1 package HR_HRHD_INITIAL_LOAD as
2 /* $Header: perhdfsyn.pkh 120.1.12010000.2 2008/11/14 13:13:43 sathkris noship $ */
3
4 /*Procedure to run the different full synch processes based on the process name
5 that is given as input*/
6 procedure hr_initial_load ( ERRBUF OUT NOCOPY varchar2,
7 RETCODE OUT NOCOPY number,
8 p_process_name in varchar2);
9
10
11 /*Procedure to extract the location data for full synch process*/
12
13 procedure hr_location_initial_load(errbuf OUT NOCOPY VARCHAR2
14 ,retcode OUT NOCOPY VARCHAR2);
15
16 /*Procedure to extract the person data for full synch process*/
17
18 procedure hr_person_initial_load(errbuf OUT NOCOPY VARCHAR2
19 ,retcode OUT NOCOPY VARCHAR2);
20
21 /*Procedure to extract the workforce data for full synch process*/
22
23 procedure hr_workforce_initial_load(errbuf OUT NOCOPY VARCHAR2
24 ,retcode OUT NOCOPY VARCHAR2);
25
26 /*Procedure to extract the jobcode data for full synch process*/
27 procedure hr_jobcode_initial_load(errbuf OUT NOCOPY VARCHAR2
28 ,retcode OUT NOCOPY VARCHAR2);
29
30 /*Procedure to extract the organization data for full synch process*/
31
32 procedure hr_organization_initial_load(errbuf OUT NOCOPY VARCHAR2
33 ,retcode OUT NOCOPY VARCHAR2);
34
35 /*Function for Encrypting*/
36 function hr_hrhd_encrypt(p_data VARCHAR2 ) RETURN RAW;
37
38 /*Function for Decrypting*/
39 function hr_hrhd_decrypt(p_data RAW ) RETURN VARCHAR2;
40
41 end HR_HRHD_INITIAL_LOAD;