Package gb_stvtrmt Standard functions and procedures for Term Type Validation Table |
Program units |
f_code_exists | Determine if the code exists in the table |
f_get_description | Return description for the code |
Cursors |
stvtrmt_c |
stvtrmt_c
CURSOR stvtrmt_c( p_code stvtrmt.stvtrmt_code%TYPE) RETURN stvtrmt%ROWTYPE;
f_code_exists
FUNCTION f_code_exists(p_code stvtrmt.stvtrmt_code%TYPE) RETURN VARCHAR2
Determine if the code exists in the table
Parameters |
p_code |
Type of term, eg. 2 - semester, 4 - quarter. |
Returns |
Y if found, otherwise N |
f_get_description
FUNCTION f_get_description(p_code stvtrmt.stvtrmt_code%TYPE) RETURN VARCHAR2
Return description for the code
Parameters |
p_code |
Type of term, eg. 2 - semester, 4 - quarter. |
Returns |
Description |