[Home] [Help]
PACKAGE BODY: APPS.PAY_DYT_CONTRACTS_PKG
Source
1 package body PAY_DYT_CONTRACTS_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_CONTRACTS_PKG
23 Base Table: PER_CONTRACTS_F
24 Date: 30/03/2009 04:52
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: PER_CONTRACTS_F_ARU_ARU
39 TABLE: PER_CONTRACTS_F
40 ACTION: UPDATE
41 GENERATED DATE: 30/03/2009 04:52
42 DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON UPDATE OF
43 PER_CONTRACTS_F
44 FULL TRIGGER NAME: PER_CONTRACTS_F_ARU
45 ================================================
46 */
47 --
48 PROCEDURE PER_CONTRACTS_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_CONTRACTUAL_JOB_TITLE IN VARCHAR2
77 ,P_NEW_CONTRACT_ID IN NUMBER
78 ,P_NEW_CTR_INFORMATION1
79 IN VARCHAR2
80 ,P_NEW_CTR_INFORMATION10 IN VARCHAR2
81 ,P_NEW_CTR_INFORMATION11 IN VARCHAR2
82 ,P_NEW_CTR_INFORMATION12 IN VARCHAR2
83 ,P_NEW_CTR_INFORMATION13 IN VARCHAR2
84
85 ,P_NEW_CTR_INFORMATION14 IN VARCHAR2
86 ,P_NEW_CTR_INFORMATION15 IN VARCHAR2
87 ,P_NEW_CTR_INFORMATION16 IN VARCHAR2
88 ,P_NEW_CTR_INFORMATION17 IN VARCHAR2
89
90 ,P_NEW_CTR_INFORMATION18 IN VARCHAR2
91 ,P_NEW_CTR_INFORMATION19 IN VARCHAR2
92 ,P_NEW_CTR_INFORMATION2 IN VARCHAR2
93 ,P_NEW_CTR_INFORMATION20 IN VARCHAR2
94 ,P_NEW_CTR_INFORMATION3
95 IN VARCHAR2
96 ,P_NEW_CTR_INFORMATION4 IN VARCHAR2
97 ,P_NEW_CTR_INFORMATION5 IN VARCHAR2
98 ,P_NEW_CTR_INFORMATION6 IN VARCHAR2
99 ,P_NEW_CTR_INFORMATION7 IN
100 VARCHAR2
101 ,P_NEW_CTR_INFORMATION8 IN VARCHAR2
102 ,P_NEW_CTR_INFORMATION9 IN VARCHAR2
103 ,P_NEW_CTR_INFORMATION_CATEGORY IN VARCHAR2
104 ,P_NEW_DESCRIPTION IN VARCHAR2
105
106 ,P_NEW_DOC_STATUS IN VARCHAR2
107 ,P_NEW_DOC_STATUS_CHANGE_DATE IN DATE
108 ,P_NEW_DURATION IN NUMBER
109 ,P_NEW_DURATION_UNITS IN VARCHAR2
110 ,P_NEW_EFFECTIVE_END_DATE
111 IN DATE
112 ,P_NEW_EFFECTIVE_START_DATE IN DATE
113 ,P_NEW_END_REASON IN VARCHAR2
114 ,P_NEW_EXTENSION_PERIOD IN NUMBER
115 ,P_NEW_EXTENSION_PERIOD_UNITS IN VARCHAR2
116
117 ,P_NEW_EXTENSION_REASON IN VARCHAR2
118 ,P_NEW_NUMBER_OF_EXTENSIONS IN NUMBER
119 ,P_NEW_PARTIES IN VARCHAR2
120 ,P_NEW_REFERENCE IN VARCHAR2
121 ,P_NEW_START_REASON
122 IN VARCHAR2
123 ,P_NEW_STATUS IN VARCHAR2
124 ,P_NEW_STATUS_REASON IN VARCHAR2
125 ,P_NEW_TYPE IN VARCHAR2
126 ,P_OLD_ATTRIBUTE1 IN VARCHAR2
127
128 ,P_OLD_ATTRIBUTE10 IN VARCHAR2
129 ,P_OLD_ATTRIBUTE11 IN VARCHAR2
130 ,P_OLD_ATTRIBUTE12 IN VARCHAR2
131 ,P_OLD_ATTRIBUTE13 IN VARCHAR2
132 ,P_OLD_ATTRIBUTE14
133 IN VARCHAR2
134 ,P_OLD_ATTRIBUTE15 IN VARCHAR2
135 ,P_OLD_ATTRIBUTE16 IN VARCHAR2
136 ,P_OLD_ATTRIBUTE17 IN VARCHAR2
137 ,P_OLD_ATTRIBUTE18 IN
138 VARCHAR2
139 ,P_OLD_ATTRIBUTE19 IN VARCHAR2
140 ,P_OLD_ATTRIBUTE2 IN VARCHAR2
141 ,P_OLD_ATTRIBUTE20 IN VARCHAR2
142 ,P_OLD_ATTRIBUTE3 IN VARCHAR2
143
144 ,P_OLD_ATTRIBUTE4 IN VARCHAR2
145 ,P_OLD_ATTRIBUTE5 IN VARCHAR2
146 ,P_OLD_ATTRIBUTE6 IN VARCHAR2
147 ,P_OLD_ATTRIBUTE7 IN VARCHAR2
148 ,P_OLD_ATTRIBUTE8
149 IN VARCHAR2
150 ,P_OLD_ATTRIBUTE9 IN VARCHAR2
151 ,P_OLD_ATTRIBUTE_CATEGORY IN VARCHAR2
152 ,P_OLD_BUSINESS_GROUP_ID IN NUMBER
153 ,P_OLD_CONTRACTUAL_JOB_TITLE IN VARCHAR2
154
155 ,P_OLD_CTR_INFORMATION1 IN VARCHAR2
156 ,P_OLD_CTR_INFORMATION10 IN VARCHAR2
157 ,P_OLD_CTR_INFORMATION11 IN VARCHAR2
158 ,P_OLD_CTR_INFORMATION12 IN VARCHAR2
159
160 ,P_OLD_CTR_INFORMATION13 IN VARCHAR2
161 ,P_OLD_CTR_INFORMATION14 IN VARCHAR2
162 ,P_OLD_CTR_INFORMATION15 IN VARCHAR2
163 ,P_OLD_CTR_INFORMATION16 IN VARCHAR2
164 ,P_OLD_CTR_INFORMATION17
165 IN VARCHAR2
166 ,P_OLD_CTR_INFORMATION18 IN VARCHAR2
167 ,P_OLD_CTR_INFORMATION19 IN VARCHAR2
168 ,P_OLD_CTR_INFORMATION2 IN VARCHAR2
169 ,P_OLD_CTR_INFORMATION20 IN
170 VARCHAR2
171 ,P_OLD_CTR_INFORMATION3 IN VARCHAR2
172 ,P_OLD_CTR_INFORMATION4 IN VARCHAR2
173 ,P_OLD_CTR_INFORMATION5 IN VARCHAR2
174 ,P_OLD_CTR_INFORMATION6 IN VARCHAR2
175
176 ,P_OLD_CTR_INFORMATION7 IN VARCHAR2
177 ,P_OLD_CTR_INFORMATION8 IN VARCHAR2
178 ,P_OLD_CTR_INFORMATION9 IN VARCHAR2
179 ,P_OLD_CTR_INFORMATION_CATEGORY IN VARCHAR2
180 ,P_OLD_DESCRIPTION
181 IN VARCHAR2
182 ,P_OLD_DOC_STATUS IN VARCHAR2
183 ,P_OLD_DOC_STATUS_CHANGE_DATE IN DATE
184 ,P_OLD_DURATION IN NUMBER
185 ,P_OLD_DURATION_UNITS IN VARCHAR2
186
187 ,P_OLD_EFFECTIVE_END_DATE IN DATE
188 ,P_OLD_EFFECTIVE_START_DATE IN DATE
189 ,P_OLD_END_REASON IN VARCHAR2
190 ,P_OLD_EXTENSION_PERIOD IN NUMBER
191 ,P_OLD_EXTENSION_PERIOD_UNITS
192 IN VARCHAR2
193 ,P_OLD_EXTENSION_REASON IN VARCHAR2
194 ,P_OLD_NUMBER_OF_EXTENSIONS IN NUMBER
195 ,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
196 ,P_OLD_PARTIES IN VARCHAR2
197
198 ,P_OLD_PERSON_ID IN NUMBER
199 ,P_OLD_REFERENCE IN VARCHAR2
200 ,P_OLD_START_REASON IN VARCHAR2
201 ,P_OLD_STATUS IN VARCHAR2
202 ,P_OLD_STATUS_REASON
203 IN VARCHAR2
204 ,P_OLD_TYPE IN VARCHAR2
205 ) IS
206
207 --
208 /* LOCAL VARIABLE DECLARATIONS */
209 L_BUSINESS_GROUP_ID NUMBER;
210 L_LEGISLATION_CODE VARCHAR2(10);
211 BEGIN
212 HR_UTILITY.TRACE(' >DYT:
213 EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PER_CONTRACTS_F_ARU');
214 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
215 RETURN;
216 END IF;
217 /* INITIALISING LOCAL VARIABLES */
218 L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
219 P_STATEMENT
220 => 'SELECT '||P_OLD_BUSINESS_GROUP_ID||' FROM SYS.DUAL'
221 );
222 --
223 L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
224 P_BG_ID => L_BUSINESS_GROUP_ID
225 );
226 --
227 /* IS THE TRIGGER IN AN ENABLED
228 FUNCTIONAL AREA */
229 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
230 P_EVENT_ID => 92,
231 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
232 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
233 P_PAYROLL_ID => NULL
234 ) THEN
235 RETURN;
236 END IF;
237 --
238
239 /* GLOBAL COMPONENT CALLS */
240 PAY_CONTINUOUS_CALC.PER_CONTRACTS_F_ARU(
241 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
242 P_EFFECTIVE_DATE => P_NEW_EFFECTIVE_START_DATE,
243 P_LEGISLATION_CODE =>
244 L_LEGISLATION_CODE,
245 P_NEW_ATTRIBUTE1 => P_NEW_ATTRIBUTE1,
246 P_NEW_ATTRIBUTE10 => P_NEW_ATTRIBUTE10,
247 P_NEW_ATTRIBUTE11 => P_NEW_ATTRIBUTE11,
248 P_NEW_ATTRIBUTE12 => P_NEW_ATTRIBUTE12,
249
250 P_NEW_ATTRIBUTE13 => P_NEW_ATTRIBUTE13,
251 P_NEW_ATTRIBUTE14 => P_NEW_ATTRIBUTE14,
252 P_NEW_ATTRIBUTE15 => P_NEW_ATTRIBUTE15,
253 P_NEW_ATTRIBUTE16 => P_NEW_ATTRIBUTE16,
254 P_NEW_ATTRIBUTE17
255 => P_NEW_ATTRIBUTE17,
256 P_NEW_ATTRIBUTE18 => P_NEW_ATTRIBUTE18,
257 P_NEW_ATTRIBUTE19 => P_NEW_ATTRIBUTE19,
258 P_NEW_ATTRIBUTE2 => P_NEW_ATTRIBUTE2,
259 P_NEW_ATTRIBUTE20 => P_NEW_ATTRIBUTE20,
260
261 P_NEW_ATTRIBUTE3 => P_NEW_ATTRIBUTE3,
262 P_NEW_ATTRIBUTE4 => P_NEW_ATTRIBUTE4,
263 P_NEW_ATTRIBUTE5 => P_NEW_ATTRIBUTE5,
264 P_NEW_ATTRIBUTE6 => P_NEW_ATTRIBUTE6,
265 P_NEW_ATTRIBUTE7
266 => P_NEW_ATTRIBUTE7,
267 P_NEW_ATTRIBUTE8 => P_NEW_ATTRIBUTE8,
268 P_NEW_ATTRIBUTE9 => P_NEW_ATTRIBUTE9,
269 P_NEW_ATTRIBUTE_CATEGORY => P_NEW_ATTRIBUTE_CATEGORY,
270 P_NEW_BUSINESS_GROUP_ID =>
271 P_OLD_BUSINESS_GROUP_ID,
272 P_NEW_CONTRACTUAL_JOB_TITLE => P_NEW_CONTRACTUAL_JOB_TITLE,
273 P_NEW_CONTRACT_ID => P_NEW_CONTRACT_ID,
274 P_NEW_CTR_INFORMATION1 => P_NEW_CTR_INFORMATION1,
275 P_NEW_CTR_INFORMATION10 =>
276 P_NEW_CTR_INFORMATION10,
277 P_NEW_CTR_INFORMATION11 => P_NEW_CTR_INFORMATION11,
278 P_NEW_CTR_INFORMATION12 => P_NEW_CTR_INFORMATION12,
279 P_NEW_CTR_INFORMATION13 => P_NEW_CTR_INFORMATION13,
280 P_NEW_CTR_INFORMATION14 =>
281 P_NEW_CTR_INFORMATION14,
282 P_NEW_CTR_INFORMATION15 => P_NEW_CTR_INFORMATION15,
283 P_NEW_CTR_INFORMATION16 => P_NEW_CTR_INFORMATION16,
284 P_NEW_CTR_INFORMATION17 => P_NEW_CTR_INFORMATION17,
285 P_NEW_CTR_INFORMATION18 =>
286 P_NEW_CTR_INFORMATION18,
287 P_NEW_CTR_INFORMATION19 => P_NEW_CTR_INFORMATION19,
288 P_NEW_CTR_INFORMATION2 => P_NEW_CTR_INFORMATION2,
289 P_NEW_CTR_INFORMATION20 => P_NEW_CTR_INFORMATION20,
290 P_NEW_CTR_INFORMATION3 =>
291 P_NEW_CTR_INFORMATION3,
292 P_NEW_CTR_INFORMATION4 => P_NEW_CTR_INFORMATION4,
293 P_NEW_CTR_INFORMATION5 => P_NEW_CTR_INFORMATION5,
294 P_NEW_CTR_INFORMATION6 => P_NEW_CTR_INFORMATION6,
295 P_NEW_CTR_INFORMATION7 =>
296 P_NEW_CTR_INFORMATION7,
297 P_NEW_CTR_INFORMATION8 => P_NEW_CTR_INFORMATION8,
298 P_NEW_CTR_INFORMATION9 => P_NEW_CTR_INFORMATION9,
299 P_NEW_CTR_INFORMATION_CATEGORY => P_NEW_CTR_INFORMATION_CATEGORY,
300 P_NEW_DESCRIPTION
301 => P_NEW_DESCRIPTION,
302 P_NEW_DOC_STATUS => P_NEW_DOC_STATUS,
303 P_NEW_DOC_STATUS_CHANGE_DATE => P_NEW_DOC_STATUS_CHANGE_DATE,
304 P_NEW_DURATION => P_NEW_DURATION,
305 P_NEW_DURATION_UNITS =>
306 P_NEW_DURATION_UNITS,
307 P_NEW_EFFECTIVE_END_DATE => P_NEW_EFFECTIVE_END_DATE,
308 P_NEW_EFFECTIVE_START_DATE => P_NEW_EFFECTIVE_START_DATE,
309 P_NEW_END_REASON => P_NEW_END_REASON,
310 P_NEW_EXTENSION_PERIOD =>
311 P_NEW_EXTENSION_PERIOD,
312 P_NEW_EXTENSION_PERIOD_UNITS => P_NEW_EXTENSION_PERIOD_UNITS,
313 P_NEW_EXTENSION_REASON => P_NEW_EXTENSION_REASON,
314 P_NEW_NUMBER_OF_EXTENSIONS => P_NEW_NUMBER_OF_EXTENSIONS,
315 P_NEW_PARTIES
316 => P_NEW_PARTIES,
317 P_NEW_PERSON_ID => P_OLD_PERSON_ID,
318 P_NEW_REFERENCE => P_NEW_REFERENCE,
319 P_NEW_START_REASON => P_NEW_START_REASON,
320 P_NEW_STATUS => P_NEW_STATUS,
321
322 P_NEW_STATUS_REASON => P_NEW_STATUS_REASON,
323 P_NEW_TYPE => P_NEW_TYPE,
324 P_OLD_ATTRIBUTE1 => P_OLD_ATTRIBUTE1,
325 P_OLD_ATTRIBUTE10 => P_OLD_ATTRIBUTE10,
326 P_OLD_ATTRIBUTE11
327 => P_OLD_ATTRIBUTE11,
328 P_OLD_ATTRIBUTE12 => P_OLD_ATTRIBUTE12,
329 P_OLD_ATTRIBUTE13 => P_OLD_ATTRIBUTE13,
330 P_OLD_ATTRIBUTE14 => P_OLD_ATTRIBUTE14,
331 P_OLD_ATTRIBUTE15 => P_OLD_ATTRIBUTE15,
332
333 P_OLD_ATTRIBUTE16 => P_OLD_ATTRIBUTE16,
334 P_OLD_ATTRIBUTE17 => P_OLD_ATTRIBUTE17,
335 P_OLD_ATTRIBUTE18 => P_OLD_ATTRIBUTE18,
336 P_OLD_ATTRIBUTE19 => P_OLD_ATTRIBUTE19,
337 P_OLD_ATTRIBUTE2
338 => P_OLD_ATTRIBUTE2,
339 P_OLD_ATTRIBUTE20 => P_OLD_ATTRIBUTE20,
340 P_OLD_ATTRIBUTE3 => P_OLD_ATTRIBUTE3,
341 P_OLD_ATTRIBUTE4 => P_OLD_ATTRIBUTE4,
342 P_OLD_ATTRIBUTE5 => P_OLD_ATTRIBUTE5,
343
344 P_OLD_ATTRIBUTE6 => P_OLD_ATTRIBUTE6,
345 P_OLD_ATTRIBUTE7 => P_OLD_ATTRIBUTE7,
346 P_OLD_ATTRIBUTE8 => P_OLD_ATTRIBUTE8,
347 P_OLD_ATTRIBUTE9 => P_OLD_ATTRIBUTE9,
348 P_OLD_ATTRIBUTE_CATEGORY
349 => P_OLD_ATTRIBUTE_CATEGORY,
350 P_OLD_BUSINESS_GROUP_ID => P_OLD_BUSINESS_GROUP_ID,
351 P_OLD_CONTRACTUAL_JOB_TITLE => P_OLD_CONTRACTUAL_JOB_TITLE,
352 P_OLD_CONTRACT_ID => P_NEW_CONTRACT_ID,
353 P_OLD_CTR_INFORMATION1
354 => P_OLD_CTR_INFORMATION1,
355 P_OLD_CTR_INFORMATION10 => P_OLD_CTR_INFORMATION10,
356 P_OLD_CTR_INFORMATION11 => P_OLD_CTR_INFORMATION11,
357 P_OLD_CTR_INFORMATION12 => P_OLD_CTR_INFORMATION12,
358 P_OLD_CTR_INFORMATION13 =>
359 P_OLD_CTR_INFORMATION13,
360 P_OLD_CTR_INFORMATION14 => P_OLD_CTR_INFORMATION14,
361 P_OLD_CTR_INFORMATION15 => P_OLD_CTR_INFORMATION15,
362 P_OLD_CTR_INFORMATION16 => P_OLD_CTR_INFORMATION16,
363 P_OLD_CTR_INFORMATION17 =>
364 P_OLD_CTR_INFORMATION17,
365 P_OLD_CTR_INFORMATION18 => P_OLD_CTR_INFORMATION18,
366 P_OLD_CTR_INFORMATION19 => P_OLD_CTR_INFORMATION19,
367 P_OLD_CTR_INFORMATION2 => P_OLD_CTR_INFORMATION2,
368 P_OLD_CTR_INFORMATION20 =>
369 P_OLD_CTR_INFORMATION20,
370 P_OLD_CTR_INFORMATION3 => P_OLD_CTR_INFORMATION3,
371 P_OLD_CTR_INFORMATION4 => P_OLD_CTR_INFORMATION4,
372 P_OLD_CTR_INFORMATION5 => P_OLD_CTR_INFORMATION5,
373 P_OLD_CTR_INFORMATION6 =>
374 P_OLD_CTR_INFORMATION6,
375 P_OLD_CTR_INFORMATION7 => P_OLD_CTR_INFORMATION7,
376 P_OLD_CTR_INFORMATION8 => P_OLD_CTR_INFORMATION8,
377 P_OLD_CTR_INFORMATION9 => P_OLD_CTR_INFORMATION9,
378 P_OLD_CTR_INFORMATION_CATEGORY =>
379 P_OLD_CTR_INFORMATION_CATEGORY,
380 P_OLD_DESCRIPTION => P_OLD_DESCRIPTION,
381 P_OLD_DOC_STATUS => P_OLD_DOC_STATUS,
382 P_OLD_DOC_STATUS_CHANGE_DATE => P_OLD_DOC_STATUS_CHANGE_DATE,
383 P_OLD_DURATION =>
384 P_OLD_DURATION,
385 P_OLD_DURATION_UNITS => P_OLD_DURATION_UNITS,
386 P_OLD_EFFECTIVE_END_DATE => P_OLD_EFFECTIVE_END_DATE,
387 P_OLD_EFFECTIVE_START_DATE => P_OLD_EFFECTIVE_START_DATE,
388 P_OLD_END_REASON =>
389 P_OLD_END_REASON,
390 P_OLD_EXTENSION_PERIOD => P_OLD_EXTENSION_PERIOD,
391 P_OLD_EXTENSION_PERIOD_UNITS => P_OLD_EXTENSION_PERIOD_UNITS,
392 P_OLD_EXTENSION_REASON => P_OLD_EXTENSION_REASON,
393 P_OLD_NUMBER_OF_EXTENSIONS =>
394 P_OLD_NUMBER_OF_EXTENSIONS,
395 P_OLD_PARTIES => P_OLD_PARTIES,
396 P_OLD_PERSON_ID => P_OLD_PERSON_ID,
397 P_OLD_REFERENCE => P_OLD_REFERENCE,
398 P_OLD_START_REASON => P_OLD_START_REASON,
399
400 P_OLD_STATUS => P_OLD_STATUS,
401 P_OLD_STATUS_REASON => P_OLD_STATUS_REASON,
402 P_OLD_TYPE => P_OLD_TYPE
403 );
404 --
405 /* LEGISLATION SPECIFIC COMPONENT CALLS */
406 --
407 /* BUSINESS GROUP SPECIFIC COMPONENT
408 CALLS */
409 --
410 /* PAYROLL SPECIFIC COMPONENT CALLS */
411 --
412 EXCEPTION
413 WHEN OTHERS THEN
414 HR_UTILITY.SET_LOCATION('PER_CONTRACTS_F_ARU_ARU',ABS(SQLCODE));
415 RAISE;
416 --
417 END PER_CONTRACTS_F_ARU_ARU;
418
419 --
420
421 /*
422 ================================================
423 This is a dynamically generated procedure.
424 Will be called by API.
425 ================================================
426 ** DO NOT CHANGE MANUALLY **
427
428 ------------------------------------------------
429 Name: AFTER_INSERT
430 Table: PER_CONTRACTS_F
431 Action: INSERT
432 Generated Date: 30/03/2009 04:52
433 Description: Called as part of INSERT process
434
435 ================================================
436 */
437
438 --
439 PROCEDURE AFTER_INSERT
440 (
441 P_CONTRACT_ID in NUMBER
442 ,P_EFFECTIVE_START_DATE in DATE
443 ,P_EFFECTIVE_END_DATE in DATE
444
445 ,P_BUSINESS_GROUP_ID in NUMBER
446 ,P_OBJECT_VERSION_NUMBER in NUMBER
447 ,P_PERSON_ID in NUMBER
448 ,P_REFERENCE in VARCHAR2
449 ,P_TYPE
450 in VARCHAR2
451 ,P_STATUS in VARCHAR2
452 ,P_STATUS_REASON in VARCHAR2
453 ,P_DOC_STATUS in VARCHAR2
454 ,P_DOC_STATUS_CHANGE_DATE in DATE
455
456 ,P_DESCRIPTION in VARCHAR2
457 ,P_DURATION in NUMBER
458 ,P_DURATION_UNITS in VARCHAR2
459 ,P_CONTRACTUAL_JOB_TITLE in VARCHAR2
460 ,P_PARTIES
461 in VARCHAR2
462 ,P_START_REASON in VARCHAR2
463 ,P_END_REASON in VARCHAR2
464 ,P_NUMBER_OF_EXTENSIONS in NUMBER
465 ,P_EXTENSION_REASON in VARCHAR2
466
467 ,P_EXTENSION_PERIOD in NUMBER
468 ,P_EXTENSION_PERIOD_UNITS in VARCHAR2
469 ,P_CTR_INFORMATION_CATEGORY in VARCHAR2
470 ,P_CTR_INFORMATION1 in VARCHAR2
471 ,P_CTR_INFORMATION2
472 in VARCHAR2
473 ,P_CTR_INFORMATION3 in VARCHAR2
474 ,P_CTR_INFORMATION4 in VARCHAR2
475 ,P_CTR_INFORMATION5 in VARCHAR2
476 ,P_CTR_INFORMATION6 in VARCHAR2
477
478 ,P_CTR_INFORMATION7 in VARCHAR2
479 ,P_CTR_INFORMATION8 in VARCHAR2
480 ,P_CTR_INFORMATION9 in VARCHAR2
481 ,P_CTR_INFORMATION10 in VARCHAR2
482 ,P_CTR_INFORMATION11
483 in VARCHAR2
484 ,P_CTR_INFORMATION12 in VARCHAR2
485 ,P_CTR_INFORMATION13 in VARCHAR2
486 ,P_CTR_INFORMATION14 in VARCHAR2
487 ,P_CTR_INFORMATION15 in
488 VARCHAR2
489 ,P_CTR_INFORMATION16 in VARCHAR2
490 ,P_CTR_INFORMATION17 in VARCHAR2
491 ,P_CTR_INFORMATION18 in VARCHAR2
492 ,P_CTR_INFORMATION19 in VARCHAR2
493
494 ,P_CTR_INFORMATION20 in VARCHAR2
495 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
496 ,P_ATTRIBUTE1 in VARCHAR2
497 ,P_ATTRIBUTE2 in VARCHAR2
498 ,P_ATTRIBUTE3
499 in VARCHAR2
500 ,P_ATTRIBUTE4 in VARCHAR2
501 ,P_ATTRIBUTE5 in VARCHAR2
502 ,P_ATTRIBUTE6 in VARCHAR2
503 ,P_ATTRIBUTE7 in
504 VARCHAR2
505 ,P_ATTRIBUTE8 in VARCHAR2
506 ,P_ATTRIBUTE9 in VARCHAR2
507 ,P_ATTRIBUTE10 in VARCHAR2
508 ,P_ATTRIBUTE11 in VARCHAR2
509 ,P_ATTRIBUTE12
510 in VARCHAR2
511 ,P_ATTRIBUTE13 in VARCHAR2
512 ,P_ATTRIBUTE14 in VARCHAR2
513 ,P_ATTRIBUTE15 in VARCHAR2
514 ,P_ATTRIBUTE16
515 in VARCHAR2
516 ,P_ATTRIBUTE17 in VARCHAR2
517 ,P_ATTRIBUTE18 in VARCHAR2
518 ,P_ATTRIBUTE19 in VARCHAR2
519 ,P_ATTRIBUTE20 in VARCHAR2
520
521 ,P_EFFECTIVE_DATE in DATE
522 ,P_VALIDATION_START_DATE in DATE
523 ,P_VALIDATION_END_DATE in DATE
524 ) IS
525 l_mode varchar2(80);
526
527 --
528 BEGIN
529
530 --
531 hr_utility.trace(' >DYT: Main entry point from
532 row handler, AFTER_INSERT');
533 /* Mechanism for event capture to know whats occurred */
534 l_mode := pay_dyn_triggers.g_dyt_mode;
535 pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
536
537 --
538 /* no calls => no dynamic triggers of this type on this table */
539
540 null;
541
542 --
543 pay_dyn_triggers.g_dyt_mode := l_mode;
544
545 --
546 EXCEPTION
547 WHEN OTHERS THEN
548 hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
549 pay_dyn_triggers.g_dyt_mode := l_mode;
550 RAISE;
551 --
552 END AFTER_INSERT;
553
554 --
555
556 /*
557 ================================================
558 This is a dynamically generated procedure.
559 Will be called by API.
560 ================================================
561 ** DO NOT CHANGE MANUALLY **
562
563 ------------------------------------------------
564 Name: AFTER_UPDATE
565 Table: PER_CONTRACTS_F
566 Action: UPDATE
567 Generated Date: 30/03/2009 04:52
568 Description: Called as part of UPDATE process
569
570 ================================================
571 */
572
573 --
574 PROCEDURE AFTER_UPDATE
575 (
576 P_CONTRACT_ID in NUMBER
577 ,P_EFFECTIVE_START_DATE in DATE
578 ,P_EFFECTIVE_END_DATE in DATE
579
580 ,P_REFERENCE in VARCHAR2
581 ,P_TYPE in VARCHAR2
582 ,P_STATUS in VARCHAR2
583 ,P_STATUS_REASON in VARCHAR2
584 ,P_DOC_STATUS
585 in VARCHAR2
586 ,P_DOC_STATUS_CHANGE_DATE in DATE
587 ,P_DESCRIPTION in VARCHAR2
588 ,P_DURATION in NUMBER
589 ,P_DURATION_UNITS in VARCHAR2
590
591 ,P_CONTRACTUAL_JOB_TITLE in VARCHAR2
592 ,P_PARTIES in VARCHAR2
593 ,P_START_REASON in VARCHAR2
594 ,P_END_REASON in VARCHAR2
595 ,P_NUMBER_OF_EXTENSIONS
596 in NUMBER
597 ,P_EXTENSION_REASON in VARCHAR2
598 ,P_EXTENSION_PERIOD in NUMBER
599 ,P_EXTENSION_PERIOD_UNITS in VARCHAR2
600 ,P_CTR_INFORMATION_CATEGORY in VARCHAR2
601
602 ,P_CTR_INFORMATION1 in VARCHAR2
603 ,P_CTR_INFORMATION2 in VARCHAR2
604 ,P_CTR_INFORMATION3 in VARCHAR2
605 ,P_CTR_INFORMATION4 in VARCHAR2
606 ,P_CTR_INFORMATION5
607 in VARCHAR2
608 ,P_CTR_INFORMATION6 in VARCHAR2
609 ,P_CTR_INFORMATION7 in VARCHAR2
610 ,P_CTR_INFORMATION8 in VARCHAR2
611 ,P_CTR_INFORMATION9 in
612 VARCHAR2
613 ,P_CTR_INFORMATION10 in VARCHAR2
614 ,P_CTR_INFORMATION11 in VARCHAR2
615 ,P_CTR_INFORMATION12 in VARCHAR2
616 ,P_CTR_INFORMATION13 in VARCHAR2
617
618 ,P_CTR_INFORMATION14 in VARCHAR2
619 ,P_CTR_INFORMATION15 in VARCHAR2
620 ,P_CTR_INFORMATION16 in VARCHAR2
621 ,P_CTR_INFORMATION17 in VARCHAR2
622 ,P_CTR_INFORMATION18
623 in VARCHAR2
624 ,P_CTR_INFORMATION19 in VARCHAR2
625 ,P_CTR_INFORMATION20 in VARCHAR2
626 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
627 ,P_ATTRIBUTE1 in
628 VARCHAR2
629 ,P_ATTRIBUTE2 in VARCHAR2
630 ,P_ATTRIBUTE3 in VARCHAR2
631 ,P_ATTRIBUTE4 in VARCHAR2
632 ,P_ATTRIBUTE5 in VARCHAR2
633 ,P_ATTRIBUTE6
634 in VARCHAR2
635 ,P_ATTRIBUTE7 in VARCHAR2
636 ,P_ATTRIBUTE8 in VARCHAR2
637 ,P_ATTRIBUTE9 in VARCHAR2
638 ,P_ATTRIBUTE10
639 in VARCHAR2
640 ,P_ATTRIBUTE11 in VARCHAR2
641 ,P_ATTRIBUTE12 in VARCHAR2
642 ,P_ATTRIBUTE13 in VARCHAR2
643 ,P_ATTRIBUTE14 in VARCHAR2
644
645 ,P_ATTRIBUTE15 in VARCHAR2
646 ,P_ATTRIBUTE16 in VARCHAR2
647 ,P_ATTRIBUTE17 in VARCHAR2
648 ,P_ATTRIBUTE18 in VARCHAR2
649 ,P_ATTRIBUTE19
650 in VARCHAR2
651 ,P_ATTRIBUTE20 in VARCHAR2
652 ,P_EFFECTIVE_DATE in DATE
653 ,P_DATETRACK_MODE in VARCHAR2
654 ,P_VALIDATION_START_DATE in DATE
655
656 ,P_VALIDATION_END_DATE in DATE
657 ,P_BUSINESS_GROUP_ID_O in NUMBER
658 ,P_PERSON_ID_O in NUMBER
659 ,P_REFERENCE_O in VARCHAR2
660 ,P_TYPE_O
661 in VARCHAR2
662 ,P_STATUS_O in VARCHAR2
663 ,P_STATUS_REASON_O in VARCHAR2
664 ,P_DOC_STATUS_O in VARCHAR2
665 ,P_DOC_STATUS_CHANGE_DATE_O in DATE
666
667 ,P_DESCRIPTION_O in VARCHAR2
668 ,P_DURATION_O in NUMBER
669 ,P_DURATION_UNITS_O in VARCHAR2
670 ,P_CONTRACTUAL_JOB_TITLE_O in VARCHAR2
671 ,P_PARTIES_O
672 in VARCHAR2
673 ,P_START_REASON_O in VARCHAR2
674 ,P_END_REASON_O in VARCHAR2
675 ,P_NUMBER_OF_EXTENSIONS_O in NUMBER
676 ,P_EXTENSION_REASON_O in VARCHAR2
677
678 ,P_EXTENSION_PERIOD_O in NUMBER
679 ,P_EXTENSION_PERIOD_UNITS_O in VARCHAR2
680 ,P_CTR_INFORMATION_CATEGORY_O in VARCHAR2
681 ,P_CTR_INFORMATION1_O in VARCHAR2
682 ,P_CTR_INFORMATION2_O
683 in VARCHAR2
684 ,P_CTR_INFORMATION3_O in VARCHAR2
685 ,P_CTR_INFORMATION4_O in VARCHAR2
686 ,P_CTR_INFORMATION5_O in VARCHAR2
687 ,P_CTR_INFORMATION6_O in VARCHAR2
688
689 ,P_CTR_INFORMATION7_O in VARCHAR2
690 ,P_CTR_INFORMATION8_O in VARCHAR2
691 ,P_CTR_INFORMATION9_O in VARCHAR2
692 ,P_CTR_INFORMATION10_O in VARCHAR2
693 ,P_CTR_INFORMATION11_O
694 in VARCHAR2
695 ,P_CTR_INFORMATION12_O in VARCHAR2
696 ,P_CTR_INFORMATION13_O in VARCHAR2
697 ,P_CTR_INFORMATION14_O in VARCHAR2
698 ,P_CTR_INFORMATION15_O in
699 VARCHAR2
700 ,P_CTR_INFORMATION16_O in VARCHAR2
701 ,P_CTR_INFORMATION17_O in VARCHAR2
702 ,P_CTR_INFORMATION18_O in VARCHAR2
703 ,P_CTR_INFORMATION19_O in VARCHAR2
704
705 ,P_CTR_INFORMATION20_O in VARCHAR2
706 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
707 ,P_ATTRIBUTE1_O in VARCHAR2
708 ,P_ATTRIBUTE2_O in VARCHAR2
709 ,P_ATTRIBUTE3_O
710 in VARCHAR2
711 ,P_ATTRIBUTE4_O in VARCHAR2
712 ,P_ATTRIBUTE5_O in VARCHAR2
713 ,P_ATTRIBUTE6_O in VARCHAR2
714 ,P_ATTRIBUTE7_O in
715 VARCHAR2
716 ,P_ATTRIBUTE8_O in VARCHAR2
717 ,P_ATTRIBUTE9_O in VARCHAR2
718 ,P_ATTRIBUTE10_O in VARCHAR2
719 ,P_ATTRIBUTE11_O in VARCHAR2
720
721 ,P_ATTRIBUTE12_O in VARCHAR2
722 ,P_ATTRIBUTE13_O in VARCHAR2
723 ,P_ATTRIBUTE14_O in VARCHAR2
724 ,P_ATTRIBUTE15_O in VARCHAR2
725 ,P_ATTRIBUTE16_O
726 in VARCHAR2
727 ,P_ATTRIBUTE17_O in VARCHAR2
728 ,P_ATTRIBUTE18_O in VARCHAR2
729 ,P_ATTRIBUTE19_O in VARCHAR2
730 ,P_ATTRIBUTE20_O in
731 VARCHAR2
732 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
733 ,P_EFFECTIVE_START_DATE_O in DATE
734 ,P_EFFECTIVE_END_DATE_O in DATE
735 ) IS
736 l_mode varchar2(80);
737
738 --
739 BEGIN
740
741 --
742 hr_utility.trace(' >DYT: Main
743 entry point from row handler, AFTER_UPDATE');
744 /* Mechanism for event capture to know whats occurred */
745 l_mode := pay_dyn_triggers.g_dyt_mode;
746 pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
747
748 --
749
750 if (paywsdyg_pkg.trigger_enabled('PER_CONTRACTS_F_ARU')) then
751 PER_CONTRACTS_F_ARU_ARU(
752 p_new_ATTRIBUTE1 => P_ATTRIBUTE1
753 ,p_new_ATTRIBUTE10 => P_ATTRIBUTE10
754 ,p_new_ATTRIBUTE11
755 => P_ATTRIBUTE11
756 ,p_new_ATTRIBUTE12 => P_ATTRIBUTE12
757 ,p_new_ATTRIBUTE13 => P_ATTRIBUTE13
758 ,p_new_ATTRIBUTE14 => P_ATTRIBUTE14
759 ,p_new_ATTRIBUTE15
760 => P_ATTRIBUTE15
761 ,p_new_ATTRIBUTE16 => P_ATTRIBUTE16
762 ,p_new_ATTRIBUTE17 => P_ATTRIBUTE17
763 ,p_new_ATTRIBUTE18 => P_ATTRIBUTE18
764 ,p_new_ATTRIBUTE19
765 => P_ATTRIBUTE19
766 ,p_new_ATTRIBUTE2 => P_ATTRIBUTE2
767 ,p_new_ATTRIBUTE20 => P_ATTRIBUTE20
768 ,p_new_ATTRIBUTE3 => P_ATTRIBUTE3
769 ,p_new_ATTRIBUTE4
770 => P_ATTRIBUTE4
771 ,p_new_ATTRIBUTE5 => P_ATTRIBUTE5
772 ,p_new_ATTRIBUTE6 => P_ATTRIBUTE6
773 ,p_new_ATTRIBUTE7 => P_ATTRIBUTE7
774 ,p_new_ATTRIBUTE8
775 => P_ATTRIBUTE8
776 ,p_new_ATTRIBUTE9 => P_ATTRIBUTE9
777 ,p_new_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
778 ,p_new_CONTRACTUAL_JOB_TITLE => P_CONTRACTUAL_JOB_TITLE
779
780 ,p_new_CONTRACT_ID => P_CONTRACT_ID
781 ,p_new_CTR_INFORMATION1 => P_CTR_INFORMATION1
782 ,p_new_CTR_INFORMATION10 => P_CTR_INFORMATION10
783 ,p_new_CTR_INFORMATION11 =>
784 P_CTR_INFORMATION11
785 ,p_new_CTR_INFORMATION12 => P_CTR_INFORMATION12
786 ,p_new_CTR_INFORMATION13 => P_CTR_INFORMATION13
787 ,p_new_CTR_INFORMATION14 => P_CTR_INFORMATION14
788
789 ,p_new_CTR_INFORMATION15 => P_CTR_INFORMATION15
790 ,p_new_CTR_INFORMATION16 => P_CTR_INFORMATION16
791 ,p_new_CTR_INFORMATION17 => P_CTR_INFORMATION17
792 ,p_new_CTR_INFORMATION18 =>
793 P_CTR_INFORMATION18
794 ,p_new_CTR_INFORMATION19 => P_CTR_INFORMATION19
795 ,p_new_CTR_INFORMATION2 => P_CTR_INFORMATION2
796 ,p_new_CTR_INFORMATION20 => P_CTR_INFORMATION20
797
798 ,p_new_CTR_INFORMATION3 => P_CTR_INFORMATION3
799 ,p_new_CTR_INFORMATION4 => P_CTR_INFORMATION4
800 ,p_new_CTR_INFORMATION5 => P_CTR_INFORMATION5
801 ,p_new_CTR_INFORMATION6 =>
802 P_CTR_INFORMATION6
803 ,p_new_CTR_INFORMATION7 => P_CTR_INFORMATION7
804 ,p_new_CTR_INFORMATION8 => P_CTR_INFORMATION8
805 ,p_new_CTR_INFORMATION9 => P_CTR_INFORMATION9
806
807 ,p_new_CTR_INFORMATION_CATEGORY => P_CTR_INFORMATION_CATEGORY
808 ,p_new_DESCRIPTION => P_DESCRIPTION
809 ,p_new_DOC_STATUS => P_DOC_STATUS
810 ,p_new_DOC_STATUS_CHANGE_DATE =>
811 P_DOC_STATUS_CHANGE_DATE
812 ,p_new_DURATION => P_DURATION
813 ,p_new_DURATION_UNITS => P_DURATION_UNITS
814 ,p_new_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
815
816 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
817 ,p_new_END_REASON => P_END_REASON
818 ,p_new_EXTENSION_PERIOD => P_EXTENSION_PERIOD
819 ,p_new_EXTENSION_PERIOD_UNITS =>
820 P_EXTENSION_PERIOD_UNITS
821 ,p_new_EXTENSION_REASON => P_EXTENSION_REASON
822 ,p_new_NUMBER_OF_EXTENSIONS => P_NUMBER_OF_EXTENSIONS
823 ,p_new_PARTIES => P_PARTIES
824 ,p_new_REFERENCE
825 => P_REFERENCE
826 ,p_new_START_REASON => P_START_REASON
827 ,p_new_STATUS => P_STATUS
828 ,p_new_STATUS_REASON => P_STATUS_REASON
829 ,p_new_TYPE
830 => P_TYPE
831 ,p_old_ATTRIBUTE1 => P_ATTRIBUTE1_O
832 ,p_old_ATTRIBUTE10 => P_ATTRIBUTE10_O
833 ,p_old_ATTRIBUTE11 => P_ATTRIBUTE11_O
834 ,p_old_ATTRIBUTE12
835 => P_ATTRIBUTE12_O
836 ,p_old_ATTRIBUTE13 => P_ATTRIBUTE13_O
837 ,p_old_ATTRIBUTE14 => P_ATTRIBUTE14_O
838 ,p_old_ATTRIBUTE15 => P_ATTRIBUTE15_O
839
840 ,p_old_ATTRIBUTE16 => P_ATTRIBUTE16_O
841 ,p_old_ATTRIBUTE17 => P_ATTRIBUTE17_O
842 ,p_old_ATTRIBUTE18 => P_ATTRIBUTE18_O
843 ,p_old_ATTRIBUTE19 =>
844 P_ATTRIBUTE19_O
845 ,p_old_ATTRIBUTE2 => P_ATTRIBUTE2_O
846 ,p_old_ATTRIBUTE20 => P_ATTRIBUTE20_O
847 ,p_old_ATTRIBUTE3 => P_ATTRIBUTE3_O
848 ,p_old_ATTRIBUTE4
849 => P_ATTRIBUTE4_O
850 ,p_old_ATTRIBUTE5 => P_ATTRIBUTE5_O
851 ,p_old_ATTRIBUTE6 => P_ATTRIBUTE6_O
852 ,p_old_ATTRIBUTE7 => P_ATTRIBUTE7_O
853 ,p_old_ATTRIBUTE8
854 => P_ATTRIBUTE8_O
855 ,p_old_ATTRIBUTE9 => P_ATTRIBUTE9_O
856 ,p_old_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY_O
857 ,p_old_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID_O
858
859 ,p_old_CONTRACTUAL_JOB_TITLE => P_CONTRACTUAL_JOB_TITLE_O
860 ,p_old_CTR_INFORMATION1 => P_CTR_INFORMATION1_O
861 ,p_old_CTR_INFORMATION10 => P_CTR_INFORMATION10_O
862 ,p_old_CTR_INFORMATION11
863 => P_CTR_INFORMATION11_O
864 ,p_old_CTR_INFORMATION12 => P_CTR_INFORMATION12_O
865 ,p_old_CTR_INFORMATION13 => P_CTR_INFORMATION13_O
866 ,p_old_CTR_INFORMATION14 => P_CTR_INFORMATION14_O
867
868 ,p_old_CTR_INFORMATION15 => P_CTR_INFORMATION15_O
869 ,p_old_CTR_INFORMATION16 => P_CTR_INFORMATION16_O
870 ,p_old_CTR_INFORMATION17 => P_CTR_INFORMATION17_O
871 ,p_old_CTR_INFORMATION18
872 => P_CTR_INFORMATION18_O
873 ,p_old_CTR_INFORMATION19 => P_CTR_INFORMATION19_O
874 ,p_old_CTR_INFORMATION2 => P_CTR_INFORMATION2_O
875 ,p_old_CTR_INFORMATION20 => P_CTR_INFORMATION20_O
876
877 ,p_old_CTR_INFORMATION3 => P_CTR_INFORMATION3_O
878 ,p_old_CTR_INFORMATION4 => P_CTR_INFORMATION4_O
879 ,p_old_CTR_INFORMATION5 => P_CTR_INFORMATION5_O
880 ,p_old_CTR_INFORMATION6
881 => P_CTR_INFORMATION6_O
882 ,p_old_CTR_INFORMATION7 => P_CTR_INFORMATION7_O
883 ,p_old_CTR_INFORMATION8 => P_CTR_INFORMATION8_O
884 ,p_old_CTR_INFORMATION9 => P_CTR_INFORMATION9_O
885
886 ,p_old_CTR_INFORMATION_CATEGORY => P_CTR_INFORMATION_CATEGORY_O
887 ,p_old_DESCRIPTION => P_DESCRIPTION_O
888 ,p_old_DOC_STATUS => P_DOC_STATUS_O
889 ,p_old_DOC_STATUS_CHANGE_DATE =>
890 P_DOC_STATUS_CHANGE_DATE_O
891 ,p_old_DURATION => P_DURATION_O
892 ,p_old_DURATION_UNITS => P_DURATION_UNITS_O
893 ,p_old_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE_O
894
895 ,p_old_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE_O
896 ,p_old_END_REASON => P_END_REASON_O
897 ,p_old_EXTENSION_PERIOD => P_EXTENSION_PERIOD_O
898 ,p_old_EXTENSION_PERIOD_UNITS
899 => P_EXTENSION_PERIOD_UNITS_O
900 ,p_old_EXTENSION_REASON => P_EXTENSION_REASON_O
901 ,p_old_NUMBER_OF_EXTENSIONS => P_NUMBER_OF_EXTENSIONS_O
902 ,p_old_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER_O
903
904 ,p_old_PARTIES => P_PARTIES_O
905 ,p_old_PERSON_ID => P_PERSON_ID_O
906 ,p_old_REFERENCE => P_REFERENCE_O
907 ,p_old_START_REASON => P_START_REASON_O
908
909 ,p_old_STATUS => P_STATUS_O
910 ,p_old_STATUS_REASON => P_STATUS_REASON_O
911 ,p_old_TYPE => P_TYPE_O
912 );
913 end if;
914
915 --
916 pay_dyn_triggers.g_dyt_mode := l_mode;
917
918 --
919
920 EXCEPTION
921 WHEN OTHERS THEN
922 hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
923 pay_dyn_triggers.g_dyt_mode := l_mode;
924 RAISE;
925 --
926 END AFTER_UPDATE;
927
928 --
929
930 /*
931 ================================================
932 This is a dynamically generated procedure.
933 Will be called by API.
934 ================================================
935 ** DO NOT CHANGE MANUALLY **
936
937 ------------------------------------------------
938 Name: AFTER_DELETE
939 Table: PER_CONTRACTS_F
940 Action: DELETE
941 Generated Date: 30/03/2009 04:52
942 Description: Called as part of DELETE process
943
944 ================================================
945 */
946
947 --
948 PROCEDURE AFTER_DELETE
949 (
950 P_EFFECTIVE_DATE in DATE
951 ,P_DATETRACK_MODE in VARCHAR2
952 ,P_VALIDATION_START_DATE in DATE
953
954 ,P_VALIDATION_END_DATE in DATE
955 ,P_CONTRACT_ID in NUMBER
956 ,P_EFFECTIVE_START_DATE in DATE
957 ,P_EFFECTIVE_END_DATE in DATE
958 ,P_OBJECT_VERSION_NUMBER
959 in NUMBER
960 ,P_EFFECTIVE_START_DATE_O in DATE
961 ,P_EFFECTIVE_END_DATE_O in DATE
962 ,P_BUSINESS_GROUP_ID_O in NUMBER
963 ,P_PERSON_ID_O in NUMBER
964 ,P_REFERENCE_O
965 in VARCHAR2
966 ,P_TYPE_O in VARCHAR2
967 ,P_STATUS_O in VARCHAR2
968 ,P_STATUS_REASON_O in VARCHAR2
969 ,P_DOC_STATUS_O in
970 VARCHAR2
971 ,P_DOC_STATUS_CHANGE_DATE_O in DATE
972 ,P_DESCRIPTION_O in VARCHAR2
973 ,P_DURATION_O in NUMBER
974 ,P_DURATION_UNITS_O in VARCHAR2
975
976 ,P_CONTRACTUAL_JOB_TITLE_O in VARCHAR2
977 ,P_PARTIES_O in VARCHAR2
978 ,P_START_REASON_O in VARCHAR2
979 ,P_END_REASON_O in VARCHAR2
980 ,P_NUMBER_OF_EXTENSIONS_O
981 in NUMBER
982 ,P_EXTENSION_REASON_O in VARCHAR2
983 ,P_EXTENSION_PERIOD_O in NUMBER
984 ,P_EXTENSION_PERIOD_UNITS_O in VARCHAR2
985 ,P_CTR_INFORMATION_CATEGORY_O in VARCHAR2
986
987 ,P_CTR_INFORMATION1_O in VARCHAR2
988 ,P_CTR_INFORMATION2_O in VARCHAR2
989 ,P_CTR_INFORMATION3_O in VARCHAR2
990 ,P_CTR_INFORMATION4_O in VARCHAR2
991 ,P_CTR_INFORMATION5_O
992 in VARCHAR2
993 ,P_CTR_INFORMATION6_O in VARCHAR2
994 ,P_CTR_INFORMATION7_O in VARCHAR2
995 ,P_CTR_INFORMATION8_O in VARCHAR2
996 ,P_CTR_INFORMATION9_O in
997 VARCHAR2
998 ,P_CTR_INFORMATION10_O in VARCHAR2
999 ,P_CTR_INFORMATION11_O in VARCHAR2
1000 ,P_CTR_INFORMATION12_O in VARCHAR2
1001 ,P_CTR_INFORMATION13_O in VARCHAR2
1002
1003 ,P_CTR_INFORMATION14_O in VARCHAR2
1004 ,P_CTR_INFORMATION15_O in VARCHAR2
1005 ,P_CTR_INFORMATION16_O in VARCHAR2
1006 ,P_CTR_INFORMATION17_O in VARCHAR2
1007 ,P_CTR_INFORMATION18_O
1008 in VARCHAR2
1009 ,P_CTR_INFORMATION19_O in VARCHAR2
1010 ,P_CTR_INFORMATION20_O in VARCHAR2
1011 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
1012 ,P_ATTRIBUTE1_O in
1013 VARCHAR2
1014 ,P_ATTRIBUTE2_O in VARCHAR2
1015 ,P_ATTRIBUTE3_O in VARCHAR2
1016 ,P_ATTRIBUTE4_O in VARCHAR2
1017 ,P_ATTRIBUTE5_O in VARCHAR2
1018
1019 ,P_ATTRIBUTE6_O in VARCHAR2
1020 ,P_ATTRIBUTE7_O in VARCHAR2
1021 ,P_ATTRIBUTE8_O in VARCHAR2
1022 ,P_ATTRIBUTE9_O in VARCHAR2
1023 ,P_ATTRIBUTE10_O
1024 in VARCHAR2
1025 ,P_ATTRIBUTE11_O in VARCHAR2
1026 ,P_ATTRIBUTE12_O in VARCHAR2
1027 ,P_ATTRIBUTE13_O in VARCHAR2
1028 ,P_ATTRIBUTE14_O in
1029 VARCHAR2
1030 ,P_ATTRIBUTE15_O in VARCHAR2
1031 ,P_ATTRIBUTE16_O in VARCHAR2
1032 ,P_ATTRIBUTE17_O in VARCHAR2
1033 ,P_ATTRIBUTE18_O in VARCHAR2
1034
1035 ,P_ATTRIBUTE19_O in VARCHAR2
1036 ,P_ATTRIBUTE20_O in VARCHAR2
1037 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
1038 ) IS
1039 l_mode varchar2(80);
1040
1041 --
1042 BEGIN
1043
1044 --
1045 hr_utility.trace(' >DYT: Main entry
1046 point from row handler, AFTER_DELETE');
1047 /* Mechanism for event capture to know whats occurred */
1048 l_mode := pay_dyn_triggers.g_dyt_mode;
1049 pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1050
1051 --
1052 /* no calls => no dynamic triggers of this type on this
1053 table */
1054 null;
1055
1056 --
1057 pay_dyn_triggers.g_dyt_mode := l_mode;
1058
1059 --
1060 EXCEPTION
1061 WHEN OTHERS THEN
1062 hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
1063 pay_dyn_triggers.g_dyt_mode := l_mode;
1064 RAISE;
1065 --
1066 END AFTER_DELETE;
1067
1068 --
1069
1070 /* END_PACKAGE */
1071 END PAY_DYT_CONTRACTS_PKG;
1072