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

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body csp_sch_int_pvt_w as
2: /* $Header: cspvscib.pls 115.12 2004/02/25 01:32:48 jjalla noship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin
8: if a0 is not null and a0.count=0 then

Line 29: , a1 out nocopy JTF_VARCHAR2_TABLE_100

25: end if;
26: end if;
27: end rosetta_table_copy_in_p13;
28: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin
33: if t is null then

Line 38: a1 := JTF_VARCHAR2_TABLE_100();

34: a0 := null;
35: a1 := null;
36: elsif t.count = 0 then
37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: else
40: a0 := JTF_NUMBER_TABLE();
41: a1 := JTF_VARCHAR2_TABLE_100();
42: if t.count > 0 then

Line 41: a1 := JTF_VARCHAR2_TABLE_100();

37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: else
40: a0 := JTF_NUMBER_TABLE();
41: a1 := JTF_VARCHAR2_TABLE_100();
42: if t.count > 0 then
43: a0.extend(t.count);
44: a1.extend(t.count);
45: ddindx := t.first;

Line 61: , a1 JTF_VARCHAR2_TABLE_100

57: end if;
58: end rosetta_table_copy_out_p13;
59:
60: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
61: , a1 JTF_VARCHAR2_TABLE_100
62: , a2 JTF_DATE_TABLE
63: , a3 JTF_NUMBER_TABLE
64: ) as
65: ddindx binary_integer; indx binary_integer;

Line 90: , a1 out nocopy JTF_VARCHAR2_TABLE_100

86: end if;
87: end if;
88: end rosetta_table_copy_in_p14;
89: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_VARCHAR2_TABLE_100
91: , a2 out nocopy JTF_DATE_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;

Line 103: a1 := JTF_VARCHAR2_TABLE_100();

99: a2 := null;
100: a3 := null;
101: elsif t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_VARCHAR2_TABLE_100();
104: a2 := JTF_DATE_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: else
107: a0 := JTF_NUMBER_TABLE();

Line 108: a1 := JTF_VARCHAR2_TABLE_100();

104: a2 := JTF_DATE_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: else
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_VARCHAR2_TABLE_100();
109: a2 := JTF_DATE_TABLE();
110: a3 := JTF_NUMBER_TABLE();
111: if t.count > 0 then
112: a0.extend(t.count);

Line 134: , a1 JTF_VARCHAR2_TABLE_100

130: end if;
131: end rosetta_table_copy_out_p14;
132:
133: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_VARCHAR2_TABLE_100
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_VARCHAR2_TABLE_100
138: , a5 JTF_VARCHAR2_TABLE_100

Line 137: , a4 JTF_VARCHAR2_TABLE_100

133: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_VARCHAR2_TABLE_100
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_VARCHAR2_TABLE_100
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE
140: , a7 JTF_NUMBER_TABLE
141: , a8 JTF_NUMBER_TABLE

Line 138: , a5 JTF_VARCHAR2_TABLE_100

134: , a1 JTF_VARCHAR2_TABLE_100
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_VARCHAR2_TABLE_100
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE
140: , a7 JTF_NUMBER_TABLE
141: , a8 JTF_NUMBER_TABLE
142: , a9 JTF_VARCHAR2_TABLE_100

Line 142: , a9 JTF_VARCHAR2_TABLE_100

138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE
140: , a7 JTF_NUMBER_TABLE
141: , a8 JTF_NUMBER_TABLE
142: , a9 JTF_VARCHAR2_TABLE_100
143: ) as
144: ddindx binary_integer; indx binary_integer;
145: begin
146: if a0 is not null and a0.count=0 then

Line 175: , a1 out nocopy JTF_VARCHAR2_TABLE_100

171: end if;
172: end if;
173: end rosetta_table_copy_in_p15;
174: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100
179: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 178: , a4 out nocopy JTF_VARCHAR2_TABLE_100

174: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100
179: , a5 out nocopy JTF_VARCHAR2_TABLE_100
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_NUMBER_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE

Line 179: , a5 out nocopy JTF_VARCHAR2_TABLE_100

175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100
179: , a5 out nocopy JTF_VARCHAR2_TABLE_100
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_NUMBER_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 183: , a9 out nocopy JTF_VARCHAR2_TABLE_100

179: , a5 out nocopy JTF_VARCHAR2_TABLE_100
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_NUMBER_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_VARCHAR2_TABLE_100
184: ) as
185: ddindx binary_integer; indx binary_integer;
186: begin
187: if t is null then

Line 200: a1 := JTF_VARCHAR2_TABLE_100();

196: a8 := null;
197: a9 := null;
198: elsif t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_VARCHAR2_TABLE_100();
201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();

Line 203: a4 := JTF_VARCHAR2_TABLE_100();

199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_VARCHAR2_TABLE_100();
201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_NUMBER_TABLE();

Line 204: a5 := JTF_VARCHAR2_TABLE_100();

200: a1 := JTF_VARCHAR2_TABLE_100();
201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_100();

Line 208: a9 := JTF_VARCHAR2_TABLE_100();

204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_NUMBER_TABLE();

Line 211: a1 := JTF_VARCHAR2_TABLE_100();

207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_NUMBER_TABLE();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_100();

Line 214: a4 := JTF_VARCHAR2_TABLE_100();

210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_NUMBER_TABLE();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_100();
216: a6 := JTF_NUMBER_TABLE();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_NUMBER_TABLE();

Line 215: a5 := JTF_VARCHAR2_TABLE_100();

211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_NUMBER_TABLE();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_100();
216: a6 := JTF_NUMBER_TABLE();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();

Line 219: a9 := JTF_VARCHAR2_TABLE_100();

215: a5 := JTF_VARCHAR2_TABLE_100();
216: a6 := JTF_NUMBER_TABLE();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: if t.count > 0 then
221: a0.extend(t.count);
222: a1.extend(t.count);
223: a2.extend(t.count);

Line 255: , a1 JTF_VARCHAR2_TABLE_100

251: end if;
252: end rosetta_table_copy_out_p15;
253:
254: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_VARCHAR2_TABLE_100
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_NUMBER_TABLE
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE

Line 260: , a6 JTF_VARCHAR2_TABLE_100

256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_NUMBER_TABLE
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_NUMBER_TABLE
262: , a8 JTF_VARCHAR2_TABLE_100
263: , a9 JTF_NUMBER_TABLE
264: , a10 JTF_NUMBER_TABLE

Line 262: , a8 JTF_VARCHAR2_TABLE_100

258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_NUMBER_TABLE
262: , a8 JTF_VARCHAR2_TABLE_100
263: , a9 JTF_NUMBER_TABLE
264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_VARCHAR2_TABLE_100

Line 266: , a12 JTF_VARCHAR2_TABLE_100

262: , a8 JTF_VARCHAR2_TABLE_100
263: , a9 JTF_NUMBER_TABLE
264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_VARCHAR2_TABLE_100
267: , a13 JTF_DATE_TABLE
268: , a14 JTF_VARCHAR2_TABLE_100
269: , a15 JTF_NUMBER_TABLE
270: ) as

Line 268: , a14 JTF_VARCHAR2_TABLE_100

264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_VARCHAR2_TABLE_100
267: , a13 JTF_DATE_TABLE
268: , a14 JTF_VARCHAR2_TABLE_100
269: , a15 JTF_NUMBER_TABLE
270: ) as
271: ddindx binary_integer; indx binary_integer;
272: begin

Line 308: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 313: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 315: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 319: , a12 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 321: , a14 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 345: a1 := JTF_VARCHAR2_TABLE_100();

341: a14 := null;
342: a15 := null;
343: elsif t.count = 0 then
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_NUMBER_TABLE();
347: a3 := JTF_NUMBER_TABLE();
348: a4 := JTF_NUMBER_TABLE();
349: a5 := JTF_NUMBER_TABLE();

Line 350: a6 := JTF_VARCHAR2_TABLE_100();

346: a2 := JTF_NUMBER_TABLE();
347: a3 := JTF_NUMBER_TABLE();
348: a4 := JTF_NUMBER_TABLE();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_VARCHAR2_TABLE_100();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_VARCHAR2_TABLE_100();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();

Line 352: a8 := JTF_VARCHAR2_TABLE_100();

348: a4 := JTF_NUMBER_TABLE();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_VARCHAR2_TABLE_100();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_VARCHAR2_TABLE_100();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_NUMBER_TABLE();
356: a12 := JTF_VARCHAR2_TABLE_100();

Line 356: a12 := JTF_VARCHAR2_TABLE_100();

352: a8 := JTF_VARCHAR2_TABLE_100();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_NUMBER_TABLE();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_DATE_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();
359: a15 := JTF_NUMBER_TABLE();
360: else

Line 358: a14 := JTF_VARCHAR2_TABLE_100();

354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_NUMBER_TABLE();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_DATE_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();
359: a15 := JTF_NUMBER_TABLE();
360: else
361: a0 := JTF_NUMBER_TABLE();
362: a1 := JTF_VARCHAR2_TABLE_100();

Line 362: a1 := JTF_VARCHAR2_TABLE_100();

358: a14 := JTF_VARCHAR2_TABLE_100();
359: a15 := JTF_NUMBER_TABLE();
360: else
361: a0 := JTF_NUMBER_TABLE();
362: a1 := JTF_VARCHAR2_TABLE_100();
363: a2 := JTF_NUMBER_TABLE();
364: a3 := JTF_NUMBER_TABLE();
365: a4 := JTF_NUMBER_TABLE();
366: a5 := JTF_NUMBER_TABLE();

Line 367: a6 := JTF_VARCHAR2_TABLE_100();

363: a2 := JTF_NUMBER_TABLE();
364: a3 := JTF_NUMBER_TABLE();
365: a4 := JTF_NUMBER_TABLE();
366: a5 := JTF_NUMBER_TABLE();
367: a6 := JTF_VARCHAR2_TABLE_100();
368: a7 := JTF_NUMBER_TABLE();
369: a8 := JTF_VARCHAR2_TABLE_100();
370: a9 := JTF_NUMBER_TABLE();
371: a10 := JTF_NUMBER_TABLE();

Line 369: a8 := JTF_VARCHAR2_TABLE_100();

365: a4 := JTF_NUMBER_TABLE();
366: a5 := JTF_NUMBER_TABLE();
367: a6 := JTF_VARCHAR2_TABLE_100();
368: a7 := JTF_NUMBER_TABLE();
369: a8 := JTF_VARCHAR2_TABLE_100();
370: a9 := JTF_NUMBER_TABLE();
371: a10 := JTF_NUMBER_TABLE();
372: a11 := JTF_NUMBER_TABLE();
373: a12 := JTF_VARCHAR2_TABLE_100();

Line 373: a12 := JTF_VARCHAR2_TABLE_100();

369: a8 := JTF_VARCHAR2_TABLE_100();
370: a9 := JTF_NUMBER_TABLE();
371: a10 := JTF_NUMBER_TABLE();
372: a11 := JTF_NUMBER_TABLE();
373: a12 := JTF_VARCHAR2_TABLE_100();
374: a13 := JTF_DATE_TABLE();
375: a14 := JTF_VARCHAR2_TABLE_100();
376: a15 := JTF_NUMBER_TABLE();
377: if t.count > 0 then

Line 375: a14 := JTF_VARCHAR2_TABLE_100();

371: a10 := JTF_NUMBER_TABLE();
372: a11 := JTF_NUMBER_TABLE();
373: a12 := JTF_VARCHAR2_TABLE_100();
374: a13 := JTF_DATE_TABLE();
375: a14 := JTF_VARCHAR2_TABLE_100();
376: a15 := JTF_NUMBER_TABLE();
377: if t.count > 0 then
378: a0.extend(t.count);
379: a1.extend(t.count);

Line 424: , a1 JTF_VARCHAR2_TABLE_100

420: end if;
421: end rosetta_table_copy_out_p16;
422:
423: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_VARCHAR2_TABLE_100
425: , a2 JTF_VARCHAR2_TABLE_100
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_VARCHAR2_TABLE_100
428: , a5 JTF_NUMBER_TABLE

Line 425: , a2 JTF_VARCHAR2_TABLE_100

421: end rosetta_table_copy_out_p16;
422:
423: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_VARCHAR2_TABLE_100
425: , a2 JTF_VARCHAR2_TABLE_100
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_VARCHAR2_TABLE_100
428: , a5 JTF_NUMBER_TABLE
429: ) as

Line 427: , a4 JTF_VARCHAR2_TABLE_100

423: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_VARCHAR2_TABLE_100
425: , a2 JTF_VARCHAR2_TABLE_100
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_VARCHAR2_TABLE_100
428: , a5 JTF_NUMBER_TABLE
429: ) as
430: ddindx binary_integer; indx binary_integer;
431: begin

Line 457: , a1 out nocopy JTF_VARCHAR2_TABLE_100

453: end if;
454: end if;
455: end rosetta_table_copy_in_p17;
456: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
457: , a1 out nocopy JTF_VARCHAR2_TABLE_100
458: , a2 out nocopy JTF_VARCHAR2_TABLE_100
459: , a3 out nocopy JTF_NUMBER_TABLE
460: , a4 out nocopy JTF_VARCHAR2_TABLE_100
461: , a5 out nocopy JTF_NUMBER_TABLE

Line 458: , a2 out nocopy JTF_VARCHAR2_TABLE_100

454: end if;
455: end rosetta_table_copy_in_p17;
456: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
457: , a1 out nocopy JTF_VARCHAR2_TABLE_100
458: , a2 out nocopy JTF_VARCHAR2_TABLE_100
459: , a3 out nocopy JTF_NUMBER_TABLE
460: , a4 out nocopy JTF_VARCHAR2_TABLE_100
461: , a5 out nocopy JTF_NUMBER_TABLE
462: ) as

Line 460: , a4 out nocopy JTF_VARCHAR2_TABLE_100

456: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
457: , a1 out nocopy JTF_VARCHAR2_TABLE_100
458: , a2 out nocopy JTF_VARCHAR2_TABLE_100
459: , a3 out nocopy JTF_NUMBER_TABLE
460: , a4 out nocopy JTF_VARCHAR2_TABLE_100
461: , a5 out nocopy JTF_NUMBER_TABLE
462: ) as
463: ddindx binary_integer; indx binary_integer;
464: begin

Line 474: a1 := JTF_VARCHAR2_TABLE_100();

470: a4 := null;
471: a5 := null;
472: elsif t.count = 0 then
473: a0 := JTF_NUMBER_TABLE();
474: a1 := JTF_VARCHAR2_TABLE_100();
475: a2 := JTF_VARCHAR2_TABLE_100();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_VARCHAR2_TABLE_100();
478: a5 := JTF_NUMBER_TABLE();

Line 475: a2 := JTF_VARCHAR2_TABLE_100();

471: a5 := null;
472: elsif t.count = 0 then
473: a0 := JTF_NUMBER_TABLE();
474: a1 := JTF_VARCHAR2_TABLE_100();
475: a2 := JTF_VARCHAR2_TABLE_100();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_VARCHAR2_TABLE_100();
478: a5 := JTF_NUMBER_TABLE();
479: else

Line 477: a4 := JTF_VARCHAR2_TABLE_100();

473: a0 := JTF_NUMBER_TABLE();
474: a1 := JTF_VARCHAR2_TABLE_100();
475: a2 := JTF_VARCHAR2_TABLE_100();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_VARCHAR2_TABLE_100();
478: a5 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_VARCHAR2_TABLE_100();

Line 481: a1 := JTF_VARCHAR2_TABLE_100();

477: a4 := JTF_VARCHAR2_TABLE_100();
478: a5 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_VARCHAR2_TABLE_100();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_VARCHAR2_TABLE_100();
485: a5 := JTF_NUMBER_TABLE();

Line 482: a2 := JTF_VARCHAR2_TABLE_100();

478: a5 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_VARCHAR2_TABLE_100();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_VARCHAR2_TABLE_100();
485: a5 := JTF_NUMBER_TABLE();
486: if t.count > 0 then

Line 484: a4 := JTF_VARCHAR2_TABLE_100();

480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_VARCHAR2_TABLE_100();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_VARCHAR2_TABLE_100();
485: a5 := JTF_NUMBER_TABLE();
486: if t.count > 0 then
487: a0.extend(t.count);
488: a1.extend(t.count);

Line 513: , a1 JTF_VARCHAR2_TABLE_100

509: end if;
510: end rosetta_table_copy_out_p17;
511:
512: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
513: , a1 JTF_VARCHAR2_TABLE_100
514: , a2 JTF_NUMBER_TABLE
515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_VARCHAR2_TABLE_100
517: , a5 JTF_NUMBER_TABLE

Line 516: , a4 JTF_VARCHAR2_TABLE_100

512: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
513: , a1 JTF_VARCHAR2_TABLE_100
514: , a2 JTF_NUMBER_TABLE
515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_VARCHAR2_TABLE_100
517: , a5 JTF_NUMBER_TABLE
518: , a6 JTF_NUMBER_TABLE
519: , a7 JTF_NUMBER_TABLE
520: , a8 JTF_VARCHAR2_TABLE_100

Line 520: , a8 JTF_VARCHAR2_TABLE_100

516: , a4 JTF_VARCHAR2_TABLE_100
517: , a5 JTF_NUMBER_TABLE
518: , a6 JTF_NUMBER_TABLE
519: , a7 JTF_NUMBER_TABLE
520: , a8 JTF_VARCHAR2_TABLE_100
521: , a9 JTF_DATE_TABLE
522: , a10 JTF_DATE_TABLE
523: , a11 JTF_VARCHAR2_TABLE_100
524: , a12 JTF_NUMBER_TABLE

Line 523: , a11 JTF_VARCHAR2_TABLE_100

519: , a7 JTF_NUMBER_TABLE
520: , a8 JTF_VARCHAR2_TABLE_100
521: , a9 JTF_DATE_TABLE
522: , a10 JTF_DATE_TABLE
523: , a11 JTF_VARCHAR2_TABLE_100
524: , a12 JTF_NUMBER_TABLE
525: , a13 JTF_NUMBER_TABLE
526: , a14 JTF_VARCHAR2_TABLE_100
527: , a15 JTF_VARCHAR2_TABLE_100

Line 526: , a14 JTF_VARCHAR2_TABLE_100

522: , a10 JTF_DATE_TABLE
523: , a11 JTF_VARCHAR2_TABLE_100
524: , a12 JTF_NUMBER_TABLE
525: , a13 JTF_NUMBER_TABLE
526: , a14 JTF_VARCHAR2_TABLE_100
527: , a15 JTF_VARCHAR2_TABLE_100
528: ) as
529: ddindx binary_integer; indx binary_integer;
530: begin

Line 527: , a15 JTF_VARCHAR2_TABLE_100

523: , a11 JTF_VARCHAR2_TABLE_100
524: , a12 JTF_NUMBER_TABLE
525: , a13 JTF_NUMBER_TABLE
526: , a14 JTF_VARCHAR2_TABLE_100
527: , a15 JTF_VARCHAR2_TABLE_100
528: ) as
529: ddindx binary_integer; indx binary_integer;
530: begin
531: if a0 is not null and a0.count=0 then

Line 566: , a1 out nocopy JTF_VARCHAR2_TABLE_100

562: end if;
563: end if;
564: end rosetta_table_copy_in_p18;
565: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
566: , a1 out nocopy JTF_VARCHAR2_TABLE_100
567: , a2 out nocopy JTF_NUMBER_TABLE
568: , a3 out nocopy JTF_NUMBER_TABLE
569: , a4 out nocopy JTF_VARCHAR2_TABLE_100
570: , a5 out nocopy JTF_NUMBER_TABLE

Line 569: , a4 out nocopy JTF_VARCHAR2_TABLE_100

565: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
566: , a1 out nocopy JTF_VARCHAR2_TABLE_100
567: , a2 out nocopy JTF_NUMBER_TABLE
568: , a3 out nocopy JTF_NUMBER_TABLE
569: , a4 out nocopy JTF_VARCHAR2_TABLE_100
570: , a5 out nocopy JTF_NUMBER_TABLE
571: , a6 out nocopy JTF_NUMBER_TABLE
572: , a7 out nocopy JTF_NUMBER_TABLE
573: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 573: , a8 out nocopy JTF_VARCHAR2_TABLE_100

569: , a4 out nocopy JTF_VARCHAR2_TABLE_100
570: , a5 out nocopy JTF_NUMBER_TABLE
571: , a6 out nocopy JTF_NUMBER_TABLE
572: , a7 out nocopy JTF_NUMBER_TABLE
573: , a8 out nocopy JTF_VARCHAR2_TABLE_100
574: , a9 out nocopy JTF_DATE_TABLE
575: , a10 out nocopy JTF_DATE_TABLE
576: , a11 out nocopy JTF_VARCHAR2_TABLE_100
577: , a12 out nocopy JTF_NUMBER_TABLE

Line 576: , a11 out nocopy JTF_VARCHAR2_TABLE_100

572: , a7 out nocopy JTF_NUMBER_TABLE
573: , a8 out nocopy JTF_VARCHAR2_TABLE_100
574: , a9 out nocopy JTF_DATE_TABLE
575: , a10 out nocopy JTF_DATE_TABLE
576: , a11 out nocopy JTF_VARCHAR2_TABLE_100
577: , a12 out nocopy JTF_NUMBER_TABLE
578: , a13 out nocopy JTF_NUMBER_TABLE
579: , a14 out nocopy JTF_VARCHAR2_TABLE_100
580: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 579: , a14 out nocopy JTF_VARCHAR2_TABLE_100

575: , a10 out nocopy JTF_DATE_TABLE
576: , a11 out nocopy JTF_VARCHAR2_TABLE_100
577: , a12 out nocopy JTF_NUMBER_TABLE
578: , a13 out nocopy JTF_NUMBER_TABLE
579: , a14 out nocopy JTF_VARCHAR2_TABLE_100
580: , a15 out nocopy JTF_VARCHAR2_TABLE_100
581: ) as
582: ddindx binary_integer; indx binary_integer;
583: begin

Line 580: , a15 out nocopy JTF_VARCHAR2_TABLE_100

576: , a11 out nocopy JTF_VARCHAR2_TABLE_100
577: , a12 out nocopy JTF_NUMBER_TABLE
578: , a13 out nocopy JTF_NUMBER_TABLE
579: , a14 out nocopy JTF_VARCHAR2_TABLE_100
580: , a15 out nocopy JTF_VARCHAR2_TABLE_100
581: ) as
582: ddindx binary_integer; indx binary_integer;
583: begin
584: if t is null then

Line 603: a1 := JTF_VARCHAR2_TABLE_100();

599: a14 := null;
600: a15 := null;
601: elsif t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();
603: a1 := JTF_VARCHAR2_TABLE_100();
604: a2 := JTF_NUMBER_TABLE();
605: a3 := JTF_NUMBER_TABLE();
606: a4 := JTF_VARCHAR2_TABLE_100();
607: a5 := JTF_NUMBER_TABLE();

Line 606: a4 := JTF_VARCHAR2_TABLE_100();

602: a0 := JTF_NUMBER_TABLE();
603: a1 := JTF_VARCHAR2_TABLE_100();
604: a2 := JTF_NUMBER_TABLE();
605: a3 := JTF_NUMBER_TABLE();
606: a4 := JTF_VARCHAR2_TABLE_100();
607: a5 := JTF_NUMBER_TABLE();
608: a6 := JTF_NUMBER_TABLE();
609: a7 := JTF_NUMBER_TABLE();
610: a8 := JTF_VARCHAR2_TABLE_100();

Line 610: a8 := JTF_VARCHAR2_TABLE_100();

606: a4 := JTF_VARCHAR2_TABLE_100();
607: a5 := JTF_NUMBER_TABLE();
608: a6 := JTF_NUMBER_TABLE();
609: a7 := JTF_NUMBER_TABLE();
610: a8 := JTF_VARCHAR2_TABLE_100();
611: a9 := JTF_DATE_TABLE();
612: a10 := JTF_DATE_TABLE();
613: a11 := JTF_VARCHAR2_TABLE_100();
614: a12 := JTF_NUMBER_TABLE();

Line 613: a11 := JTF_VARCHAR2_TABLE_100();

609: a7 := JTF_NUMBER_TABLE();
610: a8 := JTF_VARCHAR2_TABLE_100();
611: a9 := JTF_DATE_TABLE();
612: a10 := JTF_DATE_TABLE();
613: a11 := JTF_VARCHAR2_TABLE_100();
614: a12 := JTF_NUMBER_TABLE();
615: a13 := JTF_NUMBER_TABLE();
616: a14 := JTF_VARCHAR2_TABLE_100();
617: a15 := JTF_VARCHAR2_TABLE_100();

Line 616: a14 := JTF_VARCHAR2_TABLE_100();

612: a10 := JTF_DATE_TABLE();
613: a11 := JTF_VARCHAR2_TABLE_100();
614: a12 := JTF_NUMBER_TABLE();
615: a13 := JTF_NUMBER_TABLE();
616: a14 := JTF_VARCHAR2_TABLE_100();
617: a15 := JTF_VARCHAR2_TABLE_100();
618: else
619: a0 := JTF_NUMBER_TABLE();
620: a1 := JTF_VARCHAR2_TABLE_100();

Line 617: a15 := JTF_VARCHAR2_TABLE_100();

613: a11 := JTF_VARCHAR2_TABLE_100();
614: a12 := JTF_NUMBER_TABLE();
615: a13 := JTF_NUMBER_TABLE();
616: a14 := JTF_VARCHAR2_TABLE_100();
617: a15 := JTF_VARCHAR2_TABLE_100();
618: else
619: a0 := JTF_NUMBER_TABLE();
620: a1 := JTF_VARCHAR2_TABLE_100();
621: a2 := JTF_NUMBER_TABLE();

Line 620: a1 := JTF_VARCHAR2_TABLE_100();

616: a14 := JTF_VARCHAR2_TABLE_100();
617: a15 := JTF_VARCHAR2_TABLE_100();
618: else
619: a0 := JTF_NUMBER_TABLE();
620: a1 := JTF_VARCHAR2_TABLE_100();
621: a2 := JTF_NUMBER_TABLE();
622: a3 := JTF_NUMBER_TABLE();
623: a4 := JTF_VARCHAR2_TABLE_100();
624: a5 := JTF_NUMBER_TABLE();

Line 623: a4 := JTF_VARCHAR2_TABLE_100();

619: a0 := JTF_NUMBER_TABLE();
620: a1 := JTF_VARCHAR2_TABLE_100();
621: a2 := JTF_NUMBER_TABLE();
622: a3 := JTF_NUMBER_TABLE();
623: a4 := JTF_VARCHAR2_TABLE_100();
624: a5 := JTF_NUMBER_TABLE();
625: a6 := JTF_NUMBER_TABLE();
626: a7 := JTF_NUMBER_TABLE();
627: a8 := JTF_VARCHAR2_TABLE_100();

Line 627: a8 := JTF_VARCHAR2_TABLE_100();

623: a4 := JTF_VARCHAR2_TABLE_100();
624: a5 := JTF_NUMBER_TABLE();
625: a6 := JTF_NUMBER_TABLE();
626: a7 := JTF_NUMBER_TABLE();
627: a8 := JTF_VARCHAR2_TABLE_100();
628: a9 := JTF_DATE_TABLE();
629: a10 := JTF_DATE_TABLE();
630: a11 := JTF_VARCHAR2_TABLE_100();
631: a12 := JTF_NUMBER_TABLE();

Line 630: a11 := JTF_VARCHAR2_TABLE_100();

626: a7 := JTF_NUMBER_TABLE();
627: a8 := JTF_VARCHAR2_TABLE_100();
628: a9 := JTF_DATE_TABLE();
629: a10 := JTF_DATE_TABLE();
630: a11 := JTF_VARCHAR2_TABLE_100();
631: a12 := JTF_NUMBER_TABLE();
632: a13 := JTF_NUMBER_TABLE();
633: a14 := JTF_VARCHAR2_TABLE_100();
634: a15 := JTF_VARCHAR2_TABLE_100();

Line 633: a14 := JTF_VARCHAR2_TABLE_100();

629: a10 := JTF_DATE_TABLE();
630: a11 := JTF_VARCHAR2_TABLE_100();
631: a12 := JTF_NUMBER_TABLE();
632: a13 := JTF_NUMBER_TABLE();
633: a14 := JTF_VARCHAR2_TABLE_100();
634: a15 := JTF_VARCHAR2_TABLE_100();
635: if t.count > 0 then
636: a0.extend(t.count);
637: a1.extend(t.count);

Line 634: a15 := JTF_VARCHAR2_TABLE_100();

630: a11 := JTF_VARCHAR2_TABLE_100();
631: a12 := JTF_NUMBER_TABLE();
632: a13 := JTF_NUMBER_TABLE();
633: a14 := JTF_VARCHAR2_TABLE_100();
634: a15 := 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 682: , a1 JTF_VARCHAR2_TABLE_100

678: end if;
679: end rosetta_table_copy_out_p18;
680:
681: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
682: , a1 JTF_VARCHAR2_TABLE_100
683: , a2 JTF_NUMBER_TABLE
684: , a3 JTF_NUMBER_TABLE
685: , a4 JTF_VARCHAR2_TABLE_100
686: , a5 JTF_NUMBER_TABLE

Line 685: , a4 JTF_VARCHAR2_TABLE_100

681: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
682: , a1 JTF_VARCHAR2_TABLE_100
683: , a2 JTF_NUMBER_TABLE
684: , a3 JTF_NUMBER_TABLE
685: , a4 JTF_VARCHAR2_TABLE_100
686: , a5 JTF_NUMBER_TABLE
687: , a6 JTF_NUMBER_TABLE
688: , a7 JTF_NUMBER_TABLE
689: , a8 JTF_VARCHAR2_TABLE_100

Line 689: , a8 JTF_VARCHAR2_TABLE_100

685: , a4 JTF_VARCHAR2_TABLE_100
686: , a5 JTF_NUMBER_TABLE
687: , a6 JTF_NUMBER_TABLE
688: , a7 JTF_NUMBER_TABLE
689: , a8 JTF_VARCHAR2_TABLE_100
690: , a9 JTF_DATE_TABLE
691: , a10 JTF_DATE_TABLE
692: , a11 JTF_VARCHAR2_TABLE_100
693: , a12 JTF_NUMBER_TABLE

Line 692: , a11 JTF_VARCHAR2_TABLE_100

688: , a7 JTF_NUMBER_TABLE
689: , a8 JTF_VARCHAR2_TABLE_100
690: , a9 JTF_DATE_TABLE
691: , a10 JTF_DATE_TABLE
692: , a11 JTF_VARCHAR2_TABLE_100
693: , a12 JTF_NUMBER_TABLE
694: , a13 JTF_NUMBER_TABLE
695: , a14 JTF_VARCHAR2_TABLE_100
696: , a15 JTF_VARCHAR2_TABLE_100

Line 695: , a14 JTF_VARCHAR2_TABLE_100

691: , a10 JTF_DATE_TABLE
692: , a11 JTF_VARCHAR2_TABLE_100
693: , a12 JTF_NUMBER_TABLE
694: , a13 JTF_NUMBER_TABLE
695: , a14 JTF_VARCHAR2_TABLE_100
696: , a15 JTF_VARCHAR2_TABLE_100
697: ) as
698: ddindx binary_integer; indx binary_integer;
699: begin

Line 696: , a15 JTF_VARCHAR2_TABLE_100

692: , a11 JTF_VARCHAR2_TABLE_100
693: , a12 JTF_NUMBER_TABLE
694: , a13 JTF_NUMBER_TABLE
695: , a14 JTF_VARCHAR2_TABLE_100
696: , a15 JTF_VARCHAR2_TABLE_100
697: ) as
698: ddindx binary_integer; indx binary_integer;
699: begin
700: if a0 is not null and a0.count > 0 then

Line 731: , a1 out nocopy JTF_VARCHAR2_TABLE_100

727: end if;
728: end if;
729: end rosetta_table_copy_in_p19;
730: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
731: , a1 out nocopy JTF_VARCHAR2_TABLE_100
732: , a2 out nocopy JTF_NUMBER_TABLE
733: , a3 out nocopy JTF_NUMBER_TABLE
734: , a4 out nocopy JTF_VARCHAR2_TABLE_100
735: , a5 out nocopy JTF_NUMBER_TABLE

Line 734: , a4 out nocopy JTF_VARCHAR2_TABLE_100

730: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
731: , a1 out nocopy JTF_VARCHAR2_TABLE_100
732: , a2 out nocopy JTF_NUMBER_TABLE
733: , a3 out nocopy JTF_NUMBER_TABLE
734: , a4 out nocopy JTF_VARCHAR2_TABLE_100
735: , a5 out nocopy JTF_NUMBER_TABLE
736: , a6 out nocopy JTF_NUMBER_TABLE
737: , a7 out nocopy JTF_NUMBER_TABLE
738: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 738: , a8 out nocopy JTF_VARCHAR2_TABLE_100

734: , a4 out nocopy JTF_VARCHAR2_TABLE_100
735: , a5 out nocopy JTF_NUMBER_TABLE
736: , a6 out nocopy JTF_NUMBER_TABLE
737: , a7 out nocopy JTF_NUMBER_TABLE
738: , a8 out nocopy JTF_VARCHAR2_TABLE_100
739: , a9 out nocopy JTF_DATE_TABLE
740: , a10 out nocopy JTF_DATE_TABLE
741: , a11 out nocopy JTF_VARCHAR2_TABLE_100
742: , a12 out nocopy JTF_NUMBER_TABLE

Line 741: , a11 out nocopy JTF_VARCHAR2_TABLE_100

737: , a7 out nocopy JTF_NUMBER_TABLE
738: , a8 out nocopy JTF_VARCHAR2_TABLE_100
739: , a9 out nocopy JTF_DATE_TABLE
740: , a10 out nocopy JTF_DATE_TABLE
741: , a11 out nocopy JTF_VARCHAR2_TABLE_100
742: , a12 out nocopy JTF_NUMBER_TABLE
743: , a13 out nocopy JTF_NUMBER_TABLE
744: , a14 out nocopy JTF_VARCHAR2_TABLE_100
745: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 744: , a14 out nocopy JTF_VARCHAR2_TABLE_100

740: , a10 out nocopy JTF_DATE_TABLE
741: , a11 out nocopy JTF_VARCHAR2_TABLE_100
742: , a12 out nocopy JTF_NUMBER_TABLE
743: , a13 out nocopy JTF_NUMBER_TABLE
744: , a14 out nocopy JTF_VARCHAR2_TABLE_100
745: , a15 out nocopy JTF_VARCHAR2_TABLE_100
746: ) as
747: ddindx binary_integer; indx binary_integer;
748: begin

Line 745: , a15 out nocopy JTF_VARCHAR2_TABLE_100

741: , a11 out nocopy JTF_VARCHAR2_TABLE_100
742: , a12 out nocopy JTF_NUMBER_TABLE
743: , a13 out nocopy JTF_NUMBER_TABLE
744: , a14 out nocopy JTF_VARCHAR2_TABLE_100
745: , a15 out nocopy JTF_VARCHAR2_TABLE_100
746: ) as
747: ddindx binary_integer; indx binary_integer;
748: begin
749: if t is null or t.count = 0 then

Line 751: a1 := JTF_VARCHAR2_TABLE_100();

747: ddindx binary_integer; indx binary_integer;
748: begin
749: if t is null or t.count = 0 then
750: a0 := JTF_NUMBER_TABLE();
751: a1 := JTF_VARCHAR2_TABLE_100();
752: a2 := JTF_NUMBER_TABLE();
753: a3 := JTF_NUMBER_TABLE();
754: a4 := JTF_VARCHAR2_TABLE_100();
755: a5 := JTF_NUMBER_TABLE();

Line 754: a4 := JTF_VARCHAR2_TABLE_100();

750: a0 := JTF_NUMBER_TABLE();
751: a1 := JTF_VARCHAR2_TABLE_100();
752: a2 := JTF_NUMBER_TABLE();
753: a3 := JTF_NUMBER_TABLE();
754: a4 := JTF_VARCHAR2_TABLE_100();
755: a5 := JTF_NUMBER_TABLE();
756: a6 := JTF_NUMBER_TABLE();
757: a7 := JTF_NUMBER_TABLE();
758: a8 := JTF_VARCHAR2_TABLE_100();

Line 758: a8 := JTF_VARCHAR2_TABLE_100();

754: a4 := JTF_VARCHAR2_TABLE_100();
755: a5 := JTF_NUMBER_TABLE();
756: a6 := JTF_NUMBER_TABLE();
757: a7 := JTF_NUMBER_TABLE();
758: a8 := JTF_VARCHAR2_TABLE_100();
759: a9 := JTF_DATE_TABLE();
760: a10 := JTF_DATE_TABLE();
761: a11 := JTF_VARCHAR2_TABLE_100();
762: a12 := JTF_NUMBER_TABLE();

Line 761: a11 := JTF_VARCHAR2_TABLE_100();

757: a7 := JTF_NUMBER_TABLE();
758: a8 := JTF_VARCHAR2_TABLE_100();
759: a9 := JTF_DATE_TABLE();
760: a10 := JTF_DATE_TABLE();
761: a11 := JTF_VARCHAR2_TABLE_100();
762: a12 := JTF_NUMBER_TABLE();
763: a13 := JTF_NUMBER_TABLE();
764: a14 := JTF_VARCHAR2_TABLE_100();
765: a15 := JTF_VARCHAR2_TABLE_100();

Line 764: a14 := JTF_VARCHAR2_TABLE_100();

760: a10 := JTF_DATE_TABLE();
761: a11 := JTF_VARCHAR2_TABLE_100();
762: a12 := JTF_NUMBER_TABLE();
763: a13 := JTF_NUMBER_TABLE();
764: a14 := JTF_VARCHAR2_TABLE_100();
765: a15 := JTF_VARCHAR2_TABLE_100();
766: else
767: a0 := JTF_NUMBER_TABLE();
768: a1 := JTF_VARCHAR2_TABLE_100();

Line 765: a15 := JTF_VARCHAR2_TABLE_100();

761: a11 := JTF_VARCHAR2_TABLE_100();
762: a12 := JTF_NUMBER_TABLE();
763: a13 := JTF_NUMBER_TABLE();
764: a14 := JTF_VARCHAR2_TABLE_100();
765: a15 := JTF_VARCHAR2_TABLE_100();
766: else
767: a0 := JTF_NUMBER_TABLE();
768: a1 := JTF_VARCHAR2_TABLE_100();
769: a2 := JTF_NUMBER_TABLE();

Line 768: a1 := JTF_VARCHAR2_TABLE_100();

764: a14 := JTF_VARCHAR2_TABLE_100();
765: a15 := JTF_VARCHAR2_TABLE_100();
766: else
767: a0 := JTF_NUMBER_TABLE();
768: a1 := JTF_VARCHAR2_TABLE_100();
769: a2 := JTF_NUMBER_TABLE();
770: a3 := JTF_NUMBER_TABLE();
771: a4 := JTF_VARCHAR2_TABLE_100();
772: a5 := JTF_NUMBER_TABLE();

Line 771: a4 := JTF_VARCHAR2_TABLE_100();

767: a0 := JTF_NUMBER_TABLE();
768: a1 := JTF_VARCHAR2_TABLE_100();
769: a2 := JTF_NUMBER_TABLE();
770: a3 := JTF_NUMBER_TABLE();
771: a4 := JTF_VARCHAR2_TABLE_100();
772: a5 := JTF_NUMBER_TABLE();
773: a6 := JTF_NUMBER_TABLE();
774: a7 := JTF_NUMBER_TABLE();
775: a8 := JTF_VARCHAR2_TABLE_100();

Line 775: a8 := JTF_VARCHAR2_TABLE_100();

771: a4 := JTF_VARCHAR2_TABLE_100();
772: a5 := JTF_NUMBER_TABLE();
773: a6 := JTF_NUMBER_TABLE();
774: a7 := JTF_NUMBER_TABLE();
775: a8 := JTF_VARCHAR2_TABLE_100();
776: a9 := JTF_DATE_TABLE();
777: a10 := JTF_DATE_TABLE();
778: a11 := JTF_VARCHAR2_TABLE_100();
779: a12 := JTF_NUMBER_TABLE();

Line 778: a11 := JTF_VARCHAR2_TABLE_100();

774: a7 := JTF_NUMBER_TABLE();
775: a8 := JTF_VARCHAR2_TABLE_100();
776: a9 := JTF_DATE_TABLE();
777: a10 := JTF_DATE_TABLE();
778: a11 := JTF_VARCHAR2_TABLE_100();
779: a12 := JTF_NUMBER_TABLE();
780: a13 := JTF_NUMBER_TABLE();
781: a14 := JTF_VARCHAR2_TABLE_100();
782: a15 := JTF_VARCHAR2_TABLE_100();

Line 781: a14 := JTF_VARCHAR2_TABLE_100();

777: a10 := JTF_DATE_TABLE();
778: a11 := JTF_VARCHAR2_TABLE_100();
779: a12 := JTF_NUMBER_TABLE();
780: a13 := JTF_NUMBER_TABLE();
781: a14 := JTF_VARCHAR2_TABLE_100();
782: a15 := JTF_VARCHAR2_TABLE_100();
783: if t.count > 0 then
784: a0.extend(t.count);
785: a1.extend(t.count);

Line 782: a15 := JTF_VARCHAR2_TABLE_100();

778: a11 := JTF_VARCHAR2_TABLE_100();
779: a12 := JTF_NUMBER_TABLE();
780: a13 := JTF_NUMBER_TABLE();
781: a14 := JTF_VARCHAR2_TABLE_100();
782: a15 := JTF_VARCHAR2_TABLE_100();
783: if t.count > 0 then
784: a0.extend(t.count);
785: a1.extend(t.count);
786: a2.extend(t.count);

Line 830: , a1 JTF_VARCHAR2_TABLE_100

826: end if;
827: end rosetta_table_copy_out_p19;
828:
829: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
830: , a1 JTF_VARCHAR2_TABLE_100
831: , a2 JTF_VARCHAR2_TABLE_100
832: , a3 JTF_NUMBER_TABLE
833: , a4 JTF_VARCHAR2_TABLE_100
834: , a5 JTF_NUMBER_TABLE

Line 831: , a2 JTF_VARCHAR2_TABLE_100

827: end rosetta_table_copy_out_p19;
828:
829: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
830: , a1 JTF_VARCHAR2_TABLE_100
831: , a2 JTF_VARCHAR2_TABLE_100
832: , a3 JTF_NUMBER_TABLE
833: , a4 JTF_VARCHAR2_TABLE_100
834: , a5 JTF_NUMBER_TABLE
835: ) as

Line 833: , a4 JTF_VARCHAR2_TABLE_100

829: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
830: , a1 JTF_VARCHAR2_TABLE_100
831: , a2 JTF_VARCHAR2_TABLE_100
832: , a3 JTF_NUMBER_TABLE
833: , a4 JTF_VARCHAR2_TABLE_100
834: , a5 JTF_NUMBER_TABLE
835: ) as
836: ddindx binary_integer; indx binary_integer;
837: begin

Line 859: , a1 out nocopy JTF_VARCHAR2_TABLE_100

855: end if;
856: end if;
857: end rosetta_table_copy_in_p20;
858: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
859: , a1 out nocopy JTF_VARCHAR2_TABLE_100
860: , a2 out nocopy JTF_VARCHAR2_TABLE_100
861: , a3 out nocopy JTF_NUMBER_TABLE
862: , a4 out nocopy JTF_VARCHAR2_TABLE_100
863: , a5 out nocopy JTF_NUMBER_TABLE

Line 860: , a2 out nocopy JTF_VARCHAR2_TABLE_100

856: end if;
857: end rosetta_table_copy_in_p20;
858: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
859: , a1 out nocopy JTF_VARCHAR2_TABLE_100
860: , a2 out nocopy JTF_VARCHAR2_TABLE_100
861: , a3 out nocopy JTF_NUMBER_TABLE
862: , a4 out nocopy JTF_VARCHAR2_TABLE_100
863: , a5 out nocopy JTF_NUMBER_TABLE
864: ) as

Line 862: , a4 out nocopy JTF_VARCHAR2_TABLE_100

858: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
859: , a1 out nocopy JTF_VARCHAR2_TABLE_100
860: , a2 out nocopy JTF_VARCHAR2_TABLE_100
861: , a3 out nocopy JTF_NUMBER_TABLE
862: , a4 out nocopy JTF_VARCHAR2_TABLE_100
863: , a5 out nocopy JTF_NUMBER_TABLE
864: ) as
865: ddindx binary_integer; indx binary_integer;
866: begin

Line 869: a1 := JTF_VARCHAR2_TABLE_100();

865: ddindx binary_integer; indx binary_integer;
866: begin
867: if t is null or t.count = 0 then
868: a0 := JTF_NUMBER_TABLE();
869: a1 := JTF_VARCHAR2_TABLE_100();
870: a2 := JTF_VARCHAR2_TABLE_100();
871: a3 := JTF_NUMBER_TABLE();
872: a4 := JTF_VARCHAR2_TABLE_100();
873: a5 := JTF_NUMBER_TABLE();

Line 870: a2 := JTF_VARCHAR2_TABLE_100();

866: begin
867: if t is null or t.count = 0 then
868: a0 := JTF_NUMBER_TABLE();
869: a1 := JTF_VARCHAR2_TABLE_100();
870: a2 := JTF_VARCHAR2_TABLE_100();
871: a3 := JTF_NUMBER_TABLE();
872: a4 := JTF_VARCHAR2_TABLE_100();
873: a5 := JTF_NUMBER_TABLE();
874: else

Line 872: a4 := JTF_VARCHAR2_TABLE_100();

868: a0 := JTF_NUMBER_TABLE();
869: a1 := JTF_VARCHAR2_TABLE_100();
870: a2 := JTF_VARCHAR2_TABLE_100();
871: a3 := JTF_NUMBER_TABLE();
872: a4 := JTF_VARCHAR2_TABLE_100();
873: a5 := JTF_NUMBER_TABLE();
874: else
875: a0 := JTF_NUMBER_TABLE();
876: a1 := JTF_VARCHAR2_TABLE_100();

Line 876: a1 := JTF_VARCHAR2_TABLE_100();

872: a4 := JTF_VARCHAR2_TABLE_100();
873: a5 := JTF_NUMBER_TABLE();
874: else
875: a0 := JTF_NUMBER_TABLE();
876: a1 := JTF_VARCHAR2_TABLE_100();
877: a2 := JTF_VARCHAR2_TABLE_100();
878: a3 := JTF_NUMBER_TABLE();
879: a4 := JTF_VARCHAR2_TABLE_100();
880: a5 := JTF_NUMBER_TABLE();

Line 877: a2 := JTF_VARCHAR2_TABLE_100();

873: a5 := JTF_NUMBER_TABLE();
874: else
875: a0 := JTF_NUMBER_TABLE();
876: a1 := JTF_VARCHAR2_TABLE_100();
877: a2 := JTF_VARCHAR2_TABLE_100();
878: a3 := JTF_NUMBER_TABLE();
879: a4 := JTF_VARCHAR2_TABLE_100();
880: a5 := JTF_NUMBER_TABLE();
881: if t.count > 0 then

Line 879: a4 := JTF_VARCHAR2_TABLE_100();

875: a0 := JTF_NUMBER_TABLE();
876: a1 := JTF_VARCHAR2_TABLE_100();
877: a2 := JTF_VARCHAR2_TABLE_100();
878: a3 := JTF_NUMBER_TABLE();
879: a4 := JTF_VARCHAR2_TABLE_100();
880: a5 := JTF_NUMBER_TABLE();
881: if t.count > 0 then
882: a0.extend(t.count);
883: a1.extend(t.count);

Line 908: , a1 JTF_VARCHAR2_TABLE_100

904: end if;
905: end rosetta_table_copy_out_p20;
906:
907: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
908: , a1 JTF_VARCHAR2_TABLE_100
909: , a2 JTF_NUMBER_TABLE
910: , a3 JTF_VARCHAR2_TABLE_100
911: , a4 JTF_VARCHAR2_TABLE_100
912: , a5 JTF_VARCHAR2_TABLE_300

Line 910: , a3 JTF_VARCHAR2_TABLE_100

906:
907: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
908: , a1 JTF_VARCHAR2_TABLE_100
909: , a2 JTF_NUMBER_TABLE
910: , a3 JTF_VARCHAR2_TABLE_100
911: , a4 JTF_VARCHAR2_TABLE_100
912: , a5 JTF_VARCHAR2_TABLE_300
913: , a6 JTF_NUMBER_TABLE
914: , a7 JTF_VARCHAR2_TABLE_300

Line 911: , a4 JTF_VARCHAR2_TABLE_100

907: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
908: , a1 JTF_VARCHAR2_TABLE_100
909: , a2 JTF_NUMBER_TABLE
910: , a3 JTF_VARCHAR2_TABLE_100
911: , a4 JTF_VARCHAR2_TABLE_100
912: , a5 JTF_VARCHAR2_TABLE_300
913: , a6 JTF_NUMBER_TABLE
914: , a7 JTF_VARCHAR2_TABLE_300
915: , a8 JTF_VARCHAR2_TABLE_100

Line 915: , a8 JTF_VARCHAR2_TABLE_100

911: , a4 JTF_VARCHAR2_TABLE_100
912: , a5 JTF_VARCHAR2_TABLE_300
913: , a6 JTF_NUMBER_TABLE
914: , a7 JTF_VARCHAR2_TABLE_300
915: , a8 JTF_VARCHAR2_TABLE_100
916: , a9 JTF_VARCHAR2_TABLE_100
917: , a10 JTF_NUMBER_TABLE
918: , a11 JTF_NUMBER_TABLE
919: , a12 JTF_VARCHAR2_TABLE_100

Line 916: , a9 JTF_VARCHAR2_TABLE_100

912: , a5 JTF_VARCHAR2_TABLE_300
913: , a6 JTF_NUMBER_TABLE
914: , a7 JTF_VARCHAR2_TABLE_300
915: , a8 JTF_VARCHAR2_TABLE_100
916: , a9 JTF_VARCHAR2_TABLE_100
917: , a10 JTF_NUMBER_TABLE
918: , a11 JTF_NUMBER_TABLE
919: , a12 JTF_VARCHAR2_TABLE_100
920: , a13 JTF_NUMBER_TABLE

Line 919: , a12 JTF_VARCHAR2_TABLE_100

915: , a8 JTF_VARCHAR2_TABLE_100
916: , a9 JTF_VARCHAR2_TABLE_100
917: , a10 JTF_NUMBER_TABLE
918: , a11 JTF_NUMBER_TABLE
919: , a12 JTF_VARCHAR2_TABLE_100
920: , a13 JTF_NUMBER_TABLE
921: , a14 JTF_NUMBER_TABLE
922: , a15 JTF_VARCHAR2_TABLE_100
923: , a16 JTF_VARCHAR2_TABLE_100

Line 922: , a15 JTF_VARCHAR2_TABLE_100

918: , a11 JTF_NUMBER_TABLE
919: , a12 JTF_VARCHAR2_TABLE_100
920: , a13 JTF_NUMBER_TABLE
921: , a14 JTF_NUMBER_TABLE
922: , a15 JTF_VARCHAR2_TABLE_100
923: , a16 JTF_VARCHAR2_TABLE_100
924: , a17 JTF_DATE_TABLE
925: , a18 JTF_DATE_TABLE
926: , a19 JTF_VARCHAR2_TABLE_100

Line 923: , a16 JTF_VARCHAR2_TABLE_100

919: , a12 JTF_VARCHAR2_TABLE_100
920: , a13 JTF_NUMBER_TABLE
921: , a14 JTF_NUMBER_TABLE
922: , a15 JTF_VARCHAR2_TABLE_100
923: , a16 JTF_VARCHAR2_TABLE_100
924: , a17 JTF_DATE_TABLE
925: , a18 JTF_DATE_TABLE
926: , a19 JTF_VARCHAR2_TABLE_100
927: , a20 JTF_VARCHAR2_TABLE_100

Line 926: , a19 JTF_VARCHAR2_TABLE_100

922: , a15 JTF_VARCHAR2_TABLE_100
923: , a16 JTF_VARCHAR2_TABLE_100
924: , a17 JTF_DATE_TABLE
925: , a18 JTF_DATE_TABLE
926: , a19 JTF_VARCHAR2_TABLE_100
927: , a20 JTF_VARCHAR2_TABLE_100
928: ) as
929: ddindx binary_integer; indx binary_integer;
930: begin

Line 927: , a20 JTF_VARCHAR2_TABLE_100

923: , a16 JTF_VARCHAR2_TABLE_100
924: , a17 JTF_DATE_TABLE
925: , a18 JTF_DATE_TABLE
926: , a19 JTF_VARCHAR2_TABLE_100
927: , a20 JTF_VARCHAR2_TABLE_100
928: ) as
929: ddindx binary_integer; indx binary_integer;
930: begin
931: if a0 is not null and a0.count=0 then

Line 971: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 973: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 974: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 978: , a8 out nocopy JTF_VARCHAR2_TABLE_100

974: , a4 out nocopy JTF_VARCHAR2_TABLE_100
975: , a5 out nocopy JTF_VARCHAR2_TABLE_300
976: , a6 out nocopy JTF_NUMBER_TABLE
977: , a7 out nocopy JTF_VARCHAR2_TABLE_300
978: , a8 out nocopy JTF_VARCHAR2_TABLE_100
979: , a9 out nocopy JTF_VARCHAR2_TABLE_100
980: , a10 out nocopy JTF_NUMBER_TABLE
981: , a11 out nocopy JTF_NUMBER_TABLE
982: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 979: , a9 out nocopy JTF_VARCHAR2_TABLE_100

975: , a5 out nocopy JTF_VARCHAR2_TABLE_300
976: , a6 out nocopy JTF_NUMBER_TABLE
977: , a7 out nocopy JTF_VARCHAR2_TABLE_300
978: , a8 out nocopy JTF_VARCHAR2_TABLE_100
979: , a9 out nocopy JTF_VARCHAR2_TABLE_100
980: , a10 out nocopy JTF_NUMBER_TABLE
981: , a11 out nocopy JTF_NUMBER_TABLE
982: , a12 out nocopy JTF_VARCHAR2_TABLE_100
983: , a13 out nocopy JTF_NUMBER_TABLE

Line 982: , a12 out nocopy JTF_VARCHAR2_TABLE_100

978: , a8 out nocopy JTF_VARCHAR2_TABLE_100
979: , a9 out nocopy JTF_VARCHAR2_TABLE_100
980: , a10 out nocopy JTF_NUMBER_TABLE
981: , a11 out nocopy JTF_NUMBER_TABLE
982: , a12 out nocopy JTF_VARCHAR2_TABLE_100
983: , a13 out nocopy JTF_NUMBER_TABLE
984: , a14 out nocopy JTF_NUMBER_TABLE
985: , a15 out nocopy JTF_VARCHAR2_TABLE_100
986: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 985: , a15 out nocopy JTF_VARCHAR2_TABLE_100

981: , a11 out nocopy JTF_NUMBER_TABLE
982: , a12 out nocopy JTF_VARCHAR2_TABLE_100
983: , a13 out nocopy JTF_NUMBER_TABLE
984: , a14 out nocopy JTF_NUMBER_TABLE
985: , a15 out nocopy JTF_VARCHAR2_TABLE_100
986: , a16 out nocopy JTF_VARCHAR2_TABLE_100
987: , a17 out nocopy JTF_DATE_TABLE
988: , a18 out nocopy JTF_DATE_TABLE
989: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 986: , a16 out nocopy JTF_VARCHAR2_TABLE_100

982: , a12 out nocopy JTF_VARCHAR2_TABLE_100
983: , a13 out nocopy JTF_NUMBER_TABLE
984: , a14 out nocopy JTF_NUMBER_TABLE
985: , a15 out nocopy JTF_VARCHAR2_TABLE_100
986: , a16 out nocopy JTF_VARCHAR2_TABLE_100
987: , a17 out nocopy JTF_DATE_TABLE
988: , a18 out nocopy JTF_DATE_TABLE
989: , a19 out nocopy JTF_VARCHAR2_TABLE_100
990: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 989: , a19 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 990: , a20 out nocopy JTF_VARCHAR2_TABLE_100

986: , a16 out nocopy JTF_VARCHAR2_TABLE_100
987: , a17 out nocopy JTF_DATE_TABLE
988: , a18 out nocopy JTF_DATE_TABLE
989: , a19 out nocopy JTF_VARCHAR2_TABLE_100
990: , a20 out nocopy JTF_VARCHAR2_TABLE_100
991: ) as
992: ddindx binary_integer; indx binary_integer;
993: begin
994: if t is null then

Line 1018: a1 := JTF_VARCHAR2_TABLE_100();

1014: a19 := null;
1015: a20 := null;
1016: elsif t.count = 0 then
1017: a0 := JTF_NUMBER_TABLE();
1018: a1 := JTF_VARCHAR2_TABLE_100();
1019: a2 := JTF_NUMBER_TABLE();
1020: a3 := JTF_VARCHAR2_TABLE_100();
1021: a4 := JTF_VARCHAR2_TABLE_100();
1022: a5 := JTF_VARCHAR2_TABLE_300();

Line 1020: a3 := JTF_VARCHAR2_TABLE_100();

1016: elsif t.count = 0 then
1017: a0 := JTF_NUMBER_TABLE();
1018: a1 := JTF_VARCHAR2_TABLE_100();
1019: a2 := JTF_NUMBER_TABLE();
1020: a3 := JTF_VARCHAR2_TABLE_100();
1021: a4 := JTF_VARCHAR2_TABLE_100();
1022: a5 := JTF_VARCHAR2_TABLE_300();
1023: a6 := JTF_NUMBER_TABLE();
1024: a7 := JTF_VARCHAR2_TABLE_300();

Line 1021: a4 := JTF_VARCHAR2_TABLE_100();

1017: a0 := JTF_NUMBER_TABLE();
1018: a1 := JTF_VARCHAR2_TABLE_100();
1019: a2 := JTF_NUMBER_TABLE();
1020: a3 := JTF_VARCHAR2_TABLE_100();
1021: a4 := JTF_VARCHAR2_TABLE_100();
1022: a5 := JTF_VARCHAR2_TABLE_300();
1023: a6 := JTF_NUMBER_TABLE();
1024: a7 := JTF_VARCHAR2_TABLE_300();
1025: a8 := JTF_VARCHAR2_TABLE_100();

Line 1025: a8 := JTF_VARCHAR2_TABLE_100();

1021: a4 := JTF_VARCHAR2_TABLE_100();
1022: a5 := JTF_VARCHAR2_TABLE_300();
1023: a6 := JTF_NUMBER_TABLE();
1024: a7 := JTF_VARCHAR2_TABLE_300();
1025: a8 := JTF_VARCHAR2_TABLE_100();
1026: a9 := JTF_VARCHAR2_TABLE_100();
1027: a10 := JTF_NUMBER_TABLE();
1028: a11 := JTF_NUMBER_TABLE();
1029: a12 := JTF_VARCHAR2_TABLE_100();

Line 1026: a9 := JTF_VARCHAR2_TABLE_100();

1022: a5 := JTF_VARCHAR2_TABLE_300();
1023: a6 := JTF_NUMBER_TABLE();
1024: a7 := JTF_VARCHAR2_TABLE_300();
1025: a8 := JTF_VARCHAR2_TABLE_100();
1026: a9 := JTF_VARCHAR2_TABLE_100();
1027: a10 := JTF_NUMBER_TABLE();
1028: a11 := JTF_NUMBER_TABLE();
1029: a12 := JTF_VARCHAR2_TABLE_100();
1030: a13 := JTF_NUMBER_TABLE();

Line 1029: a12 := JTF_VARCHAR2_TABLE_100();

1025: a8 := JTF_VARCHAR2_TABLE_100();
1026: a9 := JTF_VARCHAR2_TABLE_100();
1027: a10 := JTF_NUMBER_TABLE();
1028: a11 := JTF_NUMBER_TABLE();
1029: a12 := JTF_VARCHAR2_TABLE_100();
1030: a13 := JTF_NUMBER_TABLE();
1031: a14 := JTF_NUMBER_TABLE();
1032: a15 := JTF_VARCHAR2_TABLE_100();
1033: a16 := JTF_VARCHAR2_TABLE_100();

Line 1032: a15 := JTF_VARCHAR2_TABLE_100();

1028: a11 := JTF_NUMBER_TABLE();
1029: a12 := JTF_VARCHAR2_TABLE_100();
1030: a13 := JTF_NUMBER_TABLE();
1031: a14 := JTF_NUMBER_TABLE();
1032: a15 := JTF_VARCHAR2_TABLE_100();
1033: a16 := JTF_VARCHAR2_TABLE_100();
1034: a17 := JTF_DATE_TABLE();
1035: a18 := JTF_DATE_TABLE();
1036: a19 := JTF_VARCHAR2_TABLE_100();

Line 1033: a16 := JTF_VARCHAR2_TABLE_100();

1029: a12 := JTF_VARCHAR2_TABLE_100();
1030: a13 := JTF_NUMBER_TABLE();
1031: a14 := JTF_NUMBER_TABLE();
1032: a15 := JTF_VARCHAR2_TABLE_100();
1033: a16 := JTF_VARCHAR2_TABLE_100();
1034: a17 := JTF_DATE_TABLE();
1035: a18 := JTF_DATE_TABLE();
1036: a19 := JTF_VARCHAR2_TABLE_100();
1037: a20 := JTF_VARCHAR2_TABLE_100();

Line 1036: a19 := JTF_VARCHAR2_TABLE_100();

1032: a15 := JTF_VARCHAR2_TABLE_100();
1033: a16 := JTF_VARCHAR2_TABLE_100();
1034: a17 := JTF_DATE_TABLE();
1035: a18 := JTF_DATE_TABLE();
1036: a19 := JTF_VARCHAR2_TABLE_100();
1037: a20 := JTF_VARCHAR2_TABLE_100();
1038: else
1039: a0 := JTF_NUMBER_TABLE();
1040: a1 := JTF_VARCHAR2_TABLE_100();

Line 1037: a20 := JTF_VARCHAR2_TABLE_100();

1033: a16 := JTF_VARCHAR2_TABLE_100();
1034: a17 := JTF_DATE_TABLE();
1035: a18 := JTF_DATE_TABLE();
1036: a19 := JTF_VARCHAR2_TABLE_100();
1037: a20 := JTF_VARCHAR2_TABLE_100();
1038: else
1039: a0 := JTF_NUMBER_TABLE();
1040: a1 := JTF_VARCHAR2_TABLE_100();
1041: a2 := JTF_NUMBER_TABLE();

Line 1040: a1 := JTF_VARCHAR2_TABLE_100();

1036: a19 := JTF_VARCHAR2_TABLE_100();
1037: a20 := JTF_VARCHAR2_TABLE_100();
1038: else
1039: a0 := JTF_NUMBER_TABLE();
1040: a1 := JTF_VARCHAR2_TABLE_100();
1041: a2 := JTF_NUMBER_TABLE();
1042: a3 := JTF_VARCHAR2_TABLE_100();
1043: a4 := JTF_VARCHAR2_TABLE_100();
1044: a5 := JTF_VARCHAR2_TABLE_300();

Line 1042: a3 := JTF_VARCHAR2_TABLE_100();

1038: else
1039: a0 := JTF_NUMBER_TABLE();
1040: a1 := JTF_VARCHAR2_TABLE_100();
1041: a2 := JTF_NUMBER_TABLE();
1042: a3 := JTF_VARCHAR2_TABLE_100();
1043: a4 := JTF_VARCHAR2_TABLE_100();
1044: a5 := JTF_VARCHAR2_TABLE_300();
1045: a6 := JTF_NUMBER_TABLE();
1046: a7 := JTF_VARCHAR2_TABLE_300();

Line 1043: a4 := JTF_VARCHAR2_TABLE_100();

1039: a0 := JTF_NUMBER_TABLE();
1040: a1 := JTF_VARCHAR2_TABLE_100();
1041: a2 := JTF_NUMBER_TABLE();
1042: a3 := JTF_VARCHAR2_TABLE_100();
1043: a4 := JTF_VARCHAR2_TABLE_100();
1044: a5 := JTF_VARCHAR2_TABLE_300();
1045: a6 := JTF_NUMBER_TABLE();
1046: a7 := JTF_VARCHAR2_TABLE_300();
1047: a8 := JTF_VARCHAR2_TABLE_100();

Line 1047: a8 := JTF_VARCHAR2_TABLE_100();

1043: a4 := JTF_VARCHAR2_TABLE_100();
1044: a5 := JTF_VARCHAR2_TABLE_300();
1045: a6 := JTF_NUMBER_TABLE();
1046: a7 := JTF_VARCHAR2_TABLE_300();
1047: a8 := JTF_VARCHAR2_TABLE_100();
1048: a9 := JTF_VARCHAR2_TABLE_100();
1049: a10 := JTF_NUMBER_TABLE();
1050: a11 := JTF_NUMBER_TABLE();
1051: a12 := JTF_VARCHAR2_TABLE_100();

Line 1048: a9 := JTF_VARCHAR2_TABLE_100();

1044: a5 := JTF_VARCHAR2_TABLE_300();
1045: a6 := JTF_NUMBER_TABLE();
1046: a7 := JTF_VARCHAR2_TABLE_300();
1047: a8 := JTF_VARCHAR2_TABLE_100();
1048: a9 := JTF_VARCHAR2_TABLE_100();
1049: a10 := JTF_NUMBER_TABLE();
1050: a11 := JTF_NUMBER_TABLE();
1051: a12 := JTF_VARCHAR2_TABLE_100();
1052: a13 := JTF_NUMBER_TABLE();

Line 1051: a12 := JTF_VARCHAR2_TABLE_100();

1047: a8 := JTF_VARCHAR2_TABLE_100();
1048: a9 := JTF_VARCHAR2_TABLE_100();
1049: a10 := JTF_NUMBER_TABLE();
1050: a11 := JTF_NUMBER_TABLE();
1051: a12 := JTF_VARCHAR2_TABLE_100();
1052: a13 := JTF_NUMBER_TABLE();
1053: a14 := JTF_NUMBER_TABLE();
1054: a15 := JTF_VARCHAR2_TABLE_100();
1055: a16 := JTF_VARCHAR2_TABLE_100();

Line 1054: a15 := JTF_VARCHAR2_TABLE_100();

1050: a11 := JTF_NUMBER_TABLE();
1051: a12 := JTF_VARCHAR2_TABLE_100();
1052: a13 := JTF_NUMBER_TABLE();
1053: a14 := JTF_NUMBER_TABLE();
1054: a15 := JTF_VARCHAR2_TABLE_100();
1055: a16 := JTF_VARCHAR2_TABLE_100();
1056: a17 := JTF_DATE_TABLE();
1057: a18 := JTF_DATE_TABLE();
1058: a19 := JTF_VARCHAR2_TABLE_100();

Line 1055: a16 := JTF_VARCHAR2_TABLE_100();

1051: a12 := JTF_VARCHAR2_TABLE_100();
1052: a13 := JTF_NUMBER_TABLE();
1053: a14 := JTF_NUMBER_TABLE();
1054: a15 := JTF_VARCHAR2_TABLE_100();
1055: a16 := JTF_VARCHAR2_TABLE_100();
1056: a17 := JTF_DATE_TABLE();
1057: a18 := JTF_DATE_TABLE();
1058: a19 := JTF_VARCHAR2_TABLE_100();
1059: a20 := JTF_VARCHAR2_TABLE_100();

Line 1058: a19 := JTF_VARCHAR2_TABLE_100();

1054: a15 := JTF_VARCHAR2_TABLE_100();
1055: a16 := JTF_VARCHAR2_TABLE_100();
1056: a17 := JTF_DATE_TABLE();
1057: a18 := JTF_DATE_TABLE();
1058: a19 := JTF_VARCHAR2_TABLE_100();
1059: a20 := JTF_VARCHAR2_TABLE_100();
1060: if t.count > 0 then
1061: a0.extend(t.count);
1062: a1.extend(t.count);

Line 1059: a20 := JTF_VARCHAR2_TABLE_100();

1055: a16 := JTF_VARCHAR2_TABLE_100();
1056: a17 := JTF_DATE_TABLE();
1057: a18 := JTF_DATE_TABLE();
1058: a19 := JTF_VARCHAR2_TABLE_100();
1059: a20 := JTF_VARCHAR2_TABLE_100();
1060: if t.count > 0 then
1061: a0.extend(t.count);
1062: a1.extend(t.count);
1063: a2.extend(t.count);

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

1112: end if;
1113: end if;
1114: end rosetta_table_copy_out_p21;
1115:
1116: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1117: , a1 JTF_NUMBER_TABLE
1118: , a2 JTF_NUMBER_TABLE
1119: , a3 JTF_VARCHAR2_TABLE_100
1120: , a4 JTF_VARCHAR2_TABLE_100

Line 1119: , a3 JTF_VARCHAR2_TABLE_100

1115:
1116: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1117: , a1 JTF_NUMBER_TABLE
1118: , a2 JTF_NUMBER_TABLE
1119: , a3 JTF_VARCHAR2_TABLE_100
1120: , a4 JTF_VARCHAR2_TABLE_100
1121: , a5 JTF_VARCHAR2_TABLE_300
1122: ) as
1123: ddindx binary_integer; indx binary_integer;

Line 1120: , a4 JTF_VARCHAR2_TABLE_100

1116: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1117: , a1 JTF_NUMBER_TABLE
1118: , a2 JTF_NUMBER_TABLE
1119: , a3 JTF_VARCHAR2_TABLE_100
1120: , a4 JTF_VARCHAR2_TABLE_100
1121: , a5 JTF_VARCHAR2_TABLE_300
1122: ) as
1123: ddindx binary_integer; indx binary_integer;
1124: begin

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

1145: end loop;
1146: end if;
1147: end if;
1148: end rosetta_table_copy_in_p22;
1149: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1150: , a1 out nocopy JTF_NUMBER_TABLE
1151: , a2 out nocopy JTF_NUMBER_TABLE
1152: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1153: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1152: , a3 out nocopy JTF_VARCHAR2_TABLE_100

1148: end rosetta_table_copy_in_p22;
1149: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1150: , a1 out nocopy JTF_NUMBER_TABLE
1151: , a2 out nocopy JTF_NUMBER_TABLE
1152: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1153: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1154: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1155: ) as
1156: ddindx binary_integer; indx binary_integer;

Line 1153: , a4 out nocopy JTF_VARCHAR2_TABLE_100

1149: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1150: , a1 out nocopy JTF_NUMBER_TABLE
1151: , a2 out nocopy JTF_NUMBER_TABLE
1152: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1153: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1154: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1155: ) as
1156: ddindx binary_integer; indx binary_integer;
1157: begin

Line 1166: a0 := JTF_VARCHAR2_TABLE_100();

1162: a3 := null;
1163: a4 := null;
1164: a5 := null;
1165: elsif t.count = 0 then
1166: a0 := JTF_VARCHAR2_TABLE_100();
1167: a1 := JTF_NUMBER_TABLE();
1168: a2 := JTF_NUMBER_TABLE();
1169: a3 := JTF_VARCHAR2_TABLE_100();
1170: a4 := JTF_VARCHAR2_TABLE_100();

Line 1169: a3 := JTF_VARCHAR2_TABLE_100();

1165: elsif t.count = 0 then
1166: a0 := JTF_VARCHAR2_TABLE_100();
1167: a1 := JTF_NUMBER_TABLE();
1168: a2 := JTF_NUMBER_TABLE();
1169: a3 := JTF_VARCHAR2_TABLE_100();
1170: a4 := JTF_VARCHAR2_TABLE_100();
1171: a5 := JTF_VARCHAR2_TABLE_300();
1172: else
1173: a0 := JTF_VARCHAR2_TABLE_100();

Line 1170: a4 := JTF_VARCHAR2_TABLE_100();

1166: a0 := JTF_VARCHAR2_TABLE_100();
1167: a1 := JTF_NUMBER_TABLE();
1168: a2 := JTF_NUMBER_TABLE();
1169: a3 := JTF_VARCHAR2_TABLE_100();
1170: a4 := JTF_VARCHAR2_TABLE_100();
1171: a5 := JTF_VARCHAR2_TABLE_300();
1172: else
1173: a0 := JTF_VARCHAR2_TABLE_100();
1174: a1 := JTF_NUMBER_TABLE();

Line 1173: a0 := JTF_VARCHAR2_TABLE_100();

1169: a3 := JTF_VARCHAR2_TABLE_100();
1170: a4 := JTF_VARCHAR2_TABLE_100();
1171: a5 := JTF_VARCHAR2_TABLE_300();
1172: else
1173: a0 := JTF_VARCHAR2_TABLE_100();
1174: a1 := JTF_NUMBER_TABLE();
1175: a2 := JTF_NUMBER_TABLE();
1176: a3 := JTF_VARCHAR2_TABLE_100();
1177: a4 := JTF_VARCHAR2_TABLE_100();

Line 1176: a3 := JTF_VARCHAR2_TABLE_100();

1172: else
1173: a0 := JTF_VARCHAR2_TABLE_100();
1174: a1 := JTF_NUMBER_TABLE();
1175: a2 := JTF_NUMBER_TABLE();
1176: a3 := JTF_VARCHAR2_TABLE_100();
1177: a4 := JTF_VARCHAR2_TABLE_100();
1178: a5 := JTF_VARCHAR2_TABLE_300();
1179: if t.count > 0 then
1180: a0.extend(t.count);

Line 1177: a4 := JTF_VARCHAR2_TABLE_100();

1173: a0 := JTF_VARCHAR2_TABLE_100();
1174: a1 := JTF_NUMBER_TABLE();
1175: a2 := JTF_NUMBER_TABLE();
1176: a3 := JTF_VARCHAR2_TABLE_100();
1177: a4 := JTF_VARCHAR2_TABLE_100();
1178: a5 := JTF_VARCHAR2_TABLE_300();
1179: if t.count > 0 then
1180: a0.extend(t.count);
1181: a1.extend(t.count);

Line 1206: , a1 JTF_VARCHAR2_TABLE_100

1202: end if;
1203: end rosetta_table_copy_out_p22;
1204:
1205: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1206: , a1 JTF_VARCHAR2_TABLE_100
1207: , a2 JTF_VARCHAR2_TABLE_100
1208: , a3 JTF_NUMBER_TABLE
1209: , a4 JTF_NUMBER_TABLE
1210: , a5 JTF_VARCHAR2_TABLE_100

Line 1207: , a2 JTF_VARCHAR2_TABLE_100

1203: end rosetta_table_copy_out_p22;
1204:
1205: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1206: , a1 JTF_VARCHAR2_TABLE_100
1207: , a2 JTF_VARCHAR2_TABLE_100
1208: , a3 JTF_NUMBER_TABLE
1209: , a4 JTF_NUMBER_TABLE
1210: , a5 JTF_VARCHAR2_TABLE_100
1211: , a6 JTF_NUMBER_TABLE

Line 1210: , a5 JTF_VARCHAR2_TABLE_100

1206: , a1 JTF_VARCHAR2_TABLE_100
1207: , a2 JTF_VARCHAR2_TABLE_100
1208: , a3 JTF_NUMBER_TABLE
1209: , a4 JTF_NUMBER_TABLE
1210: , a5 JTF_VARCHAR2_TABLE_100
1211: , a6 JTF_NUMBER_TABLE
1212: , a7 JTF_NUMBER_TABLE
1213: ) as
1214: ddindx binary_integer; indx binary_integer;

Line 1243: , a1 out nocopy JTF_VARCHAR2_TABLE_100

1239: end if;
1240: end if;
1241: end rosetta_table_copy_in_p23;
1242: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1243: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1244: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1245: , a3 out nocopy JTF_NUMBER_TABLE
1246: , a4 out nocopy JTF_NUMBER_TABLE
1247: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1244: , a2 out nocopy JTF_VARCHAR2_TABLE_100

1240: end if;
1241: end rosetta_table_copy_in_p23;
1242: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1243: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1244: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1245: , a3 out nocopy JTF_NUMBER_TABLE
1246: , a4 out nocopy JTF_NUMBER_TABLE
1247: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1248: , a6 out nocopy JTF_NUMBER_TABLE

Line 1247: , a5 out nocopy JTF_VARCHAR2_TABLE_100

1243: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1244: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1245: , a3 out nocopy JTF_NUMBER_TABLE
1246: , a4 out nocopy JTF_NUMBER_TABLE
1247: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1248: , a6 out nocopy JTF_NUMBER_TABLE
1249: , a7 out nocopy JTF_NUMBER_TABLE
1250: ) as
1251: ddindx binary_integer; indx binary_integer;

Line 1264: a1 := JTF_VARCHAR2_TABLE_100();

1260: a6 := null;
1261: a7 := null;
1262: elsif t.count = 0 then
1263: a0 := JTF_NUMBER_TABLE();
1264: a1 := JTF_VARCHAR2_TABLE_100();
1265: a2 := JTF_VARCHAR2_TABLE_100();
1266: a3 := JTF_NUMBER_TABLE();
1267: a4 := JTF_NUMBER_TABLE();
1268: a5 := JTF_VARCHAR2_TABLE_100();

Line 1265: a2 := JTF_VARCHAR2_TABLE_100();

1261: a7 := null;
1262: elsif t.count = 0 then
1263: a0 := JTF_NUMBER_TABLE();
1264: a1 := JTF_VARCHAR2_TABLE_100();
1265: a2 := JTF_VARCHAR2_TABLE_100();
1266: a3 := JTF_NUMBER_TABLE();
1267: a4 := JTF_NUMBER_TABLE();
1268: a5 := JTF_VARCHAR2_TABLE_100();
1269: a6 := JTF_NUMBER_TABLE();

Line 1268: a5 := JTF_VARCHAR2_TABLE_100();

1264: a1 := JTF_VARCHAR2_TABLE_100();
1265: a2 := JTF_VARCHAR2_TABLE_100();
1266: a3 := JTF_NUMBER_TABLE();
1267: a4 := JTF_NUMBER_TABLE();
1268: a5 := JTF_VARCHAR2_TABLE_100();
1269: a6 := JTF_NUMBER_TABLE();
1270: a7 := JTF_NUMBER_TABLE();
1271: else
1272: a0 := JTF_NUMBER_TABLE();

Line 1273: a1 := JTF_VARCHAR2_TABLE_100();

1269: a6 := JTF_NUMBER_TABLE();
1270: a7 := JTF_NUMBER_TABLE();
1271: else
1272: a0 := JTF_NUMBER_TABLE();
1273: a1 := JTF_VARCHAR2_TABLE_100();
1274: a2 := JTF_VARCHAR2_TABLE_100();
1275: a3 := JTF_NUMBER_TABLE();
1276: a4 := JTF_NUMBER_TABLE();
1277: a5 := JTF_VARCHAR2_TABLE_100();

Line 1274: a2 := JTF_VARCHAR2_TABLE_100();

1270: a7 := JTF_NUMBER_TABLE();
1271: else
1272: a0 := JTF_NUMBER_TABLE();
1273: a1 := JTF_VARCHAR2_TABLE_100();
1274: a2 := JTF_VARCHAR2_TABLE_100();
1275: a3 := JTF_NUMBER_TABLE();
1276: a4 := JTF_NUMBER_TABLE();
1277: a5 := JTF_VARCHAR2_TABLE_100();
1278: a6 := JTF_NUMBER_TABLE();

Line 1277: a5 := JTF_VARCHAR2_TABLE_100();

1273: a1 := JTF_VARCHAR2_TABLE_100();
1274: a2 := JTF_VARCHAR2_TABLE_100();
1275: a3 := JTF_NUMBER_TABLE();
1276: a4 := JTF_NUMBER_TABLE();
1277: a5 := JTF_VARCHAR2_TABLE_100();
1278: a6 := JTF_NUMBER_TABLE();
1279: a7 := JTF_NUMBER_TABLE();
1280: if t.count > 0 then
1281: a0.extend(t.count);

Line 1313: , p2_a1 JTF_VARCHAR2_TABLE_100

1309:
1310: procedure get_availability_options(p_api_version_number NUMBER
1311: , p_task_id NUMBER
1312: , p2_a0 JTF_NUMBER_TABLE
1313: , p2_a1 JTF_VARCHAR2_TABLE_100
1314: , p3_a0 DATE
1315: , p3_a1 DATE
1316: , p_likelihood NUMBER
1317: , p_subinv_only number

Line 1319: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

1315: , p3_a1 DATE
1316: , p_likelihood NUMBER
1317: , p_subinv_only number
1318: , p6_a0 out nocopy JTF_NUMBER_TABLE
1319: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1320: , p6_a2 out nocopy JTF_DATE_TABLE
1321: , p6_a3 out nocopy JTF_NUMBER_TABLE
1322: , x_return_status out nocopy VARCHAR2
1323: , x_msg_data out nocopy VARCHAR2

Line 1443: , p4_a1 JTF_VARCHAR2_TABLE_100

1439: , p_organization_id NUMBER
1440: , p_subinv_code VARCHAR2
1441: , p_need_by_date DATE
1442: , p4_a0 JTF_NUMBER_TABLE
1443: , p4_a1 JTF_VARCHAR2_TABLE_100
1444: , p4_a2 JTF_VARCHAR2_TABLE_100
1445: , p4_a3 JTF_NUMBER_TABLE
1446: , p4_a4 JTF_VARCHAR2_TABLE_100
1447: , p4_a5 JTF_NUMBER_TABLE

Line 1444: , p4_a2 JTF_VARCHAR2_TABLE_100

1440: , p_subinv_code VARCHAR2
1441: , p_need_by_date DATE
1442: , p4_a0 JTF_NUMBER_TABLE
1443: , p4_a1 JTF_VARCHAR2_TABLE_100
1444: , p4_a2 JTF_VARCHAR2_TABLE_100
1445: , p4_a3 JTF_NUMBER_TABLE
1446: , p4_a4 JTF_VARCHAR2_TABLE_100
1447: , p4_a5 JTF_NUMBER_TABLE
1448: , p_timezone_id NUMBER

Line 1446: , p4_a4 JTF_VARCHAR2_TABLE_100

1442: , p4_a0 JTF_NUMBER_TABLE
1443: , p4_a1 JTF_VARCHAR2_TABLE_100
1444: , p4_a2 JTF_VARCHAR2_TABLE_100
1445: , p4_a3 JTF_NUMBER_TABLE
1446: , p4_a4 JTF_VARCHAR2_TABLE_100
1447: , p4_a5 JTF_NUMBER_TABLE
1448: , p_timezone_id NUMBER
1449: , p6_a0 out nocopy JTF_NUMBER_TABLE
1450: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 1450: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

1446: , p4_a4 JTF_VARCHAR2_TABLE_100
1447: , p4_a5 JTF_NUMBER_TABLE
1448: , p_timezone_id NUMBER
1449: , p6_a0 out nocopy JTF_NUMBER_TABLE
1450: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1451: , p6_a2 out nocopy JTF_NUMBER_TABLE
1452: , p6_a3 out nocopy JTF_NUMBER_TABLE
1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1454: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

1449: , p6_a0 out nocopy JTF_NUMBER_TABLE
1450: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1451: , p6_a2 out nocopy JTF_NUMBER_TABLE
1452: , p6_a3 out nocopy JTF_NUMBER_TABLE
1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1454: , p6_a5 out nocopy JTF_NUMBER_TABLE
1455: , p6_a6 out nocopy JTF_NUMBER_TABLE
1456: , p6_a7 out nocopy JTF_NUMBER_TABLE
1457: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1457: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1454: , p6_a5 out nocopy JTF_NUMBER_TABLE
1455: , p6_a6 out nocopy JTF_NUMBER_TABLE
1456: , p6_a7 out nocopy JTF_NUMBER_TABLE
1457: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1458: , p6_a9 out nocopy JTF_DATE_TABLE
1459: , p6_a10 out nocopy JTF_DATE_TABLE
1460: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1461: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 1460: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

1456: , p6_a7 out nocopy JTF_NUMBER_TABLE
1457: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1458: , p6_a9 out nocopy JTF_DATE_TABLE
1459: , p6_a10 out nocopy JTF_DATE_TABLE
1460: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1461: , p6_a12 out nocopy JTF_NUMBER_TABLE
1462: , p6_a13 out nocopy JTF_NUMBER_TABLE
1463: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1463: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

1459: , p6_a10 out nocopy JTF_DATE_TABLE
1460: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1461: , p6_a12 out nocopy JTF_NUMBER_TABLE
1462: , p6_a13 out nocopy JTF_NUMBER_TABLE
1463: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1465: , x_return_status out nocopy VARCHAR2
1466: , x_msg_data out nocopy VARCHAR2
1467: , x_msg_count out nocopy NUMBER

Line 1464: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

1460: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1461: , p6_a12 out nocopy JTF_NUMBER_TABLE
1462: , p6_a13 out nocopy JTF_NUMBER_TABLE
1463: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1465: , x_return_status out nocopy VARCHAR2
1466: , x_msg_data out nocopy VARCHAR2
1467: , x_msg_count out nocopy NUMBER
1468: , p_called_from VARCHAR2

Line 1588: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100

1584:
1585: return ddrosetta_retval;
1586: end;
1587:
1588: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1589: , p0_a1 JTF_NUMBER_TABLE
1590: , p0_a2 JTF_NUMBER_TABLE
1591: , p0_a3 JTF_VARCHAR2_TABLE_100
1592: , p0_a4 JTF_VARCHAR2_TABLE_100

Line 1591: , p0_a3 JTF_VARCHAR2_TABLE_100

1587:
1588: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1589: , p0_a1 JTF_NUMBER_TABLE
1590: , p0_a2 JTF_NUMBER_TABLE
1591: , p0_a3 JTF_VARCHAR2_TABLE_100
1592: , p0_a4 JTF_VARCHAR2_TABLE_100
1593: , p0_a5 JTF_VARCHAR2_TABLE_300
1594: , p1_a0 JTF_NUMBER_TABLE
1595: , p1_a1 JTF_VARCHAR2_TABLE_100

Line 1592: , p0_a4 JTF_VARCHAR2_TABLE_100

1588: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1589: , p0_a1 JTF_NUMBER_TABLE
1590: , p0_a2 JTF_NUMBER_TABLE
1591: , p0_a3 JTF_VARCHAR2_TABLE_100
1592: , p0_a4 JTF_VARCHAR2_TABLE_100
1593: , p0_a5 JTF_VARCHAR2_TABLE_300
1594: , p1_a0 JTF_NUMBER_TABLE
1595: , p1_a1 JTF_VARCHAR2_TABLE_100
1596: , p1_a2 JTF_VARCHAR2_TABLE_100

Line 1595: , p1_a1 JTF_VARCHAR2_TABLE_100

1591: , p0_a3 JTF_VARCHAR2_TABLE_100
1592: , p0_a4 JTF_VARCHAR2_TABLE_100
1593: , p0_a5 JTF_VARCHAR2_TABLE_300
1594: , p1_a0 JTF_NUMBER_TABLE
1595: , p1_a1 JTF_VARCHAR2_TABLE_100
1596: , p1_a2 JTF_VARCHAR2_TABLE_100
1597: , p1_a3 JTF_NUMBER_TABLE
1598: , p1_a4 JTF_VARCHAR2_TABLE_100
1599: , p1_a5 JTF_NUMBER_TABLE

Line 1596: , p1_a2 JTF_VARCHAR2_TABLE_100

1592: , p0_a4 JTF_VARCHAR2_TABLE_100
1593: , p0_a5 JTF_VARCHAR2_TABLE_300
1594: , p1_a0 JTF_NUMBER_TABLE
1595: , p1_a1 JTF_VARCHAR2_TABLE_100
1596: , p1_a2 JTF_VARCHAR2_TABLE_100
1597: , p1_a3 JTF_NUMBER_TABLE
1598: , p1_a4 JTF_VARCHAR2_TABLE_100
1599: , p1_a5 JTF_NUMBER_TABLE
1600: , p_include_alternate VARCHAR2

Line 1598: , p1_a4 JTF_VARCHAR2_TABLE_100

1594: , p1_a0 JTF_NUMBER_TABLE
1595: , p1_a1 JTF_VARCHAR2_TABLE_100
1596: , p1_a2 JTF_VARCHAR2_TABLE_100
1597: , p1_a3 JTF_NUMBER_TABLE
1598: , p1_a4 JTF_VARCHAR2_TABLE_100
1599: , p1_a5 JTF_NUMBER_TABLE
1600: , p_include_alternate VARCHAR2
1601: , p3_a0 out nocopy JTF_NUMBER_TABLE
1602: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 1602: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

1598: , p1_a4 JTF_VARCHAR2_TABLE_100
1599: , p1_a5 JTF_NUMBER_TABLE
1600: , p_include_alternate VARCHAR2
1601: , p3_a0 out nocopy JTF_NUMBER_TABLE
1602: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1603: , p3_a2 out nocopy JTF_NUMBER_TABLE
1604: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1606: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1604: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

1600: , p_include_alternate VARCHAR2
1601: , p3_a0 out nocopy JTF_NUMBER_TABLE
1602: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1603: , p3_a2 out nocopy JTF_NUMBER_TABLE
1604: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1606: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1607: , p3_a6 out nocopy JTF_NUMBER_TABLE
1608: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 1605: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

1601: , p3_a0 out nocopy JTF_NUMBER_TABLE
1602: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1603: , p3_a2 out nocopy JTF_NUMBER_TABLE
1604: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1606: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1607: , p3_a6 out nocopy JTF_NUMBER_TABLE
1608: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1609: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1609: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

1605: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1606: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1607: , p3_a6 out nocopy JTF_NUMBER_TABLE
1608: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1609: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1610: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p3_a10 out nocopy JTF_NUMBER_TABLE
1612: , p3_a11 out nocopy JTF_NUMBER_TABLE
1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 1610: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100

1606: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1607: , p3_a6 out nocopy JTF_NUMBER_TABLE
1608: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1609: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1610: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p3_a10 out nocopy JTF_NUMBER_TABLE
1612: , p3_a11 out nocopy JTF_NUMBER_TABLE
1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p3_a13 out nocopy JTF_NUMBER_TABLE

Line 1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

1609: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1610: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p3_a10 out nocopy JTF_NUMBER_TABLE
1612: , p3_a11 out nocopy JTF_NUMBER_TABLE
1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p3_a13 out nocopy JTF_NUMBER_TABLE
1615: , p3_a14 out nocopy JTF_NUMBER_TABLE
1616: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 1616: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

1612: , p3_a11 out nocopy JTF_NUMBER_TABLE
1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p3_a13 out nocopy JTF_NUMBER_TABLE
1615: , p3_a14 out nocopy JTF_NUMBER_TABLE
1616: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1618: , p3_a17 out nocopy JTF_DATE_TABLE
1619: , p3_a18 out nocopy JTF_DATE_TABLE
1620: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 1617: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p3_a13 out nocopy JTF_NUMBER_TABLE
1615: , p3_a14 out nocopy JTF_NUMBER_TABLE
1616: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1618: , p3_a17 out nocopy JTF_DATE_TABLE
1619: , p3_a18 out nocopy JTF_DATE_TABLE
1620: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
1621: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 1620: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100

1616: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1618: , p3_a17 out nocopy JTF_DATE_TABLE
1619: , p3_a18 out nocopy JTF_DATE_TABLE
1620: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
1621: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
1622: , x_return_status out nocopy VARCHAR2
1623: , x_msg_data out nocopy VARCHAR2
1624: , x_msg_count out nocopy NUMBER

Line 1621: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100

1617: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1618: , p3_a17 out nocopy JTF_DATE_TABLE
1619: , p3_a18 out nocopy JTF_DATE_TABLE
1620: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
1621: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
1622: , x_return_status out nocopy VARCHAR2
1623: , x_msg_data out nocopy VARCHAR2
1624: , x_msg_count out nocopy NUMBER
1625: )

Line 1699: , p2_a1 JTF_VARCHAR2_TABLE_100

1695:
1696: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
1697: , p_resource_id NUMBER
1698: , p2_a0 JTF_NUMBER_TABLE
1699: , p2_a1 JTF_VARCHAR2_TABLE_100
1700: , p2_a2 JTF_VARCHAR2_TABLE_100
1701: , p2_a3 JTF_NUMBER_TABLE
1702: , p2_a4 JTF_VARCHAR2_TABLE_100
1703: , p2_a5 JTF_NUMBER_TABLE

Line 1700: , p2_a2 JTF_VARCHAR2_TABLE_100

1696: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
1697: , p_resource_id NUMBER
1698: , p2_a0 JTF_NUMBER_TABLE
1699: , p2_a1 JTF_VARCHAR2_TABLE_100
1700: , p2_a2 JTF_VARCHAR2_TABLE_100
1701: , p2_a3 JTF_NUMBER_TABLE
1702: , p2_a4 JTF_VARCHAR2_TABLE_100
1703: , p2_a5 JTF_NUMBER_TABLE
1704: , p_include_alternate VARCHAR2

Line 1702: , p2_a4 JTF_VARCHAR2_TABLE_100

1698: , p2_a0 JTF_NUMBER_TABLE
1699: , p2_a1 JTF_VARCHAR2_TABLE_100
1700: , p2_a2 JTF_VARCHAR2_TABLE_100
1701: , p2_a3 JTF_NUMBER_TABLE
1702: , p2_a4 JTF_VARCHAR2_TABLE_100
1703: , p2_a5 JTF_NUMBER_TABLE
1704: , p_include_alternate VARCHAR2
1705: , p4_a0 out nocopy JTF_NUMBER_TABLE
1706: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 1706: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

1702: , p2_a4 JTF_VARCHAR2_TABLE_100
1703: , p2_a5 JTF_NUMBER_TABLE
1704: , p_include_alternate VARCHAR2
1705: , p4_a0 out nocopy JTF_NUMBER_TABLE
1706: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1707: , p4_a2 out nocopy JTF_NUMBER_TABLE
1708: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1709: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1710: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1708: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

1704: , p_include_alternate VARCHAR2
1705: , p4_a0 out nocopy JTF_NUMBER_TABLE
1706: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1707: , p4_a2 out nocopy JTF_NUMBER_TABLE
1708: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1709: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1710: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1711: , p4_a6 out nocopy JTF_NUMBER_TABLE
1712: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 1709: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

1705: , p4_a0 out nocopy JTF_NUMBER_TABLE
1706: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1707: , p4_a2 out nocopy JTF_NUMBER_TABLE
1708: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1709: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1710: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1711: , p4_a6 out nocopy JTF_NUMBER_TABLE
1712: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1713: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1713: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

1709: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1710: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1711: , p4_a6 out nocopy JTF_NUMBER_TABLE
1712: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1713: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1714: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1715: , p4_a10 out nocopy JTF_NUMBER_TABLE
1716: , p4_a11 out nocopy JTF_NUMBER_TABLE
1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 1714: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

1710: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1711: , p4_a6 out nocopy JTF_NUMBER_TABLE
1712: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1713: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1714: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1715: , p4_a10 out nocopy JTF_NUMBER_TABLE
1716: , p4_a11 out nocopy JTF_NUMBER_TABLE
1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1718: , p4_a13 out nocopy JTF_NUMBER_TABLE

Line 1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

1713: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1714: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1715: , p4_a10 out nocopy JTF_NUMBER_TABLE
1716: , p4_a11 out nocopy JTF_NUMBER_TABLE
1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1718: , p4_a13 out nocopy JTF_NUMBER_TABLE
1719: , p4_a14 out nocopy JTF_NUMBER_TABLE
1720: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1721: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 1720: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

1716: , p4_a11 out nocopy JTF_NUMBER_TABLE
1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1718: , p4_a13 out nocopy JTF_NUMBER_TABLE
1719: , p4_a14 out nocopy JTF_NUMBER_TABLE
1720: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1721: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1722: , p4_a17 out nocopy JTF_DATE_TABLE
1723: , p4_a18 out nocopy JTF_DATE_TABLE
1724: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 1721: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1718: , p4_a13 out nocopy JTF_NUMBER_TABLE
1719: , p4_a14 out nocopy JTF_NUMBER_TABLE
1720: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1721: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1722: , p4_a17 out nocopy JTF_DATE_TABLE
1723: , p4_a18 out nocopy JTF_DATE_TABLE
1724: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1725: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 1724: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

1720: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1721: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1722: , p4_a17 out nocopy JTF_DATE_TABLE
1723: , p4_a18 out nocopy JTF_DATE_TABLE
1724: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1725: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1726: , x_return_status out nocopy VARCHAR2
1727: , x_msg_data out nocopy VARCHAR2
1728: , x_msg_count out nocopy NUMBER

Line 1725: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

1721: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1722: , p4_a17 out nocopy JTF_DATE_TABLE
1723: , p4_a18 out nocopy JTF_DATE_TABLE
1724: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1725: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1726: , x_return_status out nocopy VARCHAR2
1727: , x_msg_data out nocopy VARCHAR2
1728: , x_msg_count out nocopy NUMBER
1729: )

Line 1798: , p2_a1 JTF_VARCHAR2_TABLE_100

1794:
1795: procedure ws_check_organizations(p_resource_type VARCHAR2
1796: , p_resource_id NUMBER
1797: , p2_a0 JTF_NUMBER_TABLE
1798: , p2_a1 JTF_VARCHAR2_TABLE_100
1799: , p2_a2 JTF_VARCHAR2_TABLE_100
1800: , p2_a3 JTF_NUMBER_TABLE
1801: , p2_a4 JTF_VARCHAR2_TABLE_100
1802: , p2_a5 JTF_NUMBER_TABLE

Line 1799: , p2_a2 JTF_VARCHAR2_TABLE_100

1795: procedure ws_check_organizations(p_resource_type VARCHAR2
1796: , p_resource_id NUMBER
1797: , p2_a0 JTF_NUMBER_TABLE
1798: , p2_a1 JTF_VARCHAR2_TABLE_100
1799: , p2_a2 JTF_VARCHAR2_TABLE_100
1800: , p2_a3 JTF_NUMBER_TABLE
1801: , p2_a4 JTF_VARCHAR2_TABLE_100
1802: , p2_a5 JTF_NUMBER_TABLE
1803: , p_include_alternate VARCHAR2

Line 1801: , p2_a4 JTF_VARCHAR2_TABLE_100

1797: , p2_a0 JTF_NUMBER_TABLE
1798: , p2_a1 JTF_VARCHAR2_TABLE_100
1799: , p2_a2 JTF_VARCHAR2_TABLE_100
1800: , p2_a3 JTF_NUMBER_TABLE
1801: , p2_a4 JTF_VARCHAR2_TABLE_100
1802: , p2_a5 JTF_NUMBER_TABLE
1803: , p_include_alternate VARCHAR2
1804: , p4_a0 out nocopy JTF_NUMBER_TABLE
1805: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 1805: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

1801: , p2_a4 JTF_VARCHAR2_TABLE_100
1802: , p2_a5 JTF_NUMBER_TABLE
1803: , p_include_alternate VARCHAR2
1804: , p4_a0 out nocopy JTF_NUMBER_TABLE
1805: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1806: , p4_a2 out nocopy JTF_NUMBER_TABLE
1807: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1808: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1809: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1807: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

1803: , p_include_alternate VARCHAR2
1804: , p4_a0 out nocopy JTF_NUMBER_TABLE
1805: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1806: , p4_a2 out nocopy JTF_NUMBER_TABLE
1807: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1808: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1809: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1810: , p4_a6 out nocopy JTF_NUMBER_TABLE
1811: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 1808: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

1804: , p4_a0 out nocopy JTF_NUMBER_TABLE
1805: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1806: , p4_a2 out nocopy JTF_NUMBER_TABLE
1807: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1808: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1809: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1810: , p4_a6 out nocopy JTF_NUMBER_TABLE
1811: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1812: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1812: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

1808: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1809: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1810: , p4_a6 out nocopy JTF_NUMBER_TABLE
1811: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1812: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1813: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1814: , p4_a10 out nocopy JTF_NUMBER_TABLE
1815: , p4_a11 out nocopy JTF_NUMBER_TABLE
1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 1813: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

1809: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1810: , p4_a6 out nocopy JTF_NUMBER_TABLE
1811: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1812: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1813: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1814: , p4_a10 out nocopy JTF_NUMBER_TABLE
1815: , p4_a11 out nocopy JTF_NUMBER_TABLE
1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1817: , p4_a13 out nocopy JTF_NUMBER_TABLE

Line 1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

1812: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1813: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1814: , p4_a10 out nocopy JTF_NUMBER_TABLE
1815: , p4_a11 out nocopy JTF_NUMBER_TABLE
1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1817: , p4_a13 out nocopy JTF_NUMBER_TABLE
1818: , p4_a14 out nocopy JTF_NUMBER_TABLE
1819: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1820: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 1819: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

1815: , p4_a11 out nocopy JTF_NUMBER_TABLE
1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1817: , p4_a13 out nocopy JTF_NUMBER_TABLE
1818: , p4_a14 out nocopy JTF_NUMBER_TABLE
1819: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1820: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1821: , p4_a17 out nocopy JTF_DATE_TABLE
1822: , p4_a18 out nocopy JTF_DATE_TABLE
1823: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 1820: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1817: , p4_a13 out nocopy JTF_NUMBER_TABLE
1818: , p4_a14 out nocopy JTF_NUMBER_TABLE
1819: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1820: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1821: , p4_a17 out nocopy JTF_DATE_TABLE
1822: , p4_a18 out nocopy JTF_DATE_TABLE
1823: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1824: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 1823: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

1819: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1820: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1821: , p4_a17 out nocopy JTF_DATE_TABLE
1822: , p4_a18 out nocopy JTF_DATE_TABLE
1823: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1824: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1825: , x_return_status out nocopy VARCHAR2
1826: , x_msg_data out nocopy VARCHAR2
1827: , x_msg_count out nocopy NUMBER

Line 1824: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

1820: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1821: , p4_a17 out nocopy JTF_DATE_TABLE
1822: , p4_a18 out nocopy JTF_DATE_TABLE
1823: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1824: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1825: , x_return_status out nocopy VARCHAR2
1826: , x_msg_data out nocopy VARCHAR2
1827: , x_msg_count out nocopy NUMBER
1828: )

Line 1902: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1898: , p0_a4 VARCHAR2
1899: , p0_a5 NUMBER
1900: , p_org_id NUMBER
1901: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1902: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1903: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1904: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1905: , p2_a4 in out nocopy JTF_NUMBER_TABLE
1906: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1903: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100

1899: , p0_a5 NUMBER
1900: , p_org_id NUMBER
1901: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1902: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1903: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1904: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1905: , p2_a4 in out nocopy JTF_NUMBER_TABLE
1906: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1907: , p2_a6 in out nocopy JTF_NUMBER_TABLE

Line 1906: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1902: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1903: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1904: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1905: , p2_a4 in out nocopy JTF_NUMBER_TABLE
1906: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1907: , p2_a6 in out nocopy JTF_NUMBER_TABLE
1908: , p2_a7 in out nocopy JTF_NUMBER_TABLE
1909: , x_return_status out nocopy VARCHAR2
1910: , x_msg_data out nocopy VARCHAR2