Subversion Repositories DevTools

Rev

Rev 57 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 57 Rev 59
Line 261... Line 261...
261
  (
261
  (
262
    RTAG_ID
262
    RTAG_ID
263
  )
263
  )
264
  ENABLE
264
  ENABLE
265
)
265
)
266
  TABLESPACE "SYSTEM"
266
  TABLESPACE "USERS"
267
  LOGGING 
267
  LOGGING 
268
  PCTFREE 10
268
  PCTFREE 10
269
  PCTUSED 40
269
  PCTUSED 40
270
  INITRANS 1
270
  INITRANS 1
271
  MAXTRANS 255
271
  MAXTRANS 255
272
  STORAGE
272
  STORAGE
273
  (
273
  (
274
    INITIAL 64K
274
    INITIAL 64K
275
    NEXT 64K
-
 
276
    MINEXTENTS 1
275
    MINEXTENTS 1
277
    MAXEXTENTS 2147483645
276
    MAXEXTENTS 2147483645
278
    PCTINCREASE 0
-
 
279
    FREELISTS 1
277
    FREELISTS 1
280
    FREELIST GROUPS 1
278
    FREELIST GROUPS 1
281
    BUFFER_POOL DEFAULT
279
    BUFFER_POOL DEFAULT
282
  )
280
  )
283
;
281
;
Line 578... Line 576...
578
CREATE TABLE VIEW_SETTINGS
576
CREATE TABLE VIEW_SETTINGS
579
(
577
(
580
  USER_ID NUMBER NOT NULL,
578
  USER_ID NUMBER NOT NULL,
581
  VIEW_ID NUMBER NOT NULL
579
  VIEW_ID NUMBER NOT NULL
582
)
580
)
583
  TABLESPACE "SYSTEM"
581
  TABLESPACE "USERS"
584
  LOGGING 
582
  LOGGING 
585
  PCTFREE 10
583
  PCTFREE 10
586
  PCTUSED 40
584
  PCTUSED 40
587
  INITRANS 1
585
  INITRANS 1
588
  MAXTRANS 255
586
  MAXTRANS 255
589
  STORAGE
587
  STORAGE
590
  (
588
  (
591
    INITIAL 64K
589
    INITIAL 64K
592
    NEXT 64K
-
 
593
    MINEXTENTS 1
590
    MINEXTENTS 1
594
    MAXEXTENTS 2147483645
591
    MAXEXTENTS 2147483645
595
    PCTINCREASE 0
-
 
596
    FREELISTS 1
592
    FREELISTS 1
597
    FREELIST GROUPS 1
593
    FREELIST GROUPS 1
598
    BUFFER_POOL DEFAULT
594
    BUFFER_POOL DEFAULT
599
  )
595
  )
600
;
596
;
Line 667... Line 663...
667
  (
663
  (
668
    VTREE_ID
664
    VTREE_ID
669
  )
665
  )
670
  ENABLE
666
  ENABLE
671
)
667
)
672
  TABLESPACE "SYSTEM"
668
  TABLESPACE "USERS"
673
  LOGGING 
669
  LOGGING 
674
  PCTFREE 10
670
  PCTFREE 10
675
  PCTUSED 40
671
  PCTUSED 40
676
  INITRANS 1
672
  INITRANS 1
677
  MAXTRANS 255
673
  MAXTRANS 255
678
  STORAGE
674
  STORAGE
679
  (
675
  (
680
    INITIAL 64K
676
    INITIAL 64K
681
    NEXT 64K
-
 
682
    MINEXTENTS 1
677
    MINEXTENTS 1
683
    MAXEXTENTS 2147483645
678
    MAXEXTENTS 2147483645
684
    PCTINCREASE 0
-
 
685
    FREELISTS 1
679
    FREELISTS 1
686
    FREELIST GROUPS 1
680
    FREELIST GROUPS 1
687
    BUFFER_POOL DEFAULT
681
    BUFFER_POOL DEFAULT
688
  )
682
  )
689
;
683
;
Line 891... Line 885...
891
CREATE TABLE PROJECT_EXTENTIONS
885
CREATE TABLE PROJECT_EXTENTIONS
892
(
886
(
893
  PROJ_ID NUMBER NOT NULL,
887
  PROJ_ID NUMBER NOT NULL,
894
  EXT_NAME VARCHAR2(10 BYTE) NOT NULL
888
  EXT_NAME VARCHAR2(10 BYTE) NOT NULL
895
)
889
)
896
  TABLESPACE "SYSTEM"
890
  TABLESPACE "USERS"
897
  LOGGING 
891
  LOGGING 
898
  PCTFREE 10
892
  PCTFREE 10
899
  PCTUSED 40
893
  PCTUSED 40
900
  INITRANS 1
894
  INITRANS 1
901
  MAXTRANS 255
895
  MAXTRANS 255
902
  STORAGE
896
  STORAGE
903
  (
897
  (
904
    INITIAL 64K
898
    INITIAL 64K
905
    NEXT 64K
-
 
906
    MINEXTENTS 1
899
    MINEXTENTS 1
907
    MAXEXTENTS 2147483645
900
    MAXEXTENTS 2147483645
908
    PCTINCREASE 0
-
 
909
    FREELISTS 1
901
    FREELISTS 1
910
    FREELIST GROUPS 1
902
    FREELIST GROUPS 1
911
    BUFFER_POOL DEFAULT
903
    BUFFER_POOL DEFAULT
912
  )
904
  )
913
;
905
;
Line 949... Line 941...
949
  (
941
  (
950
    MSG_ID
942
    MSG_ID
951
  )
943
  )
952
  ENABLE
944
  ENABLE
953
)
945
)
954
  TABLESPACE "SYSTEM"
946
  TABLESPACE "USERS"
955
  LOGGING 
947
  LOGGING 
956
  PCTFREE 10
948
  PCTFREE 10
957
  PCTUSED 40
949
  PCTUSED 40
958
  INITRANS 1
950
  INITRANS 1
959
  MAXTRANS 255
951
  MAXTRANS 255
960
  STORAGE
952
  STORAGE
961
  (
953
  (
962
    INITIAL 64K
954
    INITIAL 64K
963
    NEXT 64K
-
 
964
    MINEXTENTS 1
955
    MINEXTENTS 1
965
    MAXEXTENTS 2147483645
956
    MAXEXTENTS 2147483645
966
    PCTINCREASE 0
-
 
967
    FREELISTS 1
957
    FREELISTS 1
968
    FREELIST GROUPS 1
958
    FREELIST GROUPS 1
969
    BUFFER_POOL DEFAULT
959
    BUFFER_POOL DEFAULT
970
  )
960
  )
971
;
961
;
Line 1192... Line 1182...
1192
  PKG_STATE NUMBER NOT NULL,
1182
  PKG_STATE NUMBER NOT NULL,
1193
  PKG_ID NUMBER,
1183
  PKG_ID NUMBER,
1194
  DEPRECATED_STATE NUMBER,
1184
  DEPRECATED_STATE NUMBER,
1195
  PRODUCT_STATE NUMBER
1185
  PRODUCT_STATE NUMBER
1196
)
1186
)
1197
  TABLESPACE "SYSTEM"
1187
  TABLESPACE "USERS"
1198
  LOGGING 
1188
  LOGGING 
1199
  PCTFREE 10
1189
  PCTFREE 10
1200
  PCTUSED 40
1190
  PCTUSED 40
1201
  INITRANS 1
1191
  INITRANS 1
1202
  MAXTRANS 255
1192
  MAXTRANS 255
1203
  STORAGE
1193
  STORAGE
1204
  (
1194
  (
1205
    INITIAL 64K
1195
    INITIAL 64K
1206
    NEXT 64K
-
 
1207
    MINEXTENTS 1
1196
    MINEXTENTS 1
1208
    MAXEXTENTS 2147483645
1197
    MAXEXTENTS 2147483645
1209
    PCTINCREASE 0
-
 
1210
    FREELISTS 1
1198
    FREELISTS 1
1211
    FREELIST GROUPS 1
1199
    FREELIST GROUPS 1
1212
    BUFFER_POOL DEFAULT
1200
    BUFFER_POOL DEFAULT
1213
  )
1201
  )
1214
;
1202
;
Line 1528... Line 1516...
1528
(
1516
(
1529
  PV_ID NUMBER NOT NULL,
1517
  PV_ID NUMBER NOT NULL,
1530
  ISS_KEY VARCHAR2(4000 BYTE),
1518
  ISS_KEY VARCHAR2(4000 BYTE),
1531
  DATE_TIME_STAMP DATE
1519
  DATE_TIME_STAMP DATE
1532
)
1520
)
1533
  TABLESPACE "SYSTEM"
1521
  TABLESPACE "USERS"
1534
  LOGGING 
1522
  LOGGING 
1535
  PCTFREE 10
1523
  PCTFREE 10
1536
  PCTUSED 40
1524
  PCTUSED 40
1537
  INITRANS 1
1525
  INITRANS 1
1538
  MAXTRANS 255
1526
  MAXTRANS 255
1539
  STORAGE
1527
  STORAGE
1540
  (
1528
  (
1541
    INITIAL 64K
1529
    INITIAL 64K
1542
    NEXT 64K
-
 
1543
    MINEXTENTS 1
1530
    MINEXTENTS 1
1544
    MAXEXTENTS 2147483645
1531
    MAXEXTENTS 2147483645
1545
    PCTINCREASE 0
-
 
1546
    FREELISTS 1
1532
    FREELISTS 1
1547
    FREELIST GROUPS 1
1533
    FREELIST GROUPS 1
1548
    BUFFER_POOL DEFAULT
1534
    BUFFER_POOL DEFAULT
1549
  )
1535
  )
1550
;
1536
;
Line 1552... Line 1538...
1552
CREATE TABLE VIEW_DEF
1538
CREATE TABLE VIEW_DEF
1553
(
1539
(
1554
  VIEW_ID NUMBER NOT NULL,
1540
  VIEW_ID NUMBER NOT NULL,
1555
  PKG_ID NUMBER NOT NULL
1541
  PKG_ID NUMBER NOT NULL
1556
)
1542
)
1557
  TABLESPACE "SYSTEM"
1543
  TABLESPACE "USERS"
1558
  LOGGING 
1544
  LOGGING 
1559
  PCTFREE 10
1545
  PCTFREE 10
1560
  PCTUSED 40
1546
  PCTUSED 40
1561
  INITRANS 1
1547
  INITRANS 1
1562
  MAXTRANS 255
1548
  MAXTRANS 255
1563
  STORAGE
1549
  STORAGE
1564
  (
1550
  (
1565
    INITIAL 64K
1551
    INITIAL 64K
1566
    NEXT 64K
-
 
1567
    MINEXTENTS 1
1552
    MINEXTENTS 1
1568
    MAXEXTENTS 2147483645
1553
    MAXEXTENTS 2147483645
1569
    PCTINCREASE 0
-
 
1570
    FREELISTS 1
1554
    FREELISTS 1
1571
    FREELIST GROUPS 1
1555
    FREELIST GROUPS 1
1572
    BUFFER_POOL DEFAULT
1556
    BUFFER_POOL DEFAULT
1573
  )
1557
  )
1574
;
1558
;
Line 1673... Line 1657...
1673
  PKG_ID NUMBER NOT NULL,
1657
  PKG_ID NUMBER NOT NULL,
1674
  DPKG_ID NUMBER NOT NULL,
1658
  DPKG_ID NUMBER NOT NULL,
1675
  BUILD_TYPE CHAR(1 BYTE) NOT NULL,
1659
  BUILD_TYPE CHAR(1 BYTE) NOT NULL,
1676
  DISPLAY_ORDER NUMBER
1660
  DISPLAY_ORDER NUMBER
1677
)
1661
)
1678
  TABLESPACE "SYSTEM"
1662
  TABLESPACE "USERS"
1679
  LOGGING 
1663
  LOGGING 
1680
  PCTFREE 10
1664
  PCTFREE 10
1681
  PCTUSED 40
1665
  PCTUSED 40
1682
  INITRANS 1
1666
  INITRANS 1
1683
  MAXTRANS 255
1667
  MAXTRANS 255
1684
  STORAGE
1668
  STORAGE
1685
  (
1669
  (
1686
    INITIAL 320K
1670
    INITIAL 320K
1687
    NEXT 64K
-
 
1688
    MINEXTENTS 1
1671
    MINEXTENTS 1
1689
    MAXEXTENTS 2147483645
1672
    MAXEXTENTS 2147483645
1690
    PCTINCREASE 0
-
 
1691
    FREELISTS 1
1673
    FREELISTS 1
1692
    FREELIST GROUPS 1
1674
    FREELIST GROUPS 1
1693
    BUFFER_POOL DEFAULT
1675
    BUFFER_POOL DEFAULT
1694
  )
1676
  )
1695
;
1677
;
Line 1769... Line 1751...
1769
  (
1751
  (
1770
    PKG_ID
1752
    PKG_ID
1771
  )
1753
  )
1772
  ENABLE
1754
  ENABLE
1773
)
1755
)
1774
  TABLESPACE "SYSTEM"
1756
  TABLESPACE "USERS"
1775
  LOGGING 
1757
  LOGGING 
1776
  PCTFREE 10
1758
  PCTFREE 10
1777
  PCTUSED 40
1759
  PCTUSED 40
1778
  INITRANS 1
1760
  INITRANS 1
1779
  MAXTRANS 255
1761
  MAXTRANS 255
1780
  STORAGE
1762
  STORAGE
1781
  (
1763
  (
1782
    INITIAL 64K
1764
    INITIAL 64K
1783
    NEXT 64K
-
 
1784
    MINEXTENTS 1
1765
    MINEXTENTS 1
1785
    MAXEXTENTS 2147483645
1766
    MAXEXTENTS 2147483645
1786
    PCTINCREASE 0
-
 
1787
    FREELISTS 1
1767
    FREELISTS 1
1788
    FREELIST GROUPS 1
1768
    FREELIST GROUPS 1
1789
    BUFFER_POOL DEFAULT
1769
    BUFFER_POOL DEFAULT
1790
  )
1770
  )
1791
;
1771
;
Line 1843... Line 1823...
1843
  (
1823
  (
1844
    PROJ_ID
1824
    PROJ_ID
1845
  )
1825
  )
1846
  ENABLE
1826
  ENABLE
1847
)
1827
)
1848
  TABLESPACE "SYSTEM"
1828
  TABLESPACE "USERS"
1849
  LOGGING 
1829
  LOGGING 
1850
  PCTFREE 10
1830
  PCTFREE 10
1851
  PCTUSED 40
1831
  PCTUSED 40
1852
  INITRANS 1
1832
  INITRANS 1
1853
  MAXTRANS 255
1833
  MAXTRANS 255
1854
  STORAGE
1834
  STORAGE
1855
  (
1835
  (
1856
    INITIAL 64K
1836
    INITIAL 64K
1857
    NEXT 64K
-
 
1858
    MINEXTENTS 1
1837
    MINEXTENTS 1
1859
    MAXEXTENTS 2147483645
1838
    MAXEXTENTS 2147483645
1860
    PCTINCREASE 0
-
 
1861
    FREELISTS 1
1839
    FREELISTS 1
1862
    FREELIST GROUPS 1
1840
    FREELIST GROUPS 1
1863
    BUFFER_POOL DEFAULT
1841
    BUFFER_POOL DEFAULT
1864
  )
1842
  )
1865
;
1843
;
Line 1875... Line 1853...
1875
  (
1853
  (
1876
    VIEW_ID
1854
    VIEW_ID
1877
  )
1855
  )
1878
  ENABLE
1856
  ENABLE
1879
)
1857
)
1880
  TABLESPACE "SYSTEM"
1858
  TABLESPACE "USERS"
1881
  LOGGING 
1859
  LOGGING 
1882
  PCTFREE 10
1860
  PCTFREE 10
1883
  PCTUSED 40
1861
  PCTUSED 40
1884
  INITRANS 1
1862
  INITRANS 1
1885
  MAXTRANS 255
1863
  MAXTRANS 255
1886
  STORAGE
1864
  STORAGE
1887
  (
1865
  (
1888
    INITIAL 64K
1866
    INITIAL 64K
1889
    NEXT 64K
-
 
1890
    MINEXTENTS 1
1867
    MINEXTENTS 1
1891
    MAXEXTENTS 2147483645
1868
    MAXEXTENTS 2147483645
1892
    PCTINCREASE 0
-
 
1893
    FREELISTS 1
1869
    FREELISTS 1
1894
    FREELIST GROUPS 1
1870
    FREELIST GROUPS 1
1895
    BUFFER_POOL DEFAULT
1871
    BUFFER_POOL DEFAULT
1896
  )
1872
  )
1897
;
1873
;
Line 2029... Line 2005...
2029
  BS_ID NUMBER,
2005
  BS_ID NUMBER,
2030
  IS_AUTOBUILDABLE CHAR(1 BYTE),
2006
  IS_AUTOBUILDABLE CHAR(1 BYTE),
2031
  SBOM_PRIORITY CHAR(1 BYTE),
2007
  SBOM_PRIORITY CHAR(1 BYTE),
2032
  RIPPLE_FIELD CHAR(1 CHAR),
2008
  RIPPLE_FIELD CHAR(1 CHAR),
2033
  MAXIMUM_BUILD_TIME NUMBER,
2009
  MAXIMUM_BUILD_TIME NUMBER,
2034
  ESTIMATED_COMPLETION_TIME DATE
2010
  ESTIMATED_COMPLETION_TIME DATE,
-
 
2011
  MAJOR_LIMIT NUMBER(10, 0),
-
 
2012
  MINOR_LIMIT NUMBER(10, 0),
-
 
2013
  PATCH_LIMIT NUMBER(10, 0),
-
 
2014
  BUILD_NUMBER_LIMIT NUMBER(10, 0)
2035
, CONSTRAINT PK_PACKAGE_VERSIONS PRIMARY KEY
2015
, CONSTRAINT PK_PACKAGE_VERSIONS PRIMARY KEY
2036
  (
2016
  (
2037
    PV_ID
2017
    PV_ID
2038
  )
2018
  )
2039
  ENABLE
2019
  ENABLE
2040
)
2020
)
2041
  TABLESPACE "SYSTEM"
2021
  TABLESPACE "USERS"
2042
  LOGGING 
2022
  LOGGING 
2043
  PCTFREE 10
2023
  PCTFREE 10
2044
  PCTUSED 40
2024
  PCTUSED 40
2045
  INITRANS 1
2025
  INITRANS 1
2046
  MAXTRANS 255
2026
  MAXTRANS 255
2047
  STORAGE
2027
  STORAGE
2048
  (
2028
  (
2049
    INITIAL 192K
2029
    INITIAL 192K
2050
    NEXT 64K
-
 
2051
    MINEXTENTS 1
2030
    MINEXTENTS 1
2052
    MAXEXTENTS 2147483645
2031
    MAXEXTENTS 2147483645
2053
    PCTINCREASE 0
-
 
2054
    FREELISTS 1
2032
    FREELISTS 1
2055
    FREELIST GROUPS 1
2033
    FREELIST GROUPS 1
2056
    BUFFER_POOL DEFAULT
2034
    BUFFER_POOL DEFAULT
2057
  )
2035
  )
2058
;
2036
;
Line 2159... Line 2137...
2159
  ISS_ID NUMBER NOT NULL,
2137
  ISS_ID NUMBER NOT NULL,
2160
  ISS_STATE NUMBER NOT NULL,
2138
  ISS_STATE NUMBER NOT NULL,
2161
  MOD_DATE DATE NOT NULL,
2139
  MOD_DATE DATE NOT NULL,
2162
  NOTES VARCHAR2(255 BYTE)
2140
  NOTES VARCHAR2(255 BYTE)
2163
)
2141
)
2164
  TABLESPACE "SYSTEM"
2142
  TABLESPACE "USERS"
2165
  LOGGING 
2143
  LOGGING 
2166
  PCTFREE 10
2144
  PCTFREE 10
2167
  PCTUSED 40
2145
  PCTUSED 40
2168
  INITRANS 1
2146
  INITRANS 1
2169
  MAXTRANS 255
2147
  MAXTRANS 255
2170
  STORAGE
2148
  STORAGE
2171
  (
2149
  (
2172
    INITIAL 64K
2150
    INITIAL 64K
2173
    NEXT 64K
-
 
2174
    MINEXTENTS 1
2151
    MINEXTENTS 1
2175
    MAXEXTENTS 2147483645
2152
    MAXEXTENTS 2147483645
2176
    PCTINCREASE 0
-
 
2177
    FREELISTS 1
2153
    FREELISTS 1
2178
    FREELIST GROUPS 1
2154
    FREELIST GROUPS 1
2179
    BUFFER_POOL DEFAULT
2155
    BUFFER_POOL DEFAULT
2180
  )
2156
  )
2181
;
2157
;
Line 3008... Line 2984...
3008
    NULL AS PKG_STATE,
2984
    NULL AS PKG_STATE,
3009
 NULL AS DEPRECATED_STATE,
2985
 NULL AS DEPRECATED_STATE,
3010
    NULL AS INSERTOR_ID,
2986
    NULL AS INSERTOR_ID,
3011
    NULL AS INSERT_STAMP,
2987
    NULL AS INSERT_STAMP,
3012
    pl.operation
2988
    pl.operation
3013
  FROM PLANNED pl;
2989
FROM PLANNED pl;
3014
 
2990
 
3015
CREATE UNIQUE INDEX UNQ_PKG_BUILD_ENV ON PACKAGE_BUILD_ENV (PV_ID ASC, BE_ID ASC)  TABLESPACE "USERS"
2991
CREATE UNIQUE INDEX UNQ_PKG_BUILD_ENV ON PACKAGE_BUILD_ENV (PV_ID ASC, BE_ID ASC)  TABLESPACE "USERS"
3016
  LOGGING 
2992
  LOGGING 
3017
  PCTFREE 10
2993
  PCTFREE 10
3018
  INITRANS 2
2994
  INITRANS 2
Line 3394... Line 3370...
3394
    FREELIST GROUPS 1
3370
    FREELIST GROUPS 1
3395
    BUFFER_POOL DEFAULT
3371
    BUFFER_POOL DEFAULT
3396
  )
3372
  )
3397
;
3373
;
3398
 
3374
 
3399
CREATE UNIQUE INDEX UNQ_VIEW_SETTINGS ON VIEW_SETTINGS (USER_ID ASC, VIEW_ID ASC)  TABLESPACE "SYSTEM"
3375
CREATE UNIQUE INDEX UNQ_VIEW_SETTINGS ON VIEW_SETTINGS (USER_ID ASC, VIEW_ID ASC)  TABLESPACE "USERS"
3400
  LOGGING 
3376
  LOGGING 
3401
  PCTFREE 10
3377
  PCTFREE 10
3402
  INITRANS 2
3378
  INITRANS 2
3403
  MAXTRANS 255
3379
  MAXTRANS 255
3404
  STORAGE
3380
  STORAGE
3405
  (
3381
  (
3406
    INITIAL 64K
3382
    INITIAL 64K
3407
    NEXT 64K
-
 
3408
    MINEXTENTS 1
3383
    MINEXTENTS 1
3409
    MAXEXTENTS 2147483645
3384
    MAXEXTENTS 2147483645
3410
    PCTINCREASE 0
-
 
3411
    FREELISTS 1
3385
    FREELISTS 1
3412
    FREELIST GROUPS 1
3386
    FREELIST GROUPS 1
3413
    BUFFER_POOL DEFAULT
3387
    BUFFER_POOL DEFAULT
3414
  )
3388
  )
3415
;
3389
;
3416
 
3390
 
3417
CREATE UNIQUE INDEX UNQ_VTREES ON VTREES (PROJ_ID ASC, VTREE_NAME ASC)  TABLESPACE "SYSTEM"
3391
CREATE UNIQUE INDEX UNQ_VTREES ON VTREES (PROJ_ID ASC, VTREE_NAME ASC)  TABLESPACE "USERS"
3418
  LOGGING 
3392
  LOGGING 
3419
  PCTFREE 10
3393
  PCTFREE 10
3420
  INITRANS 2
3394
  INITRANS 2
3421
  MAXTRANS 255
3395
  MAXTRANS 255
3422
  STORAGE
3396
  STORAGE
3423
  (
3397
  (
3424
    INITIAL 64K
3398
    INITIAL 64K
3425
    NEXT 64K
-
 
3426
    MINEXTENTS 1
3399
    MINEXTENTS 1
3427
    MAXEXTENTS 2147483645
3400
    MAXEXTENTS 2147483645
3428
    PCTINCREASE 0
-
 
3429
    FREELISTS 1
3401
    FREELISTS 1
3430
    FREELIST GROUPS 1
3402
    FREELIST GROUPS 1
3431
    BUFFER_POOL DEFAULT
3403
    BUFFER_POOL DEFAULT
3432
  )
3404
  )
3433
;
3405
;
Line 3526... Line 3498...
3526
    FREELIST GROUPS 1
3498
    FREELIST GROUPS 1
3527
    BUFFER_POOL DEFAULT
3499
    BUFFER_POOL DEFAULT
3528
  )
3500
  )
3529
;
3501
;
3530
 
3502
 
3531
CREATE UNIQUE INDEX UNQ_PROJECT_EXT ON PROJECT_EXTENTIONS (PROJ_ID ASC, EXT_NAME ASC)  TABLESPACE "SYSTEM"
3503
CREATE UNIQUE INDEX UNQ_PROJECT_EXT ON PROJECT_EXTENTIONS (PROJ_ID ASC, EXT_NAME ASC)  TABLESPACE "USERS"
3532
  LOGGING 
3504
  LOGGING 
3533
  PCTFREE 10
3505
  PCTFREE 10
3534
  INITRANS 2
3506
  INITRANS 2
3535
  MAXTRANS 255
3507
  MAXTRANS 255
3536
  STORAGE
3508
  STORAGE
3537
  (
3509
  (
3538
    INITIAL 64K
3510
    INITIAL 64K
3539
    NEXT 64K
-
 
3540
    MINEXTENTS 1
3511
    MINEXTENTS 1
3541
    MAXEXTENTS 2147483645
3512
    MAXEXTENTS 2147483645
3542
    PCTINCREASE 0
-
 
3543
    FREELISTS 1
3513
    FREELISTS 1
3544
    FREELIST GROUPS 1
3514
    FREELIST GROUPS 1
3545
    BUFFER_POOL DEFAULT
3515
    BUFFER_POOL DEFAULT
3546
  )
3516
  )
3547
;
3517
;
Line 3576... Line 3546...
3576
    FREELIST GROUPS 1
3546
    FREELIST GROUPS 1
3577
    BUFFER_POOL DEFAULT
3547
    BUFFER_POOL DEFAULT
3578
  )
3548
  )
3579
;
3549
;
3580
 
3550
 
3581
CREATE INDEX INX_MSGBOARD ON MESSAGE_BOARD (EXPIRY_DATE ASC, DUE_DATE ASC)  TABLESPACE "SYSTEM"
3551
CREATE INDEX INX_MSGBOARD ON MESSAGE_BOARD (EXPIRY_DATE ASC, DUE_DATE ASC)  TABLESPACE "USERS"
3582
  LOGGING 
3552
  LOGGING 
3583
  PCTFREE 10
3553
  PCTFREE 10
3584
  INITRANS 2
3554
  INITRANS 2
3585
  MAXTRANS 255
3555
  MAXTRANS 255
3586
  STORAGE
3556
  STORAGE
3587
  (
3557
  (
3588
    INITIAL 64K
3558
    INITIAL 64K
3589
    NEXT 64K
-
 
3590
    MINEXTENTS 1
3559
    MINEXTENTS 1
3591
    MAXEXTENTS 2147483645
3560
    MAXEXTENTS 2147483645
3592
    PCTINCREASE 0
-
 
3593
    FREELISTS 1
3561
    FREELISTS 1
3594
    FREELIST GROUPS 1
3562
    FREELIST GROUPS 1
3595
    BUFFER_POOL DEFAULT
3563
    BUFFER_POOL DEFAULT
3596
  )
3564
  )
3597
;
3565
;
Line 3738... Line 3706...
3738
    FREELIST GROUPS 1
3706
    FREELIST GROUPS 1
3739
    BUFFER_POOL DEFAULT
3707
    BUFFER_POOL DEFAULT
3740
  )
3708
  )
3741
;
3709
;
3742
 
3710
 
3743
CREATE UNIQUE INDEX UNQ_VIEW_DEF ON VIEW_DEF (VIEW_ID ASC, PKG_ID ASC)  TABLESPACE "SYSTEM"
3711
CREATE UNIQUE INDEX UNQ_VIEW_DEF ON VIEW_DEF (VIEW_ID ASC, PKG_ID ASC)  TABLESPACE "USERS"
3744
  LOGGING 
3712
  LOGGING 
3745
  PCTFREE 10
3713
  PCTFREE 10
3746
  INITRANS 2
3714
  INITRANS 2
3747
  MAXTRANS 255
3715
  MAXTRANS 255
3748
  STORAGE
3716
  STORAGE
3749
  (
3717
  (
3750
    INITIAL 64K
3718
    INITIAL 64K
3751
    NEXT 64K
-
 
3752
    MINEXTENTS 1
3719
    MINEXTENTS 1
3753
    MAXEXTENTS 2147483645
3720
    MAXEXTENTS 2147483645
3754
    PCTINCREASE 0
-
 
3755
    FREELISTS 1
3721
    FREELISTS 1
3756
    FREELIST GROUPS 1
3722
    FREELIST GROUPS 1
3757
    BUFFER_POOL DEFAULT
3723
    BUFFER_POOL DEFAULT
3758
  )
3724
  )
3759
;
3725
;
Line 3852... Line 3818...
3852
    FREELIST GROUPS 1
3818
    FREELIST GROUPS 1
3853
    BUFFER_POOL DEFAULT
3819
    BUFFER_POOL DEFAULT
3854
  )
3820
  )
3855
;
3821
;
3856
 
3822
 
3857
CREATE UNIQUE INDEX UNQ_PACKAGE_DEPENDENCIES ON PACKAGE_DEPENDENCIES (PV_ID ASC, DPV_ID ASC)  TABLESPACE "SYSTEM"
3823
CREATE UNIQUE INDEX UNQ_PACKAGE_DEPENDENCIES ON PACKAGE_DEPENDENCIES (PV_ID ASC, DPV_ID ASC)  TABLESPACE "USERS"
3858
  LOGGING 
3824
  LOGGING 
3859
  PCTFREE 10
3825
  PCTFREE 10
3860
  INITRANS 2
3826
  INITRANS 2
3861
  MAXTRANS 255
3827
  MAXTRANS 255
3862
  STORAGE
3828
  STORAGE
3863
  (
3829
  (
3864
    INITIAL 384K
3830
    INITIAL 384K
3865
    NEXT 64K
-
 
3866
    MINEXTENTS 1
3831
    MINEXTENTS 1
3867
    MAXEXTENTS 2147483645
3832
    MAXEXTENTS 2147483645
3868
    PCTINCREASE 0
-
 
3869
    FREELISTS 1
3833
    FREELISTS 1
3870
    FREELIST GROUPS 1
3834
    FREELIST GROUPS 1
3871
    BUFFER_POOL DEFAULT
3835
    BUFFER_POOL DEFAULT
3872
  )
3836
  )
3873
;
3837
;
Line 3902... Line 3866...
3902
    FREELIST GROUPS 1
3866
    FREELIST GROUPS 1
3903
    BUFFER_POOL DEFAULT
3867
    BUFFER_POOL DEFAULT
3904
  )
3868
  )
3905
;
3869
;
3906
 
3870
 
3907
CREATE UNIQUE INDEX UNQ_PACKAGES ON PACKAGES (PKG_NAME ASC)  TABLESPACE "SYSTEM"
3871
CREATE UNIQUE INDEX UNQ_PACKAGES ON PACKAGES (PKG_NAME ASC)  TABLESPACE "USERS"
3908
  LOGGING 
3872
  LOGGING 
3909
  PCTFREE 10
3873
  PCTFREE 10
3910
  INITRANS 2
3874
  INITRANS 2
3911
  MAXTRANS 255
3875
  MAXTRANS 255
3912
  STORAGE
3876
  STORAGE
3913
  (
3877
  (
3914
    INITIAL 64K
3878
    INITIAL 64K
3915
    NEXT 64K
-
 
3916
    MINEXTENTS 1
3879
    MINEXTENTS 1
3917
    MAXEXTENTS 2147483645
3880
    MAXEXTENTS 2147483645
3918
    PCTINCREASE 0
-
 
3919
    FREELISTS 1
3881
    FREELISTS 1
3920
    FREELIST GROUPS 1
3882
    FREELIST GROUPS 1
3921
    BUFFER_POOL DEFAULT
3883
    BUFFER_POOL DEFAULT
3922
  )
3884
  )
3923
;
3885
;
3924
 
3886
 
3925
CREATE UNIQUE INDEX UNQ_PROJECTS ON PROJECTS (PROJ_NAME ASC)  TABLESPACE "SYSTEM"
3887
CREATE UNIQUE INDEX UNQ_PROJECTS ON PROJECTS (PROJ_NAME ASC)  TABLESPACE "USERS"
3926
  LOGGING 
3888
  LOGGING 
3927
  PCTFREE 10
3889
  PCTFREE 10
3928
  INITRANS 2
3890
  INITRANS 2
3929
  MAXTRANS 255
3891
  MAXTRANS 255
3930
  STORAGE
3892
  STORAGE
3931
  (
3893
  (
3932
    INITIAL 64K
3894
    INITIAL 64K
3933
    NEXT 64K
-
 
3934
    MINEXTENTS 1
3895
    MINEXTENTS 1
3935
    MAXEXTENTS 2147483645
3896
    MAXEXTENTS 2147483645
3936
    PCTINCREASE 0
-
 
3937
    FREELISTS 1
3897
    FREELISTS 1
3938
    FREELIST GROUPS 1
3898
    FREELIST GROUPS 1
3939
    BUFFER_POOL DEFAULT
3899
    BUFFER_POOL DEFAULT
3940
  )
3900
  )
3941
;
3901
;
3942
 
3902
 
3943
CREATE UNIQUE INDEX UNQ_VIEWS ON VIEWS (VIEW_NAME ASC, OWNER_ID ASC)  TABLESPACE "SYSTEM"
3903
CREATE UNIQUE INDEX UNQ_VIEWS ON VIEWS (VIEW_NAME ASC, OWNER_ID ASC)  TABLESPACE "USERS"
3944
  LOGGING 
3904
  LOGGING 
3945
  PCTFREE 10
3905
  PCTFREE 10
3946
  INITRANS 2
3906
  INITRANS 2
3947
  MAXTRANS 255
3907
  MAXTRANS 255
3948
  STORAGE
3908
  STORAGE
3949
  (
3909
  (
3950
    INITIAL 64K
3910
    INITIAL 64K
3951
    NEXT 64K
-
 
3952
    MINEXTENTS 1
3911
    MINEXTENTS 1
3953
    MAXEXTENTS 2147483645
3912
    MAXEXTENTS 2147483645
3954
    PCTINCREASE 0
-
 
3955
    FREELISTS 1
3913
    FREELISTS 1
3956
    FREELIST GROUPS 1
3914
    FREELIST GROUPS 1
3957
    BUFFER_POOL DEFAULT
3915
    BUFFER_POOL DEFAULT
3958
  )
3916
  )
3959
;
3917
;
Line 4068... Line 4026...
4068
    FREELIST GROUPS 1
4026
    FREELIST GROUPS 1
4069
    BUFFER_POOL DEFAULT
4027
    BUFFER_POOL DEFAULT
4070
  )
4028
  )
4071
;
4029
;
4072
 
4030
 
4073
CREATE UNIQUE INDEX UNQ_PACKAGE_VERSIONS ON PACKAGE_VERSIONS (PKG_ID ASC, PKG_VERSION ASC)  TABLESPACE "SYSTEM"
4031
CREATE UNIQUE INDEX UNQ_PACKAGE_VERSIONS ON PACKAGE_VERSIONS (PKG_ID ASC, PKG_VERSION ASC)  TABLESPACE "USERS"
4074
  LOGGING 
4032
  LOGGING 
4075
  PCTFREE 10
4033
  PCTFREE 10
4076
  INITRANS 2
4034
  INITRANS 2
4077
  MAXTRANS 255
4035
  MAXTRANS 255
4078
  STORAGE
4036
  STORAGE
4079
  (
4037
  (
4080
    INITIAL 128K
4038
    INITIAL 128K
4081
    NEXT 64K
-
 
4082
    MINEXTENTS 1
4039
    MINEXTENTS 1
4083
    MAXEXTENTS 2147483645
4040
    MAXEXTENTS 2147483645
4084
    PCTINCREASE 0
-
 
4085
    FREELISTS 1
4041
    FREELISTS 1
4086
    FREELIST GROUPS 1
4042
    FREELIST GROUPS 1
4087
    BUFFER_POOL DEFAULT
4043
    BUFFER_POOL DEFAULT
4088
  )
4044
  )
4089
;
4045
;
Line 7611... Line 7567...
7611
   ||  Modified Date:  19/Aug/2008
7567
   ||  Modified Date:  19/Aug/2008
7612
   ||  Version      :  3.6 (added licencing cloning)
7568
   ||  Version      :  3.6 (added licencing cloning)
7613
   --------------------------------------------------------------------------- */
7569
   --------------------------------------------------------------------------- */
7614
 
7570
 
7615
   FromVersion PACKAGE_VERSIONS.PKG_VERSION%TYPE;
7571
   FromVersion PACKAGE_VERSIONS.PKG_VERSION%TYPE;
-
 
7572
major NUMBER;
-
 
7573
minor NUMBER;
7616
 
7574
patch NUMBER;
-
 
7575
buildn NUMBER;
7617
BEGIN
7576
BEGIN
7618
 
-
 
-
 
7577
------------------------------------- Limits ---------------------------------------------------
-
 
7578
   select major_limit, minor_limit, patch_limit, build_number_limit
-
 
7579
   into major, minor, patch, buildn
-
 
7580
   from package_versions where pv_id=nFROMpv_id;
-
 
7581
    UPDATE package_versions SET
-
 
7582
           major_limit = major,
-
 
7583
           minor_limit = minor,
-
 
7584
           patch_limit = patch,
-
 
7585
           build_number_limit = buildn
-
 
7586
     WHERE PV_ID = nTOpv_id;
7619
------------------------------------- Clone Dependencies ---------------------------------------------------
7587
------------------------------------- Clone Dependencies ---------------------------------------------------
7620
   IF NOT nRtag_id IS NULL
7588
   IF NOT nRtag_id IS NULL
7621
   THEN
7589
   THEN
7622
      -- Auto Update Dependencies --
7590
      -- Auto Update Dependencies --
7623
      INSERT INTO PACKAGE_DEPENDENCIES
7591
      INSERT INTO PACKAGE_DEPENDENCIES
Line 18895... Line 18863...
18895
CREATE OR REPLACE PACKAGE BODY                   "PK_PLANNED" IS
18863
CREATE OR REPLACE PACKAGE BODY                   "PK_PLANNED" IS
18896
 
18864
 
18897
/*
18865
/*
18898
------------------------------
18866
------------------------------
18899
||  Last Modified:  G.Huddy
18867
||  Last Modified:  G.Huddy
18900
||  Modified Date:  28/May/2008
18868
||  Modified Date:  05/Aug/2008
18901
||  Body Version:   1.1
18869
||  Body Version:   1.2
18902
------------------------------
18870
------------------------------
18903
*/
18871
*/
18904
 
18872
 
18905
 
18873
 
18906
/*-------------------------------------------------------------------------------------------------------*/
18874
/*-------------------------------------------------------------------------------------------------------*/
18907
PROCEDURE ADD_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER ) IS
18875
PROCEDURE ADD_PACKAGE ( newPvId IN NUMBER, ViewId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER ) IS
18908
 
18876
 
18909
	oldPvId NUMBER;
18877
    oldPvId NUMBER;
18910
	ReleaseLocation VARCHAR2(4000);
18878
    ReleaseLocation VARCHAR2(4000);
18911
	IsPatch CHAR(1) := NULL;
18879
    IsPatch CHAR(1) := NULL;
18912
	sLocation VARCHAR2(4000) := NULL;
18880
    sLocation VARCHAR2(4000) := NULL;
18913
	nRtagIdLocation NUMBER;
18881
    nRtagIdLocation NUMBER;
18914
 
18882
 
18915
 
18883
 
18916
 
18884
 
18917
BEGIN
18885
BEGIN
18918
	/*--------------- Business Rules Here -------------------*/
18886
    /*--------------- Business Rules Here -------------------*/
18919
	/*-------------------------------------------------------*/
18887
    /*-------------------------------------------------------*/
18920
 
-
 
18921
	BEGIN
-
 
18922
		-- Check if Exists in "Work in progress" anywhere in the world, except "Closed mode" releases
-
 
18923
		SELECT proj.PROJ_NAME ||' > '|| rt.RTAG_NAME, rt.RTAG_ID  INTO sLocation, nRtagIdLocation
-
 
18924
		  FROM PLANNED pl,
-
 
18925
			   RELEASE_TAGS rt,
-
 
18926
			   PROJECTS proj
-
 
18927
		 WHERE pl.PV_ID = newPvId
-
 
18928
		   AND pl.RTAG_ID = rt.RTAG_ID
-
 
18929
		   AND rt.OFFICIAL != 'Y'
-
 
18930
		   AND rt.PROJ_ID = proj.PROJ_ID;
-
 
18931
 
-
 
18932
		EXCEPTION
-
 
18933
			WHEN NO_DATA_FOUND THEN
-
 
18934
				sLocation := NULL;
-
 
18935
	END;
-
 
18936
 
18888
 
-
 
18889
    BEGIN
-
 
18890
        -- Check if Exists in "Work in progress" anywhere in the world, except "Closed mode" releases
-
 
18891
        SELECT proj.PROJ_NAME ||' > '|| rt.RTAG_NAME, rt.RTAG_ID  INTO sLocation, nRtagIdLocation
-
 
18892
          FROM PLANNED pl,
-
 
18893
               RELEASE_TAGS rt,
-
 
18894
               PROJECTS proj
-
 
18895
         WHERE pl.PV_ID = newPvId
-
 
18896
           AND pl.RTAG_ID = rt.RTAG_ID
-
 
18897
           AND rt.OFFICIAL != 'Y'
-
 
18898
           AND rt.PROJ_ID = proj.PROJ_ID;
-
 
18899
 
-
 
18900
        EXCEPTION
-
 
18901
            WHEN NO_DATA_FOUND THEN
-
 
18902
                sLocation := NULL;
-
 
18903
    END;
18937
 
18904
 
18938
 
18905
 
18939
	IF (sLocation IS NULL) OR (nRtagIdLocation = RtagId) THEN
-
 
18940
 
18906
 
-
 
18907
    IF (sLocation IS NULL) OR (nRtagIdLocation = RtagId) THEN
-
 
18908
 
18941
		-- Add to "Pending" area
18909
        -- Add to "Pending" area
18942
		INSERT INTO PLANNED ( RTAG_ID, PV_ID, VIEW_ID, OPERATION )
18910
        INSERT INTO PLANNED ( RTAG_ID, PV_ID, VIEW_ID, OPERATION )
18943
		VALUES( RtagId, newPvId, ViewId, 'R' );
18911
        VALUES( RtagId, newPvId, ViewId, 'R' );
18944
 
18912
 
18945
 
18913
 
18946
		/* LOG ACTION */
18914
        /* LOG ACTION */
18947
		SELECT proj.PROJ_NAME ||' / '|| rt.RTAG_NAME INTO ReleaseLocation
18915
        SELECT proj.PROJ_NAME ||' / '|| rt.RTAG_NAME INTO ReleaseLocation
18948
		  FROM PROJECTS proj,
18916
          FROM PROJECTS proj,
18949
			   RELEASE_TAGS rt
18917
               RELEASE_TAGS rt
18950
		 WHERE rt.PROJ_ID = proj.PROJ_ID
18918
         WHERE rt.PROJ_ID = proj.PROJ_ID
18951
		   AND rt.RTAG_ID = RtagId;
18919
           AND rt.RTAG_ID = RtagId;
18952
 
18920
 
18953
		Log_Action ( newPvId, 'add_to_planned', UserId, 'Location: '|| ReleaseLocation );
18921
        Log_Action ( newPvId, 'add_to_planned', UserId, 'Location: '|| ReleaseLocation );
18954
 
18922
 
18955
	ELSE
18923
    ELSE
18956
 
18924
 
18957
		RAISE_APPLICATION_ERROR (-20000, 'This version is already in Pending Area at '|| sLocation ||'.' );
18925
        RAISE_APPLICATION_ERROR (-20000, 'This version is already in Pending Area at '|| sLocation ||'.' );
18958
 
18926
 
18959
	END IF;
18927
    END IF;
18960
 
18928
 
18961
END;
18929
END;
18962
/*-------------------------------------------------------------------------------------------------------*/
18930
/*-------------------------------------------------------------------------------------------------------*/
18963
PROCEDURE REMOVE_PACKAGE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER ) IS
18931
PROCEDURE REMOVE_PACKAGE ( PvId IN NUMBER, RtagId IN NUMBER, UserId IN NUMBER ) IS
18964
 
18932
 
18965
	ReleaseLocation VARCHAR2(4000);
18933
    ReleaseLocation VARCHAR2(4000);
18966
 
18934
 
18967
BEGIN
18935
BEGIN
18968
 
18936
 
18969
	/*--------------- Business Rules Here -------------------*/
18937
    /*--------------- Business Rules Here -------------------*/
18970
	/*-------------------------------------------------------*/
18938
    /*-------------------------------------------------------*/
18971
 
18939
 
18972
 
18940
 
18973
	-- Get release location for logging pusposes
18941
    -- Get release location for logging pusposes
18974
	SELECT proj.PROJ_NAME  ||' / '|| rt.RTAG_NAME INTO ReleaseLocation
18942
    SELECT proj.PROJ_NAME  ||' / '|| rt.RTAG_NAME INTO ReleaseLocation
18975
	  FROM PROJECTS proj,
18943
      FROM PROJECTS proj,
18976
		   RELEASE_TAGS rt
18944
           RELEASE_TAGS rt
18977
	 WHERE rt.PROJ_ID = proj.PROJ_ID
18945
     WHERE rt.PROJ_ID = proj.PROJ_ID
18978
	   AND rt.RTAG_ID = RtagId;
18946
       AND rt.RTAG_ID = RtagId;
18979
 
18947
 
18980
 
18948
 
18981
	-- Delete from Work In Progress
18949
    -- Delete from Work In Progress
18982
	DELETE
18950
    DELETE
18983
	  FROM PLANNED pl
18951
      FROM PLANNED pl
18984
	 WHERE pl.RTAG_ID = RtagId
18952
     WHERE pl.RTAG_ID = RtagId
18985
	   AND pl.PV_ID = PvId;
18953
       AND pl.PV_ID = PvId;
18986
 
18954
 
18987
	Log_Action ( PvId, 'deleted_from_pending', UserId, 'Location: '|| ReleaseLocation );
18955
    Log_Action ( PvId, 'deleted_from_pending', UserId, 'Location: '|| ReleaseLocation );
18988
 
18956
 
18989
 
18957
 
18990
 
18958
 
18991
 
18959
 
18992
END;
18960
END;
18993
/*-------------------------------------------------------------------------------------------------------*/
18961
/*-------------------------------------------------------------------------------------------------------*/
18994
FUNCTION GET_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER ) RETURN NUMBER IS
18962
FUNCTION GET_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER ) RETURN NUMBER IS
18995
 
18963
 
18996
	ReturnValue NUMBER;
18964
    ReturnValue NUMBER;
18997
 
18965
 
18998
BEGIN
18966
BEGIN
18999
	SELECT pl.VIEW_ID INTO ReturnValue
18967
    SELECT pl.VIEW_ID INTO ReturnValue
19000
	  FROM PLANNED pl
18968
      FROM PLANNED pl
19001
	 WHERE pl.RTAG_ID = RtagId
18969
     WHERE pl.RTAG_ID = RtagId
19002
	   AND pl.PV_ID = PvId;
18970
       AND pl.PV_ID = PvId;
19003
 
18971
 
19004
	RETURN ReturnValue;
18972
    RETURN ReturnValue;
19005
END;
18973
END;
19006
/*-------------------------------------------------------------------------------------------------------*/
18974
/*-------------------------------------------------------------------------------------------------------*/
19007
PROCEDURE GET_VIEW_CONTENT ( RtagId IN NUMBER, ViewId IN NUMBER, RecordSet OUT typeCur ) IS
18975
PROCEDURE GET_VIEW_CONTENT ( RtagId IN NUMBER, ViewId IN NUMBER, RecordSet OUT typeCur ) IS
19008
 
18976
 
19009
	IsBaseView CHAR(1);
18977
    IsBaseView CHAR(1);
19010
 
18978
 
19011
BEGIN
18979
BEGIN
19012
 
18980
 
19013
	-- Check if the view is BASE VIEW
18981
    -- Check if the view is BASE VIEW
19014
	SELECT vi.BASE_VIEW INTO IsBaseView
18982
    SELECT vi.BASE_VIEW INTO IsBaseView
19015
	  FROM VIEWS vi
18983
      FROM VIEWS vi
19016
	 WHERE vi.VIEW_ID = ViewId;
18984
     WHERE vi.VIEW_ID = ViewId;
-
 
18985
 
19017
 
18986
 
-
 
18987
    IF (IsBaseView = 'Y') THEN
-
 
18988
        -- Get Base view content
-
 
18989
        OPEN RecordSet FOR
-
 
18990
        SELECT 0 AS PKG_STATE,
-
 
18991
               NULL AS DEPRECATED_STATE,
-
 
18992
               pv.pv_id,
-
 
18993
               pkg.pkg_name,
-
 
18994
               pv.pkg_version,
-
 
18995
               pv.dlocked,
-
 
18996
               pv.pv_description,
-
 
18997
               pv.BUILD_TYPE,
-
 
18998
               rel.operation
-
 
18999
          FROM PLANNED rel,
-
 
19000
               packages pkg,
-
 
19001
               package_versions pv
-
 
19002
         WHERE pv.pkg_id = pkg.pkg_id
-
 
19003
           AND rel.pv_id = pv.pv_id
-
 
19004
           AND rel.VIEW_ID = ViewId
-
 
19005
           AND rel.RTAG_ID = RtagId
-
 
19006
         ORDER BY UPPER(pkg.PKG_NAME);
19018
 
19007
 
19019
	IF (IsBaseView = 'Y') THEN
-
 
19020
		-- Get Base view content
-
 
19021
		OPEN RecordSet FOR
-
 
19022
		SELECT 0 AS PKG_STATE,
-
 
19023
			   NULL AS DEPRECATED_STATE,
-
 
19024
			   pv.pv_id,
19008
    ELSE
19025
			   pkg.pkg_name,
-
 
19026
			   pv.pkg_version,
-
 
19027
			   pv.dlocked,
-
 
19028
			   pv.pv_description,
-
 
19029
			   pv.BUILD_TYPE,
-
 
19030
			   rel.operation
-
 
19031
		  FROM PLANNED rel,
-
 
19032
			   packages pkg,
-
 
19033
			   package_versions pv
-
 
19034
		 WHERE pv.pkg_id = pkg.pkg_id
-
 
19035
		   AND rel.pv_id = pv.pv_id
-
 
19036
		   AND rel.VIEW_ID = ViewId
-
 
19037
		   AND rel.RTAG_ID = RtagId
-
 
19038
		 ORDER BY UPPER(pkg.PKG_NAME);
-
 
19039
 
19009
 
-
 
19010
        -- Get non base view content
-
 
19011
        OPEN RecordSet FOR
19040
	ELSE
19012
        SELECT 0 AS PKG_STATE,
-
 
19013
               NULL AS DEPRECATED_STATE,
-
 
19014
               pv.pv_id,
-
 
19015
               pkg.pkg_name,
-
 
19016
               pv.pkg_version,
-
 
19017
               pv.dlocked,
-
 
19018
               pv.pv_description,
-
 
19019
               pv.BUILD_TYPE,
-
 
19020
               rel.operation
-
 
19021
          FROM PLANNED rel,
-
 
19022
               packages pkg,
-
 
19023
               package_versions pv,
-
 
19024
               VIEW_DEF vd
-
 
19025
         WHERE pv.pkg_id = pkg.pkg_id
-
 
19026
           AND rel.pv_id = pv.pv_id
-
 
19027
           AND rel.RTAG_ID = RtagId
-
 
19028
           AND vd.VIEW_ID = ViewId
-
 
19029
           AND vd.PKG_ID = pv.PKG_ID
-
 
19030
         ORDER BY UPPER(pkg.PKG_NAME);
19041
 
19031
 
19042
		-- Get non base view content
-
 
19043
		OPEN RecordSet FOR
-
 
19044
		SELECT 0 AS PKG_STATE,
-
 
19045
			   NULL AS DEPRECATED_STATE,
-
 
19046
			   pv.pv_id,
-
 
19047
			   pkg.pkg_name,
-
 
19048
			   pv.pkg_version,
-
 
19049
			   pv.dlocked,
-
 
19050
			   pv.pv_description,
-
 
19051
			   pv.BUILD_TYPE,
-
 
19052
			   rel.operation
-
 
19053
		  FROM PLANNED rel,
-
 
19054
			   packages pkg,
-
 
19055
			   package_versions pv,
-
 
19056
			   VIEW_DEF vd
-
 
19057
		 WHERE pv.pkg_id = pkg.pkg_id
-
 
19058
		   AND rel.pv_id = pv.pv_id
-
 
19059
		   AND rel.RTAG_ID = RtagId
-
 
19060
		   AND vd.VIEW_ID = ViewId
-
 
19061
		   AND vd.PKG_ID = pv.PKG_ID
-
 
19062
		 ORDER BY UPPER(pkg.PKG_NAME);
-
 
19063
 
-
 
19064
	END IF;
19032
    END IF;
19065
 
19033
 
19066
 
19034
 
19067
END;
19035
END;
19068
/*-------------------------------------------------------------------------------------------------------*/
19036
/*-------------------------------------------------------------------------------------------------------*/
19069
PROCEDURE CHANGE_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER, NewViewId IN NUMBER ) IS
19037
PROCEDURE CHANGE_PACKAGE_VIEW ( PvId IN NUMBER, RtagId IN NUMBER, NewViewId IN NUMBER ) IS
19070
 
19038
 
19071
BEGIN
19039
BEGIN
19072
 
19040
 
19073
	UPDATE PLANNED pl SET
19041
    UPDATE PLANNED pl SET
19074
	pl.VIEW_ID = NewViewId
19042
    pl.VIEW_ID = NewViewId
19075
	WHERE pl.PV_ID = PvId
19043
    WHERE pl.PV_ID = PvId
19076
	  AND pl.RTAG_ID = RtagId;
19044
      AND pl.RTAG_ID = RtagId;
19077
 
19045
 
19078
END;
19046
END;
19079
/*-------------------------------------------------------------------------------------------------------*/
19047
/*-------------------------------------------------------------------------------------------------------*/
19080
-- DEVI-45275 This new function supports the ability to insert into the planned table, and existing
19048
-- DEVI-45275 This new function supports the ability to insert into the planned table, and existing
19081
-- version of a package as part of a release-to-release merge operation carried out within release manager.
19049
-- version of a package as part of a release-to-release merge operation carried out within release manager.