eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CORR_CANC_SF52 dependencies on GHR_PA_REQUESTS

Line 3: sf52_corr_rec ghr_pa_requests%rowtype;

1: package GHR_CORR_CANC_SF52 as
2: /* $Header: ghcorcan.pkh 120.0.12010000.1 2008/07/28 10:24:40 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

Line 8: ( p_sf52_data in 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);

Line 11: Procedure Cancel_Appt_SF52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype);

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) ;

Line 12: Procedure Cancel_Correction_SF52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype);

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,

Line 13: Procedure Cancel_Other_Family_Sf52 ( p_sf52_data in out nocopy 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,

Line 14: Procedure cancel_term_SF52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype);

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,

Line 18: p_sf52_data_result 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);

Line 20: Procedure Cancel_Routine (p_sf52_data in out nocopy ghr_pa_requests%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;

Line 28: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

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

Line 29: p_retro_eff_date in ghr_pa_requests.effective_date%type,

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

Line 30: p_sf52_ia_rec in out nocopy ghr_pa_requests%rowtype) ;

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