186: -- Access : Public --
187: -- Description : This function gets the gre location details --
188: -- --
189: -- Parameters : --
190: -- IN : p_location_id hr_locations.location_id --
191: -- : p_concatenate VARCHAR2 --
192: -- p_field VARCHAR2 --
193: --------------------------------------------------------------------------
194: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE
190: -- IN : p_location_id hr_locations.location_id --
191: -- : p_concatenate VARCHAR2 --
192: -- p_field VARCHAR2 --
193: --------------------------------------------------------------------------
194: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE
195: ,p_rep_email_id IN VARCHAR2
196: ,p_rep_phone IN VARCHAR2
197: ,p_segment_num IN NUMBER
198: ,p_person_type IN VARCHAR2)