250: IF OZF_DEBUG_HIGH_ON THEN
251: OZF_Utility_PVT.debug_message(l_full_name||' : Populating the Global Structure');
252: END IF;
253:
254: zx_global_structures_pkg.init_trx_line_dist_tbl(1);
255:
256: -- Populate the common values in the structure
257: zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1) := l_claim_header.org_id;
258: zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1) := l_claim_header.claim_id;
253:
254: zx_global_structures_pkg.init_trx_line_dist_tbl(1);
255:
256: -- Populate the common values in the structure
257: zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1) := l_claim_header.org_id;
258: zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1) := l_claim_header.claim_id;
259: zx_global_structures_pkg.trx_line_dist_tbl.trx_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
260: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;
254: zx_global_structures_pkg.init_trx_line_dist_tbl(1);
255:
256: -- Populate the common values in the structure
257: zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1) := l_claim_header.org_id;
258: zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1) := l_claim_header.claim_id;
259: zx_global_structures_pkg.trx_line_dist_tbl.trx_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
260: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;
262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;
255:
256: -- Populate the common values in the structure
257: zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1) := l_claim_header.org_id;
258: zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1) := l_claim_header.claim_id;
259: zx_global_structures_pkg.trx_line_dist_tbl.trx_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
260: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;
262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;
263: zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(1) := l_claim_header.legal_entity_id;
256: -- Populate the common values in the structure
257: zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1) := l_claim_header.org_id;
258: zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1) := l_claim_header.claim_id;
259: zx_global_structures_pkg.trx_line_dist_tbl.trx_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
260: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;
262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;
263: zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(1) := l_claim_header.legal_entity_id;
264: zx_global_structures_pkg.trx_line_dist_tbl.trx_level_type(1) := 'LINE';
257: zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1) := l_claim_header.org_id;
258: zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1) := l_claim_header.claim_id;
259: zx_global_structures_pkg.trx_line_dist_tbl.trx_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
260: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;
262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;
263: zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(1) := l_claim_header.legal_entity_id;
264: zx_global_structures_pkg.trx_line_dist_tbl.trx_level_type(1) := 'LINE';
265: zx_global_structures_pkg.trx_line_dist_tbl.line_level_action(1) := 'CREATE';
258: zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1) := l_claim_header.claim_id;
259: zx_global_structures_pkg.trx_line_dist_tbl.trx_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
260: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;
262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;
263: zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(1) := l_claim_header.legal_entity_id;
264: zx_global_structures_pkg.trx_line_dist_tbl.trx_level_type(1) := 'LINE';
265: zx_global_structures_pkg.trx_line_dist_tbl.line_level_action(1) := 'CREATE';
266: zx_global_structures_pkg.trx_line_dist_tbl.quote_flag(1) := 'Y';
259: zx_global_structures_pkg.trx_line_dist_tbl.trx_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
260: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;
262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;
263: zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(1) := l_claim_header.legal_entity_id;
264: zx_global_structures_pkg.trx_line_dist_tbl.trx_level_type(1) := 'LINE';
265: zx_global_structures_pkg.trx_line_dist_tbl.line_level_action(1) := 'CREATE';
266: zx_global_structures_pkg.trx_line_dist_tbl.quote_flag(1) := 'Y';
267:
260: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_date(1) := NVL(l_claim_header.effective_date, SYSDATE);
261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;
262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;
263: zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(1) := l_claim_header.legal_entity_id;
264: zx_global_structures_pkg.trx_line_dist_tbl.trx_level_type(1) := 'LINE';
265: zx_global_structures_pkg.trx_line_dist_tbl.line_level_action(1) := 'CREATE';
266: zx_global_structures_pkg.trx_line_dist_tbl.quote_flag(1) := 'Y';
267:
268: OPEN csr_curr_details(l_claim_header.currency_code);
261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;
262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;
263: zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(1) := l_claim_header.legal_entity_id;
264: zx_global_structures_pkg.trx_line_dist_tbl.trx_level_type(1) := 'LINE';
265: zx_global_structures_pkg.trx_line_dist_tbl.line_level_action(1) := 'CREATE';
266: zx_global_structures_pkg.trx_line_dist_tbl.quote_flag(1) := 'Y';
267:
268: OPEN csr_curr_details(l_claim_header.currency_code);
269: FETCH csr_curr_details INTO zx_global_structures_pkg.trx_line_dist_tbl.minimum_accountable_unit(1)
262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;
263: zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(1) := l_claim_header.legal_entity_id;
264: zx_global_structures_pkg.trx_line_dist_tbl.trx_level_type(1) := 'LINE';
265: zx_global_structures_pkg.trx_line_dist_tbl.line_level_action(1) := 'CREATE';
266: zx_global_structures_pkg.trx_line_dist_tbl.quote_flag(1) := 'Y';
267:
268: OPEN csr_curr_details(l_claim_header.currency_code);
269: FETCH csr_curr_details INTO zx_global_structures_pkg.trx_line_dist_tbl.minimum_accountable_unit(1)
270: , zx_global_structures_pkg.trx_line_dist_tbl.precision(1);
265: zx_global_structures_pkg.trx_line_dist_tbl.line_level_action(1) := 'CREATE';
266: zx_global_structures_pkg.trx_line_dist_tbl.quote_flag(1) := 'Y';
267:
268: OPEN csr_curr_details(l_claim_header.currency_code);
269: FETCH csr_curr_details INTO zx_global_structures_pkg.trx_line_dist_tbl.minimum_accountable_unit(1)
270: , zx_global_structures_pkg.trx_line_dist_tbl.precision(1);
271: CLOSE csr_curr_details;
272:
273: zx_global_structures_pkg.trx_line_dist_tbl.line_amt_includes_tax_flag(1) := 'N';
266: zx_global_structures_pkg.trx_line_dist_tbl.quote_flag(1) := 'Y';
267:
268: OPEN csr_curr_details(l_claim_header.currency_code);
269: FETCH csr_curr_details INTO zx_global_structures_pkg.trx_line_dist_tbl.minimum_accountable_unit(1)
270: , zx_global_structures_pkg.trx_line_dist_tbl.precision(1);
271: CLOSE csr_curr_details;
272:
273: zx_global_structures_pkg.trx_line_dist_tbl.line_amt_includes_tax_flag(1) := 'N';
274:
269: FETCH csr_curr_details INTO zx_global_structures_pkg.trx_line_dist_tbl.minimum_accountable_unit(1)
270: , zx_global_structures_pkg.trx_line_dist_tbl.precision(1);
271: CLOSE csr_curr_details;
272:
273: zx_global_structures_pkg.trx_line_dist_tbl.line_amt_includes_tax_flag(1) := 'N';
274:
275:
276: OPEN csr_stlmnt_tax_type(l_claim_header.claim_id);
277: FETCH csr_stlmnt_tax_type INTO l_tax_type;
278: CLOSE csr_stlmnt_tax_type;
279:
280: IF l_tax_type = 'AP' THEN
281:
282: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 200;
283: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'AP_INVOICES';
284: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'STANDARD INVOICES';
285: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
286: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
279:
280: IF l_tax_type = 'AP' THEN
281:
282: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 200;
283: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'AP_INVOICES';
284: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'STANDARD INVOICES';
285: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
286: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
287: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_PAYABLES';
280: IF l_tax_type = 'AP' THEN
281:
282: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 200;
283: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'AP_INVOICES';
284: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'STANDARD INVOICES';
285: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
286: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
287: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_PAYABLES';
288: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'STANDARD CREATED';
281:
282: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 200;
283: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'AP_INVOICES';
284: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'STANDARD INVOICES';
285: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
286: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
287: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_PAYABLES';
288: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'STANDARD CREATED';
289:
282: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 200;
283: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'AP_INVOICES';
284: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'STANDARD INVOICES';
285: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
286: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
287: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_PAYABLES';
288: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'STANDARD CREATED';
289:
290: -- Ship From Information. Bill From Info not Required
283: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'AP_INVOICES';
284: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'STANDARD INVOICES';
285: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
286: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
287: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_PAYABLES';
288: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'STANDARD CREATED';
289:
290: -- Ship From Information. Bill From Info not Required
291: OPEN csr_vendor_site_details(l_claim_header.vendor_site_id);
284: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'STANDARD INVOICES';
285: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
286: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
287: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_PAYABLES';
288: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'STANDARD CREATED';
289:
290: -- Ship From Information. Bill From Info not Required
291: OPEN csr_vendor_site_details(l_claim_header.vendor_site_id);
292: FETCH csr_vendor_site_details INTO zx_global_structures_pkg.trx_line_dist_tbl.ship_from_party_site_id(1),
288: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'STANDARD CREATED';
289:
290: -- Ship From Information. Bill From Info not Required
291: OPEN csr_vendor_site_details(l_claim_header.vendor_site_id);
292: FETCH csr_vendor_site_details INTO zx_global_structures_pkg.trx_line_dist_tbl.ship_from_party_site_id(1),
293: zx_global_structures_pkg.trx_line_dist_tbl.ship_from_location_id(1);
294: CLOSE csr_vendor_site_details;
295:
296: -- Bill To Information?
289:
290: -- Ship From Information. Bill From Info not Required
291: OPEN csr_vendor_site_details(l_claim_header.vendor_site_id);
292: FETCH csr_vendor_site_details INTO zx_global_structures_pkg.trx_line_dist_tbl.ship_from_party_site_id(1),
293: zx_global_structures_pkg.trx_line_dist_tbl.ship_from_location_id(1);
294: CLOSE csr_vendor_site_details;
295:
296: -- Bill To Information?
297: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_to_location_id(1) := ??
293: zx_global_structures_pkg.trx_line_dist_tbl.ship_from_location_id(1);
294: CLOSE csr_vendor_site_details;
295:
296: -- Bill To Information?
297: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_to_location_id(1) := ??
298:
299: -- Ship To Information
300: OPEN csr_ap_ship_to_location;
301: FETCH csr_ap_ship_to_location INTO zx_global_structures_pkg.trx_line_dist_tbl.ship_to_location_id(1);
297: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_to_location_id(1) := ??
298:
299: -- Ship To Information
300: OPEN csr_ap_ship_to_location;
301: FETCH csr_ap_ship_to_location INTO zx_global_structures_pkg.trx_line_dist_tbl.ship_to_location_id(1);
302: CLOSE csr_ap_ship_to_location;
303:
304: ELSE
305:
302: CLOSE csr_ap_ship_to_location;
303:
304: ELSE
305:
306: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 222;
307: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'TRANSACTIONS';
308:
309: IF l_claim_header.payment_method = 'RMA' THEN
310: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
303:
304: ELSE
305:
306: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 222;
307: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'TRANSACTIONS';
308:
309: IF l_claim_header.payment_method = 'RMA' THEN
310: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
311: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CREATE';
306: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 222;
307: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'TRANSACTIONS';
308:
309: IF l_claim_header.payment_method = 'RMA' THEN
310: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
311: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CREATE';
312:
313: ELSIF l_claim_header.payment_method = 'REG_CREDIT_MEMO' THEN
314: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';
307: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'TRANSACTIONS';
308:
309: IF l_claim_header.payment_method = 'RMA' THEN
310: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
311: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CREATE';
312:
313: ELSIF l_claim_header.payment_method = 'REG_CREDIT_MEMO' THEN
314: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';
315: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CM_CREATE';
310: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
311: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CREATE';
312:
313: ELSIF l_claim_header.payment_method = 'REG_CREDIT_MEMO' THEN
314: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';
315: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CM_CREATE';
316:
317: ELSE
318: IF l_claim_header.payment_method = 'CREDIT_MEMO' THEN
311: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CREATE';
312:
313: ELSIF l_claim_header.payment_method = 'REG_CREDIT_MEMO' THEN
314: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';
315: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CM_CREATE';
316:
317: ELSE
318: IF l_claim_header.payment_method = 'CREDIT_MEMO' THEN
319: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';
315: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CM_CREATE';
316:
317: ELSE
318: IF l_claim_header.payment_method = 'CREDIT_MEMO' THEN
319: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';
320: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CM_CREATE';
321: ELSIF l_claim_header.payment_method = 'DEBIT_MEMO' THEN
322: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'DEBIT_MEMO';
323: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'DM_CREATE';
316:
317: ELSE
318: IF l_claim_header.payment_method = 'CREDIT_MEMO' THEN
319: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';
320: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CM_CREATE';
321: ELSIF l_claim_header.payment_method = 'DEBIT_MEMO' THEN
322: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'DEBIT_MEMO';
323: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'DM_CREATE';
324: END IF;
318: IF l_claim_header.payment_method = 'CREDIT_MEMO' THEN
319: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';
320: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CM_CREATE';
321: ELSIF l_claim_header.payment_method = 'DEBIT_MEMO' THEN
322: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'DEBIT_MEMO';
323: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'DM_CREATE';
324: END IF;
325:
326: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
319: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';
320: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CM_CREATE';
321: ELSIF l_claim_header.payment_method = 'DEBIT_MEMO' THEN
322: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'DEBIT_MEMO';
323: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'DM_CREATE';
324: END IF;
325:
326: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
327: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
322: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'DEBIT_MEMO';
323: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'DM_CREATE';
324: END IF;
325:
326: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
327: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
328: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_RECEIVABLES';
329:
330: END IF;
323: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'DM_CREATE';
324: END IF;
325:
326: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
327: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
328: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_RECEIVABLES';
329:
330: END IF;
331:
324: END IF;
325:
326: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;
327: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';
328: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_RECEIVABLES';
329:
330: END IF;
331:
332: -- Ship From Information ? Bill From Info not required.
329:
330: END IF;
331:
332: -- Ship From Information ? Bill From Info not required.
333: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_party_id(1) := ??;
334: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_location_id(1) := ??
335: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_party_id(1) := ??;
336: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_location_id(1) := ??
337:
330: END IF;
331:
332: -- Ship From Information ? Bill From Info not required.
333: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_party_id(1) := ??;
334: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_location_id(1) := ??
335: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_party_id(1) := ??;
336: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_location_id(1) := ??
337:
338:
331:
332: -- Ship From Information ? Bill From Info not required.
333: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_party_id(1) := ??;
334: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_location_id(1) := ??
335: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_party_id(1) := ??;
336: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_location_id(1) := ??
337:
338:
339: -- Bill To Information
332: -- Ship From Information ? Bill From Info not required.
333: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_party_id(1) := ??;
334: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_location_id(1) := ??
335: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_party_id(1) := ??;
336: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_location_id(1) := ??
337:
338:
339: -- Bill To Information
340: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(1) := NVL(l_claim_header.related_site_use_id, l_claim_header.cust_billto_acct_site_id);
336: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_location_id(1) := ??
337:
338:
339: -- Bill To Information
340: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(1) := NVL(l_claim_header.related_site_use_id, l_claim_header.cust_billto_acct_site_id);
341: OPEN csr_cust_party_details(zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(1));
342: FETCH csr_cust_party_details INTO zx_global_structures_pkg.trx_line_dist_tbl.bill_to_party_site_id(1),
343: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_location_id(1);
344: CLOSE csr_cust_party_details ;
337:
338:
339: -- Bill To Information
340: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(1) := NVL(l_claim_header.related_site_use_id, l_claim_header.cust_billto_acct_site_id);
341: OPEN csr_cust_party_details(zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(1));
342: FETCH csr_cust_party_details INTO zx_global_structures_pkg.trx_line_dist_tbl.bill_to_party_site_id(1),
343: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_location_id(1);
344: CLOSE csr_cust_party_details ;
345:
338:
339: -- Bill To Information
340: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(1) := NVL(l_claim_header.related_site_use_id, l_claim_header.cust_billto_acct_site_id);
341: OPEN csr_cust_party_details(zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(1));
342: FETCH csr_cust_party_details INTO zx_global_structures_pkg.trx_line_dist_tbl.bill_to_party_site_id(1),
343: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_location_id(1);
344: CLOSE csr_cust_party_details ;
345:
346: -- Ship To Information
339: -- Bill To Information
340: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(1) := NVL(l_claim_header.related_site_use_id, l_claim_header.cust_billto_acct_site_id);
341: OPEN csr_cust_party_details(zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(1));
342: FETCH csr_cust_party_details INTO zx_global_structures_pkg.trx_line_dist_tbl.bill_to_party_site_id(1),
343: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_location_id(1);
344: CLOSE csr_cust_party_details ;
345:
346: -- Ship To Information
347: IF l_claim_header.cust_shipto_acct_site_id IS NOT NULL THEN
344: CLOSE csr_cust_party_details ;
345:
346: -- Ship To Information
347: IF l_claim_header.cust_shipto_acct_site_id IS NOT NULL THEN
348: zx_global_structures_pkg.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(1) := l_claim_header.cust_shipto_acct_site_id;
349: OPEN csr_cust_party_details(l_claim_header.cust_shipto_acct_site_id);
350: FETCH csr_cust_party_details INTO zx_global_structures_pkg.trx_line_dist_tbl.ship_to_party_site_id(1),
351: zx_global_structures_pkg.trx_line_dist_tbl.ship_to_location_id(1);
352: CLOSE csr_cust_party_details ;
346: -- Ship To Information
347: IF l_claim_header.cust_shipto_acct_site_id IS NOT NULL THEN
348: zx_global_structures_pkg.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(1) := l_claim_header.cust_shipto_acct_site_id;
349: OPEN csr_cust_party_details(l_claim_header.cust_shipto_acct_site_id);
350: FETCH csr_cust_party_details INTO zx_global_structures_pkg.trx_line_dist_tbl.ship_to_party_site_id(1),
351: zx_global_structures_pkg.trx_line_dist_tbl.ship_to_location_id(1);
352: CLOSE csr_cust_party_details ;
353: END IF;
354:
347: IF l_claim_header.cust_shipto_acct_site_id IS NOT NULL THEN
348: zx_global_structures_pkg.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(1) := l_claim_header.cust_shipto_acct_site_id;
349: OPEN csr_cust_party_details(l_claim_header.cust_shipto_acct_site_id);
350: FETCH csr_cust_party_details INTO zx_global_structures_pkg.trx_line_dist_tbl.ship_to_party_site_id(1),
351: zx_global_structures_pkg.trx_line_dist_tbl.ship_to_location_id(1);
352: CLOSE csr_cust_party_details ;
353: END IF;
354:
355: END IF;
359: FETCH csr_cm_dm_trx_id INTO l_cm_trx_type_id, l_dm_trx_type_id;
360: CLOSE csr_cm_dm_trx_id;
361:
362: IF l_claim_header.payment_method = 'CREDIT_MEMO' THEN
363: zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(1) := l_cm_trx_type_id;
364: ELSE
365: zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(1) := l_dm_trx_type_id;
366: END IF;
367: END IF;
361:
362: IF l_claim_header.payment_method = 'CREDIT_MEMO' THEN
363: zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(1) := l_cm_trx_type_id;
364: ELSE
365: zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(1) := l_dm_trx_type_id;
366: END IF;
367: END IF;
368:
369: OPEN csr_function_currency;
370: FETCH csr_function_currency INTO l_function_currency;
371: CLOSE csr_function_currency;
372:
373: IF l_claim_header.currency_code <> l_function_currency THEN
374: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_date(1) := l_claim_header.exchange_rate_date;
375: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_rate(1) := l_claim_header.exchange_rate;
376: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_type(1) := l_claim_header.exchange_rate_type;
377: END IF;
378:
371: CLOSE csr_function_currency;
372:
373: IF l_claim_header.currency_code <> l_function_currency THEN
374: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_date(1) := l_claim_header.exchange_rate_date;
375: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_rate(1) := l_claim_header.exchange_rate;
376: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_type(1) := l_claim_header.exchange_rate_type;
377: END IF;
378:
379:
372:
373: IF l_claim_header.currency_code <> l_function_currency THEN
374: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_date(1) := l_claim_header.exchange_rate_date;
375: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_rate(1) := l_claim_header.exchange_rate;
376: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_type(1) := l_claim_header.exchange_rate_type;
377: END IF;
378:
379:
380: zx_global_structures_pkg.trx_line_dist_tbl.input_tax_classification_code(1) := NULL;
376: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_type(1) := l_claim_header.exchange_rate_type;
377: END IF;
378:
379:
380: zx_global_structures_pkg.trx_line_dist_tbl.input_tax_classification_code(1) := NULL;
381: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(1) := NULL;
382: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := NULL;
383: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := NULL;
384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := NULL;
377: END IF;
378:
379:
380: zx_global_structures_pkg.trx_line_dist_tbl.input_tax_classification_code(1) := NULL;
381: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(1) := NULL;
382: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := NULL;
383: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := NULL;
384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := NULL;
385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := NULL;
378:
379:
380: zx_global_structures_pkg.trx_line_dist_tbl.input_tax_classification_code(1) := NULL;
381: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(1) := NULL;
382: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := NULL;
383: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := NULL;
384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := NULL;
385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := NULL;
386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := NULL;
379:
380: zx_global_structures_pkg.trx_line_dist_tbl.input_tax_classification_code(1) := NULL;
381: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(1) := NULL;
382: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := NULL;
383: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := NULL;
384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := NULL;
385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := NULL;
386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := NULL;
387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := NULL;
380: zx_global_structures_pkg.trx_line_dist_tbl.input_tax_classification_code(1) := NULL;
381: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(1) := NULL;
382: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := NULL;
383: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := NULL;
384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := NULL;
385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := NULL;
386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := NULL;
387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := NULL;
388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := NULL;
381: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(1) := NULL;
382: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := NULL;
383: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := NULL;
384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := NULL;
385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := NULL;
386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := NULL;
387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := NULL;
388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := NULL;
389: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := NULL;
382: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := NULL;
383: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := NULL;
384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := NULL;
385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := NULL;
386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := NULL;
387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := NULL;
388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := NULL;
389: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := NULL;
390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := NULL;
383: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := NULL;
384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := NULL;
385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := NULL;
386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := NULL;
387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := NULL;
388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := NULL;
389: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := NULL;
390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := NULL;
391: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_number(1) := NULL;
384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := NULL;
385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := NULL;
386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := NULL;
387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := NULL;
388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := NULL;
389: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := NULL;
390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := NULL;
391: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_number(1) := NULL;
392: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_date(1) := NULL;
385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := NULL;
386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := NULL;
387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := NULL;
388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := NULL;
389: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := NULL;
390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := NULL;
391: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_number(1) := NULL;
392: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_date(1) := NULL;
393:
386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := NULL;
387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := NULL;
388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := NULL;
389: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := NULL;
390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := NULL;
391: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_number(1) := NULL;
392: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_date(1) := NULL;
393:
394: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_id(1) := p_x_claim_line_rec.claim_line_id;
387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := NULL;
388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := NULL;
389: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := NULL;
390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := NULL;
391: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_number(1) := NULL;
392: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_date(1) := NULL;
393:
394: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_id(1) := p_x_claim_line_rec.claim_line_id;
395:
388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := NULL;
389: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := NULL;
390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := NULL;
391: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_number(1) := NULL;
392: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_date(1) := NULL;
393:
394: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_id(1) := p_x_claim_line_rec.claim_line_id;
395:
396: OPEN csr_stlmnt_tax_type(p_x_claim_line_rec.claim_id);
390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := NULL;
391: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_number(1) := NULL;
392: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_date(1) := NULL;
393:
394: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_id(1) := p_x_claim_line_rec.claim_line_id;
395:
396: OPEN csr_stlmnt_tax_type(p_x_claim_line_rec.claim_id);
397: FETCH csr_stlmnt_tax_type INTO l_tax_type;
398: CLOSE csr_stlmnt_tax_type;
398: CLOSE csr_stlmnt_tax_type;
399:
400: -- Switch Signs
401: IF l_tax_type = 'AP' THEN
402: zx_global_structures_pkg.trx_line_dist_tbl.input_tax_classification_code(1)
403: := p_x_claim_line_rec.tax_code;
404: IF l_claim_header.payment_method = 'AP_DEBIT' AND l_claim_header.claim_class = 'CLAIM' THEN
405: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount * -1 ;
406: ELSE
401: IF l_tax_type = 'AP' THEN
402: zx_global_structures_pkg.trx_line_dist_tbl.input_tax_classification_code(1)
403: := p_x_claim_line_rec.tax_code;
404: IF l_claim_header.payment_method = 'AP_DEBIT' AND l_claim_header.claim_class = 'CLAIM' THEN
405: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount * -1 ;
406: ELSE
407: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount ;
408: END IF;
409:
403: := p_x_claim_line_rec.tax_code;
404: IF l_claim_header.payment_method = 'AP_DEBIT' AND l_claim_header.claim_class = 'CLAIM' THEN
405: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount * -1 ;
406: ELSE
407: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount ;
408: END IF;
409:
410: ELSE
411: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(1)
407: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount ;
408: END IF;
409:
410: ELSE
411: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(1)
412: := p_x_claim_line_rec.tax_code;
413: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount * -1 ;
414:
415: END IF;
409:
410: ELSE
411: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(1)
412: := p_x_claim_line_rec.tax_code;
413: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount * -1 ;
414:
415: END IF;
416:
417:
416:
417:
418: IF l_tax_type = 'AR' AND p_x_claim_line_rec.item_id IS NOT NULL THEN
419: IF p_x_claim_line_rec. item_type = 'PRODUCT' THEN
420: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := p_x_claim_line_rec.item_id;
421: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := p_x_claim_line_rec.quantity_uom;
422: --bug5193067
423: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'GOOD';
424: ELSIF p_x_claim_line_rec. item_type = 'MEMO_LINE' THEN
417:
418: IF l_tax_type = 'AR' AND p_x_claim_line_rec.item_id IS NOT NULL THEN
419: IF p_x_claim_line_rec. item_type = 'PRODUCT' THEN
420: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := p_x_claim_line_rec.item_id;
421: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := p_x_claim_line_rec.quantity_uom;
422: --bug5193067
423: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'GOOD';
424: ELSIF p_x_claim_line_rec. item_type = 'MEMO_LINE' THEN
425: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := p_x_claim_line_rec.item_id;
419: IF p_x_claim_line_rec. item_type = 'PRODUCT' THEN
420: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := p_x_claim_line_rec.item_id;
421: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := p_x_claim_line_rec.quantity_uom;
422: --bug5193067
423: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'GOOD';
424: ELSIF p_x_claim_line_rec. item_type = 'MEMO_LINE' THEN
425: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := p_x_claim_line_rec.item_id;
426: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := p_x_claim_line_rec.quantity_uom;
427: --bug5193067
421: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := p_x_claim_line_rec.quantity_uom;
422: --bug5193067
423: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'GOOD';
424: ELSIF p_x_claim_line_rec. item_type = 'MEMO_LINE' THEN
425: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := p_x_claim_line_rec.item_id;
426: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := p_x_claim_line_rec.quantity_uom;
427: --bug5193067
428: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'MEMO';
429: END IF;
422: --bug5193067
423: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'GOOD';
424: ELSIF p_x_claim_line_rec. item_type = 'MEMO_LINE' THEN
425: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := p_x_claim_line_rec.item_id;
426: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := p_x_claim_line_rec.quantity_uom;
427: --bug5193067
428: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'MEMO';
429: END IF;
430: END IF;
424: ELSIF p_x_claim_line_rec. item_type = 'MEMO_LINE' THEN
425: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := p_x_claim_line_rec.item_id;
426: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := p_x_claim_line_rec.quantity_uom;
427: --bug5193067
428: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'MEMO';
429: END IF;
430: END IF;
431:
432: IF l_claim_header.payment_method IN ('REG_CREDIT_MEMO','RMA') AND
432: IF l_claim_header.payment_method IN ('REG_CREDIT_MEMO','RMA') AND
433: p_x_claim_line_rec.source_object_id IS NOT NULL
434: THEN
435: IF p_x_claim_line_rec.source_object_class = 'ORDER' THEN
436: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 660;
437: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'OE_ORDER_HEADERS_ALL';
438: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
439: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
440: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
433: p_x_claim_line_rec.source_object_id IS NOT NULL
434: THEN
435: IF p_x_claim_line_rec.source_object_class = 'ORDER' THEN
436: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 660;
437: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'OE_ORDER_HEADERS_ALL';
438: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
439: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
440: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
441: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
434: THEN
435: IF p_x_claim_line_rec.source_object_class = 'ORDER' THEN
436: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 660;
437: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'OE_ORDER_HEADERS_ALL';
438: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
439: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
440: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
441: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
442: ELSE
435: IF p_x_claim_line_rec.source_object_class = 'ORDER' THEN
436: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 660;
437: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'OE_ORDER_HEADERS_ALL';
438: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
439: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
440: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
441: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
442: ELSE
443: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 222;
436: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 660;
437: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'OE_ORDER_HEADERS_ALL';
438: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
439: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
440: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
441: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
442: ELSE
443: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 222;
444: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'TRANSACTIONS';
437: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'OE_ORDER_HEADERS_ALL';
438: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';
439: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
440: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
441: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
442: ELSE
443: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 222;
444: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'TRANSACTIONS';
445: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'INVOICE';
439: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
440: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
441: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
442: ELSE
443: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 222;
444: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'TRANSACTIONS';
445: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'INVOICE';
446: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
447: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
440: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
441: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
442: ELSE
443: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 222;
444: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'TRANSACTIONS';
445: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'INVOICE';
446: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
447: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
448: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
441: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
442: ELSE
443: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 222;
444: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'TRANSACTIONS';
445: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'INVOICE';
446: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
447: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
448: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
449: END IF;
442: ELSE
443: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 222;
444: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'TRANSACTIONS';
445: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'INVOICE';
446: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
447: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
448: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
449: END IF;
450: END IF;
443: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 222;
444: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'TRANSACTIONS';
445: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'INVOICE';
446: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
447: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
448: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
449: END IF;
450: END IF;
451:
444: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'TRANSACTIONS';
445: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'INVOICE';
446: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;
447: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;
448: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';
449: END IF;
450: END IF;
451:
452: -- Step 3: Make Call to Calculate Tax
453: IF OZF_DEBUG_HIGH_ON THEN
454: OZF_Utility_PVT.debug_message(l_full_name||' : Calling the tax engine');
455: END IF;
456:
457: l_transaction_rec.internal_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1);
458: l_transaction_rec.application_id := zx_global_structures_pkg.trx_line_dist_tbl.application_id(1);
459: l_transaction_rec.entity_code := zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1);
460: l_transaction_rec.event_class_code := zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1);
461: l_transaction_rec.event_type_code := zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1);
454: OZF_Utility_PVT.debug_message(l_full_name||' : Calling the tax engine');
455: END IF;
456:
457: l_transaction_rec.internal_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1);
458: l_transaction_rec.application_id := zx_global_structures_pkg.trx_line_dist_tbl.application_id(1);
459: l_transaction_rec.entity_code := zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1);
460: l_transaction_rec.event_class_code := zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1);
461: l_transaction_rec.event_type_code := zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1);
462: l_transaction_rec.trx_id := zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1);
455: END IF;
456:
457: l_transaction_rec.internal_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1);
458: l_transaction_rec.application_id := zx_global_structures_pkg.trx_line_dist_tbl.application_id(1);
459: l_transaction_rec.entity_code := zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1);
460: l_transaction_rec.event_class_code := zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1);
461: l_transaction_rec.event_type_code := zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1);
462: l_transaction_rec.trx_id := zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1);
463:
456:
457: l_transaction_rec.internal_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1);
458: l_transaction_rec.application_id := zx_global_structures_pkg.trx_line_dist_tbl.application_id(1);
459: l_transaction_rec.entity_code := zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1);
460: l_transaction_rec.event_class_code := zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1);
461: l_transaction_rec.event_type_code := zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1);
462: l_transaction_rec.trx_id := zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1);
463:
464:
457: l_transaction_rec.internal_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1);
458: l_transaction_rec.application_id := zx_global_structures_pkg.trx_line_dist_tbl.application_id(1);
459: l_transaction_rec.entity_code := zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1);
460: l_transaction_rec.event_class_code := zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1);
461: l_transaction_rec.event_type_code := zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1);
462: l_transaction_rec.trx_id := zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1);
463:
464:
465: ZX_API_PUB.calculate_tax( p_api_version => 1.0,
458: l_transaction_rec.application_id := zx_global_structures_pkg.trx_line_dist_tbl.application_id(1);
459: l_transaction_rec.entity_code := zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1);
460: l_transaction_rec.event_class_code := zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1);
461: l_transaction_rec.event_type_code := zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1);
462: l_transaction_rec.trx_id := zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1);
463:
464:
465: ZX_API_PUB.calculate_tax( p_api_version => 1.0,
466: p_init_msg_list => p_init_msg_list,