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 1970: FROM HZ_LOCATIONS

1966: WHERE party_site_id = l_ps_id;
1967:
1968: CURSOR is_location_exist(l_loc_id NUMBER) IS
1969: SELECT 'X'
1970: FROM HZ_LOCATIONS
1971: WHERE location_id = l_loc_id;
1972:
1973: CURSOR is_party_exist(l_party_id NUMBER) IS
1974: SELECT 'X'

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

2050: FND_MSG_PUB.ADD;
2051: RETURN 'E';
2052: END IF;
2053: l_dummy := 'X';
2054: ELSIF(p_entity_type = 'HZ_LOCATIONS') THEN
2055: OPEN is_location_exist(p_entity_id);
2056: FETCH is_location_exist INTO l_dummy;
2057: CLOSE is_location_exist;
2058: ELSIF(p_entity_type = 'HZ_PARTIES') THEN

Line 2299: RETURN 'HZ_LOCATIONS';

2295: RETURN 'HZ_CUST_ACCT_SITES_ALL';
2296: ELSIF(p_obj_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EDI', 'EFT', 'SMS')) THEN
2297: RETURN 'HZ_CONTACT_POINTS';
2298: ELSIF(p_obj_type = 'LOCATION') THEN
2299: RETURN 'HZ_LOCATIONS';
2300: ELSIF(p_obj_type = 'CUST_ACCT_SITE_USE') THEN
2301: RETURN 'HZ_CUST_SITE_USES_ALL';
2302: END IF;
2303: RETURN NULL;

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

2700: ELSIF(p_bus_object.business_object_code(i) = 'LOCATION' AND
2701: p_bus_object.user_mandated_flag(i) = 'Y' AND
2702: p_bus_object.tca_mandated_flag(i) = 'N' AND
2703: p_bus_object.child_bo_code(i) IS NULL) THEN
2704: IF p_bus_object.entity_name(i) = 'HZ_LOCATIONS_EXT_VL' THEN
2705: l_loc_ext := TRUE;
2706: END IF;
2707: END IF;
2708: END LOOP;