DBMS_SCHEDULER Job with dynamic parameters
1: Execute 1 job (script a) <= populates an extneral table with a list of files
2: Execute 1 job (stored procedure) <= evaluates the files based on certain business rules and updates the file_master table
3: Execute 2 jobs (scripts b & c) <= manages the files
Both scripts b and c will need a list of files (that will change every execution) provided by dbms_scheduler.