APPS.AMS_ATTACHMENT_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 54: SELECT FND_ATTACHED_DOCUMENTS_S.nextval

50: l_Fnd_Attachment_rec fnd_attachment_rec_type;
51: l_create_Attached_Doc boolean := true;
52:
53: CURSOR c_attached_doc_id IS
54: SELECT FND_ATTACHED_DOCUMENTS_S.nextval
55: FROM dual;
56:
57: CURSOR c_attached_doc_id_exists (l_id IN NUMBER) IS
58: SELECT 1

Line 59: FROM FND_ATTACHED_DOCUMENTS

55: FROM dual;
56:
57: CURSOR c_attached_doc_id_exists (l_id IN NUMBER) IS
58: SELECT 1
59: FROM FND_ATTACHED_DOCUMENTS
60: WHERE document_id = l_id;
61:
62: BEGIN
63: -- Standard Start of API savepoint

Line 200: fnd_attached_documents_pkg.Insert_Row

196: x_attached_document_id := l_attached_document_id;
197:
198:
199: /* Populate FND Attachments */
200: fnd_attached_documents_pkg.Insert_Row
201: ( x_rowid => l_row_id,
202: X_attached_document_id => l_attached_document_ID,
203: X_document_id => x_document_ID,
204: X_creation_date => sysdate,

Line 306: This procedure updates FND_DOCUMENTS,FND_DOCUMENTS_TL and FND_DOCUMENTS_SHORT_TEX T. FND_ATTACHED_DOCUMENTS is not updated because it maintains the link between

302: );
303: End Create_Fnd_Attachment;
304:
305: /**
306: This procedure updates FND_DOCUMENTS,FND_DOCUMENTS_TL and FND_DOCUMENTS_SHORT_TEX T. FND_ATTACHED_DOCUMENTS is not updated because it maintains the link between
307: FND_DOCUMENTS and FND_DOCUMENT_ENTITIES. In Sales and Marketing the association cannot be updated.
308:
309: **/
310:

Line 652: delete from fnd_attached_documents

648:
649: delete from fnd_documents_tl
650: where document_id=p_document_id;
651:
652: delete from fnd_attached_documents
653: where document_id=p_document_id;
654:
655: end if;
656: