1 PACKAGE PAY_FI_ARCHIVE_MTRA AUTHID CURRENT_USER AS
2 /* $Header: pyfimtra.pkh 120.0.12000000.1 2007/01/17 19:25:00 appldev 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_legal_employer_id OUT NOCOPY NUMBER
13 ,p_local_unit_id OUT NOCOPY NUMBER
14 ,p_adjustment_wt OUT NOCOPY NUMBER
15 ,p_adjustment_ss OUT NOCOPY NUMBER
16 ,p_adjustment_ts OUT NOCOPY NUMBER
17 ,p_vat OUT NOCOPY NUMBER
18 ,p_month OUT NOCOPY VARCHAR2
19 ,p_year OUT NOCOPY VARCHAR2
20 ,p_due_date OUT NOCOPY DATE
21 ,p_ref_number OUT NOCOPY NUMBER
22 ,p_effective_date OUT NOCOPY DATE
23 ,p_archive OUT NOCOPY VARCHAR2);
24
25 PROCEDURE RANGE_CODE
26 (p_payroll_action_id IN NUMBER
27 ,p_sql OUT NOCOPY VARCHAR2) ;
28
29 PROCEDURE ASSIGNMENT_ACTION_CODE
30 (p_payroll_action_id IN NUMBER
31 ,p_start_person IN NUMBER
32 ,p_end_person IN NUMBER
33 ,p_chunk IN NUMBER);
34
35 PROCEDURE INITIALIZATION_CODE
36 (p_payroll_action_id IN NUMBER);
37
38
39 PROCEDURE ARCHIVE_CODE
40 (p_assignment_action_id IN NUMBER
41 ,p_effective_date IN DATE);
42
43 END PAY_FI_ARCHIVE_MTRA;