| Call_form with parameter [message #80173] |
Mon, 19 August 2002 06:47  |
aish
Messages: 44
Registered: March 2001
|
Member |
|
|
I want to call one form from another and I want customer id as my parameter,where customer id is a block item.
I want to take this customer id as input parmeter and call a form and called form should display the screen for that custoer id
How do I do that?
|
|
|
|
| Re: Call_form with parameter [message #80175 is a reply to message #80173] |
Mon, 19 August 2002 12:30  |
Bob
Messages: 49
Registered: March 1999
|
Member |
|
|
/*
** Built-in: CALL_FORM
** Example: Calls a form, passing a parameter list if the
** parameter list exists.
*/
DECLARE
pl_id ParamList;
theFormName VARCHAR2(20) := 'addcust';
BEGIN
/*
** Try to lookup the 'TEMPDATA' parameter list
*/
pl_id := Get_Parameter_List('tempdata');
/*
IF Id_Null(pl_id) THEN
Call_Form(theFormName);
ELSE
Call_Form(theFormName, HIDE, NO_REPLACE, NO_QUERY_ONLY,
pl_id);
END IF;
Call_Form('lookcust',NO_HIDE,DO_REPLACE,QUERY_ONLY);
END;
Copyright (c) 1994, Oracle Corporation.
/*
** Built-in: ADD_PARAMETER
** Example: Add a value parameter to an existing Parameter
** List 'TEMPDATA', then add a data parameter to
** the list to associate named query 'DEPT_QUERY'
** with record group 'DEPT_RECORDGROUP'.
*/
DECLARE
pl_id ParamList;
BEGIN
pl_id := Get_Parameter_List('tempdata');
IF NOT Id_Null(pl_id) THEN
Add_Parameter(pl_id,'number_of_copies',TEXT_PARAMETER,'19');
Add_Parameter(pl_id, 'dept_query', DATA_PARAMETER,
'dept_recordgroup');
END IF;
END;
Copyright (c) 1994, Oracle Corporation.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
