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