1 Package BSC_DBGEN_BSC_READER AS
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
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 ;
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
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
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 function get_z_s_views(p_fact IN VARCHAR2, p_dim_set IN NUMBER) return dbms_sql.varchar2_table;
36 Function get_all_levels_for_fact(p_fact IN VARCHAR2) RETURN DBMS_SQL.VARCHAR2_TABLE ;
37 function get_dimension_level_short_name(p_dim_level_table_name IN VARCHAR2) return VARCHAR2;
38
39 function get_measures_for_short_names(p_short_names in dbms_sql.varchar2_table) return dbms_sql.varchar2_table;
40
41 function get_dim_levels_for_short_names(p_short_names in dbms_sql.varchar2_table) return dbms_sql.varchar2_table;
42
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;
52
53
54 function get_last_update_date_for_fact(p_fact in varchar2) return date;
55
56 function get_fact_cols_from_b_table(
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;
66
67
68
69
70 --added Jan 12, 2006 for Venu
71 function get_current_period_for_table( p_table_name varchar2) return number ;
72 function get_current_year_for_table(p_table_name varchar2) return number ;
73
74 END BSC_DBGEN_BSC_READER ;
[Home] [Help]