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_STD_METADATA

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

1: Package BSC_DBGEN_METADATA_READER AS
2: /* $Header: BSCMDRDS.pls 120.12 2006/01/12 13:56 arsantha noship $ */
3: PROCEDURE Initialize(p_metadata_source IN VARCHAR2) ;
4: FUNCTION Get_Facts_To_Process(p_process_id IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact ;
5: 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;
6: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
7: Function Get_Dimensions_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels in boolean default false) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
8: gRecDims bsc_varchar2_table_type;

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

1: Package BSC_DBGEN_METADATA_READER AS
2: /* $Header: BSCMDRDS.pls 120.12 2006/01/12 13:56 arsantha noship $ */
3: PROCEDURE Initialize(p_metadata_source IN VARCHAR2) ;
4: FUNCTION Get_Facts_To_Process(p_process_id IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact ;
5: 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;
6: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
7: Function Get_Dimensions_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels in boolean default false) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
8: gRecDims bsc_varchar2_table_type;
9: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

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

2: /* $Header: BSCMDRDS.pls 120.12 2006/01/12 13:56 arsantha noship $ */
3: PROCEDURE Initialize(p_metadata_source IN VARCHAR2) ;
4: FUNCTION Get_Facts_To_Process(p_process_id IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact ;
5: 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;
6: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
7: Function Get_Dimensions_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels in boolean default false) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
8: gRecDims bsc_varchar2_table_type;
9: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
10: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

Line 7: Function Get_Dimensions_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels in boolean default false) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;

3: PROCEDURE Initialize(p_metadata_source IN VARCHAR2) ;
4: FUNCTION Get_Facts_To_Process(p_process_id IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact ;
5: 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;
6: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
7: Function Get_Dimensions_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels in boolean default false) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
8: gRecDims bsc_varchar2_table_type;
9: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
10: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
11: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel ;

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

5: 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;
6: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
7: Function Get_Dimensions_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels in boolean default false) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
8: gRecDims bsc_varchar2_table_type;
9: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
10: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
11: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel ;
12: function get_facts_for_levels(p_levels dbms_sql.varchar2_table) return BSC_DBGEN_STD_METADATA.tab_clsFact;
13: function is_dim_recursive(p_dim_level varchar2) return boolean ;

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

6: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
7: Function Get_Dimensions_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels in boolean default false) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
8: gRecDims bsc_varchar2_table_type;
9: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
10: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
11: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel ;
12: function get_facts_for_levels(p_levels dbms_sql.varchar2_table) return BSC_DBGEN_STD_METADATA.tab_clsFact;
13: function is_dim_recursive(p_dim_level varchar2) return boolean ;
14: function get_fact_ids_for_calendar(p_calendar_id number) return dbms_sql.number_table;

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

7: Function Get_Dimensions_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_missing_levels in boolean default false) RETURN BSC_DBGEN_STD_METADATA.tab_clsDimension;
8: gRecDims bsc_varchar2_table_type;
9: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
10: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
11: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel ;
12: function get_facts_for_levels(p_levels dbms_sql.varchar2_table) return BSC_DBGEN_STD_METADATA.tab_clsFact;
13: function is_dim_recursive(p_dim_level varchar2) return boolean ;
14: function get_fact_ids_for_calendar(p_calendar_id number) return dbms_sql.number_table;
15: function get_calendar_id_for_fact(p_fact varchar2) return number ;

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

8: gRecDims bsc_varchar2_table_type;
9: function get_parents_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
10: function get_children_for_level(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
11: function get_level_info(p_level varchar2) return BSC_DBGEN_STD_METADATA.clsLevel ;
12: function get_facts_for_levels(p_levels dbms_sql.varchar2_table) return BSC_DBGEN_STD_METADATA.tab_clsFact;
13: function is_dim_recursive(p_dim_level varchar2) return boolean ;
14: function get_fact_ids_for_calendar(p_calendar_id number) return dbms_sql.number_table;
15: function get_calendar_id_for_fact(p_fact varchar2) return number ;
16: function get_dim_sets_for_fact(p_fact varchar2) return dbms_sql.number_table;

Line 20: function get_levels_for_table(p_table_name varchar2) return BSC_DBGEN_STD_METADATA.tab_clsLevel ;

16: function get_dim_sets_for_fact(p_fact varchar2) return dbms_sql.number_table;
17: function is_target_at_higher_level(p_fact varchar2, p_dim_set varchar2) return boolean;
18: function get_filter_for_dim_level(p_fact varchar2, p_level varchar2) return varchar2 ;
19: function get_s_views(p_fact IN VARCHAR2, p_dim_set IN NUMBER) return dbms_sql.varchar2_table;
20: function get_levels_for_table(p_table_name varchar2) return BSC_DBGEN_STD_METADATA.tab_clsLevel ;
21: 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 ;
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: function get_base_tables_for_dim_set(p_fact in varchar2, p_dim_set in varchar2, p_targets in boolean) return dbms_sql.varchar2_table;

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

17: function is_target_at_higher_level(p_fact varchar2, p_dim_set varchar2) return boolean;
18: function get_filter_for_dim_level(p_fact varchar2, p_level varchar2) return varchar2 ;
19: function get_s_views(p_fact IN VARCHAR2, p_dim_set IN NUMBER) return dbms_sql.varchar2_table;
20: function get_levels_for_table(p_table_name varchar2) return BSC_DBGEN_STD_METADATA.tab_clsLevel ;
21: 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 ;
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: function get_base_tables_for_dim_set(p_fact in varchar2, p_dim_set in varchar2, p_targets in boolean) return dbms_sql.varchar2_table;
25: function get_current_period_for_fact(p_fact varchar2, p_periodicity number) return number ;

Line 32: p_dim_set varchar2) return BSC_DBGEN_STD_METADATA.tab_clsLevel;

28: returns all the kpi that have been implemented in AW
29: */
30: function get_zero_code_levels(
31: p_fact varchar2,
32: p_dim_set varchar2) return BSC_DBGEN_STD_METADATA.tab_clsLevel;
33: function is_projection_enabled_for_kpi(p_kpi in varchar2) return varchar2;
34: function get_all_facts_in_aw return dbms_sql.varchar2_table;
35:
36: function get_z_s_views(p_fact IN VARCHAR2, p_dim_set IN NUMBER) return dbms_sql.varchar2_table;

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

46:
47:
48: --- Added 08/08/2005 as this is reqd by Venu to track dim level changes
49: function is_level_used_by_aw_fact(p_level_name in varchar2) return boolean;
50: function get_parents_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
51: function get_children_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
52:
53: procedure mark_facts_in_process(p_facts in dbms_sql.varchar2_table);
54: g_assume_production_facts dbms_sql.varchar2_table;

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

47:
48: --- Added 08/08/2005 as this is reqd by Venu to track dim level changes
49: function is_level_used_by_aw_fact(p_level_name in varchar2) return boolean;
50: function get_parents_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
51: function get_children_for_level_aw(p_level_name varchar2, p_num_levels number default 1000000) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
52:
53: procedure mark_facts_in_process(p_facts in dbms_sql.varchar2_table);
54: g_assume_production_facts dbms_sql.varchar2_table;
55:

Line 65: function get_partition_info(p_table_name in varchar2) return BSC_DBGEN_STD_METADATA.clsTablePartition;

61: function get_table_properties(p_table_name in VARCHAR2, p_property_list in dbms_sql.VARCHAR2_table) return dbms_sql.VARCHAR2_table ;
62: function get_table_properties(p_table_name in VARCHAR2, p_property varchar2) return varchar2;
63:
64:
65: function get_partition_info(p_table_name in varchar2) return BSC_DBGEN_STD_METADATA.clsTablePartition;
66:
67: TYPE rec_properties IS RECORD (
68: value varchar2(4000));
69: TYPE tab_properties is table of rec_properties index by varchar2(300);

Line 83: ) return BSC_DBGEN_STD_METADATA.tab_clsColumnMaps;

79: p_fact in varchar2,
80: p_dim_set in number,
81: p_b_table_name in varchar2,
82: p_col_type in varchar2
83: ) return BSC_DBGEN_STD_METADATA.tab_clsColumnMaps;
84:
85: procedure set_table_property(p_table_name in varchar2, p_property_name in varchar2, p_property_value in varchar2);
86:
87: