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 DUAL

Line 63: SELECT zpb_dimensions_seq.NEXTVAL INTO l_dimension_rec.DimensionId FROM DUAL;

59:
60:
61: exception
62: when NO_DATA_FOUND then
63: SELECT zpb_dimensions_seq.NEXTVAL INTO l_dimension_rec.DimensionId FROM DUAL;
64: insert_flag := true;
65: end;
66: end if;
67:

Line 167: SELECT zpb_tables_seq.NEXTVAL INTO l_table_rec.TableId FROM DUAL;

163: where table_id = l_table_rec.TableId;
164:
165: exception
166: when NO_DATA_FOUND then
167: SELECT zpb_tables_seq.NEXTVAL INTO l_table_rec.TableId FROM DUAL;
168: insert_flag := true;
169: end;
170: end if;
171:

Line 244: SELECT zpb_columns_seq.NEXTVAL INTO l_col_rec.ColumnId FROM DUAL;

240:
241:
242: exception
243: when NO_DATA_FOUND then
244: SELECT zpb_columns_seq.NEXTVAL INTO l_col_rec.ColumnId FROM DUAL;
245:
246: insert into zpb_columns
247: (
248: COLUMN_ID,

Line 315: SELECT zpb_levels_seq.NEXTVAL INTO l_level_rec.LevelId FROM DUAL;

311: where level_id = l_level_rec.LevelId;
312:
313: exception
314: when NO_DATA_FOUND then
315: SELECT zpb_levels_seq.NEXTVAL INTO l_level_rec.LevelId FROM DUAL;
316:
317: insert into zpb_levels
318: (
319: PERS_CWM_NAME,

Line 386: SELECT zpb_hier_level_seq.NEXTVAL INTO l_hier_level_rec.RelationId FROM DUAL;

382: where relation_id = l_hier_level_rec.RelationId;
383:
384: exception
385: when NO_DATA_FOUND then
386: SELECT zpb_hier_level_seq.NEXTVAL INTO l_hier_level_rec.RelationId FROM DUAL;
387:
388: insert into zpb_hier_level
389: (
390: HIER_ID,

Line 463: SELECT zpb_attributes_seq.NEXTVAL INTO l_attr_rec.AttributeId FROM DUAL;

459: where attribute_id = l_attr_rec.AttributeId;
460:
461: exception
462: when NO_DATA_FOUND then
463: SELECT zpb_attributes_seq.NEXTVAL INTO l_attr_rec.AttributeId FROM DUAL;
464:
465: insert into zpb_attributes
466: (
467:

Line 542: SELECT zpb_attr_table_col_seq.NEXTVAL INTO l_attr_table_col_rec.RelationId FROM DUAL;

538: where relation_id = l_attr_table_col_rec.RelationId;
539:
540: exception
541: when NO_DATA_FOUND then
542: SELECT zpb_attr_table_col_seq.NEXTVAL INTO l_attr_table_col_rec.RelationId FROM DUAL;
543:
544: insert into zpb_attr_table_col
545: (
546: ATTRIBUTE_ID,

Line 610: SELECT zpb_cube_dims_seq.NEXTVAL INTO l_cube_dims_rec.RelationId FROM DUAL;

606: where relation_id = l_cube_dims_rec.RelationId;
607:
608: exception
609: when NO_DATA_FOUND then
610: SELECT zpb_cube_dims_seq.NEXTVAL INTO l_cube_dims_rec.RelationId FROM DUAL;
611:
612: insert into zpb_cube_dims
613: (
614:

Line 678: SELECT zpb_cube_hier_seq.NEXTVAL INTO l_cube_hier_rec.RelationId FROM DUAL;

674: where relation_id = l_cube_hier_rec.RelationId;
675:
676: exception
677: when NO_DATA_FOUND then
678: SELECT zpb_cube_hier_seq.NEXTVAL INTO l_cube_hier_rec.RelationId FROM DUAL;
679:
680: insert into zpb_cube_hier
681: (
682: COLUMN_ID,

Line 759: SELECT zpb_measures_seq.NEXTVAL INTO l_measure_rec.MeasureId FROM DUAL;

755: where measure_id = l_measure_rec.MeasureId;
756:
757: exception
758: when NO_DATA_FOUND then
759: SELECT zpb_measures_seq.NEXTVAL INTO l_measure_rec.MeasureId FROM DUAL;
760:
761: -- dbms_output.put_line('INSERTING');
762:
763: insert into zpb_measures

Line 946: SELECT zpb_hierarchies_seq.NEXTVAL INTO l_hierarchies_rec.HierarchyId FROM DUAL;

942: where hierarchy_id = l_hierarchies_rec.HierarchyId;
943:
944: exception
945: when NO_DATA_FOUND then
946: SELECT zpb_hierarchies_seq.NEXTVAL INTO l_hierarchies_rec.HierarchyId FROM DUAL;
947:
948: insert into zpb_hierarchies
949: (
950: DIMENSION_ID,

Line 1212: SELECT zpb_cubes_seq.NEXTVAL INTO l_cube_rec.CubeId FROM DUAL;

1208: where cube_id = l_cube_rec.CubeId;
1209:
1210: exception
1211: when NO_DATA_FOUND then
1212: SELECT zpb_cubes_seq.NEXTVAL INTO l_cube_rec.CubeId FROM DUAL;
1213: insert_flag:=true;
1214: end;
1215:
1216: end if;

Line 1292: SELECT zpb_hier_scope_seq.NEXTVAL INTO l_hier_scope_rec.ScopeId FROM DUAL;

1288: where scope_id = l_hier_scope_rec.ScopeId;
1289:
1290: exception
1291: when NO_DATA_FOUND then
1292: SELECT zpb_hier_scope_seq.NEXTVAL INTO l_hier_scope_rec.ScopeId FROM DUAL;
1293:
1294: insert into zpb_hier_scope
1295: (
1296: END_DATE,

Line 1367: SELECT zpb_hier_level_scope_seq.NEXTVAL INTO l_hier_level_scope_rec.ScopeId FROM DUAL;

1363: where scope_id = l_hier_level_scope_rec.ScopeId;
1364:
1365: exception
1366: when NO_DATA_FOUND then
1367: SELECT zpb_hier_level_scope_seq.NEXTVAL INTO l_hier_level_scope_rec.ScopeId FROM DUAL;
1368:
1369: insert into zpb_hier_level_scope
1370: (
1371: LEVEL_ID,

Line 1439: SELECT zpb_attribute_scope_seq.NEXTVAL INTO l_attribute_scope_rec.ScopeId FROM DUAL;

1435: where scope_id = l_attribute_scope_rec.ScopeId;
1436:
1437: exception
1438: when NO_DATA_FOUND then
1439: SELECT zpb_attribute_scope_seq.NEXTVAL INTO l_attribute_scope_rec.ScopeId FROM DUAL;
1440:
1441: insert into zpb_attribute_scope
1442: (
1443: SCOPE_ID,

Line 1905: SELECT zpb_dimensions_seq.NEXTVAL INTO m_dimension_en.DimensionId FROM DUAL;

1901: m_dimension_exists := false;
1902:
1903: exception
1904: when NO_DATA_FOUND then
1905: SELECT zpb_dimensions_seq.NEXTVAL INTO m_dimension_en.DimensionId FROM DUAL;
1906: m_dimension_exists := true;
1907: end;
1908:
1909:

Line 2135: select sysdate into l_pp_hiert_start_time from dual;

2131: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view
2132: (p_aw, 'PERSONAL', l_dim, l_hier);
2133: m_hr_pers_table_en.AWName:= p_aw;
2134:
2135: select sysdate into l_pp_hiert_start_time from dual;
2136: else
2137: l_persLvl := false;
2138: end if;
2139:

Line 2163: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_shar_table_en.tableId FROM DUAL;

2159: m_shar_table_exists := false;
2160:
2161: exception
2162: when NO_DATA_FOUND then
2163: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_shar_table_en.tableId FROM DUAL;
2164:
2165: m_shar_table_exists := true;
2166: end;
2167:

Line 2191: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_pers_table_en.tableId FROM DUAL;

2187: m_pers_table_exists :=false;
2188:
2189: exception
2190: when NO_DATA_FOUND then
2191: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_pers_table_en.tableId FROM DUAL;
2192: m_pers_table_exists :=true;
2193: end;
2194:
2195: -- dbms_output.put_line('Hier Shar Table ID: ' || m_hr_shar_table_en.tableId );

Line 2677: -- SELECT zpb_dimensions_seq.NEXTVAL INTO m_attr_rangedim_en.DimensionId FROM DUAL;

2673: -- epb_id = m_attr_rangedim_en.EPBId;
2674:
2675: -- exception
2676: -- when NO_DATA_FOUND then
2677: -- SELECT zpb_dimensions_seq.NEXTVAL INTO m_attr_rangedim_en.DimensionId FROM DUAL;
2678: -- end;
2679:
2680: l_range_dim_data := zpb_ecm.get_dimension_data (m_attr_rangedim_en.EPBId, p_aw);
2681:

Line 4237: select sysdate into m_start_time from dual;

4233: -- dbms_output.put_line('Creating metadata map for '||p_aw);
4234:
4235: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
4236:
4237: select sysdate into m_start_time from dual;
4238:
4239: zpb_aw.execute ('aw attach '||zpb_aw.get_schema||'.'||p_aw||' first');
4240:
4241: l_gid := false;

Line 4734: UNION select 'CAL_PERIODS' from dual;

4730: select DIMENSION_NAME
4731: from ZPB_CYCLE_MODEL_DIMENSIONS
4732: where ANALYSIS_CYCLE_ID = p_instance and
4733: nvl(REMOVE_DIMENSION_FLAG, 'N') <> 'Y'
4734: UNION select 'CAL_PERIODS' from dual;
4735:
4736: bus_area_id_num number;
4737:
4738: begin

Line 5475: select sysdate into l_start_time from dual;

5471: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
5472:
5473: -- save start time. At the end we will remove all scoping entries that were
5474: -- created prior to this time, as they are no longer valid
5475: select sysdate into l_start_time from dual;
5476:
5477: l_user_id := to_number(sys_context('ZPB_CONTEXT', 'shadow_id'));
5478:
5479: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');