Package sb_stvcapl Standard functions and procedures for Career Planning Validation Table |
Program units |
f_code_exists |
f_get_description |
Cursors |
stvcapl_c |
stvcapl_c
CURSOR stvcapl_c( p_code stvcapl.stvcapl_code%TYPE) RETURN stvcapl%ROWTYPE;
f_code_exists
Function f_code_exists( p_code stvcapl.stvcapl_code%TYPE) RETURN VARCHAR2
Determine if the code exists in the table
Parameters |
p_code |
Career plan code referenced on the General Student Form (SGASTDN) and the Term Course Maintenance Form 1 (SHAINST). |
Returns |
Y if found, otherwise N |
f_get_description
Function f_get_description( p_code stvcapl.stvcapl_code%TYPE) RETURN VARCHAR2
Return description for the code
Parameters |
p_code |
Career plan code referenced on the General Student Form (SGASTDN) and the Term Course Maintenance Form 1 (SHAINST). |
Returns |
Description |