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