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

 --------------------------------------------------------
---  File created - Tuesday-April-09-2019
+--  File created - Wednesday-May-08-2019
 --------------------------------------------------------
 --------------------------------------------------------
 --  DDL for Type RELMGR_NUMBER_TAB_T
 --------------------------------------------------------
    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 240932 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 252972 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 95272 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_CR_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 95472 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 179295 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 180075 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 1245 NOCACHE  ORDER  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 68063 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PKG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 68263 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 1041 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 1238088 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1244788 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 36790 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RCON_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 37110 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 298803 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RELEASE_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 309203 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 39631 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RTAG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 39911 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 30074 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SCHEDULED_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 30134 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 1563 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDKTAG_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1623 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 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 1110364 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SESSION_NUM"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1113544 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 2141643 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_TESTRUN_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 2577583 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 375956 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 376316 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_VIEW_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 10341 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 36310 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VTREE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 36590 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Table ABT_ACTION_LOG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG"
 --------------------------------------------------------
 --  DDL for View ENVIRONMENT_VIEW
 --------------------------------------------------------
   CREATE OR REPLACE FORCE VIEW "RELEASE_MANAGER"."ENVIRONMENT_VIEW" ("ENV_AREA", "PV_ID", "RTAG_ID", "VIEW_ID", "PKG_STATE", "DEPRECATED_STATE", "INSERTOR_ID", "INSERT_STAMP", "OPERATION") AS
+  WITH building as (
+            SELECT unique rl.CURRENT_PV_ID as pv_id, rc.RTAG_ID
+            FROM RELEASE_CONFIG rc, RELEASE_TAGS rt, RUN_LEVEL rl
+            WHERE rt.RTAG_ID = rc.RTAG_ID
+            AND rc.bmcon_id is not null
+            AND rt.OFFICIAL in ( 'N', 'R', 'C')
+            AND rl.RCON_ID(+) = rc.RCON_ID
+            AND rl.CURRENT_PKG_ID_BEING_BUILT is not null
+            AND NVL(rl.PAUSE,0) < 2
+        ), scheduled as (
+            SELECT pv_id, RTAG_ID from daemon_instructions di
+            WHERE di.op_code = 2
+        ) , buildFail as (
+            SELECT pv_id, root_pv_id, RTAG_ID from do_not_ripple dnr
+        ) , baseData as (
-  SELECT 2 AS ENV_AREA,
+            SELECT 2 AS ENV_AREA,
-    rc.PV_ID,
+                rc.PV_ID,
-    rc.RTAG_ID,
+                rc.RTAG_ID,
-    rc.BASE_VIEW_ID AS VIEW_ID,
+                rc.BASE_VIEW_ID AS VIEW_ID,
-    rc.PKG_STATE,
+                rc.PKG_STATE,
- rc.DEPRECATED_STATE,
+                rc.DEPRECATED_STATE,
-    rc.INSERTOR_ID,
+                rc.INSERTOR_ID,
-    rc.INSERT_STAMP,
+                rc.INSERT_STAMP,
-    ' ' AS OPERATION
+                ' ' AS OPERATION
-  FROM RELEASE_CONTENT rc
+              FROM RELEASE_CONTENT rc
-UNION
+            UNION
-SELECT 0 AS ENV_AREA,
+            SELECT 0 AS ENV_AREA,
-    wip.PV_ID,
+                wip.PV_ID,
-    wip.RTAG_ID,
+                wip.RTAG_ID,
-    wip.VIEW_ID,
+                wip.VIEW_ID,
-    NULL AS PKG_STATE,
+                NULL AS PKG_STATE,
- NULL AS DEPRECATED_STATE,
+             NULL AS DEPRECATED_STATE,
-    NULL AS INSERTOR_ID,
+                NULL AS INSERTOR_ID,
-    NULL AS INSERT_STAMP,
+                NULL AS INSERT_STAMP,
-    ' ' AS OPERATION
+                ' ' AS OPERATION
-  FROM WORK_IN_PROGRESS wip
+              FROM WORK_IN_PROGRESS wip
-UNION
+            UNION
+            SELECT 1 AS ENV_AREA,
+                pl.PV_ID,
+                pl.RTAG_ID,
+                pl.VIEW_ID,
+                NULL AS PKG_STATE,
+             NULL AS DEPRECATED_STATE,
+                NULL AS INSERTOR_ID,
+                NULL AS INSERT_STAMP,
+                pl.operation
+            FROM PLANNED pl
+        )
-SELECT 1 AS ENV_AREA,
+SELECT unique rc.ENV_AREA,
-    pl.PV_ID,
+    rc.PV_ID,
-    pl.RTAG_ID,
+    rc.RTAG_ID,
-    pl.VIEW_ID,
+    rc.VIEW_ID,
+    Case
+        When sdi.pv_id is not null then 14
+        When bb.pv_id is not null then 15
+        When bf.pv_id is not null AND bf.root_pv_id is NULL then 16
+        When bf.pv_id is not null AND bf.root_pv_id is NOT NULL then  17
+        When rc.pkg_state is not null then rc.pkg_state
+        Else 0
-    NULL AS PKG_STATE,
+    End as pkg_state,
- NULL AS DEPRECATED_STATE,
+    rc.DEPRECATED_STATE,
-    NULL AS INSERTOR_ID,
+    rc.INSERTOR_ID,
-    NULL AS INSERT_STAMP,
+    rc.INSERT_STAMP,
-    pl.operation
+    rc.OPERATION
-FROM PLANNED pl
+  FROM baseData rc,
+       scheduled sdi,
+       buildFail bf,
+       building bb
+  WHERE sdi.pv_id(+)    = rc.pv_id  AND sdi.rtag_id(+) = rc.rtag_id
+        AND bf.pv_id(+) = rc.pv_id  AND bf.rtag_id(+) = rc.rtag_id
+        AND bb.pv_id(+) = rc.pv_id  AND bb.rtag_id(+) = rc.rtag_id
+;
   GRANT SELECT ON "RELEASE_MANAGER"."ENVIRONMENT_VIEW" TO "RM_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."ENVIRONMENT_VIEW" TO "MS_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."ENVIRONMENT_VIEW" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
---  DDL for View RM_PKG_ISSUES_ID
---------------------------------------------------------
-  CREATE OR REPLACE FORCE VIEW "RELEASE_MANAGER"."RM_PKG_ISSUES_ID" ("ISS_ID", "PKG_VERSION") AS
-  SELECT DISTINCT ISS_ID, PKG_VERSION FROM RM_PACKAGE_ISSUES WHERE ISS_ID IS NOT NULL
-;
-  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES_ID" TO "RM_READONLY";
-  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES_ID" TO "MS_READONLY";
-  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES_ID" TO "RELEASE_MANAGER_READ";
---------------------------------------------------------
 --  DDL for Index PK_LICENCES
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."PK_LICENCES" ON "RELEASE_MANAGER"."LICENCES" ("LICENCE")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   TABLESPACE "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
 --  DDL for Index PACKAGE_VERSIONS_RNOTE
 --------------------------------------------------------
-  CREATE INDEX "RELEASE_MANAGER"."PACKAGE_VERSIONS_RNOTE" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("RELEASE_NOTES_INFO")
+  CREATE INDEX "RELEASE_MANAGER"."PACKAGE_VERSIONS_RNOTE" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("RELEASE_NOTES_INFO", "DLOCKED", "MODIFIED_STAMP")
   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" ;
       nRtag_id IN NUMBER,
       nInst_id IN OUT NUMBER,
       nOp_code IN OUT NUMBER,
       nPv_id OUT NUMBER,
       nUser_id OUT NUMBER,
-      nInProgress OUT NUMBER
+      nInProgress OUT NUMBER,
+      bExpired IN NUMBER default 1
    ) RETURN NUMBER;
    /*================================================================================================*/
    PROCEDURE cleanup_stranded_daemon_insts;
    /*================================================================================================*/
    PROCEDURE insert_daemon_inst(
       nOp_code IN NUMBER,
 	PROCEDURE MAKE_RELEASE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
 	PROCEDURE MAKE_UNRELEASE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
 	PROCEDURE MAKE_PENDING ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
-	PROCEDURE MAKE_APPROVED ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
+	PROCEDURE MAKE_APPROVED ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER, sched in VARCHAR2 default NULL );
 	PROCEDURE MAKE_REJECT ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
 	PROCEDURE APPROVE_MERGE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
 	PROCEDURE CHANGE_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER, NewViewId IN NUMBER );
    -- the instruction ID obtained from the previous call (the 1st call should use 0)
    -- Can be called repeatedly to get a full list of all instructions of a specific op-code value for a release,
    -- by passing back in an op-code value of 0 or higher (use -1 if no op-code filtering is needed)
    -- Returns 1 if a record was found, else 0.
    --
+   -- The default value of bExpired (True) will return instructions that have exceeded the scheduled time
+  --  A false value will reverse the operation and return instrcutions that have not yet expired
+   --
    FUNCTION get_daemon_inst(
       nRtag_id IN NUMBER,
       nInst_id IN OUT NUMBER,
       nOp_code IN OUT NUMBER,
       nPv_id OUT NUMBER,
       nUser_id OUT NUMBER,
-      nInProgress OUT NUMBER
+      nInProgress OUT NUMBER,
+      bExpired IN NUMBER
    ) RETURN NUMBER
    IS
       CURSOR daemon_inst_cur IS
          SELECT di.daemon_instructions_id, di.op_code, di.pv_id ,di.user_id, di.in_progress
            FROM daemon_instructions di
           WHERE di.rtag_id = nRtag_id
             AND di.daemon_instructions_id > nInst_id
-            AND di.scheduled_datetime <= ora_sysdatetime
+            AND (( (bExpired != 0 ) AND (di.scheduled_datetime <= ora_sysdatetime)) OR ( (bExpired = 0) AND (di.scheduled_datetime > ora_sysdatetime) ))
             AND ((nOp_code = -1) OR (nOp_code = di.op_code))
             AND rownum <= 1
        ORDER BY di.daemon_instructions_id;
       daemon_inst_rec   daemon_inst_cur%ROWTYPE;
      END IF;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
    -- DEVI-45275 added the return of the new "operation" column in the recordset.
-   PROCEDURE get_environment_items (
+PROCEDURE get_environment_items (
      viewtype         IN      NUMBER,
      userid           IN      NUMBER,
      rtagid           IN      NUMBER,
      sviewidshowlist  IN      VARCHAR2,
      ntruerecordcount OUT     NUMBER,
          ORDER BY UPPER (ord.view_name), UPPER (ord.pkg_name);
      END IF;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
-   PROCEDURE get_released_items (
+  PROCEDURE get_released_items (
      viewtype         IN      NUMBER,
      userid           IN      NUMBER,
      rtagid           IN      NUMBER,
      sviewidshowlist  IN      VARCHAR2,
      ntruerecordcount OUT     NUMBER,
      recordset        OUT     typecur
+   )
    IS
    BEGIN
      -- Get true record count because views can give false count
-     SELECT COUNT (rc.pv_id)
+     SELECT COUNT (pl.pv_id)
       INTO ntruerecordcount
-      FROM release_content rc
+      FROM environment_view pl
-      WHERE rc.rtag_id = rtagid;
+      WHERE pl.rtag_id = rtagid;
      IF viewtype = 1
      THEN
        /*--- GUEST VIEW ---*/
        OPEN recordset FOR
                  SELECT DISTINCT vi.view_id, vi.view_name,
                              TO_NUMBER (NULL) AS pkg_state,
                              TO_NUMBER (NULL) AS deprecated_state,
                              TO_NUMBER (NULL) AS pv_id,
                              NULL AS pkg_name, NULL AS pkg_version,
-                             NULL AS dlocked, NULL AS pv_description
+                             NULL AS dlocked, NULL AS pv_description,
+                             rel.operation
-                         FROM release_content rel, views vi
+                         FROM environment_view rel, views vi
-                        WHERE rel.base_view_id = vi.view_id
+                        WHERE rel.view_id = vi.view_id
+                          AND rel.env_area = 2
                           AND rtag_id = rtagid
-                          AND rel.base_view_id NOT IN (
+                          AND rel.view_id NOT IN (
                                SELECT *
                                  FROM THE
                                        (SELECT CAST
                                                (in_list_number
                                                   (sviewidshowlist
+                                               )
                                          FROM DUAL
                                        ))
                  UNION
                  /* Base Views expanded */
-                 SELECT vi.view_id, vi.view_name, rel.pkg_state,
+                 SELECT vi.view_id, vi.view_name,
+                     rel.pkg_state,
                       rel.deprecated_state, pv.pv_id, pkg.pkg_name,
-                      pv.pkg_version, pv.dlocked, pv.pv_description
+                      pv.pkg_version, pv.dlocked, pv.pv_description,
+                      rel.operation
-                  FROM release_content rel,
+                  FROM environment_view rel,
                       PACKAGES pkg,
                       package_versions pv,
                       views vi
                   WHERE pv.pkg_id = pkg.pkg_id
                    AND rel.pv_id = pv.pv_id
+                   AND rel.env_area = 2
-                   AND rel.base_view_id = vi.view_id
+                   AND rel.view_id = vi.view_id
-                   AND rel.base_view_id IN (
+                   AND rel.view_id IN (
                         SELECT *
                           FROM THE
                                 (SELECT CAST
                                         (in_list_number
                                                (sviewidshowlist) AS relmgr_number_tab_t
                  SELECT DISTINCT vi.view_id, vi.view_name,
                              TO_NUMBER (NULL) AS pkg_state,
                              TO_NUMBER (NULL) AS deprecated_state,
                              TO_NUMBER (NULL) AS pv_id,
                              NULL AS pkg_name, NULL AS pkg_version,
-                             NULL AS dlocked, NULL AS pv_description
+                             NULL AS dlocked, NULL AS pv_description,
+                             rel.operation
-                         FROM release_content rel,
+                         FROM environment_view rel,
                              view_settings vs,
                              views vi
-                        WHERE rel.base_view_id = vi.view_id
+                        WHERE rel.view_id = vi.view_id
+                          AND rel.env_area = 2
-                          AND vs.view_id = rel.base_view_id
+                          AND vs.view_id = rel.view_id
                           AND vs.user_id = userid
                           AND rtag_id = rtagid
-                          AND rel.base_view_id NOT IN (
+                          AND rel.view_id NOT IN (
                                SELECT *
                                  FROM THE
                                        (SELECT CAST
                                                (in_list_number
                                                   (sviewidshowlist
+                                               )
                                          FROM DUAL
                                        ))
                  UNION
                  /* Base Views expanded */
-                 SELECT vi.view_id, vi.view_name, rel.pkg_state,
+                 SELECT vi.view_id, vi.view_name,
+                        rel.pkg_state,
                       rel.deprecated_state, pv.pv_id, pkg.pkg_name,
-                      pv.pkg_version, pv.dlocked, pv.pv_description
+                      pv.pkg_version, pv.dlocked, pv.pv_description,
+                      rel.operation
-                  FROM release_content rel,
+                  FROM environment_view rel,
                       PACKAGES pkg,
                       package_versions pv,
                       views vi,
                       view_settings vs
                   WHERE pv.pkg_id = pkg.pkg_id
                    AND rel.pv_id = pv.pv_id
-                   AND rel.base_view_id = vi.view_id
+                   AND rel.view_id = vi.view_id
+                   AND rel.env_area = 2
                    AND vs.view_id = vi.view_id
                    AND vs.user_id = userid
-                   AND rel.base_view_id IN (
+                   AND rel.view_id IN (
                         SELECT *
                           FROM THE
                                 (SELECT CAST
                                         (in_list_number
                                                (sviewidshowlist) AS relmgr_number_tab_t
                  SELECT vi.view_id, vi.view_name,
                       TO_NUMBER (NULL) AS pkg_state,
                       TO_NUMBER (NULL) AS deprecated_state,
                       TO_NUMBER (NULL) AS pv_id, NULL AS pkg_name,
                       NULL AS pkg_version, NULL AS dlocked,
-                      NULL AS pv_description
+                      NULL AS pv_description,
+                      rel.operation
                   FROM view_settings vs,
                       view_def vd,
                       views vi,
-                      release_content rel,
+                      environment_view rel,
                       package_versions pv
                   WHERE vs.view_id = vi.view_id
+                   AND rel.env_area = 2
                    AND rel.pv_id = pv.pv_id
                    AND vd.pkg_id = pv.pkg_id
                    AND vd.view_id = vi.view_id
                    AND vi.base_view = 'N'
                    AND rel.rtag_id = rtagid
+                                        )
                                   FROM DUAL
                                 ))
                  UNION
                  /* Private Views expanded */
-                 SELECT vi.view_id, vi.view_name, rel.pkg_state,
+                 SELECT vi.view_id, vi.view_name,
+                      rel.pkg_state,
                       rel.deprecated_state, pv.pv_id, pkg.pkg_name,
-                      pv.pkg_version, pv.dlocked, pv.pv_description
+                      pv.pkg_version, pv.dlocked, pv.pv_description,
+                      rel.operation
                   FROM users usr,
                       view_settings vs,
                       view_def vd,
                       views vi,
-                      release_content rel,
+                      environment_view rel,
                       PACKAGES pkg,
                       package_versions pv
                   WHERE vs.user_id = usr.user_id
                    AND vs.view_id = vi.view_id
+                   AND rel.env_area = 2
                    AND vd.view_id = vi.view_id
                    AND pv.pkg_id = pkg.pkg_id
                    AND rel.pv_id = pv.pv_id
                    AND rel.rtag_id = rtagid
                    AND vd.pkg_id = pkg.pkg_id
                                 ))
                    AND usr.user_id = userid) ord
          ORDER BY UPPER (ord.view_name), UPPER (ord.pkg_name);
      END IF;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
    PROCEDURE get_work_in_progress_items (
      viewtype         IN      NUMBER,
      userid           IN      NUMBER,
    END;
 /*-------------------------------------------------------------------------------------------------------*/
    -- DEVI-45275 added the return of the new "operation" column in the recordset.
-   PROCEDURE get_pending_items (
+PROCEDURE get_pending_items (
      viewtype         IN      NUMBER,
      userid           IN      NUMBER,
      rtagid           IN      NUMBER,
      sviewidshowlist  IN      VARCHAR2,
      ntruerecordcount OUT     NUMBER,
    IS
    BEGIN
      -- Get true record count because views can give false count
      SELECT COUNT (pl.pv_id)
       INTO ntruerecordcount
-      FROM planned pl
+      FROM environment_view pl
       WHERE pl.rtag_id = rtagid;
      IF viewtype = 1
      THEN
        /*--- GUEST VIEW ---*/
                              TO_NUMBER (NULL) AS deprecated_state,
                              TO_NUMBER (NULL) AS pv_id,
                              NULL AS pkg_name, NULL AS pkg_version,
                              NULL AS dlocked, NULL AS pv_description,
                              rel.operation
-                         FROM planned rel, views vi
+                         FROM environment_view rel, views vi
                         WHERE rel.view_id = vi.view_id
+                          AND rel.env_area = 1
                           AND rtag_id = rtagid
                           AND rel.view_id NOT IN (
                                SELECT *
                                  FROM THE
                                        (SELECT CAST
+                                               )
                                          FROM DUAL
                                        ))
                  UNION
                  /* Base Views expanded */
-                 SELECT vi.view_id, vi.view_name, 0 AS pkg_state,
+                 SELECT vi.view_id, vi.view_name,
-                      --rel.pkg_state,
+                     rel.pkg_state,
-                      TO_NUMBER (NULL) AS deprecated_state, pv.pv_id,
+                      rel.deprecated_state, pv.pv_id, pkg.pkg_name,
-                      pkg.pkg_name, pv.pkg_version, pv.dlocked,
+                      pv.pkg_version, pv.dlocked, pv.pv_description,
-                      pv.pv_description,
                       rel.operation
-                  FROM planned rel,
+                  FROM environment_view rel,
                       PACKAGES pkg,
                       package_versions pv,
                       views vi
                   WHERE pv.pkg_id = pkg.pkg_id
                    AND rel.pv_id = pv.pv_id
+                   AND rel.env_area = 1
                    AND rel.view_id = vi.view_id
                    AND rel.view_id IN (
                         SELECT *
                           FROM THE
                                 (SELECT CAST
                              TO_NUMBER (NULL) AS deprecated_state,
                              TO_NUMBER (NULL) AS pv_id,
                              NULL AS pkg_name, NULL AS pkg_version,
                              NULL AS dlocked, NULL AS pv_description,
                              rel.operation
+                         FROM environment_view rel,
-                         FROM planned rel, view_settings vs, views vi
+                             view_settings vs,
+                             views vi
                         WHERE rel.view_id = vi.view_id
+                          AND rel.env_area = 1
                           AND vs.view_id = rel.view_id
                           AND vs.user_id = userid
                           AND rtag_id = rtagid
                           AND rel.view_id NOT IN (
                                SELECT *
+                                               )
                                          FROM DUAL
                                        ))
                  UNION
                  /* Base Views expanded */
-                 SELECT vi.view_id, vi.view_name, 0 AS pkg_state,
+                 SELECT vi.view_id, vi.view_name,
-                      --rel.pkg_state,
+                        rel.pkg_state,
-                      TO_NUMBER (NULL) AS deprecated_state, pv.pv_id,
+                      rel.deprecated_state, pv.pv_id, pkg.pkg_name,
-                      pkg.pkg_name, pv.pkg_version, pv.dlocked,
+                      pv.pkg_version, pv.dlocked, pv.pv_description,
-                      pv.pv_description,
                       rel.operation
-                  FROM planned rel,
+                  FROM environment_view rel,
                       PACKAGES pkg,
                       package_versions pv,
                       views vi,
                       view_settings vs
                   WHERE pv.pkg_id = pkg.pkg_id
                    AND rel.pv_id = pv.pv_id
                    AND rel.view_id = vi.view_id
+                   AND rel.env_area = 1
                    AND vs.view_id = vi.view_id
                    AND vs.user_id = userid
                    AND rel.view_id IN (
                         SELECT *
                           FROM THE
                       NULL AS pv_description,
                       rel.operation
                   FROM view_settings vs,
                       view_def vd,
                       views vi,
-                      planned rel,
+                      environment_view rel,
                       package_versions pv
                   WHERE vs.view_id = vi.view_id
+                   AND rel.env_area = 1
                    AND rel.pv_id = pv.pv_id
                    AND vd.pkg_id = pv.pkg_id
                    AND vd.view_id = vi.view_id
                    AND vi.base_view = 'N'
                    AND rel.rtag_id = rtagid
+                                        )
                                   FROM DUAL
                                 ))
                  UNION
                  /* Private Views expanded */
-                 SELECT vi.view_id, vi.view_name, 0 AS pkg_state,
+                 SELECT vi.view_id, vi.view_name,
-                      --rel.pkg_state,
+                      rel.pkg_state,
-                      TO_NUMBER (NULL) AS deprecated_state, pv.pv_id,
+                      rel.deprecated_state, pv.pv_id, pkg.pkg_name,
-                      pkg.pkg_name, pv.pkg_version, pv.dlocked,
+                      pv.pkg_version, pv.dlocked, pv.pv_description,
-                      pv.pv_description,
                       rel.operation
                   FROM users usr,
                       view_settings vs,
                       view_def vd,
                       views vi,
-                      planned rel,
+                      environment_view rel,
                       PACKAGES pkg,
                       package_versions pv
                   WHERE vs.user_id = usr.user_id
                    AND vs.view_id = vi.view_id
+                   AND rel.env_area = 1
                    AND vd.view_id = vi.view_id
                    AND pv.pkg_id = pkg.pkg_id
                    AND rel.pv_id = pv.pv_id
                    AND rel.rtag_id = rtagid
                    AND vd.pkg_id = pkg.pkg_id
                                 ))
                    AND usr.user_id = userid) ord
          ORDER BY UPPER (ord.view_name), UPPER (ord.pkg_name);
      END IF;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
    PROCEDURE get_view_content (
      rtagid     IN      NUMBER,
      viewid     IN      NUMBER,
                      ) AS pkg_state,
                 rel.deprecated_state, pv.pv_id, pkg.pkg_name,
                 pv.pkg_version, pv.dlocked, pv.pv_description,
                 pv.build_type,
                 rel.operation
-            FROM environment_view rel, PACKAGES pkg, package_versions pv
+            FROM environment_view rel,
+                PACKAGES pkg,
+                package_versions pv
             WHERE pv.pkg_id = pkg.pkg_id
              AND rel.pv_id = pv.pv_id
              AND rel.view_id = viewid
              AND rel.rtag_id = rtagid
          ORDER BY UPPER (pkg.pkg_name);
      -- Log
      --log_action (pvid, 'action', userid, 'End of Make Package Pending...');
    END;
 /*-------------------------------------------------------------------------------------------------------*/
-   PROCEDURE make_approved (pvid IN NUMBER, rtagid IN NUMBER, userid IN NUMBER)
+   PROCEDURE make_approved (pvid IN NUMBER, rtagid IN NUMBER, userid IN NUMBER, sched in VARCHAR2)
    IS
    BEGIN
      -- Log
      -- log_action (pvid, 'action', userid, 'Start of Package Pending Approval...' );
      -- Change package state
      pk_package.change_state (pvid, 'A', userid);
      -- Flag Release has changed for the purposes of building
      PK_RELEASE.SET_RELEASE_MODIFIED(rtagid);
+     PK_BUILDAPI.del_daemon_inst_by_rtag_pvid(2, rtagid, pvid);
+     IF sched IS NOT NULL THEN
+        -- Schedule a future build of the package
+        PK_BUILDAPI.insert_daemon_inst( 2, rtagid, pvid, TO_DATE( sched, 'YYYY-MM-DD HH24:MI:SS'), 0, ORA_SYSDATETIME, userid);
+        log_action (pvid, 'approve_scheduled', userid, 'Scheduled build:' || sched);
+     END IF;
      -- Log
      -- log_action (pvid, 'action', userid, 'End of Package Pending Approval...');
    END;
      THEN
      -- Change package state
      pk_package.change_state (pvid, 'R', userid);
      -- Add package to new area
      pk_work_in_progress.add_package (pvid, viewid, rtagid, userid);
+     PK_BUILDAPI.del_daemon_inst_by_rtag_pvid(2, rtagid, pvid);
      ELSE
       log_action (pvid, 'action', userid, 'Rejected Package Merge');
      END IF;
      -- Log
        AND pl.PV_ID = PvId;
     RETURN ReturnValue;
 END;
 /*-------------------------------------------------------------------------------------------------------*/
-PROCEDURE GET_VIEW_CONTENT ( RtagId IN NUMBER, ViewId IN NUMBER, RecordSet OUT typeCur ) IS
+PROCEDURE GET_VIEW_CONTENT ( RtagId IN NUMBER, ViewId IN NUMBER, RecordSet OUT typeCur ) as
+begin
-    IsBaseView CHAR(1);
+OPEN RecordSet FOR
+-- Determine the PV_ID and OPERATION for the required VIEW
-BEGIN
+With selectedPv as (
+    SELECT pv.pv_id, rel.operation, 0 as pkg_state
+      FROM PLANNED rel, package_versions pv, VIEW_DEF vd,  VIEWS vi
-    -- Check if the view is BASE VIEW
+      WHERE rel.pv_id = pv.pv_id
-    SELECT vi.BASE_VIEW INTO IsBaseView
+      AND vd.PKG_ID = pv.PKG_ID
-      FROM VIEWS vi
+      AND vd.VIEW_ID = ViewId
+      AND rel.RTAG_ID = RtagId
-     WHERE vi.VIEW_ID = ViewId;
+      AND vi.VIEW_ID = ViewId
-    IF (IsBaseView IN ('Y', 'S')) THEN
+      AND vi.BASE_VIEW NOT IN ('Y', 'S')
+    UNION
-        -- Get Base view content
+     SELECT rel.pv_id, rel.operation, 0 as pkg_state
-        OPEN RecordSet FOR
+     FROM PLANNED rel, VIEWS vi
-        SELECT 0 AS PKG_STATE,
+     WHERE rel.VIEW_ID = ViewId
-               NULL AS DEPRECATED_STATE,
+     AND rel.RTAG_ID = RtagId
-               pv.pv_id,
+     AND vi.VIEW_ID = ViewId
-               pkg.pkg_name,
+     AND vi.BASE_VIEW IN ('Y', 'S')
+),
-               pv.pkg_version,
+-- Determine packages that are building
+building as (
-               pv.dlocked,
+    SELECT unique rl.CURRENT_PV_ID as pv_id, rc.RTAG_ID
+    FROM RELEASE_CONFIG rc, RELEASE_TAGS rt, RUN_LEVEL rl
-               pv.pv_description,
+    WHERE rt.RTAG_ID = rc.RTAG_ID
-               pv.BUILD_TYPE,
+    AND rc.RTAG_ID = RtagId
-               rel.operation
+    AND rc.bmcon_id is not null
-          FROM PLANNED rel,
+    AND rt.OFFICIAL in ( 'N', 'R', 'C')
-               packages pkg,
+    AND rl.RCON_ID(+) = rc.RCON_ID
-               package_versions pv
+    AND rl.CURRENT_PKG_ID_BEING_BUILT is not null
-         WHERE pv.pkg_id = pkg.pkg_id
+    AND NVL(rl.PAUSE,0) < 2
+),
+-- Determine Packages that are scheduled to build
+scheduled as (
-           AND rel.pv_id = pv.pv_id
+    SELECT pv_id, RTAG_ID from daemon_instructions di
-           AND rel.VIEW_ID = ViewId
+    WHERE di.op_code = 2
-           AND rel.RTAG_ID = RtagId
+    AND RTAG_ID = RtagId
+) ,
+-- Determine Packages that failed to build or have been excluded
+buildFail as (
+    SELECT pv_id, root_pv_id, RTAG_ID from do_not_ripple dnr
-         ORDER BY UPPER(pkg.PKG_NAME);
+    WHERE RTAG_ID = RtagId
+)
+-- Generate the complete dataset from the fragments
-    ELSE
+  SELECT Case
+                    When sdi.pv_id is not null then 14
-        -- Get non base view content
+                    When bb.pv_id is not null then 15
+                    When bf.pv_id is not null AND bf.root_pv_id is NULL then 16
+                    When bf.pv_id is not null AND bf.root_pv_id is NOT NULL then  17
+                    When rel.pkg_state is not null then rel.pkg_state
-        OPEN RecordSet FOR
+                    Else 0
-        SELECT 0 AS PKG_STATE,
+                End as pkg_state,
                NULL AS DEPRECATED_STATE,
                pv.pv_id,
                pkg.pkg_name,
                pv.pkg_version,
                pv.dlocked,
                pv.pv_description,
                pv.BUILD_TYPE,
                rel.operation
-          FROM PLANNED rel,
+          FROM selectedPv rel,
                packages pkg,
                package_versions pv,
+               scheduled sdi,
+               buildFail bf,
-               VIEW_DEF vd
+               building bb
          WHERE pv.pkg_id = pkg.pkg_id
            AND rel.pv_id = pv.pv_id
-           AND rel.RTAG_ID = RtagId
+           AND sdi.pv_id(+) = rel.pv_id
-           AND vd.VIEW_ID = ViewId
+           AND bf.pv_id(+) = rel.pv_id
-           AND vd.PKG_ID = pv.PKG_ID
+           AND bb.pv_id(+) = rel.pv_id
-         ORDER BY UPPER(pkg.PKG_NAME);
+         ORDER BY UPPER(pkg.PKG_NAME), pv.pv_id;
-    END IF;
 END;
 /*-------------------------------------------------------------------------------------------------------*/
 PROCEDURE CHANGE_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER, NewViewId IN NUMBER ) IS
 BEGIN
   END IF;
    -- check that the target release's daemons are all paused before we allow an import operation
    OPEN curTgtReleaseConfigs;
    FETCH curtgtReleaseConfigs INTO recTgtReleaseConfigs;
    WHILE curTgtReleaseConfigs%FOUND
    LOOP
       OPEN curTgtReleaseConfigRunLevel;
       FETCH curTgtReleaseConfigRunLevel INTO recTgtReleaseConfigRunLevel;
    Log_Project_Action ( ProjId, 'import_release_contents', nUserId, 'SOURCE: '|| sSourceLocation ||'   TARGET: '|| sTargetLocation, nTargetRtagId );
 END;
 /*-------------------------------------------------------------------------------------------------------*/
 PROCEDURE Clean_Release_Contents ( nRtagId IN NUMBER, nUserId IN NUMBER ) IS
    RecCount NUMBER;
         rconIdList VARCHAR2(4000);
 --
 --
 -- END;
 /*-------------------------------------------------------------------------------------------------------*/
-PROCEDURE GET_VIEW_CONTENT ( RtagId IN NUMBER, ViewId IN NUMBER, RecordSet OUT typeCur ) IS
+PROCEDURE GET_VIEW_CONTENT ( RtagId IN NUMBER, ViewId IN NUMBER, RecordSet OUT typeCur ) as
+begin
+OPEN RecordSet FOR
+-- Determine the PV_ID and OPERATION for the required VIEW
+With selectedPv as (
+    SELECT pv.pv_id, ' ' as operation, 0 as pkg_state
+      FROM RELEASE_CONTENT rel, package_versions pv, VIEW_DEF vd,  VIEWS vi
+      WHERE rel.pv_id = pv.pv_id
+      AND vd.PKG_ID = pv.PKG_ID
+      AND vd.VIEW_ID = ViewId
-   IsBaseView CHAR(1);
+      AND rel.RTAG_ID = RtagId
+      AND vi.VIEW_ID = ViewId
+      AND vi.BASE_VIEW NOT IN ('Y', 'S')
-BEGIN
+    UNION
+     SELECT rel.pv_id, ' ' as operation, 0 as pkg_state
-   -- Check if the view is BASE VIEW
+     FROM RELEASE_CONTENT rel, VIEWS vi
-   SELECT vi.BASE_VIEW INTO IsBaseView
+     WHERE rel.BASE_VIEW_ID = ViewId
-     FROM VIEWS vi
+     AND rel.RTAG_ID = RtagId
-    WHERE vi.VIEW_ID = ViewId;
+     AND vi.VIEW_ID = ViewId
+     AND vi.BASE_VIEW IN ('Y', 'S')
+),
-   IF (IsBaseView IN ('Y', 'S')) THEN
+-- Determine packages that are building
-      -- Get Base view content
+building as (
-      OPEN RecordSet FOR
+    SELECT unique rl.CURRENT_PV_ID as pv_id, rc.RTAG_ID
-      SELECT DECODE ( rel.pkg_state, NULL, 0, rel.pkg_state ) AS PKG_STATE,
+    FROM RELEASE_CONFIG rc, RELEASE_TAGS rt, RUN_LEVEL rl
-            rel.deprecated_state,
+    WHERE rt.RTAG_ID = rc.RTAG_ID
-            pv.pv_id,
+    AND rc.RTAG_ID = RtagId
-            pkg.pkg_name,
+    AND rc.bmcon_id is not null
-            pv.pkg_version,
+    AND rt.OFFICIAL in ( 'N', 'R', 'C')
-            pv.dlocked,
+    AND rl.RCON_ID(+) = rc.RCON_ID
-            pv.pv_description,
+    AND rl.CURRENT_PKG_ID_BEING_BUILT is not null
-            pv.BUILD_TYPE
+    AND NVL(rl.PAUSE,0) < 2
+),
-        FROM release_content rel,
+-- Determine Packages that are scheduled to build
-             packages pkg,
+scheduled as (
-             package_versions pv
+    SELECT pv_id, RTAG_ID from daemon_instructions di
-       WHERE pv.pkg_id = pkg.pkg_id
+    WHERE di.op_code = 2
-         AND rel.pv_id = pv.pv_id
+    AND RTAG_ID = RtagId
+) ,
-         AND rel.BASE_VIEW_ID = ViewId
+-- Determine Packages that failed to build or have been excluded
+buildFail as (
-         AND rel.RTAG_ID = RtagId
+    SELECT pv_id, root_pv_id, RTAG_ID from do_not_ripple dnr
-       ORDER BY UPPER(pkg.PKG_NAME);
+    WHERE RTAG_ID = RtagId
+)
+-- Generate the complete dataset from the fragments
-   ELSE
+  SELECT Case
-       -- Get non base view content
+                    When sdi.pv_id is not null then 14
-      OPEN RecordSet FOR
+                    When bb.pv_id is not null then 15
+                    When bf.pv_id is not null AND bf.root_pv_id is NULL then 16
+                    When bf.pv_id is not null AND bf.root_pv_id is NOT NULL then  17
-      SELECT DECODE ( rel.pkg_state, NULL, 0, rel.pkg_state ) AS PKG_STATE,
+                    When rel.pkg_state is not null then rel.pkg_state
+                    Else 0
-            rel.deprecated_state,
+                End as pkg_state,
+               NULL AS DEPRECATED_STATE,
-            pv.pv_id,
+               pv.pv_id,
-            pkg.pkg_name,
+               pkg.pkg_name,
-            pv.pkg_version,
+               pv.pkg_version,
-            pv.dlocked,
+               pv.dlocked,
-            pv.pv_description,
+               pv.pv_description,
-            pv.BUILD_TYPE
+               pv.BUILD_TYPE,
+               rel.operation
-        FROM release_content rel,
+          FROM selectedPv rel,
-             packages pkg,
+               packages pkg,
-             package_versions pv,
+               package_versions pv,
+               scheduled sdi,
+               buildFail bf,
-            VIEW_DEF vd
+               building bb
-       WHERE pv.pkg_id = pkg.pkg_id
+         WHERE pv.pkg_id = pkg.pkg_id
-         AND rel.pv_id = pv.pv_id
+           AND rel.pv_id = pv.pv_id
-         AND vd.VIEW_ID = ViewId
+           AND sdi.pv_id(+) = rel.pv_id
-         AND vd.PKG_ID = pv.PKG_ID
+           AND bf.pv_id(+) = rel.pv_id
-         AND rel.RTAG_ID = RtagId
+           AND bb.pv_id(+) = rel.pv_id
-       ORDER BY UPPER(pkg.PKG_NAME);
+         ORDER BY UPPER(pkg.PKG_NAME), pv.pv_id;
-   END IF;
 END;
 /*-------------------------------------------------------------------------------------------------------*/
   -- Add or Replace a package to the specified release
 PROCEDURE ADD_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER ) IS
    ReleaseLocation VARCHAR2(4000);
    nPkgId NUMBER;
    -- 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;
          THEN
             -- Package already exists, hence cannot be used for ripple build
             RETURN return_package_already_exists;
       END;
-      -- Update the is_autobuildable
+      -- The package has been auto built, for the first time
-      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.
                                         vext,
                                         ssv_ext,
                                         clonefrompvid
                                        );
-      -- DEVI-063601
-      -- if it is a planned build then restore the modifier_id to the previous modifier
+      -- DEVI-063601 if it is a planned build then restore the modifier_id to the previous modifier
+      -- Set the package as autobuildable ( auto built )
+      -- Update the created timestamp to the current date-time. When it was first released
+      UPDATE package_versions pv SET
-      UPDATE package_versions pv SET pv.modifier_id = iprev_modifier_id
+        pv.modifier_id = iprev_modifier_id,
+        is_autobuildable = 'Y',
+        pv.created_stamp = ora_sysdatetime
       WHERE pv.pv_id = pvid;
       --Now clean the PLANNED_VERSIONS table
       SELECT pkg_id
         INTO pkgid
 --  Constraints for Table VIEW_DEF
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."VIEW_DEF" MODIFY ("PKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VIEW_DEF" MODIFY ("VIEW_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Ref Constraints for Table ABT_ACTION_LOG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG" ADD FOREIGN KEY ("RCON_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_CONFIG" ("RCON_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table ACTION_LOG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" ADD CONSTRAINT "ACTION_LOG_FK1" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" ADD CONSTRAINT "REFACTION_TYPE48" FOREIGN KEY ("ACTTYPE_ID")
+	  REFERENCES "RELEASE_MANAGER"."ACTION_TYPE" ("ACTTYPE_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table ADDITIONAL_NOTES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" ADD CONSTRAINT "FK_ADDITION_REF_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table ADVISORY_RIPPLE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE" ADD FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE" ADD FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table AUTOBUILD_FAILURE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE" ADD FOREIGN KEY ("PROJ_ID")
+	  REFERENCES "RELEASE_MANAGER"."PROJECTS" ("PROJ_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE" ADD FOREIGN KEY ("VIEW_ID")
+	  REFERENCES "RELEASE_MANAGER"."VIEWS" ("VIEW_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BLAT_PROJECTS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_PROJECTS" ADD CONSTRAINT "BLAT_PROJECTS_FK1" FOREIGN KEY ("BLAT_ID")
+	  REFERENCES "RELEASE_MANAGER"."BLAT_SERVERS" ("BLAT_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_PROJECTS" ADD CONSTRAINT "BLAT_PROJECTS_FK2" FOREIGN KEY ("PROJ_ID")
+	  REFERENCES "RELEASE_MANAGER"."PROJECTS" ("PROJ_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BLAT_RELEASES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_RELEASES" ADD CONSTRAINT "BLAT_RELEASES_FK1" FOREIGN KEY ("BLAT_ID")
+	  REFERENCES "RELEASE_MANAGER"."BLAT_SERVERS" ("BLAT_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_RELEASES" ADD CONSTRAINT "BLAT_RELEASES_FK2" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BUILD_ENV_DOCUMENTS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" ADD CONSTRAINT "FK_BUILD_E_DOCS_REF_BUILD_ENV" FOREIGN KEY ("BE_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" ("BE_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BUILD_INSTANCES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" ADD CONSTRAINT "BUILD_INSTANCES_FK1" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ON DELETE SET NULL ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" ADD CONSTRAINT "BUILD_INSTANCES_FK2" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BUILD_MACHINE_CONFIG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" ADD CONSTRAINT "FK_BM_GBE_ID" FOREIGN KEY ("GBE_ID")
+	  REFERENCES "RELEASE_MANAGER"."GBE_MACHTYPE" ("GBE_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BUILD_ORDER
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" ADD CONSTRAINT "FK_BO_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" ADD CONSTRAINT "FK_BO_RTAG_ID" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BUILD_PLAN
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLAN" ADD CONSTRAINT "BUILD_PLAN_FK1" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLAN" ADD CONSTRAINT "BUILD_PLAN_FK2" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BUILD_STANDARDS_ADDENDUM
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" ADD CONSTRAINT "BUILD_STANDARDS_ADDENDUM_R01" FOREIGN KEY ("BS_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_STANDARDS" ("BS_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table CODE_REVIEWS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEWS" ADD CONSTRAINT "FK_CODE_REV_REF_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table CODE_REVIEW_URL
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" ADD CONSTRAINT "CODE_REVIEW_URL_PACKAGE_V_FK1" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" ADD CONSTRAINT "CODE_REVIEW_URL_PROJECT_V_FK1" FOREIGN KEY ("PROJ_ID")
+	  REFERENCES "RELEASE_MANAGER"."PROJECTS" ("PROJ_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table CQ_ISSUES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" ADD CONSTRAINT "FK_CQ_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table DAEMON_ACTION_LOG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."DAEMON_ACTION_LOG" ADD FOREIGN KEY ("RCON_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_CONFIG" ("RCON_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."DAEMON_ACTION_LOG" ADD FOREIGN KEY ("ACTTYPE_ID")
+	  REFERENCES "RELEASE_MANAGER"."ACTION_TYPE" ("ACTTYPE_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table DAEMON_INSTRUCTIONS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" ADD CONSTRAINT "DAEMON_INSTRUCTIONS_PV_ID_FK" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" ADD CONSTRAINT "DAEMON_INSTRUCTIONS_RTAG_ID_FK" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table DASH_BOARD
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" ADD FOREIGN KEY ("PROJ_ID")
+	  REFERENCES "RELEASE_MANAGER"."PROJECTS" ("PROJ_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" ADD FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table DO_NOT_RIPPLE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE" ADD FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE" ADD FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table GBE_MACHTYPE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" ADD CONSTRAINT "GBE_MACHTYPE_BUILD_MACHIN_FK1" FOREIGN KEY ("BM_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_MACHINES" ("BM_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table IGNORE_WARNINGS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" ADD CONSTRAINT "FK_IGW_DPV_ID" FOREIGN KEY ("DPV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" ADD CONSTRAINT "FK_IGW_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" ADD CONSTRAINT "FK_IGW_RTAG_ID" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table JIRA_ISSUES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."JIRA_ISSUES" ADD CONSTRAINT "FK_JIRA_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table LICENCING
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."LICENCING" ADD FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."LICENCING" ADD FOREIGN KEY ("LICENCE")
+	  REFERENCES "RELEASE_MANAGER"."LICENCES" ("LICENCE") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table LXR_STATE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" ADD CONSTRAINT "LXR_STATE_FK1" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table MEMBERS_GROUP
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."MEMBERS_GROUP" ADD FOREIGN KEY ("GROUP_EMAIL_ID")
+	  REFERENCES "RELEASE_MANAGER"."AUTOBUILD_FAILURE" ("GROUP_EMAIL_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table NOTIFICATION_HISTORY
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" ADD CONSTRAINT "FK_NH_RTAG_ID" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" ADD CONSTRAINT "FK_NK_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") DISABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_BUILD_ENV
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" ADD CONSTRAINT "FK_PKG_BUILD_E_REF_BUILD_ENV" FOREIGN KEY ("BE_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" ("BE_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" ADD CONSTRAINT "FK_PKG_BUILD_E_REF_PKG_VERSION" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_BUILD_INFO
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" ADD FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" ADD FOREIGN KEY ("BM_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_MACHINES" ("BM_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_DEPENDENCIES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ADD CONSTRAINT "PACKAGE_DEPENDENCIES_FK1" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ADD CONSTRAINT "PACKAGE_DEPENDENCIES_FK2" FOREIGN KEY ("DPV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ADD CONSTRAINT "PACKAGE_DEPENDENCIES_FK3" FOREIGN KEY ("DPKG_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGES" ("PKG_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ADD CONSTRAINT "PACKAGE_DEPENDENCIES_FK4" FOREIGN KEY ("PKG_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGES" ("PKG_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_DOCUMENTS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" ADD CONSTRAINT "FK_PKGDOCS_REF_PV" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_INTEREST
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" ADD FOREIGN KEY ("PROJ_ID")
+	  REFERENCES "RELEASE_MANAGER"."PROJECTS" ("PROJ_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_METRICS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_METRICS" ADD CONSTRAINT "FK_PACKAGE_METRICS_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_PATCHES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" ADD CONSTRAINT "FK_PP_PATCH_ID" FOREIGN KEY ("PATCH_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" ADD CONSTRAINT "FK_PP_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_PROCESSES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES" ADD CONSTRAINT "PACKAGE_PROCESSES_R01" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES" ADD CONSTRAINT "PACKAGE_PROCESSES_R02" FOREIGN KEY ("PROC_ID")
+	  REFERENCES "RELEASE_MANAGER"."PROCESSES" ("PROC_ID") ENABLE;
+--------------------------------------------------------
+--  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
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" ADD CONSTRAINT "PEGGED_VERSIONS_PACKAG_FK1" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" ADD CONSTRAINT "PEGGED_VERSIONS_RELEAS_FK1" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PLANNED
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PLANNED" ADD CONSTRAINT "REFPACKAGE_VERSIONS54" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PLANNED" ADD CONSTRAINT "REFRELEASE_TAGS53" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PLANNED" ADD CONSTRAINT "REFVIEWS55" FOREIGN KEY ("VIEW_ID")
+	  REFERENCES "RELEASE_MANAGER"."VIEWS" ("VIEW_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PLANNED_VERSIONS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PLANNED_VERSIONS" ADD FOREIGN KEY ("PKG_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGES" ("PKG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PRODUCT_COMPONENTS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS" ADD CONSTRAINT "REFPACKAGE_VERSIONS49" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table PROJECT_ACTION_LOG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG" ADD CONSTRAINT "REFACTION_TYPE63" FOREIGN KEY ("ACTTYPE_ID")
+	  REFERENCES "RELEASE_MANAGER"."ACTION_TYPE" ("ACTTYPE_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG" ADD FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") DISABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table RELEASE_COMPONENTS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_COMPONENTS" ADD CONSTRAINT "FK_RCONT_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table RELEASE_CONFIG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" ADD FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" ADD FOREIGN KEY ("GBE_ID")
+	  REFERENCES "RELEASE_MANAGER"."GBE_MACHTYPE" ("GBE_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table RELEASE_CONTENT
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" ADD CONSTRAINT "RELEASE_CONTENT_FK1" FOREIGN KEY ("SDKTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."SDK_TAGS" ("SDKTAG_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" ADD FOREIGN KEY ("PKG_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGES" ("PKG_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" ADD FOREIGN KEY ("PRODUCT_STATE")
+	  REFERENCES "RELEASE_MANAGER"."PRODUCT_STATES" ("STATE_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table RELEASE_LINKS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_LINKS" ADD CONSTRAINT "REFRELEASE_TAGS56" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_LINKS" ADD CONSTRAINT "REFRELEASE_TAGS58" FOREIGN KEY ("REF_RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table RELEASE_METRICS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_METRICS" ADD CONSTRAINT "FK_RELEASE_METRICS_RTAG_ID" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table RELEASE_MODIFIED
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_MODIFIED" ADD CONSTRAINT "RELEASE_MODIFIED_RELEASE__FK1" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table RUNTIME_DEPENDENCIES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" ADD CONSTRAINT "FK_RTD_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" ADD CONSTRAINT "FK_RTD_RTD_ID" FOREIGN KEY ("RTD_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table RUN_LEVEL
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL" ADD FOREIGN KEY ("RCON_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_CONFIG" ("RCON_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL" ADD FOREIGN KEY ("CURRENT_PKG_ID_BEING_BUILT")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGES" ("PKG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table SDK_CONTENT
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" ADD CONSTRAINT "SDK_CONTENT_FK1" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" ADD CONSTRAINT "SDK_CONTENT_FK2" FOREIGN KEY ("SDKTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."SDK_TAGS" ("SDKTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table SDK_NAMES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."SDK_NAMES" ADD CONSTRAINT "SDK_NAMES_FK1" FOREIGN KEY ("VIEW_ID")
+	  REFERENCES "RELEASE_MANAGER"."VIEWS" ("VIEW_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."SDK_NAMES" ADD CONSTRAINT "SDK_NAMES_FK2" FOREIGN KEY ("PROJ_ID")
+	  REFERENCES "RELEASE_MANAGER"."PROJECTS" ("PROJ_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table SDK_TAGS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" ADD CONSTRAINT "SDK_TAGS_FK1" FOREIGN KEY ("SDK_ID")
+	  REFERENCES "RELEASE_MANAGER"."SDK_NAMES" ("SDK_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" ADD CONSTRAINT "SDK_TAGS_FK2" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table TEST_RUN
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."TEST_RUN" ADD CONSTRAINT "TEST_RUN_FK1" FOREIGN KEY ("BUILD_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_INSTANCES" ("BUILD_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table UNIT_TESTS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."UNIT_TESTS" ADD CONSTRAINT "FK_UT_REF_PV_ID" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."UNIT_TESTS" ADD CONSTRAINT "FK_UT_REF_TEST_TYPES" FOREIGN KEY ("TEST_TYPES_FK")
+	  REFERENCES "RELEASE_MANAGER"."TEST_TYPES" ("TEST_TYPE_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table VTREES_WORLD
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VTREES_WORLD" ADD CONSTRAINT "FK_VW_REF_VTREE_ID" FOREIGN KEY ("VTREE_ID")
+	  REFERENCES "RELEASE_MANAGER"."VTREES" ("VTREE_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."VTREES_WORLD" ADD CONSTRAINT "FK_VW_REF_WORLD_ID" FOREIGN KEY ("WORLD_ID")
+	  REFERENCES "RELEASE_MANAGER"."WORLDS" ("WORLD_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table WORK_IN_PROGRESS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" ADD CONSTRAINT "REFPACKAGE_VERSIONS51" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" ADD CONSTRAINT "REFRELEASE_TAGS50" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" ADD CONSTRAINT "REFVIEWS52" FOREIGN KEY ("VIEW_ID")
+	  REFERENCES "RELEASE_MANAGER"."VIEWS" ("VIEW_ID") ENABLE;

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/web/database/Relman_export.sql – Rev 7000 → 7039