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.37.12020000.11 2013/02/28 09:37:22 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2013/08/13 18:46:41 (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_ASG_AGGR.UPDATE_RTI_AGG_UPDATE_ASG
285 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
286 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
287 );
288 PER_ASG_AGGR.UPDATE_RTI_STARTER_ASG
289 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
290 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
291 );
292 PER_GB_PENSRV_SVPN.CREATE_GB_SPN
293 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
294 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
295 );
296 PER_GB_PENSRV_SVPN.AUTO_CALC_FTE
297 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
298 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
299 );
300 elsif l_legislation_code = 'PL' then
301 PER_PL_ASSIGNMENT.UPDATE_PL_EMP_ASG_A
302 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
303 ,P_SEGMENT3 => P_SEGMENT3
304 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
305 );
306 elsif l_legislation_code = 'US' then
307 PER_US_EXTRA_ASSIGNMENT_RULES.PAY_US_ASG_REPORTING
308 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
309 );
310 end if;
311 end if;
312 hr_multi_message.end_validation_set;
313 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EMP_ASG', 'AP');
314 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_A', 20);
315 end UPDATE_EMP_ASG_A;
316 procedure UPDATE_EMP_ASG_B
317 (P_EFFECTIVE_DATE in DATE
318 ,P_DATETRACK_UPDATE_MODE in VARCHAR2
319 ,P_ASSIGNMENT_ID in NUMBER
320 ,P_OBJECT_VERSION_NUMBER in NUMBER
321 ,P_SUPERVISOR_ID in NUMBER
322 ,P_ASSIGNMENT_NUMBER in VARCHAR2
323 ,P_CHANGE_REASON in VARCHAR2
324 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
325 ,P_COMMENTS in VARCHAR2
326 ,P_DATE_PROBATION_END in DATE
327 ,P_DEFAULT_CODE_COMB_ID in NUMBER
328 ,P_FREQUENCY in VARCHAR2
329 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
330 ,P_MANAGER_FLAG in VARCHAR2
331 ,P_NORMAL_HOURS in NUMBER
332 ,P_PERF_REVIEW_PERIOD in NUMBER
333 ,P_PERF_REVIEW_PERIOD_FREQUENCY in VARCHAR2
334 ,P_PROBATION_PERIOD in NUMBER
335 ,P_PROBATION_UNIT in VARCHAR2
336 ,P_PROJECTED_ASSIGNMENT_END in VARCHAR2
337 ,P_SAL_REVIEW_PERIOD in NUMBER
338 ,P_SAL_REVIEW_PERIOD_FREQUENCY in VARCHAR2
339 ,P_SET_OF_BOOKS_ID in NUMBER
340 ,P_SOURCE_TYPE in VARCHAR2
341 ,P_TIME_NORMAL_FINISH in VARCHAR2
342 ,P_TIME_NORMAL_START in VARCHAR2
343 ,P_BARGAINING_UNIT_CODE in VARCHAR2
344 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
345 ,P_HOURLY_SALARIED_CODE in VARCHAR2
346 ,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
347 ,P_ASS_ATTRIBUTE1 in VARCHAR2
348 ,P_ASS_ATTRIBUTE2 in VARCHAR2
349 ,P_ASS_ATTRIBUTE3 in VARCHAR2
350 ,P_ASS_ATTRIBUTE4 in VARCHAR2
351 ,P_ASS_ATTRIBUTE5 in VARCHAR2
352 ,P_ASS_ATTRIBUTE6 in VARCHAR2
353 ,P_ASS_ATTRIBUTE7 in VARCHAR2
354 ,P_ASS_ATTRIBUTE8 in VARCHAR2
355 ,P_ASS_ATTRIBUTE9 in VARCHAR2
356 ,P_ASS_ATTRIBUTE10 in VARCHAR2
357 ,P_ASS_ATTRIBUTE11 in VARCHAR2
358 ,P_ASS_ATTRIBUTE12 in VARCHAR2
359 ,P_ASS_ATTRIBUTE13 in VARCHAR2
360 ,P_ASS_ATTRIBUTE14 in VARCHAR2
361 ,P_ASS_ATTRIBUTE15 in VARCHAR2
362 ,P_ASS_ATTRIBUTE16 in VARCHAR2
363 ,P_ASS_ATTRIBUTE17 in VARCHAR2
364 ,P_ASS_ATTRIBUTE18 in VARCHAR2
365 ,P_ASS_ATTRIBUTE19 in VARCHAR2
366 ,P_ASS_ATTRIBUTE20 in VARCHAR2
367 ,P_ASS_ATTRIBUTE21 in VARCHAR2
368 ,P_ASS_ATTRIBUTE22 in VARCHAR2
369 ,P_ASS_ATTRIBUTE23 in VARCHAR2
370 ,P_ASS_ATTRIBUTE24 in VARCHAR2
371 ,P_ASS_ATTRIBUTE25 in VARCHAR2
372 ,P_ASS_ATTRIBUTE26 in VARCHAR2
373 ,P_ASS_ATTRIBUTE27 in VARCHAR2
374 ,P_ASS_ATTRIBUTE28 in VARCHAR2
375 ,P_ASS_ATTRIBUTE29 in VARCHAR2
376 ,P_ASS_ATTRIBUTE30 in VARCHAR2
377 ,P_TITLE in VARCHAR2
378 ,P_SEGMENT1 in VARCHAR2
379 ,P_SEGMENT2 in VARCHAR2
380 ,P_SEGMENT3 in VARCHAR2
381 ,P_SEGMENT4 in VARCHAR2
382 ,P_SEGMENT5 in VARCHAR2
383 ,P_SEGMENT6 in VARCHAR2
384 ,P_SEGMENT7 in VARCHAR2
385 ,P_SEGMENT8 in VARCHAR2
386 ,P_SEGMENT9 in VARCHAR2
387 ,P_SEGMENT10 in VARCHAR2
388 ,P_SEGMENT11 in VARCHAR2
389 ,P_SEGMENT12 in VARCHAR2
390 ,P_SEGMENT13 in VARCHAR2
391 ,P_SEGMENT14 in VARCHAR2
392 ,P_SEGMENT15 in VARCHAR2
393 ,P_SEGMENT16 in VARCHAR2
394 ,P_SEGMENT17 in VARCHAR2
395 ,P_SEGMENT18 in VARCHAR2
396 ,P_SEGMENT19 in VARCHAR2
397 ,P_SEGMENT20 in VARCHAR2
398 ,P_SEGMENT21 in VARCHAR2
399 ,P_SEGMENT22 in VARCHAR2
400 ,P_SEGMENT23 in VARCHAR2
401 ,P_SEGMENT24 in VARCHAR2
402 ,P_SEGMENT25 in VARCHAR2
403 ,P_SEGMENT26 in VARCHAR2
404 ,P_SEGMENT27 in VARCHAR2
405 ,P_SEGMENT28 in VARCHAR2
406 ,P_SEGMENT29 in VARCHAR2
407 ,P_SEGMENT30 in VARCHAR2
408 ,P_CONCAT_SEGMENTS in VARCHAR2
409 ,P_CONTRACT_ID in NUMBER
410 ,P_ESTABLISHMENT_ID in NUMBER
411 ,P_COLLECTIVE_AGREEMENT_ID in NUMBER
412 ,P_CAGR_ID_FLEX_NUM in NUMBER
413 ,P_CAG_SEGMENT1 in VARCHAR2
414 ,P_CAG_SEGMENT2 in VARCHAR2
415 ,P_CAG_SEGMENT3 in VARCHAR2
416 ,P_CAG_SEGMENT4 in VARCHAR2
417 ,P_CAG_SEGMENT5 in VARCHAR2
418 ,P_CAG_SEGMENT6 in VARCHAR2
419 ,P_CAG_SEGMENT7 in VARCHAR2
420 ,P_CAG_SEGMENT8 in VARCHAR2
421 ,P_CAG_SEGMENT9 in VARCHAR2
422 ,P_CAG_SEGMENT10 in VARCHAR2
423 ,P_CAG_SEGMENT11 in VARCHAR2
424 ,P_CAG_SEGMENT12 in VARCHAR2
425 ,P_CAG_SEGMENT13 in VARCHAR2
426 ,P_CAG_SEGMENT14 in VARCHAR2
427 ,P_CAG_SEGMENT15 in VARCHAR2
428 ,P_CAG_SEGMENT16 in VARCHAR2
429 ,P_CAG_SEGMENT17 in VARCHAR2
430 ,P_CAG_SEGMENT18 in VARCHAR2
431 ,P_CAG_SEGMENT19 in VARCHAR2
432 ,P_CAG_SEGMENT20 in VARCHAR2
433 ,P_NOTICE_PERIOD in NUMBER
434 ,P_NOTICE_PERIOD_UOM in VARCHAR2
435 ,P_EMPLOYEE_CATEGORY in VARCHAR2
436 ,P_WORK_AT_HOME in VARCHAR2
437 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
438 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
439 )is
440 l_commit_unit_number number;
441 l_legislation_code   varchar2(30);
442 begin
443 hr_utility.set_location('Entering: HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B', 10);
444 l_commit_unit_number := hr_api.return_commit_unit;
445 if hr_api.call_leg_hooks then
446 l_legislation_code := PER_ASG_BUS1.return_legislation_code(P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
447 );
448 if l_legislation_code = 'AE' then
449 HR_AE_VALIDATE_PKG.UPDATE_ASG_VALIDATE
450 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
451 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
452 ,P_SEGMENT1 => P_SEGMENT1
453 ,P_SEGMENT2 => P_SEGMENT2
454 ,P_SEGMENT3 => P_SEGMENT3
455 ,P_SEGMENT4 => P_SEGMENT4
456 ,P_SEGMENT5 => P_SEGMENT5
457 );
458 elsif l_legislation_code = 'AU' then
459 PER_AU_ASG_LEG_HOOK.UPDATE_AU_ASG
460 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
461 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
462 ,P_SEGMENT1 => P_SEGMENT1
463 );
464 elsif l_legislation_code = 'BE' then
465 HR_BE_EXTRA_PERSON_RULES.EXTRA_ASSIGNMENT_CHECKS
466 (P_EMPLOYEE_CATEGORY => P_EMPLOYEE_CATEGORY
467 );
468 elsif l_legislation_code = 'CN' then
469 PER_CN_ASG_LEG_HOOK.CHECK_EMP_ASG_UPDATE
470 (P_SEGMENT1 => P_SEGMENT1
471 ,P_SEGMENT20 => P_SEGMENT20
472 ,P_SEGMENT21 => P_SEGMENT21
473 ,P_SEGMENT22 => P_SEGMENT22
474 ,P_SEGMENT23 => P_SEGMENT23
475 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
476 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
477 );
478 elsif l_legislation_code = 'DE' then
479 HR_DE_EXTRA_ASSIGNMENT_CHECKS.ASSIGNMENT_CHECKS
480 (P_LABOUR_UNION_MEMBER_FLAG => P_LABOUR_UNION_MEMBER_FLAG
481 );
482 elsif l_legislation_code = 'DK' then
483 HR_DK_VALIDATE_PKG.VALIDATE_UPDATE_EMP_ASG
484 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
485 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
486 ,P_SEGMENT6 => P_SEGMENT6
487 ,P_SEGMENT7 => P_SEGMENT7
488 ,P_SEGMENT8 => P_SEGMENT8
489 ,P_SEGMENT9 => P_SEGMENT9
490 );
491 elsif l_legislation_code = 'FI' then
492 HR_FI_VALIDATE_PKG.UPDATE_ASG_VALIDATE
493 (P_SEGMENT2 => P_SEGMENT2
494 ,P_SEGMENT12 => P_SEGMENT12
495 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
496 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
497 );
498 elsif l_legislation_code = 'IN' then
499 PER_IN_ASG_LEG_HOOK.CHECK_ASG_UPDATE
500 (P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
501 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
502 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
503 ,P_SEGMENT1 => P_SEGMENT1
504 ,P_SEGMENT2 => P_SEGMENT2
505 ,P_SEGMENT3 => P_SEGMENT3
506 ,P_SEGMENT4 => P_SEGMENT4
507 ,P_SEGMENT5 => P_SEGMENT5
508 ,P_SEGMENT6 => P_SEGMENT6
509 ,P_SEGMENT8 => P_SEGMENT8
510 ,P_SEGMENT9 => P_SEGMENT9
511 ,P_SEGMENT10 => P_SEGMENT10
512 ,P_SEGMENT11 => P_SEGMENT11
513 );
514 elsif l_legislation_code = 'IT' then
515 HR_IT_EXTRA_PERSON_RULES.EXTRA_UPDATE_ASSIGNMENT_CHECKS
516 (P_COLLECTIVE_AGREEMENT_ID => P_COLLECTIVE_AGREEMENT_ID
517 ,P_CAGR_ID_FLEX_NUM => P_CAGR_ID_FLEX_NUM
518 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
519 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
520 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
521 ,P_CAG_SEGMENT1 => P_CAG_SEGMENT1
522 ,P_CAG_SEGMENT2 => P_CAG_SEGMENT2
523 ,P_CAG_SEGMENT3 => P_CAG_SEGMENT3
524 ,P_SEGMENT2 => P_SEGMENT2
525 );
526 elsif l_legislation_code = 'MX' then
527 HR_MX_EXTRA_ASG_RULES.CHK_GRE_FOR_LEAV_REASON
528 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
529 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
530 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
531 ,P_SEGMENT1 => P_SEGMENT1
532 );
533 elsif l_legislation_code = 'NL' then
534 HR_NL_EXTRA_ASG_RULES.EXTRA_ASSIGNMENT_CHECKS1
535 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
536 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
537 ,P_FREQUENCY => P_FREQUENCY
538 ,P_NORMAL_HOURS => P_NORMAL_HOURS
539 ,P_SEGMENT1 => P_SEGMENT1
540 ,P_SEGMENT2 => P_SEGMENT2
541 ,P_SEGMENT3 => P_SEGMENT3
542 ,P_SEGMENT4 => P_SEGMENT4
543 ,P_SEGMENT5 => P_SEGMENT5
544 ,P_SEGMENT6 => P_SEGMENT6
545 ,P_SEGMENT7 => P_SEGMENT7
546 ,P_SEGMENT8 => P_SEGMENT8
547 ,P_SEGMENT9 => P_SEGMENT9
548 ,P_SEGMENT10 => P_SEGMENT10
549 ,P_SEGMENT11 => P_SEGMENT11
550 ,P_SEGMENT12 => P_SEGMENT12
551 ,P_SEGMENT13 => P_SEGMENT13
552 ,P_SEGMENT14 => P_SEGMENT14
553 ,P_SEGMENT15 => P_SEGMENT15
554 ,P_SEGMENT16 => P_SEGMENT16
555 ,P_SEGMENT17 => P_SEGMENT17
556 ,P_SEGMENT18 => P_SEGMENT18
557 ,P_SEGMENT19 => P_SEGMENT19
558 ,P_SEGMENT20 => P_SEGMENT20
559 ,P_SEGMENT21 => P_SEGMENT21
560 ,P_SEGMENT22 => P_SEGMENT22
561 ,P_SEGMENT23 => P_SEGMENT23
562 ,P_SEGMENT24 => P_SEGMENT24
563 ,P_SEGMENT25 => P_SEGMENT25
564 ,P_SEGMENT26 => P_SEGMENT26
565 ,P_SEGMENT27 => P_SEGMENT27
566 ,P_SEGMENT28 => P_SEGMENT28
567 ,P_SEGMENT29 => P_SEGMENT29
568 ,P_SEGMENT30 => P_SEGMENT30
569 ,P_ESTABLISHMENT_ID => P_ESTABLISHMENT_ID
570 );
571 elsif l_legislation_code = 'NO' then
572 HR_NO_VALIDATE_PKG.UPDATE_ASG_VALIDATE
573 (P_SEGMENT12 => P_SEGMENT12
574 ,P_SEGMENT13 => P_SEGMENT13
575 ,P_SEGMENT14 => P_SEGMENT14
576 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
577 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
578 );
579 elsif l_legislation_code = 'PL' then
580 PER_PL_ASSIGNMENT.UPDATE_PL_EMP_ASG
581 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
582 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
583 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
584 ,P_SEGMENT3 => P_SEGMENT3
585 ,P_SEGMENT4 => P_SEGMENT4
586 ,P_SEGMENT5 => P_SEGMENT5
587 ,P_SEGMENT6 => P_SEGMENT6
588 ,P_SEGMENT7 => P_SEGMENT7
589 ,P_SEGMENT8 => P_SEGMENT8
590 ,P_SEGMENT9 => P_SEGMENT9
591 ,P_SEGMENT11 => P_SEGMENT11
592 ,P_SEGMENT12 => P_SEGMENT12
593 ,P_SEGMENT13 => P_SEGMENT13
594 ,P_SEGMENT14 => P_SEGMENT14
595 ,P_SEGMENT15 => P_SEGMENT15
596 ,P_SEGMENT16 => P_SEGMENT16
597 ,P_NOTICE_PERIOD => P_NOTICE_PERIOD
598 ,P_NOTICE_PERIOD_UOM => P_NOTICE_PERIOD_UOM
599 );
600 elsif l_legislation_code = 'RO' then
601 PER_RO_ASSIGNMENT_VAL.UPDATE_ASG_VALIDATE
602 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
603 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
604 ,P_CONTRACT_ID => P_CONTRACT_ID
605 );
606 elsif l_legislation_code = 'RU' then
607 HR_RU_ASG_HOOK.VALIDATE_ASG_UPD_DETAILS
608 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
609 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
610 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
611 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
612 ,P_SEGMENT1 => P_SEGMENT1
613 ,P_SEGMENT2 => P_SEGMENT2
614 ,P_SEGMENT3 => P_SEGMENT3
615 ,P_SEGMENT4 => P_SEGMENT4
616 ,P_SEGMENT5 => P_SEGMENT5
617 ,P_SEGMENT6 => P_SEGMENT6
618 ,P_SEGMENT7 => P_SEGMENT7
619 ,P_SEGMENT8 => P_SEGMENT8
620 ,P_SEGMENT9 => P_SEGMENT9
621 ,P_SEGMENT10 => P_SEGMENT10
622 ,P_SEGMENT11 => P_SEGMENT11
623 ,P_SEGMENT12 => P_SEGMENT12
624 ,P_SEGMENT13 => P_SEGMENT13
625 ,P_SEGMENT14 => P_SEGMENT14
626 ,P_SEGMENT15 => P_SEGMENT15
627 );
628 elsif l_legislation_code = 'SA' then
629 HR_SA_VALIDATE_PKG.ASSIGNMENT_ANNUITIES_VALIDATE
630 (P_SEGMENT3 => P_SEGMENT3
631 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
632 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
633 );
634 elsif l_legislation_code = 'SE' then
635 HR_SE_VALIDATE_PKG.UPDATE_ASG_VALIDATE
636 (P_SEGMENT5 => P_SEGMENT5
637 ,P_SEGMENT6 => P_SEGMENT6
638 );
639 elsif l_legislation_code = 'SG' then
640 PER_SG_ASG_LEG_HOOK.UPDATE_SG_ASG
641 (P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
642 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
643 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
644 ,P_SEGMENT1 => P_SEGMENT1
645 );
646 end if;
647 end if;
648 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EMP_ASG', 'BP');
649 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B', 20);
650 end UPDATE_EMP_ASG_B;
651 end HR_ASSIGNMENT_BK2;