[Home] [Help]
PACKAGE BODY: APPS.PAY_DYT_ELEMENT_ENTRIES_PKG
Source
1 package body PAY_DYT_ELEMENT_ENTRIES_PKG
2 IS
3
4 --
5 /*
6 ==================================================
7 This is a dynamically generated database package
8 containing code to support the use of dynamic
9 triggers.
10
11 Preference of package Vs dbms triggers supporting
12 dyn' triggers is made via the dated table form.
13 .
14 This code will be called implicitly by table rhi
15 and explictly
16 from non-API packages that maintain
17 data on the relevant table.
18 ==================================================
19 ** DO NOT CHANGE MANUALLY **
20 --------------------------------------------------
21
22 Package Name: PAY_DYT_ELEMENT_ENTRIES_PKG
23 Base Table: PAY_ELEMENT_ENTRIES_F
24 Date: 30/03/2009 04:53
25 ==================================================
26 */
27
28 --
29
30 /*
31 ================================================
32 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
33 WITH CODE REPRESENTING A DYNAMIC TRIGGER
34 ================================================
35 ** DO NOT CHANGE MANUALLY **
36
37 ------------------------------------------------
38 NAME: PAY_ELEMENT_ENTRIES_F_ARU_ARU
39 TABLE: PAY_ELEMENT_ENTRIES_F
40 ACTION: UPDATE
41 GENERATED DATE: 30/03/2009 04:53
42 DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON UPDATE
43 ELEMENT ENTRY
44 FULL TRIGGER NAME: PAY_ELEMENT_ENTRIES_F_ARU
45 ================================================
46 */
47 --
48 PROCEDURE PAY_ELEMENT_ENTRIES_F_ARU_ARU
49 (
50 P_NEW_ATTRIBUTE1 IN VARCHAR2
51 ,P_NEW_ATTRIBUTE10
52 IN VARCHAR2
53 ,P_NEW_ATTRIBUTE11 IN VARCHAR2
54 ,P_NEW_ATTRIBUTE12 IN VARCHAR2
55 ,P_NEW_ATTRIBUTE13 IN VARCHAR2
56 ,P_NEW_ATTRIBUTE14 IN VARCHAR2
57
58 ,P_NEW_ATTRIBUTE15 IN VARCHAR2
59 ,P_NEW_ATTRIBUTE16 IN VARCHAR2
60 ,P_NEW_ATTRIBUTE17 IN VARCHAR2
61 ,P_NEW_ATTRIBUTE18 IN VARCHAR2
62 ,P_NEW_ATTRIBUTE19
63 IN VARCHAR2
64 ,P_NEW_ATTRIBUTE2 IN VARCHAR2
65 ,P_NEW_ATTRIBUTE20 IN VARCHAR2
66 ,P_NEW_ATTRIBUTE3 IN VARCHAR2
67 ,P_NEW_ATTRIBUTE4 IN
68 VARCHAR2
69 ,P_NEW_ATTRIBUTE5 IN VARCHAR2
70 ,P_NEW_ATTRIBUTE6 IN VARCHAR2
71 ,P_NEW_ATTRIBUTE7 IN VARCHAR2
72 ,P_NEW_ATTRIBUTE8 IN VARCHAR2
73
74 ,P_NEW_ATTRIBUTE9 IN VARCHAR2
75 ,P_NEW_ATTRIBUTE_CATEGORY IN VARCHAR2
76 ,P_NEW_BALANCE_ADJ_COST_FLAG IN VARCHAR2
77 ,P_NEW_COMMENTS IN VARCHAR2
78 ,P_NEW_COMMENT_ID
79 IN NUMBER
80 ,P_NEW_COST_ALLOCATION_KEYFLEX_ IN NUMBER
81 ,P_NEW_CREATOR_ID IN NUMBER
82 ,P_NEW_CREATOR_TYPE IN VARCHAR2
83 ,P_NEW_DATE_EARNED IN DATE
84
85 ,P_NEW_EFFECTIVE_END_DATE IN DATE
86 ,P_NEW_EFFECTIVE_START_DATE IN DATE
87 ,P_NEW_ELEMENT_ENTRY_ID IN NUMBER
88 ,P_NEW_ENTRY_INFORMATION1 IN VARCHAR2
89 ,P_NEW_ENTRY_INFORMATION10
90 IN VARCHAR2
91 ,P_NEW_ENTRY_INFORMATION11 IN VARCHAR2
92 ,P_NEW_ENTRY_INFORMATION12 IN VARCHAR2
93 ,P_NEW_ENTRY_INFORMATION13 IN VARCHAR2
94 ,P_NEW_ENTRY_INFORMATION14 IN VARCHAR2
95
96 ,P_NEW_ENTRY_INFORMATION15 IN VARCHAR2
97 ,P_NEW_ENTRY_INFORMATION16 IN VARCHAR2
98 ,P_NEW_ENTRY_INFORMATION17 IN VARCHAR2
99 ,P_NEW_ENTRY_INFORMATION18 IN VARCHAR2
100 ,P_NEW_ENTRY_INFORMATION19
101 IN VARCHAR2
102 ,P_NEW_ENTRY_INFORMATION2 IN VARCHAR2
103 ,P_NEW_ENTRY_INFORMATION20 IN VARCHAR2
104 ,P_NEW_ENTRY_INFORMATION21 IN VARCHAR2
105 ,P_NEW_ENTRY_INFORMATION22 IN
106 VARCHAR2
107 ,P_NEW_ENTRY_INFORMATION23 IN VARCHAR2
108 ,P_NEW_ENTRY_INFORMATION24 IN VARCHAR2
109 ,P_NEW_ENTRY_INFORMATION25 IN VARCHAR2
110 ,P_NEW_ENTRY_INFORMATION26 IN VARCHAR2
111
112 ,P_NEW_ENTRY_INFORMATION27 IN VARCHAR2
113 ,P_NEW_ENTRY_INFORMATION28 IN VARCHAR2
114 ,P_NEW_ENTRY_INFORMATION29 IN VARCHAR2
115 ,P_NEW_ENTRY_INFORMATION3 IN VARCHAR2
116 ,P_NEW_ENTRY_INFORMATION30
117 IN VARCHAR2
118 ,P_NEW_ENTRY_INFORMATION4 IN VARCHAR2
119 ,P_NEW_ENTRY_INFORMATION5 IN VARCHAR2
120 ,P_NEW_ENTRY_INFORMATION6 IN VARCHAR2
121 ,P_NEW_ENTRY_INFORMATION7 IN
122 VARCHAR2
123 ,P_NEW_ENTRY_INFORMATION8 IN VARCHAR2
124 ,P_NEW_ENTRY_INFORMATION9 IN VARCHAR2
125 ,P_NEW_ENTRY_INFORMATION_CATEGO IN VARCHAR2
126 ,P_NEW_ENTRY_TYPE IN VARCHAR2
127
128 ,P_NEW_OBJECT_VERSION_NUMBER IN NUMBER
129 ,P_NEW_ORIGINAL_ENTRY_ID IN NUMBER
130 ,P_NEW_PERSONAL_PAYMENT_METHOD_ IN NUMBER
131 ,P_NEW_REASON IN VARCHAR2
132 ,P_NEW_SOURCE_ID
133 IN NUMBER
134 ,P_NEW_SUBPRIORITY IN NUMBER
135 ,P_NEW_TARGET_ENTRY_ID IN NUMBER
136 ,P_NEW_UPDATING_ACTION_ID IN NUMBER
137 ,P_NEW_UPDATING_ACTION_TYPE IN VARCHAR2
138
139 ,P_OLD_ASSIGNMENT_ID IN NUMBER
140 ,P_OLD_ATTRIBUTE1 IN VARCHAR2
141 ,P_OLD_ATTRIBUTE10 IN VARCHAR2
142 ,P_OLD_ATTRIBUTE11 IN VARCHAR2
143 ,P_OLD_ATTRIBUTE12
144 IN VARCHAR2
145 ,P_OLD_ATTRIBUTE13 IN VARCHAR2
146 ,P_OLD_ATTRIBUTE14 IN VARCHAR2
147 ,P_OLD_ATTRIBUTE15 IN VARCHAR2
148 ,P_OLD_ATTRIBUTE16 IN VARCHAR2
149
150 ,P_OLD_ATTRIBUTE17 IN VARCHAR2
151 ,P_OLD_ATTRIBUTE18 IN VARCHAR2
152 ,P_OLD_ATTRIBUTE19 IN VARCHAR2
153 ,P_OLD_ATTRIBUTE2 IN VARCHAR2
154 ,P_OLD_ATTRIBUTE20
155 IN VARCHAR2
156 ,P_OLD_ATTRIBUTE3 IN VARCHAR2
157 ,P_OLD_ATTRIBUTE4 IN VARCHAR2
158 ,P_OLD_ATTRIBUTE5 IN VARCHAR2
159 ,P_OLD_ATTRIBUTE6 IN
160 VARCHAR2
161 ,P_OLD_ATTRIBUTE7 IN VARCHAR2
162 ,P_OLD_ATTRIBUTE8 IN VARCHAR2
163 ,P_OLD_ATTRIBUTE9 IN VARCHAR2
164 ,P_OLD_ATTRIBUTE_CATEGORY IN VARCHAR2
165
166 ,P_OLD_BALANCE_ADJ_COST_FLAG IN VARCHAR2
167 ,P_OLD_COMMENTS IN VARCHAR2
168 ,P_OLD_COMMENT_ID IN NUMBER
169 ,P_OLD_COST_ALLOCATION_KEYFLEX_ IN NUMBER
170 ,P_OLD_CREATOR_ID
171 IN NUMBER
172 ,P_OLD_CREATOR_TYPE IN VARCHAR2
173 ,P_OLD_DATE_EARNED IN DATE
174 ,P_OLD_EFFECTIVE_END_DATE IN DATE
175 ,P_OLD_EFFECTIVE_START_DATE IN DATE
176
177 ,P_OLD_ELEMENT_LINK_ID IN NUMBER
178 ,P_OLD_ELEMENT_TYPE_ID IN NUMBER
179 ,P_OLD_ENTRY_INFORMATION1 IN VARCHAR2
180 ,P_OLD_ENTRY_INFORMATION10 IN VARCHAR2
181 ,P_OLD_ENTRY_INFORMATION11
182 IN VARCHAR2
183 ,P_OLD_ENTRY_INFORMATION12 IN VARCHAR2
184 ,P_OLD_ENTRY_INFORMATION13 IN VARCHAR2
185 ,P_OLD_ENTRY_INFORMATION14 IN VARCHAR2
186 ,P_OLD_ENTRY_INFORMATION15 IN VARCHAR2
187
188 ,P_OLD_ENTRY_INFORMATION16 IN VARCHAR2
189 ,P_OLD_ENTRY_INFORMATION17 IN VARCHAR2
190 ,P_OLD_ENTRY_INFORMATION18 IN VARCHAR2
191 ,P_OLD_ENTRY_INFORMATION19 IN VARCHAR2
192 ,P_OLD_ENTRY_INFORMATION2
193 IN VARCHAR2
194 ,P_OLD_ENTRY_INFORMATION20 IN VARCHAR2
195 ,P_OLD_ENTRY_INFORMATION21 IN VARCHAR2
196 ,P_OLD_ENTRY_INFORMATION22 IN VARCHAR2
197 ,P_OLD_ENTRY_INFORMATION23 IN
198 VARCHAR2
199 ,P_OLD_ENTRY_INFORMATION24 IN VARCHAR2
200 ,P_OLD_ENTRY_INFORMATION25 IN VARCHAR2
201 ,P_OLD_ENTRY_INFORMATION26 IN VARCHAR2
202 ,P_OLD_ENTRY_INFORMATION27 IN VARCHAR2
203
204 ,P_OLD_ENTRY_INFORMATION28 IN VARCHAR2
205 ,P_OLD_ENTRY_INFORMATION29 IN VARCHAR2
206 ,P_OLD_ENTRY_INFORMATION3 IN VARCHAR2
207 ,P_OLD_ENTRY_INFORMATION30 IN VARCHAR2
208 ,P_OLD_ENTRY_INFORMATION4
209 IN VARCHAR2
210 ,P_OLD_ENTRY_INFORMATION5 IN VARCHAR2
211 ,P_OLD_ENTRY_INFORMATION6 IN VARCHAR2
212 ,P_OLD_ENTRY_INFORMATION7 IN VARCHAR2
213 ,P_OLD_ENTRY_INFORMATION8 IN
214 VARCHAR2
215 ,P_OLD_ENTRY_INFORMATION9 IN VARCHAR2
216 ,P_OLD_ENTRY_INFORMATION_CATEGO IN VARCHAR2
217 ,P_OLD_ENTRY_TYPE IN VARCHAR2
218 ,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
219
220 ,P_OLD_ORIGINAL_ENTRY_ID IN NUMBER
221 ,P_OLD_PERSONAL_PAYMENT_METHOD_ IN NUMBER
222 ,P_OLD_REASON IN VARCHAR2
223 ,P_OLD_SOURCE_ID IN NUMBER
224 ,P_OLD_SUBPRIORITY
225 IN NUMBER
226 ,P_OLD_TARGET_ENTRY_ID IN NUMBER
227 ,P_OLD_UPDATING_ACTION_ID IN NUMBER
228 ,P_OLD_UPDATING_ACTION_TYPE IN VARCHAR2
229 ) IS
230
231 --
232 /* LOCAL VARIABLE DECLARATIONS */
233
234 L_BUSINESS_GROUP_ID NUMBER;
235 L_LEGISLATION_CODE VARCHAR2(10);
236 BEGIN
237 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_ELEMENT_ENTRIES_F_ARU');
238 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
239
240 RETURN;
241 END IF;
242 /* INITIALISING LOCAL VARIABLES */
243 L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
244 P_STATEMENT => 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID =
245 '||P_OLD_ASSIGNMENT_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
246 );
247 --
248 L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
249
250 P_BG_ID => L_BUSINESS_GROUP_ID
251 );
252 --
253 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
254 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
255 P_EVENT_ID => 41,
256 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
257
258 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
259 P_PAYROLL_ID => NULL
260 ) THEN
261 RETURN;
262 END IF;
263 --
264 /* GLOBAL COMPONENT CALLS */
265 --
266 /* LEGISLATION SPECIFIC COMPONENT CALLS */
267 --
268 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
269 --
270
271 /* PAYROLL SPECIFIC COMPONENT CALLS */
272 --
273 EXCEPTION
274 WHEN OTHERS THEN
275 HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARU_ARU',ABS(SQLCODE));
276 RAISE;
277 --
278 END PAY_ELEMENT_ENTRIES_F_ARU_ARU;
279
280 --
281
282 /*
283 ================================================
284 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
285 WITH CODE REPRESENTING A DYNAMIC TRIGGER
286 ================================================
287 ** DO NOT CHANGE MANUALLY **
288
289 ------------------------------------------------
290 NAME: PAY_ELEMENT_ENTRIES_F_ARD_ARD
291 TABLE: PAY_ELEMENT_ENTRIES_F
292 ACTION: DELETE
293 GENERATED DATE: 30/03/2009 04:53
294 DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON DELETION OF
295 ELEMENT ENTRY
296 FULL TRIGGER NAME: PAY_ELEMENT_ENTRIES_F_ARD
297 ================================================
298 */
299 --
300 PROCEDURE PAY_ELEMENT_ENTRIES_F_ARD_ARD
301 (
302 P_NEW_EFFECTIVE_END_DATE IN DATE
303 ,P_NEW_EFFECTIVE_START_DATE
304 IN DATE
305 ,P_NEW_ELEMENT_ENTRY_ID IN NUMBER
306 ,P_OLD_ASSIGNMENT_ID IN NUMBER
307 ,P_OLD_ATTRIBUTE1 IN VARCHAR2
308 ,P_OLD_ATTRIBUTE10 IN VARCHAR2
309
310 ,P_OLD_ATTRIBUTE11 IN VARCHAR2
311 ,P_OLD_ATTRIBUTE12 IN VARCHAR2
312 ,P_OLD_ATTRIBUTE13 IN VARCHAR2
313 ,P_OLD_ATTRIBUTE14 IN VARCHAR2
314 ,P_OLD_ATTRIBUTE15
315 IN VARCHAR2
316 ,P_OLD_ATTRIBUTE16 IN VARCHAR2
317 ,P_OLD_ATTRIBUTE17 IN VARCHAR2
318 ,P_OLD_ATTRIBUTE18 IN VARCHAR2
319 ,P_OLD_ATTRIBUTE19 IN
320 VARCHAR2
321 ,P_OLD_ATTRIBUTE2 IN VARCHAR2
322 ,P_OLD_ATTRIBUTE20 IN VARCHAR2
323 ,P_OLD_ATTRIBUTE3 IN VARCHAR2
324 ,P_OLD_ATTRIBUTE4 IN VARCHAR2
325
326 ,P_OLD_ATTRIBUTE5 IN VARCHAR2
327 ,P_OLD_ATTRIBUTE6 IN VARCHAR2
328 ,P_OLD_ATTRIBUTE7 IN VARCHAR2
329 ,P_OLD_ATTRIBUTE8 IN VARCHAR2
330 ,P_OLD_ATTRIBUTE9
331 IN VARCHAR2
332 ,P_OLD_ATTRIBUTE_CATEGORY IN VARCHAR2
333 ,P_OLD_BALANCE_ADJ_COST_FLAG IN VARCHAR2
334 ,P_OLD_COMMENTS IN VARCHAR2
335 ,P_OLD_COMMENT_ID IN NUMBER
336
337 ,P_OLD_COST_ALLOCATION_KEYFLEX_ IN NUMBER
338 ,P_OLD_CREATOR_ID IN NUMBER
339 ,P_OLD_CREATOR_TYPE IN VARCHAR2
340 ,P_OLD_DATE_EARNED IN DATE
341 ,P_OLD_EFFECTIVE_END_DATE
342 IN DATE
343 ,P_OLD_EFFECTIVE_START_DATE IN DATE
344 ,P_OLD_ELEMENT_LINK_ID IN NUMBER
345 ,P_OLD_ELEMENT_TYPE_ID IN NUMBER
346 ,P_OLD_ENTRY_INFORMATION1 IN VARCHAR2
347
348 ,P_OLD_ENTRY_INFORMATION10 IN VARCHAR2
349 ,P_OLD_ENTRY_INFORMATION11 IN VARCHAR2
350 ,P_OLD_ENTRY_INFORMATION12 IN VARCHAR2
351 ,P_OLD_ENTRY_INFORMATION13 IN VARCHAR2
352 ,P_OLD_ENTRY_INFORMATION14
353 IN VARCHAR2
354 ,P_OLD_ENTRY_INFORMATION15 IN VARCHAR2
355 ,P_OLD_ENTRY_INFORMATION16 IN VARCHAR2
356 ,P_OLD_ENTRY_INFORMATION17 IN VARCHAR2
357 ,P_OLD_ENTRY_INFORMATION18 IN
358 VARCHAR2
359 ,P_OLD_ENTRY_INFORMATION19 IN VARCHAR2
360 ,P_OLD_ENTRY_INFORMATION2 IN VARCHAR2
361 ,P_OLD_ENTRY_INFORMATION20 IN VARCHAR2
362 ,P_OLD_ENTRY_INFORMATION21 IN VARCHAR2
363
364 ,P_OLD_ENTRY_INFORMATION22 IN VARCHAR2
365 ,P_OLD_ENTRY_INFORMATION23 IN VARCHAR2
366 ,P_OLD_ENTRY_INFORMATION24 IN VARCHAR2
367 ,P_OLD_ENTRY_INFORMATION25 IN VARCHAR2
368 ,P_OLD_ENTRY_INFORMATION26
369 IN VARCHAR2
370 ,P_OLD_ENTRY_INFORMATION27 IN VARCHAR2
371 ,P_OLD_ENTRY_INFORMATION28 IN VARCHAR2
372 ,P_OLD_ENTRY_INFORMATION29 IN VARCHAR2
373 ,P_OLD_ENTRY_INFORMATION3 IN
374 VARCHAR2
375 ,P_OLD_ENTRY_INFORMATION30 IN VARCHAR2
376 ,P_OLD_ENTRY_INFORMATION4 IN VARCHAR2
377 ,P_OLD_ENTRY_INFORMATION5 IN VARCHAR2
378 ,P_OLD_ENTRY_INFORMATION6 IN VARCHAR2
379
380 ,P_OLD_ENTRY_INFORMATION7 IN VARCHAR2
381 ,P_OLD_ENTRY_INFORMATION8 IN VARCHAR2
382 ,P_OLD_ENTRY_INFORMATION9 IN VARCHAR2
383 ,P_OLD_ENTRY_INFORMATION_CATEGO IN VARCHAR2
384 ,P_OLD_ENTRY_TYPE
385 IN VARCHAR2
386 ,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
387 ,P_OLD_ORIGINAL_ENTRY_ID IN NUMBER
388 ,P_OLD_PERSONAL_PAYMENT_METHOD_ IN NUMBER
389 ,P_OLD_REASON IN VARCHAR2
390
391 ,P_OLD_SOURCE_ID IN NUMBER
392 ,P_OLD_SUBPRIORITY IN NUMBER
393 ,P_OLD_TARGET_ENTRY_ID IN NUMBER
394 ,P_OLD_UPDATING_ACTION_ID IN NUMBER
395 ,P_OLD_UPDATING_ACTION_TYPE
396 IN VARCHAR2
397 ) IS
398
399 --
400 /* LOCAL VARIABLE DECLARATIONS */
401 L_BUSINESS_GROUP_ID NUMBER;
402 L_LEGISLATION_CODE VARCHAR2(10);
403 BEGIN
404 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER:
405 PAY_ELEMENT_ENTRIES_F_ARD');
406 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
407 RETURN;
408 END IF;
409 /* INITIALISING LOCAL VARIABLES */
410 L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
411 P_STATEMENT => 'SELECT
412 PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID = '||P_OLD_ASSIGNMENT_ID||' AND TO_DATE('''||TO_CHAR(P_OLD_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
413 );
414
415 --
416 L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
417 P_BG_ID => L_BUSINESS_GROUP_ID
418 );
419 --
420 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
421 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
422 P_EVENT_ID
423 => 39,
424 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
425 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
426 P_PAYROLL_ID => NULL
427 ) THEN
428 RETURN;
429 END IF;
430 --
431 /* GLOBAL COMPONENT CALLS */
432 --
433 /* LEGISLATION SPECIFIC COMPONENT CALLS */
434
435 --
436 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
437 --
438 /* PAYROLL SPECIFIC COMPONENT CALLS */
439 --
440 EXCEPTION
441 WHEN OTHERS THEN
442 HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARD_ARD',ABS(SQLCODE));
443 RAISE;
444 --
445 END
446 PAY_ELEMENT_ENTRIES_F_ARD_ARD;
447
448 --
449
450 /*
451 ================================================
452 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
453 WITH CODE REPRESENTING A DYNAMIC TRIGGER
454 ================================================
455 ** DO NOT CHANGE MANUALLY **
456
457 ------------------------------------------------
458 NAME: PAY_ELEMENT_ENTRIES_F_ARI_ARI
459 TABLE: PAY_ELEMENT_ENTRIES_F
460 ACTION: INSERT
461 GENERATED DATE: 30/03/2009 04:53
462 DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON INSERT OF
463 ELEMENT ENTRY
464 FULL TRIGGER NAME: PAY_ELEMENT_ENTRIES_F_ARI
465 ================================================
466 */
467 --
468 PROCEDURE PAY_ELEMENT_ENTRIES_F_ARI_ARI
469 (
470 P_NEW_ASSIGNMENT_ID IN NUMBER
471 ,P_NEW_ATTRIBUTE1
472 IN VARCHAR2
473 ,P_NEW_ATTRIBUTE10 IN VARCHAR2
474 ,P_NEW_ATTRIBUTE11 IN VARCHAR2
475 ,P_NEW_ATTRIBUTE12 IN VARCHAR2
476 ,P_NEW_ATTRIBUTE13 IN VARCHAR2
477
478 ,P_NEW_ATTRIBUTE14 IN VARCHAR2
479 ,P_NEW_ATTRIBUTE15 IN VARCHAR2
480 ,P_NEW_ATTRIBUTE16 IN VARCHAR2
481 ,P_NEW_ATTRIBUTE17 IN VARCHAR2
482 ,P_NEW_ATTRIBUTE18
483 IN VARCHAR2
484 ,P_NEW_ATTRIBUTE19 IN VARCHAR2
485 ,P_NEW_ATTRIBUTE2 IN VARCHAR2
486 ,P_NEW_ATTRIBUTE20 IN VARCHAR2
487 ,P_NEW_ATTRIBUTE3 IN
488 VARCHAR2
489 ,P_NEW_ATTRIBUTE4 IN VARCHAR2
490 ,P_NEW_ATTRIBUTE5 IN VARCHAR2
491 ,P_NEW_ATTRIBUTE6 IN VARCHAR2
492 ,P_NEW_ATTRIBUTE7 IN VARCHAR2
493
494 ,P_NEW_ATTRIBUTE8 IN VARCHAR2
495 ,P_NEW_ATTRIBUTE9 IN VARCHAR2
496 ,P_NEW_ATTRIBUTE_CATEGORY IN VARCHAR2
497 ,P_NEW_BALANCE_ADJ_COST_FLAG IN VARCHAR2
498 ,P_NEW_COMMENTS
499 IN VARCHAR2
500 ,P_NEW_COMMENT_ID IN NUMBER
501 ,P_NEW_COST_ALLOCATION_KEYFLEX_ IN NUMBER
502 ,P_NEW_CREATOR_ID IN NUMBER
503 ,P_NEW_CREATOR_TYPE IN VARCHAR2
504
505 ,P_NEW_DATE_EARNED IN DATE
506 ,P_NEW_EFFECTIVE_END_DATE IN DATE
507 ,P_NEW_EFFECTIVE_START_DATE IN DATE
508 ,P_NEW_ELEMENT_ENTRY_ID IN NUMBER
509 ,P_NEW_ELEMENT_LINK_ID
510 IN NUMBER
511 ,P_NEW_ELEMENT_TYPE_ID IN NUMBER
512 ,P_NEW_ENTRY_INFORMATION1 IN VARCHAR2
513 ,P_NEW_ENTRY_INFORMATION10 IN VARCHAR2
514 ,P_NEW_ENTRY_INFORMATION11 IN VARCHAR2
515
516 ,P_NEW_ENTRY_INFORMATION12 IN VARCHAR2
517 ,P_NEW_ENTRY_INFORMATION13 IN VARCHAR2
518 ,P_NEW_ENTRY_INFORMATION14 IN VARCHAR2
519 ,P_NEW_ENTRY_INFORMATION15 IN VARCHAR2
520 ,P_NEW_ENTRY_INFORMATION16
521 IN VARCHAR2
522 ,P_NEW_ENTRY_INFORMATION17 IN VARCHAR2
523 ,P_NEW_ENTRY_INFORMATION18 IN VARCHAR2
524 ,P_NEW_ENTRY_INFORMATION19 IN VARCHAR2
525 ,P_NEW_ENTRY_INFORMATION2 IN
526 VARCHAR2
527 ,P_NEW_ENTRY_INFORMATION20 IN VARCHAR2
528 ,P_NEW_ENTRY_INFORMATION21 IN VARCHAR2
529 ,P_NEW_ENTRY_INFORMATION22 IN VARCHAR2
530 ,P_NEW_ENTRY_INFORMATION23 IN VARCHAR2
531
532 ,P_NEW_ENTRY_INFORMATION24 IN VARCHAR2
533 ,P_NEW_ENTRY_INFORMATION25 IN VARCHAR2
534 ,P_NEW_ENTRY_INFORMATION26 IN VARCHAR2
535 ,P_NEW_ENTRY_INFORMATION27 IN VARCHAR2
536 ,P_NEW_ENTRY_INFORMATION28
537 IN VARCHAR2
538 ,P_NEW_ENTRY_INFORMATION29 IN VARCHAR2
539 ,P_NEW_ENTRY_INFORMATION3 IN VARCHAR2
540 ,P_NEW_ENTRY_INFORMATION30 IN VARCHAR2
541 ,P_NEW_ENTRY_INFORMATION4 IN
542 VARCHAR2
543 ,P_NEW_ENTRY_INFORMATION5 IN VARCHAR2
544 ,P_NEW_ENTRY_INFORMATION6 IN VARCHAR2
545 ,P_NEW_ENTRY_INFORMATION7 IN VARCHAR2
546 ,P_NEW_ENTRY_INFORMATION8 IN VARCHAR2
547
548 ,P_NEW_ENTRY_INFORMATION9 IN VARCHAR2
549 ,P_NEW_ENTRY_INFORMATION_CATEGO IN VARCHAR2
550 ,P_NEW_ENTRY_TYPE IN VARCHAR2
551 ,P_NEW_OBJECT_VERSION_NUMBER IN NUMBER
552 ,P_NEW_ORIGINAL_ENTRY_ID
553 IN NUMBER
554 ,P_NEW_PERSONAL_PAYMENT_METHOD_ IN NUMBER
555 ,P_NEW_REASON IN VARCHAR2
556 ,P_NEW_SOURCE_ID IN NUMBER
557 ,P_NEW_SUBPRIORITY IN NUMBER
558
559 ,P_NEW_TARGET_ENTRY_ID IN NUMBER
560 ,P_NEW_UPDATING_ACTION_ID IN NUMBER
561 ,P_NEW_UPDATING_ACTION_TYPE IN VARCHAR2
562 ) IS
563
564 --
565 /* LOCAL VARIABLE DECLARATIONS */
566 L_BUSINESS_GROUP_ID NUMBER;
567
568 L_LEGISLATION_CODE VARCHAR2(10);
569 BEGIN
570 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_ELEMENT_ENTRIES_F_ARI');
571 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
572 RETURN;
573 END IF;
574 /* INITIALISING LOCAL
575 VARIABLES */
576 L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
577 P_STATEMENT => 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID = '||P_NEW_ASSIGNMENT_ID||' AND
578 TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
579 );
580 --
581 L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
582 P_BG_ID
583 => L_BUSINESS_GROUP_ID
584 );
585 --
586 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
587 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
588 P_EVENT_ID => 40,
589 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
590 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
591
592 P_PAYROLL_ID => NULL
593 ) THEN
594 RETURN;
595 END IF;
596 --
597 /* GLOBAL COMPONENT CALLS */
598 --
599 /* LEGISLATION SPECIFIC COMPONENT CALLS */
600 --
601 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
602 --
603 /* PAYROLL SPECIFIC COMPONENT CALLS */
604 --
605
606 EXCEPTION
607 WHEN OTHERS THEN
608 HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARI_ARI',ABS(SQLCODE));
609 RAISE;
610 --
611 END PAY_ELEMENT_ENTRIES_F_ARI_ARI;
612
613 --
614
615 /*
616 ================================================
617 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
618 WITH CODE REPRESENTING A DYNAMIC TRIGGER
619 ================================================
620 ** DO NOT CHANGE MANUALLY **
621
622 ------------------------------------------------
623 NAME: PQP_PEE_LOG_ARI_ARI
624 TABLE: PAY_ELEMENT_ENTRIES_F
625 ACTION: INSERT
626 GENERATED DATE: 30/03/2009 04:53
627 DESCRIPTION: ALIEN ELEMENT ENTRY CHANGE LOG
628 FULL TRIGGER NAME:
629 PQP_PEE_LOG_ARI
630 ================================================
631 */
632 --
633 PROCEDURE PQP_PEE_LOG_ARI_ARI
634 (
635 P_NEW_ASSIGNMENT_ID IN NUMBER
636 ,P_NEW_ATTRIBUTE1 IN VARCHAR2
637 ,P_NEW_ATTRIBUTE10
638 IN VARCHAR2
639 ,P_NEW_ATTRIBUTE11 IN VARCHAR2
640 ,P_NEW_ATTRIBUTE12 IN VARCHAR2
641 ,P_NEW_ATTRIBUTE13 IN VARCHAR2
642 ,P_NEW_ATTRIBUTE14 IN VARCHAR2
643
644 ,P_NEW_ATTRIBUTE15 IN VARCHAR2
645 ,P_NEW_ATTRIBUTE16 IN VARCHAR2
646 ,P_NEW_ATTRIBUTE17 IN VARCHAR2
647 ,P_NEW_ATTRIBUTE18 IN VARCHAR2
648 ,P_NEW_ATTRIBUTE19
649 IN VARCHAR2
650 ,P_NEW_ATTRIBUTE2 IN VARCHAR2
651 ,P_NEW_ATTRIBUTE20 IN VARCHAR2
652 ,P_NEW_ATTRIBUTE3 IN VARCHAR2
653 ,P_NEW_ATTRIBUTE4 IN
654 VARCHAR2
655 ,P_NEW_ATTRIBUTE5 IN VARCHAR2
656 ,P_NEW_ATTRIBUTE6 IN VARCHAR2
657 ,P_NEW_ATTRIBUTE7 IN VARCHAR2
658 ,P_NEW_ATTRIBUTE8 IN VARCHAR2
659
660 ,P_NEW_ATTRIBUTE9 IN VARCHAR2
661 ,P_NEW_ATTRIBUTE_CATEGORY IN VARCHAR2
662 ,P_NEW_BALANCE_ADJ_COST_FLAG IN VARCHAR2
663 ,P_NEW_COMMENTS IN VARCHAR2
664 ,P_NEW_COMMENT_ID
665 IN NUMBER
666 ,P_NEW_COST_ALLOCATION_KEYFLEX_ IN NUMBER
667 ,P_NEW_CREATOR_ID IN NUMBER
668 ,P_NEW_CREATOR_TYPE IN VARCHAR2
669 ,P_NEW_DATE_EARNED IN DATE
670
671 ,P_NEW_EFFECTIVE_END_DATE IN DATE
672 ,P_NEW_EFFECTIVE_START_DATE IN DATE
673 ,P_NEW_ELEMENT_ENTRY_ID IN NUMBER
674 ,P_NEW_ELEMENT_LINK_ID IN NUMBER
675 ,P_NEW_ELEMENT_TYPE_ID
676 IN NUMBER
677 ,P_NEW_ENTRY_INFORMATION1 IN VARCHAR2
678 ,P_NEW_ENTRY_INFORMATION10 IN VARCHAR2
679 ,P_NEW_ENTRY_INFORMATION11 IN VARCHAR2
680 ,P_NEW_ENTRY_INFORMATION12 IN VARCHAR2
681
682 ,P_NEW_ENTRY_INFORMATION13 IN VARCHAR2
683 ,P_NEW_ENTRY_INFORMATION14 IN VARCHAR2
684 ,P_NEW_ENTRY_INFORMATION15 IN VARCHAR2
685 ,P_NEW_ENTRY_INFORMATION16 IN VARCHAR2
686 ,P_NEW_ENTRY_INFORMATION17
687 IN VARCHAR2
688 ,P_NEW_ENTRY_INFORMATION18 IN VARCHAR2
689 ,P_NEW_ENTRY_INFORMATION19 IN VARCHAR2
690 ,P_NEW_ENTRY_INFORMATION2 IN VARCHAR2
691 ,P_NEW_ENTRY_INFORMATION20 IN
692 VARCHAR2
693 ,P_NEW_ENTRY_INFORMATION21 IN VARCHAR2
694 ,P_NEW_ENTRY_INFORMATION22 IN VARCHAR2
695 ,P_NEW_ENTRY_INFORMATION23 IN VARCHAR2
696 ,P_NEW_ENTRY_INFORMATION24 IN VARCHAR2
697
698 ,P_NEW_ENTRY_INFORMATION25 IN VARCHAR2
699 ,P_NEW_ENTRY_INFORMATION26 IN VARCHAR2
700 ,P_NEW_ENTRY_INFORMATION27 IN VARCHAR2
701 ,P_NEW_ENTRY_INFORMATION28 IN VARCHAR2
702 ,P_NEW_ENTRY_INFORMATION29
703 IN VARCHAR2
704 ,P_NEW_ENTRY_INFORMATION3 IN VARCHAR2
705 ,P_NEW_ENTRY_INFORMATION30 IN VARCHAR2
706 ,P_NEW_ENTRY_INFORMATION4 IN VARCHAR2
707 ,P_NEW_ENTRY_INFORMATION5 IN
708 VARCHAR2
709 ,P_NEW_ENTRY_INFORMATION6 IN VARCHAR2
710 ,P_NEW_ENTRY_INFORMATION7 IN VARCHAR2
711 ,P_NEW_ENTRY_INFORMATION8 IN VARCHAR2
712 ,P_NEW_ENTRY_INFORMATION9 IN VARCHAR2
713
714 ,P_NEW_ENTRY_INFORMATION_CATEGO IN VARCHAR2
715 ,P_NEW_ENTRY_TYPE IN VARCHAR2
716 ,P_NEW_OBJECT_VERSION_NUMBER IN NUMBER
717 ,P_NEW_ORIGINAL_ENTRY_ID IN NUMBER
718
719 ,P_NEW_PERSONAL_PAYMENT_METHOD_ IN NUMBER
720 ,P_NEW_REASON IN VARCHAR2
721 ,P_NEW_SOURCE_ID IN NUMBER
722 ,P_NEW_SUBPRIORITY IN NUMBER
723 ,P_NEW_TARGET_ENTRY_ID
724 IN NUMBER
725 ,P_NEW_UPDATING_ACTION_ID IN NUMBER
726 ,P_NEW_UPDATING_ACTION_TYPE IN VARCHAR2
727 ) IS
728
729 --
730 /* LOCAL VARIABLE DECLARATIONS */
731 L_ASSIGNMENT_ID NUMBER;
732 L_BUSINESS_GROUP_ID
733 NUMBER;
734 L_EFFECTIVE_START_DATE DATE;
735 L_LEGISLATION_CODE VARCHAR2(30);
736 BEGIN
737 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_PEE_LOG_ARI');
738 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
739 RETURN;
740
741 END IF;
742 /* INITIALISING LOCAL VARIABLES */
743 L_EFFECTIVE_START_DATE := P_NEW_EFFECTIVE_START_DATE;
744 --
745 L_ASSIGNMENT_ID := P_NEW_ASSIGNMENT_ID;
746 --
747 L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
748 P_STATEMENT =>
749 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID = '||P_NEW_ASSIGNMENT_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD/MM/YYYY')||''',''DD/MM/YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
750
751 );
752 --
753 L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
754 P_BG_ID => L_BUSINESS_GROUP_ID
755 );
756 --
757 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
758 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
759 P_EVENT_ID
760 => 79,
761 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
762 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
763 P_PAYROLL_ID => NULL
764 ) THEN
765 RETURN;
766 END IF;
767 --
768 /* GLOBAL COMPONENT CALLS */
769 --
770 /* LEGISLATION SPECIFIC COMPONENT CALLS
771 */
772 IF L_LEGISLATION_CODE = 'US' THEN
773 PQP_LOG_ALIEN_DATA_CHANGES.ALIEN_ELEMENT_CHECK(
774 P_ASSIGNMENT_ID => P_NEW_ASSIGNMENT_ID,
775 P_EFFECTIVE_DATE => P_NEW_EFFECTIVE_START_DATE,
776 P_ELEMENT_LINK_ID
777 => P_NEW_ELEMENT_LINK_ID
778 );
779 END IF;
780 --
781 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
782 --
783 /* PAYROLL SPECIFIC COMPONENT CALLS */
784 --
785 EXCEPTION
786 WHEN OTHERS THEN
787 HR_UTILITY.SET_LOCATION('PQP_PEE_LOG_ARI_ARI',ABS(SQLCODE));
788 RAISE;
789
790 --
791 END PQP_PEE_LOG_ARI_ARI;
792
793 --
794
795 /*
796 ================================================
797 This is a dynamically generated procedure.
798 Will be called by API.
799 ================================================
800 ** DO NOT CHANGE MANUALLY **
801
802 ------------------------------------------------
803 Name: AFTER_INSERT
804 Table: PAY_ELEMENT_ENTRIES_F
805 Action: INSERT
806 Generated Date: 30/03/2009 04:53
807 Description: Called as part of INSERT process
808
809 ================================================
810 */
811
812 --
813 PROCEDURE AFTER_INSERT
814 (
815 P_EFFECTIVE_DATE in DATE
816 ,P_VALIDATION_START_DATE in DATE
817 ,P_VALIDATION_END_DATE in DATE
818
819 ,P_ELEMENT_ENTRY_ID in NUMBER
820 ,P_EFFECTIVE_START_DATE in DATE
821 ,P_EFFECTIVE_END_DATE in DATE
822 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
823 ,P_ASSIGNMENT_ID
824 in NUMBER
825 ,P_UPDATING_ACTION_ID in NUMBER
826 ,P_UPDATING_ACTION_TYPE in VARCHAR2
827 ,P_ELEMENT_LINK_ID in NUMBER
828 ,P_ORIGINAL_ENTRY_ID in NUMBER
829 ,P_CREATOR_TYPE
830 in VARCHAR2
831 ,P_ENTRY_TYPE in VARCHAR2
832 ,P_COMMENT_ID in NUMBER
833 ,P_COMMENTS in VARCHAR2
834 ,P_CREATOR_ID
835 in NUMBER
836 ,P_REASON in VARCHAR2
837 ,P_TARGET_ENTRY_ID in NUMBER
838 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
839 ,P_ATTRIBUTE1 in VARCHAR2
840 ,P_ATTRIBUTE2
841 in VARCHAR2
842 ,P_ATTRIBUTE3 in VARCHAR2
843 ,P_ATTRIBUTE4 in VARCHAR2
844 ,P_ATTRIBUTE5 in VARCHAR2
845 ,P_ATTRIBUTE6
846 in VARCHAR2
847 ,P_ATTRIBUTE7 in VARCHAR2
848 ,P_ATTRIBUTE8 in VARCHAR2
849 ,P_ATTRIBUTE9 in VARCHAR2
850 ,P_ATTRIBUTE10 in VARCHAR2
851
852 ,P_ATTRIBUTE11 in VARCHAR2
853 ,P_ATTRIBUTE12 in VARCHAR2
854 ,P_ATTRIBUTE13 in VARCHAR2
855 ,P_ATTRIBUTE14 in VARCHAR2
856 ,P_ATTRIBUTE15
857 in VARCHAR2
858 ,P_ATTRIBUTE16 in VARCHAR2
859 ,P_ATTRIBUTE17 in VARCHAR2
860 ,P_ATTRIBUTE18 in VARCHAR2
861 ,P_ATTRIBUTE19 in
862 VARCHAR2
863 ,P_ATTRIBUTE20 in VARCHAR2
864 ,P_ENTRY_INFORMATION_CATEGORY in VARCHAR2
865 ,P_ENTRY_INFORMATION1 in VARCHAR2
866 ,P_ENTRY_INFORMATION2 in VARCHAR2
867
868 ,P_ENTRY_INFORMATION3 in VARCHAR2
869 ,P_ENTRY_INFORMATION4 in VARCHAR2
870 ,P_ENTRY_INFORMATION5 in VARCHAR2
871 ,P_ENTRY_INFORMATION6 in VARCHAR2
872 ,P_ENTRY_INFORMATION7
873 in VARCHAR2
874 ,P_ENTRY_INFORMATION8 in VARCHAR2
875 ,P_ENTRY_INFORMATION9 in VARCHAR2
876 ,P_ENTRY_INFORMATION10 in VARCHAR2
877 ,P_ENTRY_INFORMATION11 in
878 VARCHAR2
879 ,P_ENTRY_INFORMATION12 in VARCHAR2
880 ,P_ENTRY_INFORMATION13 in VARCHAR2
881 ,P_ENTRY_INFORMATION14 in VARCHAR2
882 ,P_ENTRY_INFORMATION15 in VARCHAR2
883
884 ,P_ENTRY_INFORMATION16 in VARCHAR2
885 ,P_ENTRY_INFORMATION17 in VARCHAR2
886 ,P_ENTRY_INFORMATION18 in VARCHAR2
887 ,P_ENTRY_INFORMATION19 in VARCHAR2
888 ,P_ENTRY_INFORMATION20
889 in VARCHAR2
890 ,P_ENTRY_INFORMATION21 in VARCHAR2
891 ,P_ENTRY_INFORMATION22 in VARCHAR2
892 ,P_ENTRY_INFORMATION23 in VARCHAR2
893 ,P_ENTRY_INFORMATION24 in
894 VARCHAR2
895 ,P_ENTRY_INFORMATION25 in VARCHAR2
896 ,P_ENTRY_INFORMATION26 in VARCHAR2
897 ,P_ENTRY_INFORMATION27 in VARCHAR2
898 ,P_ENTRY_INFORMATION28 in VARCHAR2
899
900 ,P_ENTRY_INFORMATION29 in VARCHAR2
901 ,P_ENTRY_INFORMATION30 in VARCHAR2
902 ,P_SUBPRIORITY in NUMBER
903 ,P_PERSONAL_PAYMENT_METHOD_ID in NUMBER
904 ,P_DATE_EARNED
905 in DATE
906 ,P_OBJECT_VERSION_NUMBER in NUMBER
907 ,P_SOURCE_ID in NUMBER
908 ,P_BALANCE_ADJ_COST_FLAG in VARCHAR2
909 ,P_ELEMENT_TYPE_ID in NUMBER
910
911 ,P_ALL_ENTRY_VALUES_NULL in VARCHAR2
912 ) IS
913 l_mode varchar2(80);
914
915 --
916 BEGIN
917
918 --
919 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
920 /* Mechanism for event capture to know whats occurred */
921 l_mode :=
922 pay_dyn_triggers.g_dyt_mode;
923 pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
924
925 --
926
927 if (paywsdyg_pkg.trigger_enabled('PAY_ELEMENT_ENTRIES_F_ARI')) then
928 PAY_ELEMENT_ENTRIES_F_ARI_ARI(
929 p_new_ASSIGNMENT_ID => P_ASSIGNMENT_ID
930 ,p_new_ATTRIBUTE1 => P_ATTRIBUTE1
931
932 ,p_new_ATTRIBUTE10 => P_ATTRIBUTE10
933 ,p_new_ATTRIBUTE11 => P_ATTRIBUTE11
934 ,p_new_ATTRIBUTE12 => P_ATTRIBUTE12
935 ,p_new_ATTRIBUTE13 => P_ATTRIBUTE13
936
937 ,p_new_ATTRIBUTE14 => P_ATTRIBUTE14
938 ,p_new_ATTRIBUTE15 => P_ATTRIBUTE15
939 ,p_new_ATTRIBUTE16 => P_ATTRIBUTE16
940 ,p_new_ATTRIBUTE17 => P_ATTRIBUTE17
941
942 ,p_new_ATTRIBUTE18 => P_ATTRIBUTE18
943 ,p_new_ATTRIBUTE19 => P_ATTRIBUTE19
944 ,p_new_ATTRIBUTE2 => P_ATTRIBUTE2
945 ,p_new_ATTRIBUTE20 => P_ATTRIBUTE20
946
947 ,p_new_ATTRIBUTE3 => P_ATTRIBUTE3
948 ,p_new_ATTRIBUTE4 => P_ATTRIBUTE4
949 ,p_new_ATTRIBUTE5 => P_ATTRIBUTE5
950 ,p_new_ATTRIBUTE6 => P_ATTRIBUTE6
951
952 ,p_new_ATTRIBUTE7 => P_ATTRIBUTE7
953 ,p_new_ATTRIBUTE8 => P_ATTRIBUTE8
954 ,p_new_ATTRIBUTE9 => P_ATTRIBUTE9
955 ,p_new_ATTRIBUTE_CATEGORY =>
956 P_ATTRIBUTE_CATEGORY
957 ,p_new_BALANCE_ADJ_COST_FLAG => P_BALANCE_ADJ_COST_FLAG
958 ,p_new_COMMENTS => P_COMMENTS
959 ,p_new_COMMENT_ID => P_COMMENT_ID
960
961 ,p_new_COST_ALLOCATION_KEYFLEX_ => P_COST_ALLOCATION_KEYFLEX_ID
962 ,p_new_CREATOR_ID => P_CREATOR_ID
963 ,p_new_CREATOR_TYPE => P_CREATOR_TYPE
964 ,p_new_DATE_EARNED =>
965 P_DATE_EARNED
966 ,p_new_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
967 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
968 ,p_new_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
969 ,p_new_ELEMENT_LINK_ID
970 => P_ELEMENT_LINK_ID
971 ,p_new_ELEMENT_TYPE_ID => P_ELEMENT_TYPE_ID
972 ,p_new_ENTRY_INFORMATION1 => P_ENTRY_INFORMATION1
973 ,p_new_ENTRY_INFORMATION10 => P_ENTRY_INFORMATION10
974
975 ,p_new_ENTRY_INFORMATION11 => P_ENTRY_INFORMATION11
976 ,p_new_ENTRY_INFORMATION12 => P_ENTRY_INFORMATION12
977 ,p_new_ENTRY_INFORMATION13 => P_ENTRY_INFORMATION13
978 ,p_new_ENTRY_INFORMATION14
979 => P_ENTRY_INFORMATION14
980 ,p_new_ENTRY_INFORMATION15 => P_ENTRY_INFORMATION15
981 ,p_new_ENTRY_INFORMATION16 => P_ENTRY_INFORMATION16
982 ,p_new_ENTRY_INFORMATION17 => P_ENTRY_INFORMATION17
983
984 ,p_new_ENTRY_INFORMATION18 => P_ENTRY_INFORMATION18
985 ,p_new_ENTRY_INFORMATION19 => P_ENTRY_INFORMATION19
986 ,p_new_ENTRY_INFORMATION2 => P_ENTRY_INFORMATION2
987 ,p_new_ENTRY_INFORMATION20
988 => P_ENTRY_INFORMATION20
989 ,p_new_ENTRY_INFORMATION21 => P_ENTRY_INFORMATION21
990 ,p_new_ENTRY_INFORMATION22 => P_ENTRY_INFORMATION22
991 ,p_new_ENTRY_INFORMATION23 => P_ENTRY_INFORMATION23
992
993 ,p_new_ENTRY_INFORMATION24 => P_ENTRY_INFORMATION24
994 ,p_new_ENTRY_INFORMATION25 => P_ENTRY_INFORMATION25
995 ,p_new_ENTRY_INFORMATION26 => P_ENTRY_INFORMATION26
996 ,p_new_ENTRY_INFORMATION27
997 => P_ENTRY_INFORMATION27
998 ,p_new_ENTRY_INFORMATION28 => P_ENTRY_INFORMATION28
999 ,p_new_ENTRY_INFORMATION29 => P_ENTRY_INFORMATION29
1000 ,p_new_ENTRY_INFORMATION3 => P_ENTRY_INFORMATION3
1001
1002 ,p_new_ENTRY_INFORMATION30 => P_ENTRY_INFORMATION30
1003 ,p_new_ENTRY_INFORMATION4 => P_ENTRY_INFORMATION4
1004 ,p_new_ENTRY_INFORMATION5 => P_ENTRY_INFORMATION5
1005 ,p_new_ENTRY_INFORMATION6
1006 => P_ENTRY_INFORMATION6
1007 ,p_new_ENTRY_INFORMATION7 => P_ENTRY_INFORMATION7
1008 ,p_new_ENTRY_INFORMATION8 => P_ENTRY_INFORMATION8
1009 ,p_new_ENTRY_INFORMATION9 => P_ENTRY_INFORMATION9
1010
1011 ,p_new_ENTRY_INFORMATION_CATEGO => P_ENTRY_INFORMATION_CATEGORY
1012 ,p_new_ENTRY_TYPE => P_ENTRY_TYPE
1013 ,p_new_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
1014 ,p_new_ORIGINAL_ENTRY_ID
1015 => P_ORIGINAL_ENTRY_ID
1016 ,p_new_PERSONAL_PAYMENT_METHOD_ => P_PERSONAL_PAYMENT_METHOD_ID
1017 ,p_new_REASON => P_REASON
1018 ,p_new_SOURCE_ID => P_SOURCE_ID
1019 ,p_new_SUBPRIORITY
1020 => P_SUBPRIORITY
1021 ,p_new_TARGET_ENTRY_ID => P_TARGET_ENTRY_ID
1022 ,p_new_UPDATING_ACTION_ID => P_UPDATING_ACTION_ID
1023 ,p_new_UPDATING_ACTION_TYPE => P_UPDATING_ACTION_TYPE
1024
1025 );
1026 end if;
1027
1028 --
1029
1030 if (paywsdyg_pkg.trigger_enabled('PQP_PEE_LOG_ARI')) then
1031 PQP_PEE_LOG_ARI_ARI(
1032 p_new_ASSIGNMENT_ID => P_ASSIGNMENT_ID
1033 ,p_new_ATTRIBUTE1 => P_ATTRIBUTE1
1034 ,p_new_ATTRIBUTE10
1035 => P_ATTRIBUTE10
1036 ,p_new_ATTRIBUTE11 => P_ATTRIBUTE11
1037 ,p_new_ATTRIBUTE12 => P_ATTRIBUTE12
1038 ,p_new_ATTRIBUTE13 => P_ATTRIBUTE13
1039 ,p_new_ATTRIBUTE14
1040 => P_ATTRIBUTE14
1041 ,p_new_ATTRIBUTE15 => P_ATTRIBUTE15
1042 ,p_new_ATTRIBUTE16 => P_ATTRIBUTE16
1043 ,p_new_ATTRIBUTE17 => P_ATTRIBUTE17
1044 ,p_new_ATTRIBUTE18
1045 => P_ATTRIBUTE18
1046 ,p_new_ATTRIBUTE19 => P_ATTRIBUTE19
1047 ,p_new_ATTRIBUTE2 => P_ATTRIBUTE2
1048 ,p_new_ATTRIBUTE20 => P_ATTRIBUTE20
1049 ,p_new_ATTRIBUTE3
1050 => P_ATTRIBUTE3
1051 ,p_new_ATTRIBUTE4 => P_ATTRIBUTE4
1052 ,p_new_ATTRIBUTE5 => P_ATTRIBUTE5
1053 ,p_new_ATTRIBUTE6 => P_ATTRIBUTE6
1054 ,p_new_ATTRIBUTE7
1055 => P_ATTRIBUTE7
1056 ,p_new_ATTRIBUTE8 => P_ATTRIBUTE8
1057 ,p_new_ATTRIBUTE9 => P_ATTRIBUTE9
1058 ,p_new_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
1059
1060 ,p_new_BALANCE_ADJ_COST_FLAG => P_BALANCE_ADJ_COST_FLAG
1061 ,p_new_COMMENTS => P_COMMENTS
1062 ,p_new_COMMENT_ID => P_COMMENT_ID
1063 ,p_new_COST_ALLOCATION_KEYFLEX_ =>
1064 P_COST_ALLOCATION_KEYFLEX_ID
1065 ,p_new_CREATOR_ID => P_CREATOR_ID
1066 ,p_new_CREATOR_TYPE => P_CREATOR_TYPE
1067 ,p_new_DATE_EARNED => P_DATE_EARNED
1068 ,p_new_EFFECTIVE_END_DATE
1069 => P_EFFECTIVE_END_DATE
1070 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
1071 ,p_new_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
1072 ,p_new_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID
1073
1074 ,p_new_ELEMENT_TYPE_ID => P_ELEMENT_TYPE_ID
1075 ,p_new_ENTRY_INFORMATION1 => P_ENTRY_INFORMATION1
1076 ,p_new_ENTRY_INFORMATION10 => P_ENTRY_INFORMATION10
1077 ,p_new_ENTRY_INFORMATION11
1078 => P_ENTRY_INFORMATION11
1079 ,p_new_ENTRY_INFORMATION12 => P_ENTRY_INFORMATION12
1080 ,p_new_ENTRY_INFORMATION13 => P_ENTRY_INFORMATION13
1081 ,p_new_ENTRY_INFORMATION14 => P_ENTRY_INFORMATION14
1082
1083 ,p_new_ENTRY_INFORMATION15 => P_ENTRY_INFORMATION15
1084 ,p_new_ENTRY_INFORMATION16 => P_ENTRY_INFORMATION16
1085 ,p_new_ENTRY_INFORMATION17 => P_ENTRY_INFORMATION17
1086 ,p_new_ENTRY_INFORMATION18
1087 => P_ENTRY_INFORMATION18
1088 ,p_new_ENTRY_INFORMATION19 => P_ENTRY_INFORMATION19
1089 ,p_new_ENTRY_INFORMATION2 => P_ENTRY_INFORMATION2
1090 ,p_new_ENTRY_INFORMATION20 => P_ENTRY_INFORMATION20
1091
1092 ,p_new_ENTRY_INFORMATION21 => P_ENTRY_INFORMATION21
1093 ,p_new_ENTRY_INFORMATION22 => P_ENTRY_INFORMATION22
1094 ,p_new_ENTRY_INFORMATION23 => P_ENTRY_INFORMATION23
1095 ,p_new_ENTRY_INFORMATION24
1096 => P_ENTRY_INFORMATION24
1097 ,p_new_ENTRY_INFORMATION25 => P_ENTRY_INFORMATION25
1098 ,p_new_ENTRY_INFORMATION26 => P_ENTRY_INFORMATION26
1099 ,p_new_ENTRY_INFORMATION27 => P_ENTRY_INFORMATION27
1100
1101 ,p_new_ENTRY_INFORMATION28 => P_ENTRY_INFORMATION28
1102 ,p_new_ENTRY_INFORMATION29 => P_ENTRY_INFORMATION29
1103 ,p_new_ENTRY_INFORMATION3 => P_ENTRY_INFORMATION3
1104 ,p_new_ENTRY_INFORMATION30
1105 => P_ENTRY_INFORMATION30
1106 ,p_new_ENTRY_INFORMATION4 => P_ENTRY_INFORMATION4
1107 ,p_new_ENTRY_INFORMATION5 => P_ENTRY_INFORMATION5
1108 ,p_new_ENTRY_INFORMATION6 => P_ENTRY_INFORMATION6
1109
1110 ,p_new_ENTRY_INFORMATION7 => P_ENTRY_INFORMATION7
1111 ,p_new_ENTRY_INFORMATION8 => P_ENTRY_INFORMATION8
1112 ,p_new_ENTRY_INFORMATION9 => P_ENTRY_INFORMATION9
1113 ,p_new_ENTRY_INFORMATION_CATEGO
1114 => P_ENTRY_INFORMATION_CATEGORY
1115 ,p_new_ENTRY_TYPE => P_ENTRY_TYPE
1116 ,p_new_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
1117 ,p_new_ORIGINAL_ENTRY_ID => P_ORIGINAL_ENTRY_ID
1118
1119 ,p_new_PERSONAL_PAYMENT_METHOD_ => P_PERSONAL_PAYMENT_METHOD_ID
1120 ,p_new_REASON => P_REASON
1121 ,p_new_SOURCE_ID => P_SOURCE_ID
1122 ,p_new_SUBPRIORITY =>
1123 P_SUBPRIORITY
1124 ,p_new_TARGET_ENTRY_ID => P_TARGET_ENTRY_ID
1125 ,p_new_UPDATING_ACTION_ID => P_UPDATING_ACTION_ID
1126 ,p_new_UPDATING_ACTION_TYPE => P_UPDATING_ACTION_TYPE
1127 );
1128 end if;
1129
1130 --
1131
1132 pay_dyn_triggers.g_dyt_mode := l_mode;
1133
1134 --
1135 EXCEPTION
1136 WHEN OTHERS THEN
1137 hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
1138 pay_dyn_triggers.g_dyt_mode := l_mode;
1139 RAISE;
1140 --
1141 END AFTER_INSERT;
1142
1143 --
1144
1145 /*
1146 ================================================
1147 This is a dynamically generated procedure.
1148 Will be called by API.
1149 ================================================
1150 ** DO NOT CHANGE MANUALLY **
1151
1152 ------------------------------------------------
1153 Name: AFTER_UPDATE
1154 Table: PAY_ELEMENT_ENTRIES_F
1155 Action: UPDATE
1156 Generated Date: 30/03/2009 04:53
1157 Description: Called as part of UPDATE process
1158
1159 ================================================
1160 */
1161
1162 --
1163 PROCEDURE AFTER_UPDATE
1164 (
1165 P_EFFECTIVE_DATE in DATE
1166 ,P_DATETRACK_MODE in VARCHAR2
1167 ,P_VALIDATION_START_DATE in DATE
1168
1169 ,P_VALIDATION_END_DATE in DATE
1170 ,P_ELEMENT_ENTRY_ID in NUMBER
1171 ,P_EFFECTIVE_START_DATE in DATE
1172 ,P_EFFECTIVE_END_DATE in DATE
1173 ,P_COST_ALLOCATION_KEYFLEX_ID
1174 in NUMBER
1175 ,P_UPDATING_ACTION_ID in NUMBER
1176 ,P_UPDATING_ACTION_TYPE in VARCHAR2
1177 ,P_ORIGINAL_ENTRY_ID in NUMBER
1178 ,P_CREATOR_TYPE in VARCHAR2
1179 ,P_ENTRY_TYPE
1180 in VARCHAR2
1181 ,P_COMMENT_ID in NUMBER
1182 ,P_COMMENTS in VARCHAR2
1183 ,P_CREATOR_ID in NUMBER
1184 ,P_REASON in
1185 VARCHAR2
1186 ,P_TARGET_ENTRY_ID in NUMBER
1187 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
1188 ,P_ATTRIBUTE1 in VARCHAR2
1189 ,P_ATTRIBUTE2 in VARCHAR2
1190 ,P_ATTRIBUTE3
1191 in VARCHAR2
1192 ,P_ATTRIBUTE4 in VARCHAR2
1193 ,P_ATTRIBUTE5 in VARCHAR2
1194 ,P_ATTRIBUTE6 in VARCHAR2
1195 ,P_ATTRIBUTE7
1196 in VARCHAR2
1197 ,P_ATTRIBUTE8 in VARCHAR2
1198 ,P_ATTRIBUTE9 in VARCHAR2
1199 ,P_ATTRIBUTE10 in VARCHAR2
1200 ,P_ATTRIBUTE11 in VARCHAR2
1201
1202 ,P_ATTRIBUTE12 in VARCHAR2
1203 ,P_ATTRIBUTE13 in VARCHAR2
1204 ,P_ATTRIBUTE14 in VARCHAR2
1205 ,P_ATTRIBUTE15 in VARCHAR2
1206 ,P_ATTRIBUTE16
1207 in VARCHAR2
1208 ,P_ATTRIBUTE17 in VARCHAR2
1209 ,P_ATTRIBUTE18 in VARCHAR2
1210 ,P_ATTRIBUTE19 in VARCHAR2
1211 ,P_ATTRIBUTE20 in
1212 VARCHAR2
1213 ,P_ENTRY_INFORMATION_CATEGORY in VARCHAR2
1214 ,P_ENTRY_INFORMATION1 in VARCHAR2
1215 ,P_ENTRY_INFORMATION2 in VARCHAR2
1216 ,P_ENTRY_INFORMATION3 in VARCHAR2
1217
1218 ,P_ENTRY_INFORMATION4 in VARCHAR2
1219 ,P_ENTRY_INFORMATION5 in VARCHAR2
1220 ,P_ENTRY_INFORMATION6 in VARCHAR2
1221 ,P_ENTRY_INFORMATION7 in VARCHAR2
1222 ,P_ENTRY_INFORMATION8
1223 in VARCHAR2
1224 ,P_ENTRY_INFORMATION9 in VARCHAR2
1225 ,P_ENTRY_INFORMATION10 in VARCHAR2
1226 ,P_ENTRY_INFORMATION11 in VARCHAR2
1227 ,P_ENTRY_INFORMATION12 in
1228 VARCHAR2
1229 ,P_ENTRY_INFORMATION13 in VARCHAR2
1230 ,P_ENTRY_INFORMATION14 in VARCHAR2
1231 ,P_ENTRY_INFORMATION15 in VARCHAR2
1232 ,P_ENTRY_INFORMATION16 in VARCHAR2
1233
1234 ,P_ENTRY_INFORMATION17 in VARCHAR2
1235 ,P_ENTRY_INFORMATION18 in VARCHAR2
1236 ,P_ENTRY_INFORMATION19 in VARCHAR2
1237 ,P_ENTRY_INFORMATION20 in VARCHAR2
1238 ,P_ENTRY_INFORMATION21
1239 in VARCHAR2
1240 ,P_ENTRY_INFORMATION22 in VARCHAR2
1241 ,P_ENTRY_INFORMATION23 in VARCHAR2
1242 ,P_ENTRY_INFORMATION24 in VARCHAR2
1243 ,P_ENTRY_INFORMATION25 in
1244 VARCHAR2
1245 ,P_ENTRY_INFORMATION26 in VARCHAR2
1246 ,P_ENTRY_INFORMATION27 in VARCHAR2
1247 ,P_ENTRY_INFORMATION28 in VARCHAR2
1248 ,P_ENTRY_INFORMATION29 in VARCHAR2
1249
1250 ,P_ENTRY_INFORMATION30 in VARCHAR2
1251 ,P_SUBPRIORITY in NUMBER
1252 ,P_PERSONAL_PAYMENT_METHOD_ID in NUMBER
1253 ,P_DATE_EARNED in DATE
1254 ,P_OBJECT_VERSION_NUMBER
1255 in NUMBER
1256 ,P_SOURCE_ID in NUMBER
1257 ,P_BALANCE_ADJ_COST_FLAG in VARCHAR2
1258 ,P_ALL_ENTRY_VALUES_NULL in VARCHAR2
1259 ,P_EFFECTIVE_START_DATE_O in DATE
1260
1261 ,P_EFFECTIVE_END_DATE_O in DATE
1262 ,P_COST_ALLOCATION_KEYFLEX_ID_O in NUMBER
1263 ,P_ASSIGNMENT_ID_O in NUMBER
1264 ,P_UPDATING_ACTION_ID_O in NUMBER
1265 ,P_UPDATING_ACTION_TYPE_O
1266 in VARCHAR2
1267 ,P_ELEMENT_LINK_ID_O in NUMBER
1268 ,P_ORIGINAL_ENTRY_ID_O in NUMBER
1269 ,P_CREATOR_TYPE_O in VARCHAR2
1270 ,P_ENTRY_TYPE_O in VARCHAR2
1271
1272 ,P_COMMENT_ID_O in NUMBER
1273 ,P_COMMENTS_O in VARCHAR2
1274 ,P_CREATOR_ID_O in NUMBER
1275 ,P_REASON_O in VARCHAR2
1276 ,P_TARGET_ENTRY_ID_O
1277 in NUMBER
1278 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
1279 ,P_ATTRIBUTE1_O in VARCHAR2
1280 ,P_ATTRIBUTE2_O in VARCHAR2
1281 ,P_ATTRIBUTE3_O in VARCHAR2
1282
1283 ,P_ATTRIBUTE4_O in VARCHAR2
1284 ,P_ATTRIBUTE5_O in VARCHAR2
1285 ,P_ATTRIBUTE6_O in VARCHAR2
1286 ,P_ATTRIBUTE7_O in VARCHAR2
1287 ,P_ATTRIBUTE8_O
1288 in VARCHAR2
1289 ,P_ATTRIBUTE9_O in VARCHAR2
1290 ,P_ATTRIBUTE10_O in VARCHAR2
1291 ,P_ATTRIBUTE11_O in VARCHAR2
1292 ,P_ATTRIBUTE12_O in
1293 VARCHAR2
1294 ,P_ATTRIBUTE13_O in VARCHAR2
1295 ,P_ATTRIBUTE14_O in VARCHAR2
1296 ,P_ATTRIBUTE15_O in VARCHAR2
1297 ,P_ATTRIBUTE16_O in VARCHAR2
1298
1299 ,P_ATTRIBUTE17_O in VARCHAR2
1300 ,P_ATTRIBUTE18_O in VARCHAR2
1301 ,P_ATTRIBUTE19_O in VARCHAR2
1302 ,P_ATTRIBUTE20_O in VARCHAR2
1303
1304 ,P_ENTRY_INFORMATION_CATEGORY_O in VARCHAR2
1305 ,P_ENTRY_INFORMATION1_O in VARCHAR2
1306 ,P_ENTRY_INFORMATION2_O in VARCHAR2
1307 ,P_ENTRY_INFORMATION3_O in VARCHAR2
1308 ,P_ENTRY_INFORMATION4_O
1309 in VARCHAR2
1310 ,P_ENTRY_INFORMATION5_O in VARCHAR2
1311 ,P_ENTRY_INFORMATION6_O in VARCHAR2
1312 ,P_ENTRY_INFORMATION7_O in VARCHAR2
1313 ,P_ENTRY_INFORMATION8_O in
1314 VARCHAR2
1315 ,P_ENTRY_INFORMATION9_O in VARCHAR2
1316 ,P_ENTRY_INFORMATION10_O in VARCHAR2
1317 ,P_ENTRY_INFORMATION11_O in VARCHAR2
1318 ,P_ENTRY_INFORMATION12_O in VARCHAR2
1319
1320 ,P_ENTRY_INFORMATION13_O in VARCHAR2
1321 ,P_ENTRY_INFORMATION14_O in VARCHAR2
1322 ,P_ENTRY_INFORMATION15_O in VARCHAR2
1323 ,P_ENTRY_INFORMATION16_O in VARCHAR2
1324 ,P_ENTRY_INFORMATION17_O
1325 in VARCHAR2
1326 ,P_ENTRY_INFORMATION18_O in VARCHAR2
1327 ,P_ENTRY_INFORMATION19_O in VARCHAR2
1328 ,P_ENTRY_INFORMATION20_O in VARCHAR2
1329 ,P_ENTRY_INFORMATION21_O in
1330 VARCHAR2
1331 ,P_ENTRY_INFORMATION22_O in VARCHAR2
1332 ,P_ENTRY_INFORMATION23_O in VARCHAR2
1333 ,P_ENTRY_INFORMATION24_O in VARCHAR2
1334 ,P_ENTRY_INFORMATION25_O in VARCHAR2
1335
1336 ,P_ENTRY_INFORMATION26_O in VARCHAR2
1337 ,P_ENTRY_INFORMATION27_O in VARCHAR2
1338 ,P_ENTRY_INFORMATION28_O in VARCHAR2
1339 ,P_ENTRY_INFORMATION29_O in VARCHAR2
1340 ,P_ENTRY_INFORMATION30_O
1341 in VARCHAR2
1342 ,P_SUBPRIORITY_O in NUMBER
1343 ,P_PERSONAL_PAYMENT_METHOD_ID_O in NUMBER
1344 ,P_DATE_EARNED_O in DATE
1345 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
1346
1347 ,P_SOURCE_ID_O in NUMBER
1348 ,P_BALANCE_ADJ_COST_FLAG_O in VARCHAR2
1349 ,P_ELEMENT_TYPE_ID_O in NUMBER
1350 ,P_ALL_ENTRY_VALUES_NULL_O in VARCHAR2
1351 ) IS
1352 l_mode varchar2(80);
1353
1354
1355 --
1356 BEGIN
1357
1358 --
1359 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
1360 /* Mechanism for event capture to know whats occurred */
1361 l_mode := pay_dyn_triggers.g_dyt_mode;
1362 pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1363
1364 --
1365
1366 if (paywsdyg_pkg.trigger_enabled('PAY_ELEMENT_ENTRIES_F_ARU')) then
1367 PAY_ELEMENT_ENTRIES_F_ARU_ARU(
1368 p_new_ATTRIBUTE1 => P_ATTRIBUTE1
1369 ,p_new_ATTRIBUTE10 => P_ATTRIBUTE10
1370
1371 ,p_new_ATTRIBUTE11 => P_ATTRIBUTE11
1372 ,p_new_ATTRIBUTE12 => P_ATTRIBUTE12
1373 ,p_new_ATTRIBUTE13 => P_ATTRIBUTE13
1374 ,p_new_ATTRIBUTE14 => P_ATTRIBUTE14
1375
1376 ,p_new_ATTRIBUTE15 => P_ATTRIBUTE15
1377 ,p_new_ATTRIBUTE16 => P_ATTRIBUTE16
1378 ,p_new_ATTRIBUTE17 => P_ATTRIBUTE17
1379 ,p_new_ATTRIBUTE18 => P_ATTRIBUTE18
1380
1381 ,p_new_ATTRIBUTE19 => P_ATTRIBUTE19
1382 ,p_new_ATTRIBUTE2 => P_ATTRIBUTE2
1383 ,p_new_ATTRIBUTE20 => P_ATTRIBUTE20
1384 ,p_new_ATTRIBUTE3 => P_ATTRIBUTE3
1385
1386 ,p_new_ATTRIBUTE4 => P_ATTRIBUTE4
1387 ,p_new_ATTRIBUTE5 => P_ATTRIBUTE5
1388 ,p_new_ATTRIBUTE6 => P_ATTRIBUTE6
1389 ,p_new_ATTRIBUTE7 => P_ATTRIBUTE7
1390
1391 ,p_new_ATTRIBUTE8 => P_ATTRIBUTE8
1392 ,p_new_ATTRIBUTE9 => P_ATTRIBUTE9
1393 ,p_new_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
1394 ,p_new_BALANCE_ADJ_COST_FLAG =>
1395 P_BALANCE_ADJ_COST_FLAG
1396 ,p_new_COMMENTS => P_COMMENTS
1397 ,p_new_COMMENT_ID => P_COMMENT_ID
1398 ,p_new_COST_ALLOCATION_KEYFLEX_ => P_COST_ALLOCATION_KEYFLEX_ID
1399 ,p_new_CREATOR_ID
1400 => P_CREATOR_ID
1401 ,p_new_CREATOR_TYPE => P_CREATOR_TYPE
1402 ,p_new_DATE_EARNED => P_DATE_EARNED
1403 ,p_new_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
1404
1405 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
1406 ,p_new_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
1407 ,p_new_ENTRY_INFORMATION1 => P_ENTRY_INFORMATION1
1408 ,p_new_ENTRY_INFORMATION10
1409 => P_ENTRY_INFORMATION10
1410 ,p_new_ENTRY_INFORMATION11 => P_ENTRY_INFORMATION11
1411 ,p_new_ENTRY_INFORMATION12 => P_ENTRY_INFORMATION12
1412 ,p_new_ENTRY_INFORMATION13 => P_ENTRY_INFORMATION13
1413
1414 ,p_new_ENTRY_INFORMATION14 => P_ENTRY_INFORMATION14
1415 ,p_new_ENTRY_INFORMATION15 => P_ENTRY_INFORMATION15
1416 ,p_new_ENTRY_INFORMATION16 => P_ENTRY_INFORMATION16
1417 ,p_new_ENTRY_INFORMATION17
1418 => P_ENTRY_INFORMATION17
1419 ,p_new_ENTRY_INFORMATION18 => P_ENTRY_INFORMATION18
1420 ,p_new_ENTRY_INFORMATION19 => P_ENTRY_INFORMATION19
1421 ,p_new_ENTRY_INFORMATION2 => P_ENTRY_INFORMATION2
1422
1423 ,p_new_ENTRY_INFORMATION20 => P_ENTRY_INFORMATION20
1424 ,p_new_ENTRY_INFORMATION21 => P_ENTRY_INFORMATION21
1425 ,p_new_ENTRY_INFORMATION22 => P_ENTRY_INFORMATION22
1426 ,p_new_ENTRY_INFORMATION23
1427 => P_ENTRY_INFORMATION23
1428 ,p_new_ENTRY_INFORMATION24 => P_ENTRY_INFORMATION24
1429 ,p_new_ENTRY_INFORMATION25 => P_ENTRY_INFORMATION25
1430 ,p_new_ENTRY_INFORMATION26 => P_ENTRY_INFORMATION26
1431
1432 ,p_new_ENTRY_INFORMATION27 => P_ENTRY_INFORMATION27
1433 ,p_new_ENTRY_INFORMATION28 => P_ENTRY_INFORMATION28
1434 ,p_new_ENTRY_INFORMATION29 => P_ENTRY_INFORMATION29
1435 ,p_new_ENTRY_INFORMATION3
1436 => P_ENTRY_INFORMATION3
1437 ,p_new_ENTRY_INFORMATION30 => P_ENTRY_INFORMATION30
1438 ,p_new_ENTRY_INFORMATION4 => P_ENTRY_INFORMATION4
1439 ,p_new_ENTRY_INFORMATION5 => P_ENTRY_INFORMATION5
1440
1441 ,p_new_ENTRY_INFORMATION6 => P_ENTRY_INFORMATION6
1442 ,p_new_ENTRY_INFORMATION7 => P_ENTRY_INFORMATION7
1443 ,p_new_ENTRY_INFORMATION8 => P_ENTRY_INFORMATION8
1444 ,p_new_ENTRY_INFORMATION9
1445 => P_ENTRY_INFORMATION9
1446 ,p_new_ENTRY_INFORMATION_CATEGO => P_ENTRY_INFORMATION_CATEGORY
1447 ,p_new_ENTRY_TYPE => P_ENTRY_TYPE
1448 ,p_new_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
1449
1450 ,p_new_ORIGINAL_ENTRY_ID => P_ORIGINAL_ENTRY_ID
1451 ,p_new_PERSONAL_PAYMENT_METHOD_ => P_PERSONAL_PAYMENT_METHOD_ID
1452 ,p_new_REASON => P_REASON
1453 ,p_new_SOURCE_ID =>
1454 P_SOURCE_ID
1455 ,p_new_SUBPRIORITY => P_SUBPRIORITY
1456 ,p_new_TARGET_ENTRY_ID => P_TARGET_ENTRY_ID
1457 ,p_new_UPDATING_ACTION_ID => P_UPDATING_ACTION_ID
1458 ,p_new_UPDATING_ACTION_TYPE
1459 => P_UPDATING_ACTION_TYPE
1460 ,p_old_ASSIGNMENT_ID => P_ASSIGNMENT_ID_O
1461 ,p_old_ATTRIBUTE1 => P_ATTRIBUTE1_O
1462 ,p_old_ATTRIBUTE10 => P_ATTRIBUTE10_O
1463
1464 ,p_old_ATTRIBUTE11 => P_ATTRIBUTE11_O
1465 ,p_old_ATTRIBUTE12 => P_ATTRIBUTE12_O
1466 ,p_old_ATTRIBUTE13 => P_ATTRIBUTE13_O
1467 ,p_old_ATTRIBUTE14 =>
1468 P_ATTRIBUTE14_O
1469 ,p_old_ATTRIBUTE15 => P_ATTRIBUTE15_O
1470 ,p_old_ATTRIBUTE16 => P_ATTRIBUTE16_O
1471 ,p_old_ATTRIBUTE17 => P_ATTRIBUTE17_O
1472 ,p_old_ATTRIBUTE18
1473 => P_ATTRIBUTE18_O
1474 ,p_old_ATTRIBUTE19 => P_ATTRIBUTE19_O
1475 ,p_old_ATTRIBUTE2 => P_ATTRIBUTE2_O
1476 ,p_old_ATTRIBUTE20 => P_ATTRIBUTE20_O
1477 ,p_old_ATTRIBUTE3
1478 => P_ATTRIBUTE3_O
1479 ,p_old_ATTRIBUTE4 => P_ATTRIBUTE4_O
1480 ,p_old_ATTRIBUTE5 => P_ATTRIBUTE5_O
1481 ,p_old_ATTRIBUTE6 => P_ATTRIBUTE6_O
1482 ,p_old_ATTRIBUTE7
1483 => P_ATTRIBUTE7_O
1484 ,p_old_ATTRIBUTE8 => P_ATTRIBUTE8_O
1485 ,p_old_ATTRIBUTE9 => P_ATTRIBUTE9_O
1486 ,p_old_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY_O
1487
1488 ,p_old_BALANCE_ADJ_COST_FLAG => P_BALANCE_ADJ_COST_FLAG_O
1489 ,p_old_COMMENTS => P_COMMENTS_O
1490 ,p_old_COMMENT_ID => P_COMMENT_ID_O
1491 ,p_old_COST_ALLOCATION_KEYFLEX_ =>
1492 P_COST_ALLOCATION_KEYFLEX_ID_O
1493 ,p_old_CREATOR_ID => P_CREATOR_ID_O
1494 ,p_old_CREATOR_TYPE => P_CREATOR_TYPE_O
1495 ,p_old_DATE_EARNED => P_DATE_EARNED_O
1496
1497 ,p_old_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE_O
1498 ,p_old_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE_O
1499 ,p_old_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID_O
1500 ,p_old_ELEMENT_TYPE_ID
1501 => P_ELEMENT_TYPE_ID_O
1502 ,p_old_ENTRY_INFORMATION1 => P_ENTRY_INFORMATION1_O
1503 ,p_old_ENTRY_INFORMATION10 => P_ENTRY_INFORMATION10_O
1504 ,p_old_ENTRY_INFORMATION11 => P_ENTRY_INFORMATION11_O
1505
1506 ,p_old_ENTRY_INFORMATION12 => P_ENTRY_INFORMATION12_O
1507 ,p_old_ENTRY_INFORMATION13 => P_ENTRY_INFORMATION13_O
1508 ,p_old_ENTRY_INFORMATION14 => P_ENTRY_INFORMATION14_O
1509 ,p_old_ENTRY_INFORMATION15
1510 => P_ENTRY_INFORMATION15_O
1511 ,p_old_ENTRY_INFORMATION16 => P_ENTRY_INFORMATION16_O
1512 ,p_old_ENTRY_INFORMATION17 => P_ENTRY_INFORMATION17_O
1513 ,p_old_ENTRY_INFORMATION18 =>
1514 P_ENTRY_INFORMATION18_O
1515 ,p_old_ENTRY_INFORMATION19 => P_ENTRY_INFORMATION19_O
1516 ,p_old_ENTRY_INFORMATION2 => P_ENTRY_INFORMATION2_O
1517 ,p_old_ENTRY_INFORMATION20 => P_ENTRY_INFORMATION20_O
1518
1519 ,p_old_ENTRY_INFORMATION21 => P_ENTRY_INFORMATION21_O
1520 ,p_old_ENTRY_INFORMATION22 => P_ENTRY_INFORMATION22_O
1521 ,p_old_ENTRY_INFORMATION23 => P_ENTRY_INFORMATION23_O
1522 ,p_old_ENTRY_INFORMATION24
1523 => P_ENTRY_INFORMATION24_O
1524 ,p_old_ENTRY_INFORMATION25 => P_ENTRY_INFORMATION25_O
1525 ,p_old_ENTRY_INFORMATION26 => P_ENTRY_INFORMATION26_O
1526 ,p_old_ENTRY_INFORMATION27 =>
1527 P_ENTRY_INFORMATION27_O
1528 ,p_old_ENTRY_INFORMATION28 => P_ENTRY_INFORMATION28_O
1529 ,p_old_ENTRY_INFORMATION29 => P_ENTRY_INFORMATION29_O
1530 ,p_old_ENTRY_INFORMATION3 => P_ENTRY_INFORMATION3_O
1531
1532 ,p_old_ENTRY_INFORMATION30 => P_ENTRY_INFORMATION30_O
1533 ,p_old_ENTRY_INFORMATION4 => P_ENTRY_INFORMATION4_O
1534 ,p_old_ENTRY_INFORMATION5 => P_ENTRY_INFORMATION5_O
1535 ,p_old_ENTRY_INFORMATION6
1536 => P_ENTRY_INFORMATION6_O
1537 ,p_old_ENTRY_INFORMATION7 => P_ENTRY_INFORMATION7_O
1538 ,p_old_ENTRY_INFORMATION8 => P_ENTRY_INFORMATION8_O
1539 ,p_old_ENTRY_INFORMATION9 => P_ENTRY_INFORMATION9_O
1540
1541 ,p_old_ENTRY_INFORMATION_CATEGO => P_ENTRY_INFORMATION_CATEGORY_O
1542 ,p_old_ENTRY_TYPE => P_ENTRY_TYPE_O
1543 ,p_old_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER_O
1544 ,p_old_ORIGINAL_ENTRY_ID
1545 => P_ORIGINAL_ENTRY_ID_O
1546 ,p_old_PERSONAL_PAYMENT_METHOD_ => P_PERSONAL_PAYMENT_METHOD_ID_O
1547 ,p_old_REASON => P_REASON_O
1548 ,p_old_SOURCE_ID => P_SOURCE_ID_O
1549
1550 ,p_old_SUBPRIORITY => P_SUBPRIORITY_O
1551 ,p_old_TARGET_ENTRY_ID => P_TARGET_ENTRY_ID_O
1552 ,p_old_UPDATING_ACTION_ID => P_UPDATING_ACTION_ID_O
1553 ,p_old_UPDATING_ACTION_TYPE =>
1554 P_UPDATING_ACTION_TYPE_O
1555 );
1556 end if;
1557
1558 --
1559 pay_dyn_triggers.g_dyt_mode := l_mode;
1560
1561 --
1562 EXCEPTION
1563 WHEN OTHERS THEN
1564 hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
1565 pay_dyn_triggers.g_dyt_mode := l_mode;
1566 RAISE;
1567 --
1568 END
1569 AFTER_UPDATE;
1570
1571 --
1572
1573 /*
1574 ================================================
1575 This is a dynamically generated procedure.
1576 Will be called by API.
1577 ================================================
1578 ** DO NOT CHANGE MANUALLY **
1579
1580 ------------------------------------------------
1581 Name: AFTER_DELETE
1582 Table: PAY_ELEMENT_ENTRIES_F
1583 Action: DELETE
1584 Generated Date: 30/03/2009 04:53
1585 Description: Called as part of DELETE process
1586
1587 ================================================
1588 */
1589
1590 --
1591 PROCEDURE AFTER_DELETE
1592 (
1593 P_EFFECTIVE_DATE in DATE
1594 ,P_DATETRACK_MODE in VARCHAR2
1595 ,P_VALIDATION_START_DATE in DATE
1596
1597 ,P_VALIDATION_END_DATE in DATE
1598 ,P_ELEMENT_ENTRY_ID in NUMBER
1599 ,P_EFFECTIVE_START_DATE in DATE
1600 ,P_EFFECTIVE_END_DATE in DATE
1601 ,P_EFFECTIVE_START_DATE_O
1602 in DATE
1603 ,P_EFFECTIVE_END_DATE_O in DATE
1604 ,P_COST_ALLOCATION_KEYFLEX_ID_O in NUMBER
1605 ,P_ASSIGNMENT_ID_O in NUMBER
1606 ,P_UPDATING_ACTION_ID_O in NUMBER
1607
1608 ,P_UPDATING_ACTION_TYPE_O in VARCHAR2
1609 ,P_ELEMENT_LINK_ID_O in NUMBER
1610 ,P_ORIGINAL_ENTRY_ID_O in NUMBER
1611 ,P_CREATOR_TYPE_O in VARCHAR2
1612 ,P_ENTRY_TYPE_O
1613 in VARCHAR2
1614 ,P_COMMENT_ID_O in NUMBER
1615 ,P_COMMENTS_O in VARCHAR2
1616 ,P_CREATOR_ID_O in NUMBER
1617 ,P_REASON_O in VARCHAR2
1618
1619 ,P_TARGET_ENTRY_ID_O in NUMBER
1620 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
1621 ,P_ATTRIBUTE1_O in VARCHAR2
1622 ,P_ATTRIBUTE2_O in VARCHAR2
1623 ,P_ATTRIBUTE3_O
1624 in VARCHAR2
1625 ,P_ATTRIBUTE4_O in VARCHAR2
1626 ,P_ATTRIBUTE5_O in VARCHAR2
1627 ,P_ATTRIBUTE6_O in VARCHAR2
1628 ,P_ATTRIBUTE7_O in VARCHAR2
1629
1630 ,P_ATTRIBUTE8_O in VARCHAR2
1631 ,P_ATTRIBUTE9_O in VARCHAR2
1632 ,P_ATTRIBUTE10_O in VARCHAR2
1633 ,P_ATTRIBUTE11_O in VARCHAR2
1634 ,P_ATTRIBUTE12_O
1635 in VARCHAR2
1636 ,P_ATTRIBUTE13_O in VARCHAR2
1637 ,P_ATTRIBUTE14_O in VARCHAR2
1638 ,P_ATTRIBUTE15_O in VARCHAR2
1639 ,P_ATTRIBUTE16_O in
1640 VARCHAR2
1641 ,P_ATTRIBUTE17_O in VARCHAR2
1642 ,P_ATTRIBUTE18_O in VARCHAR2
1643 ,P_ATTRIBUTE19_O in VARCHAR2
1644 ,P_ATTRIBUTE20_O in VARCHAR2
1645
1646 ,P_ENTRY_INFORMATION_CATEGORY_O in VARCHAR2
1647 ,P_ENTRY_INFORMATION1_O in VARCHAR2
1648 ,P_ENTRY_INFORMATION2_O in VARCHAR2
1649 ,P_ENTRY_INFORMATION3_O in VARCHAR2
1650 ,P_ENTRY_INFORMATION4_O
1651 in VARCHAR2
1652 ,P_ENTRY_INFORMATION5_O in VARCHAR2
1653 ,P_ENTRY_INFORMATION6_O in VARCHAR2
1654 ,P_ENTRY_INFORMATION7_O in VARCHAR2
1655 ,P_ENTRY_INFORMATION8_O in
1656 VARCHAR2
1657 ,P_ENTRY_INFORMATION9_O in VARCHAR2
1658 ,P_ENTRY_INFORMATION10_O in VARCHAR2
1659 ,P_ENTRY_INFORMATION11_O in VARCHAR2
1660 ,P_ENTRY_INFORMATION12_O in VARCHAR2
1661
1662 ,P_ENTRY_INFORMATION13_O in VARCHAR2
1663 ,P_ENTRY_INFORMATION14_O in VARCHAR2
1664 ,P_ENTRY_INFORMATION15_O in VARCHAR2
1665 ,P_ENTRY_INFORMATION16_O in VARCHAR2
1666 ,P_ENTRY_INFORMATION17_O
1667 in VARCHAR2
1668 ,P_ENTRY_INFORMATION18_O in VARCHAR2
1669 ,P_ENTRY_INFORMATION19_O in VARCHAR2
1670 ,P_ENTRY_INFORMATION20_O in VARCHAR2
1671 ,P_ENTRY_INFORMATION21_O in
1672 VARCHAR2
1673 ,P_ENTRY_INFORMATION22_O in VARCHAR2
1674 ,P_ENTRY_INFORMATION23_O in VARCHAR2
1675 ,P_ENTRY_INFORMATION24_O in VARCHAR2
1676 ,P_ENTRY_INFORMATION25_O in VARCHAR2
1677
1678 ,P_ENTRY_INFORMATION26_O in VARCHAR2
1679 ,P_ENTRY_INFORMATION27_O in VARCHAR2
1680 ,P_ENTRY_INFORMATION28_O in VARCHAR2
1681 ,P_ENTRY_INFORMATION29_O in VARCHAR2
1682 ,P_ENTRY_INFORMATION30_O
1683 in VARCHAR2
1684 ,P_SUBPRIORITY_O in NUMBER
1685 ,P_PERSONAL_PAYMENT_METHOD_ID_O in NUMBER
1686 ,P_DATE_EARNED_O in DATE
1687 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
1688
1689 ,P_SOURCE_ID_O in NUMBER
1690 ,P_BALANCE_ADJ_COST_FLAG_O in VARCHAR2
1691 ,P_ELEMENT_TYPE_ID_O in NUMBER
1692 ,P_ALL_ENTRY_VALUES_NULL_O in VARCHAR2
1693 ) IS
1694 l_mode varchar2(80);
1695
1696
1697 --
1698 BEGIN
1699
1700 --
1701 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');
1702 /* Mechanism for event capture to know whats occurred */
1703 l_mode := pay_dyn_triggers.g_dyt_mode;
1704 pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1705
1706 --
1707
1708 if (paywsdyg_pkg.trigger_enabled('PAY_ELEMENT_ENTRIES_F_ARD')) then
1709 PAY_ELEMENT_ENTRIES_F_ARD_ARD(
1710 p_new_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
1711 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
1712
1713 ,p_new_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
1714 ,p_old_ASSIGNMENT_ID => P_ASSIGNMENT_ID_O
1715 ,p_old_ATTRIBUTE1 => P_ATTRIBUTE1_O
1716 ,p_old_ATTRIBUTE10 =>
1717 P_ATTRIBUTE10_O
1718 ,p_old_ATTRIBUTE11 => P_ATTRIBUTE11_O
1719 ,p_old_ATTRIBUTE12 => P_ATTRIBUTE12_O
1720 ,p_old_ATTRIBUTE13 => P_ATTRIBUTE13_O
1721 ,p_old_ATTRIBUTE14
1722 => P_ATTRIBUTE14_O
1723 ,p_old_ATTRIBUTE15 => P_ATTRIBUTE15_O
1724 ,p_old_ATTRIBUTE16 => P_ATTRIBUTE16_O
1725 ,p_old_ATTRIBUTE17 => P_ATTRIBUTE17_O
1726 ,p_old_ATTRIBUTE18
1727 => P_ATTRIBUTE18_O
1728 ,p_old_ATTRIBUTE19 => P_ATTRIBUTE19_O
1729 ,p_old_ATTRIBUTE2 => P_ATTRIBUTE2_O
1730 ,p_old_ATTRIBUTE20 => P_ATTRIBUTE20_O
1731
1732 ,p_old_ATTRIBUTE3 => P_ATTRIBUTE3_O
1733 ,p_old_ATTRIBUTE4 => P_ATTRIBUTE4_O
1734 ,p_old_ATTRIBUTE5 => P_ATTRIBUTE5_O
1735 ,p_old_ATTRIBUTE6 => P_ATTRIBUTE6_O
1736
1737 ,p_old_ATTRIBUTE7 => P_ATTRIBUTE7_O
1738 ,p_old_ATTRIBUTE8 => P_ATTRIBUTE8_O
1739 ,p_old_ATTRIBUTE9 => P_ATTRIBUTE9_O
1740 ,p_old_ATTRIBUTE_CATEGORY =>
1741 P_ATTRIBUTE_CATEGORY_O
1742 ,p_old_BALANCE_ADJ_COST_FLAG => P_BALANCE_ADJ_COST_FLAG_O
1743 ,p_old_COMMENTS => P_COMMENTS_O
1744 ,p_old_COMMENT_ID => P_COMMENT_ID_O
1745
1746 ,p_old_COST_ALLOCATION_KEYFLEX_ => P_COST_ALLOCATION_KEYFLEX_ID_O
1747 ,p_old_CREATOR_ID => P_CREATOR_ID_O
1748 ,p_old_CREATOR_TYPE => P_CREATOR_TYPE_O
1749 ,p_old_DATE_EARNED
1750 => P_DATE_EARNED_O
1751 ,p_old_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE_O
1752 ,p_old_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE_O
1753 ,p_old_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID_O
1754
1755 ,p_old_ELEMENT_TYPE_ID => P_ELEMENT_TYPE_ID_O
1756 ,p_old_ENTRY_INFORMATION1 => P_ENTRY_INFORMATION1_O
1757 ,p_old_ENTRY_INFORMATION10 => P_ENTRY_INFORMATION10_O
1758 ,p_old_ENTRY_INFORMATION11
1759 => P_ENTRY_INFORMATION11_O
1760 ,p_old_ENTRY_INFORMATION12 => P_ENTRY_INFORMATION12_O
1761 ,p_old_ENTRY_INFORMATION13 => P_ENTRY_INFORMATION13_O
1762 ,p_old_ENTRY_INFORMATION14 => P_ENTRY_INFORMATION14_O
1763
1764 ,p_old_ENTRY_INFORMATION15 => P_ENTRY_INFORMATION15_O
1765 ,p_old_ENTRY_INFORMATION16 => P_ENTRY_INFORMATION16_O
1766 ,p_old_ENTRY_INFORMATION17 => P_ENTRY_INFORMATION17_O
1767 ,p_old_ENTRY_INFORMATION18
1768 => P_ENTRY_INFORMATION18_O
1769 ,p_old_ENTRY_INFORMATION19 => P_ENTRY_INFORMATION19_O
1770 ,p_old_ENTRY_INFORMATION2 => P_ENTRY_INFORMATION2_O
1771 ,p_old_ENTRY_INFORMATION20 =>
1772 P_ENTRY_INFORMATION20_O
1773 ,p_old_ENTRY_INFORMATION21 => P_ENTRY_INFORMATION21_O
1774 ,p_old_ENTRY_INFORMATION22 => P_ENTRY_INFORMATION22_O
1775 ,p_old_ENTRY_INFORMATION23 => P_ENTRY_INFORMATION23_O
1776
1777 ,p_old_ENTRY_INFORMATION24 => P_ENTRY_INFORMATION24_O
1778 ,p_old_ENTRY_INFORMATION25 => P_ENTRY_INFORMATION25_O
1779 ,p_old_ENTRY_INFORMATION26 => P_ENTRY_INFORMATION26_O
1780 ,p_old_ENTRY_INFORMATION27
1781 => P_ENTRY_INFORMATION27_O
1782 ,p_old_ENTRY_INFORMATION28 => P_ENTRY_INFORMATION28_O
1783 ,p_old_ENTRY_INFORMATION29 => P_ENTRY_INFORMATION29_O
1784 ,p_old_ENTRY_INFORMATION3 =>
1785 P_ENTRY_INFORMATION3_O
1786 ,p_old_ENTRY_INFORMATION30 => P_ENTRY_INFORMATION30_O
1787 ,p_old_ENTRY_INFORMATION4 => P_ENTRY_INFORMATION4_O
1788 ,p_old_ENTRY_INFORMATION5 => P_ENTRY_INFORMATION5_O
1789
1790 ,p_old_ENTRY_INFORMATION6 => P_ENTRY_INFORMATION6_O
1791 ,p_old_ENTRY_INFORMATION7 => P_ENTRY_INFORMATION7_O
1792 ,p_old_ENTRY_INFORMATION8 => P_ENTRY_INFORMATION8_O
1793 ,p_old_ENTRY_INFORMATION9
1794 => P_ENTRY_INFORMATION9_O
1795 ,p_old_ENTRY_INFORMATION_CATEGO => P_ENTRY_INFORMATION_CATEGORY_O
1796 ,p_old_ENTRY_TYPE => P_ENTRY_TYPE_O
1797 ,p_old_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER_O
1798
1799 ,p_old_ORIGINAL_ENTRY_ID => P_ORIGINAL_ENTRY_ID_O
1800 ,p_old_PERSONAL_PAYMENT_METHOD_ => P_PERSONAL_PAYMENT_METHOD_ID_O
1801 ,p_old_REASON => P_REASON_O
1802 ,p_old_SOURCE_ID
1803 => P_SOURCE_ID_O
1804 ,p_old_SUBPRIORITY => P_SUBPRIORITY_O
1805 ,p_old_TARGET_ENTRY_ID => P_TARGET_ENTRY_ID_O
1806 ,p_old_UPDATING_ACTION_ID => P_UPDATING_ACTION_ID_O
1807
1808 ,p_old_UPDATING_ACTION_TYPE => P_UPDATING_ACTION_TYPE_O
1809 );
1810 end if;
1811
1812 --
1813 pay_dyn_triggers.g_dyt_mode := l_mode;
1814
1815 --
1816 EXCEPTION
1817 WHEN OTHERS THEN
1818 hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
1819 pay_dyn_triggers.g_dyt_mode
1820 := l_mode;
1821 RAISE;
1822 --
1823 END AFTER_DELETE;
1824
1825 --
1826
1827 /* END_PACKAGE */
1828 END PAY_DYT_ELEMENT_ENTRIES_PKG;
1829