PACKAGE: APPS.GHR_PROCESS_SF52

Source

1 package GHR_PROCESS_SF52 AUTHID CURRENT_USER as
2 /* $Header: ghproc52.pkh 120.4.12020000.1 2012/06/29 04:35:46 appldev 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 
9 	g_dual_prior_ws  ghr_pa_requests.work_schedule%type := NULL;   --8267598
10 	g_dual_first_noac ghr_pa_requests.first_noa_code%type := NULL;  --8264475
11 	g_dual_second_noac ghr_pa_requests.first_noa_code%type := NULL;	--8264475
12     g_dual_prior_prd ghr_pa_requests.pay_rate_determinant%type := NULL;	--8268353
13 	g_dual_action_yn   varchar2(1) := 'Y'; 	 --8264475
14 
15 	PROCEDURE refresh_pa_request(
16 		p_person_id			in	per_people_f.person_id%type,
17 		p_effective_date		in	date,
18 		p_from_only			in	boolean	default	FALSE,
19 		p_derive_to_cols		in	boolean	default 	FALSE,
20 --            p_altered_pa_request_id in    number      default     NULL,
21 --            p_noa_id_corrected       in    number      default     NULL,
22 		p_sf52_data		in out 	nocopy ghr_pa_requests%rowtype);
23 --		p_from_location_id	out	nocopy hr_locations.location_id%type
24 
25 
26 	Procedure Process_SF52 	(
27 		p_sf52_data		in out	nocopy ghr_pa_requests%rowtype,
28 		p_process_type		in	varchar2	default 'CURRENT',
29 		p_validate		in	Boolean	default FALSE,
30                 p_capped_other_pay      in      Number  default NULL);
31 	Procedure assign_new_rg (
32 		p_action_num	         in  number,
33 --		p_altered_pa_request_id  in  number      default     NULL,
34 --		p_noa_id_corrected       in  number      default     NULL,
35 		p_pa_req 		 in out nocopy ghr_pa_requests%rowtype);
36 	Procedure copy_2ndNoa_to_1stNoa (p_pa_req		  in out nocopy	ghr_pa_requests%rowtype);
37 	Procedure	null_2ndNoa_cols	(p_pa_req	  in out nocopy	ghr_pa_requests%rowtype);
38 
39 	Procedure Fetch_Extra_Info(
40 		p_pa_request_id	in	number,
41 		p_noa_id	in	number,
42 		p_agency_ei	in	boolean	default False,
43 		p_sf52_ei_data	out nocopy ghr_pa_request_extra_info%rowtype,
44 		p_result	out nocopy	varchar2);
45 
46 	Procedure get_Family_code (
47 		p_noa_id		in 	number,
48 		p_noa_family_code	out nocopy	varchar2);
49 
50 	Procedure Proc_Futr_Act(
51 		errbuf         out nocopy     varchar2,
52 		retcode        out  nocopy   number,
53                 p_poi          in     ghr_pois.personnel_office_id%type);
54 
55 	Procedure Route_Intervn_Future_Actions(
56 		p_person_id		in	number,
57 		p_effective_date	in	date
58             );
59 
60       Procedure Route_Intervn_act_pend_today(
61     		p_person_id		in	number,
62 	  	p_effective_date	in	date
63             );
64 
65 	Procedure get_par_ap_apue_fields(
66 		p_pa_req_in			in	ghr_pa_requests%rowtype,
67 		p_first_noa_id		in	ghr_pa_requests.first_noa_id%type,
68 		p_second_noa_id		in	ghr_pa_requests.second_noa_id%type,
69 		p_pa_req_out		out nocopy	ghr_pa_requests%rowtype);
70 
71 	Procedure derive_to_columns(p_sf52_data	in out nocopy	ghr_pa_requests%rowtype);
72 	Procedure Redo_Pay_calc ( p_sf52_rec	in out nocopy	ghr_pa_requests%rowtype,
73                                   p_capped_other_pay in out nocopy number );
74 
75 	Procedure refresh_req_shadow (
76 		p_sf52_data	in out nocopy ghr_pa_requests%rowtype,
77 		p_shadow_data   out nocopy ghr_pa_request_shadow%rowtype,
78 		p_process_type	in	varchar2 default 'CURRENT');
79 
80 	Procedure create_shadow_row ( p_sf52_data	in	ghr_pa_requests%rowtype);
81 	Procedure create_shadow_row ( p_shadow_data	in	ghr_pa_request_shadow%rowtype);
82 	Procedure Update_rfrs_values( p_sf52_data   in out nocopy ghr_pa_requests%rowtype,
83 				      p_shadow_data in     ghr_pa_request_shadow%rowtype);
84 procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE);
85 
86 --8267598
87 procedure reinit_dual_var;
88 
89 
90 End;