| Oracle Forms Triggers [message #522768] |
Tue, 13 September 2011 10:13  |
 |
ritaman
Messages: 10
Registered: September 2011
Location: Ireland
|
Junior Member |
|
|
Hi
I am fairly new to Oracle forms and have the job of editing an existing form.
At the moment, I have a fairly standard Purchase Order form which contains pre-loaded data (been uploaded from an XML file).
When the Purchase Order is processed, the form updates a Price History table only if the Price on the PO_Details changes.
The code for updating the price history table is contained in a PRE_UPDATE trigger on the PO_Details Data Block.
No other data changes on the PO_Details table.
I now want to change this so that the Price History table is updated even if the price does not change i.e I want to create a history record for each record on the PO_Details irrespective of whether it was updated or not.
Is there an alternative trigger that I can move my code to (ie move it from PRE_UPDATE) to some other trigger that is fired for each PO_Details record even if there is no change.
Hope this makes sense.
Thanks in advance
[color removed]
[Updated on: Tue, 13 September 2011 13:03] by Moderator Report message to a moderator |
|
|
|
| Re: Oracle Forms Triggers [message #522770 is a reply to message #522768] |
Tue, 13 September 2011 10:29  |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
What kicks off the update of po_details in the first place?
Do the users manually change stuff in the block and click save?
Or is there a button that does stuff?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
