Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Generic package to submit Concurrent Request

User_LI666Dec 9 2022 — edited Dec 21 2022

There is requirement to develop a package to submit concurrent request through backend using fnd submit API.
Whenever they pass user id, repsonsibility id, program name and its parameters it should submit the request.
User will use the number arguments as per the concurrent program.
How use fnd_submit inside the package function without knowing how many program parameters being passed as we don't know which program they submit.
Is it possible to have variable number of arguments in plsql like when concurrent program xyz has n number of parameters then the package function should use same n number of input parameters in fnd_submit API when they call this package function to submit xyz cp by passing n number of input parameters along with user id, responsibility id, cp name etc.?
Is it possible to achieve this requirement?

Comments
Post Details
Added on Dec 9 2022
3 comments
794 views