[Home] [Help]
PACKAGE: APPS.PAY_ELEMENT_TYPES_PKG
Source
1 package PAY_ELEMENT_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: pyelt.pkh 120.2.12010000.1 2008/07/27 22:31:25 appldev ship $ */
3
4 --------------------------------------------------------------------------------
5 procedure validate_translation (element_type_id IN number,
6 language IN varchar2,
7 element_name IN varchar2,
8 reporting_name IN varchar2,
9 description IN varchar2);
10 --------------------------------------------------------------------------------
11 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
12 p_legislation_code IN VARCHAR2);
13 --------------------------------------------------------------------------------
14 function ELEMENT_START_DATE (p_element_type_id number) return date;
15 --------------------------------------------------------------------------------
16 function ELEMENT_END_DATE (p_element_type_id number) return date;
17 --------------------------------------------------------------------------------
18 procedure CHECK_FOR_PAYLINK_BATCHES (
19 --
20 p_element_type_id number,
21 p_element_name varchar2);
22 --------------------------------------------------------------------------------
23 procedure RECREATE_DB_ITEMS (
24 --
25 p_element_type_id number,
26 p_effective_start_date date default to_date ('01/01/0001','DD/MM/YYYY'));
27 --------------------------------------------------------------------------------
28 procedure INSERT_ROW(
29 --
30 p_rowid in out nocopy varchar2,
31 p_element_type_id in out nocopy number,
32 p_effective_start_date date,
33 p_effective_end_date date,
34 p_business_group_id number,
35 p_legislation_code varchar2,
36 p_formula_id number,
37 p_input_currency_code varchar2,
38 p_output_currency_code varchar2,
39 p_classification_id number,
40 p_benefit_classification_id number,
41 p_additional_entry_allowed varchar2,
42 p_adjustment_only_flag varchar2,
43 p_closed_for_entry_flag varchar2,
44 p_element_name varchar2,
45 -- --
46 p_base_element_name varchar2,
47 -- --
48 p_indirect_only_flag varchar2,
49 p_multiple_entries_allowed varchar2,
50 p_multiply_value_flag varchar2,
51 p_post_termination_rule varchar2,
52 p_process_in_run_flag varchar2,
53 p_processing_priority number,
54 p_processing_type varchar2,
55 p_standard_link_flag varchar2,
56 p_comment_id number,
57 p_description varchar2,
58 p_legislation_subgroup varchar2,
59 p_qualifying_age number,
60 p_qualifying_length_of_service number,
61 p_qualifying_units varchar2,
62 p_reporting_name varchar2,
63 p_attribute_category varchar2,
64 p_attribute1 varchar2,
65 p_attribute2 varchar2,
66 p_attribute3 varchar2,
67 p_attribute4 varchar2,
68 p_attribute5 varchar2,
69 p_attribute6 varchar2,
70 p_attribute7 varchar2,
71 p_attribute8 varchar2,
72 p_attribute9 varchar2,
73 p_attribute10 varchar2,
74 p_attribute11 varchar2,
75 p_attribute12 varchar2,
76 p_attribute13 varchar2,
77 p_attribute14 varchar2,
78 p_attribute15 varchar2,
79 p_attribute16 varchar2,
80 p_attribute17 varchar2,
81 p_attribute18 varchar2,
82 p_attribute19 varchar2,
83 p_attribute20 varchar2,
84 p_element_information_category varchar2,
85 p_element_information1 varchar2,
86 p_element_information2 varchar2,
87 p_element_information3 varchar2,
88 p_element_information4 varchar2,
89 p_element_information5 varchar2,
90 p_element_information6 varchar2,
91 p_element_information7 varchar2,
92 p_element_information8 varchar2,
93 p_element_information9 varchar2,
94 p_element_information10 varchar2,
95 p_element_information11 varchar2,
96 p_element_information12 varchar2,
97 p_element_information13 varchar2,
98 p_element_information14 varchar2,
99 p_element_information15 varchar2,
100 p_element_information16 varchar2,
101 p_element_information17 varchar2,
102 p_element_information18 varchar2,
103 p_element_information19 varchar2,
104 p_element_information20 varchar2,
105 p_non_payments_flag varchar2,
106 p_default_benefit_uom varchar2,
107 p_contributions_used varchar2,
108 p_third_party_pay_only_flag varchar2,
109 p_retro_summ_ele_id number default null,
110 p_iterative_flag varchar2 default null,
111 p_iterative_formula_id number default null,
112 p_iterative_priority number default null,
113 p_process_mode varchar2 default null,
114 p_grossup_flag varchar2 default null,
115 p_advance_indicator varchar2 default null,
116 p_advance_payable varchar2 default null,
117 p_advance_deduction varchar2 default null,
118 p_process_advance_entry varchar2 default null,
119 p_proration_group_id number default null,
120 --Code added by prsundar for Continous calculation enhancement
121 p_proration_formula_id number default null,
122 p_recalc_event_group_id number default null,
123 p_once_each_period_flag varchar2 default null,
124 -- Added for FLSA Dynamic Period Allocation
125 p_time_definition_type varchar2 default null,
126 p_time_definition_id varchar2 default null,
127 -- Added for Advance Pay Enhancement
128 p_advance_element_type_id number default null,
129 p_deduction_element_type_id number default null
130 );
131 --------------------------------------------------------------------------------
132 PROCEDURE UPDATE_ROW(
133 --
134 p_rowid varchar2,
135 p_element_type_id number,
136 p_effective_start_date date,
137 p_effective_end_date date,
138 p_business_group_id number,
139 p_legislation_code varchar2,
140 p_formula_id number,
141 p_input_currency_code varchar2,
142 p_output_currency_code varchar2,
143 p_classification_id number,
144 p_benefit_classification_id number,
145 p_additional_entry_allowed varchar2,
146 p_adjustment_only_flag varchar2,
147 p_closed_for_entry_flag varchar2,
148 p_element_name varchar2,
149 p_indirect_only_flag varchar2,
150 p_multiple_entries_allowed varchar2,
151 p_multiply_value_flag varchar2,
152 p_post_termination_rule varchar2,
153 p_process_in_run_flag varchar2,
154 p_processing_priority number,
155 p_processing_type varchar2,
156 p_standard_link_flag varchar2,
157 p_comment_id number,
158 p_description varchar2,
159 p_legislation_subgroup varchar2,
160 p_qualifying_age number,
161 p_qualifying_length_of_service number,
162 p_qualifying_units varchar2,
163 p_reporting_name varchar2,
164 p_attribute_category varchar2,
165 p_attribute1 varchar2,
166 p_attribute2 varchar2,
167 p_attribute3 varchar2,
168 p_attribute4 varchar2,
169 p_attribute5 varchar2,
170 p_attribute6 varchar2,
171 p_attribute7 varchar2,
172 p_attribute8 varchar2,
173 p_attribute9 varchar2,
174 p_attribute10 varchar2,
175 p_attribute11 varchar2,
176 p_attribute12 varchar2,
177 p_attribute13 varchar2,
178 p_attribute14 varchar2,
179 p_attribute15 varchar2,
180 p_attribute16 varchar2,
181 p_attribute17 varchar2,
182 p_attribute18 varchar2,
183 p_attribute19 varchar2,
184 p_attribute20 varchar2,
185 p_element_information_category varchar2,
186 p_element_information1 varchar2,
187 p_element_information2 varchar2,
188 p_element_information3 varchar2,
189 p_element_information4 varchar2,
190 p_element_information5 varchar2,
191 p_element_information6 varchar2,
192 p_element_information7 varchar2,
193 p_element_information8 varchar2,
194 p_element_information9 varchar2,
195 p_element_information10 varchar2,
196 p_element_information11 varchar2,
197 p_element_information12 varchar2,
198 p_element_information13 varchar2,
199 p_element_information14 varchar2,
200 p_element_information15 varchar2,
201 p_element_information16 varchar2,
202 p_element_information17 varchar2,
203 p_element_information18 varchar2,
204 p_element_information19 varchar2,
205 p_element_information20 varchar2,
206 p_third_party_pay_only_flag varchar2,
207 p_retro_summ_ele_id number default null,
208 p_iterative_flag varchar2 default null,
209 p_iterative_formula_id number default null,
210 p_iterative_priority number default null,
211 p_process_mode varchar2 default null,
212 p_grossup_flag varchar2 default null,
213 p_advance_indicator varchar2 default null,
214 p_advance_payable varchar2 default null,
215 p_advance_deduction varchar2 default null,
216 p_process_advance_entry varchar2 default null,
217 p_proration_group_id number default null,
218 p_base_element_name varchar2,
219 --Code added by prsundar for Continous calculation enhancement
220 p_proration_formula_id number default null,
221 p_recalc_event_group_id number default null,
222 p_once_each_period_flag varchar2 default null,
223 -- Added for FLSA Dynamic Period Allocation
224 p_time_definition_type varchar2 default null,
225 p_time_definition_id varchar2 default null,
226 -- Added for Advance Pay Enhancement
227 p_advance_element_type_id number default null,
228 p_deduction_element_type_id number default null
229 );
230 --------------------------------------------------------------------------------
231 procedure DELETE_ROW (
232 --
233 p_element_type_id number,
234 p_rowid varchar2,
235 p_processing_priority number,
236 p_delete_mode varchar2 default 'DELETE',
237 p_session_date date default trunc (sysdate),
238 p_validation_start_date date default to_date ('01/01/0001',
239 'DD/MM/YYYY'),
240 p_validation_end_date date default to_date ('31/12/4712',
241 'DD/MM/YYYY'));
242 --------------------------------------------------------------------------------
243 procedure LOCK_ROW(
244 --
245 p_rowid varchar2,
246 p_element_type_id number,
247 p_effective_start_date date,
248 p_effective_end_date date,
249 p_business_group_id number,
250 p_legislation_code varchar2,
251 p_formula_id number,
252 p_input_currency_code varchar2,
253 p_output_currency_code varchar2,
254 p_classification_id number,
255 p_benefit_classification_id number,
256 p_additional_entry_allowed varchar2,
257 p_adjustment_only_flag varchar2,
258 p_closed_for_entry_flag varchar2,
259 --p_element_name varchar2,
260 -- --
261 p_base_element_name varchar2,
262 -- --
263 p_indirect_only_flag varchar2,
264 p_multiple_entries_allowed varchar2,
265 p_multiply_value_flag varchar2,
266 p_post_termination_rule varchar2,
267 p_process_in_run_flag varchar2,
268 p_processing_priority number,
269 p_processing_type varchar2,
270 p_standard_link_flag varchar2,
271 p_comment_id number,
272 p_description varchar2,
273 p_legislation_subgroup varchar2,
274 p_qualifying_age number,
275 p_qualifying_length_of_service number,
276 p_qualifying_units varchar2,
277 p_reporting_name varchar2,
278 p_attribute_category varchar2,
279 p_attribute1 varchar2,
280 p_attribute2 varchar2,
281 p_attribute3 varchar2,
282 p_attribute4 varchar2,
283 p_attribute5 varchar2,
284 p_attribute6 varchar2,
285 p_attribute7 varchar2,
286 p_attribute8 varchar2,
287 p_attribute9 varchar2,
288 p_attribute10 varchar2,
289 p_attribute11 varchar2,
290 p_attribute12 varchar2,
291 p_attribute13 varchar2,
292 p_attribute14 varchar2,
293 p_attribute15 varchar2,
294 p_attribute16 varchar2,
295 p_attribute17 varchar2,
296 p_attribute18 varchar2,
297 p_attribute19 varchar2,
298 p_attribute20 varchar2,
299 p_element_information_category varchar2,
300 p_element_information1 varchar2,
301 p_element_information2 varchar2,
302 p_element_information3 varchar2,
303 p_element_information4 varchar2,
304 p_element_information5 varchar2,
305 p_element_information6 varchar2,
306 p_element_information7 varchar2,
307 p_element_information8 varchar2,
308 p_element_information9 varchar2,
309 p_element_information10 varchar2,
310 p_element_information11 varchar2,
311 p_element_information12 varchar2,
312 p_element_information13 varchar2,
313 p_element_information14 varchar2,
314 p_element_information15 varchar2,
315 p_element_information16 varchar2,
316 p_element_information17 varchar2,
317 p_element_information18 varchar2,
318 p_element_information19 varchar2,
319 p_element_information20 varchar2,
320 p_third_party_pay_only_flag varchar2,
321 p_retro_summ_ele_id number default null,
322 p_iterative_flag varchar2 default null,
323 p_iterative_formula_id number default null,
324 p_iterative_priority number default null,
325 p_process_mode varchar2 default null,
326 p_grossup_flag varchar2 default null,
327 p_advance_indicator varchar2 default null,
328 p_advance_payable varchar2 default null,
329 p_advance_deduction varchar2 default null,
330 p_process_advance_entry varchar2 default null,
331 p_proration_group_id number default null,
332 --Code added by prsundar for Continous calculation enhancement
333 p_proration_formula_id number default null,
334 p_recalc_event_group_id number default null,
335 p_once_each_period_flag varchar2 default null,
336 -- Added for FLSA Dynamic Period Allocation
337 p_time_definition_type varchar2 default null,
338 p_time_definition_id varchar2 default null,
339 -- Added for Advance Pay Enhancement
340 p_advance_element_type_id number default null,
341 p_deduction_element_type_id number default null
342 );
343 -----------------------------------------------------------------------
344 function DATE_EFFECTIVELY_UPDATED (
345 --
346 p_element_type_id number,
347 p_rowid varchar2,
348 p_error_if_true boolean default FALSE) return boolean;
349 -----------------------------------------------------------------------
350 function STOP_ENTRY_RULES_EXIST (
351 --
355 p_error_if_true boolean default FALSE) return boolean;
352 p_element_type_id number,
353 p_validation_start_date date default to_date ('01/01/0001','DD/MM/YYYY'),
354 p_validation_end_date date default to_date ('31/12/4712','DD/MM/YYYY'),
356 -----------------------------------------------------------------------
357 function RUN_RESULTS_EXIST (
358 --
359 p_element_type_id number,
360 p_validation_start_date date default to_date ('01/01/0001', 'DD/MM/YYYY'),
361 p_validation_end_date date default to_date ('31/12/4712', 'DD/MM/YYYY'),
362 p_DML_action_being_checked varchar2 default 'UPDATE',
363 p_error_if_true boolean default FALSE) return boolean;
364 -----------------------------------------------------------------------
365 function FED_BY_INDIRECT_RESULTS (
366 --
367 p_element_type_id number,
368 p_validation_start_date date default to_date ('01/01/0001','DD/MM/YYYY'),
369 p_validation_end_date date default to_date ('31/12/4712','DD/MM/YYYY'),
370 p_error_if_true boolean default FALSE) return boolean;
371 -----------------------------------------------------------------------
372 function UPDATE_RECURRING_RULES_EXIST (
373 --
374 p_element_type_id number,
375 p_validation_start_date date default to_date ('01/01/0001','DD/MM/YYYY'),
376 p_validation_end_date date default to_date ('31/12/4712','DD/MM/YYYY'),
377 p_error_if_true boolean default FALSE) return boolean;
378 -----------------------------------------------------------------------------
379 procedure CHECK_RELATIONSHIPS (
380 --
381 p_element_type_id number,
382 p_rowid varchar2,
383 p_validation_start_date date default to_date ('01/01/0001','DD/MM/YYYY'),
384 p_validation_end_date date default to_date ('31/12/4712','DD/MM/YYYY'),
385 p_run_results out nocopy boolean,
386 p_element_links out nocopy boolean,
387 p_indirect_results out nocopy boolean,
388 p_dated_updates out nocopy boolean,
389 p_update_recurring out nocopy boolean,
390 p_pay_basis out nocopy boolean,
391 p_stop_entry_rules out nocopy boolean);
392 -----------------------------------------------------------------------------
393 function ELEMENT_IS_IN_AN_ELEMENT_SET (
394 --
395 p_element_type_id number,
396 p_error_if_true boolean default FALSE) return boolean;
397 -----------------------------------------------------------------------------
398 function LINKS_EXIST (
399 --
400 p_element_type_id number,
401 p_validation_start_date date default to_date ('01/01/0001','DD/MM/YYYY'),
402 p_validation_end_date date default to_date ('31/12/4712','DD/MM/YYYY'),
403 p_DML_action_being_checked varchar2 default 'UPDATE',
404 p_error_if_true boolean default FALSE) return boolean ;
405 -----------------------------------------------------------------------------
406 function COBRA_BENEFITS_EXIST (
407 --
408 p_element_type_id number,
409 p_validation_start_date date default to_date ('01/01/0001','DD/MM/YYYY'),
410 p_validation_end_date date default to_date ('31/12/4712','DD/MM/YYYY'),
411 p_error_if_true boolean default FALSE) return boolean;
412 -----------------------------------------------------------------------------
413 function DELETION_ALLOWED (
414 --
415 p_element_type_id number,
416 p_processing_priority number,
417 p_validation_start_date date default to_date ('01/01/0001','DD/MM/YYYY'),
418 p_validation_end_date date default to_date ('31/12/4712','DD/MM/YYYY'),
419 p_delete_mode varchar2 default 'ZAP') return boolean;
420 -----------------------------------------------------------------------------
421 function PRIORITY_RESULT_RULE_VIOLATED (
422 --
423 p_element_type_id number,
424 p_processing_priority number,
425 p_validation_start_date date default to_date ('01/01/0001','DD/MM/YYYY'),
426 p_validation_end_date date default to_date ('31/12/4712','DD/MM/YYYY'),
427 p_error_if_true boolean default FALSE) return boolean;
428 -------------------------------------------------------------------------------
429 function NAME_IS_NOT_UNIQUE (
430 --
431 p_element_name varchar2,
432 p_element_type_id number default null,
433 p_business_group_id number default null,
434 p_legislation_code varchar2 default null,
435 p_error_if_true boolean default FALSE) return boolean;
436 -----------------------------------------------------------------------------
437 function ELEMENT_ENTRIES_EXIST (
438 --
439 p_element_type_id number,
440 p_error_if_true boolean default FALSE) return boolean;
441 -----------------------------------------------------------------------------
442 procedure ADD_LANGUAGE;
443 -----------------------------------------------------------------------------
444 procedure TRANSLATE_ROW (
445 X_E_ELEMENT_NAME in varchar2,
446 X_E_LEGISLATION_CODE in varchar2,
447 X_E_EFFECTIVE_START_DATE in date,
448 X_E_EFFECTIVE_END_DATE in date,
449 X_ELEMENT_NAME in varchar2,
450 X_REPORTING_NAME in varchar2,
451 X_DESCRIPTION in varchar2,
452 X_OWNER in varchar2
453 );
454 -----------------------------------------------------------------------------
455 end PAY_ELEMENT_TYPES_PKG;