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 276: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

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

Line 295: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

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

Line 297: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

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

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

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

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

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

Line 317: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

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

Line 319: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 372: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

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

Line 377: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

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

Line 382: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

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

Line 387: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

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

Line 411: IF( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

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

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

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

Line 451: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(

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

Line 453: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

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

Line 459: IF( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

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

Line 461: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

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

Line 463: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

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

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

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

Line 489: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 600: ELSIF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

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

Line 639: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

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

Line 642: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(

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

Line 645: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(

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

Line 648: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(

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

Line 651: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(

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

Line 654: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(

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

Line 715: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(

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

Line 756: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(

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

Line 759: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(

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

Line 762: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(

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

Line 765: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(

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

Line 768: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(

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

Line 771: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(

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

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

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

Line 841: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

837:
838: IF ((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
839: p_trx_line_index) = 'UPDATE')
840: OR
841: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
842: p_trx_line_index) ='UPDATE' AND
843: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
844: p_trx_line_index) = 'LINE_INFO_TAX_ONLY')) THEN -- Bug 5291394
845:

Line 843: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

839: p_trx_line_index) = 'UPDATE')
840: OR
841: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
842: p_trx_line_index) ='UPDATE' AND
843: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
844: p_trx_line_index) = 'LINE_INFO_TAX_ONLY')) THEN -- Bug 5291394
845:
846: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(
847: p_event_class_rec,

Line 882: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(

878:
879: IF (l_begin_index IS NULL) OR (l_begin_index = l_end_index) THEN
880:
881: l_upg_trx_info_rec.application_id
882: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(
883: p_trx_line_index);
884: l_upg_trx_info_rec.event_class_code
885: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(
886: p_trx_line_index);

Line 885: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(

881: l_upg_trx_info_rec.application_id
882: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(
883: p_trx_line_index);
884: l_upg_trx_info_rec.event_class_code
885: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(
886: p_trx_line_index);
887: l_upg_trx_info_rec.entity_code
888: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(
889: p_trx_line_index);

Line 888: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(

884: l_upg_trx_info_rec.event_class_code
885: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(
886: p_trx_line_index);
887: l_upg_trx_info_rec.entity_code
888: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(
889: p_trx_line_index);
890: l_upg_trx_info_rec.trx_id
891: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(
892: p_trx_line_index);

Line 891: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(

887: l_upg_trx_info_rec.entity_code
888: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(
889: p_trx_line_index);
890: l_upg_trx_info_rec.trx_id
891: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(
892: p_trx_line_index);
893: l_upg_trx_info_rec.trx_line_id
894: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(
895: p_trx_line_index);

Line 894: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(

890: l_upg_trx_info_rec.trx_id
891: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(
892: p_trx_line_index);
893: l_upg_trx_info_rec.trx_line_id
894: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(
895: p_trx_line_index);
896: l_upg_trx_info_rec.trx_level_type
897: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(
898: p_trx_line_index);

Line 897: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(

893: l_upg_trx_info_rec.trx_line_id
894: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(
895: p_trx_line_index);
896: l_upg_trx_info_rec.trx_level_type
897: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(
898: p_trx_line_index);
899:
900: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(
901: p_upg_trx_info_rec => l_upg_trx_info_rec,

Line 959: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

955: END IF;
956: END IF;
957: END IF; -- -- line_level_action = 'UPDATE'
958:
959: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
960: p_trx_line_index) IN ('CREATE', 'UPDATE')
961: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
962: p_trx_line_index) = 'INTERCOMPANY_TRX'
963: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(

Line 961: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(

957: END IF; -- -- line_level_action = 'UPDATE'
958:
959: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
960: p_trx_line_index) IN ('CREATE', 'UPDATE')
961: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
962: p_trx_line_index) = 'INTERCOMPANY_TRX'
963: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
964: p_trx_line_index) IS NOT NULL
965: THEN

Line 963: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(

959: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
960: p_trx_line_index) IN ('CREATE', 'UPDATE')
961: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
962: p_trx_line_index) = 'INTERCOMPANY_TRX'
963: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
964: p_trx_line_index) IS NOT NULL
965: THEN
966:
967: ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(

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

999:
1000: IF ((l_begin_index IS NULL) OR (l_begin_index = l_end_index) ) THEN
1001:
1002: OPEN get_source_doc_info (
1003: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index),
1004: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index),
1005: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
1006: );
1007:

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

1000: IF ((l_begin_index IS NULL) OR (l_begin_index = l_end_index) ) THEN
1001:
1002: OPEN get_source_doc_info (
1003: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index),
1004: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index),
1005: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
1006: );
1007:
1008: FETCH get_source_doc_info into

Line 1005: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)

1001:
1002: OPEN get_source_doc_info (
1003: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index),
1004: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index),
1005: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
1006: );
1007:
1008: FETCH get_source_doc_info into
1009: l_upg_trx_info_rec.application_id,

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

1019: 'No record found in zx_evnt_mappings.' );
1020: FND_LOG.STRING(g_level_statement,
1021: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1022: 'application_id: '||
1023: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) );
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1026: 'entity_code: '||
1027: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) );

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

1023: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) );
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1026: 'entity_code: '||
1027: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) );
1028: FND_LOG.STRING(g_level_statement,
1029: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1030: 'event_class_code: '||
1031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) );

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

1027: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) );
1028: FND_LOG.STRING(g_level_statement,
1029: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1030: 'event_class_code: '||
1031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) );
1032: FND_LOG.STRING(g_level_statement,
1033: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1034: 'RETURN_STATUS = ' || x_return_status);
1035: FND_LOG.STRING(g_level_statement,

Line 1042: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_CREDIT_MEMO' THEN

1038: END IF;
1039: RETURN;
1040: END IF;
1041:
1042: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_CREDIT_MEMO' THEN
1043: l_upg_trx_info_rec.event_class_code := 'CREDIT_MEMO';
1044: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_DEBIT_MEMO' THEN
1045: l_upg_trx_info_rec.event_class_code := 'DEBIT_MEMO';
1046: END IF;

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

1040: END IF;
1041:
1042: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_CREDIT_MEMO' THEN
1043: l_upg_trx_info_rec.event_class_code := 'CREDIT_MEMO';
1044: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index) = 'AP_DEBIT_MEMO' THEN
1045: l_upg_trx_info_rec.event_class_code := 'DEBIT_MEMO';
1046: END IF;
1047:
1048: l_upg_trx_info_rec.trx_id

Line 1049: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(

1045: l_upg_trx_info_rec.event_class_code := 'DEBIT_MEMO';
1046: END IF;
1047:
1048: l_upg_trx_info_rec.trx_id
1049: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
1050: p_trx_line_index);
1051: l_upg_trx_info_rec.trx_line_id
1052: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(
1053: p_trx_line_index);

Line 1052: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(

1048: l_upg_trx_info_rec.trx_id
1049: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
1050: p_trx_line_index);
1051: l_upg_trx_info_rec.trx_line_id
1052: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(
1053: p_trx_line_index);
1054: l_upg_trx_info_rec.trx_level_type
1055: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(
1056: p_trx_line_index);

Line 1055: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(

1051: l_upg_trx_info_rec.trx_line_id
1052: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(
1053: p_trx_line_index);
1054: l_upg_trx_info_rec.trx_level_type
1055: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(
1056: p_trx_line_index);
1057:
1058: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(
1059: p_upg_trx_info_rec => l_upg_trx_info_rec,

Line 1120: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (

1116:
1117: -- Bug 3648628: if line_level_action = 'LINE_INFO_TAX_ONLY', skip the
1118: -- process to create any detail tax line for this trx line (memo line).
1119: --
1120: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (
1121: p_trx_line_index ) <> 'LINE_INFO_TAX_ONLY' AND
1122: p_event_class_rec.process_for_applicability_flag = 'Y' AND
1123: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg, 'Y') = 'Y' AND
1124: -- Bug 4765758: for TM, check source_process_for_appl_flag to determine

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

1166:
1167:
1168: ELSE
1169: FOR regime_index IN
1170: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0) ..
1171: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1) LOOP
1172:
1173: IF ( ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1174: regime_index).trx_line_index = p_trx_line_index) THEN

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

1167:
1168: ELSE
1169: FOR regime_index IN
1170: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0) ..
1171: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1) LOOP
1172:
1173: IF ( ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1174: regime_index).trx_line_index = p_trx_line_index) THEN
1175:

Line 1173: IF ( ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(

1169: FOR regime_index IN
1170: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0) ..
1171: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1) LOOP
1172:
1173: IF ( ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1174: regime_index).trx_line_index = p_trx_line_index) THEN
1175:
1176: -- tax_regime_id is detail_tax_regime_tbl(regime_index).tax_regime_id.
1177: -- Get the tax_provider_id:

Line 1179: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(

1175:
1176: -- tax_regime_id is detail_tax_regime_tbl(regime_index).tax_regime_id.
1177: -- Get the tax_provider_id:
1178: --
1179: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1180: regime_index).tax_regime_id;
1181: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1182: l_tax_regime_id).tax_provider_id;
1183:

Line 1181: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(

1177: -- Get the tax_provider_id:
1178: --
1179: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1180: regime_index).tax_regime_id;
1181: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1182: l_tax_regime_id).tax_provider_id;
1183:
1184: IF (l_provider_id IS NULL) THEN
1185:

Line 1190: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(

1186: -- If l_provider_id is null, this tax needs to be processed
1187: --
1188: ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes (
1189: l_tax_regime_id,
1190: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1191: l_tax_regime_id).tax_regime_code,
1192: p_trx_line_index,
1193: p_event_class_rec,
1194: l_tax_date,

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

1220: END IF; -- line_level_action <> 'LINE_INFO_TAX_ONLY'
1221: END IF; -- applied_from(adjusted_doc)_appl_id IS NOT NULL,OR ELSE
1222:
1223: IF p_event_class_rec.enforce_tax_from_acct_flag = 'Y' AND
1224: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index) > 0
1225: THEN
1226:
1227: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(
1228: p_event_class_rec,

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

1256: IF l_begin_index IS NOT NULL AND l_end_index IS NOT NULL THEN
1257:
1258: -- For migrated transactions, skip tax status and rate determination
1259: --
1260: IF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(
1261: p_trx_line_index), 'N') <> 'Y' THEN
1262:
1263: -- get tax status
1264: --

Line 1419: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1415:
1416: FND_LOG.STRING(g_level_statement,
1417: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax.END',
1418: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)'||'Tax Event Type Code: '||
1419: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1420: p_trx_line_index));
1421: END IF;
1422: RETURN;
1423: END IF; -- tax_event_type_code 'CREATE','UPDATE','OVERRIDE_TAX'

Line 1435: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(

1431: --
1432:
1433: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_hdr_tx_amt_flg := 'Y'; -- bug 5417887
1434:
1435: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(
1436: p_trx_line_index) = 'N' THEN
1437: FOR tax_line_index IN nvl(l_begin_index,0) .. nvl(l_end_index,-99) LOOP
1438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1439: tax_line_index).self_assessed_flag := 'Y';

Line 1448: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt (

1444:
1445: -- If ctrl_total_line_tx_amt is not null, process taxes for line level
1446: -- xml invoice
1447: --
1448: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt (
1449: p_trx_line_index) IS NOT NULL
1450: THEN
1451: l_tax_exists_flg := 'N';
1452: FOR i IN NVL(l_begin_index, 0) .. NVL(l_end_index, -1) LOOP

Line 1474: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(

1470: p_event_class_rec.ctrl_total_line_tx_amt_flg := 'Y';
1471: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_line_tx_amt_flg := 'Y'; -- bug 5417887
1472:
1473: ELSE
1474: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(
1475: p_trx_line_index) <> 0
1476: THEN
1477: x_return_status := FND_API.G_RET_STS_ERROR;
1478: IF (g_level_error >= g_current_runtime_level ) THEN

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

1489: FND_MESSAGE.SET_NAME('ZX','ZX_LN_CTRL_TOTAL_TAX_NOT_EXIST');
1490:
1491: -- FND_MSG_PUB.Add;
1492: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1493: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1494: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1495: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1496:
1497: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

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

1491: -- FND_MSG_PUB.Add;
1492: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1493: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1494: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1495: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1496:
1497: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1498:
1499: RETURN;

Line 1571: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1567: 'ZX_TDS_CALC_SERVICES_PUB_PKG.overide_detail_tax_lines(+)');
1568: END IF;
1569: x_return_status := FND_API.G_RET_STS_SUCCESS;
1570:
1571: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1572: p_trx_line_index) = 'OVERRIDE_TAX') THEN
1573:
1574: calculate_tax( p_trx_line_index,
1575: p_event_class_rec,

Line 1599: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1595: IF (g_level_statement >= g_current_runtime_level ) THEN
1596: FND_LOG.STRING(g_level_statement,
1597: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.override_detail_tax_lines',
1598: 'Tax Event Type Code: '||
1599: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1600: p_trx_line_index) ||' is not correct.');
1601: END IF;
1602: END IF;
1603:

Line 1645: IF ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1641: 'ZX_TDS_CALC_SERVICES_PUB_PKG.override_summary_tax_lines(+)');
1642: END IF;
1643: x_return_status := FND_API.G_RET_STS_SUCCESS;
1644:
1645: IF ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1646: p_trx_line_index) = 'OVERRIDE_TAX') THEN
1647:
1648: calculate_tax( p_trx_line_index,
1649: p_event_class_rec,

Line 1673: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

1669: IF (g_level_statement >= g_current_runtime_level ) THEN
1670: FND_LOG.STRING(g_level_statement,
1671: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.override_summary_tax_lines',
1672: 'Tax Event Type Code: '||
1673: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1674: p_trx_line_index) ||' is not correct.');
1675: END IF;
1676: END IF;
1677: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2047: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

2043:
2044: -- Bug 3971016: Skip processing tax lines for line_level_action
2045: -- 'RECORD_WITH_NO_TAX'
2046: --
2047: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2048: p_trx_line_index) = 'RECORD_WITH_NO_TAX'
2049: THEN
2050: IF (g_level_statement >= g_current_runtime_level ) THEN
2051: FND_LOG.STRING(g_level_statement,

Line 2058: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

2054: END IF;
2055: RETURN;
2056: END IF;
2057:
2058: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2059: p_trx_line_index) = 'CREATE') THEN
2060: -- get tax dates
2061: --
2062: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date( p_trx_line_index,

Line 2084: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(

2080: END IF;
2081: RETURN;
2082: END IF;
2083:
2084: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
2085: p_trx_line_index) IS NOT NULL
2086: THEN
2087: g_reference_doc_exist_flg := 'Y';
2088: END IF;

Line 2122: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

2118: IF (g_level_error >= g_current_runtime_level ) THEN
2119: FND_LOG.STRING(g_level_error,
2120: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax_for_import.END',
2121: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax_for_import(-)'||' tax event type'||
2122: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2123: p_trx_line_index));
2124: END IF;
2125: RETURN;
2126: END IF; -- tax_event_type_code

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

2292: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.validate_document_for_tax.BEGIN',
2293: 'ZX_TDS_CALC_SERVICES_PUB_PKG.validate_document_for_tax(+)');
2294: END IF;
2295:
2296: begin_index := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST;
2297:
2298: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2299: begin_index) = 'VALIDATE') THEN
2300: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2298: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

2294: END IF;
2295:
2296: begin_index := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST;
2297:
2298: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2299: begin_index) = 'VALIDATE') THEN
2300: x_return_status := FND_API.G_RET_STS_SUCCESS;
2301: ELSE
2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

Line 2307: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(

2303: IF (g_level_statement >= g_current_runtime_level ) THEN
2304: FND_LOG.STRING(g_level_statement,
2305: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.validate_document_for_tax',
2306: 'Tax Event Type Code: '||
2307: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2308: begin_index) ||' is not correct.');
2309: END IF;
2310: END IF;
2311:

Line 2699: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)

2695: CURSOR fetch_detail_tax_lines(p_line_index NUMBER) IS
2696: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */ *
2697: FROM zx_detail_tax_lines_gt
2698: WHERE trx_id =
2699: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2700: AND application_id =
2701: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)
2702: AND entity_code =
2703: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)

Line 2701: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)

2697: FROM zx_detail_tax_lines_gt
2698: WHERE trx_id =
2699: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2700: AND application_id =
2701: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)
2702: AND entity_code =
2703: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)
2704: AND event_class_code =
2705: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_line_index);

Line 2703: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)

2699: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2700: AND application_id =
2701: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)
2702: AND entity_code =
2703: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)
2704: AND event_class_code =
2705: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_line_index);
2706:
2707: l_last_row NUMBER;

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

2701: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)
2702: AND entity_code =
2703: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_line_index)
2704: AND event_class_code =
2705: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_line_index);
2706:
2707: l_last_row NUMBER;
2708:
2709: BEGIN

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

2719: -- Initialize p_det_tax_line_tbl
2720: g_detail_tax_lines_tbl.delete;
2721:
2722: FOR detail_tax_lines_rec IN fetch_detail_tax_lines(
2723: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id.FIRST) LOOP
2724: g_detail_tax_lines_tbl(l_last_row) := detail_tax_lines_rec;
2725: l_last_row := l_last_row + 1;
2726: END LOOP;
2727:

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

3615: ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_copy_and_create_flg := 'N';
3616: ZX_TDS_CALC_SERVICES_PUB_PKG.g_reference_doc_exist_flg := 'N';
3617: --bug 7537542
3618:
3619: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';
3620: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';
3621: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';
3622: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;
3623:

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

3616: ZX_TDS_CALC_SERVICES_PUB_PKG.g_reference_doc_exist_flg := 'N';
3617: --bug 7537542
3618:
3619: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';
3620: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';
3621: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';
3622: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;
3623:
3624:

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

3617: --bug 7537542
3618:
3619: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';
3620: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';
3621: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';
3622: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;
3623:
3624:
3625: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.DELETE;

Line 3622: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;

3618:
3619: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'N';
3620: ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag := 'N';
3621: ZX_GLOBAL_STRUCTURES_PKG.g_bulk_process_flag := 'N';
3622: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl.DELETE;
3623:
3624:
3625: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.DELETE;
3626: ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl.DELETE;

Line 3728: ZX_GLOBAL_STRUCTURES_PKG.ptnr_exemption_tbl.DELETE;

3724: ZX_TDS_RULE_BASE_DETM_PVT.g_value_high_tbl.DELETE;
3725: ZX_TDS_RULE_BASE_DETM_PVT.g_segment_array.DELETE;
3726:
3727: --bug 7444373
3728: ZX_GLOBAL_STRUCTURES_PKG.ptnr_exemption_tbl.DELETE;
3729:
3730: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number := NULL;
3731: ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_lines_counter := NULL;
3732: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level := NULL;