index

Package sb_stvorsn

Standard functions and procedures for Orientation Session Validation Table

Program units
f_code_exists  
f_get_description  

Cursors
stvorsn_c  

stvorsn_c 

CURSOR stvorsn_c(
    p_code  stvorsn.stvorsn_code%TYPE)
 RETURN stvorsn%ROWTYPE;

f_code_exists 

Function f_code_exists(
    p_code  stvorsn.stvorsn_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   Orientation session code referenced on the Gen.       Student Form (SGASTDN) and Term Course Maint. Form 1 (SHAINST).

Returns
Y if found, otherwise N

f_get_description 

Function f_get_description(
    p_code  stvorsn.stvorsn_code%TYPE) RETURN VARCHAR2

Return description for the code

Parameters
p_code   Orientation session code referenced on the Gen.       Student Form (SGASTDN) and Term Course Maint. Form 1 (SHAINST).

Returns
Description