eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PA_REQUESTS_PKG dependencies on PER_PEOPLE_F

Line 51: p_person_id per_people_f.person_id%TYPE

47: p_routing_group_id ghr_routing_groups.routing_group_id%TYPE)
48: RETURN VARCHAR2;
49:
50: FUNCTION get_full_name(
51: p_person_id per_people_f.person_id%TYPE
52: ,p_effective_date date)
53: RETURN VARCHAR2;
54:
55: FUNCTION get_full_name_unsecure(

Line 56: p_person_id per_people_f.person_id%TYPE

52: ,p_effective_date date)
53: RETURN VARCHAR2;
54:
55: FUNCTION get_full_name_unsecure(
56: p_person_id per_people_f.person_id%TYPE
57: ,p_effective_date date)
58: RETURN VARCHAR2;
59:
60: FUNCTION get_noa_descriptor(

Line 151: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE

147: ,p_personnelist_flag in OUT NOCOPY varchar2
148: ,p_approver_flag in OUT NOCOPY varchar2
149: ,p_reviewer_flag in OUT NOCOPY varchar2);
150: --
151: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE
152: ,p_effective_date IN DATE
153: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
154: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
155: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE

Line 153: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE

149: ,p_reviewer_flag in OUT NOCOPY varchar2);
150: --
151: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE
152: ,p_effective_date IN DATE
153: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
154: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
155: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
156: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
157: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);

Line 154: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE

150: --
151: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE
152: ,p_effective_date IN DATE
153: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
154: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
155: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
156: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
157: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);
158: --

Line 155: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE

151: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE
152: ,p_effective_date IN DATE
153: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
154: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
155: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
156: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
157: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);
158: --
159: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE

Line 156: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE

152: ,p_effective_date IN DATE
153: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
154: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
155: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
156: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
157: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);
158: --
159: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
160: ,p_effective_date IN DATE

Line 157: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);

153: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
154: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
155: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
156: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
157: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);
158: --
159: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
160: ,p_effective_date IN DATE
161: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE

Line 164: PROCEDURE get_SF52_person_ddf_details (p_person_id IN per_people_f.person_id%TYPE

160: ,p_effective_date IN DATE
161: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
162: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE);
163: --
164: PROCEDURE get_SF52_person_ddf_details (p_person_id IN per_people_f.person_id%TYPE
165: ,p_date_effective IN date default sysdate
166: ,p_citizenship OUT NOCOPY varchar2
167: ,p_veterans_preference OUT NOCOPY varchar2
168: ,p_veterans_pref_for_rif OUT NOCOPY varchar2

Line 405: FUNCTION get_upd34_pay_basis (p_person_id IN per_people_f.person_id%TYPE

401: FUNCTION get_full_name_fml(p_person_id IN varchar2,
402: p_effective_date IN date default trunc(sysdate))
403: RETURN varchar2;
404: --
405: FUNCTION get_upd34_pay_basis (p_person_id IN per_people_f.person_id%TYPE
406: ,p_position_id IN per_positions.position_id%type
407: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
408: ,p_noa_code IN varchar2 DEFAULT NULL
409: ,p_pa_request_id IN NUMBER DEFAULT NULL