[Home] [Help]
PACKAGE BODY: APPS.HR_PL_ASSIGNMENT_API
Source
1 PACKAGE body hr_pl_assignment_api AS
2 /* $Header: peasgpli.pkb 120.1 2005/09/27 04:04:58 mseshadr noship $ */
3
4
5 g_package VARCHAR2(33) := 'hr_pl_assignment_api.';
6
7 -- ----------------------------------------------------------------------------
8 -- |-------------------< create_pl_secondary_emp_asg OLD >---------------------|
9 -- ----------------------------------------------------------------------------
10
11 Procedure create_pl_secondary_emp_asg
12 (p_validate in boolean default false
13 ,p_effective_date in date
14 ,p_person_id in number
15 ,p_organization_id in number
16 ,p_grade_id in number default null
17 ,p_position_id in number default null
18 ,p_job_id in number default null
19 ,p_assignment_status_type_id in number default null
20 ,p_payroll_id in number default null
21 ,p_location_id in number default null
22 ,p_supervisor_id in number default null
23 ,p_special_ceiling_step_id in number default null
24 ,p_pay_basis_id in number default null
25 ,p_assignment_number in out nocopy varchar2
26 ,p_change_reason in varchar2 default null
27 ,p_comments in varchar2 default null
28 ,p_date_probation_end in date default null
29 ,p_default_code_comb_id in number default null
30 ,p_employment_category in varchar2 default null
31 ,p_frequency in varchar2 default null
32 ,p_internal_address_line in varchar2 default null
33 ,p_manager_flag in varchar2 default null
34 ,p_normal_hours in number default null
35 ,p_perf_review_period in number default null
36 ,p_perf_review_period_frequency in varchar2 default null
37 ,p_probation_period in number default null
38 ,p_probation_unit in varchar2 default null
39 ,p_sal_review_period in number default null
40 ,p_sal_review_period_frequency in varchar2 default null
41 ,p_set_of_books_id in number default null
42 ,p_source_type in varchar2 default null
43 ,p_time_normal_finish in varchar2 default null
44 ,p_time_normal_start in varchar2 default null
45 ,p_bargaining_unit_code in varchar2 default null
46 ,p_labour_union_member_flag in varchar2 default 'N'
47 ,p_hourly_salaried_code in varchar2 default null
48 ,p_ass_attribute_category in varchar2 default null
49 ,p_ass_attribute1 in varchar2 default null
50 ,p_ass_attribute2 in varchar2 default null
51 ,p_ass_attribute3 in varchar2 default null
52 ,p_ass_attribute4 in varchar2 default null
53 ,p_ass_attribute5 in varchar2 default null
54 ,p_ass_attribute6 in varchar2 default null
55 ,p_ass_attribute7 in varchar2 default null
56 ,p_ass_attribute8 in varchar2 default null
57 ,p_ass_attribute9 in varchar2 default null
58 ,p_ass_attribute10 in varchar2 default null
59 ,p_ass_attribute11 in varchar2 default null
60 ,p_ass_attribute12 in varchar2 default null
61 ,p_ass_attribute13 in varchar2 default null
62 ,p_ass_attribute14 in varchar2 default null
63 ,p_ass_attribute15 in varchar2 default null
64 ,p_ass_attribute16 in varchar2 default null
65 ,p_ass_attribute17 in varchar2 default null
66 ,p_ass_attribute18 in varchar2 default null
67 ,p_ass_attribute19 in varchar2 default null
68 ,p_ass_attribute20 in varchar2 default null
69 ,p_ass_attribute21 in varchar2 default null
70 ,p_ass_attribute22 in varchar2 default null
71 ,p_ass_attribute23 in varchar2 default null
72 ,p_ass_attribute24 in varchar2 default null
73 ,p_ass_attribute25 in varchar2 default null
74 ,p_ass_attribute26 in varchar2 default null
75 ,p_ass_attribute27 in varchar2 default null
76 ,p_ass_attribute28 in varchar2 default null
77 ,p_ass_attribute29 in varchar2 default null
78 ,p_ass_attribute30 in varchar2 default null
79 ,p_title in varchar2 default null
80 ,p_scl_segment1 in varchar2 default null
81 ,p_legal_employer in varchar2 default null
82 ,p_scl_segment3 in varchar2 default null
83 ,p_scl_segment4 in varchar2 default null
84 ,p_scl_segment5 in varchar2 default null
85 ,p_scl_segment6 in varchar2 default null
86 ,p_scl_segment7 in varchar2 default null
87 ,p_scl_segment8 in varchar2 default null
88 ,p_scl_segment9 in varchar2 default null
89 ,p_scl_segment10 in varchar2 default null
90 ,p_scl_segment11 in varchar2 default null
91 ,p_scl_segment12 in varchar2 default null
92 ,p_scl_segment13 in varchar2 default null
93 ,p_scl_segment14 in varchar2 default null
94 ,p_scl_segment15 in varchar2 default null
95 ,p_scl_segment16 in varchar2 default null
96 ,p_scl_segment17 in varchar2 default null
97 ,p_scl_segment18 in varchar2 default null
98 ,p_scl_segment19 in varchar2 default null
99 ,p_scl_segment20 in varchar2 default null
100 ,p_scl_segment21 in varchar2 default null
101 ,p_scl_segment22 in varchar2 default null
102 ,p_scl_segment23 in varchar2 default null
103 ,p_scl_segment24 in varchar2 default null
104 ,p_scl_segment25 in varchar2 default null
105 ,p_scl_segment26 in varchar2 default null
106 ,p_scl_segment27 in varchar2 default null
107 ,p_scl_segment28 in varchar2 default null
108 ,p_scl_segment29 in varchar2 default null
109 ,p_scl_segment30 in varchar2 default null
110 ,p_scl_concat_segments in varchar2 default null
111 ,p_pgp_segment1 in varchar2 default null
112 ,p_pgp_segment2 in varchar2 default null
113 ,p_pgp_segment3 in varchar2 default null
114 ,p_pgp_segment4 in varchar2 default null
115 ,p_pgp_segment5 in varchar2 default null
116 ,p_pgp_segment6 in varchar2 default null
117 ,p_pgp_segment7 in varchar2 default null
118 ,p_pgp_segment8 in varchar2 default null
119 ,p_pgp_segment9 in varchar2 default null
120 ,p_pgp_segment10 in varchar2 default null
121 ,p_pgp_segment11 in varchar2 default null
122 ,p_pgp_segment12 in varchar2 default null
123 ,p_pgp_segment13 in varchar2 default null
124 ,p_pgp_segment14 in varchar2 default null
125 ,p_pgp_segment15 in varchar2 default null
126 ,p_pgp_segment16 in varchar2 default null
127 ,p_pgp_segment17 in varchar2 default null
128 ,p_pgp_segment18 in varchar2 default null
129 ,p_pgp_segment19 in varchar2 default null
130 ,p_pgp_segment20 in varchar2 default null
131 ,p_pgp_segment21 in varchar2 default null
132 ,p_pgp_segment22 in varchar2 default null
133 ,p_pgp_segment23 in varchar2 default null
134 ,p_pgp_segment24 in varchar2 default null
135 ,p_pgp_segment25 in varchar2 default null
136 ,p_pgp_segment26 in varchar2 default null
137 ,p_pgp_segment27 in varchar2 default null
138 ,p_pgp_segment28 in varchar2 default null
139 ,p_pgp_segment29 in varchar2 default null
140 ,p_pgp_segment30 in varchar2 default null
141 ,p_pgp_concat_segments in varchar2 default null
142 ,p_contract_id in number default null
143 ,p_establishment_id in number default null
144 ,p_collective_agreement_id in number default null
145 ,p_cagr_id_flex_num in number default null
146 ,p_cag_segment1 in varchar2 default null
147 ,p_cag_segment2 in varchar2 default null
148 ,p_cag_segment3 in varchar2 default null
149 ,p_cag_segment4 in varchar2 default null
150 ,p_cag_segment5 in varchar2 default null
151 ,p_cag_segment6 in varchar2 default null
152 ,p_cag_segment7 in varchar2 default null
153 ,p_cag_segment8 in varchar2 default null
154 ,p_cag_segment9 in varchar2 default null
155 ,p_cag_segment10 in varchar2 default null
156 ,p_cag_segment11 in varchar2 default null
157 ,p_cag_segment12 in varchar2 default null
158 ,p_cag_segment13 in varchar2 default null
159 ,p_cag_segment14 in varchar2 default null
160 ,p_cag_segment15 in varchar2 default null
161 ,p_cag_segment16 in varchar2 default null
162 ,p_cag_segment17 in varchar2 default null
163 ,p_cag_segment18 in varchar2 default null
164 ,p_cag_segment19 in varchar2 default null
165 ,p_cag_segment20 in varchar2 default null
166 ,p_notice_period in number default null
167 ,p_notice_period_uom in varchar2 default null
168 ,p_employee_category in varchar2 default null
169 ,p_work_at_home in varchar2 default null
170 ,p_job_post_source_name in varchar2 default null
171 ,p_grade_ladder_pgm_id in number default null
172 ,p_supervisor_assignment_id in number default null
173 ,p_group_name out nocopy varchar2
174 ,p_concatenated_segments out nocopy varchar2
175 ,p_cagr_grade_def_id in out nocopy number
176 ,p_cagr_concatenated_segments out nocopy varchar2
177 ,p_assignment_id out nocopy number
178 ,p_soft_coding_keyflex_id in out nocopy number
179 ,p_people_group_id in out nocopy number
180 ,p_object_version_number out nocopy number
181 ,p_effective_start_date out nocopy date
182 ,p_effective_end_date out nocopy date
183 ,p_assignment_sequence out nocopy number
184 ,p_comment_id out nocopy number
185 ,p_other_manager_warning out nocopy boolean
186 ,p_hourly_salaried_warning out nocopy boolean
187 ,p_gsp_post_process_warning out nocopy varchar2
188 ) is
189
190 -- Declare cursors AND local variables
191 --
192 -- Declare variables
193 --
194
195
196 l_proc VARCHAR2(72) := g_package||'create_pl_secondary_emp_asg OLD';
197
198 --
199 BEGIN
200 hr_utility.set_location('Entering:'|| l_proc, 10);
201 --
202 -- Initialise local variable
203 --
204 /*Replaced code with call to new overloaded procedure
205
206 l_effective_date := trunc(p_effective_date);
207 --
208 -- Validation IN addition to Table Handlers
209 --
210 -- Ensure that the employee IS within a FI business group
211 --
212 OPEN csr_legislation;
213 FETCH csr_legislation
214 INTO l_legislation_code;
215 IF csr_legislation%notfound THEN
216 CLOSE csr_legislation;
217 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
218 hr_utility.set_message_token('LEG_CODE', 'PL');
219 hr_utility.raise_error;
220 END IF;
221 CLOSE csr_legislation;
222 --
223 --
224 -- Call create_secondary_emp_asg
225 --
226 hr_assignment_api.create_secondary_emp_asg
227 */
228 hr_pl_assignment_api.create_pl_secondary_emp_asg
229 (p_validate =>p_validate
230 ,p_effective_date =>p_effective_date
231 ,p_person_id =>p_person_id
232 ,p_organization_id =>p_organization_id
233 ,p_grade_id =>p_grade_id
234 ,p_position_id =>p_position_id
235 ,p_job_id =>p_job_id
236 ,p_assignment_status_type_id =>p_assignment_status_type_id
237 ,p_payroll_id =>p_payroll_id
238 ,p_location_id =>p_location_id
239 ,p_supervisor_id =>p_supervisor_id
240 ,p_special_ceiling_step_id =>p_special_ceiling_step_id
241 ,p_pay_basis_id =>p_pay_basis_id
242 ,p_assignment_number =>p_assignment_number
243 ,p_change_reason =>p_change_reason
244 ,p_comments =>p_comments
245 ,p_date_probation_end =>p_date_probation_end
246 ,p_default_code_comb_id =>p_default_code_comb_id
247 ,p_employment_category =>p_employment_category
248 ,p_frequency =>p_frequency
249 ,p_internal_address_line =>p_internal_address_line
250 ,p_manager_flag =>p_manager_flag
251 ,p_normal_hours =>p_normal_hours
252 ,p_perf_review_period =>p_perf_review_period
253 ,p_perf_review_period_frequency =>p_perf_review_period_frequency
254 ,p_probation_period =>p_probation_period
255 ,p_probation_unit =>p_probation_unit
256 ,p_sal_review_period =>p_sal_review_period
257 ,p_sal_review_period_frequency =>p_sal_review_period_frequency
258 ,p_set_of_books_id =>p_set_of_books_id
259 ,p_source_type =>p_source_type
260 ,p_time_normal_finish =>p_time_normal_finish
261 ,p_time_normal_start =>p_time_normal_start
262 ,p_bargaining_unit_code =>p_bargaining_unit_code
263 ,p_labour_union_member_flag =>p_labour_union_member_flag
264 ,p_hourly_salaried_code =>p_hourly_salaried_code
265 ,p_ass_attribute_category =>p_ass_attribute_category
266 ,p_ass_attribute1 =>p_ass_attribute1
267 ,p_ass_attribute2 =>p_ass_attribute2
268 ,p_ass_attribute3 =>p_ass_attribute3
269 ,p_ass_attribute4 =>p_ass_attribute4
270 ,p_ass_attribute5 =>p_ass_attribute5
271 ,p_ass_attribute6 =>p_ass_attribute6
272 ,p_ass_attribute7 =>p_ass_attribute7
273 ,p_ass_attribute8 =>p_ass_attribute8
274 ,p_ass_attribute9 =>p_ass_attribute9
275 ,p_ass_attribute10 =>p_ass_attribute10
276 ,p_ass_attribute11 =>p_ass_attribute11
277 ,p_ass_attribute12 =>p_ass_attribute12
278 ,p_ass_attribute13 =>p_ass_attribute13
279 ,p_ass_attribute14 =>p_ass_attribute14
280 ,p_ass_attribute15 =>p_ass_attribute15
281 ,p_ass_attribute16 =>p_ass_attribute16
282 ,p_ass_attribute17 =>p_ass_attribute17
283 ,p_ass_attribute18 =>p_ass_attribute18
284 ,p_ass_attribute19 =>p_ass_attribute19
285 ,p_ass_attribute20 =>p_ass_attribute20
286 ,p_ass_attribute21 =>p_ass_attribute21
287 ,p_ass_attribute22 =>p_ass_attribute22
288 ,p_ass_attribute23 =>p_ass_attribute23
289 ,p_ass_attribute24 =>p_ass_attribute24
290 ,p_ass_attribute25 =>p_ass_attribute25
291 ,p_ass_attribute26 =>p_ass_attribute26
292 ,p_ass_attribute27 =>p_ass_attribute27
293 ,p_ass_attribute28 =>p_ass_attribute28
294 ,p_ass_attribute29 =>p_ass_attribute29
295 ,p_ass_attribute30 =>p_ass_attribute30
296 ,p_title =>p_title
297 ,p_contract_category =>p_scl_segment3
298 ,p_contract_type =>p_scl_segment4
299 ,p_contract_number =>p_scl_segment5
300 ,p_change_of_contract_reason =>p_scl_segment6
301 ,p_job =>p_scl_segment7
302 ,p_work_in_special_condition =>p_scl_segment8
303 ,p_end_of_contract_addl_details =>p_scl_segment9
304 ,p_contract_start_date =>p_scl_segment11
305 ,p_planned_valid_to_date =>p_scl_segment12
306 ,p_contract_type_change_date =>p_scl_segment13
307 ,p_date_contract_signed =>p_scl_segment14
308 ,p_notice_period_date =>p_scl_segment15
309 ,p_notice_period_end_date =>p_scl_segment16
310 ,p_scl_concat_segments =>p_scl_concat_segments
311 ,p_pgp_segment1 =>p_pgp_segment1
312 ,p_pgp_segment2 =>p_pgp_segment2
313 ,p_pgp_segment3 =>p_pgp_segment3
314 ,p_pgp_segment4 =>p_pgp_segment4
315 ,p_pgp_segment5 =>p_pgp_segment5
316 ,p_pgp_segment6 =>p_pgp_segment6
317 ,p_pgp_segment7 =>p_pgp_segment7
318 ,p_pgp_segment8 =>p_pgp_segment8
319 ,p_pgp_segment9 =>p_pgp_segment9
320 ,p_pgp_segment10 =>p_pgp_segment10
321 ,p_pgp_segment11 =>p_pgp_segment11
322 ,p_pgp_segment12 =>p_pgp_segment12
323 ,p_pgp_segment13 =>p_pgp_segment13
324 ,p_pgp_segment14 =>p_pgp_segment14
325 ,p_pgp_segment15 =>p_pgp_segment15
326 ,p_pgp_segment16 =>p_pgp_segment16
327 ,p_pgp_segment17 =>p_pgp_segment17
328 ,p_pgp_segment18 =>p_pgp_segment18
329 ,p_pgp_segment19 =>p_pgp_segment19
330 ,p_pgp_segment20 =>p_pgp_segment20
331 ,p_pgp_segment21 =>p_pgp_segment21
332 ,p_pgp_segment22 =>p_pgp_segment22
333 ,p_pgp_segment23 =>p_pgp_segment23
334 ,p_pgp_segment24 =>p_pgp_segment24
335 ,p_pgp_segment25 =>p_pgp_segment25
336 ,p_pgp_segment26 =>p_pgp_segment26
337 ,p_pgp_segment27 =>p_pgp_segment27
338 ,p_pgp_segment28 =>p_pgp_segment28
339 ,p_pgp_segment29 =>p_pgp_segment29
340 ,p_pgp_segment30 =>p_pgp_segment30
341 ,p_pgp_concat_segments =>p_pgp_concat_segments
342 ,p_contract_id =>p_contract_id
343 ,p_establishment_id =>p_establishment_id
344 ,p_collective_agreement_id =>p_collective_agreement_id
345 ,p_cagr_id_flex_num =>p_cagr_id_flex_num
346 ,p_cag_segment1 =>p_cag_segment1
347 ,p_cag_segment2 =>p_cag_segment2
348 ,p_cag_segment3 =>p_cag_segment3
349 ,p_cag_segment4 =>p_cag_segment4
350 ,p_cag_segment5 =>p_cag_segment5
351 ,p_cag_segment6 =>p_cag_segment6
352 ,p_cag_segment7 =>p_cag_segment7
353 ,p_cag_segment8 =>p_cag_segment8
354 ,p_cag_segment9 =>p_cag_segment9
355 ,p_cag_segment10 =>p_cag_segment10
356 ,p_cag_segment11 =>p_cag_segment11
357 ,p_cag_segment12 =>p_cag_segment12
358 ,p_cag_segment13 =>p_cag_segment13
359 ,p_cag_segment14 =>p_cag_segment14
360 ,p_cag_segment15 =>p_cag_segment15
361 ,p_cag_segment16 =>p_cag_segment16
362 ,p_cag_segment17 =>p_cag_segment17
363 ,p_cag_segment18 =>p_cag_segment18
364 ,p_cag_segment19 =>p_cag_segment19
365 ,p_cag_segment20 =>p_cag_segment20
366 ,p_notice_period =>p_notice_period
367 ,p_notice_period_uom =>p_notice_period_uom
368 ,p_employee_category =>p_employee_category
369 ,p_work_at_home =>p_work_at_home
370 ,p_job_post_source_name =>p_job_post_source_name
371 ,p_grade_ladder_pgm_id =>p_grade_ladder_pgm_id
372 ,p_supervisor_assignment_id =>p_supervisor_assignment_id
373 ,p_group_name =>p_group_name
374 ,p_concatenated_segments =>p_concatenated_segments
375 ,p_cagr_grade_def_id =>p_cagr_grade_def_id
376 ,p_cagr_concatenated_segments =>p_cagr_concatenated_segments
377 ,p_assignment_id =>p_assignment_id
378 ,p_soft_coding_keyflex_id =>p_soft_coding_keyflex_id
379 ,p_people_group_id =>p_people_group_id
380 ,p_object_version_number =>p_object_version_number
381 ,p_effective_start_date =>p_effective_start_date
382 ,p_effective_end_date =>p_effective_end_date
383 ,p_assignment_sequence =>p_assignment_sequence
384 ,p_comment_id =>p_comment_id
385 ,p_other_manager_warning =>p_other_manager_warning
386 ,p_hourly_salaried_warning =>p_hourly_salaried_warning
387 ,p_gsp_post_process_warning =>p_gsp_post_process_warning
388 );
389
390 hr_utility.set_location(' Leaving:'||l_proc, 30);
391 --
392 END create_pl_secondary_emp_asg;
396 Procedure create_pl_secondary_emp_asg
393 -- ----------------------------------------------------------------------------
394 -- |-------------------< create_pl_secondary_emp_asg NEW >---------------------|
395 -- ----------------------------------------------------------------------------
397 (p_validate in boolean default false
398 ,p_effective_date in date
399 ,p_person_id in number
400 ,p_organization_id in number
401 ,p_grade_id in number default null
402 ,p_position_id in number default null
403 ,p_job_id in number default null
404 ,p_assignment_status_type_id in number default null
405 ,p_payroll_id in number default null
406 ,p_location_id in number default null
407 ,p_supervisor_id in number default null
408 ,p_special_ceiling_step_id in number default null
409 ,p_pay_basis_id in number default null
410 ,p_assignment_number in out nocopy varchar2
411 ,p_change_reason in varchar2 default null
412 ,p_comments in varchar2 default null
413 ,p_date_probation_end in date default null
414 ,p_default_code_comb_id in number default null
415 ,p_employment_category in varchar2 default null
416 ,p_frequency in varchar2 default null
417 ,p_internal_address_line in varchar2 default null
418 ,p_manager_flag in varchar2 default null
419 ,p_normal_hours in number default null
420 ,p_perf_review_period in number default null
421 ,p_perf_review_period_frequency in varchar2 default null
422 ,p_probation_period in number default null
423 ,p_probation_unit in varchar2 default null
424 ,p_sal_review_period in number default null
425 ,p_sal_review_period_frequency in varchar2 default null
426 ,p_set_of_books_id in number default null
427 ,p_source_type in varchar2 default null
428 ,p_time_normal_finish in varchar2 default null
429 ,p_time_normal_start in varchar2 default null
430 ,p_bargaining_unit_code in varchar2 default null
431 ,p_labour_union_member_flag in varchar2 default 'N'
432 ,p_hourly_salaried_code in varchar2 default null
433 ,p_ass_attribute_category in varchar2 default null
434 ,p_ass_attribute1 in varchar2 default null
435 ,p_ass_attribute2 in varchar2 default null
436 ,p_ass_attribute3 in varchar2 default null
437 ,p_ass_attribute4 in varchar2 default null
438 ,p_ass_attribute5 in varchar2 default null
439 ,p_ass_attribute6 in varchar2 default null
440 ,p_ass_attribute7 in varchar2 default null
441 ,p_ass_attribute8 in varchar2 default null
442 ,p_ass_attribute9 in varchar2 default null
443 ,p_ass_attribute10 in varchar2 default null
444 ,p_ass_attribute11 in varchar2 default null
445 ,p_ass_attribute12 in varchar2 default null
446 ,p_ass_attribute13 in varchar2 default null
447 ,p_ass_attribute14 in varchar2 default null
448 ,p_ass_attribute15 in varchar2 default null
449 ,p_ass_attribute16 in varchar2 default null
450 ,p_ass_attribute17 in varchar2 default null
451 ,p_ass_attribute18 in varchar2 default null
452 ,p_ass_attribute19 in varchar2 default null
453 ,p_ass_attribute20 in varchar2 default null
454 ,p_ass_attribute21 in varchar2 default null
455 ,p_ass_attribute22 in varchar2 default null
456 ,p_ass_attribute23 in varchar2 default null
457 ,p_ass_attribute24 in varchar2 default null
458 ,p_ass_attribute25 in varchar2 default null
459 ,p_ass_attribute26 in varchar2 default null
460 ,p_ass_attribute27 in varchar2 default null
461 ,p_ass_attribute28 in varchar2 default null
462 ,p_ass_attribute29 in varchar2 default null
463 ,p_ass_attribute30 in varchar2 default null
464 ,p_title in varchar2 default null
465 ,p_contract_category in varchar2
466 ,p_contract_type in varchar2
467 ,p_contract_number in varchar2
468 ,p_change_of_contract_reason in varchar2 default null
469 ,p_job in varchar2 default null
470 ,p_work_in_special_condition in varchar2 default null
471 ,p_end_of_contract_addl_details in varchar2 default null
472 ,p_contract_start_date in varchar2
473 ,p_planned_valid_to_date in varchar2 default null
474 ,p_contract_type_change_date in varchar2 default null
475 ,p_date_contract_signed in varchar2
476 ,p_notice_period_date in varchar2 default null
477 ,p_notice_period_end_date in varchar2 default null
478 ,p_scl_concat_segments in varchar2 default null
479 ,p_pgp_segment1 in varchar2 default null
480 ,p_pgp_segment2 in varchar2 default null
481 ,p_pgp_segment3 in varchar2 default null
482 ,p_pgp_segment4 in varchar2 default null
483 ,p_pgp_segment5 in varchar2 default null
484 ,p_pgp_segment6 in varchar2 default null
485 ,p_pgp_segment7 in varchar2 default null
486 ,p_pgp_segment8 in varchar2 default null
490 ,p_pgp_segment12 in varchar2 default null
487 ,p_pgp_segment9 in varchar2 default null
488 ,p_pgp_segment10 in varchar2 default null
489 ,p_pgp_segment11 in varchar2 default null
491 ,p_pgp_segment13 in varchar2 default null
492 ,p_pgp_segment14 in varchar2 default null
493 ,p_pgp_segment15 in varchar2 default null
494 ,p_pgp_segment16 in varchar2 default null
495 ,p_pgp_segment17 in varchar2 default null
496 ,p_pgp_segment18 in varchar2 default null
497 ,p_pgp_segment19 in varchar2 default null
498 ,p_pgp_segment20 in varchar2 default null
499 ,p_pgp_segment21 in varchar2 default null
500 ,p_pgp_segment22 in varchar2 default null
501 ,p_pgp_segment23 in varchar2 default null
502 ,p_pgp_segment24 in varchar2 default null
503 ,p_pgp_segment25 in varchar2 default null
504 ,p_pgp_segment26 in varchar2 default null
505 ,p_pgp_segment27 in varchar2 default null
506 ,p_pgp_segment28 in varchar2 default null
507 ,p_pgp_segment29 in varchar2 default null
508 ,p_pgp_segment30 in varchar2 default null
509 ,p_pgp_concat_segments in varchar2 default null
510 ,p_contract_id in number default null
511 ,p_establishment_id in number default null
512 ,p_collective_agreement_id in number default null
513 ,p_cagr_id_flex_num in number default null
514 ,p_cag_segment1 in varchar2 default null
515 ,p_cag_segment2 in varchar2 default null
516 ,p_cag_segment3 in varchar2 default null
517 ,p_cag_segment4 in varchar2 default null
518 ,p_cag_segment5 in varchar2 default null
519 ,p_cag_segment6 in varchar2 default null
520 ,p_cag_segment7 in varchar2 default null
521 ,p_cag_segment8 in varchar2 default null
522 ,p_cag_segment9 in varchar2 default null
523 ,p_cag_segment10 in varchar2 default null
524 ,p_cag_segment11 in varchar2 default null
525 ,p_cag_segment12 in varchar2 default null
526 ,p_cag_segment13 in varchar2 default null
527 ,p_cag_segment14 in varchar2 default null
528 ,p_cag_segment15 in varchar2 default null
529 ,p_cag_segment16 in varchar2 default null
530 ,p_cag_segment17 in varchar2 default null
531 ,p_cag_segment18 in varchar2 default null
532 ,p_cag_segment19 in varchar2 default null
533 ,p_cag_segment20 in varchar2 default null
534 ,p_notice_period in number default null
535 ,p_notice_period_uom in varchar2 default null
536 ,p_employee_category in varchar2 default null
537 ,p_work_at_home in varchar2 default null
538 ,p_job_post_source_name in varchar2 default null
539 ,p_grade_ladder_pgm_id in number default null
540 ,p_supervisor_assignment_id in number default null
541 ,p_group_name out nocopy varchar2
542 ,p_concatenated_segments out nocopy varchar2
543 ,p_cagr_grade_def_id in out nocopy number
544 ,p_cagr_concatenated_segments out nocopy varchar2
545 ,p_assignment_id out nocopy number
546 ,p_soft_coding_keyflex_id in out nocopy number
547 ,p_people_group_id in out nocopy number
548 ,p_object_version_number out nocopy number
549 ,p_effective_start_date out nocopy date
550 ,p_effective_end_date out nocopy date
551 ,p_assignment_sequence out nocopy number
552 ,p_comment_id out nocopy number
553 ,p_other_manager_warning out nocopy boolean
554 ,p_hourly_salaried_warning out nocopy boolean
555 ,p_gsp_post_process_warning out nocopy varchar2
556 )is
557
558 -- Declare cursors AND local variables
559 --
560 -- Declare variables
561 --
562
563 --l_assignment_number per_assignments_f.assignment_number%TYPE;
564 l_effective_date DATE;
565 l_business_group_id per_business_groups.business_group_id%TYPE;
566 l_legislation_code per_business_groups.legislation_code%TYPE;
567 l_proc VARCHAR2(72) := g_package||'create_pl_secondary_emp_asg OLD';
568 v_field VARCHAR2(20);
569 --
570 -- Declare cursors
571 --
572 CURSOR csr_legislation IS
573 SELECT NULL
574 FROM per_assignments_f paf,
575 per_business_groups pbg
576 WHERE paf.person_id = p_person_id
577 AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
578 AND pbg.business_group_id = paf.business_group_id
579 AND pbg.legislation_code = 'PL';
580 --
581 --
582 BEGIN
583 hr_utility.set_location('Entering:'|| l_proc, 10);
584 --
585 -- Initialise local variable
586 --
587 l_effective_date := trunc(p_effective_date);
588 --
589 -- Validation IN addition to Table Handlers
590 --
591 -- Ensure that the employee IS within a FI business group
592 --
593 OPEN csr_legislation;
594 FETCH csr_legislation
595 INTO l_legislation_code;
596 IF csr_legislation%notfound THEN
597 CLOSE csr_legislation;
598 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
599 hr_utility.set_message_token('LEG_CODE', 'PL');
600 hr_utility.raise_error;
601 END IF;
602 CLOSE csr_legislation;
603 --
604 --
605 -- Call create_secondary_emp_asg
606 --
607 hr_assignment_api.create_secondary_emp_asg
608 ( p_validate => p_validate
609 ,p_effective_date => p_effective_date
610 ,p_person_id => p_person_id
611 ,p_organization_id => p_organization_id
612 ,p_grade_id => p_grade_id
613 ,p_position_id => p_position_id
614 ,p_job_id => p_job_id
615 ,p_assignment_status_type_id => p_assignment_status_type_id
616 ,p_payroll_id => p_payroll_id
617 ,p_location_id => p_location_id
618 ,p_supervisor_id => p_supervisor_id
619 ,p_special_ceiling_step_id => p_special_ceiling_step_id
620 ,p_pay_basis_id => p_pay_basis_id
621 ,p_assignment_number => p_assignment_number
622 ,p_change_reason => p_change_reason
623 ,p_comments => p_comments
624 ,p_date_probation_end => p_date_probation_end
625 ,p_default_code_comb_id => p_default_code_comb_id
626 ,p_employment_category => p_employment_category
627 ,p_frequency => p_frequency
628 ,p_internal_address_line => p_internal_address_line
629 ,p_manager_flag => p_manager_flag
630 ,p_normal_hours => p_normal_hours
631 ,p_perf_review_period => p_perf_review_period
632 ,p_perf_review_period_frequency=> p_perf_review_period_frequency
633 ,p_probation_period => p_probation_period
634 ,p_probation_unit => p_probation_unit
635 ,p_sal_review_period => p_sal_review_period
636 ,p_sal_review_period_frequency=> p_sal_review_period_frequency
637 ,p_set_of_books_id => p_set_of_books_id
638 ,p_source_type => p_source_type
639 ,p_time_normal_finish => p_time_normal_finish
640 ,p_time_normal_start => p_time_normal_start
641 ,p_bargaining_unit_code => p_bargaining_unit_code
642 ,p_labour_union_member_flag=> p_labour_union_member_flag
643 ,p_hourly_salaried_code => p_hourly_salaried_code
644 ,p_ass_attribute_category => p_ass_attribute_category
645 ,p_ass_attribute1 => p_ass_attribute1
646 ,p_ass_attribute2 => p_ass_attribute2
647 ,p_ass_attribute3 => p_ass_attribute3
648 ,p_ass_attribute4 => p_ass_attribute4
649 ,p_ass_attribute5 => p_ass_attribute5
650 ,p_ass_attribute6 => p_ass_attribute6
651 ,p_ass_attribute7 => p_ass_attribute7
652 ,p_ass_attribute8 => p_ass_attribute8
656 ,p_ass_attribute12 => p_ass_attribute12
653 ,p_ass_attribute9 => p_ass_attribute9
654 ,p_ass_attribute10 => p_ass_attribute10
655 ,p_ass_attribute11 => p_ass_attribute11
657 ,p_ass_attribute13 => p_ass_attribute13
658 ,p_ass_attribute14 => p_ass_attribute14
659 ,p_ass_attribute15 => p_ass_attribute15
660 ,p_ass_attribute16 => p_ass_attribute16
661 ,p_ass_attribute17 => p_ass_attribute17
662 ,p_ass_attribute18 => p_ass_attribute18
663 ,p_ass_attribute19 => p_ass_attribute19
664 ,p_ass_attribute20 => p_ass_attribute20
665 ,p_ass_attribute21 => p_ass_attribute21
666 ,p_ass_attribute22 => p_ass_attribute22
667 ,p_ass_attribute23 => p_ass_attribute23
668 ,p_ass_attribute24 => p_ass_attribute24
669 ,p_ass_attribute25 => p_ass_attribute25
670 ,p_ass_attribute26 => p_ass_attribute26
671 ,p_ass_attribute27 => p_ass_attribute27
672 ,p_ass_attribute28 => p_ass_attribute28
673 ,p_ass_attribute29 => p_ass_attribute29
674 ,p_ass_attribute30 => p_ass_attribute30
675 ,p_title => p_title
676 ,p_scl_segment3 => p_contract_category
677 ,p_scl_segment4 => p_contract_type
678 ,p_scl_segment5 => p_contract_number
679 ,p_scl_segment6 => p_change_of_contract_reason
680 ,p_scl_segment7 => p_job
681 ,p_scl_segment8 => p_work_in_special_condition
682 ,p_scl_segment9 => p_end_of_contract_addl_details
683 ,p_scl_segment11 => p_contract_start_date
684 ,p_scl_segment12 => p_planned_valid_to_date
685 ,p_scl_segment13 => p_contract_type_change_date
686 ,p_scl_segment14 => p_date_contract_signed
687 ,p_scl_segment15 => p_notice_period_date
688 ,p_scl_segment16 => p_notice_period_end_date
689 ,p_scl_concat_segments => p_scl_concat_segments
690 ,p_pgp_segment1 => p_pgp_segment1
691 ,p_pgp_segment2 => p_pgp_segment2
692 ,p_pgp_segment3 => p_pgp_segment3
693 ,p_pgp_segment4 => p_pgp_segment4
694 ,p_pgp_segment5 => p_pgp_segment5
695 ,p_pgp_segment6 => p_pgp_segment6
696 ,p_pgp_segment7 => p_pgp_segment7
697 ,p_pgp_segment8 => p_pgp_segment8
698 ,p_pgp_segment9 => p_pgp_segment9
699 ,p_pgp_segment10 => p_pgp_segment10
700 ,p_pgp_segment11 => p_pgp_segment11
701 ,p_pgp_segment12 => p_pgp_segment12
702 ,p_pgp_segment13 => p_pgp_segment13
703 ,p_pgp_segment14 => p_pgp_segment14
704 ,p_pgp_segment15 => p_pgp_segment15
705 ,p_pgp_segment16 => p_pgp_segment16
706 ,p_pgp_segment17 => p_pgp_segment17
707 ,p_pgp_segment18 => p_pgp_segment18
708 ,p_pgp_segment19 => p_pgp_segment19
709 ,p_pgp_segment20 => p_pgp_segment20
710 ,p_pgp_segment21 => p_pgp_segment21
711 ,p_pgp_segment22 => p_pgp_segment22
712 ,p_pgp_segment23 => p_pgp_segment23
713 ,p_pgp_segment24 => p_pgp_segment24
714 ,p_pgp_segment25 => p_pgp_segment25
715 ,p_pgp_segment26 => p_pgp_segment26
716 ,p_pgp_segment27 => p_pgp_segment27
717 ,p_pgp_segment28 => p_pgp_segment28
718 ,p_pgp_segment29 => p_pgp_segment29
719 ,p_pgp_segment30 => p_pgp_segment30
720 ,p_pgp_concat_segments => p_pgp_concat_segments
721 ,p_contract_id => p_contract_id
722 ,p_establishment_id => p_establishment_id
723 ,p_collective_agreement_id => p_collective_agreement_id
724 ,p_cagr_id_flex_num => p_cagr_id_flex_num
725 ,p_cag_segment1 => p_cag_segment1
726 ,p_cag_segment2 => p_cag_segment2
727 ,p_cag_segment3 => p_cag_segment3
728 ,p_cag_segment4 => p_cag_segment4
729 ,p_cag_segment5 => p_cag_segment5
730 ,p_cag_segment6 => p_cag_segment6
731 ,p_cag_segment7 => p_cag_segment7
732 ,p_cag_segment8 => p_cag_segment8
733 ,p_cag_segment9 => p_cag_segment9
734 ,p_cag_segment10 => p_cag_segment10
735 ,p_cag_segment11 => p_cag_segment11
736 ,p_cag_segment12 => p_cag_segment12
737 ,p_cag_segment13 => p_cag_segment13
738 ,p_cag_segment14 => p_cag_segment14
739 ,p_cag_segment15 => p_cag_segment15
740 ,p_cag_segment16 => p_cag_segment16
741 ,p_cag_segment17 => p_cag_segment17
742 ,p_cag_segment18 => p_cag_segment18
743 ,p_cag_segment19 => p_cag_segment19
744 ,p_cag_segment20 => p_cag_segment20
745 ,p_notice_period => p_notice_period
746 ,p_notice_period_uom => p_notice_period_uom
747 ,p_employee_category => p_employee_category
748 ,p_work_at_home => p_work_at_home
749 ,p_job_post_source_name => p_job_post_source_name
750 ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
751 ,p_supervisor_assignment_id => p_supervisor_assignment_id
752 ,p_group_name => p_group_name
753 ,p_concatenated_segments => p_concatenated_segments
754 ,p_cagr_grade_def_id => p_cagr_grade_def_id
755 ,p_cagr_concatenated_segments=> p_cagr_concatenated_segments
756 ,p_assignment_id => p_assignment_id
757 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
758 ,p_people_group_id => p_people_group_id
759 ,p_object_version_number => p_object_version_number
763 ,p_comment_id => p_comment_id
760 ,p_effective_start_date => p_effective_start_date
761 ,p_effective_end_date => p_effective_end_date
762 ,p_assignment_sequence => p_assignment_sequence
764 ,p_other_manager_warning => p_other_manager_warning
765 ,p_hourly_salaried_warning => p_hourly_salaried_warning
766 ,p_gsp_post_process_warning => p_gsp_post_process_warning
767
768 );
769 hr_utility.set_location(' Leaving:'||l_proc, 30);
770 --
771 END create_pl_secondary_emp_asg;
772 -- ----------------------------------------------------------------------------
773 -- |-------------------< update_pl_emp_asg OLD>-------------------------|
774 -- ----------------------------------------------------------------------------
775
776
777 procedure update_pl_emp_asg
778 (p_validate in boolean default false
779 ,p_effective_date in date
780 ,p_datetrack_update_mode in varchar2
781 ,p_assignment_id in number
782 ,p_object_version_number in out nocopy number
783 ,p_supervisor_id in number default hr_api.g_number
784 ,p_assignment_number in varchar2 default hr_api.g_varchar2
785 ,p_change_reason in varchar2 default hr_api.g_varchar2
786 ,p_assignment_status_type_id in number default hr_api.g_number
787 ,p_comments in varchar2 default hr_api.g_varchar2
788 ,p_date_probation_end in date default hr_api.g_date
789 ,p_default_code_comb_id in number default hr_api.g_number
790 ,p_frequency in varchar2 default hr_api.g_varchar2
791 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
792 ,p_manager_flag in varchar2 default hr_api.g_varchar2
793 ,p_normal_hours in number default hr_api.g_number
794 ,p_perf_review_period in number default hr_api.g_number
795 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
796 ,p_probation_period in number default hr_api.g_number
797 ,p_probation_unit in varchar2 default hr_api.g_varchar2
798 ,p_sal_review_period in number default hr_api.g_number
799 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
800 ,p_set_of_books_id in number default hr_api.g_number
801 ,p_source_type in varchar2 default hr_api.g_varchar2
802 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
803 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
804 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
805 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
806 ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
807 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
808 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
809 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
810 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
811 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
812 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
813 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
814 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
815 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
816 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
817 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
818 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
819 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
820 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
821 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
822 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
823 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
824 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
825 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
826 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
827 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
828 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
829 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
830 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
831 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
832 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
833 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
834 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
835 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
836 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
837 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
838 ,p_title in varchar2 default hr_api.g_varchar2
839 ,p_segment1 in varchar2 default hr_api.g_varchar2
840 ,p_legal_employer in varchar2 default hr_api.g_varchar2
841 ,p_segment3 in varchar2 default hr_api.g_varchar2
842 ,p_segment4 in varchar2 default hr_api.g_varchar2
843 ,p_segment5 in varchar2 default hr_api.g_varchar2
844 ,p_segment6 in varchar2 default hr_api.g_varchar2
845 ,p_segment7 in varchar2 default hr_api.g_varchar2
846 ,p_segment8 in varchar2 default hr_api.g_varchar2
847 ,p_segment9 in varchar2 default hr_api.g_varchar2
851 ,p_segment13 in varchar2 default hr_api.g_varchar2
848 ,p_segment10 in varchar2 default hr_api.g_varchar2
849 ,p_segment11 in varchar2 default hr_api.g_varchar2
850 ,p_segment12 in varchar2 default hr_api.g_varchar2
852 ,p_segment14 in varchar2 default hr_api.g_varchar2
853 ,p_segment15 in varchar2 default hr_api.g_varchar2
854 ,p_segment16 in varchar2 default hr_api.g_varchar2
855 ,p_segment17 in varchar2 default hr_api.g_varchar2
856 ,p_segment18 in varchar2 default hr_api.g_varchar2
857 ,p_segment19 in varchar2 default hr_api.g_varchar2
858 ,p_segment20 in varchar2 default hr_api.g_varchar2
859 ,p_segment21 in varchar2 default hr_api.g_varchar2
860 ,p_segment22 in varchar2 default hr_api.g_varchar2
861 ,p_segment23 in varchar2 default hr_api.g_varchar2
862 ,p_segment24 in varchar2 default hr_api.g_varchar2
863 ,p_segment25 in varchar2 default hr_api.g_varchar2
864 ,p_segment26 in varchar2 default hr_api.g_varchar2
865 ,p_segment27 in varchar2 default hr_api.g_varchar2
866 ,p_segment28 in varchar2 default hr_api.g_varchar2
867 ,p_segment29 in varchar2 default hr_api.g_varchar2
868 ,p_segment30 in varchar2 default hr_api.g_varchar2
869 ,p_concat_segments in varchar2 default hr_api.g_varchar2
870 ,p_contract_id in number default hr_api.g_number
871 ,p_establishment_id in number default hr_api.g_number
872 ,p_collective_agreement_id in number default hr_api.g_number
873 ,p_cagr_id_flex_num in number default hr_api.g_number
874 ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
875 ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
876 ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
877 ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
878 ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
879 ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
880 ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
881 ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
882 ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
883 ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
884 ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
885 ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
886 ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
887 ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
888 ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
889 ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
890 ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
891 ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
892 ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
893 ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
894 ,p_notice_period in number default hr_api.g_number
895 ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
896 ,p_employee_category in varchar2 default hr_api.g_varchar2
897 ,p_work_at_home in varchar2 default hr_api.g_varchar2
898 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
899 ,p_supervisor_assignment_id in number default hr_api.g_number
900 ,p_cagr_grade_def_id in out nocopy number
901 ,p_cagr_concatenated_segments out nocopy varchar2
902 ,p_concatenated_segments out nocopy varchar2
903 ,p_soft_coding_keyflex_id in out nocopy number
904 ,p_comment_id out nocopy number
905 ,p_effective_start_date out nocopy date
906 ,p_effective_end_date out nocopy date
907 ,p_no_managers_warning out nocopy boolean
908 ,p_other_manager_warning out nocopy boolean
909 ,p_hourly_salaried_warning out nocopy boolean
910 ,p_gsp_post_process_warning out nocopy varchar2
911 )is
912 --
913 -- Declare cursors AND local variables
914 --
915 l_proc VARCHAR2(72) := g_package||'update_pl_emp_asg OLD';
916
917 BEGIN
918 hr_utility.set_location('Entering:'|| l_proc, 10);
919
920 /* Replaced code with call to new procedure
921 --
922 -- Truncate DATE variables
923 --
924 l_effective_date := trunc(p_effective_date);
925 --
926 -- Validate IN addition to Table Handlers
927 --
928 -- Check that the assignment exists.
929 --
930 OPEN check_legislation(p_assignment_id, l_effective_date);
931 FETCH check_legislation into l_legislation_code;
932 IF check_legislation%notfound THEN
933 CLOSE check_legislation;
934 hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
935 hr_utility.raise_error;
936 END IF;
937 CLOSE check_legislation;
938 hr_utility.set_location(l_proc, 20);
939 --
940 -- Check that the legislation of the specified business group IS 'PL'.
941 --
942 IF l_legislation_code <> 'PL' THEN
943 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
944 hr_utility.set_message_token('LEG_CODE','PL');
945 hr_utility.raise_error;
946 END IF;
947 hr_utility.set_location(l_proc, 30);
948 --
949 --
950 -- Call update_emp_asg business process
951 --
955 */
952
953 hr_assignment_api.update_emp_asg
954
956 hr_pl_assignment_api.update_pl_emp_asg
957 ( p_validate =>p_validate
958 ,p_effective_date =>p_effective_date
959 ,p_datetrack_update_mode =>p_datetrack_update_mode
960 ,p_assignment_id =>p_assignment_id
961 ,p_object_version_number =>p_object_version_number
962 ,p_supervisor_id =>p_supervisor_id
963 ,p_assignment_number =>p_assignment_number
964 ,p_change_reason =>p_change_reason
965 ,p_assignment_status_type_id =>p_assignment_status_type_id
966 ,p_comments =>p_comments
967 ,p_date_probation_end =>p_date_probation_end
968 ,p_default_code_comb_id =>p_default_code_comb_id
969 ,p_frequency =>p_frequency
970 ,p_internal_address_line =>p_internal_address_line
971 ,p_manager_flag =>p_manager_flag
972 ,p_normal_hours =>p_normal_hours
973 ,p_perf_review_period =>p_perf_review_period
974 ,p_perf_review_period_frequency =>p_perf_review_period_frequency
975 ,p_probation_period =>p_probation_period
976 ,p_probation_unit =>p_probation_unit
977 ,p_sal_review_period =>p_sal_review_period
978 ,p_sal_review_period_frequency =>p_sal_review_period_frequency
979 ,p_set_of_books_id =>p_set_of_books_id
980 ,p_source_type =>p_source_type
981 ,p_time_normal_finish =>p_time_normal_finish
982 ,p_time_normal_start =>p_time_normal_start
983 ,p_bargaining_unit_code =>p_bargaining_unit_code
984 ,p_labour_union_member_flag =>p_labour_union_member_flag
985 ,p_hourly_salaried_code =>p_hourly_salaried_code
986 ,p_ass_attribute_category =>p_ass_attribute_category
987 ,p_ass_attribute1 =>p_ass_attribute1
988 ,p_ass_attribute2 =>p_ass_attribute2
989 ,p_ass_attribute3 =>p_ass_attribute3
990 ,p_ass_attribute4 =>p_ass_attribute4
991 ,p_ass_attribute5 =>p_ass_attribute5
992 ,p_ass_attribute6 =>p_ass_attribute6
993 ,p_ass_attribute7 =>p_ass_attribute7
994 ,p_ass_attribute8 =>p_ass_attribute8
995 ,p_ass_attribute9 =>p_ass_attribute9
996 ,p_ass_attribute10 =>p_ass_attribute10
997 ,p_ass_attribute11 =>p_ass_attribute11
998 ,p_ass_attribute12 =>p_ass_attribute12
999 ,p_ass_attribute13 =>p_ass_attribute13
1000 ,p_ass_attribute14 =>p_ass_attribute14
1001 ,p_ass_attribute15 =>p_ass_attribute15
1002 ,p_ass_attribute16 =>p_ass_attribute16
1003 ,p_ass_attribute17 =>p_ass_attribute17
1004 ,p_ass_attribute18 =>p_ass_attribute18
1005 ,p_ass_attribute19 =>p_ass_attribute19
1006 ,p_ass_attribute20 =>p_ass_attribute20
1007 ,p_ass_attribute21 =>p_ass_attribute21
1008 ,p_ass_attribute22 =>p_ass_attribute22
1009 ,p_ass_attribute23 =>p_ass_attribute23
1010 ,p_ass_attribute24 =>p_ass_attribute24
1011 ,p_ass_attribute25 =>p_ass_attribute25
1012 ,p_ass_attribute26 =>p_ass_attribute26
1013 ,p_ass_attribute27 =>p_ass_attribute27
1014 ,p_ass_attribute28 =>p_ass_attribute28
1015 ,p_ass_attribute29 =>p_ass_attribute29
1016 ,p_ass_attribute30 =>p_ass_attribute30
1017 ,p_title =>p_title
1018 ,p_contract_category =>p_segment3
1019 ,p_contract_type =>p_segment4
1020 ,p_contract_number =>p_segment5
1021 ,p_change_of_contract_reason =>p_segment6
1022 ,p_job =>p_segment7
1023 ,p_work_in_special_condition =>p_segment8
1024 ,p_end_of_contract_addl_details =>p_segment9
1025 ,p_contract_start_date =>p_segment11
1026 ,p_planned_valid_to_date =>p_segment12
1027 ,p_contract_type_change_date =>p_segment13
1028 ,p_date_contract_signed =>p_segment14
1029 ,p_notice_period_date =>p_segment15
1030 ,p_notice_period_end_date =>p_segment16
1031 ,p_concat_segments =>p_concat_segments
1032 ,p_contract_id =>p_contract_id
1033 ,p_establishment_id =>p_establishment_id
1034 ,p_collective_agreement_id =>p_collective_agreement_id
1035 ,p_cagr_id_flex_num =>p_cagr_id_flex_num
1036 ,p_cag_segment1 =>p_cag_segment1
1037 ,p_cag_segment2 =>p_cag_segment2
1038 ,p_cag_segment3 =>p_cag_segment3
1039 ,p_cag_segment4 =>p_cag_segment4
1040 ,p_cag_segment5 =>p_cag_segment5
1041 ,p_cag_segment6 =>p_cag_segment6
1042 ,p_cag_segment7 =>p_cag_segment7
1043 ,p_cag_segment8 =>p_cag_segment8
1044 ,p_cag_segment9 =>p_cag_segment9
1045 ,p_cag_segment10 =>p_cag_segment10
1046 ,p_cag_segment11 =>p_cag_segment11
1047 ,p_cag_segment12 =>p_cag_segment12
1048 ,p_cag_segment13 =>p_cag_segment13
1049 ,p_cag_segment14 =>p_cag_segment14
1050 ,p_cag_segment15 =>p_cag_segment15
1051 ,p_cag_segment16 =>p_cag_segment16
1052 ,p_cag_segment17 =>p_cag_segment17
1053 ,p_cag_segment18 =>p_cag_segment18
1054 ,p_cag_segment19 =>p_cag_segment19
1055 ,p_cag_segment20 =>p_cag_segment20
1056 ,p_notice_period =>p_notice_period
1057 ,p_notice_period_uom =>p_notice_period_uom
1058 ,p_employee_category =>p_employee_category
1059 ,p_work_at_home =>p_work_at_home
1060 ,p_job_post_source_name =>p_job_post_source_name
1064 ,p_concatenated_segments =>p_concatenated_segments
1061 ,p_supervisor_assignment_id =>p_supervisor_assignment_id
1062 ,p_cagr_grade_def_id =>p_cagr_grade_def_id
1063 ,p_cagr_concatenated_segments =>p_cagr_concatenated_segments
1065 ,p_soft_coding_keyflex_id =>p_soft_coding_keyflex_id
1066 ,p_comment_id =>p_comment_id
1067 ,p_effective_start_date =>p_effective_start_date
1068 ,p_effective_end_date =>p_effective_end_date
1069 ,p_no_managers_warning =>p_no_managers_warning
1070 ,p_other_manager_warning =>p_other_manager_warning
1071 ,p_hourly_salaried_warning =>p_hourly_salaried_warning
1072 ,p_gsp_post_process_warning =>p_gsp_post_process_warning
1073 );
1074
1075 hr_utility.set_location(' Leaving:'||l_proc, 40);
1076 END update_pl_emp_asg;
1077
1078 -- ----------------------------------------------------------------------------
1079 -- |-------------------< update_pl_emp_asg NEW>-------------------------|
1080 -- ----------------------------------------------------------------------------
1081
1082
1083 procedure update_pl_emp_asg
1084 (p_validate in boolean default false
1085 ,p_effective_date in date
1086 ,p_datetrack_update_mode in varchar2
1087 ,p_assignment_id in number
1088 ,p_object_version_number in out nocopy number
1089 ,p_supervisor_id in number default hr_api.g_number
1090 ,p_assignment_number in varchar2 default hr_api.g_varchar2
1091 ,p_change_reason in varchar2 default hr_api.g_varchar2
1092 ,p_assignment_status_type_id in number default hr_api.g_number
1093 ,p_comments in varchar2 default hr_api.g_varchar2
1094 ,p_date_probation_end in date default hr_api.g_date
1095 ,p_default_code_comb_id in number default hr_api.g_number
1096 ,p_frequency in varchar2 default hr_api.g_varchar2
1097 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1098 ,p_manager_flag in varchar2 default hr_api.g_varchar2
1099 ,p_normal_hours in number default hr_api.g_number
1100 ,p_perf_review_period in number default hr_api.g_number
1101 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1102 ,p_probation_period in number default hr_api.g_number
1103 ,p_probation_unit in varchar2 default hr_api.g_varchar2
1104 ,p_sal_review_period in number default hr_api.g_number
1105 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1106 ,p_set_of_books_id in number default hr_api.g_number
1107 ,p_source_type in varchar2 default hr_api.g_varchar2
1108 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1109 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1110 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1111 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1112 ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1113 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1114 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1115 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1116 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1117 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1118 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1119 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1120 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1121 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1122 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1123 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1124 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1125 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1126 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1127 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1128 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1129 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1130 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1131 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1132 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1133 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1134 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1135 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1136 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1137 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1138 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1139 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1140 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1141 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1142 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1143 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1144 ,p_title in varchar2 default hr_api.g_varchar2
1145 ,p_contract_category in varchar2 default hr_api.g_varchar2
1146 ,p_contract_type in varchar2 default hr_api.g_varchar2
1147 ,p_contract_number in varchar2 default hr_api.g_varchar2
1148 ,p_change_of_contract_reason in varchar2 default hr_api.g_varchar2
1149 ,p_job in varchar2 default hr_api.g_varchar2
1153 ,p_planned_valid_to_date in varchar2 default hr_api.g_varchar2
1150 ,p_work_in_special_condition in varchar2 default hr_api.g_varchar2
1151 ,p_end_of_contract_addl_details in varchar2 default hr_api.g_varchar2
1152 ,p_contract_start_date in varchar2 default hr_api.g_varchar2
1154 ,p_contract_type_change_date in varchar2 default hr_api.g_varchar2
1155 ,p_date_contract_signed in varchar2 default hr_api.g_varchar2
1156 ,p_notice_period_date in varchar2 default hr_api.g_varchar2
1157 ,p_notice_period_end_date in varchar2 default hr_api.g_varchar2
1158 ,p_concat_segments in varchar2 default hr_api.g_varchar2
1159 ,p_contract_id in number default hr_api.g_number
1160 ,p_establishment_id in number default hr_api.g_number
1161 ,p_collective_agreement_id in number default hr_api.g_number
1162 ,p_cagr_id_flex_num in number default hr_api.g_number
1163 ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1164 ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1165 ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1166 ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1167 ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1168 ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1169 ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1170 ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1171 ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1172 ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1173 ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1174 ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1175 ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1176 ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1177 ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1178 ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1179 ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1180 ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1181 ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1182 ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1183 ,p_notice_period in number default hr_api.g_number
1184 ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1185 ,p_employee_category in varchar2 default hr_api.g_varchar2
1186 ,p_work_at_home in varchar2 default hr_api.g_varchar2
1187 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1188 ,p_supervisor_assignment_id in number default hr_api.g_number
1189 ,p_cagr_grade_def_id in out nocopy number
1190 ,p_cagr_concatenated_segments out nocopy varchar2
1191 ,p_concatenated_segments out nocopy varchar2
1192 ,p_soft_coding_keyflex_id in out nocopy number
1193 ,p_comment_id out nocopy number
1194 ,p_effective_start_date out nocopy date
1195 ,p_effective_end_date out nocopy date
1196 ,p_no_managers_warning out nocopy boolean
1197 ,p_other_manager_warning out nocopy boolean
1198 ,p_hourly_salaried_warning out nocopy boolean
1199 ,p_gsp_post_process_warning out nocopy varchar2
1200 )is
1201 --
1202 -- Declare cursors AND local variables
1203 --
1204 l_proc VARCHAR2(72) := g_package||'update_pl_emp_asg';
1205 l_effective_date DATE;
1206 l_legislation_code per_business_groups.legislation_code%TYPE;
1207 l_business_group_id per_business_groups.business_group_id%type;
1208 a varchar2(100);
1209 v_field varchar2(20);
1210 --
1211 CURSOR check_legislation
1212 (c_assignment_id per_assignments_f.assignment_id%TYPE,
1213 c_effective_date DATE
1214 )
1215 IS
1216 SELECT bgp.legislation_code
1217 FROM per_assignments_f asg,
1218 per_business_groups bgp
1219 WHERE asg.business_group_id = bgp.business_group_id
1220 AND asg.assignment_id = c_assignment_id
1221 AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
1222 --
1223
1224
1225 BEGIN
1226 hr_utility.set_location('Entering:'|| l_proc, 10);
1227
1228 --
1229 -- Truncate DATE variables
1230 --
1231 l_effective_date := trunc(p_effective_date);
1232 --
1233 -- Validate IN addition to Table Handlers
1234 --
1235 -- Check that the assignment exists.
1236 --
1237 OPEN check_legislation(p_assignment_id, l_effective_date);
1238 FETCH check_legislation into l_legislation_code;
1239 IF check_legislation%notfound THEN
1240 CLOSE check_legislation;
1241 hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1242 hr_utility.raise_error;
1243 END IF;
1244 CLOSE check_legislation;
1245 hr_utility.set_location(l_proc, 20);
1246 --
1247 -- Check that the legislation of the specified business group IS 'PL'.
1248 --
1249 IF l_legislation_code <> 'PL' THEN
1250 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1251 hr_utility.set_message_token('LEG_CODE','PL');
1252 hr_utility.raise_error;
1253 END IF;
1254 hr_utility.set_location(l_proc, 30);
1255 --
1256 --
1257 -- Call update_emp_asg business process
1258 --
1259
1260 hr_assignment_api.update_emp_asg
1261 (
1262 p_validate => p_validate
1263 ,p_effective_date => p_effective_date
1267 ,p_supervisor_id => p_supervisor_id
1264 ,p_datetrack_update_mode => p_datetrack_update_mode
1265 ,p_assignment_id => p_assignment_id
1266 ,p_object_version_number => p_object_version_number
1268 ,p_assignment_number => p_assignment_number
1269 ,p_change_reason => p_change_reason
1270 ,p_assignment_status_type_id => p_assignment_status_type_id
1271 ,p_comments => p_comments
1272 ,p_date_probation_end => p_date_probation_end
1273 ,p_default_code_comb_id => p_default_code_comb_id
1274 ,p_frequency => p_frequency
1275 ,p_internal_address_line => p_internal_address_line
1276 ,p_manager_flag => p_manager_flag
1277 ,p_normal_hours => p_normal_hours
1278 ,p_perf_review_period => p_perf_review_period
1279 ,p_perf_review_period_frequency => p_perf_review_period_frequency
1280 ,p_probation_period => p_probation_period
1281 ,p_probation_unit => p_probation_unit
1282 ,p_sal_review_period => p_sal_review_period
1283 ,p_sal_review_period_frequency => p_sal_review_period_frequency
1284 ,p_set_of_books_id => p_set_of_books_id
1285 ,p_source_type => p_source_type
1286 ,p_time_normal_finish => p_time_normal_finish
1287 ,p_time_normal_start => p_time_normal_start
1288 ,p_bargaining_unit_code => p_bargaining_unit_code
1289 ,p_labour_union_member_flag => p_labour_union_member_flag
1290 ,p_hourly_salaried_code => p_hourly_salaried_code
1291 ,p_ass_attribute_category => p_ass_attribute_category
1292 ,p_ass_attribute1 => p_ass_attribute1
1293 ,p_ass_attribute2 => p_ass_attribute2
1294 ,p_ass_attribute3 => p_ass_attribute3
1295 ,p_ass_attribute4 => p_ass_attribute4
1296 ,p_ass_attribute5 => p_ass_attribute5
1297 ,p_ass_attribute6 => p_ass_attribute6
1298 ,p_ass_attribute7 => p_ass_attribute7
1299 ,p_ass_attribute8 => p_ass_attribute8
1300 ,p_ass_attribute9 => p_ass_attribute9
1301 ,p_ass_attribute10 => p_ass_attribute10
1302 ,p_ass_attribute11 => p_ass_attribute11
1303 ,p_ass_attribute12 => p_ass_attribute12
1304 ,p_ass_attribute13 => p_ass_attribute13
1305 ,p_ass_attribute14 => p_ass_attribute14
1306 ,p_ass_attribute15 => p_ass_attribute15
1307 ,p_ass_attribute16 => p_ass_attribute16
1308 ,p_ass_attribute17 => p_ass_attribute17
1309 ,p_ass_attribute18 => p_ass_attribute18
1310 ,p_ass_attribute19 => p_ass_attribute19
1311 ,p_ass_attribute20 => p_ass_attribute20
1312 ,p_ass_attribute21 => p_ass_attribute21
1313 ,p_ass_attribute22 => p_ass_attribute22
1314 ,p_ass_attribute23 => p_ass_attribute23
1315 ,p_ass_attribute24 => p_ass_attribute24
1316 ,p_ass_attribute25 => p_ass_attribute25
1317 ,p_ass_attribute26 => p_ass_attribute26
1318 ,p_ass_attribute27 => p_ass_attribute27
1319 ,p_ass_attribute28 => p_ass_attribute28
1320 ,p_ass_attribute29 => p_ass_attribute29
1321 ,p_ass_attribute30 => p_ass_attribute30
1322 ,p_title => p_title
1323 ,p_segment3 => p_contract_category
1324 ,p_segment4 => p_contract_type
1325 ,p_segment5 => p_contract_number
1326 ,p_segment6 => p_change_of_contract_reason
1327 ,p_segment7 => p_job
1328 ,p_segment8 => p_work_in_special_condition
1329 ,p_segment9 => p_end_of_contract_addl_details
1330 ,p_segment11 => p_contract_start_date
1331 ,p_segment12 => p_planned_valid_to_date
1332 ,p_segment13 => p_contract_type_change_date
1333 ,p_segment14 => p_date_contract_signed
1334 ,p_segment15 => p_notice_period_date
1335 ,p_segment16 => p_notice_period_end_date
1336 ,p_concat_segments => p_concat_segments
1337 ,p_contract_id => p_contract_id
1338 ,p_establishment_id => p_establishment_id
1339 ,p_collective_agreement_id => p_collective_agreement_id
1340 ,p_cagr_id_flex_num => p_cagr_id_flex_num
1341 ,p_cag_segment1 => p_cag_segment1
1342 ,p_cag_segment2 => p_cag_segment2
1343 ,p_cag_segment3 => p_cag_segment3
1344 ,p_cag_segment4 => p_cag_segment4
1345 ,p_cag_segment5 => p_cag_segment5
1346 ,p_cag_segment6 => p_cag_segment6
1347 ,p_cag_segment7 => p_cag_segment7
1348 ,p_cag_segment8 => p_cag_segment8
1349 ,p_cag_segment9 => p_cag_segment9
1350 ,p_cag_segment10 => p_cag_segment10
1351 ,p_cag_segment11 => p_cag_segment11
1352 ,p_cag_segment12 => p_cag_segment12
1353 ,p_cag_segment13 => p_cag_segment13
1354 ,p_cag_segment14 => p_cag_segment14
1355 ,p_cag_segment15 => p_cag_segment15
1356 ,p_cag_segment16 => p_cag_segment16
1357 ,p_cag_segment17 => p_cag_segment17
1358 ,p_cag_segment18 => p_cag_segment18
1359 ,p_cag_segment19 => p_cag_segment19
1360 ,p_cag_segment20 => p_cag_segment20
1361 ,p_notice_period => p_notice_period
1362 ,p_notice_period_uom => p_notice_period_uom
1363 ,p_employee_category => p_employee_category
1364 ,p_work_at_home => p_work_at_home
1365 ,p_job_post_source_name => p_job_post_source_name
1366 ,p_supervisor_assignment_id => p_supervisor_assignment_id
1367 ,p_cagr_grade_def_id => p_cagr_grade_def_id
1368 ,p_cagr_concatenated_segments => p_cagr_concatenated_segments
1369 ,p_concatenated_segments => p_concatenated_segments
1370 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
1371 ,p_comment_id => p_comment_id
1372 ,p_effective_start_date => p_effective_start_date
1373 ,p_effective_end_date => p_effective_end_date
1374 ,p_no_managers_warning => p_no_managers_warning
1375 ,p_other_manager_warning => p_other_manager_warning
1376 ,p_hourly_salaried_warning => p_hourly_salaried_warning
1377 ,p_gsp_post_process_warning => p_gsp_post_process_warning
1378
1379 );
1380
1381 hr_utility.set_location(' Leaving:'||l_proc, 40);
1382 END update_pl_emp_asg;
1383 END hr_pl_assignment_api;