18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p10(t out nocopy okl_split_asset_pvt.cle_tbl_type, a0 JTF_NUMBER_TABLE
23: ) as
24: ddindx binary_integer; indx binary_integer;
25: begin
26: if a0 is not null and a0.count > 0 then
37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p10;
41: procedure rosetta_table_copy_out_p10(t okl_split_asset_pvt.cle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_NUMBER_TABLE();
47: else
48: a0 := JTF_NUMBER_TABLE();
49: if t.count > 0 then
50: a0.extend(t.count);
44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_NUMBER_TABLE();
47: else
48: a0 := JTF_NUMBER_TABLE();
49: if t.count > 0 then
50: a0.extend(t.count);
51: ddindx := t.first;
52: indx := 1;
61: end if;
62: end if;
63: end rosetta_table_copy_out_p10;
64:
65: procedure rosetta_table_copy_in_p13(t out nocopy okl_split_asset_pvt.ib_tbl_type, a0 JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if a0 is not null and a0.count > 0 then
80: end loop;
81: end if;
82: end if;
83: end rosetta_table_copy_in_p13;
84: procedure rosetta_table_copy_out_p13(t okl_split_asset_pvt.ib_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: ) as
86: ddindx binary_integer; indx binary_integer;
87: begin
88: if t is null or t.count = 0 then
85: ) as
86: ddindx binary_integer; indx binary_integer;
87: begin
88: if t is null or t.count = 0 then
89: a0 := JTF_NUMBER_TABLE();
90: else
91: a0 := JTF_NUMBER_TABLE();
92: if t.count > 0 then
93: a0.extend(t.count);
87: begin
88: if t is null or t.count = 0 then
89: a0 := JTF_NUMBER_TABLE();
90: else
91: a0 := JTF_NUMBER_TABLE();
92: if t.count > 0 then
93: a0.extend(t.count);
94: ddindx := t.first;
95: indx := 1;
112: , x_msg_data out nocopy VARCHAR2
113: , p_cle_id NUMBER
114: , p_split_into_individuals_yn VARCHAR2
115: , p_split_into_units NUMBER
116: , p8_a0 JTF_NUMBER_TABLE
117: , p9_a0 out nocopy JTF_NUMBER_TABLE
118: , p9_a1 out nocopy JTF_NUMBER_TABLE
119: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
120: , p9_a3 out nocopy JTF_NUMBER_TABLE
113: , p_cle_id NUMBER
114: , p_split_into_individuals_yn VARCHAR2
115: , p_split_into_units NUMBER
116: , p8_a0 JTF_NUMBER_TABLE
117: , p9_a0 out nocopy JTF_NUMBER_TABLE
118: , p9_a1 out nocopy JTF_NUMBER_TABLE
119: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
120: , p9_a3 out nocopy JTF_NUMBER_TABLE
121: , p9_a4 out nocopy JTF_NUMBER_TABLE
114: , p_split_into_individuals_yn VARCHAR2
115: , p_split_into_units NUMBER
116: , p8_a0 JTF_NUMBER_TABLE
117: , p9_a0 out nocopy JTF_NUMBER_TABLE
118: , p9_a1 out nocopy JTF_NUMBER_TABLE
119: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
120: , p9_a3 out nocopy JTF_NUMBER_TABLE
121: , p9_a4 out nocopy JTF_NUMBER_TABLE
122: , p9_a5 out nocopy JTF_NUMBER_TABLE
116: , p8_a0 JTF_NUMBER_TABLE
117: , p9_a0 out nocopy JTF_NUMBER_TABLE
118: , p9_a1 out nocopy JTF_NUMBER_TABLE
119: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
120: , p9_a3 out nocopy JTF_NUMBER_TABLE
121: , p9_a4 out nocopy JTF_NUMBER_TABLE
122: , p9_a5 out nocopy JTF_NUMBER_TABLE
123: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
124: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
117: , p9_a0 out nocopy JTF_NUMBER_TABLE
118: , p9_a1 out nocopy JTF_NUMBER_TABLE
119: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
120: , p9_a3 out nocopy JTF_NUMBER_TABLE
121: , p9_a4 out nocopy JTF_NUMBER_TABLE
122: , p9_a5 out nocopy JTF_NUMBER_TABLE
123: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
124: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
125: , p9_a8 out nocopy JTF_NUMBER_TABLE
118: , p9_a1 out nocopy JTF_NUMBER_TABLE
119: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
120: , p9_a3 out nocopy JTF_NUMBER_TABLE
121: , p9_a4 out nocopy JTF_NUMBER_TABLE
122: , p9_a5 out nocopy JTF_NUMBER_TABLE
123: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
124: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
125: , p9_a8 out nocopy JTF_NUMBER_TABLE
126: , p9_a9 out nocopy JTF_NUMBER_TABLE
121: , p9_a4 out nocopy JTF_NUMBER_TABLE
122: , p9_a5 out nocopy JTF_NUMBER_TABLE
123: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
124: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
125: , p9_a8 out nocopy JTF_NUMBER_TABLE
126: , p9_a9 out nocopy JTF_NUMBER_TABLE
127: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
128: , p9_a11 out nocopy JTF_NUMBER_TABLE
129: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
122: , p9_a5 out nocopy JTF_NUMBER_TABLE
123: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
124: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
125: , p9_a8 out nocopy JTF_NUMBER_TABLE
126: , p9_a9 out nocopy JTF_NUMBER_TABLE
127: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
128: , p9_a11 out nocopy JTF_NUMBER_TABLE
129: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
130: , p9_a13 out nocopy JTF_NUMBER_TABLE
124: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
125: , p9_a8 out nocopy JTF_NUMBER_TABLE
126: , p9_a9 out nocopy JTF_NUMBER_TABLE
127: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
128: , p9_a11 out nocopy JTF_NUMBER_TABLE
129: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
130: , p9_a13 out nocopy JTF_NUMBER_TABLE
131: , p9_a14 out nocopy JTF_NUMBER_TABLE
132: , p9_a15 out nocopy JTF_NUMBER_TABLE
126: , p9_a9 out nocopy JTF_NUMBER_TABLE
127: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
128: , p9_a11 out nocopy JTF_NUMBER_TABLE
129: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
130: , p9_a13 out nocopy JTF_NUMBER_TABLE
131: , p9_a14 out nocopy JTF_NUMBER_TABLE
132: , p9_a15 out nocopy JTF_NUMBER_TABLE
133: , p9_a16 out nocopy JTF_NUMBER_TABLE
134: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
127: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
128: , p9_a11 out nocopy JTF_NUMBER_TABLE
129: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
130: , p9_a13 out nocopy JTF_NUMBER_TABLE
131: , p9_a14 out nocopy JTF_NUMBER_TABLE
132: , p9_a15 out nocopy JTF_NUMBER_TABLE
133: , p9_a16 out nocopy JTF_NUMBER_TABLE
134: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
135: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
128: , p9_a11 out nocopy JTF_NUMBER_TABLE
129: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
130: , p9_a13 out nocopy JTF_NUMBER_TABLE
131: , p9_a14 out nocopy JTF_NUMBER_TABLE
132: , p9_a15 out nocopy JTF_NUMBER_TABLE
133: , p9_a16 out nocopy JTF_NUMBER_TABLE
134: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
135: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
136: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
129: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
130: , p9_a13 out nocopy JTF_NUMBER_TABLE
131: , p9_a14 out nocopy JTF_NUMBER_TABLE
132: , p9_a15 out nocopy JTF_NUMBER_TABLE
133: , p9_a16 out nocopy JTF_NUMBER_TABLE
134: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
135: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
136: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
137: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
146: , p9_a29 out nocopy JTF_VARCHAR2_TABLE_500
147: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_500
148: , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
149: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
150: , p9_a33 out nocopy JTF_NUMBER_TABLE
151: , p9_a34 out nocopy JTF_DATE_TABLE
152: , p9_a35 out nocopy JTF_NUMBER_TABLE
153: , p9_a36 out nocopy JTF_DATE_TABLE
154: , p9_a37 out nocopy JTF_NUMBER_TABLE
148: , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
149: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
150: , p9_a33 out nocopy JTF_NUMBER_TABLE
151: , p9_a34 out nocopy JTF_DATE_TABLE
152: , p9_a35 out nocopy JTF_NUMBER_TABLE
153: , p9_a36 out nocopy JTF_DATE_TABLE
154: , p9_a37 out nocopy JTF_NUMBER_TABLE
155: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
156: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
150: , p9_a33 out nocopy JTF_NUMBER_TABLE
151: , p9_a34 out nocopy JTF_DATE_TABLE
152: , p9_a35 out nocopy JTF_NUMBER_TABLE
153: , p9_a36 out nocopy JTF_DATE_TABLE
154: , p9_a37 out nocopy JTF_NUMBER_TABLE
155: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
156: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a40 out nocopy JTF_NUMBER_TABLE
158: , p9_a41 out nocopy JTF_DATE_TABLE
153: , p9_a36 out nocopy JTF_DATE_TABLE
154: , p9_a37 out nocopy JTF_NUMBER_TABLE
155: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
156: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a40 out nocopy JTF_NUMBER_TABLE
158: , p9_a41 out nocopy JTF_DATE_TABLE
159: , p10_a0 out nocopy NUMBER
160: , p10_a1 out nocopy NUMBER
161: , p10_a2 out nocopy VARCHAR2
477: , x_msg_data out nocopy VARCHAR2
478: , p_cle_id NUMBER
479: , p_split_into_individuals_yn VARCHAR2
480: , p_split_into_units NUMBER
481: , p8_a0 out nocopy JTF_NUMBER_TABLE
482: , p8_a1 out nocopy JTF_NUMBER_TABLE
483: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
484: , p8_a3 out nocopy JTF_NUMBER_TABLE
485: , p8_a4 out nocopy JTF_NUMBER_TABLE
478: , p_cle_id NUMBER
479: , p_split_into_individuals_yn VARCHAR2
480: , p_split_into_units NUMBER
481: , p8_a0 out nocopy JTF_NUMBER_TABLE
482: , p8_a1 out nocopy JTF_NUMBER_TABLE
483: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
484: , p8_a3 out nocopy JTF_NUMBER_TABLE
485: , p8_a4 out nocopy JTF_NUMBER_TABLE
486: , p8_a5 out nocopy JTF_NUMBER_TABLE
480: , p_split_into_units NUMBER
481: , p8_a0 out nocopy JTF_NUMBER_TABLE
482: , p8_a1 out nocopy JTF_NUMBER_TABLE
483: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
484: , p8_a3 out nocopy JTF_NUMBER_TABLE
485: , p8_a4 out nocopy JTF_NUMBER_TABLE
486: , p8_a5 out nocopy JTF_NUMBER_TABLE
487: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
488: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_2000
481: , p8_a0 out nocopy JTF_NUMBER_TABLE
482: , p8_a1 out nocopy JTF_NUMBER_TABLE
483: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
484: , p8_a3 out nocopy JTF_NUMBER_TABLE
485: , p8_a4 out nocopy JTF_NUMBER_TABLE
486: , p8_a5 out nocopy JTF_NUMBER_TABLE
487: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
488: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_2000
489: , p8_a8 out nocopy JTF_NUMBER_TABLE
482: , p8_a1 out nocopy JTF_NUMBER_TABLE
483: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
484: , p8_a3 out nocopy JTF_NUMBER_TABLE
485: , p8_a4 out nocopy JTF_NUMBER_TABLE
486: , p8_a5 out nocopy JTF_NUMBER_TABLE
487: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
488: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_2000
489: , p8_a8 out nocopy JTF_NUMBER_TABLE
490: , p8_a9 out nocopy JTF_NUMBER_TABLE
485: , p8_a4 out nocopy JTF_NUMBER_TABLE
486: , p8_a5 out nocopy JTF_NUMBER_TABLE
487: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
488: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_2000
489: , p8_a8 out nocopy JTF_NUMBER_TABLE
490: , p8_a9 out nocopy JTF_NUMBER_TABLE
491: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
492: , p8_a11 out nocopy JTF_NUMBER_TABLE
493: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
486: , p8_a5 out nocopy JTF_NUMBER_TABLE
487: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
488: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_2000
489: , p8_a8 out nocopy JTF_NUMBER_TABLE
490: , p8_a9 out nocopy JTF_NUMBER_TABLE
491: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
492: , p8_a11 out nocopy JTF_NUMBER_TABLE
493: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a13 out nocopy JTF_NUMBER_TABLE
488: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_2000
489: , p8_a8 out nocopy JTF_NUMBER_TABLE
490: , p8_a9 out nocopy JTF_NUMBER_TABLE
491: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
492: , p8_a11 out nocopy JTF_NUMBER_TABLE
493: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a13 out nocopy JTF_NUMBER_TABLE
495: , p8_a14 out nocopy JTF_NUMBER_TABLE
496: , p8_a15 out nocopy JTF_NUMBER_TABLE
490: , p8_a9 out nocopy JTF_NUMBER_TABLE
491: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
492: , p8_a11 out nocopy JTF_NUMBER_TABLE
493: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a13 out nocopy JTF_NUMBER_TABLE
495: , p8_a14 out nocopy JTF_NUMBER_TABLE
496: , p8_a15 out nocopy JTF_NUMBER_TABLE
497: , p8_a16 out nocopy JTF_NUMBER_TABLE
498: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
491: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
492: , p8_a11 out nocopy JTF_NUMBER_TABLE
493: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a13 out nocopy JTF_NUMBER_TABLE
495: , p8_a14 out nocopy JTF_NUMBER_TABLE
496: , p8_a15 out nocopy JTF_NUMBER_TABLE
497: , p8_a16 out nocopy JTF_NUMBER_TABLE
498: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
499: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_500
492: , p8_a11 out nocopy JTF_NUMBER_TABLE
493: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a13 out nocopy JTF_NUMBER_TABLE
495: , p8_a14 out nocopy JTF_NUMBER_TABLE
496: , p8_a15 out nocopy JTF_NUMBER_TABLE
497: , p8_a16 out nocopy JTF_NUMBER_TABLE
498: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
499: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_500
500: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_500
493: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
494: , p8_a13 out nocopy JTF_NUMBER_TABLE
495: , p8_a14 out nocopy JTF_NUMBER_TABLE
496: , p8_a15 out nocopy JTF_NUMBER_TABLE
497: , p8_a16 out nocopy JTF_NUMBER_TABLE
498: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
499: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_500
500: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_500
501: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_500
510: , p8_a29 out nocopy JTF_VARCHAR2_TABLE_500
511: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_500
512: , p8_a31 out nocopy JTF_VARCHAR2_TABLE_500
513: , p8_a32 out nocopy JTF_VARCHAR2_TABLE_500
514: , p8_a33 out nocopy JTF_NUMBER_TABLE
515: , p8_a34 out nocopy JTF_DATE_TABLE
516: , p8_a35 out nocopy JTF_NUMBER_TABLE
517: , p8_a36 out nocopy JTF_DATE_TABLE
518: , p8_a37 out nocopy JTF_NUMBER_TABLE
512: , p8_a31 out nocopy JTF_VARCHAR2_TABLE_500
513: , p8_a32 out nocopy JTF_VARCHAR2_TABLE_500
514: , p8_a33 out nocopy JTF_NUMBER_TABLE
515: , p8_a34 out nocopy JTF_DATE_TABLE
516: , p8_a35 out nocopy JTF_NUMBER_TABLE
517: , p8_a36 out nocopy JTF_DATE_TABLE
518: , p8_a37 out nocopy JTF_NUMBER_TABLE
519: , p8_a38 out nocopy JTF_VARCHAR2_TABLE_100
520: , p8_a39 out nocopy JTF_VARCHAR2_TABLE_100
514: , p8_a33 out nocopy JTF_NUMBER_TABLE
515: , p8_a34 out nocopy JTF_DATE_TABLE
516: , p8_a35 out nocopy JTF_NUMBER_TABLE
517: , p8_a36 out nocopy JTF_DATE_TABLE
518: , p8_a37 out nocopy JTF_NUMBER_TABLE
519: , p8_a38 out nocopy JTF_VARCHAR2_TABLE_100
520: , p8_a39 out nocopy JTF_VARCHAR2_TABLE_100
521: , p8_a40 out nocopy JTF_NUMBER_TABLE
522: , p8_a41 out nocopy JTF_DATE_TABLE
517: , p8_a36 out nocopy JTF_DATE_TABLE
518: , p8_a37 out nocopy JTF_NUMBER_TABLE
519: , p8_a38 out nocopy JTF_VARCHAR2_TABLE_100
520: , p8_a39 out nocopy JTF_VARCHAR2_TABLE_100
521: , p8_a40 out nocopy JTF_NUMBER_TABLE
522: , p8_a41 out nocopy JTF_DATE_TABLE
523: , p9_a0 out nocopy NUMBER
524: , p9_a1 out nocopy NUMBER
525: , p9_a2 out nocopy VARCHAR2
835: , x_msg_data out nocopy VARCHAR2
836: , p_cle_id NUMBER
837: , p_split_into_individuals_yn VARCHAR2
838: , p_split_into_units NUMBER
839: , p8_a0 JTF_NUMBER_TABLE
840: , p_trx_date date
841: , p10_a0 out nocopy JTF_NUMBER_TABLE
842: , p10_a1 out nocopy JTF_NUMBER_TABLE
843: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
837: , p_split_into_individuals_yn VARCHAR2
838: , p_split_into_units NUMBER
839: , p8_a0 JTF_NUMBER_TABLE
840: , p_trx_date date
841: , p10_a0 out nocopy JTF_NUMBER_TABLE
842: , p10_a1 out nocopy JTF_NUMBER_TABLE
843: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p10_a3 out nocopy JTF_NUMBER_TABLE
845: , p10_a4 out nocopy JTF_NUMBER_TABLE
838: , p_split_into_units NUMBER
839: , p8_a0 JTF_NUMBER_TABLE
840: , p_trx_date date
841: , p10_a0 out nocopy JTF_NUMBER_TABLE
842: , p10_a1 out nocopy JTF_NUMBER_TABLE
843: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p10_a3 out nocopy JTF_NUMBER_TABLE
845: , p10_a4 out nocopy JTF_NUMBER_TABLE
846: , p10_a5 out nocopy JTF_NUMBER_TABLE
840: , p_trx_date date
841: , p10_a0 out nocopy JTF_NUMBER_TABLE
842: , p10_a1 out nocopy JTF_NUMBER_TABLE
843: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p10_a3 out nocopy JTF_NUMBER_TABLE
845: , p10_a4 out nocopy JTF_NUMBER_TABLE
846: , p10_a5 out nocopy JTF_NUMBER_TABLE
847: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
848: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
841: , p10_a0 out nocopy JTF_NUMBER_TABLE
842: , p10_a1 out nocopy JTF_NUMBER_TABLE
843: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p10_a3 out nocopy JTF_NUMBER_TABLE
845: , p10_a4 out nocopy JTF_NUMBER_TABLE
846: , p10_a5 out nocopy JTF_NUMBER_TABLE
847: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
848: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
849: , p10_a8 out nocopy JTF_NUMBER_TABLE
842: , p10_a1 out nocopy JTF_NUMBER_TABLE
843: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p10_a3 out nocopy JTF_NUMBER_TABLE
845: , p10_a4 out nocopy JTF_NUMBER_TABLE
846: , p10_a5 out nocopy JTF_NUMBER_TABLE
847: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
848: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
849: , p10_a8 out nocopy JTF_NUMBER_TABLE
850: , p10_a9 out nocopy JTF_NUMBER_TABLE
845: , p10_a4 out nocopy JTF_NUMBER_TABLE
846: , p10_a5 out nocopy JTF_NUMBER_TABLE
847: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
848: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
849: , p10_a8 out nocopy JTF_NUMBER_TABLE
850: , p10_a9 out nocopy JTF_NUMBER_TABLE
851: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
852: , p10_a11 out nocopy JTF_NUMBER_TABLE
853: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
846: , p10_a5 out nocopy JTF_NUMBER_TABLE
847: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
848: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
849: , p10_a8 out nocopy JTF_NUMBER_TABLE
850: , p10_a9 out nocopy JTF_NUMBER_TABLE
851: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
852: , p10_a11 out nocopy JTF_NUMBER_TABLE
853: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
854: , p10_a13 out nocopy JTF_NUMBER_TABLE
848: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
849: , p10_a8 out nocopy JTF_NUMBER_TABLE
850: , p10_a9 out nocopy JTF_NUMBER_TABLE
851: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
852: , p10_a11 out nocopy JTF_NUMBER_TABLE
853: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
854: , p10_a13 out nocopy JTF_NUMBER_TABLE
855: , p10_a14 out nocopy JTF_NUMBER_TABLE
856: , p10_a15 out nocopy JTF_NUMBER_TABLE
850: , p10_a9 out nocopy JTF_NUMBER_TABLE
851: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
852: , p10_a11 out nocopy JTF_NUMBER_TABLE
853: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
854: , p10_a13 out nocopy JTF_NUMBER_TABLE
855: , p10_a14 out nocopy JTF_NUMBER_TABLE
856: , p10_a15 out nocopy JTF_NUMBER_TABLE
857: , p10_a16 out nocopy JTF_NUMBER_TABLE
858: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
851: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
852: , p10_a11 out nocopy JTF_NUMBER_TABLE
853: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
854: , p10_a13 out nocopy JTF_NUMBER_TABLE
855: , p10_a14 out nocopy JTF_NUMBER_TABLE
856: , p10_a15 out nocopy JTF_NUMBER_TABLE
857: , p10_a16 out nocopy JTF_NUMBER_TABLE
858: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
859: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
852: , p10_a11 out nocopy JTF_NUMBER_TABLE
853: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
854: , p10_a13 out nocopy JTF_NUMBER_TABLE
855: , p10_a14 out nocopy JTF_NUMBER_TABLE
856: , p10_a15 out nocopy JTF_NUMBER_TABLE
857: , p10_a16 out nocopy JTF_NUMBER_TABLE
858: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
859: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
860: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
853: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
854: , p10_a13 out nocopy JTF_NUMBER_TABLE
855: , p10_a14 out nocopy JTF_NUMBER_TABLE
856: , p10_a15 out nocopy JTF_NUMBER_TABLE
857: , p10_a16 out nocopy JTF_NUMBER_TABLE
858: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
859: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
860: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
861: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
870: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_500
871: , p10_a30 out nocopy JTF_VARCHAR2_TABLE_500
872: , p10_a31 out nocopy JTF_VARCHAR2_TABLE_500
873: , p10_a32 out nocopy JTF_VARCHAR2_TABLE_500
874: , p10_a33 out nocopy JTF_NUMBER_TABLE
875: , p10_a34 out nocopy JTF_DATE_TABLE
876: , p10_a35 out nocopy JTF_NUMBER_TABLE
877: , p10_a36 out nocopy JTF_DATE_TABLE
878: , p10_a37 out nocopy JTF_NUMBER_TABLE
872: , p10_a31 out nocopy JTF_VARCHAR2_TABLE_500
873: , p10_a32 out nocopy JTF_VARCHAR2_TABLE_500
874: , p10_a33 out nocopy JTF_NUMBER_TABLE
875: , p10_a34 out nocopy JTF_DATE_TABLE
876: , p10_a35 out nocopy JTF_NUMBER_TABLE
877: , p10_a36 out nocopy JTF_DATE_TABLE
878: , p10_a37 out nocopy JTF_NUMBER_TABLE
879: , p10_a38 out nocopy JTF_VARCHAR2_TABLE_100
880: , p10_a39 out nocopy JTF_VARCHAR2_TABLE_100
874: , p10_a33 out nocopy JTF_NUMBER_TABLE
875: , p10_a34 out nocopy JTF_DATE_TABLE
876: , p10_a35 out nocopy JTF_NUMBER_TABLE
877: , p10_a36 out nocopy JTF_DATE_TABLE
878: , p10_a37 out nocopy JTF_NUMBER_TABLE
879: , p10_a38 out nocopy JTF_VARCHAR2_TABLE_100
880: , p10_a39 out nocopy JTF_VARCHAR2_TABLE_100
881: , p10_a40 out nocopy JTF_NUMBER_TABLE
882: , p10_a41 out nocopy JTF_DATE_TABLE
877: , p10_a36 out nocopy JTF_DATE_TABLE
878: , p10_a37 out nocopy JTF_NUMBER_TABLE
879: , p10_a38 out nocopy JTF_VARCHAR2_TABLE_100
880: , p10_a39 out nocopy JTF_VARCHAR2_TABLE_100
881: , p10_a40 out nocopy JTF_NUMBER_TABLE
882: , p10_a41 out nocopy JTF_DATE_TABLE
883: , p11_a0 out nocopy NUMBER
884: , p11_a1 out nocopy NUMBER
885: , p11_a2 out nocopy VARCHAR2
1207: , p_cle_id NUMBER
1208: , p_split_into_individuals_yn VARCHAR2
1209: , p_split_into_units NUMBER
1210: , p_trx_date date
1211: , p9_a0 out nocopy JTF_NUMBER_TABLE
1212: , p9_a1 out nocopy JTF_NUMBER_TABLE
1213: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
1214: , p9_a3 out nocopy JTF_NUMBER_TABLE
1215: , p9_a4 out nocopy JTF_NUMBER_TABLE
1208: , p_split_into_individuals_yn VARCHAR2
1209: , p_split_into_units NUMBER
1210: , p_trx_date date
1211: , p9_a0 out nocopy JTF_NUMBER_TABLE
1212: , p9_a1 out nocopy JTF_NUMBER_TABLE
1213: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
1214: , p9_a3 out nocopy JTF_NUMBER_TABLE
1215: , p9_a4 out nocopy JTF_NUMBER_TABLE
1216: , p9_a5 out nocopy JTF_NUMBER_TABLE
1210: , p_trx_date date
1211: , p9_a0 out nocopy JTF_NUMBER_TABLE
1212: , p9_a1 out nocopy JTF_NUMBER_TABLE
1213: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
1214: , p9_a3 out nocopy JTF_NUMBER_TABLE
1215: , p9_a4 out nocopy JTF_NUMBER_TABLE
1216: , p9_a5 out nocopy JTF_NUMBER_TABLE
1217: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1218: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1211: , p9_a0 out nocopy JTF_NUMBER_TABLE
1212: , p9_a1 out nocopy JTF_NUMBER_TABLE
1213: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
1214: , p9_a3 out nocopy JTF_NUMBER_TABLE
1215: , p9_a4 out nocopy JTF_NUMBER_TABLE
1216: , p9_a5 out nocopy JTF_NUMBER_TABLE
1217: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1218: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1219: , p9_a8 out nocopy JTF_NUMBER_TABLE
1212: , p9_a1 out nocopy JTF_NUMBER_TABLE
1213: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
1214: , p9_a3 out nocopy JTF_NUMBER_TABLE
1215: , p9_a4 out nocopy JTF_NUMBER_TABLE
1216: , p9_a5 out nocopy JTF_NUMBER_TABLE
1217: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1218: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1219: , p9_a8 out nocopy JTF_NUMBER_TABLE
1220: , p9_a9 out nocopy JTF_NUMBER_TABLE
1215: , p9_a4 out nocopy JTF_NUMBER_TABLE
1216: , p9_a5 out nocopy JTF_NUMBER_TABLE
1217: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1218: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1219: , p9_a8 out nocopy JTF_NUMBER_TABLE
1220: , p9_a9 out nocopy JTF_NUMBER_TABLE
1221: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p9_a11 out nocopy JTF_NUMBER_TABLE
1223: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1216: , p9_a5 out nocopy JTF_NUMBER_TABLE
1217: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1218: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1219: , p9_a8 out nocopy JTF_NUMBER_TABLE
1220: , p9_a9 out nocopy JTF_NUMBER_TABLE
1221: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p9_a11 out nocopy JTF_NUMBER_TABLE
1223: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p9_a13 out nocopy JTF_NUMBER_TABLE
1218: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1219: , p9_a8 out nocopy JTF_NUMBER_TABLE
1220: , p9_a9 out nocopy JTF_NUMBER_TABLE
1221: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p9_a11 out nocopy JTF_NUMBER_TABLE
1223: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p9_a13 out nocopy JTF_NUMBER_TABLE
1225: , p9_a14 out nocopy JTF_NUMBER_TABLE
1226: , p9_a15 out nocopy JTF_NUMBER_TABLE
1220: , p9_a9 out nocopy JTF_NUMBER_TABLE
1221: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p9_a11 out nocopy JTF_NUMBER_TABLE
1223: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p9_a13 out nocopy JTF_NUMBER_TABLE
1225: , p9_a14 out nocopy JTF_NUMBER_TABLE
1226: , p9_a15 out nocopy JTF_NUMBER_TABLE
1227: , p9_a16 out nocopy JTF_NUMBER_TABLE
1228: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
1221: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p9_a11 out nocopy JTF_NUMBER_TABLE
1223: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p9_a13 out nocopy JTF_NUMBER_TABLE
1225: , p9_a14 out nocopy JTF_NUMBER_TABLE
1226: , p9_a15 out nocopy JTF_NUMBER_TABLE
1227: , p9_a16 out nocopy JTF_NUMBER_TABLE
1228: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
1229: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
1222: , p9_a11 out nocopy JTF_NUMBER_TABLE
1223: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p9_a13 out nocopy JTF_NUMBER_TABLE
1225: , p9_a14 out nocopy JTF_NUMBER_TABLE
1226: , p9_a15 out nocopy JTF_NUMBER_TABLE
1227: , p9_a16 out nocopy JTF_NUMBER_TABLE
1228: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
1229: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
1230: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
1223: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p9_a13 out nocopy JTF_NUMBER_TABLE
1225: , p9_a14 out nocopy JTF_NUMBER_TABLE
1226: , p9_a15 out nocopy JTF_NUMBER_TABLE
1227: , p9_a16 out nocopy JTF_NUMBER_TABLE
1228: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
1229: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
1230: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
1231: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
1240: , p9_a29 out nocopy JTF_VARCHAR2_TABLE_500
1241: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_500
1242: , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
1243: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
1244: , p9_a33 out nocopy JTF_NUMBER_TABLE
1245: , p9_a34 out nocopy JTF_DATE_TABLE
1246: , p9_a35 out nocopy JTF_NUMBER_TABLE
1247: , p9_a36 out nocopy JTF_DATE_TABLE
1248: , p9_a37 out nocopy JTF_NUMBER_TABLE
1242: , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
1243: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
1244: , p9_a33 out nocopy JTF_NUMBER_TABLE
1245: , p9_a34 out nocopy JTF_DATE_TABLE
1246: , p9_a35 out nocopy JTF_NUMBER_TABLE
1247: , p9_a36 out nocopy JTF_DATE_TABLE
1248: , p9_a37 out nocopy JTF_NUMBER_TABLE
1249: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
1250: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p9_a33 out nocopy JTF_NUMBER_TABLE
1245: , p9_a34 out nocopy JTF_DATE_TABLE
1246: , p9_a35 out nocopy JTF_NUMBER_TABLE
1247: , p9_a36 out nocopy JTF_DATE_TABLE
1248: , p9_a37 out nocopy JTF_NUMBER_TABLE
1249: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
1250: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
1251: , p9_a40 out nocopy JTF_NUMBER_TABLE
1252: , p9_a41 out nocopy JTF_DATE_TABLE
1247: , p9_a36 out nocopy JTF_DATE_TABLE
1248: , p9_a37 out nocopy JTF_NUMBER_TABLE
1249: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
1250: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
1251: , p9_a40 out nocopy JTF_NUMBER_TABLE
1252: , p9_a41 out nocopy JTF_DATE_TABLE
1253: , p10_a0 out nocopy NUMBER
1254: , p10_a1 out nocopy NUMBER
1255: , p10_a2 out nocopy VARCHAR2
1568: , x_return_status out nocopy VARCHAR2
1569: , x_msg_count out nocopy NUMBER
1570: , x_msg_data out nocopy VARCHAR2
1571: , p_cle_id NUMBER
1572: , p6_a0 JTF_NUMBER_TABLE
1573: , p6_a1 JTF_NUMBER_TABLE
1574: , p6_a2 JTF_VARCHAR2_TABLE_100
1575: , p6_a3 JTF_NUMBER_TABLE
1576: , p6_a4 JTF_NUMBER_TABLE
1569: , x_msg_count out nocopy NUMBER
1570: , x_msg_data out nocopy VARCHAR2
1571: , p_cle_id NUMBER
1572: , p6_a0 JTF_NUMBER_TABLE
1573: , p6_a1 JTF_NUMBER_TABLE
1574: , p6_a2 JTF_VARCHAR2_TABLE_100
1575: , p6_a3 JTF_NUMBER_TABLE
1576: , p6_a4 JTF_NUMBER_TABLE
1577: , p6_a5 JTF_NUMBER_TABLE
1571: , p_cle_id NUMBER
1572: , p6_a0 JTF_NUMBER_TABLE
1573: , p6_a1 JTF_NUMBER_TABLE
1574: , p6_a2 JTF_VARCHAR2_TABLE_100
1575: , p6_a3 JTF_NUMBER_TABLE
1576: , p6_a4 JTF_NUMBER_TABLE
1577: , p6_a5 JTF_NUMBER_TABLE
1578: , p6_a6 JTF_VARCHAR2_TABLE_100
1579: , p6_a7 JTF_VARCHAR2_TABLE_2000
1572: , p6_a0 JTF_NUMBER_TABLE
1573: , p6_a1 JTF_NUMBER_TABLE
1574: , p6_a2 JTF_VARCHAR2_TABLE_100
1575: , p6_a3 JTF_NUMBER_TABLE
1576: , p6_a4 JTF_NUMBER_TABLE
1577: , p6_a5 JTF_NUMBER_TABLE
1578: , p6_a6 JTF_VARCHAR2_TABLE_100
1579: , p6_a7 JTF_VARCHAR2_TABLE_2000
1580: , p6_a8 JTF_NUMBER_TABLE
1573: , p6_a1 JTF_NUMBER_TABLE
1574: , p6_a2 JTF_VARCHAR2_TABLE_100
1575: , p6_a3 JTF_NUMBER_TABLE
1576: , p6_a4 JTF_NUMBER_TABLE
1577: , p6_a5 JTF_NUMBER_TABLE
1578: , p6_a6 JTF_VARCHAR2_TABLE_100
1579: , p6_a7 JTF_VARCHAR2_TABLE_2000
1580: , p6_a8 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_NUMBER_TABLE
1576: , p6_a4 JTF_NUMBER_TABLE
1577: , p6_a5 JTF_NUMBER_TABLE
1578: , p6_a6 JTF_VARCHAR2_TABLE_100
1579: , p6_a7 JTF_VARCHAR2_TABLE_2000
1580: , p6_a8 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_NUMBER_TABLE
1582: , p6_a10 JTF_VARCHAR2_TABLE_100
1583: , p6_a11 JTF_NUMBER_TABLE
1584: , p6_a12 JTF_VARCHAR2_TABLE_100
1577: , p6_a5 JTF_NUMBER_TABLE
1578: , p6_a6 JTF_VARCHAR2_TABLE_100
1579: , p6_a7 JTF_VARCHAR2_TABLE_2000
1580: , p6_a8 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_NUMBER_TABLE
1582: , p6_a10 JTF_VARCHAR2_TABLE_100
1583: , p6_a11 JTF_NUMBER_TABLE
1584: , p6_a12 JTF_VARCHAR2_TABLE_100
1585: , p6_a13 JTF_NUMBER_TABLE
1579: , p6_a7 JTF_VARCHAR2_TABLE_2000
1580: , p6_a8 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_NUMBER_TABLE
1582: , p6_a10 JTF_VARCHAR2_TABLE_100
1583: , p6_a11 JTF_NUMBER_TABLE
1584: , p6_a12 JTF_VARCHAR2_TABLE_100
1585: , p6_a13 JTF_NUMBER_TABLE
1586: , p6_a14 JTF_NUMBER_TABLE
1587: , p6_a15 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_NUMBER_TABLE
1582: , p6_a10 JTF_VARCHAR2_TABLE_100
1583: , p6_a11 JTF_NUMBER_TABLE
1584: , p6_a12 JTF_VARCHAR2_TABLE_100
1585: , p6_a13 JTF_NUMBER_TABLE
1586: , p6_a14 JTF_NUMBER_TABLE
1587: , p6_a15 JTF_NUMBER_TABLE
1588: , p6_a16 JTF_NUMBER_TABLE
1589: , p6_a17 JTF_VARCHAR2_TABLE_100
1582: , p6_a10 JTF_VARCHAR2_TABLE_100
1583: , p6_a11 JTF_NUMBER_TABLE
1584: , p6_a12 JTF_VARCHAR2_TABLE_100
1585: , p6_a13 JTF_NUMBER_TABLE
1586: , p6_a14 JTF_NUMBER_TABLE
1587: , p6_a15 JTF_NUMBER_TABLE
1588: , p6_a16 JTF_NUMBER_TABLE
1589: , p6_a17 JTF_VARCHAR2_TABLE_100
1590: , p6_a18 JTF_VARCHAR2_TABLE_500
1583: , p6_a11 JTF_NUMBER_TABLE
1584: , p6_a12 JTF_VARCHAR2_TABLE_100
1585: , p6_a13 JTF_NUMBER_TABLE
1586: , p6_a14 JTF_NUMBER_TABLE
1587: , p6_a15 JTF_NUMBER_TABLE
1588: , p6_a16 JTF_NUMBER_TABLE
1589: , p6_a17 JTF_VARCHAR2_TABLE_100
1590: , p6_a18 JTF_VARCHAR2_TABLE_500
1591: , p6_a19 JTF_VARCHAR2_TABLE_500
1584: , p6_a12 JTF_VARCHAR2_TABLE_100
1585: , p6_a13 JTF_NUMBER_TABLE
1586: , p6_a14 JTF_NUMBER_TABLE
1587: , p6_a15 JTF_NUMBER_TABLE
1588: , p6_a16 JTF_NUMBER_TABLE
1589: , p6_a17 JTF_VARCHAR2_TABLE_100
1590: , p6_a18 JTF_VARCHAR2_TABLE_500
1591: , p6_a19 JTF_VARCHAR2_TABLE_500
1592: , p6_a20 JTF_VARCHAR2_TABLE_500
1601: , p6_a29 JTF_VARCHAR2_TABLE_500
1602: , p6_a30 JTF_VARCHAR2_TABLE_500
1603: , p6_a31 JTF_VARCHAR2_TABLE_500
1604: , p6_a32 JTF_VARCHAR2_TABLE_500
1605: , p6_a33 JTF_NUMBER_TABLE
1606: , p6_a34 JTF_DATE_TABLE
1607: , p6_a35 JTF_NUMBER_TABLE
1608: , p6_a36 JTF_DATE_TABLE
1609: , p6_a37 JTF_NUMBER_TABLE
1603: , p6_a31 JTF_VARCHAR2_TABLE_500
1604: , p6_a32 JTF_VARCHAR2_TABLE_500
1605: , p6_a33 JTF_NUMBER_TABLE
1606: , p6_a34 JTF_DATE_TABLE
1607: , p6_a35 JTF_NUMBER_TABLE
1608: , p6_a36 JTF_DATE_TABLE
1609: , p6_a37 JTF_NUMBER_TABLE
1610: , p6_a38 JTF_VARCHAR2_TABLE_100
1611: , p6_a39 JTF_VARCHAR2_TABLE_100
1605: , p6_a33 JTF_NUMBER_TABLE
1606: , p6_a34 JTF_DATE_TABLE
1607: , p6_a35 JTF_NUMBER_TABLE
1608: , p6_a36 JTF_DATE_TABLE
1609: , p6_a37 JTF_NUMBER_TABLE
1610: , p6_a38 JTF_VARCHAR2_TABLE_100
1611: , p6_a39 JTF_VARCHAR2_TABLE_100
1612: , p6_a40 JTF_NUMBER_TABLE
1613: , p6_a41 JTF_DATE_TABLE
1608: , p6_a36 JTF_DATE_TABLE
1609: , p6_a37 JTF_NUMBER_TABLE
1610: , p6_a38 JTF_VARCHAR2_TABLE_100
1611: , p6_a39 JTF_VARCHAR2_TABLE_100
1612: , p6_a40 JTF_NUMBER_TABLE
1613: , p6_a41 JTF_DATE_TABLE
1614: , p7_a0 out nocopy JTF_NUMBER_TABLE
1615: , p7_a1 out nocopy JTF_NUMBER_TABLE
1616: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
1610: , p6_a38 JTF_VARCHAR2_TABLE_100
1611: , p6_a39 JTF_VARCHAR2_TABLE_100
1612: , p6_a40 JTF_NUMBER_TABLE
1613: , p6_a41 JTF_DATE_TABLE
1614: , p7_a0 out nocopy JTF_NUMBER_TABLE
1615: , p7_a1 out nocopy JTF_NUMBER_TABLE
1616: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p7_a3 out nocopy JTF_NUMBER_TABLE
1618: , p7_a4 out nocopy JTF_NUMBER_TABLE
1611: , p6_a39 JTF_VARCHAR2_TABLE_100
1612: , p6_a40 JTF_NUMBER_TABLE
1613: , p6_a41 JTF_DATE_TABLE
1614: , p7_a0 out nocopy JTF_NUMBER_TABLE
1615: , p7_a1 out nocopy JTF_NUMBER_TABLE
1616: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p7_a3 out nocopy JTF_NUMBER_TABLE
1618: , p7_a4 out nocopy JTF_NUMBER_TABLE
1619: , p7_a5 out nocopy JTF_NUMBER_TABLE
1613: , p6_a41 JTF_DATE_TABLE
1614: , p7_a0 out nocopy JTF_NUMBER_TABLE
1615: , p7_a1 out nocopy JTF_NUMBER_TABLE
1616: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p7_a3 out nocopy JTF_NUMBER_TABLE
1618: , p7_a4 out nocopy JTF_NUMBER_TABLE
1619: , p7_a5 out nocopy JTF_NUMBER_TABLE
1620: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1621: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1614: , p7_a0 out nocopy JTF_NUMBER_TABLE
1615: , p7_a1 out nocopy JTF_NUMBER_TABLE
1616: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p7_a3 out nocopy JTF_NUMBER_TABLE
1618: , p7_a4 out nocopy JTF_NUMBER_TABLE
1619: , p7_a5 out nocopy JTF_NUMBER_TABLE
1620: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1621: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1622: , p7_a8 out nocopy JTF_NUMBER_TABLE
1615: , p7_a1 out nocopy JTF_NUMBER_TABLE
1616: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p7_a3 out nocopy JTF_NUMBER_TABLE
1618: , p7_a4 out nocopy JTF_NUMBER_TABLE
1619: , p7_a5 out nocopy JTF_NUMBER_TABLE
1620: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1621: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1622: , p7_a8 out nocopy JTF_NUMBER_TABLE
1623: , p7_a9 out nocopy JTF_NUMBER_TABLE
1618: , p7_a4 out nocopy JTF_NUMBER_TABLE
1619: , p7_a5 out nocopy JTF_NUMBER_TABLE
1620: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1621: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1622: , p7_a8 out nocopy JTF_NUMBER_TABLE
1623: , p7_a9 out nocopy JTF_NUMBER_TABLE
1624: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1625: , p7_a11 out nocopy JTF_NUMBER_TABLE
1626: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
1619: , p7_a5 out nocopy JTF_NUMBER_TABLE
1620: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1621: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1622: , p7_a8 out nocopy JTF_NUMBER_TABLE
1623: , p7_a9 out nocopy JTF_NUMBER_TABLE
1624: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1625: , p7_a11 out nocopy JTF_NUMBER_TABLE
1626: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
1627: , p7_a13 out nocopy JTF_NUMBER_TABLE
1621: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1622: , p7_a8 out nocopy JTF_NUMBER_TABLE
1623: , p7_a9 out nocopy JTF_NUMBER_TABLE
1624: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1625: , p7_a11 out nocopy JTF_NUMBER_TABLE
1626: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
1627: , p7_a13 out nocopy JTF_NUMBER_TABLE
1628: , p7_a14 out nocopy JTF_NUMBER_TABLE
1629: , p7_a15 out nocopy JTF_NUMBER_TABLE
1623: , p7_a9 out nocopy JTF_NUMBER_TABLE
1624: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1625: , p7_a11 out nocopy JTF_NUMBER_TABLE
1626: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
1627: , p7_a13 out nocopy JTF_NUMBER_TABLE
1628: , p7_a14 out nocopy JTF_NUMBER_TABLE
1629: , p7_a15 out nocopy JTF_NUMBER_TABLE
1630: , p7_a16 out nocopy JTF_NUMBER_TABLE
1631: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
1624: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1625: , p7_a11 out nocopy JTF_NUMBER_TABLE
1626: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
1627: , p7_a13 out nocopy JTF_NUMBER_TABLE
1628: , p7_a14 out nocopy JTF_NUMBER_TABLE
1629: , p7_a15 out nocopy JTF_NUMBER_TABLE
1630: , p7_a16 out nocopy JTF_NUMBER_TABLE
1631: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
1632: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_500
1625: , p7_a11 out nocopy JTF_NUMBER_TABLE
1626: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
1627: , p7_a13 out nocopy JTF_NUMBER_TABLE
1628: , p7_a14 out nocopy JTF_NUMBER_TABLE
1629: , p7_a15 out nocopy JTF_NUMBER_TABLE
1630: , p7_a16 out nocopy JTF_NUMBER_TABLE
1631: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
1632: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_500
1633: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_500
1626: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
1627: , p7_a13 out nocopy JTF_NUMBER_TABLE
1628: , p7_a14 out nocopy JTF_NUMBER_TABLE
1629: , p7_a15 out nocopy JTF_NUMBER_TABLE
1630: , p7_a16 out nocopy JTF_NUMBER_TABLE
1631: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
1632: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_500
1633: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_500
1634: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
1643: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_500
1644: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_500
1645: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_500
1646: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_500
1647: , p7_a33 out nocopy JTF_NUMBER_TABLE
1648: , p7_a34 out nocopy JTF_DATE_TABLE
1649: , p7_a35 out nocopy JTF_NUMBER_TABLE
1650: , p7_a36 out nocopy JTF_DATE_TABLE
1651: , p7_a37 out nocopy JTF_NUMBER_TABLE
1645: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_500
1646: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_500
1647: , p7_a33 out nocopy JTF_NUMBER_TABLE
1648: , p7_a34 out nocopy JTF_DATE_TABLE
1649: , p7_a35 out nocopy JTF_NUMBER_TABLE
1650: , p7_a36 out nocopy JTF_DATE_TABLE
1651: , p7_a37 out nocopy JTF_NUMBER_TABLE
1652: , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100
1653: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
1647: , p7_a33 out nocopy JTF_NUMBER_TABLE
1648: , p7_a34 out nocopy JTF_DATE_TABLE
1649: , p7_a35 out nocopy JTF_NUMBER_TABLE
1650: , p7_a36 out nocopy JTF_DATE_TABLE
1651: , p7_a37 out nocopy JTF_NUMBER_TABLE
1652: , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100
1653: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
1654: , p7_a40 out nocopy JTF_NUMBER_TABLE
1655: , p7_a41 out nocopy JTF_DATE_TABLE
1650: , p7_a36 out nocopy JTF_DATE_TABLE
1651: , p7_a37 out nocopy JTF_NUMBER_TABLE
1652: , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100
1653: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
1654: , p7_a40 out nocopy JTF_NUMBER_TABLE
1655: , p7_a41 out nocopy JTF_DATE_TABLE
1656: )
1657:
1658: as
1780: , p_init_msg_list VARCHAR2
1781: , x_return_status out nocopy VARCHAR2
1782: , x_msg_count out nocopy NUMBER
1783: , x_msg_data out nocopy VARCHAR2
1784: , p5_a0 JTF_NUMBER_TABLE
1785: , p5_a1 JTF_NUMBER_TABLE
1786: , p5_a2 JTF_VARCHAR2_TABLE_100
1787: , p5_a3 JTF_NUMBER_TABLE
1788: , p5_a4 JTF_NUMBER_TABLE
1781: , x_return_status out nocopy VARCHAR2
1782: , x_msg_count out nocopy NUMBER
1783: , x_msg_data out nocopy VARCHAR2
1784: , p5_a0 JTF_NUMBER_TABLE
1785: , p5_a1 JTF_NUMBER_TABLE
1786: , p5_a2 JTF_VARCHAR2_TABLE_100
1787: , p5_a3 JTF_NUMBER_TABLE
1788: , p5_a4 JTF_NUMBER_TABLE
1789: , p5_a5 JTF_NUMBER_TABLE
1783: , x_msg_data out nocopy VARCHAR2
1784: , p5_a0 JTF_NUMBER_TABLE
1785: , p5_a1 JTF_NUMBER_TABLE
1786: , p5_a2 JTF_VARCHAR2_TABLE_100
1787: , p5_a3 JTF_NUMBER_TABLE
1788: , p5_a4 JTF_NUMBER_TABLE
1789: , p5_a5 JTF_NUMBER_TABLE
1790: , p5_a6 JTF_VARCHAR2_TABLE_100
1791: , p5_a7 JTF_VARCHAR2_TABLE_2000
1784: , p5_a0 JTF_NUMBER_TABLE
1785: , p5_a1 JTF_NUMBER_TABLE
1786: , p5_a2 JTF_VARCHAR2_TABLE_100
1787: , p5_a3 JTF_NUMBER_TABLE
1788: , p5_a4 JTF_NUMBER_TABLE
1789: , p5_a5 JTF_NUMBER_TABLE
1790: , p5_a6 JTF_VARCHAR2_TABLE_100
1791: , p5_a7 JTF_VARCHAR2_TABLE_2000
1792: , p5_a8 JTF_NUMBER_TABLE
1785: , p5_a1 JTF_NUMBER_TABLE
1786: , p5_a2 JTF_VARCHAR2_TABLE_100
1787: , p5_a3 JTF_NUMBER_TABLE
1788: , p5_a4 JTF_NUMBER_TABLE
1789: , p5_a5 JTF_NUMBER_TABLE
1790: , p5_a6 JTF_VARCHAR2_TABLE_100
1791: , p5_a7 JTF_VARCHAR2_TABLE_2000
1792: , p5_a8 JTF_NUMBER_TABLE
1793: , p5_a9 JTF_NUMBER_TABLE
1788: , p5_a4 JTF_NUMBER_TABLE
1789: , p5_a5 JTF_NUMBER_TABLE
1790: , p5_a6 JTF_VARCHAR2_TABLE_100
1791: , p5_a7 JTF_VARCHAR2_TABLE_2000
1792: , p5_a8 JTF_NUMBER_TABLE
1793: , p5_a9 JTF_NUMBER_TABLE
1794: , p5_a10 JTF_VARCHAR2_TABLE_100
1795: , p5_a11 JTF_NUMBER_TABLE
1796: , p5_a12 JTF_VARCHAR2_TABLE_100
1789: , p5_a5 JTF_NUMBER_TABLE
1790: , p5_a6 JTF_VARCHAR2_TABLE_100
1791: , p5_a7 JTF_VARCHAR2_TABLE_2000
1792: , p5_a8 JTF_NUMBER_TABLE
1793: , p5_a9 JTF_NUMBER_TABLE
1794: , p5_a10 JTF_VARCHAR2_TABLE_100
1795: , p5_a11 JTF_NUMBER_TABLE
1796: , p5_a12 JTF_VARCHAR2_TABLE_100
1797: , p5_a13 JTF_NUMBER_TABLE
1791: , p5_a7 JTF_VARCHAR2_TABLE_2000
1792: , p5_a8 JTF_NUMBER_TABLE
1793: , p5_a9 JTF_NUMBER_TABLE
1794: , p5_a10 JTF_VARCHAR2_TABLE_100
1795: , p5_a11 JTF_NUMBER_TABLE
1796: , p5_a12 JTF_VARCHAR2_TABLE_100
1797: , p5_a13 JTF_NUMBER_TABLE
1798: , p5_a14 JTF_NUMBER_TABLE
1799: , p5_a15 JTF_NUMBER_TABLE
1793: , p5_a9 JTF_NUMBER_TABLE
1794: , p5_a10 JTF_VARCHAR2_TABLE_100
1795: , p5_a11 JTF_NUMBER_TABLE
1796: , p5_a12 JTF_VARCHAR2_TABLE_100
1797: , p5_a13 JTF_NUMBER_TABLE
1798: , p5_a14 JTF_NUMBER_TABLE
1799: , p5_a15 JTF_NUMBER_TABLE
1800: , p5_a16 JTF_NUMBER_TABLE
1801: , p5_a17 JTF_VARCHAR2_TABLE_100
1794: , p5_a10 JTF_VARCHAR2_TABLE_100
1795: , p5_a11 JTF_NUMBER_TABLE
1796: , p5_a12 JTF_VARCHAR2_TABLE_100
1797: , p5_a13 JTF_NUMBER_TABLE
1798: , p5_a14 JTF_NUMBER_TABLE
1799: , p5_a15 JTF_NUMBER_TABLE
1800: , p5_a16 JTF_NUMBER_TABLE
1801: , p5_a17 JTF_VARCHAR2_TABLE_100
1802: , p5_a18 JTF_VARCHAR2_TABLE_500
1795: , p5_a11 JTF_NUMBER_TABLE
1796: , p5_a12 JTF_VARCHAR2_TABLE_100
1797: , p5_a13 JTF_NUMBER_TABLE
1798: , p5_a14 JTF_NUMBER_TABLE
1799: , p5_a15 JTF_NUMBER_TABLE
1800: , p5_a16 JTF_NUMBER_TABLE
1801: , p5_a17 JTF_VARCHAR2_TABLE_100
1802: , p5_a18 JTF_VARCHAR2_TABLE_500
1803: , p5_a19 JTF_VARCHAR2_TABLE_500
1796: , p5_a12 JTF_VARCHAR2_TABLE_100
1797: , p5_a13 JTF_NUMBER_TABLE
1798: , p5_a14 JTF_NUMBER_TABLE
1799: , p5_a15 JTF_NUMBER_TABLE
1800: , p5_a16 JTF_NUMBER_TABLE
1801: , p5_a17 JTF_VARCHAR2_TABLE_100
1802: , p5_a18 JTF_VARCHAR2_TABLE_500
1803: , p5_a19 JTF_VARCHAR2_TABLE_500
1804: , p5_a20 JTF_VARCHAR2_TABLE_500
1813: , p5_a29 JTF_VARCHAR2_TABLE_500
1814: , p5_a30 JTF_VARCHAR2_TABLE_500
1815: , p5_a31 JTF_VARCHAR2_TABLE_500
1816: , p5_a32 JTF_VARCHAR2_TABLE_500
1817: , p5_a33 JTF_NUMBER_TABLE
1818: , p5_a34 JTF_DATE_TABLE
1819: , p5_a35 JTF_NUMBER_TABLE
1820: , p5_a36 JTF_DATE_TABLE
1821: , p5_a37 JTF_NUMBER_TABLE
1815: , p5_a31 JTF_VARCHAR2_TABLE_500
1816: , p5_a32 JTF_VARCHAR2_TABLE_500
1817: , p5_a33 JTF_NUMBER_TABLE
1818: , p5_a34 JTF_DATE_TABLE
1819: , p5_a35 JTF_NUMBER_TABLE
1820: , p5_a36 JTF_DATE_TABLE
1821: , p5_a37 JTF_NUMBER_TABLE
1822: , p5_a38 JTF_VARCHAR2_TABLE_100
1823: , p5_a39 JTF_VARCHAR2_TABLE_100
1817: , p5_a33 JTF_NUMBER_TABLE
1818: , p5_a34 JTF_DATE_TABLE
1819: , p5_a35 JTF_NUMBER_TABLE
1820: , p5_a36 JTF_DATE_TABLE
1821: , p5_a37 JTF_NUMBER_TABLE
1822: , p5_a38 JTF_VARCHAR2_TABLE_100
1823: , p5_a39 JTF_VARCHAR2_TABLE_100
1824: , p5_a40 JTF_NUMBER_TABLE
1825: , p5_a41 JTF_DATE_TABLE
1820: , p5_a36 JTF_DATE_TABLE
1821: , p5_a37 JTF_NUMBER_TABLE
1822: , p5_a38 JTF_VARCHAR2_TABLE_100
1823: , p5_a39 JTF_VARCHAR2_TABLE_100
1824: , p5_a40 JTF_NUMBER_TABLE
1825: , p5_a41 JTF_DATE_TABLE
1826: , p7_a0 out nocopy JTF_NUMBER_TABLE
1827: , p6_a0 NUMBER := 0-1962.0724
1828: , p6_a1 NUMBER := 0-1962.0724
1822: , p5_a38 JTF_VARCHAR2_TABLE_100
1823: , p5_a39 JTF_VARCHAR2_TABLE_100
1824: , p5_a40 JTF_NUMBER_TABLE
1825: , p5_a41 JTF_DATE_TABLE
1826: , p7_a0 out nocopy JTF_NUMBER_TABLE
1827: , p6_a0 NUMBER := 0-1962.0724
1828: , p6_a1 NUMBER := 0-1962.0724
1829: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
1830: , p6_a3 NUMBER := 0-1962.0724
2064: , x_return_status out nocopy VARCHAR2
2065: , x_msg_count out nocopy NUMBER
2066: , x_msg_data out nocopy VARCHAR2
2067: , p_cle_id NUMBER
2068: , p6_a0 out nocopy JTF_NUMBER_TABLE
2069: )
2070:
2071: as
2072: ddx_cle_tbl okl_split_asset_pvt.cle_tbl_type;
2105: , p_init_msg_list VARCHAR2
2106: , x_return_status out nocopy VARCHAR2
2107: , x_msg_count out nocopy NUMBER
2108: , x_msg_data out nocopy VARCHAR2
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_NUMBER_TABLE
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2106: , x_return_status out nocopy VARCHAR2
2107: , x_msg_count out nocopy NUMBER
2108: , x_msg_data out nocopy VARCHAR2
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_NUMBER_TABLE
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_VARCHAR2_TABLE_100
2107: , x_msg_count out nocopy NUMBER
2108: , x_msg_data out nocopy VARCHAR2
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_NUMBER_TABLE
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_VARCHAR2_TABLE_100
2115: , p5_a6 JTF_NUMBER_TABLE
2108: , x_msg_data out nocopy VARCHAR2
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_NUMBER_TABLE
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_VARCHAR2_TABLE_100
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_VARCHAR2_TABLE_100
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_NUMBER_TABLE
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_VARCHAR2_TABLE_100
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_VARCHAR2_TABLE_100
2117: , p5_a8 JTF_VARCHAR2_TABLE_100
2111: , p5_a2 JTF_NUMBER_TABLE
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_VARCHAR2_TABLE_100
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_VARCHAR2_TABLE_100
2117: , p5_a8 JTF_VARCHAR2_TABLE_100
2118: , p5_a9 JTF_VARCHAR2_TABLE_200
2119: , p5_a10 JTF_VARCHAR2_TABLE_100
2119: , p5_a10 JTF_VARCHAR2_TABLE_100
2120: , p5_a11 JTF_VARCHAR2_TABLE_100
2121: , p5_a12 JTF_VARCHAR2_TABLE_200
2122: , p5_a13 JTF_VARCHAR2_TABLE_100
2123: , p5_a14 JTF_NUMBER_TABLE
2124: , p5_a15 JTF_VARCHAR2_TABLE_100
2125: , p5_a16 JTF_VARCHAR2_TABLE_100
2126: , p5_a17 JTF_NUMBER_TABLE
2127: , p5_a18 JTF_NUMBER_TABLE
2122: , p5_a13 JTF_VARCHAR2_TABLE_100
2123: , p5_a14 JTF_NUMBER_TABLE
2124: , p5_a15 JTF_VARCHAR2_TABLE_100
2125: , p5_a16 JTF_VARCHAR2_TABLE_100
2126: , p5_a17 JTF_NUMBER_TABLE
2127: , p5_a18 JTF_NUMBER_TABLE
2128: , p5_a19 JTF_VARCHAR2_TABLE_100
2129: , p5_a20 JTF_VARCHAR2_TABLE_500
2130: , p5_a21 JTF_VARCHAR2_TABLE_500
2123: , p5_a14 JTF_NUMBER_TABLE
2124: , p5_a15 JTF_VARCHAR2_TABLE_100
2125: , p5_a16 JTF_VARCHAR2_TABLE_100
2126: , p5_a17 JTF_NUMBER_TABLE
2127: , p5_a18 JTF_NUMBER_TABLE
2128: , p5_a19 JTF_VARCHAR2_TABLE_100
2129: , p5_a20 JTF_VARCHAR2_TABLE_500
2130: , p5_a21 JTF_VARCHAR2_TABLE_500
2131: , p5_a22 JTF_VARCHAR2_TABLE_500
2140: , p5_a31 JTF_VARCHAR2_TABLE_500
2141: , p5_a32 JTF_VARCHAR2_TABLE_500
2142: , p5_a33 JTF_VARCHAR2_TABLE_500
2143: , p5_a34 JTF_VARCHAR2_TABLE_500
2144: , p5_a35 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2147: , p5_a38 JTF_DATE_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2142: , p5_a33 JTF_VARCHAR2_TABLE_500
2143: , p5_a34 JTF_VARCHAR2_TABLE_500
2144: , p5_a35 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2147: , p5_a38 JTF_DATE_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2149: , p5_a40 JTF_NUMBER_TABLE
2150: , p5_a41 JTF_NUMBER_TABLE
2144: , p5_a35 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2147: , p5_a38 JTF_DATE_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2149: , p5_a40 JTF_NUMBER_TABLE
2150: , p5_a41 JTF_NUMBER_TABLE
2151: , p5_a42 JTF_VARCHAR2_TABLE_100
2152: , p5_a43 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2147: , p5_a38 JTF_DATE_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2149: , p5_a40 JTF_NUMBER_TABLE
2150: , p5_a41 JTF_NUMBER_TABLE
2151: , p5_a42 JTF_VARCHAR2_TABLE_100
2152: , p5_a43 JTF_NUMBER_TABLE
2153: , p6_a0 out nocopy JTF_NUMBER_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2147: , p5_a38 JTF_DATE_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2149: , p5_a40 JTF_NUMBER_TABLE
2150: , p5_a41 JTF_NUMBER_TABLE
2151: , p5_a42 JTF_VARCHAR2_TABLE_100
2152: , p5_a43 JTF_NUMBER_TABLE
2153: , p6_a0 out nocopy JTF_NUMBER_TABLE
2154: , p6_a1 out nocopy JTF_NUMBER_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2149: , p5_a40 JTF_NUMBER_TABLE
2150: , p5_a41 JTF_NUMBER_TABLE
2151: , p5_a42 JTF_VARCHAR2_TABLE_100
2152: , p5_a43 JTF_NUMBER_TABLE
2153: , p6_a0 out nocopy JTF_NUMBER_TABLE
2154: , p6_a1 out nocopy JTF_NUMBER_TABLE
2155: , p6_a2 out nocopy JTF_NUMBER_TABLE
2156: , p6_a3 out nocopy JTF_NUMBER_TABLE
2149: , p5_a40 JTF_NUMBER_TABLE
2150: , p5_a41 JTF_NUMBER_TABLE
2151: , p5_a42 JTF_VARCHAR2_TABLE_100
2152: , p5_a43 JTF_NUMBER_TABLE
2153: , p6_a0 out nocopy JTF_NUMBER_TABLE
2154: , p6_a1 out nocopy JTF_NUMBER_TABLE
2155: , p6_a2 out nocopy JTF_NUMBER_TABLE
2156: , p6_a3 out nocopy JTF_NUMBER_TABLE
2157: , p6_a4 out nocopy JTF_NUMBER_TABLE
2150: , p5_a41 JTF_NUMBER_TABLE
2151: , p5_a42 JTF_VARCHAR2_TABLE_100
2152: , p5_a43 JTF_NUMBER_TABLE
2153: , p6_a0 out nocopy JTF_NUMBER_TABLE
2154: , p6_a1 out nocopy JTF_NUMBER_TABLE
2155: , p6_a2 out nocopy JTF_NUMBER_TABLE
2156: , p6_a3 out nocopy JTF_NUMBER_TABLE
2157: , p6_a4 out nocopy JTF_NUMBER_TABLE
2158: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2151: , p5_a42 JTF_VARCHAR2_TABLE_100
2152: , p5_a43 JTF_NUMBER_TABLE
2153: , p6_a0 out nocopy JTF_NUMBER_TABLE
2154: , p6_a1 out nocopy JTF_NUMBER_TABLE
2155: , p6_a2 out nocopy JTF_NUMBER_TABLE
2156: , p6_a3 out nocopy JTF_NUMBER_TABLE
2157: , p6_a4 out nocopy JTF_NUMBER_TABLE
2158: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2159: , p6_a6 out nocopy JTF_NUMBER_TABLE
2152: , p5_a43 JTF_NUMBER_TABLE
2153: , p6_a0 out nocopy JTF_NUMBER_TABLE
2154: , p6_a1 out nocopy JTF_NUMBER_TABLE
2155: , p6_a2 out nocopy JTF_NUMBER_TABLE
2156: , p6_a3 out nocopy JTF_NUMBER_TABLE
2157: , p6_a4 out nocopy JTF_NUMBER_TABLE
2158: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2159: , p6_a6 out nocopy JTF_NUMBER_TABLE
2160: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2153: , p6_a0 out nocopy JTF_NUMBER_TABLE
2154: , p6_a1 out nocopy JTF_NUMBER_TABLE
2155: , p6_a2 out nocopy JTF_NUMBER_TABLE
2156: , p6_a3 out nocopy JTF_NUMBER_TABLE
2157: , p6_a4 out nocopy JTF_NUMBER_TABLE
2158: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2159: , p6_a6 out nocopy JTF_NUMBER_TABLE
2160: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2161: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2155: , p6_a2 out nocopy JTF_NUMBER_TABLE
2156: , p6_a3 out nocopy JTF_NUMBER_TABLE
2157: , p6_a4 out nocopy JTF_NUMBER_TABLE
2158: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2159: , p6_a6 out nocopy JTF_NUMBER_TABLE
2160: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2161: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2162: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
2163: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2163: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2164: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2165: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
2166: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2167: , p6_a14 out nocopy JTF_NUMBER_TABLE
2168: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2169: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2170: , p6_a17 out nocopy JTF_NUMBER_TABLE
2171: , p6_a18 out nocopy JTF_NUMBER_TABLE
2166: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2167: , p6_a14 out nocopy JTF_NUMBER_TABLE
2168: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2169: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2170: , p6_a17 out nocopy JTF_NUMBER_TABLE
2171: , p6_a18 out nocopy JTF_NUMBER_TABLE
2172: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2173: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
2174: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2167: , p6_a14 out nocopy JTF_NUMBER_TABLE
2168: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2169: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2170: , p6_a17 out nocopy JTF_NUMBER_TABLE
2171: , p6_a18 out nocopy JTF_NUMBER_TABLE
2172: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2173: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
2174: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2175: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2184: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
2185: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2186: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2187: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
2188: , p6_a35 out nocopy JTF_NUMBER_TABLE
2189: , p6_a36 out nocopy JTF_DATE_TABLE
2190: , p6_a37 out nocopy JTF_NUMBER_TABLE
2191: , p6_a38 out nocopy JTF_DATE_TABLE
2192: , p6_a39 out nocopy JTF_NUMBER_TABLE
2186: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2187: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
2188: , p6_a35 out nocopy JTF_NUMBER_TABLE
2189: , p6_a36 out nocopy JTF_DATE_TABLE
2190: , p6_a37 out nocopy JTF_NUMBER_TABLE
2191: , p6_a38 out nocopy JTF_DATE_TABLE
2192: , p6_a39 out nocopy JTF_NUMBER_TABLE
2193: , p6_a40 out nocopy JTF_NUMBER_TABLE
2194: , p6_a41 out nocopy JTF_NUMBER_TABLE
2188: , p6_a35 out nocopy JTF_NUMBER_TABLE
2189: , p6_a36 out nocopy JTF_DATE_TABLE
2190: , p6_a37 out nocopy JTF_NUMBER_TABLE
2191: , p6_a38 out nocopy JTF_DATE_TABLE
2192: , p6_a39 out nocopy JTF_NUMBER_TABLE
2193: , p6_a40 out nocopy JTF_NUMBER_TABLE
2194: , p6_a41 out nocopy JTF_NUMBER_TABLE
2195: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
2196: , p6_a43 out nocopy JTF_NUMBER_TABLE
2189: , p6_a36 out nocopy JTF_DATE_TABLE
2190: , p6_a37 out nocopy JTF_NUMBER_TABLE
2191: , p6_a38 out nocopy JTF_DATE_TABLE
2192: , p6_a39 out nocopy JTF_NUMBER_TABLE
2193: , p6_a40 out nocopy JTF_NUMBER_TABLE
2194: , p6_a41 out nocopy JTF_NUMBER_TABLE
2195: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
2196: , p6_a43 out nocopy JTF_NUMBER_TABLE
2197: )
2190: , p6_a37 out nocopy JTF_NUMBER_TABLE
2191: , p6_a38 out nocopy JTF_DATE_TABLE
2192: , p6_a39 out nocopy JTF_NUMBER_TABLE
2193: , p6_a40 out nocopy JTF_NUMBER_TABLE
2194: , p6_a41 out nocopy JTF_NUMBER_TABLE
2195: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
2196: , p6_a43 out nocopy JTF_NUMBER_TABLE
2197: )
2198:
2192: , p6_a39 out nocopy JTF_NUMBER_TABLE
2193: , p6_a40 out nocopy JTF_NUMBER_TABLE
2194: , p6_a41 out nocopy JTF_NUMBER_TABLE
2195: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
2196: , p6_a43 out nocopy JTF_NUMBER_TABLE
2197: )
2198:
2199: as
2200: ddp_itiv_tbl okl_split_asset_pvt.itiv_tbl_type;