Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."UPDATE_PROCESSES" 

IS

proc_id NUMBER;

/******************************************************************************

   NAME:       DELETE_DO_NOT_RIPPLE

   PURPOSE:    TO DELETE ENTRIES FROM THE DO_NOT_RIPPLE TABLE WHEN A PACKAGE

               IS RELEASED

   REVISIONS:

   Ver        Date        Author           Description

   ---------  ----------  ---------------  ------------------------------------

   1.0        21/04/2006  Rupesh Solanki     1. Created this procedure.

   NOTES:

   Automatically available Auto Replace Keywords:

      Object Name:     DELETE_DO_NOT_RIPPLE

      Sysdate:         21/04/2006

      Date and Time:   21/04/2006, 3:21:55 PM, and 21/04/2006 3:21:55 PM

      Username:         (set in TOAD Options, Procedure Editor)

      Table Name:       (set in the "New PL/SQL Object" dialog)

******************************************************************************/

   CURSOR ripple_cur

   IS

      select proc_id,  proc_name, run_as, pkg_owner, is_interface from processes;

   ripple_rec   ripple_cur%ROWTYPE;

BEGIN

   OPEN ripple_cur;

   FETCH ripple_cur

    INTO ripple_rec;

   WHILE ripple_cur%FOUND

   LOOP

update deployment_manager.processes_config 

set proc_id = ripple_rec.proc_id

where pkg_health_tag = ripple_rec.proc_name

and cmd_interface IS NULL

and pkg_owner IS NULL

and is_interface IS NULL; 

      FETCH ripple_cur

       INTO ripple_rec;

   END LOOP;

END UPDATE_PROCESSES;

/