APPS.HR_DEI_BUS dependencies on HR_DOCUMENT_TYPES

Line 888: from hr_document_types hdt,

884: -- Cursor for Validating Document Type Id
885:
886: cursor csr_valid_doc_id is
887: select document_type_id
888: from hr_document_types hdt,
889: hr_lookups hrl
890: where hrl.lookup_code = hdt.category_code
891: and hrl.lookup_type = 'DOCUMENT_CATEGORY'
892: and hdt.document_type_id = p_document_type_id;

Line 899: -- valid document type id on hr_document_types

895: hr_utility.set_location('Entering:'||l_proc, 5);
896:
897: --
898: -- Check that the Document Type Id is linked to a
899: -- valid document type id on hr_document_types
900: --
901:
902:
903: open csr_valid_doc_id;

Line 911: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_TYPES');

907: --
908: close csr_valid_doc_id;
909: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
910: hr_utility.set_message_token('OBJECT', 'DOCUMENT_TYPE_ID');
911: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_TYPES');
912: hr_utility.raise_error;
913: --
914: else
915: close csr_valid_doc_id;

Line 930: (p_associated_column1 => 'hr_document_types.document_type_id'

926:
927: exception
928: when app_exception.application_exception then
929: if hr_multi_message.exception_add
930: (p_associated_column1 => 'hr_document_types.document_type_id'
931: ) then
932: hr_utility.set_location('Leaving:'||l_proc, 50);
933: raise;
934: end if;