Wednesday, July 3, 2024

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

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;

No comments:

Post a Comment

EBS : Package Development Process

====================== Package Specification ================================== CREATE OR REPLACE PACKAGE xx_emp_package IS     PROCEDURE lo...