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.HR_ASSIGNMENT_BK2

Source


1 package body HR_ASSIGNMENT_BK2 as
2 /* $Header: peasgapi.pkb 120.20.12010000.4 2008/09/29 13:00:03 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:54:02 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_EMP_ASG_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_DATETRACK_UPDATE_MODE in VARCHAR2
8 ,P_ASSIGNMENT_ID in NUMBER
9 ,P_OBJECT_VERSION_NUMBER in NUMBER
10 ,P_SUPERVISOR_ID in NUMBER
11 ,P_ASSIGNMENT_NUMBER in VARCHAR2
12 ,P_CHANGE_REASON in VARCHAR2
13 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
14 ,P_COMMENTS in VARCHAR2
15 ,P_DATE_PROBATION_END in DATE
16 ,P_DEFAULT_CODE_COMB_ID in NUMBER
17 ,P_FREQUENCY in VARCHAR2
18 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
19 ,P_MANAGER_FLAG in VARCHAR2
20 ,P_NORMAL_HOURS in NUMBER
21 ,P_PERF_REVIEW_PERIOD in NUMBER
22 ,P_PERF_REVIEW_PERIOD_FREQUENCY in VARCHAR2
23 ,P_PROBATION_PERIOD in NUMBER
24 ,P_PROBATION_UNIT in VARCHAR2
25 ,P_PROJECTED_ASSIGNMENT_END in VARCHAR2
26 ,P_SAL_REVIEW_PERIOD in NUMBER
27 ,P_SAL_REVIEW_PERIOD_FREQUENCY in VARCHAR2
28 ,P_SET_OF_BOOKS_ID in NUMBER
29 ,P_SOURCE_TYPE in VARCHAR2
30 ,P_TIME_NORMAL_FINISH in VARCHAR2
31 ,P_TIME_NORMAL_START in VARCHAR2
32 ,P_BARGAINING_UNIT_CODE in VARCHAR2
33 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
34 ,P_HOURLY_SALARIED_CODE in VARCHAR2
35 ,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
36 ,P_ASS_ATTRIBUTE1 in VARCHAR2
37 ,P_ASS_ATTRIBUTE2 in VARCHAR2
38 ,P_ASS_ATTRIBUTE3 in VARCHAR2
39 ,P_ASS_ATTRIBUTE4 in VARCHAR2
40 ,P_ASS_ATTRIBUTE5 in VARCHAR2
41 ,P_ASS_ATTRIBUTE6 in VARCHAR2
42 ,P_ASS_ATTRIBUTE7 in VARCHAR2
43 ,P_ASS_ATTRIBUTE8 in VARCHAR2
44 ,P_ASS_ATTRIBUTE9 in VARCHAR2
45 ,P_ASS_ATTRIBUTE10 in VARCHAR2
46 ,P_ASS_ATTRIBUTE11 in VARCHAR2
47 ,P_ASS_ATTRIBUTE12 in VARCHAR2
48 ,P_ASS_ATTRIBUTE13 in VARCHAR2
49 ,P_ASS_ATTRIBUTE14 in VARCHAR2
50 ,P_ASS_ATTRIBUTE15 in VARCHAR2
51 ,P_ASS_ATTRIBUTE16 in VARCHAR2
52 ,P_ASS_ATTRIBUTE17 in VARCHAR2
53 ,P_ASS_ATTRIBUTE18 in VARCHAR2
54 ,P_ASS_ATTRIBUTE19 in VARCHAR2
55 ,P_ASS_ATTRIBUTE20 in VARCHAR2
56 ,P_ASS_ATTRIBUTE21 in VARCHAR2
57 ,P_ASS_ATTRIBUTE22 in VARCHAR2
58 ,P_ASS_ATTRIBUTE23 in VARCHAR2
59 ,P_ASS_ATTRIBUTE24 in VARCHAR2
60 ,P_ASS_ATTRIBUTE25 in VARCHAR2
61 ,P_ASS_ATTRIBUTE26 in VARCHAR2
62 ,P_ASS_ATTRIBUTE27 in VARCHAR2
63 ,P_ASS_ATTRIBUTE28 in VARCHAR2
64 ,P_ASS_ATTRIBUTE29 in VARCHAR2
65 ,P_ASS_ATTRIBUTE30 in VARCHAR2
66 ,P_TITLE in VARCHAR2
67 ,P_SEGMENT1 in VARCHAR2
68 ,P_SEGMENT2 in VARCHAR2
69 ,P_SEGMENT3 in VARCHAR2
70 ,P_SEGMENT4 in VARCHAR2
71 ,P_SEGMENT5 in VARCHAR2
72 ,P_SEGMENT6 in VARCHAR2
73 ,P_SEGMENT7 in VARCHAR2
74 ,P_SEGMENT8 in VARCHAR2
75 ,P_SEGMENT9 in VARCHAR2
76 ,P_SEGMENT10 in VARCHAR2
77 ,P_SEGMENT11 in VARCHAR2
78 ,P_SEGMENT12 in VARCHAR2
79 ,P_SEGMENT13 in VARCHAR2
80 ,P_SEGMENT14 in VARCHAR2
81 ,P_SEGMENT15 in VARCHAR2
82 ,P_SEGMENT16 in VARCHAR2
83 ,P_SEGMENT17 in VARCHAR2
84 ,P_SEGMENT18 in VARCHAR2
85 ,P_SEGMENT19 in VARCHAR2
86 ,P_SEGMENT20 in VARCHAR2
87 ,P_SEGMENT21 in VARCHAR2
88 ,P_SEGMENT22 in VARCHAR2
89 ,P_SEGMENT23 in VARCHAR2
90 ,P_SEGMENT24 in VARCHAR2
91 ,P_SEGMENT25 in VARCHAR2
92 ,P_SEGMENT26 in VARCHAR2
93 ,P_SEGMENT27 in VARCHAR2
94 ,P_SEGMENT28 in VARCHAR2
95 ,P_SEGMENT29 in VARCHAR2
96 ,P_SEGMENT30 in VARCHAR2
97 ,P_CONCATENATED_SEGMENTS in VARCHAR2
98 ,P_SOFT_CODING_KEYFLEX_ID in NUMBER
99 ,P_COMMENT_ID in NUMBER
100 ,P_EFFECTIVE_START_DATE in DATE
101 ,P_EFFECTIVE_END_DATE in DATE
102 ,P_NO_MANAGERS_WARNING in BOOLEAN
103 ,P_OTHER_MANAGER_WARNING in BOOLEAN
104 ,P_HOURLY_SALARIED_WARNING in BOOLEAN
105 ,P_CONCAT_SEGMENTS in VARCHAR2
106 ,P_CONTRACT_ID in NUMBER
107 ,P_ESTABLISHMENT_ID in NUMBER
108 ,P_COLLECTIVE_AGREEMENT_ID in NUMBER
109 ,P_CAGR_ID_FLEX_NUM in NUMBER
110 ,P_CAG_SEGMENT1 in VARCHAR2
111 ,P_CAG_SEGMENT2 in VARCHAR2
112 ,P_CAG_SEGMENT3 in VARCHAR2
113 ,P_CAG_SEGMENT4 in VARCHAR2
114 ,P_CAG_SEGMENT5 in VARCHAR2
115 ,P_CAG_SEGMENT6 in VARCHAR2
116 ,P_CAG_SEGMENT7 in VARCHAR2
117 ,P_CAG_SEGMENT8 in VARCHAR2
118 ,P_CAG_SEGMENT9 in VARCHAR2
119 ,P_CAG_SEGMENT10 in VARCHAR2
120 ,P_CAG_SEGMENT11 in VARCHAR2
121 ,P_CAG_SEGMENT12 in VARCHAR2
122 ,P_CAG_SEGMENT13 in VARCHAR2
123 ,P_CAG_SEGMENT14 in VARCHAR2
124 ,P_CAG_SEGMENT15 in VARCHAR2
125 ,P_CAG_SEGMENT16 in VARCHAR2
126 ,P_CAG_SEGMENT17 in VARCHAR2
127 ,P_CAG_SEGMENT18 in VARCHAR2
128 ,P_CAG_SEGMENT19 in VARCHAR2
129 ,P_CAG_SEGMENT20 in VARCHAR2
130 ,P_NOTICE_PERIOD in NUMBER
131 ,P_NOTICE_PERIOD_UOM in VARCHAR2
132 ,P_EMPLOYEE_CATEGORY in VARCHAR2
133 ,P_WORK_AT_HOME in VARCHAR2
134 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
135 ,P_CAGR_GRADE_DEF_ID in NUMBER
136 ,P_CAGR_CONCATENATED_SEGMENTS in VARCHAR2
137 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
138 )is
139 l_commit_unit_number number;
140 l_legislation_code   varchar2(30);
141 begin
142 hr_utility.set_location('Entering: HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_A', 10);
143 l_commit_unit_number := hr_api.return_commit_unit;
144 if hr_api.call_app_hooks then
145 hr_assignment_be2.UPDATE_EMP_ASG_A
146 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
147 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
148 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
149 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
150 ,P_SUPERVISOR_ID => P_SUPERVISOR_ID
151 ,P_ASSIGNMENT_NUMBER => P_ASSIGNMENT_NUMBER
152 ,P_CHANGE_REASON => P_CHANGE_REASON
153 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
154 ,P_COMMENTS => P_COMMENTS
155 ,P_DATE_PROBATION_END => P_DATE_PROBATION_END
156 ,P_DEFAULT_CODE_COMB_ID => P_DEFAULT_CODE_COMB_ID
157 ,P_FREQUENCY => P_FREQUENCY
158 ,P_INTERNAL_ADDRESS_LINE => P_INTERNAL_ADDRESS_LINE
159 ,P_MANAGER_FLAG => P_MANAGER_FLAG
160 ,P_NORMAL_HOURS => P_NORMAL_HOURS
161 ,P_PERF_REVIEW_PERIOD => P_PERF_REVIEW_PERIOD
162 ,P_PERF_REVIEW_PERIOD_FREQUENCY => P_PERF_REVIEW_PERIOD_FREQUENCY
163 ,P_PROBATION_PERIOD => P_PROBATION_PERIOD
164 ,P_PROBATION_UNIT => P_PROBATION_UNIT
165 ,P_PROJECTED_ASSIGNMENT_END => P_PROJECTED_ASSIGNMENT_END
166 ,P_SAL_REVIEW_PERIOD => P_SAL_REVIEW_PERIOD
167 ,P_SAL_REVIEW_PERIOD_FREQUENCY => P_SAL_REVIEW_PERIOD_FREQUENCY
168 ,P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
169 ,P_SOURCE_TYPE => P_SOURCE_TYPE
170 ,P_TIME_NORMAL_FINISH => P_TIME_NORMAL_FINISH
171 ,P_TIME_NORMAL_START => P_TIME_NORMAL_START
172 ,P_BARGAINING_UNIT_CODE => P_BARGAINING_UNIT_CODE
173 ,P_LABOUR_UNION_MEMBER_FLAG => P_LABOUR_UNION_MEMBER_FLAG
174 ,P_HOURLY_SALARIED_CODE => P_HOURLY_SALARIED_CODE
175 ,P_ASS_ATTRIBUTE_CATEGORY => P_ASS_ATTRIBUTE_CATEGORY
176 ,P_ASS_ATTRIBUTE1 => P_ASS_ATTRIBUTE1
177 ,P_ASS_ATTRIBUTE2 => P_ASS_ATTRIBUTE2
178 ,P_ASS_ATTRIBUTE3 => P_ASS_ATTRIBUTE3
179 ,P_ASS_ATTRIBUTE4 => P_ASS_ATTRIBUTE4
180 ,P_ASS_ATTRIBUTE5 => P_ASS_ATTRIBUTE5
181 ,P_ASS_ATTRIBUTE6 => P_ASS_ATTRIBUTE6
182 ,P_ASS_ATTRIBUTE7 => P_ASS_ATTRIBUTE7
183 ,P_ASS_ATTRIBUTE8 => P_ASS_ATTRIBUTE8
184 ,P_ASS_ATTRIBUTE9 => P_ASS_ATTRIBUTE9
185 ,P_ASS_ATTRIBUTE10 => P_ASS_ATTRIBUTE10
186 ,P_ASS_ATTRIBUTE11 => P_ASS_ATTRIBUTE11
187 ,P_ASS_ATTRIBUTE12 => P_ASS_ATTRIBUTE12
188 ,P_ASS_ATTRIBUTE13 => P_ASS_ATTRIBUTE13
189 ,P_ASS_ATTRIBUTE14 => P_ASS_ATTRIBUTE14
190 ,P_ASS_ATTRIBUTE15 => P_ASS_ATTRIBUTE15
191 ,P_ASS_ATTRIBUTE16 => P_ASS_ATTRIBUTE16
192 ,P_ASS_ATTRIBUTE17 => P_ASS_ATTRIBUTE17
193 ,P_ASS_ATTRIBUTE18 => P_ASS_ATTRIBUTE18
194 ,P_ASS_ATTRIBUTE19 => P_ASS_ATTRIBUTE19
195 ,P_ASS_ATTRIBUTE20 => P_ASS_ATTRIBUTE20
196 ,P_ASS_ATTRIBUTE21 => P_ASS_ATTRIBUTE21
197 ,P_ASS_ATTRIBUTE22 => P_ASS_ATTRIBUTE22
198 ,P_ASS_ATTRIBUTE23 => P_ASS_ATTRIBUTE23
199 ,P_ASS_ATTRIBUTE24 => P_ASS_ATTRIBUTE24
200 ,P_ASS_ATTRIBUTE25 => P_ASS_ATTRIBUTE25
201 ,P_ASS_ATTRIBUTE26 => P_ASS_ATTRIBUTE26
202 ,P_ASS_ATTRIBUTE27 => P_ASS_ATTRIBUTE27
203 ,P_ASS_ATTRIBUTE28 => P_ASS_ATTRIBUTE28
204 ,P_ASS_ATTRIBUTE29 => P_ASS_ATTRIBUTE29
205 ,P_ASS_ATTRIBUTE30 => P_ASS_ATTRIBUTE30
206 ,P_TITLE => P_TITLE
207 ,P_SEGMENT1 => P_SEGMENT1
208 ,P_SEGMENT2 => P_SEGMENT2
209 ,P_SEGMENT3 => P_SEGMENT3
210 ,P_SEGMENT4 => P_SEGMENT4
211 ,P_SEGMENT5 => P_SEGMENT5
212 ,P_SEGMENT6 => P_SEGMENT6
213 ,P_SEGMENT7 => P_SEGMENT7
214 ,P_SEGMENT8 => P_SEGMENT8
215 ,P_SEGMENT9 => P_SEGMENT9
216 ,P_SEGMENT10 => P_SEGMENT10
217 ,P_SEGMENT11 => P_SEGMENT11
218 ,P_SEGMENT12 => P_SEGMENT12
219 ,P_SEGMENT13 => P_SEGMENT13
220 ,P_SEGMENT14 => P_SEGMENT14
221 ,P_SEGMENT15 => P_SEGMENT15
222 ,P_SEGMENT16 => P_SEGMENT16
223 ,P_SEGMENT17 => P_SEGMENT17
224 ,P_SEGMENT18 => P_SEGMENT18
225 ,P_SEGMENT19 => P_SEGMENT19
226 ,P_SEGMENT20 => P_SEGMENT20
227 ,P_SEGMENT21 => P_SEGMENT21
228 ,P_SEGMENT22 => P_SEGMENT22
229 ,P_SEGMENT23 => P_SEGMENT23
230 ,P_SEGMENT24 => P_SEGMENT24
231 ,P_SEGMENT25 => P_SEGMENT25
232 ,P_SEGMENT26 => P_SEGMENT26
233 ,P_SEGMENT27 => P_SEGMENT27
234 ,P_SEGMENT28 => P_SEGMENT28
235 ,P_SEGMENT29 => P_SEGMENT29
236 ,P_SEGMENT30 => P_SEGMENT30
237 ,P_CONCATENATED_SEGMENTS => P_CONCATENATED_SEGMENTS
238 ,P_SOFT_CODING_KEYFLEX_ID => P_SOFT_CODING_KEYFLEX_ID
239 ,P_COMMENT_ID => P_COMMENT_ID
240 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
241 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
242 ,P_NO_MANAGERS_WARNING => P_NO_MANAGERS_WARNING
243 ,P_OTHER_MANAGER_WARNING => P_OTHER_MANAGER_WARNING
244 ,P_HOURLY_SALARIED_WARNING => P_HOURLY_SALARIED_WARNING
245 ,P_CONCAT_SEGMENTS => P_CONCAT_SEGMENTS
246 ,P_CONTRACT_ID => P_CONTRACT_ID
247 ,P_ESTABLISHMENT_ID => P_ESTABLISHMENT_ID
248 ,P_COLLECTIVE_AGREEMENT_ID => P_COLLECTIVE_AGREEMENT_ID
249 ,P_CAGR_ID_FLEX_NUM => P_CAGR_ID_FLEX_NUM
250 ,P_CAG_SEGMENT1 => P_CAG_SEGMENT1
251 ,P_CAG_SEGMENT2 => P_CAG_SEGMENT2
252 ,P_CAG_SEGMENT3 => P_CAG_SEGMENT3
253 ,P_CAG_SEGMENT4 => P_CAG_SEGMENT4
254 ,P_CAG_SEGMENT5 => P_CAG_SEGMENT5
255 ,P_CAG_SEGMENT6 => P_CAG_SEGMENT6
256 ,P_CAG_SEGMENT7 => P_CAG_SEGMENT7
257 ,P_CAG_SEGMENT8 => P_CAG_SEGMENT8
258 ,P_CAG_SEGMENT9 => P_CAG_SEGMENT9
259 ,P_CAG_SEGMENT10 => P_CAG_SEGMENT10
260 ,P_CAG_SEGMENT11 => P_CAG_SEGMENT11
261 ,P_CAG_SEGMENT12 => P_CAG_SEGMENT12
262 ,P_CAG_SEGMENT13 => P_CAG_SEGMENT13
263 ,P_CAG_SEGMENT14 => P_CAG_SEGMENT14
264 ,P_CAG_SEGMENT15 => P_CAG_SEGMENT15
265 ,P_CAG_SEGMENT16 => P_CAG_SEGMENT16
266 ,P_CAG_SEGMENT17 => P_CAG_SEGMENT17
267 ,P_CAG_SEGMENT18 => P_CAG_SEGMENT18
268 ,P_CAG_SEGMENT19 => P_CAG_SEGMENT19
269 ,P_CAG_SEGMENT20 => P_CAG_SEGMENT20
270 ,P_NOTICE_PERIOD => P_NOTICE_PERIOD
271 ,P_NOTICE_PERIOD_UOM => P_NOTICE_PERIOD_UOM
272 ,P_EMPLOYEE_CATEGORY => P_EMPLOYEE_CATEGORY
273 ,P_WORK_AT_HOME => P_WORK_AT_HOME
274 ,P_JOB_POST_SOURCE_NAME => P_JOB_POST_SOURCE_NAME
275 ,P_CAGR_GRADE_DEF_ID => P_CAGR_GRADE_DEF_ID
276 ,P_CAGR_CONCATENATED_SEGMENTS => P_CAGR_CONCATENATED_SEGMENTS
277 ,P_SUPERVISOR_ASSIGNMENT_ID => P_SUPERVISOR_ASSIGNMENT_ID
278 );
279 end if;
280 if hr_api.call_leg_hooks then
281 l_legislation_code := PER_ASG_BUS1.return_legislation_code(P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
282 );
283 if l_legislation_code = 'GB' then
284 PER_GB_PENSRV_SVPN.CREATE_GB_SPN
285 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
286 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
287 );
288 elsif l_legislation_code = 'PL' then
289 PER_PL_ASSIGNMENT.UPDATE_PL_EMP_ASG_A
290 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
291 ,P_SEGMENT3 => P_SEGMENT3
292 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
293 );
294 elsif l_legislation_code = 'US' then
295 PER_US_EXTRA_ASSIGNMENT_RULES.PAY_US_ASG_REPORTING
296 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
297 );
298 end if;
299 end if;
300 hr_multi_message.end_validation_set;
301 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EMP_ASG', 'AP');
302 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_A', 20);
303 end UPDATE_EMP_ASG_A;
304 procedure UPDATE_EMP_ASG_B
305 (P_EFFECTIVE_DATE in DATE
306 ,P_DATETRACK_UPDATE_MODE in VARCHAR2
307 ,P_ASSIGNMENT_ID in NUMBER
308 ,P_OBJECT_VERSION_NUMBER in NUMBER
309 ,P_SUPERVISOR_ID in NUMBER
310 ,P_ASSIGNMENT_NUMBER in VARCHAR2
311 ,P_CHANGE_REASON in VARCHAR2
312 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
313 ,P_COMMENTS in VARCHAR2
314 ,P_DATE_PROBATION_END in DATE
315 ,P_DEFAULT_CODE_COMB_ID in NUMBER
316 ,P_FREQUENCY in VARCHAR2
317 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
318 ,P_MANAGER_FLAG in VARCHAR2
319 ,P_NORMAL_HOURS in NUMBER
320 ,P_PERF_REVIEW_PERIOD in NUMBER
321 ,P_PERF_REVIEW_PERIOD_FREQUENCY in VARCHAR2
322 ,P_PROBATION_PERIOD in NUMBER
323 ,P_PROBATION_UNIT in VARCHAR2
324 ,P_PROJECTED_ASSIGNMENT_END in VARCHAR2
325 ,P_SAL_REVIEW_PERIOD in NUMBER
326 ,P_SAL_REVIEW_PERIOD_FREQUENCY in VARCHAR2
327 ,P_SET_OF_BOOKS_ID in NUMBER
328 ,P_SOURCE_TYPE in VARCHAR2
329 ,P_TIME_NORMAL_FINISH in VARCHAR2
330 ,P_TIME_NORMAL_START in VARCHAR2
331 ,P_BARGAINING_UNIT_CODE in VARCHAR2
332 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
333 ,P_HOURLY_SALARIED_CODE in VARCHAR2
334 ,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
335 ,P_ASS_ATTRIBUTE1 in VARCHAR2
336 ,P_ASS_ATTRIBUTE2 in VARCHAR2
337 ,P_ASS_ATTRIBUTE3 in VARCHAR2
338 ,P_ASS_ATTRIBUTE4 in VARCHAR2
339 ,P_ASS_ATTRIBUTE5 in VARCHAR2
340 ,P_ASS_ATTRIBUTE6 in VARCHAR2
341 ,P_ASS_ATTRIBUTE7 in VARCHAR2
342 ,P_ASS_ATTRIBUTE8 in VARCHAR2
343 ,P_ASS_ATTRIBUTE9 in VARCHAR2
344 ,P_ASS_ATTRIBUTE10 in VARCHAR2
345 ,P_ASS_ATTRIBUTE11 in VARCHAR2
346 ,P_ASS_ATTRIBUTE12 in VARCHAR2
347 ,P_ASS_ATTRIBUTE13 in VARCHAR2
348 ,P_ASS_ATTRIBUTE14 in VARCHAR2
349 ,P_ASS_ATTRIBUTE15 in VARCHAR2
350 ,P_ASS_ATTRIBUTE16 in VARCHAR2
351 ,P_ASS_ATTRIBUTE17 in VARCHAR2
352 ,P_ASS_ATTRIBUTE18 in VARCHAR2
353 ,P_ASS_ATTRIBUTE19 in VARCHAR2
354 ,P_ASS_ATTRIBUTE20 in VARCHAR2
355 ,P_ASS_ATTRIBUTE21 in VARCHAR2
356 ,P_ASS_ATTRIBUTE22 in VARCHAR2
357 ,P_ASS_ATTRIBUTE23 in VARCHAR2
358 ,P_ASS_ATTRIBUTE24 in VARCHAR2
359 ,P_ASS_ATTRIBUTE25 in VARCHAR2
360 ,P_ASS_ATTRIBUTE26 in VARCHAR2
361 ,P_ASS_ATTRIBUTE27 in VARCHAR2
362 ,P_ASS_ATTRIBUTE28 in VARCHAR2
363 ,P_ASS_ATTRIBUTE29 in VARCHAR2
364 ,P_ASS_ATTRIBUTE30 in VARCHAR2
365 ,P_TITLE in VARCHAR2
366 ,P_SEGMENT1 in VARCHAR2
367 ,P_SEGMENT2 in VARCHAR2
368 ,P_SEGMENT3 in VARCHAR2
369 ,P_SEGMENT4 in VARCHAR2
370 ,P_SEGMENT5 in VARCHAR2
371 ,P_SEGMENT6 in VARCHAR2
372 ,P_SEGMENT7 in VARCHAR2
373 ,P_SEGMENT8 in VARCHAR2
374 ,P_SEGMENT9 in VARCHAR2
375 ,P_SEGMENT10 in VARCHAR2
376 ,P_SEGMENT11 in VARCHAR2
377 ,P_SEGMENT12 in VARCHAR2
378 ,P_SEGMENT13 in VARCHAR2
379 ,P_SEGMENT14 in VARCHAR2
380 ,P_SEGMENT15 in VARCHAR2
381 ,P_SEGMENT16 in VARCHAR2
382 ,P_SEGMENT17 in VARCHAR2
383 ,P_SEGMENT18 in VARCHAR2
384 ,P_SEGMENT19 in VARCHAR2
385 ,P_SEGMENT20 in VARCHAR2
386 ,P_SEGMENT21 in VARCHAR2
387 ,P_SEGMENT22 in VARCHAR2
388 ,P_SEGMENT23 in VARCHAR2
389 ,P_SEGMENT24 in VARCHAR2
390 ,P_SEGMENT25 in VARCHAR2
391 ,P_SEGMENT26 in VARCHAR2
392 ,P_SEGMENT27 in VARCHAR2
393 ,P_SEGMENT28 in VARCHAR2
394 ,P_SEGMENT29 in VARCHAR2
395 ,P_SEGMENT30 in VARCHAR2
396 ,P_CONCAT_SEGMENTS in VARCHAR2
397 ,P_CONTRACT_ID in NUMBER
398 ,P_ESTABLISHMENT_ID in NUMBER
399 ,P_COLLECTIVE_AGREEMENT_ID in NUMBER
400 ,P_CAGR_ID_FLEX_NUM in NUMBER
401 ,P_CAG_SEGMENT1 in VARCHAR2
402 ,P_CAG_SEGMENT2 in VARCHAR2
403 ,P_CAG_SEGMENT3 in VARCHAR2
404 ,P_CAG_SEGMENT4 in VARCHAR2
405 ,P_CAG_SEGMENT5 in VARCHAR2
406 ,P_CAG_SEGMENT6 in VARCHAR2
407 ,P_CAG_SEGMENT7 in VARCHAR2
408 ,P_CAG_SEGMENT8 in VARCHAR2
409 ,P_CAG_SEGMENT9 in VARCHAR2
410 ,P_CAG_SEGMENT10 in VARCHAR2
411 ,P_CAG_SEGMENT11 in VARCHAR2
412 ,P_CAG_SEGMENT12 in VARCHAR2
413 ,P_CAG_SEGMENT13 in VARCHAR2
414 ,P_CAG_SEGMENT14 in VARCHAR2
415 ,P_CAG_SEGMENT15 in VARCHAR2
416 ,P_CAG_SEGMENT16 in VARCHAR2
417 ,P_CAG_SEGMENT17 in VARCHAR2
418 ,P_CAG_SEGMENT18 in VARCHAR2
419 ,P_CAG_SEGMENT19 in VARCHAR2
420 ,P_CAG_SEGMENT20 in VARCHAR2
421 ,P_NOTICE_PERIOD in NUMBER
422 ,P_NOTICE_PERIOD_UOM in VARCHAR2
423 ,P_EMPLOYEE_CATEGORY in VARCHAR2
424 ,P_WORK_AT_HOME in VARCHAR2
425 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
426 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
427 )is
428 l_commit_unit_number number;
429 l_legislation_code   varchar2(30);
430 begin
431 hr_utility.set_location('Entering: HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B', 10);
432 l_commit_unit_number := hr_api.return_commit_unit;
433 if hr_api.call_leg_hooks then
434 l_legislation_code := PER_ASG_BUS1.return_legislation_code(P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
435 );
436 if l_legislation_code = 'AE' then
437 HR_AE_VALIDATE_PKG.UPDATE_ASG_VALIDATE
438 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
439 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
440 ,P_SEGMENT1 => P_SEGMENT1
441 ,P_SEGMENT2 => P_SEGMENT2
442 ,P_SEGMENT3 => P_SEGMENT3
443 ,P_SEGMENT4 => P_SEGMENT4
444 ,P_SEGMENT5 => P_SEGMENT5
445 );
446 elsif l_legislation_code = 'AU' then
447 PER_AU_ASG_LEG_HOOK.UPDATE_AU_ASG
448 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
449 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
450 ,P_SEGMENT1 => P_SEGMENT1
451 );
452 elsif l_legislation_code = 'BE' then
453 HR_BE_EXTRA_PERSON_RULES.EXTRA_ASSIGNMENT_CHECKS
454 (P_EMPLOYEE_CATEGORY => P_EMPLOYEE_CATEGORY
455 );
456 elsif l_legislation_code = 'CN' then
457 PER_CN_ASG_LEG_HOOK.CHECK_EMP_ASG_UPDATE
458 (P_SEGMENT1 => P_SEGMENT1
459 ,P_SEGMENT20 => P_SEGMENT20
460 ,P_SEGMENT21 => P_SEGMENT21
461 ,P_SEGMENT22 => P_SEGMENT22
462 ,P_SEGMENT23 => P_SEGMENT23
463 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
464 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
465 );
466 elsif l_legislation_code = 'DE' then
467 HR_DE_EXTRA_ASSIGNMENT_CHECKS.ASSIGNMENT_CHECKS
468 (P_LABOUR_UNION_MEMBER_FLAG => P_LABOUR_UNION_MEMBER_FLAG
469 );
470 elsif l_legislation_code = 'DK' then
471 HR_DK_VALIDATE_PKG.VALIDATE_UPDATE_EMP_ASG
472 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
473 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
474 ,P_SEGMENT6 => P_SEGMENT6
475 ,P_SEGMENT7 => P_SEGMENT7
476 ,P_SEGMENT8 => P_SEGMENT8
477 ,P_SEGMENT9 => P_SEGMENT9
478 );
479 elsif l_legislation_code = 'FI' then
480 HR_FI_VALIDATE_PKG.UPDATE_ASG_VALIDATE
481 (P_SEGMENT2 => P_SEGMENT2
482 ,P_SEGMENT12 => P_SEGMENT12
483 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
484 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
485 );
486 elsif l_legislation_code = 'IN' then
487 PER_IN_ASG_LEG_HOOK.CHECK_ASG_UPDATE
488 (P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
489 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
490 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
491 ,P_SEGMENT1 => P_SEGMENT1
492 ,P_SEGMENT2 => P_SEGMENT2
493 ,P_SEGMENT3 => P_SEGMENT3
494 ,P_SEGMENT4 => P_SEGMENT4
495 ,P_SEGMENT5 => P_SEGMENT5
496 ,P_SEGMENT6 => P_SEGMENT6
497 ,P_SEGMENT8 => P_SEGMENT8
498 ,P_SEGMENT9 => P_SEGMENT9
499 ,P_SEGMENT10 => P_SEGMENT10
500 ,P_SEGMENT11 => P_SEGMENT11
501 );
502 elsif l_legislation_code = 'IT' then
503 HR_IT_EXTRA_PERSON_RULES.EXTRA_UPDATE_ASSIGNMENT_CHECKS
504 (P_COLLECTIVE_AGREEMENT_ID => P_COLLECTIVE_AGREEMENT_ID
505 ,P_CAGR_ID_FLEX_NUM => P_CAGR_ID_FLEX_NUM
506 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
507 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
508 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
509 ,P_CAG_SEGMENT1 => P_CAG_SEGMENT1
510 ,P_CAG_SEGMENT2 => P_CAG_SEGMENT2
511 ,P_CAG_SEGMENT3 => P_CAG_SEGMENT3
512 ,P_SEGMENT2 => P_SEGMENT2
513 );
514 elsif l_legislation_code = 'MX' then
515 HR_MX_EXTRA_ASG_RULES.CHK_GRE_FOR_LEAV_REASON
516 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
517 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
518 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
519 ,P_SEGMENT1 => P_SEGMENT1
520 );
521 elsif l_legislation_code = 'NL' then
522 HR_NL_EXTRA_ASG_RULES.EXTRA_ASSIGNMENT_CHECKS1
523 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
524 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
525 ,P_FREQUENCY => P_FREQUENCY
526 ,P_NORMAL_HOURS => P_NORMAL_HOURS
527 ,P_SEGMENT1 => P_SEGMENT1
528 ,P_SEGMENT2 => P_SEGMENT2
529 ,P_SEGMENT3 => P_SEGMENT3
530 ,P_SEGMENT4 => P_SEGMENT4
531 ,P_SEGMENT5 => P_SEGMENT5
532 ,P_SEGMENT6 => P_SEGMENT6
533 ,P_SEGMENT7 => P_SEGMENT7
534 ,P_SEGMENT8 => P_SEGMENT8
535 ,P_SEGMENT9 => P_SEGMENT9
536 ,P_SEGMENT10 => P_SEGMENT10
537 ,P_SEGMENT11 => P_SEGMENT11
538 ,P_SEGMENT12 => P_SEGMENT12
539 ,P_SEGMENT13 => P_SEGMENT13
540 ,P_SEGMENT14 => P_SEGMENT14
541 ,P_SEGMENT15 => P_SEGMENT15
542 ,P_SEGMENT16 => P_SEGMENT16
543 ,P_SEGMENT17 => P_SEGMENT17
544 ,P_SEGMENT18 => P_SEGMENT18
545 ,P_SEGMENT19 => P_SEGMENT19
546 ,P_SEGMENT20 => P_SEGMENT20
547 ,P_SEGMENT21 => P_SEGMENT21
548 ,P_SEGMENT22 => P_SEGMENT22
549 ,P_SEGMENT23 => P_SEGMENT23
550 ,P_SEGMENT24 => P_SEGMENT24
551 ,P_SEGMENT25 => P_SEGMENT25
552 ,P_SEGMENT26 => P_SEGMENT26
553 ,P_SEGMENT27 => P_SEGMENT27
554 ,P_SEGMENT28 => P_SEGMENT28
555 ,P_SEGMENT29 => P_SEGMENT29
556 ,P_SEGMENT30 => P_SEGMENT30
557 );
558 elsif l_legislation_code = 'NO' then
559 HR_NO_VALIDATE_PKG.UPDATE_ASG_VALIDATE
560 (P_SEGMENT12 => P_SEGMENT12
561 ,P_SEGMENT13 => P_SEGMENT13
562 ,P_SEGMENT14 => P_SEGMENT14
563 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
564 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
565 );
566 elsif l_legislation_code = 'PL' then
567 PER_PL_ASSIGNMENT.UPDATE_PL_EMP_ASG
568 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
569 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
570 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
571 ,P_SEGMENT3 => P_SEGMENT3
572 ,P_SEGMENT4 => P_SEGMENT4
573 ,P_SEGMENT5 => P_SEGMENT5
574 ,P_SEGMENT6 => P_SEGMENT6
575 ,P_SEGMENT7 => P_SEGMENT7
576 ,P_SEGMENT8 => P_SEGMENT8
577 ,P_SEGMENT9 => P_SEGMENT9
578 ,P_SEGMENT11 => P_SEGMENT11
579 ,P_SEGMENT12 => P_SEGMENT12
580 ,P_SEGMENT13 => P_SEGMENT13
581 ,P_SEGMENT14 => P_SEGMENT14
582 ,P_SEGMENT15 => P_SEGMENT15
583 ,P_SEGMENT16 => P_SEGMENT16
584 ,P_NOTICE_PERIOD => P_NOTICE_PERIOD
585 ,P_NOTICE_PERIOD_UOM => P_NOTICE_PERIOD_UOM
586 );
587 elsif l_legislation_code = 'RU' then
588 HR_RU_ASG_HOOK.VALIDATE_ASG_UPD_DETAILS
589 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
590 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
591 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
592 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
593 ,P_SEGMENT1 => P_SEGMENT1
594 ,P_SEGMENT2 => P_SEGMENT2
595 ,P_SEGMENT3 => P_SEGMENT3
596 ,P_SEGMENT4 => P_SEGMENT4
597 ,P_SEGMENT5 => P_SEGMENT5
598 ,P_SEGMENT6 => P_SEGMENT6
599 ,P_SEGMENT7 => P_SEGMENT7
600 ,P_SEGMENT8 => P_SEGMENT8
601 ,P_SEGMENT9 => P_SEGMENT9
602 ,P_SEGMENT10 => P_SEGMENT10
603 ,P_SEGMENT11 => P_SEGMENT11
604 ,P_SEGMENT12 => P_SEGMENT12
605 ,P_SEGMENT13 => P_SEGMENT13
606 ,P_SEGMENT14 => P_SEGMENT14
607 ,P_SEGMENT15 => P_SEGMENT15
608 );
609 elsif l_legislation_code = 'SA' then
610 HR_SA_VALIDATE_PKG.ASSIGNMENT_ANNUITIES_VALIDATE
611 (P_SEGMENT3 => P_SEGMENT3
612 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
613 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
614 );
615 elsif l_legislation_code = 'SE' then
616 HR_SE_VALIDATE_PKG.UPDATE_ASG_VALIDATE
617 (P_SEGMENT5 => P_SEGMENT5
618 ,P_SEGMENT6 => P_SEGMENT6
619 );
620 end if;
621 end if;
622 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EMP_ASG', 'BP');
623 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B', 20);
624 end UPDATE_EMP_ASG_B;
625 end HR_ASSIGNMENT_BK2;