DBA Data[Home] [Help]

PACKAGE: APPS.GHR_SS_RPA_CREATION

Source


1 PACKAGE GHR_SS_RPA_CREATION AUTHID CURRENT_USER as
2  /* $Header: ghrssrpa.pkh 120.0 2011/04/22 07:40:58 vmididho noship $*/
3 
4   PROCEDURE CREATE_SF52_FEGLI(p_person_id in number,
5                               p_assignment_id in number,
6                               p_fegli_code in varchar2,
7                               p_fegli_event_code in varchar2,
8 	    		      p_effective_date in date);
9 
10   PROCEDURE CREATE_SF52_FEGLI_RPA(p_person_id in number,
11                                   p_assignment_id in number,
12                                   p_fegli_code in varchar2,
13                                   p_effective_date in date,
14                                   p_pa_request_id out NOCOPY number);
15 
16   PROCEDURE  UPDATE_SF52_FEGLI_RPA(p_pa_request_id in number,
17                                     p_person_id in number,
18                                     p_assignment_id in number,
19                                     p_fegli_code in varchar2,
20                                     p_effective_date in date);
21 
22   PROCEDURE CREATE_PA_REMARKS (p_pa_request_id   in   ghr_pa_requests.pa_request_id%type,
23                                p_effective_date  in   date,
24                                p_remark_code     in   ghr_remarks.code%type);
25 
26    PROCEDURE POPULATE_PA_REQUEST_EXTRA_INFO(p_pa_request_id in NUMBER,
27                                             p_info_type  in VARCHAR2,
28                                             p_attribute1 in VARCHAR2 default NULL,
29                                             p_attribute2 in VARCHAR2 default NULL,
30                                             p_attribute3 in VARCHAR2 default NULL,
31                                             p_attribute4 in VARCHAR2 default NULL,
32                                             p_attribute5 in VARCHAR2 default NULL,
33                                             p_attribute6 in VARCHAR2 default NULL,
34                                             p_attribute7 in VARCHAR2 default NULL,
35                                             p_attribute8 in VARCHAR2 default NULL,
36                                             p_attribute9 in VARCHAR2 default NULL,
37                                             p_attribute10 in VARCHAR2 default NULL,
38                                             p_attribute11 in VARCHAR2 default NULL,
39                                             p_attribute12 in VARCHAR2 default NULL,
40 					 p_attribute13 	 in VARCHAR2 default NULL,
41 					 p_attribute14 	 in VARCHAR2 default NULL,
42 					 p_attribute15 	 in VARCHAR2 default NULL,
43 					 p_attribute16 	 in VARCHAR2 default NULL,
44 					 p_attribute17 	 in VARCHAR2 default NULL,
45 					 p_attribute18 	 in VARCHAR2 default NULL,
46 					 p_attribute19 	 in VARCHAR2 default NULL,
47 					 p_attribute20 	 in VARCHAR2 default NULL,
48 					 p_attribute21 	 in VARCHAR2 default NULL,
49 					 p_attribute22	 in VARCHAR2 default NULL,
50 					 p_attribute23 	 in VARCHAR2 default NULL,
51 					 p_attribute24 	 in VARCHAR2 default NULL,
52 					 p_attribute25 	 in VARCHAR2 default NULL,
53 					 p_attribute26 	 in VARCHAR2 default NULL,
54 					 p_attribute27 	 in VARCHAR2 default NULL,
55 					 p_attribute28 	 in VARCHAR2 default NULL,
56 					 p_attribute29 	 in VARCHAR2 default NULL,
57 					 p_attribute30 	 in VARCHAR2 default NULL
58 				   );
59 
60   PROCEDURE UPDATE_SHADOW_ROW(p_sf52_rec in ghr_pa_requests%rowtype, p_result out NOCOPY  BOOLEAN);
61 END;