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 1670: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;

1666: open C;
1667: loop
1668: fetch C into l_attachment_id, l_document_id;
1669: EXIT WHEN C%NOTFOUND;
1670: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1671: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1672: end loop;
1673: close C;
1674: delete from eng_attachment_changes

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

1667: loop
1668: fetch C into l_attachment_id, l_document_id;
1669: EXIT WHEN C%NOTFOUND;
1670: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1671: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1672: end loop;
1673: close C;
1674: delete from eng_attachment_changes
1675: where change_id = p_change_id

Line 1795: from fnd_documents

1791: EXIT WHEN C%NOTFOUND;
1792: -- select document_id into l_document_id from fnd_attached_documents
1793: -- where attached_document_id = l_attachment_id;
1794: select datatype_id into l_datatype_id
1795: from fnd_documents
1796: where document_id = l_document_id;
1797:
1798: -- Temporarily deleting the attachment from fnd_attached_document
1799: -- instead of deleting from the fnd_documents table

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

1795: from fnd_documents
1796: where document_id = l_document_id;
1797:
1798: -- Temporarily deleting the attachment from fnd_attached_document
1799: -- instead of deleting from the fnd_documents table
1800: -- until the fnd_documents_pkg is fixed
1801:
1802: -- Check if the document exists as part of any other change order
1803: SELECT count(*) into l_document_exists

Line 1800: -- until the fnd_documents_pkg is fixed

1796: where document_id = l_document_id;
1797:
1798: -- Temporarily deleting the attachment from fnd_attached_document
1799: -- instead of deleting from the fnd_documents table
1800: -- until the fnd_documents_pkg is fixed
1801:
1802: -- Check if the document exists as part of any other change order
1803: SELECT count(*) into l_document_exists
1804: FROM eng_attachment_changes

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

1806: AND change_id <> p_change_id
1807: AND revised_item_sequence_id <> p_rev_item_seq_id;
1808:
1809: IF l_document_exists > 0 THEN
1810: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'N');
1811: END IF;
1812: end loop;
1813: close C;
1814:

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

1927: open C;
1928: loop
1929: fetch C into l_attachment_id, l_document_id;
1930: EXIT WHEN C%NOTFOUND;
1931: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1932: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1933: end loop;
1934: close C;
1935: -- Standard ending code ------------------------------------------------

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

1928: loop
1929: fetch C into l_attachment_id, l_document_id;
1930: EXIT WHEN C%NOTFOUND;
1931: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1932: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1933: end loop;
1934: close C;
1935: -- Standard ending code ------------------------------------------------
1936: FND_MSG_PUB.Count_And_Get

Line 2040: from fnd_documents

2036: select document_id into l_document_id
2037: from fnd_attached_documents
2038: where attached_document_id = p_attachment_id;
2039: select datatype_id into l_datatype_id
2040: from fnd_documents
2041: where document_id = l_document_id;
2042: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2043: exception
2044: when NO_DATA_FOUND then

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

2038: where attached_document_id = p_attachment_id;
2039: select datatype_id into l_datatype_id
2040: from fnd_documents
2041: where document_id = l_document_id;
2042: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2043: exception
2044: when NO_DATA_FOUND then
2045: return;
2046: end;