1 PACKAGE PAY_CONTINUOUS_CALC AS
2 /* $Header: pycontc.pkh 120.12.12010000.1 2008/07/27 22:22:44 appldev ship $ */
3 /* Global definitions */
4 TYPE number_tbl IS TABLE OF NUMBER INDEX BY binary_integer;
5 TYPE varchar_60_tbl IS TABLE OF VARCHAR(60) INDEX BY binary_integer;
6 -- Added to increase the size of event_list_cache.description Bug # 2375570 -mkandasa
7 TYPE varchar_240_tbl IS TABLE OF VARCHAR(240) INDEX BY binary_integer;
8 TYPE varchar_2_tbl IS TABLE OF VARCHAR(2) INDEX BY binary_integer;
9 TYPE boolean_tbl IS TABLE OF BOOLEAN INDEX BY binary_integer;
10 TYPE date_tbl IS TABLE OF DATE INDEX BY binary_integer;
11 --
12 TYPE event_list_cache IS RECORD
13 (
14 change_type varchar_60_tbl,
15 effective_date date_tbl,
16 calc_date date_tbl,
17 event_update_id number_tbl,
18 description varchar_240_tbl,
19 sz INTEGER
20 );
21 --
22 g_event_list event_list_cache;
23 g_override_cc boolean;
24 --
25
26 procedure event_update(
27 p_business_group_id in number,
28 p_legislation_code in varchar2,
29 p_table_name in varchar2,
30 p_column_name in varchar2,
31 p_old_value in varchar2,
32 p_new_value in varchar2,
33 p_effective_date in date,
34 p_calc_date in date default null,
35 p_event_type in varchar2 default 'U'
36 );
37
38
39 ------------------------------------------------------------------------------------
40 -- Here are all the trigger point procedures for Core
41 ------------------------------------------------------------------------------------
42 --
43 --
44 procedure PAY_COST_ALLOCATIONS_F_aru(
45 p_business_group_id in number,
46 p_legislation_code in varchar2,
47 p_effective_date in date,
48 p_old_ASSIGNMENT_ID in NUMBER,
49 p_new_ASSIGNMENT_ID in NUMBER,
50 p_old_BUSINESS_GROUP_ID in NUMBER,
51 p_new_BUSINESS_GROUP_ID in NUMBER,
52 p_old_COST_ALLOCATION_ID in NUMBER,
53 p_new_COST_ALLOCATION_ID in NUMBER,
54 p_old_COST_ALLOCATION_KEYFLEX_ in NUMBER,
55 p_new_COST_ALLOCATION_KEYFLEX_ in NUMBER,
56 p_old_PROGRAM_APPLICATION_ID in NUMBER,
57 p_new_PROGRAM_APPLICATION_ID in NUMBER,
58 p_old_PROGRAM_ID in NUMBER,
59 p_new_PROGRAM_ID in NUMBER,
60 p_old_PROGRAM_UPDATE_DATE in DATE,
61 p_new_PROGRAM_UPDATE_DATE in DATE,
62 p_old_PROPORTION in NUMBER,
63 p_new_PROPORTION in NUMBER,
64 p_old_REQUEST_ID in NUMBER,
65 p_new_REQUEST_ID in NUMBER,
66 p_old_EFFECTIVE_END_DATE in DATE,
67 p_new_EFFECTIVE_END_DATE in DATE,
68 p_old_EFFECTIVE_START_DATE in DATE,
69 p_new_EFFECTIVE_START_DATE in DATE
70 );
71
72 procedure PAY_COST_ALLOCATIONS_F_ari(
73 p_business_group_id in number,
74 p_legislation_code in varchar2,
75 p_assignment_id in number,
76 p_effective_start_date in date,
77 p_cost_allocation_id in number
78 );
79
80 procedure PAY_COST_ALLOCATIONS_F_ard(
81 p_business_group_id in number,
82 p_legislation_code in varchar2,
83 p_assignment_id in number,
84 p_old_cost_allocation_ID in number,
85 p_old_effective_start_date in date,
86 p_new_effective_start_date in date,
87 p_old_effective_end_date in date,
88 p_new_effective_end_date in date
89 );
90 --
91 procedure PER_PERFORMANCE_REVIEWS_aru(
92 p_business_group_id in number,
93 p_legislation_code in varchar2,
94 p_effective_date in date ,
95 p_old_ATTRIBUTE1 in VARCHAR2,
96 p_new_ATTRIBUTE1 in VARCHAR2 ,
97 p_old_ATTRIBUTE10 in VARCHAR2,
98 p_new_ATTRIBUTE10 in VARCHAR2 ,
99 p_old_ATTRIBUTE11 in VARCHAR2,
100 p_new_ATTRIBUTE11 in VARCHAR2 ,
101 p_old_ATTRIBUTE12 in VARCHAR2,
102 p_new_ATTRIBUTE12 in VARCHAR2 ,
103 p_old_ATTRIBUTE13 in VARCHAR2,
104 p_new_ATTRIBUTE13 in VARCHAR2 ,
105 p_old_ATTRIBUTE14 in VARCHAR2,
106 p_new_ATTRIBUTE14 in VARCHAR2 ,
107 p_old_ATTRIBUTE15 in VARCHAR2,
108 p_new_ATTRIBUTE15 in VARCHAR2 ,
109 p_old_ATTRIBUTE16 in VARCHAR2,
110 p_new_ATTRIBUTE16 in VARCHAR2 ,
111 p_old_ATTRIBUTE17 in VARCHAR2,
112 p_new_ATTRIBUTE17 in VARCHAR2 ,
113 p_old_ATTRIBUTE18 in VARCHAR2,
114 p_new_ATTRIBUTE18 in VARCHAR2 ,
115 p_old_ATTRIBUTE19 in VARCHAR2,
116 p_new_ATTRIBUTE19 in VARCHAR2 ,
117 p_old_ATTRIBUTE2 in VARCHAR2,
118 p_new_ATTRIBUTE2 in VARCHAR2 ,
119 p_old_ATTRIBUTE20 in VARCHAR2,
120 p_new_ATTRIBUTE20 in VARCHAR2 ,
121 p_old_ATTRIBUTE21 in VARCHAR2,
122 p_new_ATTRIBUTE21 in VARCHAR2 ,
123 p_old_ATTRIBUTE22 in VARCHAR2,
124 p_new_ATTRIBUTE22 in VARCHAR2 ,
125 p_old_ATTRIBUTE23 in VARCHAR2,
126 p_new_ATTRIBUTE23 in VARCHAR2 ,
127 p_old_ATTRIBUTE24 in VARCHAR2,
128 p_new_ATTRIBUTE24 in VARCHAR2,
129 p_old_ATTRIBUTE25 in VARCHAR2,
130 p_new_ATTRIBUTE25 in VARCHAR2 ,
131 p_old_ATTRIBUTE26 in VARCHAR2,
132 p_new_ATTRIBUTE26 in VARCHAR2 ,
133 p_old_ATTRIBUTE27 in VARCHAR2,
134 p_new_ATTRIBUTE27 in VARCHAR2 ,
135 p_old_ATTRIBUTE28 in VARCHAR2,
136 p_new_ATTRIBUTE28 in VARCHAR2 ,
137 p_old_ATTRIBUTE29 in VARCHAR2,
138 p_new_ATTRIBUTE29 in VARCHAR2 ,
139 p_old_ATTRIBUTE3 in VARCHAR2,
140 p_new_ATTRIBUTE3 in VARCHAR2 ,
141 p_old_ATTRIBUTE30 in VARCHAR2,
142 p_new_ATTRIBUTE30 in VARCHAR2 ,
143 p_old_ATTRIBUTE4 in VARCHAR2,
144 p_new_ATTRIBUTE4 in VARCHAR2 ,
145 p_old_ATTRIBUTE5 in VARCHAR2,
146 p_new_ATTRIBUTE5 in VARCHAR2 ,
147 p_old_ATTRIBUTE6 in VARCHAR2,
148 p_new_ATTRIBUTE6 in VARCHAR2 ,
149 p_old_ATTRIBUTE7 in VARCHAR2,
150 p_new_ATTRIBUTE7 in VARCHAR2 ,
151 p_old_ATTRIBUTE8 in VARCHAR2,
152 p_new_ATTRIBUTE8 in VARCHAR2 ,
153 p_old_ATTRIBUTE9 in VARCHAR2,
154 p_new_ATTRIBUTE9 in VARCHAR2 ,
155 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
156 p_new_ATTRIBUTE_CATEGORY in VARCHAR2 ,
157 p_old_EVENT_ID in NUMBER,
158 p_new_EVENT_ID in NUMBER ,
159 p_old_NEXT_PERF_REVIEW_DATE in DATE,
160 p_new_NEXT_PERF_REVIEW_DATE in DATE ,
161 p_old_PERFORMANCE_RATING in VARCHAR2,
162 p_new_PERFORMANCE_RATING in VARCHAR2 ,
163 p_old_PERFORMANCE_REVIEW_ID in NUMBER,
164 p_new_PERFORMANCE_REVIEW_ID in NUMBER ,
165 p_old_PERSON_ID in NUMBER,
166 p_new_PERSON_ID in NUMBER ,
167 p_old_REVIEW_DATE in DATE,
168 p_new_REVIEW_DATE in DATE
169 ) ;
170
171 procedure PAY_ELEMENT_ENTRY_VALUES_F_aru(
172 p_business_group_id in number,
173 p_legislation_code in varchar2,
174 p_effective_date in date,
175 p_old_ELEMENT_ENTRY_ID in NUMBER,
176 p_new_ELEMENT_ENTRY_ID in NUMBER,
177 p_old_SCREEN_ENTRY_VALUE in VARCHAR2,
178 p_new_SCREEN_ENTRY_VALUE in VARCHAR2,
179 p_old_ELEMENT_ENTRY_VALUE_ID in NUMBER
180 );
181 --
182 procedure element_entries_ari(
183 p_business_group_id in number,
184 p_legislation_code in varchar2,
185 p_assignment_id in number,
186 p_effective_start_date in date,
187 p_updating_action_id in number,
188 p_new_element_entry_id in number
189 );
190 --
191 procedure PAY_ELEMENT_ENTRIES_F_aru(
192 p_business_group_id in number,
193 p_legislation_code in varchar2,
194 p_effective_date in date,
195 p_old_ASSIGNMENT_ID in NUMBER,
196 p_new_ASSIGNMENT_ID in NUMBER,
197 p_old_ATTRIBUTE1 in VARCHAR2,
198 p_new_ATTRIBUTE1 in VARCHAR2,
199 p_old_ATTRIBUTE10 in VARCHAR2,
200 p_new_ATTRIBUTE10 in VARCHAR2,
201 p_old_ATTRIBUTE11 in VARCHAR2,
202 p_new_ATTRIBUTE11 in VARCHAR2,
203 p_old_ATTRIBUTE12 in VARCHAR2,
204 p_new_ATTRIBUTE12 in VARCHAR2,
205 p_old_ATTRIBUTE13 in VARCHAR2,
206 p_new_ATTRIBUTE13 in VARCHAR2,
207 p_old_ATTRIBUTE14 in VARCHAR2,
208 p_new_ATTRIBUTE14 in VARCHAR2,
209 p_old_ATTRIBUTE15 in VARCHAR2,
210 p_new_ATTRIBUTE15 in VARCHAR2,
211 p_old_ATTRIBUTE16 in VARCHAR2,
212 p_new_ATTRIBUTE16 in VARCHAR2,
213 p_old_ATTRIBUTE17 in VARCHAR2,
214 p_new_ATTRIBUTE17 in VARCHAR2,
215 p_old_ATTRIBUTE18 in VARCHAR2,
216 p_new_ATTRIBUTE18 in VARCHAR2,
217 p_old_ATTRIBUTE19 in VARCHAR2,
218 p_new_ATTRIBUTE19 in VARCHAR2,
219 p_old_ATTRIBUTE2 in VARCHAR2,
220 p_new_ATTRIBUTE2 in VARCHAR2,
221 p_old_ATTRIBUTE20 in VARCHAR2,
222 p_new_ATTRIBUTE20 in VARCHAR2,
223 p_old_ATTRIBUTE3 in VARCHAR2,
224 p_new_ATTRIBUTE3 in VARCHAR2,
225 p_old_ATTRIBUTE4 in VARCHAR2,
226 p_new_ATTRIBUTE4 in VARCHAR2,
227 p_old_ATTRIBUTE5 in VARCHAR2,
228 p_new_ATTRIBUTE5 in VARCHAR2,
229 p_old_ATTRIBUTE6 in VARCHAR2,
230 p_new_ATTRIBUTE6 in VARCHAR2,
231 p_old_ATTRIBUTE7 in VARCHAR2,
232 p_new_ATTRIBUTE7 in VARCHAR2,
233 p_old_ATTRIBUTE8 in VARCHAR2,
234 p_new_ATTRIBUTE8 in VARCHAR2,
235 p_old_ATTRIBUTE9 in VARCHAR2,
236 p_new_ATTRIBUTE9 in VARCHAR2,
237 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
238 p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
239 p_old_COST_ALLOCATION_KEYFLEX in NUMBER,
240 p_new_COST_ALLOCATION_KEYFLEX in NUMBER,
241 p_old_DATE_EARNED in DATE,
242 p_new_DATE_EARNED in DATE,
243 p_old_EFFECTIVE_END_DATE in DATE,
244 p_new_EFFECTIVE_END_DATE in DATE,
245 p_old_EFFECTIVE_START_DATE in DATE,
246 p_new_EFFECTIVE_START_DATE in DATE,
247 p_old_ENTRY_INFORMATION1 in VARCHAR2,
248 p_new_ENTRY_INFORMATION1 in VARCHAR2,
249 p_old_ENTRY_INFORMATION10 in VARCHAR2,
250 p_new_ENTRY_INFORMATION10 in VARCHAR2,
251 p_old_ENTRY_INFORMATION11 in VARCHAR2,
252 p_new_ENTRY_INFORMATION11 in VARCHAR2,
253 p_old_ENTRY_INFORMATION12 in VARCHAR2,
254 p_new_ENTRY_INFORMATION12 in VARCHAR2,
255 p_old_ENTRY_INFORMATION13 in VARCHAR2,
256 p_new_ENTRY_INFORMATION13 in VARCHAR2,
257 p_old_ENTRY_INFORMATION14 in VARCHAR2,
258 p_new_ENTRY_INFORMATION14 in VARCHAR2,
259 p_old_ENTRY_INFORMATION15 in VARCHAR2,
260 p_new_ENTRY_INFORMATION15 in VARCHAR2,
261 p_old_ENTRY_INFORMATION16 in VARCHAR2,
262 p_new_ENTRY_INFORMATION16 in VARCHAR2,
263 p_old_ENTRY_INFORMATION17 in VARCHAR2,
264 p_new_ENTRY_INFORMATION17 in VARCHAR2,
265 p_old_ENTRY_INFORMATION18 in VARCHAR2,
266 p_new_ENTRY_INFORMATION18 in VARCHAR2,
267 p_old_ENTRY_INFORMATION19 in VARCHAR2,
268 p_new_ENTRY_INFORMATION19 in VARCHAR2,
269 p_old_ENTRY_INFORMATION2 in VARCHAR2,
270 p_new_ENTRY_INFORMATION2 in VARCHAR2,
271 p_old_ENTRY_INFORMATION20 in VARCHAR2,
272 p_new_ENTRY_INFORMATION20 in VARCHAR2,
273 p_old_ENTRY_INFORMATION21 in VARCHAR2,
274 p_new_ENTRY_INFORMATION21 in VARCHAR2,
275 p_old_ENTRY_INFORMATION22 in VARCHAR2,
276 p_new_ENTRY_INFORMATION22 in VARCHAR2,
277 p_old_ENTRY_INFORMATION23 in VARCHAR2,
278 p_new_ENTRY_INFORMATION23 in VARCHAR2,
279 p_old_ENTRY_INFORMATION24 in VARCHAR2,
280 p_new_ENTRY_INFORMATION24 in VARCHAR2,
281 p_old_ENTRY_INFORMATION25 in VARCHAR2,
282 p_new_ENTRY_INFORMATION25 in VARCHAR2,
283 p_old_ENTRY_INFORMATION26 in VARCHAR2,
284 p_new_ENTRY_INFORMATION26 in VARCHAR2,
285 p_old_ENTRY_INFORMATION27 in VARCHAR2,
286 p_new_ENTRY_INFORMATION27 in VARCHAR2,
287 p_old_ENTRY_INFORMATION28 in VARCHAR2,
288 p_new_ENTRY_INFORMATION28 in VARCHAR2,
289 p_old_ENTRY_INFORMATION29 in VARCHAR2,
290 p_new_ENTRY_INFORMATION29 in VARCHAR2,
291 p_old_ENTRY_INFORMATION3 in VARCHAR2,
292 p_new_ENTRY_INFORMATION3 in VARCHAR2,
293 p_old_ENTRY_INFORMATION30 in VARCHAR2,
294 p_new_ENTRY_INFORMATION30 in VARCHAR2,
295 p_old_ENTRY_INFORMATION4 in VARCHAR2,
296 p_new_ENTRY_INFORMATION4 in VARCHAR2,
297 p_old_ENTRY_INFORMATION5 in VARCHAR2,
298 p_new_ENTRY_INFORMATION5 in VARCHAR2,
299 p_old_ENTRY_INFORMATION6 in VARCHAR2,
300 p_new_ENTRY_INFORMATION6 in VARCHAR2,
301 p_old_ENTRY_INFORMATION7 in VARCHAR2,
302 p_new_ENTRY_INFORMATION7 in VARCHAR2,
303 p_old_ENTRY_INFORMATION8 in VARCHAR2,
304 p_new_ENTRY_INFORMATION8 in VARCHAR2,
305 p_old_ENTRY_INFORMATION9 in VARCHAR2,
306 p_new_ENTRY_INFORMATION9 in VARCHAR2,
307 p_old_ENTRY_INFORMATION_CATEGO in VARCHAR2,
308 p_new_ENTRY_INFORMATION_CATEGO in VARCHAR2,
309 p_old_ORIGINAL_ENTRY_ID in NUMBER,
310 p_new_ORIGINAL_ENTRY_ID in NUMBER,
311 p_old_PERSONAL_PAYMENT_METHOD_ in NUMBER,
312 p_new_PERSONAL_PAYMENT_METHOD_ in NUMBER,
313 p_old_REASON in VARCHAR2,
314 p_new_REASON in VARCHAR2,
315 p_old_SUBPRIORITY in NUMBER,
316 p_new_SUBPRIORITY in NUMBER,
317 p_old_UPDATING_ACTION_ID in NUMBER,
318 p_new_UPDATING_ACTION_ID in NUMBER,
319 p_old_ELEMENT_ENTRY_ID in number
320 );
321 --
322 procedure element_entries_ard(
323 p_business_group_id in number,
324 p_legislation_code in varchar2,
325 p_assignment_id in number,
326 p_old_ELEMENT_ENTRY_ID in number,
327 p_old_effective_start_date in date,
328 p_new_effective_start_date in date,
329 p_old_effective_end_date in date,
330 p_new_effective_end_date in date,
331 p_old_ELEMENT_TYPE_ID in number default null
332 );
333 --
334 procedure PER_CONTRACTS_F_aru(
335 p_business_group_id in number,
336 p_legislation_code in varchar2,
337 p_effective_date in date
338 ,
339 p_old_ATTRIBUTE1 in VARCHAR2,
340 p_new_ATTRIBUTE1 in VARCHAR2
341 ,
342 p_old_ATTRIBUTE10 in VARCHAR2,
343 p_new_ATTRIBUTE10 in VARCHAR2
344 ,
345 p_old_ATTRIBUTE11 in VARCHAR2,
346 p_new_ATTRIBUTE11 in VARCHAR2
347 ,
348 p_old_ATTRIBUTE12 in VARCHAR2,
349 p_new_ATTRIBUTE12 in VARCHAR2
350 ,
354 p_old_ATTRIBUTE14 in VARCHAR2,
351 p_old_ATTRIBUTE13 in VARCHAR2,
352 p_new_ATTRIBUTE13 in VARCHAR2
353 ,
355 p_new_ATTRIBUTE14 in VARCHAR2
356 ,
357 p_old_ATTRIBUTE15 in VARCHAR2,
358 p_new_ATTRIBUTE15 in VARCHAR2
359 ,
360 p_old_ATTRIBUTE16 in VARCHAR2,
361 p_new_ATTRIBUTE16 in VARCHAR2
362 ,
363 p_old_ATTRIBUTE17 in VARCHAR2,
364 p_new_ATTRIBUTE17 in VARCHAR2
365 ,
366 p_old_ATTRIBUTE18 in VARCHAR2,
367 p_new_ATTRIBUTE18 in VARCHAR2
368 ,
369 p_old_ATTRIBUTE19 in VARCHAR2,
370 p_new_ATTRIBUTE19 in VARCHAR2
371 ,
372 p_old_ATTRIBUTE2 in VARCHAR2,
373 p_new_ATTRIBUTE2 in VARCHAR2
374 ,
375 p_old_ATTRIBUTE20 in VARCHAR2,
376 p_new_ATTRIBUTE20 in VARCHAR2
377 ,
378 p_old_ATTRIBUTE3 in VARCHAR2,
379 p_new_ATTRIBUTE3 in VARCHAR2
380 ,
381 p_old_ATTRIBUTE4 in VARCHAR2,
382 p_new_ATTRIBUTE4 in VARCHAR2
383 ,
384 p_old_ATTRIBUTE5 in VARCHAR2,
385 p_new_ATTRIBUTE5 in VARCHAR2
386 ,
387 p_old_ATTRIBUTE6 in VARCHAR2,
388 p_new_ATTRIBUTE6 in VARCHAR2
389 ,
390 p_old_ATTRIBUTE7 in VARCHAR2,
391 p_new_ATTRIBUTE7 in VARCHAR2
392 ,
393 p_old_ATTRIBUTE8 in VARCHAR2,
394 p_new_ATTRIBUTE8 in VARCHAR2
395 ,
396 p_old_ATTRIBUTE9 in VARCHAR2,
397 p_new_ATTRIBUTE9 in VARCHAR2
398 ,
399 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
400 p_new_ATTRIBUTE_CATEGORY in VARCHAR2
401 ,
402 p_old_BUSINESS_GROUP_ID in NUMBER,
403 p_new_BUSINESS_GROUP_ID in NUMBER
404 ,
405 p_old_CONTRACTUAL_JOB_TITLE in VARCHAR2,
406 p_new_CONTRACTUAL_JOB_TITLE in VARCHAR2
407 ,
408 p_old_CONTRACT_ID in NUMBER,
409 p_new_CONTRACT_ID in NUMBER
410 ,
411 p_old_CTR_INFORMATION1 in VARCHAR2,
412 p_new_CTR_INFORMATION1 in VARCHAR2
413 ,
414 p_old_CTR_INFORMATION10 in VARCHAR2,
415 p_new_CTR_INFORMATION10 in VARCHAR2
416 ,
417 p_old_CTR_INFORMATION11 in VARCHAR2,
418 p_new_CTR_INFORMATION11 in VARCHAR2
419 ,
420 p_old_CTR_INFORMATION12 in VARCHAR2,
421 p_new_CTR_INFORMATION12 in VARCHAR2
422 ,
423 p_old_CTR_INFORMATION13 in VARCHAR2,
424 p_new_CTR_INFORMATION13 in VARCHAR2
425 ,
426 p_old_CTR_INFORMATION14 in VARCHAR2,
427 p_new_CTR_INFORMATION14 in VARCHAR2
428 ,
429 p_old_CTR_INFORMATION15 in VARCHAR2,
430 p_new_CTR_INFORMATION15 in VARCHAR2
431 ,
432 p_old_CTR_INFORMATION16 in VARCHAR2,
433 p_new_CTR_INFORMATION16 in VARCHAR2
434 ,
435 p_old_CTR_INFORMATION17 in VARCHAR2,
436 p_new_CTR_INFORMATION17 in VARCHAR2
437 ,
438 p_old_CTR_INFORMATION18 in VARCHAR2,
439 p_new_CTR_INFORMATION18 in VARCHAR2
440 ,
441 p_old_CTR_INFORMATION19 in VARCHAR2,
442 p_new_CTR_INFORMATION19 in VARCHAR2
443 ,
444 p_old_CTR_INFORMATION2 in VARCHAR2,
445 p_new_CTR_INFORMATION2 in VARCHAR2
446 ,
447 p_old_CTR_INFORMATION20 in VARCHAR2,
448 p_new_CTR_INFORMATION20 in VARCHAR2
449 ,
450 p_old_CTR_INFORMATION3 in VARCHAR2,
451 p_new_CTR_INFORMATION3 in VARCHAR2
452 ,
453 p_old_CTR_INFORMATION4 in VARCHAR2,
454 p_new_CTR_INFORMATION4 in VARCHAR2
455 ,
456 p_old_CTR_INFORMATION5 in VARCHAR2,
457 p_new_CTR_INFORMATION5 in VARCHAR2
458 ,
459 p_old_CTR_INFORMATION6 in VARCHAR2,
460 p_new_CTR_INFORMATION6 in VARCHAR2
461 ,
462 p_old_CTR_INFORMATION7 in VARCHAR2,
463 p_new_CTR_INFORMATION7 in VARCHAR2
464 ,
465 p_old_CTR_INFORMATION8 in VARCHAR2,
466 p_new_CTR_INFORMATION8 in VARCHAR2
467 ,
468 p_old_CTR_INFORMATION9 in VARCHAR2,
469 p_new_CTR_INFORMATION9 in VARCHAR2
470 ,
471 p_old_CTR_INFORMATION_CATEGORY in VARCHAR2,
472 p_new_CTR_INFORMATION_CATEGORY in VARCHAR2
473 ,
474 p_old_DESCRIPTION in VARCHAR2,
475 p_new_DESCRIPTION in VARCHAR2
476 ,
477 p_old_DOC_STATUS in VARCHAR2,
478 p_new_DOC_STATUS in VARCHAR2
479 ,
480 p_old_DOC_STATUS_CHANGE_DATE in DATE,
481 p_new_DOC_STATUS_CHANGE_DATE in DATE
482 ,
483 p_old_DURATION in NUMBER,
484 p_new_DURATION in NUMBER
485 ,
486 p_old_DURATION_UNITS in VARCHAR2,
487 p_new_DURATION_UNITS in VARCHAR2
488 ,
489 p_old_END_REASON in VARCHAR2,
490 p_new_END_REASON in VARCHAR2
491 ,
492 p_old_EXTENSION_PERIOD in NUMBER,
493 p_new_EXTENSION_PERIOD in NUMBER
494 ,
495 p_old_EXTENSION_PERIOD_UNITS in VARCHAR2,
496 p_new_EXTENSION_PERIOD_UNITS in VARCHAR2
497 ,
498 p_old_EXTENSION_REASON in VARCHAR2,
499 p_new_EXTENSION_REASON in VARCHAR2
500 ,
501 p_old_NUMBER_OF_EXTENSIONS in NUMBER,
502 p_new_NUMBER_OF_EXTENSIONS in NUMBER
503 ,
504 p_old_PARTIES in VARCHAR2,
505 p_new_PARTIES in VARCHAR2
506 ,
507 p_old_PERSON_ID in NUMBER,
508 p_new_PERSON_ID in NUMBER
509 ,
510 p_old_REFERENCE in VARCHAR2,
511 p_new_REFERENCE in VARCHAR2
515 ,
512 ,
513 p_old_START_REASON in VARCHAR2,
514 p_new_START_REASON in VARCHAR2
516 p_old_STATUS in VARCHAR2,
517 p_new_STATUS in VARCHAR2
518 ,
519 p_old_STATUS_REASON in VARCHAR2,
520 p_new_STATUS_REASON in VARCHAR2
521 ,
522 p_old_TYPE in VARCHAR2,
523 p_new_TYPE in VARCHAR2
524 ,
525
526 p_old_EFFECTIVE_END_DATE in DATE,
527 p_new_EFFECTIVE_END_DATE in DATE
528 ,
529 p_old_EFFECTIVE_START_DATE in DATE,
530 p_new_EFFECTIVE_START_DATE in DATE
531
532 );
533
534
535 procedure PER_ALL_ASSIGNMENTS_F_aru(
536 p_business_group_id in number,
537 p_legislation_code in varchar2,
538 p_effective_date in date,
539 p_old_APPLICATION_ID in NUMBER,
540 p_new_APPLICATION_ID in NUMBER,
541 p_old_ASSIGNMENT_ID in NUMBER,
542 p_new_ASSIGNMENT_ID in NUMBER,
543 p_old_ASSIGNMENT_NUMBER in VARCHAR2,
544 p_new_ASSIGNMENT_NUMBER in VARCHAR2,
545 p_old_ASSIGNMENT_SEQUENCE in NUMBER,
546 p_new_ASSIGNMENT_SEQUENCE in NUMBER,
547 p_old_ASSIGNMENT_STATUS_TYPE_I in NUMBER,
548 p_new_ASSIGNMENT_STATUS_TYPE_I in NUMBER,
549 p_old_ASSIGNMENT_TYPE in VARCHAR2,
550 p_new_ASSIGNMENT_TYPE in VARCHAR2,
551 p_old_ASS_ATTRIBUTE1 in VARCHAR2,
552 p_new_ASS_ATTRIBUTE1 in VARCHAR2,
553 p_old_ASS_ATTRIBUTE10 in VARCHAR2,
554 p_new_ASS_ATTRIBUTE10 in VARCHAR2,
555 p_old_ASS_ATTRIBUTE11 in VARCHAR2,
556 p_new_ASS_ATTRIBUTE11 in VARCHAR2,
557 p_old_ASS_ATTRIBUTE12 in VARCHAR2,
558 p_new_ASS_ATTRIBUTE12 in VARCHAR2,
559 p_old_ASS_ATTRIBUTE13 in VARCHAR2,
560 p_new_ASS_ATTRIBUTE13 in VARCHAR2,
561 p_old_ASS_ATTRIBUTE14 in VARCHAR2,
562 p_new_ASS_ATTRIBUTE14 in VARCHAR2,
563 p_old_ASS_ATTRIBUTE15 in VARCHAR2,
564 p_new_ASS_ATTRIBUTE15 in VARCHAR2,
565 p_old_ASS_ATTRIBUTE16 in VARCHAR2,
566 p_new_ASS_ATTRIBUTE16 in VARCHAR2,
567 p_old_ASS_ATTRIBUTE17 in VARCHAR2,
568 p_new_ASS_ATTRIBUTE17 in VARCHAR2,
569 p_old_ASS_ATTRIBUTE18 in VARCHAR2,
570 p_new_ASS_ATTRIBUTE18 in VARCHAR2,
571 p_old_ASS_ATTRIBUTE19 in VARCHAR2,
572 p_new_ASS_ATTRIBUTE19 in VARCHAR2,
573 p_old_ASS_ATTRIBUTE2 in VARCHAR2,
574 p_new_ASS_ATTRIBUTE2 in VARCHAR2,
575 p_old_ASS_ATTRIBUTE20 in VARCHAR2,
576 p_new_ASS_ATTRIBUTE20 in VARCHAR2,
577 p_old_ASS_ATTRIBUTE21 in VARCHAR2,
578 p_new_ASS_ATTRIBUTE21 in VARCHAR2,
579 p_old_ASS_ATTRIBUTE22 in VARCHAR2,
580 p_new_ASS_ATTRIBUTE22 in VARCHAR2,
581 p_old_ASS_ATTRIBUTE23 in VARCHAR2,
582 p_new_ASS_ATTRIBUTE23 in VARCHAR2,
583 p_old_ASS_ATTRIBUTE24 in VARCHAR2,
584 p_new_ASS_ATTRIBUTE24 in VARCHAR2,
585 p_old_ASS_ATTRIBUTE25 in VARCHAR2,
586 p_new_ASS_ATTRIBUTE25 in VARCHAR2,
587 p_old_ASS_ATTRIBUTE26 in VARCHAR2,
588 p_new_ASS_ATTRIBUTE26 in VARCHAR2,
589 p_old_ASS_ATTRIBUTE27 in VARCHAR2,
590 p_new_ASS_ATTRIBUTE27 in VARCHAR2,
591 p_old_ASS_ATTRIBUTE28 in VARCHAR2,
592 p_new_ASS_ATTRIBUTE28 in VARCHAR2,
593 p_old_ASS_ATTRIBUTE29 in VARCHAR2,
594 p_new_ASS_ATTRIBUTE29 in VARCHAR2,
595 p_old_ASS_ATTRIBUTE3 in VARCHAR2,
596 p_new_ASS_ATTRIBUTE3 in VARCHAR2,
597 p_old_ASS_ATTRIBUTE30 in VARCHAR2,
598 p_new_ASS_ATTRIBUTE30 in VARCHAR2,
599 p_old_ASS_ATTRIBUTE4 in VARCHAR2,
600 p_new_ASS_ATTRIBUTE4 in VARCHAR2,
601 p_old_ASS_ATTRIBUTE5 in VARCHAR2,
602 p_new_ASS_ATTRIBUTE5 in VARCHAR2,
603 p_old_ASS_ATTRIBUTE6 in VARCHAR2,
604 p_new_ASS_ATTRIBUTE6 in VARCHAR2,
605 p_old_ASS_ATTRIBUTE7 in VARCHAR2,
606 p_new_ASS_ATTRIBUTE7 in VARCHAR2,
607 p_old_ASS_ATTRIBUTE8 in VARCHAR2,
608 p_new_ASS_ATTRIBUTE8 in VARCHAR2,
609 p_old_ASS_ATTRIBUTE9 in VARCHAR2,
610 p_new_ASS_ATTRIBUTE9 in VARCHAR2,
611 p_old_ASS_ATTRIBUTE_CATEGORY in VARCHAR2,
612 p_new_ASS_ATTRIBUTE_CATEGORY in VARCHAR2,
613 p_old_BARGAINING_UNIT_CODE in VARCHAR2,
614 p_new_BARGAINING_UNIT_CODE in VARCHAR2,
615 p_old_BUSINESS_GROUP_ID in NUMBER,
616 p_new_BUSINESS_GROUP_ID in NUMBER,
617 p_old_CAGR_GRADE_DEF_ID in NUMBER,
618 p_new_CAGR_GRADE_DEF_ID in NUMBER,
619 p_old_CAGR_ID_FLEX_NUM in NUMBER,
620 p_new_CAGR_ID_FLEX_NUM in NUMBER,
621 p_old_CHANGE_REASON in VARCHAR2,
622 p_new_CHANGE_REASON in VARCHAR2,
623 p_old_COLLECTIVE_AGREEMENT_ID in NUMBER,
624 p_new_COLLECTIVE_AGREEMENT_ID in NUMBER,
625 p_old_COMMENT_ID in NUMBER,
626 p_new_COMMENT_ID in NUMBER,
627 p_old_CONTRACT_ID in NUMBER,
628 p_new_CONTRACT_ID in NUMBER,
629 p_old_DATE_PROBATION_END in DATE,
630 p_new_DATE_PROBATION_END in DATE,
631 p_old_DEFAULT_CODE_COMB_ID in NUMBER,
632 p_new_DEFAULT_CODE_COMB_ID in NUMBER,
633 p_old_EFFECTIVE_END_DATE in DATE,
634 p_new_EFFECTIVE_END_DATE in DATE,
635 p_old_EFFECTIVE_START_DATE in DATE,
636 p_new_EFFECTIVE_START_DATE in DATE,
637 p_old_EMPLOYMENT_CATEGORY in VARCHAR2,
638 p_new_EMPLOYMENT_CATEGORY in VARCHAR2,
639 p_old_ESTABLISHMENT_ID in NUMBER,
640 p_new_ESTABLISHMENT_ID in NUMBER,
641 p_old_FREQUENCY in VARCHAR2,
642 p_new_FREQUENCY in VARCHAR2,
643 p_old_GRADE_ID in NUMBER,
644 p_new_GRADE_ID in NUMBER,
645 p_old_HOURLY_SALARIED_CODE in VARCHAR2,
646 p_new_HOURLY_SALARIED_CODE in VARCHAR2,
647 p_old_INTERNAL_ADDRESS_LINE in VARCHAR2,
651 p_old_LABOUR_UNION_MEMBER_FLAG in VARCHAR2,
648 p_new_INTERNAL_ADDRESS_LINE in VARCHAR2,
649 p_old_JOB_ID in NUMBER,
650 p_new_JOB_ID in NUMBER,
652 p_new_LABOUR_UNION_MEMBER_FLAG in VARCHAR2,
653 p_old_LOCATION_ID in NUMBER,
654 p_new_LOCATION_ID in NUMBER,
655 p_old_MANAGER_FLAG in VARCHAR2,
656 p_new_MANAGER_FLAG in VARCHAR2,
657 p_old_NORMAL_HOURS in NUMBER,
658 p_new_NORMAL_HOURS in NUMBER,
659 p_old_OBJECT_VERSION_NUMBER in NUMBER,
660 p_new_OBJECT_VERSION_NUMBER in NUMBER,
661 p_old_ORGANIZATION_ID in NUMBER,
662 p_new_ORGANIZATION_ID in NUMBER,
663 p_old_PAYROLL_ID in NUMBER,
664 p_new_PAYROLL_ID in NUMBER,
665 p_old_PAY_BASIS_ID in NUMBER,
666 p_new_PAY_BASIS_ID in NUMBER,
667 p_old_PEOPLE_GROUP_ID in NUMBER,
668 p_new_PEOPLE_GROUP_ID in NUMBER,
669 p_old_PERF_REVIEW_PERIOD in NUMBER,
670 p_new_PERF_REVIEW_PERIOD in NUMBER,
671 p_old_PERF_REVIEW_PERIOD_FREQU in VARCHAR2,
672 p_new_PERF_REVIEW_PERIOD_FREQU in VARCHAR2,
673 p_old_PERIOD_OF_SERVICE_ID in NUMBER,
674 p_new_PERIOD_OF_SERVICE_ID in NUMBER,
675 p_old_PERSON_ID in NUMBER,
676 p_new_PERSON_ID in NUMBER,
677 p_old_PERSON_REFERRED_BY_ID in NUMBER,
678 p_new_PERSON_REFERRED_BY_ID in NUMBER,
679 p_old_POSITION_ID in NUMBER,
680 p_new_POSITION_ID in NUMBER,
681 p_old_PRIMARY_FLAG in VARCHAR2,
682 p_new_PRIMARY_FLAG in VARCHAR2,
683 p_old_PROBATION_PERIOD in NUMBER,
684 p_new_PROBATION_PERIOD in NUMBER,
685 p_old_PROBATION_UNIT in VARCHAR2,
686 p_new_PROBATION_UNIT in VARCHAR2,
687 p_old_PROGRAM_APPLICATION_ID in NUMBER,
688 p_new_PROGRAM_APPLICATION_ID in NUMBER,
689 p_old_PROGRAM_ID in NUMBER,
690 p_new_PROGRAM_ID in NUMBER,
691 p_old_PROGRAM_UPDATE_DATE in DATE,
692 p_new_PROGRAM_UPDATE_DATE in DATE,
693 p_old_RECRUITER_ID in NUMBER,
694 p_new_RECRUITER_ID in NUMBER,
695 p_old_RECRUITMENT_ACTIVITY_ID in NUMBER,
696 p_new_RECRUITMENT_ACTIVITY_ID in NUMBER,
697 p_old_REQUEST_ID in NUMBER,
698 p_new_REQUEST_ID in NUMBER,
699 p_old_SAL_REVIEW_PERIOD in NUMBER,
700 p_new_SAL_REVIEW_PERIOD in NUMBER,
701 p_old_SAL_REVIEW_PERIOD_FREQUE in VARCHAR2,
702 p_new_SAL_REVIEW_PERIOD_FREQUE in VARCHAR2,
703 p_old_SET_OF_BOOKS_ID in NUMBER,
704 p_new_SET_OF_BOOKS_ID in NUMBER,
705 p_old_SOFT_CODING_KEYFLEX_ID in NUMBER,
706 p_new_SOFT_CODING_KEYFLEX_ID in NUMBER,
707 p_old_SOURCE_ORGANIZATION_ID in NUMBER,
708 p_new_SOURCE_ORGANIZATION_ID in NUMBER,
709 p_old_SOURCE_TYPE in VARCHAR2,
710 p_new_SOURCE_TYPE in VARCHAR2,
711 p_old_SPECIAL_CEILING_STEP_ID in NUMBER,
712 p_new_SPECIAL_CEILING_STEP_ID in NUMBER,
713 p_old_SUPERVISOR_ID in NUMBER,
714 p_new_SUPERVISOR_ID in NUMBER,
715 p_old_TIME_NORMAL_FINISH in VARCHAR2,
716 p_new_TIME_NORMAL_FINISH in VARCHAR2,
717 p_old_TIME_NORMAL_START in VARCHAR2,
718 p_new_TIME_NORMAL_START in VARCHAR2,
719 p_old_TITLE in VARCHAR2,
720 p_new_TITLE in VARCHAR2,
721 p_old_VACANCY_ID in NUMBER,
722 p_new_VACANCY_ID in NUMBER,
723 p_old_PROJECTED_ASSIGNMENT_END in DATE default null,
724 p_new_PROJECTED_ASSIGNMENT_END in DATE default null
725 );
726 --
727 procedure PER_ALL_ASSIGNMENTS_F_ari(
728 p_business_group_id in number,
729 p_legislation_code in varchar2,
730 p_assignment_id in number,
731 p_effective_start_date in date
732 );
733 --
734 procedure per_all_assignments_f_ard(
735 p_business_group_id in number,
736 p_legislation_code in varchar2,
737 p_assignment_id in number,
738 p_effective_start_date in date
739 );
740
741
742 --
743 procedure personal_payment_methods_ari(
744 p_business_group_id in number,
745 p_legislation_code in varchar2,
746 p_assignment_id in number,
747 p_effective_start_date in date,
748 p_payment_method_id in number
749 );
750
751 procedure personal_payment_methods_ard(
752 p_business_group_id in number,
753 p_legislation_code in varchar2,
754 p_assignment_id in number,
755 p_effective_start_date in date,
756 p_payment_method_id in number
757 );
758 --
759 procedure PERSONAL_PAYMENT_METHODS_F_aru(
760 p_business_group_id in number,
761 p_legislation_code in varchar2,
762 p_effective_date in date,
763 p_old_AMOUNT in NUMBER,
764 p_new_AMOUNT in NUMBER,
765 p_old_ASSIGNMENT_ID in NUMBER,
766 p_new_ASSIGNMENT_ID in NUMBER,
767 p_old_ATTRIBUTE1 in VARCHAR2,
768 p_new_ATTRIBUTE1 in VARCHAR2,
769 p_old_ATTRIBUTE10 in VARCHAR2,
770 p_new_ATTRIBUTE10 in VARCHAR2,
771 p_old_ATTRIBUTE11 in VARCHAR2,
772 p_new_ATTRIBUTE11 in VARCHAR2,
773 p_old_ATTRIBUTE12 in VARCHAR2,
774 p_new_ATTRIBUTE12 in VARCHAR2,
778 p_new_ATTRIBUTE14 in VARCHAR2,
775 p_old_ATTRIBUTE13 in VARCHAR2,
776 p_new_ATTRIBUTE13 in VARCHAR2,
777 p_old_ATTRIBUTE14 in VARCHAR2,
779 p_old_ATTRIBUTE15 in VARCHAR2,
780 p_new_ATTRIBUTE15 in VARCHAR2,
781 p_old_ATTRIBUTE16 in VARCHAR2,
782 p_new_ATTRIBUTE16 in VARCHAR2,
783 p_old_ATTRIBUTE17 in VARCHAR2,
784 p_new_ATTRIBUTE17 in VARCHAR2,
785 p_old_ATTRIBUTE18 in VARCHAR2,
786 p_new_ATTRIBUTE18 in VARCHAR2,
787 p_old_ATTRIBUTE19 in VARCHAR2,
788 p_new_ATTRIBUTE19 in VARCHAR2,
789 p_old_ATTRIBUTE2 in VARCHAR2,
790 p_new_ATTRIBUTE2 in VARCHAR2,
791 p_old_ATTRIBUTE20 in VARCHAR2,
792 p_new_ATTRIBUTE20 in VARCHAR2,
793 p_old_ATTRIBUTE3 in VARCHAR2,
794 p_new_ATTRIBUTE3 in VARCHAR2,
795 p_old_ATTRIBUTE4 in VARCHAR2,
796 p_new_ATTRIBUTE4 in VARCHAR2,
797 p_old_ATTRIBUTE5 in VARCHAR2,
798 p_new_ATTRIBUTE5 in VARCHAR2,
799 p_old_ATTRIBUTE6 in VARCHAR2,
800 p_new_ATTRIBUTE6 in VARCHAR2,
801 p_old_ATTRIBUTE7 in VARCHAR2,
802 p_new_ATTRIBUTE7 in VARCHAR2,
803 p_old_ATTRIBUTE8 in VARCHAR2,
804 p_new_ATTRIBUTE8 in VARCHAR2,
805 p_old_ATTRIBUTE9 in VARCHAR2,
806 p_new_ATTRIBUTE9 in VARCHAR2,
807 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
808 p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
809 p_old_COMMENT_ID in NUMBER,
810 p_new_COMMENT_ID in NUMBER,
811 p_old_EFFECTIVE_END_DATE in DATE,
812 p_new_EFFECTIVE_END_DATE in DATE,
813 p_old_EFFECTIVE_START_DATE in DATE,
814 p_new_EFFECTIVE_START_DATE in DATE,
815 p_old_EXTERNAL_ACCOUNT_ID in NUMBER,
816 p_new_EXTERNAL_ACCOUNT_ID in NUMBER,
817 p_old_ORG_PAYMENT_METHOD_ID in NUMBER,
818 p_new_ORG_PAYMENT_METHOD_ID in NUMBER,
819 p_old_PAYEE_ID in NUMBER,
820 p_new_PAYEE_ID in NUMBER,
821 p_old_PAYEE_TYPE in VARCHAR2,
822 p_new_PAYEE_TYPE in VARCHAR2,
823 p_old_PERCENTAGE in NUMBER,
824 p_new_PERCENTAGE in NUMBER,
825 p_old_PERSONAL_PAYMENT_METHOD_ in NUMBER,
826 p_new_PERSONAL_PAYMENT_METHOD_ in NUMBER,
827 p_old_PRIORITY in NUMBER,
828 p_new_PRIORITY in NUMBER
829 );
830 --
831 procedure PAY_ELEMENT_LINKS_F_aru(
832 p_business_group_id in number,
833 p_legislation_code in varchar2,
834 p_effective_date in date,
835 p_old_ATTRIBUTE1 in VARCHAR2,
836 p_new_ATTRIBUTE1 in VARCHAR2,
837 p_old_ATTRIBUTE10 in VARCHAR2,
838 p_new_ATTRIBUTE10 in VARCHAR2,
839 p_old_ATTRIBUTE11 in VARCHAR2,
840 p_new_ATTRIBUTE11 in VARCHAR2,
841 p_old_ATTRIBUTE12 in VARCHAR2,
842 p_new_ATTRIBUTE12 in VARCHAR2,
843 p_old_ATTRIBUTE13 in VARCHAR2,
844 p_new_ATTRIBUTE13 in VARCHAR2,
845 p_old_ATTRIBUTE14 in VARCHAR2,
846 p_new_ATTRIBUTE14 in VARCHAR2,
847 p_old_ATTRIBUTE15 in VARCHAR2,
848 p_new_ATTRIBUTE15 in VARCHAR2,
849 p_old_ATTRIBUTE16 in VARCHAR2,
850 p_new_ATTRIBUTE16 in VARCHAR2,
851 p_old_ATTRIBUTE17 in VARCHAR2,
852 p_new_ATTRIBUTE17 in VARCHAR2,
853 p_old_ATTRIBUTE18 in VARCHAR2,
854 p_new_ATTRIBUTE18 in VARCHAR2,
855 p_old_ATTRIBUTE19 in VARCHAR2,
856 p_new_ATTRIBUTE19 in VARCHAR2,
857 p_old_ATTRIBUTE2 in VARCHAR2,
858 p_new_ATTRIBUTE2 in VARCHAR2,
859 p_old_ATTRIBUTE20 in VARCHAR2,
860 p_new_ATTRIBUTE20 in VARCHAR2,
861 p_old_ATTRIBUTE3 in VARCHAR2,
862 p_new_ATTRIBUTE3 in VARCHAR2,
863 p_old_ATTRIBUTE4 in VARCHAR2,
864 p_new_ATTRIBUTE4 in VARCHAR2,
865 p_old_ATTRIBUTE5 in VARCHAR2,
866 p_new_ATTRIBUTE5 in VARCHAR2,
867 p_old_ATTRIBUTE6 in VARCHAR2,
868 p_new_ATTRIBUTE6 in VARCHAR2,
869 p_old_ATTRIBUTE7 in VARCHAR2,
870 p_new_ATTRIBUTE7 in VARCHAR2,
871 p_old_ATTRIBUTE8 in VARCHAR2,
872 p_new_ATTRIBUTE8 in VARCHAR2,
873 p_old_ATTRIBUTE9 in VARCHAR2,
874 p_new_ATTRIBUTE9 in VARCHAR2,
875 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
876 p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
877 p_old_BALANCING_KEYFLEX_ID in NUMBER,
878 p_new_BALANCING_KEYFLEX_ID in NUMBER,
879 p_old_COSTABLE_TYPE in VARCHAR2,
880 p_new_COSTABLE_TYPE in VARCHAR2,
881 p_old_COST_ALLOCATION_KEYFLEX in NUMBER,
882 p_new_COST_ALLOCATION_KEYFLEX in NUMBER,
883 p_old_ELEMENT_LINK_ID in NUMBER,
884 p_new_ELEMENT_LINK_ID in NUMBER,
885 p_old_ELEMENT_SET_ID in NUMBER,
886 p_new_ELEMENT_SET_ID in NUMBER,
887 p_old_ELEMENT_TYPE_ID in NUMBER,
888 p_new_ELEMENT_TYPE_ID in NUMBER,
889 p_old_EFFECTIVE_END_DATE in DATE,
890 p_new_EFFECTIVE_END_DATE in DATE,
891 p_old_EFFECTIVE_START_DATE in DATE,
892 p_new_EFFECTIVE_START_DATE in DATE
893 );
894 --
895 procedure PAY_ALL_PAYROLLS_F_aru(
896 p_business_group_id in number,
897 p_legislation_code in varchar2,
898 p_effective_date in date,
899 p_old_ATTRIBUTE1 in VARCHAR2,
900 p_new_ATTRIBUTE1 in VARCHAR2,
901 p_old_ATTRIBUTE10 in VARCHAR2,
902 p_new_ATTRIBUTE10 in VARCHAR2,
903 p_old_ATTRIBUTE11 in VARCHAR2,
904 p_new_ATTRIBUTE11 in VARCHAR2,
905 p_old_ATTRIBUTE12 in VARCHAR2,
906 p_new_ATTRIBUTE12 in VARCHAR2,
907 p_old_ATTRIBUTE13 in VARCHAR2,
908 p_new_ATTRIBUTE13 in VARCHAR2,
909 p_old_ATTRIBUTE14 in VARCHAR2,
910 p_new_ATTRIBUTE14 in VARCHAR2,
911 p_old_ATTRIBUTE15 in VARCHAR2,
912 p_new_ATTRIBUTE15 in VARCHAR2,
913 p_old_ATTRIBUTE16 in VARCHAR2,
914 p_new_ATTRIBUTE16 in VARCHAR2,
915 p_old_ATTRIBUTE17 in VARCHAR2,
916 p_new_ATTRIBUTE17 in VARCHAR2,
917 p_old_ATTRIBUTE18 in VARCHAR2,
918 p_new_ATTRIBUTE18 in VARCHAR2,
919 p_old_ATTRIBUTE19 in VARCHAR2,
920 p_new_ATTRIBUTE19 in VARCHAR2,
924 p_new_ATTRIBUTE20 in VARCHAR2,
921 p_old_ATTRIBUTE2 in VARCHAR2,
922 p_new_ATTRIBUTE2 in VARCHAR2,
923 p_old_ATTRIBUTE20 in VARCHAR2,
925 p_old_ATTRIBUTE3 in VARCHAR2,
926 p_new_ATTRIBUTE3 in VARCHAR2,
927 p_old_ATTRIBUTE4 in VARCHAR2,
928 p_new_ATTRIBUTE4 in VARCHAR2,
929 p_old_ATTRIBUTE5 in VARCHAR2,
930 p_new_ATTRIBUTE5 in VARCHAR2,
931 p_old_ATTRIBUTE6 in VARCHAR2,
932 p_new_ATTRIBUTE6 in VARCHAR2,
933 p_old_ATTRIBUTE7 in VARCHAR2,
934 p_new_ATTRIBUTE7 in VARCHAR2,
935 p_old_ATTRIBUTE8 in VARCHAR2,
936 p_new_ATTRIBUTE8 in VARCHAR2,
937 p_old_ATTRIBUTE9 in VARCHAR2,
938 p_new_ATTRIBUTE9 in VARCHAR2,
939 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
940 p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
941 p_old_COST_ALLOCATION_KEYFLEX_ in NUMBER,
942 p_new_COST_ALLOCATION_KEYFLEX_ in NUMBER,
943 p_old_DEFAULT_PAYMENT_METHOD_I in NUMBER,
944 p_new_DEFAULT_PAYMENT_METHOD_I in NUMBER,
945 p_old_PAYROLL_ID in NUMBER,
946 p_new_PAYROLL_ID in NUMBER,
947 p_old_PRL_INFORMATION1 in VARCHAR2,
948 p_new_PRL_INFORMATION1 in VARCHAR2,
949 p_old_PRL_INFORMATION10 in VARCHAR2,
950 p_new_PRL_INFORMATION10 in VARCHAR2,
951 p_old_PRL_INFORMATION11 in VARCHAR2,
952 p_new_PRL_INFORMATION11 in VARCHAR2,
953 p_old_PRL_INFORMATION12 in VARCHAR2,
954 p_new_PRL_INFORMATION12 in VARCHAR2,
955 p_old_PRL_INFORMATION13 in VARCHAR2,
956 p_new_PRL_INFORMATION13 in VARCHAR2,
957 p_old_PRL_INFORMATION14 in VARCHAR2,
958 p_new_PRL_INFORMATION14 in VARCHAR2,
959 p_old_PRL_INFORMATION15 in VARCHAR2,
960 p_new_PRL_INFORMATION15 in VARCHAR2,
961 p_old_PRL_INFORMATION16 in VARCHAR2,
962 p_new_PRL_INFORMATION16 in VARCHAR2,
963 p_old_PRL_INFORMATION17 in VARCHAR2,
964 p_new_PRL_INFORMATION17 in VARCHAR2,
965 p_old_PRL_INFORMATION18 in VARCHAR2,
966 p_new_PRL_INFORMATION18 in VARCHAR2,
967 p_old_PRL_INFORMATION19 in VARCHAR2,
968 p_new_PRL_INFORMATION19 in VARCHAR2,
969 p_old_PRL_INFORMATION2 in VARCHAR2,
970 p_new_PRL_INFORMATION2 in VARCHAR2,
971 p_old_PRL_INFORMATION20 in VARCHAR2,
972 p_new_PRL_INFORMATION20 in VARCHAR2,
973 p_old_PRL_INFORMATION21 in VARCHAR2,
974 p_new_PRL_INFORMATION21 in VARCHAR2,
975 p_old_PRL_INFORMATION22 in VARCHAR2,
976 p_new_PRL_INFORMATION22 in VARCHAR2,
977 p_old_PRL_INFORMATION23 in VARCHAR2,
978 p_new_PRL_INFORMATION23 in VARCHAR2,
979 p_old_PRL_INFORMATION24 in VARCHAR2,
980 p_new_PRL_INFORMATION24 in VARCHAR2,
981 p_old_PRL_INFORMATION25 in VARCHAR2,
982 p_new_PRL_INFORMATION25 in VARCHAR2,
983 p_old_PRL_INFORMATION26 in VARCHAR2,
984 p_new_PRL_INFORMATION26 in VARCHAR2,
985 p_old_PRL_INFORMATION27 in VARCHAR2,
986 p_new_PRL_INFORMATION27 in VARCHAR2,
987 p_old_PRL_INFORMATION28 in VARCHAR2,
988 p_new_PRL_INFORMATION28 in VARCHAR2,
989 p_old_PRL_INFORMATION29 in VARCHAR2,
990 p_new_PRL_INFORMATION29 in VARCHAR2,
991 p_old_PRL_INFORMATION3 in VARCHAR2,
992 p_new_PRL_INFORMATION3 in VARCHAR2,
993 p_old_PRL_INFORMATION30 in VARCHAR2,
994 p_new_PRL_INFORMATION30 in VARCHAR2,
995 p_old_PRL_INFORMATION4 in VARCHAR2,
996 p_new_PRL_INFORMATION4 in VARCHAR2,
997 p_old_PRL_INFORMATION5 in VARCHAR2,
998 p_new_PRL_INFORMATION5 in VARCHAR2,
999 p_old_PRL_INFORMATION6 in VARCHAR2,
1000 p_new_PRL_INFORMATION6 in VARCHAR2,
1001 p_old_PRL_INFORMATION7 in VARCHAR2,
1002 p_new_PRL_INFORMATION7 in VARCHAR2,
1003 p_old_PRL_INFORMATION8 in VARCHAR2,
1004 p_new_PRL_INFORMATION8 in VARCHAR2,
1005 p_old_PRL_INFORMATION9 in VARCHAR2,
1006 p_new_PRL_INFORMATION9 in VARCHAR2,
1007 p_old_PRL_INFORMATION_CATEGORY in VARCHAR2,
1008 p_new_PRL_INFORMATION_CATEGORY in VARCHAR2,
1009 p_old_SOFT_CODING_KEYFLEX_ID in NUMBER,
1010 p_new_SOFT_CODING_KEYFLEX_ID in NUMBER,
1011 p_old_SUSPENSE_ACCOUNT_KEYFLEX in NUMBER,
1012 p_new_SUSPENSE_ACCOUNT_KEYFLEX in NUMBER,
1013 p_old_EFFECTIVE_END_DATE in DATE,
1014 p_new_EFFECTIVE_END_DATE in DATE,
1015 p_old_EFFECTIVE_START_DATE in DATE,
1016 p_new_EFFECTIVE_START_DATE in DATE
1017 );
1018 --
1019 procedure PAY_ELEMENT_TYPES_F_aru(
1020 p_business_group_id in number,
1021 p_legislation_code in varchar2,
1022 p_effective_date in date,
1023 p_old_ATTRIBUTE1 in VARCHAR2,
1024 p_new_ATTRIBUTE1 in VARCHAR2,
1025 p_old_ATTRIBUTE10 in VARCHAR2,
1026 p_new_ATTRIBUTE10 in VARCHAR2,
1027 p_old_ATTRIBUTE11 in VARCHAR2,
1028 p_new_ATTRIBUTE11 in VARCHAR2,
1029 p_old_ATTRIBUTE12 in VARCHAR2,
1030 p_new_ATTRIBUTE12 in VARCHAR2,
1031 p_old_ATTRIBUTE13 in VARCHAR2,
1032 p_new_ATTRIBUTE13 in VARCHAR2,
1033 p_old_ATTRIBUTE14 in VARCHAR2,
1034 p_new_ATTRIBUTE14 in VARCHAR2,
1035 p_old_ATTRIBUTE15 in VARCHAR2,
1036 p_new_ATTRIBUTE15 in VARCHAR2,
1037 p_old_ATTRIBUTE16 in VARCHAR2,
1038 p_new_ATTRIBUTE16 in VARCHAR2,
1039 p_old_ATTRIBUTE17 in VARCHAR2,
1040 p_new_ATTRIBUTE17 in VARCHAR2,
1041 p_old_ATTRIBUTE18 in VARCHAR2,
1042 p_new_ATTRIBUTE18 in VARCHAR2,
1043 p_old_ATTRIBUTE19 in VARCHAR2,
1044 p_new_ATTRIBUTE19 in VARCHAR2,
1045 p_old_ATTRIBUTE2 in VARCHAR2,
1046 p_new_ATTRIBUTE2 in VARCHAR2,
1047 p_old_ATTRIBUTE20 in VARCHAR2,
1048 p_new_ATTRIBUTE20 in VARCHAR2,
1049 p_old_ATTRIBUTE3 in VARCHAR2,
1050 p_new_ATTRIBUTE3 in VARCHAR2,
1051 p_old_ATTRIBUTE4 in VARCHAR2,
1052 p_new_ATTRIBUTE4 in VARCHAR2,
1053 p_old_ATTRIBUTE5 in VARCHAR2,
1054 p_new_ATTRIBUTE5 in VARCHAR2,
1055 p_old_ATTRIBUTE6 in VARCHAR2,
1056 p_new_ATTRIBUTE6 in VARCHAR2,
1057 p_old_ATTRIBUTE7 in VARCHAR2,
1058 p_new_ATTRIBUTE7 in VARCHAR2,
1062 p_new_ATTRIBUTE9 in VARCHAR2,
1059 p_old_ATTRIBUTE8 in VARCHAR2,
1060 p_new_ATTRIBUTE8 in VARCHAR2,
1061 p_old_ATTRIBUTE9 in VARCHAR2,
1063 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
1064 p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
1065 p_old_ELEMENT_INFORMATION1 in VARCHAR2,
1066 p_new_ELEMENT_INFORMATION1 in VARCHAR2,
1067 p_old_ELEMENT_INFORMATION10 in VARCHAR2,
1068 p_new_ELEMENT_INFORMATION10 in VARCHAR2,
1069 p_old_ELEMENT_INFORMATION11 in VARCHAR2,
1070 p_new_ELEMENT_INFORMATION11 in VARCHAR2,
1071 p_old_ELEMENT_INFORMATION12 in VARCHAR2,
1072 p_new_ELEMENT_INFORMATION12 in VARCHAR2,
1073 p_old_ELEMENT_INFORMATION13 in VARCHAR2,
1074 p_new_ELEMENT_INFORMATION13 in VARCHAR2,
1075 p_old_ELEMENT_INFORMATION14 in VARCHAR2,
1076 p_new_ELEMENT_INFORMATION14 in VARCHAR2,
1077 p_old_ELEMENT_INFORMATION15 in VARCHAR2,
1078 p_new_ELEMENT_INFORMATION15 in VARCHAR2,
1079 p_old_ELEMENT_INFORMATION16 in VARCHAR2,
1080 p_new_ELEMENT_INFORMATION16 in VARCHAR2,
1081 p_old_ELEMENT_INFORMATION17 in VARCHAR2,
1082 p_new_ELEMENT_INFORMATION17 in VARCHAR2,
1083 p_old_ELEMENT_INFORMATION18 in VARCHAR2,
1084 p_new_ELEMENT_INFORMATION18 in VARCHAR2,
1085 p_old_ELEMENT_INFORMATION19 in VARCHAR2,
1086 p_new_ELEMENT_INFORMATION19 in VARCHAR2,
1087 p_old_ELEMENT_INFORMATION2 in VARCHAR2,
1088 p_new_ELEMENT_INFORMATION2 in VARCHAR2,
1089 p_old_ELEMENT_INFORMATION20 in VARCHAR2,
1090 p_new_ELEMENT_INFORMATION20 in VARCHAR2,
1091 p_old_ELEMENT_INFORMATION3 in VARCHAR2,
1092 p_new_ELEMENT_INFORMATION3 in VARCHAR2,
1093 p_old_ELEMENT_INFORMATION4 in VARCHAR2,
1094 p_new_ELEMENT_INFORMATION4 in VARCHAR2,
1095 p_old_ELEMENT_INFORMATION5 in VARCHAR2,
1096 p_new_ELEMENT_INFORMATION5 in VARCHAR2,
1097 p_old_ELEMENT_INFORMATION6 in VARCHAR2,
1098 p_new_ELEMENT_INFORMATION6 in VARCHAR2,
1099 p_old_ELEMENT_INFORMATION7 in VARCHAR2,
1100 p_new_ELEMENT_INFORMATION7 in VARCHAR2,
1101 p_old_ELEMENT_INFORMATION8 in VARCHAR2,
1102 p_new_ELEMENT_INFORMATION8 in VARCHAR2,
1103 p_old_ELEMENT_INFORMATION9 in VARCHAR2,
1104 p_new_ELEMENT_INFORMATION9 in VARCHAR2,
1105 p_old_ELEMENT_INFORMATION_CATE in VARCHAR2,
1106 p_new_ELEMENT_INFORMATION_CATE in VARCHAR2,
1107 p_old_ELEMENT_TYPE_ID in NUMBER,
1108 p_new_ELEMENT_TYPE_ID in NUMBER,
1109 p_old_GROSSUP_FLAG in VARCHAR2,
1110 p_new_GROSSUP_FLAG in VARCHAR2,
1111 p_old_ITERATIVE_FLAG in VARCHAR2,
1112 p_new_ITERATIVE_FLAG in VARCHAR2,
1113 p_old_ITERATIVE_FORMULA_ID in NUMBER,
1114 p_new_ITERATIVE_FORMULA_ID in NUMBER,
1115 p_old_ITERATIVE_PRIORITY in NUMBER,
1116 p_new_ITERATIVE_PRIORITY in NUMBER,
1117 p_old_POST_TERMINATION_RULE in VARCHAR2,
1118 p_new_POST_TERMINATION_RULE in VARCHAR2,
1119 p_old_PROCESSING_PRIORITY in NUMBER,
1120 p_new_PROCESSING_PRIORITY in NUMBER,
1121 p_old_PROCESS_MODE in VARCHAR2,
1122 p_new_PROCESS_MODE in VARCHAR2,
1123 p_old_EFFECTIVE_END_DATE in DATE,
1124 p_new_EFFECTIVE_END_DATE in DATE,
1125 p_old_EFFECTIVE_START_DATE in DATE,
1126 p_new_EFFECTIVE_START_DATE in DATE
1127 );
1128 --
1129 procedure PAY_LINK_INPUT_VALUES_F_aru(
1130 p_business_group_id in number,
1131 p_legislation_code in varchar2,
1132 p_effective_date in date,
1133 p_old_COSTED_FLAG in VARCHAR2,
1134 p_new_COSTED_FLAG in VARCHAR2 ,
1135 p_old_DEFAULT_VALUE in VARCHAR2,
1136 p_new_DEFAULT_VALUE in VARCHAR2 ,
1137 p_old_ELEMENT_LINK_ID in NUMBER,
1138 p_new_ELEMENT_LINK_ID in NUMBER ,
1139 p_old_INPUT_VALUE_ID in NUMBER,
1140 p_new_INPUT_VALUE_ID in NUMBER ,
1141 p_old_LINK_INPUT_VALUE_ID in NUMBER,
1142 p_new_LINK_INPUT_VALUE_ID in NUMBER ,
1143 p_old_MAX_VALUE in VARCHAR2,
1144 p_new_MAX_VALUE in VARCHAR2 ,
1145 p_old_MIN_VALUE in VARCHAR2,
1146 p_new_MIN_VALUE in VARCHAR2 ,
1147 p_old_WARNING_OR_ERROR in VARCHAR2,
1148 p_new_WARNING_OR_ERROR in VARCHAR2 ,
1149 p_old_EFFECTIVE_END_DATE in DATE,
1150 p_new_EFFECTIVE_END_DATE in DATE ,
1151 p_old_EFFECTIVE_START_DATE in DATE,
1152 p_new_EFFECTIVE_START_DATE in DATE
1153 );
1154 --
1155 procedure PAY_INPUT_VALUES_F_aru(
1156 p_business_group_id in number,
1157 p_legislation_code in varchar2,
1158 p_effective_date in date ,
1159 p_old_DEFAULT_VALUE in VARCHAR2,
1160 p_new_DEFAULT_VALUE in VARCHAR2 ,
1161 p_old_DISPLAY_SEQUENCE in NUMBER,
1162 p_new_DISPLAY_SEQUENCE in NUMBER ,
1163 p_old_ELEMENT_TYPE_ID in NUMBER,
1164 p_new_ELEMENT_TYPE_ID in NUMBER ,
1165 p_old_FORMULA_ID in NUMBER,
1166 p_new_FORMULA_ID in NUMBER ,
1167 p_old_GENERATE_DB_ITEMS_FLAG in VARCHAR2,
1168 p_new_GENERATE_DB_ITEMS_FLAG in VARCHAR2 ,
1169 p_old_HOT_DEFAULT_FLAG in VARCHAR2,
1170 p_new_HOT_DEFAULT_FLAG in VARCHAR2 ,
1171 p_old_INPUT_VALUE_ID in NUMBER,
1172 p_new_INPUT_VALUE_ID in NUMBER ,
1173 p_old_LEGISLATION_SUBGROUP in VARCHAR2,
1174 p_new_LEGISLATION_SUBGROUP in VARCHAR2 ,
1175 p_old_LOOKUP_TYPE in VARCHAR2,
1176 p_new_LOOKUP_TYPE in VARCHAR2 ,
1177 p_old_MANDATORY_FLAG in VARCHAR2,
1178 p_new_MANDATORY_FLAG in VARCHAR2 ,
1179 p_old_MAX_VALUE in VARCHAR2,
1180 p_new_MAX_VALUE in VARCHAR2 ,
1181 p_old_MIN_VALUE in VARCHAR2,
1182 p_new_MIN_VALUE in VARCHAR2 ,
1183 p_old_UOM in VARCHAR2,
1184 p_new_UOM in VARCHAR2 ,
1185 p_old_WARNING_OR_ERROR in VARCHAR2,
1186 p_new_WARNING_OR_ERROR in VARCHAR2 ,
1187 p_old_EFFECTIVE_END_DATE in DATE,
1188 p_new_EFFECTIVE_END_DATE in DATE ,
1189 p_old_EFFECTIVE_START_DATE in DATE,
1190 p_new_EFFECTIVE_START_DATE in DATE
1191 );
1192 --
1193 procedure PAY_GRADE_RULES_F_aru(
1194 p_business_group_id in number,
1198 p_new_GRADE_OR_SPINAL_POINT_ID in NUMBER ,
1195 p_legislation_code in varchar2,
1196 p_effective_date in date ,
1197 p_old_GRADE_OR_SPINAL_POINT_ID in NUMBER,
1199 p_old_GRADE_RULE_ID in NUMBER,
1200 p_new_GRADE_RULE_ID in NUMBER ,
1201 p_old_MAXIMUM in VARCHAR2,
1202 p_new_MAXIMUM in VARCHAR2 ,
1203 p_old_MID_VALUE in VARCHAR2,
1204 p_new_MID_VALUE in VARCHAR2 ,
1205 p_old_MINIMUM in VARCHAR2,
1206 p_new_MINIMUM in VARCHAR2 ,
1207 p_old_PROGRAM_APPLICATION_ID in NUMBER,
1208 p_new_PROGRAM_APPLICATION_ID in NUMBER ,
1209 p_old_PROGRAM_ID in NUMBER,
1210 p_new_PROGRAM_ID in NUMBER ,
1211 p_old_PROGRAM_UPDATE_DATE in DATE,
1212 p_new_PROGRAM_UPDATE_DATE in DATE ,
1213 p_old_RATE_ID in NUMBER,
1214 p_new_RATE_ID in NUMBER ,
1215 p_old_RATE_TYPE in VARCHAR2,
1216 p_new_RATE_TYPE in VARCHAR2 ,
1217 p_old_REQUEST_ID in NUMBER,
1218 p_new_REQUEST_ID in NUMBER ,
1219 p_old_SEQUENCE in NUMBER,
1220 p_new_SEQUENCE in NUMBER ,
1221 p_old_VALUE in VARCHAR2,
1222 p_new_VALUE in VARCHAR2 ,
1223 p_old_EFFECTIVE_END_DATE in DATE,
1224 p_new_EFFECTIVE_END_DATE in DATE ,
1225 p_old_EFFECTIVE_START_DATE in DATE,
1226 p_new_EFFECTIVE_START_DATE in DATE
1227 );
1228 --
1229
1230 Procedure PER_ADDRESSES_ari(
1231 p_business_group_id in number,
1232 p_legislation_code in varchar2,
1233 p_person_id in number,
1234 p_effective_start_date in date,
1235 p_new_address_id in number
1236 );
1237
1238 procedure PER_ADDRESSES_aru(
1239 p_business_group_id in number,
1240 p_legislation_code in varchar2,
1241 p_effective_date in date ,
1242 p_old_ADDRESS_ID in NUMBER,
1243 p_new_ADDRESS_ID in NUMBER ,
1244 p_old_ADDRESS_LINE1 in VARCHAR2,
1245 p_new_ADDRESS_LINE1 in VARCHAR2 ,
1246 p_old_ADDRESS_LINE2 in VARCHAR2,
1247 p_new_ADDRESS_LINE2 in VARCHAR2 ,
1248 p_old_ADDRESS_LINE3 in VARCHAR2,
1249 p_new_ADDRESS_LINE3 in VARCHAR2 ,
1250 p_old_ADDRESS_TYPE in VARCHAR2,
1251 p_new_ADDRESS_TYPE in VARCHAR2 ,
1252 p_old_ADDR_ATTRIBUTE1 in VARCHAR2,
1253 p_new_ADDR_ATTRIBUTE1 in VARCHAR2 ,
1254 p_old_ADDR_ATTRIBUTE10 in VARCHAR2,
1255 p_new_ADDR_ATTRIBUTE10 in VARCHAR2 ,
1256 p_old_ADDR_ATTRIBUTE11 in VARCHAR2,
1257 p_new_ADDR_ATTRIBUTE11 in VARCHAR2 ,
1258 p_old_ADDR_ATTRIBUTE12 in VARCHAR2,
1259 p_new_ADDR_ATTRIBUTE12 in VARCHAR2 ,
1260 p_old_ADDR_ATTRIBUTE13 in VARCHAR2,
1261 p_new_ADDR_ATTRIBUTE13 in VARCHAR2 ,
1262 p_old_ADDR_ATTRIBUTE14 in VARCHAR2,
1263 p_new_ADDR_ATTRIBUTE14 in VARCHAR2 ,
1264 p_old_ADDR_ATTRIBUTE15 in VARCHAR2,
1265 p_new_ADDR_ATTRIBUTE15 in VARCHAR2 ,
1266 p_old_ADDR_ATTRIBUTE16 in VARCHAR2,
1267 p_new_ADDR_ATTRIBUTE16 in VARCHAR2 ,
1268 p_old_ADDR_ATTRIBUTE17 in VARCHAR2,
1269 p_new_ADDR_ATTRIBUTE17 in VARCHAR2 ,
1270 p_old_ADDR_ATTRIBUTE18 in VARCHAR2,
1271 p_new_ADDR_ATTRIBUTE18 in VARCHAR2 ,
1272 p_old_ADDR_ATTRIBUTE19 in VARCHAR2,
1273 p_new_ADDR_ATTRIBUTE19 in VARCHAR2 ,
1274 p_old_ADDR_ATTRIBUTE2 in VARCHAR2,
1275 p_new_ADDR_ATTRIBUTE2 in VARCHAR2 ,
1276 p_old_ADDR_ATTRIBUTE20 in VARCHAR2,
1277 p_new_ADDR_ATTRIBUTE20 in VARCHAR2 ,
1278 p_old_ADDR_ATTRIBUTE3 in VARCHAR2,
1279 p_new_ADDR_ATTRIBUTE3 in VARCHAR2 ,
1280 p_old_ADDR_ATTRIBUTE4 in VARCHAR2,
1281 p_new_ADDR_ATTRIBUTE4 in VARCHAR2 ,
1282 p_old_ADDR_ATTRIBUTE5 in VARCHAR2,
1283 p_new_ADDR_ATTRIBUTE5 in VARCHAR2 ,
1284 p_old_ADDR_ATTRIBUTE6 in VARCHAR2,
1285 p_new_ADDR_ATTRIBUTE6 in VARCHAR2 ,
1286 p_old_ADDR_ATTRIBUTE7 in VARCHAR2,
1287 p_new_ADDR_ATTRIBUTE7 in VARCHAR2 ,
1288 p_old_ADDR_ATTRIBUTE8 in VARCHAR2,
1289 p_new_ADDR_ATTRIBUTE8 in VARCHAR2 ,
1290 p_old_ADDR_ATTRIBUTE9 in VARCHAR2,
1291 p_new_ADDR_ATTRIBUTE9 in VARCHAR2 ,
1292 p_old_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2,
1293 p_new_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2 ,
1294 p_old_ADD_INFORMATION13 in VARCHAR2,
1295 p_new_ADD_INFORMATION13 in VARCHAR2 ,
1296 p_old_ADD_INFORMATION14 in VARCHAR2,
1297 p_new_ADD_INFORMATION14 in VARCHAR2 ,
1298 p_old_ADD_INFORMATION15 in VARCHAR2,
1299 p_new_ADD_INFORMATION15 in VARCHAR2 ,
1300 p_old_ADD_INFORMATION16 in VARCHAR2,
1301 p_new_ADD_INFORMATION16 in VARCHAR2 ,
1302 p_old_ADD_INFORMATION17 in VARCHAR2,
1303 p_new_ADD_INFORMATION17 in VARCHAR2 ,
1304 p_old_ADD_INFORMATION18 in VARCHAR2,
1305 p_new_ADD_INFORMATION18 in VARCHAR2 ,
1306 p_old_ADD_INFORMATION19 in VARCHAR2,
1307 p_new_ADD_INFORMATION19 in VARCHAR2 ,
1308 p_old_ADD_INFORMATION20 in VARCHAR2,
1309 p_new_ADD_INFORMATION20 in VARCHAR2 ,
1310 p_old_BUSINESS_GROUP_ID in NUMBER,
1311 p_new_BUSINESS_GROUP_ID in NUMBER ,
1312 p_old_COUNTRY in VARCHAR2,
1313 p_new_COUNTRY in VARCHAR2 ,
1314 p_old_DATE_FROM in DATE,
1315 p_new_DATE_FROM in DATE ,
1316 p_old_DATE_TO in DATE,
1317 p_new_DATE_TO in DATE ,
1318 p_old_PERSON_ID in NUMBER,
1319 p_new_PERSON_ID in NUMBER ,
1320 p_old_POSTAL_CODE in VARCHAR2,
1321 p_new_POSTAL_CODE in VARCHAR2 ,
1322 p_old_PRIMARY_FLAG in VARCHAR2,
1323 p_new_PRIMARY_FLAG in VARCHAR2 ,
1324 p_old_PROGRAM_APPLICATION_ID in NUMBER,
1325 p_new_PROGRAM_APPLICATION_ID in NUMBER ,
1326 p_old_PROGRAM_ID in NUMBER,
1327 p_new_PROGRAM_ID in NUMBER ,
1328 p_old_PROGRAM_UPDATE_DATE in DATE,
1329 p_new_PROGRAM_UPDATE_DATE in DATE ,
1330 p_old_REGION_1 in VARCHAR2,
1331 p_new_REGION_1 in VARCHAR2 ,
1332 p_old_REGION_2 in VARCHAR2,
1333 p_new_REGION_2 in VARCHAR2 ,
1337 p_new_REQUEST_ID in NUMBER ,
1334 p_old_REGION_3 in VARCHAR2,
1335 p_new_REGION_3 in VARCHAR2 ,
1336 p_old_REQUEST_ID in NUMBER,
1338 p_old_STYLE in VARCHAR2,
1339 p_new_STYLE in VARCHAR2 ,
1340 p_old_TELEPHONE_NUMBER_1 in VARCHAR2,
1341 p_new_TELEPHONE_NUMBER_1 in VARCHAR2 ,
1342 p_old_TELEPHONE_NUMBER_2 in VARCHAR2,
1343 p_new_TELEPHONE_NUMBER_2 in VARCHAR2 ,
1344 p_old_TELEPHONE_NUMBER_3 in VARCHAR2,
1345 p_new_TELEPHONE_NUMBER_3 in VARCHAR2 ,
1346 p_old_TOWN_OR_CITY in VARCHAR2,
1347 p_new_TOWN_OR_CITY in VARCHAR2
1348 );
1349 --
1350
1351 procedure PER_ALL_PEOPLE_F_ard(
1352 p_business_group_id in number,
1353 p_legislation_code in varchar2,
1354 p_old_person_id in number,
1355 p_old_effective_start_date in date,
1356 p_new_effective_start_date in date,
1357 p_old_effective_end_date in date,
1358 p_new_effective_end_date in date
1359 );
1360
1361 procedure PER_SPIN_PNT_PLACEMENTS_F_ari(
1362 p_business_group_id in number,
1363 p_legislation_code in varchar2,
1364 p_placement_id in number,
1365 p_assignment_id in number,
1366 p_effective_start_date in date
1367 );
1368
1369 procedure PER_SPIN_PNT_PLACEMENTS_F_ard(
1370 p_business_group_id in number,
1371 p_legislation_code in varchar2,
1372 p_old_placement_id in number,
1373 p_old_effective_start_date in date,
1374 p_new_effective_start_date in date,
1375 p_old_effective_end_date in date,
1376 p_new_effective_end_date in date,
1377 p_old_assignment_id in number
1378 );
1379
1380 procedure PAY_GRADE_RULES_F_ard(
1381 p_business_group_id in number,
1382 p_legislation_code in varchar2,
1383 p_old_grade_rule_id in number,
1384 p_old_effective_start_date in date,
1385 p_new_effective_start_date in date,
1386 p_old_effective_end_date in date,
1387 p_new_effective_end_date in date
1388 );
1389
1390 --
1391 procedure PER_ALL_PEOPLE_F_aru(
1392 p_business_group_id in number,
1393 p_legislation_code in varchar2,
1394 p_effective_date in date ,
1395 p_old_APPLICANT_NUMBER in VARCHAR2,
1396 p_new_APPLICANT_NUMBER in VARCHAR2 ,
1397 p_old_ATTRIBUTE1 in VARCHAR2,
1398 p_new_ATTRIBUTE1 in VARCHAR2 ,
1399 p_old_ATTRIBUTE10 in VARCHAR2,
1400 p_new_ATTRIBUTE10 in VARCHAR2 ,
1401 p_old_ATTRIBUTE11 in VARCHAR2,
1402 p_new_ATTRIBUTE11 in VARCHAR2 ,
1403 p_old_ATTRIBUTE12 in VARCHAR2,
1404 p_new_ATTRIBUTE12 in VARCHAR2 ,
1405 p_old_ATTRIBUTE13 in VARCHAR2,
1406 p_new_ATTRIBUTE13 in VARCHAR2 ,
1407 p_old_ATTRIBUTE14 in VARCHAR2,
1408 p_new_ATTRIBUTE14 in VARCHAR2 ,
1409 p_old_ATTRIBUTE15 in VARCHAR2,
1410 p_new_ATTRIBUTE15 in VARCHAR2 ,
1411 p_old_ATTRIBUTE16 in VARCHAR2,
1412 p_new_ATTRIBUTE16 in VARCHAR2 ,
1413 p_old_ATTRIBUTE17 in VARCHAR2,
1414 p_new_ATTRIBUTE17 in VARCHAR2 ,
1415 p_old_ATTRIBUTE18 in VARCHAR2,
1416 p_new_ATTRIBUTE18 in VARCHAR2 ,
1417 p_old_ATTRIBUTE19 in VARCHAR2,
1418 p_new_ATTRIBUTE19 in VARCHAR2 ,
1419 p_old_ATTRIBUTE2 in VARCHAR2,
1420 p_new_ATTRIBUTE2 in VARCHAR2 ,
1421 p_old_ATTRIBUTE20 in VARCHAR2,
1422 p_new_ATTRIBUTE20 in VARCHAR2 ,
1423 p_old_ATTRIBUTE21 in VARCHAR2,
1424 p_new_ATTRIBUTE21 in VARCHAR2 ,
1425 p_old_ATTRIBUTE22 in VARCHAR2,
1426 p_new_ATTRIBUTE22 in VARCHAR2 ,
1427 p_old_ATTRIBUTE23 in VARCHAR2,
1428 p_new_ATTRIBUTE23 in VARCHAR2 ,
1429 p_old_ATTRIBUTE24 in VARCHAR2,
1430 p_new_ATTRIBUTE24 in VARCHAR2 ,
1431 p_old_ATTRIBUTE25 in VARCHAR2,
1432 p_new_ATTRIBUTE25 in VARCHAR2 ,
1433 p_old_ATTRIBUTE26 in VARCHAR2,
1434 p_new_ATTRIBUTE26 in VARCHAR2 ,
1435 p_old_ATTRIBUTE27 in VARCHAR2,
1436 p_new_ATTRIBUTE27 in VARCHAR2 ,
1437 p_old_ATTRIBUTE28 in VARCHAR2,
1438 p_new_ATTRIBUTE28 in VARCHAR2 ,
1439 p_old_ATTRIBUTE29 in VARCHAR2,
1440 p_new_ATTRIBUTE29 in VARCHAR2 ,
1441 p_old_ATTRIBUTE3 in VARCHAR2,
1442 p_new_ATTRIBUTE3 in VARCHAR2 ,
1443 p_old_ATTRIBUTE30 in VARCHAR2,
1444 p_new_ATTRIBUTE30 in VARCHAR2 ,
1445 p_old_ATTRIBUTE4 in VARCHAR2,
1446 p_new_ATTRIBUTE4 in VARCHAR2 ,
1447 p_old_ATTRIBUTE5 in VARCHAR2,
1448 p_new_ATTRIBUTE5 in VARCHAR2 ,
1449 p_old_ATTRIBUTE6 in VARCHAR2,
1450 p_new_ATTRIBUTE6 in VARCHAR2 ,
1451 p_old_ATTRIBUTE7 in VARCHAR2,
1452 p_new_ATTRIBUTE7 in VARCHAR2 ,
1453 p_old_ATTRIBUTE8 in VARCHAR2,
1454 p_new_ATTRIBUTE8 in VARCHAR2 ,
1455 p_old_ATTRIBUTE9 in VARCHAR2,
1456 p_new_ATTRIBUTE9 in VARCHAR2 ,
1457 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
1458 p_new_ATTRIBUTE_CATEGORY in VARCHAR2 ,
1459 p_old_BACKGROUND_CHECK_STATUS in VARCHAR2,
1460 p_new_BACKGROUND_CHECK_STATUS in VARCHAR2 ,
1461 p_old_BACKGROUND_DATE_CHECK in DATE,
1462 p_new_BACKGROUND_DATE_CHECK in DATE ,
1463 p_old_BENEFIT_GROUP_ID in NUMBER,
1464 p_new_BENEFIT_GROUP_ID in NUMBER ,
1465 p_old_BLOOD_TYPE in VARCHAR2,
1466 p_new_BLOOD_TYPE in VARCHAR2 ,
1467 p_old_BUSINESS_GROUP_ID in NUMBER,
1468 p_new_BUSINESS_GROUP_ID in NUMBER ,
1469 p_old_COMMENT_ID in NUMBER,
1470 p_new_COMMENT_ID in NUMBER ,
1471 p_old_COORD_BEN_MED_PLN_NO in VARCHAR2,
1472 p_new_COORD_BEN_MED_PLN_NO in VARCHAR2 ,
1473 p_old_COORD_BEN_NO_CVG_FLAG in VARCHAR2,
1477 p_old_COUNTRY_OF_BIRTH in VARCHAR2,
1474 p_new_COORD_BEN_NO_CVG_FLAG in VARCHAR2 ,
1475 p_old_CORRESPONDENCE_LANGUAGE in VARCHAR2,
1476 p_new_CORRESPONDENCE_LANGUAGE in VARCHAR2 ,
1478 p_new_COUNTRY_OF_BIRTH in VARCHAR2 ,
1479 p_old_CURRENT_APPLICANT_FLAG in VARCHAR2,
1480 p_new_CURRENT_APPLICANT_FLAG in VARCHAR2 ,
1481 p_old_CURRENT_EMPLOYEE_FLAG in VARCHAR2,
1482 p_new_CURRENT_EMPLOYEE_FLAG in VARCHAR2 ,
1483 p_old_CURRENT_EMP_OR_APL_FLAG in VARCHAR2,
1484 p_new_CURRENT_EMP_OR_APL_FLAG in VARCHAR2 ,
1485 p_old_DATE_EMPLOYEE_DATA_VERIF in DATE,
1486 p_new_DATE_EMPLOYEE_DATA_VERIF in DATE ,
1487 p_old_DATE_OF_BIRTH in DATE,
1488 p_new_DATE_OF_BIRTH in DATE ,
1489 p_old_DATE_OF_DEATH in DATE,
1490 p_new_DATE_OF_DEATH in DATE ,
1491 p_old_DPDNT_ADOPTION_DATE in DATE,
1492 p_new_DPDNT_ADOPTION_DATE in DATE ,
1493 p_old_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2,
1494 p_new_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2 ,
1495 p_old_EMAIL_ADDRESS in VARCHAR2,
1496 p_new_EMAIL_ADDRESS in VARCHAR2 ,
1497 p_old_EMPLOYEE_NUMBER in VARCHAR2,
1498 p_new_EMPLOYEE_NUMBER in VARCHAR2 ,
1499 p_old_EXPENSE_CHECK_SEND_TO_AD in VARCHAR2,
1500 p_new_EXPENSE_CHECK_SEND_TO_AD in VARCHAR2 ,
1501 p_old_FAST_PATH_EMPLOYEE in VARCHAR2,
1502 p_new_FAST_PATH_EMPLOYEE in VARCHAR2 ,
1503 p_old_FIRST_NAME in VARCHAR2,
1504 p_new_FIRST_NAME in VARCHAR2 ,
1505 p_old_FTE_CAPACITY in NUMBER,
1506 p_new_FTE_CAPACITY in NUMBER ,
1507 p_old_FULL_NAME in VARCHAR2,
1508 p_new_FULL_NAME in VARCHAR2 ,
1509 p_old_GLOBAL_PERSON_ID in VARCHAR2,
1510 p_new_GLOBAL_PERSON_ID in VARCHAR2 ,
1511 p_old_HOLD_APPLICANT_DATE_UNTI in DATE,
1512 p_new_HOLD_APPLICANT_DATE_UNTI in DATE ,
1513 p_old_HONORS in VARCHAR2,
1514 p_new_HONORS in VARCHAR2 ,
1515 p_old_INTERNAL_LOCATION in VARCHAR2,
1516 p_new_INTERNAL_LOCATION in VARCHAR2 ,
1517 p_old_KNOWN_AS in VARCHAR2,
1518 p_new_KNOWN_AS in VARCHAR2 ,
1519 p_old_LAST_MEDICAL_TEST_BY in VARCHAR2,
1520 p_new_LAST_MEDICAL_TEST_BY in VARCHAR2 ,
1521 p_old_LAST_MEDICAL_TEST_DATE in DATE,
1522 p_new_LAST_MEDICAL_TEST_DATE in DATE ,
1523 p_old_LAST_NAME in VARCHAR2,
1524 p_new_LAST_NAME in VARCHAR2 ,
1525 p_old_MAILSTOP in VARCHAR2,
1526 p_new_MAILSTOP in VARCHAR2 ,
1527 p_old_MARITAL_STATUS in VARCHAR2,
1528 p_new_MARITAL_STATUS in VARCHAR2 ,
1529 p_old_MIDDLE_NAMES in VARCHAR2,
1530 p_new_MIDDLE_NAMES in VARCHAR2 ,
1531 p_old_NATIONALITY in VARCHAR2,
1532 p_new_NATIONALITY in VARCHAR2 ,
1533 p_old_NATIONAL_IDENTIFIER in VARCHAR2,
1534 p_new_NATIONAL_IDENTIFIER in VARCHAR2 ,
1535 p_old_OFFICE_NUMBER in VARCHAR2,
1536 p_new_OFFICE_NUMBER in VARCHAR2 ,
1537 p_old_ON_MILITARY_SERVICE in VARCHAR2,
1538 p_new_ON_MILITARY_SERVICE in VARCHAR2 ,
1539 p_old_ORDER_NAME in VARCHAR2,
1540 p_new_ORDER_NAME in VARCHAR2 ,
1541 p_old_ORIGINAL_DATE_OF_HIRE in DATE,
1542 p_new_ORIGINAL_DATE_OF_HIRE in DATE ,
1543 p_old_PERSON_ID in NUMBER,
1544 p_new_PERSON_ID in NUMBER ,
1545 p_old_PERSON_TYPE_ID in NUMBER,
1546 p_new_PERSON_TYPE_ID in NUMBER ,
1547 p_old_PER_INFORMATION1 in VARCHAR2,
1548 p_new_PER_INFORMATION1 in VARCHAR2 ,
1549 p_old_PER_INFORMATION10 in VARCHAR2,
1550 p_new_PER_INFORMATION10 in VARCHAR2 ,
1551 p_old_PER_INFORMATION11 in VARCHAR2,
1552 p_new_PER_INFORMATION11 in VARCHAR2 ,
1553 p_old_PER_INFORMATION12 in VARCHAR2,
1554 p_new_PER_INFORMATION12 in VARCHAR2 ,
1555 p_old_PER_INFORMATION13 in VARCHAR2,
1556 p_new_PER_INFORMATION13 in VARCHAR2 ,
1557 p_old_PER_INFORMATION14 in VARCHAR2,
1558 p_new_PER_INFORMATION14 in VARCHAR2 ,
1559 p_old_PER_INFORMATION15 in VARCHAR2,
1560 p_new_PER_INFORMATION15 in VARCHAR2 ,
1561 p_old_PER_INFORMATION16 in VARCHAR2,
1562 p_new_PER_INFORMATION16 in VARCHAR2 ,
1563 p_old_PER_INFORMATION17 in VARCHAR2,
1564 p_new_PER_INFORMATION17 in VARCHAR2 ,
1565 p_old_PER_INFORMATION18 in VARCHAR2,
1566 p_new_PER_INFORMATION18 in VARCHAR2 ,
1567 p_old_PER_INFORMATION19 in VARCHAR2,
1568 p_new_PER_INFORMATION19 in VARCHAR2 ,
1569 p_old_PER_INFORMATION2 in VARCHAR2,
1570 p_new_PER_INFORMATION2 in VARCHAR2 ,
1571 p_old_PER_INFORMATION20 in VARCHAR2,
1572 p_new_PER_INFORMATION20 in VARCHAR2 ,
1573 p_old_PER_INFORMATION21 in VARCHAR2,
1574 p_new_PER_INFORMATION21 in VARCHAR2 ,
1575 p_old_PER_INFORMATION22 in VARCHAR2,
1576 p_new_PER_INFORMATION22 in VARCHAR2 ,
1577 p_old_PER_INFORMATION23 in VARCHAR2,
1578 p_new_PER_INFORMATION23 in VARCHAR2 ,
1579 p_old_PER_INFORMATION24 in VARCHAR2,
1580 p_new_PER_INFORMATION24 in VARCHAR2 ,
1581 p_old_PER_INFORMATION25 in VARCHAR2,
1582 p_new_PER_INFORMATION25 in VARCHAR2 ,
1583 p_old_PER_INFORMATION26 in VARCHAR2,
1584 p_new_PER_INFORMATION26 in VARCHAR2 ,
1585 p_old_PER_INFORMATION27 in VARCHAR2,
1586 p_new_PER_INFORMATION27 in VARCHAR2 ,
1587 p_old_PER_INFORMATION28 in VARCHAR2,
1588 p_new_PER_INFORMATION28 in VARCHAR2 ,
1589 p_old_PER_INFORMATION29 in VARCHAR2,
1590 p_new_PER_INFORMATION29 in VARCHAR2 ,
1591 p_old_PER_INFORMATION3 in VARCHAR2,
1592 p_new_PER_INFORMATION3 in VARCHAR2 ,
1593 p_old_PER_INFORMATION30 in VARCHAR2,
1594 p_new_PER_INFORMATION30 in VARCHAR2 ,
1595 p_old_PER_INFORMATION4 in VARCHAR2,
1596 p_new_PER_INFORMATION4 in VARCHAR2 ,
1597 p_old_PER_INFORMATION5 in VARCHAR2,
1598 p_new_PER_INFORMATION5 in VARCHAR2 ,
1599 p_old_PER_INFORMATION6 in VARCHAR2,
1600 p_new_PER_INFORMATION6 in VARCHAR2 ,
1601 p_old_PER_INFORMATION7 in VARCHAR2,
1602 p_new_PER_INFORMATION7 in VARCHAR2 ,
1603 p_old_PER_INFORMATION8 in VARCHAR2,
1604 p_new_PER_INFORMATION8 in VARCHAR2 ,
1605 p_old_PER_INFORMATION9 in VARCHAR2,
1609 p_old_PREVIOUS_LAST_NAME in VARCHAR2,
1606 p_new_PER_INFORMATION9 in VARCHAR2 ,
1607 p_old_PER_INFORMATION_CATEGORY in VARCHAR2,
1608 p_new_PER_INFORMATION_CATEGORY in VARCHAR2 ,
1610 p_new_PREVIOUS_LAST_NAME in VARCHAR2 ,
1611 p_old_PRE_NAME_ADJUNCT in VARCHAR2,
1612 p_new_PRE_NAME_ADJUNCT in VARCHAR2 ,
1613 p_old_PROGRAM_APPLICATION_ID in NUMBER,
1614 p_new_PROGRAM_APPLICATION_ID in NUMBER ,
1615 p_old_PROGRAM_ID in NUMBER,
1616 p_new_PROGRAM_ID in NUMBER ,
1617 p_old_PROGRAM_UPDATE_DATE in DATE,
1618 p_new_PROGRAM_UPDATE_DATE in DATE ,
1619 p_old_PROJECTED_START_DATE in DATE,
1620 p_new_PROJECTED_START_DATE in DATE ,
1621 p_old_RECEIPT_OF_DEATH_CERT_DA in DATE,
1622 p_new_RECEIPT_OF_DEATH_CERT_DA in DATE ,
1623 p_old_REGION_OF_BIRTH in VARCHAR2,
1624 p_new_REGION_OF_BIRTH in VARCHAR2 ,
1625 p_old_REGISTERED_DISABLED_FLAG in VARCHAR2,
1626 p_new_REGISTERED_DISABLED_FLAG in VARCHAR2 ,
1627 p_old_REHIRE_AUTHORIZOR in VARCHAR2,
1628 p_new_REHIRE_AUTHORIZOR in VARCHAR2 ,
1629 p_old_REHIRE_REASON in VARCHAR2,
1630 p_new_REHIRE_REASON in VARCHAR2 ,
1631 p_old_REHIRE_RECOMMENDATION in VARCHAR2,
1632 p_new_REHIRE_RECOMMENDATION in VARCHAR2 ,
1633 p_old_REQUEST_ID in NUMBER,
1634 p_new_REQUEST_ID in NUMBER ,
1635 p_old_RESUME_EXISTS in VARCHAR2,
1636 p_new_RESUME_EXISTS in VARCHAR2 ,
1637 p_old_RESUME_LAST_UPDATED in DATE,
1638 p_new_RESUME_LAST_UPDATED in DATE ,
1639 p_old_SECOND_PASSPORT_EXISTS in VARCHAR2,
1640 p_new_SECOND_PASSPORT_EXISTS in VARCHAR2 ,
1641 p_old_SEX in VARCHAR2,
1642 p_new_SEX in VARCHAR2 ,
1643 p_old_START_DATE in DATE,
1644 p_new_START_DATE in DATE ,
1645 p_old_STUDENT_STATUS in VARCHAR2,
1646 p_new_STUDENT_STATUS in VARCHAR2 ,
1647 p_old_SUFFIX in VARCHAR2,
1648 p_new_SUFFIX in VARCHAR2 ,
1649 p_old_TITLE in VARCHAR2,
1650 p_new_TITLE in VARCHAR2 ,
1651 p_old_TOWN_OF_BIRTH in VARCHAR2,
1652 p_new_TOWN_OF_BIRTH in VARCHAR2 ,
1653 p_old_USES_TOBACCO_FLAG in VARCHAR2,
1654 p_new_USES_TOBACCO_FLAG in VARCHAR2 ,
1655 p_old_VENDOR_ID in NUMBER,
1656 p_new_VENDOR_ID in NUMBER ,
1657 p_old_WORK_SCHEDULE in VARCHAR2,
1658 p_new_WORK_SCHEDULE in VARCHAR2 ,
1659 p_old_WORK_TELEPHONE in VARCHAR2,
1660 p_new_WORK_TELEPHONE in VARCHAR2 ,
1661 p_old_EFFECTIVE_END_DATE in DATE,
1662 p_new_EFFECTIVE_END_DATE in DATE ,
1663 p_old_EFFECTIVE_START_DATE in DATE,
1664 p_new_EFFECTIVE_START_DATE in DATE
1665 );
1666 --
1667 procedure PER_SPIN_PNT_PLACEMENTS_F_aru(
1668 p_business_group_id in number,
1669 p_legislation_code in varchar2,
1670 p_effective_date in date ,
1671 p_old_ASSIGNMENT_ID in NUMBER,
1672 p_new_ASSIGNMENT_ID in NUMBER ,
1673 p_old_AUTO_INCREMENT_FLAG in VARCHAR2,
1674 p_new_AUTO_INCREMENT_FLAG in VARCHAR2 ,
1675 p_old_BUSINESS_GROUP_ID in NUMBER,
1676 p_new_BUSINESS_GROUP_ID in NUMBER ,
1677 p_old_PARENT_SPINE_ID in NUMBER,
1678 p_new_PARENT_SPINE_ID in NUMBER ,
1679 p_old_PLACEMENT_ID in NUMBER,
1680 p_new_PLACEMENT_ID in NUMBER ,
1681 p_old_PROGRAM_APPLICATION_ID in NUMBER,
1682 p_new_PROGRAM_APPLICATION_ID in NUMBER ,
1683 p_old_PROGRAM_ID in NUMBER,
1684 p_new_PROGRAM_ID in NUMBER ,
1685 p_old_PROGRAM_UPDATE_DATE in DATE,
1686 p_new_PROGRAM_UPDATE_DATE in DATE ,
1687 p_old_REASON in VARCHAR2,
1688 p_new_REASON in VARCHAR2 ,
1689 p_old_REQUEST_ID in NUMBER,
1690 p_new_REQUEST_ID in NUMBER ,
1691 p_old_STEP_ID in NUMBER,
1692 p_new_STEP_ID in NUMBER ,
1693 p_old_EFFECTIVE_END_DATE in DATE,
1694 p_new_EFFECTIVE_END_DATE in DATE ,
1695 p_old_EFFECTIVE_START_DATE in DATE,
1696 p_new_EFFECTIVE_START_DATE in DATE
1697 );
1698 procedure PER_ASSIGN_BUDGET_VALUES_F_aru(
1699 p_business_group_id in number,
1700 p_legislation_code in varchar2,
1701 p_effective_date in date
1702 ,
1703 p_old_ASSIGNMENT_BUDGET_VALUE_ in NUMBER,
1704 p_new_ASSIGNMENT_BUDGET_VALUE_ in NUMBER
1705 ,
1706 p_old_ASSIGNMENT_ID in NUMBER,
1707 p_new_ASSIGNMENT_ID in NUMBER
1708 ,
1709 p_old_BUSINESS_GROUP_ID in NUMBER,
1710 p_new_BUSINESS_GROUP_ID in NUMBER
1711 ,
1712 p_old_PROGRAM_APPLICATION_ID in NUMBER,
1713 p_new_PROGRAM_APPLICATION_ID in NUMBER
1714 ,
1715 p_old_PROGRAM_ID in NUMBER,
1716 p_new_PROGRAM_ID in NUMBER
1717 ,
1718 p_old_PROGRAM_UPDATE_DATE in DATE,
1719 p_new_PROGRAM_UPDATE_DATE in DATE
1720 ,
1721 p_old_REQUEST_ID in NUMBER,
1722 p_new_REQUEST_ID in NUMBER
1723 ,
1724 p_old_UNIT in VARCHAR2,
1725 p_new_UNIT in VARCHAR2
1726 ,
1727 p_old_VALUE in NUMBER,
1728 p_new_VALUE in NUMBER
1729 ,
1730 p_old_EFFECTIVE_END_DATE in DATE,
1731 p_new_EFFECTIVE_END_DATE in DATE
1732 ,
1733 p_old_EFFECTIVE_START_DATE in DATE,
1734 p_new_EFFECTIVE_START_DATE in DATE
1735
1736 );
1737 --
1738 procedure PER_ASSIGN_BUDGET_VALUES_F_ari(
1739 p_business_group_id in number,
1740 p_legislation_code in varchar2,
1741 p_ASSIGNMENT_BUDGET_VALUE_ in NUMBER,
1742 p_ASSIGNMENT_ID in NUMBER,
1743 p_PROGRAM_APPLICATION_ID in NUMBER,
1744 p_PROGRAM_ID in NUMBER,
1745 p_PROGRAM_UPDATE_DATE in DATE,
1746 p_REQUEST_ID in NUMBER,
1747 p_UNIT in VARCHAR2,
1748 p_VALUE in NUMBER,
1752 --
1749 p_EFFECTIVE_END_DATE in DATE,
1750 p_EFFECTIVE_START_DATE in DATE
1751 );
1753 procedure PER_ASSIGN_BUDGET_VALUES_ard(
1754 p_business_group_id in number,
1755 p_legislation_code in varchar2,
1756 p_ASSIGNMENT_ID in NUMBER,
1757 p_EFFECTIVE_START_DATE in DATE,
1758 p_ASSIGNMENT_BUDGET_VALUE_ in NUMBER
1759 );
1760 --
1761
1762 procedure PER_PERIODS_OF_SERVICE_aru(
1763 p_business_group_id in number,
1764 p_legislation_code in varchar2,
1765 p_effective_date in date ,
1766 p_old_ACCEPTED_TERMINATION_DAT in DATE,
1767 p_new_ACCEPTED_TERMINATION_DAT in DATE ,
1768 p_old_ACTUAL_TERMINATION_DATE in DATE,
1769 p_new_ACTUAL_TERMINATION_DATE in DATE ,
1770 p_old_ADJUSTED_SVC_DATE in DATE,
1771 p_new_ADJUSTED_SVC_DATE in DATE ,
1772 p_old_ATTRIBUTE1 in VARCHAR2,
1773 p_new_ATTRIBUTE1 in VARCHAR2 ,
1774 p_old_ATTRIBUTE10 in VARCHAR2,
1775 p_new_ATTRIBUTE10 in VARCHAR2 ,
1776 p_old_ATTRIBUTE11 in VARCHAR2,
1777 p_new_ATTRIBUTE11 in VARCHAR2 ,
1778 p_old_ATTRIBUTE12 in VARCHAR2,
1779 p_new_ATTRIBUTE12 in VARCHAR2 ,
1780 p_old_ATTRIBUTE13 in VARCHAR2,
1781 p_new_ATTRIBUTE13 in VARCHAR2 ,
1782 p_old_ATTRIBUTE14 in VARCHAR2,
1783 p_new_ATTRIBUTE14 in VARCHAR2
1784 , p_old_ATTRIBUTE15 in VARCHAR2,
1785 p_new_ATTRIBUTE15 in VARCHAR2 ,
1786 p_old_ATTRIBUTE16 in VARCHAR2,
1787 p_new_ATTRIBUTE16 in VARCHAR2 ,
1788 p_old_ATTRIBUTE17 in VARCHAR2,
1789 p_new_ATTRIBUTE17 in VARCHAR2 ,
1790 p_old_ATTRIBUTE18 in VARCHAR2,
1791 p_new_ATTRIBUTE18 in VARCHAR2 ,
1792 p_old_ATTRIBUTE19 in VARCHAR2,
1793 p_new_ATTRIBUTE19 in VARCHAR2 ,
1794 p_old_ATTRIBUTE2 in VARCHAR2,
1795 p_new_ATTRIBUTE2 in VARCHAR2 ,
1796 p_old_ATTRIBUTE20 in VARCHAR2,
1797 p_new_ATTRIBUTE20 in VARCHAR2 ,
1798 p_old_ATTRIBUTE3 in VARCHAR2,
1799 p_new_ATTRIBUTE3 in VARCHAR2 ,
1800 p_old_ATTRIBUTE4 in VARCHAR2,
1801 p_new_ATTRIBUTE4 in VARCHAR2 ,
1802 p_old_ATTRIBUTE5 in VARCHAR2,
1803 p_new_ATTRIBUTE5 in VARCHAR2 ,
1804 p_old_ATTRIBUTE6 in VARCHAR2,
1805 p_new_ATTRIBUTE6 in VARCHAR2 ,
1806 p_old_ATTRIBUTE7 in VARCHAR2,
1807 p_new_ATTRIBUTE7 in VARCHAR2 ,
1808 p_old_ATTRIBUTE8 in VARCHAR2,
1809 p_new_ATTRIBUTE8 in VARCHAR2 ,
1810 p_old_ATTRIBUTE9 in VARCHAR2,
1811 p_new_ATTRIBUTE9 in VARCHAR2 ,
1812 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
1813 p_new_ATTRIBUTE_CATEGORY in VARCHAR2 ,
1814 p_old_BUSINESS_GROUP_ID in NUMBER,
1815 p_new_BUSINESS_GROUP_ID in NUMBER ,
1816 p_old_DATE_START in DATE,
1817 p_new_DATE_START in DATE ,
1818 p_old_FINAL_PROCESS_DATE in DATE,
1819 p_new_FINAL_PROCESS_DATE in DATE ,
1820 p_old_LAST_STANDARD_PROCESS_DA in DATE,
1821 p_new_LAST_STANDARD_PROCESS_DA in DATE ,
1822 p_old_LEAVING_REASON in VARCHAR2,
1823 p_new_LEAVING_REASON in VARCHAR2 ,
1824 p_old_NOTIFIED_TERMINATION_DAT in DATE,
1825 p_new_NOTIFIED_TERMINATION_DAT in DATE ,
1826 p_old_PDS_INFORMATION1 in VARCHAR2,
1827 p_new_PDS_INFORMATION1 in VARCHAR2 ,
1828 p_old_PDS_INFORMATION10 in VARCHAR2,
1829 p_new_PDS_INFORMATION10 in VARCHAR2 ,
1830 p_old_PDS_INFORMATION11 in VARCHAR2,
1831 p_new_PDS_INFORMATION11 in VARCHAR2 ,
1832 p_old_PDS_INFORMATION12 in VARCHAR2,
1833 p_new_PDS_INFORMATION12 in VARCHAR2 ,
1834 p_old_PDS_INFORMATION13 in VARCHAR2,
1835 p_new_PDS_INFORMATION13 in VARCHAR2 ,
1836 p_old_PDS_INFORMATION14 in VARCHAR2,
1837 p_new_PDS_INFORMATION14 in VARCHAR2 ,
1838 p_old_PDS_INFORMATION15 in VARCHAR2,
1839 p_new_PDS_INFORMATION15 in VARCHAR2 ,
1840 p_old_PDS_INFORMATION16 in VARCHAR2,
1841 p_new_PDS_INFORMATION16 in VARCHAR2 ,
1842 p_old_PDS_INFORMATION17 in VARCHAR2,
1843 p_new_PDS_INFORMATION17 in VARCHAR2 ,
1844 p_old_PDS_INFORMATION18 in VARCHAR2,
1845 p_new_PDS_INFORMATION18 in VARCHAR2 ,
1846 p_old_PDS_INFORMATION19 in VARCHAR2,
1847 p_new_PDS_INFORMATION19 in VARCHAR2 ,
1848 p_old_PDS_INFORMATION2 in VARCHAR2,
1849 p_new_PDS_INFORMATION2 in VARCHAR2 ,
1850 p_old_PDS_INFORMATION20 in VARCHAR2,
1851 p_new_PDS_INFORMATION20 in VARCHAR2 ,
1852 p_old_PDS_INFORMATION21 in VARCHAR2,
1853 p_new_PDS_INFORMATION21 in VARCHAR2 ,
1854 p_old_PDS_INFORMATION22 in VARCHAR2,
1855 p_new_PDS_INFORMATION22 in VARCHAR2 ,
1856 p_old_PDS_INFORMATION23 in VARCHAR2,
1857 p_new_PDS_INFORMATION23 in VARCHAR2 ,
1858 p_old_PDS_INFORMATION24 in VARCHAR2,
1859 p_new_PDS_INFORMATION24 in VARCHAR2 ,
1860 p_old_PDS_INFORMATION25 in VARCHAR2,
1861 p_new_PDS_INFORMATION25 in VARCHAR2 ,
1862 p_old_PDS_INFORMATION26 in VARCHAR2,
1863 p_new_PDS_INFORMATION26 in VARCHAR2 ,
1864 p_old_PDS_INFORMATION27 in VARCHAR2,
1865 p_new_PDS_INFORMATION27 in VARCHAR2 ,
1866 p_old_PDS_INFORMATION28 in VARCHAR2,
1867 p_new_PDS_INFORMATION28 in VARCHAR2 ,
1868 p_old_PDS_INFORMATION29 in VARCHAR2,
1869 p_new_PDS_INFORMATION29 in VARCHAR2 ,
1870 p_old_PDS_INFORMATION3 in VARCHAR2,
1871 p_new_PDS_INFORMATION3 in VARCHAR2 ,
1875 p_new_PDS_INFORMATION4 in VARCHAR2 ,
1872 p_old_PDS_INFORMATION30 in VARCHAR2,
1873 p_new_PDS_INFORMATION30 in VARCHAR2 ,
1874 p_old_PDS_INFORMATION4 in VARCHAR2,
1876 p_old_PDS_INFORMATION5 in VARCHAR2,
1877 p_new_PDS_INFORMATION5 in VARCHAR2 ,
1878 p_old_PDS_INFORMATION6 in VARCHAR2,
1879 p_new_PDS_INFORMATION6 in VARCHAR2 ,
1880 p_old_PDS_INFORMATION7 in VARCHAR2,
1881 p_new_PDS_INFORMATION7 in VARCHAR2 ,
1882 p_old_PDS_INFORMATION8 in VARCHAR2,
1883 p_new_PDS_INFORMATION8 in VARCHAR2 ,
1884 p_old_PDS_INFORMATION9 in VARCHAR2,
1885 p_new_PDS_INFORMATION9 in VARCHAR2 ,
1886 p_old_PDS_INFORMATION_CATEGORY in VARCHAR2,
1887 p_new_PDS_INFORMATION_CATEGORY in VARCHAR2 ,
1888 p_old_PERIOD_OF_SERVICE_ID in NUMBER,
1889 p_new_PERIOD_OF_SERVICE_ID in NUMBER ,
1890 p_old_PERSON_ID in NUMBER,
1891 p_new_PERSON_ID in NUMBER ,
1892 p_old_PRIOR_EMPLOYMENT_SSP_PAI in DATE,
1893 p_new_PRIOR_EMPLOYMENT_SSP_PAI in DATE ,
1894 p_old_PRIOR_EMPLOYMENT_SSP_WEE in NUMBER,
1895 p_new_PRIOR_EMPLOYMENT_SSP_WEE in NUMBER ,
1896 p_old_PROGRAM_APPLICATION_ID in NUMBER,
1897 p_new_PROGRAM_APPLICATION_ID in NUMBER ,
1898 p_old_PROGRAM_ID in NUMBER,
1899 p_new_PROGRAM_ID in NUMBER ,
1900 p_old_PROGRAM_UPDATE_DATE in DATE,
1901 p_new_PROGRAM_UPDATE_DATE in DATE ,
1902 p_old_PROJECTED_TERMINATION_DA in DATE,
1903 p_new_PROJECTED_TERMINATION_DA in DATE ,
1904 p_old_REQUEST_ID in NUMBER,
1905 p_new_REQUEST_ID in NUMBER ,
1906 p_old_TERMINATION_ACCEPTED_PER in NUMBER,
1907 p_new_TERMINATION_ACCEPTED_PER in NUMBER
1908 );
1909
1910 procedure PER_PAY_PROPOSALS_aru(
1911 p_business_group_id in number,
1912 p_legislation_code in varchar2,
1913 p_effective_date in date ,
1914 p_old_APPROVED in VARCHAR2,
1915 p_new_APPROVED in VARCHAR2 ,
1916 p_old_ASSIGNMENT_ID in NUMBER,
1917 p_new_ASSIGNMENT_ID in NUMBER ,
1918 p_old_ATTRIBUTE1 in VARCHAR2,
1919 p_new_ATTRIBUTE1 in VARCHAR2 ,
1920 p_old_ATTRIBUTE10 in VARCHAR2,
1921 p_new_ATTRIBUTE10 in VARCHAR2 ,
1922 p_old_ATTRIBUTE11 in VARCHAR2,
1923 p_new_ATTRIBUTE11 in VARCHAR2 ,
1924 p_old_ATTRIBUTE12 in VARCHAR2,
1925 p_new_ATTRIBUTE12 in VARCHAR2 ,
1926 p_old_ATTRIBUTE13 in VARCHAR2,
1927 p_new_ATTRIBUTE13 in VARCHAR2 ,
1928 p_old_ATTRIBUTE14 in VARCHAR2,
1929 p_new_ATTRIBUTE14 in VARCHAR2 ,
1930 p_old_ATTRIBUTE15 in VARCHAR2,
1931 p_new_ATTRIBUTE15 in VARCHAR2 ,
1932 p_old_ATTRIBUTE16 in VARCHAR2,
1933 p_new_ATTRIBUTE16 in VARCHAR2 ,
1934 p_old_ATTRIBUTE17 in VARCHAR2,
1935 p_new_ATTRIBUTE17 in VARCHAR2 ,
1936 p_old_ATTRIBUTE18 in VARCHAR2,
1937 p_new_ATTRIBUTE18 in VARCHAR2 ,
1938 p_old_ATTRIBUTE19 in VARCHAR2,
1939 p_new_ATTRIBUTE19 in VARCHAR2 ,
1940 p_old_ATTRIBUTE2 in VARCHAR2,
1941 p_new_ATTRIBUTE2 in VARCHAR2 ,
1942 p_old_ATTRIBUTE20 in VARCHAR2,
1943 p_new_ATTRIBUTE20 in VARCHAR2 ,
1944 p_old_ATTRIBUTE3 in VARCHAR2,
1945 p_new_ATTRIBUTE3 in VARCHAR2 ,
1946 p_old_ATTRIBUTE4 in VARCHAR2,
1947 p_new_ATTRIBUTE4 in VARCHAR2 ,
1948 p_old_ATTRIBUTE5 in VARCHAR2,
1949 p_new_ATTRIBUTE5 in VARCHAR2 ,
1950 p_old_ATTRIBUTE6 in VARCHAR2,
1951 p_new_ATTRIBUTE6 in VARCHAR2 ,
1952 p_old_ATTRIBUTE7 in VARCHAR2,
1953 p_new_ATTRIBUTE7 in VARCHAR2 ,
1954 p_old_ATTRIBUTE8 in VARCHAR2,
1955 p_new_ATTRIBUTE8 in VARCHAR2 ,
1956 p_old_ATTRIBUTE9 in VARCHAR2,
1957 p_new_ATTRIBUTE9 in VARCHAR2 ,
1958 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
1959 p_new_ATTRIBUTE_CATEGORY in VARCHAR2 ,
1960 p_old_BUSINESS_GROUP_ID in NUMBER,
1961 p_new_BUSINESS_GROUP_ID in NUMBER ,
1962 p_old_CHANGE_DATE in DATE,
1963 p_new_CHANGE_DATE in DATE ,
1964 p_old_EVENT_ID in NUMBER,
1965 p_new_EVENT_ID in NUMBER ,
1966 p_old_FORCED_RANKING in NUMBER,
1967 p_new_FORCED_RANKING in NUMBER ,
1968 p_old_LAST_CHANGE_DATE in DATE,
1969 p_new_LAST_CHANGE_DATE in DATE ,
1970 p_old_MULTIPLE_COMPONENTS in VARCHAR2,
1971 p_new_MULTIPLE_COMPONENTS in VARCHAR2 ,
1972 p_old_NEXT_PERF_REVIEW_DATE in DATE,
1973 p_new_NEXT_PERF_REVIEW_DATE in DATE ,
1974 p_old_NEXT_SAL_REVIEW_DATE in DATE,
1975 p_new_NEXT_SAL_REVIEW_DATE in DATE ,
1976 p_old_PAY_PROPOSAL_ID in NUMBER,
1977 p_new_PAY_PROPOSAL_ID in NUMBER ,
1978 p_old_PERFORMANCE_RATING in VARCHAR2,
1979 p_new_PERFORMANCE_RATING in VARCHAR2 ,
1980 p_old_PERFORMANCE_REVIEW_ID in NUMBER,
1981 p_new_PERFORMANCE_REVIEW_ID in NUMBER ,
1982 p_old_PROPOSAL_REASON in VARCHAR2,
1983 p_new_PROPOSAL_REASON in VARCHAR2 ,
1984 p_old_PROPOSED_SALARY in VARCHAR2,
1985 p_new_PROPOSED_SALARY in VARCHAR2 ,
1986 p_old_PROPOSED_SALARY_N in NUMBER,
1987 p_new_PROPOSED_SALARY_N in NUMBER ,
1988 p_old_REVIEW_DATE in DATE,
1989 p_new_REVIEW_DATE in DATE);
1990
1991 procedure PER_PAY_PROPOSALS_ari(
1992 p_business_group_id in number,
1993 p_legislation_code in varchar2,
1994 p_assignment_id in number,
1995 p_effective_start_date in date,
1996 p_pay_proposal_id in number);
1997
1998 procedure PER_PAY_PROPOSALS_ard(
1999 p_business_group_id in number,
2000 p_legislation_code in varchar2,
2004
2001 p_assignment_id in number,
2002 p_effective_start_date in date,
2003 p_pay_proposal_id in number);
2005
2006
2007
2008
2009 /* Here are all the event procedures */
2010 procedure ee_date_change ( p_element_entry_id in number,
2011 p_assignment_action_id in number,
2012 p_surrogate_key in number,
2013 p_column_name in varchar2,
2014 p_old_value in varchar2,
2015 p_new_value in varchar2,
2016 p_output_result out nocopy varchar2,
2017 p_date in date default null
2018 );
2019 --
2020 procedure grade_rule_change ( p_element_entry_id in number,
2021 p_assignment_action_id in number,
2022 p_surrogate_key in number,
2023 p_column_name in varchar2,
2024 p_old_value in varchar2,
2025 p_new_value in varchar2,
2026 p_output_result out nocopy varchar2,
2027 p_date in date default null
2028 );
2029 --
2030 procedure input_value_change ( p_element_entry_id in number,
2031 p_assignment_action_id in number,
2032 p_surrogate_key in number,
2033 p_column_name in varchar2,
2034 p_old_value in varchar2,
2035 p_new_value in varchar2,
2036 p_output_result out nocopy varchar2,
2037 p_date in date default null
2038 );
2039 --
2040 procedure link_iv_change ( p_element_entry_id in number,
2041 p_assignment_action_id in number,
2042 p_surrogate_key in number,
2043 p_column_name in varchar2,
2044 p_old_value in varchar2,
2045 p_new_value in varchar2,
2046 p_output_result out nocopy varchar2,
2047 p_date in date default null
2048 );
2049
2050 PROCEDURE PAY_USER_COL_INSTANCES_F_ari ( p_business_group_id IN NUMBER
2051 , p_legislation_code IN VARCHAR2
2052 , p_effective_start_date IN DATE
2053 , p_user_column_instance_id IN NUMBER
2054 );
2055
2056 PROCEDURE PAY_USER_COL_INSTANCES_F_aru ( p_business_group_id IN NUMBER
2057 , p_legislation_code IN VARCHAR2
2058 , p_effective_date IN DATE
2059 , p_old_BUSINESS_GROUP_ID IN VARCHAR2
2060 , p_new_BUSINESS_GROUP_ID IN VARCHAR2
2061 , p_old_EFFECTIVE_END_DATE IN DATE
2062 , p_new_EFFECTIVE_END_DATE IN DATE
2063 , p_old_EFFECTIVE_START_DATE IN DATE
2064 , p_new_EFFECTIVE_START_DATE IN DATE
2065 , p_old_LEGISLATION_CODE IN VARCHAR2
2066 , p_new_LEGISLATION_CODE IN VARCHAR2
2070 , p_new_USER_COLUMN_INSTANCE_ID IN NUMBER
2067 , p_old_USER_COLUMN_ID IN NUMBER
2068 , p_new_USER_COLUMN_ID IN NUMBER
2069 , p_old_USER_COLUMN_INSTANCE_ID IN NUMBER
2071 , p_old_USER_ROW_ID IN NUMBER
2072 , p_new_USER_ROW_ID IN NUMBER
2073 , p_old_VALUE IN VARCHAR2
2074 , p_new_VALUE IN VARCHAR2
2075 );
2076
2077 procedure PAY_USER_COL_INSTANCES_F_ard( p_business_group_id in number,
2078 p_legislation_code in varchar2,
2079 p_old_user_column_instance_id in number,
2080 p_old_effective_start_date in date,
2081 p_new_effective_start_date in date,
2082 p_old_effective_end_date in date,
2083 p_new_effective_end_date in date
2084 );
2085
2086
2087 procedure FF_GLOBALS_F_ari( p_business_group_id IN NUMBER
2088 , p_legislation_code IN VARCHAR2
2089 , p_effective_start_date IN DATE
2090 , p_global_id IN NUMBER
2091 );
2092
2093 PROCEDURE FF_GLOBALS_F_aru ( p_business_group_id IN NUMBER
2094 , p_legislation_code IN VARCHAR2
2095 , p_effective_date IN DATE
2096 , p_old_BUSINESS_GROUP_ID IN VARCHAR2
2097 , p_new_BUSINESS_GROUP_ID IN VARCHAR2
2098 , p_old_EFFECTIVE_END_DATE IN DATE
2099 , p_new_EFFECTIVE_END_DATE IN DATE
2100 , p_old_EFFECTIVE_START_DATE IN DATE
2101 , p_new_EFFECTIVE_START_DATE IN DATE
2102 , p_old_LEGISLATION_CODE IN VARCHAR2
2103 , p_new_LEGISLATION_CODE IN VARCHAR2
2104 , p_old_global_ID IN NUMBER
2105 , p_new_global_ID IN NUMBER
2106 , p_old_global_VALUE IN VARCHAR2
2107 , p_new_global_VALUE IN VARCHAR2
2108 , p_old_global_description IN VARCHAR2
2109 , p_new_global_description IN VARCHAR2
2110 );
2111
2112 procedure FF_GLOBALS_F_ard(
2113 p_business_group_id in number,
2114 p_legislation_code in varchar2,
2115 p_old_global_id in number,
2116 p_old_effective_start_date in date,
2117 p_new_effective_start_date in date,
2118 p_old_effective_end_date in date,
2119 p_new_effective_end_date in date
2120 );
2121 PROCEDURE PQH_RATE_MATRIX_RATES_F_ari( p_business_group_id IN NUMBER
2122 , p_legislation_code IN VARCHAR2
2123 , p_effective_start_date IN DATE
2124 , p_rate_matrix_rate_id IN NUMBER
2125 );
2126
2127 PROCEDURE PQH_RATE_MATRIX_RATES_F_aru( p_business_group_id IN NUMBER
2128 , p_legislation_code IN VARCHAR2
2129 , p_effective_date IN DATE
2130 , p_old_EFFECTIVE_END_DATE IN DATE
2131 , p_new_EFFECTIVE_END_DATE IN DATE
2132 , p_old_EFFECTIVE_START_DATE IN DATE
2133 , p_new_EFFECTIVE_START_DATE IN DATE
2134 , p_old_rate_matrix_rate_id IN NUMBER
2135 , p_new_rate_matrix_rate_id IN NUMBER
2136 , p_old_rate_VALUE IN VARCHAR2
2137 , p_new_rate_VALUE IN VARCHAR2
2138 , p_old_min_rate_VALUE IN VARCHAR2
2139 , p_new_min_rate_VALUE IN VARCHAR2
2140 , p_old_max_rate_VALUE IN VARCHAR2
2141 , p_new_max_rate_VALUE IN VARCHAR2
2142 , p_old_mid_rate_VALUE IN VARCHAR2
2143 , p_new_mid_rate_VALUE IN VARCHAR2
2144 );
2145
2146 PROCEDURE PQH_RATE_MATRIX_RATES_F_ard ( p_business_group_id in number,
2147 p_legislation_code in varchar2,
2148 p_old_rate_matrix_rate_id in number,
2149 p_old_effective_start_date in date,
2150 p_new_effective_start_date in date,
2151 p_old_effective_end_date in date,
2152 p_new_effective_end_date in date
2153 );
2154
2155
2156 end pay_continuous_calc;