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