1: package body ahl_completions_pvt_w as
2: /* $Header: AHLWPRCB.pls 120.1 2005/07/04 10:48 rroy noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package body ahl_completions_pvt_w as
2: /* $Header: AHLWPRCB.pls 120.1 2005/07/04 10:48 rroy noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then
64: end loop;
65: end if;
66: end if;
67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
65: end if;
66: end if;
67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
68: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_DATE_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_DATE_TABLE
77: , a9 out nocopy JTF_DATE_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_DATE_TABLE
77: , a9 out nocopy JTF_DATE_TABLE
78: , a10 out nocopy JTF_DATE_TABLE
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_DATE_TABLE
77: , a9 out nocopy JTF_DATE_TABLE
78: , a10 out nocopy JTF_DATE_TABLE
79: , a11 out nocopy JTF_DATE_TABLE
78: , a10 out nocopy JTF_DATE_TABLE
79: , a11 out nocopy JTF_DATE_TABLE
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , a14 out nocopy JTF_NUMBER_TABLE
83: , a15 out nocopy JTF_NUMBER_TABLE
84: , a16 out nocopy JTF_NUMBER_TABLE
85: , a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , a18 out nocopy JTF_NUMBER_TABLE
79: , a11 out nocopy JTF_DATE_TABLE
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , a14 out nocopy JTF_NUMBER_TABLE
83: , a15 out nocopy JTF_NUMBER_TABLE
84: , a16 out nocopy JTF_NUMBER_TABLE
85: , a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_VARCHAR2_TABLE_100
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , a14 out nocopy JTF_NUMBER_TABLE
83: , a15 out nocopy JTF_NUMBER_TABLE
84: , a16 out nocopy JTF_NUMBER_TABLE
85: , a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
82: , a14 out nocopy JTF_NUMBER_TABLE
83: , a15 out nocopy JTF_NUMBER_TABLE
84: , a16 out nocopy JTF_NUMBER_TABLE
85: , a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , a22 out nocopy JTF_VARCHAR2_TABLE_100
87: , a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , a22 out nocopy JTF_VARCHAR2_TABLE_100
91: , a23 out nocopy JTF_NUMBER_TABLE
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin
95: if t is null or t.count = 0 then
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin
95: if t is null or t.count = 0 then
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_VARCHAR2_TABLE_100();
100: a4 := JTF_NUMBER_TABLE();
93: ddindx binary_integer; indx binary_integer;
94: begin
95: if t is null or t.count = 0 then
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_VARCHAR2_TABLE_100();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_VARCHAR2_TABLE_100();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_DATE_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_VARCHAR2_TABLE_100();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_DATE_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_VARCHAR2_TABLE_100();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_DATE_TABLE();
106: a10 := JTF_DATE_TABLE();
99: a3 := JTF_VARCHAR2_TABLE_100();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_DATE_TABLE();
106: a10 := JTF_DATE_TABLE();
107: a11 := JTF_DATE_TABLE();
106: a10 := JTF_DATE_TABLE();
107: a11 := JTF_DATE_TABLE();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: a13 := JTF_VARCHAR2_TABLE_100();
110: a14 := JTF_NUMBER_TABLE();
111: a15 := JTF_NUMBER_TABLE();
112: a16 := JTF_NUMBER_TABLE();
113: a17 := JTF_VARCHAR2_TABLE_100();
114: a18 := JTF_NUMBER_TABLE();
107: a11 := JTF_DATE_TABLE();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: a13 := JTF_VARCHAR2_TABLE_100();
110: a14 := JTF_NUMBER_TABLE();
111: a15 := JTF_NUMBER_TABLE();
112: a16 := JTF_NUMBER_TABLE();
113: a17 := JTF_VARCHAR2_TABLE_100();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_VARCHAR2_TABLE_100();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: a13 := JTF_VARCHAR2_TABLE_100();
110: a14 := JTF_NUMBER_TABLE();
111: a15 := JTF_NUMBER_TABLE();
112: a16 := JTF_NUMBER_TABLE();
113: a17 := JTF_VARCHAR2_TABLE_100();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_VARCHAR2_TABLE_100();
116: a20 := JTF_VARCHAR2_TABLE_100();
110: a14 := JTF_NUMBER_TABLE();
111: a15 := JTF_NUMBER_TABLE();
112: a16 := JTF_NUMBER_TABLE();
113: a17 := JTF_VARCHAR2_TABLE_100();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_VARCHAR2_TABLE_100();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_100();
118: a22 := JTF_VARCHAR2_TABLE_100();
115: a19 := JTF_VARCHAR2_TABLE_100();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_100();
118: a22 := JTF_VARCHAR2_TABLE_100();
119: a23 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_100();
118: a22 := JTF_VARCHAR2_TABLE_100();
119: a23 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
118: a22 := JTF_VARCHAR2_TABLE_100();
119: a23 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_NUMBER_TABLE();
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_NUMBER_TABLE();
127: a6 := JTF_NUMBER_TABLE();
128: a7 := JTF_NUMBER_TABLE();
129: a8 := JTF_DATE_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_NUMBER_TABLE();
127: a6 := JTF_NUMBER_TABLE();
128: a7 := JTF_NUMBER_TABLE();
129: a8 := JTF_DATE_TABLE();
130: a9 := JTF_DATE_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_NUMBER_TABLE();
127: a6 := JTF_NUMBER_TABLE();
128: a7 := JTF_NUMBER_TABLE();
129: a8 := JTF_DATE_TABLE();
130: a9 := JTF_DATE_TABLE();
131: a10 := JTF_DATE_TABLE();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_NUMBER_TABLE();
127: a6 := JTF_NUMBER_TABLE();
128: a7 := JTF_NUMBER_TABLE();
129: a8 := JTF_DATE_TABLE();
130: a9 := JTF_DATE_TABLE();
131: a10 := JTF_DATE_TABLE();
132: a11 := JTF_DATE_TABLE();
131: a10 := JTF_DATE_TABLE();
132: a11 := JTF_DATE_TABLE();
133: a12 := JTF_VARCHAR2_TABLE_100();
134: a13 := JTF_VARCHAR2_TABLE_100();
135: a14 := JTF_NUMBER_TABLE();
136: a15 := JTF_NUMBER_TABLE();
137: a16 := JTF_NUMBER_TABLE();
138: a17 := JTF_VARCHAR2_TABLE_100();
139: a18 := JTF_NUMBER_TABLE();
132: a11 := JTF_DATE_TABLE();
133: a12 := JTF_VARCHAR2_TABLE_100();
134: a13 := JTF_VARCHAR2_TABLE_100();
135: a14 := JTF_NUMBER_TABLE();
136: a15 := JTF_NUMBER_TABLE();
137: a16 := JTF_NUMBER_TABLE();
138: a17 := JTF_VARCHAR2_TABLE_100();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_100();
133: a12 := JTF_VARCHAR2_TABLE_100();
134: a13 := JTF_VARCHAR2_TABLE_100();
135: a14 := JTF_NUMBER_TABLE();
136: a15 := JTF_NUMBER_TABLE();
137: a16 := JTF_NUMBER_TABLE();
138: a17 := JTF_VARCHAR2_TABLE_100();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_100();
141: a20 := JTF_VARCHAR2_TABLE_100();
135: a14 := JTF_NUMBER_TABLE();
136: a15 := JTF_NUMBER_TABLE();
137: a16 := JTF_NUMBER_TABLE();
138: a17 := JTF_VARCHAR2_TABLE_100();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_100();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_100();
143: a22 := JTF_VARCHAR2_TABLE_100();
140: a19 := JTF_VARCHAR2_TABLE_100();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_100();
143: a22 := JTF_VARCHAR2_TABLE_100();
144: a23 := JTF_NUMBER_TABLE();
145: if t.count > 0 then
146: a0.extend(t.count);
147: a1.extend(t.count);
148: a2.extend(t.count);
203: end if;
204: end if;
205: end rosetta_table_copy_out_p1;
206:
207: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
208: , a1 JTF_NUMBER_TABLE
209: , a2 JTF_NUMBER_TABLE
210: , a3 JTF_VARCHAR2_TABLE_100
211: , a4 JTF_NUMBER_TABLE
204: end if;
205: end rosetta_table_copy_out_p1;
206:
207: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
208: , a1 JTF_NUMBER_TABLE
209: , a2 JTF_NUMBER_TABLE
210: , a3 JTF_VARCHAR2_TABLE_100
211: , a4 JTF_NUMBER_TABLE
212: , a5 JTF_NUMBER_TABLE
205: end rosetta_table_copy_out_p1;
206:
207: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
208: , a1 JTF_NUMBER_TABLE
209: , a2 JTF_NUMBER_TABLE
210: , a3 JTF_VARCHAR2_TABLE_100
211: , a4 JTF_NUMBER_TABLE
212: , a5 JTF_NUMBER_TABLE
213: , a6 JTF_NUMBER_TABLE
207: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
208: , a1 JTF_NUMBER_TABLE
209: , a2 JTF_NUMBER_TABLE
210: , a3 JTF_VARCHAR2_TABLE_100
211: , a4 JTF_NUMBER_TABLE
212: , a5 JTF_NUMBER_TABLE
213: , a6 JTF_NUMBER_TABLE
214: , a7 JTF_VARCHAR2_TABLE_2000
215: , a8 JTF_NUMBER_TABLE
208: , a1 JTF_NUMBER_TABLE
209: , a2 JTF_NUMBER_TABLE
210: , a3 JTF_VARCHAR2_TABLE_100
211: , a4 JTF_NUMBER_TABLE
212: , a5 JTF_NUMBER_TABLE
213: , a6 JTF_NUMBER_TABLE
214: , a7 JTF_VARCHAR2_TABLE_2000
215: , a8 JTF_NUMBER_TABLE
216: , a9 JTF_NUMBER_TABLE
209: , a2 JTF_NUMBER_TABLE
210: , a3 JTF_VARCHAR2_TABLE_100
211: , a4 JTF_NUMBER_TABLE
212: , a5 JTF_NUMBER_TABLE
213: , a6 JTF_NUMBER_TABLE
214: , a7 JTF_VARCHAR2_TABLE_2000
215: , a8 JTF_NUMBER_TABLE
216: , a9 JTF_NUMBER_TABLE
217: , a10 JTF_DATE_TABLE
211: , a4 JTF_NUMBER_TABLE
212: , a5 JTF_NUMBER_TABLE
213: , a6 JTF_NUMBER_TABLE
214: , a7 JTF_VARCHAR2_TABLE_2000
215: , a8 JTF_NUMBER_TABLE
216: , a9 JTF_NUMBER_TABLE
217: , a10 JTF_DATE_TABLE
218: , a11 JTF_DATE_TABLE
219: , a12 JTF_DATE_TABLE
212: , a5 JTF_NUMBER_TABLE
213: , a6 JTF_NUMBER_TABLE
214: , a7 JTF_VARCHAR2_TABLE_2000
215: , a8 JTF_NUMBER_TABLE
216: , a9 JTF_NUMBER_TABLE
217: , a10 JTF_DATE_TABLE
218: , a11 JTF_DATE_TABLE
219: , a12 JTF_DATE_TABLE
220: , a13 JTF_DATE_TABLE
252: end loop;
253: end if;
254: end if;
255: end rosetta_table_copy_in_p3;
256: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
257: , a1 out nocopy JTF_NUMBER_TABLE
258: , a2 out nocopy JTF_NUMBER_TABLE
259: , a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , a4 out nocopy JTF_NUMBER_TABLE
253: end if;
254: end if;
255: end rosetta_table_copy_in_p3;
256: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
257: , a1 out nocopy JTF_NUMBER_TABLE
258: , a2 out nocopy JTF_NUMBER_TABLE
259: , a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , a4 out nocopy JTF_NUMBER_TABLE
261: , a5 out nocopy JTF_NUMBER_TABLE
254: end if;
255: end rosetta_table_copy_in_p3;
256: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
257: , a1 out nocopy JTF_NUMBER_TABLE
258: , a2 out nocopy JTF_NUMBER_TABLE
259: , a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , a4 out nocopy JTF_NUMBER_TABLE
261: , a5 out nocopy JTF_NUMBER_TABLE
262: , a6 out nocopy JTF_NUMBER_TABLE
256: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
257: , a1 out nocopy JTF_NUMBER_TABLE
258: , a2 out nocopy JTF_NUMBER_TABLE
259: , a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , a4 out nocopy JTF_NUMBER_TABLE
261: , a5 out nocopy JTF_NUMBER_TABLE
262: , a6 out nocopy JTF_NUMBER_TABLE
263: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
264: , a8 out nocopy JTF_NUMBER_TABLE
257: , a1 out nocopy JTF_NUMBER_TABLE
258: , a2 out nocopy JTF_NUMBER_TABLE
259: , a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , a4 out nocopy JTF_NUMBER_TABLE
261: , a5 out nocopy JTF_NUMBER_TABLE
262: , a6 out nocopy JTF_NUMBER_TABLE
263: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
264: , a8 out nocopy JTF_NUMBER_TABLE
265: , a9 out nocopy JTF_NUMBER_TABLE
258: , a2 out nocopy JTF_NUMBER_TABLE
259: , a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , a4 out nocopy JTF_NUMBER_TABLE
261: , a5 out nocopy JTF_NUMBER_TABLE
262: , a6 out nocopy JTF_NUMBER_TABLE
263: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
264: , a8 out nocopy JTF_NUMBER_TABLE
265: , a9 out nocopy JTF_NUMBER_TABLE
266: , a10 out nocopy JTF_DATE_TABLE
260: , a4 out nocopy JTF_NUMBER_TABLE
261: , a5 out nocopy JTF_NUMBER_TABLE
262: , a6 out nocopy JTF_NUMBER_TABLE
263: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
264: , a8 out nocopy JTF_NUMBER_TABLE
265: , a9 out nocopy JTF_NUMBER_TABLE
266: , a10 out nocopy JTF_DATE_TABLE
267: , a11 out nocopy JTF_DATE_TABLE
268: , a12 out nocopy JTF_DATE_TABLE
261: , a5 out nocopy JTF_NUMBER_TABLE
262: , a6 out nocopy JTF_NUMBER_TABLE
263: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
264: , a8 out nocopy JTF_NUMBER_TABLE
265: , a9 out nocopy JTF_NUMBER_TABLE
266: , a10 out nocopy JTF_DATE_TABLE
267: , a11 out nocopy JTF_DATE_TABLE
268: , a12 out nocopy JTF_DATE_TABLE
269: , a13 out nocopy JTF_DATE_TABLE
272: ) as
273: ddindx binary_integer; indx binary_integer;
274: begin
275: if t is null or t.count = 0 then
276: a0 := JTF_NUMBER_TABLE();
277: a1 := JTF_NUMBER_TABLE();
278: a2 := JTF_NUMBER_TABLE();
279: a3 := JTF_VARCHAR2_TABLE_100();
280: a4 := JTF_NUMBER_TABLE();
273: ddindx binary_integer; indx binary_integer;
274: begin
275: if t is null or t.count = 0 then
276: a0 := JTF_NUMBER_TABLE();
277: a1 := JTF_NUMBER_TABLE();
278: a2 := JTF_NUMBER_TABLE();
279: a3 := JTF_VARCHAR2_TABLE_100();
280: a4 := JTF_NUMBER_TABLE();
281: a5 := JTF_NUMBER_TABLE();
274: begin
275: if t is null or t.count = 0 then
276: a0 := JTF_NUMBER_TABLE();
277: a1 := JTF_NUMBER_TABLE();
278: a2 := JTF_NUMBER_TABLE();
279: a3 := JTF_VARCHAR2_TABLE_100();
280: a4 := JTF_NUMBER_TABLE();
281: a5 := JTF_NUMBER_TABLE();
282: a6 := JTF_NUMBER_TABLE();
276: a0 := JTF_NUMBER_TABLE();
277: a1 := JTF_NUMBER_TABLE();
278: a2 := JTF_NUMBER_TABLE();
279: a3 := JTF_VARCHAR2_TABLE_100();
280: a4 := JTF_NUMBER_TABLE();
281: a5 := JTF_NUMBER_TABLE();
282: a6 := JTF_NUMBER_TABLE();
283: a7 := JTF_VARCHAR2_TABLE_2000();
284: a8 := JTF_NUMBER_TABLE();
277: a1 := JTF_NUMBER_TABLE();
278: a2 := JTF_NUMBER_TABLE();
279: a3 := JTF_VARCHAR2_TABLE_100();
280: a4 := JTF_NUMBER_TABLE();
281: a5 := JTF_NUMBER_TABLE();
282: a6 := JTF_NUMBER_TABLE();
283: a7 := JTF_VARCHAR2_TABLE_2000();
284: a8 := JTF_NUMBER_TABLE();
285: a9 := JTF_NUMBER_TABLE();
278: a2 := JTF_NUMBER_TABLE();
279: a3 := JTF_VARCHAR2_TABLE_100();
280: a4 := JTF_NUMBER_TABLE();
281: a5 := JTF_NUMBER_TABLE();
282: a6 := JTF_NUMBER_TABLE();
283: a7 := JTF_VARCHAR2_TABLE_2000();
284: a8 := JTF_NUMBER_TABLE();
285: a9 := JTF_NUMBER_TABLE();
286: a10 := JTF_DATE_TABLE();
280: a4 := JTF_NUMBER_TABLE();
281: a5 := JTF_NUMBER_TABLE();
282: a6 := JTF_NUMBER_TABLE();
283: a7 := JTF_VARCHAR2_TABLE_2000();
284: a8 := JTF_NUMBER_TABLE();
285: a9 := JTF_NUMBER_TABLE();
286: a10 := JTF_DATE_TABLE();
287: a11 := JTF_DATE_TABLE();
288: a12 := JTF_DATE_TABLE();
281: a5 := JTF_NUMBER_TABLE();
282: a6 := JTF_NUMBER_TABLE();
283: a7 := JTF_VARCHAR2_TABLE_2000();
284: a8 := JTF_NUMBER_TABLE();
285: a9 := JTF_NUMBER_TABLE();
286: a10 := JTF_DATE_TABLE();
287: a11 := JTF_DATE_TABLE();
288: a12 := JTF_DATE_TABLE();
289: a13 := JTF_DATE_TABLE();
289: a13 := JTF_DATE_TABLE();
290: a14 := JTF_VARCHAR2_TABLE_100();
291: a15 := JTF_VARCHAR2_TABLE_100();
292: else
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_NUMBER_TABLE();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_100();
297: a4 := JTF_NUMBER_TABLE();
290: a14 := JTF_VARCHAR2_TABLE_100();
291: a15 := JTF_VARCHAR2_TABLE_100();
292: else
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_NUMBER_TABLE();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_100();
297: a4 := JTF_NUMBER_TABLE();
298: a5 := JTF_NUMBER_TABLE();
291: a15 := JTF_VARCHAR2_TABLE_100();
292: else
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_NUMBER_TABLE();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_100();
297: a4 := JTF_NUMBER_TABLE();
298: a5 := JTF_NUMBER_TABLE();
299: a6 := JTF_NUMBER_TABLE();
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_NUMBER_TABLE();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_100();
297: a4 := JTF_NUMBER_TABLE();
298: a5 := JTF_NUMBER_TABLE();
299: a6 := JTF_NUMBER_TABLE();
300: a7 := JTF_VARCHAR2_TABLE_2000();
301: a8 := JTF_NUMBER_TABLE();
294: a1 := JTF_NUMBER_TABLE();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_100();
297: a4 := JTF_NUMBER_TABLE();
298: a5 := JTF_NUMBER_TABLE();
299: a6 := JTF_NUMBER_TABLE();
300: a7 := JTF_VARCHAR2_TABLE_2000();
301: a8 := JTF_NUMBER_TABLE();
302: a9 := JTF_NUMBER_TABLE();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_100();
297: a4 := JTF_NUMBER_TABLE();
298: a5 := JTF_NUMBER_TABLE();
299: a6 := JTF_NUMBER_TABLE();
300: a7 := JTF_VARCHAR2_TABLE_2000();
301: a8 := JTF_NUMBER_TABLE();
302: a9 := JTF_NUMBER_TABLE();
303: a10 := JTF_DATE_TABLE();
297: a4 := JTF_NUMBER_TABLE();
298: a5 := JTF_NUMBER_TABLE();
299: a6 := JTF_NUMBER_TABLE();
300: a7 := JTF_VARCHAR2_TABLE_2000();
301: a8 := JTF_NUMBER_TABLE();
302: a9 := JTF_NUMBER_TABLE();
303: a10 := JTF_DATE_TABLE();
304: a11 := JTF_DATE_TABLE();
305: a12 := JTF_DATE_TABLE();
298: a5 := JTF_NUMBER_TABLE();
299: a6 := JTF_NUMBER_TABLE();
300: a7 := JTF_VARCHAR2_TABLE_2000();
301: a8 := JTF_NUMBER_TABLE();
302: a9 := JTF_NUMBER_TABLE();
303: a10 := JTF_DATE_TABLE();
304: a11 := JTF_DATE_TABLE();
305: a12 := JTF_DATE_TABLE();
306: a13 := JTF_DATE_TABLE();
351: end if;
352: end if;
353: end rosetta_table_copy_out_p3;
354:
355: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
356: , a1 JTF_NUMBER_TABLE
357: , a2 JTF_VARCHAR2_TABLE_100
358: , a3 JTF_VARCHAR2_TABLE_100
359: , a4 JTF_NUMBER_TABLE
352: end if;
353: end rosetta_table_copy_out_p3;
354:
355: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
356: , a1 JTF_NUMBER_TABLE
357: , a2 JTF_VARCHAR2_TABLE_100
358: , a3 JTF_VARCHAR2_TABLE_100
359: , a4 JTF_NUMBER_TABLE
360: , a5 JTF_NUMBER_TABLE
355: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
356: , a1 JTF_NUMBER_TABLE
357: , a2 JTF_VARCHAR2_TABLE_100
358: , a3 JTF_VARCHAR2_TABLE_100
359: , a4 JTF_NUMBER_TABLE
360: , a5 JTF_NUMBER_TABLE
361: , a6 JTF_VARCHAR2_TABLE_100
362: , a7 JTF_VARCHAR2_TABLE_200
363: , a8 JTF_NUMBER_TABLE
356: , a1 JTF_NUMBER_TABLE
357: , a2 JTF_VARCHAR2_TABLE_100
358: , a3 JTF_VARCHAR2_TABLE_100
359: , a4 JTF_NUMBER_TABLE
360: , a5 JTF_NUMBER_TABLE
361: , a6 JTF_VARCHAR2_TABLE_100
362: , a7 JTF_VARCHAR2_TABLE_200
363: , a8 JTF_NUMBER_TABLE
364: , a9 JTF_NUMBER_TABLE
359: , a4 JTF_NUMBER_TABLE
360: , a5 JTF_NUMBER_TABLE
361: , a6 JTF_VARCHAR2_TABLE_100
362: , a7 JTF_VARCHAR2_TABLE_200
363: , a8 JTF_NUMBER_TABLE
364: , a9 JTF_NUMBER_TABLE
365: , a10 JTF_NUMBER_TABLE
366: , a11 JTF_DATE_TABLE
367: ) as
360: , a5 JTF_NUMBER_TABLE
361: , a6 JTF_VARCHAR2_TABLE_100
362: , a7 JTF_VARCHAR2_TABLE_200
363: , a8 JTF_NUMBER_TABLE
364: , a9 JTF_NUMBER_TABLE
365: , a10 JTF_NUMBER_TABLE
366: , a11 JTF_DATE_TABLE
367: ) as
368: ddindx binary_integer; indx binary_integer;
361: , a6 JTF_VARCHAR2_TABLE_100
362: , a7 JTF_VARCHAR2_TABLE_200
363: , a8 JTF_NUMBER_TABLE
364: , a9 JTF_NUMBER_TABLE
365: , a10 JTF_NUMBER_TABLE
366: , a11 JTF_DATE_TABLE
367: ) as
368: ddindx binary_integer; indx binary_integer;
369: begin
392: end loop;
393: end if;
394: end if;
395: end rosetta_table_copy_in_p7;
396: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: , a2 out nocopy JTF_VARCHAR2_TABLE_100
399: , a3 out nocopy JTF_VARCHAR2_TABLE_100
400: , a4 out nocopy JTF_NUMBER_TABLE
393: end if;
394: end if;
395: end rosetta_table_copy_in_p7;
396: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: , a2 out nocopy JTF_VARCHAR2_TABLE_100
399: , a3 out nocopy JTF_VARCHAR2_TABLE_100
400: , a4 out nocopy JTF_NUMBER_TABLE
401: , a5 out nocopy JTF_NUMBER_TABLE
396: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: , a2 out nocopy JTF_VARCHAR2_TABLE_100
399: , a3 out nocopy JTF_VARCHAR2_TABLE_100
400: , a4 out nocopy JTF_NUMBER_TABLE
401: , a5 out nocopy JTF_NUMBER_TABLE
402: , a6 out nocopy JTF_VARCHAR2_TABLE_100
403: , a7 out nocopy JTF_VARCHAR2_TABLE_200
404: , a8 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: , a2 out nocopy JTF_VARCHAR2_TABLE_100
399: , a3 out nocopy JTF_VARCHAR2_TABLE_100
400: , a4 out nocopy JTF_NUMBER_TABLE
401: , a5 out nocopy JTF_NUMBER_TABLE
402: , a6 out nocopy JTF_VARCHAR2_TABLE_100
403: , a7 out nocopy JTF_VARCHAR2_TABLE_200
404: , a8 out nocopy JTF_NUMBER_TABLE
405: , a9 out nocopy JTF_NUMBER_TABLE
400: , a4 out nocopy JTF_NUMBER_TABLE
401: , a5 out nocopy JTF_NUMBER_TABLE
402: , a6 out nocopy JTF_VARCHAR2_TABLE_100
403: , a7 out nocopy JTF_VARCHAR2_TABLE_200
404: , a8 out nocopy JTF_NUMBER_TABLE
405: , a9 out nocopy JTF_NUMBER_TABLE
406: , a10 out nocopy JTF_NUMBER_TABLE
407: , a11 out nocopy JTF_DATE_TABLE
408: ) as
401: , a5 out nocopy JTF_NUMBER_TABLE
402: , a6 out nocopy JTF_VARCHAR2_TABLE_100
403: , a7 out nocopy JTF_VARCHAR2_TABLE_200
404: , a8 out nocopy JTF_NUMBER_TABLE
405: , a9 out nocopy JTF_NUMBER_TABLE
406: , a10 out nocopy JTF_NUMBER_TABLE
407: , a11 out nocopy JTF_DATE_TABLE
408: ) as
409: ddindx binary_integer; indx binary_integer;
402: , a6 out nocopy JTF_VARCHAR2_TABLE_100
403: , a7 out nocopy JTF_VARCHAR2_TABLE_200
404: , a8 out nocopy JTF_NUMBER_TABLE
405: , a9 out nocopy JTF_NUMBER_TABLE
406: , a10 out nocopy JTF_NUMBER_TABLE
407: , a11 out nocopy JTF_DATE_TABLE
408: ) as
409: ddindx binary_integer; indx binary_integer;
410: begin
408: ) as
409: ddindx binary_integer; indx binary_integer;
410: begin
411: if t is null or t.count = 0 then
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_VARCHAR2_TABLE_100();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_NUMBER_TABLE();
409: ddindx binary_integer; indx binary_integer;
410: begin
411: if t is null or t.count = 0 then
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_VARCHAR2_TABLE_100();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_NUMBER_TABLE();
417: a5 := JTF_NUMBER_TABLE();
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_VARCHAR2_TABLE_100();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_NUMBER_TABLE();
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();
420: a8 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_VARCHAR2_TABLE_100();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_NUMBER_TABLE();
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();
420: a8 := JTF_NUMBER_TABLE();
421: a9 := JTF_NUMBER_TABLE();
416: a4 := JTF_NUMBER_TABLE();
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();
420: a8 := JTF_NUMBER_TABLE();
421: a9 := JTF_NUMBER_TABLE();
422: a10 := JTF_NUMBER_TABLE();
423: a11 := JTF_DATE_TABLE();
424: else
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();
420: a8 := JTF_NUMBER_TABLE();
421: a9 := JTF_NUMBER_TABLE();
422: a10 := JTF_NUMBER_TABLE();
423: a11 := JTF_DATE_TABLE();
424: else
425: a0 := JTF_NUMBER_TABLE();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();
420: a8 := JTF_NUMBER_TABLE();
421: a9 := JTF_NUMBER_TABLE();
422: a10 := JTF_NUMBER_TABLE();
423: a11 := JTF_DATE_TABLE();
424: else
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_NUMBER_TABLE();
421: a9 := JTF_NUMBER_TABLE();
422: a10 := JTF_NUMBER_TABLE();
423: a11 := JTF_DATE_TABLE();
424: else
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: a10 := JTF_NUMBER_TABLE();
423: a11 := JTF_DATE_TABLE();
424: else
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: if t.count > 0 then
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: if t.count > 0 then
438: a0.extend(t.count);
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: if t.count > 0 then
438: a0.extend(t.count);
439: a1.extend(t.count);
471: end if;
472: end if;
473: end rosetta_table_copy_out_p7;
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_NUMBER_TABLE
472: end if;
473: end rosetta_table_copy_out_p7;
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_NUMBER_TABLE
480: , a5 JTF_NUMBER_TABLE
473: end rosetta_table_copy_out_p7;
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_NUMBER_TABLE
480: , a5 JTF_NUMBER_TABLE
481: , a6 JTF_VARCHAR2_TABLE_100
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_NUMBER_TABLE
480: , a5 JTF_NUMBER_TABLE
481: , a6 JTF_VARCHAR2_TABLE_100
482: , a7 JTF_NUMBER_TABLE
475: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_NUMBER_TABLE
480: , a5 JTF_NUMBER_TABLE
481: , a6 JTF_VARCHAR2_TABLE_100
482: , a7 JTF_NUMBER_TABLE
483: ) as
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_NUMBER_TABLE
480: , a5 JTF_NUMBER_TABLE
481: , a6 JTF_VARCHAR2_TABLE_100
482: , a7 JTF_NUMBER_TABLE
483: ) as
484: ddindx binary_integer; indx binary_integer;
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_NUMBER_TABLE
480: , a5 JTF_NUMBER_TABLE
481: , a6 JTF_VARCHAR2_TABLE_100
482: , a7 JTF_NUMBER_TABLE
483: ) as
484: ddindx binary_integer; indx binary_integer;
485: begin
486: if a0 is not null and a0.count > 0 then
504: end loop;
505: end if;
506: end if;
507: end rosetta_table_copy_in_p9;
508: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_NUMBER_TABLE
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
505: end if;
506: end if;
507: end rosetta_table_copy_in_p9;
508: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_NUMBER_TABLE
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
506: end if;
507: end rosetta_table_copy_in_p9;
508: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_NUMBER_TABLE
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_VARCHAR2_TABLE_100
507: end rosetta_table_copy_in_p9;
508: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_NUMBER_TABLE
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_VARCHAR2_TABLE_100
515: , a7 out nocopy JTF_NUMBER_TABLE
508: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_NUMBER_TABLE
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_VARCHAR2_TABLE_100
515: , a7 out nocopy JTF_NUMBER_TABLE
516: ) as
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_NUMBER_TABLE
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_VARCHAR2_TABLE_100
515: , a7 out nocopy JTF_NUMBER_TABLE
516: ) as
517: ddindx binary_integer; indx binary_integer;
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_VARCHAR2_TABLE_100
515: , a7 out nocopy JTF_NUMBER_TABLE
516: ) as
517: ddindx binary_integer; indx binary_integer;
518: begin
519: if t is null or t.count = 0 then
516: ) as
517: ddindx binary_integer; indx binary_integer;
518: begin
519: if t is null or t.count = 0 then
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_NUMBER_TABLE();
523: a3 := JTF_NUMBER_TABLE();
524: a4 := JTF_NUMBER_TABLE();
517: ddindx binary_integer; indx binary_integer;
518: begin
519: if t is null or t.count = 0 then
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_NUMBER_TABLE();
523: a3 := JTF_NUMBER_TABLE();
524: a4 := JTF_NUMBER_TABLE();
525: a5 := JTF_NUMBER_TABLE();
518: begin
519: if t is null or t.count = 0 then
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_NUMBER_TABLE();
523: a3 := JTF_NUMBER_TABLE();
524: a4 := JTF_NUMBER_TABLE();
525: a5 := JTF_NUMBER_TABLE();
526: a6 := JTF_VARCHAR2_TABLE_100();
519: if t is null or t.count = 0 then
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_NUMBER_TABLE();
523: a3 := JTF_NUMBER_TABLE();
524: a4 := JTF_NUMBER_TABLE();
525: a5 := JTF_NUMBER_TABLE();
526: a6 := JTF_VARCHAR2_TABLE_100();
527: a7 := JTF_NUMBER_TABLE();
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_NUMBER_TABLE();
523: a3 := JTF_NUMBER_TABLE();
524: a4 := JTF_NUMBER_TABLE();
525: a5 := JTF_NUMBER_TABLE();
526: a6 := JTF_VARCHAR2_TABLE_100();
527: a7 := JTF_NUMBER_TABLE();
528: else
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_NUMBER_TABLE();
523: a3 := JTF_NUMBER_TABLE();
524: a4 := JTF_NUMBER_TABLE();
525: a5 := JTF_NUMBER_TABLE();
526: a6 := JTF_VARCHAR2_TABLE_100();
527: a7 := JTF_NUMBER_TABLE();
528: else
529: a0 := JTF_NUMBER_TABLE();
523: a3 := JTF_NUMBER_TABLE();
524: a4 := JTF_NUMBER_TABLE();
525: a5 := JTF_NUMBER_TABLE();
526: a6 := JTF_VARCHAR2_TABLE_100();
527: a7 := JTF_NUMBER_TABLE();
528: else
529: a0 := JTF_NUMBER_TABLE();
530: a1 := JTF_NUMBER_TABLE();
531: a2 := JTF_NUMBER_TABLE();
525: a5 := JTF_NUMBER_TABLE();
526: a6 := JTF_VARCHAR2_TABLE_100();
527: a7 := JTF_NUMBER_TABLE();
528: else
529: a0 := JTF_NUMBER_TABLE();
530: a1 := JTF_NUMBER_TABLE();
531: a2 := JTF_NUMBER_TABLE();
532: a3 := JTF_NUMBER_TABLE();
533: a4 := JTF_NUMBER_TABLE();
526: a6 := JTF_VARCHAR2_TABLE_100();
527: a7 := JTF_NUMBER_TABLE();
528: else
529: a0 := JTF_NUMBER_TABLE();
530: a1 := JTF_NUMBER_TABLE();
531: a2 := JTF_NUMBER_TABLE();
532: a3 := JTF_NUMBER_TABLE();
533: a4 := JTF_NUMBER_TABLE();
534: a5 := JTF_NUMBER_TABLE();
527: a7 := JTF_NUMBER_TABLE();
528: else
529: a0 := JTF_NUMBER_TABLE();
530: a1 := JTF_NUMBER_TABLE();
531: a2 := JTF_NUMBER_TABLE();
532: a3 := JTF_NUMBER_TABLE();
533: a4 := JTF_NUMBER_TABLE();
534: a5 := JTF_NUMBER_TABLE();
535: a6 := JTF_VARCHAR2_TABLE_100();
528: else
529: a0 := JTF_NUMBER_TABLE();
530: a1 := JTF_NUMBER_TABLE();
531: a2 := JTF_NUMBER_TABLE();
532: a3 := JTF_NUMBER_TABLE();
533: a4 := JTF_NUMBER_TABLE();
534: a5 := JTF_NUMBER_TABLE();
535: a6 := JTF_VARCHAR2_TABLE_100();
536: a7 := JTF_NUMBER_TABLE();
529: a0 := JTF_NUMBER_TABLE();
530: a1 := JTF_NUMBER_TABLE();
531: a2 := JTF_NUMBER_TABLE();
532: a3 := JTF_NUMBER_TABLE();
533: a4 := JTF_NUMBER_TABLE();
534: a5 := JTF_NUMBER_TABLE();
535: a6 := JTF_VARCHAR2_TABLE_100();
536: a7 := JTF_NUMBER_TABLE();
537: if t.count > 0 then
530: a1 := JTF_NUMBER_TABLE();
531: a2 := JTF_NUMBER_TABLE();
532: a3 := JTF_NUMBER_TABLE();
533: a4 := JTF_NUMBER_TABLE();
534: a5 := JTF_NUMBER_TABLE();
535: a6 := JTF_VARCHAR2_TABLE_100();
536: a7 := JTF_NUMBER_TABLE();
537: if t.count > 0 then
538: a0.extend(t.count);
532: a3 := JTF_NUMBER_TABLE();
533: a4 := JTF_NUMBER_TABLE();
534: a5 := JTF_NUMBER_TABLE();
535: a6 := JTF_VARCHAR2_TABLE_100();
536: a7 := JTF_NUMBER_TABLE();
537: if t.count > 0 then
538: a0.extend(t.count);
539: a1.extend(t.count);
540: a2.extend(t.count);
563: end if;
564: end if;
565: end rosetta_table_copy_out_p9;
566:
567: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE) as
568: ddindx binary_integer; indx binary_integer;
569: begin
570: if a0 is not null and a0.count > 0 then
571: if a0.count > 0 then
581: end loop;
582: end if;
583: end if;
584: end rosetta_table_copy_in_p10;
585: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
586: ddindx binary_integer; indx binary_integer;
587: begin
588: if t is null or t.count = 0 then
589: a0 := JTF_NUMBER_TABLE();
585: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
586: ddindx binary_integer; indx binary_integer;
587: begin
588: if t is null or t.count = 0 then
589: a0 := JTF_NUMBER_TABLE();
590: else
591: a0 := JTF_NUMBER_TABLE();
592: if t.count > 0 then
593: a0.extend(t.count);
587: begin
588: if t is null or t.count = 0 then
589: a0 := JTF_NUMBER_TABLE();
590: else
591: a0 := JTF_NUMBER_TABLE();
592: if t.count > 0 then
593: a0.extend(t.count);
594: ddindx := t.first;
595: indx := 1;
604: end if;
605: end if;
606: end rosetta_table_copy_out_p10;
607:
608: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
609: , a1 JTF_VARCHAR2_TABLE_100
610: , a2 JTF_NUMBER_TABLE
611: , a3 JTF_NUMBER_TABLE
612: , a4 JTF_NUMBER_TABLE
606: end rosetta_table_copy_out_p10;
607:
608: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
609: , a1 JTF_VARCHAR2_TABLE_100
610: , a2 JTF_NUMBER_TABLE
611: , a3 JTF_NUMBER_TABLE
612: , a4 JTF_NUMBER_TABLE
613: , a5 JTF_NUMBER_TABLE
614: , a6 JTF_NUMBER_TABLE
607:
608: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
609: , a1 JTF_VARCHAR2_TABLE_100
610: , a2 JTF_NUMBER_TABLE
611: , a3 JTF_NUMBER_TABLE
612: , a4 JTF_NUMBER_TABLE
613: , a5 JTF_NUMBER_TABLE
614: , a6 JTF_NUMBER_TABLE
615: , a7 JTF_NUMBER_TABLE
608: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
609: , a1 JTF_VARCHAR2_TABLE_100
610: , a2 JTF_NUMBER_TABLE
611: , a3 JTF_NUMBER_TABLE
612: , a4 JTF_NUMBER_TABLE
613: , a5 JTF_NUMBER_TABLE
614: , a6 JTF_NUMBER_TABLE
615: , a7 JTF_NUMBER_TABLE
616: , a8 JTF_VARCHAR2_TABLE_100
609: , a1 JTF_VARCHAR2_TABLE_100
610: , a2 JTF_NUMBER_TABLE
611: , a3 JTF_NUMBER_TABLE
612: , a4 JTF_NUMBER_TABLE
613: , a5 JTF_NUMBER_TABLE
614: , a6 JTF_NUMBER_TABLE
615: , a7 JTF_NUMBER_TABLE
616: , a8 JTF_VARCHAR2_TABLE_100
617: , a9 JTF_NUMBER_TABLE
610: , a2 JTF_NUMBER_TABLE
611: , a3 JTF_NUMBER_TABLE
612: , a4 JTF_NUMBER_TABLE
613: , a5 JTF_NUMBER_TABLE
614: , a6 JTF_NUMBER_TABLE
615: , a7 JTF_NUMBER_TABLE
616: , a8 JTF_VARCHAR2_TABLE_100
617: , a9 JTF_NUMBER_TABLE
618: , a10 JTF_NUMBER_TABLE
611: , a3 JTF_NUMBER_TABLE
612: , a4 JTF_NUMBER_TABLE
613: , a5 JTF_NUMBER_TABLE
614: , a6 JTF_NUMBER_TABLE
615: , a7 JTF_NUMBER_TABLE
616: , a8 JTF_VARCHAR2_TABLE_100
617: , a9 JTF_NUMBER_TABLE
618: , a10 JTF_NUMBER_TABLE
619: ) as
613: , a5 JTF_NUMBER_TABLE
614: , a6 JTF_NUMBER_TABLE
615: , a7 JTF_NUMBER_TABLE
616: , a8 JTF_VARCHAR2_TABLE_100
617: , a9 JTF_NUMBER_TABLE
618: , a10 JTF_NUMBER_TABLE
619: ) as
620: ddindx binary_integer; indx binary_integer;
621: begin
614: , a6 JTF_NUMBER_TABLE
615: , a7 JTF_NUMBER_TABLE
616: , a8 JTF_VARCHAR2_TABLE_100
617: , a9 JTF_NUMBER_TABLE
618: , a10 JTF_NUMBER_TABLE
619: ) as
620: ddindx binary_integer; indx binary_integer;
621: begin
622: if a0 is not null and a0.count > 0 then
643: end loop;
644: end if;
645: end if;
646: end rosetta_table_copy_in_p18;
647: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
648: , a1 out nocopy JTF_VARCHAR2_TABLE_100
649: , a2 out nocopy JTF_NUMBER_TABLE
650: , a3 out nocopy JTF_NUMBER_TABLE
651: , a4 out nocopy JTF_NUMBER_TABLE
645: end if;
646: end rosetta_table_copy_in_p18;
647: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
648: , a1 out nocopy JTF_VARCHAR2_TABLE_100
649: , a2 out nocopy JTF_NUMBER_TABLE
650: , a3 out nocopy JTF_NUMBER_TABLE
651: , a4 out nocopy JTF_NUMBER_TABLE
652: , a5 out nocopy JTF_NUMBER_TABLE
653: , a6 out nocopy JTF_NUMBER_TABLE
646: end rosetta_table_copy_in_p18;
647: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
648: , a1 out nocopy JTF_VARCHAR2_TABLE_100
649: , a2 out nocopy JTF_NUMBER_TABLE
650: , a3 out nocopy JTF_NUMBER_TABLE
651: , a4 out nocopy JTF_NUMBER_TABLE
652: , a5 out nocopy JTF_NUMBER_TABLE
653: , a6 out nocopy JTF_NUMBER_TABLE
654: , a7 out nocopy JTF_NUMBER_TABLE
647: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
648: , a1 out nocopy JTF_VARCHAR2_TABLE_100
649: , a2 out nocopy JTF_NUMBER_TABLE
650: , a3 out nocopy JTF_NUMBER_TABLE
651: , a4 out nocopy JTF_NUMBER_TABLE
652: , a5 out nocopy JTF_NUMBER_TABLE
653: , a6 out nocopy JTF_NUMBER_TABLE
654: , a7 out nocopy JTF_NUMBER_TABLE
655: , a8 out nocopy JTF_VARCHAR2_TABLE_100
648: , a1 out nocopy JTF_VARCHAR2_TABLE_100
649: , a2 out nocopy JTF_NUMBER_TABLE
650: , a3 out nocopy JTF_NUMBER_TABLE
651: , a4 out nocopy JTF_NUMBER_TABLE
652: , a5 out nocopy JTF_NUMBER_TABLE
653: , a6 out nocopy JTF_NUMBER_TABLE
654: , a7 out nocopy JTF_NUMBER_TABLE
655: , a8 out nocopy JTF_VARCHAR2_TABLE_100
656: , a9 out nocopy JTF_NUMBER_TABLE
649: , a2 out nocopy JTF_NUMBER_TABLE
650: , a3 out nocopy JTF_NUMBER_TABLE
651: , a4 out nocopy JTF_NUMBER_TABLE
652: , a5 out nocopy JTF_NUMBER_TABLE
653: , a6 out nocopy JTF_NUMBER_TABLE
654: , a7 out nocopy JTF_NUMBER_TABLE
655: , a8 out nocopy JTF_VARCHAR2_TABLE_100
656: , a9 out nocopy JTF_NUMBER_TABLE
657: , a10 out nocopy JTF_NUMBER_TABLE
650: , a3 out nocopy JTF_NUMBER_TABLE
651: , a4 out nocopy JTF_NUMBER_TABLE
652: , a5 out nocopy JTF_NUMBER_TABLE
653: , a6 out nocopy JTF_NUMBER_TABLE
654: , a7 out nocopy JTF_NUMBER_TABLE
655: , a8 out nocopy JTF_VARCHAR2_TABLE_100
656: , a9 out nocopy JTF_NUMBER_TABLE
657: , a10 out nocopy JTF_NUMBER_TABLE
658: ) as
652: , a5 out nocopy JTF_NUMBER_TABLE
653: , a6 out nocopy JTF_NUMBER_TABLE
654: , a7 out nocopy JTF_NUMBER_TABLE
655: , a8 out nocopy JTF_VARCHAR2_TABLE_100
656: , a9 out nocopy JTF_NUMBER_TABLE
657: , a10 out nocopy JTF_NUMBER_TABLE
658: ) as
659: ddindx binary_integer; indx binary_integer;
660: begin
653: , a6 out nocopy JTF_NUMBER_TABLE
654: , a7 out nocopy JTF_NUMBER_TABLE
655: , a8 out nocopy JTF_VARCHAR2_TABLE_100
656: , a9 out nocopy JTF_NUMBER_TABLE
657: , a10 out nocopy JTF_NUMBER_TABLE
658: ) as
659: ddindx binary_integer; indx binary_integer;
660: begin
661: if t is null or t.count = 0 then
658: ) as
659: ddindx binary_integer; indx binary_integer;
660: begin
661: if t is null or t.count = 0 then
662: a0 := JTF_NUMBER_TABLE();
663: a1 := JTF_VARCHAR2_TABLE_100();
664: a2 := JTF_NUMBER_TABLE();
665: a3 := JTF_NUMBER_TABLE();
666: a4 := JTF_NUMBER_TABLE();
660: begin
661: if t is null or t.count = 0 then
662: a0 := JTF_NUMBER_TABLE();
663: a1 := JTF_VARCHAR2_TABLE_100();
664: a2 := JTF_NUMBER_TABLE();
665: a3 := JTF_NUMBER_TABLE();
666: a4 := JTF_NUMBER_TABLE();
667: a5 := JTF_NUMBER_TABLE();
668: a6 := JTF_NUMBER_TABLE();
661: if t is null or t.count = 0 then
662: a0 := JTF_NUMBER_TABLE();
663: a1 := JTF_VARCHAR2_TABLE_100();
664: a2 := JTF_NUMBER_TABLE();
665: a3 := JTF_NUMBER_TABLE();
666: a4 := JTF_NUMBER_TABLE();
667: a5 := JTF_NUMBER_TABLE();
668: a6 := JTF_NUMBER_TABLE();
669: a7 := JTF_NUMBER_TABLE();
662: a0 := JTF_NUMBER_TABLE();
663: a1 := JTF_VARCHAR2_TABLE_100();
664: a2 := JTF_NUMBER_TABLE();
665: a3 := JTF_NUMBER_TABLE();
666: a4 := JTF_NUMBER_TABLE();
667: a5 := JTF_NUMBER_TABLE();
668: a6 := JTF_NUMBER_TABLE();
669: a7 := JTF_NUMBER_TABLE();
670: a8 := JTF_VARCHAR2_TABLE_100();
663: a1 := JTF_VARCHAR2_TABLE_100();
664: a2 := JTF_NUMBER_TABLE();
665: a3 := JTF_NUMBER_TABLE();
666: a4 := JTF_NUMBER_TABLE();
667: a5 := JTF_NUMBER_TABLE();
668: a6 := JTF_NUMBER_TABLE();
669: a7 := JTF_NUMBER_TABLE();
670: a8 := JTF_VARCHAR2_TABLE_100();
671: a9 := JTF_NUMBER_TABLE();
664: a2 := JTF_NUMBER_TABLE();
665: a3 := JTF_NUMBER_TABLE();
666: a4 := JTF_NUMBER_TABLE();
667: a5 := JTF_NUMBER_TABLE();
668: a6 := JTF_NUMBER_TABLE();
669: a7 := JTF_NUMBER_TABLE();
670: a8 := JTF_VARCHAR2_TABLE_100();
671: a9 := JTF_NUMBER_TABLE();
672: a10 := JTF_NUMBER_TABLE();
665: a3 := JTF_NUMBER_TABLE();
666: a4 := JTF_NUMBER_TABLE();
667: a5 := JTF_NUMBER_TABLE();
668: a6 := JTF_NUMBER_TABLE();
669: a7 := JTF_NUMBER_TABLE();
670: a8 := JTF_VARCHAR2_TABLE_100();
671: a9 := JTF_NUMBER_TABLE();
672: a10 := JTF_NUMBER_TABLE();
673: else
667: a5 := JTF_NUMBER_TABLE();
668: a6 := JTF_NUMBER_TABLE();
669: a7 := JTF_NUMBER_TABLE();
670: a8 := JTF_VARCHAR2_TABLE_100();
671: a9 := JTF_NUMBER_TABLE();
672: a10 := JTF_NUMBER_TABLE();
673: else
674: a0 := JTF_NUMBER_TABLE();
675: a1 := JTF_VARCHAR2_TABLE_100();
668: a6 := JTF_NUMBER_TABLE();
669: a7 := JTF_NUMBER_TABLE();
670: a8 := JTF_VARCHAR2_TABLE_100();
671: a9 := JTF_NUMBER_TABLE();
672: a10 := JTF_NUMBER_TABLE();
673: else
674: a0 := JTF_NUMBER_TABLE();
675: a1 := JTF_VARCHAR2_TABLE_100();
676: a2 := JTF_NUMBER_TABLE();
670: a8 := JTF_VARCHAR2_TABLE_100();
671: a9 := JTF_NUMBER_TABLE();
672: a10 := JTF_NUMBER_TABLE();
673: else
674: a0 := JTF_NUMBER_TABLE();
675: a1 := JTF_VARCHAR2_TABLE_100();
676: a2 := JTF_NUMBER_TABLE();
677: a3 := JTF_NUMBER_TABLE();
678: a4 := JTF_NUMBER_TABLE();
672: a10 := JTF_NUMBER_TABLE();
673: else
674: a0 := JTF_NUMBER_TABLE();
675: a1 := JTF_VARCHAR2_TABLE_100();
676: a2 := JTF_NUMBER_TABLE();
677: a3 := JTF_NUMBER_TABLE();
678: a4 := JTF_NUMBER_TABLE();
679: a5 := JTF_NUMBER_TABLE();
680: a6 := JTF_NUMBER_TABLE();
673: else
674: a0 := JTF_NUMBER_TABLE();
675: a1 := JTF_VARCHAR2_TABLE_100();
676: a2 := JTF_NUMBER_TABLE();
677: a3 := JTF_NUMBER_TABLE();
678: a4 := JTF_NUMBER_TABLE();
679: a5 := JTF_NUMBER_TABLE();
680: a6 := JTF_NUMBER_TABLE();
681: a7 := JTF_NUMBER_TABLE();
674: a0 := JTF_NUMBER_TABLE();
675: a1 := JTF_VARCHAR2_TABLE_100();
676: a2 := JTF_NUMBER_TABLE();
677: a3 := JTF_NUMBER_TABLE();
678: a4 := JTF_NUMBER_TABLE();
679: a5 := JTF_NUMBER_TABLE();
680: a6 := JTF_NUMBER_TABLE();
681: a7 := JTF_NUMBER_TABLE();
682: a8 := JTF_VARCHAR2_TABLE_100();
675: a1 := JTF_VARCHAR2_TABLE_100();
676: a2 := JTF_NUMBER_TABLE();
677: a3 := JTF_NUMBER_TABLE();
678: a4 := JTF_NUMBER_TABLE();
679: a5 := JTF_NUMBER_TABLE();
680: a6 := JTF_NUMBER_TABLE();
681: a7 := JTF_NUMBER_TABLE();
682: a8 := JTF_VARCHAR2_TABLE_100();
683: a9 := JTF_NUMBER_TABLE();
676: a2 := JTF_NUMBER_TABLE();
677: a3 := JTF_NUMBER_TABLE();
678: a4 := JTF_NUMBER_TABLE();
679: a5 := JTF_NUMBER_TABLE();
680: a6 := JTF_NUMBER_TABLE();
681: a7 := JTF_NUMBER_TABLE();
682: a8 := JTF_VARCHAR2_TABLE_100();
683: a9 := JTF_NUMBER_TABLE();
684: a10 := JTF_NUMBER_TABLE();
677: a3 := JTF_NUMBER_TABLE();
678: a4 := JTF_NUMBER_TABLE();
679: a5 := JTF_NUMBER_TABLE();
680: a6 := JTF_NUMBER_TABLE();
681: a7 := JTF_NUMBER_TABLE();
682: a8 := JTF_VARCHAR2_TABLE_100();
683: a9 := JTF_NUMBER_TABLE();
684: a10 := JTF_NUMBER_TABLE();
685: if t.count > 0 then
679: a5 := JTF_NUMBER_TABLE();
680: a6 := JTF_NUMBER_TABLE();
681: a7 := JTF_NUMBER_TABLE();
682: a8 := JTF_VARCHAR2_TABLE_100();
683: a9 := JTF_NUMBER_TABLE();
684: a10 := JTF_NUMBER_TABLE();
685: if t.count > 0 then
686: a0.extend(t.count);
687: a1.extend(t.count);
680: a6 := JTF_NUMBER_TABLE();
681: a7 := JTF_NUMBER_TABLE();
682: a8 := JTF_VARCHAR2_TABLE_100();
683: a9 := JTF_NUMBER_TABLE();
684: a10 := JTF_NUMBER_TABLE();
685: if t.count > 0 then
686: a0.extend(t.count);
687: a1.extend(t.count);
688: a2.extend(t.count);
949:
950: procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
951: , x_msg_count out nocopy NUMBER
952: , x_msg_data out nocopy VARCHAR2
953: , p3_a0 in out nocopy JTF_NUMBER_TABLE
954: , p3_a1 in out nocopy JTF_NUMBER_TABLE
955: , p3_a2 in out nocopy JTF_NUMBER_TABLE
956: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
957: , p3_a4 in out nocopy JTF_NUMBER_TABLE
950: procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
951: , x_msg_count out nocopy NUMBER
952: , x_msg_data out nocopy VARCHAR2
953: , p3_a0 in out nocopy JTF_NUMBER_TABLE
954: , p3_a1 in out nocopy JTF_NUMBER_TABLE
955: , p3_a2 in out nocopy JTF_NUMBER_TABLE
956: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
957: , p3_a4 in out nocopy JTF_NUMBER_TABLE
958: , p3_a5 in out nocopy JTF_NUMBER_TABLE
951: , x_msg_count out nocopy NUMBER
952: , x_msg_data out nocopy VARCHAR2
953: , p3_a0 in out nocopy JTF_NUMBER_TABLE
954: , p3_a1 in out nocopy JTF_NUMBER_TABLE
955: , p3_a2 in out nocopy JTF_NUMBER_TABLE
956: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
957: , p3_a4 in out nocopy JTF_NUMBER_TABLE
958: , p3_a5 in out nocopy JTF_NUMBER_TABLE
959: , p3_a6 in out nocopy JTF_NUMBER_TABLE
953: , p3_a0 in out nocopy JTF_NUMBER_TABLE
954: , p3_a1 in out nocopy JTF_NUMBER_TABLE
955: , p3_a2 in out nocopy JTF_NUMBER_TABLE
956: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
957: , p3_a4 in out nocopy JTF_NUMBER_TABLE
958: , p3_a5 in out nocopy JTF_NUMBER_TABLE
959: , p3_a6 in out nocopy JTF_NUMBER_TABLE
960: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
961: , p3_a8 in out nocopy JTF_NUMBER_TABLE
954: , p3_a1 in out nocopy JTF_NUMBER_TABLE
955: , p3_a2 in out nocopy JTF_NUMBER_TABLE
956: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
957: , p3_a4 in out nocopy JTF_NUMBER_TABLE
958: , p3_a5 in out nocopy JTF_NUMBER_TABLE
959: , p3_a6 in out nocopy JTF_NUMBER_TABLE
960: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
961: , p3_a8 in out nocopy JTF_NUMBER_TABLE
962: , p3_a9 in out nocopy JTF_NUMBER_TABLE
955: , p3_a2 in out nocopy JTF_NUMBER_TABLE
956: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
957: , p3_a4 in out nocopy JTF_NUMBER_TABLE
958: , p3_a5 in out nocopy JTF_NUMBER_TABLE
959: , p3_a6 in out nocopy JTF_NUMBER_TABLE
960: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
961: , p3_a8 in out nocopy JTF_NUMBER_TABLE
962: , p3_a9 in out nocopy JTF_NUMBER_TABLE
963: , p3_a10 in out nocopy JTF_DATE_TABLE
957: , p3_a4 in out nocopy JTF_NUMBER_TABLE
958: , p3_a5 in out nocopy JTF_NUMBER_TABLE
959: , p3_a6 in out nocopy JTF_NUMBER_TABLE
960: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
961: , p3_a8 in out nocopy JTF_NUMBER_TABLE
962: , p3_a9 in out nocopy JTF_NUMBER_TABLE
963: , p3_a10 in out nocopy JTF_DATE_TABLE
964: , p3_a11 in out nocopy JTF_DATE_TABLE
965: , p3_a12 in out nocopy JTF_DATE_TABLE
958: , p3_a5 in out nocopy JTF_NUMBER_TABLE
959: , p3_a6 in out nocopy JTF_NUMBER_TABLE
960: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
961: , p3_a8 in out nocopy JTF_NUMBER_TABLE
962: , p3_a9 in out nocopy JTF_NUMBER_TABLE
963: , p3_a10 in out nocopy JTF_DATE_TABLE
964: , p3_a11 in out nocopy JTF_DATE_TABLE
965: , p3_a12 in out nocopy JTF_DATE_TABLE
966: , p3_a13 in out nocopy JTF_DATE_TABLE
1024: );
1025: end;
1026:
1027: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
1028: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1029: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1031: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1025: end;
1026:
1027: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
1028: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1029: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1031: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1033: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1026:
1027: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
1028: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1029: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1031: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1033: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1034: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1028: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1029: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1031: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1033: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1034: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1036: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1029: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1031: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1033: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1034: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1036: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1037: , p1_a9 in out nocopy JTF_NUMBER_TABLE
1030: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1031: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1033: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1034: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1036: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1037: , p1_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p1_a10 in out nocopy JTF_DATE_TABLE
1032: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1033: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1034: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1036: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1037: , p1_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p1_a10 in out nocopy JTF_DATE_TABLE
1039: , p1_a11 in out nocopy JTF_DATE_TABLE
1040: , p1_a12 in out nocopy JTF_DATE_TABLE
1033: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1034: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1036: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1037: , p1_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p1_a10 in out nocopy JTF_DATE_TABLE
1039: , p1_a11 in out nocopy JTF_DATE_TABLE
1040: , p1_a12 in out nocopy JTF_DATE_TABLE
1041: , p1_a13 in out nocopy JTF_DATE_TABLE