1 PACKAGE PAY_FI_ARCHIVE_TEL AS
2 /* $Header: pyfitela.pkh 120.1.12000000.2 2007/03/14 08:13:34 dbehera noship $ */
3
4 FUNCTION GET_PARAMETER(p_parameter_string IN VARCHAR2
5 ,p_token IN VARCHAR2
6 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
7
8
9
10 PROCEDURE GET_ALL_PARAMETERS(
11 p_payroll_action_id IN NUMBER -- In parameter
12 ,p_business_group_id OUT NOCOPY NUMBER -- Core parameter
13 ,p_effective_date OUT NOCOPY Date -- Core parameter
14 ,p_pension_ins_num OUT NOCOPY VARCHAR2 -- User parameter
15 ,p_legal_employer_id OUT NOCOPY NUMBER -- User parameter
16 ,p_local_unit_id OUT NOCOPY NUMBER -- User parameter
17 ,p_annual_report OUT NOCOPY VARCHAR2 -- User parameter
18 ,p_ref_date OUT NOCOPY Date -- User parameter
19 ,p_archive OUT NOCOPY VARCHAR2 -- User parameter
20 );
21
22
23
24 PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER
25 ,p_sql OUT NOCOPY VARCHAR2) ;
26
27 PROCEDURE ASSIGNMENT_ACTION_CODE (p_payroll_action_id IN NUMBER
28 ,p_start_person IN NUMBER
29 ,p_end_person IN NUMBER
30 ,p_chunk IN NUMBER);
31
32 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER);
33
34
35 FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER;
36
37 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
38 ,p_effective_date IN DATE);
39
40
41 END PAY_FI_ARCHIVE_TEL;