|
Package sb_stvgast This package provides the Common Business interface for the Graduation Application Status Validation Table API (sb_stvgast). |
| Program units |
| f_code_exists |
| f_get_description |
| f_is_active |
| f_is_webdisp |
| Cursors |
| stvgast_c |
stvgast_c
CURSOR stvgast_c(
p_code stvgast.stvgast_code%TYPE)
RETURN stvgast%ROWTYPE;
Returns the record from the validation table.
f_code_exists
Function f_code_exists(p_code stvgast.stvgast_code%TYPE) RETURN VARCHAR2
Determines if the code exists in the table
| Parameters |
| p_code |
Status code for the graduation application. |
| Returns |
|
Y if found, otherwise N |
f_get_description
Function f_get_description(p_code stvgast.stvgast_code%TYPE) RETURN VARCHAR2
Returns description for the code
| Parameters |
| p_code |
Status code for the graduation application. |
| Returns |
|
Description |
f_is_active
Function f_is_active(p_code stvgast.stvgast_code%TYPE) RETURN VARCHAR2
Returns the active indicator for the code
| Parameters |
| p_code |
Status code for the graduation application. |
| Returns |
|
STVGAST_ACTIVE_IND |
f_is_webdisp
Function f_is_webdisp(p_code stvgast.stvgast_code%TYPE) RETURN VARCHAR2
Returns the web indicator for the code
| Parameters |
| p_code |
Status code for the graduation application. |
| Returns |
|
STVGAST_DISP_WEB_IND |