index

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