[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_cei_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: --
148: pqh_cei_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: --
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: --
153: pqh_cei_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: --
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: --
158: pqh_cei_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: --
162: Raise;
194: --
195: -- {End Of Comments}
196: -- ----------------------------------------------------------------------------
197: Procedure pre_update
198: (p_rec in pqh_cei_shd.g_rec_type
199: ) is
200: --
201: l_proc varchar2(72) := g_package||'pre_update';
202: --
239: -- {End Of Comments}
240: -- ----------------------------------------------------------------------------
241: Procedure post_update
242: (p_effective_date in date
243: ,p_rec in pqh_cei_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'post_update';
247: --
383: => p_rec.attribute_category
384: ,p_object_version_number
385: => p_rec.object_version_number
386: ,p_corps_definition_id_o
387: => pqh_cei_shd.g_old_rec.corps_definition_id
388: ,p_information_type_o
389: => pqh_cei_shd.g_old_rec.information_type
390: ,p_information1_o
391: => pqh_cei_shd.g_old_rec.information1
385: => p_rec.object_version_number
386: ,p_corps_definition_id_o
387: => pqh_cei_shd.g_old_rec.corps_definition_id
388: ,p_information_type_o
389: => pqh_cei_shd.g_old_rec.information_type
390: ,p_information1_o
391: => pqh_cei_shd.g_old_rec.information1
392: ,p_information2_o
393: => pqh_cei_shd.g_old_rec.information2
387: => pqh_cei_shd.g_old_rec.corps_definition_id
388: ,p_information_type_o
389: => pqh_cei_shd.g_old_rec.information_type
390: ,p_information1_o
391: => pqh_cei_shd.g_old_rec.information1
392: ,p_information2_o
393: => pqh_cei_shd.g_old_rec.information2
394: ,p_information3_o
395: => pqh_cei_shd.g_old_rec.information3
389: => pqh_cei_shd.g_old_rec.information_type
390: ,p_information1_o
391: => pqh_cei_shd.g_old_rec.information1
392: ,p_information2_o
393: => pqh_cei_shd.g_old_rec.information2
394: ,p_information3_o
395: => pqh_cei_shd.g_old_rec.information3
396: ,p_information4_o
397: => pqh_cei_shd.g_old_rec.information4
391: => pqh_cei_shd.g_old_rec.information1
392: ,p_information2_o
393: => pqh_cei_shd.g_old_rec.information2
394: ,p_information3_o
395: => pqh_cei_shd.g_old_rec.information3
396: ,p_information4_o
397: => pqh_cei_shd.g_old_rec.information4
398: ,p_information5_o
399: => pqh_cei_shd.g_old_rec.information5
393: => pqh_cei_shd.g_old_rec.information2
394: ,p_information3_o
395: => pqh_cei_shd.g_old_rec.information3
396: ,p_information4_o
397: => pqh_cei_shd.g_old_rec.information4
398: ,p_information5_o
399: => pqh_cei_shd.g_old_rec.information5
400: ,p_information6_o
401: => pqh_cei_shd.g_old_rec.information6
395: => pqh_cei_shd.g_old_rec.information3
396: ,p_information4_o
397: => pqh_cei_shd.g_old_rec.information4
398: ,p_information5_o
399: => pqh_cei_shd.g_old_rec.information5
400: ,p_information6_o
401: => pqh_cei_shd.g_old_rec.information6
402: ,p_information7_o
403: => pqh_cei_shd.g_old_rec.information7
397: => pqh_cei_shd.g_old_rec.information4
398: ,p_information5_o
399: => pqh_cei_shd.g_old_rec.information5
400: ,p_information6_o
401: => pqh_cei_shd.g_old_rec.information6
402: ,p_information7_o
403: => pqh_cei_shd.g_old_rec.information7
404: ,p_information8_o
405: => pqh_cei_shd.g_old_rec.information8
399: => pqh_cei_shd.g_old_rec.information5
400: ,p_information6_o
401: => pqh_cei_shd.g_old_rec.information6
402: ,p_information7_o
403: => pqh_cei_shd.g_old_rec.information7
404: ,p_information8_o
405: => pqh_cei_shd.g_old_rec.information8
406: ,p_information9_o
407: => pqh_cei_shd.g_old_rec.information9
401: => pqh_cei_shd.g_old_rec.information6
402: ,p_information7_o
403: => pqh_cei_shd.g_old_rec.information7
404: ,p_information8_o
405: => pqh_cei_shd.g_old_rec.information8
406: ,p_information9_o
407: => pqh_cei_shd.g_old_rec.information9
408: ,p_information10_o
409: => pqh_cei_shd.g_old_rec.information10
403: => pqh_cei_shd.g_old_rec.information7
404: ,p_information8_o
405: => pqh_cei_shd.g_old_rec.information8
406: ,p_information9_o
407: => pqh_cei_shd.g_old_rec.information9
408: ,p_information10_o
409: => pqh_cei_shd.g_old_rec.information10
410: ,p_information11_o
411: => pqh_cei_shd.g_old_rec.information11
405: => pqh_cei_shd.g_old_rec.information8
406: ,p_information9_o
407: => pqh_cei_shd.g_old_rec.information9
408: ,p_information10_o
409: => pqh_cei_shd.g_old_rec.information10
410: ,p_information11_o
411: => pqh_cei_shd.g_old_rec.information11
412: ,p_information12_o
413: => pqh_cei_shd.g_old_rec.information12
407: => pqh_cei_shd.g_old_rec.information9
408: ,p_information10_o
409: => pqh_cei_shd.g_old_rec.information10
410: ,p_information11_o
411: => pqh_cei_shd.g_old_rec.information11
412: ,p_information12_o
413: => pqh_cei_shd.g_old_rec.information12
414: ,p_information13_o
415: => pqh_cei_shd.g_old_rec.information13
409: => pqh_cei_shd.g_old_rec.information10
410: ,p_information11_o
411: => pqh_cei_shd.g_old_rec.information11
412: ,p_information12_o
413: => pqh_cei_shd.g_old_rec.information12
414: ,p_information13_o
415: => pqh_cei_shd.g_old_rec.information13
416: ,p_information14_o
417: => pqh_cei_shd.g_old_rec.information14
411: => pqh_cei_shd.g_old_rec.information11
412: ,p_information12_o
413: => pqh_cei_shd.g_old_rec.information12
414: ,p_information13_o
415: => pqh_cei_shd.g_old_rec.information13
416: ,p_information14_o
417: => pqh_cei_shd.g_old_rec.information14
418: ,p_information15_o
419: => pqh_cei_shd.g_old_rec.information15
413: => pqh_cei_shd.g_old_rec.information12
414: ,p_information13_o
415: => pqh_cei_shd.g_old_rec.information13
416: ,p_information14_o
417: => pqh_cei_shd.g_old_rec.information14
418: ,p_information15_o
419: => pqh_cei_shd.g_old_rec.information15
420: ,p_information16_o
421: => pqh_cei_shd.g_old_rec.information16
415: => pqh_cei_shd.g_old_rec.information13
416: ,p_information14_o
417: => pqh_cei_shd.g_old_rec.information14
418: ,p_information15_o
419: => pqh_cei_shd.g_old_rec.information15
420: ,p_information16_o
421: => pqh_cei_shd.g_old_rec.information16
422: ,p_information17_o
423: => pqh_cei_shd.g_old_rec.information17
417: => pqh_cei_shd.g_old_rec.information14
418: ,p_information15_o
419: => pqh_cei_shd.g_old_rec.information15
420: ,p_information16_o
421: => pqh_cei_shd.g_old_rec.information16
422: ,p_information17_o
423: => pqh_cei_shd.g_old_rec.information17
424: ,p_information18_o
425: => pqh_cei_shd.g_old_rec.information18
419: => pqh_cei_shd.g_old_rec.information15
420: ,p_information16_o
421: => pqh_cei_shd.g_old_rec.information16
422: ,p_information17_o
423: => pqh_cei_shd.g_old_rec.information17
424: ,p_information18_o
425: => pqh_cei_shd.g_old_rec.information18
426: ,p_information19_o
427: => pqh_cei_shd.g_old_rec.information19
421: => pqh_cei_shd.g_old_rec.information16
422: ,p_information17_o
423: => pqh_cei_shd.g_old_rec.information17
424: ,p_information18_o
425: => pqh_cei_shd.g_old_rec.information18
426: ,p_information19_o
427: => pqh_cei_shd.g_old_rec.information19
428: ,p_information20_o
429: => pqh_cei_shd.g_old_rec.information20
423: => pqh_cei_shd.g_old_rec.information17
424: ,p_information18_o
425: => pqh_cei_shd.g_old_rec.information18
426: ,p_information19_o
427: => pqh_cei_shd.g_old_rec.information19
428: ,p_information20_o
429: => pqh_cei_shd.g_old_rec.information20
430: ,p_information21_o
431: => pqh_cei_shd.g_old_rec.information21
425: => pqh_cei_shd.g_old_rec.information18
426: ,p_information19_o
427: => pqh_cei_shd.g_old_rec.information19
428: ,p_information20_o
429: => pqh_cei_shd.g_old_rec.information20
430: ,p_information21_o
431: => pqh_cei_shd.g_old_rec.information21
432: ,p_information22_o
433: => pqh_cei_shd.g_old_rec.information22
427: => pqh_cei_shd.g_old_rec.information19
428: ,p_information20_o
429: => pqh_cei_shd.g_old_rec.information20
430: ,p_information21_o
431: => pqh_cei_shd.g_old_rec.information21
432: ,p_information22_o
433: => pqh_cei_shd.g_old_rec.information22
434: ,p_information23_o
435: => pqh_cei_shd.g_old_rec.information23
429: => pqh_cei_shd.g_old_rec.information20
430: ,p_information21_o
431: => pqh_cei_shd.g_old_rec.information21
432: ,p_information22_o
433: => pqh_cei_shd.g_old_rec.information22
434: ,p_information23_o
435: => pqh_cei_shd.g_old_rec.information23
436: ,p_information24_o
437: => pqh_cei_shd.g_old_rec.information24
431: => pqh_cei_shd.g_old_rec.information21
432: ,p_information22_o
433: => pqh_cei_shd.g_old_rec.information22
434: ,p_information23_o
435: => pqh_cei_shd.g_old_rec.information23
436: ,p_information24_o
437: => pqh_cei_shd.g_old_rec.information24
438: ,p_information25_o
439: => pqh_cei_shd.g_old_rec.information25
433: => pqh_cei_shd.g_old_rec.information22
434: ,p_information23_o
435: => pqh_cei_shd.g_old_rec.information23
436: ,p_information24_o
437: => pqh_cei_shd.g_old_rec.information24
438: ,p_information25_o
439: => pqh_cei_shd.g_old_rec.information25
440: ,p_information26_o
441: => pqh_cei_shd.g_old_rec.information26
435: => pqh_cei_shd.g_old_rec.information23
436: ,p_information24_o
437: => pqh_cei_shd.g_old_rec.information24
438: ,p_information25_o
439: => pqh_cei_shd.g_old_rec.information25
440: ,p_information26_o
441: => pqh_cei_shd.g_old_rec.information26
442: ,p_information27_o
443: => pqh_cei_shd.g_old_rec.information27
437: => pqh_cei_shd.g_old_rec.information24
438: ,p_information25_o
439: => pqh_cei_shd.g_old_rec.information25
440: ,p_information26_o
441: => pqh_cei_shd.g_old_rec.information26
442: ,p_information27_o
443: => pqh_cei_shd.g_old_rec.information27
444: ,p_information28_o
445: => pqh_cei_shd.g_old_rec.information28
439: => pqh_cei_shd.g_old_rec.information25
440: ,p_information26_o
441: => pqh_cei_shd.g_old_rec.information26
442: ,p_information27_o
443: => pqh_cei_shd.g_old_rec.information27
444: ,p_information28_o
445: => pqh_cei_shd.g_old_rec.information28
446: ,p_information29_o
447: => pqh_cei_shd.g_old_rec.information29
441: => pqh_cei_shd.g_old_rec.information26
442: ,p_information27_o
443: => pqh_cei_shd.g_old_rec.information27
444: ,p_information28_o
445: => pqh_cei_shd.g_old_rec.information28
446: ,p_information29_o
447: => pqh_cei_shd.g_old_rec.information29
448: ,p_information30_o
449: => pqh_cei_shd.g_old_rec.information30
443: => pqh_cei_shd.g_old_rec.information27
444: ,p_information28_o
445: => pqh_cei_shd.g_old_rec.information28
446: ,p_information29_o
447: => pqh_cei_shd.g_old_rec.information29
448: ,p_information30_o
449: => pqh_cei_shd.g_old_rec.information30
450: ,p_information_category_o
451: => pqh_cei_shd.g_old_rec.information_category
445: => pqh_cei_shd.g_old_rec.information28
446: ,p_information29_o
447: => pqh_cei_shd.g_old_rec.information29
448: ,p_information30_o
449: => pqh_cei_shd.g_old_rec.information30
450: ,p_information_category_o
451: => pqh_cei_shd.g_old_rec.information_category
452: ,p_attribute1_o
453: => pqh_cei_shd.g_old_rec.attribute1
447: => pqh_cei_shd.g_old_rec.information29
448: ,p_information30_o
449: => pqh_cei_shd.g_old_rec.information30
450: ,p_information_category_o
451: => pqh_cei_shd.g_old_rec.information_category
452: ,p_attribute1_o
453: => pqh_cei_shd.g_old_rec.attribute1
454: ,p_attribute2_o
455: => pqh_cei_shd.g_old_rec.attribute2
449: => pqh_cei_shd.g_old_rec.information30
450: ,p_information_category_o
451: => pqh_cei_shd.g_old_rec.information_category
452: ,p_attribute1_o
453: => pqh_cei_shd.g_old_rec.attribute1
454: ,p_attribute2_o
455: => pqh_cei_shd.g_old_rec.attribute2
456: ,p_attribute3_o
457: => pqh_cei_shd.g_old_rec.attribute3
451: => pqh_cei_shd.g_old_rec.information_category
452: ,p_attribute1_o
453: => pqh_cei_shd.g_old_rec.attribute1
454: ,p_attribute2_o
455: => pqh_cei_shd.g_old_rec.attribute2
456: ,p_attribute3_o
457: => pqh_cei_shd.g_old_rec.attribute3
458: ,p_attribute4_o
459: => pqh_cei_shd.g_old_rec.attribute4
453: => pqh_cei_shd.g_old_rec.attribute1
454: ,p_attribute2_o
455: => pqh_cei_shd.g_old_rec.attribute2
456: ,p_attribute3_o
457: => pqh_cei_shd.g_old_rec.attribute3
458: ,p_attribute4_o
459: => pqh_cei_shd.g_old_rec.attribute4
460: ,p_attribute5_o
461: => pqh_cei_shd.g_old_rec.attribute5
455: => pqh_cei_shd.g_old_rec.attribute2
456: ,p_attribute3_o
457: => pqh_cei_shd.g_old_rec.attribute3
458: ,p_attribute4_o
459: => pqh_cei_shd.g_old_rec.attribute4
460: ,p_attribute5_o
461: => pqh_cei_shd.g_old_rec.attribute5
462: ,p_attribute6_o
463: => pqh_cei_shd.g_old_rec.attribute6
457: => pqh_cei_shd.g_old_rec.attribute3
458: ,p_attribute4_o
459: => pqh_cei_shd.g_old_rec.attribute4
460: ,p_attribute5_o
461: => pqh_cei_shd.g_old_rec.attribute5
462: ,p_attribute6_o
463: => pqh_cei_shd.g_old_rec.attribute6
464: ,p_attribute7_o
465: => pqh_cei_shd.g_old_rec.attribute7
459: => pqh_cei_shd.g_old_rec.attribute4
460: ,p_attribute5_o
461: => pqh_cei_shd.g_old_rec.attribute5
462: ,p_attribute6_o
463: => pqh_cei_shd.g_old_rec.attribute6
464: ,p_attribute7_o
465: => pqh_cei_shd.g_old_rec.attribute7
466: ,p_attribute8_o
467: => pqh_cei_shd.g_old_rec.attribute8
461: => pqh_cei_shd.g_old_rec.attribute5
462: ,p_attribute6_o
463: => pqh_cei_shd.g_old_rec.attribute6
464: ,p_attribute7_o
465: => pqh_cei_shd.g_old_rec.attribute7
466: ,p_attribute8_o
467: => pqh_cei_shd.g_old_rec.attribute8
468: ,p_attribute9_o
469: => pqh_cei_shd.g_old_rec.attribute9
463: => pqh_cei_shd.g_old_rec.attribute6
464: ,p_attribute7_o
465: => pqh_cei_shd.g_old_rec.attribute7
466: ,p_attribute8_o
467: => pqh_cei_shd.g_old_rec.attribute8
468: ,p_attribute9_o
469: => pqh_cei_shd.g_old_rec.attribute9
470: ,p_attribute10_o
471: => pqh_cei_shd.g_old_rec.attribute10
465: => pqh_cei_shd.g_old_rec.attribute7
466: ,p_attribute8_o
467: => pqh_cei_shd.g_old_rec.attribute8
468: ,p_attribute9_o
469: => pqh_cei_shd.g_old_rec.attribute9
470: ,p_attribute10_o
471: => pqh_cei_shd.g_old_rec.attribute10
472: ,p_attribute11_o
473: => pqh_cei_shd.g_old_rec.attribute11
467: => pqh_cei_shd.g_old_rec.attribute8
468: ,p_attribute9_o
469: => pqh_cei_shd.g_old_rec.attribute9
470: ,p_attribute10_o
471: => pqh_cei_shd.g_old_rec.attribute10
472: ,p_attribute11_o
473: => pqh_cei_shd.g_old_rec.attribute11
474: ,p_attribute12_o
475: => pqh_cei_shd.g_old_rec.attribute12
469: => pqh_cei_shd.g_old_rec.attribute9
470: ,p_attribute10_o
471: => pqh_cei_shd.g_old_rec.attribute10
472: ,p_attribute11_o
473: => pqh_cei_shd.g_old_rec.attribute11
474: ,p_attribute12_o
475: => pqh_cei_shd.g_old_rec.attribute12
476: ,p_attribute13_o
477: => pqh_cei_shd.g_old_rec.attribute13
471: => pqh_cei_shd.g_old_rec.attribute10
472: ,p_attribute11_o
473: => pqh_cei_shd.g_old_rec.attribute11
474: ,p_attribute12_o
475: => pqh_cei_shd.g_old_rec.attribute12
476: ,p_attribute13_o
477: => pqh_cei_shd.g_old_rec.attribute13
478: ,p_attribute14_o
479: => pqh_cei_shd.g_old_rec.attribute14
473: => pqh_cei_shd.g_old_rec.attribute11
474: ,p_attribute12_o
475: => pqh_cei_shd.g_old_rec.attribute12
476: ,p_attribute13_o
477: => pqh_cei_shd.g_old_rec.attribute13
478: ,p_attribute14_o
479: => pqh_cei_shd.g_old_rec.attribute14
480: ,p_attribute15_o
481: => pqh_cei_shd.g_old_rec.attribute15
475: => pqh_cei_shd.g_old_rec.attribute12
476: ,p_attribute13_o
477: => pqh_cei_shd.g_old_rec.attribute13
478: ,p_attribute14_o
479: => pqh_cei_shd.g_old_rec.attribute14
480: ,p_attribute15_o
481: => pqh_cei_shd.g_old_rec.attribute15
482: ,p_attribute16_o
483: => pqh_cei_shd.g_old_rec.attribute16
477: => pqh_cei_shd.g_old_rec.attribute13
478: ,p_attribute14_o
479: => pqh_cei_shd.g_old_rec.attribute14
480: ,p_attribute15_o
481: => pqh_cei_shd.g_old_rec.attribute15
482: ,p_attribute16_o
483: => pqh_cei_shd.g_old_rec.attribute16
484: ,p_attribute17_o
485: => pqh_cei_shd.g_old_rec.attribute17
479: => pqh_cei_shd.g_old_rec.attribute14
480: ,p_attribute15_o
481: => pqh_cei_shd.g_old_rec.attribute15
482: ,p_attribute16_o
483: => pqh_cei_shd.g_old_rec.attribute16
484: ,p_attribute17_o
485: => pqh_cei_shd.g_old_rec.attribute17
486: ,p_attribute18_o
487: => pqh_cei_shd.g_old_rec.attribute18
481: => pqh_cei_shd.g_old_rec.attribute15
482: ,p_attribute16_o
483: => pqh_cei_shd.g_old_rec.attribute16
484: ,p_attribute17_o
485: => pqh_cei_shd.g_old_rec.attribute17
486: ,p_attribute18_o
487: => pqh_cei_shd.g_old_rec.attribute18
488: ,p_attribute19_o
489: => pqh_cei_shd.g_old_rec.attribute19
483: => pqh_cei_shd.g_old_rec.attribute16
484: ,p_attribute17_o
485: => pqh_cei_shd.g_old_rec.attribute17
486: ,p_attribute18_o
487: => pqh_cei_shd.g_old_rec.attribute18
488: ,p_attribute19_o
489: => pqh_cei_shd.g_old_rec.attribute19
490: ,p_attribute20_o
491: => pqh_cei_shd.g_old_rec.attribute20
485: => pqh_cei_shd.g_old_rec.attribute17
486: ,p_attribute18_o
487: => pqh_cei_shd.g_old_rec.attribute18
488: ,p_attribute19_o
489: => pqh_cei_shd.g_old_rec.attribute19
490: ,p_attribute20_o
491: => pqh_cei_shd.g_old_rec.attribute20
492: ,p_attribute21_o
493: => pqh_cei_shd.g_old_rec.attribute21
487: => pqh_cei_shd.g_old_rec.attribute18
488: ,p_attribute19_o
489: => pqh_cei_shd.g_old_rec.attribute19
490: ,p_attribute20_o
491: => pqh_cei_shd.g_old_rec.attribute20
492: ,p_attribute21_o
493: => pqh_cei_shd.g_old_rec.attribute21
494: ,p_attribute22_o
495: => pqh_cei_shd.g_old_rec.attribute22
489: => pqh_cei_shd.g_old_rec.attribute19
490: ,p_attribute20_o
491: => pqh_cei_shd.g_old_rec.attribute20
492: ,p_attribute21_o
493: => pqh_cei_shd.g_old_rec.attribute21
494: ,p_attribute22_o
495: => pqh_cei_shd.g_old_rec.attribute22
496: ,p_attribute23_o
497: => pqh_cei_shd.g_old_rec.attribute23
491: => pqh_cei_shd.g_old_rec.attribute20
492: ,p_attribute21_o
493: => pqh_cei_shd.g_old_rec.attribute21
494: ,p_attribute22_o
495: => pqh_cei_shd.g_old_rec.attribute22
496: ,p_attribute23_o
497: => pqh_cei_shd.g_old_rec.attribute23
498: ,p_attribute24_o
499: => pqh_cei_shd.g_old_rec.attribute24
493: => pqh_cei_shd.g_old_rec.attribute21
494: ,p_attribute22_o
495: => pqh_cei_shd.g_old_rec.attribute22
496: ,p_attribute23_o
497: => pqh_cei_shd.g_old_rec.attribute23
498: ,p_attribute24_o
499: => pqh_cei_shd.g_old_rec.attribute24
500: ,p_attribute25_o
501: => pqh_cei_shd.g_old_rec.attribute25
495: => pqh_cei_shd.g_old_rec.attribute22
496: ,p_attribute23_o
497: => pqh_cei_shd.g_old_rec.attribute23
498: ,p_attribute24_o
499: => pqh_cei_shd.g_old_rec.attribute24
500: ,p_attribute25_o
501: => pqh_cei_shd.g_old_rec.attribute25
502: ,p_attribute26_o
503: => pqh_cei_shd.g_old_rec.attribute26
497: => pqh_cei_shd.g_old_rec.attribute23
498: ,p_attribute24_o
499: => pqh_cei_shd.g_old_rec.attribute24
500: ,p_attribute25_o
501: => pqh_cei_shd.g_old_rec.attribute25
502: ,p_attribute26_o
503: => pqh_cei_shd.g_old_rec.attribute26
504: ,p_attribute27_o
505: => pqh_cei_shd.g_old_rec.attribute27
499: => pqh_cei_shd.g_old_rec.attribute24
500: ,p_attribute25_o
501: => pqh_cei_shd.g_old_rec.attribute25
502: ,p_attribute26_o
503: => pqh_cei_shd.g_old_rec.attribute26
504: ,p_attribute27_o
505: => pqh_cei_shd.g_old_rec.attribute27
506: ,p_attribute28_o
507: => pqh_cei_shd.g_old_rec.attribute28
501: => pqh_cei_shd.g_old_rec.attribute25
502: ,p_attribute26_o
503: => pqh_cei_shd.g_old_rec.attribute26
504: ,p_attribute27_o
505: => pqh_cei_shd.g_old_rec.attribute27
506: ,p_attribute28_o
507: => pqh_cei_shd.g_old_rec.attribute28
508: ,p_attribute29_o
509: => pqh_cei_shd.g_old_rec.attribute29
503: => pqh_cei_shd.g_old_rec.attribute26
504: ,p_attribute27_o
505: => pqh_cei_shd.g_old_rec.attribute27
506: ,p_attribute28_o
507: => pqh_cei_shd.g_old_rec.attribute28
508: ,p_attribute29_o
509: => pqh_cei_shd.g_old_rec.attribute29
510: ,p_attribute30_o
511: => pqh_cei_shd.g_old_rec.attribute30
505: => pqh_cei_shd.g_old_rec.attribute27
506: ,p_attribute28_o
507: => pqh_cei_shd.g_old_rec.attribute28
508: ,p_attribute29_o
509: => pqh_cei_shd.g_old_rec.attribute29
510: ,p_attribute30_o
511: => pqh_cei_shd.g_old_rec.attribute30
512: ,p_attribute_category_o
513: => pqh_cei_shd.g_old_rec.attribute_category
507: => pqh_cei_shd.g_old_rec.attribute28
508: ,p_attribute29_o
509: => pqh_cei_shd.g_old_rec.attribute29
510: ,p_attribute30_o
511: => pqh_cei_shd.g_old_rec.attribute30
512: ,p_attribute_category_o
513: => pqh_cei_shd.g_old_rec.attribute_category
514: ,p_object_version_number_o
515: => pqh_cei_shd.g_old_rec.object_version_number
509: => pqh_cei_shd.g_old_rec.attribute29
510: ,p_attribute30_o
511: => pqh_cei_shd.g_old_rec.attribute30
512: ,p_attribute_category_o
513: => pqh_cei_shd.g_old_rec.attribute_category
514: ,p_object_version_number_o
515: => pqh_cei_shd.g_old_rec.object_version_number
516: );
517: --
511: => pqh_cei_shd.g_old_rec.attribute30
512: ,p_attribute_category_o
513: => pqh_cei_shd.g_old_rec.attribute_category
514: ,p_object_version_number_o
515: => pqh_cei_shd.g_old_rec.object_version_number
516: );
517: --
518: exception
519: --
571: --
572: -- {End Of Comments}
573: -- ----------------------------------------------------------------------------
574: Procedure convert_defs
575: (p_rec in out nocopy pqh_cei_shd.g_rec_type
576: ) is
577: --
578: Begin
579: --
583: -- is being used then we must set to the 'current' argument value.
584: --
585: If (p_rec.corps_definition_id = hr_api.g_number) then
586: p_rec.corps_definition_id :=
587: pqh_cei_shd.g_old_rec.corps_definition_id;
588: End If;
589: If (p_rec.information_type = hr_api.g_varchar2) then
590: p_rec.information_type :=
591: pqh_cei_shd.g_old_rec.information_type;
587: pqh_cei_shd.g_old_rec.corps_definition_id;
588: End If;
589: If (p_rec.information_type = hr_api.g_varchar2) then
590: p_rec.information_type :=
591: pqh_cei_shd.g_old_rec.information_type;
592: End If;
593: If (p_rec.information1 = hr_api.g_varchar2) then
594: p_rec.information1 :=
595: pqh_cei_shd.g_old_rec.information1;
591: pqh_cei_shd.g_old_rec.information_type;
592: End If;
593: If (p_rec.information1 = hr_api.g_varchar2) then
594: p_rec.information1 :=
595: pqh_cei_shd.g_old_rec.information1;
596: End If;
597: If (p_rec.information2 = hr_api.g_varchar2) then
598: p_rec.information2 :=
599: pqh_cei_shd.g_old_rec.information2;
595: pqh_cei_shd.g_old_rec.information1;
596: End If;
597: If (p_rec.information2 = hr_api.g_varchar2) then
598: p_rec.information2 :=
599: pqh_cei_shd.g_old_rec.information2;
600: End If;
601: If (p_rec.information3 = hr_api.g_varchar2) then
602: p_rec.information3 :=
603: pqh_cei_shd.g_old_rec.information3;
599: pqh_cei_shd.g_old_rec.information2;
600: End If;
601: If (p_rec.information3 = hr_api.g_varchar2) then
602: p_rec.information3 :=
603: pqh_cei_shd.g_old_rec.information3;
604: End If;
605: If (p_rec.information4 = hr_api.g_varchar2) then
606: p_rec.information4 :=
607: pqh_cei_shd.g_old_rec.information4;
603: pqh_cei_shd.g_old_rec.information3;
604: End If;
605: If (p_rec.information4 = hr_api.g_varchar2) then
606: p_rec.information4 :=
607: pqh_cei_shd.g_old_rec.information4;
608: End If;
609: If (p_rec.information5 = hr_api.g_varchar2) then
610: p_rec.information5 :=
611: pqh_cei_shd.g_old_rec.information5;
607: pqh_cei_shd.g_old_rec.information4;
608: End If;
609: If (p_rec.information5 = hr_api.g_varchar2) then
610: p_rec.information5 :=
611: pqh_cei_shd.g_old_rec.information5;
612: End If;
613: If (p_rec.information6 = hr_api.g_varchar2) then
614: p_rec.information6 :=
615: pqh_cei_shd.g_old_rec.information6;
611: pqh_cei_shd.g_old_rec.information5;
612: End If;
613: If (p_rec.information6 = hr_api.g_varchar2) then
614: p_rec.information6 :=
615: pqh_cei_shd.g_old_rec.information6;
616: End If;
617: If (p_rec.information7 = hr_api.g_varchar2) then
618: p_rec.information7 :=
619: pqh_cei_shd.g_old_rec.information7;
615: pqh_cei_shd.g_old_rec.information6;
616: End If;
617: If (p_rec.information7 = hr_api.g_varchar2) then
618: p_rec.information7 :=
619: pqh_cei_shd.g_old_rec.information7;
620: End If;
621: If (p_rec.information8 = hr_api.g_varchar2) then
622: p_rec.information8 :=
623: pqh_cei_shd.g_old_rec.information8;
619: pqh_cei_shd.g_old_rec.information7;
620: End If;
621: If (p_rec.information8 = hr_api.g_varchar2) then
622: p_rec.information8 :=
623: pqh_cei_shd.g_old_rec.information8;
624: End If;
625: If (p_rec.information9 = hr_api.g_varchar2) then
626: p_rec.information9 :=
627: pqh_cei_shd.g_old_rec.information9;
623: pqh_cei_shd.g_old_rec.information8;
624: End If;
625: If (p_rec.information9 = hr_api.g_varchar2) then
626: p_rec.information9 :=
627: pqh_cei_shd.g_old_rec.information9;
628: End If;
629: If (p_rec.information10 = hr_api.g_varchar2) then
630: p_rec.information10 :=
631: pqh_cei_shd.g_old_rec.information10;
627: pqh_cei_shd.g_old_rec.information9;
628: End If;
629: If (p_rec.information10 = hr_api.g_varchar2) then
630: p_rec.information10 :=
631: pqh_cei_shd.g_old_rec.information10;
632: End If;
633: If (p_rec.information11 = hr_api.g_varchar2) then
634: p_rec.information11 :=
635: pqh_cei_shd.g_old_rec.information11;
631: pqh_cei_shd.g_old_rec.information10;
632: End If;
633: If (p_rec.information11 = hr_api.g_varchar2) then
634: p_rec.information11 :=
635: pqh_cei_shd.g_old_rec.information11;
636: End If;
637: If (p_rec.information12 = hr_api.g_varchar2) then
638: p_rec.information12 :=
639: pqh_cei_shd.g_old_rec.information12;
635: pqh_cei_shd.g_old_rec.information11;
636: End If;
637: If (p_rec.information12 = hr_api.g_varchar2) then
638: p_rec.information12 :=
639: pqh_cei_shd.g_old_rec.information12;
640: End If;
641: If (p_rec.information13 = hr_api.g_varchar2) then
642: p_rec.information13 :=
643: pqh_cei_shd.g_old_rec.information13;
639: pqh_cei_shd.g_old_rec.information12;
640: End If;
641: If (p_rec.information13 = hr_api.g_varchar2) then
642: p_rec.information13 :=
643: pqh_cei_shd.g_old_rec.information13;
644: End If;
645: If (p_rec.information14 = hr_api.g_varchar2) then
646: p_rec.information14 :=
647: pqh_cei_shd.g_old_rec.information14;
643: pqh_cei_shd.g_old_rec.information13;
644: End If;
645: If (p_rec.information14 = hr_api.g_varchar2) then
646: p_rec.information14 :=
647: pqh_cei_shd.g_old_rec.information14;
648: End If;
649: If (p_rec.information15 = hr_api.g_varchar2) then
650: p_rec.information15 :=
651: pqh_cei_shd.g_old_rec.information15;
647: pqh_cei_shd.g_old_rec.information14;
648: End If;
649: If (p_rec.information15 = hr_api.g_varchar2) then
650: p_rec.information15 :=
651: pqh_cei_shd.g_old_rec.information15;
652: End If;
653: If (p_rec.information16 = hr_api.g_varchar2) then
654: p_rec.information16 :=
655: pqh_cei_shd.g_old_rec.information16;
651: pqh_cei_shd.g_old_rec.information15;
652: End If;
653: If (p_rec.information16 = hr_api.g_varchar2) then
654: p_rec.information16 :=
655: pqh_cei_shd.g_old_rec.information16;
656: End If;
657: If (p_rec.information17 = hr_api.g_varchar2) then
658: p_rec.information17 :=
659: pqh_cei_shd.g_old_rec.information17;
655: pqh_cei_shd.g_old_rec.information16;
656: End If;
657: If (p_rec.information17 = hr_api.g_varchar2) then
658: p_rec.information17 :=
659: pqh_cei_shd.g_old_rec.information17;
660: End If;
661: If (p_rec.information18 = hr_api.g_varchar2) then
662: p_rec.information18 :=
663: pqh_cei_shd.g_old_rec.information18;
659: pqh_cei_shd.g_old_rec.information17;
660: End If;
661: If (p_rec.information18 = hr_api.g_varchar2) then
662: p_rec.information18 :=
663: pqh_cei_shd.g_old_rec.information18;
664: End If;
665: If (p_rec.information19 = hr_api.g_varchar2) then
666: p_rec.information19 :=
667: pqh_cei_shd.g_old_rec.information19;
663: pqh_cei_shd.g_old_rec.information18;
664: End If;
665: If (p_rec.information19 = hr_api.g_varchar2) then
666: p_rec.information19 :=
667: pqh_cei_shd.g_old_rec.information19;
668: End If;
669: If (p_rec.information20 = hr_api.g_varchar2) then
670: p_rec.information20 :=
671: pqh_cei_shd.g_old_rec.information20;
667: pqh_cei_shd.g_old_rec.information19;
668: End If;
669: If (p_rec.information20 = hr_api.g_varchar2) then
670: p_rec.information20 :=
671: pqh_cei_shd.g_old_rec.information20;
672: End If;
673: If (p_rec.information21 = hr_api.g_varchar2) then
674: p_rec.information21 :=
675: pqh_cei_shd.g_old_rec.information21;
671: pqh_cei_shd.g_old_rec.information20;
672: End If;
673: If (p_rec.information21 = hr_api.g_varchar2) then
674: p_rec.information21 :=
675: pqh_cei_shd.g_old_rec.information21;
676: End If;
677: If (p_rec.information22 = hr_api.g_varchar2) then
678: p_rec.information22 :=
679: pqh_cei_shd.g_old_rec.information22;
675: pqh_cei_shd.g_old_rec.information21;
676: End If;
677: If (p_rec.information22 = hr_api.g_varchar2) then
678: p_rec.information22 :=
679: pqh_cei_shd.g_old_rec.information22;
680: End If;
681: If (p_rec.information23 = hr_api.g_varchar2) then
682: p_rec.information23 :=
683: pqh_cei_shd.g_old_rec.information23;
679: pqh_cei_shd.g_old_rec.information22;
680: End If;
681: If (p_rec.information23 = hr_api.g_varchar2) then
682: p_rec.information23 :=
683: pqh_cei_shd.g_old_rec.information23;
684: End If;
685: If (p_rec.information24 = hr_api.g_varchar2) then
686: p_rec.information24 :=
687: pqh_cei_shd.g_old_rec.information24;
683: pqh_cei_shd.g_old_rec.information23;
684: End If;
685: If (p_rec.information24 = hr_api.g_varchar2) then
686: p_rec.information24 :=
687: pqh_cei_shd.g_old_rec.information24;
688: End If;
689: If (p_rec.information25 = hr_api.g_varchar2) then
690: p_rec.information25 :=
691: pqh_cei_shd.g_old_rec.information25;
687: pqh_cei_shd.g_old_rec.information24;
688: End If;
689: If (p_rec.information25 = hr_api.g_varchar2) then
690: p_rec.information25 :=
691: pqh_cei_shd.g_old_rec.information25;
692: End If;
693: If (p_rec.information26 = hr_api.g_varchar2) then
694: p_rec.information26 :=
695: pqh_cei_shd.g_old_rec.information26;
691: pqh_cei_shd.g_old_rec.information25;
692: End If;
693: If (p_rec.information26 = hr_api.g_varchar2) then
694: p_rec.information26 :=
695: pqh_cei_shd.g_old_rec.information26;
696: End If;
697: If (p_rec.information27 = hr_api.g_varchar2) then
698: p_rec.information27 :=
699: pqh_cei_shd.g_old_rec.information27;
695: pqh_cei_shd.g_old_rec.information26;
696: End If;
697: If (p_rec.information27 = hr_api.g_varchar2) then
698: p_rec.information27 :=
699: pqh_cei_shd.g_old_rec.information27;
700: End If;
701: If (p_rec.information28 = hr_api.g_varchar2) then
702: p_rec.information28 :=
703: pqh_cei_shd.g_old_rec.information28;
699: pqh_cei_shd.g_old_rec.information27;
700: End If;
701: If (p_rec.information28 = hr_api.g_varchar2) then
702: p_rec.information28 :=
703: pqh_cei_shd.g_old_rec.information28;
704: End If;
705: If (p_rec.information29 = hr_api.g_varchar2) then
706: p_rec.information29 :=
707: pqh_cei_shd.g_old_rec.information29;
703: pqh_cei_shd.g_old_rec.information28;
704: End If;
705: If (p_rec.information29 = hr_api.g_varchar2) then
706: p_rec.information29 :=
707: pqh_cei_shd.g_old_rec.information29;
708: End If;
709: If (p_rec.information30 = hr_api.g_varchar2) then
710: p_rec.information30 :=
711: pqh_cei_shd.g_old_rec.information30;
707: pqh_cei_shd.g_old_rec.information29;
708: End If;
709: If (p_rec.information30 = hr_api.g_varchar2) then
710: p_rec.information30 :=
711: pqh_cei_shd.g_old_rec.information30;
712: End If;
713: If (p_rec.information_category = hr_api.g_varchar2) then
714: p_rec.information_category :=
715: pqh_cei_shd.g_old_rec.information_category;
711: pqh_cei_shd.g_old_rec.information30;
712: End If;
713: If (p_rec.information_category = hr_api.g_varchar2) then
714: p_rec.information_category :=
715: pqh_cei_shd.g_old_rec.information_category;
716: End If;
717: If (p_rec.attribute1 = hr_api.g_varchar2) then
718: p_rec.attribute1 :=
719: pqh_cei_shd.g_old_rec.attribute1;
715: pqh_cei_shd.g_old_rec.information_category;
716: End If;
717: If (p_rec.attribute1 = hr_api.g_varchar2) then
718: p_rec.attribute1 :=
719: pqh_cei_shd.g_old_rec.attribute1;
720: End If;
721: If (p_rec.attribute2 = hr_api.g_varchar2) then
722: p_rec.attribute2 :=
723: pqh_cei_shd.g_old_rec.attribute2;
719: pqh_cei_shd.g_old_rec.attribute1;
720: End If;
721: If (p_rec.attribute2 = hr_api.g_varchar2) then
722: p_rec.attribute2 :=
723: pqh_cei_shd.g_old_rec.attribute2;
724: End If;
725: If (p_rec.attribute3 = hr_api.g_varchar2) then
726: p_rec.attribute3 :=
727: pqh_cei_shd.g_old_rec.attribute3;
723: pqh_cei_shd.g_old_rec.attribute2;
724: End If;
725: If (p_rec.attribute3 = hr_api.g_varchar2) then
726: p_rec.attribute3 :=
727: pqh_cei_shd.g_old_rec.attribute3;
728: End If;
729: If (p_rec.attribute4 = hr_api.g_varchar2) then
730: p_rec.attribute4 :=
731: pqh_cei_shd.g_old_rec.attribute4;
727: pqh_cei_shd.g_old_rec.attribute3;
728: End If;
729: If (p_rec.attribute4 = hr_api.g_varchar2) then
730: p_rec.attribute4 :=
731: pqh_cei_shd.g_old_rec.attribute4;
732: End If;
733: If (p_rec.attribute5 = hr_api.g_varchar2) then
734: p_rec.attribute5 :=
735: pqh_cei_shd.g_old_rec.attribute5;
731: pqh_cei_shd.g_old_rec.attribute4;
732: End If;
733: If (p_rec.attribute5 = hr_api.g_varchar2) then
734: p_rec.attribute5 :=
735: pqh_cei_shd.g_old_rec.attribute5;
736: End If;
737: If (p_rec.attribute6 = hr_api.g_varchar2) then
738: p_rec.attribute6 :=
739: pqh_cei_shd.g_old_rec.attribute6;
735: pqh_cei_shd.g_old_rec.attribute5;
736: End If;
737: If (p_rec.attribute6 = hr_api.g_varchar2) then
738: p_rec.attribute6 :=
739: pqh_cei_shd.g_old_rec.attribute6;
740: End If;
741: If (p_rec.attribute7 = hr_api.g_varchar2) then
742: p_rec.attribute7 :=
743: pqh_cei_shd.g_old_rec.attribute7;
739: pqh_cei_shd.g_old_rec.attribute6;
740: End If;
741: If (p_rec.attribute7 = hr_api.g_varchar2) then
742: p_rec.attribute7 :=
743: pqh_cei_shd.g_old_rec.attribute7;
744: End If;
745: If (p_rec.attribute8 = hr_api.g_varchar2) then
746: p_rec.attribute8 :=
747: pqh_cei_shd.g_old_rec.attribute8;
743: pqh_cei_shd.g_old_rec.attribute7;
744: End If;
745: If (p_rec.attribute8 = hr_api.g_varchar2) then
746: p_rec.attribute8 :=
747: pqh_cei_shd.g_old_rec.attribute8;
748: End If;
749: If (p_rec.attribute9 = hr_api.g_varchar2) then
750: p_rec.attribute9 :=
751: pqh_cei_shd.g_old_rec.attribute9;
747: pqh_cei_shd.g_old_rec.attribute8;
748: End If;
749: If (p_rec.attribute9 = hr_api.g_varchar2) then
750: p_rec.attribute9 :=
751: pqh_cei_shd.g_old_rec.attribute9;
752: End If;
753: If (p_rec.attribute10 = hr_api.g_varchar2) then
754: p_rec.attribute10 :=
755: pqh_cei_shd.g_old_rec.attribute10;
751: pqh_cei_shd.g_old_rec.attribute9;
752: End If;
753: If (p_rec.attribute10 = hr_api.g_varchar2) then
754: p_rec.attribute10 :=
755: pqh_cei_shd.g_old_rec.attribute10;
756: End If;
757: If (p_rec.attribute11 = hr_api.g_varchar2) then
758: p_rec.attribute11 :=
759: pqh_cei_shd.g_old_rec.attribute11;
755: pqh_cei_shd.g_old_rec.attribute10;
756: End If;
757: If (p_rec.attribute11 = hr_api.g_varchar2) then
758: p_rec.attribute11 :=
759: pqh_cei_shd.g_old_rec.attribute11;
760: End If;
761: If (p_rec.attribute12 = hr_api.g_varchar2) then
762: p_rec.attribute12 :=
763: pqh_cei_shd.g_old_rec.attribute12;
759: pqh_cei_shd.g_old_rec.attribute11;
760: End If;
761: If (p_rec.attribute12 = hr_api.g_varchar2) then
762: p_rec.attribute12 :=
763: pqh_cei_shd.g_old_rec.attribute12;
764: End If;
765: If (p_rec.attribute13 = hr_api.g_varchar2) then
766: p_rec.attribute13 :=
767: pqh_cei_shd.g_old_rec.attribute13;
763: pqh_cei_shd.g_old_rec.attribute12;
764: End If;
765: If (p_rec.attribute13 = hr_api.g_varchar2) then
766: p_rec.attribute13 :=
767: pqh_cei_shd.g_old_rec.attribute13;
768: End If;
769: If (p_rec.attribute14 = hr_api.g_varchar2) then
770: p_rec.attribute14 :=
771: pqh_cei_shd.g_old_rec.attribute14;
767: pqh_cei_shd.g_old_rec.attribute13;
768: End If;
769: If (p_rec.attribute14 = hr_api.g_varchar2) then
770: p_rec.attribute14 :=
771: pqh_cei_shd.g_old_rec.attribute14;
772: End If;
773: If (p_rec.attribute15 = hr_api.g_varchar2) then
774: p_rec.attribute15 :=
775: pqh_cei_shd.g_old_rec.attribute15;
771: pqh_cei_shd.g_old_rec.attribute14;
772: End If;
773: If (p_rec.attribute15 = hr_api.g_varchar2) then
774: p_rec.attribute15 :=
775: pqh_cei_shd.g_old_rec.attribute15;
776: End If;
777: If (p_rec.attribute16 = hr_api.g_varchar2) then
778: p_rec.attribute16 :=
779: pqh_cei_shd.g_old_rec.attribute16;
775: pqh_cei_shd.g_old_rec.attribute15;
776: End If;
777: If (p_rec.attribute16 = hr_api.g_varchar2) then
778: p_rec.attribute16 :=
779: pqh_cei_shd.g_old_rec.attribute16;
780: End If;
781: If (p_rec.attribute17 = hr_api.g_varchar2) then
782: p_rec.attribute17 :=
783: pqh_cei_shd.g_old_rec.attribute17;
779: pqh_cei_shd.g_old_rec.attribute16;
780: End If;
781: If (p_rec.attribute17 = hr_api.g_varchar2) then
782: p_rec.attribute17 :=
783: pqh_cei_shd.g_old_rec.attribute17;
784: End If;
785: If (p_rec.attribute18 = hr_api.g_varchar2) then
786: p_rec.attribute18 :=
787: pqh_cei_shd.g_old_rec.attribute18;
783: pqh_cei_shd.g_old_rec.attribute17;
784: End If;
785: If (p_rec.attribute18 = hr_api.g_varchar2) then
786: p_rec.attribute18 :=
787: pqh_cei_shd.g_old_rec.attribute18;
788: End If;
789: If (p_rec.attribute19 = hr_api.g_varchar2) then
790: p_rec.attribute19 :=
791: pqh_cei_shd.g_old_rec.attribute19;
787: pqh_cei_shd.g_old_rec.attribute18;
788: End If;
789: If (p_rec.attribute19 = hr_api.g_varchar2) then
790: p_rec.attribute19 :=
791: pqh_cei_shd.g_old_rec.attribute19;
792: End If;
793: If (p_rec.attribute20 = hr_api.g_varchar2) then
794: p_rec.attribute20 :=
795: pqh_cei_shd.g_old_rec.attribute20;
791: pqh_cei_shd.g_old_rec.attribute19;
792: End If;
793: If (p_rec.attribute20 = hr_api.g_varchar2) then
794: p_rec.attribute20 :=
795: pqh_cei_shd.g_old_rec.attribute20;
796: End If;
797: If (p_rec.attribute21 = hr_api.g_varchar2) then
798: p_rec.attribute21 :=
799: pqh_cei_shd.g_old_rec.attribute21;
795: pqh_cei_shd.g_old_rec.attribute20;
796: End If;
797: If (p_rec.attribute21 = hr_api.g_varchar2) then
798: p_rec.attribute21 :=
799: pqh_cei_shd.g_old_rec.attribute21;
800: End If;
801: If (p_rec.attribute22 = hr_api.g_varchar2) then
802: p_rec.attribute22 :=
803: pqh_cei_shd.g_old_rec.attribute22;
799: pqh_cei_shd.g_old_rec.attribute21;
800: End If;
801: If (p_rec.attribute22 = hr_api.g_varchar2) then
802: p_rec.attribute22 :=
803: pqh_cei_shd.g_old_rec.attribute22;
804: End If;
805: If (p_rec.attribute23 = hr_api.g_varchar2) then
806: p_rec.attribute23 :=
807: pqh_cei_shd.g_old_rec.attribute23;
803: pqh_cei_shd.g_old_rec.attribute22;
804: End If;
805: If (p_rec.attribute23 = hr_api.g_varchar2) then
806: p_rec.attribute23 :=
807: pqh_cei_shd.g_old_rec.attribute23;
808: End If;
809: If (p_rec.attribute24 = hr_api.g_varchar2) then
810: p_rec.attribute24 :=
811: pqh_cei_shd.g_old_rec.attribute24;
807: pqh_cei_shd.g_old_rec.attribute23;
808: End If;
809: If (p_rec.attribute24 = hr_api.g_varchar2) then
810: p_rec.attribute24 :=
811: pqh_cei_shd.g_old_rec.attribute24;
812: End If;
813: If (p_rec.attribute25 = hr_api.g_varchar2) then
814: p_rec.attribute25 :=
815: pqh_cei_shd.g_old_rec.attribute25;
811: pqh_cei_shd.g_old_rec.attribute24;
812: End If;
813: If (p_rec.attribute25 = hr_api.g_varchar2) then
814: p_rec.attribute25 :=
815: pqh_cei_shd.g_old_rec.attribute25;
816: End If;
817: If (p_rec.attribute26 = hr_api.g_varchar2) then
818: p_rec.attribute26 :=
819: pqh_cei_shd.g_old_rec.attribute26;
815: pqh_cei_shd.g_old_rec.attribute25;
816: End If;
817: If (p_rec.attribute26 = hr_api.g_varchar2) then
818: p_rec.attribute26 :=
819: pqh_cei_shd.g_old_rec.attribute26;
820: End If;
821: If (p_rec.attribute27 = hr_api.g_varchar2) then
822: p_rec.attribute27 :=
823: pqh_cei_shd.g_old_rec.attribute27;
819: pqh_cei_shd.g_old_rec.attribute26;
820: End If;
821: If (p_rec.attribute27 = hr_api.g_varchar2) then
822: p_rec.attribute27 :=
823: pqh_cei_shd.g_old_rec.attribute27;
824: End If;
825: If (p_rec.attribute28 = hr_api.g_varchar2) then
826: p_rec.attribute28 :=
827: pqh_cei_shd.g_old_rec.attribute28;
823: pqh_cei_shd.g_old_rec.attribute27;
824: End If;
825: If (p_rec.attribute28 = hr_api.g_varchar2) then
826: p_rec.attribute28 :=
827: pqh_cei_shd.g_old_rec.attribute28;
828: End If;
829: If (p_rec.attribute29 = hr_api.g_varchar2) then
830: p_rec.attribute29 :=
831: pqh_cei_shd.g_old_rec.attribute29;
827: pqh_cei_shd.g_old_rec.attribute28;
828: End If;
829: If (p_rec.attribute29 = hr_api.g_varchar2) then
830: p_rec.attribute29 :=
831: pqh_cei_shd.g_old_rec.attribute29;
832: End If;
833: If (p_rec.attribute30 = hr_api.g_varchar2) then
834: p_rec.attribute30 :=
835: pqh_cei_shd.g_old_rec.attribute30;
831: pqh_cei_shd.g_old_rec.attribute29;
832: End If;
833: If (p_rec.attribute30 = hr_api.g_varchar2) then
834: p_rec.attribute30 :=
835: pqh_cei_shd.g_old_rec.attribute30;
836: End If;
837: If (p_rec.attribute_category = hr_api.g_varchar2) then
838: p_rec.attribute_category :=
839: pqh_cei_shd.g_old_rec.attribute_category;
835: pqh_cei_shd.g_old_rec.attribute30;
836: End If;
837: If (p_rec.attribute_category = hr_api.g_varchar2) then
838: p_rec.attribute_category :=
839: pqh_cei_shd.g_old_rec.attribute_category;
840: End If;
841: --
842: End convert_defs;
843: --
845: -- |---------------------------------< upd >----------------------------------|
846: -- ----------------------------------------------------------------------------
847: Procedure upd
848: (p_effective_date in date
849: ,p_rec in out nocopy pqh_cei_shd.g_rec_type
850: ) is
851: --
852: l_proc varchar2(72) := g_package||'upd';
853: --
855: hr_utility.set_location('Entering:'||l_proc, 5);
856: --
857: -- We must lock the row which we need to update.
858: --
859: pqh_cei_shd.lck
860: (p_rec.corps_extra_info_id
861: ,p_rec.object_version_number
862: );
863: --
967: ,p_attribute30 in varchar2 default hr_api.g_varchar2
968: ,p_attribute_category in varchar2 default hr_api.g_varchar2
969: ) is
970: --
971: l_rec pqh_cei_shd.g_rec_type;
972: l_proc varchar2(72) := g_package||'upd';
973: --
974: Begin
975: hr_utility.set_location('Entering:'||l_proc, 5);
977: -- Call conversion function to turn arguments into the
978: -- l_rec structure.
979: --
980: l_rec :=
981: pqh_cei_shd.convert_args
982: (p_corps_extra_info_id
983: ,p_corps_definition_id
984: ,p_information_type
985: ,p_information1