1 PACKAGE PAY_AE_ARCHIVE AS
2 /* $Header: pyaeparc.pkh 120.0.12000000.1 2007/01/17 15:22:56 appldev 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 PROCEDURE GET_ALL_PARAMETERS(p_payroll_action_id IN NUMBER
9 ,p_business_group_id OUT NOCOPY NUMBER
10 ,p_start_date OUT NOCOPY VARCHAR2
11 ,p_end_date OUT NOCOPY VARCHAR2
12 ,p_effective_date OUT NOCOPY DATE
13 ,p_payroll_id OUT NOCOPY VARCHAR2
14 ,p_consolidation_set OUT NOCOPY VARCHAR2);
15
16 PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER
17 ,p_sql OUT NOCOPY VARCHAR2) ;
18
19 PROCEDURE ASSIGNMENT_ACTION_CODE (p_payroll_action_id IN NUMBER
20 ,p_start_person IN NUMBER
21 ,p_end_person IN NUMBER
22 ,p_chunk IN NUMBER);
23
24 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER);
25
26 PROCEDURE SETUP_ELEMENT_DEFINITIONS( p_classification_name IN VARCHAR2
27 ,p_element_name IN VARCHAR2
28 ,p_element_type_id IN NUMBER
29 ,p_element_type IN VARCHAR2
30 ,p_input_value_id IN NUMBER
31 ,p_input_value IN VARCHAR2
32 ,p_uom IN VARCHAR2
33 ,p_archive_flag IN VARCHAR2);
34
35 PROCEDURE SETUP_BALANCE_DEFINITIONS(p_balance_name IN VARCHAR2
36 ,p_defined_balance_id IN NUMBER
37 ,p_balance_type_id IN NUMBER
38 ,p_uom IN VARCHAR2);
39
40 FUNCTION GET_COUNTRY_NAME(p_territory_code VARCHAR2) RETURN VARCHAR2;
41
42 PROCEDURE ARCHIVE_EMPLOYEE_DETAILS (p_archive_assact_id IN NUMBER
43 ,p_assignment_id IN NUMBER
44 ,p_assignment_action_id IN NUMBER
45 ,p_payroll_action_id IN NUMBER
46 ,p_time_period_id IN NUMBER
47 ,p_date_earned IN DATE
48 ,p_pay_date_earned IN DATE
49 ,p_effective_date IN DATE);
50
51 PROCEDURE ARCHIVE_ELEMENT_INFO( p_payroll_action_id IN NUMBER
52 ,p_effective_date IN DATE
53 ,p_date_earned IN DATE
54 ,p_pre_payact_id IN NUMBER);
55
56 PROCEDURE ARCHIVE_MAIN_ELEMENTS(p_archive_assact_id IN NUMBER,
57 p_assignment_action_id IN NUMBER,
58 p_assignment_id IN NUMBER,
59 p_date_earned IN DATE,
60 p_effective_date IN DATE );
61
62 FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER;
63
64 PROCEDURE ARCHIVE_PAYMENT_INFO(p_archive_assact_id IN NUMBER,
65 p_prepay_assact_id IN NUMBER,
66 p_assignment_id IN NUMBER,
67 p_date_earned IN DATE,
68 p_effective_date IN DATE);
69
70 PROCEDURE ARCHIVE_ADD_ELEMENT(p_archive_assact_id IN NUMBER,
71 p_assignment_action_id IN NUMBER,
72 p_assignment_id IN NUMBER,
73 p_payroll_action_id IN NUMBER,
74 p_date_earned IN DATE,
75 p_effective_date IN DATE,
76 p_pre_payact_id IN NUMBER,
77 p_archive_flag IN VARCHAR2);
78
79 PROCEDURE ARCHIVE_OTH_BALANCE(p_archive_assact_id IN NUMBER,
80 p_assignment_action_id IN NUMBER,
81 p_assignment_id IN NUMBER,
82 p_payroll_action_id IN NUMBER,
83 p_record_count IN NUMBER,
84 p_pre_payact_id IN NUMBER,
85 p_effective_date IN DATE,
86 p_date_earned IN DATE,
87 p_archive_flag IN VARCHAR2);
88
89
90 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
91 ,p_effective_date IN DATE);
92
93
94 END PAY_AE_ARCHIVE;