Package tb_ttvsrce Standard functions and procedures for the Billing Detail Source Validation Table. |
Program units |
f_code_exists | Determine if the code exists in the table |
f_get_description | Return the description for the code |
f_entry_allowed | Return input or data entry indicator for the code |
Cursors |
ttvsrce_c |
ttvsrce_c
CURSOR ttvsrce_c( p_code ttvsrce.ttvsrce_code%TYPE) RETURN ttvsrce%ROWTYPE;
f_code_exists
Function f_code_exists(p_code ttvsrce.ttvsrce_code%TYPE) RETURN VARCHAR2
Determine if the code exists in the table
Parameters |
p_code |
Charge/Payment Source Code. VARCHAR2(1) Required |
Returns |
Y if found, otherwise N |
f_get_description
Function f_get_description(p_code ttvsrce.ttvsrce_code%TYPE) RETURN VARCHAR2
Return the description for the code
Parameters |
p_code |
Charge/Payment Source Code. VARCHAR2(1) Required |
Returns |
Description |
f_entry_allowed
Function f_entry_allowed(p_code ttvsrce.ttvsrce_code%TYPE) RETURN VARCHAR2
Return input or data entry indicator for the code
Parameters |
p_code |
Charge/Payment Source Code. VARCHAR2(1) Required |
Returns |
Data entry allowed (Y or N) for the Source Code. Return N if the code does not exist. |