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_ils_pvt.ils_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ils_pvt.ils_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ils_pvt.ils_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ils_pvt.ils_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ils_pvt.ils_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_VARCHAR2_TABLE_500
39: , a17 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_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if a0 is not null and a0.count > 0 then
87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t okl_ils_pvt.ils_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE
88: end if;
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t okl_ils_pvt.ils_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t okl_ils_pvt.ils_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_VARCHAR2_TABLE_500
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t okl_ils_pvt.ils_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_VARCHAR2_TABLE_500
98: , a7 out nocopy JTF_VARCHAR2_TABLE_500
91: procedure rosetta_table_copy_out_p2(t okl_ils_pvt.ils_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_VARCHAR2_TABLE_500
98: , a7 out nocopy JTF_VARCHAR2_TABLE_500
99: , a8 out nocopy JTF_VARCHAR2_TABLE_500
108: , a17 out nocopy JTF_VARCHAR2_TABLE_500
109: , a18 out nocopy JTF_VARCHAR2_TABLE_500
110: , a19 out nocopy JTF_VARCHAR2_TABLE_500
111: , a20 out nocopy JTF_VARCHAR2_TABLE_500
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_DATE_TABLE
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
110: , a19 out nocopy JTF_VARCHAR2_TABLE_500
111: , a20 out nocopy JTF_VARCHAR2_TABLE_500
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_DATE_TABLE
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: ) as
118: ddindx binary_integer; indx binary_integer;
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_DATE_TABLE
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: ) as
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if t is null or t.count = 0 then
117: ) as
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_VARCHAR2_TABLE_100();
119: begin
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_VARCHAR2_TABLE_100();
127: a6 := JTF_VARCHAR2_TABLE_500();
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_VARCHAR2_TABLE_100();
127: a6 := JTF_VARCHAR2_TABLE_500();
128: a7 := JTF_VARCHAR2_TABLE_500();
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_VARCHAR2_TABLE_100();
127: a6 := JTF_VARCHAR2_TABLE_500();
128: a7 := JTF_VARCHAR2_TABLE_500();
129: a8 := JTF_VARCHAR2_TABLE_500();
138: a17 := JTF_VARCHAR2_TABLE_500();
139: a18 := JTF_VARCHAR2_TABLE_500();
140: a19 := JTF_VARCHAR2_TABLE_500();
141: a20 := JTF_VARCHAR2_TABLE_500();
142: a21 := JTF_NUMBER_TABLE();
143: a22 := JTF_DATE_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_500();
141: a20 := JTF_VARCHAR2_TABLE_500();
142: a21 := JTF_NUMBER_TABLE();
143: a22 := JTF_DATE_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
142: a21 := JTF_NUMBER_TABLE();
143: a22 := JTF_DATE_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_NUMBER_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_NUMBER_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_NUMBER_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_NUMBER_TABLE();
153: a5 := JTF_VARCHAR2_TABLE_100();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_NUMBER_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_NUMBER_TABLE();
153: a5 := JTF_VARCHAR2_TABLE_100();
154: a6 := JTF_VARCHAR2_TABLE_500();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_NUMBER_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_NUMBER_TABLE();
153: a5 := JTF_VARCHAR2_TABLE_100();
154: a6 := JTF_VARCHAR2_TABLE_500();
155: a7 := JTF_VARCHAR2_TABLE_500();
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_NUMBER_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_NUMBER_TABLE();
153: a5 := JTF_VARCHAR2_TABLE_100();
154: a6 := JTF_VARCHAR2_TABLE_500();
155: a7 := JTF_VARCHAR2_TABLE_500();
156: a8 := JTF_VARCHAR2_TABLE_500();
165: a17 := JTF_VARCHAR2_TABLE_500();
166: a18 := JTF_VARCHAR2_TABLE_500();
167: a19 := JTF_VARCHAR2_TABLE_500();
168: a20 := JTF_VARCHAR2_TABLE_500();
169: a21 := JTF_NUMBER_TABLE();
170: a22 := JTF_DATE_TABLE();
171: a23 := JTF_NUMBER_TABLE();
172: a24 := JTF_DATE_TABLE();
173: a25 := JTF_NUMBER_TABLE();
167: a19 := JTF_VARCHAR2_TABLE_500();
168: a20 := JTF_VARCHAR2_TABLE_500();
169: a21 := JTF_NUMBER_TABLE();
170: a22 := JTF_DATE_TABLE();
171: a23 := JTF_NUMBER_TABLE();
172: a24 := JTF_DATE_TABLE();
173: a25 := JTF_NUMBER_TABLE();
174: if t.count > 0 then
175: a0.extend(t.count);
169: a21 := JTF_NUMBER_TABLE();
170: a22 := JTF_DATE_TABLE();
171: a23 := JTF_NUMBER_TABLE();
172: a24 := JTF_DATE_TABLE();
173: a25 := JTF_NUMBER_TABLE();
174: if t.count > 0 then
175: a0.extend(t.count);
176: a1.extend(t.count);
177: a2.extend(t.count);
236: end if;
237: end if;
238: end rosetta_table_copy_out_p2;
239:
240: procedure rosetta_table_copy_in_p5(t out nocopy okl_ils_pvt.ilsv_tbl_type, a0 JTF_NUMBER_TABLE
241: , a1 JTF_NUMBER_TABLE
242: , a2 JTF_NUMBER_TABLE
243: , a3 JTF_NUMBER_TABLE
244: , a4 JTF_NUMBER_TABLE
237: end if;
238: end rosetta_table_copy_out_p2;
239:
240: procedure rosetta_table_copy_in_p5(t out nocopy okl_ils_pvt.ilsv_tbl_type, a0 JTF_NUMBER_TABLE
241: , a1 JTF_NUMBER_TABLE
242: , a2 JTF_NUMBER_TABLE
243: , a3 JTF_NUMBER_TABLE
244: , a4 JTF_NUMBER_TABLE
245: , a5 JTF_VARCHAR2_TABLE_100
238: end rosetta_table_copy_out_p2;
239:
240: procedure rosetta_table_copy_in_p5(t out nocopy okl_ils_pvt.ilsv_tbl_type, a0 JTF_NUMBER_TABLE
241: , a1 JTF_NUMBER_TABLE
242: , a2 JTF_NUMBER_TABLE
243: , a3 JTF_NUMBER_TABLE
244: , a4 JTF_NUMBER_TABLE
245: , a5 JTF_VARCHAR2_TABLE_100
246: , a6 JTF_VARCHAR2_TABLE_500
239:
240: procedure rosetta_table_copy_in_p5(t out nocopy okl_ils_pvt.ilsv_tbl_type, a0 JTF_NUMBER_TABLE
241: , a1 JTF_NUMBER_TABLE
242: , a2 JTF_NUMBER_TABLE
243: , a3 JTF_NUMBER_TABLE
244: , a4 JTF_NUMBER_TABLE
245: , a5 JTF_VARCHAR2_TABLE_100
246: , a6 JTF_VARCHAR2_TABLE_500
247: , a7 JTF_VARCHAR2_TABLE_500
240: procedure rosetta_table_copy_in_p5(t out nocopy okl_ils_pvt.ilsv_tbl_type, a0 JTF_NUMBER_TABLE
241: , a1 JTF_NUMBER_TABLE
242: , a2 JTF_NUMBER_TABLE
243: , a3 JTF_NUMBER_TABLE
244: , a4 JTF_NUMBER_TABLE
245: , a5 JTF_VARCHAR2_TABLE_100
246: , a6 JTF_VARCHAR2_TABLE_500
247: , a7 JTF_VARCHAR2_TABLE_500
248: , a8 JTF_VARCHAR2_TABLE_500
257: , a17 JTF_VARCHAR2_TABLE_500
258: , a18 JTF_VARCHAR2_TABLE_500
259: , a19 JTF_VARCHAR2_TABLE_500
260: , a20 JTF_VARCHAR2_TABLE_500
261: , a21 JTF_NUMBER_TABLE
262: , a22 JTF_DATE_TABLE
263: , a23 JTF_NUMBER_TABLE
264: , a24 JTF_DATE_TABLE
265: , a25 JTF_NUMBER_TABLE
259: , a19 JTF_VARCHAR2_TABLE_500
260: , a20 JTF_VARCHAR2_TABLE_500
261: , a21 JTF_NUMBER_TABLE
262: , a22 JTF_DATE_TABLE
263: , a23 JTF_NUMBER_TABLE
264: , a24 JTF_DATE_TABLE
265: , a25 JTF_NUMBER_TABLE
266: ) as
267: ddindx binary_integer; indx binary_integer;
261: , a21 JTF_NUMBER_TABLE
262: , a22 JTF_DATE_TABLE
263: , a23 JTF_NUMBER_TABLE
264: , a24 JTF_DATE_TABLE
265: , a25 JTF_NUMBER_TABLE
266: ) as
267: ddindx binary_integer; indx binary_integer;
268: begin
269: if a0 is not null and a0.count > 0 then
305: end loop;
306: end if;
307: end if;
308: end rosetta_table_copy_in_p5;
309: procedure rosetta_table_copy_out_p5(t okl_ils_pvt.ilsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
310: , a1 out nocopy JTF_NUMBER_TABLE
311: , a2 out nocopy JTF_NUMBER_TABLE
312: , a3 out nocopy JTF_NUMBER_TABLE
313: , a4 out nocopy JTF_NUMBER_TABLE
306: end if;
307: end if;
308: end rosetta_table_copy_in_p5;
309: procedure rosetta_table_copy_out_p5(t okl_ils_pvt.ilsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
310: , a1 out nocopy JTF_NUMBER_TABLE
311: , a2 out nocopy JTF_NUMBER_TABLE
312: , a3 out nocopy JTF_NUMBER_TABLE
313: , a4 out nocopy JTF_NUMBER_TABLE
314: , a5 out nocopy JTF_VARCHAR2_TABLE_100
307: end if;
308: end rosetta_table_copy_in_p5;
309: procedure rosetta_table_copy_out_p5(t okl_ils_pvt.ilsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
310: , a1 out nocopy JTF_NUMBER_TABLE
311: , a2 out nocopy JTF_NUMBER_TABLE
312: , a3 out nocopy JTF_NUMBER_TABLE
313: , a4 out nocopy JTF_NUMBER_TABLE
314: , a5 out nocopy JTF_VARCHAR2_TABLE_100
315: , a6 out nocopy JTF_VARCHAR2_TABLE_500
308: end rosetta_table_copy_in_p5;
309: procedure rosetta_table_copy_out_p5(t okl_ils_pvt.ilsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
310: , a1 out nocopy JTF_NUMBER_TABLE
311: , a2 out nocopy JTF_NUMBER_TABLE
312: , a3 out nocopy JTF_NUMBER_TABLE
313: , a4 out nocopy JTF_NUMBER_TABLE
314: , a5 out nocopy JTF_VARCHAR2_TABLE_100
315: , a6 out nocopy JTF_VARCHAR2_TABLE_500
316: , a7 out nocopy JTF_VARCHAR2_TABLE_500
309: procedure rosetta_table_copy_out_p5(t okl_ils_pvt.ilsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
310: , a1 out nocopy JTF_NUMBER_TABLE
311: , a2 out nocopy JTF_NUMBER_TABLE
312: , a3 out nocopy JTF_NUMBER_TABLE
313: , a4 out nocopy JTF_NUMBER_TABLE
314: , a5 out nocopy JTF_VARCHAR2_TABLE_100
315: , a6 out nocopy JTF_VARCHAR2_TABLE_500
316: , a7 out nocopy JTF_VARCHAR2_TABLE_500
317: , a8 out nocopy JTF_VARCHAR2_TABLE_500
326: , a17 out nocopy JTF_VARCHAR2_TABLE_500
327: , a18 out nocopy JTF_VARCHAR2_TABLE_500
328: , a19 out nocopy JTF_VARCHAR2_TABLE_500
329: , a20 out nocopy JTF_VARCHAR2_TABLE_500
330: , a21 out nocopy JTF_NUMBER_TABLE
331: , a22 out nocopy JTF_DATE_TABLE
332: , a23 out nocopy JTF_NUMBER_TABLE
333: , a24 out nocopy JTF_DATE_TABLE
334: , a25 out nocopy JTF_NUMBER_TABLE
328: , a19 out nocopy JTF_VARCHAR2_TABLE_500
329: , a20 out nocopy JTF_VARCHAR2_TABLE_500
330: , a21 out nocopy JTF_NUMBER_TABLE
331: , a22 out nocopy JTF_DATE_TABLE
332: , a23 out nocopy JTF_NUMBER_TABLE
333: , a24 out nocopy JTF_DATE_TABLE
334: , a25 out nocopy JTF_NUMBER_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
330: , a21 out nocopy JTF_NUMBER_TABLE
331: , a22 out nocopy JTF_DATE_TABLE
332: , a23 out nocopy JTF_NUMBER_TABLE
333: , a24 out nocopy JTF_DATE_TABLE
334: , a25 out nocopy JTF_NUMBER_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
335: ) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: a1 := JTF_NUMBER_TABLE();
341: a2 := JTF_NUMBER_TABLE();
342: a3 := JTF_NUMBER_TABLE();
343: a4 := JTF_NUMBER_TABLE();
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: a1 := JTF_NUMBER_TABLE();
341: a2 := JTF_NUMBER_TABLE();
342: a3 := JTF_NUMBER_TABLE();
343: a4 := JTF_NUMBER_TABLE();
344: a5 := JTF_VARCHAR2_TABLE_100();
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: a1 := JTF_NUMBER_TABLE();
341: a2 := JTF_NUMBER_TABLE();
342: a3 := JTF_NUMBER_TABLE();
343: a4 := JTF_NUMBER_TABLE();
344: a5 := JTF_VARCHAR2_TABLE_100();
345: a6 := JTF_VARCHAR2_TABLE_500();
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: a1 := JTF_NUMBER_TABLE();
341: a2 := JTF_NUMBER_TABLE();
342: a3 := JTF_NUMBER_TABLE();
343: a4 := JTF_NUMBER_TABLE();
344: a5 := JTF_VARCHAR2_TABLE_100();
345: a6 := JTF_VARCHAR2_TABLE_500();
346: a7 := JTF_VARCHAR2_TABLE_500();
339: a0 := JTF_NUMBER_TABLE();
340: a1 := JTF_NUMBER_TABLE();
341: a2 := JTF_NUMBER_TABLE();
342: a3 := JTF_NUMBER_TABLE();
343: a4 := JTF_NUMBER_TABLE();
344: a5 := JTF_VARCHAR2_TABLE_100();
345: a6 := JTF_VARCHAR2_TABLE_500();
346: a7 := JTF_VARCHAR2_TABLE_500();
347: a8 := JTF_VARCHAR2_TABLE_500();
356: a17 := JTF_VARCHAR2_TABLE_500();
357: a18 := JTF_VARCHAR2_TABLE_500();
358: a19 := JTF_VARCHAR2_TABLE_500();
359: a20 := JTF_VARCHAR2_TABLE_500();
360: a21 := JTF_NUMBER_TABLE();
361: a22 := JTF_DATE_TABLE();
362: a23 := JTF_NUMBER_TABLE();
363: a24 := JTF_DATE_TABLE();
364: a25 := JTF_NUMBER_TABLE();
358: a19 := JTF_VARCHAR2_TABLE_500();
359: a20 := JTF_VARCHAR2_TABLE_500();
360: a21 := JTF_NUMBER_TABLE();
361: a22 := JTF_DATE_TABLE();
362: a23 := JTF_NUMBER_TABLE();
363: a24 := JTF_DATE_TABLE();
364: a25 := JTF_NUMBER_TABLE();
365: else
366: a0 := JTF_NUMBER_TABLE();
360: a21 := JTF_NUMBER_TABLE();
361: a22 := JTF_DATE_TABLE();
362: a23 := JTF_NUMBER_TABLE();
363: a24 := JTF_DATE_TABLE();
364: a25 := JTF_NUMBER_TABLE();
365: else
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_NUMBER_TABLE();
368: a2 := JTF_NUMBER_TABLE();
362: a23 := JTF_NUMBER_TABLE();
363: a24 := JTF_DATE_TABLE();
364: a25 := JTF_NUMBER_TABLE();
365: else
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_NUMBER_TABLE();
368: a2 := JTF_NUMBER_TABLE();
369: a3 := JTF_NUMBER_TABLE();
370: a4 := JTF_NUMBER_TABLE();
363: a24 := JTF_DATE_TABLE();
364: a25 := JTF_NUMBER_TABLE();
365: else
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_NUMBER_TABLE();
368: a2 := JTF_NUMBER_TABLE();
369: a3 := JTF_NUMBER_TABLE();
370: a4 := JTF_NUMBER_TABLE();
371: a5 := JTF_VARCHAR2_TABLE_100();
364: a25 := JTF_NUMBER_TABLE();
365: else
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_NUMBER_TABLE();
368: a2 := JTF_NUMBER_TABLE();
369: a3 := JTF_NUMBER_TABLE();
370: a4 := JTF_NUMBER_TABLE();
371: a5 := JTF_VARCHAR2_TABLE_100();
372: a6 := JTF_VARCHAR2_TABLE_500();
365: else
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_NUMBER_TABLE();
368: a2 := JTF_NUMBER_TABLE();
369: a3 := JTF_NUMBER_TABLE();
370: a4 := JTF_NUMBER_TABLE();
371: a5 := JTF_VARCHAR2_TABLE_100();
372: a6 := JTF_VARCHAR2_TABLE_500();
373: a7 := JTF_VARCHAR2_TABLE_500();
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_NUMBER_TABLE();
368: a2 := JTF_NUMBER_TABLE();
369: a3 := JTF_NUMBER_TABLE();
370: a4 := JTF_NUMBER_TABLE();
371: a5 := JTF_VARCHAR2_TABLE_100();
372: a6 := JTF_VARCHAR2_TABLE_500();
373: a7 := JTF_VARCHAR2_TABLE_500();
374: a8 := JTF_VARCHAR2_TABLE_500();
383: a17 := JTF_VARCHAR2_TABLE_500();
384: a18 := JTF_VARCHAR2_TABLE_500();
385: a19 := JTF_VARCHAR2_TABLE_500();
386: a20 := JTF_VARCHAR2_TABLE_500();
387: a21 := JTF_NUMBER_TABLE();
388: a22 := JTF_DATE_TABLE();
389: a23 := JTF_NUMBER_TABLE();
390: a24 := JTF_DATE_TABLE();
391: a25 := JTF_NUMBER_TABLE();
385: a19 := JTF_VARCHAR2_TABLE_500();
386: a20 := JTF_VARCHAR2_TABLE_500();
387: a21 := JTF_NUMBER_TABLE();
388: a22 := JTF_DATE_TABLE();
389: a23 := JTF_NUMBER_TABLE();
390: a24 := JTF_DATE_TABLE();
391: a25 := JTF_NUMBER_TABLE();
392: if t.count > 0 then
393: a0.extend(t.count);
387: a21 := JTF_NUMBER_TABLE();
388: a22 := JTF_DATE_TABLE();
389: a23 := JTF_NUMBER_TABLE();
390: a24 := JTF_DATE_TABLE();
391: a25 := JTF_NUMBER_TABLE();
392: if t.count > 0 then
393: a0.extend(t.count);
394: a1.extend(t.count);
395: a2.extend(t.count);
602: , p_init_msg_list VARCHAR2
603: , x_return_status out nocopy VARCHAR2
604: , x_msg_count out nocopy NUMBER
605: , x_msg_data out nocopy VARCHAR2
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_NUMBER_TABLE
610: , p5_a4 JTF_NUMBER_TABLE
603: , x_return_status out nocopy VARCHAR2
604: , x_msg_count out nocopy NUMBER
605: , x_msg_data out nocopy VARCHAR2
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_NUMBER_TABLE
610: , p5_a4 JTF_NUMBER_TABLE
611: , p5_a5 JTF_VARCHAR2_TABLE_100
604: , x_msg_count out nocopy NUMBER
605: , x_msg_data out nocopy VARCHAR2
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_NUMBER_TABLE
610: , p5_a4 JTF_NUMBER_TABLE
611: , p5_a5 JTF_VARCHAR2_TABLE_100
612: , p5_a6 JTF_VARCHAR2_TABLE_500
605: , x_msg_data out nocopy VARCHAR2
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_NUMBER_TABLE
610: , p5_a4 JTF_NUMBER_TABLE
611: , p5_a5 JTF_VARCHAR2_TABLE_100
612: , p5_a6 JTF_VARCHAR2_TABLE_500
613: , p5_a7 JTF_VARCHAR2_TABLE_500
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_NUMBER_TABLE
610: , p5_a4 JTF_NUMBER_TABLE
611: , p5_a5 JTF_VARCHAR2_TABLE_100
612: , p5_a6 JTF_VARCHAR2_TABLE_500
613: , p5_a7 JTF_VARCHAR2_TABLE_500
614: , p5_a8 JTF_VARCHAR2_TABLE_500
623: , p5_a17 JTF_VARCHAR2_TABLE_500
624: , p5_a18 JTF_VARCHAR2_TABLE_500
625: , p5_a19 JTF_VARCHAR2_TABLE_500
626: , p5_a20 JTF_VARCHAR2_TABLE_500
627: , p5_a21 JTF_NUMBER_TABLE
628: , p5_a22 JTF_DATE_TABLE
629: , p5_a23 JTF_NUMBER_TABLE
630: , p5_a24 JTF_DATE_TABLE
631: , p5_a25 JTF_NUMBER_TABLE
625: , p5_a19 JTF_VARCHAR2_TABLE_500
626: , p5_a20 JTF_VARCHAR2_TABLE_500
627: , p5_a21 JTF_NUMBER_TABLE
628: , p5_a22 JTF_DATE_TABLE
629: , p5_a23 JTF_NUMBER_TABLE
630: , p5_a24 JTF_DATE_TABLE
631: , p5_a25 JTF_NUMBER_TABLE
632: , p6_a0 out nocopy JTF_NUMBER_TABLE
633: , p6_a1 out nocopy JTF_NUMBER_TABLE
627: , p5_a21 JTF_NUMBER_TABLE
628: , p5_a22 JTF_DATE_TABLE
629: , p5_a23 JTF_NUMBER_TABLE
630: , p5_a24 JTF_DATE_TABLE
631: , p5_a25 JTF_NUMBER_TABLE
632: , p6_a0 out nocopy JTF_NUMBER_TABLE
633: , p6_a1 out nocopy JTF_NUMBER_TABLE
634: , p6_a2 out nocopy JTF_NUMBER_TABLE
635: , p6_a3 out nocopy JTF_NUMBER_TABLE
628: , p5_a22 JTF_DATE_TABLE
629: , p5_a23 JTF_NUMBER_TABLE
630: , p5_a24 JTF_DATE_TABLE
631: , p5_a25 JTF_NUMBER_TABLE
632: , p6_a0 out nocopy JTF_NUMBER_TABLE
633: , p6_a1 out nocopy JTF_NUMBER_TABLE
634: , p6_a2 out nocopy JTF_NUMBER_TABLE
635: , p6_a3 out nocopy JTF_NUMBER_TABLE
636: , p6_a4 out nocopy JTF_NUMBER_TABLE
629: , p5_a23 JTF_NUMBER_TABLE
630: , p5_a24 JTF_DATE_TABLE
631: , p5_a25 JTF_NUMBER_TABLE
632: , p6_a0 out nocopy JTF_NUMBER_TABLE
633: , p6_a1 out nocopy JTF_NUMBER_TABLE
634: , p6_a2 out nocopy JTF_NUMBER_TABLE
635: , p6_a3 out nocopy JTF_NUMBER_TABLE
636: , p6_a4 out nocopy JTF_NUMBER_TABLE
637: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
630: , p5_a24 JTF_DATE_TABLE
631: , p5_a25 JTF_NUMBER_TABLE
632: , p6_a0 out nocopy JTF_NUMBER_TABLE
633: , p6_a1 out nocopy JTF_NUMBER_TABLE
634: , p6_a2 out nocopy JTF_NUMBER_TABLE
635: , p6_a3 out nocopy JTF_NUMBER_TABLE
636: , p6_a4 out nocopy JTF_NUMBER_TABLE
637: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
631: , p5_a25 JTF_NUMBER_TABLE
632: , p6_a0 out nocopy JTF_NUMBER_TABLE
633: , p6_a1 out nocopy JTF_NUMBER_TABLE
634: , p6_a2 out nocopy JTF_NUMBER_TABLE
635: , p6_a3 out nocopy JTF_NUMBER_TABLE
636: , p6_a4 out nocopy JTF_NUMBER_TABLE
637: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
639: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
632: , p6_a0 out nocopy JTF_NUMBER_TABLE
633: , p6_a1 out nocopy JTF_NUMBER_TABLE
634: , p6_a2 out nocopy JTF_NUMBER_TABLE
635: , p6_a3 out nocopy JTF_NUMBER_TABLE
636: , p6_a4 out nocopy JTF_NUMBER_TABLE
637: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
639: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
640: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
649: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
650: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
651: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
652: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
653: , p6_a21 out nocopy JTF_NUMBER_TABLE
654: , p6_a22 out nocopy JTF_DATE_TABLE
655: , p6_a23 out nocopy JTF_NUMBER_TABLE
656: , p6_a24 out nocopy JTF_DATE_TABLE
657: , p6_a25 out nocopy JTF_NUMBER_TABLE
651: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
652: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
653: , p6_a21 out nocopy JTF_NUMBER_TABLE
654: , p6_a22 out nocopy JTF_DATE_TABLE
655: , p6_a23 out nocopy JTF_NUMBER_TABLE
656: , p6_a24 out nocopy JTF_DATE_TABLE
657: , p6_a25 out nocopy JTF_NUMBER_TABLE
658: )
659:
653: , p6_a21 out nocopy JTF_NUMBER_TABLE
654: , p6_a22 out nocopy JTF_DATE_TABLE
655: , p6_a23 out nocopy JTF_NUMBER_TABLE
656: , p6_a24 out nocopy JTF_DATE_TABLE
657: , p6_a25 out nocopy JTF_NUMBER_TABLE
658: )
659:
660: as
661: ddp_ilsv_tbl okl_ils_pvt.ilsv_tbl_type;
834: , p_init_msg_list VARCHAR2
835: , x_return_status out nocopy VARCHAR2
836: , x_msg_count out nocopy NUMBER
837: , x_msg_data out nocopy VARCHAR2
838: , p5_a0 JTF_NUMBER_TABLE
839: , p5_a1 JTF_NUMBER_TABLE
840: , p5_a2 JTF_NUMBER_TABLE
841: , p5_a3 JTF_NUMBER_TABLE
842: , p5_a4 JTF_NUMBER_TABLE
835: , x_return_status out nocopy VARCHAR2
836: , x_msg_count out nocopy NUMBER
837: , x_msg_data out nocopy VARCHAR2
838: , p5_a0 JTF_NUMBER_TABLE
839: , p5_a1 JTF_NUMBER_TABLE
840: , p5_a2 JTF_NUMBER_TABLE
841: , p5_a3 JTF_NUMBER_TABLE
842: , p5_a4 JTF_NUMBER_TABLE
843: , p5_a5 JTF_VARCHAR2_TABLE_100
836: , x_msg_count out nocopy NUMBER
837: , x_msg_data out nocopy VARCHAR2
838: , p5_a0 JTF_NUMBER_TABLE
839: , p5_a1 JTF_NUMBER_TABLE
840: , p5_a2 JTF_NUMBER_TABLE
841: , p5_a3 JTF_NUMBER_TABLE
842: , p5_a4 JTF_NUMBER_TABLE
843: , p5_a5 JTF_VARCHAR2_TABLE_100
844: , p5_a6 JTF_VARCHAR2_TABLE_500
837: , x_msg_data out nocopy VARCHAR2
838: , p5_a0 JTF_NUMBER_TABLE
839: , p5_a1 JTF_NUMBER_TABLE
840: , p5_a2 JTF_NUMBER_TABLE
841: , p5_a3 JTF_NUMBER_TABLE
842: , p5_a4 JTF_NUMBER_TABLE
843: , p5_a5 JTF_VARCHAR2_TABLE_100
844: , p5_a6 JTF_VARCHAR2_TABLE_500
845: , p5_a7 JTF_VARCHAR2_TABLE_500
838: , p5_a0 JTF_NUMBER_TABLE
839: , p5_a1 JTF_NUMBER_TABLE
840: , p5_a2 JTF_NUMBER_TABLE
841: , p5_a3 JTF_NUMBER_TABLE
842: , p5_a4 JTF_NUMBER_TABLE
843: , p5_a5 JTF_VARCHAR2_TABLE_100
844: , p5_a6 JTF_VARCHAR2_TABLE_500
845: , p5_a7 JTF_VARCHAR2_TABLE_500
846: , p5_a8 JTF_VARCHAR2_TABLE_500
855: , p5_a17 JTF_VARCHAR2_TABLE_500
856: , p5_a18 JTF_VARCHAR2_TABLE_500
857: , p5_a19 JTF_VARCHAR2_TABLE_500
858: , p5_a20 JTF_VARCHAR2_TABLE_500
859: , p5_a21 JTF_NUMBER_TABLE
860: , p5_a22 JTF_DATE_TABLE
861: , p5_a23 JTF_NUMBER_TABLE
862: , p5_a24 JTF_DATE_TABLE
863: , p5_a25 JTF_NUMBER_TABLE
857: , p5_a19 JTF_VARCHAR2_TABLE_500
858: , p5_a20 JTF_VARCHAR2_TABLE_500
859: , p5_a21 JTF_NUMBER_TABLE
860: , p5_a22 JTF_DATE_TABLE
861: , p5_a23 JTF_NUMBER_TABLE
862: , p5_a24 JTF_DATE_TABLE
863: , p5_a25 JTF_NUMBER_TABLE
864: )
865:
859: , p5_a21 JTF_NUMBER_TABLE
860: , p5_a22 JTF_DATE_TABLE
861: , p5_a23 JTF_NUMBER_TABLE
862: , p5_a24 JTF_DATE_TABLE
863: , p5_a25 JTF_NUMBER_TABLE
864: )
865:
866: as
867: ddp_ilsv_tbl okl_ils_pvt.ilsv_tbl_type;
1065: , p_init_msg_list VARCHAR2
1066: , x_return_status out nocopy VARCHAR2
1067: , x_msg_count out nocopy NUMBER
1068: , x_msg_data out nocopy VARCHAR2
1069: , p5_a0 JTF_NUMBER_TABLE
1070: , p5_a1 JTF_NUMBER_TABLE
1071: , p5_a2 JTF_NUMBER_TABLE
1072: , p5_a3 JTF_NUMBER_TABLE
1073: , p5_a4 JTF_NUMBER_TABLE
1066: , x_return_status out nocopy VARCHAR2
1067: , x_msg_count out nocopy NUMBER
1068: , x_msg_data out nocopy VARCHAR2
1069: , p5_a0 JTF_NUMBER_TABLE
1070: , p5_a1 JTF_NUMBER_TABLE
1071: , p5_a2 JTF_NUMBER_TABLE
1072: , p5_a3 JTF_NUMBER_TABLE
1073: , p5_a4 JTF_NUMBER_TABLE
1074: , p5_a5 JTF_VARCHAR2_TABLE_100
1067: , x_msg_count out nocopy NUMBER
1068: , x_msg_data out nocopy VARCHAR2
1069: , p5_a0 JTF_NUMBER_TABLE
1070: , p5_a1 JTF_NUMBER_TABLE
1071: , p5_a2 JTF_NUMBER_TABLE
1072: , p5_a3 JTF_NUMBER_TABLE
1073: , p5_a4 JTF_NUMBER_TABLE
1074: , p5_a5 JTF_VARCHAR2_TABLE_100
1075: , p5_a6 JTF_VARCHAR2_TABLE_500
1068: , x_msg_data out nocopy VARCHAR2
1069: , p5_a0 JTF_NUMBER_TABLE
1070: , p5_a1 JTF_NUMBER_TABLE
1071: , p5_a2 JTF_NUMBER_TABLE
1072: , p5_a3 JTF_NUMBER_TABLE
1073: , p5_a4 JTF_NUMBER_TABLE
1074: , p5_a5 JTF_VARCHAR2_TABLE_100
1075: , p5_a6 JTF_VARCHAR2_TABLE_500
1076: , p5_a7 JTF_VARCHAR2_TABLE_500
1069: , p5_a0 JTF_NUMBER_TABLE
1070: , p5_a1 JTF_NUMBER_TABLE
1071: , p5_a2 JTF_NUMBER_TABLE
1072: , p5_a3 JTF_NUMBER_TABLE
1073: , p5_a4 JTF_NUMBER_TABLE
1074: , p5_a5 JTF_VARCHAR2_TABLE_100
1075: , p5_a6 JTF_VARCHAR2_TABLE_500
1076: , p5_a7 JTF_VARCHAR2_TABLE_500
1077: , p5_a8 JTF_VARCHAR2_TABLE_500
1086: , p5_a17 JTF_VARCHAR2_TABLE_500
1087: , p5_a18 JTF_VARCHAR2_TABLE_500
1088: , p5_a19 JTF_VARCHAR2_TABLE_500
1089: , p5_a20 JTF_VARCHAR2_TABLE_500
1090: , p5_a21 JTF_NUMBER_TABLE
1091: , p5_a22 JTF_DATE_TABLE
1092: , p5_a23 JTF_NUMBER_TABLE
1093: , p5_a24 JTF_DATE_TABLE
1094: , p5_a25 JTF_NUMBER_TABLE
1088: , p5_a19 JTF_VARCHAR2_TABLE_500
1089: , p5_a20 JTF_VARCHAR2_TABLE_500
1090: , p5_a21 JTF_NUMBER_TABLE
1091: , p5_a22 JTF_DATE_TABLE
1092: , p5_a23 JTF_NUMBER_TABLE
1093: , p5_a24 JTF_DATE_TABLE
1094: , p5_a25 JTF_NUMBER_TABLE
1095: , p6_a0 out nocopy JTF_NUMBER_TABLE
1096: , p6_a1 out nocopy JTF_NUMBER_TABLE
1090: , p5_a21 JTF_NUMBER_TABLE
1091: , p5_a22 JTF_DATE_TABLE
1092: , p5_a23 JTF_NUMBER_TABLE
1093: , p5_a24 JTF_DATE_TABLE
1094: , p5_a25 JTF_NUMBER_TABLE
1095: , p6_a0 out nocopy JTF_NUMBER_TABLE
1096: , p6_a1 out nocopy JTF_NUMBER_TABLE
1097: , p6_a2 out nocopy JTF_NUMBER_TABLE
1098: , p6_a3 out nocopy JTF_NUMBER_TABLE
1091: , p5_a22 JTF_DATE_TABLE
1092: , p5_a23 JTF_NUMBER_TABLE
1093: , p5_a24 JTF_DATE_TABLE
1094: , p5_a25 JTF_NUMBER_TABLE
1095: , p6_a0 out nocopy JTF_NUMBER_TABLE
1096: , p6_a1 out nocopy JTF_NUMBER_TABLE
1097: , p6_a2 out nocopy JTF_NUMBER_TABLE
1098: , p6_a3 out nocopy JTF_NUMBER_TABLE
1099: , p6_a4 out nocopy JTF_NUMBER_TABLE
1092: , p5_a23 JTF_NUMBER_TABLE
1093: , p5_a24 JTF_DATE_TABLE
1094: , p5_a25 JTF_NUMBER_TABLE
1095: , p6_a0 out nocopy JTF_NUMBER_TABLE
1096: , p6_a1 out nocopy JTF_NUMBER_TABLE
1097: , p6_a2 out nocopy JTF_NUMBER_TABLE
1098: , p6_a3 out nocopy JTF_NUMBER_TABLE
1099: , p6_a4 out nocopy JTF_NUMBER_TABLE
1100: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1093: , p5_a24 JTF_DATE_TABLE
1094: , p5_a25 JTF_NUMBER_TABLE
1095: , p6_a0 out nocopy JTF_NUMBER_TABLE
1096: , p6_a1 out nocopy JTF_NUMBER_TABLE
1097: , p6_a2 out nocopy JTF_NUMBER_TABLE
1098: , p6_a3 out nocopy JTF_NUMBER_TABLE
1099: , p6_a4 out nocopy JTF_NUMBER_TABLE
1100: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1101: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1094: , p5_a25 JTF_NUMBER_TABLE
1095: , p6_a0 out nocopy JTF_NUMBER_TABLE
1096: , p6_a1 out nocopy JTF_NUMBER_TABLE
1097: , p6_a2 out nocopy JTF_NUMBER_TABLE
1098: , p6_a3 out nocopy JTF_NUMBER_TABLE
1099: , p6_a4 out nocopy JTF_NUMBER_TABLE
1100: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1101: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1102: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1095: , p6_a0 out nocopy JTF_NUMBER_TABLE
1096: , p6_a1 out nocopy JTF_NUMBER_TABLE
1097: , p6_a2 out nocopy JTF_NUMBER_TABLE
1098: , p6_a3 out nocopy JTF_NUMBER_TABLE
1099: , p6_a4 out nocopy JTF_NUMBER_TABLE
1100: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1101: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1102: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1103: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1112: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1113: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1114: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1115: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1116: , p6_a21 out nocopy JTF_NUMBER_TABLE
1117: , p6_a22 out nocopy JTF_DATE_TABLE
1118: , p6_a23 out nocopy JTF_NUMBER_TABLE
1119: , p6_a24 out nocopy JTF_DATE_TABLE
1120: , p6_a25 out nocopy JTF_NUMBER_TABLE
1114: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1115: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1116: , p6_a21 out nocopy JTF_NUMBER_TABLE
1117: , p6_a22 out nocopy JTF_DATE_TABLE
1118: , p6_a23 out nocopy JTF_NUMBER_TABLE
1119: , p6_a24 out nocopy JTF_DATE_TABLE
1120: , p6_a25 out nocopy JTF_NUMBER_TABLE
1121: )
1122:
1116: , p6_a21 out nocopy JTF_NUMBER_TABLE
1117: , p6_a22 out nocopy JTF_DATE_TABLE
1118: , p6_a23 out nocopy JTF_NUMBER_TABLE
1119: , p6_a24 out nocopy JTF_DATE_TABLE
1120: , p6_a25 out nocopy JTF_NUMBER_TABLE
1121: )
1122:
1123: as
1124: ddp_ilsv_tbl okl_ils_pvt.ilsv_tbl_type;
1297: , p_init_msg_list VARCHAR2
1298: , x_return_status out nocopy VARCHAR2
1299: , x_msg_count out nocopy NUMBER
1300: , x_msg_data out nocopy VARCHAR2
1301: , p5_a0 JTF_NUMBER_TABLE
1302: , p5_a1 JTF_NUMBER_TABLE
1303: , p5_a2 JTF_NUMBER_TABLE
1304: , p5_a3 JTF_NUMBER_TABLE
1305: , p5_a4 JTF_NUMBER_TABLE
1298: , x_return_status out nocopy VARCHAR2
1299: , x_msg_count out nocopy NUMBER
1300: , x_msg_data out nocopy VARCHAR2
1301: , p5_a0 JTF_NUMBER_TABLE
1302: , p5_a1 JTF_NUMBER_TABLE
1303: , p5_a2 JTF_NUMBER_TABLE
1304: , p5_a3 JTF_NUMBER_TABLE
1305: , p5_a4 JTF_NUMBER_TABLE
1306: , p5_a5 JTF_VARCHAR2_TABLE_100
1299: , x_msg_count out nocopy NUMBER
1300: , x_msg_data out nocopy VARCHAR2
1301: , p5_a0 JTF_NUMBER_TABLE
1302: , p5_a1 JTF_NUMBER_TABLE
1303: , p5_a2 JTF_NUMBER_TABLE
1304: , p5_a3 JTF_NUMBER_TABLE
1305: , p5_a4 JTF_NUMBER_TABLE
1306: , p5_a5 JTF_VARCHAR2_TABLE_100
1307: , p5_a6 JTF_VARCHAR2_TABLE_500
1300: , x_msg_data out nocopy VARCHAR2
1301: , p5_a0 JTF_NUMBER_TABLE
1302: , p5_a1 JTF_NUMBER_TABLE
1303: , p5_a2 JTF_NUMBER_TABLE
1304: , p5_a3 JTF_NUMBER_TABLE
1305: , p5_a4 JTF_NUMBER_TABLE
1306: , p5_a5 JTF_VARCHAR2_TABLE_100
1307: , p5_a6 JTF_VARCHAR2_TABLE_500
1308: , p5_a7 JTF_VARCHAR2_TABLE_500
1301: , p5_a0 JTF_NUMBER_TABLE
1302: , p5_a1 JTF_NUMBER_TABLE
1303: , p5_a2 JTF_NUMBER_TABLE
1304: , p5_a3 JTF_NUMBER_TABLE
1305: , p5_a4 JTF_NUMBER_TABLE
1306: , p5_a5 JTF_VARCHAR2_TABLE_100
1307: , p5_a6 JTF_VARCHAR2_TABLE_500
1308: , p5_a7 JTF_VARCHAR2_TABLE_500
1309: , p5_a8 JTF_VARCHAR2_TABLE_500
1318: , p5_a17 JTF_VARCHAR2_TABLE_500
1319: , p5_a18 JTF_VARCHAR2_TABLE_500
1320: , p5_a19 JTF_VARCHAR2_TABLE_500
1321: , p5_a20 JTF_VARCHAR2_TABLE_500
1322: , p5_a21 JTF_NUMBER_TABLE
1323: , p5_a22 JTF_DATE_TABLE
1324: , p5_a23 JTF_NUMBER_TABLE
1325: , p5_a24 JTF_DATE_TABLE
1326: , p5_a25 JTF_NUMBER_TABLE
1320: , p5_a19 JTF_VARCHAR2_TABLE_500
1321: , p5_a20 JTF_VARCHAR2_TABLE_500
1322: , p5_a21 JTF_NUMBER_TABLE
1323: , p5_a22 JTF_DATE_TABLE
1324: , p5_a23 JTF_NUMBER_TABLE
1325: , p5_a24 JTF_DATE_TABLE
1326: , p5_a25 JTF_NUMBER_TABLE
1327: )
1328:
1322: , p5_a21 JTF_NUMBER_TABLE
1323: , p5_a22 JTF_DATE_TABLE
1324: , p5_a23 JTF_NUMBER_TABLE
1325: , p5_a24 JTF_DATE_TABLE
1326: , p5_a25 JTF_NUMBER_TABLE
1327: )
1328:
1329: as
1330: ddp_ilsv_tbl okl_ils_pvt.ilsv_tbl_type;
1472: , p_init_msg_list VARCHAR2
1473: , x_return_status out nocopy VARCHAR2
1474: , x_msg_count out nocopy NUMBER
1475: , x_msg_data out nocopy VARCHAR2
1476: , p5_a0 JTF_NUMBER_TABLE
1477: , p5_a1 JTF_NUMBER_TABLE
1478: , p5_a2 JTF_NUMBER_TABLE
1479: , p5_a3 JTF_NUMBER_TABLE
1480: , p5_a4 JTF_NUMBER_TABLE
1473: , x_return_status out nocopy VARCHAR2
1474: , x_msg_count out nocopy NUMBER
1475: , x_msg_data out nocopy VARCHAR2
1476: , p5_a0 JTF_NUMBER_TABLE
1477: , p5_a1 JTF_NUMBER_TABLE
1478: , p5_a2 JTF_NUMBER_TABLE
1479: , p5_a3 JTF_NUMBER_TABLE
1480: , p5_a4 JTF_NUMBER_TABLE
1481: , p5_a5 JTF_VARCHAR2_TABLE_100
1474: , x_msg_count out nocopy NUMBER
1475: , x_msg_data out nocopy VARCHAR2
1476: , p5_a0 JTF_NUMBER_TABLE
1477: , p5_a1 JTF_NUMBER_TABLE
1478: , p5_a2 JTF_NUMBER_TABLE
1479: , p5_a3 JTF_NUMBER_TABLE
1480: , p5_a4 JTF_NUMBER_TABLE
1481: , p5_a5 JTF_VARCHAR2_TABLE_100
1482: , p5_a6 JTF_VARCHAR2_TABLE_500
1475: , x_msg_data out nocopy VARCHAR2
1476: , p5_a0 JTF_NUMBER_TABLE
1477: , p5_a1 JTF_NUMBER_TABLE
1478: , p5_a2 JTF_NUMBER_TABLE
1479: , p5_a3 JTF_NUMBER_TABLE
1480: , p5_a4 JTF_NUMBER_TABLE
1481: , p5_a5 JTF_VARCHAR2_TABLE_100
1482: , p5_a6 JTF_VARCHAR2_TABLE_500
1483: , p5_a7 JTF_VARCHAR2_TABLE_500
1476: , p5_a0 JTF_NUMBER_TABLE
1477: , p5_a1 JTF_NUMBER_TABLE
1478: , p5_a2 JTF_NUMBER_TABLE
1479: , p5_a3 JTF_NUMBER_TABLE
1480: , p5_a4 JTF_NUMBER_TABLE
1481: , p5_a5 JTF_VARCHAR2_TABLE_100
1482: , p5_a6 JTF_VARCHAR2_TABLE_500
1483: , p5_a7 JTF_VARCHAR2_TABLE_500
1484: , p5_a8 JTF_VARCHAR2_TABLE_500
1493: , p5_a17 JTF_VARCHAR2_TABLE_500
1494: , p5_a18 JTF_VARCHAR2_TABLE_500
1495: , p5_a19 JTF_VARCHAR2_TABLE_500
1496: , p5_a20 JTF_VARCHAR2_TABLE_500
1497: , p5_a21 JTF_NUMBER_TABLE
1498: , p5_a22 JTF_DATE_TABLE
1499: , p5_a23 JTF_NUMBER_TABLE
1500: , p5_a24 JTF_DATE_TABLE
1501: , p5_a25 JTF_NUMBER_TABLE
1495: , p5_a19 JTF_VARCHAR2_TABLE_500
1496: , p5_a20 JTF_VARCHAR2_TABLE_500
1497: , p5_a21 JTF_NUMBER_TABLE
1498: , p5_a22 JTF_DATE_TABLE
1499: , p5_a23 JTF_NUMBER_TABLE
1500: , p5_a24 JTF_DATE_TABLE
1501: , p5_a25 JTF_NUMBER_TABLE
1502: )
1503:
1497: , p5_a21 JTF_NUMBER_TABLE
1498: , p5_a22 JTF_DATE_TABLE
1499: , p5_a23 JTF_NUMBER_TABLE
1500: , p5_a24 JTF_DATE_TABLE
1501: , p5_a25 JTF_NUMBER_TABLE
1502: )
1503:
1504: as
1505: ddp_ilsv_tbl okl_ils_pvt.ilsv_tbl_type;