Deleting Concurrent program from backend

begin 

fnd_program.delete_program('SHORTNAME','APPLIC ATION'); 

fnd_program.delete_executable('SHORTNAME','APPLICATION'); 

COMMIT; 

end; 

Registering a View

Registering View

BEGIN

  fnd_dictionary_pkg.UploadView ('schemaname','ViewName','Description','Description',1);

  COMMIT;

END;

Registering column

BEGIN

  fnd_dictionary_pkg.UploadViewColumn ('schemaname','ViewName','COLUMN1'          , 1,1);

  fnd_dictionary_pkg.UploadViewColumn ('schemaname','ViewName','COLUMN2'          , 2,1);

END;

Removing view

begin

fnd_dictionary_pkg.RemoveView(  'schemaname', 'ViewName');

COMMIT;

END;