1 PACKAGE per_hu_emp_cert_archive AUTHID CURRENT_USER as
2 /* $Header: pehuecar.pkh 115.1 2004/03/26 05:35:50 grchandr noship $ */
3
4
5 FUNCTION get_parameter(
6 p_parameter_string IN VARCHAR2
7 ,p_token IN VARCHAR2
8 ) RETURN VARCHAR2;
9
10 PROCEDURE get_all_parameters(p_payroll_action_id IN NUMBER
11 ,p_business_group_id OUT NOCOPY NUMBER
12 ,p_start_date OUT NOCOPY DATE
13 ,p_end_date OUT NOCOPY DATE
14 ,p_payroll_id OUT NOCOPY NUMBER
15 ,p_issue_date OUT NOCOPY DATE
16 );
17
18 PROCEDURE range_code(p_actid IN NUMBER
19 ,sqlstr OUT NOCOPY VARCHAR2);
20
21 PROCEDURE action_creation_code (p_actid IN NUMBER
22 ,stperson IN NUMBER
23 ,endperson IN NUMBER
24 ,chunk IN NUMBER);
25
26 PROCEDURE archive_code (p_assactid in number,
27 p_effective_date in date);
28
29 PROCEDURE get_person_address(p_person_id IN NUMBER
30 ,p_assactid IN NUMBER
31 ,p_assignment_id IN NUMBER
32 ,p_termination_date IN DATE
33 ,p_effective_date IN DATE
34 );
35
36 PROCEDURE get_employee_data(p_assactid IN NUMBER
37 ,p_assignment_id IN OUT NOCOPY NUMBER
38 ,p_effective_date IN DATE
39 ,p_person_id IN OUT NOCOPY NUMBER
40 ,p_end_date IN OUT NOCOPY DATE
41 );
42
43 END per_hu_emp_cert_archive;