Package sb_stvgrst Standard functions and procedures for Graduation Status Validation Table |
Program units |
f_code_exists |
f_get_description |
Cursors |
stvgrst_c |
stvgrst_c
CURSOR stvgrst_c( p_code stvgrst.stvgrst_code%TYPE) RETURN stvgrst%ROWTYPE;
f_code_exists
Function f_code_exists( p_code stvgrst.stvgrst_code%TYPE) RETURN VARCHAR2
Determine if the code exists in the table
Parameters |
p_code |
Graduation status code. |
Returns |
Y if found, otherwise N |
f_get_description
Function f_get_description( p_code stvgrst.stvgrst_code%TYPE) RETURN VARCHAR2
Return description for the code
Parameters |
p_code |
Graduation status code. |
Returns |
Description |