Home » Developer & Programmer » Forms » question on parameter/paramlist
question on parameter/paramlist [message #151236] Tue, 13 December 2005 20:19 Go to next message
Scarlet.Zhu
Messages: 22
Registered: December 2005
Location: Shanghai
Junior Member
Hi,
I cannot clear my knowledge on parameter now.
According to the user manual:
Parameters are passed to called forms by means of a parameter list. A parameter list is a named programmatic construct that is simply a list of parameter names (called keys) and their values.
The following table shows the structure of a parameter list that contains four parameters:

Key Paramtype Value
CITY Text_Parameter 'BOGOTA'
CATEGORY Text_Parameter 'EXPORTS'
MULTIPLIER Text_Parameter '.0275'
NEW_DATA Data_Parameter 'RECORD_GROUP8'

That is, how could I use parameter like NEW_DATA in forms?

Here is another question as I raised from ashock it's question:

[quote]
Hi,
i try to maximize the report window. somthing wrong in my parameter.




Declare
pl_id ParamList;
Begin
pl_id := Create_Parameter_List('tmpdata');

Add_Parameter(pl_id, 'WINDOW_STATE', TEXT_PARAMETER, 'MAXIMIZE');

RUN_PRODUCT(REPORTS, 'rept1',
SYNCHRONOUS,
RUNTIME,
FILESYSTEM,
pl_id,null );

End;

[quote/]

what is the difference it owns with code below?
[quote]
l_request_id :=fnd_request.submit_request(l_appl_short_name,'ZZPO102',NULL,NULL,NULL
,l_bl_num,chr(0),null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null
,null,null,null,null,null);

COMMIT;

FND_FUNCTION.EXECUTE('FND_FNDCPQCR_USER');
[quote/]



Thanks !

Scarlet

[Updated on: Tue, 13 December 2005 20:24]

Report message to a moderator

Re: question on parameter/paramlist [message #151237 is a reply to message #151236] Tue, 13 December 2005 21:05 Go to previous message
Scarlet.Zhu
Messages: 22
Registered: December 2005
Location: Shanghai
Junior Member
well, i understand some:

run_product is an interface via which you may use other oracle products such as reports.

fnd_request.submit_request is another interface via which you may use non-oracle products which will be registered like a function.

Am I right??

But how could I apply:
Key Paramtype Value
CITY Text_Parameter 'BOGOTA'
CATEGORY Text_Parameter 'EXPORTS'
MULTIPLIER Text_Parameter '.0275'
NEW_DATA Data_Parameter 'RECORD_GROUP8'

I mean who can give me an example like NEW_DATA Data_Parameter 'RECORD_GROUP8'--use a recordgroup!?

Thanks
Previous Topic: default values
Next Topic: run_product parameter
Goto Forum:
  


Current Time: Fri Sep 20 02:23:43 CDT 2024