WebSVN – DevTools – Diff – /ManagerSuite/Release_Manager/trunk/web/database/Relman_export.sql

 --------------------------------------------------------
---  File created - Friday-September-23-2016
+--  File created - Thursday-July-26-2018
 --------------------------------------------------------
 --------------------------------------------------------
 --  DDL for Type RELMGR_NUMBER_TAB_T
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."MICROSOFTSEQDTPROPERTIES"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 50 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_ADDITIONAL_NOTES
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_ADDITIONAL_NOTES"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 37013 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_ADDITIONAL_NOTES"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 37313 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BMCON_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BMCON_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 261 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BMCON_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 401 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BM_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BM_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 6 NOCACHE  ORDER  NOCYCLE ;
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BSA_ID"  MINVALUE 8 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 48 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BUILD_INSTANCE
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 131745 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 254039 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_CR_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_CR_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 93290 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_CR_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 96052 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_DAEMON_INSTRUCTION_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 164895 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 169770 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_GBE_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_GBE_ID"  MINVALUE 40 MAXVALUE 9999999999999999999999990 INCREMENT BY 1 START WITH 1243 NOCACHE  ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_GBE_ID"  MINVALUE 40 MAXVALUE 9999999999999999999999990 INCREMENT BY 1 START WITH 1245 NOCACHE  ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_GROUP_EMAIL_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_GROUP_EMAIL_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1186 CACHE 20 NOORDER  NOCYCLE ;
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_MSG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 582 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_PKG_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PKG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 64249 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PKG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 66589 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_PROJ_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PROJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 881 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PROJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 941 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_PV_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1145669 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1259965 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_RCON_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RCON_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 30842 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RCON_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 33943 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_RELEASE_MOD
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RELEASE_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 160140 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RELEASE_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 342814 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_RTAG_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RTAG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 34669 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RTAG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 37029 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SCHEDULED_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SCHEDULED_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 29212 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SCHEDULED_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 29733 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SDKTAG_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDKTAG_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 723 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDKTAG_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 883 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SDK_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDK_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 143 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDK_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 163 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SESSION_NUM
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SESSION_NUM"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1069914 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SESSION_NUM"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1103850 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_TESTRUN_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_TESTRUN_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 762168 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_TESTRUN_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 2948677 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_UNIT_TESTS
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 363114 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 368596 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_USER_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_USER_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 3961 CACHE 20 ORDER  NOCYCLE ;
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VCS_TYPE"  MINVALUE 1 MAXVALUE 255 INCREMENT BY 1 START WITH 63 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_VIEW_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VIEW_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 10001 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VIEW_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 10221 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_VTREE_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VTREE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 31488 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VTREE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 33848 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Table ABT_ACTION_LOG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG"
 	"INSERTOR_ID" NUMBER,
 	"PKG_STATE" NUMBER,
 	"PKG_ID" NUMBER,
 	"DEPRECATED_STATE" NUMBER,
 	"PRODUCT_STATE" NUMBER,
-	"SDKTAG_ID" NUMBER
+	"SDKTAG_ID" NUMBER,
+	"RIPPLE_STOP" CHAR(1 BYTE),
+	"PERSIST_RIPPLE_STOP" CHAR(1 BYTE)
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  NOCOMPRESS LOGGING
   STORAGE(INITIAL 11534336 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   TABLESPACE "RELEASE_MANAGER_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONTENT"."PKG_ID" IS 'NotUsed any more. Was:Package that has been deprecated';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONTENT"."DEPRECATED_STATE" IS '6: Deprecated Package, 7: Deprecated Dependent';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONTENT"."SDKTAG_ID" IS 'Pkg imported via SDK';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONTENT"."RIPPLE_STOP" IS 's: Stop Ripple, w:Wait for Reset, g:GoBuild';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONTENT"."PERSIST_RIPPLE_STOP" IS 'Null:No';
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "RM_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "MS_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "DM_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "RELEASE_MANAGER_READ";
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "DEPLOYMENT_MANAGER";
   TABLESPACE "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
 --  DDL for Index INX_PACKAGES_V_NMM
 --------------------------------------------------------
-  CREATE INDEX "RELEASE_MANAGER"."INX_PACKAGES_V_NMM" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("V_NMM")
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."INX_PACKAGES_V_NMM" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("V_NMM", "PV_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
   STORAGE(INITIAL 9437184 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX" ;
   TABLESPACE "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
 --  DDL for Index INX_PACKAGES_V_MM
 --------------------------------------------------------
-  CREATE INDEX "RELEASE_MANAGER"."INX_PACKAGES_V_MM" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("V_MM")
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."INX_PACKAGES_V_MM" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("V_MM", "PV_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
   STORAGE(INITIAL 6291456 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX" ;
   STORAGE(INITIAL 100663296 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
+--  DDL for Index PACKAGE_PATCHES_INDEX1
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."PACKAGE_PATCHES_INDEX1" ON "RELEASE_MANAGER"."PACKAGE_PATCHES" ("PV_ID", "PATCH_ID")
+  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASE_MANAGER_DATA" ;
+--------------------------------------------------------
 --  DDL for Index INX_PACKAGE_DEPS_PV_ID
 --------------------------------------------------------
   CREATE INDEX "RELEASE_MANAGER"."INX_PACKAGE_DEPS_PV_ID" ON "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ("PV_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
 --  Ref Constraints for Table PACKAGE_VERSIONS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" ADD CONSTRAINT "PACKAGE_VERSIONS_VCS_TYPE" FOREIGN KEY ("VCS_TYPE_ID")
 	  REFERENCES "RELEASE_MANAGER"."VCS_TYPE" ("VCS_TYPE_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" ADD CONSTRAINT "PKG_NAME_EXISTS" FOREIGN KEY ("PKG_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGES" ("PKG_ID") ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" ADD FOREIGN KEY ("BS_ID")
 	  REFERENCES "RELEASE_MANAGER"."BUILD_STANDARDS" ("BS_ID") ENABLE;
 --------------------------------------------------------
 --  Ref Constraints for Table PEGGED_VERSIONS
 --------------------------------------------------------
       sarchiveserver    IN   VARCHAR2,
       smailserver       IN   VARCHAR2,
       smailsender       IN   VARCHAR2,
       faultmlist        IN   VARCHAR2,
       sdiskspace        IN   VARCHAR2,
-      ssbommanagement   IN   VARCHAR2
+      ssbommanagement   IN   VARCHAR2,
+      lxrserver         IN   VARCHAR2
    );
    /*================================================================================================*/
    PROCEDURE add_gbe_machtype (sgbevalue IN VARCHAR2, sgbeclass IN NUMBER);
    );
    PROCEDURE remove_code_review_url (
         ncrid           IN    NUMBER
    );
+   PROCEDURE SET_RIPPLE_STOP (
+    nPVID IN RELEASE_CONTENT.PV_ID%TYPE,
+    nRtagId IN RELEASE_CONTENT.RTAG_ID%TYPE,
+    nUserId IN NUMBER,
+    cMode IN CHAR
+);
 /*================================================================================================*/
 END pk_package;
+/
       dependenciesimportlist   IN   VARCHAR2,
       isrippled                IN   NUMBER,
       username                 IN   VARCHAR2
+   )
       RETURN NUMBER;
+FUNCTION auto_make_vcsrelease2 (
+      rtagid                   IN   NUMBER,
+      pkgname                  IN   VARCHAR2,
+      vext                     IN   VARCHAR2,
+      newpkgversion            IN   VARCHAR2,
+      vcstag                   IN   VARCHAR2,
+      dependenciesimportlist   IN   relmgr_varchar2_tab_t,
+      isrippled                IN   NUMBER,
+      username                 IN   VARCHAR2
+   )
+      RETURN NUMBER;
    PROCEDURE import_dependencies (
       pvid                     IN   NUMBER,
       dependenciesimportlist   IN   VARCHAR2,
       userid                   IN   NUMBER
    );
+    PROCEDURE import_dependencies2 (
+    pvid                     IN   NUMBER,
+    dependenciesimportlist   IN   relmgr_varchar2_tab_t,
+    userid                   IN   NUMBER
+    );
    FUNCTION return_last_package_version (pkgname IN VARCHAR2, rtagid IN NUMBER)
       RETURN VARCHAR2;
    FUNCTION return_wip (pkgname IN VARCHAR2, rtagid IN NUMBER)
       sarchiveserver    IN   VARCHAR2,
       smailserver       IN   VARCHAR2,
       smailsender       IN   VARCHAR2,
       faultmlist        IN   VARCHAR2,
       sdiskspace        IN   VARCHAR2,
-      ssbommanagement   IN   VARCHAR2
+      ssbommanagement   IN   VARCHAR2,
+      lxrserver         IN   VARCHAR2
+   )
    IS
    BEGIN
       UPDATE build_service_config
          SET config = sdatabaseserver
       WHERE service = 'DPKG_ARCHIVE DISK SPACE USED';
       UPDATE build_service_config
          SET config = ssbommanagement
       WHERE service = 'SBOM MANAGEMENT';
+      UPDATE build_service_config
+         SET config = lxrserver
+      WHERE service = 'LXR SERVER';
    END;
 /*-------------------------------------------------------------------------------------------------------*/
    BEGIN
       DELETE FROM code_review_url
       WHERE cr_id = ncrid;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
+PROCEDURE
+        SET_RIPPLE_STOP (
+        nPVID IN RELEASE_CONTENT.PV_ID%TYPE,
+        nRtagId IN RELEASE_CONTENT.RTAG_ID%TYPE,
+        nUserId IN NUMBER,
+        cMode IN CHAR
+    ) IS
+    ReleaseLocation VARCHAR2(4000);
+    sMode VARCHAR(100);
+    cData CHAR;
+BEGIN
+    IF (nPVID IS NULL) THEN
+        RAISE_APPLICATION_ERROR (-20000, 'PvId not set' );
+    END IF;
+    IF (nRtagId IS NULL) THEN
+        RAISE_APPLICATION_ERROR (-20001, 'rTagId not set' );
+    END IF;
+    cData := cMode;
+    If cMode = 's' THEN
+        sMode := 'ripple_stop';
+    ELSIF cMode = 'w' THEN
+        sMode := 'ripple_wait';
+    ELSIF cMode = 'r' THEN
+        sMode := 'ripple_removed';
+        cData := NULL;
+    ELSIF cMode = 'g' THEN
+        sMode := 'ripple_resume';
+    ELSE
+       RAISE_APPLICATION_ERROR (-20002, 'Unknown mode:' || cMode );
+    END IF;
+    -- Update the value
+    UPDATE RELEASE_CONTENT
+    SET RIPPLE_STOP = cData
+    WHERE RTAG_ID = nRtagId
+    AND PV_ID = nPVID;
+    -- Mark Release Changed for build
+    PK_RELEASE.SET_RELEASE_MODIFIED(nRtagId);
+    /* LOG ACTION */
+    SELECT proj.PROJ_NAME ||' / '|| rt.RTAG_NAME INTO ReleaseLocation
+    FROM PROJECTS proj,RELEASE_TAGS rt
+    WHERE rt.PROJ_ID = proj.PROJ_ID
+    AND rt.RTAG_ID = nRtagId;
+    Log_Action ( nPVID, sMode, nUserId, 'Location: '|| ReleaseLocation);
+END SET_RIPPLE_STOP;
 END pk_package;
+/
   GRANT EXECUTE ON "RELEASE_MANAGER"."PK_PACKAGE" TO "DEPLOYMENT_MANAGER";
         IF default_advisory_ripple = 'Y' THEN
           INSERT INTO ADVISORY_RIPPLE ( RTAG_ID, PV_ID ) VALUES (RtagId, newPvId);
           -- Log_Action ( newPvId, 'action', UserId, 'Set default advisory ripple' );
         END IF;
-        -- Mark Release as chnaged
+        -- Mark Release as changed
         SET_RELEASE_MODIFIED(RtagId);
         RUN_POST_ACTIONS(newPvId, RtagId);
           /* LOG ACTION */
          SELECT proj.PROJ_NAME ||' / '|| rt.RTAG_NAME INTO ReleaseLocation
 PROCEDURE REPLACE_PACKAGE ( newPvId IN NUMBER, oldPvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER ) IS
    ReleaseLocation VARCHAR2(4000);
    sPkgVersion VARCHAR2(4000);
    nSdkTag NUMBER;
+   cPersistRippleStop CHAR;
+   cRippleStop CHAR;
 BEGIN
-   -- Trap SDK Replacement
+   -- Extract essential information
-   -- This is a last ditch check. The application should not allow this condition to happen
-      SELECT SDKTAG_ID INTO nSdkTag FROM RELEASE_CONTENT
+      SELECT SDKTAG_ID, PERSIST_RIPPLE_STOP INTO nSdkTag, cPersistRippleStop FROM RELEASE_CONTENT
       WHERE rtag_id = RtagId
        AND pv_id = oldPvId;
+   -- Trap SDK Replacement
+   -- This is a last ditch check. The application should not allow this condition to happen
      If nSdkTag IS NOT NULL  THEN
        raise_application_error (-20000, 'Attempt to replace a package provided by an SDK.');
      END IF;
+   -- Determine new value for ripple_stop
+   cRippleStop := NULL;
+   IF cPersistRippleStop is NOT NULL THEN
+      cRippleStop := 's';
+   END IF;
    -- Replace Package
     UPDATE RELEASE_CONTENT
        SET pv_id = newPvId,
            insert_stamp = Ora_Sysdate,
            insertor_id = UserId,
-         product_state = NULL
+           product_state = NULL,
+           ripple_stop = cRippleStop
      WHERE rtag_id = RtagId
        AND pv_id = oldPvId;
    -- update the pegging table
    UPDATE PEGGED_VERSIONS
 --   Used by the Automated Build System to release a new package
 -- Returns:
 --    Use application errors to indicate programming errors
 --    Use negative return codes to indicate correctable user problems
 --    Positive return code is the new PVID of the package
+--
+-- Note: Being deprecated in favor of auto_make_vcsrelease2
   FUNCTION auto_make_vcsrelease (
       rtagid                   IN   NUMBER,
       pkgname                  IN   VARCHAR2,
       vext                     IN   VARCHAR2,
       newpkgversion            IN   VARCHAR2,
          END LOOP;
       END;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
+-- Use:
+--   Used by the Automated Build System to release a new package
+-- Returns:
+--    Use application errors to indicate programming errors
+--    Use negative return codes to indicate correctable user problems
+--    Positive return code is the new PVID of the package
+  FUNCTION auto_make_vcsrelease2 (
+      rtagid                   IN   NUMBER,
+      pkgname                  IN   VARCHAR2,
+      vext                     IN   VARCHAR2,
+      newpkgversion            IN   VARCHAR2,
+      vcstag                   IN   VARCHAR2,
+      dependenciesimportlist   IN   relmgr_varchar2_tab_t,
+      isrippled                IN   NUMBER,
+      username                 IN   VARCHAR2
+   )
+      RETURN NUMBER
+   IS
+      pkgid                           NUMBER;
+      pvid                            NUMBER                        := 0;
+      userid                          NUMBER;
+      dlocked                         VARCHAR2 (20)                 := NULL;
+      clonefrompvid                   NUMBER;
+      ssv_mm                          package_versions.v_mm%TYPE;
+      ssv_nmm                         package_versions.v_nmm%TYPE;
+      ssv_ext                         package_versions.v_ext%TYPE;
+      return_package_not_found        NUMBER                        := -1;
+      return_package_already_exists   NUMBER                        := -2;
+      return_not_approved             NUMBER                        := -3;
+      return_migrated_pkg             NUMBER                        := -4;
+      return_svn_path_changed         NUMBER                        := -5;
+      x_vcstypeid                     NUMBER;
+      x_tag                           VARCHAR2(32);
+      x_label                         VARCHAR2(60);
+      x_srcpath                       VARCHAR2(2000);
+      p_srcpath                       VARCHAR2(2000);
+      -- Regular expression constituents
+      Token         VARCHAR2(16) := '([^:]+)';  -- a token is anything except a ':' character
+      Seperator     VARCHAR2(4)  := '::';       -- tokens will be seperated by '::'
+      BOL           VARCHAR2(4)  := '^';
+      Anything      VARCHAR2(4)  := '.*';
+      ReplaceToken1 VARCHAR2(4)  := '\1';
+      ReplaceToken2 VARCHAR2(4)  := '\2';
+      ReplaceToken3 VARCHAR2(4)  := '\3';
+      iprev_modifier_id               NUMBER;
+   BEGIN
+      /*--------------- Business Rules Here -------------------*/
+      IF (rtagid IS NULL)
+      THEN
+         raise_application_error (-20000, 'RtagId must be supplied.');
+      END IF;
+      IF (pkgname IS NULL)
+      THEN
+         raise_application_error (-20000, 'PkgName must be supplied.');
+      END IF;
+      IF (newpkgversion IS NULL)
+      THEN
+         raise_application_error (-20000, 'PkgVersion must be supplied.');
+      END IF;
+      IF (vcstag IS NULL)
+      THEN
+         raise_application_error (-20000, 'PkgVcsTag must be supplied.');
+      END IF;
+      IF (isrippled IS NULL) OR (isrippled < 0) OR (isrippled > 1)
+      THEN
+         raise_application_error (-20000, 'IsRippled must be set to 1 (Is rippled build) or 0 (Is planned build).');
+      END IF;
+      IF (username IS NULL)
+      THEN
+         raise_application_error (-20000, 'UserName must be supplied.');
+      END IF;
+      -- Parse the PkgVcsTag
+      -- Sets up
+      --   x_tag, x_label, x_srcpath
+       BEGIN
+          -- Extract the first token - this will be the short tag name for the VCS (eg. 'CC', 'SVN', etc)
+          x_tag := REGEXP_REPLACE(vcstag, BOL || Token || Seperator || Anything, ReplaceToken1);
+          -- Decode the short tag
+          CASE x_tag
+             WHEN 'CC' THEN
+                -- extract the 2nd and 3rd tokens, those being the source path and label respectively
+                x_srcpath := REGEXP_REPLACE(vcstag, BOL || Token || Seperator || Token || Seperator || Anything, ReplaceToken2);
+                x_label   := REGEXP_REPLACE(vcstag, BOL || Token || Seperator || Token || Seperator || Token, ReplaceToken3);
+                -- NOTE: if reg-expr parsing/replacement fails, the x_... variable may receive the entire input string (vcstag), so
+                -- check for that error as well as the obvious zero-length string conditions.
+                IF LENGTH(x_srcpath) = 0 OR LENGTH(x_label) = 0 OR x_srcpath = vcstag OR x_label = vcstag THEN
+                   raise_application_error (-20000, 'VCS Tag contains insufficient or malformed data!');
+                END IF;
+                IF isSVNbyName(pkgname) > 0 THEN
+                    -- Don't allow migrated packages to be released from a CC label
+                    return return_migrated_pkg;
+                END IF;
+             WHEN 'SVN' THEN
+                -- extract the 2nd token, that being the subversion tag
+                x_srcpath := REGEXP_REPLACE(vcstag, BOL || Token || Seperator || Token || Seperator || Anything, ReplaceToken2);
+                x_label   := REGEXP_REPLACE(vcstag, BOL || Token || Seperator || Token || Seperator || Token, ReplaceToken3);
+                -- NOTE: if reg-expr parsing/replacement fails, the x_... variable may receive the entire input string (vcstag), so
+                -- check for that error as well as the obvious zero-length string conditions.
+                IF LENGTH(x_srcpath) = 0 OR LENGTH(x_label) = 0 OR x_srcpath = vcstag OR x_label = vcstag THEN
+                   raise_application_error (-20000, 'VCS Tag contains insufficient or malformed data!');
+                END IF;
+             WHEN 'UC' THEN
+                -- nothing to extract, just assign defaults
+                x_srcpath := REGEXP_REPLACE(vcstag, BOL || Token || Seperator || Token || Seperator || Anything, ReplaceToken2);
+                x_label   := 'N/A';
+             ELSE
+                raise_application_error (-20000, 'Unrecognised VCS Tag!');
+          END CASE;
+       END;
+      -- Get the VCS_TYPE_ID for the version control system.
+      BEGIN
+         SELECT vt.vcs_type_id
+         INTO x_vcstypeid
+         FROM VCS_TYPE vt
+         WHERE vt.tag = x_tag;
+         EXCEPTION
+            WHEN NO_DATA_FOUND THEN
+               raise_application_error (-20000, 'Database is missing a version control system tag (' || x_tag || ')!' );
+      END;
+      -- Get user_id
+      BEGIN
+         SELECT usr.user_id
+           INTO userid
+           FROM users usr
+          WHERE UPPER (usr.user_name) = UPPER (username)
+            AND usr.is_disabled IS NULL;
+      EXCEPTION
+         WHEN NO_DATA_FOUND
+         THEN
+            raise_application_error (-20000, 'UserName: ' || username || ' is not valid or disabled.' );
+      END;
+/*-------------------------------------------------------*/
+      -- Create package if necessary
+      IF isrippled = 1
+      THEN
+         /* Ripple Build */
+         BEGIN
+            -- Make sure that package does not exist
+            SELECT pv.pv_id
+              INTO pvid
+              FROM package_versions pv, PACKAGES pkg
+             WHERE pv.pkg_id = pkg.pkg_id
+               AND pkg.pkg_name = pkgname
+               AND pv.pkg_version = newpkgversion;
+         EXCEPTION
+            WHEN NO_DATA_FOUND
+            THEN
+               pvid := 0;
+         END;
+         IF (pvid = 0)
+         THEN
+            -- Split current version in parts
+            split_version (newpkgversion, ssv_mm, ssv_nmm, ssv_ext);
+            BEGIN
+               -- Find package to be replaced with the ripple package
+               IF NVL (vext, '|LINK_A_NULL|') = NVL (ssv_ext, '|LINK_A_NULL|')
+               THEN
+                  SELECT pv.pv_id, pv.src_path
+                    INTO clonefrompvid, p_srcpath
+                    FROM PACKAGES pkg, package_versions pv,
+                         release_content rc
+                   WHERE rc.pv_id = pv.pv_id
+                     AND pv.pkg_id = pkg.pkg_id
+                     AND rc.rtag_id = rtagid
+                     AND pkg.pkg_name = pkgname
+                     AND NVL (pv.v_ext, '|LINK_A_NULL|') = NVL (ssv_ext, '|LINK_A_NULL|');
+               ELSE
+                  SELECT pv.pv_id, pv.src_path
+                    INTO clonefrompvid, p_srcpath
+                    FROM PACKAGES pkg, package_versions pv,
+                         release_content rc
+                   WHERE rc.pv_id = pv.pv_id
+                     AND pv.pkg_id = pkg.pkg_id
+                     AND rc.rtag_id = rtagid
+                     AND pkg.pkg_name = pkgname
+                     AND NVL (pv.v_ext, '|LINK_A_NULL|') = NVL (vext, '|LINK_A_NULL|');
+               END IF;
+            EXCEPTION
+               WHEN NO_DATA_FOUND
+               THEN
+                  raise_application_error
+                                        (-20000,
+                                            'Cannot get CloneFromPvId. VExt='
+                                         || vext
+                                         || ', RtagId='
+                                         || rtagid
+                                         || ', PkgName='
+                                         || pkgname
+                                         || ', SSV_EXT='
+                                         || ssv_ext
+                                        );
+            END;
+            IF NVL (vext, '|LINK_A_NULL|') = NVL (ssv_ext, '|LINK_A_NULL|')
+            THEN
+               -- Create package
+               seed_package_names_versions (pkgname,
+                                            newpkgversion,
+                                            userid,
+                                            pvid,
+                                            clonefrompvid
+                                           );
+            ELSE
+               -- Create package (now both the same)
+               seed_package_names_versions (pkgname,
+                                             newpkgversion,
+                                             userid,
+                                             pvid,
+                                             clonefrompvid
+                                            );
+            END IF;
+            -- Update Package reason for release
+            UPDATE package_versions pv
+               SET pv.comments = 'Rippled Build.',
+                   pv.build_type = 'Y'
+             WHERE pv.pv_id = pvid;
+         ELSE
+            -- Package already exists, it was built previously, and has just been re-built again probably due to the
+            -- fact that the archive was cleaned of the original build artifacts at some point, and those artifacts
+            -- are now needed once more. As such, we need to ensure that a new release note generation occurs so
+            -- reset the package_versions[pvid].release_notes_info field to enable that to happen.
+            UPDATE package_versions pv
+               SET pv.release_notes_info = null,
+                   pv.modified_stamp = ora_sysdatetime
+             WHERE pv.pv_id = pvid;
+            --DEVI-066151
+            log_action (pvid, 'package_rebuilt', userid, 'Package Re-built...');
+            RETURN return_package_already_exists;
+         END IF;
+      ELSE
+         /* Auto build from Pending area */
+         -- Find package in pending area
+         BEGIN
+            SELECT pv.pv_id, pv.dlocked, pv.src_path
+              INTO pvid, dlocked, p_srcpath
+              FROM planned pl, package_versions pv, PACKAGES pkg
+             WHERE pl.pv_id = pv.pv_id
+               AND pv.pkg_id = pkg.pkg_id
+               AND pl.rtag_id = rtagid
+               AND pkg.pkg_name = pkgname
+               AND pv.dlocked = 'A'
+               AND NVL (pv.v_ext, '|LINK_A_NULL|') = NVL (vext, '|LINK_A_NULL|')
+               AND rownum = 1
+             ORDER BY pv.modified_stamp;
+         EXCEPTION
+            WHEN NO_DATA_FOUND
+            THEN
+               pvid := 0;
+         END;
+         IF (pvid = 0)
+         THEN
+            -- Package does not exist in pending area, hence report it
+            RETURN return_package_not_found;
+         ELSIF (dlocked != 'A')
+         THEN
+            -- Package is not approved for autobuild
+            RETURN return_not_approved;
+         END IF;
+      END IF;
+      -- Ensure Source Path does not change
+      -- Do not expect the SVN development branch to change
+      -- From the previous package
+      IF ( x_tag = 'SVN' AND p_srcpath != x_srcpath )
+      THEN
+        return return_svn_path_changed;
+      END IF;
+      BEGIN
+         -- Import Dependencies
+         import_dependencies2 (pvid, dependenciesimportlist, userid);
+      END;
+      BEGIN
+         -- Split current version in parts
+         split_version (newpkgversion, ssv_mm, ssv_nmm, ssv_ext);
+         -- Update Package Details
+         UPDATE package_versions pv
+            SET pv.pkg_version = newpkgversion,
+                pv.v_ext = ssv_ext,
+                pv.v_mm = ssv_mm,
+                pv.v_nmm = ssv_nmm,
+                pv.src_path = x_srcpath,
+                pv.pkg_label = x_label,
+                pv.vcs_type_id = x_vcstypeid
+          WHERE pv.pv_id = pvid;
+      EXCEPTION
+         WHEN DUP_VAL_ON_INDEX
+         THEN
+            -- Package already exists, hence cannot be used for ripple build
+            RETURN return_package_already_exists;
+      END;
+      -- Update the is_autobuildable
+      UPDATE package_versions
+         SET is_autobuildable = 'Y'
+       WHERE pv_id = pvid;
+      -- DEVI-063601
+      -- For planned builds the modifier_id shouldn't be set to buildadm.
+      -- To ensure this the modifier_id is obtained so it can be restored after
+      -- the function pk_environment.auto_make_release is called.
+      -- This function calls, change_state, which sets the modifier_id to the
+      -- specified userid, which for auto builds is buildadm.
+      SELECT pv.modifier_id INTO iprev_modifier_id
+      FROM package_versions pv WHERE pv.pv_id = pvid;
+      -- Now release package
+      pk_environment.auto_make_release (pvid,
+                                        rtagid,
+                                        userid,
+                                        vext,
+                                        ssv_ext,
+                                        clonefrompvid
+                                       );
+      -- DEVI-063601
+      -- if it is a planned build then restore the modifier_id to the previous modifier
+      UPDATE package_versions pv SET pv.modifier_id = iprev_modifier_id
+      WHERE pv.pv_id = pvid;
+      --Now clean the PLANNED_VERSIONS table
+      SELECT pkg_id
+        INTO pkgid
+        FROM PACKAGES
+       WHERE pkg_name = pkgname;
+      DELETE FROM planned_versions
+            WHERE pkg_id = pkgid AND pkg_version = newpkgversion;
+      RETURN pvid;
+   END;
+/*-------------------------------------------------------------------------------------------------------*/
+--  import package dependencies (2nd attenpt)
+--  Package dependencies are an array of strings. Each string is of the form
+--    'PkgName','PkgVersion','PkgType'
+--  The use of an array of package dependencies allows packages with very long
+--  list of dependencies. More than can be put in to a VARCHAR2
+--
+   PROCEDURE import_dependencies2 (
+      pvid                     IN   NUMBER,
+      dependenciesimportlist   IN   relmgr_varchar2_tab_t,
+      userid                   IN   NUMBER
+   )
+   IS
+      TYPE tdictionary IS TABLE OF VARCHAR2 (4000) INDEX BY VARCHAR2 (4000);
+      seperator         VARCHAR2 (2)           := '||';
+      pkgname           VARCHAR2 (4000);
+      pkgversion        VARCHAR2 (4000);
+      pkgtype           VARCHAR2  (50);
+      pkgid             NUMBER;
+      vext              VARCHAR2 (4000);
+      dpvid             NUMBER;
+      cbuildtypes       tdictionary;
+      dependencyrow     NUMBER;
+      sdependency       VARCHAR2 (4000);
+      citemcollection   relmgr_varchar2_tab_t;
+      CURSOR curbuildtype
+      IS
+         SELECT dpv.pkg_id || seperator || dpv.v_ext AS pkgid_ext,
+                dep.build_type
+           FROM package_dependencies dep, package_versions dpv
+          WHERE dep.pv_id = pvid AND dep.dpv_id = dpv.pv_id;
+      recbuildtype      curbuildtype%ROWTYPE;
+   BEGIN
+      -- Get Current Dependencies
+      OPEN curbuildtype;
+      FETCH curbuildtype
+       INTO recbuildtype;
+      WHILE curbuildtype%FOUND
+      LOOP
+         cbuildtypes (recbuildtype.pkgid_ext) := recbuildtype.build_type;
+         FETCH curbuildtype INTO recbuildtype;
+      END LOOP;
+      CLOSE curbuildtype;
+      BEGIN
+         -- Remove old dependencies
+         DELETE FROM package_dependencies dep
+               WHERE dep.pv_id = pvid;
+         -- Loop through dependencies
+         FOR dependencyrow IN 1 .. dependenciesimportlist.COUNT
+         LOOP
+            -- Extract pkg_name and pkg_version and type(optional)
+            sdependency := dependenciesimportlist (dependencyrow);
+            sdependency := REPLACE(sdependency, '''');
+            sdependency := REPLACE(sdependency, '"');
+            -- Remove empty dependency
+            IF LENGTH(sdependency) > 0 THEN
+              citemcollection := in_list_varchar2 (sdependency, ',');
+              IF citemcollection.COUNT  < 2
+              THEN
+                raise_application_error
+                  (-20000,
+                      'Dependency ['
+                   || sdependency
+                   || '] must have at least two ; separated fields!'
+                  );
+              END IF;
+              pkgname := citemcollection(1);
+              pkgversion := citemcollection(2);
+              IF citemcollection.COUNT >= 3
+              THEN
+                pkgtype := citemcollection(3);
+              ELSE
+                pkgtype := NULL;
+              END IF;
+              -- Dependency must exits to be linked against
+              BEGIN
+                 SELECT pv.pv_id, pv.pkg_id, pv.v_ext
+                   INTO dpvid, pkgid, vext
+                   FROM package_versions pv, PACKAGES pkg
+                  WHERE pv.pkg_id = pkg.pkg_id
+                    AND pkg.pkg_name = pkgname
+                    AND pv.pkg_version = pkgversion;
+              EXCEPTION
+                 WHEN NO_DATA_FOUND
+                 THEN
+                    raise_application_error
+                                    (-20000,
+                                        'Dependency ['
+                                     || pkgname
+                                     || ' '
+                                     || pkgversion
+                                     || '] does not exist yet and cannot be used!'
+                                    );
+              END;
+              -- Get Build Type (i.e. BuildPackageArchive or LinkPackageArchive)
+              IF pkgtype IS NULL
+              THEN
+                BEGIN
+                   pkgtype := cbuildtypes (pkgid || seperator || vext);
+                   IF pkgtype IS NULL
+                   THEN
+                      -- Set build type to LinkPackageArchive by default
+                      pkgtype := 'L';
+                   END IF;
+                EXCEPTION
+                   WHEN NO_DATA_FOUND
+                   THEN
+                      pkgtype := 'L';
+                END;
+              END IF;
+              -- Limit to known types
+              IF UPPER(pkgtype) like('B%') THEN
+                pkgtype := 'B';
+              ELSE
+                pkgtype := 'L';
+              END IF;
+              -- Insert Dependencies
+              update_package_dependency (pvid,
+                                         pkgname,
+                                         pkgversion,
+                                         pkgtype,
+                                         userid,
+                                        );
+            END IF;
+         END LOOP;
+      END;
+   END;
+/*-------------------------------------------------------------------------------------------------------*/
    FUNCTION return_last_package_version (pkgname IN VARCHAR2, rtagid IN NUMBER)
       RETURN VARCHAR2
    IS
       pkgversion   VARCHAR2 (4000);
    BEGIN
    || 0 -> NOT FOUND
    || 1 -> MAJOR
    || 2 -> MINOR MINOR
    */
    INSERT INTO temp_env_states
+   (
-      SELECT DISTINCT nnsession_num AS session_num, 1 AS level_num,
+      SELECT nnsession_num AS session_num,
+AS level_num,
+        rd.pv_id,
-                      err.pv_id, errpkg.pkg_id, errpkg.v_ext,
+        rd.pkg_id,
+        rd.v_ext,
-                      DECODE (frc.v_nmm,
+        DECODE (rd.v_nmm,
-                              NULL, 0,
+                    NULL, 0,
-                              errpv.v_nmm, DECODE (frc.v_mm,
+                    pv2.v_nmm, DECODE (rd.v_mm,
-                                                   errpv.v_mm, 0,
+                                       pv2.v_mm, 0,
-                                                  ),
+                                       ),
-                             ) AS MESSAGE,
+              ) AS MESSAGE,
+        rd.build_type
+from (
+      SELECT DISTINCT err.pv_id, errpkg.pkg_id, errpkg.v_ext,
-                             frc.build_type
+                      frc.build_type,
+                      frc.v_nmm,
+                      frc.v_mm,
+                      errpv.pv_id as errpv_id
                  FROM (
                        /* Full Release Contents used for reference*/
                         SELECT rel.rtag_id, rpv.pv_id, rpv.pkg_id,
                                 NVL (rpv.v_ext, '|LINK_A_NULL|') AS v_ext,
                                 rpv.pkg_version, rpv.v_nmm, rpv.v_mm,
                       package_versions errpv
                 WHERE err.err_dpv = errpv.pv_id
                   AND errpv.pkg_id = frc.pkg_id(+)
                   AND NVL (errpv.v_ext, '|LINK_A_NULL|') = frc.v_ext(+)
                   AND err.pv_id = errpkg.pv_id
-                  AND NVL(frc.IsAvr,0) = 0;
+                  AND NVL(frc.IsAvr,0) = 0
+                  ) rd,
+                  package_versions pv2
+                  where rd.errpv_id = pv2.PV_ID
+                  );
 END level_one_conflicts;
+/
 --------------------------------------------------------
 --  DDL for Procedure LOCK_PACKAGE
     DELETE FROM temp_env_states WHERE session_num = sessionNum;
     DELETE FROM TEMP_ENV_DEPS WHERE session_num = sessionNum;
     -- Flag Packages with New Patches Available
+        -- Temp deleted 28-Mar-2017
+    -- Reason: It takes a very long time and we dont use patches any more
-    Check_New_Patches ( NNrtag_id );
+    -- Check_New_Patches ( NNrtag_id );
 	Clean_Do_Not_Ripple( NNrtag_id );
 	/* Circular Dependency Flag */
     -- UnRipple Package
     delete from do_not_ripple where rtag_id=nRtagId and pv_id=nPvId;
     INSERT INTO DO_NOT_RIPPLE ( RTAG_ID, PV_ID, ROOT_PV_ID, ROOT_CAUSE, ROOT_FILE ) values (nRtagId, nPvId, nrootCausePvId, srootCause, srootFile);
+    -- Do not log if RootCause is -2
+    IF nrootCausePvId IS NOT NULL AND nrootCausePvId = -2 THEN
+      RETURN;
+    END IF;
     /* LOG ACTION */
    SELECT proj.PROJ_NAME ||' / '|| rt.RTAG_NAME INTO ReleaseLocation
               FROM PROJECTS proj,
                    RELEASE_TAGS rt
              WHERE rt.RTAG_ID = nRtagId

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/web/database/Relman_export.sql – Rev 6031 → 6600