Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create Custom Save Button to save IG and other regions at one time on a page

FriendlyToooSep 3 2019 — edited Sep 4 2019

Hi Folks:

I have a dialog that includes three fields (in two different regions) that a user can update, as well as an interactive grid. I need the save button (approve requisitions buttton shown below) to save any changes in the interactive grid as well as any changes in the other three fields.

I know I can have a separate save button on the IG, but that is not what my boss wants. Here is a pic of the form. The fields circled in blue are the fields I need to save changes too:

pastedImage_0.png

These are the three fields NOT in the IG that I need to save.

Additional Info field: :P6_ADDITIONAL_INFO

Building field: :P6_BUILDING

Room: :P6_ROOM

The Interactive Grid is in the Approving Official Region.

On the Approving Official Interactive Grid the approval date is what would be changed

(sql for the IG:

SELECT requisition, fiscal_year, approving_official, approval_date, approval_routing, delegate

FROM requisition_approvals

WHERE REQUISITION = :P6_REQUISITION

AND FISCAL_YEAR = :P6_FISCAL_YEAR)

pastedImage_1.png

Regions on Form:

pastedImage_10.png

Button Info currently for the "Approve Requisitions" Button:

pastedImage_0.png

Thank you so much for any help.....

Matthew

Comments
Post Details
Added on Sep 3 2019
2 comments
1,148 views