1 package PAY_DYT_CONTRACTS_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_CONTRACTS_PKG
20 Base Table: PER_CONTRACTS_F
21 Date: 30/12/2011 01:21
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: PER_CONTRACTS_F_ARU_ARU
34 Table: PER_CONTRACTS_F
35 Action: Update
36 Generated Date: 30/12/2011 01:21
37 Description: Continuous Calculation trigger on update of PER_CONTRACTS_F
38 Full trigger name: PER_CONTRACTS_F_ARU
39 ================================================
40 */
41 --
42 PROCEDURE PER_CONTRACTS_F_ARU_ARU
43 (
44 p_new_ATTRIBUTE1 in VARCHAR2
45 ,p_new_ATTRIBUTE10 in VARCHAR2
46 ,p_new_ATTRIBUTE11 in VARCHAR2
47 ,p_new_ATTRIBUTE12 in VARCHAR2
48 ,p_new_ATTRIBUTE13 in VARCHAR2
49 ,p_new_ATTRIBUTE14 in VARCHAR2
50 ,p_new_ATTRIBUTE15 in VARCHAR2
51 ,p_new_ATTRIBUTE16 in VARCHAR2
52 ,p_new_ATTRIBUTE17 in VARCHAR2
53 ,p_new_ATTRIBUTE18 in VARCHAR2
54 ,p_new_ATTRIBUTE19 in VARCHAR2
55 ,p_new_ATTRIBUTE2 in VARCHAR2
56 ,p_new_ATTRIBUTE20 in VARCHAR2
57 ,p_new_ATTRIBUTE3 in VARCHAR2
58 ,p_new_ATTRIBUTE4 in VARCHAR2
59 ,p_new_ATTRIBUTE5 in VARCHAR2
60 ,p_new_ATTRIBUTE6 in VARCHAR2
61 ,p_new_ATTRIBUTE7 in VARCHAR2
62 ,p_new_ATTRIBUTE8 in VARCHAR2
63 ,p_new_ATTRIBUTE9 in VARCHAR2
64 ,p_new_ATTRIBUTE_CATEGORY in VARCHAR2
65 ,p_new_CONTRACTUAL_JOB_TITLE in VARCHAR2
66 ,p_new_CONTRACT_ID in NUMBER
67 ,p_new_CTR_INFORMATION1 in VARCHAR2
68 ,p_new_CTR_INFORMATION10 in VARCHAR2
69 ,p_new_CTR_INFORMATION11 in VARCHAR2
70 ,p_new_CTR_INFORMATION12 in VARCHAR2
71 ,p_new_CTR_INFORMATION13 in VARCHAR2
72 ,p_new_CTR_INFORMATION14 in VARCHAR2
73 ,p_new_CTR_INFORMATION15 in VARCHAR2
74 ,p_new_CTR_INFORMATION16 in VARCHAR2
75 ,p_new_CTR_INFORMATION17 in VARCHAR2
76 ,p_new_CTR_INFORMATION18 in VARCHAR2
77 ,p_new_CTR_INFORMATION19 in VARCHAR2
78 ,p_new_CTR_INFORMATION2 in VARCHAR2
79 ,p_new_CTR_INFORMATION20 in VARCHAR2
80 ,p_new_CTR_INFORMATION3 in VARCHAR2
81 ,p_new_CTR_INFORMATION4 in VARCHAR2
82 ,p_new_CTR_INFORMATION5 in VARCHAR2
83 ,p_new_CTR_INFORMATION6 in VARCHAR2
84 ,p_new_CTR_INFORMATION7 in VARCHAR2
85 ,p_new_CTR_INFORMATION8 in VARCHAR2
86 ,p_new_CTR_INFORMATION9 in VARCHAR2
87 ,p_new_CTR_INFORMATION_CATEGORY in VARCHAR2
88 ,p_new_DESCRIPTION in VARCHAR2
89 ,p_new_DOC_STATUS in VARCHAR2
90 ,p_new_DOC_STATUS_CHANGE_DATE in DATE
91 ,p_new_DURATION in NUMBER
92 ,p_new_DURATION_UNITS in VARCHAR2
93 ,p_new_EFFECTIVE_END_DATE in DATE
94 ,p_new_EFFECTIVE_START_DATE in DATE
95 ,p_new_END_REASON in VARCHAR2
96 ,p_new_EXTENSION_PERIOD in NUMBER
97 ,p_new_EXTENSION_PERIOD_UNITS in VARCHAR2
98 ,p_new_EXTENSION_REASON in VARCHAR2
99 ,p_new_NUMBER_OF_EXTENSIONS in NUMBER
100 ,p_new_PARTIES in VARCHAR2
101 ,p_new_REFERENCE in VARCHAR2
102 ,p_new_START_REASON in VARCHAR2
103 ,p_new_STATUS in VARCHAR2
104 ,p_new_STATUS_REASON in VARCHAR2
105 ,p_new_TYPE in VARCHAR2
106 ,p_old_ATTRIBUTE1 in VARCHAR2
107 ,p_old_ATTRIBUTE10 in VARCHAR2
108 ,p_old_ATTRIBUTE11 in VARCHAR2
109 ,p_old_ATTRIBUTE12 in VARCHAR2
110 ,p_old_ATTRIBUTE13 in VARCHAR2
111 ,p_old_ATTRIBUTE14 in VARCHAR2
112 ,p_old_ATTRIBUTE15 in VARCHAR2
113 ,p_old_ATTRIBUTE16 in VARCHAR2
114 ,p_old_ATTRIBUTE17 in VARCHAR2
115 ,p_old_ATTRIBUTE18 in VARCHAR2
116 ,p_old_ATTRIBUTE19 in VARCHAR2
117 ,p_old_ATTRIBUTE2 in VARCHAR2
118 ,p_old_ATTRIBUTE20 in VARCHAR2
119 ,p_old_ATTRIBUTE3 in VARCHAR2
120 ,p_old_ATTRIBUTE4 in VARCHAR2
121 ,p_old_ATTRIBUTE5 in VARCHAR2
122 ,p_old_ATTRIBUTE6 in VARCHAR2
123 ,p_old_ATTRIBUTE7 in VARCHAR2
124 ,p_old_ATTRIBUTE8 in VARCHAR2
125 ,p_old_ATTRIBUTE9 in VARCHAR2
126 ,p_old_ATTRIBUTE_CATEGORY in VARCHAR2
127 ,p_old_BUSINESS_GROUP_ID in NUMBER
128 ,p_old_CONTRACTUAL_JOB_TITLE in VARCHAR2
129 ,p_old_CTR_INFORMATION1 in VARCHAR2
130 ,p_old_CTR_INFORMATION10 in VARCHAR2
131 ,p_old_CTR_INFORMATION11 in VARCHAR2
132 ,p_old_CTR_INFORMATION12 in VARCHAR2
133 ,p_old_CTR_INFORMATION13 in VARCHAR2
134 ,p_old_CTR_INFORMATION14 in VARCHAR2
135 ,p_old_CTR_INFORMATION15 in VARCHAR2
136 ,p_old_CTR_INFORMATION16 in VARCHAR2
137 ,p_old_CTR_INFORMATION17 in VARCHAR2
138 ,p_old_CTR_INFORMATION18 in VARCHAR2
139 ,p_old_CTR_INFORMATION19 in VARCHAR2
140 ,p_old_CTR_INFORMATION2 in VARCHAR2
141 ,p_old_CTR_INFORMATION20 in VARCHAR2
142 ,p_old_CTR_INFORMATION3 in VARCHAR2
143 ,p_old_CTR_INFORMATION4 in VARCHAR2
144 ,p_old_CTR_INFORMATION5 in VARCHAR2
145 ,p_old_CTR_INFORMATION6 in VARCHAR2
146 ,p_old_CTR_INFORMATION7 in VARCHAR2
147 ,p_old_CTR_INFORMATION8 in VARCHAR2
148 ,p_old_CTR_INFORMATION9 in VARCHAR2
149 ,p_old_CTR_INFORMATION_CATEGORY in VARCHAR2
150 ,p_old_DESCRIPTION in VARCHAR2
151 ,p_old_DOC_STATUS in VARCHAR2
152 ,p_old_DOC_STATUS_CHANGE_DATE in DATE
153 ,p_old_DURATION in NUMBER
154 ,p_old_DURATION_UNITS in VARCHAR2
155 ,p_old_EFFECTIVE_END_DATE in DATE
156 ,p_old_EFFECTIVE_START_DATE in DATE
157 ,p_old_END_REASON in VARCHAR2
158 ,p_old_EXTENSION_PERIOD in NUMBER
159 ,p_old_EXTENSION_PERIOD_UNITS in VARCHAR2
160 ,p_old_EXTENSION_REASON in VARCHAR2
161 ,p_old_NUMBER_OF_EXTENSIONS in NUMBER
162 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
163 ,p_old_PARTIES in VARCHAR2
164 ,p_old_PERSON_ID in NUMBER
165 ,p_old_REFERENCE in VARCHAR2
166 ,p_old_START_REASON in VARCHAR2
167 ,p_old_STATUS in VARCHAR2
168 ,p_old_STATUS_REASON in VARCHAR2
169 ,p_old_TYPE in VARCHAR2
170 ); -- End of procedure definition for PER_CONTRACTS_F_ARU_ARU
171
172 --
173 /*
174 ================================================
175 This is a dynamically generated procedure.
176 Will be called by API.
177 ================================================
178 ** DO NOT CHANGE MANUALLY **
179 ------------------------------------------------
180 Name: AFTER_INSERT
181 Table: PER_CONTRACTS_F
182 Action: INSERT
183 Generated Date: 30/12/2011 01:21
184 Description: Called as part of INSERT process
185 ================================================
186 */
187
188 --
189 PROCEDURE AFTER_INSERT
190 (
191 P_CONTRACT_ID in NUMBER
192 ,P_EFFECTIVE_START_DATE in DATE
193 ,P_EFFECTIVE_END_DATE in DATE
194 ,P_BUSINESS_GROUP_ID in NUMBER
195 ,P_OBJECT_VERSION_NUMBER in NUMBER
196 ,P_PERSON_ID in NUMBER
197 ,P_REFERENCE in VARCHAR2
198 ,P_TYPE in VARCHAR2
199 ,P_STATUS in VARCHAR2
200 ,P_STATUS_REASON in VARCHAR2
201 ,P_DOC_STATUS in VARCHAR2
202 ,P_DOC_STATUS_CHANGE_DATE in DATE
203 ,P_DESCRIPTION in VARCHAR2
204 ,P_DURATION in NUMBER
205 ,P_DURATION_UNITS in VARCHAR2
206 ,P_CONTRACTUAL_JOB_TITLE in VARCHAR2
207 ,P_PARTIES in VARCHAR2
208 ,P_START_REASON in VARCHAR2
209 ,P_END_REASON in VARCHAR2
210 ,P_NUMBER_OF_EXTENSIONS in NUMBER
211 ,P_EXTENSION_REASON in VARCHAR2
212 ,P_EXTENSION_PERIOD in NUMBER
213 ,P_EXTENSION_PERIOD_UNITS in VARCHAR2
214 ,P_CTR_INFORMATION_CATEGORY in VARCHAR2
215 ,P_CTR_INFORMATION1 in VARCHAR2
216 ,P_CTR_INFORMATION2 in VARCHAR2
217 ,P_CTR_INFORMATION3 in VARCHAR2
218 ,P_CTR_INFORMATION4 in VARCHAR2
219 ,P_CTR_INFORMATION5 in VARCHAR2
220 ,P_CTR_INFORMATION6 in VARCHAR2
221 ,P_CTR_INFORMATION7 in VARCHAR2
222 ,P_CTR_INFORMATION8 in VARCHAR2
223 ,P_CTR_INFORMATION9 in VARCHAR2
224 ,P_CTR_INFORMATION10 in VARCHAR2
225 ,P_CTR_INFORMATION11 in VARCHAR2
226 ,P_CTR_INFORMATION12 in VARCHAR2
227 ,P_CTR_INFORMATION13 in VARCHAR2
228 ,P_CTR_INFORMATION14 in VARCHAR2
229 ,P_CTR_INFORMATION15 in VARCHAR2
230 ,P_CTR_INFORMATION16 in VARCHAR2
231 ,P_CTR_INFORMATION17 in VARCHAR2
232 ,P_CTR_INFORMATION18 in VARCHAR2
233 ,P_CTR_INFORMATION19 in VARCHAR2
234 ,P_CTR_INFORMATION20 in VARCHAR2
235 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
236 ,P_ATTRIBUTE1 in VARCHAR2
237 ,P_ATTRIBUTE2 in VARCHAR2
238 ,P_ATTRIBUTE3 in VARCHAR2
239 ,P_ATTRIBUTE4 in VARCHAR2
240 ,P_ATTRIBUTE5 in VARCHAR2
241 ,P_ATTRIBUTE6 in VARCHAR2
242 ,P_ATTRIBUTE7 in VARCHAR2
243 ,P_ATTRIBUTE8 in VARCHAR2
244 ,P_ATTRIBUTE9 in VARCHAR2
245 ,P_ATTRIBUTE10 in VARCHAR2
246 ,P_ATTRIBUTE11 in VARCHAR2
247 ,P_ATTRIBUTE12 in VARCHAR2
248 ,P_ATTRIBUTE13 in VARCHAR2
249 ,P_ATTRIBUTE14 in VARCHAR2
250 ,P_ATTRIBUTE15 in VARCHAR2
251 ,P_ATTRIBUTE16 in VARCHAR2
252 ,P_ATTRIBUTE17 in VARCHAR2
253 ,P_ATTRIBUTE18 in VARCHAR2
254 ,P_ATTRIBUTE19 in VARCHAR2
255 ,P_ATTRIBUTE20 in VARCHAR2
256 ,P_EFFECTIVE_DATE in DATE
257 ,P_VALIDATION_START_DATE in DATE
258 ,P_VALIDATION_END_DATE in DATE
259 ); -- End of procedure definition for AFTER_INSERT
260
261 --
262 /*
263 ================================================
264 This is a dynamically generated procedure.
265 Will be called by API.
266 ================================================
267 ** DO NOT CHANGE MANUALLY **
268 ------------------------------------------------
269 Name: AFTER_UPDATE
270 Table: PER_CONTRACTS_F
271 Action: UPDATE
272 Generated Date: 30/12/2011 01:21
273 Description: Called as part of UPDATE process
274 ================================================
275 */
276
277 --
278 PROCEDURE AFTER_UPDATE
279 (
280 P_CONTRACT_ID in NUMBER
281 ,P_EFFECTIVE_START_DATE in DATE
282 ,P_EFFECTIVE_END_DATE in DATE
283 ,P_REFERENCE in VARCHAR2
284 ,P_TYPE in VARCHAR2
285 ,P_STATUS in VARCHAR2
286 ,P_STATUS_REASON in VARCHAR2
287 ,P_DOC_STATUS in VARCHAR2
288 ,P_DOC_STATUS_CHANGE_DATE in DATE
289 ,P_DESCRIPTION in VARCHAR2
290 ,P_DURATION in NUMBER
291 ,P_DURATION_UNITS in VARCHAR2
292 ,P_CONTRACTUAL_JOB_TITLE in VARCHAR2
293 ,P_PARTIES in VARCHAR2
294 ,P_START_REASON in VARCHAR2
295 ,P_END_REASON in VARCHAR2
296 ,P_NUMBER_OF_EXTENSIONS in NUMBER
297 ,P_EXTENSION_REASON in VARCHAR2
298 ,P_EXTENSION_PERIOD in NUMBER
299 ,P_EXTENSION_PERIOD_UNITS in VARCHAR2
300 ,P_CTR_INFORMATION_CATEGORY in VARCHAR2
301 ,P_CTR_INFORMATION1 in VARCHAR2
302 ,P_CTR_INFORMATION2 in VARCHAR2
303 ,P_CTR_INFORMATION3 in VARCHAR2
304 ,P_CTR_INFORMATION4 in VARCHAR2
305 ,P_CTR_INFORMATION5 in VARCHAR2
306 ,P_CTR_INFORMATION6 in VARCHAR2
307 ,P_CTR_INFORMATION7 in VARCHAR2
308 ,P_CTR_INFORMATION8 in VARCHAR2
309 ,P_CTR_INFORMATION9 in VARCHAR2
310 ,P_CTR_INFORMATION10 in VARCHAR2
311 ,P_CTR_INFORMATION11 in VARCHAR2
312 ,P_CTR_INFORMATION12 in VARCHAR2
313 ,P_CTR_INFORMATION13 in VARCHAR2
314 ,P_CTR_INFORMATION14 in VARCHAR2
315 ,P_CTR_INFORMATION15 in VARCHAR2
316 ,P_CTR_INFORMATION16 in VARCHAR2
317 ,P_CTR_INFORMATION17 in VARCHAR2
321 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
318 ,P_CTR_INFORMATION18 in VARCHAR2
319 ,P_CTR_INFORMATION19 in VARCHAR2
320 ,P_CTR_INFORMATION20 in VARCHAR2
322 ,P_ATTRIBUTE1 in VARCHAR2
323 ,P_ATTRIBUTE2 in VARCHAR2
324 ,P_ATTRIBUTE3 in VARCHAR2
325 ,P_ATTRIBUTE4 in VARCHAR2
326 ,P_ATTRIBUTE5 in VARCHAR2
327 ,P_ATTRIBUTE6 in VARCHAR2
328 ,P_ATTRIBUTE7 in VARCHAR2
329 ,P_ATTRIBUTE8 in VARCHAR2
330 ,P_ATTRIBUTE9 in VARCHAR2
331 ,P_ATTRIBUTE10 in VARCHAR2
332 ,P_ATTRIBUTE11 in VARCHAR2
333 ,P_ATTRIBUTE12 in VARCHAR2
334 ,P_ATTRIBUTE13 in VARCHAR2
335 ,P_ATTRIBUTE14 in VARCHAR2
336 ,P_ATTRIBUTE15 in VARCHAR2
337 ,P_ATTRIBUTE16 in VARCHAR2
338 ,P_ATTRIBUTE17 in VARCHAR2
339 ,P_ATTRIBUTE18 in VARCHAR2
340 ,P_ATTRIBUTE19 in VARCHAR2
341 ,P_ATTRIBUTE20 in VARCHAR2
342 ,P_EFFECTIVE_DATE in DATE
343 ,P_DATETRACK_MODE in VARCHAR2
344 ,P_VALIDATION_START_DATE in DATE
345 ,P_VALIDATION_END_DATE in DATE
346 ,P_BUSINESS_GROUP_ID_O in NUMBER
347 ,P_PERSON_ID_O in NUMBER
348 ,P_REFERENCE_O in VARCHAR2
349 ,P_TYPE_O in VARCHAR2
350 ,P_STATUS_O in VARCHAR2
351 ,P_STATUS_REASON_O in VARCHAR2
352 ,P_DOC_STATUS_O in VARCHAR2
353 ,P_DOC_STATUS_CHANGE_DATE_O in DATE
354 ,P_DESCRIPTION_O in VARCHAR2
355 ,P_DURATION_O in NUMBER
356 ,P_DURATION_UNITS_O in VARCHAR2
357 ,P_CONTRACTUAL_JOB_TITLE_O in VARCHAR2
358 ,P_PARTIES_O in VARCHAR2
359 ,P_START_REASON_O in VARCHAR2
360 ,P_END_REASON_O in VARCHAR2
361 ,P_NUMBER_OF_EXTENSIONS_O in NUMBER
362 ,P_EXTENSION_REASON_O in VARCHAR2
363 ,P_EXTENSION_PERIOD_O in NUMBER
364 ,P_EXTENSION_PERIOD_UNITS_O in VARCHAR2
365 ,P_CTR_INFORMATION_CATEGORY_O in VARCHAR2
366 ,P_CTR_INFORMATION1_O in VARCHAR2
367 ,P_CTR_INFORMATION2_O in VARCHAR2
368 ,P_CTR_INFORMATION3_O in VARCHAR2
369 ,P_CTR_INFORMATION4_O in VARCHAR2
370 ,P_CTR_INFORMATION5_O in VARCHAR2
371 ,P_CTR_INFORMATION6_O in VARCHAR2
372 ,P_CTR_INFORMATION7_O in VARCHAR2
373 ,P_CTR_INFORMATION8_O in VARCHAR2
374 ,P_CTR_INFORMATION9_O in VARCHAR2
375 ,P_CTR_INFORMATION10_O in VARCHAR2
376 ,P_CTR_INFORMATION11_O in VARCHAR2
377 ,P_CTR_INFORMATION12_O in VARCHAR2
378 ,P_CTR_INFORMATION13_O in VARCHAR2
379 ,P_CTR_INFORMATION14_O in VARCHAR2
380 ,P_CTR_INFORMATION15_O in VARCHAR2
381 ,P_CTR_INFORMATION16_O in VARCHAR2
382 ,P_CTR_INFORMATION17_O in VARCHAR2
383 ,P_CTR_INFORMATION18_O in VARCHAR2
384 ,P_CTR_INFORMATION19_O in VARCHAR2
385 ,P_CTR_INFORMATION20_O in VARCHAR2
386 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
387 ,P_ATTRIBUTE1_O in VARCHAR2
388 ,P_ATTRIBUTE2_O in VARCHAR2
389 ,P_ATTRIBUTE3_O in VARCHAR2
390 ,P_ATTRIBUTE4_O in VARCHAR2
391 ,P_ATTRIBUTE5_O in VARCHAR2
392 ,P_ATTRIBUTE6_O in VARCHAR2
393 ,P_ATTRIBUTE7_O in VARCHAR2
394 ,P_ATTRIBUTE8_O in VARCHAR2
395 ,P_ATTRIBUTE9_O in VARCHAR2
396 ,P_ATTRIBUTE10_O in VARCHAR2
397 ,P_ATTRIBUTE11_O in VARCHAR2
398 ,P_ATTRIBUTE12_O in VARCHAR2
399 ,P_ATTRIBUTE13_O in VARCHAR2
400 ,P_ATTRIBUTE14_O in VARCHAR2
401 ,P_ATTRIBUTE15_O in VARCHAR2
402 ,P_ATTRIBUTE16_O in VARCHAR2
403 ,P_ATTRIBUTE17_O in VARCHAR2
404 ,P_ATTRIBUTE18_O in VARCHAR2
405 ,P_ATTRIBUTE19_O in VARCHAR2
406 ,P_ATTRIBUTE20_O in VARCHAR2
407 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
408 ,P_EFFECTIVE_START_DATE_O in DATE
409 ,P_EFFECTIVE_END_DATE_O in DATE
410 ); -- End of procedure definition for AFTER_UPDATE
411
412 --
413 /*
414 ================================================
415 This is a dynamically generated procedure.
419 ------------------------------------------------
416 Will be called by API.
417 ================================================
418 ** DO NOT CHANGE MANUALLY **
420 Name: AFTER_DELETE
421 Table: PER_CONTRACTS_F
422 Action: DELETE
423 Generated Date: 30/12/2011 01:21
424 Description: Called as part of DELETE process
425 ================================================
426 */
427
428 --
429 PROCEDURE AFTER_DELETE
430 (
431 P_EFFECTIVE_DATE in DATE
432 ,P_DATETRACK_MODE in VARCHAR2
433 ,P_VALIDATION_START_DATE in DATE
434 ,P_VALIDATION_END_DATE in DATE
435 ,P_CONTRACT_ID in NUMBER
436 ,P_EFFECTIVE_START_DATE in DATE
437 ,P_EFFECTIVE_END_DATE in DATE
438 ,P_OBJECT_VERSION_NUMBER in NUMBER
439 ,P_EFFECTIVE_START_DATE_O in DATE
440 ,P_EFFECTIVE_END_DATE_O in DATE
441 ,P_BUSINESS_GROUP_ID_O in NUMBER
442 ,P_PERSON_ID_O in NUMBER
443 ,P_REFERENCE_O in VARCHAR2
444 ,P_TYPE_O in VARCHAR2
445 ,P_STATUS_O in VARCHAR2
446 ,P_STATUS_REASON_O in VARCHAR2
447 ,P_DOC_STATUS_O in VARCHAR2
448 ,P_DOC_STATUS_CHANGE_DATE_O in DATE
449 ,P_DESCRIPTION_O in VARCHAR2
450 ,P_DURATION_O in NUMBER
451 ,P_DURATION_UNITS_O in VARCHAR2
452 ,P_CONTRACTUAL_JOB_TITLE_O in VARCHAR2
453 ,P_PARTIES_O in VARCHAR2
454 ,P_START_REASON_O in VARCHAR2
455 ,P_END_REASON_O in VARCHAR2
456 ,P_NUMBER_OF_EXTENSIONS_O in NUMBER
457 ,P_EXTENSION_REASON_O in VARCHAR2
458 ,P_EXTENSION_PERIOD_O in NUMBER
459 ,P_EXTENSION_PERIOD_UNITS_O in VARCHAR2
460 ,P_CTR_INFORMATION_CATEGORY_O in VARCHAR2
461 ,P_CTR_INFORMATION1_O in VARCHAR2
462 ,P_CTR_INFORMATION2_O in VARCHAR2
463 ,P_CTR_INFORMATION3_O in VARCHAR2
464 ,P_CTR_INFORMATION4_O in VARCHAR2
465 ,P_CTR_INFORMATION5_O in VARCHAR2
466 ,P_CTR_INFORMATION6_O in VARCHAR2
467 ,P_CTR_INFORMATION7_O in VARCHAR2
468 ,P_CTR_INFORMATION8_O in VARCHAR2
469 ,P_CTR_INFORMATION9_O in VARCHAR2
470 ,P_CTR_INFORMATION10_O in VARCHAR2
471 ,P_CTR_INFORMATION11_O in VARCHAR2
472 ,P_CTR_INFORMATION12_O in VARCHAR2
473 ,P_CTR_INFORMATION13_O in VARCHAR2
474 ,P_CTR_INFORMATION14_O in VARCHAR2
475 ,P_CTR_INFORMATION15_O in VARCHAR2
476 ,P_CTR_INFORMATION16_O in VARCHAR2
477 ,P_CTR_INFORMATION17_O in VARCHAR2
478 ,P_CTR_INFORMATION18_O in VARCHAR2
479 ,P_CTR_INFORMATION19_O in VARCHAR2
480 ,P_CTR_INFORMATION20_O in VARCHAR2
481 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
482 ,P_ATTRIBUTE1_O in VARCHAR2
483 ,P_ATTRIBUTE2_O in VARCHAR2
484 ,P_ATTRIBUTE3_O in VARCHAR2
485 ,P_ATTRIBUTE4_O in VARCHAR2
486 ,P_ATTRIBUTE5_O in VARCHAR2
487 ,P_ATTRIBUTE6_O in VARCHAR2
488 ,P_ATTRIBUTE7_O in VARCHAR2
489 ,P_ATTRIBUTE8_O in VARCHAR2
490 ,P_ATTRIBUTE9_O in VARCHAR2
491 ,P_ATTRIBUTE10_O in VARCHAR2
492 ,P_ATTRIBUTE11_O in VARCHAR2
493 ,P_ATTRIBUTE12_O in VARCHAR2
494 ,P_ATTRIBUTE13_O in VARCHAR2
495 ,P_ATTRIBUTE14_O in VARCHAR2
496 ,P_ATTRIBUTE15_O in VARCHAR2
497 ,P_ATTRIBUTE16_O in VARCHAR2
498 ,P_ATTRIBUTE17_O in VARCHAR2
499 ,P_ATTRIBUTE18_O in VARCHAR2
500 ,P_ATTRIBUTE19_O in VARCHAR2
501 ,P_ATTRIBUTE20_O in VARCHAR2
502 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
503 ); -- End of procedure definition for AFTER_DELETE
504
505 --
506 END PAY_DYT_CONTRACTS_PKG;