Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."CLONED_PACKAGE_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 distinct proc_id, prod_id from deployment_manager.processes_config;

   ripple_rec   ripple_cur%ROWTYPE;

BEGIN

   OPEN ripple_cur;

   FETCH ripple_cur

    INTO ripple_rec;

   WHILE ripple_cur%FOUND

   LOOP

insert into package_processes (PROC_ID, PV_ID) 

values( ripple_rec.proc_id, ripple_rec.prod_id);

      FETCH ripple_cur

       INTO ripple_rec;

   END LOOP;

END CLONED_PACKAGE_PROCESSES;

/