Package sb_stvpwav Standard functions and procedures for Pre-Requisite Waiver Code Validation Table |
Program units |
f_code_exists |
f_get_description |
Cursors |
stvpwav_c |
stvpwav_c
CURSOR stvpwav_c( p_code stvpwav.stvpwav_code%TYPE) RETURN stvpwav%ROWTYPE;
f_code_exists
Function f_code_exists( p_code stvpwav.stvpwav_code%TYPE) RETURN VARCHAR2
Determine if the code exists in the table
Parameters |
p_code |
Prerequisite waiver code referenced on the Basic Course Information Form (SCACRSE). |
Returns |
Y if found, otherwise N |
f_get_description
Function f_get_description( p_code stvpwav.stvpwav_code%TYPE) RETURN VARCHAR2
Return description for the code
Parameters |
p_code |
Prerequisite waiver code referenced on the Basic Course Information Form (SCACRSE). |
Returns |
Description |