DBA Data[Home] [Help]

APPS.OZF_CLAIM_TAX_PVT dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 254: zx_global_structures_pkg.init_trx_line_dist_tbl(1);

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;

Line 257: zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1) := l_claim_header.org_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;

Line 258: zx_global_structures_pkg.trx_line_dist_tbl.trx_id(1) := l_claim_header.claim_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;

Line 259: zx_global_structures_pkg.trx_line_dist_tbl.trx_date(1) := NVL(l_claim_header.effective_date, SYSDATE);

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;

Line 260: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_date(1) := NVL(l_claim_header.effective_date, SYSDATE);

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';

Line 261: zx_global_structures_pkg.trx_line_dist_tbl.ledger_id(1) := l_claim_header.set_of_books_id;

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';

Line 262: zx_global_structures_pkg.trx_line_dist_tbl.trx_currency_code(1) := l_claim_header.currency_code;

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';

Line 263: zx_global_structures_pkg.trx_line_dist_tbl.legal_entity_id(1) := l_claim_header.legal_entity_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';
267:

Line 264: zx_global_structures_pkg.trx_line_dist_tbl.trx_level_type(1) := 'LINE';

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);

Line 265: zx_global_structures_pkg.trx_line_dist_tbl.line_level_action(1) := 'CREATE';

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)

Line 266: zx_global_structures_pkg.trx_line_dist_tbl.quote_flag(1) := 'Y';

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);

Line 269: FETCH csr_curr_details INTO zx_global_structures_pkg.trx_line_dist_tbl.minimum_accountable_unit(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';

Line 270: , zx_global_structures_pkg.trx_line_dist_tbl.precision(1);

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:

Line 273: zx_global_structures_pkg.trx_line_dist_tbl.line_amt_includes_tax_flag(1) := 'N';

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;

Line 282: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 200;

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';

Line 283: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'AP_INVOICES';

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';

Line 284: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'STANDARD INVOICES';

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';

Line 285: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;

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:

Line 286: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';

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

Line 287: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_PAYABLES';

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);

Line 288: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'STANDARD CREATED';

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),

Line 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?

Line 293: zx_global_structures_pkg.trx_line_dist_tbl.ship_from_location_id(1);

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) := ??

Line 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);

Line 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:

Line 306: zx_global_structures_pkg.trx_line_dist_tbl.application_id(1) := 222;

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';

Line 307: zx_global_structures_pkg.trx_line_dist_tbl.entity_code(1) := 'TRANSACTIONS';

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';

Line 310: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';

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';

Line 311: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CREATE';

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';

Line 314: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'CREDIT_MEMO';

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

Line 315: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'CM_CREATE';

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';

Line 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';

Line 320: 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';
324: END IF;

Line 322: zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1) := 'DEBIT_MEMO';

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;

Line 323: zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1) := 'DM_CREATE';

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';

Line 326: zx_global_structures_pkg.trx_line_dist_tbl.source_application_id(1) := 682;

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;

Line 327: zx_global_structures_pkg.trx_line_dist_tbl.source_entity_code(1) := 'OZF_CLAIMS';

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:

Line 328: zx_global_structures_pkg.trx_line_dist_tbl.source_event_class_code(1) := 'TRADE_MGT_RECEIVABLES';

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.

Line 333: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_party_id(1) := ??;

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:

Line 334: -- zx_global_structures_pkg.trx_line_dist_tbl.ship_from_location_id(1) := ??

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:

Line 335: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_party_id(1) := ??;

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

Line 336: -- zx_global_structures_pkg.trx_line_dist_tbl.bill_from_location_id(1) := ??

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);

Line 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 ;

Line 341: OPEN csr_cust_party_details(zx_global_structures_pkg.trx_line_dist_tbl.bill_to_cust_acct_site_use_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 ;
345:

Line 342: FETCH csr_cust_party_details INTO zx_global_structures_pkg.trx_line_dist_tbl.bill_to_party_site_id(1),

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

Line 343: zx_global_structures_pkg.trx_line_dist_tbl.bill_to_location_id(1);

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

Line 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;

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 ;

Line 350: FETCH csr_cust_party_details INTO zx_global_structures_pkg.trx_line_dist_tbl.ship_to_party_site_id(1),

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:

Line 351: zx_global_structures_pkg.trx_line_dist_tbl.ship_to_location_id(1);

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;

Line 363: zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(1) := l_cm_trx_type_id;

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;

Line 365: zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(1) := l_dm_trx_type_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;
368:
369: OPEN csr_function_currency;

Line 374: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_date(1) := l_claim_header.exchange_rate_date;

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:

Line 375: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_rate(1) := l_claim_header.exchange_rate;

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:

Line 376: zx_global_structures_pkg.trx_line_dist_tbl.currency_conversion_type(1) := l_claim_header.exchange_rate_type;

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;

Line 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;

Line 381: zx_global_structures_pkg.trx_line_dist_tbl.output_tax_classification_code(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;

Line 382: zx_global_structures_pkg.trx_line_dist_tbl.product_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;

Line 383: zx_global_structures_pkg.trx_line_dist_tbl.uom_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;

Line 384: zx_global_structures_pkg.trx_line_dist_tbl.product_type(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;

Line 385: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_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;

Line 386: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_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;
390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := NULL;

Line 387: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(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;

Line 388: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(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;

Line 389: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_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;
393:

Line 390: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_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:
394: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_id(1) := p_x_claim_line_rec.claim_line_id;

Line 391: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_number(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;
395:

Line 392: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_date(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:
396: OPEN csr_stlmnt_tax_type(p_x_claim_line_rec.claim_id);

Line 394: zx_global_structures_pkg.trx_line_dist_tbl.trx_line_id(1) := p_x_claim_line_rec.claim_line_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;

Line 402: zx_global_structures_pkg.trx_line_dist_tbl.input_tax_classification_code(1)

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

Line 405: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount * -1 ;

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:

Line 407: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount ;

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)

Line 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;

Line 413: zx_global_structures_pkg.trx_line_dist_tbl.line_amt(1) := p_x_claim_line_rec.amount * -1 ;

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:

Line 420: zx_global_structures_pkg.trx_line_dist_tbl.product_id(1) := p_x_claim_line_rec.item_id;

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

Line 421: zx_global_structures_pkg.trx_line_dist_tbl.uom_code(1) := p_x_claim_line_rec.quantity_uom;

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;

Line 423: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'GOOD';

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

Line 425: 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
428: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'MEMO';
429: END IF;

Line 426: 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;
430: END IF;

Line 428: --zx_global_structures_pkg.trx_line_dist_tbl.product_type(1) := 'MEMO';

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

Line 436: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 660;

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;

Line 437: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'OE_ORDER_HEADERS_ALL';

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';

Line 438: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'SALES_TRANSACTION_TAX_QUOTE';

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

Line 439: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;

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;

Line 440: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;

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';

Line 441: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';

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';

Line 443: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_application_id(1) := 222;

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;

Line 444: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_entity_code(1) := 'TRANSACTIONS';

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';

Line 445: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_event_class_code(1) := 'INVOICE';

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;

Line 446: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_id(1) := p_x_claim_line_rec.source_object_id;

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;

Line 447: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_line_id(1) := p_x_claim_line_rec.source_object_line_id;

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:

Line 448: zx_global_structures_pkg.trx_line_dist_tbl.adjusted_doc_trx_level_type(1) := 'LINE';

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

Line 457: l_transaction_rec.internal_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(1);

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);

Line 458: l_transaction_rec.application_id := zx_global_structures_pkg.trx_line_dist_tbl.application_id(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);

Line 459: l_transaction_rec.entity_code := zx_global_structures_pkg.trx_line_dist_tbl.entity_code(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:

Line 460: l_transaction_rec.event_class_code := zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(1);

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:

Line 461: l_transaction_rec.event_type_code := zx_global_structures_pkg.trx_line_dist_tbl.event_type_code(1);

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,

Line 462: l_transaction_rec.trx_id := zx_global_structures_pkg.trx_line_dist_tbl.trx_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,
466: p_init_msg_list => p_init_msg_list,