rem --------------------------------------------------------------------------
rem File:        $RCSfile: odwa_elt.tab $
rem Author:      $Author: pcsmith $
rem Date:        $Date: 2002/08/07 11:03:42 $
rem Version:     $Revision: 1.1 $
rem Status:      $State: Exp $
rem Locked_by:   $Locker:  $
rem Description: <Enter global description here>
rem Notes:       <Global notes>
rem RealAuth:    <Full real name of code author>
rem IncepDate:   <nnth Xxxember 1999>
rem Copyright:   (c) Oracle Corporation 1999.  All Rights Reserved.
rem --------------------------------------------------------------------------
rem Log of Changes from RCS
rem --------------------------------------------------------------------------
rem $Log: odwa_elt.tab $
rem Revision 1.1  2002/08/07 11:03:42  pcsmith
rem Initial revision
rem
rem --------------------------------------------------------------------------
rem  
-- Purpose: Create table pie_element_types and insert the rows
--
-- Usage:   Run while connected as ODWA owner
--
-- Remarks: Table name should be changed to odwa_element_types or similar
--          somewhere in future

--
-- Revision History
-- Label      Date         Who                  What
------------------------------------------------------------------------------------------
--            18-jul-2002  ReposDev             added contraint markers for RAU
-- 1.6        27-feb-2001  Lucas Jellema        corrected quoted string not properly terminated; unique key violation
-- 1.5        26-feb-2001  Lucas Jellema        corrected the RM_ID values, added INSERT FILES
-- 1.4        08-feb-2001  SANDRA MULLER        fix for issue 192: wrong icon for business
-- 1.3        01-feb-2001  SANDRA MULLER        Added RLV entry (issue 173)               
-- 1.2        25-jan-2001  SANDRA MULLER        issue 16: changed 'MCO' to 'RMC'          
-- 1.1        25-jan-2001  SANDRA MULLER        issue 142: changed 'MDE' to 'GEM'         
-- 1.0.3      19-jun-2000  Lucas Jellema        Added MCO (reusable) as element type
-- 1.0.2      19-may-2000  Sandra Muller        changed function.gif to
--                                              function_hierarchy_diagrammer.gif
-- 1.0.1      18-may-2000  Sandra Muller        changed PL/SQL Modules
--                                              to PL/SQL Definitions
-- 1.0.0      02-may-2000  Sandra Muller        Creation based on Cherry Pie
-------------------------------------------------------------------------------
create table pie_element_types
(DISPLAY_NAME     VARCHAR2(100)
,NAME             VARCHAR2(100)
,RM_ID            NUMBER(38)
,PLURAL           VARCHAR2(100)
,GIF_FILE         VARCHAR2(100)
,ROOT_PROCEDURE   VARCHAR2(100)
,SHORT_NAME       VARCHAR2(10)
,DETAIL_PROCEDURE VARCHAR2(100)
,display_sequence number(3)
)
/

--RAU ODWA_ELT_PK
alter table pie_element_types
add constraint odwa_elt_pk
primary key (short_name)
/

--RAU ODWA_ELT_UK1
alter table pie_element_types
add constraint odwa_elt_uk1
unique (display_name)
/

--RAU ODWA_ELT_UK2
alter table  pie_element_types
add constraint odwa_elt_uk2
unique (name)
/

--RAU ODWA_ELT_UK3
alter table  pie_element_types
add constraint odwa_elt_uk3
unique (plural)
/

insert into pie_element_types
values
('Business Function','FUNCTION',5024,'Business Functions','function.gif'
,'cdwp_fun.root_business_functions','FUN','cdwp_fun.list_business_functions',70
);

insert into pie_element_types
values
('Diagram','DIAGRAM',4941,'Diagrams','diagram.gif'
,'cdwp_dia.short_list_diagrams','DIA','cdwp_dia.list_diagrams',60
);

insert into pie_element_types
values
('Business Terminology','TERM',4994,'Business Terminology','term.gif'
,'cdwp_ter.short_list_ter','TER','cdwp_ter.list_ter',30
);

insert into pie_element_types
values
('Process Models','PROCESS MODEL',1,'Process Model','process_model_diagrammer.gif'
,'cdwp_prc.short_list_process_models','PRC','cdwp_prc.list_process_models',100
);

insert into pie_element_types
values(
'Domain','DOMAIN',5020,'Domains','domain.gif','cdwp_dom.short_list_domains','DOM','cdwp_dom.list_domains',90
);

insert into pie_element_types
values(
'Entity','ENTITY',5002,'Entities','entity.gif'
,'cdwp_ent.short_list_entities','ENT','cdwp_ent.list_entities',10
);

insert into pie_element_types
values(
'Table Definition','TABLE_DEFINITION',4974,'Table Definitions','table.gif'
,'cdwp_tbl.short_list_table_definitions','TBL','cdwp_tbl.list_table_definitions',20
);

insert into pie_element_types
values(
'Business Rule','Business_Rule',-5024,'Business Rules','system_privilege.gif'
,'cdwp_br.root_business_rules','BR','cdwp_br.list_business_rules', 40
);


insert into pie_element_types
values(
'PL/SQL Definitions','PLSQL_MODULES',4907,'PL/SQL Definitions','plsql.gif'
,'cdwp_plm.short_list_plm_definitions','PLM','cdwp_plm.list_plm_definitions', 110
);

insert into pie_element_types
values(
'Business Rule Design Definition','BUSINESS_RULE_DESIGN_DEFINITION',-4907,'Business Rule Design Definitions','brdd.gif'
,'cdwp_brd.short_list_brdd_definitions','BRDD','cdwp_brd.list_brdd_definitions', 80
);

insert into pie_element_types
values(
'View Definition','VIEW_DEFINITION',4977,'View Definitions','view.gif'
,'cdwp_vw.short_list_vw_definitions','VW','cdwp_vw.list_vw_definitions', 50
);

insert into pie_element_types
values(
'Module','MODULE',4908,'Modules','module.gif'
,'cdwp_mde.short_list_mde_definitions','GEM','cdwp_mde.list_mde_definitions',140
);

insert into pie_element_types
values(
'Reusable Module Component','MODULE_COMPONENT',5053,'Reusable Module Components','reusable_mco.gif'
,'cdwp_mco.short_list_mco_definitions','RMC','cdwp_mco.list_mco_definitions',145
);

-- 1.5
insert into pie_element_types
values(
'File','PRIMARY_ACCESS_FILE',4819,'Files','file.gif'
,'''','FILES','cdwp_fil.download_file',149
);

-- 1.3  new
insert into pie_element_types
values(
'Reusable List of Values','REUSABLE_LOV',5056,'Reusable Lists of Values','lov_reusable.gif'
,'cdwp_mco.short_list_lov_definitions','RLV','cdwp_mco.list_lov_definitions',144
);

rem  
rem  
rem --------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: odwa_elt.tab $
rem --------------------------------------------------------------------------
rem