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_BK1

Source


1 package body HR_ASSIGNMENT_BK1 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:37 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_SECONDARY_EMP_ASG_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_PERSON_ID in NUMBER
8 ,P_ORGANIZATION_ID in NUMBER
9 ,P_GRADE_ID in NUMBER
10 ,P_POSITION_ID in NUMBER
11 ,P_JOB_ID in NUMBER
12 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
13 ,P_PAYROLL_ID in NUMBER
14 ,P_LOCATION_ID in NUMBER
15 ,P_SUPERVISOR_ID in NUMBER
16 ,P_SPECIAL_CEILING_STEP_ID in NUMBER
17 ,P_PAY_BASIS_ID in NUMBER
18 ,P_ASSIGNMENT_NUMBER in VARCHAR2
19 ,P_CHANGE_REASON in VARCHAR2
20 ,P_COMMENTS in VARCHAR2
21 ,P_DATE_PROBATION_END in DATE
22 ,P_DEFAULT_CODE_COMB_ID in NUMBER
23 ,P_EMPLOYMENT_CATEGORY in VARCHAR2
24 ,P_FREQUENCY in VARCHAR2
25 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
26 ,P_MANAGER_FLAG in VARCHAR2
27 ,P_NORMAL_HOURS in NUMBER
28 ,P_PERF_REVIEW_PERIOD in NUMBER
29 ,P_PERF_REVIEW_PERIOD_FREQUENCY in VARCHAR2
30 ,P_PROBATION_PERIOD in NUMBER
31 ,P_PROBATION_UNIT in VARCHAR2
32 ,P_SAL_REVIEW_PERIOD in NUMBER
33 ,P_SAL_REVIEW_PERIOD_FREQUENCY in VARCHAR2
34 ,P_SET_OF_BOOKS_ID in NUMBER
35 ,P_SOURCE_TYPE in VARCHAR2
36 ,P_TIME_NORMAL_FINISH in VARCHAR2
37 ,P_TIME_NORMAL_START in VARCHAR2
38 ,P_BARGAINING_UNIT_CODE in VARCHAR2
39 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
40 ,P_HOURLY_SALARIED_CODE in VARCHAR2
41 ,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
42 ,P_ASS_ATTRIBUTE1 in VARCHAR2
43 ,P_ASS_ATTRIBUTE2 in VARCHAR2
44 ,P_ASS_ATTRIBUTE3 in VARCHAR2
45 ,P_ASS_ATTRIBUTE4 in VARCHAR2
46 ,P_ASS_ATTRIBUTE5 in VARCHAR2
47 ,P_ASS_ATTRIBUTE6 in VARCHAR2
48 ,P_ASS_ATTRIBUTE7 in VARCHAR2
49 ,P_ASS_ATTRIBUTE8 in VARCHAR2
50 ,P_ASS_ATTRIBUTE9 in VARCHAR2
51 ,P_ASS_ATTRIBUTE10 in VARCHAR2
52 ,P_ASS_ATTRIBUTE11 in VARCHAR2
53 ,P_ASS_ATTRIBUTE12 in VARCHAR2
54 ,P_ASS_ATTRIBUTE13 in VARCHAR2
55 ,P_ASS_ATTRIBUTE14 in VARCHAR2
56 ,P_ASS_ATTRIBUTE15 in VARCHAR2
57 ,P_ASS_ATTRIBUTE16 in VARCHAR2
58 ,P_ASS_ATTRIBUTE17 in VARCHAR2
59 ,P_ASS_ATTRIBUTE18 in VARCHAR2
60 ,P_ASS_ATTRIBUTE19 in VARCHAR2
61 ,P_ASS_ATTRIBUTE20 in VARCHAR2
62 ,P_ASS_ATTRIBUTE21 in VARCHAR2
63 ,P_ASS_ATTRIBUTE22 in VARCHAR2
64 ,P_ASS_ATTRIBUTE23 in VARCHAR2
65 ,P_ASS_ATTRIBUTE24 in VARCHAR2
66 ,P_ASS_ATTRIBUTE25 in VARCHAR2
67 ,P_ASS_ATTRIBUTE26 in VARCHAR2
68 ,P_ASS_ATTRIBUTE27 in VARCHAR2
69 ,P_ASS_ATTRIBUTE28 in VARCHAR2
70 ,P_ASS_ATTRIBUTE29 in VARCHAR2
71 ,P_ASS_ATTRIBUTE30 in VARCHAR2
72 ,P_TITLE in VARCHAR2
73 ,P_SCL_SEGMENT1 in VARCHAR2
74 ,P_SCL_SEGMENT2 in VARCHAR2
75 ,P_SCL_SEGMENT3 in VARCHAR2
76 ,P_SCL_SEGMENT4 in VARCHAR2
77 ,P_SCL_SEGMENT5 in VARCHAR2
78 ,P_SCL_SEGMENT6 in VARCHAR2
79 ,P_SCL_SEGMENT7 in VARCHAR2
80 ,P_SCL_SEGMENT8 in VARCHAR2
81 ,P_SCL_SEGMENT9 in VARCHAR2
82 ,P_SCL_SEGMENT10 in VARCHAR2
83 ,P_SCL_SEGMENT11 in VARCHAR2
84 ,P_SCL_SEGMENT12 in VARCHAR2
85 ,P_SCL_SEGMENT13 in VARCHAR2
86 ,P_SCL_SEGMENT14 in VARCHAR2
87 ,P_SCL_SEGMENT15 in VARCHAR2
88 ,P_SCL_SEGMENT16 in VARCHAR2
89 ,P_SCL_SEGMENT17 in VARCHAR2
90 ,P_SCL_SEGMENT18 in VARCHAR2
91 ,P_SCL_SEGMENT19 in VARCHAR2
92 ,P_SCL_SEGMENT20 in VARCHAR2
93 ,P_SCL_SEGMENT21 in VARCHAR2
94 ,P_SCL_SEGMENT22 in VARCHAR2
95 ,P_SCL_SEGMENT23 in VARCHAR2
96 ,P_SCL_SEGMENT24 in VARCHAR2
97 ,P_SCL_SEGMENT25 in VARCHAR2
98 ,P_SCL_SEGMENT26 in VARCHAR2
99 ,P_SCL_SEGMENT27 in VARCHAR2
100 ,P_SCL_SEGMENT28 in VARCHAR2
101 ,P_SCL_SEGMENT29 in VARCHAR2
102 ,P_SCL_SEGMENT30 in VARCHAR2
103 ,P_CONCATENATED_SEGMENTS in VARCHAR2
104 ,P_PGP_SEGMENT1 in VARCHAR2
105 ,P_PGP_SEGMENT2 in VARCHAR2
106 ,P_PGP_SEGMENT3 in VARCHAR2
107 ,P_PGP_SEGMENT4 in VARCHAR2
108 ,P_PGP_SEGMENT5 in VARCHAR2
109 ,P_PGP_SEGMENT6 in VARCHAR2
110 ,P_PGP_SEGMENT7 in VARCHAR2
111 ,P_PGP_SEGMENT8 in VARCHAR2
112 ,P_PGP_SEGMENT9 in VARCHAR2
113 ,P_PGP_SEGMENT10 in VARCHAR2
114 ,P_PGP_SEGMENT11 in VARCHAR2
115 ,P_PGP_SEGMENT12 in VARCHAR2
116 ,P_PGP_SEGMENT13 in VARCHAR2
117 ,P_PGP_SEGMENT14 in VARCHAR2
118 ,P_PGP_SEGMENT15 in VARCHAR2
119 ,P_PGP_SEGMENT16 in VARCHAR2
120 ,P_PGP_SEGMENT17 in VARCHAR2
121 ,P_PGP_SEGMENT18 in VARCHAR2
122 ,P_PGP_SEGMENT19 in VARCHAR2
123 ,P_PGP_SEGMENT20 in VARCHAR2
124 ,P_PGP_SEGMENT21 in VARCHAR2
125 ,P_PGP_SEGMENT22 in VARCHAR2
126 ,P_PGP_SEGMENT23 in VARCHAR2
127 ,P_PGP_SEGMENT24 in VARCHAR2
128 ,P_PGP_SEGMENT25 in VARCHAR2
129 ,P_PGP_SEGMENT26 in VARCHAR2
130 ,P_PGP_SEGMENT27 in VARCHAR2
131 ,P_PGP_SEGMENT28 in VARCHAR2
132 ,P_PGP_SEGMENT29 in VARCHAR2
133 ,P_PGP_SEGMENT30 in VARCHAR2
134 ,P_CONTRACT_ID in NUMBER
135 ,P_ESTABLISHMENT_ID in NUMBER
136 ,P_COLLECTIVE_AGREEMENT_ID in NUMBER
137 ,P_CAGR_ID_FLEX_NUM in NUMBER
138 ,P_CAG_SEGMENT1 in VARCHAR2
139 ,P_CAG_SEGMENT2 in VARCHAR2
140 ,P_CAG_SEGMENT3 in VARCHAR2
141 ,P_CAG_SEGMENT4 in VARCHAR2
142 ,P_CAG_SEGMENT5 in VARCHAR2
143 ,P_CAG_SEGMENT6 in VARCHAR2
144 ,P_CAG_SEGMENT7 in VARCHAR2
145 ,P_CAG_SEGMENT8 in VARCHAR2
146 ,P_CAG_SEGMENT9 in VARCHAR2
147 ,P_CAG_SEGMENT10 in VARCHAR2
148 ,P_CAG_SEGMENT11 in VARCHAR2
149 ,P_CAG_SEGMENT12 in VARCHAR2
150 ,P_CAG_SEGMENT13 in VARCHAR2
151 ,P_CAG_SEGMENT14 in VARCHAR2
152 ,P_CAG_SEGMENT15 in VARCHAR2
153 ,P_CAG_SEGMENT16 in VARCHAR2
154 ,P_CAG_SEGMENT17 in VARCHAR2
155 ,P_CAG_SEGMENT18 in VARCHAR2
156 ,P_CAG_SEGMENT19 in VARCHAR2
157 ,P_CAG_SEGMENT20 in VARCHAR2
158 ,P_NOTICE_PERIOD in NUMBER
159 ,P_NOTICE_PERIOD_UOM in VARCHAR2
160 ,P_EMPLOYEE_CATEGORY in VARCHAR2
161 ,P_WORK_AT_HOME in VARCHAR2
162 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
163 ,P_CAGR_CONCATENATED_SEGMENTS in VARCHAR2
164 ,P_CAGR_GRADE_DEF_ID in NUMBER
165 ,P_GROUP_NAME in VARCHAR2
166 ,P_ASSIGNMENT_ID in NUMBER
167 ,P_SOFT_CODING_KEYFLEX_ID in NUMBER
168 ,P_PEOPLE_GROUP_ID in NUMBER
169 ,P_OBJECT_VERSION_NUMBER in NUMBER
170 ,P_EFFECTIVE_START_DATE in DATE
171 ,P_EFFECTIVE_END_DATE in DATE
172 ,P_ASSIGNMENT_SEQUENCE in NUMBER
173 ,P_COMMENT_ID in NUMBER
174 ,P_OTHER_MANAGER_WARNING in BOOLEAN
175 ,P_HOURLY_SALARIED_WARNING in BOOLEAN
176 ,P_PGP_CONCAT_SEGMENTS in VARCHAR2
177 ,P_SCL_CONCAT_SEGMENTS in VARCHAR2
178 ,P_GRADE_LADDER_PGM_ID in NUMBER
179 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
180 )is
181 l_commit_unit_number number;
182 l_legislation_code   varchar2(30);
183 begin
184 hr_utility.set_location('Entering: HR_ASSIGNMENT_BK1.CREATE_SECONDARY_EMP_ASG_A', 10);
185 l_commit_unit_number := hr_api.return_commit_unit;
186 if hr_api.call_app_hooks then
187 hr_assignment_be1.CREATE_SECONDARY_EMP_ASG_A
188 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
189 ,P_PERSON_ID => P_PERSON_ID
190 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
191 ,P_GRADE_ID => P_GRADE_ID
192 ,P_POSITION_ID => P_POSITION_ID
193 ,P_JOB_ID => P_JOB_ID
194 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
195 ,P_PAYROLL_ID => P_PAYROLL_ID
196 ,P_LOCATION_ID => P_LOCATION_ID
197 ,P_SUPERVISOR_ID => P_SUPERVISOR_ID
198 ,P_SPECIAL_CEILING_STEP_ID => P_SPECIAL_CEILING_STEP_ID
199 ,P_PAY_BASIS_ID => P_PAY_BASIS_ID
200 ,P_ASSIGNMENT_NUMBER => P_ASSIGNMENT_NUMBER
201 ,P_CHANGE_REASON => P_CHANGE_REASON
202 ,P_COMMENTS => P_COMMENTS
203 ,P_DATE_PROBATION_END => P_DATE_PROBATION_END
204 ,P_DEFAULT_CODE_COMB_ID => P_DEFAULT_CODE_COMB_ID
205 ,P_EMPLOYMENT_CATEGORY => P_EMPLOYMENT_CATEGORY
206 ,P_FREQUENCY => P_FREQUENCY
207 ,P_INTERNAL_ADDRESS_LINE => P_INTERNAL_ADDRESS_LINE
208 ,P_MANAGER_FLAG => P_MANAGER_FLAG
209 ,P_NORMAL_HOURS => P_NORMAL_HOURS
210 ,P_PERF_REVIEW_PERIOD => P_PERF_REVIEW_PERIOD
211 ,P_PERF_REVIEW_PERIOD_FREQUENCY => P_PERF_REVIEW_PERIOD_FREQUENCY
212 ,P_PROBATION_PERIOD => P_PROBATION_PERIOD
213 ,P_PROBATION_UNIT => P_PROBATION_UNIT
214 ,P_SAL_REVIEW_PERIOD => P_SAL_REVIEW_PERIOD
215 ,P_SAL_REVIEW_PERIOD_FREQUENCY => P_SAL_REVIEW_PERIOD_FREQUENCY
216 ,P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
217 ,P_SOURCE_TYPE => P_SOURCE_TYPE
218 ,P_TIME_NORMAL_FINISH => P_TIME_NORMAL_FINISH
219 ,P_TIME_NORMAL_START => P_TIME_NORMAL_START
220 ,P_BARGAINING_UNIT_CODE => P_BARGAINING_UNIT_CODE
221 ,P_LABOUR_UNION_MEMBER_FLAG => P_LABOUR_UNION_MEMBER_FLAG
222 ,P_HOURLY_SALARIED_CODE => P_HOURLY_SALARIED_CODE
223 ,P_ASS_ATTRIBUTE_CATEGORY => P_ASS_ATTRIBUTE_CATEGORY
224 ,P_ASS_ATTRIBUTE1 => P_ASS_ATTRIBUTE1
225 ,P_ASS_ATTRIBUTE2 => P_ASS_ATTRIBUTE2
226 ,P_ASS_ATTRIBUTE3 => P_ASS_ATTRIBUTE3
227 ,P_ASS_ATTRIBUTE4 => P_ASS_ATTRIBUTE4
228 ,P_ASS_ATTRIBUTE5 => P_ASS_ATTRIBUTE5
229 ,P_ASS_ATTRIBUTE6 => P_ASS_ATTRIBUTE6
230 ,P_ASS_ATTRIBUTE7 => P_ASS_ATTRIBUTE7
231 ,P_ASS_ATTRIBUTE8 => P_ASS_ATTRIBUTE8
232 ,P_ASS_ATTRIBUTE9 => P_ASS_ATTRIBUTE9
233 ,P_ASS_ATTRIBUTE10 => P_ASS_ATTRIBUTE10
234 ,P_ASS_ATTRIBUTE11 => P_ASS_ATTRIBUTE11
235 ,P_ASS_ATTRIBUTE12 => P_ASS_ATTRIBUTE12
236 ,P_ASS_ATTRIBUTE13 => P_ASS_ATTRIBUTE13
237 ,P_ASS_ATTRIBUTE14 => P_ASS_ATTRIBUTE14
238 ,P_ASS_ATTRIBUTE15 => P_ASS_ATTRIBUTE15
239 ,P_ASS_ATTRIBUTE16 => P_ASS_ATTRIBUTE16
240 ,P_ASS_ATTRIBUTE17 => P_ASS_ATTRIBUTE17
241 ,P_ASS_ATTRIBUTE18 => P_ASS_ATTRIBUTE18
242 ,P_ASS_ATTRIBUTE19 => P_ASS_ATTRIBUTE19
243 ,P_ASS_ATTRIBUTE20 => P_ASS_ATTRIBUTE20
244 ,P_ASS_ATTRIBUTE21 => P_ASS_ATTRIBUTE21
245 ,P_ASS_ATTRIBUTE22 => P_ASS_ATTRIBUTE22
246 ,P_ASS_ATTRIBUTE23 => P_ASS_ATTRIBUTE23
247 ,P_ASS_ATTRIBUTE24 => P_ASS_ATTRIBUTE24
248 ,P_ASS_ATTRIBUTE25 => P_ASS_ATTRIBUTE25
249 ,P_ASS_ATTRIBUTE26 => P_ASS_ATTRIBUTE26
250 ,P_ASS_ATTRIBUTE27 => P_ASS_ATTRIBUTE27
251 ,P_ASS_ATTRIBUTE28 => P_ASS_ATTRIBUTE28
252 ,P_ASS_ATTRIBUTE29 => P_ASS_ATTRIBUTE29
253 ,P_ASS_ATTRIBUTE30 => P_ASS_ATTRIBUTE30
254 ,P_TITLE => P_TITLE
255 ,P_SCL_SEGMENT1 => P_SCL_SEGMENT1
256 ,P_SCL_SEGMENT2 => P_SCL_SEGMENT2
257 ,P_SCL_SEGMENT3 => P_SCL_SEGMENT3
258 ,P_SCL_SEGMENT4 => P_SCL_SEGMENT4
259 ,P_SCL_SEGMENT5 => P_SCL_SEGMENT5
260 ,P_SCL_SEGMENT6 => P_SCL_SEGMENT6
261 ,P_SCL_SEGMENT7 => P_SCL_SEGMENT7
262 ,P_SCL_SEGMENT8 => P_SCL_SEGMENT8
263 ,P_SCL_SEGMENT9 => P_SCL_SEGMENT9
264 ,P_SCL_SEGMENT10 => P_SCL_SEGMENT10
265 ,P_SCL_SEGMENT11 => P_SCL_SEGMENT11
266 ,P_SCL_SEGMENT12 => P_SCL_SEGMENT12
267 ,P_SCL_SEGMENT13 => P_SCL_SEGMENT13
268 ,P_SCL_SEGMENT14 => P_SCL_SEGMENT14
269 ,P_SCL_SEGMENT15 => P_SCL_SEGMENT15
270 ,P_SCL_SEGMENT16 => P_SCL_SEGMENT16
271 ,P_SCL_SEGMENT17 => P_SCL_SEGMENT17
272 ,P_SCL_SEGMENT18 => P_SCL_SEGMENT18
273 ,P_SCL_SEGMENT19 => P_SCL_SEGMENT19
274 ,P_SCL_SEGMENT20 => P_SCL_SEGMENT20
275 ,P_SCL_SEGMENT21 => P_SCL_SEGMENT21
276 ,P_SCL_SEGMENT22 => P_SCL_SEGMENT22
277 ,P_SCL_SEGMENT23 => P_SCL_SEGMENT23
278 ,P_SCL_SEGMENT24 => P_SCL_SEGMENT24
279 ,P_SCL_SEGMENT25 => P_SCL_SEGMENT25
280 ,P_SCL_SEGMENT26 => P_SCL_SEGMENT26
281 ,P_SCL_SEGMENT27 => P_SCL_SEGMENT27
282 ,P_SCL_SEGMENT28 => P_SCL_SEGMENT28
283 ,P_SCL_SEGMENT29 => P_SCL_SEGMENT29
284 ,P_SCL_SEGMENT30 => P_SCL_SEGMENT30
285 ,P_CONCATENATED_SEGMENTS => P_CONCATENATED_SEGMENTS
286 ,P_PGP_SEGMENT1 => P_PGP_SEGMENT1
287 ,P_PGP_SEGMENT2 => P_PGP_SEGMENT2
288 ,P_PGP_SEGMENT3 => P_PGP_SEGMENT3
289 ,P_PGP_SEGMENT4 => P_PGP_SEGMENT4
290 ,P_PGP_SEGMENT5 => P_PGP_SEGMENT5
291 ,P_PGP_SEGMENT6 => P_PGP_SEGMENT6
292 ,P_PGP_SEGMENT7 => P_PGP_SEGMENT7
293 ,P_PGP_SEGMENT8 => P_PGP_SEGMENT8
294 ,P_PGP_SEGMENT9 => P_PGP_SEGMENT9
295 ,P_PGP_SEGMENT10 => P_PGP_SEGMENT10
296 ,P_PGP_SEGMENT11 => P_PGP_SEGMENT11
297 ,P_PGP_SEGMENT12 => P_PGP_SEGMENT12
298 ,P_PGP_SEGMENT13 => P_PGP_SEGMENT13
299 ,P_PGP_SEGMENT14 => P_PGP_SEGMENT14
300 ,P_PGP_SEGMENT15 => P_PGP_SEGMENT15
301 ,P_PGP_SEGMENT16 => P_PGP_SEGMENT16
302 ,P_PGP_SEGMENT17 => P_PGP_SEGMENT17
303 ,P_PGP_SEGMENT18 => P_PGP_SEGMENT18
304 ,P_PGP_SEGMENT19 => P_PGP_SEGMENT19
305 ,P_PGP_SEGMENT20 => P_PGP_SEGMENT20
306 ,P_PGP_SEGMENT21 => P_PGP_SEGMENT21
307 ,P_PGP_SEGMENT22 => P_PGP_SEGMENT22
308 ,P_PGP_SEGMENT23 => P_PGP_SEGMENT23
309 ,P_PGP_SEGMENT24 => P_PGP_SEGMENT24
310 ,P_PGP_SEGMENT25 => P_PGP_SEGMENT25
311 ,P_PGP_SEGMENT26 => P_PGP_SEGMENT26
312 ,P_PGP_SEGMENT27 => P_PGP_SEGMENT27
313 ,P_PGP_SEGMENT28 => P_PGP_SEGMENT28
314 ,P_PGP_SEGMENT29 => P_PGP_SEGMENT29
315 ,P_PGP_SEGMENT30 => P_PGP_SEGMENT30
316 ,P_CONTRACT_ID => P_CONTRACT_ID
317 ,P_ESTABLISHMENT_ID => P_ESTABLISHMENT_ID
318 ,P_COLLECTIVE_AGREEMENT_ID => P_COLLECTIVE_AGREEMENT_ID
319 ,P_CAGR_ID_FLEX_NUM => P_CAGR_ID_FLEX_NUM
320 ,P_CAG_SEGMENT1 => P_CAG_SEGMENT1
321 ,P_CAG_SEGMENT2 => P_CAG_SEGMENT2
322 ,P_CAG_SEGMENT3 => P_CAG_SEGMENT3
323 ,P_CAG_SEGMENT4 => P_CAG_SEGMENT4
324 ,P_CAG_SEGMENT5 => P_CAG_SEGMENT5
325 ,P_CAG_SEGMENT6 => P_CAG_SEGMENT6
326 ,P_CAG_SEGMENT7 => P_CAG_SEGMENT7
327 ,P_CAG_SEGMENT8 => P_CAG_SEGMENT8
328 ,P_CAG_SEGMENT9 => P_CAG_SEGMENT9
329 ,P_CAG_SEGMENT10 => P_CAG_SEGMENT10
330 ,P_CAG_SEGMENT11 => P_CAG_SEGMENT11
331 ,P_CAG_SEGMENT12 => P_CAG_SEGMENT12
332 ,P_CAG_SEGMENT13 => P_CAG_SEGMENT13
333 ,P_CAG_SEGMENT14 => P_CAG_SEGMENT14
334 ,P_CAG_SEGMENT15 => P_CAG_SEGMENT15
335 ,P_CAG_SEGMENT16 => P_CAG_SEGMENT16
336 ,P_CAG_SEGMENT17 => P_CAG_SEGMENT17
337 ,P_CAG_SEGMENT18 => P_CAG_SEGMENT18
338 ,P_CAG_SEGMENT19 => P_CAG_SEGMENT19
339 ,P_CAG_SEGMENT20 => P_CAG_SEGMENT20
340 ,P_NOTICE_PERIOD => P_NOTICE_PERIOD
341 ,P_NOTICE_PERIOD_UOM => P_NOTICE_PERIOD_UOM
342 ,P_EMPLOYEE_CATEGORY => P_EMPLOYEE_CATEGORY
343 ,P_WORK_AT_HOME => P_WORK_AT_HOME
344 ,P_JOB_POST_SOURCE_NAME => P_JOB_POST_SOURCE_NAME
345 ,P_CAGR_CONCATENATED_SEGMENTS => P_CAGR_CONCATENATED_SEGMENTS
346 ,P_CAGR_GRADE_DEF_ID => P_CAGR_GRADE_DEF_ID
347 ,P_GROUP_NAME => P_GROUP_NAME
348 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
349 ,P_SOFT_CODING_KEYFLEX_ID => P_SOFT_CODING_KEYFLEX_ID
350 ,P_PEOPLE_GROUP_ID => P_PEOPLE_GROUP_ID
351 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
352 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
353 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
354 ,P_ASSIGNMENT_SEQUENCE => P_ASSIGNMENT_SEQUENCE
355 ,P_COMMENT_ID => P_COMMENT_ID
356 ,P_OTHER_MANAGER_WARNING => P_OTHER_MANAGER_WARNING
357 ,P_HOURLY_SALARIED_WARNING => P_HOURLY_SALARIED_WARNING
358 ,P_PGP_CONCAT_SEGMENTS => P_PGP_CONCAT_SEGMENTS
359 ,P_SCL_CONCAT_SEGMENTS => P_SCL_CONCAT_SEGMENTS
360 ,P_GRADE_LADDER_PGM_ID => P_GRADE_LADDER_PGM_ID
361 ,P_SUPERVISOR_ASSIGNMENT_ID => P_SUPERVISOR_ASSIGNMENT_ID
362 );
363 end if;
364 if hr_api.call_leg_hooks then
365 l_legislation_code := PER_PER_BUS.return_legislation_code(P_PERSON_ID => P_PERSON_ID
366 );
367 if l_legislation_code = 'GB' then
368 PER_ASG_AGGR.SET_PAYE_AGGR
369 (P_PERSON_ID => P_PERSON_ID
370 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
371 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
372 ,P_PAYROLL_ID => P_PAYROLL_ID
373 );
374 PER_ASG_AGGR.UPDATE_ASG_RTI_STARTER_FLAG
375 (P_PERSON_ID => P_PERSON_ID
376 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
377 );
378 PER_ASG_AGGR.UPDATE_RTI_AGG_PERSON
379 (P_PERSON_ID => P_PERSON_ID
380 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
381 );
382 elsif l_legislation_code = 'PL' then
383 PER_PL_ASSIGNMENT.CREATE_PL_SECONDARY_EMP_ASG_A
384 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
385 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
386 ,P_SCL_SEGMENT3 => P_SCL_SEGMENT3
387 );
388 elsif l_legislation_code = 'US' then
389 PER_US_EXTRA_ASSIGNMENT_RULES.INSERT_TAX_RECORD
390 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
391 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
392 );
393 end if;
394 end if;
395 hr_multi_message.end_validation_set;
396 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_SECONDARY_EMP_ASG', 'AP');
397 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK1.CREATE_SECONDARY_EMP_ASG_A', 20);
398 end CREATE_SECONDARY_EMP_ASG_A;
399 procedure CREATE_SECONDARY_EMP_ASG_B
400 (P_EFFECTIVE_DATE in DATE
401 ,P_PERSON_ID in NUMBER
402 ,P_ORGANIZATION_ID in NUMBER
403 ,P_GRADE_ID in NUMBER
404 ,P_POSITION_ID in NUMBER
405 ,P_JOB_ID in NUMBER
406 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
407 ,P_PAYROLL_ID in NUMBER
408 ,P_LOCATION_ID in NUMBER
409 ,P_SUPERVISOR_ID in NUMBER
410 ,P_SPECIAL_CEILING_STEP_ID in NUMBER
411 ,P_PAY_BASIS_ID in NUMBER
412 ,P_ASSIGNMENT_NUMBER in VARCHAR2
413 ,P_CHANGE_REASON in VARCHAR2
414 ,P_COMMENTS in VARCHAR2
415 ,P_DATE_PROBATION_END in DATE
416 ,P_DEFAULT_CODE_COMB_ID in NUMBER
417 ,P_EMPLOYMENT_CATEGORY in VARCHAR2
418 ,P_FREQUENCY in VARCHAR2
419 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
420 ,P_MANAGER_FLAG in VARCHAR2
421 ,P_NORMAL_HOURS in NUMBER
422 ,P_PERF_REVIEW_PERIOD in NUMBER
423 ,P_PERF_REVIEW_PERIOD_FREQUENCY in VARCHAR2
424 ,P_PROBATION_PERIOD in NUMBER
425 ,P_PROBATION_UNIT in VARCHAR2
426 ,P_SAL_REVIEW_PERIOD in NUMBER
427 ,P_SAL_REVIEW_PERIOD_FREQUENCY in VARCHAR2
428 ,P_SET_OF_BOOKS_ID in NUMBER
429 ,P_SOURCE_TYPE in VARCHAR2
430 ,P_TIME_NORMAL_FINISH in VARCHAR2
431 ,P_TIME_NORMAL_START in VARCHAR2
432 ,P_BARGAINING_UNIT_CODE in VARCHAR2
433 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
434 ,P_HOURLY_SALARIED_CODE in VARCHAR2
435 ,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
436 ,P_ASS_ATTRIBUTE1 in VARCHAR2
437 ,P_ASS_ATTRIBUTE2 in VARCHAR2
438 ,P_ASS_ATTRIBUTE3 in VARCHAR2
439 ,P_ASS_ATTRIBUTE4 in VARCHAR2
440 ,P_ASS_ATTRIBUTE5 in VARCHAR2
441 ,P_ASS_ATTRIBUTE6 in VARCHAR2
442 ,P_ASS_ATTRIBUTE7 in VARCHAR2
443 ,P_ASS_ATTRIBUTE8 in VARCHAR2
444 ,P_ASS_ATTRIBUTE9 in VARCHAR2
445 ,P_ASS_ATTRIBUTE10 in VARCHAR2
446 ,P_ASS_ATTRIBUTE11 in VARCHAR2
447 ,P_ASS_ATTRIBUTE12 in VARCHAR2
448 ,P_ASS_ATTRIBUTE13 in VARCHAR2
449 ,P_ASS_ATTRIBUTE14 in VARCHAR2
450 ,P_ASS_ATTRIBUTE15 in VARCHAR2
451 ,P_ASS_ATTRIBUTE16 in VARCHAR2
452 ,P_ASS_ATTRIBUTE17 in VARCHAR2
453 ,P_ASS_ATTRIBUTE18 in VARCHAR2
454 ,P_ASS_ATTRIBUTE19 in VARCHAR2
455 ,P_ASS_ATTRIBUTE20 in VARCHAR2
456 ,P_ASS_ATTRIBUTE21 in VARCHAR2
457 ,P_ASS_ATTRIBUTE22 in VARCHAR2
458 ,P_ASS_ATTRIBUTE23 in VARCHAR2
459 ,P_ASS_ATTRIBUTE24 in VARCHAR2
460 ,P_ASS_ATTRIBUTE25 in VARCHAR2
461 ,P_ASS_ATTRIBUTE26 in VARCHAR2
462 ,P_ASS_ATTRIBUTE27 in VARCHAR2
463 ,P_ASS_ATTRIBUTE28 in VARCHAR2
464 ,P_ASS_ATTRIBUTE29 in VARCHAR2
465 ,P_ASS_ATTRIBUTE30 in VARCHAR2
466 ,P_TITLE in VARCHAR2
467 ,P_SCL_SEGMENT1 in VARCHAR2
468 ,P_SCL_SEGMENT2 in VARCHAR2
469 ,P_SCL_SEGMENT3 in VARCHAR2
470 ,P_SCL_SEGMENT4 in VARCHAR2
471 ,P_SCL_SEGMENT5 in VARCHAR2
472 ,P_SCL_SEGMENT6 in VARCHAR2
473 ,P_SCL_SEGMENT7 in VARCHAR2
474 ,P_SCL_SEGMENT8 in VARCHAR2
475 ,P_SCL_SEGMENT9 in VARCHAR2
476 ,P_SCL_SEGMENT10 in VARCHAR2
477 ,P_SCL_SEGMENT11 in VARCHAR2
478 ,P_SCL_SEGMENT12 in VARCHAR2
479 ,P_SCL_SEGMENT13 in VARCHAR2
480 ,P_SCL_SEGMENT14 in VARCHAR2
481 ,P_SCL_SEGMENT15 in VARCHAR2
482 ,P_SCL_SEGMENT16 in VARCHAR2
483 ,P_SCL_SEGMENT17 in VARCHAR2
484 ,P_SCL_SEGMENT18 in VARCHAR2
485 ,P_SCL_SEGMENT19 in VARCHAR2
486 ,P_SCL_SEGMENT20 in VARCHAR2
487 ,P_SCL_SEGMENT21 in VARCHAR2
488 ,P_SCL_SEGMENT22 in VARCHAR2
489 ,P_SCL_SEGMENT23 in VARCHAR2
490 ,P_SCL_SEGMENT24 in VARCHAR2
491 ,P_SCL_SEGMENT25 in VARCHAR2
492 ,P_SCL_SEGMENT26 in VARCHAR2
493 ,P_SCL_SEGMENT27 in VARCHAR2
494 ,P_SCL_SEGMENT28 in VARCHAR2
495 ,P_SCL_SEGMENT29 in VARCHAR2
496 ,P_SCL_SEGMENT30 in VARCHAR2
497 ,P_SCL_CONCAT_SEGMENTS in VARCHAR2
498 ,P_PGP_SEGMENT1 in VARCHAR2
499 ,P_PGP_SEGMENT2 in VARCHAR2
500 ,P_PGP_SEGMENT3 in VARCHAR2
501 ,P_PGP_SEGMENT4 in VARCHAR2
502 ,P_PGP_SEGMENT5 in VARCHAR2
503 ,P_PGP_SEGMENT6 in VARCHAR2
504 ,P_PGP_SEGMENT7 in VARCHAR2
505 ,P_PGP_SEGMENT8 in VARCHAR2
506 ,P_PGP_SEGMENT9 in VARCHAR2
507 ,P_PGP_SEGMENT10 in VARCHAR2
508 ,P_PGP_SEGMENT11 in VARCHAR2
509 ,P_PGP_SEGMENT12 in VARCHAR2
510 ,P_PGP_SEGMENT13 in VARCHAR2
511 ,P_PGP_SEGMENT14 in VARCHAR2
512 ,P_PGP_SEGMENT15 in VARCHAR2
513 ,P_PGP_SEGMENT16 in VARCHAR2
514 ,P_PGP_SEGMENT17 in VARCHAR2
515 ,P_PGP_SEGMENT18 in VARCHAR2
516 ,P_PGP_SEGMENT19 in VARCHAR2
517 ,P_PGP_SEGMENT20 in VARCHAR2
518 ,P_PGP_SEGMENT21 in VARCHAR2
519 ,P_PGP_SEGMENT22 in VARCHAR2
520 ,P_PGP_SEGMENT23 in VARCHAR2
521 ,P_PGP_SEGMENT24 in VARCHAR2
522 ,P_PGP_SEGMENT25 in VARCHAR2
523 ,P_PGP_SEGMENT26 in VARCHAR2
524 ,P_PGP_SEGMENT27 in VARCHAR2
525 ,P_PGP_SEGMENT28 in VARCHAR2
526 ,P_PGP_SEGMENT29 in VARCHAR2
527 ,P_PGP_SEGMENT30 in VARCHAR2
528 ,P_PGP_CONCAT_SEGMENTS in VARCHAR2
529 ,P_CONTRACT_ID in NUMBER
530 ,P_ESTABLISHMENT_ID in NUMBER
531 ,P_COLLECTIVE_AGREEMENT_ID in NUMBER
532 ,P_CAGR_ID_FLEX_NUM in NUMBER
533 ,P_CAG_SEGMENT1 in VARCHAR2
534 ,P_CAG_SEGMENT2 in VARCHAR2
535 ,P_CAG_SEGMENT3 in VARCHAR2
536 ,P_CAG_SEGMENT4 in VARCHAR2
537 ,P_CAG_SEGMENT5 in VARCHAR2
538 ,P_CAG_SEGMENT6 in VARCHAR2
539 ,P_CAG_SEGMENT7 in VARCHAR2
540 ,P_CAG_SEGMENT8 in VARCHAR2
541 ,P_CAG_SEGMENT9 in VARCHAR2
542 ,P_CAG_SEGMENT10 in VARCHAR2
543 ,P_CAG_SEGMENT11 in VARCHAR2
544 ,P_CAG_SEGMENT12 in VARCHAR2
545 ,P_CAG_SEGMENT13 in VARCHAR2
546 ,P_CAG_SEGMENT14 in VARCHAR2
547 ,P_CAG_SEGMENT15 in VARCHAR2
548 ,P_CAG_SEGMENT16 in VARCHAR2
549 ,P_CAG_SEGMENT17 in VARCHAR2
550 ,P_CAG_SEGMENT18 in VARCHAR2
551 ,P_CAG_SEGMENT19 in VARCHAR2
552 ,P_CAG_SEGMENT20 in VARCHAR2
553 ,P_NOTICE_PERIOD in NUMBER
554 ,P_NOTICE_PERIOD_UOM in VARCHAR2
555 ,P_EMPLOYEE_CATEGORY in VARCHAR2
556 ,P_WORK_AT_HOME in VARCHAR2
557 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
558 ,P_GRADE_LADDER_PGM_ID in NUMBER
559 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
560 )is
561 l_commit_unit_number number;
562 l_legislation_code   varchar2(30);
563 begin
564 hr_utility.set_location('Entering: HR_ASSIGNMENT_BK1.CREATE_SECONDARY_EMP_ASG_B', 10);
565 l_commit_unit_number := hr_api.return_commit_unit;
566 if hr_api.call_leg_hooks then
567 l_legislation_code := PER_PER_BUS.return_legislation_code(P_PERSON_ID => P_PERSON_ID
568 );
569 if l_legislation_code = 'CN' then
570 PER_CN_ASG_LEG_HOOK.CHECK_EMP_ASG_CREATE
571 (P_SCL_SEGMENT1 => P_SCL_SEGMENT1
572 ,P_SCL_SEGMENT20 => P_SCL_SEGMENT20
573 ,P_SCL_SEGMENT21 => P_SCL_SEGMENT21
574 ,P_SCL_SEGMENT22 => P_SCL_SEGMENT22
575 ,P_SCL_SEGMENT23 => P_SCL_SEGMENT23
576 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
577 ,P_PERSON_ID => P_PERSON_ID
578 );
579 elsif l_legislation_code = 'DE' then
580 HR_DE_EXTRA_ASSIGNMENT_CHECKS.ASSIGNMENT_CHECKS
581 (P_LABOUR_UNION_MEMBER_FLAG => P_LABOUR_UNION_MEMBER_FLAG
582 );
583 elsif l_legislation_code = 'FI' then
584 HR_FI_VALIDATE_PKG.CREATE_ASG_VALIDATE
585 (P_SCL_SEGMENT12 => P_SCL_SEGMENT12
586 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
587 ,P_PERSON_ID => P_PERSON_ID
588 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
589 );
590 elsif l_legislation_code = 'IE' then
591 PER_IE_ORG_INFO.CREATE_IE_ASG_INFO
592 (P_PERSON_ID => P_PERSON_ID
593 ,P_PAYROLL_ID => P_PAYROLL_ID
594 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
595 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
596 );
597 elsif l_legislation_code = 'IT' then
598 HR_IT_EXTRA_ASSGT_RULES.EXTRA_ASSIGNMENT_CHECKS
599 (P_EMPLOYMENT_CATEGORY => P_EMPLOYMENT_CATEGORY
600 );
601 HR_IT_EXTRA_PERSON_RULES.EXTRA_CREATE_ASSIGNMENT_CHECKS
602 (P_COLLECTIVE_AGREEMENT_ID => P_COLLECTIVE_AGREEMENT_ID
603 ,P_CAGR_ID_FLEX_NUM => P_CAGR_ID_FLEX_NUM
604 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
605 ,P_CAG_SEGMENT1 => P_CAG_SEGMENT1
606 ,P_CAG_SEGMENT2 => P_CAG_SEGMENT2
607 ,P_CAG_SEGMENT3 => P_CAG_SEGMENT3
608 ,P_SCL_SEGMENT2 => P_SCL_SEGMENT2
609 );
610 elsif l_legislation_code = 'NL' then
611 HR_NL_EXTRA_ASG_RULES.EXTRA_ASSIGNMENT_CHECKS
612 (P_PERSON_ID => P_PERSON_ID
613 ,P_PAYROLL_ID => P_PAYROLL_ID
614 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
615 ,P_FREQUENCY => P_FREQUENCY
616 ,P_NORMAL_HOURS => P_NORMAL_HOURS
617 ,P_SCL_SEGMENT1 => P_SCL_SEGMENT1
618 ,P_SCL_SEGMENT2 => P_SCL_SEGMENT2
619 ,P_SCL_SEGMENT3 => P_SCL_SEGMENT3
620 ,P_SCL_SEGMENT4 => P_SCL_SEGMENT4
621 ,P_SCL_SEGMENT5 => P_SCL_SEGMENT5
622 ,P_SCL_SEGMENT6 => P_SCL_SEGMENT6
623 ,P_SCL_SEGMENT7 => P_SCL_SEGMENT7
624 ,P_SCL_SEGMENT8 => P_SCL_SEGMENT8
625 ,P_SCL_SEGMENT9 => P_SCL_SEGMENT9
626 ,P_SCL_SEGMENT10 => P_SCL_SEGMENT10
627 ,P_SCL_SEGMENT11 => P_SCL_SEGMENT11
628 ,P_SCL_SEGMENT12 => P_SCL_SEGMENT12
629 ,P_SCL_SEGMENT13 => P_SCL_SEGMENT13
630 ,P_SCL_SEGMENT14 => P_SCL_SEGMENT14
631 ,P_SCL_SEGMENT15 => P_SCL_SEGMENT15
632 ,P_SCL_SEGMENT16 => P_SCL_SEGMENT16
633 ,P_SCL_SEGMENT17 => P_SCL_SEGMENT17
634 ,P_SCL_SEGMENT18 => P_SCL_SEGMENT18
635 ,P_SCL_SEGMENT19 => P_SCL_SEGMENT19
636 ,P_SCL_SEGMENT20 => P_SCL_SEGMENT20
637 ,P_SCL_SEGMENT21 => P_SCL_SEGMENT21
638 ,P_SCL_SEGMENT22 => P_SCL_SEGMENT22
639 ,P_SCL_SEGMENT23 => P_SCL_SEGMENT23
640 ,P_SCL_SEGMENT24 => P_SCL_SEGMENT24
641 ,P_SCL_SEGMENT25 => P_SCL_SEGMENT25
642 ,P_SCL_SEGMENT26 => P_SCL_SEGMENT26
643 ,P_SCL_SEGMENT27 => P_SCL_SEGMENT27
644 ,P_SCL_SEGMENT28 => P_SCL_SEGMENT28
645 ,P_SCL_SEGMENT29 => P_SCL_SEGMENT29
646 ,P_SCL_SEGMENT30 => P_SCL_SEGMENT30
647 );
648 elsif l_legislation_code = 'NO' then
649 HR_NO_VALIDATE_PKG.CREATE_ASG_VALIDATE
650 (P_SCL_SEGMENT12 => P_SCL_SEGMENT12
651 ,P_SCL_SEGMENT13 => P_SCL_SEGMENT13
652 ,P_SCL_SEGMENT14 => P_SCL_SEGMENT14
653 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
654 ,P_PERSON_ID => P_PERSON_ID
655 );
656 elsif l_legislation_code = 'PL' then
657 PER_PL_ASSIGNMENT.CREATE_PL_SECONDARY_EMP_ASG
658 (P_PERSON_ID => P_PERSON_ID
659 ,P_PAYROLL_ID => P_PAYROLL_ID
660 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
661 ,P_SCL_SEGMENT3 => P_SCL_SEGMENT3
662 ,P_SCL_SEGMENT4 => P_SCL_SEGMENT4
663 ,P_SCL_SEGMENT5 => P_SCL_SEGMENT5
664 ,P_SCL_SEGMENT6 => P_SCL_SEGMENT6
665 ,P_SCL_SEGMENT7 => P_SCL_SEGMENT7
666 ,P_SCL_SEGMENT8 => P_SCL_SEGMENT8
667 ,P_SCL_SEGMENT9 => P_SCL_SEGMENT9
668 ,P_SCL_SEGMENT11 => P_SCL_SEGMENT11
669 ,P_SCL_SEGMENT12 => P_SCL_SEGMENT12
670 ,P_SCL_SEGMENT13 => P_SCL_SEGMENT13
671 ,P_SCL_SEGMENT14 => P_SCL_SEGMENT14
672 ,P_SCL_SEGMENT15 => P_SCL_SEGMENT15
673 ,P_SCL_SEGMENT16 => P_SCL_SEGMENT16
674 ,P_NOTICE_PERIOD => P_NOTICE_PERIOD
675 ,P_NOTICE_PERIOD_UOM => P_NOTICE_PERIOD_UOM
676 ,P_EMPLOYMENT_CATEGORY => P_EMPLOYMENT_CATEGORY
677 );
678 elsif l_legislation_code = 'RO' then
679 PER_RO_ASSIGNMENT_VAL.CREATE_ASG_VALIDATE
680 (P_CONTRACT_ID => P_CONTRACT_ID
681 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
682 ,P_PERSON_ID => P_PERSON_ID
683 );
684 elsif l_legislation_code = 'RU' then
685 HR_RU_ASG_HOOK.VALIDATE_ASG_CREATE_DETAILS
686 (P_PERSON_ID => P_PERSON_ID
687 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
688 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
689 ,P_SCL_SEGMENT1 => P_SCL_SEGMENT1
690 ,P_SCL_SEGMENT2 => P_SCL_SEGMENT2
691 ,P_SCL_SEGMENT3 => P_SCL_SEGMENT3
692 ,P_SCL_SEGMENT4 => P_SCL_SEGMENT4
693 ,P_SCL_SEGMENT5 => P_SCL_SEGMENT5
694 ,P_SCL_SEGMENT6 => P_SCL_SEGMENT6
695 ,P_SCL_SEGMENT7 => P_SCL_SEGMENT7
696 ,P_SCL_SEGMENT8 => P_SCL_SEGMENT8
697 ,P_SCL_SEGMENT9 => P_SCL_SEGMENT9
698 ,P_SCL_SEGMENT10 => P_SCL_SEGMENT10
699 ,P_SCL_SEGMENT11 => P_SCL_SEGMENT11
700 ,P_SCL_SEGMENT12 => P_SCL_SEGMENT12
701 ,P_SCL_SEGMENT13 => P_SCL_SEGMENT13
702 ,P_SCL_SEGMENT14 => P_SCL_SEGMENT14
703 ,P_SCL_SEGMENT15 => P_SCL_SEGMENT15
704 );
705 elsif l_legislation_code = 'SE' then
706 HR_SE_VALIDATE_PKG.CREATE_ASG_VALIDATE
707 (P_SCL_SEGMENT5 => P_SCL_SEGMENT5
708 ,P_SCL_SEGMENT6 => P_SCL_SEGMENT6
709 );
710 end if;
711 end if;
712 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_SECONDARY_EMP_ASG', 'BP');
713 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK1.CREATE_SECONDARY_EMP_ASG_B', 20);
714 end CREATE_SECONDARY_EMP_ASG_B;
715 end HR_ASSIGNMENT_BK1;