DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 17: , a1 JTF_VARCHAR2_TABLE_100

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: ) as
19: ddindx binary_integer; indx binary_integer;
20: begin
21: if a0 is not null and a0.count=0 then

Line 42: , a1 out nocopy JTF_VARCHAR2_TABLE_100

38: end if;
39: end if;
40: end rosetta_table_copy_in_p13;
41: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: ) as
44: ddindx binary_integer; indx binary_integer;
45: begin
46: if t is null then

Line 51: a1 := JTF_VARCHAR2_TABLE_100();

47: a0 := null;
48: a1 := null;
49: elsif t.count = 0 then
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: else
53: a0 := JTF_NUMBER_TABLE();
54: a1 := JTF_VARCHAR2_TABLE_100();
55: if t.count > 0 then

Line 54: a1 := JTF_VARCHAR2_TABLE_100();

50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: else
53: a0 := JTF_NUMBER_TABLE();
54: a1 := JTF_VARCHAR2_TABLE_100();
55: if t.count > 0 then
56: a0.extend(t.count);
57: a1.extend(t.count);
58: ddindx := t.first;

Line 74: , a1 JTF_VARCHAR2_TABLE_100

70: end if;
71: end rosetta_table_copy_out_p13;
72:
73: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_DATE_TABLE
76: , a3 JTF_NUMBER_TABLE
77: , a4 JTF_NUMBER_TABLE
78: , a5 JTF_NUMBER_TABLE

Line 113: , a1 out nocopy JTF_VARCHAR2_TABLE_100

109: end if;
110: end if;
111: end rosetta_table_copy_in_p14;
112: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_DATE_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE

Line 136: a1 := JTF_VARCHAR2_TABLE_100();

132: a7 := null;
133: a8 := null;
134: elsif t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_VARCHAR2_TABLE_100();
137: a2 := JTF_DATE_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_NUMBER_TABLE();

Line 146: a1 := JTF_VARCHAR2_TABLE_100();

142: a7 := JTF_VARCHAR2_TABLE_4000();
143: a8 := JTF_VARCHAR2_TABLE_4000();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();

Line 187: , a1 JTF_VARCHAR2_TABLE_100

183: end if;
184: end rosetta_table_copy_out_p14;
185:
186: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
187: , a1 JTF_VARCHAR2_TABLE_100
188: , a2 JTF_NUMBER_TABLE
189: , a3 JTF_NUMBER_TABLE
190: , a4 JTF_VARCHAR2_TABLE_100
191: , a5 JTF_VARCHAR2_TABLE_100

Line 190: , a4 JTF_VARCHAR2_TABLE_100

186: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
187: , a1 JTF_VARCHAR2_TABLE_100
188: , a2 JTF_NUMBER_TABLE
189: , a3 JTF_NUMBER_TABLE
190: , a4 JTF_VARCHAR2_TABLE_100
191: , a5 JTF_VARCHAR2_TABLE_100
192: , a6 JTF_NUMBER_TABLE
193: , a7 JTF_NUMBER_TABLE
194: , a8 JTF_NUMBER_TABLE

Line 191: , a5 JTF_VARCHAR2_TABLE_100

187: , a1 JTF_VARCHAR2_TABLE_100
188: , a2 JTF_NUMBER_TABLE
189: , a3 JTF_NUMBER_TABLE
190: , a4 JTF_VARCHAR2_TABLE_100
191: , a5 JTF_VARCHAR2_TABLE_100
192: , a6 JTF_NUMBER_TABLE
193: , a7 JTF_NUMBER_TABLE
194: , a8 JTF_NUMBER_TABLE
195: , a9 JTF_VARCHAR2_TABLE_100

Line 195: , a9 JTF_VARCHAR2_TABLE_100

191: , a5 JTF_VARCHAR2_TABLE_100
192: , a6 JTF_NUMBER_TABLE
193: , a7 JTF_NUMBER_TABLE
194: , a8 JTF_NUMBER_TABLE
195: , a9 JTF_VARCHAR2_TABLE_100
196: ) as
197: ddindx binary_integer; indx binary_integer;
198: begin
199: if a0 is not null and a0.count=0 then

Line 228: , a1 out nocopy JTF_VARCHAR2_TABLE_100

224: end if;
225: end if;
226: end rosetta_table_copy_in_p15;
227: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_NUMBER_TABLE
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_VARCHAR2_TABLE_100
232: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 231: , a4 out nocopy JTF_VARCHAR2_TABLE_100

227: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_NUMBER_TABLE
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_VARCHAR2_TABLE_100
232: , a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , a6 out nocopy JTF_NUMBER_TABLE
234: , a7 out nocopy JTF_NUMBER_TABLE
235: , a8 out nocopy JTF_NUMBER_TABLE

Line 232: , a5 out nocopy JTF_VARCHAR2_TABLE_100

228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_NUMBER_TABLE
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_VARCHAR2_TABLE_100
232: , a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , a6 out nocopy JTF_NUMBER_TABLE
234: , a7 out nocopy JTF_NUMBER_TABLE
235: , a8 out nocopy JTF_NUMBER_TABLE
236: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 236: , a9 out nocopy JTF_VARCHAR2_TABLE_100

232: , a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , a6 out nocopy JTF_NUMBER_TABLE
234: , a7 out nocopy JTF_NUMBER_TABLE
235: , a8 out nocopy JTF_NUMBER_TABLE
236: , a9 out nocopy JTF_VARCHAR2_TABLE_100
237: ) as
238: ddindx binary_integer; indx binary_integer;
239: begin
240: if t is null then

Line 253: a1 := JTF_VARCHAR2_TABLE_100();

249: a8 := null;
250: a9 := null;
251: elsif t.count = 0 then
252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_VARCHAR2_TABLE_100();
254: a2 := JTF_NUMBER_TABLE();
255: a3 := JTF_NUMBER_TABLE();
256: a4 := JTF_VARCHAR2_TABLE_100();
257: a5 := JTF_VARCHAR2_TABLE_100();

Line 256: a4 := JTF_VARCHAR2_TABLE_100();

252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_VARCHAR2_TABLE_100();
254: a2 := JTF_NUMBER_TABLE();
255: a3 := JTF_NUMBER_TABLE();
256: a4 := JTF_VARCHAR2_TABLE_100();
257: a5 := JTF_VARCHAR2_TABLE_100();
258: a6 := JTF_NUMBER_TABLE();
259: a7 := JTF_NUMBER_TABLE();
260: a8 := JTF_NUMBER_TABLE();

Line 257: a5 := JTF_VARCHAR2_TABLE_100();

253: a1 := JTF_VARCHAR2_TABLE_100();
254: a2 := JTF_NUMBER_TABLE();
255: a3 := JTF_NUMBER_TABLE();
256: a4 := JTF_VARCHAR2_TABLE_100();
257: a5 := JTF_VARCHAR2_TABLE_100();
258: a6 := JTF_NUMBER_TABLE();
259: a7 := JTF_NUMBER_TABLE();
260: a8 := JTF_NUMBER_TABLE();
261: a9 := JTF_VARCHAR2_TABLE_100();

Line 261: a9 := JTF_VARCHAR2_TABLE_100();

257: a5 := JTF_VARCHAR2_TABLE_100();
258: a6 := JTF_NUMBER_TABLE();
259: a7 := JTF_NUMBER_TABLE();
260: a8 := JTF_NUMBER_TABLE();
261: a9 := JTF_VARCHAR2_TABLE_100();
262: else
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_VARCHAR2_TABLE_100();
265: a2 := JTF_NUMBER_TABLE();

Line 264: a1 := JTF_VARCHAR2_TABLE_100();

260: a8 := JTF_NUMBER_TABLE();
261: a9 := JTF_VARCHAR2_TABLE_100();
262: else
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_VARCHAR2_TABLE_100();
265: a2 := JTF_NUMBER_TABLE();
266: a3 := JTF_NUMBER_TABLE();
267: a4 := JTF_VARCHAR2_TABLE_100();
268: a5 := JTF_VARCHAR2_TABLE_100();

Line 267: a4 := JTF_VARCHAR2_TABLE_100();

263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_VARCHAR2_TABLE_100();
265: a2 := JTF_NUMBER_TABLE();
266: a3 := JTF_NUMBER_TABLE();
267: a4 := JTF_VARCHAR2_TABLE_100();
268: a5 := JTF_VARCHAR2_TABLE_100();
269: a6 := JTF_NUMBER_TABLE();
270: a7 := JTF_NUMBER_TABLE();
271: a8 := JTF_NUMBER_TABLE();

Line 268: a5 := JTF_VARCHAR2_TABLE_100();

264: a1 := JTF_VARCHAR2_TABLE_100();
265: a2 := JTF_NUMBER_TABLE();
266: a3 := JTF_NUMBER_TABLE();
267: a4 := JTF_VARCHAR2_TABLE_100();
268: a5 := JTF_VARCHAR2_TABLE_100();
269: a6 := JTF_NUMBER_TABLE();
270: a7 := JTF_NUMBER_TABLE();
271: a8 := JTF_NUMBER_TABLE();
272: a9 := JTF_VARCHAR2_TABLE_100();

Line 272: a9 := JTF_VARCHAR2_TABLE_100();

268: a5 := JTF_VARCHAR2_TABLE_100();
269: a6 := JTF_NUMBER_TABLE();
270: a7 := JTF_NUMBER_TABLE();
271: a8 := JTF_NUMBER_TABLE();
272: a9 := JTF_VARCHAR2_TABLE_100();
273: if t.count > 0 then
274: a0.extend(t.count);
275: a1.extend(t.count);
276: a2.extend(t.count);

Line 308: , a1 JTF_VARCHAR2_TABLE_100

304: end if;
305: end rosetta_table_copy_out_p15;
306:
307: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
308: , a1 JTF_VARCHAR2_TABLE_100
309: , a2 JTF_NUMBER_TABLE
310: , a3 JTF_NUMBER_TABLE
311: , a4 JTF_NUMBER_TABLE
312: , a5 JTF_NUMBER_TABLE

Line 313: , a6 JTF_VARCHAR2_TABLE_100

309: , a2 JTF_NUMBER_TABLE
310: , a3 JTF_NUMBER_TABLE
311: , a4 JTF_NUMBER_TABLE
312: , a5 JTF_NUMBER_TABLE
313: , a6 JTF_VARCHAR2_TABLE_100
314: , a7 JTF_NUMBER_TABLE
315: , a8 JTF_VARCHAR2_TABLE_100
316: , a9 JTF_NUMBER_TABLE
317: , a10 JTF_NUMBER_TABLE

Line 315: , a8 JTF_VARCHAR2_TABLE_100

311: , a4 JTF_NUMBER_TABLE
312: , a5 JTF_NUMBER_TABLE
313: , a6 JTF_VARCHAR2_TABLE_100
314: , a7 JTF_NUMBER_TABLE
315: , a8 JTF_VARCHAR2_TABLE_100
316: , a9 JTF_NUMBER_TABLE
317: , a10 JTF_NUMBER_TABLE
318: , a11 JTF_NUMBER_TABLE
319: , a12 JTF_VARCHAR2_TABLE_100

Line 319: , a12 JTF_VARCHAR2_TABLE_100

315: , a8 JTF_VARCHAR2_TABLE_100
316: , a9 JTF_NUMBER_TABLE
317: , a10 JTF_NUMBER_TABLE
318: , a11 JTF_NUMBER_TABLE
319: , a12 JTF_VARCHAR2_TABLE_100
320: , a13 JTF_DATE_TABLE
321: , a14 JTF_VARCHAR2_TABLE_100
322: , a15 JTF_NUMBER_TABLE
323: , a16 JTF_VARCHAR2_TABLE_100

Line 321: , a14 JTF_VARCHAR2_TABLE_100

317: , a10 JTF_NUMBER_TABLE
318: , a11 JTF_NUMBER_TABLE
319: , a12 JTF_VARCHAR2_TABLE_100
320: , a13 JTF_DATE_TABLE
321: , a14 JTF_VARCHAR2_TABLE_100
322: , a15 JTF_NUMBER_TABLE
323: , a16 JTF_VARCHAR2_TABLE_100
324: ) as
325: ddindx binary_integer; indx binary_integer;

Line 323: , a16 JTF_VARCHAR2_TABLE_100

319: , a12 JTF_VARCHAR2_TABLE_100
320: , a13 JTF_DATE_TABLE
321: , a14 JTF_VARCHAR2_TABLE_100
322: , a15 JTF_NUMBER_TABLE
323: , a16 JTF_VARCHAR2_TABLE_100
324: ) as
325: ddindx binary_integer; indx binary_integer;
326: begin
327: if a0 is not null and a0.count=0 then

Line 363: , a1 out nocopy JTF_VARCHAR2_TABLE_100

359: end if;
360: end if;
361: end rosetta_table_copy_in_p16;
362: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
363: , a1 out nocopy JTF_VARCHAR2_TABLE_100
364: , a2 out nocopy JTF_NUMBER_TABLE
365: , a3 out nocopy JTF_NUMBER_TABLE
366: , a4 out nocopy JTF_NUMBER_TABLE
367: , a5 out nocopy JTF_NUMBER_TABLE

Line 368: , a6 out nocopy JTF_VARCHAR2_TABLE_100

364: , a2 out nocopy JTF_NUMBER_TABLE
365: , a3 out nocopy JTF_NUMBER_TABLE
366: , a4 out nocopy JTF_NUMBER_TABLE
367: , a5 out nocopy JTF_NUMBER_TABLE
368: , a6 out nocopy JTF_VARCHAR2_TABLE_100
369: , a7 out nocopy JTF_NUMBER_TABLE
370: , a8 out nocopy JTF_VARCHAR2_TABLE_100
371: , a9 out nocopy JTF_NUMBER_TABLE
372: , a10 out nocopy JTF_NUMBER_TABLE

Line 370: , a8 out nocopy JTF_VARCHAR2_TABLE_100

366: , a4 out nocopy JTF_NUMBER_TABLE
367: , a5 out nocopy JTF_NUMBER_TABLE
368: , a6 out nocopy JTF_VARCHAR2_TABLE_100
369: , a7 out nocopy JTF_NUMBER_TABLE
370: , a8 out nocopy JTF_VARCHAR2_TABLE_100
371: , a9 out nocopy JTF_NUMBER_TABLE
372: , a10 out nocopy JTF_NUMBER_TABLE
373: , a11 out nocopy JTF_NUMBER_TABLE
374: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 374: , a12 out nocopy JTF_VARCHAR2_TABLE_100

370: , a8 out nocopy JTF_VARCHAR2_TABLE_100
371: , a9 out nocopy JTF_NUMBER_TABLE
372: , a10 out nocopy JTF_NUMBER_TABLE
373: , a11 out nocopy JTF_NUMBER_TABLE
374: , a12 out nocopy JTF_VARCHAR2_TABLE_100
375: , a13 out nocopy JTF_DATE_TABLE
376: , a14 out nocopy JTF_VARCHAR2_TABLE_100
377: , a15 out nocopy JTF_NUMBER_TABLE
378: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 376: , a14 out nocopy JTF_VARCHAR2_TABLE_100

372: , a10 out nocopy JTF_NUMBER_TABLE
373: , a11 out nocopy JTF_NUMBER_TABLE
374: , a12 out nocopy JTF_VARCHAR2_TABLE_100
375: , a13 out nocopy JTF_DATE_TABLE
376: , a14 out nocopy JTF_VARCHAR2_TABLE_100
377: , a15 out nocopy JTF_NUMBER_TABLE
378: , a16 out nocopy JTF_VARCHAR2_TABLE_100
379: ) as
380: ddindx binary_integer; indx binary_integer;

Line 378: , a16 out nocopy JTF_VARCHAR2_TABLE_100

374: , a12 out nocopy JTF_VARCHAR2_TABLE_100
375: , a13 out nocopy JTF_DATE_TABLE
376: , a14 out nocopy JTF_VARCHAR2_TABLE_100
377: , a15 out nocopy JTF_NUMBER_TABLE
378: , a16 out nocopy JTF_VARCHAR2_TABLE_100
379: ) as
380: ddindx binary_integer; indx binary_integer;
381: begin
382: if t is null then

Line 402: a1 := JTF_VARCHAR2_TABLE_100();

398: a15 := null;
399: a16 := null;
400: elsif t.count = 0 then
401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_NUMBER_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_NUMBER_TABLE();

Line 407: a6 := JTF_VARCHAR2_TABLE_100();

403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_NUMBER_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_NUMBER_TABLE();
407: a6 := JTF_VARCHAR2_TABLE_100();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_VARCHAR2_TABLE_100();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();

Line 409: a8 := JTF_VARCHAR2_TABLE_100();

405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_NUMBER_TABLE();
407: a6 := JTF_VARCHAR2_TABLE_100();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_VARCHAR2_TABLE_100();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_NUMBER_TABLE();
413: a12 := JTF_VARCHAR2_TABLE_100();

Line 413: a12 := JTF_VARCHAR2_TABLE_100();

409: a8 := JTF_VARCHAR2_TABLE_100();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_NUMBER_TABLE();
413: a12 := JTF_VARCHAR2_TABLE_100();
414: a13 := JTF_DATE_TABLE();
415: a14 := JTF_VARCHAR2_TABLE_100();
416: a15 := JTF_NUMBER_TABLE();
417: a16 := JTF_VARCHAR2_TABLE_100();

Line 415: a14 := JTF_VARCHAR2_TABLE_100();

411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_NUMBER_TABLE();
413: a12 := JTF_VARCHAR2_TABLE_100();
414: a13 := JTF_DATE_TABLE();
415: a14 := JTF_VARCHAR2_TABLE_100();
416: a15 := JTF_NUMBER_TABLE();
417: a16 := JTF_VARCHAR2_TABLE_100();
418: else
419: a0 := JTF_NUMBER_TABLE();

Line 417: a16 := JTF_VARCHAR2_TABLE_100();

413: a12 := JTF_VARCHAR2_TABLE_100();
414: a13 := JTF_DATE_TABLE();
415: a14 := JTF_VARCHAR2_TABLE_100();
416: a15 := JTF_NUMBER_TABLE();
417: a16 := JTF_VARCHAR2_TABLE_100();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_100();
421: a2 := JTF_NUMBER_TABLE();

Line 420: a1 := JTF_VARCHAR2_TABLE_100();

416: a15 := JTF_NUMBER_TABLE();
417: a16 := JTF_VARCHAR2_TABLE_100();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_100();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();

Line 425: a6 := JTF_VARCHAR2_TABLE_100();

421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_NUMBER_TABLE();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();

Line 427: a8 := JTF_VARCHAR2_TABLE_100();

423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_NUMBER_TABLE();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_NUMBER_TABLE();
431: a12 := JTF_VARCHAR2_TABLE_100();

Line 431: a12 := JTF_VARCHAR2_TABLE_100();

427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_NUMBER_TABLE();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_DATE_TABLE();
433: a14 := JTF_VARCHAR2_TABLE_100();
434: a15 := JTF_NUMBER_TABLE();
435: a16 := JTF_VARCHAR2_TABLE_100();

Line 433: a14 := JTF_VARCHAR2_TABLE_100();

429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_NUMBER_TABLE();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_DATE_TABLE();
433: a14 := JTF_VARCHAR2_TABLE_100();
434: a15 := JTF_NUMBER_TABLE();
435: a16 := JTF_VARCHAR2_TABLE_100();
436: if t.count > 0 then
437: a0.extend(t.count);

Line 435: a16 := JTF_VARCHAR2_TABLE_100();

431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_DATE_TABLE();
433: a14 := JTF_VARCHAR2_TABLE_100();
434: a15 := JTF_NUMBER_TABLE();
435: a16 := JTF_VARCHAR2_TABLE_100();
436: if t.count > 0 then
437: a0.extend(t.count);
438: a1.extend(t.count);
439: a2.extend(t.count);

Line 485: , a1 JTF_VARCHAR2_TABLE_100

481: end if;
482: end rosetta_table_copy_out_p16;
483:
484: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
485: , a1 JTF_VARCHAR2_TABLE_100
486: , a2 JTF_VARCHAR2_TABLE_100
487: , a3 JTF_NUMBER_TABLE
488: , a4 JTF_VARCHAR2_TABLE_100
489: , a5 JTF_NUMBER_TABLE

Line 486: , a2 JTF_VARCHAR2_TABLE_100

482: end rosetta_table_copy_out_p16;
483:
484: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
485: , a1 JTF_VARCHAR2_TABLE_100
486: , a2 JTF_VARCHAR2_TABLE_100
487: , a3 JTF_NUMBER_TABLE
488: , a4 JTF_VARCHAR2_TABLE_100
489: , a5 JTF_NUMBER_TABLE
490: ) as

Line 488: , a4 JTF_VARCHAR2_TABLE_100

484: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
485: , a1 JTF_VARCHAR2_TABLE_100
486: , a2 JTF_VARCHAR2_TABLE_100
487: , a3 JTF_NUMBER_TABLE
488: , a4 JTF_VARCHAR2_TABLE_100
489: , a5 JTF_NUMBER_TABLE
490: ) as
491: ddindx binary_integer; indx binary_integer;
492: begin

Line 518: , a1 out nocopy JTF_VARCHAR2_TABLE_100

514: end if;
515: end if;
516: end rosetta_table_copy_in_p17;
517: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
518: , a1 out nocopy JTF_VARCHAR2_TABLE_100
519: , a2 out nocopy JTF_VARCHAR2_TABLE_100
520: , a3 out nocopy JTF_NUMBER_TABLE
521: , a4 out nocopy JTF_VARCHAR2_TABLE_100
522: , a5 out nocopy JTF_NUMBER_TABLE

Line 519: , a2 out nocopy JTF_VARCHAR2_TABLE_100

515: end if;
516: end rosetta_table_copy_in_p17;
517: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
518: , a1 out nocopy JTF_VARCHAR2_TABLE_100
519: , a2 out nocopy JTF_VARCHAR2_TABLE_100
520: , a3 out nocopy JTF_NUMBER_TABLE
521: , a4 out nocopy JTF_VARCHAR2_TABLE_100
522: , a5 out nocopy JTF_NUMBER_TABLE
523: ) as

Line 521: , a4 out nocopy JTF_VARCHAR2_TABLE_100

517: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
518: , a1 out nocopy JTF_VARCHAR2_TABLE_100
519: , a2 out nocopy JTF_VARCHAR2_TABLE_100
520: , a3 out nocopy JTF_NUMBER_TABLE
521: , a4 out nocopy JTF_VARCHAR2_TABLE_100
522: , a5 out nocopy JTF_NUMBER_TABLE
523: ) as
524: ddindx binary_integer; indx binary_integer;
525: begin

Line 535: a1 := JTF_VARCHAR2_TABLE_100();

531: a4 := null;
532: a5 := null;
533: elsif t.count = 0 then
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_VARCHAR2_TABLE_100();
537: a3 := JTF_NUMBER_TABLE();
538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();

Line 536: a2 := JTF_VARCHAR2_TABLE_100();

532: a5 := null;
533: elsif t.count = 0 then
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_VARCHAR2_TABLE_100();
537: a3 := JTF_NUMBER_TABLE();
538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();
540: else

Line 538: a4 := JTF_VARCHAR2_TABLE_100();

534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_VARCHAR2_TABLE_100();
537: a3 := JTF_NUMBER_TABLE();
538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();
540: else
541: a0 := JTF_NUMBER_TABLE();
542: a1 := JTF_VARCHAR2_TABLE_100();

Line 542: a1 := JTF_VARCHAR2_TABLE_100();

538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();
540: else
541: a0 := JTF_NUMBER_TABLE();
542: a1 := JTF_VARCHAR2_TABLE_100();
543: a2 := JTF_VARCHAR2_TABLE_100();
544: a3 := JTF_NUMBER_TABLE();
545: a4 := JTF_VARCHAR2_TABLE_100();
546: a5 := JTF_NUMBER_TABLE();

Line 543: a2 := JTF_VARCHAR2_TABLE_100();

539: a5 := JTF_NUMBER_TABLE();
540: else
541: a0 := JTF_NUMBER_TABLE();
542: a1 := JTF_VARCHAR2_TABLE_100();
543: a2 := JTF_VARCHAR2_TABLE_100();
544: a3 := JTF_NUMBER_TABLE();
545: a4 := JTF_VARCHAR2_TABLE_100();
546: a5 := JTF_NUMBER_TABLE();
547: if t.count > 0 then

Line 545: a4 := JTF_VARCHAR2_TABLE_100();

541: a0 := JTF_NUMBER_TABLE();
542: a1 := JTF_VARCHAR2_TABLE_100();
543: a2 := JTF_VARCHAR2_TABLE_100();
544: a3 := JTF_NUMBER_TABLE();
545: a4 := JTF_VARCHAR2_TABLE_100();
546: a5 := JTF_NUMBER_TABLE();
547: if t.count > 0 then
548: a0.extend(t.count);
549: a1.extend(t.count);

Line 574: , a1 JTF_VARCHAR2_TABLE_100

570: end if;
571: end rosetta_table_copy_out_p17;
572:
573: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
574: , a1 JTF_VARCHAR2_TABLE_100
575: , a2 JTF_NUMBER_TABLE
576: , a3 JTF_NUMBER_TABLE
577: , a4 JTF_VARCHAR2_TABLE_100
578: , a5 JTF_NUMBER_TABLE

Line 577: , a4 JTF_VARCHAR2_TABLE_100

573: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
574: , a1 JTF_VARCHAR2_TABLE_100
575: , a2 JTF_NUMBER_TABLE
576: , a3 JTF_NUMBER_TABLE
577: , a4 JTF_VARCHAR2_TABLE_100
578: , a5 JTF_NUMBER_TABLE
579: , a6 JTF_NUMBER_TABLE
580: , a7 JTF_NUMBER_TABLE
581: , a8 JTF_VARCHAR2_TABLE_100

Line 581: , a8 JTF_VARCHAR2_TABLE_100

577: , a4 JTF_VARCHAR2_TABLE_100
578: , a5 JTF_NUMBER_TABLE
579: , a6 JTF_NUMBER_TABLE
580: , a7 JTF_NUMBER_TABLE
581: , a8 JTF_VARCHAR2_TABLE_100
582: , a9 JTF_DATE_TABLE
583: , a10 JTF_DATE_TABLE
584: , a11 JTF_VARCHAR2_TABLE_100
585: , a12 JTF_NUMBER_TABLE

Line 584: , a11 JTF_VARCHAR2_TABLE_100

580: , a7 JTF_NUMBER_TABLE
581: , a8 JTF_VARCHAR2_TABLE_100
582: , a9 JTF_DATE_TABLE
583: , a10 JTF_DATE_TABLE
584: , a11 JTF_VARCHAR2_TABLE_100
585: , a12 JTF_NUMBER_TABLE
586: , a13 JTF_NUMBER_TABLE
587: , a14 JTF_VARCHAR2_TABLE_100
588: , a15 JTF_VARCHAR2_TABLE_100

Line 587: , a14 JTF_VARCHAR2_TABLE_100

583: , a10 JTF_DATE_TABLE
584: , a11 JTF_VARCHAR2_TABLE_100
585: , a12 JTF_NUMBER_TABLE
586: , a13 JTF_NUMBER_TABLE
587: , a14 JTF_VARCHAR2_TABLE_100
588: , a15 JTF_VARCHAR2_TABLE_100
589: ) as
590: ddindx binary_integer; indx binary_integer;
591: begin

Line 588: , a15 JTF_VARCHAR2_TABLE_100

584: , a11 JTF_VARCHAR2_TABLE_100
585: , a12 JTF_NUMBER_TABLE
586: , a13 JTF_NUMBER_TABLE
587: , a14 JTF_VARCHAR2_TABLE_100
588: , a15 JTF_VARCHAR2_TABLE_100
589: ) as
590: ddindx binary_integer; indx binary_integer;
591: begin
592: if a0 is not null and a0.count=0 then

Line 627: , a1 out nocopy JTF_VARCHAR2_TABLE_100

623: end if;
624: end if;
625: end rosetta_table_copy_in_p18;
626: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
627: , a1 out nocopy JTF_VARCHAR2_TABLE_100
628: , a2 out nocopy JTF_NUMBER_TABLE
629: , a3 out nocopy JTF_NUMBER_TABLE
630: , a4 out nocopy JTF_VARCHAR2_TABLE_100
631: , a5 out nocopy JTF_NUMBER_TABLE

Line 630: , a4 out nocopy JTF_VARCHAR2_TABLE_100

626: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
627: , a1 out nocopy JTF_VARCHAR2_TABLE_100
628: , a2 out nocopy JTF_NUMBER_TABLE
629: , a3 out nocopy JTF_NUMBER_TABLE
630: , a4 out nocopy JTF_VARCHAR2_TABLE_100
631: , a5 out nocopy JTF_NUMBER_TABLE
632: , a6 out nocopy JTF_NUMBER_TABLE
633: , a7 out nocopy JTF_NUMBER_TABLE
634: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 634: , a8 out nocopy JTF_VARCHAR2_TABLE_100

630: , a4 out nocopy JTF_VARCHAR2_TABLE_100
631: , a5 out nocopy JTF_NUMBER_TABLE
632: , a6 out nocopy JTF_NUMBER_TABLE
633: , a7 out nocopy JTF_NUMBER_TABLE
634: , a8 out nocopy JTF_VARCHAR2_TABLE_100
635: , a9 out nocopy JTF_DATE_TABLE
636: , a10 out nocopy JTF_DATE_TABLE
637: , a11 out nocopy JTF_VARCHAR2_TABLE_100
638: , a12 out nocopy JTF_NUMBER_TABLE

Line 637: , a11 out nocopy JTF_VARCHAR2_TABLE_100

633: , a7 out nocopy JTF_NUMBER_TABLE
634: , a8 out nocopy JTF_VARCHAR2_TABLE_100
635: , a9 out nocopy JTF_DATE_TABLE
636: , a10 out nocopy JTF_DATE_TABLE
637: , a11 out nocopy JTF_VARCHAR2_TABLE_100
638: , a12 out nocopy JTF_NUMBER_TABLE
639: , a13 out nocopy JTF_NUMBER_TABLE
640: , a14 out nocopy JTF_VARCHAR2_TABLE_100
641: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 640: , a14 out nocopy JTF_VARCHAR2_TABLE_100

636: , a10 out nocopy JTF_DATE_TABLE
637: , a11 out nocopy JTF_VARCHAR2_TABLE_100
638: , a12 out nocopy JTF_NUMBER_TABLE
639: , a13 out nocopy JTF_NUMBER_TABLE
640: , a14 out nocopy JTF_VARCHAR2_TABLE_100
641: , a15 out nocopy JTF_VARCHAR2_TABLE_100
642: ) as
643: ddindx binary_integer; indx binary_integer;
644: begin

Line 641: , a15 out nocopy JTF_VARCHAR2_TABLE_100

637: , a11 out nocopy JTF_VARCHAR2_TABLE_100
638: , a12 out nocopy JTF_NUMBER_TABLE
639: , a13 out nocopy JTF_NUMBER_TABLE
640: , a14 out nocopy JTF_VARCHAR2_TABLE_100
641: , a15 out nocopy JTF_VARCHAR2_TABLE_100
642: ) as
643: ddindx binary_integer; indx binary_integer;
644: begin
645: if t is null then

Line 664: a1 := JTF_VARCHAR2_TABLE_100();

660: a14 := null;
661: a15 := null;
662: elsif t.count = 0 then
663: a0 := JTF_NUMBER_TABLE();
664: a1 := JTF_VARCHAR2_TABLE_100();
665: a2 := JTF_NUMBER_TABLE();
666: a3 := JTF_NUMBER_TABLE();
667: a4 := JTF_VARCHAR2_TABLE_100();
668: a5 := JTF_NUMBER_TABLE();

Line 667: a4 := JTF_VARCHAR2_TABLE_100();

663: a0 := JTF_NUMBER_TABLE();
664: a1 := JTF_VARCHAR2_TABLE_100();
665: a2 := JTF_NUMBER_TABLE();
666: a3 := JTF_NUMBER_TABLE();
667: a4 := JTF_VARCHAR2_TABLE_100();
668: a5 := JTF_NUMBER_TABLE();
669: a6 := JTF_NUMBER_TABLE();
670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_100();

Line 671: a8 := JTF_VARCHAR2_TABLE_100();

667: a4 := JTF_VARCHAR2_TABLE_100();
668: a5 := JTF_NUMBER_TABLE();
669: a6 := JTF_NUMBER_TABLE();
670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_100();
672: a9 := JTF_DATE_TABLE();
673: a10 := JTF_DATE_TABLE();
674: a11 := JTF_VARCHAR2_TABLE_100();
675: a12 := JTF_NUMBER_TABLE();

Line 674: a11 := JTF_VARCHAR2_TABLE_100();

670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_100();
672: a9 := JTF_DATE_TABLE();
673: a10 := JTF_DATE_TABLE();
674: a11 := JTF_VARCHAR2_TABLE_100();
675: a12 := JTF_NUMBER_TABLE();
676: a13 := JTF_NUMBER_TABLE();
677: a14 := JTF_VARCHAR2_TABLE_100();
678: a15 := JTF_VARCHAR2_TABLE_100();

Line 677: a14 := JTF_VARCHAR2_TABLE_100();

673: a10 := JTF_DATE_TABLE();
674: a11 := JTF_VARCHAR2_TABLE_100();
675: a12 := JTF_NUMBER_TABLE();
676: a13 := JTF_NUMBER_TABLE();
677: a14 := JTF_VARCHAR2_TABLE_100();
678: a15 := JTF_VARCHAR2_TABLE_100();
679: else
680: a0 := JTF_NUMBER_TABLE();
681: a1 := JTF_VARCHAR2_TABLE_100();

Line 678: a15 := JTF_VARCHAR2_TABLE_100();

674: a11 := JTF_VARCHAR2_TABLE_100();
675: a12 := JTF_NUMBER_TABLE();
676: a13 := JTF_NUMBER_TABLE();
677: a14 := JTF_VARCHAR2_TABLE_100();
678: a15 := JTF_VARCHAR2_TABLE_100();
679: else
680: a0 := JTF_NUMBER_TABLE();
681: a1 := JTF_VARCHAR2_TABLE_100();
682: a2 := JTF_NUMBER_TABLE();

Line 681: a1 := JTF_VARCHAR2_TABLE_100();

677: a14 := JTF_VARCHAR2_TABLE_100();
678: a15 := JTF_VARCHAR2_TABLE_100();
679: else
680: a0 := JTF_NUMBER_TABLE();
681: a1 := JTF_VARCHAR2_TABLE_100();
682: a2 := JTF_NUMBER_TABLE();
683: a3 := JTF_NUMBER_TABLE();
684: a4 := JTF_VARCHAR2_TABLE_100();
685: a5 := JTF_NUMBER_TABLE();

Line 684: a4 := JTF_VARCHAR2_TABLE_100();

680: a0 := JTF_NUMBER_TABLE();
681: a1 := JTF_VARCHAR2_TABLE_100();
682: a2 := JTF_NUMBER_TABLE();
683: a3 := JTF_NUMBER_TABLE();
684: a4 := JTF_VARCHAR2_TABLE_100();
685: a5 := JTF_NUMBER_TABLE();
686: a6 := JTF_NUMBER_TABLE();
687: a7 := JTF_NUMBER_TABLE();
688: a8 := JTF_VARCHAR2_TABLE_100();

Line 688: a8 := JTF_VARCHAR2_TABLE_100();

684: a4 := JTF_VARCHAR2_TABLE_100();
685: a5 := JTF_NUMBER_TABLE();
686: a6 := JTF_NUMBER_TABLE();
687: a7 := JTF_NUMBER_TABLE();
688: a8 := JTF_VARCHAR2_TABLE_100();
689: a9 := JTF_DATE_TABLE();
690: a10 := JTF_DATE_TABLE();
691: a11 := JTF_VARCHAR2_TABLE_100();
692: a12 := JTF_NUMBER_TABLE();

Line 691: a11 := JTF_VARCHAR2_TABLE_100();

687: a7 := JTF_NUMBER_TABLE();
688: a8 := JTF_VARCHAR2_TABLE_100();
689: a9 := JTF_DATE_TABLE();
690: a10 := JTF_DATE_TABLE();
691: a11 := JTF_VARCHAR2_TABLE_100();
692: a12 := JTF_NUMBER_TABLE();
693: a13 := JTF_NUMBER_TABLE();
694: a14 := JTF_VARCHAR2_TABLE_100();
695: a15 := JTF_VARCHAR2_TABLE_100();

Line 694: a14 := JTF_VARCHAR2_TABLE_100();

690: a10 := JTF_DATE_TABLE();
691: a11 := JTF_VARCHAR2_TABLE_100();
692: a12 := JTF_NUMBER_TABLE();
693: a13 := JTF_NUMBER_TABLE();
694: a14 := JTF_VARCHAR2_TABLE_100();
695: a15 := JTF_VARCHAR2_TABLE_100();
696: if t.count > 0 then
697: a0.extend(t.count);
698: a1.extend(t.count);

Line 695: a15 := JTF_VARCHAR2_TABLE_100();

691: a11 := JTF_VARCHAR2_TABLE_100();
692: a12 := JTF_NUMBER_TABLE();
693: a13 := JTF_NUMBER_TABLE();
694: a14 := JTF_VARCHAR2_TABLE_100();
695: a15 := JTF_VARCHAR2_TABLE_100();
696: if t.count > 0 then
697: a0.extend(t.count);
698: a1.extend(t.count);
699: a2.extend(t.count);

Line 743: , a1 JTF_VARCHAR2_TABLE_100

739: end if;
740: end rosetta_table_copy_out_p18;
741:
742: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
743: , a1 JTF_VARCHAR2_TABLE_100
744: , a2 JTF_NUMBER_TABLE
745: , a3 JTF_NUMBER_TABLE
746: , a4 JTF_VARCHAR2_TABLE_100
747: , a5 JTF_NUMBER_TABLE

Line 746: , a4 JTF_VARCHAR2_TABLE_100

742: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
743: , a1 JTF_VARCHAR2_TABLE_100
744: , a2 JTF_NUMBER_TABLE
745: , a3 JTF_NUMBER_TABLE
746: , a4 JTF_VARCHAR2_TABLE_100
747: , a5 JTF_NUMBER_TABLE
748: , a6 JTF_NUMBER_TABLE
749: , a7 JTF_NUMBER_TABLE
750: , a8 JTF_VARCHAR2_TABLE_100

Line 750: , a8 JTF_VARCHAR2_TABLE_100

746: , a4 JTF_VARCHAR2_TABLE_100
747: , a5 JTF_NUMBER_TABLE
748: , a6 JTF_NUMBER_TABLE
749: , a7 JTF_NUMBER_TABLE
750: , a8 JTF_VARCHAR2_TABLE_100
751: , a9 JTF_DATE_TABLE
752: , a10 JTF_DATE_TABLE
753: , a11 JTF_VARCHAR2_TABLE_100
754: , a12 JTF_NUMBER_TABLE

Line 753: , a11 JTF_VARCHAR2_TABLE_100

749: , a7 JTF_NUMBER_TABLE
750: , a8 JTF_VARCHAR2_TABLE_100
751: , a9 JTF_DATE_TABLE
752: , a10 JTF_DATE_TABLE
753: , a11 JTF_VARCHAR2_TABLE_100
754: , a12 JTF_NUMBER_TABLE
755: , a13 JTF_NUMBER_TABLE
756: , a14 JTF_VARCHAR2_TABLE_100
757: , a15 JTF_VARCHAR2_TABLE_100

Line 756: , a14 JTF_VARCHAR2_TABLE_100

752: , a10 JTF_DATE_TABLE
753: , a11 JTF_VARCHAR2_TABLE_100
754: , a12 JTF_NUMBER_TABLE
755: , a13 JTF_NUMBER_TABLE
756: , a14 JTF_VARCHAR2_TABLE_100
757: , a15 JTF_VARCHAR2_TABLE_100
758: ) as
759: ddindx binary_integer; indx binary_integer;
760: begin

Line 757: , a15 JTF_VARCHAR2_TABLE_100

753: , a11 JTF_VARCHAR2_TABLE_100
754: , a12 JTF_NUMBER_TABLE
755: , a13 JTF_NUMBER_TABLE
756: , a14 JTF_VARCHAR2_TABLE_100
757: , a15 JTF_VARCHAR2_TABLE_100
758: ) as
759: ddindx binary_integer; indx binary_integer;
760: begin
761: if a0 is not null and a0.count > 0 then

Line 792: , a1 out nocopy JTF_VARCHAR2_TABLE_100

788: end if;
789: end if;
790: end rosetta_table_copy_in_p19;
791: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_VARCHAR2_TABLE_100
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_100
796: , a5 out nocopy JTF_NUMBER_TABLE

Line 795: , a4 out nocopy JTF_VARCHAR2_TABLE_100

791: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_VARCHAR2_TABLE_100
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_100
796: , a5 out nocopy JTF_NUMBER_TABLE
797: , a6 out nocopy JTF_NUMBER_TABLE
798: , a7 out nocopy JTF_NUMBER_TABLE
799: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 799: , a8 out nocopy JTF_VARCHAR2_TABLE_100

795: , a4 out nocopy JTF_VARCHAR2_TABLE_100
796: , a5 out nocopy JTF_NUMBER_TABLE
797: , a6 out nocopy JTF_NUMBER_TABLE
798: , a7 out nocopy JTF_NUMBER_TABLE
799: , a8 out nocopy JTF_VARCHAR2_TABLE_100
800: , a9 out nocopy JTF_DATE_TABLE
801: , a10 out nocopy JTF_DATE_TABLE
802: , a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , a12 out nocopy JTF_NUMBER_TABLE

Line 802: , a11 out nocopy JTF_VARCHAR2_TABLE_100

798: , a7 out nocopy JTF_NUMBER_TABLE
799: , a8 out nocopy JTF_VARCHAR2_TABLE_100
800: , a9 out nocopy JTF_DATE_TABLE
801: , a10 out nocopy JTF_DATE_TABLE
802: , a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
806: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 805: , a14 out nocopy JTF_VARCHAR2_TABLE_100

801: , a10 out nocopy JTF_DATE_TABLE
802: , a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
806: , a15 out nocopy JTF_VARCHAR2_TABLE_100
807: ) as
808: ddindx binary_integer; indx binary_integer;
809: begin

Line 806: , a15 out nocopy JTF_VARCHAR2_TABLE_100

802: , a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
806: , a15 out nocopy JTF_VARCHAR2_TABLE_100
807: ) as
808: ddindx binary_integer; indx binary_integer;
809: begin
810: if t is null or t.count = 0 then

Line 812: a1 := JTF_VARCHAR2_TABLE_100();

808: ddindx binary_integer; indx binary_integer;
809: begin
810: if t is null or t.count = 0 then
811: a0 := JTF_NUMBER_TABLE();
812: a1 := JTF_VARCHAR2_TABLE_100();
813: a2 := JTF_NUMBER_TABLE();
814: a3 := JTF_NUMBER_TABLE();
815: a4 := JTF_VARCHAR2_TABLE_100();
816: a5 := JTF_NUMBER_TABLE();

Line 815: a4 := JTF_VARCHAR2_TABLE_100();

811: a0 := JTF_NUMBER_TABLE();
812: a1 := JTF_VARCHAR2_TABLE_100();
813: a2 := JTF_NUMBER_TABLE();
814: a3 := JTF_NUMBER_TABLE();
815: a4 := JTF_VARCHAR2_TABLE_100();
816: a5 := JTF_NUMBER_TABLE();
817: a6 := JTF_NUMBER_TABLE();
818: a7 := JTF_NUMBER_TABLE();
819: a8 := JTF_VARCHAR2_TABLE_100();

Line 819: a8 := JTF_VARCHAR2_TABLE_100();

815: a4 := JTF_VARCHAR2_TABLE_100();
816: a5 := JTF_NUMBER_TABLE();
817: a6 := JTF_NUMBER_TABLE();
818: a7 := JTF_NUMBER_TABLE();
819: a8 := JTF_VARCHAR2_TABLE_100();
820: a9 := JTF_DATE_TABLE();
821: a10 := JTF_DATE_TABLE();
822: a11 := JTF_VARCHAR2_TABLE_100();
823: a12 := JTF_NUMBER_TABLE();

Line 822: a11 := JTF_VARCHAR2_TABLE_100();

818: a7 := JTF_NUMBER_TABLE();
819: a8 := JTF_VARCHAR2_TABLE_100();
820: a9 := JTF_DATE_TABLE();
821: a10 := JTF_DATE_TABLE();
822: a11 := JTF_VARCHAR2_TABLE_100();
823: a12 := JTF_NUMBER_TABLE();
824: a13 := JTF_NUMBER_TABLE();
825: a14 := JTF_VARCHAR2_TABLE_100();
826: a15 := JTF_VARCHAR2_TABLE_100();

Line 825: a14 := JTF_VARCHAR2_TABLE_100();

821: a10 := JTF_DATE_TABLE();
822: a11 := JTF_VARCHAR2_TABLE_100();
823: a12 := JTF_NUMBER_TABLE();
824: a13 := JTF_NUMBER_TABLE();
825: a14 := JTF_VARCHAR2_TABLE_100();
826: a15 := JTF_VARCHAR2_TABLE_100();
827: else
828: a0 := JTF_NUMBER_TABLE();
829: a1 := JTF_VARCHAR2_TABLE_100();

Line 826: a15 := JTF_VARCHAR2_TABLE_100();

822: a11 := JTF_VARCHAR2_TABLE_100();
823: a12 := JTF_NUMBER_TABLE();
824: a13 := JTF_NUMBER_TABLE();
825: a14 := JTF_VARCHAR2_TABLE_100();
826: a15 := JTF_VARCHAR2_TABLE_100();
827: else
828: a0 := JTF_NUMBER_TABLE();
829: a1 := JTF_VARCHAR2_TABLE_100();
830: a2 := JTF_NUMBER_TABLE();

Line 829: a1 := JTF_VARCHAR2_TABLE_100();

825: a14 := JTF_VARCHAR2_TABLE_100();
826: a15 := JTF_VARCHAR2_TABLE_100();
827: else
828: a0 := JTF_NUMBER_TABLE();
829: a1 := JTF_VARCHAR2_TABLE_100();
830: a2 := JTF_NUMBER_TABLE();
831: a3 := JTF_NUMBER_TABLE();
832: a4 := JTF_VARCHAR2_TABLE_100();
833: a5 := JTF_NUMBER_TABLE();

Line 832: a4 := JTF_VARCHAR2_TABLE_100();

828: a0 := JTF_NUMBER_TABLE();
829: a1 := JTF_VARCHAR2_TABLE_100();
830: a2 := JTF_NUMBER_TABLE();
831: a3 := JTF_NUMBER_TABLE();
832: a4 := JTF_VARCHAR2_TABLE_100();
833: a5 := JTF_NUMBER_TABLE();
834: a6 := JTF_NUMBER_TABLE();
835: a7 := JTF_NUMBER_TABLE();
836: a8 := JTF_VARCHAR2_TABLE_100();

Line 836: a8 := JTF_VARCHAR2_TABLE_100();

832: a4 := JTF_VARCHAR2_TABLE_100();
833: a5 := JTF_NUMBER_TABLE();
834: a6 := JTF_NUMBER_TABLE();
835: a7 := JTF_NUMBER_TABLE();
836: a8 := JTF_VARCHAR2_TABLE_100();
837: a9 := JTF_DATE_TABLE();
838: a10 := JTF_DATE_TABLE();
839: a11 := JTF_VARCHAR2_TABLE_100();
840: a12 := JTF_NUMBER_TABLE();

Line 839: a11 := JTF_VARCHAR2_TABLE_100();

835: a7 := JTF_NUMBER_TABLE();
836: a8 := JTF_VARCHAR2_TABLE_100();
837: a9 := JTF_DATE_TABLE();
838: a10 := JTF_DATE_TABLE();
839: a11 := JTF_VARCHAR2_TABLE_100();
840: a12 := JTF_NUMBER_TABLE();
841: a13 := JTF_NUMBER_TABLE();
842: a14 := JTF_VARCHAR2_TABLE_100();
843: a15 := JTF_VARCHAR2_TABLE_100();

Line 842: a14 := JTF_VARCHAR2_TABLE_100();

838: a10 := JTF_DATE_TABLE();
839: a11 := JTF_VARCHAR2_TABLE_100();
840: a12 := JTF_NUMBER_TABLE();
841: a13 := JTF_NUMBER_TABLE();
842: a14 := JTF_VARCHAR2_TABLE_100();
843: a15 := JTF_VARCHAR2_TABLE_100();
844: if t.count > 0 then
845: a0.extend(t.count);
846: a1.extend(t.count);

Line 843: a15 := JTF_VARCHAR2_TABLE_100();

839: a11 := JTF_VARCHAR2_TABLE_100();
840: a12 := JTF_NUMBER_TABLE();
841: a13 := JTF_NUMBER_TABLE();
842: a14 := JTF_VARCHAR2_TABLE_100();
843: a15 := JTF_VARCHAR2_TABLE_100();
844: if t.count > 0 then
845: a0.extend(t.count);
846: a1.extend(t.count);
847: a2.extend(t.count);

Line 891: , a1 JTF_VARCHAR2_TABLE_100

887: end if;
888: end rosetta_table_copy_out_p19;
889:
890: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
891: , a1 JTF_VARCHAR2_TABLE_100
892: , a2 JTF_VARCHAR2_TABLE_100
893: , a3 JTF_NUMBER_TABLE
894: , a4 JTF_VARCHAR2_TABLE_100
895: , a5 JTF_NUMBER_TABLE

Line 892: , a2 JTF_VARCHAR2_TABLE_100

888: end rosetta_table_copy_out_p19;
889:
890: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
891: , a1 JTF_VARCHAR2_TABLE_100
892: , a2 JTF_VARCHAR2_TABLE_100
893: , a3 JTF_NUMBER_TABLE
894: , a4 JTF_VARCHAR2_TABLE_100
895: , a5 JTF_NUMBER_TABLE
896: ) as

Line 894: , a4 JTF_VARCHAR2_TABLE_100

890: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
891: , a1 JTF_VARCHAR2_TABLE_100
892: , a2 JTF_VARCHAR2_TABLE_100
893: , a3 JTF_NUMBER_TABLE
894: , a4 JTF_VARCHAR2_TABLE_100
895: , a5 JTF_NUMBER_TABLE
896: ) as
897: ddindx binary_integer; indx binary_integer;
898: begin

Line 920: , a1 out nocopy JTF_VARCHAR2_TABLE_100

916: end if;
917: end if;
918: end rosetta_table_copy_in_p20;
919: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
920: , a1 out nocopy JTF_VARCHAR2_TABLE_100
921: , a2 out nocopy JTF_VARCHAR2_TABLE_100
922: , a3 out nocopy JTF_NUMBER_TABLE
923: , a4 out nocopy JTF_VARCHAR2_TABLE_100
924: , a5 out nocopy JTF_NUMBER_TABLE

Line 921: , a2 out nocopy JTF_VARCHAR2_TABLE_100

917: end if;
918: end rosetta_table_copy_in_p20;
919: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
920: , a1 out nocopy JTF_VARCHAR2_TABLE_100
921: , a2 out nocopy JTF_VARCHAR2_TABLE_100
922: , a3 out nocopy JTF_NUMBER_TABLE
923: , a4 out nocopy JTF_VARCHAR2_TABLE_100
924: , a5 out nocopy JTF_NUMBER_TABLE
925: ) as

Line 923: , a4 out nocopy JTF_VARCHAR2_TABLE_100

919: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
920: , a1 out nocopy JTF_VARCHAR2_TABLE_100
921: , a2 out nocopy JTF_VARCHAR2_TABLE_100
922: , a3 out nocopy JTF_NUMBER_TABLE
923: , a4 out nocopy JTF_VARCHAR2_TABLE_100
924: , a5 out nocopy JTF_NUMBER_TABLE
925: ) as
926: ddindx binary_integer; indx binary_integer;
927: begin

Line 930: a1 := JTF_VARCHAR2_TABLE_100();

926: ddindx binary_integer; indx binary_integer;
927: begin
928: if t is null or t.count = 0 then
929: a0 := JTF_NUMBER_TABLE();
930: a1 := JTF_VARCHAR2_TABLE_100();
931: a2 := JTF_VARCHAR2_TABLE_100();
932: a3 := JTF_NUMBER_TABLE();
933: a4 := JTF_VARCHAR2_TABLE_100();
934: a5 := JTF_NUMBER_TABLE();

Line 931: a2 := JTF_VARCHAR2_TABLE_100();

927: begin
928: if t is null or t.count = 0 then
929: a0 := JTF_NUMBER_TABLE();
930: a1 := JTF_VARCHAR2_TABLE_100();
931: a2 := JTF_VARCHAR2_TABLE_100();
932: a3 := JTF_NUMBER_TABLE();
933: a4 := JTF_VARCHAR2_TABLE_100();
934: a5 := JTF_NUMBER_TABLE();
935: else

Line 933: a4 := JTF_VARCHAR2_TABLE_100();

929: a0 := JTF_NUMBER_TABLE();
930: a1 := JTF_VARCHAR2_TABLE_100();
931: a2 := JTF_VARCHAR2_TABLE_100();
932: a3 := JTF_NUMBER_TABLE();
933: a4 := JTF_VARCHAR2_TABLE_100();
934: a5 := JTF_NUMBER_TABLE();
935: else
936: a0 := JTF_NUMBER_TABLE();
937: a1 := JTF_VARCHAR2_TABLE_100();

Line 937: a1 := JTF_VARCHAR2_TABLE_100();

933: a4 := JTF_VARCHAR2_TABLE_100();
934: a5 := JTF_NUMBER_TABLE();
935: else
936: a0 := JTF_NUMBER_TABLE();
937: a1 := JTF_VARCHAR2_TABLE_100();
938: a2 := JTF_VARCHAR2_TABLE_100();
939: a3 := JTF_NUMBER_TABLE();
940: a4 := JTF_VARCHAR2_TABLE_100();
941: a5 := JTF_NUMBER_TABLE();

Line 938: a2 := JTF_VARCHAR2_TABLE_100();

934: a5 := JTF_NUMBER_TABLE();
935: else
936: a0 := JTF_NUMBER_TABLE();
937: a1 := JTF_VARCHAR2_TABLE_100();
938: a2 := JTF_VARCHAR2_TABLE_100();
939: a3 := JTF_NUMBER_TABLE();
940: a4 := JTF_VARCHAR2_TABLE_100();
941: a5 := JTF_NUMBER_TABLE();
942: if t.count > 0 then

Line 940: a4 := JTF_VARCHAR2_TABLE_100();

936: a0 := JTF_NUMBER_TABLE();
937: a1 := JTF_VARCHAR2_TABLE_100();
938: a2 := JTF_VARCHAR2_TABLE_100();
939: a3 := JTF_NUMBER_TABLE();
940: a4 := JTF_VARCHAR2_TABLE_100();
941: a5 := JTF_NUMBER_TABLE();
942: if t.count > 0 then
943: a0.extend(t.count);
944: a1.extend(t.count);

Line 969: , a1 JTF_VARCHAR2_TABLE_100

965: end if;
966: end rosetta_table_copy_out_p20;
967:
968: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
969: , a1 JTF_VARCHAR2_TABLE_100
970: , a2 JTF_NUMBER_TABLE
971: , a3 JTF_VARCHAR2_TABLE_100
972: , a4 JTF_VARCHAR2_TABLE_100
973: , a5 JTF_VARCHAR2_TABLE_300

Line 971: , a3 JTF_VARCHAR2_TABLE_100

967:
968: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
969: , a1 JTF_VARCHAR2_TABLE_100
970: , a2 JTF_NUMBER_TABLE
971: , a3 JTF_VARCHAR2_TABLE_100
972: , a4 JTF_VARCHAR2_TABLE_100
973: , a5 JTF_VARCHAR2_TABLE_300
974: , a6 JTF_NUMBER_TABLE
975: , a7 JTF_VARCHAR2_TABLE_300

Line 972: , a4 JTF_VARCHAR2_TABLE_100

968: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
969: , a1 JTF_VARCHAR2_TABLE_100
970: , a2 JTF_NUMBER_TABLE
971: , a3 JTF_VARCHAR2_TABLE_100
972: , a4 JTF_VARCHAR2_TABLE_100
973: , a5 JTF_VARCHAR2_TABLE_300
974: , a6 JTF_NUMBER_TABLE
975: , a7 JTF_VARCHAR2_TABLE_300
976: , a8 JTF_VARCHAR2_TABLE_100

Line 976: , a8 JTF_VARCHAR2_TABLE_100

972: , a4 JTF_VARCHAR2_TABLE_100
973: , a5 JTF_VARCHAR2_TABLE_300
974: , a6 JTF_NUMBER_TABLE
975: , a7 JTF_VARCHAR2_TABLE_300
976: , a8 JTF_VARCHAR2_TABLE_100
977: , a9 JTF_VARCHAR2_TABLE_100
978: , a10 JTF_NUMBER_TABLE
979: , a11 JTF_NUMBER_TABLE
980: , a12 JTF_VARCHAR2_TABLE_100

Line 977: , a9 JTF_VARCHAR2_TABLE_100

973: , a5 JTF_VARCHAR2_TABLE_300
974: , a6 JTF_NUMBER_TABLE
975: , a7 JTF_VARCHAR2_TABLE_300
976: , a8 JTF_VARCHAR2_TABLE_100
977: , a9 JTF_VARCHAR2_TABLE_100
978: , a10 JTF_NUMBER_TABLE
979: , a11 JTF_NUMBER_TABLE
980: , a12 JTF_VARCHAR2_TABLE_100
981: , a13 JTF_NUMBER_TABLE

Line 980: , a12 JTF_VARCHAR2_TABLE_100

976: , a8 JTF_VARCHAR2_TABLE_100
977: , a9 JTF_VARCHAR2_TABLE_100
978: , a10 JTF_NUMBER_TABLE
979: , a11 JTF_NUMBER_TABLE
980: , a12 JTF_VARCHAR2_TABLE_100
981: , a13 JTF_NUMBER_TABLE
982: , a14 JTF_NUMBER_TABLE
983: , a15 JTF_VARCHAR2_TABLE_100
984: , a16 JTF_VARCHAR2_TABLE_100

Line 983: , a15 JTF_VARCHAR2_TABLE_100

979: , a11 JTF_NUMBER_TABLE
980: , a12 JTF_VARCHAR2_TABLE_100
981: , a13 JTF_NUMBER_TABLE
982: , a14 JTF_NUMBER_TABLE
983: , a15 JTF_VARCHAR2_TABLE_100
984: , a16 JTF_VARCHAR2_TABLE_100
985: , a17 JTF_DATE_TABLE
986: , a18 JTF_DATE_TABLE
987: , a19 JTF_VARCHAR2_TABLE_100

Line 984: , a16 JTF_VARCHAR2_TABLE_100

980: , a12 JTF_VARCHAR2_TABLE_100
981: , a13 JTF_NUMBER_TABLE
982: , a14 JTF_NUMBER_TABLE
983: , a15 JTF_VARCHAR2_TABLE_100
984: , a16 JTF_VARCHAR2_TABLE_100
985: , a17 JTF_DATE_TABLE
986: , a18 JTF_DATE_TABLE
987: , a19 JTF_VARCHAR2_TABLE_100
988: , a20 JTF_VARCHAR2_TABLE_100

Line 987: , a19 JTF_VARCHAR2_TABLE_100

983: , a15 JTF_VARCHAR2_TABLE_100
984: , a16 JTF_VARCHAR2_TABLE_100
985: , a17 JTF_DATE_TABLE
986: , a18 JTF_DATE_TABLE
987: , a19 JTF_VARCHAR2_TABLE_100
988: , a20 JTF_VARCHAR2_TABLE_100
989: ) as
990: ddindx binary_integer; indx binary_integer;
991: begin

Line 988: , a20 JTF_VARCHAR2_TABLE_100

984: , a16 JTF_VARCHAR2_TABLE_100
985: , a17 JTF_DATE_TABLE
986: , a18 JTF_DATE_TABLE
987: , a19 JTF_VARCHAR2_TABLE_100
988: , a20 JTF_VARCHAR2_TABLE_100
989: ) as
990: ddindx binary_integer; indx binary_integer;
991: begin
992: if a0 is not null and a0.count=0 then

Line 1032: , a1 out nocopy JTF_VARCHAR2_TABLE_100

1028: end if;
1029: end if;
1030: end rosetta_table_copy_in_p21;
1031: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
1032: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1033: , a2 out nocopy JTF_NUMBER_TABLE
1034: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1036: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1034: , a3 out nocopy JTF_VARCHAR2_TABLE_100

1030: end rosetta_table_copy_in_p21;
1031: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
1032: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1033: , a2 out nocopy JTF_NUMBER_TABLE
1034: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1036: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1037: , a6 out nocopy JTF_NUMBER_TABLE
1038: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 1035: , a4 out nocopy JTF_VARCHAR2_TABLE_100

1031: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
1032: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1033: , a2 out nocopy JTF_NUMBER_TABLE
1034: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1036: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1037: , a6 out nocopy JTF_NUMBER_TABLE
1038: , a7 out nocopy JTF_VARCHAR2_TABLE_300
1039: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1039: , a8 out nocopy JTF_VARCHAR2_TABLE_100

1035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1036: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1037: , a6 out nocopy JTF_NUMBER_TABLE
1038: , a7 out nocopy JTF_VARCHAR2_TABLE_300
1039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1041: , a10 out nocopy JTF_NUMBER_TABLE
1042: , a11 out nocopy JTF_NUMBER_TABLE
1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 1040: , a9 out nocopy JTF_VARCHAR2_TABLE_100

1036: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1037: , a6 out nocopy JTF_NUMBER_TABLE
1038: , a7 out nocopy JTF_VARCHAR2_TABLE_300
1039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1041: , a10 out nocopy JTF_NUMBER_TABLE
1042: , a11 out nocopy JTF_NUMBER_TABLE
1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1044: , a13 out nocopy JTF_NUMBER_TABLE

Line 1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100

1039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1041: , a10 out nocopy JTF_NUMBER_TABLE
1042: , a11 out nocopy JTF_NUMBER_TABLE
1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1044: , a13 out nocopy JTF_NUMBER_TABLE
1045: , a14 out nocopy JTF_NUMBER_TABLE
1046: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1047: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 1046: , a15 out nocopy JTF_VARCHAR2_TABLE_100

1042: , a11 out nocopy JTF_NUMBER_TABLE
1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1044: , a13 out nocopy JTF_NUMBER_TABLE
1045: , a14 out nocopy JTF_NUMBER_TABLE
1046: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1047: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1048: , a17 out nocopy JTF_DATE_TABLE
1049: , a18 out nocopy JTF_DATE_TABLE
1050: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 1047: , a16 out nocopy JTF_VARCHAR2_TABLE_100

1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1044: , a13 out nocopy JTF_NUMBER_TABLE
1045: , a14 out nocopy JTF_NUMBER_TABLE
1046: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1047: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1048: , a17 out nocopy JTF_DATE_TABLE
1049: , a18 out nocopy JTF_DATE_TABLE
1050: , a19 out nocopy JTF_VARCHAR2_TABLE_100
1051: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 1050: , a19 out nocopy JTF_VARCHAR2_TABLE_100

1046: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1047: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1048: , a17 out nocopy JTF_DATE_TABLE
1049: , a18 out nocopy JTF_DATE_TABLE
1050: , a19 out nocopy JTF_VARCHAR2_TABLE_100
1051: , a20 out nocopy JTF_VARCHAR2_TABLE_100
1052: ) as
1053: ddindx binary_integer; indx binary_integer;
1054: begin

Line 1051: , a20 out nocopy JTF_VARCHAR2_TABLE_100

1047: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1048: , a17 out nocopy JTF_DATE_TABLE
1049: , a18 out nocopy JTF_DATE_TABLE
1050: , a19 out nocopy JTF_VARCHAR2_TABLE_100
1051: , a20 out nocopy JTF_VARCHAR2_TABLE_100
1052: ) as
1053: ddindx binary_integer; indx binary_integer;
1054: begin
1055: if t is null then

Line 1079: a1 := JTF_VARCHAR2_TABLE_100();

1075: a19 := null;
1076: a20 := null;
1077: elsif t.count = 0 then
1078: a0 := JTF_NUMBER_TABLE();
1079: a1 := JTF_VARCHAR2_TABLE_100();
1080: a2 := JTF_NUMBER_TABLE();
1081: a3 := JTF_VARCHAR2_TABLE_100();
1082: a4 := JTF_VARCHAR2_TABLE_100();
1083: a5 := JTF_VARCHAR2_TABLE_300();

Line 1081: a3 := JTF_VARCHAR2_TABLE_100();

1077: elsif t.count = 0 then
1078: a0 := JTF_NUMBER_TABLE();
1079: a1 := JTF_VARCHAR2_TABLE_100();
1080: a2 := JTF_NUMBER_TABLE();
1081: a3 := JTF_VARCHAR2_TABLE_100();
1082: a4 := JTF_VARCHAR2_TABLE_100();
1083: a5 := JTF_VARCHAR2_TABLE_300();
1084: a6 := JTF_NUMBER_TABLE();
1085: a7 := JTF_VARCHAR2_TABLE_300();

Line 1082: a4 := JTF_VARCHAR2_TABLE_100();

1078: a0 := JTF_NUMBER_TABLE();
1079: a1 := JTF_VARCHAR2_TABLE_100();
1080: a2 := JTF_NUMBER_TABLE();
1081: a3 := JTF_VARCHAR2_TABLE_100();
1082: a4 := JTF_VARCHAR2_TABLE_100();
1083: a5 := JTF_VARCHAR2_TABLE_300();
1084: a6 := JTF_NUMBER_TABLE();
1085: a7 := JTF_VARCHAR2_TABLE_300();
1086: a8 := JTF_VARCHAR2_TABLE_100();

Line 1086: a8 := JTF_VARCHAR2_TABLE_100();

1082: a4 := JTF_VARCHAR2_TABLE_100();
1083: a5 := JTF_VARCHAR2_TABLE_300();
1084: a6 := JTF_NUMBER_TABLE();
1085: a7 := JTF_VARCHAR2_TABLE_300();
1086: a8 := JTF_VARCHAR2_TABLE_100();
1087: a9 := JTF_VARCHAR2_TABLE_100();
1088: a10 := JTF_NUMBER_TABLE();
1089: a11 := JTF_NUMBER_TABLE();
1090: a12 := JTF_VARCHAR2_TABLE_100();

Line 1087: a9 := JTF_VARCHAR2_TABLE_100();

1083: a5 := JTF_VARCHAR2_TABLE_300();
1084: a6 := JTF_NUMBER_TABLE();
1085: a7 := JTF_VARCHAR2_TABLE_300();
1086: a8 := JTF_VARCHAR2_TABLE_100();
1087: a9 := JTF_VARCHAR2_TABLE_100();
1088: a10 := JTF_NUMBER_TABLE();
1089: a11 := JTF_NUMBER_TABLE();
1090: a12 := JTF_VARCHAR2_TABLE_100();
1091: a13 := JTF_NUMBER_TABLE();

Line 1090: a12 := JTF_VARCHAR2_TABLE_100();

1086: a8 := JTF_VARCHAR2_TABLE_100();
1087: a9 := JTF_VARCHAR2_TABLE_100();
1088: a10 := JTF_NUMBER_TABLE();
1089: a11 := JTF_NUMBER_TABLE();
1090: a12 := JTF_VARCHAR2_TABLE_100();
1091: a13 := JTF_NUMBER_TABLE();
1092: a14 := JTF_NUMBER_TABLE();
1093: a15 := JTF_VARCHAR2_TABLE_100();
1094: a16 := JTF_VARCHAR2_TABLE_100();

Line 1093: a15 := JTF_VARCHAR2_TABLE_100();

1089: a11 := JTF_NUMBER_TABLE();
1090: a12 := JTF_VARCHAR2_TABLE_100();
1091: a13 := JTF_NUMBER_TABLE();
1092: a14 := JTF_NUMBER_TABLE();
1093: a15 := JTF_VARCHAR2_TABLE_100();
1094: a16 := JTF_VARCHAR2_TABLE_100();
1095: a17 := JTF_DATE_TABLE();
1096: a18 := JTF_DATE_TABLE();
1097: a19 := JTF_VARCHAR2_TABLE_100();

Line 1094: a16 := JTF_VARCHAR2_TABLE_100();

1090: a12 := JTF_VARCHAR2_TABLE_100();
1091: a13 := JTF_NUMBER_TABLE();
1092: a14 := JTF_NUMBER_TABLE();
1093: a15 := JTF_VARCHAR2_TABLE_100();
1094: a16 := JTF_VARCHAR2_TABLE_100();
1095: a17 := JTF_DATE_TABLE();
1096: a18 := JTF_DATE_TABLE();
1097: a19 := JTF_VARCHAR2_TABLE_100();
1098: a20 := JTF_VARCHAR2_TABLE_100();

Line 1097: a19 := JTF_VARCHAR2_TABLE_100();

1093: a15 := JTF_VARCHAR2_TABLE_100();
1094: a16 := JTF_VARCHAR2_TABLE_100();
1095: a17 := JTF_DATE_TABLE();
1096: a18 := JTF_DATE_TABLE();
1097: a19 := JTF_VARCHAR2_TABLE_100();
1098: a20 := JTF_VARCHAR2_TABLE_100();
1099: else
1100: a0 := JTF_NUMBER_TABLE();
1101: a1 := JTF_VARCHAR2_TABLE_100();

Line 1098: a20 := JTF_VARCHAR2_TABLE_100();

1094: a16 := JTF_VARCHAR2_TABLE_100();
1095: a17 := JTF_DATE_TABLE();
1096: a18 := JTF_DATE_TABLE();
1097: a19 := JTF_VARCHAR2_TABLE_100();
1098: a20 := JTF_VARCHAR2_TABLE_100();
1099: else
1100: a0 := JTF_NUMBER_TABLE();
1101: a1 := JTF_VARCHAR2_TABLE_100();
1102: a2 := JTF_NUMBER_TABLE();

Line 1101: a1 := JTF_VARCHAR2_TABLE_100();

1097: a19 := JTF_VARCHAR2_TABLE_100();
1098: a20 := JTF_VARCHAR2_TABLE_100();
1099: else
1100: a0 := JTF_NUMBER_TABLE();
1101: a1 := JTF_VARCHAR2_TABLE_100();
1102: a2 := JTF_NUMBER_TABLE();
1103: a3 := JTF_VARCHAR2_TABLE_100();
1104: a4 := JTF_VARCHAR2_TABLE_100();
1105: a5 := JTF_VARCHAR2_TABLE_300();

Line 1103: a3 := JTF_VARCHAR2_TABLE_100();

1099: else
1100: a0 := JTF_NUMBER_TABLE();
1101: a1 := JTF_VARCHAR2_TABLE_100();
1102: a2 := JTF_NUMBER_TABLE();
1103: a3 := JTF_VARCHAR2_TABLE_100();
1104: a4 := JTF_VARCHAR2_TABLE_100();
1105: a5 := JTF_VARCHAR2_TABLE_300();
1106: a6 := JTF_NUMBER_TABLE();
1107: a7 := JTF_VARCHAR2_TABLE_300();

Line 1104: a4 := JTF_VARCHAR2_TABLE_100();

1100: a0 := JTF_NUMBER_TABLE();
1101: a1 := JTF_VARCHAR2_TABLE_100();
1102: a2 := JTF_NUMBER_TABLE();
1103: a3 := JTF_VARCHAR2_TABLE_100();
1104: a4 := JTF_VARCHAR2_TABLE_100();
1105: a5 := JTF_VARCHAR2_TABLE_300();
1106: a6 := JTF_NUMBER_TABLE();
1107: a7 := JTF_VARCHAR2_TABLE_300();
1108: a8 := JTF_VARCHAR2_TABLE_100();

Line 1108: a8 := JTF_VARCHAR2_TABLE_100();

1104: a4 := JTF_VARCHAR2_TABLE_100();
1105: a5 := JTF_VARCHAR2_TABLE_300();
1106: a6 := JTF_NUMBER_TABLE();
1107: a7 := JTF_VARCHAR2_TABLE_300();
1108: a8 := JTF_VARCHAR2_TABLE_100();
1109: a9 := JTF_VARCHAR2_TABLE_100();
1110: a10 := JTF_NUMBER_TABLE();
1111: a11 := JTF_NUMBER_TABLE();
1112: a12 := JTF_VARCHAR2_TABLE_100();

Line 1109: a9 := JTF_VARCHAR2_TABLE_100();

1105: a5 := JTF_VARCHAR2_TABLE_300();
1106: a6 := JTF_NUMBER_TABLE();
1107: a7 := JTF_VARCHAR2_TABLE_300();
1108: a8 := JTF_VARCHAR2_TABLE_100();
1109: a9 := JTF_VARCHAR2_TABLE_100();
1110: a10 := JTF_NUMBER_TABLE();
1111: a11 := JTF_NUMBER_TABLE();
1112: a12 := JTF_VARCHAR2_TABLE_100();
1113: a13 := JTF_NUMBER_TABLE();

Line 1112: a12 := JTF_VARCHAR2_TABLE_100();

1108: a8 := JTF_VARCHAR2_TABLE_100();
1109: a9 := JTF_VARCHAR2_TABLE_100();
1110: a10 := JTF_NUMBER_TABLE();
1111: a11 := JTF_NUMBER_TABLE();
1112: a12 := JTF_VARCHAR2_TABLE_100();
1113: a13 := JTF_NUMBER_TABLE();
1114: a14 := JTF_NUMBER_TABLE();
1115: a15 := JTF_VARCHAR2_TABLE_100();
1116: a16 := JTF_VARCHAR2_TABLE_100();

Line 1115: a15 := JTF_VARCHAR2_TABLE_100();

1111: a11 := JTF_NUMBER_TABLE();
1112: a12 := JTF_VARCHAR2_TABLE_100();
1113: a13 := JTF_NUMBER_TABLE();
1114: a14 := JTF_NUMBER_TABLE();
1115: a15 := JTF_VARCHAR2_TABLE_100();
1116: a16 := JTF_VARCHAR2_TABLE_100();
1117: a17 := JTF_DATE_TABLE();
1118: a18 := JTF_DATE_TABLE();
1119: a19 := JTF_VARCHAR2_TABLE_100();

Line 1116: a16 := JTF_VARCHAR2_TABLE_100();

1112: a12 := JTF_VARCHAR2_TABLE_100();
1113: a13 := JTF_NUMBER_TABLE();
1114: a14 := JTF_NUMBER_TABLE();
1115: a15 := JTF_VARCHAR2_TABLE_100();
1116: a16 := JTF_VARCHAR2_TABLE_100();
1117: a17 := JTF_DATE_TABLE();
1118: a18 := JTF_DATE_TABLE();
1119: a19 := JTF_VARCHAR2_TABLE_100();
1120: a20 := JTF_VARCHAR2_TABLE_100();

Line 1119: a19 := JTF_VARCHAR2_TABLE_100();

1115: a15 := JTF_VARCHAR2_TABLE_100();
1116: a16 := JTF_VARCHAR2_TABLE_100();
1117: a17 := JTF_DATE_TABLE();
1118: a18 := JTF_DATE_TABLE();
1119: a19 := JTF_VARCHAR2_TABLE_100();
1120: a20 := JTF_VARCHAR2_TABLE_100();
1121: if t.count > 0 then
1122: a0.extend(t.count);
1123: a1.extend(t.count);

Line 1120: a20 := JTF_VARCHAR2_TABLE_100();

1116: a16 := JTF_VARCHAR2_TABLE_100();
1117: a17 := JTF_DATE_TABLE();
1118: a18 := JTF_DATE_TABLE();
1119: a19 := JTF_VARCHAR2_TABLE_100();
1120: a20 := JTF_VARCHAR2_TABLE_100();
1121: if t.count > 0 then
1122: a0.extend(t.count);
1123: a1.extend(t.count);
1124: a2.extend(t.count);

Line 1177: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100

1173: end if;
1174: end if;
1175: end rosetta_table_copy_out_p21;
1176:
1177: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1178: , a1 JTF_NUMBER_TABLE
1179: , a2 JTF_NUMBER_TABLE
1180: , a3 JTF_VARCHAR2_TABLE_100
1181: , a4 JTF_VARCHAR2_TABLE_100

Line 1180: , a3 JTF_VARCHAR2_TABLE_100

1176:
1177: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1178: , a1 JTF_NUMBER_TABLE
1179: , a2 JTF_NUMBER_TABLE
1180: , a3 JTF_VARCHAR2_TABLE_100
1181: , a4 JTF_VARCHAR2_TABLE_100
1182: , a5 JTF_VARCHAR2_TABLE_300
1183: ) as
1184: ddindx binary_integer; indx binary_integer;

Line 1181: , a4 JTF_VARCHAR2_TABLE_100

1177: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1178: , a1 JTF_NUMBER_TABLE
1179: , a2 JTF_NUMBER_TABLE
1180: , a3 JTF_VARCHAR2_TABLE_100
1181: , a4 JTF_VARCHAR2_TABLE_100
1182: , a5 JTF_VARCHAR2_TABLE_300
1183: ) as
1184: ddindx binary_integer; indx binary_integer;
1185: begin

Line 1210: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

1206: end loop;
1207: end if;
1208: end if;
1209: end rosetta_table_copy_in_p22;
1210: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1211: , a1 out nocopy JTF_NUMBER_TABLE
1212: , a2 out nocopy JTF_NUMBER_TABLE
1213: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1214: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1213: , a3 out nocopy JTF_VARCHAR2_TABLE_100

1209: end rosetta_table_copy_in_p22;
1210: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1211: , a1 out nocopy JTF_NUMBER_TABLE
1212: , a2 out nocopy JTF_NUMBER_TABLE
1213: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1214: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1215: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1216: ) as
1217: ddindx binary_integer; indx binary_integer;

Line 1214: , a4 out nocopy JTF_VARCHAR2_TABLE_100

1210: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1211: , a1 out nocopy JTF_NUMBER_TABLE
1212: , a2 out nocopy JTF_NUMBER_TABLE
1213: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1214: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1215: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1216: ) as
1217: ddindx binary_integer; indx binary_integer;
1218: begin

Line 1227: a0 := JTF_VARCHAR2_TABLE_100();

1223: a3 := null;
1224: a4 := null;
1225: a5 := null;
1226: elsif t.count = 0 then
1227: a0 := JTF_VARCHAR2_TABLE_100();
1228: a1 := JTF_NUMBER_TABLE();
1229: a2 := JTF_NUMBER_TABLE();
1230: a3 := JTF_VARCHAR2_TABLE_100();
1231: a4 := JTF_VARCHAR2_TABLE_100();

Line 1230: a3 := JTF_VARCHAR2_TABLE_100();

1226: elsif t.count = 0 then
1227: a0 := JTF_VARCHAR2_TABLE_100();
1228: a1 := JTF_NUMBER_TABLE();
1229: a2 := JTF_NUMBER_TABLE();
1230: a3 := JTF_VARCHAR2_TABLE_100();
1231: a4 := JTF_VARCHAR2_TABLE_100();
1232: a5 := JTF_VARCHAR2_TABLE_300();
1233: else
1234: a0 := JTF_VARCHAR2_TABLE_100();

Line 1231: a4 := JTF_VARCHAR2_TABLE_100();

1227: a0 := JTF_VARCHAR2_TABLE_100();
1228: a1 := JTF_NUMBER_TABLE();
1229: a2 := JTF_NUMBER_TABLE();
1230: a3 := JTF_VARCHAR2_TABLE_100();
1231: a4 := JTF_VARCHAR2_TABLE_100();
1232: a5 := JTF_VARCHAR2_TABLE_300();
1233: else
1234: a0 := JTF_VARCHAR2_TABLE_100();
1235: a1 := JTF_NUMBER_TABLE();

Line 1234: a0 := JTF_VARCHAR2_TABLE_100();

1230: a3 := JTF_VARCHAR2_TABLE_100();
1231: a4 := JTF_VARCHAR2_TABLE_100();
1232: a5 := JTF_VARCHAR2_TABLE_300();
1233: else
1234: a0 := JTF_VARCHAR2_TABLE_100();
1235: a1 := JTF_NUMBER_TABLE();
1236: a2 := JTF_NUMBER_TABLE();
1237: a3 := JTF_VARCHAR2_TABLE_100();
1238: a4 := JTF_VARCHAR2_TABLE_100();

Line 1237: a3 := JTF_VARCHAR2_TABLE_100();

1233: else
1234: a0 := JTF_VARCHAR2_TABLE_100();
1235: a1 := JTF_NUMBER_TABLE();
1236: a2 := JTF_NUMBER_TABLE();
1237: a3 := JTF_VARCHAR2_TABLE_100();
1238: a4 := JTF_VARCHAR2_TABLE_100();
1239: a5 := JTF_VARCHAR2_TABLE_300();
1240: if t.count > 0 then
1241: a0.extend(t.count);

Line 1238: a4 := JTF_VARCHAR2_TABLE_100();

1234: a0 := JTF_VARCHAR2_TABLE_100();
1235: a1 := JTF_NUMBER_TABLE();
1236: a2 := JTF_NUMBER_TABLE();
1237: a3 := JTF_VARCHAR2_TABLE_100();
1238: a4 := JTF_VARCHAR2_TABLE_100();
1239: a5 := JTF_VARCHAR2_TABLE_300();
1240: if t.count > 0 then
1241: a0.extend(t.count);
1242: a1.extend(t.count);

Line 1267: , a1 JTF_VARCHAR2_TABLE_100

1263: end if;
1264: end rosetta_table_copy_out_p22;
1265:
1266: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1267: , a1 JTF_VARCHAR2_TABLE_100
1268: , a2 JTF_VARCHAR2_TABLE_100
1269: , a3 JTF_NUMBER_TABLE
1270: , a4 JTF_NUMBER_TABLE
1271: , a5 JTF_VARCHAR2_TABLE_100

Line 1268: , a2 JTF_VARCHAR2_TABLE_100

1264: end rosetta_table_copy_out_p22;
1265:
1266: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1267: , a1 JTF_VARCHAR2_TABLE_100
1268: , a2 JTF_VARCHAR2_TABLE_100
1269: , a3 JTF_NUMBER_TABLE
1270: , a4 JTF_NUMBER_TABLE
1271: , a5 JTF_VARCHAR2_TABLE_100
1272: , a6 JTF_NUMBER_TABLE

Line 1271: , a5 JTF_VARCHAR2_TABLE_100

1267: , a1 JTF_VARCHAR2_TABLE_100
1268: , a2 JTF_VARCHAR2_TABLE_100
1269: , a3 JTF_NUMBER_TABLE
1270: , a4 JTF_NUMBER_TABLE
1271: , a5 JTF_VARCHAR2_TABLE_100
1272: , a6 JTF_NUMBER_TABLE
1273: , a7 JTF_NUMBER_TABLE
1274: ) as
1275: ddindx binary_integer; indx binary_integer;

Line 1304: , a1 out nocopy JTF_VARCHAR2_TABLE_100

1300: end if;
1301: end if;
1302: end rosetta_table_copy_in_p23;
1303: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1304: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1305: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1306: , a3 out nocopy JTF_NUMBER_TABLE
1307: , a4 out nocopy JTF_NUMBER_TABLE
1308: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1305: , a2 out nocopy JTF_VARCHAR2_TABLE_100

1301: end if;
1302: end rosetta_table_copy_in_p23;
1303: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1304: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1305: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1306: , a3 out nocopy JTF_NUMBER_TABLE
1307: , a4 out nocopy JTF_NUMBER_TABLE
1308: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1309: , a6 out nocopy JTF_NUMBER_TABLE

Line 1308: , a5 out nocopy JTF_VARCHAR2_TABLE_100

1304: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1305: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1306: , a3 out nocopy JTF_NUMBER_TABLE
1307: , a4 out nocopy JTF_NUMBER_TABLE
1308: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1309: , a6 out nocopy JTF_NUMBER_TABLE
1310: , a7 out nocopy JTF_NUMBER_TABLE
1311: ) as
1312: ddindx binary_integer; indx binary_integer;

Line 1325: a1 := JTF_VARCHAR2_TABLE_100();

1321: a6 := null;
1322: a7 := null;
1323: elsif t.count = 0 then
1324: a0 := JTF_NUMBER_TABLE();
1325: a1 := JTF_VARCHAR2_TABLE_100();
1326: a2 := JTF_VARCHAR2_TABLE_100();
1327: a3 := JTF_NUMBER_TABLE();
1328: a4 := JTF_NUMBER_TABLE();
1329: a5 := JTF_VARCHAR2_TABLE_100();

Line 1326: a2 := JTF_VARCHAR2_TABLE_100();

1322: a7 := null;
1323: elsif t.count = 0 then
1324: a0 := JTF_NUMBER_TABLE();
1325: a1 := JTF_VARCHAR2_TABLE_100();
1326: a2 := JTF_VARCHAR2_TABLE_100();
1327: a3 := JTF_NUMBER_TABLE();
1328: a4 := JTF_NUMBER_TABLE();
1329: a5 := JTF_VARCHAR2_TABLE_100();
1330: a6 := JTF_NUMBER_TABLE();

Line 1329: a5 := JTF_VARCHAR2_TABLE_100();

1325: a1 := JTF_VARCHAR2_TABLE_100();
1326: a2 := JTF_VARCHAR2_TABLE_100();
1327: a3 := JTF_NUMBER_TABLE();
1328: a4 := JTF_NUMBER_TABLE();
1329: a5 := JTF_VARCHAR2_TABLE_100();
1330: a6 := JTF_NUMBER_TABLE();
1331: a7 := JTF_NUMBER_TABLE();
1332: else
1333: a0 := JTF_NUMBER_TABLE();

Line 1334: a1 := JTF_VARCHAR2_TABLE_100();

1330: a6 := JTF_NUMBER_TABLE();
1331: a7 := JTF_NUMBER_TABLE();
1332: else
1333: a0 := JTF_NUMBER_TABLE();
1334: a1 := JTF_VARCHAR2_TABLE_100();
1335: a2 := JTF_VARCHAR2_TABLE_100();
1336: a3 := JTF_NUMBER_TABLE();
1337: a4 := JTF_NUMBER_TABLE();
1338: a5 := JTF_VARCHAR2_TABLE_100();

Line 1335: a2 := JTF_VARCHAR2_TABLE_100();

1331: a7 := JTF_NUMBER_TABLE();
1332: else
1333: a0 := JTF_NUMBER_TABLE();
1334: a1 := JTF_VARCHAR2_TABLE_100();
1335: a2 := JTF_VARCHAR2_TABLE_100();
1336: a3 := JTF_NUMBER_TABLE();
1337: a4 := JTF_NUMBER_TABLE();
1338: a5 := JTF_VARCHAR2_TABLE_100();
1339: a6 := JTF_NUMBER_TABLE();

Line 1338: a5 := JTF_VARCHAR2_TABLE_100();

1334: a1 := JTF_VARCHAR2_TABLE_100();
1335: a2 := JTF_VARCHAR2_TABLE_100();
1336: a3 := JTF_NUMBER_TABLE();
1337: a4 := JTF_NUMBER_TABLE();
1338: a5 := JTF_VARCHAR2_TABLE_100();
1339: a6 := JTF_NUMBER_TABLE();
1340: a7 := JTF_NUMBER_TABLE();
1341: if t.count > 0 then
1342: a0.extend(t.count);

Line 1374: , p2_a1 JTF_VARCHAR2_TABLE_100

1370:
1371: procedure get_availability_options(p_api_version_number NUMBER
1372: , p_task_id NUMBER
1373: , p2_a0 JTF_NUMBER_TABLE
1374: , p2_a1 JTF_VARCHAR2_TABLE_100
1375: , p3_a0 DATE
1376: , p3_a1 DATE
1377: , p_likelihood NUMBER
1378: , p_subinv_only number

Line 1383: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

1379: , p_mandatory number
1380: , p_trunk number
1381: , p_warehouse number
1382: , p9_a0 out nocopy JTF_NUMBER_TABLE
1383: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1384: , p9_a2 out nocopy JTF_DATE_TABLE
1385: , p9_a3 out nocopy JTF_NUMBER_TABLE
1386: , p9_a4 out nocopy JTF_NUMBER_TABLE
1387: , p9_a5 out nocopy JTF_NUMBER_TABLE

Line 1590: , p4_a1 JTF_VARCHAR2_TABLE_100

1586: , p_organization_id NUMBER
1587: , p_subinv_code VARCHAR2
1588: , p_need_by_date date
1589: , p4_a0 JTF_NUMBER_TABLE
1590: , p4_a1 JTF_VARCHAR2_TABLE_100
1591: , p4_a2 JTF_VARCHAR2_TABLE_100
1592: , p4_a3 JTF_NUMBER_TABLE
1593: , p4_a4 JTF_VARCHAR2_TABLE_100
1594: , p4_a5 JTF_NUMBER_TABLE

Line 1591: , p4_a2 JTF_VARCHAR2_TABLE_100

1587: , p_subinv_code VARCHAR2
1588: , p_need_by_date date
1589: , p4_a0 JTF_NUMBER_TABLE
1590: , p4_a1 JTF_VARCHAR2_TABLE_100
1591: , p4_a2 JTF_VARCHAR2_TABLE_100
1592: , p4_a3 JTF_NUMBER_TABLE
1593: , p4_a4 JTF_VARCHAR2_TABLE_100
1594: , p4_a5 JTF_NUMBER_TABLE
1595: , p_timezone_id NUMBER

Line 1593: , p4_a4 JTF_VARCHAR2_TABLE_100

1589: , p4_a0 JTF_NUMBER_TABLE
1590: , p4_a1 JTF_VARCHAR2_TABLE_100
1591: , p4_a2 JTF_VARCHAR2_TABLE_100
1592: , p4_a3 JTF_NUMBER_TABLE
1593: , p4_a4 JTF_VARCHAR2_TABLE_100
1594: , p4_a5 JTF_NUMBER_TABLE
1595: , p_timezone_id NUMBER
1596: , p6_a0 out nocopy JTF_NUMBER_TABLE
1597: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 1597: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

1593: , p4_a4 JTF_VARCHAR2_TABLE_100
1594: , p4_a5 JTF_NUMBER_TABLE
1595: , p_timezone_id NUMBER
1596: , p6_a0 out nocopy JTF_NUMBER_TABLE
1597: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1598: , p6_a2 out nocopy JTF_NUMBER_TABLE
1599: , p6_a3 out nocopy JTF_NUMBER_TABLE
1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

1596: , p6_a0 out nocopy JTF_NUMBER_TABLE
1597: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1598: , p6_a2 out nocopy JTF_NUMBER_TABLE
1599: , p6_a3 out nocopy JTF_NUMBER_TABLE
1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p6_a5 out nocopy JTF_NUMBER_TABLE
1602: , p6_a6 out nocopy JTF_NUMBER_TABLE
1603: , p6_a7 out nocopy JTF_NUMBER_TABLE
1604: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1604: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p6_a5 out nocopy JTF_NUMBER_TABLE
1602: , p6_a6 out nocopy JTF_NUMBER_TABLE
1603: , p6_a7 out nocopy JTF_NUMBER_TABLE
1604: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a9 out nocopy JTF_DATE_TABLE
1606: , p6_a10 out nocopy JTF_DATE_TABLE
1607: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 1607: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

1603: , p6_a7 out nocopy JTF_NUMBER_TABLE
1604: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a9 out nocopy JTF_DATE_TABLE
1606: , p6_a10 out nocopy JTF_DATE_TABLE
1607: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p6_a12 out nocopy JTF_NUMBER_TABLE
1609: , p6_a13 out nocopy JTF_NUMBER_TABLE
1610: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1610: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

1606: , p6_a10 out nocopy JTF_DATE_TABLE
1607: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p6_a12 out nocopy JTF_NUMBER_TABLE
1609: , p6_a13 out nocopy JTF_NUMBER_TABLE
1610: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1612: , x_return_status out nocopy VARCHAR2
1613: , x_msg_data out nocopy VARCHAR2
1614: , x_msg_count out nocopy NUMBER

Line 1611: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

1607: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p6_a12 out nocopy JTF_NUMBER_TABLE
1609: , p6_a13 out nocopy JTF_NUMBER_TABLE
1610: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1612: , x_return_status out nocopy VARCHAR2
1613: , x_msg_data out nocopy VARCHAR2
1614: , x_msg_count out nocopy NUMBER
1615: , p_called_from VARCHAR2

Line 1737: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100

1733:
1734: return ddrosetta_retval;
1735: end;
1736:
1737: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1738: , p0_a1 JTF_NUMBER_TABLE
1739: , p0_a2 JTF_NUMBER_TABLE
1740: , p0_a3 JTF_VARCHAR2_TABLE_100
1741: , p0_a4 JTF_VARCHAR2_TABLE_100

Line 1740: , p0_a3 JTF_VARCHAR2_TABLE_100

1736:
1737: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1738: , p0_a1 JTF_NUMBER_TABLE
1739: , p0_a2 JTF_NUMBER_TABLE
1740: , p0_a3 JTF_VARCHAR2_TABLE_100
1741: , p0_a4 JTF_VARCHAR2_TABLE_100
1742: , p0_a5 JTF_VARCHAR2_TABLE_300
1743: , p1_a0 JTF_NUMBER_TABLE
1744: , p1_a1 JTF_VARCHAR2_TABLE_100

Line 1741: , p0_a4 JTF_VARCHAR2_TABLE_100

1737: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1738: , p0_a1 JTF_NUMBER_TABLE
1739: , p0_a2 JTF_NUMBER_TABLE
1740: , p0_a3 JTF_VARCHAR2_TABLE_100
1741: , p0_a4 JTF_VARCHAR2_TABLE_100
1742: , p0_a5 JTF_VARCHAR2_TABLE_300
1743: , p1_a0 JTF_NUMBER_TABLE
1744: , p1_a1 JTF_VARCHAR2_TABLE_100
1745: , p1_a2 JTF_VARCHAR2_TABLE_100

Line 1744: , p1_a1 JTF_VARCHAR2_TABLE_100

1740: , p0_a3 JTF_VARCHAR2_TABLE_100
1741: , p0_a4 JTF_VARCHAR2_TABLE_100
1742: , p0_a5 JTF_VARCHAR2_TABLE_300
1743: , p1_a0 JTF_NUMBER_TABLE
1744: , p1_a1 JTF_VARCHAR2_TABLE_100
1745: , p1_a2 JTF_VARCHAR2_TABLE_100
1746: , p1_a3 JTF_NUMBER_TABLE
1747: , p1_a4 JTF_VARCHAR2_TABLE_100
1748: , p1_a5 JTF_NUMBER_TABLE

Line 1745: , p1_a2 JTF_VARCHAR2_TABLE_100

1741: , p0_a4 JTF_VARCHAR2_TABLE_100
1742: , p0_a5 JTF_VARCHAR2_TABLE_300
1743: , p1_a0 JTF_NUMBER_TABLE
1744: , p1_a1 JTF_VARCHAR2_TABLE_100
1745: , p1_a2 JTF_VARCHAR2_TABLE_100
1746: , p1_a3 JTF_NUMBER_TABLE
1747: , p1_a4 JTF_VARCHAR2_TABLE_100
1748: , p1_a5 JTF_NUMBER_TABLE
1749: , p_include_alternate VARCHAR2

Line 1747: , p1_a4 JTF_VARCHAR2_TABLE_100

1743: , p1_a0 JTF_NUMBER_TABLE
1744: , p1_a1 JTF_VARCHAR2_TABLE_100
1745: , p1_a2 JTF_VARCHAR2_TABLE_100
1746: , p1_a3 JTF_NUMBER_TABLE
1747: , p1_a4 JTF_VARCHAR2_TABLE_100
1748: , p1_a5 JTF_NUMBER_TABLE
1749: , p_include_alternate VARCHAR2
1750: , p3_a0 out nocopy JTF_NUMBER_TABLE
1751: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 1751: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

1747: , p1_a4 JTF_VARCHAR2_TABLE_100
1748: , p1_a5 JTF_NUMBER_TABLE
1749: , p_include_alternate VARCHAR2
1750: , p3_a0 out nocopy JTF_NUMBER_TABLE
1751: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1752: , p3_a2 out nocopy JTF_NUMBER_TABLE
1753: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1755: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1753: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

1749: , p_include_alternate VARCHAR2
1750: , p3_a0 out nocopy JTF_NUMBER_TABLE
1751: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1752: , p3_a2 out nocopy JTF_NUMBER_TABLE
1753: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1755: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1756: , p3_a6 out nocopy JTF_NUMBER_TABLE
1757: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 1754: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

1750: , p3_a0 out nocopy JTF_NUMBER_TABLE
1751: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1752: , p3_a2 out nocopy JTF_NUMBER_TABLE
1753: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1755: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1756: , p3_a6 out nocopy JTF_NUMBER_TABLE
1757: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1758: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1758: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

1754: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1755: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1756: , p3_a6 out nocopy JTF_NUMBER_TABLE
1757: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1758: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p3_a10 out nocopy JTF_NUMBER_TABLE
1761: , p3_a11 out nocopy JTF_NUMBER_TABLE
1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 1759: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100

1755: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1756: , p3_a6 out nocopy JTF_NUMBER_TABLE
1757: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1758: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p3_a10 out nocopy JTF_NUMBER_TABLE
1761: , p3_a11 out nocopy JTF_NUMBER_TABLE
1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1763: , p3_a13 out nocopy JTF_NUMBER_TABLE

Line 1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

1758: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p3_a10 out nocopy JTF_NUMBER_TABLE
1761: , p3_a11 out nocopy JTF_NUMBER_TABLE
1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1763: , p3_a13 out nocopy JTF_NUMBER_TABLE
1764: , p3_a14 out nocopy JTF_NUMBER_TABLE
1765: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1766: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 1765: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

1761: , p3_a11 out nocopy JTF_NUMBER_TABLE
1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1763: , p3_a13 out nocopy JTF_NUMBER_TABLE
1764: , p3_a14 out nocopy JTF_NUMBER_TABLE
1765: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1766: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1767: , p3_a17 out nocopy JTF_DATE_TABLE
1768: , p3_a18 out nocopy JTF_DATE_TABLE
1769: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 1766: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1763: , p3_a13 out nocopy JTF_NUMBER_TABLE
1764: , p3_a14 out nocopy JTF_NUMBER_TABLE
1765: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1766: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1767: , p3_a17 out nocopy JTF_DATE_TABLE
1768: , p3_a18 out nocopy JTF_DATE_TABLE
1769: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
1770: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 1769: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100

1765: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1766: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1767: , p3_a17 out nocopy JTF_DATE_TABLE
1768: , p3_a18 out nocopy JTF_DATE_TABLE
1769: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
1770: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
1771: , x_return_status out nocopy VARCHAR2
1772: , x_msg_data out nocopy VARCHAR2
1773: , x_msg_count out nocopy NUMBER

Line 1770: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100

1766: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1767: , p3_a17 out nocopy JTF_DATE_TABLE
1768: , p3_a18 out nocopy JTF_DATE_TABLE
1769: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
1770: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
1771: , x_return_status out nocopy VARCHAR2
1772: , x_msg_data out nocopy VARCHAR2
1773: , x_msg_count out nocopy NUMBER
1774: )

Line 1848: , p2_a1 JTF_VARCHAR2_TABLE_100

1844:
1845: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
1846: , p_resource_id NUMBER
1847: , p2_a0 JTF_NUMBER_TABLE
1848: , p2_a1 JTF_VARCHAR2_TABLE_100
1849: , p2_a2 JTF_VARCHAR2_TABLE_100
1850: , p2_a3 JTF_NUMBER_TABLE
1851: , p2_a4 JTF_VARCHAR2_TABLE_100
1852: , p2_a5 JTF_NUMBER_TABLE

Line 1849: , p2_a2 JTF_VARCHAR2_TABLE_100

1845: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
1846: , p_resource_id NUMBER
1847: , p2_a0 JTF_NUMBER_TABLE
1848: , p2_a1 JTF_VARCHAR2_TABLE_100
1849: , p2_a2 JTF_VARCHAR2_TABLE_100
1850: , p2_a3 JTF_NUMBER_TABLE
1851: , p2_a4 JTF_VARCHAR2_TABLE_100
1852: , p2_a5 JTF_NUMBER_TABLE
1853: , p_include_alternate VARCHAR2

Line 1851: , p2_a4 JTF_VARCHAR2_TABLE_100

1847: , p2_a0 JTF_NUMBER_TABLE
1848: , p2_a1 JTF_VARCHAR2_TABLE_100
1849: , p2_a2 JTF_VARCHAR2_TABLE_100
1850: , p2_a3 JTF_NUMBER_TABLE
1851: , p2_a4 JTF_VARCHAR2_TABLE_100
1852: , p2_a5 JTF_NUMBER_TABLE
1853: , p_include_alternate VARCHAR2
1854: , p4_a0 out nocopy JTF_NUMBER_TABLE
1855: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 1855: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

1851: , p2_a4 JTF_VARCHAR2_TABLE_100
1852: , p2_a5 JTF_NUMBER_TABLE
1853: , p_include_alternate VARCHAR2
1854: , p4_a0 out nocopy JTF_NUMBER_TABLE
1855: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1856: , p4_a2 out nocopy JTF_NUMBER_TABLE
1857: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1858: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1859: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1857: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

1853: , p_include_alternate VARCHAR2
1854: , p4_a0 out nocopy JTF_NUMBER_TABLE
1855: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1856: , p4_a2 out nocopy JTF_NUMBER_TABLE
1857: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1858: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1859: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1860: , p4_a6 out nocopy JTF_NUMBER_TABLE
1861: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 1858: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

1854: , p4_a0 out nocopy JTF_NUMBER_TABLE
1855: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1856: , p4_a2 out nocopy JTF_NUMBER_TABLE
1857: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1858: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1859: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1860: , p4_a6 out nocopy JTF_NUMBER_TABLE
1861: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1862: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1862: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

1858: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1859: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1860: , p4_a6 out nocopy JTF_NUMBER_TABLE
1861: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1862: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1863: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1864: , p4_a10 out nocopy JTF_NUMBER_TABLE
1865: , p4_a11 out nocopy JTF_NUMBER_TABLE
1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 1863: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

1859: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1860: , p4_a6 out nocopy JTF_NUMBER_TABLE
1861: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1862: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1863: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1864: , p4_a10 out nocopy JTF_NUMBER_TABLE
1865: , p4_a11 out nocopy JTF_NUMBER_TABLE
1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p4_a13 out nocopy JTF_NUMBER_TABLE

Line 1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

1862: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1863: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1864: , p4_a10 out nocopy JTF_NUMBER_TABLE
1865: , p4_a11 out nocopy JTF_NUMBER_TABLE
1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p4_a13 out nocopy JTF_NUMBER_TABLE
1868: , p4_a14 out nocopy JTF_NUMBER_TABLE
1869: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1870: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 1869: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

1865: , p4_a11 out nocopy JTF_NUMBER_TABLE
1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p4_a13 out nocopy JTF_NUMBER_TABLE
1868: , p4_a14 out nocopy JTF_NUMBER_TABLE
1869: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1870: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1871: , p4_a17 out nocopy JTF_DATE_TABLE
1872: , p4_a18 out nocopy JTF_DATE_TABLE
1873: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 1870: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p4_a13 out nocopy JTF_NUMBER_TABLE
1868: , p4_a14 out nocopy JTF_NUMBER_TABLE
1869: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1870: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1871: , p4_a17 out nocopy JTF_DATE_TABLE
1872: , p4_a18 out nocopy JTF_DATE_TABLE
1873: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 1873: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

1869: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1870: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1871: , p4_a17 out nocopy JTF_DATE_TABLE
1872: , p4_a18 out nocopy JTF_DATE_TABLE
1873: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1875: , x_return_status out nocopy VARCHAR2
1876: , x_msg_data out nocopy VARCHAR2
1877: , x_msg_count out nocopy NUMBER

Line 1874: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

1870: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1871: , p4_a17 out nocopy JTF_DATE_TABLE
1872: , p4_a18 out nocopy JTF_DATE_TABLE
1873: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1875: , x_return_status out nocopy VARCHAR2
1876: , x_msg_data out nocopy VARCHAR2
1877: , x_msg_count out nocopy NUMBER
1878: )

Line 1947: , p2_a1 JTF_VARCHAR2_TABLE_100

1943:
1944: procedure ws_check_organizations(p_resource_type VARCHAR2
1945: , p_resource_id NUMBER
1946: , p2_a0 JTF_NUMBER_TABLE
1947: , p2_a1 JTF_VARCHAR2_TABLE_100
1948: , p2_a2 JTF_VARCHAR2_TABLE_100
1949: , p2_a3 JTF_NUMBER_TABLE
1950: , p2_a4 JTF_VARCHAR2_TABLE_100
1951: , p2_a5 JTF_NUMBER_TABLE

Line 1948: , p2_a2 JTF_VARCHAR2_TABLE_100

1944: procedure ws_check_organizations(p_resource_type VARCHAR2
1945: , p_resource_id NUMBER
1946: , p2_a0 JTF_NUMBER_TABLE
1947: , p2_a1 JTF_VARCHAR2_TABLE_100
1948: , p2_a2 JTF_VARCHAR2_TABLE_100
1949: , p2_a3 JTF_NUMBER_TABLE
1950: , p2_a4 JTF_VARCHAR2_TABLE_100
1951: , p2_a5 JTF_NUMBER_TABLE
1952: , p_include_alternate VARCHAR2

Line 1950: , p2_a4 JTF_VARCHAR2_TABLE_100

1946: , p2_a0 JTF_NUMBER_TABLE
1947: , p2_a1 JTF_VARCHAR2_TABLE_100
1948: , p2_a2 JTF_VARCHAR2_TABLE_100
1949: , p2_a3 JTF_NUMBER_TABLE
1950: , p2_a4 JTF_VARCHAR2_TABLE_100
1951: , p2_a5 JTF_NUMBER_TABLE
1952: , p_include_alternate VARCHAR2
1953: , p4_a0 out nocopy JTF_NUMBER_TABLE
1954: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 1954: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

1950: , p2_a4 JTF_VARCHAR2_TABLE_100
1951: , p2_a5 JTF_NUMBER_TABLE
1952: , p_include_alternate VARCHAR2
1953: , p4_a0 out nocopy JTF_NUMBER_TABLE
1954: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1955: , p4_a2 out nocopy JTF_NUMBER_TABLE
1956: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1957: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1958: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1956: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

1952: , p_include_alternate VARCHAR2
1953: , p4_a0 out nocopy JTF_NUMBER_TABLE
1954: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1955: , p4_a2 out nocopy JTF_NUMBER_TABLE
1956: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1957: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1958: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1959: , p4_a6 out nocopy JTF_NUMBER_TABLE
1960: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 1957: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

1953: , p4_a0 out nocopy JTF_NUMBER_TABLE
1954: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1955: , p4_a2 out nocopy JTF_NUMBER_TABLE
1956: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1957: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1958: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1959: , p4_a6 out nocopy JTF_NUMBER_TABLE
1960: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1961: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1961: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

1957: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1958: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1959: , p4_a6 out nocopy JTF_NUMBER_TABLE
1960: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1961: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1962: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1963: , p4_a10 out nocopy JTF_NUMBER_TABLE
1964: , p4_a11 out nocopy JTF_NUMBER_TABLE
1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 1962: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

1958: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1959: , p4_a6 out nocopy JTF_NUMBER_TABLE
1960: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1961: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1962: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1963: , p4_a10 out nocopy JTF_NUMBER_TABLE
1964: , p4_a11 out nocopy JTF_NUMBER_TABLE
1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1966: , p4_a13 out nocopy JTF_NUMBER_TABLE

Line 1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

1961: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1962: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1963: , p4_a10 out nocopy JTF_NUMBER_TABLE
1964: , p4_a11 out nocopy JTF_NUMBER_TABLE
1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1966: , p4_a13 out nocopy JTF_NUMBER_TABLE
1967: , p4_a14 out nocopy JTF_NUMBER_TABLE
1968: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1969: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 1968: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

1964: , p4_a11 out nocopy JTF_NUMBER_TABLE
1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1966: , p4_a13 out nocopy JTF_NUMBER_TABLE
1967: , p4_a14 out nocopy JTF_NUMBER_TABLE
1968: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1969: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1970: , p4_a17 out nocopy JTF_DATE_TABLE
1971: , p4_a18 out nocopy JTF_DATE_TABLE
1972: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 1969: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1966: , p4_a13 out nocopy JTF_NUMBER_TABLE
1967: , p4_a14 out nocopy JTF_NUMBER_TABLE
1968: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1969: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1970: , p4_a17 out nocopy JTF_DATE_TABLE
1971: , p4_a18 out nocopy JTF_DATE_TABLE
1972: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1973: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 1972: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

1968: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1969: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1970: , p4_a17 out nocopy JTF_DATE_TABLE
1971: , p4_a18 out nocopy JTF_DATE_TABLE
1972: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1973: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1974: , x_return_status out nocopy VARCHAR2
1975: , x_msg_data out nocopy VARCHAR2
1976: , x_msg_count out nocopy NUMBER

Line 1973: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

1969: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1970: , p4_a17 out nocopy JTF_DATE_TABLE
1971: , p4_a18 out nocopy JTF_DATE_TABLE
1972: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1973: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1974: , x_return_status out nocopy VARCHAR2
1975: , x_msg_data out nocopy VARCHAR2
1976: , x_msg_count out nocopy NUMBER
1977: )

Line 2051: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100

2047: , p0_a4 VARCHAR2
2048: , p0_a5 NUMBER
2049: , p_org_id NUMBER
2050: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2051: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2052: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2053: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2054: , p2_a4 in out nocopy JTF_NUMBER_TABLE
2055: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 2052: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100

2048: , p0_a5 NUMBER
2049: , p_org_id NUMBER
2050: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2051: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2052: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2053: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2054: , p2_a4 in out nocopy JTF_NUMBER_TABLE
2055: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2056: , p2_a6 in out nocopy JTF_NUMBER_TABLE

Line 2055: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100

2051: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2052: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2053: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2054: , p2_a4 in out nocopy JTF_NUMBER_TABLE
2055: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2056: , p2_a6 in out nocopy JTF_NUMBER_TABLE
2057: , p2_a7 in out nocopy JTF_NUMBER_TABLE
2058: , x_return_status out nocopy VARCHAR2
2059: , x_msg_data out nocopy VARCHAR2

Line 2187: , p0_a1 JTF_VARCHAR2_TABLE_100

2183: return ddrosetta_retval;
2184: end;
2185:
2186: procedure spares_check2(p0_a0 JTF_NUMBER_TABLE
2187: , p0_a1 JTF_VARCHAR2_TABLE_100
2188: , p_task_id NUMBER
2189: , p_need_by_date date
2190: , p_trunk number
2191: , p_warehouse number

Line 2194: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

2190: , p_trunk number
2191: , p_warehouse number
2192: , p_mandatory number
2193: , p6_a0 out nocopy JTF_NUMBER_TABLE
2194: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2195: , p6_a2 out nocopy JTF_DATE_TABLE
2196: , p6_a3 out nocopy JTF_NUMBER_TABLE
2197: , p6_a4 out nocopy JTF_NUMBER_TABLE
2198: , p6_a5 out nocopy JTF_NUMBER_TABLE