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_pmr_pvt.pmr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_pmr_pvt.pmr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: ) as
33: ddindx binary_integer; indx binary_integer;
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if a0 is not null and a0.count > 0 then
55: end loop;
56: end if;
57: end if;
58: end rosetta_table_copy_in_p2;
59: procedure rosetta_table_copy_out_p2(t okl_pmr_pvt.pmr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_200
61: , a2 out nocopy JTF_VARCHAR2_TABLE_200
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: end rosetta_table_copy_in_p2;
59: procedure rosetta_table_copy_out_p2(t okl_pmr_pvt.pmr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_200
61: , a2 out nocopy JTF_VARCHAR2_TABLE_200
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_DATE_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_200
61: , a2 out nocopy JTF_VARCHAR2_TABLE_200
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_DATE_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_DATE_TABLE
68: , a9 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_DATE_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_DATE_TABLE
68: , a9 out nocopy JTF_NUMBER_TABLE
69: ) as
70: ddindx binary_integer; indx binary_integer;
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_DATE_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_DATE_TABLE
68: , a9 out nocopy JTF_NUMBER_TABLE
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_200();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_200();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_200();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_DATE_TABLE();
82: a9 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_DATE_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: else
84: a0 := JTF_NUMBER_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_DATE_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_200();
86: a2 := JTF_VARCHAR2_TABLE_200();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_DATE_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_200();
86: a2 := JTF_VARCHAR2_TABLE_200();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_VARCHAR2_TABLE_100();
83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_200();
86: a2 := JTF_VARCHAR2_TABLE_200();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_DATE_TABLE();
91: a7 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_200();
86: a2 := JTF_VARCHAR2_TABLE_200();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_DATE_TABLE();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_DATE_TABLE();
93: a9 := JTF_NUMBER_TABLE();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_DATE_TABLE();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_DATE_TABLE();
93: a9 := JTF_NUMBER_TABLE();
94: if t.count > 0 then
95: a0.extend(t.count);
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_DATE_TABLE();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_DATE_TABLE();
93: a9 := JTF_NUMBER_TABLE();
94: if t.count > 0 then
95: a0.extend(t.count);
96: a1.extend(t.count);
97: a2.extend(t.count);
124: end if;
125: end if;
126: end rosetta_table_copy_out_p2;
127:
128: procedure rosetta_table_copy_in_p5(t out nocopy okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_100
132: , a4 JTF_VARCHAR2_TABLE_2000
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_100
132: , a4 JTF_VARCHAR2_TABLE_2000
133: , a5 JTF_NUMBER_TABLE
134: , a6 JTF_DATE_TABLE
135: , a7 JTF_NUMBER_TABLE
136: , a8 JTF_DATE_TABLE
137: , a9 JTF_NUMBER_TABLE
131: , a3 JTF_VARCHAR2_TABLE_100
132: , a4 JTF_VARCHAR2_TABLE_2000
133: , a5 JTF_NUMBER_TABLE
134: , a6 JTF_DATE_TABLE
135: , a7 JTF_NUMBER_TABLE
136: , a8 JTF_DATE_TABLE
137: , a9 JTF_NUMBER_TABLE
138: ) as
139: ddindx binary_integer; indx binary_integer;
133: , a5 JTF_NUMBER_TABLE
134: , a6 JTF_DATE_TABLE
135: , a7 JTF_NUMBER_TABLE
136: , a8 JTF_DATE_TABLE
137: , a9 JTF_NUMBER_TABLE
138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin
141: if a0 is not null and a0.count > 0 then
161: end loop;
162: end if;
163: end if;
164: end rosetta_table_copy_in_p5;
165: procedure rosetta_table_copy_out_p5(t okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
166: , a1 out nocopy JTF_VARCHAR2_TABLE_100
167: , a2 out nocopy JTF_VARCHAR2_TABLE_100
168: , a3 out nocopy JTF_VARCHAR2_TABLE_100
169: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
166: , a1 out nocopy JTF_VARCHAR2_TABLE_100
167: , a2 out nocopy JTF_VARCHAR2_TABLE_100
168: , a3 out nocopy JTF_VARCHAR2_TABLE_100
169: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
170: , a5 out nocopy JTF_NUMBER_TABLE
171: , a6 out nocopy JTF_DATE_TABLE
172: , a7 out nocopy JTF_NUMBER_TABLE
173: , a8 out nocopy JTF_DATE_TABLE
174: , a9 out nocopy JTF_NUMBER_TABLE
168: , a3 out nocopy JTF_VARCHAR2_TABLE_100
169: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
170: , a5 out nocopy JTF_NUMBER_TABLE
171: , a6 out nocopy JTF_DATE_TABLE
172: , a7 out nocopy JTF_NUMBER_TABLE
173: , a8 out nocopy JTF_DATE_TABLE
174: , a9 out nocopy JTF_NUMBER_TABLE
175: ) as
176: ddindx binary_integer; indx binary_integer;
170: , a5 out nocopy JTF_NUMBER_TABLE
171: , a6 out nocopy JTF_DATE_TABLE
172: , a7 out nocopy JTF_NUMBER_TABLE
173: , a8 out nocopy JTF_DATE_TABLE
174: , a9 out nocopy JTF_NUMBER_TABLE
175: ) as
176: ddindx binary_integer; indx binary_integer;
177: begin
178: if t is null or t.count = 0 then
175: ) as
176: ddindx binary_integer; indx binary_integer;
177: begin
178: if t is null or t.count = 0 then
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_VARCHAR2_TABLE_100();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_2000();
180: a1 := JTF_VARCHAR2_TABLE_100();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_2000();
184: a5 := JTF_NUMBER_TABLE();
185: a6 := JTF_DATE_TABLE();
186: a7 := JTF_NUMBER_TABLE();
187: a8 := JTF_DATE_TABLE();
188: a9 := JTF_NUMBER_TABLE();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_2000();
184: a5 := JTF_NUMBER_TABLE();
185: a6 := JTF_DATE_TABLE();
186: a7 := JTF_NUMBER_TABLE();
187: a8 := JTF_DATE_TABLE();
188: a9 := JTF_NUMBER_TABLE();
189: else
190: a0 := JTF_NUMBER_TABLE();
184: a5 := JTF_NUMBER_TABLE();
185: a6 := JTF_DATE_TABLE();
186: a7 := JTF_NUMBER_TABLE();
187: a8 := JTF_DATE_TABLE();
188: a9 := JTF_NUMBER_TABLE();
189: else
190: a0 := JTF_NUMBER_TABLE();
191: a1 := JTF_VARCHAR2_TABLE_100();
192: a2 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_NUMBER_TABLE();
187: a8 := JTF_DATE_TABLE();
188: a9 := JTF_NUMBER_TABLE();
189: else
190: a0 := JTF_NUMBER_TABLE();
191: a1 := JTF_VARCHAR2_TABLE_100();
192: a2 := JTF_VARCHAR2_TABLE_100();
193: a3 := JTF_VARCHAR2_TABLE_100();
194: a4 := JTF_VARCHAR2_TABLE_2000();
191: a1 := JTF_VARCHAR2_TABLE_100();
192: a2 := JTF_VARCHAR2_TABLE_100();
193: a3 := JTF_VARCHAR2_TABLE_100();
194: a4 := JTF_VARCHAR2_TABLE_2000();
195: a5 := JTF_NUMBER_TABLE();
196: a6 := JTF_DATE_TABLE();
197: a7 := JTF_NUMBER_TABLE();
198: a8 := JTF_DATE_TABLE();
199: a9 := JTF_NUMBER_TABLE();
193: a3 := JTF_VARCHAR2_TABLE_100();
194: a4 := JTF_VARCHAR2_TABLE_2000();
195: a5 := JTF_NUMBER_TABLE();
196: a6 := JTF_DATE_TABLE();
197: a7 := JTF_NUMBER_TABLE();
198: a8 := JTF_DATE_TABLE();
199: a9 := JTF_NUMBER_TABLE();
200: if t.count > 0 then
201: a0.extend(t.count);
195: a5 := JTF_NUMBER_TABLE();
196: a6 := JTF_DATE_TABLE();
197: a7 := JTF_NUMBER_TABLE();
198: a8 := JTF_DATE_TABLE();
199: a9 := JTF_NUMBER_TABLE();
200: if t.count > 0 then
201: a0.extend(t.count);
202: a1.extend(t.count);
203: a2.extend(t.count);
230: end if;
231: end if;
232: end rosetta_table_copy_out_p5;
233:
234: procedure rosetta_table_copy_in_p8(t out nocopy okl_pmr_pvt.pmrv_tbl_type, a0 JTF_NUMBER_TABLE
235: , a1 JTF_NUMBER_TABLE
236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_VARCHAR2_TABLE_100
238: , a4 JTF_VARCHAR2_TABLE_200
231: end if;
232: end rosetta_table_copy_out_p5;
233:
234: procedure rosetta_table_copy_in_p8(t out nocopy okl_pmr_pvt.pmrv_tbl_type, a0 JTF_NUMBER_TABLE
235: , a1 JTF_NUMBER_TABLE
236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_VARCHAR2_TABLE_100
238: , a4 JTF_VARCHAR2_TABLE_200
239: , a5 JTF_VARCHAR2_TABLE_200
237: , a3 JTF_VARCHAR2_TABLE_100
238: , a4 JTF_VARCHAR2_TABLE_200
239: , a5 JTF_VARCHAR2_TABLE_200
240: , a6 JTF_VARCHAR2_TABLE_2000
241: , a7 JTF_NUMBER_TABLE
242: , a8 JTF_DATE_TABLE
243: , a9 JTF_NUMBER_TABLE
244: , a10 JTF_DATE_TABLE
245: , a11 JTF_NUMBER_TABLE
239: , a5 JTF_VARCHAR2_TABLE_200
240: , a6 JTF_VARCHAR2_TABLE_2000
241: , a7 JTF_NUMBER_TABLE
242: , a8 JTF_DATE_TABLE
243: , a9 JTF_NUMBER_TABLE
244: , a10 JTF_DATE_TABLE
245: , a11 JTF_NUMBER_TABLE
246: ) as
247: ddindx binary_integer; indx binary_integer;
241: , a7 JTF_NUMBER_TABLE
242: , a8 JTF_DATE_TABLE
243: , a9 JTF_NUMBER_TABLE
244: , a10 JTF_DATE_TABLE
245: , a11 JTF_NUMBER_TABLE
246: ) as
247: ddindx binary_integer; indx binary_integer;
248: begin
249: if a0 is not null and a0.count > 0 then
271: end loop;
272: end if;
273: end if;
274: end rosetta_table_copy_in_p8;
275: procedure rosetta_table_copy_out_p8(t okl_pmr_pvt.pmrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
276: , a1 out nocopy JTF_NUMBER_TABLE
277: , a2 out nocopy JTF_VARCHAR2_TABLE_100
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
272: end if;
273: end if;
274: end rosetta_table_copy_in_p8;
275: procedure rosetta_table_copy_out_p8(t okl_pmr_pvt.pmrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
276: , a1 out nocopy JTF_NUMBER_TABLE
277: , a2 out nocopy JTF_VARCHAR2_TABLE_100
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
280: , a5 out nocopy JTF_VARCHAR2_TABLE_200
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
280: , a5 out nocopy JTF_VARCHAR2_TABLE_200
281: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
282: , a7 out nocopy JTF_NUMBER_TABLE
283: , a8 out nocopy JTF_DATE_TABLE
284: , a9 out nocopy JTF_NUMBER_TABLE
285: , a10 out nocopy JTF_DATE_TABLE
286: , a11 out nocopy JTF_NUMBER_TABLE
280: , a5 out nocopy JTF_VARCHAR2_TABLE_200
281: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
282: , a7 out nocopy JTF_NUMBER_TABLE
283: , a8 out nocopy JTF_DATE_TABLE
284: , a9 out nocopy JTF_NUMBER_TABLE
285: , a10 out nocopy JTF_DATE_TABLE
286: , a11 out nocopy JTF_NUMBER_TABLE
287: ) as
288: ddindx binary_integer; indx binary_integer;
282: , a7 out nocopy JTF_NUMBER_TABLE
283: , a8 out nocopy JTF_DATE_TABLE
284: , a9 out nocopy JTF_NUMBER_TABLE
285: , a10 out nocopy JTF_DATE_TABLE
286: , a11 out nocopy JTF_NUMBER_TABLE
287: ) as
288: ddindx binary_integer; indx binary_integer;
289: begin
290: if t is null or t.count = 0 then
287: ) as
288: ddindx binary_integer; indx binary_integer;
289: begin
290: if t is null or t.count = 0 then
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_VARCHAR2_TABLE_100();
294: a3 := JTF_VARCHAR2_TABLE_100();
295: a4 := JTF_VARCHAR2_TABLE_200();
288: ddindx binary_integer; indx binary_integer;
289: begin
290: if t is null or t.count = 0 then
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_VARCHAR2_TABLE_100();
294: a3 := JTF_VARCHAR2_TABLE_100();
295: a4 := JTF_VARCHAR2_TABLE_200();
296: a5 := JTF_VARCHAR2_TABLE_200();
294: a3 := JTF_VARCHAR2_TABLE_100();
295: a4 := JTF_VARCHAR2_TABLE_200();
296: a5 := JTF_VARCHAR2_TABLE_200();
297: a6 := JTF_VARCHAR2_TABLE_2000();
298: a7 := JTF_NUMBER_TABLE();
299: a8 := JTF_DATE_TABLE();
300: a9 := JTF_NUMBER_TABLE();
301: a10 := JTF_DATE_TABLE();
302: a11 := JTF_NUMBER_TABLE();
296: a5 := JTF_VARCHAR2_TABLE_200();
297: a6 := JTF_VARCHAR2_TABLE_2000();
298: a7 := JTF_NUMBER_TABLE();
299: a8 := JTF_DATE_TABLE();
300: a9 := JTF_NUMBER_TABLE();
301: a10 := JTF_DATE_TABLE();
302: a11 := JTF_NUMBER_TABLE();
303: else
304: a0 := JTF_NUMBER_TABLE();
298: a7 := JTF_NUMBER_TABLE();
299: a8 := JTF_DATE_TABLE();
300: a9 := JTF_NUMBER_TABLE();
301: a10 := JTF_DATE_TABLE();
302: a11 := JTF_NUMBER_TABLE();
303: else
304: a0 := JTF_NUMBER_TABLE();
305: a1 := JTF_NUMBER_TABLE();
306: a2 := JTF_VARCHAR2_TABLE_100();
300: a9 := JTF_NUMBER_TABLE();
301: a10 := JTF_DATE_TABLE();
302: a11 := JTF_NUMBER_TABLE();
303: else
304: a0 := JTF_NUMBER_TABLE();
305: a1 := JTF_NUMBER_TABLE();
306: a2 := JTF_VARCHAR2_TABLE_100();
307: a3 := JTF_VARCHAR2_TABLE_100();
308: a4 := JTF_VARCHAR2_TABLE_200();
301: a10 := JTF_DATE_TABLE();
302: a11 := JTF_NUMBER_TABLE();
303: else
304: a0 := JTF_NUMBER_TABLE();
305: a1 := JTF_NUMBER_TABLE();
306: a2 := JTF_VARCHAR2_TABLE_100();
307: a3 := JTF_VARCHAR2_TABLE_100();
308: a4 := JTF_VARCHAR2_TABLE_200();
309: a5 := JTF_VARCHAR2_TABLE_200();
307: a3 := JTF_VARCHAR2_TABLE_100();
308: a4 := JTF_VARCHAR2_TABLE_200();
309: a5 := JTF_VARCHAR2_TABLE_200();
310: a6 := JTF_VARCHAR2_TABLE_2000();
311: a7 := JTF_NUMBER_TABLE();
312: a8 := JTF_DATE_TABLE();
313: a9 := JTF_NUMBER_TABLE();
314: a10 := JTF_DATE_TABLE();
315: a11 := JTF_NUMBER_TABLE();
309: a5 := JTF_VARCHAR2_TABLE_200();
310: a6 := JTF_VARCHAR2_TABLE_2000();
311: a7 := JTF_NUMBER_TABLE();
312: a8 := JTF_DATE_TABLE();
313: a9 := JTF_NUMBER_TABLE();
314: a10 := JTF_DATE_TABLE();
315: a11 := JTF_NUMBER_TABLE();
316: if t.count > 0 then
317: a0.extend(t.count);
311: a7 := JTF_NUMBER_TABLE();
312: a8 := JTF_DATE_TABLE();
313: a9 := JTF_NUMBER_TABLE();
314: a10 := JTF_DATE_TABLE();
315: a11 := JTF_NUMBER_TABLE();
316: if t.count > 0 then
317: a0.extend(t.count);
318: a1.extend(t.count);
319: a2.extend(t.count);
442: , p_init_msg_list VARCHAR2
443: , x_return_status out nocopy VARCHAR2
444: , x_msg_count out nocopy NUMBER
445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_NUMBER_TABLE
448: , p5_a2 JTF_VARCHAR2_TABLE_100
449: , p5_a3 JTF_VARCHAR2_TABLE_100
450: , p5_a4 JTF_VARCHAR2_TABLE_200
443: , x_return_status out nocopy VARCHAR2
444: , x_msg_count out nocopy NUMBER
445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_NUMBER_TABLE
448: , p5_a2 JTF_VARCHAR2_TABLE_100
449: , p5_a3 JTF_VARCHAR2_TABLE_100
450: , p5_a4 JTF_VARCHAR2_TABLE_200
451: , p5_a5 JTF_VARCHAR2_TABLE_200
449: , p5_a3 JTF_VARCHAR2_TABLE_100
450: , p5_a4 JTF_VARCHAR2_TABLE_200
451: , p5_a5 JTF_VARCHAR2_TABLE_200
452: , p5_a6 JTF_VARCHAR2_TABLE_2000
453: , p5_a7 JTF_NUMBER_TABLE
454: , p5_a8 JTF_DATE_TABLE
455: , p5_a9 JTF_NUMBER_TABLE
456: , p5_a10 JTF_DATE_TABLE
457: , p5_a11 JTF_NUMBER_TABLE
451: , p5_a5 JTF_VARCHAR2_TABLE_200
452: , p5_a6 JTF_VARCHAR2_TABLE_2000
453: , p5_a7 JTF_NUMBER_TABLE
454: , p5_a8 JTF_DATE_TABLE
455: , p5_a9 JTF_NUMBER_TABLE
456: , p5_a10 JTF_DATE_TABLE
457: , p5_a11 JTF_NUMBER_TABLE
458: , p6_a0 out nocopy JTF_NUMBER_TABLE
459: , p6_a1 out nocopy JTF_NUMBER_TABLE
453: , p5_a7 JTF_NUMBER_TABLE
454: , p5_a8 JTF_DATE_TABLE
455: , p5_a9 JTF_NUMBER_TABLE
456: , p5_a10 JTF_DATE_TABLE
457: , p5_a11 JTF_NUMBER_TABLE
458: , p6_a0 out nocopy JTF_NUMBER_TABLE
459: , p6_a1 out nocopy JTF_NUMBER_TABLE
460: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
454: , p5_a8 JTF_DATE_TABLE
455: , p5_a9 JTF_NUMBER_TABLE
456: , p5_a10 JTF_DATE_TABLE
457: , p5_a11 JTF_NUMBER_TABLE
458: , p6_a0 out nocopy JTF_NUMBER_TABLE
459: , p6_a1 out nocopy JTF_NUMBER_TABLE
460: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
455: , p5_a9 JTF_NUMBER_TABLE
456: , p5_a10 JTF_DATE_TABLE
457: , p5_a11 JTF_NUMBER_TABLE
458: , p6_a0 out nocopy JTF_NUMBER_TABLE
459: , p6_a1 out nocopy JTF_NUMBER_TABLE
460: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
463: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
461: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
463: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
464: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
465: , p6_a7 out nocopy JTF_NUMBER_TABLE
466: , p6_a8 out nocopy JTF_DATE_TABLE
467: , p6_a9 out nocopy JTF_NUMBER_TABLE
468: , p6_a10 out nocopy JTF_DATE_TABLE
469: , p6_a11 out nocopy JTF_NUMBER_TABLE
463: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
464: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
465: , p6_a7 out nocopy JTF_NUMBER_TABLE
466: , p6_a8 out nocopy JTF_DATE_TABLE
467: , p6_a9 out nocopy JTF_NUMBER_TABLE
468: , p6_a10 out nocopy JTF_DATE_TABLE
469: , p6_a11 out nocopy JTF_NUMBER_TABLE
470: )
471:
465: , p6_a7 out nocopy JTF_NUMBER_TABLE
466: , p6_a8 out nocopy JTF_DATE_TABLE
467: , p6_a9 out nocopy JTF_NUMBER_TABLE
468: , p6_a10 out nocopy JTF_DATE_TABLE
469: , p6_a11 out nocopy JTF_NUMBER_TABLE
470: )
471:
472: as
473: ddp_pmrv_tbl okl_pmr_pvt.pmrv_tbl_type;
590: , p_init_msg_list VARCHAR2
591: , x_return_status out nocopy VARCHAR2
592: , x_msg_count out nocopy NUMBER
593: , x_msg_data out nocopy VARCHAR2
594: , p5_a0 JTF_NUMBER_TABLE
595: , p5_a1 JTF_NUMBER_TABLE
596: , p5_a2 JTF_VARCHAR2_TABLE_100
597: , p5_a3 JTF_VARCHAR2_TABLE_100
598: , p5_a4 JTF_VARCHAR2_TABLE_200
591: , x_return_status out nocopy VARCHAR2
592: , x_msg_count out nocopy NUMBER
593: , x_msg_data out nocopy VARCHAR2
594: , p5_a0 JTF_NUMBER_TABLE
595: , p5_a1 JTF_NUMBER_TABLE
596: , p5_a2 JTF_VARCHAR2_TABLE_100
597: , p5_a3 JTF_VARCHAR2_TABLE_100
598: , p5_a4 JTF_VARCHAR2_TABLE_200
599: , p5_a5 JTF_VARCHAR2_TABLE_200
597: , p5_a3 JTF_VARCHAR2_TABLE_100
598: , p5_a4 JTF_VARCHAR2_TABLE_200
599: , p5_a5 JTF_VARCHAR2_TABLE_200
600: , p5_a6 JTF_VARCHAR2_TABLE_2000
601: , p5_a7 JTF_NUMBER_TABLE
602: , p5_a8 JTF_DATE_TABLE
603: , p5_a9 JTF_NUMBER_TABLE
604: , p5_a10 JTF_DATE_TABLE
605: , p5_a11 JTF_NUMBER_TABLE
599: , p5_a5 JTF_VARCHAR2_TABLE_200
600: , p5_a6 JTF_VARCHAR2_TABLE_2000
601: , p5_a7 JTF_NUMBER_TABLE
602: , p5_a8 JTF_DATE_TABLE
603: , p5_a9 JTF_NUMBER_TABLE
604: , p5_a10 JTF_DATE_TABLE
605: , p5_a11 JTF_NUMBER_TABLE
606: )
607:
601: , p5_a7 JTF_NUMBER_TABLE
602: , p5_a8 JTF_DATE_TABLE
603: , p5_a9 JTF_NUMBER_TABLE
604: , p5_a10 JTF_DATE_TABLE
605: , p5_a11 JTF_NUMBER_TABLE
606: )
607:
608: as
609: ddp_pmrv_tbl okl_pmr_pvt.pmrv_tbl_type;
737: , p_init_msg_list VARCHAR2
738: , x_return_status out nocopy VARCHAR2
739: , x_msg_count out nocopy NUMBER
740: , x_msg_data out nocopy VARCHAR2
741: , p5_a0 JTF_NUMBER_TABLE
742: , p5_a1 JTF_NUMBER_TABLE
743: , p5_a2 JTF_VARCHAR2_TABLE_100
744: , p5_a3 JTF_VARCHAR2_TABLE_100
745: , p5_a4 JTF_VARCHAR2_TABLE_200
738: , x_return_status out nocopy VARCHAR2
739: , x_msg_count out nocopy NUMBER
740: , x_msg_data out nocopy VARCHAR2
741: , p5_a0 JTF_NUMBER_TABLE
742: , p5_a1 JTF_NUMBER_TABLE
743: , p5_a2 JTF_VARCHAR2_TABLE_100
744: , p5_a3 JTF_VARCHAR2_TABLE_100
745: , p5_a4 JTF_VARCHAR2_TABLE_200
746: , p5_a5 JTF_VARCHAR2_TABLE_200
744: , p5_a3 JTF_VARCHAR2_TABLE_100
745: , p5_a4 JTF_VARCHAR2_TABLE_200
746: , p5_a5 JTF_VARCHAR2_TABLE_200
747: , p5_a6 JTF_VARCHAR2_TABLE_2000
748: , p5_a7 JTF_NUMBER_TABLE
749: , p5_a8 JTF_DATE_TABLE
750: , p5_a9 JTF_NUMBER_TABLE
751: , p5_a10 JTF_DATE_TABLE
752: , p5_a11 JTF_NUMBER_TABLE
746: , p5_a5 JTF_VARCHAR2_TABLE_200
747: , p5_a6 JTF_VARCHAR2_TABLE_2000
748: , p5_a7 JTF_NUMBER_TABLE
749: , p5_a8 JTF_DATE_TABLE
750: , p5_a9 JTF_NUMBER_TABLE
751: , p5_a10 JTF_DATE_TABLE
752: , p5_a11 JTF_NUMBER_TABLE
753: , p6_a0 out nocopy JTF_NUMBER_TABLE
754: , p6_a1 out nocopy JTF_NUMBER_TABLE
748: , p5_a7 JTF_NUMBER_TABLE
749: , p5_a8 JTF_DATE_TABLE
750: , p5_a9 JTF_NUMBER_TABLE
751: , p5_a10 JTF_DATE_TABLE
752: , p5_a11 JTF_NUMBER_TABLE
753: , p6_a0 out nocopy JTF_NUMBER_TABLE
754: , p6_a1 out nocopy JTF_NUMBER_TABLE
755: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
749: , p5_a8 JTF_DATE_TABLE
750: , p5_a9 JTF_NUMBER_TABLE
751: , p5_a10 JTF_DATE_TABLE
752: , p5_a11 JTF_NUMBER_TABLE
753: , p6_a0 out nocopy JTF_NUMBER_TABLE
754: , p6_a1 out nocopy JTF_NUMBER_TABLE
755: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
757: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
750: , p5_a9 JTF_NUMBER_TABLE
751: , p5_a10 JTF_DATE_TABLE
752: , p5_a11 JTF_NUMBER_TABLE
753: , p6_a0 out nocopy JTF_NUMBER_TABLE
754: , p6_a1 out nocopy JTF_NUMBER_TABLE
755: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
757: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
758: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
756: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
757: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
758: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
759: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
760: , p6_a7 out nocopy JTF_NUMBER_TABLE
761: , p6_a8 out nocopy JTF_DATE_TABLE
762: , p6_a9 out nocopy JTF_NUMBER_TABLE
763: , p6_a10 out nocopy JTF_DATE_TABLE
764: , p6_a11 out nocopy JTF_NUMBER_TABLE
758: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
759: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
760: , p6_a7 out nocopy JTF_NUMBER_TABLE
761: , p6_a8 out nocopy JTF_DATE_TABLE
762: , p6_a9 out nocopy JTF_NUMBER_TABLE
763: , p6_a10 out nocopy JTF_DATE_TABLE
764: , p6_a11 out nocopy JTF_NUMBER_TABLE
765: )
766:
760: , p6_a7 out nocopy JTF_NUMBER_TABLE
761: , p6_a8 out nocopy JTF_DATE_TABLE
762: , p6_a9 out nocopy JTF_NUMBER_TABLE
763: , p6_a10 out nocopy JTF_DATE_TABLE
764: , p6_a11 out nocopy JTF_NUMBER_TABLE
765: )
766:
767: as
768: ddp_pmrv_tbl okl_pmr_pvt.pmrv_tbl_type;
885: , p_init_msg_list VARCHAR2
886: , x_return_status out nocopy VARCHAR2
887: , x_msg_count out nocopy NUMBER
888: , x_msg_data out nocopy VARCHAR2
889: , p5_a0 JTF_NUMBER_TABLE
890: , p5_a1 JTF_NUMBER_TABLE
891: , p5_a2 JTF_VARCHAR2_TABLE_100
892: , p5_a3 JTF_VARCHAR2_TABLE_100
893: , p5_a4 JTF_VARCHAR2_TABLE_200
886: , x_return_status out nocopy VARCHAR2
887: , x_msg_count out nocopy NUMBER
888: , x_msg_data out nocopy VARCHAR2
889: , p5_a0 JTF_NUMBER_TABLE
890: , p5_a1 JTF_NUMBER_TABLE
891: , p5_a2 JTF_VARCHAR2_TABLE_100
892: , p5_a3 JTF_VARCHAR2_TABLE_100
893: , p5_a4 JTF_VARCHAR2_TABLE_200
894: , p5_a5 JTF_VARCHAR2_TABLE_200
892: , p5_a3 JTF_VARCHAR2_TABLE_100
893: , p5_a4 JTF_VARCHAR2_TABLE_200
894: , p5_a5 JTF_VARCHAR2_TABLE_200
895: , p5_a6 JTF_VARCHAR2_TABLE_2000
896: , p5_a7 JTF_NUMBER_TABLE
897: , p5_a8 JTF_DATE_TABLE
898: , p5_a9 JTF_NUMBER_TABLE
899: , p5_a10 JTF_DATE_TABLE
900: , p5_a11 JTF_NUMBER_TABLE
894: , p5_a5 JTF_VARCHAR2_TABLE_200
895: , p5_a6 JTF_VARCHAR2_TABLE_2000
896: , p5_a7 JTF_NUMBER_TABLE
897: , p5_a8 JTF_DATE_TABLE
898: , p5_a9 JTF_NUMBER_TABLE
899: , p5_a10 JTF_DATE_TABLE
900: , p5_a11 JTF_NUMBER_TABLE
901: )
902:
896: , p5_a7 JTF_NUMBER_TABLE
897: , p5_a8 JTF_DATE_TABLE
898: , p5_a9 JTF_NUMBER_TABLE
899: , p5_a10 JTF_DATE_TABLE
900: , p5_a11 JTF_NUMBER_TABLE
901: )
902:
903: as
904: ddp_pmrv_tbl okl_pmr_pvt.pmrv_tbl_type;
1004: , p_init_msg_list VARCHAR2
1005: , x_return_status out nocopy VARCHAR2
1006: , x_msg_count out nocopy NUMBER
1007: , x_msg_data out nocopy VARCHAR2
1008: , p5_a0 JTF_NUMBER_TABLE
1009: , p5_a1 JTF_NUMBER_TABLE
1010: , p5_a2 JTF_VARCHAR2_TABLE_100
1011: , p5_a3 JTF_VARCHAR2_TABLE_100
1012: , p5_a4 JTF_VARCHAR2_TABLE_200
1005: , x_return_status out nocopy VARCHAR2
1006: , x_msg_count out nocopy NUMBER
1007: , x_msg_data out nocopy VARCHAR2
1008: , p5_a0 JTF_NUMBER_TABLE
1009: , p5_a1 JTF_NUMBER_TABLE
1010: , p5_a2 JTF_VARCHAR2_TABLE_100
1011: , p5_a3 JTF_VARCHAR2_TABLE_100
1012: , p5_a4 JTF_VARCHAR2_TABLE_200
1013: , p5_a5 JTF_VARCHAR2_TABLE_200
1011: , p5_a3 JTF_VARCHAR2_TABLE_100
1012: , p5_a4 JTF_VARCHAR2_TABLE_200
1013: , p5_a5 JTF_VARCHAR2_TABLE_200
1014: , p5_a6 JTF_VARCHAR2_TABLE_2000
1015: , p5_a7 JTF_NUMBER_TABLE
1016: , p5_a8 JTF_DATE_TABLE
1017: , p5_a9 JTF_NUMBER_TABLE
1018: , p5_a10 JTF_DATE_TABLE
1019: , p5_a11 JTF_NUMBER_TABLE
1013: , p5_a5 JTF_VARCHAR2_TABLE_200
1014: , p5_a6 JTF_VARCHAR2_TABLE_2000
1015: , p5_a7 JTF_NUMBER_TABLE
1016: , p5_a8 JTF_DATE_TABLE
1017: , p5_a9 JTF_NUMBER_TABLE
1018: , p5_a10 JTF_DATE_TABLE
1019: , p5_a11 JTF_NUMBER_TABLE
1020: )
1021:
1015: , p5_a7 JTF_NUMBER_TABLE
1016: , p5_a8 JTF_DATE_TABLE
1017: , p5_a9 JTF_NUMBER_TABLE
1018: , p5_a10 JTF_DATE_TABLE
1019: , p5_a11 JTF_NUMBER_TABLE
1020: )
1021:
1022: as
1023: ddp_pmrv_tbl okl_pmr_pvt.pmrv_tbl_type;