index

Package BANINST1.fb_invoice_tax_rules

Support subprograms for the Invoice Tax API (FB_INVOICE_TAX).

Program units
p_register_entity   Registers the attribute value pairs to the message cache for delete operations.
p_register_entity   Registers the attribute/value pairs to the message cache for create and update operations.
p_validate   Validates all the data in the record.

p_register_entity 

Procedure p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id gb_common.internal_record_id_type)

Registers the attribute value pairs to the message cache for delete operations.
This signature uses the ROWID only, for the delete operations.

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_register_entity 

Procedure p_register_entity(p_operation_type      NUMBER,
                            p_invh_code           farintx.farintx_invh_code%TYPE,
                            p_trat_code           farintx.farintx_trat_code%TYPE,
                            p_tax_amt             farintx.farintx_tax_amt%TYPE,
                            p_pay_tax_to          farintx.farintx_pay_tax_to%TYPE,
                            p_item                farintx.farintx_item%TYPE,
                            p_seq_num             farintx.farintx_seq_num%TYPE,
                            p_rucl_code           farintx.farintx_rucl_code%TYPE,
                            p_priority_num        farintx.farintx_priority_num%TYPE,
                            p_taxable_amt         farintx.farintx_taxable_amt%TYPE,
                            p_rebate_ind          farintx.farintx_rebate_ind%TYPE,
                            p_convert_tax_amt     farintx.farintx_convert_tax_amt%TYPE,
                            p_trat_descrip        farintx.farintx_trat_descrip%TYPE,
                            p_rebate_amt          farintx.farintx_rebate_amt%TYPE,
                            p_convert_rebate_amt  farintx.farintx_convert_rebate_amt%TYPE,
                            p_rebate_percent      farintx.farintx_rebate_percent%TYPE,
                            p_coas_code_rebate    farintx.farintx_coas_code_rebate%TYPE,
                            p_fund_code_rebate    farintx.farintx_fund_code_rebate%TYPE,
                            p_acct_code_ar_rebate farintx.farintx_acct_code_ar_rebate%TYPE,
                            p_user_id             farintx.farintx_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin         farintx.farintx_data_origin%TYPE,
                            p_internal_record_id  gb_common.internal_record_id_type)

Registers the attribute/value pairs to the message cache for create and update operations.
 
This signature registers all parameters.

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_invh_code   The unique identifier of an Invoice document. VARCHAR2(8) Required
p_trat_code   The tax rate code (as defined in FTVTRAT) which is identified from the tax group entered for the invoice commodity record. VARCHAR2(4) Required
p_tax_amt   The calculated amount of tax for the tax code. NUMBER(17,2) Required
p_pay_tax_to   Indicates who the tax should be paid to. Valid values are T for Taxing Authority or V for Vendor. VARCHAR2(1) Required
p_item   The unique sequence number directly associated with an invoice commodity record. NUMBER(4)
p_seq_num   The system-generated unique number associated with the accounting records item number (as entered in FARINVA_SEQ_NUM). NUMBER(4)
p_rucl_code   The code representing the tax liability rule class code. VARCHAR2(4)
p_priority_num   The priority on the Tax Rate Code (as defined in table FTVTRAT). NUMBER(2) Required
p_taxable_amt   The amount of the item that is taxable based on indicators established for the tax rate (as defined in table FTVTRAT). This amount is multiplied by the tax rate to calculate the tax amount. NUMBER(17,2)
p_rebate_ind   Indicates if a rebate will be taken based on the tax rate (as defined in table FTVTRAT). If Y, then rebate will be processed. VARCHAR2(1)
p_convert_tax_amt   The tax amount (as entered in FARINTX_TAX_AMT) is calculated against the exchange rate of the currency code to derive this amount, in base currency. NUMBER(17,2)
p_trat_descrip   The description of the tax rate code (as defined in table FTVTRAT). VARCHAR2(35)
p_rebate_amt   The amount of the calculated rebate. NUMBER(17,2)
p_convert_rebate_amt   The rebate amount (as entered in FARINTX_REBATE_AMT) is calculated against the exchange rate of the currency code to derive this amount, in base currency. NUMBER(17,2)
p_rebate_percent   The rebate percentage on the tax rate code (as defined in table FTVTRAT) used to calculate the rebate. NUMBER(6,3)
p_coas_code_rebate   The Chart of Accounts code on the tax rate (as defined in table FTVTRAT) that will be used for the processing of the rebate posting. VARCHAR2(6)
p_fund_code_rebate   The Fund code on the tax rate (as defined in table FTVTRAT) that will be used for the processing of the rebate posting. VARCHAR2(6)
p_acct_code_ar_rebate   The A/R Account code on the tax rate (as defined in table FTVTRAT) that will be used for the processing of the rebate posting. VARCHAR2(6)
p_user_id   The unique identification code of the user who created or last updated the invoice tax record. VARCHAR2(30)
p_data_origin   Identifies the origination of this invoice tax record. VARCHAR2(30)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_invh_code           farintx.farintx_invh_code%TYPE,
                     p_trat_code           farintx.farintx_trat_code%TYPE,
                     p_tax_amt             farintx.farintx_tax_amt%TYPE,
                     p_pay_tax_to          farintx.farintx_pay_tax_to%TYPE,
                     p_item                farintx.farintx_item%TYPE DEFAULT NULL,
                     p_seq_num             farintx.farintx_seq_num%TYPE DEFAULT NULL,
                     p_rucl_code           farintx.farintx_rucl_code%TYPE DEFAULT NULL,
                     p_priority_num        farintx.farintx_priority_num%TYPE,
                     p_taxable_amt         farintx.farintx_taxable_amt%TYPE DEFAULT NULL,
                     p_rebate_ind          farintx.farintx_rebate_ind%TYPE DEFAULT NULL,
                     p_convert_tax_amt     farintx.farintx_convert_tax_amt%TYPE DEFAULT NULL,
                     p_trat_descrip        farintx.farintx_trat_descrip%TYPE DEFAULT NULL,
                     p_rebate_amt          farintx.farintx_rebate_amt%TYPE DEFAULT NULL,
                     p_convert_rebate_amt  farintx.farintx_convert_rebate_amt%TYPE DEFAULT NULL,
                     p_rebate_percent      farintx.farintx_rebate_percent%TYPE DEFAULT NULL,
                     p_coas_code_rebate    farintx.farintx_coas_code_rebate%TYPE DEFAULT NULL,
                     p_fund_code_rebate    farintx.farintx_fund_code_rebate%TYPE DEFAULT NULL,
                     p_acct_code_ar_rebate farintx.farintx_acct_code_ar_rebate%TYPE DEFAULT NULL,
                     p_user_id             farintx.farintx_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin         farintx.farintx_data_origin%TYPE DEFAULT NULL)

Validates all the data in the record.

Parameters
p_invh_code   The unique identifier of an Invoice document. VARCHAR2(8) Required
p_trat_code   The tax rate code (as defined in FTVTRAT) which is identified from the tax group entered for the invoice commodity record. VARCHAR2(4) Required
p_tax_amt   The calculated amount of tax for the tax code. NUMBER(17,2) Required
p_pay_tax_to   Indicates who the tax should be paid to. Valid values are T for Taxing Authority or V for Vendor. VARCHAR2(1) Required
p_item   The unique sequence number directly associated with an invoice commodity record. NUMBER(4)
p_seq_num   The system-generated unique number associated with the accounting records item number (as entered in FARINVA_SEQ_NUM). NUMBER(4)
p_rucl_code   The code representing the tax liability rule class code. VARCHAR2(4)
p_priority_num   The priority on the Tax Rate Code (as defined in table FTVTRAT). NUMBER(2) Required
p_taxable_amt   The amount of the item that is taxable based on indicators established for the tax rate (as defined in table FTVTRAT). This amount is multiplied by the tax rate to calculate the tax amount. NUMBER(17,2)
p_rebate_ind   Indicates if a rebate will be taken based on the tax rate (as defined in table FTVTRAT). If Y, then rebate will be processed. VARCHAR2(1)
p_convert_tax_amt   The tax amount (as entered in FARINTX_TAX_AMT) is calculated against the exchange rate of the currency code to derive this amount, in base currency. NUMBER(17,2)
p_trat_descrip   The description of the tax rate code (as defined in table FTVTRAT). VARCHAR2(35)
p_rebate_amt   The amount of the calculated rebate. NUMBER(17,2)
p_convert_rebate_amt   The rebate amount (as entered in FARINTX_REBATE_AMT) is calculated against the exchange rate of the currency code to derive this amount, in base currency. NUMBER(17,2)
p_rebate_percent   The rebate percentage on the tax rate code (as defined in table FTVTRAT) used to calculate the rebate. NUMBER(6,3)
p_coas_code_rebate   The Chart of Accounts code on the tax rate (as defined in table FTVTRAT) that will be used for the processing of the rebate posting. VARCHAR2(6)
p_fund_code_rebate   The Fund code on the tax rate (as defined in table FTVTRAT) that will be used for the processing of the rebate posting. VARCHAR2(6)
p_acct_code_ar_rebate   The A/R Account code on the tax rate (as defined in table FTVTRAT) that will be used for the processing of the rebate posting. VARCHAR2(6)
p_user_id   The unique identification code of the user who created or last updated the invoice tax record. VARCHAR2(30)
p_data_origin   Identifies the origination of this invoice tax record. VARCHAR2(30)