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_p1(t out nocopy ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_VARCHAR2_TABLE_200
41: , a25 JTF_VARCHAR2_TABLE_200
42: , a26 JTF_VARCHAR2_TABLE_200
43: , a27 JTF_DATE_TABLE
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_DATE_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_200
43: , a27 JTF_DATE_TABLE
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_DATE_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: ) as
50: ddindx binary_integer; indx binary_integer;
43: , a27 JTF_DATE_TABLE
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_DATE_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
95: end loop;
96: end if;
97: end if;
98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
96: end if;
97: end if;
98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , a7 out nocopy JTF_DATE_TABLE
107: , a8 out nocopy JTF_DATE_TABLE
108: , a9 out nocopy JTF_VARCHAR2_TABLE_100
123: , a24 out nocopy JTF_VARCHAR2_TABLE_200
124: , a25 out nocopy JTF_VARCHAR2_TABLE_200
125: , a26 out nocopy JTF_VARCHAR2_TABLE_200
126: , a27 out nocopy JTF_DATE_TABLE
127: , a28 out nocopy JTF_NUMBER_TABLE
128: , a29 out nocopy JTF_DATE_TABLE
129: , a30 out nocopy JTF_NUMBER_TABLE
130: , a31 out nocopy JTF_NUMBER_TABLE
131: , a32 out nocopy JTF_VARCHAR2_TABLE_100
125: , a26 out nocopy JTF_VARCHAR2_TABLE_200
126: , a27 out nocopy JTF_DATE_TABLE
127: , a28 out nocopy JTF_NUMBER_TABLE
128: , a29 out nocopy JTF_DATE_TABLE
129: , a30 out nocopy JTF_NUMBER_TABLE
130: , a31 out nocopy JTF_NUMBER_TABLE
131: , a32 out nocopy JTF_VARCHAR2_TABLE_100
132: ) as
133: ddindx binary_integer; indx binary_integer;
126: , a27 out nocopy JTF_DATE_TABLE
127: , a28 out nocopy JTF_NUMBER_TABLE
128: , a29 out nocopy JTF_DATE_TABLE
129: , a30 out nocopy JTF_NUMBER_TABLE
130: , a31 out nocopy JTF_NUMBER_TABLE
131: , a32 out nocopy JTF_VARCHAR2_TABLE_100
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_DATE_TABLE();
144: a8 := JTF_DATE_TABLE();
145: a9 := JTF_VARCHAR2_TABLE_100();
160: a24 := JTF_VARCHAR2_TABLE_200();
161: a25 := JTF_VARCHAR2_TABLE_200();
162: a26 := JTF_VARCHAR2_TABLE_200();
163: a27 := JTF_DATE_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_VARCHAR2_TABLE_100();
162: a26 := JTF_VARCHAR2_TABLE_200();
163: a27 := JTF_DATE_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
163: a27 := JTF_DATE_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
179: a9 := JTF_VARCHAR2_TABLE_100();
194: a24 := JTF_VARCHAR2_TABLE_200();
195: a25 := JTF_VARCHAR2_TABLE_200();
196: a26 := JTF_VARCHAR2_TABLE_200();
197: a27 := JTF_DATE_TABLE();
198: a28 := JTF_NUMBER_TABLE();
199: a29 := JTF_DATE_TABLE();
200: a30 := JTF_NUMBER_TABLE();
201: a31 := JTF_NUMBER_TABLE();
202: a32 := JTF_VARCHAR2_TABLE_100();
196: a26 := JTF_VARCHAR2_TABLE_200();
197: a27 := JTF_DATE_TABLE();
198: a28 := JTF_NUMBER_TABLE();
199: a29 := JTF_DATE_TABLE();
200: a30 := JTF_NUMBER_TABLE();
201: a31 := JTF_NUMBER_TABLE();
202: a32 := JTF_VARCHAR2_TABLE_100();
203: if t.count > 0 then
204: a0.extend(t.count);
197: a27 := JTF_DATE_TABLE();
198: a28 := JTF_NUMBER_TABLE();
199: a29 := JTF_DATE_TABLE();
200: a30 := JTF_NUMBER_TABLE();
201: a31 := JTF_NUMBER_TABLE();
202: a32 := JTF_VARCHAR2_TABLE_100();
203: if t.count > 0 then
204: a0.extend(t.count);
205: a1.extend(t.count);
279: end if;
280: end if;
281: end rosetta_table_copy_out_p1;
282:
283: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 JTF_NUMBER_TABLE
284: , a1 JTF_NUMBER_TABLE
285: , a2 JTF_VARCHAR2_TABLE_100
286: , a3 JTF_VARCHAR2_TABLE_100
287: , a4 JTF_NUMBER_TABLE
280: end if;
281: end rosetta_table_copy_out_p1;
282:
283: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 JTF_NUMBER_TABLE
284: , a1 JTF_NUMBER_TABLE
285: , a2 JTF_VARCHAR2_TABLE_100
286: , a3 JTF_VARCHAR2_TABLE_100
287: , a4 JTF_NUMBER_TABLE
288: , a5 JTF_VARCHAR2_TABLE_400
283: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 JTF_NUMBER_TABLE
284: , a1 JTF_NUMBER_TABLE
285: , a2 JTF_VARCHAR2_TABLE_100
286: , a3 JTF_VARCHAR2_TABLE_100
287: , a4 JTF_NUMBER_TABLE
288: , a5 JTF_VARCHAR2_TABLE_400
289: , a6 JTF_VARCHAR2_TABLE_100
290: , a7 JTF_VARCHAR2_TABLE_100
291: , a8 JTF_VARCHAR2_TABLE_100
307: , a24 JTF_VARCHAR2_TABLE_200
308: , a25 JTF_VARCHAR2_TABLE_200
309: , a26 JTF_VARCHAR2_TABLE_200
310: , a27 JTF_DATE_TABLE
311: , a28 JTF_NUMBER_TABLE
312: , a29 JTF_DATE_TABLE
313: , a30 JTF_NUMBER_TABLE
314: , a31 JTF_NUMBER_TABLE
315: , a32 JTF_VARCHAR2_TABLE_100
309: , a26 JTF_VARCHAR2_TABLE_200
310: , a27 JTF_DATE_TABLE
311: , a28 JTF_NUMBER_TABLE
312: , a29 JTF_DATE_TABLE
313: , a30 JTF_NUMBER_TABLE
314: , a31 JTF_NUMBER_TABLE
315: , a32 JTF_VARCHAR2_TABLE_100
316: ) as
317: ddindx binary_integer; indx binary_integer;
310: , a27 JTF_DATE_TABLE
311: , a28 JTF_NUMBER_TABLE
312: , a29 JTF_DATE_TABLE
313: , a30 JTF_NUMBER_TABLE
314: , a31 JTF_NUMBER_TABLE
315: , a32 JTF_VARCHAR2_TABLE_100
316: ) as
317: ddindx binary_integer; indx binary_integer;
318: begin
362: end loop;
363: end if;
364: end if;
365: end rosetta_table_copy_in_p3;
366: procedure rosetta_table_copy_out_p3(t ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , a4 out nocopy JTF_NUMBER_TABLE
363: end if;
364: end if;
365: end rosetta_table_copy_in_p3;
366: procedure rosetta_table_copy_out_p3(t ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , a4 out nocopy JTF_NUMBER_TABLE
371: , a5 out nocopy JTF_VARCHAR2_TABLE_400
366: procedure rosetta_table_copy_out_p3(t ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , a4 out nocopy JTF_NUMBER_TABLE
371: , a5 out nocopy JTF_VARCHAR2_TABLE_400
372: , a6 out nocopy JTF_VARCHAR2_TABLE_100
373: , a7 out nocopy JTF_VARCHAR2_TABLE_100
374: , a8 out nocopy JTF_VARCHAR2_TABLE_100
390: , a24 out nocopy JTF_VARCHAR2_TABLE_200
391: , a25 out nocopy JTF_VARCHAR2_TABLE_200
392: , a26 out nocopy JTF_VARCHAR2_TABLE_200
393: , a27 out nocopy JTF_DATE_TABLE
394: , a28 out nocopy JTF_NUMBER_TABLE
395: , a29 out nocopy JTF_DATE_TABLE
396: , a30 out nocopy JTF_NUMBER_TABLE
397: , a31 out nocopy JTF_NUMBER_TABLE
398: , a32 out nocopy JTF_VARCHAR2_TABLE_100
392: , a26 out nocopy JTF_VARCHAR2_TABLE_200
393: , a27 out nocopy JTF_DATE_TABLE
394: , a28 out nocopy JTF_NUMBER_TABLE
395: , a29 out nocopy JTF_DATE_TABLE
396: , a30 out nocopy JTF_NUMBER_TABLE
397: , a31 out nocopy JTF_NUMBER_TABLE
398: , a32 out nocopy JTF_VARCHAR2_TABLE_100
399: ) as
400: ddindx binary_integer; indx binary_integer;
393: , a27 out nocopy JTF_DATE_TABLE
394: , a28 out nocopy JTF_NUMBER_TABLE
395: , a29 out nocopy JTF_DATE_TABLE
396: , a30 out nocopy JTF_NUMBER_TABLE
397: , a31 out nocopy JTF_NUMBER_TABLE
398: , a32 out nocopy JTF_VARCHAR2_TABLE_100
399: ) as
400: ddindx binary_integer; indx binary_integer;
401: begin
399: ) as
400: ddindx binary_integer; indx binary_integer;
401: begin
402: if t is null or t.count = 0 then
403: a0 := JTF_NUMBER_TABLE();
404: a1 := JTF_NUMBER_TABLE();
405: a2 := JTF_VARCHAR2_TABLE_100();
406: a3 := JTF_VARCHAR2_TABLE_100();
407: a4 := JTF_NUMBER_TABLE();
400: ddindx binary_integer; indx binary_integer;
401: begin
402: if t is null or t.count = 0 then
403: a0 := JTF_NUMBER_TABLE();
404: a1 := JTF_NUMBER_TABLE();
405: a2 := JTF_VARCHAR2_TABLE_100();
406: a3 := JTF_VARCHAR2_TABLE_100();
407: a4 := JTF_NUMBER_TABLE();
408: a5 := JTF_VARCHAR2_TABLE_400();
403: a0 := JTF_NUMBER_TABLE();
404: a1 := JTF_NUMBER_TABLE();
405: a2 := JTF_VARCHAR2_TABLE_100();
406: a3 := JTF_VARCHAR2_TABLE_100();
407: a4 := JTF_NUMBER_TABLE();
408: a5 := JTF_VARCHAR2_TABLE_400();
409: a6 := JTF_VARCHAR2_TABLE_100();
410: a7 := JTF_VARCHAR2_TABLE_100();
411: a8 := JTF_VARCHAR2_TABLE_100();
427: a24 := JTF_VARCHAR2_TABLE_200();
428: a25 := JTF_VARCHAR2_TABLE_200();
429: a26 := JTF_VARCHAR2_TABLE_200();
430: a27 := JTF_DATE_TABLE();
431: a28 := JTF_NUMBER_TABLE();
432: a29 := JTF_DATE_TABLE();
433: a30 := JTF_NUMBER_TABLE();
434: a31 := JTF_NUMBER_TABLE();
435: a32 := JTF_VARCHAR2_TABLE_100();
429: a26 := JTF_VARCHAR2_TABLE_200();
430: a27 := JTF_DATE_TABLE();
431: a28 := JTF_NUMBER_TABLE();
432: a29 := JTF_DATE_TABLE();
433: a30 := JTF_NUMBER_TABLE();
434: a31 := JTF_NUMBER_TABLE();
435: a32 := JTF_VARCHAR2_TABLE_100();
436: else
437: a0 := JTF_NUMBER_TABLE();
430: a27 := JTF_DATE_TABLE();
431: a28 := JTF_NUMBER_TABLE();
432: a29 := JTF_DATE_TABLE();
433: a30 := JTF_NUMBER_TABLE();
434: a31 := JTF_NUMBER_TABLE();
435: a32 := JTF_VARCHAR2_TABLE_100();
436: else
437: a0 := JTF_NUMBER_TABLE();
438: a1 := JTF_NUMBER_TABLE();
433: a30 := JTF_NUMBER_TABLE();
434: a31 := JTF_NUMBER_TABLE();
435: a32 := JTF_VARCHAR2_TABLE_100();
436: else
437: a0 := JTF_NUMBER_TABLE();
438: a1 := JTF_NUMBER_TABLE();
439: a2 := JTF_VARCHAR2_TABLE_100();
440: a3 := JTF_VARCHAR2_TABLE_100();
441: a4 := JTF_NUMBER_TABLE();
434: a31 := JTF_NUMBER_TABLE();
435: a32 := JTF_VARCHAR2_TABLE_100();
436: else
437: a0 := JTF_NUMBER_TABLE();
438: a1 := JTF_NUMBER_TABLE();
439: a2 := JTF_VARCHAR2_TABLE_100();
440: a3 := JTF_VARCHAR2_TABLE_100();
441: a4 := JTF_NUMBER_TABLE();
442: a5 := JTF_VARCHAR2_TABLE_400();
437: a0 := JTF_NUMBER_TABLE();
438: a1 := JTF_NUMBER_TABLE();
439: a2 := JTF_VARCHAR2_TABLE_100();
440: a3 := JTF_VARCHAR2_TABLE_100();
441: a4 := JTF_NUMBER_TABLE();
442: a5 := JTF_VARCHAR2_TABLE_400();
443: a6 := JTF_VARCHAR2_TABLE_100();
444: a7 := JTF_VARCHAR2_TABLE_100();
445: a8 := JTF_VARCHAR2_TABLE_100();
461: a24 := JTF_VARCHAR2_TABLE_200();
462: a25 := JTF_VARCHAR2_TABLE_200();
463: a26 := JTF_VARCHAR2_TABLE_200();
464: a27 := JTF_DATE_TABLE();
465: a28 := JTF_NUMBER_TABLE();
466: a29 := JTF_DATE_TABLE();
467: a30 := JTF_NUMBER_TABLE();
468: a31 := JTF_NUMBER_TABLE();
469: a32 := JTF_VARCHAR2_TABLE_100();
463: a26 := JTF_VARCHAR2_TABLE_200();
464: a27 := JTF_DATE_TABLE();
465: a28 := JTF_NUMBER_TABLE();
466: a29 := JTF_DATE_TABLE();
467: a30 := JTF_NUMBER_TABLE();
468: a31 := JTF_NUMBER_TABLE();
469: a32 := JTF_VARCHAR2_TABLE_100();
470: if t.count > 0 then
471: a0.extend(t.count);
464: a27 := JTF_DATE_TABLE();
465: a28 := JTF_NUMBER_TABLE();
466: a29 := JTF_DATE_TABLE();
467: a30 := JTF_NUMBER_TABLE();
468: a31 := JTF_NUMBER_TABLE();
469: a32 := JTF_VARCHAR2_TABLE_100();
470: if t.count > 0 then
471: a0.extend(t.count);
472: a1.extend(t.count);
555: , p_module_type VARCHAR2
556: , x_return_status out nocopy VARCHAR2
557: , x_msg_count out nocopy NUMBER
558: , x_msg_data out nocopy VARCHAR2
559: , p9_a0 in out nocopy JTF_NUMBER_TABLE
560: , p9_a1 in out nocopy JTF_NUMBER_TABLE
561: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
562: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
563: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
556: , x_return_status out nocopy VARCHAR2
557: , x_msg_count out nocopy NUMBER
558: , x_msg_data out nocopy VARCHAR2
559: , p9_a0 in out nocopy JTF_NUMBER_TABLE
560: , p9_a1 in out nocopy JTF_NUMBER_TABLE
561: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
562: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
563: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
564: , p9_a5 in out nocopy JTF_NUMBER_TABLE
560: , p9_a1 in out nocopy JTF_NUMBER_TABLE
561: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
562: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
563: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
564: , p9_a5 in out nocopy JTF_NUMBER_TABLE
565: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
566: , p9_a7 in out nocopy JTF_DATE_TABLE
567: , p9_a8 in out nocopy JTF_DATE_TABLE
568: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
584: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
585: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_200
586: , p9_a27 in out nocopy JTF_DATE_TABLE
587: , p9_a28 in out nocopy JTF_NUMBER_TABLE
588: , p9_a29 in out nocopy JTF_DATE_TABLE
589: , p9_a30 in out nocopy JTF_NUMBER_TABLE
590: , p9_a31 in out nocopy JTF_NUMBER_TABLE
591: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_200
586: , p9_a27 in out nocopy JTF_DATE_TABLE
587: , p9_a28 in out nocopy JTF_NUMBER_TABLE
588: , p9_a29 in out nocopy JTF_DATE_TABLE
589: , p9_a30 in out nocopy JTF_NUMBER_TABLE
590: , p9_a31 in out nocopy JTF_NUMBER_TABLE
591: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
592: , p10_a0 in out nocopy JTF_NUMBER_TABLE
593: , p10_a1 in out nocopy JTF_NUMBER_TABLE
586: , p9_a27 in out nocopy JTF_DATE_TABLE
587: , p9_a28 in out nocopy JTF_NUMBER_TABLE
588: , p9_a29 in out nocopy JTF_DATE_TABLE
589: , p9_a30 in out nocopy JTF_NUMBER_TABLE
590: , p9_a31 in out nocopy JTF_NUMBER_TABLE
591: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
592: , p10_a0 in out nocopy JTF_NUMBER_TABLE
593: , p10_a1 in out nocopy JTF_NUMBER_TABLE
594: , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p9_a29 in out nocopy JTF_DATE_TABLE
589: , p9_a30 in out nocopy JTF_NUMBER_TABLE
590: , p9_a31 in out nocopy JTF_NUMBER_TABLE
591: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
592: , p10_a0 in out nocopy JTF_NUMBER_TABLE
593: , p10_a1 in out nocopy JTF_NUMBER_TABLE
594: , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
595: , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100
596: , p10_a4 in out nocopy JTF_NUMBER_TABLE
589: , p9_a30 in out nocopy JTF_NUMBER_TABLE
590: , p9_a31 in out nocopy JTF_NUMBER_TABLE
591: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
592: , p10_a0 in out nocopy JTF_NUMBER_TABLE
593: , p10_a1 in out nocopy JTF_NUMBER_TABLE
594: , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
595: , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100
596: , p10_a4 in out nocopy JTF_NUMBER_TABLE
597: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_400
592: , p10_a0 in out nocopy JTF_NUMBER_TABLE
593: , p10_a1 in out nocopy JTF_NUMBER_TABLE
594: , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
595: , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100
596: , p10_a4 in out nocopy JTF_NUMBER_TABLE
597: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_400
598: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
600: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
616: , p10_a24 in out nocopy JTF_VARCHAR2_TABLE_200
617: , p10_a25 in out nocopy JTF_VARCHAR2_TABLE_200
618: , p10_a26 in out nocopy JTF_VARCHAR2_TABLE_200
619: , p10_a27 in out nocopy JTF_DATE_TABLE
620: , p10_a28 in out nocopy JTF_NUMBER_TABLE
621: , p10_a29 in out nocopy JTF_DATE_TABLE
622: , p10_a30 in out nocopy JTF_NUMBER_TABLE
623: , p10_a31 in out nocopy JTF_NUMBER_TABLE
624: , p10_a32 in out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a26 in out nocopy JTF_VARCHAR2_TABLE_200
619: , p10_a27 in out nocopy JTF_DATE_TABLE
620: , p10_a28 in out nocopy JTF_NUMBER_TABLE
621: , p10_a29 in out nocopy JTF_DATE_TABLE
622: , p10_a30 in out nocopy JTF_NUMBER_TABLE
623: , p10_a31 in out nocopy JTF_NUMBER_TABLE
624: , p10_a32 in out nocopy JTF_VARCHAR2_TABLE_100
625: , p_mr_header_id NUMBER
626: , p_mr_effectivity_id NUMBER
619: , p10_a27 in out nocopy JTF_DATE_TABLE
620: , p10_a28 in out nocopy JTF_NUMBER_TABLE
621: , p10_a29 in out nocopy JTF_DATE_TABLE
622: , p10_a30 in out nocopy JTF_NUMBER_TABLE
623: , p10_a31 in out nocopy JTF_NUMBER_TABLE
624: , p10_a32 in out nocopy JTF_VARCHAR2_TABLE_100
625: , p_mr_header_id NUMBER
626: , p_mr_effectivity_id NUMBER
627: )