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_sta_pvt.sta_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_sta_pvt.sta_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_sta_pvt.sta_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_VARCHAR2_TABLE_100
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sta_pvt.sta_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_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_VARCHAR2_TABLE_500
31: , a9 JTF_VARCHAR2_TABLE_500
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
52: if a0 is not null and a0.count > 0 then
89: end loop;
90: end if;
91: end if;
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_NUMBER_TABLE
90: end if;
91: end if;
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_NUMBER_TABLE
98: , a5 out nocopy JTF_NUMBER_TABLE
91: end if;
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_NUMBER_TABLE
98: , a5 out nocopy JTF_NUMBER_TABLE
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
93: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_NUMBER_TABLE
98: , a5 out nocopy JTF_NUMBER_TABLE
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_VARCHAR2_TABLE_500
101: , a8 out nocopy JTF_VARCHAR2_TABLE_500
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_NUMBER_TABLE
98: , a5 out nocopy JTF_NUMBER_TABLE
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_VARCHAR2_TABLE_500
101: , a8 out nocopy JTF_VARCHAR2_TABLE_500
102: , a9 out nocopy JTF_VARCHAR2_TABLE_500
111: , a18 out nocopy JTF_VARCHAR2_TABLE_500
112: , a19 out nocopy JTF_VARCHAR2_TABLE_500
113: , a20 out nocopy JTF_VARCHAR2_TABLE_500
114: , a21 out nocopy JTF_VARCHAR2_TABLE_500
115: , a22 out nocopy JTF_NUMBER_TABLE
116: , a23 out nocopy JTF_DATE_TABLE
117: , a24 out nocopy JTF_NUMBER_TABLE
118: , a25 out nocopy JTF_DATE_TABLE
119: , a26 out nocopy JTF_NUMBER_TABLE
113: , a20 out nocopy JTF_VARCHAR2_TABLE_500
114: , a21 out nocopy JTF_VARCHAR2_TABLE_500
115: , a22 out nocopy JTF_NUMBER_TABLE
116: , a23 out nocopy JTF_DATE_TABLE
117: , a24 out nocopy JTF_NUMBER_TABLE
118: , a25 out nocopy JTF_DATE_TABLE
119: , a26 out nocopy JTF_NUMBER_TABLE
120: ) as
121: ddindx binary_integer; indx binary_integer;
115: , a22 out nocopy JTF_NUMBER_TABLE
116: , a23 out nocopy JTF_DATE_TABLE
117: , a24 out nocopy JTF_NUMBER_TABLE
118: , a25 out nocopy JTF_DATE_TABLE
119: , a26 out nocopy JTF_NUMBER_TABLE
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_500();
132: a8 := JTF_VARCHAR2_TABLE_500();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_500();
132: a8 := JTF_VARCHAR2_TABLE_500();
133: a9 := JTF_VARCHAR2_TABLE_500();
142: a18 := JTF_VARCHAR2_TABLE_500();
143: a19 := JTF_VARCHAR2_TABLE_500();
144: a20 := JTF_VARCHAR2_TABLE_500();
145: a21 := JTF_VARCHAR2_TABLE_500();
146: a22 := JTF_NUMBER_TABLE();
147: a23 := JTF_DATE_TABLE();
148: a24 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
144: a20 := JTF_VARCHAR2_TABLE_500();
145: a21 := JTF_VARCHAR2_TABLE_500();
146: a22 := JTF_NUMBER_TABLE();
147: a23 := JTF_DATE_TABLE();
148: a24 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
146: a22 := JTF_NUMBER_TABLE();
147: a23 := JTF_DATE_TABLE();
148: a24 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_NUMBER_TABLE();
154: a2 := JTF_NUMBER_TABLE();
148: a24 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_NUMBER_TABLE();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_VARCHAR2_TABLE_100();
156: a4 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_NUMBER_TABLE();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_VARCHAR2_TABLE_100();
156: a4 := JTF_NUMBER_TABLE();
157: a5 := JTF_NUMBER_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_NUMBER_TABLE();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_VARCHAR2_TABLE_100();
156: a4 := JTF_NUMBER_TABLE();
157: a5 := JTF_NUMBER_TABLE();
158: a6 := JTF_VARCHAR2_TABLE_100();
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_NUMBER_TABLE();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_VARCHAR2_TABLE_100();
156: a4 := JTF_NUMBER_TABLE();
157: a5 := JTF_NUMBER_TABLE();
158: a6 := JTF_VARCHAR2_TABLE_100();
159: a7 := JTF_VARCHAR2_TABLE_500();
160: a8 := JTF_VARCHAR2_TABLE_500();
153: a1 := JTF_NUMBER_TABLE();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_VARCHAR2_TABLE_100();
156: a4 := JTF_NUMBER_TABLE();
157: a5 := JTF_NUMBER_TABLE();
158: a6 := JTF_VARCHAR2_TABLE_100();
159: a7 := JTF_VARCHAR2_TABLE_500();
160: a8 := JTF_VARCHAR2_TABLE_500();
161: a9 := JTF_VARCHAR2_TABLE_500();
170: a18 := JTF_VARCHAR2_TABLE_500();
171: a19 := JTF_VARCHAR2_TABLE_500();
172: a20 := JTF_VARCHAR2_TABLE_500();
173: a21 := JTF_VARCHAR2_TABLE_500();
174: a22 := JTF_NUMBER_TABLE();
175: a23 := JTF_DATE_TABLE();
176: a24 := JTF_NUMBER_TABLE();
177: a25 := JTF_DATE_TABLE();
178: a26 := JTF_NUMBER_TABLE();
172: a20 := JTF_VARCHAR2_TABLE_500();
173: a21 := JTF_VARCHAR2_TABLE_500();
174: a22 := JTF_NUMBER_TABLE();
175: a23 := JTF_DATE_TABLE();
176: a24 := JTF_NUMBER_TABLE();
177: a25 := JTF_DATE_TABLE();
178: a26 := JTF_NUMBER_TABLE();
179: if t.count > 0 then
180: a0.extend(t.count);
174: a22 := JTF_NUMBER_TABLE();
175: a23 := JTF_DATE_TABLE();
176: a24 := JTF_NUMBER_TABLE();
177: a25 := JTF_DATE_TABLE();
178: a26 := JTF_NUMBER_TABLE();
179: if t.count > 0 then
180: a0.extend(t.count);
181: a1.extend(t.count);
182: a2.extend(t.count);
243: end if;
244: end if;
245: end rosetta_table_copy_out_p2;
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
244: end if;
245: end rosetta_table_copy_out_p2;
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_VARCHAR2_TABLE_100
245: end rosetta_table_copy_out_p2;
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_VARCHAR2_TABLE_100
253: , a6 JTF_VARCHAR2_TABLE_500
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_VARCHAR2_TABLE_100
253: , a6 JTF_VARCHAR2_TABLE_500
254: , a7 JTF_VARCHAR2_TABLE_500
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_VARCHAR2_TABLE_100
253: , a6 JTF_VARCHAR2_TABLE_500
254: , a7 JTF_VARCHAR2_TABLE_500
255: , a8 JTF_VARCHAR2_TABLE_500
265: , a18 JTF_VARCHAR2_TABLE_500
266: , a19 JTF_VARCHAR2_TABLE_500
267: , a20 JTF_VARCHAR2_TABLE_500
268: , a21 JTF_VARCHAR2_TABLE_100
269: , a22 JTF_NUMBER_TABLE
270: , a23 JTF_DATE_TABLE
271: , a24 JTF_NUMBER_TABLE
272: , a25 JTF_DATE_TABLE
273: , a26 JTF_NUMBER_TABLE
267: , a20 JTF_VARCHAR2_TABLE_500
268: , a21 JTF_VARCHAR2_TABLE_100
269: , a22 JTF_NUMBER_TABLE
270: , a23 JTF_DATE_TABLE
271: , a24 JTF_NUMBER_TABLE
272: , a25 JTF_DATE_TABLE
273: , a26 JTF_NUMBER_TABLE
274: ) as
275: ddindx binary_integer; indx binary_integer;
269: , a22 JTF_NUMBER_TABLE
270: , a23 JTF_DATE_TABLE
271: , a24 JTF_NUMBER_TABLE
272: , a25 JTF_DATE_TABLE
273: , a26 JTF_NUMBER_TABLE
274: ) as
275: ddindx binary_integer; indx binary_integer;
276: begin
277: if a0 is not null and a0.count > 0 then
314: end loop;
315: end if;
316: end if;
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
315: end if;
316: end if;
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_VARCHAR2_TABLE_100
316: end if;
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_VARCHAR2_TABLE_100
324: , a6 out nocopy JTF_VARCHAR2_TABLE_500
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_VARCHAR2_TABLE_100
324: , a6 out nocopy JTF_VARCHAR2_TABLE_500
325: , a7 out nocopy JTF_VARCHAR2_TABLE_500
318: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_VARCHAR2_TABLE_100
324: , a6 out nocopy JTF_VARCHAR2_TABLE_500
325: , a7 out nocopy JTF_VARCHAR2_TABLE_500
326: , a8 out nocopy JTF_VARCHAR2_TABLE_500
336: , a18 out nocopy JTF_VARCHAR2_TABLE_500
337: , a19 out nocopy JTF_VARCHAR2_TABLE_500
338: , a20 out nocopy JTF_VARCHAR2_TABLE_500
339: , a21 out nocopy JTF_VARCHAR2_TABLE_100
340: , a22 out nocopy JTF_NUMBER_TABLE
341: , a23 out nocopy JTF_DATE_TABLE
342: , a24 out nocopy JTF_NUMBER_TABLE
343: , a25 out nocopy JTF_DATE_TABLE
344: , a26 out nocopy JTF_NUMBER_TABLE
338: , a20 out nocopy JTF_VARCHAR2_TABLE_500
339: , a21 out nocopy JTF_VARCHAR2_TABLE_100
340: , a22 out nocopy JTF_NUMBER_TABLE
341: , a23 out nocopy JTF_DATE_TABLE
342: , a24 out nocopy JTF_NUMBER_TABLE
343: , a25 out nocopy JTF_DATE_TABLE
344: , a26 out nocopy JTF_NUMBER_TABLE
345: ) as
346: ddindx binary_integer; indx binary_integer;
340: , a22 out nocopy JTF_NUMBER_TABLE
341: , a23 out nocopy JTF_DATE_TABLE
342: , a24 out nocopy JTF_NUMBER_TABLE
343: , a25 out nocopy JTF_DATE_TABLE
344: , a26 out nocopy JTF_NUMBER_TABLE
345: ) as
346: ddindx binary_integer; indx binary_integer;
347: begin
348: if t is null or t.count = 0 then
345: ) as
346: ddindx binary_integer; indx binary_integer;
347: begin
348: if t is null or t.count = 0 then
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
346: ddindx binary_integer; indx binary_integer;
347: begin
348: if t is null or t.count = 0 then
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_VARCHAR2_TABLE_100();
347: begin
348: if t is null or t.count = 0 then
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_VARCHAR2_TABLE_100();
355: a6 := JTF_VARCHAR2_TABLE_500();
348: if t is null or t.count = 0 then
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_VARCHAR2_TABLE_100();
355: a6 := JTF_VARCHAR2_TABLE_500();
356: a7 := JTF_VARCHAR2_TABLE_500();
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_VARCHAR2_TABLE_100();
355: a6 := JTF_VARCHAR2_TABLE_500();
356: a7 := JTF_VARCHAR2_TABLE_500();
357: a8 := JTF_VARCHAR2_TABLE_500();
367: a18 := JTF_VARCHAR2_TABLE_500();
368: a19 := JTF_VARCHAR2_TABLE_500();
369: a20 := JTF_VARCHAR2_TABLE_500();
370: a21 := JTF_VARCHAR2_TABLE_100();
371: a22 := JTF_NUMBER_TABLE();
372: a23 := JTF_DATE_TABLE();
373: a24 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
375: a26 := JTF_NUMBER_TABLE();
369: a20 := JTF_VARCHAR2_TABLE_500();
370: a21 := JTF_VARCHAR2_TABLE_100();
371: a22 := JTF_NUMBER_TABLE();
372: a23 := JTF_DATE_TABLE();
373: a24 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_NUMBER_TABLE();
371: a22 := JTF_NUMBER_TABLE();
372: a23 := JTF_DATE_TABLE();
373: a24 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
373: a24 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_VARCHAR2_TABLE_100();
375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_VARCHAR2_TABLE_500();
376: else
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_VARCHAR2_TABLE_500();
384: a7 := JTF_VARCHAR2_TABLE_500();
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_VARCHAR2_TABLE_500();
384: a7 := JTF_VARCHAR2_TABLE_500();
385: a8 := JTF_VARCHAR2_TABLE_500();
395: a18 := JTF_VARCHAR2_TABLE_500();
396: a19 := JTF_VARCHAR2_TABLE_500();
397: a20 := JTF_VARCHAR2_TABLE_500();
398: a21 := JTF_VARCHAR2_TABLE_100();
399: a22 := JTF_NUMBER_TABLE();
400: a23 := JTF_DATE_TABLE();
401: a24 := JTF_NUMBER_TABLE();
402: a25 := JTF_DATE_TABLE();
403: a26 := JTF_NUMBER_TABLE();
397: a20 := JTF_VARCHAR2_TABLE_500();
398: a21 := JTF_VARCHAR2_TABLE_100();
399: a22 := JTF_NUMBER_TABLE();
400: a23 := JTF_DATE_TABLE();
401: a24 := JTF_NUMBER_TABLE();
402: a25 := JTF_DATE_TABLE();
403: a26 := JTF_NUMBER_TABLE();
404: if t.count > 0 then
405: a0.extend(t.count);
399: a22 := JTF_NUMBER_TABLE();
400: a23 := JTF_DATE_TABLE();
401: a24 := JTF_NUMBER_TABLE();
402: a25 := JTF_DATE_TABLE();
403: a26 := JTF_NUMBER_TABLE();
404: if t.count > 0 then
405: a0.extend(t.count);
406: a1.extend(t.count);
407: a2.extend(t.count);
620: , p_init_msg_list VARCHAR2
621: , x_return_status out nocopy VARCHAR2
622: , x_msg_count out nocopy NUMBER
623: , x_msg_data out nocopy VARCHAR2
624: , p5_a0 JTF_NUMBER_TABLE
625: , p5_a1 JTF_NUMBER_TABLE
626: , p5_a2 JTF_NUMBER_TABLE
627: , p5_a3 JTF_NUMBER_TABLE
628: , p5_a4 JTF_NUMBER_TABLE
621: , x_return_status out nocopy VARCHAR2
622: , x_msg_count out nocopy NUMBER
623: , x_msg_data out nocopy VARCHAR2
624: , p5_a0 JTF_NUMBER_TABLE
625: , p5_a1 JTF_NUMBER_TABLE
626: , p5_a2 JTF_NUMBER_TABLE
627: , p5_a3 JTF_NUMBER_TABLE
628: , p5_a4 JTF_NUMBER_TABLE
629: , p5_a5 JTF_VARCHAR2_TABLE_100
622: , x_msg_count out nocopy NUMBER
623: , x_msg_data out nocopy VARCHAR2
624: , p5_a0 JTF_NUMBER_TABLE
625: , p5_a1 JTF_NUMBER_TABLE
626: , p5_a2 JTF_NUMBER_TABLE
627: , p5_a3 JTF_NUMBER_TABLE
628: , p5_a4 JTF_NUMBER_TABLE
629: , p5_a5 JTF_VARCHAR2_TABLE_100
630: , p5_a6 JTF_VARCHAR2_TABLE_500
623: , x_msg_data out nocopy VARCHAR2
624: , p5_a0 JTF_NUMBER_TABLE
625: , p5_a1 JTF_NUMBER_TABLE
626: , p5_a2 JTF_NUMBER_TABLE
627: , p5_a3 JTF_NUMBER_TABLE
628: , p5_a4 JTF_NUMBER_TABLE
629: , p5_a5 JTF_VARCHAR2_TABLE_100
630: , p5_a6 JTF_VARCHAR2_TABLE_500
631: , p5_a7 JTF_VARCHAR2_TABLE_500
624: , p5_a0 JTF_NUMBER_TABLE
625: , p5_a1 JTF_NUMBER_TABLE
626: , p5_a2 JTF_NUMBER_TABLE
627: , p5_a3 JTF_NUMBER_TABLE
628: , p5_a4 JTF_NUMBER_TABLE
629: , p5_a5 JTF_VARCHAR2_TABLE_100
630: , p5_a6 JTF_VARCHAR2_TABLE_500
631: , p5_a7 JTF_VARCHAR2_TABLE_500
632: , p5_a8 JTF_VARCHAR2_TABLE_500
642: , p5_a18 JTF_VARCHAR2_TABLE_500
643: , p5_a19 JTF_VARCHAR2_TABLE_500
644: , p5_a20 JTF_VARCHAR2_TABLE_500
645: , p5_a21 JTF_VARCHAR2_TABLE_100
646: , p5_a22 JTF_NUMBER_TABLE
647: , p5_a23 JTF_DATE_TABLE
648: , p5_a24 JTF_NUMBER_TABLE
649: , p5_a25 JTF_DATE_TABLE
650: , p5_a26 JTF_NUMBER_TABLE
644: , p5_a20 JTF_VARCHAR2_TABLE_500
645: , p5_a21 JTF_VARCHAR2_TABLE_100
646: , p5_a22 JTF_NUMBER_TABLE
647: , p5_a23 JTF_DATE_TABLE
648: , p5_a24 JTF_NUMBER_TABLE
649: , p5_a25 JTF_DATE_TABLE
650: , p5_a26 JTF_NUMBER_TABLE
651: , p6_a0 out nocopy JTF_NUMBER_TABLE
652: , p6_a1 out nocopy JTF_NUMBER_TABLE
646: , p5_a22 JTF_NUMBER_TABLE
647: , p5_a23 JTF_DATE_TABLE
648: , p5_a24 JTF_NUMBER_TABLE
649: , p5_a25 JTF_DATE_TABLE
650: , p5_a26 JTF_NUMBER_TABLE
651: , p6_a0 out nocopy JTF_NUMBER_TABLE
652: , p6_a1 out nocopy JTF_NUMBER_TABLE
653: , p6_a2 out nocopy JTF_NUMBER_TABLE
654: , p6_a3 out nocopy JTF_NUMBER_TABLE
647: , p5_a23 JTF_DATE_TABLE
648: , p5_a24 JTF_NUMBER_TABLE
649: , p5_a25 JTF_DATE_TABLE
650: , p5_a26 JTF_NUMBER_TABLE
651: , p6_a0 out nocopy JTF_NUMBER_TABLE
652: , p6_a1 out nocopy JTF_NUMBER_TABLE
653: , p6_a2 out nocopy JTF_NUMBER_TABLE
654: , p6_a3 out nocopy JTF_NUMBER_TABLE
655: , p6_a4 out nocopy JTF_NUMBER_TABLE
648: , p5_a24 JTF_NUMBER_TABLE
649: , p5_a25 JTF_DATE_TABLE
650: , p5_a26 JTF_NUMBER_TABLE
651: , p6_a0 out nocopy JTF_NUMBER_TABLE
652: , p6_a1 out nocopy JTF_NUMBER_TABLE
653: , p6_a2 out nocopy JTF_NUMBER_TABLE
654: , p6_a3 out nocopy JTF_NUMBER_TABLE
655: , p6_a4 out nocopy JTF_NUMBER_TABLE
656: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
649: , p5_a25 JTF_DATE_TABLE
650: , p5_a26 JTF_NUMBER_TABLE
651: , p6_a0 out nocopy JTF_NUMBER_TABLE
652: , p6_a1 out nocopy JTF_NUMBER_TABLE
653: , p6_a2 out nocopy JTF_NUMBER_TABLE
654: , p6_a3 out nocopy JTF_NUMBER_TABLE
655: , p6_a4 out nocopy JTF_NUMBER_TABLE
656: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
650: , p5_a26 JTF_NUMBER_TABLE
651: , p6_a0 out nocopy JTF_NUMBER_TABLE
652: , p6_a1 out nocopy JTF_NUMBER_TABLE
653: , p6_a2 out nocopy JTF_NUMBER_TABLE
654: , p6_a3 out nocopy JTF_NUMBER_TABLE
655: , p6_a4 out nocopy JTF_NUMBER_TABLE
656: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
658: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
651: , p6_a0 out nocopy JTF_NUMBER_TABLE
652: , p6_a1 out nocopy JTF_NUMBER_TABLE
653: , p6_a2 out nocopy JTF_NUMBER_TABLE
654: , p6_a3 out nocopy JTF_NUMBER_TABLE
655: , p6_a4 out nocopy JTF_NUMBER_TABLE
656: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
658: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
659: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
669: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
670: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
671: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
672: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
673: , p6_a22 out nocopy JTF_NUMBER_TABLE
674: , p6_a23 out nocopy JTF_DATE_TABLE
675: , p6_a24 out nocopy JTF_NUMBER_TABLE
676: , p6_a25 out nocopy JTF_DATE_TABLE
677: , p6_a26 out nocopy JTF_NUMBER_TABLE
671: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
672: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
673: , p6_a22 out nocopy JTF_NUMBER_TABLE
674: , p6_a23 out nocopy JTF_DATE_TABLE
675: , p6_a24 out nocopy JTF_NUMBER_TABLE
676: , p6_a25 out nocopy JTF_DATE_TABLE
677: , p6_a26 out nocopy JTF_NUMBER_TABLE
678: )
679:
673: , p6_a22 out nocopy JTF_NUMBER_TABLE
674: , p6_a23 out nocopy JTF_DATE_TABLE
675: , p6_a24 out nocopy JTF_NUMBER_TABLE
676: , p6_a25 out nocopy JTF_DATE_TABLE
677: , p6_a26 out nocopy JTF_NUMBER_TABLE
678: )
679:
680: as
681: ddp_stav_tbl okl_sta_pvt.stav_tbl_type;
858: , p_init_msg_list VARCHAR2
859: , x_return_status out nocopy VARCHAR2
860: , x_msg_count out nocopy NUMBER
861: , x_msg_data out nocopy VARCHAR2
862: , p5_a0 JTF_NUMBER_TABLE
863: , p5_a1 JTF_NUMBER_TABLE
864: , p5_a2 JTF_NUMBER_TABLE
865: , p5_a3 JTF_NUMBER_TABLE
866: , p5_a4 JTF_NUMBER_TABLE
859: , x_return_status out nocopy VARCHAR2
860: , x_msg_count out nocopy NUMBER
861: , x_msg_data out nocopy VARCHAR2
862: , p5_a0 JTF_NUMBER_TABLE
863: , p5_a1 JTF_NUMBER_TABLE
864: , p5_a2 JTF_NUMBER_TABLE
865: , p5_a3 JTF_NUMBER_TABLE
866: , p5_a4 JTF_NUMBER_TABLE
867: , p5_a5 JTF_VARCHAR2_TABLE_100
860: , x_msg_count out nocopy NUMBER
861: , x_msg_data out nocopy VARCHAR2
862: , p5_a0 JTF_NUMBER_TABLE
863: , p5_a1 JTF_NUMBER_TABLE
864: , p5_a2 JTF_NUMBER_TABLE
865: , p5_a3 JTF_NUMBER_TABLE
866: , p5_a4 JTF_NUMBER_TABLE
867: , p5_a5 JTF_VARCHAR2_TABLE_100
868: , p5_a6 JTF_VARCHAR2_TABLE_500
861: , x_msg_data out nocopy VARCHAR2
862: , p5_a0 JTF_NUMBER_TABLE
863: , p5_a1 JTF_NUMBER_TABLE
864: , p5_a2 JTF_NUMBER_TABLE
865: , p5_a3 JTF_NUMBER_TABLE
866: , p5_a4 JTF_NUMBER_TABLE
867: , p5_a5 JTF_VARCHAR2_TABLE_100
868: , p5_a6 JTF_VARCHAR2_TABLE_500
869: , p5_a7 JTF_VARCHAR2_TABLE_500
862: , p5_a0 JTF_NUMBER_TABLE
863: , p5_a1 JTF_NUMBER_TABLE
864: , p5_a2 JTF_NUMBER_TABLE
865: , p5_a3 JTF_NUMBER_TABLE
866: , p5_a4 JTF_NUMBER_TABLE
867: , p5_a5 JTF_VARCHAR2_TABLE_100
868: , p5_a6 JTF_VARCHAR2_TABLE_500
869: , p5_a7 JTF_VARCHAR2_TABLE_500
870: , p5_a8 JTF_VARCHAR2_TABLE_500
880: , p5_a18 JTF_VARCHAR2_TABLE_500
881: , p5_a19 JTF_VARCHAR2_TABLE_500
882: , p5_a20 JTF_VARCHAR2_TABLE_500
883: , p5_a21 JTF_VARCHAR2_TABLE_100
884: , p5_a22 JTF_NUMBER_TABLE
885: , p5_a23 JTF_DATE_TABLE
886: , p5_a24 JTF_NUMBER_TABLE
887: , p5_a25 JTF_DATE_TABLE
888: , p5_a26 JTF_NUMBER_TABLE
882: , p5_a20 JTF_VARCHAR2_TABLE_500
883: , p5_a21 JTF_VARCHAR2_TABLE_100
884: , p5_a22 JTF_NUMBER_TABLE
885: , p5_a23 JTF_DATE_TABLE
886: , p5_a24 JTF_NUMBER_TABLE
887: , p5_a25 JTF_DATE_TABLE
888: , p5_a26 JTF_NUMBER_TABLE
889: )
890:
884: , p5_a22 JTF_NUMBER_TABLE
885: , p5_a23 JTF_DATE_TABLE
886: , p5_a24 JTF_NUMBER_TABLE
887: , p5_a25 JTF_DATE_TABLE
888: , p5_a26 JTF_NUMBER_TABLE
889: )
890:
891: as
892: ddp_stav_tbl okl_sta_pvt.stav_tbl_type;
1095: , p_init_msg_list VARCHAR2
1096: , x_return_status out nocopy VARCHAR2
1097: , x_msg_count out nocopy NUMBER
1098: , x_msg_data out nocopy VARCHAR2
1099: , p5_a0 JTF_NUMBER_TABLE
1100: , p5_a1 JTF_NUMBER_TABLE
1101: , p5_a2 JTF_NUMBER_TABLE
1102: , p5_a3 JTF_NUMBER_TABLE
1103: , p5_a4 JTF_NUMBER_TABLE
1096: , x_return_status out nocopy VARCHAR2
1097: , x_msg_count out nocopy NUMBER
1098: , x_msg_data out nocopy VARCHAR2
1099: , p5_a0 JTF_NUMBER_TABLE
1100: , p5_a1 JTF_NUMBER_TABLE
1101: , p5_a2 JTF_NUMBER_TABLE
1102: , p5_a3 JTF_NUMBER_TABLE
1103: , p5_a4 JTF_NUMBER_TABLE
1104: , p5_a5 JTF_VARCHAR2_TABLE_100
1097: , x_msg_count out nocopy NUMBER
1098: , x_msg_data out nocopy VARCHAR2
1099: , p5_a0 JTF_NUMBER_TABLE
1100: , p5_a1 JTF_NUMBER_TABLE
1101: , p5_a2 JTF_NUMBER_TABLE
1102: , p5_a3 JTF_NUMBER_TABLE
1103: , p5_a4 JTF_NUMBER_TABLE
1104: , p5_a5 JTF_VARCHAR2_TABLE_100
1105: , p5_a6 JTF_VARCHAR2_TABLE_500
1098: , x_msg_data out nocopy VARCHAR2
1099: , p5_a0 JTF_NUMBER_TABLE
1100: , p5_a1 JTF_NUMBER_TABLE
1101: , p5_a2 JTF_NUMBER_TABLE
1102: , p5_a3 JTF_NUMBER_TABLE
1103: , p5_a4 JTF_NUMBER_TABLE
1104: , p5_a5 JTF_VARCHAR2_TABLE_100
1105: , p5_a6 JTF_VARCHAR2_TABLE_500
1106: , p5_a7 JTF_VARCHAR2_TABLE_500
1099: , p5_a0 JTF_NUMBER_TABLE
1100: , p5_a1 JTF_NUMBER_TABLE
1101: , p5_a2 JTF_NUMBER_TABLE
1102: , p5_a3 JTF_NUMBER_TABLE
1103: , p5_a4 JTF_NUMBER_TABLE
1104: , p5_a5 JTF_VARCHAR2_TABLE_100
1105: , p5_a6 JTF_VARCHAR2_TABLE_500
1106: , p5_a7 JTF_VARCHAR2_TABLE_500
1107: , p5_a8 JTF_VARCHAR2_TABLE_500
1117: , p5_a18 JTF_VARCHAR2_TABLE_500
1118: , p5_a19 JTF_VARCHAR2_TABLE_500
1119: , p5_a20 JTF_VARCHAR2_TABLE_500
1120: , p5_a21 JTF_VARCHAR2_TABLE_100
1121: , p5_a22 JTF_NUMBER_TABLE
1122: , p5_a23 JTF_DATE_TABLE
1123: , p5_a24 JTF_NUMBER_TABLE
1124: , p5_a25 JTF_DATE_TABLE
1125: , p5_a26 JTF_NUMBER_TABLE
1119: , p5_a20 JTF_VARCHAR2_TABLE_500
1120: , p5_a21 JTF_VARCHAR2_TABLE_100
1121: , p5_a22 JTF_NUMBER_TABLE
1122: , p5_a23 JTF_DATE_TABLE
1123: , p5_a24 JTF_NUMBER_TABLE
1124: , p5_a25 JTF_DATE_TABLE
1125: , p5_a26 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1121: , p5_a22 JTF_NUMBER_TABLE
1122: , p5_a23 JTF_DATE_TABLE
1123: , p5_a24 JTF_NUMBER_TABLE
1124: , p5_a25 JTF_DATE_TABLE
1125: , p5_a26 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_NUMBER_TABLE
1122: , p5_a23 JTF_DATE_TABLE
1123: , p5_a24 JTF_NUMBER_TABLE
1124: , p5_a25 JTF_DATE_TABLE
1125: , p5_a26 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_NUMBER_TABLE
1130: , p6_a4 out nocopy JTF_NUMBER_TABLE
1123: , p5_a24 JTF_NUMBER_TABLE
1124: , p5_a25 JTF_DATE_TABLE
1125: , p5_a26 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_NUMBER_TABLE
1130: , p6_a4 out nocopy JTF_NUMBER_TABLE
1131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1124: , p5_a25 JTF_DATE_TABLE
1125: , p5_a26 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_NUMBER_TABLE
1130: , p6_a4 out nocopy JTF_NUMBER_TABLE
1131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1132: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1125: , p5_a26 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_NUMBER_TABLE
1130: , p6_a4 out nocopy JTF_NUMBER_TABLE
1131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1132: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1133: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_NUMBER_TABLE
1130: , p6_a4 out nocopy JTF_NUMBER_TABLE
1131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1132: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1133: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1134: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1144: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1145: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1146: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1147: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1148: , p6_a22 out nocopy JTF_NUMBER_TABLE
1149: , p6_a23 out nocopy JTF_DATE_TABLE
1150: , p6_a24 out nocopy JTF_NUMBER_TABLE
1151: , p6_a25 out nocopy JTF_DATE_TABLE
1152: , p6_a26 out nocopy JTF_NUMBER_TABLE
1146: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1147: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1148: , p6_a22 out nocopy JTF_NUMBER_TABLE
1149: , p6_a23 out nocopy JTF_DATE_TABLE
1150: , p6_a24 out nocopy JTF_NUMBER_TABLE
1151: , p6_a25 out nocopy JTF_DATE_TABLE
1152: , p6_a26 out nocopy JTF_NUMBER_TABLE
1153: )
1154:
1148: , p6_a22 out nocopy JTF_NUMBER_TABLE
1149: , p6_a23 out nocopy JTF_DATE_TABLE
1150: , p6_a24 out nocopy JTF_NUMBER_TABLE
1151: , p6_a25 out nocopy JTF_DATE_TABLE
1152: , p6_a26 out nocopy JTF_NUMBER_TABLE
1153: )
1154:
1155: as
1156: ddp_stav_tbl okl_sta_pvt.stav_tbl_type;
1333: , p_init_msg_list VARCHAR2
1334: , x_return_status out nocopy VARCHAR2
1335: , x_msg_count out nocopy NUMBER
1336: , x_msg_data out nocopy VARCHAR2
1337: , p5_a0 JTF_NUMBER_TABLE
1338: , p5_a1 JTF_NUMBER_TABLE
1339: , p5_a2 JTF_NUMBER_TABLE
1340: , p5_a3 JTF_NUMBER_TABLE
1341: , p5_a4 JTF_NUMBER_TABLE
1334: , x_return_status out nocopy VARCHAR2
1335: , x_msg_count out nocopy NUMBER
1336: , x_msg_data out nocopy VARCHAR2
1337: , p5_a0 JTF_NUMBER_TABLE
1338: , p5_a1 JTF_NUMBER_TABLE
1339: , p5_a2 JTF_NUMBER_TABLE
1340: , p5_a3 JTF_NUMBER_TABLE
1341: , p5_a4 JTF_NUMBER_TABLE
1342: , p5_a5 JTF_VARCHAR2_TABLE_100
1335: , x_msg_count out nocopy NUMBER
1336: , x_msg_data out nocopy VARCHAR2
1337: , p5_a0 JTF_NUMBER_TABLE
1338: , p5_a1 JTF_NUMBER_TABLE
1339: , p5_a2 JTF_NUMBER_TABLE
1340: , p5_a3 JTF_NUMBER_TABLE
1341: , p5_a4 JTF_NUMBER_TABLE
1342: , p5_a5 JTF_VARCHAR2_TABLE_100
1343: , p5_a6 JTF_VARCHAR2_TABLE_500
1336: , x_msg_data out nocopy VARCHAR2
1337: , p5_a0 JTF_NUMBER_TABLE
1338: , p5_a1 JTF_NUMBER_TABLE
1339: , p5_a2 JTF_NUMBER_TABLE
1340: , p5_a3 JTF_NUMBER_TABLE
1341: , p5_a4 JTF_NUMBER_TABLE
1342: , p5_a5 JTF_VARCHAR2_TABLE_100
1343: , p5_a6 JTF_VARCHAR2_TABLE_500
1344: , p5_a7 JTF_VARCHAR2_TABLE_500
1337: , p5_a0 JTF_NUMBER_TABLE
1338: , p5_a1 JTF_NUMBER_TABLE
1339: , p5_a2 JTF_NUMBER_TABLE
1340: , p5_a3 JTF_NUMBER_TABLE
1341: , p5_a4 JTF_NUMBER_TABLE
1342: , p5_a5 JTF_VARCHAR2_TABLE_100
1343: , p5_a6 JTF_VARCHAR2_TABLE_500
1344: , p5_a7 JTF_VARCHAR2_TABLE_500
1345: , p5_a8 JTF_VARCHAR2_TABLE_500
1355: , p5_a18 JTF_VARCHAR2_TABLE_500
1356: , p5_a19 JTF_VARCHAR2_TABLE_500
1357: , p5_a20 JTF_VARCHAR2_TABLE_500
1358: , p5_a21 JTF_VARCHAR2_TABLE_100
1359: , p5_a22 JTF_NUMBER_TABLE
1360: , p5_a23 JTF_DATE_TABLE
1361: , p5_a24 JTF_NUMBER_TABLE
1362: , p5_a25 JTF_DATE_TABLE
1363: , p5_a26 JTF_NUMBER_TABLE
1357: , p5_a20 JTF_VARCHAR2_TABLE_500
1358: , p5_a21 JTF_VARCHAR2_TABLE_100
1359: , p5_a22 JTF_NUMBER_TABLE
1360: , p5_a23 JTF_DATE_TABLE
1361: , p5_a24 JTF_NUMBER_TABLE
1362: , p5_a25 JTF_DATE_TABLE
1363: , p5_a26 JTF_NUMBER_TABLE
1364: )
1365:
1359: , p5_a22 JTF_NUMBER_TABLE
1360: , p5_a23 JTF_DATE_TABLE
1361: , p5_a24 JTF_NUMBER_TABLE
1362: , p5_a25 JTF_DATE_TABLE
1363: , p5_a26 JTF_NUMBER_TABLE
1364: )
1365:
1366: as
1367: ddp_stav_tbl okl_sta_pvt.stav_tbl_type;
1512: , p_init_msg_list VARCHAR2
1513: , x_return_status out nocopy VARCHAR2
1514: , x_msg_count out nocopy NUMBER
1515: , x_msg_data out nocopy VARCHAR2
1516: , p5_a0 JTF_NUMBER_TABLE
1517: , p5_a1 JTF_NUMBER_TABLE
1518: , p5_a2 JTF_NUMBER_TABLE
1519: , p5_a3 JTF_NUMBER_TABLE
1520: , p5_a4 JTF_NUMBER_TABLE
1513: , x_return_status out nocopy VARCHAR2
1514: , x_msg_count out nocopy NUMBER
1515: , x_msg_data out nocopy VARCHAR2
1516: , p5_a0 JTF_NUMBER_TABLE
1517: , p5_a1 JTF_NUMBER_TABLE
1518: , p5_a2 JTF_NUMBER_TABLE
1519: , p5_a3 JTF_NUMBER_TABLE
1520: , p5_a4 JTF_NUMBER_TABLE
1521: , p5_a5 JTF_VARCHAR2_TABLE_100
1514: , x_msg_count out nocopy NUMBER
1515: , x_msg_data out nocopy VARCHAR2
1516: , p5_a0 JTF_NUMBER_TABLE
1517: , p5_a1 JTF_NUMBER_TABLE
1518: , p5_a2 JTF_NUMBER_TABLE
1519: , p5_a3 JTF_NUMBER_TABLE
1520: , p5_a4 JTF_NUMBER_TABLE
1521: , p5_a5 JTF_VARCHAR2_TABLE_100
1522: , p5_a6 JTF_VARCHAR2_TABLE_500
1515: , x_msg_data out nocopy VARCHAR2
1516: , p5_a0 JTF_NUMBER_TABLE
1517: , p5_a1 JTF_NUMBER_TABLE
1518: , p5_a2 JTF_NUMBER_TABLE
1519: , p5_a3 JTF_NUMBER_TABLE
1520: , p5_a4 JTF_NUMBER_TABLE
1521: , p5_a5 JTF_VARCHAR2_TABLE_100
1522: , p5_a6 JTF_VARCHAR2_TABLE_500
1523: , p5_a7 JTF_VARCHAR2_TABLE_500
1516: , p5_a0 JTF_NUMBER_TABLE
1517: , p5_a1 JTF_NUMBER_TABLE
1518: , p5_a2 JTF_NUMBER_TABLE
1519: , p5_a3 JTF_NUMBER_TABLE
1520: , p5_a4 JTF_NUMBER_TABLE
1521: , p5_a5 JTF_VARCHAR2_TABLE_100
1522: , p5_a6 JTF_VARCHAR2_TABLE_500
1523: , p5_a7 JTF_VARCHAR2_TABLE_500
1524: , p5_a8 JTF_VARCHAR2_TABLE_500
1534: , p5_a18 JTF_VARCHAR2_TABLE_500
1535: , p5_a19 JTF_VARCHAR2_TABLE_500
1536: , p5_a20 JTF_VARCHAR2_TABLE_500
1537: , p5_a21 JTF_VARCHAR2_TABLE_100
1538: , p5_a22 JTF_NUMBER_TABLE
1539: , p5_a23 JTF_DATE_TABLE
1540: , p5_a24 JTF_NUMBER_TABLE
1541: , p5_a25 JTF_DATE_TABLE
1542: , p5_a26 JTF_NUMBER_TABLE
1536: , p5_a20 JTF_VARCHAR2_TABLE_500
1537: , p5_a21 JTF_VARCHAR2_TABLE_100
1538: , p5_a22 JTF_NUMBER_TABLE
1539: , p5_a23 JTF_DATE_TABLE
1540: , p5_a24 JTF_NUMBER_TABLE
1541: , p5_a25 JTF_DATE_TABLE
1542: , p5_a26 JTF_NUMBER_TABLE
1543: )
1544:
1538: , p5_a22 JTF_NUMBER_TABLE
1539: , p5_a23 JTF_DATE_TABLE
1540: , p5_a24 JTF_NUMBER_TABLE
1541: , p5_a25 JTF_DATE_TABLE
1542: , p5_a26 JTF_NUMBER_TABLE
1543: )
1544:
1545: as
1546: ddp_stav_tbl okl_sta_pvt.stav_tbl_type;