index

Package BANINST1.fb_ftvtgrp

Common Business interface for tax group (FB_FTVTGRP).

Program units
f_code_exists   Determines if the code exists in the table using effective/next change date logic
f_code_exists_eff   Determines if the code exists in the table
f_get_description   Returns current description for the code

Cursors
ftvtgrp_c   Returns the record from the validation table using effective/ next change date logic
ftvtgrp_eff_c   Returns the record from the validation table, regardless of dates

ftvtgrp_c 

CURSOR ftvtgrp_c(
    p_tgrp_code  ftvtgrp.ftvtgrp_tgrp_code%TYPE,
    p_eff_date  ftvtgrp.ftvtgrp_eff_date%TYPE)
 RETURN ftvtgrp%ROWTYPE;

Returns the record from the validation table using effective/ next change date logic

ftvtgrp_eff_c 

CURSOR ftvtgrp_eff_c(
   p_tgrp_code  ftvtgrp.ftvtgrp_tgrp_code%TYPE,
   p_eff_date   ftvtgrp.ftvtgrp_eff_date%TYPE)
 RETURN ftvtgrp%ROWTYPE;

Returns the record from the validation table, regardless of dates

f_code_exists 

Function f_code_exists(p_tgrp_code ftvtgrp.ftvtgrp_tgrp_code%TYPE,
                       p_eff_date  ftvtgrp.ftvtgrp_eff_date%TYPE,
                       p_rowid     VARCHAR2 DEFAULT NULL) RETURN VARCHAR2

Determines if the code exists in the table using effective/next change date logic

Parameters
p_tgrp_code   User specified code which defines the tax group.
p_eff_date   The effective date for this particular record.

Returns
Y if found when rowid is present; if rowid is not present YX/YY if found, active and non taxable indicator is Y/N or null, I if found but inactive, N if not found.

f_code_exists_eff 

Function f_code_exists_eff(p_tgrp_code ftvtgrp.ftvtgrp_tgrp_code%TYPE,
                           p_eff_date  ftvtgrp.ftvtgrp_eff_date%TYPE)
  RETURN VARCHAR2

Determines if the code exists in the table

Parameters
p_tgrp_code   User specified code which defines the tax group.
p_eff_date   The effective date for this particular record.

Returns
YX/YY indicator if found, current, active and non-taxable indicator is Y/N or null; I if found and inactive or not yet effective; T if found and active but terminated; N if not found.

f_get_description 

Function f_get_description(p_tgrp_code ftvtgrp.ftvtgrp_tgrp_code%TYPE,
                           p_eff_date  ftvtgrp.ftvtgrp_eff_date%TYPE)
  RETURN VARCHAR2

Returns current description for the code

Parameters
p_tgrp_code   User specified code which defines the tax group.
p_eff_date   The effective date for this particular record.

Returns
Description