Tuesday, 3 March 2015

How to Delete Concurrent Program and Executable

Delete Concurrent Program 

Execute FND_PROGRAM.DELETE_PROGRAM('V_PROG_SHORT_NAME', 'V_APPL_SHORT_NAME');
 Commit;


Delete Concurrent Executable:


Execute FND_PROGRAM.DELETE_EXECUTABLE('V_PROG_SHORT_NAME', 'V_APPL_SHORT_NAME');

  Commit; 


Deleting the Template:
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('
V_APPL_SHORT_NAME','V_PROG_SHORT_NAME');
END;



Deleting the Data Definition:
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('
V_APPL_SHORT_NAME','V_PROG_SHORT_NAME');
END;

Note: 
V_APPL_SHORT_NAME = application short name
V_PROG_SHORT_NAME = concurrent program short name

No comments:

Post a Comment