1: package body okl_deal_charges_pvt_w as
2: /* $Header: OKLEKACB.pls 120.0.12020000.2 2012/08/07 12:52:24 racheruv ship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy okl_deal_charges_pvt.fee_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
1: package body okl_deal_charges_pvt_w as
2: /* $Header: OKLEKACB.pls 120.0.12020000.2 2012/08/07 12:52:24 racheruv ship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy okl_deal_charges_pvt.fee_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_100
2: /* $Header: OKLEKACB.pls 120.0.12020000.2 2012/08/07 12:52:24 racheruv ship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy okl_deal_charges_pvt.fee_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_400
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_VARCHAR2_TABLE_500
37: , a34 JTF_VARCHAR2_TABLE_500
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_500
37: , a34 JTF_VARCHAR2_TABLE_500
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_500
47: , a44 JTF_VARCHAR2_TABLE_500
48: , a45 JTF_NUMBER_TABLE
49: ) as
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_500
47: , a44 JTF_VARCHAR2_TABLE_500
48: , a45 JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
52: if a0 is not null and a0.count > 0 then
108: end loop;
109: end if;
110: end if;
111: end rosetta_table_copy_in_p13;
112: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_VARCHAR2_TABLE_200
109: end if;
110: end if;
111: end rosetta_table_copy_in_p13;
112: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_VARCHAR2_TABLE_200
117: , a5 out nocopy JTF_VARCHAR2_TABLE_100
111: end rosetta_table_copy_in_p13;
112: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_VARCHAR2_TABLE_200
117: , a5 out nocopy JTF_VARCHAR2_TABLE_100
118: , a6 out nocopy JTF_VARCHAR2_TABLE_200
119: , a7 out nocopy JTF_NUMBER_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_VARCHAR2_TABLE_200
117: , a5 out nocopy JTF_VARCHAR2_TABLE_100
118: , a6 out nocopy JTF_VARCHAR2_TABLE_200
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_VARCHAR2_TABLE_400
121: , a9 out nocopy JTF_VARCHAR2_TABLE_100
122: , a10 out nocopy JTF_VARCHAR2_TABLE_200
123: , a11 out nocopy JTF_DATE_TABLE
121: , a9 out nocopy JTF_VARCHAR2_TABLE_100
122: , a10 out nocopy JTF_VARCHAR2_TABLE_200
123: , a11 out nocopy JTF_DATE_TABLE
124: , a12 out nocopy JTF_DATE_TABLE
125: , a13 out nocopy JTF_NUMBER_TABLE
126: , a14 out nocopy JTF_NUMBER_TABLE
127: , a15 out nocopy JTF_NUMBER_TABLE
128: , a16 out nocopy JTF_NUMBER_TABLE
129: , a17 out nocopy JTF_DATE_TABLE
122: , a10 out nocopy JTF_VARCHAR2_TABLE_200
123: , a11 out nocopy JTF_DATE_TABLE
124: , a12 out nocopy JTF_DATE_TABLE
125: , a13 out nocopy JTF_NUMBER_TABLE
126: , a14 out nocopy JTF_NUMBER_TABLE
127: , a15 out nocopy JTF_NUMBER_TABLE
128: , a16 out nocopy JTF_NUMBER_TABLE
129: , a17 out nocopy JTF_DATE_TABLE
130: , a18 out nocopy JTF_VARCHAR2_TABLE_100
123: , a11 out nocopy JTF_DATE_TABLE
124: , a12 out nocopy JTF_DATE_TABLE
125: , a13 out nocopy JTF_NUMBER_TABLE
126: , a14 out nocopy JTF_NUMBER_TABLE
127: , a15 out nocopy JTF_NUMBER_TABLE
128: , a16 out nocopy JTF_NUMBER_TABLE
129: , a17 out nocopy JTF_DATE_TABLE
130: , a18 out nocopy JTF_VARCHAR2_TABLE_100
131: , a19 out nocopy JTF_VARCHAR2_TABLE_100
124: , a12 out nocopy JTF_DATE_TABLE
125: , a13 out nocopy JTF_NUMBER_TABLE
126: , a14 out nocopy JTF_NUMBER_TABLE
127: , a15 out nocopy JTF_NUMBER_TABLE
128: , a16 out nocopy JTF_NUMBER_TABLE
129: , a17 out nocopy JTF_DATE_TABLE
130: , a18 out nocopy JTF_VARCHAR2_TABLE_100
131: , a19 out nocopy JTF_VARCHAR2_TABLE_100
132: , a20 out nocopy JTF_VARCHAR2_TABLE_500
144: , a32 out nocopy JTF_VARCHAR2_TABLE_500
145: , a33 out nocopy JTF_VARCHAR2_TABLE_500
146: , a34 out nocopy JTF_VARCHAR2_TABLE_500
147: , a35 out nocopy JTF_VARCHAR2_TABLE_100
148: , a36 out nocopy JTF_NUMBER_TABLE
149: , a37 out nocopy JTF_NUMBER_TABLE
150: , a38 out nocopy JTF_VARCHAR2_TABLE_100
151: , a39 out nocopy JTF_VARCHAR2_TABLE_200
152: , a40 out nocopy JTF_VARCHAR2_TABLE_100
145: , a33 out nocopy JTF_VARCHAR2_TABLE_500
146: , a34 out nocopy JTF_VARCHAR2_TABLE_500
147: , a35 out nocopy JTF_VARCHAR2_TABLE_100
148: , a36 out nocopy JTF_NUMBER_TABLE
149: , a37 out nocopy JTF_NUMBER_TABLE
150: , a38 out nocopy JTF_VARCHAR2_TABLE_100
151: , a39 out nocopy JTF_VARCHAR2_TABLE_200
152: , a40 out nocopy JTF_VARCHAR2_TABLE_100
153: , a41 out nocopy JTF_VARCHAR2_TABLE_100
150: , a38 out nocopy JTF_VARCHAR2_TABLE_100
151: , a39 out nocopy JTF_VARCHAR2_TABLE_200
152: , a40 out nocopy JTF_VARCHAR2_TABLE_100
153: , a41 out nocopy JTF_VARCHAR2_TABLE_100
154: , a42 out nocopy JTF_NUMBER_TABLE
155: , a43 out nocopy JTF_VARCHAR2_TABLE_500
156: , a44 out nocopy JTF_VARCHAR2_TABLE_500
157: , a45 out nocopy JTF_NUMBER_TABLE
158: ) as
153: , a41 out nocopy JTF_VARCHAR2_TABLE_100
154: , a42 out nocopy JTF_NUMBER_TABLE
155: , a43 out nocopy JTF_VARCHAR2_TABLE_500
156: , a44 out nocopy JTF_VARCHAR2_TABLE_500
157: , a45 out nocopy JTF_NUMBER_TABLE
158: ) as
159: ddindx binary_integer; indx binary_integer;
160: begin
161: if t is null or t.count = 0 then
158: ) as
159: ddindx binary_integer; indx binary_integer;
160: begin
161: if t is null or t.count = 0 then
162: a0 := JTF_NUMBER_TABLE();
163: a1 := JTF_NUMBER_TABLE();
164: a2 := JTF_VARCHAR2_TABLE_100();
165: a3 := JTF_NUMBER_TABLE();
166: a4 := JTF_VARCHAR2_TABLE_200();
159: ddindx binary_integer; indx binary_integer;
160: begin
161: if t is null or t.count = 0 then
162: a0 := JTF_NUMBER_TABLE();
163: a1 := JTF_NUMBER_TABLE();
164: a2 := JTF_VARCHAR2_TABLE_100();
165: a3 := JTF_NUMBER_TABLE();
166: a4 := JTF_VARCHAR2_TABLE_200();
167: a5 := JTF_VARCHAR2_TABLE_100();
161: if t is null or t.count = 0 then
162: a0 := JTF_NUMBER_TABLE();
163: a1 := JTF_NUMBER_TABLE();
164: a2 := JTF_VARCHAR2_TABLE_100();
165: a3 := JTF_NUMBER_TABLE();
166: a4 := JTF_VARCHAR2_TABLE_200();
167: a5 := JTF_VARCHAR2_TABLE_100();
168: a6 := JTF_VARCHAR2_TABLE_200();
169: a7 := JTF_NUMBER_TABLE();
165: a3 := JTF_NUMBER_TABLE();
166: a4 := JTF_VARCHAR2_TABLE_200();
167: a5 := JTF_VARCHAR2_TABLE_100();
168: a6 := JTF_VARCHAR2_TABLE_200();
169: a7 := JTF_NUMBER_TABLE();
170: a8 := JTF_VARCHAR2_TABLE_400();
171: a9 := JTF_VARCHAR2_TABLE_100();
172: a10 := JTF_VARCHAR2_TABLE_200();
173: a11 := JTF_DATE_TABLE();
171: a9 := JTF_VARCHAR2_TABLE_100();
172: a10 := JTF_VARCHAR2_TABLE_200();
173: a11 := JTF_DATE_TABLE();
174: a12 := JTF_DATE_TABLE();
175: a13 := JTF_NUMBER_TABLE();
176: a14 := JTF_NUMBER_TABLE();
177: a15 := JTF_NUMBER_TABLE();
178: a16 := JTF_NUMBER_TABLE();
179: a17 := JTF_DATE_TABLE();
172: a10 := JTF_VARCHAR2_TABLE_200();
173: a11 := JTF_DATE_TABLE();
174: a12 := JTF_DATE_TABLE();
175: a13 := JTF_NUMBER_TABLE();
176: a14 := JTF_NUMBER_TABLE();
177: a15 := JTF_NUMBER_TABLE();
178: a16 := JTF_NUMBER_TABLE();
179: a17 := JTF_DATE_TABLE();
180: a18 := JTF_VARCHAR2_TABLE_100();
173: a11 := JTF_DATE_TABLE();
174: a12 := JTF_DATE_TABLE();
175: a13 := JTF_NUMBER_TABLE();
176: a14 := JTF_NUMBER_TABLE();
177: a15 := JTF_NUMBER_TABLE();
178: a16 := JTF_NUMBER_TABLE();
179: a17 := JTF_DATE_TABLE();
180: a18 := JTF_VARCHAR2_TABLE_100();
181: a19 := JTF_VARCHAR2_TABLE_100();
174: a12 := JTF_DATE_TABLE();
175: a13 := JTF_NUMBER_TABLE();
176: a14 := JTF_NUMBER_TABLE();
177: a15 := JTF_NUMBER_TABLE();
178: a16 := JTF_NUMBER_TABLE();
179: a17 := JTF_DATE_TABLE();
180: a18 := JTF_VARCHAR2_TABLE_100();
181: a19 := JTF_VARCHAR2_TABLE_100();
182: a20 := JTF_VARCHAR2_TABLE_500();
194: a32 := JTF_VARCHAR2_TABLE_500();
195: a33 := JTF_VARCHAR2_TABLE_500();
196: a34 := JTF_VARCHAR2_TABLE_500();
197: a35 := JTF_VARCHAR2_TABLE_100();
198: a36 := JTF_NUMBER_TABLE();
199: a37 := JTF_NUMBER_TABLE();
200: a38 := JTF_VARCHAR2_TABLE_100();
201: a39 := JTF_VARCHAR2_TABLE_200();
202: a40 := JTF_VARCHAR2_TABLE_100();
195: a33 := JTF_VARCHAR2_TABLE_500();
196: a34 := JTF_VARCHAR2_TABLE_500();
197: a35 := JTF_VARCHAR2_TABLE_100();
198: a36 := JTF_NUMBER_TABLE();
199: a37 := JTF_NUMBER_TABLE();
200: a38 := JTF_VARCHAR2_TABLE_100();
201: a39 := JTF_VARCHAR2_TABLE_200();
202: a40 := JTF_VARCHAR2_TABLE_100();
203: a41 := JTF_VARCHAR2_TABLE_100();
200: a38 := JTF_VARCHAR2_TABLE_100();
201: a39 := JTF_VARCHAR2_TABLE_200();
202: a40 := JTF_VARCHAR2_TABLE_100();
203: a41 := JTF_VARCHAR2_TABLE_100();
204: a42 := JTF_NUMBER_TABLE();
205: a43 := JTF_VARCHAR2_TABLE_500();
206: a44 := JTF_VARCHAR2_TABLE_500();
207: a45 := JTF_NUMBER_TABLE();
208: else
203: a41 := JTF_VARCHAR2_TABLE_100();
204: a42 := JTF_NUMBER_TABLE();
205: a43 := JTF_VARCHAR2_TABLE_500();
206: a44 := JTF_VARCHAR2_TABLE_500();
207: a45 := JTF_NUMBER_TABLE();
208: else
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_VARCHAR2_TABLE_100();
205: a43 := JTF_VARCHAR2_TABLE_500();
206: a44 := JTF_VARCHAR2_TABLE_500();
207: a45 := JTF_NUMBER_TABLE();
208: else
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_VARCHAR2_TABLE_100();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_VARCHAR2_TABLE_200();
206: a44 := JTF_VARCHAR2_TABLE_500();
207: a45 := JTF_NUMBER_TABLE();
208: else
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_VARCHAR2_TABLE_100();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_VARCHAR2_TABLE_200();
214: a5 := JTF_VARCHAR2_TABLE_100();
208: else
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_VARCHAR2_TABLE_100();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_VARCHAR2_TABLE_200();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_VARCHAR2_TABLE_200();
216: a7 := JTF_NUMBER_TABLE();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_VARCHAR2_TABLE_200();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_VARCHAR2_TABLE_200();
216: a7 := JTF_NUMBER_TABLE();
217: a8 := JTF_VARCHAR2_TABLE_400();
218: a9 := JTF_VARCHAR2_TABLE_100();
219: a10 := JTF_VARCHAR2_TABLE_200();
220: a11 := JTF_DATE_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_100();
219: a10 := JTF_VARCHAR2_TABLE_200();
220: a11 := JTF_DATE_TABLE();
221: a12 := JTF_DATE_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_DATE_TABLE();
219: a10 := JTF_VARCHAR2_TABLE_200();
220: a11 := JTF_DATE_TABLE();
221: a12 := JTF_DATE_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_DATE_TABLE();
227: a18 := JTF_VARCHAR2_TABLE_100();
220: a11 := JTF_DATE_TABLE();
221: a12 := JTF_DATE_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_DATE_TABLE();
227: a18 := JTF_VARCHAR2_TABLE_100();
228: a19 := JTF_VARCHAR2_TABLE_100();
221: a12 := JTF_DATE_TABLE();
222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_DATE_TABLE();
227: a18 := JTF_VARCHAR2_TABLE_100();
228: a19 := JTF_VARCHAR2_TABLE_100();
229: a20 := JTF_VARCHAR2_TABLE_500();
241: a32 := JTF_VARCHAR2_TABLE_500();
242: a33 := JTF_VARCHAR2_TABLE_500();
243: a34 := JTF_VARCHAR2_TABLE_500();
244: a35 := JTF_VARCHAR2_TABLE_100();
245: a36 := JTF_NUMBER_TABLE();
246: a37 := JTF_NUMBER_TABLE();
247: a38 := JTF_VARCHAR2_TABLE_100();
248: a39 := JTF_VARCHAR2_TABLE_200();
249: a40 := JTF_VARCHAR2_TABLE_100();
242: a33 := JTF_VARCHAR2_TABLE_500();
243: a34 := JTF_VARCHAR2_TABLE_500();
244: a35 := JTF_VARCHAR2_TABLE_100();
245: a36 := JTF_NUMBER_TABLE();
246: a37 := JTF_NUMBER_TABLE();
247: a38 := JTF_VARCHAR2_TABLE_100();
248: a39 := JTF_VARCHAR2_TABLE_200();
249: a40 := JTF_VARCHAR2_TABLE_100();
250: a41 := JTF_VARCHAR2_TABLE_100();
247: a38 := JTF_VARCHAR2_TABLE_100();
248: a39 := JTF_VARCHAR2_TABLE_200();
249: a40 := JTF_VARCHAR2_TABLE_100();
250: a41 := JTF_VARCHAR2_TABLE_100();
251: a42 := JTF_NUMBER_TABLE();
252: a43 := JTF_VARCHAR2_TABLE_500();
253: a44 := JTF_VARCHAR2_TABLE_500();
254: a45 := JTF_NUMBER_TABLE();
255: if t.count > 0 then
250: a41 := JTF_VARCHAR2_TABLE_100();
251: a42 := JTF_NUMBER_TABLE();
252: a43 := JTF_VARCHAR2_TABLE_500();
253: a44 := JTF_VARCHAR2_TABLE_500();
254: a45 := JTF_NUMBER_TABLE();
255: if t.count > 0 then
256: a0.extend(t.count);
257: a1.extend(t.count);
258: a2.extend(t.count);
357: end if;
358: end if;
359: end rosetta_table_copy_out_p13;
360:
361: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
362: , a1 JTF_NUMBER_TABLE
363: , a2 JTF_NUMBER_TABLE
364: , a3 JTF_VARCHAR2_TABLE_200
365: , a4 JTF_VARCHAR2_TABLE_2000
358: end if;
359: end rosetta_table_copy_out_p13;
360:
361: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
362: , a1 JTF_NUMBER_TABLE
363: , a2 JTF_NUMBER_TABLE
364: , a3 JTF_VARCHAR2_TABLE_200
365: , a4 JTF_VARCHAR2_TABLE_2000
366: , a5 JTF_NUMBER_TABLE
359: end rosetta_table_copy_out_p13;
360:
361: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
362: , a1 JTF_NUMBER_TABLE
363: , a2 JTF_NUMBER_TABLE
364: , a3 JTF_VARCHAR2_TABLE_200
365: , a4 JTF_VARCHAR2_TABLE_2000
366: , a5 JTF_NUMBER_TABLE
367: , a6 JTF_NUMBER_TABLE
362: , a1 JTF_NUMBER_TABLE
363: , a2 JTF_NUMBER_TABLE
364: , a3 JTF_VARCHAR2_TABLE_200
365: , a4 JTF_VARCHAR2_TABLE_2000
366: , a5 JTF_NUMBER_TABLE
367: , a6 JTF_NUMBER_TABLE
368: , a7 JTF_VARCHAR2_TABLE_100
369: , a8 JTF_VARCHAR2_TABLE_200
370: , a9 JTF_VARCHAR2_TABLE_100
363: , a2 JTF_NUMBER_TABLE
364: , a3 JTF_VARCHAR2_TABLE_200
365: , a4 JTF_VARCHAR2_TABLE_2000
366: , a5 JTF_NUMBER_TABLE
367: , a6 JTF_NUMBER_TABLE
368: , a7 JTF_VARCHAR2_TABLE_100
369: , a8 JTF_VARCHAR2_TABLE_200
370: , a9 JTF_VARCHAR2_TABLE_100
371: ) as
394: end loop;
395: end if;
396: end if;
397: end rosetta_table_copy_in_p15;
398: procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
399: , a1 out nocopy JTF_NUMBER_TABLE
400: , a2 out nocopy JTF_NUMBER_TABLE
401: , a3 out nocopy JTF_VARCHAR2_TABLE_200
402: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
395: end if;
396: end if;
397: end rosetta_table_copy_in_p15;
398: procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
399: , a1 out nocopy JTF_NUMBER_TABLE
400: , a2 out nocopy JTF_NUMBER_TABLE
401: , a3 out nocopy JTF_VARCHAR2_TABLE_200
402: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
403: , a5 out nocopy JTF_NUMBER_TABLE
396: end if;
397: end rosetta_table_copy_in_p15;
398: procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
399: , a1 out nocopy JTF_NUMBER_TABLE
400: , a2 out nocopy JTF_NUMBER_TABLE
401: , a3 out nocopy JTF_VARCHAR2_TABLE_200
402: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
403: , a5 out nocopy JTF_NUMBER_TABLE
404: , a6 out nocopy JTF_NUMBER_TABLE
399: , a1 out nocopy JTF_NUMBER_TABLE
400: , a2 out nocopy JTF_NUMBER_TABLE
401: , a3 out nocopy JTF_VARCHAR2_TABLE_200
402: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
403: , a5 out nocopy JTF_NUMBER_TABLE
404: , a6 out nocopy JTF_NUMBER_TABLE
405: , a7 out nocopy JTF_VARCHAR2_TABLE_100
406: , a8 out nocopy JTF_VARCHAR2_TABLE_200
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , a2 out nocopy JTF_NUMBER_TABLE
401: , a3 out nocopy JTF_VARCHAR2_TABLE_200
402: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
403: , a5 out nocopy JTF_NUMBER_TABLE
404: , a6 out nocopy JTF_NUMBER_TABLE
405: , a7 out nocopy JTF_VARCHAR2_TABLE_100
406: , a8 out nocopy JTF_VARCHAR2_TABLE_200
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
408: ) as
408: ) as
409: ddindx binary_integer; indx binary_integer;
410: begin
411: if t is null or t.count = 0 then
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_NUMBER_TABLE();
415: a3 := JTF_VARCHAR2_TABLE_200();
416: a4 := JTF_VARCHAR2_TABLE_2000();
409: ddindx binary_integer; indx binary_integer;
410: begin
411: if t is null or t.count = 0 then
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_NUMBER_TABLE();
415: a3 := JTF_VARCHAR2_TABLE_200();
416: a4 := JTF_VARCHAR2_TABLE_2000();
417: a5 := JTF_NUMBER_TABLE();
410: begin
411: if t is null or t.count = 0 then
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_NUMBER_TABLE();
415: a3 := JTF_VARCHAR2_TABLE_200();
416: a4 := JTF_VARCHAR2_TABLE_2000();
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_NUMBER_TABLE();
415: a3 := JTF_VARCHAR2_TABLE_200();
416: a4 := JTF_VARCHAR2_TABLE_2000();
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_NUMBER_TABLE();
419: a7 := JTF_VARCHAR2_TABLE_100();
420: a8 := JTF_VARCHAR2_TABLE_200();
421: a9 := JTF_VARCHAR2_TABLE_100();
414: a2 := JTF_NUMBER_TABLE();
415: a3 := JTF_VARCHAR2_TABLE_200();
416: a4 := JTF_VARCHAR2_TABLE_2000();
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_NUMBER_TABLE();
419: a7 := JTF_VARCHAR2_TABLE_100();
420: a8 := JTF_VARCHAR2_TABLE_200();
421: a9 := JTF_VARCHAR2_TABLE_100();
422: else
419: a7 := JTF_VARCHAR2_TABLE_100();
420: a8 := JTF_VARCHAR2_TABLE_200();
421: a9 := JTF_VARCHAR2_TABLE_100();
422: else
423: a0 := JTF_NUMBER_TABLE();
424: a1 := JTF_NUMBER_TABLE();
425: a2 := JTF_NUMBER_TABLE();
426: a3 := JTF_VARCHAR2_TABLE_200();
427: a4 := JTF_VARCHAR2_TABLE_2000();
420: a8 := JTF_VARCHAR2_TABLE_200();
421: a9 := JTF_VARCHAR2_TABLE_100();
422: else
423: a0 := JTF_NUMBER_TABLE();
424: a1 := JTF_NUMBER_TABLE();
425: a2 := JTF_NUMBER_TABLE();
426: a3 := JTF_VARCHAR2_TABLE_200();
427: a4 := JTF_VARCHAR2_TABLE_2000();
428: a5 := JTF_NUMBER_TABLE();
421: a9 := JTF_VARCHAR2_TABLE_100();
422: else
423: a0 := JTF_NUMBER_TABLE();
424: a1 := JTF_NUMBER_TABLE();
425: a2 := JTF_NUMBER_TABLE();
426: a3 := JTF_VARCHAR2_TABLE_200();
427: a4 := JTF_VARCHAR2_TABLE_2000();
428: a5 := JTF_NUMBER_TABLE();
429: a6 := JTF_NUMBER_TABLE();
424: a1 := JTF_NUMBER_TABLE();
425: a2 := JTF_NUMBER_TABLE();
426: a3 := JTF_VARCHAR2_TABLE_200();
427: a4 := JTF_VARCHAR2_TABLE_2000();
428: a5 := JTF_NUMBER_TABLE();
429: a6 := JTF_NUMBER_TABLE();
430: a7 := JTF_VARCHAR2_TABLE_100();
431: a8 := JTF_VARCHAR2_TABLE_200();
432: a9 := JTF_VARCHAR2_TABLE_100();
425: a2 := JTF_NUMBER_TABLE();
426: a3 := JTF_VARCHAR2_TABLE_200();
427: a4 := JTF_VARCHAR2_TABLE_2000();
428: a5 := JTF_NUMBER_TABLE();
429: a6 := JTF_NUMBER_TABLE();
430: a7 := JTF_VARCHAR2_TABLE_100();
431: a8 := JTF_VARCHAR2_TABLE_200();
432: a9 := JTF_VARCHAR2_TABLE_100();
433: if t.count > 0 then
472: , p_chr_id NUMBER
473: , p_cle_id NUMBER
474: , p_amount NUMBER
475: , p_mode VARCHAR2
476: , p9_a0 out nocopy JTF_NUMBER_TABLE
477: , p9_a1 out nocopy JTF_NUMBER_TABLE
478: , p9_a2 out nocopy JTF_NUMBER_TABLE
479: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
480: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
473: , p_cle_id NUMBER
474: , p_amount NUMBER
475: , p_mode VARCHAR2
476: , p9_a0 out nocopy JTF_NUMBER_TABLE
477: , p9_a1 out nocopy JTF_NUMBER_TABLE
478: , p9_a2 out nocopy JTF_NUMBER_TABLE
479: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
480: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
481: , p9_a5 out nocopy JTF_NUMBER_TABLE
474: , p_amount NUMBER
475: , p_mode VARCHAR2
476: , p9_a0 out nocopy JTF_NUMBER_TABLE
477: , p9_a1 out nocopy JTF_NUMBER_TABLE
478: , p9_a2 out nocopy JTF_NUMBER_TABLE
479: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
480: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
481: , p9_a5 out nocopy JTF_NUMBER_TABLE
482: , p9_a6 out nocopy JTF_NUMBER_TABLE
477: , p9_a1 out nocopy JTF_NUMBER_TABLE
478: , p9_a2 out nocopy JTF_NUMBER_TABLE
479: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
480: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
481: , p9_a5 out nocopy JTF_NUMBER_TABLE
482: , p9_a6 out nocopy JTF_NUMBER_TABLE
483: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
484: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
485: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
478: , p9_a2 out nocopy JTF_NUMBER_TABLE
479: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
480: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
481: , p9_a5 out nocopy JTF_NUMBER_TABLE
482: , p9_a6 out nocopy JTF_NUMBER_TABLE
483: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
484: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
485: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
486: )