1 package GHR_CORR_CANC_SF52 AUTHID CURRENT_USER as
2 /* $Header: ghcorcan.pkh 120.2.12020000.1 2012/06/29 04:09:59 appldev ship $ */
3 sf52_corr_rec ghr_pa_requests%rowtype;
4 l_date_result date;
5 l_number_result number;
6 l_varchar2_result varchar2(2000);
7 Procedure Correction_SF52
8 ( p_sf52_data in ghr_pa_requests%rowtype,
9 p_process_type in varchar2 default 'CURRENT',
10 p_capped_other_pay in number default NULL);
11 Procedure Cancel_Appt_SF52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype);
12 Procedure Cancel_Correction_SF52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype);
13 Procedure Cancel_Other_Family_Sf52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype);
14 Procedure cancel_term_SF52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype);
15 Procedure update_eleentval(p_hist_pre in ghr_pa_history%rowtype) ;
16 Procedure build_corrected_sf52(p_pa_request_id in number,
17 p_noa_code_correct in varchar2,
18 p_sf52_data_result in out nocopy ghr_pa_requests%rowtype,
19 p_called_from in varchar2 default NULL);
20 Procedure Cancel_Routine (p_sf52_data in out nocopy ghr_pa_requests%rowtype);
21 Procedure populate_corrected_sf52(p_pa_request_id in number,
22 p_noa_code_correct in varchar2);
23 Function get_date_column(p_value in varchar2) return date;
24 Function get_number_column(p_value in varchar2) return number;
25 Function get_varchar2_column(p_value in varchar2) return varchar2;
26
27 Procedure get_sf52_to_details_for_ia
28 (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
29 p_retro_eff_date in ghr_pa_requests.effective_date%type,
30 p_sf52_ia_rec in out nocopy ghr_pa_requests%rowtype) ;
31
32 PROCEDURE posn_not_active
33 (p_position_id in number
34 ,p_effective_date in date
35 ,p_posn_eff_start_date OUT NOCOPY date
36 ,p_posn_eff_end_date OUT NOCOPY date
37 ,p_prior_posn_ovn OUT NOCOPY number);
38
39 --6850492
40 procedure apply_dual_correction(p_sf52_data in ghr_pa_requests%rowtype,
41 p_sf52_data_result in out nocopy ghr_pa_requests%rowtype,
42 p_retro_action_exists in varchar2); --added the parameter for 8264475
43 --6850492
44
45
46 End;