eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_REGION_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 759: , a1 JTF_VARCHAR2_TABLE_100

755: end if;
756: end rosetta_table_copy_out_p4;
757:
758: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_item_rec_table, a0 JTF_NUMBER_TABLE
759: , a1 JTF_VARCHAR2_TABLE_100
760: ) as
761: ddindx binary_integer; indx binary_integer;
762: begin
763: if a0 is not null and a0.count > 0 then

Line 780: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

776: end if;
777: end if;
778: end rosetta_table_copy_in_p5;
779: procedure rosetta_table_copy_out_p5(t jtf_region_pub.ak_item_rec_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
780: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
781: ) as
782: ddindx binary_integer; indx binary_integer;
783: begin
784: if t is null or t.count = 0 then

Line 786: a1 := JTF_VARCHAR2_TABLE_100();

782: ddindx binary_integer; indx binary_integer;
783: begin
784: if t is null or t.count = 0 then
785: a0 := JTF_NUMBER_TABLE();
786: a1 := JTF_VARCHAR2_TABLE_100();
787: else
788: a0 := JTF_NUMBER_TABLE();
789: a1 := JTF_VARCHAR2_TABLE_100();
790: if t.count > 0 then

Line 789: a1 := JTF_VARCHAR2_TABLE_100();

785: a0 := JTF_NUMBER_TABLE();
786: a1 := JTF_VARCHAR2_TABLE_100();
787: else
788: a0 := JTF_NUMBER_TABLE();
789: a1 := JTF_VARCHAR2_TABLE_100();
790: if t.count > 0 then
791: a0.extend(t.count);
792: a1.extend(t.count);
793: ddindx := t.first;

Line 808: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_bind_table, a0 JTF_VARCHAR2_TABLE_100

804: end if;
805: end if;
806: end rosetta_table_copy_out_p5;
807:
808: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_bind_table, a0 JTF_VARCHAR2_TABLE_100
809: , a1 JTF_VARCHAR2_TABLE_300
810: ) as
811: ddindx binary_integer; indx binary_integer;
812: begin

Line 829: procedure rosetta_table_copy_out_p6(t jtf_region_pub.ak_bind_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

825: end loop;
826: end if;
827: end if;
828: end rosetta_table_copy_in_p6;
829: procedure rosetta_table_copy_out_p6(t jtf_region_pub.ak_bind_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
830: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
831: ) as
832: ddindx binary_integer; indx binary_integer;
833: begin

Line 835: a0 := JTF_VARCHAR2_TABLE_100();

831: ) as
832: ddindx binary_integer; indx binary_integer;
833: begin
834: if t is null or t.count = 0 then
835: a0 := JTF_VARCHAR2_TABLE_100();
836: a1 := JTF_VARCHAR2_TABLE_300();
837: else
838: a0 := JTF_VARCHAR2_TABLE_100();
839: a1 := JTF_VARCHAR2_TABLE_300();

Line 838: a0 := JTF_VARCHAR2_TABLE_100();

834: if t is null or t.count = 0 then
835: a0 := JTF_VARCHAR2_TABLE_100();
836: a1 := JTF_VARCHAR2_TABLE_300();
837: else
838: a0 := JTF_VARCHAR2_TABLE_100();
839: a1 := JTF_VARCHAR2_TABLE_300();
840: if t.count > 0 then
841: a0.extend(t.count);
842: a1.extend(t.count);

Line 858: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table, a0 JTF_VARCHAR2_TABLE_100

854: end if;
855: end if;
856: end rosetta_table_copy_out_p6;
857:
858: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table, a0 JTF_VARCHAR2_TABLE_100
859: , a1 JTF_VARCHAR2_TABLE_100
860: , a2 JTF_VARCHAR2_TABLE_100
861: , a3 JTF_VARCHAR2_TABLE_100
862: , a4 JTF_VARCHAR2_TABLE_100

Line 859: , a1 JTF_VARCHAR2_TABLE_100

855: end if;
856: end rosetta_table_copy_out_p6;
857:
858: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table, a0 JTF_VARCHAR2_TABLE_100
859: , a1 JTF_VARCHAR2_TABLE_100
860: , a2 JTF_VARCHAR2_TABLE_100
861: , a3 JTF_VARCHAR2_TABLE_100
862: , a4 JTF_VARCHAR2_TABLE_100
863: , a5 JTF_VARCHAR2_TABLE_100

Line 860: , a2 JTF_VARCHAR2_TABLE_100

856: end rosetta_table_copy_out_p6;
857:
858: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table, a0 JTF_VARCHAR2_TABLE_100
859: , a1 JTF_VARCHAR2_TABLE_100
860: , a2 JTF_VARCHAR2_TABLE_100
861: , a3 JTF_VARCHAR2_TABLE_100
862: , a4 JTF_VARCHAR2_TABLE_100
863: , a5 JTF_VARCHAR2_TABLE_100
864: , a6 JTF_VARCHAR2_TABLE_2000

Line 861: , a3 JTF_VARCHAR2_TABLE_100

857:
858: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table, a0 JTF_VARCHAR2_TABLE_100
859: , a1 JTF_VARCHAR2_TABLE_100
860: , a2 JTF_VARCHAR2_TABLE_100
861: , a3 JTF_VARCHAR2_TABLE_100
862: , a4 JTF_VARCHAR2_TABLE_100
863: , a5 JTF_VARCHAR2_TABLE_100
864: , a6 JTF_VARCHAR2_TABLE_2000
865: , a7 JTF_NUMBER_TABLE

Line 862: , a4 JTF_VARCHAR2_TABLE_100

858: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table, a0 JTF_VARCHAR2_TABLE_100
859: , a1 JTF_VARCHAR2_TABLE_100
860: , a2 JTF_VARCHAR2_TABLE_100
861: , a3 JTF_VARCHAR2_TABLE_100
862: , a4 JTF_VARCHAR2_TABLE_100
863: , a5 JTF_VARCHAR2_TABLE_100
864: , a6 JTF_VARCHAR2_TABLE_2000
865: , a7 JTF_NUMBER_TABLE
866: , a8 JTF_VARCHAR2_TABLE_100

Line 863: , a5 JTF_VARCHAR2_TABLE_100

859: , a1 JTF_VARCHAR2_TABLE_100
860: , a2 JTF_VARCHAR2_TABLE_100
861: , a3 JTF_VARCHAR2_TABLE_100
862: , a4 JTF_VARCHAR2_TABLE_100
863: , a5 JTF_VARCHAR2_TABLE_100
864: , a6 JTF_VARCHAR2_TABLE_2000
865: , a7 JTF_NUMBER_TABLE
866: , a8 JTF_VARCHAR2_TABLE_100
867: , a9 JTF_VARCHAR2_TABLE_100

Line 866: , a8 JTF_VARCHAR2_TABLE_100

862: , a4 JTF_VARCHAR2_TABLE_100
863: , a5 JTF_VARCHAR2_TABLE_100
864: , a6 JTF_VARCHAR2_TABLE_2000
865: , a7 JTF_NUMBER_TABLE
866: , a8 JTF_VARCHAR2_TABLE_100
867: , a9 JTF_VARCHAR2_TABLE_100
868: , a10 JTF_VARCHAR2_TABLE_100
869: ) as
870: ddindx binary_integer; indx binary_integer;

Line 867: , a9 JTF_VARCHAR2_TABLE_100

863: , a5 JTF_VARCHAR2_TABLE_100
864: , a6 JTF_VARCHAR2_TABLE_2000
865: , a7 JTF_NUMBER_TABLE
866: , a8 JTF_VARCHAR2_TABLE_100
867: , a9 JTF_VARCHAR2_TABLE_100
868: , a10 JTF_VARCHAR2_TABLE_100
869: ) as
870: ddindx binary_integer; indx binary_integer;
871: begin

Line 868: , a10 JTF_VARCHAR2_TABLE_100

864: , a6 JTF_VARCHAR2_TABLE_2000
865: , a7 JTF_NUMBER_TABLE
866: , a8 JTF_VARCHAR2_TABLE_100
867: , a9 JTF_VARCHAR2_TABLE_100
868: , a10 JTF_VARCHAR2_TABLE_100
869: ) as
870: ddindx binary_integer; indx binary_integer;
871: begin
872: if a0 is not null and a0.count > 0 then

Line 897: procedure rosetta_table_copy_out_p7(t jtf_region_pub.ak_region_items_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

893: end loop;
894: end if;
895: end if;
896: end rosetta_table_copy_in_p7;
897: procedure rosetta_table_copy_out_p7(t jtf_region_pub.ak_region_items_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
898: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
899: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 898: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

894: end if;
895: end if;
896: end rosetta_table_copy_in_p7;
897: procedure rosetta_table_copy_out_p7(t jtf_region_pub.ak_region_items_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
898: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
899: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 899: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

895: end if;
896: end rosetta_table_copy_in_p7;
897: procedure rosetta_table_copy_out_p7(t jtf_region_pub.ak_region_items_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
898: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
899: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000

Line 900: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

896: end rosetta_table_copy_in_p7;
897: procedure rosetta_table_copy_out_p7(t jtf_region_pub.ak_region_items_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
898: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
899: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
904: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 901: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

897: procedure rosetta_table_copy_out_p7(t jtf_region_pub.ak_region_items_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
898: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
899: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
904: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
905: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 902: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

898: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
899: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
900: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
901: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
904: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
905: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 905: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

901: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
902: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
904: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
905: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: ) as
909: ddindx binary_integer; indx binary_integer;

Line 906: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

902: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
903: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
904: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
905: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: ) as
909: ddindx binary_integer; indx binary_integer;
910: begin

Line 907: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

903: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
904: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
905: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
906: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
907: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: ) as
909: ddindx binary_integer; indx binary_integer;
910: begin
911: if t is null or t.count = 0 then

Line 912: a0 := JTF_VARCHAR2_TABLE_100();

908: ) as
909: ddindx binary_integer; indx binary_integer;
910: begin
911: if t is null or t.count = 0 then
912: a0 := JTF_VARCHAR2_TABLE_100();
913: a1 := JTF_VARCHAR2_TABLE_100();
914: a2 := JTF_VARCHAR2_TABLE_100();
915: a3 := JTF_VARCHAR2_TABLE_100();
916: a4 := JTF_VARCHAR2_TABLE_100();

Line 913: a1 := JTF_VARCHAR2_TABLE_100();

909: ddindx binary_integer; indx binary_integer;
910: begin
911: if t is null or t.count = 0 then
912: a0 := JTF_VARCHAR2_TABLE_100();
913: a1 := JTF_VARCHAR2_TABLE_100();
914: a2 := JTF_VARCHAR2_TABLE_100();
915: a3 := JTF_VARCHAR2_TABLE_100();
916: a4 := JTF_VARCHAR2_TABLE_100();
917: a5 := JTF_VARCHAR2_TABLE_100();

Line 914: a2 := JTF_VARCHAR2_TABLE_100();

910: begin
911: if t is null or t.count = 0 then
912: a0 := JTF_VARCHAR2_TABLE_100();
913: a1 := JTF_VARCHAR2_TABLE_100();
914: a2 := JTF_VARCHAR2_TABLE_100();
915: a3 := JTF_VARCHAR2_TABLE_100();
916: a4 := JTF_VARCHAR2_TABLE_100();
917: a5 := JTF_VARCHAR2_TABLE_100();
918: a6 := JTF_VARCHAR2_TABLE_2000();

Line 915: a3 := JTF_VARCHAR2_TABLE_100();

911: if t is null or t.count = 0 then
912: a0 := JTF_VARCHAR2_TABLE_100();
913: a1 := JTF_VARCHAR2_TABLE_100();
914: a2 := JTF_VARCHAR2_TABLE_100();
915: a3 := JTF_VARCHAR2_TABLE_100();
916: a4 := JTF_VARCHAR2_TABLE_100();
917: a5 := JTF_VARCHAR2_TABLE_100();
918: a6 := JTF_VARCHAR2_TABLE_2000();
919: a7 := JTF_NUMBER_TABLE();

Line 916: a4 := JTF_VARCHAR2_TABLE_100();

912: a0 := JTF_VARCHAR2_TABLE_100();
913: a1 := JTF_VARCHAR2_TABLE_100();
914: a2 := JTF_VARCHAR2_TABLE_100();
915: a3 := JTF_VARCHAR2_TABLE_100();
916: a4 := JTF_VARCHAR2_TABLE_100();
917: a5 := JTF_VARCHAR2_TABLE_100();
918: a6 := JTF_VARCHAR2_TABLE_2000();
919: a7 := JTF_NUMBER_TABLE();
920: a8 := JTF_VARCHAR2_TABLE_100();

Line 917: a5 := JTF_VARCHAR2_TABLE_100();

913: a1 := JTF_VARCHAR2_TABLE_100();
914: a2 := JTF_VARCHAR2_TABLE_100();
915: a3 := JTF_VARCHAR2_TABLE_100();
916: a4 := JTF_VARCHAR2_TABLE_100();
917: a5 := JTF_VARCHAR2_TABLE_100();
918: a6 := JTF_VARCHAR2_TABLE_2000();
919: a7 := JTF_NUMBER_TABLE();
920: a8 := JTF_VARCHAR2_TABLE_100();
921: a9 := JTF_VARCHAR2_TABLE_100();

Line 920: a8 := JTF_VARCHAR2_TABLE_100();

916: a4 := JTF_VARCHAR2_TABLE_100();
917: a5 := JTF_VARCHAR2_TABLE_100();
918: a6 := JTF_VARCHAR2_TABLE_2000();
919: a7 := JTF_NUMBER_TABLE();
920: a8 := JTF_VARCHAR2_TABLE_100();
921: a9 := JTF_VARCHAR2_TABLE_100();
922: a10 := JTF_VARCHAR2_TABLE_100();
923: else
924: a0 := JTF_VARCHAR2_TABLE_100();

Line 921: a9 := JTF_VARCHAR2_TABLE_100();

917: a5 := JTF_VARCHAR2_TABLE_100();
918: a6 := JTF_VARCHAR2_TABLE_2000();
919: a7 := JTF_NUMBER_TABLE();
920: a8 := JTF_VARCHAR2_TABLE_100();
921: a9 := JTF_VARCHAR2_TABLE_100();
922: a10 := JTF_VARCHAR2_TABLE_100();
923: else
924: a0 := JTF_VARCHAR2_TABLE_100();
925: a1 := JTF_VARCHAR2_TABLE_100();

Line 922: a10 := JTF_VARCHAR2_TABLE_100();

918: a6 := JTF_VARCHAR2_TABLE_2000();
919: a7 := JTF_NUMBER_TABLE();
920: a8 := JTF_VARCHAR2_TABLE_100();
921: a9 := JTF_VARCHAR2_TABLE_100();
922: a10 := JTF_VARCHAR2_TABLE_100();
923: else
924: a0 := JTF_VARCHAR2_TABLE_100();
925: a1 := JTF_VARCHAR2_TABLE_100();
926: a2 := JTF_VARCHAR2_TABLE_100();

Line 924: a0 := JTF_VARCHAR2_TABLE_100();

920: a8 := JTF_VARCHAR2_TABLE_100();
921: a9 := JTF_VARCHAR2_TABLE_100();
922: a10 := JTF_VARCHAR2_TABLE_100();
923: else
924: a0 := JTF_VARCHAR2_TABLE_100();
925: a1 := JTF_VARCHAR2_TABLE_100();
926: a2 := JTF_VARCHAR2_TABLE_100();
927: a3 := JTF_VARCHAR2_TABLE_100();
928: a4 := JTF_VARCHAR2_TABLE_100();

Line 925: a1 := JTF_VARCHAR2_TABLE_100();

921: a9 := JTF_VARCHAR2_TABLE_100();
922: a10 := JTF_VARCHAR2_TABLE_100();
923: else
924: a0 := JTF_VARCHAR2_TABLE_100();
925: a1 := JTF_VARCHAR2_TABLE_100();
926: a2 := JTF_VARCHAR2_TABLE_100();
927: a3 := JTF_VARCHAR2_TABLE_100();
928: a4 := JTF_VARCHAR2_TABLE_100();
929: a5 := JTF_VARCHAR2_TABLE_100();

Line 926: a2 := JTF_VARCHAR2_TABLE_100();

922: a10 := JTF_VARCHAR2_TABLE_100();
923: else
924: a0 := JTF_VARCHAR2_TABLE_100();
925: a1 := JTF_VARCHAR2_TABLE_100();
926: a2 := JTF_VARCHAR2_TABLE_100();
927: a3 := JTF_VARCHAR2_TABLE_100();
928: a4 := JTF_VARCHAR2_TABLE_100();
929: a5 := JTF_VARCHAR2_TABLE_100();
930: a6 := JTF_VARCHAR2_TABLE_2000();

Line 927: a3 := JTF_VARCHAR2_TABLE_100();

923: else
924: a0 := JTF_VARCHAR2_TABLE_100();
925: a1 := JTF_VARCHAR2_TABLE_100();
926: a2 := JTF_VARCHAR2_TABLE_100();
927: a3 := JTF_VARCHAR2_TABLE_100();
928: a4 := JTF_VARCHAR2_TABLE_100();
929: a5 := JTF_VARCHAR2_TABLE_100();
930: a6 := JTF_VARCHAR2_TABLE_2000();
931: a7 := JTF_NUMBER_TABLE();

Line 928: a4 := JTF_VARCHAR2_TABLE_100();

924: a0 := JTF_VARCHAR2_TABLE_100();
925: a1 := JTF_VARCHAR2_TABLE_100();
926: a2 := JTF_VARCHAR2_TABLE_100();
927: a3 := JTF_VARCHAR2_TABLE_100();
928: a4 := JTF_VARCHAR2_TABLE_100();
929: a5 := JTF_VARCHAR2_TABLE_100();
930: a6 := JTF_VARCHAR2_TABLE_2000();
931: a7 := JTF_NUMBER_TABLE();
932: a8 := JTF_VARCHAR2_TABLE_100();

Line 929: a5 := JTF_VARCHAR2_TABLE_100();

925: a1 := JTF_VARCHAR2_TABLE_100();
926: a2 := JTF_VARCHAR2_TABLE_100();
927: a3 := JTF_VARCHAR2_TABLE_100();
928: a4 := JTF_VARCHAR2_TABLE_100();
929: a5 := JTF_VARCHAR2_TABLE_100();
930: a6 := JTF_VARCHAR2_TABLE_2000();
931: a7 := JTF_NUMBER_TABLE();
932: a8 := JTF_VARCHAR2_TABLE_100();
933: a9 := JTF_VARCHAR2_TABLE_100();

Line 932: a8 := JTF_VARCHAR2_TABLE_100();

928: a4 := JTF_VARCHAR2_TABLE_100();
929: a5 := JTF_VARCHAR2_TABLE_100();
930: a6 := JTF_VARCHAR2_TABLE_2000();
931: a7 := JTF_NUMBER_TABLE();
932: a8 := JTF_VARCHAR2_TABLE_100();
933: a9 := JTF_VARCHAR2_TABLE_100();
934: a10 := JTF_VARCHAR2_TABLE_100();
935: if t.count > 0 then
936: a0.extend(t.count);

Line 933: a9 := JTF_VARCHAR2_TABLE_100();

929: a5 := JTF_VARCHAR2_TABLE_100();
930: a6 := JTF_VARCHAR2_TABLE_2000();
931: a7 := JTF_NUMBER_TABLE();
932: a8 := JTF_VARCHAR2_TABLE_100();
933: a9 := JTF_VARCHAR2_TABLE_100();
934: a10 := JTF_VARCHAR2_TABLE_100();
935: if t.count > 0 then
936: a0.extend(t.count);
937: a1.extend(t.count);

Line 934: a10 := JTF_VARCHAR2_TABLE_100();

930: a6 := JTF_VARCHAR2_TABLE_2000();
931: a7 := JTF_NUMBER_TABLE();
932: a8 := JTF_VARCHAR2_TABLE_100();
933: a9 := JTF_VARCHAR2_TABLE_100();
934: a10 := JTF_VARCHAR2_TABLE_100();
935: if t.count > 0 then
936: a0.extend(t.count);
937: a1.extend(t.count);
938: a2.extend(t.count);

Line 971: procedure rosetta_table_copy_in_p8(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.short_varchar2_table, a0 JTF_VARCHAR2_TABLE_100) as

967: end if;
968: end if;
969: end rosetta_table_copy_out_p7;
970:
971: procedure rosetta_table_copy_in_p8(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.short_varchar2_table, a0 JTF_VARCHAR2_TABLE_100) as
972: ddindx binary_integer; indx binary_integer;
973: begin
974: if a0 is not null and a0.count > 0 then
975: if a0.count > 0 then

Line 989: procedure rosetta_table_copy_out_p8(t jtf_region_pub.short_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100) as

985: end loop;
986: end if;
987: end if;
988: end rosetta_table_copy_in_p8;
989: procedure rosetta_table_copy_out_p8(t jtf_region_pub.short_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100) as
990: ddindx binary_integer; indx binary_integer;
991: begin
992: if t is null or t.count = 0 then
993: a0 := JTF_VARCHAR2_TABLE_100();

Line 993: a0 := JTF_VARCHAR2_TABLE_100();

989: procedure rosetta_table_copy_out_p8(t jtf_region_pub.short_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100) as
990: ddindx binary_integer; indx binary_integer;
991: begin
992: if t is null or t.count = 0 then
993: a0 := JTF_VARCHAR2_TABLE_100();
994: else
995: a0 := JTF_VARCHAR2_TABLE_100();
996: if t.count > 0 then
997: a0.extend(t.count);

Line 995: a0 := JTF_VARCHAR2_TABLE_100();

991: begin
992: if t is null or t.count = 0 then
993: a0 := JTF_VARCHAR2_TABLE_100();
994: else
995: a0 := JTF_VARCHAR2_TABLE_100();
996: if t.count > 0 then
997: a0.extend(t.count);
998: ddindx := t.first;
999: indx := 1;

Line 1094: procedure get_regions(p_get_region_codes JTF_VARCHAR2_TABLE_100

1090: end if;
1091: end if;
1092: end rosetta_table_copy_out_p10;
1093:
1094: procedure get_regions(p_get_region_codes JTF_VARCHAR2_TABLE_100
1095: , p_get_application_id NUMBER
1096: , p_get_responsibility_ids JTF_NUMBER_TABLE
1097: , p_skip_column_name number
1098: , p_lang OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1099: , p_ret_region_codes OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1095: , p_get_application_id NUMBER
1096: , p_get_responsibility_ids JTF_NUMBER_TABLE
1097: , p_skip_column_name number
1098: , p_lang OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1099: , p_ret_region_codes OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1100: , p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1101: , p_ret_object_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1102: , p_ret_region_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1103: , p_ret_region_description OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000

Line 1101: , p_ret_object_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1097: , p_skip_column_name number
1098: , p_lang OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1099: , p_ret_region_codes OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1100: , p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1101: , p_ret_object_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1102: , p_ret_region_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1103: , p_ret_region_description OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1104: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1105: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1102: , p_ret_region_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1098: , p_lang OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1099: , p_ret_region_codes OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1100: , p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1101: , p_ret_object_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1102: , p_ret_region_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1103: , p_ret_region_description OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1104: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1105: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1106: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1104: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1100: , p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1101: , p_ret_object_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1102: , p_ret_region_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1103: , p_ret_region_description OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1104: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1105: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1106: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1107: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1108: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1105: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1101: , p_ret_object_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1102: , p_ret_region_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1103: , p_ret_region_description OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1104: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1105: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1106: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1107: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1108: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1109: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1106: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1102: , p_ret_region_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1103: , p_ret_region_description OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1104: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1105: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1106: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1107: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1108: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1109: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1110: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000

Line 1107: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1103: , p_ret_region_description OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1104: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1105: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1106: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1107: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1108: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1109: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1110: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1111: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 1108: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1104: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1105: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1106: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1107: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1108: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1109: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1110: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1111: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1112: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1109: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1105: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1106: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1107: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1108: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1109: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1110: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1111: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1112: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1113: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1112: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1108: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1109: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1110: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1111: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1112: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1113: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1114: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1115: )
1116:

Line 1113: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1109: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1110: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1111: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1112: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1113: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1114: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1115: )
1116:
1117: as

Line 1114: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1110: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1111: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1112: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1113: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1114: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1115: )
1116:
1117: as
1118: ddp_get_region_codes jtf_region_pub.short_varchar2_table;

Line 1199: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1195: , p_responsibility_id NUMBER
1196: , p_object_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1197: , p_region_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1198: , p_region_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1199: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1200: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1201: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1202: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1203: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1200: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1196: , p_object_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1197: , p_region_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1198: , p_region_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1199: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1200: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1201: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1202: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1203: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1204: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1201: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1197: , p_region_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1198: , p_region_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1199: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1200: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1201: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1202: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1203: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1204: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1205: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000

Line 1202: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1198: , p_region_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1199: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1200: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1201: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1202: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1203: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1204: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1205: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1206: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 1203: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1199: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1200: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1201: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1202: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1203: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1204: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1205: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1206: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1207: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1204: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1200: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1201: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1202: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1203: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1204: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1205: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1206: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1207: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1208: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1207: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1203: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1204: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1205: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1206: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1207: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1208: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1209: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1210: )
1211:

Line 1208: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1204: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1205: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1206: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1207: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1208: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1209: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1210: )
1211:
1212: as

Line 1209: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1205: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
1206: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1207: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1208: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1209: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1210: )
1211:
1212: as
1213: ddp_region_items_table jtf_region_pub.ak_region_items_table;

Line 1264: , p9_a0 JTF_VARCHAR2_TABLE_100

1260: , p_user_id NUMBER
1261: , p_range_low NUMBER
1262: , p_range_high NUMBER
1263: , p_max_rows IN OUT NOCOPY /* file.sql.39 change */ NUMBER
1264: , p9_a0 JTF_VARCHAR2_TABLE_100
1265: , p9_a1 JTF_VARCHAR2_TABLE_300
1266: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1267: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1268: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 1267: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

1263: , p_max_rows IN OUT NOCOPY /* file.sql.39 change */ NUMBER
1264: , p9_a0 JTF_VARCHAR2_TABLE_100
1265: , p9_a1 JTF_VARCHAR2_TABLE_300
1266: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
1267: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1268: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1269: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1270: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
1271: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300