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