2 Replies Latest reply on Sep 6, 2016 4:33 PM by User54262

    Automated Concurrent Program Submission

    User54262

      Hi All,

       

      fnd_request.submit_request will be used to submit the concurrent programs from a PL/SQL block.

       

      Scenario #1: Submitting concurrent program with a single parameter

       

      BEGIN

      vl_set_status := fnd_submit.submit_program (application      => <Application Name>,

                       program          => NULL,

                       stage     => NULL,

                       argument1        => <Parameter #1>

                      );

      END;

       

      Scenario #2: Submitting concurrent program with a couple of parameter

       

      BEGIN

      vl_set_status := fnd_submit.submit_program (application      => <Application Name>,

                       program          => NULL,

                       stage     => NULL,

                       argument1        => <Parameter #1>,

                       argument2        => <Parameter #2>

                      );

      END;

       

      Is there anyway to write a single PL/SQL program to submit different concurrent with different number of parameters ?

       

      ie. to have single sql block to covers both scenario 1 and 2