Subversion Repositories DevTools

CREATE FUNCTION "RELEASE_MANAGER"."GET_AUTOMATED_LABEL" ( nPvId IN NUMBER ) RETURN VARCHAR2 IS

/* ---------------------------------------------------------------------------
    Version: 3.0.0
   --------------------------------------------------------------------------- */

        sPkgName VARCHAR2(4000);
        sVext VARCHAR2(4000);

BEGIN

        -- Get package details
        SELECT pkg.PKG_NAME, pv.V_EXT INTO sPkgName, sVext
          FROM PACKAGE_VERSIONS pv,
                   PACKAGES pkg
         WHERE pv.PKG_ID = pkg.PKG_ID
           AND pv.PV_ID = nPvId;


        -- Generate Label for automated build
        RETURN UPPER( sPkgName ||'.'|| nPvId || sVext ||'.WIP' );

END GET_AUTOMATED_LABEL;
/