1: package body okl_pam_pvt_w as
2: /* $Header: OKLIPAMB.pls 120.0 2005/07/07 10:40:11 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
1: package body okl_pam_pvt_w as
2: /* $Header: OKLIPAMB.pls 120.0 2005/07/07 10:40:11 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
1: package body okl_pam_pvt_w as
2: /* $Header: OKLIPAMB.pls 120.0 2005/07/07 10:40:11 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_VARCHAR2_TABLE_2000
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_VARCHAR2_TABLE_2000
35: ) as
36: ddindx binary_integer; indx binary_integer;
80: end loop;
81: end if;
82: end if;
83: end rosetta_table_copy_in_p1;
84: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
81: end if;
82: end if;
83: end rosetta_table_copy_in_p1;
84: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: , a5 out nocopy JTF_NUMBER_TABLE
82: end if;
83: end rosetta_table_copy_in_p1;
84: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: , a7 out nocopy JTF_DATE_TABLE
92: , a8 out nocopy JTF_DATE_TABLE
93: , a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , a21 out nocopy JTF_VARCHAR2_TABLE_500
106: , a22 out nocopy JTF_VARCHAR2_TABLE_500
107: , a23 out nocopy JTF_VARCHAR2_TABLE_500
108: , a24 out nocopy JTF_VARCHAR2_TABLE_500
109: , a25 out nocopy JTF_NUMBER_TABLE
110: , a26 out nocopy JTF_DATE_TABLE
111: , a27 out nocopy JTF_NUMBER_TABLE
112: , a28 out nocopy JTF_DATE_TABLE
113: , a29 out nocopy JTF_NUMBER_TABLE
107: , a23 out nocopy JTF_VARCHAR2_TABLE_500
108: , a24 out nocopy JTF_VARCHAR2_TABLE_500
109: , a25 out nocopy JTF_NUMBER_TABLE
110: , a26 out nocopy JTF_DATE_TABLE
111: , a27 out nocopy JTF_NUMBER_TABLE
112: , a28 out nocopy JTF_DATE_TABLE
113: , a29 out nocopy JTF_NUMBER_TABLE
114: , a30 out nocopy JTF_VARCHAR2_TABLE_300
115: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
109: , a25 out nocopy JTF_NUMBER_TABLE
110: , a26 out nocopy JTF_DATE_TABLE
111: , a27 out nocopy JTF_NUMBER_TABLE
112: , a28 out nocopy JTF_DATE_TABLE
113: , a29 out nocopy JTF_NUMBER_TABLE
114: , a30 out nocopy JTF_VARCHAR2_TABLE_300
115: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
116: ) as
117: ddindx binary_integer; indx binary_integer;
116: ) as
117: ddindx binary_integer; indx binary_integer;
118: begin
119: if t is null or t.count = 0 then
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
117: ddindx binary_integer; indx binary_integer;
118: begin
119: if t is null or t.count = 0 then
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_NUMBER_TABLE();
118: begin
119: if t is null or t.count = 0 then
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_NUMBER_TABLE();
126: a6 := JTF_VARCHAR2_TABLE_100();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_NUMBER_TABLE();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_DATE_TABLE();
128: a8 := JTF_DATE_TABLE();
129: a9 := JTF_VARCHAR2_TABLE_100();
141: a21 := JTF_VARCHAR2_TABLE_500();
142: a22 := JTF_VARCHAR2_TABLE_500();
143: a23 := JTF_VARCHAR2_TABLE_500();
144: a24 := JTF_VARCHAR2_TABLE_500();
145: a25 := JTF_NUMBER_TABLE();
146: a26 := JTF_DATE_TABLE();
147: a27 := JTF_NUMBER_TABLE();
148: a28 := JTF_DATE_TABLE();
149: a29 := JTF_NUMBER_TABLE();
143: a23 := JTF_VARCHAR2_TABLE_500();
144: a24 := JTF_VARCHAR2_TABLE_500();
145: a25 := JTF_NUMBER_TABLE();
146: a26 := JTF_DATE_TABLE();
147: a27 := JTF_NUMBER_TABLE();
148: a28 := JTF_DATE_TABLE();
149: a29 := JTF_NUMBER_TABLE();
150: a30 := JTF_VARCHAR2_TABLE_300();
151: a31 := JTF_VARCHAR2_TABLE_2000();
145: a25 := JTF_NUMBER_TABLE();
146: a26 := JTF_DATE_TABLE();
147: a27 := JTF_NUMBER_TABLE();
148: a28 := JTF_DATE_TABLE();
149: a29 := JTF_NUMBER_TABLE();
150: a30 := JTF_VARCHAR2_TABLE_300();
151: a31 := JTF_VARCHAR2_TABLE_2000();
152: else
153: a0 := JTF_NUMBER_TABLE();
149: a29 := JTF_NUMBER_TABLE();
150: a30 := JTF_VARCHAR2_TABLE_300();
151: a31 := JTF_VARCHAR2_TABLE_2000();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_NUMBER_TABLE();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_VARCHAR2_TABLE_100();
150: a30 := JTF_VARCHAR2_TABLE_300();
151: a31 := JTF_VARCHAR2_TABLE_2000();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_NUMBER_TABLE();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_VARCHAR2_TABLE_100();
158: a5 := JTF_NUMBER_TABLE();
151: a31 := JTF_VARCHAR2_TABLE_2000();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_NUMBER_TABLE();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_VARCHAR2_TABLE_100();
158: a5 := JTF_NUMBER_TABLE();
159: a6 := JTF_VARCHAR2_TABLE_100();
154: a1 := JTF_NUMBER_TABLE();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_VARCHAR2_TABLE_100();
158: a5 := JTF_NUMBER_TABLE();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_DATE_TABLE();
161: a8 := JTF_DATE_TABLE();
162: a9 := JTF_VARCHAR2_TABLE_100();
174: a21 := JTF_VARCHAR2_TABLE_500();
175: a22 := JTF_VARCHAR2_TABLE_500();
176: a23 := JTF_VARCHAR2_TABLE_500();
177: a24 := JTF_VARCHAR2_TABLE_500();
178: a25 := JTF_NUMBER_TABLE();
179: a26 := JTF_DATE_TABLE();
180: a27 := JTF_NUMBER_TABLE();
181: a28 := JTF_DATE_TABLE();
182: a29 := JTF_NUMBER_TABLE();
176: a23 := JTF_VARCHAR2_TABLE_500();
177: a24 := JTF_VARCHAR2_TABLE_500();
178: a25 := JTF_NUMBER_TABLE();
179: a26 := JTF_DATE_TABLE();
180: a27 := JTF_NUMBER_TABLE();
181: a28 := JTF_DATE_TABLE();
182: a29 := JTF_NUMBER_TABLE();
183: a30 := JTF_VARCHAR2_TABLE_300();
184: a31 := JTF_VARCHAR2_TABLE_2000();
178: a25 := JTF_NUMBER_TABLE();
179: a26 := JTF_DATE_TABLE();
180: a27 := JTF_NUMBER_TABLE();
181: a28 := JTF_DATE_TABLE();
182: a29 := JTF_NUMBER_TABLE();
183: a30 := JTF_VARCHAR2_TABLE_300();
184: a31 := JTF_VARCHAR2_TABLE_2000();
185: if t.count > 0 then
186: a0.extend(t.count);
259: end if;
260: end if;
261: end rosetta_table_copy_out_p1;
262:
263: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_300
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_NUMBER_TABLE
267: , a4 JTF_VARCHAR2_TABLE_100
261: end rosetta_table_copy_out_p1;
262:
263: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_300
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_NUMBER_TABLE
267: , a4 JTF_VARCHAR2_TABLE_100
268: , a5 JTF_VARCHAR2_TABLE_100
269: , a6 JTF_NUMBER_TABLE
262:
263: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_300
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_NUMBER_TABLE
267: , a4 JTF_VARCHAR2_TABLE_100
268: , a5 JTF_VARCHAR2_TABLE_100
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_VARCHAR2_TABLE_100
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_NUMBER_TABLE
267: , a4 JTF_VARCHAR2_TABLE_100
268: , a5 JTF_VARCHAR2_TABLE_100
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_VARCHAR2_TABLE_100
271: , a8 JTF_DATE_TABLE
272: , a9 JTF_DATE_TABLE
273: , a10 JTF_VARCHAR2_TABLE_100
285: , a22 JTF_VARCHAR2_TABLE_500
286: , a23 JTF_VARCHAR2_TABLE_500
287: , a24 JTF_VARCHAR2_TABLE_500
288: , a25 JTF_VARCHAR2_TABLE_500
289: , a26 JTF_NUMBER_TABLE
290: , a27 JTF_DATE_TABLE
291: , a28 JTF_NUMBER_TABLE
292: , a29 JTF_DATE_TABLE
293: , a30 JTF_NUMBER_TABLE
287: , a24 JTF_VARCHAR2_TABLE_500
288: , a25 JTF_VARCHAR2_TABLE_500
289: , a26 JTF_NUMBER_TABLE
290: , a27 JTF_DATE_TABLE
291: , a28 JTF_NUMBER_TABLE
292: , a29 JTF_DATE_TABLE
293: , a30 JTF_NUMBER_TABLE
294: ) as
295: ddindx binary_integer; indx binary_integer;
289: , a26 JTF_NUMBER_TABLE
290: , a27 JTF_DATE_TABLE
291: , a28 JTF_NUMBER_TABLE
292: , a29 JTF_DATE_TABLE
293: , a30 JTF_NUMBER_TABLE
294: ) as
295: ddindx binary_integer; indx binary_integer;
296: begin
297: if a0 is not null and a0.count > 0 then
338: end loop;
339: end if;
340: end if;
341: end rosetta_table_copy_in_p3;
342: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE
343: , a1 out nocopy JTF_VARCHAR2_TABLE_300
344: , a2 out nocopy JTF_NUMBER_TABLE
345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_VARCHAR2_TABLE_100
340: end if;
341: end rosetta_table_copy_in_p3;
342: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE
343: , a1 out nocopy JTF_VARCHAR2_TABLE_300
344: , a2 out nocopy JTF_NUMBER_TABLE
345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_VARCHAR2_TABLE_100
347: , a5 out nocopy JTF_VARCHAR2_TABLE_100
348: , a6 out nocopy JTF_NUMBER_TABLE
341: end rosetta_table_copy_in_p3;
342: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE
343: , a1 out nocopy JTF_VARCHAR2_TABLE_300
344: , a2 out nocopy JTF_NUMBER_TABLE
345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_VARCHAR2_TABLE_100
347: , a5 out nocopy JTF_VARCHAR2_TABLE_100
348: , a6 out nocopy JTF_NUMBER_TABLE
349: , a7 out nocopy JTF_VARCHAR2_TABLE_100
344: , a2 out nocopy JTF_NUMBER_TABLE
345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_VARCHAR2_TABLE_100
347: , a5 out nocopy JTF_VARCHAR2_TABLE_100
348: , a6 out nocopy JTF_NUMBER_TABLE
349: , a7 out nocopy JTF_VARCHAR2_TABLE_100
350: , a8 out nocopy JTF_DATE_TABLE
351: , a9 out nocopy JTF_DATE_TABLE
352: , a10 out nocopy JTF_VARCHAR2_TABLE_100
364: , a22 out nocopy JTF_VARCHAR2_TABLE_500
365: , a23 out nocopy JTF_VARCHAR2_TABLE_500
366: , a24 out nocopy JTF_VARCHAR2_TABLE_500
367: , a25 out nocopy JTF_VARCHAR2_TABLE_500
368: , a26 out nocopy JTF_NUMBER_TABLE
369: , a27 out nocopy JTF_DATE_TABLE
370: , a28 out nocopy JTF_NUMBER_TABLE
371: , a29 out nocopy JTF_DATE_TABLE
372: , a30 out nocopy JTF_NUMBER_TABLE
366: , a24 out nocopy JTF_VARCHAR2_TABLE_500
367: , a25 out nocopy JTF_VARCHAR2_TABLE_500
368: , a26 out nocopy JTF_NUMBER_TABLE
369: , a27 out nocopy JTF_DATE_TABLE
370: , a28 out nocopy JTF_NUMBER_TABLE
371: , a29 out nocopy JTF_DATE_TABLE
372: , a30 out nocopy JTF_NUMBER_TABLE
373: ) as
374: ddindx binary_integer; indx binary_integer;
368: , a26 out nocopy JTF_NUMBER_TABLE
369: , a27 out nocopy JTF_DATE_TABLE
370: , a28 out nocopy JTF_NUMBER_TABLE
371: , a29 out nocopy JTF_DATE_TABLE
372: , a30 out nocopy JTF_NUMBER_TABLE
373: ) as
374: ddindx binary_integer; indx binary_integer;
375: begin
376: if t is null or t.count = 0 then
373: ) as
374: ddindx binary_integer; indx binary_integer;
375: begin
376: if t is null or t.count = 0 then
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_VARCHAR2_TABLE_300();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_VARCHAR2_TABLE_100();
375: begin
376: if t is null or t.count = 0 then
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_VARCHAR2_TABLE_300();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_VARCHAR2_TABLE_100();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_NUMBER_TABLE();
376: if t is null or t.count = 0 then
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_VARCHAR2_TABLE_300();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_VARCHAR2_TABLE_100();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_NUMBER_TABLE();
384: a7 := JTF_VARCHAR2_TABLE_100();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_VARCHAR2_TABLE_100();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_NUMBER_TABLE();
384: a7 := JTF_VARCHAR2_TABLE_100();
385: a8 := JTF_DATE_TABLE();
386: a9 := JTF_DATE_TABLE();
387: a10 := JTF_VARCHAR2_TABLE_100();
399: a22 := JTF_VARCHAR2_TABLE_500();
400: a23 := JTF_VARCHAR2_TABLE_500();
401: a24 := JTF_VARCHAR2_TABLE_500();
402: a25 := JTF_VARCHAR2_TABLE_500();
403: a26 := JTF_NUMBER_TABLE();
404: a27 := JTF_DATE_TABLE();
405: a28 := JTF_NUMBER_TABLE();
406: a29 := JTF_DATE_TABLE();
407: a30 := JTF_NUMBER_TABLE();
401: a24 := JTF_VARCHAR2_TABLE_500();
402: a25 := JTF_VARCHAR2_TABLE_500();
403: a26 := JTF_NUMBER_TABLE();
404: a27 := JTF_DATE_TABLE();
405: a28 := JTF_NUMBER_TABLE();
406: a29 := JTF_DATE_TABLE();
407: a30 := JTF_NUMBER_TABLE();
408: else
409: a0 := JTF_NUMBER_TABLE();
403: a26 := JTF_NUMBER_TABLE();
404: a27 := JTF_DATE_TABLE();
405: a28 := JTF_NUMBER_TABLE();
406: a29 := JTF_DATE_TABLE();
407: a30 := JTF_NUMBER_TABLE();
408: else
409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_VARCHAR2_TABLE_300();
411: a2 := JTF_NUMBER_TABLE();
405: a28 := JTF_NUMBER_TABLE();
406: a29 := JTF_DATE_TABLE();
407: a30 := JTF_NUMBER_TABLE();
408: else
409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_VARCHAR2_TABLE_300();
411: a2 := JTF_NUMBER_TABLE();
412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_VARCHAR2_TABLE_100();
407: a30 := JTF_NUMBER_TABLE();
408: else
409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_VARCHAR2_TABLE_300();
411: a2 := JTF_NUMBER_TABLE();
412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_VARCHAR2_TABLE_100();
414: a5 := JTF_VARCHAR2_TABLE_100();
415: a6 := JTF_NUMBER_TABLE();
408: else
409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_VARCHAR2_TABLE_300();
411: a2 := JTF_NUMBER_TABLE();
412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_VARCHAR2_TABLE_100();
414: a5 := JTF_VARCHAR2_TABLE_100();
415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_100();
411: a2 := JTF_NUMBER_TABLE();
412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_VARCHAR2_TABLE_100();
414: a5 := JTF_VARCHAR2_TABLE_100();
415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_100();
417: a8 := JTF_DATE_TABLE();
418: a9 := JTF_DATE_TABLE();
419: a10 := JTF_VARCHAR2_TABLE_100();
431: a22 := JTF_VARCHAR2_TABLE_500();
432: a23 := JTF_VARCHAR2_TABLE_500();
433: a24 := JTF_VARCHAR2_TABLE_500();
434: a25 := JTF_VARCHAR2_TABLE_500();
435: a26 := JTF_NUMBER_TABLE();
436: a27 := JTF_DATE_TABLE();
437: a28 := JTF_NUMBER_TABLE();
438: a29 := JTF_DATE_TABLE();
439: a30 := JTF_NUMBER_TABLE();
433: a24 := JTF_VARCHAR2_TABLE_500();
434: a25 := JTF_VARCHAR2_TABLE_500();
435: a26 := JTF_NUMBER_TABLE();
436: a27 := JTF_DATE_TABLE();
437: a28 := JTF_NUMBER_TABLE();
438: a29 := JTF_DATE_TABLE();
439: a30 := JTF_NUMBER_TABLE();
440: if t.count > 0 then
441: a0.extend(t.count);
435: a26 := JTF_NUMBER_TABLE();
436: a27 := JTF_DATE_TABLE();
437: a28 := JTF_NUMBER_TABLE();
438: a29 := JTF_DATE_TABLE();
439: a30 := JTF_NUMBER_TABLE();
440: if t.count > 0 then
441: a0.extend(t.count);
442: a1.extend(t.count);
443: a2.extend(t.count);
512: end if;
513: end if;
514: end rosetta_table_copy_out_p3;
515:
516: procedure rosetta_table_copy_in_p5(t out nocopy okl_pam_pvt.okl_pamtl_tbl, a0 JTF_NUMBER_TABLE
517: , a1 JTF_VARCHAR2_TABLE_2000
518: , a2 JTF_VARCHAR2_TABLE_100
519: , a3 JTF_VARCHAR2_TABLE_100
520: , a4 JTF_VARCHAR2_TABLE_100
517: , a1 JTF_VARCHAR2_TABLE_2000
518: , a2 JTF_VARCHAR2_TABLE_100
519: , a3 JTF_VARCHAR2_TABLE_100
520: , a4 JTF_VARCHAR2_TABLE_100
521: , a5 JTF_NUMBER_TABLE
522: , a6 JTF_DATE_TABLE
523: , a7 JTF_NUMBER_TABLE
524: , a8 JTF_DATE_TABLE
525: , a9 JTF_NUMBER_TABLE
519: , a3 JTF_VARCHAR2_TABLE_100
520: , a4 JTF_VARCHAR2_TABLE_100
521: , a5 JTF_NUMBER_TABLE
522: , a6 JTF_DATE_TABLE
523: , a7 JTF_NUMBER_TABLE
524: , a8 JTF_DATE_TABLE
525: , a9 JTF_NUMBER_TABLE
526: ) as
527: ddindx binary_integer; indx binary_integer;
521: , a5 JTF_NUMBER_TABLE
522: , a6 JTF_DATE_TABLE
523: , a7 JTF_NUMBER_TABLE
524: , a8 JTF_DATE_TABLE
525: , a9 JTF_NUMBER_TABLE
526: ) as
527: ddindx binary_integer; indx binary_integer;
528: begin
529: if a0 is not null and a0.count > 0 then
549: end loop;
550: end if;
551: end if;
552: end rosetta_table_copy_in_p5;
553: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
554: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
555: , a2 out nocopy JTF_VARCHAR2_TABLE_100
556: , a3 out nocopy JTF_VARCHAR2_TABLE_100
557: , a4 out nocopy JTF_VARCHAR2_TABLE_100
554: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
555: , a2 out nocopy JTF_VARCHAR2_TABLE_100
556: , a3 out nocopy JTF_VARCHAR2_TABLE_100
557: , a4 out nocopy JTF_VARCHAR2_TABLE_100
558: , a5 out nocopy JTF_NUMBER_TABLE
559: , a6 out nocopy JTF_DATE_TABLE
560: , a7 out nocopy JTF_NUMBER_TABLE
561: , a8 out nocopy JTF_DATE_TABLE
562: , a9 out nocopy JTF_NUMBER_TABLE
556: , a3 out nocopy JTF_VARCHAR2_TABLE_100
557: , a4 out nocopy JTF_VARCHAR2_TABLE_100
558: , a5 out nocopy JTF_NUMBER_TABLE
559: , a6 out nocopy JTF_DATE_TABLE
560: , a7 out nocopy JTF_NUMBER_TABLE
561: , a8 out nocopy JTF_DATE_TABLE
562: , a9 out nocopy JTF_NUMBER_TABLE
563: ) as
564: ddindx binary_integer; indx binary_integer;
558: , a5 out nocopy JTF_NUMBER_TABLE
559: , a6 out nocopy JTF_DATE_TABLE
560: , a7 out nocopy JTF_NUMBER_TABLE
561: , a8 out nocopy JTF_DATE_TABLE
562: , a9 out nocopy JTF_NUMBER_TABLE
563: ) as
564: ddindx binary_integer; indx binary_integer;
565: begin
566: if t is null or t.count = 0 then
563: ) as
564: ddindx binary_integer; indx binary_integer;
565: begin
566: if t is null or t.count = 0 then
567: a0 := JTF_NUMBER_TABLE();
568: a1 := JTF_VARCHAR2_TABLE_2000();
569: a2 := JTF_VARCHAR2_TABLE_100();
570: a3 := JTF_VARCHAR2_TABLE_100();
571: a4 := JTF_VARCHAR2_TABLE_100();
568: a1 := JTF_VARCHAR2_TABLE_2000();
569: a2 := JTF_VARCHAR2_TABLE_100();
570: a3 := JTF_VARCHAR2_TABLE_100();
571: a4 := JTF_VARCHAR2_TABLE_100();
572: a5 := JTF_NUMBER_TABLE();
573: a6 := JTF_DATE_TABLE();
574: a7 := JTF_NUMBER_TABLE();
575: a8 := JTF_DATE_TABLE();
576: a9 := JTF_NUMBER_TABLE();
570: a3 := JTF_VARCHAR2_TABLE_100();
571: a4 := JTF_VARCHAR2_TABLE_100();
572: a5 := JTF_NUMBER_TABLE();
573: a6 := JTF_DATE_TABLE();
574: a7 := JTF_NUMBER_TABLE();
575: a8 := JTF_DATE_TABLE();
576: a9 := JTF_NUMBER_TABLE();
577: else
578: a0 := JTF_NUMBER_TABLE();
572: a5 := JTF_NUMBER_TABLE();
573: a6 := JTF_DATE_TABLE();
574: a7 := JTF_NUMBER_TABLE();
575: a8 := JTF_DATE_TABLE();
576: a9 := JTF_NUMBER_TABLE();
577: else
578: a0 := JTF_NUMBER_TABLE();
579: a1 := JTF_VARCHAR2_TABLE_2000();
580: a2 := JTF_VARCHAR2_TABLE_100();
574: a7 := JTF_NUMBER_TABLE();
575: a8 := JTF_DATE_TABLE();
576: a9 := JTF_NUMBER_TABLE();
577: else
578: a0 := JTF_NUMBER_TABLE();
579: a1 := JTF_VARCHAR2_TABLE_2000();
580: a2 := JTF_VARCHAR2_TABLE_100();
581: a3 := JTF_VARCHAR2_TABLE_100();
582: a4 := JTF_VARCHAR2_TABLE_100();
579: a1 := JTF_VARCHAR2_TABLE_2000();
580: a2 := JTF_VARCHAR2_TABLE_100();
581: a3 := JTF_VARCHAR2_TABLE_100();
582: a4 := JTF_VARCHAR2_TABLE_100();
583: a5 := JTF_NUMBER_TABLE();
584: a6 := JTF_DATE_TABLE();
585: a7 := JTF_NUMBER_TABLE();
586: a8 := JTF_DATE_TABLE();
587: a9 := JTF_NUMBER_TABLE();
581: a3 := JTF_VARCHAR2_TABLE_100();
582: a4 := JTF_VARCHAR2_TABLE_100();
583: a5 := JTF_NUMBER_TABLE();
584: a6 := JTF_DATE_TABLE();
585: a7 := JTF_NUMBER_TABLE();
586: a8 := JTF_DATE_TABLE();
587: a9 := JTF_NUMBER_TABLE();
588: if t.count > 0 then
589: a0.extend(t.count);
583: a5 := JTF_NUMBER_TABLE();
584: a6 := JTF_DATE_TABLE();
585: a7 := JTF_NUMBER_TABLE();
586: a8 := JTF_DATE_TABLE();
587: a9 := JTF_NUMBER_TABLE();
588: if t.count > 0 then
589: a0.extend(t.count);
590: a1.extend(t.count);
591: a2.extend(t.count);
790: , p_init_msg_list VARCHAR2
791: , x_return_status out nocopy VARCHAR2
792: , x_msg_count out nocopy NUMBER
793: , x_msg_data out nocopy VARCHAR2
794: , p5_a0 JTF_NUMBER_TABLE
795: , p5_a1 JTF_NUMBER_TABLE
796: , p5_a2 JTF_NUMBER_TABLE
797: , p5_a3 JTF_VARCHAR2_TABLE_100
798: , p5_a4 JTF_VARCHAR2_TABLE_100
791: , x_return_status out nocopy VARCHAR2
792: , x_msg_count out nocopy NUMBER
793: , x_msg_data out nocopy VARCHAR2
794: , p5_a0 JTF_NUMBER_TABLE
795: , p5_a1 JTF_NUMBER_TABLE
796: , p5_a2 JTF_NUMBER_TABLE
797: , p5_a3 JTF_VARCHAR2_TABLE_100
798: , p5_a4 JTF_VARCHAR2_TABLE_100
799: , p5_a5 JTF_NUMBER_TABLE
792: , x_msg_count out nocopy NUMBER
793: , x_msg_data out nocopy VARCHAR2
794: , p5_a0 JTF_NUMBER_TABLE
795: , p5_a1 JTF_NUMBER_TABLE
796: , p5_a2 JTF_NUMBER_TABLE
797: , p5_a3 JTF_VARCHAR2_TABLE_100
798: , p5_a4 JTF_VARCHAR2_TABLE_100
799: , p5_a5 JTF_NUMBER_TABLE
800: , p5_a6 JTF_VARCHAR2_TABLE_100
795: , p5_a1 JTF_NUMBER_TABLE
796: , p5_a2 JTF_NUMBER_TABLE
797: , p5_a3 JTF_VARCHAR2_TABLE_100
798: , p5_a4 JTF_VARCHAR2_TABLE_100
799: , p5_a5 JTF_NUMBER_TABLE
800: , p5_a6 JTF_VARCHAR2_TABLE_100
801: , p5_a7 JTF_DATE_TABLE
802: , p5_a8 JTF_DATE_TABLE
803: , p5_a9 JTF_VARCHAR2_TABLE_100
815: , p5_a21 JTF_VARCHAR2_TABLE_500
816: , p5_a22 JTF_VARCHAR2_TABLE_500
817: , p5_a23 JTF_VARCHAR2_TABLE_500
818: , p5_a24 JTF_VARCHAR2_TABLE_500
819: , p5_a25 JTF_NUMBER_TABLE
820: , p5_a26 JTF_DATE_TABLE
821: , p5_a27 JTF_NUMBER_TABLE
822: , p5_a28 JTF_DATE_TABLE
823: , p5_a29 JTF_NUMBER_TABLE
817: , p5_a23 JTF_VARCHAR2_TABLE_500
818: , p5_a24 JTF_VARCHAR2_TABLE_500
819: , p5_a25 JTF_NUMBER_TABLE
820: , p5_a26 JTF_DATE_TABLE
821: , p5_a27 JTF_NUMBER_TABLE
822: , p5_a28 JTF_DATE_TABLE
823: , p5_a29 JTF_NUMBER_TABLE
824: , p5_a30 JTF_VARCHAR2_TABLE_300
825: , p5_a31 JTF_VARCHAR2_TABLE_2000
819: , p5_a25 JTF_NUMBER_TABLE
820: , p5_a26 JTF_DATE_TABLE
821: , p5_a27 JTF_NUMBER_TABLE
822: , p5_a28 JTF_DATE_TABLE
823: , p5_a29 JTF_NUMBER_TABLE
824: , p5_a30 JTF_VARCHAR2_TABLE_300
825: , p5_a31 JTF_VARCHAR2_TABLE_2000
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
822: , p5_a28 JTF_DATE_TABLE
823: , p5_a29 JTF_NUMBER_TABLE
824: , p5_a30 JTF_VARCHAR2_TABLE_300
825: , p5_a31 JTF_VARCHAR2_TABLE_2000
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_NUMBER_TABLE
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
823: , p5_a29 JTF_NUMBER_TABLE
824: , p5_a30 JTF_VARCHAR2_TABLE_300
825: , p5_a31 JTF_VARCHAR2_TABLE_2000
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_NUMBER_TABLE
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_NUMBER_TABLE
824: , p5_a30 JTF_VARCHAR2_TABLE_300
825: , p5_a31 JTF_VARCHAR2_TABLE_2000
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_NUMBER_TABLE
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_NUMBER_TABLE
832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_NUMBER_TABLE
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_NUMBER_TABLE
832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
833: , p6_a7 out nocopy JTF_DATE_TABLE
834: , p6_a8 out nocopy JTF_DATE_TABLE
835: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
847: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
848: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
849: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
850: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
851: , p6_a25 out nocopy JTF_NUMBER_TABLE
852: , p6_a26 out nocopy JTF_DATE_TABLE
853: , p6_a27 out nocopy JTF_NUMBER_TABLE
854: , p6_a28 out nocopy JTF_DATE_TABLE
855: , p6_a29 out nocopy JTF_NUMBER_TABLE
849: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
850: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
851: , p6_a25 out nocopy JTF_NUMBER_TABLE
852: , p6_a26 out nocopy JTF_DATE_TABLE
853: , p6_a27 out nocopy JTF_NUMBER_TABLE
854: , p6_a28 out nocopy JTF_DATE_TABLE
855: , p6_a29 out nocopy JTF_NUMBER_TABLE
856: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
857: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000
851: , p6_a25 out nocopy JTF_NUMBER_TABLE
852: , p6_a26 out nocopy JTF_DATE_TABLE
853: , p6_a27 out nocopy JTF_NUMBER_TABLE
854: , p6_a28 out nocopy JTF_DATE_TABLE
855: , p6_a29 out nocopy JTF_NUMBER_TABLE
856: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
857: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000
858: )
859:
1126: , p_init_msg_list VARCHAR2
1127: , x_return_status out nocopy VARCHAR2
1128: , x_msg_count out nocopy NUMBER
1129: , x_msg_data out nocopy VARCHAR2
1130: , p5_a0 JTF_NUMBER_TABLE
1131: , p5_a1 JTF_NUMBER_TABLE
1132: , p5_a2 JTF_NUMBER_TABLE
1133: , p5_a3 JTF_VARCHAR2_TABLE_100
1134: , p5_a4 JTF_VARCHAR2_TABLE_100
1127: , x_return_status out nocopy VARCHAR2
1128: , x_msg_count out nocopy NUMBER
1129: , x_msg_data out nocopy VARCHAR2
1130: , p5_a0 JTF_NUMBER_TABLE
1131: , p5_a1 JTF_NUMBER_TABLE
1132: , p5_a2 JTF_NUMBER_TABLE
1133: , p5_a3 JTF_VARCHAR2_TABLE_100
1134: , p5_a4 JTF_VARCHAR2_TABLE_100
1135: , p5_a5 JTF_NUMBER_TABLE
1128: , x_msg_count out nocopy NUMBER
1129: , x_msg_data out nocopy VARCHAR2
1130: , p5_a0 JTF_NUMBER_TABLE
1131: , p5_a1 JTF_NUMBER_TABLE
1132: , p5_a2 JTF_NUMBER_TABLE
1133: , p5_a3 JTF_VARCHAR2_TABLE_100
1134: , p5_a4 JTF_VARCHAR2_TABLE_100
1135: , p5_a5 JTF_NUMBER_TABLE
1136: , p5_a6 JTF_VARCHAR2_TABLE_100
1131: , p5_a1 JTF_NUMBER_TABLE
1132: , p5_a2 JTF_NUMBER_TABLE
1133: , p5_a3 JTF_VARCHAR2_TABLE_100
1134: , p5_a4 JTF_VARCHAR2_TABLE_100
1135: , p5_a5 JTF_NUMBER_TABLE
1136: , p5_a6 JTF_VARCHAR2_TABLE_100
1137: , p5_a7 JTF_DATE_TABLE
1138: , p5_a8 JTF_DATE_TABLE
1139: , p5_a9 JTF_VARCHAR2_TABLE_100
1151: , p5_a21 JTF_VARCHAR2_TABLE_500
1152: , p5_a22 JTF_VARCHAR2_TABLE_500
1153: , p5_a23 JTF_VARCHAR2_TABLE_500
1154: , p5_a24 JTF_VARCHAR2_TABLE_500
1155: , p5_a25 JTF_NUMBER_TABLE
1156: , p5_a26 JTF_DATE_TABLE
1157: , p5_a27 JTF_NUMBER_TABLE
1158: , p5_a28 JTF_DATE_TABLE
1159: , p5_a29 JTF_NUMBER_TABLE
1153: , p5_a23 JTF_VARCHAR2_TABLE_500
1154: , p5_a24 JTF_VARCHAR2_TABLE_500
1155: , p5_a25 JTF_NUMBER_TABLE
1156: , p5_a26 JTF_DATE_TABLE
1157: , p5_a27 JTF_NUMBER_TABLE
1158: , p5_a28 JTF_DATE_TABLE
1159: , p5_a29 JTF_NUMBER_TABLE
1160: , p5_a30 JTF_VARCHAR2_TABLE_300
1161: , p5_a31 JTF_VARCHAR2_TABLE_2000
1155: , p5_a25 JTF_NUMBER_TABLE
1156: , p5_a26 JTF_DATE_TABLE
1157: , p5_a27 JTF_NUMBER_TABLE
1158: , p5_a28 JTF_DATE_TABLE
1159: , p5_a29 JTF_NUMBER_TABLE
1160: , p5_a30 JTF_VARCHAR2_TABLE_300
1161: , p5_a31 JTF_VARCHAR2_TABLE_2000
1162: , p6_a0 out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 out nocopy JTF_NUMBER_TABLE
1158: , p5_a28 JTF_DATE_TABLE
1159: , p5_a29 JTF_NUMBER_TABLE
1160: , p5_a30 JTF_VARCHAR2_TABLE_300
1161: , p5_a31 JTF_VARCHAR2_TABLE_2000
1162: , p6_a0 out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 out nocopy JTF_NUMBER_TABLE
1164: , p6_a2 out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1166: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1159: , p5_a29 JTF_NUMBER_TABLE
1160: , p5_a30 JTF_VARCHAR2_TABLE_300
1161: , p5_a31 JTF_VARCHAR2_TABLE_2000
1162: , p6_a0 out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 out nocopy JTF_NUMBER_TABLE
1164: , p6_a2 out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1166: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1167: , p6_a5 out nocopy JTF_NUMBER_TABLE
1160: , p5_a30 JTF_VARCHAR2_TABLE_300
1161: , p5_a31 JTF_VARCHAR2_TABLE_2000
1162: , p6_a0 out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 out nocopy JTF_NUMBER_TABLE
1164: , p6_a2 out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1166: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1167: , p6_a5 out nocopy JTF_NUMBER_TABLE
1168: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1163: , p6_a1 out nocopy JTF_NUMBER_TABLE
1164: , p6_a2 out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1166: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1167: , p6_a5 out nocopy JTF_NUMBER_TABLE
1168: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p6_a7 out nocopy JTF_DATE_TABLE
1170: , p6_a8 out nocopy JTF_DATE_TABLE
1171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1183: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1184: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1185: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1186: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1187: , p6_a25 out nocopy JTF_NUMBER_TABLE
1188: , p6_a26 out nocopy JTF_DATE_TABLE
1189: , p6_a27 out nocopy JTF_NUMBER_TABLE
1190: , p6_a28 out nocopy JTF_DATE_TABLE
1191: , p6_a29 out nocopy JTF_NUMBER_TABLE
1185: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1186: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1187: , p6_a25 out nocopy JTF_NUMBER_TABLE
1188: , p6_a26 out nocopy JTF_DATE_TABLE
1189: , p6_a27 out nocopy JTF_NUMBER_TABLE
1190: , p6_a28 out nocopy JTF_DATE_TABLE
1191: , p6_a29 out nocopy JTF_NUMBER_TABLE
1192: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
1193: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1187: , p6_a25 out nocopy JTF_NUMBER_TABLE
1188: , p6_a26 out nocopy JTF_DATE_TABLE
1189: , p6_a27 out nocopy JTF_NUMBER_TABLE
1190: , p6_a28 out nocopy JTF_DATE_TABLE
1191: , p6_a29 out nocopy JTF_NUMBER_TABLE
1192: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
1193: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1194: )
1195:
1394: , p_init_msg_list VARCHAR2
1395: , x_return_status out nocopy VARCHAR2
1396: , x_msg_count out nocopy NUMBER
1397: , x_msg_data out nocopy VARCHAR2
1398: , p5_a0 JTF_NUMBER_TABLE
1399: , p5_a1 JTF_NUMBER_TABLE
1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_100
1402: , p5_a4 JTF_VARCHAR2_TABLE_100
1395: , x_return_status out nocopy VARCHAR2
1396: , x_msg_count out nocopy NUMBER
1397: , x_msg_data out nocopy VARCHAR2
1398: , p5_a0 JTF_NUMBER_TABLE
1399: , p5_a1 JTF_NUMBER_TABLE
1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_100
1402: , p5_a4 JTF_VARCHAR2_TABLE_100
1403: , p5_a5 JTF_NUMBER_TABLE
1396: , x_msg_count out nocopy NUMBER
1397: , x_msg_data out nocopy VARCHAR2
1398: , p5_a0 JTF_NUMBER_TABLE
1399: , p5_a1 JTF_NUMBER_TABLE
1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_100
1402: , p5_a4 JTF_VARCHAR2_TABLE_100
1403: , p5_a5 JTF_NUMBER_TABLE
1404: , p5_a6 JTF_VARCHAR2_TABLE_100
1399: , p5_a1 JTF_NUMBER_TABLE
1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_100
1402: , p5_a4 JTF_VARCHAR2_TABLE_100
1403: , p5_a5 JTF_NUMBER_TABLE
1404: , p5_a6 JTF_VARCHAR2_TABLE_100
1405: , p5_a7 JTF_DATE_TABLE
1406: , p5_a8 JTF_DATE_TABLE
1407: , p5_a9 JTF_VARCHAR2_TABLE_100
1419: , p5_a21 JTF_VARCHAR2_TABLE_500
1420: , p5_a22 JTF_VARCHAR2_TABLE_500
1421: , p5_a23 JTF_VARCHAR2_TABLE_500
1422: , p5_a24 JTF_VARCHAR2_TABLE_500
1423: , p5_a25 JTF_NUMBER_TABLE
1424: , p5_a26 JTF_DATE_TABLE
1425: , p5_a27 JTF_NUMBER_TABLE
1426: , p5_a28 JTF_DATE_TABLE
1427: , p5_a29 JTF_NUMBER_TABLE
1421: , p5_a23 JTF_VARCHAR2_TABLE_500
1422: , p5_a24 JTF_VARCHAR2_TABLE_500
1423: , p5_a25 JTF_NUMBER_TABLE
1424: , p5_a26 JTF_DATE_TABLE
1425: , p5_a27 JTF_NUMBER_TABLE
1426: , p5_a28 JTF_DATE_TABLE
1427: , p5_a29 JTF_NUMBER_TABLE
1428: , p5_a30 JTF_VARCHAR2_TABLE_300
1429: , p5_a31 JTF_VARCHAR2_TABLE_2000
1423: , p5_a25 JTF_NUMBER_TABLE
1424: , p5_a26 JTF_DATE_TABLE
1425: , p5_a27 JTF_NUMBER_TABLE
1426: , p5_a28 JTF_DATE_TABLE
1427: , p5_a29 JTF_NUMBER_TABLE
1428: , p5_a30 JTF_VARCHAR2_TABLE_300
1429: , p5_a31 JTF_VARCHAR2_TABLE_2000
1430: )
1431: