Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."REMOVE_PROJECT_VIEW_OWNER" (nProjId IN NUMBER,

	   	  		  						 			  nViewId IN NUMBER,

										 			  sUserIdList IN VARCHAR2,

										 			  nUserId IN NUMBER ) IS

GroupId NUMBER;													  

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

   NAME:       UPDATE_VIEW

   PURPOSE:    

   REVISIONS:

   Ver        Date        Author           		Description

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

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

   NOTES:

   Automatically available Auto Replace Keywords:

      Object Name:     UPDATE_VIEW

      Sysdate:         10/04/2006

      Date and Time:   10/04/2006, 1:55:19 PM, and 10/04/2006 1:55:19 PM

      Username:         (set in TOAD Options, Procedure Editor)

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

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

BEGIN

	 SELECT GROUP_EMAIL_ID into GroupId

	 FROM AUTOBUILD_FAILURE

	 WHERE PROJ_ID = nProjId

	 AND VIEW_ID = nViewId;

	 DELETE FROM MEMBERS_GROUP

	 WHERE GROUP_EMAIL_ID = GroupId

	 AND USER_ID IN (

	 SELECT * FROM THE ( SELECT CAST( IN_LIST_NUMBER( sUserIdList ) AS RELMGR_NUMBER_TAB_t ) FROM dual ) 

	 );

END REMOVE_PROJECT_VIEW_OWNER;

/