eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.PER_ASG_RKU

Source


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