51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy irc_ipc_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: irc_ipc_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the irc_posting_contents Row
69: --
70: update irc_posting_contents
143: ,manager_email = p_rec.manager_email
144: ,manager_work_telephone = p_rec.manager_work_telephone
145: where posting_content_id = p_rec.posting_content_id;
146: --
147: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: --
151: Exception
150: --
151: Exception
152: When hr_api.check_integrity_violated Then
153: -- A check constraint has been violated
154: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
155: --
156: irc_ipc_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
152: When hr_api.check_integrity_violated Then
153: -- A check constraint has been violated
154: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
155: --
156: irc_ipc_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
156: irc_ipc_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
161: --
162: irc_ipc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
161: --
162: irc_ipc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
162: irc_ipc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
167: --
168: irc_ipc_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
167: --
168: irc_ipc_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
171: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
172: --
167: --
168: irc_ipc_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
171: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
172: --
173: Raise;
174: End update_dml;
175: --
205: --
206: -- {End Of Comments}
207: -- ----------------------------------------------------------------------------
208: Procedure pre_update
209: (p_rec in irc_ipc_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72) := g_package||'pre_update';
213: --
249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure post_update
253: (p_rec in irc_ipc_shd.g_rec_type
254: ) is
255: --
256: l_proc varchar2(72) := g_package||'post_update';
257: --
406: => p_rec.manager_email
407: ,p_manager_work_telephone
408: => p_rec.manager_work_telephone
409: ,p_display_manager_info_o
410: => irc_ipc_shd.g_old_rec.display_manager_info
411: ,p_display_recruiter_info_o
412: => irc_ipc_shd.g_old_rec.display_recruiter_info
413: ,p_attribute_category_o
414: => irc_ipc_shd.g_old_rec.attribute_category
408: => p_rec.manager_work_telephone
409: ,p_display_manager_info_o
410: => irc_ipc_shd.g_old_rec.display_manager_info
411: ,p_display_recruiter_info_o
412: => irc_ipc_shd.g_old_rec.display_recruiter_info
413: ,p_attribute_category_o
414: => irc_ipc_shd.g_old_rec.attribute_category
415: ,p_attribute1_o
416: => irc_ipc_shd.g_old_rec.attribute1
410: => irc_ipc_shd.g_old_rec.display_manager_info
411: ,p_display_recruiter_info_o
412: => irc_ipc_shd.g_old_rec.display_recruiter_info
413: ,p_attribute_category_o
414: => irc_ipc_shd.g_old_rec.attribute_category
415: ,p_attribute1_o
416: => irc_ipc_shd.g_old_rec.attribute1
417: ,p_attribute2_o
418: => irc_ipc_shd.g_old_rec.attribute2
412: => irc_ipc_shd.g_old_rec.display_recruiter_info
413: ,p_attribute_category_o
414: => irc_ipc_shd.g_old_rec.attribute_category
415: ,p_attribute1_o
416: => irc_ipc_shd.g_old_rec.attribute1
417: ,p_attribute2_o
418: => irc_ipc_shd.g_old_rec.attribute2
419: ,p_attribute3_o
420: => irc_ipc_shd.g_old_rec.attribute3
414: => irc_ipc_shd.g_old_rec.attribute_category
415: ,p_attribute1_o
416: => irc_ipc_shd.g_old_rec.attribute1
417: ,p_attribute2_o
418: => irc_ipc_shd.g_old_rec.attribute2
419: ,p_attribute3_o
420: => irc_ipc_shd.g_old_rec.attribute3
421: ,p_attribute4_o
422: => irc_ipc_shd.g_old_rec.attribute4
416: => irc_ipc_shd.g_old_rec.attribute1
417: ,p_attribute2_o
418: => irc_ipc_shd.g_old_rec.attribute2
419: ,p_attribute3_o
420: => irc_ipc_shd.g_old_rec.attribute3
421: ,p_attribute4_o
422: => irc_ipc_shd.g_old_rec.attribute4
423: ,p_attribute5_o
424: => irc_ipc_shd.g_old_rec.attribute5
418: => irc_ipc_shd.g_old_rec.attribute2
419: ,p_attribute3_o
420: => irc_ipc_shd.g_old_rec.attribute3
421: ,p_attribute4_o
422: => irc_ipc_shd.g_old_rec.attribute4
423: ,p_attribute5_o
424: => irc_ipc_shd.g_old_rec.attribute5
425: ,p_attribute6_o
426: => irc_ipc_shd.g_old_rec.attribute6
420: => irc_ipc_shd.g_old_rec.attribute3
421: ,p_attribute4_o
422: => irc_ipc_shd.g_old_rec.attribute4
423: ,p_attribute5_o
424: => irc_ipc_shd.g_old_rec.attribute5
425: ,p_attribute6_o
426: => irc_ipc_shd.g_old_rec.attribute6
427: ,p_attribute7_o
428: => irc_ipc_shd.g_old_rec.attribute7
422: => irc_ipc_shd.g_old_rec.attribute4
423: ,p_attribute5_o
424: => irc_ipc_shd.g_old_rec.attribute5
425: ,p_attribute6_o
426: => irc_ipc_shd.g_old_rec.attribute6
427: ,p_attribute7_o
428: => irc_ipc_shd.g_old_rec.attribute7
429: ,p_attribute8_o
430: => irc_ipc_shd.g_old_rec.attribute8
424: => irc_ipc_shd.g_old_rec.attribute5
425: ,p_attribute6_o
426: => irc_ipc_shd.g_old_rec.attribute6
427: ,p_attribute7_o
428: => irc_ipc_shd.g_old_rec.attribute7
429: ,p_attribute8_o
430: => irc_ipc_shd.g_old_rec.attribute8
431: ,p_attribute9_o
432: => irc_ipc_shd.g_old_rec.attribute9
426: => irc_ipc_shd.g_old_rec.attribute6
427: ,p_attribute7_o
428: => irc_ipc_shd.g_old_rec.attribute7
429: ,p_attribute8_o
430: => irc_ipc_shd.g_old_rec.attribute8
431: ,p_attribute9_o
432: => irc_ipc_shd.g_old_rec.attribute9
433: ,p_attribute10_o
434: => irc_ipc_shd.g_old_rec.attribute10
428: => irc_ipc_shd.g_old_rec.attribute7
429: ,p_attribute8_o
430: => irc_ipc_shd.g_old_rec.attribute8
431: ,p_attribute9_o
432: => irc_ipc_shd.g_old_rec.attribute9
433: ,p_attribute10_o
434: => irc_ipc_shd.g_old_rec.attribute10
435: ,p_attribute11_o
436: => irc_ipc_shd.g_old_rec.attribute11
430: => irc_ipc_shd.g_old_rec.attribute8
431: ,p_attribute9_o
432: => irc_ipc_shd.g_old_rec.attribute9
433: ,p_attribute10_o
434: => irc_ipc_shd.g_old_rec.attribute10
435: ,p_attribute11_o
436: => irc_ipc_shd.g_old_rec.attribute11
437: ,p_attribute12_o
438: => irc_ipc_shd.g_old_rec.attribute12
432: => irc_ipc_shd.g_old_rec.attribute9
433: ,p_attribute10_o
434: => irc_ipc_shd.g_old_rec.attribute10
435: ,p_attribute11_o
436: => irc_ipc_shd.g_old_rec.attribute11
437: ,p_attribute12_o
438: => irc_ipc_shd.g_old_rec.attribute12
439: ,p_attribute13_o
440: => irc_ipc_shd.g_old_rec.attribute13
434: => irc_ipc_shd.g_old_rec.attribute10
435: ,p_attribute11_o
436: => irc_ipc_shd.g_old_rec.attribute11
437: ,p_attribute12_o
438: => irc_ipc_shd.g_old_rec.attribute12
439: ,p_attribute13_o
440: => irc_ipc_shd.g_old_rec.attribute13
441: ,p_attribute14_o
442: => irc_ipc_shd.g_old_rec.attribute14
436: => irc_ipc_shd.g_old_rec.attribute11
437: ,p_attribute12_o
438: => irc_ipc_shd.g_old_rec.attribute12
439: ,p_attribute13_o
440: => irc_ipc_shd.g_old_rec.attribute13
441: ,p_attribute14_o
442: => irc_ipc_shd.g_old_rec.attribute14
443: ,p_attribute15_o
444: => irc_ipc_shd.g_old_rec.attribute15
438: => irc_ipc_shd.g_old_rec.attribute12
439: ,p_attribute13_o
440: => irc_ipc_shd.g_old_rec.attribute13
441: ,p_attribute14_o
442: => irc_ipc_shd.g_old_rec.attribute14
443: ,p_attribute15_o
444: => irc_ipc_shd.g_old_rec.attribute15
445: ,p_attribute16_o
446: => irc_ipc_shd.g_old_rec.attribute16
440: => irc_ipc_shd.g_old_rec.attribute13
441: ,p_attribute14_o
442: => irc_ipc_shd.g_old_rec.attribute14
443: ,p_attribute15_o
444: => irc_ipc_shd.g_old_rec.attribute15
445: ,p_attribute16_o
446: => irc_ipc_shd.g_old_rec.attribute16
447: ,p_attribute17_o
448: => irc_ipc_shd.g_old_rec.attribute17
442: => irc_ipc_shd.g_old_rec.attribute14
443: ,p_attribute15_o
444: => irc_ipc_shd.g_old_rec.attribute15
445: ,p_attribute16_o
446: => irc_ipc_shd.g_old_rec.attribute16
447: ,p_attribute17_o
448: => irc_ipc_shd.g_old_rec.attribute17
449: ,p_attribute18_o
450: => irc_ipc_shd.g_old_rec.attribute18
444: => irc_ipc_shd.g_old_rec.attribute15
445: ,p_attribute16_o
446: => irc_ipc_shd.g_old_rec.attribute16
447: ,p_attribute17_o
448: => irc_ipc_shd.g_old_rec.attribute17
449: ,p_attribute18_o
450: => irc_ipc_shd.g_old_rec.attribute18
451: ,p_attribute19_o
452: => irc_ipc_shd.g_old_rec.attribute19
446: => irc_ipc_shd.g_old_rec.attribute16
447: ,p_attribute17_o
448: => irc_ipc_shd.g_old_rec.attribute17
449: ,p_attribute18_o
450: => irc_ipc_shd.g_old_rec.attribute18
451: ,p_attribute19_o
452: => irc_ipc_shd.g_old_rec.attribute19
453: ,p_attribute20_o
454: => irc_ipc_shd.g_old_rec.attribute20
448: => irc_ipc_shd.g_old_rec.attribute17
449: ,p_attribute18_o
450: => irc_ipc_shd.g_old_rec.attribute18
451: ,p_attribute19_o
452: => irc_ipc_shd.g_old_rec.attribute19
453: ,p_attribute20_o
454: => irc_ipc_shd.g_old_rec.attribute20
455: ,p_attribute21_o
456: => irc_ipc_shd.g_old_rec.attribute21
450: => irc_ipc_shd.g_old_rec.attribute18
451: ,p_attribute19_o
452: => irc_ipc_shd.g_old_rec.attribute19
453: ,p_attribute20_o
454: => irc_ipc_shd.g_old_rec.attribute20
455: ,p_attribute21_o
456: => irc_ipc_shd.g_old_rec.attribute21
457: ,p_attribute22_o
458: => irc_ipc_shd.g_old_rec.attribute22
452: => irc_ipc_shd.g_old_rec.attribute19
453: ,p_attribute20_o
454: => irc_ipc_shd.g_old_rec.attribute20
455: ,p_attribute21_o
456: => irc_ipc_shd.g_old_rec.attribute21
457: ,p_attribute22_o
458: => irc_ipc_shd.g_old_rec.attribute22
459: ,p_attribute23_o
460: => irc_ipc_shd.g_old_rec.attribute23
454: => irc_ipc_shd.g_old_rec.attribute20
455: ,p_attribute21_o
456: => irc_ipc_shd.g_old_rec.attribute21
457: ,p_attribute22_o
458: => irc_ipc_shd.g_old_rec.attribute22
459: ,p_attribute23_o
460: => irc_ipc_shd.g_old_rec.attribute23
461: ,p_attribute24_o
462: => irc_ipc_shd.g_old_rec.attribute24
456: => irc_ipc_shd.g_old_rec.attribute21
457: ,p_attribute22_o
458: => irc_ipc_shd.g_old_rec.attribute22
459: ,p_attribute23_o
460: => irc_ipc_shd.g_old_rec.attribute23
461: ,p_attribute24_o
462: => irc_ipc_shd.g_old_rec.attribute24
463: ,p_attribute25_o
464: => irc_ipc_shd.g_old_rec.attribute25
458: => irc_ipc_shd.g_old_rec.attribute22
459: ,p_attribute23_o
460: => irc_ipc_shd.g_old_rec.attribute23
461: ,p_attribute24_o
462: => irc_ipc_shd.g_old_rec.attribute24
463: ,p_attribute25_o
464: => irc_ipc_shd.g_old_rec.attribute25
465: ,p_attribute26_o
466: => irc_ipc_shd.g_old_rec.attribute26
460: => irc_ipc_shd.g_old_rec.attribute23
461: ,p_attribute24_o
462: => irc_ipc_shd.g_old_rec.attribute24
463: ,p_attribute25_o
464: => irc_ipc_shd.g_old_rec.attribute25
465: ,p_attribute26_o
466: => irc_ipc_shd.g_old_rec.attribute26
467: ,p_attribute27_o
468: => irc_ipc_shd.g_old_rec.attribute27
462: => irc_ipc_shd.g_old_rec.attribute24
463: ,p_attribute25_o
464: => irc_ipc_shd.g_old_rec.attribute25
465: ,p_attribute26_o
466: => irc_ipc_shd.g_old_rec.attribute26
467: ,p_attribute27_o
468: => irc_ipc_shd.g_old_rec.attribute27
469: ,p_attribute28_o
470: => irc_ipc_shd.g_old_rec.attribute28
464: => irc_ipc_shd.g_old_rec.attribute25
465: ,p_attribute26_o
466: => irc_ipc_shd.g_old_rec.attribute26
467: ,p_attribute27_o
468: => irc_ipc_shd.g_old_rec.attribute27
469: ,p_attribute28_o
470: => irc_ipc_shd.g_old_rec.attribute28
471: ,p_attribute29_o
472: => irc_ipc_shd.g_old_rec.attribute29
466: => irc_ipc_shd.g_old_rec.attribute26
467: ,p_attribute27_o
468: => irc_ipc_shd.g_old_rec.attribute27
469: ,p_attribute28_o
470: => irc_ipc_shd.g_old_rec.attribute28
471: ,p_attribute29_o
472: => irc_ipc_shd.g_old_rec.attribute29
473: ,p_attribute30_o
474: => irc_ipc_shd.g_old_rec.attribute30
468: => irc_ipc_shd.g_old_rec.attribute27
469: ,p_attribute28_o
470: => irc_ipc_shd.g_old_rec.attribute28
471: ,p_attribute29_o
472: => irc_ipc_shd.g_old_rec.attribute29
473: ,p_attribute30_o
474: => irc_ipc_shd.g_old_rec.attribute30
475: ,p_ipc_information_category_o
476: => irc_ipc_shd.g_old_rec.ipc_information_category
470: => irc_ipc_shd.g_old_rec.attribute28
471: ,p_attribute29_o
472: => irc_ipc_shd.g_old_rec.attribute29
473: ,p_attribute30_o
474: => irc_ipc_shd.g_old_rec.attribute30
475: ,p_ipc_information_category_o
476: => irc_ipc_shd.g_old_rec.ipc_information_category
477: ,p_ipc_information1_o
478: => irc_ipc_shd.g_old_rec.ipc_information1
472: => irc_ipc_shd.g_old_rec.attribute29
473: ,p_attribute30_o
474: => irc_ipc_shd.g_old_rec.attribute30
475: ,p_ipc_information_category_o
476: => irc_ipc_shd.g_old_rec.ipc_information_category
477: ,p_ipc_information1_o
478: => irc_ipc_shd.g_old_rec.ipc_information1
479: ,p_ipc_information2_o
480: => irc_ipc_shd.g_old_rec.ipc_information2
474: => irc_ipc_shd.g_old_rec.attribute30
475: ,p_ipc_information_category_o
476: => irc_ipc_shd.g_old_rec.ipc_information_category
477: ,p_ipc_information1_o
478: => irc_ipc_shd.g_old_rec.ipc_information1
479: ,p_ipc_information2_o
480: => irc_ipc_shd.g_old_rec.ipc_information2
481: ,p_ipc_information3_o
482: => irc_ipc_shd.g_old_rec.ipc_information3
476: => irc_ipc_shd.g_old_rec.ipc_information_category
477: ,p_ipc_information1_o
478: => irc_ipc_shd.g_old_rec.ipc_information1
479: ,p_ipc_information2_o
480: => irc_ipc_shd.g_old_rec.ipc_information2
481: ,p_ipc_information3_o
482: => irc_ipc_shd.g_old_rec.ipc_information3
483: ,p_ipc_information4_o
484: => irc_ipc_shd.g_old_rec.ipc_information4
478: => irc_ipc_shd.g_old_rec.ipc_information1
479: ,p_ipc_information2_o
480: => irc_ipc_shd.g_old_rec.ipc_information2
481: ,p_ipc_information3_o
482: => irc_ipc_shd.g_old_rec.ipc_information3
483: ,p_ipc_information4_o
484: => irc_ipc_shd.g_old_rec.ipc_information4
485: ,p_ipc_information5_o
486: => irc_ipc_shd.g_old_rec.ipc_information5
480: => irc_ipc_shd.g_old_rec.ipc_information2
481: ,p_ipc_information3_o
482: => irc_ipc_shd.g_old_rec.ipc_information3
483: ,p_ipc_information4_o
484: => irc_ipc_shd.g_old_rec.ipc_information4
485: ,p_ipc_information5_o
486: => irc_ipc_shd.g_old_rec.ipc_information5
487: ,p_ipc_information6_o
488: => irc_ipc_shd.g_old_rec.ipc_information6
482: => irc_ipc_shd.g_old_rec.ipc_information3
483: ,p_ipc_information4_o
484: => irc_ipc_shd.g_old_rec.ipc_information4
485: ,p_ipc_information5_o
486: => irc_ipc_shd.g_old_rec.ipc_information5
487: ,p_ipc_information6_o
488: => irc_ipc_shd.g_old_rec.ipc_information6
489: ,p_ipc_information7_o
490: => irc_ipc_shd.g_old_rec.ipc_information7
484: => irc_ipc_shd.g_old_rec.ipc_information4
485: ,p_ipc_information5_o
486: => irc_ipc_shd.g_old_rec.ipc_information5
487: ,p_ipc_information6_o
488: => irc_ipc_shd.g_old_rec.ipc_information6
489: ,p_ipc_information7_o
490: => irc_ipc_shd.g_old_rec.ipc_information7
491: ,p_ipc_information8_o
492: => irc_ipc_shd.g_old_rec.ipc_information8
486: => irc_ipc_shd.g_old_rec.ipc_information5
487: ,p_ipc_information6_o
488: => irc_ipc_shd.g_old_rec.ipc_information6
489: ,p_ipc_information7_o
490: => irc_ipc_shd.g_old_rec.ipc_information7
491: ,p_ipc_information8_o
492: => irc_ipc_shd.g_old_rec.ipc_information8
493: ,p_ipc_information9_o
494: => irc_ipc_shd.g_old_rec.ipc_information9
488: => irc_ipc_shd.g_old_rec.ipc_information6
489: ,p_ipc_information7_o
490: => irc_ipc_shd.g_old_rec.ipc_information7
491: ,p_ipc_information8_o
492: => irc_ipc_shd.g_old_rec.ipc_information8
493: ,p_ipc_information9_o
494: => irc_ipc_shd.g_old_rec.ipc_information9
495: ,p_ipc_information10_o
496: => irc_ipc_shd.g_old_rec.ipc_information10
490: => irc_ipc_shd.g_old_rec.ipc_information7
491: ,p_ipc_information8_o
492: => irc_ipc_shd.g_old_rec.ipc_information8
493: ,p_ipc_information9_o
494: => irc_ipc_shd.g_old_rec.ipc_information9
495: ,p_ipc_information10_o
496: => irc_ipc_shd.g_old_rec.ipc_information10
497: ,p_ipc_information11_o
498: => irc_ipc_shd.g_old_rec.ipc_information11
492: => irc_ipc_shd.g_old_rec.ipc_information8
493: ,p_ipc_information9_o
494: => irc_ipc_shd.g_old_rec.ipc_information9
495: ,p_ipc_information10_o
496: => irc_ipc_shd.g_old_rec.ipc_information10
497: ,p_ipc_information11_o
498: => irc_ipc_shd.g_old_rec.ipc_information11
499: ,p_ipc_information12_o
500: => irc_ipc_shd.g_old_rec.ipc_information12
494: => irc_ipc_shd.g_old_rec.ipc_information9
495: ,p_ipc_information10_o
496: => irc_ipc_shd.g_old_rec.ipc_information10
497: ,p_ipc_information11_o
498: => irc_ipc_shd.g_old_rec.ipc_information11
499: ,p_ipc_information12_o
500: => irc_ipc_shd.g_old_rec.ipc_information12
501: ,p_ipc_information13_o
502: => irc_ipc_shd.g_old_rec.ipc_information13
496: => irc_ipc_shd.g_old_rec.ipc_information10
497: ,p_ipc_information11_o
498: => irc_ipc_shd.g_old_rec.ipc_information11
499: ,p_ipc_information12_o
500: => irc_ipc_shd.g_old_rec.ipc_information12
501: ,p_ipc_information13_o
502: => irc_ipc_shd.g_old_rec.ipc_information13
503: ,p_ipc_information14_o
504: => irc_ipc_shd.g_old_rec.ipc_information14
498: => irc_ipc_shd.g_old_rec.ipc_information11
499: ,p_ipc_information12_o
500: => irc_ipc_shd.g_old_rec.ipc_information12
501: ,p_ipc_information13_o
502: => irc_ipc_shd.g_old_rec.ipc_information13
503: ,p_ipc_information14_o
504: => irc_ipc_shd.g_old_rec.ipc_information14
505: ,p_ipc_information15_o
506: => irc_ipc_shd.g_old_rec.ipc_information15
500: => irc_ipc_shd.g_old_rec.ipc_information12
501: ,p_ipc_information13_o
502: => irc_ipc_shd.g_old_rec.ipc_information13
503: ,p_ipc_information14_o
504: => irc_ipc_shd.g_old_rec.ipc_information14
505: ,p_ipc_information15_o
506: => irc_ipc_shd.g_old_rec.ipc_information15
507: ,p_ipc_information16_o
508: => irc_ipc_shd.g_old_rec.ipc_information16
502: => irc_ipc_shd.g_old_rec.ipc_information13
503: ,p_ipc_information14_o
504: => irc_ipc_shd.g_old_rec.ipc_information14
505: ,p_ipc_information15_o
506: => irc_ipc_shd.g_old_rec.ipc_information15
507: ,p_ipc_information16_o
508: => irc_ipc_shd.g_old_rec.ipc_information16
509: ,p_ipc_information17_o
510: => irc_ipc_shd.g_old_rec.ipc_information17
504: => irc_ipc_shd.g_old_rec.ipc_information14
505: ,p_ipc_information15_o
506: => irc_ipc_shd.g_old_rec.ipc_information15
507: ,p_ipc_information16_o
508: => irc_ipc_shd.g_old_rec.ipc_information16
509: ,p_ipc_information17_o
510: => irc_ipc_shd.g_old_rec.ipc_information17
511: ,p_ipc_information18_o
512: => irc_ipc_shd.g_old_rec.ipc_information18
506: => irc_ipc_shd.g_old_rec.ipc_information15
507: ,p_ipc_information16_o
508: => irc_ipc_shd.g_old_rec.ipc_information16
509: ,p_ipc_information17_o
510: => irc_ipc_shd.g_old_rec.ipc_information17
511: ,p_ipc_information18_o
512: => irc_ipc_shd.g_old_rec.ipc_information18
513: ,p_ipc_information19_o
514: => irc_ipc_shd.g_old_rec.ipc_information19
508: => irc_ipc_shd.g_old_rec.ipc_information16
509: ,p_ipc_information17_o
510: => irc_ipc_shd.g_old_rec.ipc_information17
511: ,p_ipc_information18_o
512: => irc_ipc_shd.g_old_rec.ipc_information18
513: ,p_ipc_information19_o
514: => irc_ipc_shd.g_old_rec.ipc_information19
515: ,p_ipc_information20_o
516: => irc_ipc_shd.g_old_rec.ipc_information20
510: => irc_ipc_shd.g_old_rec.ipc_information17
511: ,p_ipc_information18_o
512: => irc_ipc_shd.g_old_rec.ipc_information18
513: ,p_ipc_information19_o
514: => irc_ipc_shd.g_old_rec.ipc_information19
515: ,p_ipc_information20_o
516: => irc_ipc_shd.g_old_rec.ipc_information20
517: ,p_ipc_information21_o
518: => irc_ipc_shd.g_old_rec.ipc_information21
512: => irc_ipc_shd.g_old_rec.ipc_information18
513: ,p_ipc_information19_o
514: => irc_ipc_shd.g_old_rec.ipc_information19
515: ,p_ipc_information20_o
516: => irc_ipc_shd.g_old_rec.ipc_information20
517: ,p_ipc_information21_o
518: => irc_ipc_shd.g_old_rec.ipc_information21
519: ,p_ipc_information22_o
520: => irc_ipc_shd.g_old_rec.ipc_information22
514: => irc_ipc_shd.g_old_rec.ipc_information19
515: ,p_ipc_information20_o
516: => irc_ipc_shd.g_old_rec.ipc_information20
517: ,p_ipc_information21_o
518: => irc_ipc_shd.g_old_rec.ipc_information21
519: ,p_ipc_information22_o
520: => irc_ipc_shd.g_old_rec.ipc_information22
521: ,p_ipc_information23_o
522: => irc_ipc_shd.g_old_rec.ipc_information23
516: => irc_ipc_shd.g_old_rec.ipc_information20
517: ,p_ipc_information21_o
518: => irc_ipc_shd.g_old_rec.ipc_information21
519: ,p_ipc_information22_o
520: => irc_ipc_shd.g_old_rec.ipc_information22
521: ,p_ipc_information23_o
522: => irc_ipc_shd.g_old_rec.ipc_information23
523: ,p_ipc_information24_o
524: => irc_ipc_shd.g_old_rec.ipc_information24
518: => irc_ipc_shd.g_old_rec.ipc_information21
519: ,p_ipc_information22_o
520: => irc_ipc_shd.g_old_rec.ipc_information22
521: ,p_ipc_information23_o
522: => irc_ipc_shd.g_old_rec.ipc_information23
523: ,p_ipc_information24_o
524: => irc_ipc_shd.g_old_rec.ipc_information24
525: ,p_ipc_information25_o
526: => irc_ipc_shd.g_old_rec.ipc_information25
520: => irc_ipc_shd.g_old_rec.ipc_information22
521: ,p_ipc_information23_o
522: => irc_ipc_shd.g_old_rec.ipc_information23
523: ,p_ipc_information24_o
524: => irc_ipc_shd.g_old_rec.ipc_information24
525: ,p_ipc_information25_o
526: => irc_ipc_shd.g_old_rec.ipc_information25
527: ,p_ipc_information26_o
528: => irc_ipc_shd.g_old_rec.ipc_information26
522: => irc_ipc_shd.g_old_rec.ipc_information23
523: ,p_ipc_information24_o
524: => irc_ipc_shd.g_old_rec.ipc_information24
525: ,p_ipc_information25_o
526: => irc_ipc_shd.g_old_rec.ipc_information25
527: ,p_ipc_information26_o
528: => irc_ipc_shd.g_old_rec.ipc_information26
529: ,p_ipc_information27_o
530: => irc_ipc_shd.g_old_rec.ipc_information27
524: => irc_ipc_shd.g_old_rec.ipc_information24
525: ,p_ipc_information25_o
526: => irc_ipc_shd.g_old_rec.ipc_information25
527: ,p_ipc_information26_o
528: => irc_ipc_shd.g_old_rec.ipc_information26
529: ,p_ipc_information27_o
530: => irc_ipc_shd.g_old_rec.ipc_information27
531: ,p_ipc_information28_o
532: => irc_ipc_shd.g_old_rec.ipc_information28
526: => irc_ipc_shd.g_old_rec.ipc_information25
527: ,p_ipc_information26_o
528: => irc_ipc_shd.g_old_rec.ipc_information26
529: ,p_ipc_information27_o
530: => irc_ipc_shd.g_old_rec.ipc_information27
531: ,p_ipc_information28_o
532: => irc_ipc_shd.g_old_rec.ipc_information28
533: ,p_ipc_information29_o
534: => irc_ipc_shd.g_old_rec.ipc_information29
528: => irc_ipc_shd.g_old_rec.ipc_information26
529: ,p_ipc_information27_o
530: => irc_ipc_shd.g_old_rec.ipc_information27
531: ,p_ipc_information28_o
532: => irc_ipc_shd.g_old_rec.ipc_information28
533: ,p_ipc_information29_o
534: => irc_ipc_shd.g_old_rec.ipc_information29
535: ,p_ipc_information30_o
536: => irc_ipc_shd.g_old_rec.ipc_information30
530: => irc_ipc_shd.g_old_rec.ipc_information27
531: ,p_ipc_information28_o
532: => irc_ipc_shd.g_old_rec.ipc_information28
533: ,p_ipc_information29_o
534: => irc_ipc_shd.g_old_rec.ipc_information29
535: ,p_ipc_information30_o
536: => irc_ipc_shd.g_old_rec.ipc_information30
537: ,p_object_version_number_o
538: => irc_ipc_shd.g_old_rec.object_version_number
532: => irc_ipc_shd.g_old_rec.ipc_information28
533: ,p_ipc_information29_o
534: => irc_ipc_shd.g_old_rec.ipc_information29
535: ,p_ipc_information30_o
536: => irc_ipc_shd.g_old_rec.ipc_information30
537: ,p_object_version_number_o
538: => irc_ipc_shd.g_old_rec.object_version_number
539: ,p_date_approved_o
540: => irc_ipc_shd.g_old_rec.date_approved
534: => irc_ipc_shd.g_old_rec.ipc_information29
535: ,p_ipc_information30_o
536: => irc_ipc_shd.g_old_rec.ipc_information30
537: ,p_object_version_number_o
538: => irc_ipc_shd.g_old_rec.object_version_number
539: ,p_date_approved_o
540: => irc_ipc_shd.g_old_rec.date_approved
541: ,p_recruiter_full_name_o
542: => p_rec.recruiter_full_name
536: => irc_ipc_shd.g_old_rec.ipc_information30
537: ,p_object_version_number_o
538: => irc_ipc_shd.g_old_rec.object_version_number
539: ,p_date_approved_o
540: => irc_ipc_shd.g_old_rec.date_approved
541: ,p_recruiter_full_name_o
542: => p_rec.recruiter_full_name
543: ,p_recruiter_email_o
544: => p_rec.recruiter_email
608: --
609: -- {End Of Comments}
610: -- ----------------------------------------------------------------------------
611: Procedure convert_defs
612: (p_rec in out nocopy irc_ipc_shd.g_rec_type
613: ) is
614: --
615: Begin
616: --
620: -- is being used then we must set to the 'current' argument value.
621: --
622: If (p_rec.display_manager_info = hr_api.g_varchar2) then
623: p_rec.display_manager_info :=
624: irc_ipc_shd.g_old_rec.display_manager_info;
625: End If;
626: If (p_rec.display_recruiter_info = hr_api.g_varchar2) then
627: p_rec.display_recruiter_info :=
628: irc_ipc_shd.g_old_rec.display_recruiter_info;
624: irc_ipc_shd.g_old_rec.display_manager_info;
625: End If;
626: If (p_rec.display_recruiter_info = hr_api.g_varchar2) then
627: p_rec.display_recruiter_info :=
628: irc_ipc_shd.g_old_rec.display_recruiter_info;
629: End If;
630: If (p_rec.attribute_category = hr_api.g_varchar2) then
631: p_rec.attribute_category :=
632: irc_ipc_shd.g_old_rec.attribute_category;
628: irc_ipc_shd.g_old_rec.display_recruiter_info;
629: End If;
630: If (p_rec.attribute_category = hr_api.g_varchar2) then
631: p_rec.attribute_category :=
632: irc_ipc_shd.g_old_rec.attribute_category;
633: End If;
634: If (p_rec.attribute1 = hr_api.g_varchar2) then
635: p_rec.attribute1 :=
636: irc_ipc_shd.g_old_rec.attribute1;
632: irc_ipc_shd.g_old_rec.attribute_category;
633: End If;
634: If (p_rec.attribute1 = hr_api.g_varchar2) then
635: p_rec.attribute1 :=
636: irc_ipc_shd.g_old_rec.attribute1;
637: End If;
638: If (p_rec.attribute2 = hr_api.g_varchar2) then
639: p_rec.attribute2 :=
640: irc_ipc_shd.g_old_rec.attribute2;
636: irc_ipc_shd.g_old_rec.attribute1;
637: End If;
638: If (p_rec.attribute2 = hr_api.g_varchar2) then
639: p_rec.attribute2 :=
640: irc_ipc_shd.g_old_rec.attribute2;
641: End If;
642: If (p_rec.attribute3 = hr_api.g_varchar2) then
643: p_rec.attribute3 :=
644: irc_ipc_shd.g_old_rec.attribute3;
640: irc_ipc_shd.g_old_rec.attribute2;
641: End If;
642: If (p_rec.attribute3 = hr_api.g_varchar2) then
643: p_rec.attribute3 :=
644: irc_ipc_shd.g_old_rec.attribute3;
645: End If;
646: If (p_rec.attribute4 = hr_api.g_varchar2) then
647: p_rec.attribute4 :=
648: irc_ipc_shd.g_old_rec.attribute4;
644: irc_ipc_shd.g_old_rec.attribute3;
645: End If;
646: If (p_rec.attribute4 = hr_api.g_varchar2) then
647: p_rec.attribute4 :=
648: irc_ipc_shd.g_old_rec.attribute4;
649: End If;
650: If (p_rec.attribute5 = hr_api.g_varchar2) then
651: p_rec.attribute5 :=
652: irc_ipc_shd.g_old_rec.attribute5;
648: irc_ipc_shd.g_old_rec.attribute4;
649: End If;
650: If (p_rec.attribute5 = hr_api.g_varchar2) then
651: p_rec.attribute5 :=
652: irc_ipc_shd.g_old_rec.attribute5;
653: End If;
654: If (p_rec.attribute6 = hr_api.g_varchar2) then
655: p_rec.attribute6 :=
656: irc_ipc_shd.g_old_rec.attribute6;
652: irc_ipc_shd.g_old_rec.attribute5;
653: End If;
654: If (p_rec.attribute6 = hr_api.g_varchar2) then
655: p_rec.attribute6 :=
656: irc_ipc_shd.g_old_rec.attribute6;
657: End If;
658: If (p_rec.attribute7 = hr_api.g_varchar2) then
659: p_rec.attribute7 :=
660: irc_ipc_shd.g_old_rec.attribute7;
656: irc_ipc_shd.g_old_rec.attribute6;
657: End If;
658: If (p_rec.attribute7 = hr_api.g_varchar2) then
659: p_rec.attribute7 :=
660: irc_ipc_shd.g_old_rec.attribute7;
661: End If;
662: If (p_rec.attribute8 = hr_api.g_varchar2) then
663: p_rec.attribute8 :=
664: irc_ipc_shd.g_old_rec.attribute8;
660: irc_ipc_shd.g_old_rec.attribute7;
661: End If;
662: If (p_rec.attribute8 = hr_api.g_varchar2) then
663: p_rec.attribute8 :=
664: irc_ipc_shd.g_old_rec.attribute8;
665: End If;
666: If (p_rec.attribute9 = hr_api.g_varchar2) then
667: p_rec.attribute9 :=
668: irc_ipc_shd.g_old_rec.attribute9;
664: irc_ipc_shd.g_old_rec.attribute8;
665: End If;
666: If (p_rec.attribute9 = hr_api.g_varchar2) then
667: p_rec.attribute9 :=
668: irc_ipc_shd.g_old_rec.attribute9;
669: End If;
670: If (p_rec.attribute10 = hr_api.g_varchar2) then
671: p_rec.attribute10 :=
672: irc_ipc_shd.g_old_rec.attribute10;
668: irc_ipc_shd.g_old_rec.attribute9;
669: End If;
670: If (p_rec.attribute10 = hr_api.g_varchar2) then
671: p_rec.attribute10 :=
672: irc_ipc_shd.g_old_rec.attribute10;
673: End If;
674: If (p_rec.attribute11 = hr_api.g_varchar2) then
675: p_rec.attribute11 :=
676: irc_ipc_shd.g_old_rec.attribute11;
672: irc_ipc_shd.g_old_rec.attribute10;
673: End If;
674: If (p_rec.attribute11 = hr_api.g_varchar2) then
675: p_rec.attribute11 :=
676: irc_ipc_shd.g_old_rec.attribute11;
677: End If;
678: If (p_rec.attribute12 = hr_api.g_varchar2) then
679: p_rec.attribute12 :=
680: irc_ipc_shd.g_old_rec.attribute12;
676: irc_ipc_shd.g_old_rec.attribute11;
677: End If;
678: If (p_rec.attribute12 = hr_api.g_varchar2) then
679: p_rec.attribute12 :=
680: irc_ipc_shd.g_old_rec.attribute12;
681: End If;
682: If (p_rec.attribute13 = hr_api.g_varchar2) then
683: p_rec.attribute13 :=
684: irc_ipc_shd.g_old_rec.attribute13;
680: irc_ipc_shd.g_old_rec.attribute12;
681: End If;
682: If (p_rec.attribute13 = hr_api.g_varchar2) then
683: p_rec.attribute13 :=
684: irc_ipc_shd.g_old_rec.attribute13;
685: End If;
686: If (p_rec.attribute14 = hr_api.g_varchar2) then
687: p_rec.attribute14 :=
688: irc_ipc_shd.g_old_rec.attribute14;
684: irc_ipc_shd.g_old_rec.attribute13;
685: End If;
686: If (p_rec.attribute14 = hr_api.g_varchar2) then
687: p_rec.attribute14 :=
688: irc_ipc_shd.g_old_rec.attribute14;
689: End If;
690: If (p_rec.attribute15 = hr_api.g_varchar2) then
691: p_rec.attribute15 :=
692: irc_ipc_shd.g_old_rec.attribute15;
688: irc_ipc_shd.g_old_rec.attribute14;
689: End If;
690: If (p_rec.attribute15 = hr_api.g_varchar2) then
691: p_rec.attribute15 :=
692: irc_ipc_shd.g_old_rec.attribute15;
693: End If;
694: If (p_rec.attribute16 = hr_api.g_varchar2) then
695: p_rec.attribute16 :=
696: irc_ipc_shd.g_old_rec.attribute16;
692: irc_ipc_shd.g_old_rec.attribute15;
693: End If;
694: If (p_rec.attribute16 = hr_api.g_varchar2) then
695: p_rec.attribute16 :=
696: irc_ipc_shd.g_old_rec.attribute16;
697: End If;
698: If (p_rec.attribute17 = hr_api.g_varchar2) then
699: p_rec.attribute17 :=
700: irc_ipc_shd.g_old_rec.attribute17;
696: irc_ipc_shd.g_old_rec.attribute16;
697: End If;
698: If (p_rec.attribute17 = hr_api.g_varchar2) then
699: p_rec.attribute17 :=
700: irc_ipc_shd.g_old_rec.attribute17;
701: End If;
702: If (p_rec.attribute18 = hr_api.g_varchar2) then
703: p_rec.attribute18 :=
704: irc_ipc_shd.g_old_rec.attribute18;
700: irc_ipc_shd.g_old_rec.attribute17;
701: End If;
702: If (p_rec.attribute18 = hr_api.g_varchar2) then
703: p_rec.attribute18 :=
704: irc_ipc_shd.g_old_rec.attribute18;
705: End If;
706: If (p_rec.attribute19 = hr_api.g_varchar2) then
707: p_rec.attribute19 :=
708: irc_ipc_shd.g_old_rec.attribute19;
704: irc_ipc_shd.g_old_rec.attribute18;
705: End If;
706: If (p_rec.attribute19 = hr_api.g_varchar2) then
707: p_rec.attribute19 :=
708: irc_ipc_shd.g_old_rec.attribute19;
709: End If;
710: If (p_rec.attribute20 = hr_api.g_varchar2) then
711: p_rec.attribute20 :=
712: irc_ipc_shd.g_old_rec.attribute20;
708: irc_ipc_shd.g_old_rec.attribute19;
709: End If;
710: If (p_rec.attribute20 = hr_api.g_varchar2) then
711: p_rec.attribute20 :=
712: irc_ipc_shd.g_old_rec.attribute20;
713: End If;
714: If (p_rec.attribute21 = hr_api.g_varchar2) then
715: p_rec.attribute21 :=
716: irc_ipc_shd.g_old_rec.attribute21;
712: irc_ipc_shd.g_old_rec.attribute20;
713: End If;
714: If (p_rec.attribute21 = hr_api.g_varchar2) then
715: p_rec.attribute21 :=
716: irc_ipc_shd.g_old_rec.attribute21;
717: End If;
718: If (p_rec.attribute22 = hr_api.g_varchar2) then
719: p_rec.attribute22 :=
720: irc_ipc_shd.g_old_rec.attribute22;
716: irc_ipc_shd.g_old_rec.attribute21;
717: End If;
718: If (p_rec.attribute22 = hr_api.g_varchar2) then
719: p_rec.attribute22 :=
720: irc_ipc_shd.g_old_rec.attribute22;
721: End If;
722: If (p_rec.attribute23 = hr_api.g_varchar2) then
723: p_rec.attribute23 :=
724: irc_ipc_shd.g_old_rec.attribute23;
720: irc_ipc_shd.g_old_rec.attribute22;
721: End If;
722: If (p_rec.attribute23 = hr_api.g_varchar2) then
723: p_rec.attribute23 :=
724: irc_ipc_shd.g_old_rec.attribute23;
725: End If;
726: If (p_rec.attribute24 = hr_api.g_varchar2) then
727: p_rec.attribute24 :=
728: irc_ipc_shd.g_old_rec.attribute24;
724: irc_ipc_shd.g_old_rec.attribute23;
725: End If;
726: If (p_rec.attribute24 = hr_api.g_varchar2) then
727: p_rec.attribute24 :=
728: irc_ipc_shd.g_old_rec.attribute24;
729: End If;
730: If (p_rec.attribute25 = hr_api.g_varchar2) then
731: p_rec.attribute25 :=
732: irc_ipc_shd.g_old_rec.attribute25;
728: irc_ipc_shd.g_old_rec.attribute24;
729: End If;
730: If (p_rec.attribute25 = hr_api.g_varchar2) then
731: p_rec.attribute25 :=
732: irc_ipc_shd.g_old_rec.attribute25;
733: End If;
734: If (p_rec.attribute26 = hr_api.g_varchar2) then
735: p_rec.attribute26 :=
736: irc_ipc_shd.g_old_rec.attribute26;
732: irc_ipc_shd.g_old_rec.attribute25;
733: End If;
734: If (p_rec.attribute26 = hr_api.g_varchar2) then
735: p_rec.attribute26 :=
736: irc_ipc_shd.g_old_rec.attribute26;
737: End If;
738: If (p_rec.attribute27 = hr_api.g_varchar2) then
739: p_rec.attribute27 :=
740: irc_ipc_shd.g_old_rec.attribute27;
736: irc_ipc_shd.g_old_rec.attribute26;
737: End If;
738: If (p_rec.attribute27 = hr_api.g_varchar2) then
739: p_rec.attribute27 :=
740: irc_ipc_shd.g_old_rec.attribute27;
741: End If;
742: If (p_rec.attribute28 = hr_api.g_varchar2) then
743: p_rec.attribute28 :=
744: irc_ipc_shd.g_old_rec.attribute28;
740: irc_ipc_shd.g_old_rec.attribute27;
741: End If;
742: If (p_rec.attribute28 = hr_api.g_varchar2) then
743: p_rec.attribute28 :=
744: irc_ipc_shd.g_old_rec.attribute28;
745: End If;
746: If (p_rec.attribute29 = hr_api.g_varchar2) then
747: p_rec.attribute29 :=
748: irc_ipc_shd.g_old_rec.attribute29;
744: irc_ipc_shd.g_old_rec.attribute28;
745: End If;
746: If (p_rec.attribute29 = hr_api.g_varchar2) then
747: p_rec.attribute29 :=
748: irc_ipc_shd.g_old_rec.attribute29;
749: End If;
750: If (p_rec.attribute30 = hr_api.g_varchar2) then
751: p_rec.attribute30 :=
752: irc_ipc_shd.g_old_rec.attribute30;
748: irc_ipc_shd.g_old_rec.attribute29;
749: End If;
750: If (p_rec.attribute30 = hr_api.g_varchar2) then
751: p_rec.attribute30 :=
752: irc_ipc_shd.g_old_rec.attribute30;
753: End If;
754: If (p_rec.ipc_information_category = hr_api.g_varchar2) then
755: p_rec.ipc_information_category :=
756: irc_ipc_shd.g_old_rec.ipc_information_category;
752: irc_ipc_shd.g_old_rec.attribute30;
753: End If;
754: If (p_rec.ipc_information_category = hr_api.g_varchar2) then
755: p_rec.ipc_information_category :=
756: irc_ipc_shd.g_old_rec.ipc_information_category;
757: End If;
758: If (p_rec.ipc_information1 = hr_api.g_varchar2) then
759: p_rec.ipc_information1 :=
760: irc_ipc_shd.g_old_rec.ipc_information1;
756: irc_ipc_shd.g_old_rec.ipc_information_category;
757: End If;
758: If (p_rec.ipc_information1 = hr_api.g_varchar2) then
759: p_rec.ipc_information1 :=
760: irc_ipc_shd.g_old_rec.ipc_information1;
761: End If;
762: If (p_rec.ipc_information2 = hr_api.g_varchar2) then
763: p_rec.ipc_information2 :=
764: irc_ipc_shd.g_old_rec.ipc_information2;
760: irc_ipc_shd.g_old_rec.ipc_information1;
761: End If;
762: If (p_rec.ipc_information2 = hr_api.g_varchar2) then
763: p_rec.ipc_information2 :=
764: irc_ipc_shd.g_old_rec.ipc_information2;
765: End If;
766: If (p_rec.ipc_information3 = hr_api.g_varchar2) then
767: p_rec.ipc_information3 :=
768: irc_ipc_shd.g_old_rec.ipc_information3;
764: irc_ipc_shd.g_old_rec.ipc_information2;
765: End If;
766: If (p_rec.ipc_information3 = hr_api.g_varchar2) then
767: p_rec.ipc_information3 :=
768: irc_ipc_shd.g_old_rec.ipc_information3;
769: End If;
770: If (p_rec.ipc_information4 = hr_api.g_varchar2) then
771: p_rec.ipc_information4 :=
772: irc_ipc_shd.g_old_rec.ipc_information4;
768: irc_ipc_shd.g_old_rec.ipc_information3;
769: End If;
770: If (p_rec.ipc_information4 = hr_api.g_varchar2) then
771: p_rec.ipc_information4 :=
772: irc_ipc_shd.g_old_rec.ipc_information4;
773: End If;
774: If (p_rec.ipc_information5 = hr_api.g_varchar2) then
775: p_rec.ipc_information5 :=
776: irc_ipc_shd.g_old_rec.ipc_information5;
772: irc_ipc_shd.g_old_rec.ipc_information4;
773: End If;
774: If (p_rec.ipc_information5 = hr_api.g_varchar2) then
775: p_rec.ipc_information5 :=
776: irc_ipc_shd.g_old_rec.ipc_information5;
777: End If;
778: If (p_rec.ipc_information6 = hr_api.g_varchar2) then
779: p_rec.ipc_information6 :=
780: irc_ipc_shd.g_old_rec.ipc_information6;
776: irc_ipc_shd.g_old_rec.ipc_information5;
777: End If;
778: If (p_rec.ipc_information6 = hr_api.g_varchar2) then
779: p_rec.ipc_information6 :=
780: irc_ipc_shd.g_old_rec.ipc_information6;
781: End If;
782: If (p_rec.ipc_information7 = hr_api.g_varchar2) then
783: p_rec.ipc_information7 :=
784: irc_ipc_shd.g_old_rec.ipc_information7;
780: irc_ipc_shd.g_old_rec.ipc_information6;
781: End If;
782: If (p_rec.ipc_information7 = hr_api.g_varchar2) then
783: p_rec.ipc_information7 :=
784: irc_ipc_shd.g_old_rec.ipc_information7;
785: End If;
786: If (p_rec.ipc_information8 = hr_api.g_varchar2) then
787: p_rec.ipc_information8 :=
788: irc_ipc_shd.g_old_rec.ipc_information8;
784: irc_ipc_shd.g_old_rec.ipc_information7;
785: End If;
786: If (p_rec.ipc_information8 = hr_api.g_varchar2) then
787: p_rec.ipc_information8 :=
788: irc_ipc_shd.g_old_rec.ipc_information8;
789: End If;
790: If (p_rec.ipc_information9 = hr_api.g_varchar2) then
791: p_rec.ipc_information9 :=
792: irc_ipc_shd.g_old_rec.ipc_information9;
788: irc_ipc_shd.g_old_rec.ipc_information8;
789: End If;
790: If (p_rec.ipc_information9 = hr_api.g_varchar2) then
791: p_rec.ipc_information9 :=
792: irc_ipc_shd.g_old_rec.ipc_information9;
793: End If;
794: If (p_rec.ipc_information10 = hr_api.g_varchar2) then
795: p_rec.ipc_information10 :=
796: irc_ipc_shd.g_old_rec.ipc_information10;
792: irc_ipc_shd.g_old_rec.ipc_information9;
793: End If;
794: If (p_rec.ipc_information10 = hr_api.g_varchar2) then
795: p_rec.ipc_information10 :=
796: irc_ipc_shd.g_old_rec.ipc_information10;
797: End If;
798: If (p_rec.ipc_information11 = hr_api.g_varchar2) then
799: p_rec.ipc_information11 :=
800: irc_ipc_shd.g_old_rec.ipc_information11;
796: irc_ipc_shd.g_old_rec.ipc_information10;
797: End If;
798: If (p_rec.ipc_information11 = hr_api.g_varchar2) then
799: p_rec.ipc_information11 :=
800: irc_ipc_shd.g_old_rec.ipc_information11;
801: End If;
802: If (p_rec.ipc_information12 = hr_api.g_varchar2) then
803: p_rec.ipc_information12 :=
804: irc_ipc_shd.g_old_rec.ipc_information12;
800: irc_ipc_shd.g_old_rec.ipc_information11;
801: End If;
802: If (p_rec.ipc_information12 = hr_api.g_varchar2) then
803: p_rec.ipc_information12 :=
804: irc_ipc_shd.g_old_rec.ipc_information12;
805: End If;
806: If (p_rec.ipc_information13 = hr_api.g_varchar2) then
807: p_rec.ipc_information13 :=
808: irc_ipc_shd.g_old_rec.ipc_information13;
804: irc_ipc_shd.g_old_rec.ipc_information12;
805: End If;
806: If (p_rec.ipc_information13 = hr_api.g_varchar2) then
807: p_rec.ipc_information13 :=
808: irc_ipc_shd.g_old_rec.ipc_information13;
809: End If;
810: If (p_rec.ipc_information14 = hr_api.g_varchar2) then
811: p_rec.ipc_information14 :=
812: irc_ipc_shd.g_old_rec.ipc_information14;
808: irc_ipc_shd.g_old_rec.ipc_information13;
809: End If;
810: If (p_rec.ipc_information14 = hr_api.g_varchar2) then
811: p_rec.ipc_information14 :=
812: irc_ipc_shd.g_old_rec.ipc_information14;
813: End If;
814: If (p_rec.ipc_information15 = hr_api.g_varchar2) then
815: p_rec.ipc_information15 :=
816: irc_ipc_shd.g_old_rec.ipc_information15;
812: irc_ipc_shd.g_old_rec.ipc_information14;
813: End If;
814: If (p_rec.ipc_information15 = hr_api.g_varchar2) then
815: p_rec.ipc_information15 :=
816: irc_ipc_shd.g_old_rec.ipc_information15;
817: End If;
818: If (p_rec.ipc_information16 = hr_api.g_varchar2) then
819: p_rec.ipc_information16 :=
820: irc_ipc_shd.g_old_rec.ipc_information16;
816: irc_ipc_shd.g_old_rec.ipc_information15;
817: End If;
818: If (p_rec.ipc_information16 = hr_api.g_varchar2) then
819: p_rec.ipc_information16 :=
820: irc_ipc_shd.g_old_rec.ipc_information16;
821: End If;
822: If (p_rec.ipc_information17 = hr_api.g_varchar2) then
823: p_rec.ipc_information17 :=
824: irc_ipc_shd.g_old_rec.ipc_information17;
820: irc_ipc_shd.g_old_rec.ipc_information16;
821: End If;
822: If (p_rec.ipc_information17 = hr_api.g_varchar2) then
823: p_rec.ipc_information17 :=
824: irc_ipc_shd.g_old_rec.ipc_information17;
825: End If;
826: If (p_rec.ipc_information18 = hr_api.g_varchar2) then
827: p_rec.ipc_information18 :=
828: irc_ipc_shd.g_old_rec.ipc_information18;
824: irc_ipc_shd.g_old_rec.ipc_information17;
825: End If;
826: If (p_rec.ipc_information18 = hr_api.g_varchar2) then
827: p_rec.ipc_information18 :=
828: irc_ipc_shd.g_old_rec.ipc_information18;
829: End If;
830: If (p_rec.ipc_information19 = hr_api.g_varchar2) then
831: p_rec.ipc_information19 :=
832: irc_ipc_shd.g_old_rec.ipc_information19;
828: irc_ipc_shd.g_old_rec.ipc_information18;
829: End If;
830: If (p_rec.ipc_information19 = hr_api.g_varchar2) then
831: p_rec.ipc_information19 :=
832: irc_ipc_shd.g_old_rec.ipc_information19;
833: End If;
834: If (p_rec.ipc_information20 = hr_api.g_varchar2) then
835: p_rec.ipc_information20 :=
836: irc_ipc_shd.g_old_rec.ipc_information20;
832: irc_ipc_shd.g_old_rec.ipc_information19;
833: End If;
834: If (p_rec.ipc_information20 = hr_api.g_varchar2) then
835: p_rec.ipc_information20 :=
836: irc_ipc_shd.g_old_rec.ipc_information20;
837: End If;
838: If (p_rec.ipc_information21 = hr_api.g_varchar2) then
839: p_rec.ipc_information21 :=
840: irc_ipc_shd.g_old_rec.ipc_information21;
836: irc_ipc_shd.g_old_rec.ipc_information20;
837: End If;
838: If (p_rec.ipc_information21 = hr_api.g_varchar2) then
839: p_rec.ipc_information21 :=
840: irc_ipc_shd.g_old_rec.ipc_information21;
841: End If;
842: If (p_rec.ipc_information22 = hr_api.g_varchar2) then
843: p_rec.ipc_information22 :=
844: irc_ipc_shd.g_old_rec.ipc_information22;
840: irc_ipc_shd.g_old_rec.ipc_information21;
841: End If;
842: If (p_rec.ipc_information22 = hr_api.g_varchar2) then
843: p_rec.ipc_information22 :=
844: irc_ipc_shd.g_old_rec.ipc_information22;
845: End If;
846: If (p_rec.ipc_information23 = hr_api.g_varchar2) then
847: p_rec.ipc_information23 :=
848: irc_ipc_shd.g_old_rec.ipc_information23;
844: irc_ipc_shd.g_old_rec.ipc_information22;
845: End If;
846: If (p_rec.ipc_information23 = hr_api.g_varchar2) then
847: p_rec.ipc_information23 :=
848: irc_ipc_shd.g_old_rec.ipc_information23;
849: End If;
850: If (p_rec.ipc_information24 = hr_api.g_varchar2) then
851: p_rec.ipc_information24 :=
852: irc_ipc_shd.g_old_rec.ipc_information24;
848: irc_ipc_shd.g_old_rec.ipc_information23;
849: End If;
850: If (p_rec.ipc_information24 = hr_api.g_varchar2) then
851: p_rec.ipc_information24 :=
852: irc_ipc_shd.g_old_rec.ipc_information24;
853: End If;
854: If (p_rec.ipc_information25 = hr_api.g_varchar2) then
855: p_rec.ipc_information25 :=
856: irc_ipc_shd.g_old_rec.ipc_information25;
852: irc_ipc_shd.g_old_rec.ipc_information24;
853: End If;
854: If (p_rec.ipc_information25 = hr_api.g_varchar2) then
855: p_rec.ipc_information25 :=
856: irc_ipc_shd.g_old_rec.ipc_information25;
857: End If;
858: If (p_rec.ipc_information26 = hr_api.g_varchar2) then
859: p_rec.ipc_information26 :=
860: irc_ipc_shd.g_old_rec.ipc_information26;
856: irc_ipc_shd.g_old_rec.ipc_information25;
857: End If;
858: If (p_rec.ipc_information26 = hr_api.g_varchar2) then
859: p_rec.ipc_information26 :=
860: irc_ipc_shd.g_old_rec.ipc_information26;
861: End If;
862: If (p_rec.ipc_information27 = hr_api.g_varchar2) then
863: p_rec.ipc_information27 :=
864: irc_ipc_shd.g_old_rec.ipc_information27;
860: irc_ipc_shd.g_old_rec.ipc_information26;
861: End If;
862: If (p_rec.ipc_information27 = hr_api.g_varchar2) then
863: p_rec.ipc_information27 :=
864: irc_ipc_shd.g_old_rec.ipc_information27;
865: End If;
866: If (p_rec.ipc_information28 = hr_api.g_varchar2) then
867: p_rec.ipc_information28 :=
868: irc_ipc_shd.g_old_rec.ipc_information28;
864: irc_ipc_shd.g_old_rec.ipc_information27;
865: End If;
866: If (p_rec.ipc_information28 = hr_api.g_varchar2) then
867: p_rec.ipc_information28 :=
868: irc_ipc_shd.g_old_rec.ipc_information28;
869: End If;
870: If (p_rec.ipc_information29 = hr_api.g_varchar2) then
871: p_rec.ipc_information29 :=
872: irc_ipc_shd.g_old_rec.ipc_information29;
868: irc_ipc_shd.g_old_rec.ipc_information28;
869: End If;
870: If (p_rec.ipc_information29 = hr_api.g_varchar2) then
871: p_rec.ipc_information29 :=
872: irc_ipc_shd.g_old_rec.ipc_information29;
873: End If;
874: If (p_rec.ipc_information30 = hr_api.g_varchar2) then
875: p_rec.ipc_information30 :=
876: irc_ipc_shd.g_old_rec.ipc_information30;
872: irc_ipc_shd.g_old_rec.ipc_information29;
873: End If;
874: If (p_rec.ipc_information30 = hr_api.g_varchar2) then
875: p_rec.ipc_information30 :=
876: irc_ipc_shd.g_old_rec.ipc_information30;
877: End If;
878: If (p_rec.date_approved = hr_api.g_date) then
879: p_rec.date_approved :=
880: irc_ipc_shd.g_old_rec.date_approved;
876: irc_ipc_shd.g_old_rec.ipc_information30;
877: End If;
878: If (p_rec.date_approved = hr_api.g_date) then
879: p_rec.date_approved :=
880: irc_ipc_shd.g_old_rec.date_approved;
881: End If;
882: If (p_rec.recruiter_full_name = hr_api.g_varchar2) then
883: p_rec.recruiter_full_name :=
884: irc_ipc_shd.g_old_rec.recruiter_full_name;
880: irc_ipc_shd.g_old_rec.date_approved;
881: End If;
882: If (p_rec.recruiter_full_name = hr_api.g_varchar2) then
883: p_rec.recruiter_full_name :=
884: irc_ipc_shd.g_old_rec.recruiter_full_name;
885: End If;
886: If (p_rec.recruiter_email = hr_api.g_varchar2) then
887: p_rec.recruiter_email :=
888: irc_ipc_shd.g_old_rec.recruiter_email;
884: irc_ipc_shd.g_old_rec.recruiter_full_name;
885: End If;
886: If (p_rec.recruiter_email = hr_api.g_varchar2) then
887: p_rec.recruiter_email :=
888: irc_ipc_shd.g_old_rec.recruiter_email;
889: End If;
890: If (p_rec.recruiter_work_telephone = hr_api.g_varchar2) then
891: p_rec.recruiter_work_telephone :=
892: irc_ipc_shd.g_old_rec.recruiter_work_telephone;
888: irc_ipc_shd.g_old_rec.recruiter_email;
889: End If;
890: If (p_rec.recruiter_work_telephone = hr_api.g_varchar2) then
891: p_rec.recruiter_work_telephone :=
892: irc_ipc_shd.g_old_rec.recruiter_work_telephone;
893: End If;
894: If (p_rec.manager_full_name = hr_api.g_varchar2) then
895: p_rec.manager_full_name :=
896: irc_ipc_shd.g_old_rec.manager_full_name;
892: irc_ipc_shd.g_old_rec.recruiter_work_telephone;
893: End If;
894: If (p_rec.manager_full_name = hr_api.g_varchar2) then
895: p_rec.manager_full_name :=
896: irc_ipc_shd.g_old_rec.manager_full_name;
897: End If;
898: If (p_rec.manager_email = hr_api.g_varchar2) then
899: p_rec.manager_email :=
900: irc_ipc_shd.g_old_rec.manager_email;
896: irc_ipc_shd.g_old_rec.manager_full_name;
897: End If;
898: If (p_rec.manager_email = hr_api.g_varchar2) then
899: p_rec.manager_email :=
900: irc_ipc_shd.g_old_rec.manager_email;
901: End If;
902: If (p_rec.manager_work_telephone = hr_api.g_varchar2) then
903: p_rec.manager_work_telephone :=
904: irc_ipc_shd.g_old_rec.manager_work_telephone;
900: irc_ipc_shd.g_old_rec.manager_email;
901: End If;
902: If (p_rec.manager_work_telephone = hr_api.g_varchar2) then
903: p_rec.manager_work_telephone :=
904: irc_ipc_shd.g_old_rec.manager_work_telephone;
905: End If;
906: --
907: End convert_defs;
908: --
909: -- ----------------------------------------------------------------------------
910: -- |---------------------------------< upd >----------------------------------|
911: -- ----------------------------------------------------------------------------
912: Procedure upd
913: (p_rec in out nocopy irc_ipc_shd.g_rec_type
914: ) is
915: --
916: l_proc varchar2(72) := g_package||'upd';
917: --
919: hr_utility.set_location('Entering:'||l_proc, 5);
920: --
921: -- We must lock the row which we need to update.
922: --
923: irc_ipc_shd.lck
924: (p_rec.posting_content_id
925: ,p_rec.object_version_number
926: );
927: --
1029: ,p_manager_email in varchar2 default hr_api.g_varchar2
1030: ,p_manager_work_telephone in varchar2 default hr_api.g_varchar2
1031: ) is
1032: --
1033: l_rec irc_ipc_shd.g_rec_type;
1034: l_proc varchar2(72) := g_package||'upd';
1035: --
1036: Begin
1037: hr_utility.set_location('Entering:'||l_proc, 5);
1039: -- Call conversion function to turn arguments into the
1040: -- l_rec structure.
1041: --
1042: l_rec :=
1043: irc_ipc_shd.convert_args
1044: (p_posting_content_id
1045: ,p_display_manager_info
1046: ,p_display_recruiter_info
1047: ,p_attribute_category