DBA Data[Home] [Help]

APPS.GMA_EDITEXT_ATTACH_MIG dependencies on FND_ATTACHED_DOCUMENTS

Line 797: SELECT FND_ATTACHED_DOCUMENTS_S.nextval

793: l_create_Attached_Doc boolean := true;
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

Line 802: FROM FND_ATTACHED_DOCUMENTS

798: FROM dual;
799:
800: CURSOR c_attached_doc_id_exists (l_id IN NUMBER) IS
801: SELECT 1
802: FROM FND_ATTACHED_DOCUMENTS
803: WHERE document_id = l_id;
804:
805: l_category_name fnd_document_categories_tl.name%TYPE:='OPM_MIGRATED_TEXT';
806: l_user_name fnd_document_categories_tl.user_name%TYPE:='GMA Migration Text';

Line 848: fnd_attached_documents_pkg.Insert_Row

844:
845: x_attached_document_id := l_attached_document_id;
846:
847: /* Populate FND Attachments */
848: fnd_attached_documents_pkg.Insert_Row
849: ( x_rowid => l_row_id,
850: X_attached_document_id => l_attached_document_ID,
851: X_document_id => x_document_ID,
852: X_creation_date => sysdate,