APPS.AHL_WARRANTY_UTILS_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 835: FROM fnd_attached_documents attach, fnd_documents docs

831: --fetch attachments details
832: CURSOR attachment_csr (c_entity_name IN VARCHAR2, c_pk1_value IN NUMBER)
833: IS
834: SELECT attach.*,docs.datatype_id
835: FROM fnd_attached_documents attach, fnd_documents docs
836: WHERE entity_name = c_entity_name
837: AND pk1_value = c_pk1_value
838: AND docs.document_id = attach.document_id;
839:

Line 948: SELECT fnd_attached_documents_s.NEXTVAL into l_attch_doc_id from dual;

944: END IF;
945:
946: CLOSE document_csr;
947:
948: SELECT fnd_attached_documents_s.NEXTVAL into l_attch_doc_id from dual;
949:
950: -- if datatype_id = 6 X_Media_ID will be returned after inserting into fnd_documents only if we pass X_MEdia_ID as NULL,
951: --And we will need to explicitly insert data in fnd_lobs
952: l_data_type := document_rec.datatype_id;

Line 964: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(

960: ' document_rec.media_id = '||document_rec.media_id||' document_rec.url = '||document_rec.url || ' document_rec.title = ' || document_rec.title ||
961: ' csr_index.datatype_id = '||csr_index.datatype_id);
962: END IF;
963:
964: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(
965: X_Rowid =>l_row_char,
966: X_attached_document_id => l_attch_doc_id,
967: X_document_id => l_doc_id,
968: X_creation_date => sysdate,