Home » Applications » Oracle Fusion Apps & E-Business Suite » how to user go_block in when-validate-item
how to user go_block in when-validate-item [message #449521] Tue, 30 March 2010 04:51 Go to next message
westwolf2009
Messages: 14
Registered: March 2010
Junior Member
how to user go_block in when-validate-item,

when i change a item data,i want auto query detail block data.
so ,how can i do?
Re: how to user go_block in when-validate-item [message #449550 is a reply to message #449521] Tue, 30 March 2010 07:16 Go to previous messageGo to next message
Littlefoot
Messages: 21807
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.
Re: how to user go_block in when-validate-item [message #449882 is a reply to message #449550] Thu, 01 April 2010 22:18 Go to previous messageGo to next message
westwolf2009
Messages: 14
Registered: March 2010
Junior Member
thank you,

i had resoled it, i use an other way .
Re: how to user go_block in when-validate-item [message #449890 is a reply to message #449882] Fri, 02 April 2010 01:34 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How did you do it? Would you mind to share?
Re: how to user go_block in when-validate-item [message #450238 is a reply to message #449890] Mon, 05 April 2010 20:52 Go to previous messageGo to next message
westwolf2009
Messages: 14
Registered: March 2010
Junior Member
i put two item,i fire "go_block" in the when-new-item-instance on net item,

the first item is the code,the second item is code description.
Re: how to user go_block in when-validate-item [message #450248 is a reply to message #450238] Mon, 05 April 2010 23:53 Go to previous message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK; but what does this "solution" have to do with the original "question"? You were asking how to perform query of the detail block, while your last message says that there's a description item there. Does it mean that the whole detail block is now shrank into a single item?
Previous Topic: QP_PRICE_LIST_PUB.PROCESS_PRICE_LIST
Next Topic: AIM for Business Flows
Goto Forum:
  


Current Time: Tue Apr 23 12:40:46 CDT 2024