[Home] [Help]
PACKAGE: APPS.PAY_WF_PKG
Source
1 PACKAGE PAY_WF_PKG AS
2 /* $Header: payuswfpkg.pkh 120.1 2005/10/10 16:35:44 jgoswami noship $
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_WF_PKG
25 Package File Name : payuswfpkg.pkh
26 Description : This package declares functions which are ....
27
28 Change List
29 -----------
30 Date Name Vers Description
31 ---- ---- ---- -----------
32 08-JUN-2003 jgoswami 115.0 Created
33 06-AUG-2003 jgoswami 115.3 No Copy changes.
34 26-AUG-2003 jgoswami 115.4 modified parameter sequence to
35 corelate with the SRS definition.
36 10-OCT-2005 jgoswami 115.6 modified procedure,added parameter for
37 check_writer and Costing Reports
38
39 *******************************************************************/
40 procedure payroll_wf_process(errbuf OUT nocopy VARCHAR2,
41 retcode OUT nocopy NUMBER,
42 p_wf_item_type Varchar2 ,
43 p_business_group_id number ,
44 p_batch_id number ,
45 p_payroll_id varchar2,
46 p_payroll_id_dummy varchar2 ,
47 p_consolidation_set_id varchar2,
48 p_consolidation_set_id_dummy varchar2 ,
49 p_date_earned varchar2,
50 p_date_paid varchar2,
51 p_period varchar2,
52 p_payroll_element_set_name varchar2,
53 p_payroll_assignment_set_name varchar2,
54 p_payroll_run_type varchar2,
55 p_event_group varchar2,
56 p_retro_assignment_set_name varchar2,
57 p_retro_assignment_set_dummy varchar2,
58 p_retro_element_set varchar2,
59 p_retro_start_date varchar2,
60 p_effective_date varchar2,
61 p_gre varchar2,
62 p_gre_id_dummy varchar2,
63 p_p_payroll_action_id varchar2,
64 p_organization varchar2,
65 p_location varchar2,
66 p_legislation_code varchar2,
67 p_select_report_or_group varchar2,
68 p_is_exception_group varchar2,
69 p_exception_group_name varchar2,
70 p_exception_group_name_dummy varchar2,
71 p_is_exception_report varchar2,
72 p_exception_report_name varchar2,
73 p_exception_report_name_dummy varchar2,
74 p_over_ride_variance_type varchar2,
75 p_over_ride_varianc_type_dumy varchar2,
76 p_over_ride_variance_value varchar2,
77 p_over_ride_varinc_value_dumy varchar2,
78 p_payment_method_override varchar2,
79 p_nacha_payment_type varchar2,
80 p_nacha_payment_method varchar2,
81 p_deposit_date_override varchar2,
82 p_file_id_modifier varchar2,
83 p_file_id_modifier_check varchar2,
84 p_thrid_party_check varchar2,
85 p_check_writer_payment_type varchar2,
86 p_check_style varchar2,
87 p_check_writer_payment_method varchar2,
88 p_check_writer_sort_sequence varchar2,
89 p_start_check_number varchar2,
90 p_end_check_number varchar2,
91 p_overriding_cheque_date varchar2,
92 p_payment_method_3rd_party varchar2,
93 p_sort_sequence_3rd_party varchar2,
94 p_start_check_num_3rd_party varchar2,
95 p_end_check_num_3rd_party varchar2,
96 p_da_report_category varchar2,
97 p_da_sort_sequence varchar2,
98 p_da_assignment_set varchar2,
99 p_assignment_set_dummy varchar2,
100 p_selection_criterion varchar2,
101 p_is_element_set varchar2,
102 p_ele_reg_element_set varchar2,
103 p_is_element_classification varchar2,
104 p_element_classification varchar2,
105 p_is_element_name varchar2,
106 p_element varchar2,
107 p_ele_reg_employee varchar2,
108 p_costing_process varchar2,
109 p_dummy_cost_run varchar2,
110 p_cost_summary_accruals varchar2,
111 p_cost_summary_file_out varchar2,
112 p_cost_detail_selection varchar2,
113 p_cost_detail_is_ele_set varchar2,
114 p_cost_detail_ele_set varchar2,
115 p_cost_detail_is_class varchar2,
116 p_cost_detail_class varchar2,
117 p_cost_detail_is_element varchar2,
118 p_cost_detail_element varchar2,
119 p_cost_detail_asg_set varchar2,
120 p_cost_detail_accruals varchar2,
121 p_start_date varchar2,
122 p_end_date varchar2,
123 p_ppa_finder varchar2,
124 p_ppa_finder_pqp varchar2
125 );
126
127
128 procedure StartProcess (
129 p_business_group_id number ,
130 p_batch_id number ,
131 p_payroll_id varchar2,
132 p_payroll_id_dummy varchar2 ,
133 p_consolidation_set_id varchar2,
134 p_consolidation_set_id_dummy varchar2 ,
135 p_date_earned varchar2,
136 p_date_paid varchar2,
137 p_period varchar2,
138 p_payroll_element_set_name varchar2,
139 p_payroll_assignment_set_name varchar2,
140 p_payroll_run_type varchar2,
141 p_event_group varchar2,
142 p_retro_assignment_set_name varchar2,
143 p_retro_assignment_set_dummy varchar2,
144 p_retro_element_set varchar2,
145 p_retro_start_date varchar2,
146 p_effective_date varchar2,
147 p_gre varchar2,
148 p_gre_id_dummy varchar2,
149 p_p_payroll_action_id varchar2,
150 p_organization varchar2,
151 p_location varchar2,
152 p_legislation_code varchar2,
153 p_select_report_or_group varchar2,
154 p_is_exception_group varchar2,
155 p_exception_group_name varchar2,
156 p_exception_group_name_dummy varchar2,
157 p_is_exception_report varchar2,
158 p_exception_report_name varchar2,
159 p_exception_report_name_dummy varchar2,
160 p_over_ride_variance_type varchar2,
161 p_over_ride_varianc_type_dumy varchar2,
162 p_over_ride_variance_value varchar2,
163 p_over_ride_varinc_value_dumy varchar2,
164 p_payment_method_override varchar2,
165 p_nacha_payment_type varchar2,
166 p_nacha_payment_method varchar2,
167 p_deposit_date_override varchar2,
168 p_file_id_modifier varchar2,
169 p_file_id_modifier_check varchar2,
170 p_thrid_party_check varchar2,
171 p_check_writer_payment_type varchar2,
172 p_check_style varchar2,
173 p_check_writer_payment_method varchar2,
174 p_check_writer_sort_sequence varchar2,
175 p_start_check_number varchar2,
176 p_end_check_number varchar2,
177 p_overriding_cheque_date varchar2,
178 p_payment_method_3rd_party varchar2,
179 p_sort_sequence_3rd_party varchar2,
180 p_start_check_num_3rd_party varchar2,
181 p_end_check_num_3rd_party varchar2,
182 p_da_report_category varchar2,
183 p_da_sort_sequence varchar2,
184 p_da_assignment_set varchar2,
185 p_assignment_set_dummy varchar2,
186 p_selection_criterion varchar2,
187 p_is_element_set varchar2,
188 p_ele_reg_element_set varchar2,
189 p_is_element_classification varchar2,
190 p_element_classification varchar2,
191 p_is_element_name varchar2,
192 p_element varchar2,
193 p_ele_reg_employee varchar2,
194 p_costing_process varchar2,
195 p_dummy_cost_run varchar2,
196 p_cost_summary_accruals varchar2,
197 p_cost_summary_file_out varchar2,
198 p_cost_detail_selection varchar2,
199 p_cost_detail_is_ele_set varchar2,
200 p_cost_detail_ele_set varchar2,
201 p_cost_detail_is_class varchar2,
202 p_cost_detail_class varchar2,
203 p_cost_detail_is_element varchar2,
204 p_cost_detail_element varchar2,
205 p_cost_detail_asg_set varchar2,
206 p_cost_detail_accruals varchar2,
207 p_start_date varchar2,
208 p_end_date varchar2,
209 p_ppa_finder varchar2,
210 p_ppa_finder_pqp varchar2,
211 ProcessDesc in varchar2,
212 RequestorUsername in Varchar2,
213 ProcessOwner in Varchar2,
214 Workflowprocess in Varchar2 ,
215 item_type in Varchar2 ,
216 item_key in varchar2
217 ) ;
218
219
220
221 function get_notifier( ln_payroll_id in number,
222 ln_gre_id in number,
223 l_effective_date in varchar2
224 ) return varchar2 ;
225
226
227 procedure error;
228 gv_package VARCHAR2(50);
229
230 end PAY_WF_PKG;