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_p2(t out nocopy ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_NUMBER_TABLE
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_DATE_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
26: ) as
49: end loop;
50: end if;
51: end if;
52: end rosetta_table_copy_in_p2;
53: procedure rosetta_table_copy_out_p2(t ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_NUMBER_TABLE
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: , a4 out nocopy JTF_NUMBER_TABLE
50: end if;
51: end if;
52: end rosetta_table_copy_in_p2;
53: procedure rosetta_table_copy_out_p2(t ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_NUMBER_TABLE
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: , a4 out nocopy JTF_NUMBER_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
51: end if;
52: end rosetta_table_copy_in_p2;
53: procedure rosetta_table_copy_out_p2(t ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_NUMBER_TABLE
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: , a4 out nocopy JTF_NUMBER_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
53: procedure rosetta_table_copy_out_p2(t ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_NUMBER_TABLE
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: , a4 out nocopy JTF_NUMBER_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_DATE_TABLE
61: , a8 out nocopy JTF_DATE_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_NUMBER_TABLE
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: , a4 out nocopy JTF_NUMBER_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_DATE_TABLE
61: , a8 out nocopy JTF_DATE_TABLE
62: , a9 out nocopy JTF_VARCHAR2_TABLE_100
55: , a2 out nocopy JTF_NUMBER_TABLE
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: , a4 out nocopy JTF_NUMBER_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_DATE_TABLE
61: , a8 out nocopy JTF_DATE_TABLE
62: , a9 out nocopy JTF_VARCHAR2_TABLE_100
63: ) as
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_VARCHAR2_TABLE_300();
71: a4 := JTF_NUMBER_TABLE();
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_VARCHAR2_TABLE_300();
71: a4 := JTF_NUMBER_TABLE();
72: a5 := JTF_NUMBER_TABLE();
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_VARCHAR2_TABLE_300();
71: a4 := JTF_NUMBER_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_VARCHAR2_TABLE_300();
71: a4 := JTF_NUMBER_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_DATE_TABLE();
75: a8 := JTF_DATE_TABLE();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_VARCHAR2_TABLE_300();
71: a4 := JTF_NUMBER_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_DATE_TABLE();
75: a8 := JTF_DATE_TABLE();
76: a9 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_VARCHAR2_TABLE_300();
71: a4 := JTF_NUMBER_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_DATE_TABLE();
75: a8 := JTF_DATE_TABLE();
76: a9 := JTF_VARCHAR2_TABLE_100();
77: else
74: a7 := JTF_DATE_TABLE();
75: a8 := JTF_DATE_TABLE();
76: a9 := JTF_VARCHAR2_TABLE_100();
77: else
78: a0 := JTF_NUMBER_TABLE();
79: a1 := JTF_NUMBER_TABLE();
80: a2 := JTF_NUMBER_TABLE();
81: a3 := JTF_VARCHAR2_TABLE_300();
82: a4 := JTF_NUMBER_TABLE();
75: a8 := JTF_DATE_TABLE();
76: a9 := JTF_VARCHAR2_TABLE_100();
77: else
78: a0 := JTF_NUMBER_TABLE();
79: a1 := JTF_NUMBER_TABLE();
80: a2 := JTF_NUMBER_TABLE();
81: a3 := JTF_VARCHAR2_TABLE_300();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_NUMBER_TABLE();
76: a9 := JTF_VARCHAR2_TABLE_100();
77: else
78: a0 := JTF_NUMBER_TABLE();
79: a1 := JTF_NUMBER_TABLE();
80: a2 := JTF_NUMBER_TABLE();
81: a3 := JTF_VARCHAR2_TABLE_300();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
78: a0 := JTF_NUMBER_TABLE();
79: a1 := JTF_NUMBER_TABLE();
80: a2 := JTF_NUMBER_TABLE();
81: a3 := JTF_VARCHAR2_TABLE_300();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_DATE_TABLE();
86: a8 := JTF_DATE_TABLE();
79: a1 := JTF_NUMBER_TABLE();
80: a2 := JTF_NUMBER_TABLE();
81: a3 := JTF_VARCHAR2_TABLE_300();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_DATE_TABLE();
86: a8 := JTF_DATE_TABLE();
87: a9 := JTF_VARCHAR2_TABLE_100();
80: a2 := JTF_NUMBER_TABLE();
81: a3 := JTF_VARCHAR2_TABLE_300();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_DATE_TABLE();
86: a8 := JTF_DATE_TABLE();
87: a9 := JTF_VARCHAR2_TABLE_100();
88: if t.count > 0 then
118: end if;
119: end if;
120: end rosetta_table_copy_out_p2;
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_NUMBER_TABLE
125: , a3 JTF_NUMBER_TABLE
126: , a4 JTF_NUMBER_TABLE
119: end if;
120: end rosetta_table_copy_out_p2;
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_NUMBER_TABLE
125: , a3 JTF_NUMBER_TABLE
126: , a4 JTF_NUMBER_TABLE
127: , a5 JTF_NUMBER_TABLE
120: end rosetta_table_copy_out_p2;
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_NUMBER_TABLE
125: , a3 JTF_NUMBER_TABLE
126: , a4 JTF_NUMBER_TABLE
127: , a5 JTF_NUMBER_TABLE
128: , a6 JTF_NUMBER_TABLE
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_NUMBER_TABLE
125: , a3 JTF_NUMBER_TABLE
126: , a4 JTF_NUMBER_TABLE
127: , a5 JTF_NUMBER_TABLE
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_VARCHAR2_TABLE_100
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_NUMBER_TABLE
125: , a3 JTF_NUMBER_TABLE
126: , a4 JTF_NUMBER_TABLE
127: , a5 JTF_NUMBER_TABLE
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_VARCHAR2_TABLE_100
130: , a8 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_NUMBER_TABLE
125: , a3 JTF_NUMBER_TABLE
126: , a4 JTF_NUMBER_TABLE
127: , a5 JTF_NUMBER_TABLE
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_VARCHAR2_TABLE_100
130: , a8 JTF_NUMBER_TABLE
131: , a9 JTF_NUMBER_TABLE
124: , a2 JTF_NUMBER_TABLE
125: , a3 JTF_NUMBER_TABLE
126: , a4 JTF_NUMBER_TABLE
127: , a5 JTF_NUMBER_TABLE
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_VARCHAR2_TABLE_100
130: , a8 JTF_NUMBER_TABLE
131: , a9 JTF_NUMBER_TABLE
132: , a10 JTF_NUMBER_TABLE
126: , a4 JTF_NUMBER_TABLE
127: , a5 JTF_NUMBER_TABLE
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_VARCHAR2_TABLE_100
130: , a8 JTF_NUMBER_TABLE
131: , a9 JTF_NUMBER_TABLE
132: , a10 JTF_NUMBER_TABLE
133: , a11 JTF_NUMBER_TABLE
134: , a12 JTF_NUMBER_TABLE
127: , a5 JTF_NUMBER_TABLE
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_VARCHAR2_TABLE_100
130: , a8 JTF_NUMBER_TABLE
131: , a9 JTF_NUMBER_TABLE
132: , a10 JTF_NUMBER_TABLE
133: , a11 JTF_NUMBER_TABLE
134: , a12 JTF_NUMBER_TABLE
135: , a13 JTF_NUMBER_TABLE
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_VARCHAR2_TABLE_100
130: , a8 JTF_NUMBER_TABLE
131: , a9 JTF_NUMBER_TABLE
132: , a10 JTF_NUMBER_TABLE
133: , a11 JTF_NUMBER_TABLE
134: , a12 JTF_NUMBER_TABLE
135: , a13 JTF_NUMBER_TABLE
136: , a14 JTF_NUMBER_TABLE
129: , a7 JTF_VARCHAR2_TABLE_100
130: , a8 JTF_NUMBER_TABLE
131: , a9 JTF_NUMBER_TABLE
132: , a10 JTF_NUMBER_TABLE
133: , a11 JTF_NUMBER_TABLE
134: , a12 JTF_NUMBER_TABLE
135: , a13 JTF_NUMBER_TABLE
136: , a14 JTF_NUMBER_TABLE
137: , a15 JTF_NUMBER_TABLE
130: , a8 JTF_NUMBER_TABLE
131: , a9 JTF_NUMBER_TABLE
132: , a10 JTF_NUMBER_TABLE
133: , a11 JTF_NUMBER_TABLE
134: , a12 JTF_NUMBER_TABLE
135: , a13 JTF_NUMBER_TABLE
136: , a14 JTF_NUMBER_TABLE
137: , a15 JTF_NUMBER_TABLE
138: , a16 JTF_NUMBER_TABLE
131: , a9 JTF_NUMBER_TABLE
132: , a10 JTF_NUMBER_TABLE
133: , a11 JTF_NUMBER_TABLE
134: , a12 JTF_NUMBER_TABLE
135: , a13 JTF_NUMBER_TABLE
136: , a14 JTF_NUMBER_TABLE
137: , a15 JTF_NUMBER_TABLE
138: , a16 JTF_NUMBER_TABLE
139: , a17 JTF_VARCHAR2_TABLE_300
132: , a10 JTF_NUMBER_TABLE
133: , a11 JTF_NUMBER_TABLE
134: , a12 JTF_NUMBER_TABLE
135: , a13 JTF_NUMBER_TABLE
136: , a14 JTF_NUMBER_TABLE
137: , a15 JTF_NUMBER_TABLE
138: , a16 JTF_NUMBER_TABLE
139: , a17 JTF_VARCHAR2_TABLE_300
140: , a18 JTF_DATE_TABLE
133: , a11 JTF_NUMBER_TABLE
134: , a12 JTF_NUMBER_TABLE
135: , a13 JTF_NUMBER_TABLE
136: , a14 JTF_NUMBER_TABLE
137: , a15 JTF_NUMBER_TABLE
138: , a16 JTF_NUMBER_TABLE
139: , a17 JTF_VARCHAR2_TABLE_300
140: , a18 JTF_DATE_TABLE
141: , a19 JTF_DATE_TABLE
134: , a12 JTF_NUMBER_TABLE
135: , a13 JTF_NUMBER_TABLE
136: , a14 JTF_NUMBER_TABLE
137: , a15 JTF_NUMBER_TABLE
138: , a16 JTF_NUMBER_TABLE
139: , a17 JTF_VARCHAR2_TABLE_300
140: , a18 JTF_DATE_TABLE
141: , a19 JTF_DATE_TABLE
142: , a20 JTF_NUMBER_TABLE
138: , a16 JTF_NUMBER_TABLE
139: , a17 JTF_VARCHAR2_TABLE_300
140: , a18 JTF_DATE_TABLE
141: , a19 JTF_DATE_TABLE
142: , a20 JTF_NUMBER_TABLE
143: , a21 JTF_VARCHAR2_TABLE_100
144: ) as
145: ddindx binary_integer; indx binary_integer;
146: begin
179: end loop;
180: end if;
181: end if;
182: end rosetta_table_copy_in_p4;
183: procedure rosetta_table_copy_out_p4(t ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_NUMBER_TABLE
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE
180: end if;
181: end if;
182: end rosetta_table_copy_in_p4;
183: procedure rosetta_table_copy_out_p4(t ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_NUMBER_TABLE
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE
188: , a5 out nocopy JTF_NUMBER_TABLE
181: end if;
182: end rosetta_table_copy_in_p4;
183: procedure rosetta_table_copy_out_p4(t ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_NUMBER_TABLE
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE
188: , a5 out nocopy JTF_NUMBER_TABLE
189: , a6 out nocopy JTF_NUMBER_TABLE
182: end rosetta_table_copy_in_p4;
183: procedure rosetta_table_copy_out_p4(t ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_NUMBER_TABLE
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE
188: , a5 out nocopy JTF_NUMBER_TABLE
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_VARCHAR2_TABLE_100
183: procedure rosetta_table_copy_out_p4(t ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_NUMBER_TABLE
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE
188: , a5 out nocopy JTF_NUMBER_TABLE
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_VARCHAR2_TABLE_100
191: , a8 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_NUMBER_TABLE
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE
188: , a5 out nocopy JTF_NUMBER_TABLE
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_VARCHAR2_TABLE_100
191: , a8 out nocopy JTF_NUMBER_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_NUMBER_TABLE
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE
188: , a5 out nocopy JTF_NUMBER_TABLE
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_VARCHAR2_TABLE_100
191: , a8 out nocopy JTF_NUMBER_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE
188: , a5 out nocopy JTF_NUMBER_TABLE
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_VARCHAR2_TABLE_100
191: , a8 out nocopy JTF_NUMBER_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_NUMBER_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: , a12 out nocopy JTF_NUMBER_TABLE
188: , a5 out nocopy JTF_NUMBER_TABLE
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_VARCHAR2_TABLE_100
191: , a8 out nocopy JTF_NUMBER_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_NUMBER_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: , a12 out nocopy JTF_NUMBER_TABLE
196: , a13 out nocopy JTF_NUMBER_TABLE
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_VARCHAR2_TABLE_100
191: , a8 out nocopy JTF_NUMBER_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_NUMBER_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: , a12 out nocopy JTF_NUMBER_TABLE
196: , a13 out nocopy JTF_NUMBER_TABLE
197: , a14 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_VARCHAR2_TABLE_100
191: , a8 out nocopy JTF_NUMBER_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_NUMBER_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: , a12 out nocopy JTF_NUMBER_TABLE
196: , a13 out nocopy JTF_NUMBER_TABLE
197: , a14 out nocopy JTF_NUMBER_TABLE
198: , a15 out nocopy JTF_NUMBER_TABLE
191: , a8 out nocopy JTF_NUMBER_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_NUMBER_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: , a12 out nocopy JTF_NUMBER_TABLE
196: , a13 out nocopy JTF_NUMBER_TABLE
197: , a14 out nocopy JTF_NUMBER_TABLE
198: , a15 out nocopy JTF_NUMBER_TABLE
199: , a16 out nocopy JTF_NUMBER_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_NUMBER_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: , a12 out nocopy JTF_NUMBER_TABLE
196: , a13 out nocopy JTF_NUMBER_TABLE
197: , a14 out nocopy JTF_NUMBER_TABLE
198: , a15 out nocopy JTF_NUMBER_TABLE
199: , a16 out nocopy JTF_NUMBER_TABLE
200: , a17 out nocopy JTF_VARCHAR2_TABLE_300
193: , a10 out nocopy JTF_NUMBER_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: , a12 out nocopy JTF_NUMBER_TABLE
196: , a13 out nocopy JTF_NUMBER_TABLE
197: , a14 out nocopy JTF_NUMBER_TABLE
198: , a15 out nocopy JTF_NUMBER_TABLE
199: , a16 out nocopy JTF_NUMBER_TABLE
200: , a17 out nocopy JTF_VARCHAR2_TABLE_300
201: , a18 out nocopy JTF_DATE_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: , a12 out nocopy JTF_NUMBER_TABLE
196: , a13 out nocopy JTF_NUMBER_TABLE
197: , a14 out nocopy JTF_NUMBER_TABLE
198: , a15 out nocopy JTF_NUMBER_TABLE
199: , a16 out nocopy JTF_NUMBER_TABLE
200: , a17 out nocopy JTF_VARCHAR2_TABLE_300
201: , a18 out nocopy JTF_DATE_TABLE
202: , a19 out nocopy JTF_DATE_TABLE
195: , a12 out nocopy JTF_NUMBER_TABLE
196: , a13 out nocopy JTF_NUMBER_TABLE
197: , a14 out nocopy JTF_NUMBER_TABLE
198: , a15 out nocopy JTF_NUMBER_TABLE
199: , a16 out nocopy JTF_NUMBER_TABLE
200: , a17 out nocopy JTF_VARCHAR2_TABLE_300
201: , a18 out nocopy JTF_DATE_TABLE
202: , a19 out nocopy JTF_DATE_TABLE
203: , a20 out nocopy JTF_NUMBER_TABLE
199: , a16 out nocopy JTF_NUMBER_TABLE
200: , a17 out nocopy JTF_VARCHAR2_TABLE_300
201: , a18 out nocopy JTF_DATE_TABLE
202: , a19 out nocopy JTF_DATE_TABLE
203: , a20 out nocopy JTF_NUMBER_TABLE
204: , a21 out nocopy JTF_VARCHAR2_TABLE_100
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_NUMBER_TABLE();
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_NUMBER_TABLE();
207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_NUMBER_TABLE();
215: a6 := JTF_NUMBER_TABLE();
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_NUMBER_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_NUMBER_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_NUMBER_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_NUMBER_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_NUMBER_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
214: a5 := JTF_NUMBER_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: a13 := JTF_NUMBER_TABLE();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
218: a9 := JTF_NUMBER_TABLE();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_VARCHAR2_TABLE_300();
227: a18 := JTF_DATE_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_VARCHAR2_TABLE_300();
227: a18 := JTF_DATE_TABLE();
228: a19 := JTF_DATE_TABLE();
221: a12 := JTF_NUMBER_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_VARCHAR2_TABLE_300();
227: a18 := JTF_DATE_TABLE();
228: a19 := JTF_DATE_TABLE();
229: a20 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_VARCHAR2_TABLE_300();
227: a18 := JTF_DATE_TABLE();
228: a19 := JTF_DATE_TABLE();
229: a20 := JTF_NUMBER_TABLE();
230: a21 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_NUMBER_TABLE();
233: a1 := JTF_NUMBER_TABLE();
228: a19 := JTF_DATE_TABLE();
229: a20 := JTF_NUMBER_TABLE();
230: a21 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_NUMBER_TABLE();
233: a1 := JTF_NUMBER_TABLE();
234: a2 := JTF_NUMBER_TABLE();
235: a3 := JTF_NUMBER_TABLE();
236: a4 := JTF_NUMBER_TABLE();
229: a20 := JTF_NUMBER_TABLE();
230: a21 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_NUMBER_TABLE();
233: a1 := JTF_NUMBER_TABLE();
234: a2 := JTF_NUMBER_TABLE();
235: a3 := JTF_NUMBER_TABLE();
236: a4 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
230: a21 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_NUMBER_TABLE();
233: a1 := JTF_NUMBER_TABLE();
234: a2 := JTF_NUMBER_TABLE();
235: a3 := JTF_NUMBER_TABLE();
236: a4 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
231: else
232: a0 := JTF_NUMBER_TABLE();
233: a1 := JTF_NUMBER_TABLE();
234: a2 := JTF_NUMBER_TABLE();
235: a3 := JTF_NUMBER_TABLE();
236: a4 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_VARCHAR2_TABLE_100();
232: a0 := JTF_NUMBER_TABLE();
233: a1 := JTF_NUMBER_TABLE();
234: a2 := JTF_NUMBER_TABLE();
235: a3 := JTF_NUMBER_TABLE();
236: a4 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_NUMBER_TABLE();
233: a1 := JTF_NUMBER_TABLE();
234: a2 := JTF_NUMBER_TABLE();
235: a3 := JTF_NUMBER_TABLE();
236: a4 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
234: a2 := JTF_NUMBER_TABLE();
235: a3 := JTF_NUMBER_TABLE();
236: a4 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_NUMBER_TABLE();
236: a4 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_NUMBER_TABLE();
243: a11 := JTF_NUMBER_TABLE();
244: a12 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_NUMBER_TABLE();
243: a11 := JTF_NUMBER_TABLE();
244: a12 := JTF_NUMBER_TABLE();
245: a13 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_NUMBER_TABLE();
243: a11 := JTF_NUMBER_TABLE();
244: a12 := JTF_NUMBER_TABLE();
245: a13 := JTF_NUMBER_TABLE();
246: a14 := JTF_NUMBER_TABLE();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_NUMBER_TABLE();
243: a11 := JTF_NUMBER_TABLE();
244: a12 := JTF_NUMBER_TABLE();
245: a13 := JTF_NUMBER_TABLE();
246: a14 := JTF_NUMBER_TABLE();
247: a15 := JTF_NUMBER_TABLE();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_NUMBER_TABLE();
243: a11 := JTF_NUMBER_TABLE();
244: a12 := JTF_NUMBER_TABLE();
245: a13 := JTF_NUMBER_TABLE();
246: a14 := JTF_NUMBER_TABLE();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_NUMBER_TABLE();
243: a11 := JTF_NUMBER_TABLE();
244: a12 := JTF_NUMBER_TABLE();
245: a13 := JTF_NUMBER_TABLE();
246: a14 := JTF_NUMBER_TABLE();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_VARCHAR2_TABLE_300();
242: a10 := JTF_NUMBER_TABLE();
243: a11 := JTF_NUMBER_TABLE();
244: a12 := JTF_NUMBER_TABLE();
245: a13 := JTF_NUMBER_TABLE();
246: a14 := JTF_NUMBER_TABLE();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_VARCHAR2_TABLE_300();
250: a18 := JTF_DATE_TABLE();
243: a11 := JTF_NUMBER_TABLE();
244: a12 := JTF_NUMBER_TABLE();
245: a13 := JTF_NUMBER_TABLE();
246: a14 := JTF_NUMBER_TABLE();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_VARCHAR2_TABLE_300();
250: a18 := JTF_DATE_TABLE();
251: a19 := JTF_DATE_TABLE();
244: a12 := JTF_NUMBER_TABLE();
245: a13 := JTF_NUMBER_TABLE();
246: a14 := JTF_NUMBER_TABLE();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_VARCHAR2_TABLE_300();
250: a18 := JTF_DATE_TABLE();
251: a19 := JTF_DATE_TABLE();
252: a20 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_VARCHAR2_TABLE_300();
250: a18 := JTF_DATE_TABLE();
251: a19 := JTF_DATE_TABLE();
252: a20 := JTF_NUMBER_TABLE();
253: a21 := JTF_VARCHAR2_TABLE_100();
254: if t.count > 0 then
255: a0.extend(t.count);
256: a1.extend(t.count);
308: end if;
309: end if;
310: end rosetta_table_copy_out_p4;
311:
312: procedure rosetta_table_copy_in_p6(t out nocopy ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 JTF_NUMBER_TABLE
313: , a1 JTF_NUMBER_TABLE
314: , a2 JTF_NUMBER_TABLE
315: , a3 JTF_NUMBER_TABLE
316: , a4 JTF_NUMBER_TABLE
309: end if;
310: end rosetta_table_copy_out_p4;
311:
312: procedure rosetta_table_copy_in_p6(t out nocopy ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 JTF_NUMBER_TABLE
313: , a1 JTF_NUMBER_TABLE
314: , a2 JTF_NUMBER_TABLE
315: , a3 JTF_NUMBER_TABLE
316: , a4 JTF_NUMBER_TABLE
317: , a5 JTF_NUMBER_TABLE
310: end rosetta_table_copy_out_p4;
311:
312: procedure rosetta_table_copy_in_p6(t out nocopy ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 JTF_NUMBER_TABLE
313: , a1 JTF_NUMBER_TABLE
314: , a2 JTF_NUMBER_TABLE
315: , a3 JTF_NUMBER_TABLE
316: , a4 JTF_NUMBER_TABLE
317: , a5 JTF_NUMBER_TABLE
318: , a6 JTF_NUMBER_TABLE
311:
312: procedure rosetta_table_copy_in_p6(t out nocopy ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 JTF_NUMBER_TABLE
313: , a1 JTF_NUMBER_TABLE
314: , a2 JTF_NUMBER_TABLE
315: , a3 JTF_NUMBER_TABLE
316: , a4 JTF_NUMBER_TABLE
317: , a5 JTF_NUMBER_TABLE
318: , a6 JTF_NUMBER_TABLE
319: , a7 JTF_NUMBER_TABLE
312: procedure rosetta_table_copy_in_p6(t out nocopy ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 JTF_NUMBER_TABLE
313: , a1 JTF_NUMBER_TABLE
314: , a2 JTF_NUMBER_TABLE
315: , a3 JTF_NUMBER_TABLE
316: , a4 JTF_NUMBER_TABLE
317: , a5 JTF_NUMBER_TABLE
318: , a6 JTF_NUMBER_TABLE
319: , a7 JTF_NUMBER_TABLE
320: , a8 JTF_NUMBER_TABLE
313: , a1 JTF_NUMBER_TABLE
314: , a2 JTF_NUMBER_TABLE
315: , a3 JTF_NUMBER_TABLE
316: , a4 JTF_NUMBER_TABLE
317: , a5 JTF_NUMBER_TABLE
318: , a6 JTF_NUMBER_TABLE
319: , a7 JTF_NUMBER_TABLE
320: , a8 JTF_NUMBER_TABLE
321: , a9 JTF_VARCHAR2_TABLE_100
314: , a2 JTF_NUMBER_TABLE
315: , a3 JTF_NUMBER_TABLE
316: , a4 JTF_NUMBER_TABLE
317: , a5 JTF_NUMBER_TABLE
318: , a6 JTF_NUMBER_TABLE
319: , a7 JTF_NUMBER_TABLE
320: , a8 JTF_NUMBER_TABLE
321: , a9 JTF_VARCHAR2_TABLE_100
322: , a10 JTF_DATE_TABLE
315: , a3 JTF_NUMBER_TABLE
316: , a4 JTF_NUMBER_TABLE
317: , a5 JTF_NUMBER_TABLE
318: , a6 JTF_NUMBER_TABLE
319: , a7 JTF_NUMBER_TABLE
320: , a8 JTF_NUMBER_TABLE
321: , a9 JTF_VARCHAR2_TABLE_100
322: , a10 JTF_DATE_TABLE
323: , a11 JTF_VARCHAR2_TABLE_100
316: , a4 JTF_NUMBER_TABLE
317: , a5 JTF_NUMBER_TABLE
318: , a6 JTF_NUMBER_TABLE
319: , a7 JTF_NUMBER_TABLE
320: , a8 JTF_NUMBER_TABLE
321: , a9 JTF_VARCHAR2_TABLE_100
322: , a10 JTF_DATE_TABLE
323: , a11 JTF_VARCHAR2_TABLE_100
324: ) as
349: end loop;
350: end if;
351: end if;
352: end rosetta_table_copy_in_p6;
353: procedure rosetta_table_copy_out_p6(t ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
354: , a1 out nocopy JTF_NUMBER_TABLE
355: , a2 out nocopy JTF_NUMBER_TABLE
356: , a3 out nocopy JTF_NUMBER_TABLE
357: , a4 out nocopy JTF_NUMBER_TABLE
350: end if;
351: end if;
352: end rosetta_table_copy_in_p6;
353: procedure rosetta_table_copy_out_p6(t ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
354: , a1 out nocopy JTF_NUMBER_TABLE
355: , a2 out nocopy JTF_NUMBER_TABLE
356: , a3 out nocopy JTF_NUMBER_TABLE
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_NUMBER_TABLE
351: end if;
352: end rosetta_table_copy_in_p6;
353: procedure rosetta_table_copy_out_p6(t ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
354: , a1 out nocopy JTF_NUMBER_TABLE
355: , a2 out nocopy JTF_NUMBER_TABLE
356: , a3 out nocopy JTF_NUMBER_TABLE
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_NUMBER_TABLE
359: , a6 out nocopy JTF_NUMBER_TABLE
352: end rosetta_table_copy_in_p6;
353: procedure rosetta_table_copy_out_p6(t ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
354: , a1 out nocopy JTF_NUMBER_TABLE
355: , a2 out nocopy JTF_NUMBER_TABLE
356: , a3 out nocopy JTF_NUMBER_TABLE
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_NUMBER_TABLE
359: , a6 out nocopy JTF_NUMBER_TABLE
360: , a7 out nocopy JTF_NUMBER_TABLE
353: procedure rosetta_table_copy_out_p6(t ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
354: , a1 out nocopy JTF_NUMBER_TABLE
355: , a2 out nocopy JTF_NUMBER_TABLE
356: , a3 out nocopy JTF_NUMBER_TABLE
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_NUMBER_TABLE
359: , a6 out nocopy JTF_NUMBER_TABLE
360: , a7 out nocopy JTF_NUMBER_TABLE
361: , a8 out nocopy JTF_NUMBER_TABLE
354: , a1 out nocopy JTF_NUMBER_TABLE
355: , a2 out nocopy JTF_NUMBER_TABLE
356: , a3 out nocopy JTF_NUMBER_TABLE
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_NUMBER_TABLE
359: , a6 out nocopy JTF_NUMBER_TABLE
360: , a7 out nocopy JTF_NUMBER_TABLE
361: , a8 out nocopy JTF_NUMBER_TABLE
362: , a9 out nocopy JTF_VARCHAR2_TABLE_100
355: , a2 out nocopy JTF_NUMBER_TABLE
356: , a3 out nocopy JTF_NUMBER_TABLE
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_NUMBER_TABLE
359: , a6 out nocopy JTF_NUMBER_TABLE
360: , a7 out nocopy JTF_NUMBER_TABLE
361: , a8 out nocopy JTF_NUMBER_TABLE
362: , a9 out nocopy JTF_VARCHAR2_TABLE_100
363: , a10 out nocopy JTF_DATE_TABLE
356: , a3 out nocopy JTF_NUMBER_TABLE
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_NUMBER_TABLE
359: , a6 out nocopy JTF_NUMBER_TABLE
360: , a7 out nocopy JTF_NUMBER_TABLE
361: , a8 out nocopy JTF_NUMBER_TABLE
362: , a9 out nocopy JTF_VARCHAR2_TABLE_100
363: , a10 out nocopy JTF_DATE_TABLE
364: , a11 out nocopy JTF_VARCHAR2_TABLE_100
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_NUMBER_TABLE
359: , a6 out nocopy JTF_NUMBER_TABLE
360: , a7 out nocopy JTF_NUMBER_TABLE
361: , a8 out nocopy JTF_NUMBER_TABLE
362: , a9 out nocopy JTF_VARCHAR2_TABLE_100
363: , a10 out nocopy JTF_DATE_TABLE
364: , a11 out nocopy JTF_VARCHAR2_TABLE_100
365: ) as
365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_NUMBER_TABLE();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_NUMBER_TABLE();
373: a4 := JTF_NUMBER_TABLE();
366: ddindx binary_integer; indx binary_integer;
367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_NUMBER_TABLE();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_NUMBER_TABLE();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_NUMBER_TABLE();
367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_NUMBER_TABLE();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_NUMBER_TABLE();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_NUMBER_TABLE();
375: a6 := JTF_NUMBER_TABLE();
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_NUMBER_TABLE();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_NUMBER_TABLE();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_NUMBER_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_NUMBER_TABLE();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_NUMBER_TABLE();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_NUMBER_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
377: a8 := JTF_NUMBER_TABLE();
370: a1 := JTF_NUMBER_TABLE();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_NUMBER_TABLE();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_NUMBER_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
377: a8 := JTF_NUMBER_TABLE();
378: a9 := JTF_VARCHAR2_TABLE_100();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_NUMBER_TABLE();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_NUMBER_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
377: a8 := JTF_NUMBER_TABLE();
378: a9 := JTF_VARCHAR2_TABLE_100();
379: a10 := JTF_DATE_TABLE();
372: a3 := JTF_NUMBER_TABLE();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_NUMBER_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
377: a8 := JTF_NUMBER_TABLE();
378: a9 := JTF_VARCHAR2_TABLE_100();
379: a10 := JTF_DATE_TABLE();
380: a11 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_NUMBER_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
377: a8 := JTF_NUMBER_TABLE();
378: a9 := JTF_VARCHAR2_TABLE_100();
379: a10 := JTF_DATE_TABLE();
380: a11 := JTF_VARCHAR2_TABLE_100();
381: else
378: a9 := JTF_VARCHAR2_TABLE_100();
379: a10 := JTF_DATE_TABLE();
380: a11 := JTF_VARCHAR2_TABLE_100();
381: else
382: a0 := JTF_NUMBER_TABLE();
383: a1 := JTF_NUMBER_TABLE();
384: a2 := JTF_NUMBER_TABLE();
385: a3 := JTF_NUMBER_TABLE();
386: a4 := JTF_NUMBER_TABLE();
379: a10 := JTF_DATE_TABLE();
380: a11 := JTF_VARCHAR2_TABLE_100();
381: else
382: a0 := JTF_NUMBER_TABLE();
383: a1 := JTF_NUMBER_TABLE();
384: a2 := JTF_NUMBER_TABLE();
385: a3 := JTF_NUMBER_TABLE();
386: a4 := JTF_NUMBER_TABLE();
387: a5 := JTF_NUMBER_TABLE();
380: a11 := JTF_VARCHAR2_TABLE_100();
381: else
382: a0 := JTF_NUMBER_TABLE();
383: a1 := JTF_NUMBER_TABLE();
384: a2 := JTF_NUMBER_TABLE();
385: a3 := JTF_NUMBER_TABLE();
386: a4 := JTF_NUMBER_TABLE();
387: a5 := JTF_NUMBER_TABLE();
388: a6 := JTF_NUMBER_TABLE();
381: else
382: a0 := JTF_NUMBER_TABLE();
383: a1 := JTF_NUMBER_TABLE();
384: a2 := JTF_NUMBER_TABLE();
385: a3 := JTF_NUMBER_TABLE();
386: a4 := JTF_NUMBER_TABLE();
387: a5 := JTF_NUMBER_TABLE();
388: a6 := JTF_NUMBER_TABLE();
389: a7 := JTF_NUMBER_TABLE();
382: a0 := JTF_NUMBER_TABLE();
383: a1 := JTF_NUMBER_TABLE();
384: a2 := JTF_NUMBER_TABLE();
385: a3 := JTF_NUMBER_TABLE();
386: a4 := JTF_NUMBER_TABLE();
387: a5 := JTF_NUMBER_TABLE();
388: a6 := JTF_NUMBER_TABLE();
389: a7 := JTF_NUMBER_TABLE();
390: a8 := JTF_NUMBER_TABLE();
383: a1 := JTF_NUMBER_TABLE();
384: a2 := JTF_NUMBER_TABLE();
385: a3 := JTF_NUMBER_TABLE();
386: a4 := JTF_NUMBER_TABLE();
387: a5 := JTF_NUMBER_TABLE();
388: a6 := JTF_NUMBER_TABLE();
389: a7 := JTF_NUMBER_TABLE();
390: a8 := JTF_NUMBER_TABLE();
391: a9 := JTF_VARCHAR2_TABLE_100();
384: a2 := JTF_NUMBER_TABLE();
385: a3 := JTF_NUMBER_TABLE();
386: a4 := JTF_NUMBER_TABLE();
387: a5 := JTF_NUMBER_TABLE();
388: a6 := JTF_NUMBER_TABLE();
389: a7 := JTF_NUMBER_TABLE();
390: a8 := JTF_NUMBER_TABLE();
391: a9 := JTF_VARCHAR2_TABLE_100();
392: a10 := JTF_DATE_TABLE();
385: a3 := JTF_NUMBER_TABLE();
386: a4 := JTF_NUMBER_TABLE();
387: a5 := JTF_NUMBER_TABLE();
388: a6 := JTF_NUMBER_TABLE();
389: a7 := JTF_NUMBER_TABLE();
390: a8 := JTF_NUMBER_TABLE();
391: a9 := JTF_VARCHAR2_TABLE_100();
392: a10 := JTF_DATE_TABLE();
393: a11 := JTF_VARCHAR2_TABLE_100();
386: a4 := JTF_NUMBER_TABLE();
387: a5 := JTF_NUMBER_TABLE();
388: a6 := JTF_NUMBER_TABLE();
389: a7 := JTF_NUMBER_TABLE();
390: a8 := JTF_NUMBER_TABLE();
391: a9 := JTF_VARCHAR2_TABLE_100();
392: a10 := JTF_DATE_TABLE();
393: a11 := JTF_VARCHAR2_TABLE_100();
394: if t.count > 0 then
428: end if;
429: end if;
430: end rosetta_table_copy_out_p6;
431:
432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 JTF_NUMBER_TABLE
433: , a1 JTF_NUMBER_TABLE
434: , a2 JTF_NUMBER_TABLE
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_NUMBER_TABLE
429: end if;
430: end rosetta_table_copy_out_p6;
431:
432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 JTF_NUMBER_TABLE
433: , a1 JTF_NUMBER_TABLE
434: , a2 JTF_NUMBER_TABLE
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_NUMBER_TABLE
437: , a5 JTF_DATE_TABLE
430: end rosetta_table_copy_out_p6;
431:
432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 JTF_NUMBER_TABLE
433: , a1 JTF_NUMBER_TABLE
434: , a2 JTF_NUMBER_TABLE
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_NUMBER_TABLE
437: , a5 JTF_DATE_TABLE
438: , a6 JTF_NUMBER_TABLE
431:
432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 JTF_NUMBER_TABLE
433: , a1 JTF_NUMBER_TABLE
434: , a2 JTF_NUMBER_TABLE
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_NUMBER_TABLE
437: , a5 JTF_DATE_TABLE
438: , a6 JTF_NUMBER_TABLE
439: , a7 JTF_VARCHAR2_TABLE_100
432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 JTF_NUMBER_TABLE
433: , a1 JTF_NUMBER_TABLE
434: , a2 JTF_NUMBER_TABLE
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_NUMBER_TABLE
437: , a5 JTF_DATE_TABLE
438: , a6 JTF_NUMBER_TABLE
439: , a7 JTF_VARCHAR2_TABLE_100
440: , a8 JTF_NUMBER_TABLE
434: , a2 JTF_NUMBER_TABLE
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_NUMBER_TABLE
437: , a5 JTF_DATE_TABLE
438: , a6 JTF_NUMBER_TABLE
439: , a7 JTF_VARCHAR2_TABLE_100
440: , a8 JTF_NUMBER_TABLE
441: , a9 JTF_NUMBER_TABLE
442: , a10 JTF_NUMBER_TABLE
436: , a4 JTF_NUMBER_TABLE
437: , a5 JTF_DATE_TABLE
438: , a6 JTF_NUMBER_TABLE
439: , a7 JTF_VARCHAR2_TABLE_100
440: , a8 JTF_NUMBER_TABLE
441: , a9 JTF_NUMBER_TABLE
442: , a10 JTF_NUMBER_TABLE
443: , a11 JTF_VARCHAR2_TABLE_100
444: , a12 JTF_NUMBER_TABLE
437: , a5 JTF_DATE_TABLE
438: , a6 JTF_NUMBER_TABLE
439: , a7 JTF_VARCHAR2_TABLE_100
440: , a8 JTF_NUMBER_TABLE
441: , a9 JTF_NUMBER_TABLE
442: , a10 JTF_NUMBER_TABLE
443: , a11 JTF_VARCHAR2_TABLE_100
444: , a12 JTF_NUMBER_TABLE
445: , a13 JTF_VARCHAR2_TABLE_100
438: , a6 JTF_NUMBER_TABLE
439: , a7 JTF_VARCHAR2_TABLE_100
440: , a8 JTF_NUMBER_TABLE
441: , a9 JTF_NUMBER_TABLE
442: , a10 JTF_NUMBER_TABLE
443: , a11 JTF_VARCHAR2_TABLE_100
444: , a12 JTF_NUMBER_TABLE
445: , a13 JTF_VARCHAR2_TABLE_100
446: , a14 JTF_VARCHAR2_TABLE_100
440: , a8 JTF_NUMBER_TABLE
441: , a9 JTF_NUMBER_TABLE
442: , a10 JTF_NUMBER_TABLE
443: , a11 JTF_VARCHAR2_TABLE_100
444: , a12 JTF_NUMBER_TABLE
445: , a13 JTF_VARCHAR2_TABLE_100
446: , a14 JTF_VARCHAR2_TABLE_100
447: , a15 JTF_VARCHAR2_TABLE_300
448: ) as
477: end loop;
478: end if;
479: end if;
480: end rosetta_table_copy_in_p8;
481: procedure rosetta_table_copy_out_p8(t ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_NUMBER_TABLE
484: , a3 out nocopy JTF_NUMBER_TABLE
485: , a4 out nocopy JTF_NUMBER_TABLE
478: end if;
479: end if;
480: end rosetta_table_copy_in_p8;
481: procedure rosetta_table_copy_out_p8(t ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_NUMBER_TABLE
484: , a3 out nocopy JTF_NUMBER_TABLE
485: , a4 out nocopy JTF_NUMBER_TABLE
486: , a5 out nocopy JTF_DATE_TABLE
479: end if;
480: end rosetta_table_copy_in_p8;
481: procedure rosetta_table_copy_out_p8(t ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_NUMBER_TABLE
484: , a3 out nocopy JTF_NUMBER_TABLE
485: , a4 out nocopy JTF_NUMBER_TABLE
486: , a5 out nocopy JTF_DATE_TABLE
487: , a6 out nocopy JTF_NUMBER_TABLE
480: end rosetta_table_copy_in_p8;
481: procedure rosetta_table_copy_out_p8(t ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_NUMBER_TABLE
484: , a3 out nocopy JTF_NUMBER_TABLE
485: , a4 out nocopy JTF_NUMBER_TABLE
486: , a5 out nocopy JTF_DATE_TABLE
487: , a6 out nocopy JTF_NUMBER_TABLE
488: , a7 out nocopy JTF_VARCHAR2_TABLE_100
481: procedure rosetta_table_copy_out_p8(t ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_NUMBER_TABLE
484: , a3 out nocopy JTF_NUMBER_TABLE
485: , a4 out nocopy JTF_NUMBER_TABLE
486: , a5 out nocopy JTF_DATE_TABLE
487: , a6 out nocopy JTF_NUMBER_TABLE
488: , a7 out nocopy JTF_VARCHAR2_TABLE_100
489: , a8 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_NUMBER_TABLE
484: , a3 out nocopy JTF_NUMBER_TABLE
485: , a4 out nocopy JTF_NUMBER_TABLE
486: , a5 out nocopy JTF_DATE_TABLE
487: , a6 out nocopy JTF_NUMBER_TABLE
488: , a7 out nocopy JTF_VARCHAR2_TABLE_100
489: , a8 out nocopy JTF_NUMBER_TABLE
490: , a9 out nocopy JTF_NUMBER_TABLE
491: , a10 out nocopy JTF_NUMBER_TABLE
485: , a4 out nocopy JTF_NUMBER_TABLE
486: , a5 out nocopy JTF_DATE_TABLE
487: , a6 out nocopy JTF_NUMBER_TABLE
488: , a7 out nocopy JTF_VARCHAR2_TABLE_100
489: , a8 out nocopy JTF_NUMBER_TABLE
490: , a9 out nocopy JTF_NUMBER_TABLE
491: , a10 out nocopy JTF_NUMBER_TABLE
492: , a11 out nocopy JTF_VARCHAR2_TABLE_100
493: , a12 out nocopy JTF_NUMBER_TABLE
486: , a5 out nocopy JTF_DATE_TABLE
487: , a6 out nocopy JTF_NUMBER_TABLE
488: , a7 out nocopy JTF_VARCHAR2_TABLE_100
489: , a8 out nocopy JTF_NUMBER_TABLE
490: , a9 out nocopy JTF_NUMBER_TABLE
491: , a10 out nocopy JTF_NUMBER_TABLE
492: , a11 out nocopy JTF_VARCHAR2_TABLE_100
493: , a12 out nocopy JTF_NUMBER_TABLE
494: , a13 out nocopy JTF_VARCHAR2_TABLE_100
487: , a6 out nocopy JTF_NUMBER_TABLE
488: , a7 out nocopy JTF_VARCHAR2_TABLE_100
489: , a8 out nocopy JTF_NUMBER_TABLE
490: , a9 out nocopy JTF_NUMBER_TABLE
491: , a10 out nocopy JTF_NUMBER_TABLE
492: , a11 out nocopy JTF_VARCHAR2_TABLE_100
493: , a12 out nocopy JTF_NUMBER_TABLE
494: , a13 out nocopy JTF_VARCHAR2_TABLE_100
495: , a14 out nocopy JTF_VARCHAR2_TABLE_100
489: , a8 out nocopy JTF_NUMBER_TABLE
490: , a9 out nocopy JTF_NUMBER_TABLE
491: , a10 out nocopy JTF_NUMBER_TABLE
492: , a11 out nocopy JTF_VARCHAR2_TABLE_100
493: , a12 out nocopy JTF_NUMBER_TABLE
494: , a13 out nocopy JTF_VARCHAR2_TABLE_100
495: , a14 out nocopy JTF_VARCHAR2_TABLE_100
496: , a15 out nocopy JTF_VARCHAR2_TABLE_300
497: ) as
497: ) as
498: ddindx binary_integer; indx binary_integer;
499: begin
500: if t is null or t.count = 0 then
501: a0 := JTF_NUMBER_TABLE();
502: a1 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_NUMBER_TABLE();
505: a4 := JTF_NUMBER_TABLE();
498: ddindx binary_integer; indx binary_integer;
499: begin
500: if t is null or t.count = 0 then
501: a0 := JTF_NUMBER_TABLE();
502: a1 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_NUMBER_TABLE();
505: a4 := JTF_NUMBER_TABLE();
506: a5 := JTF_DATE_TABLE();
499: begin
500: if t is null or t.count = 0 then
501: a0 := JTF_NUMBER_TABLE();
502: a1 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_NUMBER_TABLE();
505: a4 := JTF_NUMBER_TABLE();
506: a5 := JTF_DATE_TABLE();
507: a6 := JTF_NUMBER_TABLE();
500: if t is null or t.count = 0 then
501: a0 := JTF_NUMBER_TABLE();
502: a1 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_NUMBER_TABLE();
505: a4 := JTF_NUMBER_TABLE();
506: a5 := JTF_DATE_TABLE();
507: a6 := JTF_NUMBER_TABLE();
508: a7 := JTF_VARCHAR2_TABLE_100();
501: a0 := JTF_NUMBER_TABLE();
502: a1 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_NUMBER_TABLE();
505: a4 := JTF_NUMBER_TABLE();
506: a5 := JTF_DATE_TABLE();
507: a6 := JTF_NUMBER_TABLE();
508: a7 := JTF_VARCHAR2_TABLE_100();
509: a8 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_NUMBER_TABLE();
505: a4 := JTF_NUMBER_TABLE();
506: a5 := JTF_DATE_TABLE();
507: a6 := JTF_NUMBER_TABLE();
508: a7 := JTF_VARCHAR2_TABLE_100();
509: a8 := JTF_NUMBER_TABLE();
510: a9 := JTF_NUMBER_TABLE();
511: a10 := JTF_NUMBER_TABLE();
505: a4 := JTF_NUMBER_TABLE();
506: a5 := JTF_DATE_TABLE();
507: a6 := JTF_NUMBER_TABLE();
508: a7 := JTF_VARCHAR2_TABLE_100();
509: a8 := JTF_NUMBER_TABLE();
510: a9 := JTF_NUMBER_TABLE();
511: a10 := JTF_NUMBER_TABLE();
512: a11 := JTF_VARCHAR2_TABLE_100();
513: a12 := JTF_NUMBER_TABLE();
506: a5 := JTF_DATE_TABLE();
507: a6 := JTF_NUMBER_TABLE();
508: a7 := JTF_VARCHAR2_TABLE_100();
509: a8 := JTF_NUMBER_TABLE();
510: a9 := JTF_NUMBER_TABLE();
511: a10 := JTF_NUMBER_TABLE();
512: a11 := JTF_VARCHAR2_TABLE_100();
513: a12 := JTF_NUMBER_TABLE();
514: a13 := JTF_VARCHAR2_TABLE_100();
507: a6 := JTF_NUMBER_TABLE();
508: a7 := JTF_VARCHAR2_TABLE_100();
509: a8 := JTF_NUMBER_TABLE();
510: a9 := JTF_NUMBER_TABLE();
511: a10 := JTF_NUMBER_TABLE();
512: a11 := JTF_VARCHAR2_TABLE_100();
513: a12 := JTF_NUMBER_TABLE();
514: a13 := JTF_VARCHAR2_TABLE_100();
515: a14 := JTF_VARCHAR2_TABLE_100();
509: a8 := JTF_NUMBER_TABLE();
510: a9 := JTF_NUMBER_TABLE();
511: a10 := JTF_NUMBER_TABLE();
512: a11 := JTF_VARCHAR2_TABLE_100();
513: a12 := JTF_NUMBER_TABLE();
514: a13 := JTF_VARCHAR2_TABLE_100();
515: a14 := JTF_VARCHAR2_TABLE_100();
516: a15 := JTF_VARCHAR2_TABLE_300();
517: else
514: a13 := JTF_VARCHAR2_TABLE_100();
515: a14 := JTF_VARCHAR2_TABLE_100();
516: a15 := JTF_VARCHAR2_TABLE_300();
517: else
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_NUMBER_TABLE();
521: a3 := JTF_NUMBER_TABLE();
522: a4 := JTF_NUMBER_TABLE();
515: a14 := JTF_VARCHAR2_TABLE_100();
516: a15 := JTF_VARCHAR2_TABLE_300();
517: else
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_NUMBER_TABLE();
521: a3 := JTF_NUMBER_TABLE();
522: a4 := JTF_NUMBER_TABLE();
523: a5 := JTF_DATE_TABLE();
516: a15 := JTF_VARCHAR2_TABLE_300();
517: else
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_NUMBER_TABLE();
521: a3 := JTF_NUMBER_TABLE();
522: a4 := JTF_NUMBER_TABLE();
523: a5 := JTF_DATE_TABLE();
524: a6 := JTF_NUMBER_TABLE();
517: else
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_NUMBER_TABLE();
521: a3 := JTF_NUMBER_TABLE();
522: a4 := JTF_NUMBER_TABLE();
523: a5 := JTF_DATE_TABLE();
524: a6 := JTF_NUMBER_TABLE();
525: a7 := JTF_VARCHAR2_TABLE_100();
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_NUMBER_TABLE();
521: a3 := JTF_NUMBER_TABLE();
522: a4 := JTF_NUMBER_TABLE();
523: a5 := JTF_DATE_TABLE();
524: a6 := JTF_NUMBER_TABLE();
525: a7 := JTF_VARCHAR2_TABLE_100();
526: a8 := JTF_NUMBER_TABLE();
520: a2 := JTF_NUMBER_TABLE();
521: a3 := JTF_NUMBER_TABLE();
522: a4 := JTF_NUMBER_TABLE();
523: a5 := JTF_DATE_TABLE();
524: a6 := JTF_NUMBER_TABLE();
525: a7 := JTF_VARCHAR2_TABLE_100();
526: a8 := JTF_NUMBER_TABLE();
527: a9 := JTF_NUMBER_TABLE();
528: a10 := JTF_NUMBER_TABLE();
522: a4 := JTF_NUMBER_TABLE();
523: a5 := JTF_DATE_TABLE();
524: a6 := JTF_NUMBER_TABLE();
525: a7 := JTF_VARCHAR2_TABLE_100();
526: a8 := JTF_NUMBER_TABLE();
527: a9 := JTF_NUMBER_TABLE();
528: a10 := JTF_NUMBER_TABLE();
529: a11 := JTF_VARCHAR2_TABLE_100();
530: a12 := JTF_NUMBER_TABLE();
523: a5 := JTF_DATE_TABLE();
524: a6 := JTF_NUMBER_TABLE();
525: a7 := JTF_VARCHAR2_TABLE_100();
526: a8 := JTF_NUMBER_TABLE();
527: a9 := JTF_NUMBER_TABLE();
528: a10 := JTF_NUMBER_TABLE();
529: a11 := JTF_VARCHAR2_TABLE_100();
530: a12 := JTF_NUMBER_TABLE();
531: a13 := JTF_VARCHAR2_TABLE_100();
524: a6 := JTF_NUMBER_TABLE();
525: a7 := JTF_VARCHAR2_TABLE_100();
526: a8 := JTF_NUMBER_TABLE();
527: a9 := JTF_NUMBER_TABLE();
528: a10 := JTF_NUMBER_TABLE();
529: a11 := JTF_VARCHAR2_TABLE_100();
530: a12 := JTF_NUMBER_TABLE();
531: a13 := JTF_VARCHAR2_TABLE_100();
532: a14 := JTF_VARCHAR2_TABLE_100();
526: a8 := JTF_NUMBER_TABLE();
527: a9 := JTF_NUMBER_TABLE();
528: a10 := JTF_NUMBER_TABLE();
529: a11 := JTF_VARCHAR2_TABLE_100();
530: a12 := JTF_NUMBER_TABLE();
531: a13 := JTF_VARCHAR2_TABLE_100();
532: a14 := JTF_VARCHAR2_TABLE_100();
533: a15 := JTF_VARCHAR2_TABLE_300();
534: if t.count > 0 then
576: end if;
577: end if;
578: end rosetta_table_copy_out_p8;
579:
580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 JTF_NUMBER_TABLE
581: , a1 JTF_VARCHAR2_TABLE_300
582: , a2 JTF_NUMBER_TABLE
583: , a3 JTF_VARCHAR2_TABLE_32767
584: ) as
578: end rosetta_table_copy_out_p8;
579:
580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 JTF_NUMBER_TABLE
581: , a1 JTF_VARCHAR2_TABLE_300
582: , a2 JTF_NUMBER_TABLE
583: , a3 JTF_VARCHAR2_TABLE_32767
584: ) as
585: ddindx binary_integer; indx binary_integer;
586: begin
601: end loop;
602: end if;
603: end if;
604: end rosetta_table_copy_in_p10;
605: procedure rosetta_table_copy_out_p10(t ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
606: , a1 out nocopy JTF_VARCHAR2_TABLE_300
607: , a2 out nocopy JTF_NUMBER_TABLE
608: , a3 out nocopy JTF_VARCHAR2_TABLE_32767
609: ) as
603: end if;
604: end rosetta_table_copy_in_p10;
605: procedure rosetta_table_copy_out_p10(t ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
606: , a1 out nocopy JTF_VARCHAR2_TABLE_300
607: , a2 out nocopy JTF_NUMBER_TABLE
608: , a3 out nocopy JTF_VARCHAR2_TABLE_32767
609: ) as
610: ddindx binary_integer; indx binary_integer;
611: begin
609: ) as
610: ddindx binary_integer; indx binary_integer;
611: begin
612: if t is null or t.count = 0 then
613: a0 := JTF_NUMBER_TABLE();
614: a1 := JTF_VARCHAR2_TABLE_300();
615: a2 := JTF_NUMBER_TABLE();
616: a3 := JTF_VARCHAR2_TABLE_32767();
617: else
611: begin
612: if t is null or t.count = 0 then
613: a0 := JTF_NUMBER_TABLE();
614: a1 := JTF_VARCHAR2_TABLE_300();
615: a2 := JTF_NUMBER_TABLE();
616: a3 := JTF_VARCHAR2_TABLE_32767();
617: else
618: a0 := JTF_NUMBER_TABLE();
619: a1 := JTF_VARCHAR2_TABLE_300();
614: a1 := JTF_VARCHAR2_TABLE_300();
615: a2 := JTF_NUMBER_TABLE();
616: a3 := JTF_VARCHAR2_TABLE_32767();
617: else
618: a0 := JTF_NUMBER_TABLE();
619: a1 := JTF_VARCHAR2_TABLE_300();
620: a2 := JTF_NUMBER_TABLE();
621: a3 := JTF_VARCHAR2_TABLE_32767();
622: if t.count > 0 then
616: a3 := JTF_VARCHAR2_TABLE_32767();
617: else
618: a0 := JTF_NUMBER_TABLE();
619: a1 := JTF_VARCHAR2_TABLE_300();
620: a2 := JTF_NUMBER_TABLE();
621: a3 := JTF_VARCHAR2_TABLE_32767();
622: if t.count > 0 then
623: a0.extend(t.count);
624: a1.extend(t.count);
670: , p6_a20 VARCHAR2
671: , p6_a21 NUMBER
672: , p6_a22 VARCHAR2
673: , p6_a23 VARCHAR2
674: , p7_a0 JTF_NUMBER_TABLE
675: , p7_a1 JTF_NUMBER_TABLE
676: , p7_a2 JTF_NUMBER_TABLE
677: , p7_a3 JTF_VARCHAR2_TABLE_300
678: , p7_a4 JTF_NUMBER_TABLE
671: , p6_a21 NUMBER
672: , p6_a22 VARCHAR2
673: , p6_a23 VARCHAR2
674: , p7_a0 JTF_NUMBER_TABLE
675: , p7_a1 JTF_NUMBER_TABLE
676: , p7_a2 JTF_NUMBER_TABLE
677: , p7_a3 JTF_VARCHAR2_TABLE_300
678: , p7_a4 JTF_NUMBER_TABLE
679: , p7_a5 JTF_NUMBER_TABLE
672: , p6_a22 VARCHAR2
673: , p6_a23 VARCHAR2
674: , p7_a0 JTF_NUMBER_TABLE
675: , p7_a1 JTF_NUMBER_TABLE
676: , p7_a2 JTF_NUMBER_TABLE
677: , p7_a3 JTF_VARCHAR2_TABLE_300
678: , p7_a4 JTF_NUMBER_TABLE
679: , p7_a5 JTF_NUMBER_TABLE
680: , p7_a6 JTF_NUMBER_TABLE
674: , p7_a0 JTF_NUMBER_TABLE
675: , p7_a1 JTF_NUMBER_TABLE
676: , p7_a2 JTF_NUMBER_TABLE
677: , p7_a3 JTF_VARCHAR2_TABLE_300
678: , p7_a4 JTF_NUMBER_TABLE
679: , p7_a5 JTF_NUMBER_TABLE
680: , p7_a6 JTF_NUMBER_TABLE
681: , p7_a7 JTF_DATE_TABLE
682: , p7_a8 JTF_DATE_TABLE
675: , p7_a1 JTF_NUMBER_TABLE
676: , p7_a2 JTF_NUMBER_TABLE
677: , p7_a3 JTF_VARCHAR2_TABLE_300
678: , p7_a4 JTF_NUMBER_TABLE
679: , p7_a5 JTF_NUMBER_TABLE
680: , p7_a6 JTF_NUMBER_TABLE
681: , p7_a7 JTF_DATE_TABLE
682: , p7_a8 JTF_DATE_TABLE
683: , p7_a9 JTF_VARCHAR2_TABLE_100
676: , p7_a2 JTF_NUMBER_TABLE
677: , p7_a3 JTF_VARCHAR2_TABLE_300
678: , p7_a4 JTF_NUMBER_TABLE
679: , p7_a5 JTF_NUMBER_TABLE
680: , p7_a6 JTF_NUMBER_TABLE
681: , p7_a7 JTF_DATE_TABLE
682: , p7_a8 JTF_DATE_TABLE
683: , p7_a9 JTF_VARCHAR2_TABLE_100
684: , p8_a0 JTF_NUMBER_TABLE
680: , p7_a6 JTF_NUMBER_TABLE
681: , p7_a7 JTF_DATE_TABLE
682: , p7_a8 JTF_DATE_TABLE
683: , p7_a9 JTF_VARCHAR2_TABLE_100
684: , p8_a0 JTF_NUMBER_TABLE
685: , p8_a1 JTF_NUMBER_TABLE
686: , p8_a2 JTF_NUMBER_TABLE
687: , p8_a3 JTF_NUMBER_TABLE
688: , p8_a4 JTF_NUMBER_TABLE
681: , p7_a7 JTF_DATE_TABLE
682: , p7_a8 JTF_DATE_TABLE
683: , p7_a9 JTF_VARCHAR2_TABLE_100
684: , p8_a0 JTF_NUMBER_TABLE
685: , p8_a1 JTF_NUMBER_TABLE
686: , p8_a2 JTF_NUMBER_TABLE
687: , p8_a3 JTF_NUMBER_TABLE
688: , p8_a4 JTF_NUMBER_TABLE
689: , p8_a5 JTF_NUMBER_TABLE
682: , p7_a8 JTF_DATE_TABLE
683: , p7_a9 JTF_VARCHAR2_TABLE_100
684: , p8_a0 JTF_NUMBER_TABLE
685: , p8_a1 JTF_NUMBER_TABLE
686: , p8_a2 JTF_NUMBER_TABLE
687: , p8_a3 JTF_NUMBER_TABLE
688: , p8_a4 JTF_NUMBER_TABLE
689: , p8_a5 JTF_NUMBER_TABLE
690: , p8_a6 JTF_NUMBER_TABLE
683: , p7_a9 JTF_VARCHAR2_TABLE_100
684: , p8_a0 JTF_NUMBER_TABLE
685: , p8_a1 JTF_NUMBER_TABLE
686: , p8_a2 JTF_NUMBER_TABLE
687: , p8_a3 JTF_NUMBER_TABLE
688: , p8_a4 JTF_NUMBER_TABLE
689: , p8_a5 JTF_NUMBER_TABLE
690: , p8_a6 JTF_NUMBER_TABLE
691: , p8_a7 JTF_VARCHAR2_TABLE_100
684: , p8_a0 JTF_NUMBER_TABLE
685: , p8_a1 JTF_NUMBER_TABLE
686: , p8_a2 JTF_NUMBER_TABLE
687: , p8_a3 JTF_NUMBER_TABLE
688: , p8_a4 JTF_NUMBER_TABLE
689: , p8_a5 JTF_NUMBER_TABLE
690: , p8_a6 JTF_NUMBER_TABLE
691: , p8_a7 JTF_VARCHAR2_TABLE_100
692: , p8_a8 JTF_NUMBER_TABLE
685: , p8_a1 JTF_NUMBER_TABLE
686: , p8_a2 JTF_NUMBER_TABLE
687: , p8_a3 JTF_NUMBER_TABLE
688: , p8_a4 JTF_NUMBER_TABLE
689: , p8_a5 JTF_NUMBER_TABLE
690: , p8_a6 JTF_NUMBER_TABLE
691: , p8_a7 JTF_VARCHAR2_TABLE_100
692: , p8_a8 JTF_NUMBER_TABLE
693: , p8_a9 JTF_NUMBER_TABLE
686: , p8_a2 JTF_NUMBER_TABLE
687: , p8_a3 JTF_NUMBER_TABLE
688: , p8_a4 JTF_NUMBER_TABLE
689: , p8_a5 JTF_NUMBER_TABLE
690: , p8_a6 JTF_NUMBER_TABLE
691: , p8_a7 JTF_VARCHAR2_TABLE_100
692: , p8_a8 JTF_NUMBER_TABLE
693: , p8_a9 JTF_NUMBER_TABLE
694: , p8_a10 JTF_NUMBER_TABLE
688: , p8_a4 JTF_NUMBER_TABLE
689: , p8_a5 JTF_NUMBER_TABLE
690: , p8_a6 JTF_NUMBER_TABLE
691: , p8_a7 JTF_VARCHAR2_TABLE_100
692: , p8_a8 JTF_NUMBER_TABLE
693: , p8_a9 JTF_NUMBER_TABLE
694: , p8_a10 JTF_NUMBER_TABLE
695: , p8_a11 JTF_NUMBER_TABLE
696: , p8_a12 JTF_NUMBER_TABLE
689: , p8_a5 JTF_NUMBER_TABLE
690: , p8_a6 JTF_NUMBER_TABLE
691: , p8_a7 JTF_VARCHAR2_TABLE_100
692: , p8_a8 JTF_NUMBER_TABLE
693: , p8_a9 JTF_NUMBER_TABLE
694: , p8_a10 JTF_NUMBER_TABLE
695: , p8_a11 JTF_NUMBER_TABLE
696: , p8_a12 JTF_NUMBER_TABLE
697: , p8_a13 JTF_NUMBER_TABLE
690: , p8_a6 JTF_NUMBER_TABLE
691: , p8_a7 JTF_VARCHAR2_TABLE_100
692: , p8_a8 JTF_NUMBER_TABLE
693: , p8_a9 JTF_NUMBER_TABLE
694: , p8_a10 JTF_NUMBER_TABLE
695: , p8_a11 JTF_NUMBER_TABLE
696: , p8_a12 JTF_NUMBER_TABLE
697: , p8_a13 JTF_NUMBER_TABLE
698: , p8_a14 JTF_NUMBER_TABLE
691: , p8_a7 JTF_VARCHAR2_TABLE_100
692: , p8_a8 JTF_NUMBER_TABLE
693: , p8_a9 JTF_NUMBER_TABLE
694: , p8_a10 JTF_NUMBER_TABLE
695: , p8_a11 JTF_NUMBER_TABLE
696: , p8_a12 JTF_NUMBER_TABLE
697: , p8_a13 JTF_NUMBER_TABLE
698: , p8_a14 JTF_NUMBER_TABLE
699: , p8_a15 JTF_NUMBER_TABLE
692: , p8_a8 JTF_NUMBER_TABLE
693: , p8_a9 JTF_NUMBER_TABLE
694: , p8_a10 JTF_NUMBER_TABLE
695: , p8_a11 JTF_NUMBER_TABLE
696: , p8_a12 JTF_NUMBER_TABLE
697: , p8_a13 JTF_NUMBER_TABLE
698: , p8_a14 JTF_NUMBER_TABLE
699: , p8_a15 JTF_NUMBER_TABLE
700: , p8_a16 JTF_NUMBER_TABLE
693: , p8_a9 JTF_NUMBER_TABLE
694: , p8_a10 JTF_NUMBER_TABLE
695: , p8_a11 JTF_NUMBER_TABLE
696: , p8_a12 JTF_NUMBER_TABLE
697: , p8_a13 JTF_NUMBER_TABLE
698: , p8_a14 JTF_NUMBER_TABLE
699: , p8_a15 JTF_NUMBER_TABLE
700: , p8_a16 JTF_NUMBER_TABLE
701: , p8_a17 JTF_VARCHAR2_TABLE_300
694: , p8_a10 JTF_NUMBER_TABLE
695: , p8_a11 JTF_NUMBER_TABLE
696: , p8_a12 JTF_NUMBER_TABLE
697: , p8_a13 JTF_NUMBER_TABLE
698: , p8_a14 JTF_NUMBER_TABLE
699: , p8_a15 JTF_NUMBER_TABLE
700: , p8_a16 JTF_NUMBER_TABLE
701: , p8_a17 JTF_VARCHAR2_TABLE_300
702: , p8_a18 JTF_DATE_TABLE
695: , p8_a11 JTF_NUMBER_TABLE
696: , p8_a12 JTF_NUMBER_TABLE
697: , p8_a13 JTF_NUMBER_TABLE
698: , p8_a14 JTF_NUMBER_TABLE
699: , p8_a15 JTF_NUMBER_TABLE
700: , p8_a16 JTF_NUMBER_TABLE
701: , p8_a17 JTF_VARCHAR2_TABLE_300
702: , p8_a18 JTF_DATE_TABLE
703: , p8_a19 JTF_DATE_TABLE
696: , p8_a12 JTF_NUMBER_TABLE
697: , p8_a13 JTF_NUMBER_TABLE
698: , p8_a14 JTF_NUMBER_TABLE
699: , p8_a15 JTF_NUMBER_TABLE
700: , p8_a16 JTF_NUMBER_TABLE
701: , p8_a17 JTF_VARCHAR2_TABLE_300
702: , p8_a18 JTF_DATE_TABLE
703: , p8_a19 JTF_DATE_TABLE
704: , p8_a20 JTF_NUMBER_TABLE
700: , p8_a16 JTF_NUMBER_TABLE
701: , p8_a17 JTF_VARCHAR2_TABLE_300
702: , p8_a18 JTF_DATE_TABLE
703: , p8_a19 JTF_DATE_TABLE
704: , p8_a20 JTF_NUMBER_TABLE
705: , p8_a21 JTF_VARCHAR2_TABLE_100
706: , p9_a0 JTF_NUMBER_TABLE
707: , p9_a1 JTF_NUMBER_TABLE
708: , p9_a2 JTF_NUMBER_TABLE
702: , p8_a18 JTF_DATE_TABLE
703: , p8_a19 JTF_DATE_TABLE
704: , p8_a20 JTF_NUMBER_TABLE
705: , p8_a21 JTF_VARCHAR2_TABLE_100
706: , p9_a0 JTF_NUMBER_TABLE
707: , p9_a1 JTF_NUMBER_TABLE
708: , p9_a2 JTF_NUMBER_TABLE
709: , p9_a3 JTF_NUMBER_TABLE
710: , p9_a4 JTF_NUMBER_TABLE
703: , p8_a19 JTF_DATE_TABLE
704: , p8_a20 JTF_NUMBER_TABLE
705: , p8_a21 JTF_VARCHAR2_TABLE_100
706: , p9_a0 JTF_NUMBER_TABLE
707: , p9_a1 JTF_NUMBER_TABLE
708: , p9_a2 JTF_NUMBER_TABLE
709: , p9_a3 JTF_NUMBER_TABLE
710: , p9_a4 JTF_NUMBER_TABLE
711: , p9_a5 JTF_NUMBER_TABLE
704: , p8_a20 JTF_NUMBER_TABLE
705: , p8_a21 JTF_VARCHAR2_TABLE_100
706: , p9_a0 JTF_NUMBER_TABLE
707: , p9_a1 JTF_NUMBER_TABLE
708: , p9_a2 JTF_NUMBER_TABLE
709: , p9_a3 JTF_NUMBER_TABLE
710: , p9_a4 JTF_NUMBER_TABLE
711: , p9_a5 JTF_NUMBER_TABLE
712: , p9_a6 JTF_NUMBER_TABLE
705: , p8_a21 JTF_VARCHAR2_TABLE_100
706: , p9_a0 JTF_NUMBER_TABLE
707: , p9_a1 JTF_NUMBER_TABLE
708: , p9_a2 JTF_NUMBER_TABLE
709: , p9_a3 JTF_NUMBER_TABLE
710: , p9_a4 JTF_NUMBER_TABLE
711: , p9_a5 JTF_NUMBER_TABLE
712: , p9_a6 JTF_NUMBER_TABLE
713: , p9_a7 JTF_NUMBER_TABLE
706: , p9_a0 JTF_NUMBER_TABLE
707: , p9_a1 JTF_NUMBER_TABLE
708: , p9_a2 JTF_NUMBER_TABLE
709: , p9_a3 JTF_NUMBER_TABLE
710: , p9_a4 JTF_NUMBER_TABLE
711: , p9_a5 JTF_NUMBER_TABLE
712: , p9_a6 JTF_NUMBER_TABLE
713: , p9_a7 JTF_NUMBER_TABLE
714: , p9_a8 JTF_NUMBER_TABLE
707: , p9_a1 JTF_NUMBER_TABLE
708: , p9_a2 JTF_NUMBER_TABLE
709: , p9_a3 JTF_NUMBER_TABLE
710: , p9_a4 JTF_NUMBER_TABLE
711: , p9_a5 JTF_NUMBER_TABLE
712: , p9_a6 JTF_NUMBER_TABLE
713: , p9_a7 JTF_NUMBER_TABLE
714: , p9_a8 JTF_NUMBER_TABLE
715: , p9_a9 JTF_VARCHAR2_TABLE_100
708: , p9_a2 JTF_NUMBER_TABLE
709: , p9_a3 JTF_NUMBER_TABLE
710: , p9_a4 JTF_NUMBER_TABLE
711: , p9_a5 JTF_NUMBER_TABLE
712: , p9_a6 JTF_NUMBER_TABLE
713: , p9_a7 JTF_NUMBER_TABLE
714: , p9_a8 JTF_NUMBER_TABLE
715: , p9_a9 JTF_VARCHAR2_TABLE_100
716: , p9_a10 JTF_DATE_TABLE
709: , p9_a3 JTF_NUMBER_TABLE
710: , p9_a4 JTF_NUMBER_TABLE
711: , p9_a5 JTF_NUMBER_TABLE
712: , p9_a6 JTF_NUMBER_TABLE
713: , p9_a7 JTF_NUMBER_TABLE
714: , p9_a8 JTF_NUMBER_TABLE
715: , p9_a9 JTF_VARCHAR2_TABLE_100
716: , p9_a10 JTF_DATE_TABLE
717: , p9_a11 JTF_VARCHAR2_TABLE_100
710: , p9_a4 JTF_NUMBER_TABLE
711: , p9_a5 JTF_NUMBER_TABLE
712: , p9_a6 JTF_NUMBER_TABLE
713: , p9_a7 JTF_NUMBER_TABLE
714: , p9_a8 JTF_NUMBER_TABLE
715: , p9_a9 JTF_VARCHAR2_TABLE_100
716: , p9_a10 JTF_DATE_TABLE
717: , p9_a11 JTF_VARCHAR2_TABLE_100
718: , x_wip_entity_id out nocopy NUMBER
841: , p_validation_level NUMBER
842: , x_return_status out nocopy VARCHAR2
843: , x_msg_count out nocopy NUMBER
844: , x_msg_data out nocopy VARCHAR2
845: , p7_a0 JTF_NUMBER_TABLE
846: , p7_a1 JTF_NUMBER_TABLE
847: , p7_a2 JTF_NUMBER_TABLE
848: , p7_a3 JTF_NUMBER_TABLE
849: , p7_a4 JTF_NUMBER_TABLE
842: , x_return_status out nocopy VARCHAR2
843: , x_msg_count out nocopy NUMBER
844: , x_msg_data out nocopy VARCHAR2
845: , p7_a0 JTF_NUMBER_TABLE
846: , p7_a1 JTF_NUMBER_TABLE
847: , p7_a2 JTF_NUMBER_TABLE
848: , p7_a3 JTF_NUMBER_TABLE
849: , p7_a4 JTF_NUMBER_TABLE
850: , p7_a5 JTF_DATE_TABLE
843: , x_msg_count out nocopy NUMBER
844: , x_msg_data out nocopy VARCHAR2
845: , p7_a0 JTF_NUMBER_TABLE
846: , p7_a1 JTF_NUMBER_TABLE
847: , p7_a2 JTF_NUMBER_TABLE
848: , p7_a3 JTF_NUMBER_TABLE
849: , p7_a4 JTF_NUMBER_TABLE
850: , p7_a5 JTF_DATE_TABLE
851: , p7_a6 JTF_NUMBER_TABLE
844: , x_msg_data out nocopy VARCHAR2
845: , p7_a0 JTF_NUMBER_TABLE
846: , p7_a1 JTF_NUMBER_TABLE
847: , p7_a2 JTF_NUMBER_TABLE
848: , p7_a3 JTF_NUMBER_TABLE
849: , p7_a4 JTF_NUMBER_TABLE
850: , p7_a5 JTF_DATE_TABLE
851: , p7_a6 JTF_NUMBER_TABLE
852: , p7_a7 JTF_VARCHAR2_TABLE_100
845: , p7_a0 JTF_NUMBER_TABLE
846: , p7_a1 JTF_NUMBER_TABLE
847: , p7_a2 JTF_NUMBER_TABLE
848: , p7_a3 JTF_NUMBER_TABLE
849: , p7_a4 JTF_NUMBER_TABLE
850: , p7_a5 JTF_DATE_TABLE
851: , p7_a6 JTF_NUMBER_TABLE
852: , p7_a7 JTF_VARCHAR2_TABLE_100
853: , p7_a8 JTF_NUMBER_TABLE
847: , p7_a2 JTF_NUMBER_TABLE
848: , p7_a3 JTF_NUMBER_TABLE
849: , p7_a4 JTF_NUMBER_TABLE
850: , p7_a5 JTF_DATE_TABLE
851: , p7_a6 JTF_NUMBER_TABLE
852: , p7_a7 JTF_VARCHAR2_TABLE_100
853: , p7_a8 JTF_NUMBER_TABLE
854: , p7_a9 JTF_NUMBER_TABLE
855: , p7_a10 JTF_NUMBER_TABLE
849: , p7_a4 JTF_NUMBER_TABLE
850: , p7_a5 JTF_DATE_TABLE
851: , p7_a6 JTF_NUMBER_TABLE
852: , p7_a7 JTF_VARCHAR2_TABLE_100
853: , p7_a8 JTF_NUMBER_TABLE
854: , p7_a9 JTF_NUMBER_TABLE
855: , p7_a10 JTF_NUMBER_TABLE
856: , p7_a11 JTF_VARCHAR2_TABLE_100
857: , p7_a12 JTF_NUMBER_TABLE
850: , p7_a5 JTF_DATE_TABLE
851: , p7_a6 JTF_NUMBER_TABLE
852: , p7_a7 JTF_VARCHAR2_TABLE_100
853: , p7_a8 JTF_NUMBER_TABLE
854: , p7_a9 JTF_NUMBER_TABLE
855: , p7_a10 JTF_NUMBER_TABLE
856: , p7_a11 JTF_VARCHAR2_TABLE_100
857: , p7_a12 JTF_NUMBER_TABLE
858: , p7_a13 JTF_VARCHAR2_TABLE_100
851: , p7_a6 JTF_NUMBER_TABLE
852: , p7_a7 JTF_VARCHAR2_TABLE_100
853: , p7_a8 JTF_NUMBER_TABLE
854: , p7_a9 JTF_NUMBER_TABLE
855: , p7_a10 JTF_NUMBER_TABLE
856: , p7_a11 JTF_VARCHAR2_TABLE_100
857: , p7_a12 JTF_NUMBER_TABLE
858: , p7_a13 JTF_VARCHAR2_TABLE_100
859: , p7_a14 JTF_VARCHAR2_TABLE_100
853: , p7_a8 JTF_NUMBER_TABLE
854: , p7_a9 JTF_NUMBER_TABLE
855: , p7_a10 JTF_NUMBER_TABLE
856: , p7_a11 JTF_VARCHAR2_TABLE_100
857: , p7_a12 JTF_NUMBER_TABLE
858: , p7_a13 JTF_VARCHAR2_TABLE_100
859: , p7_a14 JTF_VARCHAR2_TABLE_100
860: , p7_a15 JTF_VARCHAR2_TABLE_300
861: )
966: , p9_a20 VARCHAR2
967: , p9_a21 NUMBER
968: , p9_a22 VARCHAR2
969: , p9_a23 VARCHAR2
970: , p10_a0 JTF_NUMBER_TABLE
971: , p10_a1 JTF_NUMBER_TABLE
972: , p10_a2 JTF_NUMBER_TABLE
973: , p10_a3 JTF_VARCHAR2_TABLE_300
974: , p10_a4 JTF_NUMBER_TABLE
967: , p9_a21 NUMBER
968: , p9_a22 VARCHAR2
969: , p9_a23 VARCHAR2
970: , p10_a0 JTF_NUMBER_TABLE
971: , p10_a1 JTF_NUMBER_TABLE
972: , p10_a2 JTF_NUMBER_TABLE
973: , p10_a3 JTF_VARCHAR2_TABLE_300
974: , p10_a4 JTF_NUMBER_TABLE
975: , p10_a5 JTF_NUMBER_TABLE
968: , p9_a22 VARCHAR2
969: , p9_a23 VARCHAR2
970: , p10_a0 JTF_NUMBER_TABLE
971: , p10_a1 JTF_NUMBER_TABLE
972: , p10_a2 JTF_NUMBER_TABLE
973: , p10_a3 JTF_VARCHAR2_TABLE_300
974: , p10_a4 JTF_NUMBER_TABLE
975: , p10_a5 JTF_NUMBER_TABLE
976: , p10_a6 JTF_NUMBER_TABLE
970: , p10_a0 JTF_NUMBER_TABLE
971: , p10_a1 JTF_NUMBER_TABLE
972: , p10_a2 JTF_NUMBER_TABLE
973: , p10_a3 JTF_VARCHAR2_TABLE_300
974: , p10_a4 JTF_NUMBER_TABLE
975: , p10_a5 JTF_NUMBER_TABLE
976: , p10_a6 JTF_NUMBER_TABLE
977: , p10_a7 JTF_DATE_TABLE
978: , p10_a8 JTF_DATE_TABLE
971: , p10_a1 JTF_NUMBER_TABLE
972: , p10_a2 JTF_NUMBER_TABLE
973: , p10_a3 JTF_VARCHAR2_TABLE_300
974: , p10_a4 JTF_NUMBER_TABLE
975: , p10_a5 JTF_NUMBER_TABLE
976: , p10_a6 JTF_NUMBER_TABLE
977: , p10_a7 JTF_DATE_TABLE
978: , p10_a8 JTF_DATE_TABLE
979: , p10_a9 JTF_VARCHAR2_TABLE_100
972: , p10_a2 JTF_NUMBER_TABLE
973: , p10_a3 JTF_VARCHAR2_TABLE_300
974: , p10_a4 JTF_NUMBER_TABLE
975: , p10_a5 JTF_NUMBER_TABLE
976: , p10_a6 JTF_NUMBER_TABLE
977: , p10_a7 JTF_DATE_TABLE
978: , p10_a8 JTF_DATE_TABLE
979: , p10_a9 JTF_VARCHAR2_TABLE_100
980: , p11_a0 JTF_NUMBER_TABLE
976: , p10_a6 JTF_NUMBER_TABLE
977: , p10_a7 JTF_DATE_TABLE
978: , p10_a8 JTF_DATE_TABLE
979: , p10_a9 JTF_VARCHAR2_TABLE_100
980: , p11_a0 JTF_NUMBER_TABLE
981: , p11_a1 JTF_NUMBER_TABLE
982: , p11_a2 JTF_NUMBER_TABLE
983: , p11_a3 JTF_NUMBER_TABLE
984: , p11_a4 JTF_NUMBER_TABLE
977: , p10_a7 JTF_DATE_TABLE
978: , p10_a8 JTF_DATE_TABLE
979: , p10_a9 JTF_VARCHAR2_TABLE_100
980: , p11_a0 JTF_NUMBER_TABLE
981: , p11_a1 JTF_NUMBER_TABLE
982: , p11_a2 JTF_NUMBER_TABLE
983: , p11_a3 JTF_NUMBER_TABLE
984: , p11_a4 JTF_NUMBER_TABLE
985: , p11_a5 JTF_NUMBER_TABLE
978: , p10_a8 JTF_DATE_TABLE
979: , p10_a9 JTF_VARCHAR2_TABLE_100
980: , p11_a0 JTF_NUMBER_TABLE
981: , p11_a1 JTF_NUMBER_TABLE
982: , p11_a2 JTF_NUMBER_TABLE
983: , p11_a3 JTF_NUMBER_TABLE
984: , p11_a4 JTF_NUMBER_TABLE
985: , p11_a5 JTF_NUMBER_TABLE
986: , p11_a6 JTF_NUMBER_TABLE
979: , p10_a9 JTF_VARCHAR2_TABLE_100
980: , p11_a0 JTF_NUMBER_TABLE
981: , p11_a1 JTF_NUMBER_TABLE
982: , p11_a2 JTF_NUMBER_TABLE
983: , p11_a3 JTF_NUMBER_TABLE
984: , p11_a4 JTF_NUMBER_TABLE
985: , p11_a5 JTF_NUMBER_TABLE
986: , p11_a6 JTF_NUMBER_TABLE
987: , p11_a7 JTF_VARCHAR2_TABLE_100
980: , p11_a0 JTF_NUMBER_TABLE
981: , p11_a1 JTF_NUMBER_TABLE
982: , p11_a2 JTF_NUMBER_TABLE
983: , p11_a3 JTF_NUMBER_TABLE
984: , p11_a4 JTF_NUMBER_TABLE
985: , p11_a5 JTF_NUMBER_TABLE
986: , p11_a6 JTF_NUMBER_TABLE
987: , p11_a7 JTF_VARCHAR2_TABLE_100
988: , p11_a8 JTF_NUMBER_TABLE
981: , p11_a1 JTF_NUMBER_TABLE
982: , p11_a2 JTF_NUMBER_TABLE
983: , p11_a3 JTF_NUMBER_TABLE
984: , p11_a4 JTF_NUMBER_TABLE
985: , p11_a5 JTF_NUMBER_TABLE
986: , p11_a6 JTF_NUMBER_TABLE
987: , p11_a7 JTF_VARCHAR2_TABLE_100
988: , p11_a8 JTF_NUMBER_TABLE
989: , p11_a9 JTF_NUMBER_TABLE
982: , p11_a2 JTF_NUMBER_TABLE
983: , p11_a3 JTF_NUMBER_TABLE
984: , p11_a4 JTF_NUMBER_TABLE
985: , p11_a5 JTF_NUMBER_TABLE
986: , p11_a6 JTF_NUMBER_TABLE
987: , p11_a7 JTF_VARCHAR2_TABLE_100
988: , p11_a8 JTF_NUMBER_TABLE
989: , p11_a9 JTF_NUMBER_TABLE
990: , p11_a10 JTF_NUMBER_TABLE
984: , p11_a4 JTF_NUMBER_TABLE
985: , p11_a5 JTF_NUMBER_TABLE
986: , p11_a6 JTF_NUMBER_TABLE
987: , p11_a7 JTF_VARCHAR2_TABLE_100
988: , p11_a8 JTF_NUMBER_TABLE
989: , p11_a9 JTF_NUMBER_TABLE
990: , p11_a10 JTF_NUMBER_TABLE
991: , p11_a11 JTF_NUMBER_TABLE
992: , p11_a12 JTF_NUMBER_TABLE
985: , p11_a5 JTF_NUMBER_TABLE
986: , p11_a6 JTF_NUMBER_TABLE
987: , p11_a7 JTF_VARCHAR2_TABLE_100
988: , p11_a8 JTF_NUMBER_TABLE
989: , p11_a9 JTF_NUMBER_TABLE
990: , p11_a10 JTF_NUMBER_TABLE
991: , p11_a11 JTF_NUMBER_TABLE
992: , p11_a12 JTF_NUMBER_TABLE
993: , p11_a13 JTF_NUMBER_TABLE
986: , p11_a6 JTF_NUMBER_TABLE
987: , p11_a7 JTF_VARCHAR2_TABLE_100
988: , p11_a8 JTF_NUMBER_TABLE
989: , p11_a9 JTF_NUMBER_TABLE
990: , p11_a10 JTF_NUMBER_TABLE
991: , p11_a11 JTF_NUMBER_TABLE
992: , p11_a12 JTF_NUMBER_TABLE
993: , p11_a13 JTF_NUMBER_TABLE
994: , p11_a14 JTF_NUMBER_TABLE
987: , p11_a7 JTF_VARCHAR2_TABLE_100
988: , p11_a8 JTF_NUMBER_TABLE
989: , p11_a9 JTF_NUMBER_TABLE
990: , p11_a10 JTF_NUMBER_TABLE
991: , p11_a11 JTF_NUMBER_TABLE
992: , p11_a12 JTF_NUMBER_TABLE
993: , p11_a13 JTF_NUMBER_TABLE
994: , p11_a14 JTF_NUMBER_TABLE
995: , p11_a15 JTF_NUMBER_TABLE
988: , p11_a8 JTF_NUMBER_TABLE
989: , p11_a9 JTF_NUMBER_TABLE
990: , p11_a10 JTF_NUMBER_TABLE
991: , p11_a11 JTF_NUMBER_TABLE
992: , p11_a12 JTF_NUMBER_TABLE
993: , p11_a13 JTF_NUMBER_TABLE
994: , p11_a14 JTF_NUMBER_TABLE
995: , p11_a15 JTF_NUMBER_TABLE
996: , p11_a16 JTF_NUMBER_TABLE
989: , p11_a9 JTF_NUMBER_TABLE
990: , p11_a10 JTF_NUMBER_TABLE
991: , p11_a11 JTF_NUMBER_TABLE
992: , p11_a12 JTF_NUMBER_TABLE
993: , p11_a13 JTF_NUMBER_TABLE
994: , p11_a14 JTF_NUMBER_TABLE
995: , p11_a15 JTF_NUMBER_TABLE
996: , p11_a16 JTF_NUMBER_TABLE
997: , p11_a17 JTF_VARCHAR2_TABLE_300
990: , p11_a10 JTF_NUMBER_TABLE
991: , p11_a11 JTF_NUMBER_TABLE
992: , p11_a12 JTF_NUMBER_TABLE
993: , p11_a13 JTF_NUMBER_TABLE
994: , p11_a14 JTF_NUMBER_TABLE
995: , p11_a15 JTF_NUMBER_TABLE
996: , p11_a16 JTF_NUMBER_TABLE
997: , p11_a17 JTF_VARCHAR2_TABLE_300
998: , p11_a18 JTF_DATE_TABLE
991: , p11_a11 JTF_NUMBER_TABLE
992: , p11_a12 JTF_NUMBER_TABLE
993: , p11_a13 JTF_NUMBER_TABLE
994: , p11_a14 JTF_NUMBER_TABLE
995: , p11_a15 JTF_NUMBER_TABLE
996: , p11_a16 JTF_NUMBER_TABLE
997: , p11_a17 JTF_VARCHAR2_TABLE_300
998: , p11_a18 JTF_DATE_TABLE
999: , p11_a19 JTF_DATE_TABLE
992: , p11_a12 JTF_NUMBER_TABLE
993: , p11_a13 JTF_NUMBER_TABLE
994: , p11_a14 JTF_NUMBER_TABLE
995: , p11_a15 JTF_NUMBER_TABLE
996: , p11_a16 JTF_NUMBER_TABLE
997: , p11_a17 JTF_VARCHAR2_TABLE_300
998: , p11_a18 JTF_DATE_TABLE
999: , p11_a19 JTF_DATE_TABLE
1000: , p11_a20 JTF_NUMBER_TABLE
996: , p11_a16 JTF_NUMBER_TABLE
997: , p11_a17 JTF_VARCHAR2_TABLE_300
998: , p11_a18 JTF_DATE_TABLE
999: , p11_a19 JTF_DATE_TABLE
1000: , p11_a20 JTF_NUMBER_TABLE
1001: , p11_a21 JTF_VARCHAR2_TABLE_100
1002: , p12_a0 JTF_NUMBER_TABLE
1003: , p12_a1 JTF_NUMBER_TABLE
1004: , p12_a2 JTF_NUMBER_TABLE
998: , p11_a18 JTF_DATE_TABLE
999: , p11_a19 JTF_DATE_TABLE
1000: , p11_a20 JTF_NUMBER_TABLE
1001: , p11_a21 JTF_VARCHAR2_TABLE_100
1002: , p12_a0 JTF_NUMBER_TABLE
1003: , p12_a1 JTF_NUMBER_TABLE
1004: , p12_a2 JTF_NUMBER_TABLE
1005: , p12_a3 JTF_NUMBER_TABLE
1006: , p12_a4 JTF_NUMBER_TABLE
999: , p11_a19 JTF_DATE_TABLE
1000: , p11_a20 JTF_NUMBER_TABLE
1001: , p11_a21 JTF_VARCHAR2_TABLE_100
1002: , p12_a0 JTF_NUMBER_TABLE
1003: , p12_a1 JTF_NUMBER_TABLE
1004: , p12_a2 JTF_NUMBER_TABLE
1005: , p12_a3 JTF_NUMBER_TABLE
1006: , p12_a4 JTF_NUMBER_TABLE
1007: , p12_a5 JTF_NUMBER_TABLE
1000: , p11_a20 JTF_NUMBER_TABLE
1001: , p11_a21 JTF_VARCHAR2_TABLE_100
1002: , p12_a0 JTF_NUMBER_TABLE
1003: , p12_a1 JTF_NUMBER_TABLE
1004: , p12_a2 JTF_NUMBER_TABLE
1005: , p12_a3 JTF_NUMBER_TABLE
1006: , p12_a4 JTF_NUMBER_TABLE
1007: , p12_a5 JTF_NUMBER_TABLE
1008: , p12_a6 JTF_NUMBER_TABLE
1001: , p11_a21 JTF_VARCHAR2_TABLE_100
1002: , p12_a0 JTF_NUMBER_TABLE
1003: , p12_a1 JTF_NUMBER_TABLE
1004: , p12_a2 JTF_NUMBER_TABLE
1005: , p12_a3 JTF_NUMBER_TABLE
1006: , p12_a4 JTF_NUMBER_TABLE
1007: , p12_a5 JTF_NUMBER_TABLE
1008: , p12_a6 JTF_NUMBER_TABLE
1009: , p12_a7 JTF_NUMBER_TABLE
1002: , p12_a0 JTF_NUMBER_TABLE
1003: , p12_a1 JTF_NUMBER_TABLE
1004: , p12_a2 JTF_NUMBER_TABLE
1005: , p12_a3 JTF_NUMBER_TABLE
1006: , p12_a4 JTF_NUMBER_TABLE
1007: , p12_a5 JTF_NUMBER_TABLE
1008: , p12_a6 JTF_NUMBER_TABLE
1009: , p12_a7 JTF_NUMBER_TABLE
1010: , p12_a8 JTF_NUMBER_TABLE
1003: , p12_a1 JTF_NUMBER_TABLE
1004: , p12_a2 JTF_NUMBER_TABLE
1005: , p12_a3 JTF_NUMBER_TABLE
1006: , p12_a4 JTF_NUMBER_TABLE
1007: , p12_a5 JTF_NUMBER_TABLE
1008: , p12_a6 JTF_NUMBER_TABLE
1009: , p12_a7 JTF_NUMBER_TABLE
1010: , p12_a8 JTF_NUMBER_TABLE
1011: , p12_a9 JTF_VARCHAR2_TABLE_100
1004: , p12_a2 JTF_NUMBER_TABLE
1005: , p12_a3 JTF_NUMBER_TABLE
1006: , p12_a4 JTF_NUMBER_TABLE
1007: , p12_a5 JTF_NUMBER_TABLE
1008: , p12_a6 JTF_NUMBER_TABLE
1009: , p12_a7 JTF_NUMBER_TABLE
1010: , p12_a8 JTF_NUMBER_TABLE
1011: , p12_a9 JTF_VARCHAR2_TABLE_100
1012: , p12_a10 JTF_DATE_TABLE
1005: , p12_a3 JTF_NUMBER_TABLE
1006: , p12_a4 JTF_NUMBER_TABLE
1007: , p12_a5 JTF_NUMBER_TABLE
1008: , p12_a6 JTF_NUMBER_TABLE
1009: , p12_a7 JTF_NUMBER_TABLE
1010: , p12_a8 JTF_NUMBER_TABLE
1011: , p12_a9 JTF_VARCHAR2_TABLE_100
1012: , p12_a10 JTF_DATE_TABLE
1013: , p12_a11 JTF_VARCHAR2_TABLE_100
1006: , p12_a4 JTF_NUMBER_TABLE
1007: , p12_a5 JTF_NUMBER_TABLE
1008: , p12_a6 JTF_NUMBER_TABLE
1009: , p12_a7 JTF_NUMBER_TABLE
1010: , p12_a8 JTF_NUMBER_TABLE
1011: , p12_a9 JTF_VARCHAR2_TABLE_100
1012: , p12_a10 JTF_DATE_TABLE
1013: , p12_a11 JTF_VARCHAR2_TABLE_100
1014: , x_group_id out nocopy NUMBER
1012: , p12_a10 JTF_DATE_TABLE
1013: , p12_a11 JTF_VARCHAR2_TABLE_100
1014: , x_group_id out nocopy NUMBER
1015: , x_header_id out nocopy NUMBER
1016: , p15_a0 out nocopy JTF_NUMBER_TABLE
1017: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
1018: , p15_a2 out nocopy JTF_NUMBER_TABLE
1019: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_32767
1020: )
1014: , x_group_id out nocopy NUMBER
1015: , x_header_id out nocopy NUMBER
1016: , p15_a0 out nocopy JTF_NUMBER_TABLE
1017: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
1018: , p15_a2 out nocopy JTF_NUMBER_TABLE
1019: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_32767
1020: )
1021:
1022: as