18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sxp_pvt.sxp_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sxp_pvt.sxp_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sxp_pvt.sxp_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sxp_pvt.sxp_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: ) as
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin
39: if a0 is not null and a0.count > 0 then
63: end loop;
64: end if;
65: end if;
66: end rosetta_table_copy_in_p2;
67: procedure rosetta_table_copy_out_p2(t okl_sxp_pvt.sxp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_VARCHAR2_TABLE_300
71: , a4 out nocopy JTF_NUMBER_TABLE
64: end if;
65: end if;
66: end rosetta_table_copy_in_p2;
67: procedure rosetta_table_copy_out_p2(t okl_sxp_pvt.sxp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_VARCHAR2_TABLE_300
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
65: end if;
66: end rosetta_table_copy_in_p2;
67: procedure rosetta_table_copy_out_p2(t okl_sxp_pvt.sxp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_VARCHAR2_TABLE_300
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
67: procedure rosetta_table_copy_out_p2(t okl_sxp_pvt.sxp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_VARCHAR2_TABLE_300
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_VARCHAR2_TABLE_300
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_NUMBER_TABLE
76: , a9 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_VARCHAR2_TABLE_300
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_NUMBER_TABLE
76: , a9 out nocopy JTF_NUMBER_TABLE
77: , a10 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_VARCHAR2_TABLE_300
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_NUMBER_TABLE
76: , a9 out nocopy JTF_NUMBER_TABLE
77: , a10 out nocopy JTF_NUMBER_TABLE
78: , a11 out nocopy JTF_DATE_TABLE
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_NUMBER_TABLE
76: , a9 out nocopy JTF_NUMBER_TABLE
77: , a10 out nocopy JTF_NUMBER_TABLE
78: , a11 out nocopy JTF_DATE_TABLE
79: , a12 out nocopy JTF_DATE_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_NUMBER_TABLE
76: , a9 out nocopy JTF_NUMBER_TABLE
77: , a10 out nocopy JTF_NUMBER_TABLE
78: , a11 out nocopy JTF_DATE_TABLE
79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_NUMBER_TABLE
76: , a9 out nocopy JTF_NUMBER_TABLE
77: , a10 out nocopy JTF_NUMBER_TABLE
78: , a11 out nocopy JTF_DATE_TABLE
79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_NUMBER_TABLE
81: ) as
76: , a9 out nocopy JTF_NUMBER_TABLE
77: , a10 out nocopy JTF_NUMBER_TABLE
78: , a11 out nocopy JTF_DATE_TABLE
79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_NUMBER_TABLE
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_NUMBER_TABLE();
87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_VARCHAR2_TABLE_300();
89: a4 := JTF_NUMBER_TABLE();
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_NUMBER_TABLE();
87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_VARCHAR2_TABLE_300();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_NUMBER_TABLE();
87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_VARCHAR2_TABLE_300();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_NUMBER_TABLE();
87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_VARCHAR2_TABLE_300();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_NUMBER_TABLE();
86: a1 := JTF_NUMBER_TABLE();
87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_VARCHAR2_TABLE_300();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_NUMBER_TABLE();
94: a9 := JTF_NUMBER_TABLE();
87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_VARCHAR2_TABLE_300();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_NUMBER_TABLE();
94: a9 := JTF_NUMBER_TABLE();
95: a10 := JTF_NUMBER_TABLE();
88: a3 := JTF_VARCHAR2_TABLE_300();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_NUMBER_TABLE();
94: a9 := JTF_NUMBER_TABLE();
95: a10 := JTF_NUMBER_TABLE();
96: a11 := JTF_DATE_TABLE();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_NUMBER_TABLE();
94: a9 := JTF_NUMBER_TABLE();
95: a10 := JTF_NUMBER_TABLE();
96: a11 := JTF_DATE_TABLE();
97: a12 := JTF_DATE_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_NUMBER_TABLE();
94: a9 := JTF_NUMBER_TABLE();
95: a10 := JTF_NUMBER_TABLE();
96: a11 := JTF_DATE_TABLE();
97: a12 := JTF_DATE_TABLE();
98: a13 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_NUMBER_TABLE();
94: a9 := JTF_NUMBER_TABLE();
95: a10 := JTF_NUMBER_TABLE();
96: a11 := JTF_DATE_TABLE();
97: a12 := JTF_DATE_TABLE();
98: a13 := JTF_NUMBER_TABLE();
99: else
94: a9 := JTF_NUMBER_TABLE();
95: a10 := JTF_NUMBER_TABLE();
96: a11 := JTF_DATE_TABLE();
97: a12 := JTF_DATE_TABLE();
98: a13 := JTF_NUMBER_TABLE();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
96: a11 := JTF_DATE_TABLE();
97: a12 := JTF_DATE_TABLE();
98: a13 := JTF_NUMBER_TABLE();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_300();
104: a4 := JTF_NUMBER_TABLE();
97: a12 := JTF_DATE_TABLE();
98: a13 := JTF_NUMBER_TABLE();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_300();
104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_NUMBER_TABLE();
98: a13 := JTF_NUMBER_TABLE();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_300();
104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_300();
104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_300();
104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_NUMBER_TABLE();
109: a9 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_300();
104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_NUMBER_TABLE();
109: a9 := JTF_NUMBER_TABLE();
110: a10 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_300();
104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_NUMBER_TABLE();
109: a9 := JTF_NUMBER_TABLE();
110: a10 := JTF_NUMBER_TABLE();
111: a11 := JTF_DATE_TABLE();
104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_NUMBER_TABLE();
109: a9 := JTF_NUMBER_TABLE();
110: a10 := JTF_NUMBER_TABLE();
111: a11 := JTF_DATE_TABLE();
112: a12 := JTF_DATE_TABLE();
105: a5 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_NUMBER_TABLE();
109: a9 := JTF_NUMBER_TABLE();
110: a10 := JTF_NUMBER_TABLE();
111: a11 := JTF_DATE_TABLE();
112: a12 := JTF_DATE_TABLE();
113: a13 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_NUMBER_TABLE();
109: a9 := JTF_NUMBER_TABLE();
110: a10 := JTF_NUMBER_TABLE();
111: a11 := JTF_DATE_TABLE();
112: a12 := JTF_DATE_TABLE();
113: a13 := JTF_NUMBER_TABLE();
114: if t.count > 0 then
109: a9 := JTF_NUMBER_TABLE();
110: a10 := JTF_NUMBER_TABLE();
111: a11 := JTF_DATE_TABLE();
112: a12 := JTF_DATE_TABLE();
113: a13 := JTF_NUMBER_TABLE();
114: if t.count > 0 then
115: a0.extend(t.count);
116: a1.extend(t.count);
117: a2.extend(t.count);
152: end if;
153: end if;
154: end rosetta_table_copy_out_p2;
155:
156: procedure rosetta_table_copy_in_p5(t out nocopy okl_sxp_pvt.sxpv_tbl_type, a0 JTF_NUMBER_TABLE
157: , a1 JTF_NUMBER_TABLE
158: , a2 JTF_NUMBER_TABLE
159: , a3 JTF_VARCHAR2_TABLE_300
160: , a4 JTF_NUMBER_TABLE
153: end if;
154: end rosetta_table_copy_out_p2;
155:
156: procedure rosetta_table_copy_in_p5(t out nocopy okl_sxp_pvt.sxpv_tbl_type, a0 JTF_NUMBER_TABLE
157: , a1 JTF_NUMBER_TABLE
158: , a2 JTF_NUMBER_TABLE
159: , a3 JTF_VARCHAR2_TABLE_300
160: , a4 JTF_NUMBER_TABLE
161: , a5 JTF_NUMBER_TABLE
154: end rosetta_table_copy_out_p2;
155:
156: procedure rosetta_table_copy_in_p5(t out nocopy okl_sxp_pvt.sxpv_tbl_type, a0 JTF_NUMBER_TABLE
157: , a1 JTF_NUMBER_TABLE
158: , a2 JTF_NUMBER_TABLE
159: , a3 JTF_VARCHAR2_TABLE_300
160: , a4 JTF_NUMBER_TABLE
161: , a5 JTF_NUMBER_TABLE
162: , a6 JTF_NUMBER_TABLE
156: procedure rosetta_table_copy_in_p5(t out nocopy okl_sxp_pvt.sxpv_tbl_type, a0 JTF_NUMBER_TABLE
157: , a1 JTF_NUMBER_TABLE
158: , a2 JTF_NUMBER_TABLE
159: , a3 JTF_VARCHAR2_TABLE_300
160: , a4 JTF_NUMBER_TABLE
161: , a5 JTF_NUMBER_TABLE
162: , a6 JTF_NUMBER_TABLE
163: , a7 JTF_NUMBER_TABLE
164: , a8 JTF_NUMBER_TABLE
157: , a1 JTF_NUMBER_TABLE
158: , a2 JTF_NUMBER_TABLE
159: , a3 JTF_VARCHAR2_TABLE_300
160: , a4 JTF_NUMBER_TABLE
161: , a5 JTF_NUMBER_TABLE
162: , a6 JTF_NUMBER_TABLE
163: , a7 JTF_NUMBER_TABLE
164: , a8 JTF_NUMBER_TABLE
165: , a9 JTF_NUMBER_TABLE
158: , a2 JTF_NUMBER_TABLE
159: , a3 JTF_VARCHAR2_TABLE_300
160: , a4 JTF_NUMBER_TABLE
161: , a5 JTF_NUMBER_TABLE
162: , a6 JTF_NUMBER_TABLE
163: , a7 JTF_NUMBER_TABLE
164: , a8 JTF_NUMBER_TABLE
165: , a9 JTF_NUMBER_TABLE
166: , a10 JTF_NUMBER_TABLE
159: , a3 JTF_VARCHAR2_TABLE_300
160: , a4 JTF_NUMBER_TABLE
161: , a5 JTF_NUMBER_TABLE
162: , a6 JTF_NUMBER_TABLE
163: , a7 JTF_NUMBER_TABLE
164: , a8 JTF_NUMBER_TABLE
165: , a9 JTF_NUMBER_TABLE
166: , a10 JTF_NUMBER_TABLE
167: , a11 JTF_DATE_TABLE
160: , a4 JTF_NUMBER_TABLE
161: , a5 JTF_NUMBER_TABLE
162: , a6 JTF_NUMBER_TABLE
163: , a7 JTF_NUMBER_TABLE
164: , a8 JTF_NUMBER_TABLE
165: , a9 JTF_NUMBER_TABLE
166: , a10 JTF_NUMBER_TABLE
167: , a11 JTF_DATE_TABLE
168: , a12 JTF_DATE_TABLE
161: , a5 JTF_NUMBER_TABLE
162: , a6 JTF_NUMBER_TABLE
163: , a7 JTF_NUMBER_TABLE
164: , a8 JTF_NUMBER_TABLE
165: , a9 JTF_NUMBER_TABLE
166: , a10 JTF_NUMBER_TABLE
167: , a11 JTF_DATE_TABLE
168: , a12 JTF_DATE_TABLE
169: , a13 JTF_NUMBER_TABLE
162: , a6 JTF_NUMBER_TABLE
163: , a7 JTF_NUMBER_TABLE
164: , a8 JTF_NUMBER_TABLE
165: , a9 JTF_NUMBER_TABLE
166: , a10 JTF_NUMBER_TABLE
167: , a11 JTF_DATE_TABLE
168: , a12 JTF_DATE_TABLE
169: , a13 JTF_NUMBER_TABLE
170: ) as
165: , a9 JTF_NUMBER_TABLE
166: , a10 JTF_NUMBER_TABLE
167: , a11 JTF_DATE_TABLE
168: , a12 JTF_DATE_TABLE
169: , a13 JTF_NUMBER_TABLE
170: ) as
171: ddindx binary_integer; indx binary_integer;
172: begin
173: if a0 is not null and a0.count > 0 then
197: end loop;
198: end if;
199: end if;
200: end rosetta_table_copy_in_p5;
201: procedure rosetta_table_copy_out_p5(t okl_sxp_pvt.sxpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_300
205: , a4 out nocopy JTF_NUMBER_TABLE
198: end if;
199: end if;
200: end rosetta_table_copy_in_p5;
201: procedure rosetta_table_copy_out_p5(t okl_sxp_pvt.sxpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_300
205: , a4 out nocopy JTF_NUMBER_TABLE
206: , a5 out nocopy JTF_NUMBER_TABLE
199: end if;
200: end rosetta_table_copy_in_p5;
201: procedure rosetta_table_copy_out_p5(t okl_sxp_pvt.sxpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_300
205: , a4 out nocopy JTF_NUMBER_TABLE
206: , a5 out nocopy JTF_NUMBER_TABLE
207: , a6 out nocopy JTF_NUMBER_TABLE
201: procedure rosetta_table_copy_out_p5(t okl_sxp_pvt.sxpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_300
205: , a4 out nocopy JTF_NUMBER_TABLE
206: , a5 out nocopy JTF_NUMBER_TABLE
207: , a6 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_NUMBER_TABLE
209: , a8 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_300
205: , a4 out nocopy JTF_NUMBER_TABLE
206: , a5 out nocopy JTF_NUMBER_TABLE
207: , a6 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_NUMBER_TABLE
209: , a8 out nocopy JTF_NUMBER_TABLE
210: , a9 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_300
205: , a4 out nocopy JTF_NUMBER_TABLE
206: , a5 out nocopy JTF_NUMBER_TABLE
207: , a6 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_NUMBER_TABLE
209: , a8 out nocopy JTF_NUMBER_TABLE
210: , a9 out nocopy JTF_NUMBER_TABLE
211: , a10 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_300
205: , a4 out nocopy JTF_NUMBER_TABLE
206: , a5 out nocopy JTF_NUMBER_TABLE
207: , a6 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_NUMBER_TABLE
209: , a8 out nocopy JTF_NUMBER_TABLE
210: , a9 out nocopy JTF_NUMBER_TABLE
211: , a10 out nocopy JTF_NUMBER_TABLE
212: , a11 out nocopy JTF_DATE_TABLE
205: , a4 out nocopy JTF_NUMBER_TABLE
206: , a5 out nocopy JTF_NUMBER_TABLE
207: , a6 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_NUMBER_TABLE
209: , a8 out nocopy JTF_NUMBER_TABLE
210: , a9 out nocopy JTF_NUMBER_TABLE
211: , a10 out nocopy JTF_NUMBER_TABLE
212: , a11 out nocopy JTF_DATE_TABLE
213: , a12 out nocopy JTF_DATE_TABLE
206: , a5 out nocopy JTF_NUMBER_TABLE
207: , a6 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_NUMBER_TABLE
209: , a8 out nocopy JTF_NUMBER_TABLE
210: , a9 out nocopy JTF_NUMBER_TABLE
211: , a10 out nocopy JTF_NUMBER_TABLE
212: , a11 out nocopy JTF_DATE_TABLE
213: , a12 out nocopy JTF_DATE_TABLE
214: , a13 out nocopy JTF_NUMBER_TABLE
207: , a6 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_NUMBER_TABLE
209: , a8 out nocopy JTF_NUMBER_TABLE
210: , a9 out nocopy JTF_NUMBER_TABLE
211: , a10 out nocopy JTF_NUMBER_TABLE
212: , a11 out nocopy JTF_DATE_TABLE
213: , a12 out nocopy JTF_DATE_TABLE
214: , a13 out nocopy JTF_NUMBER_TABLE
215: ) as
210: , a9 out nocopy JTF_NUMBER_TABLE
211: , a10 out nocopy JTF_NUMBER_TABLE
212: , a11 out nocopy JTF_DATE_TABLE
213: , a12 out nocopy JTF_DATE_TABLE
214: , a13 out nocopy JTF_NUMBER_TABLE
215: ) as
216: ddindx binary_integer; indx binary_integer;
217: begin
218: if t is null or t.count = 0 then
215: ) as
216: ddindx binary_integer; indx binary_integer;
217: begin
218: if t is null or t.count = 0 then
219: a0 := JTF_NUMBER_TABLE();
220: a1 := JTF_NUMBER_TABLE();
221: a2 := JTF_NUMBER_TABLE();
222: a3 := JTF_VARCHAR2_TABLE_300();
223: a4 := JTF_NUMBER_TABLE();
216: ddindx binary_integer; indx binary_integer;
217: begin
218: if t is null or t.count = 0 then
219: a0 := JTF_NUMBER_TABLE();
220: a1 := JTF_NUMBER_TABLE();
221: a2 := JTF_NUMBER_TABLE();
222: a3 := JTF_VARCHAR2_TABLE_300();
223: a4 := JTF_NUMBER_TABLE();
224: a5 := JTF_NUMBER_TABLE();
217: begin
218: if t is null or t.count = 0 then
219: a0 := JTF_NUMBER_TABLE();
220: a1 := JTF_NUMBER_TABLE();
221: a2 := JTF_NUMBER_TABLE();
222: a3 := JTF_VARCHAR2_TABLE_300();
223: a4 := JTF_NUMBER_TABLE();
224: a5 := JTF_NUMBER_TABLE();
225: a6 := JTF_NUMBER_TABLE();
219: a0 := JTF_NUMBER_TABLE();
220: a1 := JTF_NUMBER_TABLE();
221: a2 := JTF_NUMBER_TABLE();
222: a3 := JTF_VARCHAR2_TABLE_300();
223: a4 := JTF_NUMBER_TABLE();
224: a5 := JTF_NUMBER_TABLE();
225: a6 := JTF_NUMBER_TABLE();
226: a7 := JTF_NUMBER_TABLE();
227: a8 := JTF_NUMBER_TABLE();
220: a1 := JTF_NUMBER_TABLE();
221: a2 := JTF_NUMBER_TABLE();
222: a3 := JTF_VARCHAR2_TABLE_300();
223: a4 := JTF_NUMBER_TABLE();
224: a5 := JTF_NUMBER_TABLE();
225: a6 := JTF_NUMBER_TABLE();
226: a7 := JTF_NUMBER_TABLE();
227: a8 := JTF_NUMBER_TABLE();
228: a9 := JTF_NUMBER_TABLE();
221: a2 := JTF_NUMBER_TABLE();
222: a3 := JTF_VARCHAR2_TABLE_300();
223: a4 := JTF_NUMBER_TABLE();
224: a5 := JTF_NUMBER_TABLE();
225: a6 := JTF_NUMBER_TABLE();
226: a7 := JTF_NUMBER_TABLE();
227: a8 := JTF_NUMBER_TABLE();
228: a9 := JTF_NUMBER_TABLE();
229: a10 := JTF_NUMBER_TABLE();
222: a3 := JTF_VARCHAR2_TABLE_300();
223: a4 := JTF_NUMBER_TABLE();
224: a5 := JTF_NUMBER_TABLE();
225: a6 := JTF_NUMBER_TABLE();
226: a7 := JTF_NUMBER_TABLE();
227: a8 := JTF_NUMBER_TABLE();
228: a9 := JTF_NUMBER_TABLE();
229: a10 := JTF_NUMBER_TABLE();
230: a11 := JTF_DATE_TABLE();
223: a4 := JTF_NUMBER_TABLE();
224: a5 := JTF_NUMBER_TABLE();
225: a6 := JTF_NUMBER_TABLE();
226: a7 := JTF_NUMBER_TABLE();
227: a8 := JTF_NUMBER_TABLE();
228: a9 := JTF_NUMBER_TABLE();
229: a10 := JTF_NUMBER_TABLE();
230: a11 := JTF_DATE_TABLE();
231: a12 := JTF_DATE_TABLE();
224: a5 := JTF_NUMBER_TABLE();
225: a6 := JTF_NUMBER_TABLE();
226: a7 := JTF_NUMBER_TABLE();
227: a8 := JTF_NUMBER_TABLE();
228: a9 := JTF_NUMBER_TABLE();
229: a10 := JTF_NUMBER_TABLE();
230: a11 := JTF_DATE_TABLE();
231: a12 := JTF_DATE_TABLE();
232: a13 := JTF_NUMBER_TABLE();
225: a6 := JTF_NUMBER_TABLE();
226: a7 := JTF_NUMBER_TABLE();
227: a8 := JTF_NUMBER_TABLE();
228: a9 := JTF_NUMBER_TABLE();
229: a10 := JTF_NUMBER_TABLE();
230: a11 := JTF_DATE_TABLE();
231: a12 := JTF_DATE_TABLE();
232: a13 := JTF_NUMBER_TABLE();
233: else
228: a9 := JTF_NUMBER_TABLE();
229: a10 := JTF_NUMBER_TABLE();
230: a11 := JTF_DATE_TABLE();
231: a12 := JTF_DATE_TABLE();
232: a13 := JTF_NUMBER_TABLE();
233: else
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_NUMBER_TABLE();
230: a11 := JTF_DATE_TABLE();
231: a12 := JTF_DATE_TABLE();
232: a13 := JTF_NUMBER_TABLE();
233: else
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_NUMBER_TABLE();
237: a3 := JTF_VARCHAR2_TABLE_300();
238: a4 := JTF_NUMBER_TABLE();
231: a12 := JTF_DATE_TABLE();
232: a13 := JTF_NUMBER_TABLE();
233: else
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_NUMBER_TABLE();
237: a3 := JTF_VARCHAR2_TABLE_300();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
232: a13 := JTF_NUMBER_TABLE();
233: else
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_NUMBER_TABLE();
237: a3 := JTF_VARCHAR2_TABLE_300();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_NUMBER_TABLE();
237: a3 := JTF_VARCHAR2_TABLE_300();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_NUMBER_TABLE();
237: a3 := JTF_VARCHAR2_TABLE_300();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
236: a2 := JTF_NUMBER_TABLE();
237: a3 := JTF_VARCHAR2_TABLE_300();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
237: a3 := JTF_VARCHAR2_TABLE_300();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_DATE_TABLE();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_DATE_TABLE();
246: a12 := JTF_DATE_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_DATE_TABLE();
246: a12 := JTF_DATE_TABLE();
247: a13 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_DATE_TABLE();
246: a12 := JTF_DATE_TABLE();
247: a13 := JTF_NUMBER_TABLE();
248: if t.count > 0 then
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_DATE_TABLE();
246: a12 := JTF_DATE_TABLE();
247: a13 := JTF_NUMBER_TABLE();
248: if t.count > 0 then
249: a0.extend(t.count);
250: a1.extend(t.count);
251: a2.extend(t.count);
386: , p_init_msg_list VARCHAR2
387: , x_return_status out nocopy VARCHAR2
388: , x_msg_count out nocopy NUMBER
389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_VARCHAR2_TABLE_300
394: , p5_a4 JTF_NUMBER_TABLE
387: , x_return_status out nocopy VARCHAR2
388: , x_msg_count out nocopy NUMBER
389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_VARCHAR2_TABLE_300
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_NUMBER_TABLE
388: , x_msg_count out nocopy NUMBER
389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_VARCHAR2_TABLE_300
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_NUMBER_TABLE
396: , p5_a6 JTF_NUMBER_TABLE
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_VARCHAR2_TABLE_300
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_NUMBER_TABLE
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_NUMBER_TABLE
398: , p5_a8 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_VARCHAR2_TABLE_300
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_NUMBER_TABLE
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_NUMBER_TABLE
398: , p5_a8 JTF_NUMBER_TABLE
399: , p5_a9 JTF_NUMBER_TABLE
392: , p5_a2 JTF_NUMBER_TABLE
393: , p5_a3 JTF_VARCHAR2_TABLE_300
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_NUMBER_TABLE
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_NUMBER_TABLE
398: , p5_a8 JTF_NUMBER_TABLE
399: , p5_a9 JTF_NUMBER_TABLE
400: , p5_a10 JTF_NUMBER_TABLE
393: , p5_a3 JTF_VARCHAR2_TABLE_300
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_NUMBER_TABLE
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_NUMBER_TABLE
398: , p5_a8 JTF_NUMBER_TABLE
399: , p5_a9 JTF_NUMBER_TABLE
400: , p5_a10 JTF_NUMBER_TABLE
401: , p5_a11 JTF_DATE_TABLE
394: , p5_a4 JTF_NUMBER_TABLE
395: , p5_a5 JTF_NUMBER_TABLE
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_NUMBER_TABLE
398: , p5_a8 JTF_NUMBER_TABLE
399: , p5_a9 JTF_NUMBER_TABLE
400: , p5_a10 JTF_NUMBER_TABLE
401: , p5_a11 JTF_DATE_TABLE
402: , p5_a12 JTF_DATE_TABLE
395: , p5_a5 JTF_NUMBER_TABLE
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_NUMBER_TABLE
398: , p5_a8 JTF_NUMBER_TABLE
399: , p5_a9 JTF_NUMBER_TABLE
400: , p5_a10 JTF_NUMBER_TABLE
401: , p5_a11 JTF_DATE_TABLE
402: , p5_a12 JTF_DATE_TABLE
403: , p5_a13 JTF_NUMBER_TABLE
396: , p5_a6 JTF_NUMBER_TABLE
397: , p5_a7 JTF_NUMBER_TABLE
398: , p5_a8 JTF_NUMBER_TABLE
399: , p5_a9 JTF_NUMBER_TABLE
400: , p5_a10 JTF_NUMBER_TABLE
401: , p5_a11 JTF_DATE_TABLE
402: , p5_a12 JTF_DATE_TABLE
403: , p5_a13 JTF_NUMBER_TABLE
404: , p6_a0 out nocopy JTF_NUMBER_TABLE
399: , p5_a9 JTF_NUMBER_TABLE
400: , p5_a10 JTF_NUMBER_TABLE
401: , p5_a11 JTF_DATE_TABLE
402: , p5_a12 JTF_DATE_TABLE
403: , p5_a13 JTF_NUMBER_TABLE
404: , p6_a0 out nocopy JTF_NUMBER_TABLE
405: , p6_a1 out nocopy JTF_NUMBER_TABLE
406: , p6_a2 out nocopy JTF_NUMBER_TABLE
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
400: , p5_a10 JTF_NUMBER_TABLE
401: , p5_a11 JTF_DATE_TABLE
402: , p5_a12 JTF_DATE_TABLE
403: , p5_a13 JTF_NUMBER_TABLE
404: , p6_a0 out nocopy JTF_NUMBER_TABLE
405: , p6_a1 out nocopy JTF_NUMBER_TABLE
406: , p6_a2 out nocopy JTF_NUMBER_TABLE
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
408: , p6_a4 out nocopy JTF_NUMBER_TABLE
401: , p5_a11 JTF_DATE_TABLE
402: , p5_a12 JTF_DATE_TABLE
403: , p5_a13 JTF_NUMBER_TABLE
404: , p6_a0 out nocopy JTF_NUMBER_TABLE
405: , p6_a1 out nocopy JTF_NUMBER_TABLE
406: , p6_a2 out nocopy JTF_NUMBER_TABLE
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
408: , p6_a4 out nocopy JTF_NUMBER_TABLE
409: , p6_a5 out nocopy JTF_NUMBER_TABLE
402: , p5_a12 JTF_DATE_TABLE
403: , p5_a13 JTF_NUMBER_TABLE
404: , p6_a0 out nocopy JTF_NUMBER_TABLE
405: , p6_a1 out nocopy JTF_NUMBER_TABLE
406: , p6_a2 out nocopy JTF_NUMBER_TABLE
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
408: , p6_a4 out nocopy JTF_NUMBER_TABLE
409: , p6_a5 out nocopy JTF_NUMBER_TABLE
410: , p6_a6 out nocopy JTF_NUMBER_TABLE
404: , p6_a0 out nocopy JTF_NUMBER_TABLE
405: , p6_a1 out nocopy JTF_NUMBER_TABLE
406: , p6_a2 out nocopy JTF_NUMBER_TABLE
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
408: , p6_a4 out nocopy JTF_NUMBER_TABLE
409: , p6_a5 out nocopy JTF_NUMBER_TABLE
410: , p6_a6 out nocopy JTF_NUMBER_TABLE
411: , p6_a7 out nocopy JTF_NUMBER_TABLE
412: , p6_a8 out nocopy JTF_NUMBER_TABLE
405: , p6_a1 out nocopy JTF_NUMBER_TABLE
406: , p6_a2 out nocopy JTF_NUMBER_TABLE
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
408: , p6_a4 out nocopy JTF_NUMBER_TABLE
409: , p6_a5 out nocopy JTF_NUMBER_TABLE
410: , p6_a6 out nocopy JTF_NUMBER_TABLE
411: , p6_a7 out nocopy JTF_NUMBER_TABLE
412: , p6_a8 out nocopy JTF_NUMBER_TABLE
413: , p6_a9 out nocopy JTF_NUMBER_TABLE
406: , p6_a2 out nocopy JTF_NUMBER_TABLE
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
408: , p6_a4 out nocopy JTF_NUMBER_TABLE
409: , p6_a5 out nocopy JTF_NUMBER_TABLE
410: , p6_a6 out nocopy JTF_NUMBER_TABLE
411: , p6_a7 out nocopy JTF_NUMBER_TABLE
412: , p6_a8 out nocopy JTF_NUMBER_TABLE
413: , p6_a9 out nocopy JTF_NUMBER_TABLE
414: , p6_a10 out nocopy JTF_NUMBER_TABLE
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
408: , p6_a4 out nocopy JTF_NUMBER_TABLE
409: , p6_a5 out nocopy JTF_NUMBER_TABLE
410: , p6_a6 out nocopy JTF_NUMBER_TABLE
411: , p6_a7 out nocopy JTF_NUMBER_TABLE
412: , p6_a8 out nocopy JTF_NUMBER_TABLE
413: , p6_a9 out nocopy JTF_NUMBER_TABLE
414: , p6_a10 out nocopy JTF_NUMBER_TABLE
415: , p6_a11 out nocopy JTF_DATE_TABLE
408: , p6_a4 out nocopy JTF_NUMBER_TABLE
409: , p6_a5 out nocopy JTF_NUMBER_TABLE
410: , p6_a6 out nocopy JTF_NUMBER_TABLE
411: , p6_a7 out nocopy JTF_NUMBER_TABLE
412: , p6_a8 out nocopy JTF_NUMBER_TABLE
413: , p6_a9 out nocopy JTF_NUMBER_TABLE
414: , p6_a10 out nocopy JTF_NUMBER_TABLE
415: , p6_a11 out nocopy JTF_DATE_TABLE
416: , p6_a12 out nocopy JTF_DATE_TABLE
409: , p6_a5 out nocopy JTF_NUMBER_TABLE
410: , p6_a6 out nocopy JTF_NUMBER_TABLE
411: , p6_a7 out nocopy JTF_NUMBER_TABLE
412: , p6_a8 out nocopy JTF_NUMBER_TABLE
413: , p6_a9 out nocopy JTF_NUMBER_TABLE
414: , p6_a10 out nocopy JTF_NUMBER_TABLE
415: , p6_a11 out nocopy JTF_DATE_TABLE
416: , p6_a12 out nocopy JTF_DATE_TABLE
417: , p6_a13 out nocopy JTF_NUMBER_TABLE
410: , p6_a6 out nocopy JTF_NUMBER_TABLE
411: , p6_a7 out nocopy JTF_NUMBER_TABLE
412: , p6_a8 out nocopy JTF_NUMBER_TABLE
413: , p6_a9 out nocopy JTF_NUMBER_TABLE
414: , p6_a10 out nocopy JTF_NUMBER_TABLE
415: , p6_a11 out nocopy JTF_DATE_TABLE
416: , p6_a12 out nocopy JTF_DATE_TABLE
417: , p6_a13 out nocopy JTF_NUMBER_TABLE
418: )
413: , p6_a9 out nocopy JTF_NUMBER_TABLE
414: , p6_a10 out nocopy JTF_NUMBER_TABLE
415: , p6_a11 out nocopy JTF_DATE_TABLE
416: , p6_a12 out nocopy JTF_DATE_TABLE
417: , p6_a13 out nocopy JTF_NUMBER_TABLE
418: )
419:
420: as
421: ddp_sxpv_tbl okl_sxp_pvt.sxpv_tbl_type;
546: , p_init_msg_list VARCHAR2
547: , x_return_status out nocopy VARCHAR2
548: , x_msg_count out nocopy NUMBER
549: , x_msg_data out nocopy VARCHAR2
550: , p5_a0 JTF_NUMBER_TABLE
551: , p5_a1 JTF_NUMBER_TABLE
552: , p5_a2 JTF_NUMBER_TABLE
553: , p5_a3 JTF_VARCHAR2_TABLE_300
554: , p5_a4 JTF_NUMBER_TABLE
547: , x_return_status out nocopy VARCHAR2
548: , x_msg_count out nocopy NUMBER
549: , x_msg_data out nocopy VARCHAR2
550: , p5_a0 JTF_NUMBER_TABLE
551: , p5_a1 JTF_NUMBER_TABLE
552: , p5_a2 JTF_NUMBER_TABLE
553: , p5_a3 JTF_VARCHAR2_TABLE_300
554: , p5_a4 JTF_NUMBER_TABLE
555: , p5_a5 JTF_NUMBER_TABLE
548: , x_msg_count out nocopy NUMBER
549: , x_msg_data out nocopy VARCHAR2
550: , p5_a0 JTF_NUMBER_TABLE
551: , p5_a1 JTF_NUMBER_TABLE
552: , p5_a2 JTF_NUMBER_TABLE
553: , p5_a3 JTF_VARCHAR2_TABLE_300
554: , p5_a4 JTF_NUMBER_TABLE
555: , p5_a5 JTF_NUMBER_TABLE
556: , p5_a6 JTF_NUMBER_TABLE
550: , p5_a0 JTF_NUMBER_TABLE
551: , p5_a1 JTF_NUMBER_TABLE
552: , p5_a2 JTF_NUMBER_TABLE
553: , p5_a3 JTF_VARCHAR2_TABLE_300
554: , p5_a4 JTF_NUMBER_TABLE
555: , p5_a5 JTF_NUMBER_TABLE
556: , p5_a6 JTF_NUMBER_TABLE
557: , p5_a7 JTF_NUMBER_TABLE
558: , p5_a8 JTF_NUMBER_TABLE
551: , p5_a1 JTF_NUMBER_TABLE
552: , p5_a2 JTF_NUMBER_TABLE
553: , p5_a3 JTF_VARCHAR2_TABLE_300
554: , p5_a4 JTF_NUMBER_TABLE
555: , p5_a5 JTF_NUMBER_TABLE
556: , p5_a6 JTF_NUMBER_TABLE
557: , p5_a7 JTF_NUMBER_TABLE
558: , p5_a8 JTF_NUMBER_TABLE
559: , p5_a9 JTF_NUMBER_TABLE
552: , p5_a2 JTF_NUMBER_TABLE
553: , p5_a3 JTF_VARCHAR2_TABLE_300
554: , p5_a4 JTF_NUMBER_TABLE
555: , p5_a5 JTF_NUMBER_TABLE
556: , p5_a6 JTF_NUMBER_TABLE
557: , p5_a7 JTF_NUMBER_TABLE
558: , p5_a8 JTF_NUMBER_TABLE
559: , p5_a9 JTF_NUMBER_TABLE
560: , p5_a10 JTF_NUMBER_TABLE
553: , p5_a3 JTF_VARCHAR2_TABLE_300
554: , p5_a4 JTF_NUMBER_TABLE
555: , p5_a5 JTF_NUMBER_TABLE
556: , p5_a6 JTF_NUMBER_TABLE
557: , p5_a7 JTF_NUMBER_TABLE
558: , p5_a8 JTF_NUMBER_TABLE
559: , p5_a9 JTF_NUMBER_TABLE
560: , p5_a10 JTF_NUMBER_TABLE
561: , p5_a11 JTF_DATE_TABLE
554: , p5_a4 JTF_NUMBER_TABLE
555: , p5_a5 JTF_NUMBER_TABLE
556: , p5_a6 JTF_NUMBER_TABLE
557: , p5_a7 JTF_NUMBER_TABLE
558: , p5_a8 JTF_NUMBER_TABLE
559: , p5_a9 JTF_NUMBER_TABLE
560: , p5_a10 JTF_NUMBER_TABLE
561: , p5_a11 JTF_DATE_TABLE
562: , p5_a12 JTF_DATE_TABLE
555: , p5_a5 JTF_NUMBER_TABLE
556: , p5_a6 JTF_NUMBER_TABLE
557: , p5_a7 JTF_NUMBER_TABLE
558: , p5_a8 JTF_NUMBER_TABLE
559: , p5_a9 JTF_NUMBER_TABLE
560: , p5_a10 JTF_NUMBER_TABLE
561: , p5_a11 JTF_DATE_TABLE
562: , p5_a12 JTF_DATE_TABLE
563: , p5_a13 JTF_NUMBER_TABLE
556: , p5_a6 JTF_NUMBER_TABLE
557: , p5_a7 JTF_NUMBER_TABLE
558: , p5_a8 JTF_NUMBER_TABLE
559: , p5_a9 JTF_NUMBER_TABLE
560: , p5_a10 JTF_NUMBER_TABLE
561: , p5_a11 JTF_DATE_TABLE
562: , p5_a12 JTF_DATE_TABLE
563: , p5_a13 JTF_NUMBER_TABLE
564: )
559: , p5_a9 JTF_NUMBER_TABLE
560: , p5_a10 JTF_NUMBER_TABLE
561: , p5_a11 JTF_DATE_TABLE
562: , p5_a12 JTF_DATE_TABLE
563: , p5_a13 JTF_NUMBER_TABLE
564: )
565:
566: as
567: ddp_sxpv_tbl okl_sxp_pvt.sxpv_tbl_type;
705: , p_init_msg_list VARCHAR2
706: , x_return_status out nocopy VARCHAR2
707: , x_msg_count out nocopy NUMBER
708: , x_msg_data out nocopy VARCHAR2
709: , p5_a0 JTF_NUMBER_TABLE
710: , p5_a1 JTF_NUMBER_TABLE
711: , p5_a2 JTF_NUMBER_TABLE
712: , p5_a3 JTF_VARCHAR2_TABLE_300
713: , p5_a4 JTF_NUMBER_TABLE
706: , x_return_status out nocopy VARCHAR2
707: , x_msg_count out nocopy NUMBER
708: , x_msg_data out nocopy VARCHAR2
709: , p5_a0 JTF_NUMBER_TABLE
710: , p5_a1 JTF_NUMBER_TABLE
711: , p5_a2 JTF_NUMBER_TABLE
712: , p5_a3 JTF_VARCHAR2_TABLE_300
713: , p5_a4 JTF_NUMBER_TABLE
714: , p5_a5 JTF_NUMBER_TABLE
707: , x_msg_count out nocopy NUMBER
708: , x_msg_data out nocopy VARCHAR2
709: , p5_a0 JTF_NUMBER_TABLE
710: , p5_a1 JTF_NUMBER_TABLE
711: , p5_a2 JTF_NUMBER_TABLE
712: , p5_a3 JTF_VARCHAR2_TABLE_300
713: , p5_a4 JTF_NUMBER_TABLE
714: , p5_a5 JTF_NUMBER_TABLE
715: , p5_a6 JTF_NUMBER_TABLE
709: , p5_a0 JTF_NUMBER_TABLE
710: , p5_a1 JTF_NUMBER_TABLE
711: , p5_a2 JTF_NUMBER_TABLE
712: , p5_a3 JTF_VARCHAR2_TABLE_300
713: , p5_a4 JTF_NUMBER_TABLE
714: , p5_a5 JTF_NUMBER_TABLE
715: , p5_a6 JTF_NUMBER_TABLE
716: , p5_a7 JTF_NUMBER_TABLE
717: , p5_a8 JTF_NUMBER_TABLE
710: , p5_a1 JTF_NUMBER_TABLE
711: , p5_a2 JTF_NUMBER_TABLE
712: , p5_a3 JTF_VARCHAR2_TABLE_300
713: , p5_a4 JTF_NUMBER_TABLE
714: , p5_a5 JTF_NUMBER_TABLE
715: , p5_a6 JTF_NUMBER_TABLE
716: , p5_a7 JTF_NUMBER_TABLE
717: , p5_a8 JTF_NUMBER_TABLE
718: , p5_a9 JTF_NUMBER_TABLE
711: , p5_a2 JTF_NUMBER_TABLE
712: , p5_a3 JTF_VARCHAR2_TABLE_300
713: , p5_a4 JTF_NUMBER_TABLE
714: , p5_a5 JTF_NUMBER_TABLE
715: , p5_a6 JTF_NUMBER_TABLE
716: , p5_a7 JTF_NUMBER_TABLE
717: , p5_a8 JTF_NUMBER_TABLE
718: , p5_a9 JTF_NUMBER_TABLE
719: , p5_a10 JTF_NUMBER_TABLE
712: , p5_a3 JTF_VARCHAR2_TABLE_300
713: , p5_a4 JTF_NUMBER_TABLE
714: , p5_a5 JTF_NUMBER_TABLE
715: , p5_a6 JTF_NUMBER_TABLE
716: , p5_a7 JTF_NUMBER_TABLE
717: , p5_a8 JTF_NUMBER_TABLE
718: , p5_a9 JTF_NUMBER_TABLE
719: , p5_a10 JTF_NUMBER_TABLE
720: , p5_a11 JTF_DATE_TABLE
713: , p5_a4 JTF_NUMBER_TABLE
714: , p5_a5 JTF_NUMBER_TABLE
715: , p5_a6 JTF_NUMBER_TABLE
716: , p5_a7 JTF_NUMBER_TABLE
717: , p5_a8 JTF_NUMBER_TABLE
718: , p5_a9 JTF_NUMBER_TABLE
719: , p5_a10 JTF_NUMBER_TABLE
720: , p5_a11 JTF_DATE_TABLE
721: , p5_a12 JTF_DATE_TABLE
714: , p5_a5 JTF_NUMBER_TABLE
715: , p5_a6 JTF_NUMBER_TABLE
716: , p5_a7 JTF_NUMBER_TABLE
717: , p5_a8 JTF_NUMBER_TABLE
718: , p5_a9 JTF_NUMBER_TABLE
719: , p5_a10 JTF_NUMBER_TABLE
720: , p5_a11 JTF_DATE_TABLE
721: , p5_a12 JTF_DATE_TABLE
722: , p5_a13 JTF_NUMBER_TABLE
715: , p5_a6 JTF_NUMBER_TABLE
716: , p5_a7 JTF_NUMBER_TABLE
717: , p5_a8 JTF_NUMBER_TABLE
718: , p5_a9 JTF_NUMBER_TABLE
719: , p5_a10 JTF_NUMBER_TABLE
720: , p5_a11 JTF_DATE_TABLE
721: , p5_a12 JTF_DATE_TABLE
722: , p5_a13 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
718: , p5_a9 JTF_NUMBER_TABLE
719: , p5_a10 JTF_NUMBER_TABLE
720: , p5_a11 JTF_DATE_TABLE
721: , p5_a12 JTF_DATE_TABLE
722: , p5_a13 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_NUMBER_TABLE
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
719: , p5_a10 JTF_NUMBER_TABLE
720: , p5_a11 JTF_DATE_TABLE
721: , p5_a12 JTF_DATE_TABLE
722: , p5_a13 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_NUMBER_TABLE
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
727: , p6_a4 out nocopy JTF_NUMBER_TABLE
720: , p5_a11 JTF_DATE_TABLE
721: , p5_a12 JTF_DATE_TABLE
722: , p5_a13 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_NUMBER_TABLE
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
727: , p6_a4 out nocopy JTF_NUMBER_TABLE
728: , p6_a5 out nocopy JTF_NUMBER_TABLE
721: , p5_a12 JTF_DATE_TABLE
722: , p5_a13 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_NUMBER_TABLE
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
727: , p6_a4 out nocopy JTF_NUMBER_TABLE
728: , p6_a5 out nocopy JTF_NUMBER_TABLE
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_NUMBER_TABLE
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
727: , p6_a4 out nocopy JTF_NUMBER_TABLE
728: , p6_a5 out nocopy JTF_NUMBER_TABLE
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_NUMBER_TABLE
731: , p6_a8 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_NUMBER_TABLE
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
727: , p6_a4 out nocopy JTF_NUMBER_TABLE
728: , p6_a5 out nocopy JTF_NUMBER_TABLE
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_NUMBER_TABLE
731: , p6_a8 out nocopy JTF_NUMBER_TABLE
732: , p6_a9 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_NUMBER_TABLE
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
727: , p6_a4 out nocopy JTF_NUMBER_TABLE
728: , p6_a5 out nocopy JTF_NUMBER_TABLE
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_NUMBER_TABLE
731: , p6_a8 out nocopy JTF_NUMBER_TABLE
732: , p6_a9 out nocopy JTF_NUMBER_TABLE
733: , p6_a10 out nocopy JTF_NUMBER_TABLE
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
727: , p6_a4 out nocopy JTF_NUMBER_TABLE
728: , p6_a5 out nocopy JTF_NUMBER_TABLE
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_NUMBER_TABLE
731: , p6_a8 out nocopy JTF_NUMBER_TABLE
732: , p6_a9 out nocopy JTF_NUMBER_TABLE
733: , p6_a10 out nocopy JTF_NUMBER_TABLE
734: , p6_a11 out nocopy JTF_DATE_TABLE
727: , p6_a4 out nocopy JTF_NUMBER_TABLE
728: , p6_a5 out nocopy JTF_NUMBER_TABLE
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_NUMBER_TABLE
731: , p6_a8 out nocopy JTF_NUMBER_TABLE
732: , p6_a9 out nocopy JTF_NUMBER_TABLE
733: , p6_a10 out nocopy JTF_NUMBER_TABLE
734: , p6_a11 out nocopy JTF_DATE_TABLE
735: , p6_a12 out nocopy JTF_DATE_TABLE
728: , p6_a5 out nocopy JTF_NUMBER_TABLE
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_NUMBER_TABLE
731: , p6_a8 out nocopy JTF_NUMBER_TABLE
732: , p6_a9 out nocopy JTF_NUMBER_TABLE
733: , p6_a10 out nocopy JTF_NUMBER_TABLE
734: , p6_a11 out nocopy JTF_DATE_TABLE
735: , p6_a12 out nocopy JTF_DATE_TABLE
736: , p6_a13 out nocopy JTF_NUMBER_TABLE
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_NUMBER_TABLE
731: , p6_a8 out nocopy JTF_NUMBER_TABLE
732: , p6_a9 out nocopy JTF_NUMBER_TABLE
733: , p6_a10 out nocopy JTF_NUMBER_TABLE
734: , p6_a11 out nocopy JTF_DATE_TABLE
735: , p6_a12 out nocopy JTF_DATE_TABLE
736: , p6_a13 out nocopy JTF_NUMBER_TABLE
737: )
732: , p6_a9 out nocopy JTF_NUMBER_TABLE
733: , p6_a10 out nocopy JTF_NUMBER_TABLE
734: , p6_a11 out nocopy JTF_DATE_TABLE
735: , p6_a12 out nocopy JTF_DATE_TABLE
736: , p6_a13 out nocopy JTF_NUMBER_TABLE
737: )
738:
739: as
740: ddp_sxpv_tbl okl_sxp_pvt.sxpv_tbl_type;
865: , p_init_msg_list VARCHAR2
866: , x_return_status out nocopy VARCHAR2
867: , x_msg_count out nocopy NUMBER
868: , x_msg_data out nocopy VARCHAR2
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_300
873: , p5_a4 JTF_NUMBER_TABLE
866: , x_return_status out nocopy VARCHAR2
867: , x_msg_count out nocopy NUMBER
868: , x_msg_data out nocopy VARCHAR2
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_300
873: , p5_a4 JTF_NUMBER_TABLE
874: , p5_a5 JTF_NUMBER_TABLE
867: , x_msg_count out nocopy NUMBER
868: , x_msg_data out nocopy VARCHAR2
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_300
873: , p5_a4 JTF_NUMBER_TABLE
874: , p5_a5 JTF_NUMBER_TABLE
875: , p5_a6 JTF_NUMBER_TABLE
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_300
873: , p5_a4 JTF_NUMBER_TABLE
874: , p5_a5 JTF_NUMBER_TABLE
875: , p5_a6 JTF_NUMBER_TABLE
876: , p5_a7 JTF_NUMBER_TABLE
877: , p5_a8 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_300
873: , p5_a4 JTF_NUMBER_TABLE
874: , p5_a5 JTF_NUMBER_TABLE
875: , p5_a6 JTF_NUMBER_TABLE
876: , p5_a7 JTF_NUMBER_TABLE
877: , p5_a8 JTF_NUMBER_TABLE
878: , p5_a9 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_300
873: , p5_a4 JTF_NUMBER_TABLE
874: , p5_a5 JTF_NUMBER_TABLE
875: , p5_a6 JTF_NUMBER_TABLE
876: , p5_a7 JTF_NUMBER_TABLE
877: , p5_a8 JTF_NUMBER_TABLE
878: , p5_a9 JTF_NUMBER_TABLE
879: , p5_a10 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_300
873: , p5_a4 JTF_NUMBER_TABLE
874: , p5_a5 JTF_NUMBER_TABLE
875: , p5_a6 JTF_NUMBER_TABLE
876: , p5_a7 JTF_NUMBER_TABLE
877: , p5_a8 JTF_NUMBER_TABLE
878: , p5_a9 JTF_NUMBER_TABLE
879: , p5_a10 JTF_NUMBER_TABLE
880: , p5_a11 JTF_DATE_TABLE
873: , p5_a4 JTF_NUMBER_TABLE
874: , p5_a5 JTF_NUMBER_TABLE
875: , p5_a6 JTF_NUMBER_TABLE
876: , p5_a7 JTF_NUMBER_TABLE
877: , p5_a8 JTF_NUMBER_TABLE
878: , p5_a9 JTF_NUMBER_TABLE
879: , p5_a10 JTF_NUMBER_TABLE
880: , p5_a11 JTF_DATE_TABLE
881: , p5_a12 JTF_DATE_TABLE
874: , p5_a5 JTF_NUMBER_TABLE
875: , p5_a6 JTF_NUMBER_TABLE
876: , p5_a7 JTF_NUMBER_TABLE
877: , p5_a8 JTF_NUMBER_TABLE
878: , p5_a9 JTF_NUMBER_TABLE
879: , p5_a10 JTF_NUMBER_TABLE
880: , p5_a11 JTF_DATE_TABLE
881: , p5_a12 JTF_DATE_TABLE
882: , p5_a13 JTF_NUMBER_TABLE
875: , p5_a6 JTF_NUMBER_TABLE
876: , p5_a7 JTF_NUMBER_TABLE
877: , p5_a8 JTF_NUMBER_TABLE
878: , p5_a9 JTF_NUMBER_TABLE
879: , p5_a10 JTF_NUMBER_TABLE
880: , p5_a11 JTF_DATE_TABLE
881: , p5_a12 JTF_DATE_TABLE
882: , p5_a13 JTF_NUMBER_TABLE
883: )
878: , p5_a9 JTF_NUMBER_TABLE
879: , p5_a10 JTF_NUMBER_TABLE
880: , p5_a11 JTF_DATE_TABLE
881: , p5_a12 JTF_DATE_TABLE
882: , p5_a13 JTF_NUMBER_TABLE
883: )
884:
885: as
886: ddp_sxpv_tbl okl_sxp_pvt.sxpv_tbl_type;
992: , p_init_msg_list VARCHAR2
993: , x_return_status out nocopy VARCHAR2
994: , x_msg_count out nocopy NUMBER
995: , x_msg_data out nocopy VARCHAR2
996: , p5_a0 JTF_NUMBER_TABLE
997: , p5_a1 JTF_NUMBER_TABLE
998: , p5_a2 JTF_NUMBER_TABLE
999: , p5_a3 JTF_VARCHAR2_TABLE_300
1000: , p5_a4 JTF_NUMBER_TABLE
993: , x_return_status out nocopy VARCHAR2
994: , x_msg_count out nocopy NUMBER
995: , x_msg_data out nocopy VARCHAR2
996: , p5_a0 JTF_NUMBER_TABLE
997: , p5_a1 JTF_NUMBER_TABLE
998: , p5_a2 JTF_NUMBER_TABLE
999: , p5_a3 JTF_VARCHAR2_TABLE_300
1000: , p5_a4 JTF_NUMBER_TABLE
1001: , p5_a5 JTF_NUMBER_TABLE
994: , x_msg_count out nocopy NUMBER
995: , x_msg_data out nocopy VARCHAR2
996: , p5_a0 JTF_NUMBER_TABLE
997: , p5_a1 JTF_NUMBER_TABLE
998: , p5_a2 JTF_NUMBER_TABLE
999: , p5_a3 JTF_VARCHAR2_TABLE_300
1000: , p5_a4 JTF_NUMBER_TABLE
1001: , p5_a5 JTF_NUMBER_TABLE
1002: , p5_a6 JTF_NUMBER_TABLE
996: , p5_a0 JTF_NUMBER_TABLE
997: , p5_a1 JTF_NUMBER_TABLE
998: , p5_a2 JTF_NUMBER_TABLE
999: , p5_a3 JTF_VARCHAR2_TABLE_300
1000: , p5_a4 JTF_NUMBER_TABLE
1001: , p5_a5 JTF_NUMBER_TABLE
1002: , p5_a6 JTF_NUMBER_TABLE
1003: , p5_a7 JTF_NUMBER_TABLE
1004: , p5_a8 JTF_NUMBER_TABLE
997: , p5_a1 JTF_NUMBER_TABLE
998: , p5_a2 JTF_NUMBER_TABLE
999: , p5_a3 JTF_VARCHAR2_TABLE_300
1000: , p5_a4 JTF_NUMBER_TABLE
1001: , p5_a5 JTF_NUMBER_TABLE
1002: , p5_a6 JTF_NUMBER_TABLE
1003: , p5_a7 JTF_NUMBER_TABLE
1004: , p5_a8 JTF_NUMBER_TABLE
1005: , p5_a9 JTF_NUMBER_TABLE
998: , p5_a2 JTF_NUMBER_TABLE
999: , p5_a3 JTF_VARCHAR2_TABLE_300
1000: , p5_a4 JTF_NUMBER_TABLE
1001: , p5_a5 JTF_NUMBER_TABLE
1002: , p5_a6 JTF_NUMBER_TABLE
1003: , p5_a7 JTF_NUMBER_TABLE
1004: , p5_a8 JTF_NUMBER_TABLE
1005: , p5_a9 JTF_NUMBER_TABLE
1006: , p5_a10 JTF_NUMBER_TABLE
999: , p5_a3 JTF_VARCHAR2_TABLE_300
1000: , p5_a4 JTF_NUMBER_TABLE
1001: , p5_a5 JTF_NUMBER_TABLE
1002: , p5_a6 JTF_NUMBER_TABLE
1003: , p5_a7 JTF_NUMBER_TABLE
1004: , p5_a8 JTF_NUMBER_TABLE
1005: , p5_a9 JTF_NUMBER_TABLE
1006: , p5_a10 JTF_NUMBER_TABLE
1007: , p5_a11 JTF_DATE_TABLE
1000: , p5_a4 JTF_NUMBER_TABLE
1001: , p5_a5 JTF_NUMBER_TABLE
1002: , p5_a6 JTF_NUMBER_TABLE
1003: , p5_a7 JTF_NUMBER_TABLE
1004: , p5_a8 JTF_NUMBER_TABLE
1005: , p5_a9 JTF_NUMBER_TABLE
1006: , p5_a10 JTF_NUMBER_TABLE
1007: , p5_a11 JTF_DATE_TABLE
1008: , p5_a12 JTF_DATE_TABLE
1001: , p5_a5 JTF_NUMBER_TABLE
1002: , p5_a6 JTF_NUMBER_TABLE
1003: , p5_a7 JTF_NUMBER_TABLE
1004: , p5_a8 JTF_NUMBER_TABLE
1005: , p5_a9 JTF_NUMBER_TABLE
1006: , p5_a10 JTF_NUMBER_TABLE
1007: , p5_a11 JTF_DATE_TABLE
1008: , p5_a12 JTF_DATE_TABLE
1009: , p5_a13 JTF_NUMBER_TABLE
1002: , p5_a6 JTF_NUMBER_TABLE
1003: , p5_a7 JTF_NUMBER_TABLE
1004: , p5_a8 JTF_NUMBER_TABLE
1005: , p5_a9 JTF_NUMBER_TABLE
1006: , p5_a10 JTF_NUMBER_TABLE
1007: , p5_a11 JTF_DATE_TABLE
1008: , p5_a12 JTF_DATE_TABLE
1009: , p5_a13 JTF_NUMBER_TABLE
1010: )
1005: , p5_a9 JTF_NUMBER_TABLE
1006: , p5_a10 JTF_NUMBER_TABLE
1007: , p5_a11 JTF_DATE_TABLE
1008: , p5_a12 JTF_DATE_TABLE
1009: , p5_a13 JTF_NUMBER_TABLE
1010: )
1011:
1012: as
1013: ddp_sxpv_tbl okl_sxp_pvt.sxpv_tbl_type;