51: --
52: -- {end of comments}
53: -- ----------------------------------------------------------------------------
54: procedure update_dml
55: (p_rec in out nocopy irc_iof_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
129: exception
130: when hr_api.check_integrity_violated then
131: -- a check constraint has been violated
132: --
133: irc_iof_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
135: when hr_api.parent_integrity_violated then
136: -- parent integrity has been violated
137: --
134: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
135: when hr_api.parent_integrity_violated then
136: -- parent integrity has been violated
137: --
138: irc_iof_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
140: when hr_api.unique_integrity_violated then
141: -- unique integrity has been violated
142: --
139: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
140: when hr_api.unique_integrity_violated then
141: -- unique integrity has been violated
142: --
143: irc_iof_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
145: when others then
146: --
147: raise;
179: --
180: -- {end of comments}
181: -- ----------------------------------------------------------------------------
182: procedure pre_update
183: (p_rec in irc_iof_shd.g_rec_type
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
224: -- {end of comments}
225: -- ----------------------------------------------------------------------------
226: procedure post_update
227: (p_effective_date in date
228: ,p_rec in irc_iof_shd.g_rec_type
229: ) is
230: --
231: l_proc varchar2(72) := g_package||'post_update';
232: --
338: => p_rec.attribute30
339: ,p_object_version_number
340: => p_rec.object_version_number
341: ,p_offer_version_o
342: => irc_iof_shd.g_old_rec.offer_version
343: ,p_latest_offer_o
344: => irc_iof_shd.g_old_rec.latest_offer
345: ,p_offer_status_o
346: => irc_iof_shd.g_old_rec.offer_status
340: => p_rec.object_version_number
341: ,p_offer_version_o
342: => irc_iof_shd.g_old_rec.offer_version
343: ,p_latest_offer_o
344: => irc_iof_shd.g_old_rec.latest_offer
345: ,p_offer_status_o
346: => irc_iof_shd.g_old_rec.offer_status
347: ,p_discretionary_job_title_o
348: => irc_iof_shd.g_old_rec.discretionary_job_title
342: => irc_iof_shd.g_old_rec.offer_version
343: ,p_latest_offer_o
344: => irc_iof_shd.g_old_rec.latest_offer
345: ,p_offer_status_o
346: => irc_iof_shd.g_old_rec.offer_status
347: ,p_discretionary_job_title_o
348: => irc_iof_shd.g_old_rec.discretionary_job_title
349: ,p_offer_extended_method_o
350: => irc_iof_shd.g_old_rec.offer_extended_method
344: => irc_iof_shd.g_old_rec.latest_offer
345: ,p_offer_status_o
346: => irc_iof_shd.g_old_rec.offer_status
347: ,p_discretionary_job_title_o
348: => irc_iof_shd.g_old_rec.discretionary_job_title
349: ,p_offer_extended_method_o
350: => irc_iof_shd.g_old_rec.offer_extended_method
351: ,p_respondent_id_o
352: => irc_iof_shd.g_old_rec.respondent_id
346: => irc_iof_shd.g_old_rec.offer_status
347: ,p_discretionary_job_title_o
348: => irc_iof_shd.g_old_rec.discretionary_job_title
349: ,p_offer_extended_method_o
350: => irc_iof_shd.g_old_rec.offer_extended_method
351: ,p_respondent_id_o
352: => irc_iof_shd.g_old_rec.respondent_id
353: ,p_expiry_date_o
354: => irc_iof_shd.g_old_rec.expiry_date
348: => irc_iof_shd.g_old_rec.discretionary_job_title
349: ,p_offer_extended_method_o
350: => irc_iof_shd.g_old_rec.offer_extended_method
351: ,p_respondent_id_o
352: => irc_iof_shd.g_old_rec.respondent_id
353: ,p_expiry_date_o
354: => irc_iof_shd.g_old_rec.expiry_date
355: ,p_proposed_start_date_o
356: => irc_iof_shd.g_old_rec.proposed_start_date
350: => irc_iof_shd.g_old_rec.offer_extended_method
351: ,p_respondent_id_o
352: => irc_iof_shd.g_old_rec.respondent_id
353: ,p_expiry_date_o
354: => irc_iof_shd.g_old_rec.expiry_date
355: ,p_proposed_start_date_o
356: => irc_iof_shd.g_old_rec.proposed_start_date
357: ,p_offer_letter_tracking_code_o
358: => irc_iof_shd.g_old_rec.offer_letter_tracking_code
352: => irc_iof_shd.g_old_rec.respondent_id
353: ,p_expiry_date_o
354: => irc_iof_shd.g_old_rec.expiry_date
355: ,p_proposed_start_date_o
356: => irc_iof_shd.g_old_rec.proposed_start_date
357: ,p_offer_letter_tracking_code_o
358: => irc_iof_shd.g_old_rec.offer_letter_tracking_code
359: ,p_offer_postal_service_o
360: => irc_iof_shd.g_old_rec.offer_postal_service
354: => irc_iof_shd.g_old_rec.expiry_date
355: ,p_proposed_start_date_o
356: => irc_iof_shd.g_old_rec.proposed_start_date
357: ,p_offer_letter_tracking_code_o
358: => irc_iof_shd.g_old_rec.offer_letter_tracking_code
359: ,p_offer_postal_service_o
360: => irc_iof_shd.g_old_rec.offer_postal_service
361: ,p_offer_shipping_date_o
362: => irc_iof_shd.g_old_rec.offer_shipping_date
356: => irc_iof_shd.g_old_rec.proposed_start_date
357: ,p_offer_letter_tracking_code_o
358: => irc_iof_shd.g_old_rec.offer_letter_tracking_code
359: ,p_offer_postal_service_o
360: => irc_iof_shd.g_old_rec.offer_postal_service
361: ,p_offer_shipping_date_o
362: => irc_iof_shd.g_old_rec.offer_shipping_date
363: ,p_vacancy_id_o
364: => irc_iof_shd.g_old_rec.vacancy_id
358: => irc_iof_shd.g_old_rec.offer_letter_tracking_code
359: ,p_offer_postal_service_o
360: => irc_iof_shd.g_old_rec.offer_postal_service
361: ,p_offer_shipping_date_o
362: => irc_iof_shd.g_old_rec.offer_shipping_date
363: ,p_vacancy_id_o
364: => irc_iof_shd.g_old_rec.vacancy_id
365: ,p_applicant_assignment_id_o
366: => irc_iof_shd.g_old_rec.applicant_assignment_id
360: => irc_iof_shd.g_old_rec.offer_postal_service
361: ,p_offer_shipping_date_o
362: => irc_iof_shd.g_old_rec.offer_shipping_date
363: ,p_vacancy_id_o
364: => irc_iof_shd.g_old_rec.vacancy_id
365: ,p_applicant_assignment_id_o
366: => irc_iof_shd.g_old_rec.applicant_assignment_id
367: ,p_offer_assignment_id_o
368: => irc_iof_shd.g_old_rec.offer_assignment_id
362: => irc_iof_shd.g_old_rec.offer_shipping_date
363: ,p_vacancy_id_o
364: => irc_iof_shd.g_old_rec.vacancy_id
365: ,p_applicant_assignment_id_o
366: => irc_iof_shd.g_old_rec.applicant_assignment_id
367: ,p_offer_assignment_id_o
368: => irc_iof_shd.g_old_rec.offer_assignment_id
369: ,p_address_id_o
370: => irc_iof_shd.g_old_rec.address_id
364: => irc_iof_shd.g_old_rec.vacancy_id
365: ,p_applicant_assignment_id_o
366: => irc_iof_shd.g_old_rec.applicant_assignment_id
367: ,p_offer_assignment_id_o
368: => irc_iof_shd.g_old_rec.offer_assignment_id
369: ,p_address_id_o
370: => irc_iof_shd.g_old_rec.address_id
371: ,p_template_id_o
372: => irc_iof_shd.g_old_rec.template_id
366: => irc_iof_shd.g_old_rec.applicant_assignment_id
367: ,p_offer_assignment_id_o
368: => irc_iof_shd.g_old_rec.offer_assignment_id
369: ,p_address_id_o
370: => irc_iof_shd.g_old_rec.address_id
371: ,p_template_id_o
372: => irc_iof_shd.g_old_rec.template_id
373: ,p_offer_letter_file_type_o
374: => irc_iof_shd.g_old_rec.offer_letter_file_type
368: => irc_iof_shd.g_old_rec.offer_assignment_id
369: ,p_address_id_o
370: => irc_iof_shd.g_old_rec.address_id
371: ,p_template_id_o
372: => irc_iof_shd.g_old_rec.template_id
373: ,p_offer_letter_file_type_o
374: => irc_iof_shd.g_old_rec.offer_letter_file_type
375: ,p_offer_letter_file_name_o
376: => irc_iof_shd.g_old_rec.offer_letter_file_name
370: => irc_iof_shd.g_old_rec.address_id
371: ,p_template_id_o
372: => irc_iof_shd.g_old_rec.template_id
373: ,p_offer_letter_file_type_o
374: => irc_iof_shd.g_old_rec.offer_letter_file_type
375: ,p_offer_letter_file_name_o
376: => irc_iof_shd.g_old_rec.offer_letter_file_name
377: ,p_attribute_category_o
378: => irc_iof_shd.g_old_rec.attribute_category
372: => irc_iof_shd.g_old_rec.template_id
373: ,p_offer_letter_file_type_o
374: => irc_iof_shd.g_old_rec.offer_letter_file_type
375: ,p_offer_letter_file_name_o
376: => irc_iof_shd.g_old_rec.offer_letter_file_name
377: ,p_attribute_category_o
378: => irc_iof_shd.g_old_rec.attribute_category
379: ,p_attribute1_o
380: => irc_iof_shd.g_old_rec.attribute1
374: => irc_iof_shd.g_old_rec.offer_letter_file_type
375: ,p_offer_letter_file_name_o
376: => irc_iof_shd.g_old_rec.offer_letter_file_name
377: ,p_attribute_category_o
378: => irc_iof_shd.g_old_rec.attribute_category
379: ,p_attribute1_o
380: => irc_iof_shd.g_old_rec.attribute1
381: ,p_attribute2_o
382: => irc_iof_shd.g_old_rec.attribute2
376: => irc_iof_shd.g_old_rec.offer_letter_file_name
377: ,p_attribute_category_o
378: => irc_iof_shd.g_old_rec.attribute_category
379: ,p_attribute1_o
380: => irc_iof_shd.g_old_rec.attribute1
381: ,p_attribute2_o
382: => irc_iof_shd.g_old_rec.attribute2
383: ,p_attribute3_o
384: => irc_iof_shd.g_old_rec.attribute3
378: => irc_iof_shd.g_old_rec.attribute_category
379: ,p_attribute1_o
380: => irc_iof_shd.g_old_rec.attribute1
381: ,p_attribute2_o
382: => irc_iof_shd.g_old_rec.attribute2
383: ,p_attribute3_o
384: => irc_iof_shd.g_old_rec.attribute3
385: ,p_attribute4_o
386: => irc_iof_shd.g_old_rec.attribute4
380: => irc_iof_shd.g_old_rec.attribute1
381: ,p_attribute2_o
382: => irc_iof_shd.g_old_rec.attribute2
383: ,p_attribute3_o
384: => irc_iof_shd.g_old_rec.attribute3
385: ,p_attribute4_o
386: => irc_iof_shd.g_old_rec.attribute4
387: ,p_attribute5_o
388: => irc_iof_shd.g_old_rec.attribute5
382: => irc_iof_shd.g_old_rec.attribute2
383: ,p_attribute3_o
384: => irc_iof_shd.g_old_rec.attribute3
385: ,p_attribute4_o
386: => irc_iof_shd.g_old_rec.attribute4
387: ,p_attribute5_o
388: => irc_iof_shd.g_old_rec.attribute5
389: ,p_attribute6_o
390: => irc_iof_shd.g_old_rec.attribute6
384: => irc_iof_shd.g_old_rec.attribute3
385: ,p_attribute4_o
386: => irc_iof_shd.g_old_rec.attribute4
387: ,p_attribute5_o
388: => irc_iof_shd.g_old_rec.attribute5
389: ,p_attribute6_o
390: => irc_iof_shd.g_old_rec.attribute6
391: ,p_attribute7_o
392: => irc_iof_shd.g_old_rec.attribute7
386: => irc_iof_shd.g_old_rec.attribute4
387: ,p_attribute5_o
388: => irc_iof_shd.g_old_rec.attribute5
389: ,p_attribute6_o
390: => irc_iof_shd.g_old_rec.attribute6
391: ,p_attribute7_o
392: => irc_iof_shd.g_old_rec.attribute7
393: ,p_attribute8_o
394: => irc_iof_shd.g_old_rec.attribute8
388: => irc_iof_shd.g_old_rec.attribute5
389: ,p_attribute6_o
390: => irc_iof_shd.g_old_rec.attribute6
391: ,p_attribute7_o
392: => irc_iof_shd.g_old_rec.attribute7
393: ,p_attribute8_o
394: => irc_iof_shd.g_old_rec.attribute8
395: ,p_attribute9_o
396: => irc_iof_shd.g_old_rec.attribute9
390: => irc_iof_shd.g_old_rec.attribute6
391: ,p_attribute7_o
392: => irc_iof_shd.g_old_rec.attribute7
393: ,p_attribute8_o
394: => irc_iof_shd.g_old_rec.attribute8
395: ,p_attribute9_o
396: => irc_iof_shd.g_old_rec.attribute9
397: ,p_attribute10_o
398: => irc_iof_shd.g_old_rec.attribute10
392: => irc_iof_shd.g_old_rec.attribute7
393: ,p_attribute8_o
394: => irc_iof_shd.g_old_rec.attribute8
395: ,p_attribute9_o
396: => irc_iof_shd.g_old_rec.attribute9
397: ,p_attribute10_o
398: => irc_iof_shd.g_old_rec.attribute10
399: ,p_attribute11_o
400: => irc_iof_shd.g_old_rec.attribute11
394: => irc_iof_shd.g_old_rec.attribute8
395: ,p_attribute9_o
396: => irc_iof_shd.g_old_rec.attribute9
397: ,p_attribute10_o
398: => irc_iof_shd.g_old_rec.attribute10
399: ,p_attribute11_o
400: => irc_iof_shd.g_old_rec.attribute11
401: ,p_attribute12_o
402: => irc_iof_shd.g_old_rec.attribute12
396: => irc_iof_shd.g_old_rec.attribute9
397: ,p_attribute10_o
398: => irc_iof_shd.g_old_rec.attribute10
399: ,p_attribute11_o
400: => irc_iof_shd.g_old_rec.attribute11
401: ,p_attribute12_o
402: => irc_iof_shd.g_old_rec.attribute12
403: ,p_attribute13_o
404: => irc_iof_shd.g_old_rec.attribute13
398: => irc_iof_shd.g_old_rec.attribute10
399: ,p_attribute11_o
400: => irc_iof_shd.g_old_rec.attribute11
401: ,p_attribute12_o
402: => irc_iof_shd.g_old_rec.attribute12
403: ,p_attribute13_o
404: => irc_iof_shd.g_old_rec.attribute13
405: ,p_attribute14_o
406: => irc_iof_shd.g_old_rec.attribute14
400: => irc_iof_shd.g_old_rec.attribute11
401: ,p_attribute12_o
402: => irc_iof_shd.g_old_rec.attribute12
403: ,p_attribute13_o
404: => irc_iof_shd.g_old_rec.attribute13
405: ,p_attribute14_o
406: => irc_iof_shd.g_old_rec.attribute14
407: ,p_attribute15_o
408: => irc_iof_shd.g_old_rec.attribute15
402: => irc_iof_shd.g_old_rec.attribute12
403: ,p_attribute13_o
404: => irc_iof_shd.g_old_rec.attribute13
405: ,p_attribute14_o
406: => irc_iof_shd.g_old_rec.attribute14
407: ,p_attribute15_o
408: => irc_iof_shd.g_old_rec.attribute15
409: ,p_attribute16_o
410: => irc_iof_shd.g_old_rec.attribute16
404: => irc_iof_shd.g_old_rec.attribute13
405: ,p_attribute14_o
406: => irc_iof_shd.g_old_rec.attribute14
407: ,p_attribute15_o
408: => irc_iof_shd.g_old_rec.attribute15
409: ,p_attribute16_o
410: => irc_iof_shd.g_old_rec.attribute16
411: ,p_attribute17_o
412: => irc_iof_shd.g_old_rec.attribute17
406: => irc_iof_shd.g_old_rec.attribute14
407: ,p_attribute15_o
408: => irc_iof_shd.g_old_rec.attribute15
409: ,p_attribute16_o
410: => irc_iof_shd.g_old_rec.attribute16
411: ,p_attribute17_o
412: => irc_iof_shd.g_old_rec.attribute17
413: ,p_attribute18_o
414: => irc_iof_shd.g_old_rec.attribute18
408: => irc_iof_shd.g_old_rec.attribute15
409: ,p_attribute16_o
410: => irc_iof_shd.g_old_rec.attribute16
411: ,p_attribute17_o
412: => irc_iof_shd.g_old_rec.attribute17
413: ,p_attribute18_o
414: => irc_iof_shd.g_old_rec.attribute18
415: ,p_attribute19_o
416: => irc_iof_shd.g_old_rec.attribute19
410: => irc_iof_shd.g_old_rec.attribute16
411: ,p_attribute17_o
412: => irc_iof_shd.g_old_rec.attribute17
413: ,p_attribute18_o
414: => irc_iof_shd.g_old_rec.attribute18
415: ,p_attribute19_o
416: => irc_iof_shd.g_old_rec.attribute19
417: ,p_attribute20_o
418: => irc_iof_shd.g_old_rec.attribute20
412: => irc_iof_shd.g_old_rec.attribute17
413: ,p_attribute18_o
414: => irc_iof_shd.g_old_rec.attribute18
415: ,p_attribute19_o
416: => irc_iof_shd.g_old_rec.attribute19
417: ,p_attribute20_o
418: => irc_iof_shd.g_old_rec.attribute20
419: ,p_attribute21_o
420: => irc_iof_shd.g_old_rec.attribute21
414: => irc_iof_shd.g_old_rec.attribute18
415: ,p_attribute19_o
416: => irc_iof_shd.g_old_rec.attribute19
417: ,p_attribute20_o
418: => irc_iof_shd.g_old_rec.attribute20
419: ,p_attribute21_o
420: => irc_iof_shd.g_old_rec.attribute21
421: ,p_attribute22_o
422: => irc_iof_shd.g_old_rec.attribute22
416: => irc_iof_shd.g_old_rec.attribute19
417: ,p_attribute20_o
418: => irc_iof_shd.g_old_rec.attribute20
419: ,p_attribute21_o
420: => irc_iof_shd.g_old_rec.attribute21
421: ,p_attribute22_o
422: => irc_iof_shd.g_old_rec.attribute22
423: ,p_attribute23_o
424: => irc_iof_shd.g_old_rec.attribute23
418: => irc_iof_shd.g_old_rec.attribute20
419: ,p_attribute21_o
420: => irc_iof_shd.g_old_rec.attribute21
421: ,p_attribute22_o
422: => irc_iof_shd.g_old_rec.attribute22
423: ,p_attribute23_o
424: => irc_iof_shd.g_old_rec.attribute23
425: ,p_attribute24_o
426: => irc_iof_shd.g_old_rec.attribute24
420: => irc_iof_shd.g_old_rec.attribute21
421: ,p_attribute22_o
422: => irc_iof_shd.g_old_rec.attribute22
423: ,p_attribute23_o
424: => irc_iof_shd.g_old_rec.attribute23
425: ,p_attribute24_o
426: => irc_iof_shd.g_old_rec.attribute24
427: ,p_attribute25_o
428: => irc_iof_shd.g_old_rec.attribute25
422: => irc_iof_shd.g_old_rec.attribute22
423: ,p_attribute23_o
424: => irc_iof_shd.g_old_rec.attribute23
425: ,p_attribute24_o
426: => irc_iof_shd.g_old_rec.attribute24
427: ,p_attribute25_o
428: => irc_iof_shd.g_old_rec.attribute25
429: ,p_attribute26_o
430: => irc_iof_shd.g_old_rec.attribute26
424: => irc_iof_shd.g_old_rec.attribute23
425: ,p_attribute24_o
426: => irc_iof_shd.g_old_rec.attribute24
427: ,p_attribute25_o
428: => irc_iof_shd.g_old_rec.attribute25
429: ,p_attribute26_o
430: => irc_iof_shd.g_old_rec.attribute26
431: ,p_attribute27_o
432: => irc_iof_shd.g_old_rec.attribute27
426: => irc_iof_shd.g_old_rec.attribute24
427: ,p_attribute25_o
428: => irc_iof_shd.g_old_rec.attribute25
429: ,p_attribute26_o
430: => irc_iof_shd.g_old_rec.attribute26
431: ,p_attribute27_o
432: => irc_iof_shd.g_old_rec.attribute27
433: ,p_attribute28_o
434: => irc_iof_shd.g_old_rec.attribute28
428: => irc_iof_shd.g_old_rec.attribute25
429: ,p_attribute26_o
430: => irc_iof_shd.g_old_rec.attribute26
431: ,p_attribute27_o
432: => irc_iof_shd.g_old_rec.attribute27
433: ,p_attribute28_o
434: => irc_iof_shd.g_old_rec.attribute28
435: ,p_attribute29_o
436: => irc_iof_shd.g_old_rec.attribute29
430: => irc_iof_shd.g_old_rec.attribute26
431: ,p_attribute27_o
432: => irc_iof_shd.g_old_rec.attribute27
433: ,p_attribute28_o
434: => irc_iof_shd.g_old_rec.attribute28
435: ,p_attribute29_o
436: => irc_iof_shd.g_old_rec.attribute29
437: ,p_attribute30_o
438: => irc_iof_shd.g_old_rec.attribute30
432: => irc_iof_shd.g_old_rec.attribute27
433: ,p_attribute28_o
434: => irc_iof_shd.g_old_rec.attribute28
435: ,p_attribute29_o
436: => irc_iof_shd.g_old_rec.attribute29
437: ,p_attribute30_o
438: => irc_iof_shd.g_old_rec.attribute30
439: ,p_object_version_number_o
440: => irc_iof_shd.g_old_rec.object_version_number
434: => irc_iof_shd.g_old_rec.attribute28
435: ,p_attribute29_o
436: => irc_iof_shd.g_old_rec.attribute29
437: ,p_attribute30_o
438: => irc_iof_shd.g_old_rec.attribute30
439: ,p_object_version_number_o
440: => irc_iof_shd.g_old_rec.object_version_number
441: );
442: --
436: => irc_iof_shd.g_old_rec.attribute29
437: ,p_attribute30_o
438: => irc_iof_shd.g_old_rec.attribute30
439: ,p_object_version_number_o
440: => irc_iof_shd.g_old_rec.object_version_number
441: );
442: --
443: exception
444: --
496: --
497: -- {end of comments}
498: -- ----------------------------------------------------------------------------
499: procedure convert_defs
500: (p_rec in out nocopy irc_iof_shd.g_rec_type
501: ) is
502: --
503: begin
504: --
508: -- is being used then we must set to the 'current' argument value.
509: --
510: if (p_rec.offer_version = hr_api.g_number) then
511: p_rec.offer_version :=
512: irc_iof_shd.g_old_rec.offer_version;
513: end if;
514: if (p_rec.latest_offer = hr_api.g_varchar2) then
515: p_rec.latest_offer :=
516: irc_iof_shd.g_old_rec.latest_offer;
512: irc_iof_shd.g_old_rec.offer_version;
513: end if;
514: if (p_rec.latest_offer = hr_api.g_varchar2) then
515: p_rec.latest_offer :=
516: irc_iof_shd.g_old_rec.latest_offer;
517: end if;
518: if (p_rec.offer_status = hr_api.g_varchar2) then
519: p_rec.offer_status :=
520: irc_iof_shd.g_old_rec.offer_status;
516: irc_iof_shd.g_old_rec.latest_offer;
517: end if;
518: if (p_rec.offer_status = hr_api.g_varchar2) then
519: p_rec.offer_status :=
520: irc_iof_shd.g_old_rec.offer_status;
521: end if;
522: if (p_rec.discretionary_job_title = hr_api.g_varchar2) then
523: p_rec.discretionary_job_title :=
524: irc_iof_shd.g_old_rec.discretionary_job_title;
520: irc_iof_shd.g_old_rec.offer_status;
521: end if;
522: if (p_rec.discretionary_job_title = hr_api.g_varchar2) then
523: p_rec.discretionary_job_title :=
524: irc_iof_shd.g_old_rec.discretionary_job_title;
525: end if;
526: if (p_rec.offer_extended_method = hr_api.g_varchar2) then
527: p_rec.offer_extended_method :=
528: irc_iof_shd.g_old_rec.offer_extended_method;
524: irc_iof_shd.g_old_rec.discretionary_job_title;
525: end if;
526: if (p_rec.offer_extended_method = hr_api.g_varchar2) then
527: p_rec.offer_extended_method :=
528: irc_iof_shd.g_old_rec.offer_extended_method;
529: end if;
530: if (p_rec.respondent_id = hr_api.g_number) then
531: p_rec.respondent_id :=
532: irc_iof_shd.g_old_rec.respondent_id;
528: irc_iof_shd.g_old_rec.offer_extended_method;
529: end if;
530: if (p_rec.respondent_id = hr_api.g_number) then
531: p_rec.respondent_id :=
532: irc_iof_shd.g_old_rec.respondent_id;
533: end if;
534: if (p_rec.expiry_date = hr_api.g_date) then
535: p_rec.expiry_date :=
536: irc_iof_shd.g_old_rec.expiry_date;
532: irc_iof_shd.g_old_rec.respondent_id;
533: end if;
534: if (p_rec.expiry_date = hr_api.g_date) then
535: p_rec.expiry_date :=
536: irc_iof_shd.g_old_rec.expiry_date;
537: end if;
538: if (p_rec.proposed_start_date = hr_api.g_date) then
539: p_rec.proposed_start_date :=
540: irc_iof_shd.g_old_rec.proposed_start_date;
536: irc_iof_shd.g_old_rec.expiry_date;
537: end if;
538: if (p_rec.proposed_start_date = hr_api.g_date) then
539: p_rec.proposed_start_date :=
540: irc_iof_shd.g_old_rec.proposed_start_date;
541: end if;
542: if (p_rec.offer_letter_tracking_code = hr_api.g_varchar2) then
543: p_rec.offer_letter_tracking_code :=
544: irc_iof_shd.g_old_rec.offer_letter_tracking_code;
540: irc_iof_shd.g_old_rec.proposed_start_date;
541: end if;
542: if (p_rec.offer_letter_tracking_code = hr_api.g_varchar2) then
543: p_rec.offer_letter_tracking_code :=
544: irc_iof_shd.g_old_rec.offer_letter_tracking_code;
545: end if;
546: if (p_rec.offer_postal_service = hr_api.g_varchar2) then
547: p_rec.offer_postal_service :=
548: irc_iof_shd.g_old_rec.offer_postal_service;
544: irc_iof_shd.g_old_rec.offer_letter_tracking_code;
545: end if;
546: if (p_rec.offer_postal_service = hr_api.g_varchar2) then
547: p_rec.offer_postal_service :=
548: irc_iof_shd.g_old_rec.offer_postal_service;
549: end if;
550: if (p_rec.offer_shipping_date = hr_api.g_date) then
551: p_rec.offer_shipping_date :=
552: irc_iof_shd.g_old_rec.offer_shipping_date;
548: irc_iof_shd.g_old_rec.offer_postal_service;
549: end if;
550: if (p_rec.offer_shipping_date = hr_api.g_date) then
551: p_rec.offer_shipping_date :=
552: irc_iof_shd.g_old_rec.offer_shipping_date;
553: end if;
554: if (p_rec.vacancy_id = hr_api.g_number) then
555: p_rec.vacancy_id :=
556: irc_iof_shd.g_old_rec.vacancy_id;
552: irc_iof_shd.g_old_rec.offer_shipping_date;
553: end if;
554: if (p_rec.vacancy_id = hr_api.g_number) then
555: p_rec.vacancy_id :=
556: irc_iof_shd.g_old_rec.vacancy_id;
557: end if;
558: if (p_rec.applicant_assignment_id = hr_api.g_number) then
559: p_rec.applicant_assignment_id :=
560: irc_iof_shd.g_old_rec.applicant_assignment_id;
556: irc_iof_shd.g_old_rec.vacancy_id;
557: end if;
558: if (p_rec.applicant_assignment_id = hr_api.g_number) then
559: p_rec.applicant_assignment_id :=
560: irc_iof_shd.g_old_rec.applicant_assignment_id;
561: end if;
562: if (p_rec.offer_assignment_id = hr_api.g_number) then
563: p_rec.offer_assignment_id :=
564: irc_iof_shd.g_old_rec.offer_assignment_id;
560: irc_iof_shd.g_old_rec.applicant_assignment_id;
561: end if;
562: if (p_rec.offer_assignment_id = hr_api.g_number) then
563: p_rec.offer_assignment_id :=
564: irc_iof_shd.g_old_rec.offer_assignment_id;
565: end if;
566: if (p_rec.address_id = hr_api.g_number) then
567: p_rec.address_id :=
568: irc_iof_shd.g_old_rec.address_id;
564: irc_iof_shd.g_old_rec.offer_assignment_id;
565: end if;
566: if (p_rec.address_id = hr_api.g_number) then
567: p_rec.address_id :=
568: irc_iof_shd.g_old_rec.address_id;
569: end if;
570: if (p_rec.template_id = hr_api.g_number) then
571: p_rec.template_id :=
572: irc_iof_shd.g_old_rec.template_id;
568: irc_iof_shd.g_old_rec.address_id;
569: end if;
570: if (p_rec.template_id = hr_api.g_number) then
571: p_rec.template_id :=
572: irc_iof_shd.g_old_rec.template_id;
573: end if;
574: if (p_rec.offer_letter_file_type = hr_api.g_varchar2) then
575: p_rec.offer_letter_file_type :=
576: irc_iof_shd.g_old_rec.offer_letter_file_type;
572: irc_iof_shd.g_old_rec.template_id;
573: end if;
574: if (p_rec.offer_letter_file_type = hr_api.g_varchar2) then
575: p_rec.offer_letter_file_type :=
576: irc_iof_shd.g_old_rec.offer_letter_file_type;
577: end if;
578: if (p_rec.offer_letter_file_name = hr_api.g_varchar2) then
579: p_rec.offer_letter_file_name :=
580: irc_iof_shd.g_old_rec.offer_letter_file_name;
576: irc_iof_shd.g_old_rec.offer_letter_file_type;
577: end if;
578: if (p_rec.offer_letter_file_name = hr_api.g_varchar2) then
579: p_rec.offer_letter_file_name :=
580: irc_iof_shd.g_old_rec.offer_letter_file_name;
581: end if;
582: if (p_rec.attribute_category = hr_api.g_varchar2) then
583: p_rec.attribute_category :=
584: irc_iof_shd.g_old_rec.attribute_category;
580: irc_iof_shd.g_old_rec.offer_letter_file_name;
581: end if;
582: if (p_rec.attribute_category = hr_api.g_varchar2) then
583: p_rec.attribute_category :=
584: irc_iof_shd.g_old_rec.attribute_category;
585: end if;
586: if (p_rec.attribute1 = hr_api.g_varchar2) then
587: p_rec.attribute1 :=
588: irc_iof_shd.g_old_rec.attribute1;
584: irc_iof_shd.g_old_rec.attribute_category;
585: end if;
586: if (p_rec.attribute1 = hr_api.g_varchar2) then
587: p_rec.attribute1 :=
588: irc_iof_shd.g_old_rec.attribute1;
589: end if;
590: if (p_rec.attribute2 = hr_api.g_varchar2) then
591: p_rec.attribute2 :=
592: irc_iof_shd.g_old_rec.attribute2;
588: irc_iof_shd.g_old_rec.attribute1;
589: end if;
590: if (p_rec.attribute2 = hr_api.g_varchar2) then
591: p_rec.attribute2 :=
592: irc_iof_shd.g_old_rec.attribute2;
593: end if;
594: if (p_rec.attribute3 = hr_api.g_varchar2) then
595: p_rec.attribute3 :=
596: irc_iof_shd.g_old_rec.attribute3;
592: irc_iof_shd.g_old_rec.attribute2;
593: end if;
594: if (p_rec.attribute3 = hr_api.g_varchar2) then
595: p_rec.attribute3 :=
596: irc_iof_shd.g_old_rec.attribute3;
597: end if;
598: if (p_rec.attribute4 = hr_api.g_varchar2) then
599: p_rec.attribute4 :=
600: irc_iof_shd.g_old_rec.attribute4;
596: irc_iof_shd.g_old_rec.attribute3;
597: end if;
598: if (p_rec.attribute4 = hr_api.g_varchar2) then
599: p_rec.attribute4 :=
600: irc_iof_shd.g_old_rec.attribute4;
601: end if;
602: if (p_rec.attribute5 = hr_api.g_varchar2) then
603: p_rec.attribute5 :=
604: irc_iof_shd.g_old_rec.attribute5;
600: irc_iof_shd.g_old_rec.attribute4;
601: end if;
602: if (p_rec.attribute5 = hr_api.g_varchar2) then
603: p_rec.attribute5 :=
604: irc_iof_shd.g_old_rec.attribute5;
605: end if;
606: if (p_rec.attribute6 = hr_api.g_varchar2) then
607: p_rec.attribute6 :=
608: irc_iof_shd.g_old_rec.attribute6;
604: irc_iof_shd.g_old_rec.attribute5;
605: end if;
606: if (p_rec.attribute6 = hr_api.g_varchar2) then
607: p_rec.attribute6 :=
608: irc_iof_shd.g_old_rec.attribute6;
609: end if;
610: if (p_rec.attribute7 = hr_api.g_varchar2) then
611: p_rec.attribute7 :=
612: irc_iof_shd.g_old_rec.attribute7;
608: irc_iof_shd.g_old_rec.attribute6;
609: end if;
610: if (p_rec.attribute7 = hr_api.g_varchar2) then
611: p_rec.attribute7 :=
612: irc_iof_shd.g_old_rec.attribute7;
613: end if;
614: if (p_rec.attribute8 = hr_api.g_varchar2) then
615: p_rec.attribute8 :=
616: irc_iof_shd.g_old_rec.attribute8;
612: irc_iof_shd.g_old_rec.attribute7;
613: end if;
614: if (p_rec.attribute8 = hr_api.g_varchar2) then
615: p_rec.attribute8 :=
616: irc_iof_shd.g_old_rec.attribute8;
617: end if;
618: if (p_rec.attribute9 = hr_api.g_varchar2) then
619: p_rec.attribute9 :=
620: irc_iof_shd.g_old_rec.attribute9;
616: irc_iof_shd.g_old_rec.attribute8;
617: end if;
618: if (p_rec.attribute9 = hr_api.g_varchar2) then
619: p_rec.attribute9 :=
620: irc_iof_shd.g_old_rec.attribute9;
621: end if;
622: if (p_rec.attribute10 = hr_api.g_varchar2) then
623: p_rec.attribute10 :=
624: irc_iof_shd.g_old_rec.attribute10;
620: irc_iof_shd.g_old_rec.attribute9;
621: end if;
622: if (p_rec.attribute10 = hr_api.g_varchar2) then
623: p_rec.attribute10 :=
624: irc_iof_shd.g_old_rec.attribute10;
625: end if;
626: if (p_rec.attribute11 = hr_api.g_varchar2) then
627: p_rec.attribute11 :=
628: irc_iof_shd.g_old_rec.attribute11;
624: irc_iof_shd.g_old_rec.attribute10;
625: end if;
626: if (p_rec.attribute11 = hr_api.g_varchar2) then
627: p_rec.attribute11 :=
628: irc_iof_shd.g_old_rec.attribute11;
629: end if;
630: if (p_rec.attribute12 = hr_api.g_varchar2) then
631: p_rec.attribute12 :=
632: irc_iof_shd.g_old_rec.attribute12;
628: irc_iof_shd.g_old_rec.attribute11;
629: end if;
630: if (p_rec.attribute12 = hr_api.g_varchar2) then
631: p_rec.attribute12 :=
632: irc_iof_shd.g_old_rec.attribute12;
633: end if;
634: if (p_rec.attribute13 = hr_api.g_varchar2) then
635: p_rec.attribute13 :=
636: irc_iof_shd.g_old_rec.attribute13;
632: irc_iof_shd.g_old_rec.attribute12;
633: end if;
634: if (p_rec.attribute13 = hr_api.g_varchar2) then
635: p_rec.attribute13 :=
636: irc_iof_shd.g_old_rec.attribute13;
637: end if;
638: if (p_rec.attribute14 = hr_api.g_varchar2) then
639: p_rec.attribute14 :=
640: irc_iof_shd.g_old_rec.attribute14;
636: irc_iof_shd.g_old_rec.attribute13;
637: end if;
638: if (p_rec.attribute14 = hr_api.g_varchar2) then
639: p_rec.attribute14 :=
640: irc_iof_shd.g_old_rec.attribute14;
641: end if;
642: if (p_rec.attribute15 = hr_api.g_varchar2) then
643: p_rec.attribute15 :=
644: irc_iof_shd.g_old_rec.attribute15;
640: irc_iof_shd.g_old_rec.attribute14;
641: end if;
642: if (p_rec.attribute15 = hr_api.g_varchar2) then
643: p_rec.attribute15 :=
644: irc_iof_shd.g_old_rec.attribute15;
645: end if;
646: if (p_rec.attribute16 = hr_api.g_varchar2) then
647: p_rec.attribute16 :=
648: irc_iof_shd.g_old_rec.attribute16;
644: irc_iof_shd.g_old_rec.attribute15;
645: end if;
646: if (p_rec.attribute16 = hr_api.g_varchar2) then
647: p_rec.attribute16 :=
648: irc_iof_shd.g_old_rec.attribute16;
649: end if;
650: if (p_rec.attribute17 = hr_api.g_varchar2) then
651: p_rec.attribute17 :=
652: irc_iof_shd.g_old_rec.attribute17;
648: irc_iof_shd.g_old_rec.attribute16;
649: end if;
650: if (p_rec.attribute17 = hr_api.g_varchar2) then
651: p_rec.attribute17 :=
652: irc_iof_shd.g_old_rec.attribute17;
653: end if;
654: if (p_rec.attribute18 = hr_api.g_varchar2) then
655: p_rec.attribute18 :=
656: irc_iof_shd.g_old_rec.attribute18;
652: irc_iof_shd.g_old_rec.attribute17;
653: end if;
654: if (p_rec.attribute18 = hr_api.g_varchar2) then
655: p_rec.attribute18 :=
656: irc_iof_shd.g_old_rec.attribute18;
657: end if;
658: if (p_rec.attribute19 = hr_api.g_varchar2) then
659: p_rec.attribute19 :=
660: irc_iof_shd.g_old_rec.attribute19;
656: irc_iof_shd.g_old_rec.attribute18;
657: end if;
658: if (p_rec.attribute19 = hr_api.g_varchar2) then
659: p_rec.attribute19 :=
660: irc_iof_shd.g_old_rec.attribute19;
661: end if;
662: if (p_rec.attribute20 = hr_api.g_varchar2) then
663: p_rec.attribute20 :=
664: irc_iof_shd.g_old_rec.attribute20;
660: irc_iof_shd.g_old_rec.attribute19;
661: end if;
662: if (p_rec.attribute20 = hr_api.g_varchar2) then
663: p_rec.attribute20 :=
664: irc_iof_shd.g_old_rec.attribute20;
665: end if;
666: if (p_rec.attribute21 = hr_api.g_varchar2) then
667: p_rec.attribute21 :=
668: irc_iof_shd.g_old_rec.attribute21;
664: irc_iof_shd.g_old_rec.attribute20;
665: end if;
666: if (p_rec.attribute21 = hr_api.g_varchar2) then
667: p_rec.attribute21 :=
668: irc_iof_shd.g_old_rec.attribute21;
669: end if;
670: if (p_rec.attribute22 = hr_api.g_varchar2) then
671: p_rec.attribute22 :=
672: irc_iof_shd.g_old_rec.attribute22;
668: irc_iof_shd.g_old_rec.attribute21;
669: end if;
670: if (p_rec.attribute22 = hr_api.g_varchar2) then
671: p_rec.attribute22 :=
672: irc_iof_shd.g_old_rec.attribute22;
673: end if;
674: if (p_rec.attribute23 = hr_api.g_varchar2) then
675: p_rec.attribute23 :=
676: irc_iof_shd.g_old_rec.attribute23;
672: irc_iof_shd.g_old_rec.attribute22;
673: end if;
674: if (p_rec.attribute23 = hr_api.g_varchar2) then
675: p_rec.attribute23 :=
676: irc_iof_shd.g_old_rec.attribute23;
677: end if;
678: if (p_rec.attribute24 = hr_api.g_varchar2) then
679: p_rec.attribute24 :=
680: irc_iof_shd.g_old_rec.attribute24;
676: irc_iof_shd.g_old_rec.attribute23;
677: end if;
678: if (p_rec.attribute24 = hr_api.g_varchar2) then
679: p_rec.attribute24 :=
680: irc_iof_shd.g_old_rec.attribute24;
681: end if;
682: if (p_rec.attribute25 = hr_api.g_varchar2) then
683: p_rec.attribute25 :=
684: irc_iof_shd.g_old_rec.attribute25;
680: irc_iof_shd.g_old_rec.attribute24;
681: end if;
682: if (p_rec.attribute25 = hr_api.g_varchar2) then
683: p_rec.attribute25 :=
684: irc_iof_shd.g_old_rec.attribute25;
685: end if;
686: if (p_rec.attribute26 = hr_api.g_varchar2) then
687: p_rec.attribute26 :=
688: irc_iof_shd.g_old_rec.attribute26;
684: irc_iof_shd.g_old_rec.attribute25;
685: end if;
686: if (p_rec.attribute26 = hr_api.g_varchar2) then
687: p_rec.attribute26 :=
688: irc_iof_shd.g_old_rec.attribute26;
689: end if;
690: if (p_rec.attribute27 = hr_api.g_varchar2) then
691: p_rec.attribute27 :=
692: irc_iof_shd.g_old_rec.attribute27;
688: irc_iof_shd.g_old_rec.attribute26;
689: end if;
690: if (p_rec.attribute27 = hr_api.g_varchar2) then
691: p_rec.attribute27 :=
692: irc_iof_shd.g_old_rec.attribute27;
693: end if;
694: if (p_rec.attribute28 = hr_api.g_varchar2) then
695: p_rec.attribute28 :=
696: irc_iof_shd.g_old_rec.attribute28;
692: irc_iof_shd.g_old_rec.attribute27;
693: end if;
694: if (p_rec.attribute28 = hr_api.g_varchar2) then
695: p_rec.attribute28 :=
696: irc_iof_shd.g_old_rec.attribute28;
697: end if;
698: if (p_rec.attribute29 = hr_api.g_varchar2) then
699: p_rec.attribute29 :=
700: irc_iof_shd.g_old_rec.attribute29;
696: irc_iof_shd.g_old_rec.attribute28;
697: end if;
698: if (p_rec.attribute29 = hr_api.g_varchar2) then
699: p_rec.attribute29 :=
700: irc_iof_shd.g_old_rec.attribute29;
701: end if;
702: if (p_rec.attribute30 = hr_api.g_varchar2) then
703: p_rec.attribute30 :=
704: irc_iof_shd.g_old_rec.attribute30;
700: irc_iof_shd.g_old_rec.attribute29;
701: end if;
702: if (p_rec.attribute30 = hr_api.g_varchar2) then
703: p_rec.attribute30 :=
704: irc_iof_shd.g_old_rec.attribute30;
705: end if;
706: --
707: end convert_defs;
708: --
710: -- |---------------------------------< upd >----------------------------------|
711: -- ----------------------------------------------------------------------------
712: procedure upd
713: (p_effective_date in date
714: ,p_rec in out nocopy irc_iof_shd.g_rec_type
715: ) is
716: --
717: l_proc varchar2(72) := g_package||'upd';
718: --
720: hr_utility.set_location('entering:'||l_proc, 5);
721: --
722: -- we must lock the row which we need to update.
723: --
724: irc_iof_shd.lck
725: (p_rec.offer_id
726: ,p_rec.object_version_number
727: );
728: --
816: ,p_attribute29 in varchar2 default hr_api.g_varchar2
817: ,p_attribute30 in varchar2 default hr_api.g_varchar2
818: ) is
819: --
820: l_rec irc_iof_shd.g_rec_type;
821: l_proc varchar2(72) := g_package||'upd';
822: --
823: begin
824: hr_utility.set_location('entering:'||l_proc, 5);
826: -- call conversion function to turn arguments into the
827: -- l_rec structure.
828: --
829: l_rec :=
830: irc_iof_shd.convert_args
831: (p_offer_id
832: ,hr_api.g_number -- offer_version
833: ,p_latest_offer
834: ,p_offer_status