begin declare procedure add( p_type_name in varchar2, p_section_seq in varchar2, p_query_type in varchar2 := null, p_format_type in varchar2 := null, p_section_name in varchar2 := null, p_layout_name in varchar2 := null, p_query_name in varchar2 := null ) is begin INSERT INTO wmp_report_drivers (type_name, section_seq, query_type, format_type, section_name, layout_name, query_name) VALUES (p_type_name, p_section_seq, p_query_type, p_format_type, p_section_name, p_layout_name, p_query_name); return; end; begin -- Number of Table Rows Inserted = 212 -- Collection - Detailed Report ***************************************************************** add('Collection_Detail', 10, 'Q', 'H', null, null, 'Collection10'); add('Collection_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Collection20'); add('Collection_Detail', 30, 'Q', 'T','10122', 'Table_2_a', 'Collection30'); -- section name = Member Objects -- Location - Detailed Report ***************************************************************** add('Location_Detail', 10, 'Q', 'H', null, null, 'Location10'); add('Location_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Location20'); add('Location_Detail', 30, 'Q', 'T','10487', 'Table_2_a', 'Location30'); -- section name = Connectors -- Connector - Detailed Report ***************************************************************** add('Connector_Detail', 10, 'Q', 'H', null, null, 'Connector10'); add('Connector_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Connector20'); add('Connector_Detail', 30, 'Q', 'T','10526', 'Table_2_a', 'Connector30'); -- section name = Referenced Locations -- RuntimeLocation - Detailed Report ***************************************************************** add('RuntimeLocation_Detail', 10, 'Q', 'H', null, null, 'RuntimeLocation10'); add('RuntimeLocation_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'RuntimeLocation20'); -- AdvancedQueue - Detailed Report ***************************************************************** add('AdvancedQueue_Detail', 10, 'Q', 'H', null, null, 'AdvancedQueue10'); add('AdvancedQueue_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'AdvancedQueue20'); add('AdvancedQueue_Detail', 30, 'Q', 'T','10273', 'Table_2_a', 'AdvancedQueue30'); -- section name = ObjectType add('AdvancedQueue_Detail', 70, 'Q', 'T','10137', 'Table_3_b', 'AdvancedQueue70'); -- section name = Physical Configuration Parameters -- ObjectType - Detailed Report ***************************************************************** add('ObjectType_Detail', 10, 'Q', 'H', null, null, 'ObjectType10'); add('ObjectType_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'ObjectType20'); add('ObjectType_Detail', 30, 'Q', 'T','10582', 'Table_2_a', 'ObjectType30'); -- section name = RecordField -- Cube - Detailed Report ************************************************************************* add('Cube_Detail', 10, 'Q', 'H', null, null, 'Cube10'); add('Cube_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Cube20'); add('Cube_Detail', 30, 'Q', 'T','10121', 'Table_6_1_b', 'Cube30'); -- section name = Measures add('Cube_Detail', 40, 'Q', 'T','10056', 'Table_2_a', 'Cube40'); -- section name = Dimensions add('Cube_Detail', 70, 'Q', 'T','10137', 'Table_3_b', 'Cube70'); -- section name = Physical Configuration Parameters -- Cube_Lineage - Lineage Report ****************************************************************** add('Cube_Lineage', 10, 'Q', 'H', null, null, 'Cube11'); add('Cube_Lineage', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Cube20'); add('Cube_Lineage', 50, 'Q', 'N','10109', 'Cube_Lineage:Measure', 'Cube50'); -- section name = Lineage Dependency -- Cube_Lineage:Measure - Nested Report *********************************************************** add('Cube_Lineage:Measure', 51, 'Q', 'R', null, 'NestedRow_1_b', 'Cube:Lineage51'); add('Cube_Lineage:Measure', 52, 'Q', 'T','10030', 'NestedTable_4_1_a', 'Cube:Lineage52'); -- section name = Dependencies -- Cube_Impact - Impact Analysis Report *********************************************************** add('Cube_Impact', 10, 'Q', 'H', null, null, 'Cube12'); add('Cube_Impact', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Cube20'); add('Cube_Impact', 60, 'Q', 'N','10087', 'Cube_Impact:Measure', 'Cube60'); -- section name = Impact Analysis Dependency -- Cube_Impact:Measure - Nested Report ******************************************************************** add('Cube_Impact:Measure', 61, 'Q', 'R', null, 'NestedRow_1_b', 'Cube:Impact61'); add('Cube_Impact:Measure', 62, 'Q', 'T','10030', 'NestedTable_4_1_a', 'Cube:Impact62'); -- section name = Dependencies -- Cube_Implementation - Report ******************************************************************* add('Cube_Implementation', 10, 'Q', 'H', null, null, 'Cube_Implementation10'); add('Cube_Implementation', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Cube_Implementation20'); add('Cube_Implementation', 30, 'Q', 'T','10174', 'Table_1_a', 'Cube_Implementation30'); -- section name = Tables implementing Cube add('Cube_Implementation', 40, 'Q', 'N','10121', 'Cube_Implementation:Measure', 'Cube_Implementation40'); -- section name = Measures add('Cube_Implementation', 50, 'Q', 'N','10056', 'Cube_Implementation:Dimension', 'Cube_Implementation50'); -- section name = Dimensions -- Cube_Implementation:Measure - Nested Report **************************************************** add('Cube_Implementation:Measure', 41, 'Q', 'T','10120', 'NestedTable_2_a', 'Cube_Implementation:Measure41'); -- section name = Measure add('Cube_Implementation:Measure', 42, 'Q', 'T','10014', 'NestedTable_1_a', 'Cube_Implementation:Measure42'); -- section name = Columns implementing Measure -- Cube_Implementation:Dimension - Nested Report ************************************************** add('Cube_Implementation:Dimension', 51, 'Q', 'T', '10229', 'NestedTable_1_a', 'Cube_Implementation:Dimension51'); -- section name = Dimension add('Cube_Implementation:Dimension', 52, 'Q', 'T','10072', 'NestedTable_1_a', 'Cube_Implementation:Dimension52'); -- section name = Foreign Keys implementing Cube t -- Dimension - Detailed Report ******************************************************************** add('Dimension_Detail', 10, 'Q', 'H', null, null, 'Dimension10'); add('Dimension_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Dimension20'); add('Dimension_Detail', 30, 'Q', 'N','10083', 'Dimension:Hierarchy', 'Dimension30'); -- section name = Hierarchies add('Dimension_Detail', 40, 'Q', 'N','10107', 'Dimension:Level', 'Dimension40'); -- section name = Levels add('Dimension_Detail', 70, 'Q', 'T','10137', 'Table_3_b', 'Dimension70'); -- section name = Physical Configuration Parameters -- Dimension:Hierarchy - Nested Report ************************************************************ add('Dimension:Hierarchy', 31, 'Q', 'R','10245', 'NestedRow_2_1_b', 'Dimension:Hierarchy31'); -- section name = Hierarchy add('Dimension:Hierarchy', 32, 'Q', 'T','10084', 'Table_2_b', 'Dimension:Hierarchy32'); -- section name = Hierarchy Levels -- Dimension:Level - Nested Report **************************************************************** add('Dimension:Level', 41, 'Q', 'R','10103', 'NestedRow_2_1_b', 'Dimension:Level41'); -- section name = Level add('Dimension:Level', 42, 'Q', 'T','10104', 'NestedTable_6_1_b', 'Dimension:Level42'); -- section name = Level Attributes -- Dimension_Lineage - Lineage Report ************************************************************* add('Dimension_Lineage', 10, 'Q', 'H', null, null, 'Dimension11'); add('Dimension_Lineage', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Dimension20'); add('Dimension_Lineage', 50, 'Q', 'N','10109', 'Dimension_Lineage:Level', 'Dimension50'); -- section name = Lineage Dependency -- Dimension_Lineage:Level - Nested Report ******************************************************** add('Dimension_Lineage:Level', 51, 'Q', 'R', null, 'NestedRow_1_b', 'Dimension:Lineage51'); add('Dimension_Lineage:Level', 52, 'Q', 'T','10030', 'NestedTable_4_1_a', 'Dimension:Lineage52'); -- section name = Dependencies -- Dimension_Impact - Impact Analysis Report ****************************************************** add('Dimension_Impact', 10, 'Q', 'H', null, null, 'Dimension12'); add('Dimension_Impact', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Dimension20'); add('Dimension_Impact', 60, 'Q', 'N','10087', 'Dimension_Impact:Level', 'Dimension60'); -- section name = Impact Analysis Dependency -- Dimension_Impact:Level - Nested Report ********************************************************* add('Dimension_Impact:Level', 61, 'Q', 'R', null, 'NestedRow_1_b', 'Dimension:Impact61'); add('Dimension_Impact:Level', 62, 'Q', 'T','10030', 'NestedTable_4_1_a', 'Dimension:Impact62'); -- section name = Dependencies -- Dimension_Implementation - Report ************************************************************** add('Dimension_Implementation', 10, 'Q', 'H', null, null, 'Dimension_Implementation10'); add('Dimension_Implementation', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Dimension_Implementation20'); add('Dimension_Implementation', 30, 'Q', 'N','10107', 'Dimension_Implementation:Level', 'Dimension_Implementation30'); -- section name = Levels -- Dimension_Implementation:Level - Nested Report ************************************************* add('Dimension_Implementation:Level', 31, 'Q', 'R','10103', 'NestedRow_2_b', 'Dimension_Implementation:Level31'); -- section name = Level add('Dimension_Implementation:Level', 32, 'Q', 'T','10175', 'NestedTable_1_a', 'Dimension_Implementation:Level32'); -- section name = Tables implementing Level add('Dimension_Implementation:Level', 33, 'Q', 'N','10104', 'Dimension_Implementation:Level:Attribute', 'Dimension_Implementation:Level33'); -- section name = Level Attributes -- Dimension_Implementation:Level:Attribute - Nested Nested Report ******************************** add('Dimension_Implementation:Level:Attribute', 34, 'Q', 'T','10257', 'NestedTable_2_a', 'Dimension_Implementation:Level:Attribute34'); -- section name = Level Attribute add('Dimension_Implementation:Level:Attribute', 35, 'Q', 'T','10013', 'NestedTable_1_a', 'Dimension_Implementation:Level:Attribute35'); -- section name = Columns implementing Level Attribute -- File - Detailed Report ************************************************************************* add('File_Detail', 10, 'Q', 'H', null, null, 'File10'); add('File_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'File20'); add('File_Detail', 30, 'Q', 'W', null, 'Table_2_a', 'File30'); add('File_Detail', 40, 'Q', 'T','10151', 'Table_2_1_a', 'File40'); -- section name = Records add('File_Detail', 50, 'Q', 'T','10137', 'Table_3_b', 'File50'); -- section name = Physical Configuration Parameters -- File_Lineage - Lineage Report **************************************************************** add('File_Lineage', 10, 'Q', 'H', null, null, 'File11'); add('File_Lineage', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'File20'); add('File_Lineage', 60, 'Q', 'N','10109', 'File_Lineage:Field', 'File60'); -- section name = Lineage Dependency -- File_Lineage:Record - Nested Report *********************************************************** add('File_Lineage:Field', 61, 'Q', 'R', null, 'NestedRow_1_b', 'File:Lineage61'); add('File_Lineage:Field', 62, 'Q', 'T','10030', 'NestedTable_4_1_a', 'File:Lineage62'); -- section name = Dependencies -- File_Impact - Impact Analysis Report ********************************************************* add('File_Impact', 10, 'Q', 'H', null, null, 'File12'); add('File_Impact', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'File20'); add('File_Impact', 70, 'Q', 'N','10087', 'File_Impact:Field', 'File70'); -- section name = Impact Analysis Dependency -- File_Impact:Record - Nested Report ************************************************************ add('File_Impact:Field', 71, 'Q', 'R', null, 'NestedRow_1_b', 'File:Impact71'); add('File_Impact:Field', 72, 'Q', 'T','10030', 'NestedTable_4_1_a', 'File:Impact72'); -- section name = Dependencies -- Function - Detailed Report ********************************************************************* add('Function_Detail', 10, 'Q', 'H', null, null, 'Function10'); add('Function_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'Function20'); add('Function_Detail', 30, 'Q', 'T','10134', 'Table_7_1_b', 'Function30'); -- section name = Parameters add('Function_Detail', 40, 'Q', 'T','10075', 'Table_2_b', 'Function40'); -- section name = Function Implementations add('Function_Detail', 50, 'Q', 'T','10137', 'Table_3_b', 'Function50'); -- section name = Physical Configuration Parameters -- TableFunction - Detailed Report ********************************************************************* add('TableFunction_Detail', 10, 'Q', 'H', null, null, 'TableFunction10'); add('TableFunction_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'TableFunction20'); add('TableFunction_Detail', 30, 'Q', 'T','10134', 'Table_7_1_b', 'TableFunction30'); -- section name = Parameters add('TableFunction_Detail', 40, 'Q', 'T','10075', 'Table_2_b', 'TableFunction40'); -- section name = Function Implementations -- FunctionLibrary - Detailed Report ************************************************************* add('FunctionLibrary_Detail', 10, 'Q', 'H', null, null, 'FunctionLibrary10'); add('FunctionLibrary_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'FunctionLibrary20'); add('FunctionLibrary_Detail', 30, 'Q', 'T','10082', 'Table_3_1_a', 'FunctionLibrary30'); -- section name = Functions add('FunctionLibrary_Detail', 40, 'Q', 'T','10137', 'Table_3_b', 'FunctionLibrary40'); -- section name = Physical Configuration Parameters -- DataWarehouse - Detailed Report ************************************************************ add('DataWarehouse_Detail', 10, 'Q', 'H', null, null, 'DataWarehouse10'); add('DataWarehouse_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'DataWarehouse20'); add('DataWarehouse_Detail', 30, 'Q', 'T','10156', 'NestedTable_4_1_a', 'DataWarehouse30'); -- section name = DataWarehouse - First Class Objects add('DataWarehouse_Detail', 40, 'Q', 'T','10137', 'Table_3_b', 'DataWarehouse40'); -- section name = Physical Configuration Parameters -- DataWarehouse_FunctionLibrary - Summary Report ********************************************* add('FunctionLibrary_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_FunctionLibrary10'); add('FunctionLibrary_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'DataWarehouse_FunctionLibrary20'); add('FunctionLibrary_Summary', 30, 'Q', 'T','10076', 'Table_2_1_a', 'DataWarehouse_FunctionLibrary30'); -- section name = Function Libraries -- DataWarehouse_TransformMap - Summary Report ************************************************ add('TransformMap_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_TransformMap10'); add('TransformMap_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'DataWarehouse_TransformMap20'); add('TransformMap_Summary', 30, 'Q', 'T','10189', 'Table_2_1_a', 'DataWarehouse_TransformMap30'); -- section name = Transforms -- DataWarehouse_Cube - Summary Report ******************************************************************* add('Cube_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_Cube10'); add('Cube_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_Cube20'); add('Cube_Summary', 30, 'Q', 'T','', 'Table_2_1_a', 'DataWarehouse_Cube30'); -- section name = Facts -- DataWarehouse_Dimension - Summary Report ************************************************************** add('Dimension_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_Dimension10'); add('Dimension_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_Dimension20'); add('Dimension_Summary', 30, 'Q', 'T','10056', 'Table_2_1_a', 'DataWarehouse_Dimension30'); -- section name = Dimensions -- DataWarehouse_MaterializedView - Summary Report ******************************************************* add('MaterializedView_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_MaterializedView10'); add('MaterializedView_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_MaterializedView20'); add('MaterializedView_Summary', 30, 'Q', 'T','10118', 'Table_2_1_a', 'DataWarehouse_MaterializedView30'); -- section name = Materialized Views -- DataWarehouse_Sequence - Summary Report *************************************************************** add('Sequence_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_Sequence10'); add('Sequence_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_Sequence20'); add('Sequence_Summary', 30, 'Q', 'T','10164', 'Table_2_1_a', 'DataWarehouse_Sequence30'); -- section name = Sequences -- PackagedModule_Sequence - Summary Report *************************************************************** add('Sequence_Summary2', 10, 'Q', 'H', null, null, 'PackagedModule_Sequence10'); add('Sequence_Summary2', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'PackagedModule_Sequence20'); add('Sequence_Summary2', 30, 'Q', 'T','10164', 'Table_2_1_a', 'PackagedModule_Sequence30'); -- section name = Sequences -- DataWarehouse_Table - Summary Report ****************************************************************** add('Table_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_Table10'); add('Table_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_Table20'); add('Table_Summary', 30, 'Q', 'T','10173', 'Table_2_1_a', 'DataWarehouse_Table30'); -- section name = Tables -- PackagedModule_Table - Summary Report ****************************************************************** add('Table_Summary2', 10, 'Q', 'H', null, null, 'PackagedModule_Table10'); add('Table_Summary2', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'PackagedModule_Table20'); add('Table_Summary2', 30, 'Q', 'T','10173', 'Table_2_1_a', 'PackagedModule_Table30'); -- section name = Tables -- DataWarehouse_View - Summary Report ******************************************************************* add('View_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_View10'); add('View_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_View20'); add('View_Summary', 30, 'Q', 'T','10202', 'Table_2_1_a', 'DataWarehouse_View30'); -- section name = Views -- PackagedModule_View - Summary Report ******************************************************************* add('View_Summary2', 10, 'Q', 'H', null, null, 'PackagedModule_View10'); add('View_Summary2', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'PackagedModule_View20'); add('View_Summary2', 30, 'Q', 'T','10202', 'Table_2_1_a', 'PackagedModule_View30'); -- section name = Views -- DataWarehouse_ExternalTable - Summary Report ******************************************************************* add('ExternalTable_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_ExternalTable10'); add('ExternalTable_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_ExternalTable20'); add('ExternalTable_Summary', 30, 'Q', 'T','10433', 'Table_2_1_a', 'DataWarehouse_ExternalTable30'); -- section name = External Table -- PackagedModule_ExternalTable - Summary Report ******************************************************************* add('ExternalTable_Summary2', 10, 'Q', 'H', null, null, 'PackagedModule_ExternalTable10'); add('ExternalTable_Summary2', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'PackagedModule_ExternalTable20'); add('ExternalTable_Summary2', 30, 'Q', 'T','10433', 'Table_2_1_a', 'PackagedModule_ExternalTable30'); -- section name = External Table -- DataWarehouse_AdvancedQueue - Summary Report ******************************************************************* add('AdvancedQueue_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_AdvancedQueue10'); add('AdvancedQueue_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_AdvancedQueue20'); add('AdvancedQueue_Summary', 30, 'Q', 'T','10432', 'Table_2_1_a', 'DataWarehouse_AdvancedQueue30'); -- section name = Advanced Queue -- DataWarehouse_Function - Summary Report ******************************************************************* add('Function_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_Function10'); add('Function_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_Function20'); add('Function_Summary', 30, 'Q', 'T','10239', 'Table_2_1_a', 'DataWarehouse_Function30'); -- section name = Function -- DataWarehouse_Function - Summary Report ******************************************************************* add('Procedure_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_Procedure10'); add('Procedure_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_Procedure20'); add('Procedure_Summary', 30, 'Q', 'T','10583', 'Table_2_1_a', 'DataWarehouse_Procedure30'); -- section name = Procedure -- DataWarehouse_TableFunction - Summary Report ******************************************************************* add('TableFunction_Summary', 10, 'Q', 'H', null, null, 'DataWarehouse_TableFunction10'); add('TableFunction_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'DataWarehouse_TableFunction20'); add('TableFunction_Summary', 30, 'Q', 'T','10477', 'Table_2_1_a', 'DataWarehouse_TableFunction30'); -- section name = Table Function -- FileModule - Detailed Report ************************************************************ add('FileModule_Detail', 10, 'Q', 'H', null, null, 'FileModule10'); add('FileModule_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'FileModule20'); add('FileModule_Detail', 30, 'Q', 'T','10508', 'NestedTable_4_1_a', 'FileModule30'); -- section name = FileModule - First Class Objects add('FileModule_Detail', 40, 'Q', 'T','10137', 'Table_3_b', 'FileModule40'); -- section name = Physical Configuration Parameters -- FileModule_File - Summary Report ******************************************************** add('File_Summary', 10, 'Q', 'H', null, null, 'FileModule_File10'); add('File_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'FileModule_File20'); add('File_Summary', 30, 'Q', 'T','10067', 'Table_2_1_a', 'FileModule_File30'); -- section name = Files -- PreDefinedModule - Detailed Report ************************************************************ add('PreDefinedModule_Detail', 10, 'Q', 'H', null, null, 'PreDefinedModule10'); add('PreDefinedModule_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'PreDefinedModule20'); add('PreDefinedModule_Detail', 30, 'Q', 'T','10509', 'NestedTable_4_1_a', 'PreDefinedModule30'); -- section name = PreDefinedModule - First Class Objects add('PreDefinedModule_Detail', 40, 'Q', 'T','10137', 'Table_3_b', 'PreDefinedModule40'); -- section name = Physical Configuration Parameters -- GatewayModule - Detailed Report ************************************************************ add('GatewayModule_Detail', 10, 'Q', 'H', null, null, 'GatewayModule10'); add('GatewayModule_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'GatewayModule20'); add('GatewayModule_Detail', 30, 'Q', 'T','10599', 'NestedTable_4_1_a', 'GatewayModule30'); -- section name = GatewayModule - First Class Objects add('GatewayModule_Detail', 40, 'Q', 'T','10137', 'Table_3_b', 'GatewayModule40'); -- section name = Physical Configuration Parameters -- MIVModule - Detailed Report ************************************************************ add('MIVModule_Detail', 10, 'Q', 'H', null, null, 'MIVModule10'); add('MIVModule_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'MIVModule20'); add('MIVModule_Detail', 30, 'Q', 'T','10510', 'NestedTable_4_1_a', 'MIVModule30'); -- section name = MIVModule - First Class Objects add('MIVModule_Detail', 40, 'Q', 'T','10137', 'Table_3_b', 'MIVModule40'); -- section name = Physical Configuration Parameters -- XMLModule - Detailed Report ************************************************************ add('XMLModule_Detail', 10, 'Q', 'H', null, null, 'XMLModule10'); add('XMLModule_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'XMLModule20'); add('XMLModule_Detail', 30, 'Q', 'T','10511', 'NestedTable_4_1_a', 'XMLModule30'); -- section name = XMLModule - First Class Objects add('XMLModule_Detail', 40, 'Q', 'T','10137', 'Table_3_b', 'XMLModule40'); -- section name = Physical Configuration Parameters -- PackagedModule - Detailed Report ************************************************************ add('PackagedModule_Detail', 10, 'Q', 'H', null, null, 'PackagedModule10'); add('PackagedModule_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'PackagedModule20'); add('PackagedModule_Detail', 30, 'Q', 'T','10512', 'NestedTable_4_1_a', 'PackagedModule30'); -- section name = PackagedModule - First Class Objects add('PackagedModule_Detail', 40, 'Q', 'T','10137', 'Table_3_b', 'PackagedModule40'); -- section name = Physical Configuration Parameters -- ProcessModule - Detailed Report ************************************************************ add('ProcessModule_Detail', 10, 'Q', 'H', null, null, 'ProcessModule10'); add('ProcessModule_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'ProcessModule20'); add('ProcessModule_Detail', 30, 'Q', 'T','10513', 'NestedTable_4_1_a', 'ProcessModule30'); -- section name = ProcessModule - First Class Objects -- ProcessModule_Process - Summary Report ******************************************************** add('ProcessPackage_Summary', 10, 'Q', 'H', null, null, 'ProcessModule_ProcessPackage10'); add('ProcessPackage_Summary', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'ProcessModule_ProcessPackage20'); add('ProcessPackage_Summary', 30, 'Q', 'T','10434', 'Table_2_1_a', 'ProcessModule_ProcessPackage30'); -- section name = Processes -- Repository - Detailed Report ***************************************************************** add('Repository', 10, 'Q', 'H', null, null, 'Installation10'); add('Repository', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Installation20'); add('Repository', 30, 'Q', 'T','10141', 'Table_2_1_a', 'Installation30'); -- section name = Projects add('Repository', 40, 'Q', 'T','10635', 'Table_2_1_a', 'Installation40'); -- section name = Predefined and public transformations -- MaterializedView - Detailed Report ************************************************************* add('MaterializedView_Detail', 10, 'Q', 'H', null, null, 'MaterializedView10'); add('MaterializedView_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'MaterializedView20'); add('MaterializedView_Detail', 30, 'Q', 'T','10012', 'Table_6_1_b', 'MaterializedView30'); -- section name = Columns add('MaterializedView_Detail', 40, 'Q', 'N','10101', 'MaterializedView:Key', 'MaterializedView40'); -- section name = Keys add('MaterializedView_Detail', 50, 'Q', 'N','10071', 'MaterializedView:ForeignKey', 'MaterializedView50'); -- section name = Foreign Keys add('MaterializedView_Detail', 55, 'Q', 'T','10586', 'Table_2_b', 'MaterializedView55'); -- section name = Check Constraint add('MaterializedView_Detail', 80, 'Q', 'T','10137', 'Table_3_b', 'MaterializedView80'); -- section name = Physical Configuration Parameters -- MaterializedView:Key - Nested Report *********************************************************** add('MaterializedView:Key', 41, 'Q', 'T','10098', 'NestedTable_3_1_a', 'MaterializedView:Key41'); -- section name = Key add('MaterializedView:Key', 42, 'Q', 'T','10099', 'NestedTable_1_a', 'MaterializedView:Key42'); -- section name = Key Columns -- MaterializedView:ForeignKey - Nested Report **************************************************** add('MaterializedView:ForeignKey', 51, 'Q', 'T','10069', 'NestedTable_4_1_a', 'MaterializedView:ForeignKey51'); -- section name = Foreign Key add('MaterializedView:ForeignKey', 52, 'Q', 'T','10099', 'NestedTable_2_a', 'MaterializedView:ForeignKey52'); -- section name = Key Columns -- MaterializedView_Lineage - Lineage Report ****************************************************** add('MaterializedView_Lineage', 10, 'Q', 'H', null, null, 'MaterializedView11'); add('MaterializedView_Lineage', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'MaterializedView20'); add('MaterializedView_Lineage', 60, 'Q', 'N','10109', 'MaterializedView_Lineage:Column', 'MaterializedView60'); -- section name = Lineage Dependency -- MaterializedView_Lineage:Column - Nested Report ************************************************ add('MaterializedView_Lineage:Column', 61, 'Q', 'R', null, 'NestedRow_1_b', 'MaterializedView:Lineage61'); add('MaterializedView_Lineage:Column', 62, 'Q', 'T','10030', 'NestedTable_4_1_a', 'MaterializedView:Lineage62'); -- section name = Dependencies -- MaterializedView_Impact - Impact Analysis Report *********************************************** add('MaterializedView_Impact', 10, 'Q', 'H', null, null, 'MaterializedView12'); add('MaterializedView_Impact', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'MaterializedView20'); add('MaterializedView_Impact', 70, 'Q', 'N','10087', 'MaterializedView_Impact:Column', 'MaterializedView70'); -- section name = Impact Analysis Dependency -- MaterializedView_Impact:Column - Nested Report ************************************************* add('MaterializedView_Impact:Column', 71, 'Q', 'R', null, 'NestedRow_1_b', 'MaterializedView:Impact71'); add('MaterializedView_Impact:Column', 72, 'Q', 'T','10030', 'NestedTable_4_1_a', 'MaterializedView:Impact72'); -- section name = Dependencies -- Project - Detailed Report ********************************************************************** add('Project_Detail', 10, 'Q', 'H', null, null, 'Project10'); add('Project_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_b', 'Project20'); add('Project_Detail', 30, 'Q', 'T','10090', 'Table_6_1_a', 'Project30'); -- section name = Modules add('Project_Detail', 40, 'Q', 'T','10428', 'Table_6_1_a', 'Project40'); -- section name = Location add('Project_Detail', 50, 'Q', 'T','10427', 'Table_6_1_a', 'Project50'); -- section name = Collection add('Project_Detail', 60, 'Q', 'T','10578', 'Table_6_1_a', 'Project60'); -- section name = Runtime Location -- Record - Detailed Report *********************************************************************** add('Record_Detail', 10, 'Q', 'H', null, null, 'Record10'); add('Record_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_1_2_2_2_b', 'Record20'); add('Record_Detail', 30, 'Q', 'T','10064', 'Table_7_4_1_b', 'Record30'); -- section name = Fields -- Sequence - Detailed Report ********************************************************************* add('Sequence_Detail', 10, 'Q', 'H', null, null, 'Sequence10'); add('Sequence_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Sequence20'); add('Sequence_Detail', 30, 'Q', 'T','10012', 'Table_6_1_b', 'Sequence30'); -- section name = Columns add('Sequence_Detail', 40, 'Q', 'T','10137', 'Table_3_b', 'Sequence40'); -- section name = Physical Configuration Parameters -- Sequence_Impact - Impact Analysis Report ******************************************************* add('Sequence_Impact', 10, 'Q', 'H', null, null, 'Sequence12'); add('Sequence_Impact', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Sequence20'); add('Sequence_Impact', 70, 'Q', 'N','10087', 'Sequence_Impact:Column', 'Sequence70'); -- section name = Impact Analysis Dependency -- Sequence_Impact:Column - Nested Report ********************************************************* add('Sequence_Impact:Column', 71, 'Q', 'R', null, 'NestedRow_1_b', 'Sequence:Impact71'); add('Sequence_Impact:Column', 72, 'Q', 'T','10030', 'NestedTable_4_1_a', 'Sequence:Impact72'); -- section name = Dependencies -- Table - Detailed Report ************************************************************************ add('Table_Detail', 10, 'Q', 'H', null, null, 'Table10'); add('Table_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Table20'); add('Table_Detail', 30, 'Q', 'T','10012', 'Table_6_1_b', 'Table30'); -- section name = Columns add('Table_Detail', 40, 'Q', 'N','10101', 'Table:Key', 'Table40'); -- section name = Keys add('Table_Detail', 50, 'Q', 'N','10071', 'Table:ForeignKey', 'Table50'); -- section name = Foreign Keys add('Table_Detail', 55, 'Q', 'T','10586', 'Table_2_b', 'Table55'); -- section name = Check Constraint add('Table_Detail', 80, 'Q', 'T','10137', 'Table_3_b', 'Table80'); -- section name = Physical Configuration Parameters -- Table:Key - Nested Report ********************************************************************** add('Table:Key', 41, 'Q', 'T','10098', 'NestedTable_3_1_a', 'Table:Key41'); -- section name = Key add('Table:Key', 42, 'Q', 'T','10099', 'NestedTable_1_a', 'Table:Key42'); -- section name = Key Columns -- Table:ForeignKey - Nested Report *************************************************************** add('Table:ForeignKey', 51, 'Q', 'T','10069', 'NestedTable_4_1_a', 'Table:ForeignKey51'); -- section name = Foreign Key add('Table:ForeignKey', 52, 'Q', 'T','10099', 'NestedTable_2_a', 'Table:ForeignKey52'); -- section name = Key Columns -- Table_Lineage - Lineage Report ***************************************************************** add('Table_Lineage', 10, 'Q', 'H', null, null, 'Table11'); add('Table_Lineage', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Table20'); add('Table_Lineage', 60, 'Q', 'N','10109', 'Table_Lineage:Column', 'Table60'); -- section name = Lineage Dependency -- Table_Lineage:Column - Nested Report *********************************************************** add('Table_Lineage:Column', 61, 'Q', 'R', null, 'NestedRow_1_b', 'Table:Lineage61'); add('Table_Lineage:Column', 62, 'Q', 'T','10030', 'NestedTable_4_1_a', 'Table:Lineage62'); -- section name = Dependencies -- Table_Impact - Impact Analysis Report ********************************************************** add('Table_Impact', 10, 'Q', 'H', null, null, 'Table12'); add('Table_Impact', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Table20'); add('Table_Impact', 70, 'Q', 'N','10087', 'Table_Impact:Column', 'Table70'); -- section name = Impact Analysis Dependency -- Table_Impact:Column - Nested Report ************************************************************ add('Table_Impact:Column', 71, 'Q', 'R', null, 'NestedRow_1_b', 'Table:Impact71'); add('Table_Impact:Column', 72, 'Q', 'T','10030', 'NestedTable_4_1_a', 'Table:Impact72'); -- section name = Dependencies -- ExternalTable - Detailed Report ************************************************************************ add('ExternalTable_Detail', 10, 'Q', 'H', null, null, 'ExternalTable10'); add('ExternalTable_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'ExternalTable20'); add('ExternalTable_Detail', 30, 'Q', 'T','10012', 'Table_6_1_b', 'ExternalTable30'); -- section name = Columns add('ExternalTable_Detail', 40, 'Q', 'N','10101', 'Table:Key', 'ExternalTable40'); -- section name = Keys add('ExternalTable_Detail', 50, 'Q', 'N','10071', 'Table:ForeignKey', 'ExternalTable50'); -- section name = Foreign Keys add('ExternalTable_Detail', 80, 'Q', 'T','10144', 'Table_3_b', 'ExternalTable80'); -- section name = Record add('ExternalTable_Detail', 90, 'Q', 'T','10137', 'Table_3_b', 'ExternalTable90'); -- section name = Physical Configuration Parameters -- ExternalTable:Key - Nested Report ********************************************************************** add('ExternalTable:Key', 41, 'Q', 'T','10098', 'NestedTable_3_1_a', 'ExternalTable:Key41'); -- section name = Key add('ExternalTable:Key', 42, 'Q', 'T','10099', 'NestedTable_1_a', 'ExternalTable:Key42'); -- section name = Key Columns -- ExternalTable:ForeignKey - Nested Report *************************************************************** add('ExternalTable:ForeignKey', 51, 'Q', 'T','10069', 'NestedTable_4_1_a', 'ExternalTable:ForeignKey51'); -- section name = Foreign Key add('ExternalTable:ForeignKey', 52, 'Q', 'T','10099', 'NestedTable_2_a', 'ExternalTable:ForeignKey52'); -- section name = Key Columns -- ExternalTable_Lineage - Lineage Report ***************************************************************** add('ExternalTable_Lineage', 10, 'Q', 'H', null, null, 'ExternalTable11'); add('ExternalTable_Lineage', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'ExternalTable20'); add('ExternalTable_Lineage', 60, 'Q', 'N','10109', 'Table_Lineage:Column', 'ExternalTable60'); -- section name = Lineage Dependency -- ExternalTable_Lineage:Column - Nested Report *********************************************************** add('ExternalTable_Lineage:Column', 61, 'Q', 'R', null, 'NestedRow_1_b', 'ExternalTable:Lineage61'); add('ExternalTable_Lineage:Column', 62, 'Q', 'T','10030', 'NestedTable_4_1_a', 'ExternalTable:Lineage62'); -- section name = Dependencies -- ExternalTable_Impact - Impact Analysis Report ********************************************************** add('ExternalTable_Impact', 10, 'Q', 'H', null, null, 'ExternalTable12'); add('ExternalTable_Impact', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'ExternalTable20'); add('ExternalTable_Impact', 70, 'Q', 'N', '10087', 'Table_Impact:Column', 'ExternalTable70'); -- section name = Impact Analysis Dependency -- ExternalTable_Impact:Column - Nested Report ************************************************************ add('ExternalTable_Impact:Column', 71, 'Q', 'R', null, 'NestedRow_1_b', 'ExternalTable:Impact71'); add('ExternalTable_Impact:Column', 72, 'Q', 'T','10030', 'NestedTable_4_1_a', 'ExternalTable:Impact72'); -- section name = Dependencies -- TransformMap - Detailed Report ***************************************************************** add('TransformMap_Detail', 10, 'Q', 'H', null, null, 'TransformMap10'); add('TransformMap_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'TransformMap20'); add('TransformMap_Detail', 30, 'Q', 'T','10128', 'Table_3_a', 'TransformMap30'); -- section name = Object Use add('TransformMap_Detail', 40, 'Q', 'N','10112', 'TransformMap:TransformMapComponent', 'TransformMap40'); -- section name = Map Components add('TransformMap_Detail', 50, 'Q', 'T','10137', 'Table_3_b', 'TransformMap50'); -- section name = Physical Configuration Parameters -- TransformMap:TransformMapComponent - Nested Report ********************************************* add('TransformMap:TransformMapComponent', 41, 'Q', 'T','10111', 'NestedTable_3_1_a', 'TransformMap:TransformMapComponent41'); -- section name = Map Component add('TransformMap:TransformMapComponent', 42, 'Q', 'T','10096', 'NestedTable_3_1_a', 'TransformMap:TransformMapComponent42'); -- section name = Item Maps -- View - Detailed Report ************************************************************************* add('View_Detail', 10, 'Q', 'H', null, null, 'View10'); add('View_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'View20'); add('View_Detail', 30, 'Q', 'T','10012', 'Table_6_1_b', 'View30'); -- section name = Columns add('View_Detail', 40, 'Q', 'N','10101', 'View:Key', 'View40'); -- section name = Keys add('View_Detail', 50, 'Q', 'N','10071', 'View:ForeignKey', 'View50'); -- section name = Foreign Keys add('View_Detail', 55, 'Q', 'T','10586', 'Table_2_b', 'View55'); -- section name = Check Constraint add('View_Detail', 80, 'Q', 'T','10137', 'Table_3_b', 'View80'); -- section name = Physical Configuration Parameters -- View:Key - Nested Report *********************************************************************** add('View:Key', 41, 'Q', 'T','10098', 'NestedTable_3_1_a', 'View:Key41'); -- section name = Key add('View:Key', 42, 'Q', 'T','10099', 'NestedTable_1_a', 'View:Key42'); -- section name = Key Columns -- View:ForeignKey - Nested Report **************************************************************** add('View:ForeignKey', 51, 'Q', 'T','10069', 'NestedTable_4_1_a', 'View:ForeignKey51'); -- section name = Foreign Key add('View:ForeignKey', 52, 'Q', 'T','10099', 'NestedTable_2_a', 'View:ForeignKey52'); -- section name = Key Columns -- View_Lineage - Lineage Report ****************************************************************** add('View_Lineage', 10, 'Q', 'H', null, null, 'View11'); add('View_Lineage', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'View20'); add('View_Lineage', 60, 'Q', 'N','10109', 'View_Lineage:Column', 'View60'); -- section name = Lineage Dependency -- View_Lineage:Column - Nested Report ************************************************************ add('View_Lineage:Column', 61, 'Q', 'R', null, 'NestedRow_1_b', 'View:Lineage61'); add('View_Lineage:Column', 62, 'Q', 'T','10030', 'NestedTable_4_1_a', 'View:Lineage62'); -- section name = Dependencies -- View_Impact - Impact Analysis Report *********************************************************** add('View_Impact', 10, 'Q', 'H', null, null, 'View12'); add('View_Impact', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'View20'); add('View_Impact', 70, 'Q', 'N','10087', 'View_Impact:Column', 'View70'); -- section name = Impact Analysis Dependency -- View_Impact:Column - Nested Report ************************************************************* add('View_Impact:Column', 71, 'Q', 'R', null, 'NestedRow_1_b', 'View:Impact71'); add('View_Impact:Column', 72, 'Q', 'T','10030', 'NestedTable_4_1_a', 'View:Impact72'); -- section name = Dependencies -- ProcessPackage - Detailed Report ********************************************************************* add('ProcessPackage_Detail', 10, 'Q', 'H', null, null, 'ProcessPackage10'); add('ProcessPackage_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'ProcessPackage20'); add('ProcessPackage_Detail', 30, 'Q', 'T','10450', 'Table_6_1_b', 'ProcessPackage30'); -- section name = Process -- Process - Detailed Report ********************************************************************* add('Process_Detail', 10, 'Q', 'H', null, null, 'Process10'); add('Process_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'Process20'); add('Process_Detail', 30, 'Q', 'T','10517', 'Table_6_1_b', 'Process30'); -- section name = Activity add('Process_Detail', 40, 'Q', 'T','10455', 'Table_3_b', 'Process40'); -- section name = Transition add('Process_Detail', 50, 'Q', 'T','10453', 'Table_6_1_b', 'Process50'); -- section name = Variables add('Process_Detail', 60, 'Q', 'T','10137', 'Table_3_b', 'Process60'); -- section name = Physical Configuration Parameters -- ProcessActivity - Detailed Report ********************************************************************* add('ProcessActivity_Detail', 10, 'Q', 'H', null, null, 'ProcessActivity10'); add('ProcessActivity_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'ProcessActivity20'); add('ProcessActivity_Detail', 30, 'Q', 'T','10134', 'Table_6_1_b', 'ProcessActivity30'); -- section name = Parameters -- ProcessTransition - Detailed Report ********************************************************************* add('ProcessTransition_Detail', 10, 'Q', 'H', null, null, 'ProcessTransition10'); add('ProcessTransition_Detail', 20, 'Q', 'R', null, 'Row_2_2_1_2_2_2_2_b', 'ProcessTransition20'); add('ProcessTransition_Detail', 30, 'Q', 'T','10464', 'Table_6_1_b', 'ProcessTransition30'); -- section name = Source Activity add('ProcessTransition_Detail', 40, 'Q', 'T','10465', 'Table_6_1_b', 'ProcessTransition40'); -- section name = Target Activity COMMIT; end; end;