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



--------------------------------------------------------
--  File created - Tuesday-April-09-2019   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Type RELMGR_NUMBER_TAB_T
--------------------------------------------------------
 

   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BSA_ID"  MINVALUE 8 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 48 CACHE 20 NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_BUILD_INSTANCE
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 240932 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_CR_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_CR_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 95272 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_DAEMON_INSTRUCTION_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 179295 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_GBE_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_GBE_ID"  MINVALUE 40 MAXVALUE 9999999999999999999999990 INCREMENT BY 1 START WITH 1245 NOCACHE  ORDER  NOCYCLE ;

   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_MSG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 582 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_PKG_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PKG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 68063 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_PROJ_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PROJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1041 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_PV_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1238088 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_RCON_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RCON_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 36790 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_RELEASE_MOD
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RELEASE_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 298803 CACHE 20 NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_RTAG_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RTAG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 39631 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_SCHEDULED_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SCHEDULED_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 30074 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_SDKTAG_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDKTAG_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1563 CACHE 20 NOORDER  NOCYCLE ;

   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDK_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 163 CACHE 20 NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_SESSION_NUM
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SESSION_NUM"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1110364 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_TESTRUN_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_TESTRUN_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 2141643 CACHE 20 NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_UNIT_TESTS
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 375956 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_USER_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_USER_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 3961 CACHE 20 ORDER  NOCYCLE ;

   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VIEW_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 10341 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Sequence SEQ_VTREE_ID
--------------------------------------------------------
 
   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VTREE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 36310 CACHE 20 ORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Table ABT_ACTION_LOG
--------------------------------------------------------
 
  CREATE TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG" 

    THEN
		/* Make sure it does not exists already as runtime dependency */
 
		--- Add new Runtime Dependency ---
	    INSERT INTO runtime_dependencies ( pv_id, rtd_id, mod_date, mod_user )
	    VALUES (  NNpv_id, retRTD_ID, ora_sysdatetime , NNuser_id );
 
    	/* LOG ACTION */
        Log_Action ( NNpv_id, 'runtime_add', NNuser_id,
    			     'Runtime package: '|| SSrtd_name ||' '|| SSrtd_version );
 

		-- Get new ID --
    	SELECT SEQ_ADDITIONAL_NOTES.NEXTVAL INTO newID FROM DUAL;
 
		--- Add Additional Note ---
	    INSERT INTO ADDITIONAL_NOTES ( note_id, pv_id, note_title, note_body, mod_date, mod_user  )
	    VALUES (  newID, pnPv_id, psNote_title, psNote_body, ora_sysdatetime, pnUser_id );
		outErrCode := 0;		-- Set return to SUCCESS
	END IF;
 
	CLOSE an_duplicate_cur;
END New_Additional_Note;

				   VALUES (
						   patchPv_id,
	                       parPkg_id,
	                       SSpatch_version,
	                       isPatchDlocked,
	                       ora_sysdatetime,
	                       NNuser_id,
	                       ORA_SYSDATETIME,
	                       NNuser_id,
	                       SSV_MM,
	                       SSV_NMM,

                                           src_path, pv_description, PV_OVERVIEW, LAST_PV_ID, owner_id, BUILD_TYPE, IS_BUILD_ENV_REQUIRED, bs_id, is_autobuildable, is_deployable, ripple_field,change_type  )
                SELECT parPv_id         AS pv_id,
                       parPkg_id        AS pkg_id,
                       spackageversion  AS pkg_version,
                       'N'              AS dlocked,
                       ora_sysdatetime  AS created_stamp,
                       NNuser_id        AS creator_id,
                       Ora_Sysdatetime  AS modified_stamp,
                       NNuser_id        AS modifier_id,
                       SSV_MM           AS V_MM,
                       SSV_NMM          AS V_NMM,

            VALUES (
                    parPv_id,
                    parPkg_id,
                    spackageversion,
                    'N',
                    ora_sysdatetime,
                    NNuser_id,
                    Ora_Sysdatetime,
                    NNuser_id,
                    SSV_MM,
                    SSV_NMM,

 
		INSERT INTO RELEASE_CONTENT ( RTAG_ID, PV_ID, BASE_VIEW_ID, INSERT_STAMP, INSERTOR_ID, PKG_STATE )
	   		   VALUES ( sync_rtags_rec.rtag_id,
		       		  	nPv_id,
						sync_rtags_rec.BASE_VIEW_ID,
	           			ora_sysdatetime,
	           			nUser_id,
						0
	      	   		   );
 
-- 		UPDATE RELEASE_CONTENT
-- 	       SET pv_id = nPv_id,
-- 	           insert_stamp = ora_sysdatetime,
-- 	           insertor_id = nUser_id
-- 	     WHERE rtag_id = sync_rtags_rec.rtag_id
-- 	       AND pv_id = sync_rtags_rec.pv_id;
 
		FETCH sync_rtags_cur INTO sync_rtags_rec;

    THEN
		--- Update Additional Note ---
	    UPDATE ADDITIONAL_NOTES SET
		       note_title = psNote_title,
		       note_body = psNote_body,
		       mod_date = ora_sysdatetime,
		       mod_user = pnUser_id
         WHERE note_id = pnNote_id
           AND pv_id = pnPv_id;
		outErrCode := 0;		-- Set return to SUCCESS
	END IF;

      userid                   IN   NUMBER
   );
   
    PROCEDURE import_dependencies2 (
    pvid                     IN   NUMBER,
    dependenciesimportlist   IN   relmgr_varchar2_tab_t,
    userid                   IN   NUMBER
    );
 
   FUNCTION return_last_package_version (pkgname IN VARCHAR2, rtagid IN NUMBER)
      RETURN VARCHAR2;

                                         last_pv_id, owner_id, is_deployable,
                                         is_build_env_required, build_type, change_type,
                                         bs_id, is_autobuildable, ripple_field, build_time)
                 SELECT returnpvid AS pv_id, origpkg_id AS pkg_id,
                        spackageversion AS pkg_version, 'N' AS dlocked,
                        ora_sysdatetime AS created_stamp, nuserid AS creator_id,
                        ora_sysdatetime AS modified_stamp,
                        nuserid AS modifier_id, ssv_mm AS v_mm,
                        ssv_nmm AS v_nmm, ssv_ext AS v_ext, pv.src_path,
                        pv.pv_description, pv.pv_overview,
                        nlastpvid AS last_pv_id, pv.owner_id, pv.is_deployable,

                         pv_description,
                         owner_id, is_patch, last_pv_id, build_type, is_build_env_required, bs_id,
                         is_autobuildable, ripple_field
                        )
                 VALUES (patchpv_id, parpkg_id, snewpatchversion,
                         ispatchdlocked, ora_sysdatetime, nuserid,
                         ora_sysdatetime, nuserid, ssv_mm, ssv_nmm, ssv_ext,
                         parent_rec.src_path,
                            'This is a patch to '
                         || parent_rec.pkg_name
                         || ' '

   BEGIN
 
      SELECT seq_cr_id.NEXTVAL INTO ncrid FROM DUAL;
 
      INSERT INTO code_review_url ( cr_id, pv_id, proj_id, url, reason, date_of_review, last_modified )
      VALUES ( ncrid, npvid, nprojid, surl, sreason, TO_DATE( ddateofreview,'DD/MM/YYYY' ), ora_sysdatetime );
 
   END;
/*-------------------------------------------------------------------------------------------------------*/
   /*
   ** Author: Jeremy Tweddle

      UPDATE code_review_url
      SET url = surl,
          proj_id = nprojid,
          reason = sreason,
          date_of_review = TO_DATE( ddateofreview,'DD/MM/YYYY' ),
          last_modified = ora_sysdatetime
      WHERE cr_id = ncrid;
 
   END;
 
/*-------------------------------------------------------------------------------------------------------*/

                        OFFICIAL, REBUILD_ENV, REBUILD_STAMP,
                        PARENT_RTAG_ID, PROJ_ID, VTREE_ID )
   VALUES ( RtagId,
          sReleaseName,
          sReleaseComments,
          ora_sysdatetime,
          nUserId,
          cOfficial,
          'N',
          0,
          ParentRtagId,

         REPLACE_PACKAGE ( newPvId, recReplacePkg.PV_ID, RtagId, UserId );
 
      ELSE
         -- Add new package
         INSERT INTO RELEASE_CONTENT ( RTAG_ID, PV_ID, BASE_VIEW_ID, INSERT_STAMP, INSERTOR_ID, PKG_STATE )
         VALUES( RtagId, newPvId, ViewId, ora_sysdatetime, UserId, 0);
 
        -- Insert default package flags
        -- Get Package Level defaults
 
        SELECT pkg.default_pegged, pkg.DEFAULT_ADVISORY_RIPPLE

   END IF;
 
   -- Replace Package
    UPDATE RELEASE_CONTENT
       SET pv_id = newPvId,
           insert_stamp = ora_sysdatetime,
           insertor_id = UserId,
           product_state = NULL,
           ripple_stop = cRippleStop
     WHERE rtag_id = RtagId
       AND pv_id = oldPvId;

Rev 6999	Rev 7000
Line 1...	Line 1...
1	`--------------------------------------------------------`	1	`--------------------------------------------------------`
2	`-- File created - Monday-April-08-2019`	2	`-- File created - Tuesday-April-09-2019`
3	`--------------------------------------------------------`	3	`--------------------------------------------------------`
4	`--------------------------------------------------------`	4	`--------------------------------------------------------`
5	`-- DDL for Type RELMGR_NUMBER_TAB_T`	5	`-- DDL for Type RELMGR_NUMBER_TAB_T`
6	`--------------------------------------------------------`	6	`--------------------------------------------------------`
7		7
Line 79...	Line 79...
79	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_BSA_ID" MINVALUE 8 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 48 CACHE 20 NOORDER NOCYCLE ;`	79	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_BSA_ID" MINVALUE 8 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 48 CACHE 20 NOORDER NOCYCLE ;`
80	`--------------------------------------------------------`	80	`--------------------------------------------------------`
81	`-- DDL for Sequence SEQ_BUILD_INSTANCE`	81	`-- DDL for Sequence SEQ_BUILD_INSTANCE`
82	`--------------------------------------------------------`	82	`--------------------------------------------------------`
83		83
84	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 240512 CACHE 20 ORDER NOCYCLE ;`	84	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 240932 CACHE 20 ORDER NOCYCLE ;`
85	`--------------------------------------------------------`	85	`--------------------------------------------------------`
86	`-- DDL for Sequence SEQ_CR_ID`	86	`-- DDL for Sequence SEQ_CR_ID`
87	`--------------------------------------------------------`	87	`--------------------------------------------------------`
88		88
89	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_CR_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 95272 CACHE 20 ORDER NOCYCLE ;`	89	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_CR_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 95272 CACHE 20 ORDER NOCYCLE ;`
90	`--------------------------------------------------------`	90	`--------------------------------------------------------`
91	`-- DDL for Sequence SEQ_DAEMON_INSTRUCTION_ID`	91	`-- DDL for Sequence SEQ_DAEMON_INSTRUCTION_ID`
92	`--------------------------------------------------------`	92	`--------------------------------------------------------`
93		93
94	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 179255 CACHE 20 ORDER NOCYCLE ;`	94	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 179295 CACHE 20 ORDER NOCYCLE ;`
95	`--------------------------------------------------------`	95	`--------------------------------------------------------`
96	`-- DDL for Sequence SEQ_GBE_ID`	96	`-- DDL for Sequence SEQ_GBE_ID`
97	`--------------------------------------------------------`	97	`--------------------------------------------------------`
98		98
99	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_GBE_ID" MINVALUE 40 MAXVALUE 9999999999999999999999990 INCREMENT BY 1 START WITH 1245 NOCACHE ORDER NOCYCLE ;`	99	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_GBE_ID" MINVALUE 40 MAXVALUE 9999999999999999999999990 INCREMENT BY 1 START WITH 1245 NOCACHE ORDER NOCYCLE ;`
Line 109...	Line 109...
109	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_MSG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 582 CACHE 20 ORDER NOCYCLE ;`	109	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_MSG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 582 CACHE 20 ORDER NOCYCLE ;`
110	`--------------------------------------------------------`	110	`--------------------------------------------------------`
111	`-- DDL for Sequence SEQ_PKG_ID`	111	`-- DDL for Sequence SEQ_PKG_ID`
112	`--------------------------------------------------------`	112	`--------------------------------------------------------`
113		113
114	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_PKG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 68043 CACHE 20 ORDER NOCYCLE ;`	114	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_PKG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 68063 CACHE 20 ORDER NOCYCLE ;`
115	`--------------------------------------------------------`	115	`--------------------------------------------------------`
116	`-- DDL for Sequence SEQ_PROJ_ID`	116	`-- DDL for Sequence SEQ_PROJ_ID`
117	`--------------------------------------------------------`	117	`--------------------------------------------------------`
118		118
119	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_PROJ_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1041 CACHE 20 ORDER NOCYCLE ;`	119	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_PROJ_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1041 CACHE 20 ORDER NOCYCLE ;`
120	`--------------------------------------------------------`	120	`--------------------------------------------------------`
121	`-- DDL for Sequence SEQ_PV_ID`	121	`-- DDL for Sequence SEQ_PV_ID`
122	`--------------------------------------------------------`	122	`--------------------------------------------------------`
123		123
124	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_PV_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1237708 CACHE 20 ORDER NOCYCLE ;`	124	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_PV_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1238088 CACHE 20 ORDER NOCYCLE ;`
125	`--------------------------------------------------------`	125	`--------------------------------------------------------`
126	`-- DDL for Sequence SEQ_RCON_ID`	126	`-- DDL for Sequence SEQ_RCON_ID`
127	`--------------------------------------------------------`	127	`--------------------------------------------------------`
128		128
129	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_RCON_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 36770 CACHE 20 ORDER NOCYCLE ;`	129	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_RCON_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 36790 CACHE 20 ORDER NOCYCLE ;`
130	`--------------------------------------------------------`	130	`--------------------------------------------------------`
131	`-- DDL for Sequence SEQ_RELEASE_MOD`	131	`-- DDL for Sequence SEQ_RELEASE_MOD`
132	`--------------------------------------------------------`	132	`--------------------------------------------------------`
133		133
134	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_RELEASE_MOD" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 298323 CACHE 20 NOORDER NOCYCLE ;`	134	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_RELEASE_MOD" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 298803 CACHE 20 NOORDER NOCYCLE ;`
135	`--------------------------------------------------------`	135	`--------------------------------------------------------`
136	`-- DDL for Sequence SEQ_RTAG_ID`	136	`-- DDL for Sequence SEQ_RTAG_ID`
137	`--------------------------------------------------------`	137	`--------------------------------------------------------`
138		138
139	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_RTAG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 39611 CACHE 20 ORDER NOCYCLE ;`	139	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_RTAG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 39631 CACHE 20 ORDER NOCYCLE ;`
140	`--------------------------------------------------------`	140	`--------------------------------------------------------`
141	`-- DDL for Sequence SEQ_SCHEDULED_ID`	141	`-- DDL for Sequence SEQ_SCHEDULED_ID`
142	`--------------------------------------------------------`	142	`--------------------------------------------------------`
143		143
144	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_SCHEDULED_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 30054 CACHE 20 ORDER NOCYCLE ;`	144	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_SCHEDULED_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 30074 CACHE 20 ORDER NOCYCLE ;`
145	`--------------------------------------------------------`	145	`--------------------------------------------------------`
146	`-- DDL for Sequence SEQ_SDKTAG_ID`	146	`-- DDL for Sequence SEQ_SDKTAG_ID`
147	`--------------------------------------------------------`	147	`--------------------------------------------------------`
148		148
149	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_SDKTAG_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1563 CACHE 20 NOORDER NOCYCLE ;`	149	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_SDKTAG_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1563 CACHE 20 NOORDER NOCYCLE ;`
Line 154...	Line 154...
154	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_SDK_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 163 CACHE 20 NOORDER NOCYCLE ;`	154	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_SDK_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 163 CACHE 20 NOORDER NOCYCLE ;`
155	`--------------------------------------------------------`	155	`--------------------------------------------------------`
156	`-- DDL for Sequence SEQ_SESSION_NUM`	156	`-- DDL for Sequence SEQ_SESSION_NUM`
157	`--------------------------------------------------------`	157	`--------------------------------------------------------`
158		158
159	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_SESSION_NUM" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1110244 CACHE 20 ORDER NOCYCLE ;`	159	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_SESSION_NUM" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1110364 CACHE 20 ORDER NOCYCLE ;`
160	`--------------------------------------------------------`	160	`--------------------------------------------------------`
161	`-- DDL for Sequence SEQ_TESTRUN_ID`	161	`-- DDL for Sequence SEQ_TESTRUN_ID`
162	`--------------------------------------------------------`	162	`--------------------------------------------------------`
163		163
164	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_TESTRUN_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 2116663 CACHE 20 NOORDER NOCYCLE ;`	164	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_TESTRUN_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 2141643 CACHE 20 NOORDER NOCYCLE ;`
165	`--------------------------------------------------------`	165	`--------------------------------------------------------`
166	`-- DDL for Sequence SEQ_UNIT_TESTS`	166	`-- DDL for Sequence SEQ_UNIT_TESTS`
167	`--------------------------------------------------------`	167	`--------------------------------------------------------`
168		168
169	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_UNIT_TESTS" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 375936 CACHE 20 ORDER NOCYCLE ;`	169	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_UNIT_TESTS" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 375956 CACHE 20 ORDER NOCYCLE ;`
170	`--------------------------------------------------------`	170	`--------------------------------------------------------`
171	`-- DDL for Sequence SEQ_USER_ID`	171	`-- DDL for Sequence SEQ_USER_ID`
172	`--------------------------------------------------------`	172	`--------------------------------------------------------`
173		173
174	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_USER_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 3961 CACHE 20 ORDER NOCYCLE ;`	174	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_USER_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 3961 CACHE 20 ORDER NOCYCLE ;`
Line 184...	Line 184...
184	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_VIEW_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 10341 CACHE 20 ORDER NOCYCLE ;`	184	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_VIEW_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 10341 CACHE 20 ORDER NOCYCLE ;`
185	`--------------------------------------------------------`	185	`--------------------------------------------------------`
186	`-- DDL for Sequence SEQ_VTREE_ID`	186	`-- DDL for Sequence SEQ_VTREE_ID`
187	`--------------------------------------------------------`	187	`--------------------------------------------------------`
188		188
189	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_VTREE_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 36290 CACHE 20 ORDER NOCYCLE ;`	189	`CREATE SEQUENCE "RELEASE_MANAGER"."SEQ_VTREE_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 36310 CACHE 20 ORDER NOCYCLE ;`
190	`--------------------------------------------------------`	190	`--------------------------------------------------------`
191	`-- DDL for Table ABT_ACTION_LOG`	191	`-- DDL for Table ABT_ACTION_LOG`
192	`--------------------------------------------------------`	192	`--------------------------------------------------------`
193		193
194	`CREATE TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG"`	194	`CREATE TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG"`
Line 4291...	Line 4291...
4291	`THEN`	4291	`THEN`
4292	`/* Make sure it does not exists already as runtime dependency */`	4292	`/* Make sure it does not exists already as runtime dependency */`
4293		4293
4294	`--- Add new Runtime Dependency ---`	4294	`--- Add new Runtime Dependency ---`
4295	`INSERT INTO runtime_dependencies ( pv_id, rtd_id, mod_date, mod_user )`	4295	`INSERT INTO runtime_dependencies ( pv_id, rtd_id, mod_date, mod_user )`
4296	`VALUES ( NNpv_id, retRTD_ID, ORA_SYSDATE , NNuser_id );`	4296	`VALUES ( NNpv_id, retRTD_ID, ora_sysdatetime , NNuser_id );`
4297		4297
4298	`/* LOG ACTION */`	4298	`/* LOG ACTION */`
4299	`Log_Action ( NNpv_id, 'runtime_add', NNuser_id,`	4299	`Log_Action ( NNpv_id, 'runtime_add', NNuser_id,`
4300	`'Runtime package: '\|\| SSrtd_name \|\|' '\|\| SSrtd_version );`	4300	`'Runtime package: '\|\| SSrtd_name \|\|' '\|\| SSrtd_version );`
4301		4301
Line 6112...	Line 6112...
6112	`-- Get new ID --`	6112	`-- Get new ID --`
6113	`SELECT SEQ_ADDITIONAL_NOTES.NEXTVAL INTO newID FROM DUAL;`	6113	`SELECT SEQ_ADDITIONAL_NOTES.NEXTVAL INTO newID FROM DUAL;`
6114		6114
6115	`--- Add Additional Note ---`	6115	`--- Add Additional Note ---`
6116	`INSERT INTO ADDITIONAL_NOTES ( note_id, pv_id, note_title, note_body, mod_date, mod_user )`	6116	`INSERT INTO ADDITIONAL_NOTES ( note_id, pv_id, note_title, note_body, mod_date, mod_user )`
6117	`VALUES ( newID, pnPv_id, psNote_title, psNote_body, Ora_Sysdate, pnUser_id );`	6117	`VALUES ( newID, pnPv_id, psNote_title, psNote_body, ora_sysdatetime, pnUser_id );`
6118	`outErrCode := 0; -- Set return to SUCCESS`	6118	`outErrCode := 0; -- Set return to SUCCESS`
6119	`END IF;`	6119	`END IF;`
6120		6120
6121	`CLOSE an_duplicate_cur;`	6121	`CLOSE an_duplicate_cur;`
6122	`END New_Additional_Note;`	6122	`END New_Additional_Note;`
Line 6250...	Line 6250...
6250	`VALUES (`	6250	`VALUES (`
6251	`patchPv_id,`	6251	`patchPv_id,`
6252	`parPkg_id,`	6252	`parPkg_id,`
6253	`SSpatch_version,`	6253	`SSpatch_version,`
6254	`isPatchDlocked,`	6254	`isPatchDlocked,`
6255	`ORA_SYSDATE,`	6255	`ora_sysdatetime,`
6256	`NNuser_id,`	6256	`NNuser_id,`
6257	`ORA_SYSDATETIME,`	6257	`ORA_SYSDATETIME,`
6258	`NNuser_id,`	6258	`NNuser_id,`
6259	`SSV_MM,`	6259	`SSV_MM,`
6260	`SSV_NMM,`	6260	`SSV_NMM,`
Line 7187...	Line 7187...
7187	`src_path, pv_description, PV_OVERVIEW, LAST_PV_ID, owner_id, BUILD_TYPE, IS_BUILD_ENV_REQUIRED, bs_id, is_autobuildable, is_deployable, ripple_field,change_type )`	7187	`src_path, pv_description, PV_OVERVIEW, LAST_PV_ID, owner_id, BUILD_TYPE, IS_BUILD_ENV_REQUIRED, bs_id, is_autobuildable, is_deployable, ripple_field,change_type )`
7188	`SELECT parPv_id AS pv_id,`	7188	`SELECT parPv_id AS pv_id,`
7189	`parPkg_id AS pkg_id,`	7189	`parPkg_id AS pkg_id,`
7190	`spackageversion AS pkg_version,`	7190	`spackageversion AS pkg_version,`
7191	`'N' AS dlocked,`	7191	`'N' AS dlocked,`
7192	`Ora_Sysdate AS created_stamp,`	7192	`ora_sysdatetime AS created_stamp,`
7193	`NNuser_id AS creator_id,`	7193	`NNuser_id AS creator_id,`
7194	`Ora_Sysdatetime AS modified_stamp,`	7194	`Ora_Sysdatetime AS modified_stamp,`
7195	`NNuser_id AS modifier_id,`	7195	`NNuser_id AS modifier_id,`
7196	`SSV_MM AS V_MM,`	7196	`SSV_MM AS V_MM,`
7197	`SSV_NMM AS V_NMM,`	7197	`SSV_NMM AS V_NMM,`
Line 7219...	Line 7219...
7219	`VALUES (`	7219	`VALUES (`
7220	`parPv_id,`	7220	`parPv_id,`
7221	`parPkg_id,`	7221	`parPkg_id,`
7222	`spackageversion,`	7222	`spackageversion,`
7223	`'N',`	7223	`'N',`
7224	`Ora_Sysdate,`	7224	`ora_sysdatetime,`
7225	`NNuser_id,`	7225	`NNuser_id,`
7226	`Ora_Sysdatetime,`	7226	`Ora_Sysdatetime,`
7227	`NNuser_id,`	7227	`NNuser_id,`
7228	`SSV_MM,`	7228	`SSV_MM,`
7229	`SSV_NMM,`	7229	`SSV_NMM,`
Line 7739...	Line 7739...
7739		7739
7740	`INSERT INTO RELEASE_CONTENT ( RTAG_ID, PV_ID, BASE_VIEW_ID, INSERT_STAMP, INSERTOR_ID, PKG_STATE )`	7740	`INSERT INTO RELEASE_CONTENT ( RTAG_ID, PV_ID, BASE_VIEW_ID, INSERT_STAMP, INSERTOR_ID, PKG_STATE )`
7741	`VALUES ( sync_rtags_rec.rtag_id,`	7741	`VALUES ( sync_rtags_rec.rtag_id,`
7742	`nPv_id,`	7742	`nPv_id,`
7743	`sync_rtags_rec.BASE_VIEW_ID,`	7743	`sync_rtags_rec.BASE_VIEW_ID,`
7744	`Ora_Sysdate,`	7744	`ora_sysdatetime,`
7745	`nUser_id,`	7745	`nUser_id,`
7746	`0`	7746	`0`
7747	`);`	7747	`);`
7748		7748
7749	`-- UPDATE RELEASE_CONTENT`	7749	`-- UPDATE RELEASE_CONTENT`
7750	`-- SET pv_id = nPv_id,`	7750	`-- SET pv_id = nPv_id,`
7751	`-- insert_stamp = Ora_Sysdate,`	7751	`-- insert_stamp = ora_sysdatetime,`
7752	`-- insertor_id = nUser_id`	7752	`-- insertor_id = nUser_id`
7753	`-- WHERE rtag_id = sync_rtags_rec.rtag_id`	7753	`-- WHERE rtag_id = sync_rtags_rec.rtag_id`
7754	`-- AND pv_id = sync_rtags_rec.pv_id;`	7754	`-- AND pv_id = sync_rtags_rec.pv_id;`
7755		7755
7756	`FETCH sync_rtags_cur INTO sync_rtags_rec;`	7756	`FETCH sync_rtags_cur INTO sync_rtags_rec;`
Line 8078...	Line 8078...
8078	`THEN`	8078	`THEN`
8079	`--- Update Additional Note ---`	8079	`--- Update Additional Note ---`
8080	`UPDATE ADDITIONAL_NOTES SET`	8080	`UPDATE ADDITIONAL_NOTES SET`
8081	`note_title = psNote_title,`	8081	`note_title = psNote_title,`
8082	`note_body = psNote_body,`	8082	`note_body = psNote_body,`
8083	`mod_date = Ora_Sysdate,`	8083	`mod_date = ora_sysdatetime,`
8084	`mod_user = pnUser_id`	8084	`mod_user = pnUser_id`
8085	`WHERE note_id = pnNote_id`	8085	`WHERE note_id = pnNote_id`
8086	`AND pv_id = pnPv_id;`	8086	`AND pv_id = pnPv_id;`
8087	`outErrCode := 0; -- Set return to SUCCESS`	8087	`outErrCode := 0; -- Set return to SUCCESS`
8088	`END IF;`	8088	`END IF;`
Line 9402...	Line 9402...
9402	`userid IN NUMBER`	9402	`userid IN NUMBER`
9403	`);`	9403	`);`
9404		9404
9405	`PROCEDURE import_dependencies2 (`	9405	`PROCEDURE import_dependencies2 (`
9406	`pvid IN NUMBER,`	9406	`pvid IN NUMBER,`
9407	`dependenciesimportlisora_sysdatetimet IN relmgr_varchar2_tab_t,`	9407	`dependenciesimportlist IN relmgr_varchar2_tab_t,`
9408	`userid IN NUMBER`	9408	`userid IN NUMBER`
9409	`);`	9409	`);`
9410		9410
9411	`FUNCTION return_last_package_version (pkgname IN VARCHAR2, rtagid IN NUMBER)`	9411	`FUNCTION return_last_package_version (pkgname IN VARCHAR2, rtagid IN NUMBER)`
9412	`RETURN VARCHAR2;`	9412	`RETURN VARCHAR2;`
Line 13073...	Line 13073...
13073	`last_pv_id, owner_id, is_deployable,`	13073	`last_pv_id, owner_id, is_deployable,`
13074	`is_build_env_required, build_type, change_type,`	13074	`is_build_env_required, build_type, change_type,`
13075	`bs_id, is_autobuildable, ripple_field, build_time)`	13075	`bs_id, is_autobuildable, ripple_field, build_time)`
13076	`SELECT returnpvid AS pv_id, origpkg_id AS pkg_id,`	13076	`SELECT returnpvid AS pv_id, origpkg_id AS pkg_id,`
13077	`spackageversion AS pkg_version, 'N' AS dlocked,`	13077	`spackageversion AS pkg_version, 'N' AS dlocked,`
13078	`ora_sysdate AS created_stamp, nuserid AS creator_id,`	13078	`ora_sysdatetime AS created_stamp, nuserid AS creator_id,`
13079	`ora_sysdatetime AS modified_stamp,`	13079	`ora_sysdatetime AS modified_stamp,`
13080	`nuserid AS modifier_id, ssv_mm AS v_mm,`	13080	`nuserid AS modifier_id, ssv_mm AS v_mm,`
13081	`ssv_nmm AS v_nmm, ssv_ext AS v_ext, pv.src_path,`	13081	`ssv_nmm AS v_nmm, ssv_ext AS v_ext, pv.src_path,`
13082	`pv.pv_description, pv.pv_overview,`	13082	`pv.pv_description, pv.pv_overview,`
13083	`nlastpvid AS last_pv_id, pv.owner_id, pv.is_deployable,`	13083	`nlastpvid AS last_pv_id, pv.owner_id, pv.is_deployable,`
Line 13914...	Line 13914...
13914	`pv_description,`	13914	`pv_description,`
13915	`owner_id, is_patch, last_pv_id, build_type, is_build_env_required, bs_id,`	13915	`owner_id, is_patch, last_pv_id, build_type, is_build_env_required, bs_id,`
13916	`is_autobuildable, ripple_field`	13916	`is_autobuildable, ripple_field`
13917	`)`	13917	`)`
13918	`VALUES (patchpv_id, parpkg_id, snewpatchversion,`	13918	`VALUES (patchpv_id, parpkg_id, snewpatchversion,`
13919	`ispatchdlocked, ora_sysdate, nuserid,`	13919	`ispatchdlocked, ora_sysdatetime, nuserid,`
13920	`ora_sysdatetime, nuserid, ssv_mm, ssv_nmm, ssv_ext,`	13920	`ora_sysdatetime, nuserid, ssv_mm, ssv_nmm, ssv_ext,`
13921	`parent_rec.src_path,`	13921	`parent_rec.src_path,`
13922	`'This is a patch to '`	13922	`'This is a patch to '`
13923	`\|\| parent_rec.pkg_name`	13923	`\|\| parent_rec.pkg_name`
13924	`\|\| ' '`	13924	`\|\| ' '`
Line 14360...	Line 14360...
14360	`BEGIN`	14360	`BEGIN`
14361		14361
14362	`SELECT seq_cr_id.NEXTVAL INTO ncrid FROM DUAL;`	14362	`SELECT seq_cr_id.NEXTVAL INTO ncrid FROM DUAL;`
14363		14363
14364	`INSERT INTO code_review_url ( cr_id, pv_id, proj_id, url, reason, date_of_review, last_modified )`	14364	`INSERT INTO code_review_url ( cr_id, pv_id, proj_id, url, reason, date_of_review, last_modified )`
14365	`VALUES ( ncrid, npvid, nprojid, surl, sreason, TO_DATE( ddateofreview,'DD/MM/YYYY' ), ora_sysdate );`	14365	`VALUES ( ncrid, npvid, nprojid, surl, sreason, TO_DATE( ddateofreview,'DD/MM/YYYY' ), ora_sysdatetime );`
14366		14366
14367	`END;`	14367	`END;`
14368	`/-------------------------------------------------------------------------------------------------------/`	14368	`/-------------------------------------------------------------------------------------------------------/`
14369	`/*`	14369	`/*`
14370	`** Author: Jeremy Tweddle`	14370	`** Author: Jeremy Tweddle`
Line 14383...	Line 14383...
14383	`UPDATE code_review_url`	14383	`UPDATE code_review_url`
14384	`SET url = surl,`	14384	`SET url = surl,`
14385	`proj_id = nprojid,`	14385	`proj_id = nprojid,`
14386	`reason = sreason,`	14386	`reason = sreason,`
14387	`date_of_review = TO_DATE( ddateofreview,'DD/MM/YYYY' ),`	14387	`date_of_review = TO_DATE( ddateofreview,'DD/MM/YYYY' ),`
14388	`last_modified = ora_sysdate`	14388	`last_modified = ora_sysdatetime`
14389	`WHERE cr_id = ncrid;`	14389	`WHERE cr_id = ncrid;`
14390		14390
14391	`END;`	14391	`END;`
14392		14392
14393	`/-------------------------------------------------------------------------------------------------------/`	14393	`/-------------------------------------------------------------------------------------------------------/`
Line 14850...	Line 14850...
14850	`OFFICIAL, REBUILD_ENV, REBUILD_STAMP,`	14850	`OFFICIAL, REBUILD_ENV, REBUILD_STAMP,`
14851	`PARENT_RTAG_ID, PROJ_ID, VTREE_ID )`	14851	`PARENT_RTAG_ID, PROJ_ID, VTREE_ID )`
14852	`VALUES ( RtagId,`	14852	`VALUES ( RtagId,`
14853	`sReleaseName,`	14853	`sReleaseName,`
14854	`sReleaseComments,`	14854	`sReleaseComments,`
14855	`ORA_SYSDATE,`	14855	`ora_sysdatetime,`
14856	`nUserId,`	14856	`nUserId,`
14857	`cOfficial,`	14857	`cOfficial,`
14858	`'N',`	14858	`'N',`
14859	`0,`	14859	`0,`
14860	`ParentRtagId,`	14860	`ParentRtagId,`
Line 15653...	Line 15653...
15653	`REPLACE_PACKAGE ( newPvId, recReplacePkg.PV_ID, RtagId, UserId );`	15653	`REPLACE_PACKAGE ( newPvId, recReplacePkg.PV_ID, RtagId, UserId );`
15654		15654
15655	`ELSE`	15655	`ELSE`
15656	`-- Add new package`	15656	`-- Add new package`
15657	`INSERT INTO RELEASE_CONTENT ( RTAG_ID, PV_ID, BASE_VIEW_ID, INSERT_STAMP, INSERTOR_ID, PKG_STATE )`	15657	`INSERT INTO RELEASE_CONTENT ( RTAG_ID, PV_ID, BASE_VIEW_ID, INSERT_STAMP, INSERTOR_ID, PKG_STATE )`
15658	`VALUES( RtagId, newPvId, ViewId, Ora_Sysdate, UserId, 0);`	15658	`VALUES( RtagId, newPvId, ViewId, ora_sysdatetime, UserId, 0);`
15659		15659
15660	`-- Insert default package flags`	15660	`-- Insert default package flags`
15661	`-- Get Package Level defaults`	15661	`-- Get Package Level defaults`
15662		15662
15663	`SELECT pkg.default_pegged, pkg.DEFAULT_ADVISORY_RIPPLE`	15663	`SELECT pkg.default_pegged, pkg.DEFAULT_ADVISORY_RIPPLE`
Line 15721...	Line 15721...
15721	`END IF;`	15721	`END IF;`
15722		15722
15723	`-- Replace Package`	15723	`-- Replace Package`
15724	`UPDATE RELEASE_CONTENT`	15724	`UPDATE RELEASE_CONTENT`
15725	`SET pv_id = newPvId,`	15725	`SET pv_id = newPvId,`
15726	`insert_stamp = Ora_Sysdate,`	15726	`insert_stamp = ora_sysdatetime,`
15727	`insertor_id = UserId,`	15727	`insertor_id = UserId,`
15728	`product_state = NULL,`	15728	`product_state = NULL,`
15729	`ripple_stop = cRippleStop`	15729	`ripple_stop = cRippleStop`
15730	`WHERE rtag_id = RtagId`	15730	`WHERE rtag_id = RtagId`
15731	`AND pv_id = oldPvId;`	15731	`AND pv_id = oldPvId;`

Subversion Repositories DevTools

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