index

Package BANINST1.fb_ftvtrat

Common Business interface for tax rate (FB_FTVTRAT).

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

Cursors
ftvtrat_c   Returns the record from the validation table.

ftvtrat_c 

CURSOR ftvtrat_c(
    p_code  ftvtrat.ftvtrat_code%TYPE,
    p_eff_date  ftvtrat.ftvtrat_eff_date%TYPE)
 RETURN ftvtrat%ROWTYPE;

Returns the record from the validation table.

f_code_exists 

Function f_code_exists(p_code     ftvtrat.ftvtrat_code%TYPE,
                       p_eff_date ftvtrat.ftvtrat_eff_date%TYPE)
  RETURN VARCHAR2

Determines if the code exists in the table

Parameters
p_code   User specified code which defines the tax rate.
p_eff_date   The effective date for this particular record.
p_nchg_date   The change date for this particular record.  I.E., if the    record included a termination date, the next change date would reflect the      date that the termination date was entered.  Requires a future change record.

Returns
Y if found, otherwise N

f_get_description 

Function f_get_description(p_code     ftvtrat.ftvtrat_code%TYPE,
                           p_eff_date ftvtrat.ftvtrat_eff_date%TYPE)
  RETURN VARCHAR2

Returns description for the code

Parameters
p_code   User specified code which defines the tax rate.
p_eff_date   The effective date for this particular record.
p_nchg_date   The change date for this particular record.  I.E., if the    record included a termination date, the next change date would reflect the      date that the termination date was entered.  Requires a future change record.

Returns
Description