Amazon

Code To Delete AOL Objects like Concurrent Program,executable,Data Definition, Template

/*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;

No comments:

Post a Comment