[Home] [Help]
PACKAGE BODY: APPS.PY_ELEMENT_ENTRY_API
Source
1 PACKAGE BODY py_element_entry_api AS
2 /* $Header: pyeleapi.pkb 120.13 2010/11/11 14:41:59 asnell ship $ */
3 --
4 -- Package Variables
5 --
6 -- ----------------------------------------------------------------------------
7 -- |-------------------------< create_element_entry >-------------------------|
8 -- ----------------------------------------------------------------------------
9 --
10 PROCEDURE create_element_entry
11 (p_validate in boolean default false
12 ,p_effective_date in date
13 ,p_business_group_id in number
14 ,p_original_entry_id in number default null
15 ,p_assignment_id in number
16 ,p_element_link_id in number
17 ,p_entry_type in varchar2
18 ,p_creator_type in varchar2 default 'F'
19 ,p_cost_allocation_keyflex_id in number default null
20 ,p_updating_action_id in number default null
24 ,p_target_entry_id in number default null
21 ,p_updating_action_type in varchar2 default null
22 ,p_comment_id in number default null
23 ,p_reason in varchar2 default null
25 ,p_subpriority in number default null
26 ,p_date_earned in date default null
27 ,p_personal_payment_method_id in number default null
28 ,p_attribute_category in varchar2 default null
29 ,p_attribute1 in varchar2 default null
30 ,p_attribute2 in varchar2 default null
31 ,p_attribute3 in varchar2 default null
32 ,p_attribute4 in varchar2 default null
33 ,p_attribute5 in varchar2 default null
34 ,p_attribute6 in varchar2 default null
35 ,p_attribute7 in varchar2 default null
36 ,p_attribute8 in varchar2 default null
37 ,p_attribute9 in varchar2 default null
38 ,p_attribute10 in varchar2 default null
39 ,p_attribute11 in varchar2 default null
40 ,p_attribute12 in varchar2 default null
41 ,p_attribute13 in varchar2 default null
42 ,p_attribute14 in varchar2 default null
43 ,p_attribute15 in varchar2 default null
44 ,p_attribute16 in varchar2 default null
45 ,p_attribute17 in varchar2 default null
46 ,p_attribute18 in varchar2 default null
47 ,p_attribute19 in varchar2 default null
48 ,p_attribute20 in varchar2 default null
49 ,p_input_value_id1 in number default null
50 ,p_input_value_id2 in number default null
51 ,p_input_value_id3 in number default null
52 ,p_input_value_id4 in number default null
53 ,p_input_value_id5 in number default null
54 ,p_input_value_id6 in number default null
55 ,p_input_value_id7 in number default null
56 ,p_input_value_id8 in number default null
57 ,p_input_value_id9 in number default null
58 ,p_input_value_id10 in number default null
59 ,p_input_value_id11 in number default null
60 ,p_input_value_id12 in number default null
61 ,p_input_value_id13 in number default null
62 ,p_input_value_id14 in number default null
63 ,p_input_value_id15 in number default null
64 ,p_entry_value1 in varchar2 default null
65 ,p_entry_value2 in varchar2 default null
66 ,p_entry_value3 in varchar2 default null
67 ,p_entry_value4 in varchar2 default null
68 ,p_entry_value5 in varchar2 default null
69 ,p_entry_value6 in varchar2 default null
70 ,p_entry_value7 in varchar2 default null
71 ,p_entry_value8 in varchar2 default null
72 ,p_entry_value9 in varchar2 default null
73 ,p_entry_value10 in varchar2 default null
74 ,p_entry_value11 in varchar2 default null
75 ,p_entry_value12 in varchar2 default null
76 ,p_entry_value13 in varchar2 default null
77 ,p_entry_value14 in varchar2 default null
78 ,p_entry_value15 in varchar2 default null
79 ,p_entry_information_category in varchar2 default null
80 ,p_entry_information1 in varchar2 default null
81 ,p_entry_information2 in varchar2 default null
82 ,p_entry_information3 in varchar2 default null
83 ,p_entry_information4 in varchar2 default null
84 ,p_entry_information5 in varchar2 default null
85 ,p_entry_information6 in varchar2 default null
86 ,p_entry_information7 in varchar2 default null
87 ,p_entry_information8 in varchar2 default null
88 ,p_entry_information9 in varchar2 default null
89 ,p_entry_information10 in varchar2 default null
90 ,p_entry_information11 in varchar2 default null
91 ,p_entry_information12 in varchar2 default null
92 ,p_entry_information13 in varchar2 default null
93 ,p_entry_information14 in varchar2 default null
94 ,p_entry_information15 in varchar2 default null
95 ,p_entry_information16 in varchar2 default null
96 ,p_entry_information17 in varchar2 default null
97 ,p_entry_information18 in varchar2 default null
98 ,p_entry_information19 in varchar2 default null
99 ,p_entry_information20 in varchar2 default null
100 ,p_entry_information21 in varchar2 default null
101 ,p_entry_information22 in varchar2 default null
102 ,p_entry_information23 in varchar2 default null
103 ,p_entry_information24 in varchar2 default null
104 ,p_entry_information25 in varchar2 default null
105 ,p_entry_information26 in varchar2 default null
106 ,p_entry_information27 in varchar2 default null
107 ,p_entry_information28 in varchar2 default null
108 ,p_entry_information29 in varchar2 default null
109 ,p_entry_information30 in varchar2 default null
110 ,p_override_user_ent_chk in varchar2 default 'N'
111 ,p_effective_start_date out nocopy date
112 ,p_effective_end_date out nocopy date
116 ) IS
113 ,p_element_entry_id out nocopy number
114 ,p_object_version_number out nocopy number
115 ,p_create_warning out nocopy boolean
117 --
118 BEGIN
119 --
120 pay_element_entry_api.create_element_entry
121 (p_validate => p_validate
122 ,p_effective_date => p_effective_date
123 ,p_business_group_id => p_business_group_id
124 ,p_original_entry_id => p_original_entry_id
125 ,p_assignment_id => p_assignment_id
126 ,p_element_link_id => p_element_link_id
127 ,p_entry_type => p_entry_type
128 ,p_creator_type => p_creator_type
129 ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
130 ,p_updating_action_id => p_updating_action_id
131 ,p_updating_action_type => p_updating_action_type
132 ,p_comment_id => p_comment_id
133 ,p_reason => p_reason
134 ,p_target_entry_id => p_target_entry_id
135 ,p_subpriority => p_subpriority
136 ,p_date_earned => p_date_earned
137 ,p_personal_payment_method_id => p_personal_payment_method_id
138 ,p_attribute_category => p_attribute_category
139 ,p_attribute1 => p_attribute1
140 ,p_attribute2 => p_attribute2
141 ,p_attribute3 => p_attribute3
142 ,p_attribute4 => p_attribute4
143 ,p_attribute5 => p_attribute5
144 ,p_attribute6 => p_attribute6
145 ,p_attribute7 => p_attribute7
146 ,p_attribute8 => p_attribute8
147 ,p_attribute9 => p_attribute9
148 ,p_attribute10 => p_attribute10
149 ,p_attribute11 => p_attribute11
150 ,p_attribute12 => p_attribute12
151 ,p_attribute13 => p_attribute13
152 ,p_attribute14 => p_attribute14
153 ,p_attribute15 => p_attribute15
154 ,p_attribute16 => p_attribute16
155 ,p_attribute17 => p_attribute17
156 ,p_attribute18 => p_attribute18
157 ,p_attribute19 => p_attribute19
158 ,p_attribute20 => p_attribute20
159 ,p_input_value_id1 => p_input_value_id1
160 ,p_input_value_id2 => p_input_value_id2
161 ,p_input_value_id3 => p_input_value_id3
162 ,p_input_value_id4 => p_input_value_id4
163 ,p_input_value_id5 => p_input_value_id5
164 ,p_input_value_id6 => p_input_value_id6
165 ,p_input_value_id7 => p_input_value_id7
166 ,p_input_value_id8 => p_input_value_id8
167 ,p_input_value_id9 => p_input_value_id9
168 ,p_input_value_id10 => p_input_value_id10
169 ,p_input_value_id11 => p_input_value_id11
170 ,p_input_value_id12 => p_input_value_id12
171 ,p_input_value_id13 => p_input_value_id13
172 ,p_input_value_id14 => p_input_value_id14
173 ,p_input_value_id15 => p_input_value_id15
174 ,p_entry_value1 => p_entry_value1
175 ,p_entry_value2 => p_entry_value2
176 ,p_entry_value3 => p_entry_value3
177 ,p_entry_value4 => p_entry_value4
178 ,p_entry_value5 => p_entry_value5
179 ,p_entry_value6 => p_entry_value6
180 ,p_entry_value7 => p_entry_value7
181 ,p_entry_value8 => p_entry_value8
182 ,p_entry_value9 => p_entry_value9
183 ,p_entry_value10 => p_entry_value10
184 ,p_entry_value11 => p_entry_value11
185 ,p_entry_value12 => p_entry_value12
186 ,p_entry_value13 => p_entry_value13
187 ,p_entry_value14 => p_entry_value14
188 ,p_entry_value15 => p_entry_value15
189 ,p_entry_information_category => p_entry_information_category
190 ,p_entry_information1 => p_entry_information1
191 ,p_entry_information2 => p_entry_information2
192 ,p_entry_information3 => p_entry_information3
193 ,p_entry_information4 => p_entry_information4
194 ,p_entry_information5 => p_entry_information5
195 ,p_entry_information6 => p_entry_information6
196 ,p_entry_information7 => p_entry_information7
197 ,p_entry_information8 => p_entry_information8
198 ,p_entry_information9 => p_entry_information9
199 ,p_entry_information10 => p_entry_information10
200 ,p_entry_information11 => p_entry_information11
201 ,p_entry_information12 => p_entry_information12
202 ,p_entry_information13 => p_entry_information13
203 ,p_entry_information14 => p_entry_information14
204 ,p_entry_information15 => p_entry_information15
205 ,p_entry_information16 => p_entry_information16
206 ,p_entry_information17 => p_entry_information17
207 ,p_entry_information18 => p_entry_information18
208 ,p_entry_information19 => p_entry_information19
209 ,p_entry_information20 => p_entry_information20
210 ,p_entry_information21 => p_entry_information21
211 ,p_entry_information22 => p_entry_information22
212 ,p_entry_information23 => p_entry_information23
213 ,p_entry_information24 => p_entry_information24
214 ,p_entry_information25 => p_entry_information25
215 ,p_entry_information26 => p_entry_information26
216 ,p_entry_information27 => p_entry_information27
217 ,p_entry_information28 => p_entry_information28
218 ,p_entry_information29 => p_entry_information29
219 ,p_entry_information30 => p_entry_information30
220 ,p_override_user_ent_chk => p_override_user_ent_chk
221 ,p_effective_start_date => p_effective_start_date
222 ,p_effective_end_date => p_effective_end_date
223 ,p_element_entry_id => p_element_entry_id
224 ,p_object_version_number => p_object_version_number
225 ,p_create_warning => p_create_warning
226 );
227 --
228 END create_element_entry;
229 --
230 -- ----------------------------------------------------------------------------
231 -- |-------------------------< delete_element_entry >-------------------------|
232 -- ----------------------------------------------------------------------------
233 --
234 PROCEDURE delete_element_entry
235 (p_validate in boolean default false
236 ,p_datetrack_delete_mode in varchar2
237 ,p_effective_date in date
238 ,p_element_entry_id in number
239 ,p_object_version_number in out nocopy number
240 ,p_effective_start_date out nocopy date
241 ,p_effective_end_date out nocopy date
242 ,p_delete_warning out nocopy boolean
243 ) IS
244
245 BEGIN
246 pay_element_entry_api.delete_element_entry
247 (p_validate
248 ,p_datetrack_delete_mode => p_datetrack_delete_mode
249 ,p_effective_date => p_effective_date
250 ,p_element_entry_id => p_element_entry_id
251 ,p_object_version_number => p_object_version_number
252 ,p_effective_start_date => p_effective_start_date
253 ,p_effective_end_date => p_effective_end_date
254 ,p_delete_warning => p_delete_warning);
255 END delete_element_entry;
256 --
257 -- ----------------------------------------------------------------------------
258 -- |-------------------------< update_element_entry >-------------------------|
259 -- ----------------------------------------------------------------------------
260 --
261 PROCEDURE update_element_entry
262 (p_validate in boolean default false
263 ,p_datetrack_update_mode in varchar2
264 ,p_effective_date in date
265 ,p_business_group_id in number
266 ,p_element_entry_id in number
267 ,p_object_version_number in out nocopy number
268 ,p_cost_allocation_keyflex_id in number default hr_api.g_number
269 ,p_updating_action_id in number default hr_api.g_number
270 ,p_updating_action_type in varchar2 default hr_api.g_varchar2
271 ,p_original_entry_id in number default hr_api.g_number
272 ,p_creator_type in varchar2 default hr_api.g_varchar2
273 ,p_comment_id in number default hr_api.g_number
274 ,p_creator_id in number default hr_api.g_number
275 ,p_reason in varchar2 default hr_api.g_varchar2
276 ,p_subpriority in number default hr_api.g_number
277 ,p_date_earned in date default hr_api.g_date
278 ,p_personal_payment_method_id in number default hr_api.g_number
279 ,p_attribute_category in varchar2 default hr_api.g_varchar2
280 ,p_attribute1 in varchar2 default hr_api.g_varchar2
281 ,p_attribute2 in varchar2 default hr_api.g_varchar2
282 ,p_attribute3 in varchar2 default hr_api.g_varchar2
283 ,p_attribute4 in varchar2 default hr_api.g_varchar2
284 ,p_attribute5 in varchar2 default hr_api.g_varchar2
285 ,p_attribute6 in varchar2 default hr_api.g_varchar2
286 ,p_attribute7 in varchar2 default hr_api.g_varchar2
287 ,p_attribute8 in varchar2 default hr_api.g_varchar2
288 ,p_attribute9 in varchar2 default hr_api.g_varchar2
289 ,p_attribute10 in varchar2 default hr_api.g_varchar2
290 ,p_attribute11 in varchar2 default hr_api.g_varchar2
291 ,p_attribute12 in varchar2 default hr_api.g_varchar2
292 ,p_attribute13 in varchar2 default hr_api.g_varchar2
293 ,p_attribute14 in varchar2 default hr_api.g_varchar2
294 ,p_attribute15 in varchar2 default hr_api.g_varchar2
295 ,p_attribute16 in varchar2 default hr_api.g_varchar2
296 ,p_attribute17 in varchar2 default hr_api.g_varchar2
297 ,p_attribute18 in varchar2 default hr_api.g_varchar2
298 ,p_attribute19 in varchar2 default hr_api.g_varchar2
299 ,p_attribute20 in varchar2 default hr_api.g_varchar2
300 ,p_input_value_id1 in number default null
301 ,p_input_value_id2 in number default null
302 ,p_input_value_id3 in number default null
303 ,p_input_value_id4 in number default null
304 ,p_input_value_id5 in number default null
305 ,p_input_value_id6 in number default null
306 ,p_input_value_id7 in number default null
307 ,p_input_value_id8 in number default null
308 ,p_input_value_id9 in number default null
309 ,p_input_value_id10 in number default null
310 ,p_input_value_id11 in number default null
311 ,p_input_value_id12 in number default null
312 ,p_input_value_id13 in number default null
313 ,p_input_value_id14 in number default null
314 ,p_input_value_id15 in number default null
315 ,p_entry_value1 in varchar2 default null
316 ,p_entry_value2 in varchar2 default null
317 ,p_entry_value3 in varchar2 default null
318 ,p_entry_value4 in varchar2 default null
319 ,p_entry_value5 in varchar2 default null
320 ,p_entry_value6 in varchar2 default null
321 ,p_entry_value7 in varchar2 default null
322 ,p_entry_value8 in varchar2 default null
323 ,p_entry_value9 in varchar2 default null
324 ,p_entry_value10 in varchar2 default null
325 ,p_entry_value11 in varchar2 default null
326 ,p_entry_value12 in varchar2 default null
327 ,p_entry_value13 in varchar2 default null
328 ,p_entry_value14 in varchar2 default null
329 ,p_entry_value15 in varchar2 default null
330 ,p_entry_information_category in varchar2 default hr_api.g_varchar2
331 ,p_entry_information1 in varchar2 default hr_api.g_varchar2
332 ,p_entry_information2 in varchar2 default hr_api.g_varchar2
333 ,p_entry_information3 in varchar2 default hr_api.g_varchar2
334 ,p_entry_information4 in varchar2 default hr_api.g_varchar2
335 ,p_entry_information5 in varchar2 default hr_api.g_varchar2
336 ,p_entry_information6 in varchar2 default hr_api.g_varchar2
337 ,p_entry_information7 in varchar2 default hr_api.g_varchar2
338 ,p_entry_information8 in varchar2 default hr_api.g_varchar2
339 ,p_entry_information9 in varchar2 default hr_api.g_varchar2
340 ,p_entry_information10 in varchar2 default hr_api.g_varchar2
341 ,p_entry_information11 in varchar2 default hr_api.g_varchar2
342 ,p_entry_information12 in varchar2 default hr_api.g_varchar2
343 ,p_entry_information13 in varchar2 default hr_api.g_varchar2
344 ,p_entry_information14 in varchar2 default hr_api.g_varchar2
345 ,p_entry_information15 in varchar2 default hr_api.g_varchar2
346 ,p_entry_information16 in varchar2 default hr_api.g_varchar2
347 ,p_entry_information17 in varchar2 default hr_api.g_varchar2
348 ,p_entry_information18 in varchar2 default hr_api.g_varchar2
349 ,p_entry_information19 in varchar2 default hr_api.g_varchar2
350 ,p_entry_information20 in varchar2 default hr_api.g_varchar2
351 ,p_entry_information21 in varchar2 default hr_api.g_varchar2
352 ,p_entry_information22 in varchar2 default hr_api.g_varchar2
353 ,p_entry_information23 in varchar2 default hr_api.g_varchar2
354 ,p_entry_information24 in varchar2 default hr_api.g_varchar2
355 ,p_entry_information25 in varchar2 default hr_api.g_varchar2
356 ,p_entry_information26 in varchar2 default hr_api.g_varchar2
357 ,p_entry_information27 in varchar2 default hr_api.g_varchar2
358 ,p_entry_information28 in varchar2 default hr_api.g_varchar2
359 ,p_entry_information29 in varchar2 default hr_api.g_varchar2
360 ,p_entry_information30 in varchar2 default hr_api.g_varchar2
361 ,p_override_user_ent_chk in varchar2 default 'N'
362 ,p_effective_start_date out nocopy date
363 ,p_effective_end_date out nocopy date
364 ,p_update_warning out nocopy boolean
365 ) IS
366 --
367 BEGIN
368 --
369 pay_element_entry_api.update_element_entry
370 (
371 p_validate => p_validate,
372 p_datetrack_update_mode => p_datetrack_update_mode,
373 p_effective_date => p_effective_date,
374 p_business_group_id => p_business_group_id,
375 p_element_entry_id => p_element_entry_id,
376 p_object_version_number => p_object_version_number,
377 p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id,
378 p_updating_action_id => p_updating_action_id,
379 p_updating_action_type => p_updating_action_type,
380 p_original_entry_id => p_original_entry_id,
381 p_creator_type => p_creator_type,
382 p_comment_id => p_comment_id,
383 p_creator_id => p_creator_id,
384 p_reason => p_reason,
385 p_subpriority => p_subpriority,
386 p_date_earned => p_date_earned,
387 p_personal_payment_method_id => p_personal_payment_method_id,
388 p_attribute_category => p_attribute_category,
389 p_attribute1 => p_attribute1,
390 p_attribute2 => p_attribute2,
391 p_attribute3 => p_attribute3,
392 p_attribute4 => p_attribute4,
393 p_attribute5 => p_attribute5,
394 p_attribute6 => p_attribute6,
395 p_attribute7 => p_attribute7,
396 p_attribute8 => p_attribute8,
397 p_attribute9 => p_attribute9,
398 p_attribute10 => p_attribute10,
399 p_attribute11 => p_attribute11,
400 p_attribute12 => p_attribute12,
401 p_attribute13 => p_attribute13,
402 p_attribute14 => p_attribute14,
403 p_attribute15 => p_attribute15,
404 p_attribute16 => p_attribute16,
405 p_attribute17 => p_attribute17,
406 p_attribute18 => p_attribute18,
407 p_attribute19 => p_attribute19,
408 p_attribute20 => p_attribute20,
409 p_input_value_id1 => p_input_value_id1,
410 p_input_value_id2 => p_input_value_id2,
411 p_input_value_id3 => p_input_value_id3,
412 p_input_value_id4 => p_input_value_id4,
413 p_input_value_id5 => p_input_value_id5,
414 p_input_value_id6 => p_input_value_id6,
415 p_input_value_id7 => p_input_value_id7,
416 p_input_value_id8 => p_input_value_id8,
417 p_input_value_id9 => p_input_value_id9,
418 p_input_value_id10 => p_input_value_id10,
419 p_input_value_id11 => p_input_value_id11,
420 p_input_value_id12 => p_input_value_id12,
421 p_input_value_id13 => p_input_value_id13,
422 p_input_value_id14 => p_input_value_id14,
423 p_input_value_id15 => p_input_value_id15,
424 p_entry_value1 => p_entry_value1,
425 p_entry_value2 => p_entry_value2,
426 p_entry_value3 => p_entry_value3,
427 p_entry_value4 => p_entry_value4,
428 p_entry_value5 => p_entry_value5,
429 p_entry_value6 => p_entry_value6,
430 p_entry_value7 => p_entry_value7,
431 p_entry_value8 => p_entry_value8,
432 p_entry_value9 => p_entry_value9,
433 p_entry_value10 => p_entry_value10,
434 p_entry_value11 => p_entry_value11,
435 p_entry_value12 => p_entry_value12,
436 p_entry_value13 => p_entry_value13,
437 p_entry_value14 => p_entry_value14,
438 p_entry_value15 => p_entry_value15,
439 p_entry_information_category => p_entry_information_category,
440 p_entry_information1 => p_entry_information1,
441 p_entry_information2 => p_entry_information2,
442 p_entry_information3 => p_entry_information3,
443 p_entry_information4 => p_entry_information4,
444 p_entry_information5 => p_entry_information5,
445 p_entry_information6 => p_entry_information6,
446 p_entry_information7 => p_entry_information7,
447 p_entry_information8 => p_entry_information8,
448 p_entry_information9 => p_entry_information9,
449 p_entry_information10 => p_entry_information10,
450 p_entry_information11 => p_entry_information11,
451 p_entry_information12 => p_entry_information12,
452 p_entry_information13 => p_entry_information13,
453 p_entry_information14 => p_entry_information14,
454 p_entry_information15 => p_entry_information15,
455 p_entry_information16 => p_entry_information16,
456 p_entry_information17 => p_entry_information17,
457 p_entry_information18 => p_entry_information18,
458 p_entry_information19 => p_entry_information19,
459 p_entry_information20 => p_entry_information20,
460 p_entry_information21 => p_entry_information21,
461 p_entry_information22 => p_entry_information22,
462 p_entry_information23 => p_entry_information23,
463 p_entry_information24 => p_entry_information24,
464 p_entry_information25 => p_entry_information25,
465 p_entry_information26 => p_entry_information26,
466 p_entry_information27 => p_entry_information27,
467 p_entry_information28 => p_entry_information28,
468 p_entry_information29 => p_entry_information29,
469 p_entry_information30 => p_entry_information30,
470 p_override_user_ent_chk => p_override_user_ent_chk,
471 p_effective_start_date => p_effective_start_date,
472 p_effective_end_date => p_effective_end_date,
473 p_update_warning => p_update_warning
474 );
475 --
476 END update_element_entry;
477 --
478 END py_element_entry_api;