eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_WARRANTY_UTILS_PVT dependencies on FND_LOBS

Line 853: FROM fnd_lobs

849: --fetch File details
850: CURSOR file_csr (c_file_id IN NUMBER)
851: IS
852: SELECT *
853: FROM fnd_lobs
854: WHERE file_id = c_file_id;
855:
856: file_rec file_csr%rowtype;
857:

Line 951: --And we will need to explicitly insert data in fnd_lobs

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
955: l_media_id := null;

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:

Line 1050: insert into fnd_lobs

1046: OPEN file_csr(document_rec.media_id);
1047: FETCH file_csr into file_rec;
1048: CLOSE file_csr;
1049:
1050: insert into fnd_lobs
1051: ( file_id,
1052: file_name,
1053: file_content_type,
1054: upload_date,