[Home] [Help]
PACKAGE BODY: APPS.PAY_DYT_DURATION_SUMMARY_PKG
Source
1 package body PAY_DYT_DURATION_SUMMARY_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_DURATION_SUMMARY_PKG
23 Base Table: PQP_GAP_DURATION_SUMMARY
24 Date: 03/01/2007 23:17
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: PQP_GAP_DURATION_SUMMARY_A_ARD
39 TABLE: PQP_GAP_DURATION_SUMMARY
40 ACTION: DELETE
41 GENERATED DATE: 03/01/2007 23:17
42 DESCRIPTION: INCIDENT REGISTER TRIGGER ON DELETE OF
43 PQP_GAP_DURATION_SUMMARY
44 FULL TRIGGER NAME: PQP_GAP_DURATION_SUMMARY_ARD
45 ================================================
46 */
47 --
48 PROCEDURE PQP_GAP_DURATION_SUMMARY_A_ARD
49 (
50 P_OLD_ASSIGNMENT_ID IN NUMBER
51 ,P_OLD_DATE_START
52 IN DATE
53 ,P_OLD_GAP_DURATION_SUMMARY_ID IN NUMBER
54 ) IS
55
56 --
57 /* LOCAL VARIABLE DECLARATIONS */
58 L_ASSIGNMENT_ID NUMBER;
59 L_BUSINESS_GROUP_ID NUMBER;
60 L_DATE_START DATE;
61
62 L_LEGISLATION_CODE VARCHAR2(30);
63 BEGIN
64 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_GAP_DURATION_SUMMARY_ARD');
65 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
66 RETURN;
67 END IF;
68 /* INITIALISING LOCAL
69 VARIABLES */
70 L_ASSIGNMENT_ID := P_OLD_ASSIGNMENT_ID;
71 --
72 L_DATE_START := P_OLD_DATE_START;
73 --
74 SELECT BUSINESS_GROUP_ID
75 INTO L_BUSINESS_GROUP_ID
76 FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = L_ASSIGNMENT_ID AND L_DATE_START BETWEEN
77 EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
78 --
79 SELECT LEGISLATION_CODE
80 INTO L_LEGISLATION_CODE
81 FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
82 --
83 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
84 IF
85 PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
86 P_EVENT_ID => 1154,
87 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
88 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
89 P_PAYROLL_ID => NULL
90 ) THEN
91 RETURN;
92 END IF;
93 --
94 /* GLOBAL COMPONENT
95 CALLS */
96 PAY_MISC_DYT_INCIDENT_PKG.PQP_GAP_DURATION_SUMMARY_ARD(
97 P_ASSIGNMENT_ID => P_OLD_ASSIGNMENT_ID,
98 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
99 P_EFFECTIVE_START_DATE => P_OLD_DATE_START,
100
101 P_GAP_DURATION_SUMMARY_ID => P_OLD_GAP_DURATION_SUMMARY_ID,
102 P_LEGISLATION_CODE => L_LEGISLATION_CODE
103 );
104 --
105 /* LEGISLATION SPECIFIC COMPONENT CALLS */
106 --
107 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
108 --
109 /* PAYROLL
110 SPECIFIC COMPONENT CALLS */
111 --
112 EXCEPTION
113 WHEN OTHERS THEN
114 HR_UTILITY.SET_LOCATION('PQP_GAP_DURATION_SUMMARY_A_ARD',ABS(SQLCODE));
115 RAISE;
116 --
117 END PQP_GAP_DURATION_SUMMARY_A_ARD;
118
119 --
120
121 /*
122 ================================================
123 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
124 WITH CODE REPRESENTING A DYNAMIC TRIGGER
125 ================================================
126 ** DO NOT CHANGE MANUALLY **
127
128 ------------------------------------------------
129 NAME: PQP_GAP_DURATION_SUMMARY_A_ARI
130 TABLE: PQP_GAP_DURATION_SUMMARY
131 ACTION: INSERT
132 GENERATED DATE: 03/01/2007 23:17
133 DESCRIPTION: INCIDENT REGISTER TRIGGER ON INSERT OF
134 PQP_GAP_DURATION_SUMMARY
135 FULL TRIGGER NAME: PQP_GAP_DURATION_SUMMARY_ARI
136 ================================================
137 */
138 --
139 PROCEDURE PQP_GAP_DURATION_SUMMARY_A_ARI
140 (
141 P_NEW_ASSIGNMENT_ID IN NUMBER
142 ,P_NEW_DATE_END
143 IN DATE
144 ,P_NEW_DATE_START IN DATE
145 ,P_NEW_DURATION_IN_DAYS IN NUMBER
146 ,P_NEW_DURATION_IN_HOURS IN NUMBER
147 ,P_NEW_GAP_DURATION_SUMMARY_ID IN NUMBER
148
149 ,P_NEW_GAP_LEVEL IN VARCHAR2
150 ,P_NEW_SUMMARY_TYPE IN VARCHAR2
151 ) IS
152
153 --
154 /* LOCAL VARIABLE DECLARATIONS */
155 L_ASSIGNMENT_ID NUMBER;
156 L_BUSINESS_GROUP_ID NUMBER;
157 L_DATE_START
158 DATE;
159 L_LEGISLATION_CODE VARCHAR2(30);
160 BEGIN
161 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_GAP_DURATION_SUMMARY_ARI');
162 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
163 RETURN;
164 END IF;
165
166 /* INITIALISING LOCAL VARIABLES */
167 L_ASSIGNMENT_ID := P_NEW_ASSIGNMENT_ID;
168 --
169 L_DATE_START := P_NEW_DATE_START;
170 --
171 SELECT BUSINESS_GROUP_ID
172 INTO L_BUSINESS_GROUP_ID
173 FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = L_ASSIGNMENT_ID AND
174 L_DATE_START BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
175 --
176 SELECT LEGISLATION_CODE
177 INTO L_LEGISLATION_CODE
178 FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
179 --
180 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL
181 AREA */
182 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
183 P_EVENT_ID => 1155,
184 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
185 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
186 P_PAYROLL_ID => NULL
187 ) THEN
188 RETURN;
189 END IF;
190 --
191 /*
192 GLOBAL COMPONENT CALLS */
193 PAY_MISC_DYT_INCIDENT_PKG.PQP_GAP_DURATION_SUMMARY_ARI(
194 P_ASSIGNMENT_ID => P_NEW_ASSIGNMENT_ID,
195 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
196 P_EFFECTIVE_START_DATE =>
197 P_NEW_DATE_START,
198 P_GAP_DURATION_SUMMARY_ID => P_NEW_GAP_DURATION_SUMMARY_ID,
199 P_LEGISLATION_CODE => L_LEGISLATION_CODE
200 );
201 --
202 /* LEGISLATION SPECIFIC COMPONENT CALLS */
203 --
204 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
205
206 --
207 /* PAYROLL SPECIFIC COMPONENT CALLS */
208 --
209 EXCEPTION
210 WHEN OTHERS THEN
211 HR_UTILITY.SET_LOCATION('PQP_GAP_DURATION_SUMMARY_A_ARI',ABS(SQLCODE));
212 RAISE;
213 --
214 END PQP_GAP_DURATION_SUMMARY_A_ARI;
215
216 --
217
218 /*
219 ================================================
220 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
221 WITH CODE REPRESENTING A DYNAMIC TRIGGER
222 ================================================
223 ** DO NOT CHANGE MANUALLY **
224
225 ------------------------------------------------
226 NAME: PQP_GAP_DURATION_SUMMARY_A_ARU
227 TABLE: PQP_GAP_DURATION_SUMMARY
228 ACTION: UPDATE
229 GENERATED DATE: 03/01/2007 23:17
230 DESCRIPTION: INCIDENT REGISTER TRIGGER ON UPDATE OF
231 PQP_GAP_DURATION_SUMMARY
232 FULL TRIGGER NAME: PQP_GAP_DURATION_SUMMARY_ARU
233 ================================================
234 */
235 --
236 PROCEDURE PQP_GAP_DURATION_SUMMARY_A_ARU
237 (
238 P_NEW_ASSIGNMENT_ID IN NUMBER
239 ,P_NEW_DATE_END
240 IN DATE
241 ,P_NEW_DATE_START IN DATE
242 ,P_NEW_DURATION_IN_DAYS IN NUMBER
243 ,P_NEW_DURATION_IN_HOURS IN NUMBER
244 ,P_NEW_GAP_DURATION_SUMMARY_ID IN NUMBER
245
246 ,P_NEW_GAP_LEVEL IN VARCHAR2
247 ,P_NEW_SUMMARY_TYPE IN VARCHAR2
248 ,P_OLD_ASSIGNMENT_ID IN NUMBER
249 ,P_OLD_DATE_END IN DATE
250 ,P_OLD_DATE_START
251 IN DATE
252 ,P_OLD_DURATION_IN_DAYS IN NUMBER
253 ,P_OLD_DURATION_IN_HOURS IN NUMBER
254 ,P_OLD_GAP_LEVEL IN VARCHAR2
255 ,P_OLD_SUMMARY_TYPE IN VARCHAR2
256 ) IS
257
258 --
259
260 /* LOCAL VARIABLE DECLARATIONS */
261 L_ASSIGNMENT_ID NUMBER;
262 L_BUSINESS_GROUP_ID NUMBER;
263 L_DATE_START DATE;
264 L_LEGISLATION_CODE VARCHAR2(30);
265 BEGIN
266 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE
267 VERSION OF DYNAMIC TRIGGER: PQP_GAP_DURATION_SUMMARY_ARU');
268 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
269 RETURN;
270 END IF;
271 /* INITIALISING LOCAL VARIABLES */
272 L_ASSIGNMENT_ID := P_NEW_ASSIGNMENT_ID;
273 --
274 L_DATE_START := P_NEW_DATE_START;
275
276 --
277 SELECT BUSINESS_GROUP_ID
278 INTO L_BUSINESS_GROUP_ID
279 FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = L_ASSIGNMENT_ID AND L_DATE_START BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
280 --
281 SELECT LEGISLATION_CODE
282 INTO L_LEGISLATION_CODE
283
284 FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
285 --
286 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
287 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
288 P_EVENT_ID => 1156,
289 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
290
291 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
292 P_PAYROLL_ID => NULL
293 ) THEN
294 RETURN;
295 END IF;
296 --
297 /* GLOBAL COMPONENT CALLS */
298 PAY_MISC_DYT_INCIDENT_PKG.PQP_GAP_DURATION_SUMMARY_ARU(
299 P_ASSIGNMENT_ID =>
300 P_NEW_ASSIGNMENT_ID,
301 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
302 P_EFFECTIVE_DATE => P_NEW_DATE_START,
303 P_GAP_DURATION_SUMMARY_ID => P_NEW_GAP_DURATION_SUMMARY_ID,
304 P_LEGISLATION_CODE =>
305 L_LEGISLATION_CODE,
306 P_NEW_DATE_END => P_NEW_DATE_END,
307 P_NEW_DATE_START => P_NEW_DATE_START,
308 P_NEW_DURATION_IN_DAYS => P_NEW_DURATION_IN_DAYS,
309 P_NEW_DURATION_IN_HOURS => P_NEW_DURATION_IN_HOURS,
310
311 P_OLD_DATE_END => P_OLD_DATE_END,
312 P_OLD_DATE_START => P_OLD_DATE_START,
313 P_OLD_DURATION_IN_DAYS => P_OLD_DURATION_IN_DAYS,
314 P_OLD_DURATION_IN_HOURS => P_OLD_DURATION_IN_HOURS
315 );
316 --
317 /*
318 LEGISLATION SPECIFIC COMPONENT CALLS */
319 --
320 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
321 --
322 /* PAYROLL SPECIFIC COMPONENT CALLS */
323 --
324 EXCEPTION
325 WHEN OTHERS THEN
326 HR_UTILITY.SET_LOCATION('PQP_GAP_DURATION_SUMMARY_A_ARU',ABS(SQLCODE));
327
328 RAISE;
329 --
330 END PQP_GAP_DURATION_SUMMARY_A_ARU;
331
332 --
333
334 /*
335 ================================================
336 This is a dynamically generated procedure.
337 Will be called by API.
338 ================================================
339 ** DO NOT CHANGE MANUALLY **
340
341 ------------------------------------------------
342 Name: AFTER_INSERT
343 Table: PQP_GAP_DURATION_SUMMARY
344 Action: INSERT
345 Generated Date: 03/01/2007 23:17
346 Description: Called as part of INSERT process
347
348 ================================================
349 */
350
351 --
352 PROCEDURE AFTER_INSERT
353 (
354 P_GAP_DURATION_SUMMARY_ID in NUMBER
355 ,P_ASSIGNMENT_ID in NUMBER
356 ,P_GAP_ABSENCE_PLAN_ID in NUMBER
357
358 ,P_SUMMARY_TYPE in VARCHAR2
359 ,P_GAP_LEVEL in VARCHAR2
360 ,P_DURATION_IN_DAYS in NUMBER
361 ,P_DURATION_IN_HOURS in NUMBER
362 ,P_DATE_START
363 in DATE
364 ,P_DATE_END in DATE
365 ,P_OBJECT_VERSION_NUMBER in NUMBER
366 ) IS
367 l_mode varchar2(80);
368
369 --
370 BEGIN
371
372 --
373 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
374
375 /* Mechanism for event capture to know whats occurred */
376 l_mode := pay_dyn_triggers.g_dyt_mode;
377 pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
378
379 --
380
381 if (paywsdyg_pkg.trigger_enabled('PQP_GAP_DURATION_SUMMARY_ARI')) then
382 PQP_GAP_DURATION_SUMMARY_A_ARI(
383 p_new_ASSIGNMENT_ID => P_ASSIGNMENT_ID
384 ,p_new_DATE_END => P_DATE_END
385
386 ,p_new_DATE_START => P_DATE_START
387 ,p_new_DURATION_IN_DAYS => P_DURATION_IN_DAYS
388 ,p_new_DURATION_IN_HOURS => P_DURATION_IN_HOURS
389 ,p_new_GAP_DURATION_SUMMARY_ID =>
390 P_GAP_DURATION_SUMMARY_ID
391 ,p_new_GAP_LEVEL => P_GAP_LEVEL
392 ,p_new_SUMMARY_TYPE => P_SUMMARY_TYPE
393 );
394 end if;
395
396 --
397 pay_dyn_triggers.g_dyt_mode := l_mode;
398
399 --
400 EXCEPTION
401 WHEN OTHERS THEN
402
403 hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
404 pay_dyn_triggers.g_dyt_mode := l_mode;
405 RAISE;
406 --
407 END AFTER_INSERT;
408
409 --
410
411 /*
412 ================================================
413 This is a dynamically generated procedure.
414 Will be called by API.
415 ================================================
416 ** DO NOT CHANGE MANUALLY **
417
418 ------------------------------------------------
419 Name: AFTER_UPDATE
420 Table: PQP_GAP_DURATION_SUMMARY
421 Action: UPDATE
422 Generated Date: 03/01/2007 23:17
423 Description: Called as part of UPDATE process
424
425 ================================================
426 */
427
428 --
429 PROCEDURE AFTER_UPDATE
430 (
431 P_GAP_DURATION_SUMMARY_ID in NUMBER
432 ,P_ASSIGNMENT_ID in NUMBER
433 ,P_GAP_ABSENCE_PLAN_ID in NUMBER
434
435 ,P_SUMMARY_TYPE in VARCHAR2
436 ,P_GAP_LEVEL in VARCHAR2
437 ,P_DURATION_IN_DAYS in NUMBER
438 ,P_DURATION_IN_HOURS in NUMBER
439 ,P_DATE_START
440 in DATE
441 ,P_DATE_END in DATE
442 ,P_OBJECT_VERSION_NUMBER in NUMBER
443 ,P_ASSIGNMENT_ID_O in NUMBER
444 ,P_GAP_ABSENCE_PLAN_ID_O in NUMBER
445
446 ,P_SUMMARY_TYPE_O in VARCHAR2
447 ,P_GAP_LEVEL_O in VARCHAR2
448 ,P_DURATION_IN_DAYS_O in NUMBER
449 ,P_DURATION_IN_HOURS_O in NUMBER
450 ,P_DATE_START_O
451 in DATE
452 ,P_DATE_END_O in DATE
453 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
454 ) IS
455 l_mode varchar2(80);
456
457 --
458 BEGIN
459
460 --
461 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
462
463 /* Mechanism for event capture to know whats occurred */
464 l_mode := pay_dyn_triggers.g_dyt_mode;
465 pay_dyn_triggers.g_dyt_mode := hr_api.g_correction;
466
467 --
468
469 if (paywsdyg_pkg.trigger_enabled('PQP_GAP_DURATION_SUMMARY_ARU')) then
470 PQP_GAP_DURATION_SUMMARY_A_ARU(
471 p_new_ASSIGNMENT_ID => P_ASSIGNMENT_ID
472 ,p_new_DATE_END => P_DATE_END
473
474 ,p_new_DATE_START => P_DATE_START
475 ,p_new_DURATION_IN_DAYS => P_DURATION_IN_DAYS
476 ,p_new_DURATION_IN_HOURS => P_DURATION_IN_HOURS
477 ,p_new_GAP_DURATION_SUMMARY_ID =>
478 P_GAP_DURATION_SUMMARY_ID
479 ,p_new_GAP_LEVEL => P_GAP_LEVEL
480 ,p_new_SUMMARY_TYPE => P_SUMMARY_TYPE
481 ,p_old_ASSIGNMENT_ID => P_ASSIGNMENT_ID_O
482 ,p_old_DATE_END
483 => P_DATE_END_O
484 ,p_old_DATE_START => P_DATE_START_O
485 ,p_old_DURATION_IN_DAYS => P_DURATION_IN_DAYS_O
486 ,p_old_DURATION_IN_HOURS => P_DURATION_IN_HOURS_O
487
491 end if;
488 ,p_old_GAP_LEVEL => P_GAP_LEVEL_O
489 ,p_old_SUMMARY_TYPE => P_SUMMARY_TYPE_O
490 );
492
493 --
494 pay_dyn_triggers.g_dyt_mode := l_mode;
495
496 --
497 EXCEPTION
498 WHEN OTHERS THEN
499
500 hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
501 pay_dyn_triggers.g_dyt_mode := l_mode;
502 RAISE;
503 --
504 END AFTER_UPDATE;
505
506 --
507
508 /*
509 ================================================
510 This is a dynamically generated procedure.
511 Will be called by API.
512 ================================================
513 ** DO NOT CHANGE MANUALLY **
514
515 ------------------------------------------------
516 Name: AFTER_DELETE
517 Table: PQP_GAP_DURATION_SUMMARY
518 Action: DELETE
519 Generated Date: 03/01/2007 23:17
520 Description: Called as part of DELETE process
521
522 ================================================
523 */
524
525 --
526 PROCEDURE AFTER_DELETE
527 (
528 P_GAP_DURATION_SUMMARY_ID in NUMBER
529 ,P_ASSIGNMENT_ID_O in NUMBER
530 ,P_GAP_ABSENCE_PLAN_ID_O in NUMBER
531
532 ,P_SUMMARY_TYPE_O in VARCHAR2
533 ,P_GAP_LEVEL_O in VARCHAR2
534 ,P_DURATION_IN_DAYS_O in NUMBER
535 ,P_DURATION_IN_HOURS_O in NUMBER
536 ,P_DATE_START_O
537 in DATE
538 ,P_DATE_END_O in DATE
539 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
540 ) IS
541 l_mode varchar2(80);
542
543 --
544 BEGIN
545
546 --
547 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');
548
549 /* Mechanism for event capture to know whats occurred */
550 l_mode := pay_dyn_triggers.g_dyt_mode;
551 pay_dyn_triggers.g_dyt_mode := hr_api.g_zap;
552
553 --
554
555 if (paywsdyg_pkg.trigger_enabled('PQP_GAP_DURATION_SUMMARY_ARD')) then
556 PQP_GAP_DURATION_SUMMARY_A_ARD(
557 p_old_ASSIGNMENT_ID => P_ASSIGNMENT_ID_O
558 ,p_old_DATE_START => P_DATE_START_O
559
560 ,p_old_GAP_DURATION_SUMMARY_ID => P_GAP_DURATION_SUMMARY_ID
561 );
562 end if;
563
564 --
565 pay_dyn_triggers.g_dyt_mode := l_mode;
566
567 --
568 EXCEPTION
569 WHEN OTHERS THEN
570 hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
571
572 pay_dyn_triggers.g_dyt_mode := l_mode;
573 RAISE;
574 --
575 END AFTER_DELETE;
576
577 --
578
579 /* END_PACKAGE */
580 END PAY_DYT_DURATION_SUMMARY_PKG;
581