EBS : API to Add / Remove Concurrent Program from Request Group in Oracle Apps (r12)

How to ADD / Remove concurrent 

Program using API in Request Group

 

Remove Concurrent Request from request Group

BEGIN

begin

    apps.fnd_program.remove_from_group

           (PROGRAM_SHORT_NAME  => 'XXTECHARDS_PROG',

            PROGRAM_APPLICATION => 'SQLAP',

            REQUEST_GROUP       => 'All_Payables',

            GROUP_APPLICATION   => 'SQLAP'

          );

    commit;

exception

    when no_data_found then

    dbms_output.put_line('Unable to remove from Request group');

end;

ADD Concurrent Request from request Group

begin

apps.fnd_program.add_to_group(

            PROGRAM_SHORT_NAME  => 'XXTECHARDS_TRANS',

            PROGRAM_APPLICATION => 'SQLAP',

            REQUEST_GROUP       => 'All_Payables',

            GROUP_APPLICATION   => 'SQLAP'

      );

=========================================================================

#Oracle Apps #EBS #Concurrent Request #Remove Concurrent Program from Request Group #Add Concurrent Program from Request Group #Request Group

#Add Concurrent Program to Request group without front end.

EBS : API To Delete Concurrent Program and Executable in Oracle Apps (R12)

API To Delete Concurrent Program and Executable from Backend in Oracle Apps

---API : How to Delete Concurrent Program Executable From Backend 
DECLARE
   v_executable_short_name   VARCHAR2 (200);
   v_application             VARCHAR2 (200);
BEGIN
   v_executable_short_name := 'XX_SHORTNAME'; ---Short name 
   v_application           := 'Payables';
   apps.fnd_program.delete_executable (executable_short_name      => v_executable_short_name,
                                       application                => v_application
                                      );
   COMMIT;
END;
--API : How to Delete Concurrent Program AND Executable From Backend ---
begin
fnd_program.delete_program('TECHHARDS_SHORTNAME','APPLICATION');
fnd_program.delete_executable('TECHHARDS_EXE_NAME','APPLICATION');
COMMIT;
end; 

***********************************************************************************

#Oracle Apps #EBS #Concurrent Program #Executable 

#How to Delete Concurrent Program through API

#How to Delete Concurrent Program Executable through API

# Fnd_Concurrent_Requests