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 399: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST,0);

395:
396: -- initialize local variables
397: --
398: l_new_row_num :=
399: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST,0);
400:
401: l_previous_sum_tax_line_number := NUMBER_DUMMY;
402:
403: --

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

452: --
453: IF tax_line_rec.summary_tax_line_number <> l_previous_sum_tax_line_number
454: THEN
455:
456: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN
457:
458: IF l_previous_sum_tax_line_number <> NUMBER_DUMMY THEN
459:
460: -- calculate rounding difference and adjust rounding difference

Line 466: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

462: --
463: l_rounding_diff := l_previous_summary_tax_amt - l_total_rnd_tax_amt;
464:
465: IF l_rounding_diff <> 0 THEN
466: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
467: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
468: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
469: l_max_line_amt_tax_index).tax_amt;
470: END IF;

Line 468: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

464:
465: IF l_rounding_diff <> 0 THEN
466: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
467: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
468: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
469: l_max_line_amt_tax_index).tax_amt;
470: END IF;
471: END IF; -- l_previous_sum_tax_line_number <> NUMBER_DUMMY
472:

Line 503: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

499: -- simply copy tax amount from summary tax line to detail tax line.
500: --
501: IF tax_line_rec.line_level_action = 'LINE_INFO_TAX_ONLY' THEN
502:
503: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
504: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
505: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
506: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
507: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 505: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

501: IF tax_line_rec.line_level_action = 'LINE_INFO_TAX_ONLY' THEN
502:
503: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
504: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
505: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
506: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
507: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
508: l_new_row_num).tax_only_line_flag := 'Y';
509:

Line 507: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

503: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
504: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
505: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
506: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
507: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
508: l_new_row_num).tax_only_line_flag := 'Y';
509:
510: -- set total rounded tax amount
511: --

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

509:
510: -- set total rounded tax amount
511: --
512: l_total_rnd_tax_amt :=
513: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt;
514:
515: ELSE
516:
517: -- prorate tax_amt with line_amt

Line 521: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

517: -- prorate tax_amt with line_amt
518: --
519: IF l_total_alloc_lines_amt <> 0 THEN
520:
521: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
522: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt *
523: tax_line_rec.line_amt/l_total_alloc_lines_amt;
524:
525: ELSE -- l_total_alloc_lines_amt = 0

Line 554: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

550: 'prorate_imported_sum_tax_lines(-)');
551: END IF;
552: RETURN;
553: ELSE
554: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
555: l_new_row_num).unrounded_tax_amt := 0;
556: END IF; -- sum_tax_line_rec.tax_amt <> 0 or ELSE
557: END IF; -- l_total_alloc_lines_amt <> 0 or ELSE
558:

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

558:
559: -- Round tax amt for 'LINE' Level rounding. 'HEADER' level rounding
560: -- will be done in tail end service as regular detail tax lines.
561: --
562: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN
563:
564: -- round tax_amt
565: --
566: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;

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

562: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN
563:
564: -- round tax_amt
565: --
566: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
567:
568: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
569: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
570: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,

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

564: -- round tax_amt
565: --
566: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
567:
568: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
569: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
570: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
571: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
572: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),

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

566: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
567:
568: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
569: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
570: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
571: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
572: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),
573: tax_line_rec.minimum_accountable_unit,
574: tax_line_rec.precision,

Line 571: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,

567:
568: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
569: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
570: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
571: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
572: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),
573: tax_line_rec.minimum_accountable_unit,
574: tax_line_rec.precision,
575: x_return_status,

Line 597: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

593:
594: -- accumulate rounded tax amount
595: --
596: l_total_rnd_tax_amt := l_total_rnd_tax_amt +
597: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
598: l_new_row_num).tax_amt;
599:
600: -- record l_max_line_amt and l_max_line_amt_tax_index
601: --

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

611: -- difference('Line' Level) for the last summary tax line
612: --
613: IF l_line_level_action = 'CREATE_WITH_TAX' THEN
614:
615: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' AND
616: l_total_alloc_lines_amt IS NOT NULL
617: THEN
618:
619: -- calculate rounding difference and adjust rounding difference

Line 625: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

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

Line 627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

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

Line 678: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

674: -- Bug 10332704
675: -- Need to set the rounding level to Header as the tax amount that Ct is passing
676: -- for the document, not for the line.
677:
678: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
679: l_new_row_num).rounding_level_code := 'HEADER';
680:
681: -- Do proration and adjust rounding difference
682: --

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

682: --
683: IF tax_line_rec.summary_tax_line_number <> l_previous_sum_tax_line_number
684: THEN
685:
686: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' THEN
687:
688: -- New summary tax line number
689: --
690: -- Adjust rounding difference for previous summary tax line for 'Line'

Line 702: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

698: --
699: l_rounding_diff := l_previous_summary_tax_amt - l_total_rnd_tax_amt;
700:
701: IF l_rounding_diff <> 0 THEN
702: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
703: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
704: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
705: l_max_line_amt_tax_index).tax_amt;
706: END IF;

Line 704: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

700:
701: IF l_rounding_diff <> 0 THEN
702: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
703: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
704: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
705: l_max_line_amt_tax_index).tax_amt;
706: END IF;
707: END IF; -- l_previous_sum_tax_line_number <> NUMBER_DUMMY
708:

Line 736: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

732:
733: -- prorate tax_amt with line_amt
734: --
735: IF l_total_trx_lines_amt <> 0 THEN
736: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
737: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt *
738: tax_line_rec.line_amt/l_total_trx_lines_amt;
739: ELSE -- l_total_trx_lines_amt = 0
740:

Line 768: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

764: 'prorate_imported_sum_tax_lines(-)');
765: END IF;
766: RETURN;
767: ELSE
768: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
769: l_new_row_num).unrounded_tax_amt := 0;
770: END IF; -- sum_tax_line_rec.tax_amt <> 0 or ELSE
771: END IF; -- l_total_alloc_lines_amt <> 0 or ELSE
772:

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

772:
773: -- Round tax amt for 'LINE' Level rounding. 'HEADER' level rounding
774: -- will be done in tail end service as regular detail tax lines.
775: --
776: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE'
777: THEN
778:
779: -- round tax_amt
780: --

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

777: THEN
778:
779: -- round tax_amt
780: --
781: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
782:
783: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
784: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
785: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,

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

779: -- round tax_amt
780: --
781: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
782:
783: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
784: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
785: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
786: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
787: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),

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

781: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_id;
782:
783: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
784: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
785: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
786: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
787: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),
788: tax_line_rec.minimum_accountable_unit,
789: tax_line_rec.precision,

Line 786: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,

782:
783: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt :=
784: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
785: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt,
786: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule,
787: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).rounding_rule_code),
788: tax_line_rec.minimum_accountable_unit,
789: tax_line_rec.precision,
790: x_return_status,

Line 812: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

808:
809: -- accumulate rounded tax amount
810: --
811: l_total_rnd_tax_amt := l_total_rnd_tax_amt +
812: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
813: l_new_row_num).tax_amt;
814:
815: -- record l_max_line_amt and l_max_line_amt_tax_index
816: --

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

822: END LOOP; -- tax_line_rec IN get_all_detail_tax_lines_csr
823:
824: -- Adjust rounding difference('Line' Level) for the last summary tax line
825: --
826: IF UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level) = 'LINE' AND
827: l_total_trx_lines_amt IS NOT NULL
828: THEN
829:
830: -- calculate rounding difference and adjust rounding difference

Line 836: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

832: --
833: l_rounding_diff := l_previous_summary_tax_amt - l_total_rnd_tax_amt;
834:
835: IF l_rounding_diff <> 0 THEN
836: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
837: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
838: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
839: l_max_line_amt_tax_index).tax_amt;
840: END IF;

Line 838: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

834:
835: IF l_rounding_diff <> 0 THEN
836: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
837: l_max_line_amt_tax_index).tax_amt := l_rounding_diff +
838: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
839: l_max_line_amt_tax_index).tax_amt;
840: END IF;
841: END IF; -- g_rounding_level = 'Line'
842:

Line 884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

880: END IF;
881:
882: -- Copy tax_amt and unrounded_tax_amt from summary tax line
883: --
884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
885: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
886: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
887: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
888:

Line 886: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

882: -- Copy tax_amt and unrounded_tax_amt from summary tax line
883: --
884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
885: l_new_row_num).tax_amt := tax_line_rec.summary_tax_amt;
886: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
887: l_new_row_num).unrounded_tax_amt := tax_line_rec.summary_tax_amt;
888:
889: -- Set tax_only_line_flag = 'Y' when line_level_action = 'LINE_INFO_TAX_ONLY'
890: --

Line 892: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

888:
889: -- Set tax_only_line_flag = 'Y' when line_level_action = 'LINE_INFO_TAX_ONLY'
890: --
891: IF tax_line_rec.line_level_action = 'LINE_INFO_TAX_ONLY' THEN
892: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
893: l_new_row_num).tax_only_line_flag := 'Y';
894: END IF;
895: END LOOP; -- tax_line_rec IN get_alloc_detail_tax_lines_csr. Bug4262870 End
896:

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

896:
897: -- set l_end_index
898: --
899: IF l_begin_index IS NOT NULL THEN
900: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
901: END IF;
902:
903: --
904: -- populate Process_For_Recovery_Flag

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

1064: -- pull in detail tax lines created from summary tax lines and perform
1065: -- tax registration number determination
1066: --
1067: l_new_row_num :=
1068: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
1069:
1070: FOR imported_tax_line_rec IN get_imported_det_tax_lines_csr LOOP
1071:
1072: -- create a new tax line in g_detail_tax_lines_tbl

Line 1075: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num) :=

1071:
1072: -- create a new tax line in g_detail_tax_lines_tbl
1073: --
1074: l_new_row_num := l_new_row_num + 1;
1075: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num) :=
1076: imported_tax_line_rec;
1077: -- set l_begin_index
1078: --
1079: IF l_begin_index IS NULL THEN

Line 1085: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1081: END IF;
1082:
1083: -- populate hq_estb_party_tax_prof_id
1084: --
1085: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1086: l_new_row_num).hq_estb_party_tax_prof_id :=
1087: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(
1088: p_trx_line_index);
1089: -- get l_def_reg_type and l_reg_rule_flg from tax chche

Line 1091: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1087: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(
1088: p_trx_line_index);
1089: -- get l_def_reg_type and l_reg_rule_flg from tax chche
1090: --
1091: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1092: l_new_row_num).tax_id;
1093: l_def_reg_type := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1094: l_tax_id).def_registr_party_type_code;
1095: l_reg_rule_flg := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

Line 1100: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1096: l_tax_id).registration_type_rule_flag;
1097:
1098: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration(
1099: p_event_class_rec,
1100: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1101: l_new_row_num).tax_regime_code,
1102: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1103: l_new_row_num).tax_id,
1104: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1102: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1098: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration(
1099: p_event_class_rec,
1100: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1101: l_new_row_num).tax_regime_code,
1102: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1103: l_new_row_num).tax_id,
1104: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1105: l_new_row_num).tax,
1106: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1104: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1100: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1101: l_new_row_num).tax_regime_code,
1102: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1103: l_new_row_num).tax_id,
1104: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1105: l_new_row_num).tax,
1106: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1107: l_new_row_num).tax_determine_date,
1108: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1106: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1102: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1103: l_new_row_num).tax_id,
1104: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1105: l_new_row_num).tax,
1106: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1107: l_new_row_num).tax_determine_date,
1108: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1109: l_new_row_num).tax_jurisdiction_code,
1110: l_def_reg_type,

Line 1108: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1104: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1105: l_new_row_num).tax,
1106: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1107: l_new_row_num).tax_determine_date,
1108: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1109: l_new_row_num).tax_jurisdiction_code,
1110: l_def_reg_type,
1111: l_reg_rule_flg,
1112: p_trx_line_index,

Line 1113: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1109: l_new_row_num).tax_jurisdiction_code,
1110: l_def_reg_type,
1111: l_reg_rule_flg,
1112: p_trx_line_index,
1113: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1114: l_new_row_num).tax_registration_number,
1115: l_tax_amt_included_flag,
1116: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1117: l_new_row_num).self_assessed_flag,

Line 1116: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1112: p_trx_line_index,
1113: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1114: l_new_row_num).tax_registration_number,
1115: l_tax_amt_included_flag,
1116: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1117: l_new_row_num).self_assessed_flag,
1118: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1119: l_new_row_num).tax_reg_num_det_result_id,
1120: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1118: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1114: l_new_row_num).tax_registration_number,
1115: l_tax_amt_included_flag,
1116: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1117: l_new_row_num).self_assessed_flag,
1118: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1119: l_new_row_num).tax_reg_num_det_result_id,
1120: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1121: l_new_row_num).rounding_rule_code,
1122: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1120: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1116: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1117: l_new_row_num).self_assessed_flag,
1118: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1119: l_new_row_num).tax_reg_num_det_result_id,
1120: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1121: l_new_row_num).rounding_rule_code,
1122: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1123: l_new_row_num).registration_party_type,
1124: x_return_status);

Line 1122: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1118: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1119: l_new_row_num).tax_reg_num_det_result_id,
1120: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1121: l_new_row_num).rounding_rule_code,
1122: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1123: l_new_row_num).registration_party_type,
1124: x_return_status);
1125:
1126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1141: l_reporting_code_id:= ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(

1137: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1138: END IF;
1139: RETURN;
1140: END IF;
1141: l_reporting_code_id:= ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(
1142: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_reg_num_det_result_id,
1143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).trx_date);
1144: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1145: l_new_row_num).legal_message_trn := l_reporting_code_id;

Line 1142: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_reg_num_det_result_id,

1138: END IF;
1139: RETURN;
1140: END IF;
1141: l_reporting_code_id:= ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(
1142: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_reg_num_det_result_id,
1143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).trx_date);
1144: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1145: l_new_row_num).legal_message_trn := l_reporting_code_id;
1146: -- get registration number for legal entity

Line 1143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).trx_date);

1139: RETURN;
1140: END IF;
1141: l_reporting_code_id:= ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(
1142: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_reg_num_det_result_id,
1143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).trx_date);
1144: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1145: l_new_row_num).legal_message_trn := l_reporting_code_id;
1146: -- get registration number for legal entity
1147: --

Line 1144: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1140: END IF;
1141: l_reporting_code_id:= ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(
1142: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_reg_num_det_result_id,
1143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).trx_date);
1144: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1145: l_new_row_num).legal_message_trn := l_reporting_code_id;
1146: -- get registration number for legal entity
1147: --
1148: ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration(

Line 1175: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1171: -- If tax_amt_included_flag from summary tax line is null, get
1172: -- l_tax_amt_included_flag with tax registration and populate it onto
1173: -- detail tax line
1174: --
1175: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1176: l_new_row_num).tax_amt_included_flag IS NULL THEN
1177: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1178: l_new_row_num).tax_amt_included_flag := l_tax_amt_included_flag;
1179:

Line 1177: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1173: -- detail tax line
1174: --
1175: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1176: l_new_row_num).tax_amt_included_flag IS NULL THEN
1177: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1178: l_new_row_num).tax_amt_included_flag := l_tax_amt_included_flag;
1179:
1180: END IF;
1181:

Line 1184: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1180: END IF;
1181:
1182: -- calculate taxable basis for imported tax lines
1183: --
1184: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1185: l_new_row_num).tax_rate;
1186: IF l_tax_rate <> 0 THEN
1187:
1188: -- Bug 3518261: Calculate taxable_amt for imported tax lines

Line 1191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1187:
1188: -- Bug 3518261: Calculate taxable_amt for imported tax lines
1189: --
1190:
1191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1192: l_new_row_num).unrounded_taxable_amt:=
1193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1194: l_new_row_num).unrounded_tax_amt/l_tax_rate*100;
1195:

Line 1193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1189: --
1190:
1191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1192: l_new_row_num).unrounded_taxable_amt:=
1193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1194: l_new_row_num).unrounded_tax_amt/l_tax_rate*100;
1195:
1196: ELSE -- l_tax_rate = 0
1197:

Line 1198: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1194: l_new_row_num).unrounded_tax_amt/l_tax_rate*100;
1195:
1196: ELSE -- l_tax_rate = 0
1197:
1198: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1199: l_new_row_num).unrounded_tax_amt = 0 THEN
1200: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1201: l_new_row_num).unrounded_taxable_amt :=
1202: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);

Line 1200: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1196: ELSE -- l_tax_rate = 0
1197:
1198: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1199: l_new_row_num).unrounded_tax_amt = 0 THEN
1200: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1201: l_new_row_num).unrounded_taxable_amt :=
1202: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
1203:
1204: ELSE

Line 1222: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

1218:
1219: FND_MESSAGE.SET_NAME('ZX','ZX_IMP_TAX_RATE_AMT_MISMATCH');
1220:
1221: -- FND_MSG_PUB.Add;
1222: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1223: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1224: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1225: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1226:

Line 1224: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

1220:
1221: -- FND_MSG_PUB.Add;
1222: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1223: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1224: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1225: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1226:
1227: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1228:

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

1223: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1224: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1225: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1226:
1227: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1228:
1229: RETURN;
1230: END IF;
1231: END IF; -- l_tax_rate <> 0 OR ELSE

Line 1235: OPEN get_key_columns_cur(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_regime_code,

1231: END IF; -- l_tax_rate <> 0 OR ELSE
1232:
1233: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index) IS NOT NULL
1234: THEN
1235: OPEN get_key_columns_cur(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_regime_code,
1236: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax,
1237: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_apportionment_line_number, 1)
1238: );
1239:

Line 1236: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax,

1232:
1233: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index) IS NOT NULL
1234: THEN
1235: OPEN get_key_columns_cur(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_regime_code,
1236: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax,
1237: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_apportionment_line_number, 1)
1238: );
1239:
1240: FETCH get_key_columns_cur INTO l_adjusted_doc_tax_line_id;

Line 1237: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_apportionment_line_number, 1)

1233: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index) IS NOT NULL
1234: THEN
1235: OPEN get_key_columns_cur(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_regime_code,
1236: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax,
1237: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_apportionment_line_number, 1)
1238: );
1239:
1240: FETCH get_key_columns_cur INTO l_adjusted_doc_tax_line_id;
1241:

Line 1243: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).adjusted_doc_tax_line_id := l_adjusted_doc_tax_line_id;

1239:
1240: FETCH get_key_columns_cur INTO l_adjusted_doc_tax_line_id;
1241:
1242: IF get_key_columns_cur%FOUND THEN
1243: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).adjusted_doc_tax_line_id := l_adjusted_doc_tax_line_id;
1244: IF (g_level_event >= g_current_runtime_level ) THEN
1245: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1246: 'l_adjusted_doc_tax_line_id: ' || l_adjusted_doc_tax_line_id);
1247: END IF;

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

1254: -- set l_end_index
1255: --
1256: IF l_begin_index IS NOT NULL THEN
1257:
1258: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
1259:
1260: -- delete the pulled-in tax lines from zx_detail_tax_lines_gt
1261: --
1262: DELETE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */

Line 1317: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_only_line_flag,'N') <> 'Y' THEN

1313: FOR i IN NVL(l_begin_index, 0) .. NVL(l_end_index, -1) LOOP
1314: -- No need to set the orig_tax_amt column for Tax Only Line because the Line Amount
1315: -- of the psuedo trx line is equal to the Tax amount of the Tax Only line
1316: -- Added if condition for Bug#14020891
1317: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_only_line_flag,'N') <> 'Y' THEN
1318:
1319: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate;
1320:
1321: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN

Line 1319: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate;

1315: -- of the psuedo trx line is equal to the Tax amount of the Tax Only line
1316: -- Added if condition for Bug#14020891
1317: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_only_line_flag,'N') <> 'Y' THEN
1318:
1319: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate;
1320:
1321: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN
1322: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1323: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);

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

1317: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_only_line_flag,'N') <> 'Y' THEN
1318:
1319: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate;
1320:
1321: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN
1322: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1323: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1324: ELSE
1325: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=

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

1318:
1319: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate;
1320:
1321: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN
1322: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1323: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1324: ELSE
1325: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1326: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/100;

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

1319: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate;
1320:
1321: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN
1322: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1323: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1324: ELSE
1325: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1326: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/100;
1327: END IF;

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

1321: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt_included_flag = 'Y' THEN
1322: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1323: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1324: ELSE
1325: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1326: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/100;
1327: END IF;
1328:
1329: END IF;

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

1322: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1323: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/(100+l_tax_rate);
1324: ELSE
1325: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).orig_tax_amt :=
1326: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).line_amt * l_tax_rate/100;
1327: END IF;
1328:
1329: END IF;
1330: END LOOP;

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

1332:
1333: -- set l_begin_index_additional
1334: --
1335: l_begin_index_additional :=
1336: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0) + 1;
1337:
1338: /* Bug 5688340: Rearranged the order of conditions in IF statement (ie. pulled
1339: adjusted_doc is NOT NULL condition before applied_from).
1340: The receipt application in AR causes a tax adjustment to be created in eBTax,

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

1429: AND p_event_class_rec.perf_addnl_appl_for_imprt_flag = 'Y')
1430: THEN
1431:
1432: IF p_event_class_rec.process_for_applicability_flag = 'Y' AND
1433: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg, 'Y') = 'Y' AND
1434: -- for TM, check source_process_for_appl_flag to determine
1435: -- whether tax needs to be calcualted or not.
1436: NVL(p_event_class_rec.source_process_for_appl_flag, 'Y') = 'Y'
1437: THEN

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

1450: -- Else (for location based) call tax applicability.
1451:
1452: IF (g_level_statement >= g_current_runtime_level ) THEN
1453: FND_LOG.STRING(g_level_statement,
1454: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1455: 'template_usage_code = '||p_event_class_rec.template_usage_code);
1456: END IF;
1457:
1458: IF p_event_class_rec.template_usage_code = 'TAX_RULES'

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

1480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1481: 'RETURN_STATUS = ' || x_return_status);
1482: FND_LOG.STRING(g_level_unexpected,
1483: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1484: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)');
1485: END IF;
1486: RETURN;
1487: END IF;
1488:

Line 1562: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1558: p_trx_line_index) ='CREATE_WITH_TAX'
1559: THEN
1560: FOR i IN NVL(l_begin_index_additional, 0) .. NVL(l_end_index_additional, -1)
1561: LOOP
1562: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1563: i).self_assessed_flag := 'Y';
1564: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1565: i).overridden_flag := 'Y';
1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1564: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1560: FOR i IN NVL(l_begin_index_additional, 0) .. NVL(l_end_index_additional, -1)
1561: LOOP
1562: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1563: i).self_assessed_flag := 'Y';
1564: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1565: i).overridden_flag := 'Y';
1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1567: i).orig_self_assessed_flag := 'X';
1568: END LOOP;

Line 1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1562: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1563: i).self_assessed_flag := 'Y';
1564: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1565: i).overridden_flag := 'Y';
1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1567: i).orig_self_assessed_flag := 'X';
1568: END LOOP;
1569: END IF;
1570:

Line 1947: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_id

1943: p_tax_class,
1944: l_tax_rate_rec,
1945: x_return_status,
1946: l_error_buffer);
1947: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_id
1948: := l_tax_rate_rec.tax_rate_id;
1949:
1950: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1951: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1985: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1981: /*
1982: * populate in ZX_TDS_TAX_LINES_POPU_PKG
1983: *
1984: * SELECT zx_lines_s.NEXTVAL INTO
1985: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1986: * p_new_row_num).tax_line_id from dual;
1987: */
1988:
1989: -- populate tax_regime_id, tax_id, tax_status_id, tax_rate_id

Line 1991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1987: */
1988:
1989: -- populate tax_regime_id, tax_id, tax_status_id, tax_rate_id
1990: --
1991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1992: p_new_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
1993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1994: p_new_row_num).tax_id := l_tax_rec.tax_id;
1995: -- Bug 12688194 Starts

Line 1993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1989: -- populate tax_regime_id, tax_id, tax_status_id, tax_rate_id
1990: --
1991: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1992: p_new_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
1993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1994: p_new_row_num).tax_id := l_tax_rec.tax_id;
1995: -- Bug 12688194 Starts
1996: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1997: p_new_row_num).Place_Of_Supply_Type_Code := l_tax_rec.Def_Place_Of_Supply_Type_Code;

Line 1996: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1992: p_new_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
1993: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1994: p_new_row_num).tax_id := l_tax_rec.tax_id;
1995: -- Bug 12688194 Starts
1996: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1997: p_new_row_num).Place_Of_Supply_Type_Code := l_tax_rec.Def_Place_Of_Supply_Type_Code;
1998: -- Bug 12688194 Ends
1999:
2000: -- bug 5077691: populate legal_reporting_status

Line 2002: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1998: -- Bug 12688194 Ends
1999:
2000: -- bug 5077691: populate legal_reporting_status
2001: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
2002: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2003: p_new_row_num).legal_reporting_status :=
2004: l_tax_rec.legal_reporting_status_def_val;
2005: END IF;
2006:

Line 2007: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2003: p_new_row_num).legal_reporting_status :=
2004: l_tax_rec.legal_reporting_status_def_val;
2005: END IF;
2006:
2007: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2008: p_new_row_num).tax_jurisdiction_id :=
2009: l_tax_jur_rec.tax_jurisdiction_id;
2010: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2011: p_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;

Line 2010: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2006:
2007: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2008: p_new_row_num).tax_jurisdiction_id :=
2009: l_tax_jur_rec.tax_jurisdiction_id;
2010: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2011: p_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
2012:
2013: -- populate data from summary tax line
2014: --

Line 2015: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2011: p_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
2012:
2013: -- populate data from summary tax line
2014: --
2015: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2016: p_new_row_num).tax_regime_code := p_tax_line_rec.tax_regime_code;
2017: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2018: p_new_row_num).tax := p_tax_line_rec.tax;
2019: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2017: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2013: -- populate data from summary tax line
2014: --
2015: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2016: p_new_row_num).tax_regime_code := p_tax_line_rec.tax_regime_code;
2017: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2018: p_new_row_num).tax := p_tax_line_rec.tax;
2019: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2020: p_new_row_num).tax_status_code := p_tax_line_rec.tax_status_code;
2021: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2019: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2015: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2016: p_new_row_num).tax_regime_code := p_tax_line_rec.tax_regime_code;
2017: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2018: p_new_row_num).tax := p_tax_line_rec.tax;
2019: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2020: p_new_row_num).tax_status_code := p_tax_line_rec.tax_status_code;
2021: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2022: p_new_row_num).tax_rate_code := p_tax_line_rec.tax_rate_code;
2023: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2021: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2017: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2018: p_new_row_num).tax := p_tax_line_rec.tax;
2019: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2020: p_new_row_num).tax_status_code := p_tax_line_rec.tax_status_code;
2021: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2022: p_new_row_num).tax_rate_code := p_tax_line_rec.tax_rate_code;
2023: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2024: p_new_row_num).tax_rate := p_tax_line_rec.tax_rate;
2025:

Line 2023: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2019: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2020: p_new_row_num).tax_status_code := p_tax_line_rec.tax_status_code;
2021: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2022: p_new_row_num).tax_rate_code := p_tax_line_rec.tax_rate_code;
2023: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2024: p_new_row_num).tax_rate := p_tax_line_rec.tax_rate;
2025:
2026: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2027: p_new_row_num).tax_jurisdiction_code :=

Line 2026: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2022: p_new_row_num).tax_rate_code := p_tax_line_rec.tax_rate_code;
2023: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2024: p_new_row_num).tax_rate := p_tax_line_rec.tax_rate;
2025:
2026: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2027: p_new_row_num).tax_jurisdiction_code :=
2028: p_tax_line_rec.tax_jurisdiction_code;
2029: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2030: p_new_row_num).tax_amt_included_flag :=

Line 2029: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2025:
2026: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2027: p_new_row_num).tax_jurisdiction_code :=
2028: p_tax_line_rec.tax_jurisdiction_code;
2029: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2030: p_new_row_num).tax_amt_included_flag :=
2031: p_tax_line_rec.tax_amt_included_flag;
2032: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2033: p_new_row_num).tax_exception_id := p_tax_line_rec.tax_exception_id;

Line 2032: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2028: p_tax_line_rec.tax_jurisdiction_code;
2029: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2030: p_new_row_num).tax_amt_included_flag :=
2031: p_tax_line_rec.tax_amt_included_flag;
2032: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2033: p_new_row_num).tax_exception_id := p_tax_line_rec.tax_exception_id;
2034: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2035: p_new_row_num).tax_exemption_id := p_tax_line_rec.tax_exemption_id;
2036: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2034: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2030: p_new_row_num).tax_amt_included_flag :=
2031: p_tax_line_rec.tax_amt_included_flag;
2032: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2033: p_new_row_num).tax_exception_id := p_tax_line_rec.tax_exception_id;
2034: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2035: p_new_row_num).tax_exemption_id := p_tax_line_rec.tax_exemption_id;
2036: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2037: p_new_row_num).exempt_reason_code := p_tax_line_rec.exempt_reason_code;
2038: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2036: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2032: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2033: p_new_row_num).tax_exception_id := p_tax_line_rec.tax_exception_id;
2034: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2035: p_new_row_num).tax_exemption_id := p_tax_line_rec.tax_exemption_id;
2036: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2037: p_new_row_num).exempt_reason_code := p_tax_line_rec.exempt_reason_code;
2038: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2039: p_new_row_num).exempt_certificate_number :=
2040: p_tax_line_rec.exempt_certificate_number;

Line 2038: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2034: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2035: p_new_row_num).tax_exemption_id := p_tax_line_rec.tax_exemption_id;
2036: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2037: p_new_row_num).exempt_reason_code := p_tax_line_rec.exempt_reason_code;
2038: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2039: p_new_row_num).exempt_certificate_number :=
2040: p_tax_line_rec.exempt_certificate_number;
2041:
2042: -- If the value of p_event_class_rec.tax_recovery_flag is 'N',

Line 2050: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2046: /*
2047: * call populate_recovery_flg in ZX_TDS_TAX_LINES_POPU_PKG instead
2048: *
2049: * IF NVL(p_event_class_rec.tax_recovery_flag, 'N') = 'N' THEN
2050: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2051: * p_new_row_num).process_for_recovery_flag := 'N';
2052: * ELSE
2053: * IF NVL(l_tax_rec.reporting_only_flag, 'N') <> 'Y' THEN
2054: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2054: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2050: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2051: * p_new_row_num).process_for_recovery_flag := 'N';
2052: * ELSE
2053: * IF NVL(l_tax_rec.reporting_only_flag, 'N') <> 'Y' THEN
2054: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2055: * p_new_row_num).process_for_recovery_flag := 'Y';
2056: * ELSE
2057: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2058: * p_new_row_num).process_for_recovery_flag := 'N';

Line 2057: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2053: * IF NVL(l_tax_rec.reporting_only_flag, 'N') <> 'Y' THEN
2054: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2055: * p_new_row_num).process_for_recovery_flag := 'Y';
2056: * ELSE
2057: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2058: * p_new_row_num).process_for_recovery_flag := 'N';
2059: * END IF;
2060: * END IF;
2061: */

Line 2065: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2061: */
2062:
2063: -- populate rounding_lvl_party_tax_prof_id and rounding_level_code
2064: --
2065: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2066: p_new_row_num).rounding_lvl_party_tax_prof_id :=
2067: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
2068: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2069: p_new_row_num).rounding_lvl_party_type :=

Line 2067: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;

2063: -- populate rounding_lvl_party_tax_prof_id and rounding_level_code
2064: --
2065: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2066: p_new_row_num).rounding_lvl_party_tax_prof_id :=
2067: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
2068: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2069: p_new_row_num).rounding_lvl_party_type :=
2070: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
2071: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2068: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2064: --
2065: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2066: p_new_row_num).rounding_lvl_party_tax_prof_id :=
2067: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
2068: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2069: p_new_row_num).rounding_lvl_party_type :=
2070: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
2071: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2072: p_new_row_num).rounding_level_code :=

Line 2070: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;

2066: p_new_row_num).rounding_lvl_party_tax_prof_id :=
2067: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
2068: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2069: p_new_row_num).rounding_lvl_party_type :=
2070: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
2071: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2072: p_new_row_num).rounding_level_code :=
2073: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;
2074:

Line 2071: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2067: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rnd_lvl_party_tax_prof_id;
2068: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2069: p_new_row_num).rounding_lvl_party_type :=
2070: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
2071: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2072: p_new_row_num).rounding_level_code :=
2073: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;
2074:
2075: -- populate tax dates

Line 2073: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;

2069: p_new_row_num).rounding_lvl_party_type :=
2070: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_lvl_party_type;
2071: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2072: p_new_row_num).rounding_level_code :=
2073: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;
2074:
2075: -- populate tax dates
2076: --
2077: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2077: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2073: ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_level;
2074:
2075: -- populate tax dates
2076: --
2077: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2078: p_new_row_num).tax_date := l_tax_date;
2079: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2080: p_new_row_num).tax_determine_date := l_tax_determine_date;
2081: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2079: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2075: -- populate tax dates
2076: --
2077: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2078: p_new_row_num).tax_date := l_tax_date;
2079: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2080: p_new_row_num).tax_determine_date := l_tax_determine_date;
2081: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2082: p_new_row_num).tax_point_date := l_tax_point_date;
2083:

Line 2081: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2077: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2078: p_new_row_num).tax_date := l_tax_date;
2079: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2080: p_new_row_num).tax_determine_date := l_tax_determine_date;
2081: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2082: p_new_row_num).tax_point_date := l_tax_point_date;
2083:
2084: -- populate the tax_currency_conversion_date as this field is mandatroy
2085: -- incase trx_currency and tax_currency are different. (8322086)

Line 2087: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2083:
2084: -- populate the tax_currency_conversion_date as this field is mandatroy
2085: -- incase trx_currency and tax_currency are different. (8322086)
2086: --
2087: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2088: p_new_row_num).tax_currency_conversion_date := l_tax_determine_date;
2089:
2090: -- bug 3282018: set manually_entered_flag='Y', last_manual_entry='TAX_AMOUNT'
2091: --

Line 2092: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2088: p_new_row_num).tax_currency_conversion_date := l_tax_determine_date;
2089:
2090: -- bug 3282018: set manually_entered_flag='Y', last_manual_entry='TAX_AMOUNT'
2091: --
2092: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2093: p_new_row_num).manually_entered_flag := 'Y';
2094: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2095: p_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2096:

Line 2094: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2090: -- bug 3282018: set manually_entered_flag='Y', last_manual_entry='TAX_AMOUNT'
2091: --
2092: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2093: p_new_row_num).manually_entered_flag := 'Y';
2094: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2095: p_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2096:
2097: -- set self_assesses_flag = 'N' for all detail tax lines created from summary
2098: -- tax lines

Line 2100: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2096:
2097: -- set self_assesses_flag = 'N' for all detail tax lines created from summary
2098: -- tax lines
2099: --
2100: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2101: p_new_row_num).self_assessed_flag := 'N';
2102:
2103: -- set proration_code
2104: --

Line 2105: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2101: p_new_row_num).self_assessed_flag := 'N';
2102:
2103: -- set proration_code
2104: --
2105: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2106: p_new_row_num).proration_code := 'REGULAR_IMPORT';
2107:
2108: -- populate mandatory columns
2109: --

Line 2110: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2106: p_new_row_num).proration_code := 'REGULAR_IMPORT';
2107:
2108: -- populate mandatory columns
2109: --
2110: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2111: p_new_row_num).internal_organization_id :=
2112: p_tax_line_rec.internal_organization_id;
2113: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2114: p_new_row_num).application_id := p_event_class_rec.application_id;

Line 2113: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2109: --
2110: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2111: p_new_row_num).internal_organization_id :=
2112: p_tax_line_rec.internal_organization_id;
2113: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2114: p_new_row_num).application_id := p_event_class_rec.application_id;
2115: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2116: p_new_row_num).entity_code := p_event_class_rec.entity_code;
2117: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2115: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2111: p_new_row_num).internal_organization_id :=
2112: p_tax_line_rec.internal_organization_id;
2113: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2114: p_new_row_num).application_id := p_event_class_rec.application_id;
2115: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2116: p_new_row_num).entity_code := p_event_class_rec.entity_code;
2117: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2118: p_new_row_num).event_class_code := p_event_class_rec.event_class_code;
2119: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2117: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2113: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2114: p_new_row_num).application_id := p_event_class_rec.application_id;
2115: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2116: p_new_row_num).entity_code := p_event_class_rec.entity_code;
2117: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2118: p_new_row_num).event_class_code := p_event_class_rec.event_class_code;
2119: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2120: p_new_row_num).event_type_code := p_event_class_rec.event_type_code;
2121: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2119: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2115: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2116: p_new_row_num).entity_code := p_event_class_rec.entity_code;
2117: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2118: p_new_row_num).event_class_code := p_event_class_rec.event_class_code;
2119: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2120: p_new_row_num).event_type_code := p_event_class_rec.event_type_code;
2121: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2122: p_new_row_num).trx_id := p_event_class_rec.trx_id;
2123: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2121: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2117: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2118: p_new_row_num).event_class_code := p_event_class_rec.event_class_code;
2119: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2120: p_new_row_num).event_type_code := p_event_class_rec.event_type_code;
2121: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2122: p_new_row_num).trx_id := p_event_class_rec.trx_id;
2123: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2124: p_new_row_num).trx_line_id := p_tax_line_rec.trx_line_id;
2125: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2123: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2119: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2120: p_new_row_num).event_type_code := p_event_class_rec.event_type_code;
2121: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2122: p_new_row_num).trx_id := p_event_class_rec.trx_id;
2123: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2124: p_new_row_num).trx_line_id := p_tax_line_rec.trx_line_id;
2125: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2126: p_new_row_num).trx_level_type := p_tax_line_rec.trx_level_type;
2127:

Line 2125: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2121: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2122: p_new_row_num).trx_id := p_event_class_rec.trx_id;
2123: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2124: p_new_row_num).trx_line_id := p_tax_line_rec.trx_line_id;
2125: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2126: p_new_row_num).trx_level_type := p_tax_line_rec.trx_level_type;
2127:
2128: -- Bug#457200- populate content_owner_id
2129: --

Line 2130: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2126: p_new_row_num).trx_level_type := p_tax_line_rec.trx_level_type;
2127:
2128: -- Bug#457200- populate content_owner_id
2129: --
2130: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2131: p_new_row_num).content_owner_id := p_event_class_rec.first_pty_org_id;
2132:
2133: -- populate interface_tax_line_id, interface_entity_code for AR import service
2134: --

Line 2135: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2131: p_new_row_num).content_owner_id := p_event_class_rec.first_pty_org_id;
2132:
2133: -- populate interface_tax_line_id, interface_entity_code for AR import service
2134: --
2135: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2136: p_new_row_num).interface_tax_line_id := p_tax_line_rec.interface_tax_line_id;
2137: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2138: p_new_row_num).interface_entity_code := p_tax_line_rec.interface_entity_code;
2139:

Line 2137: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2133: -- populate interface_tax_line_id, interface_entity_code for AR import service
2134: --
2135: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2136: p_new_row_num).interface_tax_line_id := p_tax_line_rec.interface_tax_line_id;
2137: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2138: p_new_row_num).interface_entity_code := p_tax_line_rec.interface_entity_code;
2139:
2140: -- Bug 7117340 -- DFF ER
2141: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2141: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2137: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2138: p_new_row_num).interface_entity_code := p_tax_line_rec.interface_entity_code;
2139:
2140: -- Bug 7117340 -- DFF ER
2141: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2142: p_new_row_num).attribute1 := p_tax_line_rec.attribute1;
2143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2144: p_new_row_num).attribute2 := p_tax_line_rec.attribute2;
2145: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2139:
2140: -- Bug 7117340 -- DFF ER
2141: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2142: p_new_row_num).attribute1 := p_tax_line_rec.attribute1;
2143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2144: p_new_row_num).attribute2 := p_tax_line_rec.attribute2;
2145: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2146: p_new_row_num).attribute3 := p_tax_line_rec.attribute3;
2147: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2145: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2141: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2142: p_new_row_num).attribute1 := p_tax_line_rec.attribute1;
2143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2144: p_new_row_num).attribute2 := p_tax_line_rec.attribute2;
2145: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2146: p_new_row_num).attribute3 := p_tax_line_rec.attribute3;
2147: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2148: p_new_row_num).attribute4 := p_tax_line_rec.attribute4;
2149: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2147: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2143: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2144: p_new_row_num).attribute2 := p_tax_line_rec.attribute2;
2145: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2146: p_new_row_num).attribute3 := p_tax_line_rec.attribute3;
2147: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2148: p_new_row_num).attribute4 := p_tax_line_rec.attribute4;
2149: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2150: p_new_row_num).attribute5 := p_tax_line_rec.attribute5;
2151: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2149: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2145: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2146: p_new_row_num).attribute3 := p_tax_line_rec.attribute3;
2147: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2148: p_new_row_num).attribute4 := p_tax_line_rec.attribute4;
2149: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2150: p_new_row_num).attribute5 := p_tax_line_rec.attribute5;
2151: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2152: p_new_row_num).attribute6 := p_tax_line_rec.attribute6;
2153: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2151: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2147: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2148: p_new_row_num).attribute4 := p_tax_line_rec.attribute4;
2149: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2150: p_new_row_num).attribute5 := p_tax_line_rec.attribute5;
2151: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2152: p_new_row_num).attribute6 := p_tax_line_rec.attribute6;
2153: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2154: p_new_row_num).attribute7 := p_tax_line_rec.attribute7;
2155: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2153: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2149: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2150: p_new_row_num).attribute5 := p_tax_line_rec.attribute5;
2151: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2152: p_new_row_num).attribute6 := p_tax_line_rec.attribute6;
2153: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2154: p_new_row_num).attribute7 := p_tax_line_rec.attribute7;
2155: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2156: p_new_row_num).attribute8 := p_tax_line_rec.attribute8;
2157: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2155: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2151: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2152: p_new_row_num).attribute6 := p_tax_line_rec.attribute6;
2153: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2154: p_new_row_num).attribute7 := p_tax_line_rec.attribute7;
2155: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2156: p_new_row_num).attribute8 := p_tax_line_rec.attribute8;
2157: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2158: p_new_row_num).attribute9 := p_tax_line_rec.attribute9;
2159: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2157: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2153: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2154: p_new_row_num).attribute7 := p_tax_line_rec.attribute7;
2155: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2156: p_new_row_num).attribute8 := p_tax_line_rec.attribute8;
2157: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2158: p_new_row_num).attribute9 := p_tax_line_rec.attribute9;
2159: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2160: p_new_row_num).attribute10 := p_tax_line_rec.attribute10;
2161: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2159: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2155: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2156: p_new_row_num).attribute8 := p_tax_line_rec.attribute8;
2157: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2158: p_new_row_num).attribute9 := p_tax_line_rec.attribute9;
2159: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2160: p_new_row_num).attribute10 := p_tax_line_rec.attribute10;
2161: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2162: p_new_row_num).attribute11 := p_tax_line_rec.attribute11;
2163: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2161: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2157: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2158: p_new_row_num).attribute9 := p_tax_line_rec.attribute9;
2159: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2160: p_new_row_num).attribute10 := p_tax_line_rec.attribute10;
2161: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2162: p_new_row_num).attribute11 := p_tax_line_rec.attribute11;
2163: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2164: p_new_row_num).attribute12 := p_tax_line_rec.attribute12;
2165: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2163: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2159: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2160: p_new_row_num).attribute10 := p_tax_line_rec.attribute10;
2161: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2162: p_new_row_num).attribute11 := p_tax_line_rec.attribute11;
2163: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2164: p_new_row_num).attribute12 := p_tax_line_rec.attribute12;
2165: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2166: p_new_row_num).attribute13 := p_tax_line_rec.attribute13;
2167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2165: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2161: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2162: p_new_row_num).attribute11 := p_tax_line_rec.attribute11;
2163: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2164: p_new_row_num).attribute12 := p_tax_line_rec.attribute12;
2165: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2166: p_new_row_num).attribute13 := p_tax_line_rec.attribute13;
2167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2168: p_new_row_num).attribute14 := p_tax_line_rec.attribute14;
2169: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2163: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2164: p_new_row_num).attribute12 := p_tax_line_rec.attribute12;
2165: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2166: p_new_row_num).attribute13 := p_tax_line_rec.attribute13;
2167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2168: p_new_row_num).attribute14 := p_tax_line_rec.attribute14;
2169: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2170: p_new_row_num).attribute15 := p_tax_line_rec.attribute15;
2171: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2169: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2165: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2166: p_new_row_num).attribute13 := p_tax_line_rec.attribute13;
2167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2168: p_new_row_num).attribute14 := p_tax_line_rec.attribute14;
2169: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2170: p_new_row_num).attribute15 := p_tax_line_rec.attribute15;
2171: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2172: p_new_row_num).attribute_category:= p_tax_line_rec.attribute_category;
2173:

Line 2171: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2168: p_new_row_num).attribute14 := p_tax_line_rec.attribute14;
2169: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2170: p_new_row_num).attribute15 := p_tax_line_rec.attribute15;
2171: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2172: p_new_row_num).attribute_category:= p_tax_line_rec.attribute_category;
2173:
2174:
2175: /*

Line 2178: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2174:
2175: /*
2176: * populate WHO columns in ZX_TDS_TAX_LINES_POPU_PKG
2177: *
2178: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2179: * p_new_row_num).created_by := fnd_global.user_id;
2180: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2181: * p_new_row_num).creation_date := sysdate;
2182: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2180: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2176: * populate WHO columns in ZX_TDS_TAX_LINES_POPU_PKG
2177: *
2178: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2179: * p_new_row_num).created_by := fnd_global.user_id;
2180: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2181: * p_new_row_num).creation_date := sysdate;
2182: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2183: * p_new_row_num).last_updated_by := fnd_global.user_id;
2184: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2182: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2178: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2179: * p_new_row_num).created_by := fnd_global.user_id;
2180: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2181: * p_new_row_num).creation_date := sysdate;
2182: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2183: * p_new_row_num).last_updated_by := fnd_global.user_id;
2184: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2185: * p_new_row_num).last_update_date := sysdate;
2186: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2184: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2180: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2181: * p_new_row_num).creation_date := sysdate;
2182: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2183: * p_new_row_num).last_updated_by := fnd_global.user_id;
2184: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2185: * p_new_row_num).last_update_date := sysdate;
2186: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2187: * p_new_row_num).last_update_login := fnd_global.login_id;
2188: */

Line 2186: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2182: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2183: * p_new_row_num).last_updated_by := fnd_global.user_id;
2184: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2185: * p_new_row_num).last_update_date := sysdate;
2186: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2187: * p_new_row_num).last_update_login := fnd_global.login_id;
2188: */
2189:
2190: --Bug 13724999

Line 2192: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_type := 'PERCENTAGE';

2188: */
2189:
2190: --Bug 13724999
2191: IF (l_tax_rate_rec.percentage_rate IS NOT NULL and l_tax_rate_rec.quantity_rate IS NULL) THEN
2192: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_type := 'PERCENTAGE';
2193: ELSIF (l_tax_rate_rec.quantity_rate IS NOT NULL and l_tax_rate_rec.percentage_rate IS NULL) THEN
2194: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_type := 'QUANTITY';
2195: END IF;
2196: --Bug 137249999

Line 2194: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_type := 'QUANTITY';

2190: --Bug 13724999
2191: IF (l_tax_rate_rec.percentage_rate IS NOT NULL and l_tax_rate_rec.quantity_rate IS NULL) THEN
2192: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_type := 'PERCENTAGE';
2193: ELSIF (l_tax_rate_rec.quantity_rate IS NOT NULL and l_tax_rate_rec.percentage_rate IS NULL) THEN
2194: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_rate_type := 'QUANTITY';
2195: END IF;
2196: --Bug 137249999
2197:
2198: IF (g_level_event >= g_current_runtime_level ) THEN

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

2296: -- initialize local variables
2297: --
2298: -- bug fix 4867933 begin
2299: -- l_new_row_num := NVL(x_end_index, 0);
2300: l_new_row_num := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
2301: l_orig_begin_index := x_begin_index;
2302: l_orig_end_index := x_end_index;
2303:
2304: FOR tax_line_rec in get_tax_lines_csr LOOP

Line 2324: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2320: l_new_row_num := l_new_row_num +1;
2321:
2322: -- populate tax related information from tax_line_rec
2323: --
2324: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2325: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
2326: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2327: l_new_row_num).tax := tax_line_rec.tax;
2328: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2326: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2322: -- populate tax related information from tax_line_rec
2323: --
2324: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2325: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
2326: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2327: l_new_row_num).tax := tax_line_rec.tax;
2328: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2329: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
2330:

Line 2328: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2324: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2325: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
2326: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2327: l_new_row_num).tax := tax_line_rec.tax;
2328: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2329: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
2330:
2331: -- validate and populate tax_regime_id
2332: --

Line 2356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2352: END IF;
2353: RETURN;
2354: END IF;
2355:
2356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2357: l_new_row_num).tax_regime_id :=
2358: l_tax_regime_rec.tax_regime_id;
2359:
2360: -- validate and populate tax_id

Line 2386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2382: END IF;
2383: RETURN;
2384: END IF;
2385:
2386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2387: l_new_row_num).tax_id := l_tax_rec.tax_id;
2388:
2389: -- bug 5077691: populate legal_reporting_status
2390: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN

Line 2391: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2387: l_new_row_num).tax_id := l_tax_rec.tax_id;
2388:
2389: -- bug 5077691: populate legal_reporting_status
2390: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
2391: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2392: l_new_row_num).legal_reporting_status :=
2393: l_tax_rec.legal_reporting_status_def_val;
2394: END IF;
2395:

Line 2428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2424: END IF;
2425: RETURN;
2426: END IF;
2427:
2428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2429: l_new_row_num).tax_jurisdiction_id :=
2430: l_tax_jur_rec.tax_jurisdiction_id;
2431: END IF;
2432:

Line 2460: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2456: END IF;
2457: RETURN;
2458: END IF;
2459:
2460: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2461: l_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
2462:
2463: -- populate taxable_basis_formula and tax_calculation_formula
2464: --

Line 2465: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2461: l_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
2462:
2463: -- populate taxable_basis_formula and tax_calculation_formula
2464: --
2465: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2466: l_new_row_num).taxable_basis_formula :=
2467: tax_line_rec.taxable_basis_formula;
2468: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2469: l_new_row_num).tax_calculation_formula :=

Line 2468: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2464: --
2465: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2466: l_new_row_num).taxable_basis_formula :=
2467: tax_line_rec.taxable_basis_formula;
2468: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2469: l_new_row_num).tax_calculation_formula :=
2470: tax_line_rec.tax_calculation_formula;
2471:
2472: -- 1. If applied_amt_handling_flag ='P', populate tax rate percentage from

Line 2481: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2477:
2478: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2479: tax_line_rec.tax_id).applied_amt_handling_flag = 'P' THEN
2480:
2481: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2482: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2483: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2484: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2485: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2483: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2479: tax_line_rec.tax_id).applied_amt_handling_flag = 'P' THEN
2480:
2481: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2482: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2483: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2484: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2485: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2486: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
2487:

Line 2485: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2481: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2482: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2483: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2484: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
2485: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2486: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
2487:
2488: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2489: tax_line_rec.tax_id).applied_amt_handling_flag = 'R' THEN

Line 2491: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2487:
2488: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2489: tax_line_rec.tax_id).applied_amt_handling_flag = 'R' THEN
2490:
2491: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2492: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
2493:
2494: IF tax_line_rec.line_amt <> 0 THEN
2495:

Line 2502: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2498: --
2499: l_line_amt_current :=
2500: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
2501:
2502: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2503: l_new_row_num).prd_total_tax_amt := tax_line_rec.tax_amt *
2504: (l_line_amt_current/tax_line_rec.line_amt);
2505: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2506: l_new_row_num).prd_total_tax_amt_tax_curr :=

Line 2505: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2501:
2502: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2503: l_new_row_num).prd_total_tax_amt := tax_line_rec.tax_amt *
2504: (l_line_amt_current/tax_line_rec.line_amt);
2505: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2506: l_new_row_num).prd_total_tax_amt_tax_curr :=
2507: tax_line_rec.tax_amt_tax_curr *
2508: l_line_amt_current/tax_line_rec.line_amt;
2509:

Line 2510: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2506: l_new_row_num).prd_total_tax_amt_tax_curr :=
2507: tax_line_rec.tax_amt_tax_curr *
2508: l_line_amt_current/tax_line_rec.line_amt;
2509:
2510: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2511: l_new_row_num).prd_total_tax_amt_funcl_curr :=
2512: tax_line_rec.tax_amt_funcl_curr *
2513: l_line_amt_current/tax_line_rec.line_amt;
2514:

Line 2518: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2514:
2515: -- do rounding. May be moved to rounding package later
2516: --
2517: IF tax_line_rec.ledger_id IS NOT NULL THEN
2518: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2519: l_new_row_num).prd_total_tax_amt_funcl_curr :=
2520: ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau (
2521: tax_line_rec.ledger_id,
2522: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2522: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2518: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2519: l_new_row_num).prd_total_tax_amt_funcl_curr :=
2520: ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau (
2521: tax_line_rec.ledger_id,
2522: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2523: l_new_row_num).prd_total_tax_amt_funcl_curr);
2524:
2525: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2526: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 2546: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2542: END IF; -- applied_amt_handling_flag = 'P' or 'R'
2543:
2544: -- Populate other doc line amt, taxable amt and tax amt
2545: --
2546: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2547: l_new_row_num).other_doc_line_amt := tax_line_rec.line_amt;
2548:
2549: -- bug 7024219
2550: --

Line 2553: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2549: -- bug 7024219
2550: --
2551: IF NVL(tax_line_rec.historical_flag, 'N') = 'Y' THEN
2552:
2553: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2554: l_new_row_num).other_doc_line_taxable_amt :=
2555: NVL(tax_line_rec.unrounded_taxable_amt, tax_line_rec.taxable_amt);
2556:
2557: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2557: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2553: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2554: l_new_row_num).other_doc_line_taxable_amt :=
2555: NVL(tax_line_rec.unrounded_taxable_amt, tax_line_rec.taxable_amt);
2556:
2557: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2558: l_new_row_num).other_doc_line_tax_amt :=
2559: NVL(tax_line_rec.unrounded_tax_amt, tax_line_rec.tax_amt);
2560:
2561: ELSE

Line 2563: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2559: NVL(tax_line_rec.unrounded_tax_amt, tax_line_rec.tax_amt);
2560:
2561: ELSE
2562:
2563: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2564: l_new_row_num).other_doc_line_taxable_amt :=
2565: tax_line_rec.unrounded_taxable_amt;
2566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2567: l_new_row_num).other_doc_line_tax_amt :=

Line 2566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2562:
2563: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2564: l_new_row_num).other_doc_line_taxable_amt :=
2565: tax_line_rec.unrounded_taxable_amt;
2566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2567: l_new_row_num).other_doc_line_tax_amt :=
2568: tax_line_rec.unrounded_tax_amt;
2569: END IF;
2570:

Line 2573: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2569: END IF;
2570:
2571: -- Set copied_from_other_doc_flag to 'Y'
2572: --
2573: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2574: l_new_row_num).copied_from_other_doc_flag := 'Y';
2575:
2576: -- set other_doc_source
2577: --

Line 2578: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2574: l_new_row_num).copied_from_other_doc_flag := 'Y';
2575:
2576: -- set other_doc_source
2577: --
2578: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2579: l_new_row_num).other_doc_source := 'APPLIED_FROM';
2580:
2581: -- populate manually_entered_flag, overridden_flag and last_manual_entry
2582: --

Line 2583: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2579: l_new_row_num).other_doc_source := 'APPLIED_FROM';
2580:
2581: -- populate manually_entered_flag, overridden_flag and last_manual_entry
2582: --
2583: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2584: l_new_row_num).manually_entered_flag := 'Y';
2585: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2586: l_new_row_num).overridden_flag := 'Y';
2587: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2585: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2581: -- populate manually_entered_flag, overridden_flag and last_manual_entry
2582: --
2583: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2584: l_new_row_num).manually_entered_flag := 'Y';
2585: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2586: l_new_row_num).overridden_flag := 'Y';
2587: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2588: l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2589:

Line 2587: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2583: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2584: l_new_row_num).manually_entered_flag := 'Y';
2585: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2586: l_new_row_num).overridden_flag := 'Y';
2587: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2588: l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2589:
2590: -- populate other columns
2591: --

Line 2592: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2588: l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
2589:
2590: -- populate other columns
2591: --
2592: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2593: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
2594: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2595: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2594: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2590: -- populate other columns
2591: --
2592: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2593: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
2594: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2595: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2597: l_new_row_num).tax_date := p_tax_date;
2598: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2592: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2593: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
2594: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2595: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2597: l_new_row_num).tax_date := p_tax_date;
2598: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2599: l_new_row_num).tax_determine_date := p_tax_determine_date;
2600: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2598: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2594: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2595: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
2596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2597: l_new_row_num).tax_date := p_tax_date;
2598: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2599: l_new_row_num).tax_determine_date := p_tax_determine_date;
2600: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2601: l_new_row_num).tax_point_date := p_tax_point_date;
2602: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2600: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2597: l_new_row_num).tax_date := p_tax_date;
2598: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2599: l_new_row_num).tax_determine_date := p_tax_determine_date;
2600: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2601: l_new_row_num).tax_point_date := p_tax_point_date;
2602: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2603: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2604: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2602: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2598: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2599: l_new_row_num).tax_determine_date := p_tax_determine_date;
2600: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2601: l_new_row_num).tax_point_date := p_tax_point_date;
2602: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2603: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2604: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2605: l_new_row_num).offset_tax_rate_code := tax_line_rec.offset_tax_rate_code;
2606:

Line 2604: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2600: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2601: l_new_row_num).tax_point_date := p_tax_point_date;
2602: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2603: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2604: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2605: l_new_row_num).offset_tax_rate_code := tax_line_rec.offset_tax_rate_code;
2606:
2607: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2608: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;

Line 2607: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2603: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
2604: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2605: l_new_row_num).offset_tax_rate_code := tax_line_rec.offset_tax_rate_code;
2606:
2607: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2608: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
2609: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2610: l_new_row_num).place_of_supply_type_code :=
2611: tax_line_rec.place_of_supply_type_code;

Line 2609: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2605: l_new_row_num).offset_tax_rate_code := tax_line_rec.offset_tax_rate_code;
2606:
2607: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2608: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
2609: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2610: l_new_row_num).place_of_supply_type_code :=
2611: tax_line_rec.place_of_supply_type_code;
2612: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2613: l_new_row_num).place_of_supply_result_id :=

Line 2612: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2608: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
2609: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2610: l_new_row_num).place_of_supply_type_code :=
2611: tax_line_rec.place_of_supply_type_code;
2612: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2613: l_new_row_num).place_of_supply_result_id :=
2614: tax_line_rec.place_of_supply_result_id;
2615: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2616: l_new_row_num).legal_message_pos :=

Line 2615: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2611: tax_line_rec.place_of_supply_type_code;
2612: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2613: l_new_row_num).place_of_supply_result_id :=
2614: tax_line_rec.place_of_supply_result_id;
2615: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2616: l_new_row_num).legal_message_pos :=
2617: tax_line_rec.legal_message_pos;
2618: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2619: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;

Line 2618: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2614: tax_line_rec.place_of_supply_result_id;
2615: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2616: l_new_row_num).legal_message_pos :=
2617: tax_line_rec.legal_message_pos;
2618: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2619: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;
2620: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2621: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2622: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2620: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2616: l_new_row_num).legal_message_pos :=
2617: tax_line_rec.legal_message_pos;
2618: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2619: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;
2620: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2621: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2622: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2623: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2624: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2622: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2618: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2619: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;
2620: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2621: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2622: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2623: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2624: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2625: l_new_row_num).tax_jurisdiction_code :=
2626: tax_line_rec.tax_jurisdiction_code;

Line 2624: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2620: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2621: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
2622: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2623: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2624: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2625: l_new_row_num).tax_jurisdiction_code :=
2626: tax_line_rec.tax_jurisdiction_code;
2627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2628: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;

Line 2627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2623: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
2624: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2625: l_new_row_num).tax_jurisdiction_code :=
2626: tax_line_rec.tax_jurisdiction_code;
2627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2628: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
2629: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2630: l_new_row_num).tax_registration_number :=
2631: tax_line_rec.tax_registration_number;

Line 2629: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2625: l_new_row_num).tax_jurisdiction_code :=
2626: tax_line_rec.tax_jurisdiction_code;
2627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2628: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
2629: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2630: l_new_row_num).tax_registration_number :=
2631: tax_line_rec.tax_registration_number;
2632: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2633: l_new_row_num).registration_party_type :=

Line 2632: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2628: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
2629: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2630: l_new_row_num).tax_registration_number :=
2631: tax_line_rec.tax_registration_number;
2632: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2633: l_new_row_num).registration_party_type :=
2634: tax_line_rec.registration_party_type;
2635: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2636: l_new_row_num).tax_applicability_result_id :=

Line 2635: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2631: tax_line_rec.tax_registration_number;
2632: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2633: l_new_row_num).registration_party_type :=
2634: tax_line_rec.registration_party_type;
2635: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2636: l_new_row_num).tax_applicability_result_id :=
2637: tax_line_rec.tax_applicability_result_id;
2638: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2639: l_new_row_num).legal_message_appl_2 :=

Line 2638: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2634: tax_line_rec.registration_party_type;
2635: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2636: l_new_row_num).tax_applicability_result_id :=
2637: tax_line_rec.tax_applicability_result_id;
2638: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2639: l_new_row_num).legal_message_appl_2 :=
2640: tax_line_rec.legal_message_appl_2;
2641: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2642: l_new_row_num).legal_message_appl_2 :=

Line 2641: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2637: tax_line_rec.tax_applicability_result_id;
2638: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2639: l_new_row_num).legal_message_appl_2 :=
2640: tax_line_rec.legal_message_appl_2;
2641: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2642: l_new_row_num).legal_message_appl_2 :=
2643: tax_line_rec.legal_message_appl_2;
2644: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2645: l_new_row_num).direct_rate_result_id :=

Line 2644: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2640: tax_line_rec.legal_message_appl_2;
2641: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2642: l_new_row_num).legal_message_appl_2 :=
2643: tax_line_rec.legal_message_appl_2;
2644: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2645: l_new_row_num).direct_rate_result_id :=
2646: tax_line_rec.direct_rate_result_id;
2647: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2648: l_new_row_num).legal_message_rate :=

Line 2647: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2643: tax_line_rec.legal_message_appl_2;
2644: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2645: l_new_row_num).direct_rate_result_id :=
2646: tax_line_rec.direct_rate_result_id;
2647: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2648: l_new_row_num).legal_message_rate :=
2649: tax_line_rec.legal_message_rate;
2650: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2651: l_new_row_num).rounding_lvl_party_tax_prof_id :=

Line 2650: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2646: tax_line_rec.direct_rate_result_id;
2647: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2648: l_new_row_num).legal_message_rate :=
2649: tax_line_rec.legal_message_rate;
2650: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2651: l_new_row_num).rounding_lvl_party_tax_prof_id :=
2652: tax_line_rec.rounding_lvl_party_tax_prof_id;
2653: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2654: l_new_row_num).rounding_lvl_party_type :=

Line 2653: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2649: tax_line_rec.legal_message_rate;
2650: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2651: l_new_row_num).rounding_lvl_party_tax_prof_id :=
2652: tax_line_rec.rounding_lvl_party_tax_prof_id;
2653: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2654: l_new_row_num).rounding_lvl_party_type :=
2655: tax_line_rec.rounding_lvl_party_type;
2656: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2657: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;

Line 2656: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2652: tax_line_rec.rounding_lvl_party_tax_prof_id;
2653: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2654: l_new_row_num).rounding_lvl_party_type :=
2655: tax_line_rec.rounding_lvl_party_type;
2656: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2657: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
2658: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2659: l_new_row_num).tax_reg_num_det_result_id :=
2660: tax_line_rec.tax_reg_num_det_result_id;

Line 2658: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2654: l_new_row_num).rounding_lvl_party_type :=
2655: tax_line_rec.rounding_lvl_party_type;
2656: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2657: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
2658: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2659: l_new_row_num).tax_reg_num_det_result_id :=
2660: tax_line_rec.tax_reg_num_det_result_id;
2661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2662: l_new_row_num).legal_message_trn :=

Line 2661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2657: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
2658: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2659: l_new_row_num).tax_reg_num_det_result_id :=
2660: tax_line_rec.tax_reg_num_det_result_id;
2661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2662: l_new_row_num).legal_message_trn :=
2663: tax_line_rec.legal_message_trn;
2664: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2665: l_new_row_num).tax_amt_included_flag := tax_line_rec.tax_amt_included_flag;

Line 2664: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2660: tax_line_rec.tax_reg_num_det_result_id;
2661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2662: l_new_row_num).legal_message_trn :=
2663: tax_line_rec.legal_message_trn;
2664: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2665: l_new_row_num).tax_amt_included_flag := tax_line_rec.tax_amt_included_flag;
2666: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2667: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
2668: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2666: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2662: l_new_row_num).legal_message_trn :=
2663: tax_line_rec.legal_message_trn;
2664: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2665: l_new_row_num).tax_amt_included_flag := tax_line_rec.tax_amt_included_flag;
2666: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2667: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
2668: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2669: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
2670: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id

Line 2668: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

2664: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2665: l_new_row_num).tax_amt_included_flag := tax_line_rec.tax_amt_included_flag;
2666: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2667: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
2668: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2669: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
2670: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id
2671: := tax_line_rec.status_result_id;
2672: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_status

Line 2670: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id

2666: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2667: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
2668: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2669: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
2670: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id
2671: := tax_line_rec.status_result_id;
2672: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_status
2673: := tax_line_rec.legal_message_status ;
2674: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id

Line 2672: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_status

2668: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2669: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
2670: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id
2671: := tax_line_rec.status_result_id;
2672: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_status
2673: := tax_line_rec.legal_message_status ;
2674: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id
2675: := tax_line_rec.rate_result_id;
2676: -- Bug 7117340 -- DFF ER

Line 2674: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id

2670: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id
2671: := tax_line_rec.status_result_id;
2672: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_status
2673: := tax_line_rec.legal_message_status ;
2674: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id
2675: := tax_line_rec.rate_result_id;
2676: -- Bug 7117340 -- DFF ER
2677: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1
2678: := tax_line_rec.attribute1;

Line 2677: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1

2673: := tax_line_rec.legal_message_status ;
2674: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id
2675: := tax_line_rec.rate_result_id;
2676: -- Bug 7117340 -- DFF ER
2677: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1
2678: := tax_line_rec.attribute1;
2679: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2
2680: := tax_line_rec.attribute2;
2681: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3

Line 2679: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2

2675: := tax_line_rec.rate_result_id;
2676: -- Bug 7117340 -- DFF ER
2677: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1
2678: := tax_line_rec.attribute1;
2679: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2
2680: := tax_line_rec.attribute2;
2681: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3
2682: := tax_line_rec.attribute3;
2683: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4

Line 2681: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3

2677: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1
2678: := tax_line_rec.attribute1;
2679: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2
2680: := tax_line_rec.attribute2;
2681: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3
2682: := tax_line_rec.attribute3;
2683: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4
2684: := tax_line_rec.attribute4;
2685: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5

Line 2683: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4

2679: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2
2680: := tax_line_rec.attribute2;
2681: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3
2682: := tax_line_rec.attribute3;
2683: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4
2684: := tax_line_rec.attribute4;
2685: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5
2686: := tax_line_rec.attribute5;
2687: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6

Line 2685: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5

2681: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3
2682: := tax_line_rec.attribute3;
2683: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4
2684: := tax_line_rec.attribute4;
2685: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5
2686: := tax_line_rec.attribute5;
2687: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6
2688: := tax_line_rec.attribute6;
2689: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7

Line 2687: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6

2683: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4
2684: := tax_line_rec.attribute4;
2685: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5
2686: := tax_line_rec.attribute5;
2687: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6
2688: := tax_line_rec.attribute6;
2689: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7
2690: := tax_line_rec.attribute7;
2691: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8

Line 2689: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7

2685: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5
2686: := tax_line_rec.attribute5;
2687: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6
2688: := tax_line_rec.attribute6;
2689: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7
2690: := tax_line_rec.attribute7;
2691: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8
2692: := tax_line_rec.attribute8;
2693: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9

Line 2691: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8

2687: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6
2688: := tax_line_rec.attribute6;
2689: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7
2690: := tax_line_rec.attribute7;
2691: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8
2692: := tax_line_rec.attribute8;
2693: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9
2694: := tax_line_rec.attribute9;
2695: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10

Line 2693: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9

2689: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7
2690: := tax_line_rec.attribute7;
2691: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8
2692: := tax_line_rec.attribute8;
2693: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9
2694: := tax_line_rec.attribute9;
2695: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10
2696: := tax_line_rec.attribute10;
2697: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11

Line 2695: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10

2691: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8
2692: := tax_line_rec.attribute8;
2693: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9
2694: := tax_line_rec.attribute9;
2695: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10
2696: := tax_line_rec.attribute10;
2697: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11
2698: := tax_line_rec.attribute11;
2699: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12

Line 2697: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11

2693: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9
2694: := tax_line_rec.attribute9;
2695: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10
2696: := tax_line_rec.attribute10;
2697: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11
2698: := tax_line_rec.attribute11;
2699: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12
2700: := tax_line_rec.attribute12;
2701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13

Line 2699: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12

2695: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10
2696: := tax_line_rec.attribute10;
2697: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11
2698: := tax_line_rec.attribute11;
2699: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12
2700: := tax_line_rec.attribute12;
2701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13
2702: := tax_line_rec.attribute13;
2703: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14

Line 2701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13

2697: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11
2698: := tax_line_rec.attribute11;
2699: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12
2700: := tax_line_rec.attribute12;
2701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13
2702: := tax_line_rec.attribute13;
2703: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14
2704: := tax_line_rec.attribute14;
2705: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15

Line 2703: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14

2699: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12
2700: := tax_line_rec.attribute12;
2701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13
2702: := tax_line_rec.attribute13;
2703: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14
2704: := tax_line_rec.attribute14;
2705: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15
2706: := tax_line_rec.attribute15;
2707: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute_category

Line 2705: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15

2701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13
2702: := tax_line_rec.attribute13;
2703: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14
2704: := tax_line_rec.attribute14;
2705: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15
2706: := tax_line_rec.attribute15;
2707: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute_category
2708: := tax_line_rec.attribute_category;
2709: -- End Bug 7117340 -- DFF ER

Line 2707: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute_category

2703: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14
2704: := tax_line_rec.attribute14;
2705: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15
2706: := tax_line_rec.attribute15;
2707: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute_category
2708: := tax_line_rec.attribute_category;
2709: -- End Bug 7117340 -- DFF ER
2710:
2711: -- Start Bug 8448714

Line 2789: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt <> 0 THEN

2785: ELSE
2786: l_unrounded_tax_amt := NULL;
2787: END IF;
2788:
2789: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt <> 0 THEN
2790:
2791: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt:=
2792: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt *
2793: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /

Line 2791: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt:=

2787: END IF;
2788:
2789: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt <> 0 THEN
2790:
2791: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt:=
2792: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt *
2793: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
2794: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );
2795:

Line 2792: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt *

2788:
2789: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt <> 0 THEN
2790:
2791: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt:=
2792: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt *
2793: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
2794: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );
2795:
2796: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=

Line 2794: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );

2790:
2791: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt:=
2792: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt *
2793: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
2794: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );
2795:
2796: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
2797: NVL(l_unrounded_tax_amt,
2798: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt *

Line 2796: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=

2792: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt *
2793: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
2794: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );
2795:
2796: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
2797: NVL(l_unrounded_tax_amt,
2798: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt *
2799: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
2800: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt ));

Line 2798: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt *

2794: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );
2795:
2796: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
2797: NVL(l_unrounded_tax_amt,
2798: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt *
2799: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
2800: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt ));
2801:
2802: ELSE -- other_doc_line_amt = 0 OR IS NULL

Line 2800: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt ));

2796: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
2797: NVL(l_unrounded_tax_amt,
2798: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt *
2799: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
2800: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt ));
2801:
2802: ELSE -- other_doc_line_amt = 0 OR IS NULL
2803: -- copy unrounded_taxable_amt from reference document,
2804: --

Line 2805: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt :=

2801:
2802: ELSE -- other_doc_line_amt = 0 OR IS NULL
2803: -- copy unrounded_taxable_amt from reference document,
2804: --
2805: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt :=
2806: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt;
2807:
2808: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt :=
2809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt;

Line 2806: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt;

2802: ELSE -- other_doc_line_amt = 0 OR IS NULL
2803: -- copy unrounded_taxable_amt from reference document,
2804: --
2805: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt :=
2806: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt;
2807:
2808: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt :=
2809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt;
2810:

Line 2808: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt :=

2804: --
2805: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt :=
2806: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt;
2807:
2808: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt :=
2809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt;
2810:
2811: END IF; -- other_doc_line_amt <> 0
2812:

Line 2809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt;

2805: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt :=
2806: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt;
2807:
2808: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt :=
2809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt;
2810:
2811: END IF; -- other_doc_line_amt <> 0
2812:
2813: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt:= NULL;

Line 2813: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt:= NULL;

2809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt;
2810:
2811: END IF; -- other_doc_line_amt <> 0
2812:
2813: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_amt:= NULL;
2814: END IF; -- applied_amt_handling_flag = 'P'
2815: -- End Bug 8448714
2816:
2817: IF (x_begin_index IS NULL) THEN

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

2820: END IF; -- l_tax_tbl_index IS NOT NULL
2821: END LOOP; -- FOR tax_line_rec in get_tax_lines_csr
2822:
2823: IF (x_begin_index IS NOT NULL) THEN
2824: x_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
2825: END IF;
2826:
2827: -- copy transaction info to new tax lines for new tax_lines created here
2828: --

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

2965: -- initialize local variables
2966: --
2967: -- bug fix 4867933 begin
2968: -- l_new_row_num := NVL(x_end_index, 0);
2969: l_new_row_num := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
2970: l_orig_begin_index := x_begin_index;
2971: l_orig_end_index := x_end_index;
2972:
2973: FOR tax_line_rec in get_tax_lines_csr LOOP

Line 3023: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3019: l_new_row_num := l_new_row_num +1;
3020:
3021: -- populate tax related information from tax_line_rec
3022: --
3023: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3024: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
3025: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3026: l_new_row_num).tax := tax_line_rec.tax;
3027: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3025: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3021: -- populate tax related information from tax_line_rec
3022: --
3023: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3024: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
3025: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3026: l_new_row_num).tax := tax_line_rec.tax;
3027: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3028: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
3029:

Line 3027: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3023: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3024: l_new_row_num).tax_regime_code:=tax_line_rec.tax_regime_code;
3025: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3026: l_new_row_num).tax := tax_line_rec.tax;
3027: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3028: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
3029:
3030: -- bug 5077691: populate legal_reporting_status
3031: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN

Line 3032: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3028: l_new_row_num).tax_status_code:=tax_line_rec.tax_status_code;
3029:
3030: -- bug 5077691: populate legal_reporting_status
3031: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
3032: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3033: l_new_row_num).legal_reporting_status :=
3034: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
3035: tax_line_rec.tax_id).legal_reporting_status_def_val;
3036: END IF;

Line 3042: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3038: -- for adjusted doc, tax regime id, tax id, tax status id, tax rate id
3039: -- should be the same as the original document since the
3040: -- tax_determination_date is the same as original
3041:
3042: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3043: l_new_row_num).tax_regime_id:= tax_line_rec.tax_regime_id;
3044: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3045: l_new_row_num).tax_id := tax_line_rec.tax_id;
3046: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3044: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3040: -- tax_determination_date is the same as original
3041:
3042: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3043: l_new_row_num).tax_regime_id:= tax_line_rec.tax_regime_id;
3044: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3045: l_new_row_num).tax_id := tax_line_rec.tax_id;
3046: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3047: l_new_row_num).tax_status_id:= tax_line_rec.tax_status_id;
3048:

Line 3046: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3042: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3043: l_new_row_num).tax_regime_id:= tax_line_rec.tax_regime_id;
3044: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3045: l_new_row_num).tax_id := tax_line_rec.tax_id;
3046: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3047: l_new_row_num).tax_status_id:= tax_line_rec.tax_status_id;
3048:
3049:
3050: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3050: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3046: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3047: l_new_row_num).tax_status_id:= tax_line_rec.tax_status_id;
3048:
3049:
3050: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3051: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
3052: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3053: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
3054: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3052: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3048:
3049:
3050: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3051: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
3052: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3053: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
3054: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3055: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
3056: -- bug 5508356

Line 3054: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3050: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3051: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
3052: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3053: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
3054: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3055: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
3056: -- bug 5508356
3057: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3058: l_new_row_num).account_source_tax_rate_id :=

Line 3057: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3053: l_new_row_num).tax_rate_id := tax_line_rec.tax_rate_id;
3054: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3055: l_new_row_num).tax_rate := tax_line_rec.tax_rate;
3056: -- bug 5508356
3057: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3058: l_new_row_num).account_source_tax_rate_id :=
3059: tax_line_rec.account_source_tax_rate_id;
3060:
3061: -- populate taxable_basis_formula and tax_calculation_formula

Line 3063: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3059: tax_line_rec.account_source_tax_rate_id;
3060:
3061: -- populate taxable_basis_formula and tax_calculation_formula
3062: --
3063: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3064: l_new_row_num).taxable_basis_formula :=
3065: tax_line_rec.taxable_basis_formula;
3066: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3067: l_new_row_num).tax_calculation_formula :=

Line 3066: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3062: --
3063: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3064: l_new_row_num).taxable_basis_formula :=
3065: tax_line_rec.taxable_basis_formula;
3066: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3067: l_new_row_num).tax_calculation_formula :=
3068: tax_line_rec.tax_calculation_formula;
3069:
3070:

Line 3072: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3068: tax_line_rec.tax_calculation_formula;
3069:
3070:
3071: -- Bug#6729097 --
3072: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3073: l_new_row_num).tax_apportionment_line_number := tax_line_rec.tax_apportionment_line_number;
3074:
3075: IF (g_level_statement >= g_current_runtime_level ) THEN
3076: FND_LOG.STRING(g_level_statement,

Line 3089: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3085: -- for other cases, set to the one from adjusted doc.
3086: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
3087: p_trx_line_index) = 'A'
3088: THEN
3089: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3090: l_new_row_num).tax_amt_included_flag := 'Y';
3091:
3092: ELSE
3093: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3093: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3089: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3090: l_new_row_num).tax_amt_included_flag := 'Y';
3091:
3092: ELSE
3093: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3094: l_new_row_num).tax_amt_included_flag
3095: := tax_line_rec.tax_amt_included_flag;
3096: END IF;
3097:

Line 3098: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3094: l_new_row_num).tax_amt_included_flag
3095: := tax_line_rec.tax_amt_included_flag;
3096: END IF;
3097:
3098: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3099: l_new_row_num).manually_entered_flag := tax_line_rec.manually_entered_flag;
3100:
3101: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3102: l_new_row_num).manually_entered_flag = 'Y' THEN

Line 3101: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3097:
3098: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3099: l_new_row_num).manually_entered_flag := tax_line_rec.manually_entered_flag;
3100:
3101: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3102: l_new_row_num).manually_entered_flag = 'Y' THEN
3103:
3104: -- don't recalculate the manually entered tax lines on the original
3105: -- trx line, butstill keep them so that user can update these

Line 3110: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3106: -- manual tax lines.
3107:
3108: -- Populate other doc line amt, taxable amt and tax amt
3109: --
3110: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3111: l_new_row_num).tax_amt := 0;
3112: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3113: l_new_row_num).taxable_amt := 0;
3114: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3112: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3108: -- Populate other doc line amt, taxable amt and tax amt
3109: --
3110: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3111: l_new_row_num).tax_amt := 0;
3112: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3113: l_new_row_num).taxable_amt := 0;
3114: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3115: l_new_row_num).unrounded_tax_amt := 0;
3116: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3114: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3110: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3111: l_new_row_num).tax_amt := 0;
3112: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3113: l_new_row_num).taxable_amt := 0;
3114: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3115: l_new_row_num).unrounded_tax_amt := 0;
3116: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3117: l_new_row_num).unrounded_taxable_amt := 0;
3118:

Line 3116: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3112: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3113: l_new_row_num).taxable_amt := 0;
3114: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3115: l_new_row_num).unrounded_tax_amt := 0;
3116: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3117: l_new_row_num).unrounded_taxable_amt := 0;
3118:
3119: ELSE
3120: -- For system generated tax lines on the original trx line

Line 3134: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3130: END IF;
3131:
3132: -- for tax only adjustment set the unrounded tax amount to the
3133: -- unrounded tax amount of the original doc.
3134: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3135: l_new_row_num).unrounded_taxable_amt := tax_line_rec.unrounded_taxable_amt;
3136: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3137: l_new_row_num).unrounded_tax_amt := tax_line_rec.unrounded_tax_amt;
3138:

Line 3136: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3132: -- for tax only adjustment set the unrounded tax amount to the
3133: -- unrounded tax amount of the original doc.
3134: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3135: l_new_row_num).unrounded_taxable_amt := tax_line_rec.unrounded_taxable_amt;
3136: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3137: l_new_row_num).unrounded_tax_amt := tax_line_rec.unrounded_tax_amt;
3138:
3139: ELSE
3140: -- current trx is a regular adjustment or CM

Line 3146: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3142: IF (g_level_statement >= g_current_runtime_level ) THEN
3143: FND_LOG.STRING(g_level_statement,
3144: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3145: 'tax_amt_included_flag on Current tax line: '||
3146: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3147: l_new_row_num).tax_amt_included_flag);
3148: FND_LOG.STRING(g_level_statement,
3149: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3150: 'tax_amt_included_flag on original tax line: '||

Line 3154: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3150: 'tax_amt_included_flag on original tax line: '||
3151: tax_line_rec.tax_amt_included_flag);
3152: END IF;
3153:
3154: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3155: l_new_row_num).tax_amt_included_flag ='Y'
3156: AND tax_line_rec.tax_amt_included_flag = 'N'
3157: THEN
3158: -- If current trx is a tax inclusive trx, while the original trx is

Line 3161: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3157: THEN
3158: -- If current trx is a tax inclusive trx, while the original trx is
3159: -- tax exclusive trx.
3160: IF ( tax_line_rec.line_amt + tax_line_rec.tax_amt) <> 0 THEN
3161: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3162: l_new_row_num).unrounded_taxable_amt
3163: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3164: ( tax_line_rec.unrounded_taxable_amt /
3165: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );

Line 3167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3163: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3164: ( tax_line_rec.unrounded_taxable_amt /
3165: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
3166:
3167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3168: l_new_row_num).unrounded_tax_amt
3169: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3170: ( tax_line_rec.unrounded_tax_amt /
3171: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );

Line 3173: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3169: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3170: ( tax_line_rec.unrounded_tax_amt /
3171: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
3172: ELSE
3173: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3174: l_new_row_num).unrounded_taxable_amt
3175: := tax_line_rec.unrounded_taxable_amt;
3176: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3177: l_new_row_num).unrounded_tax_amt

Line 3176: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3172: ELSE
3173: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3174: l_new_row_num).unrounded_taxable_amt
3175: := tax_line_rec.unrounded_taxable_amt;
3176: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3177: l_new_row_num).unrounded_tax_amt
3178: := tax_line_rec.unrounded_tax_amt;
3179: END IF;
3180: ELSE -- both current tax line and original tax line are inclusive and exclusive

Line 3182: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt

3178: := tax_line_rec.unrounded_tax_amt;
3179: END IF;
3180: ELSE -- both current tax line and original tax line are inclusive and exclusive
3181: IF tax_line_rec.line_amt <> 0 THEN
3182: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3183: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3184: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
3185:
3186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt

Line 3186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt

3182: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3183: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3184: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
3185:
3186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3187: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3188: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
3189: ELSE -- equal to that the original trx is a tax only trx
3190: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) = 'CREDIT_MEMO' THEN

Line 3191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt

3187: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3188: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
3189: ELSE -- equal to that the original trx is a tax only trx
3190: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) = 'CREDIT_MEMO' THEN
3191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3192: := -1 * tax_line_rec.unrounded_taxable_amt;
3193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3194: := -1 * tax_line_rec.unrounded_tax_amt;
3195: ELSE

Line 3193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt

3189: ELSE -- equal to that the original trx is a tax only trx
3190: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) = 'CREDIT_MEMO' THEN
3191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3192: := -1 * tax_line_rec.unrounded_taxable_amt;
3193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3194: := -1 * tax_line_rec.unrounded_tax_amt;
3195: ELSE
3196: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3197: := tax_line_rec.unrounded_taxable_amt;

Line 3196: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt

3192: := -1 * tax_line_rec.unrounded_taxable_amt;
3193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3194: := -1 * tax_line_rec.unrounded_tax_amt;
3195: ELSE
3196: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3197: := tax_line_rec.unrounded_taxable_amt;
3198: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3199: := tax_line_rec.unrounded_tax_amt;
3200: END IF;

Line 3198: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt

3194: := -1 * tax_line_rec.unrounded_tax_amt;
3195: ELSE
3196: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3197: := tax_line_rec.unrounded_taxable_amt;
3198: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3199: := tax_line_rec.unrounded_tax_amt;
3200: END IF;
3201: END IF;
3202: END IF; -- tax_line_rec.tax_amt_included_flag = 'N'

Line 3208: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).basis_result_id

3204: END IF; -- 'ALLOCATE_TAX_ONLY_ADJUSTMENT' trx and else
3205:
3206: END IF; -- manually_entered_flag = 'Y'
3207:
3208: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).basis_result_id
3209: := tax_line_rec.basis_result_id;
3210: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_basis
3211: := tax_line_rec.legal_message_basis ;
3212: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id

Line 3210: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_basis

3206: END IF; -- manually_entered_flag = 'Y'
3207:
3208: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).basis_result_id
3209: := tax_line_rec.basis_result_id;
3210: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_basis
3211: := tax_line_rec.legal_message_basis ;
3212: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id
3213: := tax_line_rec.calc_result_id;
3214: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_calc

Line 3212: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id

3208: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).basis_result_id
3209: := tax_line_rec.basis_result_id;
3210: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_basis
3211: := tax_line_rec.legal_message_basis ;
3212: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id
3213: := tax_line_rec.calc_result_id;
3214: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_calc
3215: := tax_line_rec.legal_message_calc;
3216: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate

Line 3214: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_calc

3210: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_basis
3211: := tax_line_rec.legal_message_basis ;
3212: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id
3213: := tax_line_rec.calc_result_id;
3214: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_calc
3215: := tax_line_rec.legal_message_calc;
3216: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate
3217: := tax_line_rec.tax_base_modifier_rate;
3218:

Line 3216: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate

3212: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).calc_result_id
3213: := tax_line_rec.calc_result_id;
3214: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_calc
3215: := tax_line_rec.legal_message_calc;
3216: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate
3217: := tax_line_rec.tax_base_modifier_rate;
3218:
3219: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag
3220: := tax_line_rec.compounding_dep_tax_flag;

Line 3219: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag

3215: := tax_line_rec.legal_message_calc;
3216: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_base_modifier_rate
3217: := tax_line_rec.tax_base_modifier_rate;
3218:
3219: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag
3220: := tax_line_rec.compounding_dep_tax_flag;
3221: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_tax_miss_flag
3222: := tax_line_rec.compounding_tax_miss_flag;
3223: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag

Line 3221: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_tax_miss_flag

3217: := tax_line_rec.tax_base_modifier_rate;
3218:
3219: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag
3220: := tax_line_rec.compounding_dep_tax_flag;
3221: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_tax_miss_flag
3222: := tax_line_rec.compounding_tax_miss_flag;
3223: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag
3224: := tax_line_rec.compounding_tax_flag;
3225:

Line 3223: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag

3219: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_dep_tax_flag
3220: := tax_line_rec.compounding_dep_tax_flag;
3221: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).compounding_tax_miss_flag
3222: := tax_line_rec.compounding_tax_miss_flag;
3223: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag
3224: := tax_line_rec.compounding_tax_flag;
3225:
3226: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3227: l_new_row_num).tax_amt_included_flag = 'Y' THEN

Line 3226: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3222: := tax_line_rec.compounding_tax_miss_flag;
3223: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).Compounding_Tax_Flag
3224: := tax_line_rec.compounding_tax_flag;
3225:
3226: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3227: l_new_row_num).tax_amt_included_flag = 'Y' THEN
3228:
3229: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
3230: p_trx_line_index) := 'Y';

Line 3233: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3229: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
3230: p_trx_line_index) := 'Y';
3231: END IF;
3232:
3233: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3234: l_new_row_num).compounding_dep_tax_flag = 'Y' THEN
3235:
3236: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
3237: p_trx_line_index) := 'Y';

Line 3240: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id

3236: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
3237: p_trx_line_index) := 'Y';
3238: END IF;
3239:
3240: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id
3241: := tax_line_rec.tax_exemption_id;
3242: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exemption
3243: := tax_line_rec.tax_rate_before_exemption;
3244: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption

Line 3242: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exemption

3238: END IF;
3239:
3240: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id
3241: := tax_line_rec.tax_exemption_id;
3242: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exemption
3243: := tax_line_rec.tax_rate_before_exemption;
3244: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption
3245: := tax_line_rec.tax_rate_name_before_exemption;
3246:

Line 3244: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption

3240: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id
3241: := tax_line_rec.tax_exemption_id;
3242: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exemption
3243: := tax_line_rec.tax_rate_before_exemption;
3244: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption
3245: := tax_line_rec.tax_rate_name_before_exemption;
3246:
3247: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier
3248: := tax_line_rec.exempt_rate_modifier;

Line 3247: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier

3243: := tax_line_rec.tax_rate_before_exemption;
3244: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exemption
3245: := tax_line_rec.tax_rate_name_before_exemption;
3246:
3247: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier
3248: := tax_line_rec.exempt_rate_modifier;
3249: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number
3250: := tax_line_rec.exempt_certificate_number;
3251: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason

Line 3249: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number

3245: := tax_line_rec.tax_rate_name_before_exemption;
3246:
3247: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier
3248: := tax_line_rec.exempt_rate_modifier;
3249: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number
3250: := tax_line_rec.exempt_certificate_number;
3251: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason
3252: := tax_line_rec.exempt_reason;
3253: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code

Line 3251: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason

3247: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_rate_modifier
3248: := tax_line_rec.exempt_rate_modifier;
3249: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number
3250: := tax_line_rec.exempt_certificate_number;
3251: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason
3252: := tax_line_rec.exempt_reason;
3253: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code
3254: := tax_line_rec.exempt_reason_code;
3255:

Line 3253: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code

3249: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_certificate_number
3250: := tax_line_rec.exempt_certificate_number;
3251: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason
3252: := tax_line_rec.exempt_reason;
3253: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code
3254: := tax_line_rec.exempt_reason_code;
3255:
3256: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id
3257: := tax_line_rec.tax_exception_id;

Line 3256: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id

3252: := tax_line_rec.exempt_reason;
3253: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exempt_reason_code
3254: := tax_line_rec.exempt_reason_code;
3255:
3256: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id
3257: := tax_line_rec.tax_exception_id;
3258: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception
3259: := tax_line_rec.tax_rate_before_exception;
3260: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception

Line 3258: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception

3254: := tax_line_rec.exempt_reason_code;
3255:
3256: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id
3257: := tax_line_rec.tax_exception_id;
3258: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception
3259: := tax_line_rec.tax_rate_before_exception;
3260: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception
3261: := tax_line_rec.tax_rate_name_before_exception;
3262: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate

Line 3260: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception

3256: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exception_id
3257: := tax_line_rec.tax_exception_id;
3258: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception
3259: := tax_line_rec.tax_rate_before_exception;
3260: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception
3261: := tax_line_rec.tax_rate_name_before_exception;
3262: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate
3263: := tax_line_rec.exception_rate;
3264:

Line 3262: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate

3258: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_before_exception
3259: := tax_line_rec.tax_rate_before_exception;
3260: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_rate_name_before_exception
3261: := tax_line_rec.tax_rate_name_before_exception;
3262: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate
3263: := tax_line_rec.exception_rate;
3264:
3265: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3266: l_new_row_num).adjusted_doc_tax_line_id := tax_line_rec.tax_line_id;

Line 3265: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3261: := tax_line_rec.tax_rate_name_before_exception;
3262: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).exception_rate
3263: := tax_line_rec.exception_rate;
3264:
3265: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3266: l_new_row_num).adjusted_doc_tax_line_id := tax_line_rec.tax_line_id;
3267:
3268: -- populate overridden_flag and last_manual_entry for manual tax line
3269: --

Line 3270: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3266: l_new_row_num).adjusted_doc_tax_line_id := tax_line_rec.tax_line_id;
3267:
3268: -- populate overridden_flag and last_manual_entry for manual tax line
3269: --
3270: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3271: l_new_row_num).overridden_flag := 'Y';
3272: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3273: -- l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
3274:

Line 3272: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3268: -- populate overridden_flag and last_manual_entry for manual tax line
3269: --
3270: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3271: l_new_row_num).overridden_flag := 'Y';
3272: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3273: -- l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
3274:
3275: -- Populate other doc line amt, taxable amt and tax amt
3276: --

Line 3277: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3273: -- l_new_row_num).last_manual_entry := 'TAX_AMOUNT';
3274:
3275: -- Populate other doc line amt, taxable amt and tax amt
3276: --
3277: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3278: l_new_row_num).other_doc_line_amt := tax_line_rec.line_amt;
3279: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3280: l_new_row_num).other_doc_line_taxable_amt :=
3281: tax_line_rec.unrounded_taxable_amt;

Line 3279: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3275: -- Populate other doc line amt, taxable amt and tax amt
3276: --
3277: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3278: l_new_row_num).other_doc_line_amt := tax_line_rec.line_amt;
3279: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3280: l_new_row_num).other_doc_line_taxable_amt :=
3281: tax_line_rec.unrounded_taxable_amt;
3282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3283: l_new_row_num).other_doc_line_tax_amt :=

Line 3282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3278: l_new_row_num).other_doc_line_amt := tax_line_rec.line_amt;
3279: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3280: l_new_row_num).other_doc_line_taxable_amt :=
3281: tax_line_rec.unrounded_taxable_amt;
3282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3283: l_new_row_num).other_doc_line_tax_amt :=
3284: tax_line_rec.unrounded_tax_amt;
3285:
3286: -- Set copied_from_other_doc_flag to 'Y'

Line 3288: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3284: tax_line_rec.unrounded_tax_amt;
3285:
3286: -- Set copied_from_other_doc_flag to 'Y'
3287: --
3288: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3289: l_new_row_num).copied_from_other_doc_flag := 'Y';
3290:
3291: -- set other_doc_source
3292: --

Line 3293: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3289: l_new_row_num).copied_from_other_doc_flag := 'Y';
3290:
3291: -- set other_doc_source
3292: --
3293: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3294: l_new_row_num).other_doc_source := 'ADJUSTED';
3295:
3296: -- populate other columns
3297: --

Line 3298: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3294: l_new_row_num).other_doc_source := 'ADJUSTED';
3295:
3296: -- populate other columns
3297: --
3298: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3299: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
3300: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3301: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
3302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3300: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3296: -- populate other columns
3297: --
3298: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3299: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
3300: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3301: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
3302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3303: l_new_row_num).tax_date := p_tax_date;
3304: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3298: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3299: l_new_row_num).rounding_level_code := tax_line_rec.rounding_level_code;
3300: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3301: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
3302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3303: l_new_row_num).tax_date := p_tax_date;
3304: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3305: l_new_row_num).tax_determine_date := p_tax_determine_date;
3306: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3304: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3300: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3301: l_new_row_num).rounding_rule_code := tax_line_rec.rounding_rule_code;
3302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3303: l_new_row_num).tax_date := p_tax_date;
3304: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3305: l_new_row_num).tax_determine_date := p_tax_determine_date;
3306: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3307: l_new_row_num).tax_point_date := p_tax_point_date;
3308: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3306: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3303: l_new_row_num).tax_date := p_tax_date;
3304: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3305: l_new_row_num).tax_determine_date := p_tax_determine_date;
3306: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3307: l_new_row_num).tax_point_date := p_tax_point_date;
3308: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3309: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
3310: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3308: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3304: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3305: l_new_row_num).tax_determine_date := p_tax_determine_date;
3306: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3307: l_new_row_num).tax_point_date := p_tax_point_date;
3308: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3309: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
3310: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3311: l_new_row_num).offset_tax_rate_code := tax_line_rec.offset_tax_rate_code;
3312:

Line 3310: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3306: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3307: l_new_row_num).tax_point_date := p_tax_point_date;
3308: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3309: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
3310: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3311: l_new_row_num).offset_tax_rate_code := tax_line_rec.offset_tax_rate_code;
3312:
3313: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3314: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;

Line 3313: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3309: l_new_row_num).offset_flag := tax_line_rec.offset_flag;
3310: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3311: l_new_row_num).offset_tax_rate_code := tax_line_rec.offset_tax_rate_code;
3312:
3313: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3314: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
3315: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3316: l_new_row_num).place_of_supply_type_code :=
3317: tax_line_rec.place_of_supply_type_code;

Line 3315: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3311: l_new_row_num).offset_tax_rate_code := tax_line_rec.offset_tax_rate_code;
3312:
3313: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3314: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
3315: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3316: l_new_row_num).place_of_supply_type_code :=
3317: tax_line_rec.place_of_supply_type_code;
3318: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3319: l_new_row_num).place_of_supply_result_id :=

Line 3318: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3314: l_new_row_num).place_of_supply := tax_line_rec.place_of_supply;
3315: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3316: l_new_row_num).place_of_supply_type_code :=
3317: tax_line_rec.place_of_supply_type_code;
3318: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3319: l_new_row_num).place_of_supply_result_id :=
3320: tax_line_rec.place_of_supply_result_id;
3321: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3322: l_new_row_num).legal_message_pos :=

Line 3321: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3317: tax_line_rec.place_of_supply_type_code;
3318: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3319: l_new_row_num).place_of_supply_result_id :=
3320: tax_line_rec.place_of_supply_result_id;
3321: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3322: l_new_row_num).legal_message_pos :=
3323: tax_line_rec.legal_message_pos;
3324: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3325: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;

Line 3324: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3320: tax_line_rec.place_of_supply_result_id;
3321: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3322: l_new_row_num).legal_message_pos :=
3323: tax_line_rec.legal_message_pos;
3324: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3325: l_new_row_num).tax_currency_code := tax_line_rec.tax_currency_code;
3326:
3327: /* Bug 5149379: When the trx currency is different from the tax currency,
3328: it is necessary to pick the tax_currency_conversion_date,

Line 3332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3328: it is necessary to pick the tax_currency_conversion_date,
3329: tax_currency_conversion_type, tax_currency_conversion_rate
3330: information from the invoice tax lines.
3331: */
3332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3333: l_new_row_num).tax_currency_conversion_date := tax_line_rec.tax_currency_conversion_date;
3334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3335: l_new_row_num).tax_currency_conversion_type := tax_line_rec.tax_currency_conversion_type;
3336: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3330: information from the invoice tax lines.
3331: */
3332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3333: l_new_row_num).tax_currency_conversion_date := tax_line_rec.tax_currency_conversion_date;
3334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3335: l_new_row_num).tax_currency_conversion_type := tax_line_rec.tax_currency_conversion_type;
3336: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3337: l_new_row_num).tax_currency_conversion_rate := tax_line_rec.tax_currency_conversion_rate;
3338:

Line 3336: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3333: l_new_row_num).tax_currency_conversion_date := tax_line_rec.tax_currency_conversion_date;
3334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3335: l_new_row_num).tax_currency_conversion_type := tax_line_rec.tax_currency_conversion_type;
3336: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3337: l_new_row_num).tax_currency_conversion_rate := tax_line_rec.tax_currency_conversion_rate;
3338:
3339: /* Bug 5131206: For partner integration, when the line_level_action is
3340: 'ALLOCATE_TAX_ONLY_ADJUSTMENT', eBTax needs to create

Line 3345: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3341: prorated tax lines and stamp the tax_provider_id on
3342: the tax line(s).
3343: */
3344:
3345: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3346: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
3347:
3348: if(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' and
3349: tax_line_rec.tax_provider_id is not null ) THEN

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

3346: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
3347:
3348: if(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' and
3349: tax_line_rec.tax_provider_id is not null ) THEN
3350: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';
3351: end if;
3352:
3353:
3354: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3354: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3350: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';
3351: end if;
3352:
3353:
3354: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3355: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
3356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3357: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
3358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3352:
3353:
3354: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3355: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
3356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3357: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
3358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3359: l_new_row_num).tax_jurisdiction_code :=
3360: tax_line_rec.tax_jurisdiction_code;

Line 3358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3354: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3355: l_new_row_num).tax_type_code := tax_line_rec.tax_type_code;
3356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3357: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
3358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3359: l_new_row_num).tax_jurisdiction_code :=
3360: tax_line_rec.tax_jurisdiction_code;
3361: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3362: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;

Line 3361: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3357: l_new_row_num).reporting_only_flag := tax_line_rec.reporting_only_flag;
3358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3359: l_new_row_num).tax_jurisdiction_code :=
3360: tax_line_rec.tax_jurisdiction_code;
3361: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3362: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
3363: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3364: l_new_row_num).tax_registration_number :=
3365: tax_line_rec.tax_registration_number;

Line 3363: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3359: l_new_row_num).tax_jurisdiction_code :=
3360: tax_line_rec.tax_jurisdiction_code;
3361: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3362: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
3363: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3364: l_new_row_num).tax_registration_number :=
3365: tax_line_rec.tax_registration_number;
3366: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3367: l_new_row_num).registration_party_type :=

Line 3366: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3362: l_new_row_num).tax_jurisdiction_id := tax_line_rec.tax_jurisdiction_id;
3363: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3364: l_new_row_num).tax_registration_number :=
3365: tax_line_rec.tax_registration_number;
3366: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3367: l_new_row_num).registration_party_type :=
3368: tax_line_rec.registration_party_type;
3369: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3370: l_new_row_num).tax_applicability_result_id :=

Line 3369: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3365: tax_line_rec.tax_registration_number;
3366: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3367: l_new_row_num).registration_party_type :=
3368: tax_line_rec.registration_party_type;
3369: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3370: l_new_row_num).tax_applicability_result_id :=
3371: tax_line_rec.tax_applicability_result_id;
3372: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3373: l_new_row_num).legal_message_appl_2 :=

Line 3372: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3368: tax_line_rec.registration_party_type;
3369: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3370: l_new_row_num).tax_applicability_result_id :=
3371: tax_line_rec.tax_applicability_result_id;
3372: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3373: l_new_row_num).legal_message_appl_2 :=
3374: tax_line_rec.legal_message_appl_2;
3375: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3376: l_new_row_num).legal_message_rate :=

Line 3375: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3371: tax_line_rec.tax_applicability_result_id;
3372: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3373: l_new_row_num).legal_message_appl_2 :=
3374: tax_line_rec.legal_message_appl_2;
3375: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3376: l_new_row_num).legal_message_rate :=
3377: tax_line_rec.legal_message_rate ;
3378: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3379: l_new_row_num).direct_rate_result_id :=

Line 3378: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3374: tax_line_rec.legal_message_appl_2;
3375: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3376: l_new_row_num).legal_message_rate :=
3377: tax_line_rec.legal_message_rate ;
3378: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3379: l_new_row_num).direct_rate_result_id :=
3380: tax_line_rec.direct_rate_result_id;
3381: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3382: l_new_row_num).rounding_lvl_party_tax_prof_id :=

Line 3381: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3377: tax_line_rec.legal_message_rate ;
3378: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3379: l_new_row_num).direct_rate_result_id :=
3380: tax_line_rec.direct_rate_result_id;
3381: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3382: l_new_row_num).rounding_lvl_party_tax_prof_id :=
3383: tax_line_rec.rounding_lvl_party_tax_prof_id;
3384: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3385: l_new_row_num).rounding_lvl_party_type :=

Line 3384: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3380: tax_line_rec.direct_rate_result_id;
3381: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3382: l_new_row_num).rounding_lvl_party_tax_prof_id :=
3383: tax_line_rec.rounding_lvl_party_tax_prof_id;
3384: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3385: l_new_row_num).rounding_lvl_party_type :=
3386: tax_line_rec.rounding_lvl_party_type;
3387: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3388: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;

Line 3387: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3383: tax_line_rec.rounding_lvl_party_tax_prof_id;
3384: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3385: l_new_row_num).rounding_lvl_party_type :=
3386: tax_line_rec.rounding_lvl_party_type;
3387: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3388: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
3389: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3390: l_new_row_num).tax_reg_num_det_result_id :=
3391: tax_line_rec.tax_reg_num_det_result_id;

Line 3389: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3385: l_new_row_num).rounding_lvl_party_type :=
3386: tax_line_rec.rounding_lvl_party_type;
3387: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3388: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
3389: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3390: l_new_row_num).tax_reg_num_det_result_id :=
3391: tax_line_rec.tax_reg_num_det_result_id;
3392: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3393: l_new_row_num).legal_message_trn :=

Line 3392: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3388: l_new_row_num).self_assessed_flag := tax_line_rec.self_assessed_flag;
3389: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3390: l_new_row_num).tax_reg_num_det_result_id :=
3391: tax_line_rec.tax_reg_num_det_result_id;
3392: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3393: l_new_row_num).legal_message_trn :=
3394: tax_line_rec.legal_message_trn;
3395:
3396: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 3396: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3392: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3393: l_new_row_num).legal_message_trn :=
3394: tax_line_rec.legal_message_trn;
3395:
3396: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3397: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
3398: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3399: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
3400: -- Added for Bug#7185529

Line 3398: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3394: tax_line_rec.legal_message_trn;
3395:
3396: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3397: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
3398: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3399: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
3400: -- Added for Bug#7185529
3401: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3402: l_new_row_num).hq_estb_reg_number := tax_line_rec.hq_estb_reg_number;

Line 3401: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

3397: l_new_row_num).tax_only_line_flag := tax_line_rec.tax_only_line_flag;
3398: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3399: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
3400: -- Added for Bug#7185529
3401: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3402: l_new_row_num).hq_estb_reg_number := tax_line_rec.hq_estb_reg_number;
3403:
3404: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id
3405: := tax_line_rec.status_result_id;

Line 3404: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id

3400: -- Added for Bug#7185529
3401: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3402: l_new_row_num).hq_estb_reg_number := tax_line_rec.hq_estb_reg_number;
3403:
3404: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id
3405: := tax_line_rec.status_result_id;
3406: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_status
3407: := tax_line_rec.legal_message_status ;
3408: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id

Line 3406: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_status

3402: l_new_row_num).hq_estb_reg_number := tax_line_rec.hq_estb_reg_number;
3403:
3404: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id
3405: := tax_line_rec.status_result_id;
3406: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_status
3407: := tax_line_rec.legal_message_status ;
3408: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id
3409: := tax_line_rec.rate_result_id;
3410:

Line 3408: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id

3404: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).status_result_id
3405: := tax_line_rec.status_result_id;
3406: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).legal_message_status
3407: := tax_line_rec.legal_message_status ;
3408: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id
3409: := tax_line_rec.rate_result_id;
3410:
3411: -- Bug 7117340 -- DFF ER
3412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1

Line 3412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1

3408: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).rate_result_id
3409: := tax_line_rec.rate_result_id;
3410:
3411: -- Bug 7117340 -- DFF ER
3412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1
3413: := tax_line_rec.attribute1;
3414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2
3415: := tax_line_rec.attribute2;
3416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3

Line 3414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2

3410:
3411: -- Bug 7117340 -- DFF ER
3412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1
3413: := tax_line_rec.attribute1;
3414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2
3415: := tax_line_rec.attribute2;
3416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3
3417: := tax_line_rec.attribute3;
3418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4

Line 3416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3

3412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute1
3413: := tax_line_rec.attribute1;
3414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2
3415: := tax_line_rec.attribute2;
3416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3
3417: := tax_line_rec.attribute3;
3418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4
3419: := tax_line_rec.attribute4;
3420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5

Line 3418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4

3414: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute2
3415: := tax_line_rec.attribute2;
3416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3
3417: := tax_line_rec.attribute3;
3418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4
3419: := tax_line_rec.attribute4;
3420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5
3421: := tax_line_rec.attribute5;
3422: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6

Line 3420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5

3416: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute3
3417: := tax_line_rec.attribute3;
3418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4
3419: := tax_line_rec.attribute4;
3420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5
3421: := tax_line_rec.attribute5;
3422: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6
3423: := tax_line_rec.attribute6;
3424: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7

Line 3422: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6

3418: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute4
3419: := tax_line_rec.attribute4;
3420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5
3421: := tax_line_rec.attribute5;
3422: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6
3423: := tax_line_rec.attribute6;
3424: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7
3425: := tax_line_rec.attribute7;
3426: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8

Line 3424: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7

3420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute5
3421: := tax_line_rec.attribute5;
3422: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6
3423: := tax_line_rec.attribute6;
3424: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7
3425: := tax_line_rec.attribute7;
3426: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8
3427: := tax_line_rec.attribute8;
3428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9

Line 3426: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8

3422: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute6
3423: := tax_line_rec.attribute6;
3424: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7
3425: := tax_line_rec.attribute7;
3426: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8
3427: := tax_line_rec.attribute8;
3428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9
3429: := tax_line_rec.attribute9;
3430: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10

Line 3428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9

3424: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute7
3425: := tax_line_rec.attribute7;
3426: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8
3427: := tax_line_rec.attribute8;
3428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9
3429: := tax_line_rec.attribute9;
3430: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10
3431: := tax_line_rec.attribute10;
3432: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11

Line 3430: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10

3426: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute8
3427: := tax_line_rec.attribute8;
3428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9
3429: := tax_line_rec.attribute9;
3430: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10
3431: := tax_line_rec.attribute10;
3432: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11
3433: := tax_line_rec.attribute11;
3434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12

Line 3432: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11

3428: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute9
3429: := tax_line_rec.attribute9;
3430: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10
3431: := tax_line_rec.attribute10;
3432: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11
3433: := tax_line_rec.attribute11;
3434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12
3435: := tax_line_rec.attribute12;
3436: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13

Line 3434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12

3430: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute10
3431: := tax_line_rec.attribute10;
3432: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11
3433: := tax_line_rec.attribute11;
3434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12
3435: := tax_line_rec.attribute12;
3436: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13
3437: := tax_line_rec.attribute13;
3438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14

Line 3436: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13

3432: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute11
3433: := tax_line_rec.attribute11;
3434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12
3435: := tax_line_rec.attribute12;
3436: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13
3437: := tax_line_rec.attribute13;
3438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14
3439: := tax_line_rec.attribute14;
3440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15

Line 3438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14

3434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute12
3435: := tax_line_rec.attribute12;
3436: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13
3437: := tax_line_rec.attribute13;
3438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14
3439: := tax_line_rec.attribute14;
3440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15
3441: := tax_line_rec.attribute15;
3442: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute_category

Line 3440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15

3436: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute13
3437: := tax_line_rec.attribute13;
3438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14
3439: := tax_line_rec.attribute14;
3440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15
3441: := tax_line_rec.attribute15;
3442: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute_category
3443: := tax_line_rec.attribute_category;
3444: -- End Bug 7117340 -- DFF ER

Line 3442: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute_category

3438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute14
3439: := tax_line_rec.attribute14;
3440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute15
3441: := tax_line_rec.attribute15;
3442: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).attribute_category
3443: := tax_line_rec.attribute_category;
3444: -- End Bug 7117340 -- DFF ER
3445:
3446: IF (x_begin_index IS NULL) THEN

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

3449: END IF; -- l_tax_tbl_index IS NOT NULL
3450: END LOOP; -- FOR tax_line_rec in get_tax_lines_csr
3451:
3452: IF (x_begin_index IS NOT NULL) THEN
3453: x_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
3454: END IF;
3455:
3456: -- copy transaction info to new tax lines for new tax_lines created here
3457: --