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 |