APPS.OKL_TXL_ITM_INSTS_PVT_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 lock_txl_itm_insts(p_api_version NUMBER
192: , p_init_msg_list VARCHAR2

Line 251: , p5_a5 JTF_VARCHAR2_TABLE_100

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

Line 253: , p5_a7 JTF_VARCHAR2_TABLE_100

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

Line 254: , p5_a8 JTF_VARCHAR2_TABLE_100

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
257: , p5_a11 JTF_VARCHAR2_TABLE_100
258: , p5_a12 JTF_VARCHAR2_TABLE_200

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

Line 257: , p5_a11 JTF_VARCHAR2_TABLE_100

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

Line 259: , p5_a13 JTF_VARCHAR2_TABLE_100

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

Line 261: , p5_a15 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
265: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 262: , p5_a16 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
265: , p5_a19 JTF_VARCHAR2_TABLE_100
266: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 265: , p5_a19 JTF_VARCHAR2_TABLE_100

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

Line 288: , p5_a42 JTF_VARCHAR2_TABLE_100

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

Line 395: , p5_a5 JTF_VARCHAR2_TABLE_100

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

Line 397: , p5_a7 JTF_VARCHAR2_TABLE_100

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

Line 398: , p5_a8 JTF_VARCHAR2_TABLE_100

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
401: , p5_a11 JTF_VARCHAR2_TABLE_100
402: , p5_a12 JTF_VARCHAR2_TABLE_200

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

Line 401: , p5_a11 JTF_VARCHAR2_TABLE_100

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

Line 403: , p5_a13 JTF_VARCHAR2_TABLE_100

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

Line 405: , p5_a15 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
409: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 406: , p5_a16 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
409: , p5_a19 JTF_VARCHAR2_TABLE_100
410: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 409: , p5_a19 JTF_VARCHAR2_TABLE_100

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

Line 432: , p5_a42 JTF_VARCHAR2_TABLE_100

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

Line 439: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 441: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 442: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

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

Line 445: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 447: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

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

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

Line 450: , p6_a16 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
453: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
454: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 453: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 476: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

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