1857: --Start Bug 3538320 <
1858: --Delete the Attachment records of the deliverable
1859:
1860: IF nvl(PA_DELIVERABLE_UTILS.IS_DLV_DOC_DEFINED(p_dlv_element_id,p_dlv_version_id),'N')='Y' THEN
1861: fnd_attached_documents2_pkg.delete_attachments
1862: (X_entity_name => 'PA_DLVR_DOC_ATTACH',
1863: X_pk1_value => to_char(p_dlv_version_id),
1864: X_delete_document_flag => 'Y');
1865:
1864: X_delete_document_flag => 'Y');
1865:
1866: END IF ;
1867:
1868: fnd_attached_documents2_pkg.delete_attachments
1869: (X_entity_name => 'PA_DVLR_ATTACH',
1870: X_pk1_value => to_char(p_dlv_version_id),
1871: X_delete_document_flag => 'Y');
1872:
3077: --Start Bug 3538320 <
3078: --Delete the Attachment records of the deliverable
3079:
3080: IF nvl(PA_DELIVERABLE_UTILS.IS_DLV_DOC_DEFINED(l_dlv_proj_elt_tbl(i),l_dlv_version_tbl(i)),'N')='Y' THEN
3081: fnd_attached_documents2_pkg.delete_attachments
3082: (X_entity_name => 'PA_DLVR_DOC_ATTACH',
3083: X_pk1_value => to_char(l_dlv_version_tbl(i)),
3084: X_delete_document_flag => 'Y');
3085: END IF ;
3083: X_pk1_value => to_char(l_dlv_version_tbl(i)),
3084: X_delete_document_flag => 'Y');
3085: END IF ;
3086:
3087: fnd_attached_documents2_pkg.delete_attachments
3088: (X_entity_name => 'PA_DVLR_ATTACH',
3089: X_pk1_value => to_char(l_dlv_version_tbl(i)),
3090: X_delete_document_flag => 'Y');
3091:
4568: END IF ;
4569:
4570: IF nvl(p_dlv_attachments_flag,'N') = 'Y' THEN
4571:
4572: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS
4573: (
4574: X_from_entity_name => 'PA_DLVR_DOC_ATTACH'
4575: ,X_from_pk1_value => l_source_element_ver_id_tbl(i)
4576: ,X_to_entity_name => 'PA_DLVR_DOC_ATTACH'
4578: ,X_created_by => fnd_global.user_id
4579: ,X_last_update_login => fnd_global.login_id
4580: );
4581:
4582: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS
4583: (
4584: X_from_entity_name => 'PA_DVLR_ATTACH'
4585: ,X_from_pk1_value => l_source_element_ver_id_tbl(i)
4586: ,X_to_entity_name => 'PA_DVLR_ATTACH'