371: * Resolves the location code
372: *
373: * ARGUMENTS
374: * p_location_id Unique identifier for the location in
375: * HR_LOCATIONS table.
376: *
377: * NOTES
378: * Return NULL if no matching records were found.
379: *
383: ********************************************************************/
384: FUNCTION get_location( p_location_id IN NUMBER )
385: RETURN VARCHAR2 AS
386:
387: v_location_code hr_locations.location_code%TYPE;
388: v_progress varchar2(3);
389:
390: BEGIN
391:
392: v_progress := '090';
393:
394: SELECT location_code
395: INTO v_location_code
396: FROM hr_locations
397: WHERE location_id = p_location_id;
398:
399: RETURN v_location_code;
400: