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 a delete process for tabular form

AliceFan-OracleJul 17 2015 — edited Aug 1 2015

Hello

I have created two applications and they are sharing the same DB schema at apex.oraclecorp.com.

One is Purchase Order app, when user enter "Purchase Request Number" and select "ERT HW/Item ID: HW/Item Name"

and click "apply change" in the tabular form, the other app in 3rd screen shot, will automatically update the data with selected item ID with the "purchase request number".

I have done this by the following code in first screenshot.

I would like to know how to create a delete process for this?

That mean when I delete the one of item in purchase order app, the other application can update the item with that purchase request number (PRM) as null?

How to specify the item I checked to delete ?

Thank you!

Alice

I have done this by Screen Shot 2015-07-17 at 16.24.22.png

Screen Shot 2015-07-17 at 16.16.18.png

Screen Shot 2015-07-17 at 16.18.33.png

This post has been answered by Kiran Pawar on Aug 1 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2015
Added on Jul 17 2015
4 comments
814 views