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_METADATA_READER dependencies on BSC_DBGEN_BSC_READER

Line 66: l_facts := BSC_DBGEN_BSC_READER.Get_Facts_To_Process(p_process_id);

62: l_facts BSC_DBGEN_STD_METADATA.tab_clsFact ;
63: l_fact_tmp BSC_DBGEN_STD_METADATA.tab_clsFact ;
64: BEGIN
65:
66: l_facts := BSC_DBGEN_BSC_READER.Get_Facts_To_Process(p_process_id);
67: --l_fact_tmp := BSC_DB_AK_READER.Get_Facts_To_Process(p_process_id);
68: FOR i IN l_fact_tmp.first..l_fact_tmp.last LOOP
69: l_facts(l_facts.count) := l_fact_tmp(i);
70: END LOOP;

Line 79: return BSC_DBGEN_BSC_READER.Get_Measures_For_Fact(p_fact, p_dim_set, p_include_derived_columns);

75:
76: FUNCTION Get_Measures_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_derived_columns IN BOOLEAN default false) return BSC_DBGEN_STD_METADATA.tab_clsMeasure IS
77: BEGIN
78: --IF (g_metadata_source = BSC_DBGEN_STD_METADATA.BSC) THEN
79: return BSC_DBGEN_BSC_READER.Get_Measures_For_Fact(p_fact, p_dim_set, p_include_derived_columns);
80: --ELSE
81: -- return BSC_DB_AK_READER.Get_Measures_For_Fact(p_fact, p_dim_set);
82: -- END IF;
83:

Line 104: return BSC_DBGEN_BSC_READER.Get_Periodicities_For_Fact(p_fact);

100:
101: BEGIN
102:
103: -- IF (g_metadata_source = BSC_DBGEN_STD_METADATA.BSC) THEN
104: return BSC_DBGEN_BSC_READER.Get_Periodicities_For_Fact(p_fact);
105: --ELSE
106: --return BSC_DB_AK_READER.Get_Periodicities_For_Fact(p_fact);
107: --END IF;
108:

Line 135: return BSC_DBGEN_BSC_READER.get_dimensions_for_fact(p_fact, p_dim_set, p_include_missing_levels);

131:
132: BEGIN
133:
134: --IF (g_metadata_source = BSC_DBGEN_STD_METADATA.BSC) THEN
135: return BSC_DBGEN_BSC_READER.get_dimensions_for_fact(p_fact, p_dim_set, p_include_missing_levels);
136: --ELSE
137: --return BSC_DB_AK_READER.get_dimensions_for_fact(p_fact, p_dim_set);
138: --END IF;
139: EXCEPTION WHEN OTHERS THEN

Line 176: return BSC_DBGEN_BSC_READER.get_parents_for_level(p_level_name, p_num_levels);

172: ) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship is
173:
174:
175: Begin
176: return BSC_DBGEN_BSC_READER.get_parents_for_level(p_level_name, p_num_levels);
177: Exception when others then
178: raise;
179: End;
180:

Line 193: return BSC_DBGEN_BSC_READER.get_children_for_level(p_level_name, p_num_levels);

189: ) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship is
190:
191:
192: Begin
193: return BSC_DBGEN_BSC_READER.get_children_for_level(p_level_name, p_num_levels);
194: Exception when others then
195: raise;
196: End;
197:

Line 220: return BSC_DBGEN_BSC_READER.get_level_info(p_level);

216:
217: l_level BSC_DBGEN_STD_METADATA.clsLevel ;
218:
219: Begin
220: return BSC_DBGEN_BSC_READER.get_level_info(p_level);
221: Exception when others then
222: raise;
223: End;
224:

Line 238: l_facts := BSC_DBGEN_BSC_READER.get_facts_for_levels(p_levels);

234:
235: l_facts BSC_DBGEN_STD_METADATA.tab_clsFact ;
236: l_fact_tmp BSC_DBGEN_STD_METADATA.tab_clsFact;
237: Begin
238: l_facts := BSC_DBGEN_BSC_READER.get_facts_for_levels(p_levels);
239: --dbms_output.put_line('Chk1');
240: --l_fact_tmp := BSC_DB_AK_READER.get_kpis_for_levels;
241: /*FOR i IN l_fact_tmp.first..l_fact_tmp.last LOOP
242: l_facts(l_facts.count) := l_fact_tmp(i);

Line 400: l_dim_sets := BSC_DBGEN_BSC_READER.get_dim_sets_for_fact(to_number(p_fact));

396:
397: l_dim_sets dbms_sql.number_table;
398: Begin
399: --IF get_fact_source(to_number(p_kpi)) = BSC_DBGEN_STD_METADATA.BSC THEN
400: l_dim_sets := BSC_DBGEN_BSC_READER.get_dim_sets_for_fact(to_number(p_fact));
401: --ELSE -- AK report
402: --l_dim_sets(1) := 0;
403: --END IF;
404: return l_dim_sets;

Line 535: return BSC_DBGEN_BSC_READER.get_filter_for_dim_level(p_fact, p_level);

531: p_level varchar2) return varchar2 is
532:
533:
534: Begin
535: return BSC_DBGEN_BSC_READER.get_filter_for_dim_level(p_fact, p_level);
536: Exception when others then
537: raise;
538: End;
539:

Line 553: return BSC_DBGEN_BSC_READER.get_s_views(p_fact, p_dim_set);

549: return dbms_sql.varchar2_table is
550:
551:
552: Begin
553: return BSC_DBGEN_BSC_READER.get_s_views(p_fact, p_dim_set);
554: Exception when others then
555: raise;
556: End;
557:

Line 599: return BSC_DBGEN_BSC_READER.get_levels_for_table(p_table_name, l_table_type);

595: Begin
596: IF (p_table_name like 'BSC%MV') THEN
597: l_table_type := 'MV';
598: END IF;
599: return BSC_DBGEN_BSC_READER.get_levels_for_table(p_table_name, l_table_type);
600: Exception when others then
601: raise;
602: End;
603:

Line 623: return BSC_DBGEN_BSC_READER.get_b_table_measures_for_fact(p_fact, p_dim_set, p_base_table, p_include_derived_columns);

619: return BSC_DBGEN_STD_METADATA.tab_clsMeasure IS
620:
621:
622: Begin
623: return BSC_DBGEN_BSC_READER.get_b_table_measures_for_fact(p_fact, p_dim_set, p_base_table, p_include_derived_columns);
624: Exception when others then
625: raise;
626: End;
627:

Line 662: return BSC_DBGEN_BSC_READER.get_periodicity_for_table(p_table);

658: p_table varchar2) return NUMBER is
659:
660:
661: Begin
662: return BSC_DBGEN_BSC_READER.get_periodicity_for_table(p_table);
663: Exception when others then
664: raise;
665: End;
666:

Line 680: return BSC_DBGEN_BSC_READER.get_db_calendar_column(p_calendar_id, p_periodicity_id);

676: p_periodicity_id number) return varchar2 is
677:
678:
679: Begin
680: return BSC_DBGEN_BSC_READER.get_db_calendar_column(p_calendar_id, p_periodicity_id);
681: Exception when others then
682: raise;
683: End;
684:

Line 696: return BSC_DBGEN_BSC_READER.get_zero_code_levels(p_fact, p_dim_set) ;

692: p_dim_set varchar2) return BSC_DBGEN_STD_METADATA.tab_clsLevel is
693:
694:
695: Begin
696: return BSC_DBGEN_BSC_READER.get_zero_code_levels(p_fact, p_dim_set) ;
697: Exception when others then
698: raise;
699: End;
700:

Line 713: return BSC_DBGEN_BSC_READER.get_base_tables_for_dim_set(to_number(p_fact), to_number(p_dim_set), p_targets);

709: p_targets in boolean) return dbms_sql.varchar2_table is
710:
711:
712: Begin
713: return BSC_DBGEN_BSC_READER.get_base_tables_for_dim_set(to_number(p_fact), to_number(p_dim_set), p_targets);
714: Exception when others then
715: raise;
716: End;
717:

Line 743: return BSC_DBGEN_BSC_READER.get_current_period_for_fact(p_fact, p_periodicity);

739: p_periodicity number) return number is
740:
741:
742: Begin
743: return BSC_DBGEN_BSC_READER.get_current_period_for_fact(p_fact, p_periodicity);
744: Exception when others then
745: raise;
746: End;
747:

Line 752: return BSC_DBGEN_BSC_READER.get_current_year_for_fact(p_fact);

748:
749: function get_current_year_for_fact(
750: p_fact varchar2) return number is
751: Begin
752: return BSC_DBGEN_BSC_READER.get_current_year_for_fact(p_fact);
753: Exception when others then
754: raise;
755: End;
756:

Line 764: return BSC_DBGEN_BSC_READER.is_projection_enabled_for_kpi(p_kpi);

760: function is_projection_enabled_for_kpi(
761: p_kpi in varchar2
762: ) return varchar2 is
763: Begin
764: return BSC_DBGEN_BSC_READER.is_projection_enabled_for_kpi(p_kpi);
765: Exception when others then
766: raise;
767: End;
768:

Line 776: return BSC_DBGEN_BSC_READER.get_all_facts_in_aw;

772: function get_all_facts_in_aw return dbms_sql.varchar2_table is
773:
774:
775: Begin
776: return BSC_DBGEN_BSC_READER.get_all_facts_in_aw;
777: Exception when others then
778: raise;
779: End;
780: --get the ZMV for a kpi and dimset

Line 793: return BSC_DBGEN_BSC_READER.get_z_s_views(p_fact, p_dim_set);

789: return dbms_sql.varchar2_table is
790:
791:
792: Begin
793: return BSC_DBGEN_BSC_READER.get_z_s_views(p_fact, p_dim_set);
794: Exception when others then
795: raise;
796: End;
797:

Line 816: return BSC_DBGEN_BSC_READER.get_all_levels_for_fact(p_fact);

812: Function get_all_levels_for_fact(p_fact IN VARCHAR2)
813: RETURN DBMS_SQL.VARCHAR2_TABLE IS
814:
815: BEGIN
816: return BSC_DBGEN_BSC_READER.get_all_levels_for_fact(p_fact);
817: END;
818:
819:
820: function get_dimension_level_short_name(p_dim_level_table_name IN VARCHAR2) return VARCHAR2

Line 823: return BSC_DBGEN_BSC_READER.get_dimension_level_short_name(p_dim_level_table_name);

819:
820: function get_dimension_level_short_name(p_dim_level_table_name IN VARCHAR2) return VARCHAR2
821: IS
822: BEGIN
823: return BSC_DBGEN_BSC_READER.get_dimension_level_short_name(p_dim_level_table_name);
824: END;
825:
826: function get_measures_for_short_names(p_short_names in dbms_sql.varchar2_table) return dbms_sql.varchar2_table is
827: begin

Line 828: return BSC_DBGEN_BSC_READER.get_measures_for_short_names(p_short_names);

824: END;
825:
826: function get_measures_for_short_names(p_short_names in dbms_sql.varchar2_table) return dbms_sql.varchar2_table is
827: begin
828: return BSC_DBGEN_BSC_READER.get_measures_for_short_names(p_short_names);
829: end;
830:
831: function get_dim_levels_for_short_names(p_short_names in dbms_sql.varchar2_table) return dbms_sql.varchar2_table is
832: begin

Line 833: return BSC_DBGEN_BSC_READER.get_dim_levels_for_short_names(p_short_names);

829: end;
830:
831: function get_dim_levels_for_short_names(p_short_names in dbms_sql.varchar2_table) return dbms_sql.varchar2_table is
832: begin
833: return BSC_DBGEN_BSC_READER.get_dim_levels_for_short_names(p_short_names);
834: end;
835:
836: function get_fact_implementation_type(p_fact in varchar2) return varchar2 is
837: begin

Line 838: return BSC_DBGEN_BSC_READER.get_fact_implementation_type(p_fact);

834: end;
835:
836: function get_fact_implementation_type(p_fact in varchar2) return varchar2 is
837: begin
838: return BSC_DBGEN_BSC_READER.get_fact_implementation_type(p_fact);
839: end;
840:
841:
842: function is_level_used_by_aw_fact(p_level_name in varchar2) return boolean is

Line 844: return bsc_dbgen_bsc_reader.is_level_used_by_aw_fact(p_level_name);

840:
841:
842: function is_level_used_by_aw_fact(p_level_name in varchar2) return boolean is
843: begin
844: return bsc_dbgen_bsc_reader.is_level_used_by_aw_fact(p_level_name);
845: end;
846:
847: -- reqd by venu to identify dim level changes
848: -- will return only the children used by facts implemented as AW

Line 851: return bsc_dbgen_bsc_reader.get_parents_for_level_aw(p_level_name, p_num_levels);

847: -- reqd by venu to identify dim level changes
848: -- will return only the children used by facts implemented as AW
849: function get_parents_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship is
850: begin
851: return bsc_dbgen_bsc_reader.get_parents_for_level_aw(p_level_name, p_num_levels);
852: end;
853:
854: -- reqd by venu to identify dim level changes
855: -- will return only the children used by facts implemented as AW

Line 858: return bsc_dbgen_bsc_reader.get_children_for_level_aw(p_level_name, p_num_levels);

854: -- reqd by venu to identify dim level changes
855: -- will return only the children used by facts implemented as AW
856: function get_children_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship is
857: begin
858: return bsc_dbgen_bsc_reader.get_children_for_level_aw(p_level_name, p_num_levels);
859: end;
860:
861:
862: procedure mark_facts_in_process(p_facts in dbms_sql.varchar2_table) is

Line 872: return bsc_dbgen_bsc_reader.get_target_per_for_b_table(p_fact, p_dim_set, p_b_table);

868: end;
869:
870: function get_target_per_for_b_table(p_fact in varchar2, p_dim_set in number, p_b_table in varchar2) return dbms_sql.varchar2_table is
871: begin
872: return bsc_dbgen_bsc_reader.get_target_per_for_b_table(p_fact, p_dim_set, p_b_table);
873:
874: end;
875:
876:

Line 1047: return bsc_dbgen_bsc_reader.get_last_update_date_for_fact(p_fact);

1043:
1044:
1045: function get_last_update_date_for_fact(p_fact in varchar2) return date is
1046: begin
1047: return bsc_dbgen_bsc_reader.get_last_update_date_for_fact(p_fact);
1048: end;
1049:
1050: function get_fact_cols_from_b_table(
1051: p_fact in varchar2,

Line 1058: return bsc_dbgen_bsc_reader.get_fact_cols_from_b_table(p_fact, p_dim_set, p_b_table_name, p_col_type);

1054: p_col_type in varchar2
1055: ) return BSC_DBGEN_STD_METADATA.tab_clsColumnMaps IS
1056: --BSC_DBGEN_STD_METADATA.tab_clsLevel
1057: Begin
1058: return bsc_dbgen_bsc_reader.get_fact_cols_from_b_table(p_fact, p_dim_set, p_b_table_name, p_col_type);
1059: Exception when others then
1060: raise;
1061: End;
1062:

Line 1066: bsc_dbgen_bsc_reader.set_table_property(p_table_name, p_property_name, p_property_value);

1062:
1063:
1064: procedure set_table_property(p_table_name in varchar2, p_property_name in varchar2, p_property_value in varchar2) is
1065: begin
1066: bsc_dbgen_bsc_reader.set_table_property(p_table_name, p_property_name, p_property_value);
1067: end;
1068:
1069:
1070: FUNCTION get_denorm_dimension_table(p_dim_short_name VARCHAR2) return VARCHAR2 IS

Line 1086: return bsc_dbgen_bsc_reader.get_current_period_for_table(p_table_name);

1082:
1083: --added Jan 12, 2006 for Venu
1084: function get_current_period_for_table( p_table_name varchar2) return number is
1085: begin
1086: return bsc_dbgen_bsc_reader.get_current_period_for_table(p_table_name);
1087: end;
1088:
1089:
1090: function get_current_year_for_table(p_table_name varchar2) return number is

Line 1092: return bsc_dbgen_bsc_reader.get_current_year_for_table(p_table_name);

1088:
1089:
1090: function get_current_year_for_table(p_table_name varchar2) return number is
1091: begin
1092: return bsc_dbgen_bsc_reader.get_current_year_for_table(p_table_name);
1093: end;
1094:
1095: END BSC_DBGEN_METADATA_READER;