Home » Developer & Programmer » Forms » go_record; go_item
go_record; go_item [message #178256] Tue, 20 June 2006 06:05 Go to next message
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 #178340 is a reply to message #178256] Tue, 20 June 2006 12:41 Go to previous messageGo to next message
Littlefoot
Messages: 19892
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"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
Re: go_record; go_item [message #178349 is a reply to message #178340] Tue, 20 June 2006 14:32 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 19892
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.
Previous Topic: how get parameter wise view
Next Topic: forms-mask based on stored procedure ?
Goto Forum:
  


Current Time: Sun Dec 21 15:11:05 CST 2014

Total time taken to generate the page: 0.08057 seconds