Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."REMOVE_RUNTIME" ( nPvId IN PACKAGE_VERSIONS.PV_ID%TYPE,
                                                                                         nRuntimeId IN RUNTIME_DEPENDENCIES.RTD_ID%TYPE,
                                             nUserId IN NUMBER ) IS
/* ---------------------------------------------------------------------------
    Version: 3.0
   --------------------------------------------------------------------------- */

   RuntimeDependency VARCHAR2(4000);

BEGIN

        -- Get Runtime dependency
    SELECT pkg.PKG_NAME ||' '|| pv.PKG_VERSION  INTO RuntimeDependency
          FROM RUNTIME_DEPENDENCIES rtd,
                   PACKAGES pkg,
               PACKAGE_VERSIONS pv
         WHERE rtd.PV_ID = nPvId
           AND pv.PKG_ID = pkg.PKG_ID
           AND rtd.RTD_ID = pv.PV_ID
           AND rtd.RTD_ID = nRuntimeId;


        -- Delete Document
    DELETE
      FROM RUNTIME_DEPENDENCIES rtd
     WHERE rtd.PV_ID = nPvId
       AND rtd.RTD_ID = nRuntimeId;


    /* LOG ACTION */
        Log_Action ( nPvId, 'runtime_remove', nUserId,
                             'Runtime package: '|| RuntimeDependency );


END Remove_Runtime;
/