1 PACKAGE BODY PAY_POG_ALL_ASSIGNMENTS_PKG AS
2 /* $Header: pypogasg.pkb 120.1.12020000.2 2012/10/05 15:47:05 jkvallab ship $ */
3 --
4 -- +---------------------------------------+
5 -- | PER_ALL_ASSIGNMENTS_F |
6 -- +---------------------------------------+
7 --
8 PROCEDURE AFTER_INSERT
9 (
10 p_effective_date in DATE
11 ,p_validation_start_date in DATE
12 ,p_validation_end_date in DATE
13 ,P_APPLICANT_RANK in NUMBER
14 ,P_APPLICATION_ID in NUMBER
15 ,P_ASSIGNMENT_CATEGORY in VARCHAR2
16 ,P_ASSIGNMENT_ID in NUMBER
17 ,P_ASSIGNMENT_NUMBER in VARCHAR2
18 ,P_ASSIGNMENT_SEQUENCE in NUMBER
19 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
20 ,P_ASSIGNMENT_TYPE in VARCHAR2
21 ,P_ASS_ATTRIBUTE1 in VARCHAR2
22 ,P_ASS_ATTRIBUTE10 in VARCHAR2
23 ,P_ASS_ATTRIBUTE11 in VARCHAR2
24 ,P_ASS_ATTRIBUTE12 in VARCHAR2
25 ,P_ASS_ATTRIBUTE13 in VARCHAR2
26 ,P_ASS_ATTRIBUTE14 in VARCHAR2
27 ,P_ASS_ATTRIBUTE15 in VARCHAR2
28 ,P_ASS_ATTRIBUTE16 in VARCHAR2
29 ,P_ASS_ATTRIBUTE17 in VARCHAR2
30 ,P_ASS_ATTRIBUTE18 in VARCHAR2
31 ,P_ASS_ATTRIBUTE19 in VARCHAR2
32 ,P_ASS_ATTRIBUTE2 in VARCHAR2
33 ,P_ASS_ATTRIBUTE20 in VARCHAR2
34 ,P_ASS_ATTRIBUTE21 in VARCHAR2
35 ,P_ASS_ATTRIBUTE22 in VARCHAR2
36 ,P_ASS_ATTRIBUTE23 in VARCHAR2
37 ,P_ASS_ATTRIBUTE24 in VARCHAR2
38 ,P_ASS_ATTRIBUTE25 in VARCHAR2
39 ,P_ASS_ATTRIBUTE26 in VARCHAR2
40 ,P_ASS_ATTRIBUTE27 in VARCHAR2
41 ,P_ASS_ATTRIBUTE28 in VARCHAR2
42 ,P_ASS_ATTRIBUTE29 in VARCHAR2
43 ,P_ASS_ATTRIBUTE3 in VARCHAR2
44 ,P_ASS_ATTRIBUTE30 in VARCHAR2
45 ,P_ASS_ATTRIBUTE4 in VARCHAR2
46 ,P_ASS_ATTRIBUTE5 in VARCHAR2
47 ,P_ASS_ATTRIBUTE6 in VARCHAR2
48 ,P_ASS_ATTRIBUTE7 in VARCHAR2
49 ,P_ASS_ATTRIBUTE8 in VARCHAR2
50 ,P_ASS_ATTRIBUTE9 in VARCHAR2
51 ,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
52 ,P_BARGAINING_UNIT_CODE in VARCHAR2
53 ,P_BUSINESS_GROUP_ID in NUMBER
54 ,P_CAGR_GRADE_DEF_ID in NUMBER
55 ,P_CAGR_ID_FLEX_NUM in NUMBER
56 ,P_CHANGE_REASON in VARCHAR2
57 ,P_COLLECTIVE_AGREEMENT_ID in NUMBER
58 ,P_COMMENT_ID in NUMBER
59 ,P_CONTRACT_ID in NUMBER
60 ,P_DATE_PROBATION_END in DATE
61 ,P_DEFAULT_CODE_COMB_ID in NUMBER
62 ,P_EFFECTIVE_END_DATE in DATE
63 ,P_EFFECTIVE_START_DATE in DATE
64 ,P_EMPLOYEE_CATEGORY in VARCHAR2
65 ,P_EMPLOYMENT_CATEGORY in VARCHAR2
66 ,P_ESTABLISHMENT_ID in NUMBER
67 ,P_FREQUENCY in VARCHAR2
68 ,P_GRADE_ID in NUMBER
69 ,P_HOURLY_SALARIED_CODE in VARCHAR2
70 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
71 ,P_JOB_ID in NUMBER
72 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
73 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
74 ,P_LOCATION_ID in NUMBER
75 ,P_MANAGER_FLAG in VARCHAR2
76 ,P_NORMAL_HOURS in NUMBER
77 ,P_NOTICE_PERIOD in NUMBER
78 ,P_NOTICE_PERIOD_UOM in VARCHAR2
79 ,P_OBJECT_VERSION_NUMBER in NUMBER
80 ,P_ORGANIZATION_ID in NUMBER
81 ,P_PAYROLL_ID in NUMBER
82 ,P_PAY_BASIS_ID in NUMBER
83 ,P_PEOPLE_GROUP_ID in NUMBER
84 ,P_PERF_REVIEW_PERIOD in NUMBER
85 ,P_PERF_REVIEW_PERIOD_FREQUEN in VARCHAR2
86 ,P_PERIOD_OF_SERVICE_ID in NUMBER
87 ,P_PERSON_ID in NUMBER
88 ,P_PERSON_REFERRED_BY_ID in NUMBER
89 ,P_PLACEMENT_DATE_START in DATE
90 ,P_POSITION_ID in NUMBER
91 ,P_POSTING_CONTENT_ID in NUMBER
92 ,P_PRIMARY_FLAG in VARCHAR2
93 ,P_PROBATION_PERIOD in NUMBER
94 ,P_PROBATION_UNIT in VARCHAR2
95 ,P_PROGRAM_APPLICATION_ID in NUMBER
96 ,P_PROGRAM_ID in NUMBER
97 ,P_PROGRAM_UPDATE_DATE in DATE
98 ,P_PROJECT_TITLE in VARCHAR2
99 ,P_RECRUITER_ID in NUMBER
100 ,P_RECRUITMENT_ACTIVITY_ID in NUMBER
101 ,P_REQUEST_ID in NUMBER
102 ,P_SAL_REVIEW_PERIOD in NUMBER
103 ,P_SAL_REVIEW_PERIOD_FREQUEN in VARCHAR2
104 ,P_SET_OF_BOOKS_ID in NUMBER
105 ,P_SOFT_CODING_KEYFLEX_ID in NUMBER
106 ,P_SOURCE_ORGANIZATION_ID in NUMBER
107 ,P_SOURCE_TYPE in VARCHAR2
108 ,P_SPECIAL_CEILING_STEP_ID in NUMBER
109 ,P_SUPERVISOR_ID in NUMBER
110 ,P_TIME_NORMAL_FINISH in VARCHAR2
111 ,P_TIME_NORMAL_START in VARCHAR2
112 ,P_TITLE in VARCHAR2
113 ,P_VACANCY_ID in NUMBER
114 ,P_VENDOR_ASSIGNMENT_NUMBER in VARCHAR2
115 ,P_VENDOR_EMPLOYEE_NUMBER in VARCHAR2
116 ,P_VENDOR_ID in NUMBER
117 ,P_WORK_AT_HOME in VARCHAR2
118 ,P_GRADE_LADDER_PGM_ID in NUMBER
119 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
120 ,P_VENDOR_SITE_ID in NUMBER
121 ,P_PO_HEADER_ID in NUMBER
122 ,P_PO_LINE_ID in NUMBER
123 ,P_PROJECTED_ASSIGNMENT_END in DATE
124 ) IS
125
126 begin
127 hr_utility.trace('>> PAY_POG_ALL_ASSIGNMENTS_PKG.after_insert');
128 --
129 pay_asg_process_grp_pkg.asg_insert_trigger
130 (p_assignment_id => p_assignment_id,
131 p_person_id => p_person_id,
132 p_period_of_service_id => p_period_of_service_id,
133 p_new_effective_start_date => p_effective_start_date,
134 p_new_effective_end_date => p_effective_end_date,
135 p_new_payroll_id => p_payroll_id,
136 p_business_group_id => p_business_group_id
137 );
138 --
139 end after_insert;
140
141 PROCEDURE AFTER_UPDATE
142 (
143 p_effective_date in DATE
144 ,p_datetrack_mode in VARCHAR2
145 ,p_validation_start_date in DATE
146 ,p_validation_end_date in DATE
147 ,P_APPLICANT_RANK in NUMBER
148 ,P_APPLICATION_ID in NUMBER
149 ,P_ASSIGNMENT_CATEGORY in VARCHAR2
150 ,P_ASSIGNMENT_ID in NUMBER
151 ,P_ASSIGNMENT_NUMBER in VARCHAR2
152 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
153 ,P_ASSIGNMENT_TYPE in VARCHAR2
154 ,P_ASS_ATTRIBUTE1 in VARCHAR2
155 ,P_ASS_ATTRIBUTE10 in VARCHAR2
156 ,P_ASS_ATTRIBUTE11 in VARCHAR2
157 ,P_ASS_ATTRIBUTE12 in VARCHAR2
158 ,P_ASS_ATTRIBUTE13 in VARCHAR2
159 ,P_ASS_ATTRIBUTE14 in VARCHAR2
160 ,P_ASS_ATTRIBUTE15 in VARCHAR2
161 ,P_ASS_ATTRIBUTE16 in VARCHAR2
162 ,P_ASS_ATTRIBUTE17 in VARCHAR2
163 ,P_ASS_ATTRIBUTE18 in VARCHAR2
164 ,P_ASS_ATTRIBUTE19 in VARCHAR2
165 ,P_ASS_ATTRIBUTE2 in VARCHAR2
166 ,P_ASS_ATTRIBUTE20 in VARCHAR2
167 ,P_ASS_ATTRIBUTE21 in VARCHAR2
168 ,P_ASS_ATTRIBUTE22 in VARCHAR2
169 ,P_ASS_ATTRIBUTE23 in VARCHAR2
170 ,P_ASS_ATTRIBUTE24 in VARCHAR2
171 ,P_ASS_ATTRIBUTE25 in VARCHAR2
172 ,P_ASS_ATTRIBUTE26 in VARCHAR2
173 ,P_ASS_ATTRIBUTE27 in VARCHAR2
174 ,P_ASS_ATTRIBUTE28 in VARCHAR2
175 ,P_ASS_ATTRIBUTE29 in VARCHAR2
176 ,P_ASS_ATTRIBUTE3 in VARCHAR2
177 ,P_ASS_ATTRIBUTE30 in VARCHAR2
178 ,P_ASS_ATTRIBUTE4 in VARCHAR2
179 ,P_ASS_ATTRIBUTE5 in VARCHAR2
180 ,P_ASS_ATTRIBUTE6 in VARCHAR2
181 ,P_ASS_ATTRIBUTE7 in VARCHAR2
182 ,P_ASS_ATTRIBUTE8 in VARCHAR2
183 ,P_ASS_ATTRIBUTE9 in VARCHAR2
184 ,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
185 ,P_BARGAINING_UNIT_CODE in VARCHAR2
186 ,P_CAGR_GRADE_DEF_ID in NUMBER
187 ,P_CAGR_ID_FLEX_NUM in NUMBER
188 ,P_CHANGE_REASON in VARCHAR2
189 ,P_COLLECTIVE_AGREEMENT_ID in NUMBER
190 ,P_COMMENTS in VARCHAR2
191 ,P_COMMENT_ID in NUMBER
192 ,P_CONTRACT_ID in NUMBER
193 ,P_DATE_PROBATION_END in DATE
194 ,P_DEFAULT_CODE_COMB_ID in NUMBER
195 ,P_EFFECTIVE_END_DATE in DATE
196 ,P_EFFECTIVE_START_DATE in DATE
197 ,P_EMPLOYEE_CATEGORY in VARCHAR2
198 ,P_EMPLOYMENT_CATEGORY in VARCHAR2
199 ,P_ESTABLISHMENT_ID in NUMBER
200 ,P_FREQUENCY in VARCHAR2
201 ,P_GRADE_ID in NUMBER
202 ,P_HOURLY_SALARIED_CODE in VARCHAR2
203 ,P_HOURLY_SALARIED_WARNING in BOOLEAN
204 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
205 ,P_JOB_ID in NUMBER
206 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
207 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
208 ,P_LOCATION_ID in NUMBER
209 ,P_MANAGER_FLAG in VARCHAR2
210 ,P_NORMAL_HOURS in NUMBER
211 ,P_NOTICE_PERIOD in NUMBER
212 ,P_NOTICE_PERIOD_UOM in VARCHAR2
213 ,P_NO_MANAGERS_WARNING in BOOLEAN
214 ,P_OBJECT_VERSION_NUMBER in NUMBER
215 ,P_ORGANIZATION_ID in NUMBER
216 ,P_ORG_NOW_NO_MANAGER_WARNING in BOOLEAN
217 ,P_OTHER_MANAGER_WARNING in BOOLEAN
218 ,P_PAYROLL_ID in NUMBER
219 ,P_PAYROLL_ID_UPDATED in BOOLEAN
220 ,P_PAY_BASIS_ID in NUMBER
221 ,P_PEOPLE_GROUP_ID in NUMBER
222 ,P_PERF_REVIEW_PERIOD in NUMBER
223 ,P_PERF_REVIEW_PERIOD_FREQUEN in VARCHAR2
224 ,P_PERIOD_OF_SERVICE_ID in NUMBER
225 ,P_PERSON_REFERRED_BY_ID in NUMBER
226 ,P_PLACEMENT_DATE_START in DATE
227 ,P_POSITION_ID in NUMBER
228 ,P_POSTING_CONTENT_ID in NUMBER
229 ,P_PRIMARY_FLAG in VARCHAR2
230 ,P_PROBATION_PERIOD in NUMBER
231 ,P_PROBATION_UNIT in VARCHAR2
232 ,P_PROGRAM_APPLICATION_ID in NUMBER
233 ,P_PROGRAM_ID in NUMBER
234 ,P_PROGRAM_UPDATE_DATE in DATE
235 ,P_PROJECT_TITLE in VARCHAR2
236 ,P_RECRUITER_ID in NUMBER
237 ,P_RECRUITMENT_ACTIVITY_ID in NUMBER
238 ,P_REQUEST_ID in NUMBER
239 ,P_SAL_REVIEW_PERIOD in NUMBER
240 ,P_SAL_REVIEW_PERIOD_FREQUEN in VARCHAR2
241 ,P_SET_OF_BOOKS_ID in NUMBER
242 ,P_SOFT_CODING_KEYFLEX_ID in NUMBER
243 ,P_SOURCE_ORGANIZATION_ID in NUMBER
247 ,P_TIME_NORMAL_FINISH in VARCHAR2
244 ,P_SOURCE_TYPE in VARCHAR2
245 ,P_SPECIAL_CEILING_STEP_ID in NUMBER
246 ,P_SUPERVISOR_ID in NUMBER
248 ,P_TIME_NORMAL_START in VARCHAR2
249 ,P_TITLE in VARCHAR2
250 ,P_VACANCY_ID in NUMBER
251 ,P_VENDOR_ASSIGNMENT_NUMBER in VARCHAR2
252 ,P_VENDOR_EMPLOYEE_NUMBER in VARCHAR2
253 ,P_VENDOR_ID in NUMBER
254 ,P_WORK_AT_HOME in VARCHAR2
255 ,P_GRADE_LADDER_PGM_ID in NUMBER
256 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
257 ,P_VENDOR_SITE_ID in NUMBER
258 ,P_PO_HEADER_ID in NUMBER
259 ,P_PO_LINE_ID in NUMBER
260 ,P_PROJECTED_ASSIGNMENT_END in DATE
261 ,P_APPLICANT_RANK_O in NUMBER
262 ,P_APPLICATION_ID_O in NUMBER
263 ,P_ASSIGNMENT_CATEGORY_O in VARCHAR2
264 ,P_ASSIGNMENT_NUMBER_O in VARCHAR2
265 ,P_ASSIGNMENT_SEQUENCE_O in NUMBER
266 ,P_ASSIGNMENT_STATUS_TYPE_ID_O in NUMBER
267 ,P_ASSIGNMENT_TYPE_O in VARCHAR2
268 ,P_ASS_ATTRIBUTE1_O in VARCHAR2
269 ,P_ASS_ATTRIBUTE10_O in VARCHAR2
270 ,P_ASS_ATTRIBUTE11_O in VARCHAR2
271 ,P_ASS_ATTRIBUTE12_O in VARCHAR2
272 ,P_ASS_ATTRIBUTE13_O in VARCHAR2
273 ,P_ASS_ATTRIBUTE14_O in VARCHAR2
274 ,P_ASS_ATTRIBUTE15_O in VARCHAR2
275 ,P_ASS_ATTRIBUTE16_O in VARCHAR2
276 ,P_ASS_ATTRIBUTE17_O in VARCHAR2
277 ,P_ASS_ATTRIBUTE18_O in VARCHAR2
278 ,P_ASS_ATTRIBUTE19_O in VARCHAR2
279 ,P_ASS_ATTRIBUTE2_O in VARCHAR2
280 ,P_ASS_ATTRIBUTE20_O in VARCHAR2
281 ,P_ASS_ATTRIBUTE21_O in VARCHAR2
282 ,P_ASS_ATTRIBUTE22_O in VARCHAR2
283 ,P_ASS_ATTRIBUTE23_O in VARCHAR2
284 ,P_ASS_ATTRIBUTE24_O in VARCHAR2
285 ,P_ASS_ATTRIBUTE25_O in VARCHAR2
286 ,P_ASS_ATTRIBUTE26_O in VARCHAR2
287 ,P_ASS_ATTRIBUTE27_O in VARCHAR2
288 ,P_ASS_ATTRIBUTE28_O in VARCHAR2
289 ,P_ASS_ATTRIBUTE29_O in VARCHAR2
290 ,P_ASS_ATTRIBUTE3_O in VARCHAR2
291 ,P_ASS_ATTRIBUTE30_O in VARCHAR2
292 ,P_ASS_ATTRIBUTE4_O in VARCHAR2
293 ,P_ASS_ATTRIBUTE5_O in VARCHAR2
294 ,P_ASS_ATTRIBUTE6_O in VARCHAR2
295 ,P_ASS_ATTRIBUTE7_O in VARCHAR2
296 ,P_ASS_ATTRIBUTE8_O in VARCHAR2
297 ,P_ASS_ATTRIBUTE9_O in VARCHAR2
298 ,P_ASS_ATTRIBUTE_CATEGORY_O in VARCHAR2
299 ,P_BARGAINING_UNIT_CODE_O in VARCHAR2
300 ,P_BUSINESS_GROUP_ID_O in NUMBER
301 ,P_CAGR_GRADE_DEF_ID_O in NUMBER
302 ,P_CAGR_ID_FLEX_NUM_O in NUMBER
303 ,P_CHANGE_REASON_O in VARCHAR2
304 ,P_COLLECTIVE_AGREEMENT_ID_O in NUMBER
305 ,P_COMMENT_ID_O in NUMBER
306 ,P_CONTRACT_ID_O in NUMBER
307 ,P_DATE_PROBATION_END_O in DATE
308 ,P_DEFAULT_CODE_COMB_ID_O in NUMBER
309 ,P_EFFECTIVE_END_DATE_O in DATE
310 ,P_EFFECTIVE_START_DATE_O in DATE
311 ,P_EMPLOYEE_CATEGORY_O in VARCHAR2
312 ,P_EMPLOYMENT_CATEGORY_O in VARCHAR2
313 ,P_ESTABLISHMENT_ID_O in NUMBER
314 ,P_FREQUENCY_O in VARCHAR2
315 ,P_GRADE_ID_O in NUMBER
316 ,P_HOURLY_SALARIED_CODE_O in VARCHAR2
317 ,P_INTERNAL_ADDRESS_LINE_O in VARCHAR2
318 ,P_JOB_ID_O in NUMBER
319 ,P_JOB_POST_SOURCE_NAME_O in VARCHAR2
320 ,P_LABOUR_UNION_MEMBER_FLAG_O in VARCHAR2
321 ,P_LOCATION_ID_O in NUMBER
322 ,P_MANAGER_FLAG_O in VARCHAR2
323 ,P_NORMAL_HOURS_O in NUMBER
324 ,P_NOTICE_PERIOD_O in NUMBER
325 ,P_NOTICE_PERIOD_UOM_O in VARCHAR2
326 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
327 ,P_ORGANIZATION_ID_O in NUMBER
328 ,P_PAYROLL_ID_O in NUMBER
329 ,P_PAY_BASIS_ID_O in NUMBER
330 ,P_PEOPLE_GROUP_ID_O in NUMBER
331 ,P_PERF_REVIEW_PERIOD_O in NUMBER
332 ,P_PERF_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
333 ,P_PERIOD_OF_SERVICE_ID_O in NUMBER
334 ,P_PERSON_ID_O in NUMBER
335 ,P_PERSON_REFERRED_BY_ID_O in NUMBER
336 ,P_PLACEMENT_DATE_START_O in DATE
337 ,P_POSITION_ID_O in NUMBER
338 ,P_POSTING_CONTENT_ID_O in NUMBER
339 ,P_PRIMARY_FLAG_O in VARCHAR2
340 ,P_PROBATION_PERIOD_O in NUMBER
341 ,P_PROBATION_UNIT_O in VARCHAR2
342 ,P_PROGRAM_APPLICATION_ID_O in NUMBER
343 ,P_PROGRAM_ID_O in NUMBER
344 ,P_PROGRAM_UPDATE_DATE_O in DATE
345 ,P_PROJECT_TITLE_O in VARCHAR2
349 ,P_SAL_REVIEW_PERIOD_O in NUMBER
346 ,P_RECRUITER_ID_O in NUMBER
347 ,P_RECRUITMENT_ACTIVITY_ID_O in NUMBER
348 ,P_REQUEST_ID_O in NUMBER
350 ,P_SAL_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
351 ,P_SET_OF_BOOKS_ID_O in NUMBER
352 ,P_SOFT_CODING_KEYFLEX_ID_O in NUMBER
353 ,P_SOURCE_ORGANIZATION_ID_O in NUMBER
354 ,P_SOURCE_TYPE_O in VARCHAR2
355 ,P_SPECIAL_CEILING_STEP_ID_O in NUMBER
356 ,P_SUPERVISOR_ID_O in NUMBER
357 ,P_TIME_NORMAL_FINISH_O in VARCHAR2
358 ,P_TIME_NORMAL_START_O in VARCHAR2
359 ,P_TITLE_O in VARCHAR2
360 ,P_VACANCY_ID_O in NUMBER
361 ,P_VENDOR_ASSIGNMENT_NUMBER_O in VARCHAR2
362 ,P_VENDOR_EMPLOYEE_NUMBER_O in VARCHAR2
363 ,P_VENDOR_ID_O in NUMBER
364 ,P_WORK_AT_HOME_O in VARCHAR2
365 ,P_GRADE_LADDER_PGM_ID_O in NUMBER
366 ,P_SUPERVISOR_ASSIGNMENT_ID_O in NUMBER
367 ,P_VENDOR_SITE_ID_O in NUMBER
368 ,P_PO_HEADER_ID_O in NUMBER
369 ,P_PO_LINE_ID_O in NUMBER
370 ,P_PROJECTED_ASSIGNMENT_END_O in DATE
371 ) IS
372 begin
373 hr_utility.trace('>> PAY_POG_ALL_ASSIGNMENTS_PKG.after_update');
374 --
375 dyt_mode := p_datetrack_mode;
376 --
377 pay_asg_process_grp_pkg.asg_update_trigger
378 (p_assignment_id => p_assignment_id,
379 p_person_id => p_person_id_o,
380 p_period_of_service_id => p_period_of_service_id,
381 p_old_effective_start_date => p_effective_start_date_o,
382 p_old_effective_end_date => p_effective_end_date_o,
383 p_new_effective_start_date => p_effective_start_date,
384 p_new_effective_end_date => p_effective_end_date,
385 p_old_payroll_id => p_payroll_id_o,
386 p_new_payroll_id => p_payroll_id,
387 p_business_group_id => p_business_group_id_o
388 );
389 --
390 end after_update;
391
392 PROCEDURE AFTER_DELETE
393 (
394 p_effective_date in DATE
395 ,p_datetrack_mode in VARCHAR2
396 ,p_validation_start_date in DATE
397 ,p_validation_end_date in DATE
398 ,P_ASSIGNMENT_ID in NUMBER
399 ,P_EFFECTIVE_END_DATE in DATE
400 ,P_EFFECTIVE_START_DATE in DATE
401 ,P_OBJECT_VERSION_NUMBER in NUMBER
402 ,P_ORG_NOW_NO_MANAGER_WARNING in BOOLEAN
403 ,P_APPLICANT_RANK_O in NUMBER
404 ,P_APPLICATION_ID_O in NUMBER
405 ,P_ASSIGNMENT_CATEGORY_O in VARCHAR2
406 ,P_ASSIGNMENT_NUMBER_O in VARCHAR2
407 ,P_ASSIGNMENT_SEQUENCE_O in NUMBER
408 ,P_ASSIGNMENT_STATUS_TYPE_ID_O in NUMBER
409 ,P_ASSIGNMENT_TYPE_O in VARCHAR2
410 ,P_ASS_ATTRIBUTE1_O in VARCHAR2
411 ,P_ASS_ATTRIBUTE10_O in VARCHAR2
412 ,P_ASS_ATTRIBUTE11_O in VARCHAR2
413 ,P_ASS_ATTRIBUTE12_O in VARCHAR2
414 ,P_ASS_ATTRIBUTE13_O in VARCHAR2
415 ,P_ASS_ATTRIBUTE14_O in VARCHAR2
416 ,P_ASS_ATTRIBUTE15_O in VARCHAR2
417 ,P_ASS_ATTRIBUTE16_O in VARCHAR2
418 ,P_ASS_ATTRIBUTE17_O in VARCHAR2
419 ,P_ASS_ATTRIBUTE18_O in VARCHAR2
420 ,P_ASS_ATTRIBUTE19_O in VARCHAR2
421 ,P_ASS_ATTRIBUTE2_O in VARCHAR2
422 ,P_ASS_ATTRIBUTE20_O in VARCHAR2
423 ,P_ASS_ATTRIBUTE21_O in VARCHAR2
424 ,P_ASS_ATTRIBUTE22_O in VARCHAR2
425 ,P_ASS_ATTRIBUTE23_O in VARCHAR2
426 ,P_ASS_ATTRIBUTE24_O in VARCHAR2
427 ,P_ASS_ATTRIBUTE25_O in VARCHAR2
428 ,P_ASS_ATTRIBUTE26_O in VARCHAR2
429 ,P_ASS_ATTRIBUTE27_O in VARCHAR2
430 ,P_ASS_ATTRIBUTE28_O in VARCHAR2
431 ,P_ASS_ATTRIBUTE29_O in VARCHAR2
432 ,P_ASS_ATTRIBUTE3_O in VARCHAR2
433 ,P_ASS_ATTRIBUTE30_O in VARCHAR2
434 ,P_ASS_ATTRIBUTE4_O in VARCHAR2
435 ,P_ASS_ATTRIBUTE5_O in VARCHAR2
436 ,P_ASS_ATTRIBUTE6_O in VARCHAR2
437 ,P_ASS_ATTRIBUTE7_O in VARCHAR2
438 ,P_ASS_ATTRIBUTE8_O in VARCHAR2
439 ,P_ASS_ATTRIBUTE9_O in VARCHAR2
440 ,P_ASS_ATTRIBUTE_CATEGORY_O in VARCHAR2
441 ,P_BARGAINING_UNIT_CODE_O in VARCHAR2
442 ,P_BUSINESS_GROUP_ID_O in NUMBER
443 ,P_CAGR_GRADE_DEF_ID_O in NUMBER
444 ,P_CAGR_ID_FLEX_NUM_O in NUMBER
445 ,P_CHANGE_REASON_O in VARCHAR2
446 ,P_COLLECTIVE_AGREEMENT_ID_O in NUMBER
447 ,P_COMMENT_ID_O in NUMBER
448 ,P_CONTRACT_ID_O in NUMBER
449 ,P_DATE_PROBATION_END_O in DATE
450 ,P_DEFAULT_CODE_COMB_ID_O in NUMBER
451 ,P_EFFECTIVE_END_DATE_O in DATE
452 ,P_EFFECTIVE_START_DATE_O in DATE
453 ,P_EMPLOYEE_CATEGORY_O in VARCHAR2
457 ,P_GRADE_ID_O in NUMBER
454 ,P_EMPLOYMENT_CATEGORY_O in VARCHAR2
455 ,P_ESTABLISHMENT_ID_O in NUMBER
456 ,P_FREQUENCY_O in VARCHAR2
458 ,P_HOURLY_SALARIED_CODE_O in VARCHAR2
459 ,P_INTERNAL_ADDRESS_LINE_O in VARCHAR2
460 ,P_JOB_ID_O in NUMBER
461 ,P_JOB_POST_SOURCE_NAME_O in VARCHAR2
462 ,P_LABOUR_UNION_MEMBER_FLAG_O in VARCHAR2
463 ,P_LOCATION_ID_O in NUMBER
464 ,P_MANAGER_FLAG_O in VARCHAR2
465 ,P_NORMAL_HOURS_O in NUMBER
466 ,P_NOTICE_PERIOD_O in NUMBER
467 ,P_NOTICE_PERIOD_UOM_O in VARCHAR2
468 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
469 ,P_ORGANIZATION_ID_O in NUMBER
470 ,P_PAYROLL_ID_O in NUMBER
471 ,P_PAY_BASIS_ID_O in NUMBER
472 ,P_PEOPLE_GROUP_ID_O in NUMBER
473 ,P_PERF_REVIEW_PERIOD_O in NUMBER
474 ,P_PERF_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
475 ,P_PERIOD_OF_SERVICE_ID_O in NUMBER
476 ,P_PERSON_ID_O in NUMBER
477 ,P_PERSON_REFERRED_BY_ID_O in NUMBER
478 ,P_PLACEMENT_DATE_START_O in DATE
479 ,P_POSITION_ID_O in NUMBER
480 ,P_POSTING_CONTENT_ID_O in NUMBER
481 ,P_PRIMARY_FLAG_O in VARCHAR2
482 ,P_PROBATION_PERIOD_O in NUMBER
483 ,P_PROBATION_UNIT_O in VARCHAR2
484 ,P_PROGRAM_APPLICATION_ID_O in NUMBER
485 ,P_PROGRAM_ID_O in NUMBER
486 ,P_PROGRAM_UPDATE_DATE_O in DATE
487 ,P_PROJECT_TITLE_O in VARCHAR2
488 ,P_RECRUITER_ID_O in NUMBER
489 ,P_RECRUITMENT_ACTIVITY_ID_O in NUMBER
490 ,P_REQUEST_ID_O in NUMBER
491 ,P_SAL_REVIEW_PERIOD_O in NUMBER
492 ,P_SAL_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
493 ,P_SET_OF_BOOKS_ID_O in NUMBER
494 ,P_SOFT_CODING_KEYFLEX_ID_O in NUMBER
495 ,P_SOURCE_ORGANIZATION_ID_O in NUMBER
496 ,P_SOURCE_TYPE_O in VARCHAR2
497 ,P_SPECIAL_CEILING_STEP_ID_O in NUMBER
498 ,P_SUPERVISOR_ID_O in NUMBER
499 ,P_TIME_NORMAL_FINISH_O in VARCHAR2
500 ,P_TIME_NORMAL_START_O in VARCHAR2
501 ,P_TITLE_O in VARCHAR2
502 ,P_VACANCY_ID_O in NUMBER
503 ,P_VENDOR_ASSIGNMENT_NUMBER_O in VARCHAR2
504 ,P_VENDOR_EMPLOYEE_NUMBER_O in VARCHAR2
505 ,P_VENDOR_ID_O in NUMBER
506 ,P_WORK_AT_HOME_O in VARCHAR2
507 ,P_GRADE_LADDER_PGM_ID_O in NUMBER
508 ,P_SUPERVISOR_ASSIGNMENT_ID_O in NUMBER
509 ,P_VENDOR_SITE_ID_O in NUMBER
510 ,P_PO_HEADER_ID_O in NUMBER
511 ,P_PO_LINE_ID_O in NUMBER
512 ,P_PROJECTED_ASSIGNMENT_END_O in DATE
513 ) IS
514 begin
515 hr_utility.trace('>> PAY_POG_ALL_ASSIGNMENTS_PKG.after_delete');
516 --
517 dyt_mode := p_datetrack_mode;
518 --
519 pay_asg_process_grp_pkg.asg_delete_trigger
520 (p_assignment_id => p_assignment_id,
521 p_effective_end_date => p_effective_end_date,
522 p_business_group_id => p_business_group_id_o,
523 p_effective_end_date_o => p_effective_end_date_o,
524 p_val_end_date => p_validation_end_date
525 );
526 --
527 end after_delete;
528
529 END PAY_POG_ALL_ASSIGNMENTS_PKG;
[Home] [Help]