APPS.AMW_SCOPE_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 1591: FROM fnd_attached_documents fad

1587: AND SCOPE_CHANGED_STATUS = 'C';
1588:
1589: CURSOR c_ap_attachments IS
1590: SELECT fad.entity_name, fad.pk1_value, fad.pk2_value, fad.pk3_value, fad.pk4_value, fad.pk5_value
1591: FROM fnd_attached_documents fad
1592: WHERE fad.entity_name = 'AMW_PROJECT_AP'
1593: AND fad.pk1_value = p_audit_project_id
1594: AND NOT EXISTS (select 'Y'
1595: from amw_ap_associations ap_assoc

Line 2473: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_AUDIT_PRCD',

2469: select category_id into v_category_id
2470: from fnd_document_categories where name = 'AMW_WORK_PAPERS';
2471: -- To copy the attachments
2472: FOR apdetails_rec IN c_apdetails LOOP
2473: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_AUDIT_PRCD',
2474: X_from_pk1_value => apdetails_rec.audit_procedure_rev_id,
2475: X_to_entity_name => 'AMW_PROJECT_AP',
2476: X_to_pk1_value => apdetails_rec.pk1,
2477: X_to_pk2_value => apdetails_rec.pk2,

Line 2491: fnd_attached_documents2_pkg.delete_attachments(X_entity_name => ap_attachment_rec.entity_name,

2487: --- Copy Attachment ends here
2488:
2489: FOR ap_attachment_rec IN c_ap_attachments LOOP
2490: -- Delete all the attachments for the audit procedure that is not present in the project
2491: fnd_attached_documents2_pkg.delete_attachments(X_entity_name => ap_attachment_rec.entity_name,
2492: X_pk1_value => ap_attachment_rec.pk1_value,
2493: X_pk2_value => ap_attachment_rec.pk2_value,
2494: X_pk3_value => ap_attachment_rec.pk3_value,
2495: X_pk4_value => ap_attachment_rec.pk4_value);