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