4 * This package contains APIs for maintaining offers and offer assignments.
1 Package IRC_OFFERS_API AUTHID CURRENT_USER as
2 /* $Header: iriofapi.pkh 120.14 2011/02/04 10:54:03 avarri ship $ */
3 /*#
5 * @rep:scope public
6 * @rep:product irc
7 * @rep:displayname Offer
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-------------------------------< create_offer >---------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a new offer.
17 *
18 *
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with iRecruitment.
21 *
22 * <p><b>Prerequisites</b><br>
23 * None.
24 *
25 * <p><b>Post Success</b><br>
26 * The record gets successfully inserted.
27 *
28 * <p><b>Post Failure</b><br>
29 * The API does not create the offer and raises an error.
30 *
31 * @param p_validate If true, then validation alone will be performed and the
32 * database will remain unchanged. If false and all validation checks pass,
33 * then the database will be modified.
34 * @param p_effective_date Effective date for the creation
35 * of the offer. If this is not passed in, DATE_FROM will be used.
39 * @param p_offer_extended_method Indicates how offers are extended to
36 * @param p_offer_status Status of the Offer version.
37 * @param p_discretionary_job_title Job title that can be used as the offer
38 * title instead of the title available in the Job Table.
40 * applicants- SYSTEM/HARDCOPY. Value is defined by the IRC: Offer Send Method
41 * System Profile Option.
42 * @param p_respondent_id User ID of the person responding to
43 * the offer extension.
44 * @param p_expiry_date Date when the current offer version expires.
45 * @param p_proposed_start_date The proposed employment start date of the
46 * applicant, if the person accepts the job offer.
47 * @param p_offer_letter_tracking_code Tracking code from the shipping
48 * company when the offer shipped.
49 * @param p_offer_postal_service Name of the company handling the
50 * delivery of the offer.
51 * @param p_offer_shipping_date Date on which paper copy of the Offer was
52 * shipped.
53 * @param p_applicant_assignment_id Applicant assignment for the applicant
54 * where the type is 'APPLICANT'.
55 * @param p_offer_assignment_id Offer assignment for the applicant where the
56 * type is 'OFFER'.
57 * @param p_address_id Address Offer should be sent to.
58 * @param p_template_id ID of the template associated with the offer. The
59 * application sets the value to null, if a manager uploads a modified version
60 * of the offer letter.
61 * @param p_offer_letter_file_type File type of the uploaded offer letter.
62 * @param p_offer_letter_file_name Filename of the uploaded offer letter.
63 * @param p_attribute_category This context value determines which flexfield
64 * structure to use with the descriptive flexfield segments.
65 * @param p_attribute1 Descriptive flexfield segment.
66 * @param p_attribute2 Descriptive flexfield segment.
67 * @param p_attribute3 Descriptive flexfield segment.
68 * @param p_attribute4 Descriptive flexfield segment.
69 * @param p_attribute5 Descriptive flexfield segment.
70 * @param p_attribute6 Descriptive flexfield segment.
71 * @param p_attribute7 Descriptive flexfield segment.
72 * @param p_attribute8 Descriptive flexfield segment.
73 * @param p_attribute9 Descriptive flexfield segment.
74 * @param p_attribute10 Descriptive flexfield segment.
75 * @param p_attribute11 Descriptive flexfield segment.
76 * @param p_attribute12 Descriptive flexfield segment.
77 * @param p_attribute13 Descriptive flexfield segment.
78 * @param p_attribute14 Descriptive flexfield segment.
79 * @param p_attribute15 Descriptive flexfield segment.
80 * @param p_attribute16 Descriptive flexfield segment.
81 * @param p_attribute17 Descriptive flexfield segment.
82 * @param p_attribute18 Descriptive flexfield segment.
83 * @param p_attribute19 Descriptive flexfield segment.
84 * @param p_attribute20 Descriptive flexfield segment.
85 * @param p_attribute21 Descriptive flexfield segment.
86 * @param p_attribute22 Descriptive flexfield segment.
87 * @param p_attribute23 Descriptive flexfield segment.
88 * @param p_attribute24 Descriptive flexfield segment.
89 * @param p_attribute25 Descriptive flexfield segment.
90 * @param p_attribute26 Descriptive flexfield segment.
91 * @param p_attribute27 Descriptive flexfield segment.
92 * @param p_attribute28 Descriptive flexfield segment.
93 * @param p_attribute29 Descriptive flexfield segment.
94 * @param p_attribute30 Descriptive flexfield segment.
95 * @param p_status_change_date Date of the offer status change.
96 * @param p_vacancy_id This indicates the vacancy id for which the
97 * offer is being created.
98 * @param p_src_apl_asg_id This indicates the source application
99 * assignment id for which the offer being created.
100 * @param p_offer_id If p_validate is false, then this uniquely identifies
101 * the offer created. If p_validate is true, then set to null.
102 * @param p_offer_version Version of the Offer starting at 1.
103 * Part of the Business Key to the Table.
104 * @param p_object_version_number If p_validate is false, then set to the
105 * version number of the created assignment detail. If p_validate is true,
106 * then the value will be null.
107 * @rep:displayname Create Offer
108 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
109 * @rep:lifecycle active
110 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
111 * @rep:scope public
112 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
113 */
114 --
115 -- {End Of Comments}
116 --
117 procedure create_offer
118 ( P_VALIDATE IN boolean default false
119 ,P_EFFECTIVE_DATE IN date default null
120 ,P_OFFER_STATUS IN VARCHAR2
121 ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default null
122 ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default null
123 ,P_RESPONDENT_ID IN NUMBER default null
124 ,P_EXPIRY_DATE IN DATE default null
125 ,P_PROPOSED_START_DATE IN DATE default null
126 ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default null
127 ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default null
128 ,P_OFFER_SHIPPING_DATE IN DATE default null
129 ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER
130 ,P_OFFER_ASSIGNMENT_ID IN NUMBER
131 ,P_ADDRESS_ID IN NUMBER default null
132 ,P_TEMPLATE_ID IN NUMBER default null
133 ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default null
134 ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default null
138 ,P_ATTRIBUTE3 IN VARCHAR2 default null
135 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default null
136 ,P_ATTRIBUTE1 IN VARCHAR2 default null
137 ,P_ATTRIBUTE2 IN VARCHAR2 default null
139 ,P_ATTRIBUTE4 IN VARCHAR2 default null
140 ,P_ATTRIBUTE5 IN VARCHAR2 default null
141 ,P_ATTRIBUTE6 IN VARCHAR2 default null
142 ,P_ATTRIBUTE7 IN VARCHAR2 default null
143 ,P_ATTRIBUTE8 IN VARCHAR2 default null
144 ,P_ATTRIBUTE9 IN VARCHAR2 default null
145 ,P_ATTRIBUTE10 IN VARCHAR2 default null
146 ,P_ATTRIBUTE11 IN VARCHAR2 default null
147 ,P_ATTRIBUTE12 IN VARCHAR2 default null
148 ,P_ATTRIBUTE13 IN VARCHAR2 default null
149 ,P_ATTRIBUTE14 IN VARCHAR2 default null
150 ,P_ATTRIBUTE15 IN VARCHAR2 default null
151 ,P_ATTRIBUTE16 IN VARCHAR2 default null
152 ,P_ATTRIBUTE17 IN VARCHAR2 default null
153 ,P_ATTRIBUTE18 IN VARCHAR2 default null
154 ,P_ATTRIBUTE19 IN VARCHAR2 default null
155 ,P_ATTRIBUTE20 IN VARCHAR2 default null
156 ,P_ATTRIBUTE21 IN VARCHAR2 default null
157 ,P_ATTRIBUTE22 IN VARCHAR2 default null
158 ,P_ATTRIBUTE23 IN VARCHAR2 default null
159 ,P_ATTRIBUTE24 IN VARCHAR2 default null
160 ,P_ATTRIBUTE25 IN VARCHAR2 default null
161 ,P_ATTRIBUTE26 IN VARCHAR2 default null
162 ,P_ATTRIBUTE27 IN VARCHAR2 default null
163 ,P_ATTRIBUTE28 IN VARCHAR2 default null
164 ,P_ATTRIBUTE29 IN VARCHAR2 default null
165 ,P_ATTRIBUTE30 IN VARCHAR2 default null
166 ,P_STATUS_CHANGE_DATE IN DATE default null
167 ,P_VACANCY_ID IN NUMBER default null
168 ,P_SRC_APL_ASG_ID IN NUMBER default null
169 ,P_OFFER_ID OUT nocopy NUMBER
170 ,P_OFFER_VERSION OUT nocopy NUMBER
174 -- ----------------------------------------------------------------------------
171 ,P_OBJECT_VERSION_NUMBER OUT nocopy NUMBER
172 );
173 --
175 -- |-------------------------------< update_offer >---------------------------|
176 -- ----------------------------------------------------------------------------
177 --
178 -- {Start Of Comments}
179 /*#
180 * This API updates an offer.
181 *
182 *
183 * <p><b>Licensing</b><br>
184 * This API is licensed for use with iRecruitment.
185 *
186 * <p><b>Prerequisites</b><br>
187 * The offer should exist.
188 *
189 * <p><b>Post Success</b><br>
190 * Successfully updates the record.
191 *
192 * <p><b>Post Failure</b><br>
193 * The API does not update the offer and an error will be raised.
194 *
195 * @param p_validate If true, then validation alone will be performed and the
196 * database will remain unchanged. If false and all validation checks pass,
197 * then the database will be modified.
198 * @param p_effective_date Effective date for the creation
199 * of the offer.
200 * @param p_offer_status Status of the Offer version.
201 * @param p_discretionary_job_title Job Title that can be used as the offer
202 * title instead of the Title set in the Job Table.
203 * @param p_offer_extended_method Indicates how offers are extended to
204 * applicants- SYSTEM/HARDCOPY. Value is defined by the IRC: Offer Send Method
205 * System Profile Option.
206 * @param p_respondent_id User ID of the person responding to
207 * the offer extension.
208 * @param p_expiry_date Date when the current offer version expires.
209 * @param p_proposed_start_date The proposed employment start date of the
210 * applicant, if the person accepts the job offer.
211 * @param p_offer_letter_tracking_code Tracking code from the shipping
212 * company when the offer shipped.
213 * @param p_offer_postal_service Name of the company handling the
214 * delivery of the offer.
215 * @param p_offer_shipping_date Date on which paper copy of the Offer was
216 * shipped.
217 * @param p_applicant_assignment_id Applicant assignment for the applicant
218 * where the type is 'APPLICANT'.
219 * @param p_offer_assignment_id Offer assignment for the applicant where the
220 * type is 'OFFER'.
221 * @param p_address_id Address Offer should be sent to.
222 * @param p_template_id ID of the template associated with the offer. The
223 * application sets the value to null, if a manager uploads a modified version
224 * of the offer letter.
225 * @param p_offer_letter_file_type File type of the uploaded offer letter.
226 * @param p_offer_letter_file_name Filename of the uploaded offer letter.
227 * @param p_attribute_category This context value determines which flexfield
228 * structure to use with the descriptive flexfield segments.
229 * @param p_attribute1 Descriptive flexfield segment.
230 * @param p_attribute2 Descriptive flexfield segment.
231 * @param p_attribute3 Descriptive flexfield segment.
232 * @param p_attribute4 Descriptive flexfield segment.
233 * @param p_attribute5 Descriptive flexfield segment.
234 * @param p_attribute6 Descriptive flexfield segment.
235 * @param p_attribute7 Descriptive flexfield segment.
236 * @param p_attribute8 Descriptive flexfield segment.
237 * @param p_attribute9 Descriptive flexfield segment.
238 * @param p_attribute10 Descriptive flexfield segment.
239 * @param p_attribute11 Descriptive flexfield segment.
240 * @param p_attribute12 Descriptive flexfield segment.
241 * @param p_attribute13 Descriptive flexfield segment.
242 * @param p_attribute14 Descriptive flexfield segment.
243 * @param p_attribute15 Descriptive flexfield segment.
244 * @param p_attribute16 Descriptive flexfield segment.
245 * @param p_attribute17 Descriptive flexfield segment.
246 * @param p_attribute18 Descriptive flexfield segment.
247 * @param p_attribute19 Descriptive flexfield segment.
248 * @param p_attribute20 Descriptive flexfield segment.
249 * @param p_attribute21 Descriptive flexfield segment.
250 * @param p_attribute22 Descriptive flexfield segment.
251 * @param p_attribute23 Descriptive flexfield segment.
252 * @param p_attribute24 Descriptive flexfield segment.
253 * @param p_attribute25 Descriptive flexfield segment.
254 * @param p_attribute26 Descriptive flexfield segment.
255 * @param p_attribute27 Descriptive flexfield segment.
256 * @param p_attribute28 Descriptive flexfield segment.
257 * @param p_attribute29 Descriptive flexfield segment.
258 * @param p_attribute30 Descriptive flexfield segment.
259 * @param p_change_reason Reason for the Status Change.
260 * @param p_decline_reason Applicant Decline Reason.
261 * @param p_note_text Offer Notes Text.
262 * @param p_status_change_date Date of the offer status change.
263 * @param p_offer_id If p_validate is false, then this uniquely identifies
264 * the new version of offer that may be created or will be set to the same
265 * value which was passed in. If p_validate is true will be set to the same
266 * value which was passed in.
267 * @param p_object_version_number Pass in the current version number of the
268 * offer to be updated. When the API completes if p_validate is
269 * false, will be set to the new version number of the updated offer.
270 * @param p_offer_version New Version of the updated Offer.
271 * @rep:displayname Update Offer
272 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
273 * @rep:lifecycle active
274 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
275 * @rep:scope public
276 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
277 */
278 --
279 -- {End Of Comments}
280 --
281 procedure update_offer
282 ( P_VALIDATE IN boolean default false
283 ,P_EFFECTIVE_DATE IN date default null
284 ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
288 ,P_EXPIRY_DATE IN DATE default hr_api.g_date
285 ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
286 ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
287 ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
289 ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
290 ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
291 ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
292 ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
293 ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
294 ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
295 ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
296 ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
297 ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
298 ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
299 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
300 ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
301 ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
302 ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
303 ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
304 ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
305 ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
306 ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
307 ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
308 ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
309 ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
310 ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
311 ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
312 ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
313 ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
314 ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
315 ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
316 ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
317 ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
318 ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
319 ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
320 ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
321 ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
322 ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
323 ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
324 ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
325 ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
326 ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
327 ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
328 ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
329 ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
330 ,P_CHANGE_REASON IN VARCHAR2 default null
331 ,P_DECLINE_REASON IN VARCHAR2 default null
332 ,P_NOTE_TEXT IN VARCHAR2 default null
333 ,P_STATUS_CHANGE_DATE IN DATE default null
334 ,P_OFFER_ID IN OUT nocopy NUMBER
335 ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
336 ,P_OFFER_VERSION OUT nocopy NUMBER
337 );
338 --
339 -- ----------------------------------------------------------------------------
340 -- |-------------------------------< delete_offer >---------------------------|
341 -- ----------------------------------------------------------------------------
342 --
343 -- {Start Of Comments}
344 /*#
345 * This API deletes an offer.
346 *
347 *
348 * <p><b>Licensing</b><br>
349 * This API is licensed for use with iRecruitment.
350 *
351 * <p><b>Prerequisites</b><br>
352 * The offer should exist.
353 *
354 * <p><b>Post Success</b><br>
355 * The current offer record will be deleted.
356 *
357 * <p><b>Post Failure</b><br>
358 * The record will not be deleted and an error is raised.
359 *
360 * @param p_validate If true, then validation alone will be performed and the
361 * database will remain unchanged. If false and all validation checks pass,
362 * then the database will be modified.
363 * @param p_object_version_number Current version number of the offer
364 * to be deleted.
365 * @param p_offer_id Primary key of the offer in the IRC_OFFERS table.
366 * @param p_effective_date Effective date for the creation
367 * of the offer.
368 * @rep:displayname Delete Offer
369 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
370 * @rep:lifecycle active
371 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
372 * @rep:scope public
373 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
374 */
375 --
376 -- {End Of Comments}
377 --
378 procedure delete_offer
379 (
380 P_VALIDATE in boolean default false
381 , P_OBJECT_VERSION_NUMBER in number
382 , P_OFFER_ID in number
383 , P_EFFECTIVE_DATE in date default null
384 );
385 --
386 -- ----------------------------------------------------------------------------
390 -- {Start Of Comments}
387 -- |-------------------------------< close_offer >----------------------------|
388 -- ----------------------------------------------------------------------------
389 --
391 /*#
392 * This API closes an offer and also end dates the offer assignment record.
393 *
394 * This API works for 2 cases:
395 * 1. A manager closes an offer or an applicant declines an offer.
396 * 2. The applicant withdraws the application for which an offer has been
397 * created.
398 *
399 * <p><b>Licensing</b><br>
400 * This API is licensed for use with iRecruitment.
401 *
402 * <p><b>Prerequisites</b><br>
403 * The offer should exist for the applicant assignment.
404 *
405 * <p><b>Post Success</b><br>
406 * The API sets the offer status to closed and end dates the offer assignment
407 * record.
408 *
409 * <p><b>Post Failure</b><br>
410 * The API does not close the offer and raises an error.
411 *
412 * @param p_validate If true, then validation alone will be performed and the
413 * database will remain unchanged. If false and all validation checks pass,
414 * then the database will be modified.
415 * @param p_effective_date Effective date for the creation
416 * of the offer.
417 * @param p_applicant_assignment_id Applicant assignment for the applicant
418 * where the type is 'APPLICANT'.
419 * @param p_offer_id Primary key of the offer in the IRC_OFFERS table.
420 * @param p_respondent_id User ID of the person closing the offer.
421 * @param p_change_reason Reason for the status change.
422 * @param p_decline_reason The applicant's reason for declining an offer.
423 * @param p_note_text Offer notes text.
424 * @param p_status_change_date Date of the offer status change.
425 * @rep:displayname Close Offer
426 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
427 * @rep:lifecycle active
428 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
429 * @rep:scope public
430 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
431 */
432 --
433 -- {End Of Comments}
434 --
435 procedure close_offer
436 ( P_VALIDATE IN boolean default false
437 ,P_EFFECTIVE_DATE IN date default null
438 ,P_APPLICANT_ASSIGNMENT_ID IN number default null
439 ,P_OFFER_ID IN number default null
440 ,P_RESPONDENT_ID IN number default null
441 ,P_CHANGE_REASON IN VARCHAR2 default null
442 ,P_DECLINE_REASON IN VARCHAR2 default null
443 ,P_NOTE_TEXT IN VARCHAR2 default null
444 ,P_STATUS_CHANGE_DATE IN date default null
445 );
446 --
447 -- ----------------------------------------------------------------------------
448 -- |--------------------------------< hold_offer >----------------------------|
449 -- ----------------------------------------------------------------------------
450 --
451 -- {Start Of Comments}
452 /*#
453 * This API places an offer on Hold.
454 *
455 *
456 * <p><b>Licensing</b><br>
457 * This API is licensed for use with iRecruitment.
458 *
459 * <p><b>Prerequisites</b><br>
460 * The offer should exist.
461 *
462 * <p><b>Post Success</b><br>
463 * The offer's status would be set to "HOLD".
464 *
465 * <p><b>Post Failure</b><br>
466 * The API does not place the offer on hold and raises an error.
467 *
468 * @param p_validate If true, then validation alone will be performed and the
469 * database will remain unchanged. If false and all validation checks pass,
470 * then the database will be modified.
471 * @param p_effective_date Effective date for the creation
472 * of the offer.
473 * @param p_offer_id Primary key of the offer in the IRC_OFFERS table.
474 * @param p_respondent_id User ID of the person holding the offer.
475 * @param p_change_reason Reason for the Status Change.
476 * @param p_status_change_date Date of the offer status change.
477 * @param p_note_text Offer Notes Text.
478 * @param p_object_version_number Pass in the current version number of the
479 * offer to be put on hold. When the API completes if p_validate is false,
480 * will be set to the new version number of the updated offer. If p_validate
481 * is true will be set to the same value which was passed in.
482 * @rep:displayname Hold Offer
483 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
484 * @rep:lifecycle active
485 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
486 * @rep:scope public
487 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
488 */
489 --
490 -- {End Of Comments}
491 --
492 procedure hold_offer
493 ( P_VALIDATE IN boolean default false
494 ,P_EFFECTIVE_DATE IN date default null
495 ,P_OFFER_ID IN NUMBER
496 ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
497 ,P_CHANGE_REASON IN VARCHAR2 default null
498 ,P_STATUS_CHANGE_DATE IN date default null
499 ,P_NOTE_TEXT IN VARCHAR2 default null
500 ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
501 );
502 --
503 -- ----------------------------------------------------------------------------
504 -- |------------------------------< release_offer >---------------------------|
505 -- ----------------------------------------------------------------------------
506 --
507 -- {Start Of Comments}
508 /*#
509 * This API releases an offer from the HOLD state and sets the offer status to the
510 * one that existed before the offer was placed on hold.
511 *
512 * <p><b>Licensing</b><br>
516 * The offer should exist and be in HOLD status.
513 * This API is licensed for use with iRecruitment.
514 *
515 * <p><b>Prerequisites</b><br>
517 *
518 * <p><b>Post Success</b><br>
519 * The offer's status would be released from HOLD and set to the offer status
520 * that existed before the offer was held.
521 *
522 * <p><b>Post Failure</b><br>
523 * The offer will not be released and an error would be raised.
524 *
525 * @param p_validate If true, then validation alone will be performed and the
526 * database will remain unchanged. If false and all validation checks pass,
527 * then the database will be modified.
528 * @param p_effective_date Effective date for the creation
529 * of the offer.
530 * @param p_offer_id Primary key of the offer in the IRC_OFFERS table.
531 * @param p_respondent_id User ID of the person releasing the offer.
532 * @param p_change_reason Reason for the status change.
533 * @param p_status_change_date Date of the offer status change.
534 * @param p_note_text Offer notes text.
535 * @param p_object_version_number Pass in the current version number of the
536 * offer to be released. When the API completes if p_validate is false, will be
537 * set to the new version number of the released offer. If p_validate is true
538 * will be set to the same value which was passed in.
539 * @rep:displayname Release Offer
540 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
541 * @rep:lifecycle active
542 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
543 * @rep:scope public
544 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
545 */
546 --
547 -- {End Of Comments}
548 --
549 procedure release_offer
550 ( P_VALIDATE IN boolean default false
551 ,P_EFFECTIVE_DATE IN date default null
552 ,P_OFFER_ID IN NUMBER
553 ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
554 ,P_CHANGE_REASON IN VARCHAR2 default null
555 ,P_STATUS_CHANGE_DATE IN date default null
556 ,P_NOTE_TEXT IN VARCHAR2 default null
557 ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
558 );
559 --
560 -- ----------------------------------------------------------------------------
561 -- |-------------------------< create_offer_assignment >----------------------|
562 -- ----------------------------------------------------------------------------
563 --
564 -- {Start Of Comments}
565 /*#
566 * This API creates an assignment record of type 'O' for offers.
567 *
568 *
569 * <p><b>Licensing</b><br>
570 * This API is licensed for use with iRecruitment.
571 *
572 * <p><b>Prerequisites</b><br>
573 * None.
574 *
575 * <p><b>Post Success</b><br>
576 * A new offer assignment record will be created.
577 *
578 * <p><b>Post Failure</b><br>
579 * The record will not be created and an error is raised.
580 *
581 * @param p_assignment_id If p_validate is false, then this uniquely identifies
582 * the created assignment. If p_validate is true, then set to null.
583 * @param p_effective_start_date If p_validate is false, then set to the
584 * earliest effective start date for the created assignment. If p_validate is
585 * true, then set to null.
586 * @param p_effective_end_date If p_validate is false, then set to the
587 * effective end date for the created assignment. If p_validate is true, then
588 * set to null.
589 * @param p_business_group_id The business group associated with this
590 * assignment. This should be the same as the business group associated with
591 * the applicant person.
592 * @param p_recruiter_id Recruiter for the assignment. The value refers to the
593 * recruiter's person record.
594 * @param p_grade_id Identifies the grade of the assignment.
595 * @param p_position_id Identifies the position of the assignment.
596 * @param p_job_id Identifies the job of the assignment.
597 * @param p_assignment_status_type_id Identifies the assignment status of the
598 * assignment.
599 * @param p_payroll_id Identifies the payroll for the assignment.
600 * @param p_location_id Identifies the location of the assignment.
601 * @param p_person_referred_by_id Identifies the person record of the person
602 * who referred the applicant.
603 * @param p_supervisor_id Identifies the supervisor for the assignment. The
604 * value refers to the supervisor's person record.
605 * @param p_special_ceiling_step_id Highest allowed step for the grade scale
606 * associated with the grade of the assignment.
607 * @param p_person_id Identifies the person record that owns the assignments to
608 * update.
609 * @param p_recruitment_activity_id Identifies the Recruitment Activity from
610 * which the applicant was found.
611 * @param p_source_organization_id Identifies the recruiting source
612 * organization.
613 * @param p_organization_id Identifies the organization of the assignment.
614 * @param p_people_group_id If a value is passed in for this parameter, it
615 * identifies an existing People Group Key Flexfield combination to associate
616 * with the assignment, and segment values are ignored. If a value is not
617 * passed in, then the individual People Group Key Flexfield segments supplied
618 * will be used to choose an existing combination or create a new combination.
619 * When the API completes, if p_validate is false, then this uniquely
620 * identifies the associated combination of the People Group Key flexfield for
621 * this assignment. If p_validate is true, then set to null.
622 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
623 * it identifies an existing Soft Coded Key Flexfield combination to associate
624 * with the assignment, and segment values are ignored. If a value is not
625 * passed in, then the individual Soft Coded Key Flexfield segments supplied
626 * will be used to choose an existing combination or create a new combination.
630 * @param p_vacancy_id Identifies the vacancy that the applicant applied for.
627 * When the API completes, if p_validate is false, then this uniquely
628 * identifies the associated combination of the Soft Coded Key flexfield for
629 * this assignment. If p_validate is true, then set to null.
631 * @param p_pay_basis_id Salary basis for the assignment.
632 * @param p_assignment_sequence If p_validate is false, then an automatically
633 * incremented number is associated with this assignment, depending on the
634 * number of assignment which already exist. If p_validate is true then set to
635 * null.
636 * @param p_assignment_type Represents the type of the person's assignment,
637 * 'A' if Applicant, 'O' for Offer.
638 * @param p_primary_flag Indicates whether the address is a primary address.
639 * Valid values are 'Y' or 'N'.
640 * @param p_application_id Identifies the application record of the offer
641 * assignment.
642 * @param p_assignment_number If a value is passed in, this is used as the
643 * assignment number. If no value is passed in an assignment number is
644 * generated.
645 * @param p_change_reason Reason for the assignment status change. If there is
646 * no change reason, then the parameter can be null. Valid values are defined
647 * in the EMP_ASSIGN_REASON lookup type.
648 * @param p_comment_id If p_validate is false and comment text was provided,
649 * then will be set to the identifier of the created assignment comment record.
650 * If p_validate is true or no comment text was provided, then will be null.
651 * @param p_comments Comment text.
652 * @param p_date_probation_end End date of the probation period.
653 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
654 * Flexfield combination that applies to this assignment.
655 * @param p_employment_category Employment category. Valid values are defined
656 * in the EMP_CAT lookup type.
657 * @param p_frequency Frequency associated with the defined normal working
658 * hours. Valid values are defined in the FREQUENCY lookup type.
659 * @param p_internal_address_line Internal address identified with the
660 * assignment.
661 * @param p_manager_flag Indicates whether the employee is a manager.
662 * @param p_normal_hours Normal working hours for this assignment.
663 * @param p_perf_review_period Length of the performance review period.
664 * @param p_perf_review_period_frequency Units of the performance review
665 * period.
666 * @param p_period_of_service_id Period of service that is being terminated.
667 * @param p_probation_period Length of the probation period.
668 * @param p_probation_unit Units of the probation period. Valid values are
669 * defined in the QUALIFYING_UNITS lookup type.
670 * @param p_sal_review_period Length of the salary review period.
671 * @param p_sal_review_period_frequency Units of the salary review period.
672 * Valid values are defined in the FREQUENCY lookup type.
673 * @param p_set_of_books_id Identifies General Ledger set of books.
674 * @param p_source_type Recruitment activity that this assignment is sourced
675 * from. Valid values are defined in the REC_TYPE lookup type.
676 * @param p_time_normal_finish Normal work finish time.
677 * @param p_time_normal_start Normal work start time.
678 * @param p_bargaining_unit_code Code for the bargaining unit. Valid values are
679 * defined in the BARGAINING_UNIT_CODE lookup type.
680 * @param p_labour_union_member_flag Value 'Y' indicates employee is a union
681 * member. Other values indicate that the employee is not a union member.
682 * @param p_hourly_salaried_code Identifies whether the assignment is paid
683 * hourly or is salaried. Valid values are defined in the HOURLY_SALARIED_CODE
684 * lookup type.
685 * @param p_request_id When the API is executed from a concurrent program, the
686 * value is set to the concurrent request identifier.
687 * @param p_program_application_id When the API is executed from a concurrent
688 * program, the value is set to the program's Application identifier.
689 * @param p_program_id When the API is executed from a concurrent program, the
690 * value is set to the program's identifier.
691 * @param p_program_update_date When the API is executed from a concurrent
692 * program, the value is set to when the program was run.
693 * @param p_ass_attribute_category This context value determines which
694 * Flexfield Structure to use with the Descriptive flexfield segments.
695 * @param p_ass_attribute1 Descriptive flexfield segment.
696 * @param p_ass_attribute2 Descriptive flexfield segment.
697 * @param p_ass_attribute3 Descriptive flexfield segment.
698 * @param p_ass_attribute4 Descriptive flexfield segment.
699 * @param p_ass_attribute5 Descriptive flexfield segment.
700 * @param p_ass_attribute6 Descriptive flexfield segment.
701 * @param p_ass_attribute7 Descriptive flexfield segment.
702 * @param p_ass_attribute8 Descriptive flexfield segment.
703 * @param p_ass_attribute9 Descriptive flexfield segment.
704 * @param p_ass_attribute10 Descriptive flexfield segment.
705 * @param p_ass_attribute11 Descriptive flexfield segment.
706 * @param p_ass_attribute12 Descriptive flexfield segment.
707 * @param p_ass_attribute13 Descriptive flexfield segment.
708 * @param p_ass_attribute14 Descriptive flexfield segment.
709 * @param p_ass_attribute15 Descriptive flexfield segment.
710 * @param p_ass_attribute16 Descriptive flexfield segment.
711 * @param p_ass_attribute17 Descriptive flexfield segment.
712 * @param p_ass_attribute18 Descriptive flexfield segment.
713 * @param p_ass_attribute19 Descriptive flexfield segment.
714 * @param p_ass_attribute20 Descriptive flexfield segment.
715 * @param p_ass_attribute21 Descriptive flexfield segment.
716 * @param p_ass_attribute22 Descriptive flexfield segment.
717 * @param p_ass_attribute23 Descriptive flexfield segment.
718 * @param p_ass_attribute24 Descriptive flexfield segment.
719 * @param p_ass_attribute25 Descriptive flexfield segment.
720 * @param p_ass_attribute26 Descriptive flexfield segment.
724 * @param p_ass_attribute30 Descriptive flexfield segment.
721 * @param p_ass_attribute27 Descriptive flexfield segment.
722 * @param p_ass_attribute28 Descriptive flexfield segment.
723 * @param p_ass_attribute29 Descriptive flexfield segment.
725 * @param p_title Obsolete parameter, do not use.
726 * @param p_validate_df_flex Identifies whether to validate the descriptive
727 * flex fields values.
728 * @param p_object_version_number If p_validate is false, then set to the
729 * version number of the created assignment. If p_validate is true, then the
730 * value will be null.
731 * @param p_other_manager_warning If set to true, then a manager existed in the
732 * organization prior to calling this API and the manager flag has been set to
733 * 'Y' for yes.
734 * @param p_hourly_salaried_warning Set to true if values entered for Salary
735 * Basis and Hourly Salaried Code are invalid as of p_effective_date.
736 * @param p_effective_date Determines when the DateTrack operation comes
737 * into force.
738 * @param p_validate If true, then validation alone will be performed and the
739 * database will remain unchanged. If false and all validation checks pass,
740 * then the database will be modified.
741 * @param p_contract_id Contract associated with this assignment.
742 * @param p_establishment_id For French business groups, this identifies the
743 * Establishment Legal Entity for this assignment.
744 * @param p_collective_agreement_id Collective Agreement that applies to this
745 * assignment.
746 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
747 * identifies an existing CAGR Key Flexfield combination to associate with the
748 * assignment, and segment values are ignored. If a value is not passed in,
749 * then the individual CAGR Key Flexfield segments supplied will be used to
750 * choose an existing combination or create a new combination. When the API
751 * completes, if p_validate is false, then this uniquely identifies the
752 * associated combination of the CAGR Key flexfield for this assignment. If
753 * p_validate is true, then set to null.
754 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
755 * flexfield to use for this assignment.
756 * @param p_notice_period Length of notice period.
757 * @param p_notice_period_uom Units for notice period. Valid values are defined
758 * in the QUALIFYING_UNITS lookup type.
759 * @param p_employee_category Employee Category. Valid values are defined in
760 * the EMPLOYEE_CATG lookup type.
761 * @param p_work_at_home Indicates whether this assignment is to work at home.
762 * Valid values are defined in the YES_NO lookup type.
763 * @param p_job_post_source_name The source of the job posting that was
764 * selected for this assignment.
765 * @param p_posting_content_id Identifies the posting to which the applicant
766 * has applied.
767 * @param p_placement_date_start Start date of the placement action.
768 * @param p_vendor_id Identifier of the supplier of the contingent worker from
769 * iProcurement.
770 * @param p_vendor_employee_number Identification number given by the supplier
771 * to the contingent worker.
772 * @param p_vendor_assignment_number Identification number given by the
773 * supplier to the contingent worker's assignment.
774 * @param p_assignment_category Assignment Category. Valid values are defined
775 * in the CWK_ASG_CATEGORY lookup type.
776 * @param p_project_title Project title.
777 * @param p_applicant_rank Applicant's rank.
778 * @param p_grade_ladder_pgm_id Grade ladder defined for this assignment.
779 * @param p_supervisor_assignment_id Supervisor's assignment that is
780 * responsible for supervising this assignment.
781 * @param p_vendor_site_id Identifier of the supplier site of the contingent
782 * worker from iProcurement.
783 * @param p_po_header_id Identifies the purchase order header in iProcurement
784 * that stores the contingent worker's assignment pay details.
785 * @param p_po_line_id Identifies the purchase order line in iProcurement that
786 * stores the contingent worker's assignment pay details.
787 * @param p_projected_assignment_end Projected end date of this assignment.
788 * @rep:displayname Create Offer Assignment
789 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
790 * @rep:lifecycle active
791 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
792 * @rep:scope public
793 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
794 */
795 --
796 -- {End Of Comments}
797 --
798 Procedure create_offer_assignment
799 (
800 p_assignment_id OUT NOCOPY NUMBER
801 ,p_effective_start_date OUT NOCOPY DATE
802 ,p_effective_end_date OUT NOCOPY DATE
803 ,p_business_group_id IN NUMBER
804 ,p_recruiter_id IN NUMBER default null
805 ,p_grade_id IN NUMBER default null
806 ,p_position_id IN NUMBER default null
807 ,p_job_id IN NUMBER default null
808 ,p_assignment_status_type_id IN NUMBER
809 ,p_payroll_id IN NUMBER default null
810 ,p_location_id IN NUMBER default null
811 ,p_person_referred_by_id IN NUMBER default null
812 ,p_supervisor_id IN NUMBER default null
813 ,p_special_ceiling_step_id IN NUMBER default null
814 ,p_person_id IN NUMBER
815 ,p_recruitment_activity_id IN NUMBER default null
816 ,p_source_organization_id IN NUMBER default null
817 ,p_organization_id IN NUMBER
818 ,p_people_group_id IN NUMBER default null
819 ,p_soft_coding_keyflex_id IN NUMBER default null
820 ,p_vacancy_id IN NUMBER default null
821 ,p_pay_basis_id IN NUMBER default null
825 ,p_application_id IN NUMBER default null
822 ,p_assignment_sequence OUT NOCOPY NUMBER
823 ,p_assignment_type IN VARCHAR2
824 ,p_primary_flag IN VARCHAR2
826 ,p_assignment_number IN OUT NOCOPY VARCHAr2
827 ,p_change_reason IN VARCHAR2 default null
828 ,p_comment_id OUT NOCOPY NUMBER
829 ,p_comments IN VARCHAR2 default null
830 ,p_date_probation_end IN DATE default null
831 ,p_default_code_comb_id IN NUMBER default null
832 ,p_employment_category IN VARCHAR2 default null
833 ,p_frequency IN VARCHAR2 default null
834 ,p_internal_address_line IN VARCHAR2 default null
835 ,p_manager_flag IN VARCHAR2 default null
836 ,p_normal_hours IN NUMBER default null
837 ,p_perf_review_period IN NUMBER default null
838 ,p_perf_review_period_frequency IN VARCHAR2 default null
839 ,p_period_of_service_id IN NUMBER default null
840 ,p_probation_period IN NUMBER default null
841 ,p_probation_unit IN VARCHAR2 default null
842 ,p_sal_review_period IN NUMBER default null
843 ,p_sal_review_period_frequency IN VARCHAR2 default null
844 ,p_set_of_books_id IN NUMBER default null
845 ,p_source_type IN VARCHAR2 default null
846 ,p_time_normal_finish IN VARCHAR2 default null
847 ,p_time_normal_start IN VARCHAR2 default null
848 ,p_bargaining_unit_code IN VARCHAR2 default null
849 ,p_labour_union_member_flag IN VARCHAR2 default 'N'
850 ,p_hourly_salaried_code IN VARCHAR2 default null
851 ,p_request_id IN NUMBER default null
852 ,p_program_application_id IN NUMBER default null
853 ,p_program_id IN NUMBER default null
854 ,p_program_update_date IN DATE default null
855 ,p_ass_attribute_category IN VARCHAR2 default null
856 ,p_ass_attribute1 IN VARCHAR2 default null
857 ,p_ass_attribute2 IN VARCHAR2 default null
858 ,p_ass_attribute3 IN VARCHAR2 default null
859 ,p_ass_attribute4 IN VARCHAR2 default null
860 ,p_ass_attribute5 IN VARCHAR2 default null
861 ,p_ass_attribute6 IN VARCHAR2 default null
862 ,p_ass_attribute7 IN VARCHAR2 default null
863 ,p_ass_attribute8 IN VARCHAR2 default null
864 ,p_ass_attribute9 IN VARCHAR2 default null
865 ,p_ass_attribute10 IN VARCHAR2 default null
866 ,p_ass_attribute11 IN VARCHAR2 default null
867 ,p_ass_attribute12 IN VARCHAR2 default null
868 ,p_ass_attribute13 IN VARCHAR2 default null
869 ,p_ass_attribute14 IN VARCHAR2 default null
870 ,p_ass_attribute15 IN VARCHAR2 default null
871 ,p_ass_attribute16 IN VARCHAR2 default null
872 ,p_ass_attribute17 IN VARCHAR2 default null
873 ,p_ass_attribute18 IN VARCHAR2 default null
874 ,p_ass_attribute19 IN VARCHAR2 default null
875 ,p_ass_attribute20 IN VARCHAR2 default null
876 ,p_ass_attribute21 IN VARCHAR2 default null
877 ,p_ass_attribute22 IN VARCHAR2 default null
878 ,p_ass_attribute23 IN VARCHAR2 default null
879 ,p_ass_attribute24 IN VARCHAR2 default null
880 ,p_ass_attribute25 IN VARCHAR2 default null
881 ,p_ass_attribute26 IN VARCHAR2 default null
882 ,p_ass_attribute27 IN VARCHAR2 default null
883 ,p_ass_attribute28 IN VARCHAR2 default null
884 ,p_ass_attribute29 IN VARCHAR2 default null
885 ,p_ass_attribute30 IN VARCHAR2 default null
886 ,p_title IN VARCHAR2 default null
887 ,p_validate_df_flex IN BOOLEAN default true
888 ,p_object_version_number OUT NOCOPY NUMBER
889 ,p_other_manager_warning OUT NOCOPY BOOLEAN
890 ,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
891 ,p_effective_date IN DATE
892 ,p_validate IN BOOLEAN default false
893 ,p_contract_id IN NUMBER default null
894 ,p_establishment_id IN NUMBER default null
895 ,p_collective_agreement_id IN NUMBER default null
896 ,p_cagr_grade_def_id IN NUMBER default null
897 ,p_cagr_id_flex_num IN NUMBER default null
898 ,p_notice_period IN NUMBER default null
899 ,p_notice_period_uom IN VARCHAR2 default null
900 ,p_employee_category IN VARCHAR2 default null
901 ,p_work_at_home IN VARCHAR2 default null
902 ,p_job_post_source_name IN VARCHAR2 default null
903 ,p_posting_content_id IN NUMBER default null
904 ,p_placement_date_start IN DATE default null
905 ,p_vendor_id IN NUMBER default null
906 ,p_vendor_employee_number IN VARCHAR2 default null
907 ,p_vendor_assignment_number IN VARCHAR2 default null
908 ,p_assignment_category IN VARCHAR2 default null
912 ,p_supervisor_assignment_id IN NUMBER default null
909 ,p_project_title IN VARCHAR2 default null
910 ,p_applicant_rank IN NUMBER default null
911 ,p_grade_ladder_pgm_id IN NUMBER default null
913 ,p_vendor_site_id IN NUMBER default null
914 ,p_po_header_id IN NUMBER default null
915 ,p_po_line_id IN NUMBER default null
916 ,p_projected_assignment_end IN DATE default null
917 );
918 --
919 -- ----------------------------------------------------------------------------
920 -- |-------------------------< update_offer_assignment >----------------------|
921 -- ----------------------------------------------------------------------------
922 --
923 -- {Start Of Comments}
924 /*#
925 * This api updates an offer assignment.
926 *
927 *
928 * <p><b>Licensing</b><br>
929 * This API is licensed for use with iRecruitment.
930 *
931 * <p><b>Prerequisites</b><br>
932 * The offer assignment should exist.
933 *
934 * <p><b>Post Success</b><br>
935 * When the offer assignment is successfully updated, the following parameters are
936 * set.
937 *
938 * <p><b>Post Failure</b><br>
939 * The record will not be updated and an error is raised.
940 *
941 * @param p_assignment_id If p_validate is false, then this uniquely identifies
942 * the created assignment. If p_validate is true, then set to null.
943 * @param p_effective_start_date If p_validate is false, then set to the
944 * effective start date on the updated offer assignment row which now exists
945 * as of the effective date. If p_validate is true, then set to null.
946 * @param p_effective_end_date If p_validate is false, then set to the
947 * effective end date on the updated offer assignment row which now exists
948 * as of the effective date. If p_validate is true, then set to null.
949 * @param p_business_group_id The business group associated with this
950 * assignment. This should be the same as the business group associated with
951 * the contingent worker.
952 * @param p_recruiter_id Recruiter for the assignment. The value refers to the
953 * recruiter's person record.
954 * @param p_grade_id Identifies the grade of the assignment.
955 * @param p_position_id Identifies the position of the assignment.
956 * @param p_job_id Identifies the job of the assignment.
957 * @param p_assignment_status_type_id Identifies the assignment status of the
958 * assignment.
959 * @param p_payroll_id Identifies the payroll for the assignment.
960 * @param p_location_id Identifies the location of the assignment.
961 * @param p_person_referred_by_id Identifies the person record of the person
962 * who referred the applicant.
963 * @param p_supervisor_id Identifies the supervisor for the assignment. The
964 * value refers to the supervisor's person record.
965 * @param p_special_ceiling_step_id Highest allowed step for the grade scale
966 * associated with the grade of the assignment.
967 * @param p_recruitment_activity_id Identifies the Recruitment Activity from
968 * which the applicant was found.
969 * @param p_source_organization_id Identifies the recruiting source
970 * organization.
971 * @param p_organization_id Identifies the organization of the assignment.
972 * @param p_people_group_id If a value is passed in for this parameter, it
973 * identifies an existing People Group Key Flexfield combination to associate
974 * with the assignment, and segment values are ignored. If a value is not
975 * passed in, then the individual People Group Key Flexfield segments supplied
976 * will be used to choose an existing combination or create a new combination.
977 * When the API completes, if p_validate is false, then this uniquely
978 * identifies the associated combination of the People Group Key flexfield for
979 * this assignment. If p_validate is true, then set to null.
980 * @param p_soft_coding_keyflex_id If a value is passed in for this parameter,
981 * it identifies an existing Soft Coded Key Flexfield combination to associate
982 * with the assignment, and segment values are ignored. If a value is not
983 * passed in, then the individual Soft Coded Key Flexfield segments supplied
984 * will be used to choose an existing combination or create a new combination.
985 * When the API completes, if p_validate is false, then this uniquely
986 * identifies the associated combination of the Soft Coded Key flexfield for
987 * this assignment. If p_validate is true, then set to null.
988 * @param p_vacancy_id Identifies the vacancy that the applicant applied for.
989 * @param p_pay_basis_id Salary basis for the assignment.
990 * @param p_assignment_type Represents the type of the person's assignment,
991 * 'A' if Applicant, 'O' for Offer.
992 * @param p_primary_flag Indicates whether the address is a primary address.
993 * Valid values are 'Y' or 'N'.
994 * @param p_application_id Identifies the application record to which this
995 * assignment belongs.
996 * @param p_assignment_number If a value is passed in, this is used as the
997 * assignment number. If no value is passed in an assignment number is
998 * generated.
999 * @param p_change_reason Reason for the assignment status change. If there is
1000 * no change reason, then the parameter can be null. Valid values are defined in the
1001 * EMP_ASSIGN_REASON lookup type.
1002 * @param p_comment_id If p_validate is false and comment text was provided,
1003 * then will be set to the identifier of the created assignment comment record.
1004 * If p_validate is true or no comment text was provided, then will be null.
1005 * @param p_comments Comment text.
1006 * @param p_date_probation_end End date of the probation period.
1007 * @param p_default_code_comb_id Identifier for the General Ledger Accounting
1008 * Flexfield combination that applies to this assignment.
1012 * hours. Valid values are defined in the FREQUENCY lookup type.
1009 * @param p_employment_category Employment category. Valid values are defined
1010 * in the EMP_CAT lookup type.
1011 * @param p_frequency Frequency associated with the defined normal working
1013 * @param p_internal_address_line Internal address identified with the
1014 * assignment.
1015 * @param p_manager_flag Indicates whether the employee is a manager.
1016 * @param p_normal_hours Normal working hours for this assignment.
1017 * @param p_perf_review_period Length of the performance review period.
1018 * @param p_perf_review_period_frequency Units of the performance review
1019 * period.
1020 * @param p_period_of_service_id Period of service that is being terminated.
1021 * @param p_probation_period Length of the probation period.
1022 * @param p_probation_unit Units of the probation period. Valid values are
1023 * defined in the QUALIFYING_UNITS lookup type.
1024 * @param p_sal_review_period Length of the salary review period.
1025 * @param p_sal_review_period_frequency Units of the salary review period.
1026 * Valid values are defined in the FREQUENCY lookup type.
1027 * @param p_set_of_books_id Identifies General Ledger set of books.
1028 * @param p_source_type Recruitment activity that this assignment is sourced
1029 * from. Valid values are defined in the REC_TYPE lookup type.
1030 * @param p_time_normal_finish Normal work finish time.
1031 * @param p_time_normal_start Normal work start time.
1032 * @param p_bargaining_unit_code Code for the bargaining unit. Valid values are
1033 * defined in the BARGAINING_UNIT_CODE lookup type.
1034 * @param p_labour_union_member_flag Value 'Y' indicates employee is a union
1035 * member. Other values indicate that the employee is not a union member.
1036 * @param p_hourly_salaried_code Identifies whether the assignment is paid
1037 * hourly or is salaried. Valid values are defined in the HOURLY_SALARIED_CODE
1038 * lookup type.
1039 * @param p_request_id When the API is executed from a concurrent program, the
1040 * value is set to the concurrent request identifier.
1041 * @param p_program_application_id When the API is executed from a concurrent
1042 * program, the value is set to the program's Application identifier.
1043 * @param p_program_id When the API is executed from a concurrent program, the
1044 * value is set to the program's identifier.
1045 * @param p_program_update_date When the API is executed from a concurrent
1046 * program, the value is set to when the program was run.
1047 * @param p_ass_attribute_category This context value determines which
1048 * Flexfield Structure to use with the Descriptive flexfield segments.
1049 * @param p_ass_attribute1 Descriptive flexfield segment.
1050 * @param p_ass_attribute2 Descriptive flexfield segment.
1051 * @param p_ass_attribute3 Descriptive flexfield segment.
1052 * @param p_ass_attribute4 Descriptive flexfield segment.
1053 * @param p_ass_attribute5 Descriptive flexfield segment.
1054 * @param p_ass_attribute6 Descriptive flexfield segment.
1055 * @param p_ass_attribute7 Descriptive flexfield segment.
1056 * @param p_ass_attribute8 Descriptive flexfield segment.
1057 * @param p_ass_attribute9 Descriptive flexfield segment.
1058 * @param p_ass_attribute10 Descriptive flexfield segment.
1059 * @param p_ass_attribute11 Descriptive flexfield segment.
1060 * @param p_ass_attribute12 Descriptive flexfield segment.
1061 * @param p_ass_attribute13 Descriptive flexfield segment.
1062 * @param p_ass_attribute14 Descriptive flexfield segment.
1063 * @param p_ass_attribute15 Descriptive flexfield segment.
1064 * @param p_ass_attribute16 Descriptive flexfield segment.
1065 * @param p_ass_attribute17 Descriptive flexfield segment.
1066 * @param p_ass_attribute18 Descriptive flexfield segment.
1067 * @param p_ass_attribute19 Descriptive flexfield segment.
1068 * @param p_ass_attribute20 Descriptive flexfield segment.
1069 * @param p_ass_attribute21 Descriptive flexfield segment.
1070 * @param p_ass_attribute22 Descriptive flexfield segment.
1071 * @param p_ass_attribute23 Descriptive flexfield segment.
1072 * @param p_ass_attribute24 Descriptive flexfield segment.
1073 * @param p_ass_attribute25 Descriptive flexfield segment.
1074 * @param p_ass_attribute26 Descriptive flexfield segment.
1075 * @param p_ass_attribute27 Descriptive flexfield segment.
1076 * @param p_ass_attribute28 Descriptive flexfield segment.
1077 * @param p_ass_attribute29 Descriptive flexfield segment.
1078 * @param p_ass_attribute30 Descriptive flexfield segment.
1079 * @param p_title Obsolete parameter, do not use.
1080 * @param p_contract_id Contract associated with this assignment.
1081 * @param p_establishment_id For French business groups, this identifies the
1082 * Establishment Legal Entity for this assignment.
1083 * @param p_collective_agreement_id Collective Agreement that applies to this
1084 * assignment.
1085 * @param p_cagr_grade_def_id If a value is passed in for this parameter, it
1086 * identifies an existing CAGR Key Flexfield combination to associate with the
1087 * assignment, and segment values are ignored. If a value is not passed in,
1088 * then the individual CAGR Key Flexfield segments supplied will be used to
1089 * choose an existing combination or create a new combination. When the API
1090 * completes, if p_validate is false, then this uniquely identifies the
1091 * associated combination of the CAGR Key flexfield for this assignment. If
1092 * p_validate is true, then set to null.
1093 * @param p_cagr_id_flex_num Identifier for the structure from CAGR Key
1094 * flexfield to use for this assignment.
1095 * @param p_asg_object_version_number If p_validate is false, then this
1096 * parameter is set to the version number of the assignment created. If
1097 * p_validate is true, then this parameter is null.
1098 * @param p_notice_period Length of notice period.
1099 * @param p_notice_period_uom Units for notice period. Valid values are defined
1100 * in the QUALIFYING_UNITS lookup type.
1104 * Valid values are defined in the YES_NO lookup type.
1101 * @param p_employee_category Employee Category. Valid values are defined in
1102 * the EMPLOYEE_CATG lookup type.
1103 * @param p_work_at_home Indicates whether this assignment is to work at home.
1105 * @param p_job_post_source_name The source of the job posting that was
1106 * selected for this assignment.
1107 * @param p_posting_content_id Identifies the posting to which the applicant
1108 * has applied.
1109 * @param p_placement_date_start Start date of the placement action.
1110 * @param p_vendor_id Identifier of the supplier of the contingent worker from
1111 * iProcurement.
1112 * @param p_vendor_employee_number Identification number given by the supplier
1113 * to the contingent worker.
1114 * @param p_vendor_assignment_number Identification number given by the
1115 * supplier to the contingent worker's assignment.
1116 * @param p_assignment_category Assignment Category. Valid values are defined
1117 * in the CWK_ASG_CATEGORY lookup type.
1118 * @param p_project_title Project title.
1119 * @param p_applicant_rank Applicant's rank.
1120 * @param p_grade_ladder_pgm_id Grade lLadder defined for this assignment.
1121 * @param p_supervisor_assignment_id Supervisor's assignment that is
1122 * responsible for supervising this assignment.
1123 * @param p_vendor_site_id Identifier of the supplier site of the contingent
1124 * worker from iProcurement.
1125 * @param p_po_header_id Identifies the purchase order header in iProcurement
1126 * that stores the contingent worker's assignment pay details.
1127 * @param p_po_line_id Identifies the purchase order line in iProcurement that
1128 * stores the contingent worker's assignment pay details.
1129 * @param p_projected_assignment_end Projected end date of this assignment.
1130 * @param p_payroll_id_updated ID of the payroll for the updated assignment.
1131 * @param p_other_manager_warning If set to true, then a manager existed in the
1132 * organization prior to calling this API and the manager flag has been set to
1133 * 'Y' for yes.
1134 * @param p_hourly_salaried_warning Set to true if values entered for Salary
1135 * Basis and Hourly Salaried Code are invalid as of p_effective_date.
1136 * @param p_no_managers_warning Set to true if as a result of the update there
1137 * is no manager in the organization. Otherwise set to false.
1138 * @param p_org_now_no_manager_warning Set to true if this assignment had the
1139 * manager flag set to 'Y' and there are no other managers in the assignment's
1140 * organization. Set to false if there is another manager in the assignment's
1141 * organization or if this assignment did not have the manager flag set to 'Y'.
1142 * The warning value only applies as of the final process date.
1143 * @param p_validation_start_date Derived Effective Start Date.
1144 * @param p_validation_end_date Derived Effective End Date.
1145 * @param p_effective_date Determines when the DateTrack operation comes
1146 * into force.
1147 * @param p_datetrack_mode Indicates which DateTrack mode to use when
1148 * deleting the record. You must set to either ZAP, DELETE_NEXT_CHANGE or
1149 * FUTURE_CHANGE. Modes available for use with a particular record depend on
1150 * the dates of previous record changes and the effective date of this change.
1151 * @param p_validate If true, then validation alone will be performed and the
1152 * database will remain unchanged. If false and all validation checks pass,
1153 * then the database will be modified.
1154 * @param p_offer_id If p_validate is false, then this uniquely identifies
1155 * the new version of offer that may be created or will be set to the same
1156 * value which was passed in. If p_validate is true will be set to the same
1157 * value which was passed in.
1158 * @param p_offer_status Status of the Offer version.
1159 * @rep:displayname Update Offer Assignment
1160 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
1161 * @rep:lifecycle active
1162 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1163 * @rep:scope public
1164 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1165 */
1166 --
1167 -- {End Of Comments}
1168 --
1169 procedure update_offer_assignment
1170 ( P_ASSIGNMENT_ID IN OUT NOCOPY NUMBER
1171 ,P_EFFECTIVE_START_DATE OUT NOCOPY DATE
1172 ,P_EFFECTIVE_END_DATE OUT NOCOPY DATE
1173 ,P_BUSINESS_GROUP_ID OUT NOCOPY NUMBER
1174
1175 ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
1176 ,P_GRADE_ID IN NUMBER default hr_api.g_number
1177 ,P_POSITION_ID IN NUMBER default hr_api.g_number
1178 ,P_JOB_ID IN NUMBER default hr_api.g_number
1179 ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
1180 ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
1181 ,P_LOCATION_ID IN NUMBER default hr_api.g_number
1182 ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
1183 ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
1184 ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
1185 ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
1186 ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
1187
1188 ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
1189 ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
1190 ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
1191 ,P_VACANCY_ID IN NUMBER default hr_api.g_number
1192 ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
1196 ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
1193 ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
1194 ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
1195 ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
1197 ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
1198 ,P_COMMENT_ID OUT NOCOPY NUMBER
1199 ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
1200 ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
1201
1202 ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
1203 ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1204 ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
1205 ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
1206 ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
1207 ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
1208 ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
1209 ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
1210 ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
1211 ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
1212 ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
1213 ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
1214 ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
1215 ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
1216
1217 ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
1218 ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
1219 ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
1220 ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
1221 ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
1222 ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
1223 ,P_REQUEST_ID IN NUMBER default hr_api.g_number
1224 ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
1225 ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
1226 ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
1227 ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1228 ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
1229 ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
1230 ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
1231 ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
1232 ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
1233
1234 ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
1235 ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
1236 ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
1237 ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
1238 ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
1239 ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
1240 ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
1241 ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
1242 ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
1243 ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
1244 ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
1245 ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
1246 ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
1247
1248 ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
1249 ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
1250 ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
1251 ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
1252 ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
1253 ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
1254 ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
1255 ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
1256 ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
1257 ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
1258 ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
1259 ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
1260 ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
1261 ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
1262 ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
1263 ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
1267 ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
1264 ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
1265 ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
1266 ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
1268 ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
1269 ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1270 ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
1271 ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
1272 ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
1273 ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
1274 ,P_VENDOR_ID IN NUMBER default hr_api.g_number
1275 ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
1276 ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
1277 ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1278 ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
1279 ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
1280 ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
1281 ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1282 ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
1283 ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
1284 ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
1285 ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date
1286 ,P_PAYROLL_ID_UPDATED OUT NOCOPY BOOLEAN
1287 ,P_OTHER_MANAGER_WARNING OUT NOCOPY BOOLEAN
1288 ,P_HOURLY_SALARIED_WARNING OUT NOCOPY BOOLEAN
1289 ,P_NO_MANAGERS_WARNING OUT NOCOPY BOOLEAN
1290 ,P_ORG_NOW_NO_MANAGER_WARNING OUT NOCOPY BOOLEAN
1291 ,P_VALIDATION_START_DATE OUT NOCOPY DATE
1292 ,P_VALIDATION_END_DATE OUT NOCOPY DATE
1293 ,P_EFFECTIVE_DATE IN DATE default null
1294 ,P_DATETRACK_MODE IN VARCHAR2 default hr_api.g_update
1295 ,P_VALIDATE IN BOOLEAN default false
1296 ,P_OFFER_ID IN OUT NOCOPY NUMBER
1297 ,P_OFFER_STATUS IN VARCHAR2 default null
1298 );
1299 --
1300 -- ----------------------------------------------------------------------------
1301 -- |-------------------------< delete_offer_assignment >----------------------|
1302 -- ----------------------------------------------------------------------------
1303 --
1304 -- {Start Of Comments}
1305 /*#
1306 * This API deletes an offer assignment and the offer associated with it.
1307 *
1308 *
1309 * <p><b>Licensing</b><br>
1310 * This API is licensed for use with iRecruitment.
1311 *
1312 * <p><b>Prerequisites</b><br>
1313 * An offer assignment should exist.
1314 *
1315 * <p><b>Post Success</b><br>
1316 * Both the offer assignment and the offer records will be deleted.
1317 *
1318 * <p><b>Post Failure</b><br>
1319 * If there is no offer associated with this assignment, then the API raises
1320 * an error.
1321 *
1322 * @param p_validate If true, then validation alone will be performed and the
1323 * database will remain unchanged. If false and all validation checks pass,
1324 * then the database will be modified.
1325 * @param p_effective_date Determines when the DateTrack operation comes into
1326 * force.
1327 * @param p_offer_assignment_id Offer assignment for the applicant where the
1328 * type is 'OFFER'.
1329 * @rep:displayname Delete Offer Assignment
1330 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
1331 * @rep:lifecycle active
1332 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1333 * @rep:scope public
1334 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1335 */
1336 --
1337 -- {End Of Comments}
1338 --
1339 procedure delete_offer_assignment
1340 ( P_VALIDATE IN boolean default false
1341 ,P_EFFECTIVE_DATE IN date default null
1342 ,P_OFFER_ASSIGNMENT_ID IN number
1343 );
1344 --
1345 -- ----------------------------------------------------------------------------
1346 -- |---------------------------< upload_offer_letter >------------------------|
1347 -- ----------------------------------------------------------------------------
1348 --
1349 -- {Start Of Comments}
1350 /*#
1351 * This API uploads the offer letter to the corresponding offer record.
1352 *
1353 *
1354 * <p><b>Licensing</b><br>
1355 * This API is licensed for use with iRecruitment.
1356 *
1357 * <p><b>Prerequisites</b><br>
1358 * The offer should exist.
1359 *
1360 * <p><b>Post Success</b><br>
1361 * The offer letter will be uploaded to the IRC_OFFERS table.
1362 *
1363 * <p><b>Post Failure</b><br>
1364 * Offer letter will not be uploaded and, an error is raised.
1365 *
1366 * @param p_validate If true, then validation alone will be performed and the
1367 * database will remain unchanged. If false and all validation checks pass,
1368 * then the database will be modified.
1369 * @param p_offer_letter Offer letter either generated when the offer is
1370 * extended or uploaded by the Super User.
1371 * @param p_offer_id Primary key of the offer in the IRC_OFFERS table.
1372 * @param p_object_version_number System generated version of row.
1373 * @rep:displayname Upload Offer Letter
1374 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
1375 * @rep:lifecycle active
1376 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1377 * @rep:scope public
1378 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1379 */
1380 --
1381 -- {End Of Comments}
1382 --
1383 procedure upload_offer_letter
1384 ( P_VALIDATE IN boolean default false
1385 ,P_OFFER_LETTER IN BLOB
1386 ,P_OFFER_ID IN NUMBER
1387 ,P_OBJECT_VERSION_NUMBER IN NUMBER
1388 );
1389 --
1390 -- ----------------------------------------------------------------------------
1391 -- |-----------------------< other_extended_offers_count >--------------------|
1392 -- ----------------------------------------------------------------------------
1393 --
1394 -- {Start Of Comments}
1395 /*#
1396 * This function returns the number of offers that have already been extended
1397 * or accepted by the candidate.
1398 *
1399 *
1400 * <p><b>Licensing</b><br>
1401 * This API is licensed for use with iRecruitment.
1402 *
1403 * <p><b>Prerequisites</b><br>
1404 * The applicant should exist.
1405 *
1406 * <p><b>Post Success</b><br>
1407 * The API returns the sum of extended and accepted offers for this
1408 * candidate.
1409 *
1410 * <p><b>Post Failure</b><br>
1411 * An error is raised.
1412 *
1413 * @param p_applicant_assignment_id Applicant assignment for the applicant
1414 * where the type is 'APPLICANT'.
1415 * @param p_effective_date Effective date for the creation
1416 * of the offer.
1417 * @param p_person_id The person ID for this applicant.
1418 * @param p_other_extended_offer_count Contains the sum of the extended and
1419 * accepted offers for this candidate.
1420 * @rep:displayname Other Extended Offers Count.
1421 * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER
1422 * @rep:lifecycle active
1423 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1424 * @rep:scope public
1425 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1426 */
1427 --
1428 -- {End Of Comments}
1429 --
1430 PROCEDURE other_extended_offers_count
1431 ( p_applicant_assignment_id IN NUMBER default null
1432 ,p_effective_date IN DATE
1433 ,p_person_id IN NUMBER default null
1434 ,p_other_extended_offer_count OUT nocopy NUMBER
1435 );
1436 --
1437 g_src_apl_asg_id number(15);
1438 --
1439 end IRC_OFFERS_API;