APPS.AHL_WARRANTY_UTILS_PVT dependencies on FND_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 844: FROM fnd_documents_vl docs

840: --fetch documents details
841: CURSOR document_csr (c_document_id IN NUMBER)
842: IS
843: SELECT *
844: FROM fnd_documents_vl docs
845: WHERE document_id = c_document_id;
846:
847: document_rec document_csr%rowtype;
848:

Line 913: fnd_documents_pkg.Delete_Row(csr_index.document_id,

909: --Cursor For LOOP
910: FOR csr_index in attachment_csr(p_entity_name,p_pk1_value)
911: LOOP
912:
913: fnd_documents_pkg.Delete_Row(csr_index.document_id,
914: csr_index.datatype_id,
915: 'Y');
916:
917: END LOOP;

Line 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,

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;
953: l_media_id := document_rec.media_id;
954: IF( l_data_type = 6)THEN

Line 1039: -- datatype_id = 1 for Short Text (Taken care in FND_DOCUMENTS_PKG.Insert_Row if Media_Id is passed)

1035: IF (l_log_statement >= l_log_current_level) THEN
1036: fnd_log.string(l_log_statement,L_DEBUG_KEY,'JKJ, After insersion : l_doc_id = ' || l_doc_id || ' l_attch_doc_id = '||l_attch_doc_id||' document_rec.image_type = '||document_rec.image_type );
1037: END IF;
1038:
1039: -- datatype_id = 1 for Short Text (Taken care in FND_DOCUMENTS_PKG.Insert_Row if Media_Id is passed)
1040: -- datatype_id = 5 for url (Taken care directly if url is passed)
1041: -- datatype_id = 6 for file (X_Media_ID will be returned after inserting into fnd_documents, But need to inserddata in fnd_lobs)
1042: IF(l_data_type = 6)THEN
1043:

Line 1041: -- datatype_id = 6 for file (X_Media_ID will be returned after inserting into fnd_documents, But need to inserddata in fnd_lobs)

1037: END IF;
1038:
1039: -- datatype_id = 1 for Short Text (Taken care in FND_DOCUMENTS_PKG.Insert_Row if Media_Id is passed)
1040: -- datatype_id = 5 for url (Taken care directly if url is passed)
1041: -- datatype_id = 6 for file (X_Media_ID will be returned after inserting into fnd_documents, But need to inserddata in fnd_lobs)
1042: IF(l_data_type = 6)THEN
1043:
1044: file_rec := null;
1045: