[Home] [Help]
138: cursor C IS
139: select attachment_id, previous_status,
140: decode(datatype_id, 8, family_id, source_document_id) document_id,
141: repository_id, created_by
142: from eng_attachment_changes
143: where change_id = p_change_id;
144:
145: l_attachment_id NUMBER;
146: l_prev_status VARCHAR2(100);
228: cursor C IS
229: select attachment_id, previous_status, source_document_id, repository_id,
230: category_id, family_id, source_media_id, file_name,
231: datatype_id, created_by
232: from eng_attachment_changes
233: where change_id = p_change_id;
234:
235:
236: l_api_name CONSTANT VARCHAR2(30) := 'Update_Attachment_Status';
764: a.new_category_id, a.created_by, a.last_update_login,
765: a.repository_id,
766: decode(b.protocol, 'WEBDAV', -1, a.family_id) family_id,
767: a.dm_type, b.protocol
768: from eng_attachment_changes a, dom_repositories b
769: where change_id = p_change_id
770: and revised_item_sequence_id = p_rev_item_seq_id
771: and a.repository_id = b.id;
772:
1277: l_fnd_user_id number;
1278: l_fnd_login_id number;
1279: cursor C IS
1280: select attachment_id
1281: from eng_attachment_changes
1282: where change_id = p_change_id;
1283: l_api_name CONSTANT VARCHAR2(30) := 'Complete_Attachment_Approval';
1284: l_api_version CONSTANT NUMBER := 1.0;
1285:
1507: x_program_id => fnd_global.conc_program_id,
1508: x_request_id => fnd_global.conc_request_id
1509: );
1510: -- Step 4: Moving attachment changes (only Detach) from source revision to new revision
1511: update eng_attachment_changes
1512: set attachment_id = l_new_attachment_id
1513: where change_id = p_change_id
1514: and revised_item_sequence_id = p_rev_item_seq_id
1515: and attachment_id = l_attachment_id
1520: set pk3_value = p_new_rev_id
1521: where attached_document_id = l_attachment_id
1522: and exists
1523: (select change_document_id
1524: from eng_attachment_changes
1525: where change_id = p_change_id
1526: and revised_item_sequence_id = p_rev_item_seq_id
1527: and attachment_id = l_attachment_id);
1528: end if;
1694: x_program_id => fnd_global.conc_program_id,
1695: x_request_id => fnd_global.conc_request_id
1696: );
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 =
1716: set pk3_value = p_new_rev_id
1717: where attached_document_id = l_attachment_id
1718: and exists
1719: (select change_document_id
1720: from eng_attachment_changes
1721: where change_id = p_change_id
1722: and revised_item_sequence_id = p_rev_item_seq_id
1723: and attachment_id = l_attachment_id);
1724: end if;
1726: close C;
1727:
1728: /* Update pk3_value(rev_id) from 'From Revision' to 'New Revision' for 'ATTACH' change lines */
1729:
1730: update eng_attachment_changes set pk3_value = p_new_rev_id
1731: where change_id = p_change_id
1732: and revised_item_sequence_id = p_rev_item_seq_id
1733: and action_type = 'ATTACH'
1734: and pk3_value = p_curr_rev_id ;
1820: -- ) -- commenting this out so that item level changes also get deleted when rev item is removed
1821: -- this is ok since attached_document_id is only pk anyway
1822: and attached_document_id in
1823: (select attachment_id
1824: from eng_attachment_changes
1825: where change_id = p_change_id
1826: and revised_item_sequence_id = p_rev_item_seq_id
1827: and action_type = 'ATTACH'); -- fix for 3771466
1828: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments_And_Changes';
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
1883: and revised_item_sequence_id = p_rev_item_seq_id;
1884: -- Standard ending code ------------------------------------------------
1885: FND_MSG_PUB.Count_And_Get
1944: )
1945: IS
1946: Cursor C IS
1947: select source_document_id
1948: from eng_attachment_changes
1949: where change_id = p_change_id
1950: and revised_item_sequence_id = p_rev_item_seq_id
1951: and action_type = 'ATTACH';
1952: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments_For_Curr_CO';
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
2012: WHERE source_document_id = l_document_id
2013: AND change_id <> p_change_id
2014: AND revised_item_sequence_id <> p_rev_item_seq_id;
2015:
2350: -- Initialize API return status to success
2351: x_return_status := FND_API.G_RET_STS_SUCCESS;
2352:
2353: -- Real code starts here -----------------------------------------------
2354: delete from eng_attachment_changes
2355: where change_id = p_change_id
2356: and revised_item_sequence_id = p_rev_item_seq_id;
2357: -- Standard ending code ------------------------------------------------
2358: FND_MSG_PUB.Count_And_Get
2414: l_revised_item_seq_id NUMBER) is
2415: select change_id, revised_item_sequence_id,
2416: category_id, file_name, source_path,
2417: pk1_value, pk2_value, pk3_value
2418: from eng_attachment_changes a
2419: where a.change_id = l_change_id
2420: and datatype_id = 8 -- only webservices files
2421: and family_id = 0 -- for floating version files
2422: and action_type in ('ATTACH','CHANGE_REVISION','CHANGE_VERSION_LABEL')