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.PV_LOCATOR dependencies on JTF_NUMBER_TABLE

Line 60: ,p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE

56: ,p_max_no_partners IN NUMBER
57: ,p_distance IN NUMBER
58: ,p_distance_unit IN VARCHAR2
59: ,p_sql_query IN VARCHAR2
60: ,p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE
61: ,p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000
62: ,p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: ,p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 64: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE

60: ,p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE
61: ,p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000
62: ,p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: ,p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE
65: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE
66: ,x_return_status OUT NOCOPY VARCHAR2
67: ,x_msg_count OUT NOCOPY NUMBER
68: ,x_msg_data OUT NOCOPY VARCHAR2

Line 65: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE

61: ,p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000
62: ,p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
63: ,p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
64: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE
65: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE
66: ,x_return_status OUT NOCOPY VARCHAR2
67: ,x_msg_count OUT NOCOPY NUMBER
68: ,x_msg_data OUT NOCOPY VARCHAR2
69: )

Line 108: x_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

104: l_customer_geocode_object HZ_LOCATIONS.GEOMETRY%TYPE;
105: l_query VARCHAR2(4000);
106: l_string VARCHAR2(4000);
107: l_skip_server VARCHAR2(4000);
108: x_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
109:
110:
111: cursor l_parties_cursor(l_geo HZ_LOCATIONS.GEOMETRY%TYPE
112: ,l_dist_unit VARCHAR2

Line 113: ,x_matched_id JTF_NUMBER_TABLE

109:
110:
111: cursor l_parties_cursor(l_geo HZ_LOCATIONS.GEOMETRY%TYPE
112: ,l_dist_unit VARCHAR2
113: ,x_matched_id JTF_NUMBER_TABLE
114: ,p_distance NUMBER
115: ,p_customer_city VARCHAR2) is
116: select * from
117: (

Line 125: (SELECT column_value party_id FROM TABLE (CAST( x_matched_id AS JTF_NUMBER_TABLE)) ) p

121: org.url, cp.phone_country_code, cp.phone_area_code, cp.phone_number, rownum rn
122: from
123: (
124: select p.party_id from
125: (SELECT column_value party_id FROM TABLE (CAST( x_matched_id AS JTF_NUMBER_TABLE)) ) p
126: ) tmp,
127: hz_parties org,
128: hz_party_sites hzs,
129: hz_locations hzl,

Line 360: x_partner_tbl := JTF_NUMBER_TABLE();

356: ELSE
357: l_return_partner_tbl := l_partner_tbl;
358: END IF;
359:
360: x_partner_tbl := JTF_NUMBER_TABLE();
361: x_distance_tbl := JTF_NUMBER_TABLE();
362:
363: FOR i in 1 .. l_return_partner_tbl.count LOOP
364: x_partner_tbl.extend;

Line 361: x_distance_tbl := JTF_NUMBER_TABLE();

357: l_return_partner_tbl := l_partner_tbl;
358: END IF;
359:
360: x_partner_tbl := JTF_NUMBER_TABLE();
361: x_distance_tbl := JTF_NUMBER_TABLE();
362:
363: FOR i in 1 .. l_return_partner_tbl.count LOOP
364: x_partner_tbl.extend;
365: x_distance_tbl.extend;

Line 444: ,p_partner_tbl IN JTF_NUMBER_TABLE

440: ,p_commit IN VARCHAR2 := FND_API.g_false
441: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
442:
443: ,p_customer_address IN party_address_rec_type
444: ,p_partner_tbl IN JTF_NUMBER_TABLE
445: ,p_max_no_partners IN NUMBER
446: ,p_distance IN NUMBER
447: ,p_distance_unit IN VARCHAR2
448: ,p_sort_by_distance IN VARCHAR2 := 'T'

Line 449: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE

445: ,p_max_no_partners IN NUMBER
446: ,p_distance IN NUMBER
447: ,p_distance_unit IN VARCHAR2
448: ,p_sort_by_distance IN VARCHAR2 := 'T'
449: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE
450: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE
451: ,x_distance_unit OUT NOCOPY VARCHAR2
452: ,x_return_status OUT NOCOPY VARCHAR2
453: ,x_msg_count OUT NOCOPY NUMBER

Line 450: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE

446: ,p_distance IN NUMBER
447: ,p_distance_unit IN VARCHAR2
448: ,p_sort_by_distance IN VARCHAR2 := 'T'
449: ,x_partner_tbl OUT NOCOPY JTF_NUMBER_TABLE
450: ,x_distance_tbl OUT NOCOPY JTF_NUMBER_TABLE
451: ,x_distance_unit OUT NOCOPY VARCHAR2
452: ,x_return_status OUT NOCOPY VARCHAR2
453: ,x_msg_count OUT NOCOPY NUMBER
454: ,x_msg_data OUT NOCOPY VARCHAR2

Line 624: x_partner_tbl := JTF_NUMBER_TABLE();

620:
621:
622:
623: x_distance_unit :=l_distance_unit;
624: x_partner_tbl := JTF_NUMBER_TABLE();
625: x_distance_tbl := JTF_NUMBER_TABLE();
626: FOR i in 1 .. p_partner_tbl.count LOOP
627: x_partner_tbl.extend;
628: x_distance_tbl.extend;

Line 625: x_distance_tbl := JTF_NUMBER_TABLE();

621:
622:
623: x_distance_unit :=l_distance_unit;
624: x_partner_tbl := JTF_NUMBER_TABLE();
625: x_distance_tbl := JTF_NUMBER_TABLE();
626: FOR i in 1 .. p_partner_tbl.count LOOP
627: x_partner_tbl.extend;
628: x_distance_tbl.extend;
629: x_partner_tbl(i):=p_partner_tbl(i);

Line 722: ' FROM TABLE (CAST(:p_partner_tbl AS JTF_NUMBER_TABLE))))) c ' ||

718: ' pv_partner_profiles pvpp, '||
719: ' (SELECT * ' ||
720: ' FROM (SELECT column_value party_id ' ||
721: ' FROM (SELECT column_value ' ||
722: ' FROM TABLE (CAST(:p_partner_tbl AS JTF_NUMBER_TABLE))))) c ' ||
723: ' where pvpp.partner_id = c.party_id ' ||
724: ' and org.party_id (+) = pvpp.partner_party_id '||
725: ' and org.party_type (+) = '||''''||'ORGANIZATION'||''''||
726: ' and org.party_id = hzs.party_id (+) '||

Line 780: FROM TABLE(CAST(:p_partner_tbl AS JTF_NUMBER_TABLE))))) c

776: pv_partner_profiles pvpp,
777: (SELECT *
778: FROM (SELECT column_value party_id
779: FROM (SELECT column_value
780: FROM TABLE(CAST(:p_partner_tbl AS JTF_NUMBER_TABLE))))) c
781: WHERE pvpp.partner_id = c.party_id and
782: org.party_id (+) = pvpp.partner_party_id and
783: org.party_type (+) = 'ORGANIZATION' and
784: org.party_id = hzs.party_id (+) and

Line 909: x_partner_tbl := JTF_NUMBER_TABLE();

905: );
906: END IF;
907:
908: x_distance_unit :=l_distance_unit;
909: x_partner_tbl := JTF_NUMBER_TABLE();
910: x_distance_tbl := JTF_NUMBER_TABLE();
911: FOR i in 1 .. l_return_final_partner_tbl.count LOOP
912: x_partner_tbl.extend;
913: x_distance_tbl.extend;

Line 910: x_distance_tbl := JTF_NUMBER_TABLE();

906: END IF;
907:
908: x_distance_unit :=l_distance_unit;
909: x_partner_tbl := JTF_NUMBER_TABLE();
910: x_distance_tbl := JTF_NUMBER_TABLE();
911: FOR i in 1 .. l_return_final_partner_tbl.count LOOP
912: x_partner_tbl.extend;
913: x_distance_tbl.extend;
914: x_partner_tbl(i):=l_return_final_partner_tbl(i).party_relation_id;