DBA Data[Home] [Help]

APPS.PSA_UTILS dependencies on AP_HOLDS_ALL

Line 1197: debug_other_string(g_state_level,l_path_name, 'Deleting ap_holds_all' );

1193: AND accounting_event_id = l_events_tab(l_counter).event_id;
1194: END IF;
1195: END LOOP;
1196:
1197: debug_other_string(g_state_level,l_path_name, 'Deleting ap_holds_all' );
1198: DELETE ap_holds_all
1199: WHERE invoice_id = p_invoice_id
1200: AND hold_lookup_code = 'CANT FUNDS CHECK'
1201: AND release_lookup_code IS NULL;

Line 1198: DELETE ap_holds_all

1194: END IF;
1195: END LOOP;
1196:
1197: debug_other_string(g_state_level,l_path_name, 'Deleting ap_holds_all' );
1198: DELETE ap_holds_all
1199: WHERE invoice_id = p_invoice_id
1200: AND hold_lookup_code = 'CANT FUNDS CHECK'
1201: AND release_lookup_code IS NULL;
1202: debug_other_string(g_state_level,l_path_name, 'Deleted '||SQL%ROWCOUNT||' rows.' );