index

Package gb_stvcipc

Standard functions and procedures for CIP 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
stvcipc_c  

stvcipc_c 

CURSOR stvcipc_c(
   p_code  stvcipc.stvcipc_code%TYPE)
RETURN stvcipc%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_code stvcipc.stvcipc_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   Classification of Instructional Programs (CIP) code   assigned an area of study as referenced in the Degree Program Code (SDAPROG)    and the Basic Course Info. Form (SCACRSE) and by STVMAJR.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code stvcipc.stvcipc_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_code   Classification of Instructional Programs (CIP) code   assigned an area of study as referenced in the Degree Program Code (SDAPROG)    and the Basic Course Info. Form (SCACRSE) and by STVMAJR.

Returns
Description