/*First Delete Concurrent Program*/
BEGIN
fnd_program.
delete_program (program_short_name => 'Concurrent_Program_Short_Name',
application => 'Application_Short_Name');
COMMIT;
END;
/*Second delete Executable*/
BEGIN
fnd_program.
delete_executable (executable_short_name => 'Executable_Short_Name',
application => 'Application_Short_Name');
COMMIT;
END;
/*Third Delete Data Template*/
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('Application_Short_Name','Template Code');
COMMIT;
END;
/*Fourth Delete Data Definition*/
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('Application_Short_Name','Data Definition Code',);
COMMIT;
END;
On Tue, Dec 24, 2013 at 3:45 PM, Sumit Vishwas Nandapure <sumitn@evosys.co.in> wrote:
/*First Delete Concurrent Program*/
BEGIN
fnd_program.
delete_program (program_short_name => 'Concurrent_Program_Short_Name',
application => 'Application_Short_Name');
COMMIT;
END;
/*Second delete Executable*/
BEGIN
fnd_program.
delete_executable (executable_short_name => 'Concurrent_Program_Short_Name',
application => 'Application_Short_Name');
COMMIT;
END;
/*Third Delete Data Template*/
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('Application_Short_Name','Concurrent_Program_Short_Name');
COMMIT;
END;
/*Fourth Delete Data Definition*/
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('Application_Short_Name','Concurrent_Program_Short_Name',);
COMMIT;
END;
BEGIN
fnd_program.
delete_program (program_short_name => 'Concurrent_Program_Short_Name',
application => 'Application_Short_Name');
COMMIT;
END;
/*Second delete Executable*/
BEGIN
fnd_program.
delete_executable (executable_short_name => 'Executable_Short_Name',
application => 'Application_Short_Name');
COMMIT;
END;
/*Third Delete Data Template*/
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('Application_Short_Name','Template Code');
COMMIT;
END;
/*Fourth Delete Data Definition*/
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('Application_Short_Name','Data Definition Code',);
COMMIT;
END;
On Tue, Dec 24, 2013 at 3:45 PM, Sumit Vishwas Nandapure <sumitn@evosys.co.in> wrote:
/*First Delete Concurrent Program*/
BEGIN
fnd_program.
delete_program (program_short_name => 'Concurrent_Program_Short_Name',
application => 'Application_Short_Name');
COMMIT;
END;
/*Second delete Executable*/
BEGIN
fnd_program.
delete_executable (executable_short_name => 'Concurrent_Program_Short_Name',
application => 'Application_Short_Name');
COMMIT;
END;
/*Third Delete Data Template*/
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('Application_Short_Name','Concurrent_Program_Short_Name');
COMMIT;
END;
/*Fourth Delete Data Definition*/
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('Application_Short_Name','Concurrent_Program_Short_Name',);
COMMIT;
END;
No comments:
Post a Comment