[Home] [Help]
PACKAGE BODY: APPS.PAY_DYT_USER_COLUMN_INSTA_PKG
Source
1 package body PAY_DYT_USER_COLUMN_INSTA_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
16 explictly 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_USER_COLUMN_INSTA_PKG
23 Base Table: PAY_USER_COLUMN_INSTANCES_F
24 Date: 03/01/2007 23:13
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_USER_COLUMN_INSTANCES__ARD
39 TABLE: PAY_USER_COLUMN_INSTANCES_F
40 ACTION: DELETE
41 GENERATED DATE: 03/01/2007 23:13
42 DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON DELETE
43 OF PAY_USER_COLUMN_INSTANCES_F
44 FULL TRIGGER NAME: PAY_USER_COLUMN_INSTANCES_F_ARD
45 ================================================
46 */
47 --
48 PROCEDURE PAY_USER_COLUMN_INSTANCES__ARD
49 (
50 P_NEW_DATETRACK_MODE IN VARCHAR2
51
52 ,P_NEW_EFFECTIVE_DATE IN DATE
53 ,P_NEW_EFFECTIVE_END_DATE IN DATE
54 ,P_NEW_EFFECTIVE_START_DATE IN DATE
55 ,P_NEW_USER_COLUMN_INSTANCE_ID IN NUMBER
56 ,P_NEW_VALIDATION_END_DATE
57 IN DATE
58 ,P_NEW_VALIDATION_START_DATE IN DATE
59 ,P_OLD_BUSINESS_GROUP_ID IN NUMBER
60 ,P_OLD_EFFECTIVE_END_DATE IN DATE
61 ,P_OLD_EFFECTIVE_START_DATE IN DATE
62 ,P_OLD_LEGISLATION_CODE
63 IN VARCHAR2
64 ,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
65 ,P_OLD_USER_COLUMN_ID IN NUMBER
66 ,P_OLD_USER_ROW_ID IN NUMBER
67 ,P_OLD_VALUE IN VARCHAR2
68 ) IS
69
70
71 --
72 /* LOCAL VARIABLE DECLARATIONS */
73 L_BUSINESS_GROUP_ID NUMBER;
74 L_LEGISLATION_CODE VARCHAR2(10);
75 BEGIN
76 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_USER_COLUMN_INSTANCES_F_ARD');
77 IF NOT
78 (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
79 RETURN;
80 END IF;
81 /* INITIALISING LOCAL VARIABLES */
82 L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
83 P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM
84 PAY_USER_COLUMN_INSTANCES_F '||' WHERE USER_COLUMN_INSTANCE_ID = '|| P_NEW_USER_COLUMN_INSTANCE_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
85 );
86
87 --
88 L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
89 P_BG_ID => L_BUSINESS_GROUP_ID
90 );
91 --
92 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
93 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
94 P_EVENT_ID =>
95 1140,
96 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
97 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
98 P_PAYROLL_ID => NULL
99 ) THEN
100 RETURN;
101 END IF;
102 --
103 /* GLOBAL COMPONENT CALLS */
104 PAY_CONTINUOUS_CALC.PAY_USER_COL_INSTANCES_F_ARD(
105
106 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
107 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
108 P_NEW_EFFECTIVE_END_DATE => P_NEW_EFFECTIVE_END_DATE,
109 P_NEW_EFFECTIVE_START_DATE => P_NEW_EFFECTIVE_START_DATE,
110
111 P_OLD_EFFECTIVE_END_DATE => P_OLD_EFFECTIVE_END_DATE,
112 P_OLD_EFFECTIVE_START_DATE => P_OLD_EFFECTIVE_START_DATE,
113 P_OLD_USER_COLUMN_INSTANCE_ID => P_NEW_USER_COLUMN_INSTANCE_ID
114 );
115 --
116 /* LEGISLATION SPECIFIC COMPONENT CALLS */
117 --
118
119 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
120 --
121 /* PAYROLL SPECIFIC COMPONENT CALLS */
122 --
123 EXCEPTION
124 WHEN OTHERS THEN
125 HR_UTILITY.SET_LOCATION('PAY_USER_COLUMN_INSTANCES__ARD',ABS(SQLCODE));
126 RAISE;
127 --
128 END
129 PAY_USER_COLUMN_INSTANCES__ARD;
130
131 --
132
133 /*
134 ================================================
135 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
136 WITH CODE REPRESENTING A DYNAMIC TRIGGER
137 ================================================
138 ** DO NOT CHANGE MANUALLY **
139
140 ------------------------------------------------
141 NAME: PAY_USER_COLUMN_INSTANCES__ARI
142 TABLE: PAY_USER_COLUMN_INSTANCES_F
143 ACTION: INSERT
144 GENERATED DATE: 03/01/2007 23:13
145 DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON INSERT
146 OF PAY_USER_COLUMN_INSTANCES_F
147 FULL TRIGGER NAME: PAY_USER_COLUMN_INSTANCES_F_ARI
148 ================================================
149 */
150 --
151 PROCEDURE PAY_USER_COLUMN_INSTANCES__ARI
152 (
153 P_NEW_BUSINESS_GROUP_ID IN NUMBER
154
155 ,P_NEW_EFFECTIVE_DATE IN DATE
156 ,P_NEW_EFFECTIVE_END_DATE IN DATE
157 ,P_NEW_EFFECTIVE_START_DATE IN DATE
158 ,P_NEW_LEGISLATION_CODE IN VARCHAR2
159 ,P_NEW_OBJECT_VERSION_NUMBER
160 IN NUMBER
161 ,P_NEW_USER_COLUMN_ID IN NUMBER
162 ,P_NEW_USER_COLUMN_INSTANCE_ID IN NUMBER
163 ,P_NEW_USER_ROW_ID IN NUMBER
164 ,P_NEW_VALIDATION_END_DATE IN DATE
165
166 ,P_NEW_VALIDATION_START_DATE IN DATE
167 ,P_NEW_VALUE IN VARCHAR2
168 ) IS
169
170 --
171 /* LOCAL VARIABLE DECLARATIONS */
172 L_BUSINESS_GROUP_ID NUMBER;
173 L_LEGISLATION_CODE VARCHAR2(10);
174 BEGIN
175
176 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_USER_COLUMN_INSTANCES_F_ARI');
177 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
178 RETURN;
179 END IF;
180 /* INITIALISING LOCAL VARIABLES */
181 L_BUSINESS_GROUP_ID :=
182 PAY_CORE_UTILS.GET_BUSINESS_GROUP(
183 P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM PAY_USER_COLUMN_INSTANCES_F '||' WHERE USER_COLUMN_INSTANCE_ID = '|| P_NEW_USER_COLUMN_INSTANCE_ID||' AND
184 TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
185 );
186 --
187 L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
188 P_BG_ID =>
189 L_BUSINESS_GROUP_ID
190 );
191 --
192 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
193 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
194 P_EVENT_ID => 1141,
195 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
196 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
197
198 P_PAYROLL_ID => NULL
199 ) THEN
200 RETURN;
201 END IF;
202 --
203 /* GLOBAL COMPONENT CALLS */
204 PAY_CONTINUOUS_CALC.PAY_USER_COL_INSTANCES_F_ARI(
205 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
206 P_EFFECTIVE_START_DATE =>
207 P_NEW_EFFECTIVE_START_DATE,
208 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
209 P_USER_COLUMN_INSTANCE_ID => P_NEW_USER_COLUMN_INSTANCE_ID
210 );
211 --
212 /* LEGISLATION SPECIFIC COMPONENT CALLS */
213 --
214 /* BUSINESS GROUP SPECIFIC COMPONENT
215 CALLS */
216 --
217 /* PAYROLL SPECIFIC COMPONENT CALLS */
218 --
219 EXCEPTION
220 WHEN OTHERS THEN
221 HR_UTILITY.SET_LOCATION('PAY_USER_COLUMN_INSTANCES__ARI',ABS(SQLCODE));
222 RAISE;
223 --
224 END PAY_USER_COLUMN_INSTANCES__ARI;
225
226 --
227
228 /*
229 ================================================
230 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
231 WITH CODE REPRESENTING A DYNAMIC TRIGGER
232 ================================================
233 ** DO NOT CHANGE MANUALLY **
234
235 ------------------------------------------------
236 NAME: PAY_USER_COLUMN_INSTANCES__ARU
237 TABLE: PAY_USER_COLUMN_INSTANCES_F
238 ACTION: UPDATE
239 GENERATED DATE: 03/01/2007 23:13
240 DESCRIPTION: CONTINUOUS CALCUATION TRIGGER ON UPDATE
241 OF PAY_USER_COLUMN_INSTANCES_F
242 FULL TRIGGER NAME: PAY_USER_COLUMN_INSTANCES_F_ARU
243 ================================================
244 */
245 --
246 PROCEDURE PAY_USER_COLUMN_INSTANCES__ARU
247 (
248 P_NEW_DATETRACK_MODE IN VARCHAR2
249
250 ,P_NEW_EFFECTIVE_DATE IN DATE
251 ,P_NEW_EFFECTIVE_END_DATE IN DATE
252 ,P_NEW_EFFECTIVE_START_DATE IN DATE
253 ,P_NEW_OBJECT_VERSION_NUMBER IN NUMBER
254 ,P_NEW_USER_COLUMN_INSTANCE_ID
255 IN NUMBER
256 ,P_NEW_VALIDATION_END_DATE IN DATE
257 ,P_NEW_VALIDATION_START_DATE IN DATE
258 ,P_NEW_VALUE IN VARCHAR2
259 ,P_OLD_BUSINESS_GROUP_ID IN NUMBER
260
261 ,P_OLD_EFFECTIVE_END_DATE IN DATE
262 ,P_OLD_EFFECTIVE_START_DATE IN DATE
263 ,P_OLD_LEGISLATION_CODE IN VARCHAR2
264 ,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
265 ,P_OLD_USER_COLUMN_ID
266 IN NUMBER
267 ,P_OLD_USER_ROW_ID IN NUMBER
268 ,P_OLD_VALUE IN VARCHAR2
269 ) IS
270
271 --
272 /* LOCAL VARIABLE DECLARATIONS */
273 L_BUSINESS_GROUP_ID NUMBER;
274 L_LEGISLATION_CODE
275 VARCHAR2(10);
276 BEGIN
277 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_USER_COLUMN_INSTANCES_F_ARU');
278 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
279 RETURN;
280 END IF;
281 /* INITIALISING LOCAL VARIABLES */
282
283 L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
284 P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM PAY_USER_COLUMN_INSTANCES_F '||' WHERE USER_COLUMN_INSTANCE_ID = '|| P_NEW_USER_COLUMN_INSTANCE_ID||' AND
285 TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||
286 ''',''DD-MON-YYYY'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
287 );
288 --
289 L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
290 P_BG_ID =>
291 L_BUSINESS_GROUP_ID
292 );
293 --
294 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
295 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
296 P_EVENT_ID => 1142,
297 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
298 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
299
300 P_PAYROLL_ID => NULL
301 ) THEN
302 RETURN;
303 END IF;
304 --
305 /* GLOBAL COMPONENT CALLS */
306 PAY_CONTINUOUS_CALC.PAY_USER_COL_INSTANCES_F_ARU(
307 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
308 P_EFFECTIVE_DATE =>
309 P_NEW_EFFECTIVE_START_DATE,
310 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
311 P_NEW_BUSINESS_GROUP_ID => P_OLD_BUSINESS_GROUP_ID,
312 P_NEW_EFFECTIVE_END_DATE => P_NEW_EFFECTIVE_END_DATE,
313 P_NEW_EFFECTIVE_START_DATE =>
314 P_NEW_EFFECTIVE_START_DATE,
315 P_NEW_LEGISLATION_CODE => P_OLD_LEGISLATION_CODE,
316 P_NEW_USER_COLUMN_ID => P_OLD_USER_COLUMN_ID,
317 P_NEW_USER_COLUMN_INSTANCE_ID => P_NEW_USER_COLUMN_INSTANCE_ID,
318 P_NEW_USER_ROW_ID
319 => P_OLD_USER_ROW_ID,
320 P_NEW_VALUE => P_NEW_VALUE,
321 P_OLD_BUSINESS_GROUP_ID => P_OLD_BUSINESS_GROUP_ID,
322 P_OLD_EFFECTIVE_END_DATE => P_OLD_EFFECTIVE_END_DATE,
323 P_OLD_EFFECTIVE_START_DATE =>
324 P_OLD_EFFECTIVE_START_DATE,
325 P_OLD_LEGISLATION_CODE => P_OLD_LEGISLATION_CODE,
326 P_OLD_USER_COLUMN_ID => P_OLD_USER_COLUMN_ID,
327 P_OLD_USER_COLUMN_INSTANCE_ID => P_NEW_USER_COLUMN_INSTANCE_ID,
328 P_OLD_USER_ROW_ID
329 => P_OLD_USER_ROW_ID,
330 P_OLD_VALUE => P_OLD_VALUE
331 );
332 --
333 /* LEGISLATION SPECIFIC COMPONENT CALLS */
334 --
335 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
336 --
337 /* PAYROLL SPECIFIC COMPONENT CALLS */
338 --
339 EXCEPTION
340 WHEN OTHERS
341 THEN
342 HR_UTILITY.SET_LOCATION('PAY_USER_COLUMN_INSTANCES__ARU',ABS(SQLCODE));
343 RAISE;
344 --
345 END PAY_USER_COLUMN_INSTANCES__ARU;
346
347 --
348
349 /*
350 ================================================
351 This is a dynamically generated procedure.
352 Will be called by API.
353 ================================================
354 ** DO NOT CHANGE MANUALLY **
355
356 ------------------------------------------------
357 Name: AFTER_INSERT
358 Table: PAY_USER_COLUMN_INSTANCES_F
359 Action: INSERT
360 Generated Date: 03/01/2007 23:13
361 Description: Called as part of INSERT process
362
363 ================================================
364 */
365
366 --
367 PROCEDURE AFTER_INSERT
368 (
369 P_EFFECTIVE_DATE in DATE
370 ,P_VALIDATION_START_DATE in DATE
371 ,P_VALIDATION_END_DATE in DATE
372
373 ,P_USER_COLUMN_INSTANCE_ID in NUMBER
374 ,P_EFFECTIVE_START_DATE in DATE
375 ,P_EFFECTIVE_END_DATE in DATE
376 ,P_USER_ROW_ID in NUMBER
377 ,P_USER_COLUMN_ID
378 in NUMBER
379 ,P_BUSINESS_GROUP_ID in NUMBER
380 ,P_LEGISLATION_CODE in VARCHAR2
381 ,P_VALUE in VARCHAR2
382 ,P_OBJECT_VERSION_NUMBER in NUMBER
383 ) IS
384 l_mode
385 varchar2(80);
386
387 --
388 BEGIN
389
390 --
391 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
392 /* Mechanism for event capture to know whats occurred */
393 l_mode := pay_dyn_triggers.g_dyt_mode;
394 pay_dyn_triggers.g_dyt_mode :=
395 hr_api.g_insert;
396
397 --
398
399 if (paywsdyg_pkg.trigger_enabled('PAY_USER_COLUMN_INSTANCES_F_ARI')) then
400 PAY_USER_COLUMN_INSTANCES__ARI(
401 p_new_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
402 ,p_new_EFFECTIVE_DATE => P_EFFECTIVE_DATE
403
404 ,p_new_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
405 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
406 ,p_new_LEGISLATION_CODE => P_LEGISLATION_CODE
407 ,p_new_OBJECT_VERSION_NUMBER
408 => P_OBJECT_VERSION_NUMBER
409 ,p_new_USER_COLUMN_ID => P_USER_COLUMN_ID
410 ,p_new_USER_COLUMN_INSTANCE_ID => P_USER_COLUMN_INSTANCE_ID
411 ,p_new_USER_ROW_ID => P_USER_ROW_ID
412
413 ,p_new_VALIDATION_END_DATE => P_VALIDATION_END_DATE
414 ,p_new_VALIDATION_START_DATE => P_VALIDATION_START_DATE
415 ,p_new_VALUE => P_VALUE
416 );
417 end if;
418
419 --
420 pay_dyn_triggers.g_dyt_mode :=
421 l_mode;
422
423 --
424 EXCEPTION
425 WHEN OTHERS THEN
426 hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
427 pay_dyn_triggers.g_dyt_mode := l_mode;
428 RAISE;
429 --
430 END AFTER_INSERT;
431
432 --
433
434 /*
435 ================================================
436 This is a dynamically generated procedure.
437 Will be called by API.
438 ================================================
439 ** DO NOT CHANGE MANUALLY **
440
441 ------------------------------------------------
442 Name: AFTER_UPDATE
443 Table: PAY_USER_COLUMN_INSTANCES_F
444 Action: UPDATE
445 Generated Date: 03/01/2007 23:13
446 Description: Called as part of UPDATE process
447
448 ================================================
449 */
450
451 --
452 PROCEDURE AFTER_UPDATE
453 (
454 P_EFFECTIVE_DATE in DATE
455 ,P_DATETRACK_MODE in VARCHAR2
456 ,P_VALIDATION_START_DATE in DATE
457
458 ,P_VALIDATION_END_DATE in DATE
459 ,P_USER_COLUMN_INSTANCE_ID in NUMBER
460 ,P_EFFECTIVE_START_DATE in DATE
461 ,P_EFFECTIVE_END_DATE in DATE
462 ,P_VALUE
463 in VARCHAR2
464 ,P_OBJECT_VERSION_NUMBER in NUMBER
465 ,P_EFFECTIVE_START_DATE_O in DATE
466 ,P_EFFECTIVE_END_DATE_O in DATE
467 ,P_USER_ROW_ID_O in NUMBER
468 ,P_USER_COLUMN_ID_O
469 in NUMBER
470 ,P_BUSINESS_GROUP_ID_O in NUMBER
471 ,P_LEGISLATION_CODE_O in VARCHAR2
472 ,P_VALUE_O in VARCHAR2
473 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
474
475 ) IS
476 l_mode varchar2(80);
477
478 --
479 BEGIN
480
481 --
482 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
483 /* Mechanism for event capture to know whats occurred */
484 l_mode := pay_dyn_triggers.g_dyt_mode;
485
486 pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
487
488 --
489
490 if (paywsdyg_pkg.trigger_enabled('PAY_USER_COLUMN_INSTANCES_F_ARU')) then
491 PAY_USER_COLUMN_INSTANCES__ARU(
492 p_new_DATETRACK_MODE => P_DATETRACK_MODE
493 ,p_new_EFFECTIVE_DATE => P_EFFECTIVE_DATE
494
495 ,p_new_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
496 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
497 ,p_new_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
498 ,p_new_USER_COLUMN_INSTANCE_ID
499 => P_USER_COLUMN_INSTANCE_ID
500 ,p_new_VALIDATION_END_DATE => P_VALIDATION_END_DATE
501 ,p_new_VALIDATION_START_DATE => P_VALIDATION_START_DATE
502 ,p_new_VALUE => P_VALUE
503
504 ,p_old_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID_O
505 ,p_old_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE_O
506 ,p_old_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE_O
507 ,p_old_LEGISLATION_CODE
508 => P_LEGISLATION_CODE_O
509 ,p_old_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER_O
510 ,p_old_USER_COLUMN_ID => P_USER_COLUMN_ID_O
511 ,p_old_USER_ROW_ID => P_USER_ROW_ID_O
512
513 ,p_old_VALUE => P_VALUE_O
514 );
515 end if;
516
517 --
518 pay_dyn_triggers.g_dyt_mode := l_mode;
519
520 --
521 EXCEPTION
522 WHEN OTHERS THEN
523 hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
524 pay_dyn_triggers.g_dyt_mode := l_mode;
525
526 RAISE;
527 --
528 END AFTER_UPDATE;
529
530 --
531
532 /*
533 ================================================
534 This is a dynamically generated procedure.
535 Will be called by API.
536 ================================================
537 ** DO NOT CHANGE MANUALLY **
538
539 ------------------------------------------------
540 Name: AFTER_DELETE
541 Table: PAY_USER_COLUMN_INSTANCES_F
542 Action: DELETE
543 Generated Date: 03/01/2007 23:13
544 Description: Called as part of DELETE process
545
546 ================================================
547 */
548
549 --
550 PROCEDURE AFTER_DELETE
551 (
552 P_EFFECTIVE_DATE in DATE
553 ,P_DATETRACK_MODE in VARCHAR2
554 ,P_VALIDATION_START_DATE in DATE
555
556 ,P_VALIDATION_END_DATE in DATE
557 ,P_USER_COLUMN_INSTANCE_ID in NUMBER
558 ,P_EFFECTIVE_START_DATE in DATE
559 ,P_EFFECTIVE_END_DATE in DATE
560 ,P_EFFECTIVE_START_DATE_O
561 in DATE
562 ,P_EFFECTIVE_END_DATE_O in DATE
563 ,P_USER_ROW_ID_O in NUMBER
564 ,P_USER_COLUMN_ID_O in NUMBER
565 ,P_BUSINESS_GROUP_ID_O in NUMBER
566 ,P_LEGISLATION_CODE_O
567 in VARCHAR2
568 ,P_VALUE_O in VARCHAR2
569 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
570 ) IS
571 l_mode varchar2(80);
572
573 --
574 BEGIN
575
576 --
577 hr_utility.trace(' >DYT: Main entry point from row handler,
578 AFTER_DELETE');
579 /* Mechanism for event capture to know whats occurred */
580 l_mode := pay_dyn_triggers.g_dyt_mode;
581 pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
582
583 --
584
585 if (paywsdyg_pkg.trigger_enabled('PAY_USER_COLUMN_INSTANCES_F_ARD')) then
586 PAY_USER_COLUMN_INSTANCES__ARD(
587 p_new_DATETRACK_MODE => P_DATETRACK_MODE
588 ,p_new_EFFECTIVE_DATE => P_EFFECTIVE_DATE
589
590 ,p_new_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
591 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
592 ,p_new_USER_COLUMN_INSTANCE_ID => P_USER_COLUMN_INSTANCE_ID
593 ,p_new_VALIDATION_END_DATE
594 => P_VALIDATION_END_DATE
595 ,p_new_VALIDATION_START_DATE => P_VALIDATION_START_DATE
596 ,p_old_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID_O
597 ,p_old_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE_O
598
599 ,p_old_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE_O
600 ,p_old_LEGISLATION_CODE => P_LEGISLATION_CODE_O
601 ,p_old_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER_O
602 ,p_old_USER_COLUMN_ID
603 => P_USER_COLUMN_ID_O
604 ,p_old_USER_ROW_ID => P_USER_ROW_ID_O
605 ,p_old_VALUE => P_VALUE_O
606 );
607 end if;
608
609 --
610 pay_dyn_triggers.g_dyt_mode := l_mode;
611
612 --
613 EXCEPTION
614 WHEN OTHERS
615 THEN
616 hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
617 pay_dyn_triggers.g_dyt_mode := l_mode;
618 RAISE;
619 --
620 END AFTER_DELETE;
621
622 --
623
624 /* END_PACKAGE */
625 END PAY_DYT_USER_COLUMN_INSTA_PKG;
626