Script to delete Concurrent program and Executable and Data definition and Template

Begin

fnd_program.delete_program('program short name','applicaton shot name');

fnd_program.delete_executable('program short name','applicaton shot name');

commit;

End;

Example: If you have a concurrent Progam called "Employee Details Report" with the short name EMPDTLSREP and an Executable EMPDTLSEXE is associated with the concurrentprogram Employee Details Report in apps schema then use the script below to delete both the concurrent program and executable.

Begin

fnd_program.delete_program('EMPDTLSREP', 'applicaton shot name' );

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','NRGINTR');

END;

--------------------------------------------------------

--------------------------------------------------------

script for deleting the template

------------------------------------------------------>

BEGIN

XDO_TEMPLATES_PKG.DELETE_ROW('INV','NRGINTR');

END;