127: BEGIN
128:
129:
130: SELECT 1 INTO l_count
131: FROM hr_locations_all
132: WHERE location_code = p_location_code AND business_group_id = l_business_grp_id;
133:
134:
135: RETURN true;
160: BEGIN
161:
162: SELECT location_id, object_version_number
163: INTO p_location_id, p_object_version_number
164: FROM hr_locations_all
165: WHERE location_code = p_location_code;
166:
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
204: l_location_id NUMBER;
205: BEGIN
206:
207: SELECT location_id INTO l_location_id
208: FROM hr_locations_all
209: WHERE location_code = p_location_code;
210:
211: RETURN l_location_id;
212: EXCEPTION