How To Delete A Concurrent Program, Executable (Short Name),Data Definition and Template From Back End In Oracle Apps EBS R12
-- Script to delete the concurrent program and executable from Oracle Apps:
Syntax :
----------
Begin
fnd_program.delete_program('program short name','schema');
fnd_program.delete_executable('program short name','schema');
commit;
End;
Example :
------------
Begin
fnd_program.delete_program('XX_SALARY_DETAIL_REPORT', 'XXBRAC' );
fnd_program.delete_executable('XX_SALARY_DETAIL_REPORT', 'XXBRAC' );
commit;
End;
----------------------------------------------------------------------------------
Begin
fnd_program.delete_program('EMPDTLSREP', 'apps' );
fnd_program.delete_executable('EMPDTLSEXE', 'apps' );
commit;
End;
Note: The same concurrent program can be disable through from end if a user decides not to use it.
------------------------------------------------>
-- Script for deleting the datadefinition
------------------------------------------------>
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('INV','XX_SALARY_DETAIL_REPORT');
END;
------------------------------------------------------
-- script for deleting the template
------------------------------------------------------>
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('INV','XX_SALARY_DETAIL_REPORT');
END;
