14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_VARCHAR2_TABLE_100
39: , a23 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_VARCHAR2_TABLE_100
39: , a23 JTF_NUMBER_TABLE
40: ) as
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_VARCHAR2_TABLE_100
39: , a23 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_VARCHAR2_TABLE_100
39: , a23 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
42: begin
79: end if;
80: end rosetta_table_copy_in_p1;
81: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_NUMBER_TABLE
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_NUMBER_TABLE
86: , a5 out nocopy JTF_NUMBER_TABLE
87: , a6 out nocopy JTF_NUMBER_TABLE
80: end rosetta_table_copy_in_p1;
81: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_NUMBER_TABLE
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_NUMBER_TABLE
86: , a5 out nocopy JTF_NUMBER_TABLE
87: , a6 out nocopy JTF_NUMBER_TABLE
88: , a7 out nocopy JTF_NUMBER_TABLE
89: , a8 out nocopy JTF_DATE_TABLE
90: , a9 out nocopy JTF_DATE_TABLE
91: , a10 out nocopy JTF_DATE_TABLE
92: , a11 out nocopy JTF_DATE_TABLE
93: , a12 out nocopy JTF_VARCHAR2_TABLE_100
94: , a13 out nocopy JTF_VARCHAR2_TABLE_100
95: , a14 out nocopy JTF_NUMBER_TABLE
96: , a15 out nocopy JTF_NUMBER_TABLE
97: , a16 out nocopy JTF_NUMBER_TABLE
90: , a9 out nocopy JTF_DATE_TABLE
91: , a10 out nocopy JTF_DATE_TABLE
92: , a11 out nocopy JTF_DATE_TABLE
93: , a12 out nocopy JTF_VARCHAR2_TABLE_100
94: , a13 out nocopy JTF_VARCHAR2_TABLE_100
95: , a14 out nocopy JTF_NUMBER_TABLE
96: , a15 out nocopy JTF_NUMBER_TABLE
97: , a16 out nocopy JTF_NUMBER_TABLE
98: , a17 out nocopy JTF_VARCHAR2_TABLE_100
94: , a13 out nocopy JTF_VARCHAR2_TABLE_100
95: , a14 out nocopy JTF_NUMBER_TABLE
96: , a15 out nocopy JTF_NUMBER_TABLE
97: , a16 out nocopy JTF_NUMBER_TABLE
98: , a17 out nocopy JTF_VARCHAR2_TABLE_100
99: , a18 out nocopy JTF_NUMBER_TABLE
100: , a19 out nocopy JTF_VARCHAR2_TABLE_100
101: , a20 out nocopy JTF_VARCHAR2_TABLE_100
102: , a21 out nocopy JTF_VARCHAR2_TABLE_100
96: , a15 out nocopy JTF_NUMBER_TABLE
97: , a16 out nocopy JTF_NUMBER_TABLE
98: , a17 out nocopy JTF_VARCHAR2_TABLE_100
99: , a18 out nocopy JTF_NUMBER_TABLE
100: , a19 out nocopy JTF_VARCHAR2_TABLE_100
101: , a20 out nocopy JTF_VARCHAR2_TABLE_100
102: , a21 out nocopy JTF_VARCHAR2_TABLE_100
103: , a22 out nocopy JTF_VARCHAR2_TABLE_100
104: , a23 out nocopy JTF_NUMBER_TABLE
97: , a16 out nocopy JTF_NUMBER_TABLE
98: , a17 out nocopy JTF_VARCHAR2_TABLE_100
99: , a18 out nocopy JTF_NUMBER_TABLE
100: , a19 out nocopy JTF_VARCHAR2_TABLE_100
101: , a20 out nocopy JTF_VARCHAR2_TABLE_100
102: , a21 out nocopy JTF_VARCHAR2_TABLE_100
103: , a22 out nocopy JTF_VARCHAR2_TABLE_100
104: , a23 out nocopy JTF_NUMBER_TABLE
105: ) as
98: , a17 out nocopy JTF_VARCHAR2_TABLE_100
99: , a18 out nocopy JTF_NUMBER_TABLE
100: , a19 out nocopy JTF_VARCHAR2_TABLE_100
101: , a20 out nocopy JTF_VARCHAR2_TABLE_100
102: , a21 out nocopy JTF_VARCHAR2_TABLE_100
103: , a22 out nocopy JTF_VARCHAR2_TABLE_100
104: , a23 out nocopy JTF_NUMBER_TABLE
105: ) as
106: ddindx binary_integer; indx binary_integer;
99: , a18 out nocopy JTF_NUMBER_TABLE
100: , a19 out nocopy JTF_VARCHAR2_TABLE_100
101: , a20 out nocopy JTF_VARCHAR2_TABLE_100
102: , a21 out nocopy JTF_VARCHAR2_TABLE_100
103: , a22 out nocopy JTF_VARCHAR2_TABLE_100
104: , a23 out nocopy JTF_NUMBER_TABLE
105: ) as
106: ddindx binary_integer; indx binary_integer;
107: begin
107: begin
108: if t is null or t.count = 0 then
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_100();
112: a3 := JTF_VARCHAR2_TABLE_100();
113: a4 := JTF_NUMBER_TABLE();
114: a5 := JTF_NUMBER_TABLE();
115: a6 := JTF_NUMBER_TABLE();
108: if t is null or t.count = 0 then
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_100();
112: a3 := JTF_VARCHAR2_TABLE_100();
113: a4 := JTF_NUMBER_TABLE();
114: a5 := JTF_NUMBER_TABLE();
115: a6 := JTF_NUMBER_TABLE();
116: a7 := JTF_NUMBER_TABLE();
117: a8 := JTF_DATE_TABLE();
118: a9 := JTF_DATE_TABLE();
119: a10 := JTF_DATE_TABLE();
120: a11 := JTF_DATE_TABLE();
121: a12 := JTF_VARCHAR2_TABLE_100();
122: a13 := JTF_VARCHAR2_TABLE_100();
123: a14 := JTF_NUMBER_TABLE();
124: a15 := JTF_NUMBER_TABLE();
125: a16 := JTF_NUMBER_TABLE();
118: a9 := JTF_DATE_TABLE();
119: a10 := JTF_DATE_TABLE();
120: a11 := JTF_DATE_TABLE();
121: a12 := JTF_VARCHAR2_TABLE_100();
122: a13 := JTF_VARCHAR2_TABLE_100();
123: a14 := JTF_NUMBER_TABLE();
124: a15 := JTF_NUMBER_TABLE();
125: a16 := JTF_NUMBER_TABLE();
126: a17 := JTF_VARCHAR2_TABLE_100();
122: a13 := JTF_VARCHAR2_TABLE_100();
123: a14 := JTF_NUMBER_TABLE();
124: a15 := JTF_NUMBER_TABLE();
125: a16 := JTF_NUMBER_TABLE();
126: a17 := JTF_VARCHAR2_TABLE_100();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();
129: a20 := JTF_VARCHAR2_TABLE_100();
130: a21 := JTF_VARCHAR2_TABLE_100();
124: a15 := JTF_NUMBER_TABLE();
125: a16 := JTF_NUMBER_TABLE();
126: a17 := JTF_VARCHAR2_TABLE_100();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();
129: a20 := JTF_VARCHAR2_TABLE_100();
130: a21 := JTF_VARCHAR2_TABLE_100();
131: a22 := JTF_VARCHAR2_TABLE_100();
132: a23 := JTF_NUMBER_TABLE();
125: a16 := JTF_NUMBER_TABLE();
126: a17 := JTF_VARCHAR2_TABLE_100();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();
129: a20 := JTF_VARCHAR2_TABLE_100();
130: a21 := JTF_VARCHAR2_TABLE_100();
131: a22 := JTF_VARCHAR2_TABLE_100();
132: a23 := JTF_NUMBER_TABLE();
133: else
126: a17 := JTF_VARCHAR2_TABLE_100();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();
129: a20 := JTF_VARCHAR2_TABLE_100();
130: a21 := JTF_VARCHAR2_TABLE_100();
131: a22 := JTF_VARCHAR2_TABLE_100();
132: a23 := JTF_NUMBER_TABLE();
133: else
134: a0 := JTF_NUMBER_TABLE();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();
129: a20 := JTF_VARCHAR2_TABLE_100();
130: a21 := JTF_VARCHAR2_TABLE_100();
131: a22 := JTF_VARCHAR2_TABLE_100();
132: a23 := JTF_NUMBER_TABLE();
133: else
134: a0 := JTF_NUMBER_TABLE();
135: a1 := JTF_NUMBER_TABLE();
132: a23 := JTF_NUMBER_TABLE();
133: else
134: a0 := JTF_NUMBER_TABLE();
135: a1 := JTF_NUMBER_TABLE();
136: a2 := JTF_VARCHAR2_TABLE_100();
137: a3 := JTF_VARCHAR2_TABLE_100();
138: a4 := JTF_NUMBER_TABLE();
139: a5 := JTF_NUMBER_TABLE();
140: a6 := JTF_NUMBER_TABLE();
133: else
134: a0 := JTF_NUMBER_TABLE();
135: a1 := JTF_NUMBER_TABLE();
136: a2 := JTF_VARCHAR2_TABLE_100();
137: a3 := JTF_VARCHAR2_TABLE_100();
138: a4 := JTF_NUMBER_TABLE();
139: a5 := JTF_NUMBER_TABLE();
140: a6 := JTF_NUMBER_TABLE();
141: a7 := JTF_NUMBER_TABLE();
142: a8 := JTF_DATE_TABLE();
143: a9 := JTF_DATE_TABLE();
144: a10 := JTF_DATE_TABLE();
145: a11 := JTF_DATE_TABLE();
146: a12 := JTF_VARCHAR2_TABLE_100();
147: a13 := JTF_VARCHAR2_TABLE_100();
148: a14 := JTF_NUMBER_TABLE();
149: a15 := JTF_NUMBER_TABLE();
150: a16 := JTF_NUMBER_TABLE();
143: a9 := JTF_DATE_TABLE();
144: a10 := JTF_DATE_TABLE();
145: a11 := JTF_DATE_TABLE();
146: a12 := JTF_VARCHAR2_TABLE_100();
147: a13 := JTF_VARCHAR2_TABLE_100();
148: a14 := JTF_NUMBER_TABLE();
149: a15 := JTF_NUMBER_TABLE();
150: a16 := JTF_NUMBER_TABLE();
151: a17 := JTF_VARCHAR2_TABLE_100();
147: a13 := JTF_VARCHAR2_TABLE_100();
148: a14 := JTF_NUMBER_TABLE();
149: a15 := JTF_NUMBER_TABLE();
150: a16 := JTF_NUMBER_TABLE();
151: a17 := JTF_VARCHAR2_TABLE_100();
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();
154: a20 := JTF_VARCHAR2_TABLE_100();
155: a21 := JTF_VARCHAR2_TABLE_100();
149: a15 := JTF_NUMBER_TABLE();
150: a16 := JTF_NUMBER_TABLE();
151: a17 := JTF_VARCHAR2_TABLE_100();
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();
154: a20 := JTF_VARCHAR2_TABLE_100();
155: a21 := JTF_VARCHAR2_TABLE_100();
156: a22 := JTF_VARCHAR2_TABLE_100();
157: a23 := JTF_NUMBER_TABLE();
150: a16 := JTF_NUMBER_TABLE();
151: a17 := JTF_VARCHAR2_TABLE_100();
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();
154: a20 := JTF_VARCHAR2_TABLE_100();
155: a21 := JTF_VARCHAR2_TABLE_100();
156: a22 := JTF_VARCHAR2_TABLE_100();
157: a23 := JTF_NUMBER_TABLE();
158: if t.count > 0 then
151: a17 := JTF_VARCHAR2_TABLE_100();
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();
154: a20 := JTF_VARCHAR2_TABLE_100();
155: a21 := JTF_VARCHAR2_TABLE_100();
156: a22 := JTF_VARCHAR2_TABLE_100();
157: a23 := JTF_NUMBER_TABLE();
158: if t.count > 0 then
159: a0.extend(t.count);
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();
154: a20 := JTF_VARCHAR2_TABLE_100();
155: a21 := JTF_VARCHAR2_TABLE_100();
156: a22 := JTF_VARCHAR2_TABLE_100();
157: a23 := JTF_NUMBER_TABLE();
158: if t.count > 0 then
159: a0.extend(t.count);
160: a1.extend(t.count);
219:
220: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_NUMBER_TABLE
223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_NUMBER_TABLE
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_NUMBER_TABLE
227: , a7 JTF_VARCHAR2_TABLE_2000
230: , a10 JTF_DATE_TABLE
231: , a11 JTF_DATE_TABLE
232: , a12 JTF_DATE_TABLE
233: , a13 JTF_DATE_TABLE
234: , a14 JTF_VARCHAR2_TABLE_100
235: , a15 JTF_VARCHAR2_TABLE_100
236: ) as
237: ddindx binary_integer; indx binary_integer;
238: begin
231: , a11 JTF_DATE_TABLE
232: , a12 JTF_DATE_TABLE
233: , a13 JTF_DATE_TABLE
234: , a14 JTF_VARCHAR2_TABLE_100
235: , a15 JTF_VARCHAR2_TABLE_100
236: ) as
237: ddindx binary_integer; indx binary_integer;
238: begin
239: if a0 is not null and a0.count > 0 then
268: end rosetta_table_copy_in_p3;
269: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_NUMBER_TABLE
272: , a3 out nocopy JTF_VARCHAR2_TABLE_100
273: , a4 out nocopy JTF_NUMBER_TABLE
274: , a5 out nocopy JTF_NUMBER_TABLE
275: , a6 out nocopy JTF_NUMBER_TABLE
276: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
279: , a10 out nocopy JTF_DATE_TABLE
280: , a11 out nocopy JTF_DATE_TABLE
281: , a12 out nocopy JTF_DATE_TABLE
282: , a13 out nocopy JTF_DATE_TABLE
283: , a14 out nocopy JTF_VARCHAR2_TABLE_100
284: , a15 out nocopy JTF_VARCHAR2_TABLE_100
285: ) as
286: ddindx binary_integer; indx binary_integer;
287: begin
280: , a11 out nocopy JTF_DATE_TABLE
281: , a12 out nocopy JTF_DATE_TABLE
282: , a13 out nocopy JTF_DATE_TABLE
283: , a14 out nocopy JTF_VARCHAR2_TABLE_100
284: , a15 out nocopy JTF_VARCHAR2_TABLE_100
285: ) as
286: ddindx binary_integer; indx binary_integer;
287: begin
288: if t is null or t.count = 0 then
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_NUMBER_TABLE();
296: a7 := JTF_VARCHAR2_TABLE_2000();
299: a10 := JTF_DATE_TABLE();
300: a11 := JTF_DATE_TABLE();
301: a12 := JTF_DATE_TABLE();
302: a13 := JTF_DATE_TABLE();
303: a14 := JTF_VARCHAR2_TABLE_100();
304: a15 := JTF_VARCHAR2_TABLE_100();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
300: a11 := JTF_DATE_TABLE();
301: a12 := JTF_DATE_TABLE();
302: a13 := JTF_DATE_TABLE();
303: a14 := JTF_VARCHAR2_TABLE_100();
304: a15 := JTF_VARCHAR2_TABLE_100();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_NUMBER_TABLE();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_VARCHAR2_TABLE_2000();
316: a10 := JTF_DATE_TABLE();
317: a11 := JTF_DATE_TABLE();
318: a12 := JTF_DATE_TABLE();
319: a13 := JTF_DATE_TABLE();
320: a14 := JTF_VARCHAR2_TABLE_100();
321: a15 := JTF_VARCHAR2_TABLE_100();
322: if t.count > 0 then
323: a0.extend(t.count);
324: a1.extend(t.count);
317: a11 := JTF_DATE_TABLE();
318: a12 := JTF_DATE_TABLE();
319: a13 := JTF_DATE_TABLE();
320: a14 := JTF_VARCHAR2_TABLE_100();
321: a15 := JTF_VARCHAR2_TABLE_100();
322: if t.count > 0 then
323: a0.extend(t.count);
324: a1.extend(t.count);
325: a2.extend(t.count);
366: end rosetta_table_copy_out_p3;
367:
368: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
369: , a1 JTF_NUMBER_TABLE
370: , a2 JTF_VARCHAR2_TABLE_100
371: , a3 JTF_VARCHAR2_TABLE_100
372: , a4 JTF_NUMBER_TABLE
373: , a5 JTF_NUMBER_TABLE
374: , a6 JTF_VARCHAR2_TABLE_100
367:
368: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
369: , a1 JTF_NUMBER_TABLE
370: , a2 JTF_VARCHAR2_TABLE_100
371: , a3 JTF_VARCHAR2_TABLE_100
372: , a4 JTF_NUMBER_TABLE
373: , a5 JTF_NUMBER_TABLE
374: , a6 JTF_VARCHAR2_TABLE_100
375: , a7 JTF_VARCHAR2_TABLE_200
370: , a2 JTF_VARCHAR2_TABLE_100
371: , a3 JTF_VARCHAR2_TABLE_100
372: , a4 JTF_NUMBER_TABLE
373: , a5 JTF_NUMBER_TABLE
374: , a6 JTF_VARCHAR2_TABLE_100
375: , a7 JTF_VARCHAR2_TABLE_200
376: , a8 JTF_NUMBER_TABLE
377: , a9 JTF_NUMBER_TABLE
378: , a10 JTF_NUMBER_TABLE
407: end if;
408: end rosetta_table_copy_in_p7;
409: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
410: , a1 out nocopy JTF_NUMBER_TABLE
411: , a2 out nocopy JTF_VARCHAR2_TABLE_100
412: , a3 out nocopy JTF_VARCHAR2_TABLE_100
413: , a4 out nocopy JTF_NUMBER_TABLE
414: , a5 out nocopy JTF_NUMBER_TABLE
415: , a6 out nocopy JTF_VARCHAR2_TABLE_100
408: end rosetta_table_copy_in_p7;
409: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
410: , a1 out nocopy JTF_NUMBER_TABLE
411: , a2 out nocopy JTF_VARCHAR2_TABLE_100
412: , a3 out nocopy JTF_VARCHAR2_TABLE_100
413: , a4 out nocopy JTF_NUMBER_TABLE
414: , a5 out nocopy JTF_NUMBER_TABLE
415: , a6 out nocopy JTF_VARCHAR2_TABLE_100
416: , a7 out nocopy JTF_VARCHAR2_TABLE_200
411: , a2 out nocopy JTF_VARCHAR2_TABLE_100
412: , a3 out nocopy JTF_VARCHAR2_TABLE_100
413: , a4 out nocopy JTF_NUMBER_TABLE
414: , a5 out nocopy JTF_NUMBER_TABLE
415: , a6 out nocopy JTF_VARCHAR2_TABLE_100
416: , a7 out nocopy JTF_VARCHAR2_TABLE_200
417: , a8 out nocopy JTF_NUMBER_TABLE
418: , a9 out nocopy JTF_NUMBER_TABLE
419: , a10 out nocopy JTF_NUMBER_TABLE
423: begin
424: if t is null or t.count = 0 then
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_NUMBER_TABLE();
427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();
424: if t is null or t.count = 0 then
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_NUMBER_TABLE();
427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();
432: a7 := JTF_VARCHAR2_TABLE_200();
427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();
432: a7 := JTF_VARCHAR2_TABLE_200();
433: a8 := JTF_NUMBER_TABLE();
434: a9 := JTF_NUMBER_TABLE();
435: a10 := JTF_NUMBER_TABLE();
436: a11 := JTF_DATE_TABLE();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: a3 := JTF_VARCHAR2_TABLE_100();
442: a4 := JTF_NUMBER_TABLE();
443: a5 := JTF_NUMBER_TABLE();
444: a6 := JTF_VARCHAR2_TABLE_100();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: a3 := JTF_VARCHAR2_TABLE_100();
442: a4 := JTF_NUMBER_TABLE();
443: a5 := JTF_NUMBER_TABLE();
444: a6 := JTF_VARCHAR2_TABLE_100();
445: a7 := JTF_VARCHAR2_TABLE_200();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: a3 := JTF_VARCHAR2_TABLE_100();
442: a4 := JTF_NUMBER_TABLE();
443: a5 := JTF_NUMBER_TABLE();
444: a6 := JTF_VARCHAR2_TABLE_100();
445: a7 := JTF_VARCHAR2_TABLE_200();
446: a8 := JTF_NUMBER_TABLE();
447: a9 := JTF_NUMBER_TABLE();
448: a10 := JTF_NUMBER_TABLE();
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_NUMBER_TABLE
494: , a6 JTF_VARCHAR2_TABLE_100
495: , a7 JTF_NUMBER_TABLE
496: ) as
497: ddindx binary_integer; indx binary_integer;
498: begin
523: , a2 out nocopy JTF_NUMBER_TABLE
524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE
526: , a5 out nocopy JTF_NUMBER_TABLE
527: , a6 out nocopy JTF_VARCHAR2_TABLE_100
528: , a7 out nocopy JTF_NUMBER_TABLE
529: ) as
530: ddindx binary_integer; indx binary_integer;
531: begin
535: a2 := JTF_NUMBER_TABLE();
536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();
538: a5 := JTF_NUMBER_TABLE();
539: a6 := JTF_VARCHAR2_TABLE_100();
540: a7 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_NUMBER_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: a4 := JTF_NUMBER_TABLE();
547: a5 := JTF_NUMBER_TABLE();
548: a6 := JTF_VARCHAR2_TABLE_100();
549: a7 := JTF_NUMBER_TABLE();
550: if t.count > 0 then
551: a0.extend(t.count);
552: a1.extend(t.count);
618: end if;
619: end rosetta_table_copy_out_p10;
620:
621: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
622: , a1 JTF_VARCHAR2_TABLE_100
623: , a2 JTF_NUMBER_TABLE
624: , a3 JTF_NUMBER_TABLE
625: , a4 JTF_NUMBER_TABLE
626: , a5 JTF_NUMBER_TABLE
623: , a2 JTF_NUMBER_TABLE
624: , a3 JTF_NUMBER_TABLE
625: , a4 JTF_NUMBER_TABLE
626: , a5 JTF_NUMBER_TABLE
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
629: , a8 JTF_NUMBER_TABLE
630: , a9 JTF_NUMBER_TABLE
631: , a10 JTF_NUMBER_TABLE
628: , a7 JTF_NUMBER_TABLE
629: , a8 JTF_NUMBER_TABLE
630: , a9 JTF_NUMBER_TABLE
631: , a10 JTF_NUMBER_TABLE
632: , a11 JTF_VARCHAR2_TABLE_100
633: , a12 JTF_NUMBER_TABLE
634: , a13 JTF_NUMBER_TABLE
635: ) as
636: ddindx binary_integer; indx binary_integer;
663: end if;
664: end if;
665: end rosetta_table_copy_in_p18;
666: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
667: , a1 out nocopy JTF_VARCHAR2_TABLE_100
668: , a2 out nocopy JTF_NUMBER_TABLE
669: , a3 out nocopy JTF_NUMBER_TABLE
670: , a4 out nocopy JTF_NUMBER_TABLE
671: , a5 out nocopy JTF_NUMBER_TABLE
668: , a2 out nocopy JTF_NUMBER_TABLE
669: , a3 out nocopy JTF_NUMBER_TABLE
670: , a4 out nocopy JTF_NUMBER_TABLE
671: , a5 out nocopy JTF_NUMBER_TABLE
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE
674: , a8 out nocopy JTF_NUMBER_TABLE
675: , a9 out nocopy JTF_NUMBER_TABLE
676: , a10 out nocopy JTF_NUMBER_TABLE
673: , a7 out nocopy JTF_NUMBER_TABLE
674: , a8 out nocopy JTF_NUMBER_TABLE
675: , a9 out nocopy JTF_NUMBER_TABLE
676: , a10 out nocopy JTF_NUMBER_TABLE
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
678: , a12 out nocopy JTF_NUMBER_TABLE
679: , a13 out nocopy JTF_NUMBER_TABLE
680: ) as
681: ddindx binary_integer; indx binary_integer;
681: ddindx binary_integer; indx binary_integer;
682: begin
683: if t is null or t.count = 0 then
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_VARCHAR2_TABLE_100();
686: a2 := JTF_NUMBER_TABLE();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_NUMBER_TABLE();
689: a5 := JTF_NUMBER_TABLE();
686: a2 := JTF_NUMBER_TABLE();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_NUMBER_TABLE();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_NUMBER_TABLE();
693: a9 := JTF_NUMBER_TABLE();
694: a10 := JTF_NUMBER_TABLE();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_NUMBER_TABLE();
693: a9 := JTF_NUMBER_TABLE();
694: a10 := JTF_NUMBER_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_NUMBER_TABLE();
697: a13 := JTF_NUMBER_TABLE();
698: else
699: a0 := JTF_NUMBER_TABLE();
696: a12 := JTF_NUMBER_TABLE();
697: a13 := JTF_NUMBER_TABLE();
698: else
699: a0 := JTF_NUMBER_TABLE();
700: a1 := JTF_VARCHAR2_TABLE_100();
701: a2 := JTF_NUMBER_TABLE();
702: a3 := JTF_NUMBER_TABLE();
703: a4 := JTF_NUMBER_TABLE();
704: a5 := JTF_NUMBER_TABLE();
701: a2 := JTF_NUMBER_TABLE();
702: a3 := JTF_NUMBER_TABLE();
703: a4 := JTF_NUMBER_TABLE();
704: a5 := JTF_NUMBER_TABLE();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := JTF_NUMBER_TABLE();
708: a9 := JTF_NUMBER_TABLE();
709: a10 := JTF_NUMBER_TABLE();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := JTF_NUMBER_TABLE();
708: a9 := JTF_NUMBER_TABLE();
709: a10 := JTF_NUMBER_TABLE();
710: a11 := JTF_VARCHAR2_TABLE_100();
711: a12 := JTF_NUMBER_TABLE();
712: a13 := JTF_NUMBER_TABLE();
713: if t.count > 0 then
714: a0.extend(t.count);
996: , x_msg_data out nocopy VARCHAR2
997: , p3_a0 in out nocopy JTF_NUMBER_TABLE
998: , p3_a1 in out nocopy JTF_NUMBER_TABLE
999: , p3_a2 in out nocopy JTF_NUMBER_TABLE
1000: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1001: , p3_a4 in out nocopy JTF_NUMBER_TABLE
1002: , p3_a5 in out nocopy JTF_NUMBER_TABLE
1003: , p3_a6 in out nocopy JTF_NUMBER_TABLE
1004: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1007: , p3_a10 in out nocopy JTF_DATE_TABLE
1008: , p3_a11 in out nocopy JTF_DATE_TABLE
1009: , p3_a12 in out nocopy JTF_DATE_TABLE
1010: , p3_a13 in out nocopy JTF_DATE_TABLE
1011: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1012: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1013: )
1014:
1015: as
1008: , p3_a11 in out nocopy JTF_DATE_TABLE
1009: , p3_a12 in out nocopy JTF_DATE_TABLE
1010: , p3_a13 in out nocopy JTF_DATE_TABLE
1011: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1012: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1013: )
1014:
1015: as
1016: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;
1071: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
1072: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1073: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1074: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1075: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1076: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1077: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1078: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1079: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1082: , p1_a10 in out nocopy JTF_DATE_TABLE
1083: , p1_a11 in out nocopy JTF_DATE_TABLE
1084: , p1_a12 in out nocopy JTF_DATE_TABLE
1085: , p1_a13 in out nocopy JTF_DATE_TABLE
1086: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1087: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1088: )
1089:
1090: as
1083: , p1_a11 in out nocopy JTF_DATE_TABLE
1084: , p1_a12 in out nocopy JTF_DATE_TABLE
1085: , p1_a13 in out nocopy JTF_DATE_TABLE
1086: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1087: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1088: )
1089:
1090: as
1091: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;
1179: , p3_a2 out nocopy JTF_NUMBER_TABLE
1180: , p3_a3 out nocopy JTF_NUMBER_TABLE
1181: , p3_a4 out nocopy JTF_NUMBER_TABLE
1182: , p3_a5 out nocopy JTF_NUMBER_TABLE
1183: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p3_a7 out nocopy JTF_NUMBER_TABLE
1185: ) return varchar2
1186:
1187: as
1237: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1238: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1239: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1240: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1241: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1242: , p1_a7 in out nocopy JTF_NUMBER_TABLE
1243: , p_actual_end_date date
1244: , x_msg_count out nocopy VARCHAR2
1245: , x_msg_data out nocopy VARCHAR2
1314: , p3_a2 out nocopy JTF_NUMBER_TABLE
1315: , p3_a3 out nocopy JTF_NUMBER_TABLE
1316: , p3_a4 out nocopy JTF_NUMBER_TABLE
1317: , p3_a5 out nocopy JTF_NUMBER_TABLE
1318: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p3_a7 out nocopy JTF_NUMBER_TABLE
1320: ) return varchar2
1321:
1322: as
1363: , p3_a2 JTF_NUMBER_TABLE
1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE
1366: , p3_a5 JTF_NUMBER_TABLE
1367: , p3_a6 JTF_VARCHAR2_TABLE_100
1368: , p3_a7 JTF_NUMBER_TABLE
1369: , p_dml_flag VARCHAR2
1370: , x_msg_count out nocopy VARCHAR2
1371: , x_msg_data out nocopy VARCHAR2