Home » Applications » Oracle Fusion Apps & E-Business Suite » how to user go_block in when-validate-item
|
|
 Re: how to user go_block in when-validate-item [message #449550 is a reply to message #449521] |
Tue, 30 March 2010 07:16   |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
GO_BLOCK is a restricted procedure and can not be used in the WHEN-VALIDATE-ITEM trigger.
You could use it in, for example, KEY-NEXT-ITEM trigger, but it wouldn't fire if user navigates through items using a mouse.
Or, you could set master block navigation style property to "Change data block" and put EXECUTE_QUERY into a PRE-BLOCK trigger (of a detail block). If the item you are talking about is the last in the master block, navigating out of it will do the job.
However, why and what are you, actually, trying to do? As you didn't provide much information, I can't imagine what should be the case here.
Because, detail block should be populated upon querying master block, not during insert. Are you inserting values into an item? Is it the only item in the master block?
Do explain it a little bit more and you might hear some more ideas.
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun May 04 03:14:23 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
