index

Package BANINST1.fb_req_tax_rules

Support subprograms for the Requisition Tax (fb_req_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_reqh_code          fprrqtx.fprrqtx_reqh_code%TYPE,
                            p_item               fprrqtx.fprrqtx_item%TYPE,
                            p_priority_num       fprrqtx.fprrqtx_priority_num%TYPE,
                            p_trat_code          fprrqtx.fprrqtx_trat_code%TYPE,
                            p_tax_amt            fprrqtx.fprrqtx_tax_amt%TYPE,
                            p_taxable_amt        fprrqtx.fprrqtx_taxable_amt%TYPE,
                            p_pay_tax_to         fprrqtx.fprrqtx_pay_tax_to%TYPE,
                            p_user_id            fprrqtx.fprrqtx_user_id%TYPE DEFAULT Gb_Common.f_sct_user,
                            p_data_origin        fprrqtx.fprrqtx_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 the parameters.

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_reqh_code   Requisition document code. VARCHAR2(8) Required Key
p_item   System generated item number which specifies the commodity within the requisition document. NUMBER(4) Required 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   Taxable 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   Unique identification code for the user. VARCHAR2(30) Required
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_reqh_code    fprrqtx.fprrqtx_reqh_code%TYPE,
                     p_item         fprrqtx.fprrqtx_item%TYPE,
                     p_priority_num fprrqtx.fprrqtx_priority_num%TYPE,
                     p_trat_code    fprrqtx.fprrqtx_trat_code%TYPE,
                     p_tax_amt      fprrqtx.fprrqtx_tax_amt%TYPE,
                     p_taxable_amt  fprrqtx.fprrqtx_taxable_amt%TYPE,
                     p_pay_tax_to   fprrqtx.fprrqtx_pay_tax_to%TYPE,
                     p_user_id      fprrqtx.fprrqtx_user_id%TYPE DEFAULT Gb_Common.f_sct_user,
                     p_data_origin  fprrqtx.fprrqtx_data_origin%TYPE DEFAULT NULL)

Validates all the data in the record.

Parameters
p_reqh_code   Requisition document code. VARCHAR2(8) Required Key
p_item   System generated item number which specifies the commodity within the requisition document. NUMBER(4) Required 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   Taxable 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   Unique identification code for the user. VARCHAR2(30) Required
p_data_origin   Source system that generated the data. VARCHAR2(30)