1 PACKAGE pay_se_slsa_archive AUTHID CURRENT_USER AS
2 /* $Header: pyseslsa.pkh 120.0.12000000.1 2007/07/18 11:12:36 psingla noship $ */
3 /* ############################################################# */
4 -- For Archive
5 FUNCTION get_parameter (
6 p_parameter_string IN VARCHAR2,
7 p_token IN VARCHAR2,
8 p_segment_number IN NUMBER DEFAULT NULL
9 )
10 RETURN VARCHAR2;
11
12 PROCEDURE get_all_parameters (
13 p_payroll_action_id IN NUMBER -- In parameter
14 ,
15 p_business_group_id OUT NOCOPY NUMBER -- Core parameter
16 ,
17 p_effective_date OUT NOCOPY DATE -- Core parameter
18 ,
19 p_legal_employer_id OUT NOCOPY NUMBER -- User parameter
20 ,
21 p_request_for_all_or_not OUT NOCOPY VARCHAR2 -- User parameter
22 ,
23 p_start_date OUT NOCOPY DATE -- User parameter
24 ,
25 p_end_date OUT NOCOPY DATE
26 );
27
28 PROCEDURE range_code (
29 p_payroll_action_id IN NUMBER,
30 p_sql OUT NOCOPY VARCHAR2
31 );
32
33 PROCEDURE assignment_action_code (
34 p_payroll_action_id IN NUMBER,
35 p_start_person IN NUMBER,
36 p_end_person IN NUMBER,
37 p_chunk IN NUMBER
38 );
39
40 PROCEDURE initialization_code (
41 p_payroll_action_id IN NUMBER
42 );
43
44 PROCEDURE archive_code (
45 p_assignment_action_id IN NUMBER,
46 p_effective_date IN DATE
47 );
48
49 PROCEDURE get_schedule_duration (
50 p_start_date IN DATE,
51 p_end_date IN DATE,
52 p_days_or_hours IN VARCHAR2,
53 p_duration IN OUT NOCOPY NUMBER
54 );
55 END pay_se_slsa_archive;