Home » Developer & Programmer » Forms » best way to pass 100+ parameter in form A to form B (form 6i on windows deploy on EBS 11.5.10)
best way to pass 100+ parameter in form A to form B [message #572840] Tue, 18 December 2012 01:52 Go to next message
chanokchai
Messages: 11
Registered: December 2012
Location: thailand
Junior Member

Dear friends

If I want to pass lots of informations (100 parameter) from standard HR assignment form to my custom form. I am using fnd_function.execute('called form') to launch new form. what is the best simple way to do.

I thinking of creating 100 parameter object but not sure it has limitation of number or not. Another ways I googled are shared PL/SQL library or parameter list which I still doubt. Confused

thank you so much
Jarjarbank
Re: best way to pass 100+ parameter in form A to form B [message #572848 is a reply to message #572840] Tue, 18 December 2012 02:46 Go to previous messageGo to next message
Littlefoot
Messages: 19319
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How about creating a (global temporary?) table: form A would put information into it, form B would read stored values.
icon14.gif  Re: best way to pass 100+ parameter in form A to form B [message #573032 is a reply to message #572848] Thu, 20 December 2012 01:55 Go to previous messageGo to next message
chanokchai
Messages: 11
Registered: December 2012
Location: thailand
Junior Member

thanks littlefoot. that's 1 way to do. I have found another way would like to share.

using shared PLSQL library
1. create custom .PLL library ( XXTEST.pll )
2. add custom package spec ( XXTESTPKG ) with all parameters declared. no need package body.
3. compile it
4. attach this libraries in both calling form and called form.
5. done. you can refer XXTESTPKG.parameterABC at both side.

thanks!

[Updated on: Thu, 20 December 2012 01:56]

Report message to a moderator

Re: best way to pass 100+ parameter in form A to form B [message #573054 is a reply to message #573032] Thu, 20 December 2012 06:25 Go to previous message
cookiemonster
Messages: 10846
Registered: September 2008
Location: Rainy Manchester
Senior Member
You can do the same thing with a datbase package, then you don't need to attach anything to the form.
Previous Topic: how to reduce quantity (merged 2)
Next Topic: How to open another form within a form
Goto Forum:
  


Current Time: Mon Jul 28 03:45:02 CDT 2014

Total time taken to generate the page: 0.11919 seconds