Package gb_stvsbgi

Standard functions and procedures for Source/Background Inst Validation Table

Program units

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

Cursors

CURSOR stvsbgi_c(
    p_code  stvsbgi.stvsbgi_code%TYPE)
 RETURN stvsbgi%ROWTYPE;

f_code_exists

FUNCTION f_code_exists(p_code stvsbgi.stvsbgi_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters

p_code

Source/Background institution code referenced in the Recruiting, Admissions and Academic History Modules.

Returns

Y if found, otherwise N

f_get_description

FUNCTION f_get_description(p_code stvsbgi.stvsbgi_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters

p_code

Source/Background institution code referenced in the Recruiting, Admissions and Academic History Modules.

Returns

Description