Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."REMOVE_PACKAGE_INTEREST" (nProjId IN PROJECTS.PROJ_ID%TYPE,
                                                                                                        nPkgId IN PACKAGES.PKG_ID%TYPE,
                                                                                                        nUserId IN NUMBER
                                                                                                        ) IS

/******************************************************************************
   NAME:       REMOVE_PACKAGE_INTEREST
   PURPOSE:    To remove interest in a given package per project

   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.0        12/05/2006  Rupesh Solanki      1. Created this procedure.

   NOTES:

   Automatically available Auto Replace Keywords:
      Object Name:     REMOVE_PACKAGE_INTEREST
      Sysdate:         12/05/2006
      Date and Time:   12/05/2006, 11:28:50 AM, and 12/05/2006 11:28:50 AM
      Username:         (set in TOAD Options, Procedure Editor)
      Table Name:       (set in the "New PL/SQL Object" dialog)

******************************************************************************/
BEGIN

         --Delete from PACKAGE_INTEREST
         DELETE FROM PACKAGE_INTEREST
         WHERE PROJ_ID = nProjId
         AND PKG_ID = nPkgId
         AND USER_ID = nUserId;
         
END REMOVE_PACKAGE_INTEREST;
/