DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on HR_ALL_POSITIONS_F

Line 71: p_position_id hr_all_positions_f.position_id%TYPE

67: -- possibly need description returned not just name?
68:
69: -- Bug#5482191 Added the function get_personnel_system_indicator
70: FUNCTION get_personnel_system_indicator(
71: p_position_id hr_all_positions_f.position_id%TYPE
72: ,p_effective_date date)
73: RETURN VARCHAR2;
74:
75: --

Line 132: PROCEDURE get_SF52_pos_ddf_details (p_position_id IN hr_all_positions_f.position_id%TYPE

128: ,p_pay_rate_determinant OUT NOCOPY varchar2
129: ,p_work_schedule OUT NOCOPY varchar2
130: ,p_part_time_hours OUT NOCOPY varchar2);
131: --
132: PROCEDURE get_SF52_pos_ddf_details (p_position_id IN hr_all_positions_f.position_id%TYPE
133: ,p_date_effective IN date default sysdate
134: ,p_flsa_category OUT NOCOPY varchar2
135: ,p_bargaining_unit_status OUT NOCOPY varchar2
136: ,p_work_schedule OUT NOCOPY varchar2

Line 161: (p_position_id IN hr_all_positions_f.position_id%TYPE

157: ,p_country OUT NOCOPY per_addresses.country%TYPE
158: ,p_territory_short_name OUT NOCOPY varchar2);
159: --
160: PROCEDURE get_SF52_to_data_elements
161: (p_position_id IN hr_all_positions_f.position_id%TYPE
162: ,p_effective_date IN date default sysdate
163: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
164: ,p_grade_id IN OUT NOCOPY number
165: ,p_job_id IN OUT NOCOPY number