DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_DOC_SEQUENCE_AUDIT

Line 5495: Print('ap_doc_sequence_audit, Checks');

5491: */
5492: debug_info := 'Deleting one subgroup of Invoices';
5493: IF g_debug_switch in ('y','Y') THEN
5494: Print('(Delete_AP_Tables)'||debug_info);
5495: Print('ap_doc_sequence_audit, Checks');
5496: END IF;
5497:
5498: /* Bug 5052709 - removal of obsolete SQL
5499: -- Move the deletion of ap_chrg_allocations from purge_pos to here.

Line 5517: DELETE FROM ap_doc_sequence_audit AUD

5513: */
5514: -- delete_check_sequence_audit
5515:
5516: /* bug3068811 : Changed from EXISTS to IN for performance */
5517: DELETE FROM ap_doc_sequence_audit AUD
5518: WHERE (AUD.doc_sequence_id , AUD.doc_sequence_value)
5519: IN (SELECT C.doc_sequence_id , C.doc_sequence_value
5520: FROM ap_purge_invoice_list PL,
5521: ap_checks C,

Line 5711: debug_info := 'ap_doc_sequence_audit, Invoices';

5707: l_invoice_lines_rows := SQL%ROWCOUNT; /*bug 11829621*/
5708:
5709: /* bug 10391241 */
5710:
5711: debug_info := 'ap_doc_sequence_audit, Invoices';
5712: IF g_debug_switch in ('y','Y') THEN
5713: Print('(Delete_AP_Tables)'||debug_info);
5714: END IF;
5715:

Line 5719: DELETE FROM ap_doc_sequence_audit AUD

5715:
5716: -- delete_inv_seq_audit
5717:
5718: /* bug3284915 : Changed from EXISTS to IN for performance */
5719: DELETE FROM ap_doc_sequence_audit AUD
5720: WHERE (AUD.doc_sequence_id , AUD.doc_sequence_value)
5721: IN (SELECT I.doc_sequence_id , I.doc_sequence_value
5722: FROM ap_purge_invoice_list PL,
5723: ap_invoices I