index

Package gb_gtvacht

Standard functions and procedures for Automated Clearing House (ACH) transaction type validation table.

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

Cursors
gtvacht_c   Returns the record from the validation table.

gtvacht_c 

CURSOR gtvacht_c(
    p_code  gtvacht.gtvacht_code%TYPE)
 RETURN gtvacht%ROWTYPE;

Returns the record from the validation table.

f_code_exists 

FUNCTION f_code_exists(p_code gtvacht.gtvacht_code%TYPE) RETURN VARCHAR2

Determines if the code exists in the table

Parameters
p_code   Automated Clearing House (ACH) transaction type codes for the Banner System.

Returns
Y if found, otherwise N

f_get_description 

FUNCTION f_get_description(p_code gtvacht.gtvacht_code%TYPE)
  RETURN VARCHAR2

Returns description for the code

Parameters
p_code   Automated Clearing House (ACH) transaction type codes for the Banner System.

Returns
Description