index

Package gb_gtvsvct

Standard functions and procedures for GTVSVCT: Validation entries for SEVIS Occupation Category Type Codes for Exchange Visitor program.

Program units
f_code_exists   Determines if the code exists in the table
f_get_description   Returns description for the code

Cursors
gtvsvct_c   Returns the record from the validation table.

gtvsvct_c 

CURSOR gtvsvct_c(
    p_code  gtvsvct.gtvsvct_code%TYPE)
 RETURN gtvsvct%ROWTYPE;

Returns the record from the validation table.

f_code_exists 

FUNCTION f_code_exists(p_code gtvsvct.gtvsvct_code%TYPE) RETURN VARCHAR2

Determines if the code exists in the table

Parameters
p_code   Exchange Visitor Occupation Category Type Code for SEVIS Reporting.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code gtvsvct.gtvsvct_code%TYPE)
  RETURN VARCHAR2

Returns description for the code

Parameters
p_code   Exchange Visitor Occupation Category Type Code for SEVIS Reporting.

Returns
Description