1 PACKAGE PAY_SE_ARCHIVE_CWCA AUTHID CURRENT_USER AS
2 /* $Header: pysecwca.pkh 120.0.12010000.2 2010/01/12 10:07:17 vijranga ship $ */
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 -- In parameter
11 ,p_business_group_id OUT NOCOPY NUMBER -- Core parameter
12 ,p_effective_date OUT NOCOPY DATE -- Core parameter
13 ,p_person_id OUT NOCOPY NUMBER -- User parameter
14 ,p_assignment_id OUT NOCOPY VARCHAR2 -- User parameter
15 ,p_still_employed OUT NOCOPY VARCHAR2 -- User parameter
16 ,p_report_start_year OUT NOCOPY VARCHAR2 -- User parameter
17 ,p_report_start_month OUT NOCOPY VARCHAR2 -- User parameter
18 );
19
20 PROCEDURE RANGE_CODE
21 (p_payroll_action_id IN NUMBER
22 ,p_sql OUT NOCOPY VARCHAR2) ;
23
24 PROCEDURE ASSIGNMENT_ACTION_CODE
25 (p_payroll_action_id IN NUMBER
26 ,p_start_person IN NUMBER
27 ,p_end_person IN NUMBER
28 ,p_chunk IN NUMBER);
29
30 PROCEDURE INITIALIZATION_CODE
31 (p_payroll_action_id IN NUMBER);
32
33
34 PROCEDURE ARCHIVE_CODE
35 (p_assignment_action_id IN NUMBER
36 ,p_effective_date IN DATE);
37
38 PROCEDURE DEINITIALIZATION_CODE
39 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
40
41 -- Bug# 9222739 fix starts
42 FUNCTION GET_DEFINED_BALANCE_VALUE
43 (p_assignment_id IN NUMBER
44 ,p_balance_name IN VARCHAR2
45 ,p_balance_dim IN VARCHAR2
46 ,p_virtual_date IN DATE) RETURN NUMBER;
47
48 -- Bug# 9222739 fix ends
49
50 END PAY_SE_ARCHIVE_CWCA;