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_JL_EXTRACT_PKG dependencies on ZX_REP_TRX_JX_EXT_T

Line 12: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT19%TYPE INDEX BY BINARY_INTEGER;

8: -----------------------------------------
9: --
10:
11: TYPE GDF_RA_CUST_TRX_ATT19_TBL IS TABLE OF
12: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT19%TYPE INDEX BY BINARY_INTEGER;
13:
14: TYPE DOCUMENT_SUB_TYPE_MNG_TBL IS TABLE OF
15: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
16:

Line 15: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;

11: TYPE GDF_RA_CUST_TRX_ATT19_TBL IS TABLE OF
12: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT19%TYPE INDEX BY BINARY_INTEGER;
13:
14: TYPE DOCUMENT_SUB_TYPE_MNG_TBL IS TABLE OF
15: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
16:
17: TYPE NUMERIC1_TBL IS TABLE OF
18: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
19:

Line 18: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;

14: TYPE DOCUMENT_SUB_TYPE_MNG_TBL IS TABLE OF
15: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
16:
17: TYPE NUMERIC1_TBL IS TABLE OF
18: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
19:
20: TYPE NUMERIC2_TBL IS TABLE OF
21: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
22:

Line 21: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;

17: TYPE NUMERIC1_TBL IS TABLE OF
18: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
19:
20: TYPE NUMERIC2_TBL IS TABLE OF
21: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
22:
23: TYPE NUMERIC3_TBL IS TABLE OF
24: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;
25:

Line 24: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;

20: TYPE NUMERIC2_TBL IS TABLE OF
21: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
22:
23: TYPE NUMERIC3_TBL IS TABLE OF
24: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;
25:
26: TYPE NUMERIC4_TBL IS TABLE OF
27: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;
28:

Line 27: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;

23: TYPE NUMERIC3_TBL IS TABLE OF
24: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;
25:
26: TYPE NUMERIC4_TBL IS TABLE OF
27: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;
28:
29: TYPE NUMERIC5_TBL IS TABLE OF
30: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;
31:

Line 30: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;

26: TYPE NUMERIC4_TBL IS TABLE OF
27: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;
28:
29: TYPE NUMERIC5_TBL IS TABLE OF
30: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;
31:
32: TYPE NUMERIC6_TBL IS TABLE OF
33: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;
34:

Line 33: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;

29: TYPE NUMERIC5_TBL IS TABLE OF
30: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;
31:
32: TYPE NUMERIC6_TBL IS TABLE OF
33: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;
34:
35: TYPE NUMERIC7_TBL IS TABLE OF
36: ZX_REP_TRX_JX_EXT_T.NUMERIC7%TYPE INDEX BY BINARY_INTEGER;
37:

Line 36: ZX_REP_TRX_JX_EXT_T.NUMERIC7%TYPE INDEX BY BINARY_INTEGER;

32: TYPE NUMERIC6_TBL IS TABLE OF
33: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;
34:
35: TYPE NUMERIC7_TBL IS TABLE OF
36: ZX_REP_TRX_JX_EXT_T.NUMERIC7%TYPE INDEX BY BINARY_INTEGER;
37:
38: TYPE NUMERIC8_TBL IS TABLE OF
39: ZX_REP_TRX_JX_EXT_T.NUMERIC8%TYPE INDEX BY BINARY_INTEGER;
40:

Line 39: ZX_REP_TRX_JX_EXT_T.NUMERIC8%TYPE INDEX BY BINARY_INTEGER;

35: TYPE NUMERIC7_TBL IS TABLE OF
36: ZX_REP_TRX_JX_EXT_T.NUMERIC7%TYPE INDEX BY BINARY_INTEGER;
37:
38: TYPE NUMERIC8_TBL IS TABLE OF
39: ZX_REP_TRX_JX_EXT_T.NUMERIC8%TYPE INDEX BY BINARY_INTEGER;
40:
41: TYPE NUMERIC9_TBL IS TABLE OF
42: ZX_REP_TRX_JX_EXT_T.NUMERIC9%TYPE INDEX BY BINARY_INTEGER;
43:

Line 42: ZX_REP_TRX_JX_EXT_T.NUMERIC9%TYPE INDEX BY BINARY_INTEGER;

38: TYPE NUMERIC8_TBL IS TABLE OF
39: ZX_REP_TRX_JX_EXT_T.NUMERIC8%TYPE INDEX BY BINARY_INTEGER;
40:
41: TYPE NUMERIC9_TBL IS TABLE OF
42: ZX_REP_TRX_JX_EXT_T.NUMERIC9%TYPE INDEX BY BINARY_INTEGER;
43:
44: TYPE NUMERIC10_TBL IS TABLE OF
45: ZX_REP_TRX_JX_EXT_T.NUMERIC10%TYPE INDEX BY BINARY_INTEGER;
46:

Line 45: ZX_REP_TRX_JX_EXT_T.NUMERIC10%TYPE INDEX BY BINARY_INTEGER;

41: TYPE NUMERIC9_TBL IS TABLE OF
42: ZX_REP_TRX_JX_EXT_T.NUMERIC9%TYPE INDEX BY BINARY_INTEGER;
43:
44: TYPE NUMERIC10_TBL IS TABLE OF
45: ZX_REP_TRX_JX_EXT_T.NUMERIC10%TYPE INDEX BY BINARY_INTEGER;
46:
47: TYPE NUMERIC11_TBL IS TABLE OF
48: ZX_REP_TRX_JX_EXT_T.NUMERIC11%TYPE INDEX BY BINARY_INTEGER;
49:

Line 48: ZX_REP_TRX_JX_EXT_T.NUMERIC11%TYPE INDEX BY BINARY_INTEGER;

44: TYPE NUMERIC10_TBL IS TABLE OF
45: ZX_REP_TRX_JX_EXT_T.NUMERIC10%TYPE INDEX BY BINARY_INTEGER;
46:
47: TYPE NUMERIC11_TBL IS TABLE OF
48: ZX_REP_TRX_JX_EXT_T.NUMERIC11%TYPE INDEX BY BINARY_INTEGER;
49:
50: TYPE NUMERIC12_TBL IS TABLE OF
51: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;
52:

Line 51: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;

47: TYPE NUMERIC11_TBL IS TABLE OF
48: ZX_REP_TRX_JX_EXT_T.NUMERIC11%TYPE INDEX BY BINARY_INTEGER;
49:
50: TYPE NUMERIC12_TBL IS TABLE OF
51: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;
52:
53: TYPE NUMERIC13_TBL IS TABLE OF
54: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
55:

Line 54: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;

50: TYPE NUMERIC12_TBL IS TABLE OF
51: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;
52:
53: TYPE NUMERIC13_TBL IS TABLE OF
54: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
55:
56: TYPE NUMERIC14_TBL IS TABLE OF
57: ZX_REP_TRX_JX_EXT_T.NUMERIC14%TYPE INDEX BY BINARY_INTEGER;
58:

Line 57: ZX_REP_TRX_JX_EXT_T.NUMERIC14%TYPE INDEX BY BINARY_INTEGER;

53: TYPE NUMERIC13_TBL IS TABLE OF
54: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
55:
56: TYPE NUMERIC14_TBL IS TABLE OF
57: ZX_REP_TRX_JX_EXT_T.NUMERIC14%TYPE INDEX BY BINARY_INTEGER;
58:
59: TYPE NUMERIC15_TBL IS TABLE OF
60: ZX_REP_TRX_JX_EXT_T.NUMERIC15%TYPE INDEX BY BINARY_INTEGER;
61:

Line 60: ZX_REP_TRX_JX_EXT_T.NUMERIC15%TYPE INDEX BY BINARY_INTEGER;

56: TYPE NUMERIC14_TBL IS TABLE OF
57: ZX_REP_TRX_JX_EXT_T.NUMERIC14%TYPE INDEX BY BINARY_INTEGER;
58:
59: TYPE NUMERIC15_TBL IS TABLE OF
60: ZX_REP_TRX_JX_EXT_T.NUMERIC15%TYPE INDEX BY BINARY_INTEGER;
61:
62: TYPE NUMERIC16_TBL IS TABLE OF
63: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
64:

Line 63: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;

59: TYPE NUMERIC15_TBL IS TABLE OF
60: ZX_REP_TRX_JX_EXT_T.NUMERIC15%TYPE INDEX BY BINARY_INTEGER;
61:
62: TYPE NUMERIC16_TBL IS TABLE OF
63: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
64:
65: TYPE ATTRIBUTE1_TBL IS TABLE OF
66: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
67:

Line 66: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

62: TYPE NUMERIC16_TBL IS TABLE OF
63: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
64:
65: TYPE ATTRIBUTE1_TBL IS TABLE OF
66: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
67:
68: TYPE ATTRIBUTE2_TBL IS TABLE OF
69: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
70:

Line 69: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;

65: TYPE ATTRIBUTE1_TBL IS TABLE OF
66: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
67:
68: TYPE ATTRIBUTE2_TBL IS TABLE OF
69: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
70:
71: TYPE ATTRIBUTE3_TBL IS TABLE OF
72: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
73:

Line 72: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;

68: TYPE ATTRIBUTE2_TBL IS TABLE OF
69: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
70:
71: TYPE ATTRIBUTE3_TBL IS TABLE OF
72: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
73:
74: TYPE ATTRIBUTE4_TBL IS TABLE OF
75: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
76:

Line 75: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

71: TYPE ATTRIBUTE3_TBL IS TABLE OF
72: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
73:
74: TYPE ATTRIBUTE4_TBL IS TABLE OF
75: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
76:
77: TYPE ATTRIBUTE5_TBL IS TABLE OF
78: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
79:

Line 78: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

74: TYPE ATTRIBUTE4_TBL IS TABLE OF
75: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
76:
77: TYPE ATTRIBUTE5_TBL IS TABLE OF
78: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
79:
80: TYPE ATTRIBUTE6_TBL IS TABLE OF
81: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
82:

Line 81: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

77: TYPE ATTRIBUTE5_TBL IS TABLE OF
78: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
79:
80: TYPE ATTRIBUTE6_TBL IS TABLE OF
81: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
82:
83: TYPE ATTRIBUTE7_TBL IS TABLE OF
84: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
85:

Line 84: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;

80: TYPE ATTRIBUTE6_TBL IS TABLE OF
81: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
82:
83: TYPE ATTRIBUTE7_TBL IS TABLE OF
84: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE ATTRIBUTE8_TBL IS TABLE OF
87: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
88:

Line 87: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;

83: TYPE ATTRIBUTE7_TBL IS TABLE OF
84: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE ATTRIBUTE8_TBL IS TABLE OF
87: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE ATTRIBUTE9_TBL IS TABLE OF
90: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
91:

Line 90: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;

86: TYPE ATTRIBUTE8_TBL IS TABLE OF
87: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE ATTRIBUTE9_TBL IS TABLE OF
90: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
91:
92: TYPE ATTRIBUTE10_TBL IS TABLE OF
93: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
94:

Line 93: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;

89: TYPE ATTRIBUTE9_TBL IS TABLE OF
90: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
91:
92: TYPE ATTRIBUTE10_TBL IS TABLE OF
93: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
94:
95: TYPE ATTRIBUTE11_TBL IS TABLE OF
96: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
97:

Line 96: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;

92: TYPE ATTRIBUTE10_TBL IS TABLE OF
93: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
94:
95: TYPE ATTRIBUTE11_TBL IS TABLE OF
96: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
97:
98: TYPE ATTRIBUTE12_TBL IS TABLE OF
99: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
100:

Line 99: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;

95: TYPE ATTRIBUTE11_TBL IS TABLE OF
96: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
97:
98: TYPE ATTRIBUTE12_TBL IS TABLE OF
99: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
100:
101: TYPE ATTRIBUTE13_TBL IS TABLE OF
102: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
103:

Line 102: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;

98: TYPE ATTRIBUTE12_TBL IS TABLE OF
99: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
100:
101: TYPE ATTRIBUTE13_TBL IS TABLE OF
102: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
103:
104: TYPE ATTRIBUTE14_TBL IS TABLE OF
105: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
106:

Line 105: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;

101: TYPE ATTRIBUTE13_TBL IS TABLE OF
102: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
103:
104: TYPE ATTRIBUTE14_TBL IS TABLE OF
105: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
106:
107: TYPE ATTRIBUTE15_TBL IS TABLE OF
108: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
109:

Line 108: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;

104: TYPE ATTRIBUTE14_TBL IS TABLE OF
105: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
106:
107: TYPE ATTRIBUTE15_TBL IS TABLE OF
108: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
109:
110: TYPE ATTRIBUTE16_TBL IS TABLE OF
111: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
112:

Line 111: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;

107: TYPE ATTRIBUTE15_TBL IS TABLE OF
108: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
109:
110: TYPE ATTRIBUTE16_TBL IS TABLE OF
111: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
112:
113: TYPE ATTRIBUTE17_TBL IS TABLE OF
114: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
115:

Line 114: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;

110: TYPE ATTRIBUTE16_TBL IS TABLE OF
111: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
112:
113: TYPE ATTRIBUTE17_TBL IS TABLE OF
114: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
115:
116: TYPE ATTRIBUTE18_TBL IS TABLE OF
117: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
118:

Line 117: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;

113: TYPE ATTRIBUTE17_TBL IS TABLE OF
114: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
115:
116: TYPE ATTRIBUTE18_TBL IS TABLE OF
117: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
118:
119: TYPE ATTRIBUTE19_TBL IS TABLE OF
120: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
121:

Line 120: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;

116: TYPE ATTRIBUTE18_TBL IS TABLE OF
117: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
118:
119: TYPE ATTRIBUTE19_TBL IS TABLE OF
120: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
121:
122: TYPE ATTRIBUTE20_TBL IS TABLE OF
123: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
124:

Line 123: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;

119: TYPE ATTRIBUTE19_TBL IS TABLE OF
120: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
121:
122: TYPE ATTRIBUTE20_TBL IS TABLE OF
123: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
124:
125: TYPE ATTRIBUTE21_TBL IS TABLE OF
126: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
127:

Line 126: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;

122: TYPE ATTRIBUTE20_TBL IS TABLE OF
123: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
124:
125: TYPE ATTRIBUTE21_TBL IS TABLE OF
126: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
127:
128: TYPE ATTRIBUTE22_TBL IS TABLE OF
129: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
130:

Line 129: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;

125: TYPE ATTRIBUTE21_TBL IS TABLE OF
126: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
127:
128: TYPE ATTRIBUTE22_TBL IS TABLE OF
129: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
130:
131: TYPE ATTRIBUTE23_TBL IS TABLE OF
132: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
133:

Line 132: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;

128: TYPE ATTRIBUTE22_TBL IS TABLE OF
129: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
130:
131: TYPE ATTRIBUTE23_TBL IS TABLE OF
132: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
133:
134: TYPE ATTRIBUTE25_TBL IS TABLE OF
135: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
136:

Line 135: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;

131: TYPE ATTRIBUTE23_TBL IS TABLE OF
132: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
133:
134: TYPE ATTRIBUTE25_TBL IS TABLE OF
135: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
136:
137: TYPE GDF_RA_BATCH_SOURCES_ATT7_TBL IS TABLE OF
138: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT7%TYPE INDEX BY BINARY_INTEGER;
139:

Line 138: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT7%TYPE INDEX BY BINARY_INTEGER;

134: TYPE ATTRIBUTE25_TBL IS TABLE OF
135: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
136:
137: TYPE GDF_RA_BATCH_SOURCES_ATT7_TBL IS TABLE OF
138: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT7%TYPE INDEX BY BINARY_INTEGER;
139:
140: TYPE GDF_AP_INV_ATT11_TBL IS TABLE OF
141: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT11%TYPE INDEX BY BINARY_INTEGER;
142:

Line 141: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT11%TYPE INDEX BY BINARY_INTEGER;

137: TYPE GDF_RA_BATCH_SOURCES_ATT7_TBL IS TABLE OF
138: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT7%TYPE INDEX BY BINARY_INTEGER;
139:
140: TYPE GDF_AP_INV_ATT11_TBL IS TABLE OF
141: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT11%TYPE INDEX BY BINARY_INTEGER;
142:
143: TYPE GDF_AP_INV_ATT12_TBL IS TABLE OF
144: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT12%TYPE INDEX BY BINARY_INTEGER;
145: -----------------------------------------

Line 144: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT12%TYPE INDEX BY BINARY_INTEGER;

140: TYPE GDF_AP_INV_ATT11_TBL IS TABLE OF
141: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT11%TYPE INDEX BY BINARY_INTEGER;
142:
143: TYPE GDF_AP_INV_ATT12_TBL IS TABLE OF
144: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT12%TYPE INDEX BY BINARY_INTEGER;
145: -----------------------------------------
146: --Private Methods Declarations
147: -----------------------------------------
148: l_err_msg VARCHAR2(120);

Line 341: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;

337: (
338: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
339: P_ORG_ID IN NUMBER
340: )
341: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
342:
343: PROCEDURE GET_FISCAL_PRINTER
344: (
345: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

Line 574: | from zx_rep_trx_jx_ext_t table to meet the requirement in |

570: | Type : Private |
571: | Pre-req : None |
572: | Function : |
573: | This procedure extract tax amount for various tax types |
574: | from zx_rep_trx_jx_ext_t table to meet the requirement in |
575: | the flat file |
576: | |
577: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AP |
578: | |

Line 798: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

794: -- Insert lines into JX EXT Table with Calculated amount --
795:
796: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
797:
798: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
799: detail_tax_line_id,
800: numeric9,
801: gdf_ap_invoices_att13,
802: created_by,

Line 807: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

803: creation_date,
804: last_updated_by,
805: last_update_date,
806: last_update_login)
807: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
808: l_detail_tax_line_id_tbl(i),
809: l_vat_amt_tbl(i),
810: l_dgi_doc_type_tbl(i),
811: fnd_global.user_id,

Line 819: 'After insertion into zx_rep_trx_jx_ext_t ');

815: fnd_global.login_id);
816:
817: IF ( g_level_statement>= g_current_runtime_level ) THEN
818: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
819: 'After insertion into zx_rep_trx_jx_ext_t ');
820: END IF;
821:
822: -- Delete Unwanted lines from Detail ITF
823:

Line 827: FROM zx_rep_trx_jx_ext_t ext

823:
824: DELETE from zx_rep_trx_detail_t itf
825: WHERE itf.request_id = p_request_id
826: AND NOT EXISTS ( SELECT 1
827: FROM zx_rep_trx_jx_ext_t ext
828: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
829:
830: IF ( g_level_statement>= g_current_runtime_level ) THEN
831: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',

Line 983: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

979: -- Insert lines into JX EXT Table with Calculated amount --
980:
981: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
982:
983: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
984: detail_tax_line_id,
985: numeric9,
986: numeric10,
987: numeric8,

Line 999: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

995: last_updated_by,
996: last_update_date,
997: last_update_login,
998: request_id)
999: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1000: l_detail_tax_line_id_tbl(i),
1001: l_vat_amt_tbl(i),
1002: l_taxable_amt_tbl(i),
1003: l_non_taxable_amt_tbl(i),

Line 1019: 'After insertion into zx_rep_trx_jx_ext_t ');

1015: p_request_id);
1016:
1017: IF ( g_level_statement>= g_current_runtime_level ) THEN
1018: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
1019: 'After insertion into zx_rep_trx_jx_ext_t ');
1020: END IF;
1021:
1022: -- Delete Unwanted lines from Detail ITF
1023:

Line 1027: FROM zx_rep_trx_jx_ext_t ext

1023:
1024: DELETE from zx_rep_trx_detail_t itf
1025: WHERE itf.request_id = p_request_id
1026: AND NOT EXISTS ( SELECT 1
1027: FROM zx_rep_trx_jx_ext_t ext
1028: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
1029:
1030: IF ( g_level_statement>= g_current_runtime_level ) THEN
1031: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JL_AP',

Line 1404: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

1400: -- Insert lines into JX EXT Table with Calculated amount --
1401:
1402: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
1403:
1404: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
1405: detail_tax_line_id,
1406: numeric9,
1407: numeric10,
1408: numeric8,

Line 1429: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1425: last_updated_by,
1426: last_update_date,
1427: last_update_login,
1428: request_id)
1429: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1430: l_detail_tax_line_id_tbl(i),
1431: l_vat_amt_tbl(i),
1432: l_taxable_amt_tbl(i),
1433: l_non_taxable_amt_tbl(i),

Line 1457: 'After insertion into zx_rep_trx_jx_ext_t ');

1453: p_request_id);
1454:
1455: IF ( g_level_statement>= g_current_runtime_level ) THEN
1456: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
1457: 'After insertion into zx_rep_trx_jx_ext_t ');
1458: END IF;
1459:
1460: -- Delete Unwanted lines from Detail ITF
1461:

Line 1465: FROM zx_rep_trx_jx_ext_t ext

1461:
1462: DELETE from zx_rep_trx_detail_t itf
1463: WHERE itf.request_id = p_request_id
1464: AND NOT EXISTS ( SELECT 1
1465: FROM zx_rep_trx_jx_ext_t ext
1466: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
1467:
1468: UPDATE_DGI_CURR_CODE(p_request_id);
1469:

Line 1634: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

1630: -- Insert lines into JX EXT Table with Calculated amount --
1631:
1632: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
1633:
1634: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
1635: detail_tax_line_id,
1636: numeric9,--l_vat_amt_tbl
1637: numeric10,--l_taxable_amt_tbl
1638: numeric2,--l_vat_exempt_amt_tbl

Line 1654: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1650: creation_date,
1651: last_updated_by,
1652: last_update_date,
1653: last_update_login)
1654: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1655: l_detail_tax_line_id_tbl(i),
1656: l_vat_amt_tbl(i),
1657: l_taxable_amt_tbl(i),
1658: l_vat_exempt_amt_tbl(i),

Line 1678: 'After insertion into zx_rep_trx_jx_ext_t ');

1674: fnd_global.login_id);
1675:
1676: IF ( g_level_statement>= g_current_runtime_level ) THEN
1677: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
1678: 'After insertion into zx_rep_trx_jx_ext_t ');
1679: END IF;
1680: -- Delete Unwanted lines from Detail ITF
1681:
1682:

Line 1686: FROM zx_rep_trx_jx_ext_t ext

1682:
1683: DELETE from zx_rep_trx_detail_t itf
1684: WHERE itf.request_id = p_request_id
1685: AND NOT EXISTS ( SELECT 1
1686: FROM zx_rep_trx_jx_ext_t ext
1687: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
1688:
1689:
1690: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1750: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

1746: -- Insert lines into JX EXT Table with Calculated amount --
1747:
1748: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
1749:
1750: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
1751: detail_tax_line_id,
1752: attribute10,
1753: created_by,
1754: creation_date,

Line 1758: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1754: creation_date,
1755: last_updated_by,
1756: last_update_date,
1757: last_update_login)
1758: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1759: l_detail_tax_line_id_tbl(i),
1760: l_tax_auth_categ_tbl(i),
1761: fnd_global.user_id,
1762: sysdate,

Line 1769: 'After insertion into zx_rep_trx_jx_ext_t ');

1765: fnd_global.login_id);
1766:
1767: IF ( g_level_statement>= g_current_runtime_level ) THEN
1768: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
1769: 'After insertion into zx_rep_trx_jx_ext_t ');
1770: END IF;
1771:
1772: END IF; -- End of P_REPORT_NAME = ..
1773:

Line 1789: | from zx_rep_trx_jx_ext_t table to meet the requirement in |

1785: | Type : Private |
1786: | Pre-req : None |
1787: | Function : |
1788: | This procedure extract tax amount for various tax categories |
1789: | from zx_rep_trx_jx_ext_t table to meet the requirement in |
1790: | the flat file |
1791: | |
1792: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
1793: | |

Line 1850: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;

1846: l_total_doc_amt_tbl NUMERIC12_TBL;
1847: l_rec_count_tbl NUMERIC11_TBL;
1848: l_rate_count_tbl NUMERIC13_TBL;
1849:
1850: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
1851: l_dgi_code_tbl ATTRIBUTE11_TBL;
1852: l_cust_condition_code_tbl ATTRIBUTE7_TBL;
1853: l_dgi_tax_regime_code_tbl ATTRIBUTE25_TBL;
1854: l_vat_reg_stat_code_tbl ATTRIBUTE8_TBL;

Line 1864: l_tax_catg_desc zx_rep_trx_jx_ext_t.attribute1%type; --bug 5251425

1860: l_dgi_trx_code_tbl ATTRIBUTE4_TBL;
1861: l_count NUMBER;
1862: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
1863:
1864: l_tax_catg_desc zx_rep_trx_jx_ext_t.attribute1%type; --bug 5251425
1865: l_extended_amt_tbl NUMERIC10_TBL; --Bug 5396444
1866: BEGIN
1867:
1868: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1995: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

1991: -- Insert lines into JX EXT Table with Calculated amount --
1992:
1993: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
1994:
1995: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
1996: detail_tax_line_id,
1997: numeric9,
1998: attribute11,
1999: created_by,

Line 2005: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2001: last_updated_by,
2002: last_update_date,
2003: last_update_login,
2004: request_id)
2005: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2006: l_detail_tax_line_id_tbl(i),
2007: l_vat_amt_tbl(i),
2008: l_dgi_code_tbl(i),
2009: fnd_global.user_id,

Line 2018: 'After insertion into zx_rep_trx_jx_ext_t ');

2014: p_request_id);
2015:
2016: IF ( g_level_statement>= g_current_runtime_level ) THEN
2017: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
2018: 'After insertion into zx_rep_trx_jx_ext_t ');
2019: END IF;
2020: -- Delete Unwanted lines from Detail ITF
2021:
2022: DELETE from zx_rep_trx_detail_t itf

Line 2025: FROM zx_rep_trx_jx_ext_t ext

2021:
2022: DELETE from zx_rep_trx_detail_t itf
2023: WHERE itf.request_id = p_request_id
2024: AND NOT EXISTS ( SELECT 1
2025: FROM zx_rep_trx_jx_ext_t ext
2026: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
2027:
2028: IF ( g_level_statement>= g_current_runtime_level ) THEN
2029: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',

Line 2166: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2162: -- Insert lines into JX EXT Table with Calculated amount --
2163:
2164: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
2165:
2166: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2167: detail_tax_line_id,
2168: numeric9,
2169: numeric3,
2170: numeric12,

Line 2180: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2176: creation_date,
2177: last_updated_by,
2178: last_update_date,
2179: last_update_login)
2180: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2181: l_detail_tax_line_id_tbl(i),
2182: l_taxable_amt_tbl(i),
2183: l_vat_perc_amt_tbl(i),
2184: l_total_doc_amt_tbl(i),

Line 2197: 'After insertion into zx_rep_trx_jx_ext_t ');

2193: fnd_global.login_id);
2194:
2195: IF ( g_level_statement>= g_current_runtime_level ) THEN
2196: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
2197: 'After insertion into zx_rep_trx_jx_ext_t ');
2198: END IF;
2199: -- Delete Unwanted lines from Detail ITF
2200:
2201: DELETE from zx_rep_trx_detail_t itf

Line 2204: FROM zx_rep_trx_jx_ext_t ext

2200:
2201: DELETE from zx_rep_trx_detail_t itf
2202: WHERE itf.request_id = p_request_id
2203: AND NOT EXISTS ( SELECT 1
2204: FROM zx_rep_trx_jx_ext_t ext
2205: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
2206:
2207: IF ( g_level_statement>= g_current_runtime_level ) THEN
2208: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',

Line 2450: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2446: -- Insert lines into JX EXT Table with Calculated amount --
2447:
2448: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
2449:
2450: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2451: detail_tax_line_id,
2452: numeric9,
2453: numeric10,
2454: numeric8,

Line 2465: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2461: creation_date,
2462: last_updated_by,
2463: last_update_date,
2464: last_update_login)
2465: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2466: l_detail_tax_line_id_tbl(i),
2467: l_vat_amt_tbl(i),
2468: l_taxable_amt_tbl(i),
2469: l_non_taxable_amt_tbl(i),

Line 2483: 'After insertion into zx_rep_trx_jx_ext_t ');

2479: fnd_global.login_id);
2480:
2481: IF ( g_level_statement>= g_current_runtime_level ) THEN
2482: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
2483: 'After insertion into zx_rep_trx_jx_ext_t ');
2484: END IF;
2485: -- Delete Unwanted lines from Detail ITF
2486:
2487: DELETE from zx_rep_trx_detail_t itf

Line 2490: FROM zx_rep_trx_jx_ext_t ext

2486:
2487: DELETE from zx_rep_trx_detail_t itf
2488: WHERE itf.request_id = p_request_id
2489: AND NOT EXISTS ( SELECT 1
2490: FROM zx_rep_trx_jx_ext_t ext
2491: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
2492:
2493: IF ( g_level_statement>= g_current_runtime_level ) THEN
2494: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',

Line 2928: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2924: -- Insert lines into JX EXT Table with Calculated amount --
2925:
2926: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
2927:
2928: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2929: detail_tax_line_id,
2930: numeric9,
2931: numeric10,
2932: numeric8,

Line 2955: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2951: last_updated_by,
2952: last_update_date,
2953: last_update_login,
2954: request_id)
2955: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2956: l_detail_tax_line_id_tbl(i),
2957: l_vat_amt_tbl(i),
2958: l_taxable_amt_tbl(i),
2959: l_non_taxable_amt_tbl(i),

Line 2985: 'After insertion into zx_rep_trx_jx_ext_t ');

2981: p_request_id);
2982:
2983: IF ( g_level_statement>= g_current_runtime_level ) THEN
2984: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
2985: 'After insertion into zx_rep_trx_jx_ext_t ');
2986: END IF;
2987: -- Delete Unwanted lines from Detail ITF
2988:
2989: /* DELETE from zx_rep_trx_detail_t itf

Line 2992: FROM zx_rep_trx_jx_ext_t ext

2988:
2989: /* DELETE from zx_rep_trx_detail_t itf
2990: WHERE itf.request_id = p_request_id
2991: AND NOT EXISTS ( SELECT 1
2992: FROM zx_rep_trx_jx_ext_t ext
2993: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
2994: */
2995:
2996: UPDATE_DGI_CURR_CODE(p_request_id);

Line 3119: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

3115: -- Insert lines into JX EXT Table with Calculated amount --
3116:
3117: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
3118:
3119: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
3120: detail_tax_line_id,
3121: numeric4,
3122: numeric5,
3123: attribute11,

Line 3132: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3128: last_updated_by,
3129: last_update_date,
3130: last_update_login,
3131: request_id)
3132: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3133: l_detail_tax_line_id_tbl(i),
3134: l_prov_perc_amt_tbl(i),
3135: l_munic_perc_amt_tbl(i),
3136: l_dgi_code_tbl(i),

Line 3148: 'After insertion into zx_rep_trx_jx_ext_t ');

3144: p_request_id);
3145:
3146: IF ( g_level_statement>= g_current_runtime_level ) THEN
3147: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3148: 'After insertion into zx_rep_trx_jx_ext_t ');
3149: END IF;
3150: -- Delete Unwanted lines from Detail ITF
3151:
3152: DELETE from zx_rep_trx_detail_t itf

Line 3155: FROM zx_rep_trx_jx_ext_t ext

3151:
3152: DELETE from zx_rep_trx_detail_t itf
3153: WHERE itf.request_id = p_request_id
3154: AND NOT EXISTS ( SELECT 1
3155: FROM zx_rep_trx_jx_ext_t ext
3156: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
3157:
3158: IF ( g_level_statement>= g_current_runtime_level ) THEN
3159: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',

Line 3303: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

3299: -- Insert lines into JX EXT Table with Calculated amount --
3300:
3301: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
3302:
3303: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
3304: detail_tax_line_id,
3305: numeric9,
3306: numeric10,
3307: numeric2,

Line 3314: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3310: creation_date,
3311: last_updated_by,
3312: last_update_date,
3313: last_update_login)
3314: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3315: l_detail_tax_line_id_tbl(i),
3316: l_vat_amt_tbl(i),
3317: l_taxable_amt_tbl(i),
3318: l_vat_exempt_amt_tbl(i),

Line 3328: 'After insertion into zx_rep_trx_jx_ext_t ');

3324: fnd_global.login_id);
3325:
3326: IF ( g_level_statement>= g_current_runtime_level ) THEN
3327: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3328: 'After insertion into zx_rep_trx_jx_ext_t ');
3329: END IF;
3330: -- Delete Unwanted lines from Detail ITF
3331:
3332: DELETE from zx_rep_trx_detail_t itf

Line 3335: FROM zx_rep_trx_jx_ext_t ext

3331:
3332: DELETE from zx_rep_trx_detail_t itf
3333: WHERE itf.request_id = p_request_id
3334: AND NOT EXISTS ( SELECT 1
3335: FROM zx_rep_trx_jx_ext_t ext
3336: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
3337:
3338: IF ( g_level_statement>= g_current_runtime_level ) THEN
3339: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JL_AP',

Line 3439: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

3435: l_vat_amt_tbl);
3436:
3437:
3438: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
3439: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
3440: detail_tax_line_id,
3441: numeric15,--total doc amt
3442: numeric12,--extended amt
3443: numeric9,--vat amt

Line 3449: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3445: creation_date,
3446: last_updated_by,
3447: last_update_date,
3448: last_update_login)
3449: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3450: l_detail_tax_line_id_tbl(i),
3451: (l_total_doc_amt_tbl(i) + l_vat_amt_tbl(i)) * l_exchange_rate_tbl(i), --Bug 5396444
3452: l_extended_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444
3453: l_vat_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444

Line 3462: 'After insertion into zx_rep_trx_jx_ext_t ');

3458: fnd_global.login_id);
3459:
3460: IF ( g_level_statement>= g_current_runtime_level ) THEN
3461: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
3462: 'After insertion into zx_rep_trx_jx_ext_t ');
3463: END IF;
3464:
3465: -- Delete Unwanted lines from Detail ITF
3466:

Line 3470: FROM zx_rep_trx_jx_ext_t ext

3466:
3467: DELETE from zx_rep_trx_detail_t itf
3468: WHERE itf.request_id = p_request_id
3469: AND NOT EXISTS ( SELECT 1
3470: FROM zx_rep_trx_jx_ext_t ext
3471: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
3472:
3473: IF ( g_level_statement>= g_current_runtime_level ) THEN
3474: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',

Line 3487: -- Populate zx_rep_trx_jx_ext_t.attribute1 to get the C_TAX_CATEGORY_DESC for the report

3483:
3484: END;
3485:
3486: ELSIF P_REPORT_NAME = 'ZXCOARSW' THEN --Bug 5251425
3487: -- Populate zx_rep_trx_jx_ext_t.attribute1 to get the C_TAX_CATEGORY_DESC for the report
3488:
3489: BEGIN
3490: SELECT jtc.description
3491: INTO l_tax_catg_desc

Line 3513: INSERT INTO zx_rep_trx_jx_ext_t

3509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3510: 'l_tax_catg_desc : '||l_tax_catg_desc );
3511: END IF;
3512:
3513: INSERT INTO zx_rep_trx_jx_ext_t
3514: (detail_tax_line_ext_id,
3515: detail_tax_line_id,
3516: attribute1,
3517: created_by,

Line 3522: (SELECT zx_rep_trx_jx_ext_t_s.nextval,

3518: creation_date,
3519: last_updated_by,
3520: last_update_date,
3521: last_update_login)
3522: (SELECT zx_rep_trx_jx_ext_t_s.nextval,
3523: dtl.detail_tax_line_id,
3524: l_tax_catg_desc,
3525: dtl.created_by,
3526: dtl.creation_date,

Line 3536: 'After insertion into zx_rep_trx_jx_ext_t ');

3532: );
3533:
3534: IF ( g_level_statement>= g_current_runtime_level ) THEN
3535: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3536: 'After insertion into zx_rep_trx_jx_ext_t ');
3537: END IF;
3538:
3539: END IF; -- End of P_REPORT_NAME = ..
3540:

Line 7340: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE IS

7336: (
7337: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
7338: P_ORG_ID IN NUMBER
7339: )
7340: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE IS
7341:
7342: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
7343: l_err_msg VARCHAR2(120);
7344:

Line 7342: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;

7338: P_ORG_ID IN NUMBER
7339: )
7340: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE IS
7341:
7342: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
7343: l_err_msg VARCHAR2(120);
7344:
7345: BEGIN
7346: