Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."UPDATE_MISC_VIEW" IS
/******************************************************************************
   NAME:       UPDATE_MISC_VIEW
   PURPOSE:    

   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.0        16/03/2007          1. Created this procedure.

   NOTES:

   Automatically available Auto Replace Keywords:
      Object Name:     UPDATE_MISC_VIEW
      Sysdate:         16/03/2007
      Date and Time:   16/03/2007, 8:56:29 AM, and 16/03/2007 8:56:29 AM
      Username:         (set in TOAD Options, Procedure Editor)
      Table Name:       (set in the "New PL/SQL Object" dialog)

******************************************************************************/
   CURSOR view_cur /*Create a record set to store the ripple data*/
   IS
         SELECT pkg.pkg_id, rc.base_view_id 
         FROM package_versions pv, packages pkg, release_content rc
         where rc.rtag_id = 2362
         and rc.pv_id = pv.pv_id
         and pv.pkg_id = pkg.pkg_id;
   view_rec   view_cur%ROWTYPE;



BEGIN
   OPEN view_cur;

   FETCH view_cur
    INTO view_rec;

   WHILE view_cur%FOUND
   LOOP

           
           update release_content
           set base_view_id = view_rec.base_view_id
           where rtag_id = 8027
           and pv_id IN 
           (
                select pv.pv_id from release_content rc, package_versions pv
                where rc.rtag_id = 8027
                and pv.pv_id = rc.pv_id
                and pv.pkg_id = view_rec.pkg_id 
          
           );
          
           

           
           
           
           
           

   FETCH view_cur
                 INTO view_rec;
   END LOOP;     





END UPDATE_MISC_VIEW; /
 
CREATE PROCEDURE "RELEASE_MANAGER"."UPDATE_PACKAGE_DEPENDENCY" ( NNpv_id IN NUMBER,
                                                        SSdep_name IN PACKAGES.pkg_name%TYPE,
                                                        SSdep_version IN PACKAGE_VERSIONS.pkg_version%TYPE,
                                                        CCbuild_type IN PACKAGE_DEPENDENCIES.build_type%TYPE,
                                                        NNuser_id IN NUMBER,
                                                        NNdelete_old_dependency IN NUMBER
                                                       ) IS
/* ---------------------------------------------------------------------------
    Version: 3.3
   --------------------------------------------------------------------------- */

    retPV_ID NUMBER;
    SSV_EXT PACKAGE_VERSIONS.v_ext%TYPE;
        DepIsPatch      PACKAGE_VERSIONS.is_patch%TYPE;
    PvIsPatch   PACKAGE_VERSIONS.is_patch%TYPE;
    NNpkg_id NUMBER;
    NNdpkg_id NUMBER;

BEGIN
    --- Seed database with package_name and version if required ---
    Seed_Package_Names_Versions ( SSdep_name, SSdep_version, NNuser_id, retPV_ID );

    -- get v_ext,pkg_id of current dependency
    SELECT v_ext, pkg_id, is_patch INTO SSV_EXT, NNdpkg_id, DepIsPatch
      FROM PACKAGE_VERSIONS
     WHERE pv_id = retPV_ID;

    -- get pkg_id of parent package
    SELECT pkg_id, is_patch INTO NNpkg_id, PvIsPatch
      FROM PACKAGE_VERSIONS
     WHERE pv_id = NNpv_id;


        IF ( (PvIsPatch IS NULL) AND (DepIsPatch IS NULL) ) OR
        ( (PvIsPatch IS NOT NULL) )THEN

            IF NNdelete_old_dependency = 1 THEN
                /* Used for CUSTOM dependency add/edit */

                --- Remove old dependency ---
            IF (PvIsPatch IS NULL) THEN
                -- Do it for Packages
                        DELETE FROM PACKAGE_DEPENDENCIES
                         WHERE ( pv_id, dpv_id, pkg_id, dpkg_id, build_type, display_order ) IN
                            (
                            SELECT dep.*
                              FROM PACKAGE_DEPENDENCIES dep,
                                   PACKAGE_VERSIONS dpv,
                                   PACKAGE_VERSIONS pv
                             WHERE dep.dpv_id = dpv.pv_id
                               AND dep.pv_id = NNpv_id
                               AND pv.pv_id = retPV_ID
                               AND dpv.pkg_id = pv.pkg_id
                               AND NVL(dpv.v_ext, '|LINK_A_NULL|') = NVL(SSV_EXT, '|LINK_A_NULL|')
                            );
            ELSE
                -- Do it for Patches
                DELETE FROM PACKAGE_DEPENDENCIES
                         WHERE ( pv_id, dpv_id, pkg_id, dpkg_id, build_type, display_order ) IN
                            (
                            SELECT dep.*
                              FROM PACKAGE_DEPENDENCIES dep
                             WHERE dep.dpv_id = retPV_ID
                               AND dep.pv_id = NNpv_id
                            );
                        END IF;

            END IF;

            /* NOTE: for JATS, ANTS dependency update, it is expected that all dependencies are removed. */

            --- Add new dependency ---
            INSERT INTO PACKAGE_DEPENDENCIES ( pv_id, dpv_id, pkg_id, dpkg_id, build_type )
            VALUES ( NNpv_id, retPV_ID, NNpkg_id, NNdpkg_id, CCbuild_type );

        END IF;

END Update_Package_Dependency;
/