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;
/