707:
708:
709: --4693463
710:
711: delete from ap_unselected_invoices_all
712: where checkrun_id = l_checkrun_id;
713:
714: delete from ap_selected_invoices_all
715: where checkrun_id = l_checkrun_id
2722:
2723: END LOOP; --loop for org_id's
2724: close c_relevant_orgs;
2725:
2726: l_debug_info := 'DELETE FROM ap_unselected_invoices_all';
2727: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2728: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2729: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2730: END IF;
2728: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2729: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2730: END IF;
2731:
2732: DELETE FROM ap_unselected_invoices_all
2733: WHERE checkrun_id = l_checkrun_id;
2734:
2735: END LOOP; -- loop for checkrun_id
2736: