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_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_TRD_SERVICES_PUB_PKG

Line 31: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

27: p_return_status OUT NOCOPY VARCHAR2,
28: p_error_buffer OUT NOCOPY VARCHAR2);
29:
30: PROCEDURE round_tax_dists_trx_curr (
31: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
32: p_rnd_begin_index IN NUMBER,
33: p_rnd_end_index IN NUMBER,
34: p_tax_line_amt IN NUMBER,
35: p_return_status OUT NOCOPY VARCHAR2,

Line 39: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

35: p_return_status OUT NOCOPY VARCHAR2,
36: p_error_buffer OUT NOCOPY VARCHAR2);
37:
38: PROCEDURE convert_tax_dists (
39: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
40: p_rnd_begin_index IN NUMBER,
41: p_rnd_end_index IN NUMBER,
42: p_tax_line_amt_tax_curr IN NUMBER,
43: p_tax_line_amt_funcl_curr IN NUMBER,

Line 52: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

48: p_tax_id IN NUMBER,
49: p_tax_apportionment_line_num IN NUMBER,
50: p_prd_total_tax_amt IN NUMBER,
51: p_trx_line_dist_index IN NUMBER,
52: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
53: p_rnd_begin_index IN NUMBER,
54: p_rnd_end_index OUT NOCOPY NUMBER,
55: p_return_status OUT NOCOPY VARCHAR2,
56: p_error_buffer OUT NOCOPY VARCHAR2);

Line 62: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

58: PROCEDURE get_recovery_from_adjusted(
59: p_tax_id IN NUMBER,
60: p_tax_apportionment_line_num IN NUMBER,
61: p_trx_line_dist_index IN NUMBER,
62: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
63: p_rnd_begin_index IN NUMBER,
64: p_rnd_end_index OUT NOCOPY NUMBER,
65: p_return_status OUT NOCOPY VARCHAR2,
66: p_error_buffer OUT NOCOPY VARCHAR2);

Line 69: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,

65: p_return_status OUT NOCOPY VARCHAR2,
66: p_error_buffer OUT NOCOPY VARCHAR2);
67:
68: PROCEDURE enforce_recovery_from_ref(
69: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
70: p_tax_line_index IN NUMBER,
71: p_trx_line_dist_index IN NUMBER,
72: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
73: p_rnd_begin_index IN NUMBER,

Line 72: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

68: PROCEDURE enforce_recovery_from_ref(
69: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
70: p_tax_line_index IN NUMBER,
71: p_trx_line_dist_index IN NUMBER,
72: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
73: p_rnd_begin_index IN NUMBER,
74: p_rnd_end_index OUT NOCOPY NUMBER,
75: p_return_status OUT NOCOPY VARCHAR2,
76: p_error_buffer OUT NOCOPY VARCHAR2);

Line 79: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

75: p_return_status OUT NOCOPY VARCHAR2,
76: p_error_buffer OUT NOCOPY VARCHAR2);
77:
78: PROCEDURE round_and_adjust_prd_tax_amts (
79: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
80: p_rnd_begin_index IN NUMBER,
81: p_rnd_end_index IN NUMBER,
82: p_return_status OUT NOCOPY VARCHAR2,
83: p_error_buffer OUT NOCOPY VARCHAR2);

Line 86: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,

82: p_return_status OUT NOCOPY VARCHAR2,
83: p_error_buffer OUT NOCOPY VARCHAR2);
84:
85: PROCEDURE get_variance_related_columns(
86: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
87: p_tax_line_index IN NUMBER,
88: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
89: p_rnd_begin_index IN NUMBER,
90: p_rnd_end_index IN NUMBER,

Line 88: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

84:
85: PROCEDURE get_variance_related_columns(
86: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
87: p_tax_line_index IN NUMBER,
88: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
89: p_rnd_begin_index IN NUMBER,
90: p_rnd_end_index IN NUMBER,
91: p_return_status OUT NOCOPY VARCHAR2,
92: p_error_buffer OUT NOCOPY VARCHAR2);

Line 95: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,

91: p_return_status OUT NOCOPY VARCHAR2,
92: p_error_buffer OUT NOCOPY VARCHAR2);
93:
94: PROCEDURE calc_tax_dist(
95: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
96: p_tax_line_index IN NUMBER,
97: p_trx_line_dist_index IN NUMBER,
98: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
99: p_rnd_begin_index IN NUMBER,

Line 98: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

94: PROCEDURE calc_tax_dist(
95: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
96: p_tax_line_index IN NUMBER,
97: p_trx_line_dist_index IN NUMBER,
98: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
99: p_rnd_begin_index IN NUMBER,
100: p_rnd_end_index IN OUT NOCOPY NUMBER,
101: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
102: p_return_status OUT NOCOPY VARCHAR2,

Line 298: IF ZX_TRD_SERVICES_PUB_PKG.g_variance_calc_flag = 'Y' THEN

294: END IF;
295: RETURN;
296: END IF;
297:
298: IF ZX_TRD_SERVICES_PUB_PKG.g_variance_calc_flag = 'Y' THEN
299: get_variance_related_columns(
300: p_detail_tax_line_tbl,
301: p_tax_line_index,
302: p_rec_nrec_dist_tbl,

Line 563: IF ZX_TRD_SERVICES_PUB_PKG.g_variance_calc_flag = 'Y' THEN

559: END IF;
560: RETURN;
561: END IF;
562:
563: IF ZX_TRD_SERVICES_PUB_PKG.g_variance_calc_flag = 'Y' THEN
564: get_variance_related_columns(
565: p_detail_tax_line_tbl,
566: p_tax_line_index,
567: p_rec_nrec_dist_tbl,

Line 631: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,

627:
628: END calc_tax_dist;
629:
630: PROCEDURE cancel_tax_line(
631: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
632: p_tax_line_index IN NUMBER,
633: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
634: p_rnd_begin_index IN NUMBER,
635: p_rnd_end_index IN OUT NOCOPY NUMBER,

Line 633: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

629:
630: PROCEDURE cancel_tax_line(
631: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
632: p_tax_line_index IN NUMBER,
633: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
634: p_rnd_begin_index IN NUMBER,
635: p_rnd_end_index IN OUT NOCOPY NUMBER,
636: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
637: p_return_status OUT NOCOPY VARCHAR2,

Line 786: p_detail_tax_line_tbl IN zx_trd_services_pub_pkg.tax_line_tbl_type,

782: end cancel_tax_line;
783:
784:
785: PROCEDURE det_appl_rec_type(
786: p_detail_tax_line_tbl IN zx_trd_services_pub_pkg.tax_line_tbl_type,
787: p_tax_line_index IN NUMBER,
788: p_trx_line_dist_index IN NUMBER,
789: p_rec_nrec_dist_tbl IN OUT NOCOPY zx_trd_services_pub_pkg.rec_nrec_dist_tbl_type,
790: p_rnd_begin_index IN NUMBER,

Line 789: p_rec_nrec_dist_tbl IN OUT NOCOPY zx_trd_services_pub_pkg.rec_nrec_dist_tbl_type,

785: PROCEDURE det_appl_rec_type(
786: p_detail_tax_line_tbl IN zx_trd_services_pub_pkg.tax_line_tbl_type,
787: p_tax_line_index IN NUMBER,
788: p_trx_line_dist_index IN NUMBER,
789: p_rec_nrec_dist_tbl IN OUT NOCOPY zx_trd_services_pub_pkg.rec_nrec_dist_tbl_type,
790: p_rnd_begin_index IN NUMBER,
791: p_rnd_end_index OUT NOCOPY NUMBER,
792: p_return_status OUT NOCOPY VARCHAR2,
793: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 1050: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.tax_line_tbl_type,

1046:
1047: END DET_APPL_REC_TYPE;
1048:
1049: PROCEDURE get_tax_related_columns_sta(
1050: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.tax_line_tbl_type,
1051: p_tax_line_index IN NUMBER,
1052: p_trx_line_dist_index IN NUMBER,
1053: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,
1054: p_rnd_begin_index IN NUMBER,

Line 1053: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,

1049: PROCEDURE get_tax_related_columns_sta(
1050: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.tax_line_tbl_type,
1051: p_tax_line_index IN NUMBER,
1052: p_trx_line_dist_index IN NUMBER,
1053: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,
1054: p_rnd_begin_index IN NUMBER,
1055: p_rnd_end_index IN NUMBER,
1056: p_return_status OUT NOCOPY VARCHAR2,
1057: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 1275: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.tax_line_tbl_type,

1271: END get_tax_related_columns_sta;
1272:
1273:
1274: PROCEDURE get_tax_related_columns_var(
1275: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.tax_line_tbl_type,
1276: p_tax_line_index IN NUMBER,
1277: p_trx_line_dist_index IN NUMBER,
1278: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,
1279: p_rnd_begin_index IN NUMBER,

Line 1278: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,

1274: PROCEDURE get_tax_related_columns_var(
1275: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.tax_line_tbl_type,
1276: p_tax_line_index IN NUMBER,
1277: p_trx_line_dist_index IN NUMBER,
1278: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,
1279: p_rnd_begin_index IN NUMBER,
1280: p_rnd_end_index IN NUMBER,
1281: p_return_status OUT NOCOPY VARCHAR2,
1282: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 1546: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.tax_line_tbl_type,

1542: END GET_TAX_RELATED_COLUMNS_VAR;
1543:
1544:
1545: PROCEDURE get_rec_rate(
1546: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.tax_line_tbl_type,
1547: p_tax_line_index IN NUMBER,
1548: p_trx_line_dist_index IN NUMBER,
1549: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1550: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,

Line 1550: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,

1546: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.tax_line_tbl_type,
1547: p_tax_line_index IN NUMBER,
1548: p_trx_line_dist_index IN NUMBER,
1549: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1550: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,
1551: p_rnd_begin_index IN NUMBER,
1552: p_rnd_end_index IN OUT NOCOPY NUMBER,
1553: p_return_status OUT NOCOPY VARCHAR2,
1554: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 2659: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,

2655: END IF;
2656: END get_rec_rate;
2657:
2658: PROCEDURE GET_REC_NREC_DIST_AMT(
2659: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
2660: p_tax_line_index IN NUMBER,
2661: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
2662: p_rnd_begin_index IN NUMBER,
2663: p_rnd_end_index IN NUMBER,

Line 2661: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

2657:
2658: PROCEDURE GET_REC_NREC_DIST_AMT(
2659: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
2660: p_tax_line_index IN NUMBER,
2661: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
2662: p_rnd_begin_index IN NUMBER,
2663: p_rnd_end_index IN NUMBER,
2664: p_return_status OUT NOCOPY VARCHAR2,
2665: p_error_buffer OUT NOCOPY VARCHAR2)

Line 2720: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

2716: END GET_REC_NREC_DIST_AMT;
2717:
2718:
2719: PROCEDURE round_rec_nrec_amt(
2720: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
2721: p_rnd_begin_index IN NUMBER,
2722: p_rnd_end_index IN NUMBER,
2723: p_tax_line_amt IN NUMBER,
2724: p_tax_line_amt_tax_curr IN NUMBER,

Line 2877: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

2873:
2874: END ROUND_REC_NREC_AMT;
2875:
2876: PROCEDURE round_tax_dists_trx_curr (
2877: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
2878: p_rnd_begin_index IN NUMBER,
2879: p_rnd_end_index IN NUMBER,
2880: p_tax_line_amt IN NUMBER,
2881: p_return_status OUT NOCOPY VARCHAR2,

Line 3562: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

3558:
3559: END round_tax_dists_trx_curr;
3560:
3561: PROCEDURE convert_tax_dists (
3562: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
3563: p_rnd_begin_index IN NUMBER,
3564: p_rnd_end_index IN NUMBER,
3565: p_tax_line_amt_tax_curr IN NUMBER,
3566: p_tax_line_amt_funcl_curr IN NUMBER,

Line 5154: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

5150: p_tax_id IN NUMBER,
5151: p_tax_apportionment_line_num IN NUMBER,
5152: p_prd_total_tax_amt IN NUMBER,
5153: p_trx_line_dist_index IN NUMBER,
5154: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
5155: p_rnd_begin_index IN NUMBER,
5156: p_rnd_end_index OUT NOCOPY NUMBER,
5157: p_return_status OUT NOCOPY VARCHAR2,
5158: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 5384: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

5380: PROCEDURE get_recovery_from_adjusted(
5381: p_tax_id IN NUMBER,
5382: p_tax_apportionment_line_num IN NUMBER,
5383: p_trx_line_dist_index IN NUMBER,
5384: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
5385: p_rnd_begin_index IN NUMBER,
5386: p_rnd_end_index OUT NOCOPY NUMBER,
5387: p_return_status OUT NOCOPY VARCHAR2,
5388: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 5567: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,

5563:
5564: END get_recovery_from_adjusted;
5565:
5566: PROCEDURE enforce_recovery_from_ref(
5567: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
5568: p_tax_line_index IN NUMBER,
5569: p_trx_line_dist_index IN NUMBER,
5570: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
5571: p_rnd_begin_index IN NUMBER,

Line 5570: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

5566: PROCEDURE enforce_recovery_from_ref(
5567: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
5568: p_tax_line_index IN NUMBER,
5569: p_trx_line_dist_index IN NUMBER,
5570: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
5571: p_rnd_begin_index IN NUMBER,
5572: p_rnd_end_index OUT NOCOPY NUMBER,
5573: p_return_status OUT NOCOPY VARCHAR2,
5574: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 5944: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

5940:
5941: END enforce_recovery_from_ref;
5942:
5943: PROCEDURE round_and_adjust_prd_tax_amts (
5944: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
5945: p_rnd_begin_index IN NUMBER,
5946: p_rnd_end_index IN NUMBER,
5947: p_return_status OUT NOCOPY VARCHAR2,
5948: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 6278: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,

6274:
6275: END round_and_adjust_prd_tax_amts;
6276:
6277: PROCEDURE get_variance_related_columns(
6278: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
6279: p_tax_line_index IN NUMBER,
6280: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
6281: p_rnd_begin_index IN NUMBER,
6282: p_rnd_end_index IN NUMBER,

Line 6280: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,

6276:
6277: PROCEDURE get_variance_related_columns(
6278: p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
6279: p_tax_line_index IN NUMBER,
6280: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
6281: p_rnd_begin_index IN NUMBER,
6282: p_rnd_end_index IN NUMBER,
6283: p_return_status OUT NOCOPY VARCHAR2,
6284: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 6337: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(

6333: 'Reverse flag and Freeze flag are not Y ');
6334: END IF;
6335:
6336: p_rec_nrec_dist_tbl(i).trx_line_dist_qty :=
6337: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(
6338: l_dist_id).trx_line_dist_qty;
6339: END IF;
6340:
6341: p_rec_nrec_dist_tbl(i).ref_doc_trx_line_dist_qty :=

Line 6342: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(

6338: l_dist_id).trx_line_dist_qty;
6339: END IF;
6340:
6341: p_rec_nrec_dist_tbl(i).ref_doc_trx_line_dist_qty :=
6342: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(
6343: l_dist_id).ref_doc_trx_line_dist_qty;
6344: p_rec_nrec_dist_tbl(i).price_diff :=
6345: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(l_dist_id).price_diff;
6346:

Line 6345: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(l_dist_id).price_diff;

6341: p_rec_nrec_dist_tbl(i).ref_doc_trx_line_dist_qty :=
6342: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(
6343: l_dist_id).ref_doc_trx_line_dist_qty;
6344: p_rec_nrec_dist_tbl(i).price_diff :=
6345: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(l_dist_id).price_diff;
6346:
6347: p_rec_nrec_dist_tbl(i).qty_diff :=
6348: p_rec_nrec_dist_tbl(i).trx_line_dist_qty -
6349: p_rec_nrec_dist_tbl(i).ref_doc_trx_line_dist_qty;

Line 6351: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(

6347: p_rec_nrec_dist_tbl(i).qty_diff :=
6348: p_rec_nrec_dist_tbl(i).trx_line_dist_qty -
6349: p_rec_nrec_dist_tbl(i).ref_doc_trx_line_dist_qty;
6350: p_rec_nrec_dist_tbl(i).ref_doc_curr_conv_rate :=
6351: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(
6352: l_dist_id).ref_doc_curr_conv_rate;
6353: p_rec_nrec_dist_tbl(i).applied_to_doc_curr_conv_rate :=
6354: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(
6355: l_dist_id).applied_to_doc_curr_conv_rate;

Line 6354: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(

6350: p_rec_nrec_dist_tbl(i).ref_doc_curr_conv_rate :=
6351: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(
6352: l_dist_id).ref_doc_curr_conv_rate;
6353: p_rec_nrec_dist_tbl(i).applied_to_doc_curr_conv_rate :=
6354: ZX_TRD_SERVICES_PUB_PKG.g_tax_variance_info_tbl(
6355: l_dist_id).applied_to_doc_curr_conv_rate;
6356:
6357: -- set rate_tax_factor
6358: --

Line 6421: IF ZX_TRD_SERVICES_PUB_PKG.g_retained_value is NOT NULL THEN

6417:
6418: -- Bug 11675911 / Bug 10621602, formula changes for retainage release invoices and standard invoice
6419: -- with retainage line. g_ret_doc_type will be 'R' or 'S'. g_retained_value is the retained percent.
6420:
6421: IF ZX_TRD_SERVICES_PUB_PKG.g_retained_value is NOT NULL THEN
6422:
6423: IF (g_level_procedure >= g_current_runtime_level ) THEN
6424: FND_LOG.STRING(g_level_procedure,
6425: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',

Line 6429: IF ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type is NOT NULL AND

6425: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',
6426: 'g_retained_value is not NULL - Retainage flow');
6427: END IF;
6428:
6429: IF ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type is NOT NULL AND
6430: ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type = 'S' THEN
6431:
6432: IF (g_level_procedure >= g_current_runtime_level ) THEN
6433: FND_LOG.STRING(g_level_procedure,

Line 6430: ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type = 'S' THEN

6426: 'g_retained_value is not NULL - Retainage flow');
6427: END IF;
6428:
6429: IF ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type is NOT NULL AND
6430: ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type = 'S' THEN
6431:
6432: IF (g_level_procedure >= g_current_runtime_level ) THEN
6433: FND_LOG.STRING(g_level_procedure,
6434: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',

Line 6445: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty * gt.unit_price * (1 - (ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)))),

6441: UPDATE zx_rec_nrec_dist_gt gt
6442: SET per_trx_curr_unit_nr_amt =
6443: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
6444: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6445: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty * gt.unit_price * (1 - (ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)))),
6446: per_unit_nrec_tax_amt =
6447: DECODE(gt.trx_line_dist_qty, 0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6448: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/gt.trx_line_dist_qty),
6449: (ref_doc_tax_dist_id,

Line 6506: IF ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type is NOT NULL AND

6502: AND ref_doc_tax_dist_id IS NULL;
6503:
6504: END IF; -- g_ret_doc_type 'S'
6505:
6506: IF ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type is NOT NULL AND
6507: ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type = 'R' THEN
6508:
6509: IF (g_level_procedure >= g_current_runtime_level ) THEN
6510: FND_LOG.STRING(g_level_procedure,

Line 6507: ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type = 'R' THEN

6503:
6504: END IF; -- g_ret_doc_type 'S'
6505:
6506: IF ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type is NOT NULL AND
6507: ZX_TRD_SERVICES_PUB_PKG.g_ret_doc_type = 'R' THEN
6508:
6509: IF (g_level_procedure >= g_current_runtime_level ) THEN
6510: FND_LOG.STRING(g_level_procedure,
6511: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',

Line 6519: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty * gt.unit_price * (ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100))),

6515: UPDATE zx_rec_nrec_dist_gt gt
6516: SET per_trx_curr_unit_nr_amt =
6517: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
6518: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6519: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty * gt.unit_price * (ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100))),
6520: per_unit_nrec_tax_amt =
6521: DECODE(gt.trx_line_dist_qty, 0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6522: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/gt.trx_line_dist_qty),
6523: (ref_doc_tax_dist_id,

Line 6534: (NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt))(ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)/(gt.ref_doc_trx_line_dist_qtydist.unit_price*(ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)))),

6530: Nvl(unit_price,0),
6531: DECODE(gt.ref_doc_trx_line_dist_qty,
6532: NULL, DECODE(Nvl(dist.unit_price,0), 0, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/dist.trx_line_dist_amt, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/dist.unit_price),
6533: DECODE(gt.ref_doc_trx_line_dist_qty*dist.unit_price, 0, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt),
6534: (NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt))*(ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)/(gt.ref_doc_trx_line_dist_qty*dist.unit_price*(ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)))),
6535: DECODE(Nvl(gt.ref_doc_trx_line_dist_qty,0), 0, NVL(dist.unrounded_rec_nrec_tax_amt,dist.rec_nrec_tax_amt)/dist.trx_line_dist_amt,
6536: NVL(dist.unrounded_rec_nrec_tax_amt, dist.rec_nrec_tax_amt)/gt.ref_doc_trx_line_dist_qty)
6537: FROM zx_rec_nrec_dist dist
6538: WHERE dist.application_id = gt.ref_doc_application_id

Line 6661: END IF; --ZX_TRD_SERVICES_PUB_PKG.g_retained_value

6657: AND NVL(reverse_flag,'N')='N'
6658: AND mrc_tax_dist_flag = 'N'
6659: AND ref_doc_tax_dist_id IS NULL;
6660:
6661: END IF; --ZX_TRD_SERVICES_PUB_PKG.g_retained_value
6662:
6663: IF (g_level_procedure >= g_current_runtime_level ) THEN
6664: FND_LOG.STRING(g_level_procedure,
6665: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors.END',

Line 6691: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,

6687: | for each reporting currency |
6688: * =====================================================================*/
6689: PROCEDURE create_mrc_tax_dists (
6690: p_event_class_rec IN zx_api_pub.event_class_rec_type,
6691: p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,
6692: p_rnd_begin_index IN NUMBER,
6693: p_rnd_end_index IN OUT NOCOPY NUMBER,
6694: p_return_status OUT NOCOPY VARCHAR2,
6695: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 6844: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists',

6840:
6841: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6842: IF (g_level_statement >= g_current_runtime_level ) THEN
6843: FND_LOG.STRING(g_level_statement,
6844: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists',
6845: 'After calling ROUND_REC_NREC_AMT p_return_status = '
6846: || p_return_status);
6847: FND_LOG.STRING(g_level_statement,
6848: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists.END',

Line 6848: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists.END',

6844: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists',
6845: 'After calling ROUND_REC_NREC_AMT p_return_status = '
6846: || p_return_status);
6847: FND_LOG.STRING(g_level_statement,
6848: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists.END',
6849: 'ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists(-)');
6850: END IF;
6851: RETURN;
6852: END IF;

Line 6849: 'ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists(-)');

6845: 'After calling ROUND_REC_NREC_AMT p_return_status = '
6846: || p_return_status);
6847: FND_LOG.STRING(g_level_statement,
6848: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists.END',
6849: 'ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists(-)');
6850: END IF;
6851: RETURN;
6852: END IF;
6853: END LOOP; -- mrc_line_rec IN get_mrc_tax_line_info_csr LOOP