I'm starting to explore APEX as a development platform. I have an application using packages and tables for the business logic.
Currently it was working within EBS using forms.
I now want to move this to APEX basically changing the application layer from forms to APEX.
The packages work for all the Creation, Updating and Deleting. There are also views.
From what I have been playing around with I am looking at this approach and would like input as to if its viable.
I need a report that behaves like a form. This will be based on a view to bring data.
From this report form the user will be able to update the data and if he want to insert it should open a new line.
All the validation I want the package to do as well as the inserting and updating.
So is there a best way of doing this and also does anyone have any suggestions as to how.
Would I create a blank page and build it from the ground up for each form or maybe start with either a form or report page and then customize it.
you can use tabular forms for this:
If you want for all to be cleaner in APEX, you can create instead of trigger over your view that uses your package API for DML.
This is sort of what I am looking for but is there a way to make a Tabular Form 1 row.
This sort of defeats its purpose but I what the functionality of this but the look and feel to be like a Form.
Navigation between records can then be done with navigation buttons.
Or is this not the way APEX works