APPS.OKL_TXL_ITM_INSTS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 102: , p5_a0 JTF_NUMBER_TABLE

98: , p_init_msg_list VARCHAR2
99: , x_return_status out nocopy VARCHAR2
100: , x_msg_count out nocopy NUMBER
101: , x_msg_data out nocopy VARCHAR2
102: , p5_a0 JTF_NUMBER_TABLE
103: , p5_a1 JTF_NUMBER_TABLE
104: , p5_a2 JTF_NUMBER_TABLE
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_NUMBER_TABLE

Line 103: , p5_a1 JTF_NUMBER_TABLE

99: , x_return_status out nocopy VARCHAR2
100: , x_msg_count out nocopy NUMBER
101: , x_msg_data out nocopy VARCHAR2
102: , p5_a0 JTF_NUMBER_TABLE
103: , p5_a1 JTF_NUMBER_TABLE
104: , p5_a2 JTF_NUMBER_TABLE
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_NUMBER_TABLE
107: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 104: , p5_a2 JTF_NUMBER_TABLE

100: , x_msg_count out nocopy NUMBER
101: , x_msg_data out nocopy VARCHAR2
102: , p5_a0 JTF_NUMBER_TABLE
103: , p5_a1 JTF_NUMBER_TABLE
104: , p5_a2 JTF_NUMBER_TABLE
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_NUMBER_TABLE
107: , p5_a5 JTF_VARCHAR2_TABLE_100
108: , p5_a6 JTF_NUMBER_TABLE

Line 105: , p5_a3 JTF_NUMBER_TABLE

101: , x_msg_data out nocopy VARCHAR2
102: , p5_a0 JTF_NUMBER_TABLE
103: , p5_a1 JTF_NUMBER_TABLE
104: , p5_a2 JTF_NUMBER_TABLE
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_NUMBER_TABLE
107: , p5_a5 JTF_VARCHAR2_TABLE_100
108: , p5_a6 JTF_NUMBER_TABLE
109: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 106: , p5_a4 JTF_NUMBER_TABLE

102: , p5_a0 JTF_NUMBER_TABLE
103: , p5_a1 JTF_NUMBER_TABLE
104: , p5_a2 JTF_NUMBER_TABLE
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_NUMBER_TABLE
107: , p5_a5 JTF_VARCHAR2_TABLE_100
108: , p5_a6 JTF_NUMBER_TABLE
109: , p5_a7 JTF_VARCHAR2_TABLE_100
110: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 108: , p5_a6 JTF_NUMBER_TABLE

104: , p5_a2 JTF_NUMBER_TABLE
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_NUMBER_TABLE
107: , p5_a5 JTF_VARCHAR2_TABLE_100
108: , p5_a6 JTF_NUMBER_TABLE
109: , p5_a7 JTF_VARCHAR2_TABLE_100
110: , p5_a8 JTF_VARCHAR2_TABLE_100
111: , p5_a9 JTF_VARCHAR2_TABLE_200
112: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 116: , p5_a14 JTF_NUMBER_TABLE

112: , p5_a10 JTF_VARCHAR2_TABLE_100
113: , p5_a11 JTF_VARCHAR2_TABLE_100
114: , p5_a12 JTF_VARCHAR2_TABLE_200
115: , p5_a13 JTF_VARCHAR2_TABLE_100
116: , p5_a14 JTF_NUMBER_TABLE
117: , p5_a15 JTF_VARCHAR2_TABLE_100
118: , p5_a16 JTF_VARCHAR2_TABLE_100
119: , p5_a17 JTF_NUMBER_TABLE
120: , p5_a18 JTF_NUMBER_TABLE

Line 119: , p5_a17 JTF_NUMBER_TABLE

115: , p5_a13 JTF_VARCHAR2_TABLE_100
116: , p5_a14 JTF_NUMBER_TABLE
117: , p5_a15 JTF_VARCHAR2_TABLE_100
118: , p5_a16 JTF_VARCHAR2_TABLE_100
119: , p5_a17 JTF_NUMBER_TABLE
120: , p5_a18 JTF_NUMBER_TABLE
121: , p5_a19 JTF_VARCHAR2_TABLE_100
122: , p5_a20 JTF_VARCHAR2_TABLE_500
123: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 120: , p5_a18 JTF_NUMBER_TABLE

116: , p5_a14 JTF_NUMBER_TABLE
117: , p5_a15 JTF_VARCHAR2_TABLE_100
118: , p5_a16 JTF_VARCHAR2_TABLE_100
119: , p5_a17 JTF_NUMBER_TABLE
120: , p5_a18 JTF_NUMBER_TABLE
121: , p5_a19 JTF_VARCHAR2_TABLE_100
122: , p5_a20 JTF_VARCHAR2_TABLE_500
123: , p5_a21 JTF_VARCHAR2_TABLE_500
124: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 137: , p5_a35 JTF_NUMBER_TABLE

133: , p5_a31 JTF_VARCHAR2_TABLE_500
134: , p5_a32 JTF_VARCHAR2_TABLE_500
135: , p5_a33 JTF_VARCHAR2_TABLE_500
136: , p5_a34 JTF_VARCHAR2_TABLE_500
137: , p5_a35 JTF_NUMBER_TABLE
138: , p5_a36 JTF_DATE_TABLE
139: , p5_a37 JTF_NUMBER_TABLE
140: , p5_a38 JTF_DATE_TABLE
141: , p5_a39 JTF_NUMBER_TABLE

Line 139: , p5_a37 JTF_NUMBER_TABLE

135: , p5_a33 JTF_VARCHAR2_TABLE_500
136: , p5_a34 JTF_VARCHAR2_TABLE_500
137: , p5_a35 JTF_NUMBER_TABLE
138: , p5_a36 JTF_DATE_TABLE
139: , p5_a37 JTF_NUMBER_TABLE
140: , p5_a38 JTF_DATE_TABLE
141: , p5_a39 JTF_NUMBER_TABLE
142: , p5_a40 JTF_NUMBER_TABLE
143: , p5_a41 JTF_NUMBER_TABLE

Line 141: , p5_a39 JTF_NUMBER_TABLE

137: , p5_a35 JTF_NUMBER_TABLE
138: , p5_a36 JTF_DATE_TABLE
139: , p5_a37 JTF_NUMBER_TABLE
140: , p5_a38 JTF_DATE_TABLE
141: , p5_a39 JTF_NUMBER_TABLE
142: , p5_a40 JTF_NUMBER_TABLE
143: , p5_a41 JTF_NUMBER_TABLE
144: , p5_a42 JTF_VARCHAR2_TABLE_100
145: , p5_a43 JTF_NUMBER_TABLE

Line 142: , p5_a40 JTF_NUMBER_TABLE

138: , p5_a36 JTF_DATE_TABLE
139: , p5_a37 JTF_NUMBER_TABLE
140: , p5_a38 JTF_DATE_TABLE
141: , p5_a39 JTF_NUMBER_TABLE
142: , p5_a40 JTF_NUMBER_TABLE
143: , p5_a41 JTF_NUMBER_TABLE
144: , p5_a42 JTF_VARCHAR2_TABLE_100
145: , p5_a43 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 143: , p5_a41 JTF_NUMBER_TABLE

139: , p5_a37 JTF_NUMBER_TABLE
140: , p5_a38 JTF_DATE_TABLE
141: , p5_a39 JTF_NUMBER_TABLE
142: , p5_a40 JTF_NUMBER_TABLE
143: , p5_a41 JTF_NUMBER_TABLE
144: , p5_a42 JTF_VARCHAR2_TABLE_100
145: , p5_a43 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 145: , p5_a43 JTF_NUMBER_TABLE

141: , p5_a39 JTF_NUMBER_TABLE
142: , p5_a40 JTF_NUMBER_TABLE
143: , p5_a41 JTF_NUMBER_TABLE
144: , p5_a42 JTF_VARCHAR2_TABLE_100
145: , p5_a43 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 146: , p6_a0 out nocopy JTF_NUMBER_TABLE

142: , p5_a40 JTF_NUMBER_TABLE
143: , p5_a41 JTF_NUMBER_TABLE
144: , p5_a42 JTF_VARCHAR2_TABLE_100
145: , p5_a43 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_NUMBER_TABLE
150: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 147: , p6_a1 out nocopy JTF_NUMBER_TABLE

143: , p5_a41 JTF_NUMBER_TABLE
144: , p5_a42 JTF_VARCHAR2_TABLE_100
145: , p5_a43 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_NUMBER_TABLE
150: , p6_a4 out nocopy JTF_NUMBER_TABLE
151: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 148: , p6_a2 out nocopy JTF_NUMBER_TABLE

144: , p5_a42 JTF_VARCHAR2_TABLE_100
145: , p5_a43 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_NUMBER_TABLE
150: , p6_a4 out nocopy JTF_NUMBER_TABLE
151: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 149: , p6_a3 out nocopy JTF_NUMBER_TABLE

145: , p5_a43 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_NUMBER_TABLE
150: , p6_a4 out nocopy JTF_NUMBER_TABLE
151: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , p6_a6 out nocopy JTF_NUMBER_TABLE
153: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 150: , p6_a4 out nocopy JTF_NUMBER_TABLE

146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_NUMBER_TABLE
150: , p6_a4 out nocopy JTF_NUMBER_TABLE
151: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , p6_a6 out nocopy JTF_NUMBER_TABLE
153: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 152: , p6_a6 out nocopy JTF_NUMBER_TABLE

148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_NUMBER_TABLE
150: , p6_a4 out nocopy JTF_NUMBER_TABLE
151: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , p6_a6 out nocopy JTF_NUMBER_TABLE
153: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
156: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 160: , p6_a14 out nocopy JTF_NUMBER_TABLE

156: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
157: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
158: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
159: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a14 out nocopy JTF_NUMBER_TABLE
161: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
163: , p6_a17 out nocopy JTF_NUMBER_TABLE
164: , p6_a18 out nocopy JTF_NUMBER_TABLE

Line 163: , p6_a17 out nocopy JTF_NUMBER_TABLE

159: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a14 out nocopy JTF_NUMBER_TABLE
161: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
163: , p6_a17 out nocopy JTF_NUMBER_TABLE
164: , p6_a18 out nocopy JTF_NUMBER_TABLE
165: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
167: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 164: , p6_a18 out nocopy JTF_NUMBER_TABLE

160: , p6_a14 out nocopy JTF_NUMBER_TABLE
161: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
163: , p6_a17 out nocopy JTF_NUMBER_TABLE
164: , p6_a18 out nocopy JTF_NUMBER_TABLE
165: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
167: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
168: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500

Line 181: , p6_a35 out nocopy JTF_NUMBER_TABLE

177: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
178: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
179: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
180: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
181: , p6_a35 out nocopy JTF_NUMBER_TABLE
182: , p6_a36 out nocopy JTF_DATE_TABLE
183: , p6_a37 out nocopy JTF_NUMBER_TABLE
184: , p6_a38 out nocopy JTF_DATE_TABLE
185: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 183: , p6_a37 out nocopy JTF_NUMBER_TABLE

179: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
180: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
181: , p6_a35 out nocopy JTF_NUMBER_TABLE
182: , p6_a36 out nocopy JTF_DATE_TABLE
183: , p6_a37 out nocopy JTF_NUMBER_TABLE
184: , p6_a38 out nocopy JTF_DATE_TABLE
185: , p6_a39 out nocopy JTF_NUMBER_TABLE
186: , p6_a40 out nocopy JTF_NUMBER_TABLE
187: , p6_a41 out nocopy JTF_NUMBER_TABLE

Line 185: , p6_a39 out nocopy JTF_NUMBER_TABLE

181: , p6_a35 out nocopy JTF_NUMBER_TABLE
182: , p6_a36 out nocopy JTF_DATE_TABLE
183: , p6_a37 out nocopy JTF_NUMBER_TABLE
184: , p6_a38 out nocopy JTF_DATE_TABLE
185: , p6_a39 out nocopy JTF_NUMBER_TABLE
186: , p6_a40 out nocopy JTF_NUMBER_TABLE
187: , p6_a41 out nocopy JTF_NUMBER_TABLE
188: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
189: , p6_a43 out nocopy JTF_NUMBER_TABLE

Line 186: , p6_a40 out nocopy JTF_NUMBER_TABLE

182: , p6_a36 out nocopy JTF_DATE_TABLE
183: , p6_a37 out nocopy JTF_NUMBER_TABLE
184: , p6_a38 out nocopy JTF_DATE_TABLE
185: , p6_a39 out nocopy JTF_NUMBER_TABLE
186: , p6_a40 out nocopy JTF_NUMBER_TABLE
187: , p6_a41 out nocopy JTF_NUMBER_TABLE
188: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
189: , p6_a43 out nocopy JTF_NUMBER_TABLE
190: );

Line 187: , p6_a41 out nocopy JTF_NUMBER_TABLE

183: , p6_a37 out nocopy JTF_NUMBER_TABLE
184: , p6_a38 out nocopy JTF_DATE_TABLE
185: , p6_a39 out nocopy JTF_NUMBER_TABLE
186: , p6_a40 out nocopy JTF_NUMBER_TABLE
187: , p6_a41 out nocopy JTF_NUMBER_TABLE
188: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
189: , p6_a43 out nocopy JTF_NUMBER_TABLE
190: );
191: procedure lock_txl_itm_insts(p_api_version NUMBER

Line 189: , p6_a43 out nocopy JTF_NUMBER_TABLE

185: , p6_a39 out nocopy JTF_NUMBER_TABLE
186: , p6_a40 out nocopy JTF_NUMBER_TABLE
187: , p6_a41 out nocopy JTF_NUMBER_TABLE
188: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
189: , p6_a43 out nocopy JTF_NUMBER_TABLE
190: );
191: procedure lock_txl_itm_insts(p_api_version NUMBER
192: , p_init_msg_list VARCHAR2
193: , x_return_status out nocopy VARCHAR2

Line 246: , p5_a0 JTF_NUMBER_TABLE

242: , p_init_msg_list VARCHAR2
243: , x_return_status out nocopy VARCHAR2
244: , x_msg_count out nocopy NUMBER
245: , x_msg_data out nocopy VARCHAR2
246: , p5_a0 JTF_NUMBER_TABLE
247: , p5_a1 JTF_NUMBER_TABLE
248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_NUMBER_TABLE
250: , p5_a4 JTF_NUMBER_TABLE

Line 247: , p5_a1 JTF_NUMBER_TABLE

243: , x_return_status out nocopy VARCHAR2
244: , x_msg_count out nocopy NUMBER
245: , x_msg_data out nocopy VARCHAR2
246: , p5_a0 JTF_NUMBER_TABLE
247: , p5_a1 JTF_NUMBER_TABLE
248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_NUMBER_TABLE
250: , p5_a4 JTF_NUMBER_TABLE
251: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 248: , p5_a2 JTF_NUMBER_TABLE

244: , x_msg_count out nocopy NUMBER
245: , x_msg_data out nocopy VARCHAR2
246: , p5_a0 JTF_NUMBER_TABLE
247: , p5_a1 JTF_NUMBER_TABLE
248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_NUMBER_TABLE
250: , p5_a4 JTF_NUMBER_TABLE
251: , p5_a5 JTF_VARCHAR2_TABLE_100
252: , p5_a6 JTF_NUMBER_TABLE

Line 249: , p5_a3 JTF_NUMBER_TABLE

245: , x_msg_data out nocopy VARCHAR2
246: , p5_a0 JTF_NUMBER_TABLE
247: , p5_a1 JTF_NUMBER_TABLE
248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_NUMBER_TABLE
250: , p5_a4 JTF_NUMBER_TABLE
251: , p5_a5 JTF_VARCHAR2_TABLE_100
252: , p5_a6 JTF_NUMBER_TABLE
253: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 250: , p5_a4 JTF_NUMBER_TABLE

246: , p5_a0 JTF_NUMBER_TABLE
247: , p5_a1 JTF_NUMBER_TABLE
248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_NUMBER_TABLE
250: , p5_a4 JTF_NUMBER_TABLE
251: , p5_a5 JTF_VARCHAR2_TABLE_100
252: , p5_a6 JTF_NUMBER_TABLE
253: , p5_a7 JTF_VARCHAR2_TABLE_100
254: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 252: , p5_a6 JTF_NUMBER_TABLE

248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_NUMBER_TABLE
250: , p5_a4 JTF_NUMBER_TABLE
251: , p5_a5 JTF_VARCHAR2_TABLE_100
252: , p5_a6 JTF_NUMBER_TABLE
253: , p5_a7 JTF_VARCHAR2_TABLE_100
254: , p5_a8 JTF_VARCHAR2_TABLE_100
255: , p5_a9 JTF_VARCHAR2_TABLE_200
256: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 260: , p5_a14 JTF_NUMBER_TABLE

256: , p5_a10 JTF_VARCHAR2_TABLE_100
257: , p5_a11 JTF_VARCHAR2_TABLE_100
258: , p5_a12 JTF_VARCHAR2_TABLE_200
259: , p5_a13 JTF_VARCHAR2_TABLE_100
260: , p5_a14 JTF_NUMBER_TABLE
261: , p5_a15 JTF_VARCHAR2_TABLE_100
262: , p5_a16 JTF_VARCHAR2_TABLE_100
263: , p5_a17 JTF_NUMBER_TABLE
264: , p5_a18 JTF_NUMBER_TABLE

Line 263: , p5_a17 JTF_NUMBER_TABLE

259: , p5_a13 JTF_VARCHAR2_TABLE_100
260: , p5_a14 JTF_NUMBER_TABLE
261: , p5_a15 JTF_VARCHAR2_TABLE_100
262: , p5_a16 JTF_VARCHAR2_TABLE_100
263: , p5_a17 JTF_NUMBER_TABLE
264: , p5_a18 JTF_NUMBER_TABLE
265: , p5_a19 JTF_VARCHAR2_TABLE_100
266: , p5_a20 JTF_VARCHAR2_TABLE_500
267: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 264: , p5_a18 JTF_NUMBER_TABLE

260: , p5_a14 JTF_NUMBER_TABLE
261: , p5_a15 JTF_VARCHAR2_TABLE_100
262: , p5_a16 JTF_VARCHAR2_TABLE_100
263: , p5_a17 JTF_NUMBER_TABLE
264: , p5_a18 JTF_NUMBER_TABLE
265: , p5_a19 JTF_VARCHAR2_TABLE_100
266: , p5_a20 JTF_VARCHAR2_TABLE_500
267: , p5_a21 JTF_VARCHAR2_TABLE_500
268: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 281: , p5_a35 JTF_NUMBER_TABLE

277: , p5_a31 JTF_VARCHAR2_TABLE_500
278: , p5_a32 JTF_VARCHAR2_TABLE_500
279: , p5_a33 JTF_VARCHAR2_TABLE_500
280: , p5_a34 JTF_VARCHAR2_TABLE_500
281: , p5_a35 JTF_NUMBER_TABLE
282: , p5_a36 JTF_DATE_TABLE
283: , p5_a37 JTF_NUMBER_TABLE
284: , p5_a38 JTF_DATE_TABLE
285: , p5_a39 JTF_NUMBER_TABLE

Line 283: , p5_a37 JTF_NUMBER_TABLE

279: , p5_a33 JTF_VARCHAR2_TABLE_500
280: , p5_a34 JTF_VARCHAR2_TABLE_500
281: , p5_a35 JTF_NUMBER_TABLE
282: , p5_a36 JTF_DATE_TABLE
283: , p5_a37 JTF_NUMBER_TABLE
284: , p5_a38 JTF_DATE_TABLE
285: , p5_a39 JTF_NUMBER_TABLE
286: , p5_a40 JTF_NUMBER_TABLE
287: , p5_a41 JTF_NUMBER_TABLE

Line 285: , p5_a39 JTF_NUMBER_TABLE

281: , p5_a35 JTF_NUMBER_TABLE
282: , p5_a36 JTF_DATE_TABLE
283: , p5_a37 JTF_NUMBER_TABLE
284: , p5_a38 JTF_DATE_TABLE
285: , p5_a39 JTF_NUMBER_TABLE
286: , p5_a40 JTF_NUMBER_TABLE
287: , p5_a41 JTF_NUMBER_TABLE
288: , p5_a42 JTF_VARCHAR2_TABLE_100
289: , p5_a43 JTF_NUMBER_TABLE

Line 286: , p5_a40 JTF_NUMBER_TABLE

282: , p5_a36 JTF_DATE_TABLE
283: , p5_a37 JTF_NUMBER_TABLE
284: , p5_a38 JTF_DATE_TABLE
285: , p5_a39 JTF_NUMBER_TABLE
286: , p5_a40 JTF_NUMBER_TABLE
287: , p5_a41 JTF_NUMBER_TABLE
288: , p5_a42 JTF_VARCHAR2_TABLE_100
289: , p5_a43 JTF_NUMBER_TABLE
290: );

Line 287: , p5_a41 JTF_NUMBER_TABLE

283: , p5_a37 JTF_NUMBER_TABLE
284: , p5_a38 JTF_DATE_TABLE
285: , p5_a39 JTF_NUMBER_TABLE
286: , p5_a40 JTF_NUMBER_TABLE
287: , p5_a41 JTF_NUMBER_TABLE
288: , p5_a42 JTF_VARCHAR2_TABLE_100
289: , p5_a43 JTF_NUMBER_TABLE
290: );
291: procedure update_txl_itm_insts(p_api_version NUMBER

Line 289: , p5_a43 JTF_NUMBER_TABLE

285: , p5_a39 JTF_NUMBER_TABLE
286: , p5_a40 JTF_NUMBER_TABLE
287: , p5_a41 JTF_NUMBER_TABLE
288: , p5_a42 JTF_VARCHAR2_TABLE_100
289: , p5_a43 JTF_NUMBER_TABLE
290: );
291: procedure update_txl_itm_insts(p_api_version NUMBER
292: , p_init_msg_list VARCHAR2
293: , x_return_status out nocopy VARCHAR2

Line 390: , p5_a0 JTF_NUMBER_TABLE

386: , p_init_msg_list VARCHAR2
387: , x_return_status out nocopy VARCHAR2
388: , x_msg_count out nocopy NUMBER
389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_NUMBER_TABLE
394: , p5_a4 JTF_NUMBER_TABLE

Line 391: , p5_a1 JTF_NUMBER_TABLE

387: , x_return_status out nocopy VARCHAR2
388: , x_msg_count out nocopy NUMBER
389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_NUMBER_TABLE
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 392: , p5_a2 JTF_NUMBER_TABLE

388: , x_msg_count out nocopy NUMBER
389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_NUMBER_TABLE
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_VARCHAR2_TABLE_100
396: , p5_a6 JTF_NUMBER_TABLE

Line 393: , p5_a3 JTF_NUMBER_TABLE

389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_NUMBER_TABLE
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_VARCHAR2_TABLE_100
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 394: , p5_a4 JTF_NUMBER_TABLE

390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_NUMBER_TABLE
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_VARCHAR2_TABLE_100
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_VARCHAR2_TABLE_100
398: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 396: , p5_a6 JTF_NUMBER_TABLE

392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_NUMBER_TABLE
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_VARCHAR2_TABLE_100
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_VARCHAR2_TABLE_100
398: , p5_a8 JTF_VARCHAR2_TABLE_100
399: , p5_a9 JTF_VARCHAR2_TABLE_200
400: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 404: , p5_a14 JTF_NUMBER_TABLE

400: , p5_a10 JTF_VARCHAR2_TABLE_100
401: , p5_a11 JTF_VARCHAR2_TABLE_100
402: , p5_a12 JTF_VARCHAR2_TABLE_200
403: , p5_a13 JTF_VARCHAR2_TABLE_100
404: , p5_a14 JTF_NUMBER_TABLE
405: , p5_a15 JTF_VARCHAR2_TABLE_100
406: , p5_a16 JTF_VARCHAR2_TABLE_100
407: , p5_a17 JTF_NUMBER_TABLE
408: , p5_a18 JTF_NUMBER_TABLE

Line 407: , p5_a17 JTF_NUMBER_TABLE

403: , p5_a13 JTF_VARCHAR2_TABLE_100
404: , p5_a14 JTF_NUMBER_TABLE
405: , p5_a15 JTF_VARCHAR2_TABLE_100
406: , p5_a16 JTF_VARCHAR2_TABLE_100
407: , p5_a17 JTF_NUMBER_TABLE
408: , p5_a18 JTF_NUMBER_TABLE
409: , p5_a19 JTF_VARCHAR2_TABLE_100
410: , p5_a20 JTF_VARCHAR2_TABLE_500
411: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 408: , p5_a18 JTF_NUMBER_TABLE

404: , p5_a14 JTF_NUMBER_TABLE
405: , p5_a15 JTF_VARCHAR2_TABLE_100
406: , p5_a16 JTF_VARCHAR2_TABLE_100
407: , p5_a17 JTF_NUMBER_TABLE
408: , p5_a18 JTF_NUMBER_TABLE
409: , p5_a19 JTF_VARCHAR2_TABLE_100
410: , p5_a20 JTF_VARCHAR2_TABLE_500
411: , p5_a21 JTF_VARCHAR2_TABLE_500
412: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 425: , p5_a35 JTF_NUMBER_TABLE

421: , p5_a31 JTF_VARCHAR2_TABLE_500
422: , p5_a32 JTF_VARCHAR2_TABLE_500
423: , p5_a33 JTF_VARCHAR2_TABLE_500
424: , p5_a34 JTF_VARCHAR2_TABLE_500
425: , p5_a35 JTF_NUMBER_TABLE
426: , p5_a36 JTF_DATE_TABLE
427: , p5_a37 JTF_NUMBER_TABLE
428: , p5_a38 JTF_DATE_TABLE
429: , p5_a39 JTF_NUMBER_TABLE

Line 427: , p5_a37 JTF_NUMBER_TABLE

423: , p5_a33 JTF_VARCHAR2_TABLE_500
424: , p5_a34 JTF_VARCHAR2_TABLE_500
425: , p5_a35 JTF_NUMBER_TABLE
426: , p5_a36 JTF_DATE_TABLE
427: , p5_a37 JTF_NUMBER_TABLE
428: , p5_a38 JTF_DATE_TABLE
429: , p5_a39 JTF_NUMBER_TABLE
430: , p5_a40 JTF_NUMBER_TABLE
431: , p5_a41 JTF_NUMBER_TABLE

Line 429: , p5_a39 JTF_NUMBER_TABLE

425: , p5_a35 JTF_NUMBER_TABLE
426: , p5_a36 JTF_DATE_TABLE
427: , p5_a37 JTF_NUMBER_TABLE
428: , p5_a38 JTF_DATE_TABLE
429: , p5_a39 JTF_NUMBER_TABLE
430: , p5_a40 JTF_NUMBER_TABLE
431: , p5_a41 JTF_NUMBER_TABLE
432: , p5_a42 JTF_VARCHAR2_TABLE_100
433: , p5_a43 JTF_NUMBER_TABLE

Line 430: , p5_a40 JTF_NUMBER_TABLE

426: , p5_a36 JTF_DATE_TABLE
427: , p5_a37 JTF_NUMBER_TABLE
428: , p5_a38 JTF_DATE_TABLE
429: , p5_a39 JTF_NUMBER_TABLE
430: , p5_a40 JTF_NUMBER_TABLE
431: , p5_a41 JTF_NUMBER_TABLE
432: , p5_a42 JTF_VARCHAR2_TABLE_100
433: , p5_a43 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 431: , p5_a41 JTF_NUMBER_TABLE

427: , p5_a37 JTF_NUMBER_TABLE
428: , p5_a38 JTF_DATE_TABLE
429: , p5_a39 JTF_NUMBER_TABLE
430: , p5_a40 JTF_NUMBER_TABLE
431: , p5_a41 JTF_NUMBER_TABLE
432: , p5_a42 JTF_VARCHAR2_TABLE_100
433: , p5_a43 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 433: , p5_a43 JTF_NUMBER_TABLE

429: , p5_a39 JTF_NUMBER_TABLE
430: , p5_a40 JTF_NUMBER_TABLE
431: , p5_a41 JTF_NUMBER_TABLE
432: , p5_a42 JTF_VARCHAR2_TABLE_100
433: , p5_a43 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 434: , p6_a0 out nocopy JTF_NUMBER_TABLE

430: , p5_a40 JTF_NUMBER_TABLE
431: , p5_a41 JTF_NUMBER_TABLE
432: , p5_a42 JTF_VARCHAR2_TABLE_100
433: , p5_a43 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 435: , p6_a1 out nocopy JTF_NUMBER_TABLE

431: , p5_a41 JTF_NUMBER_TABLE
432: , p5_a42 JTF_VARCHAR2_TABLE_100
433: , p5_a43 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 436: , p6_a2 out nocopy JTF_NUMBER_TABLE

432: , p5_a42 JTF_VARCHAR2_TABLE_100
433: , p5_a43 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
440: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 437: , p6_a3 out nocopy JTF_NUMBER_TABLE

433: , p5_a43 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
441: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 438: , p6_a4 out nocopy JTF_NUMBER_TABLE

434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
441: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
442: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 440: , p6_a6 out nocopy JTF_NUMBER_TABLE

436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
441: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
442: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
443: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
444: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 448: , p6_a14 out nocopy JTF_NUMBER_TABLE

444: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
445: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
446: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
447: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
448: , p6_a14 out nocopy JTF_NUMBER_TABLE
449: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
451: , p6_a17 out nocopy JTF_NUMBER_TABLE
452: , p6_a18 out nocopy JTF_NUMBER_TABLE

Line 451: , p6_a17 out nocopy JTF_NUMBER_TABLE

447: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
448: , p6_a14 out nocopy JTF_NUMBER_TABLE
449: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
451: , p6_a17 out nocopy JTF_NUMBER_TABLE
452: , p6_a18 out nocopy JTF_NUMBER_TABLE
453: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
454: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
455: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 452: , p6_a18 out nocopy JTF_NUMBER_TABLE

448: , p6_a14 out nocopy JTF_NUMBER_TABLE
449: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
451: , p6_a17 out nocopy JTF_NUMBER_TABLE
452: , p6_a18 out nocopy JTF_NUMBER_TABLE
453: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
454: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
455: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
456: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500

Line 469: , p6_a35 out nocopy JTF_NUMBER_TABLE

465: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
466: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
467: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
468: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
469: , p6_a35 out nocopy JTF_NUMBER_TABLE
470: , p6_a36 out nocopy JTF_DATE_TABLE
471: , p6_a37 out nocopy JTF_NUMBER_TABLE
472: , p6_a38 out nocopy JTF_DATE_TABLE
473: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 471: , p6_a37 out nocopy JTF_NUMBER_TABLE

467: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
468: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
469: , p6_a35 out nocopy JTF_NUMBER_TABLE
470: , p6_a36 out nocopy JTF_DATE_TABLE
471: , p6_a37 out nocopy JTF_NUMBER_TABLE
472: , p6_a38 out nocopy JTF_DATE_TABLE
473: , p6_a39 out nocopy JTF_NUMBER_TABLE
474: , p6_a40 out nocopy JTF_NUMBER_TABLE
475: , p6_a41 out nocopy JTF_NUMBER_TABLE

Line 473: , p6_a39 out nocopy JTF_NUMBER_TABLE

469: , p6_a35 out nocopy JTF_NUMBER_TABLE
470: , p6_a36 out nocopy JTF_DATE_TABLE
471: , p6_a37 out nocopy JTF_NUMBER_TABLE
472: , p6_a38 out nocopy JTF_DATE_TABLE
473: , p6_a39 out nocopy JTF_NUMBER_TABLE
474: , p6_a40 out nocopy JTF_NUMBER_TABLE
475: , p6_a41 out nocopy JTF_NUMBER_TABLE
476: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a43 out nocopy JTF_NUMBER_TABLE

Line 474: , p6_a40 out nocopy JTF_NUMBER_TABLE

470: , p6_a36 out nocopy JTF_DATE_TABLE
471: , p6_a37 out nocopy JTF_NUMBER_TABLE
472: , p6_a38 out nocopy JTF_DATE_TABLE
473: , p6_a39 out nocopy JTF_NUMBER_TABLE
474: , p6_a40 out nocopy JTF_NUMBER_TABLE
475: , p6_a41 out nocopy JTF_NUMBER_TABLE
476: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a43 out nocopy JTF_NUMBER_TABLE
478: );

Line 475: , p6_a41 out nocopy JTF_NUMBER_TABLE

471: , p6_a37 out nocopy JTF_NUMBER_TABLE
472: , p6_a38 out nocopy JTF_DATE_TABLE
473: , p6_a39 out nocopy JTF_NUMBER_TABLE
474: , p6_a40 out nocopy JTF_NUMBER_TABLE
475: , p6_a41 out nocopy JTF_NUMBER_TABLE
476: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a43 out nocopy JTF_NUMBER_TABLE
478: );
479: procedure delete_txl_itm_insts(p_api_version NUMBER

Line 477: , p6_a43 out nocopy JTF_NUMBER_TABLE

473: , p6_a39 out nocopy JTF_NUMBER_TABLE
474: , p6_a40 out nocopy JTF_NUMBER_TABLE
475: , p6_a41 out nocopy JTF_NUMBER_TABLE
476: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a43 out nocopy JTF_NUMBER_TABLE
478: );
479: procedure delete_txl_itm_insts(p_api_version NUMBER
480: , p_init_msg_list VARCHAR2
481: , x_return_status out nocopy VARCHAR2

Line 534: , p5_a0 JTF_NUMBER_TABLE

530: , p_init_msg_list VARCHAR2
531: , x_return_status out nocopy VARCHAR2
532: , x_msg_count out nocopy NUMBER
533: , x_msg_data out nocopy VARCHAR2
534: , p5_a0 JTF_NUMBER_TABLE
535: , p5_a1 JTF_NUMBER_TABLE
536: , p5_a2 JTF_NUMBER_TABLE
537: , p5_a3 JTF_NUMBER_TABLE
538: , p5_a4 JTF_NUMBER_TABLE

Line 535: , p5_a1 JTF_NUMBER_TABLE

531: , x_return_status out nocopy VARCHAR2
532: , x_msg_count out nocopy NUMBER
533: , x_msg_data out nocopy VARCHAR2
534: , p5_a0 JTF_NUMBER_TABLE
535: , p5_a1 JTF_NUMBER_TABLE
536: , p5_a2 JTF_NUMBER_TABLE
537: , p5_a3 JTF_NUMBER_TABLE
538: , p5_a4 JTF_NUMBER_TABLE
539: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 536: , p5_a2 JTF_NUMBER_TABLE

532: , x_msg_count out nocopy NUMBER
533: , x_msg_data out nocopy VARCHAR2
534: , p5_a0 JTF_NUMBER_TABLE
535: , p5_a1 JTF_NUMBER_TABLE
536: , p5_a2 JTF_NUMBER_TABLE
537: , p5_a3 JTF_NUMBER_TABLE
538: , p5_a4 JTF_NUMBER_TABLE
539: , p5_a5 JTF_VARCHAR2_TABLE_100
540: , p5_a6 JTF_NUMBER_TABLE

Line 537: , p5_a3 JTF_NUMBER_TABLE

533: , x_msg_data out nocopy VARCHAR2
534: , p5_a0 JTF_NUMBER_TABLE
535: , p5_a1 JTF_NUMBER_TABLE
536: , p5_a2 JTF_NUMBER_TABLE
537: , p5_a3 JTF_NUMBER_TABLE
538: , p5_a4 JTF_NUMBER_TABLE
539: , p5_a5 JTF_VARCHAR2_TABLE_100
540: , p5_a6 JTF_NUMBER_TABLE
541: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 538: , p5_a4 JTF_NUMBER_TABLE

534: , p5_a0 JTF_NUMBER_TABLE
535: , p5_a1 JTF_NUMBER_TABLE
536: , p5_a2 JTF_NUMBER_TABLE
537: , p5_a3 JTF_NUMBER_TABLE
538: , p5_a4 JTF_NUMBER_TABLE
539: , p5_a5 JTF_VARCHAR2_TABLE_100
540: , p5_a6 JTF_NUMBER_TABLE
541: , p5_a7 JTF_VARCHAR2_TABLE_100
542: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 540: , p5_a6 JTF_NUMBER_TABLE

536: , p5_a2 JTF_NUMBER_TABLE
537: , p5_a3 JTF_NUMBER_TABLE
538: , p5_a4 JTF_NUMBER_TABLE
539: , p5_a5 JTF_VARCHAR2_TABLE_100
540: , p5_a6 JTF_NUMBER_TABLE
541: , p5_a7 JTF_VARCHAR2_TABLE_100
542: , p5_a8 JTF_VARCHAR2_TABLE_100
543: , p5_a9 JTF_VARCHAR2_TABLE_200
544: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 548: , p5_a14 JTF_NUMBER_TABLE

544: , p5_a10 JTF_VARCHAR2_TABLE_100
545: , p5_a11 JTF_VARCHAR2_TABLE_100
546: , p5_a12 JTF_VARCHAR2_TABLE_200
547: , p5_a13 JTF_VARCHAR2_TABLE_100
548: , p5_a14 JTF_NUMBER_TABLE
549: , p5_a15 JTF_VARCHAR2_TABLE_100
550: , p5_a16 JTF_VARCHAR2_TABLE_100
551: , p5_a17 JTF_NUMBER_TABLE
552: , p5_a18 JTF_NUMBER_TABLE

Line 551: , p5_a17 JTF_NUMBER_TABLE

547: , p5_a13 JTF_VARCHAR2_TABLE_100
548: , p5_a14 JTF_NUMBER_TABLE
549: , p5_a15 JTF_VARCHAR2_TABLE_100
550: , p5_a16 JTF_VARCHAR2_TABLE_100
551: , p5_a17 JTF_NUMBER_TABLE
552: , p5_a18 JTF_NUMBER_TABLE
553: , p5_a19 JTF_VARCHAR2_TABLE_100
554: , p5_a20 JTF_VARCHAR2_TABLE_500
555: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 552: , p5_a18 JTF_NUMBER_TABLE

548: , p5_a14 JTF_NUMBER_TABLE
549: , p5_a15 JTF_VARCHAR2_TABLE_100
550: , p5_a16 JTF_VARCHAR2_TABLE_100
551: , p5_a17 JTF_NUMBER_TABLE
552: , p5_a18 JTF_NUMBER_TABLE
553: , p5_a19 JTF_VARCHAR2_TABLE_100
554: , p5_a20 JTF_VARCHAR2_TABLE_500
555: , p5_a21 JTF_VARCHAR2_TABLE_500
556: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 569: , p5_a35 JTF_NUMBER_TABLE

565: , p5_a31 JTF_VARCHAR2_TABLE_500
566: , p5_a32 JTF_VARCHAR2_TABLE_500
567: , p5_a33 JTF_VARCHAR2_TABLE_500
568: , p5_a34 JTF_VARCHAR2_TABLE_500
569: , p5_a35 JTF_NUMBER_TABLE
570: , p5_a36 JTF_DATE_TABLE
571: , p5_a37 JTF_NUMBER_TABLE
572: , p5_a38 JTF_DATE_TABLE
573: , p5_a39 JTF_NUMBER_TABLE

Line 571: , p5_a37 JTF_NUMBER_TABLE

567: , p5_a33 JTF_VARCHAR2_TABLE_500
568: , p5_a34 JTF_VARCHAR2_TABLE_500
569: , p5_a35 JTF_NUMBER_TABLE
570: , p5_a36 JTF_DATE_TABLE
571: , p5_a37 JTF_NUMBER_TABLE
572: , p5_a38 JTF_DATE_TABLE
573: , p5_a39 JTF_NUMBER_TABLE
574: , p5_a40 JTF_NUMBER_TABLE
575: , p5_a41 JTF_NUMBER_TABLE

Line 573: , p5_a39 JTF_NUMBER_TABLE

569: , p5_a35 JTF_NUMBER_TABLE
570: , p5_a36 JTF_DATE_TABLE
571: , p5_a37 JTF_NUMBER_TABLE
572: , p5_a38 JTF_DATE_TABLE
573: , p5_a39 JTF_NUMBER_TABLE
574: , p5_a40 JTF_NUMBER_TABLE
575: , p5_a41 JTF_NUMBER_TABLE
576: , p5_a42 JTF_VARCHAR2_TABLE_100
577: , p5_a43 JTF_NUMBER_TABLE

Line 574: , p5_a40 JTF_NUMBER_TABLE

570: , p5_a36 JTF_DATE_TABLE
571: , p5_a37 JTF_NUMBER_TABLE
572: , p5_a38 JTF_DATE_TABLE
573: , p5_a39 JTF_NUMBER_TABLE
574: , p5_a40 JTF_NUMBER_TABLE
575: , p5_a41 JTF_NUMBER_TABLE
576: , p5_a42 JTF_VARCHAR2_TABLE_100
577: , p5_a43 JTF_NUMBER_TABLE
578: );

Line 575: , p5_a41 JTF_NUMBER_TABLE

571: , p5_a37 JTF_NUMBER_TABLE
572: , p5_a38 JTF_DATE_TABLE
573: , p5_a39 JTF_NUMBER_TABLE
574: , p5_a40 JTF_NUMBER_TABLE
575: , p5_a41 JTF_NUMBER_TABLE
576: , p5_a42 JTF_VARCHAR2_TABLE_100
577: , p5_a43 JTF_NUMBER_TABLE
578: );
579: procedure validate_txl_itm_insts(p_api_version NUMBER

Line 577: , p5_a43 JTF_NUMBER_TABLE

573: , p5_a39 JTF_NUMBER_TABLE
574: , p5_a40 JTF_NUMBER_TABLE
575: , p5_a41 JTF_NUMBER_TABLE
576: , p5_a42 JTF_VARCHAR2_TABLE_100
577: , p5_a43 JTF_NUMBER_TABLE
578: );
579: procedure validate_txl_itm_insts(p_api_version NUMBER
580: , p_init_msg_list VARCHAR2
581: , x_return_status out nocopy VARCHAR2

Line 634: , p5_a0 JTF_NUMBER_TABLE

630: , p_init_msg_list VARCHAR2
631: , x_return_status out nocopy VARCHAR2
632: , x_msg_count out nocopy NUMBER
633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_NUMBER_TABLE
636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_NUMBER_TABLE

Line 635: , p5_a1 JTF_NUMBER_TABLE

631: , x_return_status out nocopy VARCHAR2
632: , x_msg_count out nocopy NUMBER
633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_NUMBER_TABLE
636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_NUMBER_TABLE
639: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 636: , p5_a2 JTF_NUMBER_TABLE

632: , x_msg_count out nocopy NUMBER
633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_NUMBER_TABLE
636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_NUMBER_TABLE
639: , p5_a5 JTF_VARCHAR2_TABLE_100
640: , p5_a6 JTF_NUMBER_TABLE

Line 637: , p5_a3 JTF_NUMBER_TABLE

633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_NUMBER_TABLE
636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_NUMBER_TABLE
639: , p5_a5 JTF_VARCHAR2_TABLE_100
640: , p5_a6 JTF_NUMBER_TABLE
641: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 638: , p5_a4 JTF_NUMBER_TABLE

634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_NUMBER_TABLE
636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_NUMBER_TABLE
639: , p5_a5 JTF_VARCHAR2_TABLE_100
640: , p5_a6 JTF_NUMBER_TABLE
641: , p5_a7 JTF_VARCHAR2_TABLE_100
642: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 640: , p5_a6 JTF_NUMBER_TABLE

636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_NUMBER_TABLE
639: , p5_a5 JTF_VARCHAR2_TABLE_100
640: , p5_a6 JTF_NUMBER_TABLE
641: , p5_a7 JTF_VARCHAR2_TABLE_100
642: , p5_a8 JTF_VARCHAR2_TABLE_100
643: , p5_a9 JTF_VARCHAR2_TABLE_200
644: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 648: , p5_a14 JTF_NUMBER_TABLE

644: , p5_a10 JTF_VARCHAR2_TABLE_100
645: , p5_a11 JTF_VARCHAR2_TABLE_100
646: , p5_a12 JTF_VARCHAR2_TABLE_200
647: , p5_a13 JTF_VARCHAR2_TABLE_100
648: , p5_a14 JTF_NUMBER_TABLE
649: , p5_a15 JTF_VARCHAR2_TABLE_100
650: , p5_a16 JTF_VARCHAR2_TABLE_100
651: , p5_a17 JTF_NUMBER_TABLE
652: , p5_a18 JTF_NUMBER_TABLE

Line 651: , p5_a17 JTF_NUMBER_TABLE

647: , p5_a13 JTF_VARCHAR2_TABLE_100
648: , p5_a14 JTF_NUMBER_TABLE
649: , p5_a15 JTF_VARCHAR2_TABLE_100
650: , p5_a16 JTF_VARCHAR2_TABLE_100
651: , p5_a17 JTF_NUMBER_TABLE
652: , p5_a18 JTF_NUMBER_TABLE
653: , p5_a19 JTF_VARCHAR2_TABLE_100
654: , p5_a20 JTF_VARCHAR2_TABLE_500
655: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 652: , p5_a18 JTF_NUMBER_TABLE

648: , p5_a14 JTF_NUMBER_TABLE
649: , p5_a15 JTF_VARCHAR2_TABLE_100
650: , p5_a16 JTF_VARCHAR2_TABLE_100
651: , p5_a17 JTF_NUMBER_TABLE
652: , p5_a18 JTF_NUMBER_TABLE
653: , p5_a19 JTF_VARCHAR2_TABLE_100
654: , p5_a20 JTF_VARCHAR2_TABLE_500
655: , p5_a21 JTF_VARCHAR2_TABLE_500
656: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 669: , p5_a35 JTF_NUMBER_TABLE

665: , p5_a31 JTF_VARCHAR2_TABLE_500
666: , p5_a32 JTF_VARCHAR2_TABLE_500
667: , p5_a33 JTF_VARCHAR2_TABLE_500
668: , p5_a34 JTF_VARCHAR2_TABLE_500
669: , p5_a35 JTF_NUMBER_TABLE
670: , p5_a36 JTF_DATE_TABLE
671: , p5_a37 JTF_NUMBER_TABLE
672: , p5_a38 JTF_DATE_TABLE
673: , p5_a39 JTF_NUMBER_TABLE

Line 671: , p5_a37 JTF_NUMBER_TABLE

667: , p5_a33 JTF_VARCHAR2_TABLE_500
668: , p5_a34 JTF_VARCHAR2_TABLE_500
669: , p5_a35 JTF_NUMBER_TABLE
670: , p5_a36 JTF_DATE_TABLE
671: , p5_a37 JTF_NUMBER_TABLE
672: , p5_a38 JTF_DATE_TABLE
673: , p5_a39 JTF_NUMBER_TABLE
674: , p5_a40 JTF_NUMBER_TABLE
675: , p5_a41 JTF_NUMBER_TABLE

Line 673: , p5_a39 JTF_NUMBER_TABLE

669: , p5_a35 JTF_NUMBER_TABLE
670: , p5_a36 JTF_DATE_TABLE
671: , p5_a37 JTF_NUMBER_TABLE
672: , p5_a38 JTF_DATE_TABLE
673: , p5_a39 JTF_NUMBER_TABLE
674: , p5_a40 JTF_NUMBER_TABLE
675: , p5_a41 JTF_NUMBER_TABLE
676: , p5_a42 JTF_VARCHAR2_TABLE_100
677: , p5_a43 JTF_NUMBER_TABLE

Line 674: , p5_a40 JTF_NUMBER_TABLE

670: , p5_a36 JTF_DATE_TABLE
671: , p5_a37 JTF_NUMBER_TABLE
672: , p5_a38 JTF_DATE_TABLE
673: , p5_a39 JTF_NUMBER_TABLE
674: , p5_a40 JTF_NUMBER_TABLE
675: , p5_a41 JTF_NUMBER_TABLE
676: , p5_a42 JTF_VARCHAR2_TABLE_100
677: , p5_a43 JTF_NUMBER_TABLE
678: );

Line 675: , p5_a41 JTF_NUMBER_TABLE

671: , p5_a37 JTF_NUMBER_TABLE
672: , p5_a38 JTF_DATE_TABLE
673: , p5_a39 JTF_NUMBER_TABLE
674: , p5_a40 JTF_NUMBER_TABLE
675: , p5_a41 JTF_NUMBER_TABLE
676: , p5_a42 JTF_VARCHAR2_TABLE_100
677: , p5_a43 JTF_NUMBER_TABLE
678: );
679: end okl_txl_itm_insts_pvt_w;

Line 677: , p5_a43 JTF_NUMBER_TABLE

673: , p5_a39 JTF_NUMBER_TABLE
674: , p5_a40 JTF_NUMBER_TABLE
675: , p5_a41 JTF_NUMBER_TABLE
676: , p5_a42 JTF_VARCHAR2_TABLE_100
677: , p5_a43 JTF_NUMBER_TABLE
678: );
679: end okl_txl_itm_insts_pvt_w;