1 Package hr_assignment_swi As
2 /* $Header: hrasgswi.pkh 120.0.12010000.1 2008/07/28 03:04:18 appldev ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< accept_apl_asg >----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: hr_assignment_api.accept_apl_asg
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE accept_apl_asg
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_datetrack_update_mode in varchar2
30 ,p_assignment_id in number
31 ,p_object_version_number in out nocopy number
32 ,p_assignment_status_type_id in number default hr_api.g_number
33 ,p_change_reason in varchar2 default hr_api.g_varchar2
34 ,p_effective_start_date out nocopy date
35 ,p_effective_end_date out nocopy date
36 ,p_return_status out nocopy varchar2
37 );
38 -- ----------------------------------------------------------------------------
39 -- |---------------------------< activate_apl_asg >---------------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start of comments}
42 --
43 -- Description:
44 -- This procedure is the self-service wrapper procedure to the following
45 -- API: hr_assignment_api.activate_apl_asg
46 --
47 -- Pre-requisites
48 -- All 'IN' parameters to this procedure have been appropriately derived.
49 --
50 -- Post Success:
51 -- p_return_status will return value indicating success.
52 --
53 -- Post Failure:
54 -- p_return_status will return value indication failure.
55 --
56 -- Access Status:
57 -- Internal Development use only.
58 --
59 -- {End of comments}
60 -- ----------------------------------------------------------------------------
61 PROCEDURE activate_apl_asg
62 (p_validate in number default hr_api.g_false_num
63 ,p_effective_date in date
64 ,p_datetrack_update_mode in varchar2
65 ,p_assignment_id in number
66 ,p_object_version_number in out nocopy number
67 ,p_assignment_status_type_id in number default hr_api.g_number
68 ,p_change_reason in varchar2 default hr_api.g_varchar2
69 ,p_effective_start_date out nocopy date
70 ,p_effective_end_date out nocopy date
71 ,p_return_status out nocopy varchar2
72 );
73 -- ----------------------------------------------------------------------------
74 -- |-----------------------< create_secondary_apl_asg >-----------------------|
75 -- ----------------------------------------------------------------------------
76 -- {Start of comments}
77 --
78 -- Description:
79 -- This procedure is the self-service wrapper procedure to the following
80 -- API: hr_assignment_api.create_secondary_apl_asg
81 --
82 -- Pre-requisites
83 -- All 'IN' parameters to this procedure have been appropriately derived.
84 --
85 -- Post Success:
86 -- p_return_status will return value indicating success.
87 --
88 -- Post Failure:
89 -- p_return_status will return value indication failure.
90 --
91 -- Access Status:
92 -- Internal Development use only.
93 --
94 -- {End of comments}
95 -- ----------------------------------------------------------------------------
96 PROCEDURE create_secondary_apl_asg
97 (p_validate in number default hr_api.g_false_num
98 ,p_effective_date in date
99 ,p_person_id in number
100 ,p_organization_id in number
101 ,p_recruiter_id in number default null
102 ,p_grade_id in number default null
103 ,p_position_id in number default null
104 ,p_job_id in number default null
105 ,p_assignment_status_type_id in number default null
106 ,p_payroll_id in number default null
107 ,p_location_id in number default null
108 ,p_person_referred_by_id in number default null
109 ,p_supervisor_id in number default null
110 ,p_special_ceiling_step_id in number default null
111 ,p_recruitment_activity_id in number default null
112 ,p_source_organization_id in number default null
113 ,p_vacancy_id in number default null
114 ,p_pay_basis_id in number default null
115 ,p_change_reason in varchar2 default null
116 ,p_comments in varchar2 default null
117 ,p_date_probation_end in date default null
118 ,p_default_code_comb_id in number default null
119 ,p_employment_category in varchar2 default null
120 ,p_frequency in varchar2 default null
121 ,p_internal_address_line in varchar2 default null
122 ,p_manager_flag in varchar2 default null
123 ,p_normal_hours in number default null
124 ,p_perf_review_period in number default null
125 ,p_perf_review_period_frequency in varchar2 default null
126 ,p_probation_period in number default null
127 ,p_probation_unit in varchar2 default null
128 ,p_sal_review_period in number default null
129 ,p_sal_review_period_frequency in varchar2 default null
130 ,p_set_of_books_id in number default null
131 ,p_source_type in varchar2 default null
132 ,p_time_normal_finish in varchar2 default null
133 ,p_time_normal_start in varchar2 default null
134 ,p_bargaining_unit_code in varchar2 default null
135 ,p_ass_attribute_category in varchar2 default null
136 ,p_ass_attribute1 in varchar2 default null
137 ,p_ass_attribute2 in varchar2 default null
138 ,p_ass_attribute3 in varchar2 default null
139 ,p_ass_attribute4 in varchar2 default null
140 ,p_ass_attribute5 in varchar2 default null
141 ,p_ass_attribute6 in varchar2 default null
142 ,p_ass_attribute7 in varchar2 default null
143 ,p_ass_attribute8 in varchar2 default null
144 ,p_ass_attribute9 in varchar2 default null
145 ,p_ass_attribute10 in varchar2 default null
146 ,p_ass_attribute11 in varchar2 default null
147 ,p_ass_attribute12 in varchar2 default null
148 ,p_ass_attribute13 in varchar2 default null
149 ,p_ass_attribute14 in varchar2 default null
150 ,p_ass_attribute15 in varchar2 default null
151 ,p_ass_attribute16 in varchar2 default null
152 ,p_ass_attribute17 in varchar2 default null
153 ,p_ass_attribute18 in varchar2 default null
154 ,p_ass_attribute19 in varchar2 default null
155 ,p_ass_attribute20 in varchar2 default null
156 ,p_ass_attribute21 in varchar2 default null
157 ,p_ass_attribute22 in varchar2 default null
158 ,p_ass_attribute23 in varchar2 default null
159 ,p_ass_attribute24 in varchar2 default null
160 ,p_ass_attribute25 in varchar2 default null
161 ,p_ass_attribute26 in varchar2 default null
162 ,p_ass_attribute27 in varchar2 default null
163 ,p_ass_attribute28 in varchar2 default null
164 ,p_ass_attribute29 in varchar2 default null
165 ,p_ass_attribute30 in varchar2 default null
166 ,p_title in varchar2 default null
167 ,p_concatenated_segments out nocopy varchar2
168 ,p_contract_id in number default null
169 ,p_establishment_id in number default null
170 ,p_collective_agreement_id in number default null
171 ,p_notice_period in number default null
172 ,p_notice_period_uom in varchar2 default null
173 ,p_employee_category in varchar2 default null
174 ,p_work_at_home in varchar2 default null
175 ,p_job_post_source_name in varchar2 default null
176 ,p_applicant_rank in number default null
177 ,p_posting_content_id in number default null
178 ,p_cagr_grade_def_id in out nocopy number
179 ,p_cagr_concatenated_segments out nocopy varchar2
180 ,p_group_name out nocopy varchar2
181 ,p_assignment_id in number
182 ,p_people_group_id in out nocopy number
183 ,p_soft_coding_keyflex_id in out nocopy number
184 ,p_comment_id out nocopy number
185 ,p_object_version_number out nocopy number
186 ,p_effective_start_date out nocopy date
187 ,p_effective_end_date out nocopy date
188 ,p_assignment_sequence out nocopy number
189 ,p_return_status out nocopy varchar2
190 );
191 -- ----------------------------------------------------------------------------
192 -- |-----------------------------< offer_apl_asg >----------------------------|
193 -- ----------------------------------------------------------------------------
194 -- {Start of comments}
195 --
196 -- Description:
197 -- This procedure is the self-service wrapper procedure to the following
198 -- API: hr_assignment_api.offer_apl_asg
199 --
200 -- Pre-requisites
201 -- All 'IN' parameters to this procedure have been appropriately derived.
202 --
203 -- Post Success:
204 -- p_return_status will return value indicating success.
205 --
206 -- Post Failure:
207 -- p_return_status will return value indication failure.
208 --
209 -- Access Status:
210 -- Internal Development use only.
211 --
212 -- {End of comments}
213 -- ----------------------------------------------------------------------------
214 PROCEDURE offer_apl_asg
215 (p_validate in number default hr_api.g_false_num
216 ,p_effective_date in date
217 ,p_datetrack_update_mode in varchar2
218 ,p_assignment_id in number
219 ,p_object_version_number in out nocopy number
220 ,p_assignment_status_type_id in number default hr_api.g_number
221 ,p_change_reason in varchar2 default hr_api.g_varchar2
222 ,p_effective_start_date out nocopy date
223 ,p_effective_end_date out nocopy date
224 ,p_return_status out nocopy varchar2
225 );
226 -- ----------------------------------------------------------------------------
227 -- |---------------------------< terminate_apl_asg >--------------------------|
228 -- ----------------------------------------------------------------------------
229 -- {Start of comments}
230 --
231 -- Description:
232 -- This procedure is the self-service wrapper procedure to the following
233 -- API: hr_assignment_api.terminate_apl_asg
234 --
235 -- Pre-requisites
236 -- All 'IN' parameters to this procedure have been appropriately derived.
237 --
238 -- Post Success:
239 -- p_return_status will return value indicating success.
240 --
241 -- Post Failure:
242 -- p_return_status will return value indication failure.
243 --
244 -- Access Status:
245 -- Internal Development use only.
246 --
247 -- {End of comments}
248 -- ----------------------------------------------------------------------------
249 PROCEDURE terminate_apl_asg
250 (p_validate in number default hr_api.g_false_num
251 ,p_effective_date in date
252 ,p_assignment_id in number
253 ,p_object_version_number in out nocopy number
254 ,p_effective_start_date out nocopy date
255 ,p_effective_end_date out nocopy date
256 ,p_return_status out nocopy varchar2
257 );
258 -- ----------------------------------------------------------------------------
259 -- |----------------------------< update_apl_asg >----------------------------|
260 -- ----------------------------------------------------------------------------
261 -- {Start of comments}
262 --
263 -- Description:
264 -- This procedure is the self-service wrapper procedure to the following
265 -- API: hr_assignment_api.update_apl_asg
266 --
267 -- Pre-requisites
268 -- All 'IN' parameters to this procedure have been appropriately derived.
269 --
270 -- Post Success:
271 -- p_return_status will return value indicating success.
272 --
273 -- Post Failure:
274 -- p_return_status will return value indication failure.
275 --
276 -- Access Status:
277 -- Internal Development use only.
278 --
279 -- {End of comments}
280 -- ----------------------------------------------------------------------------
281 PROCEDURE update_apl_asg
282 (p_validate in number default hr_api.g_false_num
283 ,p_effective_date in date
284 ,p_datetrack_update_mode in varchar2
285 ,p_assignment_id in number
286 ,p_object_version_number in out nocopy number
287 ,p_recruiter_id in number default hr_api.g_number
288 ,p_grade_id in number default hr_api.g_number
289 ,p_position_id in number default hr_api.g_number
290 ,p_job_id in number default hr_api.g_number
291 ,p_payroll_id in number default hr_api.g_number
292 ,p_location_id in number default hr_api.g_number
293 ,p_person_referred_by_id in number default hr_api.g_number
294 ,p_supervisor_id in number default hr_api.g_number
295 ,p_special_ceiling_step_id in number default hr_api.g_number
296 ,p_recruitment_activity_id in number default hr_api.g_number
297 ,p_source_organization_id in number default hr_api.g_number
298 ,p_organization_id in number default hr_api.g_number
299 ,p_vacancy_id in number default hr_api.g_number
300 ,p_pay_basis_id in number default hr_api.g_number
301 ,p_application_id in number default hr_api.g_number
302 ,p_change_reason in varchar2 default hr_api.g_varchar2
303 ,p_assignment_status_type_id in number default hr_api.g_number
304 ,p_comments in varchar2 default hr_api.g_varchar2
305 ,p_date_probation_end in date default hr_api.g_date
306 ,p_default_code_comb_id in number default hr_api.g_number
307 ,p_employment_category in varchar2 default hr_api.g_varchar2
308 ,p_frequency in varchar2 default hr_api.g_varchar2
309 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
310 ,p_manager_flag in varchar2 default hr_api.g_varchar2
311 ,p_normal_hours in number default hr_api.g_number
312 ,p_perf_review_period in number default hr_api.g_number
313 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
314 ,p_probation_period in number default hr_api.g_number
315 ,p_probation_unit in varchar2 default hr_api.g_varchar2
316 ,p_sal_review_period in number default hr_api.g_number
317 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
318 ,p_set_of_books_id in number default hr_api.g_number
319 ,p_source_type in varchar2 default hr_api.g_varchar2
320 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
321 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
322 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
323 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
324 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
325 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
326 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
327 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
328 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
329 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
330 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
331 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
332 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
333 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
334 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
335 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
336 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
337 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
338 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
339 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
340 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
341 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
342 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
343 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
344 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
345 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
346 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
347 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
348 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
349 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
350 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
351 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
352 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
353 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
354 ,p_title in varchar2 default hr_api.g_varchar2
355 ,p_concatenated_segments out nocopy varchar2
356 ,p_contract_id in number default hr_api.g_number
357 ,p_establishment_id in number default hr_api.g_number
358 ,p_collective_agreement_id in number default hr_api.g_number
359 ,p_notice_period in number default hr_api.g_number
360 ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
361 ,p_employee_category in varchar2 default hr_api.g_varchar2
362 ,p_work_at_home in varchar2 default hr_api.g_varchar2
363 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
364 ,p_posting_content_id in number default hr_api.g_number
365 ,p_applicant_rank in number default hr_api.g_number
366 ,p_cagr_grade_def_id in out nocopy number
367 ,p_cagr_concatenated_segments out nocopy varchar2
368 ,p_group_name out nocopy varchar2
369 ,p_comment_id out nocopy number
370 ,p_people_group_id in out nocopy number
371 ,p_soft_coding_keyflex_id in out nocopy number
372 ,p_effective_start_date out nocopy date
373 ,p_effective_end_date out nocopy date
374 ,p_return_status out nocopy varchar2
375 );
376 -- ----------------------------------------------------------------------------
377 -- |----------------------------< update_emp_asg >----------------------------|
378 -- ----------------------------------------------------------------------------
379 -- {Start of comments}
380 --
381 -- Description:
382 -- This procedure is the self-service wrapper procedure to the following
383 -- API: hr_assignment_api.update_emp_asg
384 --
385 -- Pre-requisites
386 -- All 'IN' parameters to this procedure have been appropriately derived.
387 --
388 -- Post Success:
389 -- p_return_status will return value indicating success.
390 --
391 -- Post Failure:
392 -- p_return_status will return value indication failure.
393 --
394 -- Access Status:
395 -- Internal Development use only.
396 --
397 -- {End of comments}
398 -- ----------------------------------------------------------------------------
399 PROCEDURE update_emp_asg
400 (p_validate in number default hr_api.g_false_num
401 ,p_effective_date in date
402 ,p_datetrack_update_mode in varchar2
403 ,p_assignment_id in number
404 ,p_object_version_number in out nocopy number
405 ,p_supervisor_id in number default hr_api.g_number
406 ,p_assignment_number in varchar2 default hr_api.g_varchar2
407 ,p_change_reason in varchar2 default hr_api.g_varchar2
408 ,p_assignment_status_type_id in number default hr_api.g_number
409 ,p_comments in varchar2 default hr_api.g_varchar2
410 ,p_date_probation_end in date default hr_api.g_date
411 ,p_default_code_comb_id in number default hr_api.g_number
412 ,p_frequency in varchar2 default hr_api.g_varchar2
413 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
414 ,p_manager_flag in varchar2 default hr_api.g_varchar2
415 ,p_normal_hours in number default hr_api.g_number
416 ,p_perf_review_period in number default hr_api.g_number
417 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
418 ,p_probation_period in number default hr_api.g_number
419 ,p_probation_unit in varchar2 default hr_api.g_varchar2
420 ,p_sal_review_period in number default hr_api.g_number
421 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
422 ,p_set_of_books_id in number default hr_api.g_number
423 ,p_source_type in varchar2 default hr_api.g_varchar2
424 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
425 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
426 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
427 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
428 ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
429 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
430 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
431 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
432 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
433 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
434 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
435 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
436 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
437 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
438 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
439 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
440 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
441 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
442 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
443 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
444 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
445 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
446 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
447 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
448 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
449 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
450 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
451 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
452 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
453 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
454 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
455 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
456 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
457 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
458 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
459 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
460 ,p_title in varchar2 default hr_api.g_varchar2
461 ,p_segment1 in varchar2 default hr_api.g_varchar2
462 ,p_segment2 in varchar2 default hr_api.g_varchar2
463 ,p_segment3 in varchar2 default hr_api.g_varchar2
464 ,p_segment4 in varchar2 default hr_api.g_varchar2
465 ,p_segment5 in varchar2 default hr_api.g_varchar2
466 ,p_segment6 in varchar2 default hr_api.g_varchar2
467 ,p_segment7 in varchar2 default hr_api.g_varchar2
468 ,p_segment8 in varchar2 default hr_api.g_varchar2
469 ,p_segment9 in varchar2 default hr_api.g_varchar2
470 ,p_segment10 in varchar2 default hr_api.g_varchar2
471 ,p_segment11 in varchar2 default hr_api.g_varchar2
472 ,p_segment12 in varchar2 default hr_api.g_varchar2
473 ,p_segment13 in varchar2 default hr_api.g_varchar2
474 ,p_segment14 in varchar2 default hr_api.g_varchar2
475 ,p_segment15 in varchar2 default hr_api.g_varchar2
476 ,p_segment16 in varchar2 default hr_api.g_varchar2
477 ,p_segment17 in varchar2 default hr_api.g_varchar2
478 ,p_segment18 in varchar2 default hr_api.g_varchar2
479 ,p_segment19 in varchar2 default hr_api.g_varchar2
480 ,p_segment20 in varchar2 default hr_api.g_varchar2
481 ,p_segment21 in varchar2 default hr_api.g_varchar2
482 ,p_segment22 in varchar2 default hr_api.g_varchar2
483 ,p_segment23 in varchar2 default hr_api.g_varchar2
484 ,p_segment24 in varchar2 default hr_api.g_varchar2
485 ,p_segment25 in varchar2 default hr_api.g_varchar2
486 ,p_segment26 in varchar2 default hr_api.g_varchar2
487 ,p_segment27 in varchar2 default hr_api.g_varchar2
488 ,p_segment28 in varchar2 default hr_api.g_varchar2
489 ,p_segment29 in varchar2 default hr_api.g_varchar2
490 ,p_segment30 in varchar2 default hr_api.g_varchar2
491 ,p_concat_segments in varchar2 default hr_api.g_varchar2
492 ,p_contract_id in number default hr_api.g_number
493 ,p_establishment_id in number default hr_api.g_number
494 ,p_collective_agreement_id in number default hr_api.g_number
495 ,p_cagr_id_flex_num in number default hr_api.g_number
496 ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
497 ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
498 ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
499 ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
500 ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
501 ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
502 ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
503 ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
504 ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
505 ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
506 ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
507 ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
508 ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
509 ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
510 ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
511 ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
512 ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
513 ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
514 ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
515 ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
516 ,p_notice_period in number default hr_api.g_number
517 ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
518 ,p_employee_category in varchar2 default hr_api.g_varchar2
519 ,p_work_at_home in varchar2 default hr_api.g_varchar2
520 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
521 ,p_cagr_grade_def_id out nocopy number
522 ,p_cagr_concatenated_segments out nocopy varchar2
523 ,p_concatenated_segments out nocopy varchar2
524 ,p_soft_coding_keyflex_id out nocopy number
525 ,p_comment_id out nocopy number
526 ,p_effective_start_date out nocopy date
527 ,p_effective_end_date out nocopy date
528 ,p_return_status out nocopy varchar2
529 );
530 --
531 --
532
533 -- ----------------------------------------------------------------------------
534 -- |------------------------< update_emp_asg_criteria >-----------------------|
535 -- ----------------------------------------------------------------------------
536 -- {Start of comments}
537 --
538 -- Description:
539 -- This procedure is the self-service wrapper procedure to the following
540 -- API: hr_assignment_api.update_emp_asg_criteria
541 --
542 -- Pre-requisites
543 -- All 'IN' parameters to this procedure have been appropriately derived.
544 --
545 -- Post Success:
546 -- p_return_status will return value indicating success.
547 --
548 -- Post Failure:
549 -- p_return_status will return value indication failure.
550 --
551 -- Access Status:
552 -- Internal Development use only.
553 --
554 -- {End of comments}
555 -- ----------------------------------------------------------------------------
556 PROCEDURE update_emp_asg_criteria
557 (p_validate in number default hr_api.g_false_num
558 ,p_effective_date in date
559 ,p_datetrack_update_mode in varchar2
560 ,p_assignment_id in number
561 ,p_object_version_number in out nocopy number
562 ,p_grade_id in number default hr_api.g_number
563 ,p_position_id in number default hr_api.g_number
564 ,p_job_id in number default hr_api.g_number
565 ,p_payroll_id in number default hr_api.g_number
566 ,p_location_id in number default hr_api.g_number
567 ,p_special_ceiling_step_id in out nocopy number
568 ,p_organization_id in number default hr_api.g_number
569 ,p_pay_basis_id in number default hr_api.g_number
570 ,p_segment1 in varchar2 default hr_api.g_varchar2
571 ,p_segment2 in varchar2 default hr_api.g_varchar2
572 ,p_segment3 in varchar2 default hr_api.g_varchar2
573 ,p_segment4 in varchar2 default hr_api.g_varchar2
574 ,p_segment5 in varchar2 default hr_api.g_varchar2
575 ,p_segment6 in varchar2 default hr_api.g_varchar2
576 ,p_segment7 in varchar2 default hr_api.g_varchar2
577 ,p_segment8 in varchar2 default hr_api.g_varchar2
578 ,p_segment9 in varchar2 default hr_api.g_varchar2
579 ,p_segment10 in varchar2 default hr_api.g_varchar2
580 ,p_segment11 in varchar2 default hr_api.g_varchar2
581 ,p_segment12 in varchar2 default hr_api.g_varchar2
582 ,p_segment13 in varchar2 default hr_api.g_varchar2
583 ,p_segment14 in varchar2 default hr_api.g_varchar2
584 ,p_segment15 in varchar2 default hr_api.g_varchar2
585 ,p_segment16 in varchar2 default hr_api.g_varchar2
586 ,p_segment17 in varchar2 default hr_api.g_varchar2
587 ,p_segment18 in varchar2 default hr_api.g_varchar2
588 ,p_segment19 in varchar2 default hr_api.g_varchar2
589 ,p_segment20 in varchar2 default hr_api.g_varchar2
590 ,p_segment21 in varchar2 default hr_api.g_varchar2
591 ,p_segment22 in varchar2 default hr_api.g_varchar2
592 ,p_segment23 in varchar2 default hr_api.g_varchar2
593 ,p_segment24 in varchar2 default hr_api.g_varchar2
594 ,p_segment25 in varchar2 default hr_api.g_varchar2
595 ,p_segment26 in varchar2 default hr_api.g_varchar2
596 ,p_segment27 in varchar2 default hr_api.g_varchar2
597 ,p_segment28 in varchar2 default hr_api.g_varchar2
598 ,p_segment29 in varchar2 default hr_api.g_varchar2
599 ,p_segment30 in varchar2 default hr_api.g_varchar2
600 ,p_concat_segments in varchar2 default hr_api.g_varchar2
601 ,p_group_name out nocopy varchar2
602 ,p_employment_category in varchar2 default hr_api.g_varchar2
603 ,p_effective_start_date out nocopy date
604 ,p_effective_end_date out nocopy date
605 ,p_people_group_id out nocopy number
606 ,p_entries_changed_warning out nocopy varchar2
607 ,p_return_status out nocopy varchar2
608 );
609 end hr_assignment_swi;