Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."UNLOCK_PACKAGE" ( nPvId IN PACKAGE_VERSIONS.PV_ID%TYPE,
                                                                                         nUserId IN NUMBER ) IS
/* ---------------------------------------------------------------------------
    Author: Rupesh Solanki
        
        Version: 4.0
   --------------------------------------------------------------------------- */
   STATE CHAR;
   
BEGIN
         
        SELECT DLOCKED INTO STATE
        FROM PACKAGE_VERSIONS
        WHERE PV_ID = nPvId; 

        IF STATE = 'A' THEN --It was made official for autobuilds
                -- Unlock Package
                UPDATE PACKAGE_VERSIONS pv SET
                pv.DLOCKED = 'P'
                WHERE pv.PV_ID = nPvId; 
        ELSE
                -- Unlock Package
                UPDATE PACKAGE_VERSIONS pv SET
                pv.DLOCKED = 'N'
                WHERE pv.PV_ID = nPvId; 
        
        END IF;    

    /* LOG ACTION */
        Log_Action ( nPvId, 'unlock_package', nUserId );

END Unlock_Package;
/