[Home] [Help]
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml
49: (p_rec in out nocopy hr_dei_shd.g_rec_type
50: ) is
51: --
52: l_proc varchar2(72) := g_package||'update_dml';
53: --
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: --
157: hr_dei_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: --
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: --
162: hr_dei_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: --
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: --
167: hr_dei_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: --
171: Raise;
203: --
204: -- {End Of Comments}
205: -- ----------------------------------------------------------------------------
206: Procedure pre_update
207: (p_rec in hr_dei_shd.g_rec_type
208: ) is
209: --
210: l_proc varchar2(72) := g_package||'pre_update';
211: --
247: --
248: -- {End Of Comments}
249: -- ----------------------------------------------------------------------------
250: Procedure post_update
251: (p_rec in hr_dei_shd.g_rec_type
252: ) is
253: --
254: l_proc varchar2(72) := g_package||'post_update';
255: --
420: => p_rec.program_update_date
421: ,p_object_version_number
422: => p_rec.object_version_number
423: ,p_person_id_o
424: => hr_dei_shd.g_old_rec.person_id
425: ,p_document_type_id_o
426: => hr_dei_shd.g_old_rec.document_type_id
427: ,p_document_number_o
428: => hr_dei_shd.g_old_rec.document_number
422: => p_rec.object_version_number
423: ,p_person_id_o
424: => hr_dei_shd.g_old_rec.person_id
425: ,p_document_type_id_o
426: => hr_dei_shd.g_old_rec.document_type_id
427: ,p_document_number_o
428: => hr_dei_shd.g_old_rec.document_number
429: ,p_date_from_o
430: => hr_dei_shd.g_old_rec.date_from
424: => hr_dei_shd.g_old_rec.person_id
425: ,p_document_type_id_o
426: => hr_dei_shd.g_old_rec.document_type_id
427: ,p_document_number_o
428: => hr_dei_shd.g_old_rec.document_number
429: ,p_date_from_o
430: => hr_dei_shd.g_old_rec.date_from
431: ,p_date_to_o
432: => hr_dei_shd.g_old_rec.date_to
426: => hr_dei_shd.g_old_rec.document_type_id
427: ,p_document_number_o
428: => hr_dei_shd.g_old_rec.document_number
429: ,p_date_from_o
430: => hr_dei_shd.g_old_rec.date_from
431: ,p_date_to_o
432: => hr_dei_shd.g_old_rec.date_to
433: ,p_issued_by_o
434: => hr_dei_shd.g_old_rec.issued_by
428: => hr_dei_shd.g_old_rec.document_number
429: ,p_date_from_o
430: => hr_dei_shd.g_old_rec.date_from
431: ,p_date_to_o
432: => hr_dei_shd.g_old_rec.date_to
433: ,p_issued_by_o
434: => hr_dei_shd.g_old_rec.issued_by
435: ,p_issued_at_o
436: => hr_dei_shd.g_old_rec.issued_at
430: => hr_dei_shd.g_old_rec.date_from
431: ,p_date_to_o
432: => hr_dei_shd.g_old_rec.date_to
433: ,p_issued_by_o
434: => hr_dei_shd.g_old_rec.issued_by
435: ,p_issued_at_o
436: => hr_dei_shd.g_old_rec.issued_at
437: ,p_issued_date_o
438: => hr_dei_shd.g_old_rec.issued_date
432: => hr_dei_shd.g_old_rec.date_to
433: ,p_issued_by_o
434: => hr_dei_shd.g_old_rec.issued_by
435: ,p_issued_at_o
436: => hr_dei_shd.g_old_rec.issued_at
437: ,p_issued_date_o
438: => hr_dei_shd.g_old_rec.issued_date
439: ,p_issuing_authority_o
440: => hr_dei_shd.g_old_rec.issuing_authority
434: => hr_dei_shd.g_old_rec.issued_by
435: ,p_issued_at_o
436: => hr_dei_shd.g_old_rec.issued_at
437: ,p_issued_date_o
438: => hr_dei_shd.g_old_rec.issued_date
439: ,p_issuing_authority_o
440: => hr_dei_shd.g_old_rec.issuing_authority
441: ,p_verified_by_o
442: => hr_dei_shd.g_old_rec.verified_by
436: => hr_dei_shd.g_old_rec.issued_at
437: ,p_issued_date_o
438: => hr_dei_shd.g_old_rec.issued_date
439: ,p_issuing_authority_o
440: => hr_dei_shd.g_old_rec.issuing_authority
441: ,p_verified_by_o
442: => hr_dei_shd.g_old_rec.verified_by
443: ,p_verified_date_o
444: => hr_dei_shd.g_old_rec.verified_date
438: => hr_dei_shd.g_old_rec.issued_date
439: ,p_issuing_authority_o
440: => hr_dei_shd.g_old_rec.issuing_authority
441: ,p_verified_by_o
442: => hr_dei_shd.g_old_rec.verified_by
443: ,p_verified_date_o
444: => hr_dei_shd.g_old_rec.verified_date
445: ,p_related_object_name_o
446: => hr_dei_shd.g_old_rec.related_object_name
440: => hr_dei_shd.g_old_rec.issuing_authority
441: ,p_verified_by_o
442: => hr_dei_shd.g_old_rec.verified_by
443: ,p_verified_date_o
444: => hr_dei_shd.g_old_rec.verified_date
445: ,p_related_object_name_o
446: => hr_dei_shd.g_old_rec.related_object_name
447: ,p_related_object_id_col_o
448: => hr_dei_shd.g_old_rec.related_object_id_col
442: => hr_dei_shd.g_old_rec.verified_by
443: ,p_verified_date_o
444: => hr_dei_shd.g_old_rec.verified_date
445: ,p_related_object_name_o
446: => hr_dei_shd.g_old_rec.related_object_name
447: ,p_related_object_id_col_o
448: => hr_dei_shd.g_old_rec.related_object_id_col
449: ,p_related_object_id_o
450: => hr_dei_shd.g_old_rec.related_object_id
444: => hr_dei_shd.g_old_rec.verified_date
445: ,p_related_object_name_o
446: => hr_dei_shd.g_old_rec.related_object_name
447: ,p_related_object_id_col_o
448: => hr_dei_shd.g_old_rec.related_object_id_col
449: ,p_related_object_id_o
450: => hr_dei_shd.g_old_rec.related_object_id
451: ,p_dei_attribute_category_o
452: => hr_dei_shd.g_old_rec.dei_attribute_category
446: => hr_dei_shd.g_old_rec.related_object_name
447: ,p_related_object_id_col_o
448: => hr_dei_shd.g_old_rec.related_object_id_col
449: ,p_related_object_id_o
450: => hr_dei_shd.g_old_rec.related_object_id
451: ,p_dei_attribute_category_o
452: => hr_dei_shd.g_old_rec.dei_attribute_category
453: ,p_dei_attribute1_o
454: => hr_dei_shd.g_old_rec.dei_attribute1
448: => hr_dei_shd.g_old_rec.related_object_id_col
449: ,p_related_object_id_o
450: => hr_dei_shd.g_old_rec.related_object_id
451: ,p_dei_attribute_category_o
452: => hr_dei_shd.g_old_rec.dei_attribute_category
453: ,p_dei_attribute1_o
454: => hr_dei_shd.g_old_rec.dei_attribute1
455: ,p_dei_attribute2_o
456: => hr_dei_shd.g_old_rec.dei_attribute2
450: => hr_dei_shd.g_old_rec.related_object_id
451: ,p_dei_attribute_category_o
452: => hr_dei_shd.g_old_rec.dei_attribute_category
453: ,p_dei_attribute1_o
454: => hr_dei_shd.g_old_rec.dei_attribute1
455: ,p_dei_attribute2_o
456: => hr_dei_shd.g_old_rec.dei_attribute2
457: ,p_dei_attribute3_o
458: => hr_dei_shd.g_old_rec.dei_attribute3
452: => hr_dei_shd.g_old_rec.dei_attribute_category
453: ,p_dei_attribute1_o
454: => hr_dei_shd.g_old_rec.dei_attribute1
455: ,p_dei_attribute2_o
456: => hr_dei_shd.g_old_rec.dei_attribute2
457: ,p_dei_attribute3_o
458: => hr_dei_shd.g_old_rec.dei_attribute3
459: ,p_dei_attribute4_o
460: => hr_dei_shd.g_old_rec.dei_attribute4
454: => hr_dei_shd.g_old_rec.dei_attribute1
455: ,p_dei_attribute2_o
456: => hr_dei_shd.g_old_rec.dei_attribute2
457: ,p_dei_attribute3_o
458: => hr_dei_shd.g_old_rec.dei_attribute3
459: ,p_dei_attribute4_o
460: => hr_dei_shd.g_old_rec.dei_attribute4
461: ,p_dei_attribute5_o
462: => hr_dei_shd.g_old_rec.dei_attribute5
456: => hr_dei_shd.g_old_rec.dei_attribute2
457: ,p_dei_attribute3_o
458: => hr_dei_shd.g_old_rec.dei_attribute3
459: ,p_dei_attribute4_o
460: => hr_dei_shd.g_old_rec.dei_attribute4
461: ,p_dei_attribute5_o
462: => hr_dei_shd.g_old_rec.dei_attribute5
463: ,p_dei_attribute6_o
464: => hr_dei_shd.g_old_rec.dei_attribute6
458: => hr_dei_shd.g_old_rec.dei_attribute3
459: ,p_dei_attribute4_o
460: => hr_dei_shd.g_old_rec.dei_attribute4
461: ,p_dei_attribute5_o
462: => hr_dei_shd.g_old_rec.dei_attribute5
463: ,p_dei_attribute6_o
464: => hr_dei_shd.g_old_rec.dei_attribute6
465: ,p_dei_attribute7_o
466: => hr_dei_shd.g_old_rec.dei_attribute7
460: => hr_dei_shd.g_old_rec.dei_attribute4
461: ,p_dei_attribute5_o
462: => hr_dei_shd.g_old_rec.dei_attribute5
463: ,p_dei_attribute6_o
464: => hr_dei_shd.g_old_rec.dei_attribute6
465: ,p_dei_attribute7_o
466: => hr_dei_shd.g_old_rec.dei_attribute7
467: ,p_dei_attribute8_o
468: => hr_dei_shd.g_old_rec.dei_attribute8
462: => hr_dei_shd.g_old_rec.dei_attribute5
463: ,p_dei_attribute6_o
464: => hr_dei_shd.g_old_rec.dei_attribute6
465: ,p_dei_attribute7_o
466: => hr_dei_shd.g_old_rec.dei_attribute7
467: ,p_dei_attribute8_o
468: => hr_dei_shd.g_old_rec.dei_attribute8
469: ,p_dei_attribute9_o
470: => hr_dei_shd.g_old_rec.dei_attribute9
464: => hr_dei_shd.g_old_rec.dei_attribute6
465: ,p_dei_attribute7_o
466: => hr_dei_shd.g_old_rec.dei_attribute7
467: ,p_dei_attribute8_o
468: => hr_dei_shd.g_old_rec.dei_attribute8
469: ,p_dei_attribute9_o
470: => hr_dei_shd.g_old_rec.dei_attribute9
471: ,p_dei_attribute10_o
472: => hr_dei_shd.g_old_rec.dei_attribute10
466: => hr_dei_shd.g_old_rec.dei_attribute7
467: ,p_dei_attribute8_o
468: => hr_dei_shd.g_old_rec.dei_attribute8
469: ,p_dei_attribute9_o
470: => hr_dei_shd.g_old_rec.dei_attribute9
471: ,p_dei_attribute10_o
472: => hr_dei_shd.g_old_rec.dei_attribute10
473: ,p_dei_attribute11_o
474: => hr_dei_shd.g_old_rec.dei_attribute11
468: => hr_dei_shd.g_old_rec.dei_attribute8
469: ,p_dei_attribute9_o
470: => hr_dei_shd.g_old_rec.dei_attribute9
471: ,p_dei_attribute10_o
472: => hr_dei_shd.g_old_rec.dei_attribute10
473: ,p_dei_attribute11_o
474: => hr_dei_shd.g_old_rec.dei_attribute11
475: ,p_dei_attribute12_o
476: => hr_dei_shd.g_old_rec.dei_attribute12
470: => hr_dei_shd.g_old_rec.dei_attribute9
471: ,p_dei_attribute10_o
472: => hr_dei_shd.g_old_rec.dei_attribute10
473: ,p_dei_attribute11_o
474: => hr_dei_shd.g_old_rec.dei_attribute11
475: ,p_dei_attribute12_o
476: => hr_dei_shd.g_old_rec.dei_attribute12
477: ,p_dei_attribute13_o
478: => hr_dei_shd.g_old_rec.dei_attribute13
472: => hr_dei_shd.g_old_rec.dei_attribute10
473: ,p_dei_attribute11_o
474: => hr_dei_shd.g_old_rec.dei_attribute11
475: ,p_dei_attribute12_o
476: => hr_dei_shd.g_old_rec.dei_attribute12
477: ,p_dei_attribute13_o
478: => hr_dei_shd.g_old_rec.dei_attribute13
479: ,p_dei_attribute14_o
480: => hr_dei_shd.g_old_rec.dei_attribute14
474: => hr_dei_shd.g_old_rec.dei_attribute11
475: ,p_dei_attribute12_o
476: => hr_dei_shd.g_old_rec.dei_attribute12
477: ,p_dei_attribute13_o
478: => hr_dei_shd.g_old_rec.dei_attribute13
479: ,p_dei_attribute14_o
480: => hr_dei_shd.g_old_rec.dei_attribute14
481: ,p_dei_attribute15_o
482: => hr_dei_shd.g_old_rec.dei_attribute15
476: => hr_dei_shd.g_old_rec.dei_attribute12
477: ,p_dei_attribute13_o
478: => hr_dei_shd.g_old_rec.dei_attribute13
479: ,p_dei_attribute14_o
480: => hr_dei_shd.g_old_rec.dei_attribute14
481: ,p_dei_attribute15_o
482: => hr_dei_shd.g_old_rec.dei_attribute15
483: ,p_dei_attribute16_o
484: => hr_dei_shd.g_old_rec.dei_attribute16
478: => hr_dei_shd.g_old_rec.dei_attribute13
479: ,p_dei_attribute14_o
480: => hr_dei_shd.g_old_rec.dei_attribute14
481: ,p_dei_attribute15_o
482: => hr_dei_shd.g_old_rec.dei_attribute15
483: ,p_dei_attribute16_o
484: => hr_dei_shd.g_old_rec.dei_attribute16
485: ,p_dei_attribute17_o
486: => hr_dei_shd.g_old_rec.dei_attribute17
480: => hr_dei_shd.g_old_rec.dei_attribute14
481: ,p_dei_attribute15_o
482: => hr_dei_shd.g_old_rec.dei_attribute15
483: ,p_dei_attribute16_o
484: => hr_dei_shd.g_old_rec.dei_attribute16
485: ,p_dei_attribute17_o
486: => hr_dei_shd.g_old_rec.dei_attribute17
487: ,p_dei_attribute18_o
488: => hr_dei_shd.g_old_rec.dei_attribute18
482: => hr_dei_shd.g_old_rec.dei_attribute15
483: ,p_dei_attribute16_o
484: => hr_dei_shd.g_old_rec.dei_attribute16
485: ,p_dei_attribute17_o
486: => hr_dei_shd.g_old_rec.dei_attribute17
487: ,p_dei_attribute18_o
488: => hr_dei_shd.g_old_rec.dei_attribute18
489: ,p_dei_attribute19_o
490: => hr_dei_shd.g_old_rec.dei_attribute19
484: => hr_dei_shd.g_old_rec.dei_attribute16
485: ,p_dei_attribute17_o
486: => hr_dei_shd.g_old_rec.dei_attribute17
487: ,p_dei_attribute18_o
488: => hr_dei_shd.g_old_rec.dei_attribute18
489: ,p_dei_attribute19_o
490: => hr_dei_shd.g_old_rec.dei_attribute19
491: ,p_dei_attribute20_o
492: => hr_dei_shd.g_old_rec.dei_attribute20
486: => hr_dei_shd.g_old_rec.dei_attribute17
487: ,p_dei_attribute18_o
488: => hr_dei_shd.g_old_rec.dei_attribute18
489: ,p_dei_attribute19_o
490: => hr_dei_shd.g_old_rec.dei_attribute19
491: ,p_dei_attribute20_o
492: => hr_dei_shd.g_old_rec.dei_attribute20
493: ,p_dei_attribute21_o
494: => hr_dei_shd.g_old_rec.dei_attribute21
488: => hr_dei_shd.g_old_rec.dei_attribute18
489: ,p_dei_attribute19_o
490: => hr_dei_shd.g_old_rec.dei_attribute19
491: ,p_dei_attribute20_o
492: => hr_dei_shd.g_old_rec.dei_attribute20
493: ,p_dei_attribute21_o
494: => hr_dei_shd.g_old_rec.dei_attribute21
495: ,p_dei_attribute22_o
496: => hr_dei_shd.g_old_rec.dei_attribute22
490: => hr_dei_shd.g_old_rec.dei_attribute19
491: ,p_dei_attribute20_o
492: => hr_dei_shd.g_old_rec.dei_attribute20
493: ,p_dei_attribute21_o
494: => hr_dei_shd.g_old_rec.dei_attribute21
495: ,p_dei_attribute22_o
496: => hr_dei_shd.g_old_rec.dei_attribute22
497: ,p_dei_attribute23_o
498: => hr_dei_shd.g_old_rec.dei_attribute23
492: => hr_dei_shd.g_old_rec.dei_attribute20
493: ,p_dei_attribute21_o
494: => hr_dei_shd.g_old_rec.dei_attribute21
495: ,p_dei_attribute22_o
496: => hr_dei_shd.g_old_rec.dei_attribute22
497: ,p_dei_attribute23_o
498: => hr_dei_shd.g_old_rec.dei_attribute23
499: ,p_dei_attribute24_o
500: => hr_dei_shd.g_old_rec.dei_attribute24
494: => hr_dei_shd.g_old_rec.dei_attribute21
495: ,p_dei_attribute22_o
496: => hr_dei_shd.g_old_rec.dei_attribute22
497: ,p_dei_attribute23_o
498: => hr_dei_shd.g_old_rec.dei_attribute23
499: ,p_dei_attribute24_o
500: => hr_dei_shd.g_old_rec.dei_attribute24
501: ,p_dei_attribute25_o
502: => hr_dei_shd.g_old_rec.dei_attribute25
496: => hr_dei_shd.g_old_rec.dei_attribute22
497: ,p_dei_attribute23_o
498: => hr_dei_shd.g_old_rec.dei_attribute23
499: ,p_dei_attribute24_o
500: => hr_dei_shd.g_old_rec.dei_attribute24
501: ,p_dei_attribute25_o
502: => hr_dei_shd.g_old_rec.dei_attribute25
503: ,p_dei_attribute26_o
504: => hr_dei_shd.g_old_rec.dei_attribute26
498: => hr_dei_shd.g_old_rec.dei_attribute23
499: ,p_dei_attribute24_o
500: => hr_dei_shd.g_old_rec.dei_attribute24
501: ,p_dei_attribute25_o
502: => hr_dei_shd.g_old_rec.dei_attribute25
503: ,p_dei_attribute26_o
504: => hr_dei_shd.g_old_rec.dei_attribute26
505: ,p_dei_attribute27_o
506: => hr_dei_shd.g_old_rec.dei_attribute27
500: => hr_dei_shd.g_old_rec.dei_attribute24
501: ,p_dei_attribute25_o
502: => hr_dei_shd.g_old_rec.dei_attribute25
503: ,p_dei_attribute26_o
504: => hr_dei_shd.g_old_rec.dei_attribute26
505: ,p_dei_attribute27_o
506: => hr_dei_shd.g_old_rec.dei_attribute27
507: ,p_dei_attribute28_o
508: => hr_dei_shd.g_old_rec.dei_attribute28
502: => hr_dei_shd.g_old_rec.dei_attribute25
503: ,p_dei_attribute26_o
504: => hr_dei_shd.g_old_rec.dei_attribute26
505: ,p_dei_attribute27_o
506: => hr_dei_shd.g_old_rec.dei_attribute27
507: ,p_dei_attribute28_o
508: => hr_dei_shd.g_old_rec.dei_attribute28
509: ,p_dei_attribute29_o
510: => hr_dei_shd.g_old_rec.dei_attribute29
504: => hr_dei_shd.g_old_rec.dei_attribute26
505: ,p_dei_attribute27_o
506: => hr_dei_shd.g_old_rec.dei_attribute27
507: ,p_dei_attribute28_o
508: => hr_dei_shd.g_old_rec.dei_attribute28
509: ,p_dei_attribute29_o
510: => hr_dei_shd.g_old_rec.dei_attribute29
511: ,p_dei_attribute30_o
512: => hr_dei_shd.g_old_rec.dei_attribute30
506: => hr_dei_shd.g_old_rec.dei_attribute27
507: ,p_dei_attribute28_o
508: => hr_dei_shd.g_old_rec.dei_attribute28
509: ,p_dei_attribute29_o
510: => hr_dei_shd.g_old_rec.dei_attribute29
511: ,p_dei_attribute30_o
512: => hr_dei_shd.g_old_rec.dei_attribute30
513: ,p_dei_information_category_o
514: => hr_dei_shd.g_old_rec.dei_information_category
508: => hr_dei_shd.g_old_rec.dei_attribute28
509: ,p_dei_attribute29_o
510: => hr_dei_shd.g_old_rec.dei_attribute29
511: ,p_dei_attribute30_o
512: => hr_dei_shd.g_old_rec.dei_attribute30
513: ,p_dei_information_category_o
514: => hr_dei_shd.g_old_rec.dei_information_category
515: ,p_dei_information1_o
516: => hr_dei_shd.g_old_rec.dei_information1
510: => hr_dei_shd.g_old_rec.dei_attribute29
511: ,p_dei_attribute30_o
512: => hr_dei_shd.g_old_rec.dei_attribute30
513: ,p_dei_information_category_o
514: => hr_dei_shd.g_old_rec.dei_information_category
515: ,p_dei_information1_o
516: => hr_dei_shd.g_old_rec.dei_information1
517: ,p_dei_information2_o
518: => hr_dei_shd.g_old_rec.dei_information2
512: => hr_dei_shd.g_old_rec.dei_attribute30
513: ,p_dei_information_category_o
514: => hr_dei_shd.g_old_rec.dei_information_category
515: ,p_dei_information1_o
516: => hr_dei_shd.g_old_rec.dei_information1
517: ,p_dei_information2_o
518: => hr_dei_shd.g_old_rec.dei_information2
519: ,p_dei_information3_o
520: => hr_dei_shd.g_old_rec.dei_information3
514: => hr_dei_shd.g_old_rec.dei_information_category
515: ,p_dei_information1_o
516: => hr_dei_shd.g_old_rec.dei_information1
517: ,p_dei_information2_o
518: => hr_dei_shd.g_old_rec.dei_information2
519: ,p_dei_information3_o
520: => hr_dei_shd.g_old_rec.dei_information3
521: ,p_dei_information4_o
522: => hr_dei_shd.g_old_rec.dei_information4
516: => hr_dei_shd.g_old_rec.dei_information1
517: ,p_dei_information2_o
518: => hr_dei_shd.g_old_rec.dei_information2
519: ,p_dei_information3_o
520: => hr_dei_shd.g_old_rec.dei_information3
521: ,p_dei_information4_o
522: => hr_dei_shd.g_old_rec.dei_information4
523: ,p_dei_information5_o
524: => hr_dei_shd.g_old_rec.dei_information5
518: => hr_dei_shd.g_old_rec.dei_information2
519: ,p_dei_information3_o
520: => hr_dei_shd.g_old_rec.dei_information3
521: ,p_dei_information4_o
522: => hr_dei_shd.g_old_rec.dei_information4
523: ,p_dei_information5_o
524: => hr_dei_shd.g_old_rec.dei_information5
525: ,p_dei_information6_o
526: => hr_dei_shd.g_old_rec.dei_information6
520: => hr_dei_shd.g_old_rec.dei_information3
521: ,p_dei_information4_o
522: => hr_dei_shd.g_old_rec.dei_information4
523: ,p_dei_information5_o
524: => hr_dei_shd.g_old_rec.dei_information5
525: ,p_dei_information6_o
526: => hr_dei_shd.g_old_rec.dei_information6
527: ,p_dei_information7_o
528: => hr_dei_shd.g_old_rec.dei_information7
522: => hr_dei_shd.g_old_rec.dei_information4
523: ,p_dei_information5_o
524: => hr_dei_shd.g_old_rec.dei_information5
525: ,p_dei_information6_o
526: => hr_dei_shd.g_old_rec.dei_information6
527: ,p_dei_information7_o
528: => hr_dei_shd.g_old_rec.dei_information7
529: ,p_dei_information8_o
530: => hr_dei_shd.g_old_rec.dei_information8
524: => hr_dei_shd.g_old_rec.dei_information5
525: ,p_dei_information6_o
526: => hr_dei_shd.g_old_rec.dei_information6
527: ,p_dei_information7_o
528: => hr_dei_shd.g_old_rec.dei_information7
529: ,p_dei_information8_o
530: => hr_dei_shd.g_old_rec.dei_information8
531: ,p_dei_information9_o
532: => hr_dei_shd.g_old_rec.dei_information9
526: => hr_dei_shd.g_old_rec.dei_information6
527: ,p_dei_information7_o
528: => hr_dei_shd.g_old_rec.dei_information7
529: ,p_dei_information8_o
530: => hr_dei_shd.g_old_rec.dei_information8
531: ,p_dei_information9_o
532: => hr_dei_shd.g_old_rec.dei_information9
533: ,p_dei_information10_o
534: => hr_dei_shd.g_old_rec.dei_information10
528: => hr_dei_shd.g_old_rec.dei_information7
529: ,p_dei_information8_o
530: => hr_dei_shd.g_old_rec.dei_information8
531: ,p_dei_information9_o
532: => hr_dei_shd.g_old_rec.dei_information9
533: ,p_dei_information10_o
534: => hr_dei_shd.g_old_rec.dei_information10
535: ,p_dei_information11_o
536: => hr_dei_shd.g_old_rec.dei_information11
530: => hr_dei_shd.g_old_rec.dei_information8
531: ,p_dei_information9_o
532: => hr_dei_shd.g_old_rec.dei_information9
533: ,p_dei_information10_o
534: => hr_dei_shd.g_old_rec.dei_information10
535: ,p_dei_information11_o
536: => hr_dei_shd.g_old_rec.dei_information11
537: ,p_dei_information12_o
538: => hr_dei_shd.g_old_rec.dei_information12
532: => hr_dei_shd.g_old_rec.dei_information9
533: ,p_dei_information10_o
534: => hr_dei_shd.g_old_rec.dei_information10
535: ,p_dei_information11_o
536: => hr_dei_shd.g_old_rec.dei_information11
537: ,p_dei_information12_o
538: => hr_dei_shd.g_old_rec.dei_information12
539: ,p_dei_information13_o
540: => hr_dei_shd.g_old_rec.dei_information13
534: => hr_dei_shd.g_old_rec.dei_information10
535: ,p_dei_information11_o
536: => hr_dei_shd.g_old_rec.dei_information11
537: ,p_dei_information12_o
538: => hr_dei_shd.g_old_rec.dei_information12
539: ,p_dei_information13_o
540: => hr_dei_shd.g_old_rec.dei_information13
541: ,p_dei_information14_o
542: => hr_dei_shd.g_old_rec.dei_information14
536: => hr_dei_shd.g_old_rec.dei_information11
537: ,p_dei_information12_o
538: => hr_dei_shd.g_old_rec.dei_information12
539: ,p_dei_information13_o
540: => hr_dei_shd.g_old_rec.dei_information13
541: ,p_dei_information14_o
542: => hr_dei_shd.g_old_rec.dei_information14
543: ,p_dei_information15_o
544: => hr_dei_shd.g_old_rec.dei_information15
538: => hr_dei_shd.g_old_rec.dei_information12
539: ,p_dei_information13_o
540: => hr_dei_shd.g_old_rec.dei_information13
541: ,p_dei_information14_o
542: => hr_dei_shd.g_old_rec.dei_information14
543: ,p_dei_information15_o
544: => hr_dei_shd.g_old_rec.dei_information15
545: ,p_dei_information16_o
546: => hr_dei_shd.g_old_rec.dei_information16
540: => hr_dei_shd.g_old_rec.dei_information13
541: ,p_dei_information14_o
542: => hr_dei_shd.g_old_rec.dei_information14
543: ,p_dei_information15_o
544: => hr_dei_shd.g_old_rec.dei_information15
545: ,p_dei_information16_o
546: => hr_dei_shd.g_old_rec.dei_information16
547: ,p_dei_information17_o
548: => hr_dei_shd.g_old_rec.dei_information17
542: => hr_dei_shd.g_old_rec.dei_information14
543: ,p_dei_information15_o
544: => hr_dei_shd.g_old_rec.dei_information15
545: ,p_dei_information16_o
546: => hr_dei_shd.g_old_rec.dei_information16
547: ,p_dei_information17_o
548: => hr_dei_shd.g_old_rec.dei_information17
549: ,p_dei_information18_o
550: => hr_dei_shd.g_old_rec.dei_information18
544: => hr_dei_shd.g_old_rec.dei_information15
545: ,p_dei_information16_o
546: => hr_dei_shd.g_old_rec.dei_information16
547: ,p_dei_information17_o
548: => hr_dei_shd.g_old_rec.dei_information17
549: ,p_dei_information18_o
550: => hr_dei_shd.g_old_rec.dei_information18
551: ,p_dei_information19_o
552: => hr_dei_shd.g_old_rec.dei_information19
546: => hr_dei_shd.g_old_rec.dei_information16
547: ,p_dei_information17_o
548: => hr_dei_shd.g_old_rec.dei_information17
549: ,p_dei_information18_o
550: => hr_dei_shd.g_old_rec.dei_information18
551: ,p_dei_information19_o
552: => hr_dei_shd.g_old_rec.dei_information19
553: ,p_dei_information20_o
554: => hr_dei_shd.g_old_rec.dei_information20
548: => hr_dei_shd.g_old_rec.dei_information17
549: ,p_dei_information18_o
550: => hr_dei_shd.g_old_rec.dei_information18
551: ,p_dei_information19_o
552: => hr_dei_shd.g_old_rec.dei_information19
553: ,p_dei_information20_o
554: => hr_dei_shd.g_old_rec.dei_information20
555: ,p_dei_information21_o
556: => hr_dei_shd.g_old_rec.dei_information21
550: => hr_dei_shd.g_old_rec.dei_information18
551: ,p_dei_information19_o
552: => hr_dei_shd.g_old_rec.dei_information19
553: ,p_dei_information20_o
554: => hr_dei_shd.g_old_rec.dei_information20
555: ,p_dei_information21_o
556: => hr_dei_shd.g_old_rec.dei_information21
557: ,p_dei_information22_o
558: => hr_dei_shd.g_old_rec.dei_information22
552: => hr_dei_shd.g_old_rec.dei_information19
553: ,p_dei_information20_o
554: => hr_dei_shd.g_old_rec.dei_information20
555: ,p_dei_information21_o
556: => hr_dei_shd.g_old_rec.dei_information21
557: ,p_dei_information22_o
558: => hr_dei_shd.g_old_rec.dei_information22
559: ,p_dei_information23_o
560: => hr_dei_shd.g_old_rec.dei_information23
554: => hr_dei_shd.g_old_rec.dei_information20
555: ,p_dei_information21_o
556: => hr_dei_shd.g_old_rec.dei_information21
557: ,p_dei_information22_o
558: => hr_dei_shd.g_old_rec.dei_information22
559: ,p_dei_information23_o
560: => hr_dei_shd.g_old_rec.dei_information23
561: ,p_dei_information24_o
562: => hr_dei_shd.g_old_rec.dei_information24
556: => hr_dei_shd.g_old_rec.dei_information21
557: ,p_dei_information22_o
558: => hr_dei_shd.g_old_rec.dei_information22
559: ,p_dei_information23_o
560: => hr_dei_shd.g_old_rec.dei_information23
561: ,p_dei_information24_o
562: => hr_dei_shd.g_old_rec.dei_information24
563: ,p_dei_information25_o
564: => hr_dei_shd.g_old_rec.dei_information25
558: => hr_dei_shd.g_old_rec.dei_information22
559: ,p_dei_information23_o
560: => hr_dei_shd.g_old_rec.dei_information23
561: ,p_dei_information24_o
562: => hr_dei_shd.g_old_rec.dei_information24
563: ,p_dei_information25_o
564: => hr_dei_shd.g_old_rec.dei_information25
565: ,p_dei_information26_o
566: => hr_dei_shd.g_old_rec.dei_information26
560: => hr_dei_shd.g_old_rec.dei_information23
561: ,p_dei_information24_o
562: => hr_dei_shd.g_old_rec.dei_information24
563: ,p_dei_information25_o
564: => hr_dei_shd.g_old_rec.dei_information25
565: ,p_dei_information26_o
566: => hr_dei_shd.g_old_rec.dei_information26
567: ,p_dei_information27_o
568: => hr_dei_shd.g_old_rec.dei_information27
562: => hr_dei_shd.g_old_rec.dei_information24
563: ,p_dei_information25_o
564: => hr_dei_shd.g_old_rec.dei_information25
565: ,p_dei_information26_o
566: => hr_dei_shd.g_old_rec.dei_information26
567: ,p_dei_information27_o
568: => hr_dei_shd.g_old_rec.dei_information27
569: ,p_dei_information28_o
570: => hr_dei_shd.g_old_rec.dei_information28
564: => hr_dei_shd.g_old_rec.dei_information25
565: ,p_dei_information26_o
566: => hr_dei_shd.g_old_rec.dei_information26
567: ,p_dei_information27_o
568: => hr_dei_shd.g_old_rec.dei_information27
569: ,p_dei_information28_o
570: => hr_dei_shd.g_old_rec.dei_information28
571: ,p_dei_information29_o
572: => hr_dei_shd.g_old_rec.dei_information29
566: => hr_dei_shd.g_old_rec.dei_information26
567: ,p_dei_information27_o
568: => hr_dei_shd.g_old_rec.dei_information27
569: ,p_dei_information28_o
570: => hr_dei_shd.g_old_rec.dei_information28
571: ,p_dei_information29_o
572: => hr_dei_shd.g_old_rec.dei_information29
573: ,p_dei_information30_o
574: => hr_dei_shd.g_old_rec.dei_information30
568: => hr_dei_shd.g_old_rec.dei_information27
569: ,p_dei_information28_o
570: => hr_dei_shd.g_old_rec.dei_information28
571: ,p_dei_information29_o
572: => hr_dei_shd.g_old_rec.dei_information29
573: ,p_dei_information30_o
574: => hr_dei_shd.g_old_rec.dei_information30
575: ,p_request_id_o
576: => hr_dei_shd.g_old_rec.request_id
570: => hr_dei_shd.g_old_rec.dei_information28
571: ,p_dei_information29_o
572: => hr_dei_shd.g_old_rec.dei_information29
573: ,p_dei_information30_o
574: => hr_dei_shd.g_old_rec.dei_information30
575: ,p_request_id_o
576: => hr_dei_shd.g_old_rec.request_id
577: ,p_program_application_id_o
578: => hr_dei_shd.g_old_rec.program_application_id
572: => hr_dei_shd.g_old_rec.dei_information29
573: ,p_dei_information30_o
574: => hr_dei_shd.g_old_rec.dei_information30
575: ,p_request_id_o
576: => hr_dei_shd.g_old_rec.request_id
577: ,p_program_application_id_o
578: => hr_dei_shd.g_old_rec.program_application_id
579: ,p_program_id_o
580: => hr_dei_shd.g_old_rec.program_id
574: => hr_dei_shd.g_old_rec.dei_information30
575: ,p_request_id_o
576: => hr_dei_shd.g_old_rec.request_id
577: ,p_program_application_id_o
578: => hr_dei_shd.g_old_rec.program_application_id
579: ,p_program_id_o
580: => hr_dei_shd.g_old_rec.program_id
581: ,p_program_update_date_o
582: => hr_dei_shd.g_old_rec.program_update_date
576: => hr_dei_shd.g_old_rec.request_id
577: ,p_program_application_id_o
578: => hr_dei_shd.g_old_rec.program_application_id
579: ,p_program_id_o
580: => hr_dei_shd.g_old_rec.program_id
581: ,p_program_update_date_o
582: => hr_dei_shd.g_old_rec.program_update_date
583: ,p_object_version_number_o
584: => hr_dei_shd.g_old_rec.object_version_number
578: => hr_dei_shd.g_old_rec.program_application_id
579: ,p_program_id_o
580: => hr_dei_shd.g_old_rec.program_id
581: ,p_program_update_date_o
582: => hr_dei_shd.g_old_rec.program_update_date
583: ,p_object_version_number_o
584: => hr_dei_shd.g_old_rec.object_version_number
585: );
586: --
580: => hr_dei_shd.g_old_rec.program_id
581: ,p_program_update_date_o
582: => hr_dei_shd.g_old_rec.program_update_date
583: ,p_object_version_number_o
584: => hr_dei_shd.g_old_rec.object_version_number
585: );
586: --
587: exception
588: --
640: --
641: -- {End Of Comments}
642: -- ----------------------------------------------------------------------------
643: Procedure convert_defs
644: (p_rec in out nocopy hr_dei_shd.g_rec_type
645: ) is
646: --
647: Begin
648: --
652: -- is being used then we must set to the 'current' argument value.
653: --
654: If (p_rec.person_id = hr_api.g_number) then
655: p_rec.person_id :=
656: hr_dei_shd.g_old_rec.person_id;
657: End If;
658: If (p_rec.document_type_id = hr_api.g_number) then
659: p_rec.document_type_id :=
660: hr_dei_shd.g_old_rec.document_type_id;
656: hr_dei_shd.g_old_rec.person_id;
657: End If;
658: If (p_rec.document_type_id = hr_api.g_number) then
659: p_rec.document_type_id :=
660: hr_dei_shd.g_old_rec.document_type_id;
661: End If;
662: If (p_rec.document_number = hr_api.g_varchar2) then
663: p_rec.document_number :=
664: hr_dei_shd.g_old_rec.document_number;
660: hr_dei_shd.g_old_rec.document_type_id;
661: End If;
662: If (p_rec.document_number = hr_api.g_varchar2) then
663: p_rec.document_number :=
664: hr_dei_shd.g_old_rec.document_number;
665: End If;
666: If (p_rec.date_from = hr_api.g_date) then
667: p_rec.date_from :=
668: hr_dei_shd.g_old_rec.date_from;
664: hr_dei_shd.g_old_rec.document_number;
665: End If;
666: If (p_rec.date_from = hr_api.g_date) then
667: p_rec.date_from :=
668: hr_dei_shd.g_old_rec.date_from;
669: End If;
670: If (p_rec.date_to = hr_api.g_date) then
671: p_rec.date_to :=
672: hr_dei_shd.g_old_rec.date_to;
668: hr_dei_shd.g_old_rec.date_from;
669: End If;
670: If (p_rec.date_to = hr_api.g_date) then
671: p_rec.date_to :=
672: hr_dei_shd.g_old_rec.date_to;
673: End If;
674: If (p_rec.issued_by = hr_api.g_varchar2) then
675: p_rec.issued_by :=
676: hr_dei_shd.g_old_rec.issued_by;
672: hr_dei_shd.g_old_rec.date_to;
673: End If;
674: If (p_rec.issued_by = hr_api.g_varchar2) then
675: p_rec.issued_by :=
676: hr_dei_shd.g_old_rec.issued_by;
677: End If;
678: If (p_rec.issued_at = hr_api.g_varchar2) then
679: p_rec.issued_at :=
680: hr_dei_shd.g_old_rec.issued_at;
676: hr_dei_shd.g_old_rec.issued_by;
677: End If;
678: If (p_rec.issued_at = hr_api.g_varchar2) then
679: p_rec.issued_at :=
680: hr_dei_shd.g_old_rec.issued_at;
681: End If;
682: If (p_rec.issued_date = hr_api.g_date) then
683: p_rec.issued_date :=
684: hr_dei_shd.g_old_rec.issued_date;
680: hr_dei_shd.g_old_rec.issued_at;
681: End If;
682: If (p_rec.issued_date = hr_api.g_date) then
683: p_rec.issued_date :=
684: hr_dei_shd.g_old_rec.issued_date;
685: End If;
686: If (p_rec.issuing_authority = hr_api.g_varchar2) then
687: p_rec.issuing_authority :=
688: hr_dei_shd.g_old_rec.issuing_authority;
684: hr_dei_shd.g_old_rec.issued_date;
685: End If;
686: If (p_rec.issuing_authority = hr_api.g_varchar2) then
687: p_rec.issuing_authority :=
688: hr_dei_shd.g_old_rec.issuing_authority;
689: End If;
690: If (p_rec.verified_by = hr_api.g_number) then
691: p_rec.verified_by :=
692: hr_dei_shd.g_old_rec.verified_by;
688: hr_dei_shd.g_old_rec.issuing_authority;
689: End If;
690: If (p_rec.verified_by = hr_api.g_number) then
691: p_rec.verified_by :=
692: hr_dei_shd.g_old_rec.verified_by;
693: End If;
694: If (p_rec.verified_date = hr_api.g_date) then
695: p_rec.verified_date :=
696: hr_dei_shd.g_old_rec.verified_date;
692: hr_dei_shd.g_old_rec.verified_by;
693: End If;
694: If (p_rec.verified_date = hr_api.g_date) then
695: p_rec.verified_date :=
696: hr_dei_shd.g_old_rec.verified_date;
697: End If;
698: If (p_rec.related_object_name = hr_api.g_varchar2) then
699: p_rec.related_object_name :=
700: hr_dei_shd.g_old_rec.related_object_name;
696: hr_dei_shd.g_old_rec.verified_date;
697: End If;
698: If (p_rec.related_object_name = hr_api.g_varchar2) then
699: p_rec.related_object_name :=
700: hr_dei_shd.g_old_rec.related_object_name;
701: End If;
702: If (p_rec.related_object_id_col = hr_api.g_varchar2) then
703: p_rec.related_object_id_col :=
704: hr_dei_shd.g_old_rec.related_object_id_col;
700: hr_dei_shd.g_old_rec.related_object_name;
701: End If;
702: If (p_rec.related_object_id_col = hr_api.g_varchar2) then
703: p_rec.related_object_id_col :=
704: hr_dei_shd.g_old_rec.related_object_id_col;
705: End If;
706: If (p_rec.related_object_id = hr_api.g_number) then
707: p_rec.related_object_id :=
708: hr_dei_shd.g_old_rec.related_object_id;
704: hr_dei_shd.g_old_rec.related_object_id_col;
705: End If;
706: If (p_rec.related_object_id = hr_api.g_number) then
707: p_rec.related_object_id :=
708: hr_dei_shd.g_old_rec.related_object_id;
709: End If;
710: If (p_rec.dei_attribute_category = hr_api.g_varchar2) then
711: p_rec.dei_attribute_category :=
712: hr_dei_shd.g_old_rec.dei_attribute_category;
708: hr_dei_shd.g_old_rec.related_object_id;
709: End If;
710: If (p_rec.dei_attribute_category = hr_api.g_varchar2) then
711: p_rec.dei_attribute_category :=
712: hr_dei_shd.g_old_rec.dei_attribute_category;
713: End If;
714: If (p_rec.dei_attribute1 = hr_api.g_varchar2) then
715: p_rec.dei_attribute1 :=
716: hr_dei_shd.g_old_rec.dei_attribute1;
712: hr_dei_shd.g_old_rec.dei_attribute_category;
713: End If;
714: If (p_rec.dei_attribute1 = hr_api.g_varchar2) then
715: p_rec.dei_attribute1 :=
716: hr_dei_shd.g_old_rec.dei_attribute1;
717: End If;
718: If (p_rec.dei_attribute2 = hr_api.g_varchar2) then
719: p_rec.dei_attribute2 :=
720: hr_dei_shd.g_old_rec.dei_attribute2;
716: hr_dei_shd.g_old_rec.dei_attribute1;
717: End If;
718: If (p_rec.dei_attribute2 = hr_api.g_varchar2) then
719: p_rec.dei_attribute2 :=
720: hr_dei_shd.g_old_rec.dei_attribute2;
721: End If;
722: If (p_rec.dei_attribute3 = hr_api.g_varchar2) then
723: p_rec.dei_attribute3 :=
724: hr_dei_shd.g_old_rec.dei_attribute3;
720: hr_dei_shd.g_old_rec.dei_attribute2;
721: End If;
722: If (p_rec.dei_attribute3 = hr_api.g_varchar2) then
723: p_rec.dei_attribute3 :=
724: hr_dei_shd.g_old_rec.dei_attribute3;
725: End If;
726: If (p_rec.dei_attribute4 = hr_api.g_varchar2) then
727: p_rec.dei_attribute4 :=
728: hr_dei_shd.g_old_rec.dei_attribute4;
724: hr_dei_shd.g_old_rec.dei_attribute3;
725: End If;
726: If (p_rec.dei_attribute4 = hr_api.g_varchar2) then
727: p_rec.dei_attribute4 :=
728: hr_dei_shd.g_old_rec.dei_attribute4;
729: End If;
730: If (p_rec.dei_attribute5 = hr_api.g_varchar2) then
731: p_rec.dei_attribute5 :=
732: hr_dei_shd.g_old_rec.dei_attribute5;
728: hr_dei_shd.g_old_rec.dei_attribute4;
729: End If;
730: If (p_rec.dei_attribute5 = hr_api.g_varchar2) then
731: p_rec.dei_attribute5 :=
732: hr_dei_shd.g_old_rec.dei_attribute5;
733: End If;
734: If (p_rec.dei_attribute6 = hr_api.g_varchar2) then
735: p_rec.dei_attribute6 :=
736: hr_dei_shd.g_old_rec.dei_attribute6;
732: hr_dei_shd.g_old_rec.dei_attribute5;
733: End If;
734: If (p_rec.dei_attribute6 = hr_api.g_varchar2) then
735: p_rec.dei_attribute6 :=
736: hr_dei_shd.g_old_rec.dei_attribute6;
737: End If;
738: If (p_rec.dei_attribute7 = hr_api.g_varchar2) then
739: p_rec.dei_attribute7 :=
740: hr_dei_shd.g_old_rec.dei_attribute7;
736: hr_dei_shd.g_old_rec.dei_attribute6;
737: End If;
738: If (p_rec.dei_attribute7 = hr_api.g_varchar2) then
739: p_rec.dei_attribute7 :=
740: hr_dei_shd.g_old_rec.dei_attribute7;
741: End If;
742: If (p_rec.dei_attribute8 = hr_api.g_varchar2) then
743: p_rec.dei_attribute8 :=
744: hr_dei_shd.g_old_rec.dei_attribute8;
740: hr_dei_shd.g_old_rec.dei_attribute7;
741: End If;
742: If (p_rec.dei_attribute8 = hr_api.g_varchar2) then
743: p_rec.dei_attribute8 :=
744: hr_dei_shd.g_old_rec.dei_attribute8;
745: End If;
746: If (p_rec.dei_attribute9 = hr_api.g_varchar2) then
747: p_rec.dei_attribute9 :=
748: hr_dei_shd.g_old_rec.dei_attribute9;
744: hr_dei_shd.g_old_rec.dei_attribute8;
745: End If;
746: If (p_rec.dei_attribute9 = hr_api.g_varchar2) then
747: p_rec.dei_attribute9 :=
748: hr_dei_shd.g_old_rec.dei_attribute9;
749: End If;
750: If (p_rec.dei_attribute10 = hr_api.g_varchar2) then
751: p_rec.dei_attribute10 :=
752: hr_dei_shd.g_old_rec.dei_attribute10;
748: hr_dei_shd.g_old_rec.dei_attribute9;
749: End If;
750: If (p_rec.dei_attribute10 = hr_api.g_varchar2) then
751: p_rec.dei_attribute10 :=
752: hr_dei_shd.g_old_rec.dei_attribute10;
753: End If;
754: If (p_rec.dei_attribute11 = hr_api.g_varchar2) then
755: p_rec.dei_attribute11 :=
756: hr_dei_shd.g_old_rec.dei_attribute11;
752: hr_dei_shd.g_old_rec.dei_attribute10;
753: End If;
754: If (p_rec.dei_attribute11 = hr_api.g_varchar2) then
755: p_rec.dei_attribute11 :=
756: hr_dei_shd.g_old_rec.dei_attribute11;
757: End If;
758: If (p_rec.dei_attribute12 = hr_api.g_varchar2) then
759: p_rec.dei_attribute12 :=
760: hr_dei_shd.g_old_rec.dei_attribute12;
756: hr_dei_shd.g_old_rec.dei_attribute11;
757: End If;
758: If (p_rec.dei_attribute12 = hr_api.g_varchar2) then
759: p_rec.dei_attribute12 :=
760: hr_dei_shd.g_old_rec.dei_attribute12;
761: End If;
762: If (p_rec.dei_attribute13 = hr_api.g_varchar2) then
763: p_rec.dei_attribute13 :=
764: hr_dei_shd.g_old_rec.dei_attribute13;
760: hr_dei_shd.g_old_rec.dei_attribute12;
761: End If;
762: If (p_rec.dei_attribute13 = hr_api.g_varchar2) then
763: p_rec.dei_attribute13 :=
764: hr_dei_shd.g_old_rec.dei_attribute13;
765: End If;
766: If (p_rec.dei_attribute14 = hr_api.g_varchar2) then
767: p_rec.dei_attribute14 :=
768: hr_dei_shd.g_old_rec.dei_attribute14;
764: hr_dei_shd.g_old_rec.dei_attribute13;
765: End If;
766: If (p_rec.dei_attribute14 = hr_api.g_varchar2) then
767: p_rec.dei_attribute14 :=
768: hr_dei_shd.g_old_rec.dei_attribute14;
769: End If;
770: If (p_rec.dei_attribute15 = hr_api.g_varchar2) then
771: p_rec.dei_attribute15 :=
772: hr_dei_shd.g_old_rec.dei_attribute15;
768: hr_dei_shd.g_old_rec.dei_attribute14;
769: End If;
770: If (p_rec.dei_attribute15 = hr_api.g_varchar2) then
771: p_rec.dei_attribute15 :=
772: hr_dei_shd.g_old_rec.dei_attribute15;
773: End If;
774: If (p_rec.dei_attribute16 = hr_api.g_varchar2) then
775: p_rec.dei_attribute16 :=
776: hr_dei_shd.g_old_rec.dei_attribute16;
772: hr_dei_shd.g_old_rec.dei_attribute15;
773: End If;
774: If (p_rec.dei_attribute16 = hr_api.g_varchar2) then
775: p_rec.dei_attribute16 :=
776: hr_dei_shd.g_old_rec.dei_attribute16;
777: End If;
778: If (p_rec.dei_attribute17 = hr_api.g_varchar2) then
779: p_rec.dei_attribute17 :=
780: hr_dei_shd.g_old_rec.dei_attribute17;
776: hr_dei_shd.g_old_rec.dei_attribute16;
777: End If;
778: If (p_rec.dei_attribute17 = hr_api.g_varchar2) then
779: p_rec.dei_attribute17 :=
780: hr_dei_shd.g_old_rec.dei_attribute17;
781: End If;
782: If (p_rec.dei_attribute18 = hr_api.g_varchar2) then
783: p_rec.dei_attribute18 :=
784: hr_dei_shd.g_old_rec.dei_attribute18;
780: hr_dei_shd.g_old_rec.dei_attribute17;
781: End If;
782: If (p_rec.dei_attribute18 = hr_api.g_varchar2) then
783: p_rec.dei_attribute18 :=
784: hr_dei_shd.g_old_rec.dei_attribute18;
785: End If;
786: If (p_rec.dei_attribute19 = hr_api.g_varchar2) then
787: p_rec.dei_attribute19 :=
788: hr_dei_shd.g_old_rec.dei_attribute19;
784: hr_dei_shd.g_old_rec.dei_attribute18;
785: End If;
786: If (p_rec.dei_attribute19 = hr_api.g_varchar2) then
787: p_rec.dei_attribute19 :=
788: hr_dei_shd.g_old_rec.dei_attribute19;
789: End If;
790: If (p_rec.dei_attribute20 = hr_api.g_varchar2) then
791: p_rec.dei_attribute20 :=
792: hr_dei_shd.g_old_rec.dei_attribute20;
788: hr_dei_shd.g_old_rec.dei_attribute19;
789: End If;
790: If (p_rec.dei_attribute20 = hr_api.g_varchar2) then
791: p_rec.dei_attribute20 :=
792: hr_dei_shd.g_old_rec.dei_attribute20;
793: End If;
794: If (p_rec.dei_attribute21 = hr_api.g_varchar2) then
795: p_rec.dei_attribute21 :=
796: hr_dei_shd.g_old_rec.dei_attribute21;
792: hr_dei_shd.g_old_rec.dei_attribute20;
793: End If;
794: If (p_rec.dei_attribute21 = hr_api.g_varchar2) then
795: p_rec.dei_attribute21 :=
796: hr_dei_shd.g_old_rec.dei_attribute21;
797: End If;
798: If (p_rec.dei_attribute22 = hr_api.g_varchar2) then
799: p_rec.dei_attribute22 :=
800: hr_dei_shd.g_old_rec.dei_attribute22;
796: hr_dei_shd.g_old_rec.dei_attribute21;
797: End If;
798: If (p_rec.dei_attribute22 = hr_api.g_varchar2) then
799: p_rec.dei_attribute22 :=
800: hr_dei_shd.g_old_rec.dei_attribute22;
801: End If;
802: If (p_rec.dei_attribute23 = hr_api.g_varchar2) then
803: p_rec.dei_attribute23 :=
804: hr_dei_shd.g_old_rec.dei_attribute23;
800: hr_dei_shd.g_old_rec.dei_attribute22;
801: End If;
802: If (p_rec.dei_attribute23 = hr_api.g_varchar2) then
803: p_rec.dei_attribute23 :=
804: hr_dei_shd.g_old_rec.dei_attribute23;
805: End If;
806: If (p_rec.dei_attribute24 = hr_api.g_varchar2) then
807: p_rec.dei_attribute24 :=
808: hr_dei_shd.g_old_rec.dei_attribute24;
804: hr_dei_shd.g_old_rec.dei_attribute23;
805: End If;
806: If (p_rec.dei_attribute24 = hr_api.g_varchar2) then
807: p_rec.dei_attribute24 :=
808: hr_dei_shd.g_old_rec.dei_attribute24;
809: End If;
810: If (p_rec.dei_attribute25 = hr_api.g_varchar2) then
811: p_rec.dei_attribute25 :=
812: hr_dei_shd.g_old_rec.dei_attribute25;
808: hr_dei_shd.g_old_rec.dei_attribute24;
809: End If;
810: If (p_rec.dei_attribute25 = hr_api.g_varchar2) then
811: p_rec.dei_attribute25 :=
812: hr_dei_shd.g_old_rec.dei_attribute25;
813: End If;
814: If (p_rec.dei_attribute26 = hr_api.g_varchar2) then
815: p_rec.dei_attribute26 :=
816: hr_dei_shd.g_old_rec.dei_attribute26;
812: hr_dei_shd.g_old_rec.dei_attribute25;
813: End If;
814: If (p_rec.dei_attribute26 = hr_api.g_varchar2) then
815: p_rec.dei_attribute26 :=
816: hr_dei_shd.g_old_rec.dei_attribute26;
817: End If;
818: If (p_rec.dei_attribute27 = hr_api.g_varchar2) then
819: p_rec.dei_attribute27 :=
820: hr_dei_shd.g_old_rec.dei_attribute27;
816: hr_dei_shd.g_old_rec.dei_attribute26;
817: End If;
818: If (p_rec.dei_attribute27 = hr_api.g_varchar2) then
819: p_rec.dei_attribute27 :=
820: hr_dei_shd.g_old_rec.dei_attribute27;
821: End If;
822: If (p_rec.dei_attribute28 = hr_api.g_varchar2) then
823: p_rec.dei_attribute28 :=
824: hr_dei_shd.g_old_rec.dei_attribute28;
820: hr_dei_shd.g_old_rec.dei_attribute27;
821: End If;
822: If (p_rec.dei_attribute28 = hr_api.g_varchar2) then
823: p_rec.dei_attribute28 :=
824: hr_dei_shd.g_old_rec.dei_attribute28;
825: End If;
826: If (p_rec.dei_attribute29 = hr_api.g_varchar2) then
827: p_rec.dei_attribute29 :=
828: hr_dei_shd.g_old_rec.dei_attribute29;
824: hr_dei_shd.g_old_rec.dei_attribute28;
825: End If;
826: If (p_rec.dei_attribute29 = hr_api.g_varchar2) then
827: p_rec.dei_attribute29 :=
828: hr_dei_shd.g_old_rec.dei_attribute29;
829: End If;
830: If (p_rec.dei_attribute30 = hr_api.g_varchar2) then
831: p_rec.dei_attribute30 :=
832: hr_dei_shd.g_old_rec.dei_attribute30;
828: hr_dei_shd.g_old_rec.dei_attribute29;
829: End If;
830: If (p_rec.dei_attribute30 = hr_api.g_varchar2) then
831: p_rec.dei_attribute30 :=
832: hr_dei_shd.g_old_rec.dei_attribute30;
833: End If;
834: If (p_rec.dei_information_category = hr_api.g_varchar2) then
835: p_rec.dei_information_category :=
836: hr_dei_shd.g_old_rec.dei_information_category;
832: hr_dei_shd.g_old_rec.dei_attribute30;
833: End If;
834: If (p_rec.dei_information_category = hr_api.g_varchar2) then
835: p_rec.dei_information_category :=
836: hr_dei_shd.g_old_rec.dei_information_category;
837: End If;
838: If (p_rec.dei_information1 = hr_api.g_varchar2) then
839: p_rec.dei_information1 :=
840: hr_dei_shd.g_old_rec.dei_information1;
836: hr_dei_shd.g_old_rec.dei_information_category;
837: End If;
838: If (p_rec.dei_information1 = hr_api.g_varchar2) then
839: p_rec.dei_information1 :=
840: hr_dei_shd.g_old_rec.dei_information1;
841: End If;
842: If (p_rec.dei_information2 = hr_api.g_varchar2) then
843: p_rec.dei_information2 :=
844: hr_dei_shd.g_old_rec.dei_information2;
840: hr_dei_shd.g_old_rec.dei_information1;
841: End If;
842: If (p_rec.dei_information2 = hr_api.g_varchar2) then
843: p_rec.dei_information2 :=
844: hr_dei_shd.g_old_rec.dei_information2;
845: End If;
846: If (p_rec.dei_information3 = hr_api.g_varchar2) then
847: p_rec.dei_information3 :=
848: hr_dei_shd.g_old_rec.dei_information3;
844: hr_dei_shd.g_old_rec.dei_information2;
845: End If;
846: If (p_rec.dei_information3 = hr_api.g_varchar2) then
847: p_rec.dei_information3 :=
848: hr_dei_shd.g_old_rec.dei_information3;
849: End If;
850: If (p_rec.dei_information4 = hr_api.g_varchar2) then
851: p_rec.dei_information4 :=
852: hr_dei_shd.g_old_rec.dei_information4;
848: hr_dei_shd.g_old_rec.dei_information3;
849: End If;
850: If (p_rec.dei_information4 = hr_api.g_varchar2) then
851: p_rec.dei_information4 :=
852: hr_dei_shd.g_old_rec.dei_information4;
853: End If;
854: If (p_rec.dei_information5 = hr_api.g_varchar2) then
855: p_rec.dei_information5 :=
856: hr_dei_shd.g_old_rec.dei_information5;
852: hr_dei_shd.g_old_rec.dei_information4;
853: End If;
854: If (p_rec.dei_information5 = hr_api.g_varchar2) then
855: p_rec.dei_information5 :=
856: hr_dei_shd.g_old_rec.dei_information5;
857: End If;
858: If (p_rec.dei_information6 = hr_api.g_varchar2) then
859: p_rec.dei_information6 :=
860: hr_dei_shd.g_old_rec.dei_information6;
856: hr_dei_shd.g_old_rec.dei_information5;
857: End If;
858: If (p_rec.dei_information6 = hr_api.g_varchar2) then
859: p_rec.dei_information6 :=
860: hr_dei_shd.g_old_rec.dei_information6;
861: End If;
862: If (p_rec.dei_information7 = hr_api.g_varchar2) then
863: p_rec.dei_information7 :=
864: hr_dei_shd.g_old_rec.dei_information7;
860: hr_dei_shd.g_old_rec.dei_information6;
861: End If;
862: If (p_rec.dei_information7 = hr_api.g_varchar2) then
863: p_rec.dei_information7 :=
864: hr_dei_shd.g_old_rec.dei_information7;
865: End If;
866: If (p_rec.dei_information8 = hr_api.g_varchar2) then
867: p_rec.dei_information8 :=
868: hr_dei_shd.g_old_rec.dei_information8;
864: hr_dei_shd.g_old_rec.dei_information7;
865: End If;
866: If (p_rec.dei_information8 = hr_api.g_varchar2) then
867: p_rec.dei_information8 :=
868: hr_dei_shd.g_old_rec.dei_information8;
869: End If;
870: If (p_rec.dei_information9 = hr_api.g_varchar2) then
871: p_rec.dei_information9 :=
872: hr_dei_shd.g_old_rec.dei_information9;
868: hr_dei_shd.g_old_rec.dei_information8;
869: End If;
870: If (p_rec.dei_information9 = hr_api.g_varchar2) then
871: p_rec.dei_information9 :=
872: hr_dei_shd.g_old_rec.dei_information9;
873: End If;
874: If (p_rec.dei_information10 = hr_api.g_varchar2) then
875: p_rec.dei_information10 :=
876: hr_dei_shd.g_old_rec.dei_information10;
872: hr_dei_shd.g_old_rec.dei_information9;
873: End If;
874: If (p_rec.dei_information10 = hr_api.g_varchar2) then
875: p_rec.dei_information10 :=
876: hr_dei_shd.g_old_rec.dei_information10;
877: End If;
878: If (p_rec.dei_information11 = hr_api.g_varchar2) then
879: p_rec.dei_information11 :=
880: hr_dei_shd.g_old_rec.dei_information11;
876: hr_dei_shd.g_old_rec.dei_information10;
877: End If;
878: If (p_rec.dei_information11 = hr_api.g_varchar2) then
879: p_rec.dei_information11 :=
880: hr_dei_shd.g_old_rec.dei_information11;
881: End If;
882: If (p_rec.dei_information12 = hr_api.g_varchar2) then
883: p_rec.dei_information12 :=
884: hr_dei_shd.g_old_rec.dei_information12;
880: hr_dei_shd.g_old_rec.dei_information11;
881: End If;
882: If (p_rec.dei_information12 = hr_api.g_varchar2) then
883: p_rec.dei_information12 :=
884: hr_dei_shd.g_old_rec.dei_information12;
885: End If;
886: If (p_rec.dei_information13 = hr_api.g_varchar2) then
887: p_rec.dei_information13 :=
888: hr_dei_shd.g_old_rec.dei_information13;
884: hr_dei_shd.g_old_rec.dei_information12;
885: End If;
886: If (p_rec.dei_information13 = hr_api.g_varchar2) then
887: p_rec.dei_information13 :=
888: hr_dei_shd.g_old_rec.dei_information13;
889: End If;
890: If (p_rec.dei_information14 = hr_api.g_varchar2) then
891: p_rec.dei_information14 :=
892: hr_dei_shd.g_old_rec.dei_information14;
888: hr_dei_shd.g_old_rec.dei_information13;
889: End If;
890: If (p_rec.dei_information14 = hr_api.g_varchar2) then
891: p_rec.dei_information14 :=
892: hr_dei_shd.g_old_rec.dei_information14;
893: End If;
894: If (p_rec.dei_information15 = hr_api.g_varchar2) then
895: p_rec.dei_information15 :=
896: hr_dei_shd.g_old_rec.dei_information15;
892: hr_dei_shd.g_old_rec.dei_information14;
893: End If;
894: If (p_rec.dei_information15 = hr_api.g_varchar2) then
895: p_rec.dei_information15 :=
896: hr_dei_shd.g_old_rec.dei_information15;
897: End If;
898: If (p_rec.dei_information16 = hr_api.g_varchar2) then
899: p_rec.dei_information16 :=
900: hr_dei_shd.g_old_rec.dei_information16;
896: hr_dei_shd.g_old_rec.dei_information15;
897: End If;
898: If (p_rec.dei_information16 = hr_api.g_varchar2) then
899: p_rec.dei_information16 :=
900: hr_dei_shd.g_old_rec.dei_information16;
901: End If;
902: If (p_rec.dei_information17 = hr_api.g_varchar2) then
903: p_rec.dei_information17 :=
904: hr_dei_shd.g_old_rec.dei_information17;
900: hr_dei_shd.g_old_rec.dei_information16;
901: End If;
902: If (p_rec.dei_information17 = hr_api.g_varchar2) then
903: p_rec.dei_information17 :=
904: hr_dei_shd.g_old_rec.dei_information17;
905: End If;
906: If (p_rec.dei_information18 = hr_api.g_varchar2) then
907: p_rec.dei_information18 :=
908: hr_dei_shd.g_old_rec.dei_information18;
904: hr_dei_shd.g_old_rec.dei_information17;
905: End If;
906: If (p_rec.dei_information18 = hr_api.g_varchar2) then
907: p_rec.dei_information18 :=
908: hr_dei_shd.g_old_rec.dei_information18;
909: End If;
910: If (p_rec.dei_information19 = hr_api.g_varchar2) then
911: p_rec.dei_information19 :=
912: hr_dei_shd.g_old_rec.dei_information19;
908: hr_dei_shd.g_old_rec.dei_information18;
909: End If;
910: If (p_rec.dei_information19 = hr_api.g_varchar2) then
911: p_rec.dei_information19 :=
912: hr_dei_shd.g_old_rec.dei_information19;
913: End If;
914: If (p_rec.dei_information20 = hr_api.g_varchar2) then
915: p_rec.dei_information20 :=
916: hr_dei_shd.g_old_rec.dei_information20;
912: hr_dei_shd.g_old_rec.dei_information19;
913: End If;
914: If (p_rec.dei_information20 = hr_api.g_varchar2) then
915: p_rec.dei_information20 :=
916: hr_dei_shd.g_old_rec.dei_information20;
917: End If;
918: If (p_rec.dei_information21 = hr_api.g_varchar2) then
919: p_rec.dei_information21 :=
920: hr_dei_shd.g_old_rec.dei_information21;
916: hr_dei_shd.g_old_rec.dei_information20;
917: End If;
918: If (p_rec.dei_information21 = hr_api.g_varchar2) then
919: p_rec.dei_information21 :=
920: hr_dei_shd.g_old_rec.dei_information21;
921: End If;
922: If (p_rec.dei_information22 = hr_api.g_varchar2) then
923: p_rec.dei_information22 :=
924: hr_dei_shd.g_old_rec.dei_information22;
920: hr_dei_shd.g_old_rec.dei_information21;
921: End If;
922: If (p_rec.dei_information22 = hr_api.g_varchar2) then
923: p_rec.dei_information22 :=
924: hr_dei_shd.g_old_rec.dei_information22;
925: End If;
926: If (p_rec.dei_information23 = hr_api.g_varchar2) then
927: p_rec.dei_information23 :=
928: hr_dei_shd.g_old_rec.dei_information23;
924: hr_dei_shd.g_old_rec.dei_information22;
925: End If;
926: If (p_rec.dei_information23 = hr_api.g_varchar2) then
927: p_rec.dei_information23 :=
928: hr_dei_shd.g_old_rec.dei_information23;
929: End If;
930: If (p_rec.dei_information24 = hr_api.g_varchar2) then
931: p_rec.dei_information24 :=
932: hr_dei_shd.g_old_rec.dei_information24;
928: hr_dei_shd.g_old_rec.dei_information23;
929: End If;
930: If (p_rec.dei_information24 = hr_api.g_varchar2) then
931: p_rec.dei_information24 :=
932: hr_dei_shd.g_old_rec.dei_information24;
933: End If;
934: If (p_rec.dei_information25 = hr_api.g_varchar2) then
935: p_rec.dei_information25 :=
936: hr_dei_shd.g_old_rec.dei_information25;
932: hr_dei_shd.g_old_rec.dei_information24;
933: End If;
934: If (p_rec.dei_information25 = hr_api.g_varchar2) then
935: p_rec.dei_information25 :=
936: hr_dei_shd.g_old_rec.dei_information25;
937: End If;
938: If (p_rec.dei_information26 = hr_api.g_varchar2) then
939: p_rec.dei_information26 :=
940: hr_dei_shd.g_old_rec.dei_information26;
936: hr_dei_shd.g_old_rec.dei_information25;
937: End If;
938: If (p_rec.dei_information26 = hr_api.g_varchar2) then
939: p_rec.dei_information26 :=
940: hr_dei_shd.g_old_rec.dei_information26;
941: End If;
942: If (p_rec.dei_information27 = hr_api.g_varchar2) then
943: p_rec.dei_information27 :=
944: hr_dei_shd.g_old_rec.dei_information27;
940: hr_dei_shd.g_old_rec.dei_information26;
941: End If;
942: If (p_rec.dei_information27 = hr_api.g_varchar2) then
943: p_rec.dei_information27 :=
944: hr_dei_shd.g_old_rec.dei_information27;
945: End If;
946: If (p_rec.dei_information28 = hr_api.g_varchar2) then
947: p_rec.dei_information28 :=
948: hr_dei_shd.g_old_rec.dei_information28;
944: hr_dei_shd.g_old_rec.dei_information27;
945: End If;
946: If (p_rec.dei_information28 = hr_api.g_varchar2) then
947: p_rec.dei_information28 :=
948: hr_dei_shd.g_old_rec.dei_information28;
949: End If;
950: If (p_rec.dei_information29 = hr_api.g_varchar2) then
951: p_rec.dei_information29 :=
952: hr_dei_shd.g_old_rec.dei_information29;
948: hr_dei_shd.g_old_rec.dei_information28;
949: End If;
950: If (p_rec.dei_information29 = hr_api.g_varchar2) then
951: p_rec.dei_information29 :=
952: hr_dei_shd.g_old_rec.dei_information29;
953: End If;
954: If (p_rec.dei_information30 = hr_api.g_varchar2) then
955: p_rec.dei_information30 :=
956: hr_dei_shd.g_old_rec.dei_information30;
952: hr_dei_shd.g_old_rec.dei_information29;
953: End If;
954: If (p_rec.dei_information30 = hr_api.g_varchar2) then
955: p_rec.dei_information30 :=
956: hr_dei_shd.g_old_rec.dei_information30;
957: End If;
958: If (p_rec.request_id = hr_api.g_number) then
959: p_rec.request_id :=
960: hr_dei_shd.g_old_rec.request_id;
956: hr_dei_shd.g_old_rec.dei_information30;
957: End If;
958: If (p_rec.request_id = hr_api.g_number) then
959: p_rec.request_id :=
960: hr_dei_shd.g_old_rec.request_id;
961: End If;
962: If (p_rec.program_application_id = hr_api.g_number) then
963: p_rec.program_application_id :=
964: hr_dei_shd.g_old_rec.program_application_id;
960: hr_dei_shd.g_old_rec.request_id;
961: End If;
962: If (p_rec.program_application_id = hr_api.g_number) then
963: p_rec.program_application_id :=
964: hr_dei_shd.g_old_rec.program_application_id;
965: End If;
966: If (p_rec.program_id = hr_api.g_number) then
967: p_rec.program_id :=
968: hr_dei_shd.g_old_rec.program_id;
964: hr_dei_shd.g_old_rec.program_application_id;
965: End If;
966: If (p_rec.program_id = hr_api.g_number) then
967: p_rec.program_id :=
968: hr_dei_shd.g_old_rec.program_id;
969: End If;
970: If (p_rec.program_update_date = hr_api.g_date) then
971: p_rec.program_update_date :=
972: hr_dei_shd.g_old_rec.program_update_date;
968: hr_dei_shd.g_old_rec.program_id;
969: End If;
970: If (p_rec.program_update_date = hr_api.g_date) then
971: p_rec.program_update_date :=
972: hr_dei_shd.g_old_rec.program_update_date;
973: End If;
974: --
975: End convert_defs;
976: --
977: -- ----------------------------------------------------------------------------
978: -- |---------------------------------< upd >----------------------------------|
979: -- ----------------------------------------------------------------------------
980: Procedure upd
981: (p_rec in out nocopy hr_dei_shd.g_rec_type
982: ) is
983: --
984: l_proc varchar2(72) := g_package||'upd';
985: --
987: hr_utility.set_location('Entering:'||l_proc, 5);
988: --
989: -- We must lock the row which we need to update.
990: --
991: hr_dei_shd.lck
992: (p_rec.document_extra_info_id
993: ,p_rec.object_version_number
994: );
995: --
1111: ,p_program_id in number default hr_api.g_number
1112: ,p_program_update_date in date default hr_api.g_date
1113: ) is
1114: --
1115: l_rec hr_dei_shd.g_rec_type;
1116: l_proc varchar2(72) := g_package||'upd';
1117: --
1118: Begin
1119: hr_utility.set_location('Entering:'||l_proc, 5);
1121: -- Call conversion function to turn arguments into the
1122: -- l_rec structure.
1123: --
1124: l_rec :=
1125: hr_dei_shd.convert_args
1126: (p_document_extra_info_id
1127: ,hr_api.g_number
1128: ,p_document_type_id
1129: ,p_document_number