index

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.