1 PACKAGE PAY_NL_ABP_ARCHIVE AUTHID CURRENT_USER as
2 /* $Header: pynlabpar.pkh 120.0.12020000.1 2012/08/10 12:24:05 asudhaka noship $ */
3
4 level_cnt number;
5
6 TYPE PTPData IS RECORD (start_date DATE
7 ,end_date DATE
8 ,ptp NUMBER);
9
10 TYPE tPTPData IS TABLE OF PTPData INDEX BY BINARY_INTEGER;
11
12 TYPE PENSIONData IS RECORD (pension_type VARCHAR2(6)
13 ,pension_type_variant VARCHAR2(3) DEFAULT NULL
14 ,contr_base NUMBER DEFAULT NULL
15 ,contr_amt NUMBER DEFAULT NULL
16 ,date_earned DATE);
17
18 TYPE tPENSIONData IS TABLE OF PENSIONData INDEX BY BINARY_INTEGER;
19
20 PROCEDURE get_all_parameters (p_payroll_action_id IN NUMBER
21 ,p_org_struct_id OUT NOCOPY NUMBER
22 ,p_org_id OUT NOCOPY NUMBER
23 ,p_report_type OUT NOCOPY VARCHAR2
24 ,p_seq_num OUT NOCOPY NUMBER
25 ,p_bg_id OUT NOCOPY NUMBER
26 ,p_start_date OUT NOCOPY DATE
27 ,p_end_date OUT NOCOPY DATE);
28
29 FUNCTION get_parameter (p_parameter_string IN VARCHAR2
30 ,p_token IN VARCHAR2
31 ,p_segment_number IN NUMBER DEFAULT NULL )
32 RETURN VARCHAR2;
33
34 PROCEDURE range_code (pactid IN NUMBER
35 ,sqlstr OUT NOCOPY VARCHAR2);
36
37 PROCEDURE initialization_code(p_action_context_id in number);
38
39 PROCEDURE assignment_action_code (p_payroll_action_id IN NUMBER
40 ,p_start_person_id IN NUMBER
41 ,p_end_person_id IN NUMBER
42 ,p_chunk IN NUMBER);
43
44 PROCEDURE archive_code (p_assignment_action_id IN NUMBER
45 ,p_effective_date IN DATE);
46
47
48 PROCEDURE deinitialization_code(p_payroll_action_id IN NUMBER);
49
50 END PAY_NL_ABP_ARCHIVE;