270:
271:
272: procedure get_lac_dtls
273: (p_pa_request_id in number,
274: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
275:
276: procedure create_lac_remarks
277: (p_pa_request_id in number,
278: p_new_pa_request_id in number);
311: p_to_supervisory_differential in number,
312: p_to_supervisory_diff_perce in number,
313: p_to_staffing_differential in number,
314: p_duty_station_id in number,
315: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
316: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
317: -- FWFA Changes Bug#4444609
318: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
319: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
312: p_to_supervisory_diff_perce in number,
313: p_to_staffing_differential in number,
314: p_duty_station_id in number,
315: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
316: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
317: -- FWFA Changes Bug#4444609
318: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
319: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
320: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
314: p_duty_station_id in number,
315: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
316: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
317: -- FWFA Changes Bug#4444609
318: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
319: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
320: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
321: -- FWFA Changes
322: p_lac_sf52_rec in ghr_pa_requests%rowtype,
315: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
316: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
317: -- FWFA Changes Bug#4444609
318: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
319: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
320: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
321: -- FWFA Changes
322: p_lac_sf52_rec in ghr_pa_requests%rowtype,
323: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
316: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
317: -- FWFA Changes Bug#4444609
318: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
319: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
320: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
321: -- FWFA Changes
322: p_lac_sf52_rec in ghr_pa_requests%rowtype,
323: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
324:
318: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
319: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
320: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
321: -- FWFA Changes
322: p_lac_sf52_rec in ghr_pa_requests%rowtype,
323: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
324:
325: procedure check_select_flg_pos(p_position_id in number,
326: p_action in varchar2,
319: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
320: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
321: -- FWFA Changes
322: p_lac_sf52_rec in ghr_pa_requests%rowtype,
323: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
324:
325: procedure check_select_flg_pos(p_position_id in number,
326: p_action in varchar2,
327: p_effective_date in date,