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

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