606: procedure rosetta_table_copy_in_p13(t out jtf_ec_pub.notes_tbl_type, a0 JTF_VARCHAR2_TABLE_100
607: , a1 JTF_NUMBER_TABLE
608: , a2 JTF_VARCHAR2_TABLE_2000
609: , a3 JTF_VARCHAR2_TABLE_32767
610: , a4 JTF_VARCHAR2_TABLE_300
611: , a5 JTF_VARCHAR2_TABLE_100
612: , a6 JTF_VARCHAR2_TABLE_300
613: , a7 JTF_NUMBER_TABLE
614: , a8 JTF_VARCHAR2_TABLE_300
608: , a2 JTF_VARCHAR2_TABLE_2000
609: , a3 JTF_VARCHAR2_TABLE_32767
610: , a4 JTF_VARCHAR2_TABLE_300
611: , a5 JTF_VARCHAR2_TABLE_100
612: , a6 JTF_VARCHAR2_TABLE_300
613: , a7 JTF_NUMBER_TABLE
614: , a8 JTF_VARCHAR2_TABLE_300
615: , a9 JTF_NUMBER_TABLE
616: , a10 JTF_VARCHAR2_TABLE_300
610: , a4 JTF_VARCHAR2_TABLE_300
611: , a5 JTF_VARCHAR2_TABLE_100
612: , a6 JTF_VARCHAR2_TABLE_300
613: , a7 JTF_NUMBER_TABLE
614: , a8 JTF_VARCHAR2_TABLE_300
615: , a9 JTF_NUMBER_TABLE
616: , a10 JTF_VARCHAR2_TABLE_300
617: , a11 JTF_NUMBER_TABLE
618: ) as
612: , a6 JTF_VARCHAR2_TABLE_300
613: , a7 JTF_NUMBER_TABLE
614: , a8 JTF_VARCHAR2_TABLE_300
615: , a9 JTF_NUMBER_TABLE
616: , a10 JTF_VARCHAR2_TABLE_300
617: , a11 JTF_NUMBER_TABLE
618: ) as
619: ddindx binary_integer; indx binary_integer;
620: begin
647: procedure rosetta_table_copy_out_p13(t jtf_ec_pub.notes_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
648: , a1 out JTF_NUMBER_TABLE
649: , a2 out JTF_VARCHAR2_TABLE_2000
650: , a3 out JTF_VARCHAR2_TABLE_32767
651: , a4 out JTF_VARCHAR2_TABLE_300
652: , a5 out JTF_VARCHAR2_TABLE_100
653: , a6 out JTF_VARCHAR2_TABLE_300
654: , a7 out JTF_NUMBER_TABLE
655: , a8 out JTF_VARCHAR2_TABLE_300
649: , a2 out JTF_VARCHAR2_TABLE_2000
650: , a3 out JTF_VARCHAR2_TABLE_32767
651: , a4 out JTF_VARCHAR2_TABLE_300
652: , a5 out JTF_VARCHAR2_TABLE_100
653: , a6 out JTF_VARCHAR2_TABLE_300
654: , a7 out JTF_NUMBER_TABLE
655: , a8 out JTF_VARCHAR2_TABLE_300
656: , a9 out JTF_NUMBER_TABLE
657: , a10 out JTF_VARCHAR2_TABLE_300
651: , a4 out JTF_VARCHAR2_TABLE_300
652: , a5 out JTF_VARCHAR2_TABLE_100
653: , a6 out JTF_VARCHAR2_TABLE_300
654: , a7 out JTF_NUMBER_TABLE
655: , a8 out JTF_VARCHAR2_TABLE_300
656: , a9 out JTF_NUMBER_TABLE
657: , a10 out JTF_VARCHAR2_TABLE_300
658: , a11 out JTF_NUMBER_TABLE
659: ) as
653: , a6 out JTF_VARCHAR2_TABLE_300
654: , a7 out JTF_NUMBER_TABLE
655: , a8 out JTF_VARCHAR2_TABLE_300
656: , a9 out JTF_NUMBER_TABLE
657: , a10 out JTF_VARCHAR2_TABLE_300
658: , a11 out JTF_NUMBER_TABLE
659: ) as
660: ddindx binary_integer; indx binary_integer;
661: begin
663: a0 := JTF_VARCHAR2_TABLE_100();
664: a1 := JTF_NUMBER_TABLE();
665: a2 := JTF_VARCHAR2_TABLE_2000();
666: a3 := JTF_VARCHAR2_TABLE_32767();
667: a4 := JTF_VARCHAR2_TABLE_300();
668: a5 := JTF_VARCHAR2_TABLE_100();
669: a6 := JTF_VARCHAR2_TABLE_300();
670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_300();
665: a2 := JTF_VARCHAR2_TABLE_2000();
666: a3 := JTF_VARCHAR2_TABLE_32767();
667: a4 := JTF_VARCHAR2_TABLE_300();
668: a5 := JTF_VARCHAR2_TABLE_100();
669: a6 := JTF_VARCHAR2_TABLE_300();
670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_300();
672: a9 := JTF_NUMBER_TABLE();
673: a10 := JTF_VARCHAR2_TABLE_300();
667: a4 := JTF_VARCHAR2_TABLE_300();
668: a5 := JTF_VARCHAR2_TABLE_100();
669: a6 := JTF_VARCHAR2_TABLE_300();
670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_300();
672: a9 := JTF_NUMBER_TABLE();
673: a10 := JTF_VARCHAR2_TABLE_300();
674: a11 := JTF_NUMBER_TABLE();
675: else
669: a6 := JTF_VARCHAR2_TABLE_300();
670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_300();
672: a9 := JTF_NUMBER_TABLE();
673: a10 := JTF_VARCHAR2_TABLE_300();
674: a11 := JTF_NUMBER_TABLE();
675: else
676: a0 := JTF_VARCHAR2_TABLE_100();
677: a1 := JTF_NUMBER_TABLE();
676: a0 := JTF_VARCHAR2_TABLE_100();
677: a1 := JTF_NUMBER_TABLE();
678: a2 := JTF_VARCHAR2_TABLE_2000();
679: a3 := JTF_VARCHAR2_TABLE_32767();
680: a4 := JTF_VARCHAR2_TABLE_300();
681: a5 := JTF_VARCHAR2_TABLE_100();
682: a6 := JTF_VARCHAR2_TABLE_300();
683: a7 := JTF_NUMBER_TABLE();
684: a8 := JTF_VARCHAR2_TABLE_300();
678: a2 := JTF_VARCHAR2_TABLE_2000();
679: a3 := JTF_VARCHAR2_TABLE_32767();
680: a4 := JTF_VARCHAR2_TABLE_300();
681: a5 := JTF_VARCHAR2_TABLE_100();
682: a6 := JTF_VARCHAR2_TABLE_300();
683: a7 := JTF_NUMBER_TABLE();
684: a8 := JTF_VARCHAR2_TABLE_300();
685: a9 := JTF_NUMBER_TABLE();
686: a10 := JTF_VARCHAR2_TABLE_300();
680: a4 := JTF_VARCHAR2_TABLE_300();
681: a5 := JTF_VARCHAR2_TABLE_100();
682: a6 := JTF_VARCHAR2_TABLE_300();
683: a7 := JTF_NUMBER_TABLE();
684: a8 := JTF_VARCHAR2_TABLE_300();
685: a9 := JTF_NUMBER_TABLE();
686: a10 := JTF_VARCHAR2_TABLE_300();
687: a11 := JTF_NUMBER_TABLE();
688: if t.count > 0 then
682: a6 := JTF_VARCHAR2_TABLE_300();
683: a7 := JTF_NUMBER_TABLE();
684: a8 := JTF_VARCHAR2_TABLE_300();
685: a9 := JTF_NUMBER_TABLE();
686: a10 := JTF_VARCHAR2_TABLE_300();
687: a11 := JTF_NUMBER_TABLE();
688: if t.count > 0 then
689: a0.extend(t.count);
690: a1.extend(t.count);
836: , p15_a0 JTF_VARCHAR2_TABLE_100
837: , p15_a1 JTF_NUMBER_TABLE
838: , p15_a2 JTF_VARCHAR2_TABLE_2000
839: , p15_a3 JTF_VARCHAR2_TABLE_32767
840: , p15_a4 JTF_VARCHAR2_TABLE_300
841: , p15_a5 JTF_VARCHAR2_TABLE_100
842: , p15_a6 JTF_VARCHAR2_TABLE_300
843: , p15_a7 JTF_NUMBER_TABLE
844: , p15_a8 JTF_VARCHAR2_TABLE_300
838: , p15_a2 JTF_VARCHAR2_TABLE_2000
839: , p15_a3 JTF_VARCHAR2_TABLE_32767
840: , p15_a4 JTF_VARCHAR2_TABLE_300
841: , p15_a5 JTF_VARCHAR2_TABLE_100
842: , p15_a6 JTF_VARCHAR2_TABLE_300
843: , p15_a7 JTF_NUMBER_TABLE
844: , p15_a8 JTF_VARCHAR2_TABLE_300
845: , p15_a9 JTF_NUMBER_TABLE
846: , p15_a10 JTF_VARCHAR2_TABLE_300
840: , p15_a4 JTF_VARCHAR2_TABLE_300
841: , p15_a5 JTF_VARCHAR2_TABLE_100
842: , p15_a6 JTF_VARCHAR2_TABLE_300
843: , p15_a7 JTF_NUMBER_TABLE
844: , p15_a8 JTF_VARCHAR2_TABLE_300
845: , p15_a9 JTF_NUMBER_TABLE
846: , p15_a10 JTF_VARCHAR2_TABLE_300
847: , p15_a11 JTF_NUMBER_TABLE
848: , x_esc_id out NUMBER
842: , p15_a6 JTF_VARCHAR2_TABLE_300
843: , p15_a7 JTF_NUMBER_TABLE
844: , p15_a8 JTF_VARCHAR2_TABLE_300
845: , p15_a9 JTF_NUMBER_TABLE
846: , p15_a10 JTF_VARCHAR2_TABLE_300
847: , p15_a11 JTF_NUMBER_TABLE
848: , x_esc_id out NUMBER
849: , x_esc_number out NUMBER
850: , x_workflow_process_id out VARCHAR2
1150: , p17_a0 JTF_VARCHAR2_TABLE_100
1151: , p17_a1 JTF_NUMBER_TABLE
1152: , p17_a2 JTF_VARCHAR2_TABLE_2000
1153: , p17_a3 JTF_VARCHAR2_TABLE_32767
1154: , p17_a4 JTF_VARCHAR2_TABLE_300
1155: , p17_a5 JTF_VARCHAR2_TABLE_100
1156: , p17_a6 JTF_VARCHAR2_TABLE_300
1157: , p17_a7 JTF_NUMBER_TABLE
1158: , p17_a8 JTF_VARCHAR2_TABLE_300
1152: , p17_a2 JTF_VARCHAR2_TABLE_2000
1153: , p17_a3 JTF_VARCHAR2_TABLE_32767
1154: , p17_a4 JTF_VARCHAR2_TABLE_300
1155: , p17_a5 JTF_VARCHAR2_TABLE_100
1156: , p17_a6 JTF_VARCHAR2_TABLE_300
1157: , p17_a7 JTF_NUMBER_TABLE
1158: , p17_a8 JTF_VARCHAR2_TABLE_300
1159: , p17_a9 JTF_NUMBER_TABLE
1160: , p17_a10 JTF_VARCHAR2_TABLE_300
1154: , p17_a4 JTF_VARCHAR2_TABLE_300
1155: , p17_a5 JTF_VARCHAR2_TABLE_100
1156: , p17_a6 JTF_VARCHAR2_TABLE_300
1157: , p17_a7 JTF_NUMBER_TABLE
1158: , p17_a8 JTF_VARCHAR2_TABLE_300
1159: , p17_a9 JTF_NUMBER_TABLE
1160: , p17_a10 JTF_VARCHAR2_TABLE_300
1161: , p17_a11 JTF_NUMBER_TABLE
1162: , x_object_version_number out NUMBER
1156: , p17_a6 JTF_VARCHAR2_TABLE_300
1157: , p17_a7 JTF_NUMBER_TABLE
1158: , p17_a8 JTF_VARCHAR2_TABLE_300
1159: , p17_a9 JTF_NUMBER_TABLE
1160: , p17_a10 JTF_VARCHAR2_TABLE_300
1161: , p17_a11 JTF_NUMBER_TABLE
1162: , x_object_version_number out NUMBER
1163: , x_workflow_process_id out VARCHAR2
1164: )