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

 --------------------------------------------------------
---  File created - Tuesday-July-21-2015
+--  File created - Friday-November-27-2015
 --------------------------------------------------------
 --------------------------------------------------------
 --  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 35929 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_ADDITIONAL_NOTES"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 36009 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 241 CACHE 20 NOORDER  NOCYCLE ;
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BSA_ID"  MINVALUE 8 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 28 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 24161 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 53381 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 89846 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_CR_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 90606 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 158028 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 160148 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 1232 NOCACHE  ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_GBE_ID"  MINVALUE 40 MAXVALUE 9999999999999999999999990 INCREMENT BY 1 START WITH 1240 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 1166 CACHE 20 NOORDER  NOCYCLE ;
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_MSG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 562 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 61927 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PKG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 62547 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 841 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PROJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 861 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 1053105 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1078645 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 27570 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RCON_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 28230 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 17976 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RELEASE_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 55336 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 32205 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RTAG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 32745 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 27687 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SCHEDULED_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 27947 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 41 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDKTAG_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 121 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 41 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDK_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 81 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 1036746 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SESSION_NUM"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1047766 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_UNIT_TESTS
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 357062 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 358582 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 43 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 5601 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VIEW_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 5661 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 29024 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VTREE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 29564 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Table ABT_ACTION_LOG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG"
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   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 "RELEASEM_DATA" ;
 --------------------------------------------------------
+--  DDL for Table LXR_STATE
+--------------------------------------------------------
+  CREATE TABLE "RELEASE_MANAGER"."LXR_STATE"
+   (	"RTAG_ID" NUMBER,
+	"LXRSERVER" CHAR(1 BYTE) DEFAULT 'N'
+   ) SEGMENT CREATION IMMEDIATE
+  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
+  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 "RELEASEM_DATA" ;
+   COMMENT ON COLUMN "RELEASE_MANAGER"."LXR_STATE"."RTAG_ID" IS 'Link to Release_Tags';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."LXR_STATE"."LXRSERVER" IS 'Written by server - I:Indexed, C:Closing, N:Not Known. May be InProgress.';
+   COMMENT ON TABLE "RELEASE_MANAGER"."LXR_STATE"  IS 'Contains data updated by the LXR server.
+This table is writable by a user known to the LXR Server';
+--------------------------------------------------------
 --  DDL for Table MEMBERS_GROUP
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."MEMBERS_GROUP"
    (	"GROUP_EMAIL_ID" NUMBER,
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   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 "RELEASEM_DATA" ;
+   COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES"."PV_ID" IS 'Package Version Identifier';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES"."DPV_ID" IS 'Depends on this package version';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES"."BUILD_TYPE" IS 'B:BuildPkgArchive, L:LinkPkgArchive';
 --------------------------------------------------------
 --  DDL for Table PACKAGE_DOCUMENTS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS"
 	"ESTIMATED_COMPLETION_TIME" DATE,
 	"MAJOR_LIMIT" NUMBER(10,0),
 	"MINOR_LIMIT" NUMBER(10,0),
 	"PATCH_LIMIT" NUMBER(10,0),
 	"BUILD_NUMBER_LIMIT" NUMBER(10,0),
-	"VCS_TYPE_ID" NUMBER
+	"VCS_TYPE_ID" NUMBER,
+	"PKG_IDEXT" VARCHAR2(70 BYTE)
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 134217728 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
   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 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
-   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONTENT"."PKG_ID" IS 'Package that has been deprecated';
+   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';
 --------------------------------------------------------
 --  DDL for Table RELEASE_LINKS
 --------------------------------------------------------
 	"ASSOC_MASS_REF" NUMBER,
 	"OWNER_PERSONAL_EMAIL" VARCHAR2(1000 BYTE),
 	"CONFIG_SPEC_BRANCH" VARCHAR2(4000 BYTE),
 	"PRODUCT_STATE_USED" CHAR(1 BYTE),
 	"OFFICIAL_ID" NUMBER,
-	"BUILD_AGE" NUMBER DEFAULT 31
+	"BUILD_AGE" NUMBER DEFAULT 31,
+	"LXR" CHAR(1 BYTE) DEFAULT 'N'
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 262144 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."CREATED_STAMP" IS 'Date Release was created';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."CREATOR_ID" IS 'User who created the release';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."OFFICIAL_STAMP" IS 'Date OFFICIAL state was changed';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."RELEASOR_ID" IS 'Not Used';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."OFFICIAL" IS 'State of release. A:Archived, Y:Closed, C:CCB Mode, R:Restricted, N: Open';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."REBUILD_ENV" IS 'Y: Rebuild Package State';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."REBUILD_STAMP" IS 'Not used ?';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."OFFICIAL_ID" IS 'User last changed OFFICIAL state';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."BUILD_AGE" IS 'Days without building before warning is shown';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."LXR" IS 'Y:Enable LXR';
 --------------------------------------------------------
 --  DDL for Table RIPPLE_FIELD_STATES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RIPPLE_FIELD_STATES"
    COMMENT ON COLUMN "RELEASE_MANAGER"."SDK_TAGS"."CREATOR_ID" IS 'Who Created the version';
    COMMENT ON COLUMN "RELEASE_MANAGER"."SDK_TAGS"."STATE_STAMP" IS 'Time of last change to this version';
    COMMENT ON COLUMN "RELEASE_MANAGER"."SDK_TAGS"."STATE_ID" IS 'User id who made the last state change';
    COMMENT ON COLUMN "RELEASE_MANAGER"."SDK_TAGS"."SDK_STATE" IS 'State: U-Under Development; R-Released; D-Deprecated';
 --------------------------------------------------------
+--  DDL for Table TEMP_ENV_DEPS
+--------------------------------------------------------
+  CREATE TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS"
+   (	"SESSION_NUM" NUMBER,
+	"PV_ID" NUMBER,
+	"PKG_ID" NUMBER,
+	"V_EXT" VARCHAR2(50 BYTE),
+	"DPV_ID" NUMBER,
+	"DPKG_ID" NUMBER,
+	"DV_EXT" VARCHAR2(50 BYTE)
+   ) SEGMENT CREATION IMMEDIATE
+  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
+  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 "RELEASEM_DATA" ;
+   COMMENT ON TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS"  IS 'This table is used in the creation of the package_state information
+Data in the table is temporary. It should be cleared out after its been used.
+Data will only be used for a few seconds.
+The table is used to map DPV_IDs to PV_IDs, but only for DPV_IDs that are of interest';
+--------------------------------------------------------
 --  DDL for Table TEMP_ENV_STATES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES"
    (	"SESSION_NUM" NUMBER,
   CREATE TABLE "RELEASE_MANAGER"."TEST_RUN"
    (	"BUILD_ID" NUMBER,
 	"PLATFORM" VARCHAR2(50 BYTE),
 	"TYPE" VARCHAR2(1 BYTE),
-	"TEST_NAME" VARCHAR2(150 BYTE),
+	"TEST_NAME" VARCHAR2(200 BYTE),
 	"TEST_OUTCOME" VARCHAR2(20 BYTE),
 	"TIME_TAKEN" NUMBER,
 	"FAIL_MESSAGE" CLOB
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   TABLESPACE "RELEASEM_INDX" ;
 --------------------------------------------------------
 --  DDL for Index INX_PACKAGES_ALIAS
 --------------------------------------------------------
-  CREATE INDEX "RELEASE_MANAGER"."INX_PACKAGES_ALIAS" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PKG_ID", "V_EXT")
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."INX_PACKAGES_ALIAS" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID", "PKG_ID", "V_EXT")
   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 "RELEASEM_DATA" ;
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."PK_VIEWS" ON "RELEASE_MANAGER"."VIEWS" ("VIEW_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 "RELEASEM_INDX" ;
+--------------------------------------------------------
+--  DDL for Index CQ_USERS_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."CQ_USERS_PK" ON "RELEASE_MANAGER"."CQ_USERS" ("DBID")
+  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 "RELEASEM_DATA" ;
 --------------------------------------------------------
 --  DDL for Index PK_PACKAGES
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."PK_PACKAGES" ON "RELEASE_MANAGER"."PACKAGES" ("PKG_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 "RELEASEM_INDX" ;
 --------------------------------------------------------
+--  DDL for Index CQ_SOFTWARE_ISSUE_INDEX6
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE_INDEX6" ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ("NEW_NUM")
+  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 "RELEASEM_DATA" ;
+--------------------------------------------------------
 --  DDL for Index BUILD_MACHINES_PK
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."BUILD_MACHINES_PK" ON "RELEASE_MANAGER"."BUILD_MACHINES" ("BM_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   CREATE INDEX "RELEASE_MANAGER"."SDK_CONTENT_INDEX1" ON "RELEASE_MANAGER"."SDK_CONTENT" ("SDKTAG_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 "RELEASEM_DATA" ;
+--------------------------------------------------------
+--  DDL for Index CQ_STATEDEF_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."CQ_STATEDEF_PK" ON "RELEASE_MANAGER"."CQ_STATEDEF" ("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 "RELEASEM_DATA" ;
 --------------------------------------------------------
 --  DDL for Index INX_RL_RTAG_ID
 --------------------------------------------------------
   CREATE INDEX "RELEASE_MANAGER"."INX_RL_RTAG_ID" ON "RELEASE_MANAGER"."RELEASE_LINKS" ("RTAG_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX" ;
 --------------------------------------------------------
+--  DDL for Index LICENCING_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."LICENCING_PK" ON "RELEASE_MANAGER"."LICENCING" ("PV_ID", "LICENCE")
+  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 "RELEASEM_DATA" ;
+--------------------------------------------------------
 --  DDL for Index BUILD_SERVICE_CONFIG_INDEX1
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG_INDEX1" ON "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" ("SERVICE")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."RELEASE_MODIFIED_PK" ON "RELEASE_MANAGER"."RELEASE_MODIFIED" ("RTAG_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 "RELEASEM_DATA" ;
+--------------------------------------------------------
+--  DDL for Index CQ_HISTORY_INDEX2
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."CQ_HISTORY_INDEX2" ON "RELEASE_MANAGER"."CQ_HISTORY" ("ENTITYDEF_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 "RELEASEM_DATA" ;
 --------------------------------------------------------
 --  DDL for Index INX_TTB_LEVEL_NUM
 --------------------------------------------------------
   CREATE INDEX "RELEASE_MANAGER"."INX_TTB_LEVEL_NUM" ON "RELEASE_MANAGER"."TEMP_TREE_BROWSE" ("LEVEL_NUM")
   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 "RELEASEM_INDX" ;
 --------------------------------------------------------
+--  DDL for Index CQ_SOFTWARE_ISSUE_INDEX2
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE_INDEX2" ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ("STATE")
+  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 "RELEASEM_DATA" ;
+--------------------------------------------------------
+--  DDL for Index TEMP_ENV_DEPS_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."TEMP_ENV_DEPS_PK" ON "RELEASE_MANAGER"."TEMP_ENV_DEPS" ("PV_ID", "SESSION_NUM", "DPV_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 "RELEASEM_DATA" ;
+--------------------------------------------------------
 --  DDL for Index UNQ_RELEASE_LINKS
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."UNQ_RELEASE_LINKS" ON "RELEASE_MANAGER"."RELEASE_LINKS" ("RTAG_ID", "REF_RTAG_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."UNQ_PKG_DOC" ON "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" ("PV_ID", "DOC_NUM")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX" ;
+--------------------------------------------------------
+--  DDL for Index LXR_STATE_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."LXR_STATE_PK" ON "RELEASE_MANAGER"."LXR_STATE" ("RTAG_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 "RELEASEM_DATA" ;
 --------------------------------------------------------
 --  DDL for Index DAEMON_INSTRUCTIONS_PK
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS_PK" ON "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" ("DAEMON_INSTRUCTIONS_ID")
   CREATE INDEX "RELEASE_MANAGER"."INX_TTB_PKG" ON "RELEASE_MANAGER"."TEMP_TREE_BROWSE" ("PKG_ID", "V_EXT")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX" ;
+--------------------------------------------------------
+--  DDL for Index PACKAGE_VERSIONS_MODIFER_ID
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."PACKAGE_VERSIONS_MODIFER_ID" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("MODIFIER_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 "RELEASEM_DATA" ;
 --------------------------------------------------------
 --  DDL for Index UNQ_VALIDATION_RULES
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."UNQ_VALIDATION_RULES" ON "RELEASE_MANAGER"."VALIDATION_RULES" ("FIELD_NAME")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
   STORAGE(INITIAL 851968 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX" ;
 --------------------------------------------------------
+--  DDL for Index CQ_SOFTWARE_ISSUE_INDEX5
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE_INDEX5" ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ("PRODUCT")
+  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 "RELEASEM_DATA" ;
+--------------------------------------------------------
 --  DDL for Index UNQ_VTREE_WORLD
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."UNQ_VTREE_WORLD" ON "RELEASE_MANAGER"."VTREES_WORLD" ("WORLD_ID", "VTREE_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."SDK_TAGS_PK" ON "RELEASE_MANAGER"."SDK_TAGS" ("SDKTAG_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 "RELEASEM_DATA" ;
+--------------------------------------------------------
+--  DDL for Index CQ_SOFTWARE_ISSUE_INDEX7
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE_INDEX7" ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ("DEPENDANT_DEVIS")
+  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 "RELEASEM_DATA" ;
 --------------------------------------------------------
 --  DDL for Index PK_NOTIFICATION_HISTORY
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."PK_NOTIFICATION_HISTORY" ON "RELEASE_MANAGER"."NOTIFICATION_HISTORY" ("RTAG_ID", "PV_ID", "USER_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
   STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX" ;
 --------------------------------------------------------
+--  DDL for Index CQ_SOFTWARE_ISSUE_INDEX3
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE_INDEX3" ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ("PACKAGE_REF")
+  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 "RELEASEM_DATA" ;
+--------------------------------------------------------
+--  DDL for Index CQ_SOFTWARE_ISSUE_INDEX4
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE_INDEX4" ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ("PROJECT")
+  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 "RELEASEM_DATA" ;
+--------------------------------------------------------
 --  DDL for Index UNQ_REL_COMPONENTS
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."UNQ_REL_COMPONENTS" ON "RELEASE_MANAGER"."RELEASE_COMPONENTS" ("PV_ID", "FILE_NAME", "FILE_PATH")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."PK_BUILD_ENVIRONMENTS" ON "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" ("BE_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX" ;
+--------------------------------------------------------
+--  DDL for Index CQ_SOFTWARE_ISSUE_INDEX1
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE_INDEX1" ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ("DBID")
+  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 "RELEASEM_DATA" ;
 --------------------------------------------------------
 --  DDL for Index INX_PACKAGE_DEPS_DPKG_ID
 --------------------------------------------------------
   CREATE INDEX "RELEASE_MANAGER"."INX_PACKAGE_DEPS_DPKG_ID" ON "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ("DPKG_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX" ;
 --------------------------------------------------------
+--  DDL for Index CQ_HISTORY_INDEX1
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."CQ_HISTORY_INDEX1" ON "RELEASE_MANAGER"."CQ_HISTORY" ("DBID")
+  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 "RELEASEM_DATA" ;
+--------------------------------------------------------
 --  DDL for Index UNQ_AN_PART2
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."UNQ_AN_PART2" ON "RELEASE_MANAGER"."ADDITIONAL_NOTES" ("PV_ID", "NOTE_TITLE")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" MODIFY ("MOD_USER" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table LXR_STATE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" ADD CONSTRAINT "LXR_STATE_PK" PRIMARY KEY ("RTAG_ID")
+  USING INDEX 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 "RELEASEM_DATA"  ENABLE;
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_PROCESSES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES" MODIFY ("PROC_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("DLOCKED" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PKG_VERSION" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
+--  Constraints for Table CQ_SOFTWARE_ISSUE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ADD CONSTRAINT "CQ_SOFTWARE_ISSUE_PK" PRIMARY KEY ("DBID")
+  USING INDEX 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 "RELEASEM_DATA"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" MODIFY ("DBID" NOT NULL ENABLE);
+--------------------------------------------------------
 --  Constraints for Table PACKAGE_INTEREST
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("USER_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("PROJ_ID" NOT NULL ENABLE);
   STORAGE(INITIAL 4194304 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_METRICS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
+--  Constraints for Table CQ_USERS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_USERS" ADD CONSTRAINT "CQ_USERS_PK" PRIMARY KEY ("DBID")
+  USING INDEX 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 "RELEASEM_DATA"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."CQ_USERS" MODIFY ("DBID" NOT NULL ENABLE);
+--------------------------------------------------------
 --  Constraints for Table CODE_REVIEW_URL
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" ADD CONSTRAINT "CODE_REVIEW_URL_PK" PRIMARY KEY ("CR_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("DATE_OF_REVIEW" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("URL" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("PROJ_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("CR_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table CQ_STATEDEF
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_STATEDEF" ADD CONSTRAINT "CQ_STATEDEF_PK" PRIMARY KEY ("ID")
+  USING INDEX 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 "RELEASEM_DATA"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."CQ_STATEDEF" MODIFY ("ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table AUTOBUILD_FAILURE
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE" ADD PRIMARY KEY ("GROUP_EMAIL_ID")
   USING INDEX 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 "RELEASEM_DATA"  ENABLE;
 --------------------------------------------------------
+--  Constraints for Table TEMP_ENV_DEPS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("PKG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("DPV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("SESSION_NUM" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("DPKG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" ADD CONSTRAINT "TEMP_ENV_DEPS_PK" PRIMARY KEY ("PV_ID", "SESSION_NUM", "DPV_ID")
+  USING INDEX 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 "RELEASEM_DATA"  ENABLE;
+--------------------------------------------------------
 --  Constraints for Table VTREES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."VTREES" ADD CONSTRAINT "PK_VTREES" PRIMARY KEY ("VTREE_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   ALTER TABLE "RELEASE_MANAGER"."PROJECTS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table LICENCING
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."LICENCING" ADD CONSTRAINT "LICENCING_PK" PRIMARY KEY ("PV_ID", "LICENCE")
+  USING INDEX 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 "RELEASEM_DATA"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."LICENCING" MODIFY ("LICENCE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."LICENCING" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table MESSAGE_BOARD
 --------------------------------------------------------
   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;
 --------------------------------------------------------
 --  DDL for Function CAN_EDIT_PKG_IN_PROJECT
 --------------------------------------------------------
   CREATE OR REPLACE FUNCTION "RELEASE_MANAGER"."CAN_EDIT_PKG_IN_PROJECT" ( nPvId IN NUMBER, nRtagId IN NUMBER ) RETURN NUMBER IS
+-- Returns 0 : Package is not editable in this Release
+--         1 : Package is editable in this release
 /* ---------------------------------------------------------------------------
     Version: 3.0.0
    --------------------------------------------------------------------------- */
-    VExt PACKAGE_VERSIONS.V_EXT%TYPE;
+  VExt PACKAGE_VERSIONS.V_EXT%TYPE;
-	ProjId NUMBER;
+  ProjId NUMBER;
-	RowCount NUMBER;
+  RowCount NUMBER;
-	cReleaseMode CHAR(1);
+  cReleaseMode CHAR(1);
 BEGIN
-	--RETURN 1;
-	/*--------------- Business Rules Here -------------------*/
+  /*--------------- Business Rules Here -------------------*/
-	IF (nRtagId IS NULL)  OR  (nRtagId < 1)THEN
+  IF (nRtagId IS NULL)  OR  (nRtagId < 1)THEN
-		RETURN 0;
+    RETURN 0;
-	END IF;
+  END IF;
-	/*-------------------------------------------------------*/
+  /*-------------------------------------------------------*/
-	/*-- First Check. See if package is used through release reference --*/
+  /*-- First Check. See if package is used through release reference --*/
-	SELECT COUNT(rc.PV_ID) INTO RowCount
+  SELECT COUNT(rc.PV_ID) INTO RowCount
-	  FROM (
+    FROM (
-	  		SELECT rl.REF_RTAG_ID
+        SELECT rl.REF_RTAG_ID
-			  FROM RELEASE_LINKS rl
+        FROM RELEASE_LINKS rl
-			 WHERE rl.RTAG_ID = nRtagId
+       WHERE rl.RTAG_ID = nRtagId
-	  		) rl,
+        ) rl,
-			RELEASE_CONTENT rc
+      RELEASE_CONTENT rc
-	  WHERE rc.RTAG_ID = rl.REF_RTAG_ID
+    WHERE rc.RTAG_ID = rl.REF_RTAG_ID
-	    AND rc.PV_ID = nPvId;
+      AND rc.PV_ID = nPvId;
-	-- Decide if package can be edited
+  -- Decide if package can be edited
-	IF RowCount > 0 THEN
+  IF RowCount > 0 THEN
-		-- Package is referenced from other release, hence cannot be edited
+    -- Package is referenced from other release, hence cannot be edited
-		RETURN 0;
+    RETURN 0;
-	END IF;
+  END IF;
 -- Check if the package is included through an SDK reference
   SELECT count(*) INTO RowCount
     FROM RELEASE_CONTENT rc
    WHERE rc.RTAG_ID = nRtagId
-	    AND rc.PV_ID = nPvId
+      AND rc.PV_ID = nPvId
       AND rc.SDKTAG_ID is not NULL ;
-	IF RowCount > 0 THEN
+  IF RowCount > 0 THEN
-		-- Package is imported via SDK
+    -- Package is imported via SDK
-		RETURN 0;
+    RETURN 0;
-	END IF;
+  END IF;
+--  Pegged packages can be edited. Other checking needs to be done
-  -- Check if the package is pegged
+--  -- Check if the package is pegged
-  SELECT count(*) INTO RowCount
+--  SELECT count(*) INTO RowCount
-    FROM pegged_versions
+--    FROM pegged_versions
-   WHERE RTAG_ID = nRtagId
+--   WHERE RTAG_ID = nRtagId
-	    AND PV_ID = nPvId;
+--      AND PV_ID = nPvId;
-	IF RowCount > 0 THEN
+--  IF RowCount > 0 THEN
-		-- Package is Pegged
+--    -- Package is Pegged
-		RETURN 0;
+--    RETURN 0;
-	END IF;
+--  END IF;
-		-- Check is only done for releases in restrictive mode
+  -- Check is only done for releases in restrictive mode
-		SELECT rt.OFFICIAL INTO cReleaseMode
+  SELECT rt.OFFICIAL INTO cReleaseMode
-		  FROM RELEASE_TAGS rt
+    FROM RELEASE_TAGS rt
-		 WHERE rt.RTAG_ID = nRtagId;
+   WHERE rt.RTAG_ID = nRtagId;
-		IF cReleaseMode = 'N' OR cReleaseMode = 'R'  OR cReleaseMode = 'C' THEN
+  IF cReleaseMode = 'N' OR cReleaseMode = 'R'  OR cReleaseMode = 'C' THEN
-			-- Do not do any firther checking,
+    -- Do not do any further checking,
-			-- Package is editable here
+    -- Package is editable here
-			RETURN 1;
+    RETURN 1;
-		END IF;
+  END IF;
-	/*-- Further checking --*/
+  /*-- Further checking --*/
-	-- Get proj_id
+  -- Get proj_id
-	SELECT rt.PROJ_ID  INTO  ProjId
+  SELECT rt.PROJ_ID  INTO  ProjId
-	  FROM RELEASE_TAGS rt
+    FROM RELEASE_TAGS rt
-	 WHERE rt.RTAG_ID = nRtagId;
+   WHERE rt.RTAG_ID = nRtagId;
-	BEGIN
+  BEGIN
-		-- Get v_ext
+    -- Get v_ext
-		SELECT pv.V_EXT  INTO  Vext
+    SELECT pv.V_EXT  INTO  Vext
-		  FROM PACKAGE_VERSIONS pv
+      FROM PACKAGE_VERSIONS pv
-		 WHERE pv.PV_ID = nPvId;
+     WHERE pv.PV_ID = nPvId;
-		EXCEPTION
+    EXCEPTION
-	    	WHEN NO_DATA_FOUND THEN
+        WHEN NO_DATA_FOUND THEN
-	       		Vext := NULL;
+            Vext := NULL;
-	END;
+  END;
-	--Temp Hack for Step Project
+  --Temp Hack for Step Project
-	IF ProjId != 281 THEN
+  IF ProjId != 281 THEN
-		-- Find if package can be edited in this project
+    -- Find if package can be edited in this project
-			SELECT COUNT(pe.EXT_NAME) INTO RowCount
+      SELECT COUNT(pe.EXT_NAME) INTO RowCount
-	 		FROM PROJECT_EXTENTIONS pe
+      FROM PROJECT_EXTENTIONS pe
-			WHERE pe.PROJ_ID != ProjId
+      WHERE pe.PROJ_ID != ProjId
-	  		AND pe.EXT_NAME = VExt;
+        AND pe.EXT_NAME = VExt;
-	END IF;
+  END IF;
-	-- Decide if package can be edited
+  -- Decide if package can be edited
-	IF RowCount > 0 THEN
+  IF RowCount > 0 THEN
-		-- Package extension is found in other projects, hence NOT EDITABLE
+    -- Package extension is found in other projects, hence NOT EDITABLE
-		RETURN 0;
+    RETURN 0;
-	ELSE
+  ELSE
-		RETURN 1;
+    RETURN 1;
-	END IF;
+  END IF;
 END CAN_EDIT_PKG_IN_PROJECT;
+/
 --------------------------------------------------------
 --  DDL for Function DT_ADDUSEROBJECT
 	/*================================================================================================*/
 	FUNCTION SELECT_ENVIRONMENT_AREA ( cDlock IN PACKAGE_VERSIONS.DLOCKED%TYPE ) RETURN NUMBER;
 	FUNCTION GET_PACKAGE_AREA ( PvId IN NUMBER, RtagId IN NUMBER ) RETURN NUMBER;
 	FUNCTION GET_VIEW_LOCATION ( PvId IN NUMBER, RtagId IN NUMBER ) RETURN NUMBER;
-	PROCEDURE ADD_PACKAGE ( PvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
+	PROCEDURE ADD_PACKAGE ( PvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER, imode IN   CHAR default NULL );
-	PROCEDURE ADD_PACKAGE_BULK ( PvIdList IN VARCHAR2, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
+	PROCEDURE ADD_PACKAGE_BULK ( PvIdList IN VARCHAR2, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER, imode IN CHAR default NULL );
 	PROCEDURE REPLACE_PACKAGE ( newPvId IN NUMBER, oldPvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
 	FUNCTION REMOVE_PACKAGE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER, ForceRemove IN CHAR ) RETURN NUMBER;
 	PROCEDURE GET_ENVIRONMENT_ITEMS ( ViewType IN NUMBER, UserId IN NUMBER, RtagId IN NUMBER,  sViewIdShowList IN VARCHAR2, nTrueRecordCount OUT NUMBER, RecordSet OUT typeCur );
 	PROCEDURE GET_RELEASED_ITEMS ( ViewType IN NUMBER, UserId IN NUMBER, RtagId IN NUMBER,  sViewIdShowList IN VARCHAR2, nTrueRecordCount OUT NUMBER, RecordSet OUT typeCur );
 */
 	TYPE typeCur IS REF CURSOR;
     /*================================================================================================*/
-	PROCEDURE ADD_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
+	PROCEDURE ADD_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER, OPR IN CHAR DEFAULT 'R'  );
 	PROCEDURE REMOVE_PACKAGE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER );
 	FUNCTION GET_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER ) RETURN NUMBER;
 	PROCEDURE GET_VIEW_CONTENT ( RtagId IN NUMBER, ViewId IN NUMBER, RecordSet OUT typeCur );
 	PROCEDURE CHANGE_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER, NewViewId IN NUMBER );
 	PROCEDURE MERGE_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER, mergeOperation IN CHAR);
 	TYPE typeCur IS REF CURSOR;
     /*================================================================================================*/
 	PROCEDURE New_Release ( sReleaseName IN VARCHAR2, sReleaseComments IN VARCHAR2, nProjId IN NUMBER, nSourceRtagId IN NUMBER, sIsBranched IN CHAR, nUserId IN NUMBER );
-	PROCEDURE Update_Release ( nRtagId IN NUMBER, sReleaseName IN VARCHAR2, sReleaseComments IN VARCHAR2, nParentRtagId IN NUMBER, nMASSRtagId IN NUMBER, nConfigSpecBranch IN VARCHAR2, sOwnerEmail IN VARCHAR2, nUserId IN NUMBER, cState IN VARCHAR, nBuildAge in NUMBER );
+	PROCEDURE Update_Release ( nRtagId IN NUMBER, sReleaseName IN VARCHAR2, sReleaseComments IN VARCHAR2, nParentRtagId IN NUMBER, nMASSRtagId IN NUMBER, nConfigSpecBranch IN VARCHAR2, sOwnerEmail IN VARCHAR2, nUserId IN NUMBER, cState IN VARCHAR, nBuildAge in NUMBER,cLxr in CHAR );
 	PROCEDURE MOVE_RELEASE ( sRtagIdList IN VARCHAR2, nProjId IN NUMBER, nUserId IN NUMBER  );
 	PROCEDURE Destroy_Release ( nRtagId IN NUMBER, nUserId IN NUMBER );
 	PROCEDURE Import_Release_Contents ( nSourceRtagId IN NUMBER, nTargetRtagId IN NUMBER, nUserId IN NUMBER );
 	PROCEDURE Clean_Release_Contents ( nRtagId IN NUMBER, nUserId IN NUMBER );
 	FUNCTION GET_PARENT_RTAG ( nRtagId IN NUMBER, nSourceRtagId IN NUMBER, cIsBranch IN CHAR ) RETURN NUMBER;
   PROCEDURE ADD_RELEASE_SDK ( nRtagId IN NUMBER, nSdktagId IN NUMBER, nUserId IN NUMBER, bDelete IN  NUMBER, nInsertCount OUT NUMBER, curReturn OUT typeCur );
   PROCEDURE REMOVE_RELEASE_SDK ( nRtagId IN NUMBER, nSdktagId IN NUMBER );
   FUNCTION CAN_ADD_PKG_TO_RELEASE ( nRtagId IN NUMBER, nPvid in NUMBER ) RETURN NUMBER;
 	/*================================================================================================*/
 END PK_RELEASE;
+/
 --------------------------------------------------------
 --  DDL for Package PK_RMAPI
            VALUES (nuserid, ora_sysdatetime, nrtagid,
                    'Release has been archived to the ARCHIVE_MANAGER schema'
                   );
    END;
 /*-------------------------------------------------------------------------------------------------------*/
 END pk_archive;
+/
 --------------------------------------------------------
 --  DDL for Package Body PK_BUILDAPI
 --------------------------------------------------------
      RETURN viewid;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
+--  Add a package to the specified release
+--  Default imode: Will determine the tab ( WIP, PENDING, RELEASE ) to add the package
+--  Otherwise will Add the package to the PENDING set
+--
    PROCEDURE add_package (
      pvid    IN   NUMBER,
-     viewid   IN   NUMBER,
+     viewid  IN   NUMBER,
-     rtagid   IN   NUMBER,
+     rtagid  IN   NUMBER,
-     userid   IN   NUMBER
+     userid  IN   NUMBER,
+     imode   IN   CHAR default NULL
+   )
    IS
      dlocked   package_versions.dlocked%TYPE;
      envtab   NUMBER;
+     pendOpr CHAR := 'R';
    BEGIN
      IF can_edit_pkg_in_project (pvid, rtagid) = 1
      THEN
+       IF iMode IS NULL THEN
+         -- Determine the tab to use based on the package lock state
-       -- Get dlock state
+         -- Get dlock state
-       SELECT pv.dlocked
+         SELECT pv.dlocked
-         INTO dlocked
+           INTO dlocked
-         FROM package_versions pv
+           FROM package_versions pv
-        WHERE pv.pv_id = pvid;
+          WHERE pv.pv_id = pvid;
-       -- Get which area should go under
+         -- Get which area should go under
-       envtab := select_environment_area (dlocked);
+         envtab := select_environment_area (dlocked);
+       ELSE
+        -- Assume that the package is to be added to Pending
+        envtab := 1;
+        pendOpr := 'A';
+       END IF;
        -- Log
        --log_action (pvid, 'action', userid, 'Start of Package Add...');
-       -- Remove Package
+       -- Add Package
        IF envtab = 0
        THEN
          -- WORK IN PROGRESS --
          pk_work_in_progress.add_package (pvid, viewid, rtagid, userid);
        ELSIF envtab = 1
        THEN
          -- PENDING --
-         pk_planned.add_package (pvid, viewid, rtagid, userid);
+         pk_planned.add_package (pvid, viewid, rtagid, userid, pendOpr);
        ELSIF envtab = 2
        THEN
          -- RELEASED --
          -- NOTE: this package will be replaced with matching package
          pk_release.add_package (pvid, viewid, rtagid, userid);
 /*-------------------------------------------------------------------------------------------------------*/
    PROCEDURE add_package_bulk (
      pvidlist   IN   VARCHAR2,
      viewid    IN   NUMBER,
      rtagid    IN   NUMBER,
-     userid    IN   NUMBER
+     userid    IN   NUMBER,
+     imode     IN   CHAR DEFAULT NULL
+   )
    IS
-     nidcollector   relmgr_number_tab_t         := relmgr_number_tab_t
+     nidcollector relmgr_number_tab_t         := relmgr_number_tab_t();
-                                                        ();
      dlocked      package_versions.dlocked%TYPE;
      pvid         NUMBER;
      envtab       NUMBER;
    BEGIN
      /*--------------- Business Rules Here -------------------*/
      nidcollector := in_list_number (pvidlist);
      FOR i IN 1 .. nidcollector.COUNT
      LOOP
        pvid := nidcollector (i);
-       add_package (pvid, viewid, rtagid, userid);
+       add_package (pvid, viewid, rtagid, userid, imode);
      END LOOP;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
    PROCEDURE replace_package (
 ------------------------------
 */
 /*-------------------------------------------------------------------------------------------------------*/
-PROCEDURE ADD_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER ) IS
+PROCEDURE ADD_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER, OPR IN CHAR DEFAULT 'R' ) IS
     oldPvId NUMBER;
     ReleaseLocation VARCHAR2(4000);
     IsPatch CHAR(1) := NULL;
     sLocation VARCHAR2(4000) := NULL;
 BEGIN
     /*--------------- Business Rules Here -------------------*/
     /*-------------------------------------------------------*/
+    IF OPR = 'R' THEN
-    BEGIN
+      BEGIN
-        -- Check if Exists in "Work in progress" anywhere in the world, except "Closed mode" releases
+          -- Check if Exists in "Work in progress" anywhere in the world, except "Closed mode" releases
-        SELECT proj.PROJ_NAME ||' > '|| rt.RTAG_NAME, rt.RTAG_ID  INTO sLocation, nRtagIdLocation
+          SELECT proj.PROJ_NAME ||' > '|| rt.RTAG_NAME, rt.RTAG_ID  INTO sLocation, nRtagIdLocation
-          FROM PLANNED pl,
+            FROM PLANNED pl,
-               RELEASE_TAGS rt,
+                 RELEASE_TAGS rt,
-               PROJECTS proj
+                 PROJECTS proj
-         WHERE pl.PV_ID = newPvId
+           WHERE pl.PV_ID = newPvId
-           AND pl.RTAG_ID = rt.RTAG_ID
+             AND pl.RTAG_ID = rt.RTAG_ID
-           AND rt.OFFICIAL != 'Y'
+             AND rt.OFFICIAL != 'Y'
-           AND rt.PROJ_ID = proj.PROJ_ID;
+             AND rt.PROJ_ID = proj.PROJ_ID;
-        EXCEPTION
+          EXCEPTION
-            WHEN NO_DATA_FOUND THEN
+              WHEN NO_DATA_FOUND THEN
-                sLocation := NULL;
+                  sLocation := NULL;
-    END;
+      END;
-    IF (sLocation IS NULL) OR (nRtagIdLocation = RtagId) THEN
+      IF (sLocation IS NULL) OR (nRtagIdLocation = RtagId) THEN
-        -- Add to "Pending" area
+          -- Add to "Pending" area
-        INSERT INTO PLANNED ( RTAG_ID, PV_ID, VIEW_ID, OPERATION )
+          INSERT INTO PLANNED ( RTAG_ID, PV_ID, VIEW_ID, OPERATION )
-        VALUES( RtagId, newPvId, ViewId, 'R' );
+          VALUES( RtagId, newPvId, ViewId, OPR );
-        /* LOG ACTION */
+          /* LOG ACTION */
-        SELECT proj.PROJ_NAME ||' / '|| rt.RTAG_NAME INTO ReleaseLocation
+          SELECT proj.PROJ_NAME ||' / '|| rt.RTAG_NAME INTO ReleaseLocation
-          FROM PROJECTS proj,
+            FROM PROJECTS proj,
-               RELEASE_TAGS rt
+                 RELEASE_TAGS rt
-         WHERE rt.PROJ_ID = proj.PROJ_ID
+           WHERE rt.PROJ_ID = proj.PROJ_ID
-           AND rt.RTAG_ID = RtagId;
+             AND rt.RTAG_ID = RtagId;
-        Log_Action ( newPvId, 'add_to_planned', UserId, 'Location: '|| ReleaseLocation );
+          Log_Action ( newPvId, 'add_to_planned', UserId, 'Location: '|| ReleaseLocation );
+      ELSE
+            RAISE_APPLICATION_ERROR (-20000, 'This version is already in Pending Area at '|| sLocation ||'.' );
+        END IF;
     ELSE
+      -- Not adding a WIP. Merging a package version
-        RAISE_APPLICATION_ERROR (-20000, 'This version is already in Pending Area at '|| sLocation ||'.' );
+      MERGE_PACKAGE ( newPvId, ViewId, RtagId, UserId, OPR );
     END IF;
 END;
 /*-------------------------------------------------------------------------------------------------------*/
 PROCEDURE REMOVE_PACKAGE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER ) IS
                            nMASSRtagId IN NUMBER,
                            nConfigSpecBranch IN VARCHAR2,
                            sOwnerEmail IN VARCHAR2,
                            nUserId IN NUMBER,
                            cState IN VARCHAR,
-                           nBuildAge in NUMBER) IS
+                           nBuildAge in NUMBER,
+                           cLxr in CHAR) IS
 RecCount NUMBER := 0;
 ProjId NUMBER;
 BEGIN
    rt.PARENT_RTAG_ID = nParentRtagId,
    rt.ASSOC_MASS_REF = nMASSRtagId,
    rt.CONFIG_SPEC_BRANCH = nConfigSpecBranch,
    rt.OWNER_EMAIL = sOwnerEmail,
    rt.PRODUCT_STATE_USED = cState,
-   rt.BUILD_AGE = nBuildAge
+   rt.BUILD_AGE = nBuildAge,
+   rt.LXR = cLxr
    WHERE rt.RTAG_ID = nRtagId;
    -- Update display Order
    UPDATE_DISPLAY_ORDER ( ProjId );
    -- Clean target contents
    Clean_Release_Contents ( nTargetRtagId, nUserId );
    -- Import Released Area Contents
-   INSERT INTO RELEASE_CONTENT ( RTAG_ID, PV_ID, BASE_VIEW_ID, INSERT_STAMP, INSERTOR_ID, PKG_STATE, PKG_ID, DEPRECATED_STATE )
+   INSERT INTO RELEASE_CONTENT ( RTAG_ID, PV_ID, BASE_VIEW_ID, INSERT_STAMP, INSERTOR_ID, PKG_STATE, PKG_ID, DEPRECATED_STATE, PRODUCT_STATE, SDKTAG_ID )
    SELECT nTargetRtagId AS RTAG_ID,
          rc.PV_ID,
          rc.BASE_VIEW_ID,
          rc.INSERT_STAMP,
          rc.INSERTOR_ID,
          rc.PKG_STATE,
          rc.PKG_ID,
-         rc.DEPRECATED_STATE
+         rc.DEPRECATED_STATE,
+         rc.PRODUCT_STATE,
+         rc.SDKTAG_ID
      FROM RELEASE_CONTENT rc
     WHERE rc.RTAG_ID = nSourceRtagId;
    -- Import any Pegged Version settings from the source release
   sName VARCHAR2(1000) := name;
   sNameLen NUMBER;
 BEGIN
   sNameLen := LENGTH(sName);
-  IF sNameLen >= 150 Then
+  IF sNameLen >= 199 Then
-    sName := '...' || SUBSTR(sName, sNameLen - 147);
+    sName := '...' || SUBSTR(sName, sNameLen - 196);
   END IF;
   INSERT into TEST_RUN
     (BUILD_ID, TEST_NAME, TEST_OUTCOME, TIME_TAKEN,FAIL_MESSAGE,PLATFORM, TYPE)
     VALUES(build_id,sName,outcome, duration, message, platform, stype);
 BEGIN
 	/*--------------- Business Rules Here -------------------*/
 	/*-------------------------------------------------------*/
 	BEGIN
-		-- Check if Exists in "Work in progress" anywhere in the world, except "Closed mode" releases
+		-- Check if Exists in "Work in progress" anywhere in the world in a non-closed Release
 		SELECT proj.PROJ_NAME ||' > '|| rt.RTAG_NAME  INTO sLocation
 		  FROM WORK_IN_PROGRESS wip,
 		  	   RELEASE_TAGS rt,
 			   PROJECTS proj
 		 WHERE wip.PV_ID = newPvId
 		   AND wip.RTAG_ID = rt.RTAG_ID
-		   AND rt.OFFICIAL != 'Y'
+		   AND rt.OFFICIAL in ('N','R','C')
 		   AND rt.PROJ_ID = proj.PROJ_ID;
 		EXCEPTION
 	    	WHEN NO_DATA_FOUND THEN
 	       		sLocation := NULL;
 --------------------------------------------------------
 --  DDL for Procedure ADD_PACKAGE_INTEREST
 --------------------------------------------------------
 set define off;
-  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."ADD_PACKAGE_INTEREST" (nProjId IN PROJECTS.PROJ_ID%TYPE,
+  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."ADD_PACKAGE_INTEREST" (
-	   	  		  								  nPkgIdList IN VARCHAR2,
+    nProjId    IN PROJECTS.PROJ_ID%TYPE,
-												  nUserId IN NUMBER
+    nPkgIdList IN VARCHAR2,
-	   	  		  								  ) IS
+    nUserId    IN NUMBER )
+IS
-/******************************************************************************
+  npkgidcollector relmgr_number_tab_t := relmgr_number_tab_t ();
-   NAME:       ADD_PACKAGE_INTEREST
+  nPkgId        NUMBER;
-   PURPOSE:
+  alreadyExists NUMBER;
-   REVISIONS:
+BEGIN
-   Ver        Date        Author           Description
+  npkgidcollector := in_list_number2 (nPkgIdList);
-   ---------  ----------  ---------------  ------------------------------------
-.0        12/05/2006  Rupesh Solanki     1. Created this procedure.
+  FOR i IN 1..npkgidcollector.COUNT
-   NOTES:
+  LOOP
-   Automatically available Auto Replace Keywords:
+    nPkgId := npkgidcollector(i);
-      Object Name:     ADD_PACKAGE_INTEREST
+    --- Ensure it doesn't already exist
-      Sysdate:         12/05/2006
+    SELECT COUNT(*)
-      Date and Time:   12/05/2006, 9:11:12 AM, and 12/05/2006 9:11:12 AM
-      Username:         (set in TOAD Options, Procedure Editor)
+    INTO alreadyExists
-      Table Name:       (set in the "New PL/SQL Object" dialog)
+    FROM PACKAGE_INTEREST
-******************************************************************************/
-   npkgidcollector   relmgr_number_tab_t := relmgr_number_tab_t ();
+    WHERE USER_ID      = nUserId
-   nPkgId NUMBER;
+    AND PKG_ID         = nPkgId
-BEGIN
-	 npkgidcollector := in_list_number2 (nPkgIdList);
+    AND PROJ_ID        = nProjId;
-	FOR i IN 1..npkgidcollector.COUNT
+    IF ( alreadyExists = 0 ) THEN
-	LOOP
-		nPkgId := npkgidcollector(i);
-	 --- Insert into PACKAGE_INTEREST TABLE
+      --- Insert into PACKAGE_INTEREST TABLE
+      INSERT
-	 INSERT INTO PACKAGE_INTEREST (PROJ_ID, PKG_ID, USER_ID)
+        INTO PACKAGE_INTEREST (PROJ_ID, PKG_ID, USER_ID )
-	 VALUES(nProjId, nPkgId, nUserId);
+        VALUES (nProjId, nPkgId, nUserId );
+    END IF;
-	END LOOP;
+  END LOOP;
 END ADD_PACKAGE_INTEREST;
+/
 --------------------------------------------------------
---  DDL for Procedure ADD_PACKAGE_INTEREST_TEST
---------------------------------------------------------
-set define off;
-  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."ADD_PACKAGE_INTEREST_TEST" (nProjId IN PROJECTS.PROJ_ID%TYPE,
-	   	  		  								  nPkgIdList IN VARCHAR2,
-												  nUserId IN NUMBER
-	   	  		  								  ) IS
-/******************************************************************************
-   NAME:       ADD_PACKAGE_INTEREST
-   PURPOSE:
-   REVISIONS:
-   Ver        Date        Author           Description
-   ---------  ----------  ---------------  ------------------------------------
-.0        12/05/2006  Rupesh Solanki     1. Created this procedure.
-   NOTES:
-   Automatically available Auto Replace Keywords:
-      Object Name:     ADD_PACKAGE_INTEREST
-      Sysdate:         12/05/2006
-      Date and Time:   12/05/2006, 9:11:12 AM, and 12/05/2006 9:11:12 AM
-      Username:         (set in TOAD Options, Procedure Editor)
-      Table Name:       (set in the "New PL/SQL Object" dialog)
-******************************************************************************/
-   npkgidcollector   relmgr_number_tab_t := relmgr_number_tab_t ();
-   nPkgId NUMBER;
-BEGIN
-	 npkgidcollector := in_list_number2 (nPkgIdList);
-	FOR i IN 1..npkgidcollector.COUNT
-	LOOP
-		nPkgId := npkgidcollector(i);
-	 --- Insert into PACKAGE_INTEREST TABLE
-	 INSERT INTO PACKAGE_INTEREST (PROJ_ID, PKG_ID, USER_ID)
-	 VALUES(nProjId, nPkgId, nUserId);
-	END LOOP;
-END ADD_PACKAGE_INTEREST_TEST;
-/
---------------------------------------------------------
 --  DDL for Procedure ADD_RUNTIME_DEPENDENCY
 --------------------------------------------------------
 set define off;
   CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."ADD_RUNTIME_DEPENDENCY" ( NNpv_id IN NUMBER,
 	||	1 - Open Mode
 	||	2 - Restrictive Mode
 	||	3 - Closed Mode
 	||	4 - CCB Mode
 	||	5 - Archive Mode
+  ||  6 - Preserve Mode
 	*/
 	-- Get project Id
 	SELECT rt.PROJ_ID INTO nProjId
 	  FROM RELEASE_TAGS rt
 	 WHERE rt.RTAG_ID = nRtagId;
 		cMode := 'A';
 		/* LOG ACTION */
    		Log_Project_Action ( nProjId, 'set_to_archive_mode', UserId, 'Release is set to Archive Mode', nRtagId  );
+  ELSIF nModeCode = 6 THEN
+		-- Archive Mode
+		cMode := 'P';
+		/* LOG ACTION */
+   		Log_Project_Action ( nProjId, 'set_to_archive_mode', UserId, 'Release is set to Preserve Mode', nRtagId  );
 	END IF;
 	-- Now update table
 --------------------------------------------------------
 --  DDL for Procedure DEPRECATE_PACKAGE
 --------------------------------------------------------
 set define off;
-  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."DEPRECATE_PACKAGE" (nPvId IN PACKAGE_VERSIONS.PV_ID%TYPE,
+  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."DEPRECATE_PACKAGE" (
+    nPvId     IN PACKAGE_VERSIONS.PV_ID%TYPE,
-	   	  		  							   nRtagId IN DEPRECATED_PACKAGES.RTAG_ID%TYPE,
+    nRtagId   IN DEPRECATED_PACKAGES.RTAG_ID%TYPE,
-	   	  		  							   nPkgId IN DEPRECATED_PACKAGES.PKG_ID%TYPE,
+    nPkgId    IN DEPRECATED_PACKAGES.PKG_ID%TYPE,
-											   sComments IN DEPRECATED_PACKAGES.COMMENTS%TYPE,
+    sComments IN DEPRECATED_PACKAGES.COMMENTS%TYPE,
-											   nUserId IN NUMBER) IS
+    nUserId   IN NUMBER)
-ext VARCHAR2(50);
+IS
+  ext VARCHAR2(50);
 BEGIN
+  --Extract the package version extension
+  SELECT V_EXT INTO ext
+  FROM PACKAGE_VERSIONS
+  WHERE PV_ID = nPvId;
+  -- Deprecate Package
+  INSERT INTO DEPRECATED_PACKAGES
+    ( RTAG_ID, PKG_ID, COMMENTS, V_EXT )
+    VALUES ( nRtagId, nPkgId, sComments, ext );
+  -- Update Release Contents entry
+  -- Process PackageName.ext for the package. ie: Allow multiple
+  -- versions of the package to be in the release.
+    UPDATE RELEASE_CONTENT
+    SET
+      DEPRECATED_STATE = 6
+    WHERE RTAG_ID      = nRtagId
+    AND PV_ID IN (
+      SELECT PV.PV_ID
+      FROM PACKAGE_VERSIONS PV
+      WHERE PV.PKG_ID   = nPkgId
+      AND NVL(PV.V_EXT, '.NULL') = NVL(ext,'.NULL')
+      );
-	--Extract the package version extension
-	SELECT V_EXT into ext
-	FROM PACKAGE_VERSIONS
-	WHERE PV_ID = nPvId;
-    -- Deprecate Package
+  -- Update consumers of the package
-    INSERT INTO DEPRECATED_PACKAGES (RTAG_ID, PKG_ID, COMMENTS, V_EXT)
-	VALUES (nRtagId, nPkgId, sComments, ext);
+  --  Update ALL packages in the Release
-	IF ext IS NOT NULL THEN
-	   UPDATE RELEASE_CONTENT
-	   SET PKG_ID = nPkgId, DEPRECATED_STATE = 6
-	   WHERE RTAG_ID = nRtagId
-	   AND PV_ID IN (SELECT PV.PV_ID
-		   	  	  	FROM PACKAGE_VERSIONS PV, PACKAGES PKG
-				  	WHERE PKG.PKG_ID = PV.PKG_ID
-				  	AND PV.V_EXT = ext
-				  	AND PKG.PKG_ID = nPkgId
-				 	);
-	ELSE
-	   UPDATE RELEASE_CONTENT
-	   SET PKG_ID = nPkgId, DEPRECATED_STATE = 6
-	   WHERE RTAG_ID = nRtagId
-	   AND PV_ID IN (SELECT PV.PV_ID
-		   	  	  	FROM PACKAGE_VERSIONS PV, PACKAGES PKG
-				  	WHERE PKG.PKG_ID = PV.PKG_ID
-				  	AND PV.V_EXT IS NULL
-				  	AND PKG.PKG_ID = nPkgId
-				 	);
-	END IF;
-	UPDATE RELEASE_CONTENT
-	SET PKG_ID = nPkgId, DEPRECATED_STATE = 7
-	WHERE RTAG_ID = nRtagId
-	AND PV_ID IN (		   SELECT DISTINCT
- 	 		  	 		   qry.PV_ID
-						        FROM (
-								 	  SELECT dep.*,
-									  LEVEL AS LEVEL_NUM
-									  FROM PACKAGE_DEPENDENCIES dep
- 								START WITH dep.DPV_ID IN ( nPvId )
-								CONNECT BY PRIOR dep.PV_ID = dep.DPV_ID
- 								) qry,
-								PACKAGES pkg,
-								PACKAGE_VERSIONS pv,
-								RELEASE_CONTENT rc
-						 	 WHERE qry.PV_ID = pv.PV_ID AND pv.PKG_ID = pkg.PKG_ID
-							 AND rc.RTAG_ID = nRtagId AND rc.PV_ID = qry.PV_ID
-							 AND rc.DEPRECATED_STATE IS NULL
+  REBUILD_DEPRECATE_STATE(nRtagId);
-				 );
-    /* LOG ACTION */
-   	/*Log_Action ( nPkgId, 'deprecated_package', nUserId );*/
+  /* LOG ACTION */
+  /*Log_Action ( nPkgId, 'deprecated_package', nUserId );*/
 END Deprecate_Package;
+/
 --------------------------------------------------------
 --  DDL for Procedure DT_DROPUSEROBJECTBYID
 --------------------------------------------------------
 --  DDL for Procedure DT_SETPROPERTYBYID
 --------------------------------------------------------
 set define off;
-  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."DT_SETPROPERTYBYID" ( PARAM_ID   IN NUMBER, PARAM_PROPERTY IN VARCHAR2, PARAM_VALUE  IN VARCHAR2, PARAM_LVALUE  IN LONG RAW ) AS BEGIN DECLARE X NUMBER(40); BEGIN SELECT COUNT(*) INTO X FROM MICROSOFTDTPROPERTIES WHERE OBJECTID=PARAM_ID AND PROPERTY=PARAM_PROPERTY; IF X = 0 THEN INSERT INTO MICROSOFTDTPROPERTIES (ID, PROPERTY, OBJECTID, VALUE, LVALUE, VERSION) VALUES (MICROSOFTSEQDTPROPERTIES.NEXTVAL, PARAM_PROPERTY, PARAM_ID, PARAM_VALUE, PARAM_LVALUE, 0); ELSE UPDATE MICROSOFTDTPROPERTIES SET VALUE=PARAM_VALUE, LVALUE=PARAM_LVALUE, VERSION=VERSION+1 WHERE OBJECTID=PARAM_ID AND PROPERTY=PARAM_PROPERTY; END IF; END; END DT_SETPROPERTYBYID;
+  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."DT_SETPROPERTYBYID" (
+    PARAM_ID       IN NUMBER,
+    PARAM_PROPERTY IN VARCHAR2,
+    PARAM_VALUE    IN VARCHAR2,
+    PARAM_LVALUE   IN LONG RAW )
+AS
+BEGIN
+  DECLARE
+    X NUMBER(38);
+  BEGIN
+    SELECT COUNT(*)
+    INTO X
+    FROM MICROSOFTDTPROPERTIES
+    WHERE OBJECTID=PARAM_ID
+    AND PROPERTY  =PARAM_PROPERTY;
+    IF X          = 0 THEN
+      INSERT
+      INTO MICROSOFTDTPROPERTIES
+        (
+          ID,
+          PROPERTY,
+          OBJECTID,
+          VALUE,
+          LVALUE,
+          VERSION
+        )
+        VALUES
+        (
+          MICROSOFTSEQDTPROPERTIES.NEXTVAL,
+          PARAM_PROPERTY,
+          PARAM_ID,
+          PARAM_VALUE,
+          PARAM_LVALUE,
+        );
+    ELSE
+      UPDATE MICROSOFTDTPROPERTIES
+      SET VALUE     =PARAM_VALUE,
+        LVALUE      =PARAM_LVALUE,
+        VERSION     =VERSION+1
+      WHERE OBJECTID=PARAM_ID
+      AND PROPERTY  =PARAM_PROPERTY;
+    END IF;
+  END;
+END DT_SETPROPERTYBYID;
+/
 --------------------------------------------------------
 --  DDL for Procedure IGNORE_DEPENDENCY_WARNINGS
 --------------------------------------------------------
 /* ---------------------------------------------------------------------------
     Version: 3.0.1
    --------------------------------------------------------------------------- */
    previteration   NUMBER := nniteration - 1;
 BEGIN
+  -- Map broken dependency information from a package into a consumer
+  -- package. ie: Ripple need-to-build info up the dependency tree.
    /* ---------  LEVEL 1 CONFILCTS -----------
    || Following states are used:
    || 0 -> NOT FOUND
    || 1 -> MAJOR
    || 2 -> MINOR MINOR
    */
    INSERT INTO temp_env_states
-      SELECT DISTINCT nnsession_num AS session_num, nniteration AS level_num,
+               SELECT DISTINCT nnsession_num AS session_num, nniteration AS level_num,
-                      pv.pv_id, pv.pkg_id, pv.v_ext,
+                      dpv.pv_id, dpv.pkg_id, dpv.v_ext,
                       DECODE (tes.tes_state, 2, 2, 1) AS MESSAGE
-                 FROM package_dependencies dep,
-                      package_versions dpv,
+                 FROM TEMP_ENV_DEPS dpv,
-                      package_versions pv,
-                      release_content rel,
                       temp_env_states tes
-                WHERE rel.pv_id = dep.pv_id
+                WHERE dpv.SESSION_NUM = nnsession_num
-                  AND rel.rtag_id = nnrtag_id
-                  AND dep.pv_id = pv.pv_id
-                  AND dep.dpv_id = dpv.pv_id
-                  AND dpv.pkg_id = tes.pkg_id
+                  AND dpv.dpkg_id = tes.pkg_id
-                  AND NVL (dpv.v_ext, '|LINK_A_NULL|') = NVL (tes.v_ext, '|LINK_A_NULL|')
+                  AND NVL (dpv.dv_ext, '|LINK_A_NULL|') = NVL (tes.v_ext, '|LINK_A_NULL|')
                   AND tes.session_num = nnsession_num
-                  AND tes.level_num = previteration
+                  AND tes.level_num = previteration;
-                  AND (dep.pv_id, dep.dpv_id) IN
-                                                   /* Remove packages listed in IGNORE_WARNINGS table
-                                                      and PEGGED packages
-                                                      and packages already stored in Temp Table.
-                                                 */
-                      (
-                         SELECT pd.pv_id, pd.dpv_id
-                           FROM package_dependencies pd, release_content rc
-                          WHERE pd.pv_id = rc.pv_id AND rc.rtag_id = nnrtag_id
-                           AND NOT pd.pv_id IN (SELECT pegv.pv_id FROM PEGGED_VERSIONS pegv WHERE pegv.rtag_id = nnrtag_id)
-                          -- AND pd.pv_id NOT IN ( SELECT pv_id FROM temp_env_states WHERE session_num = NNsession_num AND level_num > 5 )
-                         MINUS
-                         SELECT igw.pv_id, igw.dpv_id
-                           FROM ignore_warnings igw
-                          WHERE igw.rtag_id = nnrtag_id);
    nnrowcnt := SQL%ROWCOUNT;
 END level_n_conflicts;
+/
    nnrtag_id       IN   NUMBER,
    nnsession_num   IN   NUMBER
+)
 IS
 BEGIN
+  --  Prepare the TEMP_ENV_DEPS table
+  --  This table maps package-versions to their dependencies and is
+  --  used to walk up the dependency tree.
+  --  This table consists of PV_ID -> DPV_ID in the release in which we are interested
+  --  ie: Those that ARE NOT a part of:
+  --    Pegged Package
+  --    SDK imported package
+  --    Marked with an ignore warnings
+  --    Marked as an advisory ripple
+  --
+  --  This table speeds up the process by a huge (really huge) amount
+  --
+      INSERT into TEMP_ENV_DEPS
+      (
+      SELECT DISTINCT nnsession_num AS session_num,
+                      pv.pv_id, pv.pkg_id, pv.v_ext,
+                      dpv.pv_id as dpv_id, dpv.pkg_id as dpkg_id, dpv.v_ext as dv_ext
+                 FROM release_content rel,
+                      package_dependencies dep,
+                      package_versions dpv,
+                      package_versions pv
+                WHERE rel.pv_id = dep.pv_id
+                  AND rel.rtag_id = nnrtag_id
+                  AND dep.pv_id = pv.pv_id
+                  AND dep.dpv_id = dpv.pv_id
+                  --AND rel.SDKTAG_ID is null
+                  --AND NOT dep.pv_id IN (SELECT pegv.pv_id FROM PEGGED_VERSIONS pegv WHERE pegv.rtag_id = nnrtag_id)
+                  AND NOT (dep.pv_id, dep.dpv_id) in (SELECT igw.pv_id, igw.DPV_ID from ignore_warnings igw where igw.rtag_id = nnrtag_id)
+                  );
    /* ---------  LEVEL 1 CONFILCTS -----------
    || Following states are used:
    || 0 -> NOT FOUND
    || 1 -> MAJOR
    || 2 -> MINOR MINOR
                  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,
-                                (SELECT COUNT(*)
-                                   FROM ADVISORY_RIPPLE avr
-                                  WHERE avr.rtag_id = rel.rtag_id
+                                (SELECT COUNT(*) FROM ADVISORY_RIPPLE avr WHERE avr.rtag_id = rel.rtag_id AND avr.pv_id = rel.pv_id ) AS IsAvr
-                                    AND avr.pv_id = rel.pv_id
-                                ) AS IsAvr
                           FROM release_content rel,
                                 package_versions rpv
                           WHERE rel.pv_id = rpv.pv_id
                              AND rtag_id = nnrtag_id
                       ) frc,
+                      (
-                       /* DPV_IDs not found in release (excluding those from pegged versions whose dependencies will not
+                       /* DPV_IDs not found in release. Excluding:
+                              Those from pegged versions
-                          necessarily be satisfied in the release) */
+                              Those from packages imported via an SDK
+                              */
                        SELECT dep.pv_id, dep.dpv_id AS err_dpv
-                         FROM package_dependencies dep,
+                         FROM package_dependencies dep
-                              package_versions dep_dpv
-                        WHERE dep.dpv_id = dep_dpv.pv_id
-                          AND dep.pv_id IN (SELECT pv_id FROM release_content WHERE rtag_id = nnrtag_id)
+                        WHERE dep.pv_id IN (SELECT pv_id FROM release_content WHERE rtag_id = nnrtag_id AND release_content.SDKTAG_ID is NULL)
                           AND NOT dep.pv_id IN (SELECT pegv.pv_id FROM PEGGED_VERSIONS pegv WHERE pegv.rtag_id = nnrtag_id)
                           AND NOT dep.dpv_id IN (SELECT pv_id FROM release_content WHERE rtag_id = nnrtag_id)
                        MINUS
                        /* MINUS Dependencies to be ignored */
                        SELECT igw.pv_id, igw.dpv_id AS err_dpv
-                         FROM ignore_warnings igw,
+                         FROM ignore_warnings igw
-                              package_versions igw_dpv
-                        WHERE igw.dpv_id = igw_dpv.pv_id
+                        WHERE igw.rtag_id = nnrtag_id
-                          AND igw.rtag_id = nnrtag_id
                       ) err,
                       package_versions errpkg,
                       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 frc.IsAvr = 0;
+                  AND NVL(frc.IsAvr,0) = 0;
 END level_one_conflicts;
+/
 --------------------------------------------------------
 --  DDL for Procedure LOCK_PACKAGE
 END PAOLO_Build_Tree;
+/
 --------------------------------------------------------
+--  DDL for Procedure REBUILD_DEPRECATE_STATE
+--------------------------------------------------------
+set define off;
+  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."REBUILD_DEPRECATE_STATE" ( nRtagId IN INT ) AS
+BEGIN
+  --  Clear the 'calculated' values from the Release Conetnts
+  --
+  UPDATE RELEASE_CONTENT
+      SET DEPRECATED_STATE = NULL
+  WHERE RTAG_ID =  nRtagId
+  AND DEPRECATED_STATE != 6
+  AND DEPRECATED_STATE is NOT NULL;
+  --
+  --  Insert new calculated values into the table
+  --  Use of 'AAA' speeds up the CONNECT BY PRIOR query (lots)
+  UPDATE RELEASE_CONTENT
+      SET DEPRECATED_STATE = 7
+  WHERE RTAG_ID =  nRtagId
+  AND DEPRECATED_STATE is null
+  AND PV_ID in (
+        WITH AAA AS
+          (SELECT pd.*
+          FROM PACKAGE_DEPENDENCIES pd,
+            RELEASE_CONTENT RC1
+          WHERE rc1.rtag_id = nRtagId
+          AND RC1.PV_ID     = pd.PV_ID
+          )
+      SELECT DISTINCT qry.PV_ID
+      FROM
+        (SELECT dep.*,
+          LEVEL AS LEVEL_NUM
+        FROM AAA dep
+          START WITH dep.DPV_ID IN (
+                SELECT rc.pv_id as pv_id
+                FROM RELEASE_CONTENT rc
+                WHERE rc.rtag_id  = nRtagId
+                AND rc.DEPRECATED_STATE = 6 )
+          CONNECT BY PRIOR dep.PV_ID = dep.DPV_ID
+        ) qry,
+        PACKAGES pkg,
+        PACKAGE_VERSIONS pv,
+        RELEASE_CONTENT rc
+      WHERE qry.PV_ID          = pv.PV_ID
+      AND pv.PKG_ID            = pkg.PKG_ID
+      AND rc.RTAG_ID           = nRtagId
+      AND rc.PV_ID             = qry.PV_ID
+      );
+END REBUILD_DEPRECATE_STATE;
+/
+--------------------------------------------------------
 --  DDL for Procedure REBUILD_ENVIRONMENT
 --------------------------------------------------------
 set define off;
   CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."REBUILD_ENVIRONMENT" ( NNrtag_id IN NUMBER ) IS
+  --
-/* ---------------------------------------------------------------------------
+  --  Recalculate the package_state
-    Version: 3.3
+  --  Triggered by the Web Interface
-   --------------------------------------------------------------------------- */
+  --
     rowCnt NUMBER := 0;
     iteration NUMBER := 2;          -- Iterations counter
-    maxIterations NUMBER := 50;    -- Maximum number of iterations allowed.
+    maxIterations NUMBER := 30;     -- Maximum number of iterations allowed.
                                     -- This will prevent infinite loops if cyrcular dependencies are found
     sessionNum NUMBER;
 BEGIN
     SELECT SEQ_session_num.nextval INTO sessionNum FROM DUAL;
     -- Redo Patch Ignore warnings
     Ignore_Dependency_Warnings ( NNrtag_id, NULL, NULL, TRUE );
     Level_One_Conflicts ( NNrtag_id, sessionNum );
+    --commit;
     LOOP
         Level_N_Conflicts ( NNrtag_id, sessionNum, rowCnt, iteration );
+        --commit;
         iteration := iteration + 1;
         EXIT WHEN (rowCnt < 1) OR (iteration > maxIterations);
     END LOOP;
     Update_Package_States ( NNrtag_id, sessionNum );
-    DELETE FROM temp_env_states WHERE temp_env_states.session_num = sessionNum;
+    DELETE FROM temp_env_states WHERE session_num = sessionNum;
+    DELETE FROM TEMP_ENV_DEPS WHERE session_num = sessionNum;
     -- Flag Packages with New Patches Available
     Check_New_Patches ( NNrtag_id );
 	Clean_Do_Not_Ripple( NNrtag_id );
     */
 END Rebuild_Environment;
+/
 --------------------------------------------------------
---  DDL for Procedure RELEASE_MANAGER_MAILOUT
---------------------------------------------------------
-set define off;
-  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."RELEASE_MANAGER_MAILOUT" (
-  sender      IN VARCHAR2,
-  recipient   IN VARCHAR2,
-  ccrecipient IN VARCHAR2,
-  subject     IN VARCHAR2,
-  message     IN VARCHAR2
-  ) IS
-  crlf VARCHAR2(2):= UTL_TCP.CRLF;
-  connection utl_smtp.connection;
-  mailhost VARCHAR2(30) := 'aupera03.aupera.erggroup.com';
-  header VARCHAR2(1000);
-BEGIN
-  --
-  -- Start the connection.
-  --
-  connection := utl_smtp.open_connection(mailhost,25);
-  header:= 'Date: '||TO_CHAR(SYSDATE,'dd Mon yy hh24:mi:ss')||crlf||
-     'From: '||sender||''||crlf||
-  'Subject: '||subject||crlf||
-       'To: '||recipient||crlf||
-       'CC: '||ccrecipient;
-  --
-  -- Handshake with the SMTP server
-  --
-  utl_smtp.helo(connection, mailhost);
-  utl_smtp.mail(connection, sender);
-  utl_smtp.rcpt(connection, recipient);
-  utl_smtp.rcpt(connection, ccrecipient);
-  utl_smtp.open_data(connection);
-  --
-  -- Write the header
-  --
-  utl_smtp.write_data(connection, header);
-  --
-  -- The crlf is required to distinguish that what comes next is not simply part of the header..
-  --
-  utl_smtp.write_data(connection, crlf ||message);
-  utl_smtp.close_data(connection);
-  utl_smtp.quit(connection);
-EXCEPTION
-  WHEN UTL_SMTP.INVALID_OPERATION THEN
-    dbms_output.put_line(' Invalid Operation in SMTP transaction.');
-  WHEN UTL_SMTP.TRANSIENT_ERROR THEN
-    dbms_output.put_line(' Temporary problems with sending email - try again later.');
-  WHEN UTL_SMTP.PERMANENT_ERROR THEN
-    dbms_output.put_line(' Errors in code for SMTP transaction.');
-END RELEASE_MANAGER_MAILOUT;
-/
---------------------------------------------------------
 --  DDL for Procedure REMOVE_COMPONENTS
 --------------------------------------------------------
 set define off;
   CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."REMOVE_COMPONENTS" ( nPvId IN RELEASE_COMPONENTS.PV_ID%TYPE ) IS
 --------------------------------------------------------
 --  DDL for Procedure UNDEPRECATE_PACKAGE
 --------------------------------------------------------
 set define off;
-  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."UNDEPRECATE_PACKAGE" (nPvId IN PACKAGE_VERSIONS.PV_ID%TYPE,
+  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."UNDEPRECATE_PACKAGE" (
+    nPvId   IN PACKAGE_VERSIONS.PV_ID%TYPE,
-	   	  		  								 nRtagId IN DEPRECATED_PACKAGES.RTAG_ID%TYPE,
+    nRtagId IN DEPRECATED_PACKAGES.RTAG_ID%TYPE,
-	   	  		  							   	 nPkgId IN DEPRECATED_PACKAGES.PKG_ID%TYPE,
+    nPkgId  IN DEPRECATED_PACKAGES.PKG_ID%TYPE,
-											   	 nUserId IN NUMBER) IS
+    nUserId IN NUMBER)
+IS
-ext VARCHAR2(50);
+  ext      VARCHAR2(50);
-PvIdList VARCHAR2(32767);
-nIdCollector RELMGR_NUMBER_TAB_t := RELMGR_NUMBER_TAB_t();
-PvId NUMBER;
-sComments VARCHAR2(32767);
-BEGIN
+BEGIN
+  --Extract the package extension
+  SELECT V_EXT INTO ext
+  FROM PACKAGE_VERSIONS
+  WHERE PV_ID = nPvId;
+    -- Undeprecate Package
+    DELETE
+    FROM DEPRECATED_PACKAGES
+    WHERE RTAG_ID = nRtagId
+    AND PKG_ID    = nPkgId
+    AND NVL(V_EXT,'.NULL') = NVL(ext,'.NULL');
+    -- Update Release Contents entry
+    -- Process PackageName.ext for the package. ie: Allow multiple
+    -- versions of the package to be in the release.
+    UPDATE RELEASE_CONTENT
+    SET
+      DEPRECATED_STATE = NULL
+    WHERE RTAG_ID      = nRtagId
+    AND PV_ID IN (
+      SELECT PV.PV_ID
+      FROM PACKAGE_VERSIONS PV
+      WHERE PV.PKG_ID   = nPkgId
+      AND NVL(PV.V_EXT, '.NULL') = NVL(ext,'.NULL')
+      );
-	--Extract the package extension
-	SELECT V_EXT into ext
-	FROM PACKAGE_VERSIONS
-	WHERE PV_ID = nPvId;
-	--SELECT COMMENTS into sComments
-	--FROM DEPRECATED_PACKAGES
-	--WHERE RTAG_ID = nRtagId
-	--AND V_EXT = ext
-	--AND PKG_ID = nPkgId;
-	--SELECT PV_ID into PvIdList FROM
-	--RELEASE_CONTENT WHERE RTAG_ID = nRtagId
-	--AND PKG_STATE = 6
-	--AND PV_ID NOT IN nPvId;
-	IF ext IS NOT NULL THEN
-       -- Undeprecate Package
+  -- Update consumers of the package
-       DELETE FROM DEPRECATED_PACKAGES
-	   WHERE RTAG_ID = nRtagId
-	   AND PKG_ID = nPkgId
-	   AND V_EXT = ext;
-		UPDATE RELEASE_CONTENT
-		SET PKG_ID = NULL, DEPRECATED_STATE = NULL
-		WHERE RTAG_ID = nRtagId
-		AND PV_ID IN (SELECT PV.PV_ID
-				  	  FROM PACKAGE_VERSIONS PV, PACKAGES PKG
-					  WHERE PKG.PKG_ID = PV.PKG_ID
-					  AND PKG.PKG_ID = nPkgId
-					  AND PV.V_EXT = ext
-					  UNION
-					  SELECT DISTINCT
-	 	 		  	 		   qry.PV_ID
-							        FROM (
-									 	  SELECT dep.*,
-										  LEVEL AS LEVEL_NUM
-										  FROM PACKAGE_DEPENDENCIES dep
-	 								START WITH dep.DPV_ID IN ( nPvId )
-									--AND dep.DPV_ID NOT IN ( SELECT PV_ID FROM RELEASE_CONTENT WHERE RTAG_ID = nRtagId AND PKG_STATE = 6 )
-									CONNECT BY PRIOR dep.PV_ID = dep.DPV_ID
-	 								) qry,
-									PACKAGES pkg,
-									PACKAGE_VERSIONS pv,
-									RELEASE_CONTENT rc
-							 	 WHERE qry.PV_ID = pv.PV_ID AND pv.PKG_ID = pkg.PKG_ID
-								 AND rc.RTAG_ID = nRtagId AND rc.PV_ID = qry.PV_ID
-					 );
-	ELSE
-       -- Undeprecate Package
+  --  Update ALL packages in the Release
-       DELETE FROM DEPRECATED_PACKAGES
-	   WHERE RTAG_ID = nRtagId
-	   AND PKG_ID = nPkgId
-	   AND V_EXT IS NULL;
-		UPDATE RELEASE_CONTENT
-		SET PKG_ID = NULL, DEPRECATED_STATE = NULL
-		WHERE RTAG_ID = nRtagId
-		AND PV_ID IN (SELECT PV.PV_ID
-				  	  FROM PACKAGE_VERSIONS PV, PACKAGES PKG
-					  WHERE PKG.PKG_ID = PV.PKG_ID
-					  AND PKG.PKG_ID = nPkgId
-					  AND PV.V_EXT IS NULL
-					  UNION
-					  SELECT DISTINCT
-	 	 		  	 		   qry.PV_ID
-							        FROM (
-									 	  SELECT dep.*,
-										  LEVEL AS LEVEL_NUM
-										  FROM PACKAGE_DEPENDENCIES dep
-	 								START WITH dep.DPV_ID IN ( nPvId )
-									--AND dep.DPV_ID NOT IN ( SELECT PV_ID FROM RELEASE_CONTENT WHERE RTAG_ID = nRtagId AND PKG_STATE = 6 )
-									CONNECT BY PRIOR dep.PV_ID = dep.DPV_ID
-	 								) qry,
-									PACKAGES pkg,
-									PACKAGE_VERSIONS pv,
-									RELEASE_CONTENT rc
-							 	 WHERE qry.PV_ID = pv.PV_ID AND pv.PKG_ID = pkg.PKG_ID
-								 AND rc.RTAG_ID = nRtagId AND rc.PV_ID = qry.PV_ID
-					 );
-	END IF;
-	--IF PvIdList IS NOT NULL THEN
-	 --  nIdCollector := IN_LIST_NUMBER ( PvIdList );
-	 --  FOR i IN 1..nIdCollector.COUNT
-	 --  LOOP
-	--	   PvId := nIdCollector(i);
-	--		Deprecate_Package (nPvId, nRtagId, nPkgId, sComments, nUserId );
-	--		END LOOP;
-	--END IF;
-	Rebuild_environment(nRtagId);
+  REBUILD_DEPRECATE_STATE(nRtagId);
 END Undeprecate_Package;
+/
 --------------------------------------------------------

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/database/Relman_export.sql @ 5384 – Rev 5172 → 5384