[Home] [Help]
PACKAGE BODY: APPS.HR_IN_ASSIGNMENT_API
Source
1 PACKAGE Body hr_in_assignment_api AS
2 /* $Header: peasgini.pkb 120.1 2005/08/05 05:31 sukukuma noship $ */
3 g_package VARCHAR2(33) := 'hr_in_assignment_api.';
4 g_trace BOOLEAN ;
5
6
7 -- ----------------------------------------------------------------------------
8 -- |---------------------------< check_person >-------------------------------|
9 -- ----------------------------------------------------------------------------
10
11 PROCEDURE check_person (p_person_id IN NUMBER
12 ,p_legislation_code IN VARCHAR2
13 ,p_effective_date IN DATE
14 )
15 IS
16 l_legislation_code per_business_groups.legislation_code%type;
17 --
18 CURSOR csr_emp_leg
19 (l_person_id per_people_f.person_id%TYPE,
20 l_effective_date DATE
21 )
22 IS
23 SELECT bgp.legislation_code
24 FROM per_people_f per,
25 per_business_groups bgp
26 WHERE per.business_group_id = bgp.business_group_id
27 AND per.person_id = l_person_id
28 AND l_effective_date between per.effective_start_date and per.effective_END_date;
29
30 BEGIN
31
32 OPEN csr_emp_leg(p_person_id, trunc(p_effective_date));
33 FETCH csr_emp_leg into l_legislation_code;
34
35 IF csr_emp_leg%notfound THEN
36 CLOSE csr_emp_leg;
37 hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
38 hr_utility.raise_error;
39 END IF;
40 CLOSE csr_emp_leg;
41
42 --
43 -- Check that the legislation of the specified business group is 'IN'.
44 --
45 IF l_legislation_code <> p_legislation_code THEN
46 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
47 hr_utility.set_message_token('LEG_CODE','IN');
48 hr_utility.raise_error;
49 END IF;
50
51 EXCEPTION
52 WHEN OTHERS THEN
53 IF csr_emp_leg%ISOPEN THEN
54 CLOSE csr_emp_leg;
55 END IF;
56 RAISE;
57
58 END check_person;
59
60 -- ----------------------------------------------------------------------------
61 -- |---------------------< create_in_secondary_emp_asg >--------------------------|
62 -- ----------------------------------------------------------------------------
63
64 PROCEDURE create_in_secondary_emp_asg
65 (p_validate IN BOOLEAN DEFAULT false
66 ,p_effective_date IN DATE
67 ,p_person_id IN NUMBER
68 ,p_organization_id IN NUMBER
69 ,p_grade_id IN NUMBER DEFAULT null
70 ,p_position_id IN NUMBER DEFAULT null
71 ,p_job_id IN NUMBER DEFAULT null
72 ,p_assignment_status_type_id IN NUMBER DEFAULT null
73 ,p_payroll_id IN NUMBER DEFAULT null
74 ,p_location_id IN NUMBER DEFAULT null
75 ,p_supervisor_id IN NUMBER DEFAULT null
76 ,p_special_ceiling_step_id IN NUMBER DEFAULT null
77 ,p_pay_basis_id IN NUMBER DEFAULT null
78 ,p_assignment_number IN OUT NOCOPY VARCHAR2
79 ,p_change_reason IN VARCHAR2 DEFAULT null
80 ,p_comments IN VARCHAR2 DEFAULT null
81 ,p_date_probation_end IN DATE DEFAULT null
82 ,p_default_code_comb_id IN NUMBER DEFAULT null
83 ,p_employment_category IN VARCHAR2 DEFAULT null
84 ,p_frequency IN VARCHAR2 DEFAULT null
85 ,p_internal_address_line IN VARCHAR2 DEFAULT null
86 ,p_manager_flag IN VARCHAR2 DEFAULT null
87 ,p_normal_hours IN NUMBER DEFAULT null
88 ,p_perf_review_period IN NUMBER DEFAULT null
89 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT null
90 ,p_probation_period IN NUMBER DEFAULT null
91 ,p_probation_unit IN VARCHAR2 DEFAULT null
92 ,p_sal_review_period IN NUMBER DEFAULT null
93 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT null
94 ,p_set_of_books_id IN NUMBER DEFAULT null
95 ,p_source_type IN VARCHAR2 DEFAULT null
96 ,p_time_normal_finish IN VARCHAR2 DEFAULT null
97 ,p_time_normal_start IN VARCHAR2 DEFAULT null
98 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT null
99 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT null
100 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT null
101 ,p_ass_attribute_category IN VARCHAR2 DEFAULT null
102 ,p_ass_attribute1 IN VARCHAR2 DEFAULT null
103 ,p_ass_attribute2 IN VARCHAR2 DEFAULT null
104 ,p_ass_attribute3 IN VARCHAR2 DEFAULT null
105 ,p_ass_attribute4 IN VARCHAR2 DEFAULT null
106 ,p_ass_attribute5 IN VARCHAR2 DEFAULT null
107 ,p_ass_attribute6 IN VARCHAR2 DEFAULT null
108 ,p_ass_attribute7 IN VARCHAR2 DEFAULT null
109 ,p_ass_attribute8 IN VARCHAR2 DEFAULT null
110 ,p_ass_attribute9 IN VARCHAR2 DEFAULT null
111 ,p_ass_attribute10 IN VARCHAR2 DEFAULT null
112 ,p_ass_attribute11 IN VARCHAR2 DEFAULT null
113 ,p_ass_attribute12 IN VARCHAR2 DEFAULT null
114 ,p_ass_attribute13 IN VARCHAR2 DEFAULT null
115 ,p_ass_attribute14 IN VARCHAR2 DEFAULT null
116 ,p_ass_attribute15 IN VARCHAR2 DEFAULT null
117 ,p_ass_attribute16 IN VARCHAR2 DEFAULT null
118 ,p_ass_attribute17 IN VARCHAR2 DEFAULT null
119 ,p_ass_attribute18 IN VARCHAR2 DEFAULT null
120 ,p_ass_attribute19 IN VARCHAR2 DEFAULT null
121 ,p_ass_attribute20 IN VARCHAR2 DEFAULT null
122 ,p_ass_attribute21 IN VARCHAR2 DEFAULT null
123 ,p_ass_attribute22 IN VARCHAR2 DEFAULT null
124 ,p_ass_attribute23 IN VARCHAR2 DEFAULT null
125 ,p_ass_attribute24 IN VARCHAR2 DEFAULT null
126 ,p_ass_attribute25 IN VARCHAR2 DEFAULT null
127 ,p_ass_attribute26 IN VARCHAR2 DEFAULT null
128 ,p_ass_attribute27 IN VARCHAR2 DEFAULT null
129 ,p_ass_attribute28 IN VARCHAR2 DEFAULT null
130 ,p_ass_attribute29 IN VARCHAR2 DEFAULT null
131 ,p_ass_attribute30 IN VARCHAR2 DEFAULT null
132 ,p_title IN VARCHAR2 DEFAULT null
133 ,p_gre_legal_entity IN VARCHAR2
134 ,p_pf_organization IN VARCHAR2 DEFAULT null
135 ,p_prof_tax_organization IN VARCHAR2 DEFAULT null
136 ,p_esi_organization IN VARCHAR2 DEFAULT null
137 ,p_factory IN VARCHAR2 DEFAULT null
138 ,p_establishment IN VARCHAR2 DEFAULT null
139 ,p_covered_by_gratuity_act IN VARCHAR2 DEFAULT 'N'
140 ,p_having_substantial_interest IN VARCHAR2 DEFAULT 'N'
141 ,p_director IN VARCHAR2 DEFAULT 'N'
142 ,p_specified IN VARCHAR2 DEFAULT 'Y'
143 ,p_scl_concat_segments IN VARCHAR2 DEFAULT null
144 ,p_pgp_segment1 IN VARCHAR2 DEFAULT null
145 ,p_pgp_segment2 IN VARCHAR2 DEFAULT null
146 ,p_pgp_segment3 IN VARCHAR2 DEFAULT null
147 ,p_pgp_segment4 IN VARCHAR2 DEFAULT null
148 ,p_pgp_segment5 IN VARCHAR2 DEFAULT null
149 ,p_pgp_segment6 IN VARCHAR2 DEFAULT null
150 ,p_pgp_segment7 IN VARCHAR2 DEFAULT null
151 ,p_pgp_segment8 IN VARCHAR2 DEFAULT null
152 ,p_pgp_segment9 IN VARCHAR2 DEFAULT null
153 ,p_pgp_segment10 IN VARCHAR2 DEFAULT null
154 ,p_pgp_segment11 IN VARCHAR2 DEFAULT null
155 ,p_pgp_segment12 IN VARCHAR2 DEFAULT null
156 ,p_pgp_segment13 IN VARCHAR2 DEFAULT null
157 ,p_pgp_segment14 IN VARCHAR2 DEFAULT null
158 ,p_pgp_segment15 IN VARCHAR2 DEFAULT null
159 ,p_pgp_segment16 IN VARCHAR2 DEFAULT null
160 ,p_pgp_segment17 IN VARCHAR2 DEFAULT null
161 ,p_pgp_segment18 IN VARCHAR2 DEFAULT null
162 ,p_pgp_segment19 IN VARCHAR2 DEFAULT null
163 ,p_pgp_segment20 IN VARCHAR2 DEFAULT null
164 ,p_pgp_segment21 IN VARCHAR2 DEFAULT null
165 ,p_pgp_segment22 IN VARCHAR2 DEFAULT null
166 ,p_pgp_segment23 IN VARCHAR2 DEFAULT null
167 ,p_pgp_segment24 IN VARCHAR2 DEFAULT null
168 ,p_pgp_segment25 IN VARCHAR2 DEFAULT null
169 ,p_pgp_segment26 IN VARCHAR2 DEFAULT null
170 ,p_pgp_segment27 IN VARCHAR2 DEFAULT null
171 ,p_pgp_segment28 IN VARCHAR2 DEFAULT null
172 ,p_pgp_segment29 IN VARCHAR2 DEFAULT null
173 ,p_pgp_segment30 IN VARCHAR2 DEFAULT null
174 ,p_pgp_concat_segments IN VARCHAR2 DEFAULT null
175 ,p_contract_id IN NUMBER DEFAULT null
176 ,p_establishment_id IN NUMBER DEFAULT null
177 ,p_collective_agreement_id IN NUMBER DEFAULT null
178 ,p_cagr_id_flex_num IN NUMBER DEFAULT null
179 ,p_cag_segment1 IN VARCHAR2 DEFAULT null
180 ,p_cag_segment2 IN VARCHAR2 DEFAULT null
181 ,p_cag_segment3 IN VARCHAR2 DEFAULT null
182 ,p_cag_segment4 IN VARCHAR2 DEFAULT null
183 ,p_cag_segment5 IN VARCHAR2 DEFAULT null
184 ,p_cag_segment6 IN VARCHAR2 DEFAULT null
185 ,p_cag_segment7 IN VARCHAR2 DEFAULT null
186 ,p_cag_segment8 IN VARCHAR2 DEFAULT null
187 ,p_cag_segment9 IN VARCHAR2 DEFAULT null
188 ,p_cag_segment10 IN VARCHAR2 DEFAULT null
189 ,p_cag_segment11 IN VARCHAR2 DEFAULT null
190 ,p_cag_segment12 IN VARCHAR2 DEFAULT null
191 ,p_cag_segment13 IN VARCHAR2 DEFAULT null
192 ,p_cag_segment14 IN VARCHAR2 DEFAULT null
193 ,p_cag_segment15 IN VARCHAR2 DEFAULT null
194 ,p_cag_segment16 IN VARCHAR2 DEFAULT null
195 ,p_cag_segment17 IN VARCHAR2 DEFAULT null
196 ,p_cag_segment18 IN VARCHAR2 DEFAULT null
197 ,p_cag_segment19 IN VARCHAR2 DEFAULT null
198 ,p_cag_segment20 IN VARCHAR2 DEFAULT null
199 ,p_notice_period IN NUMBER DEFAULT null
200 ,p_notice_period_uom IN VARCHAR2 DEFAULT null
201 ,p_employee_category IN VARCHAR2 DEFAULT null
202 ,p_work_at_home IN VARCHAR2 DEFAULT null
203 ,p_job_post_source_name IN VARCHAR2 DEFAULT null
204 ,p_grade_ladder_pgm_id IN NUMBER DEFAULT null
205 ,p_supervisor_assignment_id IN NUMBER DEFAULT null
206 ,p_group_name OUT NOCOPY VARCHAR2
207 ,p_concatenated_segments OUT NOCOPY VARCHAR2
208 ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
209 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
210 ,p_assignment_id OUT NOCOPY NUMBER
211 ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
212 ,p_people_group_id IN OUT NOCOPY NUMBER
213 ,p_object_version_number OUT NOCOPY NUMBER
214 ,p_effective_start_date OUT NOCOPY DATE
215 ,p_effective_end_date OUT NOCOPY DATE
216 ,p_assignment_sequence OUT NOCOPY NUMBER
217 ,p_comment_id OUT NOCOPY NUMBER
218 ,p_other_manager_warning OUT NOCOPY BOOLEAN
219 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
220 ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
221 ) IS
222 --
223 -- Declare variables
224 --
225 l_effective_date DATE;
226 l_proc VARCHAR2(72);
227 --
228 BEGIN
229
230
231 l_proc := g_package||'create_secondary_emp_asg';
232 l_effective_date := trunc(p_effective_date);
233 g_trace := hr_utility.debug_enabled ;
234
235 IF g_trace THEN
236 hr_utility.set_location('Entering: '||l_proc, 10);
237 END IF ;
238
239 check_person (p_person_id ,'IN', l_effective_date);
240
241 IF g_trace THEN
242 hr_utility.set_location(l_proc, 20);
243 END IF ;
244
245 hr_assignment_api.create_secondary_emp_asg
246 (p_validate => p_validate
247 ,p_effective_date => p_effective_date
248 ,p_person_id => p_person_id
249 ,p_organization_id => p_organization_id
250 ,p_grade_id => p_grade_id
251 ,p_position_id => p_position_id
252 ,p_job_id => p_job_id
253 ,p_assignment_status_type_id => p_assignment_status_type_id
254 ,p_payroll_id => p_payroll_id
255 ,p_location_id => p_location_id
256 ,p_supervisor_id => p_supervisor_id
257 ,p_special_ceiling_step_id => p_special_ceiling_step_id
258 ,p_pay_basis_id => p_pay_basis_id
259 ,p_assignment_number => p_assignment_number
260 ,p_change_reason => p_change_reason
261 ,p_comments => p_comments
262 ,p_date_probation_end => p_date_probation_end
263 ,p_default_code_comb_id => p_default_code_comb_id
264 ,p_employment_category => p_employment_category
265 ,p_frequency => p_frequency
266 ,p_internal_address_line => p_internal_address_line
267 ,p_manager_flag => p_manager_flag
268 ,p_normal_hours => p_normal_hours
269 ,p_perf_review_period => p_perf_review_period
270 ,p_perf_review_period_frequency=> p_perf_review_period_frequency
271 ,p_probation_period => p_probation_period
272 ,p_probation_unit => p_probation_unit
273 ,p_sal_review_period => p_sal_review_period
274 ,p_sal_review_period_frequency => p_sal_review_period_frequency
275 ,p_set_of_books_id => p_set_of_books_id
276 ,p_source_type => p_source_type
277 ,p_time_normal_finish => p_time_normal_finish
278 ,p_time_normal_start => p_time_normal_start
279 ,p_bargaining_unit_code => p_bargaining_unit_code
280 ,p_labour_union_member_flag => p_labour_union_member_flag
281 ,p_hourly_salaried_code => p_hourly_salaried_code
282 ,p_ass_attribute_category => p_ass_attribute_category
283 ,p_ass_attribute1 => p_ass_attribute1
284 ,p_ass_attribute2 => p_ass_attribute2
285 ,p_ass_attribute3 => p_ass_attribute3
286 ,p_ass_attribute4 => p_ass_attribute4
287 ,p_ass_attribute5 => p_ass_attribute5
288 ,p_ass_attribute6 => p_ass_attribute6
289 ,p_ass_attribute7 => p_ass_attribute7
290 ,p_ass_attribute8 => p_ass_attribute8
291 ,p_ass_attribute9 => p_ass_attribute9
292 ,p_ass_attribute10 => p_ass_attribute10
293 ,p_ass_attribute11 => p_ass_attribute11
294 ,p_ass_attribute12 => p_ass_attribute12
295 ,p_ass_attribute13 => p_ass_attribute13
296 ,p_ass_attribute14 => p_ass_attribute14
297 ,p_ass_attribute15 => p_ass_attribute15
298 ,p_ass_attribute16 => p_ass_attribute16
299 ,p_ass_attribute17 => p_ass_attribute17
300 ,p_ass_attribute18 => p_ass_attribute18
301 ,p_ass_attribute19 => p_ass_attribute19
302 ,p_ass_attribute20 => p_ass_attribute20
303 ,p_ass_attribute21 => p_ass_attribute21
304 ,p_ass_attribute22 => p_ass_attribute22
305 ,p_ass_attribute23 => p_ass_attribute23
306 ,p_ass_attribute24 => p_ass_attribute24
307 ,p_ass_attribute25 => p_ass_attribute25
308 ,p_ass_attribute26 => p_ass_attribute26
309 ,p_ass_attribute27 => p_ass_attribute27
310 ,p_ass_attribute28 => p_ass_attribute28
311 ,p_ass_attribute29 => p_ass_attribute29
312 ,p_ass_attribute30 => p_ass_attribute30
313 ,p_title => p_title
314 ,p_scl_segment1 => p_gre_legal_entity
315 ,p_scl_segment2 => p_pf_organization
316 ,p_scl_segment3 => p_prof_tax_organization
317 ,p_scl_segment4 => p_esi_organization
318 ,p_scl_segment5 => p_factory
319 ,p_scl_segment6 => p_establishment
320 ,p_scl_segment8 => p_covered_by_gratuity_act
321 ,p_scl_segment9 => p_having_substantial_interest
322 ,p_scl_segment10 => p_director
323 ,p_scl_segment11 => p_specified
324 ,p_scl_concat_segments => p_scl_concat_segments
325 ,p_pgp_segment1 => p_pgp_segment1
326 ,p_pgp_segment2 => p_pgp_segment2
327 ,p_pgp_segment3 => p_pgp_segment3
328 ,p_pgp_segment4 => p_pgp_segment4
329 ,p_pgp_segment5 => p_pgp_segment5
330 ,p_pgp_segment6 => p_pgp_segment6
331 ,p_pgp_segment7 => p_pgp_segment7
332 ,p_pgp_segment8 => p_pgp_segment8
333 ,p_pgp_segment9 => p_pgp_segment9
334 ,p_pgp_segment10 => p_pgp_segment10
335 ,p_pgp_segment11 => p_pgp_segment11
336 ,p_pgp_segment12 => p_pgp_segment12
337 ,p_pgp_segment13 => p_pgp_segment13
338 ,p_pgp_segment14 => p_pgp_segment14
339 ,p_pgp_segment15 => p_pgp_segment15
340 ,p_pgp_segment16 => p_pgp_segment16
341 ,p_pgp_segment17 => p_pgp_segment17
342 ,p_pgp_segment18 => p_pgp_segment18
343 ,p_pgp_segment19 => p_pgp_segment19
344 ,p_pgp_segment20 => p_pgp_segment20
345 ,p_pgp_segment21 => p_pgp_segment21
346 ,p_pgp_segment22 => p_pgp_segment22
347 ,p_pgp_segment23 => p_pgp_segment23
348 ,p_pgp_segment24 => p_pgp_segment24
349 ,p_pgp_segment25 => p_pgp_segment25
350 ,p_pgp_segment26 => p_pgp_segment26
351 ,p_pgp_segment27 => p_pgp_segment27
352 ,p_pgp_segment28 => p_pgp_segment28
353 ,p_pgp_segment29 => p_pgp_segment29
354 ,p_pgp_segment30 => p_pgp_segment30
355 ,p_pgp_concat_segments => p_pgp_concat_segments
356 ,p_contract_id => p_contract_id
357 ,p_establishment_id => p_establishment_id
358 ,p_collective_agreement_id => p_collective_agreement_id
359 ,p_cagr_id_flex_num => p_cagr_id_flex_num
360 ,p_cag_segment1 => p_cag_segment1
361 ,p_cag_segment2 => p_cag_segment2
362 ,p_cag_segment3 => p_cag_segment3
363 ,p_cag_segment4 => p_cag_segment4
364 ,p_cag_segment5 => p_cag_segment5
365 ,p_cag_segment6 => p_cag_segment6
366 ,p_cag_segment7 => p_cag_segment7
367 ,p_cag_segment8 => p_cag_segment8
368 ,p_cag_segment9 => p_cag_segment9
369 ,p_cag_segment10 => p_cag_segment10
370 ,p_cag_segment11 => p_cag_segment11
371 ,p_cag_segment12 => p_cag_segment12
372 ,p_cag_segment13 => p_cag_segment13
373 ,p_cag_segment14 => p_cag_segment14
374 ,p_cag_segment15 => p_cag_segment15
375 ,p_cag_segment16 => p_cag_segment16
376 ,p_cag_segment17 => p_cag_segment17
377 ,p_cag_segment18 => p_cag_segment18
378 ,p_cag_segment19 => p_cag_segment19
379 ,p_cag_segment20 => p_cag_segment20
380 ,p_notice_period => p_notice_period
381 ,p_notice_period_uom => p_notice_period_uom
382 ,p_employee_category => p_employee_category
383 ,p_work_at_home => p_work_at_home
384 ,p_job_post_source_name => p_job_post_source_name
385 ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
386 ,p_supervisor_assignment_id => p_supervisor_assignment_id
387 ,p_group_name => p_group_name
388 ,p_concatenated_segments => p_concatenated_segments
389 ,p_cagr_grade_def_id => p_cagr_grade_def_id
390 ,p_cagr_concatenated_segments => p_cagr_concatenated_segments
391 ,p_assignment_id => p_assignment_id
392 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
393 ,p_people_group_id => p_people_group_id
394 ,p_object_version_number => p_object_version_number
395 ,p_effective_start_date => p_effective_start_date
396 ,p_effective_end_date => p_effective_end_date
397 ,p_assignment_sequence => p_assignment_sequence
398 ,p_comment_id => p_comment_id
399 ,p_other_manager_warning => p_other_manager_warning
400 ,p_hourly_salaried_warning => p_hourly_salaried_warning
401 ,p_gsp_post_process_warning => p_gsp_post_process_warning);
402
403 IF g_trace THEN
404 hr_utility.set_location('Leaving: '||l_proc, 30);
405 END IF ;
406
407 END create_in_secondary_emp_asg;
408
409 -- ----------------------------------------------------------------------------
410 -- |--------------------------< update_in_emp_asg >------------------------------|
411 -- ----------------------------------------------------------------------------
412
413 PROCEDURE update_in_emp_asg
414 (p_validate IN BOOLEAN DEFAULT FALSE
415 ,p_effective_date IN DATE
416 ,p_datetrack_update_mode IN VARCHAR2
417 ,p_assignment_id IN NUMBER
418 ,p_object_version_number IN OUT NOCOPY NUMBER
419 ,p_supervisor_id IN NUMBER DEFAULT HR_API.G_NUMBER
420 ,p_assignment_number IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
421 ,p_change_reason IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
422 ,p_assignment_status_type_id IN NUMBER DEFAULT HR_API.G_NUMBER
423 ,p_comments IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
424 ,p_date_probation_end IN DATE DEFAULT HR_API.G_DATE
425 ,p_default_code_comb_id IN NUMBER DEFAULT HR_API.G_NUMBER
426 ,p_frequency IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
427 ,p_internal_address_line IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
428 ,p_manager_flag IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
429 ,p_normal_hours IN NUMBER DEFAULT HR_API.G_NUMBER
430 ,p_perf_review_period IN NUMBER DEFAULT HR_API.G_NUMBER
431 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
432 ,p_probation_period IN NUMBER DEFAULT HR_API.G_NUMBER
433 ,p_probation_unit IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
434 ,p_sal_review_period IN NUMBER DEFAULT HR_API.G_NUMBER
435 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
436 ,p_set_of_books_id IN NUMBER DEFAULT HR_API.G_NUMBER
437 ,p_source_type IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
438 ,p_time_normal_finish IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
439 ,p_time_normal_start IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
440 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
441 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
442 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
443 ,p_ass_attribute_category IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
444 ,p_ass_attribute1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
445 ,p_ass_attribute2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
446 ,p_ass_attribute3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
447 ,p_ass_attribute4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
448 ,p_ass_attribute5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
449 ,p_ass_attribute6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
450 ,p_ass_attribute7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
451 ,p_ass_attribute8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
452 ,p_ass_attribute9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
453 ,p_ass_attribute10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
454 ,p_ass_attribute11 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
455 ,p_ass_attribute12 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
456 ,p_ass_attribute13 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
457 ,p_ass_attribute14 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
458 ,p_ass_attribute15 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
459 ,p_ass_attribute16 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
460 ,p_ass_attribute17 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
461 ,p_ass_attribute18 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
462 ,p_ass_attribute19 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
463 ,p_ass_attribute20 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
464 ,p_ass_attribute21 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
465 ,p_ass_attribute22 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
466 ,p_ass_attribute23 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
467 ,p_ass_attribute24 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
468 ,p_ass_attribute25 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
469 ,p_ass_attribute26 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
470 ,p_ass_attribute27 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
471 ,p_ass_attribute28 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
472 ,p_ass_attribute29 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
473 ,p_ass_attribute30 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
474 ,p_title IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
475 ,p_gre_legal_entity IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
476 ,p_pf_organization IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
477 ,p_prof_tax_organization IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
478 ,p_esi_organization IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
479 ,p_factory IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
480 ,p_establishment IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
481 ,p_covered_by_gratuity_act IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
482 ,p_having_substantial_interest IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
483 ,p_director IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
484 ,p_specified IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
485 ,p_concat_segments IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
486 ,p_contract_id IN NUMBER DEFAULT HR_API.G_NUMBER
487 ,p_establishment_id IN NUMBER DEFAULT HR_API.G_NUMBER
488 ,p_collective_agreement_id IN NUMBER DEFAULT HR_API.G_NUMBER
489 ,p_cagr_id_flex_num IN NUMBER DEFAULT HR_API.G_NUMBER
490 ,p_cag_segment1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
491 ,p_cag_segment2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
492 ,p_cag_segment3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
493 ,p_cag_segment4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
494 ,p_cag_segment5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
495 ,p_cag_segment6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
496 ,p_cag_segment7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
497 ,p_cag_segment8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
498 ,p_cag_segment9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
499 ,p_cag_segment10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
500 ,p_cag_segment11 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
501 ,p_cag_segment12 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
502 ,p_cag_segment13 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
503 ,p_cag_segment14 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
504 ,p_cag_segment15 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
505 ,p_cag_segment16 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
506 ,p_cag_segment17 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
507 ,p_cag_segment18 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
508 ,p_cag_segment19 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
509 ,p_cag_segment20 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
510 ,p_notice_period IN NUMBER DEFAULT HR_API.G_NUMBER
511 ,p_notice_period_uom IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
512 ,p_employee_category IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
513 ,p_work_at_home IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
514 ,p_job_post_source_name IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
515 ,p_supervisor_assignment_id IN NUMBER DEFAULT HR_API.G_NUMBER
516 ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
517 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
518 ,p_concatenated_segments OUT NOCOPY VARCHAR2
519 ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
520 ,p_comment_id OUT NOCOPY NUMBER
521 ,p_effective_start_date OUT NOCOPY DATE
522 ,p_effective_end_date OUT NOCOPY DATE
523 ,p_no_managers_warning OUT NOCOPY BOOLEAN
524 ,p_other_manager_warning OUT NOCOPY BOOLEAN
525 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
526 ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
527 ) IS
528 --
529 -- Declare variables
530 --
531 l_proc VARCHAR2(72);
532 --
533 BEGIN
534
535 l_proc := g_package||'update_emp_asg';
536 g_trace := hr_utility.debug_enabled ;
537
538 IF g_trace THEN
539 hr_utility.set_location('Entering: '||l_proc, 10);
540 END IF ;
541
542 hr_assignment_api.update_emp_asg
543 (p_validate => p_validate
544 ,p_effective_date => p_effective_date
545 ,p_datetrack_update_mode => p_datetrack_update_mode
546 ,p_assignment_id => p_assignment_id
547 ,p_object_version_number => p_object_version_number
548 ,p_supervisor_id => p_supervisor_id
549 ,p_assignment_number => p_assignment_number
550 ,p_change_reason => p_change_reason
551 ,p_assignment_status_type_id => p_assignment_status_type_id
552 ,p_comments => p_comments
553 ,p_date_probation_end => p_date_probation_end
554 ,p_default_code_comb_id => p_default_code_comb_id
555 ,p_frequency => p_frequency
556 ,p_internal_address_line => p_internal_address_line
557 ,p_manager_flag => p_manager_flag
558 ,p_normal_hours => p_normal_hours
559 ,p_perf_review_period => p_perf_review_period
560 ,p_perf_review_period_frequency => p_perf_review_period_frequency
561 ,p_probation_period => p_probation_period
562 ,p_probation_unit => p_probation_unit
563 ,p_sal_review_period => p_sal_review_period
564 ,p_sal_review_period_frequency => p_sal_review_period_frequency
565 ,p_set_of_books_id => p_set_of_books_id
566 ,p_source_type => p_source_type
567 ,p_time_normal_finish => p_time_normal_finish
568 ,p_time_normal_start => p_time_normal_start
569 ,p_bargaining_unit_code => p_bargaining_unit_code
570 ,p_labour_union_member_flag => p_labour_union_member_flag
571 ,p_hourly_salaried_code => p_hourly_salaried_code
572 ,p_ass_attribute_category => p_ass_attribute_category
573 ,p_ass_attribute1 => p_ass_attribute1
574 ,p_ass_attribute2 => p_ass_attribute2
575 ,p_ass_attribute3 => p_ass_attribute3
576 ,p_ass_attribute4 => p_ass_attribute4
577 ,p_ass_attribute5 => p_ass_attribute5
578 ,p_ass_attribute6 => p_ass_attribute6
579 ,p_ass_attribute7 => p_ass_attribute7
580 ,p_ass_attribute8 => p_ass_attribute8
581 ,p_ass_attribute9 => p_ass_attribute9
582 ,p_ass_attribute10 => p_ass_attribute10
583 ,p_ass_attribute11 => p_ass_attribute11
584 ,p_ass_attribute12 => p_ass_attribute12
585 ,p_ass_attribute13 => p_ass_attribute13
586 ,p_ass_attribute14 => p_ass_attribute14
587 ,p_ass_attribute15 => p_ass_attribute15
588 ,p_ass_attribute16 => p_ass_attribute16
589 ,p_ass_attribute17 => p_ass_attribute17
590 ,p_ass_attribute18 => p_ass_attribute18
591 ,p_ass_attribute19 => p_ass_attribute19
592 ,p_ass_attribute20 => p_ass_attribute20
593 ,p_ass_attribute21 => p_ass_attribute21
594 ,p_ass_attribute22 => p_ass_attribute22
595 ,p_ass_attribute23 => p_ass_attribute23
596 ,p_ass_attribute24 => p_ass_attribute24
597 ,p_ass_attribute25 => p_ass_attribute25
598 ,p_ass_attribute26 => p_ass_attribute26
599 ,p_ass_attribute27 => p_ass_attribute27
600 ,p_ass_attribute28 => p_ass_attribute28
601 ,p_ass_attribute29 => p_ass_attribute29
602 ,p_ass_attribute30 => p_ass_attribute30
603 ,p_title => p_title
604 ,p_segment1 => p_gre_legal_entity
605 ,p_segment2 => p_pf_organization
606 ,p_segment3 => p_prof_tax_organization
607 ,p_segment4 => p_esi_organization
608 ,p_segment5 => p_factory
609 ,p_segment6 => p_establishment
610 ,p_segment8 => p_covered_by_gratuity_act
611 ,p_segment9 => p_having_substantial_interest
612 ,p_segment10 => p_director
613 ,p_segment11 => p_specified
614 ,p_concat_segments => p_concat_segments
615 ,p_contract_id => p_contract_id
616 ,p_establishment_id => p_establishment_id
617 ,p_collective_agreement_id => p_collective_agreement_id
618 ,p_cagr_id_flex_num => p_cagr_id_flex_num
619 ,p_cag_segment1 => p_cag_segment1
620 ,p_cag_segment2 => p_cag_segment2
621 ,p_cag_segment3 => p_cag_segment3
622 ,p_cag_segment4 => p_cag_segment4
623 ,p_cag_segment5 => p_cag_segment5
624 ,p_cag_segment6 => p_cag_segment6
625 ,p_cag_segment7 => p_cag_segment7
626 ,p_cag_segment8 => p_cag_segment8
627 ,p_cag_segment9 => p_cag_segment9
628 ,p_cag_segment10 => p_cag_segment10
629 ,p_cag_segment11 => p_cag_segment11
630 ,p_cag_segment12 => p_cag_segment12
631 ,p_cag_segment13 => p_cag_segment13
632 ,p_cag_segment14 => p_cag_segment14
633 ,p_cag_segment15 => p_cag_segment15
634 ,p_cag_segment16 => p_cag_segment16
635 ,p_cag_segment17 => p_cag_segment17
636 ,p_cag_segment18 => p_cag_segment18
637 ,p_cag_segment19 => p_cag_segment19
638 ,p_cag_segment20 => p_cag_segment20
639 ,p_notice_period => p_notice_period
640 ,p_notice_period_uom => p_notice_period_uom
641 ,p_employee_category => p_employee_category
642 ,p_work_at_home => p_work_at_home
643 ,p_job_post_source_name => p_job_post_source_name
644 ,p_supervisor_assignment_id => p_supervisor_assignment_id
645 ,p_cagr_grade_def_id => p_cagr_grade_def_id
646 ,p_cagr_concatenated_segments => p_cagr_concatenated_segments
647 ,p_concatenated_segments => p_concatenated_segments
648 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
649 ,p_comment_id => p_comment_id
650 ,p_effective_start_date => p_effective_start_date
651 ,p_effective_end_date => p_effective_end_date
652 ,p_no_managers_warning => p_no_managers_warning
653 ,p_other_manager_warning => p_other_manager_warning
654 ,p_hourly_salaried_warning => p_hourly_salaried_warning
655 ,p_gsp_post_process_warning => p_gsp_post_process_warning
656 );
657
658 IF g_trace THEN
659 hr_utility.set_location(l_proc, 20);
660 END IF ;
661
662 END update_in_emp_asg;
663
664 -- ----------------------------------------------------------------------------
665 -- |-----------------------< create_in_secondary_cwk_asg >-------------------------|
666 -- ----------------------------------------------------------------------------
667
668 PROCEDURE create_in_secondary_cwk_asg
669 (p_validate IN BOOLEAN DEFAULT false
670 ,p_effective_date IN DATE
671 ,p_business_group_id IN NUMBER
672 ,p_person_id IN NUMBER
673 ,p_organization_id IN NUMBER
674 ,p_assignment_number IN OUT NOCOPY VARCHAR2
675 ,p_assignment_category IN VARCHAR2 DEFAULT null
676 ,p_assignment_status_type_id IN NUMBER DEFAULT null
677 ,p_change_reason IN VARCHAR2 DEFAULT null
678 ,p_comments IN VARCHAR2 DEFAULT null
679 ,p_default_code_comb_id IN NUMBER DEFAULT null
680 ,p_establishment_id IN NUMBER DEFAULT null
681 ,p_frequency IN VARCHAR2 DEFAULT null
682 ,p_internal_address_line IN VARCHAR2 DEFAULT null
683 ,p_job_id IN NUMBER DEFAULT null
684 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT 'N'
685 ,p_location_id IN NUMBER DEFAULT null
686 ,p_manager_flag IN VARCHAR2 DEFAULT null
687 ,p_normal_hours IN NUMBER DEFAULT null
688 ,p_position_id IN NUMBER DEFAULT null
689 ,p_grade_id IN NUMBER DEFAULT null
690 ,p_project_title IN VARCHAR2 DEFAULT null
691 ,p_set_of_books_id IN NUMBER DEFAULT null
692 ,p_source_type IN VARCHAR2 DEFAULT null
693 ,p_supervisor_id IN NUMBER DEFAULT null
694 ,p_time_normal_finish IN VARCHAR2 DEFAULT null
695 ,p_time_normal_start IN VARCHAR2 DEFAULT null
696 ,p_title IN VARCHAR2 DEFAULT null
697 ,p_vendor_assignment_number IN VARCHAR2 DEFAULT null
698 ,p_vendor_employee_number IN VARCHAR2 DEFAULT null
699 ,p_vendor_id IN NUMBER DEFAULT null
700 ,p_vendor_site_id IN NUMBER DEFAULT null
701 ,p_po_header_id IN NUMBER DEFAULT null
702 ,p_po_line_id IN NUMBER DEFAULT null
703 ,p_projected_assignment_end IN DATE DEFAULT null
704 ,p_attribute_category IN VARCHAR2 DEFAULT null
705 ,p_attribute1 IN VARCHAR2 DEFAULT null
706 ,p_attribute2 IN VARCHAR2 DEFAULT null
707 ,p_attribute3 IN VARCHAR2 DEFAULT null
708 ,p_attribute4 IN VARCHAR2 DEFAULT null
709 ,p_attribute5 IN VARCHAR2 DEFAULT null
710 ,p_attribute6 IN VARCHAR2 DEFAULT null
711 ,p_attribute7 IN VARCHAR2 DEFAULT null
712 ,p_attribute8 IN VARCHAR2 DEFAULT null
713 ,p_attribute9 IN VARCHAR2 DEFAULT null
714 ,p_attribute10 IN VARCHAR2 DEFAULT null
715 ,p_attribute11 IN VARCHAR2 DEFAULT null
716 ,p_attribute12 IN VARCHAR2 DEFAULT null
717 ,p_attribute13 IN VARCHAR2 DEFAULT null
718 ,p_attribute14 IN VARCHAR2 DEFAULT null
719 ,p_attribute15 IN VARCHAR2 DEFAULT null
720 ,p_attribute16 IN VARCHAR2 DEFAULT null
721 ,p_attribute17 IN VARCHAR2 DEFAULT null
722 ,p_attribute18 IN VARCHAR2 DEFAULT null
723 ,p_attribute19 IN VARCHAR2 DEFAULT null
724 ,p_attribute20 IN VARCHAR2 DEFAULT null
725 ,p_attribute21 IN VARCHAR2 DEFAULT null
726 ,p_attribute22 IN VARCHAR2 DEFAULT null
727 ,p_attribute23 IN VARCHAR2 DEFAULT null
728 ,p_attribute24 IN VARCHAR2 DEFAULT null
729 ,p_attribute25 IN VARCHAR2 DEFAULT null
730 ,p_attribute26 IN VARCHAR2 DEFAULT null
731 ,p_attribute27 IN VARCHAR2 DEFAULT null
732 ,p_attribute28 IN VARCHAR2 DEFAULT null
733 ,p_attribute29 IN VARCHAR2 DEFAULT null
734 ,p_attribute30 IN VARCHAR2 DEFAULT null
735 ,p_pgp_segment1 IN VARCHAR2 DEFAULT null
736 ,p_pgp_segment2 IN VARCHAR2 DEFAULT null
737 ,p_pgp_segment3 IN VARCHAR2 DEFAULT null
738 ,p_pgp_segment4 IN VARCHAR2 DEFAULT null
739 ,p_pgp_segment5 IN VARCHAR2 DEFAULT null
740 ,p_pgp_segment6 IN VARCHAR2 DEFAULT null
741 ,p_pgp_segment7 IN VARCHAR2 DEFAULT null
742 ,p_pgp_segment8 IN VARCHAR2 DEFAULT null
743 ,p_pgp_segment9 IN VARCHAR2 DEFAULT null
744 ,p_pgp_segment10 IN VARCHAR2 DEFAULT null
745 ,p_pgp_segment11 IN VARCHAR2 DEFAULT null
746 ,p_pgp_segment12 IN VARCHAR2 DEFAULT null
747 ,p_pgp_segment13 IN VARCHAR2 DEFAULT null
748 ,p_pgp_segment14 IN VARCHAR2 DEFAULT null
749 ,p_pgp_segment15 IN VARCHAR2 DEFAULT null
750 ,p_pgp_segment16 IN VARCHAR2 DEFAULT null
751 ,p_pgp_segment17 IN VARCHAR2 DEFAULT null
752 ,p_pgp_segment18 IN VARCHAR2 DEFAULT null
753 ,p_pgp_segment19 IN VARCHAR2 DEFAULT null
754 ,p_pgp_segment20 IN VARCHAR2 DEFAULT null
755 ,p_pgp_segment21 IN VARCHAR2 DEFAULT null
756 ,p_pgp_segment22 IN VARCHAR2 DEFAULT null
757 ,p_pgp_segment23 IN VARCHAR2 DEFAULT null
758 ,p_pgp_segment24 IN VARCHAR2 DEFAULT null
759 ,p_pgp_segment25 IN VARCHAR2 DEFAULT null
760 ,p_pgp_segment26 IN VARCHAR2 DEFAULT null
761 ,p_pgp_segment27 IN VARCHAR2 DEFAULT null
762 ,p_pgp_segment28 IN VARCHAR2 DEFAULT null
763 ,p_pgp_segment29 IN VARCHAR2 DEFAULT null
764 ,p_pgp_segment30 IN VARCHAR2 DEFAULT null
765 ,p_scl_contractor_name IN VARCHAR2 DEFAULT null
766 ,p_scl_concat_segments IN VARCHAR2 DEFAULT null
767 ,p_pgp_concat_segments IN VARCHAR2 DEFAULT null
768 ,p_supervisor_assignment_id IN NUMBER DEFAULT null
769 ,p_assignment_id OUT NOCOPY NUMBER
770 ,p_object_version_number OUT NOCOPY NUMBER
771 ,p_effective_start_date OUT NOCOPY DATE
772 ,p_effective_end_date OUT NOCOPY DATE
773 ,p_assignment_sequence OUT NOCOPY NUMBER
774 ,p_comment_id OUT NOCOPY NUMBER
775 ,p_people_group_id OUT NOCOPY NUMBER
776 ,p_people_group_name OUT NOCOPY VARCHAR2
777 ,p_other_manager_warning OUT NOCOPY BOOLEAN
778 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
779 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
780 ) IS
781 --
782 -- Declare variables
783 --
784 l_effective_date DATE;
785 l_proc VARCHAR2(72);
786 l_cwk_check NUMBER;
787
788 CURSOR csr_cwk_leg
789 (l_person_id per_people_f.person_id%TYPE,
790 l_effective_date DATE,
791 l_business_group_id per_people_f.business_group_id%TYPE
792 )
793 IS
794 SELECT 1
795 FROM per_people_f
796 WHERE business_group_id = l_business_group_id
797 AND person_id = l_person_id
798 AND l_effective_date between effective_start_date and effective_END_date;
799 BEGIN
800
801 l_proc := g_package||'create_in_secondary_cwk_asg';
802 l_effective_date := trunc(p_effective_date);
803 g_trace := hr_utility.debug_enabled ;
804 l_cwk_check := 0;
805
806 IF g_trace THEN
807 hr_utility.set_location('Entering: '||l_proc, 10);
808 END IF ;
809
810 OPEN csr_cwk_leg(p_person_id, l_effective_date, p_business_group_id);
811 FETCH csr_cwk_leg into l_cwk_check;
812
813 IF l_cwk_check = 0 THEN
814 CLOSE csr_cwk_leg;
815 hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
816 hr_utility.raise_error;
817 END IF;
818 CLOSE csr_cwk_leg;
819
820 IF g_trace THEN
821 hr_utility.set_location(l_proc, 20);
822 END IF ;
823
824 hr_assignment_api.create_secondary_cwk_asg
825 ( p_validate => p_validate
826 ,p_effective_date => p_effective_date
827 ,p_business_group_id => p_business_group_id
828 ,p_person_id => p_person_id
829 ,p_organization_id => p_organization_id
830 ,p_assignment_number => p_assignment_number
831 ,p_assignment_category => p_assignment_category
832 ,p_assignment_status_type_id => p_assignment_status_type_id
833 ,p_change_reason => p_change_reason
834 ,p_comments => p_comments
835 ,p_default_code_comb_id => p_default_code_comb_id
836 ,p_establishment_id => p_establishment_id
837 ,p_frequency => p_frequency
838 ,p_internal_address_line => p_internal_address_line
839 ,p_job_id => p_job_id
840 ,p_labour_union_member_flag => p_labour_union_member_flag
841 ,p_location_id => p_location_id
842 ,p_manager_flag => p_manager_flag
843 ,p_normal_hours => p_normal_hours
844 ,p_position_id => p_position_id
845 ,p_grade_id => p_grade_id
846 ,p_project_title => p_project_title
847 ,p_set_of_books_id => p_set_of_books_id
848 ,p_source_type => p_source_type
849 ,p_supervisor_id => p_supervisor_id
850 ,p_time_normal_finish => p_time_normal_finish
851 ,p_time_normal_start => p_time_normal_start
852 ,p_title => p_title
853 ,p_vendor_assignment_number => p_vendor_assignment_number
854 ,p_vendor_employee_number => p_vendor_employee_number
855 ,p_vendor_id => p_vendor_id
856 ,p_vendor_site_id => p_vendor_site_id
857 ,p_po_header_id => p_po_header_id
858 ,p_po_line_id => p_po_line_id
859 ,p_projected_assignment_end => p_projected_assignment_end
860 ,p_attribute_category => p_attribute_category
861 ,p_attribute1 => p_attribute1
862 ,p_attribute2 => p_attribute2
863 ,p_attribute3 => p_attribute3
864 ,p_attribute4 => p_attribute4
865 ,p_attribute5 => p_attribute5
866 ,p_attribute6 => p_attribute6
867 ,p_attribute7 => p_attribute7
868 ,p_attribute8 => p_attribute8
869 ,p_attribute9 => p_attribute9
870 ,p_attribute10 => p_attribute10
871 ,p_attribute11 => p_attribute11
872 ,p_attribute12 => p_attribute12
873 ,p_attribute13 => p_attribute13
874 ,p_attribute14 => p_attribute14
875 ,p_attribute15 => p_attribute15
876 ,p_attribute16 => p_attribute16
877 ,p_attribute17 => p_attribute17
878 ,p_attribute18 => p_attribute18
879 ,p_attribute19 => p_attribute19
880 ,p_attribute20 => p_attribute20
881 ,p_attribute21 => p_attribute21
882 ,p_attribute22 => p_attribute22
883 ,p_attribute23 => p_attribute23
884 ,p_attribute24 => p_attribute24
885 ,p_attribute25 => p_attribute25
886 ,p_attribute26 => p_attribute26
887 ,p_attribute27 => p_attribute27
888 ,p_attribute28 => p_attribute28
889 ,p_attribute29 => p_attribute29
890 ,p_attribute30 => p_attribute30
891 ,p_pgp_segment1 => p_pgp_segment1
892 ,p_pgp_segment2 => p_pgp_segment2
893 ,p_pgp_segment3 => p_pgp_segment3
894 ,p_pgp_segment4 => p_pgp_segment4
895 ,p_pgp_segment5 => p_pgp_segment5
896 ,p_pgp_segment6 => p_pgp_segment6
897 ,p_pgp_segment7 => p_pgp_segment7
898 ,p_pgp_segment8 => p_pgp_segment8
899 ,p_pgp_segment9 => p_pgp_segment9
900 ,p_pgp_segment10 => p_pgp_segment10
901 ,p_pgp_segment11 => p_pgp_segment11
902 ,p_pgp_segment12 => p_pgp_segment12
903 ,p_pgp_segment13 => p_pgp_segment13
904 ,p_pgp_segment14 => p_pgp_segment14
905 ,p_pgp_segment15 => p_pgp_segment15
906 ,p_pgp_segment16 => p_pgp_segment16
907 ,p_pgp_segment17 => p_pgp_segment17
908 ,p_pgp_segment18 => p_pgp_segment18
909 ,p_pgp_segment19 => p_pgp_segment19
910 ,p_pgp_segment20 => p_pgp_segment20
911 ,p_pgp_segment21 => p_pgp_segment21
912 ,p_pgp_segment22 => p_pgp_segment22
913 ,p_pgp_segment23 => p_pgp_segment23
914 ,p_pgp_segment24 => p_pgp_segment24
915 ,p_pgp_segment25 => p_pgp_segment25
916 ,p_pgp_segment26 => p_pgp_segment26
917 ,p_pgp_segment27 => p_pgp_segment27
918 ,p_pgp_segment28 => p_pgp_segment28
919 ,p_pgp_segment29 => p_pgp_segment29
920 ,p_pgp_segment30 => p_pgp_segment30
921 ,p_scl_segment1 => p_scl_contractor_name
922 ,p_scl_concat_segments => p_scl_concat_segments
923 ,p_pgp_concat_segments => p_pgp_concat_segments
924 ,p_supervisor_assignment_id => p_supervisor_assignment_id
925 ,p_assignment_id => p_assignment_id
926 ,p_object_version_number => p_object_version_number
927 ,p_effective_start_date => p_effective_start_date
928 ,p_effective_end_date => p_effective_end_date
929 ,p_assignment_sequence => p_assignment_sequence
930 ,p_comment_id => p_comment_id
931 ,p_people_group_id => p_people_group_id
932 ,p_people_group_name => p_people_group_name
933 ,p_other_manager_warning => p_other_manager_warning
934 ,p_hourly_salaried_warning => p_hourly_salaried_warning
935 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id );
936
937 IF g_trace THEN
938 hr_utility.set_location('Leaving: '||l_proc, 30);
939 END IF ;
940
941 END create_in_secondary_cwk_asg;
942
943 -- ----------------------------------------------------------------------------
944 -- |--------------------------< update_in_cwk_asg >------------------------------|
945 -- ----------------------------------------------------------------------------
946
947 PROCEDURE update_in_cwk_asg
948 (p_validate IN BOOLEAN DEFAULT FALSE
949 ,p_effective_date IN DATE
950 ,p_datetrack_update_mode IN VARCHAR2
951 ,p_assignment_id IN NUMBER
952 ,p_object_version_number IN OUT NOCOPY NUMBER
953 ,p_assignment_category IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
954 ,p_assignment_number IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
955 ,p_change_reason IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
956 ,p_comments IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
957 ,p_default_code_comb_id IN NUMBER DEFAULT HR_API.G_NUMBER
958 ,p_establishment_id IN NUMBER DEFAULT HR_API.G_NUMBER
959 ,p_frequency IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
960 ,p_internal_address_line IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
961 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
962 ,p_manager_flag IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
963 ,p_normal_hours IN NUMBER DEFAULT HR_API.G_NUMBER
964 ,p_project_title IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
965 ,p_set_of_books_id IN NUMBER DEFAULT HR_API.G_NUMBER
966 ,p_source_type IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
967 ,p_supervisor_id IN NUMBER DEFAULT HR_API.G_NUMBER
968 ,p_time_normal_finish IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
969 ,p_time_normal_start IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
970 ,p_title IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
971 ,p_vendor_assignment_number IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
972 ,p_vendor_employee_number IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
973 ,p_vendor_id IN NUMBER DEFAULT HR_API.G_NUMBER
974 ,p_vendor_site_id IN NUMBER DEFAULT HR_API.G_NUMBER
975 ,p_po_header_id IN NUMBER DEFAULT HR_API.G_NUMBER
976 ,p_po_line_id IN NUMBER DEFAULT HR_API.G_NUMBER
977 ,p_projected_assignment_end IN DATE DEFAULT HR_API.G_DATE
978 ,p_assignment_status_type_id IN NUMBER DEFAULT HR_API.G_NUMBER
979 ,p_concat_segments IN VARCHAR2 DEFAULT NULL
980 ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
981 ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
982 ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
983 ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
984 ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
985 ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
986 ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
987 ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
988 ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
989 ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
990 ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
991 ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
992 ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
993 ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
994 ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
995 ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
996 ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
997 ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
998 ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
999 ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1000 ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1001 ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1002 ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1003 ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1004 ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1005 ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1006 ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1007 ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1008 ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1009 ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1010 ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1011 ,p_scl_contractor_name IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
1012 ,p_supervisor_assignment_id IN NUMBER DEFAULT HR_API.G_NUMBER
1013 ,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
1014 ,p_effective_start_date OUT NOCOPY DATE
1015 ,p_effective_end_date OUT NOCOPY DATE
1016 ,p_comment_id OUT NOCOPY NUMBER
1017 ,p_no_managers_warning OUT NOCOPY BOOLEAN
1018 ,p_other_manager_warning OUT NOCOPY BOOLEAN
1019 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
1020 ,p_concatenated_segments OUT NOCOPY VARCHAR2
1021 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
1022 ) IS
1023 --
1024 -- Declare cursors and local variables
1025 --
1026 l_proc VARCHAR2(72);
1027
1028 BEGIN
1029
1030 l_proc := g_package||'update_cwk_asg';
1031 g_trace := hr_utility.debug_enabled ;
1032
1033 IF g_trace THEN
1034 hr_utility.set_location('Entering: '||l_proc, 10);
1035 END IF ;
1036
1037 hr_assignment_api.update_cwk_asg
1038 (p_validate => p_validate
1039 ,p_effective_date => p_effective_date
1040 ,p_datetrack_update_mode => p_datetrack_update_mode
1041 ,p_assignment_id => p_assignment_id
1042 ,p_object_version_number => p_object_version_number
1043 ,p_assignment_category => p_assignment_category
1044 ,p_assignment_number => p_assignment_number
1045 ,p_change_reason => p_change_reason
1046 ,p_comments => p_comments
1047 ,p_default_code_comb_id => p_default_code_comb_id
1048 ,p_establishment_id => p_establishment_id
1049 ,p_frequency => p_frequency
1050 ,p_internal_address_line => p_internal_address_line
1051 ,p_labour_union_member_flag => p_labour_union_member_flag
1052 ,p_manager_flag => p_manager_flag
1053 ,p_normal_hours => p_normal_hours
1054 ,p_project_title => p_project_title
1055 ,p_set_of_books_id => p_set_of_books_id
1056 ,p_source_type => p_source_type
1057 ,p_supervisor_id => p_supervisor_id
1058 ,p_time_normal_finish => p_time_normal_finish
1059 ,p_time_normal_start => p_time_normal_start
1060 ,p_title => p_title
1061 ,p_vendor_assignment_number => p_vendor_assignment_number
1062 ,p_vendor_employee_number => p_vendor_employee_number
1063 ,p_vendor_id => p_vendor_id
1064 ,p_vendor_site_id => p_vendor_site_id
1065 ,p_po_header_id => p_po_header_id
1066 ,p_po_line_id => p_po_line_id
1067 ,p_projected_assignment_end => p_projected_assignment_end
1068 ,p_assignment_status_type_id => p_assignment_status_type_id
1069 ,p_concat_segments => p_concat_segments
1070 ,p_attribute_category => p_attribute_category
1071 ,p_attribute1 => p_attribute1
1072 ,p_attribute2 => p_attribute2
1073 ,p_attribute3 => p_attribute3
1074 ,p_attribute4 => p_attribute4
1075 ,p_attribute5 => p_attribute5
1076 ,p_attribute6 => p_attribute6
1077 ,p_attribute7 => p_attribute7
1078 ,p_attribute8 => p_attribute8
1079 ,p_attribute9 => p_attribute9
1080 ,p_attribute10 => p_attribute10
1081 ,p_attribute11 => p_attribute11
1082 ,p_attribute12 => p_attribute12
1083 ,p_attribute13 => p_attribute13
1084 ,p_attribute14 => p_attribute14
1085 ,p_attribute15 => p_attribute15
1086 ,p_attribute16 => p_attribute16
1087 ,p_attribute17 => p_attribute17
1088 ,p_attribute18 => p_attribute18
1089 ,p_attribute19 => p_attribute19
1090 ,p_attribute20 => p_attribute20
1091 ,p_attribute21 => p_attribute21
1092 ,p_attribute22 => p_attribute22
1093 ,p_attribute23 => p_attribute23
1094 ,p_attribute24 => p_attribute24
1095 ,p_attribute25 => p_attribute25
1096 ,p_attribute26 => p_attribute26
1097 ,p_attribute27 => p_attribute27
1098 ,p_attribute28 => p_attribute28
1099 ,p_attribute29 => p_attribute29
1100 ,p_attribute30 => p_attribute30
1101 ,p_scl_segment1 => p_scl_contractor_name
1102 ,p_supervisor_assignment_id => p_supervisor_assignment_id
1103 ,p_org_now_no_manager_warning=> p_org_now_no_manager_warning
1104 ,p_effective_start_date => p_effective_start_date
1105 ,p_effective_end_date => p_effective_end_date
1106 ,p_comment_id => p_comment_id
1107 ,p_no_managers_warning => p_no_managers_warning
1108 ,p_other_manager_warning => p_other_manager_warning
1109 ,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
1110 ,p_concatenated_segments => p_concatenated_segments
1111 ,p_hourly_salaried_warning => p_hourly_salaried_warning );
1112
1113 IF g_trace THEN
1114 hr_utility.set_location('Entering: '||l_proc, 20);
1115 END IF ;
1116
1117 END update_in_cwk_asg;
1118
1119 END hr_in_assignment_api;