1 Package pay_element_entry_api AUTHID CURRENT_USER as
2 /* $Header: pyeleapi.pkh 120.2.12010000.1 2008/07/27 22:30:34 appldev ship $ */
3 /*#
4 * This package contains element entry APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Element Entry
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< create_element_entry >-----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates element entries and element entry values.
17 *
18 * The number of element entry values created always equals the number of input
19 * values for the corresponding element type.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * The assignment and element link must exist and the assignment must be
26 * eligible for that link.
27 *
28 * <p><b>Post Success</b><br>
29 * The element entry and element entry values will be created.
30 *
31 * <p><b>Post Failure</b><br>
32 * The element entry and element entry values will not be created and an error
33 * will be raised.
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_effective_date Determines when the DateTrack operation comes into
38 * force.
39 * @param p_business_group_id Obsolete parameter, do not use.
40 * @param p_original_entry_id Obsolete parameter, do not use.
41 * @param p_assignment_id Identifies the assignment for which you create the
42 * Element Entry record.
43 * @param p_element_link_id Foreign key to PAY_ELEMENT_LINKS
44 * @param p_entry_type Entry type. Valid values are defined by the
45 * 'ENTRY_VALUE' lookup type.
46 * @param p_creator_type Describes the creator of the element entry. Valid
47 * values are defined by the 'CREATOR_TYPE' lookup type.
48 * @param p_cost_allocation_keyflex_id Identifier for the Cost Allocation
49 * Keyflex
50 * @param p_updating_action_id Reserved parameter, do not use.
51 * @param p_updating_action_type Reserved parameter, do not use.
52 * @param p_comment_id Identifier for the comment
53 * @param p_reason Reason attached to element entry. Values validated by user
54 * extensible 'REASON' lookup type.
55 * @param p_target_entry_id When creating and adjustment element entry, is the
56 * element_entry_id of the target of the adjustment.
57 * @param p_subpriority Sub priority value used in payroll processing of the
58 * element entry.
59 * @param p_date_earned Date earned.
60 * @param p_personal_payment_method_id Foreign key to
61 * PAY_PERSONAL_PAYMENT_METHODS
62 * @param p_attribute_category This context value determines which flexfield
63 * structure to use with the descriptive flexfield segments.
64 * @param p_attribute1 Descriptive flexfield segment.
65 * @param p_attribute2 Descriptive flexfield segment.
66 * @param p_attribute3 Descriptive flexfield segment.
67 * @param p_attribute4 Descriptive flexfield segment.
68 * @param p_attribute5 Descriptive flexfield segment.
69 * @param p_attribute6 Descriptive flexfield segment.
70 * @param p_attribute7 Descriptive flexfield segment.
71 * @param p_attribute8 Descriptive flexfield segment.
72 * @param p_attribute9 Descriptive flexfield segment.
73 * @param p_attribute10 Descriptive flexfield segment.
74 * @param p_attribute11 Descriptive flexfield segment.
75 * @param p_attribute12 Descriptive flexfield segment.
76 * @param p_attribute13 Descriptive flexfield segment.
77 * @param p_attribute14 Descriptive flexfield segment.
78 * @param p_attribute15 Descriptive flexfield segment.
79 * @param p_attribute16 Descriptive flexfield segment.
80 * @param p_attribute17 Descriptive flexfield segment.
81 * @param p_attribute18 Descriptive flexfield segment.
82 * @param p_attribute19 Descriptive flexfield segment.
83 * @param p_attribute20 Descriptive flexfield segment.
84 * @param p_input_value_id1 Indentifier for the Input Value
85 * @param p_input_value_id2 Indentifier for the Input Value
86 * @param p_input_value_id3 Indentifier for the Input Value
87 * @param p_input_value_id4 Indentifier for the Input Value
88 * @param p_input_value_id5 Indentifier for the Input Value
89 * @param p_input_value_id6 Indentifier for the Input Value
90 * @param p_input_value_id7 Indentifier for the Input Value
91 * @param p_input_value_id8 Indentifier for the Input Value
92 * @param p_input_value_id9 Indentifier for the Input Value
93 * @param p_input_value_id10 Indentifier for the Input Value
94 * @param p_input_value_id11 Indentifier for the Input Value
95 * @param p_input_value_id12 Indentifier for the Input Value
96 * @param p_input_value_id13 Indentifier for the Input Value
97 * @param p_input_value_id14 Indentifier for the Input Value
98 * @param p_input_value_id15 Indentifier for the Input Value
99 * @param p_entry_value1 Element entry value.
100 * @param p_entry_value2 Element entry value.
101 * @param p_entry_value3 Element entry value.
102 * @param p_entry_value4 Element entry value.
103 * @param p_entry_value5 Element entry value.
104 * @param p_entry_value6 Element entry value.
105 * @param p_entry_value7 Element entry value.
106 * @param p_entry_value8 Element entry value.
107 * @param p_entry_value9 Element entry value.
108 * @param p_entry_value10 Element entry value.
109 * @param p_entry_value11 Element entry value.
110 * @param p_entry_value12 Element entry value.
111 * @param p_entry_value13 Element entry value.
112 * @param p_entry_value14 Element entry value.
116 * @param p_entry_information2 Developer Descriptive flexfield segment.
113 * @param p_entry_value15 Element entry value.
114 * @param p_entry_information_category Obsolete parameter, do not use.
115 * @param p_entry_information1 Developer Descriptive flexfield segment.
117 * @param p_entry_information3 Developer Descriptive flexfield segment.
118 * @param p_entry_information4 Developer Descriptive flexfield segment.
119 * @param p_entry_information5 Developer Descriptive flexfield segment.
120 * @param p_entry_information6 Developer Descriptive flexfield segment.
121 * @param p_entry_information7 Developer Descriptive flexfield segment.
122 * @param p_entry_information8 Developer Descriptive flexfield segment.
123 * @param p_entry_information9 Developer Descriptive flexfield segment.
124 * @param p_entry_information10 Developer Descriptive flexfield segment.
125 * @param p_entry_information11 Developer Descriptive flexfield segment.
126 * @param p_entry_information12 Developer Descriptive flexfield segment.
127 * @param p_entry_information13 Developer Descriptive flexfield segment.
128 * @param p_entry_information14 Developer Descriptive flexfield segment.
129 * @param p_entry_information15 Developer Descriptive flexfield segment.
130 * @param p_entry_information16 Developer Descriptive flexfield segment.
131 * @param p_entry_information17 Developer Descriptive flexfield segment.
132 * @param p_entry_information18 Developer Descriptive flexfield segment.
133 * @param p_entry_information19 Developer Descriptive flexfield segment.
134 * @param p_entry_information20 Developer Descriptive flexfield segment.
135 * @param p_entry_information21 Developer Descriptive flexfield segment.
136 * @param p_entry_information22 Developer Descriptive flexfield segment.
137 * @param p_entry_information23 Developer Descriptive flexfield segment.
138 * @param p_entry_information24 Developer Descriptive flexfield segment.
139 * @param p_entry_information25 Developer Descriptive flexfield segment.
140 * @param p_entry_information26 Developer Descriptive flexfield segment.
141 * @param p_entry_information27 Developer Descriptive flexfield segment.
142 * @param p_entry_information28 Developer Descriptive flexfield segment.
143 * @param p_entry_information29 Developer Descriptive flexfield segment.
144 * @param p_entry_information30 Developer Descriptive flexfield segment.
145 * @param p_override_user_ent_chk Controls whether the user enterable status of
146 * an entry value should be checked on creation or update of an element entry
147 * value.Valid values are defined by 'YES_NO' lookup type.
148 * @param p_effective_start_date If p_validate is false, then set to the
149 * earliest effective start date for the created element entry. If p_validate
150 * is true, then set to null.
151 * @param p_effective_end_date If p_validate is false, then set to the
152 * effective end date for the created element entry. If p_validate is true,
153 * then set to null.
154 * @param p_element_entry_id If p_validate is false, then this uniquely
155 * identifies the created element entry. If p_validate is true, then set to
156 * null.
157 * @param p_object_version_number If p_validate is false, then set to the
158 * version number of the created element entry. If p_validate is true, then the
159 * value will be null.
160 * @param p_create_warning If set to true, the value set for an element entry
161 * value is outside the allowable range as specified on the input value and the
162 * warning flag is set.
163 * @rep:displayname Create Element Entry
164 * @rep:category BUSINESS_ENTITY PAY_ELEMENT_ENTRY
165 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
166 * @rep:scope public
167 * @rep:lifecycle active
168 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
169 */
170 --
171 -- {End Of Comments}
172 --
173 procedure create_element_entry
174 (p_validate in boolean default false
175 ,p_effective_date in date
176 ,p_business_group_id in number
177 ,p_original_entry_id in number default null
178 ,p_assignment_id in number
179 ,p_element_link_id in number
180 ,p_entry_type in varchar2
181 ,p_creator_type in varchar2 default 'F'
182 ,p_cost_allocation_keyflex_id in number default null
183 ,p_updating_action_id in number default null
184 ,p_updating_action_type in varchar2 default null
185 ,p_comment_id in number default null
186 ,p_reason in varchar2 default null
187 ,p_target_entry_id in number default null
188 ,p_subpriority in number default null
189 ,p_date_earned in date default null
190 ,p_personal_payment_method_id in number default null
191 ,p_attribute_category in varchar2 default null
192 ,p_attribute1 in varchar2 default null
193 ,p_attribute2 in varchar2 default null
194 ,p_attribute3 in varchar2 default null
195 ,p_attribute4 in varchar2 default null
196 ,p_attribute5 in varchar2 default null
197 ,p_attribute6 in varchar2 default null
198 ,p_attribute7 in varchar2 default null
199 ,p_attribute8 in varchar2 default null
200 ,p_attribute9 in varchar2 default null
201 ,p_attribute10 in varchar2 default null
202 ,p_attribute11 in varchar2 default null
203 ,p_attribute12 in varchar2 default null
204 ,p_attribute13 in varchar2 default null
205 ,p_attribute14 in varchar2 default null
206 ,p_attribute15 in varchar2 default null
207 ,p_attribute16 in varchar2 default null
211 ,p_attribute20 in varchar2 default null
208 ,p_attribute17 in varchar2 default null
209 ,p_attribute18 in varchar2 default null
210 ,p_attribute19 in varchar2 default null
212 ,p_input_value_id1 in number default null
213 ,p_input_value_id2 in number default null
214 ,p_input_value_id3 in number default null
215 ,p_input_value_id4 in number default null
216 ,p_input_value_id5 in number default null
217 ,p_input_value_id6 in number default null
218 ,p_input_value_id7 in number default null
219 ,p_input_value_id8 in number default null
220 ,p_input_value_id9 in number default null
221 ,p_input_value_id10 in number default null
222 ,p_input_value_id11 in number default null
223 ,p_input_value_id12 in number default null
224 ,p_input_value_id13 in number default null
225 ,p_input_value_id14 in number default null
226 ,p_input_value_id15 in number default null
227 ,p_entry_value1 in varchar2 default null
228 ,p_entry_value2 in varchar2 default null
229 ,p_entry_value3 in varchar2 default null
230 ,p_entry_value4 in varchar2 default null
231 ,p_entry_value5 in varchar2 default null
232 ,p_entry_value6 in varchar2 default null
233 ,p_entry_value7 in varchar2 default null
234 ,p_entry_value8 in varchar2 default null
235 ,p_entry_value9 in varchar2 default null
236 ,p_entry_value10 in varchar2 default null
237 ,p_entry_value11 in varchar2 default null
238 ,p_entry_value12 in varchar2 default null
239 ,p_entry_value13 in varchar2 default null
240 ,p_entry_value14 in varchar2 default null
241 ,p_entry_value15 in varchar2 default null
242 ,p_entry_information_category in varchar2 default null
243 ,p_entry_information1 in varchar2 default null
244 ,p_entry_information2 in varchar2 default null
245 ,p_entry_information3 in varchar2 default null
246 ,p_entry_information4 in varchar2 default null
247 ,p_entry_information5 in varchar2 default null
248 ,p_entry_information6 in varchar2 default null
249 ,p_entry_information7 in varchar2 default null
250 ,p_entry_information8 in varchar2 default null
251 ,p_entry_information9 in varchar2 default null
252 ,p_entry_information10 in varchar2 default null
253 ,p_entry_information11 in varchar2 default null
254 ,p_entry_information12 in varchar2 default null
255 ,p_entry_information13 in varchar2 default null
256 ,p_entry_information14 in varchar2 default null
257 ,p_entry_information15 in varchar2 default null
258 ,p_entry_information16 in varchar2 default null
259 ,p_entry_information17 in varchar2 default null
260 ,p_entry_information18 in varchar2 default null
261 ,p_entry_information19 in varchar2 default null
262 ,p_entry_information20 in varchar2 default null
263 ,p_entry_information21 in varchar2 default null
264 ,p_entry_information22 in varchar2 default null
265 ,p_entry_information23 in varchar2 default null
266 ,p_entry_information24 in varchar2 default null
267 ,p_entry_information25 in varchar2 default null
268 ,p_entry_information26 in varchar2 default null
269 ,p_entry_information27 in varchar2 default null
270 ,p_entry_information28 in varchar2 default null
271 ,p_entry_information29 in varchar2 default null
272 ,p_entry_information30 in varchar2 default null
273 ,p_override_user_ent_chk in varchar2 default 'N'
274 ,p_effective_start_date out nocopy date
275 ,p_effective_end_date out nocopy date
276 ,p_element_entry_id out nocopy number
277 ,p_object_version_number out nocopy number
278 ,p_create_warning out nocopy boolean
279 );
280 --
281 -- ----------------------------------------------------------------------------
282 -- |---------------------------< delete_element_entry >-----------------------|
283 -- ----------------------------------------------------------------------------
284 --
285 -- {Start Of Comments}
286 /*#
287 * This API deletes an existing element entry and element entry values.
288 *
289 * The role of this process is to perform a validated delete of an existing row
290 * in the pay_element_entries_f table of the HR schema
291 *
292 * <p><b>Licensing</b><br>
293 * This API is licensed for use with Human Resources.
294 *
295 * <p><b>Prerequisites</b><br>
296 * The element entry must exist at the deletion date.
297 *
298 * <p><b>Post Success</b><br>
299 * The element entry and the element entry values will have been deleted.
300 *
301 * <p><b>Post Failure</b><br>
302 * The element entry and element entry values will not have been deleted and an
303 * error will be raised.
304 * @param p_validate If true, then validation alone will be performed and the
305 * database will remain unchanged. If false and all validation checks pass,
306 * then the database will be modified.
307 * @param p_datetrack_delete_mode Indicates which DateTrack mode to use when
311 * change.
308 * deleting the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
309 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
310 * on the dates of previous record changes and the effective date of this
312 * @param p_effective_date Determines when the DateTrack operation comes into
313 * force.
314 * @param p_element_entry_id The element entry to delete.
315 * @param p_object_version_number Pass in the current version number of the
316 * element entry to be deleted. When the API completes if p_validate is false,
317 * will be set to the new version number of the deleted element entry. If
318 * p_validate is true will be set to the same value which was passed in.
319 * @param p_effective_start_date If p_validate is false, then set to the
320 * effective start date for the deleted element entry row which now exists as
321 * of the effective date. If p_validate is true or all row instances have been
322 * deleted then set to null.
323 * @param p_effective_end_date If p_validate is false, then set to the
324 * effective end date for the deleted element entry row which now exists as of
325 * the effective date. If p_validate is true or all row instances have been
326 * deleted then set to null.
327 * @param p_delete_warning Always set to null.
328 * @rep:displayname Delete Element Entry
329 * @rep:category BUSINESS_ENTITY PAY_ELEMENT_ENTRY
330 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
331 * @rep:scope public
332 * @rep:lifecycle active
333 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
334 */
335 --
336 -- {End Of Comments}
337 --
338 procedure delete_element_entry
339 (p_validate in boolean default false
340 ,p_datetrack_delete_mode in varchar2
341 ,p_effective_date in date
342 ,p_element_entry_id in number
343 ,p_object_version_number in out nocopy number
344 ,p_effective_start_date out nocopy date
345 ,p_effective_end_date out nocopy date
346 ,p_delete_warning out nocopy boolean
347 );
348 --
349 -- ----------------------------------------------------------------------------
350 -- |---------------------------< update_element_entry >-----------------------|
351 -- ----------------------------------------------------------------------------
352 --
353 -- {Start Of Comments}
354 /*#
355 * This API will update an existing element entry and element entry values.
356 *
357 * This API updates the element description or any of its input values for the
358 * given element.
359 *
360 * <p><b>Licensing</b><br>
361 * This API is licensed for use with Human Resources.
362 *
363 * <p><b>Prerequisites</b><br>
364 * The element entry to update must exist at the update date.
365 *
366 * <p><b>Post Success</b><br>
367 * The element entry and the element entry values will have been updated.
368 *
369 * <p><b>Post Failure</b><br>
370 * The element entry and the element entry values will not have been updated
371 * and an error will be raised.
372 * @param p_validate If true, then validation alone will be performed and the
373 * database will remain unchanged. If false and all validation checks pass,
374 * then the database will be modified.
375 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
376 * updating the record. You must set to either UPDATE, CORRECTION,
377 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
378 * particular record depend on the dates of previous record changes and the
379 * effective date of this change.
380 * @param p_effective_date Determines when the DateTrack operation comes into
381 * force.
382 * @param p_business_group_id Obsolete parameter, do not use.
383 * @param p_element_entry_id Identifies the element entry to update.
384 * @param p_object_version_number Pass in the current version number of the
385 * element to be updated. When the API completes if p_validate is false, will
386 * be set to the new version number of the updated element entry. If p_validate
387 * is true will be set to the same value which was passed in
388 * @param p_cost_allocation_keyflex_id Identifier for the Cost Allocation
389 * Keyflex
390 * @param p_updating_action_id Reserved parameter, do not use.
391 * @param p_updating_action_type Reserved parameter, do not use.
392 * @param p_original_entry_id Reserved parameter, do not use.
393 * @param p_creator_type Describes the creator of the element entry. Valid
394 * values are defined by the 'CREATOR_TYPE' lookup type.
395 * @param p_comment_id Identifier for the comment
396 * @param p_creator_id Appropriate identifier associated with the creator type.
397 * @param p_reason Reason attached to element entry. Values validated by user
398 * extensible 'REASON' lookup type.
399 * @param p_subpriority Sub priority value used in payroll processing of the
400 * element entry.
401 * @param p_date_earned Date earned.
402 * @param p_personal_payment_method_id Foreign key to
403 * PAY_PERSONAL_PAYMENT_METHODS
404 * @param p_attribute_category This context value determines which flexfield
405 * structure to use with the descriptive flexfield segments.
406 * @param p_attribute1 Descriptive flexfield segment.
407 * @param p_attribute2 Descriptive flexfield segment.
408 * @param p_attribute3 Descriptive flexfield segment.
409 * @param p_attribute4 Descriptive flexfield segment.
410 * @param p_attribute5 Descriptive flexfield segment.
411 * @param p_attribute6 Descriptive flexfield segment.
412 * @param p_attribute7 Descriptive flexfield segment.
413 * @param p_attribute8 Descriptive flexfield segment.
414 * @param p_attribute9 Descriptive flexfield segment.
415 * @param p_attribute10 Descriptive flexfield segment.
416 * @param p_attribute11 Descriptive flexfield segment.
420 * @param p_attribute15 Descriptive flexfield segment.
417 * @param p_attribute12 Descriptive flexfield segment.
418 * @param p_attribute13 Descriptive flexfield segment.
419 * @param p_attribute14 Descriptive flexfield segment.
421 * @param p_attribute16 Descriptive flexfield segment.
422 * @param p_attribute17 Descriptive flexfield segment.
423 * @param p_attribute18 Descriptive flexfield segment.
424 * @param p_attribute19 Descriptive flexfield segment.
425 * @param p_attribute20 Descriptive flexfield segment.
426 * @param p_input_value_id1 Indentifier for the Input Value
427 * @param p_input_value_id2 Indentifier for the Input Value
428 * @param p_input_value_id3 Indentifier for the Input Value
429 * @param p_input_value_id4 Indentifier for the Input Value
430 * @param p_input_value_id5 Indentifier for the Input Value
431 * @param p_input_value_id6 Indentifier for the Input Value
432 * @param p_input_value_id7 Indentifier for the Input Value
433 * @param p_input_value_id8 Indentifier for the Input Value
434 * @param p_input_value_id9 Indentifier for the Input Value
435 * @param p_input_value_id10 Indentifier for the Input Value
436 * @param p_input_value_id11 Indentifier for the Input Value
437 * @param p_input_value_id12 Indentifier for the Input Value
438 * @param p_input_value_id13 Indentifier for the Input Value
439 * @param p_input_value_id14 Indentifier for the Input Value
440 * @param p_input_value_id15 Indentifier for the Input Value
441 * @param p_entry_value1 Element entry value.
442 * @param p_entry_value2 Element entry value.
443 * @param p_entry_value3 Element entry value.
444 * @param p_entry_value4 Element entry value.
445 * @param p_entry_value5 Element entry value.
446 * @param p_entry_value6 Element entry value.
447 * @param p_entry_value7 Element entry value.
448 * @param p_entry_value8 Element entry value.
449 * @param p_entry_value9 Element entry value.
450 * @param p_entry_value10 Element entry value.
451 * @param p_entry_value11 Element entry value.
452 * @param p_entry_value12 Element entry value.
453 * @param p_entry_value13 Element entry value.
454 * @param p_entry_value14 Element entry value.
455 * @param p_entry_value15 Element entry value.
456 * @param p_entry_information_category Obsolete parameter, do not use.
457 * @param p_entry_information1 Developer Descriptive flexfield segment.
458 * @param p_entry_information2 Developer Descriptive flexfield segment.
459 * @param p_entry_information3 Developer Descriptive flexfield segment.
460 * @param p_entry_information4 Developer Descriptive flexfield segment.
461 * @param p_entry_information5 Developer Descriptive flexfield segment.
462 * @param p_entry_information6 Developer Descriptive flexfield segment.
463 * @param p_entry_information7 Developer Descriptive flexfield segment.
464 * @param p_entry_information8 Developer Descriptive flexfield segment.
465 * @param p_entry_information9 Developer Descriptive flexfield segment.
466 * @param p_entry_information10 Developer Descriptive flexfield segment.
467 * @param p_entry_information11 Developer Descriptive flexfield segment.
468 * @param p_entry_information12 Developer Descriptive flexfield segment.
469 * @param p_entry_information13 Developer Descriptive flexfield segment.
470 * @param p_entry_information14 Developer Descriptive flexfield segment.
471 * @param p_entry_information15 Developer Descriptive flexfield segment.
472 * @param p_entry_information16 Developer Descriptive flexfield segment.
473 * @param p_entry_information17 Developer Descriptive flexfield segment.
474 * @param p_entry_information18 Developer Descriptive flexfield segment.
475 * @param p_entry_information19 Developer Descriptive flexfield segment.
476 * @param p_entry_information20 Developer Descriptive flexfield segment.
477 * @param p_entry_information21 Developer Descriptive flexfield segment.
478 * @param p_entry_information22 Developer Descriptive flexfield segment.
479 * @param p_entry_information23 Developer Descriptive flexfield segment.
480 * @param p_entry_information24 Developer Descriptive flexfield segment.
481 * @param p_entry_information25 Developer Descriptive flexfield segment.
482 * @param p_entry_information26 Developer Descriptive flexfield segment.
483 * @param p_entry_information27 Developer Descriptive flexfield segment.
484 * @param p_entry_information28 Developer Descriptive flexfield segment.
485 * @param p_entry_information29 Developer Descriptive flexfield segment.
486 * @param p_entry_information30 Developer Descriptive flexfield segment.
487 * @param p_override_user_ent_chk Controls whether the user enterable status of
488 * an entry value should be checked on creation or update of an element entry
489 * value.Valid values are defined by 'YES_NO' lookup type.
490 * @param p_effective_start_date If p_validate is false, then set to the
491 * effective start date on the updated element entry row which now exists as of
492 * the effective date. If p_validate is true, then set to null.
493 * @param p_effective_end_date If p_validate is false, then set to the
494 * effective end date on the updated element entry row which now exists as of
495 * the effective date. If p_validate is true, then set to null.
496 * @param p_update_warning If set to true, the value set for an element entry
497 * value is outside the allowable range as specified on the input value and the
498 * warning flag is set.
499 * @rep:displayname Update Element Entry
500 * @rep:category BUSINESS_ENTITY PAY_ELEMENT_ENTRY
501 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
502 * @rep:scope public
503 * @rep:lifecycle active
504 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
505 */
506 --
507 -- {End Of Comments}
508 --
509 procedure update_element_entry
510 (p_validate in boolean default false
511 ,p_datetrack_update_mode in varchar2
512 ,p_effective_date in date
513 ,p_business_group_id in number
517 ,p_updating_action_id in number default hr_api.g_number
514 ,p_element_entry_id in number
515 ,p_object_version_number in out nocopy number
516 ,p_cost_allocation_keyflex_id in number default hr_api.g_number
518 ,p_updating_action_type in varchar2 default hr_api.g_varchar2
519 ,p_original_entry_id in number default hr_api.g_number
520 ,p_creator_type in varchar2 default hr_api.g_varchar2
521 ,p_comment_id in number default hr_api.g_number
522 ,p_creator_id in number default hr_api.g_number
523 ,p_reason in varchar2 default hr_api.g_varchar2
524 ,p_subpriority in number default hr_api.g_number
525 ,p_date_earned in date default hr_api.g_date
526 ,p_personal_payment_method_id in number default hr_api.g_number
527 ,p_attribute_category in varchar2 default hr_api.g_varchar2
528 ,p_attribute1 in varchar2 default hr_api.g_varchar2
529 ,p_attribute2 in varchar2 default hr_api.g_varchar2
530 ,p_attribute3 in varchar2 default hr_api.g_varchar2
531 ,p_attribute4 in varchar2 default hr_api.g_varchar2
532 ,p_attribute5 in varchar2 default hr_api.g_varchar2
533 ,p_attribute6 in varchar2 default hr_api.g_varchar2
534 ,p_attribute7 in varchar2 default hr_api.g_varchar2
535 ,p_attribute8 in varchar2 default hr_api.g_varchar2
536 ,p_attribute9 in varchar2 default hr_api.g_varchar2
537 ,p_attribute10 in varchar2 default hr_api.g_varchar2
538 ,p_attribute11 in varchar2 default hr_api.g_varchar2
539 ,p_attribute12 in varchar2 default hr_api.g_varchar2
540 ,p_attribute13 in varchar2 default hr_api.g_varchar2
541 ,p_attribute14 in varchar2 default hr_api.g_varchar2
542 ,p_attribute15 in varchar2 default hr_api.g_varchar2
543 ,p_attribute16 in varchar2 default hr_api.g_varchar2
544 ,p_attribute17 in varchar2 default hr_api.g_varchar2
545 ,p_attribute18 in varchar2 default hr_api.g_varchar2
546 ,p_attribute19 in varchar2 default hr_api.g_varchar2
547 ,p_attribute20 in varchar2 default hr_api.g_varchar2
548 ,p_input_value_id1 in number default null
549 ,p_input_value_id2 in number default null
550 ,p_input_value_id3 in number default null
551 ,p_input_value_id4 in number default null
552 ,p_input_value_id5 in number default null
553 ,p_input_value_id6 in number default null
554 ,p_input_value_id7 in number default null
555 ,p_input_value_id8 in number default null
556 ,p_input_value_id9 in number default null
557 ,p_input_value_id10 in number default null
558 ,p_input_value_id11 in number default null
559 ,p_input_value_id12 in number default null
560 ,p_input_value_id13 in number default null
561 ,p_input_value_id14 in number default null
562 ,p_input_value_id15 in number default null
563 ,p_entry_value1 in varchar2 default null
564 ,p_entry_value2 in varchar2 default null
565 ,p_entry_value3 in varchar2 default null
566 ,p_entry_value4 in varchar2 default null
567 ,p_entry_value5 in varchar2 default null
568 ,p_entry_value6 in varchar2 default null
569 ,p_entry_value7 in varchar2 default null
570 ,p_entry_value8 in varchar2 default null
571 ,p_entry_value9 in varchar2 default null
572 ,p_entry_value10 in varchar2 default null
573 ,p_entry_value11 in varchar2 default null
574 ,p_entry_value12 in varchar2 default null
575 ,p_entry_value13 in varchar2 default null
576 ,p_entry_value14 in varchar2 default null
577 ,p_entry_value15 in varchar2 default null
578 ,p_entry_information_category in varchar2 default hr_api.g_varchar2
579 ,p_entry_information1 in varchar2 default hr_api.g_varchar2
580 ,p_entry_information2 in varchar2 default hr_api.g_varchar2
581 ,p_entry_information3 in varchar2 default hr_api.g_varchar2
582 ,p_entry_information4 in varchar2 default hr_api.g_varchar2
583 ,p_entry_information5 in varchar2 default hr_api.g_varchar2
584 ,p_entry_information6 in varchar2 default hr_api.g_varchar2
585 ,p_entry_information7 in varchar2 default hr_api.g_varchar2
586 ,p_entry_information8 in varchar2 default hr_api.g_varchar2
587 ,p_entry_information9 in varchar2 default hr_api.g_varchar2
588 ,p_entry_information10 in varchar2 default hr_api.g_varchar2
589 ,p_entry_information11 in varchar2 default hr_api.g_varchar2
590 ,p_entry_information12 in varchar2 default hr_api.g_varchar2
591 ,p_entry_information13 in varchar2 default hr_api.g_varchar2
592 ,p_entry_information14 in varchar2 default hr_api.g_varchar2
593 ,p_entry_information15 in varchar2 default hr_api.g_varchar2
594 ,p_entry_information16 in varchar2 default hr_api.g_varchar2
595 ,p_entry_information17 in varchar2 default hr_api.g_varchar2
596 ,p_entry_information18 in varchar2 default hr_api.g_varchar2
597 ,p_entry_information19 in varchar2 default hr_api.g_varchar2
598 ,p_entry_information20 in varchar2 default hr_api.g_varchar2
599 ,p_entry_information21 in varchar2 default hr_api.g_varchar2
600 ,p_entry_information22 in varchar2 default hr_api.g_varchar2
601 ,p_entry_information23 in varchar2 default hr_api.g_varchar2
602 ,p_entry_information24 in varchar2 default hr_api.g_varchar2
603 ,p_entry_information25 in varchar2 default hr_api.g_varchar2
604 ,p_entry_information26 in varchar2 default hr_api.g_varchar2
605 ,p_entry_information27 in varchar2 default hr_api.g_varchar2
606 ,p_entry_information28 in varchar2 default hr_api.g_varchar2
607 ,p_entry_information29 in varchar2 default hr_api.g_varchar2
608 ,p_entry_information30 in varchar2 default hr_api.g_varchar2
609 ,p_override_user_ent_chk in varchar2 default 'N'
610 ,p_effective_start_date out nocopy date
611 ,p_effective_end_date out nocopy date
612 ,p_update_warning out nocopy boolean
613 );
614 --
615 end pay_element_entry_api;
[Home] [Help]