index

Package BANINST1.fb_po_tax_rules

Support subprograms for the PO_TAX (fb_po_tax).

Program units
p_register_entity   Register the attribute value pairs to the message cache for delete operations.
p_register_entity   Register 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)

Register 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_pohd_code          fprpotx.fprpotx_pohd_code%TYPE,
                            p_item               fprpotx.fprpotx_item%TYPE,
                            p_change_seq_num     fprpotx.fprpotx_change_seq_num%TYPE,
                            p_priority_num       fprpotx.fprpotx_priority_num%TYPE,
                            p_trat_code          fprpotx.fprpotx_trat_code%TYPE,
                            p_tax_amt            fprpotx.fprpotx_tax_amt%TYPE,
                            p_taxable_amt        fprpotx.fprpotx_taxable_amt%TYPE,
                            p_pay_tax_to         fprpotx.fprpotx_pay_tax_to%TYPE,
                            p_user_id            fprpotx.fprpotx_user_id%TYPE DEFAULT Gb_Common.f_sct_user,
                            p_data_origin        fprpotx.fprpotx_data_origin%TYPE,
                            p_internal_record_id Gb_Common.internal_record_id_type)

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

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_pohd_code   The unique identifier of a purchase order document. VARCHAR2(8) Required Key
p_item   The literal commodity or goods associated with an invoice processing record.  The unique sequence number directly associated with the item on the commodity record. NUMBER(4) Required Key
p_change_seq_num   Change sequence number for change purchase orders, which is part of the unique key. NUMBER(3) Key
p_priority_num   A number to establish the order in which taxes are to be compounded for a taxed commodity. NUMBER(2) Required Key
p_trat_code   The value of the tax rate established on form: FTVTRAT. VARCHAR2(4) Required Key
p_tax_amt   The amount of tax computed or entered for a document. NUMBER(17,2) Required
p_taxable_amt   The amount which is multiplied by the tax rate to give tax amount. NUMBER(17,2) Required
p_pay_tax_to   Indicates who should be paid taxes either the vendor or the taxing authority. VARCHAR2(1) Required
p_user_id   The unique identification code for the user. VARCHAR2(30)
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_pohd_code      fprpotx.fprpotx_pohd_code%TYPE,
                     p_item           fprpotx.fprpotx_item%TYPE,
                     p_change_seq_num fprpotx.fprpotx_change_seq_num%TYPE,
                     p_priority_num   fprpotx.fprpotx_priority_num%TYPE,
                     p_trat_code      fprpotx.fprpotx_trat_code%TYPE,
                     p_tax_amt        fprpotx.fprpotx_tax_amt%TYPE,
                     p_taxable_amt    fprpotx.fprpotx_taxable_amt%TYPE,
                     p_pay_tax_to     fprpotx.fprpotx_pay_tax_to%TYPE,
                     p_user_id        fprpotx.fprpotx_user_id%TYPE DEFAULT Gb_Common.f_sct_user,
                     p_data_origin    fprpotx.fprpotx_data_origin%TYPE DEFAULT NULL)

Validates all the data in the record.

Parameters
p_pohd_code   The unique identifier of a purchase order document. VARCHAR2(8) Required Key
p_item   The literal commodity or goods associated with an invoice processing record.  The unique sequence number directly associated with the item on the commodity record. NUMBER(4) Required Key
p_change_seq_num   Change sequence number for change purchase orders, which is part of the unique key. NUMBER(3) Key
p_priority_num   A number to establish the order in which taxes are to be compounded for a taxed commodity. NUMBER(2) Required Key
p_trat_code   The value of the tax rate established on form: FTVTRAT. VARCHAR2(4) Required Key
p_tax_amt   The amount of tax computed or entered for a document. NUMBER(17,2) Required
p_taxable_amt   The amount which is multiplied by the tax rate to give tax amount. NUMBER(17,2) Required
p_pay_tax_to   Indicates who should be paid taxes either the vendor or the taxing authority. VARCHAR2(1) Required
p_user_id   The unique identification code for the user. VARCHAR2(30)
p_data_origin   Source system that generated the data. VARCHAR2(30)