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 DBMS_SQL

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 14: function get_fact_ids_for_calendar(p_calendar_id number) return dbms_sql.number_table;

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 ;

Line 16: function get_dim_sets_for_fact(p_fact varchar2) return dbms_sql.number_table;

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 ;

Line 19: function get_s_views(p_fact IN VARCHAR2, p_dim_set IN NUMBER) return dbms_sql.varchar2_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 ;

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

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

Line 34: function get_all_facts_in_aw return dbms_sql.varchar2_table;

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:

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

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:

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

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;

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

Line 43: function get_dim_levels_for_short_names(p_short_names in dbms_sql.varchar2_table) return dbms_sql.varchar2_table;

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:

Line 53: procedure mark_facts_in_process(p_facts in dbms_sql.varchar2_table);

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:

Line 54: g_assume_production_facts dbms_sql.varchar2_table;

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;

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

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:

Line 61: function get_table_properties(p_table_name in VARCHAR2, p_property_list in dbms_sql.VARCHAR2_table) 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;