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.BSC_DBGEN_BSC_READER dependencies on BSC_DBGEN_METADATA_READER

Line 2386: l_dim_sets := bsc_dbgen_metadata_reader.get_dim_sets_for_fact(p_kpi);

2382: l_dim_sets dbms_sql.number_table;
2383: l_measures BSC_DBGEN_STD_METADATA.tab_clsMeasure;
2384: l_properties BSC_DBGEN_STD_METADATA.tab_ClsProperties;
2385: Begin
2386: l_dim_sets := bsc_dbgen_metadata_reader.get_dim_sets_for_fact(p_kpi);
2387: --DBMS_OUTPUT.PUT_LINE('L_DIM_SETS.COUNT = '||TO_CHAR(l_dim_sets.count));
2388: IF (l_dim_sets.count > 0) THEN
2389: FOR i IN l_dim_sets.first..l_dim_sets.last LOOP
2390: l_measures := bsc_dbgen_metadata_reader.get_measures_for_fact(p_kpi, l_dim_sets(i));

Line 2390: l_measures := bsc_dbgen_metadata_reader.get_measures_for_fact(p_kpi, l_dim_sets(i));

2386: l_dim_sets := bsc_dbgen_metadata_reader.get_dim_sets_for_fact(p_kpi);
2387: --DBMS_OUTPUT.PUT_LINE('L_DIM_SETS.COUNT = '||TO_CHAR(l_dim_sets.count));
2388: IF (l_dim_sets.count > 0) THEN
2389: FOR i IN l_dim_sets.first..l_dim_sets.last LOOP
2390: l_measures := bsc_dbgen_metadata_reader.get_measures_for_fact(p_kpi, l_dim_sets(i));
2391: IF (l_measures.count > 0) THEN
2392: FOR j IN l_measures.first..l_measures.last LOOP
2393: l_properties := l_measures(j).Properties;
2394: IF (bsc_dbgen_utils.get_property_value(l_properties, BSC_DBGEN_STD_METADATA.PROJECTION_ID) <> '0') THEN

Line 2632: --dbms_output.put_line('assume count='||BSC_DBGEN_METADATA_READER.g_assume_production_facts.count);

2628: begin
2629: if is_level_used_by_prod_aw_fact(p_level_name) then
2630: return true;
2631: end if;
2632: --dbms_output.put_line('assume count='||BSC_DBGEN_METADATA_READER.g_assume_production_facts.count);
2633:
2634: -- Not used by any production facts, now check if any processing facts have it
2635: -- This memory variable is populated by GDB during process time
2636: IF (BSC_DBGEN_METADATA_READER.g_assume_production_facts.count=0) THEN

Line 2636: IF (BSC_DBGEN_METADATA_READER.g_assume_production_facts.count=0) THEN

2632: --dbms_output.put_line('assume count='||BSC_DBGEN_METADATA_READER.g_assume_production_facts.count);
2633:
2634: -- Not used by any production facts, now check if any processing facts have it
2635: -- This memory variable is populated by GDB during process time
2636: IF (BSC_DBGEN_METADATA_READER.g_assume_production_facts.count=0) THEN
2637: return false;
2638: END IF;
2639: -- now see if objectives being processed have these levels
2640: l_session_id := userenv('SESSIONID');

Line 2642: FORALL i in 1..BSC_DBGEN_METADATA_READER.g_assume_production_facts.count

2638: END IF;
2639: -- now see if objectives being processed have these levels
2640: l_session_id := userenv('SESSIONID');
2641: delete bsc_tmp_big_in_cond where session_id=l_session_id and variable_id=1;
2642: FORALL i in 1..BSC_DBGEN_METADATA_READER.g_assume_production_facts.count
2643: insert into bsc_tmp_big_in_cond (session_id, variable_id, value_n) values (l_session_id, 1,
2644: to_number(BSC_DBGEN_METADATA_READER.g_assume_production_facts(i)));
2645:
2646: select count(1) into l_count

Line 2644: to_number(BSC_DBGEN_METADATA_READER.g_assume_production_facts(i)));

2640: l_session_id := userenv('SESSIONID');
2641: delete bsc_tmp_big_in_cond where session_id=l_session_id and variable_id=1;
2642: FORALL i in 1..BSC_DBGEN_METADATA_READER.g_assume_production_facts.count
2643: insert into bsc_tmp_big_in_cond (session_id, variable_id, value_n) values (l_session_id, 1,
2644: to_number(BSC_DBGEN_METADATA_READER.g_assume_production_facts(i)));
2645:
2646: select count(1) into l_count
2647: from bsc_kpi_dim_levels_b lvl,
2648: bsc_kpi_properties prop,