1 package PAY_FR_ARC_PKG AUTHID CURRENT_USER as
2 /* $Header: pyfrarch.pkh 115.10 2004/01/16 08:57:17 hwinsor 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 function get_balance_id (
10 p_balance_name in varchar2
11 ,p_dimension in varchar2) return number ;
12 --
13 procedure range_cursor(
14 pactid in number
15 ,sqlstr out nocopy varchar);
16 --
17 procedure action_creation(
18 pactid in number
19 ,stperson in number
20 ,endperson in number
21 ,chunk in number);
22 --
23 procedure archinit(
24 p_payroll_action_id in number);
25 --
26 procedure archive_code(
27 p_assactid in number
28 ,p_effective_date in date);
29 --
30 procedure archive_code_sub(
31 p_assactid in number
32 ,p_effective_date in date);
33 --
34 procedure deinitialize(
35 p_payroll_action_id in number);
36 --
37 procedure load_balances(
38 p_assignment_action_id in number
39 ,p_archive_action_id in number
40 ,p_context_id in number
41 ,p_totals_taxable_income out nocopy number);
42 --
43 procedure load_holidays(
44 p_assignment_id in number
45 ,p_person_id in number
46 ,p_effective_date in date
47 ,p_assignment_action_id in number
48 ,p_establishment_id in number
49 ,p_business_group_id in number);
50 --
51 procedure load_employee_dates(
52 p_assignment_id in number
53 ,p_effective_date in date
54 ,p_assignment_action_id in number
55 ,p_latest_date_earned in date
56 ,p_asat_date out nocopy date
57 ,p_payroll_id in number
58 ,p_establishment_id in number
59 ,p_term_reason OUT nocopy varchar2
60 ,p_term_atd OUT nocopy date
61 ,p_term_lwd OUT nocopy date
62 ,p_term_pay_schedule OUT nocopy varchar2);
63 --
64 procedure load_employee(
65 p_assignment_id in number
66 ,p_person_id in number
67 ,p_asat_date in date
68 ,p_assignment_action_id in number
69 ,p_latest_date_earned in date
70 ,p_establishment_id in number
71 ,p_ee_info_id out nocopy number);
72 --
73 procedure load_bank(
74 p_assignment_action_id in number
75 ,p_assignment_id in number
76 ,p_totals_previous_advice out nocopy number
77 ,p_totals_this_advice out nocopy number
78 ,p_totals_net_advice out nocopy number
79 ,p_establishment_id in number
80 ,p_asat_date in date);
81 --
82 procedure load_messages(
83 p_archive_assignment_action_id in number
84 ,p_establishment_id in number
85 ,p_term_atd in date
86 ,p_term_reason in varchar2);
87 --
88 procedure load_ee_rate_grouped_runs(
89 p_archive_assignment_action_id in number
90 ,p_assignment_id in number
91 ,p_latest_process_type in varchar2
92 ,p_total_gross_pay out nocopy number
93 ,p_reductions out nocopy number
94 ,p_net_payments out nocopy number
95 ,p_court_orders out nocopy number
96 ,p_establishment_id in number
97 ,p_effective_date in date
98 ,p_termination_reason in varchar2
99 ,p_term_st_ele_id in number
100 ,p_term_ex_ele_id in number
101 );
102 --
103 procedure load_deductions1(
104 p_archive_assignment_action_id in number
105 ,p_assignment_id in number
106 ,p_latest_process_type in varchar2
107 ,p_total_deduct_ee out nocopy number
108 ,p_total_deduct_er out nocopy number
109 ,p_total_charge_ee out nocopy number
110 ,p_total_charge_er out nocopy number
111 ,p_establishment_id in number
112 ,p_effective_date in date);
113 procedure load_deductions(
114 p_archive_assignment_action_id in number
115 ,p_assignment_id in number
116 ,p_latest_process_type in varchar2
117 ,p_total_deduct_ee out nocopy number
118 ,p_total_deduct_er out nocopy number
119 ,p_total_charge_ee out nocopy number
120 ,p_total_charge_er out nocopy number
121 ,p_establishment_id in number
122 ,p_effective_date in date);
123 --
124 procedure load_rate_grouped_runs(
125 p_archive_assignment_action_id in number
126 ,p_assignment_id in number
127 ,p_latest_process_type in varchar2
128 ,p_total_ee_net_deductions out nocopy number
129 ,p_establishment_id in number
130 ,p_total_gross_pay in out nocopy number
131 ,p_effective_date in date);
132 --
133 procedure load_payslip_text (
134 p_action_id in number);
135 --
136 procedure get_all_parameters (
137 p_payroll_action_id in number
138 ,p_payroll_id out nocopy number
139 ,p_assignment_id out nocopy number
140 ,p_assignment_set_id out nocopy number
141 ,p_business_group_id out nocopy number
142 ,p_start_date out nocopy date
143 ,p_effective_date out nocopy date);
144 --
145 -- Support objects
146 --
147 procedure get_latest_run_data(
148 p_archive_action_id in number
149 ,p_assignment_id in number
150 ,p_establishment_id in number
151 ,p_date_earned out nocopy date
152 ,p_latest_process_type out nocopy varchar2
153 ,p_latest_assignment_action_id out nocopy number);
154 --
155 procedure load_organization_details(
156 p_payroll_action_id in number
157 ,p_business_Group_id in number
158 ,p_payroll_id in number
159 ,p_assignment_id in number
160 ,p_assignment_set_id in number
161 ,p_effective_date in date
162 ,p_start_date in date);
163 --
164 procedure get_instance_variables (
165 p_assignment_action_id in number
166 ,p_person_id out nocopy number
167 ,p_establishment_id out nocopy number
168 ,p_assignment_id out nocopy number
169 ,p_payroll_id out nocopy number);
170 --
171 procedure write_archive(
172 p_action_context_id in number
173 ,p_action_context_type in varchar2
174 ,p_rubric in varchar2
175 ,p_rubric_sort in number
176 ,p_tax_unit_id in number
177 ,p_context_prefix in varchar2
178 ,p_action_information_category in varchar2
179 ,p_action_information4 in varchar2 default null
180 ,p_action_information5 in varchar2 default null
181 ,p_action_information6 in varchar2 default null
182 ,p_action_information7 in varchar2 default null
183 ,p_action_information8 in varchar2 default null
184 ,p_action_information9 in varchar2 default null
185 ,p_action_information10 in varchar2 default null
186 ,p_action_information11 in varchar2 default null
187 ,p_action_information12 in varchar2 default null
188 ,p_action_information13 in varchar2 default null );
189 --
190 end PAY_FR_ARC_PKG;