[Home] [Help]
PACKAGE BODY: APPS.PAY_DYT_ASSIGNMENT_ATTRIB_PKG
Source
4 --
1 package body PAY_DYT_ASSIGNMENT_ATTRIB_PKG
2 IS
3
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_ASSIGNMENT_ATTRIB_PKG
23 Base Table: PQP_ASSIGNMENT_ATTRIBUTES_F
24 Date: 27/11/2012 04:01
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_ASSIGNMENT_ATTRIBUTES__ARI
39 TABLE: PQP_ASSIGNMENT_ATTRIBUTES_F
40 ACTION: INSERT
41 GENERATED DATE: 27/11/2012 04:01
42 DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON
43 INSERT OF PQP_ASSIGNMENT_ATTRIBUTES_F
44 FULL TRIGGER NAME: PQP_ASSIGNMENT_ATTRIBUTES_F_ARI
45 ================================================
46 */
47 --
48 PROCEDURE PQP_ASSIGNMENT_ATTRIBUTES__ARI
49 (
50 P_NEW_AAT_ATTRIBUTE1 IN VARCHAR2
51
52 ,P_NEW_AAT_ATTRIBUTE10 IN VARCHAR2
53 ,P_NEW_AAT_ATTRIBUTE11 IN VARCHAR2
54 ,P_NEW_AAT_ATTRIBUTE12 IN VARCHAR2
55 ,P_NEW_AAT_ATTRIBUTE13 IN VARCHAR2
56 ,P_NEW_AAT_ATTRIBUTE14
57 IN VARCHAR2
58 ,P_NEW_AAT_ATTRIBUTE15 IN VARCHAR2
59 ,P_NEW_AAT_ATTRIBUTE16 IN VARCHAR2
60 ,P_NEW_AAT_ATTRIBUTE17 IN VARCHAR2
61 ,P_NEW_AAT_ATTRIBUTE18 IN
62 VARCHAR2
63 ,P_NEW_AAT_ATTRIBUTE19 IN VARCHAR2
64 ,P_NEW_AAT_ATTRIBUTE2 IN VARCHAR2
65 ,P_NEW_AAT_ATTRIBUTE20 IN VARCHAR2
66 ,P_NEW_AAT_ATTRIBUTE3 IN VARCHAR2
67
68 ,P_NEW_AAT_ATTRIBUTE4 IN VARCHAR2
69 ,P_NEW_AAT_ATTRIBUTE5 IN VARCHAR2
70 ,P_NEW_AAT_ATTRIBUTE6 IN VARCHAR2
71 ,P_NEW_AAT_ATTRIBUTE7 IN VARCHAR2
72 ,P_NEW_AAT_ATTRIBUTE8
73 IN VARCHAR2
74 ,P_NEW_AAT_ATTRIBUTE9 IN VARCHAR2
75 ,P_NEW_AAT_ATTRIBUTE_CATEGORY IN VARCHAR2
76 ,P_NEW_AAT_INFORMATION1 IN VARCHAR2
77 ,P_NEW_AAT_INFORMATION10 IN
78 VARCHAR2
79 ,P_NEW_AAT_INFORMATION11 IN VARCHAR2
80 ,P_NEW_AAT_INFORMATION12 IN VARCHAR2
81 ,P_NEW_AAT_INFORMATION13 IN VARCHAR2
82 ,P_NEW_AAT_INFORMATION14 IN VARCHAR2
83
84 ,P_NEW_AAT_INFORMATION15 IN VARCHAR2
85 ,P_NEW_AAT_INFORMATION16 IN VARCHAR2
86 ,P_NEW_AAT_INFORMATION17 IN VARCHAR2
87 ,P_NEW_AAT_INFORMATION18 IN VARCHAR2
88 ,P_NEW_AAT_INFORMATION19
89 IN VARCHAR2
90 ,P_NEW_AAT_INFORMATION2 IN VARCHAR2
91 ,P_NEW_AAT_INFORMATION20 IN VARCHAR2
92 ,P_NEW_AAT_INFORMATION3 IN VARCHAR2
93 ,P_NEW_AAT_INFORMATION4 IN
94 VARCHAR2
95 ,P_NEW_AAT_INFORMATION5 IN VARCHAR2
96 ,P_NEW_AAT_INFORMATION6 IN VARCHAR2
97 ,P_NEW_AAT_INFORMATION7 IN VARCHAR2
98 ,P_NEW_AAT_INFORMATION8 IN VARCHAR2
99
100 ,P_NEW_AAT_INFORMATION9 IN VARCHAR2
101 ,P_NEW_AAT_INFORMATION_CATEGORY IN VARCHAR2
102 ,P_NEW_ASSIGNMENT_ATTRIBUTE_ID IN NUMBER
103 ,P_NEW_ASSIGNMENT_ID IN NUMBER
104 ,P_NEW_BUSINESS_GROUP_ID
105 IN NUMBER
106 ,P_NEW_COMPANY_CAR_CALC_METHOD IN VARCHAR2
107 ,P_NEW_COMPANY_CAR_RATES_TABLE_ IN NUMBER
108 ,P_NEW_COMPANY_CAR_SECONDARY_TA IN NUMBER
109 ,P_NEW_CONTRACT_TYPE IN VARCHAR2
110
111 ,P_NEW_EFFECTIVE_DATE IN DATE
112 ,P_NEW_EFFECTIVE_END_DATE IN DATE
113 ,P_NEW_EFFECTIVE_START_DATE IN DATE
114 ,P_NEW_LGPS_EXCLUSION_TYPE IN VARCHAR2
115 ,P_NEW_LGPS_MEMBERSHIP_NUMBER
116 IN VARCHAR2
117 ,P_NEW_LGPS_PENSIONABLE_PAY IN VARCHAR2
118 ,P_NEW_LGPS_PROCESS_FLAG IN VARCHAR2
119 ,P_NEW_LGPS_TRANS_ARRANG_FLAG IN VARCHAR2
120 ,P_NEW_OBJECT_VERSION_NUMBER IN NUMBER
121
122 ,P_NEW_PRIMARY_CAPITAL_CONTRIBU IN NUMBER
123 ,P_NEW_PRIMARY_CAR_FUEL_BENEFIT IN VARCHAR2
124 ,P_NEW_PRIMARY_CLASS_1A IN VARCHAR2
128 ,P_NEW_PRIVATE_CAR IN NUMBER
125 ,P_NEW_PRIMARY_COMPANY_CAR IN NUMBER
126
127 ,P_NEW_PRIMARY_PRIVATE_CONTRIBU IN NUMBER
129 ,P_NEW_PRIVATE_CAR_CALC_METHOD IN VARCHAR2
130 ,P_NEW_PRIVATE_CAR_ESSENTIAL_TA IN NUMBER
131 ,P_NEW_PRIVATE_CAR_RATES_TABLE_
132 IN NUMBER
133 ,P_NEW_SECONDARY_CAPITAL_CONTRI IN NUMBER
134 ,P_NEW_SECONDARY_CAR_FUEL_BENEF IN VARCHAR2
135 ,P_NEW_SECONDARY_CLASS_1A IN VARCHAR2
136 ,P_NEW_SECONDARY_COMPANY_CAR IN NUMBER
137
138 ,P_NEW_SECONDARY_PRIVATE_CONTRI IN NUMBER
139 ,P_NEW_START_DAY IN VARCHAR2
140 ,P_NEW_TP_ELECTED_PENSION IN VARCHAR2
141 ,P_NEW_TP_FAST_TRACK IN VARCHAR2
142 ,P_NEW_TP_IS_TEACHER
143 IN VARCHAR2
144 ,P_NEW_TP_SAFEGUARDED_GRADE IN NUMBER
145 ,P_NEW_TP_SAFEGUARDED_GRADE_ID IN NUMBER
146 ,P_NEW_TP_SAFEGUARDED_RATE_ID IN NUMBER
147 ,P_NEW_TP_SAFEGUARDED_RATE_TYPE IN VARCHAR2
148
149 ,P_NEW_TP_SAFEGUARDED_SPINAL_PO IN NUMBER
150 ,P_NEW_TP_SPINAL_POINT_ID IN NUMBER
151 ,P_NEW_VALIDATION_END_DATE IN DATE
152 ,P_NEW_VALIDATION_START_DATE IN DATE
153 ,P_NEW_WORK_PATTERN
154 IN VARCHAR2
155 ) IS
156
157 --
158 /* LOCAL VARIABLE DECLARATIONS */
159 L_BUSINESS_GROUP_ID NUMBER;
160 L_LEGISLATION_CODE VARCHAR2(30);
161 BEGIN
162 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER:
163 PQP_ASSIGNMENT_ATTRIBUTES_F_ARI');
164 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
165 RETURN;
166 END IF;
167 /* INITIALISING LOCAL VARIABLES */
168 L_BUSINESS_GROUP_ID := P_NEW_BUSINESS_GROUP_ID;
169 --
170 SELECT LEGISLATION_CODE
171 INTO L_LEGISLATION_CODE
172
173 FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
174 --
175 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
176 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
177 P_EVENT_ID => 77,
178 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
179
180 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
181 P_PAYROLL_ID => NULL
182 ) THEN
183 RETURN;
184 END IF;
185 --
186 /* GLOBAL COMPONENT CALLS */
187 PQP_GB_TP_EXTRACT_TRIGGERS.PQP_ASSIGNMENT_ATTRIBUTE_F_ARI(
188 P_BUSINESS_GROUP_ID =>
189 L_BUSINESS_GROUP_ID,
190 P_EFFECTIVE_DATE => P_NEW_EFFECTIVE_END_DATE,
191 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
192 P_NEW_ASSIGNMENT_ATTRIBUTE_ID => P_NEW_ASSIGNMENT_ATTRIBUTE_ID,
193 P_NEW_ASSIGNMENT_ID =>
194 P_NEW_ASSIGNMENT_ID,
195 P_NEW_EFFECTIVE_END_DATE => P_NEW_EFFECTIVE_END_DATE,
196 P_NEW_EFFECTIVE_START_DATE => P_NEW_EFFECTIVE_START_DATE
197 );
198 --
199 /* LEGISLATION SPECIFIC COMPONENT CALLS */
200 --
201 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS
202 */
203 --
204 /* PAYROLL SPECIFIC COMPONENT CALLS */
205 --
206 EXCEPTION
207 WHEN OTHERS THEN
208 HR_UTILITY.SET_LOCATION('PQP_ASSIGNMENT_ATTRIBUTES__ARI',ABS(SQLCODE));
209 RAISE;
210 --
211 END PQP_ASSIGNMENT_ATTRIBUTES__ARI;
212
213 --
214
215 /*
216 ================================================
217 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
218 WITH CODE REPRESENTING A DYNAMIC TRIGGER
219 ================================================
220 ** DO NOT CHANGE MANUALLY **
221
222 ------------------------------------------------
223 NAME: PQP_ASSIGNMENT_ATTRIBUTES__ARU
224 TABLE: PQP_ASSIGNMENT_ATTRIBUTES_F
225 ACTION: UPDATE
226 GENERATED DATE: 27/11/2012 04:01
227 DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON
228 UPDATE OF PQP_ASSIGNMENT_ATTRIBUTES_F
229 FULL TRIGGER NAME: PQP_ASSIGNMENT_ATTRIBUTES_F_ARU
230 ================================================
231 */
232 --
233 PROCEDURE PQP_ASSIGNMENT_ATTRIBUTES__ARU
234 (
235 P_NEW_AAT_ATTRIBUTE1 IN VARCHAR2
236
237 ,P_NEW_AAT_ATTRIBUTE10 IN VARCHAR2
238 ,P_NEW_AAT_ATTRIBUTE11 IN VARCHAR2
239 ,P_NEW_AAT_ATTRIBUTE12 IN VARCHAR2
240 ,P_NEW_AAT_ATTRIBUTE13 IN VARCHAR2
241 ,P_NEW_AAT_ATTRIBUTE14
242 IN VARCHAR2
243 ,P_NEW_AAT_ATTRIBUTE15 IN VARCHAR2
244 ,P_NEW_AAT_ATTRIBUTE16 IN VARCHAR2
245 ,P_NEW_AAT_ATTRIBUTE17 IN VARCHAR2
246 ,P_NEW_AAT_ATTRIBUTE18 IN
247 VARCHAR2
248 ,P_NEW_AAT_ATTRIBUTE19 IN VARCHAR2
249 ,P_NEW_AAT_ATTRIBUTE2 IN VARCHAR2
250 ,P_NEW_AAT_ATTRIBUTE20 IN VARCHAR2
251 ,P_NEW_AAT_ATTRIBUTE3 IN VARCHAR2
252
253 ,P_NEW_AAT_ATTRIBUTE4 IN VARCHAR2
254 ,P_NEW_AAT_ATTRIBUTE5 IN VARCHAR2
255 ,P_NEW_AAT_ATTRIBUTE6 IN VARCHAR2
256 ,P_NEW_AAT_ATTRIBUTE7 IN VARCHAR2
257 ,P_NEW_AAT_ATTRIBUTE8
258 IN VARCHAR2
259 ,P_NEW_AAT_ATTRIBUTE9 IN VARCHAR2
260 ,P_NEW_AAT_ATTRIBUTE_CATEGORY IN VARCHAR2
261 ,P_NEW_AAT_INFORMATION1 IN VARCHAR2
262 ,P_NEW_AAT_INFORMATION10 IN
263 VARCHAR2
264 ,P_NEW_AAT_INFORMATION11 IN VARCHAR2
265 ,P_NEW_AAT_INFORMATION12 IN VARCHAR2
266 ,P_NEW_AAT_INFORMATION13 IN VARCHAR2
267 ,P_NEW_AAT_INFORMATION14 IN VARCHAR2
268
269 ,P_NEW_AAT_INFORMATION15 IN VARCHAR2
270 ,P_NEW_AAT_INFORMATION16 IN VARCHAR2
271 ,P_NEW_AAT_INFORMATION17 IN VARCHAR2
272 ,P_NEW_AAT_INFORMATION18 IN VARCHAR2
273 ,P_NEW_AAT_INFORMATION19
274 IN VARCHAR2
275 ,P_NEW_AAT_INFORMATION2 IN VARCHAR2
276 ,P_NEW_AAT_INFORMATION20 IN VARCHAR2
277 ,P_NEW_AAT_INFORMATION3 IN VARCHAR2
278 ,P_NEW_AAT_INFORMATION4 IN
279 VARCHAR2
280 ,P_NEW_AAT_INFORMATION5 IN VARCHAR2
281 ,P_NEW_AAT_INFORMATION6 IN VARCHAR2
282 ,P_NEW_AAT_INFORMATION7 IN VARCHAR2
283 ,P_NEW_AAT_INFORMATION8 IN VARCHAR2
284
285 ,P_NEW_AAT_INFORMATION9 IN VARCHAR2
286 ,P_NEW_AAT_INFORMATION_CATEGORY IN VARCHAR2
287 ,P_NEW_ASSIGNMENT_ATTRIBUTE_ID IN NUMBER
288 ,P_NEW_ASSIGNMENT_ID IN NUMBER
289 ,P_NEW_BUSINESS_GROUP_ID
290 IN NUMBER
291 ,P_NEW_COMPANY_CAR_CALC_METHOD IN VARCHAR2
292 ,P_NEW_COMPANY_CAR_RATES_TABLE_ IN NUMBER
293 ,P_NEW_COMPANY_CAR_SECONDARY_TA IN NUMBER
294 ,P_NEW_CONTRACT_TYPE IN VARCHAR2
295
296 ,P_NEW_DATETRACK_MODE IN VARCHAR2
297 ,P_NEW_EFFECTIVE_DATE IN DATE
298 ,P_NEW_EFFECTIVE_END_DATE IN DATE
299 ,P_NEW_EFFECTIVE_START_DATE IN DATE
300 ,P_NEW_LGPS_EXCLUSION_TYPE
301 IN VARCHAR2
302 ,P_NEW_LGPS_MEMBERSHIP_NUMBER IN VARCHAR2
303 ,P_NEW_LGPS_PENSIONABLE_PAY IN VARCHAR2
304 ,P_NEW_LGPS_PROCESS_FLAG IN VARCHAR2
305 ,P_NEW_LGPS_TRANS_ARRANG_FLAG IN VARCHAR2
306
307 ,P_NEW_OBJECT_VERSION_NUMBER IN NUMBER
308 ,P_NEW_PRIMARY_CAPITAL_CONTRIBU IN NUMBER
309 ,P_NEW_PRIMARY_CAR_FUEL_BENEFIT IN VARCHAR2
310 ,P_NEW_PRIMARY_CLASS_1A IN VARCHAR2
311 ,P_NEW_PRIMARY_COMPANY_CAR
312 IN NUMBER
313 ,P_NEW_PRIMARY_PRIVATE_CONTRIBU IN NUMBER
314 ,P_NEW_PRIVATE_CAR IN NUMBER
315 ,P_NEW_PRIVATE_CAR_CALC_METHOD IN VARCHAR2
316 ,P_NEW_PRIVATE_CAR_ESSENTIAL_TA IN NUMBER
317
318 ,P_NEW_PRIVATE_CAR_RATES_TABLE_ IN NUMBER
319 ,P_NEW_SECONDARY_CAPITAL_CONTRI IN NUMBER
320 ,P_NEW_SECONDARY_CAR_FUEL_BENEF IN VARCHAR2
321 ,P_NEW_SECONDARY_CLASS_1A IN VARCHAR2
322 ,P_NEW_SECONDARY_COMPANY_CAR
323 IN NUMBER
324 ,P_NEW_SECONDARY_PRIVATE_CONTRI IN NUMBER
325 ,P_NEW_START_DAY IN VARCHAR2
326 ,P_NEW_TP_ELECTED_PENSION IN VARCHAR2
327 ,P_NEW_TP_FAST_TRACK IN VARCHAR2
328
329 ,P_NEW_TP_IS_TEACHER IN VARCHAR2
330 ,P_NEW_TP_SAFEGUARDED_GRADE IN NUMBER
331 ,P_NEW_TP_SAFEGUARDED_GRADE_ID IN NUMBER
332 ,P_NEW_TP_SAFEGUARDED_RATE_ID IN NUMBER
333 ,P_NEW_TP_SAFEGUARDED_RATE_TYPE
334 IN VARCHAR2
335 ,P_NEW_TP_SAFEGUARDED_SPINAL_PO IN NUMBER
336 ,P_NEW_TP_SPINAL_POINT_ID IN NUMBER
337 ,P_NEW_VALIDATION_END_DATE IN DATE
338 ,P_NEW_VALIDATION_START_DATE IN DATE
339
340 ,P_NEW_WORK_PATTERN IN VARCHAR2
341 ,P_OLD_AAT_ATTRIBUTE1 IN VARCHAR2
342 ,P_OLD_AAT_ATTRIBUTE10 IN VARCHAR2
343 ,P_OLD_AAT_ATTRIBUTE11 IN VARCHAR2
344 ,P_OLD_AAT_ATTRIBUTE12
345 IN VARCHAR2
346 ,P_OLD_AAT_ATTRIBUTE13 IN VARCHAR2
347 ,P_OLD_AAT_ATTRIBUTE14 IN VARCHAR2
348 ,P_OLD_AAT_ATTRIBUTE15 IN VARCHAR2
349 ,P_OLD_AAT_ATTRIBUTE16 IN
350 VARCHAR2
351 ,P_OLD_AAT_ATTRIBUTE17 IN VARCHAR2
352 ,P_OLD_AAT_ATTRIBUTE18 IN VARCHAR2
353 ,P_OLD_AAT_ATTRIBUTE19 IN VARCHAR2
354 ,P_OLD_AAT_ATTRIBUTE2 IN VARCHAR2
355
356 ,P_OLD_AAT_ATTRIBUTE20 IN VARCHAR2
357 ,P_OLD_AAT_ATTRIBUTE3 IN VARCHAR2
358 ,P_OLD_AAT_ATTRIBUTE4 IN VARCHAR2
359 ,P_OLD_AAT_ATTRIBUTE5 IN VARCHAR2
360 ,P_OLD_AAT_ATTRIBUTE6
361 IN VARCHAR2
362 ,P_OLD_AAT_ATTRIBUTE7 IN VARCHAR2
363 ,P_OLD_AAT_ATTRIBUTE8 IN VARCHAR2
364 ,P_OLD_AAT_ATTRIBUTE9 IN VARCHAR2
365 ,P_OLD_AAT_ATTRIBUTE_CATEGORY IN
366 VARCHAR2
367 ,P_OLD_AAT_INFORMATION1 IN VARCHAR2
368 ,P_OLD_AAT_INFORMATION10 IN VARCHAR2
369 ,P_OLD_AAT_INFORMATION11 IN VARCHAR2
370 ,P_OLD_AAT_INFORMATION12 IN VARCHAR2
371
372 ,P_OLD_AAT_INFORMATION13 IN VARCHAR2
373 ,P_OLD_AAT_INFORMATION14 IN VARCHAR2
374 ,P_OLD_AAT_INFORMATION15 IN VARCHAR2
375 ,P_OLD_AAT_INFORMATION16 IN VARCHAR2
376 ,P_OLD_AAT_INFORMATION17
377 IN VARCHAR2
381 ,P_OLD_AAT_INFORMATION20 IN
378 ,P_OLD_AAT_INFORMATION18 IN VARCHAR2
379 ,P_OLD_AAT_INFORMATION19 IN VARCHAR2
380 ,P_OLD_AAT_INFORMATION2 IN VARCHAR2
382 VARCHAR2
383 ,P_OLD_AAT_INFORMATION3 IN VARCHAR2
384 ,P_OLD_AAT_INFORMATION4 IN VARCHAR2
385 ,P_OLD_AAT_INFORMATION5 IN VARCHAR2
386 ,P_OLD_AAT_INFORMATION6 IN VARCHAR2
387
388 ,P_OLD_AAT_INFORMATION7 IN VARCHAR2
389 ,P_OLD_AAT_INFORMATION8 IN VARCHAR2
390 ,P_OLD_AAT_INFORMATION9 IN VARCHAR2
391 ,P_OLD_AAT_INFORMATION_CATEGORY IN VARCHAR2
392 ,P_OLD_ASSIGNMENT_ID
393 IN NUMBER
394 ,P_OLD_BUSINESS_GROUP_ID IN NUMBER
395 ,P_OLD_COMPANY_CAR_CALC_METHOD IN VARCHAR2
396 ,P_OLD_COMPANY_CAR_RATES_TABLE_ IN NUMBER
397 ,P_OLD_COMPANY_CAR_SECONDARY_TA IN NUMBER
398
399 ,P_OLD_CONTRACT_TYPE IN VARCHAR2
400 ,P_OLD_EFFECTIVE_END_DATE IN DATE
401 ,P_OLD_EFFECTIVE_START_DATE IN DATE
402 ,P_OLD_LGPS_EXCLUSION_TYPE IN VARCHAR2
403 ,P_OLD_LGPS_MEMBERSHIP_NUMBER
404 IN VARCHAR2
405 ,P_OLD_LGPS_PENSIONABLE_PAY IN VARCHAR2
406 ,P_OLD_LGPS_PROCESS_FLAG IN VARCHAR2
407 ,P_OLD_LGPS_TRANS_ARRANG_FLAG IN VARCHAR2
408 ,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
409
410 ,P_OLD_PRIMARY_CAPITAL_CONTRIBU IN NUMBER
411 ,P_OLD_PRIMARY_CAR_FUEL_BENEFIT IN VARCHAR2
412 ,P_OLD_PRIMARY_CLASS_1A IN VARCHAR2
413 ,P_OLD_PRIMARY_COMPANY_CAR IN NUMBER
414
415 ,P_OLD_PRIMARY_PRIVATE_CONTRIBU IN NUMBER
416 ,P_OLD_PRIVATE_CAR IN NUMBER
417 ,P_OLD_PRIVATE_CAR_CALC_METHOD IN VARCHAR2
418 ,P_OLD_PRIVATE_CAR_ESSENTIAL_TA IN NUMBER
419 ,P_OLD_PRIVATE_CAR_RATES_TABLE_
420 IN NUMBER
421 ,P_OLD_SECONDARY_CAPITAL_CONTRI IN NUMBER
422 ,P_OLD_SECONDARY_CAR_FUEL_BENEF IN VARCHAR2
423 ,P_OLD_SECONDARY_CLASS_1A IN VARCHAR2
424 ,P_OLD_SECONDARY_COMPANY_CAR IN NUMBER
425
426 ,P_OLD_SECONDARY_PRIVATE_CONTRI IN NUMBER
427 ,P_OLD_START_DAY IN VARCHAR2
428 ,P_OLD_TP_ELECTED_PENSION IN VARCHAR2
429 ,P_OLD_TP_FAST_TRACK IN VARCHAR2
430 ,P_OLD_TP_IS_TEACHER
431 IN VARCHAR2
432 ,P_OLD_TP_SAFEGUARDED_GRADE IN NUMBER
433 ,P_OLD_TP_SAFEGUARDED_GRADE_ID IN NUMBER
434 ,P_OLD_TP_SAFEGUARDED_RATE_ID IN NUMBER
435 ,P_OLD_TP_SAFEGUARDED_RATE_TYPE IN VARCHAR2
436
437 ,P_OLD_TP_SAFEGUARDED_SPINAL_PO IN NUMBER
438 ,P_OLD_TP_SPINAL_POINT_ID IN NUMBER
439 ,P_OLD_WORK_PATTERN IN VARCHAR2
440 ) IS
441
442 --
443 /* LOCAL VARIABLE DECLARATIONS */
444 L_BUSINESS_GROUP_ID NUMBER;
445
446 L_LEGISLATION_CODE VARCHAR2(10);
447 BEGIN
448 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_ASSIGNMENT_ATTRIBUTES_F_ARU');
449 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
450 RETURN;
451 END IF;
452 /* INITIALISING LOCAL
453 VARIABLES */
454 L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
455 P_STATEMENT => 'SELECT '||P_NEW_BUSINESS_GROUP_ID||' FROM DUAL'
456 );
457 --
458 L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
459 P_BG_ID
460 => L_BUSINESS_GROUP_ID
461 );
462 --
463 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
464 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
465 P_EVENT_ID => 78,
466 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
467 P_BUSINESS_GROUP_ID =>
468 L_BUSINESS_GROUP_ID,
469 P_PAYROLL_ID => NULL
470 ) THEN
471 RETURN;
472 END IF;
473 --
474 /* GLOBAL COMPONENT CALLS */
475 PQP_GB_TP_EXTRACT_TRIGGERS.PQP_ASSIGNMENT_ATTRIBUTE_F_ARU(
476 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
477
478 P_EFFECTIVE_DATE => P_NEW_EFFECTIVE_START_DATE,
479 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
480 P_NEW_AAT_ATTRIBUTE1 => P_NEW_AAT_ATTRIBUTE1,
481 P_NEW_AAT_ATTRIBUTE10 => P_NEW_AAT_ATTRIBUTE10,
482
483 P_NEW_AAT_ATTRIBUTE11 => P_NEW_AAT_ATTRIBUTE11,
484 P_NEW_AAT_ATTRIBUTE12 => P_NEW_AAT_ATTRIBUTE12,
485 P_NEW_AAT_ATTRIBUTE13 => P_NEW_AAT_ATTRIBUTE13,
486 P_NEW_AAT_ATTRIBUTE14 => P_NEW_AAT_ATTRIBUTE14,
487
488 P_NEW_AAT_ATTRIBUTE15 => P_NEW_AAT_ATTRIBUTE15,
489 P_NEW_AAT_ATTRIBUTE16 => P_NEW_AAT_ATTRIBUTE16,
490 P_NEW_AAT_ATTRIBUTE17 => P_NEW_AAT_ATTRIBUTE17,
491 P_NEW_AAT_ATTRIBUTE18 => P_NEW_AAT_ATTRIBUTE18,
492
493 P_NEW_AAT_ATTRIBUTE19 => P_NEW_AAT_ATTRIBUTE19,
494 P_NEW_AAT_ATTRIBUTE2 => P_NEW_AAT_ATTRIBUTE2,
495 P_NEW_AAT_ATTRIBUTE20 => P_NEW_AAT_ATTRIBUTE20,
496 P_NEW_AAT_ATTRIBUTE3 => P_NEW_AAT_ATTRIBUTE3,
497
498 P_NEW_AAT_ATTRIBUTE4 => P_NEW_AAT_ATTRIBUTE4,
499 P_NEW_AAT_ATTRIBUTE5 => P_NEW_AAT_ATTRIBUTE5,
500 P_NEW_AAT_ATTRIBUTE6 => P_NEW_AAT_ATTRIBUTE6,
501 P_NEW_AAT_ATTRIBUTE7 => P_NEW_AAT_ATTRIBUTE7,
502
503 P_NEW_AAT_ATTRIBUTE8 => P_NEW_AAT_ATTRIBUTE8,
504 P_NEW_AAT_ATTRIBUTE9 => P_NEW_AAT_ATTRIBUTE9,
505 P_NEW_AAT_ATTRIBUTE_CATEGORY => P_NEW_AAT_ATTRIBUTE_CATEGORY,
506 P_NEW_AAT_INFORMATION1 => P_NEW_AAT_INFORMATION1,
507
508 P_NEW_AAT_INFORMATION10 => P_NEW_AAT_INFORMATION10,
509 P_NEW_AAT_INFORMATION11 => P_NEW_AAT_INFORMATION11,
510 P_NEW_AAT_INFORMATION12 => P_NEW_AAT_INFORMATION12,
511 P_NEW_AAT_INFORMATION13 => P_NEW_AAT_INFORMATION13,
512
513 P_NEW_AAT_INFORMATION14 => P_NEW_AAT_INFORMATION14,
514 P_NEW_AAT_INFORMATION15 => P_NEW_AAT_INFORMATION15,
515 P_NEW_AAT_INFORMATION16 => P_NEW_AAT_INFORMATION16,
516 P_NEW_AAT_INFORMATION17 => P_NEW_AAT_INFORMATION17,
517
518 P_NEW_AAT_INFORMATION18 => P_NEW_AAT_INFORMATION18,
519 P_NEW_AAT_INFORMATION19 => P_NEW_AAT_INFORMATION19,
520 P_NEW_AAT_INFORMATION2 => P_NEW_AAT_INFORMATION2,
521 P_NEW_AAT_INFORMATION20 => P_NEW_AAT_INFORMATION20,
522
523 P_NEW_AAT_INFORMATION3 => P_NEW_AAT_INFORMATION3,
524 P_NEW_AAT_INFORMATION4 => P_NEW_AAT_INFORMATION4,
525 P_NEW_AAT_INFORMATION5 => P_NEW_AAT_INFORMATION5,
526 P_NEW_AAT_INFORMATION6 => P_NEW_AAT_INFORMATION6,
527
528 P_NEW_AAT_INFORMATION7 => P_NEW_AAT_INFORMATION7,
529 P_NEW_AAT_INFORMATION8 => P_NEW_AAT_INFORMATION8,
530 P_NEW_AAT_INFORMATION9 => P_NEW_AAT_INFORMATION9,
531 P_NEW_AAT_INFORMATION_CATEGORY => P_NEW_AAT_INFORMATION_CATEGORY,
532
533 P_NEW_ASSIGNMENT_ATTRIBUTE_ID => P_NEW_ASSIGNMENT_ATTRIBUTE_ID,
534 P_NEW_ASSIGNMENT_ID => P_NEW_ASSIGNMENT_ID,
535 P_NEW_BUSINESS_GROUP_ID => P_NEW_BUSINESS_GROUP_ID,
536 P_NEW_COMPANY_CAR_CALC_METHOD =>
537 P_NEW_COMPANY_CAR_CALC_METHOD,
538 P_NEW_COMPANY_CAR_RATES_TABLE_ => P_NEW_COMPANY_CAR_RATES_TABLE_,
539 P_NEW_COMPANY_CAR_SECONDARY_TA => P_NEW_COMPANY_CAR_SECONDARY_TA,
540 P_NEW_CONTRACT_TYPE => P_NEW_CONTRACT_TYPE,
541
542 P_NEW_EFFECTIVE_END_DATE => P_NEW_EFFECTIVE_END_DATE,
543 P_NEW_EFFECTIVE_START_DATE => P_NEW_EFFECTIVE_START_DATE,
544 P_NEW_PRIMARY_CAPITAL_CONTRIBU => P_NEW_PRIMARY_CAPITAL_CONTRIBU,
545 P_NEW_PRIMARY_CAR_FUEL_BENEFIT =>
546 P_NEW_PRIMARY_CAR_FUEL_BENEFIT,
547 P_NEW_PRIMARY_CLASS_1A => P_NEW_PRIMARY_CLASS_1A,
548 P_NEW_PRIMARY_COMPANY_CAR => P_NEW_PRIMARY_COMPANY_CAR,
549 P_NEW_PRIMARY_PRIVATE_CONTRIBU => P_NEW_PRIMARY_PRIVATE_CONTRIBU,
550 P_NEW_PRIVATE_CAR
551 => P_NEW_PRIVATE_CAR,
552 P_NEW_PRIVATE_CAR_CALC_METHOD => P_NEW_PRIVATE_CAR_CALC_METHOD,
553 P_NEW_PRIVATE_CAR_ESSENTIAL_TA => P_NEW_PRIVATE_CAR_ESSENTIAL_TA,
554 P_NEW_PRIVATE_CAR_RATES_TABLE_ => P_NEW_PRIVATE_CAR_RATES_TABLE_,
555
556 P_NEW_SECONDARY_CAPITAL_CONTRI => P_NEW_SECONDARY_CAPITAL_CONTRI,
557 P_NEW_SECONDARY_CAR_FUEL_BENEF => P_NEW_SECONDARY_CAR_FUEL_BENEF,
558 P_NEW_SECONDARY_CLASS_1A => P_NEW_SECONDARY_CLASS_1A,
559 P_NEW_SECONDARY_COMPANY_CAR =>
560 P_NEW_SECONDARY_COMPANY_CAR,
561 P_NEW_SECONDARY_PRIVATE_CONTRI => P_NEW_SECONDARY_PRIVATE_CONTRI,
562 P_NEW_START_DAY => P_NEW_START_DAY,
563 P_NEW_TP_ELECTED_PENSION => P_NEW_TP_ELECTED_PENSION,
564 P_NEW_TP_FAST_TRACK
565 => P_NEW_TP_FAST_TRACK,
566 P_NEW_TP_IS_TEACHER => P_NEW_TP_IS_TEACHER,
567 P_NEW_TP_SAFEGUARDED_GRADE => P_NEW_TP_SAFEGUARDED_GRADE,
568 P_NEW_TP_SAFEGUARDED_RATE_ID => P_NEW_TP_SAFEGUARDED_RATE_ID,
569 P_NEW_TP_SAFEGUARDED_RATE_TYPE =>
570 P_NEW_TP_SAFEGUARDED_RATE_TYPE,
571 P_NEW_TP_SAFEGUARDED_SPINAL_PO => P_NEW_TP_SAFEGUARDED_SPINAL_PO,
572 P_NEW_WORK_PATTERN => P_NEW_WORK_PATTERN,
573 P_NEW_LGPS_EXCLUSION_TYPE => P_NEW_LGPS_EXCLUSION_TYPE,
574
575 P_NEW_LGPS_MEMBERSHIP_NUMBER => P_NEW_LGPS_MEMBERSHIP_NUMBER,
576 P_NEW_LGPS_PENSIONABLE_PAY => P_NEW_LGPS_PENSIONABLE_PAY,
577 P_NEW_LGPS_PROCESS_FLAG => P_NEW_LGPS_PROCESS_FLAG,
578 P_NEW_LGPS_TRANS_ARRANG_FLAG =>
579 P_NEW_LGPS_TRANS_ARRANG_FLAG,
580 P_OLD_AAT_ATTRIBUTE1 => P_OLD_AAT_ATTRIBUTE1,
581 P_OLD_AAT_ATTRIBUTE10 => P_OLD_AAT_ATTRIBUTE10,
582 P_OLD_AAT_ATTRIBUTE11 => P_OLD_AAT_ATTRIBUTE11,
583 P_OLD_AAT_ATTRIBUTE12 =>
584 P_OLD_AAT_ATTRIBUTE12,
585 P_OLD_AAT_ATTRIBUTE13 => P_OLD_AAT_ATTRIBUTE13,
586 P_OLD_AAT_ATTRIBUTE14 => P_OLD_AAT_ATTRIBUTE14,
587 P_OLD_AAT_ATTRIBUTE15 => P_OLD_AAT_ATTRIBUTE15,
588 P_OLD_AAT_ATTRIBUTE16 =>
589 P_OLD_AAT_ATTRIBUTE16,
590 P_OLD_AAT_ATTRIBUTE17 => P_OLD_AAT_ATTRIBUTE17,
591 P_OLD_AAT_ATTRIBUTE18 => P_OLD_AAT_ATTRIBUTE18,
592 P_OLD_AAT_ATTRIBUTE19 => P_OLD_AAT_ATTRIBUTE19,
593 P_OLD_AAT_ATTRIBUTE2 =>
594 P_OLD_AAT_ATTRIBUTE2,
595 P_OLD_AAT_ATTRIBUTE20 => P_OLD_AAT_ATTRIBUTE20,
596 P_OLD_AAT_ATTRIBUTE3 => P_OLD_AAT_ATTRIBUTE3,
597 P_OLD_AAT_ATTRIBUTE4 => P_OLD_AAT_ATTRIBUTE4,
598 P_OLD_AAT_ATTRIBUTE5 =>
599 P_OLD_AAT_ATTRIBUTE5,
600 P_OLD_AAT_ATTRIBUTE6 => P_OLD_AAT_ATTRIBUTE6,
601 P_OLD_AAT_ATTRIBUTE7 => P_OLD_AAT_ATTRIBUTE7,
602 P_OLD_AAT_ATTRIBUTE8 => P_OLD_AAT_ATTRIBUTE8,
603 P_OLD_AAT_ATTRIBUTE9 =>
604 P_OLD_AAT_ATTRIBUTE9,
605 P_OLD_AAT_ATTRIBUTE_CATEGORY => P_OLD_AAT_ATTRIBUTE_CATEGORY,
606 P_OLD_AAT_INFORMATION1 => P_OLD_AAT_INFORMATION1,
610 P_OLD_AAT_INFORMATION12 => P_OLD_AAT_INFORMATION12,
607 P_OLD_AAT_INFORMATION10 => P_OLD_AAT_INFORMATION10,
608 P_OLD_AAT_INFORMATION11 =>
609 P_OLD_AAT_INFORMATION11,
611 P_OLD_AAT_INFORMATION13 => P_OLD_AAT_INFORMATION13,
612 P_OLD_AAT_INFORMATION14 => P_OLD_AAT_INFORMATION14,
613 P_OLD_AAT_INFORMATION15 =>
614 P_OLD_AAT_INFORMATION15,
615 P_OLD_AAT_INFORMATION16 => P_OLD_AAT_INFORMATION16,
616 P_OLD_AAT_INFORMATION17 => P_OLD_AAT_INFORMATION17,
617 P_OLD_AAT_INFORMATION18 => P_OLD_AAT_INFORMATION18,
618 P_OLD_AAT_INFORMATION19 =>
619 P_OLD_AAT_INFORMATION19,
620 P_OLD_AAT_INFORMATION2 => P_OLD_AAT_INFORMATION2,
621 P_OLD_AAT_INFORMATION20 => P_OLD_AAT_INFORMATION20,
622 P_OLD_AAT_INFORMATION3 => P_OLD_AAT_INFORMATION3,
623 P_OLD_AAT_INFORMATION4 =>
624 P_OLD_AAT_INFORMATION4,
625 P_OLD_AAT_INFORMATION5 => P_OLD_AAT_INFORMATION5,
626 P_OLD_AAT_INFORMATION6 => P_OLD_AAT_INFORMATION6,
627 P_OLD_AAT_INFORMATION7 => P_OLD_AAT_INFORMATION7,
628 P_OLD_AAT_INFORMATION8 =>
629 P_OLD_AAT_INFORMATION8,
630 P_OLD_AAT_INFORMATION9 => P_OLD_AAT_INFORMATION9,
631 P_OLD_AAT_INFORMATION_CATEGORY => P_OLD_AAT_INFORMATION_CATEGORY,
632 P_OLD_ASSIGNMENT_ATTRIBUTE_ID => P_NEW_ASSIGNMENT_ATTRIBUTE_ID,
633 P_OLD_ASSIGNMENT_ID
634 => P_OLD_ASSIGNMENT_ID,
635 P_OLD_BUSINESS_GROUP_ID => P_OLD_BUSINESS_GROUP_ID,
636 P_OLD_COMPANY_CAR_CALC_METHOD => P_OLD_COMPANY_CAR_CALC_METHOD,
637 P_OLD_COMPANY_CAR_RATES_TABLE_ => P_OLD_COMPANY_CAR_RATES_TABLE_,
638
639 P_OLD_COMPANY_CAR_SECONDARY_TA => P_NEW_COMPANY_CAR_SECONDARY_TA,
640 P_OLD_CONTRACT_TYPE => P_OLD_CONTRACT_TYPE,
641 P_OLD_EFFECTIVE_END_DATE => P_OLD_EFFECTIVE_END_DATE,
642 P_OLD_EFFECTIVE_START_DATE => P_OLD_EFFECTIVE_START_DATE,
643
644 P_OLD_PRIMARY_CAPITAL_CONTRIBU => P_NEW_PRIMARY_CAPITAL_CONTRIBU,
645 P_OLD_PRIMARY_CAR_FUEL_BENEFIT => P_OLD_PRIMARY_CAR_FUEL_BENEFIT,
646 P_OLD_PRIMARY_CLASS_1A => P_OLD_PRIMARY_CLASS_1A,
647 P_OLD_PRIMARY_COMPANY_CAR =>
648 P_OLD_PRIMARY_COMPANY_CAR,
649 P_OLD_PRIMARY_PRIVATE_CONTRIBU => P_NEW_PRIMARY_PRIVATE_CONTRIBU,
650 P_OLD_PRIVATE_CAR => P_OLD_PRIVATE_CAR,
651 P_OLD_PRIVATE_CAR_CALC_METHOD => P_OLD_PRIVATE_CAR_CALC_METHOD,
652
653 P_OLD_PRIVATE_CAR_ESSENTIAL_TA => P_NEW_PRIVATE_CAR_ESSENTIAL_TA,
654 P_OLD_PRIVATE_CAR_RATES_TABLE_ => P_OLD_PRIVATE_CAR_RATES_TABLE_,
655 P_OLD_SECONDARY_CAPITAL_CONTRI => P_NEW_SECONDARY_CAPITAL_CONTRI,
656 P_OLD_SECONDARY_CAR_FUEL_BENEF =>
657 P_OLD_SECONDARY_CAR_FUEL_BENEF,
658 P_OLD_SECONDARY_CLASS_1A => P_OLD_SECONDARY_CLASS_1A,
659 P_OLD_SECONDARY_COMPANY_CAR => P_OLD_SECONDARY_COMPANY_CAR,
660 P_OLD_SECONDARY_PRIVATE_CONTRI => P_NEW_SECONDARY_PRIVATE_CONTRI,
661 P_OLD_START_DAY
662 => P_OLD_START_DAY,
663 P_OLD_TP_ELECTED_PENSION => P_OLD_TP_ELECTED_PENSION,
664 P_OLD_TP_FAST_TRACK => P_OLD_TP_FAST_TRACK,
665 P_OLD_TP_IS_TEACHER => P_OLD_TP_IS_TEACHER,
666 P_OLD_TP_SAFEGUARDED_GRADE =>
667 P_OLD_TP_SAFEGUARDED_GRADE,
668 P_OLD_TP_SAFEGUARDED_RATE_ID => P_OLD_TP_SAFEGUARDED_RATE_ID,
669 P_OLD_TP_SAFEGUARDED_RATE_TYPE => P_OLD_TP_SAFEGUARDED_RATE_TYPE,
670 P_OLD_TP_SAFEGUARDED_SPINAL_PO => P_OLD_TP_SAFEGUARDED_SPINAL_PO,
671
672 P_OLD_WORK_PATTERN => P_OLD_WORK_PATTERN,
673 P_OLD_LGPS_EXCLUSION_TYPE => P_OLD_LGPS_EXCLUSION_TYPE,
674 P_OLD_LGPS_MEMBERSHIP_NUMBER => P_OLD_LGPS_MEMBERSHIP_NUMBER,
675 P_OLD_LGPS_PENSIONABLE_PAY => P_OLD_LGPS_PENSIONABLE_PAY,
676
677 P_OLD_LGPS_PROCESS_FLAG => P_OLD_LGPS_PROCESS_FLAG,
678 P_OLD_LGPS_TRANS_ARRANG_FLAG => P_OLD_LGPS_TRANS_ARRANG_FLAG
679 );
680 --
681 /* LEGISLATION SPECIFIC COMPONENT CALLS */
682 --
683 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
684 --
685 /* PAYROLL
686 SPECIFIC COMPONENT CALLS */
687 --
688 EXCEPTION
689 WHEN OTHERS THEN
690 HR_UTILITY.SET_LOCATION('PQP_ASSIGNMENT_ATTRIBUTES__ARU',ABS(SQLCODE));
691 RAISE;
692 --
693 END PQP_ASSIGNMENT_ATTRIBUTES__ARU;
694
695 --
696
697 /*
698 ================================================
699 THIS IS A DYNAMICALLY GENERATED PACKAGE PROCEDURE
700 WITH CODE REPRESENTING A DYNAMIC TRIGGER
701 ================================================
702 ** DO NOT CHANGE MANUALLY **
703
704 ------------------------------------------------
705 NAME: PQP_ASSIGNMENT_ATTRIBUTES__ARD
706 TABLE: PQP_ASSIGNMENT_ATTRIBUTES_F
707 ACTION: DELETE
708 GENERATED DATE: 27/11/2012 04:01
709 DESCRIPTION: CONTINUOUS CALCULATION TRIGGER ON
710 DELETE OF PQP_ASSIGNMENT_ATTRIBUTES
711 FULL TRIGGER NAME: PQP_ASSIGNMENT_ATTRIBUTES_F_ARD
712 ================================================
713 */
714 --
715 PROCEDURE PQP_ASSIGNMENT_ATTRIBUTES__ARD
716 (
717 P_NEW_ASSIGNMENT_ATTRIBUTE_ID IN NUMBER
718
719 ,P_NEW_DATETRACK_MODE IN VARCHAR2
720 ,P_NEW_EFFECTIVE_DATE IN DATE
721 ,P_NEW_EFFECTIVE_END_DATE IN DATE
722 ,P_NEW_EFFECTIVE_START_DATE IN DATE
723 ,P_NEW_VALIDATION_END_DATE
724 IN DATE
725 ,P_NEW_VALIDATION_START_DATE IN DATE
729
726 ,P_OLD_AAT_ATTRIBUTE1 IN VARCHAR2
727 ,P_OLD_AAT_ATTRIBUTE10 IN VARCHAR2
728 ,P_OLD_AAT_ATTRIBUTE11 IN VARCHAR2
730 ,P_OLD_AAT_ATTRIBUTE12 IN VARCHAR2
731 ,P_OLD_AAT_ATTRIBUTE13 IN VARCHAR2
732 ,P_OLD_AAT_ATTRIBUTE14 IN VARCHAR2
733 ,P_OLD_AAT_ATTRIBUTE15 IN VARCHAR2
734 ,P_OLD_AAT_ATTRIBUTE16
735 IN VARCHAR2
736 ,P_OLD_AAT_ATTRIBUTE17 IN VARCHAR2
737 ,P_OLD_AAT_ATTRIBUTE18 IN VARCHAR2
738 ,P_OLD_AAT_ATTRIBUTE19 IN VARCHAR2
739 ,P_OLD_AAT_ATTRIBUTE2 IN
740 VARCHAR2
741 ,P_OLD_AAT_ATTRIBUTE20 IN VARCHAR2
742 ,P_OLD_AAT_ATTRIBUTE3 IN VARCHAR2
743 ,P_OLD_AAT_ATTRIBUTE4 IN VARCHAR2
744 ,P_OLD_AAT_ATTRIBUTE5 IN VARCHAR2
745
746 ,P_OLD_AAT_ATTRIBUTE6 IN VARCHAR2
747 ,P_OLD_AAT_ATTRIBUTE7 IN VARCHAR2
748 ,P_OLD_AAT_ATTRIBUTE8 IN VARCHAR2
749 ,P_OLD_AAT_ATTRIBUTE9 IN VARCHAR2
750
751 ,P_OLD_AAT_ATTRIBUTE_CATEGORY IN VARCHAR2
752 ,P_OLD_AAT_INFORMATION1 IN VARCHAR2
753 ,P_OLD_AAT_INFORMATION10 IN VARCHAR2
754 ,P_OLD_AAT_INFORMATION11 IN VARCHAR2
755 ,P_OLD_AAT_INFORMATION12
756 IN VARCHAR2
757 ,P_OLD_AAT_INFORMATION13 IN VARCHAR2
758 ,P_OLD_AAT_INFORMATION14 IN VARCHAR2
759 ,P_OLD_AAT_INFORMATION15 IN VARCHAR2
760 ,P_OLD_AAT_INFORMATION16 IN
761 VARCHAR2
762 ,P_OLD_AAT_INFORMATION17 IN VARCHAR2
763 ,P_OLD_AAT_INFORMATION18 IN VARCHAR2
764 ,P_OLD_AAT_INFORMATION19 IN VARCHAR2
765 ,P_OLD_AAT_INFORMATION2 IN VARCHAR2
766
767 ,P_OLD_AAT_INFORMATION20 IN VARCHAR2
768 ,P_OLD_AAT_INFORMATION3 IN VARCHAR2
769 ,P_OLD_AAT_INFORMATION4 IN VARCHAR2
770 ,P_OLD_AAT_INFORMATION5 IN VARCHAR2
771 ,P_OLD_AAT_INFORMATION6
772 IN VARCHAR2
773 ,P_OLD_AAT_INFORMATION7 IN VARCHAR2
774 ,P_OLD_AAT_INFORMATION8 IN VARCHAR2
775 ,P_OLD_AAT_INFORMATION9 IN VARCHAR2
776 ,P_OLD_AAT_INFORMATION_CATEGORY IN
777 VARCHAR2
778 ,P_OLD_ASSIGNMENT_ID IN NUMBER
779 ,P_OLD_BUSINESS_GROUP_ID IN NUMBER
780 ,P_OLD_COMPANY_CAR_CALC_METHOD IN VARCHAR2
781 ,P_OLD_COMPANY_CAR_RATES_TABLE_ IN NUMBER
782
783 ,P_OLD_COMPANY_CAR_SECONDARY_TA IN NUMBER
784 ,P_OLD_CONTRACT_TYPE IN VARCHAR2
785 ,P_OLD_EFFECTIVE_END_DATE IN DATE
786 ,P_OLD_EFFECTIVE_START_DATE IN DATE
787 ,P_OLD_LGPS_EXCLUSION_TYPE
788 IN VARCHAR2
789 ,P_OLD_LGPS_MEMBERSHIP_NUMBER IN VARCHAR2
790 ,P_OLD_LGPS_PENSIONABLE_PAY IN VARCHAR2
791 ,P_OLD_LGPS_PROCESS_FLAG IN VARCHAR2
792 ,P_OLD_LGPS_TRANS_ARRANG_FLAG IN VARCHAR2
793
794 ,P_OLD_OBJECT_VERSION_NUMBER IN NUMBER
795 ,P_OLD_PRIMARY_CAPITAL_CONTRIBU IN NUMBER
796 ,P_OLD_PRIMARY_CAR_FUEL_BENEFIT IN VARCHAR2
797 ,P_OLD_PRIMARY_CLASS_1A IN VARCHAR2
798 ,P_OLD_PRIMARY_COMPANY_CAR
799 IN NUMBER
800 ,P_OLD_PRIMARY_PRIVATE_CONTRIBU IN NUMBER
801 ,P_OLD_PRIVATE_CAR IN NUMBER
802 ,P_OLD_PRIVATE_CAR_CALC_METHOD IN VARCHAR2
803 ,P_OLD_PRIVATE_CAR_ESSENTIAL_TA IN NUMBER
804
805 ,P_OLD_PRIVATE_CAR_RATES_TABLE_ IN NUMBER
806 ,P_OLD_SECONDARY_CAPITAL_CONTRI IN NUMBER
807 ,P_OLD_SECONDARY_CAR_FUEL_BENEF IN VARCHAR2
808 ,P_OLD_SECONDARY_CLASS_1A IN VARCHAR2
809 ,P_OLD_SECONDARY_COMPANY_CAR
810 IN NUMBER
811 ,P_OLD_SECONDARY_PRIVATE_CONTRI IN NUMBER
812 ,P_OLD_START_DAY IN VARCHAR2
813 ,P_OLD_TP_ELECTED_PENSION IN VARCHAR2
814 ,P_OLD_TP_FAST_TRACK IN VARCHAR2
815
816 ,P_OLD_TP_IS_TEACHER IN VARCHAR2
817 ,P_OLD_TP_SAFEGUARDED_GRADE IN NUMBER
818 ,P_OLD_TP_SAFEGUARDED_GRADE_ID IN NUMBER
819 ,P_OLD_TP_SAFEGUARDED_RATE_ID IN NUMBER
820 ,P_OLD_TP_SAFEGUARDED_RATE_TYPE
821 IN VARCHAR2
822 ,P_OLD_TP_SAFEGUARDED_SPINAL_PO IN NUMBER
823 ,P_OLD_TP_SPINAL_POINT_ID IN NUMBER
824 ,P_OLD_WORK_PATTERN IN VARCHAR2
825 ) IS
826
827 --
828 /* LOCAL VARIABLE DECLARATIONS */
829
830 L_BUSINESS_GROUP_ID NUMBER;
831 L_LEGISLATION_CODE VARCHAR2(10);
832 BEGIN
833 HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_ASSIGNMENT_ATTRIBUTES_F_ARD');
834 IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
835
836 RETURN;
837 END IF;
838 /* INITIALISING LOCAL VARIABLES */
839 L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
840 P_STATEMENT => 'SELECT '||P_OLD_BUSINESS_GROUP_ID||' FROM SYS.DUAL'
841 );
842 --
843 L_LEGISLATION_CODE :=
847 --
844 PAY_CORE_UTILS.GET_LEGISLATION_CODE(
845 P_BG_ID => L_BUSINESS_GROUP_ID
846 );
848 /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
849 IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
850 P_EVENT_ID => 2133,
851
852 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
853 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
854 P_PAYROLL_ID => NULL
855 ) THEN
856 RETURN;
857 END IF;
858 --
859 /* GLOBAL COMPONENT CALLS */
860 PQP_GB_TP_EXTRACT_TRIGGERS.PQP_ASSIGNMENT_ATTRIBUTE_F_ARD(
861
862 P_BUSINESS_GROUP_ID => L_BUSINESS_GROUP_ID,
863 P_LEGISLATION_CODE => L_LEGISLATION_CODE,
864 P_NEW_EFFECTIVE_END_DATE => P_NEW_EFFECTIVE_END_DATE,
865 P_NEW_EFFECTIVE_START_DATE => P_NEW_EFFECTIVE_START_DATE,
866
867 P_OLD_ASSIGNMENT_ATTRIBUTE_ID => P_NEW_ASSIGNMENT_ATTRIBUTE_ID,
868 P_OLD_ASSIGNMENT_ID => P_OLD_ASSIGNMENT_ID,
869 P_OLD_EFFECTIVE_END_DATE => P_OLD_EFFECTIVE_END_DATE,
870 P_OLD_EFFECTIVE_START_DATE => P_OLD_EFFECTIVE_START_DATE
871
872 );
873 --
874 /* LEGISLATION SPECIFIC COMPONENT CALLS */
875 --
876 /* BUSINESS GROUP SPECIFIC COMPONENT CALLS */
877 --
878 /* PAYROLL SPECIFIC COMPONENT CALLS */
879 --
880 EXCEPTION
881 WHEN OTHERS THEN
882
883 HR_UTILITY.SET_LOCATION('PQP_ASSIGNMENT_ATTRIBUTES__ARD',ABS(SQLCODE));
884 RAISE;
885 --
886 END PQP_ASSIGNMENT_ATTRIBUTES__ARD;
887
888 --
889
890 /*
891 ================================================
892 This is a dynamically generated procedure.
893 Will be called by API.
894 ================================================
895 ** DO NOT CHANGE MANUALLY **
896
897 ------------------------------------------------
898 Name: AFTER_INSERT
899 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
900 Action: INSERT
901 Generated Date: 27/11/2012 04:01
902 Description: Called as part of INSERT process
903
904 ================================================
905 */
906
907 --
908 PROCEDURE AFTER_INSERT
909 (
910 P_EFFECTIVE_DATE in DATE
911 ,P_VALIDATION_START_DATE in DATE
912 ,P_VALIDATION_END_DATE in DATE
913
914 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
915 ,P_EFFECTIVE_START_DATE in DATE
916 ,P_EFFECTIVE_END_DATE in DATE
917 ,P_BUSINESS_GROUP_ID in NUMBER
918 ,P_ASSIGNMENT_ID
919 in NUMBER
920 ,P_CONTRACT_TYPE in VARCHAR2
921 ,P_WORK_PATTERN in VARCHAR2
922 ,P_START_DAY in VARCHAR2
923 ,P_OBJECT_VERSION_NUMBER in NUMBER
924
925 ,P_PRIMARY_COMPANY_CAR in NUMBER
926 ,P_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
927 ,P_PRIMARY_CLASS_1A in VARCHAR2
928 ,P_PRIMARY_CAPITAL_CONTRIBUTION in NUMBER
929
930 ,P_PRIMARY_PRIVATE_CONTRIBUTION in NUMBER
931 ,P_SECONDARY_COMPANY_CAR in NUMBER
932 ,P_SECONDARY_CAR_FUEL_BENEFIT in VARCHAR2
933 ,P_SECONDARY_CLASS_1A in VARCHAR2
934
935 ,P_SECONDARY_CAPITAL_CONTRIBUTI in NUMBER
936 ,P_SECONDARY_PRIVATE_CONTRIBUTI in NUMBER
937 ,P_COMPANY_CAR_CALC_METHOD in VARCHAR2
938 ,P_COMPANY_CAR_RATES_TABLE_ID in NUMBER
939 ,P_COMPANY_CAR_SECONDARY_TABLE
940 in NUMBER
941 ,P_PRIVATE_CAR in NUMBER
942 ,P_PRIVATE_CAR_CALC_METHOD in VARCHAR2
943 ,P_PRIVATE_CAR_RATES_TABLE_ID in NUMBER
944 ,P_PRIVATE_CAR_ESSENTIAL_TABLE in NUMBER
945
946 ,P_TP_IS_TEACHER in VARCHAR2
947 ,P_TP_HEADTEACHER_GRP_CODE in NUMBER
948 ,P_TP_SAFEGUARDED_GRADE in VARCHAR2
949 ,P_TP_SAFEGUARDED_GRADE_ID in NUMBER
950 ,P_TP_SAFEGUARDED_RATE_TYPE
951 in VARCHAR2
952 ,P_TP_SAFEGUARDED_RATE_ID in NUMBER
953 ,P_TP_SPINAL_POINT_ID in NUMBER
954 ,P_TP_ELECTED_PENSION in VARCHAR2
955 ,P_TP_FAST_TRACK in VARCHAR2
956
957 ,P_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
958 ,P_AAT_ATTRIBUTE1 in VARCHAR2
959 ,P_AAT_ATTRIBUTE2 in VARCHAR2
960 ,P_AAT_ATTRIBUTE3 in VARCHAR2
961 ,P_AAT_ATTRIBUTE4
962 in VARCHAR2
963 ,P_AAT_ATTRIBUTE5 in VARCHAR2
964 ,P_AAT_ATTRIBUTE6 in VARCHAR2
965 ,P_AAT_ATTRIBUTE7 in VARCHAR2
966 ,P_AAT_ATTRIBUTE8 in
967 VARCHAR2
968 ,P_AAT_ATTRIBUTE9 in VARCHAR2
969 ,P_AAT_ATTRIBUTE10 in VARCHAR2
970 ,P_AAT_ATTRIBUTE11 in VARCHAR2
971 ,P_AAT_ATTRIBUTE12 in VARCHAR2
972
973 ,P_AAT_ATTRIBUTE13 in VARCHAR2
974 ,P_AAT_ATTRIBUTE14 in VARCHAR2
975 ,P_AAT_ATTRIBUTE15 in VARCHAR2
976 ,P_AAT_ATTRIBUTE16 in VARCHAR2
977 ,P_AAT_ATTRIBUTE17
978 in VARCHAR2
982 ,P_AAT_INFORMATION_CATEGORY in
979 ,P_AAT_ATTRIBUTE18 in VARCHAR2
980 ,P_AAT_ATTRIBUTE19 in VARCHAR2
981 ,P_AAT_ATTRIBUTE20 in VARCHAR2
983 VARCHAR2
984 ,P_AAT_INFORMATION1 in VARCHAR2
985 ,P_AAT_INFORMATION2 in VARCHAR2
986 ,P_AAT_INFORMATION3 in VARCHAR2
987 ,P_AAT_INFORMATION4 in VARCHAR2
988
989 ,P_AAT_INFORMATION5 in VARCHAR2
990 ,P_AAT_INFORMATION6 in VARCHAR2
991 ,P_AAT_INFORMATION7 in VARCHAR2
992 ,P_AAT_INFORMATION8 in VARCHAR2
993 ,P_AAT_INFORMATION9
994 in VARCHAR2
995 ,P_AAT_INFORMATION10 in VARCHAR2
996 ,P_AAT_INFORMATION11 in VARCHAR2
997 ,P_AAT_INFORMATION12 in VARCHAR2
998 ,P_AAT_INFORMATION13 in
999 VARCHAR2
1000 ,P_AAT_INFORMATION14 in VARCHAR2
1001 ,P_AAT_INFORMATION15 in VARCHAR2
1002 ,P_AAT_INFORMATION16 in VARCHAR2
1003 ,P_AAT_INFORMATION17 in VARCHAR2
1004
1005 ,P_AAT_INFORMATION18 in VARCHAR2
1006 ,P_AAT_INFORMATION19 in VARCHAR2
1007 ,P_AAT_INFORMATION20 in VARCHAR2
1008 ,P_LGPS_PROCESS_FLAG in VARCHAR2
1009 ,P_LGPS_EXCLUSION_TYPE
1010 in VARCHAR2
1011 ,P_LGPS_PENSIONABLE_PAY in VARCHAR2
1012 ,P_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
1013 ,P_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
1014 ) IS
1015 l_mode varchar2(80);
1016
1017 --
1018 BEGIN
1019
1020 --
1021
1022 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
1023 /* Mechanism for event capture to know whats occurred */
1024 l_mode := pay_dyn_triggers.g_dyt_mode;
1025 pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
1026
1027 --
1028
1029 if (paywsdyg_pkg.trigger_enabled('PQP_ASSIGNMENT_ATTRIBUTES_F_ARI')) then
1030 PQP_ASSIGNMENT_ATTRIBUTES__ARI(
1031 p_new_AAT_ATTRIBUTE1 => P_AAT_ATTRIBUTE1
1032 ,p_new_AAT_ATTRIBUTE10 => P_AAT_ATTRIBUTE10
1033
1034 ,p_new_AAT_ATTRIBUTE11 => P_AAT_ATTRIBUTE11
1035 ,p_new_AAT_ATTRIBUTE12 => P_AAT_ATTRIBUTE12
1036 ,p_new_AAT_ATTRIBUTE13 => P_AAT_ATTRIBUTE13
1037 ,p_new_AAT_ATTRIBUTE14 =>
1038 P_AAT_ATTRIBUTE14
1039 ,p_new_AAT_ATTRIBUTE15 => P_AAT_ATTRIBUTE15
1040 ,p_new_AAT_ATTRIBUTE16 => P_AAT_ATTRIBUTE16
1041 ,p_new_AAT_ATTRIBUTE17 => P_AAT_ATTRIBUTE17
1042 ,p_new_AAT_ATTRIBUTE18
1043 => P_AAT_ATTRIBUTE18
1044 ,p_new_AAT_ATTRIBUTE19 => P_AAT_ATTRIBUTE19
1045 ,p_new_AAT_ATTRIBUTE2 => P_AAT_ATTRIBUTE2
1046 ,p_new_AAT_ATTRIBUTE20 => P_AAT_ATTRIBUTE20
1047
1048 ,p_new_AAT_ATTRIBUTE3 => P_AAT_ATTRIBUTE3
1049 ,p_new_AAT_ATTRIBUTE4 => P_AAT_ATTRIBUTE4
1050 ,p_new_AAT_ATTRIBUTE5 => P_AAT_ATTRIBUTE5
1051 ,p_new_AAT_ATTRIBUTE6 =>
1052 P_AAT_ATTRIBUTE6
1053 ,p_new_AAT_ATTRIBUTE7 => P_AAT_ATTRIBUTE7
1054 ,p_new_AAT_ATTRIBUTE8 => P_AAT_ATTRIBUTE8
1055 ,p_new_AAT_ATTRIBUTE9 => P_AAT_ATTRIBUTE9
1056 ,p_new_AAT_ATTRIBUTE_CATEGORY
1057 => P_AAT_ATTRIBUTE_CATEGORY
1058 ,p_new_AAT_INFORMATION1 => P_AAT_INFORMATION1
1059 ,p_new_AAT_INFORMATION10 => P_AAT_INFORMATION10
1060 ,p_new_AAT_INFORMATION11 => P_AAT_INFORMATION11
1061
1062 ,p_new_AAT_INFORMATION12 => P_AAT_INFORMATION12
1063 ,p_new_AAT_INFORMATION13 => P_AAT_INFORMATION13
1064 ,p_new_AAT_INFORMATION14 => P_AAT_INFORMATION14
1065 ,p_new_AAT_INFORMATION15 =>
1066 P_AAT_INFORMATION15
1067 ,p_new_AAT_INFORMATION16 => P_AAT_INFORMATION16
1068 ,p_new_AAT_INFORMATION17 => P_AAT_INFORMATION17
1069 ,p_new_AAT_INFORMATION18 => P_AAT_INFORMATION18
1070
1071 ,p_new_AAT_INFORMATION19 => P_AAT_INFORMATION19
1072 ,p_new_AAT_INFORMATION2 => P_AAT_INFORMATION2
1073 ,p_new_AAT_INFORMATION20 => P_AAT_INFORMATION20
1074 ,p_new_AAT_INFORMATION3 =>
1075 P_AAT_INFORMATION3
1076 ,p_new_AAT_INFORMATION4 => P_AAT_INFORMATION4
1077 ,p_new_AAT_INFORMATION5 => P_AAT_INFORMATION5
1078 ,p_new_AAT_INFORMATION6 => P_AAT_INFORMATION6
1079 ,p_new_AAT_INFORMATION7
1080 => P_AAT_INFORMATION7
1081 ,p_new_AAT_INFORMATION8 => P_AAT_INFORMATION8
1082 ,p_new_AAT_INFORMATION9 => P_AAT_INFORMATION9
1083 ,p_new_AAT_INFORMATION_CATEGORY =>
1084 P_AAT_INFORMATION_CATEGORY
1085 ,p_new_ASSIGNMENT_ATTRIBUTE_ID => P_ASSIGNMENT_ATTRIBUTE_ID
1086 ,p_new_ASSIGNMENT_ID => P_ASSIGNMENT_ID
1087 ,p_new_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1088
1089 ,p_new_COMPANY_CAR_CALC_METHOD => P_COMPANY_CAR_CALC_METHOD
1090 ,p_new_COMPANY_CAR_RATES_TABLE_ => P_COMPANY_CAR_RATES_TABLE_ID
1094 ,p_new_EFFECTIVE_DATE => P_EFFECTIVE_DATE
1091 ,p_new_COMPANY_CAR_SECONDARY_TA => P_COMPANY_CAR_SECONDARY_TABLE
1092
1093 ,p_new_CONTRACT_TYPE => P_CONTRACT_TYPE
1095 ,p_new_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
1096 ,p_new_EFFECTIVE_START_DATE =>
1097 P_EFFECTIVE_START_DATE
1098 ,p_new_LGPS_EXCLUSION_TYPE => P_LGPS_EXCLUSION_TYPE
1099 ,p_new_LGPS_MEMBERSHIP_NUMBER => P_LGPS_MEMBERSHIP_NUMBER
1100 ,p_new_LGPS_PENSIONABLE_PAY => P_LGPS_PENSIONABLE_PAY
1101
1102 ,p_new_LGPS_PROCESS_FLAG => P_LGPS_PROCESS_FLAG
1103 ,p_new_LGPS_TRANS_ARRANG_FLAG => P_LGPS_TRANS_ARRANG_FLAG
1104 ,p_new_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
1105 ,p_new_PRIMARY_CAPITAL_CONTRIBU
1106 => P_PRIMARY_CAPITAL_CONTRIBUTION
1107 ,p_new_PRIMARY_CAR_FUEL_BENEFIT => P_PRIMARY_CAR_FUEL_BENEFIT
1108 ,p_new_PRIMARY_CLASS_1A => P_PRIMARY_CLASS_1A
1109 ,p_new_PRIMARY_COMPANY_CAR =>
1110 P_PRIMARY_COMPANY_CAR
1111 ,p_new_PRIMARY_PRIVATE_CONTRIBU => P_PRIMARY_PRIVATE_CONTRIBUTION
1112 ,p_new_PRIVATE_CAR => P_PRIVATE_CAR
1113 ,p_new_PRIVATE_CAR_CALC_METHOD => P_PRIVATE_CAR_CALC_METHOD
1114
1115 ,p_new_PRIVATE_CAR_ESSENTIAL_TA => P_PRIVATE_CAR_ESSENTIAL_TABLE
1116 ,p_new_PRIVATE_CAR_RATES_TABLE_ => P_PRIVATE_CAR_RATES_TABLE_ID
1117 ,p_new_SECONDARY_CAPITAL_CONTRI => P_SECONDARY_CAPITAL_CONTRIBUTI
1118
1119 ,p_new_SECONDARY_CAR_FUEL_BENEF => P_SECONDARY_CAR_FUEL_BENEFIT
1120 ,p_new_SECONDARY_CLASS_1A => P_SECONDARY_CLASS_1A
1121 ,p_new_SECONDARY_COMPANY_CAR => P_SECONDARY_COMPANY_CAR
1122
1123 ,p_new_SECONDARY_PRIVATE_CONTRI => P_SECONDARY_PRIVATE_CONTRIBUTI
1124 ,p_new_START_DAY => P_START_DAY
1125 ,p_new_TP_ELECTED_PENSION => P_TP_ELECTED_PENSION
1126 ,p_new_TP_FAST_TRACK
1127 => P_TP_FAST_TRACK
1128 ,p_new_TP_IS_TEACHER => P_TP_IS_TEACHER
1129 ,p_new_TP_SAFEGUARDED_GRADE => P_TP_SAFEGUARDED_GRADE
1130 ,p_new_TP_SAFEGUARDED_GRADE_ID => P_TP_SAFEGUARDED_GRADE_ID
1131
1132 ,p_new_TP_SAFEGUARDED_RATE_ID => P_TP_SAFEGUARDED_RATE_ID
1133 ,p_new_TP_SAFEGUARDED_RATE_TYPE => P_TP_SAFEGUARDED_RATE_TYPE
1134 ,p_new_TP_SAFEGUARDED_SPINAL_PO => P_TP_SPINAL_POINT_ID
1135 ,p_new_TP_SPINAL_POINT_ID
1136 => P_TP_SPINAL_POINT_ID
1137 ,p_new_VALIDATION_END_DATE => P_VALIDATION_END_DATE
1138 ,p_new_VALIDATION_START_DATE => P_VALIDATION_START_DATE
1139 ,p_new_WORK_PATTERN => P_WORK_PATTERN
1140 );
1141
1142 end if;
1143
1144 --
1145 pay_dyn_triggers.g_dyt_mode := l_mode;
1146
1147 --
1148 EXCEPTION
1149 WHEN OTHERS THEN
1150 hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
1151 pay_dyn_triggers.g_dyt_mode := l_mode;
1152 RAISE;
1153 --
1154 END AFTER_INSERT;
1155
1156 --
1157
1158 /*
1159 ================================================
1160 This is a dynamically generated procedure.
1161 Will be called by API.
1162 ================================================
1163 ** DO NOT CHANGE MANUALLY **
1164
1165 ------------------------------------------------
1166 Name: AFTER_UPDATE
1167 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
1168 Action: UPDATE
1169 Generated Date: 27/11/2012 04:01
1170 Description: Called as part of UPDATE process
1171
1172 ================================================
1173 */
1174
1175 --
1176 PROCEDURE AFTER_UPDATE
1177 (
1178 P_EFFECTIVE_DATE in DATE
1179 ,P_DATETRACK_MODE in VARCHAR2
1180 ,P_VALIDATION_START_DATE in DATE
1181
1182 ,P_VALIDATION_END_DATE in DATE
1183 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
1184 ,P_EFFECTIVE_START_DATE in DATE
1185 ,P_EFFECTIVE_END_DATE in DATE
1186 ,P_BUSINESS_GROUP_ID
1187 in NUMBER
1188 ,P_ASSIGNMENT_ID in NUMBER
1189 ,P_CONTRACT_TYPE in VARCHAR2
1190 ,P_WORK_PATTERN in VARCHAR2
1191 ,P_START_DAY in VARCHAR2
1192
1193 ,P_OBJECT_VERSION_NUMBER in NUMBER
1194 ,P_PRIMARY_COMPANY_CAR in NUMBER
1195 ,P_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
1196 ,P_PRIMARY_CLASS_1A in VARCHAR2
1197
1198 ,P_PRIMARY_CAPITAL_CONTRIBUTION in NUMBER
1199 ,P_PRIMARY_PRIVATE_CONTRIBUTION in NUMBER
1200 ,P_SECONDARY_COMPANY_CAR in NUMBER
1201 ,P_SECONDARY_CAR_FUEL_BENEFIT in VARCHAR2
1202 ,P_SECONDARY_CLASS_1A
1203 in VARCHAR2
1204 ,P_SECONDARY_CAPITAL_CONTRIBUTI in NUMBER
1205 ,P_SECONDARY_PRIVATE_CONTRIBUTI in NUMBER
1206 ,P_COMPANY_CAR_CALC_METHOD in VARCHAR2
1207 ,P_COMPANY_CAR_RATES_TABLE_ID in NUMBER
1208
1209 ,P_COMPANY_CAR_SECONDARY_TABLE in NUMBER
1210 ,P_PRIVATE_CAR in NUMBER
1211 ,P_PRIVATE_CAR_CALC_METHOD in VARCHAR2
1212 ,P_PRIVATE_CAR_RATES_TABLE_ID in NUMBER
1213 ,P_PRIVATE_CAR_ESSENTIAL_TABLE
1214 in NUMBER
1218 ,P_TP_SAFEGUARDED_GRADE_ID in NUMBER
1215 ,P_TP_IS_TEACHER in VARCHAR2
1216 ,P_TP_HEADTEACHER_GRP_CODE in NUMBER
1217 ,P_TP_SAFEGUARDED_GRADE in VARCHAR2
1219
1220 ,P_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
1221 ,P_TP_SAFEGUARDED_RATE_ID in NUMBER
1222 ,P_TP_SPINAL_POINT_ID in NUMBER
1223 ,P_TP_ELECTED_PENSION in VARCHAR2
1224 ,P_TP_FAST_TRACK
1225 in VARCHAR2
1226 ,P_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
1227 ,P_AAT_ATTRIBUTE1 in VARCHAR2
1228 ,P_AAT_ATTRIBUTE2 in VARCHAR2
1229 ,P_AAT_ATTRIBUTE3 in VARCHAR2
1230
1231 ,P_AAT_ATTRIBUTE4 in VARCHAR2
1232 ,P_AAT_ATTRIBUTE5 in VARCHAR2
1233 ,P_AAT_ATTRIBUTE6 in VARCHAR2
1234 ,P_AAT_ATTRIBUTE7 in VARCHAR2
1235 ,P_AAT_ATTRIBUTE8
1236 in VARCHAR2
1237 ,P_AAT_ATTRIBUTE9 in VARCHAR2
1238 ,P_AAT_ATTRIBUTE10 in VARCHAR2
1239 ,P_AAT_ATTRIBUTE11 in VARCHAR2
1240 ,P_AAT_ATTRIBUTE12 in
1241 VARCHAR2
1242 ,P_AAT_ATTRIBUTE13 in VARCHAR2
1243 ,P_AAT_ATTRIBUTE14 in VARCHAR2
1244 ,P_AAT_ATTRIBUTE15 in VARCHAR2
1245 ,P_AAT_ATTRIBUTE16 in VARCHAR2
1246
1247 ,P_AAT_ATTRIBUTE17 in VARCHAR2
1248 ,P_AAT_ATTRIBUTE18 in VARCHAR2
1249 ,P_AAT_ATTRIBUTE19 in VARCHAR2
1250 ,P_AAT_ATTRIBUTE20 in VARCHAR2
1251
1252 ,P_AAT_INFORMATION_CATEGORY in VARCHAR2
1253 ,P_AAT_INFORMATION1 in VARCHAR2
1254 ,P_AAT_INFORMATION2 in VARCHAR2
1255 ,P_AAT_INFORMATION3 in VARCHAR2
1256 ,P_AAT_INFORMATION4
1257 in VARCHAR2
1258 ,P_AAT_INFORMATION5 in VARCHAR2
1259 ,P_AAT_INFORMATION6 in VARCHAR2
1260 ,P_AAT_INFORMATION7 in VARCHAR2
1261 ,P_AAT_INFORMATION8 in
1262 VARCHAR2
1263 ,P_AAT_INFORMATION9 in VARCHAR2
1264 ,P_AAT_INFORMATION10 in VARCHAR2
1265 ,P_AAT_INFORMATION11 in VARCHAR2
1266 ,P_AAT_INFORMATION12 in VARCHAR2
1267
1268 ,P_AAT_INFORMATION13 in VARCHAR2
1269 ,P_AAT_INFORMATION14 in VARCHAR2
1270 ,P_AAT_INFORMATION15 in VARCHAR2
1271 ,P_AAT_INFORMATION16 in VARCHAR2
1272 ,P_AAT_INFORMATION17
1273 in VARCHAR2
1274 ,P_AAT_INFORMATION18 in VARCHAR2
1275 ,P_AAT_INFORMATION19 in VARCHAR2
1276 ,P_AAT_INFORMATION20 in VARCHAR2
1277 ,P_LGPS_PROCESS_FLAG in
1278 VARCHAR2
1279 ,P_LGPS_EXCLUSION_TYPE in VARCHAR2
1280 ,P_LGPS_PENSIONABLE_PAY in VARCHAR2
1281 ,P_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
1282 ,P_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
1283
1284 ,P_EFFECTIVE_START_DATE_O in DATE
1285 ,P_EFFECTIVE_END_DATE_O in DATE
1286 ,P_BUSINESS_GROUP_ID_O in NUMBER
1287 ,P_ASSIGNMENT_ID_O in NUMBER
1288 ,P_CONTRACT_TYPE_O
1289 in VARCHAR2
1290 ,P_WORK_PATTERN_O in VARCHAR2
1291 ,P_START_DAY_O in VARCHAR2
1292 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
1293 ,P_PRIMARY_COMPANY_CAR_O in NUMBER
1294
1295 ,P_PRIMARY_CAR_FUEL_BENEFIT_O in VARCHAR2
1296 ,P_PRIMARY_CLASS_1A_O in VARCHAR2
1297 ,P_PRIMARY_CAPITAL_CONTRIBUTI_O in NUMBER
1298 ,P_PRIMARY_PRIVATE_CONTRIBUTI_O in NUMBER
1299 ,P_SECONDARY_COMPANY_CAR_O
1300 in NUMBER
1301 ,P_SECONDARY_CAR_FUEL_BENEFIT_O in VARCHAR2
1302 ,P_SECONDARY_CLASS_1A_O in VARCHAR2
1303 ,P_SECONDARY_CAPITAL_CONTRIBU_O in NUMBER
1304 ,P_SECONDARY_PRIVATE_CONTRIBU_O in NUMBER
1305
1306 ,P_COMPANY_CAR_CALC_METHOD_O in VARCHAR2
1307 ,P_COMPANY_CAR_RATES_TABLE_ID_O in NUMBER
1308 ,P_COMPANY_CAR_SECONDARY_TABL_O in NUMBER
1309 ,P_PRIVATE_CAR_O in NUMBER
1310 ,P_PRIVATE_CAR_CALC_METHOD_O
1311 in VARCHAR2
1312 ,P_PRIVATE_CAR_RATES_TABLE_ID_O in NUMBER
1313 ,P_PRIVATE_CAR_ESSENTIAL_TABL_O in NUMBER
1314 ,P_TP_IS_TEACHER_O in VARCHAR2
1315 ,P_TP_HEADTEACHER_GRP_CODE_O in NUMBER
1316
1317 ,P_TP_SAFEGUARDED_GRADE_O in VARCHAR2
1318 ,P_TP_SAFEGUARDED_GRADE_ID_O in NUMBER
1319 ,P_TP_SAFEGUARDED_RATE_TYPE_O in VARCHAR2
1320 ,P_TP_SAFEGUARDED_RATE_ID_O in NUMBER
1321 ,P_TP_SPINAL_POINT_ID_O
1322 in NUMBER
1323 ,P_TP_ELECTED_PENSION_O in VARCHAR2
1324 ,P_TP_FAST_TRACK_O in VARCHAR2
1325 ,P_AAT_ATTRIBUTE_CATEGORY_O in VARCHAR2
1326 ,P_AAT_ATTRIBUTE1_O in VARCHAR2
1327
1328 ,P_AAT_ATTRIBUTE2_O in VARCHAR2
1329 ,P_AAT_ATTRIBUTE3_O in VARCHAR2
1330 ,P_AAT_ATTRIBUTE4_O in VARCHAR2
1334 ,P_AAT_ATTRIBUTE7_O in VARCHAR2
1331 ,P_AAT_ATTRIBUTE5_O in VARCHAR2
1332 ,P_AAT_ATTRIBUTE6_O
1333 in VARCHAR2
1335 ,P_AAT_ATTRIBUTE8_O in VARCHAR2
1336 ,P_AAT_ATTRIBUTE9_O in VARCHAR2
1337 ,P_AAT_ATTRIBUTE10_O in
1338 VARCHAR2
1339 ,P_AAT_ATTRIBUTE11_O in VARCHAR2
1340 ,P_AAT_ATTRIBUTE12_O in VARCHAR2
1341 ,P_AAT_ATTRIBUTE13_O in VARCHAR2
1342 ,P_AAT_ATTRIBUTE14_O in VARCHAR2
1343
1344 ,P_AAT_ATTRIBUTE15_O in VARCHAR2
1345 ,P_AAT_ATTRIBUTE16_O in VARCHAR2
1346 ,P_AAT_ATTRIBUTE17_O in VARCHAR2
1347 ,P_AAT_ATTRIBUTE18_O in VARCHAR2
1348 ,P_AAT_ATTRIBUTE19_O
1349 in VARCHAR2
1350 ,P_AAT_ATTRIBUTE20_O in VARCHAR2
1351 ,P_AAT_INFORMATION_CATEGORY_O in VARCHAR2
1352 ,P_AAT_INFORMATION1_O in VARCHAR2
1353 ,P_AAT_INFORMATION2_O in
1354 VARCHAR2
1355 ,P_AAT_INFORMATION3_O in VARCHAR2
1356 ,P_AAT_INFORMATION4_O in VARCHAR2
1357 ,P_AAT_INFORMATION5_O in VARCHAR2
1358 ,P_AAT_INFORMATION6_O in VARCHAR2
1359
1360 ,P_AAT_INFORMATION7_O in VARCHAR2
1361 ,P_AAT_INFORMATION8_O in VARCHAR2
1362 ,P_AAT_INFORMATION9_O in VARCHAR2
1363 ,P_AAT_INFORMATION10_O in VARCHAR2
1364 ,P_AAT_INFORMATION11_O
1365 in VARCHAR2
1366 ,P_AAT_INFORMATION12_O in VARCHAR2
1367 ,P_AAT_INFORMATION13_O in VARCHAR2
1368 ,P_AAT_INFORMATION14_O in VARCHAR2
1369 ,P_AAT_INFORMATION15_O in
1370 VARCHAR2
1371 ,P_AAT_INFORMATION16_O in VARCHAR2
1372 ,P_AAT_INFORMATION17_O in VARCHAR2
1373 ,P_AAT_INFORMATION18_O in VARCHAR2
1374 ,P_AAT_INFORMATION19_O in VARCHAR2
1375
1376 ,P_AAT_INFORMATION20_O in VARCHAR2
1377 ,P_LGPS_PROCESS_FLAG_O in VARCHAR2
1378 ,P_LGPS_EXCLUSION_TYPE_O in VARCHAR2
1379 ,P_LGPS_PENSIONABLE_PAY_O in VARCHAR2
1380
1381 ,P_LGPS_TRANS_ARRANG_FLAG_O in VARCHAR2
1382 ,P_LGPS_MEMBERSHIP_NUMBER_O in VARCHAR2
1383 ) IS
1384 l_mode varchar2(80);
1385
1386 --
1387 BEGIN
1388
1389 --
1390 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
1391 /* Mechanism
1392 for event capture to know whats occurred */
1393 l_mode := pay_dyn_triggers.g_dyt_mode;
1394 pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1395
1396 --
1397
1398 if (paywsdyg_pkg.trigger_enabled('PQP_ASSIGNMENT_ATTRIBUTES_F_ARU')) then
1399 PQP_ASSIGNMENT_ATTRIBUTES__ARU(
1400 p_new_AAT_ATTRIBUTE1 => P_AAT_ATTRIBUTE1
1401 ,p_new_AAT_ATTRIBUTE10 => P_AAT_ATTRIBUTE10
1402
1403 ,p_new_AAT_ATTRIBUTE11 => P_AAT_ATTRIBUTE11
1404 ,p_new_AAT_ATTRIBUTE12 => P_AAT_ATTRIBUTE12
1405 ,p_new_AAT_ATTRIBUTE13 => P_AAT_ATTRIBUTE13
1406 ,p_new_AAT_ATTRIBUTE14 =>
1407 P_AAT_ATTRIBUTE14
1408 ,p_new_AAT_ATTRIBUTE15 => P_AAT_ATTRIBUTE15
1409 ,p_new_AAT_ATTRIBUTE16 => P_AAT_ATTRIBUTE16
1410 ,p_new_AAT_ATTRIBUTE17 => P_AAT_ATTRIBUTE17
1411 ,p_new_AAT_ATTRIBUTE18
1412 => P_AAT_ATTRIBUTE18
1413 ,p_new_AAT_ATTRIBUTE19 => P_AAT_ATTRIBUTE19
1414 ,p_new_AAT_ATTRIBUTE2 => P_AAT_ATTRIBUTE2
1415 ,p_new_AAT_ATTRIBUTE20 => P_AAT_ATTRIBUTE20
1416
1417 ,p_new_AAT_ATTRIBUTE3 => P_AAT_ATTRIBUTE3
1418 ,p_new_AAT_ATTRIBUTE4 => P_AAT_ATTRIBUTE4
1419 ,p_new_AAT_ATTRIBUTE5 => P_AAT_ATTRIBUTE5
1420 ,p_new_AAT_ATTRIBUTE6 =>
1421 P_AAT_ATTRIBUTE6
1422 ,p_new_AAT_ATTRIBUTE7 => P_AAT_ATTRIBUTE7
1423 ,p_new_AAT_ATTRIBUTE8 => P_AAT_ATTRIBUTE8
1424 ,p_new_AAT_ATTRIBUTE9 => P_AAT_ATTRIBUTE9
1425 ,p_new_AAT_ATTRIBUTE_CATEGORY
1426 => P_AAT_ATTRIBUTE_CATEGORY
1427 ,p_new_AAT_INFORMATION1 => P_AAT_INFORMATION1
1428 ,p_new_AAT_INFORMATION10 => P_AAT_INFORMATION10
1429 ,p_new_AAT_INFORMATION11 => P_AAT_INFORMATION11
1430
1431 ,p_new_AAT_INFORMATION12 => P_AAT_INFORMATION12
1432 ,p_new_AAT_INFORMATION13 => P_AAT_INFORMATION13
1433 ,p_new_AAT_INFORMATION14 => P_AAT_INFORMATION14
1434 ,p_new_AAT_INFORMATION15 =>
1435 P_AAT_INFORMATION15
1436 ,p_new_AAT_INFORMATION16 => P_AAT_INFORMATION16
1437 ,p_new_AAT_INFORMATION17 => P_AAT_INFORMATION17
1438 ,p_new_AAT_INFORMATION18 => P_AAT_INFORMATION18
1439
1440 ,p_new_AAT_INFORMATION19 => P_AAT_INFORMATION19
1441 ,p_new_AAT_INFORMATION2 => P_AAT_INFORMATION2
1442 ,p_new_AAT_INFORMATION20 => P_AAT_INFORMATION20
1443 ,p_new_AAT_INFORMATION3 =>
1444 P_AAT_INFORMATION3
1445 ,p_new_AAT_INFORMATION4 => P_AAT_INFORMATION4
1446 ,p_new_AAT_INFORMATION5 => P_AAT_INFORMATION5
1447 ,p_new_AAT_INFORMATION6 => P_AAT_INFORMATION6
1451 ,p_new_AAT_INFORMATION9 => P_AAT_INFORMATION9
1448 ,p_new_AAT_INFORMATION7
1449 => P_AAT_INFORMATION7
1450 ,p_new_AAT_INFORMATION8 => P_AAT_INFORMATION8
1452 ,p_new_AAT_INFORMATION_CATEGORY =>
1453 P_AAT_INFORMATION_CATEGORY
1454 ,p_new_ASSIGNMENT_ATTRIBUTE_ID => P_ASSIGNMENT_ATTRIBUTE_ID
1455 ,p_new_ASSIGNMENT_ID => P_ASSIGNMENT_ID
1456 ,p_new_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1457
1458 ,p_new_COMPANY_CAR_CALC_METHOD => P_COMPANY_CAR_CALC_METHOD
1459 ,p_new_COMPANY_CAR_RATES_TABLE_ => P_COMPANY_CAR_RATES_TABLE_ID
1460 ,p_new_COMPANY_CAR_SECONDARY_TA => P_COMPANY_CAR_SECONDARY_TABLE
1461
1462 ,p_new_CONTRACT_TYPE => P_CONTRACT_TYPE
1463 ,p_new_DATETRACK_MODE => P_DATETRACK_MODE
1464 ,p_new_EFFECTIVE_DATE => P_EFFECTIVE_DATE
1465 ,p_new_EFFECTIVE_END_DATE =>
1466 P_EFFECTIVE_END_DATE
1467 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
1468 ,p_new_LGPS_EXCLUSION_TYPE => P_LGPS_EXCLUSION_TYPE
1469 ,p_new_LGPS_MEMBERSHIP_NUMBER => P_LGPS_MEMBERSHIP_NUMBER
1470
1471 ,p_new_LGPS_PENSIONABLE_PAY => P_LGPS_PENSIONABLE_PAY
1472 ,p_new_LGPS_PROCESS_FLAG => P_LGPS_PROCESS_FLAG
1473 ,p_new_LGPS_TRANS_ARRANG_FLAG => P_LGPS_TRANS_ARRANG_FLAG
1474 ,p_new_OBJECT_VERSION_NUMBER
1475 => P_OBJECT_VERSION_NUMBER
1476 ,p_new_PRIMARY_CAPITAL_CONTRIBU => P_PRIMARY_CAPITAL_CONTRIBUTION
1477 ,p_new_PRIMARY_CAR_FUEL_BENEFIT => P_PRIMARY_CAR_FUEL_BENEFIT
1478 ,p_new_PRIMARY_CLASS_1A =>
1479 P_PRIMARY_CLASS_1A
1480 ,p_new_PRIMARY_COMPANY_CAR => P_PRIMARY_COMPANY_CAR
1481 ,p_new_PRIMARY_PRIVATE_CONTRIBU => P_PRIMARY_PRIVATE_CONTRIBUTION
1482 ,p_new_PRIVATE_CAR => P_PRIVATE_CAR
1483
1484 ,p_new_PRIVATE_CAR_CALC_METHOD => P_PRIVATE_CAR_CALC_METHOD
1485 ,p_new_PRIVATE_CAR_ESSENTIAL_TA => P_PRIVATE_CAR_ESSENTIAL_TABLE
1486 ,p_new_PRIVATE_CAR_RATES_TABLE_ => P_PRIVATE_CAR_RATES_TABLE_ID
1487
1488 ,p_new_SECONDARY_CAPITAL_CONTRI => P_SECONDARY_CAPITAL_CONTRIBUTI
1489 ,p_new_SECONDARY_CAR_FUEL_BENEF => P_SECONDARY_CAR_FUEL_BENEFIT
1490 ,p_new_SECONDARY_CLASS_1A => P_SECONDARY_CLASS_1A
1491
1492 ,p_new_SECONDARY_COMPANY_CAR => P_SECONDARY_COMPANY_CAR
1493 ,p_new_SECONDARY_PRIVATE_CONTRI => P_SECONDARY_PRIVATE_CONTRIBUTI
1494 ,p_new_START_DAY => P_START_DAY
1495 ,p_new_TP_ELECTED_PENSION
1496 => P_TP_ELECTED_PENSION
1497 ,p_new_TP_FAST_TRACK => P_TP_FAST_TRACK
1498 ,p_new_TP_IS_TEACHER => P_TP_IS_TEACHER
1499 ,p_new_TP_SAFEGUARDED_GRADE => P_TP_SAFEGUARDED_GRADE
1500
1501 ,p_new_TP_SAFEGUARDED_GRADE_ID => P_TP_SAFEGUARDED_GRADE_ID
1502 ,p_new_TP_SAFEGUARDED_RATE_ID => P_TP_SAFEGUARDED_RATE_ID
1503 ,p_new_TP_SAFEGUARDED_RATE_TYPE => P_TP_SAFEGUARDED_RATE_TYPE
1504
1505 ,p_new_TP_SAFEGUARDED_SPINAL_PO => P_TP_SPINAL_POINT_ID
1506 ,p_new_TP_SPINAL_POINT_ID => P_TP_SPINAL_POINT_ID
1507 ,p_new_VALIDATION_END_DATE => P_VALIDATION_END_DATE
1508 ,p_new_VALIDATION_START_DATE
1509 => P_VALIDATION_START_DATE
1510 ,p_new_WORK_PATTERN => P_WORK_PATTERN
1511 ,p_old_AAT_ATTRIBUTE1 => P_AAT_ATTRIBUTE1_O
1512 ,p_old_AAT_ATTRIBUTE10 => P_AAT_ATTRIBUTE10_O
1513
1514 ,p_old_AAT_ATTRIBUTE11 => P_AAT_ATTRIBUTE11_O
1515 ,p_old_AAT_ATTRIBUTE12 => P_AAT_ATTRIBUTE12_O
1516 ,p_old_AAT_ATTRIBUTE13 => P_AAT_ATTRIBUTE13_O
1517 ,p_old_AAT_ATTRIBUTE14 =>
1518 P_AAT_ATTRIBUTE14_O
1519 ,p_old_AAT_ATTRIBUTE15 => P_AAT_ATTRIBUTE15_O
1520 ,p_old_AAT_ATTRIBUTE16 => P_AAT_ATTRIBUTE16_O
1521 ,p_old_AAT_ATTRIBUTE17 => P_AAT_ATTRIBUTE17_O
1522
1523 ,p_old_AAT_ATTRIBUTE18 => P_AAT_ATTRIBUTE18_O
1524 ,p_old_AAT_ATTRIBUTE19 => P_AAT_ATTRIBUTE19_O
1525 ,p_old_AAT_ATTRIBUTE2 => P_AAT_ATTRIBUTE2_O
1526 ,p_old_AAT_ATTRIBUTE20 =>
1527 P_AAT_ATTRIBUTE20_O
1528 ,p_old_AAT_ATTRIBUTE3 => P_AAT_ATTRIBUTE3_O
1529 ,p_old_AAT_ATTRIBUTE4 => P_AAT_ATTRIBUTE4_O
1530 ,p_old_AAT_ATTRIBUTE5 => P_AAT_ATTRIBUTE5_O
1531 ,p_old_AAT_ATTRIBUTE6
1532 => P_AAT_ATTRIBUTE6_O
1533 ,p_old_AAT_ATTRIBUTE7 => P_AAT_ATTRIBUTE7_O
1534 ,p_old_AAT_ATTRIBUTE8 => P_AAT_ATTRIBUTE8_O
1535 ,p_old_AAT_ATTRIBUTE9 => P_AAT_ATTRIBUTE9_O
1536
1537 ,p_old_AAT_ATTRIBUTE_CATEGORY => P_AAT_ATTRIBUTE_CATEGORY_O
1538 ,p_old_AAT_INFORMATION1 => P_AAT_INFORMATION1_O
1539 ,p_old_AAT_INFORMATION10 => P_AAT_INFORMATION10_O
1540 ,p_old_AAT_INFORMATION11
1541 => P_AAT_INFORMATION11_O
1542 ,p_old_AAT_INFORMATION12 => P_AAT_INFORMATION12_O
1543 ,p_old_AAT_INFORMATION13 => P_AAT_INFORMATION13_O
1544 ,p_old_AAT_INFORMATION14 => P_AAT_INFORMATION14_O
1548 ,p_old_AAT_INFORMATION17 => P_AAT_INFORMATION17_O
1545
1546 ,p_old_AAT_INFORMATION15 => P_AAT_INFORMATION15_O
1547 ,p_old_AAT_INFORMATION16 => P_AAT_INFORMATION16_O
1549 ,p_old_AAT_INFORMATION18
1550 => P_AAT_INFORMATION18_O
1551 ,p_old_AAT_INFORMATION19 => P_AAT_INFORMATION19_O
1552 ,p_old_AAT_INFORMATION2 => P_AAT_INFORMATION2_O
1553 ,p_old_AAT_INFORMATION20 => P_AAT_INFORMATION20_O
1554
1555 ,p_old_AAT_INFORMATION3 => P_AAT_INFORMATION3_O
1556 ,p_old_AAT_INFORMATION4 => P_AAT_INFORMATION4_O
1557 ,p_old_AAT_INFORMATION5 => P_AAT_INFORMATION5_O
1558 ,p_old_AAT_INFORMATION6
1559 => P_AAT_INFORMATION6_O
1560 ,p_old_AAT_INFORMATION7 => P_AAT_INFORMATION7_O
1561 ,p_old_AAT_INFORMATION8 => P_AAT_INFORMATION8_O
1562 ,p_old_AAT_INFORMATION9 => P_AAT_INFORMATION9_O
1563
1564 ,p_old_AAT_INFORMATION_CATEGORY => P_AAT_INFORMATION_CATEGORY_O
1565 ,p_old_ASSIGNMENT_ID => P_ASSIGNMENT_ID_O
1566 ,p_old_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID_O
1567 ,p_old_COMPANY_CAR_CALC_METHOD
1568 => P_COMPANY_CAR_CALC_METHOD_O
1569 ,p_old_COMPANY_CAR_RATES_TABLE_ => P_COMPANY_CAR_RATES_TABLE_ID_O
1570 ,p_old_COMPANY_CAR_SECONDARY_TA => P_COMPANY_CAR_SECONDARY_TABL_O
1571 ,p_old_CONTRACT_TYPE =>
1572 P_CONTRACT_TYPE_O
1573 ,p_old_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE_O
1574 ,p_old_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE_O
1575 ,p_old_LGPS_EXCLUSION_TYPE => P_LGPS_EXCLUSION_TYPE_O
1576
1577 ,p_old_LGPS_MEMBERSHIP_NUMBER => P_LGPS_MEMBERSHIP_NUMBER_O
1578 ,p_old_LGPS_PENSIONABLE_PAY => P_LGPS_PENSIONABLE_PAY_O
1579 ,p_old_LGPS_PROCESS_FLAG => P_LGPS_PROCESS_FLAG_O
1580 ,p_old_LGPS_TRANS_ARRANG_FLAG
1581 => P_LGPS_TRANS_ARRANG_FLAG_O
1582 ,p_old_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER_O
1583 ,p_old_PRIMARY_CAPITAL_CONTRIBU => P_PRIMARY_CAPITAL_CONTRIBUTI_O
1584 ,p_old_PRIMARY_CAR_FUEL_BENEFIT =>
1585 P_PRIMARY_CAR_FUEL_BENEFIT_O
1586 ,p_old_PRIMARY_CLASS_1A => P_PRIMARY_CLASS_1A_O
1587 ,p_old_PRIMARY_COMPANY_CAR => P_PRIMARY_COMPANY_CAR_O
1588 ,p_old_PRIMARY_PRIVATE_CONTRIBU => P_PRIMARY_PRIVATE_CONTRIBUTI_O
1589
1590 ,p_old_PRIVATE_CAR => P_PRIVATE_CAR_O
1591 ,p_old_PRIVATE_CAR_CALC_METHOD => P_PRIVATE_CAR_CALC_METHOD_O
1592 ,p_old_PRIVATE_CAR_ESSENTIAL_TA => P_PRIVATE_CAR_ESSENTIAL_TABL_O
1593
1594 ,p_old_PRIVATE_CAR_RATES_TABLE_ => P_PRIVATE_CAR_RATES_TABLE_ID_O
1595 ,p_old_SECONDARY_CAPITAL_CONTRI => P_SECONDARY_CAPITAL_CONTRIBU_O
1596 ,p_old_SECONDARY_CAR_FUEL_BENEF => P_SECONDARY_CAR_FUEL_BENEFIT_O
1597
1598 ,p_old_SECONDARY_CLASS_1A => P_SECONDARY_CLASS_1A_O
1599 ,p_old_SECONDARY_COMPANY_CAR => P_SECONDARY_COMPANY_CAR_O
1600 ,p_old_SECONDARY_PRIVATE_CONTRI => P_SECONDARY_PRIVATE_CONTRIBU_O
1601 ,p_old_START_DAY
1602 => P_START_DAY_O
1603 ,p_old_TP_ELECTED_PENSION => P_TP_ELECTED_PENSION_O
1604 ,p_old_TP_FAST_TRACK => P_TP_FAST_TRACK_O
1605 ,p_old_TP_IS_TEACHER => P_TP_IS_TEACHER_O
1606
1607 ,p_old_TP_SAFEGUARDED_GRADE => P_TP_SAFEGUARDED_GRADE_O
1608 ,p_old_TP_SAFEGUARDED_GRADE_ID => P_TP_SAFEGUARDED_GRADE_ID_O
1609 ,p_old_TP_SAFEGUARDED_RATE_ID => P_TP_SAFEGUARDED_RATE_ID_O
1610
1611 ,p_old_TP_SAFEGUARDED_RATE_TYPE => P_TP_SAFEGUARDED_RATE_TYPE_O
1612 ,p_old_TP_SAFEGUARDED_SPINAL_PO => P_TP_SPINAL_POINT_ID_O
1613 ,p_old_TP_SPINAL_POINT_ID => P_TP_SPINAL_POINT_ID_O
1614 ,p_old_WORK_PATTERN
1615 => P_WORK_PATTERN_O
1616 );
1617 end if;
1618
1619 --
1620 pay_dyn_triggers.g_dyt_mode := l_mode;
1621
1622 --
1623 EXCEPTION
1624 WHEN OTHERS THEN
1625 hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
1626 pay_dyn_triggers.g_dyt_mode := l_mode;
1627 RAISE;
1628 --
1629 END
1630 AFTER_UPDATE;
1631
1632 --
1633
1634 /*
1635 ================================================
1636 This is a dynamically generated procedure.
1637 Will be called by API.
1638 ================================================
1639 ** DO NOT CHANGE MANUALLY **
1640
1641 ------------------------------------------------
1642 Name: AFTER_DELETE
1643 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
1644 Action: DELETE
1645 Generated Date: 27/11/2012 04:01
1646 Description: Called as part of DELETE process
1647
1648 ================================================
1649 */
1650
1651 --
1652 PROCEDURE AFTER_DELETE
1653 (
1654 P_EFFECTIVE_DATE in DATE
1655 ,P_DATETRACK_MODE in VARCHAR2
1656 ,P_VALIDATION_START_DATE in DATE
1657
1658 ,P_VALIDATION_END_DATE in DATE
1659 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
1660 ,P_EFFECTIVE_START_DATE in DATE
1661 ,P_EFFECTIVE_END_DATE in DATE
1662 ,P_EFFECTIVE_START_DATE_O
1663 in DATE
1664 ,P_EFFECTIVE_END_DATE_O in DATE
1668 ,P_WORK_PATTERN_O
1665 ,P_BUSINESS_GROUP_ID_O in NUMBER
1666 ,P_ASSIGNMENT_ID_O in NUMBER
1667 ,P_CONTRACT_TYPE_O in VARCHAR2
1669 in VARCHAR2
1670 ,P_START_DAY_O in VARCHAR2
1671 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
1672 ,P_PRIMARY_COMPANY_CAR_O in NUMBER
1673 ,P_PRIMARY_CAR_FUEL_BENEFIT_O in
1674 VARCHAR2
1675 ,P_PRIMARY_CLASS_1A_O in VARCHAR2
1676 ,P_PRIMARY_CAPITAL_CONTRIBUTI_O in NUMBER
1677 ,P_PRIMARY_PRIVATE_CONTRIBUTI_O in NUMBER
1678 ,P_SECONDARY_COMPANY_CAR_O in NUMBER
1679
1680 ,P_SECONDARY_CAR_FUEL_BENEFIT_O in VARCHAR2
1681 ,P_SECONDARY_CLASS_1A_O in VARCHAR2
1682 ,P_SECONDARY_CAPITAL_CONTRIBU_O in NUMBER
1683 ,P_SECONDARY_PRIVATE_CONTRIBU_O in NUMBER
1684 ,P_COMPANY_CAR_CALC_METHOD_O
1685 in VARCHAR2
1686 ,P_COMPANY_CAR_RATES_TABLE_ID_O in NUMBER
1687 ,P_COMPANY_CAR_SECONDARY_TABL_O in NUMBER
1688 ,P_PRIVATE_CAR_O in NUMBER
1689 ,P_PRIVATE_CAR_CALC_METHOD_O in VARCHAR2
1690
1691 ,P_PRIVATE_CAR_RATES_TABLE_ID_O in NUMBER
1692 ,P_PRIVATE_CAR_ESSENTIAL_TABL_O in NUMBER
1693 ,P_TP_IS_TEACHER_O in VARCHAR2
1694 ,P_TP_HEADTEACHER_GRP_CODE_O in NUMBER
1695 ,P_TP_SAFEGUARDED_GRADE_O
1696 in VARCHAR2
1697 ,P_TP_SAFEGUARDED_GRADE_ID_O in NUMBER
1698 ,P_TP_SAFEGUARDED_RATE_TYPE_O in VARCHAR2
1699 ,P_TP_SAFEGUARDED_RATE_ID_O in NUMBER
1700 ,P_TP_SPINAL_POINT_ID_O in NUMBER
1701
1702 ,P_TP_ELECTED_PENSION_O in VARCHAR2
1703 ,P_TP_FAST_TRACK_O in VARCHAR2
1704 ,P_AAT_ATTRIBUTE_CATEGORY_O in VARCHAR2
1705 ,P_AAT_ATTRIBUTE1_O in VARCHAR2
1706 ,P_AAT_ATTRIBUTE2_O
1707 in VARCHAR2
1708 ,P_AAT_ATTRIBUTE3_O in VARCHAR2
1709 ,P_AAT_ATTRIBUTE4_O in VARCHAR2
1710 ,P_AAT_ATTRIBUTE5_O in VARCHAR2
1711 ,P_AAT_ATTRIBUTE6_O in
1712 VARCHAR2
1713 ,P_AAT_ATTRIBUTE7_O in VARCHAR2
1714 ,P_AAT_ATTRIBUTE8_O in VARCHAR2
1715 ,P_AAT_ATTRIBUTE9_O in VARCHAR2
1716 ,P_AAT_ATTRIBUTE10_O in VARCHAR2
1717
1718 ,P_AAT_ATTRIBUTE11_O in VARCHAR2
1719 ,P_AAT_ATTRIBUTE12_O in VARCHAR2
1720 ,P_AAT_ATTRIBUTE13_O in VARCHAR2
1721 ,P_AAT_ATTRIBUTE14_O in VARCHAR2
1722 ,P_AAT_ATTRIBUTE15_O
1723 in VARCHAR2
1724 ,P_AAT_ATTRIBUTE16_O in VARCHAR2
1725 ,P_AAT_ATTRIBUTE17_O in VARCHAR2
1726 ,P_AAT_ATTRIBUTE18_O in VARCHAR2
1727 ,P_AAT_ATTRIBUTE19_O in
1728 VARCHAR2
1729 ,P_AAT_ATTRIBUTE20_O in VARCHAR2
1730 ,P_AAT_INFORMATION_CATEGORY_O in VARCHAR2
1731 ,P_AAT_INFORMATION1_O in VARCHAR2
1732 ,P_AAT_INFORMATION2_O in VARCHAR2
1733
1734 ,P_AAT_INFORMATION3_O in VARCHAR2
1735 ,P_AAT_INFORMATION4_O in VARCHAR2
1736 ,P_AAT_INFORMATION5_O in VARCHAR2
1737 ,P_AAT_INFORMATION6_O in VARCHAR2
1738 ,P_AAT_INFORMATION7_O
1739 in VARCHAR2
1740 ,P_AAT_INFORMATION8_O in VARCHAR2
1741 ,P_AAT_INFORMATION9_O in VARCHAR2
1742 ,P_AAT_INFORMATION10_O in VARCHAR2
1743 ,P_AAT_INFORMATION11_O in
1744 VARCHAR2
1745 ,P_AAT_INFORMATION12_O in VARCHAR2
1746 ,P_AAT_INFORMATION13_O in VARCHAR2
1747 ,P_AAT_INFORMATION14_O in VARCHAR2
1748 ,P_AAT_INFORMATION15_O in VARCHAR2
1749
1750 ,P_AAT_INFORMATION16_O in VARCHAR2
1751 ,P_AAT_INFORMATION17_O in VARCHAR2
1752 ,P_AAT_INFORMATION18_O in VARCHAR2
1753 ,P_AAT_INFORMATION19_O in VARCHAR2
1754 ,P_AAT_INFORMATION20_O
1755 in VARCHAR2
1756 ,P_LGPS_PROCESS_FLAG_O in VARCHAR2
1757 ,P_LGPS_EXCLUSION_TYPE_O in VARCHAR2
1758 ,P_LGPS_PENSIONABLE_PAY_O in VARCHAR2
1759 ,P_LGPS_TRANS_ARRANG_FLAG_O in
1760 VARCHAR2
1761 ,P_LGPS_MEMBERSHIP_NUMBER_O in VARCHAR2
1762 ) IS
1763 l_mode varchar2(80);
1764
1765 --
1766 BEGIN
1767
1768 --
1769 hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');
1770 /* Mechanism for event capture to know whats occurred */
1771
1772 l_mode := pay_dyn_triggers.g_dyt_mode;
1773 pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1774
1775 --
1776
1777 if (paywsdyg_pkg.trigger_enabled('PQP_ASSIGNMENT_ATTRIBUTES_F_ARD')) then
1778 PQP_ASSIGNMENT_ATTRIBUTES__ARD(
1779 p_new_ASSIGNMENT_ATTRIBUTE_ID => P_ASSIGNMENT_ATTRIBUTE_ID
1780 ,p_new_DATETRACK_MODE =>
1781 P_DATETRACK_MODE
1782 ,p_new_EFFECTIVE_DATE => P_EFFECTIVE_DATE
1783 ,p_new_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
1784 ,p_new_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
1785
1786 ,p_new_VALIDATION_END_DATE => P_VALIDATION_END_DATE
1790 => P_AAT_ATTRIBUTE10_O
1787 ,p_new_VALIDATION_START_DATE => P_VALIDATION_START_DATE
1788 ,p_old_AAT_ATTRIBUTE1 => P_AAT_ATTRIBUTE1_O
1789 ,p_old_AAT_ATTRIBUTE10
1791 ,p_old_AAT_ATTRIBUTE11 => P_AAT_ATTRIBUTE11_O
1792 ,p_old_AAT_ATTRIBUTE12 => P_AAT_ATTRIBUTE12_O
1793 ,p_old_AAT_ATTRIBUTE13 => P_AAT_ATTRIBUTE13_O
1794
1795 ,p_old_AAT_ATTRIBUTE14 => P_AAT_ATTRIBUTE14_O
1796 ,p_old_AAT_ATTRIBUTE15 => P_AAT_ATTRIBUTE15_O
1797 ,p_old_AAT_ATTRIBUTE16 => P_AAT_ATTRIBUTE16_O
1798 ,p_old_AAT_ATTRIBUTE17 =>
1799 P_AAT_ATTRIBUTE17_O
1800 ,p_old_AAT_ATTRIBUTE18 => P_AAT_ATTRIBUTE18_O
1801 ,p_old_AAT_ATTRIBUTE19 => P_AAT_ATTRIBUTE19_O
1802 ,p_old_AAT_ATTRIBUTE2 => P_AAT_ATTRIBUTE2_O
1803
1804 ,p_old_AAT_ATTRIBUTE20 => P_AAT_ATTRIBUTE20_O
1805 ,p_old_AAT_ATTRIBUTE3 => P_AAT_ATTRIBUTE3_O
1806 ,p_old_AAT_ATTRIBUTE4 => P_AAT_ATTRIBUTE4_O
1807 ,p_old_AAT_ATTRIBUTE5 =>
1808 P_AAT_ATTRIBUTE5_O
1809 ,p_old_AAT_ATTRIBUTE6 => P_AAT_ATTRIBUTE6_O
1810 ,p_old_AAT_ATTRIBUTE7 => P_AAT_ATTRIBUTE7_O
1811 ,p_old_AAT_ATTRIBUTE8 => P_AAT_ATTRIBUTE8_O
1812 ,p_old_AAT_ATTRIBUTE9
1813 => P_AAT_ATTRIBUTE9_O
1814 ,p_old_AAT_ATTRIBUTE_CATEGORY => P_AAT_ATTRIBUTE_CATEGORY_O
1815 ,p_old_AAT_INFORMATION1 => P_AAT_INFORMATION1_O
1816 ,p_old_AAT_INFORMATION10 =>
1817 P_AAT_INFORMATION10_O
1818 ,p_old_AAT_INFORMATION11 => P_AAT_INFORMATION11_O
1819 ,p_old_AAT_INFORMATION12 => P_AAT_INFORMATION12_O
1820 ,p_old_AAT_INFORMATION13 => P_AAT_INFORMATION13_O
1821
1822 ,p_old_AAT_INFORMATION14 => P_AAT_INFORMATION14_O
1823 ,p_old_AAT_INFORMATION15 => P_AAT_INFORMATION15_O
1824 ,p_old_AAT_INFORMATION16 => P_AAT_INFORMATION16_O
1825 ,p_old_AAT_INFORMATION17
1826 => P_AAT_INFORMATION17_O
1827 ,p_old_AAT_INFORMATION18 => P_AAT_INFORMATION18_O
1828 ,p_old_AAT_INFORMATION19 => P_AAT_INFORMATION19_O
1829 ,p_old_AAT_INFORMATION2 => P_AAT_INFORMATION2_O
1830
1831 ,p_old_AAT_INFORMATION20 => P_AAT_INFORMATION20_O
1832 ,p_old_AAT_INFORMATION3 => P_AAT_INFORMATION3_O
1833 ,p_old_AAT_INFORMATION4 => P_AAT_INFORMATION4_O
1834 ,p_old_AAT_INFORMATION5
1835 => P_AAT_INFORMATION5_O
1836 ,p_old_AAT_INFORMATION6 => P_AAT_INFORMATION6_O
1837 ,p_old_AAT_INFORMATION7 => P_AAT_INFORMATION7_O
1838 ,p_old_AAT_INFORMATION8 => P_AAT_INFORMATION8_O
1839
1840 ,p_old_AAT_INFORMATION9 => P_AAT_INFORMATION9_O
1841 ,p_old_AAT_INFORMATION_CATEGORY => P_AAT_INFORMATION_CATEGORY_O
1842 ,p_old_ASSIGNMENT_ID => P_ASSIGNMENT_ID_O
1843 ,p_old_BUSINESS_GROUP_ID
1844 => P_BUSINESS_GROUP_ID_O
1845 ,p_old_COMPANY_CAR_CALC_METHOD => P_COMPANY_CAR_CALC_METHOD_O
1846 ,p_old_COMPANY_CAR_RATES_TABLE_ => P_COMPANY_CAR_RATES_TABLE_ID_O
1847 ,p_old_COMPANY_CAR_SECONDARY_TA =>
1848 P_COMPANY_CAR_SECONDARY_TABL_O
1849 ,p_old_CONTRACT_TYPE => P_CONTRACT_TYPE_O
1850 ,p_old_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE_O
1851 ,p_old_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE_O
1852
1853 ,p_old_LGPS_EXCLUSION_TYPE => P_LGPS_EXCLUSION_TYPE_O
1854 ,p_old_LGPS_MEMBERSHIP_NUMBER => P_LGPS_MEMBERSHIP_NUMBER_O
1855 ,p_old_LGPS_PENSIONABLE_PAY => P_LGPS_PENSIONABLE_PAY_O
1856 ,p_old_LGPS_PROCESS_FLAG
1857 => P_LGPS_PROCESS_FLAG_O
1858 ,p_old_LGPS_TRANS_ARRANG_FLAG => P_LGPS_TRANS_ARRANG_FLAG_O
1859 ,p_old_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER_O
1860 ,p_old_PRIMARY_CAPITAL_CONTRIBU =>
1861 P_PRIMARY_CAPITAL_CONTRIBUTI_O
1862 ,p_old_PRIMARY_CAR_FUEL_BENEFIT => P_PRIMARY_CAR_FUEL_BENEFIT_O
1863 ,p_old_PRIMARY_CLASS_1A => P_PRIMARY_CLASS_1A_O
1864 ,p_old_PRIMARY_COMPANY_CAR => P_PRIMARY_COMPANY_CAR_O
1865
1866 ,p_old_PRIMARY_PRIVATE_CONTRIBU => P_PRIMARY_PRIVATE_CONTRIBUTI_O
1867 ,p_old_PRIVATE_CAR => P_PRIVATE_CAR_O
1868 ,p_old_PRIVATE_CAR_CALC_METHOD => P_PRIVATE_CAR_CALC_METHOD_O
1869
1870 ,p_old_PRIVATE_CAR_ESSENTIAL_TA => P_PRIVATE_CAR_ESSENTIAL_TABL_O
1871 ,p_old_PRIVATE_CAR_RATES_TABLE_ => P_PRIVATE_CAR_RATES_TABLE_ID_O
1872 ,p_old_SECONDARY_CAPITAL_CONTRI => P_SECONDARY_CAPITAL_CONTRIBU_O
1873
1874 ,p_old_SECONDARY_CAR_FUEL_BENEF => P_SECONDARY_CAR_FUEL_BENEFIT_O
1875 ,p_old_SECONDARY_CLASS_1A => P_SECONDARY_CLASS_1A_O
1876 ,p_old_SECONDARY_COMPANY_CAR => P_SECONDARY_COMPANY_CAR_O
1877
1878 ,p_old_SECONDARY_PRIVATE_CONTRI => P_SECONDARY_PRIVATE_CONTRIBU_O
1879 ,p_old_START_DAY => P_START_DAY_O
1880 ,p_old_TP_ELECTED_PENSION => P_TP_ELECTED_PENSION_O
1881 ,p_old_TP_FAST_TRACK
1882 => P_TP_FAST_TRACK_O
1883 ,p_old_TP_IS_TEACHER => P_TP_IS_TEACHER_O
1884 ,p_old_TP_SAFEGUARDED_GRADE => P_TP_SAFEGUARDED_GRADE_O
1885 ,p_old_TP_SAFEGUARDED_GRADE_ID => P_TP_SAFEGUARDED_GRADE_ID_O
1886
1887 ,p_old_TP_SAFEGUARDED_RATE_ID => P_TP_SAFEGUARDED_RATE_ID_O
1888 ,p_old_TP_SAFEGUARDED_RATE_TYPE => P_TP_SAFEGUARDED_RATE_TYPE_O
1889 ,p_old_TP_SAFEGUARDED_SPINAL_PO => P_TP_SPINAL_POINT_ID_O
1890 ,p_old_TP_SPINAL_POINT_ID
1891 => P_TP_SPINAL_POINT_ID_O
1892 ,p_old_WORK_PATTERN => P_WORK_PATTERN_O
1893 );
1894 end if;
1895
1896 --
1897 pay_dyn_triggers.g_dyt_mode := l_mode;
1898
1899 --
1900 EXCEPTION
1901 WHEN OTHERS THEN
1902
1903 hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
1904 pay_dyn_triggers.g_dyt_mode := l_mode;
1905 RAISE;
1906 --
1907 END AFTER_DELETE;
1908
1909 --
1910
1911 /* END_PACKAGE */
1912 END PAY_DYT_ASSIGNMENT_ATTRIB_PKG;
1913