DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_ENCUMBRANCE_LINES

Line 3379: debug_info := 'ap_encumbrance_lines';

3375: INTO fp_payment_history_rows
3376: FROM ap_payment_history;
3377:
3378: --
3379: debug_info := 'ap_encumbrance_lines';
3380: IF g_debug_switch in ('y','Y') THEN
3381: Print('(Count_Accounting_Rows)'||debug_info);
3382: END IF;
3383:

Line 3387: FROM ap_encumbrance_lines;

3383:
3384: --
3385: SELECT count(*)
3386: INTO fp_encumbrance_line_rows
3387: FROM ap_encumbrance_lines;
3388:
3389: --
3390: debug_info := 'rcv_subledger_details';
3391: IF g_debug_switch in ('y','Y') THEN

Line 4049: ap_encumbrance_lines = fp_encumbrance_line_rows,

4045: ap_ae_headers = fp_ae_header_rows,
4046: ap_accounting_events = fp_accounting_event_rows,
4047: ap_chrg_allocations = fp_chrg_allocation_rows,
4048: ap_payment_history = fp_payment_history_rows,
4049: ap_encumbrance_lines = fp_encumbrance_line_rows,
4050: rcv_subledger_details = fp_rcv_subledger_detail_rows
4051: WHERE purge_name = fp_purge_name ;
4052:
4053: --

Line 5433: debug_info := 'ap_encumbrance_lines';

5429: and pil.invoice_id BETWEEN range_low AND range_high) ;
5430:
5431: */ --Bug 4588031
5432:
5433: debug_info := 'ap_encumbrance_lines';
5434: IF g_debug_switch in ('y','Y') THEN
5435: Print('(Purge_Accounting)'||debug_info);
5436: END IF;
5437:

Line 5438: DELETE FROM ap_encumbrance_lines aen

5434: IF g_debug_switch in ('y','Y') THEN
5435: Print('(Purge_Accounting)'||debug_info);
5436: END IF;
5437:
5438: DELETE FROM ap_encumbrance_lines aen
5439: WHERE EXISTS (
5440: SELECT 'dist'
5441: FROM ap_purge_invoice_list pil
5442: , ap_invoice_distributions aid