1 PACKAGE PAY_DK_ARCHIVE_EHOL AUTHID CURRENT_USER AS
2 /* $Header: pydkeholca.pkh 120.0.12020000.1 2012/07/18 05:20:14 rsahai noship $ */
3
4 FUNCTION GET_PARAMETER
5 (p_parameter_string IN VARCHAR2
6 ,p_token IN VARCHAR2
7 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
8
9 PROCEDURE GET_ALL_PARAMETERS
10 ( p_payroll_action_id IN NUMBER
11 ,p_business_group_id OUT NOCOPY NUMBER
12 ,p_legal_employer_id OUT NOCOPY NUMBER
13 ,p_effective_date OUT NOCOPY DATE
14 ,p_payroll OUT NOCOPY NUMBER
15 ,p_year OUT NOCOPY NUMBER
16 ,p_payroll_type OUT NOCOPY VARCHAR2
17 ,p_start_date OUT NOCOPY VARCHAR2
18 ,p_end_date OUT NOCOPY VARCHAR2
19 ,p_test_submission OUT NOCOPY VARCHAR2
20 ,p_company_terminating OUT NOCOPY VARCHAR2
21 ,p_msg_txt OUT NOCOPY VARCHAR2);
22
23 PROCEDURE RANGE_CODE
24 (p_payroll_action_id IN NUMBER
25 ,p_sql OUT NOCOPY VARCHAR2) ;
26
27 PROCEDURE ASSIGNMENT_ACTION_CODE
28 (p_payroll_action_id IN NUMBER
29 ,p_start_person IN NUMBER
30 ,p_end_person IN NUMBER
31 ,p_chunk IN NUMBER);
32
33 PROCEDURE INITIALIZATION_CODE
34 (p_payroll_action_id IN NUMBER);
35
36
37 PROCEDURE ARCHIVE_CODE
38 (p_assignment_action_id IN NUMBER
39 ,p_effective_date IN DATE);
40
41 PROCEDURE DEINITIALIZATION_CODE
42 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
43
44 PROCEDURE generate_xml(
45 errbuf out nocopy varchar2
46 ,retcode out nocopy varchar2
47 ,p_payroll_act_id in number
48 );
49
50 END PAY_DK_ARCHIVE_EHOL;