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 1609: from fnd_attached_documents

1605: )
1606: IS
1607: cursor C IS
1608: select attached_document_id, status
1609: from fnd_attached_documents
1610: where pk1_value = p_org_id
1611: and pk2_value = p_inv_item_id
1612: and pk3_value = p_curr_rev_id;
1613:

Line 1662: from fnd_attached_documents

1658:
1659: -- Real code starts here -----------------------------------------------
1660: select count(*)
1661: into l_count
1662: from fnd_attached_documents
1663: where pk1_value = p_org_id
1664: and pk2_value = p_inv_item_id
1665: and pk3_value = p_new_rev_id;
1666: if(l_count>0) then

Line 1701: from fnd_attached_documents

1697:
1698: update eng_attachment_changes
1699: set attachment_id = l_new_attachment_id,
1700: source_document_id = (select document_id
1701: from fnd_attached_documents
1702: where attached_document_id =
1703: l_new_attachment_id),
1704: pk3_value = p_new_rev_id
1705: where change_id = p_change_id

Line 1710: update fnd_attached_documents

1706: and revised_item_sequence_id = p_rev_item_seq_id
1707: and attachment_id = l_attachment_id
1708: and action_type = 'DETACH';
1709: if(l_status is not null) then
1710: update fnd_attached_documents
1711: set status = null
1712: where attached_document_id = l_new_attachment_id;
1713: end if;
1714: else

Line 1715: update fnd_attached_documents

1711: set status = null
1712: where attached_document_id = l_new_attachment_id;
1713: end if;
1714: else
1715: update fnd_attached_documents
1716: set pk3_value = p_new_rev_id
1717: where attached_document_id = l_attachment_id
1718: and exists
1719: (select change_document_id

Line 1813: from fnd_attached_documents

1809: )
1810: IS
1811: cursor C IS
1812: select attached_document_id, document_id
1813: from fnd_attached_documents
1814: where pk1_value = p_org_id
1815: and pk2_value = p_inv_item_id
1816: -- and (
1817: -- pk3_value = p_revision_id

Line 1999: -- select document_id into l_document_id from fnd_attached_documents

1995: open C;
1996: loop
1997: fetch C into l_document_id;
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;

Line 2088: from fnd_attached_documents

2084: )
2085: IS
2086: cursor C IS
2087: select attached_document_id, document_id
2088: from fnd_attached_documents
2089: where pk1_value = p_org_id
2090: and pk2_value = p_inv_item_id
2091: and pk3_value = p_revision_id;
2092: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments';

Line 2244: from fnd_attached_documents

2240:
2241: -- Real code starts here -----------------------------------------------
2242: begin
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;