1 package PAY_DYT_ELEMENT_ENTRIES_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_ELEMENT_ENTRIES_PKG
20 Base Table: PAY_ELEMENT_ENTRIES_F
21 Date: 30/03/2009 04:53
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: PAY_ELEMENT_ENTRIES_F_ARU_ARU
34 Table: PAY_ELEMENT_ENTRIES_F
35 Action: Update
36 Generated Date: 30/03/2009 04:53
37 Description: Continuous Calculation trigger on update element entry
38 Full trigger name: PAY_ELEMENT_ENTRIES_F_ARU
39 ================================================
40 */
41 --
42 PROCEDURE PAY_ELEMENT_ENTRIES_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_BALANCE_ADJ_COST_FLAG in VARCHAR2
66 ,p_new_COMMENTS in VARCHAR2
67 ,p_new_COMMENT_ID in NUMBER
68 ,p_new_COST_ALLOCATION_KEYFLEX_ in NUMBER
69 ,p_new_CREATOR_ID in NUMBER
70 ,p_new_CREATOR_TYPE in VARCHAR2
71 ,p_new_DATE_EARNED in DATE
72 ,p_new_EFFECTIVE_END_DATE in DATE
73 ,p_new_EFFECTIVE_START_DATE in DATE
74 ,p_new_ELEMENT_ENTRY_ID in NUMBER
75 ,p_new_ENTRY_INFORMATION1 in VARCHAR2
76 ,p_new_ENTRY_INFORMATION10 in VARCHAR2
77 ,p_new_ENTRY_INFORMATION11 in VARCHAR2
78 ,p_new_ENTRY_INFORMATION12 in VARCHAR2
79 ,p_new_ENTRY_INFORMATION13 in VARCHAR2
80 ,p_new_ENTRY_INFORMATION14 in VARCHAR2
81 ,p_new_ENTRY_INFORMATION15 in VARCHAR2
82 ,p_new_ENTRY_INFORMATION16 in VARCHAR2
83 ,p_new_ENTRY_INFORMATION17 in VARCHAR2
84 ,p_new_ENTRY_INFORMATION18 in VARCHAR2
85 ,p_new_ENTRY_INFORMATION19 in VARCHAR2
86 ,p_new_ENTRY_INFORMATION2 in VARCHAR2
87 ,p_new_ENTRY_INFORMATION20 in VARCHAR2
88 ,p_new_ENTRY_INFORMATION21 in VARCHAR2
89 ,p_new_ENTRY_INFORMATION22 in VARCHAR2
90 ,p_new_ENTRY_INFORMATION23 in VARCHAR2
91 ,p_new_ENTRY_INFORMATION24 in VARCHAR2
92 ,p_new_ENTRY_INFORMATION25 in VARCHAR2
93 ,p_new_ENTRY_INFORMATION26 in VARCHAR2
94 ,p_new_ENTRY_INFORMATION27 in VARCHAR2
95 ,p_new_ENTRY_INFORMATION28 in VARCHAR2
96 ,p_new_ENTRY_INFORMATION29 in VARCHAR2
97 ,p_new_ENTRY_INFORMATION3 in VARCHAR2
98 ,p_new_ENTRY_INFORMATION30 in VARCHAR2
99 ,p_new_ENTRY_INFORMATION4 in VARCHAR2
100 ,p_new_ENTRY_INFORMATION5 in VARCHAR2
101 ,p_new_ENTRY_INFORMATION6 in VARCHAR2
102 ,p_new_ENTRY_INFORMATION7 in VARCHAR2
103 ,p_new_ENTRY_INFORMATION8 in VARCHAR2
104 ,p_new_ENTRY_INFORMATION9 in VARCHAR2
105 ,p_new_ENTRY_INFORMATION_CATEGO in VARCHAR2
106 ,p_new_ENTRY_TYPE in VARCHAR2
107 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
108 ,p_new_ORIGINAL_ENTRY_ID in NUMBER
109 ,p_new_PERSONAL_PAYMENT_METHOD_ in NUMBER
110 ,p_new_REASON in VARCHAR2
111 ,p_new_SOURCE_ID in NUMBER
112 ,p_new_SUBPRIORITY in NUMBER
113 ,p_new_TARGET_ENTRY_ID in NUMBER
114 ,p_new_UPDATING_ACTION_ID in NUMBER
115 ,p_new_UPDATING_ACTION_TYPE in VARCHAR2
116 ,p_old_ASSIGNMENT_ID in NUMBER
117 ,p_old_ATTRIBUTE1 in VARCHAR2
118 ,p_old_ATTRIBUTE10 in VARCHAR2
119 ,p_old_ATTRIBUTE11 in VARCHAR2
120 ,p_old_ATTRIBUTE12 in VARCHAR2
121 ,p_old_ATTRIBUTE13 in VARCHAR2
122 ,p_old_ATTRIBUTE14 in VARCHAR2
123 ,p_old_ATTRIBUTE15 in VARCHAR2
124 ,p_old_ATTRIBUTE16 in VARCHAR2
125 ,p_old_ATTRIBUTE17 in VARCHAR2
126 ,p_old_ATTRIBUTE18 in VARCHAR2
127 ,p_old_ATTRIBUTE19 in VARCHAR2
128 ,p_old_ATTRIBUTE2 in VARCHAR2
129 ,p_old_ATTRIBUTE20 in VARCHAR2
130 ,p_old_ATTRIBUTE3 in VARCHAR2
131 ,p_old_ATTRIBUTE4 in VARCHAR2
132 ,p_old_ATTRIBUTE5 in VARCHAR2
133 ,p_old_ATTRIBUTE6 in VARCHAR2
134 ,p_old_ATTRIBUTE7 in VARCHAR2
135 ,p_old_ATTRIBUTE8 in VARCHAR2
136 ,p_old_ATTRIBUTE9 in VARCHAR2
137 ,p_old_ATTRIBUTE_CATEGORY in VARCHAR2
138 ,p_old_BALANCE_ADJ_COST_FLAG in VARCHAR2
139 ,p_old_COMMENTS in VARCHAR2
140 ,p_old_COMMENT_ID in NUMBER
141 ,p_old_COST_ALLOCATION_KEYFLEX_ in NUMBER
142 ,p_old_CREATOR_ID in NUMBER
143 ,p_old_CREATOR_TYPE in VARCHAR2
144 ,p_old_DATE_EARNED in DATE
145 ,p_old_EFFECTIVE_END_DATE in DATE
146 ,p_old_EFFECTIVE_START_DATE in DATE
147 ,p_old_ELEMENT_LINK_ID in NUMBER
148 ,p_old_ELEMENT_TYPE_ID in NUMBER
149 ,p_old_ENTRY_INFORMATION1 in VARCHAR2
150 ,p_old_ENTRY_INFORMATION10 in VARCHAR2
151 ,p_old_ENTRY_INFORMATION11 in VARCHAR2
152 ,p_old_ENTRY_INFORMATION12 in VARCHAR2
153 ,p_old_ENTRY_INFORMATION13 in VARCHAR2
154 ,p_old_ENTRY_INFORMATION14 in VARCHAR2
155 ,p_old_ENTRY_INFORMATION15 in VARCHAR2
156 ,p_old_ENTRY_INFORMATION16 in VARCHAR2
157 ,p_old_ENTRY_INFORMATION17 in VARCHAR2
158 ,p_old_ENTRY_INFORMATION18 in VARCHAR2
159 ,p_old_ENTRY_INFORMATION19 in VARCHAR2
160 ,p_old_ENTRY_INFORMATION2 in VARCHAR2
161 ,p_old_ENTRY_INFORMATION20 in VARCHAR2
162 ,p_old_ENTRY_INFORMATION21 in VARCHAR2
163 ,p_old_ENTRY_INFORMATION22 in VARCHAR2
164 ,p_old_ENTRY_INFORMATION23 in VARCHAR2
165 ,p_old_ENTRY_INFORMATION24 in VARCHAR2
166 ,p_old_ENTRY_INFORMATION25 in VARCHAR2
167 ,p_old_ENTRY_INFORMATION26 in VARCHAR2
168 ,p_old_ENTRY_INFORMATION27 in VARCHAR2
169 ,p_old_ENTRY_INFORMATION28 in VARCHAR2
170 ,p_old_ENTRY_INFORMATION29 in VARCHAR2
171 ,p_old_ENTRY_INFORMATION3 in VARCHAR2
172 ,p_old_ENTRY_INFORMATION30 in VARCHAR2
173 ,p_old_ENTRY_INFORMATION4 in VARCHAR2
174 ,p_old_ENTRY_INFORMATION5 in VARCHAR2
175 ,p_old_ENTRY_INFORMATION6 in VARCHAR2
176 ,p_old_ENTRY_INFORMATION7 in VARCHAR2
177 ,p_old_ENTRY_INFORMATION8 in VARCHAR2
178 ,p_old_ENTRY_INFORMATION9 in VARCHAR2
179 ,p_old_ENTRY_INFORMATION_CATEGO in VARCHAR2
180 ,p_old_ENTRY_TYPE in VARCHAR2
181 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
182 ,p_old_ORIGINAL_ENTRY_ID in NUMBER
183 ,p_old_PERSONAL_PAYMENT_METHOD_ in NUMBER
184 ,p_old_REASON in VARCHAR2
185 ,p_old_SOURCE_ID in NUMBER
186 ,p_old_SUBPRIORITY in NUMBER
187 ,p_old_TARGET_ENTRY_ID in NUMBER
188 ,p_old_UPDATING_ACTION_ID in NUMBER
189 ,p_old_UPDATING_ACTION_TYPE in VARCHAR2
190 ); -- End of procedure definition for PAY_ELEMENT_ENTRIES_F_ARU_ARU
191
192 --
193 /*
194 ================================================
195 This is a dynamically generated package procedure
196 with code representing a dynamic trigger
197 ================================================
198 ** DO NOT CHANGE MANUALLY **
199 ------------------------------------------------
200 Name: PAY_ELEMENT_ENTRIES_F_ARD_ARD
201 Table: PAY_ELEMENT_ENTRIES_F
202 Action: Delete
203 Generated Date: 30/03/2009 04:53
204 Description: Continuous Calculation trigger on deletion of element entry
205 Full trigger name: PAY_ELEMENT_ENTRIES_F_ARD
206 ================================================
207 */
208 --
209 PROCEDURE PAY_ELEMENT_ENTRIES_F_ARD_ARD
210 (
211 p_new_EFFECTIVE_END_DATE in DATE
212 ,p_new_EFFECTIVE_START_DATE in DATE
213 ,p_new_ELEMENT_ENTRY_ID in NUMBER
214 ,p_old_ASSIGNMENT_ID in NUMBER
215 ,p_old_ATTRIBUTE1 in VARCHAR2
216 ,p_old_ATTRIBUTE10 in VARCHAR2
217 ,p_old_ATTRIBUTE11 in VARCHAR2
218 ,p_old_ATTRIBUTE12 in VARCHAR2
219 ,p_old_ATTRIBUTE13 in VARCHAR2
220 ,p_old_ATTRIBUTE14 in VARCHAR2
221 ,p_old_ATTRIBUTE15 in VARCHAR2
222 ,p_old_ATTRIBUTE16 in VARCHAR2
223 ,p_old_ATTRIBUTE17 in VARCHAR2
224 ,p_old_ATTRIBUTE18 in VARCHAR2
225 ,p_old_ATTRIBUTE19 in VARCHAR2
226 ,p_old_ATTRIBUTE2 in VARCHAR2
227 ,p_old_ATTRIBUTE20 in VARCHAR2
228 ,p_old_ATTRIBUTE3 in VARCHAR2
229 ,p_old_ATTRIBUTE4 in VARCHAR2
230 ,p_old_ATTRIBUTE5 in VARCHAR2
231 ,p_old_ATTRIBUTE6 in VARCHAR2
232 ,p_old_ATTRIBUTE7 in VARCHAR2
233 ,p_old_ATTRIBUTE8 in VARCHAR2
234 ,p_old_ATTRIBUTE9 in VARCHAR2
235 ,p_old_ATTRIBUTE_CATEGORY in VARCHAR2
236 ,p_old_BALANCE_ADJ_COST_FLAG in VARCHAR2
237 ,p_old_COMMENTS in VARCHAR2
238 ,p_old_COMMENT_ID in NUMBER
239 ,p_old_COST_ALLOCATION_KEYFLEX_ in NUMBER
240 ,p_old_CREATOR_ID in NUMBER
241 ,p_old_CREATOR_TYPE in VARCHAR2
242 ,p_old_DATE_EARNED in DATE
243 ,p_old_EFFECTIVE_END_DATE in DATE
244 ,p_old_EFFECTIVE_START_DATE in DATE
245 ,p_old_ELEMENT_LINK_ID in NUMBER
246 ,p_old_ELEMENT_TYPE_ID in NUMBER
247 ,p_old_ENTRY_INFORMATION1 in VARCHAR2
248 ,p_old_ENTRY_INFORMATION10 in VARCHAR2
249 ,p_old_ENTRY_INFORMATION11 in VARCHAR2
250 ,p_old_ENTRY_INFORMATION12 in VARCHAR2
251 ,p_old_ENTRY_INFORMATION13 in VARCHAR2
252 ,p_old_ENTRY_INFORMATION14 in VARCHAR2
253 ,p_old_ENTRY_INFORMATION15 in VARCHAR2
254 ,p_old_ENTRY_INFORMATION16 in VARCHAR2
255 ,p_old_ENTRY_INFORMATION17 in VARCHAR2
256 ,p_old_ENTRY_INFORMATION18 in VARCHAR2
257 ,p_old_ENTRY_INFORMATION19 in VARCHAR2
258 ,p_old_ENTRY_INFORMATION2 in VARCHAR2
259 ,p_old_ENTRY_INFORMATION20 in VARCHAR2
260 ,p_old_ENTRY_INFORMATION21 in VARCHAR2
261 ,p_old_ENTRY_INFORMATION22 in VARCHAR2
262 ,p_old_ENTRY_INFORMATION23 in VARCHAR2
263 ,p_old_ENTRY_INFORMATION24 in VARCHAR2
264 ,p_old_ENTRY_INFORMATION25 in VARCHAR2
265 ,p_old_ENTRY_INFORMATION26 in VARCHAR2
266 ,p_old_ENTRY_INFORMATION27 in VARCHAR2
267 ,p_old_ENTRY_INFORMATION28 in VARCHAR2
268 ,p_old_ENTRY_INFORMATION29 in VARCHAR2
269 ,p_old_ENTRY_INFORMATION3 in VARCHAR2
270 ,p_old_ENTRY_INFORMATION30 in VARCHAR2
271 ,p_old_ENTRY_INFORMATION4 in VARCHAR2
272 ,p_old_ENTRY_INFORMATION5 in VARCHAR2
273 ,p_old_ENTRY_INFORMATION6 in VARCHAR2
274 ,p_old_ENTRY_INFORMATION7 in VARCHAR2
275 ,p_old_ENTRY_INFORMATION8 in VARCHAR2
276 ,p_old_ENTRY_INFORMATION9 in VARCHAR2
277 ,p_old_ENTRY_INFORMATION_CATEGO in VARCHAR2
278 ,p_old_ENTRY_TYPE in VARCHAR2
279 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
280 ,p_old_ORIGINAL_ENTRY_ID in NUMBER
281 ,p_old_PERSONAL_PAYMENT_METHOD_ in NUMBER
282 ,p_old_REASON in VARCHAR2
283 ,p_old_SOURCE_ID in NUMBER
284 ,p_old_SUBPRIORITY in NUMBER
285 ,p_old_TARGET_ENTRY_ID in NUMBER
286 ,p_old_UPDATING_ACTION_ID in NUMBER
287 ,p_old_UPDATING_ACTION_TYPE in VARCHAR2
288 ); -- End of procedure definition for PAY_ELEMENT_ENTRIES_F_ARD_ARD
289
290 --
291 /*
292 ================================================
293 This is a dynamically generated package procedure
294 with code representing a dynamic trigger
295 ================================================
296 ** DO NOT CHANGE MANUALLY **
297 ------------------------------------------------
298 Name: PAY_ELEMENT_ENTRIES_F_ARI_ARI
299 Table: PAY_ELEMENT_ENTRIES_F
300 Action: Insert
301 Generated Date: 30/03/2009 04:53
302 Description: Continuous Calculation trigger on insert of element entry
303 Full trigger name: PAY_ELEMENT_ENTRIES_F_ARI
304 ================================================
305 */
306 --
307 PROCEDURE PAY_ELEMENT_ENTRIES_F_ARI_ARI
308 (
309 p_new_ASSIGNMENT_ID in NUMBER
310 ,p_new_ATTRIBUTE1 in VARCHAR2
311 ,p_new_ATTRIBUTE10 in VARCHAR2
312 ,p_new_ATTRIBUTE11 in VARCHAR2
313 ,p_new_ATTRIBUTE12 in VARCHAR2
314 ,p_new_ATTRIBUTE13 in VARCHAR2
318 ,p_new_ATTRIBUTE17 in VARCHAR2
315 ,p_new_ATTRIBUTE14 in VARCHAR2
316 ,p_new_ATTRIBUTE15 in VARCHAR2
317 ,p_new_ATTRIBUTE16 in VARCHAR2
319 ,p_new_ATTRIBUTE18 in VARCHAR2
320 ,p_new_ATTRIBUTE19 in VARCHAR2
321 ,p_new_ATTRIBUTE2 in VARCHAR2
322 ,p_new_ATTRIBUTE20 in VARCHAR2
323 ,p_new_ATTRIBUTE3 in VARCHAR2
324 ,p_new_ATTRIBUTE4 in VARCHAR2
325 ,p_new_ATTRIBUTE5 in VARCHAR2
326 ,p_new_ATTRIBUTE6 in VARCHAR2
327 ,p_new_ATTRIBUTE7 in VARCHAR2
328 ,p_new_ATTRIBUTE8 in VARCHAR2
329 ,p_new_ATTRIBUTE9 in VARCHAR2
330 ,p_new_ATTRIBUTE_CATEGORY in VARCHAR2
331 ,p_new_BALANCE_ADJ_COST_FLAG in VARCHAR2
332 ,p_new_COMMENTS in VARCHAR2
333 ,p_new_COMMENT_ID in NUMBER
334 ,p_new_COST_ALLOCATION_KEYFLEX_ in NUMBER
335 ,p_new_CREATOR_ID in NUMBER
336 ,p_new_CREATOR_TYPE in VARCHAR2
337 ,p_new_DATE_EARNED in DATE
338 ,p_new_EFFECTIVE_END_DATE in DATE
339 ,p_new_EFFECTIVE_START_DATE in DATE
340 ,p_new_ELEMENT_ENTRY_ID in NUMBER
341 ,p_new_ELEMENT_LINK_ID in NUMBER
342 ,p_new_ELEMENT_TYPE_ID in NUMBER
343 ,p_new_ENTRY_INFORMATION1 in VARCHAR2
344 ,p_new_ENTRY_INFORMATION10 in VARCHAR2
345 ,p_new_ENTRY_INFORMATION11 in VARCHAR2
346 ,p_new_ENTRY_INFORMATION12 in VARCHAR2
347 ,p_new_ENTRY_INFORMATION13 in VARCHAR2
348 ,p_new_ENTRY_INFORMATION14 in VARCHAR2
349 ,p_new_ENTRY_INFORMATION15 in VARCHAR2
350 ,p_new_ENTRY_INFORMATION16 in VARCHAR2
351 ,p_new_ENTRY_INFORMATION17 in VARCHAR2
352 ,p_new_ENTRY_INFORMATION18 in VARCHAR2
353 ,p_new_ENTRY_INFORMATION19 in VARCHAR2
354 ,p_new_ENTRY_INFORMATION2 in VARCHAR2
355 ,p_new_ENTRY_INFORMATION20 in VARCHAR2
356 ,p_new_ENTRY_INFORMATION21 in VARCHAR2
357 ,p_new_ENTRY_INFORMATION22 in VARCHAR2
358 ,p_new_ENTRY_INFORMATION23 in VARCHAR2
359 ,p_new_ENTRY_INFORMATION24 in VARCHAR2
360 ,p_new_ENTRY_INFORMATION25 in VARCHAR2
361 ,p_new_ENTRY_INFORMATION26 in VARCHAR2
362 ,p_new_ENTRY_INFORMATION27 in VARCHAR2
363 ,p_new_ENTRY_INFORMATION28 in VARCHAR2
364 ,p_new_ENTRY_INFORMATION29 in VARCHAR2
365 ,p_new_ENTRY_INFORMATION3 in VARCHAR2
366 ,p_new_ENTRY_INFORMATION30 in VARCHAR2
367 ,p_new_ENTRY_INFORMATION4 in VARCHAR2
368 ,p_new_ENTRY_INFORMATION5 in VARCHAR2
369 ,p_new_ENTRY_INFORMATION6 in VARCHAR2
370 ,p_new_ENTRY_INFORMATION7 in VARCHAR2
371 ,p_new_ENTRY_INFORMATION8 in VARCHAR2
372 ,p_new_ENTRY_INFORMATION9 in VARCHAR2
373 ,p_new_ENTRY_INFORMATION_CATEGO in VARCHAR2
374 ,p_new_ENTRY_TYPE in VARCHAR2
375 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
376 ,p_new_ORIGINAL_ENTRY_ID in NUMBER
377 ,p_new_PERSONAL_PAYMENT_METHOD_ in NUMBER
378 ,p_new_REASON in VARCHAR2
379 ,p_new_SOURCE_ID in NUMBER
380 ,p_new_SUBPRIORITY in NUMBER
381 ,p_new_TARGET_ENTRY_ID in NUMBER
382 ,p_new_UPDATING_ACTION_ID in NUMBER
383 ,p_new_UPDATING_ACTION_TYPE in VARCHAR2
384 ); -- End of procedure definition for PAY_ELEMENT_ENTRIES_F_ARI_ARI
385
386 --
387 /*
388 ================================================
389 This is a dynamically generated package procedure
390 with code representing a dynamic trigger
391 ================================================
392 ** DO NOT CHANGE MANUALLY **
393 ------------------------------------------------
394 Name: PQP_PEE_LOG_ARI_ARI
395 Table: PAY_ELEMENT_ENTRIES_F
396 Action: Insert
397 Generated Date: 30/03/2009 04:53
398 Description: Alien Element entry change log
399 Full trigger name: PQP_PEE_LOG_ARI
400 ================================================
401 */
402 --
403 PROCEDURE PQP_PEE_LOG_ARI_ARI
404 (
405 p_new_ASSIGNMENT_ID in NUMBER
406 ,p_new_ATTRIBUTE1 in VARCHAR2
407 ,p_new_ATTRIBUTE10 in VARCHAR2
408 ,p_new_ATTRIBUTE11 in VARCHAR2
409 ,p_new_ATTRIBUTE12 in VARCHAR2
410 ,p_new_ATTRIBUTE13 in VARCHAR2
411 ,p_new_ATTRIBUTE14 in VARCHAR2
412 ,p_new_ATTRIBUTE15 in VARCHAR2
413 ,p_new_ATTRIBUTE16 in VARCHAR2
414 ,p_new_ATTRIBUTE17 in VARCHAR2
415 ,p_new_ATTRIBUTE18 in VARCHAR2
416 ,p_new_ATTRIBUTE19 in VARCHAR2
417 ,p_new_ATTRIBUTE2 in VARCHAR2
421 ,p_new_ATTRIBUTE5 in VARCHAR2
418 ,p_new_ATTRIBUTE20 in VARCHAR2
419 ,p_new_ATTRIBUTE3 in VARCHAR2
420 ,p_new_ATTRIBUTE4 in VARCHAR2
422 ,p_new_ATTRIBUTE6 in VARCHAR2
423 ,p_new_ATTRIBUTE7 in VARCHAR2
424 ,p_new_ATTRIBUTE8 in VARCHAR2
425 ,p_new_ATTRIBUTE9 in VARCHAR2
426 ,p_new_ATTRIBUTE_CATEGORY in VARCHAR2
427 ,p_new_BALANCE_ADJ_COST_FLAG in VARCHAR2
428 ,p_new_COMMENTS in VARCHAR2
429 ,p_new_COMMENT_ID in NUMBER
430 ,p_new_COST_ALLOCATION_KEYFLEX_ in NUMBER
431 ,p_new_CREATOR_ID in NUMBER
432 ,p_new_CREATOR_TYPE in VARCHAR2
433 ,p_new_DATE_EARNED in DATE
434 ,p_new_EFFECTIVE_END_DATE in DATE
435 ,p_new_EFFECTIVE_START_DATE in DATE
436 ,p_new_ELEMENT_ENTRY_ID in NUMBER
437 ,p_new_ELEMENT_LINK_ID in NUMBER
438 ,p_new_ELEMENT_TYPE_ID in NUMBER
439 ,p_new_ENTRY_INFORMATION1 in VARCHAR2
440 ,p_new_ENTRY_INFORMATION10 in VARCHAR2
441 ,p_new_ENTRY_INFORMATION11 in VARCHAR2
442 ,p_new_ENTRY_INFORMATION12 in VARCHAR2
443 ,p_new_ENTRY_INFORMATION13 in VARCHAR2
444 ,p_new_ENTRY_INFORMATION14 in VARCHAR2
445 ,p_new_ENTRY_INFORMATION15 in VARCHAR2
446 ,p_new_ENTRY_INFORMATION16 in VARCHAR2
447 ,p_new_ENTRY_INFORMATION17 in VARCHAR2
448 ,p_new_ENTRY_INFORMATION18 in VARCHAR2
449 ,p_new_ENTRY_INFORMATION19 in VARCHAR2
450 ,p_new_ENTRY_INFORMATION2 in VARCHAR2
451 ,p_new_ENTRY_INFORMATION20 in VARCHAR2
452 ,p_new_ENTRY_INFORMATION21 in VARCHAR2
453 ,p_new_ENTRY_INFORMATION22 in VARCHAR2
454 ,p_new_ENTRY_INFORMATION23 in VARCHAR2
455 ,p_new_ENTRY_INFORMATION24 in VARCHAR2
456 ,p_new_ENTRY_INFORMATION25 in VARCHAR2
457 ,p_new_ENTRY_INFORMATION26 in VARCHAR2
458 ,p_new_ENTRY_INFORMATION27 in VARCHAR2
459 ,p_new_ENTRY_INFORMATION28 in VARCHAR2
460 ,p_new_ENTRY_INFORMATION29 in VARCHAR2
461 ,p_new_ENTRY_INFORMATION3 in VARCHAR2
462 ,p_new_ENTRY_INFORMATION30 in VARCHAR2
463 ,p_new_ENTRY_INFORMATION4 in VARCHAR2
464 ,p_new_ENTRY_INFORMATION5 in VARCHAR2
465 ,p_new_ENTRY_INFORMATION6 in VARCHAR2
466 ,p_new_ENTRY_INFORMATION7 in VARCHAR2
467 ,p_new_ENTRY_INFORMATION8 in VARCHAR2
468 ,p_new_ENTRY_INFORMATION9 in VARCHAR2
469 ,p_new_ENTRY_INFORMATION_CATEGO in VARCHAR2
470 ,p_new_ENTRY_TYPE in VARCHAR2
471 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
472 ,p_new_ORIGINAL_ENTRY_ID in NUMBER
473 ,p_new_PERSONAL_PAYMENT_METHOD_ in NUMBER
474 ,p_new_REASON in VARCHAR2
475 ,p_new_SOURCE_ID in NUMBER
476 ,p_new_SUBPRIORITY in NUMBER
477 ,p_new_TARGET_ENTRY_ID in NUMBER
478 ,p_new_UPDATING_ACTION_ID in NUMBER
479 ,p_new_UPDATING_ACTION_TYPE in VARCHAR2
480 ); -- End of procedure definition for PQP_PEE_LOG_ARI_ARI
481
482 --
483 /*
484 ================================================
485 This is a dynamically generated procedure.
486 Will be called by API.
487 ================================================
488 ** DO NOT CHANGE MANUALLY **
489 ------------------------------------------------
490 Name: AFTER_INSERT
491 Table: PAY_ELEMENT_ENTRIES_F
492 Action: INSERT
493 Generated Date: 30/03/2009 04:53
494 Description: Called as part of INSERT process
495 ================================================
496 */
497
498 --
499 PROCEDURE AFTER_INSERT
500 (
501 P_EFFECTIVE_DATE in DATE
502 ,P_VALIDATION_START_DATE in DATE
503 ,P_VALIDATION_END_DATE in DATE
504 ,P_ELEMENT_ENTRY_ID in NUMBER
505 ,P_EFFECTIVE_START_DATE in DATE
506 ,P_EFFECTIVE_END_DATE in DATE
507 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
508 ,P_ASSIGNMENT_ID in NUMBER
509 ,P_UPDATING_ACTION_ID in NUMBER
510 ,P_UPDATING_ACTION_TYPE in VARCHAR2
511 ,P_ELEMENT_LINK_ID in NUMBER
512 ,P_ORIGINAL_ENTRY_ID in NUMBER
513 ,P_CREATOR_TYPE in VARCHAR2
514 ,P_ENTRY_TYPE in VARCHAR2
515 ,P_COMMENT_ID in NUMBER
516 ,P_COMMENTS in VARCHAR2
517 ,P_CREATOR_ID in NUMBER
518 ,P_REASON in VARCHAR2
519 ,P_TARGET_ENTRY_ID in NUMBER
520 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
521 ,P_ATTRIBUTE1 in VARCHAR2
525 ,P_ATTRIBUTE5 in VARCHAR2
522 ,P_ATTRIBUTE2 in VARCHAR2
523 ,P_ATTRIBUTE3 in VARCHAR2
524 ,P_ATTRIBUTE4 in VARCHAR2
526 ,P_ATTRIBUTE6 in VARCHAR2
527 ,P_ATTRIBUTE7 in VARCHAR2
528 ,P_ATTRIBUTE8 in VARCHAR2
529 ,P_ATTRIBUTE9 in VARCHAR2
530 ,P_ATTRIBUTE10 in VARCHAR2
531 ,P_ATTRIBUTE11 in VARCHAR2
532 ,P_ATTRIBUTE12 in VARCHAR2
533 ,P_ATTRIBUTE13 in VARCHAR2
534 ,P_ATTRIBUTE14 in VARCHAR2
535 ,P_ATTRIBUTE15 in VARCHAR2
536 ,P_ATTRIBUTE16 in VARCHAR2
537 ,P_ATTRIBUTE17 in VARCHAR2
538 ,P_ATTRIBUTE18 in VARCHAR2
539 ,P_ATTRIBUTE19 in VARCHAR2
540 ,P_ATTRIBUTE20 in VARCHAR2
541 ,P_ENTRY_INFORMATION_CATEGORY in VARCHAR2
542 ,P_ENTRY_INFORMATION1 in VARCHAR2
543 ,P_ENTRY_INFORMATION2 in VARCHAR2
544 ,P_ENTRY_INFORMATION3 in VARCHAR2
545 ,P_ENTRY_INFORMATION4 in VARCHAR2
546 ,P_ENTRY_INFORMATION5 in VARCHAR2
547 ,P_ENTRY_INFORMATION6 in VARCHAR2
548 ,P_ENTRY_INFORMATION7 in VARCHAR2
549 ,P_ENTRY_INFORMATION8 in VARCHAR2
550 ,P_ENTRY_INFORMATION9 in VARCHAR2
551 ,P_ENTRY_INFORMATION10 in VARCHAR2
552 ,P_ENTRY_INFORMATION11 in VARCHAR2
553 ,P_ENTRY_INFORMATION12 in VARCHAR2
554 ,P_ENTRY_INFORMATION13 in VARCHAR2
555 ,P_ENTRY_INFORMATION14 in VARCHAR2
556 ,P_ENTRY_INFORMATION15 in VARCHAR2
557 ,P_ENTRY_INFORMATION16 in VARCHAR2
558 ,P_ENTRY_INFORMATION17 in VARCHAR2
559 ,P_ENTRY_INFORMATION18 in VARCHAR2
560 ,P_ENTRY_INFORMATION19 in VARCHAR2
561 ,P_ENTRY_INFORMATION20 in VARCHAR2
562 ,P_ENTRY_INFORMATION21 in VARCHAR2
563 ,P_ENTRY_INFORMATION22 in VARCHAR2
564 ,P_ENTRY_INFORMATION23 in VARCHAR2
565 ,P_ENTRY_INFORMATION24 in VARCHAR2
566 ,P_ENTRY_INFORMATION25 in VARCHAR2
567 ,P_ENTRY_INFORMATION26 in VARCHAR2
568 ,P_ENTRY_INFORMATION27 in VARCHAR2
569 ,P_ENTRY_INFORMATION28 in VARCHAR2
570 ,P_ENTRY_INFORMATION29 in VARCHAR2
571 ,P_ENTRY_INFORMATION30 in VARCHAR2
572 ,P_SUBPRIORITY in NUMBER
573 ,P_PERSONAL_PAYMENT_METHOD_ID in NUMBER
574 ,P_DATE_EARNED in DATE
575 ,P_OBJECT_VERSION_NUMBER in NUMBER
576 ,P_SOURCE_ID in NUMBER
577 ,P_BALANCE_ADJ_COST_FLAG in VARCHAR2
578 ,P_ELEMENT_TYPE_ID in NUMBER
579 ,P_ALL_ENTRY_VALUES_NULL in VARCHAR2
580 ); -- End of procedure definition for AFTER_INSERT
581
582 --
583 /*
584 ================================================
585 This is a dynamically generated procedure.
586 Will be called by API.
587 ================================================
588 ** DO NOT CHANGE MANUALLY **
589 ------------------------------------------------
590 Name: AFTER_UPDATE
591 Table: PAY_ELEMENT_ENTRIES_F
592 Action: UPDATE
593 Generated Date: 30/03/2009 04:53
594 Description: Called as part of UPDATE process
595 ================================================
596 */
597
598 --
599 PROCEDURE AFTER_UPDATE
600 (
601 P_EFFECTIVE_DATE in DATE
602 ,P_DATETRACK_MODE in VARCHAR2
603 ,P_VALIDATION_START_DATE in DATE
604 ,P_VALIDATION_END_DATE in DATE
605 ,P_ELEMENT_ENTRY_ID in NUMBER
606 ,P_EFFECTIVE_START_DATE in DATE
607 ,P_EFFECTIVE_END_DATE in DATE
608 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
609 ,P_UPDATING_ACTION_ID in NUMBER
610 ,P_UPDATING_ACTION_TYPE in VARCHAR2
611 ,P_ORIGINAL_ENTRY_ID in NUMBER
612 ,P_CREATOR_TYPE in VARCHAR2
613 ,P_ENTRY_TYPE in VARCHAR2
614 ,P_COMMENT_ID in NUMBER
615 ,P_COMMENTS in VARCHAR2
616 ,P_CREATOR_ID in NUMBER
617 ,P_REASON in VARCHAR2
618 ,P_TARGET_ENTRY_ID in NUMBER
619 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
620 ,P_ATTRIBUTE1 in VARCHAR2
621 ,P_ATTRIBUTE2 in VARCHAR2
622 ,P_ATTRIBUTE3 in VARCHAR2
623 ,P_ATTRIBUTE4 in VARCHAR2
624 ,P_ATTRIBUTE5 in VARCHAR2
625 ,P_ATTRIBUTE6 in VARCHAR2
629 ,P_ATTRIBUTE10 in VARCHAR2
626 ,P_ATTRIBUTE7 in VARCHAR2
627 ,P_ATTRIBUTE8 in VARCHAR2
628 ,P_ATTRIBUTE9 in VARCHAR2
630 ,P_ATTRIBUTE11 in VARCHAR2
631 ,P_ATTRIBUTE12 in VARCHAR2
632 ,P_ATTRIBUTE13 in VARCHAR2
633 ,P_ATTRIBUTE14 in VARCHAR2
634 ,P_ATTRIBUTE15 in VARCHAR2
635 ,P_ATTRIBUTE16 in VARCHAR2
636 ,P_ATTRIBUTE17 in VARCHAR2
637 ,P_ATTRIBUTE18 in VARCHAR2
638 ,P_ATTRIBUTE19 in VARCHAR2
639 ,P_ATTRIBUTE20 in VARCHAR2
640 ,P_ENTRY_INFORMATION_CATEGORY in VARCHAR2
641 ,P_ENTRY_INFORMATION1 in VARCHAR2
642 ,P_ENTRY_INFORMATION2 in VARCHAR2
643 ,P_ENTRY_INFORMATION3 in VARCHAR2
644 ,P_ENTRY_INFORMATION4 in VARCHAR2
645 ,P_ENTRY_INFORMATION5 in VARCHAR2
646 ,P_ENTRY_INFORMATION6 in VARCHAR2
647 ,P_ENTRY_INFORMATION7 in VARCHAR2
648 ,P_ENTRY_INFORMATION8 in VARCHAR2
649 ,P_ENTRY_INFORMATION9 in VARCHAR2
650 ,P_ENTRY_INFORMATION10 in VARCHAR2
651 ,P_ENTRY_INFORMATION11 in VARCHAR2
652 ,P_ENTRY_INFORMATION12 in VARCHAR2
653 ,P_ENTRY_INFORMATION13 in VARCHAR2
654 ,P_ENTRY_INFORMATION14 in VARCHAR2
655 ,P_ENTRY_INFORMATION15 in VARCHAR2
656 ,P_ENTRY_INFORMATION16 in VARCHAR2
657 ,P_ENTRY_INFORMATION17 in VARCHAR2
658 ,P_ENTRY_INFORMATION18 in VARCHAR2
659 ,P_ENTRY_INFORMATION19 in VARCHAR2
660 ,P_ENTRY_INFORMATION20 in VARCHAR2
661 ,P_ENTRY_INFORMATION21 in VARCHAR2
662 ,P_ENTRY_INFORMATION22 in VARCHAR2
663 ,P_ENTRY_INFORMATION23 in VARCHAR2
664 ,P_ENTRY_INFORMATION24 in VARCHAR2
665 ,P_ENTRY_INFORMATION25 in VARCHAR2
666 ,P_ENTRY_INFORMATION26 in VARCHAR2
667 ,P_ENTRY_INFORMATION27 in VARCHAR2
668 ,P_ENTRY_INFORMATION28 in VARCHAR2
669 ,P_ENTRY_INFORMATION29 in VARCHAR2
670 ,P_ENTRY_INFORMATION30 in VARCHAR2
671 ,P_SUBPRIORITY in NUMBER
672 ,P_PERSONAL_PAYMENT_METHOD_ID in NUMBER
673 ,P_DATE_EARNED in DATE
674 ,P_OBJECT_VERSION_NUMBER in NUMBER
675 ,P_SOURCE_ID in NUMBER
676 ,P_BALANCE_ADJ_COST_FLAG in VARCHAR2
677 ,P_ALL_ENTRY_VALUES_NULL in VARCHAR2
678 ,P_EFFECTIVE_START_DATE_O in DATE
679 ,P_EFFECTIVE_END_DATE_O in DATE
680 ,P_COST_ALLOCATION_KEYFLEX_ID_O in NUMBER
681 ,P_ASSIGNMENT_ID_O in NUMBER
682 ,P_UPDATING_ACTION_ID_O in NUMBER
683 ,P_UPDATING_ACTION_TYPE_O in VARCHAR2
684 ,P_ELEMENT_LINK_ID_O in NUMBER
685 ,P_ORIGINAL_ENTRY_ID_O in NUMBER
686 ,P_CREATOR_TYPE_O in VARCHAR2
687 ,P_ENTRY_TYPE_O in VARCHAR2
688 ,P_COMMENT_ID_O in NUMBER
689 ,P_COMMENTS_O in VARCHAR2
690 ,P_CREATOR_ID_O in NUMBER
691 ,P_REASON_O in VARCHAR2
692 ,P_TARGET_ENTRY_ID_O in NUMBER
693 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
694 ,P_ATTRIBUTE1_O in VARCHAR2
695 ,P_ATTRIBUTE2_O in VARCHAR2
696 ,P_ATTRIBUTE3_O in VARCHAR2
697 ,P_ATTRIBUTE4_O in VARCHAR2
698 ,P_ATTRIBUTE5_O in VARCHAR2
699 ,P_ATTRIBUTE6_O in VARCHAR2
700 ,P_ATTRIBUTE7_O in VARCHAR2
701 ,P_ATTRIBUTE8_O in VARCHAR2
702 ,P_ATTRIBUTE9_O in VARCHAR2
703 ,P_ATTRIBUTE10_O in VARCHAR2
704 ,P_ATTRIBUTE11_O in VARCHAR2
705 ,P_ATTRIBUTE12_O in VARCHAR2
706 ,P_ATTRIBUTE13_O in VARCHAR2
707 ,P_ATTRIBUTE14_O in VARCHAR2
708 ,P_ATTRIBUTE15_O in VARCHAR2
709 ,P_ATTRIBUTE16_O in VARCHAR2
710 ,P_ATTRIBUTE17_O in VARCHAR2
711 ,P_ATTRIBUTE18_O in VARCHAR2
712 ,P_ATTRIBUTE19_O in VARCHAR2
713 ,P_ATTRIBUTE20_O in VARCHAR2
714 ,P_ENTRY_INFORMATION_CATEGORY_O in VARCHAR2
715 ,P_ENTRY_INFORMATION1_O in VARCHAR2
716 ,P_ENTRY_INFORMATION2_O in VARCHAR2
717 ,P_ENTRY_INFORMATION3_O in VARCHAR2
718 ,P_ENTRY_INFORMATION4_O in VARCHAR2
719 ,P_ENTRY_INFORMATION5_O in VARCHAR2
720 ,P_ENTRY_INFORMATION6_O in VARCHAR2
721 ,P_ENTRY_INFORMATION7_O in VARCHAR2
725 ,P_ENTRY_INFORMATION11_O in VARCHAR2
722 ,P_ENTRY_INFORMATION8_O in VARCHAR2
723 ,P_ENTRY_INFORMATION9_O in VARCHAR2
724 ,P_ENTRY_INFORMATION10_O in VARCHAR2
726 ,P_ENTRY_INFORMATION12_O in VARCHAR2
727 ,P_ENTRY_INFORMATION13_O in VARCHAR2
728 ,P_ENTRY_INFORMATION14_O in VARCHAR2
729 ,P_ENTRY_INFORMATION15_O in VARCHAR2
730 ,P_ENTRY_INFORMATION16_O in VARCHAR2
731 ,P_ENTRY_INFORMATION17_O in VARCHAR2
732 ,P_ENTRY_INFORMATION18_O in VARCHAR2
733 ,P_ENTRY_INFORMATION19_O in VARCHAR2
734 ,P_ENTRY_INFORMATION20_O in VARCHAR2
735 ,P_ENTRY_INFORMATION21_O in VARCHAR2
736 ,P_ENTRY_INFORMATION22_O in VARCHAR2
737 ,P_ENTRY_INFORMATION23_O in VARCHAR2
738 ,P_ENTRY_INFORMATION24_O in VARCHAR2
739 ,P_ENTRY_INFORMATION25_O in VARCHAR2
740 ,P_ENTRY_INFORMATION26_O in VARCHAR2
741 ,P_ENTRY_INFORMATION27_O in VARCHAR2
742 ,P_ENTRY_INFORMATION28_O in VARCHAR2
743 ,P_ENTRY_INFORMATION29_O in VARCHAR2
744 ,P_ENTRY_INFORMATION30_O in VARCHAR2
745 ,P_SUBPRIORITY_O in NUMBER
746 ,P_PERSONAL_PAYMENT_METHOD_ID_O in NUMBER
747 ,P_DATE_EARNED_O in DATE
748 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
749 ,P_SOURCE_ID_O in NUMBER
750 ,P_BALANCE_ADJ_COST_FLAG_O in VARCHAR2
751 ,P_ELEMENT_TYPE_ID_O in NUMBER
752 ,P_ALL_ENTRY_VALUES_NULL_O in VARCHAR2
753 ); -- End of procedure definition for AFTER_UPDATE
754
755 --
756 /*
757 ================================================
758 This is a dynamically generated procedure.
759 Will be called by API.
760 ================================================
761 ** DO NOT CHANGE MANUALLY **
762 ------------------------------------------------
763 Name: AFTER_DELETE
764 Table: PAY_ELEMENT_ENTRIES_F
765 Action: DELETE
766 Generated Date: 30/03/2009 04:53
767 Description: Called as part of DELETE process
768 ================================================
769 */
770
771 --
772 PROCEDURE AFTER_DELETE
773 (
774 P_EFFECTIVE_DATE in DATE
775 ,P_DATETRACK_MODE in VARCHAR2
776 ,P_VALIDATION_START_DATE in DATE
777 ,P_VALIDATION_END_DATE in DATE
778 ,P_ELEMENT_ENTRY_ID in NUMBER
779 ,P_EFFECTIVE_START_DATE in DATE
780 ,P_EFFECTIVE_END_DATE in DATE
781 ,P_EFFECTIVE_START_DATE_O in DATE
782 ,P_EFFECTIVE_END_DATE_O in DATE
783 ,P_COST_ALLOCATION_KEYFLEX_ID_O in NUMBER
784 ,P_ASSIGNMENT_ID_O in NUMBER
785 ,P_UPDATING_ACTION_ID_O in NUMBER
786 ,P_UPDATING_ACTION_TYPE_O in VARCHAR2
787 ,P_ELEMENT_LINK_ID_O in NUMBER
788 ,P_ORIGINAL_ENTRY_ID_O in NUMBER
789 ,P_CREATOR_TYPE_O in VARCHAR2
790 ,P_ENTRY_TYPE_O in VARCHAR2
791 ,P_COMMENT_ID_O in NUMBER
792 ,P_COMMENTS_O in VARCHAR2
793 ,P_CREATOR_ID_O in NUMBER
794 ,P_REASON_O in VARCHAR2
795 ,P_TARGET_ENTRY_ID_O in NUMBER
796 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
797 ,P_ATTRIBUTE1_O in VARCHAR2
798 ,P_ATTRIBUTE2_O in VARCHAR2
799 ,P_ATTRIBUTE3_O in VARCHAR2
800 ,P_ATTRIBUTE4_O in VARCHAR2
801 ,P_ATTRIBUTE5_O in VARCHAR2
802 ,P_ATTRIBUTE6_O in VARCHAR2
803 ,P_ATTRIBUTE7_O in VARCHAR2
804 ,P_ATTRIBUTE8_O in VARCHAR2
805 ,P_ATTRIBUTE9_O in VARCHAR2
806 ,P_ATTRIBUTE10_O in VARCHAR2
807 ,P_ATTRIBUTE11_O in VARCHAR2
808 ,P_ATTRIBUTE12_O in VARCHAR2
809 ,P_ATTRIBUTE13_O in VARCHAR2
810 ,P_ATTRIBUTE14_O in VARCHAR2
811 ,P_ATTRIBUTE15_O in VARCHAR2
812 ,P_ATTRIBUTE16_O in VARCHAR2
813 ,P_ATTRIBUTE17_O in VARCHAR2
814 ,P_ATTRIBUTE18_O in VARCHAR2
815 ,P_ATTRIBUTE19_O in VARCHAR2
816 ,P_ATTRIBUTE20_O in VARCHAR2
817 ,P_ENTRY_INFORMATION_CATEGORY_O in VARCHAR2
818 ,P_ENTRY_INFORMATION1_O in VARCHAR2
819 ,P_ENTRY_INFORMATION2_O in VARCHAR2
820 ,P_ENTRY_INFORMATION3_O in VARCHAR2
821 ,P_ENTRY_INFORMATION4_O in VARCHAR2
822 ,P_ENTRY_INFORMATION5_O in VARCHAR2
823 ,P_ENTRY_INFORMATION6_O in VARCHAR2
824 ,P_ENTRY_INFORMATION7_O in VARCHAR2
825 ,P_ENTRY_INFORMATION8_O in VARCHAR2
826 ,P_ENTRY_INFORMATION9_O in VARCHAR2
827 ,P_ENTRY_INFORMATION10_O in VARCHAR2
828 ,P_ENTRY_INFORMATION11_O in VARCHAR2
829 ,P_ENTRY_INFORMATION12_O in VARCHAR2
830 ,P_ENTRY_INFORMATION13_O in VARCHAR2
831 ,P_ENTRY_INFORMATION14_O in VARCHAR2
832 ,P_ENTRY_INFORMATION15_O in VARCHAR2
833 ,P_ENTRY_INFORMATION16_O in VARCHAR2
834 ,P_ENTRY_INFORMATION17_O in VARCHAR2
835 ,P_ENTRY_INFORMATION18_O in VARCHAR2
836 ,P_ENTRY_INFORMATION19_O in VARCHAR2
837 ,P_ENTRY_INFORMATION20_O in VARCHAR2
838 ,P_ENTRY_INFORMATION21_O in VARCHAR2
839 ,P_ENTRY_INFORMATION22_O in VARCHAR2
840 ,P_ENTRY_INFORMATION23_O in VARCHAR2
841 ,P_ENTRY_INFORMATION24_O in VARCHAR2
842 ,P_ENTRY_INFORMATION25_O in VARCHAR2
843 ,P_ENTRY_INFORMATION26_O in VARCHAR2
844 ,P_ENTRY_INFORMATION27_O in VARCHAR2
845 ,P_ENTRY_INFORMATION28_O in VARCHAR2
846 ,P_ENTRY_INFORMATION29_O in VARCHAR2
847 ,P_ENTRY_INFORMATION30_O in VARCHAR2
848 ,P_SUBPRIORITY_O in NUMBER
849 ,P_PERSONAL_PAYMENT_METHOD_ID_O in NUMBER
850 ,P_DATE_EARNED_O in DATE
851 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
852 ,P_SOURCE_ID_O in NUMBER
853 ,P_BALANCE_ADJ_COST_FLAG_O in VARCHAR2
854 ,P_ELEMENT_TYPE_ID_O in NUMBER
855 ,P_ALL_ENTRY_VALUES_NULL_O in VARCHAR2
856 ); -- End of procedure definition for AFTER_DELETE
857
858 --
859 END PAY_DYT_ELEMENT_ENTRIES_PKG;
[Home] [Help]