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.AHL_PP_MATERIALS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pp_materials_pvt.req_material_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE

Line 29: , a13 JTF_VARCHAR2_TABLE_100

25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_300
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_DATE_TABLE

Line 34: , a18 JTF_VARCHAR2_TABLE_100

30: , a14 JTF_VARCHAR2_TABLE_300
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE

Line 35: , a19 JTF_VARCHAR2_TABLE_100

31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE

Line 37: , a21 JTF_VARCHAR2_TABLE_100

33: , a17 JTF_DATE_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE

Line 43: , a27 JTF_VARCHAR2_TABLE_100

39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_NUMBER_TABLE
43: , a27 JTF_VARCHAR2_TABLE_100
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE

Line 48: , a32 JTF_VARCHAR2_TABLE_100

44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_DATE_TABLE
52: , a36 JTF_DATE_TABLE

Line 53: , a37 JTF_VARCHAR2_TABLE_100

49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_DATE_TABLE
52: , a36 JTF_DATE_TABLE
53: , a37 JTF_VARCHAR2_TABLE_100
54: , a38 JTF_NUMBER_TABLE
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_NUMBER_TABLE
57: , a41 JTF_NUMBER_TABLE

Line 58: , a42 JTF_VARCHAR2_TABLE_100

54: , a38 JTF_NUMBER_TABLE
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_NUMBER_TABLE
57: , a41 JTF_NUMBER_TABLE
58: , a42 JTF_VARCHAR2_TABLE_100
59: , a43 JTF_VARCHAR2_TABLE_100
60: , a44 JTF_VARCHAR2_TABLE_200
61: , a45 JTF_VARCHAR2_TABLE_200
62: , a46 JTF_VARCHAR2_TABLE_200

Line 59: , a43 JTF_VARCHAR2_TABLE_100

55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_NUMBER_TABLE
57: , a41 JTF_NUMBER_TABLE
58: , a42 JTF_VARCHAR2_TABLE_100
59: , a43 JTF_VARCHAR2_TABLE_100
60: , a44 JTF_VARCHAR2_TABLE_200
61: , a45 JTF_VARCHAR2_TABLE_200
62: , a46 JTF_VARCHAR2_TABLE_200
63: , a47 JTF_VARCHAR2_TABLE_200

Line 77: , a61 JTF_VARCHAR2_TABLE_100

73: , a57 JTF_VARCHAR2_TABLE_200
74: , a58 JTF_VARCHAR2_TABLE_200
75: , a59 JTF_NUMBER_TABLE
76: , a60 JTF_VARCHAR2_TABLE_3000
77: , a61 JTF_VARCHAR2_TABLE_100
78: , a62 JTF_VARCHAR2_TABLE_100
79: ) as
80: ddindx binary_integer; indx binary_integer;
81: begin

Line 78: , a62 JTF_VARCHAR2_TABLE_100

74: , a58 JTF_VARCHAR2_TABLE_200
75: , a59 JTF_NUMBER_TABLE
76: , a60 JTF_VARCHAR2_TABLE_3000
77: , a61 JTF_VARCHAR2_TABLE_100
78: , a62 JTF_VARCHAR2_TABLE_100
79: ) as
80: ddindx binary_integer; indx binary_integer;
81: begin
82: if a0 is not null and a0.count > 0 then

Line 162: , a3 out nocopy JTF_VARCHAR2_TABLE_100

158: end rosetta_table_copy_in_p2;
159: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
160: , a1 out nocopy JTF_NUMBER_TABLE
161: , a2 out nocopy JTF_NUMBER_TABLE
162: , a3 out nocopy JTF_VARCHAR2_TABLE_100
163: , a4 out nocopy JTF_NUMBER_TABLE
164: , a5 out nocopy JTF_DATE_TABLE
165: , a6 out nocopy JTF_NUMBER_TABLE
166: , a7 out nocopy JTF_NUMBER_TABLE

Line 172: , a13 out nocopy JTF_VARCHAR2_TABLE_100

168: , a9 out nocopy JTF_NUMBER_TABLE
169: , a10 out nocopy JTF_NUMBER_TABLE
170: , a11 out nocopy JTF_VARCHAR2_TABLE_200
171: , a12 out nocopy JTF_NUMBER_TABLE
172: , a13 out nocopy JTF_VARCHAR2_TABLE_100
173: , a14 out nocopy JTF_VARCHAR2_TABLE_300
174: , a15 out nocopy JTF_NUMBER_TABLE
175: , a16 out nocopy JTF_NUMBER_TABLE
176: , a17 out nocopy JTF_DATE_TABLE

Line 177: , a18 out nocopy JTF_VARCHAR2_TABLE_100

173: , a14 out nocopy JTF_VARCHAR2_TABLE_300
174: , a15 out nocopy JTF_NUMBER_TABLE
175: , a16 out nocopy JTF_NUMBER_TABLE
176: , a17 out nocopy JTF_DATE_TABLE
177: , a18 out nocopy JTF_VARCHAR2_TABLE_100
178: , a19 out nocopy JTF_VARCHAR2_TABLE_100
179: , a20 out nocopy JTF_NUMBER_TABLE
180: , a21 out nocopy JTF_VARCHAR2_TABLE_100
181: , a22 out nocopy JTF_NUMBER_TABLE

Line 178: , a19 out nocopy JTF_VARCHAR2_TABLE_100

174: , a15 out nocopy JTF_NUMBER_TABLE
175: , a16 out nocopy JTF_NUMBER_TABLE
176: , a17 out nocopy JTF_DATE_TABLE
177: , a18 out nocopy JTF_VARCHAR2_TABLE_100
178: , a19 out nocopy JTF_VARCHAR2_TABLE_100
179: , a20 out nocopy JTF_NUMBER_TABLE
180: , a21 out nocopy JTF_VARCHAR2_TABLE_100
181: , a22 out nocopy JTF_NUMBER_TABLE
182: , a23 out nocopy JTF_NUMBER_TABLE

Line 180: , a21 out nocopy JTF_VARCHAR2_TABLE_100

176: , a17 out nocopy JTF_DATE_TABLE
177: , a18 out nocopy JTF_VARCHAR2_TABLE_100
178: , a19 out nocopy JTF_VARCHAR2_TABLE_100
179: , a20 out nocopy JTF_NUMBER_TABLE
180: , a21 out nocopy JTF_VARCHAR2_TABLE_100
181: , a22 out nocopy JTF_NUMBER_TABLE
182: , a23 out nocopy JTF_NUMBER_TABLE
183: , a24 out nocopy JTF_NUMBER_TABLE
184: , a25 out nocopy JTF_NUMBER_TABLE

Line 186: , a27 out nocopy JTF_VARCHAR2_TABLE_100

182: , a23 out nocopy JTF_NUMBER_TABLE
183: , a24 out nocopy JTF_NUMBER_TABLE
184: , a25 out nocopy JTF_NUMBER_TABLE
185: , a26 out nocopy JTF_NUMBER_TABLE
186: , a27 out nocopy JTF_VARCHAR2_TABLE_100
187: , a28 out nocopy JTF_NUMBER_TABLE
188: , a29 out nocopy JTF_NUMBER_TABLE
189: , a30 out nocopy JTF_NUMBER_TABLE
190: , a31 out nocopy JTF_NUMBER_TABLE

Line 191: , a32 out nocopy JTF_VARCHAR2_TABLE_100

187: , a28 out nocopy JTF_NUMBER_TABLE
188: , a29 out nocopy JTF_NUMBER_TABLE
189: , a30 out nocopy JTF_NUMBER_TABLE
190: , a31 out nocopy JTF_NUMBER_TABLE
191: , a32 out nocopy JTF_VARCHAR2_TABLE_100
192: , a33 out nocopy JTF_NUMBER_TABLE
193: , a34 out nocopy JTF_NUMBER_TABLE
194: , a35 out nocopy JTF_DATE_TABLE
195: , a36 out nocopy JTF_DATE_TABLE

Line 196: , a37 out nocopy JTF_VARCHAR2_TABLE_100

192: , a33 out nocopy JTF_NUMBER_TABLE
193: , a34 out nocopy JTF_NUMBER_TABLE
194: , a35 out nocopy JTF_DATE_TABLE
195: , a36 out nocopy JTF_DATE_TABLE
196: , a37 out nocopy JTF_VARCHAR2_TABLE_100
197: , a38 out nocopy JTF_NUMBER_TABLE
198: , a39 out nocopy JTF_NUMBER_TABLE
199: , a40 out nocopy JTF_NUMBER_TABLE
200: , a41 out nocopy JTF_NUMBER_TABLE

Line 201: , a42 out nocopy JTF_VARCHAR2_TABLE_100

197: , a38 out nocopy JTF_NUMBER_TABLE
198: , a39 out nocopy JTF_NUMBER_TABLE
199: , a40 out nocopy JTF_NUMBER_TABLE
200: , a41 out nocopy JTF_NUMBER_TABLE
201: , a42 out nocopy JTF_VARCHAR2_TABLE_100
202: , a43 out nocopy JTF_VARCHAR2_TABLE_100
203: , a44 out nocopy JTF_VARCHAR2_TABLE_200
204: , a45 out nocopy JTF_VARCHAR2_TABLE_200
205: , a46 out nocopy JTF_VARCHAR2_TABLE_200

Line 202: , a43 out nocopy JTF_VARCHAR2_TABLE_100

198: , a39 out nocopy JTF_NUMBER_TABLE
199: , a40 out nocopy JTF_NUMBER_TABLE
200: , a41 out nocopy JTF_NUMBER_TABLE
201: , a42 out nocopy JTF_VARCHAR2_TABLE_100
202: , a43 out nocopy JTF_VARCHAR2_TABLE_100
203: , a44 out nocopy JTF_VARCHAR2_TABLE_200
204: , a45 out nocopy JTF_VARCHAR2_TABLE_200
205: , a46 out nocopy JTF_VARCHAR2_TABLE_200
206: , a47 out nocopy JTF_VARCHAR2_TABLE_200

Line 220: , a61 out nocopy JTF_VARCHAR2_TABLE_100

216: , a57 out nocopy JTF_VARCHAR2_TABLE_200
217: , a58 out nocopy JTF_VARCHAR2_TABLE_200
218: , a59 out nocopy JTF_NUMBER_TABLE
219: , a60 out nocopy JTF_VARCHAR2_TABLE_3000
220: , a61 out nocopy JTF_VARCHAR2_TABLE_100
221: , a62 out nocopy JTF_VARCHAR2_TABLE_100
222: ) as
223: ddindx binary_integer; indx binary_integer;
224: begin

Line 221: , a62 out nocopy JTF_VARCHAR2_TABLE_100

217: , a58 out nocopy JTF_VARCHAR2_TABLE_200
218: , a59 out nocopy JTF_NUMBER_TABLE
219: , a60 out nocopy JTF_VARCHAR2_TABLE_3000
220: , a61 out nocopy JTF_VARCHAR2_TABLE_100
221: , a62 out nocopy JTF_VARCHAR2_TABLE_100
222: ) as
223: ddindx binary_integer; indx binary_integer;
224: begin
225: if t is null or t.count = 0 then

Line 229: a3 := JTF_VARCHAR2_TABLE_100();

225: if t is null or t.count = 0 then
226: a0 := JTF_NUMBER_TABLE();
227: a1 := JTF_NUMBER_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_NUMBER_TABLE();
231: a5 := JTF_DATE_TABLE();
232: a6 := JTF_NUMBER_TABLE();
233: a7 := JTF_NUMBER_TABLE();

Line 239: a13 := JTF_VARCHAR2_TABLE_100();

235: a9 := JTF_NUMBER_TABLE();
236: a10 := JTF_NUMBER_TABLE();
237: a11 := JTF_VARCHAR2_TABLE_200();
238: a12 := JTF_NUMBER_TABLE();
239: a13 := JTF_VARCHAR2_TABLE_100();
240: a14 := JTF_VARCHAR2_TABLE_300();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_NUMBER_TABLE();
243: a17 := JTF_DATE_TABLE();

Line 244: a18 := JTF_VARCHAR2_TABLE_100();

240: a14 := JTF_VARCHAR2_TABLE_300();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_NUMBER_TABLE();
243: a17 := JTF_DATE_TABLE();
244: a18 := JTF_VARCHAR2_TABLE_100();
245: a19 := JTF_VARCHAR2_TABLE_100();
246: a20 := JTF_NUMBER_TABLE();
247: a21 := JTF_VARCHAR2_TABLE_100();
248: a22 := JTF_NUMBER_TABLE();

Line 245: a19 := JTF_VARCHAR2_TABLE_100();

241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_NUMBER_TABLE();
243: a17 := JTF_DATE_TABLE();
244: a18 := JTF_VARCHAR2_TABLE_100();
245: a19 := JTF_VARCHAR2_TABLE_100();
246: a20 := JTF_NUMBER_TABLE();
247: a21 := JTF_VARCHAR2_TABLE_100();
248: a22 := JTF_NUMBER_TABLE();
249: a23 := JTF_NUMBER_TABLE();

Line 247: a21 := JTF_VARCHAR2_TABLE_100();

243: a17 := JTF_DATE_TABLE();
244: a18 := JTF_VARCHAR2_TABLE_100();
245: a19 := JTF_VARCHAR2_TABLE_100();
246: a20 := JTF_NUMBER_TABLE();
247: a21 := JTF_VARCHAR2_TABLE_100();
248: a22 := JTF_NUMBER_TABLE();
249: a23 := JTF_NUMBER_TABLE();
250: a24 := JTF_NUMBER_TABLE();
251: a25 := JTF_NUMBER_TABLE();

Line 253: a27 := JTF_VARCHAR2_TABLE_100();

249: a23 := JTF_NUMBER_TABLE();
250: a24 := JTF_NUMBER_TABLE();
251: a25 := JTF_NUMBER_TABLE();
252: a26 := JTF_NUMBER_TABLE();
253: a27 := JTF_VARCHAR2_TABLE_100();
254: a28 := JTF_NUMBER_TABLE();
255: a29 := JTF_NUMBER_TABLE();
256: a30 := JTF_NUMBER_TABLE();
257: a31 := JTF_NUMBER_TABLE();

Line 258: a32 := JTF_VARCHAR2_TABLE_100();

254: a28 := JTF_NUMBER_TABLE();
255: a29 := JTF_NUMBER_TABLE();
256: a30 := JTF_NUMBER_TABLE();
257: a31 := JTF_NUMBER_TABLE();
258: a32 := JTF_VARCHAR2_TABLE_100();
259: a33 := JTF_NUMBER_TABLE();
260: a34 := JTF_NUMBER_TABLE();
261: a35 := JTF_DATE_TABLE();
262: a36 := JTF_DATE_TABLE();

Line 263: a37 := JTF_VARCHAR2_TABLE_100();

259: a33 := JTF_NUMBER_TABLE();
260: a34 := JTF_NUMBER_TABLE();
261: a35 := JTF_DATE_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_VARCHAR2_TABLE_100();
264: a38 := JTF_NUMBER_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_NUMBER_TABLE();
267: a41 := JTF_NUMBER_TABLE();

Line 268: a42 := JTF_VARCHAR2_TABLE_100();

264: a38 := JTF_NUMBER_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_NUMBER_TABLE();
267: a41 := JTF_NUMBER_TABLE();
268: a42 := JTF_VARCHAR2_TABLE_100();
269: a43 := JTF_VARCHAR2_TABLE_100();
270: a44 := JTF_VARCHAR2_TABLE_200();
271: a45 := JTF_VARCHAR2_TABLE_200();
272: a46 := JTF_VARCHAR2_TABLE_200();

Line 269: a43 := JTF_VARCHAR2_TABLE_100();

265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_NUMBER_TABLE();
267: a41 := JTF_NUMBER_TABLE();
268: a42 := JTF_VARCHAR2_TABLE_100();
269: a43 := JTF_VARCHAR2_TABLE_100();
270: a44 := JTF_VARCHAR2_TABLE_200();
271: a45 := JTF_VARCHAR2_TABLE_200();
272: a46 := JTF_VARCHAR2_TABLE_200();
273: a47 := JTF_VARCHAR2_TABLE_200();

Line 287: a61 := JTF_VARCHAR2_TABLE_100();

283: a57 := JTF_VARCHAR2_TABLE_200();
284: a58 := JTF_VARCHAR2_TABLE_200();
285: a59 := JTF_NUMBER_TABLE();
286: a60 := JTF_VARCHAR2_TABLE_3000();
287: a61 := JTF_VARCHAR2_TABLE_100();
288: a62 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();

Line 288: a62 := JTF_VARCHAR2_TABLE_100();

284: a58 := JTF_VARCHAR2_TABLE_200();
285: a59 := JTF_NUMBER_TABLE();
286: a60 := JTF_VARCHAR2_TABLE_3000();
287: a61 := JTF_VARCHAR2_TABLE_100();
288: a62 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();

Line 293: a3 := JTF_VARCHAR2_TABLE_100();

289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_VARCHAR2_TABLE_100();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_DATE_TABLE();
296: a6 := JTF_NUMBER_TABLE();
297: a7 := JTF_NUMBER_TABLE();

Line 303: a13 := JTF_VARCHAR2_TABLE_100();

299: a9 := JTF_NUMBER_TABLE();
300: a10 := JTF_NUMBER_TABLE();
301: a11 := JTF_VARCHAR2_TABLE_200();
302: a12 := JTF_NUMBER_TABLE();
303: a13 := JTF_VARCHAR2_TABLE_100();
304: a14 := JTF_VARCHAR2_TABLE_300();
305: a15 := JTF_NUMBER_TABLE();
306: a16 := JTF_NUMBER_TABLE();
307: a17 := JTF_DATE_TABLE();

Line 308: a18 := JTF_VARCHAR2_TABLE_100();

304: a14 := JTF_VARCHAR2_TABLE_300();
305: a15 := JTF_NUMBER_TABLE();
306: a16 := JTF_NUMBER_TABLE();
307: a17 := JTF_DATE_TABLE();
308: a18 := JTF_VARCHAR2_TABLE_100();
309: a19 := JTF_VARCHAR2_TABLE_100();
310: a20 := JTF_NUMBER_TABLE();
311: a21 := JTF_VARCHAR2_TABLE_100();
312: a22 := JTF_NUMBER_TABLE();

Line 309: a19 := JTF_VARCHAR2_TABLE_100();

305: a15 := JTF_NUMBER_TABLE();
306: a16 := JTF_NUMBER_TABLE();
307: a17 := JTF_DATE_TABLE();
308: a18 := JTF_VARCHAR2_TABLE_100();
309: a19 := JTF_VARCHAR2_TABLE_100();
310: a20 := JTF_NUMBER_TABLE();
311: a21 := JTF_VARCHAR2_TABLE_100();
312: a22 := JTF_NUMBER_TABLE();
313: a23 := JTF_NUMBER_TABLE();

Line 311: a21 := JTF_VARCHAR2_TABLE_100();

307: a17 := JTF_DATE_TABLE();
308: a18 := JTF_VARCHAR2_TABLE_100();
309: a19 := JTF_VARCHAR2_TABLE_100();
310: a20 := JTF_NUMBER_TABLE();
311: a21 := JTF_VARCHAR2_TABLE_100();
312: a22 := JTF_NUMBER_TABLE();
313: a23 := JTF_NUMBER_TABLE();
314: a24 := JTF_NUMBER_TABLE();
315: a25 := JTF_NUMBER_TABLE();

Line 317: a27 := JTF_VARCHAR2_TABLE_100();

313: a23 := JTF_NUMBER_TABLE();
314: a24 := JTF_NUMBER_TABLE();
315: a25 := JTF_NUMBER_TABLE();
316: a26 := JTF_NUMBER_TABLE();
317: a27 := JTF_VARCHAR2_TABLE_100();
318: a28 := JTF_NUMBER_TABLE();
319: a29 := JTF_NUMBER_TABLE();
320: a30 := JTF_NUMBER_TABLE();
321: a31 := JTF_NUMBER_TABLE();

Line 322: a32 := JTF_VARCHAR2_TABLE_100();

318: a28 := JTF_NUMBER_TABLE();
319: a29 := JTF_NUMBER_TABLE();
320: a30 := JTF_NUMBER_TABLE();
321: a31 := JTF_NUMBER_TABLE();
322: a32 := JTF_VARCHAR2_TABLE_100();
323: a33 := JTF_NUMBER_TABLE();
324: a34 := JTF_NUMBER_TABLE();
325: a35 := JTF_DATE_TABLE();
326: a36 := JTF_DATE_TABLE();

Line 327: a37 := JTF_VARCHAR2_TABLE_100();

323: a33 := JTF_NUMBER_TABLE();
324: a34 := JTF_NUMBER_TABLE();
325: a35 := JTF_DATE_TABLE();
326: a36 := JTF_DATE_TABLE();
327: a37 := JTF_VARCHAR2_TABLE_100();
328: a38 := JTF_NUMBER_TABLE();
329: a39 := JTF_NUMBER_TABLE();
330: a40 := JTF_NUMBER_TABLE();
331: a41 := JTF_NUMBER_TABLE();

Line 332: a42 := JTF_VARCHAR2_TABLE_100();

328: a38 := JTF_NUMBER_TABLE();
329: a39 := JTF_NUMBER_TABLE();
330: a40 := JTF_NUMBER_TABLE();
331: a41 := JTF_NUMBER_TABLE();
332: a42 := JTF_VARCHAR2_TABLE_100();
333: a43 := JTF_VARCHAR2_TABLE_100();
334: a44 := JTF_VARCHAR2_TABLE_200();
335: a45 := JTF_VARCHAR2_TABLE_200();
336: a46 := JTF_VARCHAR2_TABLE_200();

Line 333: a43 := JTF_VARCHAR2_TABLE_100();

329: a39 := JTF_NUMBER_TABLE();
330: a40 := JTF_NUMBER_TABLE();
331: a41 := JTF_NUMBER_TABLE();
332: a42 := JTF_VARCHAR2_TABLE_100();
333: a43 := JTF_VARCHAR2_TABLE_100();
334: a44 := JTF_VARCHAR2_TABLE_200();
335: a45 := JTF_VARCHAR2_TABLE_200();
336: a46 := JTF_VARCHAR2_TABLE_200();
337: a47 := JTF_VARCHAR2_TABLE_200();

Line 351: a61 := JTF_VARCHAR2_TABLE_100();

347: a57 := JTF_VARCHAR2_TABLE_200();
348: a58 := JTF_VARCHAR2_TABLE_200();
349: a59 := JTF_NUMBER_TABLE();
350: a60 := JTF_VARCHAR2_TABLE_3000();
351: a61 := JTF_VARCHAR2_TABLE_100();
352: a62 := JTF_VARCHAR2_TABLE_100();
353: if t.count > 0 then
354: a0.extend(t.count);
355: a1.extend(t.count);

Line 352: a62 := JTF_VARCHAR2_TABLE_100();

348: a58 := JTF_VARCHAR2_TABLE_200();
349: a59 := JTF_NUMBER_TABLE();
350: a60 := JTF_VARCHAR2_TABLE_3000();
351: a61 := JTF_VARCHAR2_TABLE_100();
352: a62 := JTF_VARCHAR2_TABLE_100();
353: if t.count > 0 then
354: a0.extend(t.count);
355: a1.extend(t.count);
356: a2.extend(t.count);

Line 496: , a3 JTF_VARCHAR2_TABLE_100

492:
493: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: , a2 JTF_NUMBER_TABLE
496: , a3 JTF_VARCHAR2_TABLE_100
497: , a4 JTF_VARCHAR2_TABLE_300
498: , a5 JTF_NUMBER_TABLE
499: , a6 JTF_NUMBER_TABLE
500: , a7 JTF_NUMBER_TABLE

Line 505: , a12 JTF_VARCHAR2_TABLE_100

501: , a8 JTF_NUMBER_TABLE
502: , a9 JTF_NUMBER_TABLE
503: , a10 JTF_NUMBER_TABLE
504: , a11 JTF_DATE_TABLE
505: , a12 JTF_VARCHAR2_TABLE_100
506: , a13 JTF_NUMBER_TABLE
507: , a14 JTF_DATE_TABLE
508: , a15 JTF_NUMBER_TABLE
509: , a16 JTF_VARCHAR2_TABLE_100

Line 509: , a16 JTF_VARCHAR2_TABLE_100

505: , a12 JTF_VARCHAR2_TABLE_100
506: , a13 JTF_NUMBER_TABLE
507: , a14 JTF_DATE_TABLE
508: , a15 JTF_NUMBER_TABLE
509: , a16 JTF_VARCHAR2_TABLE_100
510: , a17 JTF_NUMBER_TABLE
511: , a18 JTF_NUMBER_TABLE
512: , a19 JTF_NUMBER_TABLE
513: , a20 JTF_NUMBER_TABLE

Line 514: , a21 JTF_VARCHAR2_TABLE_100

510: , a17 JTF_NUMBER_TABLE
511: , a18 JTF_NUMBER_TABLE
512: , a19 JTF_NUMBER_TABLE
513: , a20 JTF_NUMBER_TABLE
514: , a21 JTF_VARCHAR2_TABLE_100
515: , a22 JTF_NUMBER_TABLE
516: , a23 JTF_VARCHAR2_TABLE_100
517: ) as
518: ddindx binary_integer; indx binary_integer;

Line 516: , a23 JTF_VARCHAR2_TABLE_100

512: , a19 JTF_NUMBER_TABLE
513: , a20 JTF_NUMBER_TABLE
514: , a21 JTF_VARCHAR2_TABLE_100
515: , a22 JTF_NUMBER_TABLE
516: , a23 JTF_VARCHAR2_TABLE_100
517: ) as
518: ddindx binary_integer; indx binary_integer;
519: begin
520: if a0 is not null and a0.count > 0 then

Line 561: , a3 out nocopy JTF_VARCHAR2_TABLE_100

557: end rosetta_table_copy_in_p3;
558: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_NUMBER_TABLE
560: , a2 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_NUMBER_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE

Line 570: , a12 out nocopy JTF_VARCHAR2_TABLE_100

566: , a8 out nocopy JTF_NUMBER_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
568: , a10 out nocopy JTF_NUMBER_TABLE
569: , a11 out nocopy JTF_DATE_TABLE
570: , a12 out nocopy JTF_VARCHAR2_TABLE_100
571: , a13 out nocopy JTF_NUMBER_TABLE
572: , a14 out nocopy JTF_DATE_TABLE
573: , a15 out nocopy JTF_NUMBER_TABLE
574: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 574: , a16 out nocopy JTF_VARCHAR2_TABLE_100

570: , a12 out nocopy JTF_VARCHAR2_TABLE_100
571: , a13 out nocopy JTF_NUMBER_TABLE
572: , a14 out nocopy JTF_DATE_TABLE
573: , a15 out nocopy JTF_NUMBER_TABLE
574: , a16 out nocopy JTF_VARCHAR2_TABLE_100
575: , a17 out nocopy JTF_NUMBER_TABLE
576: , a18 out nocopy JTF_NUMBER_TABLE
577: , a19 out nocopy JTF_NUMBER_TABLE
578: , a20 out nocopy JTF_NUMBER_TABLE

Line 579: , a21 out nocopy JTF_VARCHAR2_TABLE_100

575: , a17 out nocopy JTF_NUMBER_TABLE
576: , a18 out nocopy JTF_NUMBER_TABLE
577: , a19 out nocopy JTF_NUMBER_TABLE
578: , a20 out nocopy JTF_NUMBER_TABLE
579: , a21 out nocopy JTF_VARCHAR2_TABLE_100
580: , a22 out nocopy JTF_NUMBER_TABLE
581: , a23 out nocopy JTF_VARCHAR2_TABLE_100
582: ) as
583: ddindx binary_integer; indx binary_integer;

Line 581: , a23 out nocopy JTF_VARCHAR2_TABLE_100

577: , a19 out nocopy JTF_NUMBER_TABLE
578: , a20 out nocopy JTF_NUMBER_TABLE
579: , a21 out nocopy JTF_VARCHAR2_TABLE_100
580: , a22 out nocopy JTF_NUMBER_TABLE
581: , a23 out nocopy JTF_VARCHAR2_TABLE_100
582: ) as
583: ddindx binary_integer; indx binary_integer;
584: begin
585: if t is null or t.count = 0 then

Line 589: a3 := JTF_VARCHAR2_TABLE_100();

585: if t is null or t.count = 0 then
586: a0 := JTF_NUMBER_TABLE();
587: a1 := JTF_NUMBER_TABLE();
588: a2 := JTF_NUMBER_TABLE();
589: a3 := JTF_VARCHAR2_TABLE_100();
590: a4 := JTF_VARCHAR2_TABLE_300();
591: a5 := JTF_NUMBER_TABLE();
592: a6 := JTF_NUMBER_TABLE();
593: a7 := JTF_NUMBER_TABLE();

Line 598: a12 := JTF_VARCHAR2_TABLE_100();

594: a8 := JTF_NUMBER_TABLE();
595: a9 := JTF_NUMBER_TABLE();
596: a10 := JTF_NUMBER_TABLE();
597: a11 := JTF_DATE_TABLE();
598: a12 := JTF_VARCHAR2_TABLE_100();
599: a13 := JTF_NUMBER_TABLE();
600: a14 := JTF_DATE_TABLE();
601: a15 := JTF_NUMBER_TABLE();
602: a16 := JTF_VARCHAR2_TABLE_100();

Line 602: a16 := JTF_VARCHAR2_TABLE_100();

598: a12 := JTF_VARCHAR2_TABLE_100();
599: a13 := JTF_NUMBER_TABLE();
600: a14 := JTF_DATE_TABLE();
601: a15 := JTF_NUMBER_TABLE();
602: a16 := JTF_VARCHAR2_TABLE_100();
603: a17 := JTF_NUMBER_TABLE();
604: a18 := JTF_NUMBER_TABLE();
605: a19 := JTF_NUMBER_TABLE();
606: a20 := JTF_NUMBER_TABLE();

Line 607: a21 := JTF_VARCHAR2_TABLE_100();

603: a17 := JTF_NUMBER_TABLE();
604: a18 := JTF_NUMBER_TABLE();
605: a19 := JTF_NUMBER_TABLE();
606: a20 := JTF_NUMBER_TABLE();
607: a21 := JTF_VARCHAR2_TABLE_100();
608: a22 := JTF_NUMBER_TABLE();
609: a23 := JTF_VARCHAR2_TABLE_100();
610: else
611: a0 := JTF_NUMBER_TABLE();

Line 609: a23 := JTF_VARCHAR2_TABLE_100();

605: a19 := JTF_NUMBER_TABLE();
606: a20 := JTF_NUMBER_TABLE();
607: a21 := JTF_VARCHAR2_TABLE_100();
608: a22 := JTF_NUMBER_TABLE();
609: a23 := JTF_VARCHAR2_TABLE_100();
610: else
611: a0 := JTF_NUMBER_TABLE();
612: a1 := JTF_NUMBER_TABLE();
613: a2 := JTF_NUMBER_TABLE();

Line 614: a3 := JTF_VARCHAR2_TABLE_100();

610: else
611: a0 := JTF_NUMBER_TABLE();
612: a1 := JTF_NUMBER_TABLE();
613: a2 := JTF_NUMBER_TABLE();
614: a3 := JTF_VARCHAR2_TABLE_100();
615: a4 := JTF_VARCHAR2_TABLE_300();
616: a5 := JTF_NUMBER_TABLE();
617: a6 := JTF_NUMBER_TABLE();
618: a7 := JTF_NUMBER_TABLE();

Line 623: a12 := JTF_VARCHAR2_TABLE_100();

619: a8 := JTF_NUMBER_TABLE();
620: a9 := JTF_NUMBER_TABLE();
621: a10 := JTF_NUMBER_TABLE();
622: a11 := JTF_DATE_TABLE();
623: a12 := JTF_VARCHAR2_TABLE_100();
624: a13 := JTF_NUMBER_TABLE();
625: a14 := JTF_DATE_TABLE();
626: a15 := JTF_NUMBER_TABLE();
627: a16 := JTF_VARCHAR2_TABLE_100();

Line 627: a16 := JTF_VARCHAR2_TABLE_100();

623: a12 := JTF_VARCHAR2_TABLE_100();
624: a13 := JTF_NUMBER_TABLE();
625: a14 := JTF_DATE_TABLE();
626: a15 := JTF_NUMBER_TABLE();
627: a16 := JTF_VARCHAR2_TABLE_100();
628: a17 := JTF_NUMBER_TABLE();
629: a18 := JTF_NUMBER_TABLE();
630: a19 := JTF_NUMBER_TABLE();
631: a20 := JTF_NUMBER_TABLE();

Line 632: a21 := JTF_VARCHAR2_TABLE_100();

628: a17 := JTF_NUMBER_TABLE();
629: a18 := JTF_NUMBER_TABLE();
630: a19 := JTF_NUMBER_TABLE();
631: a20 := JTF_NUMBER_TABLE();
632: a21 := JTF_VARCHAR2_TABLE_100();
633: a22 := JTF_NUMBER_TABLE();
634: a23 := JTF_VARCHAR2_TABLE_100();
635: if t.count > 0 then
636: a0.extend(t.count);

Line 634: a23 := JTF_VARCHAR2_TABLE_100();

630: a19 := JTF_NUMBER_TABLE();
631: a20 := JTF_NUMBER_TABLE();
632: a21 := JTF_VARCHAR2_TABLE_100();
633: a22 := JTF_NUMBER_TABLE();
634: a23 := JTF_VARCHAR2_TABLE_100();
635: if t.count > 0 then
636: a0.extend(t.count);
637: a1.extend(t.count);
638: a2.extend(t.count);

Line 705: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100

701: , p_interface_flag VARCHAR2
702: , p5_a0 in out nocopy JTF_NUMBER_TABLE
703: , p5_a1 in out nocopy JTF_NUMBER_TABLE
704: , p5_a2 in out nocopy JTF_NUMBER_TABLE
705: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a4 in out nocopy JTF_NUMBER_TABLE
707: , p5_a5 in out nocopy JTF_DATE_TABLE
708: , p5_a6 in out nocopy JTF_NUMBER_TABLE
709: , p5_a7 in out nocopy JTF_NUMBER_TABLE

Line 715: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100

711: , p5_a9 in out nocopy JTF_NUMBER_TABLE
712: , p5_a10 in out nocopy JTF_NUMBER_TABLE
713: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
714: , p5_a12 in out nocopy JTF_NUMBER_TABLE
715: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
717: , p5_a15 in out nocopy JTF_NUMBER_TABLE
718: , p5_a16 in out nocopy JTF_NUMBER_TABLE
719: , p5_a17 in out nocopy JTF_DATE_TABLE

Line 720: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100

716: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
717: , p5_a15 in out nocopy JTF_NUMBER_TABLE
718: , p5_a16 in out nocopy JTF_NUMBER_TABLE
719: , p5_a17 in out nocopy JTF_DATE_TABLE
720: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
721: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
722: , p5_a20 in out nocopy JTF_NUMBER_TABLE
723: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a22 in out nocopy JTF_NUMBER_TABLE

Line 721: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100

717: , p5_a15 in out nocopy JTF_NUMBER_TABLE
718: , p5_a16 in out nocopy JTF_NUMBER_TABLE
719: , p5_a17 in out nocopy JTF_DATE_TABLE
720: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
721: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
722: , p5_a20 in out nocopy JTF_NUMBER_TABLE
723: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a22 in out nocopy JTF_NUMBER_TABLE
725: , p5_a23 in out nocopy JTF_NUMBER_TABLE

Line 723: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100

719: , p5_a17 in out nocopy JTF_DATE_TABLE
720: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
721: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
722: , p5_a20 in out nocopy JTF_NUMBER_TABLE
723: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a22 in out nocopy JTF_NUMBER_TABLE
725: , p5_a23 in out nocopy JTF_NUMBER_TABLE
726: , p5_a24 in out nocopy JTF_NUMBER_TABLE
727: , p5_a25 in out nocopy JTF_NUMBER_TABLE

Line 729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100

725: , p5_a23 in out nocopy JTF_NUMBER_TABLE
726: , p5_a24 in out nocopy JTF_NUMBER_TABLE
727: , p5_a25 in out nocopy JTF_NUMBER_TABLE
728: , p5_a26 in out nocopy JTF_NUMBER_TABLE
729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p5_a28 in out nocopy JTF_NUMBER_TABLE
731: , p5_a29 in out nocopy JTF_NUMBER_TABLE
732: , p5_a30 in out nocopy JTF_NUMBER_TABLE
733: , p5_a31 in out nocopy JTF_NUMBER_TABLE

Line 734: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100

730: , p5_a28 in out nocopy JTF_NUMBER_TABLE
731: , p5_a29 in out nocopy JTF_NUMBER_TABLE
732: , p5_a30 in out nocopy JTF_NUMBER_TABLE
733: , p5_a31 in out nocopy JTF_NUMBER_TABLE
734: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
735: , p5_a33 in out nocopy JTF_NUMBER_TABLE
736: , p5_a34 in out nocopy JTF_NUMBER_TABLE
737: , p5_a35 in out nocopy JTF_DATE_TABLE
738: , p5_a36 in out nocopy JTF_DATE_TABLE

Line 739: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100

735: , p5_a33 in out nocopy JTF_NUMBER_TABLE
736: , p5_a34 in out nocopy JTF_NUMBER_TABLE
737: , p5_a35 in out nocopy JTF_DATE_TABLE
738: , p5_a36 in out nocopy JTF_DATE_TABLE
739: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
740: , p5_a38 in out nocopy JTF_NUMBER_TABLE
741: , p5_a39 in out nocopy JTF_NUMBER_TABLE
742: , p5_a40 in out nocopy JTF_NUMBER_TABLE
743: , p5_a41 in out nocopy JTF_NUMBER_TABLE

Line 744: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100

740: , p5_a38 in out nocopy JTF_NUMBER_TABLE
741: , p5_a39 in out nocopy JTF_NUMBER_TABLE
742: , p5_a40 in out nocopy JTF_NUMBER_TABLE
743: , p5_a41 in out nocopy JTF_NUMBER_TABLE
744: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
747: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
748: , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200

Line 745: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100

741: , p5_a39 in out nocopy JTF_NUMBER_TABLE
742: , p5_a40 in out nocopy JTF_NUMBER_TABLE
743: , p5_a41 in out nocopy JTF_NUMBER_TABLE
744: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
747: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
748: , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200
749: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_200

Line 763: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100

759: , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
760: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
761: , p5_a59 in out nocopy JTF_NUMBER_TABLE
762: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
763: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
764: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
765: , x_job_return_status out nocopy VARCHAR2
766: , x_return_status out nocopy VARCHAR2
767: , x_msg_count out nocopy NUMBER

Line 764: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100

760: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
761: , p5_a59 in out nocopy JTF_NUMBER_TABLE
762: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
763: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
764: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
765: , x_job_return_status out nocopy VARCHAR2
766: , x_return_status out nocopy VARCHAR2
767: , x_msg_count out nocopy NUMBER
768: , x_msg_data out nocopy VARCHAR2

Line 947: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100

943: , p_module_type VARCHAR2
944: , p5_a0 in out nocopy JTF_NUMBER_TABLE
945: , p5_a1 in out nocopy JTF_NUMBER_TABLE
946: , p5_a2 in out nocopy JTF_NUMBER_TABLE
947: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
948: , p5_a4 in out nocopy JTF_NUMBER_TABLE
949: , p5_a5 in out nocopy JTF_DATE_TABLE
950: , p5_a6 in out nocopy JTF_NUMBER_TABLE
951: , p5_a7 in out nocopy JTF_NUMBER_TABLE

Line 957: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100

953: , p5_a9 in out nocopy JTF_NUMBER_TABLE
954: , p5_a10 in out nocopy JTF_NUMBER_TABLE
955: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
956: , p5_a12 in out nocopy JTF_NUMBER_TABLE
957: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
958: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
959: , p5_a15 in out nocopy JTF_NUMBER_TABLE
960: , p5_a16 in out nocopy JTF_NUMBER_TABLE
961: , p5_a17 in out nocopy JTF_DATE_TABLE

Line 962: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100

958: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
959: , p5_a15 in out nocopy JTF_NUMBER_TABLE
960: , p5_a16 in out nocopy JTF_NUMBER_TABLE
961: , p5_a17 in out nocopy JTF_DATE_TABLE
962: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a20 in out nocopy JTF_NUMBER_TABLE
965: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a22 in out nocopy JTF_NUMBER_TABLE

Line 963: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100

959: , p5_a15 in out nocopy JTF_NUMBER_TABLE
960: , p5_a16 in out nocopy JTF_NUMBER_TABLE
961: , p5_a17 in out nocopy JTF_DATE_TABLE
962: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a20 in out nocopy JTF_NUMBER_TABLE
965: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a22 in out nocopy JTF_NUMBER_TABLE
967: , p5_a23 in out nocopy JTF_NUMBER_TABLE

Line 965: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100

961: , p5_a17 in out nocopy JTF_DATE_TABLE
962: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a20 in out nocopy JTF_NUMBER_TABLE
965: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a22 in out nocopy JTF_NUMBER_TABLE
967: , p5_a23 in out nocopy JTF_NUMBER_TABLE
968: , p5_a24 in out nocopy JTF_NUMBER_TABLE
969: , p5_a25 in out nocopy JTF_NUMBER_TABLE

Line 971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100

967: , p5_a23 in out nocopy JTF_NUMBER_TABLE
968: , p5_a24 in out nocopy JTF_NUMBER_TABLE
969: , p5_a25 in out nocopy JTF_NUMBER_TABLE
970: , p5_a26 in out nocopy JTF_NUMBER_TABLE
971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
972: , p5_a28 in out nocopy JTF_NUMBER_TABLE
973: , p5_a29 in out nocopy JTF_NUMBER_TABLE
974: , p5_a30 in out nocopy JTF_NUMBER_TABLE
975: , p5_a31 in out nocopy JTF_NUMBER_TABLE

Line 976: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100

972: , p5_a28 in out nocopy JTF_NUMBER_TABLE
973: , p5_a29 in out nocopy JTF_NUMBER_TABLE
974: , p5_a30 in out nocopy JTF_NUMBER_TABLE
975: , p5_a31 in out nocopy JTF_NUMBER_TABLE
976: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
977: , p5_a33 in out nocopy JTF_NUMBER_TABLE
978: , p5_a34 in out nocopy JTF_NUMBER_TABLE
979: , p5_a35 in out nocopy JTF_DATE_TABLE
980: , p5_a36 in out nocopy JTF_DATE_TABLE

Line 981: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100

977: , p5_a33 in out nocopy JTF_NUMBER_TABLE
978: , p5_a34 in out nocopy JTF_NUMBER_TABLE
979: , p5_a35 in out nocopy JTF_DATE_TABLE
980: , p5_a36 in out nocopy JTF_DATE_TABLE
981: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
982: , p5_a38 in out nocopy JTF_NUMBER_TABLE
983: , p5_a39 in out nocopy JTF_NUMBER_TABLE
984: , p5_a40 in out nocopy JTF_NUMBER_TABLE
985: , p5_a41 in out nocopy JTF_NUMBER_TABLE

Line 986: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100

982: , p5_a38 in out nocopy JTF_NUMBER_TABLE
983: , p5_a39 in out nocopy JTF_NUMBER_TABLE
984: , p5_a40 in out nocopy JTF_NUMBER_TABLE
985: , p5_a41 in out nocopy JTF_NUMBER_TABLE
986: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
987: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
988: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
989: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
990: , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200

Line 987: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100

983: , p5_a39 in out nocopy JTF_NUMBER_TABLE
984: , p5_a40 in out nocopy JTF_NUMBER_TABLE
985: , p5_a41 in out nocopy JTF_NUMBER_TABLE
986: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
987: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
988: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
989: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
990: , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200
991: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1005: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100

1001: , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
1002: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
1003: , p5_a59 in out nocopy JTF_NUMBER_TABLE
1004: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
1005: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
1006: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
1007: , x_return_status out nocopy VARCHAR2
1008: , x_msg_count out nocopy NUMBER
1009: , x_msg_data out nocopy VARCHAR2

Line 1006: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100

1002: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
1003: , p5_a59 in out nocopy JTF_NUMBER_TABLE
1004: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
1005: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
1006: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
1007: , x_return_status out nocopy VARCHAR2
1008: , x_msg_count out nocopy NUMBER
1009: , x_msg_data out nocopy VARCHAR2
1010: )

Line 1423: , p4_a3 JTF_VARCHAR2_TABLE_100

1419: , p_validation_level NUMBER
1420: , p4_a0 JTF_NUMBER_TABLE
1421: , p4_a1 JTF_NUMBER_TABLE
1422: , p4_a2 JTF_NUMBER_TABLE
1423: , p4_a3 JTF_VARCHAR2_TABLE_100
1424: , p4_a4 JTF_NUMBER_TABLE
1425: , p4_a5 JTF_DATE_TABLE
1426: , p4_a6 JTF_NUMBER_TABLE
1427: , p4_a7 JTF_NUMBER_TABLE

Line 1433: , p4_a13 JTF_VARCHAR2_TABLE_100

1429: , p4_a9 JTF_NUMBER_TABLE
1430: , p4_a10 JTF_NUMBER_TABLE
1431: , p4_a11 JTF_VARCHAR2_TABLE_200
1432: , p4_a12 JTF_NUMBER_TABLE
1433: , p4_a13 JTF_VARCHAR2_TABLE_100
1434: , p4_a14 JTF_VARCHAR2_TABLE_300
1435: , p4_a15 JTF_NUMBER_TABLE
1436: , p4_a16 JTF_NUMBER_TABLE
1437: , p4_a17 JTF_DATE_TABLE

Line 1438: , p4_a18 JTF_VARCHAR2_TABLE_100

1434: , p4_a14 JTF_VARCHAR2_TABLE_300
1435: , p4_a15 JTF_NUMBER_TABLE
1436: , p4_a16 JTF_NUMBER_TABLE
1437: , p4_a17 JTF_DATE_TABLE
1438: , p4_a18 JTF_VARCHAR2_TABLE_100
1439: , p4_a19 JTF_VARCHAR2_TABLE_100
1440: , p4_a20 JTF_NUMBER_TABLE
1441: , p4_a21 JTF_VARCHAR2_TABLE_100
1442: , p4_a22 JTF_NUMBER_TABLE

Line 1439: , p4_a19 JTF_VARCHAR2_TABLE_100

1435: , p4_a15 JTF_NUMBER_TABLE
1436: , p4_a16 JTF_NUMBER_TABLE
1437: , p4_a17 JTF_DATE_TABLE
1438: , p4_a18 JTF_VARCHAR2_TABLE_100
1439: , p4_a19 JTF_VARCHAR2_TABLE_100
1440: , p4_a20 JTF_NUMBER_TABLE
1441: , p4_a21 JTF_VARCHAR2_TABLE_100
1442: , p4_a22 JTF_NUMBER_TABLE
1443: , p4_a23 JTF_NUMBER_TABLE

Line 1441: , p4_a21 JTF_VARCHAR2_TABLE_100

1437: , p4_a17 JTF_DATE_TABLE
1438: , p4_a18 JTF_VARCHAR2_TABLE_100
1439: , p4_a19 JTF_VARCHAR2_TABLE_100
1440: , p4_a20 JTF_NUMBER_TABLE
1441: , p4_a21 JTF_VARCHAR2_TABLE_100
1442: , p4_a22 JTF_NUMBER_TABLE
1443: , p4_a23 JTF_NUMBER_TABLE
1444: , p4_a24 JTF_NUMBER_TABLE
1445: , p4_a25 JTF_NUMBER_TABLE

Line 1447: , p4_a27 JTF_VARCHAR2_TABLE_100

1443: , p4_a23 JTF_NUMBER_TABLE
1444: , p4_a24 JTF_NUMBER_TABLE
1445: , p4_a25 JTF_NUMBER_TABLE
1446: , p4_a26 JTF_NUMBER_TABLE
1447: , p4_a27 JTF_VARCHAR2_TABLE_100
1448: , p4_a28 JTF_NUMBER_TABLE
1449: , p4_a29 JTF_NUMBER_TABLE
1450: , p4_a30 JTF_NUMBER_TABLE
1451: , p4_a31 JTF_NUMBER_TABLE

Line 1452: , p4_a32 JTF_VARCHAR2_TABLE_100

1448: , p4_a28 JTF_NUMBER_TABLE
1449: , p4_a29 JTF_NUMBER_TABLE
1450: , p4_a30 JTF_NUMBER_TABLE
1451: , p4_a31 JTF_NUMBER_TABLE
1452: , p4_a32 JTF_VARCHAR2_TABLE_100
1453: , p4_a33 JTF_NUMBER_TABLE
1454: , p4_a34 JTF_NUMBER_TABLE
1455: , p4_a35 JTF_DATE_TABLE
1456: , p4_a36 JTF_DATE_TABLE

Line 1457: , p4_a37 JTF_VARCHAR2_TABLE_100

1453: , p4_a33 JTF_NUMBER_TABLE
1454: , p4_a34 JTF_NUMBER_TABLE
1455: , p4_a35 JTF_DATE_TABLE
1456: , p4_a36 JTF_DATE_TABLE
1457: , p4_a37 JTF_VARCHAR2_TABLE_100
1458: , p4_a38 JTF_NUMBER_TABLE
1459: , p4_a39 JTF_NUMBER_TABLE
1460: , p4_a40 JTF_NUMBER_TABLE
1461: , p4_a41 JTF_NUMBER_TABLE

Line 1462: , p4_a42 JTF_VARCHAR2_TABLE_100

1458: , p4_a38 JTF_NUMBER_TABLE
1459: , p4_a39 JTF_NUMBER_TABLE
1460: , p4_a40 JTF_NUMBER_TABLE
1461: , p4_a41 JTF_NUMBER_TABLE
1462: , p4_a42 JTF_VARCHAR2_TABLE_100
1463: , p4_a43 JTF_VARCHAR2_TABLE_100
1464: , p4_a44 JTF_VARCHAR2_TABLE_200
1465: , p4_a45 JTF_VARCHAR2_TABLE_200
1466: , p4_a46 JTF_VARCHAR2_TABLE_200

Line 1463: , p4_a43 JTF_VARCHAR2_TABLE_100

1459: , p4_a39 JTF_NUMBER_TABLE
1460: , p4_a40 JTF_NUMBER_TABLE
1461: , p4_a41 JTF_NUMBER_TABLE
1462: , p4_a42 JTF_VARCHAR2_TABLE_100
1463: , p4_a43 JTF_VARCHAR2_TABLE_100
1464: , p4_a44 JTF_VARCHAR2_TABLE_200
1465: , p4_a45 JTF_VARCHAR2_TABLE_200
1466: , p4_a46 JTF_VARCHAR2_TABLE_200
1467: , p4_a47 JTF_VARCHAR2_TABLE_200

Line 1481: , p4_a61 JTF_VARCHAR2_TABLE_100

1477: , p4_a57 JTF_VARCHAR2_TABLE_200
1478: , p4_a58 JTF_VARCHAR2_TABLE_200
1479: , p4_a59 JTF_NUMBER_TABLE
1480: , p4_a60 JTF_VARCHAR2_TABLE_3000
1481: , p4_a61 JTF_VARCHAR2_TABLE_100
1482: , p4_a62 JTF_VARCHAR2_TABLE_100
1483: , x_return_status out nocopy VARCHAR2
1484: , x_msg_count out nocopy NUMBER
1485: , x_msg_data out nocopy VARCHAR2

Line 1482: , p4_a62 JTF_VARCHAR2_TABLE_100

1478: , p4_a58 JTF_VARCHAR2_TABLE_200
1479: , p4_a59 JTF_NUMBER_TABLE
1480: , p4_a60 JTF_VARCHAR2_TABLE_3000
1481: , p4_a61 JTF_VARCHAR2_TABLE_100
1482: , p4_a62 JTF_VARCHAR2_TABLE_100
1483: , x_return_status out nocopy VARCHAR2
1484: , x_msg_count out nocopy NUMBER
1485: , x_msg_data out nocopy VARCHAR2
1486: )