DBA Data[Home] [Help]

APPS.GMA_EDITEXT_ATTACH_MIG dependencies on DUAL

Line 636: FROM dual;

632:
633: -- Get category id from a sequence.
634: SELECT fnd_document_categories_s.nextval
635: INTO l_category_id
636: FROM dual;
637:
638: -- Call fnd's package to create the Category
639: fnd_doc_categories_pkg.insert_row
640: (

Line 724: from dual;

720:
721: -- Get category id from a sequence.
722: select fnd_doc_category_usages_s.nextval
723: into l_doc_category_usage_id
724: from dual;
725:
726: INSERT INTO FND_DOC_CATEGORY_USAGES
727: (DOC_CATEGORY_USAGE_ID,
728: CATEGORY_ID,

Line 798: FROM dual;

794: l_dummy fnd_documents.document_id%TYPE;
795:
796: CURSOR c_attached_doc_id IS
797: SELECT FND_ATTACHED_DOCUMENTS_S.nextval
798: FROM dual;
799:
800: CURSOR c_attached_doc_id_exists (l_id IN NUMBER) IS
801: SELECT 1
802: FROM FND_ATTACHED_DOCUMENTS