1 PACKAGE HR_DELTA_SYNC_MESSAGES AUTHID CURRENT_USER as
2 /* $Header: perhrhdrir.pkh 120.4 2008/01/23 13:07:33 sathkris noship $ */
3 /*Procedure to run the different full synch processes based on the process name
4 that is given as input*/
5 procedure hr_delta_sync ( ERRBUF OUT NOCOPY varchar2,
6 RETCODE OUT NOCOPY number,
7 p_process_name in varchar2,
8 p_party_site_id in number);
9
10 /*Procedure to extract the state data for delta synch process*/
11 procedure hr_state_delta_sync(errbuf OUT NOCOPY VARCHAR2
12 ,retcode OUT NOCOPY VARCHAR2
13 ,p_party_site_id in number);
14
15 /*Procedure to extract the country data for delta synch process*/
16 procedure hr_country_delta_sync(errbuf OUT NOCOPY VARCHAR2
17 ,retcode OUT NOCOPY VARCHAR2
18 ,p_party_site_id in number);
19
20 /*Procedure to extract the location data for delta synch process*/
21 procedure hr_location_delta_sync(errbuf OUT NOCOPY VARCHAR2
22 ,retcode OUT NOCOPY VARCHAR2
23 ,p_party_site_id in number);
24
25 /*Procedure to extract the person data for delta synch process*/
26 procedure hr_person_delta_sync(errbuf OUT NOCOPY VARCHAR2
27 ,retcode OUT NOCOPY VARCHAR2
28 ,p_party_site_id in number);
29
30 /*Procedure to extract the workforce data for delta synch process*/
31 procedure hr_workforce_delta_sync(errbuf OUT NOCOPY VARCHAR2
32 ,retcode OUT NOCOPY VARCHAR2
33 ,p_party_site_id in number);
34
35 /*Procedure to extract the jobcode data for delta synch process*/
36 procedure hr_jobcode_delta_sync(errbuf OUT NOCOPY VARCHAR2
37 ,retcode OUT NOCOPY VARCHAR2
38 ,p_party_site_id in number);
39
40 /*Procedure to extract the organization data for delta synch process*/
41 procedure hr_organizaton_delta_sync(errbuf OUT NOCOPY VARCHAR2
42 ,retcode OUT NOCOPY VARCHAR2
43 ,p_party_site_id in number);
44
45 /*Procedure to extract the business group data for delta synch process*/
46 procedure hr_businessgrp_delta_sync(errbuf OUT NOCOPY VARCHAR2
47 ,retcode OUT NOCOPY VARCHAR2
48 ,p_party_site_id in number);
49
50 /*Procedure to extract the payroll group data for delta synch process*/
51 procedure hr_payroll_delta_sync(errbuf OUT NOCOPY VARCHAR2
52 ,retcode OUT NOCOPY VARCHAR2
53 ,p_party_site_id in number);
54
55
56
57 /*Procedure to insert the record into psft_sync_run table*/
58 procedure insert_psft_sync_run(p_status number
59 ,p_process_name varchar2
60 ,errbuf OUT NOCOPY VARCHAR2
61 ,retcode OUT NOCOPY VARCHAR2);
62
63 /*Procedure to update the record into psft_sync_run table*/
64 PROCEDURE update_psft_sync_run(p_status number
65 ,p_process_name varchar2
66 ,p_run_date date
67 ,errbuf OUT NOCOPY VARCHAR2
68 ,retcode OUT NOCOPY VARCHAR2);
69
70 PROCEDURE update_delta_msg_status(p_event_key varchar2,
71 p_process_name varchar2);
72
73
74 end hr_delta_sync_messages;