[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;
1613: -- ) -- commenting this out so that item level changes also get deleted when rev item is removed
1614: -- this is ok since attached_document_id is only pk anyway
1615: and attached_document_id in
1616: (select attachment_id
1617: from eng_attachment_changes
1618: where change_id = p_change_id
1619: and revised_item_sequence_id = p_rev_item_seq_id
1620: and action_type = 'ATTACH'); -- fix for 3771466
1621: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments_And_Changes';
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
1676: and revised_item_sequence_id = p_rev_item_seq_id;
1677: -- Standard ending code ------------------------------------------------
1678: FND_MSG_PUB.Count_And_Get
1737: )
1738: IS
1739: Cursor C IS
1740: select source_document_id
1741: from eng_attachment_changes
1742: where change_id = p_change_id
1743: and revised_item_sequence_id = p_rev_item_seq_id
1744: and action_type = 'ATTACH';
1745: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments_For_Curr_CO';
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
1805: WHERE source_document_id = l_document_id
1806: AND change_id <> p_change_id
1807: AND revised_item_sequence_id <> p_rev_item_seq_id;
1808:
2143: -- Initialize API return status to success
2144: x_return_status := FND_API.G_RET_STS_SUCCESS;
2145:
2146: -- Real code starts here -----------------------------------------------
2147: delete from eng_attachment_changes
2148: where change_id = p_change_id
2149: and revised_item_sequence_id = p_rev_item_seq_id;
2150: -- Standard ending code ------------------------------------------------
2151: FND_MSG_PUB.Count_And_Get
2207: l_revised_item_seq_id NUMBER) is
2208: select change_id, revised_item_sequence_id,
2209: category_id, file_name, source_path,
2210: pk1_value, pk2_value, pk3_value
2211: from eng_attachment_changes a
2212: where a.change_id = l_change_id
2213: and datatype_id = 8 -- only webservices files
2214: and family_id = 0 -- for floating version files
2215: and action_type in ('ATTACH','CHANGE_REVISION','CHANGE_VERSION_LABEL')