1 package HR_HRHD_INITIAL_LOAD AUTHID CURRENT_USER as
2 /* $Header: perhdfsyn.pkh 120.2.12020000.2 2013/02/22 14:30:42 pathota ship $ */
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 ,p_no_of_files in Number);
10
11
12 /*Procedure to extract the location data for full synch process*/
13
14 procedure hr_location_initial_load(errbuf OUT NOCOPY VARCHAR2
15 ,retcode OUT NOCOPY VARCHAR2 , p_number_of_files in Number);
16
17 /*Procedure to extract the person data for full synch process*/
18
19 procedure hr_person_initial_load(errbuf OUT NOCOPY VARCHAR2
20 ,retcode OUT NOCOPY VARCHAR2 , p_number_of_files in Number);
21
22 /*Procedure to extract the workforce data for full synch process*/
23
24 procedure hr_workforce_initial_load(errbuf OUT NOCOPY VARCHAR2
25 ,retcode OUT NOCOPY VARCHAR2 , p_number_of_files in Number);
26
27 /*Procedure to extract the jobcode data for full synch process*/
28 procedure hr_jobcode_initial_load(errbuf OUT NOCOPY VARCHAR2
29 ,retcode OUT NOCOPY VARCHAR2 , p_number_of_files in Number);
30
31 /*Procedure to extract the organization data for full synch process*/
32
33 procedure hr_organization_initial_load(errbuf OUT NOCOPY VARCHAR2
34 ,retcode OUT NOCOPY VARCHAR2 , p_number_of_files in Number);
35
36 /*Function for Encrypting*/
37 function hr_hrhd_encrypt(p_data VARCHAR2 ) RETURN RAW;
38
39 /*Function for Decrypting*/
40 function hr_hrhd_decrypt(p_data RAW ) RETURN VARCHAR2;
41
42 end HR_HRHD_INITIAL_LOAD;
43