| go_record; go_item [message #178256] |
Tue, 20 June 2006 06:05  |
tomaac
Messages: 10
Registered: May 2006
|
Junior Member |
|
|
What does this code stands for?
if nvl(FND_PROFILE.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER'),'Y') = 'Y' then
go_record(:SYSTEM.Trigger_Record);
go_item('ast_cu_location.address1');
execute_trigger('KEY-LISTVAL');
else
null;
end if;
-- novice
|
|
|
|
|
|
| Re: go_record; go_item [message #178349 is a reply to message #178340] |
Tue, 20 June 2006 14:32  |
tomaac
Messages: 10
Registered: May 2006
|
Junior Member |
|
|
| Littlefoot wrote on Tue, 20 June 2006 12:41 |
"FND_PROFILE.VALUE" seems to be a function which accepts one parameter and returns character; as 'Y' is expected here, I guess that it can return Y, N or NULL.
NVL function is here so that it doesn't matter whether it is Y or NULL - IF condition will be satisfied and several commands will be executed:
- go to the triggering record
- go to designed item (ast_cu_location.address1)
- open List of Values window
|
Does "go to the triggering record" means that that item becomes active which cause trigger to execute?
"go to designed item (ast_cu_location.address1)" means that ast_cu_location.address1 becomes active?
Actually what means "go to ..." in these cases?
Is there any standard documentation where this is described, cause I'm an absolute novice to Forms?
|
|
|
|
| Re: go_record; go_item [message #178362 is a reply to message #178349] |
Tue, 20 June 2006 16:14 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
"Go to" means exactly what it says. First one takes you to the triggering record, the second one to the item in this record. If the item is disabled, you'd get an error message (can not navigate to disabled item). If it is enabled, cursor will blink in this item.
Those are restricted procedures and their description can easily be found in Oracle Forms Online Help system (while in Forms Builder, select Help menu, Online Help, Search tab, type "go_record" (or "go_item" or anything else) and search for it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
