276:
277:
278: procedure get_lac_dtls
279: (p_pa_request_id in number,
280: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
281:
282: procedure create_lac_remarks
283: (p_pa_request_id in number,
284: p_new_pa_request_id in number);
317: p_to_supervisory_differential in number,
318: p_to_supervisory_diff_perce in number,
319: p_to_staffing_differential in number,
320: p_duty_station_id in number,
321: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
322: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
323: -- FWFA Changes Bug#4444609
324: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
325: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
318: p_to_supervisory_diff_perce in number,
319: p_to_staffing_differential in number,
320: p_duty_station_id in number,
321: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
322: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
323: -- FWFA Changes Bug#4444609
324: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
325: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
326: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
320: p_duty_station_id in number,
321: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
322: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
323: -- FWFA Changes Bug#4444609
324: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
325: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
326: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
327: -- FWFA Changes
328: p_lac_sf52_rec in ghr_pa_requests%rowtype,
321: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
322: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
323: -- FWFA Changes Bug#4444609
324: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
325: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
326: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
327: -- FWFA Changes
328: p_lac_sf52_rec in ghr_pa_requests%rowtype,
329: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
322: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
323: -- FWFA Changes Bug#4444609
324: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
325: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
326: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
327: -- FWFA Changes
328: p_lac_sf52_rec in ghr_pa_requests%rowtype,
329: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
330:
324: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
325: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
326: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
327: -- FWFA Changes
328: p_lac_sf52_rec in ghr_pa_requests%rowtype,
329: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
330:
331: procedure check_select_flg_pos(p_position_id in number,
332: p_action in varchar2,
325: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
326: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
327: -- FWFA Changes
328: p_lac_sf52_rec in ghr_pa_requests%rowtype,
329: p_sf52_rec out nocopy ghr_pa_requests%rowtype);
330:
331: procedure check_select_flg_pos(p_position_id in number,
332: p_action in varchar2,
333: p_effective_date in date,