[Home] [Help]
PACKAGE: APPS.GHR_PROCESS_SF52
Source
1 package GHR_PROCESS_SF52 as
2 /* $Header: ghproc52.pkh 120.0.12010000.2 2008/08/05 15:10:40 ubhat ship $ */
3
4 g_total_pay_check varchar2(1) := 'Y';
5 g_prd ghr_pa_requests.pay_rate_determinant%type := NULL;
6 g_step_or_rate ghr_pa_requests.to_step_or_rate%type := NULL;
7 e_refresh EXCEPTION; -- Bug# 5634990
8 PROCEDURE refresh_pa_request(
9 p_person_id in per_people_f.person_id%type,
10 p_effective_date in date,
11 p_from_only in boolean default FALSE,
12 p_derive_to_cols in boolean default FALSE,
13 -- p_altered_pa_request_id in number default NULL,
14 -- p_noa_id_corrected in number default NULL,
15 p_sf52_data in out nocopy ghr_pa_requests%rowtype);
16 -- p_from_location_id out nocopy hr_locations.location_id%type
17
18
19 Procedure Process_SF52 (
20 p_sf52_data in out nocopy ghr_pa_requests%rowtype,
21 p_process_type in varchar2 default 'CURRENT',
22 p_validate in Boolean default FALSE,
23 p_capped_other_pay in Number default NULL);
24 Procedure assign_new_rg (
25 p_action_num in number,
26 -- p_altered_pa_request_id in number default NULL,
27 -- p_noa_id_corrected in number default NULL,
28 p_pa_req in out nocopy ghr_pa_requests%rowtype);
29 Procedure copy_2ndNoa_to_1stNoa (p_pa_req in out nocopy ghr_pa_requests%rowtype);
30 Procedure null_2ndNoa_cols (p_pa_req in out nocopy ghr_pa_requests%rowtype);
31
32 Procedure Fetch_Extra_Info(
33 p_pa_request_id in number,
34 p_noa_id in number,
35 p_agency_ei in boolean default False,
36 p_sf52_ei_data out nocopy ghr_pa_request_extra_info%rowtype,
37 p_result out nocopy varchar2);
38
39 Procedure get_Family_code (
40 p_noa_id in number,
41 p_noa_family_code out nocopy varchar2);
42
43 Procedure Proc_Futr_Act(
44 errbuf out nocopy varchar2,
45 retcode out nocopy number,
46 p_poi in ghr_pois.personnel_office_id%type);
47
48 Procedure Route_Intervn_Future_Actions(
49 p_person_id in number,
50 p_effective_date in date
51 );
52
53 Procedure Route_Intervn_act_pend_today(
54 p_person_id in number,
55 p_effective_date in date
56 );
57
58 Procedure get_par_ap_apue_fields(
59 p_pa_req_in in ghr_pa_requests%rowtype,
60 p_first_noa_id in ghr_pa_requests.first_noa_id%type,
61 p_second_noa_id in ghr_pa_requests.second_noa_id%type,
62 p_pa_req_out out nocopy ghr_pa_requests%rowtype);
63
64 Procedure derive_to_columns(p_sf52_data in out nocopy ghr_pa_requests%rowtype);
65 Procedure Redo_Pay_calc ( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
66 p_capped_other_pay in out nocopy number );
67
68 Procedure refresh_req_shadow (
69 p_sf52_data in out nocopy ghr_pa_requests%rowtype,
70 p_shadow_data out nocopy ghr_pa_request_shadow%rowtype,
71 p_process_type in varchar2 default 'CURRENT');
72
73 Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype);
74 Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype);
75 Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
76 p_shadow_data in ghr_pa_request_shadow%rowtype);
77 procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE);
78
79
80 End;