Integration

Can anyone help because i am confused about Oracles offerings!

In my organisation where use Staffware v9 (now TIBCO, and not the iprocess engine) as the workflow backbone. Relatively simple process maps with background steps calling SQL code to perfom updates and return case data variable settings and foreground steps mapping to oracle forms. v9 is client server with limited API set so uses DDL calls with parameter passing and timers to communicate, but used the better API interfaces in the past. Currently on Oracle 10g at the moment, plans to go to 11g, but not holding my breath on this as we would need some infrastructure changes.

The client server nature of the TIBCO product and the fact that it uses flat files for transactional processing means that it is no longer suitable for our needs, and i want to replace it with an alternative. As we are an oracle shop, a suitable oracle product would be ideal, but unlike the (admittedly sparse) documentation on the old oracle workflow, the new stuff confuses the hell out of me as it seems so wrapped up with SOA concepts (something we are NOT interested in at the moment) and with the addition of some what conflicting BPM and BAM tools as well, there also seems no clear direction. TIBCO also want a lot of money to go to the new product

What i need is a tool to do the following
1) define users, access levels, group work queues with membership and supervisors
2) graphical process designer that can define PL/SQL interface steps, make available foreground tasks in the appropriate queues with APIs to access from the forms environment
3) workflow process management objects like
- decision based process routing on rule or data values
- sub procedure definitions
- external event APIs to control flow and update case data
- branching, joining and wait joins
- rules engines and dynamic process definition nice to have, but not critical
4) operational API for case starting, event issue, audit trail access etc.
5) APIs and repository held in the database
6) externally accessible database structure (ie: makes sense in sql) for reporting/management

I have worked with workflow systems for way too many years (years ago i was even on the Staffware advisory panel) so well up on how these systems work, and think that all of the above is pretty basic stuff, but (maybe just getting old) i cannot see how oracle are meeting what i see as the basics

any ideas?