DBA Data[Home] [Help]

APPS.AP_IMPORT_INVOICES_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 21: from fnd_attached_documents

17: debug_info VARCHAR2(500);
18: BEGIN
19: select count(1)
20: into l_attachments_count
21: from fnd_attached_documents
22: where entity_name = 'AP_INVOICES_INTERFACE'
23: and pk1_value = p_invoice_id;
24:
25: -- only delete if there is an attachment

Line 29: fnd_attached_documents2_pkg.delete_attachments(

25: -- only delete if there is an attachment
26: if ( l_attachments_count > 0 ) then
27: -- assuming deleting only the association with related documents
28: -- need to see if that's always the case
29: fnd_attached_documents2_pkg.delete_attachments(
30: X_entity_name => 'AP_INVOICES_INTERFACE',
31: X_pk1_value => p_invoice_id,
32: X_delete_document_flag => 'N' );
33: end if;