Tech Trainings

Oracle E-Business – Invoke Concurrent Programing Using PLSQL

November 30, 2021 by admin

Declare
 L_Conc_Id Number; 
    L_User_Id          Number := 1318;--Fnd_Profile.Value('USER_ID');
   L_Resp_Id          Number := 20419 ;-- fnd_profile.value('RESP_ID');
   L_Resp_App_Id      Number := 0 ;-- Fnd_Profile.Value('RESP_APPL_ID');
L_Org_Id number :=204; 

begin

dbms_output.put_line('Invoking Hello World CP From PLSQL API') ; 

fnd_global.apps_initialize
   (
      user_id       => l_user_id       --User Id
      ,resp_id      => l_resp_id       --Responsibility Id
      ,resp_appl_id => l_resp_app_id   --Responsibility Application Id
   );
   
     l_conc_id := fnd_request.submit_request
                   ( application   => 'FND'
                    ,program       => 'XXORA_HELLO_CP'
                    ,description   => NULL
                    ,start_time    => SYSDATE
                    ,sub_request   => FALSE
--                    ,argument1     => l_int_run_id    --interface run id
--                    ,argument2     => l_access_set_id --data access set_id
--                    ,argument3     => 'N'             --post to suspense
--                    ,argument4     => NULL            --from date
--                    ,argument5     => NULL            --to date
--                    ,argument6     => 'N'             --summary mode
--                    ,argument7     => 'N'             --import DFF
--                    ,argument8     => 'Y'             --backward mode
                   );
 
   Commit;

dbms_output.put_line('Conc request id ---' || l_conc_id);
end ; 

Comments |0|