12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_200
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_200
43: , a27 JTF_VARCHAR2_TABLE_200
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_200
43: , a27 JTF_VARCHAR2_TABLE_200
44: , a28 JTF_VARCHAR2_TABLE_200
111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p3;
115: procedure rosetta_table_copy_out_p3(t ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_VARCHAR2_TABLE_100
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
113: end if;
114: end rosetta_table_copy_in_p3;
115: procedure rosetta_table_copy_out_p3(t ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_VARCHAR2_TABLE_100
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: end rosetta_table_copy_in_p3;
115: procedure rosetta_table_copy_out_p3(t ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_VARCHAR2_TABLE_100
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_VARCHAR2_TABLE_100
122: , a7 out nocopy JTF_VARCHAR2_TABLE_100
115: procedure rosetta_table_copy_out_p3(t ahl_mc_rule_pvt.ui_rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_VARCHAR2_TABLE_100
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_VARCHAR2_TABLE_100
122: , a7 out nocopy JTF_VARCHAR2_TABLE_100
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
116: , a1 out nocopy JTF_VARCHAR2_TABLE_100
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_VARCHAR2_TABLE_100
122: , a7 out nocopy JTF_VARCHAR2_TABLE_100
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
122: , a7 out nocopy JTF_VARCHAR2_TABLE_100
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_NUMBER_TABLE
127: , a12 out nocopy JTF_VARCHAR2_TABLE_100
128: , a13 out nocopy JTF_VARCHAR2_TABLE_100
129: , a14 out nocopy JTF_VARCHAR2_TABLE_100
130: , a15 out nocopy JTF_VARCHAR2_TABLE_100
133: , a18 out nocopy JTF_VARCHAR2_TABLE_100
134: , a19 out nocopy JTF_VARCHAR2_TABLE_100
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_VARCHAR2_TABLE_100
137: , a22 out nocopy JTF_NUMBER_TABLE
138: , a23 out nocopy JTF_NUMBER_TABLE
139: , a24 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_VARCHAR2_TABLE_100
141: , a26 out nocopy JTF_VARCHAR2_TABLE_200
134: , a19 out nocopy JTF_VARCHAR2_TABLE_100
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_VARCHAR2_TABLE_100
137: , a22 out nocopy JTF_NUMBER_TABLE
138: , a23 out nocopy JTF_NUMBER_TABLE
139: , a24 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_VARCHAR2_TABLE_100
141: , a26 out nocopy JTF_VARCHAR2_TABLE_200
142: , a27 out nocopy JTF_VARCHAR2_TABLE_200
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_VARCHAR2_TABLE_100
137: , a22 out nocopy JTF_NUMBER_TABLE
138: , a23 out nocopy JTF_NUMBER_TABLE
139: , a24 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_VARCHAR2_TABLE_100
141: , a26 out nocopy JTF_VARCHAR2_TABLE_200
142: , a27 out nocopy JTF_VARCHAR2_TABLE_200
143: , a28 out nocopy JTF_VARCHAR2_TABLE_200
156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin
159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_100();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_NUMBER_TABLE();
158: begin
159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_100();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_NUMBER_TABLE();
166: a6 := JTF_VARCHAR2_TABLE_100();
159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_100();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_NUMBER_TABLE();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_VARCHAR2_TABLE_100();
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_100();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_NUMBER_TABLE();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_VARCHAR2_TABLE_100();
168: a8 := JTF_VARCHAR2_TABLE_100();
161: a1 := JTF_VARCHAR2_TABLE_100();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_NUMBER_TABLE();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_VARCHAR2_TABLE_100();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_VARCHAR2_TABLE_100();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_VARCHAR2_TABLE_100();
170: a10 := JTF_VARCHAR2_TABLE_100();
171: a11 := JTF_NUMBER_TABLE();
172: a12 := JTF_VARCHAR2_TABLE_100();
173: a13 := JTF_VARCHAR2_TABLE_100();
174: a14 := JTF_VARCHAR2_TABLE_100();
175: a15 := JTF_VARCHAR2_TABLE_100();
178: a18 := JTF_VARCHAR2_TABLE_100();
179: a19 := JTF_VARCHAR2_TABLE_100();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_VARCHAR2_TABLE_100();
182: a22 := JTF_NUMBER_TABLE();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_VARCHAR2_TABLE_100();
186: a26 := JTF_VARCHAR2_TABLE_200();
179: a19 := JTF_VARCHAR2_TABLE_100();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_VARCHAR2_TABLE_100();
182: a22 := JTF_NUMBER_TABLE();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_VARCHAR2_TABLE_100();
186: a26 := JTF_VARCHAR2_TABLE_200();
187: a27 := JTF_VARCHAR2_TABLE_200();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_VARCHAR2_TABLE_100();
182: a22 := JTF_NUMBER_TABLE();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_VARCHAR2_TABLE_100();
186: a26 := JTF_VARCHAR2_TABLE_200();
187: a27 := JTF_VARCHAR2_TABLE_200();
188: a28 := JTF_VARCHAR2_TABLE_200();
198: a38 := JTF_VARCHAR2_TABLE_200();
199: a39 := JTF_VARCHAR2_TABLE_200();
200: a40 := JTF_VARCHAR2_TABLE_200();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_VARCHAR2_TABLE_100();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_NUMBER_TABLE();
200: a40 := JTF_VARCHAR2_TABLE_200();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_VARCHAR2_TABLE_100();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_NUMBER_TABLE();
207: a5 := JTF_NUMBER_TABLE();
208: a6 := JTF_VARCHAR2_TABLE_100();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_VARCHAR2_TABLE_100();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_NUMBER_TABLE();
207: a5 := JTF_NUMBER_TABLE();
208: a6 := JTF_VARCHAR2_TABLE_100();
209: a7 := JTF_VARCHAR2_TABLE_100();
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_VARCHAR2_TABLE_100();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_NUMBER_TABLE();
207: a5 := JTF_NUMBER_TABLE();
208: a6 := JTF_VARCHAR2_TABLE_100();
209: a7 := JTF_VARCHAR2_TABLE_100();
210: a8 := JTF_VARCHAR2_TABLE_100();
203: a1 := JTF_VARCHAR2_TABLE_100();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_NUMBER_TABLE();
207: a5 := JTF_NUMBER_TABLE();
208: a6 := JTF_VARCHAR2_TABLE_100();
209: a7 := JTF_VARCHAR2_TABLE_100();
210: a8 := JTF_VARCHAR2_TABLE_100();
211: a9 := JTF_VARCHAR2_TABLE_100();
209: a7 := JTF_VARCHAR2_TABLE_100();
210: a8 := JTF_VARCHAR2_TABLE_100();
211: a9 := JTF_VARCHAR2_TABLE_100();
212: a10 := JTF_VARCHAR2_TABLE_100();
213: a11 := JTF_NUMBER_TABLE();
214: a12 := JTF_VARCHAR2_TABLE_100();
215: a13 := JTF_VARCHAR2_TABLE_100();
216: a14 := JTF_VARCHAR2_TABLE_100();
217: a15 := JTF_VARCHAR2_TABLE_100();
220: a18 := JTF_VARCHAR2_TABLE_100();
221: a19 := JTF_VARCHAR2_TABLE_100();
222: a20 := JTF_VARCHAR2_TABLE_100();
223: a21 := JTF_VARCHAR2_TABLE_100();
224: a22 := JTF_NUMBER_TABLE();
225: a23 := JTF_NUMBER_TABLE();
226: a24 := JTF_NUMBER_TABLE();
227: a25 := JTF_VARCHAR2_TABLE_100();
228: a26 := JTF_VARCHAR2_TABLE_200();
221: a19 := JTF_VARCHAR2_TABLE_100();
222: a20 := JTF_VARCHAR2_TABLE_100();
223: a21 := JTF_VARCHAR2_TABLE_100();
224: a22 := JTF_NUMBER_TABLE();
225: a23 := JTF_NUMBER_TABLE();
226: a24 := JTF_NUMBER_TABLE();
227: a25 := JTF_VARCHAR2_TABLE_100();
228: a26 := JTF_VARCHAR2_TABLE_200();
229: a27 := JTF_VARCHAR2_TABLE_200();
222: a20 := JTF_VARCHAR2_TABLE_100();
223: a21 := JTF_VARCHAR2_TABLE_100();
224: a22 := JTF_NUMBER_TABLE();
225: a23 := JTF_NUMBER_TABLE();
226: a24 := JTF_NUMBER_TABLE();
227: a25 := JTF_VARCHAR2_TABLE_100();
228: a26 := JTF_VARCHAR2_TABLE_200();
229: a27 := JTF_VARCHAR2_TABLE_200();
230: a28 := JTF_VARCHAR2_TABLE_200();
335: end if;
336: end if;
337: end rosetta_table_copy_out_p3;
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
336: end if;
337: end rosetta_table_copy_out_p3;
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
347: , a8 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_VARCHAR2_TABLE_100
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
347: , a8 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_VARCHAR2_TABLE_100
349: , a10 JTF_NUMBER_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
347: , a8 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_VARCHAR2_TABLE_100
349: , a10 JTF_NUMBER_TABLE
350: , a11 JTF_VARCHAR2_TABLE_100
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
347: , a8 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_VARCHAR2_TABLE_100
349: , a10 JTF_NUMBER_TABLE
350: , a11 JTF_VARCHAR2_TABLE_100
351: , a12 JTF_VARCHAR2_TABLE_100
352: , a13 JTF_NUMBER_TABLE
353: , a14 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_VARCHAR2_TABLE_100
349: , a10 JTF_NUMBER_TABLE
350: , a11 JTF_VARCHAR2_TABLE_100
351: , a12 JTF_VARCHAR2_TABLE_100
352: , a13 JTF_NUMBER_TABLE
353: , a14 JTF_VARCHAR2_TABLE_100
354: , a15 JTF_VARCHAR2_TABLE_100
355: , a16 JTF_VARCHAR2_TABLE_100
356: , a17 JTF_VARCHAR2_TABLE_100
426: end loop;
427: end if;
428: end if;
429: end rosetta_table_copy_in_p4;
430: procedure rosetta_table_copy_out_p4(t ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
431: , a1 out nocopy JTF_NUMBER_TABLE
432: , a2 out nocopy JTF_DATE_TABLE
433: , a3 out nocopy JTF_NUMBER_TABLE
434: , a4 out nocopy JTF_DATE_TABLE
427: end if;
428: end if;
429: end rosetta_table_copy_in_p4;
430: procedure rosetta_table_copy_out_p4(t ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
431: , a1 out nocopy JTF_NUMBER_TABLE
432: , a2 out nocopy JTF_DATE_TABLE
433: , a3 out nocopy JTF_NUMBER_TABLE
434: , a4 out nocopy JTF_DATE_TABLE
435: , a5 out nocopy JTF_NUMBER_TABLE
429: end rosetta_table_copy_in_p4;
430: procedure rosetta_table_copy_out_p4(t ahl_mc_rule_pvt.rule_stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
431: , a1 out nocopy JTF_NUMBER_TABLE
432: , a2 out nocopy JTF_DATE_TABLE
433: , a3 out nocopy JTF_NUMBER_TABLE
434: , a4 out nocopy JTF_DATE_TABLE
435: , a5 out nocopy JTF_NUMBER_TABLE
436: , a6 out nocopy JTF_NUMBER_TABLE
437: , a7 out nocopy JTF_NUMBER_TABLE
431: , a1 out nocopy JTF_NUMBER_TABLE
432: , a2 out nocopy JTF_DATE_TABLE
433: , a3 out nocopy JTF_NUMBER_TABLE
434: , a4 out nocopy JTF_DATE_TABLE
435: , a5 out nocopy JTF_NUMBER_TABLE
436: , a6 out nocopy JTF_NUMBER_TABLE
437: , a7 out nocopy JTF_NUMBER_TABLE
438: , a8 out nocopy JTF_VARCHAR2_TABLE_100
439: , a9 out nocopy JTF_VARCHAR2_TABLE_100
432: , a2 out nocopy JTF_DATE_TABLE
433: , a3 out nocopy JTF_NUMBER_TABLE
434: , a4 out nocopy JTF_DATE_TABLE
435: , a5 out nocopy JTF_NUMBER_TABLE
436: , a6 out nocopy JTF_NUMBER_TABLE
437: , a7 out nocopy JTF_NUMBER_TABLE
438: , a8 out nocopy JTF_VARCHAR2_TABLE_100
439: , a9 out nocopy JTF_VARCHAR2_TABLE_100
440: , a10 out nocopy JTF_NUMBER_TABLE
433: , a3 out nocopy JTF_NUMBER_TABLE
434: , a4 out nocopy JTF_DATE_TABLE
435: , a5 out nocopy JTF_NUMBER_TABLE
436: , a6 out nocopy JTF_NUMBER_TABLE
437: , a7 out nocopy JTF_NUMBER_TABLE
438: , a8 out nocopy JTF_VARCHAR2_TABLE_100
439: , a9 out nocopy JTF_VARCHAR2_TABLE_100
440: , a10 out nocopy JTF_NUMBER_TABLE
441: , a11 out nocopy JTF_VARCHAR2_TABLE_100
436: , a6 out nocopy JTF_NUMBER_TABLE
437: , a7 out nocopy JTF_NUMBER_TABLE
438: , a8 out nocopy JTF_VARCHAR2_TABLE_100
439: , a9 out nocopy JTF_VARCHAR2_TABLE_100
440: , a10 out nocopy JTF_NUMBER_TABLE
441: , a11 out nocopy JTF_VARCHAR2_TABLE_100
442: , a12 out nocopy JTF_VARCHAR2_TABLE_100
443: , a13 out nocopy JTF_NUMBER_TABLE
444: , a14 out nocopy JTF_VARCHAR2_TABLE_100
439: , a9 out nocopy JTF_VARCHAR2_TABLE_100
440: , a10 out nocopy JTF_NUMBER_TABLE
441: , a11 out nocopy JTF_VARCHAR2_TABLE_100
442: , a12 out nocopy JTF_VARCHAR2_TABLE_100
443: , a13 out nocopy JTF_NUMBER_TABLE
444: , a14 out nocopy JTF_VARCHAR2_TABLE_100
445: , a15 out nocopy JTF_VARCHAR2_TABLE_100
446: , a16 out nocopy JTF_VARCHAR2_TABLE_100
447: , a17 out nocopy JTF_VARCHAR2_TABLE_100
467: ) as
468: ddindx binary_integer; indx binary_integer;
469: begin
470: if t is null or t.count = 0 then
471: a0 := JTF_NUMBER_TABLE();
472: a1 := JTF_NUMBER_TABLE();
473: a2 := JTF_DATE_TABLE();
474: a3 := JTF_NUMBER_TABLE();
475: a4 := JTF_DATE_TABLE();
468: ddindx binary_integer; indx binary_integer;
469: begin
470: if t is null or t.count = 0 then
471: a0 := JTF_NUMBER_TABLE();
472: a1 := JTF_NUMBER_TABLE();
473: a2 := JTF_DATE_TABLE();
474: a3 := JTF_NUMBER_TABLE();
475: a4 := JTF_DATE_TABLE();
476: a5 := JTF_NUMBER_TABLE();
470: if t is null or t.count = 0 then
471: a0 := JTF_NUMBER_TABLE();
472: a1 := JTF_NUMBER_TABLE();
473: a2 := JTF_DATE_TABLE();
474: a3 := JTF_NUMBER_TABLE();
475: a4 := JTF_DATE_TABLE();
476: a5 := JTF_NUMBER_TABLE();
477: a6 := JTF_NUMBER_TABLE();
478: a7 := JTF_NUMBER_TABLE();
472: a1 := JTF_NUMBER_TABLE();
473: a2 := JTF_DATE_TABLE();
474: a3 := JTF_NUMBER_TABLE();
475: a4 := JTF_DATE_TABLE();
476: a5 := JTF_NUMBER_TABLE();
477: a6 := JTF_NUMBER_TABLE();
478: a7 := JTF_NUMBER_TABLE();
479: a8 := JTF_VARCHAR2_TABLE_100();
480: a9 := JTF_VARCHAR2_TABLE_100();
473: a2 := JTF_DATE_TABLE();
474: a3 := JTF_NUMBER_TABLE();
475: a4 := JTF_DATE_TABLE();
476: a5 := JTF_NUMBER_TABLE();
477: a6 := JTF_NUMBER_TABLE();
478: a7 := JTF_NUMBER_TABLE();
479: a8 := JTF_VARCHAR2_TABLE_100();
480: a9 := JTF_VARCHAR2_TABLE_100();
481: a10 := JTF_NUMBER_TABLE();
474: a3 := JTF_NUMBER_TABLE();
475: a4 := JTF_DATE_TABLE();
476: a5 := JTF_NUMBER_TABLE();
477: a6 := JTF_NUMBER_TABLE();
478: a7 := JTF_NUMBER_TABLE();
479: a8 := JTF_VARCHAR2_TABLE_100();
480: a9 := JTF_VARCHAR2_TABLE_100();
481: a10 := JTF_NUMBER_TABLE();
482: a11 := JTF_VARCHAR2_TABLE_100();
477: a6 := JTF_NUMBER_TABLE();
478: a7 := JTF_NUMBER_TABLE();
479: a8 := JTF_VARCHAR2_TABLE_100();
480: a9 := JTF_VARCHAR2_TABLE_100();
481: a10 := JTF_NUMBER_TABLE();
482: a11 := JTF_VARCHAR2_TABLE_100();
483: a12 := JTF_VARCHAR2_TABLE_100();
484: a13 := JTF_NUMBER_TABLE();
485: a14 := JTF_VARCHAR2_TABLE_100();
480: a9 := JTF_VARCHAR2_TABLE_100();
481: a10 := JTF_NUMBER_TABLE();
482: a11 := JTF_VARCHAR2_TABLE_100();
483: a12 := JTF_VARCHAR2_TABLE_100();
484: a13 := JTF_NUMBER_TABLE();
485: a14 := JTF_VARCHAR2_TABLE_100();
486: a15 := JTF_VARCHAR2_TABLE_100();
487: a16 := JTF_VARCHAR2_TABLE_100();
488: a17 := JTF_VARCHAR2_TABLE_100();
505: a34 := JTF_VARCHAR2_TABLE_200();
506: a35 := JTF_VARCHAR2_TABLE_200();
507: a36 := JTF_VARCHAR2_TABLE_100();
508: else
509: a0 := JTF_NUMBER_TABLE();
510: a1 := JTF_NUMBER_TABLE();
511: a2 := JTF_DATE_TABLE();
512: a3 := JTF_NUMBER_TABLE();
513: a4 := JTF_DATE_TABLE();
506: a35 := JTF_VARCHAR2_TABLE_200();
507: a36 := JTF_VARCHAR2_TABLE_100();
508: else
509: a0 := JTF_NUMBER_TABLE();
510: a1 := JTF_NUMBER_TABLE();
511: a2 := JTF_DATE_TABLE();
512: a3 := JTF_NUMBER_TABLE();
513: a4 := JTF_DATE_TABLE();
514: a5 := JTF_NUMBER_TABLE();
508: else
509: a0 := JTF_NUMBER_TABLE();
510: a1 := JTF_NUMBER_TABLE();
511: a2 := JTF_DATE_TABLE();
512: a3 := JTF_NUMBER_TABLE();
513: a4 := JTF_DATE_TABLE();
514: a5 := JTF_NUMBER_TABLE();
515: a6 := JTF_NUMBER_TABLE();
516: a7 := JTF_NUMBER_TABLE();
510: a1 := JTF_NUMBER_TABLE();
511: a2 := JTF_DATE_TABLE();
512: a3 := JTF_NUMBER_TABLE();
513: a4 := JTF_DATE_TABLE();
514: a5 := JTF_NUMBER_TABLE();
515: a6 := JTF_NUMBER_TABLE();
516: a7 := JTF_NUMBER_TABLE();
517: a8 := JTF_VARCHAR2_TABLE_100();
518: a9 := JTF_VARCHAR2_TABLE_100();
511: a2 := JTF_DATE_TABLE();
512: a3 := JTF_NUMBER_TABLE();
513: a4 := JTF_DATE_TABLE();
514: a5 := JTF_NUMBER_TABLE();
515: a6 := JTF_NUMBER_TABLE();
516: a7 := JTF_NUMBER_TABLE();
517: a8 := JTF_VARCHAR2_TABLE_100();
518: a9 := JTF_VARCHAR2_TABLE_100();
519: a10 := JTF_NUMBER_TABLE();
512: a3 := JTF_NUMBER_TABLE();
513: a4 := JTF_DATE_TABLE();
514: a5 := JTF_NUMBER_TABLE();
515: a6 := JTF_NUMBER_TABLE();
516: a7 := JTF_NUMBER_TABLE();
517: a8 := JTF_VARCHAR2_TABLE_100();
518: a9 := JTF_VARCHAR2_TABLE_100();
519: a10 := JTF_NUMBER_TABLE();
520: a11 := JTF_VARCHAR2_TABLE_100();
515: a6 := JTF_NUMBER_TABLE();
516: a7 := JTF_NUMBER_TABLE();
517: a8 := JTF_VARCHAR2_TABLE_100();
518: a9 := JTF_VARCHAR2_TABLE_100();
519: a10 := JTF_NUMBER_TABLE();
520: a11 := JTF_VARCHAR2_TABLE_100();
521: a12 := JTF_VARCHAR2_TABLE_100();
522: a13 := JTF_NUMBER_TABLE();
523: a14 := JTF_VARCHAR2_TABLE_100();
518: a9 := JTF_VARCHAR2_TABLE_100();
519: a10 := JTF_NUMBER_TABLE();
520: a11 := JTF_VARCHAR2_TABLE_100();
521: a12 := JTF_VARCHAR2_TABLE_100();
522: a13 := JTF_NUMBER_TABLE();
523: a14 := JTF_VARCHAR2_TABLE_100();
524: a15 := JTF_VARCHAR2_TABLE_100();
525: a16 := JTF_VARCHAR2_TABLE_100();
526: a17 := JTF_VARCHAR2_TABLE_100();
630: end if;
631: end if;
632: end rosetta_table_copy_out_p4;
633:
634: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mc_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE
635: , a1 JTF_NUMBER_TABLE
636: , a2 JTF_DATE_TABLE
637: , a3 JTF_NUMBER_TABLE
638: , a4 JTF_DATE_TABLE
631: end if;
632: end rosetta_table_copy_out_p4;
633:
634: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mc_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE
635: , a1 JTF_NUMBER_TABLE
636: , a2 JTF_DATE_TABLE
637: , a3 JTF_NUMBER_TABLE
638: , a4 JTF_DATE_TABLE
639: , a5 JTF_NUMBER_TABLE
633:
634: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mc_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE
635: , a1 JTF_NUMBER_TABLE
636: , a2 JTF_DATE_TABLE
637: , a3 JTF_NUMBER_TABLE
638: , a4 JTF_DATE_TABLE
639: , a5 JTF_NUMBER_TABLE
640: , a6 JTF_NUMBER_TABLE
641: , a7 JTF_NUMBER_TABLE
635: , a1 JTF_NUMBER_TABLE
636: , a2 JTF_DATE_TABLE
637: , a3 JTF_NUMBER_TABLE
638: , a4 JTF_DATE_TABLE
639: , a5 JTF_NUMBER_TABLE
640: , a6 JTF_NUMBER_TABLE
641: , a7 JTF_NUMBER_TABLE
642: , a8 JTF_VARCHAR2_TABLE_100
643: , a9 JTF_VARCHAR2_TABLE_100
636: , a2 JTF_DATE_TABLE
637: , a3 JTF_NUMBER_TABLE
638: , a4 JTF_DATE_TABLE
639: , a5 JTF_NUMBER_TABLE
640: , a6 JTF_NUMBER_TABLE
641: , a7 JTF_NUMBER_TABLE
642: , a8 JTF_VARCHAR2_TABLE_100
643: , a9 JTF_VARCHAR2_TABLE_100
644: , a10 JTF_VARCHAR2_TABLE_100
637: , a3 JTF_NUMBER_TABLE
638: , a4 JTF_DATE_TABLE
639: , a5 JTF_NUMBER_TABLE
640: , a6 JTF_NUMBER_TABLE
641: , a7 JTF_NUMBER_TABLE
642: , a8 JTF_VARCHAR2_TABLE_100
643: , a9 JTF_VARCHAR2_TABLE_100
644: , a10 JTF_VARCHAR2_TABLE_100
645: , a11 JTF_VARCHAR2_TABLE_100
713: end loop;
714: end if;
715: end if;
716: end rosetta_table_copy_in_p5;
717: procedure rosetta_table_copy_out_p5(t ahl_mc_rule_pvt.rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
718: , a1 out nocopy JTF_NUMBER_TABLE
719: , a2 out nocopy JTF_DATE_TABLE
720: , a3 out nocopy JTF_NUMBER_TABLE
721: , a4 out nocopy JTF_DATE_TABLE
714: end if;
715: end if;
716: end rosetta_table_copy_in_p5;
717: procedure rosetta_table_copy_out_p5(t ahl_mc_rule_pvt.rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
718: , a1 out nocopy JTF_NUMBER_TABLE
719: , a2 out nocopy JTF_DATE_TABLE
720: , a3 out nocopy JTF_NUMBER_TABLE
721: , a4 out nocopy JTF_DATE_TABLE
722: , a5 out nocopy JTF_NUMBER_TABLE
716: end rosetta_table_copy_in_p5;
717: procedure rosetta_table_copy_out_p5(t ahl_mc_rule_pvt.rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
718: , a1 out nocopy JTF_NUMBER_TABLE
719: , a2 out nocopy JTF_DATE_TABLE
720: , a3 out nocopy JTF_NUMBER_TABLE
721: , a4 out nocopy JTF_DATE_TABLE
722: , a5 out nocopy JTF_NUMBER_TABLE
723: , a6 out nocopy JTF_NUMBER_TABLE
724: , a7 out nocopy JTF_NUMBER_TABLE
718: , a1 out nocopy JTF_NUMBER_TABLE
719: , a2 out nocopy JTF_DATE_TABLE
720: , a3 out nocopy JTF_NUMBER_TABLE
721: , a4 out nocopy JTF_DATE_TABLE
722: , a5 out nocopy JTF_NUMBER_TABLE
723: , a6 out nocopy JTF_NUMBER_TABLE
724: , a7 out nocopy JTF_NUMBER_TABLE
725: , a8 out nocopy JTF_VARCHAR2_TABLE_100
726: , a9 out nocopy JTF_VARCHAR2_TABLE_100
719: , a2 out nocopy JTF_DATE_TABLE
720: , a3 out nocopy JTF_NUMBER_TABLE
721: , a4 out nocopy JTF_DATE_TABLE
722: , a5 out nocopy JTF_NUMBER_TABLE
723: , a6 out nocopy JTF_NUMBER_TABLE
724: , a7 out nocopy JTF_NUMBER_TABLE
725: , a8 out nocopy JTF_VARCHAR2_TABLE_100
726: , a9 out nocopy JTF_VARCHAR2_TABLE_100
727: , a10 out nocopy JTF_VARCHAR2_TABLE_100
720: , a3 out nocopy JTF_NUMBER_TABLE
721: , a4 out nocopy JTF_DATE_TABLE
722: , a5 out nocopy JTF_NUMBER_TABLE
723: , a6 out nocopy JTF_NUMBER_TABLE
724: , a7 out nocopy JTF_NUMBER_TABLE
725: , a8 out nocopy JTF_VARCHAR2_TABLE_100
726: , a9 out nocopy JTF_VARCHAR2_TABLE_100
727: , a10 out nocopy JTF_VARCHAR2_TABLE_100
728: , a11 out nocopy JTF_VARCHAR2_TABLE_100
750: ) as
751: ddindx binary_integer; indx binary_integer;
752: begin
753: if t is null or t.count = 0 then
754: a0 := JTF_NUMBER_TABLE();
755: a1 := JTF_NUMBER_TABLE();
756: a2 := JTF_DATE_TABLE();
757: a3 := JTF_NUMBER_TABLE();
758: a4 := JTF_DATE_TABLE();
751: ddindx binary_integer; indx binary_integer;
752: begin
753: if t is null or t.count = 0 then
754: a0 := JTF_NUMBER_TABLE();
755: a1 := JTF_NUMBER_TABLE();
756: a2 := JTF_DATE_TABLE();
757: a3 := JTF_NUMBER_TABLE();
758: a4 := JTF_DATE_TABLE();
759: a5 := JTF_NUMBER_TABLE();
753: if t is null or t.count = 0 then
754: a0 := JTF_NUMBER_TABLE();
755: a1 := JTF_NUMBER_TABLE();
756: a2 := JTF_DATE_TABLE();
757: a3 := JTF_NUMBER_TABLE();
758: a4 := JTF_DATE_TABLE();
759: a5 := JTF_NUMBER_TABLE();
760: a6 := JTF_NUMBER_TABLE();
761: a7 := JTF_NUMBER_TABLE();
755: a1 := JTF_NUMBER_TABLE();
756: a2 := JTF_DATE_TABLE();
757: a3 := JTF_NUMBER_TABLE();
758: a4 := JTF_DATE_TABLE();
759: a5 := JTF_NUMBER_TABLE();
760: a6 := JTF_NUMBER_TABLE();
761: a7 := JTF_NUMBER_TABLE();
762: a8 := JTF_VARCHAR2_TABLE_100();
763: a9 := JTF_VARCHAR2_TABLE_100();
756: a2 := JTF_DATE_TABLE();
757: a3 := JTF_NUMBER_TABLE();
758: a4 := JTF_DATE_TABLE();
759: a5 := JTF_NUMBER_TABLE();
760: a6 := JTF_NUMBER_TABLE();
761: a7 := JTF_NUMBER_TABLE();
762: a8 := JTF_VARCHAR2_TABLE_100();
763: a9 := JTF_VARCHAR2_TABLE_100();
764: a10 := JTF_VARCHAR2_TABLE_100();
757: a3 := JTF_NUMBER_TABLE();
758: a4 := JTF_DATE_TABLE();
759: a5 := JTF_NUMBER_TABLE();
760: a6 := JTF_NUMBER_TABLE();
761: a7 := JTF_NUMBER_TABLE();
762: a8 := JTF_VARCHAR2_TABLE_100();
763: a9 := JTF_VARCHAR2_TABLE_100();
764: a10 := JTF_VARCHAR2_TABLE_100();
765: a11 := JTF_VARCHAR2_TABLE_100();
784: a30 := JTF_VARCHAR2_TABLE_200();
785: a31 := JTF_VARCHAR2_TABLE_200();
786: a32 := JTF_VARCHAR2_TABLE_100();
787: else
788: a0 := JTF_NUMBER_TABLE();
789: a1 := JTF_NUMBER_TABLE();
790: a2 := JTF_DATE_TABLE();
791: a3 := JTF_NUMBER_TABLE();
792: a4 := JTF_DATE_TABLE();
785: a31 := JTF_VARCHAR2_TABLE_200();
786: a32 := JTF_VARCHAR2_TABLE_100();
787: else
788: a0 := JTF_NUMBER_TABLE();
789: a1 := JTF_NUMBER_TABLE();
790: a2 := JTF_DATE_TABLE();
791: a3 := JTF_NUMBER_TABLE();
792: a4 := JTF_DATE_TABLE();
793: a5 := JTF_NUMBER_TABLE();
787: else
788: a0 := JTF_NUMBER_TABLE();
789: a1 := JTF_NUMBER_TABLE();
790: a2 := JTF_DATE_TABLE();
791: a3 := JTF_NUMBER_TABLE();
792: a4 := JTF_DATE_TABLE();
793: a5 := JTF_NUMBER_TABLE();
794: a6 := JTF_NUMBER_TABLE();
795: a7 := JTF_NUMBER_TABLE();
789: a1 := JTF_NUMBER_TABLE();
790: a2 := JTF_DATE_TABLE();
791: a3 := JTF_NUMBER_TABLE();
792: a4 := JTF_DATE_TABLE();
793: a5 := JTF_NUMBER_TABLE();
794: a6 := JTF_NUMBER_TABLE();
795: a7 := JTF_NUMBER_TABLE();
796: a8 := JTF_VARCHAR2_TABLE_100();
797: a9 := JTF_VARCHAR2_TABLE_100();
790: a2 := JTF_DATE_TABLE();
791: a3 := JTF_NUMBER_TABLE();
792: a4 := JTF_DATE_TABLE();
793: a5 := JTF_NUMBER_TABLE();
794: a6 := JTF_NUMBER_TABLE();
795: a7 := JTF_NUMBER_TABLE();
796: a8 := JTF_VARCHAR2_TABLE_100();
797: a9 := JTF_VARCHAR2_TABLE_100();
798: a10 := JTF_VARCHAR2_TABLE_100();
791: a3 := JTF_NUMBER_TABLE();
792: a4 := JTF_DATE_TABLE();
793: a5 := JTF_NUMBER_TABLE();
794: a6 := JTF_NUMBER_TABLE();
795: a7 := JTF_NUMBER_TABLE();
796: a8 := JTF_VARCHAR2_TABLE_100();
797: a9 := JTF_VARCHAR2_TABLE_100();
798: a10 := JTF_VARCHAR2_TABLE_100();
799: a11 := JTF_VARCHAR2_TABLE_100();
905: , x_return_status out nocopy VARCHAR2
906: , x_msg_count out nocopy NUMBER
907: , x_msg_data out nocopy VARCHAR2
908: , p_rule_id NUMBER
909: , p8_a0 out nocopy JTF_NUMBER_TABLE
910: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
911: , p8_a2 out nocopy JTF_NUMBER_TABLE
912: , p8_a3 out nocopy JTF_NUMBER_TABLE
913: , p8_a4 out nocopy JTF_NUMBER_TABLE
907: , x_msg_data out nocopy VARCHAR2
908: , p_rule_id NUMBER
909: , p8_a0 out nocopy JTF_NUMBER_TABLE
910: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
911: , p8_a2 out nocopy JTF_NUMBER_TABLE
912: , p8_a3 out nocopy JTF_NUMBER_TABLE
913: , p8_a4 out nocopy JTF_NUMBER_TABLE
914: , p8_a5 out nocopy JTF_NUMBER_TABLE
915: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
908: , p_rule_id NUMBER
909: , p8_a0 out nocopy JTF_NUMBER_TABLE
910: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
911: , p8_a2 out nocopy JTF_NUMBER_TABLE
912: , p8_a3 out nocopy JTF_NUMBER_TABLE
913: , p8_a4 out nocopy JTF_NUMBER_TABLE
914: , p8_a5 out nocopy JTF_NUMBER_TABLE
915: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
916: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
909: , p8_a0 out nocopy JTF_NUMBER_TABLE
910: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
911: , p8_a2 out nocopy JTF_NUMBER_TABLE
912: , p8_a3 out nocopy JTF_NUMBER_TABLE
913: , p8_a4 out nocopy JTF_NUMBER_TABLE
914: , p8_a5 out nocopy JTF_NUMBER_TABLE
915: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
916: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
917: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
910: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
911: , p8_a2 out nocopy JTF_NUMBER_TABLE
912: , p8_a3 out nocopy JTF_NUMBER_TABLE
913: , p8_a4 out nocopy JTF_NUMBER_TABLE
914: , p8_a5 out nocopy JTF_NUMBER_TABLE
915: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
916: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
917: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
918: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
916: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
917: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
918: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
919: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
920: , p8_a11 out nocopy JTF_NUMBER_TABLE
921: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
922: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
923: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
924: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
927: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
928: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
929: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
930: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
931: , p8_a22 out nocopy JTF_NUMBER_TABLE
932: , p8_a23 out nocopy JTF_NUMBER_TABLE
933: , p8_a24 out nocopy JTF_NUMBER_TABLE
934: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_100
935: , p8_a26 out nocopy JTF_VARCHAR2_TABLE_200
928: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
929: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
930: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
931: , p8_a22 out nocopy JTF_NUMBER_TABLE
932: , p8_a23 out nocopy JTF_NUMBER_TABLE
933: , p8_a24 out nocopy JTF_NUMBER_TABLE
934: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_100
935: , p8_a26 out nocopy JTF_VARCHAR2_TABLE_200
936: , p8_a27 out nocopy JTF_VARCHAR2_TABLE_200
929: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
930: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
931: , p8_a22 out nocopy JTF_NUMBER_TABLE
932: , p8_a23 out nocopy JTF_NUMBER_TABLE
933: , p8_a24 out nocopy JTF_NUMBER_TABLE
934: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_100
935: , p8_a26 out nocopy JTF_VARCHAR2_TABLE_200
936: , p8_a27 out nocopy JTF_VARCHAR2_TABLE_200
937: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_200
1035: , x_return_status out nocopy VARCHAR2
1036: , x_msg_count out nocopy NUMBER
1037: , x_msg_data out nocopy VARCHAR2
1038: , p_module VARCHAR2
1039: , p8_a0 JTF_NUMBER_TABLE
1040: , p8_a1 JTF_VARCHAR2_TABLE_100
1041: , p8_a2 JTF_NUMBER_TABLE
1042: , p8_a3 JTF_NUMBER_TABLE
1043: , p8_a4 JTF_NUMBER_TABLE
1037: , x_msg_data out nocopy VARCHAR2
1038: , p_module VARCHAR2
1039: , p8_a0 JTF_NUMBER_TABLE
1040: , p8_a1 JTF_VARCHAR2_TABLE_100
1041: , p8_a2 JTF_NUMBER_TABLE
1042: , p8_a3 JTF_NUMBER_TABLE
1043: , p8_a4 JTF_NUMBER_TABLE
1044: , p8_a5 JTF_NUMBER_TABLE
1045: , p8_a6 JTF_VARCHAR2_TABLE_100
1038: , p_module VARCHAR2
1039: , p8_a0 JTF_NUMBER_TABLE
1040: , p8_a1 JTF_VARCHAR2_TABLE_100
1041: , p8_a2 JTF_NUMBER_TABLE
1042: , p8_a3 JTF_NUMBER_TABLE
1043: , p8_a4 JTF_NUMBER_TABLE
1044: , p8_a5 JTF_NUMBER_TABLE
1045: , p8_a6 JTF_VARCHAR2_TABLE_100
1046: , p8_a7 JTF_VARCHAR2_TABLE_100
1039: , p8_a0 JTF_NUMBER_TABLE
1040: , p8_a1 JTF_VARCHAR2_TABLE_100
1041: , p8_a2 JTF_NUMBER_TABLE
1042: , p8_a3 JTF_NUMBER_TABLE
1043: , p8_a4 JTF_NUMBER_TABLE
1044: , p8_a5 JTF_NUMBER_TABLE
1045: , p8_a6 JTF_VARCHAR2_TABLE_100
1046: , p8_a7 JTF_VARCHAR2_TABLE_100
1047: , p8_a8 JTF_VARCHAR2_TABLE_100
1040: , p8_a1 JTF_VARCHAR2_TABLE_100
1041: , p8_a2 JTF_NUMBER_TABLE
1042: , p8_a3 JTF_NUMBER_TABLE
1043: , p8_a4 JTF_NUMBER_TABLE
1044: , p8_a5 JTF_NUMBER_TABLE
1045: , p8_a6 JTF_VARCHAR2_TABLE_100
1046: , p8_a7 JTF_VARCHAR2_TABLE_100
1047: , p8_a8 JTF_VARCHAR2_TABLE_100
1048: , p8_a9 JTF_VARCHAR2_TABLE_100
1046: , p8_a7 JTF_VARCHAR2_TABLE_100
1047: , p8_a8 JTF_VARCHAR2_TABLE_100
1048: , p8_a9 JTF_VARCHAR2_TABLE_100
1049: , p8_a10 JTF_VARCHAR2_TABLE_100
1050: , p8_a11 JTF_NUMBER_TABLE
1051: , p8_a12 JTF_VARCHAR2_TABLE_100
1052: , p8_a13 JTF_VARCHAR2_TABLE_100
1053: , p8_a14 JTF_VARCHAR2_TABLE_100
1054: , p8_a15 JTF_VARCHAR2_TABLE_100
1057: , p8_a18 JTF_VARCHAR2_TABLE_100
1058: , p8_a19 JTF_VARCHAR2_TABLE_100
1059: , p8_a20 JTF_VARCHAR2_TABLE_100
1060: , p8_a21 JTF_VARCHAR2_TABLE_100
1061: , p8_a22 JTF_NUMBER_TABLE
1062: , p8_a23 JTF_NUMBER_TABLE
1063: , p8_a24 JTF_NUMBER_TABLE
1064: , p8_a25 JTF_VARCHAR2_TABLE_100
1065: , p8_a26 JTF_VARCHAR2_TABLE_200
1058: , p8_a19 JTF_VARCHAR2_TABLE_100
1059: , p8_a20 JTF_VARCHAR2_TABLE_100
1060: , p8_a21 JTF_VARCHAR2_TABLE_100
1061: , p8_a22 JTF_NUMBER_TABLE
1062: , p8_a23 JTF_NUMBER_TABLE
1063: , p8_a24 JTF_NUMBER_TABLE
1064: , p8_a25 JTF_VARCHAR2_TABLE_100
1065: , p8_a26 JTF_VARCHAR2_TABLE_200
1066: , p8_a27 JTF_VARCHAR2_TABLE_200
1059: , p8_a20 JTF_VARCHAR2_TABLE_100
1060: , p8_a21 JTF_VARCHAR2_TABLE_100
1061: , p8_a22 JTF_NUMBER_TABLE
1062: , p8_a23 JTF_NUMBER_TABLE
1063: , p8_a24 JTF_NUMBER_TABLE
1064: , p8_a25 JTF_VARCHAR2_TABLE_100
1065: , p8_a26 JTF_VARCHAR2_TABLE_200
1066: , p8_a27 JTF_VARCHAR2_TABLE_200
1067: , p8_a28 JTF_VARCHAR2_TABLE_200
1301: , p8_a29 VARCHAR2
1302: , p8_a30 VARCHAR2
1303: , p8_a31 VARCHAR2
1304: , p8_a32 VARCHAR2
1305: , p9_a0 JTF_NUMBER_TABLE
1306: , p9_a1 JTF_VARCHAR2_TABLE_100
1307: , p9_a2 JTF_NUMBER_TABLE
1308: , p9_a3 JTF_NUMBER_TABLE
1309: , p9_a4 JTF_NUMBER_TABLE
1303: , p8_a31 VARCHAR2
1304: , p8_a32 VARCHAR2
1305: , p9_a0 JTF_NUMBER_TABLE
1306: , p9_a1 JTF_VARCHAR2_TABLE_100
1307: , p9_a2 JTF_NUMBER_TABLE
1308: , p9_a3 JTF_NUMBER_TABLE
1309: , p9_a4 JTF_NUMBER_TABLE
1310: , p9_a5 JTF_NUMBER_TABLE
1311: , p9_a6 JTF_VARCHAR2_TABLE_100
1304: , p8_a32 VARCHAR2
1305: , p9_a0 JTF_NUMBER_TABLE
1306: , p9_a1 JTF_VARCHAR2_TABLE_100
1307: , p9_a2 JTF_NUMBER_TABLE
1308: , p9_a3 JTF_NUMBER_TABLE
1309: , p9_a4 JTF_NUMBER_TABLE
1310: , p9_a5 JTF_NUMBER_TABLE
1311: , p9_a6 JTF_VARCHAR2_TABLE_100
1312: , p9_a7 JTF_VARCHAR2_TABLE_100
1305: , p9_a0 JTF_NUMBER_TABLE
1306: , p9_a1 JTF_VARCHAR2_TABLE_100
1307: , p9_a2 JTF_NUMBER_TABLE
1308: , p9_a3 JTF_NUMBER_TABLE
1309: , p9_a4 JTF_NUMBER_TABLE
1310: , p9_a5 JTF_NUMBER_TABLE
1311: , p9_a6 JTF_VARCHAR2_TABLE_100
1312: , p9_a7 JTF_VARCHAR2_TABLE_100
1313: , p9_a8 JTF_VARCHAR2_TABLE_100
1306: , p9_a1 JTF_VARCHAR2_TABLE_100
1307: , p9_a2 JTF_NUMBER_TABLE
1308: , p9_a3 JTF_NUMBER_TABLE
1309: , p9_a4 JTF_NUMBER_TABLE
1310: , p9_a5 JTF_NUMBER_TABLE
1311: , p9_a6 JTF_VARCHAR2_TABLE_100
1312: , p9_a7 JTF_VARCHAR2_TABLE_100
1313: , p9_a8 JTF_VARCHAR2_TABLE_100
1314: , p9_a9 JTF_VARCHAR2_TABLE_100
1312: , p9_a7 JTF_VARCHAR2_TABLE_100
1313: , p9_a8 JTF_VARCHAR2_TABLE_100
1314: , p9_a9 JTF_VARCHAR2_TABLE_100
1315: , p9_a10 JTF_VARCHAR2_TABLE_100
1316: , p9_a11 JTF_NUMBER_TABLE
1317: , p9_a12 JTF_VARCHAR2_TABLE_100
1318: , p9_a13 JTF_VARCHAR2_TABLE_100
1319: , p9_a14 JTF_VARCHAR2_TABLE_100
1320: , p9_a15 JTF_VARCHAR2_TABLE_100
1323: , p9_a18 JTF_VARCHAR2_TABLE_100
1324: , p9_a19 JTF_VARCHAR2_TABLE_100
1325: , p9_a20 JTF_VARCHAR2_TABLE_100
1326: , p9_a21 JTF_VARCHAR2_TABLE_100
1327: , p9_a22 JTF_NUMBER_TABLE
1328: , p9_a23 JTF_NUMBER_TABLE
1329: , p9_a24 JTF_NUMBER_TABLE
1330: , p9_a25 JTF_VARCHAR2_TABLE_100
1331: , p9_a26 JTF_VARCHAR2_TABLE_200
1324: , p9_a19 JTF_VARCHAR2_TABLE_100
1325: , p9_a20 JTF_VARCHAR2_TABLE_100
1326: , p9_a21 JTF_VARCHAR2_TABLE_100
1327: , p9_a22 JTF_NUMBER_TABLE
1328: , p9_a23 JTF_NUMBER_TABLE
1329: , p9_a24 JTF_NUMBER_TABLE
1330: , p9_a25 JTF_VARCHAR2_TABLE_100
1331: , p9_a26 JTF_VARCHAR2_TABLE_200
1332: , p9_a27 JTF_VARCHAR2_TABLE_200
1325: , p9_a20 JTF_VARCHAR2_TABLE_100
1326: , p9_a21 JTF_VARCHAR2_TABLE_100
1327: , p9_a22 JTF_NUMBER_TABLE
1328: , p9_a23 JTF_NUMBER_TABLE
1329: , p9_a24 JTF_NUMBER_TABLE
1330: , p9_a25 JTF_VARCHAR2_TABLE_100
1331: , p9_a26 JTF_VARCHAR2_TABLE_200
1332: , p9_a27 JTF_VARCHAR2_TABLE_200
1333: , p9_a28 JTF_VARCHAR2_TABLE_200
1578: , x_msg_count out nocopy NUMBER
1579: , x_msg_data out nocopy VARCHAR2
1580: , p_mc_header_id NUMBER
1581: , p_encoded_path VARCHAR2
1582: , p9_a0 out nocopy JTF_NUMBER_TABLE
1583: , p9_a1 out nocopy JTF_NUMBER_TABLE
1584: , p9_a2 out nocopy JTF_DATE_TABLE
1585: , p9_a3 out nocopy JTF_NUMBER_TABLE
1586: , p9_a4 out nocopy JTF_DATE_TABLE
1579: , x_msg_data out nocopy VARCHAR2
1580: , p_mc_header_id NUMBER
1581: , p_encoded_path VARCHAR2
1582: , p9_a0 out nocopy JTF_NUMBER_TABLE
1583: , p9_a1 out nocopy JTF_NUMBER_TABLE
1584: , p9_a2 out nocopy JTF_DATE_TABLE
1585: , p9_a3 out nocopy JTF_NUMBER_TABLE
1586: , p9_a4 out nocopy JTF_DATE_TABLE
1587: , p9_a5 out nocopy JTF_NUMBER_TABLE
1581: , p_encoded_path VARCHAR2
1582: , p9_a0 out nocopy JTF_NUMBER_TABLE
1583: , p9_a1 out nocopy JTF_NUMBER_TABLE
1584: , p9_a2 out nocopy JTF_DATE_TABLE
1585: , p9_a3 out nocopy JTF_NUMBER_TABLE
1586: , p9_a4 out nocopy JTF_DATE_TABLE
1587: , p9_a5 out nocopy JTF_NUMBER_TABLE
1588: , p9_a6 out nocopy JTF_NUMBER_TABLE
1589: , p9_a7 out nocopy JTF_NUMBER_TABLE
1583: , p9_a1 out nocopy JTF_NUMBER_TABLE
1584: , p9_a2 out nocopy JTF_DATE_TABLE
1585: , p9_a3 out nocopy JTF_NUMBER_TABLE
1586: , p9_a4 out nocopy JTF_DATE_TABLE
1587: , p9_a5 out nocopy JTF_NUMBER_TABLE
1588: , p9_a6 out nocopy JTF_NUMBER_TABLE
1589: , p9_a7 out nocopy JTF_NUMBER_TABLE
1590: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1591: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
1584: , p9_a2 out nocopy JTF_DATE_TABLE
1585: , p9_a3 out nocopy JTF_NUMBER_TABLE
1586: , p9_a4 out nocopy JTF_DATE_TABLE
1587: , p9_a5 out nocopy JTF_NUMBER_TABLE
1588: , p9_a6 out nocopy JTF_NUMBER_TABLE
1589: , p9_a7 out nocopy JTF_NUMBER_TABLE
1590: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1591: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
1592: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
1585: , p9_a3 out nocopy JTF_NUMBER_TABLE
1586: , p9_a4 out nocopy JTF_DATE_TABLE
1587: , p9_a5 out nocopy JTF_NUMBER_TABLE
1588: , p9_a6 out nocopy JTF_NUMBER_TABLE
1589: , p9_a7 out nocopy JTF_NUMBER_TABLE
1590: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1591: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
1592: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
1593: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100