1 package PAY_DYT_ASSIGNMENT_ATTRIB_PKG
2 AS
3
4 --
5 /*
6 ==================================================
7 This is a dynamically generated database package
8 containing code to support the use of dynamic
9 triggers.
10 Preference of package Vs dbms triggers supporting
11 dyn' triggers is made via the dated table form.
12 .
13 This code will be called implicitly by table rhi
14 and explictly from non-API packages that maintain
15 data on the relevant table.
16 ==================================================
17 ** DO NOT CHANGE MANUALLY **
18 --------------------------------------------------
19 Package Name: PAY_DYT_ASSIGNMENT_ATTRIB_PKG
20 Base Table: PQP_ASSIGNMENT_ATTRIBUTES_F
21 Date: 27/11/2012 04:01
22 ==================================================
23 */
24
25 --
26 /*
27 ================================================
28 This is a dynamically generated package procedure
29 with code representing a dynamic trigger
30 ================================================
31 ** DO NOT CHANGE MANUALLY **
32 ------------------------------------------------
33 Name: PQP_ASSIGNMENT_ATTRIBUTES__ARI
34 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
35 Action: Insert
36 Generated Date: 27/11/2012 04:01
37 Description: Continuous Calculation trigger on insert of PQP_ASSIGNMENT_ATTRIBUTES_F
38 Full trigger name: PQP_ASSIGNMENT_ATTRIBUTES_F_ARI
39 ================================================
40 */
41 --
42 PROCEDURE PQP_ASSIGNMENT_ATTRIBUTES__ARI
43 (
44 p_new_AAT_ATTRIBUTE1 in VARCHAR2
45 ,p_new_AAT_ATTRIBUTE10 in VARCHAR2
46 ,p_new_AAT_ATTRIBUTE11 in VARCHAR2
47 ,p_new_AAT_ATTRIBUTE12 in VARCHAR2
48 ,p_new_AAT_ATTRIBUTE13 in VARCHAR2
49 ,p_new_AAT_ATTRIBUTE14 in VARCHAR2
50 ,p_new_AAT_ATTRIBUTE15 in VARCHAR2
51 ,p_new_AAT_ATTRIBUTE16 in VARCHAR2
52 ,p_new_AAT_ATTRIBUTE17 in VARCHAR2
53 ,p_new_AAT_ATTRIBUTE18 in VARCHAR2
54 ,p_new_AAT_ATTRIBUTE19 in VARCHAR2
55 ,p_new_AAT_ATTRIBUTE2 in VARCHAR2
56 ,p_new_AAT_ATTRIBUTE20 in VARCHAR2
57 ,p_new_AAT_ATTRIBUTE3 in VARCHAR2
58 ,p_new_AAT_ATTRIBUTE4 in VARCHAR2
59 ,p_new_AAT_ATTRIBUTE5 in VARCHAR2
60 ,p_new_AAT_ATTRIBUTE6 in VARCHAR2
61 ,p_new_AAT_ATTRIBUTE7 in VARCHAR2
62 ,p_new_AAT_ATTRIBUTE8 in VARCHAR2
63 ,p_new_AAT_ATTRIBUTE9 in VARCHAR2
64 ,p_new_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
65 ,p_new_AAT_INFORMATION1 in VARCHAR2
66 ,p_new_AAT_INFORMATION10 in VARCHAR2
67 ,p_new_AAT_INFORMATION11 in VARCHAR2
68 ,p_new_AAT_INFORMATION12 in VARCHAR2
69 ,p_new_AAT_INFORMATION13 in VARCHAR2
70 ,p_new_AAT_INFORMATION14 in VARCHAR2
71 ,p_new_AAT_INFORMATION15 in VARCHAR2
72 ,p_new_AAT_INFORMATION16 in VARCHAR2
73 ,p_new_AAT_INFORMATION17 in VARCHAR2
74 ,p_new_AAT_INFORMATION18 in VARCHAR2
75 ,p_new_AAT_INFORMATION19 in VARCHAR2
76 ,p_new_AAT_INFORMATION2 in VARCHAR2
77 ,p_new_AAT_INFORMATION20 in VARCHAR2
78 ,p_new_AAT_INFORMATION3 in VARCHAR2
79 ,p_new_AAT_INFORMATION4 in VARCHAR2
80 ,p_new_AAT_INFORMATION5 in VARCHAR2
81 ,p_new_AAT_INFORMATION6 in VARCHAR2
82 ,p_new_AAT_INFORMATION7 in VARCHAR2
83 ,p_new_AAT_INFORMATION8 in VARCHAR2
84 ,p_new_AAT_INFORMATION9 in VARCHAR2
85 ,p_new_AAT_INFORMATION_CATEGORY in VARCHAR2
86 ,p_new_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
87 ,p_new_ASSIGNMENT_ID in NUMBER
88 ,p_new_BUSINESS_GROUP_ID in NUMBER
89 ,p_new_COMPANY_CAR_CALC_METHOD in VARCHAR2
90 ,p_new_COMPANY_CAR_RATES_TABLE_ in NUMBER
91 ,p_new_COMPANY_CAR_SECONDARY_TA in NUMBER
92 ,p_new_CONTRACT_TYPE in VARCHAR2
93 ,p_new_EFFECTIVE_DATE in DATE
94 ,p_new_EFFECTIVE_END_DATE in DATE
95 ,p_new_EFFECTIVE_START_DATE in DATE
96 ,p_new_LGPS_EXCLUSION_TYPE in VARCHAR2
97 ,p_new_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
98 ,p_new_LGPS_PENSIONABLE_PAY in VARCHAR2
99 ,p_new_LGPS_PROCESS_FLAG in VARCHAR2
100 ,p_new_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
101 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
102 ,p_new_PRIMARY_CAPITAL_CONTRIBU in NUMBER
103 ,p_new_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
104 ,p_new_PRIMARY_CLASS_1A in VARCHAR2
105 ,p_new_PRIMARY_COMPANY_CAR in NUMBER
106 ,p_new_PRIMARY_PRIVATE_CONTRIBU in NUMBER
107 ,p_new_PRIVATE_CAR in NUMBER
108 ,p_new_PRIVATE_CAR_CALC_METHOD in VARCHAR2
109 ,p_new_PRIVATE_CAR_ESSENTIAL_TA in NUMBER
110 ,p_new_PRIVATE_CAR_RATES_TABLE_ in NUMBER
111 ,p_new_SECONDARY_CAPITAL_CONTRI in NUMBER
112 ,p_new_SECONDARY_CAR_FUEL_BENEF in VARCHAR2
113 ,p_new_SECONDARY_CLASS_1A in VARCHAR2
114 ,p_new_SECONDARY_COMPANY_CAR in NUMBER
115 ,p_new_SECONDARY_PRIVATE_CONTRI in NUMBER
116 ,p_new_START_DAY in VARCHAR2
117 ,p_new_TP_ELECTED_PENSION in VARCHAR2
118 ,p_new_TP_FAST_TRACK in VARCHAR2
119 ,p_new_TP_IS_TEACHER in VARCHAR2
120 ,p_new_TP_SAFEGUARDED_GRADE in NUMBER
121 ,p_new_TP_SAFEGUARDED_GRADE_ID in NUMBER
122 ,p_new_TP_SAFEGUARDED_RATE_ID in NUMBER
123 ,p_new_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
124 ,p_new_TP_SAFEGUARDED_SPINAL_PO in NUMBER
125 ,p_new_TP_SPINAL_POINT_ID in NUMBER
126 ,p_new_VALIDATION_END_DATE in DATE
127 ,p_new_VALIDATION_START_DATE in DATE
128 ,p_new_WORK_PATTERN in VARCHAR2
129 ); -- End of procedure definition for PQP_ASSIGNMENT_ATTRIBUTES__ARI
130
131 --
132 /*
133 ================================================
134 This is a dynamically generated package procedure
135 with code representing a dynamic trigger
136 ================================================
137 ** DO NOT CHANGE MANUALLY **
138 ------------------------------------------------
139 Name: PQP_ASSIGNMENT_ATTRIBUTES__ARU
140 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
141 Action: Update
142 Generated Date: 27/11/2012 04:01
143 Description: Continuous Calculation trigger on update of PQP_ASSIGNMENT_ATTRIBUTES_F
144 Full trigger name: PQP_ASSIGNMENT_ATTRIBUTES_F_ARU
145 ================================================
146 */
147 --
148 PROCEDURE PQP_ASSIGNMENT_ATTRIBUTES__ARU
149 (
150 p_new_AAT_ATTRIBUTE1 in VARCHAR2
151 ,p_new_AAT_ATTRIBUTE10 in VARCHAR2
152 ,p_new_AAT_ATTRIBUTE11 in VARCHAR2
153 ,p_new_AAT_ATTRIBUTE12 in VARCHAR2
154 ,p_new_AAT_ATTRIBUTE13 in VARCHAR2
155 ,p_new_AAT_ATTRIBUTE14 in VARCHAR2
156 ,p_new_AAT_ATTRIBUTE15 in VARCHAR2
157 ,p_new_AAT_ATTRIBUTE16 in VARCHAR2
158 ,p_new_AAT_ATTRIBUTE17 in VARCHAR2
159 ,p_new_AAT_ATTRIBUTE18 in VARCHAR2
160 ,p_new_AAT_ATTRIBUTE19 in VARCHAR2
161 ,p_new_AAT_ATTRIBUTE2 in VARCHAR2
162 ,p_new_AAT_ATTRIBUTE20 in VARCHAR2
163 ,p_new_AAT_ATTRIBUTE3 in VARCHAR2
164 ,p_new_AAT_ATTRIBUTE4 in VARCHAR2
165 ,p_new_AAT_ATTRIBUTE5 in VARCHAR2
166 ,p_new_AAT_ATTRIBUTE6 in VARCHAR2
167 ,p_new_AAT_ATTRIBUTE7 in VARCHAR2
168 ,p_new_AAT_ATTRIBUTE8 in VARCHAR2
169 ,p_new_AAT_ATTRIBUTE9 in VARCHAR2
170 ,p_new_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
171 ,p_new_AAT_INFORMATION1 in VARCHAR2
172 ,p_new_AAT_INFORMATION10 in VARCHAR2
173 ,p_new_AAT_INFORMATION11 in VARCHAR2
174 ,p_new_AAT_INFORMATION12 in VARCHAR2
175 ,p_new_AAT_INFORMATION13 in VARCHAR2
176 ,p_new_AAT_INFORMATION14 in VARCHAR2
177 ,p_new_AAT_INFORMATION15 in VARCHAR2
178 ,p_new_AAT_INFORMATION16 in VARCHAR2
179 ,p_new_AAT_INFORMATION17 in VARCHAR2
180 ,p_new_AAT_INFORMATION18 in VARCHAR2
181 ,p_new_AAT_INFORMATION19 in VARCHAR2
182 ,p_new_AAT_INFORMATION2 in VARCHAR2
183 ,p_new_AAT_INFORMATION20 in VARCHAR2
184 ,p_new_AAT_INFORMATION3 in VARCHAR2
185 ,p_new_AAT_INFORMATION4 in VARCHAR2
186 ,p_new_AAT_INFORMATION5 in VARCHAR2
187 ,p_new_AAT_INFORMATION6 in VARCHAR2
188 ,p_new_AAT_INFORMATION7 in VARCHAR2
189 ,p_new_AAT_INFORMATION8 in VARCHAR2
190 ,p_new_AAT_INFORMATION9 in VARCHAR2
191 ,p_new_AAT_INFORMATION_CATEGORY in VARCHAR2
192 ,p_new_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
193 ,p_new_ASSIGNMENT_ID in NUMBER
194 ,p_new_BUSINESS_GROUP_ID in NUMBER
195 ,p_new_COMPANY_CAR_CALC_METHOD in VARCHAR2
196 ,p_new_COMPANY_CAR_RATES_TABLE_ in NUMBER
197 ,p_new_COMPANY_CAR_SECONDARY_TA in NUMBER
198 ,p_new_CONTRACT_TYPE in VARCHAR2
199 ,p_new_DATETRACK_MODE in VARCHAR2
200 ,p_new_EFFECTIVE_DATE in DATE
201 ,p_new_EFFECTIVE_END_DATE in DATE
202 ,p_new_EFFECTIVE_START_DATE in DATE
203 ,p_new_LGPS_EXCLUSION_TYPE in VARCHAR2
204 ,p_new_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
205 ,p_new_LGPS_PENSIONABLE_PAY in VARCHAR2
206 ,p_new_LGPS_PROCESS_FLAG in VARCHAR2
207 ,p_new_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
208 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
209 ,p_new_PRIMARY_CAPITAL_CONTRIBU in NUMBER
210 ,p_new_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
211 ,p_new_PRIMARY_CLASS_1A in VARCHAR2
212 ,p_new_PRIMARY_COMPANY_CAR in NUMBER
213 ,p_new_PRIMARY_PRIVATE_CONTRIBU in NUMBER
214 ,p_new_PRIVATE_CAR in NUMBER
215 ,p_new_PRIVATE_CAR_CALC_METHOD in VARCHAR2
216 ,p_new_PRIVATE_CAR_ESSENTIAL_TA in NUMBER
217 ,p_new_PRIVATE_CAR_RATES_TABLE_ in NUMBER
218 ,p_new_SECONDARY_CAPITAL_CONTRI in NUMBER
219 ,p_new_SECONDARY_CAR_FUEL_BENEF in VARCHAR2
220 ,p_new_SECONDARY_CLASS_1A in VARCHAR2
221 ,p_new_SECONDARY_COMPANY_CAR in NUMBER
222 ,p_new_SECONDARY_PRIVATE_CONTRI in NUMBER
223 ,p_new_START_DAY in VARCHAR2
224 ,p_new_TP_ELECTED_PENSION in VARCHAR2
225 ,p_new_TP_FAST_TRACK in VARCHAR2
226 ,p_new_TP_IS_TEACHER in VARCHAR2
227 ,p_new_TP_SAFEGUARDED_GRADE in NUMBER
228 ,p_new_TP_SAFEGUARDED_GRADE_ID in NUMBER
229 ,p_new_TP_SAFEGUARDED_RATE_ID in NUMBER
230 ,p_new_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
231 ,p_new_TP_SAFEGUARDED_SPINAL_PO in NUMBER
232 ,p_new_TP_SPINAL_POINT_ID in NUMBER
233 ,p_new_VALIDATION_END_DATE in DATE
234 ,p_new_VALIDATION_START_DATE in DATE
235 ,p_new_WORK_PATTERN in VARCHAR2
236 ,p_old_AAT_ATTRIBUTE1 in VARCHAR2
237 ,p_old_AAT_ATTRIBUTE10 in VARCHAR2
238 ,p_old_AAT_ATTRIBUTE11 in VARCHAR2
239 ,p_old_AAT_ATTRIBUTE12 in VARCHAR2
240 ,p_old_AAT_ATTRIBUTE13 in VARCHAR2
241 ,p_old_AAT_ATTRIBUTE14 in VARCHAR2
242 ,p_old_AAT_ATTRIBUTE15 in VARCHAR2
243 ,p_old_AAT_ATTRIBUTE16 in VARCHAR2
244 ,p_old_AAT_ATTRIBUTE17 in VARCHAR2
245 ,p_old_AAT_ATTRIBUTE18 in VARCHAR2
246 ,p_old_AAT_ATTRIBUTE19 in VARCHAR2
247 ,p_old_AAT_ATTRIBUTE2 in VARCHAR2
248 ,p_old_AAT_ATTRIBUTE20 in VARCHAR2
249 ,p_old_AAT_ATTRIBUTE3 in VARCHAR2
250 ,p_old_AAT_ATTRIBUTE4 in VARCHAR2
251 ,p_old_AAT_ATTRIBUTE5 in VARCHAR2
252 ,p_old_AAT_ATTRIBUTE6 in VARCHAR2
253 ,p_old_AAT_ATTRIBUTE7 in VARCHAR2
254 ,p_old_AAT_ATTRIBUTE8 in VARCHAR2
255 ,p_old_AAT_ATTRIBUTE9 in VARCHAR2
256 ,p_old_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
257 ,p_old_AAT_INFORMATION1 in VARCHAR2
258 ,p_old_AAT_INFORMATION10 in VARCHAR2
259 ,p_old_AAT_INFORMATION11 in VARCHAR2
260 ,p_old_AAT_INFORMATION12 in VARCHAR2
261 ,p_old_AAT_INFORMATION13 in VARCHAR2
262 ,p_old_AAT_INFORMATION14 in VARCHAR2
263 ,p_old_AAT_INFORMATION15 in VARCHAR2
264 ,p_old_AAT_INFORMATION16 in VARCHAR2
265 ,p_old_AAT_INFORMATION17 in VARCHAR2
266 ,p_old_AAT_INFORMATION18 in VARCHAR2
267 ,p_old_AAT_INFORMATION19 in VARCHAR2
268 ,p_old_AAT_INFORMATION2 in VARCHAR2
269 ,p_old_AAT_INFORMATION20 in VARCHAR2
270 ,p_old_AAT_INFORMATION3 in VARCHAR2
271 ,p_old_AAT_INFORMATION4 in VARCHAR2
272 ,p_old_AAT_INFORMATION5 in VARCHAR2
273 ,p_old_AAT_INFORMATION6 in VARCHAR2
274 ,p_old_AAT_INFORMATION7 in VARCHAR2
275 ,p_old_AAT_INFORMATION8 in VARCHAR2
276 ,p_old_AAT_INFORMATION9 in VARCHAR2
277 ,p_old_AAT_INFORMATION_CATEGORY in VARCHAR2
278 ,p_old_ASSIGNMENT_ID in NUMBER
282 ,p_old_COMPANY_CAR_SECONDARY_TA in NUMBER
279 ,p_old_BUSINESS_GROUP_ID in NUMBER
280 ,p_old_COMPANY_CAR_CALC_METHOD in VARCHAR2
281 ,p_old_COMPANY_CAR_RATES_TABLE_ in NUMBER
283 ,p_old_CONTRACT_TYPE in VARCHAR2
284 ,p_old_EFFECTIVE_END_DATE in DATE
285 ,p_old_EFFECTIVE_START_DATE in DATE
286 ,p_old_LGPS_EXCLUSION_TYPE in VARCHAR2
287 ,p_old_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
288 ,p_old_LGPS_PENSIONABLE_PAY in VARCHAR2
289 ,p_old_LGPS_PROCESS_FLAG in VARCHAR2
290 ,p_old_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
291 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
292 ,p_old_PRIMARY_CAPITAL_CONTRIBU in NUMBER
293 ,p_old_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
294 ,p_old_PRIMARY_CLASS_1A in VARCHAR2
295 ,p_old_PRIMARY_COMPANY_CAR in NUMBER
296 ,p_old_PRIMARY_PRIVATE_CONTRIBU in NUMBER
297 ,p_old_PRIVATE_CAR in NUMBER
298 ,p_old_PRIVATE_CAR_CALC_METHOD in VARCHAR2
299 ,p_old_PRIVATE_CAR_ESSENTIAL_TA in NUMBER
300 ,p_old_PRIVATE_CAR_RATES_TABLE_ in NUMBER
301 ,p_old_SECONDARY_CAPITAL_CONTRI in NUMBER
302 ,p_old_SECONDARY_CAR_FUEL_BENEF in VARCHAR2
303 ,p_old_SECONDARY_CLASS_1A in VARCHAR2
304 ,p_old_SECONDARY_COMPANY_CAR in NUMBER
305 ,p_old_SECONDARY_PRIVATE_CONTRI in NUMBER
306 ,p_old_START_DAY in VARCHAR2
307 ,p_old_TP_ELECTED_PENSION in VARCHAR2
308 ,p_old_TP_FAST_TRACK in VARCHAR2
309 ,p_old_TP_IS_TEACHER in VARCHAR2
310 ,p_old_TP_SAFEGUARDED_GRADE in NUMBER
311 ,p_old_TP_SAFEGUARDED_GRADE_ID in NUMBER
312 ,p_old_TP_SAFEGUARDED_RATE_ID in NUMBER
313 ,p_old_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
314 ,p_old_TP_SAFEGUARDED_SPINAL_PO in NUMBER
315 ,p_old_TP_SPINAL_POINT_ID in NUMBER
316 ,p_old_WORK_PATTERN in VARCHAR2
317 ); -- End of procedure definition for PQP_ASSIGNMENT_ATTRIBUTES__ARU
318
319 --
320 /*
321 ================================================
322 This is a dynamically generated package procedure
323 with code representing a dynamic trigger
324 ================================================
325 ** DO NOT CHANGE MANUALLY **
326 ------------------------------------------------
327 Name: PQP_ASSIGNMENT_ATTRIBUTES__ARD
328 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
329 Action: Delete
330 Generated Date: 27/11/2012 04:01
331 Description: Continuous Calculation trigger on delete of PQP_ASSIGNMENT_ATTRIBUTES
332 Full trigger name: PQP_ASSIGNMENT_ATTRIBUTES_F_ARD
333 ================================================
334 */
335 --
336 PROCEDURE PQP_ASSIGNMENT_ATTRIBUTES__ARD
337 (
338 p_new_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
339 ,p_new_DATETRACK_MODE in VARCHAR2
340 ,p_new_EFFECTIVE_DATE in DATE
341 ,p_new_EFFECTIVE_END_DATE in DATE
342 ,p_new_EFFECTIVE_START_DATE in DATE
343 ,p_new_VALIDATION_END_DATE in DATE
344 ,p_new_VALIDATION_START_DATE in DATE
345 ,p_old_AAT_ATTRIBUTE1 in VARCHAR2
346 ,p_old_AAT_ATTRIBUTE10 in VARCHAR2
347 ,p_old_AAT_ATTRIBUTE11 in VARCHAR2
348 ,p_old_AAT_ATTRIBUTE12 in VARCHAR2
349 ,p_old_AAT_ATTRIBUTE13 in VARCHAR2
350 ,p_old_AAT_ATTRIBUTE14 in VARCHAR2
351 ,p_old_AAT_ATTRIBUTE15 in VARCHAR2
352 ,p_old_AAT_ATTRIBUTE16 in VARCHAR2
353 ,p_old_AAT_ATTRIBUTE17 in VARCHAR2
354 ,p_old_AAT_ATTRIBUTE18 in VARCHAR2
355 ,p_old_AAT_ATTRIBUTE19 in VARCHAR2
356 ,p_old_AAT_ATTRIBUTE2 in VARCHAR2
357 ,p_old_AAT_ATTRIBUTE20 in VARCHAR2
358 ,p_old_AAT_ATTRIBUTE3 in VARCHAR2
359 ,p_old_AAT_ATTRIBUTE4 in VARCHAR2
360 ,p_old_AAT_ATTRIBUTE5 in VARCHAR2
361 ,p_old_AAT_ATTRIBUTE6 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 VARCHAR2
366 ,p_old_AAT_INFORMATION1 in VARCHAR2
367 ,p_old_AAT_INFORMATION10 in VARCHAR2
368 ,p_old_AAT_INFORMATION11 in VARCHAR2
369 ,p_old_AAT_INFORMATION12 in VARCHAR2
370 ,p_old_AAT_INFORMATION13 in VARCHAR2
371 ,p_old_AAT_INFORMATION14 in VARCHAR2
372 ,p_old_AAT_INFORMATION15 in VARCHAR2
373 ,p_old_AAT_INFORMATION16 in VARCHAR2
374 ,p_old_AAT_INFORMATION17 in VARCHAR2
375 ,p_old_AAT_INFORMATION18 in VARCHAR2
376 ,p_old_AAT_INFORMATION19 in VARCHAR2
377 ,p_old_AAT_INFORMATION2 in VARCHAR2
378 ,p_old_AAT_INFORMATION20 in VARCHAR2
379 ,p_old_AAT_INFORMATION3 in VARCHAR2
383 ,p_old_AAT_INFORMATION7 in VARCHAR2
380 ,p_old_AAT_INFORMATION4 in VARCHAR2
381 ,p_old_AAT_INFORMATION5 in VARCHAR2
382 ,p_old_AAT_INFORMATION6 in VARCHAR2
384 ,p_old_AAT_INFORMATION8 in VARCHAR2
385 ,p_old_AAT_INFORMATION9 in VARCHAR2
386 ,p_old_AAT_INFORMATION_CATEGORY in VARCHAR2
387 ,p_old_ASSIGNMENT_ID in NUMBER
388 ,p_old_BUSINESS_GROUP_ID in NUMBER
389 ,p_old_COMPANY_CAR_CALC_METHOD in VARCHAR2
390 ,p_old_COMPANY_CAR_RATES_TABLE_ in NUMBER
391 ,p_old_COMPANY_CAR_SECONDARY_TA in NUMBER
392 ,p_old_CONTRACT_TYPE in VARCHAR2
393 ,p_old_EFFECTIVE_END_DATE in DATE
394 ,p_old_EFFECTIVE_START_DATE in DATE
395 ,p_old_LGPS_EXCLUSION_TYPE in VARCHAR2
396 ,p_old_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
397 ,p_old_LGPS_PENSIONABLE_PAY in VARCHAR2
398 ,p_old_LGPS_PROCESS_FLAG in VARCHAR2
399 ,p_old_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
400 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
401 ,p_old_PRIMARY_CAPITAL_CONTRIBU in NUMBER
402 ,p_old_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
403 ,p_old_PRIMARY_CLASS_1A in VARCHAR2
404 ,p_old_PRIMARY_COMPANY_CAR in NUMBER
405 ,p_old_PRIMARY_PRIVATE_CONTRIBU in NUMBER
406 ,p_old_PRIVATE_CAR in NUMBER
407 ,p_old_PRIVATE_CAR_CALC_METHOD in VARCHAR2
408 ,p_old_PRIVATE_CAR_ESSENTIAL_TA in NUMBER
409 ,p_old_PRIVATE_CAR_RATES_TABLE_ in NUMBER
410 ,p_old_SECONDARY_CAPITAL_CONTRI in NUMBER
411 ,p_old_SECONDARY_CAR_FUEL_BENEF in VARCHAR2
412 ,p_old_SECONDARY_CLASS_1A in VARCHAR2
413 ,p_old_SECONDARY_COMPANY_CAR in NUMBER
414 ,p_old_SECONDARY_PRIVATE_CONTRI in NUMBER
415 ,p_old_START_DAY in VARCHAR2
416 ,p_old_TP_ELECTED_PENSION in VARCHAR2
417 ,p_old_TP_FAST_TRACK in VARCHAR2
418 ,p_old_TP_IS_TEACHER in VARCHAR2
419 ,p_old_TP_SAFEGUARDED_GRADE in NUMBER
420 ,p_old_TP_SAFEGUARDED_GRADE_ID in NUMBER
424 ,p_old_TP_SPINAL_POINT_ID in NUMBER
421 ,p_old_TP_SAFEGUARDED_RATE_ID in NUMBER
422 ,p_old_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
423 ,p_old_TP_SAFEGUARDED_SPINAL_PO in NUMBER
425 ,p_old_WORK_PATTERN in VARCHAR2
426 ); -- End of procedure definition for PQP_ASSIGNMENT_ATTRIBUTES__ARD
427
428 --
429 /*
430 ================================================
431 This is a dynamically generated procedure.
432 Will be called by API.
433 ================================================
434 ** DO NOT CHANGE MANUALLY **
435 ------------------------------------------------
436 Name: AFTER_INSERT
437 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
438 Action: INSERT
439 Generated Date: 27/11/2012 04:01
440 Description: Called as part of INSERT process
441 ================================================
442 */
443
444 --
445 PROCEDURE AFTER_INSERT
446 (
447 P_EFFECTIVE_DATE in DATE
448 ,P_VALIDATION_START_DATE in DATE
449 ,P_VALIDATION_END_DATE in DATE
450 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
451 ,P_EFFECTIVE_START_DATE in DATE
452 ,P_EFFECTIVE_END_DATE in DATE
453 ,P_BUSINESS_GROUP_ID in NUMBER
454 ,P_ASSIGNMENT_ID in NUMBER
455 ,P_CONTRACT_TYPE in VARCHAR2
456 ,P_WORK_PATTERN in VARCHAR2
457 ,P_START_DAY in VARCHAR2
458 ,P_OBJECT_VERSION_NUMBER in NUMBER
459 ,P_PRIMARY_COMPANY_CAR in NUMBER
460 ,P_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
461 ,P_PRIMARY_CLASS_1A in VARCHAR2
462 ,P_PRIMARY_CAPITAL_CONTRIBUTION in NUMBER
463 ,P_PRIMARY_PRIVATE_CONTRIBUTION in NUMBER
464 ,P_SECONDARY_COMPANY_CAR in NUMBER
465 ,P_SECONDARY_CAR_FUEL_BENEFIT in VARCHAR2
466 ,P_SECONDARY_CLASS_1A in VARCHAR2
467 ,P_SECONDARY_CAPITAL_CONTRIBUTI in NUMBER
468 ,P_SECONDARY_PRIVATE_CONTRIBUTI in NUMBER
469 ,P_COMPANY_CAR_CALC_METHOD in VARCHAR2
470 ,P_COMPANY_CAR_RATES_TABLE_ID in NUMBER
471 ,P_COMPANY_CAR_SECONDARY_TABLE in NUMBER
472 ,P_PRIVATE_CAR in NUMBER
473 ,P_PRIVATE_CAR_CALC_METHOD in VARCHAR2
474 ,P_PRIVATE_CAR_RATES_TABLE_ID in NUMBER
475 ,P_PRIVATE_CAR_ESSENTIAL_TABLE in NUMBER
476 ,P_TP_IS_TEACHER in VARCHAR2
477 ,P_TP_HEADTEACHER_GRP_CODE in NUMBER
478 ,P_TP_SAFEGUARDED_GRADE in VARCHAR2
479 ,P_TP_SAFEGUARDED_GRADE_ID in NUMBER
480 ,P_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
481 ,P_TP_SAFEGUARDED_RATE_ID in NUMBER
482 ,P_TP_SPINAL_POINT_ID in NUMBER
483 ,P_TP_ELECTED_PENSION in VARCHAR2
484 ,P_TP_FAST_TRACK in VARCHAR2
485 ,P_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
486 ,P_AAT_ATTRIBUTE1 in VARCHAR2
487 ,P_AAT_ATTRIBUTE2 in VARCHAR2
488 ,P_AAT_ATTRIBUTE3 in VARCHAR2
489 ,P_AAT_ATTRIBUTE4 in VARCHAR2
490 ,P_AAT_ATTRIBUTE5 in VARCHAR2
491 ,P_AAT_ATTRIBUTE6 in VARCHAR2
492 ,P_AAT_ATTRIBUTE7 in VARCHAR2
493 ,P_AAT_ATTRIBUTE8 in VARCHAR2
494 ,P_AAT_ATTRIBUTE9 in VARCHAR2
495 ,P_AAT_ATTRIBUTE10 in VARCHAR2
496 ,P_AAT_ATTRIBUTE11 in VARCHAR2
497 ,P_AAT_ATTRIBUTE12 in VARCHAR2
498 ,P_AAT_ATTRIBUTE13 in VARCHAR2
499 ,P_AAT_ATTRIBUTE14 in VARCHAR2
500 ,P_AAT_ATTRIBUTE15 in VARCHAR2
501 ,P_AAT_ATTRIBUTE16 in VARCHAR2
502 ,P_AAT_ATTRIBUTE17 in VARCHAR2
503 ,P_AAT_ATTRIBUTE18 in VARCHAR2
504 ,P_AAT_ATTRIBUTE19 in VARCHAR2
505 ,P_AAT_ATTRIBUTE20 in VARCHAR2
506 ,P_AAT_INFORMATION_CATEGORY in VARCHAR2
507 ,P_AAT_INFORMATION1 in VARCHAR2
508 ,P_AAT_INFORMATION2 in VARCHAR2
509 ,P_AAT_INFORMATION3 in VARCHAR2
510 ,P_AAT_INFORMATION4 in VARCHAR2
511 ,P_AAT_INFORMATION5 in VARCHAR2
512 ,P_AAT_INFORMATION6 in VARCHAR2
513 ,P_AAT_INFORMATION7 in VARCHAR2
514 ,P_AAT_INFORMATION8 in VARCHAR2
515 ,P_AAT_INFORMATION9 in VARCHAR2
516 ,P_AAT_INFORMATION10 in VARCHAR2
517 ,P_AAT_INFORMATION11 in VARCHAR2
518 ,P_AAT_INFORMATION12 in VARCHAR2
519 ,P_AAT_INFORMATION13 in VARCHAR2
520 ,P_AAT_INFORMATION14 in VARCHAR2
521 ,P_AAT_INFORMATION15 in VARCHAR2
522 ,P_AAT_INFORMATION16 in VARCHAR2
523 ,P_AAT_INFORMATION17 in VARCHAR2
524 ,P_AAT_INFORMATION18 in VARCHAR2
525 ,P_AAT_INFORMATION19 in VARCHAR2
526 ,P_AAT_INFORMATION20 in VARCHAR2
527 ,P_LGPS_PROCESS_FLAG in VARCHAR2
531 ,P_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
528 ,P_LGPS_EXCLUSION_TYPE in VARCHAR2
529 ,P_LGPS_PENSIONABLE_PAY in VARCHAR2
530 ,P_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
532 ); -- End of procedure definition for AFTER_INSERT
533
534 --
535 /*
536 ================================================
537 This is a dynamically generated procedure.
538 Will be called by API.
539 ================================================
540 ** DO NOT CHANGE MANUALLY **
541 ------------------------------------------------
542 Name: AFTER_UPDATE
543 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
544 Action: UPDATE
545 Generated Date: 27/11/2012 04:01
546 Description: Called as part of UPDATE process
547 ================================================
548 */
549
550 --
551 PROCEDURE AFTER_UPDATE
552 (
553 P_EFFECTIVE_DATE in DATE
554 ,P_DATETRACK_MODE in VARCHAR2
555 ,P_VALIDATION_START_DATE in DATE
556 ,P_VALIDATION_END_DATE in DATE
557 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
558 ,P_EFFECTIVE_START_DATE in DATE
559 ,P_EFFECTIVE_END_DATE in DATE
560 ,P_BUSINESS_GROUP_ID in NUMBER
561 ,P_ASSIGNMENT_ID in NUMBER
562 ,P_CONTRACT_TYPE in VARCHAR2
563 ,P_WORK_PATTERN in VARCHAR2
564 ,P_START_DAY in VARCHAR2
565 ,P_OBJECT_VERSION_NUMBER in NUMBER
566 ,P_PRIMARY_COMPANY_CAR in NUMBER
567 ,P_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
568 ,P_PRIMARY_CLASS_1A in VARCHAR2
569 ,P_PRIMARY_CAPITAL_CONTRIBUTION in NUMBER
570 ,P_PRIMARY_PRIVATE_CONTRIBUTION in NUMBER
571 ,P_SECONDARY_COMPANY_CAR in NUMBER
572 ,P_SECONDARY_CAR_FUEL_BENEFIT in VARCHAR2
573 ,P_SECONDARY_CLASS_1A in VARCHAR2
574 ,P_SECONDARY_CAPITAL_CONTRIBUTI in NUMBER
575 ,P_SECONDARY_PRIVATE_CONTRIBUTI in NUMBER
576 ,P_COMPANY_CAR_CALC_METHOD in VARCHAR2
577 ,P_COMPANY_CAR_RATES_TABLE_ID in NUMBER
578 ,P_COMPANY_CAR_SECONDARY_TABLE in NUMBER
579 ,P_PRIVATE_CAR in NUMBER
580 ,P_PRIVATE_CAR_CALC_METHOD in VARCHAR2
581 ,P_PRIVATE_CAR_RATES_TABLE_ID in NUMBER
582 ,P_PRIVATE_CAR_ESSENTIAL_TABLE in NUMBER
583 ,P_TP_IS_TEACHER in VARCHAR2
584 ,P_TP_HEADTEACHER_GRP_CODE in NUMBER
585 ,P_TP_SAFEGUARDED_GRADE in VARCHAR2
586 ,P_TP_SAFEGUARDED_GRADE_ID in NUMBER
587 ,P_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
588 ,P_TP_SAFEGUARDED_RATE_ID in NUMBER
589 ,P_TP_SPINAL_POINT_ID in NUMBER
590 ,P_TP_ELECTED_PENSION in VARCHAR2
591 ,P_TP_FAST_TRACK in VARCHAR2
592 ,P_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
593 ,P_AAT_ATTRIBUTE1 in VARCHAR2
594 ,P_AAT_ATTRIBUTE2 in VARCHAR2
595 ,P_AAT_ATTRIBUTE3 in VARCHAR2
596 ,P_AAT_ATTRIBUTE4 in VARCHAR2
597 ,P_AAT_ATTRIBUTE5 in VARCHAR2
598 ,P_AAT_ATTRIBUTE6 in VARCHAR2
599 ,P_AAT_ATTRIBUTE7 in VARCHAR2
600 ,P_AAT_ATTRIBUTE8 in VARCHAR2
601 ,P_AAT_ATTRIBUTE9 in VARCHAR2
602 ,P_AAT_ATTRIBUTE10 in VARCHAR2
603 ,P_AAT_ATTRIBUTE11 in VARCHAR2
604 ,P_AAT_ATTRIBUTE12 in VARCHAR2
605 ,P_AAT_ATTRIBUTE13 in VARCHAR2
606 ,P_AAT_ATTRIBUTE14 in VARCHAR2
607 ,P_AAT_ATTRIBUTE15 in VARCHAR2
608 ,P_AAT_ATTRIBUTE16 in VARCHAR2
609 ,P_AAT_ATTRIBUTE17 in VARCHAR2
610 ,P_AAT_ATTRIBUTE18 in VARCHAR2
611 ,P_AAT_ATTRIBUTE19 in VARCHAR2
612 ,P_AAT_ATTRIBUTE20 in VARCHAR2
613 ,P_AAT_INFORMATION_CATEGORY in VARCHAR2
614 ,P_AAT_INFORMATION1 in VARCHAR2
615 ,P_AAT_INFORMATION2 in VARCHAR2
616 ,P_AAT_INFORMATION3 in VARCHAR2
617 ,P_AAT_INFORMATION4 in VARCHAR2
618 ,P_AAT_INFORMATION5 in VARCHAR2
619 ,P_AAT_INFORMATION6 in VARCHAR2
620 ,P_AAT_INFORMATION7 in VARCHAR2
621 ,P_AAT_INFORMATION8 in VARCHAR2
622 ,P_AAT_INFORMATION9 in VARCHAR2
623 ,P_AAT_INFORMATION10 in VARCHAR2
624 ,P_AAT_INFORMATION11 in VARCHAR2
625 ,P_AAT_INFORMATION12 in VARCHAR2
626 ,P_AAT_INFORMATION13 in VARCHAR2
627 ,P_AAT_INFORMATION14 in VARCHAR2
628 ,P_AAT_INFORMATION15 in VARCHAR2
629 ,P_AAT_INFORMATION16 in VARCHAR2
630 ,P_AAT_INFORMATION17 in VARCHAR2
631 ,P_AAT_INFORMATION18 in VARCHAR2
632 ,P_AAT_INFORMATION19 in VARCHAR2
633 ,P_AAT_INFORMATION20 in VARCHAR2
634 ,P_LGPS_PROCESS_FLAG in VARCHAR2
635 ,P_LGPS_EXCLUSION_TYPE in VARCHAR2
636 ,P_LGPS_PENSIONABLE_PAY in VARCHAR2
640 ,P_EFFECTIVE_END_DATE_O in DATE
637 ,P_LGPS_TRANS_ARRANG_FLAG in VARCHAR2
638 ,P_LGPS_MEMBERSHIP_NUMBER in VARCHAR2
639 ,P_EFFECTIVE_START_DATE_O in DATE
641 ,P_BUSINESS_GROUP_ID_O in NUMBER
642 ,P_ASSIGNMENT_ID_O in NUMBER
643 ,P_CONTRACT_TYPE_O in VARCHAR2
644 ,P_WORK_PATTERN_O in VARCHAR2
645 ,P_START_DAY_O in VARCHAR2
646 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
647 ,P_PRIMARY_COMPANY_CAR_O in NUMBER
648 ,P_PRIMARY_CAR_FUEL_BENEFIT_O in VARCHAR2
649 ,P_PRIMARY_CLASS_1A_O in VARCHAR2
650 ,P_PRIMARY_CAPITAL_CONTRIBUTI_O in NUMBER
651 ,P_PRIMARY_PRIVATE_CONTRIBUTI_O in NUMBER
652 ,P_SECONDARY_COMPANY_CAR_O in NUMBER
653 ,P_SECONDARY_CAR_FUEL_BENEFIT_O in VARCHAR2
654 ,P_SECONDARY_CLASS_1A_O in VARCHAR2
655 ,P_SECONDARY_CAPITAL_CONTRIBU_O in NUMBER
656 ,P_SECONDARY_PRIVATE_CONTRIBU_O in NUMBER
657 ,P_COMPANY_CAR_CALC_METHOD_O in VARCHAR2
658 ,P_COMPANY_CAR_RATES_TABLE_ID_O in NUMBER
659 ,P_COMPANY_CAR_SECONDARY_TABL_O in NUMBER
660 ,P_PRIVATE_CAR_O in NUMBER
661 ,P_PRIVATE_CAR_CALC_METHOD_O in VARCHAR2
662 ,P_PRIVATE_CAR_RATES_TABLE_ID_O in NUMBER
663 ,P_PRIVATE_CAR_ESSENTIAL_TABL_O in NUMBER
664 ,P_TP_IS_TEACHER_O in VARCHAR2
665 ,P_TP_HEADTEACHER_GRP_CODE_O in NUMBER
666 ,P_TP_SAFEGUARDED_GRADE_O in VARCHAR2
667 ,P_TP_SAFEGUARDED_GRADE_ID_O in NUMBER
668 ,P_TP_SAFEGUARDED_RATE_TYPE_O in VARCHAR2
669 ,P_TP_SAFEGUARDED_RATE_ID_O in NUMBER
670 ,P_TP_SPINAL_POINT_ID_O in NUMBER
671 ,P_TP_ELECTED_PENSION_O in VARCHAR2
672 ,P_TP_FAST_TRACK_O in VARCHAR2
673 ,P_AAT_ATTRIBUTE_CATEGORY_O in VARCHAR2
674 ,P_AAT_ATTRIBUTE1_O in VARCHAR2
675 ,P_AAT_ATTRIBUTE2_O in VARCHAR2
676 ,P_AAT_ATTRIBUTE3_O in VARCHAR2
677 ,P_AAT_ATTRIBUTE4_O in VARCHAR2
678 ,P_AAT_ATTRIBUTE5_O in VARCHAR2
679 ,P_AAT_ATTRIBUTE6_O in VARCHAR2
680 ,P_AAT_ATTRIBUTE7_O in VARCHAR2
681 ,P_AAT_ATTRIBUTE8_O in VARCHAR2
682 ,P_AAT_ATTRIBUTE9_O in VARCHAR2
683 ,P_AAT_ATTRIBUTE10_O in VARCHAR2
684 ,P_AAT_ATTRIBUTE11_O in VARCHAR2
685 ,P_AAT_ATTRIBUTE12_O in VARCHAR2
686 ,P_AAT_ATTRIBUTE13_O in VARCHAR2
687 ,P_AAT_ATTRIBUTE14_O in VARCHAR2
688 ,P_AAT_ATTRIBUTE15_O in VARCHAR2
689 ,P_AAT_ATTRIBUTE16_O in VARCHAR2
690 ,P_AAT_ATTRIBUTE17_O in VARCHAR2
691 ,P_AAT_ATTRIBUTE18_O in VARCHAR2
692 ,P_AAT_ATTRIBUTE19_O in VARCHAR2
693 ,P_AAT_ATTRIBUTE20_O in VARCHAR2
694 ,P_AAT_INFORMATION_CATEGORY_O in VARCHAR2
695 ,P_AAT_INFORMATION1_O in VARCHAR2
696 ,P_AAT_INFORMATION2_O in VARCHAR2
697 ,P_AAT_INFORMATION3_O in VARCHAR2
698 ,P_AAT_INFORMATION4_O in VARCHAR2
699 ,P_AAT_INFORMATION5_O in VARCHAR2
700 ,P_AAT_INFORMATION6_O in VARCHAR2
701 ,P_AAT_INFORMATION7_O in VARCHAR2
702 ,P_AAT_INFORMATION8_O in VARCHAR2
703 ,P_AAT_INFORMATION9_O in VARCHAR2
704 ,P_AAT_INFORMATION10_O in VARCHAR2
705 ,P_AAT_INFORMATION11_O in VARCHAR2
706 ,P_AAT_INFORMATION12_O in VARCHAR2
707 ,P_AAT_INFORMATION13_O in VARCHAR2
708 ,P_AAT_INFORMATION14_O in VARCHAR2
709 ,P_AAT_INFORMATION15_O in VARCHAR2
710 ,P_AAT_INFORMATION16_O in VARCHAR2
711 ,P_AAT_INFORMATION17_O in VARCHAR2
712 ,P_AAT_INFORMATION18_O in VARCHAR2
713 ,P_AAT_INFORMATION19_O in VARCHAR2
714 ,P_AAT_INFORMATION20_O in VARCHAR2
715 ,P_LGPS_PROCESS_FLAG_O in VARCHAR2
716 ,P_LGPS_EXCLUSION_TYPE_O in VARCHAR2
717 ,P_LGPS_PENSIONABLE_PAY_O in VARCHAR2
718 ,P_LGPS_TRANS_ARRANG_FLAG_O in VARCHAR2
719 ,P_LGPS_MEMBERSHIP_NUMBER_O in VARCHAR2
720 ); -- End of procedure definition for AFTER_UPDATE
721
722 --
723 /*
724 ================================================
725 This is a dynamically generated procedure.
726 Will be called by API.
727 ================================================
728 ** DO NOT CHANGE MANUALLY **
729 ------------------------------------------------
730 Name: AFTER_DELETE
731 Table: PQP_ASSIGNMENT_ATTRIBUTES_F
732 Action: DELETE
733 Generated Date: 27/11/2012 04:01
734 Description: Called as part of DELETE process
735 ================================================
736 */
737
738 --
739 PROCEDURE AFTER_DELETE
740 (
741 P_EFFECTIVE_DATE in DATE
745 ,P_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
742 ,P_DATETRACK_MODE in VARCHAR2
743 ,P_VALIDATION_START_DATE in DATE
744 ,P_VALIDATION_END_DATE in DATE
746 ,P_EFFECTIVE_START_DATE in DATE
747 ,P_EFFECTIVE_END_DATE in DATE
748 ,P_EFFECTIVE_START_DATE_O in DATE
749 ,P_EFFECTIVE_END_DATE_O in DATE
750 ,P_BUSINESS_GROUP_ID_O in NUMBER
751 ,P_ASSIGNMENT_ID_O in NUMBER
752 ,P_CONTRACT_TYPE_O in VARCHAR2
753 ,P_WORK_PATTERN_O in VARCHAR2
754 ,P_START_DAY_O in VARCHAR2
755 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
756 ,P_PRIMARY_COMPANY_CAR_O in NUMBER
757 ,P_PRIMARY_CAR_FUEL_BENEFIT_O in VARCHAR2
758 ,P_PRIMARY_CLASS_1A_O in VARCHAR2
759 ,P_PRIMARY_CAPITAL_CONTRIBUTI_O in NUMBER
760 ,P_PRIMARY_PRIVATE_CONTRIBUTI_O in NUMBER
761 ,P_SECONDARY_COMPANY_CAR_O in NUMBER
762 ,P_SECONDARY_CAR_FUEL_BENEFIT_O in VARCHAR2
763 ,P_SECONDARY_CLASS_1A_O in VARCHAR2
764 ,P_SECONDARY_CAPITAL_CONTRIBU_O in NUMBER
765 ,P_SECONDARY_PRIVATE_CONTRIBU_O in NUMBER
766 ,P_COMPANY_CAR_CALC_METHOD_O in VARCHAR2
767 ,P_COMPANY_CAR_RATES_TABLE_ID_O in NUMBER
768 ,P_COMPANY_CAR_SECONDARY_TABL_O in NUMBER
769 ,P_PRIVATE_CAR_O in NUMBER
770 ,P_PRIVATE_CAR_CALC_METHOD_O in VARCHAR2
771 ,P_PRIVATE_CAR_RATES_TABLE_ID_O in NUMBER
772 ,P_PRIVATE_CAR_ESSENTIAL_TABL_O in NUMBER
773 ,P_TP_IS_TEACHER_O in VARCHAR2
774 ,P_TP_HEADTEACHER_GRP_CODE_O in NUMBER
775 ,P_TP_SAFEGUARDED_GRADE_O in VARCHAR2
776 ,P_TP_SAFEGUARDED_GRADE_ID_O in NUMBER
777 ,P_TP_SAFEGUARDED_RATE_TYPE_O in VARCHAR2
778 ,P_TP_SAFEGUARDED_RATE_ID_O in NUMBER
779 ,P_TP_SPINAL_POINT_ID_O in NUMBER
780 ,P_TP_ELECTED_PENSION_O in VARCHAR2
781 ,P_TP_FAST_TRACK_O in VARCHAR2
782 ,P_AAT_ATTRIBUTE_CATEGORY_O in VARCHAR2
783 ,P_AAT_ATTRIBUTE1_O in VARCHAR2
784 ,P_AAT_ATTRIBUTE2_O in VARCHAR2
785 ,P_AAT_ATTRIBUTE3_O in VARCHAR2
786 ,P_AAT_ATTRIBUTE4_O in VARCHAR2
787 ,P_AAT_ATTRIBUTE5_O in VARCHAR2
788 ,P_AAT_ATTRIBUTE6_O in VARCHAR2
789 ,P_AAT_ATTRIBUTE7_O in VARCHAR2
790 ,P_AAT_ATTRIBUTE8_O in VARCHAR2
791 ,P_AAT_ATTRIBUTE9_O in VARCHAR2
792 ,P_AAT_ATTRIBUTE10_O in VARCHAR2
793 ,P_AAT_ATTRIBUTE11_O in VARCHAR2
794 ,P_AAT_ATTRIBUTE12_O in VARCHAR2
795 ,P_AAT_ATTRIBUTE13_O in VARCHAR2
796 ,P_AAT_ATTRIBUTE14_O in VARCHAR2
797 ,P_AAT_ATTRIBUTE15_O in VARCHAR2
798 ,P_AAT_ATTRIBUTE16_O in VARCHAR2
799 ,P_AAT_ATTRIBUTE17_O in VARCHAR2
800 ,P_AAT_ATTRIBUTE18_O in VARCHAR2
801 ,P_AAT_ATTRIBUTE19_O in VARCHAR2
802 ,P_AAT_ATTRIBUTE20_O in VARCHAR2
803 ,P_AAT_INFORMATION_CATEGORY_O in VARCHAR2
804 ,P_AAT_INFORMATION1_O in VARCHAR2
805 ,P_AAT_INFORMATION2_O in VARCHAR2
806 ,P_AAT_INFORMATION3_O in VARCHAR2
807 ,P_AAT_INFORMATION4_O in VARCHAR2
808 ,P_AAT_INFORMATION5_O in VARCHAR2
809 ,P_AAT_INFORMATION6_O in VARCHAR2
810 ,P_AAT_INFORMATION7_O in VARCHAR2
811 ,P_AAT_INFORMATION8_O in VARCHAR2
812 ,P_AAT_INFORMATION9_O in VARCHAR2
813 ,P_AAT_INFORMATION10_O in VARCHAR2
814 ,P_AAT_INFORMATION11_O in VARCHAR2
815 ,P_AAT_INFORMATION12_O in VARCHAR2
816 ,P_AAT_INFORMATION13_O in VARCHAR2
817 ,P_AAT_INFORMATION14_O in VARCHAR2
818 ,P_AAT_INFORMATION15_O in VARCHAR2
819 ,P_AAT_INFORMATION16_O in VARCHAR2
820 ,P_AAT_INFORMATION17_O in VARCHAR2
821 ,P_AAT_INFORMATION18_O in VARCHAR2
822 ,P_AAT_INFORMATION19_O in VARCHAR2
823 ,P_AAT_INFORMATION20_O in VARCHAR2
824 ,P_LGPS_PROCESS_FLAG_O in VARCHAR2
825 ,P_LGPS_EXCLUSION_TYPE_O in VARCHAR2
826 ,P_LGPS_PENSIONABLE_PAY_O in VARCHAR2
827 ,P_LGPS_TRANS_ARRANG_FLAG_O in VARCHAR2
828 ,P_LGPS_MEMBERSHIP_NUMBER_O in VARCHAR2
829 ); -- End of procedure definition for AFTER_DELETE
830
831 --
832 END PAY_DYT_ASSIGNMENT_ATTRIB_PKG;
[Home] [Help]