DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_ENCUMBRANCE_LINES

Line 3883: debug_info := 'ap_encumbrance_lines';

3879: INTO fp_payment_history_rows
3880: FROM ap_payment_history;
3881:
3882: --
3883: debug_info := 'ap_encumbrance_lines';
3884: IF g_debug_switch in ('y','Y') THEN
3885: Print('(Count_Accounting_Rows)'||debug_info);
3886: END IF;
3887:

Line 3891: FROM ap_encumbrance_lines;

3887:
3888: --
3889: SELECT count(*)
3890: INTO fp_encumbrance_line_rows
3891: FROM ap_encumbrance_lines;
3892:
3893: --
3894: debug_info := 'rcv_subledger_details';
3895: IF g_debug_switch in ('y','Y') THEN

Line 4553: ap_encumbrance_lines = fp_encumbrance_line_rows,

4549: ap_ae_headers = fp_ae_header_rows,
4550: ap_accounting_events = fp_accounting_event_rows,
4551: ap_chrg_allocations = fp_chrg_allocation_rows,
4552: ap_payment_history = fp_payment_history_rows,
4553: ap_encumbrance_lines = fp_encumbrance_line_rows,
4554: rcv_subledger_details = fp_rcv_subledger_detail_rows
4555: WHERE purge_name = fp_purge_name ;
4556:
4557: --

Line 5993: debug_info := 'ap_encumbrance_lines';

5989: and pil.invoice_id BETWEEN range_low AND range_high) ;
5990:
5991: */ --Bug 4588031
5992:
5993: debug_info := 'ap_encumbrance_lines';
5994: IF g_debug_switch in ('y','Y') THEN
5995: Print('(Purge_Accounting)'||debug_info);
5996: END IF;
5997:

Line 5998: DELETE FROM ap_encumbrance_lines aen

5994: IF g_debug_switch in ('y','Y') THEN
5995: Print('(Purge_Accounting)'||debug_info);
5996: END IF;
5997:
5998: DELETE FROM ap_encumbrance_lines aen
5999: WHERE EXISTS (
6000: SELECT 'dist'
6001: FROM ap_purge_invoice_list pil
6002: , ap_invoice_distributions aid