[Home] [Help]
PACKAGE: APPS.GHR_SF52_POST_UPDATE
Source
1 PACKAGE GHR_SF52_POST_UPDATE AUTHID CURRENT_USER AS
2 /* $Header: gh52poup.pkh 120.0.12010000.1 2008/07/28 10:21:09 appldev ship $ */
3
4 --
5 -- ----------------------------------------------------------------------------
6 -- |--------------------------< Post_sf52_process>--------------------------|
7 -- ----------------------------------------------------------------------------
8
9
10 Procedure Post_sf52_process
11 (
12 p_pa_request_id in number,
13 p_effective_date in date,
14 p_object_version_number in out NOCOPY number,
15 p_from_position_id in number default null,
16 p_to_position_id in number default null,
17 p_agency_code in varchar2 default null, -- to_agency_code
18 p_sf52_data_result in ghr_pa_requests%rowtype,
19 p_called_from in varchar2 default null
20 );
21
22 Procedure Post_sf52_cancel
23 (
24 p_pa_request_id in number,
25 p_effective_date in date,
26 p_object_version_number in out NOCOPY number,
27 p_from_position_id in number default null,
28 p_to_position_id in number default null,
29 p_agency_code in varchar2 default null -- to_agency_code
30 );
31
32 Procedure Post_sf52_future
33 (
34 p_pa_request_id in number,
35 p_effective_date in date,
36 p_object_version_number in out NOCOPY number
37 );
38
39 --
40 -- ----------------------------------------------------------------------------
41 -- |--------------------------< get_Notification_Details>--------------------------|
42 -- ----------------------------------------------------------------------------
43
44 Procedure get_notification_details
45 (
46 p_pa_request_id in number,
47 p_effective_date in date,
48 p_from_position_id in number default null,
49 p_to_position_id in number default null,
50 p_agency_code in out NOCOPY varchar2, -- to_agency_code
51 p_from_agency_code out NOCOPY varchar2,
52 p_from_agency_desc out NOCOPY varchar2,
53 p_from_office_symbol out NOCOPY varchar2,
54 p_personnel_office_id out NOCOPY number,
55 p_employee_dept_or_agency out NOCOPY varchar2,
56 p_to_office_symbol out NOCOPY varchar2
57 );
58
59 end ghr_sf52_post_update;