APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 1222: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',

1218: select distinct pk2 into org_id from amw_ap_associations
1219: where audit_procedure_id=l_audit_procedure_id and
1220: audit_procedure_rev_id=l_audit_procedure_rev_id;
1221:
1222: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',
1223: X_from_pk1_value => p_source_project_id,
1224: X_from_pk2_value =>org_id,
1225: X_from_pk3_value =>src_task_id,
1226: X_from_pk4_value =>ap_rec.AUDIT_PROCEDURE_REV_ID,

Line 1296: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',

1292: select category_id into v_category_id
1293: from fnd_document_categories where name = 'AMW_WORK_PAPERS';
1294:
1295: FOR apdetails_rec IN c_apdetails LOOP
1296: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',
1297: X_from_pk1_value => p_source_project_id,
1298: X_from_pk2_value =>apdetails_rec.src_pk2,
1299: X_from_pk3_value =>apdetails_rec.src_pk4,
1300: X_from_pk4_value =>apdetails_rec.src_audit_procedure_rev_id,

Line 1335: update fnd_attached_documents

1331: and src.audit_procedure_id=dest.audit_procedure_id
1332: and src.pk4=ap_task_icm.src_task_id
1333: and src.association_creation_date is null);
1334:
1335: update fnd_attached_documents
1336: set pk3_value=ap_task_icm.dest_task_id
1337: where pk1_value=to_char(p_dest_project_id) and pk3_value=-1
1338: and pk4_value in (
1339: select src.audit_procedure_rev_id

Line 1600: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',

1596: select distinct pk2 into org_id from amw_ap_associations
1597: where audit_procedure_id=l_audit_procedure_id and
1598: audit_procedure_rev_id=l_audit_procedure_rev_id;
1599:
1600: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',
1601: X_from_pk1_value => p_source_project_id,
1602: X_from_pk2_value =>org_id,
1603: X_from_pk3_value =>src_task_id,
1604: X_from_pk4_value =>ap_rec.AUDIT_PROCEDURE_REV_ID,

Line 1672: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',

1668: select category_id into v_category_id
1669: from fnd_document_categories where name = 'AMW_WORK_PAPERS';
1670:
1671: FOR apdetails_rec IN c_apdetails LOOP
1672: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',
1673: X_from_pk1_value => p_source_project_id,
1674: X_from_pk2_value =>apdetails_rec.src_pk2,
1675: X_from_pk3_value =>apdetails_rec.src_pk4,
1676: X_from_pk4_value =>apdetails_rec.src_audit_procedure_rev_id,

Line 1711: update fnd_attached_documents

1707: and src.audit_procedure_id=dest.audit_procedure_id
1708: and src.pk4=ap_task_icm.src_task_id
1709: and src.association_creation_date is null);
1710:
1711: update fnd_attached_documents
1712: set pk3_value=ap_task_icm.dest_task_id
1713: where pk1_value=to_char(p_dest_project_id) and pk3_value=-1
1714: and pk4_value in (
1715: select src.audit_procedure_rev_id