index

Package BANINST1.fb_ftvcrsn

Common Business interface for closed document reason (FB_FTVCRSN).


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

Cursors
ftvcrsn_c   Returns the record from the validation table.


ftvcrsn_c

CURSOR ftvcrsn_c(
    p_code  ftvcrsn.ftvcrsn_code%TYPE,
    p_start_date  ftvcrsn.ftvcrsn_start_date%TYPE)
 RETURN ftvcrsn%ROWTYPE;

Returns the record from the validation table.


f_code_exists

Function f_code_exists(p_code       ftvcrsn.ftvcrsn_code%TYPE,
                       p_start_date ftvcrsn.ftvcrsn_start_date%TYPE)
  RETURN VARCHAR2

Determines if the code exists in the table

Parameters
p_code   The reason code.
p_start_date   The start date.

Returns
Y if found, otherwise N


f_get_description

Function f_get_description(p_code       ftvcrsn.ftvcrsn_code%TYPE,
                           p_start_date ftvcrsn.ftvcrsn_start_date%TYPE)
  RETURN VARCHAR2

Returns description for the code

Parameters
p_code   The reason code.
p_start_date   The start date.

Returns
Description