1: package body csd_hv_wip_job_pvt_w as
2: /* $Header: csdwhvjb.pls 120.14.12020000.4 2013/04/02 22:38:03 swai ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
1: package body csd_hv_wip_job_pvt_w as
2: /* $Header: csdwhvjb.pls 120.14.12020000.4 2013/04/02 22:38:03 swai ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: csdwhvjb.pls 120.14.12020000.4 2013/04/02 22:38:03 swai ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: ) as
3: procedure rosetta_table_copy_in_p3(t out nocopy csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: ) as
11: ddindx binary_integer; indx binary_integer;
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: ) as
11: ddindx binary_integer; indx binary_integer;
12: begin
13: if a0 is not null and a0.count > 0 then
31: end if;
32: end if;
33: end rosetta_table_copy_in_p3;
34: procedure rosetta_table_copy_out_p3(t csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
32: end if;
33: end rosetta_table_copy_in_p3;
34: procedure rosetta_table_copy_out_p3(t csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_NUMBER_TABLE
33: end rosetta_table_copy_in_p3;
34: procedure rosetta_table_copy_out_p3(t csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_NUMBER_TABLE
41: ) as
34: procedure rosetta_table_copy_out_p3(t csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_NUMBER_TABLE
41: ) as
42: ddindx binary_integer; indx binary_integer;
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_NUMBER_TABLE
41: ) as
42: ddindx binary_integer; indx binary_integer;
43: begin
44: if t is null or t.count = 0 then
42: ddindx binary_integer; indx binary_integer;
43: begin
44: if t is null or t.count = 0 then
45: a0 := JTF_VARCHAR2_TABLE_300();
46: a1 := JTF_NUMBER_TABLE();
47: a2 := JTF_NUMBER_TABLE();
48: a3 := JTF_NUMBER_TABLE();
49: a4 := JTF_NUMBER_TABLE();
50: a5 := JTF_VARCHAR2_TABLE_100();
43: begin
44: if t is null or t.count = 0 then
45: a0 := JTF_VARCHAR2_TABLE_300();
46: a1 := JTF_NUMBER_TABLE();
47: a2 := JTF_NUMBER_TABLE();
48: a3 := JTF_NUMBER_TABLE();
49: a4 := JTF_NUMBER_TABLE();
50: a5 := JTF_VARCHAR2_TABLE_100();
51: a6 := JTF_NUMBER_TABLE();
44: if t is null or t.count = 0 then
45: a0 := JTF_VARCHAR2_TABLE_300();
46: a1 := JTF_NUMBER_TABLE();
47: a2 := JTF_NUMBER_TABLE();
48: a3 := JTF_NUMBER_TABLE();
49: a4 := JTF_NUMBER_TABLE();
50: a5 := JTF_VARCHAR2_TABLE_100();
51: a6 := JTF_NUMBER_TABLE();
52: else
45: a0 := JTF_VARCHAR2_TABLE_300();
46: a1 := JTF_NUMBER_TABLE();
47: a2 := JTF_NUMBER_TABLE();
48: a3 := JTF_NUMBER_TABLE();
49: a4 := JTF_NUMBER_TABLE();
50: a5 := JTF_VARCHAR2_TABLE_100();
51: a6 := JTF_NUMBER_TABLE();
52: else
53: a0 := JTF_VARCHAR2_TABLE_300();
47: a2 := JTF_NUMBER_TABLE();
48: a3 := JTF_NUMBER_TABLE();
49: a4 := JTF_NUMBER_TABLE();
50: a5 := JTF_VARCHAR2_TABLE_100();
51: a6 := JTF_NUMBER_TABLE();
52: else
53: a0 := JTF_VARCHAR2_TABLE_300();
54: a1 := JTF_NUMBER_TABLE();
55: a2 := JTF_NUMBER_TABLE();
50: a5 := JTF_VARCHAR2_TABLE_100();
51: a6 := JTF_NUMBER_TABLE();
52: else
53: a0 := JTF_VARCHAR2_TABLE_300();
54: a1 := JTF_NUMBER_TABLE();
55: a2 := JTF_NUMBER_TABLE();
56: a3 := JTF_NUMBER_TABLE();
57: a4 := JTF_NUMBER_TABLE();
58: a5 := JTF_VARCHAR2_TABLE_100();
51: a6 := JTF_NUMBER_TABLE();
52: else
53: a0 := JTF_VARCHAR2_TABLE_300();
54: a1 := JTF_NUMBER_TABLE();
55: a2 := JTF_NUMBER_TABLE();
56: a3 := JTF_NUMBER_TABLE();
57: a4 := JTF_NUMBER_TABLE();
58: a5 := JTF_VARCHAR2_TABLE_100();
59: a6 := JTF_NUMBER_TABLE();
52: else
53: a0 := JTF_VARCHAR2_TABLE_300();
54: a1 := JTF_NUMBER_TABLE();
55: a2 := JTF_NUMBER_TABLE();
56: a3 := JTF_NUMBER_TABLE();
57: a4 := JTF_NUMBER_TABLE();
58: a5 := JTF_VARCHAR2_TABLE_100();
59: a6 := JTF_NUMBER_TABLE();
60: if t.count > 0 then
53: a0 := JTF_VARCHAR2_TABLE_300();
54: a1 := JTF_NUMBER_TABLE();
55: a2 := JTF_NUMBER_TABLE();
56: a3 := JTF_NUMBER_TABLE();
57: a4 := JTF_NUMBER_TABLE();
58: a5 := JTF_VARCHAR2_TABLE_100();
59: a6 := JTF_NUMBER_TABLE();
60: if t.count > 0 then
61: a0.extend(t.count);
55: a2 := JTF_NUMBER_TABLE();
56: a3 := JTF_NUMBER_TABLE();
57: a4 := JTF_NUMBER_TABLE();
58: a5 := JTF_VARCHAR2_TABLE_100();
59: a6 := JTF_NUMBER_TABLE();
60: if t.count > 0 then
61: a0.extend(t.count);
62: a1.extend(t.count);
63: a2.extend(t.count);
84: end if;
85: end if;
86: end rosetta_table_copy_out_p3;
87:
88: procedure rosetta_table_copy_in_p5(t out nocopy csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_NUMBER_TABLE
91: , a3 JTF_NUMBER_TABLE
92: , a4 JTF_NUMBER_TABLE
85: end if;
86: end rosetta_table_copy_out_p3;
87:
88: procedure rosetta_table_copy_in_p5(t out nocopy csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_NUMBER_TABLE
91: , a3 JTF_NUMBER_TABLE
92: , a4 JTF_NUMBER_TABLE
93: , a5 JTF_NUMBER_TABLE
86: end rosetta_table_copy_out_p3;
87:
88: procedure rosetta_table_copy_in_p5(t out nocopy csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_NUMBER_TABLE
91: , a3 JTF_NUMBER_TABLE
92: , a4 JTF_NUMBER_TABLE
93: , a5 JTF_NUMBER_TABLE
94: , a6 JTF_NUMBER_TABLE
87:
88: procedure rosetta_table_copy_in_p5(t out nocopy csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_NUMBER_TABLE
91: , a3 JTF_NUMBER_TABLE
92: , a4 JTF_NUMBER_TABLE
93: , a5 JTF_NUMBER_TABLE
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_NUMBER_TABLE
88: procedure rosetta_table_copy_in_p5(t out nocopy csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_NUMBER_TABLE
91: , a3 JTF_NUMBER_TABLE
92: , a4 JTF_NUMBER_TABLE
93: , a5 JTF_NUMBER_TABLE
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_NUMBER_TABLE
96: , a8 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_NUMBER_TABLE
91: , a3 JTF_NUMBER_TABLE
92: , a4 JTF_NUMBER_TABLE
93: , a5 JTF_NUMBER_TABLE
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_NUMBER_TABLE
96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_NUMBER_TABLE
90: , a2 JTF_NUMBER_TABLE
91: , a3 JTF_NUMBER_TABLE
92: , a4 JTF_NUMBER_TABLE
93: , a5 JTF_NUMBER_TABLE
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_NUMBER_TABLE
96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_NUMBER_TABLE
98: , a10 JTF_VARCHAR2_TABLE_100
91: , a3 JTF_NUMBER_TABLE
92: , a4 JTF_NUMBER_TABLE
93: , a5 JTF_NUMBER_TABLE
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_NUMBER_TABLE
96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_NUMBER_TABLE
98: , a10 JTF_VARCHAR2_TABLE_100
99: , a11 JTF_VARCHAR2_TABLE_100
92: , a4 JTF_NUMBER_TABLE
93: , a5 JTF_NUMBER_TABLE
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_NUMBER_TABLE
96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_NUMBER_TABLE
98: , a10 JTF_VARCHAR2_TABLE_100
99: , a11 JTF_VARCHAR2_TABLE_100
100: , a12 JTF_VARCHAR2_TABLE_100
93: , a5 JTF_NUMBER_TABLE
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_NUMBER_TABLE
96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_NUMBER_TABLE
98: , a10 JTF_VARCHAR2_TABLE_100
99: , a11 JTF_VARCHAR2_TABLE_100
100: , a12 JTF_VARCHAR2_TABLE_100
101: , a13 JTF_VARCHAR2_TABLE_100
99: , a11 JTF_VARCHAR2_TABLE_100
100: , a12 JTF_VARCHAR2_TABLE_100
101: , a13 JTF_VARCHAR2_TABLE_100
102: , a14 JTF_VARCHAR2_TABLE_100
103: , a15 JTF_NUMBER_TABLE
104: , a16 JTF_NUMBER_TABLE
105: , a17 JTF_NUMBER_TABLE
106: , a18 JTF_VARCHAR2_TABLE_100
107: , a19 JTF_NUMBER_TABLE
100: , a12 JTF_VARCHAR2_TABLE_100
101: , a13 JTF_VARCHAR2_TABLE_100
102: , a14 JTF_VARCHAR2_TABLE_100
103: , a15 JTF_NUMBER_TABLE
104: , a16 JTF_NUMBER_TABLE
105: , a17 JTF_NUMBER_TABLE
106: , a18 JTF_VARCHAR2_TABLE_100
107: , a19 JTF_NUMBER_TABLE
108: , a20 JTF_NUMBER_TABLE
101: , a13 JTF_VARCHAR2_TABLE_100
102: , a14 JTF_VARCHAR2_TABLE_100
103: , a15 JTF_NUMBER_TABLE
104: , a16 JTF_NUMBER_TABLE
105: , a17 JTF_NUMBER_TABLE
106: , a18 JTF_VARCHAR2_TABLE_100
107: , a19 JTF_NUMBER_TABLE
108: , a20 JTF_NUMBER_TABLE
109: , a21 JTF_NUMBER_TABLE
103: , a15 JTF_NUMBER_TABLE
104: , a16 JTF_NUMBER_TABLE
105: , a17 JTF_NUMBER_TABLE
106: , a18 JTF_VARCHAR2_TABLE_100
107: , a19 JTF_NUMBER_TABLE
108: , a20 JTF_NUMBER_TABLE
109: , a21 JTF_NUMBER_TABLE
110: , a22 JTF_VARCHAR2_TABLE_100
111: , a23 JTF_NUMBER_TABLE
104: , a16 JTF_NUMBER_TABLE
105: , a17 JTF_NUMBER_TABLE
106: , a18 JTF_VARCHAR2_TABLE_100
107: , a19 JTF_NUMBER_TABLE
108: , a20 JTF_NUMBER_TABLE
109: , a21 JTF_NUMBER_TABLE
110: , a22 JTF_VARCHAR2_TABLE_100
111: , a23 JTF_NUMBER_TABLE
112: , a24 JTF_VARCHAR2_TABLE_100
105: , a17 JTF_NUMBER_TABLE
106: , a18 JTF_VARCHAR2_TABLE_100
107: , a19 JTF_NUMBER_TABLE
108: , a20 JTF_NUMBER_TABLE
109: , a21 JTF_NUMBER_TABLE
110: , a22 JTF_VARCHAR2_TABLE_100
111: , a23 JTF_NUMBER_TABLE
112: , a24 JTF_VARCHAR2_TABLE_100
113: , a25 JTF_VARCHAR2_TABLE_200
107: , a19 JTF_NUMBER_TABLE
108: , a20 JTF_NUMBER_TABLE
109: , a21 JTF_NUMBER_TABLE
110: , a22 JTF_VARCHAR2_TABLE_100
111: , a23 JTF_NUMBER_TABLE
112: , a24 JTF_VARCHAR2_TABLE_100
113: , a25 JTF_VARCHAR2_TABLE_200
114: , a26 JTF_VARCHAR2_TABLE_200
115: , a27 JTF_VARCHAR2_TABLE_200
183: end loop;
184: end if;
185: end if;
186: end rosetta_table_copy_in_p5;
187: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_NUMBER_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
184: end if;
185: end if;
186: end rosetta_table_copy_in_p5;
187: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_NUMBER_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_NUMBER_TABLE
185: end if;
186: end rosetta_table_copy_in_p5;
187: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_NUMBER_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_NUMBER_TABLE
186: end rosetta_table_copy_in_p5;
187: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_NUMBER_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_NUMBER_TABLE
194: , a7 out nocopy JTF_NUMBER_TABLE
187: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_NUMBER_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_NUMBER_TABLE
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_NUMBER_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_NUMBER_TABLE
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_NUMBER_TABLE
196: , a9 out nocopy JTF_NUMBER_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_NUMBER_TABLE
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_NUMBER_TABLE
196: , a9 out nocopy JTF_NUMBER_TABLE
197: , a10 out nocopy JTF_VARCHAR2_TABLE_100
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_NUMBER_TABLE
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_NUMBER_TABLE
196: , a9 out nocopy JTF_NUMBER_TABLE
197: , a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , a11 out nocopy JTF_VARCHAR2_TABLE_100
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_NUMBER_TABLE
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_NUMBER_TABLE
196: , a9 out nocopy JTF_NUMBER_TABLE
197: , a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , a11 out nocopy JTF_VARCHAR2_TABLE_100
199: , a12 out nocopy JTF_VARCHAR2_TABLE_100
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_NUMBER_TABLE
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_NUMBER_TABLE
196: , a9 out nocopy JTF_NUMBER_TABLE
197: , a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , a11 out nocopy JTF_VARCHAR2_TABLE_100
199: , a12 out nocopy JTF_VARCHAR2_TABLE_100
200: , a13 out nocopy JTF_VARCHAR2_TABLE_100
198: , a11 out nocopy JTF_VARCHAR2_TABLE_100
199: , a12 out nocopy JTF_VARCHAR2_TABLE_100
200: , a13 out nocopy JTF_VARCHAR2_TABLE_100
201: , a14 out nocopy JTF_VARCHAR2_TABLE_100
202: , a15 out nocopy JTF_NUMBER_TABLE
203: , a16 out nocopy JTF_NUMBER_TABLE
204: , a17 out nocopy JTF_NUMBER_TABLE
205: , a18 out nocopy JTF_VARCHAR2_TABLE_100
206: , a19 out nocopy JTF_NUMBER_TABLE
199: , a12 out nocopy JTF_VARCHAR2_TABLE_100
200: , a13 out nocopy JTF_VARCHAR2_TABLE_100
201: , a14 out nocopy JTF_VARCHAR2_TABLE_100
202: , a15 out nocopy JTF_NUMBER_TABLE
203: , a16 out nocopy JTF_NUMBER_TABLE
204: , a17 out nocopy JTF_NUMBER_TABLE
205: , a18 out nocopy JTF_VARCHAR2_TABLE_100
206: , a19 out nocopy JTF_NUMBER_TABLE
207: , a20 out nocopy JTF_NUMBER_TABLE
200: , a13 out nocopy JTF_VARCHAR2_TABLE_100
201: , a14 out nocopy JTF_VARCHAR2_TABLE_100
202: , a15 out nocopy JTF_NUMBER_TABLE
203: , a16 out nocopy JTF_NUMBER_TABLE
204: , a17 out nocopy JTF_NUMBER_TABLE
205: , a18 out nocopy JTF_VARCHAR2_TABLE_100
206: , a19 out nocopy JTF_NUMBER_TABLE
207: , a20 out nocopy JTF_NUMBER_TABLE
208: , a21 out nocopy JTF_NUMBER_TABLE
202: , a15 out nocopy JTF_NUMBER_TABLE
203: , a16 out nocopy JTF_NUMBER_TABLE
204: , a17 out nocopy JTF_NUMBER_TABLE
205: , a18 out nocopy JTF_VARCHAR2_TABLE_100
206: , a19 out nocopy JTF_NUMBER_TABLE
207: , a20 out nocopy JTF_NUMBER_TABLE
208: , a21 out nocopy JTF_NUMBER_TABLE
209: , a22 out nocopy JTF_VARCHAR2_TABLE_100
210: , a23 out nocopy JTF_NUMBER_TABLE
203: , a16 out nocopy JTF_NUMBER_TABLE
204: , a17 out nocopy JTF_NUMBER_TABLE
205: , a18 out nocopy JTF_VARCHAR2_TABLE_100
206: , a19 out nocopy JTF_NUMBER_TABLE
207: , a20 out nocopy JTF_NUMBER_TABLE
208: , a21 out nocopy JTF_NUMBER_TABLE
209: , a22 out nocopy JTF_VARCHAR2_TABLE_100
210: , a23 out nocopy JTF_NUMBER_TABLE
211: , a24 out nocopy JTF_VARCHAR2_TABLE_100
204: , a17 out nocopy JTF_NUMBER_TABLE
205: , a18 out nocopy JTF_VARCHAR2_TABLE_100
206: , a19 out nocopy JTF_NUMBER_TABLE
207: , a20 out nocopy JTF_NUMBER_TABLE
208: , a21 out nocopy JTF_NUMBER_TABLE
209: , a22 out nocopy JTF_VARCHAR2_TABLE_100
210: , a23 out nocopy JTF_NUMBER_TABLE
211: , a24 out nocopy JTF_VARCHAR2_TABLE_100
212: , a25 out nocopy JTF_VARCHAR2_TABLE_200
206: , a19 out nocopy JTF_NUMBER_TABLE
207: , a20 out nocopy JTF_NUMBER_TABLE
208: , a21 out nocopy JTF_NUMBER_TABLE
209: , a22 out nocopy JTF_VARCHAR2_TABLE_100
210: , a23 out nocopy JTF_NUMBER_TABLE
211: , a24 out nocopy JTF_VARCHAR2_TABLE_100
212: , a25 out nocopy JTF_VARCHAR2_TABLE_200
213: , a26 out nocopy JTF_VARCHAR2_TABLE_200
214: , a27 out nocopy JTF_VARCHAR2_TABLE_200
228: ) as
229: ddindx binary_integer; indx binary_integer;
230: begin
231: if t is null or t.count = 0 then
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: ddindx binary_integer; indx binary_integer;
230: begin
231: if t is null or t.count = 0 then
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: begin
231: if t is null or t.count = 0 then
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: if t is null or t.count = 0 then
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_NUMBER_TABLE();
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_NUMBER_TABLE();
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_NUMBER_TABLE();
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_NUMBER_TABLE();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_VARCHAR2_TABLE_100();
235: a3 := JTF_NUMBER_TABLE();
236: a4 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_NUMBER_TABLE();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
236: a4 := JTF_NUMBER_TABLE();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_NUMBER_TABLE();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
244: a12 := JTF_VARCHAR2_TABLE_100();
237: a5 := JTF_NUMBER_TABLE();
238: a6 := JTF_NUMBER_TABLE();
239: a7 := JTF_NUMBER_TABLE();
240: a8 := JTF_NUMBER_TABLE();
241: a9 := JTF_NUMBER_TABLE();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
244: a12 := JTF_VARCHAR2_TABLE_100();
245: a13 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
244: a12 := JTF_VARCHAR2_TABLE_100();
245: a13 := JTF_VARCHAR2_TABLE_100();
246: a14 := JTF_VARCHAR2_TABLE_100();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_NUMBER_TABLE();
250: a18 := JTF_VARCHAR2_TABLE_100();
251: a19 := JTF_NUMBER_TABLE();
244: a12 := JTF_VARCHAR2_TABLE_100();
245: a13 := JTF_VARCHAR2_TABLE_100();
246: a14 := JTF_VARCHAR2_TABLE_100();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_NUMBER_TABLE();
250: a18 := JTF_VARCHAR2_TABLE_100();
251: a19 := JTF_NUMBER_TABLE();
252: a20 := JTF_NUMBER_TABLE();
245: a13 := JTF_VARCHAR2_TABLE_100();
246: a14 := JTF_VARCHAR2_TABLE_100();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_NUMBER_TABLE();
250: a18 := JTF_VARCHAR2_TABLE_100();
251: a19 := JTF_NUMBER_TABLE();
252: a20 := JTF_NUMBER_TABLE();
253: a21 := JTF_NUMBER_TABLE();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_NUMBER_TABLE();
250: a18 := JTF_VARCHAR2_TABLE_100();
251: a19 := JTF_NUMBER_TABLE();
252: a20 := JTF_NUMBER_TABLE();
253: a21 := JTF_NUMBER_TABLE();
254: a22 := JTF_VARCHAR2_TABLE_100();
255: a23 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_NUMBER_TABLE();
250: a18 := JTF_VARCHAR2_TABLE_100();
251: a19 := JTF_NUMBER_TABLE();
252: a20 := JTF_NUMBER_TABLE();
253: a21 := JTF_NUMBER_TABLE();
254: a22 := JTF_VARCHAR2_TABLE_100();
255: a23 := JTF_NUMBER_TABLE();
256: a24 := JTF_VARCHAR2_TABLE_100();
249: a17 := JTF_NUMBER_TABLE();
250: a18 := JTF_VARCHAR2_TABLE_100();
251: a19 := JTF_NUMBER_TABLE();
252: a20 := JTF_NUMBER_TABLE();
253: a21 := JTF_NUMBER_TABLE();
254: a22 := JTF_VARCHAR2_TABLE_100();
255: a23 := JTF_NUMBER_TABLE();
256: a24 := JTF_VARCHAR2_TABLE_100();
257: a25 := JTF_VARCHAR2_TABLE_200();
251: a19 := JTF_NUMBER_TABLE();
252: a20 := JTF_NUMBER_TABLE();
253: a21 := JTF_NUMBER_TABLE();
254: a22 := JTF_VARCHAR2_TABLE_100();
255: a23 := JTF_NUMBER_TABLE();
256: a24 := JTF_VARCHAR2_TABLE_100();
257: a25 := JTF_VARCHAR2_TABLE_200();
258: a26 := JTF_VARCHAR2_TABLE_200();
259: a27 := JTF_VARCHAR2_TABLE_200();
270: a38 := JTF_VARCHAR2_TABLE_200();
271: a39 := JTF_VARCHAR2_TABLE_200();
272: a40 := JTF_VARCHAR2_TABLE_100();
273: else
274: a0 := JTF_NUMBER_TABLE();
275: a1 := JTF_NUMBER_TABLE();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_NUMBER_TABLE();
278: a4 := JTF_NUMBER_TABLE();
271: a39 := JTF_VARCHAR2_TABLE_200();
272: a40 := JTF_VARCHAR2_TABLE_100();
273: else
274: a0 := JTF_NUMBER_TABLE();
275: a1 := JTF_NUMBER_TABLE();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_NUMBER_TABLE();
278: a4 := JTF_NUMBER_TABLE();
279: a5 := JTF_NUMBER_TABLE();
272: a40 := JTF_VARCHAR2_TABLE_100();
273: else
274: a0 := JTF_NUMBER_TABLE();
275: a1 := JTF_NUMBER_TABLE();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_NUMBER_TABLE();
278: a4 := JTF_NUMBER_TABLE();
279: a5 := JTF_NUMBER_TABLE();
280: a6 := JTF_NUMBER_TABLE();
273: else
274: a0 := JTF_NUMBER_TABLE();
275: a1 := JTF_NUMBER_TABLE();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_NUMBER_TABLE();
278: a4 := JTF_NUMBER_TABLE();
279: a5 := JTF_NUMBER_TABLE();
280: a6 := JTF_NUMBER_TABLE();
281: a7 := JTF_NUMBER_TABLE();
274: a0 := JTF_NUMBER_TABLE();
275: a1 := JTF_NUMBER_TABLE();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_NUMBER_TABLE();
278: a4 := JTF_NUMBER_TABLE();
279: a5 := JTF_NUMBER_TABLE();
280: a6 := JTF_NUMBER_TABLE();
281: a7 := JTF_NUMBER_TABLE();
282: a8 := JTF_NUMBER_TABLE();
275: a1 := JTF_NUMBER_TABLE();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_NUMBER_TABLE();
278: a4 := JTF_NUMBER_TABLE();
279: a5 := JTF_NUMBER_TABLE();
280: a6 := JTF_NUMBER_TABLE();
281: a7 := JTF_NUMBER_TABLE();
282: a8 := JTF_NUMBER_TABLE();
283: a9 := JTF_NUMBER_TABLE();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_NUMBER_TABLE();
278: a4 := JTF_NUMBER_TABLE();
279: a5 := JTF_NUMBER_TABLE();
280: a6 := JTF_NUMBER_TABLE();
281: a7 := JTF_NUMBER_TABLE();
282: a8 := JTF_NUMBER_TABLE();
283: a9 := JTF_NUMBER_TABLE();
284: a10 := JTF_VARCHAR2_TABLE_100();
277: a3 := JTF_NUMBER_TABLE();
278: a4 := JTF_NUMBER_TABLE();
279: a5 := JTF_NUMBER_TABLE();
280: a6 := JTF_NUMBER_TABLE();
281: a7 := JTF_NUMBER_TABLE();
282: a8 := JTF_NUMBER_TABLE();
283: a9 := JTF_NUMBER_TABLE();
284: a10 := JTF_VARCHAR2_TABLE_100();
285: a11 := JTF_VARCHAR2_TABLE_100();
278: a4 := JTF_NUMBER_TABLE();
279: a5 := JTF_NUMBER_TABLE();
280: a6 := JTF_NUMBER_TABLE();
281: a7 := JTF_NUMBER_TABLE();
282: a8 := JTF_NUMBER_TABLE();
283: a9 := JTF_NUMBER_TABLE();
284: a10 := JTF_VARCHAR2_TABLE_100();
285: a11 := JTF_VARCHAR2_TABLE_100();
286: a12 := JTF_VARCHAR2_TABLE_100();
279: a5 := JTF_NUMBER_TABLE();
280: a6 := JTF_NUMBER_TABLE();
281: a7 := JTF_NUMBER_TABLE();
282: a8 := JTF_NUMBER_TABLE();
283: a9 := JTF_NUMBER_TABLE();
284: a10 := JTF_VARCHAR2_TABLE_100();
285: a11 := JTF_VARCHAR2_TABLE_100();
286: a12 := JTF_VARCHAR2_TABLE_100();
287: a13 := JTF_VARCHAR2_TABLE_100();
285: a11 := JTF_VARCHAR2_TABLE_100();
286: a12 := JTF_VARCHAR2_TABLE_100();
287: a13 := JTF_VARCHAR2_TABLE_100();
288: a14 := JTF_VARCHAR2_TABLE_100();
289: a15 := JTF_NUMBER_TABLE();
290: a16 := JTF_NUMBER_TABLE();
291: a17 := JTF_NUMBER_TABLE();
292: a18 := JTF_VARCHAR2_TABLE_100();
293: a19 := JTF_NUMBER_TABLE();
286: a12 := JTF_VARCHAR2_TABLE_100();
287: a13 := JTF_VARCHAR2_TABLE_100();
288: a14 := JTF_VARCHAR2_TABLE_100();
289: a15 := JTF_NUMBER_TABLE();
290: a16 := JTF_NUMBER_TABLE();
291: a17 := JTF_NUMBER_TABLE();
292: a18 := JTF_VARCHAR2_TABLE_100();
293: a19 := JTF_NUMBER_TABLE();
294: a20 := JTF_NUMBER_TABLE();
287: a13 := JTF_VARCHAR2_TABLE_100();
288: a14 := JTF_VARCHAR2_TABLE_100();
289: a15 := JTF_NUMBER_TABLE();
290: a16 := JTF_NUMBER_TABLE();
291: a17 := JTF_NUMBER_TABLE();
292: a18 := JTF_VARCHAR2_TABLE_100();
293: a19 := JTF_NUMBER_TABLE();
294: a20 := JTF_NUMBER_TABLE();
295: a21 := JTF_NUMBER_TABLE();
289: a15 := JTF_NUMBER_TABLE();
290: a16 := JTF_NUMBER_TABLE();
291: a17 := JTF_NUMBER_TABLE();
292: a18 := JTF_VARCHAR2_TABLE_100();
293: a19 := JTF_NUMBER_TABLE();
294: a20 := JTF_NUMBER_TABLE();
295: a21 := JTF_NUMBER_TABLE();
296: a22 := JTF_VARCHAR2_TABLE_100();
297: a23 := JTF_NUMBER_TABLE();
290: a16 := JTF_NUMBER_TABLE();
291: a17 := JTF_NUMBER_TABLE();
292: a18 := JTF_VARCHAR2_TABLE_100();
293: a19 := JTF_NUMBER_TABLE();
294: a20 := JTF_NUMBER_TABLE();
295: a21 := JTF_NUMBER_TABLE();
296: a22 := JTF_VARCHAR2_TABLE_100();
297: a23 := JTF_NUMBER_TABLE();
298: a24 := JTF_VARCHAR2_TABLE_100();
291: a17 := JTF_NUMBER_TABLE();
292: a18 := JTF_VARCHAR2_TABLE_100();
293: a19 := JTF_NUMBER_TABLE();
294: a20 := JTF_NUMBER_TABLE();
295: a21 := JTF_NUMBER_TABLE();
296: a22 := JTF_VARCHAR2_TABLE_100();
297: a23 := JTF_NUMBER_TABLE();
298: a24 := JTF_VARCHAR2_TABLE_100();
299: a25 := JTF_VARCHAR2_TABLE_200();
293: a19 := JTF_NUMBER_TABLE();
294: a20 := JTF_NUMBER_TABLE();
295: a21 := JTF_NUMBER_TABLE();
296: a22 := JTF_VARCHAR2_TABLE_100();
297: a23 := JTF_NUMBER_TABLE();
298: a24 := JTF_VARCHAR2_TABLE_100();
299: a25 := JTF_VARCHAR2_TABLE_200();
300: a26 := JTF_VARCHAR2_TABLE_200();
301: a27 := JTF_VARCHAR2_TABLE_200();
407: end if;
408: end if;
409: end rosetta_table_copy_out_p5;
410:
411: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_NUMBER_TABLE
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
408: end if;
409: end rosetta_table_copy_out_p5;
410:
411: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_NUMBER_TABLE
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
409: end rosetta_table_copy_out_p5;
410:
411: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_NUMBER_TABLE
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
410:
411: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_NUMBER_TABLE
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
411: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_NUMBER_TABLE
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_NUMBER_TABLE
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
413: , a2 JTF_NUMBER_TABLE
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_NUMBER_TABLE
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_NUMBER_TABLE
422: , a11 JTF_VARCHAR2_TABLE_100
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_NUMBER_TABLE
422: , a11 JTF_VARCHAR2_TABLE_100
423: , a12 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_NUMBER_TABLE
422: , a11 JTF_VARCHAR2_TABLE_100
423: , a12 JTF_NUMBER_TABLE
424: , a13 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_NUMBER_TABLE
422: , a11 JTF_VARCHAR2_TABLE_100
423: , a12 JTF_NUMBER_TABLE
424: , a13 JTF_NUMBER_TABLE
425: , a14 JTF_VARCHAR2_TABLE_100
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_NUMBER_TABLE
422: , a11 JTF_VARCHAR2_TABLE_100
423: , a12 JTF_NUMBER_TABLE
424: , a13 JTF_NUMBER_TABLE
425: , a14 JTF_VARCHAR2_TABLE_100
426: , a15 JTF_VARCHAR2_TABLE_100
427: , a16 JTF_VARCHAR2_TABLE_100
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_NUMBER_TABLE
422: , a11 JTF_VARCHAR2_TABLE_100
423: , a12 JTF_NUMBER_TABLE
424: , a13 JTF_NUMBER_TABLE
425: , a14 JTF_VARCHAR2_TABLE_100
426: , a15 JTF_VARCHAR2_TABLE_100
427: , a16 JTF_VARCHAR2_TABLE_100
428: , a17 JTF_NUMBER_TABLE
424: , a13 JTF_NUMBER_TABLE
425: , a14 JTF_VARCHAR2_TABLE_100
426: , a15 JTF_VARCHAR2_TABLE_100
427: , a16 JTF_VARCHAR2_TABLE_100
428: , a17 JTF_NUMBER_TABLE
429: , a18 JTF_VARCHAR2_TABLE_100
430: , a19 JTF_NUMBER_TABLE
431: , a20 JTF_VARCHAR2_TABLE_100
432: , a21 JTF_VARCHAR2_TABLE_100
426: , a15 JTF_VARCHAR2_TABLE_100
427: , a16 JTF_VARCHAR2_TABLE_100
428: , a17 JTF_NUMBER_TABLE
429: , a18 JTF_VARCHAR2_TABLE_100
430: , a19 JTF_NUMBER_TABLE
431: , a20 JTF_VARCHAR2_TABLE_100
432: , a21 JTF_VARCHAR2_TABLE_100
433: , a22 JTF_VARCHAR2_TABLE_200
434: , a23 JTF_VARCHAR2_TABLE_200
498: end loop;
499: end if;
500: end if;
501: end rosetta_table_copy_in_p7;
502: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_NUMBER_TABLE
505: , a3 out nocopy JTF_NUMBER_TABLE
506: , a4 out nocopy JTF_NUMBER_TABLE
499: end if;
500: end if;
501: end rosetta_table_copy_in_p7;
502: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_NUMBER_TABLE
505: , a3 out nocopy JTF_NUMBER_TABLE
506: , a4 out nocopy JTF_NUMBER_TABLE
507: , a5 out nocopy JTF_NUMBER_TABLE
500: end if;
501: end rosetta_table_copy_in_p7;
502: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_NUMBER_TABLE
505: , a3 out nocopy JTF_NUMBER_TABLE
506: , a4 out nocopy JTF_NUMBER_TABLE
507: , a5 out nocopy JTF_NUMBER_TABLE
508: , a6 out nocopy JTF_NUMBER_TABLE
501: end rosetta_table_copy_in_p7;
502: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_NUMBER_TABLE
505: , a3 out nocopy JTF_NUMBER_TABLE
506: , a4 out nocopy JTF_NUMBER_TABLE
507: , a5 out nocopy JTF_NUMBER_TABLE
508: , a6 out nocopy JTF_NUMBER_TABLE
509: , a7 out nocopy JTF_NUMBER_TABLE
502: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_NUMBER_TABLE
505: , a3 out nocopy JTF_NUMBER_TABLE
506: , a4 out nocopy JTF_NUMBER_TABLE
507: , a5 out nocopy JTF_NUMBER_TABLE
508: , a6 out nocopy JTF_NUMBER_TABLE
509: , a7 out nocopy JTF_NUMBER_TABLE
510: , a8 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_NUMBER_TABLE
505: , a3 out nocopy JTF_NUMBER_TABLE
506: , a4 out nocopy JTF_NUMBER_TABLE
507: , a5 out nocopy JTF_NUMBER_TABLE
508: , a6 out nocopy JTF_NUMBER_TABLE
509: , a7 out nocopy JTF_NUMBER_TABLE
510: , a8 out nocopy JTF_NUMBER_TABLE
511: , a9 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_NUMBER_TABLE
505: , a3 out nocopy JTF_NUMBER_TABLE
506: , a4 out nocopy JTF_NUMBER_TABLE
507: , a5 out nocopy JTF_NUMBER_TABLE
508: , a6 out nocopy JTF_NUMBER_TABLE
509: , a7 out nocopy JTF_NUMBER_TABLE
510: , a8 out nocopy JTF_NUMBER_TABLE
511: , a9 out nocopy JTF_NUMBER_TABLE
512: , a10 out nocopy JTF_NUMBER_TABLE
505: , a3 out nocopy JTF_NUMBER_TABLE
506: , a4 out nocopy JTF_NUMBER_TABLE
507: , a5 out nocopy JTF_NUMBER_TABLE
508: , a6 out nocopy JTF_NUMBER_TABLE
509: , a7 out nocopy JTF_NUMBER_TABLE
510: , a8 out nocopy JTF_NUMBER_TABLE
511: , a9 out nocopy JTF_NUMBER_TABLE
512: , a10 out nocopy JTF_NUMBER_TABLE
513: , a11 out nocopy JTF_VARCHAR2_TABLE_100
506: , a4 out nocopy JTF_NUMBER_TABLE
507: , a5 out nocopy JTF_NUMBER_TABLE
508: , a6 out nocopy JTF_NUMBER_TABLE
509: , a7 out nocopy JTF_NUMBER_TABLE
510: , a8 out nocopy JTF_NUMBER_TABLE
511: , a9 out nocopy JTF_NUMBER_TABLE
512: , a10 out nocopy JTF_NUMBER_TABLE
513: , a11 out nocopy JTF_VARCHAR2_TABLE_100
514: , a12 out nocopy JTF_NUMBER_TABLE
507: , a5 out nocopy JTF_NUMBER_TABLE
508: , a6 out nocopy JTF_NUMBER_TABLE
509: , a7 out nocopy JTF_NUMBER_TABLE
510: , a8 out nocopy JTF_NUMBER_TABLE
511: , a9 out nocopy JTF_NUMBER_TABLE
512: , a10 out nocopy JTF_NUMBER_TABLE
513: , a11 out nocopy JTF_VARCHAR2_TABLE_100
514: , a12 out nocopy JTF_NUMBER_TABLE
515: , a13 out nocopy JTF_NUMBER_TABLE
508: , a6 out nocopy JTF_NUMBER_TABLE
509: , a7 out nocopy JTF_NUMBER_TABLE
510: , a8 out nocopy JTF_NUMBER_TABLE
511: , a9 out nocopy JTF_NUMBER_TABLE
512: , a10 out nocopy JTF_NUMBER_TABLE
513: , a11 out nocopy JTF_VARCHAR2_TABLE_100
514: , a12 out nocopy JTF_NUMBER_TABLE
515: , a13 out nocopy JTF_NUMBER_TABLE
516: , a14 out nocopy JTF_VARCHAR2_TABLE_100
510: , a8 out nocopy JTF_NUMBER_TABLE
511: , a9 out nocopy JTF_NUMBER_TABLE
512: , a10 out nocopy JTF_NUMBER_TABLE
513: , a11 out nocopy JTF_VARCHAR2_TABLE_100
514: , a12 out nocopy JTF_NUMBER_TABLE
515: , a13 out nocopy JTF_NUMBER_TABLE
516: , a14 out nocopy JTF_VARCHAR2_TABLE_100
517: , a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , a16 out nocopy JTF_VARCHAR2_TABLE_100
511: , a9 out nocopy JTF_NUMBER_TABLE
512: , a10 out nocopy JTF_NUMBER_TABLE
513: , a11 out nocopy JTF_VARCHAR2_TABLE_100
514: , a12 out nocopy JTF_NUMBER_TABLE
515: , a13 out nocopy JTF_NUMBER_TABLE
516: , a14 out nocopy JTF_VARCHAR2_TABLE_100
517: , a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , a16 out nocopy JTF_VARCHAR2_TABLE_100
519: , a17 out nocopy JTF_NUMBER_TABLE
515: , a13 out nocopy JTF_NUMBER_TABLE
516: , a14 out nocopy JTF_VARCHAR2_TABLE_100
517: , a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , a16 out nocopy JTF_VARCHAR2_TABLE_100
519: , a17 out nocopy JTF_NUMBER_TABLE
520: , a18 out nocopy JTF_VARCHAR2_TABLE_100
521: , a19 out nocopy JTF_NUMBER_TABLE
522: , a20 out nocopy JTF_VARCHAR2_TABLE_100
523: , a21 out nocopy JTF_VARCHAR2_TABLE_100
517: , a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , a16 out nocopy JTF_VARCHAR2_TABLE_100
519: , a17 out nocopy JTF_NUMBER_TABLE
520: , a18 out nocopy JTF_VARCHAR2_TABLE_100
521: , a19 out nocopy JTF_NUMBER_TABLE
522: , a20 out nocopy JTF_VARCHAR2_TABLE_100
523: , a21 out nocopy JTF_VARCHAR2_TABLE_100
524: , a22 out nocopy JTF_VARCHAR2_TABLE_200
525: , a23 out nocopy JTF_VARCHAR2_TABLE_200
539: ) as
540: ddindx binary_integer; indx binary_integer;
541: begin
542: if t is null or t.count = 0 then
543: a0 := JTF_NUMBER_TABLE();
544: a1 := JTF_NUMBER_TABLE();
545: a2 := JTF_NUMBER_TABLE();
546: a3 := JTF_NUMBER_TABLE();
547: a4 := JTF_NUMBER_TABLE();
540: ddindx binary_integer; indx binary_integer;
541: begin
542: if t is null or t.count = 0 then
543: a0 := JTF_NUMBER_TABLE();
544: a1 := JTF_NUMBER_TABLE();
545: a2 := JTF_NUMBER_TABLE();
546: a3 := JTF_NUMBER_TABLE();
547: a4 := JTF_NUMBER_TABLE();
548: a5 := JTF_NUMBER_TABLE();
541: begin
542: if t is null or t.count = 0 then
543: a0 := JTF_NUMBER_TABLE();
544: a1 := JTF_NUMBER_TABLE();
545: a2 := JTF_NUMBER_TABLE();
546: a3 := JTF_NUMBER_TABLE();
547: a4 := JTF_NUMBER_TABLE();
548: a5 := JTF_NUMBER_TABLE();
549: a6 := JTF_NUMBER_TABLE();
542: if t is null or t.count = 0 then
543: a0 := JTF_NUMBER_TABLE();
544: a1 := JTF_NUMBER_TABLE();
545: a2 := JTF_NUMBER_TABLE();
546: a3 := JTF_NUMBER_TABLE();
547: a4 := JTF_NUMBER_TABLE();
548: a5 := JTF_NUMBER_TABLE();
549: a6 := JTF_NUMBER_TABLE();
550: a7 := JTF_NUMBER_TABLE();
543: a0 := JTF_NUMBER_TABLE();
544: a1 := JTF_NUMBER_TABLE();
545: a2 := JTF_NUMBER_TABLE();
546: a3 := JTF_NUMBER_TABLE();
547: a4 := JTF_NUMBER_TABLE();
548: a5 := JTF_NUMBER_TABLE();
549: a6 := JTF_NUMBER_TABLE();
550: a7 := JTF_NUMBER_TABLE();
551: a8 := JTF_NUMBER_TABLE();
544: a1 := JTF_NUMBER_TABLE();
545: a2 := JTF_NUMBER_TABLE();
546: a3 := JTF_NUMBER_TABLE();
547: a4 := JTF_NUMBER_TABLE();
548: a5 := JTF_NUMBER_TABLE();
549: a6 := JTF_NUMBER_TABLE();
550: a7 := JTF_NUMBER_TABLE();
551: a8 := JTF_NUMBER_TABLE();
552: a9 := JTF_NUMBER_TABLE();
545: a2 := JTF_NUMBER_TABLE();
546: a3 := JTF_NUMBER_TABLE();
547: a4 := JTF_NUMBER_TABLE();
548: a5 := JTF_NUMBER_TABLE();
549: a6 := JTF_NUMBER_TABLE();
550: a7 := JTF_NUMBER_TABLE();
551: a8 := JTF_NUMBER_TABLE();
552: a9 := JTF_NUMBER_TABLE();
553: a10 := JTF_NUMBER_TABLE();
546: a3 := JTF_NUMBER_TABLE();
547: a4 := JTF_NUMBER_TABLE();
548: a5 := JTF_NUMBER_TABLE();
549: a6 := JTF_NUMBER_TABLE();
550: a7 := JTF_NUMBER_TABLE();
551: a8 := JTF_NUMBER_TABLE();
552: a9 := JTF_NUMBER_TABLE();
553: a10 := JTF_NUMBER_TABLE();
554: a11 := JTF_VARCHAR2_TABLE_100();
547: a4 := JTF_NUMBER_TABLE();
548: a5 := JTF_NUMBER_TABLE();
549: a6 := JTF_NUMBER_TABLE();
550: a7 := JTF_NUMBER_TABLE();
551: a8 := JTF_NUMBER_TABLE();
552: a9 := JTF_NUMBER_TABLE();
553: a10 := JTF_NUMBER_TABLE();
554: a11 := JTF_VARCHAR2_TABLE_100();
555: a12 := JTF_NUMBER_TABLE();
548: a5 := JTF_NUMBER_TABLE();
549: a6 := JTF_NUMBER_TABLE();
550: a7 := JTF_NUMBER_TABLE();
551: a8 := JTF_NUMBER_TABLE();
552: a9 := JTF_NUMBER_TABLE();
553: a10 := JTF_NUMBER_TABLE();
554: a11 := JTF_VARCHAR2_TABLE_100();
555: a12 := JTF_NUMBER_TABLE();
556: a13 := JTF_NUMBER_TABLE();
549: a6 := JTF_NUMBER_TABLE();
550: a7 := JTF_NUMBER_TABLE();
551: a8 := JTF_NUMBER_TABLE();
552: a9 := JTF_NUMBER_TABLE();
553: a10 := JTF_NUMBER_TABLE();
554: a11 := JTF_VARCHAR2_TABLE_100();
555: a12 := JTF_NUMBER_TABLE();
556: a13 := JTF_NUMBER_TABLE();
557: a14 := JTF_VARCHAR2_TABLE_100();
551: a8 := JTF_NUMBER_TABLE();
552: a9 := JTF_NUMBER_TABLE();
553: a10 := JTF_NUMBER_TABLE();
554: a11 := JTF_VARCHAR2_TABLE_100();
555: a12 := JTF_NUMBER_TABLE();
556: a13 := JTF_NUMBER_TABLE();
557: a14 := JTF_VARCHAR2_TABLE_100();
558: a15 := JTF_VARCHAR2_TABLE_100();
559: a16 := JTF_VARCHAR2_TABLE_100();
552: a9 := JTF_NUMBER_TABLE();
553: a10 := JTF_NUMBER_TABLE();
554: a11 := JTF_VARCHAR2_TABLE_100();
555: a12 := JTF_NUMBER_TABLE();
556: a13 := JTF_NUMBER_TABLE();
557: a14 := JTF_VARCHAR2_TABLE_100();
558: a15 := JTF_VARCHAR2_TABLE_100();
559: a16 := JTF_VARCHAR2_TABLE_100();
560: a17 := JTF_NUMBER_TABLE();
556: a13 := JTF_NUMBER_TABLE();
557: a14 := JTF_VARCHAR2_TABLE_100();
558: a15 := JTF_VARCHAR2_TABLE_100();
559: a16 := JTF_VARCHAR2_TABLE_100();
560: a17 := JTF_NUMBER_TABLE();
561: a18 := JTF_VARCHAR2_TABLE_100();
562: a19 := JTF_NUMBER_TABLE();
563: a20 := JTF_VARCHAR2_TABLE_100();
564: a21 := JTF_VARCHAR2_TABLE_100();
558: a15 := JTF_VARCHAR2_TABLE_100();
559: a16 := JTF_VARCHAR2_TABLE_100();
560: a17 := JTF_NUMBER_TABLE();
561: a18 := JTF_VARCHAR2_TABLE_100();
562: a19 := JTF_NUMBER_TABLE();
563: a20 := JTF_VARCHAR2_TABLE_100();
564: a21 := JTF_VARCHAR2_TABLE_100();
565: a22 := JTF_VARCHAR2_TABLE_200();
566: a23 := JTF_VARCHAR2_TABLE_200();
577: a34 := JTF_VARCHAR2_TABLE_200();
578: a35 := JTF_VARCHAR2_TABLE_200();
579: a36 := JTF_VARCHAR2_TABLE_200();
580: else
581: a0 := JTF_NUMBER_TABLE();
582: a1 := JTF_NUMBER_TABLE();
583: a2 := JTF_NUMBER_TABLE();
584: a3 := JTF_NUMBER_TABLE();
585: a4 := JTF_NUMBER_TABLE();
578: a35 := JTF_VARCHAR2_TABLE_200();
579: a36 := JTF_VARCHAR2_TABLE_200();
580: else
581: a0 := JTF_NUMBER_TABLE();
582: a1 := JTF_NUMBER_TABLE();
583: a2 := JTF_NUMBER_TABLE();
584: a3 := JTF_NUMBER_TABLE();
585: a4 := JTF_NUMBER_TABLE();
586: a5 := JTF_NUMBER_TABLE();
579: a36 := JTF_VARCHAR2_TABLE_200();
580: else
581: a0 := JTF_NUMBER_TABLE();
582: a1 := JTF_NUMBER_TABLE();
583: a2 := JTF_NUMBER_TABLE();
584: a3 := JTF_NUMBER_TABLE();
585: a4 := JTF_NUMBER_TABLE();
586: a5 := JTF_NUMBER_TABLE();
587: a6 := JTF_NUMBER_TABLE();
580: else
581: a0 := JTF_NUMBER_TABLE();
582: a1 := JTF_NUMBER_TABLE();
583: a2 := JTF_NUMBER_TABLE();
584: a3 := JTF_NUMBER_TABLE();
585: a4 := JTF_NUMBER_TABLE();
586: a5 := JTF_NUMBER_TABLE();
587: a6 := JTF_NUMBER_TABLE();
588: a7 := JTF_NUMBER_TABLE();
581: a0 := JTF_NUMBER_TABLE();
582: a1 := JTF_NUMBER_TABLE();
583: a2 := JTF_NUMBER_TABLE();
584: a3 := JTF_NUMBER_TABLE();
585: a4 := JTF_NUMBER_TABLE();
586: a5 := JTF_NUMBER_TABLE();
587: a6 := JTF_NUMBER_TABLE();
588: a7 := JTF_NUMBER_TABLE();
589: a8 := JTF_NUMBER_TABLE();
582: a1 := JTF_NUMBER_TABLE();
583: a2 := JTF_NUMBER_TABLE();
584: a3 := JTF_NUMBER_TABLE();
585: a4 := JTF_NUMBER_TABLE();
586: a5 := JTF_NUMBER_TABLE();
587: a6 := JTF_NUMBER_TABLE();
588: a7 := JTF_NUMBER_TABLE();
589: a8 := JTF_NUMBER_TABLE();
590: a9 := JTF_NUMBER_TABLE();
583: a2 := JTF_NUMBER_TABLE();
584: a3 := JTF_NUMBER_TABLE();
585: a4 := JTF_NUMBER_TABLE();
586: a5 := JTF_NUMBER_TABLE();
587: a6 := JTF_NUMBER_TABLE();
588: a7 := JTF_NUMBER_TABLE();
589: a8 := JTF_NUMBER_TABLE();
590: a9 := JTF_NUMBER_TABLE();
591: a10 := JTF_NUMBER_TABLE();
584: a3 := JTF_NUMBER_TABLE();
585: a4 := JTF_NUMBER_TABLE();
586: a5 := JTF_NUMBER_TABLE();
587: a6 := JTF_NUMBER_TABLE();
588: a7 := JTF_NUMBER_TABLE();
589: a8 := JTF_NUMBER_TABLE();
590: a9 := JTF_NUMBER_TABLE();
591: a10 := JTF_NUMBER_TABLE();
592: a11 := JTF_VARCHAR2_TABLE_100();
585: a4 := JTF_NUMBER_TABLE();
586: a5 := JTF_NUMBER_TABLE();
587: a6 := JTF_NUMBER_TABLE();
588: a7 := JTF_NUMBER_TABLE();
589: a8 := JTF_NUMBER_TABLE();
590: a9 := JTF_NUMBER_TABLE();
591: a10 := JTF_NUMBER_TABLE();
592: a11 := JTF_VARCHAR2_TABLE_100();
593: a12 := JTF_NUMBER_TABLE();
586: a5 := JTF_NUMBER_TABLE();
587: a6 := JTF_NUMBER_TABLE();
588: a7 := JTF_NUMBER_TABLE();
589: a8 := JTF_NUMBER_TABLE();
590: a9 := JTF_NUMBER_TABLE();
591: a10 := JTF_NUMBER_TABLE();
592: a11 := JTF_VARCHAR2_TABLE_100();
593: a12 := JTF_NUMBER_TABLE();
594: a13 := JTF_NUMBER_TABLE();
587: a6 := JTF_NUMBER_TABLE();
588: a7 := JTF_NUMBER_TABLE();
589: a8 := JTF_NUMBER_TABLE();
590: a9 := JTF_NUMBER_TABLE();
591: a10 := JTF_NUMBER_TABLE();
592: a11 := JTF_VARCHAR2_TABLE_100();
593: a12 := JTF_NUMBER_TABLE();
594: a13 := JTF_NUMBER_TABLE();
595: a14 := JTF_VARCHAR2_TABLE_100();
589: a8 := JTF_NUMBER_TABLE();
590: a9 := JTF_NUMBER_TABLE();
591: a10 := JTF_NUMBER_TABLE();
592: a11 := JTF_VARCHAR2_TABLE_100();
593: a12 := JTF_NUMBER_TABLE();
594: a13 := JTF_NUMBER_TABLE();
595: a14 := JTF_VARCHAR2_TABLE_100();
596: a15 := JTF_VARCHAR2_TABLE_100();
597: a16 := JTF_VARCHAR2_TABLE_100();
590: a9 := JTF_NUMBER_TABLE();
591: a10 := JTF_NUMBER_TABLE();
592: a11 := JTF_VARCHAR2_TABLE_100();
593: a12 := JTF_NUMBER_TABLE();
594: a13 := JTF_NUMBER_TABLE();
595: a14 := JTF_VARCHAR2_TABLE_100();
596: a15 := JTF_VARCHAR2_TABLE_100();
597: a16 := JTF_VARCHAR2_TABLE_100();
598: a17 := JTF_NUMBER_TABLE();
594: a13 := JTF_NUMBER_TABLE();
595: a14 := JTF_VARCHAR2_TABLE_100();
596: a15 := JTF_VARCHAR2_TABLE_100();
597: a16 := JTF_VARCHAR2_TABLE_100();
598: a17 := JTF_NUMBER_TABLE();
599: a18 := JTF_VARCHAR2_TABLE_100();
600: a19 := JTF_NUMBER_TABLE();
601: a20 := JTF_VARCHAR2_TABLE_100();
602: a21 := JTF_VARCHAR2_TABLE_100();
596: a15 := JTF_VARCHAR2_TABLE_100();
597: a16 := JTF_VARCHAR2_TABLE_100();
598: a17 := JTF_NUMBER_TABLE();
599: a18 := JTF_VARCHAR2_TABLE_100();
600: a19 := JTF_NUMBER_TABLE();
601: a20 := JTF_VARCHAR2_TABLE_100();
602: a21 := JTF_VARCHAR2_TABLE_100();
603: a22 := JTF_VARCHAR2_TABLE_200();
604: a23 := JTF_VARCHAR2_TABLE_200();
702: end if;
703: end if;
704: end rosetta_table_copy_out_p7;
705:
706: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
707: , a1 JTF_NUMBER_TABLE
708: , a2 JTF_NUMBER_TABLE
709: , a3 JTF_NUMBER_TABLE
710: , a4 JTF_VARCHAR2_TABLE_300
703: end if;
704: end rosetta_table_copy_out_p7;
705:
706: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
707: , a1 JTF_NUMBER_TABLE
708: , a2 JTF_NUMBER_TABLE
709: , a3 JTF_NUMBER_TABLE
710: , a4 JTF_VARCHAR2_TABLE_300
711: , a5 JTF_DATE_TABLE
704: end rosetta_table_copy_out_p7;
705:
706: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
707: , a1 JTF_NUMBER_TABLE
708: , a2 JTF_NUMBER_TABLE
709: , a3 JTF_NUMBER_TABLE
710: , a4 JTF_VARCHAR2_TABLE_300
711: , a5 JTF_DATE_TABLE
712: , a6 JTF_DATE_TABLE
705:
706: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
707: , a1 JTF_NUMBER_TABLE
708: , a2 JTF_NUMBER_TABLE
709: , a3 JTF_NUMBER_TABLE
710: , a4 JTF_VARCHAR2_TABLE_300
711: , a5 JTF_DATE_TABLE
712: , a6 JTF_DATE_TABLE
713: , a7 JTF_DATE_TABLE
711: , a5 JTF_DATE_TABLE
712: , a6 JTF_DATE_TABLE
713: , a7 JTF_DATE_TABLE
714: , a8 JTF_DATE_TABLE
715: , a9 JTF_NUMBER_TABLE
716: , a10 JTF_NUMBER_TABLE
717: , a11 JTF_NUMBER_TABLE
718: , a12 JTF_NUMBER_TABLE
719: , a13 JTF_NUMBER_TABLE
712: , a6 JTF_DATE_TABLE
713: , a7 JTF_DATE_TABLE
714: , a8 JTF_DATE_TABLE
715: , a9 JTF_NUMBER_TABLE
716: , a10 JTF_NUMBER_TABLE
717: , a11 JTF_NUMBER_TABLE
718: , a12 JTF_NUMBER_TABLE
719: , a13 JTF_NUMBER_TABLE
720: , a14 JTF_VARCHAR2_TABLE_100
713: , a7 JTF_DATE_TABLE
714: , a8 JTF_DATE_TABLE
715: , a9 JTF_NUMBER_TABLE
716: , a10 JTF_NUMBER_TABLE
717: , a11 JTF_NUMBER_TABLE
718: , a12 JTF_NUMBER_TABLE
719: , a13 JTF_NUMBER_TABLE
720: , a14 JTF_VARCHAR2_TABLE_100
721: , a15 JTF_VARCHAR2_TABLE_100
714: , a8 JTF_DATE_TABLE
715: , a9 JTF_NUMBER_TABLE
716: , a10 JTF_NUMBER_TABLE
717: , a11 JTF_NUMBER_TABLE
718: , a12 JTF_NUMBER_TABLE
719: , a13 JTF_NUMBER_TABLE
720: , a14 JTF_VARCHAR2_TABLE_100
721: , a15 JTF_VARCHAR2_TABLE_100
722: , a16 JTF_NUMBER_TABLE
715: , a9 JTF_NUMBER_TABLE
716: , a10 JTF_NUMBER_TABLE
717: , a11 JTF_NUMBER_TABLE
718: , a12 JTF_NUMBER_TABLE
719: , a13 JTF_NUMBER_TABLE
720: , a14 JTF_VARCHAR2_TABLE_100
721: , a15 JTF_VARCHAR2_TABLE_100
722: , a16 JTF_NUMBER_TABLE
723: , a17 JTF_VARCHAR2_TABLE_100
718: , a12 JTF_NUMBER_TABLE
719: , a13 JTF_NUMBER_TABLE
720: , a14 JTF_VARCHAR2_TABLE_100
721: , a15 JTF_VARCHAR2_TABLE_100
722: , a16 JTF_NUMBER_TABLE
723: , a17 JTF_VARCHAR2_TABLE_100
724: , a18 JTF_VARCHAR2_TABLE_100
725: , a19 JTF_VARCHAR2_TABLE_200
726: , a20 JTF_VARCHAR2_TABLE_200
787: end loop;
788: end if;
789: end if;
790: end rosetta_table_copy_in_p9;
791: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_NUMBER_TABLE
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_300
788: end if;
789: end if;
790: end rosetta_table_copy_in_p9;
791: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_NUMBER_TABLE
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_300
796: , a5 out nocopy JTF_DATE_TABLE
789: end if;
790: end rosetta_table_copy_in_p9;
791: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_NUMBER_TABLE
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_300
796: , a5 out nocopy JTF_DATE_TABLE
797: , a6 out nocopy JTF_DATE_TABLE
790: end rosetta_table_copy_in_p9;
791: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_NUMBER_TABLE
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_300
796: , a5 out nocopy JTF_DATE_TABLE
797: , a6 out nocopy JTF_DATE_TABLE
798: , a7 out nocopy JTF_DATE_TABLE
796: , a5 out nocopy JTF_DATE_TABLE
797: , a6 out nocopy JTF_DATE_TABLE
798: , a7 out nocopy JTF_DATE_TABLE
799: , a8 out nocopy JTF_DATE_TABLE
800: , a9 out nocopy JTF_NUMBER_TABLE
801: , a10 out nocopy JTF_NUMBER_TABLE
802: , a11 out nocopy JTF_NUMBER_TABLE
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
797: , a6 out nocopy JTF_DATE_TABLE
798: , a7 out nocopy JTF_DATE_TABLE
799: , a8 out nocopy JTF_DATE_TABLE
800: , a9 out nocopy JTF_NUMBER_TABLE
801: , a10 out nocopy JTF_NUMBER_TABLE
802: , a11 out nocopy JTF_NUMBER_TABLE
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
798: , a7 out nocopy JTF_DATE_TABLE
799: , a8 out nocopy JTF_DATE_TABLE
800: , a9 out nocopy JTF_NUMBER_TABLE
801: , a10 out nocopy JTF_NUMBER_TABLE
802: , a11 out nocopy JTF_NUMBER_TABLE
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
806: , a15 out nocopy JTF_VARCHAR2_TABLE_100
799: , a8 out nocopy JTF_DATE_TABLE
800: , a9 out nocopy JTF_NUMBER_TABLE
801: , a10 out nocopy JTF_NUMBER_TABLE
802: , a11 out nocopy JTF_NUMBER_TABLE
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
806: , a15 out nocopy JTF_VARCHAR2_TABLE_100
807: , a16 out nocopy JTF_NUMBER_TABLE
800: , a9 out nocopy JTF_NUMBER_TABLE
801: , a10 out nocopy JTF_NUMBER_TABLE
802: , a11 out nocopy JTF_NUMBER_TABLE
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
806: , a15 out nocopy JTF_VARCHAR2_TABLE_100
807: , a16 out nocopy JTF_NUMBER_TABLE
808: , a17 out nocopy JTF_VARCHAR2_TABLE_100
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
806: , a15 out nocopy JTF_VARCHAR2_TABLE_100
807: , a16 out nocopy JTF_NUMBER_TABLE
808: , a17 out nocopy JTF_VARCHAR2_TABLE_100
809: , a18 out nocopy JTF_VARCHAR2_TABLE_100
810: , a19 out nocopy JTF_VARCHAR2_TABLE_200
811: , a20 out nocopy JTF_VARCHAR2_TABLE_200
825: ) as
826: ddindx binary_integer; indx binary_integer;
827: begin
828: if t is null or t.count = 0 then
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
831: a2 := JTF_NUMBER_TABLE();
832: a3 := JTF_NUMBER_TABLE();
833: a4 := JTF_VARCHAR2_TABLE_300();
826: ddindx binary_integer; indx binary_integer;
827: begin
828: if t is null or t.count = 0 then
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
831: a2 := JTF_NUMBER_TABLE();
832: a3 := JTF_NUMBER_TABLE();
833: a4 := JTF_VARCHAR2_TABLE_300();
834: a5 := JTF_DATE_TABLE();
827: begin
828: if t is null or t.count = 0 then
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
831: a2 := JTF_NUMBER_TABLE();
832: a3 := JTF_NUMBER_TABLE();
833: a4 := JTF_VARCHAR2_TABLE_300();
834: a5 := JTF_DATE_TABLE();
835: a6 := JTF_DATE_TABLE();
828: if t is null or t.count = 0 then
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
831: a2 := JTF_NUMBER_TABLE();
832: a3 := JTF_NUMBER_TABLE();
833: a4 := JTF_VARCHAR2_TABLE_300();
834: a5 := JTF_DATE_TABLE();
835: a6 := JTF_DATE_TABLE();
836: a7 := JTF_DATE_TABLE();
834: a5 := JTF_DATE_TABLE();
835: a6 := JTF_DATE_TABLE();
836: a7 := JTF_DATE_TABLE();
837: a8 := JTF_DATE_TABLE();
838: a9 := JTF_NUMBER_TABLE();
839: a10 := JTF_NUMBER_TABLE();
840: a11 := JTF_NUMBER_TABLE();
841: a12 := JTF_NUMBER_TABLE();
842: a13 := JTF_NUMBER_TABLE();
835: a6 := JTF_DATE_TABLE();
836: a7 := JTF_DATE_TABLE();
837: a8 := JTF_DATE_TABLE();
838: a9 := JTF_NUMBER_TABLE();
839: a10 := JTF_NUMBER_TABLE();
840: a11 := JTF_NUMBER_TABLE();
841: a12 := JTF_NUMBER_TABLE();
842: a13 := JTF_NUMBER_TABLE();
843: a14 := JTF_VARCHAR2_TABLE_100();
836: a7 := JTF_DATE_TABLE();
837: a8 := JTF_DATE_TABLE();
838: a9 := JTF_NUMBER_TABLE();
839: a10 := JTF_NUMBER_TABLE();
840: a11 := JTF_NUMBER_TABLE();
841: a12 := JTF_NUMBER_TABLE();
842: a13 := JTF_NUMBER_TABLE();
843: a14 := JTF_VARCHAR2_TABLE_100();
844: a15 := JTF_VARCHAR2_TABLE_100();
837: a8 := JTF_DATE_TABLE();
838: a9 := JTF_NUMBER_TABLE();
839: a10 := JTF_NUMBER_TABLE();
840: a11 := JTF_NUMBER_TABLE();
841: a12 := JTF_NUMBER_TABLE();
842: a13 := JTF_NUMBER_TABLE();
843: a14 := JTF_VARCHAR2_TABLE_100();
844: a15 := JTF_VARCHAR2_TABLE_100();
845: a16 := JTF_NUMBER_TABLE();
838: a9 := JTF_NUMBER_TABLE();
839: a10 := JTF_NUMBER_TABLE();
840: a11 := JTF_NUMBER_TABLE();
841: a12 := JTF_NUMBER_TABLE();
842: a13 := JTF_NUMBER_TABLE();
843: a14 := JTF_VARCHAR2_TABLE_100();
844: a15 := JTF_VARCHAR2_TABLE_100();
845: a16 := JTF_NUMBER_TABLE();
846: a17 := JTF_VARCHAR2_TABLE_100();
841: a12 := JTF_NUMBER_TABLE();
842: a13 := JTF_NUMBER_TABLE();
843: a14 := JTF_VARCHAR2_TABLE_100();
844: a15 := JTF_VARCHAR2_TABLE_100();
845: a16 := JTF_NUMBER_TABLE();
846: a17 := JTF_VARCHAR2_TABLE_100();
847: a18 := JTF_VARCHAR2_TABLE_100();
848: a19 := JTF_VARCHAR2_TABLE_200();
849: a20 := JTF_VARCHAR2_TABLE_200();
860: a31 := JTF_VARCHAR2_TABLE_200();
861: a32 := JTF_VARCHAR2_TABLE_200();
862: a33 := JTF_VARCHAR2_TABLE_200();
863: else
864: a0 := JTF_NUMBER_TABLE();
865: a1 := JTF_NUMBER_TABLE();
866: a2 := JTF_NUMBER_TABLE();
867: a3 := JTF_NUMBER_TABLE();
868: a4 := JTF_VARCHAR2_TABLE_300();
861: a32 := JTF_VARCHAR2_TABLE_200();
862: a33 := JTF_VARCHAR2_TABLE_200();
863: else
864: a0 := JTF_NUMBER_TABLE();
865: a1 := JTF_NUMBER_TABLE();
866: a2 := JTF_NUMBER_TABLE();
867: a3 := JTF_NUMBER_TABLE();
868: a4 := JTF_VARCHAR2_TABLE_300();
869: a5 := JTF_DATE_TABLE();
862: a33 := JTF_VARCHAR2_TABLE_200();
863: else
864: a0 := JTF_NUMBER_TABLE();
865: a1 := JTF_NUMBER_TABLE();
866: a2 := JTF_NUMBER_TABLE();
867: a3 := JTF_NUMBER_TABLE();
868: a4 := JTF_VARCHAR2_TABLE_300();
869: a5 := JTF_DATE_TABLE();
870: a6 := JTF_DATE_TABLE();
863: else
864: a0 := JTF_NUMBER_TABLE();
865: a1 := JTF_NUMBER_TABLE();
866: a2 := JTF_NUMBER_TABLE();
867: a3 := JTF_NUMBER_TABLE();
868: a4 := JTF_VARCHAR2_TABLE_300();
869: a5 := JTF_DATE_TABLE();
870: a6 := JTF_DATE_TABLE();
871: a7 := JTF_DATE_TABLE();
869: a5 := JTF_DATE_TABLE();
870: a6 := JTF_DATE_TABLE();
871: a7 := JTF_DATE_TABLE();
872: a8 := JTF_DATE_TABLE();
873: a9 := JTF_NUMBER_TABLE();
874: a10 := JTF_NUMBER_TABLE();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_NUMBER_TABLE();
877: a13 := JTF_NUMBER_TABLE();
870: a6 := JTF_DATE_TABLE();
871: a7 := JTF_DATE_TABLE();
872: a8 := JTF_DATE_TABLE();
873: a9 := JTF_NUMBER_TABLE();
874: a10 := JTF_NUMBER_TABLE();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_NUMBER_TABLE();
877: a13 := JTF_NUMBER_TABLE();
878: a14 := JTF_VARCHAR2_TABLE_100();
871: a7 := JTF_DATE_TABLE();
872: a8 := JTF_DATE_TABLE();
873: a9 := JTF_NUMBER_TABLE();
874: a10 := JTF_NUMBER_TABLE();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_NUMBER_TABLE();
877: a13 := JTF_NUMBER_TABLE();
878: a14 := JTF_VARCHAR2_TABLE_100();
879: a15 := JTF_VARCHAR2_TABLE_100();
872: a8 := JTF_DATE_TABLE();
873: a9 := JTF_NUMBER_TABLE();
874: a10 := JTF_NUMBER_TABLE();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_NUMBER_TABLE();
877: a13 := JTF_NUMBER_TABLE();
878: a14 := JTF_VARCHAR2_TABLE_100();
879: a15 := JTF_VARCHAR2_TABLE_100();
880: a16 := JTF_NUMBER_TABLE();
873: a9 := JTF_NUMBER_TABLE();
874: a10 := JTF_NUMBER_TABLE();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_NUMBER_TABLE();
877: a13 := JTF_NUMBER_TABLE();
878: a14 := JTF_VARCHAR2_TABLE_100();
879: a15 := JTF_VARCHAR2_TABLE_100();
880: a16 := JTF_NUMBER_TABLE();
881: a17 := JTF_VARCHAR2_TABLE_100();
876: a12 := JTF_NUMBER_TABLE();
877: a13 := JTF_NUMBER_TABLE();
878: a14 := JTF_VARCHAR2_TABLE_100();
879: a15 := JTF_VARCHAR2_TABLE_100();
880: a16 := JTF_NUMBER_TABLE();
881: a17 := JTF_VARCHAR2_TABLE_100();
882: a18 := JTF_VARCHAR2_TABLE_100();
883: a19 := JTF_VARCHAR2_TABLE_200();
884: a20 := JTF_VARCHAR2_TABLE_200();
976: end if;
977: end if;
978: end rosetta_table_copy_out_p9;
979:
980: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
981: , a1 JTF_NUMBER_TABLE
982: , a2 JTF_NUMBER_TABLE
983: , a3 JTF_NUMBER_TABLE
984: ) as
977: end if;
978: end rosetta_table_copy_out_p9;
979:
980: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
981: , a1 JTF_NUMBER_TABLE
982: , a2 JTF_NUMBER_TABLE
983: , a3 JTF_NUMBER_TABLE
984: ) as
985: ddindx binary_integer; indx binary_integer;
978: end rosetta_table_copy_out_p9;
979:
980: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
981: , a1 JTF_NUMBER_TABLE
982: , a2 JTF_NUMBER_TABLE
983: , a3 JTF_NUMBER_TABLE
984: ) as
985: ddindx binary_integer; indx binary_integer;
986: begin
979:
980: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
981: , a1 JTF_NUMBER_TABLE
982: , a2 JTF_NUMBER_TABLE
983: , a3 JTF_NUMBER_TABLE
984: ) as
985: ddindx binary_integer; indx binary_integer;
986: begin
987: if a0 is not null and a0.count > 0 then
1001: end loop;
1002: end if;
1003: end if;
1004: end rosetta_table_copy_in_p11;
1005: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1006: , a1 out nocopy JTF_NUMBER_TABLE
1007: , a2 out nocopy JTF_NUMBER_TABLE
1008: , a3 out nocopy JTF_NUMBER_TABLE
1009: ) as
1002: end if;
1003: end if;
1004: end rosetta_table_copy_in_p11;
1005: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1006: , a1 out nocopy JTF_NUMBER_TABLE
1007: , a2 out nocopy JTF_NUMBER_TABLE
1008: , a3 out nocopy JTF_NUMBER_TABLE
1009: ) as
1010: ddindx binary_integer; indx binary_integer;
1003: end if;
1004: end rosetta_table_copy_in_p11;
1005: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1006: , a1 out nocopy JTF_NUMBER_TABLE
1007: , a2 out nocopy JTF_NUMBER_TABLE
1008: , a3 out nocopy JTF_NUMBER_TABLE
1009: ) as
1010: ddindx binary_integer; indx binary_integer;
1011: begin
1004: end rosetta_table_copy_in_p11;
1005: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1006: , a1 out nocopy JTF_NUMBER_TABLE
1007: , a2 out nocopy JTF_NUMBER_TABLE
1008: , a3 out nocopy JTF_NUMBER_TABLE
1009: ) as
1010: ddindx binary_integer; indx binary_integer;
1011: begin
1012: if t is null or t.count = 0 then
1009: ) as
1010: ddindx binary_integer; indx binary_integer;
1011: begin
1012: if t is null or t.count = 0 then
1013: a0 := JTF_NUMBER_TABLE();
1014: a1 := JTF_NUMBER_TABLE();
1015: a2 := JTF_NUMBER_TABLE();
1016: a3 := JTF_NUMBER_TABLE();
1017: else
1010: ddindx binary_integer; indx binary_integer;
1011: begin
1012: if t is null or t.count = 0 then
1013: a0 := JTF_NUMBER_TABLE();
1014: a1 := JTF_NUMBER_TABLE();
1015: a2 := JTF_NUMBER_TABLE();
1016: a3 := JTF_NUMBER_TABLE();
1017: else
1018: a0 := JTF_NUMBER_TABLE();
1011: begin
1012: if t is null or t.count = 0 then
1013: a0 := JTF_NUMBER_TABLE();
1014: a1 := JTF_NUMBER_TABLE();
1015: a2 := JTF_NUMBER_TABLE();
1016: a3 := JTF_NUMBER_TABLE();
1017: else
1018: a0 := JTF_NUMBER_TABLE();
1019: a1 := JTF_NUMBER_TABLE();
1012: if t is null or t.count = 0 then
1013: a0 := JTF_NUMBER_TABLE();
1014: a1 := JTF_NUMBER_TABLE();
1015: a2 := JTF_NUMBER_TABLE();
1016: a3 := JTF_NUMBER_TABLE();
1017: else
1018: a0 := JTF_NUMBER_TABLE();
1019: a1 := JTF_NUMBER_TABLE();
1020: a2 := JTF_NUMBER_TABLE();
1014: a1 := JTF_NUMBER_TABLE();
1015: a2 := JTF_NUMBER_TABLE();
1016: a3 := JTF_NUMBER_TABLE();
1017: else
1018: a0 := JTF_NUMBER_TABLE();
1019: a1 := JTF_NUMBER_TABLE();
1020: a2 := JTF_NUMBER_TABLE();
1021: a3 := JTF_NUMBER_TABLE();
1022: if t.count > 0 then
1015: a2 := JTF_NUMBER_TABLE();
1016: a3 := JTF_NUMBER_TABLE();
1017: else
1018: a0 := JTF_NUMBER_TABLE();
1019: a1 := JTF_NUMBER_TABLE();
1020: a2 := JTF_NUMBER_TABLE();
1021: a3 := JTF_NUMBER_TABLE();
1022: if t.count > 0 then
1023: a0.extend(t.count);
1016: a3 := JTF_NUMBER_TABLE();
1017: else
1018: a0 := JTF_NUMBER_TABLE();
1019: a1 := JTF_NUMBER_TABLE();
1020: a2 := JTF_NUMBER_TABLE();
1021: a3 := JTF_NUMBER_TABLE();
1022: if t.count > 0 then
1023: a0.extend(t.count);
1024: a1.extend(t.count);
1017: else
1018: a0 := JTF_NUMBER_TABLE();
1019: a1 := JTF_NUMBER_TABLE();
1020: a2 := JTF_NUMBER_TABLE();
1021: a3 := JTF_NUMBER_TABLE();
1022: if t.count > 0 then
1023: a0.extend(t.count);
1024: a1.extend(t.count);
1025: a2.extend(t.count);
1048: , x_return_status out nocopy VARCHAR2
1049: , x_msg_count out nocopy NUMBER
1050: , x_msg_data out nocopy VARCHAR2
1051: , p7_a0 JTF_VARCHAR2_TABLE_300
1052: , p7_a1 JTF_NUMBER_TABLE
1053: , p7_a2 JTF_NUMBER_TABLE
1054: , p7_a3 JTF_NUMBER_TABLE
1055: , p7_a4 JTF_NUMBER_TABLE
1056: , p7_a5 JTF_VARCHAR2_TABLE_100
1049: , x_msg_count out nocopy NUMBER
1050: , x_msg_data out nocopy VARCHAR2
1051: , p7_a0 JTF_VARCHAR2_TABLE_300
1052: , p7_a1 JTF_NUMBER_TABLE
1053: , p7_a2 JTF_NUMBER_TABLE
1054: , p7_a3 JTF_NUMBER_TABLE
1055: , p7_a4 JTF_NUMBER_TABLE
1056: , p7_a5 JTF_VARCHAR2_TABLE_100
1057: , p7_a6 JTF_NUMBER_TABLE
1050: , x_msg_data out nocopy VARCHAR2
1051: , p7_a0 JTF_VARCHAR2_TABLE_300
1052: , p7_a1 JTF_NUMBER_TABLE
1053: , p7_a2 JTF_NUMBER_TABLE
1054: , p7_a3 JTF_NUMBER_TABLE
1055: , p7_a4 JTF_NUMBER_TABLE
1056: , p7_a5 JTF_VARCHAR2_TABLE_100
1057: , p7_a6 JTF_NUMBER_TABLE
1058: )
1051: , p7_a0 JTF_VARCHAR2_TABLE_300
1052: , p7_a1 JTF_NUMBER_TABLE
1053: , p7_a2 JTF_NUMBER_TABLE
1054: , p7_a3 JTF_NUMBER_TABLE
1055: , p7_a4 JTF_NUMBER_TABLE
1056: , p7_a5 JTF_VARCHAR2_TABLE_100
1057: , p7_a6 JTF_NUMBER_TABLE
1058: )
1059:
1053: , p7_a2 JTF_NUMBER_TABLE
1054: , p7_a3 JTF_NUMBER_TABLE
1055: , p7_a4 JTF_NUMBER_TABLE
1056: , p7_a5 JTF_VARCHAR2_TABLE_100
1057: , p7_a6 JTF_NUMBER_TABLE
1058: )
1059:
1060: as
1061: ddp_mv_txn_dtls_tbl csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type;
1243: , p_validation_level NUMBER
1244: , x_return_status out nocopy VARCHAR2
1245: , x_msg_count out nocopy NUMBER
1246: , x_msg_data out nocopy VARCHAR2
1247: , p7_a0 JTF_NUMBER_TABLE
1248: , p7_a1 JTF_NUMBER_TABLE
1249: , p7_a2 JTF_NUMBER_TABLE
1250: , p7_a3 JTF_NUMBER_TABLE
1251: , p7_a4 JTF_NUMBER_TABLE
1244: , x_return_status out nocopy VARCHAR2
1245: , x_msg_count out nocopy NUMBER
1246: , x_msg_data out nocopy VARCHAR2
1247: , p7_a0 JTF_NUMBER_TABLE
1248: , p7_a1 JTF_NUMBER_TABLE
1249: , p7_a2 JTF_NUMBER_TABLE
1250: , p7_a3 JTF_NUMBER_TABLE
1251: , p7_a4 JTF_NUMBER_TABLE
1252: , p7_a5 JTF_NUMBER_TABLE
1245: , x_msg_count out nocopy NUMBER
1246: , x_msg_data out nocopy VARCHAR2
1247: , p7_a0 JTF_NUMBER_TABLE
1248: , p7_a1 JTF_NUMBER_TABLE
1249: , p7_a2 JTF_NUMBER_TABLE
1250: , p7_a3 JTF_NUMBER_TABLE
1251: , p7_a4 JTF_NUMBER_TABLE
1252: , p7_a5 JTF_NUMBER_TABLE
1253: , p7_a6 JTF_NUMBER_TABLE
1246: , x_msg_data out nocopy VARCHAR2
1247: , p7_a0 JTF_NUMBER_TABLE
1248: , p7_a1 JTF_NUMBER_TABLE
1249: , p7_a2 JTF_NUMBER_TABLE
1250: , p7_a3 JTF_NUMBER_TABLE
1251: , p7_a4 JTF_NUMBER_TABLE
1252: , p7_a5 JTF_NUMBER_TABLE
1253: , p7_a6 JTF_NUMBER_TABLE
1254: , p7_a7 JTF_NUMBER_TABLE
1247: , p7_a0 JTF_NUMBER_TABLE
1248: , p7_a1 JTF_NUMBER_TABLE
1249: , p7_a2 JTF_NUMBER_TABLE
1250: , p7_a3 JTF_NUMBER_TABLE
1251: , p7_a4 JTF_NUMBER_TABLE
1252: , p7_a5 JTF_NUMBER_TABLE
1253: , p7_a6 JTF_NUMBER_TABLE
1254: , p7_a7 JTF_NUMBER_TABLE
1255: , p7_a8 JTF_NUMBER_TABLE
1248: , p7_a1 JTF_NUMBER_TABLE
1249: , p7_a2 JTF_NUMBER_TABLE
1250: , p7_a3 JTF_NUMBER_TABLE
1251: , p7_a4 JTF_NUMBER_TABLE
1252: , p7_a5 JTF_NUMBER_TABLE
1253: , p7_a6 JTF_NUMBER_TABLE
1254: , p7_a7 JTF_NUMBER_TABLE
1255: , p7_a8 JTF_NUMBER_TABLE
1256: , p7_a9 JTF_NUMBER_TABLE
1249: , p7_a2 JTF_NUMBER_TABLE
1250: , p7_a3 JTF_NUMBER_TABLE
1251: , p7_a4 JTF_NUMBER_TABLE
1252: , p7_a5 JTF_NUMBER_TABLE
1253: , p7_a6 JTF_NUMBER_TABLE
1254: , p7_a7 JTF_NUMBER_TABLE
1255: , p7_a8 JTF_NUMBER_TABLE
1256: , p7_a9 JTF_NUMBER_TABLE
1257: , p7_a10 JTF_VARCHAR2_TABLE_100
1250: , p7_a3 JTF_NUMBER_TABLE
1251: , p7_a4 JTF_NUMBER_TABLE
1252: , p7_a5 JTF_NUMBER_TABLE
1253: , p7_a6 JTF_NUMBER_TABLE
1254: , p7_a7 JTF_NUMBER_TABLE
1255: , p7_a8 JTF_NUMBER_TABLE
1256: , p7_a9 JTF_NUMBER_TABLE
1257: , p7_a10 JTF_VARCHAR2_TABLE_100
1258: , p7_a11 JTF_VARCHAR2_TABLE_100
1251: , p7_a4 JTF_NUMBER_TABLE
1252: , p7_a5 JTF_NUMBER_TABLE
1253: , p7_a6 JTF_NUMBER_TABLE
1254: , p7_a7 JTF_NUMBER_TABLE
1255: , p7_a8 JTF_NUMBER_TABLE
1256: , p7_a9 JTF_NUMBER_TABLE
1257: , p7_a10 JTF_VARCHAR2_TABLE_100
1258: , p7_a11 JTF_VARCHAR2_TABLE_100
1259: , p7_a12 JTF_VARCHAR2_TABLE_100
1252: , p7_a5 JTF_NUMBER_TABLE
1253: , p7_a6 JTF_NUMBER_TABLE
1254: , p7_a7 JTF_NUMBER_TABLE
1255: , p7_a8 JTF_NUMBER_TABLE
1256: , p7_a9 JTF_NUMBER_TABLE
1257: , p7_a10 JTF_VARCHAR2_TABLE_100
1258: , p7_a11 JTF_VARCHAR2_TABLE_100
1259: , p7_a12 JTF_VARCHAR2_TABLE_100
1260: , p7_a13 JTF_VARCHAR2_TABLE_100
1258: , p7_a11 JTF_VARCHAR2_TABLE_100
1259: , p7_a12 JTF_VARCHAR2_TABLE_100
1260: , p7_a13 JTF_VARCHAR2_TABLE_100
1261: , p7_a14 JTF_VARCHAR2_TABLE_100
1262: , p7_a15 JTF_NUMBER_TABLE
1263: , p7_a16 JTF_NUMBER_TABLE
1264: , p7_a17 JTF_NUMBER_TABLE
1265: , p7_a18 JTF_VARCHAR2_TABLE_100
1266: , p7_a19 JTF_NUMBER_TABLE
1259: , p7_a12 JTF_VARCHAR2_TABLE_100
1260: , p7_a13 JTF_VARCHAR2_TABLE_100
1261: , p7_a14 JTF_VARCHAR2_TABLE_100
1262: , p7_a15 JTF_NUMBER_TABLE
1263: , p7_a16 JTF_NUMBER_TABLE
1264: , p7_a17 JTF_NUMBER_TABLE
1265: , p7_a18 JTF_VARCHAR2_TABLE_100
1266: , p7_a19 JTF_NUMBER_TABLE
1267: , p7_a20 JTF_NUMBER_TABLE
1260: , p7_a13 JTF_VARCHAR2_TABLE_100
1261: , p7_a14 JTF_VARCHAR2_TABLE_100
1262: , p7_a15 JTF_NUMBER_TABLE
1263: , p7_a16 JTF_NUMBER_TABLE
1264: , p7_a17 JTF_NUMBER_TABLE
1265: , p7_a18 JTF_VARCHAR2_TABLE_100
1266: , p7_a19 JTF_NUMBER_TABLE
1267: , p7_a20 JTF_NUMBER_TABLE
1268: , p7_a21 JTF_NUMBER_TABLE
1262: , p7_a15 JTF_NUMBER_TABLE
1263: , p7_a16 JTF_NUMBER_TABLE
1264: , p7_a17 JTF_NUMBER_TABLE
1265: , p7_a18 JTF_VARCHAR2_TABLE_100
1266: , p7_a19 JTF_NUMBER_TABLE
1267: , p7_a20 JTF_NUMBER_TABLE
1268: , p7_a21 JTF_NUMBER_TABLE
1269: , p7_a22 JTF_VARCHAR2_TABLE_100
1270: , p7_a23 JTF_NUMBER_TABLE
1263: , p7_a16 JTF_NUMBER_TABLE
1264: , p7_a17 JTF_NUMBER_TABLE
1265: , p7_a18 JTF_VARCHAR2_TABLE_100
1266: , p7_a19 JTF_NUMBER_TABLE
1267: , p7_a20 JTF_NUMBER_TABLE
1268: , p7_a21 JTF_NUMBER_TABLE
1269: , p7_a22 JTF_VARCHAR2_TABLE_100
1270: , p7_a23 JTF_NUMBER_TABLE
1271: , p7_a24 JTF_VARCHAR2_TABLE_100
1264: , p7_a17 JTF_NUMBER_TABLE
1265: , p7_a18 JTF_VARCHAR2_TABLE_100
1266: , p7_a19 JTF_NUMBER_TABLE
1267: , p7_a20 JTF_NUMBER_TABLE
1268: , p7_a21 JTF_NUMBER_TABLE
1269: , p7_a22 JTF_VARCHAR2_TABLE_100
1270: , p7_a23 JTF_NUMBER_TABLE
1271: , p7_a24 JTF_VARCHAR2_TABLE_100
1272: , p7_a25 JTF_VARCHAR2_TABLE_200
1266: , p7_a19 JTF_NUMBER_TABLE
1267: , p7_a20 JTF_NUMBER_TABLE
1268: , p7_a21 JTF_NUMBER_TABLE
1269: , p7_a22 JTF_VARCHAR2_TABLE_100
1270: , p7_a23 JTF_NUMBER_TABLE
1271: , p7_a24 JTF_VARCHAR2_TABLE_100
1272: , p7_a25 JTF_VARCHAR2_TABLE_200
1273: , p7_a26 JTF_VARCHAR2_TABLE_200
1274: , p7_a27 JTF_VARCHAR2_TABLE_200
1373: , p_validation_level NUMBER
1374: , x_return_status out nocopy VARCHAR2
1375: , x_msg_count out nocopy NUMBER
1376: , x_msg_data out nocopy VARCHAR2
1377: , p7_a0 JTF_NUMBER_TABLE
1378: , p7_a1 JTF_NUMBER_TABLE
1379: , p7_a2 JTF_NUMBER_TABLE
1380: , p7_a3 JTF_NUMBER_TABLE
1381: , p7_a4 JTF_NUMBER_TABLE
1374: , x_return_status out nocopy VARCHAR2
1375: , x_msg_count out nocopy NUMBER
1376: , x_msg_data out nocopy VARCHAR2
1377: , p7_a0 JTF_NUMBER_TABLE
1378: , p7_a1 JTF_NUMBER_TABLE
1379: , p7_a2 JTF_NUMBER_TABLE
1380: , p7_a3 JTF_NUMBER_TABLE
1381: , p7_a4 JTF_NUMBER_TABLE
1382: , p7_a5 JTF_NUMBER_TABLE
1375: , x_msg_count out nocopy NUMBER
1376: , x_msg_data out nocopy VARCHAR2
1377: , p7_a0 JTF_NUMBER_TABLE
1378: , p7_a1 JTF_NUMBER_TABLE
1379: , p7_a2 JTF_NUMBER_TABLE
1380: , p7_a3 JTF_NUMBER_TABLE
1381: , p7_a4 JTF_NUMBER_TABLE
1382: , p7_a5 JTF_NUMBER_TABLE
1383: , p7_a6 JTF_NUMBER_TABLE
1376: , x_msg_data out nocopy VARCHAR2
1377: , p7_a0 JTF_NUMBER_TABLE
1378: , p7_a1 JTF_NUMBER_TABLE
1379: , p7_a2 JTF_NUMBER_TABLE
1380: , p7_a3 JTF_NUMBER_TABLE
1381: , p7_a4 JTF_NUMBER_TABLE
1382: , p7_a5 JTF_NUMBER_TABLE
1383: , p7_a6 JTF_NUMBER_TABLE
1384: , p7_a7 JTF_NUMBER_TABLE
1377: , p7_a0 JTF_NUMBER_TABLE
1378: , p7_a1 JTF_NUMBER_TABLE
1379: , p7_a2 JTF_NUMBER_TABLE
1380: , p7_a3 JTF_NUMBER_TABLE
1381: , p7_a4 JTF_NUMBER_TABLE
1382: , p7_a5 JTF_NUMBER_TABLE
1383: , p7_a6 JTF_NUMBER_TABLE
1384: , p7_a7 JTF_NUMBER_TABLE
1385: , p7_a8 JTF_NUMBER_TABLE
1378: , p7_a1 JTF_NUMBER_TABLE
1379: , p7_a2 JTF_NUMBER_TABLE
1380: , p7_a3 JTF_NUMBER_TABLE
1381: , p7_a4 JTF_NUMBER_TABLE
1382: , p7_a5 JTF_NUMBER_TABLE
1383: , p7_a6 JTF_NUMBER_TABLE
1384: , p7_a7 JTF_NUMBER_TABLE
1385: , p7_a8 JTF_NUMBER_TABLE
1386: , p7_a9 JTF_NUMBER_TABLE
1379: , p7_a2 JTF_NUMBER_TABLE
1380: , p7_a3 JTF_NUMBER_TABLE
1381: , p7_a4 JTF_NUMBER_TABLE
1382: , p7_a5 JTF_NUMBER_TABLE
1383: , p7_a6 JTF_NUMBER_TABLE
1384: , p7_a7 JTF_NUMBER_TABLE
1385: , p7_a8 JTF_NUMBER_TABLE
1386: , p7_a9 JTF_NUMBER_TABLE
1387: , p7_a10 JTF_VARCHAR2_TABLE_100
1380: , p7_a3 JTF_NUMBER_TABLE
1381: , p7_a4 JTF_NUMBER_TABLE
1382: , p7_a5 JTF_NUMBER_TABLE
1383: , p7_a6 JTF_NUMBER_TABLE
1384: , p7_a7 JTF_NUMBER_TABLE
1385: , p7_a8 JTF_NUMBER_TABLE
1386: , p7_a9 JTF_NUMBER_TABLE
1387: , p7_a10 JTF_VARCHAR2_TABLE_100
1388: , p7_a11 JTF_VARCHAR2_TABLE_100
1381: , p7_a4 JTF_NUMBER_TABLE
1382: , p7_a5 JTF_NUMBER_TABLE
1383: , p7_a6 JTF_NUMBER_TABLE
1384: , p7_a7 JTF_NUMBER_TABLE
1385: , p7_a8 JTF_NUMBER_TABLE
1386: , p7_a9 JTF_NUMBER_TABLE
1387: , p7_a10 JTF_VARCHAR2_TABLE_100
1388: , p7_a11 JTF_VARCHAR2_TABLE_100
1389: , p7_a12 JTF_VARCHAR2_TABLE_100
1382: , p7_a5 JTF_NUMBER_TABLE
1383: , p7_a6 JTF_NUMBER_TABLE
1384: , p7_a7 JTF_NUMBER_TABLE
1385: , p7_a8 JTF_NUMBER_TABLE
1386: , p7_a9 JTF_NUMBER_TABLE
1387: , p7_a10 JTF_VARCHAR2_TABLE_100
1388: , p7_a11 JTF_VARCHAR2_TABLE_100
1389: , p7_a12 JTF_VARCHAR2_TABLE_100
1390: , p7_a13 JTF_VARCHAR2_TABLE_100
1388: , p7_a11 JTF_VARCHAR2_TABLE_100
1389: , p7_a12 JTF_VARCHAR2_TABLE_100
1390: , p7_a13 JTF_VARCHAR2_TABLE_100
1391: , p7_a14 JTF_VARCHAR2_TABLE_100
1392: , p7_a15 JTF_NUMBER_TABLE
1393: , p7_a16 JTF_NUMBER_TABLE
1394: , p7_a17 JTF_NUMBER_TABLE
1395: , p7_a18 JTF_VARCHAR2_TABLE_100
1396: , p7_a19 JTF_NUMBER_TABLE
1389: , p7_a12 JTF_VARCHAR2_TABLE_100
1390: , p7_a13 JTF_VARCHAR2_TABLE_100
1391: , p7_a14 JTF_VARCHAR2_TABLE_100
1392: , p7_a15 JTF_NUMBER_TABLE
1393: , p7_a16 JTF_NUMBER_TABLE
1394: , p7_a17 JTF_NUMBER_TABLE
1395: , p7_a18 JTF_VARCHAR2_TABLE_100
1396: , p7_a19 JTF_NUMBER_TABLE
1397: , p7_a20 JTF_NUMBER_TABLE
1390: , p7_a13 JTF_VARCHAR2_TABLE_100
1391: , p7_a14 JTF_VARCHAR2_TABLE_100
1392: , p7_a15 JTF_NUMBER_TABLE
1393: , p7_a16 JTF_NUMBER_TABLE
1394: , p7_a17 JTF_NUMBER_TABLE
1395: , p7_a18 JTF_VARCHAR2_TABLE_100
1396: , p7_a19 JTF_NUMBER_TABLE
1397: , p7_a20 JTF_NUMBER_TABLE
1398: , p7_a21 JTF_NUMBER_TABLE
1392: , p7_a15 JTF_NUMBER_TABLE
1393: , p7_a16 JTF_NUMBER_TABLE
1394: , p7_a17 JTF_NUMBER_TABLE
1395: , p7_a18 JTF_VARCHAR2_TABLE_100
1396: , p7_a19 JTF_NUMBER_TABLE
1397: , p7_a20 JTF_NUMBER_TABLE
1398: , p7_a21 JTF_NUMBER_TABLE
1399: , p7_a22 JTF_VARCHAR2_TABLE_100
1400: , p7_a23 JTF_NUMBER_TABLE
1393: , p7_a16 JTF_NUMBER_TABLE
1394: , p7_a17 JTF_NUMBER_TABLE
1395: , p7_a18 JTF_VARCHAR2_TABLE_100
1396: , p7_a19 JTF_NUMBER_TABLE
1397: , p7_a20 JTF_NUMBER_TABLE
1398: , p7_a21 JTF_NUMBER_TABLE
1399: , p7_a22 JTF_VARCHAR2_TABLE_100
1400: , p7_a23 JTF_NUMBER_TABLE
1401: , p7_a24 JTF_VARCHAR2_TABLE_100
1394: , p7_a17 JTF_NUMBER_TABLE
1395: , p7_a18 JTF_VARCHAR2_TABLE_100
1396: , p7_a19 JTF_NUMBER_TABLE
1397: , p7_a20 JTF_NUMBER_TABLE
1398: , p7_a21 JTF_NUMBER_TABLE
1399: , p7_a22 JTF_VARCHAR2_TABLE_100
1400: , p7_a23 JTF_NUMBER_TABLE
1401: , p7_a24 JTF_VARCHAR2_TABLE_100
1402: , p7_a25 JTF_VARCHAR2_TABLE_200
1396: , p7_a19 JTF_NUMBER_TABLE
1397: , p7_a20 JTF_NUMBER_TABLE
1398: , p7_a21 JTF_NUMBER_TABLE
1399: , p7_a22 JTF_VARCHAR2_TABLE_100
1400: , p7_a23 JTF_NUMBER_TABLE
1401: , p7_a24 JTF_VARCHAR2_TABLE_100
1402: , p7_a25 JTF_VARCHAR2_TABLE_200
1403: , p7_a26 JTF_VARCHAR2_TABLE_200
1404: , p7_a27 JTF_VARCHAR2_TABLE_200
1503: , p_validation_level NUMBER
1504: , x_return_status out nocopy VARCHAR2
1505: , x_msg_count out nocopy NUMBER
1506: , x_msg_data out nocopy VARCHAR2
1507: , p7_a0 JTF_NUMBER_TABLE
1508: , p7_a1 JTF_NUMBER_TABLE
1509: , p7_a2 JTF_NUMBER_TABLE
1510: , p7_a3 JTF_NUMBER_TABLE
1511: , p7_a4 JTF_NUMBER_TABLE
1504: , x_return_status out nocopy VARCHAR2
1505: , x_msg_count out nocopy NUMBER
1506: , x_msg_data out nocopy VARCHAR2
1507: , p7_a0 JTF_NUMBER_TABLE
1508: , p7_a1 JTF_NUMBER_TABLE
1509: , p7_a2 JTF_NUMBER_TABLE
1510: , p7_a3 JTF_NUMBER_TABLE
1511: , p7_a4 JTF_NUMBER_TABLE
1512: , p7_a5 JTF_NUMBER_TABLE
1505: , x_msg_count out nocopy NUMBER
1506: , x_msg_data out nocopy VARCHAR2
1507: , p7_a0 JTF_NUMBER_TABLE
1508: , p7_a1 JTF_NUMBER_TABLE
1509: , p7_a2 JTF_NUMBER_TABLE
1510: , p7_a3 JTF_NUMBER_TABLE
1511: , p7_a4 JTF_NUMBER_TABLE
1512: , p7_a5 JTF_NUMBER_TABLE
1513: , p7_a6 JTF_NUMBER_TABLE
1506: , x_msg_data out nocopy VARCHAR2
1507: , p7_a0 JTF_NUMBER_TABLE
1508: , p7_a1 JTF_NUMBER_TABLE
1509: , p7_a2 JTF_NUMBER_TABLE
1510: , p7_a3 JTF_NUMBER_TABLE
1511: , p7_a4 JTF_NUMBER_TABLE
1512: , p7_a5 JTF_NUMBER_TABLE
1513: , p7_a6 JTF_NUMBER_TABLE
1514: , p7_a7 JTF_NUMBER_TABLE
1507: , p7_a0 JTF_NUMBER_TABLE
1508: , p7_a1 JTF_NUMBER_TABLE
1509: , p7_a2 JTF_NUMBER_TABLE
1510: , p7_a3 JTF_NUMBER_TABLE
1511: , p7_a4 JTF_NUMBER_TABLE
1512: , p7_a5 JTF_NUMBER_TABLE
1513: , p7_a6 JTF_NUMBER_TABLE
1514: , p7_a7 JTF_NUMBER_TABLE
1515: , p7_a8 JTF_NUMBER_TABLE
1508: , p7_a1 JTF_NUMBER_TABLE
1509: , p7_a2 JTF_NUMBER_TABLE
1510: , p7_a3 JTF_NUMBER_TABLE
1511: , p7_a4 JTF_NUMBER_TABLE
1512: , p7_a5 JTF_NUMBER_TABLE
1513: , p7_a6 JTF_NUMBER_TABLE
1514: , p7_a7 JTF_NUMBER_TABLE
1515: , p7_a8 JTF_NUMBER_TABLE
1516: , p7_a9 JTF_NUMBER_TABLE
1509: , p7_a2 JTF_NUMBER_TABLE
1510: , p7_a3 JTF_NUMBER_TABLE
1511: , p7_a4 JTF_NUMBER_TABLE
1512: , p7_a5 JTF_NUMBER_TABLE
1513: , p7_a6 JTF_NUMBER_TABLE
1514: , p7_a7 JTF_NUMBER_TABLE
1515: , p7_a8 JTF_NUMBER_TABLE
1516: , p7_a9 JTF_NUMBER_TABLE
1517: , p7_a10 JTF_VARCHAR2_TABLE_100
1510: , p7_a3 JTF_NUMBER_TABLE
1511: , p7_a4 JTF_NUMBER_TABLE
1512: , p7_a5 JTF_NUMBER_TABLE
1513: , p7_a6 JTF_NUMBER_TABLE
1514: , p7_a7 JTF_NUMBER_TABLE
1515: , p7_a8 JTF_NUMBER_TABLE
1516: , p7_a9 JTF_NUMBER_TABLE
1517: , p7_a10 JTF_VARCHAR2_TABLE_100
1518: , p7_a11 JTF_VARCHAR2_TABLE_100
1511: , p7_a4 JTF_NUMBER_TABLE
1512: , p7_a5 JTF_NUMBER_TABLE
1513: , p7_a6 JTF_NUMBER_TABLE
1514: , p7_a7 JTF_NUMBER_TABLE
1515: , p7_a8 JTF_NUMBER_TABLE
1516: , p7_a9 JTF_NUMBER_TABLE
1517: , p7_a10 JTF_VARCHAR2_TABLE_100
1518: , p7_a11 JTF_VARCHAR2_TABLE_100
1519: , p7_a12 JTF_VARCHAR2_TABLE_100
1512: , p7_a5 JTF_NUMBER_TABLE
1513: , p7_a6 JTF_NUMBER_TABLE
1514: , p7_a7 JTF_NUMBER_TABLE
1515: , p7_a8 JTF_NUMBER_TABLE
1516: , p7_a9 JTF_NUMBER_TABLE
1517: , p7_a10 JTF_VARCHAR2_TABLE_100
1518: , p7_a11 JTF_VARCHAR2_TABLE_100
1519: , p7_a12 JTF_VARCHAR2_TABLE_100
1520: , p7_a13 JTF_VARCHAR2_TABLE_100
1518: , p7_a11 JTF_VARCHAR2_TABLE_100
1519: , p7_a12 JTF_VARCHAR2_TABLE_100
1520: , p7_a13 JTF_VARCHAR2_TABLE_100
1521: , p7_a14 JTF_VARCHAR2_TABLE_100
1522: , p7_a15 JTF_NUMBER_TABLE
1523: , p7_a16 JTF_NUMBER_TABLE
1524: , p7_a17 JTF_NUMBER_TABLE
1525: , p7_a18 JTF_VARCHAR2_TABLE_100
1526: , p7_a19 JTF_NUMBER_TABLE
1519: , p7_a12 JTF_VARCHAR2_TABLE_100
1520: , p7_a13 JTF_VARCHAR2_TABLE_100
1521: , p7_a14 JTF_VARCHAR2_TABLE_100
1522: , p7_a15 JTF_NUMBER_TABLE
1523: , p7_a16 JTF_NUMBER_TABLE
1524: , p7_a17 JTF_NUMBER_TABLE
1525: , p7_a18 JTF_VARCHAR2_TABLE_100
1526: , p7_a19 JTF_NUMBER_TABLE
1527: , p7_a20 JTF_NUMBER_TABLE
1520: , p7_a13 JTF_VARCHAR2_TABLE_100
1521: , p7_a14 JTF_VARCHAR2_TABLE_100
1522: , p7_a15 JTF_NUMBER_TABLE
1523: , p7_a16 JTF_NUMBER_TABLE
1524: , p7_a17 JTF_NUMBER_TABLE
1525: , p7_a18 JTF_VARCHAR2_TABLE_100
1526: , p7_a19 JTF_NUMBER_TABLE
1527: , p7_a20 JTF_NUMBER_TABLE
1528: , p7_a21 JTF_NUMBER_TABLE
1522: , p7_a15 JTF_NUMBER_TABLE
1523: , p7_a16 JTF_NUMBER_TABLE
1524: , p7_a17 JTF_NUMBER_TABLE
1525: , p7_a18 JTF_VARCHAR2_TABLE_100
1526: , p7_a19 JTF_NUMBER_TABLE
1527: , p7_a20 JTF_NUMBER_TABLE
1528: , p7_a21 JTF_NUMBER_TABLE
1529: , p7_a22 JTF_VARCHAR2_TABLE_100
1530: , p7_a23 JTF_NUMBER_TABLE
1523: , p7_a16 JTF_NUMBER_TABLE
1524: , p7_a17 JTF_NUMBER_TABLE
1525: , p7_a18 JTF_VARCHAR2_TABLE_100
1526: , p7_a19 JTF_NUMBER_TABLE
1527: , p7_a20 JTF_NUMBER_TABLE
1528: , p7_a21 JTF_NUMBER_TABLE
1529: , p7_a22 JTF_VARCHAR2_TABLE_100
1530: , p7_a23 JTF_NUMBER_TABLE
1531: , p7_a24 JTF_VARCHAR2_TABLE_100
1524: , p7_a17 JTF_NUMBER_TABLE
1525: , p7_a18 JTF_VARCHAR2_TABLE_100
1526: , p7_a19 JTF_NUMBER_TABLE
1527: , p7_a20 JTF_NUMBER_TABLE
1528: , p7_a21 JTF_NUMBER_TABLE
1529: , p7_a22 JTF_VARCHAR2_TABLE_100
1530: , p7_a23 JTF_NUMBER_TABLE
1531: , p7_a24 JTF_VARCHAR2_TABLE_100
1532: , p7_a25 JTF_VARCHAR2_TABLE_200
1526: , p7_a19 JTF_NUMBER_TABLE
1527: , p7_a20 JTF_NUMBER_TABLE
1528: , p7_a21 JTF_NUMBER_TABLE
1529: , p7_a22 JTF_VARCHAR2_TABLE_100
1530: , p7_a23 JTF_NUMBER_TABLE
1531: , p7_a24 JTF_VARCHAR2_TABLE_100
1532: , p7_a25 JTF_VARCHAR2_TABLE_200
1533: , p7_a26 JTF_VARCHAR2_TABLE_200
1534: , p7_a27 JTF_VARCHAR2_TABLE_200
1633: , p_validation_level NUMBER
1634: , x_return_status out nocopy VARCHAR2
1635: , x_msg_count out nocopy NUMBER
1636: , x_msg_data out nocopy VARCHAR2
1637: , p7_a0 JTF_NUMBER_TABLE
1638: , p7_a1 JTF_NUMBER_TABLE
1639: , p7_a2 JTF_NUMBER_TABLE
1640: , p7_a3 JTF_NUMBER_TABLE
1641: , p7_a4 JTF_NUMBER_TABLE
1634: , x_return_status out nocopy VARCHAR2
1635: , x_msg_count out nocopy NUMBER
1636: , x_msg_data out nocopy VARCHAR2
1637: , p7_a0 JTF_NUMBER_TABLE
1638: , p7_a1 JTF_NUMBER_TABLE
1639: , p7_a2 JTF_NUMBER_TABLE
1640: , p7_a3 JTF_NUMBER_TABLE
1641: , p7_a4 JTF_NUMBER_TABLE
1642: , p7_a5 JTF_NUMBER_TABLE
1635: , x_msg_count out nocopy NUMBER
1636: , x_msg_data out nocopy VARCHAR2
1637: , p7_a0 JTF_NUMBER_TABLE
1638: , p7_a1 JTF_NUMBER_TABLE
1639: , p7_a2 JTF_NUMBER_TABLE
1640: , p7_a3 JTF_NUMBER_TABLE
1641: , p7_a4 JTF_NUMBER_TABLE
1642: , p7_a5 JTF_NUMBER_TABLE
1643: , p7_a6 JTF_NUMBER_TABLE
1636: , x_msg_data out nocopy VARCHAR2
1637: , p7_a0 JTF_NUMBER_TABLE
1638: , p7_a1 JTF_NUMBER_TABLE
1639: , p7_a2 JTF_NUMBER_TABLE
1640: , p7_a3 JTF_NUMBER_TABLE
1641: , p7_a4 JTF_NUMBER_TABLE
1642: , p7_a5 JTF_NUMBER_TABLE
1643: , p7_a6 JTF_NUMBER_TABLE
1644: , p7_a7 JTF_NUMBER_TABLE
1637: , p7_a0 JTF_NUMBER_TABLE
1638: , p7_a1 JTF_NUMBER_TABLE
1639: , p7_a2 JTF_NUMBER_TABLE
1640: , p7_a3 JTF_NUMBER_TABLE
1641: , p7_a4 JTF_NUMBER_TABLE
1642: , p7_a5 JTF_NUMBER_TABLE
1643: , p7_a6 JTF_NUMBER_TABLE
1644: , p7_a7 JTF_NUMBER_TABLE
1645: , p7_a8 JTF_NUMBER_TABLE
1638: , p7_a1 JTF_NUMBER_TABLE
1639: , p7_a2 JTF_NUMBER_TABLE
1640: , p7_a3 JTF_NUMBER_TABLE
1641: , p7_a4 JTF_NUMBER_TABLE
1642: , p7_a5 JTF_NUMBER_TABLE
1643: , p7_a6 JTF_NUMBER_TABLE
1644: , p7_a7 JTF_NUMBER_TABLE
1645: , p7_a8 JTF_NUMBER_TABLE
1646: , p7_a9 JTF_NUMBER_TABLE
1639: , p7_a2 JTF_NUMBER_TABLE
1640: , p7_a3 JTF_NUMBER_TABLE
1641: , p7_a4 JTF_NUMBER_TABLE
1642: , p7_a5 JTF_NUMBER_TABLE
1643: , p7_a6 JTF_NUMBER_TABLE
1644: , p7_a7 JTF_NUMBER_TABLE
1645: , p7_a8 JTF_NUMBER_TABLE
1646: , p7_a9 JTF_NUMBER_TABLE
1647: , p7_a10 JTF_NUMBER_TABLE
1640: , p7_a3 JTF_NUMBER_TABLE
1641: , p7_a4 JTF_NUMBER_TABLE
1642: , p7_a5 JTF_NUMBER_TABLE
1643: , p7_a6 JTF_NUMBER_TABLE
1644: , p7_a7 JTF_NUMBER_TABLE
1645: , p7_a8 JTF_NUMBER_TABLE
1646: , p7_a9 JTF_NUMBER_TABLE
1647: , p7_a10 JTF_NUMBER_TABLE
1648: , p7_a11 JTF_VARCHAR2_TABLE_100
1641: , p7_a4 JTF_NUMBER_TABLE
1642: , p7_a5 JTF_NUMBER_TABLE
1643: , p7_a6 JTF_NUMBER_TABLE
1644: , p7_a7 JTF_NUMBER_TABLE
1645: , p7_a8 JTF_NUMBER_TABLE
1646: , p7_a9 JTF_NUMBER_TABLE
1647: , p7_a10 JTF_NUMBER_TABLE
1648: , p7_a11 JTF_VARCHAR2_TABLE_100
1649: , p7_a12 JTF_NUMBER_TABLE
1642: , p7_a5 JTF_NUMBER_TABLE
1643: , p7_a6 JTF_NUMBER_TABLE
1644: , p7_a7 JTF_NUMBER_TABLE
1645: , p7_a8 JTF_NUMBER_TABLE
1646: , p7_a9 JTF_NUMBER_TABLE
1647: , p7_a10 JTF_NUMBER_TABLE
1648: , p7_a11 JTF_VARCHAR2_TABLE_100
1649: , p7_a12 JTF_NUMBER_TABLE
1650: , p7_a13 JTF_NUMBER_TABLE
1643: , p7_a6 JTF_NUMBER_TABLE
1644: , p7_a7 JTF_NUMBER_TABLE
1645: , p7_a8 JTF_NUMBER_TABLE
1646: , p7_a9 JTF_NUMBER_TABLE
1647: , p7_a10 JTF_NUMBER_TABLE
1648: , p7_a11 JTF_VARCHAR2_TABLE_100
1649: , p7_a12 JTF_NUMBER_TABLE
1650: , p7_a13 JTF_NUMBER_TABLE
1651: , p7_a14 JTF_VARCHAR2_TABLE_100
1645: , p7_a8 JTF_NUMBER_TABLE
1646: , p7_a9 JTF_NUMBER_TABLE
1647: , p7_a10 JTF_NUMBER_TABLE
1648: , p7_a11 JTF_VARCHAR2_TABLE_100
1649: , p7_a12 JTF_NUMBER_TABLE
1650: , p7_a13 JTF_NUMBER_TABLE
1651: , p7_a14 JTF_VARCHAR2_TABLE_100
1652: , p7_a15 JTF_VARCHAR2_TABLE_100
1653: , p7_a16 JTF_VARCHAR2_TABLE_100
1646: , p7_a9 JTF_NUMBER_TABLE
1647: , p7_a10 JTF_NUMBER_TABLE
1648: , p7_a11 JTF_VARCHAR2_TABLE_100
1649: , p7_a12 JTF_NUMBER_TABLE
1650: , p7_a13 JTF_NUMBER_TABLE
1651: , p7_a14 JTF_VARCHAR2_TABLE_100
1652: , p7_a15 JTF_VARCHAR2_TABLE_100
1653: , p7_a16 JTF_VARCHAR2_TABLE_100
1654: , p7_a17 JTF_NUMBER_TABLE
1650: , p7_a13 JTF_NUMBER_TABLE
1651: , p7_a14 JTF_VARCHAR2_TABLE_100
1652: , p7_a15 JTF_VARCHAR2_TABLE_100
1653: , p7_a16 JTF_VARCHAR2_TABLE_100
1654: , p7_a17 JTF_NUMBER_TABLE
1655: , p7_a18 JTF_VARCHAR2_TABLE_100
1656: , p7_a19 JTF_NUMBER_TABLE
1657: , p7_a20 JTF_VARCHAR2_TABLE_100
1658: , p7_a21 JTF_VARCHAR2_TABLE_100
1652: , p7_a15 JTF_VARCHAR2_TABLE_100
1653: , p7_a16 JTF_VARCHAR2_TABLE_100
1654: , p7_a17 JTF_NUMBER_TABLE
1655: , p7_a18 JTF_VARCHAR2_TABLE_100
1656: , p7_a19 JTF_NUMBER_TABLE
1657: , p7_a20 JTF_VARCHAR2_TABLE_100
1658: , p7_a21 JTF_VARCHAR2_TABLE_100
1659: , p7_a22 JTF_VARCHAR2_TABLE_200
1660: , p7_a23 JTF_VARCHAR2_TABLE_200
1751: , p_validation_level NUMBER
1752: , x_return_status out nocopy VARCHAR2
1753: , x_msg_count out nocopy NUMBER
1754: , x_msg_data out nocopy VARCHAR2
1755: , p7_a0 JTF_NUMBER_TABLE
1756: , p7_a1 JTF_NUMBER_TABLE
1757: , p7_a2 JTF_NUMBER_TABLE
1758: , p7_a3 JTF_NUMBER_TABLE
1759: , p7_a4 JTF_NUMBER_TABLE
1752: , x_return_status out nocopy VARCHAR2
1753: , x_msg_count out nocopy NUMBER
1754: , x_msg_data out nocopy VARCHAR2
1755: , p7_a0 JTF_NUMBER_TABLE
1756: , p7_a1 JTF_NUMBER_TABLE
1757: , p7_a2 JTF_NUMBER_TABLE
1758: , p7_a3 JTF_NUMBER_TABLE
1759: , p7_a4 JTF_NUMBER_TABLE
1760: , p7_a5 JTF_NUMBER_TABLE
1753: , x_msg_count out nocopy NUMBER
1754: , x_msg_data out nocopy VARCHAR2
1755: , p7_a0 JTF_NUMBER_TABLE
1756: , p7_a1 JTF_NUMBER_TABLE
1757: , p7_a2 JTF_NUMBER_TABLE
1758: , p7_a3 JTF_NUMBER_TABLE
1759: , p7_a4 JTF_NUMBER_TABLE
1760: , p7_a5 JTF_NUMBER_TABLE
1761: , p7_a6 JTF_NUMBER_TABLE
1754: , x_msg_data out nocopy VARCHAR2
1755: , p7_a0 JTF_NUMBER_TABLE
1756: , p7_a1 JTF_NUMBER_TABLE
1757: , p7_a2 JTF_NUMBER_TABLE
1758: , p7_a3 JTF_NUMBER_TABLE
1759: , p7_a4 JTF_NUMBER_TABLE
1760: , p7_a5 JTF_NUMBER_TABLE
1761: , p7_a6 JTF_NUMBER_TABLE
1762: , p7_a7 JTF_NUMBER_TABLE
1755: , p7_a0 JTF_NUMBER_TABLE
1756: , p7_a1 JTF_NUMBER_TABLE
1757: , p7_a2 JTF_NUMBER_TABLE
1758: , p7_a3 JTF_NUMBER_TABLE
1759: , p7_a4 JTF_NUMBER_TABLE
1760: , p7_a5 JTF_NUMBER_TABLE
1761: , p7_a6 JTF_NUMBER_TABLE
1762: , p7_a7 JTF_NUMBER_TABLE
1763: , p7_a8 JTF_NUMBER_TABLE
1756: , p7_a1 JTF_NUMBER_TABLE
1757: , p7_a2 JTF_NUMBER_TABLE
1758: , p7_a3 JTF_NUMBER_TABLE
1759: , p7_a4 JTF_NUMBER_TABLE
1760: , p7_a5 JTF_NUMBER_TABLE
1761: , p7_a6 JTF_NUMBER_TABLE
1762: , p7_a7 JTF_NUMBER_TABLE
1763: , p7_a8 JTF_NUMBER_TABLE
1764: , p7_a9 JTF_NUMBER_TABLE
1757: , p7_a2 JTF_NUMBER_TABLE
1758: , p7_a3 JTF_NUMBER_TABLE
1759: , p7_a4 JTF_NUMBER_TABLE
1760: , p7_a5 JTF_NUMBER_TABLE
1761: , p7_a6 JTF_NUMBER_TABLE
1762: , p7_a7 JTF_NUMBER_TABLE
1763: , p7_a8 JTF_NUMBER_TABLE
1764: , p7_a9 JTF_NUMBER_TABLE
1765: , p7_a10 JTF_VARCHAR2_TABLE_100
1758: , p7_a3 JTF_NUMBER_TABLE
1759: , p7_a4 JTF_NUMBER_TABLE
1760: , p7_a5 JTF_NUMBER_TABLE
1761: , p7_a6 JTF_NUMBER_TABLE
1762: , p7_a7 JTF_NUMBER_TABLE
1763: , p7_a8 JTF_NUMBER_TABLE
1764: , p7_a9 JTF_NUMBER_TABLE
1765: , p7_a10 JTF_VARCHAR2_TABLE_100
1766: , p7_a11 JTF_VARCHAR2_TABLE_100
1759: , p7_a4 JTF_NUMBER_TABLE
1760: , p7_a5 JTF_NUMBER_TABLE
1761: , p7_a6 JTF_NUMBER_TABLE
1762: , p7_a7 JTF_NUMBER_TABLE
1763: , p7_a8 JTF_NUMBER_TABLE
1764: , p7_a9 JTF_NUMBER_TABLE
1765: , p7_a10 JTF_VARCHAR2_TABLE_100
1766: , p7_a11 JTF_VARCHAR2_TABLE_100
1767: , p7_a12 JTF_VARCHAR2_TABLE_100
1760: , p7_a5 JTF_NUMBER_TABLE
1761: , p7_a6 JTF_NUMBER_TABLE
1762: , p7_a7 JTF_NUMBER_TABLE
1763: , p7_a8 JTF_NUMBER_TABLE
1764: , p7_a9 JTF_NUMBER_TABLE
1765: , p7_a10 JTF_VARCHAR2_TABLE_100
1766: , p7_a11 JTF_VARCHAR2_TABLE_100
1767: , p7_a12 JTF_VARCHAR2_TABLE_100
1768: , p7_a13 JTF_VARCHAR2_TABLE_100
1766: , p7_a11 JTF_VARCHAR2_TABLE_100
1767: , p7_a12 JTF_VARCHAR2_TABLE_100
1768: , p7_a13 JTF_VARCHAR2_TABLE_100
1769: , p7_a14 JTF_VARCHAR2_TABLE_100
1770: , p7_a15 JTF_NUMBER_TABLE
1771: , p7_a16 JTF_NUMBER_TABLE
1772: , p7_a17 JTF_NUMBER_TABLE
1773: , p7_a18 JTF_VARCHAR2_TABLE_100
1774: , p7_a19 JTF_NUMBER_TABLE
1767: , p7_a12 JTF_VARCHAR2_TABLE_100
1768: , p7_a13 JTF_VARCHAR2_TABLE_100
1769: , p7_a14 JTF_VARCHAR2_TABLE_100
1770: , p7_a15 JTF_NUMBER_TABLE
1771: , p7_a16 JTF_NUMBER_TABLE
1772: , p7_a17 JTF_NUMBER_TABLE
1773: , p7_a18 JTF_VARCHAR2_TABLE_100
1774: , p7_a19 JTF_NUMBER_TABLE
1775: , p7_a20 JTF_NUMBER_TABLE
1768: , p7_a13 JTF_VARCHAR2_TABLE_100
1769: , p7_a14 JTF_VARCHAR2_TABLE_100
1770: , p7_a15 JTF_NUMBER_TABLE
1771: , p7_a16 JTF_NUMBER_TABLE
1772: , p7_a17 JTF_NUMBER_TABLE
1773: , p7_a18 JTF_VARCHAR2_TABLE_100
1774: , p7_a19 JTF_NUMBER_TABLE
1775: , p7_a20 JTF_NUMBER_TABLE
1776: , p7_a21 JTF_NUMBER_TABLE
1770: , p7_a15 JTF_NUMBER_TABLE
1771: , p7_a16 JTF_NUMBER_TABLE
1772: , p7_a17 JTF_NUMBER_TABLE
1773: , p7_a18 JTF_VARCHAR2_TABLE_100
1774: , p7_a19 JTF_NUMBER_TABLE
1775: , p7_a20 JTF_NUMBER_TABLE
1776: , p7_a21 JTF_NUMBER_TABLE
1777: , p7_a22 JTF_VARCHAR2_TABLE_100
1778: , p7_a23 JTF_NUMBER_TABLE
1771: , p7_a16 JTF_NUMBER_TABLE
1772: , p7_a17 JTF_NUMBER_TABLE
1773: , p7_a18 JTF_VARCHAR2_TABLE_100
1774: , p7_a19 JTF_NUMBER_TABLE
1775: , p7_a20 JTF_NUMBER_TABLE
1776: , p7_a21 JTF_NUMBER_TABLE
1777: , p7_a22 JTF_VARCHAR2_TABLE_100
1778: , p7_a23 JTF_NUMBER_TABLE
1779: , p7_a24 JTF_VARCHAR2_TABLE_100
1772: , p7_a17 JTF_NUMBER_TABLE
1773: , p7_a18 JTF_VARCHAR2_TABLE_100
1774: , p7_a19 JTF_NUMBER_TABLE
1775: , p7_a20 JTF_NUMBER_TABLE
1776: , p7_a21 JTF_NUMBER_TABLE
1777: , p7_a22 JTF_VARCHAR2_TABLE_100
1778: , p7_a23 JTF_NUMBER_TABLE
1779: , p7_a24 JTF_VARCHAR2_TABLE_100
1780: , p7_a25 JTF_VARCHAR2_TABLE_200
1774: , p7_a19 JTF_NUMBER_TABLE
1775: , p7_a20 JTF_NUMBER_TABLE
1776: , p7_a21 JTF_NUMBER_TABLE
1777: , p7_a22 JTF_VARCHAR2_TABLE_100
1778: , p7_a23 JTF_NUMBER_TABLE
1779: , p7_a24 JTF_VARCHAR2_TABLE_100
1780: , p7_a25 JTF_VARCHAR2_TABLE_200
1781: , p7_a26 JTF_VARCHAR2_TABLE_200
1782: , p7_a27 JTF_VARCHAR2_TABLE_200
1881: , p_validation_level NUMBER
1882: , x_return_status out nocopy VARCHAR2
1883: , x_msg_count out nocopy NUMBER
1884: , x_msg_data out nocopy VARCHAR2
1885: , p7_a0 JTF_NUMBER_TABLE
1886: , p7_a1 JTF_NUMBER_TABLE
1887: , p7_a2 JTF_NUMBER_TABLE
1888: , p7_a3 JTF_NUMBER_TABLE
1889: , p7_a4 JTF_NUMBER_TABLE
1882: , x_return_status out nocopy VARCHAR2
1883: , x_msg_count out nocopy NUMBER
1884: , x_msg_data out nocopy VARCHAR2
1885: , p7_a0 JTF_NUMBER_TABLE
1886: , p7_a1 JTF_NUMBER_TABLE
1887: , p7_a2 JTF_NUMBER_TABLE
1888: , p7_a3 JTF_NUMBER_TABLE
1889: , p7_a4 JTF_NUMBER_TABLE
1890: , p7_a5 JTF_NUMBER_TABLE
1883: , x_msg_count out nocopy NUMBER
1884: , x_msg_data out nocopy VARCHAR2
1885: , p7_a0 JTF_NUMBER_TABLE
1886: , p7_a1 JTF_NUMBER_TABLE
1887: , p7_a2 JTF_NUMBER_TABLE
1888: , p7_a3 JTF_NUMBER_TABLE
1889: , p7_a4 JTF_NUMBER_TABLE
1890: , p7_a5 JTF_NUMBER_TABLE
1891: , p7_a6 JTF_NUMBER_TABLE
1884: , x_msg_data out nocopy VARCHAR2
1885: , p7_a0 JTF_NUMBER_TABLE
1886: , p7_a1 JTF_NUMBER_TABLE
1887: , p7_a2 JTF_NUMBER_TABLE
1888: , p7_a3 JTF_NUMBER_TABLE
1889: , p7_a4 JTF_NUMBER_TABLE
1890: , p7_a5 JTF_NUMBER_TABLE
1891: , p7_a6 JTF_NUMBER_TABLE
1892: , p7_a7 JTF_NUMBER_TABLE
1885: , p7_a0 JTF_NUMBER_TABLE
1886: , p7_a1 JTF_NUMBER_TABLE
1887: , p7_a2 JTF_NUMBER_TABLE
1888: , p7_a3 JTF_NUMBER_TABLE
1889: , p7_a4 JTF_NUMBER_TABLE
1890: , p7_a5 JTF_NUMBER_TABLE
1891: , p7_a6 JTF_NUMBER_TABLE
1892: , p7_a7 JTF_NUMBER_TABLE
1893: , p7_a8 JTF_NUMBER_TABLE
1886: , p7_a1 JTF_NUMBER_TABLE
1887: , p7_a2 JTF_NUMBER_TABLE
1888: , p7_a3 JTF_NUMBER_TABLE
1889: , p7_a4 JTF_NUMBER_TABLE
1890: , p7_a5 JTF_NUMBER_TABLE
1891: , p7_a6 JTF_NUMBER_TABLE
1892: , p7_a7 JTF_NUMBER_TABLE
1893: , p7_a8 JTF_NUMBER_TABLE
1894: , p7_a9 JTF_NUMBER_TABLE
1887: , p7_a2 JTF_NUMBER_TABLE
1888: , p7_a3 JTF_NUMBER_TABLE
1889: , p7_a4 JTF_NUMBER_TABLE
1890: , p7_a5 JTF_NUMBER_TABLE
1891: , p7_a6 JTF_NUMBER_TABLE
1892: , p7_a7 JTF_NUMBER_TABLE
1893: , p7_a8 JTF_NUMBER_TABLE
1894: , p7_a9 JTF_NUMBER_TABLE
1895: , p7_a10 JTF_NUMBER_TABLE
1888: , p7_a3 JTF_NUMBER_TABLE
1889: , p7_a4 JTF_NUMBER_TABLE
1890: , p7_a5 JTF_NUMBER_TABLE
1891: , p7_a6 JTF_NUMBER_TABLE
1892: , p7_a7 JTF_NUMBER_TABLE
1893: , p7_a8 JTF_NUMBER_TABLE
1894: , p7_a9 JTF_NUMBER_TABLE
1895: , p7_a10 JTF_NUMBER_TABLE
1896: , p7_a11 JTF_VARCHAR2_TABLE_100
1889: , p7_a4 JTF_NUMBER_TABLE
1890: , p7_a5 JTF_NUMBER_TABLE
1891: , p7_a6 JTF_NUMBER_TABLE
1892: , p7_a7 JTF_NUMBER_TABLE
1893: , p7_a8 JTF_NUMBER_TABLE
1894: , p7_a9 JTF_NUMBER_TABLE
1895: , p7_a10 JTF_NUMBER_TABLE
1896: , p7_a11 JTF_VARCHAR2_TABLE_100
1897: , p7_a12 JTF_NUMBER_TABLE
1890: , p7_a5 JTF_NUMBER_TABLE
1891: , p7_a6 JTF_NUMBER_TABLE
1892: , p7_a7 JTF_NUMBER_TABLE
1893: , p7_a8 JTF_NUMBER_TABLE
1894: , p7_a9 JTF_NUMBER_TABLE
1895: , p7_a10 JTF_NUMBER_TABLE
1896: , p7_a11 JTF_VARCHAR2_TABLE_100
1897: , p7_a12 JTF_NUMBER_TABLE
1898: , p7_a13 JTF_NUMBER_TABLE
1891: , p7_a6 JTF_NUMBER_TABLE
1892: , p7_a7 JTF_NUMBER_TABLE
1893: , p7_a8 JTF_NUMBER_TABLE
1894: , p7_a9 JTF_NUMBER_TABLE
1895: , p7_a10 JTF_NUMBER_TABLE
1896: , p7_a11 JTF_VARCHAR2_TABLE_100
1897: , p7_a12 JTF_NUMBER_TABLE
1898: , p7_a13 JTF_NUMBER_TABLE
1899: , p7_a14 JTF_VARCHAR2_TABLE_100
1893: , p7_a8 JTF_NUMBER_TABLE
1894: , p7_a9 JTF_NUMBER_TABLE
1895: , p7_a10 JTF_NUMBER_TABLE
1896: , p7_a11 JTF_VARCHAR2_TABLE_100
1897: , p7_a12 JTF_NUMBER_TABLE
1898: , p7_a13 JTF_NUMBER_TABLE
1899: , p7_a14 JTF_VARCHAR2_TABLE_100
1900: , p7_a15 JTF_VARCHAR2_TABLE_100
1901: , p7_a16 JTF_VARCHAR2_TABLE_100
1894: , p7_a9 JTF_NUMBER_TABLE
1895: , p7_a10 JTF_NUMBER_TABLE
1896: , p7_a11 JTF_VARCHAR2_TABLE_100
1897: , p7_a12 JTF_NUMBER_TABLE
1898: , p7_a13 JTF_NUMBER_TABLE
1899: , p7_a14 JTF_VARCHAR2_TABLE_100
1900: , p7_a15 JTF_VARCHAR2_TABLE_100
1901: , p7_a16 JTF_VARCHAR2_TABLE_100
1902: , p7_a17 JTF_NUMBER_TABLE
1898: , p7_a13 JTF_NUMBER_TABLE
1899: , p7_a14 JTF_VARCHAR2_TABLE_100
1900: , p7_a15 JTF_VARCHAR2_TABLE_100
1901: , p7_a16 JTF_VARCHAR2_TABLE_100
1902: , p7_a17 JTF_NUMBER_TABLE
1903: , p7_a18 JTF_VARCHAR2_TABLE_100
1904: , p7_a19 JTF_NUMBER_TABLE
1905: , p7_a20 JTF_VARCHAR2_TABLE_100
1906: , p7_a21 JTF_VARCHAR2_TABLE_100
1900: , p7_a15 JTF_VARCHAR2_TABLE_100
1901: , p7_a16 JTF_VARCHAR2_TABLE_100
1902: , p7_a17 JTF_NUMBER_TABLE
1903: , p7_a18 JTF_VARCHAR2_TABLE_100
1904: , p7_a19 JTF_NUMBER_TABLE
1905: , p7_a20 JTF_VARCHAR2_TABLE_100
1906: , p7_a21 JTF_VARCHAR2_TABLE_100
1907: , p7_a22 JTF_VARCHAR2_TABLE_200
1908: , p7_a23 JTF_VARCHAR2_TABLE_200
1999: , p_validation_level NUMBER
2000: , x_return_status out nocopy VARCHAR2
2001: , x_msg_count out nocopy NUMBER
2002: , x_msg_data out nocopy VARCHAR2
2003: , p7_a0 JTF_NUMBER_TABLE
2004: , p7_a1 JTF_NUMBER_TABLE
2005: , p7_a2 JTF_NUMBER_TABLE
2006: , p7_a3 JTF_NUMBER_TABLE
2007: , p7_a4 JTF_VARCHAR2_TABLE_300
2000: , x_return_status out nocopy VARCHAR2
2001: , x_msg_count out nocopy NUMBER
2002: , x_msg_data out nocopy VARCHAR2
2003: , p7_a0 JTF_NUMBER_TABLE
2004: , p7_a1 JTF_NUMBER_TABLE
2005: , p7_a2 JTF_NUMBER_TABLE
2006: , p7_a3 JTF_NUMBER_TABLE
2007: , p7_a4 JTF_VARCHAR2_TABLE_300
2008: , p7_a5 JTF_DATE_TABLE
2001: , x_msg_count out nocopy NUMBER
2002: , x_msg_data out nocopy VARCHAR2
2003: , p7_a0 JTF_NUMBER_TABLE
2004: , p7_a1 JTF_NUMBER_TABLE
2005: , p7_a2 JTF_NUMBER_TABLE
2006: , p7_a3 JTF_NUMBER_TABLE
2007: , p7_a4 JTF_VARCHAR2_TABLE_300
2008: , p7_a5 JTF_DATE_TABLE
2009: , p7_a6 JTF_DATE_TABLE
2002: , x_msg_data out nocopy VARCHAR2
2003: , p7_a0 JTF_NUMBER_TABLE
2004: , p7_a1 JTF_NUMBER_TABLE
2005: , p7_a2 JTF_NUMBER_TABLE
2006: , p7_a3 JTF_NUMBER_TABLE
2007: , p7_a4 JTF_VARCHAR2_TABLE_300
2008: , p7_a5 JTF_DATE_TABLE
2009: , p7_a6 JTF_DATE_TABLE
2010: , p7_a7 JTF_DATE_TABLE
2008: , p7_a5 JTF_DATE_TABLE
2009: , p7_a6 JTF_DATE_TABLE
2010: , p7_a7 JTF_DATE_TABLE
2011: , p7_a8 JTF_DATE_TABLE
2012: , p7_a9 JTF_NUMBER_TABLE
2013: , p7_a10 JTF_NUMBER_TABLE
2014: , p7_a11 JTF_NUMBER_TABLE
2015: , p7_a12 JTF_NUMBER_TABLE
2016: , p7_a13 JTF_NUMBER_TABLE
2009: , p7_a6 JTF_DATE_TABLE
2010: , p7_a7 JTF_DATE_TABLE
2011: , p7_a8 JTF_DATE_TABLE
2012: , p7_a9 JTF_NUMBER_TABLE
2013: , p7_a10 JTF_NUMBER_TABLE
2014: , p7_a11 JTF_NUMBER_TABLE
2015: , p7_a12 JTF_NUMBER_TABLE
2016: , p7_a13 JTF_NUMBER_TABLE
2017: , p7_a14 JTF_VARCHAR2_TABLE_100
2010: , p7_a7 JTF_DATE_TABLE
2011: , p7_a8 JTF_DATE_TABLE
2012: , p7_a9 JTF_NUMBER_TABLE
2013: , p7_a10 JTF_NUMBER_TABLE
2014: , p7_a11 JTF_NUMBER_TABLE
2015: , p7_a12 JTF_NUMBER_TABLE
2016: , p7_a13 JTF_NUMBER_TABLE
2017: , p7_a14 JTF_VARCHAR2_TABLE_100
2018: , p7_a15 JTF_VARCHAR2_TABLE_100
2011: , p7_a8 JTF_DATE_TABLE
2012: , p7_a9 JTF_NUMBER_TABLE
2013: , p7_a10 JTF_NUMBER_TABLE
2014: , p7_a11 JTF_NUMBER_TABLE
2015: , p7_a12 JTF_NUMBER_TABLE
2016: , p7_a13 JTF_NUMBER_TABLE
2017: , p7_a14 JTF_VARCHAR2_TABLE_100
2018: , p7_a15 JTF_VARCHAR2_TABLE_100
2019: , p7_a16 JTF_NUMBER_TABLE
2012: , p7_a9 JTF_NUMBER_TABLE
2013: , p7_a10 JTF_NUMBER_TABLE
2014: , p7_a11 JTF_NUMBER_TABLE
2015: , p7_a12 JTF_NUMBER_TABLE
2016: , p7_a13 JTF_NUMBER_TABLE
2017: , p7_a14 JTF_VARCHAR2_TABLE_100
2018: , p7_a15 JTF_VARCHAR2_TABLE_100
2019: , p7_a16 JTF_NUMBER_TABLE
2020: , p7_a17 JTF_VARCHAR2_TABLE_100
2015: , p7_a12 JTF_NUMBER_TABLE
2016: , p7_a13 JTF_NUMBER_TABLE
2017: , p7_a14 JTF_VARCHAR2_TABLE_100
2018: , p7_a15 JTF_VARCHAR2_TABLE_100
2019: , p7_a16 JTF_NUMBER_TABLE
2020: , p7_a17 JTF_VARCHAR2_TABLE_100
2021: , p7_a18 JTF_VARCHAR2_TABLE_100
2022: , p7_a19 JTF_VARCHAR2_TABLE_200
2023: , p7_a20 JTF_VARCHAR2_TABLE_200
2113: , x_msg_count out nocopy NUMBER
2114: , x_msg_data out nocopy VARCHAR2
2115: , p_repair_line_id NUMBER
2116: , p_repair_quantity NUMBER
2117: , p9_a0 JTF_NUMBER_TABLE
2118: , p9_a1 JTF_NUMBER_TABLE
2119: , p9_a2 JTF_NUMBER_TABLE
2120: , p9_a3 JTF_NUMBER_TABLE
2121: )
2114: , x_msg_data out nocopy VARCHAR2
2115: , p_repair_line_id NUMBER
2116: , p_repair_quantity NUMBER
2117: , p9_a0 JTF_NUMBER_TABLE
2118: , p9_a1 JTF_NUMBER_TABLE
2119: , p9_a2 JTF_NUMBER_TABLE
2120: , p9_a3 JTF_NUMBER_TABLE
2121: )
2122:
2115: , p_repair_line_id NUMBER
2116: , p_repair_quantity NUMBER
2117: , p9_a0 JTF_NUMBER_TABLE
2118: , p9_a1 JTF_NUMBER_TABLE
2119: , p9_a2 JTF_NUMBER_TABLE
2120: , p9_a3 JTF_NUMBER_TABLE
2121: )
2122:
2123: as
2116: , p_repair_quantity NUMBER
2117: , p9_a0 JTF_NUMBER_TABLE
2118: , p9_a1 JTF_NUMBER_TABLE
2119: , p9_a2 JTF_NUMBER_TABLE
2120: , p9_a3 JTF_NUMBER_TABLE
2121: )
2122:
2123: as
2124: ddp_service_code_tbl csd_hv_wip_job_pvt.service_code_tbl_type;