Subversion Repositories DevTools

Rev

Rev 5892 | Rev 6031 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5892 Rev 5893
Line 18271... Line 18271...
18271
 
18271
 
18272
END Sync_Projects_New_Version;
18272
END Sync_Projects_New_Version;
18273
 
18273
 
18274
/
18274
/
18275
--------------------------------------------------------
18275
--------------------------------------------------------
18276
--  DDL for Procedure TEST
-
 
18277
--------------------------------------------------------
-
 
18278
set define off;
-
 
18279
 
-
 
18280
  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."TEST" 
-
 
18281
IS
-
 
18282
 
-
 
18283
proc_id NUMBER;
-
 
18284
/******************************************************************************
-
 
18285
   NAME:       DELETE_DO_NOT_RIPPLE
-
 
18286
   PURPOSE:    TO DELETE ENTRIES FROM THE DO_NOT_RIPPLE TABLE WHEN A PACKAGE
-
 
18287
               IS RELEASED
-
 
18288
 
-
 
18289
   REVISIONS:
-
 
18290
   Ver        Date        Author           Description
-
 
18291
   ---------  ----------  ---------------  ------------------------------------
-
 
18292
   1.0        21/04/2006  Rupesh Solanki     1. Created this procedure.
-
 
18293
 
-
 
18294
   NOTES:
-
 
18295
 
-
 
18296
   Automatically available Auto Replace Keywords:
-
 
18297
      Object Name:     DELETE_DO_NOT_RIPPLE
-
 
18298
      Sysdate:         21/04/2006
-
 
18299
      Date and Time:   21/04/2006, 3:21:55 PM, and 21/04/2006 3:21:55 PM
-
 
18300
      Username:         (set in TOAD Options, Procedure Editor)
-
 
18301
      Table Name:       (set in the "New PL/SQL Object" dialog)
-
 
18302
 
-
 
18303
******************************************************************************/
-
 
18304
   CURSOR ripple_cur
-
 
18305
   IS
-
 
18306
      select distinct pkg_health_tag, cmd_interface, pkg_owner, is_interface from deployment_manager.processes_config;
-
 
18307
 
-
 
18308
   ripple_rec   ripple_cur%ROWTYPE;
-
 
18309
BEGIN
-
 
18310
   OPEN ripple_cur;
-
 
18311
 
-
 
18312
   FETCH ripple_cur
-
 
18313
    INTO ripple_rec;
-
 
18314
 
-
 
18315
   WHILE ripple_cur%FOUND
-
 
18316
   LOOP
-
 
18317
   
-
 
18318
   select deployment_manager.seq_proc_id.nextval into proc_id from dual;
-
 
18319
   
-
 
18320
insert into processes (PROC_ID, PROC_NAME, RUN_AS, PKG_OWNER, IS_INTERFACE) 
-
 
18321
values(proc_id, ripple_rec.pkg_health_tag, ripple_rec.cmd_interface, ripple_rec.pkg_owner, ripple_rec.is_interface);
-
 
18322
 
-
 
18323
      FETCH ripple_cur
-
 
18324
       INTO ripple_rec;
-
 
18325
   END LOOP;
-
 
18326
END test;
-
 
18327
 
-
 
18328
/
-
 
18329
--------------------------------------------------------
-
 
18330
--  DDL for Procedure TEST_MARCO
-
 
18331
--------------------------------------------------------
-
 
18332
set define off;
-
 
18333
 
-
 
18334
  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."TEST_MARCO" IS
-
 
18335
/******************************************************************************
-
 
18336
   NAME:       TEST_MARCO
-
 
18337
   PURPOSE:    
-
 
18338
 
-
 
18339
   REVISIONS:
-
 
18340
   Ver        Date        Author           Description
-
 
18341
   ---------  ----------  ---------------  ------------------------------------
-
 
18342
   1.0        2/03/2007          1. Created this procedure.
-
 
18343
 
-
 
18344
   NOTES:
-
 
18345
 
-
 
18346
   Automatically available Auto Replace Keywords:
-
 
18347
      Object Name:     TEST_MARCO
-
 
18348
      Sysdate:         2/03/2007
-
 
18349
      Date and Time:   2/03/2007, 3:11:11 PM, and 2/03/2007 3:11:11 PM
-
 
18350
      Username:         (set in TOAD Options, Procedure Editor)
-
 
18351
      Table Name:       (set in the "New PL/SQL Object" dialog)
-
 
18352
 
-
 
18353
******************************************************************************/
-
 
18354
 
-
 
18355
parPv_id    NUMBER;
-
 
18356
parPkg_id   NUMBER;
-
 
18357
    SSV_MM PACKAGE_VERSIONS.V_MM%TYPE;
-
 
18358
    SSV_NMM PACKAGE_VERSIONS.V_NMM%TYPE;
-
 
18359
    SSV_EXT PACKAGE_VERSIONS.V_EXT%TYPE;
-
 
18360
BEGIN
-
 
18361
 
-
 
18362
SELECT SEQ_PV_ID.NEXTVAL INTO parPv_id FROM DUAL;
-
 
18363
 
-
 
18364
        /* LOG ACTION */
-
 
18365
        Log_Action ( parPv_id, 'new_version', 3764,
-
 
18366
        			 'New package version: '|| parPv_id || '.' );
-
 
18367
 
-
 
18368
        Split_Version ( parPv_id || '.', SSV_MM, SSV_NMM, SSV_EXT );
-
 
18369
		
-
 
18370
     -- Clone Package Version Details --
-
 
18371
            INSERT INTO PACKAGE_VERSIONS ( pv_id, pkg_id, pkg_version, dlocked, created_stamp, creator_id, modified_stamp, modifier_id, V_MM, V_NMM, V_EXT,
-
 
18372
                                           src_path, pv_description, PV_OVERVIEW, LAST_PV_ID, owner_id, BUILD_TYPE, IS_BUILD_ENV_REQUIRED, bs_id, is_autobuildable, is_deployable )
-
 
18373
                SELECT parPv_id         AS pv_id,
-
 
18374
                       pv.pkg_id        AS pkg_id,
-
 
18375
                       parPv_id || '.'    AS pkg_version,
-
 
18376
                       'N'              AS dlocked,
-
 
18377
                       Ora_Sysdate      AS created_stamp,
-
 
18378
                       3764        AS creator_id,
-
 
18379
                       Ora_Sysdatetime  AS modified_stamp,
-
 
18380
                       3764        AS modifier_id,
-
 
18381
                       SSV_MM          AS V_MM,
-
 
18382
                       SSV_NMM         AS V_NMM,
-
 
18383
                       SSV_EXT          AS V_EXT,
-
 
18384
                       pv.src_path,
-
 
18385
                       pv.pv_description,
-
 
18386
                       pv.PV_OVERVIEW,
-
 
18387
                       112982 	AS LAST_PV_ID,
-
 
18388
                       pv.owner_id,
-
 
18389
					   pv.BUILD_TYPE,
-
 
18390
					   pv.IS_BUILD_ENV_REQUIRED,
-
 
18391
					   pv.bs_id,
-
 
18392
					   pv.is_autobuildable,
-
 
18393
					   pv.IS_DEPLOYABLE
-
 
18394
                  FROM PACKAGE_VERSIONS pv
-
 
18395
                 WHERE pv.pv_id = 112982;		
-
 
18396
		
-
 
18397
Basic_Clone ( 112982, parPv_id, NULL, 3764, 22325, 0 );
-
 
18398
 
-
 
18399
 
-
 
18400
END TEST_MARCO;
-
 
18401
 
-
 
18402
/
-
 
18403
--------------------------------------------------------
-
 
18404
--  DDL for Procedure TOUCH_RELEASE
18276
--  DDL for Procedure TOUCH_RELEASE
18405
--------------------------------------------------------
18277
--------------------------------------------------------
18406
set define off;
18278
set define off;
18407
 
18279
 
18408
  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."TOUCH_RELEASE" ( nRtagId IN RELEASE_TAGS.RTAG_ID%TYPE ) IS
18280
  CREATE OR REPLACE PROCEDURE "RELEASE_MANAGER"."TOUCH_RELEASE" ( nRtagId IN RELEASE_TAGS.RTAG_ID%TYPE ) IS