Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."CHANGE_PACKAGE_STATE" ( nPvId IN PACKAGE_VERSIONS.PV_ID%TYPE,
                                                                                         nRtagId IN RELEASE_TAGS.RTAG_ID%TYPE ) IS
/* ---------------------------------------------------------------------------
    Version: 4.0
   --------------------------------------------------------------------------- */

BEGIN

    -- Unlock Package
    UPDATE RELEASE_CONTENT rc SET
        rc.PKG_STATE = 0
    WHERE rc.PV_ID = nPvId
        AND rc.RTAG_ID = nRtagId;

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

END Change_Package_State;
/