[Home] [Help]
38: --
39: -- This record structure will keep all the in parameters that were passed to the main pay calc process
40: TYPE pay_calc_in_rec_type IS RECORD
41: (person_id per_people_f.person_id%TYPE
42: ,position_id hr_all_positions_f.position_id%TYPE
43: ,noa_family_code ghr_families.noa_family_code%TYPE
44: ,noa_code ghr_nature_of_actions.code%TYPE
45: ,second_noa_code ghr_nature_of_actions.code%TYPE
46: --GPPA Update46
141:
142: FUNCTION get_user_table_name (p_user_table_id IN NUMBER)
143: RETURN VARCHAR2;
144: --
145: FUNCTION get_user_table_id (p_position_id IN hr_all_positions_f.position_id%TYPE
146: ,p_effective_date IN date)
147: RETURN NUMBER;
148: --
149: FUNCTION get_open_pay_range (p_position_id IN hr_all_positions_f.position_id%TYPE
145: FUNCTION get_user_table_id (p_position_id IN hr_all_positions_f.position_id%TYPE
146: ,p_effective_date IN date)
147: RETURN NUMBER;
148: --
149: FUNCTION get_open_pay_range (p_position_id IN hr_all_positions_f.position_id%TYPE
150: ,p_person_id IN per_all_people_f.person_id%type
151: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
152: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type
153: ,p_effective_date IN date)
200: --
201:
202: --Bug# 5132113 added new parameters p_open_out_locality_adj,p_open_localityadj_field
203: PROCEDURE main_pay_calc (p_person_id IN per_people_f.person_id%TYPE
204: ,p_position_id IN hr_all_positions_f.position_id%TYPE
205: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
206: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
207: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
208: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE