1 package body PAY_DYT_ASSIGNMENT_ATTRIB_PKG AS
2 -- /* $Header: pqpdtpkg.pkb 120.2 2008/06/04 09:16:17 pvelugul noship $ */
3
4 --
5 /*
6 ==================================================
7 This is a dynamically generated database package
8 containing code to support the use of dynamic
9 triggers.
10
11 Preference of package Vs dbms triggers supporting
12 dyn' triggers is made via the dated table form.
13 .
14 This code will be called implicitly by table rhi
15 and
16 explictly from non-API packages that maintain
17 data on the relevant table.
18 ==================================================
19 ** DO NOT CHANGE MANUALLY **
20
21 --------------------------------------------------
22 Package Name: PAY_DYT_ASSIGNMENT_ATTRIB_PKG
23 Base Table: PQP_ASSIGNMENT_ATTRIBUTES_F
24 Date: 31/03/2004 09:06
25 ==================================================
26 */
27
28 --
29
30 /*
31 ================================================
32 This is a dynamically generated procedure.
33 Will be called by API.
34 ================================================
35 ** DO NOT CHANGE MANUALLY **
36
37 ------------------------------------------------
38 Name: AFTER_INSERT
39 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
40 Action: INSERT
41 Generated Date: 31/03/2004 09:06
42 Description: Called as part of INSERT process
43
44 ================================================
45 */
46
47 --
48 PROCEDURE AFTER_INSERT
49 (
50 P_EFFECTIVE_DATE in DATE
51 ,P_VALIDATION_START_DATE in DATE
52 ,P_VALIDATION_END_DATE in DATE
53
54 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
55 ,P_EFFECTIVE_START_DATE in DATE
56 ,P_EFFECTIVE_END_DATE in DATE
57 ,P_BUSINESS_GROUP_ID in NUMBER
58 ,P_ASSIGNMENT_ID
59 in NUMBER
60 ,P_CONTRACT_TYPE in VARCHAR2
61 ,P_WORK_PATTERN in VARCHAR2
62 ,P_START_DAY in VARCHAR2
63 ,P_OBJECT_VERSION_NUMBER in NUMBER
64
65 ,P_PRIMARY_COMPANY_CAR in NUMBER
66 ,P_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
67 ,P_PRIMARY_CLASS_1A in VARCHAR2
68 ,P_PRIMARY_CAPITAL_CONTRIBUTION in NUMBER
69
70 ,P_PRIMARY_PRIVATE_CONTRIBUTION in NUMBER
71 ,P_SECONDARY_COMPANY_CAR in NUMBER
72 ,P_SECONDARY_CAR_FUEL_BENEFIT in VARCHAR2
73 ,P_SECONDARY_CLASS_1A in VARCHAR2
74
75 ,P_SECONDARY_CAPITAL_CONTRIBUTI in NUMBER
76 ,P_SECONDARY_PRIVATE_CONTRIBUTI in NUMBER
77 ,P_COMPANY_CAR_CALC_METHOD in VARCHAR2
78 ,P_COMPANY_CAR_RATES_TABLE_ID in NUMBER
79 ,P_COMPANY_CAR_SECONDARY_TABLE
80 in NUMBER
81 ,P_PRIVATE_CAR in NUMBER
82 ,P_PRIVATE_CAR_CALC_METHOD in VARCHAR2
83 ,P_PRIVATE_CAR_RATES_TABLE_ID in NUMBER
84 ,P_PRIVATE_CAR_ESSENTIAL_TABLE in NUMBER
85
86 ,P_TP_IS_TEACHER in VARCHAR2
87 ,P_TP_HEADTEACHER_GRP_CODE in NUMBER
88 ,P_TP_SAFEGUARDED_GRADE in VARCHAR2
89 ,P_TP_SAFEGUARDED_GRADE_ID in NUMBER
90 ,P_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
91 ,P_TP_SAFEGUARDED_RATE_ID
92 in NUMBER
93 ,P_TP_SPINAL_POINT_ID in NUMBER
94 ,P_TP_ELECTED_PENSION in VARCHAR2
95 ,P_TP_FAST_TRACK in VARCHAR2
96 ,P_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
97 ,P_AAT_ATTRIBUTE1 in VARCHAR2
98 ,P_AAT_ATTRIBUTE2 in VARCHAR2
99 ,P_AAT_ATTRIBUTE3 in VARCHAR2
100 ,P_AAT_ATTRIBUTE4 in VARCHAR2
101 ,P_AAT_ATTRIBUTE5
102 in VARCHAR2
103 ,P_AAT_ATTRIBUTE6 in VARCHAR2
104 ,P_AAT_ATTRIBUTE7 in VARCHAR2
105 ,P_AAT_ATTRIBUTE8 in VARCHAR2
106 ,P_AAT_ATTRIBUTE9 in
107 VARCHAR2
108 ,P_AAT_ATTRIBUTE10 in VARCHAR2
109 ,P_AAT_ATTRIBUTE11 in VARCHAR2
110 ,P_AAT_ATTRIBUTE12 in VARCHAR2
111 ,P_AAT_ATTRIBUTE13 in VARCHAR2
112
113 ,P_AAT_ATTRIBUTE14 in VARCHAR2
114 ,P_AAT_ATTRIBUTE15 in VARCHAR2
115 ,P_AAT_ATTRIBUTE16 in VARCHAR2
116 ,P_AAT_ATTRIBUTE17 in VARCHAR2
117 ,P_AAT_ATTRIBUTE18
118 in VARCHAR2
119 ,P_AAT_ATTRIBUTE19 in VARCHAR2
120 ,P_AAT_ATTRIBUTE20 in VARCHAR2
121 ,P_AAT_INFORMATION_CATEGORY in VARCHAR2
122 ,P_AAT_INFORMATION1 in
123 VARCHAR2
124 ,P_AAT_INFORMATION2 in VARCHAR2
125 ,P_AAT_INFORMATION3 in VARCHAR2
126 ,P_AAT_INFORMATION4 in VARCHAR2
127 ,P_AAT_INFORMATION5 in VARCHAR2
128
129 ,P_AAT_INFORMATION6 in VARCHAR2
130 ,P_AAT_INFORMATION7 in VARCHAR2
131 ,P_AAT_INFORMATION8 in VARCHAR2
132 ,P_AAT_INFORMATION9 in VARCHAR2
133 ,P_AAT_INFORMATION10
134 in VARCHAR2
135 ,P_AAT_INFORMATION11 in VARCHAR2
136 ,P_AAT_INFORMATION12 in VARCHAR2
137 ,P_AAT_INFORMATION13 in VARCHAR2
138 ,P_AAT_INFORMATION14 in
139 VARCHAR2
140 ,P_AAT_INFORMATION15 in VARCHAR2
141 ,P_AAT_INFORMATION16 in VARCHAR2
142 ,P_AAT_INFORMATION17 in VARCHAR2
143 ,P_AAT_INFORMATION18 in VARCHAR2
144
145 ,P_AAT_INFORMATION19 in VARCHAR2
146 ,P_AAT_INFORMATION20 in VARCHAR2
147 ) IS
148 l_mode varchar2(80);
149
150 --
151 BEGIN
152
153 --
154 hr_utility.trace('>> Dynamic trigger package, original dummy procedure.');
155 hr_utility.trace('>> PAY_DYT_ASSIGNMENT_ATTRIB_PKG.after_insert');
156 --
157 END AFTER_INSERT;
158
159 --
160
161 /*
162 ================================================
163 This is a dynamically generated procedure.
164 Will be called by API.
165 ================================================
166 ** DO NOT CHANGE MANUALLY **
167
168 ------------------------------------------------
169 Name: AFTER_UPDATE
170 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
171 Action: UPDATE
172 Generated Date: 31/03/2004 09:06
173 Description: Called as part of UPDATE process
174
175 ================================================
176 */
177
178 --
179 PROCEDURE AFTER_UPDATE
180 (
181 P_EFFECTIVE_DATE in DATE
182 ,P_DATETRACK_MODE in VARCHAR2
183 ,P_VALIDATION_START_DATE in DATE
184
185 ,P_VALIDATION_END_DATE in DATE
186 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
187 ,P_EFFECTIVE_START_DATE in DATE
188 ,P_EFFECTIVE_END_DATE in DATE
189 ,P_BUSINESS_GROUP_ID
190 in NUMBER
191 ,P_ASSIGNMENT_ID in NUMBER
192 ,P_CONTRACT_TYPE in VARCHAR2
193 ,P_WORK_PATTERN in VARCHAR2
194 ,P_START_DAY in VARCHAR2
195
196 ,P_OBJECT_VERSION_NUMBER in NUMBER
197 ,P_PRIMARY_COMPANY_CAR in NUMBER
198 ,P_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
199 ,P_PRIMARY_CLASS_1A in VARCHAR2
200
201 ,P_PRIMARY_CAPITAL_CONTRIBUTION in NUMBER
202 ,P_PRIMARY_PRIVATE_CONTRIBUTION in NUMBER
203 ,P_SECONDARY_COMPANY_CAR in NUMBER
204 ,P_SECONDARY_CAR_FUEL_BENEFIT in VARCHAR2
205 ,P_SECONDARY_CLASS_1A
206 in VARCHAR2
207 ,P_SECONDARY_CAPITAL_CONTRIBUTI in NUMBER
208 ,P_SECONDARY_PRIVATE_CONTRIBUTI in NUMBER
209 ,P_COMPANY_CAR_CALC_METHOD in VARCHAR2
210 ,P_COMPANY_CAR_RATES_TABLE_ID in NUMBER
211
212 ,P_COMPANY_CAR_SECONDARY_TABLE in NUMBER
213 ,P_PRIVATE_CAR in NUMBER
214 ,P_PRIVATE_CAR_CALC_METHOD in VARCHAR2
215 ,P_PRIVATE_CAR_RATES_TABLE_ID in NUMBER
216 ,P_PRIVATE_CAR_ESSENTIAL_TABLE
217 in NUMBER
218 ,P_TP_IS_TEACHER in VARCHAR2
219 ,P_TP_HEADTEACHER_GRP_CODE in NUMBER
220 ,P_TP_SAFEGUARDED_GRADE in VARCHAR2
221 ,P_TP_SAFEGUARDED_GRADE_ID in NUMBER
222 ,P_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
223
224 ,P_TP_SAFEGUARDED_RATE_ID in NUMBER
225 ,P_TP_SPINAL_POINT_ID in NUMBER
226 ,P_TP_ELECTED_PENSION in VARCHAR2
227 ,P_TP_FAST_TRACK in VARCHAR2
228 ,P_AAT_ATTRIBUTE_CATEGORY
229 in VARCHAR2
230 ,P_AAT_ATTRIBUTE1 in VARCHAR2
231 ,P_AAT_ATTRIBUTE2 in VARCHAR2
232 ,P_AAT_ATTRIBUTE3 in VARCHAR2
233 ,P_AAT_ATTRIBUTE4 in VARCHAR2
234
235 ,P_AAT_ATTRIBUTE5 in VARCHAR2
236 ,P_AAT_ATTRIBUTE6 in VARCHAR2
237 ,P_AAT_ATTRIBUTE7 in VARCHAR2
238 ,P_AAT_ATTRIBUTE8 in VARCHAR2
239 ,P_AAT_ATTRIBUTE9
240 in VARCHAR2
241 ,P_AAT_ATTRIBUTE10 in VARCHAR2
242 ,P_AAT_ATTRIBUTE11 in VARCHAR2
243 ,P_AAT_ATTRIBUTE12 in VARCHAR2
244 ,P_AAT_ATTRIBUTE13 in
245 VARCHAR2
246 ,P_AAT_ATTRIBUTE14 in VARCHAR2
247 ,P_AAT_ATTRIBUTE15 in VARCHAR2
248 ,P_AAT_ATTRIBUTE16 in VARCHAR2
249 ,P_AAT_ATTRIBUTE17 in VARCHAR2
250
251 ,P_AAT_ATTRIBUTE18 in VARCHAR2
252 ,P_AAT_ATTRIBUTE19 in VARCHAR2
253 ,P_AAT_ATTRIBUTE20 in VARCHAR2
254 ,P_AAT_INFORMATION_CATEGORY in VARCHAR2
255 ,P_AAT_INFORMATION1
256 in VARCHAR2
257 ,P_AAT_INFORMATION2 in VARCHAR2
258 ,P_AAT_INFORMATION3 in VARCHAR2
259 ,P_AAT_INFORMATION4 in VARCHAR2
260 ,P_AAT_INFORMATION5 in
261 VARCHAR2
262 ,P_AAT_INFORMATION6 in VARCHAR2
263 ,P_AAT_INFORMATION7 in VARCHAR2
264 ,P_AAT_INFORMATION8 in VARCHAR2
265 ,P_AAT_INFORMATION9 in VARCHAR2
266
267 ,P_AAT_INFORMATION10 in VARCHAR2
268 ,P_AAT_INFORMATION11 in VARCHAR2
269 ,P_AAT_INFORMATION12 in VARCHAR2
270 ,P_AAT_INFORMATION13 in VARCHAR2
271 ,P_AAT_INFORMATION14
272 in VARCHAR2
273 ,P_AAT_INFORMATION15 in VARCHAR2
274 ,P_AAT_INFORMATION16 in VARCHAR2
275 ,P_AAT_INFORMATION17 in VARCHAR2
276 ,P_AAT_INFORMATION18 in
277 VARCHAR2
278 ,P_AAT_INFORMATION19 in VARCHAR2
279 ,P_AAT_INFORMATION20 in VARCHAR2
280 ,P_EFFECTIVE_START_DATE_O in DATE
281 ,P_EFFECTIVE_END_DATE_O in DATE
282 ,P_BUSINESS_GROUP_ID_O
283 in NUMBER
284 ,P_ASSIGNMENT_ID_O in NUMBER
285 ,P_CONTRACT_TYPE_O in VARCHAR2
286 ,P_WORK_PATTERN_O in VARCHAR2
287 ,P_START_DAY_O in
288 VARCHAR2
289 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
290 ,P_PRIMARY_COMPANY_CAR_O in NUMBER
291 ,P_PRIMARY_CAR_FUEL_BENEFIT_O in VARCHAR2
292 ,P_PRIMARY_CLASS_1A_O in VARCHAR2
293
294 ,P_PRIMARY_CAPITAL_CONTRIBUTI_O in NUMBER
295 ,P_PRIMARY_PRIVATE_CONTRIBUTI_O in NUMBER
296 ,P_SECONDARY_COMPANY_CAR_O in NUMBER
297 ,P_SECONDARY_CAR_FUEL_BENEFIT_O in VARCHAR2
298 ,P_SECONDARY_CLASS_1A_O
299 in VARCHAR2
300 ,P_SECONDARY_CAPITAL_CONTRIBU_O in NUMBER
301 ,P_SECONDARY_PRIVATE_CONTRIBU_O in NUMBER
302 ,P_COMPANY_CAR_CALC_METHOD_O in VARCHAR2
303 ,P_COMPANY_CAR_RATES_TABLE_ID_O in NUMBER
304
305 ,P_COMPANY_CAR_SECONDARY_TABL_O in NUMBER
306 ,P_PRIVATE_CAR_O in NUMBER
307 ,P_PRIVATE_CAR_CALC_METHOD_O in VARCHAR2
308 ,P_PRIVATE_CAR_RATES_TABLE_ID_O in NUMBER
309 ,P_PRIVATE_CAR_ESSENTIAL_TABL_O
310 in NUMBER
311 ,P_TP_IS_TEACHER_O in VARCHAR2
312 ,P_TP_HEADTEACHER_GRP_CODE_O in NUMBER
313 ,P_TP_SAFEGUARDED_GRADE_O in VARCHAR2
314 ,P_TP_SAFEGUARDED_GRADE_ID_O in NUMBER
315 ,P_TP_SAFEGUARDED_RATE_TYPE_O in VARCHAR2
316
317 ,P_TP_SAFEGUARDED_RATE_ID_O in NUMBER
318 ,P_TP_SPINAL_POINT_ID_O in NUMBER
319 ,P_TP_ELECTED_PENSION_O in VARCHAR2
320 ,P_TP_FAST_TRACK_O in VARCHAR2
321 ,P_AAT_ATTRIBUTE_CATEGORY_O
322 in VARCHAR2
323 ,P_AAT_ATTRIBUTE1_O in VARCHAR2
324 ,P_AAT_ATTRIBUTE2_O in VARCHAR2
325 ,P_AAT_ATTRIBUTE3_O in VARCHAR2
326 ,P_AAT_ATTRIBUTE4_O in VARCHAR2
327
328 ,P_AAT_ATTRIBUTE5_O in VARCHAR2
329 ,P_AAT_ATTRIBUTE6_O in VARCHAR2
330 ,P_AAT_ATTRIBUTE7_O in VARCHAR2
331 ,P_AAT_ATTRIBUTE8_O in VARCHAR2
332 ,P_AAT_ATTRIBUTE9_O
333 in VARCHAR2
334 ,P_AAT_ATTRIBUTE10_O in VARCHAR2
335 ,P_AAT_ATTRIBUTE11_O in VARCHAR2
336 ,P_AAT_ATTRIBUTE12_O in VARCHAR2
337 ,P_AAT_ATTRIBUTE13_O in
338 VARCHAR2
339 ,P_AAT_ATTRIBUTE14_O in VARCHAR2
340 ,P_AAT_ATTRIBUTE15_O in VARCHAR2
341 ,P_AAT_ATTRIBUTE16_O in VARCHAR2
342 ,P_AAT_ATTRIBUTE17_O in VARCHAR2
343
344 ,P_AAT_ATTRIBUTE18_O in VARCHAR2
345 ,P_AAT_ATTRIBUTE19_O in VARCHAR2
346 ,P_AAT_ATTRIBUTE20_O in VARCHAR2
347 ,P_AAT_INFORMATION_CATEGORY_O in VARCHAR2
348 ,P_AAT_INFORMATION1_O
349 in VARCHAR2
350 ,P_AAT_INFORMATION2_O in VARCHAR2
351 ,P_AAT_INFORMATION3_O in VARCHAR2
352 ,P_AAT_INFORMATION4_O in VARCHAR2
353 ,P_AAT_INFORMATION5_O in
354 VARCHAR2
355 ,P_AAT_INFORMATION6_O in VARCHAR2
356 ,P_AAT_INFORMATION7_O in VARCHAR2
357 ,P_AAT_INFORMATION8_O in VARCHAR2
358 ,P_AAT_INFORMATION9_O in VARCHAR2
359
360 ,P_AAT_INFORMATION10_O in VARCHAR2
361 ,P_AAT_INFORMATION11_O in VARCHAR2
362 ,P_AAT_INFORMATION12_O in VARCHAR2
363 ,P_AAT_INFORMATION13_O in VARCHAR2
364 ,P_AAT_INFORMATION14_O
365 in VARCHAR2
366 ,P_AAT_INFORMATION15_O in VARCHAR2
367 ,P_AAT_INFORMATION16_O in VARCHAR2
371 ,P_AAT_INFORMATION19_O in VARCHAR2
368 ,P_AAT_INFORMATION17_O in VARCHAR2
369 ,P_AAT_INFORMATION18_O in
370 VARCHAR2
372 ,P_AAT_INFORMATION20_O in VARCHAR2
373 ) IS
374 l_mode varchar2(80);
375
376 --
377 BEGIN
378
379 --
380 hr_utility.trace('>> Dynamic trigger package, original dummy procedure.');
381 hr_utility.trace('>> PAY_DYT_ASSIGNMENT_ATTRIB_PKG.after_update');
382 --
383 END AFTER_UPDATE;
384
385 --
386
387 /*
388 ================================================
389 This is a dynamically generated procedure.
390 Will be called by API.
391 ================================================
392 ** DO NOT CHANGE MANUALLY **
393
394 ------------------------------------------------
395 Name: AFTER_DELETE
396 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
397 Action: DELETE
398 Generated Date: 31/03/2004 09:06
399 Description: Called as part of DELETE process
400
401 ================================================
402 */
403
404 --
405 PROCEDURE AFTER_DELETE
406 (
407 P_EFFECTIVE_DATE in DATE
408 ,P_DATETRACK_MODE in VARCHAR2
409 ,P_VALIDATION_START_DATE in DATE
410
411 ,P_VALIDATION_END_DATE in DATE
412 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
413 ,P_EFFECTIVE_START_DATE in DATE
414 ,P_EFFECTIVE_END_DATE in DATE
415 ,P_EFFECTIVE_START_DATE_O
416 in DATE
417 ,P_EFFECTIVE_END_DATE_O in DATE
418 ,P_BUSINESS_GROUP_ID_O in NUMBER
419 ,P_ASSIGNMENT_ID_O in NUMBER
420 ,P_CONTRACT_TYPE_O in VARCHAR2
421 ,P_WORK_PATTERN_O
422 in VARCHAR2
423 ,P_START_DAY_O in VARCHAR2
424 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
425 ,P_PRIMARY_COMPANY_CAR_O in NUMBER
426 ,P_PRIMARY_CAR_FUEL_BENEFIT_O in
427 VARCHAR2
428 ,P_PRIMARY_CLASS_1A_O in VARCHAR2
429 ,P_PRIMARY_CAPITAL_CONTRIBUTI_O in NUMBER
430 ,P_PRIMARY_PRIVATE_CONTRIBUTI_O in NUMBER
431 ,P_SECONDARY_COMPANY_CAR_O in NUMBER
432
433 ,P_SECONDARY_CAR_FUEL_BENEFIT_O in VARCHAR2
434 ,P_SECONDARY_CLASS_1A_O in VARCHAR2
435 ,P_SECONDARY_CAPITAL_CONTRIBU_O in NUMBER
436 ,P_SECONDARY_PRIVATE_CONTRIBU_O in NUMBER
437 ,P_COMPANY_CAR_CALC_METHOD_O
438 in VARCHAR2
439 ,P_COMPANY_CAR_RATES_TABLE_ID_O in NUMBER
440 ,P_COMPANY_CAR_SECONDARY_TABL_O in NUMBER
441 ,P_PRIVATE_CAR_O in NUMBER
442 ,P_PRIVATE_CAR_CALC_METHOD_O in VARCHAR2
443
444 ,P_PRIVATE_CAR_RATES_TABLE_ID_O in NUMBER
445 ,P_PRIVATE_CAR_ESSENTIAL_TABL_O in NUMBER
446 ,P_TP_IS_TEACHER_O in VARCHAR2
447 ,P_TP_HEADTEACHER_GRP_CODE_O in NUMBER
448 ,P_TP_SAFEGUARDED_GRADE_O in VARCHAR2
449 ,P_TP_SAFEGUARDED_GRADE_ID_O
450 in NUMBER
451 ,P_TP_SAFEGUARDED_RATE_TYPE_O in VARCHAR2
452 ,P_TP_SAFEGUARDED_RATE_ID_O in NUMBER
453 ,P_TP_SPINAL_POINT_ID_O in NUMBER
454 ,P_TP_ELECTED_PENSION_O in VARCHAR2
455
456 ,P_TP_FAST_TRACK_O in VARCHAR2
457 ,P_AAT_ATTRIBUTE_CATEGORY_O in VARCHAR2
458 ,P_AAT_ATTRIBUTE1_O in VARCHAR2
459 ,P_AAT_ATTRIBUTE2_O in VARCHAR2
460 ,P_AAT_ATTRIBUTE3_O
461 in VARCHAR2
462 ,P_AAT_ATTRIBUTE4_O in VARCHAR2
463 ,P_AAT_ATTRIBUTE5_O in VARCHAR2
464 ,P_AAT_ATTRIBUTE6_O in VARCHAR2
465 ,P_AAT_ATTRIBUTE7_O in
466 VARCHAR2
467 ,P_AAT_ATTRIBUTE8_O in VARCHAR2
468 ,P_AAT_ATTRIBUTE9_O in VARCHAR2
469 ,P_AAT_ATTRIBUTE10_O in VARCHAR2
470 ,P_AAT_ATTRIBUTE11_O in VARCHAR2
471
472 ,P_AAT_ATTRIBUTE12_O in VARCHAR2
473 ,P_AAT_ATTRIBUTE13_O in VARCHAR2
474 ,P_AAT_ATTRIBUTE14_O in VARCHAR2
475 ,P_AAT_ATTRIBUTE15_O in VARCHAR2
476 ,P_AAT_ATTRIBUTE16_O
477 in VARCHAR2
478 ,P_AAT_ATTRIBUTE17_O in VARCHAR2
479 ,P_AAT_ATTRIBUTE18_O in VARCHAR2
480 ,P_AAT_ATTRIBUTE19_O in VARCHAR2
481 ,P_AAT_ATTRIBUTE20_O in
482 VARCHAR2
483 ,P_AAT_INFORMATION_CATEGORY_O in VARCHAR2
484 ,P_AAT_INFORMATION1_O in VARCHAR2
485 ,P_AAT_INFORMATION2_O in VARCHAR2
486 ,P_AAT_INFORMATION3_O in VARCHAR2
487
488 ,P_AAT_INFORMATION4_O in VARCHAR2
489 ,P_AAT_INFORMATION5_O in VARCHAR2
490 ,P_AAT_INFORMATION6_O in VARCHAR2
491 ,P_AAT_INFORMATION7_O in VARCHAR2
492 ,P_AAT_INFORMATION8_O
493 in VARCHAR2
494 ,P_AAT_INFORMATION9_O in VARCHAR2
495 ,P_AAT_INFORMATION10_O in VARCHAR2
496 ,P_AAT_INFORMATION11_O in VARCHAR2
497 ,P_AAT_INFORMATION12_O in
498 VARCHAR2
499 ,P_AAT_INFORMATION13_O in VARCHAR2
500 ,P_AAT_INFORMATION14_O in VARCHAR2
501 ,P_AAT_INFORMATION15_O in VARCHAR2
502 ,P_AAT_INFORMATION16_O in VARCHAR2
503
504 ,P_AAT_INFORMATION17_O in VARCHAR2
505 ,P_AAT_INFORMATION18_O in VARCHAR2
506 ,P_AAT_INFORMATION19_O in VARCHAR2
507 ,P_AAT_INFORMATION20_O in VARCHAR2
508 ) IS
509 l_mode
510 varchar2(80);
511
512 --
513 BEGIN
514 --
515 hr_utility.trace('>> Dynamic trigger package, original dummy procedure.');
516 hr_utility.trace('>> PAY_DYT_ASSIGNMENT_ATTRIB_PKG.after_delete');
517 --
518 END AFTER_DELETE;
519
520 --
521
522 /* END_PACKAGE */
523 END PAY_DYT_ASSIGNMENT_ATTRIB_PKG;