26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_NUMBER_TABLE
105: , a83 JTF_NUMBER_TABLE
106: , a84 JTF_NUMBER_TABLE
107: , a85 JTF_NUMBER_TABLE
108: , a86 JTF_NUMBER_TABLE
109: , a87 JTF_VARCHAR2_TABLE_100
110: , a88 JTF_VARCHAR2_TABLE_300
111: , a89 JTF_NUMBER_TABLE
112: , a90 JTF_VARCHAR2_TABLE_100
113: , a91 JTF_VARCHAR2_TABLE_100
108: , a86 JTF_NUMBER_TABLE
109: , a87 JTF_VARCHAR2_TABLE_100
110: , a88 JTF_VARCHAR2_TABLE_300
111: , a89 JTF_NUMBER_TABLE
112: , a90 JTF_VARCHAR2_TABLE_100
113: , a91 JTF_VARCHAR2_TABLE_100
114: , a92 JTF_DATE_TABLE
115: , a93 JTF_NUMBER_TABLE
116: , a94 JTF_NUMBER_TABLE
109: , a87 JTF_VARCHAR2_TABLE_100
110: , a88 JTF_VARCHAR2_TABLE_300
111: , a89 JTF_NUMBER_TABLE
112: , a90 JTF_VARCHAR2_TABLE_100
113: , a91 JTF_VARCHAR2_TABLE_100
114: , a92 JTF_DATE_TABLE
115: , a93 JTF_NUMBER_TABLE
116: , a94 JTF_NUMBER_TABLE
117: , a95 JTF_NUMBER_TABLE
245: , a4 out nocopy JTF_NUMBER_TABLE
246: , a5 out nocopy JTF_NUMBER_TABLE
247: , a6 out nocopy JTF_NUMBER_TABLE
248: , a7 out nocopy JTF_NUMBER_TABLE
249: , a8 out nocopy JTF_VARCHAR2_TABLE_100
250: , a9 out nocopy JTF_VARCHAR2_TABLE_100
251: , a10 out nocopy JTF_NUMBER_TABLE
252: , a11 out nocopy JTF_NUMBER_TABLE
253: , a12 out nocopy JTF_NUMBER_TABLE
246: , a5 out nocopy JTF_NUMBER_TABLE
247: , a6 out nocopy JTF_NUMBER_TABLE
248: , a7 out nocopy JTF_NUMBER_TABLE
249: , a8 out nocopy JTF_VARCHAR2_TABLE_100
250: , a9 out nocopy JTF_VARCHAR2_TABLE_100
251: , a10 out nocopy JTF_NUMBER_TABLE
252: , a11 out nocopy JTF_NUMBER_TABLE
253: , a12 out nocopy JTF_NUMBER_TABLE
254: , a13 out nocopy JTF_VARCHAR2_TABLE_100
250: , a9 out nocopy JTF_VARCHAR2_TABLE_100
251: , a10 out nocopy JTF_NUMBER_TABLE
252: , a11 out nocopy JTF_NUMBER_TABLE
253: , a12 out nocopy JTF_NUMBER_TABLE
254: , a13 out nocopy JTF_VARCHAR2_TABLE_100
255: , a14 out nocopy JTF_NUMBER_TABLE
256: , a15 out nocopy JTF_NUMBER_TABLE
257: , a16 out nocopy JTF_VARCHAR2_TABLE_100
258: , a17 out nocopy JTF_NUMBER_TABLE
253: , a12 out nocopy JTF_NUMBER_TABLE
254: , a13 out nocopy JTF_VARCHAR2_TABLE_100
255: , a14 out nocopy JTF_NUMBER_TABLE
256: , a15 out nocopy JTF_NUMBER_TABLE
257: , a16 out nocopy JTF_VARCHAR2_TABLE_100
258: , a17 out nocopy JTF_NUMBER_TABLE
259: , a18 out nocopy JTF_NUMBER_TABLE
260: , a19 out nocopy JTF_NUMBER_TABLE
261: , a20 out nocopy JTF_NUMBER_TABLE
258: , a17 out nocopy JTF_NUMBER_TABLE
259: , a18 out nocopy JTF_NUMBER_TABLE
260: , a19 out nocopy JTF_NUMBER_TABLE
261: , a20 out nocopy JTF_NUMBER_TABLE
262: , a21 out nocopy JTF_VARCHAR2_TABLE_100
263: , a22 out nocopy JTF_NUMBER_TABLE
264: , a23 out nocopy JTF_NUMBER_TABLE
265: , a24 out nocopy JTF_NUMBER_TABLE
266: , a25 out nocopy JTF_NUMBER_TABLE
324: , a83 out nocopy JTF_NUMBER_TABLE
325: , a84 out nocopy JTF_NUMBER_TABLE
326: , a85 out nocopy JTF_NUMBER_TABLE
327: , a86 out nocopy JTF_NUMBER_TABLE
328: , a87 out nocopy JTF_VARCHAR2_TABLE_100
329: , a88 out nocopy JTF_VARCHAR2_TABLE_300
330: , a89 out nocopy JTF_NUMBER_TABLE
331: , a90 out nocopy JTF_VARCHAR2_TABLE_100
332: , a91 out nocopy JTF_VARCHAR2_TABLE_100
327: , a86 out nocopy JTF_NUMBER_TABLE
328: , a87 out nocopy JTF_VARCHAR2_TABLE_100
329: , a88 out nocopy JTF_VARCHAR2_TABLE_300
330: , a89 out nocopy JTF_NUMBER_TABLE
331: , a90 out nocopy JTF_VARCHAR2_TABLE_100
332: , a91 out nocopy JTF_VARCHAR2_TABLE_100
333: , a92 out nocopy JTF_DATE_TABLE
334: , a93 out nocopy JTF_NUMBER_TABLE
335: , a94 out nocopy JTF_NUMBER_TABLE
328: , a87 out nocopy JTF_VARCHAR2_TABLE_100
329: , a88 out nocopy JTF_VARCHAR2_TABLE_300
330: , a89 out nocopy JTF_NUMBER_TABLE
331: , a90 out nocopy JTF_VARCHAR2_TABLE_100
332: , a91 out nocopy JTF_VARCHAR2_TABLE_100
333: , a92 out nocopy JTF_DATE_TABLE
334: , a93 out nocopy JTF_NUMBER_TABLE
335: , a94 out nocopy JTF_NUMBER_TABLE
336: , a95 out nocopy JTF_NUMBER_TABLE
350: a4 := JTF_NUMBER_TABLE();
351: a5 := JTF_NUMBER_TABLE();
352: a6 := JTF_NUMBER_TABLE();
353: a7 := JTF_NUMBER_TABLE();
354: a8 := JTF_VARCHAR2_TABLE_100();
355: a9 := JTF_VARCHAR2_TABLE_100();
356: a10 := JTF_NUMBER_TABLE();
357: a11 := JTF_NUMBER_TABLE();
358: a12 := JTF_NUMBER_TABLE();
351: a5 := JTF_NUMBER_TABLE();
352: a6 := JTF_NUMBER_TABLE();
353: a7 := JTF_NUMBER_TABLE();
354: a8 := JTF_VARCHAR2_TABLE_100();
355: a9 := JTF_VARCHAR2_TABLE_100();
356: a10 := JTF_NUMBER_TABLE();
357: a11 := JTF_NUMBER_TABLE();
358: a12 := JTF_NUMBER_TABLE();
359: a13 := JTF_VARCHAR2_TABLE_100();
355: a9 := JTF_VARCHAR2_TABLE_100();
356: a10 := JTF_NUMBER_TABLE();
357: a11 := JTF_NUMBER_TABLE();
358: a12 := JTF_NUMBER_TABLE();
359: a13 := JTF_VARCHAR2_TABLE_100();
360: a14 := JTF_NUMBER_TABLE();
361: a15 := JTF_NUMBER_TABLE();
362: a16 := JTF_VARCHAR2_TABLE_100();
363: a17 := JTF_NUMBER_TABLE();
358: a12 := JTF_NUMBER_TABLE();
359: a13 := JTF_VARCHAR2_TABLE_100();
360: a14 := JTF_NUMBER_TABLE();
361: a15 := JTF_NUMBER_TABLE();
362: a16 := JTF_VARCHAR2_TABLE_100();
363: a17 := JTF_NUMBER_TABLE();
364: a18 := JTF_NUMBER_TABLE();
365: a19 := JTF_NUMBER_TABLE();
366: a20 := JTF_NUMBER_TABLE();
363: a17 := JTF_NUMBER_TABLE();
364: a18 := JTF_NUMBER_TABLE();
365: a19 := JTF_NUMBER_TABLE();
366: a20 := JTF_NUMBER_TABLE();
367: a21 := JTF_VARCHAR2_TABLE_100();
368: a22 := JTF_NUMBER_TABLE();
369: a23 := JTF_NUMBER_TABLE();
370: a24 := JTF_NUMBER_TABLE();
371: a25 := JTF_NUMBER_TABLE();
429: a83 := JTF_NUMBER_TABLE();
430: a84 := JTF_NUMBER_TABLE();
431: a85 := JTF_NUMBER_TABLE();
432: a86 := JTF_NUMBER_TABLE();
433: a87 := JTF_VARCHAR2_TABLE_100();
434: a88 := JTF_VARCHAR2_TABLE_300();
435: a89 := JTF_NUMBER_TABLE();
436: a90 := JTF_VARCHAR2_TABLE_100();
437: a91 := JTF_VARCHAR2_TABLE_100();
432: a86 := JTF_NUMBER_TABLE();
433: a87 := JTF_VARCHAR2_TABLE_100();
434: a88 := JTF_VARCHAR2_TABLE_300();
435: a89 := JTF_NUMBER_TABLE();
436: a90 := JTF_VARCHAR2_TABLE_100();
437: a91 := JTF_VARCHAR2_TABLE_100();
438: a92 := JTF_DATE_TABLE();
439: a93 := JTF_NUMBER_TABLE();
440: a94 := JTF_NUMBER_TABLE();
433: a87 := JTF_VARCHAR2_TABLE_100();
434: a88 := JTF_VARCHAR2_TABLE_300();
435: a89 := JTF_NUMBER_TABLE();
436: a90 := JTF_VARCHAR2_TABLE_100();
437: a91 := JTF_VARCHAR2_TABLE_100();
438: a92 := JTF_DATE_TABLE();
439: a93 := JTF_NUMBER_TABLE();
440: a94 := JTF_NUMBER_TABLE();
441: a95 := JTF_NUMBER_TABLE();
452: a4 := JTF_NUMBER_TABLE();
453: a5 := JTF_NUMBER_TABLE();
454: a6 := JTF_NUMBER_TABLE();
455: a7 := JTF_NUMBER_TABLE();
456: a8 := JTF_VARCHAR2_TABLE_100();
457: a9 := JTF_VARCHAR2_TABLE_100();
458: a10 := JTF_NUMBER_TABLE();
459: a11 := JTF_NUMBER_TABLE();
460: a12 := JTF_NUMBER_TABLE();
453: a5 := JTF_NUMBER_TABLE();
454: a6 := JTF_NUMBER_TABLE();
455: a7 := JTF_NUMBER_TABLE();
456: a8 := JTF_VARCHAR2_TABLE_100();
457: a9 := JTF_VARCHAR2_TABLE_100();
458: a10 := JTF_NUMBER_TABLE();
459: a11 := JTF_NUMBER_TABLE();
460: a12 := JTF_NUMBER_TABLE();
461: a13 := JTF_VARCHAR2_TABLE_100();
457: a9 := JTF_VARCHAR2_TABLE_100();
458: a10 := JTF_NUMBER_TABLE();
459: a11 := JTF_NUMBER_TABLE();
460: a12 := JTF_NUMBER_TABLE();
461: a13 := JTF_VARCHAR2_TABLE_100();
462: a14 := JTF_NUMBER_TABLE();
463: a15 := JTF_NUMBER_TABLE();
464: a16 := JTF_VARCHAR2_TABLE_100();
465: a17 := JTF_NUMBER_TABLE();
460: a12 := JTF_NUMBER_TABLE();
461: a13 := JTF_VARCHAR2_TABLE_100();
462: a14 := JTF_NUMBER_TABLE();
463: a15 := JTF_NUMBER_TABLE();
464: a16 := JTF_VARCHAR2_TABLE_100();
465: a17 := JTF_NUMBER_TABLE();
466: a18 := JTF_NUMBER_TABLE();
467: a19 := JTF_NUMBER_TABLE();
468: a20 := JTF_NUMBER_TABLE();
465: a17 := JTF_NUMBER_TABLE();
466: a18 := JTF_NUMBER_TABLE();
467: a19 := JTF_NUMBER_TABLE();
468: a20 := JTF_NUMBER_TABLE();
469: a21 := JTF_VARCHAR2_TABLE_100();
470: a22 := JTF_NUMBER_TABLE();
471: a23 := JTF_NUMBER_TABLE();
472: a24 := JTF_NUMBER_TABLE();
473: a25 := JTF_NUMBER_TABLE();
531: a83 := JTF_NUMBER_TABLE();
532: a84 := JTF_NUMBER_TABLE();
533: a85 := JTF_NUMBER_TABLE();
534: a86 := JTF_NUMBER_TABLE();
535: a87 := JTF_VARCHAR2_TABLE_100();
536: a88 := JTF_VARCHAR2_TABLE_300();
537: a89 := JTF_NUMBER_TABLE();
538: a90 := JTF_VARCHAR2_TABLE_100();
539: a91 := JTF_VARCHAR2_TABLE_100();
534: a86 := JTF_NUMBER_TABLE();
535: a87 := JTF_VARCHAR2_TABLE_100();
536: a88 := JTF_VARCHAR2_TABLE_300();
537: a89 := JTF_NUMBER_TABLE();
538: a90 := JTF_VARCHAR2_TABLE_100();
539: a91 := JTF_VARCHAR2_TABLE_100();
540: a92 := JTF_DATE_TABLE();
541: a93 := JTF_NUMBER_TABLE();
542: a94 := JTF_NUMBER_TABLE();
535: a87 := JTF_VARCHAR2_TABLE_100();
536: a88 := JTF_VARCHAR2_TABLE_300();
537: a89 := JTF_NUMBER_TABLE();
538: a90 := JTF_VARCHAR2_TABLE_100();
539: a91 := JTF_VARCHAR2_TABLE_100();
540: a92 := JTF_DATE_TABLE();
541: a93 := JTF_NUMBER_TABLE();
542: a94 := JTF_NUMBER_TABLE();
543: a95 := JTF_NUMBER_TABLE();
763: end rosetta_table_copy_out_p0;
764:
765: procedure rosetta_table_copy_in_p2(t out nocopy ozf_fund_allocations_pvt.factid_table_type, a0 JTF_NUMBER_TABLE
766: , a1 JTF_NUMBER_TABLE
767: , a2 JTF_VARCHAR2_TABLE_100
768: ) as
769: ddindx binary_integer; indx binary_integer;
770: begin
771: if a0 is not null and a0.count > 0 then
786: end if;
787: end rosetta_table_copy_in_p2;
788: procedure rosetta_table_copy_out_p2(t ozf_fund_allocations_pvt.factid_table_type, a0 out nocopy JTF_NUMBER_TABLE
789: , a1 out nocopy JTF_NUMBER_TABLE
790: , a2 out nocopy JTF_VARCHAR2_TABLE_100
791: ) as
792: ddindx binary_integer; indx binary_integer;
793: begin
794: if t is null or t.count = 0 then
793: begin
794: if t is null or t.count = 0 then
795: a0 := JTF_NUMBER_TABLE();
796: a1 := JTF_NUMBER_TABLE();
797: a2 := JTF_VARCHAR2_TABLE_100();
798: else
799: a0 := JTF_NUMBER_TABLE();
800: a1 := JTF_NUMBER_TABLE();
801: a2 := JTF_VARCHAR2_TABLE_100();
797: a2 := JTF_VARCHAR2_TABLE_100();
798: else
799: a0 := JTF_NUMBER_TABLE();
800: a1 := JTF_NUMBER_TABLE();
801: a2 := JTF_VARCHAR2_TABLE_100();
802: if t.count > 0 then
803: a0.extend(t.count);
804: a1.extend(t.count);
805: a2.extend(t.count);
833: , p7_a4 JTF_NUMBER_TABLE
834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE
836: , p7_a7 JTF_NUMBER_TABLE
837: , p7_a8 JTF_VARCHAR2_TABLE_100
838: , p7_a9 JTF_VARCHAR2_TABLE_100
839: , p7_a10 JTF_NUMBER_TABLE
840: , p7_a11 JTF_NUMBER_TABLE
841: , p7_a12 JTF_NUMBER_TABLE
834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE
836: , p7_a7 JTF_NUMBER_TABLE
837: , p7_a8 JTF_VARCHAR2_TABLE_100
838: , p7_a9 JTF_VARCHAR2_TABLE_100
839: , p7_a10 JTF_NUMBER_TABLE
840: , p7_a11 JTF_NUMBER_TABLE
841: , p7_a12 JTF_NUMBER_TABLE
842: , p7_a13 JTF_VARCHAR2_TABLE_100
838: , p7_a9 JTF_VARCHAR2_TABLE_100
839: , p7_a10 JTF_NUMBER_TABLE
840: , p7_a11 JTF_NUMBER_TABLE
841: , p7_a12 JTF_NUMBER_TABLE
842: , p7_a13 JTF_VARCHAR2_TABLE_100
843: , p7_a14 JTF_NUMBER_TABLE
844: , p7_a15 JTF_NUMBER_TABLE
845: , p7_a16 JTF_VARCHAR2_TABLE_100
846: , p7_a17 JTF_NUMBER_TABLE
841: , p7_a12 JTF_NUMBER_TABLE
842: , p7_a13 JTF_VARCHAR2_TABLE_100
843: , p7_a14 JTF_NUMBER_TABLE
844: , p7_a15 JTF_NUMBER_TABLE
845: , p7_a16 JTF_VARCHAR2_TABLE_100
846: , p7_a17 JTF_NUMBER_TABLE
847: , p7_a18 JTF_NUMBER_TABLE
848: , p7_a19 JTF_NUMBER_TABLE
849: , p7_a20 JTF_NUMBER_TABLE
846: , p7_a17 JTF_NUMBER_TABLE
847: , p7_a18 JTF_NUMBER_TABLE
848: , p7_a19 JTF_NUMBER_TABLE
849: , p7_a20 JTF_NUMBER_TABLE
850: , p7_a21 JTF_VARCHAR2_TABLE_100
851: , p7_a22 JTF_NUMBER_TABLE
852: , p7_a23 JTF_NUMBER_TABLE
853: , p7_a24 JTF_NUMBER_TABLE
854: , p7_a25 JTF_NUMBER_TABLE
912: , p7_a83 JTF_NUMBER_TABLE
913: , p7_a84 JTF_NUMBER_TABLE
914: , p7_a85 JTF_NUMBER_TABLE
915: , p7_a86 JTF_NUMBER_TABLE
916: , p7_a87 JTF_VARCHAR2_TABLE_100
917: , p7_a88 JTF_VARCHAR2_TABLE_300
918: , p7_a89 JTF_NUMBER_TABLE
919: , p7_a90 JTF_VARCHAR2_TABLE_100
920: , p7_a91 JTF_VARCHAR2_TABLE_100
915: , p7_a86 JTF_NUMBER_TABLE
916: , p7_a87 JTF_VARCHAR2_TABLE_100
917: , p7_a88 JTF_VARCHAR2_TABLE_300
918: , p7_a89 JTF_NUMBER_TABLE
919: , p7_a90 JTF_VARCHAR2_TABLE_100
920: , p7_a91 JTF_VARCHAR2_TABLE_100
921: , p7_a92 JTF_DATE_TABLE
922: , p7_a93 JTF_NUMBER_TABLE
923: , p7_a94 JTF_NUMBER_TABLE
916: , p7_a87 JTF_VARCHAR2_TABLE_100
917: , p7_a88 JTF_VARCHAR2_TABLE_300
918: , p7_a89 JTF_NUMBER_TABLE
919: , p7_a90 JTF_VARCHAR2_TABLE_100
920: , p7_a91 JTF_VARCHAR2_TABLE_100
921: , p7_a92 JTF_DATE_TABLE
922: , p7_a93 JTF_NUMBER_TABLE
923: , p7_a94 JTF_NUMBER_TABLE
924: , p7_a95 JTF_NUMBER_TABLE
1084: , p_approver_factid NUMBER
1085: , p_approve_all_flag VARCHAR2
1086: , p6_a0 JTF_NUMBER_TABLE
1087: , p6_a1 JTF_NUMBER_TABLE
1088: , p6_a2 JTF_VARCHAR2_TABLE_100
1089: , x_return_status out nocopy VARCHAR2
1090: , x_msg_count out nocopy NUMBER
1091: , x_msg_data out nocopy VARCHAR2
1092: )
1141: , p_validation_level NUMBER
1142: , p_rejector_factid NUMBER
1143: , p5_a0 JTF_NUMBER_TABLE
1144: , p5_a1 JTF_NUMBER_TABLE
1145: , p5_a2 JTF_VARCHAR2_TABLE_100
1146: , x_return_status out nocopy VARCHAR2
1147: , x_msg_count out nocopy NUMBER
1148: , x_msg_data out nocopy VARCHAR2
1149: )