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_STD_METADATA

Line 6: FUNCTION Get_Facts_To_Process(p_process_id IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact;

2: /* $Header: BSCBSRDS.pls 120.7 2006/01/12 13:56 arsantha noship $ */
3: Function is_parent_1N(p_child_level IN VARCHAR2, p_parent_level IN VARCHAR2 ) RETURN boolean ;
4: Function is_parent_MN(p_child_level IN VARCHAR2, p_parent_level IN VARCHAR2 ) RETURN boolean ;
5:
6: FUNCTION Get_Facts_To_Process(p_process_id IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact;
7: 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;
8: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity ;
9: Function get_dimensions_for_fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels IN boolean) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
10:

Line 7: 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;

3: Function is_parent_1N(p_child_level IN VARCHAR2, p_parent_level IN VARCHAR2 ) RETURN boolean ;
4: Function is_parent_MN(p_child_level IN VARCHAR2, p_parent_level IN VARCHAR2 ) RETURN boolean ;
5:
6: FUNCTION Get_Facts_To_Process(p_process_id IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact;
7: 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;
8: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity ;
9: Function get_dimensions_for_fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels IN boolean) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
10:
11:

Line 8: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity ;

4: Function is_parent_MN(p_child_level IN VARCHAR2, p_parent_level IN VARCHAR2 ) RETURN boolean ;
5:
6: FUNCTION Get_Facts_To_Process(p_process_id IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact;
7: 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;
8: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity ;
9: Function get_dimensions_for_fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels IN boolean) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
10:
11:
12: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

Line 9: Function get_dimensions_for_fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels IN boolean) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;

5:
6: FUNCTION Get_Facts_To_Process(p_process_id IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact;
7: 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;
8: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity ;
9: Function get_dimensions_for_fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels IN boolean) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
10:
11:
12: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
13: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

Line 12: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

8: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity ;
9: Function get_dimensions_for_fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels IN boolean) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
10:
11:
12: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
13: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
14: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel;
15: Function get_dim_sets_for_fact(p_fact VARCHAR2) return DBMS_SQL.NUMBER_TABLE;
16:

Line 13: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

9: Function get_dimensions_for_fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels IN boolean) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
10:
11:
12: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
13: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
14: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel;
15: Function get_dim_sets_for_fact(p_fact VARCHAR2) return DBMS_SQL.NUMBER_TABLE;
16:
17: function get_s_views(p_fact IN VARCHAR2,p_dim_set IN NUMBER)return dbms_sql.varchar2_table;

Line 14: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel;

10:
11:
12: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
13: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
14: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel;
15: Function get_dim_sets_for_fact(p_fact VARCHAR2) return DBMS_SQL.NUMBER_TABLE;
16:
17: function get_s_views(p_fact IN VARCHAR2,p_dim_set IN NUMBER)return dbms_sql.varchar2_table;
18: function get_levels_for_table(p_table_name varchar2,p_table_type VARCHAR2) return BSC_DBGEN_STD_METADATA.tab_clsLevel ;

Line 18: function get_levels_for_table(p_table_name varchar2,p_table_type VARCHAR2) return BSC_DBGEN_STD_METADATA.tab_clsLevel ;

14: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel;
15: Function get_dim_sets_for_fact(p_fact VARCHAR2) return DBMS_SQL.NUMBER_TABLE;
16:
17: function get_s_views(p_fact IN VARCHAR2,p_dim_set IN NUMBER)return dbms_sql.varchar2_table;
18: function get_levels_for_table(p_table_name varchar2,p_table_type VARCHAR2) return BSC_DBGEN_STD_METADATA.tab_clsLevel ;
19:
20: function get_b_table_measures_for_fact(p_fact varchar2,p_dim_set varchar2,p_base_table varchar2, p_include_derived_columns boolean) return BSC_DBGEN_STD_METADATA.tab_clsMeasure ;
21:
22: function get_periodicity_for_table(p_table varchar2) return NUMBER ;

Line 20: function get_b_table_measures_for_fact(p_fact varchar2,p_dim_set varchar2,p_base_table varchar2, p_include_derived_columns boolean) return BSC_DBGEN_STD_METADATA.tab_clsMeasure ;

16:
17: function get_s_views(p_fact IN VARCHAR2,p_dim_set IN NUMBER)return dbms_sql.varchar2_table;
18: function get_levels_for_table(p_table_name varchar2,p_table_type VARCHAR2) return BSC_DBGEN_STD_METADATA.tab_clsLevel ;
19:
20: function get_b_table_measures_for_fact(p_fact varchar2,p_dim_set varchar2,p_base_table varchar2, p_include_derived_columns boolean) return BSC_DBGEN_STD_METADATA.tab_clsMeasure ;
21:
22: function get_periodicity_for_table(p_table varchar2) return NUMBER ;
23: function get_db_calendar_column(p_calendar_id number,p_periodicity_id number) return varchar2;
24:

Line 25: function get_zero_code_levels(p_fact varchar2, p_dim_set varchar2) return BSC_DBGEN_STD_METADATA.tab_clsLevel;

21:
22: function get_periodicity_for_table(p_table varchar2) return NUMBER ;
23: function get_db_calendar_column(p_calendar_id number,p_periodicity_id number) return varchar2;
24:
25: function get_zero_code_levels(p_fact varchar2, p_dim_set varchar2) return BSC_DBGEN_STD_METADATA.tab_clsLevel;
26:
27: function get_base_tables_for_dim_set(p_fact varchar2,p_dim_set in number,p_targets in boolean) return dbms_sql.varchar2_table;
28: function get_facts_for_levels(p_levels dbms_sql.varchar2_table) return BSC_DBGEN_STD_METADATA.tab_clsFact;
29: function get_filter_for_dim_level(p_fact varchar2, p_level varchar2) return varchar2 ;

Line 28: function get_facts_for_levels(p_levels dbms_sql.varchar2_table) return BSC_DBGEN_STD_METADATA.tab_clsFact;

24:
25: function get_zero_code_levels(p_fact varchar2, p_dim_set varchar2) return BSC_DBGEN_STD_METADATA.tab_clsLevel;
26:
27: function get_base_tables_for_dim_set(p_fact varchar2,p_dim_set in number,p_targets in boolean) return dbms_sql.varchar2_table;
28: function get_facts_for_levels(p_levels dbms_sql.varchar2_table) return BSC_DBGEN_STD_METADATA.tab_clsFact;
29: function get_filter_for_dim_level(p_fact varchar2, p_level varchar2) return varchar2 ;
30: function get_current_period_for_fact(p_fact varchar2, p_periodicity number) return number ;
31: function get_current_year_for_fact(p_fact varchar2) return number ;
32:

Line 47: function get_parents_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

43: function get_fact_implementation_type(p_fact in varchar2) return varchar2;
44:
45: --- Added 08/08/2005 as this is reqd by Venu to track dim level changes
46: function is_level_used_by_aw_fact(p_level_name in varchar2) return boolean;
47: function get_parents_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
48: function get_children_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
49:
50:
51: 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;

Line 48: function get_children_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

44:
45: --- Added 08/08/2005 as this is reqd by Venu to track dim level changes
46: function is_level_used_by_aw_fact(p_level_name in varchar2) return boolean;
47: function get_parents_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
48: function get_children_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
49:
50:
51: 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;
52:

Line 61: ) return BSC_DBGEN_STD_METADATA.tab_clsColumnMaps;

57: p_fact in varchar2,
58: p_dim_set in number,
59: p_b_table_name in varchar2,
60: p_col_type in varchar2
61: ) return BSC_DBGEN_STD_METADATA.tab_clsColumnMaps;
62:
63: procedure set_table_property(p_table_name in varchar2, p_property_name in varchar2, p_property_value in varchar2);
64:
65: g_initialized boolean :=false;