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