Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Tuesday, 29 March 2016

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;
Share this article :

0 comments:

Post a Comment