The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT zx_transaction_s.nextval
INTO x_real_value
FROM DUAL;
SELECT zx_transaction_lines_s.nextval
INTO x_real_value
FROM DUAL;
SELECT zx_sim_trx_dists_s.nextval
INTO x_real_value
FROM DUAL;
select batch_source_id
into x_user_key_id
from ra_batch_sources_all
where org_id = l_num_id
and name = l_varchar2_id;
select organization_id
into x_user_key_id
from hr_all_organization_units
where business_group_id = l_num_id
and name = l_varchar2_id;
select application_id
into x_user_key_id
from fnd_application
where application_short_name = l_varchar2_id;
select set_of_books_id
into x_user_key_id
from gl_sets_of_books
where name = l_varchar2_id;
select xle_ep.legal_entity_id
into x_user_key_id
from xle_entity_profiles xle_ep,
hz_parties hz_pty
where xle_ep.party_id = hz_pty.party_id
and upper(xle_ep.name) = l_name
and hz_pty.party_number = l_party_number;
SELECT upper(party_source_table)
INTO l_table_name
FROM zx_party_types
WHERE party_type_code = l_party_type;
select vendor_id
into x_user_key_id
from ap_suppliers
where vendor_name = l_varchar2_id;
Select party_id
into x_user_key_id
from hz_parties
where party_number = l_varchar2_id;
select party_id
into x_user_key_id
from hz_parties
where party_name = l_varchar2_id;
select ship_to_location_id
into x_user_key_id
from hr_locations
where location_code = l_varchar2_id
and business_group_id = l_num_id;
select ship_to_location_id
into x_user_key_id
from hr_locations
where location_code = l_varchar2_id
and business_group_id is null;
select location_id
into x_user_key_id
from hz_locations
where ltrim(rtrim(upper(address1))) = ltrim(rtrim(upper(l_varchar2_id)))
and upper(city) = upper(l_varchar2_id1);
select location_id
into x_user_key_id
from hz_locations
where short_description = l_varchar2_id;
select location_id
into x_user_key_id
from hr_locations
where location_code = l_varchar2_id
and business_group_id = l_num_id;
select location_id
into x_user_key_id
from hr_locations
where location_code = l_varchar2_id
and business_group_id is null;
select chart_of_accounts_id
into l_chrt_acct_id
from gl_sets_of_books
where set_of_books_id = g_suite_rec_tbl.ledger_id(1);
select doc_sequence_id
into x_user_key_id
from FND_DOCUMENT_SEQUENCES
where name = l_varchar2_id;
select upper(party_source_table)
into l_table_name
from zx_party_types
where party_type_code = l_party_type;
select party_site_id
into x_user_key_id
from hz_party_sites
where party_site_number = l_varchar2_id ;
select party_site_id
into x_user_key_id
from po_vendor_sites
where vendor_site_code = l_varchar2_id;
select location_id
into l_ship_from_location_id
from hz_party_sites
where party_site_id=x_user_key_id;
select vendor_site_id
into x_user_key_id
from po_vendor_sites_all
where vendor_site_code = l_varchar2_id;
| PROCEDURE insert_into_rev_dist_lines_gt : Logic to Insert into Global |
| Temporary Table |
| ZX_REVERSE_DIST_GT |
* ===========================================================================*/
PROCEDURE insert_into_rev_dist_lines_gt(p_transaction_id IN NUMBER) IS
l_int_org_id NUMBER;
INSERT INTO ZX_REVERSE_DIST_GT
( internal_organization_id,
reversing_appln_id,
reversing_entity_code,
reversing_evnt_cls_code,
reversing_trx_level_type,
reversing_trx_id,
reversing_trx_line_id,
reversing_trx_line_dist_id,
reversing_tax_line_id,
reversed_appln_id,
reversed_entity_code,
reversed_evnt_cls_code,
reversed_trx_level_type,
reversed_trx_id,
reversed_trx_line_id,
reversed_trx_line_dist_id,
FIRST_PTY_ORG_ID ,
reversed_tax_line_id )
SELECT g_transaction_rec.internal_organization_id,
application_id,
entity_code,
event_class_code,
'DISTRIBUTION',
trx_id,
trx_line_id,
trx_line_dist_id,
tax_line_id,
application_id,
entity_code,
event_class_code,
'DISTRIBUTION',
trx_id,
trx_line_id,
trx_line_dist_id,
g_transaction_rec.first_pty_org_id,
tax_line_id
FROM zx_rec_nrec_dist
WHERE trx_id = p_transaction_id;
END insert_into_rev_dist_lines_gt;
SELECT
SHIP_TO_PARTY_TYPE ,
SHIP_FROM_PARTY_TYPE,
POA_PARTY_TYPE,
POO_PARTY_TYPE,
PAYING_PARTY_TYPE,
OWN_HQ_PARTY_TYPE,
TRAD_HQ_PARTY_TYPE,
POI_PARTY_TYPE,
POD_PARTY_TYPE,
BILL_TO_PARTY_TYPE,
BILL_FROM_PARTY_TYPE,
TTL_TRNS_PARTY_TYPE,
MERCHANT_PARTY_TYPE,
SHIP_TO_PTY_SITE_TYPE,
SHIP_FROM_PTY_SITE_TYPE,
POA_PTY_SITE_TYPE,
POO_PTY_SITE_TYPE,
PAYING_PTY_SITE_TYPE,
OWN_HQ_PTY_SITE_TYPE,
TRAD_HQ_PTY_SITE_TYPE,
POI_PTY_SITE_TYPE,
POD_PTY_SITE_TYPE,
BILL_TO_PTY_SITE_TYPE,
BILL_FROM_PTY_SITE_TYPE,
TTL_TRNS_PTY_SITE_TYPE,
PROD_FAMILY_GRP_CODE
INTO
g_party_rec.SHIP_TO_PARTY_TYPE,
g_party_rec.SHIP_FROM_PARTY_TYPE,
g_party_rec.POA_PARTY_TYPE,
g_party_rec.POO_PARTY_TYPE,
g_party_rec.PAYING_PARTY_TYPE,
g_party_rec.OWN_HQ_PARTY_TYPE,
g_party_rec.TRAD_HQ_PARTY_TYPE,
g_party_rec.POI_PARTY_TYPE,
g_party_rec.POD_PARTY_TYPE,
g_party_rec.BILL_TO_PARTY_TYPE,
g_party_rec.BILL_FROM_PARTY_TYPE,
g_party_rec.TTL_TRNS_PARTY_TYPE,
g_party_rec.MERCHANT_PARTY_TYPE,
g_party_rec.SHIP_TO_PTY_SITE_TYPE,
g_party_rec.SHIP_FROM_PTY_SITE_TYPE,
g_party_rec.POA_PTY_SITE_TYPE,
g_party_rec.POO_PTY_SITE_TYPE,
g_party_rec.PAYING_PTY_SITE_TYPE,
g_party_rec.OWN_HQ_PTY_SITE_TYPE,
g_party_rec.TRAD_HQ_PTY_SITE_TYPE,
g_party_rec.POI_PTY_SITE_TYPE,
g_party_rec.POD_PTY_SITE_TYPE,
g_party_rec.BILL_TO_PTY_SITE_TYPE,
g_party_rec.BILL_FROM_PTY_SITE_TYPE,
g_party_rec.TTL_TRNS_PTY_SITE_TYPE,
g_party_rec.PROD_FAMILY_GRP_CODE
FROM
zx_evnt_cls_mappings
WHERE
application_id = g_suite_rec_tbl.application_id(p_header_row)
and entity_code = g_suite_rec_tbl.entity_code(p_header_row)
and event_class_code = g_suite_rec_tbl.event_class_code(p_header_row) ;
| PROCEDURE insert_data_trx_headers_gt : Inserts a row in zx_trx_headers_gt|
* ================================================================================*/
PROCEDURE insert_data_trx_headers_gt(p_row_id IN NUMBER)
IS
BEGIN
write_message('Inserting into zx_trx_headers_gt rec_tbl_row:'||to_char(p_row_id));
INSERT INTO zx_trx_headers_gt(
INTERNAL_ORGANIZATION_ID ,
INTERNAL_ORG_LOCATION_ID ,
APPLICATION_ID ,
ENTITY_CODE ,
EVENT_CLASS_CODE ,
EVENT_TYPE_CODE ,
TRX_ID ,
TRX_DATE ,
TRX_DOC_REVISION ,
LEDGER_ID ,
TRX_CURRENCY_CODE ,
CURRENCY_CONVERSION_DATE ,
CURRENCY_CONVERSION_RATE ,
CURRENCY_CONVERSION_TYPE ,
MINIMUM_ACCOUNTABLE_UNIT ,
PRECISION ,
LEGAL_ENTITY_ID ,
ROUNDING_SHIP_TO_PARTY_ID ,
ROUNDING_SHIP_FROM_PARTY_ID ,
ROUNDING_BILL_TO_PARTY_ID ,
ROUNDING_BILL_FROM_PARTY_ID ,
RNDG_SHIP_TO_PARTY_SITE_ID ,
RNDG_SHIP_FROM_PARTY_SITE_ID ,
RNDG_BILL_TO_PARTY_SITE_ID ,
RNDG_BILL_FROM_PARTY_SITE_ID ,
ESTABLISHMENT_ID ,
RECEIVABLES_TRX_TYPE_ID ,
RELATED_DOC_APPLICATION_ID ,
RELATED_DOC_ENTITY_CODE ,
RELATED_DOC_EVENT_CLASS_CODE ,
RELATED_DOC_TRX_ID ,
RELATED_DOC_NUMBER ,
RELATED_DOC_DATE ,
DEFAULT_TAXATION_COUNTRY ,
QUOTE_FLAG ,
CTRL_TOTAL_HDR_TX_AMT ,
TRX_NUMBER ,
TRX_DESCRIPTION ,
TRX_COMMUNICATED_DATE ,
BATCH_SOURCE_ID ,
BATCH_SOURCE_NAME ,
DOC_SEQ_ID ,
DOC_SEQ_NAME ,
DOC_SEQ_VALUE ,
TRX_DUE_DATE ,
TRX_TYPE_DESCRIPTION ,
DOCUMENT_SUB_TYPE ,
SUPPLIER_TAX_INVOICE_NUMBER ,
SUPPLIER_TAX_INVOICE_DATE ,
SUPPLIER_EXCHANGE_RATE ,
TAX_INVOICE_DATE ,
TAX_INVOICE_NUMBER ,
FIRST_PTY_ORG_ID ,
TAX_EVENT_CLASS_CODE ,
TAX_EVENT_TYPE_CODE ,
DOC_EVENT_STATUS ,
RDNG_SHIP_TO_PTY_TX_PROF_ID ,
RDNG_SHIP_FROM_PTY_TX_PROF_ID ,
RDNG_BILL_TO_PTY_TX_PROF_ID ,
RDNG_BILL_FROM_PTY_TX_PROF_ID ,
RDNG_SHIP_TO_PTY_TX_P_ST_ID ,
RDNG_SHIP_FROM_PTY_TX_P_ST_ID ,
RDNG_BILL_TO_PTY_TX_P_ST_ID ,
RDNG_BILL_FROM_PTY_TX_P_ST_ID ,
VALIDATION_CHECK_FLAG ,
PORT_OF_ENTRY_CODE )
VALUES
(
g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(p_row_id) ,
g_suite_rec_tbl.INTERNAL_ORG_LOCATION_ID(p_row_id) ,
g_suite_rec_tbl.APPLICATION_ID(p_row_id) ,
g_suite_rec_tbl.ENTITY_CODE(p_row_id) ,
g_suite_rec_tbl.EVENT_CLASS_CODE(p_row_id) ,
g_suite_rec_tbl.EVENT_TYPE_CODE(p_row_id) ,
g_suite_rec_tbl.TRX_ID(p_row_id) ,
g_suite_rec_tbl.TRX_DATE(p_row_id) ,
g_suite_rec_tbl.TRX_DOC_REVISION(p_row_id) ,
g_suite_rec_tbl.LEDGER_ID(p_row_id) ,
g_suite_rec_tbl.TRX_CURRENCY_CODE(p_row_id) ,
g_suite_rec_tbl.CURRENCY_CONVERSION_DATE(p_row_id) ,
g_suite_rec_tbl.CURRENCY_CONVERSION_RATE(p_row_id) ,
g_suite_rec_tbl.CURRENCY_CONVERSION_TYPE(p_row_id) ,
g_suite_rec_tbl.MINIMUM_ACCOUNTABLE_UNIT(p_row_id) ,
g_suite_rec_tbl.PRECISION(p_row_id) ,
g_suite_rec_tbl.LEGAL_ENTITY_ID(p_row_id) ,
g_suite_rec_tbl.ROUNDING_SHIP_TO_PARTY_ID(p_row_id) ,
g_suite_rec_tbl.ROUNDING_SHIP_FROM_PARTY_ID(p_row_id) ,
g_suite_rec_tbl.ROUNDING_BILL_TO_PARTY_ID(p_row_id) ,
g_suite_rec_tbl.ROUNDING_BILL_FROM_PARTY_ID(p_row_id) ,
g_suite_rec_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(p_row_id) ,
g_suite_rec_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID(p_row_id) ,
g_suite_rec_tbl.RNDG_BILL_TO_PARTY_SITE_ID(p_row_id) ,
g_suite_rec_tbl.RNDG_BILL_FROM_PARTY_SITE_ID(p_row_id) ,
g_suite_rec_tbl.ESTABLISHMENT_ID(p_row_id) ,
g_suite_rec_tbl.RECEIVABLES_TRX_TYPE_ID(p_row_id) ,
g_suite_rec_tbl.RELATED_DOC_APPLICATION_ID(p_row_id) ,
g_suite_rec_tbl.RELATED_DOC_ENTITY_CODE(p_row_id) ,
g_suite_rec_tbl.RELATED_DOC_EVENT_CLASS_CODE(p_row_id) ,
g_suite_rec_tbl.RELATED_DOC_TRX_ID(p_row_id) ,
g_suite_rec_tbl.RELATED_DOC_NUMBER(p_row_id) ,
g_suite_rec_tbl.RELATED_DOC_DATE(p_row_id) ,
g_suite_rec_tbl.DEFAULT_TAXATION_COUNTRY(p_row_id) ,
g_suite_rec_tbl.QUOTE_FLAG(p_row_id) ,
g_suite_rec_tbl.CTRL_TOTAL_HDR_TX_AMT(p_row_id) ,
g_suite_rec_tbl.TRX_NUMBER(p_row_id) ,
g_suite_rec_tbl.TRX_DESCRIPTION(p_row_id) ,
g_suite_rec_tbl.TRX_COMMUNICATED_DATE(p_row_id) ,
g_suite_rec_tbl.BATCH_SOURCE_ID(p_row_id) ,
g_suite_rec_tbl.BATCH_SOURCE_NAME(p_row_id) ,
g_suite_rec_tbl.DOC_SEQ_ID(p_row_id) ,
g_suite_rec_tbl.DOC_SEQ_NAME(p_row_id) ,
g_suite_rec_tbl.DOC_SEQ_VALUE(p_row_id) ,
g_suite_rec_tbl.TRX_DUE_DATE(p_row_id) ,
g_suite_rec_tbl.TRX_TYPE_DESCRIPTION(p_row_id) ,
g_suite_rec_tbl.DOCUMENT_SUB_TYPE(p_row_id) ,
g_suite_rec_tbl.SUPPLIER_TAX_INVOICE_NUMBER(p_row_id) ,
g_suite_rec_tbl.SUPPLIER_TAX_INVOICE_DATE(p_row_id) ,
g_suite_rec_tbl.SUPPLIER_EXCHANGE_RATE(p_row_id) ,
g_suite_rec_tbl.TAX_INVOICE_DATE(p_row_id) ,
g_suite_rec_tbl.TAX_INVOICE_NUMBER(p_row_id) ,
g_suite_rec_tbl.FIRST_PTY_ORG_ID(p_row_id) ,
g_suite_rec_tbl.TAX_EVENT_CLASS_CODE(p_row_id) ,
g_suite_rec_tbl.TAX_EVENT_TYPE_CODE(p_row_id) ,
g_suite_rec_tbl.DOC_EVENT_STATUS(p_row_id) ,
g_suite_rec_tbl.RDNG_SHIP_TO_PTY_TX_PROF_ID(p_row_id) ,
g_suite_rec_tbl.RDNG_SHIP_FROM_PTY_TX_PROF_ID(p_row_id) ,
g_suite_rec_tbl.RDNG_BILL_TO_PTY_TX_PROF_ID(p_row_id) ,
g_suite_rec_tbl.RDNG_BILL_FROM_PTY_TX_PROF_ID(p_row_id) ,
g_suite_rec_tbl.RDNG_SHIP_TO_PTY_TX_P_ST_ID(p_row_id) ,
g_suite_rec_tbl.RDNG_SHIP_FROM_PTY_TX_P_ST_ID(p_row_id) ,
g_suite_rec_tbl.RDNG_BILL_TO_PTY_TX_P_ST_ID(p_row_id) ,
g_suite_rec_tbl.RDNG_BILL_FROM_PTY_TX_P_ST_ID(p_row_id) ,
g_suite_rec_tbl.VALIDATION_CHECK_FLAG(p_row_id) ,
g_suite_rec_tbl.PORT_OF_ENTRY_CODE(p_row_id) );
END insert_data_trx_headers_gt;
| PROCEDURE insert_data_trx_lines_gt : Inserts data for lines in |
| ZX_TRANSACTION_LINES_GT. Some values |
| are obtained from the Header row |
* ============================================================================*/
PROCEDURE insert_data_trx_lines_gt(p_header_row NUMBER,
p_starting_line_row NUMBER,
p_ending_line_row NUMBER)
IS
l_counter NUMBER;
write_message('Inserting into ZX_TRANSACTION_LINES_GT rec_tbl_row:'||to_char(i));
INSERT INTO ZX_TRANSACTION_LINES_GT(
APPLICATION_ID ,
ENTITY_CODE ,
EVENT_CLASS_CODE ,
TRX_ID ,
TRX_LEVEL_TYPE ,
TRX_LINE_ID ,
LINE_LEVEL_ACTION ,
LINE_CLASS ,
TRX_SHIPPING_DATE ,
TRX_RECEIPT_DATE ,
TRX_LINE_TYPE ,
TRX_LINE_DATE ,
TRX_BUSINESS_CATEGORY ,
LINE_INTENDED_USE ,
USER_DEFINED_FISC_CLASS ,
LINE_AMT ,
TRX_LINE_QUANTITY ,
UNIT_PRICE ,
EXEMPT_CERTIFICATE_NUMBER ,
EXEMPT_REASON ,
CASH_DISCOUNT ,
VOLUME_DISCOUNT ,
TRADING_DISCOUNT ,
TRANSFER_CHARGE ,
TRANSPORTATION_CHARGE ,
INSURANCE_CHARGE ,
OTHER_CHARGE ,
PRODUCT_ID ,
PRODUCT_FISC_CLASSIFICATION ,
PRODUCT_ORG_ID ,
UOM_CODE ,
PRODUCT_TYPE ,
PRODUCT_CODE ,
PRODUCT_CATEGORY ,
TRX_SIC_CODE ,
FOB_POINT ,
SHIP_TO_PARTY_ID ,
SHIP_FROM_PARTY_ID ,
POA_PARTY_ID ,
POO_PARTY_ID ,
BILL_TO_PARTY_ID ,
BILL_FROM_PARTY_ID ,
MERCHANT_PARTY_ID ,
SHIP_TO_PARTY_SITE_ID ,
SHIP_FROM_PARTY_SITE_ID ,
POA_PARTY_SITE_ID ,
POO_PARTY_SITE_ID ,
BILL_TO_PARTY_SITE_ID ,
BILL_FROM_PARTY_SITE_ID ,
SHIP_TO_LOCATION_ID ,
SHIP_FROM_LOCATION_ID ,
POA_LOCATION_ID ,
POO_LOCATION_ID ,
BILL_TO_LOCATION_ID ,
BILL_FROM_LOCATION_ID ,
ACCOUNT_CCID ,
ACCOUNT_STRING ,
MERCHANT_PARTY_COUNTRY ,
REF_DOC_APPLICATION_ID ,
REF_DOC_ENTITY_CODE ,
REF_DOC_EVENT_CLASS_CODE ,
REF_DOC_TRX_ID ,
REF_DOC_LINE_ID ,
REF_DOC_LINE_QUANTITY ,
APPLIED_FROM_APPLICATION_ID ,
APPLIED_FROM_ENTITY_CODE ,
APPLIED_FROM_EVENT_CLASS_CODE ,
APPLIED_FROM_TRX_ID ,
APPLIED_FROM_LINE_ID ,
ADJUSTED_DOC_APPLICATION_ID ,
ADJUSTED_DOC_ENTITY_CODE ,
ADJUSTED_DOC_EVENT_CLASS_CODE ,
ADJUSTED_DOC_TRX_ID ,
ADJUSTED_DOC_LINE_ID ,
ADJUSTED_DOC_NUMBER ,
ADJUSTED_DOC_DATE ,
APPLIED_TO_APPLICATION_ID ,
APPLIED_TO_ENTITY_CODE ,
APPLIED_TO_EVENT_CLASS_CODE ,
APPLIED_TO_TRX_ID ,
APPLIED_TO_TRX_LINE_ID ,
TRX_ID_LEVEL2 ,
TRX_ID_LEVEL3 ,
TRX_ID_LEVEL4 ,
TRX_ID_LEVEL5 ,
TRX_ID_LEVEL6 ,
TRX_LINE_NUMBER ,
TRX_LINE_DESCRIPTION ,
PRODUCT_DESCRIPTION ,
TRX_WAYBILL_NUMBER ,
TRX_LINE_GL_DATE ,
MERCHANT_PARTY_NAME ,
MERCHANT_PARTY_DOCUMENT_NUMBER ,
MERCHANT_PARTY_REFERENCE ,
MERCHANT_PARTY_TAXPAYER_ID ,
MERCHANT_PARTY_TAX_REG_NUMBER ,
PAYING_PARTY_ID ,
OWN_HQ_PARTY_ID ,
TRADING_HQ_PARTY_ID ,
POI_PARTY_ID ,
POD_PARTY_ID ,
TITLE_TRANSFER_PARTY_ID ,
PAYING_PARTY_SITE_ID ,
OWN_HQ_PARTY_SITE_ID ,
TRADING_HQ_PARTY_SITE_ID ,
POI_PARTY_SITE_ID ,
POD_PARTY_SITE_ID ,
TITLE_TRANSFER_PARTY_SITE_ID ,
PAYING_LOCATION_ID ,
OWN_HQ_LOCATION_ID ,
TRADING_HQ_LOCATION_ID ,
POC_LOCATION_ID ,
POI_LOCATION_ID ,
POD_LOCATION_ID ,
TITLE_TRANSFER_LOCATION_ID ,
ASSESSABLE_VALUE ,
ASSET_FLAG ,
ASSET_NUMBER ,
ASSET_ACCUM_DEPRECIATION ,
ASSET_TYPE ,
ASSET_COST ,
SHIP_TO_PARTY_TAX_PROF_ID ,
SHIP_FROM_PARTY_TAX_PROF_ID ,
POA_PARTY_TAX_PROF_ID ,
POO_PARTY_TAX_PROF_ID ,
PAYING_PARTY_TAX_PROF_ID ,
OWN_HQ_PARTY_TAX_PROF_ID ,
TRADING_HQ_PARTY_TAX_PROF_ID ,
POI_PARTY_TAX_PROF_ID ,
POD_PARTY_TAX_PROF_ID ,
BILL_TO_PARTY_TAX_PROF_ID ,
BILL_FROM_PARTY_TAX_PROF_ID ,
TITLE_TRANS_PARTY_TAX_PROF_ID ,
SHIP_TO_SITE_TAX_PROF_ID ,
SHIP_FROM_SITE_TAX_PROF_ID ,
POA_SITE_TAX_PROF_ID ,
POO_SITE_TAX_PROF_ID ,
PAYING_SITE_TAX_PROF_ID ,
OWN_HQ_SITE_TAX_PROF_ID ,
TRADING_HQ_SITE_TAX_PROF_ID ,
POI_SITE_TAX_PROF_ID ,
POD_SITE_TAX_PROF_ID ,
BILL_TO_SITE_TAX_PROF_ID ,
BILL_FROM_SITE_TAX_PROF_ID ,
TITLE_TRANS_SITE_TAX_PROF_ID ,
MERCHANT_PARTY_TAX_PROF_ID ,
HQ_ESTB_PARTY_TAX_PROF_ID ,
LINE_AMT_INCLUDES_TAX_FLAG ,
HISTORICAL_FLAG ,
CTRL_HDR_TX_APPL_FLAG ,
CTRL_TOTAL_LINE_TX_AMT
)
VALUES
(
g_suite_rec_tbl.APPLICATION_ID(p_header_row) ,
g_suite_rec_tbl.ENTITY_CODE(p_header_row) ,
g_suite_rec_tbl.EVENT_CLASS_CODE(p_header_row) ,
g_suite_rec_tbl.TRX_ID(p_header_row) ,
g_suite_rec_tbl.TRX_LEVEL_TYPE(p_header_row) ,
g_suite_rec_tbl.TRX_LINE_ID(i) ,
g_suite_rec_tbl.LINE_LEVEL_ACTION(i) ,
g_suite_rec_tbl.LINE_CLASS(i) ,
g_suite_rec_tbl.TRX_SHIPPING_DATE(i) ,
g_suite_rec_tbl.TRX_RECEIPT_DATE(i) ,
g_suite_rec_tbl.TRX_LINE_TYPE(i) ,
g_suite_rec_tbl.TRX_LINE_DATE(i) ,
g_suite_rec_tbl.TRX_BUSINESS_CATEGORY(i) ,
g_suite_rec_tbl.LINE_INTENDED_USE(i) ,
g_suite_rec_tbl.USER_DEFINED_FISC_CLASS(i) ,
g_suite_rec_tbl.LINE_AMT(i) ,
g_suite_rec_tbl.TRX_LINE_QUANTITY(i) ,
g_suite_rec_tbl.UNIT_PRICE(i) ,
g_suite_rec_tbl.EXEMPT_CERTIFICATE_NUMBER(i) ,
g_suite_rec_tbl.EXEMPT_REASON(i) ,
g_suite_rec_tbl.CASH_DISCOUNT(i) ,
g_suite_rec_tbl.VOLUME_DISCOUNT(i) ,
g_suite_rec_tbl.TRADING_DISCOUNT(i) ,
g_suite_rec_tbl.TRANSFER_CHARGE(i) ,
g_suite_rec_tbl.TRANSPORTATION_CHARGE(i) ,
g_suite_rec_tbl.INSURANCE_CHARGE(i) ,
g_suite_rec_tbl.OTHER_CHARGE(i) ,
g_suite_rec_tbl.PRODUCT_ID(i) ,
g_suite_rec_tbl.PRODUCT_FISC_CLASSIFICATION(i) ,
g_suite_rec_tbl.PRODUCT_ORG_ID(i) ,
g_suite_rec_tbl.UOM_CODE(i) ,
g_suite_rec_tbl.PRODUCT_TYPE(i) ,
g_suite_rec_tbl.PRODUCT_CODE(i) ,
g_suite_rec_tbl.PRODUCT_CATEGORY(i) ,
g_suite_rec_tbl.TRX_SIC_CODE(i) ,
g_suite_rec_tbl.FOB_POINT(i) ,
g_suite_rec_tbl.SHIP_TO_PARTY_ID(i) ,
g_suite_rec_tbl.SHIP_FROM_PARTY_ID(i) ,
g_suite_rec_tbl.POA_PARTY_ID(i) ,
g_suite_rec_tbl.POO_PARTY_ID(i) ,
g_suite_rec_tbl.BILL_TO_PARTY_ID(i) ,
g_suite_rec_tbl.BILL_FROM_PARTY_ID(i) ,
g_suite_rec_tbl.MERCHANT_PARTY_ID(i) ,
g_suite_rec_tbl.SHIP_TO_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.SHIP_FROM_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.POA_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.POO_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.BILL_TO_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.BILL_FROM_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.SHIP_TO_LOCATION_ID(i) ,
--g_suite_rec_tbl.SHIP_FROM_LOCATION_ID(i) ,
l_ship_from_location_id,
g_suite_rec_tbl.POA_LOCATION_ID(i) ,
g_suite_rec_tbl.POO_LOCATION_ID(i) ,
g_suite_rec_tbl.BILL_TO_LOCATION_ID(i) ,
g_suite_rec_tbl.BILL_FROM_LOCATION_ID(i) ,
g_suite_rec_tbl.ACCOUNT_CCID(i) ,
g_suite_rec_tbl.ACCOUNT_STRING(i) ,
g_suite_rec_tbl.MERCHANT_PARTY_COUNTRY(i) ,
g_suite_rec_tbl.REF_DOC_APPLICATION_ID(i) ,
g_suite_rec_tbl.REF_DOC_ENTITY_CODE(i) ,
g_suite_rec_tbl.REF_DOC_EVENT_CLASS_CODE(i) ,
g_suite_rec_tbl.REF_DOC_TRX_ID(i) ,
g_suite_rec_tbl.REF_DOC_LINE_ID(i) ,
g_suite_rec_tbl.REF_DOC_LINE_QUANTITY(i) ,
g_suite_rec_tbl.APPLIED_FROM_APPLICATION_ID(i) ,
g_suite_rec_tbl.APPLIED_FROM_ENTITY_CODE(i) ,
g_suite_rec_tbl.APPLIED_FROM_EVENT_CLASS_CODE(i) ,
g_suite_rec_tbl.APPLIED_FROM_TRX_ID(i) ,
g_suite_rec_tbl.APPLIED_FROM_LINE_ID(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_APPLICATION_ID(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_ENTITY_CODE(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_TRX_ID(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_LINE_ID(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_NUMBER(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_DATE(i) ,
g_suite_rec_tbl.APPLIED_TO_APPLICATION_ID(i) ,
g_suite_rec_tbl.APPLIED_TO_ENTITY_CODE(i) ,
g_suite_rec_tbl.APPLIED_TO_EVENT_CLASS_CODE(i) ,
g_suite_rec_tbl.APPLIED_TO_TRX_ID(i) ,
g_suite_rec_tbl.APPLIED_TO_TRX_LINE_ID(i) ,
g_suite_rec_tbl.TRX_ID_LEVEL2(i) ,
g_suite_rec_tbl.TRX_ID_LEVEL3(i) ,
g_suite_rec_tbl.TRX_ID_LEVEL4(i) ,
g_suite_rec_tbl.TRX_ID_LEVEL5(i) ,
g_suite_rec_tbl.TRX_ID_LEVEL6(i) ,
g_suite_rec_tbl.TRX_LINE_NUMBER(i) ,
g_suite_rec_tbl.TRX_LINE_DESCRIPTION(i) ,
g_suite_rec_tbl.PRODUCT_DESCRIPTION(i) ,
g_suite_rec_tbl.TRX_WAYBILL_NUMBER(i) ,
g_suite_rec_tbl.TRX_LINE_GL_DATE(i) ,
g_suite_rec_tbl.MERCHANT_PARTY_NAME(i) ,
g_suite_rec_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER(i) ,
g_suite_rec_tbl.MERCHANT_PARTY_REFERENCE(i) ,
g_suite_rec_tbl.MERCHANT_PARTY_TAXPAYER_ID(i) ,
g_suite_rec_tbl.MERCHANT_PARTY_TAX_REG_NUMBER(i) ,
g_suite_rec_tbl.PAYING_PARTY_ID(i) ,
g_suite_rec_tbl.OWN_HQ_PARTY_ID(i) ,
g_suite_rec_tbl.TRADING_HQ_PARTY_ID(i) ,
g_suite_rec_tbl.POI_PARTY_ID(i) ,
g_suite_rec_tbl.POD_PARTY_ID(i) ,
g_suite_rec_tbl.TITLE_TRANSFER_PARTY_ID(i) ,
g_suite_rec_tbl.PAYING_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.OWN_HQ_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.TRADING_HQ_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.POI_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.POD_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.TITLE_TRANSFER_PARTY_SITE_ID(i) ,
g_suite_rec_tbl.PAYING_LOCATION_ID(i) ,
g_suite_rec_tbl.OWN_HQ_LOCATION_ID(i) ,
g_suite_rec_tbl.TRADING_HQ_LOCATION_ID(i) ,
g_suite_rec_tbl.POC_LOCATION_ID(i) ,
g_suite_rec_tbl.POI_LOCATION_ID(i) ,
g_suite_rec_tbl.POD_LOCATION_ID(i) ,
g_suite_rec_tbl.TITLE_TRANSFER_LOCATION_ID(i) ,
g_suite_rec_tbl.ASSESSABLE_VALUE(i) ,
g_suite_rec_tbl.ASSET_FLAG(i) ,
g_suite_rec_tbl.ASSET_NUMBER(i) ,
g_suite_rec_tbl.ASSET_ACCUM_DEPRECIATION(i) ,
g_suite_rec_tbl.ASSET_TYPE(i) ,
g_suite_rec_tbl.ASSET_COST(i) ,
g_suite_rec_tbl.SHIP_TO_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.SHIP_FROM_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.POA_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.POO_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.PAYING_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.OWN_HQ_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.TRADING_HQ_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.POI_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.POD_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.BILL_TO_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.BILL_FROM_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.TITLE_TRANS_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.SHIP_TO_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.SHIP_FROM_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.POA_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.POO_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.PAYING_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.OWN_HQ_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.TRADING_HQ_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.POI_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.POD_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.BILL_TO_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.BILL_FROM_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.TITLE_TRANS_SITE_TAX_PROF_ID(i) ,
g_suite_rec_tbl.MERCHANT_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.HQ_ESTB_PARTY_TAX_PROF_ID(i) ,
g_suite_rec_tbl.LINE_AMT_INCLUDES_TAX_FLAG(i) ,
g_suite_rec_tbl.HISTORICAL_FLAG(i) ,
g_suite_rec_tbl.CTRL_HDR_TX_APPL_FLAG(i) ,
g_suite_rec_tbl.CTRL_TOTAL_LINE_TX_AMT(i)
);
END insert_data_trx_lines_gt;
| PROCEDURE insert_data_mrc_gt :Inserts a row in ZX_MRC_GT |
* ===========================================================================*/
PROCEDURE insert_data_mrc_gt
(
p_header_row IN NUMBER
) IS
BEGIN
INSERT INTO ZX_MRC_GT
(
MINIMUM_ACCOUNTABLE_UNIT ,
PRECISION ,
APPLICATION_ID ,
ENTITY_CODE ,
EVENT_CLASS_CODE ,
EVENT_TYPE_CODE ,
TRX_ID ,
REPORTING_CURRENCY_CODE ,
CURRENCY_CONVERSION_DATE ,
CURRENCY_CONVERSION_TYPE ,
CURRENCY_CONVERSION_RATE ,
LEDGER_ID
)
VALUES
(
g_suite_rec_tbl.MINIMUM_ACCOUNTABLE_UNIT(p_header_row) ,
g_suite_rec_tbl.PRECISION(p_header_row) ,
g_suite_rec_tbl.APPLICATION_ID (p_header_row) ,
g_suite_rec_tbl.ENTITY_CODE(p_header_row) ,
g_suite_rec_tbl.EVENT_CLASS_CODE(p_header_row) ,
g_suite_rec_tbl.EVENT_TYPE_CODE(p_header_row) ,
g_suite_rec_tbl.TRX_ID(p_header_row) ,
g_suite_rec_tbl.TRX_CURRENCY_CODE(p_header_row) ,
------------------------------------------------------------
--At this moment we will use TRX_CURRENCY_CODE, later when
--g_suite_rec_tbl.REPORTING_CURRENCY_CODE(i) is added to BTT
--we will replace it by REPORTING_CURRENCY_CODE.
------------------------------------------------------------
g_suite_rec_tbl.CURRENCY_CONVERSION_DATE(p_header_row) ,
g_suite_rec_tbl.CURRENCY_CONVERSION_TYPE(p_header_row) ,
g_suite_rec_tbl.CURRENCY_CONVERSION_RATE(p_header_row) ,
g_suite_rec_tbl.LEDGER_ID(p_header_row)
);
| PROCEDURE insert_transaction_rec : Populate the row in transaction_rec |
* ============================================================================*/
PROCEDURE insert_transaction_rec (
p_transaction_rec IN OUT NOCOPY zx_api_pub.transaction_rec_type
)
IS
BEGIN
p_transaction_rec.INTERNAL_ORGANIZATION_ID := g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(1);
END insert_transaction_rec;
| PROCEDURE insert_row_transaction_rec : Populate the row in transaction_rec |
* ============================================================================*/
PROCEDURE insert_row_transaction_rec (
p_transaction_rec IN OUT NOCOPY zx_api_pub.transaction_rec_type,
p_initial_row IN NUMBER
)
IS
BEGIN
p_transaction_rec.INTERNAL_ORGANIZATION_ID := g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(p_initial_row);
END insert_row_transaction_rec;
| PROCEDURE insert_import_sum_tax_lines_gt:Insert a row in ZX_IMPORT_TAX_LINES_GT |
* ====================================================================================*/
PROCEDURE insert_import_sum_tax_lines_gt (
p_starting_row_tax_lines IN NUMBER,
p_ending_row_tax_lines IN NUMBER)
IS
i NUMBER;
INSERT INTO ZX_IMPORT_TAX_LINES_GT
(
SUMMARY_TAX_LINE_NUMBER ,
INTERNAL_ORGANIZATION_ID ,
APPLICATION_ID ,
ENTITY_CODE ,
EVENT_CLASS_CODE ,
TRX_ID ,
TAX_REGIME_CODE ,
TAX ,
TAX_STATUS_CODE ,
TAX_RATE_CODE ,
TAX_RATE ,
TAX_AMT ,
TAX_JURISDICTION_CODE ,
TAX_AMT_INCLUDED_FLAG ,
TAX_RATE_ID ,
TAX_PROVIDER_ID ,
TAX_EXCEPTION_ID ,
TAX_EXEMPTION_ID ,
EXEMPT_REASON_CODE ,
EXEMPT_CERTIFICATE_NUMBER ,
TAX_LINE_ALLOCATION_FLAG
)
VALUES
(
g_suite_rec_tbl.SUMMARY_TAX_LINE_NUMBER(i) ,
g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(i) ,
g_suite_rec_tbl.APPLICATION_ID(i) ,
g_suite_rec_tbl.ENTITY_CODE(i) ,
g_suite_rec_tbl.EVENT_CLASS_CODE(i) ,
g_suite_rec_tbl.TRX_ID(i) ,
g_suite_rec_tbl.TAX_REGIME_CODE(i) ,
g_suite_rec_tbl.TAX(i) ,
g_suite_rec_tbl.TAX_STATUS_CODE(i) ,
g_suite_rec_tbl.TAX_RATE_CODE(i) ,
g_suite_rec_tbl.TAX_RATE(i) ,
g_suite_rec_tbl.TAX_AMT(i) ,
g_suite_rec_tbl.TAX_JURISDICTION_CODE(i) ,
g_suite_rec_tbl.TAX_AMT_INCLUDED_FLAG(i) ,
g_suite_rec_tbl.TAX_RATE_ID(i) ,
g_suite_rec_tbl.TAX_PROVIDER_ID(i) ,
g_suite_rec_tbl.TAX_EXCEPTION_ID(i) ,
g_suite_rec_tbl.TAX_EXEMPTION_ID(i) ,
g_suite_rec_tbl.EXEMPT_REASON_CODE(i) ,
g_suite_rec_tbl.EXEMPT_CERTIFICATE_NUMBER(i),
g_suite_rec_tbl.TAX_LINE_ALLOCATION_FLAG(i)
);
END insert_import_sum_tax_lines_gt;
| PROCEDURE insert_trx_tax_link_gt:Insert a row in ZX_TRX_TAX_LINK_GT |
* ====================================================================*/
PROCEDURE insert_trx_tax_link_gt
(
p_sta_row_imp_tax_link IN NUMBER,
p_end_row_imp_tax_link IN NUMBER
)
IS
i NUMBER;
INSERT INTO ZX_TRX_TAX_LINK_GT
(
APPLICATION_ID ,
ENTITY_CODE ,
EVENT_CLASS_CODE ,
TRX_ID ,
TRX_LEVEL_TYPE ,
TRX_LINE_ID ,
SUMMARY_TAX_LINE_NUMBER ,
LINE_AMT
)
VALUES
(
g_suite_rec_tbl.APPLICATION_ID(i) ,
g_suite_rec_tbl.ENTITY_CODE(i) ,
g_suite_rec_tbl.EVENT_CLASS_CODE(i) ,
g_suite_rec_tbl.TRX_ID(i) ,
g_suite_rec_tbl.TRX_LEVEL_TYPE(i) ,
g_suite_rec_tbl.TRX_LINE_ID(i) ,
g_suite_rec_tbl.SUMMARY_TAX_LINE_NUMBER(i) ,
g_suite_rec_tbl.LINE_AMT(i)
);
END insert_trx_tax_link_gt;
| PROCEDURE insert_reverse_trx_lines_gt:Insert a row in ZX_REVERSE_TRX_LINES_GT|
* =============================================================================*/
PROCEDURE insert_reverse_trx_lines_gt
IS
i NUMBER;
INSERT INTO ZX_REVERSE_TRX_LINES_GT
(
INTERNAL_ORGANIZATION_ID ,
REVERSING_APPLN_ID ,
REVERSING_ENTITY_CODE ,
REVERSING_EVNT_CLS_CODE ,
REVERSING_TRX_ID ,
REVERSING_TRX_LEVEL_TYPE ,
REVERSING_TRX_LINE_ID ,
REVERSED_APPLN_ID ,
REVERSED_ENTITY_CODE ,
REVERSED_EVNT_CLS_CODE ,
REVERSED_TRX_ID ,
REVERSED_TRX_LEVEL_TYPE ,
REVERSED_TRX_LINE_ID ,
TRX_LINE_DESCRIPTION ,
PRODUCT_DESCRIPTION ,
TRX_WAYBILL_NUMBER ,
TRX_LINE_GL_DATE ,
MERCHANT_PARTY_DOCUMENT_NUMBER
)
VALUES
(
g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(i) ,
g_suite_rec_tbl.REVERSING_APPLN_ID(i) ,
g_suite_rec_tbl.REVERSING_ENTITY_CODE(i) ,
g_suite_rec_tbl.REVERSING_EVNT_CLS_CODE(i) ,
g_suite_rec_tbl.REVERSING_TRX_ID(i) ,
g_suite_rec_tbl.REVERSING_TRX_LEVEL_TYPE(i) ,
g_suite_rec_tbl.REVERSING_TRX_LINE_ID(i) ,
g_suite_rec_tbl.REVERSED_APPLN_ID(i) ,
g_suite_rec_tbl.REVERSED_ENTITY_CODE(i) ,
g_suite_rec_tbl.REVERSED_EVNT_CLS_CODE(i) ,
g_suite_rec_tbl.REVERSED_TRX_ID(i) ,
g_suite_rec_tbl.REVERSED_TRX_LEVEL_TYPE(i) ,
g_suite_rec_tbl.REVERSED_TRX_LINE_ID(i) ,
g_suite_rec_tbl.TRX_LINE_DESCRIPTION(i) ,
g_suite_rec_tbl.PRODUCT_DESCRIPTION(i) ,
g_suite_rec_tbl.TRX_WAYBILL_NUMBER(i) ,
g_suite_rec_tbl.TRX_LINE_GL_DATE(i) ,
g_suite_rec_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER(i)
);
END insert_reverse_trx_lines_gt;
| PROCEDURE insert_reverse_dist_lines_gt:Insert a row in ZX_REVERSE_TRX_LINES_GT |
* ===============================================================================*/
PROCEDURE insert_reverse_dist_lines_gt
IS
i NUMBER;
INSERT INTO ZX_REVERSE_DIST_GT
(
INTERNAL_ORGANIZATION_ID,
REVERSING_APPLN_ID,
REVERSING_ENTITY_CODE,
REVERSING_EVNT_CLS_CODE,
REVERSING_TRX_ID,
REVERSING_TRX_LEVEL_TYPE,
REVERSING_TRX_LINE_ID,
REVERSING_TRX_LINE_DIST_ID,
REVERSING_TAX_LINE_ID,
REVERSED_APPLN_ID,
REVERSED_ENTITY_CODE,
REVERSED_EVNT_CLS_CODE,
REVERSED_TRX_ID,
REVERSED_TRX_LEVEL_TYPE,
REVERSED_TRX_LINE_ID,
REVERSED_TRX_LINE_DIST_ID,
FIRST_PTY_ORG_ID ,
REVERSED_TAX_LINE_ID
)
VALUES
(
g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(i),
g_suite_rec_tbl.REVERSING_APPLN_ID(i),
g_suite_rec_tbl.REVERSING_ENTITY_CODE(i),
g_suite_rec_tbl.REVERSING_EVNT_CLS_CODE(i),
g_suite_rec_tbl.REVERSING_TRX_ID(i),
g_suite_rec_tbl.REVERSING_TRX_LEVEL_TYPE(i),
g_suite_rec_tbl.REVERSING_TRX_LINE_ID(i),
g_suite_rec_tbl.REVERSING_TRX_LINE_DIST_ID(i),
g_suite_rec_tbl.REVERSING_TAX_LINE_ID(i),
g_suite_rec_tbl.REVERSED_APPLN_ID(i),
g_suite_rec_tbl.REVERSED_ENTITY_CODE(i),
g_suite_rec_tbl.REVERSED_EVNT_CLS_CODE(i),
g_suite_rec_tbl.REVERSED_TRX_ID(i),
g_suite_rec_tbl.REVERSED_TRX_LEVEL_TYPE(i) ,
g_suite_rec_tbl.REVERSED_TRX_LINE_ID(i) ,
g_suite_rec_tbl.REVERSED_TRX_LINE_DIST_ID(i) ,
g_suite_rec_tbl.FIRST_PTY_ORG_ID(i) ,
g_suite_rec_tbl.REVERSED_TAX_LINE_ID(i)
);
END insert_reverse_dist_lines_gt;
| PROCEDURE insert_itm_distributions_gt:Insert a row in ZX_ITM_DISTRIBUTIONS_GT |
* ================================================================================*/
PROCEDURE insert_itm_distributions_gt
(
p_header_row IN NUMBER,
p_sta_row_item_dist IN NUMBER,
p_end_row_item_dist IN NUMBER
)
IS
i NUMBER;
INSERT INTO ZX_ITM_DISTRIBUTIONS_GT
(
APPLICATION_ID ,
ENTITY_CODE ,
EVENT_CLASS_CODE ,
TRX_ID ,
TRX_LINE_ID ,
TRX_LEVEL_TYPE ,
TRX_LINE_DIST_ID ,
DIST_LEVEL_ACTION ,
TRX_LINE_DIST_DATE ,
ITEM_DIST_NUMBER ,
DIST_INTENDED_USE ,
TAX_INCLUSION_FLAG ,
TAX_CODE ,
APPLIED_FROM_TAX_DIST_ID ,
ADJUSTED_DOC_TAX_DIST_ID ,
TASK_ID ,
AWARD_ID ,
PROJECT_ID ,
EXPENDITURE_TYPE ,
EXPENDITURE_ORGANIZATION_ID ,
EXPENDITURE_ITEM_DATE ,
TRX_LINE_DIST_AMT ,
TRX_LINE_DIST_QTY ,
TRX_LINE_QUANTITY ,
ACCOUNT_CCID ,
ACCOUNT_STRING ,
REF_DOC_APPLICATION_ID ,
REF_DOC_ENTITY_CODE ,
REF_DOC_EVENT_CLASS_CODE ,
REF_DOC_TRX_ID ,
REF_DOC_LINE_ID ,
REF_DOC_DIST_ID ,
REF_DOC_CURR_CONV_RATE ,
TRX_LINE_DIST_TAX_AMT ,
HISTORICAL_FLAG ,
APPLIED_FROM_APPLICATION_ID ,
APPLIED_FROM_EVENT_CLASS_CODE ,
APPLIED_FROM_ENTITY_CODE ,
APPLIED_FROM_TRX_ID ,
APPLIED_FROM_LINE_ID ,
APPLIED_FROM_DIST_ID ,
ADJUSTED_DOC_APPLICATION_ID ,
ADJUSTED_DOC_EVENT_CLASS_CODE ,
ADJUSTED_DOC_ENTITY_CODE ,
ADJUSTED_DOC_TRX_ID ,
ADJUSTED_DOC_LINE_ID ,
ADJUSTED_DOC_DIST_ID ,
APPLIED_TO_DOC_CURR_CONV_RATE ,
TAX_VARIANCE_CALC_FLAG
)
VALUES
(
g_suite_rec_tbl.APPLICATION_ID(p_header_row) ,
g_suite_rec_tbl.ENTITY_CODE(p_header_row) ,
g_suite_rec_tbl.EVENT_CLASS_CODE(p_header_row) ,
g_suite_rec_tbl.TRX_ID(p_header_row) ,
g_suite_rec_tbl.TRX_LINE_ID(i) ,
g_suite_rec_tbl.TRX_LEVEL_TYPE(i) ,
g_suite_rec_tbl.TRX_LINE_DIST_ID(i) ,
g_suite_rec_tbl.DIST_LEVEL_ACTION(i) ,
g_suite_rec_tbl.TRX_LINE_DIST_DATE(i) ,
g_suite_rec_tbl.ITEM_DIST_NUMBER(i) ,
g_suite_rec_tbl.DIST_INTENDED_USE(i) ,
g_suite_rec_tbl.TAX_INCLUSION_FLAG(i) ,
g_suite_rec_tbl.TAX_CODE(i) ,
g_suite_rec_tbl.APPLIED_FROM_TAX_DIST_ID(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_TAX_DIST_ID(i) ,
g_suite_rec_tbl.TASK_ID(i) ,
g_suite_rec_tbl.AWARD_ID(i) ,
g_suite_rec_tbl.PROJECT_ID(i) ,
g_suite_rec_tbl.EXPENDITURE_TYPE(i) ,
g_suite_rec_tbl.EXPENDITURE_ORGANIZATION_ID(i) ,
g_suite_rec_tbl.EXPENDITURE_ITEM_DATE(i) ,
g_suite_rec_tbl.TRX_LINE_DIST_AMT(i) ,
g_suite_rec_tbl.TRX_LINE_DIST_QUANTITY(i) ,
g_suite_rec_tbl.TRX_LINE_QUANTITY(i) ,
g_suite_rec_tbl.ACCOUNT_CCID(i) ,
g_suite_rec_tbl.ACCOUNT_STRING(i) ,
g_suite_rec_tbl.REF_DOC_APPLICATION_ID(i) ,
g_suite_rec_tbl.REF_DOC_ENTITY_CODE(i) ,
g_suite_rec_tbl.REF_DOC_EVENT_CLASS_CODE(i) ,
g_suite_rec_tbl.REF_DOC_TRX_ID(i) ,
g_suite_rec_tbl.REF_DOC_LINE_ID(i) ,
g_suite_rec_tbl.REF_DOC_DIST_ID(i) ,
g_suite_rec_tbl.REF_DOC_CURR_CONV_RATE(i) ,
g_suite_rec_tbl.TRX_LINE_DIST_TAX_AMT(i) ,
g_suite_rec_tbl.HISTORICAL_FLAG(i) ,
g_suite_rec_tbl.APPLIED_FROM_APPLICATION_ID(i) ,
g_suite_rec_tbl.APPLIED_FROM_EVENT_CLASS_CODE(i) ,
g_suite_rec_tbl.APPLIED_FROM_ENTITY_CODE(i) ,
g_suite_rec_tbl.APPLIED_FROM_TRX_ID(i) ,
g_suite_rec_tbl.APPLIED_FROM_LINE_ID(i) ,
g_suite_rec_tbl.APPLIED_FROM_DIST_ID(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_APPLICATION_ID(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(i) ,
g_suite_rec_tbl.adjusted_doc_entity_code(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_TRX_ID(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_LINE_ID(i) ,
g_suite_rec_tbl.ADJUSTED_DOC_DIST_ID(i) ,
g_suite_rec_tbl.APPLIED_TO_DOC_CURR_CONV_RATE(i) ,
g_suite_rec_tbl.TAX_VARIANCE_CALC_FLAG(i) );
END insert_itm_distributions_gt;
| PROCEDURE Insert rows into ZX_TAX_DIST_ID_GT from zx_rec_nrec_dist |
* ========================================================================*/
PROCEDURE insert_rows_tax_dist_id_gt( p_trx_id IN NUMBER)
IS
BEGIN
INSERT INTO ZX_TAX_DIST_ID_GT
(
TAX_DIST_ID
)
SELECT
REC_NREC_TAX_DIST_ID
FROM ZX_REC_NREC_DIST
WHERE TRX_ID = p_trx_id;
END insert_rows_tax_dist_id_gt;
| PROCEDURE insert_sync_trx_rec: Insert the row in the sync trx record |
* =========================================================================*/
PROCEDURE insert_sync_trx_rec
(
p_header_row IN NUMBER,
x_sync_trx_rec OUT NOCOPY zx_api_pub.sync_trx_rec_type
)
IS
BEGIN
x_sync_trx_rec.APPLICATION_ID := g_suite_rec_tbl.APPLICATION_ID(p_header_row);
END insert_sync_trx_rec;
| PROCEDURE insert_sync_trx_lines_tbl:Insert a row in ZX_SYNC_TRX_LINES_tbl |
* ==========================================================================*/
PROCEDURE insert_sync_trx_lines_tbl(
p_header_row IN NUMBER,
p_starting_row_sync_trx_lines IN NUMBER,
p_ending_row_sync_trx_lines IN NUMBER,
x_sync_trx_lines_tbl OUT NOCOPY zx_api_pub.sync_trx_lines_tbl_type%type)
IS
i NUMBER;
END insert_sync_trx_lines_tbl;
| PROCEDURE insert_transaction_line_rec: Populate the transaction_line_rec |
* ============================================================================*/
PROCEDURE insert_transaction_line_rec (
p_transaction_line_rec IN OUT NOCOPY zx_api_pub.transaction_line_rec_type,
p_row_trx_line IN NUMBER
)
IS
BEGIN
p_transaction_line_rec.INTERNAL_ORGANIZATION_ID := g_suite_rec_tbl.internal_organization_id(p_row_trx_line);
write_message('A row has been inserted in g_transaction_line_rec.');
END insert_transaction_line_rec;
| PROCEDURE delete_table : Reset the record of tables |
* ======================================================================*/
PROCEDURE delete_table IS
BEGIN
g_suite_rec_tbl.ROW_ID.delete;
g_suite_rec_tbl.ROW_SUITE.delete;
g_suite_rec_tbl.ROW_CASE.delete;
g_suite_rec_tbl.ROW_API.delete;
g_suite_rec_tbl.ROW_SERVICE.delete;
g_suite_rec_tbl.ROW_STRUCTURE.delete;
g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID.delete;
g_suite_rec_tbl.INTERNAL_ORG_LOCATION_ID.delete;
g_suite_rec_tbl.APPLICATION_ID.delete;
g_suite_rec_tbl.ENTITY_CODE.delete;
g_suite_rec_tbl.EVENT_CLASS_CODE.delete;
g_suite_rec_tbl.TAX_EVENT_CLASS_CODE.delete;
g_suite_rec_tbl.DOC_EVENT_STATUS.delete;
g_suite_rec_tbl.TAX_HOLD_RELEASED_CODE.delete;
g_suite_rec_tbl.EVENT_TYPE_CODE.delete;
g_suite_rec_tbl.TRX_ID.delete;
g_suite_rec_tbl.OVERRIDE_LEVEL.delete;
g_suite_rec_tbl.TRX_LEVEL_TYPE.delete;
g_suite_rec_tbl.TRX_LINE_ID.delete;
g_suite_rec_tbl.TRX_WAYBILL_NUMBER.delete;
g_suite_rec_tbl.TRX_LINE_DESCRIPTION.delete;
g_suite_rec_tbl.PRODUCT_DESCRIPTION.delete;
g_suite_rec_tbl.TAX_LINE_ID.delete;
g_suite_rec_tbl.SUMMARY_TAX_LINE_ID.delete;
g_suite_rec_tbl.INVOICE_PRICE_VARIANCE.delete;
g_suite_rec_tbl.LINE_LEVEL_ACTION.delete;
g_suite_rec_tbl.TAX_CLASSIFICATION_CODE.delete;
g_suite_rec_tbl.TRX_DATE.delete;
g_suite_rec_tbl.TRX_DOC_REVISION.delete;
g_suite_rec_tbl.LEDGER_ID.delete;
g_suite_rec_tbl.TAX_RATE_ID.delete;
g_suite_rec_tbl.TRX_CURRENCY_CODE.delete;
g_suite_rec_tbl.CURRENCY_CONVERSION_DATE.delete;
g_suite_rec_tbl.CURRENCY_CONVERSION_RATE.delete;
g_suite_rec_tbl.CURRENCY_CONVERSION_TYPE.delete;
g_suite_rec_tbl.MINIMUM_ACCOUNTABLE_UNIT.delete;
g_suite_rec_tbl.PRECISION.delete;
g_suite_rec_tbl.TRX_SHIPPING_DATE.delete;
g_suite_rec_tbl.TRX_RECEIPT_DATE.delete;
g_suite_rec_tbl.LEGAL_ENTITY_ID.delete;
g_suite_rec_tbl.REVERSING_APPLN_ID.delete;
g_suite_rec_tbl.ROUNDING_SHIP_TO_PARTY_ID.delete;
g_suite_rec_tbl.ROUNDING_SHIP_FROM_PARTY_ID.delete;
g_suite_rec_tbl.ROUNDING_BILL_TO_PARTY_ID.delete;
g_suite_rec_tbl.ROUNDING_BILL_FROM_PARTY_ID.delete;
g_suite_rec_tbl.RNDG_SHIP_TO_PARTY_SITE_ID.delete;
g_suite_rec_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID.delete;
g_suite_rec_tbl.RNDG_BILL_TO_PARTY_SITE_ID.delete;
g_suite_rec_tbl.RNDG_BILL_FROM_PARTY_SITE_ID.delete;
g_suite_rec_tbl.ESTABLISHMENT_ID.delete;
g_suite_rec_tbl.TAX_EXEMPTION_ID.delete;
g_suite_rec_tbl.REC_NREC_TAX_DIST_ID.delete;
g_suite_rec_tbl.TAX_APPORTIONMENT_LINE_NUMBER.delete;
g_suite_rec_tbl.EXEMPTION_RATE.delete;
g_suite_rec_tbl.TOTAL_NREC_TAX_AMT.delete;
g_suite_rec_tbl.TOTAL_REC_TAX_AMT.delete;
g_suite_rec_tbl.REC_TAX_AMT.delete;
g_suite_rec_tbl.NREC_TAX_AMT.delete;
g_suite_rec_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER.delete;
g_suite_rec_tbl.TRX_LINE_TYPE.delete;
g_suite_rec_tbl.TAX_REGISTRATION_NUMBER.delete;
g_suite_rec_tbl.CTRL_TOTAL_HDR_TX_AMT.delete;
g_suite_rec_tbl.EXEMPT_REASON_CODE.delete;
g_suite_rec_tbl.TAX_HOLD_CODE.delete;
g_suite_rec_tbl.TAX_AMT_FUNCL_CURR.delete;
g_suite_rec_tbl.TOTAL_REC_TAX_AMT_FUNCL_CURR.delete;
g_suite_rec_tbl.TOTAL_NREC_TAX_AMT_FUNCL_CURR.delete;
g_suite_rec_tbl.TAXABLE_AMT_FUNCL_CURR.delete;
g_suite_rec_tbl.REC_TAX_AMT_FUNCL_CURR.delete;
g_suite_rec_tbl.NREC_TAX_AMT_FUNCL_CURR.delete;
g_suite_rec_tbl.TRX_LINE_DATE.delete;
g_suite_rec_tbl.TRX_BUSINESS_CATEGORY.delete;
g_suite_rec_tbl.LINE_INTENDED_USE.delete;
g_suite_rec_tbl.USER_DEFINED_FISC_CLASS.delete;
g_suite_rec_tbl.TAX_CODE.delete;
g_suite_rec_tbl.TAX_INCLUSION_FLAG.delete;
g_suite_rec_tbl.TAX_AMT_INCLUDED_FLAG.delete;
g_suite_rec_tbl.SELF_ASSESSED_FLAG.delete;
g_suite_rec_tbl.QUOTE_FLAG.delete;
g_suite_rec_tbl.HISTORICAL_FLAG.delete;
g_suite_rec_tbl.MANUALLY_ENTERED_FLAG.delete;
g_suite_rec_tbl.LINE_AMT.delete;
g_suite_rec_tbl.TRX_LINE_QUANTITY.delete;
g_suite_rec_tbl.UNIT_PRICE.delete;
g_suite_rec_tbl.EXEMPT_CERTIFICATE_NUMBER.delete;
g_suite_rec_tbl.EXEMPT_REASON.delete;
g_suite_rec_tbl.CASH_DISCOUNT.delete;
g_suite_rec_tbl.VOLUME_DISCOUNT.delete;
g_suite_rec_tbl.TRADING_DISCOUNT.delete;
g_suite_rec_tbl.TRANSFER_CHARGE.delete;
g_suite_rec_tbl.TRANSPORTATION_CHARGE.delete;
g_suite_rec_tbl.INSURANCE_CHARGE.delete;
g_suite_rec_tbl.OTHER_CHARGE.delete;
g_suite_rec_tbl.PRODUCT_ID.delete;
g_suite_rec_tbl.PRODUCT_FISC_CLASSIFICATION.delete;
g_suite_rec_tbl.PRODUCT_ORG_ID.delete;
g_suite_rec_tbl.UOM_CODE.delete;
g_suite_rec_tbl.PRODUCT_TYPE.delete;
g_suite_rec_tbl.PRODUCT_CODE.delete;
g_suite_rec_tbl.PRODUCT_CATEGORY.delete;
g_suite_rec_tbl.TRX_SIC_CODE.delete;
g_suite_rec_tbl.FOB_POINT.delete;
g_suite_rec_tbl.SHIP_TO_PARTY_ID.delete;
g_suite_rec_tbl.SHIP_FROM_PARTY_ID.delete;
g_suite_rec_tbl.POA_PARTY_ID.delete;
g_suite_rec_tbl.POO_PARTY_ID.delete;
g_suite_rec_tbl.BILL_TO_PARTY_ID.delete;
g_suite_rec_tbl.BILL_FROM_PARTY_ID.delete;
g_suite_rec_tbl.MERCHANT_PARTY_ID.delete;
g_suite_rec_tbl.SHIP_TO_PARTY_SITE_ID.delete;
g_suite_rec_tbl.SHIP_FROM_PARTY_SITE_ID.delete;
g_suite_rec_tbl.POA_PARTY_SITE_ID.delete;
g_suite_rec_tbl.POO_PARTY_SITE_ID.delete;
g_suite_rec_tbl.BILL_TO_PARTY_SITE_ID.delete;
g_suite_rec_tbl.BILL_FROM_PARTY_SITE_ID.delete;
g_suite_rec_tbl.SHIP_TO_LOCATION_ID.delete;
g_suite_rec_tbl.SHIP_FROM_LOCATION_ID.delete;
g_suite_rec_tbl.POA_LOCATION_ID.delete;
g_suite_rec_tbl.POO_LOCATION_ID.delete;
g_suite_rec_tbl.BILL_TO_LOCATION_ID.delete;
g_suite_rec_tbl.BILL_FROM_LOCATION_ID.delete;
g_suite_rec_tbl.ACCOUNT_CCID.delete;
g_suite_rec_tbl.ACCOUNT_STRING.delete;
g_suite_rec_tbl.MERCHANT_PARTY_COUNTRY.delete;
g_suite_rec_tbl.RECEIVABLES_TRX_TYPE_ID.delete;
g_suite_rec_tbl.REF_DOC_APPLICATION_ID.delete;
g_suite_rec_tbl.REF_DOC_ENTITY_CODE.delete;
g_suite_rec_tbl.REF_DOC_EVENT_CLASS_CODE.delete;
g_suite_rec_tbl.REF_DOC_TRX_ID.delete;
g_suite_rec_tbl.REF_DOC_LINE_ID.delete;
g_suite_rec_tbl.REF_DOC_LINE_QUANTITY.delete;
g_suite_rec_tbl.RELATED_DOC_APPLICATION_ID.delete;
g_suite_rec_tbl.RELATED_DOC_ENTITY_CODE.delete;
g_suite_rec_tbl.RELATED_DOC_EVENT_CLASS_CODE.delete;
g_suite_rec_tbl.RELATED_DOC_TRX_ID.delete;
g_suite_rec_tbl.RELATED_DOC_NUMBER.delete;
g_suite_rec_tbl.RELATED_DOC_DATE.delete;
g_suite_rec_tbl.APPLIED_FROM_APPLICATION_ID.delete;
g_suite_rec_tbl.APPLIED_FROM_ENTITY_CODE.delete;
g_suite_rec_tbl.APPLIED_FROM_EVENT_CLASS_CODE.delete;
g_suite_rec_tbl.APPLIED_FROM_TRX_ID.delete;
g_suite_rec_tbl.APPLIED_FROM_LINE_ID.delete;
g_suite_rec_tbl.ADJUSTED_DOC_APPLICATION_ID.delete;
g_suite_rec_tbl.ADJUSTED_DOC_ENTITY_CODE.delete;
g_suite_rec_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE.delete;
g_suite_rec_tbl.ADJUSTED_DOC_TRX_ID.delete;
g_suite_rec_tbl.ADJUSTED_DOC_LINE_ID.delete;
g_suite_rec_tbl.ADJUSTED_DOC_NUMBER.delete;
g_suite_rec_tbl.ASSESSABLE_VALUE.delete;
g_suite_rec_tbl.ADJUSTED_DOC_DATE.delete;
g_suite_rec_tbl.APPLIED_TO_APPLICATION_ID.delete;
g_suite_rec_tbl.APPLIED_TO_ENTITY_CODE.delete;
g_suite_rec_tbl.APPLIED_TO_EVENT_CLASS_CODE.delete;
g_suite_rec_tbl.APPLIED_TO_TRX_ID.delete;
g_suite_rec_tbl.APPLIED_TO_TRX_LINE_ID.delete;
g_suite_rec_tbl.TRX_LINE_NUMBER.delete;
g_suite_rec_tbl.TRX_NUMBER.delete;
g_suite_rec_tbl.TRX_DESCRIPTION.delete;
g_suite_rec_tbl.TRX_COMMUNICATED_DATE.delete;
g_suite_rec_tbl.TRX_LINE_GL_DATE.delete;
g_suite_rec_tbl.BATCH_SOURCE_ID.delete;
g_suite_rec_tbl.BATCH_SOURCE_NAME.delete;
g_suite_rec_tbl.DOC_SEQ_ID.delete;
g_suite_rec_tbl.DOC_SEQ_NAME.delete;
g_suite_rec_tbl.DOC_SEQ_VALUE.delete;
g_suite_rec_tbl.TRX_DUE_DATE.delete;
g_suite_rec_tbl.TRX_TYPE_DESCRIPTION.delete;
g_suite_rec_tbl.MERCHANT_PARTY_NAME.delete;
g_suite_rec_tbl.MERCHANT_PARTY_REFERENCE.delete;
g_suite_rec_tbl.MERCHANT_PARTY_TAXPAYER_ID.delete;
g_suite_rec_tbl.MERCHANT_PARTY_TAX_REG_NUMBER.delete;
g_suite_rec_tbl.DOCUMENT_SUB_TYPE.delete;
g_suite_rec_tbl.SUPPLIER_TAX_INVOICE_NUMBER.delete;
g_suite_rec_tbl.SUPPLIER_TAX_INVOICE_DATE.delete;
g_suite_rec_tbl.SUPPLIER_EXCHANGE_RATE.delete;
g_suite_rec_tbl.EXCHANGE_RATE_VARIANCE.delete;
g_suite_rec_tbl.BASE_INVOICE_PRICE_VARIANCE.delete;
g_suite_rec_tbl.TAX_INVOICE_DATE.delete;
g_suite_rec_tbl.TAX_INVOICE_NUMBER.delete;
g_suite_rec_tbl.SUMMARY_TAX_LINE_NUMBER.delete;
g_suite_rec_tbl.TAX_REGIME_CODE.delete;
g_suite_rec_tbl.TAX_JURISDICTION_ID.delete;
g_suite_rec_tbl.TAX.delete;
g_suite_rec_tbl.TAX_STATUS_CODE.delete;
g_suite_rec_tbl.RECOVERY_TYPE_CODE.delete;
g_suite_rec_tbl.RECOVERY_RATE_CODE.delete;
g_suite_rec_tbl.TAX_RATE_CODE.delete;
g_suite_rec_tbl.RECOVERABLE_FLAG.delete;
g_suite_rec_tbl.FREEZE_FLAG.delete;
g_suite_rec_tbl.POSTING_FLAG.delete;
g_suite_rec_tbl.TAX_RATE.delete;
g_suite_rec_tbl.TAX_AMT.delete;
g_suite_rec_tbl.REC_NREC_TAX_AMT.delete;
g_suite_rec_tbl.TAXABLE_AMT.delete;
g_suite_rec_tbl.REC_NREC_TAX_AMT_FUNCL_CURR.delete;
g_suite_rec_tbl.REC_NREC_CCID.delete;
g_suite_rec_tbl.REVERSING_ENTITY_CODE.delete;
g_suite_rec_tbl.REVERSING_EVNT_CLS_CODE.delete;
g_suite_rec_tbl.REVERSING_TRX_ID.delete;
g_suite_rec_tbl.REVERSING_TRX_LINE_DIST_ID.delete;
g_suite_rec_tbl.REVERSING_TRX_LEVEL_TYPE.delete;
g_suite_rec_tbl.REVERSING_TRX_LINE_ID.delete;
g_suite_rec_tbl.REVERSED_APPLN_ID.delete;
g_suite_rec_tbl.REVERSED_ENTITY_CODE.delete;
g_suite_rec_tbl.REVERSED_EVNT_CLS_CODE.delete;
g_suite_rec_tbl.REVERSED_TRX_ID.delete;
g_suite_rec_tbl.REVERSED_TRX_LEVEL_TYPE.delete;
g_suite_rec_tbl.REVERSED_TRX_LINE_ID.delete;
g_suite_rec_tbl.REVERSE_FLAG.delete;
g_suite_rec_tbl.CANCEL_FLAG.delete;
g_suite_rec_tbl.TRX_LINE_DIST_ID.delete;
g_suite_rec_tbl.REVERSED_TAX_DIST_ID.delete;
g_suite_rec_tbl.DIST_LEVEL_ACTION.delete;
g_suite_rec_tbl.TRX_LINE_DIST_DATE.delete;
g_suite_rec_tbl.ITEM_DIST_NUMBER.delete;
g_suite_rec_tbl.DIST_INTENDED_USE.delete;
g_suite_rec_tbl.TASK_ID.delete;
g_suite_rec_tbl.AWARD_ID.delete;
g_suite_rec_tbl.PROJECT_ID.delete;
g_suite_rec_tbl.EXPENDITURE_TYPE.delete;
g_suite_rec_tbl.EXPENDITURE_ORGANIZATION_ID.delete;
g_suite_rec_tbl.EXPENDITURE_ITEM_DATE.delete;
g_suite_rec_tbl.TRX_LINE_DIST_AMT.delete;
g_suite_rec_tbl.TRX_LINE_DIST_QUANTITY.delete;
g_suite_rec_tbl.REF_DOC_DIST_ID.delete;
g_suite_rec_tbl.REF_DOC_CURR_CONV_RATE.delete;
g_suite_rec_tbl.TAX_DIST_ID.delete;
g_suite_rec_tbl.LINE_AMT_INCLUDES_TAX_FLAG.delete;
g_suite_rec_tbl.DEFAULT_TAXATION_COUNTRY.delete;
g_suite_rec_tbl.VALIDATION_CHECK_FLAG.delete;
g_suite_rec_tbl.FIRST_PTY_ORG_ID.delete;
g_suite_rec_tbl.RDNG_SHIP_TO_PTY_TX_PROF_ID.delete;
g_suite_rec_tbl.RDNG_SHIP_FROM_PTY_TX_PROF_ID.delete;
g_suite_rec_tbl.RDNG_BILL_TO_PTY_TX_PROF_ID.delete;
g_suite_rec_tbl.RDNG_BILL_FROM_PTY_TX_PROF_ID.delete;
g_suite_rec_tbl.RDNG_SHIP_TO_PTY_TX_P_ST_ID.delete;
g_suite_rec_tbl.RDNG_SHIP_FROM_PTY_TX_P_ST_ID.delete;
g_suite_rec_tbl.RDNG_BILL_TO_PTY_TX_P_ST_ID.delete;
g_suite_rec_tbl.RDNG_BILL_FROM_PTY_TX_P_ST_ID.delete;
g_suite_rec_tbl.ASSESSABLE_VALUE.delete;
g_suite_rec_tbl.ASSET_ACCUM_DEPRECIATION.delete;
g_suite_rec_tbl.ASSET_COST.delete;
g_suite_rec_tbl.ASSET_FLAG.delete;
g_suite_rec_tbl.ASSET_NUMBER.delete;
g_suite_rec_tbl.ASSET_TYPE.delete;
g_suite_rec_tbl.BILL_FROM_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.BILL_FROM_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.BILL_TO_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.BILL_TO_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.CTRL_HDR_TX_APPL_FLAG.delete;
g_suite_rec_tbl.CTRL_TOTAL_LINE_TX_AMT.delete;
g_suite_rec_tbl.ENTITY_CODE.delete;
g_suite_rec_tbl.EVENT_CLASS_CODE.delete;
g_suite_rec_tbl.HQ_ESTB_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.LINE_CLASS.delete;
g_suite_rec_tbl.MERCHANT_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.OWN_HQ_LOCATION_ID.delete;
g_suite_rec_tbl.OWN_HQ_PARTY_ID.delete;
g_suite_rec_tbl.OWN_HQ_PARTY_SITE_ID.delete;
g_suite_rec_tbl.OWN_HQ_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.OWN_HQ_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.PAYING_LOCATION_ID.delete;
g_suite_rec_tbl.PAYING_PARTY_ID.delete;
g_suite_rec_tbl.PAYING_PARTY_SITE_ID.delete;
g_suite_rec_tbl.PAYING_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.PAYING_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.POA_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.POA_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.POC_LOCATION_ID.delete;
g_suite_rec_tbl.POD_LOCATION_ID.delete;
g_suite_rec_tbl.POD_PARTY_ID.delete;
g_suite_rec_tbl.POD_PARTY_SITE_ID.delete;
g_suite_rec_tbl.POD_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.POD_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.POI_LOCATION_ID.delete;
g_suite_rec_tbl.POI_PARTY_ID.delete;
g_suite_rec_tbl.POI_PARTY_SITE_ID.delete;
g_suite_rec_tbl.POI_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.POI_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.POO_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.POO_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.SHIP_FROM_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.SHIP_FROM_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.SHIP_TO_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.SHIP_TO_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.TITLE_TRANS_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.TITLE_TRANS_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.TITLE_TRANSFER_LOCATION_ID.delete;
g_suite_rec_tbl.TITLE_TRANSFER_PARTY_ID.delete;
g_suite_rec_tbl.TITLE_TRANSFER_PARTY_SITE_ID.delete;
g_suite_rec_tbl.TRADING_HQ_LOCATION_ID.delete;
g_suite_rec_tbl.TRADING_HQ_PARTY_ID.delete;
g_suite_rec_tbl.TRADING_HQ_PARTY_SITE_ID.delete;
g_suite_rec_tbl.TRADING_HQ_PARTY_TAX_PROF_ID.delete;
g_suite_rec_tbl.TRADING_HQ_SITE_TAX_PROF_ID.delete;
g_suite_rec_tbl.TRX_ID_LEVEL2.delete;
g_suite_rec_tbl.TRX_ID_LEVEL3.delete;
g_suite_rec_tbl.TRX_ID_LEVEL4.delete;
g_suite_rec_tbl.TRX_ID_LEVEL5.delete;
g_suite_rec_tbl.TRX_ID_LEVEL6.delete;
g_suite_rec_tbl.PORT_OF_ENTRY_CODE.delete;
g_suite_rec_tbl.SHIP_THIRD_PTY_ACCT_ID.delete;
g_suite_rec_tbl.BILL_THIRD_PTY_ACCT_ID.delete;
g_suite_rec_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID.delete;
g_suite_rec_tbl.BILL_THIRD_PTY_ACCT_SITE_ID.delete;
g_suite_rec_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID.delete;
g_suite_rec_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID.delete;
END delete_table;
select count(*) into l_dummy from zx_trx_headers_gt;
zx_trl_detail_override_pkg.Insert_row (
X_ROWID => l_row_id ,
P_TAX_LINE_ID => null ,
P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.entity_code(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.event_class_code(i) ,
P_EVENT_TYPE_CODE => g_suite_rec_tbl.event_type_code(i) ,
P_TRX_ID => g_suite_rec_tbl.trx_id(i) ,
P_TRX_LINE_ID => g_suite_rec_tbl.tax_line_id(i) ,
P_TRX_LEVEL_TYPE => g_suite_rec_tbl.trx_level_type(i) ,
P_TRX_LINE_NUMBER => g_suite_rec_tbl.trx_line_number(i) ,
P_DOC_EVENT_STATUS => null ,
P_TAX_EVENT_CLASS_CODE => null ,
P_TAX_EVENT_TYPE_CODE => null ,
P_TAX_LINE_NUMBER => g_suite_rec_tbl.tax_line_number(i) ,
P_CONTENT_OWNER_ID => null ,
P_TAX_REGIME_ID => null ,
P_TAX_REGIME_CODE => g_suite_rec_tbl.tax_regime_code(i) ,
P_TAX_ID => null ,
P_TAX => g_suite_rec_tbl.tax(i) ,
P_TAX_STATUS_ID => null ,
P_TAX_STATUS_CODE => g_suite_rec_tbl.tax_status_code(i) ,
P_TAX_RATE_ID => g_suite_rec_tbl.tax_rate_id(i) ,
P_TAX_RATE_CODE => g_suite_rec_tbl.tax_rate_code(i) ,
P_TAX_RATE => g_suite_rec_tbl.tax_rate(i) ,
P_TAX_RATE_TYPE => null ,
P_TAX_APPORTIONMENT_LINE_NUM => null ,
P_TRX_ID_LEVEL2 => null ,
P_TRX_ID_LEVEL3 => null ,
P_TRX_ID_LEVEL4 => null ,
P_TRX_ID_LEVEL5 => null ,
P_TRX_ID_LEVEL6 => null ,
P_TRX_USER_KEY_LEVEL1 => null ,
P_TRX_USER_KEY_LEVEL2 => null ,
P_TRX_USER_KEY_LEVEL3 => null ,
P_TRX_USER_KEY_LEVEL4 => null ,
P_TRX_USER_KEY_LEVEL5 => null ,
P_TRX_USER_KEY_LEVEL6 => null ,
/* P_HDR_TRX_USER_KEY1 => null ,
P_HDR_TRX_USER_KEY2 => null ,
P_HDR_TRX_USER_KEY3 => null ,
P_HDR_TRX_USER_KEY4 => null ,
P_HDR_TRX_USER_KEY5 => null ,
P_HDR_TRX_USER_KEY6 => null ,
P_LINE_TRX_USER_KEY1 => null ,
P_LINE_TRX_USER_KEY2 => null ,
P_LINE_TRX_USER_KEY3 => null ,
P_LINE_TRX_USER_KEY4 => null ,
P_LINE_TRX_USER_KEY5 => null ,
P_LINE_TRX_USER_KEY6 => null ,*/
P_MRC_TAX_LINE_FLAG => null ,
P_MRC_LINK_TO_TAX_LINE_ID => null ,
P_LEDGER_ID => null ,
P_ESTABLISHMENT_ID => null ,
P_LEGAL_ENTITY_ID => null ,
-- P_LEGAL_ENTITY_TAX_REG_NUMBER => null ,
P_HQ_ESTB_REG_NUMBER => null ,
P_HQ_ESTB_PARTY_TAX_PROF_ID => null ,
P_CURRENCY_CONVERSION_DATE => null ,
P_CURRENCY_CONVERSION_TYPE => null ,
P_CURRENCY_CONVERSION_RATE => null ,
P_TAX_CURR_CONVERSION_DATE => null ,
P_TAX_CURR_CONVERSION_TYPE => null ,
P_TAX_CURR_CONVERSION_RATE => null ,
P_TRX_CURRENCY_CODE => null ,
P_REPORTING_CURRENCY_CODE => null ,
P_MINIMUM_ACCOUNTABLE_UNIT => null ,
P_PRECISION => null ,
P_TRX_NUMBER => g_suite_rec_tbl.trx_number(i) ,
P_TRX_DATE => null ,
P_UNIT_PRICE => null ,
P_LINE_AMT => null ,
P_TRX_LINE_QUANTITY => null ,
P_TAX_BASE_MODIFIER_RATE => null ,
P_REF_DOC_APPLICATION_ID => null ,
P_REF_DOC_ENTITY_CODE => null ,
P_REF_DOC_EVENT_CLASS_CODE => null ,
P_REF_DOC_TRX_ID => null ,
P_REF_DOC_TRX_LEVEL_TYPE => null ,
P_REF_DOC_LINE_ID => null ,
P_REF_DOC_LINE_QUANTITY => null ,
P_OTHER_DOC_LINE_AMT => null ,
P_OTHER_DOC_LINE_TAX_AMT => null ,
P_OTHER_DOC_LINE_TAXABLE_AMT => null ,
P_UNROUNDED_TAXABLE_AMT => null ,
P_UNROUNDED_TAX_AMT => null ,
P_RELATED_DOC_APPLICATION_ID => null ,
P_RELATED_DOC_ENTITY_CODE => null ,
P_RELATED_DOC_EVT_CLASS_CODE => null ,
P_RELATED_DOC_TRX_ID => null ,
P_RELATED_DOC_TRX_LEVEL_TYPE => null ,
P_RELATED_DOC_NUMBER => null ,
P_RELATED_DOC_DATE => null ,
P_APPLIED_FROM_APPL_ID => null ,
P_APPLIED_FROM_EVT_CLSS_CODE => null ,
P_APPLIED_FROM_ENTITY_CODE => null ,
P_APPLIED_FROM_TRX_ID => null ,
P_APPLIED_FROM_TRX_LEVEL_TYPE => null ,
P_APPLIED_FROM_LINE_ID => null ,
P_APPLIED_FROM_TRX_NUMBER => null ,
P_ADJUSTED_DOC_APPLN_ID => null ,
P_ADJUSTED_DOC_ENTITY_CODE => g_suite_rec_tbl.adjusted_doc_entity_code(i),
P_ADJUSTED_DOC_EVT_CLSS_CODE => null ,
P_ADJUSTED_DOC_TRX_ID => null ,
P_ADJUSTED_DOC_TRX_LEVEL_TYPE => null ,
P_ADJUSTED_DOC_LINE_ID => null ,
P_ADJUSTED_DOC_NUMBER => null ,
P_ADJUSTED_DOC_DATE => null ,
P_APPLIED_TO_APPLICATION_ID => null ,
P_APPLIED_TO_EVT_CLASS_CODE => null ,
P_APPLIED_TO_ENTITY_CODE => null ,
P_APPLIED_TO_TRX_ID => null ,
P_APPLIED_TO_TRX_LEVEL_TYPE => null ,
P_APPLIED_TO_LINE_ID => null ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
P_OFFSET_LINK_TO_TAX_LINE_ID => null ,
P_OFFSET_FLAG => null ,
P_PROCESS_FOR_RECOVERY_FLAG => null ,
P_TAX_JURISDICTION_ID => g_suite_rec_tbl.tax_jurisdiction_id(i) ,
P_TAX_JURISDICTION_CODE => null ,
P_PLACE_OF_SUPPLY => null ,
P_PLACE_OF_SUPPLY_TYPE_CODE => null ,
P_PLACE_OF_SUPPLY_RESULT_ID => null ,
P_TAX_DATE_RULE_ID => null ,
P_TAX_DATE => null ,
P_TAX_DETERMINE_DATE => null ,
P_TAX_POINT_DATE => null ,
P_TRX_LINE_DATE => null ,
P_TAX_TYPE_CODE => null ,
P_TAX_CODE => null ,
P_TAX_REGISTRATION_ID => null ,
P_TAX_REGISTRATION_NUMBER => g_suite_rec_tbl.tax_registration_number(i) ,
P_REGISTRATION_PARTY_TYPE => null ,
P_ROUNDING_LEVEL_CODE => null ,
P_ROUNDING_RULE_CODE => null ,
P_RNDG_LVL_PARTY_TAX_PROF_ID => null ,
P_ROUNDING_LVL_PARTY_TYPE => null ,
P_COMPOUNDING_TAX_FLAG => null ,
P_ORIG_TAX_STATUS_ID => null ,
P_ORIG_TAX_STATUS_CODE => null ,
P_ORIG_TAX_RATE_ID => null ,
P_ORIG_TAX_RATE_CODE => null ,
P_ORIG_TAX_RATE => null ,
P_ORIG_TAX_JURISDICTION_ID => null ,
P_ORIG_TAX_JURISDICTION_CODE => null ,
P_ORIG_TAX_AMT_INCLUDED_FLAG => null ,
P_ORIG_SELF_ASSESSED_FLAG => null ,
P_TAX_CURRENCY_CODE => null ,
P_TAX_AMT => g_suite_rec_tbl.tax_amt(i) ,
P_TAX_AMT_TAX_CURR => null ,
P_TAX_AMT_FUNCL_CURR => null ,
P_TAXABLE_AMT => g_suite_rec_tbl.taxable_amt(i) ,
P_TAXABLE_AMT_TAX_CURR => null ,
P_TAXABLE_AMT_FUNCL_CURR => null ,
P_ORIG_TAXABLE_AMT => null ,
P_ORIG_TAXABLE_AMT_TAX_CURR => null ,
P_CAL_TAX_AMT => null ,
P_CAL_TAX_AMT_TAX_CURR => null ,
P_CAL_TAX_AMT_FUNCL_CURR => null ,
P_ORIG_TAX_AMT => null ,
P_ORIG_TAX_AMT_TAX_CURR => null ,
P_REC_TAX_AMT => g_suite_rec_tbl.rec_tax_amt(i) ,
P_REC_TAX_AMT_TAX_CURR => null ,
P_REC_TAX_AMT_FUNCL_CURR => null ,
P_NREC_TAX_AMT => g_suite_rec_tbl.nrec_tax_amt(i) ,
P_NREC_TAX_AMT_TAX_CURR => null ,
P_NREC_TAX_AMT_FUNCL_CURR => null ,
P_TAX_EXEMPTION_ID => g_suite_rec_tbl.tax_exemption_id(i) ,
P_TAX_RATE_BEFORE_EXEMPTION => null, --NOT SURE IF IT IS g_suite_rec_tbl.exemption_rate(i),
P_TAX_RATE_NAME_BEFORE_EXEMPT => null ,
P_EXEMPT_RATE_MODIFIER => null ,
P_EXEMPT_CERTIFICATE_NUMBER => g_suite_rec_tbl.exempt_certificate_number(i),
P_EXEMPT_REASON => null ,
P_EXEMPT_REASON_CODE => g_suite_rec_tbl.exempt_reason_code(i) ,
P_TAX_EXCEPTION_ID => null ,
P_TAX_RATE_BEFORE_EXCEPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXCEPT => null ,
P_EXCEPTION_RATE => g_suite_rec_tbl.exemption_rate(i) ,
P_TAX_APPORTIONMENT_FLAG => null ,
P_HISTORICAL_FLAG => null ,
P_TAXABLE_BASIS_FORMULA => null ,
P_TAX_CALCULATION_FORMULA => null ,
P_CANCEL_FLAG => g_suite_rec_tbl.cancel_flag(i) ,
P_PURGE_FLAG => null ,
P_DELETE_FLAG => null ,
P_TAX_AMT_INCLUDED_FLAG => g_suite_rec_tbl.tax_amt_included_flag(i) ,
P_SELF_ASSESSED_FLAG => g_suite_rec_tbl.self_assessed_flag(i) ,
P_OVERRIDDEN_FLAG => null ,
P_MANUALLY_ENTERED_FLAG => g_suite_rec_tbl.manually_entered_flag(i) ,
P_REPORTING_ONLY_FLAG => null ,
P_FREEZE_UNTIL_OVERRIDDN_FLG => null ,
P_COPIED_FROM_OTHER_DOC_FLAG => null ,
P_RECALC_REQUIRED_FLAG => null ,
P_SETTLEMENT_FLAG => null ,
P_ITEM_DIST_CHANGED_FLAG => null ,
P_ASSOC_CHILDREN_FROZEN_FLG => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_COMPOUNDING_DEP_TAX_FLAG => null ,
P_COMPOUNDING_TAX_MISS_FLAG => null ,
P_SYNC_WITH_PRVDR_FLAG => null ,
P_LAST_MANUAL_ENTRY => null ,
P_TAX_PROVIDER_ID => null ,
P_RECORD_TYPE_CODE => null ,
P_REPORTING_PERIOD_ID => null ,
P_LEGAL_JUSTIFICATION_TEXT1 => null ,
P_LEGAL_JUSTIFICATION_TEXT2 => null ,
P_LEGAL_JUSTIFICATION_TEXT3 => null ,
P_LEGAL_MESSAGE_APPL_2 => null ,
P_LEGAL_MESSAGE_STATUS => null ,
P_LEGAL_MESSAGE_RATE => null ,
P_LEGAL_MESSAGE_BASIS => null ,
P_LEGAL_MESSAGE_CALC => null ,
P_LEGAL_MESSAGE_THRESHOLD => null ,
P_LEGAL_MESSAGE_POS => null ,
P_LEGAL_MESSAGE_TRN => null ,
P_LEGAL_MESSAGE_EXMPT => null ,
P_LEGAL_MESSAGE_EXCPT => null ,
P_TAX_REGIME_TEMPLATE_ID => null ,
P_TAX_APPLICABILITY_RESULT_ID => null ,
P_DIRECT_RATE_RESULT_ID => null ,
P_STATUS_RESULT_ID => null ,
P_RATE_RESULT_ID => null ,
P_BASIS_RESULT_ID => null ,
P_THRESH_RESULT_ID => null ,
P_CALC_RESULT_ID => null ,
P_TAX_REG_NUM_DET_RESULT_ID => null ,
P_EVAL_EXMPT_RESULT_ID => null ,
P_EVAL_EXCPT_RESULT_ID => null ,
P_ENFORCED_FROM_NAT_ACCT_FLG => null ,
P_TAX_HOLD_CODE => null ,
P_TAX_HOLD_RELEASED_CODE => null ,
P_PRD_TOTAL_TAX_AMT => null ,
P_PRD_TOTAL_TAX_AMT_TAX_CURR => null ,
P_PRD_TOTAL_TAX_AMT_FUNCL_CURR => null ,
P_TRX_LINE_INDEX => null ,
P_OFFSET_TAX_RATE_CODE => null ,
P_PRORATION_CODE => null ,
P_OTHER_DOC_SOURCE => null ,
P_INTERNAL_ORG_LOCATION_ID => null ,
P_LINE_ASSESSABLE_VALUE => null ,
P_CTRL_TOTAL_LINE_TX_AMT => g_suite_rec_tbl.ctrl_total_line_tx_amt(i) ,
P_APPLIED_TO_TRX_NUMBER => null ,
--P_EVENT_ID => null (has been renamed),
P_ATTRIBUTE_CATEGORY => null ,
P_ATTRIBUTE1 => null ,
P_ATTRIBUTE2 => null ,
P_ATTRIBUTE3 => null ,
P_ATTRIBUTE4 => null ,
P_ATTRIBUTE5 => null ,
P_ATTRIBUTE6 => null ,
P_ATTRIBUTE7 => null ,
P_ATTRIBUTE8 => null ,
P_ATTRIBUTE9 => null ,
P_ATTRIBUTE10 => null ,
P_ATTRIBUTE11 => null ,
P_ATTRIBUTE12 => null ,
P_ATTRIBUTE13 => null ,
P_ATTRIBUTE14 => null ,
P_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE_CATEGORY => null ,
P_GLOBAL_ATTRIBUTE1 => null ,
P_GLOBAL_ATTRIBUTE2 => null ,
P_GLOBAL_ATTRIBUTE3 => null ,
P_GLOBAL_ATTRIBUTE4 => null ,
P_GLOBAL_ATTRIBUTE5 => null ,
P_GLOBAL_ATTRIBUTE6 => null ,
P_GLOBAL_ATTRIBUTE7 => null ,
P_GLOBAL_ATTRIBUTE8 => null ,
P_GLOBAL_ATTRIBUTE9 => null ,
P_GLOBAL_ATTRIBUTE10 => null ,
P_GLOBAL_ATTRIBUTE11 => null ,
P_GLOBAL_ATTRIBUTE12 => null ,
P_GLOBAL_ATTRIBUTE13 => null ,
P_GLOBAL_ATTRIBUTE14 => null ,
P_GLOBAL_ATTRIBUTE15 => null ,
P_NUMERIC1 => null ,
P_NUMERIC2 => null ,
P_NUMERIC3 => null ,
P_NUMERIC4 => null ,
P_NUMERIC5 => null ,
P_NUMERIC6 => null ,
P_NUMERIC7 => null ,
P_NUMERIC8 => null ,
P_NUMERIC9 => null ,
P_NUMERIC10 => null ,
P_CHAR1 => null ,
P_CHAR2 => null ,
P_CHAR3 => null ,
P_CHAR4 => null ,
P_CHAR5 => null ,
P_CHAR6 => null ,
P_CHAR7 => null ,
P_CHAR8 => null ,
P_CHAR9 => null ,
P_CHAR10 => null ,
P_DATE1 => null ,
P_DATE2 => null ,
P_DATE3 => null ,
P_DATE4 => null ,
P_DATE5 => null ,
P_DATE6 => null ,
P_DATE7 => null ,
P_DATE8 => null ,
P_DATE9 => null ,
P_DATE10 => null ,
P_INTERFACE_ENTITY_CODE => null ,
P_INTERFACE_TAX_LINE_ID => null ,
P_TAXING_JURIS_GEOGRAPHY_ID => null ,
P_ADJUSTED_DOC_TAX_LINE_ID => null ,
P_OBJECT_VERSION_NUMBER => 1 ,
P_CREATED_BY => 1 , ---------------------------------
P_CREATION_DATE => sysdate, -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for the Who Columns?
P_LAST_UPDATE_DATE => sysdate, -- Review this later.
P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
ELSIF p_api_service = 'OVERRIDE_DETAIL_UPDATE_TAX_LINE' THEN
----------------------------------------------
-- Get inital and ending row for the structure
----------------------------------------------
get_start_end_rows_structure
(
p_suite => p_suite_number,
p_case => p_case_number,
p_structure => 'STRUCTURE_OVERRIDE_DETAIL_TAX_LINES',
x_start_row => l_start_row,
x_end_row => l_end_row
);
select object_version_number
into l_object_version_number
from zx_lines
where application_id =g_suite_rec_tbl.application_id(i)
and entity_code = g_suite_rec_tbl.entity_code(i)
and event_class_code = g_suite_rec_tbl.event_class_code(i)
and trx_id = g_suite_rec_tbl.trx_id(i)
and trx_line_id = g_suite_rec_tbl.trx_line_id(i)
and trx_level_type = g_suite_rec_tbl.trx_level_type(i)
and tax_line_id = g_suite_rec_tbl.tax_line_id(i) ;
P_DELETE_FLAG => null ,
P_TAX_AMT_INCLUDED_FLAG => g_suite_rec_tbl.tax_amt_included_flag(i) ,
P_SELF_ASSESSED_FLAG => g_suite_rec_tbl.self_assessed_flag(i) ,
P_OVERRIDDEN_FLAG => null ,
P_MANUALLY_ENTERED_FLAG => null ,
P_REPORTING_ONLY_FLAG => null ,
P_FREEZE_UNTIL_OVERRIDDN_FLG => null ,
P_COPIED_FROM_OTHER_DOC_FLAG => null ,
P_RECALC_REQUIRED_FLAG => null ,
P_SETTLEMENT_FLAG => null ,
P_ITEM_DIST_CHANGED_FLAG => null ,
P_ASSOC_CHILDREN_FROZEN_FLG => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_COMPOUNDING_DEP_TAX_FLAG => null ,
P_COMPOUNDING_TAX_MISS_FLAG => null ,
P_SYNC_WITH_PRVDR_FLAG => null ,
P_LAST_MANUAL_ENTRY => null ,
P_TAX_PROVIDER_ID => null ,
P_RECORD_TYPE_CODE => null ,
P_REPORTING_PERIOD_ID => null ,
P_LEGAL_JUSTIFICATION_TEXT1 => null ,
P_LEGAL_JUSTIFICATION_TEXT2 => null ,
P_LEGAL_JUSTIFICATION_TEXT3 => null ,
P_LEGAL_MESSAGE_APPL_2 => null ,
P_LEGAL_MESSAGE_STATUS => null ,
P_LEGAL_MESSAGE_RATE => null ,
P_LEGAL_MESSAGE_BASIS => null ,
P_LEGAL_MESSAGE_CALC => null ,
P_LEGAL_MESSAGE_THRESHOLD => null ,
P_LEGAL_MESSAGE_POS => null ,
P_LEGAL_MESSAGE_TRN => null ,
P_LEGAL_MESSAGE_EXMPT => null ,
P_LEGAL_MESSAGE_EXCPT => null ,
P_TAX_REGIME_TEMPLATE_ID => null ,
P_TAX_APPLICABILITY_RESULT_ID => null ,
P_DIRECT_RATE_RESULT_ID => null ,
P_STATUS_RESULT_ID => null ,
P_RATE_RESULT_ID => null ,
P_BASIS_RESULT_ID => null ,
P_THRESH_RESULT_ID => null ,
P_CALC_RESULT_ID => null ,
P_TAX_REG_NUM_DET_RESULT_ID => null ,
P_EVAL_EXMPT_RESULT_ID => null ,
P_EVAL_EXCPT_RESULT_ID => null ,
P_ENFORCED_FROM_NAT_ACCT_FLG => null ,
P_TAX_HOLD_CODE => null ,
P_TAX_HOLD_RELEASED_CODE => null ,
P_PRD_TOTAL_TAX_AMT => null ,
P_PRD_TOTAL_TAX_AMT_TAX_CURR => null ,
P_PRD_TOTAL_TAX_AMT_FUNCL_CURR => null ,
P_TRX_LINE_INDEX => null ,
P_OFFSET_TAX_RATE_CODE => null ,
P_PRORATION_CODE => null ,
P_OTHER_DOC_SOURCE => null ,
P_INTERNAL_ORG_LOCATION_ID => null ,
P_LINE_ASSESSABLE_VALUE => null ,
P_CTRL_TOTAL_LINE_TX_AMT => g_suite_rec_tbl.ctrl_total_line_tx_amt(i) ,
P_APPLIED_TO_TRX_NUMBER => null ,
P_ATTRIBUTE_CATEGORY => null ,
P_ATTRIBUTE1 => null ,
P_ATTRIBUTE2 => null ,
P_ATTRIBUTE3 => null ,
P_ATTRIBUTE4 => null ,
P_ATTRIBUTE5 => null ,
P_ATTRIBUTE6 => null ,
P_ATTRIBUTE7 => null ,
P_ATTRIBUTE8 => null ,
P_ATTRIBUTE9 => null ,
P_ATTRIBUTE10 => null ,
P_ATTRIBUTE11 => null ,
P_ATTRIBUTE12 => null ,
P_ATTRIBUTE13 => null ,
P_ATTRIBUTE14 => null ,
P_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE_CATEGORY => null ,
P_GLOBAL_ATTRIBUTE1 => null ,
P_GLOBAL_ATTRIBUTE2 => null ,
P_GLOBAL_ATTRIBUTE3 => null ,
P_GLOBAL_ATTRIBUTE4 => null ,
P_GLOBAL_ATTRIBUTE5 => null ,
P_GLOBAL_ATTRIBUTE6 => null ,
P_GLOBAL_ATTRIBUTE7 => null ,
P_GLOBAL_ATTRIBUTE8 => null ,
P_GLOBAL_ATTRIBUTE9 => null ,
P_GLOBAL_ATTRIBUTE10 => null ,
P_GLOBAL_ATTRIBUTE11 => null ,
P_GLOBAL_ATTRIBUTE12 => null ,
P_GLOBAL_ATTRIBUTE13 => null ,
P_GLOBAL_ATTRIBUTE14 => null ,
P_GLOBAL_ATTRIBUTE15 => null ,
P_NUMERIC1 => null ,
P_NUMERIC2 => null ,
P_NUMERIC3 => null ,
P_NUMERIC4 => null ,
P_NUMERIC5 => null ,
P_NUMERIC6 => null ,
P_NUMERIC7 => null ,
P_NUMERIC8 => null ,
P_NUMERIC9 => null ,
P_NUMERIC10 => null ,
P_CHAR1 => null ,
P_CHAR2 => null ,
P_CHAR3 => null ,
P_CHAR4 => null ,
P_CHAR5 => null ,
P_CHAR6 => null ,
P_CHAR7 => null ,
P_CHAR8 => null ,
P_CHAR9 => null ,
P_CHAR10 => null ,
P_DATE1 => null ,
P_DATE2 => null ,
P_DATE3 => null ,
P_DATE4 => null ,
P_DATE5 => null ,
P_DATE6 => null ,
P_DATE7 => null ,
P_DATE8 => null ,
P_DATE9 => null ,
P_DATE10 => null ,
P_INTERFACE_ENTITY_CODE => null ,
P_INTERFACE_TAX_LINE_ID => null ,
P_TAXING_JURIS_GEOGRAPHY_ID => null ,
P_ADJUSTED_DOC_TAX_LINE_ID => null ,
P_OBJECT_VERSION_NUMBER => l_object_version_number ,
P_CREATED_BY => 1 , ---------------------------------
P_CREATION_DATE => sysdate, -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for the Who Columns?
P_LAST_UPDATE_DATE => sysdate, -- Review this later.
P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
select object_version_number
into l_object_version_number
from zx_lines
where application_id =g_suite_rec_tbl.application_id(i)
and entity_code = g_suite_rec_tbl.entity_code(i)
and event_class_code = g_suite_rec_tbl.event_class_code(i)
and trx_id = g_suite_rec_tbl.trx_id(i)
and trx_line_id = g_suite_rec_tbl.trx_line_id(i)
and trx_level_type = g_suite_rec_tbl.trx_level_type(i)
and tax_line_id = g_suite_rec_tbl.tax_line_id(i) ;
zx_trl_detail_override_pkg.Update_row(
--X_ROWID => l_row_id ,
P_TAX_LINE_ID => g_suite_rec_tbl.tax_line_id(i) ,
P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.entity_code(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.event_class_code(i) ,
P_EVENT_TYPE_CODE => g_suite_rec_tbl.event_type_code(i) ,
P_TRX_ID => g_suite_rec_tbl.trx_id(i) ,
P_TRX_LINE_ID => g_suite_rec_tbl.trx_line_id(i) ,
P_TRX_LEVEL_TYPE => g_suite_rec_tbl.trx_level_type(i) ,
P_TRX_LINE_NUMBER => g_suite_rec_tbl.trx_line_number(i) ,
P_DOC_EVENT_STATUS => null ,
P_TAX_EVENT_CLASS_CODE => null ,
P_TAX_EVENT_TYPE_CODE => null ,
P_TAX_LINE_NUMBER => null ,
P_CONTENT_OWNER_ID => null ,
P_TAX_REGIME_ID => null ,
P_TAX_REGIME_CODE => g_suite_rec_tbl.tax_regime_code(i) ,
P_TAX_ID => null ,
P_TAX => null ,
P_TAX_STATUS_ID => null ,
P_TAX_STATUS_CODE => g_suite_rec_tbl.tax_status_code(i) ,
P_TAX_RATE_ID => g_suite_rec_tbl.tax_rate_id(i) ,
P_TAX_RATE_CODE => g_suite_rec_tbl.tax_rate_code(i) ,
P_TAX_RATE => g_suite_rec_tbl.tax_rate(i) ,
P_TAX_RATE_TYPE => null ,
P_TAX_APPORTIONMENT_LINE_NUM => null ,
P_TRX_ID_LEVEL2 => null ,
P_TRX_ID_LEVEL3 => null ,
P_TRX_ID_LEVEL4 => null ,
P_TRX_ID_LEVEL5 => null ,
P_TRX_ID_LEVEL6 => null ,
P_TRX_USER_KEY_LEVEL1 => null ,
P_TRX_USER_KEY_LEVEL2 => null ,
P_TRX_USER_KEY_LEVEL3 => null ,
P_TRX_USER_KEY_LEVEL4 => null ,
P_TRX_USER_KEY_LEVEL5 => null ,
P_TRX_USER_KEY_LEVEL6 => null ,
/*P_HDR_TRX_USER_KEY1 => null ,
P_HDR_TRX_USER_KEY2 => null ,
P_HDR_TRX_USER_KEY3 => null ,
P_HDR_TRX_USER_KEY4 => null ,
P_HDR_TRX_USER_KEY5 => null ,
P_HDR_TRX_USER_KEY6 => null ,
P_LINE_TRX_USER_KEY1 => null ,
P_LINE_TRX_USER_KEY2 => null ,
P_LINE_TRX_USER_KEY3 => null ,
P_LINE_TRX_USER_KEY4 => null ,
P_LINE_TRX_USER_KEY5 => null ,
P_LINE_TRX_USER_KEY6 => null ,*/
P_MRC_TAX_LINE_FLAG => null ,
P_MRC_LINK_TO_TAX_LINE_ID => null ,
P_LEDGER_ID => null ,
P_ESTABLISHMENT_ID => null ,
P_LEGAL_ENTITY_ID => null ,
-- P_LEGAL_ENTITY_TAX_REG_NUMBER => null ,
P_HQ_ESTB_REG_NUMBER => null ,
P_HQ_ESTB_PARTY_TAX_PROF_ID => null ,
P_CURRENCY_CONVERSION_DATE => null ,
P_CURRENCY_CONVERSION_TYPE => null ,
P_CURRENCY_CONVERSION_RATE => null ,
P_TAX_CURR_CONVERSION_DATE => null ,
P_TAX_CURR_CONVERSION_TYPE => null ,
P_TAX_CURR_CONVERSION_RATE => null ,
P_TRX_CURRENCY_CODE => null ,
P_REPORTING_CURRENCY_CODE => null ,
P_MINIMUM_ACCOUNTABLE_UNIT => null ,
P_PRECISION => null ,
P_TRX_NUMBER => null ,
P_TRX_DATE => null ,
P_UNIT_PRICE => null ,
P_LINE_AMT => null ,
P_TRX_LINE_QUANTITY => null ,
P_TAX_BASE_MODIFIER_RATE => null ,
P_REF_DOC_APPLICATION_ID => null ,
P_REF_DOC_ENTITY_CODE => null ,
P_REF_DOC_EVENT_CLASS_CODE => null ,
P_REF_DOC_TRX_ID => null ,
P_REF_DOC_TRX_LEVEL_TYPE => null ,
P_REF_DOC_LINE_ID => null ,
P_REF_DOC_LINE_QUANTITY => null ,
P_OTHER_DOC_LINE_AMT => null ,
P_OTHER_DOC_LINE_TAX_AMT => null ,
P_OTHER_DOC_LINE_TAXABLE_AMT => null ,
P_UNROUNDED_TAXABLE_AMT => null ,
P_UNROUNDED_TAX_AMT => null ,
P_RELATED_DOC_APPLICATION_ID => null ,
P_RELATED_DOC_ENTITY_CODE => null ,
P_RELATED_DOC_EVT_CLASS_CODE => null ,
P_RELATED_DOC_TRX_ID => null ,
P_RELATED_DOC_TRX_LEVEL_TYPE => null ,
P_RELATED_DOC_NUMBER => null ,
P_RELATED_DOC_DATE => null ,
P_APPLIED_FROM_APPL_ID => null ,
P_APPLIED_FROM_EVT_CLSS_CODE => null ,
P_APPLIED_FROM_ENTITY_CODE => null ,
P_APPLIED_FROM_TRX_ID => null ,
P_APPLIED_FROM_TRX_LEVEL_TYPE => null ,
P_APPLIED_FROM_LINE_ID => null ,
P_APPLIED_FROM_TRX_NUMBER => null ,
P_ADJUSTED_DOC_APPLN_ID => null ,
P_ADJUSTED_DOC_ENTITY_CODE => g_suite_rec_tbl.adjusted_doc_entity_code(i),
P_ADJUSTED_DOC_EVT_CLSS_CODE => null ,
P_ADJUSTED_DOC_TRX_ID => null ,
P_ADJUSTED_DOC_TRX_LEVEL_TYPE => null ,
P_ADJUSTED_DOC_LINE_ID => null ,
P_ADJUSTED_DOC_NUMBER => null ,
P_ADJUSTED_DOC_DATE => null ,
P_APPLIED_TO_APPLICATION_ID => null ,
P_APPLIED_TO_EVT_CLASS_CODE => null ,
P_APPLIED_TO_ENTITY_CODE => null ,
P_APPLIED_TO_TRX_ID => null ,
P_APPLIED_TO_TRX_LEVEL_TYPE => null ,
P_APPLIED_TO_LINE_ID => null ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
P_OFFSET_LINK_TO_TAX_LINE_ID => null ,
P_OFFSET_FLAG => null ,
P_PROCESS_FOR_RECOVERY_FLAG => null ,
P_TAX_JURISDICTION_ID => null ,
P_TAX_JURISDICTION_CODE => null ,
P_PLACE_OF_SUPPLY => null ,
P_PLACE_OF_SUPPLY_TYPE_CODE => null ,
P_PLACE_OF_SUPPLY_RESULT_ID => null ,
P_TAX_DATE_RULE_ID => null ,
P_TAX_DATE => null ,
P_TAX_DETERMINE_DATE => null ,
P_TAX_POINT_DATE => null ,
P_TRX_LINE_DATE => null ,
P_TAX_TYPE_CODE => null ,
P_TAX_CODE => null ,
P_TAX_REGISTRATION_ID => null ,
P_TAX_REGISTRATION_NUMBER => null ,
P_REGISTRATION_PARTY_TYPE => null ,
P_ROUNDING_LEVEL_CODE => null ,
P_ROUNDING_RULE_CODE => null ,
P_RNDG_LVL_PARTY_TAX_PROF_ID => null ,
P_ROUNDING_LVL_PARTY_TYPE => null ,
P_COMPOUNDING_TAX_FLAG => null ,
P_ORIG_TAX_STATUS_ID => null ,
P_ORIG_TAX_STATUS_CODE => null ,
P_ORIG_TAX_RATE_ID => null ,
P_ORIG_TAX_RATE_CODE => null ,
P_ORIG_TAX_RATE => null ,
P_ORIG_TAX_JURISDICTION_ID => null ,
P_ORIG_TAX_JURISDICTION_CODE => null ,
P_ORIG_TAX_AMT_INCLUDED_FLAG => null ,
P_ORIG_SELF_ASSESSED_FLAG => null ,
P_TAX_CURRENCY_CODE => null ,
P_TAX_AMT => g_suite_rec_tbl.tax_amt(i) ,
P_TAX_AMT_TAX_CURR => null ,
P_TAX_AMT_FUNCL_CURR => null ,
P_TAXABLE_AMT => null ,
P_TAXABLE_AMT_TAX_CURR => null ,
P_TAXABLE_AMT_FUNCL_CURR => null ,
P_ORIG_TAXABLE_AMT => null ,
P_ORIG_TAXABLE_AMT_TAX_CURR => null ,
P_CAL_TAX_AMT => null ,
P_CAL_TAX_AMT_TAX_CURR => null ,
P_CAL_TAX_AMT_FUNCL_CURR => null ,
P_ORIG_TAX_AMT => null ,
P_ORIG_TAX_AMT_TAX_CURR => null ,
P_REC_TAX_AMT => null ,
P_REC_TAX_AMT_TAX_CURR => null ,
P_REC_TAX_AMT_FUNCL_CURR => null ,
P_NREC_TAX_AMT => null ,
P_NREC_TAX_AMT_TAX_CURR => null ,
P_NREC_TAX_AMT_FUNCL_CURR => null ,
P_TAX_EXEMPTION_ID => null ,
P_TAX_RATE_BEFORE_EXEMPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXEMPT => null ,
P_EXEMPT_RATE_MODIFIER => null ,
P_EXEMPT_CERTIFICATE_NUMBER => null ,
P_EXEMPT_REASON => null ,
P_EXEMPT_REASON_CODE => null ,
P_TAX_EXCEPTION_ID => null ,
P_TAX_RATE_BEFORE_EXCEPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXCEPT => null ,
P_EXCEPTION_RATE => null ,
P_TAX_APPORTIONMENT_FLAG => null ,
P_HISTORICAL_FLAG => null ,
P_TAXABLE_BASIS_FORMULA => null ,
P_TAX_CALCULATION_FORMULA => null ,
P_CANCEL_FLAG => null ,
P_PURGE_FLAG => null ,
P_DELETE_FLAG => null ,
P_TAX_AMT_INCLUDED_FLAG => g_suite_rec_tbl.tax_amt_included_flag(i) ,
P_SELF_ASSESSED_FLAG => g_suite_rec_tbl.self_assessed_flag(i) ,
P_OVERRIDDEN_FLAG => null ,
P_MANUALLY_ENTERED_FLAG => null ,
P_REPORTING_ONLY_FLAG => null ,
P_FREEZE_UNTIL_OVERRIDDN_FLG => null ,
P_COPIED_FROM_OTHER_DOC_FLAG => null ,
P_RECALC_REQUIRED_FLAG => null ,
P_SETTLEMENT_FLAG => null ,
P_ITEM_DIST_CHANGED_FLAG => null ,
P_ASSOC_CHILDREN_FROZEN_FLG => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_COMPOUNDING_DEP_TAX_FLAG => null ,
P_COMPOUNDING_TAX_MISS_FLAG => null ,
P_SYNC_WITH_PRVDR_FLAG => null ,
P_LAST_MANUAL_ENTRY => null ,
P_TAX_PROVIDER_ID => null ,
P_RECORD_TYPE_CODE => null ,
P_REPORTING_PERIOD_ID => null ,
P_LEGAL_JUSTIFICATION_TEXT1 => null ,
P_LEGAL_JUSTIFICATION_TEXT2 => null ,
P_LEGAL_JUSTIFICATION_TEXT3 => null ,
P_LEGAL_MESSAGE_APPL_2 => null ,
P_LEGAL_MESSAGE_STATUS => null ,
P_LEGAL_MESSAGE_RATE => null ,
P_LEGAL_MESSAGE_BASIS => null ,
P_LEGAL_MESSAGE_CALC => null ,
P_LEGAL_MESSAGE_THRESHOLD => null ,
P_LEGAL_MESSAGE_POS => null ,
P_LEGAL_MESSAGE_TRN => null ,
P_LEGAL_MESSAGE_EXMPT => null ,
P_LEGAL_MESSAGE_EXCPT => null ,
P_TAX_REGIME_TEMPLATE_ID => null ,
P_TAX_APPLICABILITY_RESULT_ID => null ,
P_DIRECT_RATE_RESULT_ID => null ,
P_STATUS_RESULT_ID => null ,
P_RATE_RESULT_ID => null ,
P_BASIS_RESULT_ID => null ,
P_THRESH_RESULT_ID => null ,
P_CALC_RESULT_ID => null ,
P_TAX_REG_NUM_DET_RESULT_ID => null ,
P_EVAL_EXMPT_RESULT_ID => null ,
P_EVAL_EXCPT_RESULT_ID => null ,
P_ENFORCED_FROM_NAT_ACCT_FLG => null ,
P_TAX_HOLD_CODE => null ,
P_TAX_HOLD_RELEASED_CODE => null ,
P_PRD_TOTAL_TAX_AMT => null ,
P_PRD_TOTAL_TAX_AMT_TAX_CURR => null ,
P_PRD_TOTAL_TAX_AMT_FUNCL_CURR => null ,
P_TRX_LINE_INDEX => null ,
P_OFFSET_TAX_RATE_CODE => null ,
P_PRORATION_CODE => null ,
P_OTHER_DOC_SOURCE => null ,
P_INTERNAL_ORG_LOCATION_ID => null ,
P_LINE_ASSESSABLE_VALUE => null ,
P_CTRL_TOTAL_LINE_TX_AMT => g_suite_rec_tbl.ctrl_total_line_tx_amt(i) ,
P_APPLIED_TO_TRX_NUMBER => null ,
--P_CTRL_EF_OV_CAL_LINE_FLAG => null ,
P_ATTRIBUTE_CATEGORY => null ,
P_ATTRIBUTE1 => null ,
P_ATTRIBUTE2 => null ,
P_ATTRIBUTE3 => null ,
P_ATTRIBUTE4 => null ,
P_ATTRIBUTE5 => null ,
P_ATTRIBUTE6 => null ,
P_ATTRIBUTE7 => null ,
P_ATTRIBUTE8 => null ,
P_ATTRIBUTE9 => null ,
P_ATTRIBUTE10 => null ,
P_ATTRIBUTE11 => null ,
P_ATTRIBUTE12 => null ,
P_ATTRIBUTE13 => null ,
P_ATTRIBUTE14 => null ,
P_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE_CATEGORY => null ,
P_GLOBAL_ATTRIBUTE1 => null ,
P_GLOBAL_ATTRIBUTE2 => null ,
P_GLOBAL_ATTRIBUTE3 => null ,
P_GLOBAL_ATTRIBUTE4 => null ,
P_GLOBAL_ATTRIBUTE5 => null ,
P_GLOBAL_ATTRIBUTE6 => null ,
P_GLOBAL_ATTRIBUTE7 => null ,
P_GLOBAL_ATTRIBUTE8 => null ,
P_GLOBAL_ATTRIBUTE9 => null ,
P_GLOBAL_ATTRIBUTE10 => null ,
P_GLOBAL_ATTRIBUTE11 => null ,
P_GLOBAL_ATTRIBUTE12 => null ,
P_GLOBAL_ATTRIBUTE13 => null ,
P_GLOBAL_ATTRIBUTE14 => null ,
P_GLOBAL_ATTRIBUTE15 => null ,
P_NUMERIC1 => null ,
P_NUMERIC2 => null ,
P_NUMERIC3 => null ,
P_NUMERIC4 => null ,
P_NUMERIC5 => null ,
P_NUMERIC6 => null ,
P_NUMERIC7 => null ,
P_NUMERIC8 => null ,
P_NUMERIC9 => null ,
P_NUMERIC10 => null ,
P_CHAR1 => null ,
P_CHAR2 => null ,
P_CHAR3 => null ,
P_CHAR4 => null ,
P_CHAR5 => null ,
P_CHAR6 => null ,
P_CHAR7 => null ,
P_CHAR8 => null ,
P_CHAR9 => null ,
P_CHAR10 => null ,
P_DATE1 => null ,
P_DATE2 => null ,
P_DATE3 => null ,
P_DATE4 => null ,
P_DATE5 => null ,
P_DATE6 => null ,
P_DATE7 => null ,
P_DATE8 => null ,
P_DATE9 => null ,
P_DATE10 => null ,
P_INTERFACE_ENTITY_CODE => null ,
P_INTERFACE_TAX_LINE_ID => null ,
P_TAXING_JURIS_GEOGRAPHY_ID => null ,
P_ADJUSTED_DOC_TAX_LINE_ID => null ,
P_OBJECT_VERSION_NUMBER => l_object_version_number+1 ,
--P_CREATED_BY => 1 , ---------------------------------
--P_CREATION_DATE => sysdate, -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for the Who Columns?
P_LAST_UPDATE_DATE => sysdate, -- Review this later.
P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
write_message('Service ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_row/Update_row have been called!.');
ELSIF p_api_service = 'OVERRIDE_DETAIL_DELETE_TAX_LINE' THEN
----------------------------------------------
-- Get inital and ending row for the structure
----------------------------------------------
get_start_end_rows_structure
(
p_suite => p_suite_number,
p_case => p_case_number,
p_structure => 'STRUCTURE_OVERRIDE_DETAIL_TAX_LINES',
x_start_row => l_start_row,
x_end_row => l_end_row
);
/* In V7 Changes for ZX_TRL_DETAIL_OVERRIDE_PKG.delete_row
P_EXEMPTION_RATE => g_suite_rec_tbl.exemption_rate(i)
is no longer there*/
FOR i in l_start_row..l_end_row LOOP
select object_version_number
into l_object_version_number
from zx_lines
where application_id =g_suite_rec_tbl.application_id(i)
and entity_code = g_suite_rec_tbl.entity_code(i)
and event_class_code = g_suite_rec_tbl.event_class_code(i)
and trx_id = g_suite_rec_tbl.trx_id(i)
and trx_line_id = g_suite_rec_tbl.trx_line_id(i)
and trx_level_type = g_suite_rec_tbl.trx_level_type(i)
and tax_line_id = g_suite_rec_tbl.tax_line_id(i) ;
ZX_TRL_DETAIL_OVERRIDE_PKG.delete_row(
X_ROWID => l_row_id ,
P_TAX_LINE_ID => g_suite_rec_tbl.tax_line_id(i) ,
P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.entity_code(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.event_class_code(i) ,
P_EVENT_TYPE_CODE => g_suite_rec_tbl.event_type_code(i) ,
P_TRX_ID => g_suite_rec_tbl.trx_id(i) ,
P_TRX_LINE_ID => g_suite_rec_tbl.trx_line_id(i) ,
P_TRX_LEVEL_TYPE => g_suite_rec_tbl.trx_level_type(i) ,
P_TRX_LINE_NUMBER => g_suite_rec_tbl.trx_line_number(i) ,
P_DOC_EVENT_STATUS => null ,
P_TAX_EVENT_CLASS_CODE => null ,
P_TAX_EVENT_TYPE_CODE => null ,
P_TAX_LINE_NUMBER => null ,
P_CONTENT_OWNER_ID => null ,
P_TAX_REGIME_ID => null ,
P_TAX_REGIME_CODE => g_suite_rec_tbl.tax_regime_code(i) ,
P_TAX_ID => null ,
P_TAX => g_suite_rec_tbl.tax(i) ,
P_TAX_STATUS_ID => null ,
P_TAX_STATUS_CODE => g_suite_rec_tbl.tax_status_code(i) ,
P_TAX_RATE_ID => g_suite_rec_tbl.tax_rate_id(i) ,
P_TAX_RATE_CODE => g_suite_rec_tbl.tax_rate_code(i) ,
P_TAX_RATE => g_suite_rec_tbl.tax_rate(i) ,
P_TAX_RATE_TYPE => null ,
P_TAX_APPORTIONMENT_LINE_NUM => null ,
P_TRX_ID_LEVEL2 => null ,
P_TRX_ID_LEVEL3 => null ,
P_TRX_ID_LEVEL4 => null ,
P_TRX_ID_LEVEL5 => null ,
P_TRX_ID_LEVEL6 => null ,
P_TRX_USER_KEY_LEVEL1 => null ,
P_TRX_USER_KEY_LEVEL2 => null ,
P_TRX_USER_KEY_LEVEL3 => null ,
P_TRX_USER_KEY_LEVEL4 => null ,
P_TRX_USER_KEY_LEVEL5 => null ,
P_TRX_USER_KEY_LEVEL6 => null ,
/*P_HDR_TRX_USER_KEY1 => null ,
P_HDR_TRX_USER_KEY2 => null ,
P_HDR_TRX_USER_KEY3 => null ,
P_HDR_TRX_USER_KEY4 => null ,
P_HDR_TRX_USER_KEY5 => null ,
P_HDR_TRX_USER_KEY6 => null ,
P_LINE_TRX_USER_KEY1 => null ,
P_LINE_TRX_USER_KEY2 => null ,
P_LINE_TRX_USER_KEY3 => null ,
P_LINE_TRX_USER_KEY4 => null ,
P_LINE_TRX_USER_KEY5 => null ,
P_LINE_TRX_USER_KEY6 => null ,*/
P_MRC_TAX_LINE_FLAG => null ,
P_MRC_LINK_TO_TAX_LINE_ID => null ,
P_LEDGER_ID => null ,
P_ESTABLISHMENT_ID => null ,
P_LEGAL_ENTITY_ID => null ,
-- P_LEGAL_ENTITY_TAX_REG_NUMBER => null ,
P_HQ_ESTB_REG_NUMBER => null ,
P_HQ_ESTB_PARTY_TAX_PROF_ID => null ,
P_CURRENCY_CONVERSION_DATE => null ,
P_CURRENCY_CONVERSION_TYPE => null ,
P_CURRENCY_CONVERSION_RATE => null ,
P_TAX_CURR_CONVERSION_DATE => null ,
P_TAX_CURR_CONVERSION_TYPE => null ,
P_TAX_CURR_CONVERSION_RATE => null ,
P_TRX_CURRENCY_CODE => null ,
P_REPORTING_CURRENCY_CODE => null ,
P_MINIMUM_ACCOUNTABLE_UNIT => null ,
P_PRECISION => null ,
P_TRX_NUMBER => g_suite_rec_tbl.trx_number(i) ,
P_TRX_DATE => null ,
P_UNIT_PRICE => null ,
P_LINE_AMT => null ,
P_TRX_LINE_QUANTITY => null ,
P_TAX_BASE_MODIFIER_RATE => null ,
P_REF_DOC_APPLICATION_ID => null ,
P_REF_DOC_ENTITY_CODE => null ,
P_REF_DOC_EVENT_CLASS_CODE => null ,
P_REF_DOC_TRX_ID => null ,
P_REF_DOC_TRX_LEVEL_TYPE => null ,
P_REF_DOC_LINE_ID => null ,
P_REF_DOC_LINE_QUANTITY => null ,
P_OTHER_DOC_LINE_AMT => null ,
P_OTHER_DOC_LINE_TAX_AMT => null ,
P_OTHER_DOC_LINE_TAXABLE_AMT => null ,
P_UNROUNDED_TAXABLE_AMT => null ,
P_UNROUNDED_TAX_AMT => null ,
P_RELATED_DOC_APPLICATION_ID => null ,
P_RELATED_DOC_ENTITY_CODE => null ,
P_RELATED_DOC_EVT_CLASS_CODE => null ,
P_RELATED_DOC_TRX_ID => null ,
P_RELATED_DOC_TRX_LEVEL_TYPE => null ,
P_RELATED_DOC_NUMBER => null ,
P_RELATED_DOC_DATE => null ,
P_APPLIED_FROM_APPL_ID => null ,
P_APPLIED_FROM_EVT_CLSS_CODE => null ,
P_APPLIED_FROM_ENTITY_CODE => null ,
P_APPLIED_FROM_TRX_ID => null ,
P_APPLIED_FROM_TRX_LEVEL_TYPE => null ,
P_APPLIED_FROM_LINE_ID => null ,
P_APPLIED_FROM_TRX_NUMBER => null ,
P_ADJUSTED_DOC_APPLN_ID => null ,
P_ADJUSTED_DOC_ENTITY_CODE => g_suite_rec_tbl.adjusted_doc_entity_code(i),
P_ADJUSTED_DOC_EVT_CLSS_CODE => null ,
P_ADJUSTED_DOC_TRX_ID => null ,
P_ADJUSTED_DOC_TRX_LEVEL_TYPE => null ,
P_ADJUSTED_DOC_LINE_ID => null ,
P_ADJUSTED_DOC_NUMBER => null ,
P_ADJUSTED_DOC_DATE => null ,
P_APPLIED_TO_APPLICATION_ID => null ,
P_APPLIED_TO_EVT_CLASS_CODE => null ,
P_APPLIED_TO_ENTITY_CODE => null ,
P_APPLIED_TO_TRX_ID => null ,
P_APPLIED_TO_TRX_LEVEL_TYPE => null ,
P_APPLIED_TO_LINE_ID => null ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
P_OFFSET_LINK_TO_TAX_LINE_ID => null ,
P_OFFSET_FLAG => null ,
P_PROCESS_FOR_RECOVERY_FLAG => null ,
P_TAX_JURISDICTION_ID => g_suite_rec_tbl.tax_jurisdiction_id(i) ,
P_TAX_JURISDICTION_CODE => null ,
P_PLACE_OF_SUPPLY => null ,
P_PLACE_OF_SUPPLY_TYPE_CODE => null ,
P_PLACE_OF_SUPPLY_RESULT_ID => null ,
P_TAX_DATE_RULE_ID => null ,
P_TAX_DATE => null ,
P_TAX_DETERMINE_DATE => null ,
P_TAX_POINT_DATE => null ,
P_TRX_LINE_DATE => null ,
P_TAX_TYPE_CODE => null ,
P_TAX_CODE => null ,
P_TAX_REGISTRATION_ID => null ,
P_TAX_REGISTRATION_NUMBER => g_suite_rec_tbl.tax_registration_number(i) ,
P_REGISTRATION_PARTY_TYPE => null ,
P_ROUNDING_LEVEL_CODE => null ,
P_ROUNDING_RULE_CODE => null ,
P_RNDG_LVL_PARTY_TAX_PROF_ID => null ,
P_ROUNDING_LVL_PARTY_TYPE => null ,
P_COMPOUNDING_TAX_FLAG => null ,
P_ORIG_TAX_STATUS_ID => null ,
P_ORIG_TAX_STATUS_CODE => null ,
P_ORIG_TAX_RATE_ID => null ,
P_ORIG_TAX_RATE_CODE => null ,
P_ORIG_TAX_RATE => null ,
P_ORIG_TAX_JURISDICTION_ID => null ,
P_ORIG_TAX_JURISDICTION_CODE => null ,
P_ORIG_TAX_AMT_INCLUDED_FLAG => null ,
P_ORIG_SELF_ASSESSED_FLAG => null ,
P_TAX_CURRENCY_CODE => null ,
P_TAX_AMT => g_suite_rec_tbl.tax_amt(i) ,
P_TAX_AMT_TAX_CURR => null ,
P_TAX_AMT_FUNCL_CURR => null ,
P_TAXABLE_AMT => g_suite_rec_tbl.taxable_amt(i) ,
P_TAXABLE_AMT_TAX_CURR => null ,
P_TAXABLE_AMT_FUNCL_CURR => null ,
P_ORIG_TAXABLE_AMT => null ,
P_ORIG_TAXABLE_AMT_TAX_CURR => null ,
P_CAL_TAX_AMT => null ,
P_CAL_TAX_AMT_TAX_CURR => null ,
P_CAL_TAX_AMT_FUNCL_CURR => null ,
P_ORIG_TAX_AMT => null ,
P_ORIG_TAX_AMT_TAX_CURR => null ,
P_REC_TAX_AMT => g_suite_rec_tbl.rec_tax_amt(i) ,
P_REC_TAX_AMT_TAX_CURR => null ,
P_REC_TAX_AMT_FUNCL_CURR => null ,
P_NREC_TAX_AMT => g_suite_rec_tbl.nrec_tax_amt(i) ,
P_NREC_TAX_AMT_TAX_CURR => null ,
P_NREC_TAX_AMT_FUNCL_CURR => null ,
P_TAX_EXEMPTION_ID => null ,
P_TAX_RATE_BEFORE_EXEMPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXEMPT => null ,
P_EXEMPT_RATE_MODIFIER => null ,
P_EXEMPT_CERTIFICATE_NUMBER => g_suite_rec_tbl.exempt_certificate_number(i),
P_EXEMPT_REASON => null ,
P_EXEMPT_REASON_CODE => g_suite_rec_tbl.exempt_reason_code(i) ,
P_TAX_EXCEPTION_ID => null ,
P_TAX_RATE_BEFORE_EXCEPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXCEPT => null ,
P_EXCEPTION_RATE => null ,
P_TAX_APPORTIONMENT_FLAG => null ,
P_HISTORICAL_FLAG => null ,
P_TAXABLE_BASIS_FORMULA => null ,
P_TAX_CALCULATION_FORMULA => null ,
P_CANCEL_FLAG => g_suite_rec_tbl.cancel_flag(i) ,
P_PURGE_FLAG => null ,
P_DELETE_FLAG => null ,
P_TAX_AMT_INCLUDED_FLAG => g_suite_rec_tbl.tax_amt_included_flag(i) ,
P_SELF_ASSESSED_FLAG => g_suite_rec_tbl.self_assessed_flag(i) ,
P_OVERRIDDEN_FLAG => null ,
P_MANUALLY_ENTERED_FLAG => g_suite_rec_tbl.manually_entered_flag(i) ,
P_REPORTING_ONLY_FLAG => null ,
P_FREEZE_UNTIL_OVERRIDDN_FLG => null ,
P_COPIED_FROM_OTHER_DOC_FLAG => null ,
P_RECALC_REQUIRED_FLAG => null ,
P_SETTLEMENT_FLAG => null ,
P_ITEM_DIST_CHANGED_FLAG => null ,
P_ASSOC_CHILDREN_FROZEN_FLG => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_COMPOUNDING_DEP_TAX_FLAG => null ,
P_COMPOUNDING_TAX_MISS_FLAG => null ,
P_SYNC_WITH_PRVDR_FLAG => null ,
P_LAST_MANUAL_ENTRY => null ,
P_TAX_PROVIDER_ID => null ,
P_RECORD_TYPE_CODE => null ,
P_REPORTING_PERIOD_ID => null ,
P_LEGAL_JUSTIFICATION_TEXT1 => null ,
P_LEGAL_JUSTIFICATION_TEXT2 => null ,
P_LEGAL_JUSTIFICATION_TEXT3 => null ,
P_LEGAL_MESSAGE_APPL_2 => null ,
P_LEGAL_MESSAGE_STATUS => null ,
P_LEGAL_MESSAGE_RATE => null ,
P_LEGAL_MESSAGE_BASIS => null ,
P_LEGAL_MESSAGE_CALC => null ,
P_LEGAL_MESSAGE_THRESHOLD => null ,
P_LEGAL_MESSAGE_POS => null ,
P_LEGAL_MESSAGE_TRN => null ,
P_LEGAL_MESSAGE_EXMPT => null ,
P_LEGAL_MESSAGE_EXCPT => null ,
P_TAX_REGIME_TEMPLATE_ID => null ,
P_TAX_APPLICABILITY_RESULT_ID => null ,
P_DIRECT_RATE_RESULT_ID => null ,
P_STATUS_RESULT_ID => null ,
P_RATE_RESULT_ID => null ,
P_BASIS_RESULT_ID => null ,
P_THRESH_RESULT_ID => null ,
P_CALC_RESULT_ID => null ,
P_TAX_REG_NUM_DET_RESULT_ID => null ,
P_EVAL_EXMPT_RESULT_ID => null ,
P_EVAL_EXCPT_RESULT_ID => null ,
P_ENFORCED_FROM_NAT_ACCT_FLG => null ,
P_TAX_HOLD_CODE => null ,
P_TAX_HOLD_RELEASED_CODE => null ,
P_PRD_TOTAL_TAX_AMT => null ,
P_PRD_TOTAL_TAX_AMT_TAX_CURR => null ,
P_PRD_TOTAL_TAX_AMT_FUNCL_CURR => null ,
P_TRX_LINE_INDEX => null ,
P_OFFSET_TAX_RATE_CODE => null ,
P_PRORATION_CODE => null ,
P_OTHER_DOC_SOURCE => null ,
P_INTERNAL_ORG_LOCATION_ID => null ,
P_LINE_ASSESSABLE_VALUE => null ,
P_CTRL_TOTAL_LINE_TX_AMT => g_suite_rec_tbl.ctrl_total_line_tx_amt(i) ,
P_APPLIED_TO_TRX_NUMBER => null , --added bug 4053445
P_ATTRIBUTE_CATEGORY => null ,
P_ATTRIBUTE1 => null ,
P_ATTRIBUTE2 => null ,
P_ATTRIBUTE3 => null ,
P_ATTRIBUTE4 => null ,
P_ATTRIBUTE5 => null ,
P_ATTRIBUTE6 => null ,
P_ATTRIBUTE7 => null ,
P_ATTRIBUTE8 => null ,
P_ATTRIBUTE9 => null ,
P_ATTRIBUTE10 => null ,
P_ATTRIBUTE11 => null ,
P_ATTRIBUTE12 => null ,
P_ATTRIBUTE13 => null ,
P_ATTRIBUTE14 => null ,
P_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE_CATEGORY => null ,
P_GLOBAL_ATTRIBUTE1 => null ,
P_GLOBAL_ATTRIBUTE2 => null ,
P_GLOBAL_ATTRIBUTE3 => null ,
P_GLOBAL_ATTRIBUTE4 => null ,
P_GLOBAL_ATTRIBUTE5 => null ,
P_GLOBAL_ATTRIBUTE6 => null ,
P_GLOBAL_ATTRIBUTE7 => null ,
P_GLOBAL_ATTRIBUTE8 => null ,
P_GLOBAL_ATTRIBUTE9 => null ,
P_GLOBAL_ATTRIBUTE10 => null ,
P_GLOBAL_ATTRIBUTE11 => null ,
P_GLOBAL_ATTRIBUTE12 => null ,
P_GLOBAL_ATTRIBUTE13 => null ,
P_GLOBAL_ATTRIBUTE14 => null ,
P_GLOBAL_ATTRIBUTE15 => null ,
P_NUMERIC1 => null ,
P_NUMERIC2 => null ,
P_NUMERIC3 => null ,
P_NUMERIC4 => null ,
P_NUMERIC5 => null ,
P_NUMERIC6 => null ,
P_NUMERIC7 => null ,
P_NUMERIC8 => null ,
P_NUMERIC9 => null ,
P_NUMERIC10 => null ,
P_CHAR1 => null ,
P_CHAR2 => null ,
P_CHAR3 => null ,
P_CHAR4 => null ,
P_CHAR5 => null ,
P_CHAR6 => null ,
P_CHAR7 => null ,
P_CHAR8 => null ,
P_CHAR9 => null ,
P_CHAR10 => null ,
P_DATE1 => null ,
P_DATE2 => null ,
P_DATE3 => null ,
P_DATE4 => null ,
P_DATE5 => null ,
P_DATE6 => null ,
P_DATE7 => null ,
P_DATE8 => null ,
P_DATE9 => null ,
P_DATE10 => null ,
P_INTERFACE_ENTITY_CODE => null ,
P_INTERFACE_TAX_LINE_ID => null ,
P_TAXING_JURIS_GEOGRAPHY_ID => null ,
P_ADJUSTED_DOC_TAX_LINE_ID => null ,
P_OBJECT_VERSION_NUMBER => l_object_version_number ,
P_CREATED_BY => 1 , ---------------------------------
P_CREATION_DATE => sysdate, -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for the Who Columns?
P_LAST_UPDATE_DATE => sysdate, -- Review this later.
P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
write_message('Service ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row has been called!.');
/* Not found in ZX_TRL_SUMMARY_OVERRIDE_PKG.insert_row following
columns
P_TRX_LEVEL_TYPE => g_suite_rec_tbl.TRX_LEVEL_TYPE(i) ,
P_SUMMARY_TAX_LINE_NUMBER => g_suite_rec_tbl.SUMMARY_TAX_LINE_NUMBER(i),
P_TAX_JURISDICTION_ID => g_suite_rec_tbl.TAX_JURISDICTION_ID(i) , --THERE IS ONLY CODE */
FOR i IN l_start_row..l_end_row LOOP
ZX_TRL_SUMMARY_OVERRIDE_PKG.insert_row(
X_ROWID => l_row_id ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.SUMMARY_TAX_LINE_ID(i) ,
P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(i),
P_APPLICATION_ID => g_suite_rec_tbl.APPLICATION_ID(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.ENTITY_CODE(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.EVENT_CLASS_CODE(i) ,
P_TRX_ID => g_suite_rec_tbl.TRX_ID(i) ,
P_SUMMARY_TAX_LINE_NUMBER => null ,
P_TRX_NUMBER => g_suite_rec_tbl.TRX_NUMBER(i) ,
P_APPLIED_FROM_APPLICATION_ID => null ,
P_APPLIED_FROM_EVT_CLASS_CODE => null ,
P_APPLIED_FROM_ENTITY_CODE => null ,
P_APPLIED_FROM_TRX_ID => null ,
P_APPLIED_FROM_TRX_LEVEL_TYPE => null ,
P_APPLIED_FROM_LINE_ID => null ,
P_ADJUSTED_DOC_APPLICATION_ID => null ,
P_ADJUSTED_DOC_ENTITY_CODE => g_suite_rec_tbl.adjusted_doc_entity_code(i),
P_ADJUSTED_DOC_EVT_CLASS_CODE => null ,
P_ADJUSTED_DOC_TRX_ID => null ,
P_ADJUSTED_DOC_TRX_LEVEL_TYPE => null ,
P_APPLIED_TO_APPLICATION_ID => null ,
P_APPLIED_TO_EVENT_CLASS_CODE => null ,
P_APPLIED_TO_ENTITY_CODE => null ,
P_APPLIED_TO_TRX_ID => null ,
P_APPLIED_TO_TRX_LEVEL_TYPE => null ,
P_APPLIED_TO_LINE_ID => null ,
P_TAX_EXEMPTION_ID => null ,
P_TAX_RATE_BEFORE_EXEMPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXEMPT => null ,
P_EXEMPT_RATE_MODIFIER => null ,
P_EXEMPT_CERTIFICATE_NUMBER => null ,
P_EXEMPT_REASON => null ,
P_EXEMPT_REASON_CODE => null ,
P_TAX_RATE_BEFORE_EXCEPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXCEPT => null ,
P_TAX_EXCEPTION_ID => null ,
P_EXCEPTION_RATE => null ,
P_CONTENT_OWNER_ID => null ,
P_TAX_REGIME_CODE => g_suite_rec_tbl.TAX_REGIME_CODE(i) ,
P_TAX => g_suite_rec_tbl.TAX(i) ,
P_TAX_STATUS_CODE => g_suite_rec_tbl.TAX_STATUS_CODE(i) ,
P_TAX_RATE_ID => g_suite_rec_tbl.TAX_RATE_ID(i) ,
P_TAX_RATE_CODE => g_suite_rec_tbl.TAX_RATE_CODE(i) ,
P_TAX_RATE => g_suite_rec_tbl.TAX_RATE(i) ,
P_TAX_AMT => g_suite_rec_tbl.TAX_AMT(i) ,
P_TAX_AMT_TAX_CURR => null ,
P_TAX_AMT_FUNCL_CURR => null ,
P_TAX_JURISDICTION_CODE => null ,
P_TOTAL_REC_TAX_AMT => g_suite_rec_tbl.TOTAL_REC_TAX_AMT(i) ,
P_TOTAL_REC_TAX_AMT_FUNC_CURR => null ,
P_TOTAL_REC_TAX_AMT_TAX_CURR => null ,
P_TOTAL_NREC_TAX_AMT => g_suite_rec_tbl.TOTAL_NREC_TAX_AMT(i) ,
P_TOTAL_NREC_TAX_AMT_FUNC_CURR => null ,
P_TOTAL_NREC_TAX_AMT_TAX_CURR => null ,
P_LEDGER_ID => g_suite_rec_tbl.LEDGER_ID(i) ,
P_LEGAL_ENTITY_ID => null ,
P_ESTABLISHMENT_ID => null ,
P_CURRENCY_CONVERSION_DATE => null ,
P_CURRENCY_CONVERSION_TYPE => null ,
P_CURRENCY_CONVERSION_RATE => null ,
P_SUMMARIZATION_TEMPLATE_ID => null ,
P_TAXABLE_BASIS_FORMULA => null ,
P_TAX_CALCULATION_FORMULA => null ,
P_HISTORICAL_FLAG => null ,
P_CANCEL_FLAG => g_suite_rec_tbl.CANCEL_FLAG(i) ,
P_DELETE_FLAG => null ,
P_TAX_AMT_INCLUDED_FLAG => g_suite_rec_tbl.TAX_AMT_INCLUDED_FLAG(i),
P_COMPOUNDING_TAX_FLAG => null ,
P_SELF_ASSESSED_FLAG => g_suite_rec_tbl.SELF_ASSESSED_FLAG(i) ,
P_OVERRIDDEN_FLAG => null ,
P_REPORTING_ONLY_FLAG => null ,
P_ASSOC_CHILD_FROZEN_FLAG => null ,
P_COPIED_FROM_OTHER_DOC_FLAG => null ,
P_MANUALLY_ENTERED_FLAG => g_suite_rec_tbl.MANUALLY_ENTERED_FLAG(i),
P_MRC_TAX_LINE_FLAG => null ,
P_LAST_MANUAL_ENTRY => null ,
P_RECORD_TYPE_CODE => null ,
P_TAX_PROVIDER_ID => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_ADJUST_TAX_AMT_FLAG => null ,
P_ATTRIBUTE_CATEGORY => null ,
P_ATTRIBUTE1 => null ,
P_ATTRIBUTE2 => null ,
P_ATTRIBUTE3 => null ,
P_ATTRIBUTE4 => null ,
P_ATTRIBUTE5 => null ,
P_ATTRIBUTE6 => null ,
P_ATTRIBUTE7 => null ,
P_ATTRIBUTE8 => null ,
P_ATTRIBUTE9 => null ,
P_ATTRIBUTE10 => null ,
P_ATTRIBUTE11 => null ,
P_ATTRIBUTE12 => null ,
P_ATTRIBUTE13 => null ,
P_ATTRIBUTE14 => null ,
P_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE_CATEGORY => null ,
P_GLOBAL_ATTRIBUTE1 => null ,
P_GLOBAL_ATTRIBUTE2 => null ,
P_GLOBAL_ATTRIBUTE3 => null ,
P_GLOBAL_ATTRIBUTE4 => null ,
P_GLOBAL_ATTRIBUTE5 => null ,
P_GLOBAL_ATTRIBUTE6 => null ,
P_GLOBAL_ATTRIBUTE7 => null ,
P_GLOBAL_ATTRIBUTE8 => null ,
P_GLOBAL_ATTRIBUTE9 => null ,
P_GLOBAL_ATTRIBUTE10 => null ,
P_GLOBAL_ATTRIBUTE11 => null ,
P_GLOBAL_ATTRIBUTE12 => null ,
P_GLOBAL_ATTRIBUTE13 => null ,
P_GLOBAL_ATTRIBUTE14 => null ,
P_GLOBAL_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE16 => null ,
P_GLOBAL_ATTRIBUTE17 => null ,
P_GLOBAL_ATTRIBUTE18 => null ,
P_GLOBAL_ATTRIBUTE19 => null ,
P_GLOBAL_ATTRIBUTE20 => null ,
P_OBJECT_VERSION_NUMBER => 1 ,
P_CREATED_BY => 1 , ---------------------------------
P_CREATION_DATE => sysdate, -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for the Who Columns?
P_LAST_UPDATE_DATE => sysdate, -- Review this later.
P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
write_message('Service ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row has been called!.');
write_message('Calling zx_trl_allocations_pkg.insert_row');
zx_trl_allocations_pkg.insert_row(
X_ROWID => l_row_id ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.entity_code(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.event_class_code(i) ,
P_EVENT_TYPE_CODE => g_suite_rec_tbl.event_type_code(i) ,
P_TRX_LINE_NUMBER => g_suite_rec_tbl.trx_line_number(i) ,
P_TRX_ID => g_suite_rec_tbl.trx_id(i) ,
P_TRX_NUMBER => null ,
P_TRX_LINE_ID => g_suite_rec_tbl.trx_line_id(i) ,
P_TRX_LEVEL_TYPE => g_suite_rec_tbl.trx_level_type(i) ,
P_LINE_AMT => null ,
P_TRX_LINE_DATE => null ,
--P_TAX_REGIME_ID => null ,
P_TAX_REGIME_CODE => g_suite_rec_tbl.tax_regime_code(i) ,
--P_TAX_ID => null ,
P_TAX => g_suite_rec_tbl.tax(i) ,
--P_TAX_JURISDICTION_ID => g_suite_rec_tbl.tax_jurisdiction_id(i) ,
P_TAX_JURISDICTION_CODE => null ,
--P_TAX_STATUS_ID => null ,
P_TAX_STATUS_CODE => g_suite_rec_tbl.tax_status_code(i) ,
P_TAX_RATE_ID => g_suite_rec_tbl.tax_rate_id(i) ,
P_TAX_RATE_CODE => g_suite_rec_tbl.tax_rate_code(i) ,
P_TAX_RATE => g_suite_rec_tbl.tax_rate(i) ,
P_TAX_AMT => g_suite_rec_tbl.tax_amt(i) ,
P_ENABLED_RECORD => null ,
--P_HDR_TRX_USER_KEY1 => null ,
--P_HDR_TRX_USER_KEY2 => null ,
--P_HDR_TRX_USER_KEY3 => null ,
--P_HDR_TRX_USER_KEY4 => null ,
--P_HDR_TRX_USER_KEY5 => null ,
--P_HDR_TRX_USER_KEY6 => null ,
--P_LINE_TRX_USER_KEY1 => null ,
--P_LINE_TRX_USER_KEY2 => null ,
--P_LINE_TRX_USER_KEY3 => null ,
--P_LINE_TRX_USER_KEY4 => null ,
--P_LINE_TRX_USER_KEY5 => null ,
--P_LINE_TRX_USER_KEY6 => null ,
P_MANUALLY_ENTERED_FLAG => null ,
P_CONTENT_OWNER_ID => null ,
P_RECORD_TYPE_CODE => null ,
P_LAST_MANUAL_ENTRY => null ,
P_TRX_LINE_AMT => null ,
P_TAX_AMT_INCLUDED_FLAG => null ,
P_SELF_ASSESSED_FLAG => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_CREATED_BY => 1 , ---------------------------------
P_CREATION_DATE => sysdate , -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for the Who Columns?
P_LAST_UPDATE_DATE => sysdate , -- Review this later.
P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
write_message('Service zx_trl_allocations_pkg.Insert_row has been called!.');
P_LAST_UPDATED_BY => 1 , -- to pass to Who Columns?
P_LAST_UPDATE_DATE => sysdate , ------------------------------
P_LAST_UPDATE_LOGIN => 1
); null;
zx_trl_allocations_pkg.Update_row
(
X_ROWID => l_row_id ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i) ,
P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.entity_code(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.event_class_code(i) ,
P_EVENT_TYPE_CODE => g_suite_rec_tbl.event_type_code(i) ,
P_TRX_LINE_ID => g_suite_rec_tbl.trx_line_id(i) ,
P_TRX_LINE_NUMBER => g_suite_rec_tbl.trx_line_number(i) ,
P_TAX_EVENT_CLASS_CODE => null ,
P_TAX_EVENT_TYPE_CODE => null ,
P_TRX_ID => g_suite_rec_tbl.trx_id(i) ,
P_TAX_LINE_ID => g_suite_rec_tbl.tax_line_id(i) ,
P_TAX_LINE_NUMBER => null ,
P_TAX_AMT => g_suite_rec_tbl.tax_amt(i) ,
P_ENABLED_RECORD => null ,
P_CREATED_BY => null ,
P_CREATION_DATE => null ,
P_LAST_UPDATED_BY => null ,
P_LAST_UPDATE_DATE => null ,
P_LAST_UPDATE_LOGIN => null
); null;
write_message('Service zx_trl_allocations_pkg.Update_row has been called!.');
zx_trl_allocations_pkg.Delete_row
(
X_ROWID => l_row_id ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.entity_code(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.event_class_code(i) ,
P_EVENT_TYPE_CODE => g_suite_rec_tbl.event_type_code(i) ,
P_TRX_ID => g_suite_rec_tbl.trx_id(i)
);
write_message('Service zx_trl_allocations_pkg.Delete_row has been called!.');
ELSIF p_api_service = 'OVERRIDE_SUMMARY_UPDATE_TAX_LINE' THEN
FOR i in g_suite_rec_tbl.application_id.FIRST..g_suite_rec_tbl.application_id.LAST LOOP
select object_version_number
into l_object_version_number
from zx_lines_summary
where application_id =g_suite_rec_tbl.application_id(i)
and entity_code = g_suite_rec_tbl.entity_code(i)
and event_class_code = g_suite_rec_tbl.event_class_code(i)
and trx_id = g_suite_rec_tbl.trx_id(i)
and summary_tax_line_id = g_suite_rec_tbl.summary_tax_line_id(i) ;
P_DELETE_FLAG => null ,
P_TAX_AMT_INCLUDED_FLAG => g_suite_rec_tbl.TAX_AMT_INCLUDED_FLAG(i) ,
P_COMPOUNDING_TAX_FLAG => null ,
P_SELF_ASSESSED_FLAG => g_suite_rec_tbl.SELF_ASSESSED_FLAG(i) ,
P_OVERRIDDEN_FLAG => null ,
P_REPORTING_ONLY_FLAG => null ,
P_ASSOC_CHILD_FROZEN_FLAG => null ,
P_COPIED_FROM_OTHER_DOC_FLAG => null ,
P_MANUALLY_ENTERED_FLAG => g_suite_rec_tbl.MANUALLY_ENTERED_FLAG(i) ,
P_MRC_TAX_LINE_FLAG => null ,
P_LAST_MANUAL_ENTRY => null ,
P_RECORD_TYPE_CODE => null ,
P_TAX_PROVIDER_ID => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_ADJUST_TAX_AMT_FLAG => null ,
P_ATTRIBUTE_CATEGORY => null ,
P_ATTRIBUTE1 => null ,
P_ATTRIBUTE2 => null ,
P_ATTRIBUTE3 => null ,
P_ATTRIBUTE4 => null ,
P_ATTRIBUTE5 => null ,
P_ATTRIBUTE6 => null ,
P_ATTRIBUTE7 => null ,
P_ATTRIBUTE8 => null ,
P_ATTRIBUTE9 => null ,
P_ATTRIBUTE10 => null ,
P_ATTRIBUTE11 => null ,
P_ATTRIBUTE12 => null ,
P_ATTRIBUTE13 => null ,
P_ATTRIBUTE14 => null ,
P_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE_CATEGORY => null ,
P_GLOBAL_ATTRIBUTE1 => null ,
P_GLOBAL_ATTRIBUTE2 => null ,
P_GLOBAL_ATTRIBUTE3 => null ,
P_GLOBAL_ATTRIBUTE4 => null ,
P_GLOBAL_ATTRIBUTE5 => null ,
P_GLOBAL_ATTRIBUTE6 => null ,
P_GLOBAL_ATTRIBUTE7 => null ,
P_GLOBAL_ATTRIBUTE8 => null ,
P_GLOBAL_ATTRIBUTE9 => null ,
P_GLOBAL_ATTRIBUTE10 => null ,
P_GLOBAL_ATTRIBUTE11 => null ,
P_GLOBAL_ATTRIBUTE12 => null ,
P_GLOBAL_ATTRIBUTE13 => null ,
P_GLOBAL_ATTRIBUTE14 => null ,
P_GLOBAL_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE16 => null ,
P_GLOBAL_ATTRIBUTE17 => null ,
P_GLOBAL_ATTRIBUTE18 => null ,
P_GLOBAL_ATTRIBUTE19 => null ,
P_GLOBAL_ATTRIBUTE20 => null ,
P_OBJECT_VERSION_NUMBER => l_object_version_number ,
P_CREATED_BY => 1 , ---------------------------------
P_CREATION_DATE => sysdate , -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for the Who Columns?
P_LAST_UPDATE_DATE => sysdate , -- Review this later.
P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
select object_version_number
into l_object_version_number
from zx_lines_summary
where application_id =g_suite_rec_tbl.application_id(i)
and entity_code = g_suite_rec_tbl.entity_code(i)
and event_class_code = g_suite_rec_tbl.event_class_code(i)
and trx_id = g_suite_rec_tbl.trx_id(i)
and summary_tax_line_id = g_suite_rec_tbl.summary_tax_line_id(i) ;
ZX_TRL_SUMMARY_OVERRIDE_PKG.Update_row(
--X_ROWID => l_row_id ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.SUMMARY_TAX_LINE_ID(i) ,
P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(i),
P_APPLICATION_ID => g_suite_rec_tbl.APPLICATION_ID(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.ENTITY_CODE(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.EVENT_CLASS_CODE(i) ,
P_TRX_ID => g_suite_rec_tbl.TRX_ID(i) ,
P_SUMMARY_TAX_LINE_NUMBER => g_suite_rec_tbl.SUMMARY_TAX_LINE_NUMBER(i) ,
P_TRX_NUMBER => g_suite_rec_tbl.TRX_NUMBER(i) ,
P_APPLIED_FROM_APPLICATION_ID => null ,
P_APPLIED_FROM_EVT_CLASS_CODE => null ,
P_APPLIED_FROM_ENTITY_CODE => null ,
P_APPLIED_FROM_TRX_ID => null ,
P_APPLIED_FROM_TRX_LEVEL_TYPE => null ,
P_APPLIED_FROM_LINE_ID => null ,
P_ADJUSTED_DOC_APPLICATION_ID => null ,
P_ADJUSTED_DOC_ENTITY_CODE => g_suite_rec_tbl.adjusted_doc_entity_code(i),
P_ADJUSTED_DOC_EVT_CLASS_CODE => null ,
P_ADJUSTED_DOC_TRX_ID => null ,
P_ADJUSTED_DOC_TRX_LEVEL_TYPE => null ,
P_APPLIED_TO_APPLICATION_ID => null ,
P_APPLIED_TO_EVENT_CLASS_CODE => null ,
P_APPLIED_TO_ENTITY_CODE => null ,
P_APPLIED_TO_TRX_ID => null ,
P_APPLIED_TO_TRX_LEVEL_TYPE => null ,
P_APPLIED_TO_LINE_ID => null ,
P_TAX_EXEMPTION_ID => null ,
P_TAX_RATE_BEFORE_EXEMPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXEMPT => null ,
P_EXEMPT_RATE_MODIFIER => null ,
P_EXEMPT_CERTIFICATE_NUMBER => null ,
P_EXEMPT_REASON => null ,
P_EXEMPT_REASON_CODE => null ,
P_TAX_RATE_BEFORE_EXCEPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXCEPT => null ,
P_TAX_EXCEPTION_ID => null ,
P_EXCEPTION_RATE => null ,
P_CONTENT_OWNER_ID => null ,
P_TAX_REGIME_CODE => g_suite_rec_tbl.TAX_REGIME_CODE(i) ,
P_TAX => g_suite_rec_tbl.TAX(i) ,
P_TAX_STATUS_ID => null ,
P_TAX_STATUS_CODE => g_suite_rec_tbl.TAX_STATUS_CODE(i) ,
P_TAX_RATE_ID => g_suite_rec_tbl.TAX_RATE_ID(i) ,
P_TAX_RATE_CODE => g_suite_rec_tbl.TAX_RATE_CODE(i) ,
P_TAX_RATE => g_suite_rec_tbl.TAX_RATE(i) ,
P_TAX_AMT => g_suite_rec_tbl.TAX_AMT(i) ,
P_TAX_AMT_TAX_CURR => null ,
P_TAX_AMT_FUNCL_CURR => null ,
P_TAX_JURISDICTION_CODE => null ,
P_TOTAL_REC_TAX_AMT => g_suite_rec_tbl.TOTAL_REC_TAX_AMT(i) ,
P_TOTAL_REC_TAX_AMT_FUNC_CURR => null ,
P_TOTAL_REC_TAX_AMT_TAX_CURR => null ,
P_TOTAL_NREC_TAX_AMT => g_suite_rec_tbl.TOTAL_NREC_TAX_AMT(i) ,
P_TOTAL_NREC_TAX_AMT_FUNC_CURR => null ,
P_TOTAL_NREC_TAX_AMT_TAX_CURR => null ,
P_LEDGER_ID => g_suite_rec_tbl.LEDGER_ID(i) ,
P_LEGAL_ENTITY_ID => null ,
P_ESTABLISHMENT_ID => null ,
P_CURRENCY_CONVERSION_DATE => null ,
P_CURRENCY_CONVERSION_TYPE => null ,
P_CURRENCY_CONVERSION_RATE => null ,
P_SUMMARIZATION_TEMPLATE_ID => null ,
P_TAXABLE_BASIS_FORMULA => null ,
P_TAX_CALCULATION_FORMULA => null ,
P_HISTORICAL_FLAG => null ,
P_CANCEL_FLAG => g_suite_rec_tbl.CANCEL_FLAG(i) ,
P_DELETE_FLAG => null ,
P_TAX_AMT_INCLUDED_FLAG => g_suite_rec_tbl.TAX_AMT_INCLUDED_FLAG(i) ,
P_COMPOUNDING_TAX_FLAG => null ,
P_SELF_ASSESSED_FLAG => g_suite_rec_tbl.SELF_ASSESSED_FLAG(i) ,
P_OVERRIDDEN_FLAG => null ,
P_REPORTING_ONLY_FLAG => null ,
P_ASSOC_CHILD_FROZEN_FLAG => null ,
P_COPIED_FROM_OTHER_DOC_FLAG => null ,
P_MANUALLY_ENTERED_FLAG => g_suite_rec_tbl.MANUALLY_ENTERED_FLAG(i) ,
P_MRC_TAX_LINE_FLAG => null ,
P_LAST_MANUAL_ENTRY => null ,
P_RECORD_TYPE_CODE => null ,
P_TAX_PROVIDER_ID => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_ADJUST_TAX_AMT_FLAG => null ,
--P_EVENT_ID => null ,
--P_CTRL_EF_OV_CAL_LINE_FLAG => null ,
P_ATTRIBUTE_CATEGORY => null ,
P_ATTRIBUTE1 => null ,
P_ATTRIBUTE2 => null ,
P_ATTRIBUTE3 => null ,
P_ATTRIBUTE4 => null ,
P_ATTRIBUTE5 => null ,
P_ATTRIBUTE6 => null ,
P_ATTRIBUTE7 => null ,
P_ATTRIBUTE8 => null ,
P_ATTRIBUTE9 => null ,
P_ATTRIBUTE10 => null ,
P_ATTRIBUTE11 => null ,
P_ATTRIBUTE12 => null ,
P_ATTRIBUTE13 => null ,
P_ATTRIBUTE14 => null ,
P_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE_CATEGORY => null ,
P_GLOBAL_ATTRIBUTE1 => null ,
P_GLOBAL_ATTRIBUTE2 => null ,
P_GLOBAL_ATTRIBUTE3 => null ,
P_GLOBAL_ATTRIBUTE4 => null ,
P_GLOBAL_ATTRIBUTE5 => null ,
P_GLOBAL_ATTRIBUTE6 => null ,
P_GLOBAL_ATTRIBUTE7 => null ,
P_GLOBAL_ATTRIBUTE8 => null ,
P_GLOBAL_ATTRIBUTE9 => null ,
P_GLOBAL_ATTRIBUTE10 => null ,
P_GLOBAL_ATTRIBUTE11 => null ,
P_GLOBAL_ATTRIBUTE12 => null ,
P_GLOBAL_ATTRIBUTE13 => null ,
P_GLOBAL_ATTRIBUTE14 => null ,
P_GLOBAL_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE16 => null ,
P_GLOBAL_ATTRIBUTE17 => null ,
P_GLOBAL_ATTRIBUTE18 => null ,
P_GLOBAL_ATTRIBUTE19 => null ,
P_GLOBAL_ATTRIBUTE20 => null ,
P_OBJECT_VERSION_NUMBER => l_object_version_number+1 ,
--P_CREATED_BY => 1 , ---------------------------------
--P_CREATION_DATE => sysdate , -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for the Who Columns?
P_LAST_UPDATE_DATE => sysdate , -- Review this later.
P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
write_message('Service zx_trl_allocations_pkg.Delete_row has been called!.');
ELSIF p_api_service = 'OVERRIDE_SUMMARY_DELETE_TAX_LINE' THEN
----------------------------------------------
-- Get inital and ending row for the structure
----------------------------------------------
get_start_end_rows_structure
(
p_suite => p_suite_number,
p_case => p_case_number,
p_structure => 'STRUCTURE_OVERRIDE_SUMMARY_TAX_LINES',
x_start_row => l_start_row,
x_end_row => l_end_row
);
write_message('Calculating for OVERRIDE_SUMMARY_DELETE_TAX_LINE');
select object_version_number
into l_object_version_number
from zx_lines_summary
where application_id =g_suite_rec_tbl.application_id(i)
and entity_code = g_suite_rec_tbl.entity_code(i)
and event_class_code = g_suite_rec_tbl.event_class_code(i)
and trx_id = g_suite_rec_tbl.trx_id(i)
and summary_tax_line_id = g_suite_rec_tbl.summary_tax_line_id(i) ;
ZX_TRL_SUMMARY_OVERRIDE_PKG.Delete_row(
X_ROWID => l_row_id ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.SUMMARY_TAX_LINE_ID(i) ,
P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(i),
P_APPLICATION_ID => g_suite_rec_tbl.APPLICATION_ID(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.ENTITY_CODE(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.EVENT_CLASS_CODE(i) ,
P_TRX_ID => g_suite_rec_tbl.TRX_ID(i) ,
P_SUMMARY_TAX_LINE_NUMBER => g_suite_rec_tbl.SUMMARY_TAX_LINE_NUMBER(i) ,
P_TRX_NUMBER => g_suite_rec_tbl.TRX_NUMBER(i) ,
P_APPLIED_FROM_APPLICATION_ID => null ,
P_APPLIED_FROM_EVT_CLASS_CODE => null ,
P_APPLIED_FROM_ENTITY_CODE => null ,
P_APPLIED_FROM_TRX_ID => null ,
P_APPLIED_FROM_TRX_LEVEL_TYPE => null ,
P_APPLIED_FROM_LINE_ID => null ,
P_ADJUSTED_DOC_APPLICATION_ID => null ,
P_ADJUSTED_DOC_ENTITY_CODE => g_suite_rec_tbl.adjusted_doc_entity_code(i),
P_ADJUSTED_DOC_EVT_CLASS_CODE => null ,
P_ADJUSTED_DOC_TRX_ID => null ,
P_ADJUSTED_DOC_TRX_LEVEL_TYPE => null ,
P_APPLIED_TO_APPLICATION_ID => null ,
P_APPLIED_TO_EVENT_CLASS_CODE => null ,
P_APPLIED_TO_ENTITY_CODE => null ,
P_APPLIED_TO_TRX_ID => null ,
P_APPLIED_TO_TRX_LEVEL_TYPE => null ,
P_APPLIED_TO_LINE_ID => null ,
P_TAX_EXEMPTION_ID => null ,
P_TAX_RATE_BEFORE_EXEMPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXEMPT => null ,
P_EXEMPT_RATE_MODIFIER => null ,
P_EXEMPT_CERTIFICATE_NUMBER => null ,
P_EXEMPT_REASON => null ,
P_EXEMPT_REASON_CODE => null ,
P_TAX_RATE_BEFORE_EXCEPTION => null ,
P_TAX_RATE_NAME_BEFORE_EXCEPT => null ,
P_TAX_EXCEPTION_ID => null ,
P_EXCEPTION_RATE => null ,
P_CONTENT_OWNER_ID => null ,
P_TAX_REGIME_CODE => g_suite_rec_tbl.TAX_REGIME_CODE(i) ,
P_TAX => g_suite_rec_tbl.TAX(i) ,
P_TAX_STATUS_CODE => g_suite_rec_tbl.TAX_STATUS_CODE(i) ,
P_TAX_RATE_ID => g_suite_rec_tbl.TAX_RATE_ID(i) ,
P_TAX_RATE_CODE => g_suite_rec_tbl.TAX_RATE_CODE(i) ,
P_TAX_RATE => g_suite_rec_tbl.TAX_RATE(i) ,
P_TAX_AMT => g_suite_rec_tbl.TAX_AMT(i) ,
P_TAX_AMT_TAX_CURR => null ,
P_TAX_AMT_FUNCL_CURR => null ,
P_TAX_JURISDICTION_CODE => null ,
P_TOTAL_REC_TAX_AMT => g_suite_rec_tbl.TOTAL_REC_TAX_AMT(i) ,
P_TOTAL_REC_TAX_AMT_FUNC_CURR => null ,
P_TOTAL_REC_TAX_AMT_TAX_CURR => null ,
P_TOTAL_NREC_TAX_AMT => g_suite_rec_tbl.TOTAL_NREC_TAX_AMT(i) ,
P_TOTAL_NREC_TAX_AMT_FUNC_CURR => null ,
P_TOTAL_NREC_TAX_AMT_TAX_CURR => null ,
P_LEDGER_ID => g_suite_rec_tbl.LEDGER_ID(i) ,
P_LEGAL_ENTITY_ID => null ,
P_ESTABLISHMENT_ID => null ,
P_CURRENCY_CONVERSION_DATE => null ,
P_CURRENCY_CONVERSION_TYPE => null ,
P_CURRENCY_CONVERSION_RATE => null ,
P_SUMMARIZATION_TEMPLATE_ID => null ,
P_TAXABLE_BASIS_FORMULA => null ,
P_TAX_CALCULATION_FORMULA => null ,
P_HISTORICAL_FLAG => null ,
P_CANCEL_FLAG => g_suite_rec_tbl.CANCEL_FLAG(i) ,
P_DELETE_FLAG => null ,
P_TAX_AMT_INCLUDED_FLAG => g_suite_rec_tbl.TAX_AMT_INCLUDED_FLAG(i) ,
P_COMPOUNDING_TAX_FLAG => null ,
P_SELF_ASSESSED_FLAG => g_suite_rec_tbl.SELF_ASSESSED_FLAG(i) ,
P_OVERRIDDEN_FLAG => null ,
P_REPORTING_ONLY_FLAG => null ,
P_ASSOC_CHILD_FROZEN_FLAG => null ,
P_COPIED_FROM_OTHER_DOC_FLAG => null ,
P_MANUALLY_ENTERED_FLAG => g_suite_rec_tbl.MANUALLY_ENTERED_FLAG(i) ,
P_MRC_TAX_LINE_FLAG => null ,
P_LAST_MANUAL_ENTRY => null ,
P_RECORD_TYPE_CODE => null ,
P_TAX_PROVIDER_ID => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_ADJUST_TAX_AMT_FLAG => null ,
P_ATTRIBUTE_CATEGORY => null ,
P_ATTRIBUTE1 => null ,
P_ATTRIBUTE2 => null ,
P_ATTRIBUTE3 => null ,
P_ATTRIBUTE4 => null ,
P_ATTRIBUTE5 => null ,
P_ATTRIBUTE6 => null ,
P_ATTRIBUTE7 => null ,
P_ATTRIBUTE8 => null ,
P_ATTRIBUTE9 => null ,
P_ATTRIBUTE10 => null ,
P_ATTRIBUTE11 => null ,
P_ATTRIBUTE12 => null ,
P_ATTRIBUTE13 => null ,
P_ATTRIBUTE14 => null ,
P_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE_CATEGORY => null ,
P_GLOBAL_ATTRIBUTE1 => null ,
P_GLOBAL_ATTRIBUTE2 => null ,
P_GLOBAL_ATTRIBUTE3 => null ,
P_GLOBAL_ATTRIBUTE4 => null ,
P_GLOBAL_ATTRIBUTE5 => null ,
P_GLOBAL_ATTRIBUTE6 => null ,
P_GLOBAL_ATTRIBUTE7 => null ,
P_GLOBAL_ATTRIBUTE8 => null ,
P_GLOBAL_ATTRIBUTE9 => null ,
P_GLOBAL_ATTRIBUTE10 => null ,
P_GLOBAL_ATTRIBUTE11 => null ,
P_GLOBAL_ATTRIBUTE12 => null ,
P_GLOBAL_ATTRIBUTE13 => null ,
P_GLOBAL_ATTRIBUTE14 => null ,
P_GLOBAL_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE16 => null ,
P_GLOBAL_ATTRIBUTE17 => null ,
P_GLOBAL_ATTRIBUTE18 => null ,
P_GLOBAL_ATTRIBUTE19 => null ,
P_GLOBAL_ATTRIBUTE20 => null ,
P_OBJECT_VERSION_NUMBER => l_object_version_number ,
P_CREATED_BY => 1 , -------------------------------
P_CREATION_DATE => sysdate , -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for who columns?
P_LAST_UPDATE_LOGIN => 1 , -- Review this later.
P_LAST_UPDATE_DATE => sysdate); -------------------------------
ELSIF p_api_service = 'OVERRIDE_DISTRIBUTION_UPDATE_TAX_LINE' THEN
-----------------------------------------------------------
-- Proceeds to Call the Lock_row and Update_row API
-----------------------------------------------------------
FOR i in g_suite_rec_tbl.application_id.FIRST..g_suite_rec_tbl.application_id.LAST LOOP
select object_version_number
into l_object_version_number
from ZX_REC_NREC_DIST
where application_id =g_suite_rec_tbl.application_id(i)
and entity_code = g_suite_rec_tbl.entity_code(i)
and event_class_code = g_suite_rec_tbl.event_class_code(i)
and trx_id = g_suite_rec_tbl.trx_id(i)
and trx_line_id = g_suite_rec_tbl.trx_line_id(i)
and trx_level_type = g_suite_rec_tbl.trx_level_type(i)
and REC_NREC_TAX_DIST_ID = g_suite_rec_tbl.REC_NREC_TAX_DIST_ID(i) ;
P_LAST_UPDATED_BY => 1 , -- to pass for who columns?
P_LAST_UPDATE_LOGIN => 1 , -- Review this later.
P_LAST_UPDATE_DATE => sysdate); -------------------------------
select object_version_number
into l_object_version_number
from ZX_REC_NREC_DIST
where application_id =g_suite_rec_tbl.application_id(i)
and entity_code = g_suite_rec_tbl.entity_code(i)
and event_class_code = g_suite_rec_tbl.event_class_code(i)
and trx_id = g_suite_rec_tbl.trx_id(i)
and trx_line_id = g_suite_rec_tbl.trx_line_id(i)
and trx_level_type = g_suite_rec_tbl.trx_level_type(i)
and REC_NREC_TAX_DIST_ID = g_suite_rec_tbl.REC_NREC_TAX_DIST_ID(i) ;
ZX_TRL_DISTRIBUTIONS_PKG.Update_row(
-- X_ROWID => l_row_id ,
P_REC_NREC_TAX_DIST_ID => g_suite_rec_tbl.rec_nrec_tax_dist_id(i) ,
P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,
P_ENTITY_CODE => g_suite_rec_tbl.entity_code(i) ,
P_EVENT_CLASS_CODE => g_suite_rec_tbl.event_class_code(i) ,
P_EVENT_TYPE_CODE => g_suite_rec_tbl.event_type_code(i) ,
P_TRX_ID => g_suite_rec_tbl.trx_id(i) ,
P_TRX_NUMBER => null ,
P_TRX_LINE_ID => g_suite_rec_tbl.trx_line_id(i) ,
P_TRX_LINE_NUMBER => g_suite_rec_tbl.trx_line_number(i) ,
P_TAX_LINE_ID => g_suite_rec_tbl.tax_line_id(i) ,
P_TAX_LINE_NUMBER => null ,
P_TRX_LINE_DIST_ID => g_suite_rec_tbl.trx_line_dist_id(i) ,
P_TRX_LEVEL_TYPE => null ,
P_ITEM_DIST_NUMBER => g_suite_rec_tbl.item_dist_number(i) ,
P_REC_NREC_TAX_DIST_NUMBER => null ,
P_REC_NREC_RATE => null ,
P_RECOVERABLE_FLAG => null ,
P_REC_NREC_TAX_AMT => g_suite_rec_tbl.rec_nrec_tax_amt(i) ,
P_TAX_EVENT_CLASS_CODE => null ,
P_TAX_EVENT_TYPE_CODE => null ,
P_CONTENT_OWNER_ID => null ,
P_TAX_REGIME_ID => null ,
P_TAX_REGIME_CODE => g_suite_rec_tbl.tax_regime_code(i) ,
P_TAX_ID => null ,
P_TAX => g_suite_rec_tbl.tax(i) ,
P_TAX_STATUS_ID => null ,
P_TAX_STATUS_CODE => g_suite_rec_tbl.tax_status_code(i) ,
P_TAX_RATE_ID => g_suite_rec_tbl.tax_rate_id(i) ,
P_TAX_RATE_CODE => g_suite_rec_tbl.tax_rate_code(i) ,
P_TAX_RATE => g_suite_rec_tbl.tax_rate(i) ,
P_INCLUSIVE_FLAG => null ,
P_RECOVERY_TYPE_ID => null ,
P_RECOVERY_TYPE_CODE => g_suite_rec_tbl.recovery_type_code(i) ,
P_RECOVERY_RATE_ID => null ,
P_RECOVERY_RATE_CODE => g_suite_rec_tbl.recovery_rate_code(i) ,
P_REC_TYPE_RULE_FLAG => null ,
P_NEW_REC_RATE_CODE_FLAG => null ,
P_REVERSE_FLAG => g_suite_rec_tbl.reverse_flag(i) ,
P_HISTORICAL_FLAG => g_suite_rec_tbl.historical_flag(i) ,
P_REVERSED_TAX_DIST_ID => g_suite_rec_tbl.reversed_tax_dist_id(i) ,
P_REC_NREC_TAX_AMT_TAX_CURR => null ,
P_REC_NREC_TAX_AMT_FUNCL_CURR => g_suite_rec_tbl.rec_nrec_tax_amt_funcl_curr(i),
P_INTENDED_USE => null ,
P_PROJECT_ID => g_suite_rec_tbl.project_id(i) ,
P_TASK_ID => g_suite_rec_tbl.task_id(i) ,
P_AWARD_ID => g_suite_rec_tbl.award_id(i) ,
P_EXPENDITURE_TYPE => g_suite_rec_tbl.expenditure_type(i) ,
P_EXPENDITURE_ORGANIZATION_ID => g_suite_rec_tbl.expenditure_organization_id(i),
P_EXPENDITURE_ITEM_DATE => g_suite_rec_tbl.expenditure_item_date(i) ,
P_REC_RATE_DET_RULE_FLAG => null ,
P_LEDGER_ID => g_suite_rec_tbl.ledger_id(i) ,
P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
P_RECORD_TYPE_CODE => null ,
P_CURRENCY_CONVERSION_DATE => g_suite_rec_tbl.currency_conversion_date(i),
P_CURRENCY_CONVERSION_TYPE => g_suite_rec_tbl.currency_conversion_type(i),
P_CURRENCY_CONVERSION_RATE => g_suite_rec_tbl.currency_conversion_rate(i),
P_TAX_CURRENCY_CONVERSION_DATE => null ,
P_TAX_CURRENCY_CONVERSION_TYPE => null ,
P_TAX_CURRENCY_CONVERSION_RATE => null ,
P_TRX_CURRENCY_CODE => g_suite_rec_tbl.trx_currency_code(i) ,
P_TAX_CURRENCY_CODE => null ,
P_TRX_LINE_DIST_QTY => null ,
P_REF_DOC_TRX_LINE_DIST_QTY => null ,
P_PRICE_DIFF => null ,
P_QTY_DIFF => null ,
P_PER_TRX_CURR_UNIT_NR_AMT => null ,
P_REF_PER_TRX_CURR_UNIT_NR_AMT => null ,
P_REF_DOC_CURR_CONV_RATE => null ,
P_UNIT_PRICE => null ,
P_REF_DOC_UNIT_PRICE => null ,
P_PER_UNIT_NREC_TAX_AMT => null ,
P_REF_DOC_PER_UNIT_NREC_TAX_AM => null ,
P_RATE_TAX_FACTOR => null ,
P_TAX_APPORTIONMENT_FLAG => null ,
P_TRX_LINE_DIST_AMT => g_suite_rec_tbl.trx_line_dist_amt(i) ,
P_TRX_LINE_DIST_TAX_AMT => null ,
P_ORIG_REC_NREC_RATE => null ,
P_ORIG_REC_RATE_CODE => null ,
P_ORIG_REC_NREC_TAX_AMT => null ,
P_ORIG_REC_NREC_TAX_AMT_TAX_CU => null ,
P_ACCOUNT_CCID => null ,
P_ACCOUNT_STRING => null ,
P_UNROUNDED_REC_NREC_TAX_AMT => null ,
P_APPLICABILITY_RESULT_ID => null ,
P_REC_RATE_RESULT_ID => null ,
P_BACKWARD_COMPATIBILITY_FLAG => null ,
P_OVERRIDDEN_FLAG => null ,
P_SELF_ASSESSED_FLAG => g_suite_rec_tbl.self_assessed_flag(i) ,
P_FREEZE_FLAG => g_suite_rec_tbl.freeze_flag(i) ,
P_POSTING_FLAG => g_suite_rec_tbl.posting_flag(i) ,
P_GL_DATE => null ,
P_REF_DOC_APPLICATION_ID => null ,
P_REF_DOC_ENTITY_CODE => null ,
P_REF_DOC_EVENT_CLASS_CODE => null ,
P_REF_DOC_TRX_ID => null ,
P_REF_DOC_TRX_LEVEL_TYPE => null ,
P_REF_DOC_LINE_ID => null ,
P_REF_DOC_DIST_ID => null ,
P_MINIMUM_ACCOUNTABLE_UNIT => null ,
P_PRECISION => null ,
P_ROUNDING_RULE_CODE => null ,
P_TAXABLE_AMT => null ,
P_TAXABLE_AMT_TAX_CURR => null ,
P_TAXABLE_AMT_FUNCL_CURR => null ,
P_TAX_ONLY_LINE_FLAG => null ,
P_UNROUNDED_TAXABLE_AMT => null ,
P_LEGAL_ENTITY_ID => null ,
P_PRD_TAX_AMT => null ,
P_PRD_TAX_AMT_TAX_CURR => null ,
P_PRD_TAX_AMT_FUNCL_CURR => null ,
P_PRD_TOTAL_TAX_AMT => null ,
P_PRD_TOTAL_TAX_AMT_TAX_CURR => null ,
P_PRD_TOTAL_TAX_AMT_FUNCL_CURR => null ,
P_APPLIED_FROM_TAX_DIST_ID => null ,
P_APPL_TO_DOC_CURR_CONV_RATE => null ,
P_ADJUSTED_DOC_TAX_DIST_ID => null ,
P_FUNC_CURR_ROUNDING_ADJUST => null ,
P_TAX_APPORTIONMENT_LINE_NUM => null ,
P_LAST_MANUAL_ENTRY => null ,
P_REF_DOC_TAX_DIST_ID => null ,
P_MRC_TAX_DIST_FLAG => null ,
P_MRC_LINK_TO_TAX_DIST_ID => null ,
/* P_HDR_TRX_USER_KEY1 => null ,
P_HDR_TRX_USER_KEY2 => null ,
P_HDR_TRX_USER_KEY3 => null ,
P_HDR_TRX_USER_KEY4 => null ,
P_HDR_TRX_USER_KEY5 => null ,
P_HDR_TRX_USER_KEY6 => null ,
P_LINE_TRX_USER_KEY1 => null ,
P_LINE_TRX_USER_KEY2 => null ,
P_LINE_TRX_USER_KEY3 => null ,
P_LINE_TRX_USER_KEY4 => null ,
P_LINE_TRX_USER_KEY5 => null ,
P_LINE_TRX_USER_KEY6 => null ,
P_DIST_TRX_USER_KEY1 => null ,
P_DIST_TRX_USER_KEY2 => null ,
P_DIST_TRX_USER_KEY3 => null ,
P_DIST_TRX_USER_KEY4 => null ,
P_DIST_TRX_USER_KEY5 => null ,
P_DIST_TRX_USER_KEY6 => null ,
P_REPORTING_CURRENCY_CODE => null ,
P_INTERNAL_ORGANIZATION_ID => null ,*/
P_ATTRIBUTE_CATEGORY => null ,
P_ATTRIBUTE1 => null ,
P_ATTRIBUTE2 => null ,
P_ATTRIBUTE3 => null ,
P_ATTRIBUTE4 => null ,
P_ATTRIBUTE5 => null ,
P_ATTRIBUTE6 => null ,
P_ATTRIBUTE7 => null ,
P_ATTRIBUTE8 => null ,
P_ATTRIBUTE9 => null ,
P_ATTRIBUTE10 => null ,
P_ATTRIBUTE11 => null ,
P_ATTRIBUTE12 => null ,
P_ATTRIBUTE13 => null ,
P_ATTRIBUTE14 => null ,
P_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE_CATEGORY => null ,
P_GLOBAL_ATTRIBUTE1 => null ,
P_GLOBAL_ATTRIBUTE2 => null ,
P_GLOBAL_ATTRIBUTE3 => null ,
P_GLOBAL_ATTRIBUTE4 => null ,
P_GLOBAL_ATTRIBUTE5 => null ,
P_GLOBAL_ATTRIBUTE6 => null ,
P_GLOBAL_ATTRIBUTE7 => null ,
P_GLOBAL_ATTRIBUTE8 => null ,
P_GLOBAL_ATTRIBUTE9 => null ,
P_GLOBAL_ATTRIBUTE10 => null ,
P_GLOBAL_ATTRIBUTE11 => null ,
P_GLOBAL_ATTRIBUTE12 => null ,
P_GLOBAL_ATTRIBUTE13 => null ,
P_GLOBAL_ATTRIBUTE14 => null ,
P_GLOBAL_ATTRIBUTE15 => null ,
P_GLOBAL_ATTRIBUTE16 => null ,
P_GLOBAL_ATTRIBUTE17 => null ,
P_GLOBAL_ATTRIBUTE18 => null ,
P_GLOBAL_ATTRIBUTE19 => null ,
P_GLOBAL_ATTRIBUTE20 => null ,
P_ORIG_AP_CHRG_DIST_NUM => null ,
P_ORIG_AP_CHRG_DIST_ID => null ,
P_ORIG_AP_TAX_DIST_NUM => null ,
P_ORIG_AP_TAX_DIST_ID => null ,
P_OBJECT_VERSION_NUMBER => l_object_version_number+1 ,
-- P_CREATED_BY => 1 , -------------------------------
-- P_CREATION_DATE => sysdate , -- What are the correct values
P_LAST_UPDATED_BY => 1 , -- to pass for who columns?
P_LAST_UPDATE_LOGIN => 1 , -- Review this later.
P_LAST_UPDATE_DATE => sysdate); -------------------------------
ELSIF p_api_service = 'GLOBAL_DOCUMENT_UPDATE' THEN
-----------------------------------------------------------
-- Proceeds to Call the API Synchronize Tax Repository
-----------------------------------------------------------
zx_api_pub.global_document_update (
l_api_version ,
l_init_msg_list ,
l_commit ,
l_validation_level ,
l_return_status ,
l_msg_count ,
l_msg_data ,
g_transaction_rec );
write_message('Service ZX_API_PUB.GLOBAL_DOCUMENT_UPDATE has been called!. ');
ELSIF p_api_service = 'MARK_TAX_LINES_DELETED' THEN
-----------------------------------------------------------
-- Proceeds to Call the API Synchronize Tax Repository
-----------------------------------------------------------
zx_api_pub.mark_tax_lines_deleted (
l_api_version ,
l_init_msg_list ,
l_commit ,
l_validation_level ,
l_return_status ,
l_msg_count ,
l_msg_data ,
g_transaction_line_rec);
write_message('Service ZX_API_PUB.MARK_TAX_LINES_DELETED has been called!. ');
insert_rows_tax_dist_id_gt(p_transaction_id);
insert_row_transaction_rec(g_transaction_rec,l_initial_row);
write_message('After inserting row_transaction_rec ');
Select event_type_code into g_transaction_rec.event_type_code
FROM zx_evnt_typ_mappings
WHERE application_id = g_suite_rec_tbl.APPLICATION_ID(l_initial_row)
AND entity_code = g_suite_rec_tbl.ENTITY_CODE(l_initial_row)
AND event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(l_initial_row)
AND tax_event_type_code = 'UPDATE';
Insert into zx_trx_headers_gt
( INTERNAL_ORGANIZATION_ID,
APPLICATION_ID,
ENTITY_CODE,
EVENT_CLASS_CODE,
EVENT_TYPE_CODE,
TRX_ID,
TRX_DATE,
TRX_CURRENCY_CODE,
PRECISION,
LEGAL_ENTITY_ID)
SELECT INTERNAL_ORGANIZATION_ID,
APPLICATION_ID,
ENTITY_CODE,
EVENT_CLASS_CODE,
G_TRANSACTION_REC.EVENT_TYPE_CODE,
TRX_ID,
TRX_DATE,
TRX_CURRENCY_CODE,
PRECISION,
LEGAL_ENTITY_ID
FROM zx_lines
WHERE trx_id = p_transaction_id
AND tax_only_line_flag= 'N';
/* Insert into zx_transaction_lines_gt
( APPLICATION_ID,
ENTITY_CODE,
EVENT_CLASS_CODE,
TRX_LEVEL_TYPE,
LINE_LEVEL_ACTION,
TRX_BUSINESS_CATEGORY,
LINE_AMT,
TRX_LINE_QUANTITY,
UNIT_PRICE,
--UOM_CODE, --Commented for V6 Changes.
TRX_LINE_GL_DATE,
LINE_AMT_INCLUDES_TAX_FLAG)
SELECT APPLICATION_ID,
ENTITY_CODE,
EVENT_CLASS_CODE,
TRX_LEVEL_TYPE,
'DISCARD',
TRX_BUSINESS_CATEGORY,
LINE_AMT,
TRX_LINE_QUANTITY,
UNIT_PRICE,
--UOM_CODE, -- Commented for V6 Changes.
sysdate, --TRX_LINE_GL_DATE, -- Commented for V6 changes.
'A' --LINE_AMT_INCLUDES_TAX_FLAG -- Commented for V6 Changes.
FROM zx_lines
WHERE trx_id = p_transaction_id
AND tax_only_line_flag= 'N'; */
SELECT 'X' into l_flag
FROM zx_lines
WHERE trx_id = p_transaction_id
AND tax_only_line_flag= 'Y';
insert_into_rev_dist_lines_gt(p_transaction_id);
Select event_type_code into g_transaction_rec.event_type_code
FROM zx_evnt_typ_mappings
WHERE application_id = g_suite_rec_tbl.APPLICATION_ID(l_initial_row)
AND entity_code = g_suite_rec_tbl.ENTITY_CODE(l_initial_row)
AND event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(l_initial_row)
AND tax_event_type_code = 'CANCEL';
zx_api_pub.global_document_update (
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
p_commit => l_commit,
p_validation_level => l_validation_level ,
x_return_status => l_return_status ,
x_msg_count => l_msg_count ,
x_msg_data => l_msg_data ,
p_transaction_rec => g_transaction_rec );
write_message('Service ZX_API_PUB.GLOBAL_DOCUMENT_FOR_UPDATE has been called');
Select event_type_code into g_transaction_rec.event_type_code
FROM zx_evnt_typ_mappings
WHERE application_id = g_suite_rec_tbl.APPLICATION_ID(l_initial_row)
AND entity_code = g_suite_rec_tbl.ENTITY_CODE(l_initial_row)
AND event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(l_initial_row)
AND tax_event_type_code = 'RELEASE_HOLD';
zx_api_pub.global_document_update (
p_api_version => l_api_version ,
p_init_msg_list => l_init_msg_list ,
p_commit => l_commit,
p_validation_level => l_validation_level ,
x_return_status => l_return_status ,
x_msg_count => l_msg_count ,
x_msg_data => l_msg_data ,
p_transaction_rec => g_transaction_rec );
write_message('Service ZX_API_PUB.GLOBAL_DOCUMENT_UPDATE has been called ');
| PROCEDURE insert_into_gts : Logic to Insert in the Global Temporary Tables, |
| Records or Records of Tables |
* ====================================================================================*/
PROCEDURE insert_into_gts (p_suite_number IN VARCHAR2,
p_case_number IN VARCHAR2,
p_service IN VARCHAR2,
p_structure IN VARCHAR2,
p_header_row_id IN NUMBER,
p_starting_row_id IN NUMBER,
p_ending_row_id IN NUMBER,
p_prev_trx_id IN NUMBER) IS
l_trx_id NUMBER;
insert_data_trx_headers_gt(p_header_row_id);
write_message('Row has been inserted in ZX_TRX_HEADERS_GT!');
insert_data_trx_lines_gt(p_header_row_id,
p_starting_row_id,
p_ending_row_id);
write_message('Row(s) have been inserted in TRX_LINES_GT!');
insert_data_mrc_gt(p_header_row_id);
write_message('Row(s) have been inserted in ZX_MRC_GT!');
DELETE from ZX_TRX_HEADERS_GT
WHERE trx_id = g_suite_rec_tbl.TRX_ID(p_header_row_id);
write_message('--Row for Calculate has been deleted from ZX_TRX_HEADERS_GT!!!');
insert_data_trx_headers_gt(l_header_row);
write_message('--Row for Recovery has been inserted in ZX_TRX_HEADERS_GT!!!');
insert_itm_distributions_gt
(
p_header_row => l_header_row,
p_sta_row_item_dist => l_initial_row,
p_end_row_item_dist => l_ending_row
);
write_message('--Row(s) has been inserted in ZX_ITM_DISTRIBUTIONS_GT!!!');
insert_data_mrc_gt(p_header_row_id);
write_message('--Row(s) have been inserted in ZX_MRC_GT!');
insert_sync_trx_rec(
p_header_row => p_header_row_id,
x_sync_trx_rec => g_sync_trx_rec);
write_message('A row has been inserted in g_sync_trx_rec.');
insert_sync_trx_lines_tbl(
p_header_row => p_header_row_id,
p_starting_row_sync_trx_lines => p_starting_row_id,
p_ending_row_sync_trx_lines => p_ending_row_id,
x_sync_trx_lines_tbl => g_sync_trx_lines_tbl);
write_message('Rows have been inserted in g_sync_trx_lines_tbl.');
insert_data_trx_headers_gt(p_header_row_id);
write_message('-- A row has been inserted in ZX_TRX_HEADERS_GT!!!');
insert_row_transaction_rec(g_transaction_rec,l_initial_row);
write_message('-- A row has been inserted in TRANSACTION RECORD!!!');
ELSIF p_service = 'GLOBAL_DOCUMENT_UPDATE' THEN
--------------------------
--Insert the row in the GT
--------------------------
insert_transaction_rec(g_transaction_rec);
write_message('A row has been inserted in transaction_rec.');
ELSIF p_service = 'MARK_TAX_LINES_DELETED' THEN
-----------------------------------------------------------
-- Logic to get the start and end number in the case
-----------------------------------------------------------
get_start_end_rows_structure
(
p_suite => p_suite_number,
p_case => p_case_number,
p_structure => 'STRUCTURE_TRANSACTION_LINE_RECORD',
x_start_row => l_initial_row,
x_end_row => l_ending_row
);
insert_transaction_line_rec(g_transaction_line_rec,
l_initial_row);
insert_data_trx_headers_gt(p_header_row_id);
write_message('Row has been inserted in ZX_TRX_HEADERS_GT!');
insert_data_trx_lines_gt(p_header_row_id,
l_initial_row,
l_ending_row);
write_message('Row(s) have been inserted in TRX_LINES_GT!');
insert_import_sum_tax_lines_gt(
p_starting_row_tax_lines => l_initial_row,
p_ending_row_tax_lines => l_ending_row);
write_message('To Call TRX_TAX_LINK_GT insert the initial row is'||to_char(l_initial_row));
insert_trx_tax_link_gt
(
p_sta_row_imp_tax_link => l_initial_row,
p_end_row_imp_tax_link => l_ending_row
);
write_message('Rows have been inserted in ZX_TRANSACTION_LINES_GT');
insert_transaction_rec(g_transaction_rec);
write_message('A row has been inserted in transaction_rec.');
insert_reverse_trx_lines_gt;
write_message('A row has been inserted in reverse_trx_lines_gt.');
insert_reverse_dist_lines_gt;
write_message('A row has been inserted in reverse_dist_lines_gt.');
insert_transaction_rec(g_transaction_rec
);
write_message('A row has been inserted in transaction_rec.');
insert_transaction_rec(g_transaction_rec);
insert_tax_dist_id_gt
(
p_suite => p_suite_number,
p_case => p_case_number,
p_structure => 'STRUCTURE_ITEM_DISTRIBUTION_KEY'
);
write_message('A row has been inserted in transaction_rec.');
END insert_into_gts;
SELECT zxevntmap.tax_event_type_code
INTO x_tx_evnt_typ_code
FROM zx_evnt_typ_mappings zxevntmap
WHERE zxevntmap.event_class_code = p_evnt_cls_code
AND zxevntmap.application_id = p_appln_id
AND zxevntmap.entity_code = p_entity_code
AND zxevntmap.event_type_code = p_evnt_typ_code
AND zxevntmap.enabled_flag = 'Y';
| Bulk insert into the temporary table. |
*==========================================================================*/
PROCEDURE Populate_Report_Table
(
p_suite IN VARCHAR2,
p_case IN VARCHAR2,
p_service IN VARCHAR2,
p_transaction_id IN NUMBER,
p_error_flag IN VARCHAR2,
p_error_message IN VARCHAR2
) IS
c_lines_per_fetch CONSTANT NUMBER:= 1000;
select count(*)
into l_dummy
from zx_lines l
where l.trx_id = p_transaction_id
and l.application_id = l_application_id
and l.entity_code = l_entity_code
and l.event_class_code = l_event_class_code;
INSERT INTO ZX_TEST_API_GT(
SUITE_NUMBER ,
CASE_NUMBER ,
TRX_ID ,
TRX_NUMBER ,
TRX_LINE_NUMBER ,
TRX_DATE ,
TRX_CURRENCY_CODE ,
SUMMARY_TAX_LINE_ID ,
TAX_LINE_ID ,
TAX_REGIME_CODE ,
TAX_JURISDICTION_ID ,
TAX ,
TAX_STATUS_CODE ,
TAX_RATE_ID ,
TAX_RATE_CODE ,
TAX_RATE ,
TAX_AMT ,
TAXABLE_AMT ,
REC_TAX_AMT ,
NREC_TAX_AMT ,
TAX_AMT_FUNCL_CURR ,
TOTAL_REC_TAX_AMT ,
TOTAL_NREC_TAX_AMT ,
TOTAL_REC_TAX_AMT_FUNCL_CURR ,
TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
SELF_ASSESSED_FLAG ,
MANUALLY_ENTERED_FLAG ,
LINE_AMT_INCLUDES_TAX_FLAG ,
TAXABLE_AMT_FUNCL_CURR ,
REC_TAX_AMT_FUNCL_CURR ,
NREC_TAX_AMT_FUNCL_CURR ,
TAX_AMT_INCLUDED_FLAG ,
TAX_EXEMPTION_ID ,
EXEMPTION_RATE ,
EXEMPT_REASON_CODE ,
TAX_APPORTIONMENT_LINE_NUMBER ,
TAX_REGISTRATION_NUMBER ,
TAX_HOLD_CODE ,
TAX_HOLD_RELEASED_CODE ,
LINE_AMT ,
TAX_JURISDICTION_CODE ,
TAX_RATE_NAME ,
TAX_RATE_TYPE ,
TAX_DETERMINE_DATE ,
CANCEL_FLAG ,
EVENT_CLASS_CODE ,
EVENT_TYPE_CODE ,
ETAX_API ,
ERROR_FLAG ,
ERROR_MESSAGE )
select
p_suite ,
p_case ,
p_transaction_id ,
zx_lines.TRX_NUMBER ,
zx_lines.trx_line_id , --zx_lines.TRX_LINE_NUMBER,
zx_lines.TRX_DATE ,
zx_lines.TRX_CURRENCY_CODE ,
zx_lines.SUMMARY_TAX_LINE_ID ,
zx_lines.TAX_LINE_ID ,
zx_lines.TAX_REGIME_CODE ,
zx_lines.TAX_JURISDICTION_ID ,
zx_lines.TAX ,
zx_lines.TAX_STATUS_CODE ,
zx_lines.TAX_RATE_ID ,
zx_lines.TAX_RATE_CODE ,
zx_lines.TAX_RATE ,
zx_lines.TAX_AMT ,
zx_lines.TAXABLE_AMT ,
zx_lines.REC_TAX_AMT ,
zx_lines.NREC_TAX_AMT ,
zx_lines.TAX_AMT_FUNCL_CURR ,
NULL ,
NULL ,
NULL ,
NULL ,
zx_lines.SELF_ASSESSED_FLAG ,
zx_lines.MANUALLY_ENTERED_FLAG ,
'A', --substr(zx_lines.LINE_AMT_INCLUDES_TAX_FLAG,1,1) , --Commented V6 Changes.
zx_lines.TAXABLE_AMT_FUNCL_CURR ,
zx_lines.REC_TAX_AMT_FUNCL_CURR ,
zx_lines.NREC_TAX_AMT_FUNCL_CURR ,
zx_lines.TAX_AMT_INCLUDED_FLAG ,
zx_lines.TAX_EXEMPTION_ID ,
NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes
zx_lines.EXEMPT_REASON_CODE ,
zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,
zx_lines.TAX_REGISTRATION_NUMBER ,
zx_lines.TAX_HOLD_CODE ,
zx_lines.TAX_HOLD_RELEASED_CODE ,
zx_lines.LINE_AMT ,
zx_lines.TAX_JURISDICTION_CODE ,
zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated
zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated
zx_lines.TAX_DETERMINE_DATE ,
zx_lines.CANCEL_FLAG ,
zx_lines.EVENT_CLASS_CODE ,
zx_lines.EVENT_TYPE_CODE ,
p_service ,
'N', --ERROR_FLAG ,
g_party_rec.prod_family_grp_code||' LINE' --ERROR_MESSAGE
FROM ZX_LINES,
ZX_RATES_B
WHERE trx_id = p_transaction_id
AND application_id = l_application_id
AND entity_code = l_entity_code
AND event_class_code = l_event_class_code
AND zx_lines.tax_rate_id(+) = zx_rates_b.tax_rate_id
ORDER BY trx_id,
trx_line_id;
select count(*) into l_dummy from zx_lines_summary where trx_id =p_transaction_id;
INSERT INTO ZX_TEST_API_GT(
SUITE_NUMBER ,
CASE_NUMBER ,
TRX_ID ,
TRX_NUMBER ,
TRX_LINE_NUMBER ,
TRX_DATE ,
TRX_CURRENCY_CODE ,
SUMMARY_TAX_LINE_ID ,
TAX_LINE_ID ,
TAX_REGIME_CODE ,
TAX_JURISDICTION_ID ,
TAX ,
TAX_STATUS_CODE ,
TAX_RATE_ID ,
TAX_RATE_CODE ,
TAX_RATE ,
TAX_AMT ,
TAXABLE_AMT ,
REC_TAX_AMT ,
NREC_TAX_AMT ,
TAX_AMT_FUNCL_CURR ,
TOTAL_REC_TAX_AMT ,
TOTAL_NREC_TAX_AMT ,
TOTAL_REC_TAX_AMT_FUNCL_CURR ,
TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
SELF_ASSESSED_FLAG ,
MANUALLY_ENTERED_FLAG ,
LINE_AMT_INCLUDES_TAX_FLAG ,
TAXABLE_AMT_FUNCL_CURR ,
REC_TAX_AMT_FUNCL_CURR ,
NREC_TAX_AMT_FUNCL_CURR ,
TAX_AMT_INCLUDED_FLAG ,
TAX_EXEMPTION_ID ,
EXEMPTION_RATE ,
EXEMPT_REASON_CODE ,
TAX_APPORTIONMENT_LINE_NUMBER ,
TAX_REGISTRATION_NUMBER ,
TAX_HOLD_CODE ,
TAX_HOLD_RELEASED_CODE ,
LINE_AMT ,
TAX_JURISDICTION_CODE ,
TAX_RATE_NAME ,
TAX_RATE_TYPE ,
TAX_DETERMINE_DATE ,
CANCEL_FLAG ,
EVENT_CLASS_CODE ,
EVENT_TYPE_CODE ,
ETAX_API ,
ERROR_FLAG ,
ERROR_MESSAGE )
select p_suite ,
p_case ,
p_transaction_id ,
zx_lines_summary.TRX_NUMBER ,
null, --TRX_LINE_NUMBER ,
null, --TRX_DATE ,
null, --TRX_CURRENCY_CODE ,
zx_lines_summary.SUMMARY_TAX_LINE_ID ,
null, --TAX_LINE_ID ,
zx_lines_summary.TAX_REGIME_CODE ,
null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
zx_lines_summary.TAX ,
zx_lines_summary.TAX_STATUS_CODE ,
zx_lines_summary.TAX_RATE_ID ,
zx_lines_summary.TAX_RATE_CODE ,
zx_lines_summary.TAX_RATE ,
zx_lines_summary.TAX_AMT ,
null, --TAXABLE_AMT ,
null, --REC_TAX_AMT ,
null, --NREC_TAX_AMT ,
zx_lines_summary.TAX_AMT_FUNCL_CURR ,
zx_lines_summary.TOTAL_REC_TAX_AMT ,
zx_lines_summary.TOTAL_NREC_TAX_AMT ,
zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
zx_lines_summary.SELF_ASSESSED_FLAG ,
zx_lines_summary.MANUALLY_ENTERED_FLAG ,
null, --LINE_AMT_INCLUDES_TAX_FLAG ,
null, --TAXABLE_AMT_FUNCL_CURR ,
null, --REC_TAX_AMT_FUNCL_CURR ,
null, --NREC_TAX_AMT_FUNCL_CURR ,
zx_lines_summary.TAX_AMT_INCLUDED_FLAG ,
null, --TAX_EXEMPTION_ID ,
null, --EXEMPTION_RATE ,
null, --EXEMPT_REASON_CODE ,
null, --TAX_APPORTIONMENT_LINE_NUMBER ,
null, --TAX_REGISTRATION_NUMBER ,
null, --TAX_HOLD_CODE ,
null, --TAX_HOLD_RELEASED_CODE ,
null, --LINE_AMT ,
zx_lines_summary.TAX_JURISDICTION_CODE ,
zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,
zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,
null, --TAX_DETERMINE_DATE ,
zx_lines_summary.CANCEL_FLAG ,
zx_lines_summary.EVENT_CLASS_CODE ,
null, --EVENT_TYPE_CODE ,
p_service ,
'N', --ERROR_FLAG ,
g_party_rec.prod_family_grp_code||' SUMMARY' --ERROR_MESSAGE
FROM ZX_LINES_SUMMARY,
ZX_RATES_B
WHERE trx_id = p_transaction_id
AND application_id = l_application_id
AND entity_code = l_entity_code
AND event_class_code = l_event_class_code
AND zx_lines_summary.tax_rate_id(+) = zx_rates_b.tax_rate_id;
/*select count(*) into l_dummy from zx_rec_nrec_dist where trx_id =p_transaction_id;
INSERT INTO ZX_TEST_API_GT(
SUITE_NUMBER ,
CASE_NUMBER ,
TRX_ID ,
TRX_NUMBER ,
TRX_LINE_NUMBER ,
TRX_DATE ,
TRX_CURRENCY_CODE ,
SUMMARY_TAX_LINE_ID ,
TAX_LINE_ID ,
TAX_REGIME_CODE ,
TAX_JURISDICTION_ID ,
TAX ,
TAX_STATUS_CODE ,
TAX_RATE_ID ,
TAX_RATE_CODE ,
TAX_RATE ,
TAX_AMT ,
TAXABLE_AMT ,
REC_TAX_AMT ,
NREC_TAX_AMT ,
TAX_AMT_FUNCL_CURR ,
TOTAL_REC_TAX_AMT ,
TOTAL_NREC_TAX_AMT ,
TOTAL_REC_TAX_AMT_FUNCL_CURR ,
TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
SELF_ASSESSED_FLAG ,
MANUALLY_ENTERED_FLAG ,
LINE_AMT_INCLUDES_TAX_FLAG ,
TAXABLE_AMT_FUNCL_CURR ,
REC_TAX_AMT_FUNCL_CURR ,
NREC_TAX_AMT_FUNCL_CURR ,
TAX_AMT_INCLUDED_FLAG ,
TAX_EXEMPTION_ID ,
EXEMPTION_RATE ,
EXEMPT_REASON_CODE ,
TAX_APPORTIONMENT_LINE_NUMBER ,
TAX_REGISTRATION_NUMBER ,
TAX_HOLD_CODE ,
TAX_HOLD_RELEASED_CODE ,
LINE_AMT ,
TAX_JURISDICTION_CODE ,
TAX_RATE_NAME ,
TAX_RATE_TYPE ,
TAX_DETERMINE_DATE ,
CANCEL_FLAG ,
EVENT_CLASS_CODE ,
EVENT_TYPE_CODE ,
ETAX_API ,
ERROR_FLAG ,
ERROR_MESSAGE )
SELECT p_suite ,
p_case ,
p_transaction_id ,
null , --TRX_NUMBER
zx_rec_nrec_dist.trx_line_id , --zx_rec_nrec_dist.TRX_LINE_NUMBER
null , --TRX_DATE
null , --TRX_CURRENCY_CODE
zx_rec_nrec_dist.SUMMARY_TAX_LINE_ID ,
zx_rec_nrec_dist.TAX_LINE_ID ,
zx_rec_nrec_dist.TAX_REGIME_CODE ,
null , --TAX_JURISDICTION_ID
zx_rec_nrec_dist.TAX ,
zx_rec_nrec_dist.TAX_STATUS_CODE ,
zx_rec_nrec_dist.TAX_RATE_ID ,
zx_rec_nrec_dist.TAX_RATE_CODE ,
zx_rec_nrec_dist.TAX_RATE ,
zx_rec_nrec_dist.REC_NREC_TAX_AMT , --TAX_AMT --BUG 4376481, Is this the Tax Amt?
zx_rec_nrec_dist.TAXABLE_AMT ,
null , --REC_TAX_AMT
null , --NREC_TAX_AMT
null , --zx_rec_nrec_dist.TAX_AMT_FUNCL_CURR
null , --TOTAL_REC_TAX_AMT
null , --TOTAL_NREC_TAX_AMT
null , --TOTAL_REC_TAX_AMT_FUNCL_CURR
null , --TOTAL_NREC_TAX_AMT_FUNCL_CURR
null , --zx_rec_nrec_dist.SELF_ASSESSED_FLAG
null , --MANUALLY_ENTERED_FLAG
null , --LINE_AMT_INCLUDES_TAX_FLAG
null , --TAXABLE_AMT_FUNCL_CURR
null , --REC_TAX_AMT_FUNCL_CURR
null , --NREC_TAX_AMT_FUNCL_CURR
null , --TAX_AMT_INCLUDED_FLAG
null , --TAX_EXEMPTION_ID
null , --EXEMPTION_RATE
null , --EXEMPT_REASON_CODE
null , --TAX_APPORTIONMENT_LINE_NUMBER
null , --TAX_REGISTRATION_NUMBER
null , --TAX_HOLD_CODE
null , --TAX_HOLD_RELEASED_CODE
null , --LINE_AMT
null , --TAX_JURISDICTION_CODE
null , --TAX_RATE_NAME
null , --TAX_RATE_TYPE
null , --TAX_DETERMINE_DATE
null , --CANCEL_FLAG
zx_rec_nrec_dist.EVENT_CLASS_CODE ,
zx_rec_nrec_dist.EVENT_TYPE_CODE ,
p_service ,
'N' , --ERROR_FLAG
g_party_rec.prod_family_grp_code||' DIST' --ERROR_MESSAGE
FROM zx_rec_nrec_dist,
zx_rates_b
WHERE trx_id = p_transaction_id
AND application_id = l_application_id
AND entity_code = l_entity_code
AND event_class_code = l_event_class_code
AND zx_rec_nrec_dist.tax_rate_id(+) = zx_rates_b.tax_rate_id;
Write_Message('Error messages will be inserted in the Report Table');
INSERT INTO ZX_TEST_API_GT
(SUITE_NUMBER ,
CASE_NUMBER ,
TRX_ID ,
TRX_NUMBER ,
TRX_LINE_NUMBER ,
TRX_DATE ,
TRX_CURRENCY_CODE ,
SUMMARY_TAX_LINE_ID ,
TAX_LINE_ID ,
TAX_REGIME_CODE ,
TAX_JURISDICTION_ID ,
TAX ,
TAX_STATUS_CODE ,
TAX_RATE_ID ,
TAX_RATE_CODE ,
TAX_RATE ,
TAX_AMT ,
TAXABLE_AMT ,
REC_TAX_AMT ,
NREC_TAX_AMT ,
TAX_AMT_FUNCL_CURR ,
TOTAL_REC_TAX_AMT ,
TOTAL_NREC_TAX_AMT ,
TOTAL_REC_TAX_AMT_FUNCL_CURR ,
TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
SELF_ASSESSED_FLAG ,
MANUALLY_ENTERED_FLAG ,
LINE_AMT_INCLUDES_TAX_FLAG ,
TAXABLE_AMT_FUNCL_CURR ,
REC_TAX_AMT_FUNCL_CURR ,
NREC_TAX_AMT_FUNCL_CURR ,
TAX_AMT_INCLUDED_FLAG ,
TAX_EXEMPTION_ID ,
EXEMPTION_RATE ,
EXEMPT_REASON_CODE ,
TAX_APPORTIONMENT_LINE_NUMBER ,
TAX_REGISTRATION_NUMBER ,
TAX_HOLD_CODE ,
TAX_HOLD_RELEASED_CODE ,
LINE_AMT ,
TAX_JURISDICTION_CODE ,
TAX_RATE_NAME ,
TAX_RATE_TYPE ,
TAX_DETERMINE_DATE ,
CANCEL_FLAG ,
EVENT_CLASS_CODE ,
EVENT_TYPE_CODE ,
ETAX_API ,
ERROR_FLAG ,
ERROR_MESSAGE)
VALUES
(p_suite ,
p_case ,
p_transaction_id, --TRX_ID ,
null, --TRX_NUMBER ,
null, --TRX_LINE_NUMBER ,
null, --TRX_DATE ,
null, --TRX_CURRENCY_CODE ,
null, --SUMMARY_TAX_LINE_ID ,
null, --TAX_LINE_ID ,
null, --TAX_REGIME_CODE ,
null, --TAX_JURISDICTION_ID ,
null, --TAX ,
null, --TAX_STATUS_CODE ,
null, --TAX_RATE_ID ,
null, --TAX_RATE_CODE ,
null, --TAX_RATE ,
null, --TAX_AMT ,
null, --TAXABLE_AMT ,
null, --REC_TAX_AMT ,
null, --NREC_TAX_AMT ,
null, --TAX_AMT_FUNCL_CURR ,
null, --TOTAL_REC_TAX_AMT ,
null, --TOTAL_NREC_TAX_AMT ,
null, --TOTAL_REC_TAX_AMT_FUNCL_CURR ,
null, --TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
null, --SELF_ASSESSED_FLAG ,
null, --MANUALLY_ENTERED_FLAG ,
null, --LINE_AMT_INCLUDES_TAX_FLAG ,
null, --TAXABLE_AMT_FUNCL_CURR ,
null, --REC_TAX_AMT_FUNCL_CURR ,
null, --NREC_TAX_AMT_FUNCL_CURR ,
null, --TAX_AMT_INCLUDED_FLAG ,
null, --TAX_EXEMPTION_ID ,
null, --EXEMPTION_RATE ,
null, --EXEMPT_REASON_CODE ,
null, --TAX_APPORTIONMENT_LINE_NUMBER ,
null, --TAX_REGISTRATION_NUMBER ,
null, --TAX_HOLD_CODE ,
null, --TAX_HOLD_RELEASED_CODE ,
null, --LINE_AMT ,
null, --TAX_JURISDICTION_CODE ,
null, --TAX_RATE_NAME ,
null, --TAX_RATE_TYPE ,
null, --TAX_DETERMINE_DATE ,
null, --CANCEL_FLAG ,
null, --EVENT_CLASS_CODE ,
null, --EVENT_TYPE_CODE ,
p_service ,
p_error_flag ,
p_error_message);
| PROCEDURE update_trx_header_cache : Update the Cache Transaction Header Info|
| from a row in g_suite_rec_tbl |
* ===========================================================================*/
PROCEDURE update_trx_header_cache(p_header_row_id IN NUMBER) IS
l_updateable_row NUMBER;
l_updateable_row := i;
Write_message('==Row to be updated is'||l_updateable_row);
g_trx_headers_cache_rec_tbl.INTERNAL_ORGANIZATION_ID(l_updateable_row) :=g_suite_rec_tbl.INTERNAL_ORGANIZATION_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.APPLICATION_ID(l_updateable_row) :=g_suite_rec_tbl.APPLICATION_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.ENTITY_CODE(l_updateable_row) :=g_suite_rec_tbl.ENTITY_CODE(p_header_row_id);
g_trx_headers_cache_rec_tbl.EVENT_CLASS_CODE(l_updateable_row) :=g_suite_rec_tbl.EVENT_CLASS_CODE(p_header_row_id);
g_trx_headers_cache_rec_tbl.EVENT_TYPE_CODE(l_updateable_row) :=g_suite_rec_tbl.EVENT_TYPE_CODE(p_header_row_id);
g_trx_headers_cache_rec_tbl.TRX_ID(l_updateable_row) :=g_suite_rec_tbl.TRX_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.TRX_DATE(l_updateable_row) :=g_suite_rec_tbl.TRX_DATE(p_header_row_id);
g_trx_headers_cache_rec_tbl.TRX_DOC_REVISION(l_updateable_row) :=g_suite_rec_tbl.TRX_DOC_REVISION(p_header_row_id);
g_trx_headers_cache_rec_tbl.LEDGER_ID(l_updateable_row) :=g_suite_rec_tbl.LEDGER_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.TRX_CURRENCY_CODE(l_updateable_row) :=g_suite_rec_tbl.TRX_CURRENCY_CODE(p_header_row_id);
g_trx_headers_cache_rec_tbl.CURRENCY_CONVERSION_DATE(l_updateable_row) :=g_suite_rec_tbl.CURRENCY_CONVERSION_DATE(p_header_row_id);
g_trx_headers_cache_rec_tbl.CURRENCY_CONVERSION_RATE(l_updateable_row) :=g_suite_rec_tbl.CURRENCY_CONVERSION_RATE(p_header_row_id);
g_trx_headers_cache_rec_tbl.CURRENCY_CONVERSION_TYPE(l_updateable_row) :=g_suite_rec_tbl.CURRENCY_CONVERSION_TYPE(p_header_row_id);
g_trx_headers_cache_rec_tbl.MINIMUM_ACCOUNTABLE_UNIT(l_updateable_row) :=g_suite_rec_tbl.MINIMUM_ACCOUNTABLE_UNIT(p_header_row_id);
g_trx_headers_cache_rec_tbl.PRECISION(l_updateable_row) :=g_suite_rec_tbl.PRECISION(p_header_row_id);
g_trx_headers_cache_rec_tbl.LEGAL_ENTITY_ID(l_updateable_row) :=g_suite_rec_tbl.LEGAL_ENTITY_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.ROUNDING_SHIP_TO_PARTY_ID(l_updateable_row) :=g_suite_rec_tbl.ROUNDING_SHIP_TO_PARTY_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.ROUNDING_SHIP_FROM_PARTY_ID(l_updateable_row) :=g_suite_rec_tbl.ROUNDING_SHIP_FROM_PARTY_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.ROUNDING_BILL_TO_PARTY_ID(l_updateable_row) :=g_suite_rec_tbl.ROUNDING_BILL_TO_PARTY_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.ROUNDING_BILL_FROM_PARTY_ID(l_updateable_row) :=g_suite_rec_tbl.ROUNDING_BILL_FROM_PARTY_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(l_updateable_row) :=g_suite_rec_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID(l_updateable_row) :=g_suite_rec_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.RNDG_BILL_TO_PARTY_SITE_ID(l_updateable_row) :=g_suite_rec_tbl.RNDG_BILL_TO_PARTY_SITE_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.RNDG_BILL_FROM_PARTY_SITE_ID(l_updateable_row) :=g_suite_rec_tbl.RNDG_BILL_FROM_PARTY_SITE_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.ESTABLISHMENT_ID(l_updateable_row) :=g_suite_rec_tbl.ESTABLISHMENT_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.RECEIVABLES_TRX_TYPE_ID(l_updateable_row) :=g_suite_rec_tbl.RECEIVABLES_TRX_TYPE_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.RELATED_DOC_APPLICATION_ID(l_updateable_row) :=g_suite_rec_tbl.RELATED_DOC_APPLICATION_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.RELATED_DOC_ENTITY_CODE(l_updateable_row) :=g_suite_rec_tbl.RELATED_DOC_ENTITY_CODE(p_header_row_id);
g_trx_headers_cache_rec_tbl.RELATED_DOC_EVENT_CLASS_CODE(l_updateable_row) :=g_suite_rec_tbl.RELATED_DOC_EVENT_CLASS_CODE(p_header_row_id);
g_trx_headers_cache_rec_tbl.RELATED_DOC_TRX_ID(l_updateable_row) :=g_suite_rec_tbl.RELATED_DOC_TRX_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.RELATED_DOC_NUMBER(l_updateable_row) :=g_suite_rec_tbl.RELATED_DOC_NUMBER(p_header_row_id);
g_trx_headers_cache_rec_tbl.RELATED_DOC_DATE(l_updateable_row) :=g_suite_rec_tbl.RELATED_DOC_DATE(p_header_row_id);
g_trx_headers_cache_rec_tbl.DEFAULT_TAXATION_COUNTRY(l_updateable_row) :=g_suite_rec_tbl.DEFAULT_TAXATION_COUNTRY(p_header_row_id);
g_trx_headers_cache_rec_tbl.QUOTE_FLAG(l_updateable_row) :=g_suite_rec_tbl.QUOTE_FLAG(p_header_row_id);
g_trx_headers_cache_rec_tbl.TRX_NUMBER(l_updateable_row) :=g_suite_rec_tbl.TRX_NUMBER(p_header_row_id);
g_trx_headers_cache_rec_tbl.TRX_DESCRIPTION(l_updateable_row) :=g_suite_rec_tbl.TRX_DESCRIPTION(p_header_row_id);
g_trx_headers_cache_rec_tbl.TRX_COMMUNICATED_DATE(l_updateable_row) :=g_suite_rec_tbl.TRX_COMMUNICATED_DATE(p_header_row_id);
g_trx_headers_cache_rec_tbl.BATCH_SOURCE_ID(l_updateable_row) :=g_suite_rec_tbl.BATCH_SOURCE_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.BATCH_SOURCE_NAME(l_updateable_row) :=g_suite_rec_tbl.BATCH_SOURCE_NAME(p_header_row_id);
g_trx_headers_cache_rec_tbl.DOC_SEQ_ID(l_updateable_row) :=g_suite_rec_tbl.DOC_SEQ_ID(p_header_row_id);
g_trx_headers_cache_rec_tbl.DOC_SEQ_NAME(l_updateable_row) :=g_suite_rec_tbl.DOC_SEQ_NAME(p_header_row_id);
g_trx_headers_cache_rec_tbl.DOC_SEQ_VALUE(l_updateable_row) :=g_suite_rec_tbl.DOC_SEQ_VALUE(p_header_row_id);
g_trx_headers_cache_rec_tbl.TRX_DUE_DATE(l_updateable_row) :=g_suite_rec_tbl.TRX_DUE_DATE(p_header_row_id);
g_trx_headers_cache_rec_tbl.TRX_TYPE_DESCRIPTION(l_updateable_row) :=g_suite_rec_tbl.TRX_TYPE_DESCRIPTION(p_header_row_id);
g_trx_headers_cache_rec_tbl.DOCUMENT_SUB_TYPE(l_updateable_row) :=g_suite_rec_tbl.DOCUMENT_SUB_TYPE(p_header_row_id);
g_trx_headers_cache_rec_tbl.SUPPLIER_TAX_INVOICE_NUMBER(l_updateable_row) :=g_suite_rec_tbl.SUPPLIER_TAX_INVOICE_NUMBER(p_header_row_id);
g_trx_headers_cache_rec_tbl.SUPPLIER_TAX_INVOICE_DATE(l_updateable_row) :=g_suite_rec_tbl.SUPPLIER_TAX_INVOICE_DATE(p_header_row_id);
g_trx_headers_cache_rec_tbl.SUPPLIER_EXCHANGE_RATE(l_updateable_row) :=g_suite_rec_tbl.SUPPLIER_EXCHANGE_RATE(p_header_row_id);
g_trx_headers_cache_rec_tbl.TAX_INVOICE_DATE(l_updateable_row) :=g_suite_rec_tbl.TAX_INVOICE_DATE(p_header_row_id);
g_trx_headers_cache_rec_tbl.TAX_INVOICE_NUMBER(l_updateable_row) :=g_suite_rec_tbl.TAX_INVOICE_NUMBER(p_header_row_id);
END update_trx_header_cache;
| PROCEDURE update_trx_lines_cache : Update the Cache Lines Info |
| from a row in g_suite_rec_tbl |
* =======================================================================*/
PROCEDURE update_trx_lines_cache(p_header_row_id IN NUMBER,
p_line_row_id IN NUMBER) IS
l_trx_line_exists_flag VARCHAR2(1);
l_updateable_row NUMBER;
l_updateable_row := i;
write_message('==Row to be updated is'||l_updateable_row );
g_trx_lines_cache_rec_tbl.APPLICATION_ID(l_updateable_row) := g_suite_rec_tbl.APPLICATION_ID(p_header_row_id);
g_trx_lines_cache_rec_tbl.ENTITY_CODE(l_updateable_row) := g_suite_rec_tbl.ENTITY_CODE(p_header_row_id);
g_trx_lines_cache_rec_tbl.EVENT_CLASS_CODE(l_updateable_row) := g_suite_rec_tbl.EVENT_CLASS_CODE(p_header_row_id);
g_trx_lines_cache_rec_tbl.TRX_ID(l_updateable_row) := g_suite_rec_tbl.TRX_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.TRX_LINE_ID(l_updateable_row) := g_suite_rec_tbl.TRX_LINE_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.LINE_LEVEL_ACTION(l_updateable_row) := g_suite_rec_tbl.LINE_LEVEL_ACTION(p_line_row_id);
g_trx_lines_cache_rec_tbl.TRX_LINE_TYPE(l_updateable_row) := g_suite_rec_tbl.TRX_LINE_TYPE(p_line_row_id);
g_trx_lines_cache_rec_tbl.TRX_LINE_DATE(l_updateable_row) := g_suite_rec_tbl.TRX_LINE_DATE(p_line_row_id);
g_trx_lines_cache_rec_tbl.TRX_BUSINESS_CATEGORY(l_updateable_row) := g_suite_rec_tbl.TRX_BUSINESS_CATEGORY(p_line_row_id);
g_trx_lines_cache_rec_tbl.LINE_INTENDED_USE(l_updateable_row) := g_suite_rec_tbl.LINE_INTENDED_USE(p_line_row_id);
g_trx_lines_cache_rec_tbl.USER_DEFINED_FISC_CLASS(l_updateable_row) := g_suite_rec_tbl.USER_DEFINED_FISC_CLASS(p_line_row_id);
g_trx_lines_cache_rec_tbl.LINE_AMT(l_updateable_row) := g_suite_rec_tbl.LINE_AMT(p_line_row_id);
g_trx_lines_cache_rec_tbl.TRX_LINE_QUANTITY(l_updateable_row) := g_suite_rec_tbl.TRX_LINE_QUANTITY(p_line_row_id);
g_trx_lines_cache_rec_tbl.UNIT_PRICE(l_updateable_row) := g_suite_rec_tbl.UNIT_PRICE(p_line_row_id);
g_trx_lines_cache_rec_tbl.PRODUCT_ID(l_updateable_row) := g_suite_rec_tbl.PRODUCT_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.PRODUCT_FISC_CLASSIFICATION(l_updateable_row):= g_suite_rec_tbl.PRODUCT_FISC_CLASSIFICATION(p_line_row_id);
g_trx_lines_cache_rec_tbl.PRODUCT_ORG_ID(l_updateable_row) := g_suite_rec_tbl.PRODUCT_ORG_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.UOM_CODE(l_updateable_row) := g_suite_rec_tbl.UOM_CODE(p_line_row_id);
g_trx_lines_cache_rec_tbl.PRODUCT_TYPE(l_updateable_row) := g_suite_rec_tbl.PRODUCT_TYPE(p_line_row_id);
g_trx_lines_cache_rec_tbl.PRODUCT_CODE(l_updateable_row) := g_suite_rec_tbl.PRODUCT_CODE(p_line_row_id);
g_trx_lines_cache_rec_tbl.PRODUCT_CATEGORY(l_updateable_row) := g_suite_rec_tbl.PRODUCT_CATEGORY(p_line_row_id);
g_trx_lines_cache_rec_tbl.MERCHANT_PARTY_ID(l_updateable_row) := g_suite_rec_tbl.MERCHANT_PARTY_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.ACCOUNT_CCID(l_updateable_row) := g_suite_rec_tbl.ACCOUNT_CCID(p_line_row_id);
g_trx_lines_cache_rec_tbl.ACCOUNT_STRING(l_updateable_row) := g_suite_rec_tbl.ACCOUNT_STRING(p_line_row_id);
g_trx_lines_cache_rec_tbl.REF_DOC_APPLICATION_ID(l_updateable_row) := g_suite_rec_tbl.REF_DOC_APPLICATION_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.REF_DOC_ENTITY_CODE(l_updateable_row) := g_suite_rec_tbl.REF_DOC_ENTITY_CODE(p_line_row_id);
g_trx_lines_cache_rec_tbl.REF_DOC_EVENT_CLASS_CODE(l_updateable_row) := g_suite_rec_tbl.REF_DOC_EVENT_CLASS_CODE(p_line_row_id);
g_trx_lines_cache_rec_tbl.REF_DOC_TRX_ID(l_updateable_row) := g_suite_rec_tbl.REF_DOC_TRX_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.REF_DOC_LINE_ID(l_updateable_row) := g_suite_rec_tbl.REF_DOC_LINE_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.REF_DOC_LINE_QUANTITY(l_updateable_row) := g_suite_rec_tbl.REF_DOC_LINE_QUANTITY(p_line_row_id);
g_trx_lines_cache_rec_tbl.APPLIED_FROM_APPLICATION_ID(l_updateable_row):= g_suite_rec_tbl.APPLIED_FROM_APPLICATION_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.APPLIED_FROM_ENTITY_CODE(l_updateable_row) := g_suite_rec_tbl.APPLIED_FROM_ENTITY_CODE(p_line_row_id);
g_trx_lines_cache_rec_tbl.APPLIED_FROM_EVENT_CLASS_CODE(l_updateable_row):= g_suite_rec_tbl.APPLIED_FROM_EVENT_CLASS_CODE(p_line_row_id);
g_trx_lines_cache_rec_tbl.APPLIED_FROM_TRX_ID(l_updateable_row) := g_suite_rec_tbl.APPLIED_FROM_TRX_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.APPLIED_FROM_LINE_ID(l_updateable_row) := g_suite_rec_tbl.APPLIED_FROM_LINE_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.ADJUSTED_DOC_APPLICATION_ID(l_updateable_row):= g_suite_rec_tbl.ADJUSTED_DOC_APPLICATION_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.adjusted_doc_entity_code(l_updateable_row) := g_suite_rec_tbl.adjusted_doc_entity_code(p_line_row_id);
g_trx_lines_cache_rec_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(l_updateable_row):= g_suite_rec_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(p_line_row_id);
g_trx_lines_cache_rec_tbl.ADJUSTED_DOC_TRX_ID(l_updateable_row) := g_suite_rec_tbl.ADJUSTED_DOC_TRX_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.ADJUSTED_DOC_LINE_ID(l_updateable_row) := g_suite_rec_tbl.ADJUSTED_DOC_LINE_ID(p_line_row_id);
g_trx_lines_cache_rec_tbl.TRX_LINE_NUMBER(l_updateable_row) := g_suite_rec_tbl.TRX_LINE_NUMBER(p_line_row_id);
g_trx_lines_cache_rec_tbl.TRX_LINE_DESCRIPTION(l_updateable_row) := g_suite_rec_tbl.TRX_LINE_DESCRIPTION(p_line_row_id);
g_trx_lines_cache_rec_tbl.TRX_LINE_GL_DATE(l_updateable_row) := g_suite_rec_tbl.TRX_LINE_GL_DATE(p_line_row_id);
g_trx_lines_cache_rec_tbl.LINE_AMT_INCLUDES_TAX_FLAG(l_updateable_row) := g_suite_rec_tbl.LINE_AMT_INCLUDES_TAX_FLAG(p_line_row_id);
g_trx_lines_cache_rec_tbl.TRX_LEVEL_TYPE(l_updateable_row) := g_suite_rec_tbl.TRX_LEVEL_TYPE(p_line_row_id);
END update_trx_lines_cache;
| PROCEDURE update_dist_lines_cache : Update the Cache Dist Lines Info |
| from a row in g_suite_rec_tbl |
* =======================================================================*/
PROCEDURE update_dist_lines_cache
(
p_dist_row_id IN NUMBER
) IS
l_dist_line_exists_flag VARCHAR2(1);
l_updateable_row NUMBER;
l_updateable_row := i;
write_message('==Row to be updated is'||l_updateable_row );
g_dist_lines_cache_rec_tbl.APPLICATION_ID(l_updateable_row) :=g_suite_rec_tbl.APPLICATION_ID(p_dist_row_id);
g_dist_lines_cache_rec_tbl.ENTITY_CODE(l_updateable_row) :=g_suite_rec_tbl.ENTITY_CODE(p_dist_row_id);
g_dist_lines_cache_rec_tbl.EVENT_CLASS_CODE(l_updateable_row) :=g_suite_rec_tbl.EVENT_CLASS_CODE(p_dist_row_id);
g_dist_lines_cache_rec_tbl.EVENT_TYPE_CODE(l_updateable_row) :=g_suite_rec_tbl.EVENT_TYPE_CODE(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TRX_ID(l_updateable_row) :=g_suite_rec_tbl.TRX_ID(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TRX_LINE_ID(l_updateable_row) :=g_suite_rec_tbl.TRX_LINE_ID(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TRX_LINE_QUANTITY(l_updateable_row) :=g_suite_rec_tbl.TRX_LINE_QUANTITY(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TRX_LEVEL_TYPE(l_updateable_row) :=g_suite_rec_tbl.TRX_LEVEL_TYPE(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TRX_LINE_DIST_ID(l_updateable_row) :=g_suite_rec_tbl.TRX_LINE_DIST_ID(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TRX_LINE_DIST_AMT(l_updateable_row) :=g_suite_rec_tbl.TRX_LINE_DIST_AMT(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TRX_LINE_DIST_QUANTITY(l_updateable_row):=g_suite_rec_tbl.TRX_LINE_DIST_QUANTITY(p_dist_row_id);
g_dist_lines_cache_rec_tbl.DIST_LEVEL_ACTION(l_updateable_row) :=g_suite_rec_tbl.DIST_LEVEL_ACTION(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TRX_LINE_DIST_DATE(l_updateable_row) :=g_suite_rec_tbl.TRX_LINE_DIST_DATE(p_dist_row_id);
g_dist_lines_cache_rec_tbl.ITEM_DIST_NUMBER(l_updateable_row) :=g_suite_rec_tbl.ITEM_DIST_NUMBER(p_dist_row_id);
g_dist_lines_cache_rec_tbl.DIST_INTENDED_USE(l_updateable_row) :=g_suite_rec_tbl.DIST_INTENDED_USE(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TAX_INCLUSION_FLAG(l_updateable_row) :=g_suite_rec_tbl.TAX_INCLUSION_FLAG(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TAX_CODE(l_updateable_row) :=g_suite_rec_tbl.TAX_CODE(p_dist_row_id);
g_dist_lines_cache_rec_tbl.TASK_ID(l_updateable_row) :=g_suite_rec_tbl.TASK_ID(p_dist_row_id);
g_dist_lines_cache_rec_tbl.AWARD_ID(l_updateable_row) :=g_suite_rec_tbl.AWARD_ID(p_dist_row_id);
g_dist_lines_cache_rec_tbl.PROJECT_ID(l_updateable_row) :=g_suite_rec_tbl.PROJECT_ID(p_dist_row_id);
END update_dist_lines_cache;
| Insert A(l) into B |
| 5) If B(i) is not in A(l) Do nothing |
| 6) If B(i) is not in A(l) insert into A |
* ===========================================================================*/
PROCEDURE merge_with_dist_lines_cache
(
p_suite IN VARCHAR2,
p_case IN VARCHAR2
)
IS
l_dist_is_in_cache_flag VARCHAR2(1);
| PROCEDURE insert_tax_dist_id_gt :Retrieves TAX_DIST_ID depending on |
| what STRUCTURE is being passed when |
| calling using service |
| FREEZE_DISTRIBUTIONS |
| The Structures are: |
| STRUCTURE_TAX_LINE_KEY |
| STRUCTURE_ITEM_DISTRIBUTION_KEY |
| STRUCTURE_TRANSACTION_LINE_KEY |
| Also Pupulates ZX_TAX_DIST_ID_GT |
* =========================================================================*/
PROCEDURE insert_tax_dist_id_gt
(
p_suite IN VARCHAR2,
p_case IN VARCHAR2,
p_structure IN VARCHAR2
) IS
l_rec_nrec_tax_dist_id NUMBER;
WRITE_MESSAGE('Calling insert_tax_dist_id with '||p_structure);
INSERT INTO ZX_TAX_DIST_ID_GT
(
TAX_DIST_ID
)
(SELECT
REC_NREC_TAX_DIST_ID
FROM zx_rec_nrec_dist
WHERE tax_id in (SELECT tax_id
FROM zx_lines l
WHERE l.application_id = g_suite_rec_tbl.APPLICATION_ID(i)
AND l.entity_code = g_suite_rec_tbl.ENTITY_CODE(i)
AND l.event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(i)
AND l.trx_id = g_suite_rec_tbl.TRX_ID(i)
AND l.trx_line_id = g_suite_rec_tbl.TRX_LINE_ID(i)));
INSERT INTO ZX_TAX_DIST_ID_GT
(
TAX_DIST_ID
)
(SELECT rec_nrec_tax_dist_id
REC_NREC_TAX_DIST_ID
FROM zx_rec_nrec_dist d
WHERE d.application_id = g_suite_rec_tbl.APPLICATION_ID(i)
AND d.entity_code = g_suite_rec_tbl.ENTITY_CODE(i)
AND d.event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(i)
AND d.trx_id = g_suite_rec_tbl.TRX_ID(i)
AND d.trx_line_id = g_suite_rec_tbl.TRX_LINE_ID(i)
AND d.trx_line_dist_id = g_suite_rec_tbl.TRX_LINE_DIST_ID(i));
INSERT INTO ZX_TAX_DIST_ID_GT
(
TAX_DIST_ID
)
(SELECT
REC_NREC_TAX_DIST_ID
FROM zx_rec_nrec_dist
WHERE tax_id in (SELECT tax_id
FROM zx_lines l
WHERE l.application_id = g_suite_rec_tbl.APPLICATION_ID(i)
AND l.entity_code = g_suite_rec_tbl.ENTITY_CODE(i)
AND l.event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(i)
AND l.trx_id = g_suite_rec_tbl.TRX_ID(i)
AND l.trx_line_id = g_suite_rec_tbl.TRX_LINE_ID(i)
AND l.tax_regime_code = g_suite_rec_tbl.TAX_REGIME_CODE(i)
AND l.tax = g_suite_rec_tbl.TAX(i)
AND l.tax_status_code = g_suite_rec_tbl.TAX_STATUS_CODE(i)
AND l.tax_line_number = g_suite_rec_tbl.TAX_LINE_NUMBER(i)));
INSERT INTO ZX_TAX_DIST_ID_GT
(
TAX_DIST_ID
)
VALUES
(
g_suite_rec_tbl.tax_dist_id(i)
);
END insert_tax_dist_id_gt;
ELSIF l_tax_event_type_code = 'UPDATE' THEN
IF l_structure = 'STRUCTURE_TRANSACTION_HEADER' THEN
update_trx_header_cache(p_header_row_id => p_header_row_id);
write_message('==A line for Header cache has been updated');
update_trx_lines_cache(p_header_row_id => p_header_row_id,
p_line_row_id => i);
write_message('==A line for Line cache has been updated');
SELECT message_text
FROM zx_errors_gt;
Select count(*) into l_zx_errors_gt_count from ZX_ERRORS_GT;
Select user_id
into l_user_id
from fnd_user_view
where user_name = 'BTT';
write_message('-- Row has been inserted in Suite Structure --');
write_message('-- Inserting into Global Temporary Tables --');
write_message('-- Insert into GTs will be performed --');
insert_into_gts(p_suite_number => l_file_curr_line_suite_number,
p_case_number => l_file_curr_line_case_number,
p_service => l_file_curr_line_task,
p_structure => l_file_curr_line_structure,
p_header_row_id => l_curr_case_header_row,
p_starting_row_id => l_curr_case_line_start_row,
p_ending_row_id => l_curr_case_line_end_row,
p_prev_trx_id => l_curr_case_trx_id);
write_message('-- Insert into GTs is completed. --');