1 PACKAGE PAY_FI_ARCHIVE_LTFA AUTHID CURRENT_USER AS
2 /* $Header: pyfiltfa.pkh 120.0.12000000.2 2007/02/14 05:38:23 dbehera 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_pension_ins_num OUT NOCOPY VARCHAR2
13 ,p_legal_employer_id OUT NOCOPY NUMBER
14 ,p_local_unit_id OUT NOCOPY NUMBER
15 ,p_month OUT NOCOPY VARCHAR2
16 ,p_year OUT NOCOPY VARCHAR2
17 ,p_effective_date OUT NOCOPY DATE
18 ,p_archive OUT NOCOPY VARCHAR2);
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
42
43 END PAY_FI_ARCHIVE_LTFA;