232: p_program_id => p_program_id,
233: p_program_update_date => p_program_update_date
234: );
235: exception
236: when hr_api.cannot_find_prog_unit then
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'CREATE_DOC_EXTRA_INFO',
239: p_hook_type => 'BP'
240: );
233: p_program_update_date => p_program_update_date
234: );
235: exception
236: when hr_api.cannot_find_prog_unit then
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'CREATE_DOC_EXTRA_INFO',
239: p_hook_type => 'BP'
240: );
241: end;
479: p_program_update_date => p_program_update_date,
480: p_object_version_number => l_object_version_number
481: );
482: exception
483: when hr_api.cannot_find_prog_unit then
484: hr_api.cannot_find_prog_unit_error
485: (p_module_name => 'CREATE_DOC_EXTRA_INFO',
486: p_hook_type => 'AP'
487: );
480: p_object_version_number => l_object_version_number
481: );
482: exception
483: when hr_api.cannot_find_prog_unit then
484: hr_api.cannot_find_prog_unit_error
485: (p_module_name => 'CREATE_DOC_EXTRA_INFO',
486: p_hook_type => 'AP'
487: );
488: end;
491: --
492: -- When in validation only mode raise the Validate_Enabled exception
493: --
494: if p_validate then
495: raise hr_api.validate_enabled;
496: end if;
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 11);
499: exception
496: end if;
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 11);
499: exception
500: when hr_api.validate_enabled then
501: --
502: -- As the Validate_Enabled exception has been raised
503: -- we must rollback to the savepoint
504: --
540: ,p_person_id in number
541: ,p_document_type_id in number
542: ,p_date_from in date
543: ,p_date_to in date
544: ,p_document_number in varchar2 default hr_api.g_varchar2
545: ,p_issued_by in varchar2 default hr_api.g_varchar2
546: ,p_issued_at in varchar2 default hr_api.g_varchar2
547: ,p_issued_date in date default hr_api.g_date
548: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
541: ,p_document_type_id in number
542: ,p_date_from in date
543: ,p_date_to in date
544: ,p_document_number in varchar2 default hr_api.g_varchar2
545: ,p_issued_by in varchar2 default hr_api.g_varchar2
546: ,p_issued_at in varchar2 default hr_api.g_varchar2
547: ,p_issued_date in date default hr_api.g_date
548: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
549: ,p_verified_by in number default hr_api.g_number
542: ,p_date_from in date
543: ,p_date_to in date
544: ,p_document_number in varchar2 default hr_api.g_varchar2
545: ,p_issued_by in varchar2 default hr_api.g_varchar2
546: ,p_issued_at in varchar2 default hr_api.g_varchar2
547: ,p_issued_date in date default hr_api.g_date
548: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
549: ,p_verified_by in number default hr_api.g_number
550: ,p_verified_date in date default hr_api.g_date
543: ,p_date_to in date
544: ,p_document_number in varchar2 default hr_api.g_varchar2
545: ,p_issued_by in varchar2 default hr_api.g_varchar2
546: ,p_issued_at in varchar2 default hr_api.g_varchar2
547: ,p_issued_date in date default hr_api.g_date
548: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
549: ,p_verified_by in number default hr_api.g_number
550: ,p_verified_date in date default hr_api.g_date
551: ,p_related_object_name in varchar2 default hr_api.g_varchar2
544: ,p_document_number in varchar2 default hr_api.g_varchar2
545: ,p_issued_by in varchar2 default hr_api.g_varchar2
546: ,p_issued_at in varchar2 default hr_api.g_varchar2
547: ,p_issued_date in date default hr_api.g_date
548: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
549: ,p_verified_by in number default hr_api.g_number
550: ,p_verified_date in date default hr_api.g_date
551: ,p_related_object_name in varchar2 default hr_api.g_varchar2
552: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
545: ,p_issued_by in varchar2 default hr_api.g_varchar2
546: ,p_issued_at in varchar2 default hr_api.g_varchar2
547: ,p_issued_date in date default hr_api.g_date
548: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
549: ,p_verified_by in number default hr_api.g_number
550: ,p_verified_date in date default hr_api.g_date
551: ,p_related_object_name in varchar2 default hr_api.g_varchar2
552: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
553: ,p_related_object_id in number default hr_api.g_number
546: ,p_issued_at in varchar2 default hr_api.g_varchar2
547: ,p_issued_date in date default hr_api.g_date
548: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
549: ,p_verified_by in number default hr_api.g_number
550: ,p_verified_date in date default hr_api.g_date
551: ,p_related_object_name in varchar2 default hr_api.g_varchar2
552: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
553: ,p_related_object_id in number default hr_api.g_number
554: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
547: ,p_issued_date in date default hr_api.g_date
548: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
549: ,p_verified_by in number default hr_api.g_number
550: ,p_verified_date in date default hr_api.g_date
551: ,p_related_object_name in varchar2 default hr_api.g_varchar2
552: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
553: ,p_related_object_id in number default hr_api.g_number
554: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
548: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
549: ,p_verified_by in number default hr_api.g_number
550: ,p_verified_date in date default hr_api.g_date
551: ,p_related_object_name in varchar2 default hr_api.g_varchar2
552: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
553: ,p_related_object_id in number default hr_api.g_number
554: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
549: ,p_verified_by in number default hr_api.g_number
550: ,p_verified_date in date default hr_api.g_date
551: ,p_related_object_name in varchar2 default hr_api.g_varchar2
552: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
553: ,p_related_object_id in number default hr_api.g_number
554: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
550: ,p_verified_date in date default hr_api.g_date
551: ,p_related_object_name in varchar2 default hr_api.g_varchar2
552: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
553: ,p_related_object_id in number default hr_api.g_number
554: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
551: ,p_related_object_name in varchar2 default hr_api.g_varchar2
552: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
553: ,p_related_object_id in number default hr_api.g_number
554: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
552: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
553: ,p_related_object_id in number default hr_api.g_number
554: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
553: ,p_related_object_id in number default hr_api.g_number
554: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
554: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
555: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
556: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
557: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
558: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
559: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
560: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
561: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
562: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
563: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
564: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
565: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
566: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
567: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
575: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
568: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
575: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
576: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
569: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
575: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
576: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
577: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
570: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
575: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
576: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
577: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
578: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
571: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
575: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
576: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
577: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
578: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
579: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
572: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
575: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
576: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
577: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
578: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
579: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
580: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
573: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
575: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
576: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
577: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
578: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
579: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
580: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
581: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
574: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
575: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
576: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
577: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
578: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
579: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
580: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
581: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
582: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
575: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
576: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
577: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
578: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
579: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
580: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
581: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
582: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
583: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
576: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
577: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
578: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
579: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
580: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
581: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
582: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
583: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
584: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
577: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
578: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
579: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
580: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
581: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
582: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
583: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
584: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
585: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
578: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
579: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
580: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
581: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
582: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
583: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
584: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
585: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
586: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
579: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
580: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
581: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
582: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
583: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
584: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
585: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
586: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
587: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
580: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
581: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
582: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
583: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
584: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
585: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
586: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
587: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
588: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
581: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
582: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
583: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
584: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
585: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
586: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
587: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
588: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
589: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
582: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
583: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
584: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
585: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
586: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
587: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
588: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
589: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
590: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
583: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
584: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
585: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
586: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
587: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
588: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
589: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
590: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
591: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
584: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
585: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
586: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
587: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
588: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
589: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
590: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
591: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
592: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
585: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
586: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
587: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
588: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
589: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
590: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
591: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
592: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
593: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
586: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
587: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
588: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
589: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
590: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
591: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
592: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
593: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
594: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
587: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
588: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
589: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
590: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
591: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
592: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
593: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
594: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
595: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
588: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
589: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
590: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
591: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
592: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
593: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
594: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
595: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
596: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
589: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
590: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
591: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
592: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
593: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
594: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
595: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
596: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
597: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
590: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
591: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
592: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
593: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
594: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
595: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
596: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
597: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
598: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
591: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
592: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
593: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
594: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
595: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
596: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
597: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
598: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
599: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
592: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
593: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
594: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
595: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
596: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
597: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
598: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
599: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
600: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
593: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
594: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
595: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
596: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
597: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
598: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
599: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
600: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
601: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
594: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
595: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
596: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
597: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
598: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
599: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
600: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
601: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
602: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
595: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
596: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
597: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
598: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
599: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
600: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
601: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
602: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
603: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
596: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
597: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
598: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
599: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
600: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
601: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
602: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
603: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
604: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
597: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
598: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
599: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
600: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
601: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
602: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
603: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
604: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
605: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
598: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
599: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
600: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
601: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
602: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
603: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
604: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
605: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
606: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
599: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
600: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
601: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
602: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
603: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
604: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
605: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
606: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
607: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
600: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
601: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
602: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
603: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
604: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
605: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
606: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
607: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
608: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
601: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
602: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
603: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
604: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
605: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
606: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
607: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
608: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
609: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
602: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
603: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
604: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
605: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
606: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
607: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
608: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
609: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
610: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
603: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
604: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
605: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
606: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
607: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
608: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
609: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
610: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
611: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
604: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
605: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
606: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
607: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
608: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
609: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
610: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
611: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
612: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
605: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
606: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
607: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
608: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
609: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
610: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
611: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
612: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
613: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
606: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
607: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
608: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
609: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
610: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
611: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
612: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
613: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
614: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
607: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
608: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
609: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
610: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
611: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
612: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
613: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
614: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
615: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
608: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
609: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
610: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
611: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
612: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
613: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
614: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
615: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
616: ,p_request_id in number default hr_api.g_number
609: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
610: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
611: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
612: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
613: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
614: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
615: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
616: ,p_request_id in number default hr_api.g_number
617: ,p_program_application_id in number default hr_api.g_number
610: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
611: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
612: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
613: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
614: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
615: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
616: ,p_request_id in number default hr_api.g_number
617: ,p_program_application_id in number default hr_api.g_number
618: ,p_program_id in number default hr_api.g_number
611: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
612: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
613: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
614: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
615: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
616: ,p_request_id in number default hr_api.g_number
617: ,p_program_application_id in number default hr_api.g_number
618: ,p_program_id in number default hr_api.g_number
619: ,p_program_update_date in date default hr_api.g_date
612: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
613: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
614: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
615: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
616: ,p_request_id in number default hr_api.g_number
617: ,p_program_application_id in number default hr_api.g_number
618: ,p_program_id in number default hr_api.g_number
619: ,p_program_update_date in date default hr_api.g_date
620: ,p_object_version_number in out nocopy number
613: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
614: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
615: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
616: ,p_request_id in number default hr_api.g_number
617: ,p_program_application_id in number default hr_api.g_number
618: ,p_program_id in number default hr_api.g_number
619: ,p_program_update_date in date default hr_api.g_date
620: ,p_object_version_number in out nocopy number
621: ) is
614: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
615: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
616: ,p_request_id in number default hr_api.g_number
617: ,p_program_application_id in number default hr_api.g_number
618: ,p_program_id in number default hr_api.g_number
619: ,p_program_update_date in date default hr_api.g_date
620: ,p_object_version_number in out nocopy number
621: ) is
622: --
615: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
616: ,p_request_id in number default hr_api.g_number
617: ,p_program_application_id in number default hr_api.g_number
618: ,p_program_id in number default hr_api.g_number
619: ,p_program_update_date in date default hr_api.g_date
620: ,p_object_version_number in out nocopy number
621: ) is
622: --
623: -- Declare cursors and local variables
757: p_program_update_date => p_program_update_date,
758: p_object_version_number => p_object_version_number
759: );
760: exception
761: when hr_api.cannot_find_prog_unit then
762: hr_api.cannot_find_prog_unit_error
763: (p_module_name => 'UPDATE_DOC_EXTRA_INFO',
764: p_hook_type => 'BP'
765: );
758: p_object_version_number => p_object_version_number
759: );
760: exception
761: when hr_api.cannot_find_prog_unit then
762: hr_api.cannot_find_prog_unit_error
763: (p_module_name => 'UPDATE_DOC_EXTRA_INFO',
764: p_hook_type => 'BP'
765: );
766: end;
1006: p_program_update_date => p_program_update_date,
1007: p_object_version_number => p_object_version_number
1008: );
1009: exception
1010: when hr_api.cannot_find_prog_unit then
1011: hr_api.cannot_find_prog_unit_error
1012: (p_module_name => 'UPDATE_DOC_EXTRA_INFO',
1013: p_hook_type => 'AP'
1014: );
1007: p_object_version_number => p_object_version_number
1008: );
1009: exception
1010: when hr_api.cannot_find_prog_unit then
1011: hr_api.cannot_find_prog_unit_error
1012: (p_module_name => 'UPDATE_DOC_EXTRA_INFO',
1013: p_hook_type => 'AP'
1014: );
1015: end;
1018: --
1019: -- When in validation only mode raise the Validate_Enabled exception
1020: --
1021: if p_validate then
1022: raise hr_api.validate_enabled;
1023: end if;
1024: --
1025: hr_utility.set_location(' Leaving:'||l_proc, 11);
1026: exception
1023: end if;
1024: --
1025: hr_utility.set_location(' Leaving:'||l_proc, 11);
1026: exception
1027: when hr_api.validate_enabled then
1028: --
1029: -- As the Validate_Enabled exception has been raised
1030: -- we must rollback to the savepoint
1031: --
1083: (p_document_extra_info_id => p_document_extra_info_id,
1084: p_object_version_number => p_object_version_number
1085: );
1086: exception
1087: when hr_api.cannot_find_prog_unit then
1088: hr_api.cannot_find_prog_unit_error
1089: (p_module_name => 'DELETE_DOC_EXTRA_INFO',
1090: p_hook_type => 'BP'
1091: );
1084: p_object_version_number => p_object_version_number
1085: );
1086: exception
1087: when hr_api.cannot_find_prog_unit then
1088: hr_api.cannot_find_prog_unit_error
1089: (p_module_name => 'DELETE_DOC_EXTRA_INFO',
1090: p_hook_type => 'BP'
1091: );
1092: end;
1111: (p_document_extra_info_id => p_document_extra_info_id,
1112: p_object_version_number => p_object_version_number
1113: );
1114: exception
1115: when hr_api.cannot_find_prog_unit then
1116: hr_api.cannot_find_prog_unit_error
1117: (p_module_name => 'DELETE_DOC_EXTRA_INFO',
1118: p_hook_type => 'AP'
1119: );
1112: p_object_version_number => p_object_version_number
1113: );
1114: exception
1115: when hr_api.cannot_find_prog_unit then
1116: hr_api.cannot_find_prog_unit_error
1117: (p_module_name => 'DELETE_DOC_EXTRA_INFO',
1118: p_hook_type => 'AP'
1119: );
1120: end;
1123: --
1124: -- When in validation only mode raise the Validate_Enabled exception
1125: --
1126: if p_validate then
1127: raise hr_api.validate_enabled;
1128: end if;
1129: --
1130: hr_utility.set_location(' Leaving:'||l_proc, 11);
1131: exception
1128: end if;
1129: --
1130: hr_utility.set_location(' Leaving:'||l_proc, 11);
1131: exception
1132: when hr_api.validate_enabled then
1133: --
1134: -- As the Validate_Enabled exception has been raised
1135: -- we must rollback to the savepoint
1136: --