index

Package gb_stvdegc

Standard functions and procedures for Degree Code Validation Table

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

Cursors
stvdegc_c  

stvdegc_c 

CURSOR stvdegc_c(
    p_code  stvdegc.stvdegc_code%TYPE)
 RETURN stvdegc%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_code stvdegc.stvdegc_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   Degree code referenced in the Recruiting, Admissions, Gen. Student, Registration, Academic History and Degree Audit Modules. 000000 - Degree Not Declared.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code stvdegc.stvdegc_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_code   Degree code referenced in the Recruiting, Admissions, Gen. Student, Registration, Academic History and Degree Audit Modules. 000000 - Degree Not Declared.

Returns
Description