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_fpr_pvt.fpr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_fpr_pvt.fpr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_fpr_pvt.fpr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
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_fpr_pvt.fpr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
35: begin
36: if a0 is not null and a0.count > 0 then
57: end loop;
58: end if;
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_fpr_pvt.fpr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
58: end if;
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_fpr_pvt.fpr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_fpr_pvt.fpr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
61: procedure rosetta_table_copy_out_p2(t okl_fpr_pvt.fpr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_NUMBER_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
98: a10 := JTF_NUMBER_TABLE();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
100: a0.extend(t.count);
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
100: a0.extend(t.count);
101: a1.extend(t.count);
102: a2.extend(t.count);
131: end if;
132: end if;
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_VARCHAR2_TABLE_300
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_VARCHAR2_TABLE_300
140: , a5 JTF_VARCHAR2_TABLE_800
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE
143: , a8 JTF_NUMBER_TABLE
144: , a9 JTF_DATE_TABLE
145: , a10 JTF_NUMBER_TABLE
139: , a4 JTF_VARCHAR2_TABLE_300
140: , a5 JTF_VARCHAR2_TABLE_800
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE
143: , a8 JTF_NUMBER_TABLE
144: , a9 JTF_DATE_TABLE
145: , a10 JTF_NUMBER_TABLE
146: ) as
147: ddindx binary_integer; indx binary_integer;
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE
143: , a8 JTF_NUMBER_TABLE
144: , a9 JTF_DATE_TABLE
145: , a10 JTF_NUMBER_TABLE
146: ) as
147: ddindx binary_integer; indx binary_integer;
148: begin
149: if a0 is not null and a0.count > 0 then
170: end loop;
171: end if;
172: end if;
173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_VARCHAR2_TABLE_100
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_VARCHAR2_TABLE_300
176: , a2 out nocopy JTF_VARCHAR2_TABLE_100
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_VARCHAR2_TABLE_300
179: , a5 out nocopy JTF_VARCHAR2_TABLE_800
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_DATE_TABLE
184: , a10 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_300
179: , a5 out nocopy JTF_VARCHAR2_TABLE_800
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_DATE_TABLE
184: , a10 out nocopy JTF_NUMBER_TABLE
185: ) as
186: ddindx binary_integer; indx binary_integer;
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_DATE_TABLE
184: , a10 out nocopy JTF_NUMBER_TABLE
185: ) as
186: ddindx binary_integer; indx binary_integer;
187: begin
188: if t is null or t.count = 0 then
185: ) as
186: ddindx binary_integer; indx binary_integer;
187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_VARCHAR2_TABLE_100();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_VARCHAR2_TABLE_300();
191: a2 := JTF_VARCHAR2_TABLE_100();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_VARCHAR2_TABLE_300();
194: a5 := JTF_VARCHAR2_TABLE_800();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();
197: a8 := JTF_NUMBER_TABLE();
198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
193: a4 := JTF_VARCHAR2_TABLE_300();
194: a5 := JTF_VARCHAR2_TABLE_800();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();
197: a8 := JTF_NUMBER_TABLE();
198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();
197: a8 := JTF_NUMBER_TABLE();
198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_VARCHAR2_TABLE_100();
197: a8 := JTF_NUMBER_TABLE();
198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_VARCHAR2_TABLE_300();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_VARCHAR2_TABLE_300();
206: a5 := JTF_VARCHAR2_TABLE_800();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();
209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_DATE_TABLE();
211: a10 := JTF_NUMBER_TABLE();
205: a4 := JTF_VARCHAR2_TABLE_300();
206: a5 := JTF_VARCHAR2_TABLE_800();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();
209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_DATE_TABLE();
211: a10 := JTF_NUMBER_TABLE();
212: if t.count > 0 then
213: a0.extend(t.count);
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();
209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_DATE_TABLE();
211: a10 := JTF_NUMBER_TABLE();
212: if t.count > 0 then
213: a0.extend(t.count);
214: a1.extend(t.count);
215: a2.extend(t.count);
244: end if;
245: end if;
246: end rosetta_table_copy_out_p5;
247:
248: procedure rosetta_table_copy_in_p8(t out nocopy okl_fpr_pvt.fprv_tbl_type, a0 JTF_NUMBER_TABLE
249: , a1 JTF_NUMBER_TABLE
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_NUMBER_TABLE
245: end if;
246: end rosetta_table_copy_out_p5;
247:
248: procedure rosetta_table_copy_in_p8(t out nocopy okl_fpr_pvt.fprv_tbl_type, a0 JTF_NUMBER_TABLE
249: , a1 JTF_NUMBER_TABLE
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_NUMBER_TABLE
253: , a5 JTF_NUMBER_TABLE
247:
248: procedure rosetta_table_copy_in_p8(t out nocopy okl_fpr_pvt.fprv_tbl_type, a0 JTF_NUMBER_TABLE
249: , a1 JTF_NUMBER_TABLE
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_NUMBER_TABLE
253: , a5 JTF_NUMBER_TABLE
254: , a6 JTF_VARCHAR2_TABLE_300
255: , a7 JTF_VARCHAR2_TABLE_800
248: procedure rosetta_table_copy_in_p8(t out nocopy okl_fpr_pvt.fprv_tbl_type, a0 JTF_NUMBER_TABLE
249: , a1 JTF_NUMBER_TABLE
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_NUMBER_TABLE
253: , a5 JTF_NUMBER_TABLE
254: , a6 JTF_VARCHAR2_TABLE_300
255: , a7 JTF_VARCHAR2_TABLE_800
256: , a8 JTF_VARCHAR2_TABLE_100
249: , a1 JTF_NUMBER_TABLE
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_NUMBER_TABLE
253: , a5 JTF_NUMBER_TABLE
254: , a6 JTF_VARCHAR2_TABLE_300
255: , a7 JTF_VARCHAR2_TABLE_800
256: , a8 JTF_VARCHAR2_TABLE_100
257: , a9 JTF_NUMBER_TABLE
253: , a5 JTF_NUMBER_TABLE
254: , a6 JTF_VARCHAR2_TABLE_300
255: , a7 JTF_VARCHAR2_TABLE_800
256: , a8 JTF_VARCHAR2_TABLE_100
257: , a9 JTF_NUMBER_TABLE
258: , a10 JTF_DATE_TABLE
259: , a11 JTF_NUMBER_TABLE
260: , a12 JTF_DATE_TABLE
261: , a13 JTF_NUMBER_TABLE
255: , a7 JTF_VARCHAR2_TABLE_800
256: , a8 JTF_VARCHAR2_TABLE_100
257: , a9 JTF_NUMBER_TABLE
258: , a10 JTF_DATE_TABLE
259: , a11 JTF_NUMBER_TABLE
260: , a12 JTF_DATE_TABLE
261: , a13 JTF_NUMBER_TABLE
262: ) as
263: ddindx binary_integer; indx binary_integer;
257: , a9 JTF_NUMBER_TABLE
258: , a10 JTF_DATE_TABLE
259: , a11 JTF_NUMBER_TABLE
260: , a12 JTF_DATE_TABLE
261: , a13 JTF_NUMBER_TABLE
262: ) as
263: ddindx binary_integer; indx binary_integer;
264: begin
265: if a0 is not null and a0.count > 0 then
289: end loop;
290: end if;
291: end if;
292: end rosetta_table_copy_in_p8;
293: procedure rosetta_table_copy_out_p8(t okl_fpr_pvt.fprv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_VARCHAR2_TABLE_100
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
290: end if;
291: end if;
292: end rosetta_table_copy_in_p8;
293: procedure rosetta_table_copy_out_p8(t okl_fpr_pvt.fprv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_VARCHAR2_TABLE_100
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_NUMBER_TABLE
292: end rosetta_table_copy_in_p8;
293: procedure rosetta_table_copy_out_p8(t okl_fpr_pvt.fprv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_VARCHAR2_TABLE_100
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_NUMBER_TABLE
299: , a6 out nocopy JTF_VARCHAR2_TABLE_300
300: , a7 out nocopy JTF_VARCHAR2_TABLE_800
293: procedure rosetta_table_copy_out_p8(t okl_fpr_pvt.fprv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_VARCHAR2_TABLE_100
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_NUMBER_TABLE
299: , a6 out nocopy JTF_VARCHAR2_TABLE_300
300: , a7 out nocopy JTF_VARCHAR2_TABLE_800
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_VARCHAR2_TABLE_100
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_NUMBER_TABLE
299: , a6 out nocopy JTF_VARCHAR2_TABLE_300
300: , a7 out nocopy JTF_VARCHAR2_TABLE_800
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
302: , a9 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_NUMBER_TABLE
299: , a6 out nocopy JTF_VARCHAR2_TABLE_300
300: , a7 out nocopy JTF_VARCHAR2_TABLE_800
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
302: , a9 out nocopy JTF_NUMBER_TABLE
303: , a10 out nocopy JTF_DATE_TABLE
304: , a11 out nocopy JTF_NUMBER_TABLE
305: , a12 out nocopy JTF_DATE_TABLE
306: , a13 out nocopy JTF_NUMBER_TABLE
300: , a7 out nocopy JTF_VARCHAR2_TABLE_800
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
302: , a9 out nocopy JTF_NUMBER_TABLE
303: , a10 out nocopy JTF_DATE_TABLE
304: , a11 out nocopy JTF_NUMBER_TABLE
305: , a12 out nocopy JTF_DATE_TABLE
306: , a13 out nocopy JTF_NUMBER_TABLE
307: ) as
308: ddindx binary_integer; indx binary_integer;
302: , a9 out nocopy JTF_NUMBER_TABLE
303: , a10 out nocopy JTF_DATE_TABLE
304: , a11 out nocopy JTF_NUMBER_TABLE
305: , a12 out nocopy JTF_DATE_TABLE
306: , a13 out nocopy JTF_NUMBER_TABLE
307: ) as
308: ddindx binary_integer; indx binary_integer;
309: begin
310: if t is null or t.count = 0 then
307: ) as
308: ddindx binary_integer; indx binary_integer;
309: begin
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_NUMBER_TABLE();
308: ddindx binary_integer; indx binary_integer;
309: begin
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_NUMBER_TABLE();
316: a5 := JTF_NUMBER_TABLE();
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_NUMBER_TABLE();
316: a5 := JTF_NUMBER_TABLE();
317: a6 := JTF_VARCHAR2_TABLE_300();
318: a7 := JTF_VARCHAR2_TABLE_800();
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_NUMBER_TABLE();
316: a5 := JTF_NUMBER_TABLE();
317: a6 := JTF_VARCHAR2_TABLE_300();
318: a7 := JTF_VARCHAR2_TABLE_800();
319: a8 := JTF_VARCHAR2_TABLE_100();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_NUMBER_TABLE();
316: a5 := JTF_NUMBER_TABLE();
317: a6 := JTF_VARCHAR2_TABLE_300();
318: a7 := JTF_VARCHAR2_TABLE_800();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_NUMBER_TABLE();
316: a5 := JTF_NUMBER_TABLE();
317: a6 := JTF_VARCHAR2_TABLE_300();
318: a7 := JTF_VARCHAR2_TABLE_800();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_NUMBER_TABLE();
321: a10 := JTF_DATE_TABLE();
322: a11 := JTF_NUMBER_TABLE();
323: a12 := JTF_DATE_TABLE();
324: a13 := JTF_NUMBER_TABLE();
318: a7 := JTF_VARCHAR2_TABLE_800();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_NUMBER_TABLE();
321: a10 := JTF_DATE_TABLE();
322: a11 := JTF_NUMBER_TABLE();
323: a12 := JTF_DATE_TABLE();
324: a13 := JTF_NUMBER_TABLE();
325: else
326: a0 := JTF_NUMBER_TABLE();
320: a9 := JTF_NUMBER_TABLE();
321: a10 := JTF_DATE_TABLE();
322: a11 := JTF_NUMBER_TABLE();
323: a12 := JTF_DATE_TABLE();
324: a13 := JTF_NUMBER_TABLE();
325: else
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_VARCHAR2_TABLE_100();
322: a11 := JTF_NUMBER_TABLE();
323: a12 := JTF_DATE_TABLE();
324: a13 := JTF_NUMBER_TABLE();
325: else
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_VARCHAR2_TABLE_100();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_NUMBER_TABLE();
323: a12 := JTF_DATE_TABLE();
324: a13 := JTF_NUMBER_TABLE();
325: else
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_VARCHAR2_TABLE_100();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_NUMBER_TABLE();
331: a5 := JTF_NUMBER_TABLE();
325: else
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_VARCHAR2_TABLE_100();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_NUMBER_TABLE();
331: a5 := JTF_NUMBER_TABLE();
332: a6 := JTF_VARCHAR2_TABLE_300();
333: a7 := JTF_VARCHAR2_TABLE_800();
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_VARCHAR2_TABLE_100();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_NUMBER_TABLE();
331: a5 := JTF_NUMBER_TABLE();
332: a6 := JTF_VARCHAR2_TABLE_300();
333: a7 := JTF_VARCHAR2_TABLE_800();
334: a8 := JTF_VARCHAR2_TABLE_100();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_VARCHAR2_TABLE_100();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_NUMBER_TABLE();
331: a5 := JTF_NUMBER_TABLE();
332: a6 := JTF_VARCHAR2_TABLE_300();
333: a7 := JTF_VARCHAR2_TABLE_800();
334: a8 := JTF_VARCHAR2_TABLE_100();
335: a9 := JTF_NUMBER_TABLE();
331: a5 := JTF_NUMBER_TABLE();
332: a6 := JTF_VARCHAR2_TABLE_300();
333: a7 := JTF_VARCHAR2_TABLE_800();
334: a8 := JTF_VARCHAR2_TABLE_100();
335: a9 := JTF_NUMBER_TABLE();
336: a10 := JTF_DATE_TABLE();
337: a11 := JTF_NUMBER_TABLE();
338: a12 := JTF_DATE_TABLE();
339: a13 := JTF_NUMBER_TABLE();
333: a7 := JTF_VARCHAR2_TABLE_800();
334: a8 := JTF_VARCHAR2_TABLE_100();
335: a9 := JTF_NUMBER_TABLE();
336: a10 := JTF_DATE_TABLE();
337: a11 := JTF_NUMBER_TABLE();
338: a12 := JTF_DATE_TABLE();
339: a13 := JTF_NUMBER_TABLE();
340: if t.count > 0 then
341: a0.extend(t.count);
335: a9 := JTF_NUMBER_TABLE();
336: a10 := JTF_DATE_TABLE();
337: a11 := JTF_NUMBER_TABLE();
338: a12 := JTF_DATE_TABLE();
339: a13 := JTF_NUMBER_TABLE();
340: if t.count > 0 then
341: a0.extend(t.count);
342: a1.extend(t.count);
343: a2.extend(t.count);
478: , p_init_msg_list VARCHAR2
479: , x_return_status out nocopy VARCHAR2
480: , x_msg_count out nocopy NUMBER
481: , x_msg_data out nocopy VARCHAR2
482: , p5_a0 JTF_NUMBER_TABLE
483: , p5_a1 JTF_NUMBER_TABLE
484: , p5_a2 JTF_VARCHAR2_TABLE_100
485: , p5_a3 JTF_NUMBER_TABLE
486: , p5_a4 JTF_NUMBER_TABLE
479: , x_return_status out nocopy VARCHAR2
480: , x_msg_count out nocopy NUMBER
481: , x_msg_data out nocopy VARCHAR2
482: , p5_a0 JTF_NUMBER_TABLE
483: , p5_a1 JTF_NUMBER_TABLE
484: , p5_a2 JTF_VARCHAR2_TABLE_100
485: , p5_a3 JTF_NUMBER_TABLE
486: , p5_a4 JTF_NUMBER_TABLE
487: , p5_a5 JTF_NUMBER_TABLE
481: , x_msg_data out nocopy VARCHAR2
482: , p5_a0 JTF_NUMBER_TABLE
483: , p5_a1 JTF_NUMBER_TABLE
484: , p5_a2 JTF_VARCHAR2_TABLE_100
485: , p5_a3 JTF_NUMBER_TABLE
486: , p5_a4 JTF_NUMBER_TABLE
487: , p5_a5 JTF_NUMBER_TABLE
488: , p5_a6 JTF_VARCHAR2_TABLE_300
489: , p5_a7 JTF_VARCHAR2_TABLE_800
482: , p5_a0 JTF_NUMBER_TABLE
483: , p5_a1 JTF_NUMBER_TABLE
484: , p5_a2 JTF_VARCHAR2_TABLE_100
485: , p5_a3 JTF_NUMBER_TABLE
486: , p5_a4 JTF_NUMBER_TABLE
487: , p5_a5 JTF_NUMBER_TABLE
488: , p5_a6 JTF_VARCHAR2_TABLE_300
489: , p5_a7 JTF_VARCHAR2_TABLE_800
490: , p5_a8 JTF_VARCHAR2_TABLE_100
483: , p5_a1 JTF_NUMBER_TABLE
484: , p5_a2 JTF_VARCHAR2_TABLE_100
485: , p5_a3 JTF_NUMBER_TABLE
486: , p5_a4 JTF_NUMBER_TABLE
487: , p5_a5 JTF_NUMBER_TABLE
488: , p5_a6 JTF_VARCHAR2_TABLE_300
489: , p5_a7 JTF_VARCHAR2_TABLE_800
490: , p5_a8 JTF_VARCHAR2_TABLE_100
491: , p5_a9 JTF_NUMBER_TABLE
487: , p5_a5 JTF_NUMBER_TABLE
488: , p5_a6 JTF_VARCHAR2_TABLE_300
489: , p5_a7 JTF_VARCHAR2_TABLE_800
490: , p5_a8 JTF_VARCHAR2_TABLE_100
491: , p5_a9 JTF_NUMBER_TABLE
492: , p5_a10 JTF_DATE_TABLE
493: , p5_a11 JTF_NUMBER_TABLE
494: , p5_a12 JTF_DATE_TABLE
495: , p5_a13 JTF_NUMBER_TABLE
489: , p5_a7 JTF_VARCHAR2_TABLE_800
490: , p5_a8 JTF_VARCHAR2_TABLE_100
491: , p5_a9 JTF_NUMBER_TABLE
492: , p5_a10 JTF_DATE_TABLE
493: , p5_a11 JTF_NUMBER_TABLE
494: , p5_a12 JTF_DATE_TABLE
495: , p5_a13 JTF_NUMBER_TABLE
496: , p6_a0 out nocopy JTF_NUMBER_TABLE
497: , p6_a1 out nocopy JTF_NUMBER_TABLE
491: , p5_a9 JTF_NUMBER_TABLE
492: , p5_a10 JTF_DATE_TABLE
493: , p5_a11 JTF_NUMBER_TABLE
494: , p5_a12 JTF_DATE_TABLE
495: , p5_a13 JTF_NUMBER_TABLE
496: , p6_a0 out nocopy JTF_NUMBER_TABLE
497: , p6_a1 out nocopy JTF_NUMBER_TABLE
498: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
499: , p6_a3 out nocopy JTF_NUMBER_TABLE
492: , p5_a10 JTF_DATE_TABLE
493: , p5_a11 JTF_NUMBER_TABLE
494: , p5_a12 JTF_DATE_TABLE
495: , p5_a13 JTF_NUMBER_TABLE
496: , p6_a0 out nocopy JTF_NUMBER_TABLE
497: , p6_a1 out nocopy JTF_NUMBER_TABLE
498: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
499: , p6_a3 out nocopy JTF_NUMBER_TABLE
500: , p6_a4 out nocopy JTF_NUMBER_TABLE
493: , p5_a11 JTF_NUMBER_TABLE
494: , p5_a12 JTF_DATE_TABLE
495: , p5_a13 JTF_NUMBER_TABLE
496: , p6_a0 out nocopy JTF_NUMBER_TABLE
497: , p6_a1 out nocopy JTF_NUMBER_TABLE
498: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
499: , p6_a3 out nocopy JTF_NUMBER_TABLE
500: , p6_a4 out nocopy JTF_NUMBER_TABLE
501: , p6_a5 out nocopy JTF_NUMBER_TABLE
495: , p5_a13 JTF_NUMBER_TABLE
496: , p6_a0 out nocopy JTF_NUMBER_TABLE
497: , p6_a1 out nocopy JTF_NUMBER_TABLE
498: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
499: , p6_a3 out nocopy JTF_NUMBER_TABLE
500: , p6_a4 out nocopy JTF_NUMBER_TABLE
501: , p6_a5 out nocopy JTF_NUMBER_TABLE
502: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
503: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
496: , p6_a0 out nocopy JTF_NUMBER_TABLE
497: , p6_a1 out nocopy JTF_NUMBER_TABLE
498: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
499: , p6_a3 out nocopy JTF_NUMBER_TABLE
500: , p6_a4 out nocopy JTF_NUMBER_TABLE
501: , p6_a5 out nocopy JTF_NUMBER_TABLE
502: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
503: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
504: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
497: , p6_a1 out nocopy JTF_NUMBER_TABLE
498: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
499: , p6_a3 out nocopy JTF_NUMBER_TABLE
500: , p6_a4 out nocopy JTF_NUMBER_TABLE
501: , p6_a5 out nocopy JTF_NUMBER_TABLE
502: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
503: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
504: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a9 out nocopy JTF_NUMBER_TABLE
501: , p6_a5 out nocopy JTF_NUMBER_TABLE
502: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
503: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
504: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a9 out nocopy JTF_NUMBER_TABLE
506: , p6_a10 out nocopy JTF_DATE_TABLE
507: , p6_a11 out nocopy JTF_NUMBER_TABLE
508: , p6_a12 out nocopy JTF_DATE_TABLE
509: , p6_a13 out nocopy JTF_NUMBER_TABLE
503: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
504: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a9 out nocopy JTF_NUMBER_TABLE
506: , p6_a10 out nocopy JTF_DATE_TABLE
507: , p6_a11 out nocopy JTF_NUMBER_TABLE
508: , p6_a12 out nocopy JTF_DATE_TABLE
509: , p6_a13 out nocopy JTF_NUMBER_TABLE
510: )
511:
505: , p6_a9 out nocopy JTF_NUMBER_TABLE
506: , p6_a10 out nocopy JTF_DATE_TABLE
507: , p6_a11 out nocopy JTF_NUMBER_TABLE
508: , p6_a12 out nocopy JTF_DATE_TABLE
509: , p6_a13 out nocopy JTF_NUMBER_TABLE
510: )
511:
512: as
513: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
638: , p_init_msg_list VARCHAR2
639: , x_return_status out nocopy VARCHAR2
640: , x_msg_count out nocopy NUMBER
641: , x_msg_data out nocopy VARCHAR2
642: , p5_a0 JTF_NUMBER_TABLE
643: , p5_a1 JTF_NUMBER_TABLE
644: , p5_a2 JTF_VARCHAR2_TABLE_100
645: , p5_a3 JTF_NUMBER_TABLE
646: , p5_a4 JTF_NUMBER_TABLE
639: , x_return_status out nocopy VARCHAR2
640: , x_msg_count out nocopy NUMBER
641: , x_msg_data out nocopy VARCHAR2
642: , p5_a0 JTF_NUMBER_TABLE
643: , p5_a1 JTF_NUMBER_TABLE
644: , p5_a2 JTF_VARCHAR2_TABLE_100
645: , p5_a3 JTF_NUMBER_TABLE
646: , p5_a4 JTF_NUMBER_TABLE
647: , p5_a5 JTF_NUMBER_TABLE
641: , x_msg_data out nocopy VARCHAR2
642: , p5_a0 JTF_NUMBER_TABLE
643: , p5_a1 JTF_NUMBER_TABLE
644: , p5_a2 JTF_VARCHAR2_TABLE_100
645: , p5_a3 JTF_NUMBER_TABLE
646: , p5_a4 JTF_NUMBER_TABLE
647: , p5_a5 JTF_NUMBER_TABLE
648: , p5_a6 JTF_VARCHAR2_TABLE_300
649: , p5_a7 JTF_VARCHAR2_TABLE_800
642: , p5_a0 JTF_NUMBER_TABLE
643: , p5_a1 JTF_NUMBER_TABLE
644: , p5_a2 JTF_VARCHAR2_TABLE_100
645: , p5_a3 JTF_NUMBER_TABLE
646: , p5_a4 JTF_NUMBER_TABLE
647: , p5_a5 JTF_NUMBER_TABLE
648: , p5_a6 JTF_VARCHAR2_TABLE_300
649: , p5_a7 JTF_VARCHAR2_TABLE_800
650: , p5_a8 JTF_VARCHAR2_TABLE_100
643: , p5_a1 JTF_NUMBER_TABLE
644: , p5_a2 JTF_VARCHAR2_TABLE_100
645: , p5_a3 JTF_NUMBER_TABLE
646: , p5_a4 JTF_NUMBER_TABLE
647: , p5_a5 JTF_NUMBER_TABLE
648: , p5_a6 JTF_VARCHAR2_TABLE_300
649: , p5_a7 JTF_VARCHAR2_TABLE_800
650: , p5_a8 JTF_VARCHAR2_TABLE_100
651: , p5_a9 JTF_NUMBER_TABLE
647: , p5_a5 JTF_NUMBER_TABLE
648: , p5_a6 JTF_VARCHAR2_TABLE_300
649: , p5_a7 JTF_VARCHAR2_TABLE_800
650: , p5_a8 JTF_VARCHAR2_TABLE_100
651: , p5_a9 JTF_NUMBER_TABLE
652: , p5_a10 JTF_DATE_TABLE
653: , p5_a11 JTF_NUMBER_TABLE
654: , p5_a12 JTF_DATE_TABLE
655: , p5_a13 JTF_NUMBER_TABLE
649: , p5_a7 JTF_VARCHAR2_TABLE_800
650: , p5_a8 JTF_VARCHAR2_TABLE_100
651: , p5_a9 JTF_NUMBER_TABLE
652: , p5_a10 JTF_DATE_TABLE
653: , p5_a11 JTF_NUMBER_TABLE
654: , p5_a12 JTF_DATE_TABLE
655: , p5_a13 JTF_NUMBER_TABLE
656: )
657:
651: , p5_a9 JTF_NUMBER_TABLE
652: , p5_a10 JTF_DATE_TABLE
653: , p5_a11 JTF_NUMBER_TABLE
654: , p5_a12 JTF_DATE_TABLE
655: , p5_a13 JTF_NUMBER_TABLE
656: )
657:
658: as
659: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
797: , p_init_msg_list VARCHAR2
798: , x_return_status out nocopy VARCHAR2
799: , x_msg_count out nocopy NUMBER
800: , x_msg_data out nocopy VARCHAR2
801: , p5_a0 JTF_NUMBER_TABLE
802: , p5_a1 JTF_NUMBER_TABLE
803: , p5_a2 JTF_VARCHAR2_TABLE_100
804: , p5_a3 JTF_NUMBER_TABLE
805: , p5_a4 JTF_NUMBER_TABLE
798: , x_return_status out nocopy VARCHAR2
799: , x_msg_count out nocopy NUMBER
800: , x_msg_data out nocopy VARCHAR2
801: , p5_a0 JTF_NUMBER_TABLE
802: , p5_a1 JTF_NUMBER_TABLE
803: , p5_a2 JTF_VARCHAR2_TABLE_100
804: , p5_a3 JTF_NUMBER_TABLE
805: , p5_a4 JTF_NUMBER_TABLE
806: , p5_a5 JTF_NUMBER_TABLE
800: , x_msg_data out nocopy VARCHAR2
801: , p5_a0 JTF_NUMBER_TABLE
802: , p5_a1 JTF_NUMBER_TABLE
803: , p5_a2 JTF_VARCHAR2_TABLE_100
804: , p5_a3 JTF_NUMBER_TABLE
805: , p5_a4 JTF_NUMBER_TABLE
806: , p5_a5 JTF_NUMBER_TABLE
807: , p5_a6 JTF_VARCHAR2_TABLE_300
808: , p5_a7 JTF_VARCHAR2_TABLE_800
801: , p5_a0 JTF_NUMBER_TABLE
802: , p5_a1 JTF_NUMBER_TABLE
803: , p5_a2 JTF_VARCHAR2_TABLE_100
804: , p5_a3 JTF_NUMBER_TABLE
805: , p5_a4 JTF_NUMBER_TABLE
806: , p5_a5 JTF_NUMBER_TABLE
807: , p5_a6 JTF_VARCHAR2_TABLE_300
808: , p5_a7 JTF_VARCHAR2_TABLE_800
809: , p5_a8 JTF_VARCHAR2_TABLE_100
802: , p5_a1 JTF_NUMBER_TABLE
803: , p5_a2 JTF_VARCHAR2_TABLE_100
804: , p5_a3 JTF_NUMBER_TABLE
805: , p5_a4 JTF_NUMBER_TABLE
806: , p5_a5 JTF_NUMBER_TABLE
807: , p5_a6 JTF_VARCHAR2_TABLE_300
808: , p5_a7 JTF_VARCHAR2_TABLE_800
809: , p5_a8 JTF_VARCHAR2_TABLE_100
810: , p5_a9 JTF_NUMBER_TABLE
806: , p5_a5 JTF_NUMBER_TABLE
807: , p5_a6 JTF_VARCHAR2_TABLE_300
808: , p5_a7 JTF_VARCHAR2_TABLE_800
809: , p5_a8 JTF_VARCHAR2_TABLE_100
810: , p5_a9 JTF_NUMBER_TABLE
811: , p5_a10 JTF_DATE_TABLE
812: , p5_a11 JTF_NUMBER_TABLE
813: , p5_a12 JTF_DATE_TABLE
814: , p5_a13 JTF_NUMBER_TABLE
808: , p5_a7 JTF_VARCHAR2_TABLE_800
809: , p5_a8 JTF_VARCHAR2_TABLE_100
810: , p5_a9 JTF_NUMBER_TABLE
811: , p5_a10 JTF_DATE_TABLE
812: , p5_a11 JTF_NUMBER_TABLE
813: , p5_a12 JTF_DATE_TABLE
814: , p5_a13 JTF_NUMBER_TABLE
815: , p6_a0 out nocopy JTF_NUMBER_TABLE
816: , p6_a1 out nocopy JTF_NUMBER_TABLE
810: , p5_a9 JTF_NUMBER_TABLE
811: , p5_a10 JTF_DATE_TABLE
812: , p5_a11 JTF_NUMBER_TABLE
813: , p5_a12 JTF_DATE_TABLE
814: , p5_a13 JTF_NUMBER_TABLE
815: , p6_a0 out nocopy JTF_NUMBER_TABLE
816: , p6_a1 out nocopy JTF_NUMBER_TABLE
817: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
818: , p6_a3 out nocopy JTF_NUMBER_TABLE
811: , p5_a10 JTF_DATE_TABLE
812: , p5_a11 JTF_NUMBER_TABLE
813: , p5_a12 JTF_DATE_TABLE
814: , p5_a13 JTF_NUMBER_TABLE
815: , p6_a0 out nocopy JTF_NUMBER_TABLE
816: , p6_a1 out nocopy JTF_NUMBER_TABLE
817: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
818: , p6_a3 out nocopy JTF_NUMBER_TABLE
819: , p6_a4 out nocopy JTF_NUMBER_TABLE
812: , p5_a11 JTF_NUMBER_TABLE
813: , p5_a12 JTF_DATE_TABLE
814: , p5_a13 JTF_NUMBER_TABLE
815: , p6_a0 out nocopy JTF_NUMBER_TABLE
816: , p6_a1 out nocopy JTF_NUMBER_TABLE
817: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
818: , p6_a3 out nocopy JTF_NUMBER_TABLE
819: , p6_a4 out nocopy JTF_NUMBER_TABLE
820: , p6_a5 out nocopy JTF_NUMBER_TABLE
814: , p5_a13 JTF_NUMBER_TABLE
815: , p6_a0 out nocopy JTF_NUMBER_TABLE
816: , p6_a1 out nocopy JTF_NUMBER_TABLE
817: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
818: , p6_a3 out nocopy JTF_NUMBER_TABLE
819: , p6_a4 out nocopy JTF_NUMBER_TABLE
820: , p6_a5 out nocopy JTF_NUMBER_TABLE
821: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
822: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
815: , p6_a0 out nocopy JTF_NUMBER_TABLE
816: , p6_a1 out nocopy JTF_NUMBER_TABLE
817: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
818: , p6_a3 out nocopy JTF_NUMBER_TABLE
819: , p6_a4 out nocopy JTF_NUMBER_TABLE
820: , p6_a5 out nocopy JTF_NUMBER_TABLE
821: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
822: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
823: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
816: , p6_a1 out nocopy JTF_NUMBER_TABLE
817: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
818: , p6_a3 out nocopy JTF_NUMBER_TABLE
819: , p6_a4 out nocopy JTF_NUMBER_TABLE
820: , p6_a5 out nocopy JTF_NUMBER_TABLE
821: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
822: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
823: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
824: , p6_a9 out nocopy JTF_NUMBER_TABLE
820: , p6_a5 out nocopy JTF_NUMBER_TABLE
821: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
822: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
823: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
824: , p6_a9 out nocopy JTF_NUMBER_TABLE
825: , p6_a10 out nocopy JTF_DATE_TABLE
826: , p6_a11 out nocopy JTF_NUMBER_TABLE
827: , p6_a12 out nocopy JTF_DATE_TABLE
828: , p6_a13 out nocopy JTF_NUMBER_TABLE
822: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
823: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
824: , p6_a9 out nocopy JTF_NUMBER_TABLE
825: , p6_a10 out nocopy JTF_DATE_TABLE
826: , p6_a11 out nocopy JTF_NUMBER_TABLE
827: , p6_a12 out nocopy JTF_DATE_TABLE
828: , p6_a13 out nocopy JTF_NUMBER_TABLE
829: )
830:
824: , p6_a9 out nocopy JTF_NUMBER_TABLE
825: , p6_a10 out nocopy JTF_DATE_TABLE
826: , p6_a11 out nocopy JTF_NUMBER_TABLE
827: , p6_a12 out nocopy JTF_DATE_TABLE
828: , p6_a13 out nocopy JTF_NUMBER_TABLE
829: )
830:
831: as
832: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
957: , p_init_msg_list VARCHAR2
958: , x_return_status out nocopy VARCHAR2
959: , x_msg_count out nocopy NUMBER
960: , x_msg_data out nocopy VARCHAR2
961: , p5_a0 JTF_NUMBER_TABLE
962: , p5_a1 JTF_NUMBER_TABLE
963: , p5_a2 JTF_VARCHAR2_TABLE_100
964: , p5_a3 JTF_NUMBER_TABLE
965: , p5_a4 JTF_NUMBER_TABLE
958: , x_return_status out nocopy VARCHAR2
959: , x_msg_count out nocopy NUMBER
960: , x_msg_data out nocopy VARCHAR2
961: , p5_a0 JTF_NUMBER_TABLE
962: , p5_a1 JTF_NUMBER_TABLE
963: , p5_a2 JTF_VARCHAR2_TABLE_100
964: , p5_a3 JTF_NUMBER_TABLE
965: , p5_a4 JTF_NUMBER_TABLE
966: , p5_a5 JTF_NUMBER_TABLE
960: , x_msg_data out nocopy VARCHAR2
961: , p5_a0 JTF_NUMBER_TABLE
962: , p5_a1 JTF_NUMBER_TABLE
963: , p5_a2 JTF_VARCHAR2_TABLE_100
964: , p5_a3 JTF_NUMBER_TABLE
965: , p5_a4 JTF_NUMBER_TABLE
966: , p5_a5 JTF_NUMBER_TABLE
967: , p5_a6 JTF_VARCHAR2_TABLE_300
968: , p5_a7 JTF_VARCHAR2_TABLE_800
961: , p5_a0 JTF_NUMBER_TABLE
962: , p5_a1 JTF_NUMBER_TABLE
963: , p5_a2 JTF_VARCHAR2_TABLE_100
964: , p5_a3 JTF_NUMBER_TABLE
965: , p5_a4 JTF_NUMBER_TABLE
966: , p5_a5 JTF_NUMBER_TABLE
967: , p5_a6 JTF_VARCHAR2_TABLE_300
968: , p5_a7 JTF_VARCHAR2_TABLE_800
969: , p5_a8 JTF_VARCHAR2_TABLE_100
962: , p5_a1 JTF_NUMBER_TABLE
963: , p5_a2 JTF_VARCHAR2_TABLE_100
964: , p5_a3 JTF_NUMBER_TABLE
965: , p5_a4 JTF_NUMBER_TABLE
966: , p5_a5 JTF_NUMBER_TABLE
967: , p5_a6 JTF_VARCHAR2_TABLE_300
968: , p5_a7 JTF_VARCHAR2_TABLE_800
969: , p5_a8 JTF_VARCHAR2_TABLE_100
970: , p5_a9 JTF_NUMBER_TABLE
966: , p5_a5 JTF_NUMBER_TABLE
967: , p5_a6 JTF_VARCHAR2_TABLE_300
968: , p5_a7 JTF_VARCHAR2_TABLE_800
969: , p5_a8 JTF_VARCHAR2_TABLE_100
970: , p5_a9 JTF_NUMBER_TABLE
971: , p5_a10 JTF_DATE_TABLE
972: , p5_a11 JTF_NUMBER_TABLE
973: , p5_a12 JTF_DATE_TABLE
974: , p5_a13 JTF_NUMBER_TABLE
968: , p5_a7 JTF_VARCHAR2_TABLE_800
969: , p5_a8 JTF_VARCHAR2_TABLE_100
970: , p5_a9 JTF_NUMBER_TABLE
971: , p5_a10 JTF_DATE_TABLE
972: , p5_a11 JTF_NUMBER_TABLE
973: , p5_a12 JTF_DATE_TABLE
974: , p5_a13 JTF_NUMBER_TABLE
975: )
976:
970: , p5_a9 JTF_NUMBER_TABLE
971: , p5_a10 JTF_DATE_TABLE
972: , p5_a11 JTF_NUMBER_TABLE
973: , p5_a12 JTF_DATE_TABLE
974: , p5_a13 JTF_NUMBER_TABLE
975: )
976:
977: as
978: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;
1084: , p_init_msg_list VARCHAR2
1085: , x_return_status out nocopy VARCHAR2
1086: , x_msg_count out nocopy NUMBER
1087: , x_msg_data out nocopy VARCHAR2
1088: , p5_a0 JTF_NUMBER_TABLE
1089: , p5_a1 JTF_NUMBER_TABLE
1090: , p5_a2 JTF_VARCHAR2_TABLE_100
1091: , p5_a3 JTF_NUMBER_TABLE
1092: , p5_a4 JTF_NUMBER_TABLE
1085: , x_return_status out nocopy VARCHAR2
1086: , x_msg_count out nocopy NUMBER
1087: , x_msg_data out nocopy VARCHAR2
1088: , p5_a0 JTF_NUMBER_TABLE
1089: , p5_a1 JTF_NUMBER_TABLE
1090: , p5_a2 JTF_VARCHAR2_TABLE_100
1091: , p5_a3 JTF_NUMBER_TABLE
1092: , p5_a4 JTF_NUMBER_TABLE
1093: , p5_a5 JTF_NUMBER_TABLE
1087: , x_msg_data out nocopy VARCHAR2
1088: , p5_a0 JTF_NUMBER_TABLE
1089: , p5_a1 JTF_NUMBER_TABLE
1090: , p5_a2 JTF_VARCHAR2_TABLE_100
1091: , p5_a3 JTF_NUMBER_TABLE
1092: , p5_a4 JTF_NUMBER_TABLE
1093: , p5_a5 JTF_NUMBER_TABLE
1094: , p5_a6 JTF_VARCHAR2_TABLE_300
1095: , p5_a7 JTF_VARCHAR2_TABLE_800
1088: , p5_a0 JTF_NUMBER_TABLE
1089: , p5_a1 JTF_NUMBER_TABLE
1090: , p5_a2 JTF_VARCHAR2_TABLE_100
1091: , p5_a3 JTF_NUMBER_TABLE
1092: , p5_a4 JTF_NUMBER_TABLE
1093: , p5_a5 JTF_NUMBER_TABLE
1094: , p5_a6 JTF_VARCHAR2_TABLE_300
1095: , p5_a7 JTF_VARCHAR2_TABLE_800
1096: , p5_a8 JTF_VARCHAR2_TABLE_100
1089: , p5_a1 JTF_NUMBER_TABLE
1090: , p5_a2 JTF_VARCHAR2_TABLE_100
1091: , p5_a3 JTF_NUMBER_TABLE
1092: , p5_a4 JTF_NUMBER_TABLE
1093: , p5_a5 JTF_NUMBER_TABLE
1094: , p5_a6 JTF_VARCHAR2_TABLE_300
1095: , p5_a7 JTF_VARCHAR2_TABLE_800
1096: , p5_a8 JTF_VARCHAR2_TABLE_100
1097: , p5_a9 JTF_NUMBER_TABLE
1093: , p5_a5 JTF_NUMBER_TABLE
1094: , p5_a6 JTF_VARCHAR2_TABLE_300
1095: , p5_a7 JTF_VARCHAR2_TABLE_800
1096: , p5_a8 JTF_VARCHAR2_TABLE_100
1097: , p5_a9 JTF_NUMBER_TABLE
1098: , p5_a10 JTF_DATE_TABLE
1099: , p5_a11 JTF_NUMBER_TABLE
1100: , p5_a12 JTF_DATE_TABLE
1101: , p5_a13 JTF_NUMBER_TABLE
1095: , p5_a7 JTF_VARCHAR2_TABLE_800
1096: , p5_a8 JTF_VARCHAR2_TABLE_100
1097: , p5_a9 JTF_NUMBER_TABLE
1098: , p5_a10 JTF_DATE_TABLE
1099: , p5_a11 JTF_NUMBER_TABLE
1100: , p5_a12 JTF_DATE_TABLE
1101: , p5_a13 JTF_NUMBER_TABLE
1102: )
1103:
1097: , p5_a9 JTF_NUMBER_TABLE
1098: , p5_a10 JTF_DATE_TABLE
1099: , p5_a11 JTF_NUMBER_TABLE
1100: , p5_a12 JTF_DATE_TABLE
1101: , p5_a13 JTF_NUMBER_TABLE
1102: )
1103:
1104: as
1105: ddp_fprv_tbl okl_fpr_pvt.fprv_tbl_type;