APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on HZ_LOCATIONS

Line 25: , hz_locations l

21: FROM jtf_rs_resource_extns_vl r
22: , per_people_f pf
23: , hz_parties p
24: , hz_party_sites s
25: , hz_locations l
26: , fnd_territories_vl t
27: WHERE r.resource_id = :resource_id
28: AND pf.person_id = r.source_id
29: AND pf.party_id = p.party_id (+)

Line 52: , hz_locations l

48: , s.start_date_active
49: , s.end_date_active
50: FROM jtf_rs_resource_extns_vl r
51: , hz_party_sites s
52: , hz_locations l
53: , fnd_territories_vl t
54: WHERE r.resource_id = :resource_id
55: AND r.source_id = s.party_id (+)
56: AND NVL(s.status, ''A'') = ''A''

Line 77: , hz_locations l

73: , s.start_date_active
74: , s.end_date_active
75: FROM hz_parties p
76: , hz_party_sites s
77: , hz_locations l
78: , fnd_territories_vl t
79: WHERE p.person_last_name = :res_type_id_string
80: AND p.person_first_name = :dep_arr_party_name
81: AND s.party_id = p.party_id

Line 133: l_address_line hz_locations.address1%TYPE;

129: * The logic followed is exactly as given in BuildingNum.isBuildingNumber (BuildingNum.java).
130: */
131: FUNCTION is_address_line_valid(p_address_line IN VARCHAR2, p_country_code VARCHAR2)
132: RETURN BOOLEAN IS
133: l_address_line hz_locations.address1%TYPE;
134: l_first_word hz_locations.address1%TYPE;
135: l_count_words NUMBER;
136: l_sep_index NUMBER;
137: BEGIN

Line 134: l_first_word hz_locations.address1%TYPE;

130: */
131: FUNCTION is_address_line_valid(p_address_line IN VARCHAR2, p_country_code VARCHAR2)
132: RETURN BOOLEAN IS
133: l_address_line hz_locations.address1%TYPE;
134: l_first_word hz_locations.address1%TYPE;
135: l_count_words NUMBER;
136: l_sep_index NUMBER;
137: BEGIN
138: l_address_line := trim(p_address_line);

Line 250: l_roadname hz_locations.address1%TYPE;

246: l_resultarray csf_lf_pub.csf_lf_resultarray;
247: l_update_addr BOOLEAN;
248: l_update_geo BOOLEAN;
249: l_call_lf BOOLEAN;
250: l_roadname hz_locations.address1%TYPE;
251: l_location_ovn NUMBER;
252: l_location_rec hz_location_v2pub.location_rec_type;
253: l_road VARCHAR2(200);
254:

Line 257: FROM HZ_LOCATIONS

253: l_road VARCHAR2(200);
254:
255: CURSOR c_location_locking_info IS
256: SELECT object_version_number
257: FROM HZ_LOCATIONS
258: WHERE LOCATION_ID = p_location_id;
259:
260: BEGIN
261: SAVEPOINT resolve_address_pub;

Line 423: -- hz_locations)

419: FETCH c_location_locking_info INTO l_location_ovn;
420: CLOSE c_location_locking_info;
421:
422: -- Updating the location record (it updates both hz_parties and
423: -- hz_locations)
424: hz_location_v2pub.update_location(
425: p_location_rec => l_location_rec
426: , p_object_version_number => l_location_ovn
427: , x_return_status => x_return_status

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

732: x_return_status := fnd_api.g_ret_sts_success;
733:
734: SAVEPOINT create_party;
735:
736: -- Street and Country are NOT NULL columns in HZ_LOCATIONS
737: IF p_address.country IS NULL THEN
738: l_location_rec.address1 := '_';
739: OPEN c_terr;
740: FETCH c_terr INTO l_location_rec.country;

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

751: l_location_rec.country := p_address.country;
752: END IF;
753:
754: IF l_debug THEN
755: debug('Creating Location Record in HZ_LOCATIONS', l_api_name, fnd_log.level_statement);
756: debug(' --> Address1 = ' || l_location_rec.address1, l_api_name, fnd_log.level_statement);
757: debug(' --> City = ' || l_location_rec.city, l_api_name, fnd_log.level_statement);
758: debug(' --> State = ' || l_location_rec.state, l_api_name, fnd_log.level_statement);
759: debug(' --> Zip = ' || l_location_rec.postal_code, l_api_name, fnd_log.level_statement);