eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_METADATA_PKG dependencies on ZPB_MD_RECORDS

Line 8: -- zpb_md_records.dimensions_entry into zpb_dimensions and

4: G_PKG_NAME CONSTANT VARCHAR2(16) := 'ZPB_METADATA_PKG';
5:
6: -------------------------------------------------------------------------------
7: -- insertDimensionRecord - Private function that inserts a
8: -- zpb_md_records.dimensions_entry into zpb_dimensions and
9: -- returns the primary key of the newly created entry
10: --
11: -- if p_primary_key_provided is true, then the primary key for the
12: -- dimension to be inserted is provided and we do not select it from sequence

Line 14: function insertDimensionRecord(p_dimension_rec in zpb_md_records.DIMENSIONS_ENTRY,

10: --
11: -- if p_primary_key_provided is true, then the primary key for the
12: -- dimension to be inserted is provided and we do not select it from sequence
13: -------------------------------------------------------------------------------
14: function insertDimensionRecord(p_dimension_rec in zpb_md_records.DIMENSIONS_ENTRY,
15: p_primary_key_provided in boolean default false)
16: return number is
17:
18: l_dimension_rec zpb_md_records.dimensions_entry;

Line 18: l_dimension_rec zpb_md_records.dimensions_entry;

14: function insertDimensionRecord(p_dimension_rec in zpb_md_records.DIMENSIONS_ENTRY,
15: p_primary_key_provided in boolean default false)
16: return number is
17:
18: l_dimension_rec zpb_md_records.dimensions_entry;
19: bus_area_id_num number;
20: insert_flag boolean;
21: begin
22:

Line 126: -- zpb_md_records.tables_entry into zpb_tables and

122: end insertDimensionRecord;
123:
124: -------------------------------------------------------------------------------
125: -- insertTableRecord - Private function that inserts a
126: -- zpb_md_records.tables_entry into zpb_tables and
127: -- returns the primary key of the newly created entry
128: --
129: -- if p_primary_key_provided is true, then the primary key for the
130: -- table to be inserted is provided and we do not select it from sequence

Line 132: function insertTableRecord(p_table_rec in zpb_md_records.TABLES_ENTRY,

128: --
129: -- if p_primary_key_provided is true, then the primary key for the
130: -- table to be inserted is provided and we do not select it from sequence
131: -------------------------------------------------------------------------------
132: function insertTableRecord(p_table_rec in zpb_md_records.TABLES_ENTRY,
133: p_primary_key_provided in boolean default false)
134: return number is
135: l_table_rec zpb_md_records.tables_entry;
136: bus_area_id_num number;

Line 135: l_table_rec zpb_md_records.tables_entry;

131: -------------------------------------------------------------------------------
132: function insertTableRecord(p_table_rec in zpb_md_records.TABLES_ENTRY,
133: p_primary_key_provided in boolean default false)
134: return number is
135: l_table_rec zpb_md_records.tables_entry;
136: bus_area_id_num number;
137: insert_flag boolean;
138:
139: begin

Line 209: -- zpb_md_records.columns_entry into zpb_columns and

205:
206:
207: -------------------------------------------------------------------------------
208: -- insertColumnRecord - Private function that inserts a
209: -- zpb_md_records.columns_entry into zpb_columns and
210: -- returns the primary key of the newly created entry
211: -------------------------------------------------------------------------------
212: function insertColumnRecord(p_col_rec in zpb_md_records.columns_entry)
213: return number is

Line 212: function insertColumnRecord(p_col_rec in zpb_md_records.columns_entry)

208: -- insertColumnRecord - Private function that inserts a
209: -- zpb_md_records.columns_entry into zpb_columns and
210: -- returns the primary key of the newly created entry
211: -------------------------------------------------------------------------------
212: function insertColumnRecord(p_col_rec in zpb_md_records.columns_entry)
213: return number is
214: l_col_rec zpb_md_records.columns_entry;
215: bus_area_id_num number;
216:

Line 214: l_col_rec zpb_md_records.columns_entry;

210: -- returns the primary key of the newly created entry
211: -------------------------------------------------------------------------------
212: function insertColumnRecord(p_col_rec in zpb_md_records.columns_entry)
213: return number is
214: l_col_rec zpb_md_records.columns_entry;
215: bus_area_id_num number;
216:
217: begin
218:

Line 279: -- zpb_md_records.levels_entry into zpb_levels and

275: end insertColumnRecord;
276:
277: -------------------------------------------------------------------------------
278: -- insertLevelRecord - Private function that inserts a
279: -- zpb_md_records.levels_entry into zpb_levels and
280: -- returns the primary key of the newly created entry
281: -------------------------------------------------------------------------------
282: function insertLevelRecord(p_level_rec zpb_md_records.levels_entry)
283: return number is

Line 282: function insertLevelRecord(p_level_rec zpb_md_records.levels_entry)

278: -- insertLevelRecord - Private function that inserts a
279: -- zpb_md_records.levels_entry into zpb_levels and
280: -- returns the primary key of the newly created entry
281: -------------------------------------------------------------------------------
282: function insertLevelRecord(p_level_rec zpb_md_records.levels_entry)
283: return number is
284:
285: l_level_rec zpb_md_records.levels_entry;
286:

Line 285: l_level_rec zpb_md_records.levels_entry;

281: -------------------------------------------------------------------------------
282: function insertLevelRecord(p_level_rec zpb_md_records.levels_entry)
283: return number is
284:
285: l_level_rec zpb_md_records.levels_entry;
286:
287: begin
288:
289: l_level_rec := p_level_rec;

Line 352: -- zpb_md_records.hier_level_entry into zpb_hier_levels and

348: end insertLevelRecord;
349:
350: -------------------------------------------------------------------------------
351: -- insertHierLevelRecord - Private function that inserts a
352: -- zpb_md_records.hier_level_entry into zpb_hier_levels and
353: -- returns the primary key of the newly created entry
354: -------------------------------------------------------------------------------
355: function insertHierLevelRecord(p_hier_level_rec zpb_md_records.hier_level_entry)
356: return number is

Line 355: function insertHierLevelRecord(p_hier_level_rec zpb_md_records.hier_level_entry)

351: -- insertHierLevelRecord - Private function that inserts a
352: -- zpb_md_records.hier_level_entry into zpb_hier_levels and
353: -- returns the primary key of the newly created entry
354: -------------------------------------------------------------------------------
355: function insertHierLevelRecord(p_hier_level_rec zpb_md_records.hier_level_entry)
356: return number is
357:
358: l_hier_level_rec zpb_md_records.hier_level_entry;
359:

Line 358: l_hier_level_rec zpb_md_records.hier_level_entry;

354: -------------------------------------------------------------------------------
355: function insertHierLevelRecord(p_hier_level_rec zpb_md_records.hier_level_entry)
356: return number is
357:
358: l_hier_level_rec zpb_md_records.hier_level_entry;
359:
360: begin
361:
362: l_hier_level_rec := p_hier_level_rec;

Line 425: -- zpb_md_records.attributes_entry into zpb_attributes and

421: end insertHierLevelRecord;
422:
423: -------------------------------------------------------------------------------
424: -- inserAttributeRecord - Private function that inserts a
425: -- zpb_md_records.attributes_entry into zpb_attributes and
426: -- returns the primary key of the newly created entry
427: -------------------------------------------------------------------------------
428: function insertAttributeRecord(p_attr_rec zpb_md_records.attributes_entry)
429: return number is

Line 428: function insertAttributeRecord(p_attr_rec zpb_md_records.attributes_entry)

424: -- inserAttributeRecord - Private function that inserts a
425: -- zpb_md_records.attributes_entry into zpb_attributes and
426: -- returns the primary key of the newly created entry
427: -------------------------------------------------------------------------------
428: function insertAttributeRecord(p_attr_rec zpb_md_records.attributes_entry)
429: return number is
430:
431: l_attr_rec zpb_md_records.attributes_entry;
432:

Line 431: l_attr_rec zpb_md_records.attributes_entry;

427: -------------------------------------------------------------------------------
428: function insertAttributeRecord(p_attr_rec zpb_md_records.attributes_entry)
429: return number is
430:
431: l_attr_rec zpb_md_records.attributes_entry;
432:
433: begin
434:
435: l_attr_rec := p_attr_rec;

Line 510: -- zpb_md_records.attr_table_col_entry into zpb_attr_table_col and

506:
507:
508: -------------------------------------------------------------------------------
509: -- insertAttrTableColRecord - Private function that inserts a
510: -- zpb_md_records.attr_table_col_entry into zpb_attr_table_col and
511: -- returns the primary key of the newly created entry
512: -------------------------------------------------------------------------------
513: function insertAttrTableColRecord(p_attr_table_col_rec zpb_md_records.attr_table_col_entry)
514: return number is

Line 513: function insertAttrTableColRecord(p_attr_table_col_rec zpb_md_records.attr_table_col_entry)

509: -- insertAttrTableColRecord - Private function that inserts a
510: -- zpb_md_records.attr_table_col_entry into zpb_attr_table_col and
511: -- returns the primary key of the newly created entry
512: -------------------------------------------------------------------------------
513: function insertAttrTableColRecord(p_attr_table_col_rec zpb_md_records.attr_table_col_entry)
514: return number is
515:
516: l_attr_table_col_rec zpb_md_records.attr_table_col_entry;
517:

Line 516: l_attr_table_col_rec zpb_md_records.attr_table_col_entry;

512: -------------------------------------------------------------------------------
513: function insertAttrTableColRecord(p_attr_table_col_rec zpb_md_records.attr_table_col_entry)
514: return number is
515:
516: l_attr_table_col_rec zpb_md_records.attr_table_col_entry;
517:
518: begin
519:
520: l_attr_table_col_rec := p_attr_table_col_rec;

Line 578: -- zpb_md_records.cube_dims_entry into zpb_cube_dims and

574:
575:
576: -------------------------------------------------------------------------------
577: -- insertCubeDimsRecord - Private function that inserts a
578: -- zpb_md_records.cube_dims_entry into zpb_cube_dims and
579: -- returns the primary key of the newly created entry
580: -------------------------------------------------------------------------------
581: function insertCubeDimsRecord(p_cube_dims_rec zpb_md_records.cube_dims_entry)
582: return number is

Line 581: function insertCubeDimsRecord(p_cube_dims_rec zpb_md_records.cube_dims_entry)

577: -- insertCubeDimsRecord - Private function that inserts a
578: -- zpb_md_records.cube_dims_entry into zpb_cube_dims and
579: -- returns the primary key of the newly created entry
580: -------------------------------------------------------------------------------
581: function insertCubeDimsRecord(p_cube_dims_rec zpb_md_records.cube_dims_entry)
582: return number is
583:
584: l_cube_dims_rec zpb_md_records.cube_dims_entry;
585:

Line 584: l_cube_dims_rec zpb_md_records.cube_dims_entry;

580: -------------------------------------------------------------------------------
581: function insertCubeDimsRecord(p_cube_dims_rec zpb_md_records.cube_dims_entry)
582: return number is
583:
584: l_cube_dims_rec zpb_md_records.cube_dims_entry;
585:
586: begin
587:
588: l_cube_dims_rec := p_cube_dims_rec;

Line 646: -- zpb_md_records.cube_hier_entry into zpb_cube_hier and

642: end insertCubeDimsRecord;
643:
644: -------------------------------------------------------------------------------
645: -- insertCubeHierRecord - Private function that inserts a
646: -- zpb_md_records.cube_hier_entry into zpb_cube_hier and
647: -- returns the primary key of the newly created entry
648: -------------------------------------------------------------------------------
649: function insertCubeHierRecord(p_cube_hier_rec zpb_md_records.cube_hier_entry)
650: return number is

Line 649: function insertCubeHierRecord(p_cube_hier_rec zpb_md_records.cube_hier_entry)

645: -- insertCubeHierRecord - Private function that inserts a
646: -- zpb_md_records.cube_hier_entry into zpb_cube_hier and
647: -- returns the primary key of the newly created entry
648: -------------------------------------------------------------------------------
649: function insertCubeHierRecord(p_cube_hier_rec zpb_md_records.cube_hier_entry)
650: return number is
651:
652: l_cube_hier_rec zpb_md_records.cube_hier_entry;
653:

Line 652: l_cube_hier_rec zpb_md_records.cube_hier_entry;

648: -------------------------------------------------------------------------------
649: function insertCubeHierRecord(p_cube_hier_rec zpb_md_records.cube_hier_entry)
650: return number is
651:
652: l_cube_hier_rec zpb_md_records.cube_hier_entry;
653:
654: begin
655:
656: l_cube_hier_rec := p_cube_hier_rec;

Line 713: -- zpb_md_records.measures_entry into zpb_measures and

709: end insertCubeHierRecord;
710:
711: -------------------------------------------------------------------------------
712: -- insertMeasureRecord - Private function that inserts a
713: -- zpb_md_records.measures_entry into zpb_measures and
714: -- returns the primary key of the newly created entry
715: -------------------------------------------------------------------------------
716: function insertMeasureRecord(p_measure_rec zpb_md_records.measures_entry)
717: return number is

Line 716: function insertMeasureRecord(p_measure_rec zpb_md_records.measures_entry)

712: -- insertMeasureRecord - Private function that inserts a
713: -- zpb_md_records.measures_entry into zpb_measures and
714: -- returns the primary key of the newly created entry
715: -------------------------------------------------------------------------------
716: function insertMeasureRecord(p_measure_rec zpb_md_records.measures_entry)
717: return number is
718:
719: l_measure_rec zpb_md_records.measures_entry;
720:

Line 719: l_measure_rec zpb_md_records.measures_entry;

715: -------------------------------------------------------------------------------
716: function insertMeasureRecord(p_measure_rec zpb_md_records.measures_entry)
717: return number is
718:
719: l_measure_rec zpb_md_records.measures_entry;
720:
721: begin
722:
723: l_measure_rec := p_measure_rec;

Line 819: -- zpb_md_records.attributes_tl_entry into zpb_attributes_tl

815: end insertMeasureRecord;
816:
817: -------------------------------------------------------------------------------
818: -- insertAttributeTLRecord - Private procedure that inserts a
819: -- zpb_md_records.attributes_tl_entry into zpb_attributes_tl
820: -------------------------------------------------------------------------------
821: procedure insertAttributesTLRecord(p_attributes_tl_rec zpb_md_records.attributes_tl_entry)
822: is
823: l_attributes_tl_rec zpb_md_records.attributes_tl_entry;

Line 821: procedure insertAttributesTLRecord(p_attributes_tl_rec zpb_md_records.attributes_tl_entry)

817: -------------------------------------------------------------------------------
818: -- insertAttributeTLRecord - Private procedure that inserts a
819: -- zpb_md_records.attributes_tl_entry into zpb_attributes_tl
820: -------------------------------------------------------------------------------
821: procedure insertAttributesTLRecord(p_attributes_tl_rec zpb_md_records.attributes_tl_entry)
822: is
823: l_attributes_tl_rec zpb_md_records.attributes_tl_entry;
824: begin
825:

Line 823: l_attributes_tl_rec zpb_md_records.attributes_tl_entry;

819: -- zpb_md_records.attributes_tl_entry into zpb_attributes_tl
820: -------------------------------------------------------------------------------
821: procedure insertAttributesTLRecord(p_attributes_tl_rec zpb_md_records.attributes_tl_entry)
822: is
823: l_attributes_tl_rec zpb_md_records.attributes_tl_entry;
824: begin
825:
826: l_attributes_tl_rec := p_attributes_tl_rec;
827:

Line 866: -- zpb_md_records.dimensions_tl_entry into zpb_dimensions_tl

862:
863:
864: -------------------------------------------------------------------------------
865: -- insertDimensionsTLRecord - Private procedure that inserts a
866: -- zpb_md_records.dimensions_tl_entry into zpb_dimensions_tl
867: -------------------------------------------------------------------------------
868: procedure insertDimensionsTLRecord(p_dimensions_tl_rec zpb_md_records.dimensions_tl_entry)
869: is
870: l_dimensions_tl_rec zpb_md_records.dimensions_tl_entry;

Line 868: procedure insertDimensionsTLRecord(p_dimensions_tl_rec zpb_md_records.dimensions_tl_entry)

864: -------------------------------------------------------------------------------
865: -- insertDimensionsTLRecord - Private procedure that inserts a
866: -- zpb_md_records.dimensions_tl_entry into zpb_dimensions_tl
867: -------------------------------------------------------------------------------
868: procedure insertDimensionsTLRecord(p_dimensions_tl_rec zpb_md_records.dimensions_tl_entry)
869: is
870: l_dimensions_tl_rec zpb_md_records.dimensions_tl_entry;
871: begin
872:

Line 870: l_dimensions_tl_rec zpb_md_records.dimensions_tl_entry;

866: -- zpb_md_records.dimensions_tl_entry into zpb_dimensions_tl
867: -------------------------------------------------------------------------------
868: procedure insertDimensionsTLRecord(p_dimensions_tl_rec zpb_md_records.dimensions_tl_entry)
869: is
870: l_dimensions_tl_rec zpb_md_records.dimensions_tl_entry;
871: begin
872:
873: l_dimensions_tl_rec := p_dimensions_tl_rec;
874:

Line 912: -- zpb_md_records.hierarchies_entry into zpb_hierarchies and

908: end insertDimensionsTLRecord;
909:
910: -------------------------------------------------------------------------------
911: -- insertHierarchyRecord - Private function that inserts a
912: -- zpb_md_records.hierarchies_entry into zpb_hierarchies and
913: -- returns the primary key of the newly created entry
914: -------------------------------------------------------------------------------
915: function insertHierarchyRecord(p_hierarchies_rec in zpb_md_records.hierarchies_entry)
916: return number is

Line 915: function insertHierarchyRecord(p_hierarchies_rec in zpb_md_records.hierarchies_entry)

911: -- insertHierarchyRecord - Private function that inserts a
912: -- zpb_md_records.hierarchies_entry into zpb_hierarchies and
913: -- returns the primary key of the newly created entry
914: -------------------------------------------------------------------------------
915: function insertHierarchyRecord(p_hierarchies_rec in zpb_md_records.hierarchies_entry)
916: return number is
917: l_hierarchies_rec zpb_md_records.hierarchies_entry;
918:
919: begin

Line 917: l_hierarchies_rec zpb_md_records.hierarchies_entry;

913: -- returns the primary key of the newly created entry
914: -------------------------------------------------------------------------------
915: function insertHierarchyRecord(p_hierarchies_rec in zpb_md_records.hierarchies_entry)
916: return number is
917: l_hierarchies_rec zpb_md_records.hierarchies_entry;
918:
919: begin
920:
921: l_hierarchies_rec := p_hierarchies_rec;

Line 989: -- zpb_md_records.hierarchies_tl_entry into zpb_hierarchies_tl and

985: end insertHierarchyRecord;
986:
987: -------------------------------------------------------------------------------
988: -- insertHierarchyTLRecord - Private procedure that inserts a
989: -- zpb_md_records.hierarchies_tl_entry into zpb_hierarchies_tl and
990: -------------------------------------------------------------------------------
991: procedure insertHierarchyTLRecord(p_hierarchies_tl_rec in zpb_md_records.hierarchies_tl_entry)
992: is
993: l_hierarchies_tl_rec zpb_md_records.hierarchies_tl_entry;

Line 991: procedure insertHierarchyTLRecord(p_hierarchies_tl_rec in zpb_md_records.hierarchies_tl_entry)

987: -------------------------------------------------------------------------------
988: -- insertHierarchyTLRecord - Private procedure that inserts a
989: -- zpb_md_records.hierarchies_tl_entry into zpb_hierarchies_tl and
990: -------------------------------------------------------------------------------
991: procedure insertHierarchyTLRecord(p_hierarchies_tl_rec in zpb_md_records.hierarchies_tl_entry)
992: is
993: l_hierarchies_tl_rec zpb_md_records.hierarchies_tl_entry;
994: l_record_count number;
995:

Line 993: l_hierarchies_tl_rec zpb_md_records.hierarchies_tl_entry;

989: -- zpb_md_records.hierarchies_tl_entry into zpb_hierarchies_tl and
990: -------------------------------------------------------------------------------
991: procedure insertHierarchyTLRecord(p_hierarchies_tl_rec in zpb_md_records.hierarchies_tl_entry)
992: is
993: l_hierarchies_tl_rec zpb_md_records.hierarchies_tl_entry;
994: l_record_count number;
995:
996: begin
997:

Line 1061: -- zpb_md_records.levels_tl_entry into zpb_levels_tl and

1057: end insertHierarchyTLRecord;
1058:
1059: -------------------------------------------------------------------------------
1060: -- insertLevelTLRecord - Private procedure that inserts a
1061: -- zpb_md_records.levels_tl_entry into zpb_levels_tl and
1062: -------------------------------------------------------------------------------
1063: procedure insertLevelTLRecord(p_levels_tl_rec in zpb_md_records.levels_tl_entry)
1064: is
1065: l_levels_tl_rec zpb_md_records.levels_tl_entry;

Line 1063: procedure insertLevelTLRecord(p_levels_tl_rec in zpb_md_records.levels_tl_entry)

1059: -------------------------------------------------------------------------------
1060: -- insertLevelTLRecord - Private procedure that inserts a
1061: -- zpb_md_records.levels_tl_entry into zpb_levels_tl and
1062: -------------------------------------------------------------------------------
1063: procedure insertLevelTLRecord(p_levels_tl_rec in zpb_md_records.levels_tl_entry)
1064: is
1065: l_levels_tl_rec zpb_md_records.levels_tl_entry;
1066: l_record_count number;
1067:

Line 1065: l_levels_tl_rec zpb_md_records.levels_tl_entry;

1061: -- zpb_md_records.levels_tl_entry into zpb_levels_tl and
1062: -------------------------------------------------------------------------------
1063: procedure insertLevelTLRecord(p_levels_tl_rec in zpb_md_records.levels_tl_entry)
1064: is
1065: l_levels_tl_rec zpb_md_records.levels_tl_entry;
1066: l_record_count number;
1067:
1068: begin
1069:

Line 1170: -- zpb_md_records.cubes_entry into zpb_cubes and

1166: end deleteCubeRecord;
1167:
1168: -------------------------------------------------------------------------------
1169: -- insertCubeRecord - Private function that inserts a
1170: -- zpb_md_records.cubes_entry into zpb_cubes and
1171: -- returns the primary key of the newly created entry
1172: --
1173: -- if p_primary_key_provided is true, then the primary key for the
1174: -- cube to be inserted is provided and we do not select it from sequence

Line 1176: function insertCubeRecord(p_cube_rec in zpb_md_records.CUBES_ENTRY,

1172: --
1173: -- if p_primary_key_provided is true, then the primary key for the
1174: -- cube to be inserted is provided and we do not select it from sequence
1175: -------------------------------------------------------------------------------
1176: function insertCubeRecord(p_cube_rec in zpb_md_records.CUBES_ENTRY,
1177: p_primary_key_provided in boolean default false)
1178: return number is
1179: l_cube_rec zpb_md_records.cubes_entry;
1180: bus_area_id_num number;

Line 1179: l_cube_rec zpb_md_records.cubes_entry;

1175: -------------------------------------------------------------------------------
1176: function insertCubeRecord(p_cube_rec in zpb_md_records.CUBES_ENTRY,
1177: p_primary_key_provided in boolean default false)
1178: return number is
1179: l_cube_rec zpb_md_records.cubes_entry;
1180: bus_area_id_num number;
1181: insert_flag boolean;
1182:
1183: begin

Line 1259: -- zpb_md_records.hier_scope_entry into zpb_hier_scope and

1255:
1256:
1257: -------------------------------------------------------------------------------
1258: -- insertHierScopeRecord - Private function that inserts a
1259: -- zpb_md_records.hier_scope_entry into zpb_hier_scope and
1260: -- returns the primary key of the newly created entry
1261: -------------------------------------------------------------------------------
1262: function insertHierScopeRecord(p_hier_scope_rec zpb_md_records.hier_scope_entry)
1263: return number is

Line 1262: function insertHierScopeRecord(p_hier_scope_rec zpb_md_records.hier_scope_entry)

1258: -- insertHierScopeRecord - Private function that inserts a
1259: -- zpb_md_records.hier_scope_entry into zpb_hier_scope and
1260: -- returns the primary key of the newly created entry
1261: -------------------------------------------------------------------------------
1262: function insertHierScopeRecord(p_hier_scope_rec zpb_md_records.hier_scope_entry)
1263: return number is
1264:
1265: l_hier_scope_rec zpb_md_records.hier_scope_entry;
1266:

Line 1265: l_hier_scope_rec zpb_md_records.hier_scope_entry;

1261: -------------------------------------------------------------------------------
1262: function insertHierScopeRecord(p_hier_scope_rec zpb_md_records.hier_scope_entry)
1263: return number is
1264:
1265: l_hier_scope_rec zpb_md_records.hier_scope_entry;
1266:
1267: begin
1268:
1269: l_hier_scope_rec := p_hier_scope_rec;

Line 1333: -- zpb_md_records.hier_level_scope_entry into zpb_hier_level_scope and

1329: end insertHierScopeRecord;
1330:
1331: -------------------------------------------------------------------------------
1332: -- insertHierlevelscopeRecord - Private function that inserts a
1333: -- zpb_md_records.hier_level_scope_entry into zpb_hier_level_scope and
1334: -- returns the primary key of the newly created entry
1335: -------------------------------------------------------------------------------
1336: function insertHierlevelscopeRecord(p_hier_level_scope_rec zpb_md_records.hier_level_scope_entry)
1337: return number is

Line 1336: function insertHierlevelscopeRecord(p_hier_level_scope_rec zpb_md_records.hier_level_scope_entry)

1332: -- insertHierlevelscopeRecord - Private function that inserts a
1333: -- zpb_md_records.hier_level_scope_entry into zpb_hier_level_scope and
1334: -- returns the primary key of the newly created entry
1335: -------------------------------------------------------------------------------
1336: function insertHierlevelscopeRecord(p_hier_level_scope_rec zpb_md_records.hier_level_scope_entry)
1337: return number is
1338:
1339: l_hier_level_scope_rec zpb_md_records.hier_level_scope_entry;
1340:

Line 1339: l_hier_level_scope_rec zpb_md_records.hier_level_scope_entry;

1335: -------------------------------------------------------------------------------
1336: function insertHierlevelscopeRecord(p_hier_level_scope_rec zpb_md_records.hier_level_scope_entry)
1337: return number is
1338:
1339: l_hier_level_scope_rec zpb_md_records.hier_level_scope_entry;
1340:
1341: begin
1342:
1343: l_hier_level_scope_rec := p_hier_level_scope_rec;

Line 1407: -- zpb_md_records.attribute_scope_entry into zpb_attribute_scope and

1403:
1404:
1405: -------------------------------------------------------------------------------
1406: -- insertAttributescopeRecord - Private function that inserts a
1407: -- zpb_md_records.attribute_scope_entry into zpb_attribute_scope and
1408: -- returns the primary key of the newly created entry
1409: -------------------------------------------------------------------------------
1410: function insertAttributescopeRecord(p_attribute_scope_rec zpb_md_records.attribute_scope_entry)
1411: return number is

Line 1410: function insertAttributescopeRecord(p_attribute_scope_rec zpb_md_records.attribute_scope_entry)

1406: -- insertAttributescopeRecord - Private function that inserts a
1407: -- zpb_md_records.attribute_scope_entry into zpb_attribute_scope and
1408: -- returns the primary key of the newly created entry
1409: -------------------------------------------------------------------------------
1410: function insertAttributescopeRecord(p_attribute_scope_rec zpb_md_records.attribute_scope_entry)
1411: return number is
1412:
1413: l_attribute_scope_rec zpb_md_records.attribute_scope_entry;
1414:

Line 1413: l_attribute_scope_rec zpb_md_records.attribute_scope_entry;

1409: -------------------------------------------------------------------------------
1410: function insertAttributescopeRecord(p_attribute_scope_rec zpb_md_records.attribute_scope_entry)
1411: return number is
1412:
1413: l_attribute_scope_rec zpb_md_records.attribute_scope_entry;
1414:
1415: begin
1416:
1417: l_attribute_scope_rec := p_attribute_scope_rec;

Line 1790: m_dimension_en zpb_md_records.dimensions_entry;

1786: l_global_attr_ecm zpb_ecm.global_attr_ecm;
1787: l_attr_ecm zpb_ecm.attr_ecm;
1788: l_attr_nameFrag varchar2(500);
1789:
1790: m_dimension_en zpb_md_records.dimensions_entry;
1791: m_dimension_tl_en zpb_md_records.dimensions_tl_entry;
1792: m_pers_table_en zpb_md_records.tables_entry;
1793: m_shar_table_en zpb_md_records.tables_entry;
1794: m_pers_column_en zpb_md_records.columns_entry;

Line 1791: m_dimension_tl_en zpb_md_records.dimensions_tl_entry;

1787: l_attr_ecm zpb_ecm.attr_ecm;
1788: l_attr_nameFrag varchar2(500);
1789:
1790: m_dimension_en zpb_md_records.dimensions_entry;
1791: m_dimension_tl_en zpb_md_records.dimensions_tl_entry;
1792: m_pers_table_en zpb_md_records.tables_entry;
1793: m_shar_table_en zpb_md_records.tables_entry;
1794: m_pers_column_en zpb_md_records.columns_entry;
1795: m_shar_column_en zpb_md_records.columns_entry;

Line 1792: m_pers_table_en zpb_md_records.tables_entry;

1788: l_attr_nameFrag varchar2(500);
1789:
1790: m_dimension_en zpb_md_records.dimensions_entry;
1791: m_dimension_tl_en zpb_md_records.dimensions_tl_entry;
1792: m_pers_table_en zpb_md_records.tables_entry;
1793: m_shar_table_en zpb_md_records.tables_entry;
1794: m_pers_column_en zpb_md_records.columns_entry;
1795: m_shar_column_en zpb_md_records.columns_entry;
1796:

Line 1793: m_shar_table_en zpb_md_records.tables_entry;

1789:
1790: m_dimension_en zpb_md_records.dimensions_entry;
1791: m_dimension_tl_en zpb_md_records.dimensions_tl_entry;
1792: m_pers_table_en zpb_md_records.tables_entry;
1793: m_shar_table_en zpb_md_records.tables_entry;
1794: m_pers_column_en zpb_md_records.columns_entry;
1795: m_shar_column_en zpb_md_records.columns_entry;
1796:
1797: m_hier_en zpb_md_records.hierarchies_entry;

Line 1794: m_pers_column_en zpb_md_records.columns_entry;

1790: m_dimension_en zpb_md_records.dimensions_entry;
1791: m_dimension_tl_en zpb_md_records.dimensions_tl_entry;
1792: m_pers_table_en zpb_md_records.tables_entry;
1793: m_shar_table_en zpb_md_records.tables_entry;
1794: m_pers_column_en zpb_md_records.columns_entry;
1795: m_shar_column_en zpb_md_records.columns_entry;
1796:
1797: m_hier_en zpb_md_records.hierarchies_entry;
1798: m_hier_tl_en zpb_md_records.hierarchies_tl_entry;

Line 1795: m_shar_column_en zpb_md_records.columns_entry;

1791: m_dimension_tl_en zpb_md_records.dimensions_tl_entry;
1792: m_pers_table_en zpb_md_records.tables_entry;
1793: m_shar_table_en zpb_md_records.tables_entry;
1794: m_pers_column_en zpb_md_records.columns_entry;
1795: m_shar_column_en zpb_md_records.columns_entry;
1796:
1797: m_hier_en zpb_md_records.hierarchies_entry;
1798: m_hier_tl_en zpb_md_records.hierarchies_tl_entry;
1799: m_level_en zpb_md_records.levels_entry;

Line 1797: m_hier_en zpb_md_records.hierarchies_entry;

1793: m_shar_table_en zpb_md_records.tables_entry;
1794: m_pers_column_en zpb_md_records.columns_entry;
1795: m_shar_column_en zpb_md_records.columns_entry;
1796:
1797: m_hier_en zpb_md_records.hierarchies_entry;
1798: m_hier_tl_en zpb_md_records.hierarchies_tl_entry;
1799: m_level_en zpb_md_records.levels_entry;
1800: m_level_tl_en zpb_md_records.levels_tl_entry;
1801: m_hier_level_en zpb_md_records.hier_level_entry;

Line 1798: m_hier_tl_en zpb_md_records.hierarchies_tl_entry;

1794: m_pers_column_en zpb_md_records.columns_entry;
1795: m_shar_column_en zpb_md_records.columns_entry;
1796:
1797: m_hier_en zpb_md_records.hierarchies_entry;
1798: m_hier_tl_en zpb_md_records.hierarchies_tl_entry;
1799: m_level_en zpb_md_records.levels_entry;
1800: m_level_tl_en zpb_md_records.levels_tl_entry;
1801: m_hier_level_en zpb_md_records.hier_level_entry;
1802: m_hr_shar_table_en zpb_md_records.tables_entry;

Line 1799: m_level_en zpb_md_records.levels_entry;

1795: m_shar_column_en zpb_md_records.columns_entry;
1796:
1797: m_hier_en zpb_md_records.hierarchies_entry;
1798: m_hier_tl_en zpb_md_records.hierarchies_tl_entry;
1799: m_level_en zpb_md_records.levels_entry;
1800: m_level_tl_en zpb_md_records.levels_tl_entry;
1801: m_hier_level_en zpb_md_records.hier_level_entry;
1802: m_hr_shar_table_en zpb_md_records.tables_entry;
1803: m_hr_pers_table_en zpb_md_records.tables_entry;

Line 1800: m_level_tl_en zpb_md_records.levels_tl_entry;

1796:
1797: m_hier_en zpb_md_records.hierarchies_entry;
1798: m_hier_tl_en zpb_md_records.hierarchies_tl_entry;
1799: m_level_en zpb_md_records.levels_entry;
1800: m_level_tl_en zpb_md_records.levels_tl_entry;
1801: m_hier_level_en zpb_md_records.hier_level_entry;
1802: m_hr_shar_table_en zpb_md_records.tables_entry;
1803: m_hr_pers_table_en zpb_md_records.tables_entry;
1804:

Line 1801: m_hier_level_en zpb_md_records.hier_level_entry;

1797: m_hier_en zpb_md_records.hierarchies_entry;
1798: m_hier_tl_en zpb_md_records.hierarchies_tl_entry;
1799: m_level_en zpb_md_records.levels_entry;
1800: m_level_tl_en zpb_md_records.levels_tl_entry;
1801: m_hier_level_en zpb_md_records.hier_level_entry;
1802: m_hr_shar_table_en zpb_md_records.tables_entry;
1803: m_hr_pers_table_en zpb_md_records.tables_entry;
1804:
1805: -- static hierarchy table columns

Line 1802: m_hr_shar_table_en zpb_md_records.tables_entry;

1798: m_hier_tl_en zpb_md_records.hierarchies_tl_entry;
1799: m_level_en zpb_md_records.levels_entry;
1800: m_level_tl_en zpb_md_records.levels_tl_entry;
1801: m_hier_level_en zpb_md_records.hier_level_entry;
1802: m_hr_shar_table_en zpb_md_records.tables_entry;
1803: m_hr_pers_table_en zpb_md_records.tables_entry;
1804:
1805: -- static hierarchy table columns
1806: m_hr_pers_col_memCol zpb_md_records.columns_entry;

Line 1803: m_hr_pers_table_en zpb_md_records.tables_entry;

1799: m_level_en zpb_md_records.levels_entry;
1800: m_level_tl_en zpb_md_records.levels_tl_entry;
1801: m_hier_level_en zpb_md_records.hier_level_entry;
1802: m_hr_shar_table_en zpb_md_records.tables_entry;
1803: m_hr_pers_table_en zpb_md_records.tables_entry;
1804:
1805: -- static hierarchy table columns
1806: m_hr_pers_col_memCol zpb_md_records.columns_entry;
1807: m_hr_shar_col_memCol zpb_md_records.columns_entry;

Line 1806: m_hr_pers_col_memCol zpb_md_records.columns_entry;

1802: m_hr_shar_table_en zpb_md_records.tables_entry;
1803: m_hr_pers_table_en zpb_md_records.tables_entry;
1804:
1805: -- static hierarchy table columns
1806: m_hr_pers_col_memCol zpb_md_records.columns_entry;
1807: m_hr_shar_col_memCol zpb_md_records.columns_entry;
1808: m_hr_pers_col_gidCol zpb_md_records.columns_entry;
1809: m_hr_shar_col_gidCol zpb_md_records.columns_entry;
1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;

Line 1807: m_hr_shar_col_memCol zpb_md_records.columns_entry;

1803: m_hr_pers_table_en zpb_md_records.tables_entry;
1804:
1805: -- static hierarchy table columns
1806: m_hr_pers_col_memCol zpb_md_records.columns_entry;
1807: m_hr_shar_col_memCol zpb_md_records.columns_entry;
1808: m_hr_pers_col_gidCol zpb_md_records.columns_entry;
1809: m_hr_shar_col_gidCol zpb_md_records.columns_entry;
1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;
1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;

Line 1808: m_hr_pers_col_gidCol zpb_md_records.columns_entry;

1804:
1805: -- static hierarchy table columns
1806: m_hr_pers_col_memCol zpb_md_records.columns_entry;
1807: m_hr_shar_col_memCol zpb_md_records.columns_entry;
1808: m_hr_pers_col_gidCol zpb_md_records.columns_entry;
1809: m_hr_shar_col_gidCol zpb_md_records.columns_entry;
1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;
1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;
1812: m_hr_shar_col_pgidCol zpb_md_records.columns_entry;

Line 1809: m_hr_shar_col_gidCol zpb_md_records.columns_entry;

1805: -- static hierarchy table columns
1806: m_hr_pers_col_memCol zpb_md_records.columns_entry;
1807: m_hr_shar_col_memCol zpb_md_records.columns_entry;
1808: m_hr_pers_col_gidCol zpb_md_records.columns_entry;
1809: m_hr_shar_col_gidCol zpb_md_records.columns_entry;
1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;
1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;
1812: m_hr_shar_col_pgidCol zpb_md_records.columns_entry;
1813: m_hr_pers_col_pgidCol zpb_md_records.columns_entry;

Line 1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;

1806: m_hr_pers_col_memCol zpb_md_records.columns_entry;
1807: m_hr_shar_col_memCol zpb_md_records.columns_entry;
1808: m_hr_pers_col_gidCol zpb_md_records.columns_entry;
1809: m_hr_shar_col_gidCol zpb_md_records.columns_entry;
1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;
1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;
1812: m_hr_shar_col_pgidCol zpb_md_records.columns_entry;
1813: m_hr_pers_col_pgidCol zpb_md_records.columns_entry;
1814: m_hr_pers_col_orderCol zpb_md_records.columns_entry;

Line 1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;

1807: m_hr_shar_col_memCol zpb_md_records.columns_entry;
1808: m_hr_pers_col_gidCol zpb_md_records.columns_entry;
1809: m_hr_shar_col_gidCol zpb_md_records.columns_entry;
1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;
1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;
1812: m_hr_shar_col_pgidCol zpb_md_records.columns_entry;
1813: m_hr_pers_col_pgidCol zpb_md_records.columns_entry;
1814: m_hr_pers_col_orderCol zpb_md_records.columns_entry;
1815: m_hr_shar_col_orderCol zpb_md_records.columns_entry;

Line 1812: m_hr_shar_col_pgidCol zpb_md_records.columns_entry;

1808: m_hr_pers_col_gidCol zpb_md_records.columns_entry;
1809: m_hr_shar_col_gidCol zpb_md_records.columns_entry;
1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;
1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;
1812: m_hr_shar_col_pgidCol zpb_md_records.columns_entry;
1813: m_hr_pers_col_pgidCol zpb_md_records.columns_entry;
1814: m_hr_pers_col_orderCol zpb_md_records.columns_entry;
1815: m_hr_shar_col_orderCol zpb_md_records.columns_entry;
1816:

Line 1813: m_hr_pers_col_pgidCol zpb_md_records.columns_entry;

1809: m_hr_shar_col_gidCol zpb_md_records.columns_entry;
1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;
1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;
1812: m_hr_shar_col_pgidCol zpb_md_records.columns_entry;
1813: m_hr_pers_col_pgidCol zpb_md_records.columns_entry;
1814: m_hr_pers_col_orderCol zpb_md_records.columns_entry;
1815: m_hr_shar_col_orderCol zpb_md_records.columns_entry;
1816:
1817: m_level_order number;

Line 1814: m_hr_pers_col_orderCol zpb_md_records.columns_entry;

1810: m_hr_shar_col_parentCol zpb_md_records.columns_entry;
1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;
1812: m_hr_shar_col_pgidCol zpb_md_records.columns_entry;
1813: m_hr_pers_col_pgidCol zpb_md_records.columns_entry;
1814: m_hr_pers_col_orderCol zpb_md_records.columns_entry;
1815: m_hr_shar_col_orderCol zpb_md_records.columns_entry;
1816:
1817: m_level_order number;
1818:

Line 1815: m_hr_shar_col_orderCol zpb_md_records.columns_entry;

1811: m_hr_pers_col_parentCol zpb_md_records.columns_entry;
1812: m_hr_shar_col_pgidCol zpb_md_records.columns_entry;
1813: m_hr_pers_col_pgidCol zpb_md_records.columns_entry;
1814: m_hr_pers_col_orderCol zpb_md_records.columns_entry;
1815: m_hr_shar_col_orderCol zpb_md_records.columns_entry;
1816:
1817: m_level_order number;
1818:
1819: m_table_id number;

Line 1828: m_attr_en zpb_md_records.attributes_entry;

1824: m_attr_table_col_id number;
1825: m_dummy_num number;
1826:
1827: -- attribute
1828: m_attr_en zpb_md_records.attributes_entry;
1829: m_attr_table_col_en zpb_md_records.attr_table_col_entry;
1830:
1831: -- attribute range dimension
1832: m_attr_rangedim_en zpb_md_records.dimensions_entry;

Line 1829: m_attr_table_col_en zpb_md_records.attr_table_col_entry;

1825: m_dummy_num number;
1826:
1827: -- attribute
1828: m_attr_en zpb_md_records.attributes_entry;
1829: m_attr_table_col_en zpb_md_records.attr_table_col_entry;
1830:
1831: -- attribute range dimension
1832: m_attr_rangedim_en zpb_md_records.dimensions_entry;
1833: m_attr_rangedim_tl_en zpb_md_records.dimensions_tl_entry;

Line 1832: m_attr_rangedim_en zpb_md_records.dimensions_entry;

1828: m_attr_en zpb_md_records.attributes_entry;
1829: m_attr_table_col_en zpb_md_records.attr_table_col_entry;
1830:
1831: -- attribute range dimension
1832: m_attr_rangedim_en zpb_md_records.dimensions_entry;
1833: m_attr_rangedim_tl_en zpb_md_records.dimensions_tl_entry;
1834: m_attr_rangehier_en zpb_md_records.hierarchies_entry;
1835: m_attr_rangetbl_en zpb_md_records.tables_entry;
1836: m_attr_rangedimCount number;

Line 1833: m_attr_rangedim_tl_en zpb_md_records.dimensions_tl_entry;

1829: m_attr_table_col_en zpb_md_records.attr_table_col_entry;
1830:
1831: -- attribute range dimension
1832: m_attr_rangedim_en zpb_md_records.dimensions_entry;
1833: m_attr_rangedim_tl_en zpb_md_records.dimensions_tl_entry;
1834: m_attr_rangehier_en zpb_md_records.hierarchies_entry;
1835: m_attr_rangetbl_en zpb_md_records.tables_entry;
1836: m_attr_rangedimCount number;
1837: m_attr_rangecol_en zpb_md_records.columns_entry;

Line 1834: m_attr_rangehier_en zpb_md_records.hierarchies_entry;

1830:
1831: -- attribute range dimension
1832: m_attr_rangedim_en zpb_md_records.dimensions_entry;
1833: m_attr_rangedim_tl_en zpb_md_records.dimensions_tl_entry;
1834: m_attr_rangehier_en zpb_md_records.hierarchies_entry;
1835: m_attr_rangetbl_en zpb_md_records.tables_entry;
1836: m_attr_rangedimCount number;
1837: m_attr_rangecol_en zpb_md_records.columns_entry;
1838: m_attr_rangehl_en zpb_md_records.hier_level_entry;

Line 1835: m_attr_rangetbl_en zpb_md_records.tables_entry;

1831: -- attribute range dimension
1832: m_attr_rangedim_en zpb_md_records.dimensions_entry;
1833: m_attr_rangedim_tl_en zpb_md_records.dimensions_tl_entry;
1834: m_attr_rangehier_en zpb_md_records.hierarchies_entry;
1835: m_attr_rangetbl_en zpb_md_records.tables_entry;
1836: m_attr_rangedimCount number;
1837: m_attr_rangecol_en zpb_md_records.columns_entry;
1838: m_attr_rangehl_en zpb_md_records.hier_level_entry;
1839: m_attr_rangelev_en zpb_md_records.levels_entry;

Line 1837: m_attr_rangecol_en zpb_md_records.columns_entry;

1833: m_attr_rangedim_tl_en zpb_md_records.dimensions_tl_entry;
1834: m_attr_rangehier_en zpb_md_records.hierarchies_entry;
1835: m_attr_rangetbl_en zpb_md_records.tables_entry;
1836: m_attr_rangedimCount number;
1837: m_attr_rangecol_en zpb_md_records.columns_entry;
1838: m_attr_rangehl_en zpb_md_records.hier_level_entry;
1839: m_attr_rangelev_en zpb_md_records.levels_entry;
1840: m_attr_rangeattr_en zpb_md_records.attributes_entry;
1841: m_attr_rangeatc_en zpb_md_records.attr_table_col_entry;

Line 1838: m_attr_rangehl_en zpb_md_records.hier_level_entry;

1834: m_attr_rangehier_en zpb_md_records.hierarchies_entry;
1835: m_attr_rangetbl_en zpb_md_records.tables_entry;
1836: m_attr_rangedimCount number;
1837: m_attr_rangecol_en zpb_md_records.columns_entry;
1838: m_attr_rangehl_en zpb_md_records.hier_level_entry;
1839: m_attr_rangelev_en zpb_md_records.levels_entry;
1840: m_attr_rangeattr_en zpb_md_records.attributes_entry;
1841: m_attr_rangeatc_en zpb_md_records.attr_table_col_entry;
1842:

Line 1839: m_attr_rangelev_en zpb_md_records.levels_entry;

1835: m_attr_rangetbl_en zpb_md_records.tables_entry;
1836: m_attr_rangedimCount number;
1837: m_attr_rangecol_en zpb_md_records.columns_entry;
1838: m_attr_rangehl_en zpb_md_records.hier_level_entry;
1839: m_attr_rangelev_en zpb_md_records.levels_entry;
1840: m_attr_rangeattr_en zpb_md_records.attributes_entry;
1841: m_attr_rangeatc_en zpb_md_records.attr_table_col_entry;
1842:
1843: -- shared attribute range dimension

Line 1840: m_attr_rangeattr_en zpb_md_records.attributes_entry;

1836: m_attr_rangedimCount number;
1837: m_attr_rangecol_en zpb_md_records.columns_entry;
1838: m_attr_rangehl_en zpb_md_records.hier_level_entry;
1839: m_attr_rangelev_en zpb_md_records.levels_entry;
1840: m_attr_rangeattr_en zpb_md_records.attributes_entry;
1841: m_attr_rangeatc_en zpb_md_records.attr_table_col_entry;
1842:
1843: -- shared attribute range dimension
1844: m_attr_range_sh_tbl_en zpb_md_records.tables_entry;

Line 1841: m_attr_rangeatc_en zpb_md_records.attr_table_col_entry;

1837: m_attr_rangecol_en zpb_md_records.columns_entry;
1838: m_attr_rangehl_en zpb_md_records.hier_level_entry;
1839: m_attr_rangelev_en zpb_md_records.levels_entry;
1840: m_attr_rangeattr_en zpb_md_records.attributes_entry;
1841: m_attr_rangeatc_en zpb_md_records.attr_table_col_entry;
1842:
1843: -- shared attribute range dimension
1844: m_attr_range_sh_tbl_en zpb_md_records.tables_entry;
1845: m_attr_range_sh_col_en zpb_md_records.columns_entry;

Line 1844: m_attr_range_sh_tbl_en zpb_md_records.tables_entry;

1840: m_attr_rangeattr_en zpb_md_records.attributes_entry;
1841: m_attr_rangeatc_en zpb_md_records.attr_table_col_entry;
1842:
1843: -- shared attribute range dimension
1844: m_attr_range_sh_tbl_en zpb_md_records.tables_entry;
1845: m_attr_range_sh_col_en zpb_md_records.columns_entry;
1846: m_attr_sh_rangeatc_en zpb_md_records.attr_table_col_entry;
1847:
1848: m_attr_tl_en zpb_md_records.attributes_tl_entry;

Line 1845: m_attr_range_sh_col_en zpb_md_records.columns_entry;

1841: m_attr_rangeatc_en zpb_md_records.attr_table_col_entry;
1842:
1843: -- shared attribute range dimension
1844: m_attr_range_sh_tbl_en zpb_md_records.tables_entry;
1845: m_attr_range_sh_col_en zpb_md_records.columns_entry;
1846: m_attr_sh_rangeatc_en zpb_md_records.attr_table_col_entry;
1847:
1848: m_attr_tl_en zpb_md_records.attributes_tl_entry;
1849:

Line 1846: m_attr_sh_rangeatc_en zpb_md_records.attr_table_col_entry;

1842:
1843: -- shared attribute range dimension
1844: m_attr_range_sh_tbl_en zpb_md_records.tables_entry;
1845: m_attr_range_sh_col_en zpb_md_records.columns_entry;
1846: m_attr_sh_rangeatc_en zpb_md_records.attr_table_col_entry;
1847:
1848: m_attr_tl_en zpb_md_records.attributes_tl_entry;
1849:
1850: bus_area_id_num number;

Line 1848: m_attr_tl_en zpb_md_records.attributes_tl_entry;

1844: m_attr_range_sh_tbl_en zpb_md_records.tables_entry;
1845: m_attr_range_sh_col_en zpb_md_records.columns_entry;
1846: m_attr_sh_rangeatc_en zpb_md_records.attr_table_col_entry;
1847:
1848: m_attr_tl_en zpb_md_records.attributes_tl_entry;
1849:
1850: bus_area_id_num number;
1851:
1852: -- primary keys found flags

Line 3230: m_cube_en zpb_md_records.cubes_entry;

3226: nl varchar2(1) := fnd_global.local_chr(10);
3227: l_dim_ecm zpb_ecm.dimension_ecm;
3228:
3229: -- interface layer table entrieds
3230: m_cube_en zpb_md_records.cubes_entry;
3231: m_table_en zpb_md_records.tables_entry;
3232: m_cube_dims_en zpb_md_records.cube_dims_entry;
3233: m_column_en zpb_md_records.columns_entry;
3234: m_cube_hier_en zpb_md_records.cube_hier_entry;

Line 3231: m_table_en zpb_md_records.tables_entry;

3227: l_dim_ecm zpb_ecm.dimension_ecm;
3228:
3229: -- interface layer table entrieds
3230: m_cube_en zpb_md_records.cubes_entry;
3231: m_table_en zpb_md_records.tables_entry;
3232: m_cube_dims_en zpb_md_records.cube_dims_entry;
3233: m_column_en zpb_md_records.columns_entry;
3234: m_cube_hier_en zpb_md_records.cube_hier_entry;
3235:

Line 3232: m_cube_dims_en zpb_md_records.cube_dims_entry;

3228:
3229: -- interface layer table entrieds
3230: m_cube_en zpb_md_records.cubes_entry;
3231: m_table_en zpb_md_records.tables_entry;
3232: m_cube_dims_en zpb_md_records.cube_dims_entry;
3233: m_column_en zpb_md_records.columns_entry;
3234: m_cube_hier_en zpb_md_records.cube_hier_entry;
3235:
3236: m_relation_id number;

Line 3233: m_column_en zpb_md_records.columns_entry;

3229: -- interface layer table entrieds
3230: m_cube_en zpb_md_records.cubes_entry;
3231: m_table_en zpb_md_records.tables_entry;
3232: m_cube_dims_en zpb_md_records.cube_dims_entry;
3233: m_column_en zpb_md_records.columns_entry;
3234: m_cube_hier_en zpb_md_records.cube_hier_entry;
3235:
3236: m_relation_id number;
3237: m_table_id number;

Line 3234: m_cube_hier_en zpb_md_records.cube_hier_entry;

3230: m_cube_en zpb_md_records.cubes_entry;
3231: m_table_en zpb_md_records.tables_entry;
3232: m_cube_dims_en zpb_md_records.cube_dims_entry;
3233: m_column_en zpb_md_records.columns_entry;
3234: m_cube_hier_en zpb_md_records.cube_hier_entry;
3235:
3236: m_relation_id number;
3237: m_table_id number;
3238:

Line 3903: m_meas_en zpb_md_records.measures_entry;

3899: nl varchar2(1) := fnd_global.local_chr(10);
3900: l_global_ecm zpb_ecm.global_ecm;
3901:
3902: -- measure table entry
3903: m_meas_en zpb_md_records.measures_entry;
3904: m_meas_id number;
3905: m_cwm_name varchar2(128);
3906: m_column_en zpb_md_records.columns_entry;
3907:

Line 3906: m_column_en zpb_md_records.columns_entry;

3902: -- measure table entry
3903: m_meas_en zpb_md_records.measures_entry;
3904: m_meas_id number;
3905: m_cwm_name varchar2(128);
3906: m_column_en zpb_md_records.columns_entry;
3907:
3908: l_insert_meas_flag boolean;
3909:
3910: -- string manipulations for personal measure MD

Line 4214: m_meas_en zpb_md_records.measures_entry;

4210: l_dim_ecm zpb_ecm.dimension_ecm;
4211: l_global_ecm zpb_ecm.global_ecm;
4212:
4213: -- measure entry
4214: m_meas_en zpb_md_records.measures_entry;
4215: m_meas_id number;
4216: m_meas_cube_name varchar2(128);
4217: m_meas_col_name varchar2(128);
4218: m_column_en zpb_md_records.columns_entry;

Line 4218: m_column_en zpb_md_records.columns_entry;

4214: m_meas_en zpb_md_records.measures_entry;
4215: m_meas_id number;
4216: m_meas_cube_name varchar2(128);
4217: m_meas_col_name varchar2(128);
4218: m_column_en zpb_md_records.columns_entry;
4219:
4220: -- store start time. On completion of refresh all entries
4221: -- with lsat_updated before start date will be removed
4222: m_start_time date;

Line 4226: m_table_en zpb_md_records.tables_entry;

4222: m_start_time date;
4223: bus_area_id_num number;
4224:
4225: -- "special" table entries
4226: m_table_en zpb_md_records.tables_entry;
4227: m_column_id_num number;
4228:
4229: begin
4230:

Line 4710: m_cube_en zpb_md_records.cubes_entry;

4706: l_cpr_meas_cube varchar2(64);
4707: l_frmcpr varchar2(16);
4708:
4709: -- md table entries
4710: m_cube_en zpb_md_records.cubes_entry;
4711: m_table_en zpb_md_records.tables_entry;
4712: m_cube_dims_en zpb_md_records.cube_dims_entry;
4713: m_column_en zpb_md_records.columns_entry;
4714: m_cube_hier_en zpb_md_records.cube_hier_entry;

Line 4711: m_table_en zpb_md_records.tables_entry;

4707: l_frmcpr varchar2(16);
4708:
4709: -- md table entries
4710: m_cube_en zpb_md_records.cubes_entry;
4711: m_table_en zpb_md_records.tables_entry;
4712: m_cube_dims_en zpb_md_records.cube_dims_entry;
4713: m_column_en zpb_md_records.columns_entry;
4714: m_cube_hier_en zpb_md_records.cube_hier_entry;
4715: m_meas_en zpb_md_records.measures_entry;

Line 4712: m_cube_dims_en zpb_md_records.cube_dims_entry;

4708:
4709: -- md table entries
4710: m_cube_en zpb_md_records.cubes_entry;
4711: m_table_en zpb_md_records.tables_entry;
4712: m_cube_dims_en zpb_md_records.cube_dims_entry;
4713: m_column_en zpb_md_records.columns_entry;
4714: m_cube_hier_en zpb_md_records.cube_hier_entry;
4715: m_meas_en zpb_md_records.measures_entry;
4716:

Line 4713: m_column_en zpb_md_records.columns_entry;

4709: -- md table entries
4710: m_cube_en zpb_md_records.cubes_entry;
4711: m_table_en zpb_md_records.tables_entry;
4712: m_cube_dims_en zpb_md_records.cube_dims_entry;
4713: m_column_en zpb_md_records.columns_entry;
4714: m_cube_hier_en zpb_md_records.cube_hier_entry;
4715: m_meas_en zpb_md_records.measures_entry;
4716:
4717: m_cube_id number;

Line 4714: m_cube_hier_en zpb_md_records.cube_hier_entry;

4710: m_cube_en zpb_md_records.cubes_entry;
4711: m_table_en zpb_md_records.tables_entry;
4712: m_cube_dims_en zpb_md_records.cube_dims_entry;
4713: m_column_en zpb_md_records.columns_entry;
4714: m_cube_hier_en zpb_md_records.cube_hier_entry;
4715: m_meas_en zpb_md_records.measures_entry;
4716:
4717: m_cube_id number;
4718: m_relation_id number;

Line 4715: m_meas_en zpb_md_records.measures_entry;

4711: m_table_en zpb_md_records.tables_entry;
4712: m_cube_dims_en zpb_md_records.cube_dims_entry;
4713: m_column_en zpb_md_records.columns_entry;
4714: m_cube_hier_en zpb_md_records.cube_hier_entry;
4715: m_meas_en zpb_md_records.measures_entry;
4716:
4717: m_cube_id number;
4718: m_relation_id number;
4719: m_meas_id number;

Line 4964: m_cube_en zpb_md_records.cubes_entry;

4960: nl varchar2(1) := fnd_global.local_chr(10);
4961: l_dim_ecm zpb_ecm.dimension_ecm;
4962:
4963: -- md table entries
4964: m_cube_en zpb_md_records.cubes_entry;
4965: m_table_en zpb_md_records.tables_entry;
4966: m_cube_dims_en zpb_md_records.cube_dims_entry;
4967: m_column_en zpb_md_records.columns_entry;
4968: m_cube_hier_en zpb_md_records.cube_hier_entry;

Line 4965: m_table_en zpb_md_records.tables_entry;

4961: l_dim_ecm zpb_ecm.dimension_ecm;
4962:
4963: -- md table entries
4964: m_cube_en zpb_md_records.cubes_entry;
4965: m_table_en zpb_md_records.tables_entry;
4966: m_cube_dims_en zpb_md_records.cube_dims_entry;
4967: m_column_en zpb_md_records.columns_entry;
4968: m_cube_hier_en zpb_md_records.cube_hier_entry;
4969: m_meas_en zpb_md_records.measures_entry;

Line 4966: m_cube_dims_en zpb_md_records.cube_dims_entry;

4962:
4963: -- md table entries
4964: m_cube_en zpb_md_records.cubes_entry;
4965: m_table_en zpb_md_records.tables_entry;
4966: m_cube_dims_en zpb_md_records.cube_dims_entry;
4967: m_column_en zpb_md_records.columns_entry;
4968: m_cube_hier_en zpb_md_records.cube_hier_entry;
4969: m_meas_en zpb_md_records.measures_entry;
4970:

Line 4967: m_column_en zpb_md_records.columns_entry;

4963: -- md table entries
4964: m_cube_en zpb_md_records.cubes_entry;
4965: m_table_en zpb_md_records.tables_entry;
4966: m_cube_dims_en zpb_md_records.cube_dims_entry;
4967: m_column_en zpb_md_records.columns_entry;
4968: m_cube_hier_en zpb_md_records.cube_hier_entry;
4969: m_meas_en zpb_md_records.measures_entry;
4970:
4971: m_cube_id number;

Line 4968: m_cube_hier_en zpb_md_records.cube_hier_entry;

4964: m_cube_en zpb_md_records.cubes_entry;
4965: m_table_en zpb_md_records.tables_entry;
4966: m_cube_dims_en zpb_md_records.cube_dims_entry;
4967: m_column_en zpb_md_records.columns_entry;
4968: m_cube_hier_en zpb_md_records.cube_hier_entry;
4969: m_meas_en zpb_md_records.measures_entry;
4970:
4971: m_cube_id number;
4972: m_relation_id number;

Line 4969: m_meas_en zpb_md_records.measures_entry;

4965: m_table_en zpb_md_records.tables_entry;
4966: m_cube_dims_en zpb_md_records.cube_dims_entry;
4967: m_column_en zpb_md_records.columns_entry;
4968: m_cube_hier_en zpb_md_records.cube_hier_entry;
4969: m_meas_en zpb_md_records.measures_entry;
4970:
4971: m_cube_id number;
4972: m_relation_id number;
4973: m_meas_id number;

Line 5405: l_hier_scope_en zpb_md_records.hier_scope_entry;

5401:
5402: l_dimension_id number;
5403:
5404: l_user_id number;
5405: l_hier_scope_en zpb_md_records.hier_scope_entry;
5406: l_hier_perscwm varchar2(60);
5407:
5408: l_hl_scope_en zpb_md_records.hier_level_scope_entry;
5409:

Line 5408: l_hl_scope_en zpb_md_records.hier_level_scope_entry;

5404: l_user_id number;
5405: l_hier_scope_en zpb_md_records.hier_scope_entry;
5406: l_hier_perscwm varchar2(60);
5407:
5408: l_hl_scope_en zpb_md_records.hier_level_scope_entry;
5409:
5410: l_level_perscwm varchar2(60);
5411: l_attr_perscwm varchar2(60);
5412:

Line 5415: l_attr_scope_en zpb_md_records.attribute_scope_entry;

5411: l_attr_perscwm varchar2(60);
5412:
5413: l_pers_hier_table_name varchar2(60);
5414:
5415: l_attr_scope_en zpb_md_records.attribute_scope_entry;
5416:
5417: l_dummy_num number;
5418:
5419: l_hr_pers_table_en zpb_md_records.tables_entry;

Line 5419: l_hr_pers_table_en zpb_md_records.tables_entry;

5415: l_attr_scope_en zpb_md_records.attribute_scope_entry;
5416:
5417: l_dummy_num number;
5418:
5419: l_hr_pers_table_en zpb_md_records.tables_entry;
5420: l_level_en zpb_md_records.levels_entry;
5421: l_pers_column_en zpb_md_records.columns_entry;
5422: l_level_tl_en zpb_md_records.levels_tl_entry;
5423: l_level_or_str varchar2(16);

Line 5420: l_level_en zpb_md_records.levels_entry;

5416:
5417: l_dummy_num number;
5418:
5419: l_hr_pers_table_en zpb_md_records.tables_entry;
5420: l_level_en zpb_md_records.levels_entry;
5421: l_pers_column_en zpb_md_records.columns_entry;
5422: l_level_tl_en zpb_md_records.levels_tl_entry;
5423: l_level_or_str varchar2(16);
5424:

Line 5421: l_pers_column_en zpb_md_records.columns_entry;

5417: l_dummy_num number;
5418:
5419: l_hr_pers_table_en zpb_md_records.tables_entry;
5420: l_level_en zpb_md_records.levels_entry;
5421: l_pers_column_en zpb_md_records.columns_entry;
5422: l_level_tl_en zpb_md_records.levels_tl_entry;
5423: l_level_or_str varchar2(16);
5424:
5425: l_start_time date;

Line 5422: l_level_tl_en zpb_md_records.levels_tl_entry;

5418:
5419: l_hr_pers_table_en zpb_md_records.tables_entry;
5420: l_level_en zpb_md_records.levels_entry;
5421: l_pers_column_en zpb_md_records.columns_entry;
5422: l_level_tl_en zpb_md_records.levels_tl_entry;
5423: l_level_or_str varchar2(16);
5424:
5425: l_start_time date;
5426: l_accessToAHier boolean;