Subversion Repositories DevTools

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

BEGIN

    -- Clear Advisory Ripple Package
    DELETE FROM ADVISORY_RIPPLE
        WHERE PV_ID = nPvId
        AND RTAG_ID = nRtagId;

    /* LOG ACTION */
        Log_Action ( nPvId, 'clear_advisory_ripple', nUserId );
        
        /*Rebuild_Environment(nRtagId);*/

END Clear_Advisory_Ripple;
/