Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."SWITCH_REPRODUCIBLE_PACKAGE" (nPvId IN NUMBER, nUserId IN NUMBER)IS
Auto CHAR;
/******************************************************************************
   NAME:       SWITCH_REPRODUCIBLE_PACKAGE
   PURPOSE:    

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

   NOTES:

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

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

         SELECT IS_AUTOBUILDABLE into Auto
         FROM PACKAGE_VERSIONS 
         WHERE PV_ID = nPvId;

         IF Auto = 'N' Then
         
                UPDATE PACKAGE_VERSIONS
                SET IS_AUTOBUILDABLE = 'Y'
                WHERE PV_ID = nPvId;
         
         
                /* LOG ACTION */
                Log_Action ( nPvId, 'reproducible_package', nUserId );   
         
         Else
                 
                 UPDATE PACKAGE_VERSIONS
                 SET IS_AUTOBUILDABLE = 'N'
                 WHERE PV_ID = nPvId;
                 
         
                 /* LOG ACTION */
                 Log_Action ( nPvId, 'unreproducible_package', nUserId );        
         
         End If;
         
         

        




END SWITCH_REPRODUCIBLE_PACKAGE;
/