1 package hr_full_sync_messages as
2 /* $Header: perhrhdfull.pkh 120.3 2008/01/23 13:06:27 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_full_sync ( ERRBUF OUT NOCOPY varchar2,
6 RETCODE OUT NOCOPY number,
7 p_process_name in varchar2);
8
9 /*Procedure to extract the state data for full synch process*/
10 procedure hr_state_full_sync(errbuf OUT NOCOPY VARCHAR2
11 ,retcode OUT NOCOPY VARCHAR2);
12
13 /*Procedure to extract the country data for full synch process*/
14 procedure hr_country_full_sync(errbuf OUT NOCOPY VARCHAR2
15 ,retcode OUT NOCOPY VARCHAR2);
16
17 /*Procedure to extract the location data for full synch process*/
18 procedure hr_location_full_sync(errbuf OUT NOCOPY VARCHAR2
19 ,retcode OUT NOCOPY VARCHAR2);
20
21 /*Procedure to extract the person data for full synch process*/
22 procedure hr_person_full_sync(errbuf OUT NOCOPY VARCHAR2
23 ,retcode OUT NOCOPY VARCHAR2);
24
25 /*Procedure to extract the workforce data for full synch process*/
26 procedure hr_workforce_full_sync(errbuf OUT NOCOPY VARCHAR2
27 ,retcode OUT NOCOPY VARCHAR2);
28
29 /*Procedure to extract the jobcode data for full synch process*/
30 procedure hr_jobcode_full_sync(errbuf OUT NOCOPY VARCHAR2
31 ,retcode OUT NOCOPY VARCHAR2);
32
33 /*Procedure to extract the organization data for full synch process*/
34 procedure hr_organizaton_full_sync(errbuf OUT NOCOPY VARCHAR2
35 ,retcode OUT NOCOPY VARCHAR2);
36
37 /*Procedure to extract the business group data for full synch process*/
38 procedure hr_businessgrp_full_sync(errbuf OUT NOCOPY VARCHAR2
39 ,retcode OUT NOCOPY VARCHAR2);
40
41 /*Procedure to extract the payroll group data for full synch process*/
42 procedure hr_payroll_full_sync(errbuf OUT NOCOPY VARCHAR2
43 ,retcode OUT NOCOPY VARCHAR2);
44
45
46
47 /*Procedure to insert the record into psft_sync_run table*/
48 procedure insert_psft_sync_run(p_status number
49 ,p_process_name varchar2
50 ,errbuf OUT NOCOPY VARCHAR2
51 ,retcode OUT NOCOPY VARCHAR2);
52
53 /*Procedure to update the record into psft_sync_run table*/
54 PROCEDURE update_psft_sync_run(p_status number
55 ,p_process_name varchar2
56 ,p_run_date date
57 ,errbuf OUT NOCOPY VARCHAR2
58 ,retcode OUT NOCOPY VARCHAR2);
59
60
61 end hr_full_sync_messages;