[Home] [Help]
1595: for req in req_cursor(program_application_id, program_id) loop
1596: delete from fnd_concurrent_requests
1597: where request_id = req.request_id;
1598:
1599: delete from fnd_run_requests
1600: where request_id = req.request_id;
1601:
1602: delete from fnd_conc_release_periods_tl
1603: where (application_id, concurrent_period_id) in
1650: delete from fnd_file_temp
1651: where request_id = req.request_id;
1652:
1653: /* in case parent was cancelled before running: */
1654: delete from fnd_run_requests
1655: where parent_request_id = req.request_id;
1656:
1657: delete from fnd_conc_request_arguments
1658: where request_id = req.request_id;