APPS.HZ_MAP_PARTY_PUB dependencies on HZ_LOCATIONS

Line 1019: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_LOCATIONS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

1015: * Policy functions will not be added to non-profile entities as the concept of
1016: * select/de-select data sources for other entities is obsoleted.
1017:
1018: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_RELATIONSHIPS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1019: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_LOCATIONS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1020: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CONTACT_POINTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1021: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CREDIT_RATINGS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1022: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_REPORTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1023: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_NUMBERS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

Line 4043: FROM hz_party_sites ps, hz_locations loc

4039:
4040: -- Bug 2882305 : Add address1 to select statement
4041: SELECT ps.location_id, ps.party_site_id, loc.object_version_number,loc.address1
4042: INTO p_location_rec.location_id, l_party_site_id, l_object_version_number, l_address1
4043: FROM hz_party_sites ps, hz_locations loc
4044: WHERE ps.party_id = p_party_id
4045: AND ps.location_id = loc.location_id
4046: AND loc.actual_content_source = p_location_rec.actual_content_source
4047: AND ps.end_date_active is NULL

Line 4065: FROM hz_party_sites ps, hz_locations loc

4061: -- if the existing location record has same taxable components, update this record
4062:
4063: /* SELECT ps.location_id, loc.object_version_number
4064: INTO p_location_rec.location_id, l_object_version_number
4065: FROM hz_party_sites ps, hz_locations loc
4066: WHERE ps.party_id = p_party_id
4067: AND ps.location_id = loc.location_id
4068: AND loc.actual_content_source = p_location_rec.actual_content_source
4069: AND UPPER(loc.ADDRESS1 || loc.ADDRESS2 || loc.ADDRESS3 || loc.ADDRESS4 ||

Line 4185: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;

4181: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
4182: l_msg_count NUMBER;
4183: l_msg_data VARCHAR2(2000);
4184: -- l_party_site_exist VARCHAR2(1) := 'N';
4185: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
4186:
4187: BEGIN
4188: -- Bug 3417357 : If p_create_new = TRUE, its a new party. ALWAYS create a new
4189: -- location for new party. For party being enriched, if location is not chagned,

Line 4215: FROM hz_locations

4211: --use decode function for address2, etc. because we already assigned
4212: --G_MISS_XXX to those columns.
4213: --select by UPPER(ADDRESS1) to prevent dulicate.
4214: SELECT location_id INTO p_location_rec.location_id
4215: FROM hz_locations
4216: WHERE UPPER(ADDRESS1) = UPPER(p_location_rec.ADDRESS1) AND
4217: UPPER(NVL(ADDRESS2, FND_API.G_MISS_CHAR)) = UPPER(decode(p_location_rec.ADDRESS2, NULL, FND_API.G_MISS_CHAR, p_location_rec.ADDRESS2)) AND
4218: UPPER(NVL(ADDRESS3, FND_API.G_MISS_CHAR)) = UPPER(decode(p_location_rec.ADDRESS3, NULL, FND_API.G_MISS_CHAR, p_location_rec.ADDRESS3)) AND
4219: UPPER(NVL(ADDRESS4, FND_API.G_MISS_CHAR)) = UPPER(decode(p_location_rec.ADDRESS4, NULL, FND_API.G_MISS_CHAR, p_location_rec.ADDRESS4)) AND