[Home] [Help]
PACKAGE: APPS.HR_ENTRY_API
Source
1 package hr_entry_api AUTHID CURRENT_USER as
2 /* $Header: pyentapi.pkh 120.2.12010000.1 2008/07/27 22:31:54 appldev ship $ */
3 --
4 /*
5 /*
6
7 * Copyright (C) 1993 Oracle Corporation UK Ltd. Richmond, England. *
8
9 Name : hr_entry_api
10 Description : API for element entries. Supports insert, update and delete.
11 Uses : hr_entry , hr_utility
12 Used By : hrentmnt
13
14 Change List
15 -----------
16 Date Name Vers Bug No Description
17 +---------+------------+-------+--------+------------------------------------+
18 29-Oct-93 J.S.Hobbs 40.0 First Created.
19 04-Nov-93 J.S.Hobbs 40.1 Changed parameters to
20 update_element_entry.
21 01-Mar-94 D.C.Harris 40.2 G590 Added new parameter
22 p_check_for_update.
23 08-Mar-94 D.C.Harris 40.3 Corrected defaulting of
24 p_dt_update_mode.
25 Enabled use of passing hot defaulted
26 values to update api.
27 02-Mar-95 J.S.Hobbs 40.5 Added support for new column
28 SUBPRIORITY
29 18-Apr-95 J.S.Hobbs 40.6 274283 Changed parameter p_reason to be a
30 varchar2 instead of a number.
31 16-May-95 D.E.Saxby 40.7 280574 Made validate_entry_value public.
32 29-Jun-95 N. Simpson 40.8 Added new columns date_earned and
33 personal_payment_method_id
34 07-May-97 M.Reid 40.9 Changed defaults to API standards
35 26-NOV-98 S.Billing 110.1 559467 Modified conv_entry_values_to_table()
36 and conv_table_to_table(),
37 added extra parameters so that creator
38 type and entry type can be passed
39 down,
40 if creator type is forms or mix and
41 and entry type is NOT adjustment and
42 the user is attempting to set/update
43 a non-user enterable input value
44 then throw an error
45 -- --
46 25-Apr-00 sbilling 115.3 Merged in changes made by J.Bailie to
47 introduce DDFF functionality on the
48 Element Entry form.
49 Overloaded insert_element_entry and
50 update_element_entry procedures
51 to add developer flex. There now exist
52 4 versions of each procedure which
53 have
54 Table of IV's
55 Expanded IV's
56 Table of IV's and DDF
57 Expanded IV's amd DDF
58 19-Jun-00 D.E.Saxby 115.4 1334301 Made set_formula_contexts public.
59 15-Aug-00 A.Handa 115.5 Added commit before exit statement.
60 24-jul-01 tbattoo 115.6 1869615 Support for new column on pay_element
61 entries, updating_action_type
62 11-Feb-02 SuSivasu 115.7 Added default for p_entry_information_category
63 as well as included p_override_user_ent_chk
64 to the insert and update entry interfaces.
65 12-Feb-02 SuSivasu 115.8 GSCC standards fix.
66 05-Dec-02 dsaxby 115.9 2692195 Nocopy changes.
67 11-Feb-03 swinton 115.10 2793978 Enabled value set validation of
68 element entry values.
69 Validate_entry_value modified to
70 handle value set validated entry
71 values.
72 28-Mar-03 alogue 115.11 2848993 Undo Nocopy changes to insert_element_entry
73 called from c-code batch processes (to
74 avoit nasty patching issue!).
75 04-Oct-05 swinton 115.12 4646377 Reinstated NOCOPY changes to
76 insert_element_entry.
77
78 +---------+------------+-------+--------+------------------------------------+
79 */
80 --
81 ------------------------------------------------------------------------------
82 -- NAME --
83 -- hr_entry_api.conv_entry_values_to_table --
84 -- --
85 -- DESCRIPTION --
86 -- Converts a set of predefined parameters containing the INPUT_VALUE_IDs --
87 -- and SCREEN_ENTRY_VALUEs for an element entry to a pair of PLSQL tables --
88 -- containing the same information. It also returns the number of entry --
89 -- values. --
90 ------------------------------------------------------------------------------
91 --
92 procedure conv_entry_values_to_table
93 (
94 p_iv_format varchar2,
95 p_element_entry_id number,
96 p_element_link_id number,
97 p_session_date date,
98 p_creator_type varchar2,
99 p_entry_type varchar2,
100 p_input_value_id1 number,
101 p_input_value_id2 number,
102 p_input_value_id3 number,
103 p_input_value_id4 number,
104 p_input_value_id5 number,
105 p_input_value_id6 number,
106 p_input_value_id7 number,
107 p_input_value_id8 number,
108 p_input_value_id9 number,
109 p_input_value_id10 number,
110 p_input_value_id11 number,
111 p_input_value_id12 number,
112 p_input_value_id13 number,
113 p_input_value_id14 number,
114 p_input_value_id15 number,
115 p_entry_value1 varchar2,
116 p_entry_value2 varchar2,
117 p_entry_value3 varchar2,
118 p_entry_value4 varchar2,
119 p_entry_value5 varchar2,
120 p_entry_value6 varchar2,
121 p_entry_value7 varchar2,
122 p_entry_value8 varchar2,
123 p_entry_value9 varchar2,
124 p_entry_value10 varchar2,
125 p_entry_value11 varchar2,
126 p_entry_value12 varchar2,
127 p_entry_value13 varchar2,
128 p_entry_value14 varchar2,
129 p_entry_value15 varchar2,
130 p_num_entry_values out nocopy number,
131 p_input_value_id_tbl out nocopy hr_entry.number_table,
132 p_entry_value_tbl out nocopy hr_entry.varchar2_table
133 );
134 --
135 ------------------------------------------------------------------------------
136 -- NAME --
137 -- hr_entry.conv_table_to_table --
138 -- --
139 -- DESCRIPTION --
140 -- Given a table of entry values it converts to DB format if required. Any --
141 -- entry values that are not specified are derived NB. when inserting the --
142 -- values are defaulted, when updating the existing entry values are used. --
143 ------------------------------------------------------------------------------
144 --
145 procedure conv_table_to_table
146 (
147 p_iv_format varchar2,
148 p_session_date date,
149 p_element_entry_id number,
150 p_element_link_id number,
151 p_num_entry_values in out nocopy number,
152 p_creator_type varchar2,
153 p_entry_type varchar2,
154 p_input_value_id_tbl in out nocopy hr_entry.number_table,
155 p_entry_value_tbl in out nocopy hr_entry.varchar2_table
156 );
157 --
158 ------------------------------------------------------------------------------
159 -- NAME --
160 -- hr_entry_api.set_formula_contexts --
161 -- --
162 -- DESCRIPTION --
163 -- Called to set the (global) contexts that will be used in any input value --
164 -- validation formula. We obtain the business_group_id from the assignment --
165 -- only if it hasn't already been set to save ourselves a database hit. --
166 ------------------------------------------------------------------------------
167 --
168 procedure set_formula_contexts
169 (
170 p_assignment_id number,
171 p_effective_date date
172 );
173 --
174 ------------------------------------------------------------------------------
175 -- NAME --
176 -- hr_entry.validate_entry_value --
177 -- --
178 -- DESCRIPTION --
179 -- Validates and converts an entry value to DB format. --
180 ------------------------------------------------------------------------------
181 --
182 procedure validate_entry_value
183 (
184 p_element_link_id number,
185 p_input_value_id number,
186 p_session_date date,
187 p_screen_format in out nocopy varchar2,
188 p_db_format in out nocopy varchar2,
189 p_lookup_type varchar2,
190 p_uom varchar2,
191 p_input_currency_code varchar2,
192 p_value_set_id number default null
193 );
194 --
195 ------------------------------------------------------------------------------
196 -- NAME --
197 -- hr_entry_api.get_link --
198 -- --
199 -- DESCRIPTION --
200 -- Returns for the element link that represents the assignments eligibility --
201 -- for a particular element type on a given date. --
202 ------------------------------------------------------------------------------
203 --
204 function get_link
205 (
206 p_assignment_id number,
207 p_element_type_id number,
208 p_session_date date
209 ) return number;
210 --
211 ------------------------------------------------------------------------------
212 -- NAME --
213 -- hr_entry_api.insert_element_entry --
214 -- --
215 -- DESCRIPTION --
216 -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
217 -- entry values passed as a table. It converts the entry values to DB --
218 -- format and also defaults any entry values that were not specified. --
219 -- NB. all entry values specified are validated ! --
220 ------------------------------------------------------------------------------
221 --
222 procedure insert_element_entry
223 (
224 --
225 -- Common Parameters
226 --
227 p_effective_start_date in out nocopy date,
228 p_effective_end_date in out nocopy date,
229 --
230 -- Element Entry Table
231 --
232 p_element_entry_id in out nocopy number,
233 p_original_entry_id number default null,
234 p_assignment_id number,
235 p_element_link_id number,
236 p_creator_type varchar2,
237 p_entry_type varchar2,
238 p_cost_allocation_keyflex_id number default null,
239 p_updating_action_id number default null,
240 p_updating_action_type varchar2 default null,
241 p_comment_id number default null,
242 p_creator_id number default null,
243 p_reason varchar2 default null,
244 p_target_entry_id number default null,
245 p_subpriority number default null,
246 p_date_earned date default null,
247 p_personal_payment_method_id number default null,
248 p_attribute_category varchar2 default null,
249 p_attribute1 varchar2 default null,
250 p_attribute2 varchar2 default null,
251 p_attribute3 varchar2 default null,
252 p_attribute4 varchar2 default null,
253 p_attribute5 varchar2 default null,
254 p_attribute6 varchar2 default null,
255 p_attribute7 varchar2 default null,
256 p_attribute8 varchar2 default null,
257 p_attribute9 varchar2 default null,
258 p_attribute10 varchar2 default null,
259 p_attribute11 varchar2 default null,
260 p_attribute12 varchar2 default null,
261 p_attribute13 varchar2 default null,
262 p_attribute14 varchar2 default null,
263 p_attribute15 varchar2 default null,
264 p_attribute16 varchar2 default null,
265 p_attribute17 varchar2 default null,
266 p_attribute18 varchar2 default null,
267 p_attribute19 varchar2 default null,
268 p_attribute20 varchar2 default null,
269 p_override_user_ent_chk varchar2 default 'N',
270 p_label_identifier varchar2 default null,
271
272 --
273 -- Element Entry Values Table
274 --
275 p_num_entry_values number,
276 p_input_value_id_tbl hr_entry.number_table,
277 p_entry_value_tbl hr_entry.varchar2_table
278 );
279 --
280 ------------------------------------------------------------------------------
281 -- NAME --
282 -- hr_entry_api.insert_element_entry --
283 -- --
284 -- DESCRIPTION --
285 -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
286 -- entry values passed as parameters. It converts the entry values to DB --
287 -- format and also defaults any entry values that were not specified. --
288 -- NB. all entry values specified are validated ! --
289 ------------------------------------------------------------------------------
290 --
291 procedure insert_element_entry
292 (
293 --
294 -- Common Parameters
295 --
296 p_effective_start_date in out nocopy date,
297 p_effective_end_date in out nocopy date,
298 --
299 -- Element Entry Table
300 --
301 p_element_entry_id in out nocopy number,
302 p_original_entry_id number default null,
303 p_assignment_id number,
304 p_element_link_id number,
305 p_creator_type varchar2,
306 p_entry_type varchar2,
307 p_cost_allocation_keyflex_id number default null,
308 p_updating_action_id number default null,
309 p_updating_action_type varchar2 default null,
310 p_comment_id number default null,
311 p_creator_id number default null,
312 p_reason varchar2 default null,
313 p_target_entry_id number default null,
314 p_subpriority number default null,
315 p_date_earned date default null,
316 p_personal_payment_method_id number default null,
317 p_attribute_category varchar2 default null,
318 p_attribute1 varchar2 default null,
319 p_attribute2 varchar2 default null,
320 p_attribute3 varchar2 default null,
321 p_attribute4 varchar2 default null,
322 p_attribute5 varchar2 default null,
323 p_attribute6 varchar2 default null,
324 p_attribute7 varchar2 default null,
325 p_attribute8 varchar2 default null,
326 p_attribute9 varchar2 default null,
327 p_attribute10 varchar2 default null,
328 p_attribute11 varchar2 default null,
329 p_attribute12 varchar2 default null,
330 p_attribute13 varchar2 default null,
331 p_attribute14 varchar2 default null,
332 p_attribute15 varchar2 default null,
333 p_attribute16 varchar2 default null,
334 p_attribute17 varchar2 default null,
335 p_attribute18 varchar2 default null,
336 p_attribute19 varchar2 default null,
337 p_attribute20 varchar2 default null,
338 --
339 -- Element Entry Values Table
340 --
341 p_input_value_id1 number default null,
342 p_input_value_id2 number default null,
343 p_input_value_id3 number default null,
344 p_input_value_id4 number default null,
345 p_input_value_id5 number default null,
346 p_input_value_id6 number default null,
347 p_input_value_id7 number default null,
348 p_input_value_id8 number default null,
349 p_input_value_id9 number default null,
350 p_input_value_id10 number default null,
351 p_input_value_id11 number default null,
352 p_input_value_id12 number default null,
353 p_input_value_id13 number default null,
354 p_input_value_id14 number default null,
355 p_input_value_id15 number default null,
356 p_entry_value1 varchar2 default null,
357 p_entry_value2 varchar2 default null,
358 p_entry_value3 varchar2 default null,
359 p_entry_value4 varchar2 default null,
360 p_entry_value5 varchar2 default null,
361 p_entry_value6 varchar2 default null,
362 p_entry_value7 varchar2 default null,
363 p_entry_value8 varchar2 default null,
364 p_entry_value9 varchar2 default null,
365 p_entry_value10 varchar2 default null,
366 p_entry_value11 varchar2 default null,
367 p_entry_value12 varchar2 default null,
368 p_entry_value13 varchar2 default null,
369 p_entry_value14 varchar2 default null,
370 p_entry_value15 varchar2 default null,
371 p_override_user_ent_chk varchar2 default 'N',
372 p_label_identifier varchar2 default null
373 );
374 --
375 -- --
376 --
377 ------------------------------------------------------------------------------
378 -- NAME --
379 -- hr_entry_api.insert_element_entry --
380 -- --
381 -- DESCRIPTION --
382 -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
383 -- entry values passed as a table. It converts the entry values to DB --
384 -- format and also defaults any entry values that were not specified. --
385 -- NB. all entry values specified are validated ! --
386 ------------------------------------------------------------------------------
387 --
388 -- Overloaded version with Element Entry developer flex
389 --
390 procedure insert_element_entry
391 (
392 --
393 -- Common Parameters
394 --
395 p_effective_start_date in out nocopy date,
396 p_effective_end_date in out nocopy date,
397 --
398 -- Element Entry Table
399 --
400 p_element_entry_id in out nocopy number,
401 p_original_entry_id number default null,
402 p_assignment_id number,
403 p_element_link_id number,
404 p_creator_type varchar2,
405 p_entry_type varchar2,
406 p_cost_allocation_keyflex_id number default null,
407 p_updating_action_id number default null,
408 p_updating_action_type varchar2 default null,
409 p_comment_id number default null,
410 p_creator_id number default null,
411 p_reason varchar2 default null,
412 p_target_entry_id number default null,
413 p_subpriority number default null,
414 p_date_earned date default null,
415 p_personal_payment_method_id number default null,
416 p_attribute_category varchar2 default null,
417 p_attribute1 varchar2 default null,
418 p_attribute2 varchar2 default null,
419 p_attribute3 varchar2 default null,
420 p_attribute4 varchar2 default null,
421 p_attribute5 varchar2 default null,
422 p_attribute6 varchar2 default null,
423 p_attribute7 varchar2 default null,
424 p_attribute8 varchar2 default null,
425 p_attribute9 varchar2 default null,
426 p_attribute10 varchar2 default null,
427 p_attribute11 varchar2 default null,
428 p_attribute12 varchar2 default null,
429 p_attribute13 varchar2 default null,
430 p_attribute14 varchar2 default null,
431 p_attribute15 varchar2 default null,
432 p_attribute16 varchar2 default null,
433 p_attribute17 varchar2 default null,
434 p_attribute18 varchar2 default null,
435 p_attribute19 varchar2 default null,
436 p_attribute20 varchar2 default null,
437 --
438 -- Element Entry Values Table
439 --
440 p_num_entry_values number,
441 p_input_value_id_tbl hr_entry.number_table,
442 p_entry_value_tbl hr_entry.varchar2_table,
443 --
444 -- Developer Descriptive Flex
445 --
446 p_entry_information_category varchar2 ,
447 p_entry_information1 varchar2 default null,
448 p_entry_information2 varchar2 default null,
449 p_entry_information3 varchar2 default null,
450 p_entry_information4 varchar2 default null,
451 p_entry_information5 varchar2 default null,
452 p_entry_information6 varchar2 default null,
453 p_entry_information7 varchar2 default null,
454 p_entry_information8 varchar2 default null,
455 p_entry_information9 varchar2 default null,
456 p_entry_information10 varchar2 default null,
457 p_entry_information11 varchar2 default null,
458 p_entry_information12 varchar2 default null,
459 p_entry_information13 varchar2 default null,
460 p_entry_information14 varchar2 default null,
461 p_entry_information15 varchar2 default null,
462 p_entry_information16 varchar2 default null,
463 p_entry_information17 varchar2 default null,
464 p_entry_information18 varchar2 default null,
465 p_entry_information19 varchar2 default null,
466 p_entry_information20 varchar2 default null,
467 p_entry_information21 varchar2 default null,
468 p_entry_information22 varchar2 default null,
469 p_entry_information23 varchar2 default null,
470 p_entry_information24 varchar2 default null,
471 p_entry_information25 varchar2 default null,
472 p_entry_information26 varchar2 default null,
473 p_entry_information27 varchar2 default null,
474 p_entry_information28 varchar2 default null,
475 p_entry_information29 varchar2 default null,
476 p_entry_information30 varchar2 default null,
477 p_override_user_ent_chk varchar2 default 'N',
478 p_label_identifier varchar2 default null
479 );
480 --
481 -- --
482 --
483 ------------------------------------------------------------------------------
484 -- NAME --
485 -- hr_entry_api.insert_element_entry --
486 -- --
487 -- DESCRIPTION --
488 -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
489 -- entry values passed as parameters. It converts the entry values to DB --
490 -- format and also defaults any entry values that were not specified. --
491 -- NB. all entry values specified are validated ! --
492 ------------------------------------------------------------------------------
493 --
494 --
495 -- Overloaded version with Element Entry developer flex
496 --
497 procedure insert_element_entry
498 (
499 --
500 -- Common Parameters
501 --
502 p_effective_start_date in out nocopy date,
503 p_effective_end_date in out nocopy date,
504 --
505 -- Element Entry Table
506 --
507 p_element_entry_id in out nocopy number,
508 p_original_entry_id number default null,
509 p_assignment_id number,
510 p_element_link_id number,
511 p_creator_type varchar2,
512 p_entry_type varchar2,
513 p_cost_allocation_keyflex_id number default null,
514 p_updating_action_id number default null,
515 p_updating_action_type varchar2 default null,
516 p_comment_id number default null,
517 p_creator_id number default null,
518 p_reason varchar2 default null,
519 p_target_entry_id number default null,
520 p_subpriority number default null,
521 p_date_earned date default null,
522 p_personal_payment_method_id number default null,
523 p_attribute_category varchar2 default null,
524 p_attribute1 varchar2 default null,
525 p_attribute2 varchar2 default null,
526 p_attribute3 varchar2 default null,
527 p_attribute4 varchar2 default null,
528 p_attribute5 varchar2 default null,
529 p_attribute6 varchar2 default null,
530 p_attribute7 varchar2 default null,
531 p_attribute8 varchar2 default null,
532 p_attribute9 varchar2 default null,
533 p_attribute10 varchar2 default null,
534 p_attribute11 varchar2 default null,
535 p_attribute12 varchar2 default null,
536 p_attribute13 varchar2 default null,
537 p_attribute14 varchar2 default null,
538 p_attribute15 varchar2 default null,
539 p_attribute16 varchar2 default null,
540 p_attribute17 varchar2 default null,
541 p_attribute18 varchar2 default null,
542 p_attribute19 varchar2 default null,
543 p_attribute20 varchar2 default null,
544 --
545 -- Element Entry Values Table
546 --
547 p_input_value_id1 number default null,
548 p_input_value_id2 number default null,
549 p_input_value_id3 number default null,
550 p_input_value_id4 number default null,
551 p_input_value_id5 number default null,
552 p_input_value_id6 number default null,
553 p_input_value_id7 number default null,
554 p_input_value_id8 number default null,
555 p_input_value_id9 number default null,
556 p_input_value_id10 number default null,
557 p_input_value_id11 number default null,
558 p_input_value_id12 number default null,
559 p_input_value_id13 number default null,
560 p_input_value_id14 number default null,
561 p_input_value_id15 number default null,
562 p_entry_value1 varchar2 default null,
563 p_entry_value2 varchar2 default null,
564 p_entry_value3 varchar2 default null,
565 p_entry_value4 varchar2 default null,
566 p_entry_value5 varchar2 default null,
567 p_entry_value6 varchar2 default null,
568 p_entry_value7 varchar2 default null,
569 p_entry_value8 varchar2 default null,
570 p_entry_value9 varchar2 default null,
571 p_entry_value10 varchar2 default null,
572 p_entry_value11 varchar2 default null,
573 p_entry_value12 varchar2 default null,
574 p_entry_value13 varchar2 default null,
575 p_entry_value14 varchar2 default null,
576 p_entry_value15 varchar2 default null,
577 --
578 -- Developer Descriptive Flex
579 --
580 p_entry_information_category varchar2 ,
581 p_entry_information1 varchar2 default null,
582 p_entry_information2 varchar2 default null,
583 p_entry_information3 varchar2 default null,
584 p_entry_information4 varchar2 default null,
585 p_entry_information5 varchar2 default null,
586 p_entry_information6 varchar2 default null,
587 p_entry_information7 varchar2 default null,
588 p_entry_information8 varchar2 default null,
589 p_entry_information9 varchar2 default null,
590 p_entry_information10 varchar2 default null,
591 p_entry_information11 varchar2 default null,
592 p_entry_information12 varchar2 default null,
593 p_entry_information13 varchar2 default null,
594 p_entry_information14 varchar2 default null,
595 p_entry_information15 varchar2 default null,
596 p_entry_information16 varchar2 default null,
597 p_entry_information17 varchar2 default null,
598 p_entry_information18 varchar2 default null,
599 p_entry_information19 varchar2 default null,
600 p_entry_information20 varchar2 default null,
601 p_entry_information21 varchar2 default null,
602 p_entry_information22 varchar2 default null,
603 p_entry_information23 varchar2 default null,
604 p_entry_information24 varchar2 default null,
605 p_entry_information25 varchar2 default null,
606 p_entry_information26 varchar2 default null,
607 p_entry_information27 varchar2 default null,
608 p_entry_information28 varchar2 default null,
609 p_entry_information29 varchar2 default null,
610 p_entry_information30 varchar2 default null,
611 p_override_user_ent_chk varchar2 default 'N',
612 p_label_identifier varchar2 default null
613 );
614 --
615 ------------------------------------------------------------------------------
616 -- NAME --
617 -- hr_entry_api.update_element_entry --
618 -- --
619 -- DESCRIPTION --
620 -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
621 -- entry values passed as a table. It converts the entry values to DB --
622 -- format. Any entry values that were not specified are copied from the --
623 -- element entry being updated. --
624 -- NB. all entry values specified are validated ! --
625 ------------------------------------------------------------------------------
626 --
627 procedure update_element_entry
628 (
629 --
630 -- Update Mode
631 --
632 p_dt_update_mode varchar2 default null,
633 --
634 -- Date on which change is taking place
635 --
636 p_session_date date,
637 --
638 -- Check to see if the entry is being updated
639 --
640 p_check_for_update varchar2 default 'N',
641 --
642 -- Element Entry Table
643 --
644 p_element_entry_id number,
645 p_cost_allocation_keyflex_id number default hr_api.g_number,
646 p_updating_action_id number default hr_api.g_number,
647 p_updating_action_type varchar2 default hr_api.g_varchar2,
648 p_original_entry_id number default hr_api.g_number,
649 p_creator_type varchar2 default hr_api.g_varchar2,
650 p_comment_id number default hr_api.g_number,
651 p_creator_id number default hr_api.g_number,
652 p_reason varchar2 default hr_api.g_varchar2,
653 p_subpriority number default hr_api.g_number,
654 p_date_earned date default hr_api.g_date,
655 p_personal_payment_method_id number default hr_api.g_number,
656 p_attribute_category varchar2 default hr_api.g_varchar2,
657 p_attribute1 varchar2 default hr_api.g_varchar2,
658 p_attribute2 varchar2 default hr_api.g_varchar2,
659 p_attribute3 varchar2 default hr_api.g_varchar2,
660 p_attribute4 varchar2 default hr_api.g_varchar2,
661 p_attribute5 varchar2 default hr_api.g_varchar2,
662 p_attribute6 varchar2 default hr_api.g_varchar2,
663 p_attribute7 varchar2 default hr_api.g_varchar2,
664 p_attribute8 varchar2 default hr_api.g_varchar2,
665 p_attribute9 varchar2 default hr_api.g_varchar2,
666 p_attribute10 varchar2 default hr_api.g_varchar2,
667 p_attribute11 varchar2 default hr_api.g_varchar2,
668 p_attribute12 varchar2 default hr_api.g_varchar2,
669 p_attribute13 varchar2 default hr_api.g_varchar2,
670 p_attribute14 varchar2 default hr_api.g_varchar2,
671 p_attribute15 varchar2 default hr_api.g_varchar2,
672 p_attribute16 varchar2 default hr_api.g_varchar2,
673 p_attribute17 varchar2 default hr_api.g_varchar2,
674 p_attribute18 varchar2 default hr_api.g_varchar2,
675 p_attribute19 varchar2 default hr_api.g_varchar2,
676 p_attribute20 varchar2 default hr_api.g_varchar2,
677 p_override_user_ent_chk varchar2 default 'N',
678 --
679 -- Element Entry Values Table
680 --
681 p_num_entry_values number,
682 p_input_value_id_tbl hr_entry.number_table,
683 p_entry_value_tbl hr_entry.varchar2_table
684 );
685 --
686 ------------------------------------------------------------------------------
687 -- NAME --
688 -- hr_entry_api.update_element_entry --
689 -- --
690 -- DESCRIPTION --
691 -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
692 -- entry values passed as parameters. It converts the entry values to DB --
693 -- format. Any entry values that were not specified are copied from the --
694 -- element entry being updated. --
695 -- NB. all entry values specified are validated ! --
696 ------------------------------------------------------------------------------
697 --
698 procedure update_element_entry
699 (
700 --
701 -- Update Mode
702 --
703 p_dt_update_mode varchar2 default null,
704 --
705 -- Date on which change is taking place
706 --
707 p_session_date date,
708 --
709 -- Check to see if the entry is being updated
710 --
711 p_check_for_update varchar2 default 'N',
712 --
713 -- Element Entry Table
714 --
715 p_element_entry_id number,
716 p_cost_allocation_keyflex_id number default hr_api.g_number,
717 p_updating_action_id number default hr_api.g_number,
718 p_updating_action_type varchar2 default hr_api.g_varchar2,
719 p_original_entry_id number default hr_api.g_number,
720 p_creator_type varchar2 default hr_api.g_varchar2,
721 p_comment_id number default hr_api.g_number,
722 p_creator_id number default hr_api.g_number,
723 p_reason varchar2 default hr_api.g_varchar2,
724 p_subpriority number default hr_api.g_number,
725 p_date_earned date default hr_api.g_date,
726 p_personal_payment_method_id number default hr_api.g_number,
727 p_attribute_category varchar2 default hr_api.g_varchar2,
728 p_attribute1 varchar2 default hr_api.g_varchar2,
729 p_attribute2 varchar2 default hr_api.g_varchar2,
730 p_attribute3 varchar2 default hr_api.g_varchar2,
731 p_attribute4 varchar2 default hr_api.g_varchar2,
732 p_attribute5 varchar2 default hr_api.g_varchar2,
733 p_attribute6 varchar2 default hr_api.g_varchar2,
734 p_attribute7 varchar2 default hr_api.g_varchar2,
735 p_attribute8 varchar2 default hr_api.g_varchar2,
736 p_attribute9 varchar2 default hr_api.g_varchar2,
737 p_attribute10 varchar2 default hr_api.g_varchar2,
738 p_attribute11 varchar2 default hr_api.g_varchar2,
739 p_attribute12 varchar2 default hr_api.g_varchar2,
740 p_attribute13 varchar2 default hr_api.g_varchar2,
741 p_attribute14 varchar2 default hr_api.g_varchar2,
742 p_attribute15 varchar2 default hr_api.g_varchar2,
743 p_attribute16 varchar2 default hr_api.g_varchar2,
744 p_attribute17 varchar2 default hr_api.g_varchar2,
745 p_attribute18 varchar2 default hr_api.g_varchar2,
746 p_attribute19 varchar2 default hr_api.g_varchar2,
747 p_attribute20 varchar2 default hr_api.g_varchar2,
748 --
749 -- Element Entry Values Table
750 --
751 p_input_value_id1 number default null,
752 p_input_value_id2 number default null,
753 p_input_value_id3 number default null,
754 p_input_value_id4 number default null,
755 p_input_value_id5 number default null,
756 p_input_value_id6 number default null,
757 p_input_value_id7 number default null,
758 p_input_value_id8 number default null,
759 p_input_value_id9 number default null,
760 p_input_value_id10 number default null,
761 p_input_value_id11 number default null,
762 p_input_value_id12 number default null,
763 p_input_value_id13 number default null,
764 p_input_value_id14 number default null,
765 p_input_value_id15 number default null,
766 p_entry_value1 varchar2 default null,
767 p_entry_value2 varchar2 default null,
768 p_entry_value3 varchar2 default null,
769 p_entry_value4 varchar2 default null,
770 p_entry_value5 varchar2 default null,
771 p_entry_value6 varchar2 default null,
772 p_entry_value7 varchar2 default null,
773 p_entry_value8 varchar2 default null,
774 p_entry_value9 varchar2 default null,
775 p_entry_value10 varchar2 default null,
776 p_entry_value11 varchar2 default null,
777 p_entry_value12 varchar2 default null,
778 p_entry_value13 varchar2 default null,
779 p_entry_value14 varchar2 default null,
780 p_entry_value15 varchar2 default null,
781 p_override_user_ent_chk varchar2 default 'N'
782 );
783 --
784 -- --
785 --
786 ------------------------------------------------------------------------------
787 -- NAME --
788 -- hr_entry_api.update_element_entry --
789 -- --
790 -- DESCRIPTION --
791 -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
792 -- entry values passed as a table. It converts the entry values to DB --
793 -- format. Any entry values that were not specified are copied from the --
794 -- element entry being updated. --
795 -- NB. all entry values specified are validated ! --
796 ------------------------------------------------------------------------------
797 --
798 -- Overloaded version with Element Entry developer flex
799 --
800 --
801 procedure update_element_entry
802 (
803 --
804 -- Update Mode
805 --
806 p_dt_update_mode varchar2 default null,
807 --
808 -- Date on which change is taking place
809 --
810 p_session_date date,
811 --
812 -- Check to see if the entry is being updated
813 --
814 p_check_for_update varchar2 default 'N',
815 --
816 -- Element Entry Table
817 --
818 p_element_entry_id number,
819 p_cost_allocation_keyflex_id number default hr_api.g_number,
820 p_updating_action_id number default hr_api.g_number,
821 p_updating_action_type varchar2 default hr_api.g_varchar2,
822 p_original_entry_id number default hr_api.g_number,
823 p_creator_type varchar2 default hr_api.g_varchar2,
824 p_comment_id number default hr_api.g_number,
825 p_creator_id number default hr_api.g_number,
826 p_reason varchar2 default hr_api.g_varchar2,
827 p_subpriority number default hr_api.g_number,
828 p_date_earned date default hr_api.g_date,
829 p_personal_payment_method_id number default hr_api.g_number,
830 p_attribute_category varchar2 default hr_api.g_varchar2,
831 p_attribute1 varchar2 default hr_api.g_varchar2,
832 p_attribute2 varchar2 default hr_api.g_varchar2,
833 p_attribute3 varchar2 default hr_api.g_varchar2,
834 p_attribute4 varchar2 default hr_api.g_varchar2,
835 p_attribute5 varchar2 default hr_api.g_varchar2,
836 p_attribute6 varchar2 default hr_api.g_varchar2,
837 p_attribute7 varchar2 default hr_api.g_varchar2,
838 p_attribute8 varchar2 default hr_api.g_varchar2,
839 p_attribute9 varchar2 default hr_api.g_varchar2,
840 p_attribute10 varchar2 default hr_api.g_varchar2,
841 p_attribute11 varchar2 default hr_api.g_varchar2,
842 p_attribute12 varchar2 default hr_api.g_varchar2,
843 p_attribute13 varchar2 default hr_api.g_varchar2,
844 p_attribute14 varchar2 default hr_api.g_varchar2,
845 p_attribute15 varchar2 default hr_api.g_varchar2,
846 p_attribute16 varchar2 default hr_api.g_varchar2,
847 p_attribute17 varchar2 default hr_api.g_varchar2,
848 p_attribute18 varchar2 default hr_api.g_varchar2,
849 p_attribute19 varchar2 default hr_api.g_varchar2,
850 p_attribute20 varchar2 default hr_api.g_varchar2,
851 --
852 -- Element Entry Values Table
853 --
854 p_num_entry_values number,
855 p_input_value_id_tbl hr_entry.number_table,
856 p_entry_value_tbl hr_entry.varchar2_table,
857 --
858 -- Developer Descriptive Flex
859 --
860 p_entry_information_category varchar2 ,
861 p_entry_information1 varchar2 default hr_api.g_varchar2,
862 p_entry_information2 varchar2 default hr_api.g_varchar2,
863 p_entry_information3 varchar2 default hr_api.g_varchar2,
864 p_entry_information4 varchar2 default hr_api.g_varchar2,
865 p_entry_information5 varchar2 default hr_api.g_varchar2,
866 p_entry_information6 varchar2 default hr_api.g_varchar2,
867 p_entry_information7 varchar2 default hr_api.g_varchar2,
868 p_entry_information8 varchar2 default hr_api.g_varchar2,
869 p_entry_information9 varchar2 default hr_api.g_varchar2,
870 p_entry_information10 varchar2 default hr_api.g_varchar2,
871 p_entry_information11 varchar2 default hr_api.g_varchar2,
872 p_entry_information12 varchar2 default hr_api.g_varchar2,
873 p_entry_information13 varchar2 default hr_api.g_varchar2,
874 p_entry_information14 varchar2 default hr_api.g_varchar2,
875 p_entry_information15 varchar2 default hr_api.g_varchar2,
876 p_entry_information16 varchar2 default hr_api.g_varchar2,
877 p_entry_information17 varchar2 default hr_api.g_varchar2,
878 p_entry_information18 varchar2 default hr_api.g_varchar2,
879 p_entry_information19 varchar2 default hr_api.g_varchar2,
880 p_entry_information20 varchar2 default hr_api.g_varchar2,
881 p_entry_information21 varchar2 default hr_api.g_varchar2,
882 p_entry_information22 varchar2 default hr_api.g_varchar2,
883 p_entry_information23 varchar2 default hr_api.g_varchar2,
884 p_entry_information24 varchar2 default hr_api.g_varchar2,
885 p_entry_information25 varchar2 default hr_api.g_varchar2,
886 p_entry_information26 varchar2 default hr_api.g_varchar2,
887 p_entry_information27 varchar2 default hr_api.g_varchar2,
888 p_entry_information28 varchar2 default hr_api.g_varchar2,
889 p_entry_information29 varchar2 default hr_api.g_varchar2,
890 p_entry_information30 varchar2 default hr_api.g_varchar2,
891 p_override_user_ent_chk varchar2 default 'N'
892 );
893 --
894 -- --
895 --
896 ------------------------------------------------------------------------------
897 -- NAME --
898 -- hr_entry_api.update_element_entry --
899 -- --
900 -- DESCRIPTION --
901 -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
902 -- entry values passed as parameters. It converts the entry values to DB --
903 -- format. Any entry values that were not specified are copied from the --
904 -- element entry being updated. --
905 -- NB. all entry values specified are validated ! --
906 ------------------------------------------------------------------------------
907 --
908 -- Overloaded version with Element Entry developer flex
909 --
910 --
911 procedure update_element_entry
912 (
913 --
914 -- Update Mode
915 --
916 p_dt_update_mode varchar2 default null,
917 --
918 -- Date on which change is taking place
919 --
920 p_session_date date,
921 --
922 -- Check to see if the entry is being updated
923 --
924 p_check_for_update varchar2 default 'N',
925 --
926 -- Element Entry Table
927 --
928 p_element_entry_id number,
929 p_cost_allocation_keyflex_id number default hr_api.g_number,
930 p_updating_action_id number default hr_api.g_number,
931 p_updating_action_type varchar2 default hr_api.g_varchar2,
932 p_original_entry_id number default hr_api.g_number,
933 p_creator_type varchar2 default hr_api.g_varchar2,
934 p_comment_id number default hr_api.g_number,
935 p_creator_id number default hr_api.g_number,
936 p_reason varchar2 default hr_api.g_varchar2,
937 p_subpriority number default hr_api.g_number,
938 p_date_earned date default hr_api.g_date,
939 p_personal_payment_method_id number default hr_api.g_number,
940 p_attribute_category varchar2 default hr_api.g_varchar2,
941 p_attribute1 varchar2 default hr_api.g_varchar2,
942 p_attribute2 varchar2 default hr_api.g_varchar2,
943 p_attribute3 varchar2 default hr_api.g_varchar2,
944 p_attribute4 varchar2 default hr_api.g_varchar2,
945 p_attribute5 varchar2 default hr_api.g_varchar2,
946 p_attribute6 varchar2 default hr_api.g_varchar2,
947 p_attribute7 varchar2 default hr_api.g_varchar2,
948 p_attribute8 varchar2 default hr_api.g_varchar2,
949 p_attribute9 varchar2 default hr_api.g_varchar2,
950 p_attribute10 varchar2 default hr_api.g_varchar2,
951 p_attribute11 varchar2 default hr_api.g_varchar2,
952 p_attribute12 varchar2 default hr_api.g_varchar2,
953 p_attribute13 varchar2 default hr_api.g_varchar2,
954 p_attribute14 varchar2 default hr_api.g_varchar2,
955 p_attribute15 varchar2 default hr_api.g_varchar2,
956 p_attribute16 varchar2 default hr_api.g_varchar2,
957 p_attribute17 varchar2 default hr_api.g_varchar2,
958 p_attribute18 varchar2 default hr_api.g_varchar2,
959 p_attribute19 varchar2 default hr_api.g_varchar2,
960 p_attribute20 varchar2 default hr_api.g_varchar2,
961 --
962 -- Element Entry Values Table
963 --
964 p_input_value_id1 number default null,
965 p_input_value_id2 number default null,
966 p_input_value_id3 number default null,
967 p_input_value_id4 number default null,
968 p_input_value_id5 number default null,
969 p_input_value_id6 number default null,
970 p_input_value_id7 number default null,
971 p_input_value_id8 number default null,
972 p_input_value_id9 number default null,
973 p_input_value_id10 number default null,
974 p_input_value_id11 number default null,
975 p_input_value_id12 number default null,
976 p_input_value_id13 number default null,
977 p_input_value_id14 number default null,
978 p_input_value_id15 number default null,
979 p_entry_value1 varchar2 default null,
980 p_entry_value2 varchar2 default null,
981 p_entry_value3 varchar2 default null,
982 p_entry_value4 varchar2 default null,
983 p_entry_value5 varchar2 default null,
984 p_entry_value6 varchar2 default null,
985 p_entry_value7 varchar2 default null,
986 p_entry_value8 varchar2 default null,
987 p_entry_value9 varchar2 default null,
988 p_entry_value10 varchar2 default null,
989 p_entry_value11 varchar2 default null,
990 p_entry_value12 varchar2 default null,
991 p_entry_value13 varchar2 default null,
992 p_entry_value14 varchar2 default null,
993 p_entry_value15 varchar2 default null,
994 --
995 -- Developer Descriptive Flex
996 --
997 p_entry_information_category varchar2 ,
998 p_entry_information1 varchar2 default hr_api.g_varchar2,
999 p_entry_information2 varchar2 default hr_api.g_varchar2,
1000 p_entry_information3 varchar2 default hr_api.g_varchar2,
1001 p_entry_information4 varchar2 default hr_api.g_varchar2,
1002 p_entry_information5 varchar2 default hr_api.g_varchar2,
1003 p_entry_information6 varchar2 default hr_api.g_varchar2,
1004 p_entry_information7 varchar2 default hr_api.g_varchar2,
1005 p_entry_information8 varchar2 default hr_api.g_varchar2,
1006 p_entry_information9 varchar2 default hr_api.g_varchar2,
1007 p_entry_information10 varchar2 default hr_api.g_varchar2,
1008 p_entry_information11 varchar2 default hr_api.g_varchar2,
1009 p_entry_information12 varchar2 default hr_api.g_varchar2,
1010 p_entry_information13 varchar2 default hr_api.g_varchar2,
1011 p_entry_information14 varchar2 default hr_api.g_varchar2,
1012 p_entry_information15 varchar2 default hr_api.g_varchar2,
1013 p_entry_information16 varchar2 default hr_api.g_varchar2,
1014 p_entry_information17 varchar2 default hr_api.g_varchar2,
1015 p_entry_information18 varchar2 default hr_api.g_varchar2,
1016 p_entry_information19 varchar2 default hr_api.g_varchar2,
1017 p_entry_information20 varchar2 default hr_api.g_varchar2,
1018 p_entry_information21 varchar2 default hr_api.g_varchar2,
1019 p_entry_information22 varchar2 default hr_api.g_varchar2,
1020 p_entry_information23 varchar2 default hr_api.g_varchar2,
1021 p_entry_information24 varchar2 default hr_api.g_varchar2,
1022 p_entry_information25 varchar2 default hr_api.g_varchar2,
1023 p_entry_information26 varchar2 default hr_api.g_varchar2,
1024 p_entry_information27 varchar2 default hr_api.g_varchar2,
1025 p_entry_information28 varchar2 default hr_api.g_varchar2,
1026 p_entry_information29 varchar2 default hr_api.g_varchar2,
1027 p_entry_information30 varchar2 default hr_api.g_varchar2,
1028 p_override_user_ent_chk varchar2 default 'N'
1029 );
1030 --
1031 ------------------------------------------------------------------------------
1032 -- NAME --
1033 -- hr_entry_api.delete_element_entry --
1034 -- --
1035 -- DESCRIPTION --
1036 -- Deletes an element entry providing full validation. --
1037 ------------------------------------------------------------------------------
1038 --
1039 procedure delete_element_entry
1040 (
1041 --
1042 -- Delete Mode
1043 --
1044 p_dt_delete_mode varchar2,
1045 --
1046 -- Date on which change is taking place
1047 --
1048 p_session_date date,
1049 --
1050 -- Element Entry Table
1051 --
1052 p_element_entry_id number
1053 );
1054 --
1055 --
1056 end hr_entry_api;