1 Package irc_offers_swi AUTHID CURRENT_USER As
2 /* $Header: iriofswi.pkh 120.15 2011/02/03 09:34:11 amikukum ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-----------------------------< create_offer >-----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: irc_offers_api.create_offer
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 create_offer
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date default null
29 ,p_offer_status in varchar2
30 ,p_discretionary_job_title in varchar2 default null
31 ,p_offer_extended_method in varchar2 default null
32 ,p_respondent_id in number default null
33 ,p_expiry_date in date default null
34 ,p_proposed_start_date in date default null
35 ,p_offer_letter_tracking_code in varchar2 default null
36 ,p_offer_postal_service in varchar2 default null
37 ,p_offer_shipping_date in date default null
38 ,p_applicant_assignment_id in number
39 ,p_offer_assignment_id in number
40 ,p_address_id in number default null
41 ,p_template_id in number default null
42 ,p_offer_letter_file_type in varchar2 default null
43 ,p_offer_letter_file_name in varchar2 default null
44 ,p_attribute_category in varchar2 default null
45 ,p_attribute1 in varchar2 default null
46 ,p_attribute2 in varchar2 default null
47 ,p_attribute3 in varchar2 default null
48 ,p_attribute4 in varchar2 default null
49 ,p_attribute5 in varchar2 default null
50 ,p_attribute6 in varchar2 default null
51 ,p_attribute7 in varchar2 default null
52 ,p_attribute8 in varchar2 default null
53 ,p_attribute9 in varchar2 default null
54 ,p_attribute10 in varchar2 default null
55 ,p_attribute11 in varchar2 default null
56 ,p_attribute12 in varchar2 default null
57 ,p_attribute13 in varchar2 default null
58 ,p_attribute14 in varchar2 default null
59 ,p_attribute15 in varchar2 default null
60 ,p_attribute16 in varchar2 default null
61 ,p_attribute17 in varchar2 default null
62 ,p_attribute18 in varchar2 default null
63 ,p_attribute19 in varchar2 default null
64 ,p_attribute20 in varchar2 default null
65 ,p_attribute21 in varchar2 default null
66 ,p_attribute22 in varchar2 default null
67 ,p_attribute23 in varchar2 default null
68 ,p_attribute24 in varchar2 default null
69 ,p_attribute25 in varchar2 default null
70 ,p_attribute26 in varchar2 default null
71 ,p_attribute27 in varchar2 default null
72 ,p_attribute28 in varchar2 default null
73 ,p_attribute29 in varchar2 default null
74 ,p_attribute30 in varchar2 default null
75 ,p_status_change_date in date default null
76 ,p_vacancy_id in number default null
77 ,p_src_apl_asg_id in number default null
78 ,p_offer_id in out nocopy number
79 ,p_offer_version out nocopy number
80 ,p_object_version_number out nocopy number
81 ,p_return_status out nocopy varchar2
82 );
83 -- ----------------------------------------------------------------------------
84 -- |-----------------------------< update_offer >-----------------------------|
85 -- ----------------------------------------------------------------------------
86 -- {Start of comments}
87 --
88 -- Description:
89 -- This procedure is the self-service wrapper procedure to the following
90 -- API: irc_offers_api.update_offer
91 --
92 -- Pre-requisites
93 -- All 'IN' parameters to this procedure have been appropriately derived.
94 --
95 -- Post Success:
96 -- p_return_status will return value indicating success.
97 --
98 -- Post Failure:
99 -- p_return_status will return value indication failure.
100 --
101 -- Access Status:
102 -- Internal Development use only.
103 --
104 -- {End of comments}
105 -- ----------------------------------------------------------------------------
106 PROCEDURE update_offer
107 (p_validate in number default hr_api.g_false_num
108 ,p_effective_date in date default hr_api.g_date
109 ,p_offer_status in varchar2 default hr_api.g_varchar2
110 ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
111 ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
112 ,p_respondent_id in number default hr_api.g_number
113 ,p_expiry_date in date default hr_api.g_date
114 ,p_proposed_start_date in date default hr_api.g_date
115 ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
116 ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
117 ,p_offer_shipping_date in date default hr_api.g_date
118 ,p_applicant_assignment_id in number default hr_api.g_number
119 ,p_offer_assignment_id in number default hr_api.g_number
120 ,p_address_id in number default hr_api.g_number
121 ,p_template_id in number default hr_api.g_number
122 ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
123 ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
124 ,p_attribute_category in varchar2 default hr_api.g_varchar2
125 ,p_attribute1 in varchar2 default hr_api.g_varchar2
126 ,p_attribute2 in varchar2 default hr_api.g_varchar2
127 ,p_attribute3 in varchar2 default hr_api.g_varchar2
128 ,p_attribute4 in varchar2 default hr_api.g_varchar2
129 ,p_attribute5 in varchar2 default hr_api.g_varchar2
130 ,p_attribute6 in varchar2 default hr_api.g_varchar2
131 ,p_attribute7 in varchar2 default hr_api.g_varchar2
132 ,p_attribute8 in varchar2 default hr_api.g_varchar2
133 ,p_attribute9 in varchar2 default hr_api.g_varchar2
134 ,p_attribute10 in varchar2 default hr_api.g_varchar2
135 ,p_attribute11 in varchar2 default hr_api.g_varchar2
136 ,p_attribute12 in varchar2 default hr_api.g_varchar2
137 ,p_attribute13 in varchar2 default hr_api.g_varchar2
138 ,p_attribute14 in varchar2 default hr_api.g_varchar2
139 ,p_attribute15 in varchar2 default hr_api.g_varchar2
140 ,p_attribute16 in varchar2 default hr_api.g_varchar2
141 ,p_attribute17 in varchar2 default hr_api.g_varchar2
142 ,p_attribute18 in varchar2 default hr_api.g_varchar2
143 ,p_attribute19 in varchar2 default hr_api.g_varchar2
144 ,p_attribute20 in varchar2 default hr_api.g_varchar2
145 ,p_attribute21 in varchar2 default hr_api.g_varchar2
146 ,p_attribute22 in varchar2 default hr_api.g_varchar2
147 ,p_attribute23 in varchar2 default hr_api.g_varchar2
148 ,p_attribute24 in varchar2 default hr_api.g_varchar2
149 ,p_attribute25 in varchar2 default hr_api.g_varchar2
150 ,p_attribute26 in varchar2 default hr_api.g_varchar2
151 ,p_attribute27 in varchar2 default hr_api.g_varchar2
152 ,p_attribute28 in varchar2 default hr_api.g_varchar2
153 ,p_attribute29 in varchar2 default hr_api.g_varchar2
154 ,p_attribute30 in varchar2 default hr_api.g_varchar2
155 ,p_change_reason in varchar2 default null
156 ,p_decline_reason in varchar2 default null
157 ,p_note_text in varchar2 default null
158 ,p_status_change_date in date default null
162 ,p_return_status out nocopy varchar2
159 ,p_offer_id in out nocopy number
160 ,p_object_version_number in out nocopy number
161 ,p_offer_version out nocopy number
163 );
164 -- ----------------------------------------------------------------------------
165 -- |-----------------------------< delete_offer >-----------------------------|
166 -- ----------------------------------------------------------------------------
167 -- {Start of comments}
168 --
169 -- Description:
170 -- This procedure is the self-service wrapper procedure to the following
171 -- API: irc_offers_api.delete_offer
172 --
173 -- Pre-requisites
174 -- All 'IN' parameters to this procedure have been appropriately derived.
175 --
176 -- Post Success:
177 -- p_return_status will return value indicating success.
178 --
179 -- Post Failure:
180 -- p_return_status will return value indication failure.
181 --
182 -- Access Status:
183 -- Internal Development use only.
184 --
185 -- {End of comments}
186 -- ----------------------------------------------------------------------------
187 PROCEDURE delete_offer
188 (p_validate in number default hr_api.g_false_num
189 ,p_object_version_number in number
190 ,p_offer_id in number
191 ,p_effective_date in date default hr_api.g_date
192 ,p_return_status out nocopy varchar2
193 );
194 -- ----------------------------------------------------------------------------
195 -- |------------------------------< close_offer >-----------------------------|
196 -- ----------------------------------------------------------------------------
197 -- {Start of comments}
198 --
199 -- Description:
200 -- This procedure is the self-service wrapper procedure to the following
201 -- API: irc_offers_api.close_offer
202 --
203 -- Pre-requisites
204 -- All 'IN' parameters to this procedure have been appropriately derived.
205 --
206 -- Post Success:
207 -- p_return_status will return value indicating success.
208 --
209 -- Post Failure:
210 -- p_return_status will return value indication failure.
211 --
212 -- Access Status:
213 -- Internal Development use only.
214 --
215 -- {End of comments}
216 -- ----------------------------------------------------------------------------
217 PROCEDURE close_offer
218 (p_validate in number default hr_api.g_false_num
219 ,p_effective_date in date default hr_api.g_date
220 ,p_applicant_assignment_id in number default hr_api.g_number
221 ,p_offer_id in number default hr_api.g_number
222 ,p_respondent_id in number default hr_api.g_number
223 ,p_change_reason in varchar2 default hr_api.g_varchar2
224 ,p_decline_reason in varchar2 default hr_api.g_varchar2
225 ,p_note_text in varchar2 default hr_api.g_varchar2
226 ,p_status_change_date in date default hr_api.g_date
227 ,p_return_status out nocopy varchar2
228 );
229 -- ----------------------------------------------------------------------------
230 -- |------------------------------< hold_offer >------------------------------|
231 -- ----------------------------------------------------------------------------
232 -- {Start of comments}
233 --
234 -- Description:
235 -- This procedure is the self-service wrapper procedure to the following
236 -- API: irc_offers_api.hold_offer
237 --
238 -- Pre-requisites
239 -- All 'IN' parameters to this procedure have been appropriately derived.
240 --
241 -- Post Success:
242 -- p_return_status will return value indicating success.
243 --
244 -- Post Failure:
245 -- p_return_status will return value indication failure.
246 --
247 -- Access Status:
248 -- Internal Development use only.
249 --
250 -- {End of comments}
251 -- ----------------------------------------------------------------------------
252 PROCEDURE hold_offer
253 (p_validate in number default hr_api.g_false_num
254 ,p_effective_date in date default hr_api.g_date
255 ,p_offer_id in number
256 ,p_respondent_id in number default hr_api.g_number
257 ,p_change_reason in varchar2 default hr_api.g_varchar2
258 ,p_status_change_date in date default hr_api.g_date
259 ,p_note_text in varchar2 default hr_api.g_varchar2
260 ,p_object_version_number in out nocopy number
261 ,p_return_status out nocopy varchar2
262 );
263 -- ----------------------------------------------------------------------------
264 -- |-----------------------------< release_offer >----------------------------|
265 -- ----------------------------------------------------------------------------
266 -- {Start of comments}
267 --
268 -- Description:
269 -- This procedure is the self-service wrapper procedure to the following
270 -- API: irc_offers_api.release_offer
271 --
272 -- Pre-requisites
273 -- All 'IN' parameters to this procedure have been appropriately derived.
274 --
275 -- Post Success:
276 -- p_return_status will return value indicating success.
277 --
278 -- Post Failure:
279 -- p_return_status will return value indication failure.
280 --
281 -- Access Status:
282 -- Internal Development use only.
283 --
284 -- {End of comments}
288 ,p_effective_date in date default hr_api.g_date
285 -- ----------------------------------------------------------------------------
286 PROCEDURE release_offer
287 (p_validate in number default hr_api.g_false_num
289 ,p_offer_id in number
290 ,p_respondent_id in number default hr_api.g_number
291 ,p_change_reason in varchar2 default hr_api.g_varchar2
292 ,p_status_change_date in date default hr_api.g_date
293 ,p_note_text in varchar2 default hr_api.g_varchar2
294 ,p_object_version_number in out nocopy number
295 ,p_return_status out nocopy varchar2
296 );
297 -- ----------------------------------------------------------------------------
298 -- |------------------------< create_offer_assignment >-----------------------|
299 -- ----------------------------------------------------------------------------
300 -- {Start of comments}
301 --
302 -- Description:
303 -- This procedure is the self-service wrapper procedure to the following
304 -- API: irc_offers_api.create_offer_assignment
305 --
306 -- Pre-requisites
307 -- All 'IN' parameters to this procedure have been appropriately derived.
308 --
309 -- Post Success:
310 -- p_return_status will return value indicating success.
311 --
312 -- Post Failure:
313 -- p_return_status will return value indication failure.
314 --
315 -- Access Status:
316 -- Internal Development use only.
317 --
318 -- {End of comments}
319 -- ----------------------------------------------------------------------------
320 PROCEDURE create_offer_assignment
321 (p_assignment_id in out nocopy number
322 ,p_effective_start_date out nocopy date
323 ,p_effective_end_date out nocopy date
324 ,p_business_group_id in number
325 ,p_recruiter_id in number default null
326 ,p_grade_id in number default null
327 ,p_position_id in number default null
328 ,p_job_id in number default null
329 ,p_assignment_status_type_id in number
330 ,p_payroll_id in number default null
331 ,p_location_id in number default null
332 ,p_person_referred_by_id in number default null
333 ,p_supervisor_id in number default null
334 ,p_special_ceiling_step_id in number default null
335 ,p_person_id in number
336 ,p_recruitment_activity_id in number default null
337 ,p_source_organization_id in number default null
338 ,p_organization_id in number
339 ,p_people_group_id in number default null
340 ,p_soft_coding_keyflex_id in number default null
341 ,p_vacancy_id in number default null
342 ,p_pay_basis_id in number default null
343 ,p_assignment_sequence out nocopy number
344 ,p_assignment_type in varchar2
345 ,p_primary_flag in varchar2
346 ,p_application_id in number default null
347 ,p_assignment_number in out nocopy varchar2
348 ,p_change_reason in varchar2 default null
349 ,p_comment_id out nocopy number
350 ,p_comments in varchar2 default null
351 ,p_date_probation_end in date default null
352 ,p_default_code_comb_id in number default null
353 ,p_employment_category in varchar2 default null
354 ,p_frequency in varchar2 default null
355 ,p_internal_address_line in varchar2 default null
356 ,p_manager_flag in varchar2 default null
357 ,p_normal_hours in number default null
358 ,p_perf_review_period in number default null
359 ,p_perf_review_period_frequency in varchar2 default null
360 ,p_period_of_service_id in number default null
361 ,p_probation_period in number default null
362 ,p_probation_unit in varchar2 default null
363 ,p_sal_review_period in number default null
364 ,p_sal_review_period_frequency in varchar2 default null
365 ,p_set_of_books_id in number default null
366 ,p_source_type in varchar2 default null
367 ,p_time_normal_finish in varchar2 default null
368 ,p_time_normal_start in varchar2 default null
369 ,p_bargaining_unit_code in varchar2 default null
370 ,p_labour_union_member_flag in varchar2 default null
371 ,p_hourly_salaried_code in varchar2 default null
372 ,p_request_id in number default null
373 ,p_program_application_id in number default null
374 ,p_program_id in number default null
375 ,p_program_update_date in date default null
376 ,p_ass_attribute_category in varchar2 default null
377 ,p_ass_attribute1 in varchar2 default null
378 ,p_ass_attribute2 in varchar2 default null
379 ,p_ass_attribute3 in varchar2 default null
380 ,p_ass_attribute4 in varchar2 default null
381 ,p_ass_attribute5 in varchar2 default null
382 ,p_ass_attribute6 in varchar2 default null
383 ,p_ass_attribute7 in varchar2 default null
384 ,p_ass_attribute8 in varchar2 default null
385 ,p_ass_attribute9 in varchar2 default null
386 ,p_ass_attribute10 in varchar2 default null
387 ,p_ass_attribute11 in varchar2 default null
391 ,p_ass_attribute15 in varchar2 default null
388 ,p_ass_attribute12 in varchar2 default null
389 ,p_ass_attribute13 in varchar2 default null
390 ,p_ass_attribute14 in varchar2 default null
392 ,p_ass_attribute16 in varchar2 default null
393 ,p_ass_attribute17 in varchar2 default null
394 ,p_ass_attribute18 in varchar2 default null
395 ,p_ass_attribute19 in varchar2 default null
396 ,p_ass_attribute20 in varchar2 default null
397 ,p_ass_attribute21 in varchar2 default null
398 ,p_ass_attribute22 in varchar2 default null
399 ,p_ass_attribute23 in varchar2 default null
400 ,p_ass_attribute24 in varchar2 default null
401 ,p_ass_attribute25 in varchar2 default null
402 ,p_ass_attribute26 in varchar2 default null
403 ,p_ass_attribute27 in varchar2 default null
404 ,p_ass_attribute28 in varchar2 default null
405 ,p_ass_attribute29 in varchar2 default null
406 ,p_ass_attribute30 in varchar2 default null
407 ,p_title in varchar2 default null
408 ,p_validate_df_flex in number default null
409 ,p_object_version_number out nocopy number
410 ,p_effective_date in date
411 ,p_validate in number default hr_api.g_false_num
412 ,p_contract_id in number default null
413 ,p_establishment_id in number default null
414 ,p_collective_agreement_id in number default null
415 ,p_cagr_grade_def_id in number default null
416 ,p_cagr_id_flex_num in number default null
417 ,p_notice_period in number default null
418 ,p_notice_period_uom in varchar2 default null
419 ,p_employee_category in varchar2 default null
420 ,p_work_at_home in varchar2 default null
421 ,p_job_post_source_name in varchar2 default null
422 ,p_posting_content_id in number default null
423 ,p_placement_date_start in date default null
424 ,p_vendor_id in number default null
425 ,p_vendor_employee_number in varchar2 default null
426 ,p_vendor_assignment_number in varchar2 default null
427 ,p_assignment_category in varchar2 default null
428 ,p_project_title in varchar2 default null
429 ,p_applicant_rank in number default null
430 ,p_grade_ladder_pgm_id in number default null
431 ,p_supervisor_assignment_id in number default null
432 ,p_vendor_site_id in number default null
433 ,p_po_header_id in number default null
434 ,p_po_line_id in number default null
435 ,p_projected_assignment_end in date default null
436 ,p_return_status out nocopy varchar2
437 );
438 -- ----------------------------------------------------------------------------
439 -- |------------------------< update_offer_assignment >-----------------------|
440 -- ----------------------------------------------------------------------------
441 -- {Start of comments}
442 --
443 -- Description:
444 -- This procedure is the self-service wrapper procedure to the following
445 -- API: irc_offers_api.update_offer_assignment
446 --
447 -- Pre-requisites
448 -- All 'IN' parameters to this procedure have been appropriately derived.
449 --
450 -- Post Success:
451 -- p_return_status will return value indicating success.
452 --
453 -- Post Failure:
454 -- p_return_status will return value indication failure.
455 --
456 -- Access Status:
457 -- Internal Development use only.
458 --
459 -- {End of comments}
460 -- ----------------------------------------------------------------------------
461 PROCEDURE update_offer_assignment
462 (p_assignment_id in out nocopy number
463 ,p_effective_start_date out nocopy date
464 ,p_effective_end_date out nocopy date
465 ,p_business_group_id out nocopy number
466 ,p_recruiter_id in number default hr_api.g_number
467 ,p_grade_id in number default hr_api.g_number
468 ,p_position_id in number default hr_api.g_number
469 ,p_job_id in number default hr_api.g_number
470 ,p_assignment_status_type_id in number default hr_api.g_number
471 ,p_payroll_id in number default hr_api.g_number
472 ,p_location_id in number default hr_api.g_number
473 ,p_person_referred_by_id in number default hr_api.g_number
474 ,p_supervisor_id in number default hr_api.g_number
475 ,p_special_ceiling_step_id in number default hr_api.g_number
476 ,p_recruitment_activity_id in number default hr_api.g_number
477 ,p_source_organization_id in number default hr_api.g_number
478 ,p_organization_id in number default hr_api.g_number
479 ,p_people_group_id in number default hr_api.g_number
480 ,p_soft_coding_keyflex_id in number default hr_api.g_number
481 ,p_vacancy_id in number default hr_api.g_number
482 ,p_pay_basis_id in number default hr_api.g_number
483 ,p_assignment_type in varchar2 default hr_api.g_varchar2
487 ,p_change_reason in varchar2 default hr_api.g_varchar2
484 ,p_primary_flag in varchar2 default hr_api.g_varchar2
485 ,p_application_id in number default hr_api.g_number
486 ,p_assignment_number in varchar2 default hr_api.g_varchar2
488 ,p_comment_id out nocopy number
489 ,p_comments in varchar2 default hr_api.g_varchar2
490 ,p_date_probation_end in date default hr_api.g_date
491 ,p_default_code_comb_id in number default hr_api.g_number
492 ,p_employment_category in varchar2 default hr_api.g_varchar2
493 ,p_frequency in varchar2 default hr_api.g_varchar2
494 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
495 ,p_manager_flag in varchar2 default hr_api.g_varchar2
496 ,p_normal_hours in number default hr_api.g_number
497 ,p_perf_review_period in number default hr_api.g_number
498 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
499 ,p_period_of_service_id in number default hr_api.g_number
500 ,p_probation_period in number default hr_api.g_number
501 ,p_probation_unit in varchar2 default hr_api.g_varchar2
502 ,p_sal_review_period in number default hr_api.g_number
503 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
504 ,p_set_of_books_id in number default hr_api.g_number
505 ,p_source_type in varchar2 default hr_api.g_varchar2
506 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
507 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
508 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
509 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
510 ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
511 ,p_request_id in number default hr_api.g_number
512 ,p_program_application_id in number default hr_api.g_number
513 ,p_program_id in number default hr_api.g_number
514 ,p_program_update_date in date default hr_api.g_date
515 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
516 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
517 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
518 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
519 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
520 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
521 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
522 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
523 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
524 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
525 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
526 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
527 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
528 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
529 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
530 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
531 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
532 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
533 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
534 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
535 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
536 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
537 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
538 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
539 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
540 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
541 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
542 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
543 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
544 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
545 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
546 ,p_title in varchar2 default hr_api.g_varchar2
547 ,p_contract_id in number default hr_api.g_number
548 ,p_establishment_id in number default hr_api.g_number
549 ,p_collective_agreement_id in number default hr_api.g_number
550 ,p_cagr_grade_def_id in number default hr_api.g_number
551 ,p_cagr_id_flex_num in number default hr_api.g_number
552 ,p_asg_object_version_number in out nocopy number
553 ,p_notice_period in number default hr_api.g_number
554 ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
555 ,p_employee_category in varchar2 default hr_api.g_varchar2
556 ,p_work_at_home in varchar2 default hr_api.g_varchar2
557 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
558 ,p_posting_content_id in number default hr_api.g_number
559 ,p_placement_date_start in date default hr_api.g_date
560 ,p_vendor_id in number default hr_api.g_number
561 ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
562 ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
566 ,p_grade_ladder_pgm_id in number default hr_api.g_number
563 ,p_assignment_category in varchar2 default hr_api.g_varchar2
564 ,p_project_title in varchar2 default hr_api.g_varchar2
565 ,p_applicant_rank in number default hr_api.g_number
567 ,p_supervisor_assignment_id in number default hr_api.g_number
568 ,p_vendor_site_id in number default hr_api.g_number
569 ,p_po_header_id in number default hr_api.g_number
570 ,p_po_line_id in number default hr_api.g_number
571 ,p_projected_assignment_end in date default hr_api.g_date
572 ,p_payroll_id_updated out nocopy number
573 ,p_validation_start_date out nocopy date
574 ,p_validation_end_date out nocopy date
575 ,p_effective_date in date default hr_api.g_date
576 ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
577 ,p_validate in number default hr_api.g_false_num
578 ,p_offer_id in out nocopy number
579 ,p_offer_status in varchar2 default null
580 ,p_return_status out nocopy varchar2
581 );
582 -- ----------------------------------------------------------------------------
583 -- |------------------------< delete_offer_assignment >-----------------------|
584 -- ----------------------------------------------------------------------------
585 -- {Start of comments}
586 --
587 -- Description:
588 -- This procedure is the self-service wrapper procedure to the following
589 -- API: irc_offers_api.delete_offer_assignment
590 --
591 -- Pre-requisites
592 -- All 'IN' parameters to this procedure have been appropriately derived.
593 --
594 -- Post Success:
595 -- p_return_status will return value indicating success.
596 --
597 -- Post Failure:
598 -- p_return_status will return value indication failure.
599 --
600 -- Access Status:
601 -- Internal Development use only.
602 --
603 -- {End of comments}
604 -- ----------------------------------------------------------------------------
605 PROCEDURE delete_offer_assignment
606 (p_validate in number default hr_api.g_false_num
607 ,p_effective_date in date default hr_api.g_date
608 ,p_offer_assignment_id in number
609 ,p_return_status out nocopy varchar2
610 );
611 -- ----------------------------------------------------------------------------
612 -- |--------------------------< upload_offer_letter >-------------------------|
613 -- ----------------------------------------------------------------------------
614 -- {Start of comments}
615 --
616 -- Description:
617 -- This procedure is the self-service wrapper procedure to the following
618 -- API: irc_offers_api.upload_offer_letter
619 --
620 -- Pre-requisites
621 -- All 'IN' parameters to this procedure have been appropriately derived.
622 --
623 -- Post Success:
624 -- p_return_status will return value indicating success.
625 --
626 -- Post Failure:
627 -- p_return_status will return value indication failure.
628 --
629 -- Access Status:
630 -- Internal Development use only.
631 --
632 -- {End of comments}
633 -- ----------------------------------------------------------------------------
634 PROCEDURE upload_offer_letter
635 (p_validate in number default hr_api.g_false_num
636 ,p_offer_letter in BLOB
637 ,p_offer_id in number
638 ,p_object_version_number in number
639 ,p_return_status out nocopy varchar2
640 );
641 -- ----------------------------------------------------------------------------
642 -- |-------------------------< run_benmgle_for_irec >-------------------------|
643 -- ----------------------------------------------------------------------------
644 -- {Start of comments}
645 --
646 -- Description:
647 -- This procedure calls the benifits wrapper for iRecruitment
648 --
649 -- Pre-requisites
650 -- All 'IN' parameters to this procedure have been appropriately derived.
651 --
652 -- Post Success:
653 -- p_return_status will return value indicating success.
654 --
655 -- Post Failure:
656 -- p_return_status will return value indication failure.
657 --
658 -- Access Status:
659 -- Internal Development use only.
660 --
661 -- {End of comments}
662 -- ----------------------------------------------------------------------------
663 PROCEDURE run_benmgle_for_irec
664 (p_assignment_id in number
665 ,p_effective_start_date in date default trunc(sysdate)
666 ,p_effective_end_date in date default hr_api.g_eot
667 ,p_business_group_id in number
668 ,p_recruiter_id in number default null
669 ,p_grade_id in number default null
670 ,p_position_id in number default null
671 ,p_job_id in number default null
672 ,p_assignment_status_type_id in number
673 ,p_payroll_id in number default null
674 ,p_location_id in number default null
675 ,p_person_referred_by_id in number default null
676 ,p_supervisor_id in number default null
677 ,p_special_ceiling_step_id in number default null
678 ,p_person_id in number
679 ,p_recruitment_activity_id in number default null
680 ,p_source_organization_id in number default null
681 ,p_organization_id in number
682 ,p_people_group_id in number default null
686 ,p_assignment_sequence in number default 1
683 ,p_soft_coding_keyflex_id in number default null
684 ,p_vacancy_id in number default null
685 ,p_pay_basis_id in number default null
687 ,p_assignment_type in varchar2
688 ,p_primary_flag in varchar2
689 ,p_application_id in number default null
690 ,p_assignment_number in varchar2 default null
691 ,p_change_reason in varchar2 default null
692 ,p_comment_id in number default null
693 ,p_date_probation_end in date default null
694 ,p_default_code_comb_id in number default null
695 ,p_employment_category in varchar2 default null
696 ,p_frequency in varchar2 default null
697 ,p_internal_address_line in varchar2 default null
698 ,p_manager_flag in varchar2 default null
699 ,p_normal_hours in number default null
700 ,p_perf_review_period in number default null
701 ,p_perf_review_period_frequency in varchar2 default null
702 ,p_period_of_service_id in number default null
703 ,p_probation_period in number default null
704 ,p_probation_unit in varchar2 default null
705 ,p_sal_review_period in number default null
706 ,p_sal_review_period_frequency in varchar2 default null
707 ,p_set_of_books_id in number default null
708 ,p_source_type in varchar2 default null
709 ,p_time_normal_finish in varchar2 default null
710 ,p_time_normal_start in varchar2 default null
711 ,p_bargaining_unit_code in varchar2 default null
712 ,p_labour_union_member_flag in varchar2 default null
713 ,p_hourly_salaried_code in varchar2 default null
714 ,p_request_id in number default null
715 ,p_program_application_id in number default null
716 ,p_program_id in number default null
717 ,p_program_update_date in date default null
718 ,p_ass_attribute_category in varchar2 default null
719 ,p_ass_attribute1 in varchar2 default null
720 ,p_ass_attribute2 in varchar2 default null
721 ,p_ass_attribute3 in varchar2 default null
722 ,p_ass_attribute4 in varchar2 default null
723 ,p_ass_attribute5 in varchar2 default null
724 ,p_ass_attribute6 in varchar2 default null
725 ,p_ass_attribute7 in varchar2 default null
726 ,p_ass_attribute8 in varchar2 default null
727 ,p_ass_attribute9 in varchar2 default null
728 ,p_ass_attribute10 in varchar2 default null
729 ,p_ass_attribute11 in varchar2 default null
730 ,p_ass_attribute12 in varchar2 default null
731 ,p_ass_attribute13 in varchar2 default null
732 ,p_ass_attribute14 in varchar2 default null
733 ,p_ass_attribute15 in varchar2 default null
734 ,p_ass_attribute16 in varchar2 default null
735 ,p_ass_attribute17 in varchar2 default null
736 ,p_ass_attribute18 in varchar2 default null
737 ,p_ass_attribute19 in varchar2 default null
738 ,p_ass_attribute20 in varchar2 default null
739 ,p_ass_attribute21 in varchar2 default null
740 ,p_ass_attribute22 in varchar2 default null
741 ,p_ass_attribute23 in varchar2 default null
742 ,p_ass_attribute24 in varchar2 default null
743 ,p_ass_attribute25 in varchar2 default null
744 ,p_ass_attribute26 in varchar2 default null
745 ,p_ass_attribute27 in varchar2 default null
746 ,p_ass_attribute28 in varchar2 default null
747 ,p_ass_attribute29 in varchar2 default null
748 ,p_ass_attribute30 in varchar2 default null
749 ,p_title in varchar2 default null
750 ,p_object_version_number in number default 1
751 ,p_contract_id in number default null
752 ,p_establishment_id in number default null
753 ,p_collective_agreement_id in number default null
754 ,p_cagr_grade_def_id in number default null
755 ,p_cagr_id_flex_num in number default null
756 ,p_notice_period in number default null
757 ,p_notice_period_uom in varchar2 default null
758 ,p_employee_category in varchar2 default null
759 ,p_work_at_home in varchar2 default null
760 ,p_job_post_source_name in varchar2 default null
761 ,p_posting_content_id in number default null
762 ,p_placement_date_start in date default null
763 ,p_vendor_id in number default null
764 ,p_vendor_employee_number in varchar2 default null
765 ,p_vendor_assignment_number in varchar2 default null
766 ,p_assignment_category in varchar2 default null
767 ,p_project_title in varchar2 default null
768 ,p_applicant_rank in number default null
769 ,p_grade_ladder_pgm_id in number default null
770 ,p_supervisor_assignment_id in number default null
771 ,p_vendor_site_id in number default null
775 ,p_effective_date in date
772 ,p_po_header_id in number default null
773 ,p_po_line_id in number default null
774 ,p_projected_assignment_end in date default null
776 ,p_return_status out nocopy varchar2
777 );
778 --
779 -- ----------------------------------------------------------------------------
780 -- |--------------------< is_run_benmgle_for_irec_reqd >----------------------|
781 -- ----------------------------------------------------------------------------
782 PROCEDURE is_run_benmgle_for_irec_reqd
783 (p_assignment_id in number
784 ,p_effective_start_date in date default trunc(sysdate)
785 ,p_effective_end_date in date default hr_api.g_eot
786 ,p_business_group_id in number
787 ,p_recruiter_id in number default null
788 ,p_grade_id in number default null
789 ,p_position_id in number default null
790 ,p_job_id in number default null
791 ,p_assignment_status_type_id in number
792 ,p_payroll_id in number default null
793 ,p_location_id in number default null
794 ,p_person_referred_by_id in number default null
795 ,p_supervisor_id in number default null
796 ,p_special_ceiling_step_id in number default null
797 ,p_person_id in number
798 ,p_recruitment_activity_id in number default null
799 ,p_source_organization_id in number default null
800 ,p_organization_id in number
801 ,p_people_group_id in number default null
802 ,p_soft_coding_keyflex_id in number default null
803 ,p_vacancy_id in number default null
804 ,p_pay_basis_id in number default null
805 ,p_assignment_sequence in number default 1
806 ,p_assignment_type in varchar2
807 ,p_primary_flag in varchar2
808 ,p_application_id in number default null
809 ,p_assignment_number in varchar2 default null
810 ,p_change_reason in varchar2 default null
811 ,p_comment_id in number default null
812 ,p_date_probation_end in date default null
813 ,p_default_code_comb_id in number default null
814 ,p_employment_category in varchar2 default null
815 ,p_frequency in varchar2 default null
816 ,p_internal_address_line in varchar2 default null
817 ,p_manager_flag in varchar2 default null
818 ,p_normal_hours in number default null
819 ,p_perf_review_period in number default null
820 ,p_perf_review_period_frequency in varchar2 default null
821 ,p_period_of_service_id in number default null
822 ,p_probation_period in number default null
823 ,p_probation_unit in varchar2 default null
824 ,p_sal_review_period in number default null
825 ,p_sal_review_period_frequency in varchar2 default null
826 ,p_set_of_books_id in number default null
827 ,p_source_type in varchar2 default null
828 ,p_time_normal_finish in varchar2 default null
829 ,p_time_normal_start in varchar2 default null
830 ,p_bargaining_unit_code in varchar2 default null
831 ,p_labour_union_member_flag in varchar2 default null
832 ,p_hourly_salaried_code in varchar2 default null
833 ,p_request_id in number default null
834 ,p_program_application_id in number default null
835 ,p_program_id in number default null
836 ,p_program_update_date in date default null
837 ,p_ass_attribute_category in varchar2 default null
838 ,p_ass_attribute1 in varchar2 default null
839 ,p_ass_attribute2 in varchar2 default null
840 ,p_ass_attribute3 in varchar2 default null
841 ,p_ass_attribute4 in varchar2 default null
842 ,p_ass_attribute5 in varchar2 default null
843 ,p_ass_attribute6 in varchar2 default null
844 ,p_ass_attribute7 in varchar2 default null
845 ,p_ass_attribute8 in varchar2 default null
846 ,p_ass_attribute9 in varchar2 default null
847 ,p_ass_attribute10 in varchar2 default null
848 ,p_ass_attribute11 in varchar2 default null
849 ,p_ass_attribute12 in varchar2 default null
850 ,p_ass_attribute13 in varchar2 default null
851 ,p_ass_attribute14 in varchar2 default null
852 ,p_ass_attribute15 in varchar2 default null
853 ,p_ass_attribute16 in varchar2 default null
854 ,p_ass_attribute17 in varchar2 default null
855 ,p_ass_attribute18 in varchar2 default null
856 ,p_ass_attribute19 in varchar2 default null
857 ,p_ass_attribute20 in varchar2 default null
858 ,p_ass_attribute21 in varchar2 default null
859 ,p_ass_attribute22 in varchar2 default null
860 ,p_ass_attribute23 in varchar2 default null
861 ,p_ass_attribute24 in varchar2 default null
862 ,p_ass_attribute25 in varchar2 default null
863 ,p_ass_attribute26 in varchar2 default null
864 ,p_ass_attribute27 in varchar2 default null
865 ,p_ass_attribute28 in varchar2 default null
866 ,p_ass_attribute29 in varchar2 default null
870 ,p_contract_id in number default null
867 ,p_ass_attribute30 in varchar2 default null
868 ,p_title in varchar2 default null
869 ,p_object_version_number in number default 1
871 ,p_establishment_id in number default null
872 ,p_collective_agreement_id in number default null
873 ,p_cagr_grade_def_id in number default null
874 ,p_cagr_id_flex_num in number default null
875 ,p_notice_period in number default null
876 ,p_notice_period_uom in varchar2 default null
877 ,p_employee_category in varchar2 default null
878 ,p_work_at_home in varchar2 default null
879 ,p_job_post_source_name in varchar2 default null
880 ,p_posting_content_id in number default null
881 ,p_placement_date_start in date default null
882 ,p_vendor_id in number default null
883 ,p_vendor_employee_number in varchar2 default null
884 ,p_vendor_assignment_number in varchar2 default null
885 ,p_assignment_category in varchar2 default null
886 ,p_project_title in varchar2 default null
887 ,p_applicant_rank in number default null
888 ,p_grade_ladder_pgm_id in number default null
889 ,p_supervisor_assignment_id in number default null
890 ,p_vendor_site_id in number default null
891 ,p_po_header_id in number default null
892 ,p_po_line_id in number default null
893 ,p_projected_assignment_end in date default null
894 ,p_effective_date in date
895 --
896 -- pay proposal details
897 --
898 ,p_pay_proposal_id in number
899 ,p_event_id in number default null
900 ,p_change_date in date default null
901 ,p_last_change_date in date default null
902 ,p_next_perf_review_date in date default null
903 ,p_next_sal_review_date in date default null
904 ,p_performance_rating in varchar2 default null
905 ,p_proposal_reason in varchar2 default null
906 ,p_proposed_salary in varchar2 default null
907 ,p_review_date in date default null
908 ,p_attribute_category in varchar2 default null
909 ,p_attribute1 in varchar2 default null
910 ,p_attribute2 in varchar2 default null
911 ,p_attribute3 in varchar2 default null
912 ,p_attribute4 in varchar2 default null
913 ,p_attribute5 in varchar2 default null
914 ,p_attribute6 in varchar2 default null
915 ,p_attribute7 in varchar2 default null
916 ,p_attribute8 in varchar2 default null
917 ,p_attribute9 in varchar2 default null
918 ,p_attribute10 in varchar2 default null
919 ,p_attribute11 in varchar2 default null
920 ,p_attribute12 in varchar2 default null
921 ,p_attribute13 in varchar2 default null
922 ,p_attribute14 in varchar2 default null
923 ,p_attribute15 in varchar2 default null
924 ,p_attribute16 in varchar2 default null
925 ,p_attribute17 in varchar2 default null
926 ,p_attribute18 in varchar2 default null
927 ,p_attribute19 in varchar2 default null
928 ,p_attribute20 in varchar2 default null
929 ,p_pay_proposal_ovn in number default null
930 ,p_approved in varchar2 default null
931 ,p_multiple_components in varchar2 default null
932 ,p_forced_ranking in number default null
933 ,p_performance_review_id in number default null
934 ,p_proposed_salary_n in number default null
935 ,p_comments in long default null
936 --
937 ,p_is_run_reqd out nocopy varchar2
938 ,p_return_status out nocopy varchar2
939 );
940 --
941 -- Define global variables
942 --
943 g_old_offer_assignment_record per_all_assignments_f%rowtype;
944 g_old_pay_proposal_record per_pay_proposals%rowtype;
945 --
946
947 --Save For Later Code Changes
948 -- ----------------------------------------------------------------------------
949 -- |-------------------------< process_offers_api >--------------------------|
950 -- ----------------------------------------------------------------------------
951
952 procedure process_offers_api
953 (
954 p_document in CLOB
955 ,p_return_status out nocopy VARCHAR2
956 ,p_validate in number default hr_api.g_false_num
957 ,p_effective_date in date default null
958 );
959
960 -- ----------------------------------------------------------------------------
961 -- |-------------------------< process_asg_api >-----------------------------|
962 -- ----------------------------------------------------------------------------
963
964 procedure process_asg_api
965 (
966 p_document in CLOB
967 ,p_return_status out nocopy VARCHAR2
968 ,p_validate in number default hr_api.g_false_num
969 ,p_effective_date in date default null
970 );
971
972 -- ----------------------------------------------------------------------------
973 -- |-------------------------< finalize_transaction >-------------------------|
974 -- ----------------------------------------------------------------------------
975
976 procedure finalize_transaction
977 (
978 p_transaction_id in number
979 ,p_event in varchar2
980 ,p_return_status out nocopy varchar2
981 );
982
983 -- ----------------------------------------------------------------------------
984 -- |-----------------------------< void_ben_records >-------------------------|
985 -- ----------------------------------------------------------------------------
986
987 procedure void_ben_records
988 ( p_applicant_assignment_id in number default null
989 ,p_offer_assignment_id in number default null
990 ,p_status_code in varchar2 default null
991 ,p_effective_date in date default trunc(sysdate)
992 ,p_transaction_id in number default null
993 ,p_void_single_per_in_ler in varchar2 default 'N'
994 );
995 --
996 --
997 -- ----------------------------------------------------------------------------
998 -- |-----------------------------< handleAttachmentsWhenCommit >---------------|
999 -- ----------------------------------------------------------------------------
1000 --
1001 procedure handleAttachmentsWhenCommit(p_applicant_assignment_id in number);
1002 --
1003 -- ----------------------------------------------------------------------------
1004 -- |-----------------------------< handleAttachmentsWhenRejected >-------------|
1005 -- ----------------------------------------------------------------------------
1006 --
1007 procedure handleAttachmentsWhenRejected(p_applicant_assignment_id in number);
1008
1009 -- ---------------------------------------------------------------------------
1010 -- |-----------------------------< handleAttachmentsWhenEditing >--------------|
1011 -- ----------------------------------------------------------------------------
1012 --
1013 procedure handleAttachmentsWhenEdit(p_applicant_assignment_id in number);
1014 --
1015 --
1016 -- ----------------------------------------------------------------------------
1017 -- |-----------------------------< clear_global_data >-------------------------|
1018 -- ----------------------------------------------------------------------------
1019 procedure clear_global_data;
1020 --
1021 end irc_offers_swi;