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_NUMBER_TABLE

Line 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

754: end if;
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

Line 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

775: end loop;
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

Line 785: a0 := JTF_NUMBER_TABLE();

781: ) as
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();

Line 788: a0 := JTF_NUMBER_TABLE();

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
791: a0.extend(t.count);
792: a1.extend(t.count);

Line 865: , a7 JTF_NUMBER_TABLE

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
868: , a10 JTF_VARCHAR2_TABLE_100
869: ) as

Line 904: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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
907: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
908: ) as

Line 919: a7 := JTF_NUMBER_TABLE();

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();
922: a10 := JTF_VARCHAR2_TABLE_100();
923: else

Line 931: a7 := JTF_NUMBER_TABLE();

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();
934: a10 := JTF_VARCHAR2_TABLE_100();
935: if t.count > 0 then

Line 1053: procedure rosetta_table_copy_in_p10(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.number_table, a0 JTF_NUMBER_TABLE) as

1049: end if;
1050: end if;
1051: end rosetta_table_copy_out_p9;
1052:
1053: procedure rosetta_table_copy_in_p10(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.number_table, a0 JTF_NUMBER_TABLE) as
1054: ddindx binary_integer; indx binary_integer;
1055: begin
1056: if a0 is not null and a0.count > 0 then
1057: if a0.count > 0 then

Line 1071: procedure rosetta_table_copy_out_p10(t jtf_region_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE) as

1067: end loop;
1068: end if;
1069: end if;
1070: end rosetta_table_copy_in_p10;
1071: procedure rosetta_table_copy_out_p10(t jtf_region_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE) as
1072: ddindx binary_integer; indx binary_integer;
1073: begin
1074: if t is null or t.count = 0 then
1075: a0 := JTF_NUMBER_TABLE();

Line 1075: a0 := JTF_NUMBER_TABLE();

1071: procedure rosetta_table_copy_out_p10(t jtf_region_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE) as
1072: ddindx binary_integer; indx binary_integer;
1073: begin
1074: if t is null or t.count = 0 then
1075: a0 := JTF_NUMBER_TABLE();
1076: else
1077: a0 := JTF_NUMBER_TABLE();
1078: if t.count > 0 then
1079: a0.extend(t.count);

Line 1077: a0 := JTF_NUMBER_TABLE();

1073: begin
1074: if t is null or t.count = 0 then
1075: a0 := JTF_NUMBER_TABLE();
1076: else
1077: a0 := JTF_NUMBER_TABLE();
1078: if t.count > 0 then
1079: a0.extend(t.count);
1080: ddindx := t.first;
1081: indx := 1;

Line 1096: , p_get_responsibility_ids JTF_NUMBER_TABLE

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
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

Line 1100: , p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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
1104: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 1111: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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
1114: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1115: )

Line 1206: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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
1209: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
1210: )

Line 1266: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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
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