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_BK5

Source


1 package body HR_ASSIGNMENT_BK5 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:46:22 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_APL_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_GRADE_ID in NUMBER
11 ,P_JOB_ID in NUMBER
12 ,P_PAYROLL_ID in NUMBER
13 ,P_LOCATION_ID in NUMBER
14 ,P_ORGANIZATION_ID in NUMBER
15 ,P_POSITION_ID in NUMBER
16 ,P_APPLICATION_ID in NUMBER
17 ,P_SPECIAL_CEILING_STEP_ID in NUMBER
18 ,P_RECRUITER_ID in NUMBER
19 ,P_RECRUITMENT_ACTIVITY_ID in NUMBER
20 ,P_SOFT_CODING_KEYFLEX_ID in NUMBER
21 ,P_VACANCY_ID in NUMBER
22 ,P_PAY_BASIS_ID in NUMBER
23 ,P_PERSON_REFERRED_BY_ID in NUMBER
24 ,P_SUPERVISOR_ID in NUMBER
25 ,P_SOURCE_ORGANIZATION_ID in NUMBER
26 ,P_CHANGE_REASON in VARCHAR2
27 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
28 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
29 ,P_DEFAULT_CODE_COMB_ID in NUMBER
30 ,P_EMPLOYMENT_CATEGORY in VARCHAR2
31 ,P_FREQUENCY in VARCHAR2
32 ,P_MANAGER_FLAG in VARCHAR2
33 ,P_NORMAL_HOURS in NUMBER
34 ,P_PERF_REVIEW_PERIOD in NUMBER
35 ,P_PERF_REVIEW_PERIOD_FREQUENCY in VARCHAR2
36 ,P_PROBATION_PERIOD in NUMBER
37 ,P_PROBATION_UNIT in VARCHAR2
38 ,P_SAL_REVIEW_PERIOD in NUMBER
39 ,P_SAL_REVIEW_PERIOD_FREQUENCY in VARCHAR2
40 ,P_SET_OF_BOOKS_ID in NUMBER
41 ,P_SOURCE_TYPE in VARCHAR2
42 ,P_TIME_NORMAL_FINISH in VARCHAR2
43 ,P_TIME_NORMAL_START in VARCHAR2
44 ,P_BARGAINING_UNIT_CODE in VARCHAR2
45 ,P_COMMENTS in VARCHAR2
46 ,P_DATE_PROBATION_END in DATE
47 ,P_TITLE in VARCHAR2
48 ,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
49 ,P_ASS_ATTRIBUTE1 in VARCHAR2
50 ,P_ASS_ATTRIBUTE2 in VARCHAR2
51 ,P_ASS_ATTRIBUTE3 in VARCHAR2
52 ,P_ASS_ATTRIBUTE4 in VARCHAR2
53 ,P_ASS_ATTRIBUTE5 in VARCHAR2
54 ,P_ASS_ATTRIBUTE6 in VARCHAR2
55 ,P_ASS_ATTRIBUTE7 in VARCHAR2
56 ,P_ASS_ATTRIBUTE8 in VARCHAR2
57 ,P_ASS_ATTRIBUTE9 in VARCHAR2
58 ,P_ASS_ATTRIBUTE10 in VARCHAR2
59 ,P_ASS_ATTRIBUTE11 in VARCHAR2
60 ,P_ASS_ATTRIBUTE12 in VARCHAR2
61 ,P_ASS_ATTRIBUTE13 in VARCHAR2
62 ,P_ASS_ATTRIBUTE14 in VARCHAR2
63 ,P_ASS_ATTRIBUTE15 in VARCHAR2
64 ,P_ASS_ATTRIBUTE16 in VARCHAR2
65 ,P_ASS_ATTRIBUTE17 in VARCHAR2
66 ,P_ASS_ATTRIBUTE18 in VARCHAR2
67 ,P_ASS_ATTRIBUTE19 in VARCHAR2
68 ,P_ASS_ATTRIBUTE20 in VARCHAR2
69 ,P_ASS_ATTRIBUTE21 in VARCHAR2
70 ,P_ASS_ATTRIBUTE22 in VARCHAR2
71 ,P_ASS_ATTRIBUTE23 in VARCHAR2
72 ,P_ASS_ATTRIBUTE24 in VARCHAR2
73 ,P_ASS_ATTRIBUTE25 in VARCHAR2
74 ,P_ASS_ATTRIBUTE26 in VARCHAR2
75 ,P_ASS_ATTRIBUTE27 in VARCHAR2
76 ,P_ASS_ATTRIBUTE28 in VARCHAR2
77 ,P_ASS_ATTRIBUTE29 in VARCHAR2
78 ,P_ASS_ATTRIBUTE30 in VARCHAR2
79 ,P_SCL_SEGMENT1 in VARCHAR2
80 ,P_SCL_SEGMENT2 in VARCHAR2
81 ,P_SCL_SEGMENT3 in VARCHAR2
82 ,P_SCL_SEGMENT4 in VARCHAR2
83 ,P_SCL_SEGMENT5 in VARCHAR2
84 ,P_SCL_SEGMENT6 in VARCHAR2
85 ,P_SCL_SEGMENT7 in VARCHAR2
86 ,P_SCL_SEGMENT8 in VARCHAR2
87 ,P_SCL_SEGMENT9 in VARCHAR2
88 ,P_SCL_SEGMENT10 in VARCHAR2
89 ,P_SCL_SEGMENT11 in VARCHAR2
90 ,P_SCL_SEGMENT12 in VARCHAR2
91 ,P_SCL_SEGMENT13 in VARCHAR2
92 ,P_SCL_SEGMENT14 in VARCHAR2
93 ,P_SCL_SEGMENT15 in VARCHAR2
94 ,P_SCL_SEGMENT16 in VARCHAR2
95 ,P_SCL_SEGMENT17 in VARCHAR2
96 ,P_SCL_SEGMENT18 in VARCHAR2
97 ,P_SCL_SEGMENT19 in VARCHAR2
98 ,P_SCL_SEGMENT20 in VARCHAR2
99 ,P_SCL_SEGMENT21 in VARCHAR2
100 ,P_SCL_SEGMENT22 in VARCHAR2
101 ,P_SCL_SEGMENT23 in VARCHAR2
102 ,P_SCL_SEGMENT24 in VARCHAR2
103 ,P_SCL_SEGMENT25 in VARCHAR2
104 ,P_SCL_SEGMENT26 in VARCHAR2
105 ,P_SCL_SEGMENT27 in VARCHAR2
106 ,P_SCL_SEGMENT28 in VARCHAR2
107 ,P_SCL_SEGMENT29 in VARCHAR2
108 ,P_SCL_SEGMENT30 in VARCHAR2
109 ,P_CONCATENATED_SEGMENTS in VARCHAR2
110 ,P_PGP_SEGMENT1 in VARCHAR2
111 ,P_PGP_SEGMENT2 in VARCHAR2
112 ,P_PGP_SEGMENT3 in VARCHAR2
113 ,P_PGP_SEGMENT4 in VARCHAR2
114 ,P_PGP_SEGMENT5 in VARCHAR2
115 ,P_PGP_SEGMENT6 in VARCHAR2
116 ,P_PGP_SEGMENT7 in VARCHAR2
117 ,P_PGP_SEGMENT8 in VARCHAR2
118 ,P_PGP_SEGMENT9 in VARCHAR2
119 ,P_PGP_SEGMENT10 in VARCHAR2
120 ,P_PGP_SEGMENT11 in VARCHAR2
121 ,P_PGP_SEGMENT12 in VARCHAR2
122 ,P_PGP_SEGMENT13 in VARCHAR2
123 ,P_PGP_SEGMENT14 in VARCHAR2
124 ,P_PGP_SEGMENT15 in VARCHAR2
125 ,P_PGP_SEGMENT16 in VARCHAR2
126 ,P_PGP_SEGMENT17 in VARCHAR2
127 ,P_PGP_SEGMENT18 in VARCHAR2
128 ,P_PGP_SEGMENT19 in VARCHAR2
129 ,P_PGP_SEGMENT20 in VARCHAR2
130 ,P_PGP_SEGMENT21 in VARCHAR2
131 ,P_PGP_SEGMENT22 in VARCHAR2
132 ,P_PGP_SEGMENT23 in VARCHAR2
133 ,P_PGP_SEGMENT24 in VARCHAR2
134 ,P_PGP_SEGMENT25 in VARCHAR2
135 ,P_PGP_SEGMENT26 in VARCHAR2
136 ,P_PGP_SEGMENT27 in VARCHAR2
137 ,P_PGP_SEGMENT28 in VARCHAR2
138 ,P_PGP_SEGMENT29 in VARCHAR2
139 ,P_PGP_SEGMENT30 in VARCHAR2
140 ,P_GROUP_NAME in VARCHAR2
141 ,P_COMMENT_ID in NUMBER
142 ,P_PEOPLE_GROUP_ID in NUMBER
143 ,P_EFFECTIVE_START_DATE in DATE
144 ,P_EFFECTIVE_END_DATE in DATE
145 ,P_SCL_CONCAT_SEGMENTS in VARCHAR2
146 ,P_CONCAT_SEGMENTS in VARCHAR2
147 ,P_CONTRACT_ID in NUMBER
148 ,P_ESTABLISHMENT_ID in NUMBER
149 ,P_COLLECTIVE_AGREEMENT_ID in NUMBER
150 ,P_CAGR_ID_FLEX_NUM in NUMBER
151 ,P_CAG_SEGMENT1 in VARCHAR2
152 ,P_CAG_SEGMENT2 in VARCHAR2
153 ,P_CAG_SEGMENT3 in VARCHAR2
154 ,P_CAG_SEGMENT4 in VARCHAR2
155 ,P_CAG_SEGMENT5 in VARCHAR2
156 ,P_CAG_SEGMENT6 in VARCHAR2
157 ,P_CAG_SEGMENT7 in VARCHAR2
158 ,P_CAG_SEGMENT8 in VARCHAR2
159 ,P_CAG_SEGMENT9 in VARCHAR2
160 ,P_CAG_SEGMENT10 in VARCHAR2
161 ,P_CAG_SEGMENT11 in VARCHAR2
162 ,P_CAG_SEGMENT12 in VARCHAR2
163 ,P_CAG_SEGMENT13 in VARCHAR2
164 ,P_CAG_SEGMENT14 in VARCHAR2
165 ,P_CAG_SEGMENT15 in VARCHAR2
166 ,P_CAG_SEGMENT16 in VARCHAR2
167 ,P_CAG_SEGMENT17 in VARCHAR2
168 ,P_CAG_SEGMENT18 in VARCHAR2
169 ,P_CAG_SEGMENT19 in VARCHAR2
170 ,P_CAG_SEGMENT20 in VARCHAR2
171 ,P_NOTICE_PERIOD in NUMBER
172 ,P_NOTICE_PERIOD_UOM in VARCHAR2
173 ,P_EMPLOYEE_CATEGORY in VARCHAR2
174 ,P_WORK_AT_HOME in VARCHAR2
175 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
176 ,P_CAGR_GRADE_DEF_ID in NUMBER
177 ,P_CAGR_CONCATENATED_SEGMENTS in VARCHAR2
178 ,P_APPLICANT_RANK in NUMBER
179 ,P_POSTING_CONTENT_ID in NUMBER
180 ,P_GRADE_LADDER_PGM_ID in NUMBER
181 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
182 )is
183 l_commit_unit_number number;
184 l_legislation_code   varchar2(30);
185 begin
186 hr_utility.set_location('Entering: HR_ASSIGNMENT_BK5.UPDATE_APL_ASG_A', 10);
187 l_commit_unit_number := hr_api.return_commit_unit;
188 if hr_api.call_app_hooks then
189 hr_assignment_be5.UPDATE_APL_ASG_A
190 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
191 ,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
192 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
193 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
194 ,P_GRADE_ID => P_GRADE_ID
195 ,P_JOB_ID => P_JOB_ID
196 ,P_PAYROLL_ID => P_PAYROLL_ID
197 ,P_LOCATION_ID => P_LOCATION_ID
198 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
199 ,P_POSITION_ID => P_POSITION_ID
200 ,P_APPLICATION_ID => P_APPLICATION_ID
201 ,P_SPECIAL_CEILING_STEP_ID => P_SPECIAL_CEILING_STEP_ID
202 ,P_RECRUITER_ID => P_RECRUITER_ID
203 ,P_RECRUITMENT_ACTIVITY_ID => P_RECRUITMENT_ACTIVITY_ID
204 ,P_SOFT_CODING_KEYFLEX_ID => P_SOFT_CODING_KEYFLEX_ID
205 ,P_VACANCY_ID => P_VACANCY_ID
206 ,P_PAY_BASIS_ID => P_PAY_BASIS_ID
207 ,P_PERSON_REFERRED_BY_ID => P_PERSON_REFERRED_BY_ID
208 ,P_SUPERVISOR_ID => P_SUPERVISOR_ID
209 ,P_SOURCE_ORGANIZATION_ID => P_SOURCE_ORGANIZATION_ID
210 ,P_CHANGE_REASON => P_CHANGE_REASON
211 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
212 ,P_INTERNAL_ADDRESS_LINE => P_INTERNAL_ADDRESS_LINE
213 ,P_DEFAULT_CODE_COMB_ID => P_DEFAULT_CODE_COMB_ID
214 ,P_EMPLOYMENT_CATEGORY => P_EMPLOYMENT_CATEGORY
215 ,P_FREQUENCY => P_FREQUENCY
216 ,P_MANAGER_FLAG => P_MANAGER_FLAG
217 ,P_NORMAL_HOURS => P_NORMAL_HOURS
218 ,P_PERF_REVIEW_PERIOD => P_PERF_REVIEW_PERIOD
219 ,P_PERF_REVIEW_PERIOD_FREQUENCY => P_PERF_REVIEW_PERIOD_FREQUENCY
220 ,P_PROBATION_PERIOD => P_PROBATION_PERIOD
221 ,P_PROBATION_UNIT => P_PROBATION_UNIT
222 ,P_SAL_REVIEW_PERIOD => P_SAL_REVIEW_PERIOD
223 ,P_SAL_REVIEW_PERIOD_FREQUENCY => P_SAL_REVIEW_PERIOD_FREQUENCY
224 ,P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
225 ,P_SOURCE_TYPE => P_SOURCE_TYPE
226 ,P_TIME_NORMAL_FINISH => P_TIME_NORMAL_FINISH
227 ,P_TIME_NORMAL_START => P_TIME_NORMAL_START
228 ,P_BARGAINING_UNIT_CODE => P_BARGAINING_UNIT_CODE
229 ,P_COMMENTS => P_COMMENTS
230 ,P_DATE_PROBATION_END => P_DATE_PROBATION_END
231 ,P_TITLE => P_TITLE
232 ,P_ASS_ATTRIBUTE_CATEGORY => P_ASS_ATTRIBUTE_CATEGORY
233 ,P_ASS_ATTRIBUTE1 => P_ASS_ATTRIBUTE1
234 ,P_ASS_ATTRIBUTE2 => P_ASS_ATTRIBUTE2
235 ,P_ASS_ATTRIBUTE3 => P_ASS_ATTRIBUTE3
236 ,P_ASS_ATTRIBUTE4 => P_ASS_ATTRIBUTE4
237 ,P_ASS_ATTRIBUTE5 => P_ASS_ATTRIBUTE5
238 ,P_ASS_ATTRIBUTE6 => P_ASS_ATTRIBUTE6
239 ,P_ASS_ATTRIBUTE7 => P_ASS_ATTRIBUTE7
240 ,P_ASS_ATTRIBUTE8 => P_ASS_ATTRIBUTE8
241 ,P_ASS_ATTRIBUTE9 => P_ASS_ATTRIBUTE9
242 ,P_ASS_ATTRIBUTE10 => P_ASS_ATTRIBUTE10
243 ,P_ASS_ATTRIBUTE11 => P_ASS_ATTRIBUTE11
244 ,P_ASS_ATTRIBUTE12 => P_ASS_ATTRIBUTE12
245 ,P_ASS_ATTRIBUTE13 => P_ASS_ATTRIBUTE13
246 ,P_ASS_ATTRIBUTE14 => P_ASS_ATTRIBUTE14
247 ,P_ASS_ATTRIBUTE15 => P_ASS_ATTRIBUTE15
248 ,P_ASS_ATTRIBUTE16 => P_ASS_ATTRIBUTE16
249 ,P_ASS_ATTRIBUTE17 => P_ASS_ATTRIBUTE17
250 ,P_ASS_ATTRIBUTE18 => P_ASS_ATTRIBUTE18
251 ,P_ASS_ATTRIBUTE19 => P_ASS_ATTRIBUTE19
252 ,P_ASS_ATTRIBUTE20 => P_ASS_ATTRIBUTE20
253 ,P_ASS_ATTRIBUTE21 => P_ASS_ATTRIBUTE21
254 ,P_ASS_ATTRIBUTE22 => P_ASS_ATTRIBUTE22
255 ,P_ASS_ATTRIBUTE23 => P_ASS_ATTRIBUTE23
256 ,P_ASS_ATTRIBUTE24 => P_ASS_ATTRIBUTE24
257 ,P_ASS_ATTRIBUTE25 => P_ASS_ATTRIBUTE25
258 ,P_ASS_ATTRIBUTE26 => P_ASS_ATTRIBUTE26
259 ,P_ASS_ATTRIBUTE27 => P_ASS_ATTRIBUTE27
260 ,P_ASS_ATTRIBUTE28 => P_ASS_ATTRIBUTE28
261 ,P_ASS_ATTRIBUTE29 => P_ASS_ATTRIBUTE29
262 ,P_ASS_ATTRIBUTE30 => P_ASS_ATTRIBUTE30
263 ,P_SCL_SEGMENT1 => P_SCL_SEGMENT1
264 ,P_SCL_SEGMENT2 => P_SCL_SEGMENT2
265 ,P_SCL_SEGMENT3 => P_SCL_SEGMENT3
266 ,P_SCL_SEGMENT4 => P_SCL_SEGMENT4
267 ,P_SCL_SEGMENT5 => P_SCL_SEGMENT5
268 ,P_SCL_SEGMENT6 => P_SCL_SEGMENT6
269 ,P_SCL_SEGMENT7 => P_SCL_SEGMENT7
270 ,P_SCL_SEGMENT8 => P_SCL_SEGMENT8
271 ,P_SCL_SEGMENT9 => P_SCL_SEGMENT9
272 ,P_SCL_SEGMENT10 => P_SCL_SEGMENT10
273 ,P_SCL_SEGMENT11 => P_SCL_SEGMENT11
274 ,P_SCL_SEGMENT12 => P_SCL_SEGMENT12
275 ,P_SCL_SEGMENT13 => P_SCL_SEGMENT13
276 ,P_SCL_SEGMENT14 => P_SCL_SEGMENT14
277 ,P_SCL_SEGMENT15 => P_SCL_SEGMENT15
278 ,P_SCL_SEGMENT16 => P_SCL_SEGMENT16
279 ,P_SCL_SEGMENT17 => P_SCL_SEGMENT17
280 ,P_SCL_SEGMENT18 => P_SCL_SEGMENT18
281 ,P_SCL_SEGMENT19 => P_SCL_SEGMENT19
282 ,P_SCL_SEGMENT20 => P_SCL_SEGMENT20
283 ,P_SCL_SEGMENT21 => P_SCL_SEGMENT21
284 ,P_SCL_SEGMENT22 => P_SCL_SEGMENT22
285 ,P_SCL_SEGMENT23 => P_SCL_SEGMENT23
286 ,P_SCL_SEGMENT24 => P_SCL_SEGMENT24
287 ,P_SCL_SEGMENT25 => P_SCL_SEGMENT25
288 ,P_SCL_SEGMENT26 => P_SCL_SEGMENT26
289 ,P_SCL_SEGMENT27 => P_SCL_SEGMENT27
290 ,P_SCL_SEGMENT28 => P_SCL_SEGMENT28
291 ,P_SCL_SEGMENT29 => P_SCL_SEGMENT29
292 ,P_SCL_SEGMENT30 => P_SCL_SEGMENT30
293 ,P_CONCATENATED_SEGMENTS => P_CONCATENATED_SEGMENTS
294 ,P_PGP_SEGMENT1 => P_PGP_SEGMENT1
295 ,P_PGP_SEGMENT2 => P_PGP_SEGMENT2
296 ,P_PGP_SEGMENT3 => P_PGP_SEGMENT3
297 ,P_PGP_SEGMENT4 => P_PGP_SEGMENT4
298 ,P_PGP_SEGMENT5 => P_PGP_SEGMENT5
299 ,P_PGP_SEGMENT6 => P_PGP_SEGMENT6
300 ,P_PGP_SEGMENT7 => P_PGP_SEGMENT7
301 ,P_PGP_SEGMENT8 => P_PGP_SEGMENT8
302 ,P_PGP_SEGMENT9 => P_PGP_SEGMENT9
303 ,P_PGP_SEGMENT10 => P_PGP_SEGMENT10
304 ,P_PGP_SEGMENT11 => P_PGP_SEGMENT11
305 ,P_PGP_SEGMENT12 => P_PGP_SEGMENT12
306 ,P_PGP_SEGMENT13 => P_PGP_SEGMENT13
307 ,P_PGP_SEGMENT14 => P_PGP_SEGMENT14
308 ,P_PGP_SEGMENT15 => P_PGP_SEGMENT15
309 ,P_PGP_SEGMENT16 => P_PGP_SEGMENT16
310 ,P_PGP_SEGMENT17 => P_PGP_SEGMENT17
311 ,P_PGP_SEGMENT18 => P_PGP_SEGMENT18
312 ,P_PGP_SEGMENT19 => P_PGP_SEGMENT19
313 ,P_PGP_SEGMENT20 => P_PGP_SEGMENT20
314 ,P_PGP_SEGMENT21 => P_PGP_SEGMENT21
315 ,P_PGP_SEGMENT22 => P_PGP_SEGMENT22
316 ,P_PGP_SEGMENT23 => P_PGP_SEGMENT23
317 ,P_PGP_SEGMENT24 => P_PGP_SEGMENT24
318 ,P_PGP_SEGMENT25 => P_PGP_SEGMENT25
319 ,P_PGP_SEGMENT26 => P_PGP_SEGMENT26
320 ,P_PGP_SEGMENT27 => P_PGP_SEGMENT27
321 ,P_PGP_SEGMENT28 => P_PGP_SEGMENT28
322 ,P_PGP_SEGMENT29 => P_PGP_SEGMENT29
323 ,P_PGP_SEGMENT30 => P_PGP_SEGMENT30
324 ,P_GROUP_NAME => P_GROUP_NAME
325 ,P_COMMENT_ID => P_COMMENT_ID
326 ,P_PEOPLE_GROUP_ID => P_PEOPLE_GROUP_ID
327 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
328 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
329 ,P_SCL_CONCAT_SEGMENTS => P_SCL_CONCAT_SEGMENTS
330 ,P_CONCAT_SEGMENTS => P_CONCAT_SEGMENTS
331 ,P_CONTRACT_ID => P_CONTRACT_ID
332 ,P_ESTABLISHMENT_ID => P_ESTABLISHMENT_ID
333 ,P_COLLECTIVE_AGREEMENT_ID => P_COLLECTIVE_AGREEMENT_ID
334 ,P_CAGR_ID_FLEX_NUM => P_CAGR_ID_FLEX_NUM
335 ,P_CAG_SEGMENT1 => P_CAG_SEGMENT1
336 ,P_CAG_SEGMENT2 => P_CAG_SEGMENT2
337 ,P_CAG_SEGMENT3 => P_CAG_SEGMENT3
338 ,P_CAG_SEGMENT4 => P_CAG_SEGMENT4
339 ,P_CAG_SEGMENT5 => P_CAG_SEGMENT5
340 ,P_CAG_SEGMENT6 => P_CAG_SEGMENT6
341 ,P_CAG_SEGMENT7 => P_CAG_SEGMENT7
342 ,P_CAG_SEGMENT8 => P_CAG_SEGMENT8
343 ,P_CAG_SEGMENT9 => P_CAG_SEGMENT9
344 ,P_CAG_SEGMENT10 => P_CAG_SEGMENT10
345 ,P_CAG_SEGMENT11 => P_CAG_SEGMENT11
346 ,P_CAG_SEGMENT12 => P_CAG_SEGMENT12
347 ,P_CAG_SEGMENT13 => P_CAG_SEGMENT13
348 ,P_CAG_SEGMENT14 => P_CAG_SEGMENT14
349 ,P_CAG_SEGMENT15 => P_CAG_SEGMENT15
350 ,P_CAG_SEGMENT16 => P_CAG_SEGMENT16
351 ,P_CAG_SEGMENT17 => P_CAG_SEGMENT17
352 ,P_CAG_SEGMENT18 => P_CAG_SEGMENT18
353 ,P_CAG_SEGMENT19 => P_CAG_SEGMENT19
354 ,P_CAG_SEGMENT20 => P_CAG_SEGMENT20
355 ,P_NOTICE_PERIOD => P_NOTICE_PERIOD
356 ,P_NOTICE_PERIOD_UOM => P_NOTICE_PERIOD_UOM
357 ,P_EMPLOYEE_CATEGORY => P_EMPLOYEE_CATEGORY
358 ,P_WORK_AT_HOME => P_WORK_AT_HOME
359 ,P_JOB_POST_SOURCE_NAME => P_JOB_POST_SOURCE_NAME
360 ,P_CAGR_GRADE_DEF_ID => P_CAGR_GRADE_DEF_ID
361 ,P_CAGR_CONCATENATED_SEGMENTS => P_CAGR_CONCATENATED_SEGMENTS
362 ,P_APPLICANT_RANK => P_APPLICANT_RANK
363 ,P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
364 ,P_GRADE_LADDER_PGM_ID => P_GRADE_LADDER_PGM_ID
365 ,P_SUPERVISOR_ASSIGNMENT_ID => P_SUPERVISOR_ASSIGNMENT_ID
366 );
367 end if;
368 hr_multi_message.end_validation_set;
369 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_APL_ASG', 'AP');
370 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK5.UPDATE_APL_ASG_A', 20);
371 end UPDATE_APL_ASG_A;
372 procedure UPDATE_APL_ASG_B
373 (P_EFFECTIVE_DATE in DATE
374 ,P_DATETRACK_UPDATE_MODE in VARCHAR2
375 ,P_ASSIGNMENT_ID in NUMBER
376 ,P_OBJECT_VERSION_NUMBER in NUMBER
377 ,P_GRADE_ID in NUMBER
378 ,P_JOB_ID in NUMBER
379 ,P_PAYROLL_ID in NUMBER
380 ,P_LOCATION_ID in NUMBER
381 ,P_ORGANIZATION_ID in NUMBER
382 ,P_POSITION_ID in NUMBER
383 ,P_APPLICATION_ID in NUMBER
384 ,P_SPECIAL_CEILING_STEP_ID in NUMBER
385 ,P_RECRUITER_ID in NUMBER
386 ,P_RECRUITMENT_ACTIVITY_ID in NUMBER
387 ,P_VACANCY_ID in NUMBER
388 ,P_PAY_BASIS_ID in NUMBER
389 ,P_PERSON_REFERRED_BY_ID in NUMBER
390 ,P_SUPERVISOR_ID in NUMBER
391 ,P_SOURCE_ORGANIZATION_ID in NUMBER
392 ,P_CHANGE_REASON in VARCHAR2
393 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
394 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
395 ,P_DEFAULT_CODE_COMB_ID in NUMBER
396 ,P_EMPLOYMENT_CATEGORY in VARCHAR2
397 ,P_FREQUENCY in VARCHAR2
398 ,P_MANAGER_FLAG in VARCHAR2
399 ,P_NORMAL_HOURS in NUMBER
400 ,P_PERF_REVIEW_PERIOD in NUMBER
401 ,P_PERF_REVIEW_PERIOD_FREQUENCY in VARCHAR2
402 ,P_PROBATION_PERIOD in NUMBER
403 ,P_PROBATION_UNIT in VARCHAR2
404 ,P_SAL_REVIEW_PERIOD in NUMBER
405 ,P_SAL_REVIEW_PERIOD_FREQUENCY in VARCHAR2
406 ,P_SET_OF_BOOKS_ID in NUMBER
407 ,P_SOURCE_TYPE in VARCHAR2
408 ,P_TIME_NORMAL_FINISH in VARCHAR2
409 ,P_TIME_NORMAL_START in VARCHAR2
410 ,P_BARGAINING_UNIT_CODE in VARCHAR2
411 ,P_COMMENTS in VARCHAR2
412 ,P_DATE_PROBATION_END in DATE
413 ,P_TITLE in VARCHAR2
414 ,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
415 ,P_ASS_ATTRIBUTE1 in VARCHAR2
416 ,P_ASS_ATTRIBUTE2 in VARCHAR2
417 ,P_ASS_ATTRIBUTE3 in VARCHAR2
418 ,P_ASS_ATTRIBUTE4 in VARCHAR2
419 ,P_ASS_ATTRIBUTE5 in VARCHAR2
420 ,P_ASS_ATTRIBUTE6 in VARCHAR2
421 ,P_ASS_ATTRIBUTE7 in VARCHAR2
422 ,P_ASS_ATTRIBUTE8 in VARCHAR2
423 ,P_ASS_ATTRIBUTE9 in VARCHAR2
424 ,P_ASS_ATTRIBUTE10 in VARCHAR2
425 ,P_ASS_ATTRIBUTE11 in VARCHAR2
426 ,P_ASS_ATTRIBUTE12 in VARCHAR2
427 ,P_ASS_ATTRIBUTE13 in VARCHAR2
428 ,P_ASS_ATTRIBUTE14 in VARCHAR2
429 ,P_ASS_ATTRIBUTE15 in VARCHAR2
430 ,P_ASS_ATTRIBUTE16 in VARCHAR2
431 ,P_ASS_ATTRIBUTE17 in VARCHAR2
432 ,P_ASS_ATTRIBUTE18 in VARCHAR2
433 ,P_ASS_ATTRIBUTE19 in VARCHAR2
434 ,P_ASS_ATTRIBUTE20 in VARCHAR2
435 ,P_ASS_ATTRIBUTE21 in VARCHAR2
436 ,P_ASS_ATTRIBUTE22 in VARCHAR2
437 ,P_ASS_ATTRIBUTE23 in VARCHAR2
438 ,P_ASS_ATTRIBUTE24 in VARCHAR2
439 ,P_ASS_ATTRIBUTE25 in VARCHAR2
440 ,P_ASS_ATTRIBUTE26 in VARCHAR2
441 ,P_ASS_ATTRIBUTE27 in VARCHAR2
442 ,P_ASS_ATTRIBUTE28 in VARCHAR2
443 ,P_ASS_ATTRIBUTE29 in VARCHAR2
444 ,P_ASS_ATTRIBUTE30 in VARCHAR2
445 ,P_SCL_SEGMENT1 in VARCHAR2
446 ,P_SCL_SEGMENT2 in VARCHAR2
447 ,P_SCL_SEGMENT3 in VARCHAR2
448 ,P_SCL_SEGMENT4 in VARCHAR2
449 ,P_SCL_SEGMENT5 in VARCHAR2
450 ,P_SCL_SEGMENT6 in VARCHAR2
451 ,P_SCL_SEGMENT7 in VARCHAR2
452 ,P_SCL_SEGMENT8 in VARCHAR2
453 ,P_SCL_SEGMENT9 in VARCHAR2
454 ,P_SCL_SEGMENT10 in VARCHAR2
455 ,P_SCL_SEGMENT11 in VARCHAR2
456 ,P_SCL_SEGMENT12 in VARCHAR2
457 ,P_SCL_SEGMENT13 in VARCHAR2
458 ,P_SCL_SEGMENT14 in VARCHAR2
459 ,P_SCL_SEGMENT15 in VARCHAR2
460 ,P_SCL_SEGMENT16 in VARCHAR2
461 ,P_SCL_SEGMENT17 in VARCHAR2
462 ,P_SCL_SEGMENT18 in VARCHAR2
463 ,P_SCL_SEGMENT19 in VARCHAR2
464 ,P_SCL_SEGMENT20 in VARCHAR2
465 ,P_SCL_SEGMENT21 in VARCHAR2
466 ,P_SCL_SEGMENT22 in VARCHAR2
467 ,P_SCL_SEGMENT23 in VARCHAR2
468 ,P_SCL_SEGMENT24 in VARCHAR2
469 ,P_SCL_SEGMENT25 in VARCHAR2
470 ,P_SCL_SEGMENT26 in VARCHAR2
471 ,P_SCL_SEGMENT27 in VARCHAR2
472 ,P_SCL_SEGMENT28 in VARCHAR2
473 ,P_SCL_SEGMENT29 in VARCHAR2
474 ,P_SCL_SEGMENT30 in VARCHAR2
475 ,P_SCL_CONCAT_SEGMENTS in VARCHAR2
476 ,P_PGP_SEGMENT1 in VARCHAR2
477 ,P_PGP_SEGMENT2 in VARCHAR2
478 ,P_PGP_SEGMENT3 in VARCHAR2
479 ,P_PGP_SEGMENT4 in VARCHAR2
480 ,P_PGP_SEGMENT5 in VARCHAR2
481 ,P_PGP_SEGMENT6 in VARCHAR2
482 ,P_PGP_SEGMENT7 in VARCHAR2
483 ,P_PGP_SEGMENT8 in VARCHAR2
484 ,P_PGP_SEGMENT9 in VARCHAR2
485 ,P_PGP_SEGMENT10 in VARCHAR2
486 ,P_PGP_SEGMENT11 in VARCHAR2
487 ,P_PGP_SEGMENT12 in VARCHAR2
488 ,P_PGP_SEGMENT13 in VARCHAR2
489 ,P_PGP_SEGMENT14 in VARCHAR2
490 ,P_PGP_SEGMENT15 in VARCHAR2
491 ,P_PGP_SEGMENT16 in VARCHAR2
492 ,P_PGP_SEGMENT17 in VARCHAR2
493 ,P_PGP_SEGMENT18 in VARCHAR2
494 ,P_PGP_SEGMENT19 in VARCHAR2
495 ,P_PGP_SEGMENT20 in VARCHAR2
496 ,P_PGP_SEGMENT21 in VARCHAR2
497 ,P_PGP_SEGMENT22 in VARCHAR2
498 ,P_PGP_SEGMENT23 in VARCHAR2
499 ,P_PGP_SEGMENT24 in VARCHAR2
500 ,P_PGP_SEGMENT25 in VARCHAR2
501 ,P_PGP_SEGMENT26 in VARCHAR2
502 ,P_PGP_SEGMENT27 in VARCHAR2
503 ,P_PGP_SEGMENT28 in VARCHAR2
504 ,P_PGP_SEGMENT29 in VARCHAR2
505 ,P_PGP_SEGMENT30 in VARCHAR2
506 ,P_CONCAT_SEGMENTS in VARCHAR2
507 ,P_CONTRACT_ID in NUMBER
508 ,P_ESTABLISHMENT_ID in NUMBER
509 ,P_COLLECTIVE_AGREEMENT_ID in NUMBER
510 ,P_CAGR_ID_FLEX_NUM in NUMBER
511 ,P_CAG_SEGMENT1 in VARCHAR2
512 ,P_CAG_SEGMENT2 in VARCHAR2
513 ,P_CAG_SEGMENT3 in VARCHAR2
514 ,P_CAG_SEGMENT4 in VARCHAR2
515 ,P_CAG_SEGMENT5 in VARCHAR2
516 ,P_CAG_SEGMENT6 in VARCHAR2
517 ,P_CAG_SEGMENT7 in VARCHAR2
518 ,P_CAG_SEGMENT8 in VARCHAR2
519 ,P_CAG_SEGMENT9 in VARCHAR2
520 ,P_CAG_SEGMENT10 in VARCHAR2
521 ,P_CAG_SEGMENT11 in VARCHAR2
522 ,P_CAG_SEGMENT12 in VARCHAR2
523 ,P_CAG_SEGMENT13 in VARCHAR2
524 ,P_CAG_SEGMENT14 in VARCHAR2
525 ,P_CAG_SEGMENT15 in VARCHAR2
526 ,P_CAG_SEGMENT16 in VARCHAR2
527 ,P_CAG_SEGMENT17 in VARCHAR2
528 ,P_CAG_SEGMENT18 in VARCHAR2
529 ,P_CAG_SEGMENT19 in VARCHAR2
530 ,P_CAG_SEGMENT20 in VARCHAR2
531 ,P_NOTICE_PERIOD in NUMBER
532 ,P_NOTICE_PERIOD_UOM in VARCHAR2
533 ,P_EMPLOYEE_CATEGORY in VARCHAR2
534 ,P_WORK_AT_HOME in VARCHAR2
535 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
536 ,P_APPLICANT_RANK in NUMBER
537 ,P_POSTING_CONTENT_ID in NUMBER
538 ,P_GRADE_LADDER_PGM_ID in NUMBER
539 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
540 )is
541 l_commit_unit_number number;
542 l_legislation_code   varchar2(30);
543 begin
544 hr_utility.set_location('Entering: HR_ASSIGNMENT_BK5.UPDATE_APL_ASG_B', 10);
545 l_commit_unit_number := hr_api.return_commit_unit;
546 if hr_api.call_leg_hooks then
547 l_legislation_code := PER_ASG_BUS1.return_legislation_code(P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
548 );
549 if l_legislation_code = 'IT' then
550 HR_IT_EXTRA_ASSGT_RULES.EXTRA_ASSIGNMENT_CHECKS
551 (P_EMPLOYMENT_CATEGORY => P_EMPLOYMENT_CATEGORY
552 );
553 end if;
554 end if;
555 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_APL_ASG', 'BP');
556 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK5.UPDATE_APL_ASG_B', 20);
557 end UPDATE_APL_ASG_B;
558 end HR_ASSIGNMENT_BK5;