Rem
Rem $Header: whdev/2.0/owb/shiphome/owb/reposasst/upg/bug_8516174.sql /main/1 2010/05/27 18:25:42 jinhe Exp $
Rem
Rem bug_8516174.sql
Rem
Rem Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. 
Rem
Rem    NAME
Rem      bug_8516174.sql
Rem
Rem    DESCRIPTION
Rem      Create sql in-place upgrade patch for bug 8516174
Rem
Rem    NOTES
Rem      Bug 8516174: built-in ct properties and its tasks properties should not be editable
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    jinhe       05/26/10 - Created
Rem

UPDATE CMPTaskFlowInstalledModule_R
SET seeded          = 1 ,
  customerdeletable = 0 ,
  customerrenamable = 0 ,
  editable          = 0
WHERE elementId    IN
  (SELECT DISTINCT taskFlowModule.elementId
  FROM CMPTaskFlowInstalledModule_R taskFlowModule,
    CMPWBProject_R proj
  WHERE taskFlowModule.owningProject = proj.elementId
  AND proj.NAME                      = 'PUBLIC_PROJECT'
  AND taskFlowModule.NAME            = 'BUILT_IN_CT'
  );


UPDATE CMPTaskFlow_R
SET seeded          = 1 ,
  customerdeletable = 0 ,
  customerrenamable = 0 ,
  editable          = 0
WHERE elementId    IN
  (SELECT taskFlow.elementId
  FROM CMPTaskFlow_R taskFlow,
    CMPTaskFlowInstalledModule_R taskFlowModule,
    CMPWBProject_R proj
  WHERE taskFlow.owningInstalledModule = taskFlowModule.elementId
  AND taskFlowModule.owningProject     = proj.elementId
  AND proj.NAME                        = 'PUBLIC_PROJECT'
  AND taskFlowModule.NAME              = 'BUILT_IN_CT'
  );


UPDATE CMPProcessActivityParameter_R
SET seeded              = 1 ,
  customerdeletable     = 0 ,
  customerrenamable     = 0 ,
  editable              = 0
WHERE firstClassObject IN
  (SELECT DISTINCT taskFlow.elementId
  FROM CMPTaskFlow_R taskFlow,
    CMPTaskFlowInstalledModule_R taskFlowModule,
    CMPWBProject_R proj
  WHERE taskFlow.owningInstalledModule = taskFlowModule.elementId
  AND taskFlowModule.owningProject     = proj.elementId
  AND proj.NAME                        = 'PUBLIC_PROJECT'
  AND taskFlowModule.NAME              = 'BUILT_IN_CT'
  );


UPDATE CMPProcessTransition_R
SET seeded              = 1 ,
  customerdeletable     = 0 ,
  customerrenamable     = 0 ,
  editable              = 0
WHERE firstClassObject IN
  (SELECT DISTINCT taskFlow.elementId
  FROM CMPTaskFlow_R taskFlow,
    CMPTaskFlowInstalledModule_R taskFlowModule,
    CMPWBProject_R proj
  WHERE taskFlow.owningInstalledModule = taskFlowModule.elementId
  AND taskFlowModule.owningProject     = proj.elementId
  AND proj.NAME                        = 'PUBLIC_PROJECT'
  AND taskFlowModule.NAME              = 'BUILT_IN_CT'
  );


UPDATE CMPStringPropertyValue_R
SET seeded              = 1 ,
  customerdeletable     = 0 ,
  customerrenamable     = 0 ,
  editable              = 0
WHERE firstClassObject IN
  (SELECT DISTINCT taskFlow.elementId
  FROM CMPTaskFlow_R taskFlow,
    CMPTaskFlowInstalledModule_R taskFlowModule,
    CMPWBProject_R proj
  WHERE taskFlow.owningInstalledModule = taskFlowModule.elementId
  AND taskFlowModule.owningProject     = proj.elementId
  AND proj.NAME                        = 'PUBLIC_PROJECT'
  AND taskFlowModule.NAME              = 'BUILT_IN_CT'
  );


UPDATE CMPTask_R
SET seeded              = 1 ,
  customerdeletable     = 0 ,
  customerrenamable     = 0 ,
  editable              = 0
WHERE firstClassObject IN
  (SELECT DISTINCT taskFlow.elementId
  FROM CMPTaskFlow_R taskFlow,
    CMPTaskFlowInstalledModule_R taskFlowModule,
    CMPWBProject_R proj
  WHERE taskFlow.owningInstalledModule = taskFlowModule.elementId
  AND taskFlowModule.owningProject     = proj.elementId
  AND proj.NAME                        = 'PUBLIC_PROJECT'
  AND taskFlowModule.NAME              = 'BUILT_IN_CT'
  );