1: package body csd_hv_wip_job_pvt_w as
2: /* $Header: csdwhvjb.pls 120.9 2008/03/25 01:18:11 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.9 2008/03/25 01:18:11 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.9 2008/03/25 01:18:11 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: ) as
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: ) as
113: ddindx binary_integer; indx binary_integer;
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: ) as
113: ddindx binary_integer; indx binary_integer;
114: begin
115: if a0 is not null and a0.count > 0 then
149: end loop;
150: end if;
151: end if;
152: end rosetta_table_copy_in_p5;
153: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_NUMBER_TABLE
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
150: end if;
151: end if;
152: end rosetta_table_copy_in_p5;
153: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_NUMBER_TABLE
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
151: end if;
152: end rosetta_table_copy_in_p5;
153: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_NUMBER_TABLE
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_NUMBER_TABLE
152: end rosetta_table_copy_in_p5;
153: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_NUMBER_TABLE
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_NUMBER_TABLE
160: , a7 out nocopy JTF_NUMBER_TABLE
153: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_NUMBER_TABLE
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_NUMBER_TABLE
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_NUMBER_TABLE
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_NUMBER_TABLE
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_NUMBER_TABLE
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_VARCHAR2_TABLE_100
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_NUMBER_TABLE
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_VARCHAR2_TABLE_100
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_NUMBER_TABLE
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_VARCHAR2_TABLE_100
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100
165: , a12 out nocopy JTF_VARCHAR2_TABLE_100
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_NUMBER_TABLE
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_VARCHAR2_TABLE_100
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100
165: , a12 out nocopy JTF_VARCHAR2_TABLE_100
166: , a13 out nocopy JTF_VARCHAR2_TABLE_100
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100
165: , a12 out nocopy JTF_VARCHAR2_TABLE_100
166: , a13 out nocopy JTF_VARCHAR2_TABLE_100
167: , a14 out nocopy JTF_VARCHAR2_TABLE_100
168: , a15 out nocopy JTF_NUMBER_TABLE
169: , a16 out nocopy JTF_NUMBER_TABLE
170: , a17 out nocopy JTF_NUMBER_TABLE
171: , a18 out nocopy JTF_VARCHAR2_TABLE_100
172: , a19 out nocopy JTF_NUMBER_TABLE
165: , a12 out nocopy JTF_VARCHAR2_TABLE_100
166: , a13 out nocopy JTF_VARCHAR2_TABLE_100
167: , a14 out nocopy JTF_VARCHAR2_TABLE_100
168: , a15 out nocopy JTF_NUMBER_TABLE
169: , a16 out nocopy JTF_NUMBER_TABLE
170: , a17 out nocopy JTF_NUMBER_TABLE
171: , a18 out nocopy JTF_VARCHAR2_TABLE_100
172: , a19 out nocopy JTF_NUMBER_TABLE
173: , a20 out nocopy JTF_NUMBER_TABLE
166: , a13 out nocopy JTF_VARCHAR2_TABLE_100
167: , a14 out nocopy JTF_VARCHAR2_TABLE_100
168: , a15 out nocopy JTF_NUMBER_TABLE
169: , a16 out nocopy JTF_NUMBER_TABLE
170: , a17 out nocopy JTF_NUMBER_TABLE
171: , a18 out nocopy JTF_VARCHAR2_TABLE_100
172: , a19 out nocopy JTF_NUMBER_TABLE
173: , a20 out nocopy JTF_NUMBER_TABLE
174: , a21 out nocopy JTF_NUMBER_TABLE
168: , a15 out nocopy JTF_NUMBER_TABLE
169: , a16 out nocopy JTF_NUMBER_TABLE
170: , a17 out nocopy JTF_NUMBER_TABLE
171: , a18 out nocopy JTF_VARCHAR2_TABLE_100
172: , a19 out nocopy JTF_NUMBER_TABLE
173: , a20 out nocopy JTF_NUMBER_TABLE
174: , a21 out nocopy JTF_NUMBER_TABLE
175: , a22 out nocopy JTF_VARCHAR2_TABLE_100
176: , a23 out nocopy JTF_NUMBER_TABLE
169: , a16 out nocopy JTF_NUMBER_TABLE
170: , a17 out nocopy JTF_NUMBER_TABLE
171: , a18 out nocopy JTF_VARCHAR2_TABLE_100
172: , a19 out nocopy JTF_NUMBER_TABLE
173: , a20 out nocopy JTF_NUMBER_TABLE
174: , a21 out nocopy JTF_NUMBER_TABLE
175: , a22 out nocopy JTF_VARCHAR2_TABLE_100
176: , a23 out nocopy JTF_NUMBER_TABLE
177: ) as
170: , a17 out nocopy JTF_NUMBER_TABLE
171: , a18 out nocopy JTF_VARCHAR2_TABLE_100
172: , a19 out nocopy JTF_NUMBER_TABLE
173: , a20 out nocopy JTF_NUMBER_TABLE
174: , a21 out nocopy JTF_NUMBER_TABLE
175: , a22 out nocopy JTF_VARCHAR2_TABLE_100
176: , a23 out nocopy JTF_NUMBER_TABLE
177: ) as
178: ddindx binary_integer; indx binary_integer;
172: , a19 out nocopy JTF_NUMBER_TABLE
173: , a20 out nocopy JTF_NUMBER_TABLE
174: , a21 out nocopy JTF_NUMBER_TABLE
175: , a22 out nocopy JTF_VARCHAR2_TABLE_100
176: , a23 out nocopy JTF_NUMBER_TABLE
177: ) as
178: ddindx binary_integer; indx binary_integer;
179: begin
180: if t is null or t.count = 0 then
177: ) as
178: ddindx binary_integer; indx binary_integer;
179: begin
180: if t is null or t.count = 0 then
181: a0 := JTF_NUMBER_TABLE();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_NUMBER_TABLE();
184: a3 := JTF_NUMBER_TABLE();
185: a4 := JTF_NUMBER_TABLE();
178: ddindx binary_integer; indx binary_integer;
179: begin
180: if t is null or t.count = 0 then
181: a0 := JTF_NUMBER_TABLE();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_NUMBER_TABLE();
184: a3 := JTF_NUMBER_TABLE();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_NUMBER_TABLE();
179: begin
180: if t is null or t.count = 0 then
181: a0 := JTF_NUMBER_TABLE();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_NUMBER_TABLE();
184: a3 := JTF_NUMBER_TABLE();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_NUMBER_TABLE();
187: a6 := JTF_NUMBER_TABLE();
180: if t is null or t.count = 0 then
181: a0 := JTF_NUMBER_TABLE();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_NUMBER_TABLE();
184: a3 := JTF_NUMBER_TABLE();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_NUMBER_TABLE();
187: a6 := JTF_NUMBER_TABLE();
188: a7 := JTF_NUMBER_TABLE();
181: a0 := JTF_NUMBER_TABLE();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_NUMBER_TABLE();
184: a3 := JTF_NUMBER_TABLE();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_NUMBER_TABLE();
187: a6 := JTF_NUMBER_TABLE();
188: a7 := JTF_NUMBER_TABLE();
189: a8 := JTF_NUMBER_TABLE();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_NUMBER_TABLE();
184: a3 := JTF_NUMBER_TABLE();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_NUMBER_TABLE();
187: a6 := JTF_NUMBER_TABLE();
188: a7 := JTF_NUMBER_TABLE();
189: a8 := JTF_NUMBER_TABLE();
190: a9 := JTF_NUMBER_TABLE();
183: a2 := JTF_NUMBER_TABLE();
184: a3 := JTF_NUMBER_TABLE();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_NUMBER_TABLE();
187: a6 := JTF_NUMBER_TABLE();
188: a7 := JTF_NUMBER_TABLE();
189: a8 := JTF_NUMBER_TABLE();
190: a9 := JTF_NUMBER_TABLE();
191: a10 := JTF_VARCHAR2_TABLE_100();
184: a3 := JTF_NUMBER_TABLE();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_NUMBER_TABLE();
187: a6 := JTF_NUMBER_TABLE();
188: a7 := JTF_NUMBER_TABLE();
189: a8 := JTF_NUMBER_TABLE();
190: a9 := JTF_NUMBER_TABLE();
191: a10 := JTF_VARCHAR2_TABLE_100();
192: a11 := JTF_VARCHAR2_TABLE_100();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_NUMBER_TABLE();
187: a6 := JTF_NUMBER_TABLE();
188: a7 := JTF_NUMBER_TABLE();
189: a8 := JTF_NUMBER_TABLE();
190: a9 := JTF_NUMBER_TABLE();
191: a10 := JTF_VARCHAR2_TABLE_100();
192: a11 := JTF_VARCHAR2_TABLE_100();
193: a12 := JTF_VARCHAR2_TABLE_100();
186: a5 := JTF_NUMBER_TABLE();
187: a6 := JTF_NUMBER_TABLE();
188: a7 := JTF_NUMBER_TABLE();
189: a8 := JTF_NUMBER_TABLE();
190: a9 := JTF_NUMBER_TABLE();
191: a10 := JTF_VARCHAR2_TABLE_100();
192: a11 := JTF_VARCHAR2_TABLE_100();
193: a12 := JTF_VARCHAR2_TABLE_100();
194: a13 := JTF_VARCHAR2_TABLE_100();
192: a11 := JTF_VARCHAR2_TABLE_100();
193: a12 := JTF_VARCHAR2_TABLE_100();
194: a13 := JTF_VARCHAR2_TABLE_100();
195: a14 := JTF_VARCHAR2_TABLE_100();
196: a15 := JTF_NUMBER_TABLE();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_NUMBER_TABLE();
199: a18 := JTF_VARCHAR2_TABLE_100();
200: a19 := JTF_NUMBER_TABLE();
193: a12 := JTF_VARCHAR2_TABLE_100();
194: a13 := JTF_VARCHAR2_TABLE_100();
195: a14 := JTF_VARCHAR2_TABLE_100();
196: a15 := JTF_NUMBER_TABLE();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_NUMBER_TABLE();
199: a18 := JTF_VARCHAR2_TABLE_100();
200: a19 := JTF_NUMBER_TABLE();
201: a20 := JTF_NUMBER_TABLE();
194: a13 := JTF_VARCHAR2_TABLE_100();
195: a14 := JTF_VARCHAR2_TABLE_100();
196: a15 := JTF_NUMBER_TABLE();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_NUMBER_TABLE();
199: a18 := JTF_VARCHAR2_TABLE_100();
200: a19 := JTF_NUMBER_TABLE();
201: a20 := JTF_NUMBER_TABLE();
202: a21 := JTF_NUMBER_TABLE();
196: a15 := JTF_NUMBER_TABLE();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_NUMBER_TABLE();
199: a18 := JTF_VARCHAR2_TABLE_100();
200: a19 := JTF_NUMBER_TABLE();
201: a20 := JTF_NUMBER_TABLE();
202: a21 := JTF_NUMBER_TABLE();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_NUMBER_TABLE();
199: a18 := JTF_VARCHAR2_TABLE_100();
200: a19 := JTF_NUMBER_TABLE();
201: a20 := JTF_NUMBER_TABLE();
202: a21 := JTF_NUMBER_TABLE();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
205: else
198: a17 := JTF_NUMBER_TABLE();
199: a18 := JTF_VARCHAR2_TABLE_100();
200: a19 := JTF_NUMBER_TABLE();
201: a20 := JTF_NUMBER_TABLE();
202: a21 := JTF_NUMBER_TABLE();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
200: a19 := JTF_NUMBER_TABLE();
201: a20 := JTF_NUMBER_TABLE();
202: a21 := JTF_NUMBER_TABLE();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
202: a21 := JTF_NUMBER_TABLE();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
204: a23 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_VARCHAR2_TABLE_100();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_VARCHAR2_TABLE_100();
217: a11 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_VARCHAR2_TABLE_100();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_VARCHAR2_TABLE_100();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_VARCHAR2_TABLE_100();
221: a15 := JTF_NUMBER_TABLE();
222: a16 := JTF_NUMBER_TABLE();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_NUMBER_TABLE();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_VARCHAR2_TABLE_100();
221: a15 := JTF_NUMBER_TABLE();
222: a16 := JTF_NUMBER_TABLE();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_NUMBER_TABLE();
226: a20 := JTF_NUMBER_TABLE();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_VARCHAR2_TABLE_100();
221: a15 := JTF_NUMBER_TABLE();
222: a16 := JTF_NUMBER_TABLE();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_NUMBER_TABLE();
226: a20 := JTF_NUMBER_TABLE();
227: a21 := JTF_NUMBER_TABLE();
221: a15 := JTF_NUMBER_TABLE();
222: a16 := JTF_NUMBER_TABLE();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_NUMBER_TABLE();
226: a20 := JTF_NUMBER_TABLE();
227: a21 := JTF_NUMBER_TABLE();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_NUMBER_TABLE();
222: a16 := JTF_NUMBER_TABLE();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_NUMBER_TABLE();
226: a20 := JTF_NUMBER_TABLE();
227: a21 := JTF_NUMBER_TABLE();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_NUMBER_TABLE();
230: if t.count > 0 then
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_NUMBER_TABLE();
226: a20 := JTF_NUMBER_TABLE();
227: a21 := JTF_NUMBER_TABLE();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_NUMBER_TABLE();
230: if t.count > 0 then
231: a0.extend(t.count);
225: a19 := JTF_NUMBER_TABLE();
226: a20 := JTF_NUMBER_TABLE();
227: a21 := JTF_NUMBER_TABLE();
228: a22 := JTF_VARCHAR2_TABLE_100();
229: a23 := JTF_NUMBER_TABLE();
230: if t.count > 0 then
231: a0.extend(t.count);
232: a1.extend(t.count);
233: a2.extend(t.count);
288: end if;
289: end if;
290: end rosetta_table_copy_out_p5;
291:
292: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
293: , a1 JTF_NUMBER_TABLE
294: , a2 JTF_NUMBER_TABLE
295: , a3 JTF_NUMBER_TABLE
296: , a4 JTF_NUMBER_TABLE
289: end if;
290: end rosetta_table_copy_out_p5;
291:
292: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
293: , a1 JTF_NUMBER_TABLE
294: , a2 JTF_NUMBER_TABLE
295: , a3 JTF_NUMBER_TABLE
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_NUMBER_TABLE
290: end rosetta_table_copy_out_p5;
291:
292: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
293: , a1 JTF_NUMBER_TABLE
294: , a2 JTF_NUMBER_TABLE
295: , a3 JTF_NUMBER_TABLE
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_NUMBER_TABLE
298: , a6 JTF_NUMBER_TABLE
291:
292: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
293: , a1 JTF_NUMBER_TABLE
294: , a2 JTF_NUMBER_TABLE
295: , a3 JTF_NUMBER_TABLE
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_NUMBER_TABLE
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
292: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
293: , a1 JTF_NUMBER_TABLE
294: , a2 JTF_NUMBER_TABLE
295: , a3 JTF_NUMBER_TABLE
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_NUMBER_TABLE
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: , a8 JTF_NUMBER_TABLE
293: , a1 JTF_NUMBER_TABLE
294: , a2 JTF_NUMBER_TABLE
295: , a3 JTF_NUMBER_TABLE
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_NUMBER_TABLE
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: , a8 JTF_NUMBER_TABLE
301: , a9 JTF_NUMBER_TABLE
294: , a2 JTF_NUMBER_TABLE
295: , a3 JTF_NUMBER_TABLE
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_NUMBER_TABLE
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: , a8 JTF_NUMBER_TABLE
301: , a9 JTF_NUMBER_TABLE
302: , a10 JTF_NUMBER_TABLE
295: , a3 JTF_NUMBER_TABLE
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_NUMBER_TABLE
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: , a8 JTF_NUMBER_TABLE
301: , a9 JTF_NUMBER_TABLE
302: , a10 JTF_NUMBER_TABLE
303: , a11 JTF_VARCHAR2_TABLE_100
296: , a4 JTF_NUMBER_TABLE
297: , a5 JTF_NUMBER_TABLE
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: , a8 JTF_NUMBER_TABLE
301: , a9 JTF_NUMBER_TABLE
302: , a10 JTF_NUMBER_TABLE
303: , a11 JTF_VARCHAR2_TABLE_100
304: , a12 JTF_NUMBER_TABLE
297: , a5 JTF_NUMBER_TABLE
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: , a8 JTF_NUMBER_TABLE
301: , a9 JTF_NUMBER_TABLE
302: , a10 JTF_NUMBER_TABLE
303: , a11 JTF_VARCHAR2_TABLE_100
304: , a12 JTF_NUMBER_TABLE
305: , a13 JTF_NUMBER_TABLE
298: , a6 JTF_NUMBER_TABLE
299: , a7 JTF_NUMBER_TABLE
300: , a8 JTF_NUMBER_TABLE
301: , a9 JTF_NUMBER_TABLE
302: , a10 JTF_NUMBER_TABLE
303: , a11 JTF_VARCHAR2_TABLE_100
304: , a12 JTF_NUMBER_TABLE
305: , a13 JTF_NUMBER_TABLE
306: , a14 JTF_VARCHAR2_TABLE_100
300: , a8 JTF_NUMBER_TABLE
301: , a9 JTF_NUMBER_TABLE
302: , a10 JTF_NUMBER_TABLE
303: , a11 JTF_VARCHAR2_TABLE_100
304: , a12 JTF_NUMBER_TABLE
305: , a13 JTF_NUMBER_TABLE
306: , a14 JTF_VARCHAR2_TABLE_100
307: , a15 JTF_VARCHAR2_TABLE_100
308: , a16 JTF_VARCHAR2_TABLE_100
301: , a9 JTF_NUMBER_TABLE
302: , a10 JTF_NUMBER_TABLE
303: , a11 JTF_VARCHAR2_TABLE_100
304: , a12 JTF_NUMBER_TABLE
305: , a13 JTF_NUMBER_TABLE
306: , a14 JTF_VARCHAR2_TABLE_100
307: , a15 JTF_VARCHAR2_TABLE_100
308: , a16 JTF_VARCHAR2_TABLE_100
309: , a17 JTF_NUMBER_TABLE
305: , a13 JTF_NUMBER_TABLE
306: , a14 JTF_VARCHAR2_TABLE_100
307: , a15 JTF_VARCHAR2_TABLE_100
308: , a16 JTF_VARCHAR2_TABLE_100
309: , a17 JTF_NUMBER_TABLE
310: , a18 JTF_VARCHAR2_TABLE_100
311: , a19 JTF_NUMBER_TABLE
312: , a20 JTF_VARCHAR2_TABLE_100
313: ) as
307: , a15 JTF_VARCHAR2_TABLE_100
308: , a16 JTF_VARCHAR2_TABLE_100
309: , a17 JTF_NUMBER_TABLE
310: , a18 JTF_VARCHAR2_TABLE_100
311: , a19 JTF_NUMBER_TABLE
312: , a20 JTF_VARCHAR2_TABLE_100
313: ) as
314: ddindx binary_integer; indx binary_integer;
315: begin
347: end loop;
348: end if;
349: end if;
350: end rosetta_table_copy_in_p7;
351: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
352: , a1 out nocopy JTF_NUMBER_TABLE
353: , a2 out nocopy JTF_NUMBER_TABLE
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE
348: end if;
349: end if;
350: end rosetta_table_copy_in_p7;
351: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
352: , a1 out nocopy JTF_NUMBER_TABLE
353: , a2 out nocopy JTF_NUMBER_TABLE
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE
356: , a5 out nocopy JTF_NUMBER_TABLE
349: end if;
350: end rosetta_table_copy_in_p7;
351: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
352: , a1 out nocopy JTF_NUMBER_TABLE
353: , a2 out nocopy JTF_NUMBER_TABLE
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE
356: , a5 out nocopy JTF_NUMBER_TABLE
357: , a6 out nocopy JTF_NUMBER_TABLE
350: end rosetta_table_copy_in_p7;
351: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
352: , a1 out nocopy JTF_NUMBER_TABLE
353: , a2 out nocopy JTF_NUMBER_TABLE
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE
356: , a5 out nocopy JTF_NUMBER_TABLE
357: , a6 out nocopy JTF_NUMBER_TABLE
358: , a7 out nocopy JTF_NUMBER_TABLE
351: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
352: , a1 out nocopy JTF_NUMBER_TABLE
353: , a2 out nocopy JTF_NUMBER_TABLE
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE
356: , a5 out nocopy JTF_NUMBER_TABLE
357: , a6 out nocopy JTF_NUMBER_TABLE
358: , a7 out nocopy JTF_NUMBER_TABLE
359: , a8 out nocopy JTF_NUMBER_TABLE
352: , a1 out nocopy JTF_NUMBER_TABLE
353: , a2 out nocopy JTF_NUMBER_TABLE
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE
356: , a5 out nocopy JTF_NUMBER_TABLE
357: , a6 out nocopy JTF_NUMBER_TABLE
358: , a7 out nocopy JTF_NUMBER_TABLE
359: , a8 out nocopy JTF_NUMBER_TABLE
360: , a9 out nocopy JTF_NUMBER_TABLE
353: , a2 out nocopy JTF_NUMBER_TABLE
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE
356: , a5 out nocopy JTF_NUMBER_TABLE
357: , a6 out nocopy JTF_NUMBER_TABLE
358: , a7 out nocopy JTF_NUMBER_TABLE
359: , a8 out nocopy JTF_NUMBER_TABLE
360: , a9 out nocopy JTF_NUMBER_TABLE
361: , a10 out nocopy JTF_NUMBER_TABLE
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE
356: , a5 out nocopy JTF_NUMBER_TABLE
357: , a6 out nocopy JTF_NUMBER_TABLE
358: , a7 out nocopy JTF_NUMBER_TABLE
359: , a8 out nocopy JTF_NUMBER_TABLE
360: , a9 out nocopy JTF_NUMBER_TABLE
361: , a10 out nocopy JTF_NUMBER_TABLE
362: , a11 out nocopy JTF_VARCHAR2_TABLE_100
355: , a4 out nocopy JTF_NUMBER_TABLE
356: , a5 out nocopy JTF_NUMBER_TABLE
357: , a6 out nocopy JTF_NUMBER_TABLE
358: , a7 out nocopy JTF_NUMBER_TABLE
359: , a8 out nocopy JTF_NUMBER_TABLE
360: , a9 out nocopy JTF_NUMBER_TABLE
361: , a10 out nocopy JTF_NUMBER_TABLE
362: , a11 out nocopy JTF_VARCHAR2_TABLE_100
363: , a12 out nocopy JTF_NUMBER_TABLE
356: , a5 out nocopy JTF_NUMBER_TABLE
357: , a6 out nocopy JTF_NUMBER_TABLE
358: , a7 out nocopy JTF_NUMBER_TABLE
359: , a8 out nocopy JTF_NUMBER_TABLE
360: , a9 out nocopy JTF_NUMBER_TABLE
361: , a10 out nocopy JTF_NUMBER_TABLE
362: , a11 out nocopy JTF_VARCHAR2_TABLE_100
363: , a12 out nocopy JTF_NUMBER_TABLE
364: , a13 out nocopy JTF_NUMBER_TABLE
357: , a6 out nocopy JTF_NUMBER_TABLE
358: , a7 out nocopy JTF_NUMBER_TABLE
359: , a8 out nocopy JTF_NUMBER_TABLE
360: , a9 out nocopy JTF_NUMBER_TABLE
361: , a10 out nocopy JTF_NUMBER_TABLE
362: , a11 out nocopy JTF_VARCHAR2_TABLE_100
363: , a12 out nocopy JTF_NUMBER_TABLE
364: , a13 out nocopy JTF_NUMBER_TABLE
365: , a14 out nocopy JTF_VARCHAR2_TABLE_100
359: , a8 out nocopy JTF_NUMBER_TABLE
360: , a9 out nocopy JTF_NUMBER_TABLE
361: , a10 out nocopy JTF_NUMBER_TABLE
362: , a11 out nocopy JTF_VARCHAR2_TABLE_100
363: , a12 out nocopy JTF_NUMBER_TABLE
364: , a13 out nocopy JTF_NUMBER_TABLE
365: , a14 out nocopy JTF_VARCHAR2_TABLE_100
366: , a15 out nocopy JTF_VARCHAR2_TABLE_100
367: , a16 out nocopy JTF_VARCHAR2_TABLE_100
360: , a9 out nocopy JTF_NUMBER_TABLE
361: , a10 out nocopy JTF_NUMBER_TABLE
362: , a11 out nocopy JTF_VARCHAR2_TABLE_100
363: , a12 out nocopy JTF_NUMBER_TABLE
364: , a13 out nocopy JTF_NUMBER_TABLE
365: , a14 out nocopy JTF_VARCHAR2_TABLE_100
366: , a15 out nocopy JTF_VARCHAR2_TABLE_100
367: , a16 out nocopy JTF_VARCHAR2_TABLE_100
368: , a17 out nocopy JTF_NUMBER_TABLE
364: , a13 out nocopy JTF_NUMBER_TABLE
365: , a14 out nocopy JTF_VARCHAR2_TABLE_100
366: , a15 out nocopy JTF_VARCHAR2_TABLE_100
367: , a16 out nocopy JTF_VARCHAR2_TABLE_100
368: , a17 out nocopy JTF_NUMBER_TABLE
369: , a18 out nocopy JTF_VARCHAR2_TABLE_100
370: , a19 out nocopy JTF_NUMBER_TABLE
371: , a20 out nocopy JTF_VARCHAR2_TABLE_100
372: ) as
366: , a15 out nocopy JTF_VARCHAR2_TABLE_100
367: , a16 out nocopy JTF_VARCHAR2_TABLE_100
368: , a17 out nocopy JTF_NUMBER_TABLE
369: , a18 out nocopy JTF_VARCHAR2_TABLE_100
370: , a19 out nocopy JTF_NUMBER_TABLE
371: , a20 out nocopy JTF_VARCHAR2_TABLE_100
372: ) as
373: ddindx binary_integer; indx binary_integer;
374: begin
372: ) as
373: ddindx binary_integer; indx binary_integer;
374: begin
375: if t is null or t.count = 0 then
376: a0 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_NUMBER_TABLE();
379: a3 := JTF_NUMBER_TABLE();
380: a4 := JTF_NUMBER_TABLE();
373: ddindx binary_integer; indx binary_integer;
374: begin
375: if t is null or t.count = 0 then
376: a0 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_NUMBER_TABLE();
379: a3 := JTF_NUMBER_TABLE();
380: a4 := JTF_NUMBER_TABLE();
381: a5 := JTF_NUMBER_TABLE();
374: begin
375: if t is null or t.count = 0 then
376: a0 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_NUMBER_TABLE();
379: a3 := JTF_NUMBER_TABLE();
380: a4 := JTF_NUMBER_TABLE();
381: a5 := JTF_NUMBER_TABLE();
382: a6 := JTF_NUMBER_TABLE();
375: if t is null or t.count = 0 then
376: a0 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_NUMBER_TABLE();
379: a3 := JTF_NUMBER_TABLE();
380: a4 := JTF_NUMBER_TABLE();
381: a5 := JTF_NUMBER_TABLE();
382: a6 := JTF_NUMBER_TABLE();
383: a7 := JTF_NUMBER_TABLE();
376: a0 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_NUMBER_TABLE();
379: a3 := JTF_NUMBER_TABLE();
380: a4 := JTF_NUMBER_TABLE();
381: a5 := JTF_NUMBER_TABLE();
382: a6 := JTF_NUMBER_TABLE();
383: a7 := JTF_NUMBER_TABLE();
384: a8 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_NUMBER_TABLE();
379: a3 := JTF_NUMBER_TABLE();
380: a4 := JTF_NUMBER_TABLE();
381: a5 := JTF_NUMBER_TABLE();
382: a6 := JTF_NUMBER_TABLE();
383: a7 := JTF_NUMBER_TABLE();
384: a8 := JTF_NUMBER_TABLE();
385: a9 := JTF_NUMBER_TABLE();
378: a2 := JTF_NUMBER_TABLE();
379: a3 := JTF_NUMBER_TABLE();
380: a4 := JTF_NUMBER_TABLE();
381: a5 := JTF_NUMBER_TABLE();
382: a6 := JTF_NUMBER_TABLE();
383: a7 := JTF_NUMBER_TABLE();
384: a8 := JTF_NUMBER_TABLE();
385: a9 := JTF_NUMBER_TABLE();
386: a10 := JTF_NUMBER_TABLE();
379: a3 := JTF_NUMBER_TABLE();
380: a4 := JTF_NUMBER_TABLE();
381: a5 := JTF_NUMBER_TABLE();
382: a6 := JTF_NUMBER_TABLE();
383: a7 := JTF_NUMBER_TABLE();
384: a8 := JTF_NUMBER_TABLE();
385: a9 := JTF_NUMBER_TABLE();
386: a10 := JTF_NUMBER_TABLE();
387: a11 := JTF_VARCHAR2_TABLE_100();
380: a4 := JTF_NUMBER_TABLE();
381: a5 := JTF_NUMBER_TABLE();
382: a6 := JTF_NUMBER_TABLE();
383: a7 := JTF_NUMBER_TABLE();
384: a8 := JTF_NUMBER_TABLE();
385: a9 := JTF_NUMBER_TABLE();
386: a10 := JTF_NUMBER_TABLE();
387: a11 := JTF_VARCHAR2_TABLE_100();
388: a12 := JTF_NUMBER_TABLE();
381: a5 := JTF_NUMBER_TABLE();
382: a6 := JTF_NUMBER_TABLE();
383: a7 := JTF_NUMBER_TABLE();
384: a8 := JTF_NUMBER_TABLE();
385: a9 := JTF_NUMBER_TABLE();
386: a10 := JTF_NUMBER_TABLE();
387: a11 := JTF_VARCHAR2_TABLE_100();
388: a12 := JTF_NUMBER_TABLE();
389: a13 := JTF_NUMBER_TABLE();
382: a6 := JTF_NUMBER_TABLE();
383: a7 := JTF_NUMBER_TABLE();
384: a8 := JTF_NUMBER_TABLE();
385: a9 := JTF_NUMBER_TABLE();
386: a10 := JTF_NUMBER_TABLE();
387: a11 := JTF_VARCHAR2_TABLE_100();
388: a12 := JTF_NUMBER_TABLE();
389: a13 := JTF_NUMBER_TABLE();
390: a14 := JTF_VARCHAR2_TABLE_100();
384: a8 := JTF_NUMBER_TABLE();
385: a9 := JTF_NUMBER_TABLE();
386: a10 := JTF_NUMBER_TABLE();
387: a11 := JTF_VARCHAR2_TABLE_100();
388: a12 := JTF_NUMBER_TABLE();
389: a13 := JTF_NUMBER_TABLE();
390: a14 := JTF_VARCHAR2_TABLE_100();
391: a15 := JTF_VARCHAR2_TABLE_100();
392: a16 := JTF_VARCHAR2_TABLE_100();
385: a9 := JTF_NUMBER_TABLE();
386: a10 := JTF_NUMBER_TABLE();
387: a11 := JTF_VARCHAR2_TABLE_100();
388: a12 := JTF_NUMBER_TABLE();
389: a13 := JTF_NUMBER_TABLE();
390: a14 := JTF_VARCHAR2_TABLE_100();
391: a15 := JTF_VARCHAR2_TABLE_100();
392: a16 := JTF_VARCHAR2_TABLE_100();
393: a17 := JTF_NUMBER_TABLE();
389: a13 := JTF_NUMBER_TABLE();
390: a14 := JTF_VARCHAR2_TABLE_100();
391: a15 := JTF_VARCHAR2_TABLE_100();
392: a16 := JTF_VARCHAR2_TABLE_100();
393: a17 := JTF_NUMBER_TABLE();
394: a18 := JTF_VARCHAR2_TABLE_100();
395: a19 := JTF_NUMBER_TABLE();
396: a20 := JTF_VARCHAR2_TABLE_100();
397: else
391: a15 := JTF_VARCHAR2_TABLE_100();
392: a16 := JTF_VARCHAR2_TABLE_100();
393: a17 := JTF_NUMBER_TABLE();
394: a18 := JTF_VARCHAR2_TABLE_100();
395: a19 := JTF_NUMBER_TABLE();
396: a20 := JTF_VARCHAR2_TABLE_100();
397: else
398: a0 := JTF_NUMBER_TABLE();
399: a1 := JTF_NUMBER_TABLE();
394: a18 := JTF_VARCHAR2_TABLE_100();
395: a19 := JTF_NUMBER_TABLE();
396: a20 := JTF_VARCHAR2_TABLE_100();
397: else
398: a0 := JTF_NUMBER_TABLE();
399: a1 := JTF_NUMBER_TABLE();
400: a2 := JTF_NUMBER_TABLE();
401: a3 := JTF_NUMBER_TABLE();
402: a4 := JTF_NUMBER_TABLE();
395: a19 := JTF_NUMBER_TABLE();
396: a20 := JTF_VARCHAR2_TABLE_100();
397: else
398: a0 := JTF_NUMBER_TABLE();
399: a1 := JTF_NUMBER_TABLE();
400: a2 := JTF_NUMBER_TABLE();
401: a3 := JTF_NUMBER_TABLE();
402: a4 := JTF_NUMBER_TABLE();
403: a5 := JTF_NUMBER_TABLE();
396: a20 := JTF_VARCHAR2_TABLE_100();
397: else
398: a0 := JTF_NUMBER_TABLE();
399: a1 := JTF_NUMBER_TABLE();
400: a2 := JTF_NUMBER_TABLE();
401: a3 := JTF_NUMBER_TABLE();
402: a4 := JTF_NUMBER_TABLE();
403: a5 := JTF_NUMBER_TABLE();
404: a6 := JTF_NUMBER_TABLE();
397: else
398: a0 := JTF_NUMBER_TABLE();
399: a1 := JTF_NUMBER_TABLE();
400: a2 := JTF_NUMBER_TABLE();
401: a3 := JTF_NUMBER_TABLE();
402: a4 := JTF_NUMBER_TABLE();
403: a5 := JTF_NUMBER_TABLE();
404: a6 := JTF_NUMBER_TABLE();
405: a7 := JTF_NUMBER_TABLE();
398: a0 := JTF_NUMBER_TABLE();
399: a1 := JTF_NUMBER_TABLE();
400: a2 := JTF_NUMBER_TABLE();
401: a3 := JTF_NUMBER_TABLE();
402: a4 := JTF_NUMBER_TABLE();
403: a5 := JTF_NUMBER_TABLE();
404: a6 := JTF_NUMBER_TABLE();
405: a7 := JTF_NUMBER_TABLE();
406: a8 := JTF_NUMBER_TABLE();
399: a1 := JTF_NUMBER_TABLE();
400: a2 := JTF_NUMBER_TABLE();
401: a3 := JTF_NUMBER_TABLE();
402: a4 := JTF_NUMBER_TABLE();
403: a5 := JTF_NUMBER_TABLE();
404: a6 := JTF_NUMBER_TABLE();
405: a7 := JTF_NUMBER_TABLE();
406: a8 := JTF_NUMBER_TABLE();
407: a9 := JTF_NUMBER_TABLE();
400: a2 := JTF_NUMBER_TABLE();
401: a3 := JTF_NUMBER_TABLE();
402: a4 := JTF_NUMBER_TABLE();
403: a5 := JTF_NUMBER_TABLE();
404: a6 := JTF_NUMBER_TABLE();
405: a7 := JTF_NUMBER_TABLE();
406: a8 := JTF_NUMBER_TABLE();
407: a9 := JTF_NUMBER_TABLE();
408: a10 := JTF_NUMBER_TABLE();
401: a3 := JTF_NUMBER_TABLE();
402: a4 := JTF_NUMBER_TABLE();
403: a5 := JTF_NUMBER_TABLE();
404: a6 := JTF_NUMBER_TABLE();
405: a7 := JTF_NUMBER_TABLE();
406: a8 := JTF_NUMBER_TABLE();
407: a9 := JTF_NUMBER_TABLE();
408: a10 := JTF_NUMBER_TABLE();
409: a11 := JTF_VARCHAR2_TABLE_100();
402: a4 := JTF_NUMBER_TABLE();
403: a5 := JTF_NUMBER_TABLE();
404: a6 := JTF_NUMBER_TABLE();
405: a7 := JTF_NUMBER_TABLE();
406: a8 := JTF_NUMBER_TABLE();
407: a9 := JTF_NUMBER_TABLE();
408: a10 := JTF_NUMBER_TABLE();
409: a11 := JTF_VARCHAR2_TABLE_100();
410: a12 := JTF_NUMBER_TABLE();
403: a5 := JTF_NUMBER_TABLE();
404: a6 := JTF_NUMBER_TABLE();
405: a7 := JTF_NUMBER_TABLE();
406: a8 := JTF_NUMBER_TABLE();
407: a9 := JTF_NUMBER_TABLE();
408: a10 := JTF_NUMBER_TABLE();
409: a11 := JTF_VARCHAR2_TABLE_100();
410: a12 := JTF_NUMBER_TABLE();
411: a13 := JTF_NUMBER_TABLE();
404: a6 := JTF_NUMBER_TABLE();
405: a7 := JTF_NUMBER_TABLE();
406: a8 := JTF_NUMBER_TABLE();
407: a9 := JTF_NUMBER_TABLE();
408: a10 := JTF_NUMBER_TABLE();
409: a11 := JTF_VARCHAR2_TABLE_100();
410: a12 := JTF_NUMBER_TABLE();
411: a13 := JTF_NUMBER_TABLE();
412: a14 := JTF_VARCHAR2_TABLE_100();
406: a8 := JTF_NUMBER_TABLE();
407: a9 := JTF_NUMBER_TABLE();
408: a10 := JTF_NUMBER_TABLE();
409: a11 := JTF_VARCHAR2_TABLE_100();
410: a12 := JTF_NUMBER_TABLE();
411: a13 := JTF_NUMBER_TABLE();
412: a14 := JTF_VARCHAR2_TABLE_100();
413: a15 := JTF_VARCHAR2_TABLE_100();
414: a16 := JTF_VARCHAR2_TABLE_100();
407: a9 := JTF_NUMBER_TABLE();
408: a10 := JTF_NUMBER_TABLE();
409: a11 := JTF_VARCHAR2_TABLE_100();
410: a12 := JTF_NUMBER_TABLE();
411: a13 := JTF_NUMBER_TABLE();
412: a14 := JTF_VARCHAR2_TABLE_100();
413: a15 := JTF_VARCHAR2_TABLE_100();
414: a16 := JTF_VARCHAR2_TABLE_100();
415: a17 := JTF_NUMBER_TABLE();
411: a13 := JTF_NUMBER_TABLE();
412: a14 := JTF_VARCHAR2_TABLE_100();
413: a15 := JTF_VARCHAR2_TABLE_100();
414: a16 := JTF_VARCHAR2_TABLE_100();
415: a17 := JTF_NUMBER_TABLE();
416: a18 := JTF_VARCHAR2_TABLE_100();
417: a19 := JTF_NUMBER_TABLE();
418: a20 := JTF_VARCHAR2_TABLE_100();
419: if t.count > 0 then
413: a15 := JTF_VARCHAR2_TABLE_100();
414: a16 := JTF_VARCHAR2_TABLE_100();
415: a17 := JTF_NUMBER_TABLE();
416: a18 := JTF_VARCHAR2_TABLE_100();
417: a19 := JTF_NUMBER_TABLE();
418: a20 := JTF_VARCHAR2_TABLE_100();
419: if t.count > 0 then
420: a0.extend(t.count);
421: a1.extend(t.count);
471: end if;
472: end if;
473: end rosetta_table_copy_out_p7;
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_VARCHAR2_TABLE_300
472: end if;
473: end rosetta_table_copy_out_p7;
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_VARCHAR2_TABLE_300
480: , a5 JTF_DATE_TABLE
473: end rosetta_table_copy_out_p7;
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_VARCHAR2_TABLE_300
480: , a5 JTF_DATE_TABLE
481: , a6 JTF_DATE_TABLE
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_VARCHAR2_TABLE_300
480: , a5 JTF_DATE_TABLE
481: , a6 JTF_DATE_TABLE
482: , a7 JTF_DATE_TABLE
480: , a5 JTF_DATE_TABLE
481: , a6 JTF_DATE_TABLE
482: , a7 JTF_DATE_TABLE
483: , a8 JTF_DATE_TABLE
484: , a9 JTF_NUMBER_TABLE
485: , a10 JTF_NUMBER_TABLE
486: , a11 JTF_NUMBER_TABLE
487: , a12 JTF_NUMBER_TABLE
488: , a13 JTF_NUMBER_TABLE
481: , a6 JTF_DATE_TABLE
482: , a7 JTF_DATE_TABLE
483: , a8 JTF_DATE_TABLE
484: , a9 JTF_NUMBER_TABLE
485: , a10 JTF_NUMBER_TABLE
486: , a11 JTF_NUMBER_TABLE
487: , a12 JTF_NUMBER_TABLE
488: , a13 JTF_NUMBER_TABLE
489: , a14 JTF_VARCHAR2_TABLE_100
482: , a7 JTF_DATE_TABLE
483: , a8 JTF_DATE_TABLE
484: , a9 JTF_NUMBER_TABLE
485: , a10 JTF_NUMBER_TABLE
486: , a11 JTF_NUMBER_TABLE
487: , a12 JTF_NUMBER_TABLE
488: , a13 JTF_NUMBER_TABLE
489: , a14 JTF_VARCHAR2_TABLE_100
490: , a15 JTF_VARCHAR2_TABLE_100
483: , a8 JTF_DATE_TABLE
484: , a9 JTF_NUMBER_TABLE
485: , a10 JTF_NUMBER_TABLE
486: , a11 JTF_NUMBER_TABLE
487: , a12 JTF_NUMBER_TABLE
488: , a13 JTF_NUMBER_TABLE
489: , a14 JTF_VARCHAR2_TABLE_100
490: , a15 JTF_VARCHAR2_TABLE_100
491: , a16 JTF_NUMBER_TABLE
484: , a9 JTF_NUMBER_TABLE
485: , a10 JTF_NUMBER_TABLE
486: , a11 JTF_NUMBER_TABLE
487: , a12 JTF_NUMBER_TABLE
488: , a13 JTF_NUMBER_TABLE
489: , a14 JTF_VARCHAR2_TABLE_100
490: , a15 JTF_VARCHAR2_TABLE_100
491: , a16 JTF_NUMBER_TABLE
492: , a17 JTF_VARCHAR2_TABLE_100
487: , a12 JTF_NUMBER_TABLE
488: , a13 JTF_NUMBER_TABLE
489: , a14 JTF_VARCHAR2_TABLE_100
490: , a15 JTF_VARCHAR2_TABLE_100
491: , a16 JTF_NUMBER_TABLE
492: , a17 JTF_VARCHAR2_TABLE_100
493: ) as
494: ddindx binary_integer; indx binary_integer;
495: begin
524: end loop;
525: end if;
526: end if;
527: end rosetta_table_copy_in_p9;
528: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
529: , a1 out nocopy JTF_NUMBER_TABLE
530: , a2 out nocopy JTF_NUMBER_TABLE
531: , a3 out nocopy JTF_NUMBER_TABLE
532: , a4 out nocopy JTF_VARCHAR2_TABLE_300
525: end if;
526: end if;
527: end rosetta_table_copy_in_p9;
528: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
529: , a1 out nocopy JTF_NUMBER_TABLE
530: , a2 out nocopy JTF_NUMBER_TABLE
531: , a3 out nocopy JTF_NUMBER_TABLE
532: , a4 out nocopy JTF_VARCHAR2_TABLE_300
533: , a5 out nocopy JTF_DATE_TABLE
526: end if;
527: end rosetta_table_copy_in_p9;
528: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
529: , a1 out nocopy JTF_NUMBER_TABLE
530: , a2 out nocopy JTF_NUMBER_TABLE
531: , a3 out nocopy JTF_NUMBER_TABLE
532: , a4 out nocopy JTF_VARCHAR2_TABLE_300
533: , a5 out nocopy JTF_DATE_TABLE
534: , a6 out nocopy JTF_DATE_TABLE
527: end rosetta_table_copy_in_p9;
528: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
529: , a1 out nocopy JTF_NUMBER_TABLE
530: , a2 out nocopy JTF_NUMBER_TABLE
531: , a3 out nocopy JTF_NUMBER_TABLE
532: , a4 out nocopy JTF_VARCHAR2_TABLE_300
533: , a5 out nocopy JTF_DATE_TABLE
534: , a6 out nocopy JTF_DATE_TABLE
535: , a7 out nocopy JTF_DATE_TABLE
533: , a5 out nocopy JTF_DATE_TABLE
534: , a6 out nocopy JTF_DATE_TABLE
535: , a7 out nocopy JTF_DATE_TABLE
536: , a8 out nocopy JTF_DATE_TABLE
537: , a9 out nocopy JTF_NUMBER_TABLE
538: , a10 out nocopy JTF_NUMBER_TABLE
539: , a11 out nocopy JTF_NUMBER_TABLE
540: , a12 out nocopy JTF_NUMBER_TABLE
541: , a13 out nocopy JTF_NUMBER_TABLE
534: , a6 out nocopy JTF_DATE_TABLE
535: , a7 out nocopy JTF_DATE_TABLE
536: , a8 out nocopy JTF_DATE_TABLE
537: , a9 out nocopy JTF_NUMBER_TABLE
538: , a10 out nocopy JTF_NUMBER_TABLE
539: , a11 out nocopy JTF_NUMBER_TABLE
540: , a12 out nocopy JTF_NUMBER_TABLE
541: , a13 out nocopy JTF_NUMBER_TABLE
542: , a14 out nocopy JTF_VARCHAR2_TABLE_100
535: , a7 out nocopy JTF_DATE_TABLE
536: , a8 out nocopy JTF_DATE_TABLE
537: , a9 out nocopy JTF_NUMBER_TABLE
538: , a10 out nocopy JTF_NUMBER_TABLE
539: , a11 out nocopy JTF_NUMBER_TABLE
540: , a12 out nocopy JTF_NUMBER_TABLE
541: , a13 out nocopy JTF_NUMBER_TABLE
542: , a14 out nocopy JTF_VARCHAR2_TABLE_100
543: , a15 out nocopy JTF_VARCHAR2_TABLE_100
536: , a8 out nocopy JTF_DATE_TABLE
537: , a9 out nocopy JTF_NUMBER_TABLE
538: , a10 out nocopy JTF_NUMBER_TABLE
539: , a11 out nocopy JTF_NUMBER_TABLE
540: , a12 out nocopy JTF_NUMBER_TABLE
541: , a13 out nocopy JTF_NUMBER_TABLE
542: , a14 out nocopy JTF_VARCHAR2_TABLE_100
543: , a15 out nocopy JTF_VARCHAR2_TABLE_100
544: , a16 out nocopy JTF_NUMBER_TABLE
537: , a9 out nocopy JTF_NUMBER_TABLE
538: , a10 out nocopy JTF_NUMBER_TABLE
539: , a11 out nocopy JTF_NUMBER_TABLE
540: , a12 out nocopy JTF_NUMBER_TABLE
541: , a13 out nocopy JTF_NUMBER_TABLE
542: , a14 out nocopy JTF_VARCHAR2_TABLE_100
543: , a15 out nocopy JTF_VARCHAR2_TABLE_100
544: , a16 out nocopy JTF_NUMBER_TABLE
545: , a17 out nocopy JTF_VARCHAR2_TABLE_100
540: , a12 out nocopy JTF_NUMBER_TABLE
541: , a13 out nocopy JTF_NUMBER_TABLE
542: , a14 out nocopy JTF_VARCHAR2_TABLE_100
543: , a15 out nocopy JTF_VARCHAR2_TABLE_100
544: , a16 out nocopy JTF_NUMBER_TABLE
545: , a17 out nocopy JTF_VARCHAR2_TABLE_100
546: ) as
547: ddindx binary_integer; indx binary_integer;
548: begin
546: ) as
547: ddindx binary_integer; indx binary_integer;
548: begin
549: if t is null or t.count = 0 then
550: a0 := JTF_NUMBER_TABLE();
551: a1 := JTF_NUMBER_TABLE();
552: a2 := JTF_NUMBER_TABLE();
553: a3 := JTF_NUMBER_TABLE();
554: a4 := JTF_VARCHAR2_TABLE_300();
547: ddindx binary_integer; indx binary_integer;
548: begin
549: if t is null or t.count = 0 then
550: a0 := JTF_NUMBER_TABLE();
551: a1 := JTF_NUMBER_TABLE();
552: a2 := JTF_NUMBER_TABLE();
553: a3 := JTF_NUMBER_TABLE();
554: a4 := JTF_VARCHAR2_TABLE_300();
555: a5 := JTF_DATE_TABLE();
548: begin
549: if t is null or t.count = 0 then
550: a0 := JTF_NUMBER_TABLE();
551: a1 := JTF_NUMBER_TABLE();
552: a2 := JTF_NUMBER_TABLE();
553: a3 := JTF_NUMBER_TABLE();
554: a4 := JTF_VARCHAR2_TABLE_300();
555: a5 := JTF_DATE_TABLE();
556: a6 := JTF_DATE_TABLE();
549: if t is null or t.count = 0 then
550: a0 := JTF_NUMBER_TABLE();
551: a1 := JTF_NUMBER_TABLE();
552: a2 := JTF_NUMBER_TABLE();
553: a3 := JTF_NUMBER_TABLE();
554: a4 := JTF_VARCHAR2_TABLE_300();
555: a5 := JTF_DATE_TABLE();
556: a6 := JTF_DATE_TABLE();
557: a7 := JTF_DATE_TABLE();
555: a5 := JTF_DATE_TABLE();
556: a6 := JTF_DATE_TABLE();
557: a7 := JTF_DATE_TABLE();
558: a8 := JTF_DATE_TABLE();
559: a9 := JTF_NUMBER_TABLE();
560: a10 := JTF_NUMBER_TABLE();
561: a11 := JTF_NUMBER_TABLE();
562: a12 := JTF_NUMBER_TABLE();
563: a13 := JTF_NUMBER_TABLE();
556: a6 := JTF_DATE_TABLE();
557: a7 := JTF_DATE_TABLE();
558: a8 := JTF_DATE_TABLE();
559: a9 := JTF_NUMBER_TABLE();
560: a10 := JTF_NUMBER_TABLE();
561: a11 := JTF_NUMBER_TABLE();
562: a12 := JTF_NUMBER_TABLE();
563: a13 := JTF_NUMBER_TABLE();
564: a14 := JTF_VARCHAR2_TABLE_100();
557: a7 := JTF_DATE_TABLE();
558: a8 := JTF_DATE_TABLE();
559: a9 := JTF_NUMBER_TABLE();
560: a10 := JTF_NUMBER_TABLE();
561: a11 := JTF_NUMBER_TABLE();
562: a12 := JTF_NUMBER_TABLE();
563: a13 := JTF_NUMBER_TABLE();
564: a14 := JTF_VARCHAR2_TABLE_100();
565: a15 := JTF_VARCHAR2_TABLE_100();
558: a8 := JTF_DATE_TABLE();
559: a9 := JTF_NUMBER_TABLE();
560: a10 := JTF_NUMBER_TABLE();
561: a11 := JTF_NUMBER_TABLE();
562: a12 := JTF_NUMBER_TABLE();
563: a13 := JTF_NUMBER_TABLE();
564: a14 := JTF_VARCHAR2_TABLE_100();
565: a15 := JTF_VARCHAR2_TABLE_100();
566: a16 := JTF_NUMBER_TABLE();
559: a9 := JTF_NUMBER_TABLE();
560: a10 := JTF_NUMBER_TABLE();
561: a11 := JTF_NUMBER_TABLE();
562: a12 := JTF_NUMBER_TABLE();
563: a13 := JTF_NUMBER_TABLE();
564: a14 := JTF_VARCHAR2_TABLE_100();
565: a15 := JTF_VARCHAR2_TABLE_100();
566: a16 := JTF_NUMBER_TABLE();
567: a17 := JTF_VARCHAR2_TABLE_100();
562: a12 := JTF_NUMBER_TABLE();
563: a13 := JTF_NUMBER_TABLE();
564: a14 := JTF_VARCHAR2_TABLE_100();
565: a15 := JTF_VARCHAR2_TABLE_100();
566: a16 := JTF_NUMBER_TABLE();
567: a17 := JTF_VARCHAR2_TABLE_100();
568: else
569: a0 := JTF_NUMBER_TABLE();
570: a1 := JTF_NUMBER_TABLE();
565: a15 := JTF_VARCHAR2_TABLE_100();
566: a16 := JTF_NUMBER_TABLE();
567: a17 := JTF_VARCHAR2_TABLE_100();
568: else
569: a0 := JTF_NUMBER_TABLE();
570: a1 := JTF_NUMBER_TABLE();
571: a2 := JTF_NUMBER_TABLE();
572: a3 := JTF_NUMBER_TABLE();
573: a4 := JTF_VARCHAR2_TABLE_300();
566: a16 := JTF_NUMBER_TABLE();
567: a17 := JTF_VARCHAR2_TABLE_100();
568: else
569: a0 := JTF_NUMBER_TABLE();
570: a1 := JTF_NUMBER_TABLE();
571: a2 := JTF_NUMBER_TABLE();
572: a3 := JTF_NUMBER_TABLE();
573: a4 := JTF_VARCHAR2_TABLE_300();
574: a5 := JTF_DATE_TABLE();
567: a17 := JTF_VARCHAR2_TABLE_100();
568: else
569: a0 := JTF_NUMBER_TABLE();
570: a1 := JTF_NUMBER_TABLE();
571: a2 := JTF_NUMBER_TABLE();
572: a3 := JTF_NUMBER_TABLE();
573: a4 := JTF_VARCHAR2_TABLE_300();
574: a5 := JTF_DATE_TABLE();
575: a6 := JTF_DATE_TABLE();
568: else
569: a0 := JTF_NUMBER_TABLE();
570: a1 := JTF_NUMBER_TABLE();
571: a2 := JTF_NUMBER_TABLE();
572: a3 := JTF_NUMBER_TABLE();
573: a4 := JTF_VARCHAR2_TABLE_300();
574: a5 := JTF_DATE_TABLE();
575: a6 := JTF_DATE_TABLE();
576: a7 := JTF_DATE_TABLE();
574: a5 := JTF_DATE_TABLE();
575: a6 := JTF_DATE_TABLE();
576: a7 := JTF_DATE_TABLE();
577: a8 := JTF_DATE_TABLE();
578: a9 := JTF_NUMBER_TABLE();
579: a10 := JTF_NUMBER_TABLE();
580: a11 := JTF_NUMBER_TABLE();
581: a12 := JTF_NUMBER_TABLE();
582: a13 := JTF_NUMBER_TABLE();
575: a6 := JTF_DATE_TABLE();
576: a7 := JTF_DATE_TABLE();
577: a8 := JTF_DATE_TABLE();
578: a9 := JTF_NUMBER_TABLE();
579: a10 := JTF_NUMBER_TABLE();
580: a11 := JTF_NUMBER_TABLE();
581: a12 := JTF_NUMBER_TABLE();
582: a13 := JTF_NUMBER_TABLE();
583: a14 := JTF_VARCHAR2_TABLE_100();
576: a7 := JTF_DATE_TABLE();
577: a8 := JTF_DATE_TABLE();
578: a9 := JTF_NUMBER_TABLE();
579: a10 := JTF_NUMBER_TABLE();
580: a11 := JTF_NUMBER_TABLE();
581: a12 := JTF_NUMBER_TABLE();
582: a13 := JTF_NUMBER_TABLE();
583: a14 := JTF_VARCHAR2_TABLE_100();
584: a15 := JTF_VARCHAR2_TABLE_100();
577: a8 := JTF_DATE_TABLE();
578: a9 := JTF_NUMBER_TABLE();
579: a10 := JTF_NUMBER_TABLE();
580: a11 := JTF_NUMBER_TABLE();
581: a12 := JTF_NUMBER_TABLE();
582: a13 := JTF_NUMBER_TABLE();
583: a14 := JTF_VARCHAR2_TABLE_100();
584: a15 := JTF_VARCHAR2_TABLE_100();
585: a16 := JTF_NUMBER_TABLE();
578: a9 := JTF_NUMBER_TABLE();
579: a10 := JTF_NUMBER_TABLE();
580: a11 := JTF_NUMBER_TABLE();
581: a12 := JTF_NUMBER_TABLE();
582: a13 := JTF_NUMBER_TABLE();
583: a14 := JTF_VARCHAR2_TABLE_100();
584: a15 := JTF_VARCHAR2_TABLE_100();
585: a16 := JTF_NUMBER_TABLE();
586: a17 := JTF_VARCHAR2_TABLE_100();
581: a12 := JTF_NUMBER_TABLE();
582: a13 := JTF_NUMBER_TABLE();
583: a14 := JTF_VARCHAR2_TABLE_100();
584: a15 := JTF_VARCHAR2_TABLE_100();
585: a16 := JTF_NUMBER_TABLE();
586: a17 := JTF_VARCHAR2_TABLE_100();
587: if t.count > 0 then
588: a0.extend(t.count);
589: a1.extend(t.count);
633: end if;
634: end if;
635: end rosetta_table_copy_out_p9;
636:
637: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
638: , a1 JTF_NUMBER_TABLE
639: , a2 JTF_NUMBER_TABLE
640: , a3 JTF_NUMBER_TABLE
641: ) as
634: end if;
635: end rosetta_table_copy_out_p9;
636:
637: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
638: , a1 JTF_NUMBER_TABLE
639: , a2 JTF_NUMBER_TABLE
640: , a3 JTF_NUMBER_TABLE
641: ) as
642: ddindx binary_integer; indx binary_integer;
635: end rosetta_table_copy_out_p9;
636:
637: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
638: , a1 JTF_NUMBER_TABLE
639: , a2 JTF_NUMBER_TABLE
640: , a3 JTF_NUMBER_TABLE
641: ) as
642: ddindx binary_integer; indx binary_integer;
643: begin
636:
637: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
638: , a1 JTF_NUMBER_TABLE
639: , a2 JTF_NUMBER_TABLE
640: , a3 JTF_NUMBER_TABLE
641: ) as
642: ddindx binary_integer; indx binary_integer;
643: begin
644: if a0 is not null and a0.count > 0 then
658: end loop;
659: end if;
660: end if;
661: end rosetta_table_copy_in_p11;
662: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
663: , a1 out nocopy JTF_NUMBER_TABLE
664: , a2 out nocopy JTF_NUMBER_TABLE
665: , a3 out nocopy JTF_NUMBER_TABLE
666: ) as
659: end if;
660: end if;
661: end rosetta_table_copy_in_p11;
662: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
663: , a1 out nocopy JTF_NUMBER_TABLE
664: , a2 out nocopy JTF_NUMBER_TABLE
665: , a3 out nocopy JTF_NUMBER_TABLE
666: ) as
667: ddindx binary_integer; indx binary_integer;
660: end if;
661: end rosetta_table_copy_in_p11;
662: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
663: , a1 out nocopy JTF_NUMBER_TABLE
664: , a2 out nocopy JTF_NUMBER_TABLE
665: , a3 out nocopy JTF_NUMBER_TABLE
666: ) as
667: ddindx binary_integer; indx binary_integer;
668: begin
661: end rosetta_table_copy_in_p11;
662: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
663: , a1 out nocopy JTF_NUMBER_TABLE
664: , a2 out nocopy JTF_NUMBER_TABLE
665: , a3 out nocopy JTF_NUMBER_TABLE
666: ) as
667: ddindx binary_integer; indx binary_integer;
668: begin
669: if t is null or t.count = 0 then
666: ) as
667: ddindx binary_integer; indx binary_integer;
668: begin
669: if t is null or t.count = 0 then
670: a0 := JTF_NUMBER_TABLE();
671: a1 := JTF_NUMBER_TABLE();
672: a2 := JTF_NUMBER_TABLE();
673: a3 := JTF_NUMBER_TABLE();
674: else
667: ddindx binary_integer; indx binary_integer;
668: begin
669: if t is null or t.count = 0 then
670: a0 := JTF_NUMBER_TABLE();
671: a1 := JTF_NUMBER_TABLE();
672: a2 := JTF_NUMBER_TABLE();
673: a3 := JTF_NUMBER_TABLE();
674: else
675: a0 := JTF_NUMBER_TABLE();
668: begin
669: if t is null or t.count = 0 then
670: a0 := JTF_NUMBER_TABLE();
671: a1 := JTF_NUMBER_TABLE();
672: a2 := JTF_NUMBER_TABLE();
673: a3 := JTF_NUMBER_TABLE();
674: else
675: a0 := JTF_NUMBER_TABLE();
676: a1 := JTF_NUMBER_TABLE();
669: if t is null or t.count = 0 then
670: a0 := JTF_NUMBER_TABLE();
671: a1 := JTF_NUMBER_TABLE();
672: a2 := JTF_NUMBER_TABLE();
673: a3 := JTF_NUMBER_TABLE();
674: else
675: a0 := JTF_NUMBER_TABLE();
676: a1 := JTF_NUMBER_TABLE();
677: a2 := JTF_NUMBER_TABLE();
671: a1 := JTF_NUMBER_TABLE();
672: a2 := JTF_NUMBER_TABLE();
673: a3 := JTF_NUMBER_TABLE();
674: else
675: a0 := JTF_NUMBER_TABLE();
676: a1 := JTF_NUMBER_TABLE();
677: a2 := JTF_NUMBER_TABLE();
678: a3 := JTF_NUMBER_TABLE();
679: if t.count > 0 then
672: a2 := JTF_NUMBER_TABLE();
673: a3 := JTF_NUMBER_TABLE();
674: else
675: a0 := JTF_NUMBER_TABLE();
676: a1 := JTF_NUMBER_TABLE();
677: a2 := JTF_NUMBER_TABLE();
678: a3 := JTF_NUMBER_TABLE();
679: if t.count > 0 then
680: a0.extend(t.count);
673: a3 := JTF_NUMBER_TABLE();
674: else
675: a0 := JTF_NUMBER_TABLE();
676: a1 := JTF_NUMBER_TABLE();
677: a2 := JTF_NUMBER_TABLE();
678: a3 := JTF_NUMBER_TABLE();
679: if t.count > 0 then
680: a0.extend(t.count);
681: a1.extend(t.count);
674: else
675: a0 := JTF_NUMBER_TABLE();
676: a1 := JTF_NUMBER_TABLE();
677: a2 := JTF_NUMBER_TABLE();
678: a3 := JTF_NUMBER_TABLE();
679: if t.count > 0 then
680: a0.extend(t.count);
681: a1.extend(t.count);
682: a2.extend(t.count);
705: , x_return_status out nocopy VARCHAR2
706: , x_msg_count out nocopy NUMBER
707: , x_msg_data out nocopy VARCHAR2
708: , p7_a0 JTF_VARCHAR2_TABLE_300
709: , p7_a1 JTF_NUMBER_TABLE
710: , p7_a2 JTF_NUMBER_TABLE
711: , p7_a3 JTF_NUMBER_TABLE
712: , p7_a4 JTF_NUMBER_TABLE
713: , p7_a5 JTF_VARCHAR2_TABLE_100
706: , x_msg_count out nocopy NUMBER
707: , x_msg_data out nocopy VARCHAR2
708: , p7_a0 JTF_VARCHAR2_TABLE_300
709: , p7_a1 JTF_NUMBER_TABLE
710: , p7_a2 JTF_NUMBER_TABLE
711: , p7_a3 JTF_NUMBER_TABLE
712: , p7_a4 JTF_NUMBER_TABLE
713: , p7_a5 JTF_VARCHAR2_TABLE_100
714: , p7_a6 JTF_NUMBER_TABLE
707: , x_msg_data out nocopy VARCHAR2
708: , p7_a0 JTF_VARCHAR2_TABLE_300
709: , p7_a1 JTF_NUMBER_TABLE
710: , p7_a2 JTF_NUMBER_TABLE
711: , p7_a3 JTF_NUMBER_TABLE
712: , p7_a4 JTF_NUMBER_TABLE
713: , p7_a5 JTF_VARCHAR2_TABLE_100
714: , p7_a6 JTF_NUMBER_TABLE
715: )
708: , p7_a0 JTF_VARCHAR2_TABLE_300
709: , p7_a1 JTF_NUMBER_TABLE
710: , p7_a2 JTF_NUMBER_TABLE
711: , p7_a3 JTF_NUMBER_TABLE
712: , p7_a4 JTF_NUMBER_TABLE
713: , p7_a5 JTF_VARCHAR2_TABLE_100
714: , p7_a6 JTF_NUMBER_TABLE
715: )
716:
710: , p7_a2 JTF_NUMBER_TABLE
711: , p7_a3 JTF_NUMBER_TABLE
712: , p7_a4 JTF_NUMBER_TABLE
713: , p7_a5 JTF_VARCHAR2_TABLE_100
714: , p7_a6 JTF_NUMBER_TABLE
715: )
716:
717: as
718: ddp_mv_txn_dtls_tbl csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type;
900: , p_validation_level NUMBER
901: , x_return_status out nocopy VARCHAR2
902: , x_msg_count out nocopy NUMBER
903: , x_msg_data out nocopy VARCHAR2
904: , p7_a0 JTF_NUMBER_TABLE
905: , p7_a1 JTF_NUMBER_TABLE
906: , p7_a2 JTF_NUMBER_TABLE
907: , p7_a3 JTF_NUMBER_TABLE
908: , p7_a4 JTF_NUMBER_TABLE
901: , x_return_status out nocopy VARCHAR2
902: , x_msg_count out nocopy NUMBER
903: , x_msg_data out nocopy VARCHAR2
904: , p7_a0 JTF_NUMBER_TABLE
905: , p7_a1 JTF_NUMBER_TABLE
906: , p7_a2 JTF_NUMBER_TABLE
907: , p7_a3 JTF_NUMBER_TABLE
908: , p7_a4 JTF_NUMBER_TABLE
909: , p7_a5 JTF_NUMBER_TABLE
902: , x_msg_count out nocopy NUMBER
903: , x_msg_data out nocopy VARCHAR2
904: , p7_a0 JTF_NUMBER_TABLE
905: , p7_a1 JTF_NUMBER_TABLE
906: , p7_a2 JTF_NUMBER_TABLE
907: , p7_a3 JTF_NUMBER_TABLE
908: , p7_a4 JTF_NUMBER_TABLE
909: , p7_a5 JTF_NUMBER_TABLE
910: , p7_a6 JTF_NUMBER_TABLE
903: , x_msg_data out nocopy VARCHAR2
904: , p7_a0 JTF_NUMBER_TABLE
905: , p7_a1 JTF_NUMBER_TABLE
906: , p7_a2 JTF_NUMBER_TABLE
907: , p7_a3 JTF_NUMBER_TABLE
908: , p7_a4 JTF_NUMBER_TABLE
909: , p7_a5 JTF_NUMBER_TABLE
910: , p7_a6 JTF_NUMBER_TABLE
911: , p7_a7 JTF_NUMBER_TABLE
904: , p7_a0 JTF_NUMBER_TABLE
905: , p7_a1 JTF_NUMBER_TABLE
906: , p7_a2 JTF_NUMBER_TABLE
907: , p7_a3 JTF_NUMBER_TABLE
908: , p7_a4 JTF_NUMBER_TABLE
909: , p7_a5 JTF_NUMBER_TABLE
910: , p7_a6 JTF_NUMBER_TABLE
911: , p7_a7 JTF_NUMBER_TABLE
912: , p7_a8 JTF_NUMBER_TABLE
905: , p7_a1 JTF_NUMBER_TABLE
906: , p7_a2 JTF_NUMBER_TABLE
907: , p7_a3 JTF_NUMBER_TABLE
908: , p7_a4 JTF_NUMBER_TABLE
909: , p7_a5 JTF_NUMBER_TABLE
910: , p7_a6 JTF_NUMBER_TABLE
911: , p7_a7 JTF_NUMBER_TABLE
912: , p7_a8 JTF_NUMBER_TABLE
913: , p7_a9 JTF_NUMBER_TABLE
906: , p7_a2 JTF_NUMBER_TABLE
907: , p7_a3 JTF_NUMBER_TABLE
908: , p7_a4 JTF_NUMBER_TABLE
909: , p7_a5 JTF_NUMBER_TABLE
910: , p7_a6 JTF_NUMBER_TABLE
911: , p7_a7 JTF_NUMBER_TABLE
912: , p7_a8 JTF_NUMBER_TABLE
913: , p7_a9 JTF_NUMBER_TABLE
914: , p7_a10 JTF_VARCHAR2_TABLE_100
907: , p7_a3 JTF_NUMBER_TABLE
908: , p7_a4 JTF_NUMBER_TABLE
909: , p7_a5 JTF_NUMBER_TABLE
910: , p7_a6 JTF_NUMBER_TABLE
911: , p7_a7 JTF_NUMBER_TABLE
912: , p7_a8 JTF_NUMBER_TABLE
913: , p7_a9 JTF_NUMBER_TABLE
914: , p7_a10 JTF_VARCHAR2_TABLE_100
915: , p7_a11 JTF_VARCHAR2_TABLE_100
908: , p7_a4 JTF_NUMBER_TABLE
909: , p7_a5 JTF_NUMBER_TABLE
910: , p7_a6 JTF_NUMBER_TABLE
911: , p7_a7 JTF_NUMBER_TABLE
912: , p7_a8 JTF_NUMBER_TABLE
913: , p7_a9 JTF_NUMBER_TABLE
914: , p7_a10 JTF_VARCHAR2_TABLE_100
915: , p7_a11 JTF_VARCHAR2_TABLE_100
916: , p7_a12 JTF_VARCHAR2_TABLE_100
909: , p7_a5 JTF_NUMBER_TABLE
910: , p7_a6 JTF_NUMBER_TABLE
911: , p7_a7 JTF_NUMBER_TABLE
912: , p7_a8 JTF_NUMBER_TABLE
913: , p7_a9 JTF_NUMBER_TABLE
914: , p7_a10 JTF_VARCHAR2_TABLE_100
915: , p7_a11 JTF_VARCHAR2_TABLE_100
916: , p7_a12 JTF_VARCHAR2_TABLE_100
917: , p7_a13 JTF_VARCHAR2_TABLE_100
915: , p7_a11 JTF_VARCHAR2_TABLE_100
916: , p7_a12 JTF_VARCHAR2_TABLE_100
917: , p7_a13 JTF_VARCHAR2_TABLE_100
918: , p7_a14 JTF_VARCHAR2_TABLE_100
919: , p7_a15 JTF_NUMBER_TABLE
920: , p7_a16 JTF_NUMBER_TABLE
921: , p7_a17 JTF_NUMBER_TABLE
922: , p7_a18 JTF_VARCHAR2_TABLE_100
923: , p7_a19 JTF_NUMBER_TABLE
916: , p7_a12 JTF_VARCHAR2_TABLE_100
917: , p7_a13 JTF_VARCHAR2_TABLE_100
918: , p7_a14 JTF_VARCHAR2_TABLE_100
919: , p7_a15 JTF_NUMBER_TABLE
920: , p7_a16 JTF_NUMBER_TABLE
921: , p7_a17 JTF_NUMBER_TABLE
922: , p7_a18 JTF_VARCHAR2_TABLE_100
923: , p7_a19 JTF_NUMBER_TABLE
924: , p7_a20 JTF_NUMBER_TABLE
917: , p7_a13 JTF_VARCHAR2_TABLE_100
918: , p7_a14 JTF_VARCHAR2_TABLE_100
919: , p7_a15 JTF_NUMBER_TABLE
920: , p7_a16 JTF_NUMBER_TABLE
921: , p7_a17 JTF_NUMBER_TABLE
922: , p7_a18 JTF_VARCHAR2_TABLE_100
923: , p7_a19 JTF_NUMBER_TABLE
924: , p7_a20 JTF_NUMBER_TABLE
925: , p7_a21 JTF_NUMBER_TABLE
919: , p7_a15 JTF_NUMBER_TABLE
920: , p7_a16 JTF_NUMBER_TABLE
921: , p7_a17 JTF_NUMBER_TABLE
922: , p7_a18 JTF_VARCHAR2_TABLE_100
923: , p7_a19 JTF_NUMBER_TABLE
924: , p7_a20 JTF_NUMBER_TABLE
925: , p7_a21 JTF_NUMBER_TABLE
926: , p7_a22 JTF_VARCHAR2_TABLE_100
927: , p7_a23 JTF_NUMBER_TABLE
920: , p7_a16 JTF_NUMBER_TABLE
921: , p7_a17 JTF_NUMBER_TABLE
922: , p7_a18 JTF_VARCHAR2_TABLE_100
923: , p7_a19 JTF_NUMBER_TABLE
924: , p7_a20 JTF_NUMBER_TABLE
925: , p7_a21 JTF_NUMBER_TABLE
926: , p7_a22 JTF_VARCHAR2_TABLE_100
927: , p7_a23 JTF_NUMBER_TABLE
928: , x_transaction_header_id out nocopy NUMBER
921: , p7_a17 JTF_NUMBER_TABLE
922: , p7_a18 JTF_VARCHAR2_TABLE_100
923: , p7_a19 JTF_NUMBER_TABLE
924: , p7_a20 JTF_NUMBER_TABLE
925: , p7_a21 JTF_NUMBER_TABLE
926: , p7_a22 JTF_VARCHAR2_TABLE_100
927: , p7_a23 JTF_NUMBER_TABLE
928: , x_transaction_header_id out nocopy NUMBER
929: )
923: , p7_a19 JTF_NUMBER_TABLE
924: , p7_a20 JTF_NUMBER_TABLE
925: , p7_a21 JTF_NUMBER_TABLE
926: , p7_a22 JTF_VARCHAR2_TABLE_100
927: , p7_a23 JTF_NUMBER_TABLE
928: , x_transaction_header_id out nocopy NUMBER
929: )
930:
931: as
996: , p_validation_level NUMBER
997: , x_return_status out nocopy VARCHAR2
998: , x_msg_count out nocopy NUMBER
999: , x_msg_data out nocopy VARCHAR2
1000: , p7_a0 JTF_NUMBER_TABLE
1001: , p7_a1 JTF_NUMBER_TABLE
1002: , p7_a2 JTF_NUMBER_TABLE
1003: , p7_a3 JTF_NUMBER_TABLE
1004: , p7_a4 JTF_NUMBER_TABLE
997: , x_return_status out nocopy VARCHAR2
998: , x_msg_count out nocopy NUMBER
999: , x_msg_data out nocopy VARCHAR2
1000: , p7_a0 JTF_NUMBER_TABLE
1001: , p7_a1 JTF_NUMBER_TABLE
1002: , p7_a2 JTF_NUMBER_TABLE
1003: , p7_a3 JTF_NUMBER_TABLE
1004: , p7_a4 JTF_NUMBER_TABLE
1005: , p7_a5 JTF_NUMBER_TABLE
998: , x_msg_count out nocopy NUMBER
999: , x_msg_data out nocopy VARCHAR2
1000: , p7_a0 JTF_NUMBER_TABLE
1001: , p7_a1 JTF_NUMBER_TABLE
1002: , p7_a2 JTF_NUMBER_TABLE
1003: , p7_a3 JTF_NUMBER_TABLE
1004: , p7_a4 JTF_NUMBER_TABLE
1005: , p7_a5 JTF_NUMBER_TABLE
1006: , p7_a6 JTF_NUMBER_TABLE
999: , x_msg_data out nocopy VARCHAR2
1000: , p7_a0 JTF_NUMBER_TABLE
1001: , p7_a1 JTF_NUMBER_TABLE
1002: , p7_a2 JTF_NUMBER_TABLE
1003: , p7_a3 JTF_NUMBER_TABLE
1004: , p7_a4 JTF_NUMBER_TABLE
1005: , p7_a5 JTF_NUMBER_TABLE
1006: , p7_a6 JTF_NUMBER_TABLE
1007: , p7_a7 JTF_NUMBER_TABLE
1000: , p7_a0 JTF_NUMBER_TABLE
1001: , p7_a1 JTF_NUMBER_TABLE
1002: , p7_a2 JTF_NUMBER_TABLE
1003: , p7_a3 JTF_NUMBER_TABLE
1004: , p7_a4 JTF_NUMBER_TABLE
1005: , p7_a5 JTF_NUMBER_TABLE
1006: , p7_a6 JTF_NUMBER_TABLE
1007: , p7_a7 JTF_NUMBER_TABLE
1008: , p7_a8 JTF_NUMBER_TABLE
1001: , p7_a1 JTF_NUMBER_TABLE
1002: , p7_a2 JTF_NUMBER_TABLE
1003: , p7_a3 JTF_NUMBER_TABLE
1004: , p7_a4 JTF_NUMBER_TABLE
1005: , p7_a5 JTF_NUMBER_TABLE
1006: , p7_a6 JTF_NUMBER_TABLE
1007: , p7_a7 JTF_NUMBER_TABLE
1008: , p7_a8 JTF_NUMBER_TABLE
1009: , p7_a9 JTF_NUMBER_TABLE
1002: , p7_a2 JTF_NUMBER_TABLE
1003: , p7_a3 JTF_NUMBER_TABLE
1004: , p7_a4 JTF_NUMBER_TABLE
1005: , p7_a5 JTF_NUMBER_TABLE
1006: , p7_a6 JTF_NUMBER_TABLE
1007: , p7_a7 JTF_NUMBER_TABLE
1008: , p7_a8 JTF_NUMBER_TABLE
1009: , p7_a9 JTF_NUMBER_TABLE
1010: , p7_a10 JTF_VARCHAR2_TABLE_100
1003: , p7_a3 JTF_NUMBER_TABLE
1004: , p7_a4 JTF_NUMBER_TABLE
1005: , p7_a5 JTF_NUMBER_TABLE
1006: , p7_a6 JTF_NUMBER_TABLE
1007: , p7_a7 JTF_NUMBER_TABLE
1008: , p7_a8 JTF_NUMBER_TABLE
1009: , p7_a9 JTF_NUMBER_TABLE
1010: , p7_a10 JTF_VARCHAR2_TABLE_100
1011: , p7_a11 JTF_VARCHAR2_TABLE_100
1004: , p7_a4 JTF_NUMBER_TABLE
1005: , p7_a5 JTF_NUMBER_TABLE
1006: , p7_a6 JTF_NUMBER_TABLE
1007: , p7_a7 JTF_NUMBER_TABLE
1008: , p7_a8 JTF_NUMBER_TABLE
1009: , p7_a9 JTF_NUMBER_TABLE
1010: , p7_a10 JTF_VARCHAR2_TABLE_100
1011: , p7_a11 JTF_VARCHAR2_TABLE_100
1012: , p7_a12 JTF_VARCHAR2_TABLE_100
1005: , p7_a5 JTF_NUMBER_TABLE
1006: , p7_a6 JTF_NUMBER_TABLE
1007: , p7_a7 JTF_NUMBER_TABLE
1008: , p7_a8 JTF_NUMBER_TABLE
1009: , p7_a9 JTF_NUMBER_TABLE
1010: , p7_a10 JTF_VARCHAR2_TABLE_100
1011: , p7_a11 JTF_VARCHAR2_TABLE_100
1012: , p7_a12 JTF_VARCHAR2_TABLE_100
1013: , p7_a13 JTF_VARCHAR2_TABLE_100
1011: , p7_a11 JTF_VARCHAR2_TABLE_100
1012: , p7_a12 JTF_VARCHAR2_TABLE_100
1013: , p7_a13 JTF_VARCHAR2_TABLE_100
1014: , p7_a14 JTF_VARCHAR2_TABLE_100
1015: , p7_a15 JTF_NUMBER_TABLE
1016: , p7_a16 JTF_NUMBER_TABLE
1017: , p7_a17 JTF_NUMBER_TABLE
1018: , p7_a18 JTF_VARCHAR2_TABLE_100
1019: , p7_a19 JTF_NUMBER_TABLE
1012: , p7_a12 JTF_VARCHAR2_TABLE_100
1013: , p7_a13 JTF_VARCHAR2_TABLE_100
1014: , p7_a14 JTF_VARCHAR2_TABLE_100
1015: , p7_a15 JTF_NUMBER_TABLE
1016: , p7_a16 JTF_NUMBER_TABLE
1017: , p7_a17 JTF_NUMBER_TABLE
1018: , p7_a18 JTF_VARCHAR2_TABLE_100
1019: , p7_a19 JTF_NUMBER_TABLE
1020: , p7_a20 JTF_NUMBER_TABLE
1013: , p7_a13 JTF_VARCHAR2_TABLE_100
1014: , p7_a14 JTF_VARCHAR2_TABLE_100
1015: , p7_a15 JTF_NUMBER_TABLE
1016: , p7_a16 JTF_NUMBER_TABLE
1017: , p7_a17 JTF_NUMBER_TABLE
1018: , p7_a18 JTF_VARCHAR2_TABLE_100
1019: , p7_a19 JTF_NUMBER_TABLE
1020: , p7_a20 JTF_NUMBER_TABLE
1021: , p7_a21 JTF_NUMBER_TABLE
1015: , p7_a15 JTF_NUMBER_TABLE
1016: , p7_a16 JTF_NUMBER_TABLE
1017: , p7_a17 JTF_NUMBER_TABLE
1018: , p7_a18 JTF_VARCHAR2_TABLE_100
1019: , p7_a19 JTF_NUMBER_TABLE
1020: , p7_a20 JTF_NUMBER_TABLE
1021: , p7_a21 JTF_NUMBER_TABLE
1022: , p7_a22 JTF_VARCHAR2_TABLE_100
1023: , p7_a23 JTF_NUMBER_TABLE
1016: , p7_a16 JTF_NUMBER_TABLE
1017: , p7_a17 JTF_NUMBER_TABLE
1018: , p7_a18 JTF_VARCHAR2_TABLE_100
1019: , p7_a19 JTF_NUMBER_TABLE
1020: , p7_a20 JTF_NUMBER_TABLE
1021: , p7_a21 JTF_NUMBER_TABLE
1022: , p7_a22 JTF_VARCHAR2_TABLE_100
1023: , p7_a23 JTF_NUMBER_TABLE
1024: , p_transaction_header_id NUMBER
1017: , p7_a17 JTF_NUMBER_TABLE
1018: , p7_a18 JTF_VARCHAR2_TABLE_100
1019: , p7_a19 JTF_NUMBER_TABLE
1020: , p7_a20 JTF_NUMBER_TABLE
1021: , p7_a21 JTF_NUMBER_TABLE
1022: , p7_a22 JTF_VARCHAR2_TABLE_100
1023: , p7_a23 JTF_NUMBER_TABLE
1024: , p_transaction_header_id NUMBER
1025: )
1019: , p7_a19 JTF_NUMBER_TABLE
1020: , p7_a20 JTF_NUMBER_TABLE
1021: , p7_a21 JTF_NUMBER_TABLE
1022: , p7_a22 JTF_VARCHAR2_TABLE_100
1023: , p7_a23 JTF_NUMBER_TABLE
1024: , p_transaction_header_id NUMBER
1025: )
1026:
1027: as
1092: , p_validation_level NUMBER
1093: , x_return_status out nocopy VARCHAR2
1094: , x_msg_count out nocopy NUMBER
1095: , x_msg_data out nocopy VARCHAR2
1096: , p7_a0 JTF_NUMBER_TABLE
1097: , p7_a1 JTF_NUMBER_TABLE
1098: , p7_a2 JTF_NUMBER_TABLE
1099: , p7_a3 JTF_NUMBER_TABLE
1100: , p7_a4 JTF_NUMBER_TABLE
1093: , x_return_status out nocopy VARCHAR2
1094: , x_msg_count out nocopy NUMBER
1095: , x_msg_data out nocopy VARCHAR2
1096: , p7_a0 JTF_NUMBER_TABLE
1097: , p7_a1 JTF_NUMBER_TABLE
1098: , p7_a2 JTF_NUMBER_TABLE
1099: , p7_a3 JTF_NUMBER_TABLE
1100: , p7_a4 JTF_NUMBER_TABLE
1101: , p7_a5 JTF_NUMBER_TABLE
1094: , x_msg_count out nocopy NUMBER
1095: , x_msg_data out nocopy VARCHAR2
1096: , p7_a0 JTF_NUMBER_TABLE
1097: , p7_a1 JTF_NUMBER_TABLE
1098: , p7_a2 JTF_NUMBER_TABLE
1099: , p7_a3 JTF_NUMBER_TABLE
1100: , p7_a4 JTF_NUMBER_TABLE
1101: , p7_a5 JTF_NUMBER_TABLE
1102: , p7_a6 JTF_NUMBER_TABLE
1095: , x_msg_data out nocopy VARCHAR2
1096: , p7_a0 JTF_NUMBER_TABLE
1097: , p7_a1 JTF_NUMBER_TABLE
1098: , p7_a2 JTF_NUMBER_TABLE
1099: , p7_a3 JTF_NUMBER_TABLE
1100: , p7_a4 JTF_NUMBER_TABLE
1101: , p7_a5 JTF_NUMBER_TABLE
1102: , p7_a6 JTF_NUMBER_TABLE
1103: , p7_a7 JTF_NUMBER_TABLE
1096: , p7_a0 JTF_NUMBER_TABLE
1097: , p7_a1 JTF_NUMBER_TABLE
1098: , p7_a2 JTF_NUMBER_TABLE
1099: , p7_a3 JTF_NUMBER_TABLE
1100: , p7_a4 JTF_NUMBER_TABLE
1101: , p7_a5 JTF_NUMBER_TABLE
1102: , p7_a6 JTF_NUMBER_TABLE
1103: , p7_a7 JTF_NUMBER_TABLE
1104: , p7_a8 JTF_NUMBER_TABLE
1097: , p7_a1 JTF_NUMBER_TABLE
1098: , p7_a2 JTF_NUMBER_TABLE
1099: , p7_a3 JTF_NUMBER_TABLE
1100: , p7_a4 JTF_NUMBER_TABLE
1101: , p7_a5 JTF_NUMBER_TABLE
1102: , p7_a6 JTF_NUMBER_TABLE
1103: , p7_a7 JTF_NUMBER_TABLE
1104: , p7_a8 JTF_NUMBER_TABLE
1105: , p7_a9 JTF_NUMBER_TABLE
1098: , p7_a2 JTF_NUMBER_TABLE
1099: , p7_a3 JTF_NUMBER_TABLE
1100: , p7_a4 JTF_NUMBER_TABLE
1101: , p7_a5 JTF_NUMBER_TABLE
1102: , p7_a6 JTF_NUMBER_TABLE
1103: , p7_a7 JTF_NUMBER_TABLE
1104: , p7_a8 JTF_NUMBER_TABLE
1105: , p7_a9 JTF_NUMBER_TABLE
1106: , p7_a10 JTF_VARCHAR2_TABLE_100
1099: , p7_a3 JTF_NUMBER_TABLE
1100: , p7_a4 JTF_NUMBER_TABLE
1101: , p7_a5 JTF_NUMBER_TABLE
1102: , p7_a6 JTF_NUMBER_TABLE
1103: , p7_a7 JTF_NUMBER_TABLE
1104: , p7_a8 JTF_NUMBER_TABLE
1105: , p7_a9 JTF_NUMBER_TABLE
1106: , p7_a10 JTF_VARCHAR2_TABLE_100
1107: , p7_a11 JTF_VARCHAR2_TABLE_100
1100: , p7_a4 JTF_NUMBER_TABLE
1101: , p7_a5 JTF_NUMBER_TABLE
1102: , p7_a6 JTF_NUMBER_TABLE
1103: , p7_a7 JTF_NUMBER_TABLE
1104: , p7_a8 JTF_NUMBER_TABLE
1105: , p7_a9 JTF_NUMBER_TABLE
1106: , p7_a10 JTF_VARCHAR2_TABLE_100
1107: , p7_a11 JTF_VARCHAR2_TABLE_100
1108: , p7_a12 JTF_VARCHAR2_TABLE_100
1101: , p7_a5 JTF_NUMBER_TABLE
1102: , p7_a6 JTF_NUMBER_TABLE
1103: , p7_a7 JTF_NUMBER_TABLE
1104: , p7_a8 JTF_NUMBER_TABLE
1105: , p7_a9 JTF_NUMBER_TABLE
1106: , p7_a10 JTF_VARCHAR2_TABLE_100
1107: , p7_a11 JTF_VARCHAR2_TABLE_100
1108: , p7_a12 JTF_VARCHAR2_TABLE_100
1109: , p7_a13 JTF_VARCHAR2_TABLE_100
1107: , p7_a11 JTF_VARCHAR2_TABLE_100
1108: , p7_a12 JTF_VARCHAR2_TABLE_100
1109: , p7_a13 JTF_VARCHAR2_TABLE_100
1110: , p7_a14 JTF_VARCHAR2_TABLE_100
1111: , p7_a15 JTF_NUMBER_TABLE
1112: , p7_a16 JTF_NUMBER_TABLE
1113: , p7_a17 JTF_NUMBER_TABLE
1114: , p7_a18 JTF_VARCHAR2_TABLE_100
1115: , p7_a19 JTF_NUMBER_TABLE
1108: , p7_a12 JTF_VARCHAR2_TABLE_100
1109: , p7_a13 JTF_VARCHAR2_TABLE_100
1110: , p7_a14 JTF_VARCHAR2_TABLE_100
1111: , p7_a15 JTF_NUMBER_TABLE
1112: , p7_a16 JTF_NUMBER_TABLE
1113: , p7_a17 JTF_NUMBER_TABLE
1114: , p7_a18 JTF_VARCHAR2_TABLE_100
1115: , p7_a19 JTF_NUMBER_TABLE
1116: , p7_a20 JTF_NUMBER_TABLE
1109: , p7_a13 JTF_VARCHAR2_TABLE_100
1110: , p7_a14 JTF_VARCHAR2_TABLE_100
1111: , p7_a15 JTF_NUMBER_TABLE
1112: , p7_a16 JTF_NUMBER_TABLE
1113: , p7_a17 JTF_NUMBER_TABLE
1114: , p7_a18 JTF_VARCHAR2_TABLE_100
1115: , p7_a19 JTF_NUMBER_TABLE
1116: , p7_a20 JTF_NUMBER_TABLE
1117: , p7_a21 JTF_NUMBER_TABLE
1111: , p7_a15 JTF_NUMBER_TABLE
1112: , p7_a16 JTF_NUMBER_TABLE
1113: , p7_a17 JTF_NUMBER_TABLE
1114: , p7_a18 JTF_VARCHAR2_TABLE_100
1115: , p7_a19 JTF_NUMBER_TABLE
1116: , p7_a20 JTF_NUMBER_TABLE
1117: , p7_a21 JTF_NUMBER_TABLE
1118: , p7_a22 JTF_VARCHAR2_TABLE_100
1119: , p7_a23 JTF_NUMBER_TABLE
1112: , p7_a16 JTF_NUMBER_TABLE
1113: , p7_a17 JTF_NUMBER_TABLE
1114: , p7_a18 JTF_VARCHAR2_TABLE_100
1115: , p7_a19 JTF_NUMBER_TABLE
1116: , p7_a20 JTF_NUMBER_TABLE
1117: , p7_a21 JTF_NUMBER_TABLE
1118: , p7_a22 JTF_VARCHAR2_TABLE_100
1119: , p7_a23 JTF_NUMBER_TABLE
1120: , p_transaction_header_id NUMBER
1113: , p7_a17 JTF_NUMBER_TABLE
1114: , p7_a18 JTF_VARCHAR2_TABLE_100
1115: , p7_a19 JTF_NUMBER_TABLE
1116: , p7_a20 JTF_NUMBER_TABLE
1117: , p7_a21 JTF_NUMBER_TABLE
1118: , p7_a22 JTF_VARCHAR2_TABLE_100
1119: , p7_a23 JTF_NUMBER_TABLE
1120: , p_transaction_header_id NUMBER
1121: )
1115: , p7_a19 JTF_NUMBER_TABLE
1116: , p7_a20 JTF_NUMBER_TABLE
1117: , p7_a21 JTF_NUMBER_TABLE
1118: , p7_a22 JTF_VARCHAR2_TABLE_100
1119: , p7_a23 JTF_NUMBER_TABLE
1120: , p_transaction_header_id NUMBER
1121: )
1122:
1123: as
1188: , p_validation_level NUMBER
1189: , x_return_status out nocopy VARCHAR2
1190: , x_msg_count out nocopy NUMBER
1191: , x_msg_data out nocopy VARCHAR2
1192: , p7_a0 JTF_NUMBER_TABLE
1193: , p7_a1 JTF_NUMBER_TABLE
1194: , p7_a2 JTF_NUMBER_TABLE
1195: , p7_a3 JTF_NUMBER_TABLE
1196: , p7_a4 JTF_NUMBER_TABLE
1189: , x_return_status out nocopy VARCHAR2
1190: , x_msg_count out nocopy NUMBER
1191: , x_msg_data out nocopy VARCHAR2
1192: , p7_a0 JTF_NUMBER_TABLE
1193: , p7_a1 JTF_NUMBER_TABLE
1194: , p7_a2 JTF_NUMBER_TABLE
1195: , p7_a3 JTF_NUMBER_TABLE
1196: , p7_a4 JTF_NUMBER_TABLE
1197: , p7_a5 JTF_NUMBER_TABLE
1190: , x_msg_count out nocopy NUMBER
1191: , x_msg_data out nocopy VARCHAR2
1192: , p7_a0 JTF_NUMBER_TABLE
1193: , p7_a1 JTF_NUMBER_TABLE
1194: , p7_a2 JTF_NUMBER_TABLE
1195: , p7_a3 JTF_NUMBER_TABLE
1196: , p7_a4 JTF_NUMBER_TABLE
1197: , p7_a5 JTF_NUMBER_TABLE
1198: , p7_a6 JTF_NUMBER_TABLE
1191: , x_msg_data out nocopy VARCHAR2
1192: , p7_a0 JTF_NUMBER_TABLE
1193: , p7_a1 JTF_NUMBER_TABLE
1194: , p7_a2 JTF_NUMBER_TABLE
1195: , p7_a3 JTF_NUMBER_TABLE
1196: , p7_a4 JTF_NUMBER_TABLE
1197: , p7_a5 JTF_NUMBER_TABLE
1198: , p7_a6 JTF_NUMBER_TABLE
1199: , p7_a7 JTF_NUMBER_TABLE
1192: , p7_a0 JTF_NUMBER_TABLE
1193: , p7_a1 JTF_NUMBER_TABLE
1194: , p7_a2 JTF_NUMBER_TABLE
1195: , p7_a3 JTF_NUMBER_TABLE
1196: , p7_a4 JTF_NUMBER_TABLE
1197: , p7_a5 JTF_NUMBER_TABLE
1198: , p7_a6 JTF_NUMBER_TABLE
1199: , p7_a7 JTF_NUMBER_TABLE
1200: , p7_a8 JTF_NUMBER_TABLE
1193: , p7_a1 JTF_NUMBER_TABLE
1194: , p7_a2 JTF_NUMBER_TABLE
1195: , p7_a3 JTF_NUMBER_TABLE
1196: , p7_a4 JTF_NUMBER_TABLE
1197: , p7_a5 JTF_NUMBER_TABLE
1198: , p7_a6 JTF_NUMBER_TABLE
1199: , p7_a7 JTF_NUMBER_TABLE
1200: , p7_a8 JTF_NUMBER_TABLE
1201: , p7_a9 JTF_NUMBER_TABLE
1194: , p7_a2 JTF_NUMBER_TABLE
1195: , p7_a3 JTF_NUMBER_TABLE
1196: , p7_a4 JTF_NUMBER_TABLE
1197: , p7_a5 JTF_NUMBER_TABLE
1198: , p7_a6 JTF_NUMBER_TABLE
1199: , p7_a7 JTF_NUMBER_TABLE
1200: , p7_a8 JTF_NUMBER_TABLE
1201: , p7_a9 JTF_NUMBER_TABLE
1202: , p7_a10 JTF_NUMBER_TABLE
1195: , p7_a3 JTF_NUMBER_TABLE
1196: , p7_a4 JTF_NUMBER_TABLE
1197: , p7_a5 JTF_NUMBER_TABLE
1198: , p7_a6 JTF_NUMBER_TABLE
1199: , p7_a7 JTF_NUMBER_TABLE
1200: , p7_a8 JTF_NUMBER_TABLE
1201: , p7_a9 JTF_NUMBER_TABLE
1202: , p7_a10 JTF_NUMBER_TABLE
1203: , p7_a11 JTF_VARCHAR2_TABLE_100
1196: , p7_a4 JTF_NUMBER_TABLE
1197: , p7_a5 JTF_NUMBER_TABLE
1198: , p7_a6 JTF_NUMBER_TABLE
1199: , p7_a7 JTF_NUMBER_TABLE
1200: , p7_a8 JTF_NUMBER_TABLE
1201: , p7_a9 JTF_NUMBER_TABLE
1202: , p7_a10 JTF_NUMBER_TABLE
1203: , p7_a11 JTF_VARCHAR2_TABLE_100
1204: , p7_a12 JTF_NUMBER_TABLE
1197: , p7_a5 JTF_NUMBER_TABLE
1198: , p7_a6 JTF_NUMBER_TABLE
1199: , p7_a7 JTF_NUMBER_TABLE
1200: , p7_a8 JTF_NUMBER_TABLE
1201: , p7_a9 JTF_NUMBER_TABLE
1202: , p7_a10 JTF_NUMBER_TABLE
1203: , p7_a11 JTF_VARCHAR2_TABLE_100
1204: , p7_a12 JTF_NUMBER_TABLE
1205: , p7_a13 JTF_NUMBER_TABLE
1198: , p7_a6 JTF_NUMBER_TABLE
1199: , p7_a7 JTF_NUMBER_TABLE
1200: , p7_a8 JTF_NUMBER_TABLE
1201: , p7_a9 JTF_NUMBER_TABLE
1202: , p7_a10 JTF_NUMBER_TABLE
1203: , p7_a11 JTF_VARCHAR2_TABLE_100
1204: , p7_a12 JTF_NUMBER_TABLE
1205: , p7_a13 JTF_NUMBER_TABLE
1206: , p7_a14 JTF_VARCHAR2_TABLE_100
1200: , p7_a8 JTF_NUMBER_TABLE
1201: , p7_a9 JTF_NUMBER_TABLE
1202: , p7_a10 JTF_NUMBER_TABLE
1203: , p7_a11 JTF_VARCHAR2_TABLE_100
1204: , p7_a12 JTF_NUMBER_TABLE
1205: , p7_a13 JTF_NUMBER_TABLE
1206: , p7_a14 JTF_VARCHAR2_TABLE_100
1207: , p7_a15 JTF_VARCHAR2_TABLE_100
1208: , p7_a16 JTF_VARCHAR2_TABLE_100
1201: , p7_a9 JTF_NUMBER_TABLE
1202: , p7_a10 JTF_NUMBER_TABLE
1203: , p7_a11 JTF_VARCHAR2_TABLE_100
1204: , p7_a12 JTF_NUMBER_TABLE
1205: , p7_a13 JTF_NUMBER_TABLE
1206: , p7_a14 JTF_VARCHAR2_TABLE_100
1207: , p7_a15 JTF_VARCHAR2_TABLE_100
1208: , p7_a16 JTF_VARCHAR2_TABLE_100
1209: , p7_a17 JTF_NUMBER_TABLE
1205: , p7_a13 JTF_NUMBER_TABLE
1206: , p7_a14 JTF_VARCHAR2_TABLE_100
1207: , p7_a15 JTF_VARCHAR2_TABLE_100
1208: , p7_a16 JTF_VARCHAR2_TABLE_100
1209: , p7_a17 JTF_NUMBER_TABLE
1210: , p7_a18 JTF_VARCHAR2_TABLE_100
1211: , p7_a19 JTF_NUMBER_TABLE
1212: , p7_a20 JTF_VARCHAR2_TABLE_100
1213: )
1207: , p7_a15 JTF_VARCHAR2_TABLE_100
1208: , p7_a16 JTF_VARCHAR2_TABLE_100
1209: , p7_a17 JTF_NUMBER_TABLE
1210: , p7_a18 JTF_VARCHAR2_TABLE_100
1211: , p7_a19 JTF_NUMBER_TABLE
1212: , p7_a20 JTF_VARCHAR2_TABLE_100
1213: )
1214:
1215: as
1274: , p_validation_level NUMBER
1275: , x_return_status out nocopy VARCHAR2
1276: , x_msg_count out nocopy NUMBER
1277: , x_msg_data out nocopy VARCHAR2
1278: , p7_a0 JTF_NUMBER_TABLE
1279: , p7_a1 JTF_NUMBER_TABLE
1280: , p7_a2 JTF_NUMBER_TABLE
1281: , p7_a3 JTF_NUMBER_TABLE
1282: , p7_a4 JTF_NUMBER_TABLE
1275: , x_return_status out nocopy VARCHAR2
1276: , x_msg_count out nocopy NUMBER
1277: , x_msg_data out nocopy VARCHAR2
1278: , p7_a0 JTF_NUMBER_TABLE
1279: , p7_a1 JTF_NUMBER_TABLE
1280: , p7_a2 JTF_NUMBER_TABLE
1281: , p7_a3 JTF_NUMBER_TABLE
1282: , p7_a4 JTF_NUMBER_TABLE
1283: , p7_a5 JTF_NUMBER_TABLE
1276: , x_msg_count out nocopy NUMBER
1277: , x_msg_data out nocopy VARCHAR2
1278: , p7_a0 JTF_NUMBER_TABLE
1279: , p7_a1 JTF_NUMBER_TABLE
1280: , p7_a2 JTF_NUMBER_TABLE
1281: , p7_a3 JTF_NUMBER_TABLE
1282: , p7_a4 JTF_NUMBER_TABLE
1283: , p7_a5 JTF_NUMBER_TABLE
1284: , p7_a6 JTF_NUMBER_TABLE
1277: , x_msg_data out nocopy VARCHAR2
1278: , p7_a0 JTF_NUMBER_TABLE
1279: , p7_a1 JTF_NUMBER_TABLE
1280: , p7_a2 JTF_NUMBER_TABLE
1281: , p7_a3 JTF_NUMBER_TABLE
1282: , p7_a4 JTF_NUMBER_TABLE
1283: , p7_a5 JTF_NUMBER_TABLE
1284: , p7_a6 JTF_NUMBER_TABLE
1285: , p7_a7 JTF_NUMBER_TABLE
1278: , p7_a0 JTF_NUMBER_TABLE
1279: , p7_a1 JTF_NUMBER_TABLE
1280: , p7_a2 JTF_NUMBER_TABLE
1281: , p7_a3 JTF_NUMBER_TABLE
1282: , p7_a4 JTF_NUMBER_TABLE
1283: , p7_a5 JTF_NUMBER_TABLE
1284: , p7_a6 JTF_NUMBER_TABLE
1285: , p7_a7 JTF_NUMBER_TABLE
1286: , p7_a8 JTF_NUMBER_TABLE
1279: , p7_a1 JTF_NUMBER_TABLE
1280: , p7_a2 JTF_NUMBER_TABLE
1281: , p7_a3 JTF_NUMBER_TABLE
1282: , p7_a4 JTF_NUMBER_TABLE
1283: , p7_a5 JTF_NUMBER_TABLE
1284: , p7_a6 JTF_NUMBER_TABLE
1285: , p7_a7 JTF_NUMBER_TABLE
1286: , p7_a8 JTF_NUMBER_TABLE
1287: , p7_a9 JTF_NUMBER_TABLE
1280: , p7_a2 JTF_NUMBER_TABLE
1281: , p7_a3 JTF_NUMBER_TABLE
1282: , p7_a4 JTF_NUMBER_TABLE
1283: , p7_a5 JTF_NUMBER_TABLE
1284: , p7_a6 JTF_NUMBER_TABLE
1285: , p7_a7 JTF_NUMBER_TABLE
1286: , p7_a8 JTF_NUMBER_TABLE
1287: , p7_a9 JTF_NUMBER_TABLE
1288: , p7_a10 JTF_VARCHAR2_TABLE_100
1281: , p7_a3 JTF_NUMBER_TABLE
1282: , p7_a4 JTF_NUMBER_TABLE
1283: , p7_a5 JTF_NUMBER_TABLE
1284: , p7_a6 JTF_NUMBER_TABLE
1285: , p7_a7 JTF_NUMBER_TABLE
1286: , p7_a8 JTF_NUMBER_TABLE
1287: , p7_a9 JTF_NUMBER_TABLE
1288: , p7_a10 JTF_VARCHAR2_TABLE_100
1289: , p7_a11 JTF_VARCHAR2_TABLE_100
1282: , p7_a4 JTF_NUMBER_TABLE
1283: , p7_a5 JTF_NUMBER_TABLE
1284: , p7_a6 JTF_NUMBER_TABLE
1285: , p7_a7 JTF_NUMBER_TABLE
1286: , p7_a8 JTF_NUMBER_TABLE
1287: , p7_a9 JTF_NUMBER_TABLE
1288: , p7_a10 JTF_VARCHAR2_TABLE_100
1289: , p7_a11 JTF_VARCHAR2_TABLE_100
1290: , p7_a12 JTF_VARCHAR2_TABLE_100
1283: , p7_a5 JTF_NUMBER_TABLE
1284: , p7_a6 JTF_NUMBER_TABLE
1285: , p7_a7 JTF_NUMBER_TABLE
1286: , p7_a8 JTF_NUMBER_TABLE
1287: , p7_a9 JTF_NUMBER_TABLE
1288: , p7_a10 JTF_VARCHAR2_TABLE_100
1289: , p7_a11 JTF_VARCHAR2_TABLE_100
1290: , p7_a12 JTF_VARCHAR2_TABLE_100
1291: , p7_a13 JTF_VARCHAR2_TABLE_100
1289: , p7_a11 JTF_VARCHAR2_TABLE_100
1290: , p7_a12 JTF_VARCHAR2_TABLE_100
1291: , p7_a13 JTF_VARCHAR2_TABLE_100
1292: , p7_a14 JTF_VARCHAR2_TABLE_100
1293: , p7_a15 JTF_NUMBER_TABLE
1294: , p7_a16 JTF_NUMBER_TABLE
1295: , p7_a17 JTF_NUMBER_TABLE
1296: , p7_a18 JTF_VARCHAR2_TABLE_100
1297: , p7_a19 JTF_NUMBER_TABLE
1290: , p7_a12 JTF_VARCHAR2_TABLE_100
1291: , p7_a13 JTF_VARCHAR2_TABLE_100
1292: , p7_a14 JTF_VARCHAR2_TABLE_100
1293: , p7_a15 JTF_NUMBER_TABLE
1294: , p7_a16 JTF_NUMBER_TABLE
1295: , p7_a17 JTF_NUMBER_TABLE
1296: , p7_a18 JTF_VARCHAR2_TABLE_100
1297: , p7_a19 JTF_NUMBER_TABLE
1298: , p7_a20 JTF_NUMBER_TABLE
1291: , p7_a13 JTF_VARCHAR2_TABLE_100
1292: , p7_a14 JTF_VARCHAR2_TABLE_100
1293: , p7_a15 JTF_NUMBER_TABLE
1294: , p7_a16 JTF_NUMBER_TABLE
1295: , p7_a17 JTF_NUMBER_TABLE
1296: , p7_a18 JTF_VARCHAR2_TABLE_100
1297: , p7_a19 JTF_NUMBER_TABLE
1298: , p7_a20 JTF_NUMBER_TABLE
1299: , p7_a21 JTF_NUMBER_TABLE
1293: , p7_a15 JTF_NUMBER_TABLE
1294: , p7_a16 JTF_NUMBER_TABLE
1295: , p7_a17 JTF_NUMBER_TABLE
1296: , p7_a18 JTF_VARCHAR2_TABLE_100
1297: , p7_a19 JTF_NUMBER_TABLE
1298: , p7_a20 JTF_NUMBER_TABLE
1299: , p7_a21 JTF_NUMBER_TABLE
1300: , p7_a22 JTF_VARCHAR2_TABLE_100
1301: , p7_a23 JTF_NUMBER_TABLE
1294: , p7_a16 JTF_NUMBER_TABLE
1295: , p7_a17 JTF_NUMBER_TABLE
1296: , p7_a18 JTF_VARCHAR2_TABLE_100
1297: , p7_a19 JTF_NUMBER_TABLE
1298: , p7_a20 JTF_NUMBER_TABLE
1299: , p7_a21 JTF_NUMBER_TABLE
1300: , p7_a22 JTF_VARCHAR2_TABLE_100
1301: , p7_a23 JTF_NUMBER_TABLE
1302: , x_op_created out nocopy VARCHAR
1295: , p7_a17 JTF_NUMBER_TABLE
1296: , p7_a18 JTF_VARCHAR2_TABLE_100
1297: , p7_a19 JTF_NUMBER_TABLE
1298: , p7_a20 JTF_NUMBER_TABLE
1299: , p7_a21 JTF_NUMBER_TABLE
1300: , p7_a22 JTF_VARCHAR2_TABLE_100
1301: , p7_a23 JTF_NUMBER_TABLE
1302: , x_op_created out nocopy VARCHAR
1303: )
1297: , p7_a19 JTF_NUMBER_TABLE
1298: , p7_a20 JTF_NUMBER_TABLE
1299: , p7_a21 JTF_NUMBER_TABLE
1300: , p7_a22 JTF_VARCHAR2_TABLE_100
1301: , p7_a23 JTF_NUMBER_TABLE
1302: , x_op_created out nocopy VARCHAR
1303: )
1304:
1305: as
1370: , p_validation_level NUMBER
1371: , x_return_status out nocopy VARCHAR2
1372: , x_msg_count out nocopy NUMBER
1373: , x_msg_data out nocopy VARCHAR2
1374: , p7_a0 JTF_NUMBER_TABLE
1375: , p7_a1 JTF_NUMBER_TABLE
1376: , p7_a2 JTF_NUMBER_TABLE
1377: , p7_a3 JTF_NUMBER_TABLE
1378: , p7_a4 JTF_NUMBER_TABLE
1371: , x_return_status out nocopy VARCHAR2
1372: , x_msg_count out nocopy NUMBER
1373: , x_msg_data out nocopy VARCHAR2
1374: , p7_a0 JTF_NUMBER_TABLE
1375: , p7_a1 JTF_NUMBER_TABLE
1376: , p7_a2 JTF_NUMBER_TABLE
1377: , p7_a3 JTF_NUMBER_TABLE
1378: , p7_a4 JTF_NUMBER_TABLE
1379: , p7_a5 JTF_NUMBER_TABLE
1372: , x_msg_count out nocopy NUMBER
1373: , x_msg_data out nocopy VARCHAR2
1374: , p7_a0 JTF_NUMBER_TABLE
1375: , p7_a1 JTF_NUMBER_TABLE
1376: , p7_a2 JTF_NUMBER_TABLE
1377: , p7_a3 JTF_NUMBER_TABLE
1378: , p7_a4 JTF_NUMBER_TABLE
1379: , p7_a5 JTF_NUMBER_TABLE
1380: , p7_a6 JTF_NUMBER_TABLE
1373: , x_msg_data out nocopy VARCHAR2
1374: , p7_a0 JTF_NUMBER_TABLE
1375: , p7_a1 JTF_NUMBER_TABLE
1376: , p7_a2 JTF_NUMBER_TABLE
1377: , p7_a3 JTF_NUMBER_TABLE
1378: , p7_a4 JTF_NUMBER_TABLE
1379: , p7_a5 JTF_NUMBER_TABLE
1380: , p7_a6 JTF_NUMBER_TABLE
1381: , p7_a7 JTF_NUMBER_TABLE
1374: , p7_a0 JTF_NUMBER_TABLE
1375: , p7_a1 JTF_NUMBER_TABLE
1376: , p7_a2 JTF_NUMBER_TABLE
1377: , p7_a3 JTF_NUMBER_TABLE
1378: , p7_a4 JTF_NUMBER_TABLE
1379: , p7_a5 JTF_NUMBER_TABLE
1380: , p7_a6 JTF_NUMBER_TABLE
1381: , p7_a7 JTF_NUMBER_TABLE
1382: , p7_a8 JTF_NUMBER_TABLE
1375: , p7_a1 JTF_NUMBER_TABLE
1376: , p7_a2 JTF_NUMBER_TABLE
1377: , p7_a3 JTF_NUMBER_TABLE
1378: , p7_a4 JTF_NUMBER_TABLE
1379: , p7_a5 JTF_NUMBER_TABLE
1380: , p7_a6 JTF_NUMBER_TABLE
1381: , p7_a7 JTF_NUMBER_TABLE
1382: , p7_a8 JTF_NUMBER_TABLE
1383: , p7_a9 JTF_NUMBER_TABLE
1376: , p7_a2 JTF_NUMBER_TABLE
1377: , p7_a3 JTF_NUMBER_TABLE
1378: , p7_a4 JTF_NUMBER_TABLE
1379: , p7_a5 JTF_NUMBER_TABLE
1380: , p7_a6 JTF_NUMBER_TABLE
1381: , p7_a7 JTF_NUMBER_TABLE
1382: , p7_a8 JTF_NUMBER_TABLE
1383: , p7_a9 JTF_NUMBER_TABLE
1384: , p7_a10 JTF_NUMBER_TABLE
1377: , p7_a3 JTF_NUMBER_TABLE
1378: , p7_a4 JTF_NUMBER_TABLE
1379: , p7_a5 JTF_NUMBER_TABLE
1380: , p7_a6 JTF_NUMBER_TABLE
1381: , p7_a7 JTF_NUMBER_TABLE
1382: , p7_a8 JTF_NUMBER_TABLE
1383: , p7_a9 JTF_NUMBER_TABLE
1384: , p7_a10 JTF_NUMBER_TABLE
1385: , p7_a11 JTF_VARCHAR2_TABLE_100
1378: , p7_a4 JTF_NUMBER_TABLE
1379: , p7_a5 JTF_NUMBER_TABLE
1380: , p7_a6 JTF_NUMBER_TABLE
1381: , p7_a7 JTF_NUMBER_TABLE
1382: , p7_a8 JTF_NUMBER_TABLE
1383: , p7_a9 JTF_NUMBER_TABLE
1384: , p7_a10 JTF_NUMBER_TABLE
1385: , p7_a11 JTF_VARCHAR2_TABLE_100
1386: , p7_a12 JTF_NUMBER_TABLE
1379: , p7_a5 JTF_NUMBER_TABLE
1380: , p7_a6 JTF_NUMBER_TABLE
1381: , p7_a7 JTF_NUMBER_TABLE
1382: , p7_a8 JTF_NUMBER_TABLE
1383: , p7_a9 JTF_NUMBER_TABLE
1384: , p7_a10 JTF_NUMBER_TABLE
1385: , p7_a11 JTF_VARCHAR2_TABLE_100
1386: , p7_a12 JTF_NUMBER_TABLE
1387: , p7_a13 JTF_NUMBER_TABLE
1380: , p7_a6 JTF_NUMBER_TABLE
1381: , p7_a7 JTF_NUMBER_TABLE
1382: , p7_a8 JTF_NUMBER_TABLE
1383: , p7_a9 JTF_NUMBER_TABLE
1384: , p7_a10 JTF_NUMBER_TABLE
1385: , p7_a11 JTF_VARCHAR2_TABLE_100
1386: , p7_a12 JTF_NUMBER_TABLE
1387: , p7_a13 JTF_NUMBER_TABLE
1388: , p7_a14 JTF_VARCHAR2_TABLE_100
1382: , p7_a8 JTF_NUMBER_TABLE
1383: , p7_a9 JTF_NUMBER_TABLE
1384: , p7_a10 JTF_NUMBER_TABLE
1385: , p7_a11 JTF_VARCHAR2_TABLE_100
1386: , p7_a12 JTF_NUMBER_TABLE
1387: , p7_a13 JTF_NUMBER_TABLE
1388: , p7_a14 JTF_VARCHAR2_TABLE_100
1389: , p7_a15 JTF_VARCHAR2_TABLE_100
1390: , p7_a16 JTF_VARCHAR2_TABLE_100
1383: , p7_a9 JTF_NUMBER_TABLE
1384: , p7_a10 JTF_NUMBER_TABLE
1385: , p7_a11 JTF_VARCHAR2_TABLE_100
1386: , p7_a12 JTF_NUMBER_TABLE
1387: , p7_a13 JTF_NUMBER_TABLE
1388: , p7_a14 JTF_VARCHAR2_TABLE_100
1389: , p7_a15 JTF_VARCHAR2_TABLE_100
1390: , p7_a16 JTF_VARCHAR2_TABLE_100
1391: , p7_a17 JTF_NUMBER_TABLE
1387: , p7_a13 JTF_NUMBER_TABLE
1388: , p7_a14 JTF_VARCHAR2_TABLE_100
1389: , p7_a15 JTF_VARCHAR2_TABLE_100
1390: , p7_a16 JTF_VARCHAR2_TABLE_100
1391: , p7_a17 JTF_NUMBER_TABLE
1392: , p7_a18 JTF_VARCHAR2_TABLE_100
1393: , p7_a19 JTF_NUMBER_TABLE
1394: , p7_a20 JTF_VARCHAR2_TABLE_100
1395: )
1389: , p7_a15 JTF_VARCHAR2_TABLE_100
1390: , p7_a16 JTF_VARCHAR2_TABLE_100
1391: , p7_a17 JTF_NUMBER_TABLE
1392: , p7_a18 JTF_VARCHAR2_TABLE_100
1393: , p7_a19 JTF_NUMBER_TABLE
1394: , p7_a20 JTF_VARCHAR2_TABLE_100
1395: )
1396:
1397: as
1456: , p_validation_level NUMBER
1457: , x_return_status out nocopy VARCHAR2
1458: , x_msg_count out nocopy NUMBER
1459: , x_msg_data out nocopy VARCHAR2
1460: , p7_a0 JTF_NUMBER_TABLE
1461: , p7_a1 JTF_NUMBER_TABLE
1462: , p7_a2 JTF_NUMBER_TABLE
1463: , p7_a3 JTF_NUMBER_TABLE
1464: , p7_a4 JTF_VARCHAR2_TABLE_300
1457: , x_return_status out nocopy VARCHAR2
1458: , x_msg_count out nocopy NUMBER
1459: , x_msg_data out nocopy VARCHAR2
1460: , p7_a0 JTF_NUMBER_TABLE
1461: , p7_a1 JTF_NUMBER_TABLE
1462: , p7_a2 JTF_NUMBER_TABLE
1463: , p7_a3 JTF_NUMBER_TABLE
1464: , p7_a4 JTF_VARCHAR2_TABLE_300
1465: , p7_a5 JTF_DATE_TABLE
1458: , x_msg_count out nocopy NUMBER
1459: , x_msg_data out nocopy VARCHAR2
1460: , p7_a0 JTF_NUMBER_TABLE
1461: , p7_a1 JTF_NUMBER_TABLE
1462: , p7_a2 JTF_NUMBER_TABLE
1463: , p7_a3 JTF_NUMBER_TABLE
1464: , p7_a4 JTF_VARCHAR2_TABLE_300
1465: , p7_a5 JTF_DATE_TABLE
1466: , p7_a6 JTF_DATE_TABLE
1459: , x_msg_data out nocopy VARCHAR2
1460: , p7_a0 JTF_NUMBER_TABLE
1461: , p7_a1 JTF_NUMBER_TABLE
1462: , p7_a2 JTF_NUMBER_TABLE
1463: , p7_a3 JTF_NUMBER_TABLE
1464: , p7_a4 JTF_VARCHAR2_TABLE_300
1465: , p7_a5 JTF_DATE_TABLE
1466: , p7_a6 JTF_DATE_TABLE
1467: , p7_a7 JTF_DATE_TABLE
1465: , p7_a5 JTF_DATE_TABLE
1466: , p7_a6 JTF_DATE_TABLE
1467: , p7_a7 JTF_DATE_TABLE
1468: , p7_a8 JTF_DATE_TABLE
1469: , p7_a9 JTF_NUMBER_TABLE
1470: , p7_a10 JTF_NUMBER_TABLE
1471: , p7_a11 JTF_NUMBER_TABLE
1472: , p7_a12 JTF_NUMBER_TABLE
1473: , p7_a13 JTF_NUMBER_TABLE
1466: , p7_a6 JTF_DATE_TABLE
1467: , p7_a7 JTF_DATE_TABLE
1468: , p7_a8 JTF_DATE_TABLE
1469: , p7_a9 JTF_NUMBER_TABLE
1470: , p7_a10 JTF_NUMBER_TABLE
1471: , p7_a11 JTF_NUMBER_TABLE
1472: , p7_a12 JTF_NUMBER_TABLE
1473: , p7_a13 JTF_NUMBER_TABLE
1474: , p7_a14 JTF_VARCHAR2_TABLE_100
1467: , p7_a7 JTF_DATE_TABLE
1468: , p7_a8 JTF_DATE_TABLE
1469: , p7_a9 JTF_NUMBER_TABLE
1470: , p7_a10 JTF_NUMBER_TABLE
1471: , p7_a11 JTF_NUMBER_TABLE
1472: , p7_a12 JTF_NUMBER_TABLE
1473: , p7_a13 JTF_NUMBER_TABLE
1474: , p7_a14 JTF_VARCHAR2_TABLE_100
1475: , p7_a15 JTF_VARCHAR2_TABLE_100
1468: , p7_a8 JTF_DATE_TABLE
1469: , p7_a9 JTF_NUMBER_TABLE
1470: , p7_a10 JTF_NUMBER_TABLE
1471: , p7_a11 JTF_NUMBER_TABLE
1472: , p7_a12 JTF_NUMBER_TABLE
1473: , p7_a13 JTF_NUMBER_TABLE
1474: , p7_a14 JTF_VARCHAR2_TABLE_100
1475: , p7_a15 JTF_VARCHAR2_TABLE_100
1476: , p7_a16 JTF_NUMBER_TABLE
1469: , p7_a9 JTF_NUMBER_TABLE
1470: , p7_a10 JTF_NUMBER_TABLE
1471: , p7_a11 JTF_NUMBER_TABLE
1472: , p7_a12 JTF_NUMBER_TABLE
1473: , p7_a13 JTF_NUMBER_TABLE
1474: , p7_a14 JTF_VARCHAR2_TABLE_100
1475: , p7_a15 JTF_VARCHAR2_TABLE_100
1476: , p7_a16 JTF_NUMBER_TABLE
1477: , p7_a17 JTF_VARCHAR2_TABLE_100
1472: , p7_a12 JTF_NUMBER_TABLE
1473: , p7_a13 JTF_NUMBER_TABLE
1474: , p7_a14 JTF_VARCHAR2_TABLE_100
1475: , p7_a15 JTF_VARCHAR2_TABLE_100
1476: , p7_a16 JTF_NUMBER_TABLE
1477: , p7_a17 JTF_VARCHAR2_TABLE_100
1478: )
1479:
1480: as
1538: , x_msg_count out nocopy NUMBER
1539: , x_msg_data out nocopy VARCHAR2
1540: , p_repair_line_id NUMBER
1541: , p_repair_quantity NUMBER
1542: , p9_a0 JTF_NUMBER_TABLE
1543: , p9_a1 JTF_NUMBER_TABLE
1544: , p9_a2 JTF_NUMBER_TABLE
1545: , p9_a3 JTF_NUMBER_TABLE
1546: )
1539: , x_msg_data out nocopy VARCHAR2
1540: , p_repair_line_id NUMBER
1541: , p_repair_quantity NUMBER
1542: , p9_a0 JTF_NUMBER_TABLE
1543: , p9_a1 JTF_NUMBER_TABLE
1544: , p9_a2 JTF_NUMBER_TABLE
1545: , p9_a3 JTF_NUMBER_TABLE
1546: )
1547:
1540: , p_repair_line_id NUMBER
1541: , p_repair_quantity NUMBER
1542: , p9_a0 JTF_NUMBER_TABLE
1543: , p9_a1 JTF_NUMBER_TABLE
1544: , p9_a2 JTF_NUMBER_TABLE
1545: , p9_a3 JTF_NUMBER_TABLE
1546: )
1547:
1548: as
1541: , p_repair_quantity NUMBER
1542: , p9_a0 JTF_NUMBER_TABLE
1543: , p9_a1 JTF_NUMBER_TABLE
1544: , p9_a2 JTF_NUMBER_TABLE
1545: , p9_a3 JTF_NUMBER_TABLE
1546: )
1547:
1548: as
1549: ddp_service_code_tbl csd_hv_wip_job_pvt.service_code_tbl_type;