Tuesday, January 31, 2012

How to add Concurrent program to request group from backend.


Following piece of code is used for adding Concurrent program to any request group from Pl/SQL

DECLARE
BEGIN
FND_PROGRAM.add_to_group
    (
     PROGRAM_SHORT_NAME  =>'XX_CONC_PROG'
    ,PROGRAM_APPLICATION =>'AR'
    ,REQUEST_GROUP       => 'All Reports'
    ,GROUP_APPLICATION   =>'SQLAP'
    ) ;    
  commit;
exception 
    when others then
           dbms_output.put_line('Request Already exixts in this request group'); 
END ;
/