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: TYPE zxclpplr_doc_sub_typ_rec IS RECORD(
147: CL_DOC_SUB_TYPE ZX_REP_TRX_DETAIL_T.DOCUMENT_SUB_TYPE%TYPE,
148: CL_NUM_OF_DOC ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE,

Line 148: CL_NUM_OF_DOC ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE,

144: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT12%TYPE INDEX BY BINARY_INTEGER;
145:
146: TYPE zxclpplr_doc_sub_typ_rec IS RECORD(
147: CL_DOC_SUB_TYPE ZX_REP_TRX_DETAIL_T.DOCUMENT_SUB_TYPE%TYPE,
148: CL_NUM_OF_DOC ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE,
149: CL_TOTAL_VAT_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE,
150: CL_TOTAL_OTHER_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC11%type,
151: CL_TOTAL_EXEMPT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE,
152: CL_TOTAL_EFFECT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE

Line 149: CL_TOTAL_VAT_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE,

145:
146: TYPE zxclpplr_doc_sub_typ_rec IS RECORD(
147: CL_DOC_SUB_TYPE ZX_REP_TRX_DETAIL_T.DOCUMENT_SUB_TYPE%TYPE,
148: CL_NUM_OF_DOC ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE,
149: CL_TOTAL_VAT_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE,
150: CL_TOTAL_OTHER_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC11%type,
151: CL_TOTAL_EXEMPT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE,
152: CL_TOTAL_EFFECT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE
153: );

Line 150: CL_TOTAL_OTHER_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC11%type,

146: TYPE zxclpplr_doc_sub_typ_rec IS RECORD(
147: CL_DOC_SUB_TYPE ZX_REP_TRX_DETAIL_T.DOCUMENT_SUB_TYPE%TYPE,
148: CL_NUM_OF_DOC ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE,
149: CL_TOTAL_VAT_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE,
150: CL_TOTAL_OTHER_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC11%type,
151: CL_TOTAL_EXEMPT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE,
152: CL_TOTAL_EFFECT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE
153: );
154:

Line 151: CL_TOTAL_EXEMPT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE,

147: CL_DOC_SUB_TYPE ZX_REP_TRX_DETAIL_T.DOCUMENT_SUB_TYPE%TYPE,
148: CL_NUM_OF_DOC ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE,
149: CL_TOTAL_VAT_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE,
150: CL_TOTAL_OTHER_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC11%type,
151: CL_TOTAL_EXEMPT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE,
152: CL_TOTAL_EFFECT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE
153: );
154:
155: TYPE zxclpplr_doc_sub_typ_tbl IS TABLE OF zxclpplr_doc_sub_typ_rec

Line 152: CL_TOTAL_EFFECT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE

148: CL_NUM_OF_DOC ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE,
149: CL_TOTAL_VAT_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE,
150: CL_TOTAL_OTHER_TAX ZX_REP_TRX_JX_EXT_T.NUMERIC11%type,
151: CL_TOTAL_EXEMPT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE,
152: CL_TOTAL_EFFECT_AMT ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE
153: );
154:
155: TYPE zxclpplr_doc_sub_typ_tbl IS TABLE OF zxclpplr_doc_sub_typ_rec
156: INDEX BY BINARY_INTEGER;

Line 363: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;

359: (
360: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
361: P_ORG_ID IN NUMBER
362: )
363: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
364:
365: PROCEDURE GET_FISCAL_PRINTER
366: (
367: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

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

600: | Type : Private |
601: | Pre-req : None |
602: | Function : |
603: | This procedure extract tax amount for various tax types |
604: | from zx_rep_trx_jx_ext_t table to meet the requirement in |
605: | the flat file |
606: | |
607: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AP |
608: | |

Line 840: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

836: -- Insert lines into JX EXT Table with Calculated amount --
837:
838: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
839:
840: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
841: detail_tax_line_id,
842: numeric9,
843: gdf_ap_invoices_att13,
844: created_by,

Line 850: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

846: last_updated_by,
847: last_update_date,
848: last_update_login,
849: request_id)
850: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
851: l_detail_tax_line_id_tbl(i),
852: l_vat_amt_tbl(i),
853: l_dgi_doc_type_tbl(i),
854: fnd_global.user_id,

Line 863: 'After insertion into zx_rep_trx_jx_ext_t ');

859: p_request_id);
860:
861: IF ( g_level_statement>= g_current_runtime_level ) THEN
862: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
863: 'After insertion into zx_rep_trx_jx_ext_t ');
864: END IF;
865:
866: -- Delete Unwanted lines from Detail ITF
867:

Line 871: FROM zx_rep_trx_jx_ext_t ext

867:
868: DELETE from zx_rep_trx_detail_t itf
869: WHERE itf.request_id = p_request_id
870: AND NOT EXISTS ( SELECT 1
871: FROM zx_rep_trx_jx_ext_t ext
872: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
873:
874: IF ( g_level_statement>= g_current_runtime_level ) THEN
875: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',

Line 1035: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

1031: -- Insert lines into JX EXT Table with Calculated amount --
1032:
1033: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
1034:
1035: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
1036: detail_tax_line_id,
1037: numeric9,
1038: numeric10,
1039: numeric8,

Line 1051: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1047: last_updated_by,
1048: last_update_date,
1049: last_update_login,
1050: request_id)
1051: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1052: l_detail_tax_line_id_tbl(i),
1053: l_vat_amt_tbl(i),
1054: l_taxable_amt_tbl(i),
1055: l_non_taxable_amt_tbl(i),

Line 1072: 'After insertion into zx_rep_trx_jx_ext_t ');

1068: p_request_id);
1069:
1070: IF ( g_level_statement>= g_current_runtime_level ) THEN
1071: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
1072: 'After insertion into zx_rep_trx_jx_ext_t ');
1073: END IF;
1074:
1075: -- Delete Unwanted lines from Detail ITF
1076:

Line 1078: DELETE FROM zx_rep_trx_jx_ext_t

1074:
1075: -- Delete Unwanted lines from Detail ITF
1076:
1077:
1078: DELETE FROM zx_rep_trx_jx_ext_t
1079: WHERE detail_tax_line_id not in ( SELECT min(itf.detail_tax_line_id)
1080: FROM zx_rep_trx_detail_t itf,
1081: ap_invoices_all apinv
1082: WHERE itf.request_id = P_REQUEST_ID

Line 1094: FROM zx_rep_trx_jx_ext_t ext

1090:
1091: DELETE from zx_rep_trx_detail_t itf
1092: WHERE itf.request_id = p_request_id
1093: AND NOT EXISTS ( SELECT 1
1094: FROM zx_rep_trx_jx_ext_t ext
1095: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
1096:
1097: IF ( g_level_statement>= g_current_runtime_level ) THEN
1098: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JL_AP',

Line 1484: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

1480: -- Insert lines into JX EXT Table with Calculated amount --
1481:
1482: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
1483:
1484: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
1485: detail_tax_line_id,
1486: numeric9,
1487: numeric10,
1488: numeric8,

Line 1509: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1505: last_updated_by,
1506: last_update_date,
1507: last_update_login,
1508: request_id)
1509: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1510: l_detail_tax_line_id_tbl(i),
1511: l_vat_amt_tbl(i),
1512: l_taxable_amt_tbl(i),
1513: l_non_taxable_amt_tbl(i),

Line 1537: 'After insertion into zx_rep_trx_jx_ext_t ');

1533: p_request_id);
1534:
1535: IF ( g_level_statement>= g_current_runtime_level ) THEN
1536: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
1537: 'After insertion into zx_rep_trx_jx_ext_t ');
1538: END IF;
1539:
1540: -- Delete Unwanted lines from Detail ITF
1541:

Line 1545: FROM zx_rep_trx_jx_ext_t ext

1541:
1542: DELETE from zx_rep_trx_detail_t itf
1543: WHERE itf.request_id = p_request_id
1544: AND NOT EXISTS ( SELECT 1
1545: FROM zx_rep_trx_jx_ext_t ext
1546: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
1547:
1548: UPDATE_DGI_CURR_CODE(p_request_id);
1549:

Line 1733: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

1729: -- Insert lines into JX EXT Table with Calculated amount --
1730:
1731: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
1732:
1733: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
1734: detail_tax_line_id,
1735: numeric9,--l_vat_amt_tbl
1736: numeric10,--l_taxable_amt_tbl
1737: numeric2,--l_vat_exempt_amt_tbl

Line 1754: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1750: last_updated_by,
1751: last_update_date,
1752: last_update_login,
1753: request_id)
1754: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1755: l_detail_tax_line_id_tbl(i),
1756: l_vat_amt_tbl(i),
1757: l_taxable_amt_tbl(i),
1758: l_vat_exempt_amt_tbl(i),

Line 1779: 'After insertion into zx_rep_trx_jx_ext_t ');

1775: p_request_id);
1776:
1777: IF ( g_level_statement>= g_current_runtime_level ) THEN
1778: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
1779: 'After insertion into zx_rep_trx_jx_ext_t ');
1780: END IF;
1781:
1782: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
1783: UPDATE zx_rep_trx_detail_t itf

Line 1797: FROM zx_rep_trx_jx_ext_t ext

1793: -- Delete Unwanted lines from Detail ITF
1794: DELETE from zx_rep_trx_detail_t itf
1795: WHERE itf.request_id = p_request_id
1796: AND NOT EXISTS ( SELECT 1
1797: FROM zx_rep_trx_jx_ext_t ext
1798: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
1799:
1800:
1801: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1861: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

1857: -- Insert lines into JX EXT Table with Calculated amount --
1858:
1859: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
1860:
1861: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
1862: detail_tax_line_id,
1863: attribute10,
1864: created_by,
1865: creation_date,

Line 1870: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1866: last_updated_by,
1867: last_update_date,
1868: last_update_login,
1869: request_id)
1870: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1871: l_detail_tax_line_id_tbl(i),
1872: l_tax_auth_categ_tbl(i),
1873: fnd_global.user_id,
1874: sysdate,

Line 1882: 'After insertion into zx_rep_trx_jx_ext_t ');

1878: p_request_id);
1879:
1880: IF ( g_level_statement>= g_current_runtime_level ) THEN
1881: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
1882: 'After insertion into zx_rep_trx_jx_ext_t ');
1883: END IF;
1884:
1885: END IF; -- End of P_REPORT_NAME = ..
1886:

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

1898: | Type : Private |
1899: | Pre-req : None |
1900: | Function : |
1901: | This procedure extract tax amount for various tax categories |
1902: | from zx_rep_trx_jx_ext_t table to meet the requirement in |
1903: | the flat file |
1904: | |
1905: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
1906: | |

Line 1964: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;

1960: l_total_doc_amt_tbl NUMERIC12_TBL;
1961: l_rec_count_tbl NUMERIC11_TBL;
1962: l_rate_count_tbl NUMERIC13_TBL;
1963:
1964: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
1965: l_dgi_code_tbl ATTRIBUTE11_TBL;
1966: l_cust_condition_code_tbl ATTRIBUTE7_TBL;
1967: l_dgi_tax_regime_code_tbl ATTRIBUTE25_TBL;
1968: l_vat_reg_stat_code_tbl ATTRIBUTE8_TBL;

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

1974: l_dgi_trx_code_tbl ATTRIBUTE4_TBL;
1975: l_count NUMBER;
1976: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
1977:
1978: l_tax_catg_desc zx_rep_trx_jx_ext_t.attribute1%type; --bug 5251425
1979: l_extended_amt_tbl NUMERIC10_TBL; --Bug 5396444
1980: l_validation_digit_tbl ATTRIBUTE12_TBL;
1981:
1982: BEGIN

Line 2145: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2141: -- Insert lines into JX EXT Table with Calculated amount --
2142:
2143: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
2144:
2145: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2146: detail_tax_line_id,
2147: numeric9,
2148: numeric3,
2149: numeric12,

Line 2160: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2156: last_updated_by,
2157: last_update_date,
2158: last_update_login
2159: )
2160: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2161: l_detail_tax_line_id_tbl(i),
2162: l_taxable_amt_tbl(i),
2163: l_vat_perc_amt_tbl(i),
2164: l_total_doc_amt_tbl(i),

Line 2178: 'After insertion into zx_rep_trx_jx_ext_t ');

2174: );
2175:
2176: IF ( g_level_statement>= g_current_runtime_level ) THEN
2177: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
2178: 'After insertion into zx_rep_trx_jx_ext_t ');
2179: END IF;
2180: -- Delete Unwanted lines from Detail ITF
2181:
2182: DELETE from zx_rep_trx_detail_t itf

Line 2185: FROM zx_rep_trx_jx_ext_t ext

2181:
2182: DELETE from zx_rep_trx_detail_t itf
2183: WHERE itf.request_id = p_request_id
2184: AND NOT EXISTS ( SELECT 1
2185: FROM zx_rep_trx_jx_ext_t ext
2186: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
2187:
2188: IF ( g_level_statement>= g_current_runtime_level ) THEN
2189: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',

Line 2458: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2454: -- Insert lines into JX EXT Table with Calculated amount --
2455:
2456: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
2457:
2458: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2459: detail_tax_line_id,
2460: numeric9,
2461: numeric10,
2462: numeric8,

Line 2475: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2471: last_updated_by,
2472: last_update_date,
2473: last_update_login,
2474: request_id)
2475: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2476: l_detail_tax_line_id_tbl(i),
2477: l_vat_amt_tbl(i),
2478: l_taxable_amt_tbl(i),
2479: l_non_taxable_amt_tbl(i),

Line 2495: 'After insertion into zx_rep_trx_jx_ext_t ');

2491: p_request_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',
2495: 'After insertion into zx_rep_trx_jx_ext_t ');
2496: END IF;
2497: -- Delete Unwanted lines from Detail ITF
2498:
2499: DELETE from zx_rep_trx_detail_t itf

Line 2502: FROM zx_rep_trx_jx_ext_t ext

2498:
2499: DELETE from zx_rep_trx_detail_t itf
2500: WHERE itf.request_id = p_request_id
2501: AND NOT EXISTS ( SELECT 1
2502: FROM zx_rep_trx_jx_ext_t ext
2503: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
2504:
2505:
2506: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2978: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2974: -- Insert lines into JX EXT Table with Calculated amount --
2975:
2976: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
2977:
2978: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2979: detail_tax_line_id,
2980: numeric9,
2981: numeric10,
2982: numeric8,

Line 3005: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3001: last_updated_by,
3002: last_update_date,
3003: last_update_login,
3004: request_id)
3005: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3006: l_detail_tax_line_id_tbl(i),
3007: l_vat_amt_tbl(i),
3008: l_taxable_amt_tbl(i),
3009: l_non_taxable_amt_tbl(i),

Line 3035: 'After insertion into zx_rep_trx_jx_ext_t ');

3031: p_request_id);
3032:
3033: IF ( g_level_statement>= g_current_runtime_level ) THEN
3034: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3035: 'After insertion into zx_rep_trx_jx_ext_t ');
3036: END IF;
3037: -- Delete Unwanted lines from Detail ITF
3038:
3039: /* DELETE from zx_rep_trx_detail_t itf

Line 3042: FROM zx_rep_trx_jx_ext_t ext

3038:
3039: /* DELETE from zx_rep_trx_detail_t itf
3040: WHERE itf.request_id = p_request_id
3041: AND NOT EXISTS ( SELECT 1
3042: FROM zx_rep_trx_jx_ext_t ext
3043: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
3044: */
3045:
3046: UPDATE_DGI_CURR_CODE(p_request_id);

Line 3169: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

3165: -- Insert lines into JX EXT Table with Calculated amount --
3166:
3167: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
3168:
3169: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
3170: detail_tax_line_id,
3171: numeric4,
3172: numeric5,
3173: attribute11,

Line 3182: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3178: last_updated_by,
3179: last_update_date,
3180: last_update_login,
3181: request_id)
3182: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3183: l_detail_tax_line_id_tbl(i),
3184: l_prov_perc_amt_tbl(i),
3185: l_munic_perc_amt_tbl(i),
3186: l_dgi_code_tbl(i),

Line 3198: 'After insertion into zx_rep_trx_jx_ext_t ');

3194: p_request_id);
3195:
3196: IF ( g_level_statement>= g_current_runtime_level ) THEN
3197: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3198: 'After insertion into zx_rep_trx_jx_ext_t ');
3199: END IF;
3200: -- Delete Unwanted lines from Detail ITF
3201:
3202: DELETE from zx_rep_trx_detail_t itf

Line 3205: FROM zx_rep_trx_jx_ext_t ext

3201:
3202: DELETE from zx_rep_trx_detail_t itf
3203: WHERE itf.request_id = p_request_id
3204: AND NOT EXISTS ( SELECT 1
3205: FROM zx_rep_trx_jx_ext_t ext
3206: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
3207:
3208: IF ( g_level_statement>= g_current_runtime_level ) THEN
3209: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',

Line 3374: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

3370: -- Insert lines into JX EXT Table with Calculated amount --
3371:
3372: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
3373:
3374: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
3375: detail_tax_line_id,
3376: numeric9,
3377: numeric10,
3378: numeric2,

Line 3387: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3383: last_updated_by,
3384: last_update_date,
3385: last_update_login,
3386: request_id)
3387: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3388: l_detail_tax_line_id_tbl(i),
3389: l_vat_amt_tbl(i),
3390: l_taxable_amt_tbl(i),
3391: l_vat_exempt_amt_tbl(i),

Line 3403: 'After insertion into zx_rep_trx_jx_ext_t ');

3399: p_request_id);
3400:
3401: IF ( g_level_statement>= g_current_runtime_level ) THEN
3402: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3403: 'After insertion into zx_rep_trx_jx_ext_t ');
3404: END IF;
3405: -- Delete Unwanted lines from Detail ITF
3406:
3407: DELETE from zx_rep_trx_detail_t itf

Line 3410: FROM zx_rep_trx_jx_ext_t ext

3406:
3407: DELETE from zx_rep_trx_detail_t itf
3408: WHERE itf.request_id = p_request_id
3409: AND NOT EXISTS ( SELECT 1
3410: FROM zx_rep_trx_jx_ext_t ext
3411: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
3412:
3413: IF ( g_level_statement>= g_current_runtime_level ) THEN
3414: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JL_AP',

Line 3521: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

3517: l_vat_amt_tbl);
3518:
3519:
3520: FORALL i in NVL(l_detail_tax_line_id_tbl.first,-99)..NVL(l_detail_tax_line_id_tbl.last,0)
3521: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
3522: detail_tax_line_id,
3523: numeric15,--total doc amt
3524: numeric12,--extended amt
3525: numeric9,--vat amt

Line 3532: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3528: last_updated_by,
3529: last_update_date,
3530: last_update_login,
3531: request_id)
3532: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3533: l_detail_tax_line_id_tbl(i),
3534: (l_total_doc_amt_tbl(i) + l_vat_amt_tbl(i)) * l_exchange_rate_tbl(i), --Bug 5396444
3535: l_extended_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444
3536: l_vat_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444

Line 3546: 'After insertion into zx_rep_trx_jx_ext_t ');

3542: p_request_id);
3543:
3544: IF ( g_level_statement>= g_current_runtime_level ) THEN
3545: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
3546: 'After insertion into zx_rep_trx_jx_ext_t ');
3547: END IF;
3548:
3549: -- Delete Unwanted lines from Detail ITF
3550:

Line 3554: FROM zx_rep_trx_jx_ext_t ext

3550:
3551: DELETE from zx_rep_trx_detail_t itf
3552: WHERE itf.request_id = p_request_id
3553: AND NOT EXISTS ( SELECT 1
3554: FROM zx_rep_trx_jx_ext_t ext
3555: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
3556:
3557: IF ( g_level_statement>= g_current_runtime_level ) THEN
3558: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',

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

3567:
3568: END;
3569:
3570: ELSIF P_REPORT_NAME = 'ZXCOARSW' THEN --Bug 5251425
3571: -- Populate zx_rep_trx_jx_ext_t.attribute1 to get the C_TAX_CATEGORY_DESC for the report
3572:
3573: BEGIN
3574: SELECT jtc.description
3575: INTO l_tax_catg_desc

Line 3597: INSERT INTO zx_rep_trx_jx_ext_t

3593: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3594: 'l_tax_catg_desc : '||l_tax_catg_desc );
3595: END IF;
3596:
3597: INSERT INTO zx_rep_trx_jx_ext_t
3598: (detail_tax_line_ext_id,
3599: detail_tax_line_id,
3600: attribute1,
3601: created_by,

Line 3607: (SELECT zx_rep_trx_jx_ext_t_s.nextval,

3603: last_updated_by,
3604: last_update_date,
3605: last_update_login,
3606: request_id)
3607: (SELECT zx_rep_trx_jx_ext_t_s.nextval,
3608: dtl.detail_tax_line_id,
3609: l_tax_catg_desc,
3610: dtl.created_by,
3611: dtl.creation_date,

Line 3622: 'After insertion into zx_rep_trx_jx_ext_t ');

3618: );
3619:
3620: IF ( g_level_statement>= g_current_runtime_level ) THEN
3621: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3622: 'After insertion into zx_rep_trx_jx_ext_t ');
3623: END IF;
3624:
3625: END IF; -- End of P_REPORT_NAME = ..
3626:

Line 7732: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE IS

7728: (
7729: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
7730: P_ORG_ID IN NUMBER
7731: )
7732: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE IS
7733:
7734: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
7735: l_err_msg VARCHAR2(120);
7736:

Line 7734: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;

7730: P_ORG_ID IN NUMBER
7731: )
7732: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE IS
7733:
7734: l_tax_authority_code ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
7735: l_err_msg VARCHAR2(120);
7736:
7737: BEGIN
7738: