OraFAQ Forum: Forms » best way to pass 100+ parameter in form A to form B

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)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

best way to pass 100+ parameter in form A to form B [message #572840]

Tue, 18 December 2012 01:52

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

Report message to a moderator

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

Littlefoot
Messages: 17253
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.

Report message to a moderator

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

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

cookiemonster
Messages: 9285
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.

Report message to a moderator

Previous Topic:	how to reduce quantity (merged 2)
Next Topic:	How to open another form within a form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 07:12:56 CDT 2013

Total time taken to generate the page: 0.10119 seconds