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 1533: update fnd_attached_documents

1529: and wf_orig_system = l_orig_system
1530: and approval_status = 'P';
1531:
1532: -- Added for Bug 6996115
1533: update fnd_attached_documents
1534: set pk1_value = itemkey||l_rname2
1535: where pk1_value = itemkey||l_rname;
1536:
1537:

Line 2180: where document_id in(select document_id from fnd_attached_documents

2176: --this code is to delete the pdf that has already been created with the DRAFT watermark
2177: --for PRE APPROVED report types
2178: delete from fnd_lobs
2179: where file_id in(select media_id from fnd_documents_vl
2180: where document_id in(select document_id from fnd_attached_documents
2181: where pk1_value = itemkey));
2182:
2183:
2184:

Line 2185: delete from fnd_attached_documents

2181: where pk1_value = itemkey));
2182:
2183:
2184:
2185: delete from fnd_attached_documents
2186: where pk1_value = itemkey;
2187:
2188: END IF;
2189: -- Bug 7135471 End