12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
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
13: return d;
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
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
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
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
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
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
34: , a18 JTF_NUMBER_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
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
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
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 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
38: , a22 JTF_VARCHAR2_TABLE_100
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
43: if a0 is not null and a0.count > 0 then
77: end loop;
78: end if;
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
78: end if;
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
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
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
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
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
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
99: , a18 out nocopy JTF_NUMBER_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
99: , a18 out nocopy JTF_NUMBER_TABLE
100: , a19 out nocopy JTF_VARCHAR2_TABLE_100
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
99: , a18 out nocopy JTF_NUMBER_TABLE
100: , a19 out nocopy JTF_VARCHAR2_TABLE_100
101: , a20 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
103: , a22 out nocopy JTF_VARCHAR2_TABLE_100
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
108: if t is null or t.count = 0 then
105: ) as
106: ddindx binary_integer; indx binary_integer;
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();
106: ddindx binary_integer; indx binary_integer;
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();
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();
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();
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();
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();
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();
127: a18 := JTF_NUMBER_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();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();
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();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();
129: a20 := 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();
131: a22 := JTF_VARCHAR2_TABLE_100();
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();
136: a2 := 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();
136: a2 := JTF_VARCHAR2_TABLE_100();
137: a3 := JTF_VARCHAR2_TABLE_100();
138: a4 := JTF_NUMBER_TABLE();
131: a22 := JTF_VARCHAR2_TABLE_100();
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();
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();
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();
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();
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();
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();
152: a18 := JTF_NUMBER_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();
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();
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();
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();
154: a20 := 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();
156: a22 := JTF_VARCHAR2_TABLE_100();
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);
161: a2.extend(t.count);
216: end if;
217: end if;
218: end rosetta_table_copy_out_p1;
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
217: end if;
218: end rosetta_table_copy_out_p1;
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
218: end rosetta_table_copy_out_p1;
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
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
228: , a8 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
228: , a8 JTF_NUMBER_TABLE
229: , a9 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
228: , a8 JTF_NUMBER_TABLE
229: , a9 JTF_NUMBER_TABLE
230: , a10 JTF_DATE_TABLE
224: , a4 JTF_NUMBER_TABLE
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_NUMBER_TABLE
227: , a7 JTF_VARCHAR2_TABLE_2000
228: , a8 JTF_NUMBER_TABLE
229: , a9 JTF_NUMBER_TABLE
230: , a10 JTF_DATE_TABLE
231: , a11 JTF_DATE_TABLE
232: , a12 JTF_DATE_TABLE
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_NUMBER_TABLE
227: , a7 JTF_VARCHAR2_TABLE_2000
228: , a8 JTF_NUMBER_TABLE
229: , a9 JTF_NUMBER_TABLE
230: , a10 JTF_DATE_TABLE
231: , a11 JTF_DATE_TABLE
232: , a12 JTF_DATE_TABLE
233: , a13 JTF_DATE_TABLE
265: end loop;
266: end if;
267: end if;
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
266: end if;
267: end if;
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
267: end if;
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
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
277: , a8 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
277: , a8 out nocopy JTF_NUMBER_TABLE
278: , a9 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
277: , a8 out nocopy JTF_NUMBER_TABLE
278: , a9 out nocopy JTF_NUMBER_TABLE
279: , a10 out nocopy JTF_DATE_TABLE
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
277: , a8 out nocopy JTF_NUMBER_TABLE
278: , a9 out nocopy JTF_NUMBER_TABLE
279: , a10 out nocopy JTF_DATE_TABLE
280: , a11 out nocopy JTF_DATE_TABLE
281: , a12 out nocopy JTF_DATE_TABLE
274: , a5 out nocopy JTF_NUMBER_TABLE
275: , a6 out nocopy JTF_NUMBER_TABLE
276: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
277: , a8 out nocopy JTF_NUMBER_TABLE
278: , a9 out nocopy JTF_NUMBER_TABLE
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
285: ) as
286: ddindx binary_integer; indx binary_integer;
287: begin
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();
286: ddindx binary_integer; indx binary_integer;
287: begin
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();
287: begin
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();
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();
297: a8 := 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();
297: a8 := JTF_NUMBER_TABLE();
298: a9 := 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();
297: a8 := JTF_NUMBER_TABLE();
298: a9 := JTF_NUMBER_TABLE();
299: a10 := JTF_DATE_TABLE();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_NUMBER_TABLE();
296: a7 := JTF_VARCHAR2_TABLE_2000();
297: a8 := JTF_NUMBER_TABLE();
298: a9 := JTF_NUMBER_TABLE();
299: a10 := JTF_DATE_TABLE();
300: a11 := JTF_DATE_TABLE();
301: a12 := JTF_DATE_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_NUMBER_TABLE();
296: a7 := JTF_VARCHAR2_TABLE_2000();
297: a8 := JTF_NUMBER_TABLE();
298: a9 := JTF_NUMBER_TABLE();
299: a10 := JTF_DATE_TABLE();
300: a11 := JTF_DATE_TABLE();
301: a12 := JTF_DATE_TABLE();
302: a13 := 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();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_NUMBER_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();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_NUMBER_TABLE();
311: a5 := JTF_NUMBER_TABLE();
304: a15 := JTF_VARCHAR2_TABLE_100();
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();
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();
314: a8 := 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();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := 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();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_NUMBER_TABLE();
316: a10 := JTF_DATE_TABLE();
310: a4 := JTF_NUMBER_TABLE();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_VARCHAR2_TABLE_2000();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_NUMBER_TABLE();
316: a10 := JTF_DATE_TABLE();
317: a11 := JTF_DATE_TABLE();
318: a12 := JTF_DATE_TABLE();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_VARCHAR2_TABLE_2000();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_NUMBER_TABLE();
316: a10 := JTF_DATE_TABLE();
317: a11 := JTF_DATE_TABLE();
318: a12 := JTF_DATE_TABLE();
319: a13 := JTF_DATE_TABLE();
364: end if;
365: end if;
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
365: end if;
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
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
376: , a8 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
376: , a8 JTF_NUMBER_TABLE
377: , a9 JTF_NUMBER_TABLE
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
379: , a11 JTF_DATE_TABLE
380: ) as
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
379: , a11 JTF_DATE_TABLE
380: ) as
381: ddindx binary_integer; indx binary_integer;
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
379: , a11 JTF_DATE_TABLE
380: ) as
381: ddindx binary_integer; indx binary_integer;
382: begin
405: end loop;
406: end if;
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
406: end if;
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
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
417: , a8 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
417: , a8 out nocopy JTF_NUMBER_TABLE
418: , a9 out nocopy JTF_NUMBER_TABLE
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
420: , a11 out nocopy JTF_DATE_TABLE
421: ) as
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
420: , a11 out nocopy JTF_DATE_TABLE
421: ) as
422: ddindx binary_integer; indx binary_integer;
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
420: , a11 out nocopy JTF_DATE_TABLE
421: ) as
422: ddindx binary_integer; indx binary_integer;
423: begin
421: ) as
422: ddindx binary_integer; indx binary_integer;
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();
422: ddindx binary_integer; indx binary_integer;
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();
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();
433: a8 := 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();
433: a8 := JTF_NUMBER_TABLE();
434: a9 := JTF_NUMBER_TABLE();
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
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();
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();
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();
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();
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();
446: a8 := 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();
446: a8 := JTF_NUMBER_TABLE();
447: a9 := JTF_NUMBER_TABLE();
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();
449: a11 := JTF_DATE_TABLE();
450: if t.count > 0 then
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();
449: a11 := JTF_DATE_TABLE();
450: if t.count > 0 then
451: a0.extend(t.count);
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();
449: a11 := JTF_DATE_TABLE();
450: if t.count > 0 then
451: a0.extend(t.count);
452: a1.extend(t.count);
484: end if;
485: end if;
486: end rosetta_table_copy_out_p7;
487:
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE
485: end if;
486: end rosetta_table_copy_out_p7;
487:
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_NUMBER_TABLE
486: end rosetta_table_copy_out_p7;
487:
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 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
487:
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 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
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 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
489: , a1 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;
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
499: if a0 is not null and a0.count > 0 then
517: end loop;
518: end if;
519: end if;
520: end rosetta_table_copy_in_p9;
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
523: , a2 out nocopy JTF_NUMBER_TABLE
524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE
518: end if;
519: end if;
520: end rosetta_table_copy_in_p9;
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
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
519: end if;
520: end rosetta_table_copy_in_p9;
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
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
520: end rosetta_table_copy_in_p9;
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
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
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
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
522: , a1 out nocopy JTF_NUMBER_TABLE
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;
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
532: if t is null or t.count = 0 then
529: ) as
530: ddindx binary_integer; indx binary_integer;
531: begin
532: if t is null or t.count = 0 then
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
535: a2 := JTF_NUMBER_TABLE();
536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();
530: ddindx binary_integer; indx binary_integer;
531: begin
532: if t is null or t.count = 0 then
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
535: a2 := JTF_NUMBER_TABLE();
536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();
538: a5 := JTF_NUMBER_TABLE();
531: begin
532: if t is null or t.count = 0 then
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
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();
532: if t is null or t.count = 0 then
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
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();
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
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
534: a1 := JTF_NUMBER_TABLE();
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();
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();
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();
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();
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();
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();
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
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);
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);
553: a2.extend(t.count);
576: end if;
577: end if;
578: end rosetta_table_copy_out_p9;
579:
580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE) as
581: ddindx binary_integer; indx binary_integer;
582: begin
583: if a0 is not null and a0.count > 0 then
584: if a0.count > 0 then
594: end loop;
595: end if;
596: end if;
597: end rosetta_table_copy_in_p10;
598: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
599: ddindx binary_integer; indx binary_integer;
600: begin
601: if t is null or t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();
598: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
599: ddindx binary_integer; indx binary_integer;
600: begin
601: if t is null or t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();
603: else
604: a0 := JTF_NUMBER_TABLE();
605: if t.count > 0 then
606: a0.extend(t.count);
600: begin
601: if t is null or t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();
603: else
604: a0 := JTF_NUMBER_TABLE();
605: if t.count > 0 then
606: a0.extend(t.count);
607: ddindx := t.first;
608: indx := 1;
617: end if;
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
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
627: , a6 JTF_VARCHAR2_TABLE_100
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
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
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
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
629: , a8 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
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
629: , a8 JTF_NUMBER_TABLE
630: , a9 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
632: , a11 JTF_VARCHAR2_TABLE_100
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
632: , a11 JTF_VARCHAR2_TABLE_100
633: , a12 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
632: , a11 JTF_VARCHAR2_TABLE_100
633: , a12 JTF_NUMBER_TABLE
634: , a13 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
632: , a11 JTF_VARCHAR2_TABLE_100
633: , a12 JTF_NUMBER_TABLE
634: , a13 JTF_NUMBER_TABLE
635: ) as
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;
637: begin
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;
637: begin
638: if a0 is not null and a0.count > 0 then
662: end loop;
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
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
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
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
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE
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
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE
674: , a8 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
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
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
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
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
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
678: , a12 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
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
678: , a12 out nocopy JTF_NUMBER_TABLE
679: , a13 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
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
678: , a12 out nocopy JTF_NUMBER_TABLE
679: , a13 out nocopy JTF_NUMBER_TABLE
680: ) as
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;
682: begin
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;
682: begin
683: if t is null or t.count = 0 then
680: ) as
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();
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();
690: a6 := JTF_VARCHAR2_TABLE_100();
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();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
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();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := 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();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_NUMBER_TABLE();
693: a9 := 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();
695: a11 := JTF_VARCHAR2_TABLE_100();
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();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := 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();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_NUMBER_TABLE();
697: a13 := 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();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_NUMBER_TABLE();
697: a13 := JTF_NUMBER_TABLE();
698: else
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();
700: a1 := JTF_VARCHAR2_TABLE_100();
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();
700: a1 := JTF_VARCHAR2_TABLE_100();
701: a2 := 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();
700: a1 := JTF_VARCHAR2_TABLE_100();
701: a2 := JTF_NUMBER_TABLE();
702: a3 := JTF_NUMBER_TABLE();
703: a4 := 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();
705: a6 := JTF_VARCHAR2_TABLE_100();
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();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
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();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := 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();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := JTF_NUMBER_TABLE();
708: a9 := 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();
710: a11 := JTF_VARCHAR2_TABLE_100();
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();
710: a11 := JTF_VARCHAR2_TABLE_100();
711: a12 := 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();
710: a11 := JTF_VARCHAR2_TABLE_100();
711: a12 := JTF_NUMBER_TABLE();
712: a13 := 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();
710: a11 := JTF_VARCHAR2_TABLE_100();
711: a12 := JTF_NUMBER_TABLE();
712: a13 := JTF_NUMBER_TABLE();
713: if t.count > 0 then
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);
715: a1.extend(t.count);
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);
715: a1.extend(t.count);
716: a2.extend(t.count);
993:
994: procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
995: , x_msg_count out nocopy NUMBER
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
994: procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
995: , x_msg_count out nocopy NUMBER
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
995: , x_msg_count out nocopy NUMBER
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
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
1005: , p3_a8 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
1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE
1006: , p3_a9 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
1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE
1006: , p3_a9 in out nocopy JTF_NUMBER_TABLE
1007: , p3_a10 in out nocopy JTF_DATE_TABLE
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
1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE
1006: , p3_a9 in out nocopy JTF_NUMBER_TABLE
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
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
1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE
1006: , p3_a9 in out nocopy JTF_NUMBER_TABLE
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
1068: );
1069: end;
1070:
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
1069: end;
1070:
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
1070:
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
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
1080: , p1_a8 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
1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1081: , p1_a9 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
1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1081: , p1_a9 in out nocopy JTF_NUMBER_TABLE
1082: , p1_a10 in out nocopy JTF_DATE_TABLE
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
1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1081: , p1_a9 in out nocopy JTF_NUMBER_TABLE
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
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
1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1081: , p1_a9 in out nocopy JTF_NUMBER_TABLE
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
1173:
1174: function get_reset_counters(p_mr_header_id NUMBER
1175: , p_item_instance_id NUMBER
1176: , p_actual_date date
1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
1179: , p3_a2 out nocopy JTF_NUMBER_TABLE
1180: , p3_a3 out nocopy JTF_NUMBER_TABLE
1181: , p3_a4 out nocopy JTF_NUMBER_TABLE
1174: function get_reset_counters(p_mr_header_id NUMBER
1175: , p_item_instance_id NUMBER
1176: , p_actual_date date
1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
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
1175: , p_item_instance_id NUMBER
1176: , p_actual_date date
1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
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
1176: , p_actual_date date
1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
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
1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
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
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
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:
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
1188: ddp_actual_date date;
1231: , p0_a8 NUMBER
1232: , p0_a9 NUMBER
1233: , p0_a10 NUMBER
1234: , p0_a11 DATE
1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
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
1232: , p0_a9 NUMBER
1233: , p0_a10 NUMBER
1234: , p0_a11 DATE
1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
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
1233: , p0_a10 NUMBER
1234: , p0_a11 DATE
1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
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
1234: , p0_a11 DATE
1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
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
1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
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
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
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
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
1246: ) return varchar2
1308:
1309: function get_cp_counters(p_item_instance_id NUMBER
1310: , p_wip_entity_id NUMBER
1311: , p_actual_date date
1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
1314: , p3_a2 out nocopy JTF_NUMBER_TABLE
1315: , p3_a3 out nocopy JTF_NUMBER_TABLE
1316: , p3_a4 out nocopy JTF_NUMBER_TABLE
1309: function get_cp_counters(p_item_instance_id NUMBER
1310: , p_wip_entity_id NUMBER
1311: , p_actual_date date
1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
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
1310: , p_wip_entity_id NUMBER
1311: , p_actual_date date
1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
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
1311: , p_actual_date date
1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
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
1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
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
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
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:
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
1323: ddp_actual_date date;
1357:
1358: function update_ump(p_unit_effectivity_id NUMBER
1359: , p_ue_object_version NUMBER
1360: , p_actual_end_date date
1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
1363: , p3_a2 JTF_NUMBER_TABLE
1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE
1358: function update_ump(p_unit_effectivity_id NUMBER
1359: , p_ue_object_version NUMBER
1360: , p_actual_end_date date
1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
1363: , p3_a2 JTF_NUMBER_TABLE
1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE
1366: , p3_a5 JTF_NUMBER_TABLE
1359: , p_ue_object_version NUMBER
1360: , p_actual_end_date date
1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
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
1360: , p_actual_end_date date
1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
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
1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
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
1362: , p3_a1 JTF_NUMBER_TABLE
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
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
1372: ) return varchar2