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.CSF_RESOURCE_ADDRESS_PVT dependencies on HZ_LOCATIONS

Line 31: , hz_locations l

27: FROM jtf_rs_resource_extns_vl r
28: , per_people_f pf
29: , hz_parties p
30: , hz_party_sites s
31: , hz_locations l
32: , fnd_territories_vl t
33: WHERE r.resource_id = :resource_id
34: AND pf.person_id = r.source_id
35: AND pf.party_id = p.party_id (+)

Line 58: , hz_locations l

54: , s.start_date_active
55: , s.end_date_active
56: FROM jtf_rs_resource_extns_vl r
57: , hz_party_sites s
58: , hz_locations l
59: , fnd_territories_vl t
60: WHERE r.resource_id = :resource_id
61: AND r.source_id = s.party_id (+)
62: AND NVL(s.status, ''A'') = ''A''

Line 83: , hz_locations l

79: , s.start_date_active
80: , s.end_date_active
81: FROM hz_parties p
82: , hz_party_sites s
83: , hz_locations l
84: , fnd_territories_vl t
85: WHERE p.person_last_name = :res_type_id_string
86: AND p.person_first_name = :dep_arr_party_name
87: AND s.party_id = p.party_id

Line 107: from hz_locations hzl,

103: , t.territory_short_name
104: , hzl.geometry
105: , hps.start_date_active
106: , hps.end_date_active
107: from hz_locations hzl,
108: hz_party_sites hps,
109: hz_cust_acct_sites hzacs,
110: hz_cust_site_uses hzacus,
111: hz_parties hp,

Line 174: l_address_line hz_locations.address1%TYPE;

170: * The logic followed is exactly as given in BuildingNum.isBuildingNumber (BuildingNum.java).
171: */
172: FUNCTION is_address_line_valid(p_address_line IN VARCHAR2, p_country_code VARCHAR2)
173: RETURN BOOLEAN IS
174: l_address_line hz_locations.address1%TYPE;
175: l_first_word hz_locations.address1%TYPE;
176: l_count_words NUMBER;
177: l_sep_index NUMBER;
178: BEGIN

Line 175: l_first_word hz_locations.address1%TYPE;

171: */
172: FUNCTION is_address_line_valid(p_address_line IN VARCHAR2, p_country_code VARCHAR2)
173: RETURN BOOLEAN IS
174: l_address_line hz_locations.address1%TYPE;
175: l_first_word hz_locations.address1%TYPE;
176: l_count_words NUMBER;
177: l_sep_index NUMBER;
178: BEGIN
179: l_address_line := trim(p_address_line);

Line 309: l_roadname hz_locations.address1%TYPE;

305: l_resultarray csf_lf_pub.csf_lf_resultarray;
306: l_update_addr BOOLEAN;
307: l_update_geo BOOLEAN := FALSE;
308: l_call_lf BOOLEAN;
309: l_roadname hz_locations.address1%TYPE;
310: l_location_ovn NUMBER;
311: l_location_rec hz_location_v2pub.location_rec_type;
312: l_road VARCHAR2(200);
313: l_geometry MDSYS.SDO_GEOMETRY := NULL;

Line 314: l_geom_status_code hz_locations.geometry_status_code%TYPE := NULL;

310: l_location_ovn NUMBER;
311: l_location_rec hz_location_v2pub.location_rec_type;
312: l_road VARCHAR2(200);
313: l_geometry MDSYS.SDO_GEOMETRY := NULL;
314: l_geom_status_code hz_locations.geometry_status_code%TYPE := NULL;
315: l_msg_data VARCHAR2(200);
316: l_existing_geom_seg_id NUMBER;
317:
318: CURSOR c_location_locking_info IS

Line 320: FROM HZ_LOCATIONS

316: l_existing_geom_seg_id NUMBER;
317:
318: CURSOR c_location_locking_info IS
319: SELECT object_version_number, geometry, geometry_status_code
320: FROM HZ_LOCATIONS
321: WHERE LOCATION_ID = p_location_id;
322:
323: BEGIN
324: SAVEPOINT resolve_address_pub;

Line 539: -- hz_locations)

535: l_location_rec.location_id := p_location_id;
536: l_location_rec.created_by_module := null;
537:
538: -- Updating the location record (it updates both hz_parties and
539: -- hz_locations)
540:
541: update_location(
542: p_location_rec => l_location_rec
543: , p_object_version_number => l_location_ovn

Line 873: -- Street and Country are NOT NULL columns in HZ_LOCATIONS

869: x_return_status := fnd_api.g_ret_sts_success;
870:
871: -- SAVEPOINT create_party;
872:
873: -- Street and Country are NOT NULL columns in HZ_LOCATIONS
874: IF p_address.country IS NULL THEN
875: l_location_rec.address1 := '_';
876: OPEN c_terr;
877: FETCH c_terr INTO l_location_rec.country;

Line 894: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);

890: -- l_location_rec.province := p_address.province;
891: END IF;
892:
893: IF l_debug THEN
894: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
895: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
896: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
897: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
898: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);

Line 1375: -- Street and Country are NOT NULL columns in HZ_LOCATIONS

1371: x_return_status := fnd_api.g_ret_sts_success;
1372:
1373: SAVEPOINT create_party;
1374:
1375: -- Street and Country are NOT NULL columns in HZ_LOCATIONS
1376: IF p_address.country IS NULL THEN
1377: l_location_rec.address1 := '_';
1378: OPEN c_terr;
1379: FETCH c_terr INTO l_location_rec.country;

Line 1406: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);

1402:
1403: END IF;
1404:
1405: IF l_debug THEN
1406: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
1407: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
1408: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
1409: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
1410: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);

Line 1617: , hz_locations hl

1613: t.territory_short_name,
1614: HPS.START_DATE_ACTIVE,
1615: HPS.END_DATE_ACTIVE
1616: FROM csp_rs_cust_relations csc
1617: , hz_locations hl
1618: , fnd_territories_vl t
1619: , hz_party_sites hps
1620: WHERE csc.resource_id=p_resource_id
1621: AND csc.resource_type = p_resource_type