APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_LOCATIONS

Line 382: FROM HZ_LOCATIONS

378: WHERE party_site_id = l_ps_id;
379:
380: CURSOR is_loc_valid(l_loc_id NUMBER) IS
381: SELECT 'X'
382: FROM HZ_LOCATIONS
383: WHERE location_id = l_loc_id;
384:
385: CURSOR is_cr_valid(l_cr_id NUMBER) IS
386: SELECT 'X'

Line 454: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN

450: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNT_ROLES') THEN
451: OPEN is_cr_valid(px_id);
452: FETCH is_cr_valid INTO l_valid_id;
453: CLOSE is_cr_valid;
454: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN
455: OPEN is_loc_valid(px_id);
456: FETCH is_loc_valid INTO l_valid_id;
457: CLOSE is_loc_valid;
458: ELSIF(p_obj_type = 'HZ_PARTY_SITES') THEN

Line 1975: FROM HZ_LOCATIONS

1971: WHERE party_site_id = l_ps_id;
1972:
1973: CURSOR is_location_exist(l_loc_id NUMBER) IS
1974: SELECT 'X'
1975: FROM HZ_LOCATIONS
1976: WHERE location_id = l_loc_id;
1977:
1978: CURSOR is_party_exist(l_party_id NUMBER) IS
1979: SELECT 'X'

Line 2059: ELSIF(p_entity_type = 'HZ_LOCATIONS') THEN

2055: FND_MSG_PUB.ADD;
2056: RETURN 'E';
2057: END IF;
2058: l_dummy := 'X';
2059: ELSIF(p_entity_type = 'HZ_LOCATIONS') THEN
2060: OPEN is_location_exist(p_entity_id);
2061: FETCH is_location_exist INTO l_dummy;
2062: CLOSE is_location_exist;
2063: ELSIF(p_entity_type = 'HZ_PARTIES') THEN

Line 2304: RETURN 'HZ_LOCATIONS';

2300: RETURN 'HZ_CUST_ACCT_SITES_ALL';
2301: ELSIF(p_obj_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EDI', 'EFT', 'SMS')) THEN
2302: RETURN 'HZ_CONTACT_POINTS';
2303: ELSIF(p_obj_type = 'LOCATION') THEN
2304: RETURN 'HZ_LOCATIONS';
2305: ELSIF(p_obj_type = 'CUST_ACCT_SITE_USE') THEN
2306: RETURN 'HZ_CUST_SITE_USES_ALL';
2307: END IF;
2308: RETURN NULL;

Line 2709: IF p_bus_object.entity_name(i) = 'HZ_LOCATIONS_EXT_VL' THEN

2705: ELSIF(p_bus_object.business_object_code(i) = 'LOCATION' AND
2706: p_bus_object.user_mandated_flag(i) = 'Y' AND
2707: p_bus_object.tca_mandated_flag(i) = 'N' AND
2708: p_bus_object.child_bo_code(i) IS NULL) THEN
2709: IF p_bus_object.entity_name(i) = 'HZ_LOCATIONS_EXT_VL' THEN
2710: l_loc_ext := TRUE;
2711: END IF;
2712: END IF;
2713: END LOOP;