index

Package gb_stvatyp

Standard functions and procedures for Address Type Validation Table

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

Cursors
stvatyp_c  

stvatyp_c 

CURSOR stvatyp_c(
    p_code  stvatyp.stvatyp_code%TYPE)
 RETURN stvatyp%ROWTYPE;

f_code_exists 

FUNCTION f_code_exists(p_code stvatyp.stvatyp_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters
p_code   A code used throughout all BANNER systems to identify the type of address for which information is maintained (for example; Mailing, Permanent, or Billing).

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code stvatyp.stvatyp_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters
p_code   A code used throughout all BANNER systems to identify the type of address for which information is maintained (for example; Mailing, Permanent, or Billing).

Returns
Description