APPS.BSC_DBGEN_BSC_READER dependencies on DBMS_SQL

Line 15: Function get_dim_sets_for_fact(p_fact VARCHAR2) return DBMS_SQL.NUMBER_TABLE;

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:

Line 17: function get_s_views(p_fact IN VARCHAR2,p_dim_set IN NUMBER)return dbms_sql.varchar2_table;

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:

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

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 ;

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 34: function get_all_facts_in_aw return dbms_sql.varchar2_table;

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:

Line 35: function get_z_s_views(p_fact IN VARCHAR2, p_dim_set IN NUMBER) return dbms_sql.varchar2_table;

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;

Line 36: Function get_all_levels_for_fact(p_fact IN VARCHAR2) RETURN DBMS_SQL.VARCHAR2_TABLE ;

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:

Line 39: function get_measures_for_short_names(p_short_names in dbms_sql.varchar2_table) 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;

Line 41: function get_dim_levels_for_short_names(p_short_names in dbms_sql.varchar2_table) 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

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

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: