Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Custom.pll, zooms, fnd_function.execute, Auto query after form navigat

Status
Not open for further replies.

Chiere

Programmer
Nov 19, 2003
4
US
I have invoked a zoom in the custom library using fnd_function.execute, however I can not get it to auto query the form after navigation to the form. I am passing the customer number to the block field RCU_CUSTOMER_NUMBER, which is the required info for the query.

The following is my code from the event procedure of custom.pll.

if (event_name = 'ZOOM') then
if (form_name = 'ARXCWMAI' and block_name = 'CQIT_PS') then
param_to_pass1 := name_in('CQIT_PS.RAC_CUSTOMER_NUMBER';

fnd_function.execute(FUNCTION_NAME=>'AR_ARXCWMAI_ECC',
OPEN_FLAG=>'Y',
SESSION_FLAG=>'N',
OTHER_PARAMS=>'RCU_CUSTOMER_NUMBER"'||param_to_pass1||'"');
end if;
else
null;
end if;

Please Help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top