index

Package gb_stvmajr

Standard functions and procedures for Major, Minor, Concentration Validation Table.
 
One of these codes can be used in any or all of the categories Major,Minor, and Concentration. Separate functions are provided to verfiy that a given code has a particular indicator set and thus may be used in that role.

Program units
f_code_exists   Determine if the major code exists in the table, regardless of the major, minor and concentration indicators.
f_major_code_exists   Determine if the code exists in the table and is flagged for use as a major code.
f_minor_code_exists   Determine if the code exists in the table and is flagged for use as a minor code.
f_concentration_code_exists   Determine if the code exists in the table and is flagged for use as a concentration code.
f_get_description   Return description for the code.

Cursors
stvmajr_c  
stvmajr_major_c  
stvmajr_minor_c  
stvmajr_concentration_c  

stvmajr_c 

cursor stvmajr_c(
   p_code  stvmajr.stvmajr_code%TYPE)
RETURN stvmajr%ROWTYPE;

stvmajr_major_c 

cursor stvmajr_major_c(
   p_code  stvmajr.stvmajr_code%TYPE)
RETURN stvmajr%ROWTYPE;

stvmajr_minor_c 

cursor stvmajr_minor_c(
   p_code  stvmajr.stvmajr_code%TYPE)
RETURN stvmajr%ROWTYPE;

stvmajr_concentration_c 

cursor stvmajr_concentration_c(
   p_code  stvmajr.stvmajr_code%TYPE)
RETURN stvmajr%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_code stvmajr.stvmajr_code%TYPE) RETURN VARCHAR2

Determine if the major code exists in the table, regardless of the major, minor and concentration indicators.

Parameters
p_code   Major code used by Catalog, Admissions, Registration, etc.

Returns
Y if found, otherwise N

f_major_code_exists 

FUNCTION f_major_code_exists(p_code stvmajr.stvmajr_code%TYPE)
  RETURN VARCHAR2

Determine if the code exists in the table and is flagged for use as a major code.

Parameters
p_code   Major code used by Catalog, Admissions, Registration, etc.

Returns
Y if found, otherwise N

f_minor_code_exists 

FUNCTION f_minor_code_exists(p_code stvmajr.stvmajr_code%TYPE)
  RETURN VARCHAR2

Determine if the code exists in the table and is flagged for use as a minor code.

Parameters
p_code   Major code used by Catalog, Admissions, Registration, etc.

Returns
Y if found, otherwise N

f_concentration_code_exists 

FUNCTION f_concentration_code_exists(p_code stvmajr.stvmajr_code%TYPE)
  RETURN VARCHAR2

Determine if the code exists in the table and is flagged for use as a concentration code.

Parameters
p_code   Major code used by Catalog, Admissions, Registration, etc.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code stvmajr.stvmajr_code%TYPE)
  RETURN VARCHAR2

Return description for the code.

Parameters
p_code   Major code used by Catalog, Admissions, Registration, etc.

Returns
Description