[Home] [Help]
PACKAGE: APPS.PAY_CA_WF_PKG
Source
1 PACKAGE pay_ca_wf_pkg AUTHID CURRENT_USER AS
2 /* $Header: paycawfpkg.pkh 120.3 2012/01/19 07:56:34 rpahune ship $ */
3
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
8 * Chertsey, England. *
9 * *
10 * All rights reserved. *
11 * *
12 * This material has been provided pursuant to an agreement *
13 * containing restrictions on its use. The material is also *
14 * protected by copyright law. No part of this material may *
15 * be copied or distributed, transmitted or transcribed, in *
16 * any form or by any means, electronic, mechanical, magnetic, *
17 * manual, or otherwise, or disclosed to third parties without *
18 * the express written permission of Oracle Corporation UK Ltd, *
19 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
20 * England. *
21 * *
22 ******************************************************************
23
24 Package Body Name : pay_ca_wf_pkg
25 Package File Name : paycawfpkg.pkh
26 Description : This package declares functions which are used by the
27 Canadian Payroll Workflow process
28
29 Change List
30 -----------
31 Date Name Vers Description
32 ---- ---- ---- -----------
33 15-JUN-2004 ssouresr 115.0 Created
34 23-Jun-2011 rgottipa 115.1 Overloaded the procedures
35 payroll_wf_process and StartProcess
36 to resolving bug 10287946
37 15-Jul-2011 rgottipa 115.2 Added parameters to overloaded procedures
38 payroll_wf_process and StartProcess
39 to call Retro-Notification (enhanced) PDF
40 and RetroPay (enhanced)
41 *******************************************************************/
42
43 procedure payroll_wf_process(errbuf OUT nocopy varchar2,
44 retcode OUT nocopy number,
45 p_wf_item_type varchar2,
46 p_business_group_id number ,
47 p_batch_id number ,
48 p_payroll_id varchar2,
49 p_consolidation_set_id varchar2,
50 p_date_earned varchar2,
51 p_date_paid varchar2,
52 p_retro_event_group varchar2,
53 p_retro_assignment_set varchar2,
54 p_retropay_assignment_set varchar2,
55 p_retropay_element_set varchar2,
56 p_retro_start_date varchar2,
57 p_payroll_element_set varchar2,
58 p_payroll_assignment_set varchar2,
59 p_payroll_run_type varchar2,
60 p_gre_or_tax_group varchar2,
61 p_is_gre varchar2,
62 p_gre varchar2,
63 p_is_tax_group varchar2,
64 p_tax_group varchar2,
65 p_gross_to_net_period varchar2,
66 p_payroll_process varchar2,
67 p_session_date varchar2,
68 p_organization varchar2,
69 p_location varchar2,
70 p_quebec varchar2,
71 p_qhsf_account_number varchar2,
72 p_qhsf_override_table varchar2,
73 p_sdr_federal varchar2,
74 p_sdr_province varchar2,
75 p_sdr_reporting_dimension varchar2,
76 p_exp_legislation_code varchar2,
77 p_exp_report_or_group varchar2,
78 p_exp_is_group varchar2,
79 p_exp_group_name varchar2,
80 p_exp_is_report varchar2,
81 p_exp_report_name varchar2,
82 p_exp_variance_type varchar2,
83 p_exp_variance_value varchar2,
84 p_payment_method_override varchar2,
85 p_ele_selection_criterion varchar2,
86 p_ele_is_element_set varchar2,
87 p_ele_element_set varchar2,
88 p_ele_is_element_class varchar2,
89 p_ele_element_class varchar2,
90 p_ele_is_element_name varchar2,
91 p_ele_element_name varchar2,
92 p_ele_employee varchar2,
93 p_deduction_class varchar2,
94 p_deduction_name varchar2,
95 p_deduction_sort_one varchar2,
96 p_deduction_sort_two varchar2,
97 p_deduction_sort_three varchar2,
98 p_reg_suppress_zero varchar2,
99 p_reg_full_report_ver varchar2,
100 p_reg_reporting_dim varchar2,
101 p_reg_sort_one varchar2,
102 p_reg_sort_two varchar2,
103 p_reg_sort_three varchar2,
104 p_reg_employee_page_break varchar2,
105 p_reg_req_num varchar2,
106 p_dd_payment_type varchar2,
107 p_dd_payment_method varchar2,
108 p_dd_override_date varchar2,
109 p_dd_financial_inst varchar2,
110 p_dd_cpa_code varchar2,
111 p_dd_file_number varchar2,
112 p_cheque_payment_type varchar2,
113 p_cheque_payment_method varchar2,
114 p_cheque_sort_sequence varchar2,
115 p_cheque_style varchar2,
116 p_start_cheque_number varchar2,
117 p_end_cheque_number varchar2,
118 p_da_data_type varchar2,
119 p_payment_rep_payment_type varchar2,
120 p_payment_rep_payment_method varchar2,
121 p_roe_assignment_set varchar2,
122 p_roe_worksheet_person varchar2,
123 p_roe_mag_media_person varchar2,
124 p_roe_mag_roe_type varchar2,
125 p_cost_summary_accruals varchar2,
126 p_cost_summary_file_out varchar2,
127 p_cost_detail_selection varchar2,
128 p_cost_detail_is_ele_set varchar2,
129 p_cost_detail_ele_set varchar2,
130 p_cost_detail_is_class varchar2,
131 p_cost_detail_class varchar2,
132 p_cost_detail_is_element varchar2,
133 p_cost_detail_element varchar2,
134 p_cost_detail_asg_set varchar2,
135 p_cost_detail_accruals varchar2
136 );
137
138 procedure payroll_wf_process(errbuf OUT nocopy varchar2,
139 retcode OUT nocopy number,
140 p_wf_item_type varchar2,
141 p_business_group_id number ,
142 p_batch_id number ,
143 p_payroll_id varchar2,
144 p_consolidation_set_id varchar2,
145 p_date_earned varchar2,
146 p_date_paid varchar2,
147 p_retro_event_group varchar2,
148 p_retro_valid_template_list varchar2,--bug 12704242
149 p_retro_template_name varchar2,--bug 12704242
150 p_retro_assignment_set varchar2,
151 p_retro_generate_report varchar2,--bug 12704242
152 p_retropay_assignment_set varchar2,
153 p_retropay_element_set varchar2,
154 p_retro_start_date varchar2,
155 p_retropay_entry_creation_date varchar2, --bug 12704242
156 p_payroll_element_set varchar2,
157 p_payroll_assignment_set varchar2,
158 p_payroll_run_type varchar2,
159 p_gre_or_tax_group varchar2,
160 p_is_gre varchar2,
161 p_gre varchar2,
162 p_is_tax_group varchar2,
163 p_tax_group varchar2,
164 p_gross_to_net_period varchar2,
165 p_payroll_process varchar2,
166 p_session_date varchar2,
167 p_organization varchar2,
168 p_location varchar2,
169 p_quebec varchar2,
170 p_qhsf_account_number varchar2,
171 p_qhsf_override_table varchar2,
172 p_sdr_federal varchar2,
173 p_sdr_province varchar2,
174 p_sdr_reporting_dimension varchar2,
175 p_exp_legislation_code varchar2,
176 p_exp_report_or_group varchar2,
177 p_exp_is_group varchar2,
178 p_exp_group_name varchar2,
179 p_exp_is_report varchar2,
180 p_exp_report_name varchar2,
181 p_exp_variance_type varchar2,
182 p_exp_variance_value varchar2,
183 p_payment_method_override varchar2,
184 p_ele_selection_criterion varchar2,
185 p_ele_is_element_set varchar2,
186 p_ele_element_set varchar2,
187 p_ele_is_element_class varchar2,
188 p_ele_element_class varchar2,
189 p_ele_is_element_name varchar2,
190 p_ele_element_name varchar2,
191 p_ele_employee varchar2,
192 p_deduction_class varchar2,
193 p_deduction_name varchar2,
194 p_deduction_sort_one varchar2,
195 p_deduction_sort_two varchar2,
196 p_deduction_sort_three varchar2,
197 p_reg_suppress_zero varchar2,
198 p_reg_full_report_ver varchar2,
199 p_reg_reporting_dim varchar2,
200 p_reg_sort_one varchar2,
201 p_reg_sort_two varchar2,
202 p_reg_sort_three varchar2,
203 p_reg_employee_page_break varchar2,
204 p_reg_req_num varchar2,
205 p_dd_payment_type varchar2,
206 p_dd_payment_method varchar2,
207 p_dd_override_date varchar2,
208 p_dd_financial_inst varchar2,
209 p_dd_cpa_code varchar2,
210 p_dd_file_number varchar2,
211 p_cheque_payment_type varchar2,
212 p_cheque_payment_method varchar2,
213 p_cheque_sort_sequence varchar2,
214 p_cheque_style varchar2,
215 p_start_cheque_number varchar2,
216 p_end_cheque_number varchar2,
217 p_da_data_type varchar2,
218 p_payment_rep_payment_type varchar2,
219 p_payment_rep_payment_method varchar2,
220 p_roe_assignment_set varchar2,
221 p_roe_worksheet_person varchar2,
222 p_roe_mag_media_person varchar2,
223 p_roe_mag_roe_type varchar2,
224 p_cost_summary_accruals varchar2,
225 p_cost_summary_file_out varchar2,
226 p_cost_detail_selection varchar2,
227 p_cost_detail_is_ele_set varchar2,
228 p_cost_detail_ele_set varchar2,
229 p_cost_detail_is_class varchar2,
230 p_cost_detail_class varchar2,
231 p_cost_detail_is_element varchar2,
232 p_cost_detail_element varchar2,
233 p_cost_detail_asg_set varchar2,
234 p_cost_detail_accruals varchar2,
235 p_action_parameter_group varchar2 -- bug 12548555
236 );
237 procedure StartProcess (p_business_group_id number ,
238 p_batch_id number ,
239 p_payroll_id varchar2,
240 p_consolidation_set_id varchar2,
241 p_date_earned varchar2,
242 p_date_paid varchar2,
243 p_retro_event_group varchar2,
244 p_retro_assignment_set varchar2,
245 p_retropay_assignment_set varchar2,
246 p_retropay_element_set varchar2,
247 p_retro_start_date varchar2,
248 p_payroll_element_set varchar2,
249 p_payroll_assignment_set varchar2,
250 p_payroll_run_type varchar2,
251 p_gre_or_tax_group varchar2,
252 p_is_gre varchar2,
253 p_gre varchar2,
254 p_is_tax_group varchar2,
255 p_tax_group varchar2,
256 p_gross_to_net_period varchar2,
257 p_payroll_process varchar2,
258 p_session_date varchar2,
259 p_organization varchar2,
260 p_location varchar2,
261 p_quebec varchar2,
262 p_qhsf_account_number varchar2,
263 p_qhsf_override_table varchar2,
264 p_sdr_federal varchar2,
265 p_sdr_province varchar2,
266 p_sdr_reporting_dimension varchar2,
267 p_exp_legislation_code varchar2,
268 p_exp_report_or_group varchar2,
269 p_exp_is_group varchar2,
270 p_exp_group_name varchar2,
271 p_exp_is_report varchar2,
272 p_exp_report_name varchar2,
273 p_exp_variance_type varchar2,
274 p_exp_variance_value varchar2,
275 p_payment_method_override varchar2,
276 p_ele_selection_criterion varchar2,
277 p_ele_is_element_set varchar2,
278 p_ele_element_set varchar2,
279 p_ele_is_element_class varchar2,
280 p_ele_element_class varchar2,
281 p_ele_is_element_name varchar2,
282 p_ele_element_name varchar2,
283 p_ele_employee varchar2,
284 p_deduction_class varchar2,
285 p_deduction_name varchar2,
286 p_deduction_sort_one varchar2,
287 p_deduction_sort_two varchar2,
288 p_deduction_sort_three varchar2,
289 p_reg_suppress_zero varchar2,
290 p_reg_full_report_ver varchar2,
291 p_reg_reporting_dim varchar2,
292 p_reg_sort_one varchar2,
293 p_reg_sort_two varchar2,
294 p_reg_sort_three varchar2,
295 p_reg_employee_page_break varchar2,
296 p_reg_req_num varchar2,
297 p_dd_payment_type varchar2,
298 p_dd_payment_method varchar2,
299 p_dd_override_date varchar2,
300 p_dd_financial_inst varchar2,
301 p_dd_cpa_code varchar2,
302 p_dd_file_number varchar2,
303 p_cheque_payment_type varchar2,
304 p_cheque_payment_method varchar2,
305 p_cheque_sort_sequence varchar2,
306 p_cheque_style varchar2,
307 p_start_cheque_number varchar2,
308 p_end_cheque_number varchar2,
309 p_da_data_type varchar2,
310 p_payment_rep_payment_type varchar2,
311 p_payment_rep_payment_method varchar2,
315 p_roe_mag_roe_type varchar2,
312 p_roe_assignment_set varchar2,
313 p_roe_worksheet_person varchar2,
314 p_roe_mag_media_person varchar2,
316 p_cost_summary_accruals varchar2,
317 p_cost_summary_file_out varchar2,
318 p_cost_detail_selection varchar2,
319 p_cost_detail_is_ele_set varchar2,
320 p_cost_detail_ele_set varchar2,
321 p_cost_detail_is_class varchar2,
322 p_cost_detail_class varchar2,
323 p_cost_detail_is_element varchar2,
324 p_cost_detail_element varchar2,
325 p_cost_detail_asg_set varchar2,
326 p_cost_detail_accruals varchar2,
327 ProcessDesc in varchar2,
328 RequestorUsername in varchar2,
329 ProcessOwner in varchar2,
330 Workflowprocess in varchar2 default null,
331 item_type in varchar2 default null,
332 item_key in varchar2);
333
334 procedure StartProcess (p_business_group_id number ,
335 p_batch_id number ,
336 p_payroll_id varchar2,
337 p_consolidation_set_id varchar2,
338 p_date_earned varchar2,
339 p_date_paid varchar2,
340 p_retro_event_group varchar2,
341 p_retro_valid_template_list varchar2,--bug 12704242
342 p_retro_template_name varchar2,--bug 12704242
343 p_retro_assignment_set varchar2,
344 p_retro_generate_report varchar2,--bug 12704242
345 p_retropay_assignment_set varchar2,
346 p_retropay_element_set varchar2,
347 p_retro_start_date varchar2,
348 p_retropay_entry_creation_date varchar2, --bug 12704242
349 p_payroll_element_set varchar2,
350 p_payroll_assignment_set varchar2,
351 p_payroll_run_type varchar2,
352 p_gre_or_tax_group varchar2,
353 p_is_gre varchar2,
354 p_gre varchar2,
355 p_is_tax_group varchar2,
356 p_tax_group varchar2,
357 p_gross_to_net_period varchar2,
358 p_payroll_process varchar2,
359 p_session_date varchar2,
360 p_organization varchar2,
361 p_location varchar2,
362 p_quebec varchar2,
363 p_qhsf_account_number varchar2,
364 p_qhsf_override_table varchar2,
365 p_sdr_federal varchar2,
366 p_sdr_province varchar2,
367 p_sdr_reporting_dimension varchar2,
368 p_exp_legislation_code varchar2,
369 p_exp_report_or_group varchar2,
370 p_exp_is_group varchar2,
371 p_exp_group_name varchar2,
372 p_exp_is_report varchar2,
373 p_exp_report_name varchar2,
374 p_exp_variance_type varchar2,
375 p_exp_variance_value varchar2,
376 p_payment_method_override varchar2,
377 p_ele_selection_criterion varchar2,
378 p_ele_is_element_set varchar2,
379 p_ele_element_set varchar2,
380 p_ele_is_element_class varchar2,
381 p_ele_element_class varchar2,
382 p_ele_is_element_name varchar2,
383 p_ele_element_name varchar2,
384 p_ele_employee varchar2,
385 p_deduction_class varchar2,
386 p_deduction_name varchar2,
387 p_deduction_sort_one varchar2,
388 p_deduction_sort_two varchar2,
389 p_deduction_sort_three varchar2,
390 p_reg_suppress_zero varchar2,
391 p_reg_full_report_ver varchar2,
392 p_reg_reporting_dim varchar2,
393 p_reg_sort_one varchar2,
394 p_reg_sort_two varchar2,
395 p_reg_sort_three varchar2,
396 p_reg_employee_page_break varchar2,
397 p_reg_req_num varchar2,
398 p_dd_payment_type varchar2,
399 p_dd_payment_method varchar2,
400 p_dd_override_date varchar2,
401 p_dd_financial_inst varchar2,
402 p_dd_cpa_code varchar2,
403 p_dd_file_number varchar2,
404 p_cheque_payment_type varchar2,
405 p_cheque_payment_method varchar2,
406 p_cheque_sort_sequence varchar2,
407 p_cheque_style varchar2,
408 p_start_cheque_number varchar2,
412 p_payment_rep_payment_method varchar2,
409 p_end_cheque_number varchar2,
410 p_da_data_type varchar2,
411 p_payment_rep_payment_type varchar2,
413 p_roe_assignment_set varchar2,
414 p_roe_worksheet_person varchar2,
415 p_roe_mag_media_person varchar2,
416 p_roe_mag_roe_type varchar2,
417 p_cost_summary_accruals varchar2,
418 p_cost_summary_file_out varchar2,
419 p_cost_detail_selection varchar2,
420 p_cost_detail_is_ele_set varchar2,
421 p_cost_detail_ele_set varchar2,
422 p_cost_detail_is_class varchar2,
423 p_cost_detail_class varchar2,
424 p_cost_detail_is_element varchar2,
425 p_cost_detail_element varchar2,
426 p_cost_detail_asg_set varchar2,
427 p_cost_detail_accruals varchar2,
428 p_action_parameter_group varchar2, -- bug 12548555
429 ProcessDesc in varchar2,
430 RequestorUsername in varchar2,
431 ProcessOwner in varchar2,
432 Workflowprocess in varchar2 default null,
433 item_type in varchar2 default null,
434 item_key in varchar2);
435
436
437 function get_notifier(p_payroll_id in number,
438 p_gre_id in number,
439 p_effective_date in varchar2) return varchar2;
440
441 procedure error;
442
443 gv_package varchar2(50);
444
445 end pay_ca_wf_pkg;