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_ATTACHED_DOCUMENTS

Line 177: --UPDATE fnd_attached_documents

173: , p_last_updated_by => l_fnd_user_id
174: , p_last_update_login => l_fnd_login_id
175: );
176:
177: --UPDATE fnd_attached_documents
178: --SET status = l_prev_status,
179: -- last_update_date = sysdate,
180: -- last_updated_by = l_fnd_user_id,
181: -- last_update_login = l_fnd_login_id

Line 605: -- First creating a record in fnd_attached_documents with the

601: Write_Debug('p_document_id:'||to_char(p_document_id));
602: Write_Debug('l_fnd_login_id:'||to_char(l_fnd_login_id));
603: END IF ;
604:
605: -- First creating a record in fnd_attached_documents with the
606: -- task id
607:
608: dom_attachment_util_pkg.Create_Attachment(
609: x_Attached_document_id => l_new_attached_doc_id

Line 883: -- select fnd_attached_documents_s.nextval

879: IF l_action_type = 'ATTACH' THEN
880:
881: -- Swarnali - no longer needed with the new DOM package
882:
883: -- select fnd_attached_documents_s.nextval
884: -- into l_attachment_id from dual;
885:
886: -- insert into swarb values(2, 'inside attach ->', to_char(l_attachment_id));
887: -- commit;

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

1102: -- Real code starts here -----------------------------------------------
1103: l_fnd_user_id := fnd_global.user_id; -- -1; -- Bug 3700111
1104: l_fnd_login_id := fnd_global.login_id; -- ''; -- Bug 3700111
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');

Line 1111: select fnd_attached_documents_s.nextval

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(
1115: X_Rowid => l_row_id,

Line 1114: fnd_attached_documents_pkg.Insert_Row(

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(
1115: X_Rowid => l_row_id,
1116: X_attached_document_id => l_attached_doc_id,
1117: X_document_id => l_doc_id,
1118: X_creation_date => sysdate,

Line 1159: update fnd_attached_documents set category_id = l_category_id, status = p_source_status where attached_document_id = l_attached_doc_id;

1155: X_doc_attribute14 => null,
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 ------------------------------------------------

Line 1248: -- vamohan: Fix for 3471772: commented out previous line since for a CO, once att changes are implemented, approval status in FND_ATTACHED_DOCUMENTS should be nulled out

1244: end if;
1245: elsif(l_base_change_mgmt_type_code = 'CHANGE_ORDER') then
1246: if(p_header_status = G_ENG_NOT_SUBMITTED) then
1247: x_attachment_status := G_APPROVED; -- x_attachment_status := G_PENDING_CHANGE;
1248: -- vamohan: Fix for 3471772: commented out previous line since for a CO, once att changes are implemented, approval status in FND_ATTACHED_DOCUMENTS should be nulled out
1249: return;
1250: elsif(p_header_status = G_ENG_APPR_APPROVED) then
1251: x_attachment_status := G_APPROVED;
1252: return;

Line 1333: update fnd_attached_documents

1329: open C;
1330: loop
1331: fetch C into l_attachment_id;
1332: EXIT WHEN C%NOTFOUND;
1333: update fnd_attached_documents
1334: set status = p_approval_status, last_update_date = sysdate,
1335: last_updated_by = l_fnd_user_id,
1336: last_update_login = l_fnd_login_id
1337: where attached_document_id = l_attachment_id;

Line 1411: from fnd_attached_documents

1407: IS
1408:
1409: cursor C IS
1410: select attached_document_id, status
1411: from fnd_attached_documents
1412: where entity_name='MTL_ITEM_REVISIONS'
1413: and pk1_value = p_org_id
1414: and pk2_value = p_inv_item_id
1415: and pk3_value = p_curr_rev_id;

Line 1470: from fnd_attached_documents

1466: -- Step 1: If attachment exists for new revision (possible?), return
1467:
1468: select count(*)
1469: into l_count
1470: from fnd_attached_documents
1471: where entity_name='MTL_ITEM_REVISIONS'
1472: and pk1_value = p_org_id
1473: and pk2_value = p_inv_item_id
1474: and pk3_value = p_new_rev_id;

Line 1519: update fnd_attached_documents

1515: and attachment_id = l_attachment_id
1516: and action_type = 'DETACH';
1517:
1518: else
1519: update fnd_attached_documents
1520: set pk3_value = p_new_rev_id
1521: where attached_document_id = l_attachment_id
1522: and exists
1523: (select change_document_id

Line 1606: from fnd_attached_documents

1602: )
1603: IS
1604: cursor C IS
1605: select attached_document_id, document_id
1606: from fnd_attached_documents
1607: where pk1_value = p_org_id
1608: and pk2_value = p_inv_item_id
1609: -- and (
1610: -- pk3_value = p_revision_id

Line 1792: -- select document_id into l_document_id from fnd_attached_documents

1788: open C;
1789: loop
1790: fetch C into l_document_id;
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;

Line 1881: from fnd_attached_documents

1877: )
1878: IS
1879: cursor C IS
1880: select attached_document_id, document_id
1881: from fnd_attached_documents
1882: where pk1_value = p_org_id
1883: and pk2_value = p_inv_item_id
1884: and pk3_value = p_revision_id;
1885: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments';

Line 2037: from fnd_attached_documents

2033:
2034: -- Real code starts here -----------------------------------------------
2035: begin
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;