DBA Data[Home] [Help]

APPS.HR_DTY_BUS dependencies on HR_DOCUMENT_EXTRA_INFO

Line 640: -- HR_DOCUMENT_EXTRA_INFO

636: -- {Start Of Comments}
637: --
638: -- Description:
639: -- This procedure ensures an document type can't be deleted if it is referenced by
640: -- HR_DOCUMENT_EXTRA_INFO
641: --
642: -- Pre Conditions:
643: -- g_old_rec has been populated with details of the values currently in
644: -- the database.

Line 684: from hr_document_extra_info hdei

680:
681: cursor csr_doc_type_delete
682: is
683: select 'X'
684: from hr_document_extra_info hdei
685: where hdei.document_type_id = p_document_type;
686:
687: --
688: begin

Line 703: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_EXTRA_INFO');

699: close csr_doc_type_delete;
700:
701: hr_utility.set_message(800, 'HR_449715_DOR_DOC_TYP_DEL_VAL');
702: hr_utility.set_message_token('TYPE', l_document_type);
703: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_EXTRA_INFO');
704: hr_utility.raise_error;
705: hr_utility.set_location(l_proc, 10);
706: --
707: else