[Home] [Help]
213:
214: CURSOR c_local_attachment
215: IS
216: SELECT fad.attached_document_id, fad.status
217: FROM fnd_documents_vl fdv, fnd_attached_documents fad
218: WHERE fdv.document_id = fad.document_id
219: AND fad.entity_name = p_local_entity_name
220: AND fad.pk1_value= p_local_pk1_value
221: AND fad.pk2_value = p_local_pk2_value
224: OR
225: (fdv.document_id <> p_global_document_id
226: AND ( Nvl(fdv.dm_folder_path, '*NULL*'), fdv.dm_node, fdv.file_name)=
227: (SELECT Nvl(dm_folder_path, '*NULL*'), dm_node, file_name
228: FROM fnd_documents_vl
229: WHERE document_id = p_global_document_id)
230: )
231: OR
232: (fdv.document_id <> p_global_document_id
232: (fdv.document_id <> p_global_document_id
233: AND fdv.dm_node = 0
234: AND (fdv.file_name, fdv.datatype_id) =
235: (SELECT file_name, datatype_id
236: FROM fnd_documents_vl
237: WHERE document_id = p_global_document_id)
238: )
239: );
240:
306: IS
307: SELECT fad.category_id, fad.status, fad.document_id
308: , fad.attached_document_id, fdv.file_name, fad.last_updated_by
309: , fdv.dm_type, fdv.datatype_id, fdv.document_id source_document_id
310: FROM fnd_attached_documents fad, fnd_documents_vl fdv
311: WHERE fad.attached_document_id = cp_attached_document_id
312: AND fad.document_id = fdv.document_id
313: AND cp_attach_action_type <> 'ATTACH'
314: UNION ALL
314: UNION ALL
315: SELECT eac.category_id, eac.previous_status, eac.source_document_id
316: , eac.attachment_id, eac.file_name, eac.last_updated_by
317: , eac.dm_type, eac.datatype_id, eac.source_document_id
318: FROM eng_attachment_changes eac, fnd_documents_vl fdv
319: WHERE eac.change_document_id = cp_change_document_id
320: AND eac.source_document_id = fdv.document_id
321: AND cp_attach_action_type = 'ATTACH';
322: