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_IMPORT_DOCUMENT_PKG dependencies on ZX_TDS_CALC_SERVICES_PUB_PKG

Line 331: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST,0);

327:
328: -- initialize local variables
329: --
330: l_new_row_num :=
331: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST,0);
332:
333: l_previous_sum_tax_line_number := NUMBER_DUMMY;
334:
335: --

Line 388: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN

384: --
385: IF tax_line_rec.summary_tax_line_number <> l_previous_sum_tax_line_number
386: THEN
387:
388: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN
389:
390: IF l_previous_sum_tax_line_number <> NUMBER_DUMMY THEN
391:
392: -- calculate rounding difference and adjust rounding difference

Line 398: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

394: --
395: l_rounding_diff := l_previous_summary_tax_amt - l_total_rnd_tax_amt;
396:
397: IF l_rounding_diff <> 0 THEN
398: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
399: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
400: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
401: l_max_line_amt_tax_index).tax_amt;
402: END IF;

Line 400: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

396:
397: IF l_rounding_diff <> 0 THEN
398: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
399: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
400: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
401: l_max_line_amt_tax_index).tax_amt;
402: END IF;
403: END IF; -- l_previous_sum_tax_line_number <> NUMBER_DUMMY
404:

Line 435: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

431: -- simply copy tax amount from summary tax line to detail tax line.
432: --
433: IF tax_line_rec.line_level_action = 'LINE_INFO_TAX_ONLY' THEN
434:
435: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
436: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
437: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
438: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
439: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 437: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

433: IF tax_line_rec.line_level_action = 'LINE_INFO_TAX_ONLY' THEN
434:
435: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
436: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
437: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
438: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
439: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
440: l_new_row_num).tax_only_line_flag := 'Y';
441:

Line 439: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

435: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
436: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
437: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
438: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
439: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
440: l_new_row_num).tax_only_line_flag := 'Y';
441:
442: -- set total rounded tax amount
443: --

Line 445: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt;

441:
442: -- set total rounded tax amount
443: --
444: l_total_rnd_tax_amt :=
445: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt;
446:
447: ELSE
448:
449: -- prorate tax_amt with line_amt

Line 453: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

449: -- prorate tax_amt with line_amt
450: --
451: IF l_total_alloc_lines_amt <> 0 THEN
452:
453: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
454: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt *
455: tax_line_rec.line_amt/l_total_alloc_lines_amt;
456:
457: ELSE -- l_total_alloc_lines_amt = 0

Line 486: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

482: 'prorate_imported_sum_tax_lines(-)');
483: END IF;
484: RETURN;
485: ELSE
486: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
487: l_new_row_num).unrounded_tax_amt := 0;
488: END IF; -- sum_tax_line_rec.tax_amt <> 0 or ELSE
489: END IF; -- l_total_alloc_lines_amt <> 0 or ELSE
490:

Line 494: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN

490:
491: -- Round tax amt for 'LINE' Level rounding. 'HEADER' level rounding
492: -- will be done in tail end service as regular detail tax lines.
493: --
494: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN
495:
496: -- round tax_amt
497: --
498: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;

Line 498: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;

494: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN
495:
496: -- round tax_amt
497: --
498: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
499:
500: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
501: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
502: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,

Line 500: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=

496: -- round tax_amt
497: --
498: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
499:
500: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
501: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
502: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
503: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
504: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),

Line 502: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,

498: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
499:
500: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
501: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
502: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
503: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
504: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),
505: tax_line_rec.minimum_accountable_unit,
506: tax_line_rec.precision,

Line 503: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,

499:
500: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
501: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
502: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
503: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
504: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),
505: tax_line_rec.minimum_accountable_unit,
506: tax_line_rec.precision,
507: x_return_status,

Line 529: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

525:
526: -- accumulate rounded tax amount
527: --
528: l_total_rnd_tax_amt := l_total_rnd_tax_amt +
529: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
530: l_new_row_num).tax_amt;
531:
532: -- record l_max_line_amt and l_max_line_amt_tax_index
533: --

Line 547: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' AND

543: -- difference('Line' Level) for the last summary tax line
544: --
545: IF l_line_level_action = 'CREATE_WITH_TAX' THEN
546:
547: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' AND
548: l_total_alloc_lines_amt IS NOT NULL
549: THEN
550:
551: -- calculate rounding difference and adjust rounding difference

Line 557: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

553: --
554: l_rounding_diff := l_previous_summary_tax_amt - l_total_rnd_tax_amt;
555:
556: IF l_rounding_diff <> 0 THEN
557: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
558: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
559: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
560: l_max_line_amt_tax_index).tax_amt;
561: END IF;

Line 559: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

555:
556: IF l_rounding_diff <> 0 THEN
557: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
558: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
559: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
560: l_max_line_amt_tax_index).tax_amt;
561: END IF;
562: END IF; -- g_rounding_level = 'Line'
563: END IF; -- line_level_action = 'CREATE_WITH_TAX'

Line 611: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN

607: --
608: IF tax_line_rec.summary_tax_line_number <> l_previous_sum_tax_line_number
609: THEN
610:
611: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN
612:
613: -- New summary tax line number
614: --
615: -- Adjust rounding difference for previous summary tax line for 'Line'

Line 627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

623: --
624: l_rounding_diff := l_previous_summary_tax_amt - l_total_rnd_tax_amt;
625:
626: IF l_rounding_diff <> 0 THEN
627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
628: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
629: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
630: l_max_line_amt_tax_index).tax_amt;
631: END IF;

Line 629: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

625:
626: IF l_rounding_diff <> 0 THEN
627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
628: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
629: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
630: l_max_line_amt_tax_index).tax_amt;
631: END IF;
632: END IF; -- l_previous_sum_tax_line_number <> NUMBER_DUMMY
633:

Line 661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

657:
658: -- prorate tax_amt with line_amt
659: --
660: IF l_total_trx_lines_amt <> 0 THEN
661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
662: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt *
663: tax_line_rec.line_amt/l_total_trx_lines_amt;
664: ELSE -- l_total_trx_lines_amt = 0
665:

Line 693: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

689: 'prorate_imported_sum_tax_lines(-)');
690: END IF;
691: RETURN;
692: ELSE
693: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
694: l_new_row_num).unrounded_tax_amt := 0;
695: END IF; -- sum_tax_line_rec.tax_amt <> 0 or ELSE
696: END IF; -- l_total_alloc_lines_amt <> 0 or ELSE
697:

Line 701: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE'

697:
698: -- Round tax amt for 'LINE' Level rounding. 'HEADER' level rounding
699: -- will be done in tail end service as regular detail tax lines.
700: --
701: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE'
702: THEN
703:
704: -- round tax_amt
705: --

Line 706: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;

702: THEN
703:
704: -- round tax_amt
705: --
706: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
707:
708: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
709: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
710: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,

Line 708: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=

704: -- round tax_amt
705: --
706: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
707:
708: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
709: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
710: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
711: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
712: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),

Line 710: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,

706: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
707:
708: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
709: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
710: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
711: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
712: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),
713: tax_line_rec.minimum_accountable_unit,
714: tax_line_rec.precision,

Line 711: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,

707:
708: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
709: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
710: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
711: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
712: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),
713: tax_line_rec.minimum_accountable_unit,
714: tax_line_rec.precision,
715: x_return_status,

Line 737: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

733:
734: -- accumulate rounded tax amount
735: --
736: l_total_rnd_tax_amt := l_total_rnd_tax_amt +
737: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
738: l_new_row_num).tax_amt;
739:
740: -- record l_max_line_amt and l_max_line_amt_tax_index
741: --

Line 751: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' AND

747: END LOOP; -- tax_line_rec IN get_all_detail_tax_lines_csr
748:
749: -- Adjust rounding difference('Line' Level) for the last summary tax line
750: --
751: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' AND
752: l_total_trx_lines_amt IS NOT NULL
753: THEN
754:
755: -- calculate rounding difference and adjust rounding difference

Line 761: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

757: --
758: l_rounding_diff := l_previous_summary_tax_amt - l_total_rnd_tax_amt;
759:
760: IF l_rounding_diff <> 0 THEN
761: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
762: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
764: l_max_line_amt_tax_index).tax_amt;
765: END IF;

Line 763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

759:
760: IF l_rounding_diff <> 0 THEN
761: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
762: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
764: l_max_line_amt_tax_index).tax_amt;
765: END IF;
766: END IF; -- g_rounding_level = 'Line'
767:

Line 809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

805: END IF;
806:
807: -- Copy tax_amt and unrounded_tax_amt from summary tax line
808: --
809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
810: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
812: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
813:

Line 811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

807: -- Copy tax_amt and unrounded_tax_amt from summary tax line
808: --
809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
810: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
812: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
813:
814: -- Set tax_only_line_flag = 'Y' when line_level_action = 'LINE_INFO_TAX_ONLY'
815: --

Line 817: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

813:
814: -- Set tax_only_line_flag = 'Y' when line_level_action = 'LINE_INFO_TAX_ONLY'
815: --
816: IF tax_line_rec.line_level_action = 'LINE_INFO_TAX_ONLY' THEN
817: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
818: l_new_row_num).tax_only_line_flag := 'Y';
819: END IF;
820: END LOOP; -- tax_line_rec IN get_alloc_detail_tax_lines_csr. Bug4262870 End
821:

Line 825: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;

821:
822: -- set l_end_index
823: --
824: IF l_begin_index IS NOT NULL THEN
825: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
826: END IF;
827:
828: --
829: -- populate Process_For_Recovery_Flag

Line 963: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);

959: -- pull in detail tax lines created from summary tax lines and perform
960: -- tax registration number determination
961: --
962: l_new_row_num :=
963: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
964:
965: FOR imported_tax_line_rec IN get_imported_det_tax_lines_csr LOOP
966:
967: -- create a new tax line in g_detail_tax_lines_tbl

Line 970: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num) :=

966:
967: -- create a new tax line in g_detail_tax_lines_tbl
968: --
969: l_new_row_num := l_new_row_num + 1;
970: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num) :=
971: imported_tax_line_rec;
972: -- set l_begin_index
973: --
974: IF l_begin_index IS NULL THEN

Line 980: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

976: END IF;
977:
978: -- get l_def_reg_type and l_reg_rule_flg from tax chche
979: --
980: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
981: l_new_row_num).tax_id;
982: l_def_reg_type := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
983: l_tax_id).def_registr_party_type_code;
984: l_reg_rule_flg := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

Line 989: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

985: l_tax_id).registration_type_rule_flag;
986:
987: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration(
988: p_event_class_rec,
989: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
990: l_new_row_num).tax_regime_code,
991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
992: l_new_row_num).tax_id,
993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

987: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration(
988: p_event_class_rec,
989: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
990: l_new_row_num).tax_regime_code,
991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
992: l_new_row_num).tax_id,
993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
994: l_new_row_num).tax,
995: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

989: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
990: l_new_row_num).tax_regime_code,
991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
992: l_new_row_num).tax_id,
993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
994: l_new_row_num).tax,
995: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
996: l_new_row_num).tax_determine_date,
997: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 995: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
992: l_new_row_num).tax_id,
993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
994: l_new_row_num).tax,
995: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
996: l_new_row_num).tax_determine_date,
997: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
998: l_new_row_num).tax_jurisdiction_code,
999: l_def_reg_type,

Line 997: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
994: l_new_row_num).tax,
995: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
996: l_new_row_num).tax_determine_date,
997: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
998: l_new_row_num).tax_jurisdiction_code,
999: l_def_reg_type,
1000: l_reg_rule_flg,
1001: p_trx_line_index,

Line 1002: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

998: l_new_row_num).tax_jurisdiction_code,
999: l_def_reg_type,
1000: l_reg_rule_flg,
1001: p_trx_line_index,
1002: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1003: l_new_row_num).tax_registration_number,
1004: l_tax_amt_included_flag,
1005: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1006: l_new_row_num).self_assessed_flag,

Line 1005: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1001: p_trx_line_index,
1002: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1003: l_new_row_num).tax_registration_number,
1004: l_tax_amt_included_flag,
1005: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1006: l_new_row_num).self_assessed_flag,
1007: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1008: l_new_row_num).tax_reg_num_det_result_id,
1009: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1007: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1003: l_new_row_num).tax_registration_number,
1004: l_tax_amt_included_flag,
1005: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1006: l_new_row_num).self_assessed_flag,
1007: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1008: l_new_row_num).tax_reg_num_det_result_id,
1009: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1010: l_new_row_num).rounding_rule_code,
1011: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1009: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1005: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1006: l_new_row_num).self_assessed_flag,
1007: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1008: l_new_row_num).tax_reg_num_det_result_id,
1009: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1010: l_new_row_num).rounding_rule_code,
1011: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1012: l_new_row_num).registration_party_type,
1013: x_return_status);

Line 1011: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1007: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1008: l_new_row_num).tax_reg_num_det_result_id,
1009: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1010: l_new_row_num).rounding_rule_code,
1011: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1012: l_new_row_num).registration_party_type,
1013: x_return_status);
1014:
1015: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1060: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1056: -- If tax_amt_included_flag from summary tax line is null, get
1057: -- l_tax_amt_included_flag with tax registration and populate it onto
1058: -- detail tax line
1059: --
1060: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1061: l_new_row_num).tax_amt_included_flag IS NULL THEN
1062: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1063: l_new_row_num).tax_amt_included_flag := l_tax_amt_included_flag;
1064:

Line 1062: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1058: -- detail tax line
1059: --
1060: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1061: l_new_row_num).tax_amt_included_flag IS NULL THEN
1062: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1063: l_new_row_num).tax_amt_included_flag := l_tax_amt_included_flag;
1064:
1065: END IF;
1066:

Line 1069: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1065: END IF;
1066:
1067: -- calculate taxable basis for imported tax lines
1068: --
1069: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1070: l_new_row_num).tax_rate;
1071: IF l_tax_rate <> 0 THEN
1072:
1073: -- Bug 3518261: Calculate taxable_amt for imported tax lines

Line 1076: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1072:
1073: -- Bug 3518261: Calculate taxable_amt for imported tax lines
1074: --
1075:
1076: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1077: l_new_row_num).unrounded_taxable_amt:=
1078: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1079: l_new_row_num).unrounded_tax_amt/l_tax_rate*100;
1080:

Line 1078: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1074: --
1075:
1076: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1077: l_new_row_num).unrounded_taxable_amt:=
1078: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1079: l_new_row_num).unrounded_tax_amt/l_tax_rate*100;
1080:
1081: ELSE -- l_tax_rate = 0
1082:

Line 1083: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1079: l_new_row_num).unrounded_tax_amt/l_tax_rate*100;
1080:
1081: ELSE -- l_tax_rate = 0
1082:
1083: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1084: l_new_row_num).unrounded_tax_amt = 0 THEN
1085: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1086: l_new_row_num).unrounded_taxable_amt :=
1087: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);

Line 1085: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1081: ELSE -- l_tax_rate = 0
1082:
1083: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1084: l_new_row_num).unrounded_tax_amt = 0 THEN
1085: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1086: l_new_row_num).unrounded_taxable_amt :=
1087: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
1088:
1089: ELSE

Line 1107: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

1103:
1104: FND_MESSAGE.SET_NAME('ZX','ZX_IMP_TAX_RATE_AMT_MISMATCH');
1105:
1106: -- FND_MSG_PUB.Add;
1107: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1108: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1109: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1111:

Line 1109: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

1105:
1106: -- FND_MSG_PUB.Add;
1107: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1108: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1109: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1111:
1112: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1113:

Line 1112: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

1108: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1109: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1111:
1112: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1113:
1114: RETURN;
1115: END IF;
1116: END IF; -- l_tax_rate <> 0 OR ELSE

Line 1124: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;

1120: -- set l_end_index
1121: --
1122: IF l_begin_index IS NOT NULL THEN
1123:
1124: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
1125:
1126: -- delete the pulled-in tax lines from zx_detail_tax_lines_gt
1127: --
1128: DELETE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */

Line 1180: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN

1176:
1177: -- bug 6634198: set orig_tax_amt
1178: --
1179: FOR i IN NVL(l_begin_index, 0) .. NVL(l_end_index, -1) LOOP
1180: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN
1181:
1182: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1183: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1184:

Line 1182: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=

1178: --
1179: FOR i IN NVL(l_begin_index, 0) .. NVL(l_end_index, -1) LOOP
1180: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN
1181:
1182: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1183: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1184:
1185: ELSE
1186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=

Line 1183: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);

1179: FOR i IN NVL(l_begin_index, 0) .. NVL(l_end_index, -1) LOOP
1180: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN
1181:
1182: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1183: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1184:
1185: ELSE
1186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1187: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/100;

Line 1186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=

1182: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1183: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1184:
1185: ELSE
1186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1187: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/100;
1188: END IF;
1189: END LOOP;
1190: END IF;

Line 1187: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/100;

1183: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1184:
1185: ELSE
1186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1187: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/100;
1188: END IF;
1189: END LOOP;
1190: END IF;
1191:

Line 1195: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0) + 1;

1191:
1192: -- set l_begin_index_additional
1193: --
1194: l_begin_index_additional :=
1195: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0) + 1;
1196:
1197: /* Bug 5688340: Rearranged the order of conditions in IF statement (ie. pulled
1198: adjusted_doc is NOT NULL condition before applied_from).
1199: The receipt application in AR causes a tax adjustment to be created in eBTax,

Line 1292: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg, 'Y') = 'Y' AND

1288: AND p_event_class_rec.perf_addnl_appl_for_imprt_flag = 'Y')
1289: THEN
1290:
1291: IF p_event_class_rec.process_for_applicability_flag = 'Y' AND
1292: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg, 'Y') = 'Y' AND
1293: -- for TM, check source_process_for_appl_flag to determine
1294: -- whether tax needs to be calcualted or not.
1295: NVL(p_event_class_rec.source_process_for_appl_flag, 'Y') = 'Y'
1296: THEN

Line 1313: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',

1309: -- Else (for location based) call tax applicability.
1310:
1311: IF (g_level_statement >= g_current_runtime_level ) THEN
1312: FND_LOG.STRING(g_level_statement,
1313: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1314: 'template_usage_code = '||p_event_class_rec.template_usage_code);
1315: END IF;
1316:
1317: IF p_event_class_rec.template_usage_code = 'TAX_RULES'

Line 1343: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)');

1339: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1340: 'RETURN_STATUS = ' || x_return_status);
1341: FND_LOG.STRING(g_level_unexpected,
1342: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1343: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)');
1344: END IF;
1345: RETURN;
1346: END IF;
1347:

Line 1421: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1417: p_trx_line_index) ='CREATE_WITH_TAX'
1418: THEN
1419: FOR i IN NVL(l_begin_index_additional, 0) .. NVL(l_end_index_additional, -1)
1420: LOOP
1421: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1422: i).self_assessed_flag := 'Y';
1423: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1424: i).overridden_flag := 'Y';
1425: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1423: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1419: FOR i IN NVL(l_begin_index_additional, 0) .. NVL(l_end_index_additional, -1)
1420: LOOP
1421: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1422: i).self_assessed_flag := 'Y';
1423: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1424: i).overridden_flag := 'Y';
1425: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1426: i).orig_self_assessed_flag := 'X';
1427: END LOOP;

Line 1425: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1421: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1422: i).self_assessed_flag := 'Y';
1423: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1424: i).overridden_flag := 'Y';
1425: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1426: i).orig_self_assessed_flag := 'X';
1427: END LOOP;
1428: END IF;
1429:

Line 1806: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_id

1802: p_tax_class,
1803: l_tax_rate_rec,
1804: x_return_status,
1805: l_error_buffer);
1806: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_id
1807: := l_tax_rate_rec.tax_rate_id;
1808:
1809: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1810: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1844: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1840: /*
1841: * populate in ZX_TDS_TAX_LINES_POPU_PKG
1842: *
1843: * SELECT zx_lines_s.NEXTVAL INTO
1844: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1845: * p_new_row_num).tax_line_id from dual;
1846: */
1847:
1848: -- populate tax_regime_id, tax_id, tax_status_id, tax_rate_id

Line 1850: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1846: */
1847:
1848: -- populate tax_regime_id, tax_id, tax_status_id, tax_rate_id
1849: --
1850: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1851: p_new_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
1852: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1853: p_new_row_num).tax_id := l_tax_rec.tax_id;
1854:

Line 1852: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1848: -- populate tax_regime_id, tax_id, tax_status_id, tax_rate_id
1849: --
1850: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1851: p_new_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
1852: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1853: p_new_row_num).tax_id := l_tax_rec.tax_id;
1854:
1855: -- bug 5077691: populate legal_reporting_status
1856: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN

Line 1857: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1853: p_new_row_num).tax_id := l_tax_rec.tax_id;
1854:
1855: -- bug 5077691: populate legal_reporting_status
1856: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
1857: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1858: p_new_row_num).legal_reporting_status :=
1859: l_tax_rec.legal_reporting_status_def_val;
1860: END IF;
1861:

Line 1862: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1858: p_new_row_num).legal_reporting_status :=
1859: l_tax_rec.legal_reporting_status_def_val;
1860: END IF;
1861:
1862: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1863: p_new_row_num).tax_jurisdiction_id :=
1864: l_tax_jur_rec.tax_jurisdiction_id;
1865: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1866: p_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;

Line 1865: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1861:
1862: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1863: p_new_row_num).tax_jurisdiction_id :=
1864: l_tax_jur_rec.tax_jurisdiction_id;
1865: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1866: p_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
1867:
1868: -- populate data from summary tax line
1869: --

Line 1870: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1866: p_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
1867:
1868: -- populate data from summary tax line
1869: --
1870: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1871: p_new_row_num).tax_regime_code := p_tax_line_rec.tax_regime_code;
1872: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1873: p_new_row_num).tax := p_tax_line_rec.tax;
1874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1872: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1868: -- populate data from summary tax line
1869: --
1870: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1871: p_new_row_num).tax_regime_code := p_tax_line_rec.tax_regime_code;
1872: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1873: p_new_row_num).tax := p_tax_line_rec.tax;
1874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1875: p_new_row_num).tax_status_code := p_tax_line_rec.tax_status_code;
1876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1870: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1871: p_new_row_num).tax_regime_code := p_tax_line_rec.tax_regime_code;
1872: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1873: p_new_row_num).tax := p_tax_line_rec.tax;
1874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1875: p_new_row_num).tax_status_code := p_tax_line_rec.tax_status_code;
1876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1877: p_new_row_num).tax_rate_code := p_tax_line_rec.tax_rate_code;
1878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1872: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1873: p_new_row_num).tax := p_tax_line_rec.tax;
1874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1875: p_new_row_num).tax_status_code := p_tax_line_rec.tax_status_code;
1876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1877: p_new_row_num).tax_rate_code := p_tax_line_rec.tax_rate_code;
1878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1879: p_new_row_num).tax_rate := p_tax_line_rec.tax_rate;
1880:

Line 1878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1875: p_new_row_num).tax_status_code := p_tax_line_rec.tax_status_code;
1876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1877: p_new_row_num).tax_rate_code := p_tax_line_rec.tax_rate_code;
1878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1879: p_new_row_num).tax_rate := p_tax_line_rec.tax_rate;
1880:
1881: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1882: p_new_row_num).tax_jurisdiction_code :=

Line 1881: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1877: p_new_row_num).tax_rate_code := p_tax_line_rec.tax_rate_code;
1878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1879: p_new_row_num).tax_rate := p_tax_line_rec.tax_rate;
1880:
1881: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1882: p_new_row_num).tax_jurisdiction_code :=
1883: p_tax_line_rec.tax_jurisdiction_code;
1884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1885: p_new_row_num).tax_amt_included_flag :=

Line 1884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1880:
1881: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1882: p_new_row_num).tax_jurisdiction_code :=
1883: p_tax_line_rec.tax_jurisdiction_code;
1884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1885: p_new_row_num).tax_amt_included_flag :=
1886: p_tax_line_rec.tax_amt_included_flag;
1887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1888: p_new_row_num).tax_exception_id := p_tax_line_rec.tax_exception_id;

Line 1887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1883: p_tax_line_rec.tax_jurisdiction_code;
1884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1885: p_new_row_num).tax_amt_included_flag :=
1886: p_tax_line_rec.tax_amt_included_flag;
1887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1888: p_new_row_num).tax_exception_id := p_tax_line_rec.tax_exception_id;
1889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1890: p_new_row_num).tax_exemption_id := p_tax_line_rec.tax_exemption_id;
1891: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1885: p_new_row_num).tax_amt_included_flag :=
1886: p_tax_line_rec.tax_amt_included_flag;
1887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1888: p_new_row_num).tax_exception_id := p_tax_line_rec.tax_exception_id;
1889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1890: p_new_row_num).tax_exemption_id := p_tax_line_rec.tax_exemption_id;
1891: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1892: p_new_row_num).exempt_reason_code := p_tax_line_rec.exempt_reason_code;
1893: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1891: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1888: p_new_row_num).tax_exception_id := p_tax_line_rec.tax_exception_id;
1889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1890: p_new_row_num).tax_exemption_id := p_tax_line_rec.tax_exemption_id;
1891: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1892: p_new_row_num).exempt_reason_code := p_tax_line_rec.exempt_reason_code;
1893: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1894: p_new_row_num).exempt_certificate_number :=
1895: p_tax_line_rec.exempt_certificate_number;

Line 1893: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1890: p_new_row_num).tax_exemption_id := p_tax_line_rec.tax_exemption_id;
1891: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1892: p_new_row_num).exempt_reason_code := p_tax_line_rec.exempt_reason_code;
1893: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1894: p_new_row_num).exempt_certificate_number :=
1895: p_tax_line_rec.exempt_certificate_number;
1896:
1897: -- If the value of p_event_class_rec.tax_recovery_flag is 'N',

Line 1905: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1901: /*
1902: * call populate_recovery_flg in ZX_TDS_TAX_LINES_POPU_PKG instead
1903: *
1904: * IF NVL(p_event_class_rec.tax_recovery_flag, 'N') = 'N' THEN
1905: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1906: * p_new_row_num).process_for_recovery_flag := 'N';
1907: * ELSE
1908: * IF NVL(l_tax_rec.reporting_only_flag, 'N') <> 'Y' THEN
1909: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1909: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1905: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1906: * p_new_row_num).process_for_recovery_flag := 'N';
1907: * ELSE
1908: * IF NVL(l_tax_rec.reporting_only_flag, 'N') <> 'Y' THEN
1909: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1910: * p_new_row_num).process_for_recovery_flag := 'Y';
1911: * ELSE
1912: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1913: * p_new_row_num).process_for_recovery_flag := 'N';

Line 1912: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1908: * IF NVL(l_tax_rec.reporting_only_flag, 'N') <> 'Y' THEN
1909: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1910: * p_new_row_num).process_for_recovery_flag := 'Y';
1911: * ELSE
1912: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1913: * p_new_row_num).process_for_recovery_flag := 'N';
1914: * END IF;
1915: * END IF;
1916: */

Line 1920: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1916: */
1917:
1918: -- populate rounding_lvl_party_tax_prof_id and rounding_level_code
1919: --
1920: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1921: p_new_row_num).rounding_lvl_party_tax_prof_id :=
1922: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
1923: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1924: p_new_row_num).rounding_lvl_party_type :=

Line 1922: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;

1918: -- populate rounding_lvl_party_tax_prof_id and rounding_level_code
1919: --
1920: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1921: p_new_row_num).rounding_lvl_party_tax_prof_id :=
1922: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
1923: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1924: p_new_row_num).rounding_lvl_party_type :=
1925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
1926: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1923: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1919: --
1920: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1921: p_new_row_num).rounding_lvl_party_tax_prof_id :=
1922: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
1923: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1924: p_new_row_num).rounding_lvl_party_type :=
1925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
1926: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1927: p_new_row_num).rounding_level_code :=

Line 1925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;

1921: p_new_row_num).rounding_lvl_party_tax_prof_id :=
1922: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
1923: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1924: p_new_row_num).rounding_lvl_party_type :=
1925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
1926: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1927: p_new_row_num).rounding_level_code :=
1928: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;
1929:

Line 1926: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1922: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
1923: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1924: p_new_row_num).rounding_lvl_party_type :=
1925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
1926: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1927: p_new_row_num).rounding_level_code :=
1928: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;
1929:
1930: -- populate tax dates

Line 1928: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;

1924: p_new_row_num).rounding_lvl_party_type :=
1925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
1926: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1927: p_new_row_num).rounding_level_code :=
1928: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;
1929:
1930: -- populate tax dates
1931: --
1932: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1932: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1928: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;
1929:
1930: -- populate tax dates
1931: --
1932: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1933: p_new_row_num).tax_date := l_tax_date;
1934: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1935: p_new_row_num).tax_determine_date := l_tax_determine_date;
1936: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1934: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1930: -- populate tax dates
1931: --
1932: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1933: p_new_row_num).tax_date := l_tax_date;
1934: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1935: p_new_row_num).tax_determine_date := l_tax_determine_date;
1936: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1937: p_new_row_num).tax_point_date := l_tax_point_date;
1938:

Line 1936: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1932: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1933: p_new_row_num).tax_date := l_tax_date;
1934: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1935: p_new_row_num).tax_determine_date := l_tax_determine_date;
1936: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1937: p_new_row_num).tax_point_date := l_tax_point_date;
1938:
1939: -- bug 3282018: set manually_entered_flag='Y', last_manual_entry='TAX_AMOUNT'
1940: --

Line 1941: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1937: p_new_row_num).tax_point_date := l_tax_point_date;
1938:
1939: -- bug 3282018: set manually_entered_flag='Y', last_manual_entry='TAX_AMOUNT'
1940: --
1941: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1942: p_new_row_num).manually_entered_flag := 'Y';
1943: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1944: p_new_row_num).last_manual_entry := 'TAX_AMOUNT';
1945:

Line 1943: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1939: -- bug 3282018: set manually_entered_flag='Y', last_manual_entry='TAX_AMOUNT'
1940: --
1941: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1942: p_new_row_num).manually_entered_flag := 'Y';
1943: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1944: p_new_row_num).last_manual_entry := 'TAX_AMOUNT';
1945:
1946: -- set self_assesses_flag = 'N' for all detail tax lines created from summary
1947: -- tax lines

Line 1949: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1945:
1946: -- set self_assesses_flag = 'N' for all detail tax lines created from summary
1947: -- tax lines
1948: --
1949: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1950: p_new_row_num).self_assessed_flag := 'N';
1951:
1952: -- set proration_code
1953: --

Line 1954: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1950: p_new_row_num).self_assessed_flag := 'N';
1951:
1952: -- set proration_code
1953: --
1954: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1955: p_new_row_num).proration_code := 'REGULAR_IMPORT';
1956:
1957: -- populate mandatory columns
1958: --

Line 1959: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1955: p_new_row_num).proration_code := 'REGULAR_IMPORT';
1956:
1957: -- populate mandatory columns
1958: --
1959: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1960: p_new_row_num).internal_organization_id :=
1961: p_tax_line_rec.internal_organization_id;
1962: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1963: p_new_row_num).application_id := p_event_class_rec.application_id;

Line 1962: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1958: --
1959: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1960: p_new_row_num).internal_organization_id :=
1961: p_tax_line_rec.internal_organization_id;
1962: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1963: p_new_row_num).application_id := p_event_class_rec.application_id;
1964: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1965: p_new_row_num).entity_code := p_event_class_rec.entity_code;
1966: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1964: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1960: p_new_row_num).internal_organization_id :=
1961: p_tax_line_rec.internal_organization_id;
1962: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1963: p_new_row_num).application_id := p_event_class_rec.application_id;
1964: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1965: p_new_row_num).entity_code := p_event_class_rec.entity_code;
1966: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1967: p_new_row_num).event_class_code := p_event_class_rec.event_class_code;
1968: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1966: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1962: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1963: p_new_row_num).application_id := p_event_class_rec.application_id;
1964: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1965: p_new_row_num).entity_code := p_event_class_rec.entity_code;
1966: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1967: p_new_row_num).event_class_code := p_event_class_rec.event_class_code;
1968: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1969: p_new_row_num).event_type_code := p_event_class_rec.event_type_code;
1970: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1968: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1964: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1965: p_new_row_num).entity_code := p_event_class_rec.entity_code;
1966: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1967: p_new_row_num).event_class_code := p_event_class_rec.event_class_code;
1968: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1969: p_new_row_num).event_type_code := p_event_class_rec.event_type_code;
1970: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1971: p_new_row_num).trx_id := p_event_class_rec.trx_id;
1972: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1970: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1966: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1967: p_new_row_num).event_class_code := p_event_class_rec.event_class_code;
1968: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1969: p_new_row_num).event_type_code := p_event_class_rec.event_type_code;
1970: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1971: p_new_row_num).trx_id := p_event_class_rec.trx_id;
1972: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1973: p_new_row_num).trx_line_id := p_tax_line_rec.trx_line_id;
1974: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1972: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1968: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1969: p_new_row_num).event_type_code := p_event_class_rec.event_type_code;
1970: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1971: p_new_row_num).trx_id := p_event_class_rec.trx_id;
1972: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1973: p_new_row_num).trx_line_id := p_tax_line_rec.trx_line_id;
1974: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1975: p_new_row_num).trx_level_type := p_tax_line_rec.trx_level_type;
1976:

Line 1974: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1970: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1971: p_new_row_num).trx_id := p_event_class_rec.trx_id;
1972: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1973: p_new_row_num).trx_line_id := p_tax_line_rec.trx_line_id;
1974: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1975: p_new_row_num).trx_level_type := p_tax_line_rec.trx_level_type;
1976:
1977: -- Bug#457200- populate content_owner_id
1978: --

Line 1979: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1975: p_new_row_num).trx_level_type := p_tax_line_rec.trx_level_type;
1976:
1977: -- Bug#457200- populate content_owner_id
1978: --
1979: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1980: p_new_row_num).content_owner_id := p_event_class_rec.first_pty_org_id;
1981:
1982: -- populate interface_tax_line_id, interface_entity_code for AR import service
1983: --

Line 1984: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1980: p_new_row_num).content_owner_id := p_event_class_rec.first_pty_org_id;
1981:
1982: -- populate interface_tax_line_id, interface_entity_code for AR import service
1983: --
1984: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1985: p_new_row_num).interface_tax_line_id := p_tax_line_rec.interface_tax_line_id;
1986: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1987: p_new_row_num).interface_entity_code := p_tax_line_rec.interface_entity_code;
1988:

Line 1986: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1982: -- populate interface_tax_line_id, interface_entity_code for AR import service
1983: --
1984: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1985: p_new_row_num).interface_tax_line_id := p_tax_line_rec.interface_tax_line_id;
1986: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1987: p_new_row_num).interface_entity_code := p_tax_line_rec.interface_entity_code;
1988:
1989: /*
1990: * populate WHO columns in ZX_TDS_TAX_LINES_POPU_PKG

Line 1992: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1988:
1989: /*
1990: * populate WHO columns in ZX_TDS_TAX_LINES_POPU_PKG
1991: *
1992: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1993: * p_new_row_num).created_by := fnd_global.user_id;
1994: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1995: * p_new_row_num).creation_date := sysdate;
1996: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1994: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1990: * populate WHO columns in ZX_TDS_TAX_LINES_POPU_PKG
1991: *
1992: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1993: * p_new_row_num).created_by := fnd_global.user_id;
1994: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1995: * p_new_row_num).creation_date := sysdate;
1996: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1997: * p_new_row_num).last_updated_by := fnd_global.user_id;
1998: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1996: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1992: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1993: * p_new_row_num).created_by := fnd_global.user_id;
1994: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1995: * p_new_row_num).creation_date := sysdate;
1996: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1997: * p_new_row_num).last_updated_by := fnd_global.user_id;
1998: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1999: * p_new_row_num).last_update_date := sysdate;
2000: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1998: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1994: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1995: * p_new_row_num).creation_date := sysdate;
1996: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1997: * p_new_row_num).last_updated_by := fnd_global.user_id;
1998: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1999: * p_new_row_num).last_update_date := sysdate;
2000: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2001: * p_new_row_num).last_update_login := fnd_global.login_id;
2002: */

Line 2000: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1996: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1997: * p_new_row_num).last_updated_by := fnd_global.user_id;
1998: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1999: * p_new_row_num).last_update_date := sysdate;
2000: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2001: * p_new_row_num).last_update_login := fnd_global.login_id;
2002: */
2003:
2004: IF (g_level_event >= g_current_runtime_level ) THEN

Line 2101: l_new_row_num := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);

2097: -- initialize local variables
2098: --
2099: -- bug fix 4867933 begin
2100: -- l_new_row_num := NVL(x_end_index, 0);
2101: l_new_row_num := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
2102: l_orig_begin_index := x_begin_index;
2103: l_orig_end_index := x_end_index;
2104:
2105: FOR tax_line_rec in get_tax_lines_csr LOOP

Line 2125: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2121: l_new_row_num := l_new_row_num +1;
2122:
2123: -- populate tax related information from tax_line_rec
2124: --
2125: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2126: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
2127: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2128: l_new_row_num).tax := tax_line_rec.tax;
2129: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2127: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2123: -- populate tax related information from tax_line_rec
2124: --
2125: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2126: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
2127: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2128: l_new_row_num).tax := tax_line_rec.tax;
2129: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2130: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
2131:

Line 2129: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2125: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2126: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
2127: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2128: l_new_row_num).tax := tax_line_rec.tax;
2129: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2130: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
2131:
2132: -- validate and populate tax_regime_id
2133: --

Line 2157: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2153: END IF;
2154: RETURN;
2155: END IF;
2156:
2157: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2158: l_new_row_num).tax_regime_id :=
2159: l_tax_regime_rec.tax_regime_id;
2160:
2161: -- validate and populate tax_id

Line 2187: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2183: END IF;
2184: RETURN;
2185: END IF;
2186:
2187: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2188: l_new_row_num).tax_id := l_tax_rec.tax_id;
2189:
2190: -- bug 5077691: populate legal_reporting_status
2191: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN

Line 2192: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2188: l_new_row_num).tax_id := l_tax_rec.tax_id;
2189:
2190: -- bug 5077691: populate legal_reporting_status
2191: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
2192: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2193: l_new_row_num).legal_reporting_status :=
2194: l_tax_rec.legal_reporting_status_def_val;
2195: END IF;
2196:

Line 2229: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2225: END IF;
2226: RETURN;
2227: END IF;
2228:
2229: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2230: l_new_row_num).tax_jurisdiction_id :=
2231: l_tax_jur_rec.tax_jurisdiction_id;
2232: END IF;
2233:

Line 2261: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2257: END IF;
2258: RETURN;
2259: END IF;
2260:
2261: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2262: l_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
2263:
2264: -- populate taxable_basis_formula and tax_calculation_formula
2265: --

Line 2266: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2262: l_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
2263:
2264: -- populate taxable_basis_formula and tax_calculation_formula
2265: --
2266: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2267: l_new_row_num).taxable_basis_formula :=
2268: tax_line_rec.taxable_basis_formula;
2269: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2270: l_new_row_num).tax_calculation_formula :=

Line 2269: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2265: --
2266: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2267: l_new_row_num).taxable_basis_formula :=
2268: tax_line_rec.taxable_basis_formula;
2269: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2270: l_new_row_num).tax_calculation_formula :=
2271: tax_line_rec.tax_calculation_formula;
2272:
2273: -- 1. If applied_amt_handling_flag ='P', populate tax rate percentage from

Line 2282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2278:
2279: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2280: tax_line_rec.tax_id).applied_amt_handling_flag = 'P' THEN
2281:
2282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2283: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2285: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2286: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2280: tax_line_rec.tax_id).applied_amt_handling_flag = 'P' THEN
2281:
2282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2283: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2285: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2286: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2287: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
2288:

Line 2286: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2283: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2285: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2286: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2287: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
2288:
2289: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2290: tax_line_rec.tax_id).applied_amt_handling_flag = 'R' THEN

Line 2292: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2288:
2289: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2290: tax_line_rec.tax_id).applied_amt_handling_flag = 'R' THEN
2291:
2292: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2293: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2294:
2295: IF tax_line_rec.line_amt <> 0 THEN
2296:

Line 2303: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2299: --
2300: l_line_amt_current :=
2301: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
2302:
2303: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2304: l_new_row_num).prd_total_tax_amt := tax_line_rec.tax_amt *
2305: (l_line_amt_current/tax_line_rec.line_amt);
2306: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2307: l_new_row_num).prd_total_tax_amt_tax_curr :=

Line 2306: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2302:
2303: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2304: l_new_row_num).prd_total_tax_amt := tax_line_rec.tax_amt *
2305: (l_line_amt_current/tax_line_rec.line_amt);
2306: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2307: l_new_row_num).prd_total_tax_amt_tax_curr :=
2308: tax_line_rec.tax_amt_tax_curr *
2309: l_line_amt_current/tax_line_rec.line_amt;
2310:

Line 2311: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2307: l_new_row_num).prd_total_tax_amt_tax_curr :=
2308: tax_line_rec.tax_amt_tax_curr *
2309: l_line_amt_current/tax_line_rec.line_amt;
2310:
2311: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2312: l_new_row_num).prd_total_tax_amt_funcl_curr :=
2313: tax_line_rec.tax_amt_funcl_curr *
2314: l_line_amt_current/tax_line_rec.line_amt;
2315:

Line 2319: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2315:
2316: -- do rounding. May be moved to rounding package later
2317: --
2318: IF tax_line_rec.ledger_id IS NOT NULL THEN
2319: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2320: l_new_row_num).prd_total_tax_amt_funcl_curr :=
2321: ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau (
2322: tax_line_rec.ledger_id,
2323: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2323: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2319: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2320: l_new_row_num).prd_total_tax_amt_funcl_curr :=
2321: ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau (
2322: tax_line_rec.ledger_id,
2323: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2324: l_new_row_num).prd_total_tax_amt_funcl_curr);
2325:
2326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2327: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 2347: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2343: END IF; -- applied_amt_handling_flag = 'P' or 'R'
2344:
2345: -- Populate other doc line amt, taxable amt and tax amt
2346: --
2347: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2348: l_new_row_num).other_doc_line_amt := tax_line_rec.line_amt;
2349:
2350: -- bug 7024219
2351: --

Line 2354: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2350: -- bug 7024219
2351: --
2352: IF NVL(tax_line_rec.historical_flag, 'N') = 'Y' THEN
2353:
2354: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2355: l_new_row_num).other_doc_line_taxable_amt :=
2356: NVL(tax_line_rec.unrounded_taxable_amt, tax_line_rec.taxable_amt);
2357:
2358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2354: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2355: l_new_row_num).other_doc_line_taxable_amt :=
2356: NVL(tax_line_rec.unrounded_taxable_amt, tax_line_rec.taxable_amt);
2357:
2358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2359: l_new_row_num).other_doc_line_tax_amt :=
2360: NVL(tax_line_rec.unrounded_tax_amt, tax_line_rec.tax_amt);
2361:
2362: ELSE

Line 2364: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2360: NVL(tax_line_rec.unrounded_tax_amt, tax_line_rec.tax_amt);
2361:
2362: ELSE
2363:
2364: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2365: l_new_row_num).other_doc_line_taxable_amt :=
2366: tax_line_rec.unrounded_taxable_amt;
2367: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2368: l_new_row_num).other_doc_line_tax_amt :=

Line 2367: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2363:
2364: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2365: l_new_row_num).other_doc_line_taxable_amt :=
2366: tax_line_rec.unrounded_taxable_amt;
2367: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2368: l_new_row_num).other_doc_line_tax_amt :=
2369: tax_line_rec.unrounded_tax_amt;
2370: END IF;
2371:

Line 2374: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2370: END IF;
2371:
2372: -- Set copied_from_other_doc_flag to 'Y'
2373: --
2374: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2375: l_new_row_num).copied_from_other_doc_flag := 'Y';
2376:
2377: -- set other_doc_source
2378: --

Line 2379: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2375: l_new_row_num).copied_from_other_doc_flag := 'Y';
2376:
2377: -- set other_doc_source
2378: --
2379: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2380: l_new_row_num).other_doc_source := 'APPLIED_FROM';
2381:
2382: -- populate manually_entered_flag, overridden_flag and last_manual_entry
2383: --

Line 2384: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2380: l_new_row_num).other_doc_source := 'APPLIED_FROM';
2381:
2382: -- populate manually_entered_flag, overridden_flag and last_manual_entry
2383: --
2384: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2385: l_new_row_num).manually_entered_flag := 'Y';
2386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2387: l_new_row_num).overridden_flag := 'Y';
2388: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2382: -- populate manually_entered_flag, overridden_flag and last_manual_entry
2383: --
2384: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2385: l_new_row_num).manually_entered_flag := 'Y';
2386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2387: l_new_row_num).overridden_flag := 'Y';
2388: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2389: l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2390:

Line 2388: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2384: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2385: l_new_row_num).manually_entered_flag := 'Y';
2386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2387: l_new_row_num).overridden_flag := 'Y';
2388: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2389: l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2390:
2391: -- populate other columns
2392: --

Line 2393: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2389: l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2390:
2391: -- populate other columns
2392: --
2393: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2394: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
2395: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2396: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2397: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2395: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2391: -- populate other columns
2392: --
2393: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2394: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
2395: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2396: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2397: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2398: l_new_row_num).tax_date := p_tax_date;
2399: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2397: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2393: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2394: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
2395: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2396: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2397: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2398: l_new_row_num).tax_date := p_tax_date;
2399: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2400: l_new_row_num).tax_determine_date := p_tax_determine_date;
2401: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2399: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2395: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2396: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2397: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2398: l_new_row_num).tax_date := p_tax_date;
2399: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2400: l_new_row_num).tax_determine_date := p_tax_determine_date;
2401: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2402: l_new_row_num).tax_point_date := p_tax_point_date;
2403: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2401: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2397: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2398: l_new_row_num).tax_date := p_tax_date;
2399: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2400: l_new_row_num).tax_determine_date := p_tax_determine_date;
2401: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2402: l_new_row_num).tax_point_date := p_tax_point_date;
2403: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2404: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2405:

Line 2403: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2399: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2400: l_new_row_num).tax_determine_date := p_tax_determine_date;
2401: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2402: l_new_row_num).tax_point_date := p_tax_point_date;
2403: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2404: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2405:
2406: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2407: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;

Line 2406: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2402: l_new_row_num).tax_point_date := p_tax_point_date;
2403: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2404: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2405:
2406: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2407: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
2408: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2409: l_new_row_num).place_of_supply_type_code :=
2410: tax_line_rec.place_of_supply_type_code;

Line 2408: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2404: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2405:
2406: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2407: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
2408: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2409: l_new_row_num).place_of_supply_type_code :=
2410: tax_line_rec.place_of_supply_type_code;
2411: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2412: l_new_row_num).place_of_supply_result_id :=

Line 2411: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2407: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
2408: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2409: l_new_row_num).place_of_supply_type_code :=
2410: tax_line_rec.place_of_supply_type_code;
2411: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2412: l_new_row_num).place_of_supply_result_id :=
2413: tax_line_rec.place_of_supply_result_id;
2414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2415: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;

Line 2414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2410: tax_line_rec.place_of_supply_type_code;
2411: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2412: l_new_row_num).place_of_supply_result_id :=
2413: tax_line_rec.place_of_supply_result_id;
2414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2415: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;
2416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2417: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2412: l_new_row_num).place_of_supply_result_id :=
2413: tax_line_rec.place_of_supply_result_id;
2414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2415: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;
2416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2417: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2419: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2415: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;
2416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2417: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2419: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2421: l_new_row_num).tax_jurisdiction_code :=
2422: tax_line_rec.tax_jurisdiction_code;

Line 2420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2417: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2419: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2421: l_new_row_num).tax_jurisdiction_code :=
2422: tax_line_rec.tax_jurisdiction_code;
2423: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2424: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;

Line 2423: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2419: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2421: l_new_row_num).tax_jurisdiction_code :=
2422: tax_line_rec.tax_jurisdiction_code;
2423: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2424: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
2425: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2426: l_new_row_num).tax_registration_number :=
2427: tax_line_rec.tax_registration_number;

Line 2425: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2421: l_new_row_num).tax_jurisdiction_code :=
2422: tax_line_rec.tax_jurisdiction_code;
2423: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2424: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
2425: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2426: l_new_row_num).tax_registration_number :=
2427: tax_line_rec.tax_registration_number;
2428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2429: l_new_row_num).registration_party_type :=

Line 2428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2424: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
2425: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2426: l_new_row_num).tax_registration_number :=
2427: tax_line_rec.tax_registration_number;
2428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2429: l_new_row_num).registration_party_type :=
2430: tax_line_rec.registration_party_type;
2431: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2432: l_new_row_num).tax_applicability_result_id :=

Line 2431: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2427: tax_line_rec.tax_registration_number;
2428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2429: l_new_row_num).registration_party_type :=
2430: tax_line_rec.registration_party_type;
2431: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2432: l_new_row_num).tax_applicability_result_id :=
2433: tax_line_rec.tax_applicability_result_id;
2434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2435: l_new_row_num).direct_rate_result_id :=

Line 2434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2430: tax_line_rec.registration_party_type;
2431: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2432: l_new_row_num).tax_applicability_result_id :=
2433: tax_line_rec.tax_applicability_result_id;
2434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2435: l_new_row_num).direct_rate_result_id :=
2436: tax_line_rec.direct_rate_result_id;
2437: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2438: l_new_row_num).rounding_lvl_party_tax_prof_id :=

Line 2437: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2433: tax_line_rec.tax_applicability_result_id;
2434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2435: l_new_row_num).direct_rate_result_id :=
2436: tax_line_rec.direct_rate_result_id;
2437: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2438: l_new_row_num).rounding_lvl_party_tax_prof_id :=
2439: tax_line_rec.rounding_lvl_party_tax_prof_id;
2440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2441: l_new_row_num).rounding_lvl_party_type :=

Line 2440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2436: tax_line_rec.direct_rate_result_id;
2437: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2438: l_new_row_num).rounding_lvl_party_tax_prof_id :=
2439: tax_line_rec.rounding_lvl_party_tax_prof_id;
2440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2441: l_new_row_num).rounding_lvl_party_type :=
2442: tax_line_rec.rounding_lvl_party_type;
2443: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2444: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;

Line 2443: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2439: tax_line_rec.rounding_lvl_party_tax_prof_id;
2440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2441: l_new_row_num).rounding_lvl_party_type :=
2442: tax_line_rec.rounding_lvl_party_type;
2443: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2444: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
2445: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2446: l_new_row_num).tax_reg_num_det_result_id :=
2447: tax_line_rec.tax_reg_num_det_result_id;

Line 2445: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2441: l_new_row_num).rounding_lvl_party_type :=
2442: tax_line_rec.rounding_lvl_party_type;
2443: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2444: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
2445: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2446: l_new_row_num).tax_reg_num_det_result_id :=
2447: tax_line_rec.tax_reg_num_det_result_id;
2448: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2449: l_new_row_num).tax_amt_included_flag := tax_line_rec.tax_amt_included_flag;

Line 2448: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2444: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
2445: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2446: l_new_row_num).tax_reg_num_det_result_id :=
2447: tax_line_rec.tax_reg_num_det_result_id;
2448: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2449: l_new_row_num).tax_amt_included_flag := tax_line_rec.tax_amt_included_flag;
2450: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2451: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
2452: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2450: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2446: l_new_row_num).tax_reg_num_det_result_id :=
2447: tax_line_rec.tax_reg_num_det_result_id;
2448: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2449: l_new_row_num).tax_amt_included_flag := tax_line_rec.tax_amt_included_flag;
2450: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2451: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
2452: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2453: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
2454:

Line 2452: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2448: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2449: l_new_row_num).tax_amt_included_flag := tax_line_rec.tax_amt_included_flag;
2450: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2451: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
2452: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2453: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
2454:
2455: IF (x_begin_index IS NULL) THEN
2456: x_begin_index := l_new_row_num;

Line 2462: x_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;

2458: END IF; -- l_tax_tbl_index IS NOT NULL
2459: END LOOP; -- FOR tax_line_rec in get_tax_lines_csr
2460:
2461: IF (x_begin_index IS NOT NULL) THEN
2462: x_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
2463: END IF;
2464:
2465: -- copy transaction info to new tax lines for new tax_lines created here
2466: --

Line 2607: l_new_row_num := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);

2603: -- initialize local variables
2604: --
2605: -- bug fix 4867933 begin
2606: -- l_new_row_num := NVL(x_end_index, 0);
2607: l_new_row_num := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
2608: l_orig_begin_index := x_begin_index;
2609: l_orig_end_index := x_end_index;
2610:
2611: FOR tax_line_rec in get_tax_lines_csr LOOP

Line 2661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2657: l_new_row_num := l_new_row_num +1;
2658:
2659: -- populate tax related information from tax_line_rec
2660: --
2661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2662: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
2663: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2664: l_new_row_num).tax := tax_line_rec.tax;
2665: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2663: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2659: -- populate tax related information from tax_line_rec
2660: --
2661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2662: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
2663: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2664: l_new_row_num).tax := tax_line_rec.tax;
2665: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2666: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
2667:

Line 2665: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2662: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
2663: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2664: l_new_row_num).tax := tax_line_rec.tax;
2665: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2666: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
2667:
2668: -- bug 5077691: populate legal_reporting_status
2669: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN

Line 2670: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2666: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
2667:
2668: -- bug 5077691: populate legal_reporting_status
2669: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
2670: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2671: l_new_row_num).legal_reporting_status :=
2672: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2673: tax_line_rec.tax_id).legal_reporting_status_def_val;
2674: END IF;

Line 2680: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2676: -- for adjusted doc, tax regime id, tax id, tax status id, tax rate id
2677: -- should be the same as the original document since the
2678: -- tax_determination_date is the same as original
2679:
2680: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2681: l_new_row_num).tax_regime_id:= tax_line_rec.tax_regime_id;
2682: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2683: l_new_row_num).tax_id := tax_line_rec.tax_id;
2684: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2682: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2678: -- tax_determination_date is the same as original
2679:
2680: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2681: l_new_row_num).tax_regime_id:= tax_line_rec.tax_regime_id;
2682: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2683: l_new_row_num).tax_id := tax_line_rec.tax_id;
2684: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2685: l_new_row_num).tax_status_id:= tax_line_rec.tax_status_id;
2686:

Line 2684: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2680: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2681: l_new_row_num).tax_regime_id:= tax_line_rec.tax_regime_id;
2682: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2683: l_new_row_num).tax_id := tax_line_rec.tax_id;
2684: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2685: l_new_row_num).tax_status_id:= tax_line_rec.tax_status_id;
2686:
2687:
2688: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2688: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2684: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2685: l_new_row_num).tax_status_id:= tax_line_rec.tax_status_id;
2686:
2687:
2688: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2689: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2690: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2691: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2692: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2690: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2686:
2687:
2688: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2689: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2690: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2691: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2692: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2693: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
2694: -- bug 5508356

Line 2692: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2688: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2689: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2690: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2691: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2692: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2693: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
2694: -- bug 5508356
2695: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2696: l_new_row_num).account_source_tax_rate_id :=

Line 2695: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2691: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2692: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2693: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
2694: -- bug 5508356
2695: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2696: l_new_row_num).account_source_tax_rate_id :=
2697: tax_line_rec.account_source_tax_rate_id;
2698:
2699: -- populate taxable_basis_formula and tax_calculation_formula

Line 2701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2697: tax_line_rec.account_source_tax_rate_id;
2698:
2699: -- populate taxable_basis_formula and tax_calculation_formula
2700: --
2701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2702: l_new_row_num).taxable_basis_formula :=
2703: tax_line_rec.taxable_basis_formula;
2704: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2705: l_new_row_num).tax_calculation_formula :=

Line 2704: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2700: --
2701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2702: l_new_row_num).taxable_basis_formula :=
2703: tax_line_rec.taxable_basis_formula;
2704: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2705: l_new_row_num).tax_calculation_formula :=
2706: tax_line_rec.tax_calculation_formula;
2707:
2708:

Line 2710: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2706: tax_line_rec.tax_calculation_formula;
2707:
2708:
2709: -- Bug#6729097 --
2710: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2711: l_new_row_num).tax_apportionment_line_number := tax_line_rec.tax_apportionment_line_number;
2712:
2713: IF (g_level_statement >= g_current_runtime_level ) THEN
2714: FND_LOG.STRING(g_level_statement,

Line 2727: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2723: -- for other cases, set to the one from adjusted doc.
2724: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
2725: p_trx_line_index) = 'A'
2726: THEN
2727: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2728: l_new_row_num).tax_amt_included_flag := 'Y';
2729:
2730: ELSE
2731: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2731: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2727: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2728: l_new_row_num).tax_amt_included_flag := 'Y';
2729:
2730: ELSE
2731: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2732: l_new_row_num).tax_amt_included_flag
2733: := tax_line_rec.tax_amt_included_flag;
2734: END IF;
2735:

Line 2736: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2732: l_new_row_num).tax_amt_included_flag
2733: := tax_line_rec.tax_amt_included_flag;
2734: END IF;
2735:
2736: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2737: l_new_row_num).manually_entered_flag := tax_line_rec.manually_entered_flag;
2738:
2739: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2740: l_new_row_num).manually_entered_flag = 'Y' THEN

Line 2739: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2735:
2736: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2737: l_new_row_num).manually_entered_flag := tax_line_rec.manually_entered_flag;
2738:
2739: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2740: l_new_row_num).manually_entered_flag = 'Y' THEN
2741:
2742: -- don't recalculate the manually entered tax lines on the original
2743: -- trx line, butstill keep them so that user can update these

Line 2748: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2744: -- manual tax lines.
2745:
2746: -- Populate other doc line amt, taxable amt and tax amt
2747: --
2748: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2749: l_new_row_num).tax_amt := 0;
2750: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2751: l_new_row_num).taxable_amt := 0;
2752: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2750: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2746: -- Populate other doc line amt, taxable amt and tax amt
2747: --
2748: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2749: l_new_row_num).tax_amt := 0;
2750: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2751: l_new_row_num).taxable_amt := 0;
2752: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2753: l_new_row_num).unrounded_tax_amt := 0;
2754: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2752: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2748: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2749: l_new_row_num).tax_amt := 0;
2750: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2751: l_new_row_num).taxable_amt := 0;
2752: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2753: l_new_row_num).unrounded_tax_amt := 0;
2754: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2755: l_new_row_num).unrounded_taxable_amt := 0;
2756:

Line 2754: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2750: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2751: l_new_row_num).taxable_amt := 0;
2752: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2753: l_new_row_num).unrounded_tax_amt := 0;
2754: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2755: l_new_row_num).unrounded_taxable_amt := 0;
2756:
2757: ELSE
2758: -- For system generated tax lines on the original trx line

Line 2772: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2768: END IF;
2769:
2770: -- for tax only adjustment set the unrounded tax amount to the
2771: -- unrounded tax amount of the original doc.
2772: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2773: l_new_row_num).unrounded_taxable_amt := tax_line_rec.unrounded_taxable_amt;
2774: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2775: l_new_row_num).unrounded_tax_amt := tax_line_rec.unrounded_tax_amt;
2776:

Line 2774: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2770: -- for tax only adjustment set the unrounded tax amount to the
2771: -- unrounded tax amount of the original doc.
2772: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2773: l_new_row_num).unrounded_taxable_amt := tax_line_rec.unrounded_taxable_amt;
2774: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2775: l_new_row_num).unrounded_tax_amt := tax_line_rec.unrounded_tax_amt;
2776:
2777: ELSE
2778: -- current trx is a regular adjustment or CM

Line 2784: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2780: IF (g_level_statement >= g_current_runtime_level ) THEN
2781: FND_LOG.STRING(g_level_statement,
2782: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2783: 'tax_amt_included_flag on Current tax line: '||
2784: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2785: l_new_row_num).tax_amt_included_flag);
2786: FND_LOG.STRING(g_level_statement,
2787: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2788: 'tax_amt_included_flag on original tax line: '||

Line 2792: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2788: 'tax_amt_included_flag on original tax line: '||
2789: tax_line_rec.tax_amt_included_flag);
2790: END IF;
2791:
2792: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2793: l_new_row_num).tax_amt_included_flag ='Y'
2794: AND tax_line_rec.tax_amt_included_flag = 'N'
2795: THEN
2796: -- If current trx is a tax inclusive trx, while the original trx is

Line 2799: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2795: THEN
2796: -- If current trx is a tax inclusive trx, while the original trx is
2797: -- tax exclusive trx.
2798: IF ( tax_line_rec.line_amt + tax_line_rec.tax_amt) <> 0 THEN
2799: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2800: l_new_row_num).unrounded_taxable_amt
2801: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2802: ( tax_line_rec.unrounded_taxable_amt /
2803: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );

Line 2805: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2801: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2802: ( tax_line_rec.unrounded_taxable_amt /
2803: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
2804:
2805: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2806: l_new_row_num).unrounded_tax_amt
2807: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2808: ( tax_line_rec.unrounded_tax_amt /
2809: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );

Line 2811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2807: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2808: ( tax_line_rec.unrounded_tax_amt /
2809: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
2810: ELSE
2811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2812: l_new_row_num).unrounded_taxable_amt
2813: := tax_line_rec.unrounded_taxable_amt;
2814: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2815: l_new_row_num).unrounded_tax_amt

Line 2814: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2810: ELSE
2811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2812: l_new_row_num).unrounded_taxable_amt
2813: := tax_line_rec.unrounded_taxable_amt;
2814: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2815: l_new_row_num).unrounded_tax_amt
2816: := tax_line_rec.unrounded_tax_amt;
2817: END IF;
2818: ELSE -- both current tax line and original tax line are inclusive and exclusive

Line 2820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt

2816: := tax_line_rec.unrounded_tax_amt;
2817: END IF;
2818: ELSE -- both current tax line and original tax line are inclusive and exclusive
2819: IF tax_line_rec.line_amt <> 0 THEN
2820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
2821: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2822: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
2823:
2824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt

Line 2824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt

2820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
2821: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2822: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
2823:
2824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
2825: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2826: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
2827: ELSE -- equal to that the original trx is a tax only trx
2828: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt

Line 2828: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt

2824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
2825: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2826: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
2827: ELSE -- equal to that the original trx is a tax only trx
2828: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
2829: := tax_line_rec.unrounded_taxable_amt;
2830: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
2831: := tax_line_rec.unrounded_tax_amt;
2832: END IF;

Line 2830: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt

2826: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
2827: ELSE -- equal to that the original trx is a tax only trx
2828: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
2829: := tax_line_rec.unrounded_taxable_amt;
2830: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
2831: := tax_line_rec.unrounded_tax_amt;
2832: END IF;
2833: END IF; -- tax_line_rec.tax_amt_included_flag = 'N'
2834:

Line 2839: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).basis_result_id

2835: END IF; -- 'ALLOCATE_TAX_ONLY_ADJUSTMENT' trx and else
2836:
2837: END IF; -- manually_entered_flag = 'Y'
2838:
2839: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).basis_result_id
2840: := tax_line_rec.basis_result_id;
2841: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id
2842: := tax_line_rec.calc_result_id;
2843: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate

Line 2841: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id

2837: END IF; -- manually_entered_flag = 'Y'
2838:
2839: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).basis_result_id
2840: := tax_line_rec.basis_result_id;
2841: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id
2842: := tax_line_rec.calc_result_id;
2843: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate
2844: := tax_line_rec.tax_base_modifier_rate;
2845:

Line 2843: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate

2839: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).basis_result_id
2840: := tax_line_rec.basis_result_id;
2841: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id
2842: := tax_line_rec.calc_result_id;
2843: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate
2844: := tax_line_rec.tax_base_modifier_rate;
2845:
2846: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag
2847: := tax_line_rec.compounding_dep_tax_flag;

Line 2846: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag

2842: := tax_line_rec.calc_result_id;
2843: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate
2844: := tax_line_rec.tax_base_modifier_rate;
2845:
2846: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag
2847: := tax_line_rec.compounding_dep_tax_flag;
2848: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_tax_miss_flag
2849: := tax_line_rec.compounding_tax_miss_flag;
2850: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag

Line 2848: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_tax_miss_flag

2844: := tax_line_rec.tax_base_modifier_rate;
2845:
2846: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag
2847: := tax_line_rec.compounding_dep_tax_flag;
2848: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_tax_miss_flag
2849: := tax_line_rec.compounding_tax_miss_flag;
2850: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag
2851: := tax_line_rec.compounding_tax_flag;
2852:

Line 2850: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag

2846: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag
2847: := tax_line_rec.compounding_dep_tax_flag;
2848: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_tax_miss_flag
2849: := tax_line_rec.compounding_tax_miss_flag;
2850: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag
2851: := tax_line_rec.compounding_tax_flag;
2852:
2853: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2854: l_new_row_num).tax_amt_included_flag = 'Y' THEN

Line 2853: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2849: := tax_line_rec.compounding_tax_miss_flag;
2850: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag
2851: := tax_line_rec.compounding_tax_flag;
2852:
2853: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2854: l_new_row_num).tax_amt_included_flag = 'Y' THEN
2855:
2856: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
2857: p_trx_line_index) := 'Y';

Line 2860: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2856: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
2857: p_trx_line_index) := 'Y';
2858: END IF;
2859:
2860: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2861: l_new_row_num).compounding_dep_tax_flag = 'Y' THEN
2862:
2863: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
2864: p_trx_line_index) := 'Y';

Line 2867: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id

2863: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
2864: p_trx_line_index) := 'Y';
2865: END IF;
2866:
2867: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id
2868: := tax_line_rec.tax_exemption_id;
2869: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exemption
2870: := tax_line_rec.tax_rate_before_exemption;
2871: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption

Line 2869: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exemption

2865: END IF;
2866:
2867: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id
2868: := tax_line_rec.tax_exemption_id;
2869: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exemption
2870: := tax_line_rec.tax_rate_before_exemption;
2871: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption
2872: := tax_line_rec.tax_rate_name_before_exemption;
2873:

Line 2871: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption

2867: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id
2868: := tax_line_rec.tax_exemption_id;
2869: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exemption
2870: := tax_line_rec.tax_rate_before_exemption;
2871: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption
2872: := tax_line_rec.tax_rate_name_before_exemption;
2873:
2874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier
2875: := tax_line_rec.exempt_rate_modifier;

Line 2874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier

2870: := tax_line_rec.tax_rate_before_exemption;
2871: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption
2872: := tax_line_rec.tax_rate_name_before_exemption;
2873:
2874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier
2875: := tax_line_rec.exempt_rate_modifier;
2876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number
2877: := tax_line_rec.exempt_certificate_number;
2878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason

Line 2876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number

2872: := tax_line_rec.tax_rate_name_before_exemption;
2873:
2874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier
2875: := tax_line_rec.exempt_rate_modifier;
2876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number
2877: := tax_line_rec.exempt_certificate_number;
2878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason
2879: := tax_line_rec.exempt_reason;
2880: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code

Line 2878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason

2874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier
2875: := tax_line_rec.exempt_rate_modifier;
2876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number
2877: := tax_line_rec.exempt_certificate_number;
2878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason
2879: := tax_line_rec.exempt_reason;
2880: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code
2881: := tax_line_rec.exempt_reason_code;
2882:

Line 2880: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code

2876: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number
2877: := tax_line_rec.exempt_certificate_number;
2878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason
2879: := tax_line_rec.exempt_reason;
2880: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code
2881: := tax_line_rec.exempt_reason_code;
2882:
2883: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id
2884: := tax_line_rec.tax_exception_id;

Line 2883: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id

2879: := tax_line_rec.exempt_reason;
2880: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code
2881: := tax_line_rec.exempt_reason_code;
2882:
2883: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id
2884: := tax_line_rec.tax_exception_id;
2885: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception
2886: := tax_line_rec.tax_rate_before_exception;
2887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception

Line 2885: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception

2881: := tax_line_rec.exempt_reason_code;
2882:
2883: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id
2884: := tax_line_rec.tax_exception_id;
2885: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception
2886: := tax_line_rec.tax_rate_before_exception;
2887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception
2888: := tax_line_rec.tax_rate_name_before_exception;
2889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate

Line 2887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception

2883: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id
2884: := tax_line_rec.tax_exception_id;
2885: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception
2886: := tax_line_rec.tax_rate_before_exception;
2887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception
2888: := tax_line_rec.tax_rate_name_before_exception;
2889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate
2890: := tax_line_rec.exception_rate;
2891:

Line 2889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate

2885: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception
2886: := tax_line_rec.tax_rate_before_exception;
2887: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception
2888: := tax_line_rec.tax_rate_name_before_exception;
2889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate
2890: := tax_line_rec.exception_rate;
2891:
2892: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2893: l_new_row_num).adjusted_doc_tax_line_id := tax_line_rec.tax_line_id;

Line 2892: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2888: := tax_line_rec.tax_rate_name_before_exception;
2889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate
2890: := tax_line_rec.exception_rate;
2891:
2892: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2893: l_new_row_num).adjusted_doc_tax_line_id := tax_line_rec.tax_line_id;
2894:
2895: -- populate overridden_flag and last_manual_entry for manual tax line
2896: --

Line 2897: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2893: l_new_row_num).adjusted_doc_tax_line_id := tax_line_rec.tax_line_id;
2894:
2895: -- populate overridden_flag and last_manual_entry for manual tax line
2896: --
2897: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2898: l_new_row_num).overridden_flag := 'Y';
2899: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2900: l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2901:

Line 2899: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2895: -- populate overridden_flag and last_manual_entry for manual tax line
2896: --
2897: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2898: l_new_row_num).overridden_flag := 'Y';
2899: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2900: l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2901:
2902: -- Populate other doc line amt, taxable amt and tax amt
2903: --

Line 2904: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2900: l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2901:
2902: -- Populate other doc line amt, taxable amt and tax amt
2903: --
2904: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2905: l_new_row_num).other_doc_line_amt := tax_line_rec.line_amt;
2906: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2907: l_new_row_num).other_doc_line_taxable_amt :=
2908: tax_line_rec.unrounded_taxable_amt;

Line 2906: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2902: -- Populate other doc line amt, taxable amt and tax amt
2903: --
2904: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2905: l_new_row_num).other_doc_line_amt := tax_line_rec.line_amt;
2906: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2907: l_new_row_num).other_doc_line_taxable_amt :=
2908: tax_line_rec.unrounded_taxable_amt;
2909: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2910: l_new_row_num).other_doc_line_tax_amt :=

Line 2909: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2905: l_new_row_num).other_doc_line_amt := tax_line_rec.line_amt;
2906: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2907: l_new_row_num).other_doc_line_taxable_amt :=
2908: tax_line_rec.unrounded_taxable_amt;
2909: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2910: l_new_row_num).other_doc_line_tax_amt :=
2911: tax_line_rec.unrounded_tax_amt;
2912:
2913: -- Set copied_from_other_doc_flag to 'Y'

Line 2915: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2911: tax_line_rec.unrounded_tax_amt;
2912:
2913: -- Set copied_from_other_doc_flag to 'Y'
2914: --
2915: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2916: l_new_row_num).copied_from_other_doc_flag := 'Y';
2917:
2918: -- set other_doc_source
2919: --

Line 2920: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2916: l_new_row_num).copied_from_other_doc_flag := 'Y';
2917:
2918: -- set other_doc_source
2919: --
2920: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2921: l_new_row_num).other_doc_source := 'ADJUSTED';
2922:
2923: -- populate other columns
2924: --

Line 2925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2921: l_new_row_num).other_doc_source := 'ADJUSTED';
2922:
2923: -- populate other columns
2924: --
2925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2926: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
2927: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2928: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2929: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2927: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2923: -- populate other columns
2924: --
2925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2926: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
2927: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2928: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2929: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2930: l_new_row_num).tax_date := p_tax_date;
2931: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2929: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2926: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
2927: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2928: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2929: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2930: l_new_row_num).tax_date := p_tax_date;
2931: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2932: l_new_row_num).tax_determine_date := p_tax_determine_date;
2933: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2931: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2927: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2928: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2929: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2930: l_new_row_num).tax_date := p_tax_date;
2931: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2932: l_new_row_num).tax_determine_date := p_tax_determine_date;
2933: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2934: l_new_row_num).tax_point_date := p_tax_point_date;
2935: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2933: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2929: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2930: l_new_row_num).tax_date := p_tax_date;
2931: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2932: l_new_row_num).tax_determine_date := p_tax_determine_date;
2933: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2934: l_new_row_num).tax_point_date := p_tax_point_date;
2935: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2936: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2937:

Line 2935: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2931: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2932: l_new_row_num).tax_determine_date := p_tax_determine_date;
2933: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2934: l_new_row_num).tax_point_date := p_tax_point_date;
2935: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2936: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2937:
2938: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2939: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;

Line 2938: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2934: l_new_row_num).tax_point_date := p_tax_point_date;
2935: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2936: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2937:
2938: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2939: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
2940: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2941: l_new_row_num).place_of_supply_type_code :=
2942: tax_line_rec.place_of_supply_type_code;

Line 2940: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2936: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2937:
2938: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2939: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
2940: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2941: l_new_row_num).place_of_supply_type_code :=
2942: tax_line_rec.place_of_supply_type_code;
2943: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2944: l_new_row_num).place_of_supply_result_id :=

Line 2943: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2939: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
2940: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2941: l_new_row_num).place_of_supply_type_code :=
2942: tax_line_rec.place_of_supply_type_code;
2943: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2944: l_new_row_num).place_of_supply_result_id :=
2945: tax_line_rec.place_of_supply_result_id;
2946: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2947: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;

Line 2946: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2942: tax_line_rec.place_of_supply_type_code;
2943: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2944: l_new_row_num).place_of_supply_result_id :=
2945: tax_line_rec.place_of_supply_result_id;
2946: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2947: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;
2948:
2949: /* Bug 5149379: When the trx currency is different from the tax currency,
2950: it is necessary to pick the tax_currency_conversion_date,

Line 2954: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2950: it is necessary to pick the tax_currency_conversion_date,
2951: tax_currency_conversion_type, tax_currency_conversion_rate
2952: information from the invoice tax lines.
2953: */
2954: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2955: l_new_row_num).tax_currency_conversion_date := tax_line_rec.tax_currency_conversion_date;
2956: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2957: l_new_row_num).tax_currency_conversion_type := tax_line_rec.tax_currency_conversion_type;
2958: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2956: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2952: information from the invoice tax lines.
2953: */
2954: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2955: l_new_row_num).tax_currency_conversion_date := tax_line_rec.tax_currency_conversion_date;
2956: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2957: l_new_row_num).tax_currency_conversion_type := tax_line_rec.tax_currency_conversion_type;
2958: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2959: l_new_row_num).tax_currency_conversion_rate := tax_line_rec.tax_currency_conversion_rate;
2960:

Line 2958: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2954: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2955: l_new_row_num).tax_currency_conversion_date := tax_line_rec.tax_currency_conversion_date;
2956: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2957: l_new_row_num).tax_currency_conversion_type := tax_line_rec.tax_currency_conversion_type;
2958: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2959: l_new_row_num).tax_currency_conversion_rate := tax_line_rec.tax_currency_conversion_rate;
2960:
2961: /* Bug 5131206: For partner integration, when the line_level_action is
2962: 'ALLOCATE_TAX_ONLY_ADJUSTMENT', eBTax needs to create

Line 2967: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2963: prorated tax lines and stamp the tax_provider_id on
2964: the tax line(s).
2965: */
2966:
2967: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2968: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
2969:
2970: if(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' and
2971: tax_line_rec.tax_provider_id is not null ) THEN

Line 2972: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';

2968: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
2969:
2970: if(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' and
2971: tax_line_rec.tax_provider_id is not null ) THEN
2972: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';
2973: end if;
2974:
2975:
2976: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2976: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2972: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';
2973: end if;
2974:
2975:
2976: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2977: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2979: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2974:
2975:
2976: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2977: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2979: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2981: l_new_row_num).tax_jurisdiction_code :=
2982: tax_line_rec.tax_jurisdiction_code;

Line 2980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2976: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2977: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2979: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2981: l_new_row_num).tax_jurisdiction_code :=
2982: tax_line_rec.tax_jurisdiction_code;
2983: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2984: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;

Line 2983: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2979: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2981: l_new_row_num).tax_jurisdiction_code :=
2982: tax_line_rec.tax_jurisdiction_code;
2983: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2984: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
2985: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2986: l_new_row_num).tax_registration_number :=
2987: tax_line_rec.tax_registration_number;

Line 2985: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2981: l_new_row_num).tax_jurisdiction_code :=
2982: tax_line_rec.tax_jurisdiction_code;
2983: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2984: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
2985: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2986: l_new_row_num).tax_registration_number :=
2987: tax_line_rec.tax_registration_number;
2988: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2989: l_new_row_num).registration_party_type :=

Line 2988: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2984: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
2985: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2986: l_new_row_num).tax_registration_number :=
2987: tax_line_rec.tax_registration_number;
2988: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2989: l_new_row_num).registration_party_type :=
2990: tax_line_rec.registration_party_type;
2991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2992: l_new_row_num).tax_applicability_result_id :=

Line 2991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2987: tax_line_rec.tax_registration_number;
2988: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2989: l_new_row_num).registration_party_type :=
2990: tax_line_rec.registration_party_type;
2991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2992: l_new_row_num).tax_applicability_result_id :=
2993: tax_line_rec.tax_applicability_result_id;
2994: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2995: l_new_row_num).direct_rate_result_id :=

Line 2994: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2990: tax_line_rec.registration_party_type;
2991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2992: l_new_row_num).tax_applicability_result_id :=
2993: tax_line_rec.tax_applicability_result_id;
2994: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2995: l_new_row_num).direct_rate_result_id :=
2996: tax_line_rec.direct_rate_result_id;
2997: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2998: l_new_row_num).rounding_lvl_party_tax_prof_id :=

Line 2997: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2993: tax_line_rec.tax_applicability_result_id;
2994: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2995: l_new_row_num).direct_rate_result_id :=
2996: tax_line_rec.direct_rate_result_id;
2997: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2998: l_new_row_num).rounding_lvl_party_tax_prof_id :=
2999: tax_line_rec.rounding_lvl_party_tax_prof_id;
3000: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3001: l_new_row_num).rounding_lvl_party_type :=

Line 3000: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2996: tax_line_rec.direct_rate_result_id;
2997: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2998: l_new_row_num).rounding_lvl_party_tax_prof_id :=
2999: tax_line_rec.rounding_lvl_party_tax_prof_id;
3000: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3001: l_new_row_num).rounding_lvl_party_type :=
3002: tax_line_rec.rounding_lvl_party_type;
3003: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3004: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;

Line 3003: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2999: tax_line_rec.rounding_lvl_party_tax_prof_id;
3000: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3001: l_new_row_num).rounding_lvl_party_type :=
3002: tax_line_rec.rounding_lvl_party_type;
3003: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3004: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
3005: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3006: l_new_row_num).tax_reg_num_det_result_id :=
3007: tax_line_rec.tax_reg_num_det_result_id;

Line 3005: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3001: l_new_row_num).rounding_lvl_party_type :=
3002: tax_line_rec.rounding_lvl_party_type;
3003: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3004: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
3005: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3006: l_new_row_num).tax_reg_num_det_result_id :=
3007: tax_line_rec.tax_reg_num_det_result_id;
3008:
3009: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3009: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3005: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3006: l_new_row_num).tax_reg_num_det_result_id :=
3007: tax_line_rec.tax_reg_num_det_result_id;
3008:
3009: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3010: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
3011: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3012: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
3013: -- Added for Bug#7185529

Line 3011: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3007: tax_line_rec.tax_reg_num_det_result_id;
3008:
3009: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3010: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
3011: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3012: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
3013: -- Added for Bug#7185529
3014: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3015: l_new_row_num).hq_estb_reg_number := tax_line_rec.hq_estb_reg_number;

Line 3014: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3010: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
3011: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3012: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
3013: -- Added for Bug#7185529
3014: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3015: l_new_row_num).hq_estb_reg_number := tax_line_rec.hq_estb_reg_number;
3016:
3017: IF (x_begin_index IS NULL) THEN
3018: x_begin_index := l_new_row_num;

Line 3024: x_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;

3020: END IF; -- l_tax_tbl_index IS NOT NULL
3021: END LOOP; -- FOR tax_line_rec in get_tax_lines_csr
3022:
3023: IF (x_begin_index IS NOT NULL) THEN
3024: x_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
3025: END IF;
3026:
3027: -- copy transaction info to new tax lines for new tax_lines created here
3028: --