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.ENG_ATTACHMENT_IMPLEMENTATION dependencies on FND_DOCUMENTS

Line 864: FROM fnd_documents

860: -- commit;
861:
862: -- Get the document_id for the attachment
863: SELECT document_id INTO l_document_id
864: FROM fnd_documents
865: WHERE document_id = l_source_document_id;
866:
867: -- insert into swarb values(1, 'attachment not null->', to_char(l_document_id));
868: -- commit;

Line 1109: from fnd_documents where document_id = l_source_doc_id;

1105: select userenv('LANG') into l_language from dual;
1106: select category_id, document_id into l_category_id, l_source_doc_id from fnd_attached_documents where attached_document_id = p_source_attachment_id;
1107: select datatype_id, security_type, dm_node, dm_folder_path, dm_type, dm_document_id, dm_version_number
1108: into l_datatype_id, l_security_type, l_dm_node, l_dm_folder_path, l_dm_type, l_dm_document_id, l_dm_version_number
1109: from fnd_documents where document_id = l_source_doc_id;
1110: select file_name, description, media_id into l_file_name, l_description, l_media_id from fnd_documents_tl where document_id = l_source_doc_id and language = userenv('LANG');
1111: select fnd_attached_documents_s.nextval
1112: into l_attached_doc_id
1113: from dual;

Line 1110: select file_name, description, media_id into l_file_name, l_description, l_media_id from fnd_documents_tl where document_id = l_source_doc_id and language = userenv('LANG');

1106: select category_id, document_id into l_category_id, l_source_doc_id from fnd_attached_documents where attached_document_id = p_source_attachment_id;
1107: select datatype_id, security_type, dm_node, dm_folder_path, dm_type, dm_document_id, dm_version_number
1108: into l_datatype_id, l_security_type, l_dm_node, l_dm_folder_path, l_dm_type, l_dm_document_id, l_dm_version_number
1109: from fnd_documents where document_id = l_source_doc_id;
1110: select file_name, description, media_id into l_file_name, l_description, l_media_id from fnd_documents_tl where document_id = l_source_doc_id and language = userenv('LANG');
1111: select fnd_attached_documents_s.nextval
1112: into l_attached_doc_id
1113: from dual;
1114: fnd_attached_documents_pkg.Insert_Row(

Line 1160: update fnd_documents set dm_node = l_dm_node, dm_folder_path = l_dm_folder_path, dm_type = l_dm_type, dm_document_id = l_dm_document_id, dm_version_number = l_dm_version_number where document_id = l_doc_id;

1156: X_doc_attribute15 => null,
1157: X_create_doc => 'Y' -- Fix for 3762710
1158: );
1159: update fnd_attached_documents set category_id = l_category_id, status = p_source_status where attached_document_id = l_attached_doc_id;
1160: update fnd_documents set dm_node = l_dm_node, dm_folder_path = l_dm_folder_path, dm_type = l_dm_type, dm_document_id = l_dm_document_id, dm_version_number = l_dm_version_number where document_id = l_doc_id;
1161: x_new_attachment_id := l_attached_doc_id;
1162:
1163: -- Standard ending code ------------------------------------------------
1164: FND_MSG_PUB.Count_And_Get

Line 1877: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;

1873: open C;
1874: loop
1875: fetch C into l_attachment_id, l_document_id;
1876: EXIT WHEN C%NOTFOUND;
1877: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1878: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1879: end loop;
1880: close C;
1881: delete from eng_attachment_changes

Line 1878: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');

1874: loop
1875: fetch C into l_attachment_id, l_document_id;
1876: EXIT WHEN C%NOTFOUND;
1877: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1878: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1879: end loop;
1880: close C;
1881: delete from eng_attachment_changes
1882: where change_id = p_change_id

Line 2002: from fnd_documents

1998: EXIT WHEN C%NOTFOUND;
1999: -- select document_id into l_document_id from fnd_attached_documents
2000: -- where attached_document_id = l_attachment_id;
2001: select datatype_id into l_datatype_id
2002: from fnd_documents
2003: where document_id = l_document_id;
2004:
2005: -- Temporarily deleting the attachment from fnd_attached_document
2006: -- instead of deleting from the fnd_documents table

Line 2006: -- instead of deleting from the fnd_documents table

2002: from fnd_documents
2003: where document_id = l_document_id;
2004:
2005: -- Temporarily deleting the attachment from fnd_attached_document
2006: -- instead of deleting from the fnd_documents table
2007: -- until the fnd_documents_pkg is fixed
2008:
2009: -- Check if the document exists as part of any other change order
2010: SELECT count(*) into l_document_exists

Line 2007: -- until the fnd_documents_pkg is fixed

2003: where document_id = l_document_id;
2004:
2005: -- Temporarily deleting the attachment from fnd_attached_document
2006: -- instead of deleting from the fnd_documents table
2007: -- until the fnd_documents_pkg is fixed
2008:
2009: -- Check if the document exists as part of any other change order
2010: SELECT count(*) into l_document_exists
2011: FROM eng_attachment_changes

Line 2017: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'N');

2013: AND change_id <> p_change_id
2014: AND revised_item_sequence_id <> p_rev_item_seq_id;
2015:
2016: IF l_document_exists > 0 THEN
2017: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'N');
2018: END IF;
2019: end loop;
2020: close C;
2021:

Line 2138: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;

2134: open C;
2135: loop
2136: fetch C into l_attachment_id, l_document_id;
2137: EXIT WHEN C%NOTFOUND;
2138: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
2139: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2140: end loop;
2141: close C;
2142: -- Standard ending code ------------------------------------------------

Line 2139: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');

2135: loop
2136: fetch C into l_attachment_id, l_document_id;
2137: EXIT WHEN C%NOTFOUND;
2138: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
2139: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2140: end loop;
2141: close C;
2142: -- Standard ending code ------------------------------------------------
2143: FND_MSG_PUB.Count_And_Get

Line 2247: from fnd_documents

2243: select document_id into l_document_id
2244: from fnd_attached_documents
2245: where attached_document_id = p_attachment_id;
2246: select datatype_id into l_datatype_id
2247: from fnd_documents
2248: where document_id = l_document_id;
2249: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2250: exception
2251: when NO_DATA_FOUND then

Line 2249: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');

2245: where attached_document_id = p_attachment_id;
2246: select datatype_id into l_datatype_id
2247: from fnd_documents
2248: where document_id = l_document_id;
2249: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2250: exception
2251: when NO_DATA_FOUND then
2252: return;
2253: end;