index

Package gb_stvacyr

Standard functions and procedures for Academic Year Validation Table

Program units
f_code_exists   Determine if the code exists in the table
f_get_description   Return description for the code

Cursors
stvacyr_c  

stvacyr_c 

CURSOR stvacyr_c(
    p_code  stvacyr.stvacyr_code%TYPE)
 RETURN stvacyr%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_code stvacyr.stvacyr_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   Identifies the abbreviation for the beginning and ending periods for academic year. Referenced in the General Student, Academic History, Degree Audit Modules. Format CCYY (e.g. 1995-1996 coded 1996).

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code stvacyr.stvacyr_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_code   Identifies the abbreviation for the beginning and ending periods for academic year. Referenced in the General Student, Academic History, Degree Audit Modules. Format CCYY (e.g. 1995-1996 coded 1996).

Returns
Description