[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_rol_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: --
137: per_rol_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: --
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: --
142: per_rol_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
147: per_rol_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: --
151: Raise;
183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure pre_update
187: (p_rec in per_rol_shd.g_rec_type
188: ) is
189: --
190: l_proc varchar2(72) := g_package||'pre_update';
191: --
228: -- {End Of Comments}
229: -- ----------------------------------------------------------------------------
230: Procedure post_update
231: (p_effective_date in date
232: ,p_rec in per_rol_shd.g_rec_type
233: ) is
234: --
235: l_proc varchar2(72) := g_package||'post_update';
236: --
349: => p_rec.role_information20
350: ,p_object_version_number
351: => p_rec.object_version_number
352: ,p_job_id_o
353: => per_rol_shd.g_old_rec.job_id
354: ,p_job_group_id_o
355: => per_rol_shd.g_old_rec.job_group_id
356: ,p_person_id_o
357: => per_rol_shd.g_old_rec.person_id
351: => p_rec.object_version_number
352: ,p_job_id_o
353: => per_rol_shd.g_old_rec.job_id
354: ,p_job_group_id_o
355: => per_rol_shd.g_old_rec.job_group_id
356: ,p_person_id_o
357: => per_rol_shd.g_old_rec.person_id
358: ,p_organization_id_o
359: => per_rol_shd.g_old_rec.organization_id
353: => per_rol_shd.g_old_rec.job_id
354: ,p_job_group_id_o
355: => per_rol_shd.g_old_rec.job_group_id
356: ,p_person_id_o
357: => per_rol_shd.g_old_rec.person_id
358: ,p_organization_id_o
359: => per_rol_shd.g_old_rec.organization_id
360: ,p_start_date_o
361: => per_rol_shd.g_old_rec.start_date
355: => per_rol_shd.g_old_rec.job_group_id
356: ,p_person_id_o
357: => per_rol_shd.g_old_rec.person_id
358: ,p_organization_id_o
359: => per_rol_shd.g_old_rec.organization_id
360: ,p_start_date_o
361: => per_rol_shd.g_old_rec.start_date
362: ,p_end_date_o
363: => per_rol_shd.g_old_rec.end_date
357: => per_rol_shd.g_old_rec.person_id
358: ,p_organization_id_o
359: => per_rol_shd.g_old_rec.organization_id
360: ,p_start_date_o
361: => per_rol_shd.g_old_rec.start_date
362: ,p_end_date_o
363: => per_rol_shd.g_old_rec.end_date
364: ,p_confidential_date_o
365: => per_rol_shd.g_old_rec.confidential_date
359: => per_rol_shd.g_old_rec.organization_id
360: ,p_start_date_o
361: => per_rol_shd.g_old_rec.start_date
362: ,p_end_date_o
363: => per_rol_shd.g_old_rec.end_date
364: ,p_confidential_date_o
365: => per_rol_shd.g_old_rec.confidential_date
366: ,p_emp_rights_flag_o
367: => per_rol_shd.g_old_rec.emp_rights_flag
361: => per_rol_shd.g_old_rec.start_date
362: ,p_end_date_o
363: => per_rol_shd.g_old_rec.end_date
364: ,p_confidential_date_o
365: => per_rol_shd.g_old_rec.confidential_date
366: ,p_emp_rights_flag_o
367: => per_rol_shd.g_old_rec.emp_rights_flag
368: ,p_end_of_rights_date_o
369: => per_rol_shd.g_old_rec.end_of_rights_date
363: => per_rol_shd.g_old_rec.end_date
364: ,p_confidential_date_o
365: => per_rol_shd.g_old_rec.confidential_date
366: ,p_emp_rights_flag_o
367: => per_rol_shd.g_old_rec.emp_rights_flag
368: ,p_end_of_rights_date_o
369: => per_rol_shd.g_old_rec.end_of_rights_date
370: ,p_primary_contact_flag_o
371: => per_rol_shd.g_old_rec.primary_contact_flag
365: => per_rol_shd.g_old_rec.confidential_date
366: ,p_emp_rights_flag_o
367: => per_rol_shd.g_old_rec.emp_rights_flag
368: ,p_end_of_rights_date_o
369: => per_rol_shd.g_old_rec.end_of_rights_date
370: ,p_primary_contact_flag_o
371: => per_rol_shd.g_old_rec.primary_contact_flag
372: ,p_attribute_category_o
373: => per_rol_shd.g_old_rec.attribute_category
367: => per_rol_shd.g_old_rec.emp_rights_flag
368: ,p_end_of_rights_date_o
369: => per_rol_shd.g_old_rec.end_of_rights_date
370: ,p_primary_contact_flag_o
371: => per_rol_shd.g_old_rec.primary_contact_flag
372: ,p_attribute_category_o
373: => per_rol_shd.g_old_rec.attribute_category
374: ,p_attribute1_o
375: => per_rol_shd.g_old_rec.attribute1
369: => per_rol_shd.g_old_rec.end_of_rights_date
370: ,p_primary_contact_flag_o
371: => per_rol_shd.g_old_rec.primary_contact_flag
372: ,p_attribute_category_o
373: => per_rol_shd.g_old_rec.attribute_category
374: ,p_attribute1_o
375: => per_rol_shd.g_old_rec.attribute1
376: ,p_attribute2_o
377: => per_rol_shd.g_old_rec.attribute2
371: => per_rol_shd.g_old_rec.primary_contact_flag
372: ,p_attribute_category_o
373: => per_rol_shd.g_old_rec.attribute_category
374: ,p_attribute1_o
375: => per_rol_shd.g_old_rec.attribute1
376: ,p_attribute2_o
377: => per_rol_shd.g_old_rec.attribute2
378: ,p_attribute3_o
379: => per_rol_shd.g_old_rec.attribute3
373: => per_rol_shd.g_old_rec.attribute_category
374: ,p_attribute1_o
375: => per_rol_shd.g_old_rec.attribute1
376: ,p_attribute2_o
377: => per_rol_shd.g_old_rec.attribute2
378: ,p_attribute3_o
379: => per_rol_shd.g_old_rec.attribute3
380: ,p_attribute4_o
381: => per_rol_shd.g_old_rec.attribute4
375: => per_rol_shd.g_old_rec.attribute1
376: ,p_attribute2_o
377: => per_rol_shd.g_old_rec.attribute2
378: ,p_attribute3_o
379: => per_rol_shd.g_old_rec.attribute3
380: ,p_attribute4_o
381: => per_rol_shd.g_old_rec.attribute4
382: ,p_attribute5_o
383: => per_rol_shd.g_old_rec.attribute5
377: => per_rol_shd.g_old_rec.attribute2
378: ,p_attribute3_o
379: => per_rol_shd.g_old_rec.attribute3
380: ,p_attribute4_o
381: => per_rol_shd.g_old_rec.attribute4
382: ,p_attribute5_o
383: => per_rol_shd.g_old_rec.attribute5
384: ,p_attribute6_o
385: => per_rol_shd.g_old_rec.attribute6
379: => per_rol_shd.g_old_rec.attribute3
380: ,p_attribute4_o
381: => per_rol_shd.g_old_rec.attribute4
382: ,p_attribute5_o
383: => per_rol_shd.g_old_rec.attribute5
384: ,p_attribute6_o
385: => per_rol_shd.g_old_rec.attribute6
386: ,p_attribute7_o
387: => per_rol_shd.g_old_rec.attribute7
381: => per_rol_shd.g_old_rec.attribute4
382: ,p_attribute5_o
383: => per_rol_shd.g_old_rec.attribute5
384: ,p_attribute6_o
385: => per_rol_shd.g_old_rec.attribute6
386: ,p_attribute7_o
387: => per_rol_shd.g_old_rec.attribute7
388: ,p_attribute8_o
389: => per_rol_shd.g_old_rec.attribute8
383: => per_rol_shd.g_old_rec.attribute5
384: ,p_attribute6_o
385: => per_rol_shd.g_old_rec.attribute6
386: ,p_attribute7_o
387: => per_rol_shd.g_old_rec.attribute7
388: ,p_attribute8_o
389: => per_rol_shd.g_old_rec.attribute8
390: ,p_attribute9_o
391: => per_rol_shd.g_old_rec.attribute9
385: => per_rol_shd.g_old_rec.attribute6
386: ,p_attribute7_o
387: => per_rol_shd.g_old_rec.attribute7
388: ,p_attribute8_o
389: => per_rol_shd.g_old_rec.attribute8
390: ,p_attribute9_o
391: => per_rol_shd.g_old_rec.attribute9
392: ,p_attribute10_o
393: => per_rol_shd.g_old_rec.attribute10
387: => per_rol_shd.g_old_rec.attribute7
388: ,p_attribute8_o
389: => per_rol_shd.g_old_rec.attribute8
390: ,p_attribute9_o
391: => per_rol_shd.g_old_rec.attribute9
392: ,p_attribute10_o
393: => per_rol_shd.g_old_rec.attribute10
394: ,p_attribute11_o
395: => per_rol_shd.g_old_rec.attribute11
389: => per_rol_shd.g_old_rec.attribute8
390: ,p_attribute9_o
391: => per_rol_shd.g_old_rec.attribute9
392: ,p_attribute10_o
393: => per_rol_shd.g_old_rec.attribute10
394: ,p_attribute11_o
395: => per_rol_shd.g_old_rec.attribute11
396: ,p_attribute12_o
397: => per_rol_shd.g_old_rec.attribute12
391: => per_rol_shd.g_old_rec.attribute9
392: ,p_attribute10_o
393: => per_rol_shd.g_old_rec.attribute10
394: ,p_attribute11_o
395: => per_rol_shd.g_old_rec.attribute11
396: ,p_attribute12_o
397: => per_rol_shd.g_old_rec.attribute12
398: ,p_attribute13_o
399: => per_rol_shd.g_old_rec.attribute13
393: => per_rol_shd.g_old_rec.attribute10
394: ,p_attribute11_o
395: => per_rol_shd.g_old_rec.attribute11
396: ,p_attribute12_o
397: => per_rol_shd.g_old_rec.attribute12
398: ,p_attribute13_o
399: => per_rol_shd.g_old_rec.attribute13
400: ,p_attribute14_o
401: => per_rol_shd.g_old_rec.attribute14
395: => per_rol_shd.g_old_rec.attribute11
396: ,p_attribute12_o
397: => per_rol_shd.g_old_rec.attribute12
398: ,p_attribute13_o
399: => per_rol_shd.g_old_rec.attribute13
400: ,p_attribute14_o
401: => per_rol_shd.g_old_rec.attribute14
402: ,p_attribute15_o
403: => per_rol_shd.g_old_rec.attribute15
397: => per_rol_shd.g_old_rec.attribute12
398: ,p_attribute13_o
399: => per_rol_shd.g_old_rec.attribute13
400: ,p_attribute14_o
401: => per_rol_shd.g_old_rec.attribute14
402: ,p_attribute15_o
403: => per_rol_shd.g_old_rec.attribute15
404: ,p_attribute16_o
405: => per_rol_shd.g_old_rec.attribute16
399: => per_rol_shd.g_old_rec.attribute13
400: ,p_attribute14_o
401: => per_rol_shd.g_old_rec.attribute14
402: ,p_attribute15_o
403: => per_rol_shd.g_old_rec.attribute15
404: ,p_attribute16_o
405: => per_rol_shd.g_old_rec.attribute16
406: ,p_attribute17_o
407: => per_rol_shd.g_old_rec.attribute17
401: => per_rol_shd.g_old_rec.attribute14
402: ,p_attribute15_o
403: => per_rol_shd.g_old_rec.attribute15
404: ,p_attribute16_o
405: => per_rol_shd.g_old_rec.attribute16
406: ,p_attribute17_o
407: => per_rol_shd.g_old_rec.attribute17
408: ,p_attribute18_o
409: => per_rol_shd.g_old_rec.attribute18
403: => per_rol_shd.g_old_rec.attribute15
404: ,p_attribute16_o
405: => per_rol_shd.g_old_rec.attribute16
406: ,p_attribute17_o
407: => per_rol_shd.g_old_rec.attribute17
408: ,p_attribute18_o
409: => per_rol_shd.g_old_rec.attribute18
410: ,p_attribute19_o
411: => per_rol_shd.g_old_rec.attribute19
405: => per_rol_shd.g_old_rec.attribute16
406: ,p_attribute17_o
407: => per_rol_shd.g_old_rec.attribute17
408: ,p_attribute18_o
409: => per_rol_shd.g_old_rec.attribute18
410: ,p_attribute19_o
411: => per_rol_shd.g_old_rec.attribute19
412: ,p_attribute20_o
413: => per_rol_shd.g_old_rec.attribute20
407: => per_rol_shd.g_old_rec.attribute17
408: ,p_attribute18_o
409: => per_rol_shd.g_old_rec.attribute18
410: ,p_attribute19_o
411: => per_rol_shd.g_old_rec.attribute19
412: ,p_attribute20_o
413: => per_rol_shd.g_old_rec.attribute20
414: ,p_role_information_category_o
415: => per_rol_shd.g_old_rec.role_information_category
409: => per_rol_shd.g_old_rec.attribute18
410: ,p_attribute19_o
411: => per_rol_shd.g_old_rec.attribute19
412: ,p_attribute20_o
413: => per_rol_shd.g_old_rec.attribute20
414: ,p_role_information_category_o
415: => per_rol_shd.g_old_rec.role_information_category
416: ,p_role_information1_o
417: => per_rol_shd.g_old_rec.role_information1
411: => per_rol_shd.g_old_rec.attribute19
412: ,p_attribute20_o
413: => per_rol_shd.g_old_rec.attribute20
414: ,p_role_information_category_o
415: => per_rol_shd.g_old_rec.role_information_category
416: ,p_role_information1_o
417: => per_rol_shd.g_old_rec.role_information1
418: ,p_role_information2_o
419: => per_rol_shd.g_old_rec.role_information2
413: => per_rol_shd.g_old_rec.attribute20
414: ,p_role_information_category_o
415: => per_rol_shd.g_old_rec.role_information_category
416: ,p_role_information1_o
417: => per_rol_shd.g_old_rec.role_information1
418: ,p_role_information2_o
419: => per_rol_shd.g_old_rec.role_information2
420: ,p_role_information3_o
421: => per_rol_shd.g_old_rec.role_information3
415: => per_rol_shd.g_old_rec.role_information_category
416: ,p_role_information1_o
417: => per_rol_shd.g_old_rec.role_information1
418: ,p_role_information2_o
419: => per_rol_shd.g_old_rec.role_information2
420: ,p_role_information3_o
421: => per_rol_shd.g_old_rec.role_information3
422: ,p_role_information4_o
423: => per_rol_shd.g_old_rec.role_information4
417: => per_rol_shd.g_old_rec.role_information1
418: ,p_role_information2_o
419: => per_rol_shd.g_old_rec.role_information2
420: ,p_role_information3_o
421: => per_rol_shd.g_old_rec.role_information3
422: ,p_role_information4_o
423: => per_rol_shd.g_old_rec.role_information4
424: ,p_role_information5_o
425: => per_rol_shd.g_old_rec.role_information5
419: => per_rol_shd.g_old_rec.role_information2
420: ,p_role_information3_o
421: => per_rol_shd.g_old_rec.role_information3
422: ,p_role_information4_o
423: => per_rol_shd.g_old_rec.role_information4
424: ,p_role_information5_o
425: => per_rol_shd.g_old_rec.role_information5
426: ,p_role_information6_o
427: => per_rol_shd.g_old_rec.role_information6
421: => per_rol_shd.g_old_rec.role_information3
422: ,p_role_information4_o
423: => per_rol_shd.g_old_rec.role_information4
424: ,p_role_information5_o
425: => per_rol_shd.g_old_rec.role_information5
426: ,p_role_information6_o
427: => per_rol_shd.g_old_rec.role_information6
428: ,p_role_information7_o
429: => per_rol_shd.g_old_rec.role_information7
423: => per_rol_shd.g_old_rec.role_information4
424: ,p_role_information5_o
425: => per_rol_shd.g_old_rec.role_information5
426: ,p_role_information6_o
427: => per_rol_shd.g_old_rec.role_information6
428: ,p_role_information7_o
429: => per_rol_shd.g_old_rec.role_information7
430: ,p_role_information8_o
431: => per_rol_shd.g_old_rec.role_information8
425: => per_rol_shd.g_old_rec.role_information5
426: ,p_role_information6_o
427: => per_rol_shd.g_old_rec.role_information6
428: ,p_role_information7_o
429: => per_rol_shd.g_old_rec.role_information7
430: ,p_role_information8_o
431: => per_rol_shd.g_old_rec.role_information8
432: ,p_role_information9_o
433: => per_rol_shd.g_old_rec.role_information9
427: => per_rol_shd.g_old_rec.role_information6
428: ,p_role_information7_o
429: => per_rol_shd.g_old_rec.role_information7
430: ,p_role_information8_o
431: => per_rol_shd.g_old_rec.role_information8
432: ,p_role_information9_o
433: => per_rol_shd.g_old_rec.role_information9
434: ,p_role_information10_o
435: => per_rol_shd.g_old_rec.role_information10
429: => per_rol_shd.g_old_rec.role_information7
430: ,p_role_information8_o
431: => per_rol_shd.g_old_rec.role_information8
432: ,p_role_information9_o
433: => per_rol_shd.g_old_rec.role_information9
434: ,p_role_information10_o
435: => per_rol_shd.g_old_rec.role_information10
436: ,p_role_information11_o
437: => per_rol_shd.g_old_rec.role_information11
431: => per_rol_shd.g_old_rec.role_information8
432: ,p_role_information9_o
433: => per_rol_shd.g_old_rec.role_information9
434: ,p_role_information10_o
435: => per_rol_shd.g_old_rec.role_information10
436: ,p_role_information11_o
437: => per_rol_shd.g_old_rec.role_information11
438: ,p_role_information12_o
439: => per_rol_shd.g_old_rec.role_information12
433: => per_rol_shd.g_old_rec.role_information9
434: ,p_role_information10_o
435: => per_rol_shd.g_old_rec.role_information10
436: ,p_role_information11_o
437: => per_rol_shd.g_old_rec.role_information11
438: ,p_role_information12_o
439: => per_rol_shd.g_old_rec.role_information12
440: ,p_role_information13_o
441: => per_rol_shd.g_old_rec.role_information13
435: => per_rol_shd.g_old_rec.role_information10
436: ,p_role_information11_o
437: => per_rol_shd.g_old_rec.role_information11
438: ,p_role_information12_o
439: => per_rol_shd.g_old_rec.role_information12
440: ,p_role_information13_o
441: => per_rol_shd.g_old_rec.role_information13
442: ,p_role_information14_o
443: => per_rol_shd.g_old_rec.role_information14
437: => per_rol_shd.g_old_rec.role_information11
438: ,p_role_information12_o
439: => per_rol_shd.g_old_rec.role_information12
440: ,p_role_information13_o
441: => per_rol_shd.g_old_rec.role_information13
442: ,p_role_information14_o
443: => per_rol_shd.g_old_rec.role_information14
444: ,p_role_information15_o
445: => per_rol_shd.g_old_rec.role_information15
439: => per_rol_shd.g_old_rec.role_information12
440: ,p_role_information13_o
441: => per_rol_shd.g_old_rec.role_information13
442: ,p_role_information14_o
443: => per_rol_shd.g_old_rec.role_information14
444: ,p_role_information15_o
445: => per_rol_shd.g_old_rec.role_information15
446: ,p_role_information16_o
447: => per_rol_shd.g_old_rec.role_information16
441: => per_rol_shd.g_old_rec.role_information13
442: ,p_role_information14_o
443: => per_rol_shd.g_old_rec.role_information14
444: ,p_role_information15_o
445: => per_rol_shd.g_old_rec.role_information15
446: ,p_role_information16_o
447: => per_rol_shd.g_old_rec.role_information16
448: ,p_role_information17_o
449: => per_rol_shd.g_old_rec.role_information17
443: => per_rol_shd.g_old_rec.role_information14
444: ,p_role_information15_o
445: => per_rol_shd.g_old_rec.role_information15
446: ,p_role_information16_o
447: => per_rol_shd.g_old_rec.role_information16
448: ,p_role_information17_o
449: => per_rol_shd.g_old_rec.role_information17
450: ,p_role_information18_o
451: => per_rol_shd.g_old_rec.role_information18
445: => per_rol_shd.g_old_rec.role_information15
446: ,p_role_information16_o
447: => per_rol_shd.g_old_rec.role_information16
448: ,p_role_information17_o
449: => per_rol_shd.g_old_rec.role_information17
450: ,p_role_information18_o
451: => per_rol_shd.g_old_rec.role_information18
452: ,p_role_information19_o
453: => per_rol_shd.g_old_rec.role_information19
447: => per_rol_shd.g_old_rec.role_information16
448: ,p_role_information17_o
449: => per_rol_shd.g_old_rec.role_information17
450: ,p_role_information18_o
451: => per_rol_shd.g_old_rec.role_information18
452: ,p_role_information19_o
453: => per_rol_shd.g_old_rec.role_information19
454: ,p_role_information20_o
455: => per_rol_shd.g_old_rec.role_information20
449: => per_rol_shd.g_old_rec.role_information17
450: ,p_role_information18_o
451: => per_rol_shd.g_old_rec.role_information18
452: ,p_role_information19_o
453: => per_rol_shd.g_old_rec.role_information19
454: ,p_role_information20_o
455: => per_rol_shd.g_old_rec.role_information20
456: ,p_object_version_number_o
457: => per_rol_shd.g_old_rec.object_version_number
451: => per_rol_shd.g_old_rec.role_information18
452: ,p_role_information19_o
453: => per_rol_shd.g_old_rec.role_information19
454: ,p_role_information20_o
455: => per_rol_shd.g_old_rec.role_information20
456: ,p_object_version_number_o
457: => per_rol_shd.g_old_rec.object_version_number
458: );
459: --
453: => per_rol_shd.g_old_rec.role_information19
454: ,p_role_information20_o
455: => per_rol_shd.g_old_rec.role_information20
456: ,p_object_version_number_o
457: => per_rol_shd.g_old_rec.object_version_number
458: );
459: --
460: exception
461: --
513: --
514: -- {End Of Comments}
515: -- ----------------------------------------------------------------------------
516: Procedure convert_defs
517: (p_rec in out nocopy per_rol_shd.g_rec_type
518: ) is
519: --
520: Begin
521: --
525: -- is being used then we must set to the 'current' argument value.
526: --
527: If (p_rec.job_id = hr_api.g_number) then
528: p_rec.job_id :=
529: per_rol_shd.g_old_rec.job_id;
530: End If;
531: If (p_rec.job_group_id = hr_api.g_number) then
532: p_rec.job_group_id :=
533: per_rol_shd.g_old_rec.job_group_id;
529: per_rol_shd.g_old_rec.job_id;
530: End If;
531: If (p_rec.job_group_id = hr_api.g_number) then
532: p_rec.job_group_id :=
533: per_rol_shd.g_old_rec.job_group_id;
534: End If;
535: If (p_rec.person_id = hr_api.g_number) then
536: p_rec.person_id :=
537: per_rol_shd.g_old_rec.person_id;
533: per_rol_shd.g_old_rec.job_group_id;
534: End If;
535: If (p_rec.person_id = hr_api.g_number) then
536: p_rec.person_id :=
537: per_rol_shd.g_old_rec.person_id;
538: End If;
539: If (p_rec.organization_id = hr_api.g_number) then
540: p_rec.organization_id :=
541: per_rol_shd.g_old_rec.organization_id;
537: per_rol_shd.g_old_rec.person_id;
538: End If;
539: If (p_rec.organization_id = hr_api.g_number) then
540: p_rec.organization_id :=
541: per_rol_shd.g_old_rec.organization_id;
542: End If;
543: If (p_rec.start_date = hr_api.g_date) then
544: p_rec.start_date :=
545: per_rol_shd.g_old_rec.start_date;
541: per_rol_shd.g_old_rec.organization_id;
542: End If;
543: If (p_rec.start_date = hr_api.g_date) then
544: p_rec.start_date :=
545: per_rol_shd.g_old_rec.start_date;
546: End If;
547: If (p_rec.end_date = hr_api.g_date) then
548: p_rec.end_date :=
549: per_rol_shd.g_old_rec.end_date;
545: per_rol_shd.g_old_rec.start_date;
546: End If;
547: If (p_rec.end_date = hr_api.g_date) then
548: p_rec.end_date :=
549: per_rol_shd.g_old_rec.end_date;
550: End If;
551: If (p_rec.confidential_date = hr_api.g_date) then
552: p_rec.confidential_date :=
553: per_rol_shd.g_old_rec.confidential_date;
549: per_rol_shd.g_old_rec.end_date;
550: End If;
551: If (p_rec.confidential_date = hr_api.g_date) then
552: p_rec.confidential_date :=
553: per_rol_shd.g_old_rec.confidential_date;
554: End If;
555: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then
556: p_rec.emp_rights_flag :=
557: per_rol_shd.g_old_rec.emp_rights_flag;
553: per_rol_shd.g_old_rec.confidential_date;
554: End If;
555: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then
556: p_rec.emp_rights_flag :=
557: per_rol_shd.g_old_rec.emp_rights_flag;
558: End If;
559: If (p_rec.end_of_rights_date = hr_api.g_date) then
560: p_rec.end_of_rights_date :=
561: per_rol_shd.g_old_rec.end_of_rights_date;
557: per_rol_shd.g_old_rec.emp_rights_flag;
558: End If;
559: If (p_rec.end_of_rights_date = hr_api.g_date) then
560: p_rec.end_of_rights_date :=
561: per_rol_shd.g_old_rec.end_of_rights_date;
562: End If;
563: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then
564: p_rec.primary_contact_flag :=
565: per_rol_shd.g_old_rec.primary_contact_flag;
561: per_rol_shd.g_old_rec.end_of_rights_date;
562: End If;
563: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then
564: p_rec.primary_contact_flag :=
565: per_rol_shd.g_old_rec.primary_contact_flag;
566: End If;
567: If (p_rec.attribute_category = hr_api.g_varchar2) then
568: p_rec.attribute_category :=
569: per_rol_shd.g_old_rec.attribute_category;
565: per_rol_shd.g_old_rec.primary_contact_flag;
566: End If;
567: If (p_rec.attribute_category = hr_api.g_varchar2) then
568: p_rec.attribute_category :=
569: per_rol_shd.g_old_rec.attribute_category;
570: End If;
571: If (p_rec.attribute1 = hr_api.g_varchar2) then
572: p_rec.attribute1 :=
573: per_rol_shd.g_old_rec.attribute1;
569: per_rol_shd.g_old_rec.attribute_category;
570: End If;
571: If (p_rec.attribute1 = hr_api.g_varchar2) then
572: p_rec.attribute1 :=
573: per_rol_shd.g_old_rec.attribute1;
574: End If;
575: If (p_rec.attribute2 = hr_api.g_varchar2) then
576: p_rec.attribute2 :=
577: per_rol_shd.g_old_rec.attribute2;
573: per_rol_shd.g_old_rec.attribute1;
574: End If;
575: If (p_rec.attribute2 = hr_api.g_varchar2) then
576: p_rec.attribute2 :=
577: per_rol_shd.g_old_rec.attribute2;
578: End If;
579: If (p_rec.attribute3 = hr_api.g_varchar2) then
580: p_rec.attribute3 :=
581: per_rol_shd.g_old_rec.attribute3;
577: per_rol_shd.g_old_rec.attribute2;
578: End If;
579: If (p_rec.attribute3 = hr_api.g_varchar2) then
580: p_rec.attribute3 :=
581: per_rol_shd.g_old_rec.attribute3;
582: End If;
583: If (p_rec.attribute4 = hr_api.g_varchar2) then
584: p_rec.attribute4 :=
585: per_rol_shd.g_old_rec.attribute4;
581: per_rol_shd.g_old_rec.attribute3;
582: End If;
583: If (p_rec.attribute4 = hr_api.g_varchar2) then
584: p_rec.attribute4 :=
585: per_rol_shd.g_old_rec.attribute4;
586: End If;
587: If (p_rec.attribute5 = hr_api.g_varchar2) then
588: p_rec.attribute5 :=
589: per_rol_shd.g_old_rec.attribute5;
585: per_rol_shd.g_old_rec.attribute4;
586: End If;
587: If (p_rec.attribute5 = hr_api.g_varchar2) then
588: p_rec.attribute5 :=
589: per_rol_shd.g_old_rec.attribute5;
590: End If;
591: If (p_rec.attribute6 = hr_api.g_varchar2) then
592: p_rec.attribute6 :=
593: per_rol_shd.g_old_rec.attribute6;
589: per_rol_shd.g_old_rec.attribute5;
590: End If;
591: If (p_rec.attribute6 = hr_api.g_varchar2) then
592: p_rec.attribute6 :=
593: per_rol_shd.g_old_rec.attribute6;
594: End If;
595: If (p_rec.attribute7 = hr_api.g_varchar2) then
596: p_rec.attribute7 :=
597: per_rol_shd.g_old_rec.attribute7;
593: per_rol_shd.g_old_rec.attribute6;
594: End If;
595: If (p_rec.attribute7 = hr_api.g_varchar2) then
596: p_rec.attribute7 :=
597: per_rol_shd.g_old_rec.attribute7;
598: End If;
599: If (p_rec.attribute8 = hr_api.g_varchar2) then
600: p_rec.attribute8 :=
601: per_rol_shd.g_old_rec.attribute8;
597: per_rol_shd.g_old_rec.attribute7;
598: End If;
599: If (p_rec.attribute8 = hr_api.g_varchar2) then
600: p_rec.attribute8 :=
601: per_rol_shd.g_old_rec.attribute8;
602: End If;
603: If (p_rec.attribute9 = hr_api.g_varchar2) then
604: p_rec.attribute9 :=
605: per_rol_shd.g_old_rec.attribute9;
601: per_rol_shd.g_old_rec.attribute8;
602: End If;
603: If (p_rec.attribute9 = hr_api.g_varchar2) then
604: p_rec.attribute9 :=
605: per_rol_shd.g_old_rec.attribute9;
606: End If;
607: If (p_rec.attribute10 = hr_api.g_varchar2) then
608: p_rec.attribute10 :=
609: per_rol_shd.g_old_rec.attribute10;
605: per_rol_shd.g_old_rec.attribute9;
606: End If;
607: If (p_rec.attribute10 = hr_api.g_varchar2) then
608: p_rec.attribute10 :=
609: per_rol_shd.g_old_rec.attribute10;
610: End If;
611: If (p_rec.attribute11 = hr_api.g_varchar2) then
612: p_rec.attribute11 :=
613: per_rol_shd.g_old_rec.attribute11;
609: per_rol_shd.g_old_rec.attribute10;
610: End If;
611: If (p_rec.attribute11 = hr_api.g_varchar2) then
612: p_rec.attribute11 :=
613: per_rol_shd.g_old_rec.attribute11;
614: End If;
615: If (p_rec.attribute12 = hr_api.g_varchar2) then
616: p_rec.attribute12 :=
617: per_rol_shd.g_old_rec.attribute12;
613: per_rol_shd.g_old_rec.attribute11;
614: End If;
615: If (p_rec.attribute12 = hr_api.g_varchar2) then
616: p_rec.attribute12 :=
617: per_rol_shd.g_old_rec.attribute12;
618: End If;
619: If (p_rec.attribute13 = hr_api.g_varchar2) then
620: p_rec.attribute13 :=
621: per_rol_shd.g_old_rec.attribute13;
617: per_rol_shd.g_old_rec.attribute12;
618: End If;
619: If (p_rec.attribute13 = hr_api.g_varchar2) then
620: p_rec.attribute13 :=
621: per_rol_shd.g_old_rec.attribute13;
622: End If;
623: If (p_rec.attribute14 = hr_api.g_varchar2) then
624: p_rec.attribute14 :=
625: per_rol_shd.g_old_rec.attribute14;
621: per_rol_shd.g_old_rec.attribute13;
622: End If;
623: If (p_rec.attribute14 = hr_api.g_varchar2) then
624: p_rec.attribute14 :=
625: per_rol_shd.g_old_rec.attribute14;
626: End If;
627: If (p_rec.attribute15 = hr_api.g_varchar2) then
628: p_rec.attribute15 :=
629: per_rol_shd.g_old_rec.attribute15;
625: per_rol_shd.g_old_rec.attribute14;
626: End If;
627: If (p_rec.attribute15 = hr_api.g_varchar2) then
628: p_rec.attribute15 :=
629: per_rol_shd.g_old_rec.attribute15;
630: End If;
631: If (p_rec.attribute16 = hr_api.g_varchar2) then
632: p_rec.attribute16 :=
633: per_rol_shd.g_old_rec.attribute16;
629: per_rol_shd.g_old_rec.attribute15;
630: End If;
631: If (p_rec.attribute16 = hr_api.g_varchar2) then
632: p_rec.attribute16 :=
633: per_rol_shd.g_old_rec.attribute16;
634: End If;
635: If (p_rec.attribute17 = hr_api.g_varchar2) then
636: p_rec.attribute17 :=
637: per_rol_shd.g_old_rec.attribute17;
633: per_rol_shd.g_old_rec.attribute16;
634: End If;
635: If (p_rec.attribute17 = hr_api.g_varchar2) then
636: p_rec.attribute17 :=
637: per_rol_shd.g_old_rec.attribute17;
638: End If;
639: If (p_rec.attribute18 = hr_api.g_varchar2) then
640: p_rec.attribute18 :=
641: per_rol_shd.g_old_rec.attribute18;
637: per_rol_shd.g_old_rec.attribute17;
638: End If;
639: If (p_rec.attribute18 = hr_api.g_varchar2) then
640: p_rec.attribute18 :=
641: per_rol_shd.g_old_rec.attribute18;
642: End If;
643: If (p_rec.attribute19 = hr_api.g_varchar2) then
644: p_rec.attribute19 :=
645: per_rol_shd.g_old_rec.attribute19;
641: per_rol_shd.g_old_rec.attribute18;
642: End If;
643: If (p_rec.attribute19 = hr_api.g_varchar2) then
644: p_rec.attribute19 :=
645: per_rol_shd.g_old_rec.attribute19;
646: End If;
647: If (p_rec.attribute20 = hr_api.g_varchar2) then
648: p_rec.attribute20 :=
649: per_rol_shd.g_old_rec.attribute20;
645: per_rol_shd.g_old_rec.attribute19;
646: End If;
647: If (p_rec.attribute20 = hr_api.g_varchar2) then
648: p_rec.attribute20 :=
649: per_rol_shd.g_old_rec.attribute20;
650: End If;
651: If (p_rec.role_information_category = hr_api.g_varchar2) then
652: p_rec.role_information_category :=
653: per_rol_shd.g_old_rec.role_information_category;
649: per_rol_shd.g_old_rec.attribute20;
650: End If;
651: If (p_rec.role_information_category = hr_api.g_varchar2) then
652: p_rec.role_information_category :=
653: per_rol_shd.g_old_rec.role_information_category;
654: End If;
655: If (p_rec.role_information1 = hr_api.g_varchar2) then
656: p_rec.role_information1 :=
657: per_rol_shd.g_old_rec.role_information1;
653: per_rol_shd.g_old_rec.role_information_category;
654: End If;
655: If (p_rec.role_information1 = hr_api.g_varchar2) then
656: p_rec.role_information1 :=
657: per_rol_shd.g_old_rec.role_information1;
658: End If;
659: If (p_rec.role_information2 = hr_api.g_varchar2) then
660: p_rec.role_information2 :=
661: per_rol_shd.g_old_rec.role_information2;
657: per_rol_shd.g_old_rec.role_information1;
658: End If;
659: If (p_rec.role_information2 = hr_api.g_varchar2) then
660: p_rec.role_information2 :=
661: per_rol_shd.g_old_rec.role_information2;
662: End If;
663: If (p_rec.role_information3 = hr_api.g_varchar2) then
664: p_rec.role_information3 :=
665: per_rol_shd.g_old_rec.role_information3;
661: per_rol_shd.g_old_rec.role_information2;
662: End If;
663: If (p_rec.role_information3 = hr_api.g_varchar2) then
664: p_rec.role_information3 :=
665: per_rol_shd.g_old_rec.role_information3;
666: End If;
667: If (p_rec.role_information4 = hr_api.g_varchar2) then
668: p_rec.role_information4 :=
669: per_rol_shd.g_old_rec.role_information4;
665: per_rol_shd.g_old_rec.role_information3;
666: End If;
667: If (p_rec.role_information4 = hr_api.g_varchar2) then
668: p_rec.role_information4 :=
669: per_rol_shd.g_old_rec.role_information4;
670: End If;
671: If (p_rec.role_information5 = hr_api.g_varchar2) then
672: p_rec.role_information5 :=
673: per_rol_shd.g_old_rec.role_information5;
669: per_rol_shd.g_old_rec.role_information4;
670: End If;
671: If (p_rec.role_information5 = hr_api.g_varchar2) then
672: p_rec.role_information5 :=
673: per_rol_shd.g_old_rec.role_information5;
674: End If;
675: If (p_rec.role_information6 = hr_api.g_varchar2) then
676: p_rec.role_information6 :=
677: per_rol_shd.g_old_rec.role_information6;
673: per_rol_shd.g_old_rec.role_information5;
674: End If;
675: If (p_rec.role_information6 = hr_api.g_varchar2) then
676: p_rec.role_information6 :=
677: per_rol_shd.g_old_rec.role_information6;
678: End If;
679: If (p_rec.role_information7 = hr_api.g_varchar2) then
680: p_rec.role_information7 :=
681: per_rol_shd.g_old_rec.role_information7;
677: per_rol_shd.g_old_rec.role_information6;
678: End If;
679: If (p_rec.role_information7 = hr_api.g_varchar2) then
680: p_rec.role_information7 :=
681: per_rol_shd.g_old_rec.role_information7;
682: End If;
683: If (p_rec.role_information8 = hr_api.g_varchar2) then
684: p_rec.role_information8 :=
685: per_rol_shd.g_old_rec.role_information8;
681: per_rol_shd.g_old_rec.role_information7;
682: End If;
683: If (p_rec.role_information8 = hr_api.g_varchar2) then
684: p_rec.role_information8 :=
685: per_rol_shd.g_old_rec.role_information8;
686: End If;
687: If (p_rec.role_information9 = hr_api.g_varchar2) then
688: p_rec.role_information9 :=
689: per_rol_shd.g_old_rec.role_information9;
685: per_rol_shd.g_old_rec.role_information8;
686: End If;
687: If (p_rec.role_information9 = hr_api.g_varchar2) then
688: p_rec.role_information9 :=
689: per_rol_shd.g_old_rec.role_information9;
690: End If;
691: If (p_rec.role_information10 = hr_api.g_varchar2) then
692: p_rec.role_information10 :=
693: per_rol_shd.g_old_rec.role_information10;
689: per_rol_shd.g_old_rec.role_information9;
690: End If;
691: If (p_rec.role_information10 = hr_api.g_varchar2) then
692: p_rec.role_information10 :=
693: per_rol_shd.g_old_rec.role_information10;
694: End If;
695: If (p_rec.role_information11 = hr_api.g_varchar2) then
696: p_rec.role_information11 :=
697: per_rol_shd.g_old_rec.role_information11;
693: per_rol_shd.g_old_rec.role_information10;
694: End If;
695: If (p_rec.role_information11 = hr_api.g_varchar2) then
696: p_rec.role_information11 :=
697: per_rol_shd.g_old_rec.role_information11;
698: End If;
699: If (p_rec.role_information12 = hr_api.g_varchar2) then
700: p_rec.role_information12 :=
701: per_rol_shd.g_old_rec.role_information12;
697: per_rol_shd.g_old_rec.role_information11;
698: End If;
699: If (p_rec.role_information12 = hr_api.g_varchar2) then
700: p_rec.role_information12 :=
701: per_rol_shd.g_old_rec.role_information12;
702: End If;
703: If (p_rec.role_information13 = hr_api.g_varchar2) then
704: p_rec.role_information13 :=
705: per_rol_shd.g_old_rec.role_information13;
701: per_rol_shd.g_old_rec.role_information12;
702: End If;
703: If (p_rec.role_information13 = hr_api.g_varchar2) then
704: p_rec.role_information13 :=
705: per_rol_shd.g_old_rec.role_information13;
706: End If;
707: If (p_rec.role_information14 = hr_api.g_varchar2) then
708: p_rec.role_information14 :=
709: per_rol_shd.g_old_rec.role_information14;
705: per_rol_shd.g_old_rec.role_information13;
706: End If;
707: If (p_rec.role_information14 = hr_api.g_varchar2) then
708: p_rec.role_information14 :=
709: per_rol_shd.g_old_rec.role_information14;
710: End If;
711: If (p_rec.role_information15 = hr_api.g_varchar2) then
712: p_rec.role_information15 :=
713: per_rol_shd.g_old_rec.role_information15;
709: per_rol_shd.g_old_rec.role_information14;
710: End If;
711: If (p_rec.role_information15 = hr_api.g_varchar2) then
712: p_rec.role_information15 :=
713: per_rol_shd.g_old_rec.role_information15;
714: End If;
715: If (p_rec.role_information16 = hr_api.g_varchar2) then
716: p_rec.role_information16 :=
717: per_rol_shd.g_old_rec.role_information16;
713: per_rol_shd.g_old_rec.role_information15;
714: End If;
715: If (p_rec.role_information16 = hr_api.g_varchar2) then
716: p_rec.role_information16 :=
717: per_rol_shd.g_old_rec.role_information16;
718: End If;
719: If (p_rec.role_information17 = hr_api.g_varchar2) then
720: p_rec.role_information17 :=
721: per_rol_shd.g_old_rec.role_information17;
717: per_rol_shd.g_old_rec.role_information16;
718: End If;
719: If (p_rec.role_information17 = hr_api.g_varchar2) then
720: p_rec.role_information17 :=
721: per_rol_shd.g_old_rec.role_information17;
722: End If;
723: If (p_rec.role_information18 = hr_api.g_varchar2) then
724: p_rec.role_information18 :=
725: per_rol_shd.g_old_rec.role_information18;
721: per_rol_shd.g_old_rec.role_information17;
722: End If;
723: If (p_rec.role_information18 = hr_api.g_varchar2) then
724: p_rec.role_information18 :=
725: per_rol_shd.g_old_rec.role_information18;
726: End If;
727: If (p_rec.role_information19 = hr_api.g_varchar2) then
728: p_rec.role_information19 :=
729: per_rol_shd.g_old_rec.role_information19;
725: per_rol_shd.g_old_rec.role_information18;
726: End If;
727: If (p_rec.role_information19 = hr_api.g_varchar2) then
728: p_rec.role_information19 :=
729: per_rol_shd.g_old_rec.role_information19;
730: End If;
731: If (p_rec.role_information20 = hr_api.g_varchar2) then
732: p_rec.role_information20 :=
733: per_rol_shd.g_old_rec.role_information20;
729: per_rol_shd.g_old_rec.role_information19;
730: End If;
731: If (p_rec.role_information20 = hr_api.g_varchar2) then
732: p_rec.role_information20 :=
733: per_rol_shd.g_old_rec.role_information20;
734: End If;
735: --
736: End convert_defs;
737: --
739: -- |---------------------------------< upd >----------------------------------|
740: -- ----------------------------------------------------------------------------
741: Procedure upd
742: (p_effective_date in date
743: ,p_rec in out nocopy per_rol_shd.g_rec_type
744: ) is
745: --
746: l_proc varchar2(72) := g_package||'upd';
747: --
749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: -- We must lock the row which we need to update.
752: --
753: per_rol_shd.lck
754: (p_rec.role_id
755: ,p_rec.object_version_number
756: );
757: --
840: ,p_role_information20 in varchar2 default hr_api.g_varchar2
841: ,p_old_end_date in date default hr_api.g_date -- fix 1370960
842: ) is
843: --
844: l_rec per_rol_shd.g_rec_type;
845: l_proc varchar2(72) := g_package||'upd';
846: --
847: Begin
848: hr_utility.set_location('Entering:'||l_proc, 5);
850: -- Call conversion function to turn arguments into the
851: -- l_rec structure.
852: --
853: l_rec :=
854: per_rol_shd.convert_args
855: (p_role_id
856: ,hr_api.g_number
857: ,hr_api.g_number
858: ,hr_api.g_number