APPS.OKL_TXL_ITM_INSTS_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 107: , p5_a5 JTF_VARCHAR2_TABLE_100

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
111: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 109: , p5_a7 JTF_VARCHAR2_TABLE_100

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
113: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 110: , p5_a8 JTF_VARCHAR2_TABLE_100

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
113: , p5_a11 JTF_VARCHAR2_TABLE_100
114: , p5_a12 JTF_VARCHAR2_TABLE_200

Line 112: , p5_a10 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
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

Line 113: , p5_a11 JTF_VARCHAR2_TABLE_100

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
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

Line 115: , p5_a13 JTF_VARCHAR2_TABLE_100

111: , p5_a9 JTF_VARCHAR2_TABLE_200
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

Line 117: , p5_a15 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
121: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 118: , p5_a16 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
121: , p5_a19 JTF_VARCHAR2_TABLE_100
122: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 121: , p5_a19 JTF_VARCHAR2_TABLE_100

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
125: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 144: , p5_a42 JTF_VARCHAR2_TABLE_100

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
148: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 151: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
155: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 153: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

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
157: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

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
157: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
158: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 156: , p6_a10 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
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

Line 157: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 159: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

155: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
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

Line 161: , p6_a15 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
165: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 162: , p6_a16 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
165: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 165: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

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
169: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 188: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

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 update_txl_itm_insts(p_api_version NUMBER
192: , p_init_msg_list VARCHAR2

Line 295: , p5_a5 JTF_VARCHAR2_TABLE_100

291: , p5_a1 JTF_NUMBER_TABLE
292: , p5_a2 JTF_NUMBER_TABLE
293: , p5_a3 JTF_NUMBER_TABLE
294: , p5_a4 JTF_NUMBER_TABLE
295: , p5_a5 JTF_VARCHAR2_TABLE_100
296: , p5_a6 JTF_NUMBER_TABLE
297: , p5_a7 JTF_VARCHAR2_TABLE_100
298: , p5_a8 JTF_VARCHAR2_TABLE_100
299: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 297: , p5_a7 JTF_VARCHAR2_TABLE_100

293: , p5_a3 JTF_NUMBER_TABLE
294: , p5_a4 JTF_NUMBER_TABLE
295: , p5_a5 JTF_VARCHAR2_TABLE_100
296: , p5_a6 JTF_NUMBER_TABLE
297: , p5_a7 JTF_VARCHAR2_TABLE_100
298: , p5_a8 JTF_VARCHAR2_TABLE_100
299: , p5_a9 JTF_VARCHAR2_TABLE_200
300: , p5_a10 JTF_VARCHAR2_TABLE_100
301: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 298: , p5_a8 JTF_VARCHAR2_TABLE_100

294: , p5_a4 JTF_NUMBER_TABLE
295: , p5_a5 JTF_VARCHAR2_TABLE_100
296: , p5_a6 JTF_NUMBER_TABLE
297: , p5_a7 JTF_VARCHAR2_TABLE_100
298: , p5_a8 JTF_VARCHAR2_TABLE_100
299: , p5_a9 JTF_VARCHAR2_TABLE_200
300: , p5_a10 JTF_VARCHAR2_TABLE_100
301: , p5_a11 JTF_VARCHAR2_TABLE_100
302: , p5_a12 JTF_VARCHAR2_TABLE_200

Line 300: , p5_a10 JTF_VARCHAR2_TABLE_100

296: , p5_a6 JTF_NUMBER_TABLE
297: , p5_a7 JTF_VARCHAR2_TABLE_100
298: , p5_a8 JTF_VARCHAR2_TABLE_100
299: , p5_a9 JTF_VARCHAR2_TABLE_200
300: , p5_a10 JTF_VARCHAR2_TABLE_100
301: , p5_a11 JTF_VARCHAR2_TABLE_100
302: , p5_a12 JTF_VARCHAR2_TABLE_200
303: , p5_a13 JTF_VARCHAR2_TABLE_100
304: , p5_a14 JTF_NUMBER_TABLE

Line 301: , p5_a11 JTF_VARCHAR2_TABLE_100

297: , p5_a7 JTF_VARCHAR2_TABLE_100
298: , p5_a8 JTF_VARCHAR2_TABLE_100
299: , p5_a9 JTF_VARCHAR2_TABLE_200
300: , p5_a10 JTF_VARCHAR2_TABLE_100
301: , p5_a11 JTF_VARCHAR2_TABLE_100
302: , p5_a12 JTF_VARCHAR2_TABLE_200
303: , p5_a13 JTF_VARCHAR2_TABLE_100
304: , p5_a14 JTF_NUMBER_TABLE
305: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 303: , p5_a13 JTF_VARCHAR2_TABLE_100

299: , p5_a9 JTF_VARCHAR2_TABLE_200
300: , p5_a10 JTF_VARCHAR2_TABLE_100
301: , p5_a11 JTF_VARCHAR2_TABLE_100
302: , p5_a12 JTF_VARCHAR2_TABLE_200
303: , p5_a13 JTF_VARCHAR2_TABLE_100
304: , p5_a14 JTF_NUMBER_TABLE
305: , p5_a15 JTF_VARCHAR2_TABLE_100
306: , p5_a16 JTF_VARCHAR2_TABLE_100
307: , p5_a17 JTF_NUMBER_TABLE

Line 305: , p5_a15 JTF_VARCHAR2_TABLE_100

301: , p5_a11 JTF_VARCHAR2_TABLE_100
302: , p5_a12 JTF_VARCHAR2_TABLE_200
303: , p5_a13 JTF_VARCHAR2_TABLE_100
304: , p5_a14 JTF_NUMBER_TABLE
305: , p5_a15 JTF_VARCHAR2_TABLE_100
306: , p5_a16 JTF_VARCHAR2_TABLE_100
307: , p5_a17 JTF_NUMBER_TABLE
308: , p5_a18 JTF_NUMBER_TABLE
309: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 306: , p5_a16 JTF_VARCHAR2_TABLE_100

302: , p5_a12 JTF_VARCHAR2_TABLE_200
303: , p5_a13 JTF_VARCHAR2_TABLE_100
304: , p5_a14 JTF_NUMBER_TABLE
305: , p5_a15 JTF_VARCHAR2_TABLE_100
306: , p5_a16 JTF_VARCHAR2_TABLE_100
307: , p5_a17 JTF_NUMBER_TABLE
308: , p5_a18 JTF_NUMBER_TABLE
309: , p5_a19 JTF_VARCHAR2_TABLE_100
310: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 309: , p5_a19 JTF_VARCHAR2_TABLE_100

305: , p5_a15 JTF_VARCHAR2_TABLE_100
306: , p5_a16 JTF_VARCHAR2_TABLE_100
307: , p5_a17 JTF_NUMBER_TABLE
308: , p5_a18 JTF_NUMBER_TABLE
309: , p5_a19 JTF_VARCHAR2_TABLE_100
310: , p5_a20 JTF_VARCHAR2_TABLE_500
311: , p5_a21 JTF_VARCHAR2_TABLE_500
312: , p5_a22 JTF_VARCHAR2_TABLE_500
313: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 332: , p5_a42 JTF_VARCHAR2_TABLE_100

328: , p5_a38 JTF_DATE_TABLE
329: , p5_a39 JTF_NUMBER_TABLE
330: , p5_a40 JTF_NUMBER_TABLE
331: , p5_a41 JTF_NUMBER_TABLE
332: , p5_a42 JTF_VARCHAR2_TABLE_100
333: , p5_a43 JTF_NUMBER_TABLE
334: , p6_a0 out nocopy JTF_NUMBER_TABLE
335: , p6_a1 out nocopy JTF_NUMBER_TABLE
336: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 339: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

335: , p6_a1 out nocopy JTF_NUMBER_TABLE
336: , p6_a2 out nocopy JTF_NUMBER_TABLE
337: , p6_a3 out nocopy JTF_NUMBER_TABLE
338: , p6_a4 out nocopy JTF_NUMBER_TABLE
339: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
340: , p6_a6 out nocopy JTF_NUMBER_TABLE
341: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 341: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

337: , p6_a3 out nocopy JTF_NUMBER_TABLE
338: , p6_a4 out nocopy JTF_NUMBER_TABLE
339: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
340: , p6_a6 out nocopy JTF_NUMBER_TABLE
341: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
344: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 342: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

338: , p6_a4 out nocopy JTF_NUMBER_TABLE
339: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
340: , p6_a6 out nocopy JTF_NUMBER_TABLE
341: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
344: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 344: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

340: , p6_a6 out nocopy JTF_NUMBER_TABLE
341: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
344: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
347: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 345: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

341: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
344: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
347: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a14 out nocopy JTF_NUMBER_TABLE
349: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 347: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

343: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
344: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
347: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a14 out nocopy JTF_NUMBER_TABLE
349: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
350: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a17 out nocopy JTF_NUMBER_TABLE

Line 349: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

345: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
347: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a14 out nocopy JTF_NUMBER_TABLE
349: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
350: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a17 out nocopy JTF_NUMBER_TABLE
352: , p6_a18 out nocopy JTF_NUMBER_TABLE
353: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 350: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

346: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
347: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a14 out nocopy JTF_NUMBER_TABLE
349: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
350: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a17 out nocopy JTF_NUMBER_TABLE
352: , p6_a18 out nocopy JTF_NUMBER_TABLE
353: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
354: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 353: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

349: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
350: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a17 out nocopy JTF_NUMBER_TABLE
352: , p6_a18 out nocopy JTF_NUMBER_TABLE
353: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
354: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
355: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
356: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
357: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 376: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

372: , p6_a38 out nocopy JTF_DATE_TABLE
373: , p6_a39 out nocopy JTF_NUMBER_TABLE
374: , p6_a40 out nocopy JTF_NUMBER_TABLE
375: , p6_a41 out nocopy JTF_NUMBER_TABLE
376: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
377: , p6_a43 out nocopy JTF_NUMBER_TABLE
378: );
379: procedure delete_txl_itm_insts(p_api_version NUMBER
380: , p_init_msg_list VARCHAR2

Line 439: , p5_a5 JTF_VARCHAR2_TABLE_100

435: , p5_a1 JTF_NUMBER_TABLE
436: , p5_a2 JTF_NUMBER_TABLE
437: , p5_a3 JTF_NUMBER_TABLE
438: , p5_a4 JTF_NUMBER_TABLE
439: , p5_a5 JTF_VARCHAR2_TABLE_100
440: , p5_a6 JTF_NUMBER_TABLE
441: , p5_a7 JTF_VARCHAR2_TABLE_100
442: , p5_a8 JTF_VARCHAR2_TABLE_100
443: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 441: , p5_a7 JTF_VARCHAR2_TABLE_100

437: , p5_a3 JTF_NUMBER_TABLE
438: , p5_a4 JTF_NUMBER_TABLE
439: , p5_a5 JTF_VARCHAR2_TABLE_100
440: , p5_a6 JTF_NUMBER_TABLE
441: , p5_a7 JTF_VARCHAR2_TABLE_100
442: , p5_a8 JTF_VARCHAR2_TABLE_100
443: , p5_a9 JTF_VARCHAR2_TABLE_200
444: , p5_a10 JTF_VARCHAR2_TABLE_100
445: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 442: , p5_a8 JTF_VARCHAR2_TABLE_100

438: , p5_a4 JTF_NUMBER_TABLE
439: , p5_a5 JTF_VARCHAR2_TABLE_100
440: , p5_a6 JTF_NUMBER_TABLE
441: , p5_a7 JTF_VARCHAR2_TABLE_100
442: , p5_a8 JTF_VARCHAR2_TABLE_100
443: , p5_a9 JTF_VARCHAR2_TABLE_200
444: , p5_a10 JTF_VARCHAR2_TABLE_100
445: , p5_a11 JTF_VARCHAR2_TABLE_100
446: , p5_a12 JTF_VARCHAR2_TABLE_200

Line 444: , p5_a10 JTF_VARCHAR2_TABLE_100

440: , p5_a6 JTF_NUMBER_TABLE
441: , p5_a7 JTF_VARCHAR2_TABLE_100
442: , p5_a8 JTF_VARCHAR2_TABLE_100
443: , p5_a9 JTF_VARCHAR2_TABLE_200
444: , p5_a10 JTF_VARCHAR2_TABLE_100
445: , p5_a11 JTF_VARCHAR2_TABLE_100
446: , p5_a12 JTF_VARCHAR2_TABLE_200
447: , p5_a13 JTF_VARCHAR2_TABLE_100
448: , p5_a14 JTF_NUMBER_TABLE

Line 445: , p5_a11 JTF_VARCHAR2_TABLE_100

441: , p5_a7 JTF_VARCHAR2_TABLE_100
442: , p5_a8 JTF_VARCHAR2_TABLE_100
443: , p5_a9 JTF_VARCHAR2_TABLE_200
444: , p5_a10 JTF_VARCHAR2_TABLE_100
445: , p5_a11 JTF_VARCHAR2_TABLE_100
446: , p5_a12 JTF_VARCHAR2_TABLE_200
447: , p5_a13 JTF_VARCHAR2_TABLE_100
448: , p5_a14 JTF_NUMBER_TABLE
449: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 447: , p5_a13 JTF_VARCHAR2_TABLE_100

443: , p5_a9 JTF_VARCHAR2_TABLE_200
444: , p5_a10 JTF_VARCHAR2_TABLE_100
445: , p5_a11 JTF_VARCHAR2_TABLE_100
446: , p5_a12 JTF_VARCHAR2_TABLE_200
447: , p5_a13 JTF_VARCHAR2_TABLE_100
448: , p5_a14 JTF_NUMBER_TABLE
449: , p5_a15 JTF_VARCHAR2_TABLE_100
450: , p5_a16 JTF_VARCHAR2_TABLE_100
451: , p5_a17 JTF_NUMBER_TABLE

Line 449: , p5_a15 JTF_VARCHAR2_TABLE_100

445: , p5_a11 JTF_VARCHAR2_TABLE_100
446: , p5_a12 JTF_VARCHAR2_TABLE_200
447: , p5_a13 JTF_VARCHAR2_TABLE_100
448: , p5_a14 JTF_NUMBER_TABLE
449: , p5_a15 JTF_VARCHAR2_TABLE_100
450: , p5_a16 JTF_VARCHAR2_TABLE_100
451: , p5_a17 JTF_NUMBER_TABLE
452: , p5_a18 JTF_NUMBER_TABLE
453: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 450: , p5_a16 JTF_VARCHAR2_TABLE_100

446: , p5_a12 JTF_VARCHAR2_TABLE_200
447: , p5_a13 JTF_VARCHAR2_TABLE_100
448: , p5_a14 JTF_NUMBER_TABLE
449: , p5_a15 JTF_VARCHAR2_TABLE_100
450: , p5_a16 JTF_VARCHAR2_TABLE_100
451: , p5_a17 JTF_NUMBER_TABLE
452: , p5_a18 JTF_NUMBER_TABLE
453: , p5_a19 JTF_VARCHAR2_TABLE_100
454: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 453: , p5_a19 JTF_VARCHAR2_TABLE_100

449: , p5_a15 JTF_VARCHAR2_TABLE_100
450: , p5_a16 JTF_VARCHAR2_TABLE_100
451: , p5_a17 JTF_NUMBER_TABLE
452: , p5_a18 JTF_NUMBER_TABLE
453: , p5_a19 JTF_VARCHAR2_TABLE_100
454: , p5_a20 JTF_VARCHAR2_TABLE_500
455: , p5_a21 JTF_VARCHAR2_TABLE_500
456: , p5_a22 JTF_VARCHAR2_TABLE_500
457: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 476: , p5_a42 JTF_VARCHAR2_TABLE_100

472: , p5_a38 JTF_DATE_TABLE
473: , p5_a39 JTF_NUMBER_TABLE
474: , p5_a40 JTF_NUMBER_TABLE
475: , p5_a41 JTF_NUMBER_TABLE
476: , p5_a42 JTF_VARCHAR2_TABLE_100
477: , p5_a43 JTF_NUMBER_TABLE
478: );
479: procedure lock_txl_itm_insts(p_api_version NUMBER
480: , p_init_msg_list VARCHAR2

Line 539: , p5_a5 JTF_VARCHAR2_TABLE_100

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
543: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 541: , p5_a7 JTF_VARCHAR2_TABLE_100

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
545: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 542: , p5_a8 JTF_VARCHAR2_TABLE_100

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
545: , p5_a11 JTF_VARCHAR2_TABLE_100
546: , p5_a12 JTF_VARCHAR2_TABLE_200

Line 544: , p5_a10 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
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

Line 545: , p5_a11 JTF_VARCHAR2_TABLE_100

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
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

Line 547: , p5_a13 JTF_VARCHAR2_TABLE_100

543: , p5_a9 JTF_VARCHAR2_TABLE_200
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

Line 549: , p5_a15 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
553: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 550: , p5_a16 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
553: , p5_a19 JTF_VARCHAR2_TABLE_100
554: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 553: , p5_a19 JTF_VARCHAR2_TABLE_100

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
557: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 576: , p5_a42 JTF_VARCHAR2_TABLE_100

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
580: , p_init_msg_list VARCHAR2

Line 639: , p5_a5 JTF_VARCHAR2_TABLE_100

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
643: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 641: , p5_a7 JTF_VARCHAR2_TABLE_100

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
645: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 642: , p5_a8 JTF_VARCHAR2_TABLE_100

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
645: , p5_a11 JTF_VARCHAR2_TABLE_100
646: , p5_a12 JTF_VARCHAR2_TABLE_200

Line 644: , p5_a10 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
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

Line 645: , p5_a11 JTF_VARCHAR2_TABLE_100

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
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

Line 647: , p5_a13 JTF_VARCHAR2_TABLE_100

643: , p5_a9 JTF_VARCHAR2_TABLE_200
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

Line 649: , p5_a15 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
653: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 650: , p5_a16 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
653: , p5_a19 JTF_VARCHAR2_TABLE_100
654: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 653: , p5_a19 JTF_VARCHAR2_TABLE_100

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
657: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 676: , p5_a42 JTF_VARCHAR2_TABLE_100

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_pub_w;