43: debug(' location_id : '||p_location_id);
44:
45: IF p_location_type_code IN ('INVENTORY', 'INTERNAL_SITE') THEN
46: l_location_table := 'HR_LOCATIONS';
47: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN
48: BEGIN
49: SELECT 'Y' INTO l_hz_or_hr
50: FROM hz_locations
51: WHERE location_id = p_location_id;
46: l_location_table := 'HR_LOCATIONS';
47: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN
48: BEGIN
49: SELECT 'Y' INTO l_hz_or_hr
50: FROM hz_locations
51: WHERE location_id = p_location_id;
52: l_location_table := 'HZ_LOCATIONS';
53: EXCEPTION
54: WHEN no_data_found THEN
48: BEGIN
49: SELECT 'Y' INTO l_hz_or_hr
50: FROM hz_locations
51: WHERE location_id = p_location_id;
52: l_location_table := 'HZ_LOCATIONS';
53: EXCEPTION
54: WHEN no_data_found THEN
55: l_location_table := 'HR_LOCATIONS';
56: END;
328: x_hz_location_id => l_location_id,
329: x_Return_Status => l_return_status,
330: x_Error_Message => l_error_message );
331:
332: l_location_type_code := 'HZ_LOCATIONS';
333:
334: END IF;
335:
336: get_fa_location_id(