eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_CALC_SERVICES_PUB_PKG dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 113: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(

109: -- 'ALLOCATE_LINE_ONLY_ADJUSTMENT'
110: -- Bug 5440023: Do not skip regime determination for line_level_action
111: -- 'LINE_INFO_TAX_ONLY' if it is partner integration
112: --
113: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
114: p_trx_line_index) IS NULL
115: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
116: p_trx_line_index) IS NULL
117: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code (

Line 115: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

111: -- 'LINE_INFO_TAX_ONLY' if it is partner integration
112: --
113: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
114: p_trx_line_index) IS NULL
115: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
116: p_trx_line_index) IS NULL
117: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code (
118: p_trx_line_index ) <> 'OVERRIDE_TAX'
119: AND nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag (

Line 117: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code (

113: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
114: p_trx_line_index) IS NULL
115: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
116: p_trx_line_index) IS NULL
117: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code (
118: p_trx_line_index ) <> 'OVERRIDE_TAX'
119: AND nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag (
120: p_trx_line_index ), 'N') = 'N'
121: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (

Line 119: AND nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag (

115: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
116: p_trx_line_index) IS NULL
117: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code (
118: p_trx_line_index ) <> 'OVERRIDE_TAX'
119: AND nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag (
120: p_trx_line_index ), 'N') = 'N'
121: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (
122: p_trx_line_index ) NOT IN ('CANCEL', 'SYNCHRONIZE', 'DISCARD',
123: 'RECORD_WITH_NO_TAX', 'NO_CHANGE',

Line 121: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (

117: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code (
118: p_trx_line_index ) <> 'OVERRIDE_TAX'
119: AND nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag (
120: p_trx_line_index ), 'N') = 'N'
121: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (
122: p_trx_line_index ) NOT IN ('CANCEL', 'SYNCHRONIZE', 'DISCARD',
123: 'RECORD_WITH_NO_TAX', 'NO_CHANGE',
124: 'ALLOCATE_LINE_ONLY_ADJUSTMENT'))
125: THEN

Line 131: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action ( p_trx_line_index ) = 'LINE_INFO_TAX_ONLY'

127: --
128: -- Bug#5440023- do not process non partner and line level
129: -- action is 'LINE_INFO_TAX_ONLY'
130: --
131: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action ( p_trx_line_index ) = 'LINE_INFO_TAX_ONLY'
132: AND NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'N' ) THEN
133:
134: RETURN;
135:

Line 132: AND NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'N' ) THEN

128: -- Bug#5440023- do not process non partner and line level
129: -- action is 'LINE_INFO_TAX_ONLY'
130: --
131: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action ( p_trx_line_index ) = 'LINE_INFO_TAX_ONLY'
132: AND NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'N' ) THEN
133:
134: RETURN;
135:
136: END IF;

Line 277: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

273: -- 'RECORD_WITH_NO_TAX'
274: -- Bug 3893366: Skip processing tax applicability for line_level_action
275: -- 'ALLOCATE_LINE_ONLY_ADJUSTMENT'
276: --
277: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
278: p_trx_line_index) IN ( 'RECORD_WITH_NO_TAX',
279: 'ALLOCATE_LINE_ONLY_ADJUSTMENT')
280: THEN
281: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 296: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

292: --l_begin_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST+1;
293:
294: -- Bug 3971006
295: --
296: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
297: p_trx_line_index) = 'CREATE' AND
298: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
299: p_trx_line_index) ='COPY_AND_CREATE'
300: THEN

Line 298: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

294: -- Bug 3971006
295: --
296: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
297: p_trx_line_index) = 'CREATE' AND
298: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
299: p_trx_line_index) ='COPY_AND_CREATE'
300: THEN
301:
302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_copy_and_create_flg := 'Y';

Line 309: /*IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

305:
306:
307: -- bug fix 5417887
308: -- following setting has been done in the srv type pkg for each trx
309: /*IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
310: p_trx_line_index) = 'UPDATE'
311: THEN
312: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'Y';
313: END IF;

Line 312: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'Y';

308: -- following setting has been done in the srv type pkg for each trx
309: /*IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
310: p_trx_line_index) = 'UPDATE'
311: THEN
312: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'Y';
313: END IF;
314: */
315:
316: -- bug 3770874: set global variables for line_level_action 'CANCEL'/DISCARD'

Line 319: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

315:
316: -- bug 3770874: set global variables for line_level_action 'CANCEL'/DISCARD'
317: -- Remove tax_event_type 'DELETE' and 'CANCEL'
318: --
319: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
320: p_trx_line_index) = 'UPDATE' AND
321: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
322: p_trx_line_index) IN ('CANCEL', 'SYNCHRONIZE', 'DISCARD', 'NO_CHANGE',
323: 'UNAPPLY_FROM')

Line 321: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

317: -- Remove tax_event_type 'DELETE' and 'CANCEL'
318: --
319: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
320: p_trx_line_index) = 'UPDATE' AND
321: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
322: p_trx_line_index) IN ('CANCEL', 'SYNCHRONIZE', 'DISCARD', 'NO_CHANGE',
323: 'UNAPPLY_FROM')
324: THEN
325:

Line 326: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index) = 'Y' AND

322: p_trx_line_index) IN ('CANCEL', 'SYNCHRONIZE', 'DISCARD', 'NO_CHANGE',
323: 'UNAPPLY_FROM')
324: THEN
325:
326: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index) = 'Y' AND
327: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) IN
328: ('CANCEL', 'DISCARD', 'NO_CHANGE', 'UNAPPLY_FROM')
329: THEN
330:

Line 327: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) IN

323: 'UNAPPLY_FROM')
324: THEN
325:
326: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index) = 'Y' AND
327: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) IN
328: ('CANCEL', 'DISCARD', 'NO_CHANGE', 'UNAPPLY_FROM')
329: THEN
330:
331: l_upg_trx_info_rec.application_id

Line 332: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);

328: ('CANCEL', 'DISCARD', 'NO_CHANGE', 'UNAPPLY_FROM')
329: THEN
330:
331: l_upg_trx_info_rec.application_id
332: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
333: l_upg_trx_info_rec.event_class_code
334: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);
335: l_upg_trx_info_rec.entity_code
336: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);

Line 334: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);

330:
331: l_upg_trx_info_rec.application_id
332: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
333: l_upg_trx_info_rec.event_class_code
334: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);
335: l_upg_trx_info_rec.entity_code
336: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
337: l_upg_trx_info_rec.trx_id
338: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);

Line 336: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);

332: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
333: l_upg_trx_info_rec.event_class_code
334: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);
335: l_upg_trx_info_rec.entity_code
336: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
337: l_upg_trx_info_rec.trx_id
338: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);
339: l_upg_trx_info_rec.trx_line_id
340: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);

Line 338: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);

334: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);
335: l_upg_trx_info_rec.entity_code
336: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
337: l_upg_trx_info_rec.trx_id
338: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);
339: l_upg_trx_info_rec.trx_line_id
340: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
341: l_upg_trx_info_rec.trx_level_type
342: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);

Line 340: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);

336: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
337: l_upg_trx_info_rec.trx_id
338: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);
339: l_upg_trx_info_rec.trx_line_id
340: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
341: l_upg_trx_info_rec.trx_level_type
342: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
343:
344: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(

Line 342: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);

338: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);
339: l_upg_trx_info_rec.trx_line_id
340: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
341: l_upg_trx_info_rec.trx_level_type
342: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
343:
344: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(
345: p_upg_trx_info_rec => l_upg_trx_info_rec,
346: x_trx_migrated_b => l_trx_migrated_b,

Line 374: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

370: END IF;
371: END IF; -- NOT l_trx_migrated_b
372: END IF; -- historical_flag = 'Y'
373:
374: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
375: p_trx_line_index) ='CANCEL' THEN
376:
377: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_cancel_exist_flg := 'Y';
378:

Line 379: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

375: p_trx_line_index) ='CANCEL' THEN
376:
377: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_cancel_exist_flg := 'Y';
378:
379: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
380: p_trx_line_index) ='DISCARD' THEN
381:
382: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_discard_exist_flg:= 'Y';
383:

Line 384: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

380: p_trx_line_index) ='DISCARD' THEN
381:
382: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_discard_exist_flg:= 'Y';
383:
384: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
385: p_trx_line_index) = 'UNAPPLY_FROM' THEN
386:
387: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_discard_exist_flg:= 'Y';
388:

Line 389: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

385: p_trx_line_index) = 'UNAPPLY_FROM' THEN
386:
387: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_discard_exist_flg:= 'Y';
388:
389: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
390: p_trx_line_index) ='NO_CHANGE' THEN
391:
392: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_nochange_exist_flg := 'Y';
393:

Line 413: IF( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

409: g_trx_alphanum_value_tbl.DELETE;
410:
411: -- get tax date for tax event type other than 'OVERRIDE_TAX'
412: --
413: IF( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
414: p_trx_line_index) <> 'OVERRIDE_TAX') THEN
415:
416: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(
417: p_trx_line_index,

Line 443: --IF p_trx_line_index = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST

439:
440: -- comment out for bug fix 5417887
441: -- Initialize g_detail_tax_lines_tbl when it is the first transaction line
442: --
443: --IF p_trx_line_index = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST
444: --THEN
445:
446: -- g_detail_tax_lines_tbl.DELETE;
447: --END IF;

Line 453: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(

449: -- If ref_doc_application_id is not null and it is not an override tax case,
450: -- set the g_reference_doc_exist_flg, so that in the tail end service to
451: -- call process_reference_tax_lines().
452:
453: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
454: p_trx_line_index) IS NOT NULL AND
455: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
456: p_trx_line_index) <> 'OVERRIDE_TAX'
457: THEN

Line 455: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

451: -- call process_reference_tax_lines().
452:
453: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
454: p_trx_line_index) IS NOT NULL AND
455: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
456: p_trx_line_index) <> 'OVERRIDE_TAX'
457: THEN
458: g_reference_doc_exist_flg := 'Y';
459: END IF;

Line 461: IF( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

457: THEN
458: g_reference_doc_exist_flg := 'Y';
459: END IF;
460:
461: IF( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
462: p_trx_line_index) ='CREATE' OR
463: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
464: p_trx_line_index) ='UPDATE' OR
465: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

Line 463: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

459: END IF;
460:
461: IF( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
462: p_trx_line_index) ='CREATE' OR
463: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
464: p_trx_line_index) ='UPDATE' OR
465: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
466: p_trx_line_index) = 'OVERRIDE_TAX') THEN
467:

Line 465: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

461: IF( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
462: p_trx_line_index) ='CREATE' OR
463: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
464: p_trx_line_index) ='UPDATE' OR
465: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
466: p_trx_line_index) = 'OVERRIDE_TAX') THEN
467:
468: -- IF it is a migrated transaction,
469: -- fetch all tax lines from current document, skip applicability process

Line 489: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index)

485: -- and cash receipt info in applied from columns.
486: -- In this case, tax calculation must be done using invoice
487: -- (ie. adjusted doc info).
488:
489: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index)
490: = 'Y' OR
491: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
492: p_trx_line_index) = 'OVERRIDE_TAX'
493: THEN

Line 491: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

487: -- (ie. adjusted doc info).
488:
489: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index)
490: = 'Y' OR
491: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
492: p_trx_line_index) = 'OVERRIDE_TAX'
493: THEN
494:
495: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(

Line 529: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index) = 'Y' THEN

525: -- transaction on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines
526: -- again to fetch the tax lines for the historical transaction.
527:
528: IF ((l_begin_index IS NULL) OR (l_begin_index = l_end_index)) AND
529: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index) = 'Y' THEN
530:
531: l_upg_trx_info_rec.application_id
532: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
533: l_upg_trx_info_rec.event_class_code

Line 532: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);

528: IF ((l_begin_index IS NULL) OR (l_begin_index = l_end_index)) AND
529: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index) = 'Y' THEN
530:
531: l_upg_trx_info_rec.application_id
532: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
533: l_upg_trx_info_rec.event_class_code
534: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);
535: l_upg_trx_info_rec.entity_code
536: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);

Line 534: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);

530:
531: l_upg_trx_info_rec.application_id
532: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
533: l_upg_trx_info_rec.event_class_code
534: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);
535: l_upg_trx_info_rec.entity_code
536: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
537: l_upg_trx_info_rec.trx_id
538: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);

Line 536: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);

532: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
533: l_upg_trx_info_rec.event_class_code
534: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);
535: l_upg_trx_info_rec.entity_code
536: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
537: l_upg_trx_info_rec.trx_id
538: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);
539: l_upg_trx_info_rec.trx_line_id
540: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);

Line 538: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);

534: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);
535: l_upg_trx_info_rec.entity_code
536: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
537: l_upg_trx_info_rec.trx_id
538: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);
539: l_upg_trx_info_rec.trx_line_id
540: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
541: l_upg_trx_info_rec.trx_level_type
542: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);

Line 540: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);

536: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
537: l_upg_trx_info_rec.trx_id
538: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);
539: l_upg_trx_info_rec.trx_line_id
540: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
541: l_upg_trx_info_rec.trx_level_type
542: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
543:
544: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(

Line 542: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);

538: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_index);
539: l_upg_trx_info_rec.trx_line_id
540: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
541: l_upg_trx_info_rec.trx_level_type
542: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
543:
544: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(
545: p_upg_trx_info_rec => l_upg_trx_info_rec,
546: x_trx_migrated_b => l_trx_migrated_b,

Line 602: ELSIF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

598:
599: END IF;
600: END IF;
601:
602: ELSIF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
603: p_trx_line_index) IS NOT NULL ) THEN
604:
605: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(
606: p_event_class_rec,

Line 641: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

637:
638: IF (l_begin_index IS NULL) OR (l_begin_index = l_end_index) THEN
639:
640: l_upg_trx_info_rec.application_id
641: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
642: p_trx_line_index);
643: l_upg_trx_info_rec.event_class_code
644: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
645: p_trx_line_index);

Line 644: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(

640: l_upg_trx_info_rec.application_id
641: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
642: p_trx_line_index);
643: l_upg_trx_info_rec.event_class_code
644: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
645: p_trx_line_index);
646: l_upg_trx_info_rec.entity_code
647: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
648: p_trx_line_index);

Line 647: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(

643: l_upg_trx_info_rec.event_class_code
644: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
645: p_trx_line_index);
646: l_upg_trx_info_rec.entity_code
647: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
648: p_trx_line_index);
649: l_upg_trx_info_rec.trx_id
650: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
651: p_trx_line_index);

Line 650: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(

646: l_upg_trx_info_rec.entity_code
647: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
648: p_trx_line_index);
649: l_upg_trx_info_rec.trx_id
650: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
651: p_trx_line_index);
652: l_upg_trx_info_rec.trx_line_id
653: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
654: p_trx_line_index);

Line 653: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(

649: l_upg_trx_info_rec.trx_id
650: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
651: p_trx_line_index);
652: l_upg_trx_info_rec.trx_line_id
653: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
654: p_trx_line_index);
655: l_upg_trx_info_rec.trx_level_type
656: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
657: p_trx_line_index);

Line 656: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(

652: l_upg_trx_info_rec.trx_line_id
653: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
654: p_trx_line_index);
655: l_upg_trx_info_rec.trx_level_type
656: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
657: p_trx_line_index);
658:
659: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(
660: p_upg_trx_info_rec => l_upg_trx_info_rec,

Line 717: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(

713:
714: END IF;
715: END IF;
716:
717: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
718: p_trx_line_index) IS NOT NULL
719: THEN
720:
721: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(

Line 758: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(

754:
755: IF (l_begin_index IS NULL) OR (l_begin_index = l_end_index) THEN
756:
757: l_upg_trx_info_rec.application_id
758: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
759: p_trx_line_index);
760: l_upg_trx_info_rec.event_class_code
761: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(
762: p_trx_line_index);

Line 761: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(

757: l_upg_trx_info_rec.application_id
758: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
759: p_trx_line_index);
760: l_upg_trx_info_rec.event_class_code
761: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(
762: p_trx_line_index);
763: l_upg_trx_info_rec.entity_code
764: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(
765: p_trx_line_index);

Line 764: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(

760: l_upg_trx_info_rec.event_class_code
761: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(
762: p_trx_line_index);
763: l_upg_trx_info_rec.entity_code
764: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(
765: p_trx_line_index);
766: l_upg_trx_info_rec.trx_id
767: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(
768: p_trx_line_index);

Line 767: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(

763: l_upg_trx_info_rec.entity_code
764: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(
765: p_trx_line_index);
766: l_upg_trx_info_rec.trx_id
767: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(
768: p_trx_line_index);
769: l_upg_trx_info_rec.trx_line_id
770: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(
771: p_trx_line_index);

Line 770: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(

766: l_upg_trx_info_rec.trx_id
767: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(
768: p_trx_line_index);
769: l_upg_trx_info_rec.trx_line_id
770: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(
771: p_trx_line_index);
772: l_upg_trx_info_rec.trx_level_type
773: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(
774: p_trx_line_index);

Line 773: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(

769: l_upg_trx_info_rec.trx_line_id
770: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(
771: p_trx_line_index);
772: l_upg_trx_info_rec.trx_level_type
773: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(
774: p_trx_line_index);
775:
776: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(
777: p_upg_trx_info_rec => l_upg_trx_info_rec,

Line 840: IF (((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

836:
837: -- For UPDATE case, fetch manual tax lines from zx_lines
838: --
839:
840: IF (((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
841: p_trx_line_index) = 'UPDATE')
842: OR
843: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
844: p_trx_line_index) ='UPDATE' AND

Line 843: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

839:
840: IF (((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
841: p_trx_line_index) = 'UPDATE')
842: OR
843: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
844: p_trx_line_index) ='UPDATE' AND
845: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
846: p_trx_line_index) = 'LINE_INFO_TAX_ONLY'
847: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

Line 845: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

841: p_trx_line_index) = 'UPDATE')
842: OR
843: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
844: p_trx_line_index) ='UPDATE' AND
845: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
846: p_trx_line_index) = 'LINE_INFO_TAX_ONLY'
847: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
848: p_trx_line_index) = 'CREATE_WITH_TAX') -- Bug 8205359
849: ))) AND --bug#8534499

Line 847: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

843: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
844: p_trx_line_index) ='UPDATE' AND
845: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
846: p_trx_line_index) = 'LINE_INFO_TAX_ONLY'
847: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
848: p_trx_line_index) = 'CREATE_WITH_TAX') -- Bug 8205359
849: ))) AND --bug#8534499
850: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
851: p_trx_line_index) <> 'INTERCOMPANY_TRX' OR

Line 850: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(

846: p_trx_line_index) = 'LINE_INFO_TAX_ONLY'
847: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
848: p_trx_line_index) = 'CREATE_WITH_TAX') -- Bug 8205359
849: ))) AND --bug#8534499
850: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
851: p_trx_line_index) <> 'INTERCOMPANY_TRX' OR
852: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
853: p_trx_line_index) IS NULL) THEN -- Bug 5291394
854:

Line 852: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(

848: p_trx_line_index) = 'CREATE_WITH_TAX') -- Bug 8205359
849: ))) AND --bug#8534499
850: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
851: p_trx_line_index) <> 'INTERCOMPANY_TRX' OR
852: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
853: p_trx_line_index) IS NULL) THEN -- Bug 5291394
854:
855: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(
856: p_event_class_rec,

Line 891: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(

887:
888: IF (l_begin_index IS NULL) OR (l_begin_index = l_end_index) THEN
889:
890: l_upg_trx_info_rec.application_id
891: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(
892: p_trx_line_index);
893: l_upg_trx_info_rec.event_class_code
894: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(
895: p_trx_line_index);

Line 894: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(

890: l_upg_trx_info_rec.application_id
891: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(
892: p_trx_line_index);
893: l_upg_trx_info_rec.event_class_code
894: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(
895: p_trx_line_index);
896: l_upg_trx_info_rec.entity_code
897: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(
898: p_trx_line_index);

Line 897: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(

893: l_upg_trx_info_rec.event_class_code
894: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(
895: p_trx_line_index);
896: l_upg_trx_info_rec.entity_code
897: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(
898: p_trx_line_index);
899: l_upg_trx_info_rec.trx_id
900: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(
901: p_trx_line_index);

Line 900: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(

896: l_upg_trx_info_rec.entity_code
897: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(
898: p_trx_line_index);
899: l_upg_trx_info_rec.trx_id
900: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(
901: p_trx_line_index);
902: l_upg_trx_info_rec.trx_line_id
903: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(
904: p_trx_line_index);

Line 903: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(

899: l_upg_trx_info_rec.trx_id
900: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(
901: p_trx_line_index);
902: l_upg_trx_info_rec.trx_line_id
903: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(
904: p_trx_line_index);
905: l_upg_trx_info_rec.trx_level_type
906: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(
907: p_trx_line_index);

Line 906: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(

902: l_upg_trx_info_rec.trx_line_id
903: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(
904: p_trx_line_index);
905: l_upg_trx_info_rec.trx_level_type
906: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(
907: p_trx_line_index);
908:
909: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(
910: p_upg_trx_info_rec => l_upg_trx_info_rec,

Line 968: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

964: END IF;
965: END IF;
966: END IF; -- -- line_level_action = 'UPDATE'
967:
968: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
969: p_trx_line_index) IN ('CREATE', 'UPDATE')
970: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
971: p_trx_line_index) = 'INTERCOMPANY_TRX'
972: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(

Line 970: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(

966: END IF; -- -- line_level_action = 'UPDATE'
967:
968: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
969: p_trx_line_index) IN ('CREATE', 'UPDATE')
970: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
971: p_trx_line_index) = 'INTERCOMPANY_TRX'
972: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
973: p_trx_line_index) IS NOT NULL
974: THEN

Line 972: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(

968: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
969: p_trx_line_index) IN ('CREATE', 'UPDATE')
970: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
971: p_trx_line_index) = 'INTERCOMPANY_TRX'
972: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
973: p_trx_line_index) IS NOT NULL
974: THEN
975:
976: ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(

Line 1012: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index),

1008:
1009: IF ((l_begin_index IS NULL) OR (l_begin_index = l_end_index) ) THEN
1010:
1011: OPEN get_source_doc_info (
1012: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index),
1013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index),
1014: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
1015: );
1016:

Line 1013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index),

1009: IF ((l_begin_index IS NULL) OR (l_begin_index = l_end_index) ) THEN
1010:
1011: OPEN get_source_doc_info (
1012: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index),
1013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index),
1014: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
1015: );
1016:
1017: FETCH get_source_doc_info into

Line 1014: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)

1010:
1011: OPEN get_source_doc_info (
1012: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index),
1013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index),
1014: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
1015: );
1016:
1017: FETCH get_source_doc_info into
1018: l_upg_trx_info_rec.application_id,

Line 1032: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) );

1028: 'No record found in zx_evnt_mappings.' );
1029: FND_LOG.STRING(g_level_statement,
1030: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1031: 'application_id: '||
1032: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) );
1033: FND_LOG.STRING(g_level_statement,
1034: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1035: 'entity_code: '||
1036: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) );

Line 1036: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) );

1032: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) );
1033: FND_LOG.STRING(g_level_statement,
1034: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1035: 'entity_code: '||
1036: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) );
1037: FND_LOG.STRING(g_level_statement,
1038: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1039: 'event_class_code: '||
1040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) );

Line 1040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) );

1036: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) );
1037: FND_LOG.STRING(g_level_statement,
1038: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1039: 'event_class_code: '||
1040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) );
1041: FND_LOG.STRING(g_level_statement,
1042: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1043: 'RETURN_STATUS = ' || x_return_status);
1044: FND_LOG.STRING(g_level_statement,

Line 1052: /* IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_CREDIT_MEMO' THEN

1048: RETURN;
1049: END IF;
1050:
1051: --Bug 9587918
1052: /* IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_CREDIT_MEMO' THEN
1053: l_upg_trx_info_rec.event_class_code := 'CREDIT_MEMO';
1054: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_DEBIT_MEMO' THEN
1055: l_upg_trx_info_rec.event_class_code := 'DEBIT_MEMO';
1056: END IF; */

Line 1054: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_DEBIT_MEMO' THEN

1050:
1051: --Bug 9587918
1052: /* IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_CREDIT_MEMO' THEN
1053: l_upg_trx_info_rec.event_class_code := 'CREDIT_MEMO';
1054: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_DEBIT_MEMO' THEN
1055: l_upg_trx_info_rec.event_class_code := 'DEBIT_MEMO';
1056: END IF; */
1057:
1058: l_upg_trx_info_rec.trx_id

Line 1059: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(

1055: l_upg_trx_info_rec.event_class_code := 'DEBIT_MEMO';
1056: END IF; */
1057:
1058: l_upg_trx_info_rec.trx_id
1059: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
1060: p_trx_line_index);
1061: l_upg_trx_info_rec.trx_line_id
1062: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(
1063: p_trx_line_index);

Line 1062: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(

1058: l_upg_trx_info_rec.trx_id
1059: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
1060: p_trx_line_index);
1061: l_upg_trx_info_rec.trx_line_id
1062: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(
1063: p_trx_line_index);
1064: l_upg_trx_info_rec.trx_level_type
1065: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(
1066: p_trx_line_index);

Line 1065: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(

1061: l_upg_trx_info_rec.trx_line_id
1062: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(
1063: p_trx_line_index);
1064: l_upg_trx_info_rec.trx_level_type
1065: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(
1066: p_trx_line_index);
1067:
1068: --Bug 10631930 (continuation of bug 9587918, relaxing event class code check for intercompany invoices)
1069:

Line 1160: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (

1156: -- 'CREATE_WITH_TAX', incase user updates any of the header level tax determining
1157: -- attributes for an imported transaction, which has manual tax line. Adding perform
1158: -- additional flag for future purposes.
1159:
1160: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (
1161: p_trx_line_index ) <> 'LINE_INFO_TAX_ONLY' AND
1162: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (
1163: p_trx_line_index ) <> 'CREATE_WITH_TAX'
1164: OR NVL(p_event_class_rec.perf_addnl_appl_for_imprt_flag,'N') = 'Y') AND

Line 1162: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (

1158: -- additional flag for future purposes.
1159:
1160: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (
1161: p_trx_line_index ) <> 'LINE_INFO_TAX_ONLY' AND
1162: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (
1163: p_trx_line_index ) <> 'CREATE_WITH_TAX'
1164: OR NVL(p_event_class_rec.perf_addnl_appl_for_imprt_flag,'N') = 'Y') AND
1165: p_event_class_rec.process_for_applicability_flag = 'Y' AND
1166: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg, 'Y') = 'Y' AND

Line 1213: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0) ..

1209:
1210:
1211: ELSE
1212: FOR regime_index IN
1213: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0) ..
1214: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1) LOOP
1215:
1216: IF ( ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1217: regime_index).trx_line_index = p_trx_line_index) THEN

Line 1214: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1) LOOP

1210:
1211: ELSE
1212: FOR regime_index IN
1213: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0) ..
1214: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1) LOOP
1215:
1216: IF ( ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1217: regime_index).trx_line_index = p_trx_line_index) THEN
1218:

Line 1216: IF ( ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(

1212: FOR regime_index IN
1213: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0) ..
1214: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1) LOOP
1215:
1216: IF ( ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1217: regime_index).trx_line_index = p_trx_line_index) THEN
1218:
1219: -- tax_regime_id is detail_tax_regime_tbl(regime_index).tax_regime_id.
1220: -- Get the tax_provider_id:

Line 1222: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(

1218:
1219: -- tax_regime_id is detail_tax_regime_tbl(regime_index).tax_regime_id.
1220: -- Get the tax_provider_id:
1221: --
1222: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1223: regime_index).tax_regime_id;
1224: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1225: l_tax_regime_id).tax_provider_id;
1226:

Line 1224: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(

1220: -- Get the tax_provider_id:
1221: --
1222: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1223: regime_index).tax_regime_id;
1224: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1225: l_tax_regime_id).tax_provider_id;
1226:
1227: IF (l_provider_id IS NULL) THEN
1228:

Line 1233: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(

1229: -- If l_provider_id is null, this tax needs to be processed
1230: --
1231: ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes (
1232: l_tax_regime_id,
1233: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1234: l_tax_regime_id).tax_regime_code,
1235: p_trx_line_index,
1236: p_event_class_rec,
1237: l_tax_date,

Line 1267: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index) > 0

1263: END IF; -- line_level_action <> 'LINE_INFO_TAX_ONLY'
1264: END IF; -- applied_from(adjusted_doc)_appl_id IS NOT NULL,OR ELSE
1265:
1266: IF p_event_class_rec.enforce_tax_from_acct_flag = 'Y' AND
1267: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index) > 0
1268: THEN
1269:
1270: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(
1271: p_event_class_rec,

Line 1303: IF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(

1299: IF l_begin_index IS NOT NULL AND l_end_index IS NOT NULL THEN
1300:
1301: -- For migrated transactions, skip tax status and rate determination
1302: --
1303: IF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(
1304: p_trx_line_index), 'N') <> 'Y' THEN
1305:
1306: -- get tax status
1307: --

Line 1462: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1458:
1459: FND_LOG.STRING(g_level_statement,
1460: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax.END',
1461: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)'||'Tax Event Type Code: '||
1462: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1463: p_trx_line_index));
1464: END IF;
1465: RETURN;
1466: END IF; -- tax_event_type_code 'CREATE','UPDATE','OVERRIDE_TAX'

Line 1478: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(

1474: --
1475:
1476: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_hdr_tx_amt_flg := 'Y'; -- bug 5417887
1477:
1478: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(
1479: p_trx_line_index) = 'N' THEN
1480: FOR tax_line_index IN nvl(l_begin_index,0) .. nvl(l_end_index,-99) LOOP
1481: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1482: tax_line_index).self_assessed_flag := 'Y';

Line 1492: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_trx_line_index) IS NOT NULL AND

1488: -- Start : If Statement added for Bug#8540809
1489: -- If Ctrl_Total_Hdr_Tx_Amt is Not Null and Ctrl_Hdr_Tx_Appl_flag = Y then
1490: -- set the global variable g_ctrl_total_hdr_tx_amt_flg = Y
1491:
1492: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_trx_line_index) IS NOT NULL AND
1493: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(p_trx_line_index) = 'Y'
1494: THEN
1495: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_hdr_tx_amt_flg := 'Y';
1496: END IF;

Line 1493: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(p_trx_line_index) = 'Y'

1489: -- If Ctrl_Total_Hdr_Tx_Amt is Not Null and Ctrl_Hdr_Tx_Appl_flag = Y then
1490: -- set the global variable g_ctrl_total_hdr_tx_amt_flg = Y
1491:
1492: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_trx_line_index) IS NOT NULL AND
1493: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(p_trx_line_index) = 'Y'
1494: THEN
1495: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_hdr_tx_amt_flg := 'Y';
1496: END IF;
1497: -- End : If Statement added for Bug#8540809

Line 1502: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt (

1498:
1499: -- If ctrl_total_line_tx_amt is not null, process taxes for line level
1500: -- xml invoice
1501: --
1502: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt (
1503: p_trx_line_index) IS NOT NULL
1504: THEN
1505: l_tax_exists_flg := 'N';
1506: FOR i IN NVL(l_begin_index, 0) .. NVL(l_end_index, -1) LOOP

Line 1528: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(

1524: p_event_class_rec.ctrl_total_line_tx_amt_flg := 'Y';
1525: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_line_tx_amt_flg := 'Y'; -- bug 5417887
1526:
1527: ELSE
1528: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(
1529: p_trx_line_index) <> 0
1530: THEN
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: IF (g_level_error >= g_current_runtime_level ) THEN

Line 1547: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);

1543: FND_MESSAGE.SET_NAME('ZX','ZX_LN_CTRL_TOTAL_TAX_NOT_EXIST');
1544:
1545: -- FND_MSG_PUB.Add;
1546: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1547: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1548: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1549: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1550:
1551: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1549: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);

1545: -- FND_MSG_PUB.Add;
1546: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1547: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1548: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1549: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1550:
1551: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1552:
1553: RETURN;

Line 1625: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1621: 'ZX_TDS_CALC_SERVICES_PUB_PKG.overide_detail_tax_lines(+)');
1622: END IF;
1623: x_return_status := FND_API.G_RET_STS_SUCCESS;
1624:
1625: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1626: p_trx_line_index) = 'OVERRIDE_TAX') THEN
1627:
1628: calculate_tax( p_trx_line_index,
1629: p_event_class_rec,

Line 1653: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1649: IF (g_level_statement >= g_current_runtime_level ) THEN
1650: FND_LOG.STRING(g_level_statement,
1651: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.override_detail_tax_lines',
1652: 'Tax Event Type Code: '||
1653: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1654: p_trx_line_index) ||' is not correct.');
1655: END IF;
1656: END IF;
1657:

Line 1699: IF ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1695: 'ZX_TDS_CALC_SERVICES_PUB_PKG.override_summary_tax_lines(+)');
1696: END IF;
1697: x_return_status := FND_API.G_RET_STS_SUCCESS;
1698:
1699: IF ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1700: p_trx_line_index) = 'OVERRIDE_TAX') THEN
1701:
1702: calculate_tax( p_trx_line_index,
1703: p_event_class_rec,

Line 1727: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1723: IF (g_level_statement >= g_current_runtime_level ) THEN
1724: FND_LOG.STRING(g_level_statement,
1725: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.override_summary_tax_lines',
1726: 'Tax Event Type Code: '||
1727: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1728: p_trx_line_index) ||' is not correct.');
1729: END IF;
1730: END IF;
1731: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2101: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

2097:
2098: -- Bug 3971016: Skip processing tax lines for line_level_action
2099: -- 'RECORD_WITH_NO_TAX'
2100: --
2101: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2102: p_trx_line_index) = 'RECORD_WITH_NO_TAX'
2103: THEN
2104: IF (g_level_statement >= g_current_runtime_level ) THEN
2105: FND_LOG.STRING(g_level_statement,

Line 2112: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

2108: END IF;
2109: RETURN;
2110: END IF;
2111:
2112: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2113: p_trx_line_index) = 'CREATE') THEN
2114: -- get tax dates
2115: --
2116: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date( p_trx_line_index,

Line 2138: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(

2134: END IF;
2135: RETURN;
2136: END IF;
2137:
2138: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
2139: p_trx_line_index) IS NOT NULL
2140: THEN
2141: g_reference_doc_exist_flg := 'Y';
2142: END IF;

Line 2176: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

2172: IF (g_level_error >= g_current_runtime_level ) THEN
2173: FND_LOG.STRING(g_level_error,
2174: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax_for_import.END',
2175: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax_for_import(-)'||' tax event type'||
2176: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2177: p_trx_line_index));
2178: END IF;
2179: RETURN;
2180: END IF; -- tax_event_type_code

Line 2350: begin_index := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST;

2346: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.validate_document_for_tax.BEGIN',
2347: 'ZX_TDS_CALC_SERVICES_PUB_PKG.validate_document_for_tax(+)');
2348: END IF;
2349:
2350: begin_index := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST;
2351:
2352: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2353: begin_index) = 'VALIDATE') THEN
2354: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2352: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

2348: END IF;
2349:
2350: begin_index := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST;
2351:
2352: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2353: begin_index) = 'VALIDATE') THEN
2354: x_return_status := FND_API.G_RET_STS_SUCCESS;
2355: ELSE
2356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

Line 2361: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

2357: IF (g_level_statement >= g_current_runtime_level ) THEN
2358: FND_LOG.STRING(g_level_statement,
2359: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.validate_document_for_tax',
2360: 'Tax Event Type Code: '||
2361: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2362: begin_index) ||' is not correct.');
2363: END IF;
2364: END IF;
2365:

Line 2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)

2757: CURSOR fetch_detail_tax_lines(p_line_index NUMBER) IS
2758: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */ *
2759: FROM zx_detail_tax_lines_gt
2760: WHERE trx_id =
2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2762: AND application_id =
2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)
2764: AND entity_code =
2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)

Line 2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)

2759: FROM zx_detail_tax_lines_gt
2760: WHERE trx_id =
2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2762: AND application_id =
2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)
2764: AND entity_code =
2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)
2766: AND event_class_code =
2767: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_line_index);

Line 2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)

2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2762: AND application_id =
2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)
2764: AND entity_code =
2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)
2766: AND event_class_code =
2767: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_line_index);
2768:
2769: l_last_row NUMBER;

Line 2767: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_line_index);

2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)
2764: AND entity_code =
2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)
2766: AND event_class_code =
2767: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_line_index);
2768:
2769: l_last_row NUMBER;
2770:
2771: BEGIN

Line 2785: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST) LOOP

2781: -- Initialize p_det_tax_line_tbl
2782: g_detail_tax_lines_tbl.delete;
2783:
2784: FOR detail_tax_lines_rec IN fetch_detail_tax_lines(
2785: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST) LOOP
2786: g_detail_tax_lines_tbl(l_last_row) := detail_tax_lines_rec;
2787: l_last_row := l_last_row + 1;
2788: END LOOP;
2789:

Line 3899: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';

3895:
3896: --Bug 8736358
3897: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_update_exist_flg := 'N';
3898:
3899: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';
3900: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';
3901: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';
3902: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;
3903: ZX_GLOBAL_STRUCTURES_PKG.lte_trx_tbl.DELETE;

Line 3900: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';

3896: --Bug 8736358
3897: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_update_exist_flg := 'N';
3898:
3899: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';
3900: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';
3901: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';
3902: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;
3903: ZX_GLOBAL_STRUCTURES_PKG.lte_trx_tbl.DELETE;
3904:

Line 3901: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';

3897: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ln_action_update_exist_flg := 'N';
3898:
3899: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';
3900: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';
3901: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';
3902: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;
3903: ZX_GLOBAL_STRUCTURES_PKG.lte_trx_tbl.DELETE;
3904:
3905:

Line 3902: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;

3898:
3899: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';
3900: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';
3901: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';
3902: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;
3903: ZX_GLOBAL_STRUCTURES_PKG.lte_trx_tbl.DELETE;
3904:
3905:
3906: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.DELETE;

Line 3903: ZX_GLOBAL_STRUCTURES_PKG.lte_trx_tbl.DELETE;

3899: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';
3900: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';
3901: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';
3902: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;
3903: ZX_GLOBAL_STRUCTURES_PKG.lte_trx_tbl.DELETE;
3904:
3905:
3906: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.DELETE;
3907: ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl.DELETE;

Line 3937: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.DELETE;

3933: ZX_TDS_RULE_BASE_DETM_PVT.g_segment_array.DELETE;
3934: ZX_TPI_SERVICES_PKG.tax_regime_tmp_tbl.DELETE;
3935:
3936: --bug8251315
3937: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.DELETE;
3938: --bug#8551677
3939: --bug#9469868
3940: --ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl.DELETE;
3941: --bug#7519329

Line 3940: --ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl.DELETE;

3936: --bug8251315
3937: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.DELETE;
3938: --bug#8551677
3939: --bug#9469868
3940: --ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl.DELETE;
3941: --bug#7519329
3942: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL.DELETE;
3943:
3944: ZX_TDS_TAX_ROUNDING_PKG.g_euro_code := NULL;

Line 3942: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL.DELETE;

3938: --bug#8551677
3939: --bug#9469868
3940: --ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl.DELETE;
3941: --bug#7519329
3942: ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL.DELETE;
3943:
3944: ZX_TDS_TAX_ROUNDING_PKG.g_euro_code := NULL;
3945: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number := NULL;
3946: ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_lines_counter := NULL;

Line 4018: ZX_GLOBAL_STRUCTURES_PKG.ptnr_exemption_tbl.DELETE;

4014: ZX_TDS_RULE_BASE_DETM_PVT.g_value_high_tbl.DELETE;
4015: ZX_TDS_RULE_BASE_DETM_PVT.g_segment_array.DELETE;
4016:
4017: --bug 7444373
4018: ZX_GLOBAL_STRUCTURES_PKG.ptnr_exemption_tbl.DELETE;
4019:
4020: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number := NULL;
4021: ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_lines_counter := NULL;
4022: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level := NULL;