APPS.PSP_ER_WORKFLOW dependencies on FND_ATTACHED_DOCUMENTS

Line 478: FROM fnd_attached_documents fad,

474: where request_id = l_request_id;
475:
476: DELETE fnd_lobs fl
477: WHERE fl.file_id IN (SELECT fdl.media_id
478: FROM fnd_attached_documents fad,
479: fnd_documents_vl fdl
480: WHERE fad.pk1_value = itemkey
481: AND fdl.document_id = fad.document_id
482: AND fad.entity_name = 'ERDETAILS');

Line 486: FROM fnd_attached_documents fad,

482: AND fad.entity_name = 'ERDETAILS');
483:
484: DELETE fnd_lobs fl
485: WHERE fl.file_id IN (SELECT fdl.media_id
486: FROM fnd_attached_documents fad,
487: fnd_documents_vl fdl
488: WHERE fad.pk1_value IN (SELECT wf_item_key
489: FROM psp_eff_report_approvals pera
490: WHERE pera.effort_report_detail_id IN (SELECT perd.effort_report_detail_id

Line 1493: update fnd_attached_documents

1489: and wf_orig_system = l_orig_system
1490: and approval_status = 'P';
1491:
1492: -- Added for Bug 6996115
1493: update fnd_attached_documents
1494: set pk1_value = itemkey||l_rname2
1495: where pk1_value = itemkey||l_rname;
1496:
1497:

Line 2124: where document_id in(select document_id from fnd_attached_documents

2120: --this code is to delete the pdf that has already been created with the DRAFT watermark
2121: --for PRE APPROVED report types
2122: delete from fnd_lobs
2123: where file_id in(select media_id from fnd_documents_vl
2124: where document_id in(select document_id from fnd_attached_documents
2125: where pk1_value = itemkey));
2126:
2127:
2128:

Line 2129: delete from fnd_attached_documents

2125: where pk1_value = itemkey));
2126:
2127:
2128:
2129: delete from fnd_attached_documents
2130: where pk1_value = itemkey;
2131:
2132: END IF;
2133: -- Bug 7135471 End