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;
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;
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 ;
26 function get_current_year_for_fact(p_fact varchar2) return number ;
27 /*
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;
37 Function get_all_levels_for_fact(p_fact IN VARCHAR2) RETURN DBMS_SQL.VARCHAR2_TABLE ;
38
39 function get_dimension_level_short_name(p_dim_level_table_name IN VARCHAR2) return VARCHAR2;
40
41 function get_measures_for_short_names(p_short_names in dbms_sql.varchar2_table) return dbms_sql.varchar2_table;
42
43 function get_dim_levels_for_short_names(p_short_names in dbms_sql.varchar2_table) return dbms_sql.varchar2_table;
44
45 function get_fact_implementation_type(p_fact varchar2) return varchar2;
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;
55
56 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;
57
58 function get_max_partitions return number;
59 function get_partition_clause return varchar2;
60
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);
70 g_initora_parameters tab_properties;
71 g_num_partitions number := -1;
72
73
74 function get_last_update_date_for_fact(p_fact in varchar2) return date;
75
76 g_bsc_schema varchar2(100);
77
78 function get_fact_cols_from_b_table(
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
88 FUNCTION get_denorm_dimension_table(p_dim_short_name VARCHAR2) return VARCHAR2 ;
89
90
91 --added Jan 12, 2006 for Venu
92 function get_current_period_for_table( p_table_name varchar2) return number ;
93 function get_current_year_for_table(p_table_name varchar2) return number ;
94
95 END BSC_DBGEN_METADATA_READER ;
[Home] [Help]