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_METADATA dependencies on DBMS_SQL

Line 85: p_kpi out nocopy dbms_sql.varchar2_table,

81: returns kpi that references any of the levels.(not necessarily all levels)
82: */
83: procedure get_kpi_for_dim(
84: p_levels varchar2,
85: p_kpi out nocopy dbms_sql.varchar2_table,
86: p_dimset out nocopy dbms_sql.varchar2_table
87: ) is
88: --
89: l_facts BSC_DBGEN_STD_METADATA.tab_clsFact;

Line 86: p_dimset out nocopy dbms_sql.varchar2_table

82: */
83: procedure get_kpi_for_dim(
84: p_levels varchar2,
85: p_kpi out nocopy dbms_sql.varchar2_table,
86: p_dimset out nocopy dbms_sql.varchar2_table
87: ) is
88: --
89: l_facts BSC_DBGEN_STD_METADATA.tab_clsFact;
90: l_levels dbms_sql.varchar2_table;

Line 90: l_levels dbms_sql.varchar2_table;

86: p_dimset out nocopy dbms_sql.varchar2_table
87: ) is
88: --
89: l_facts BSC_DBGEN_STD_METADATA.tab_clsFact;
90: l_levels dbms_sql.varchar2_table;
91: l_all_kpis dbms_sql.varchar2_table;
92: Begin
93: l_levels(1):=p_levels;
94: l_facts:=bsc_dbgen_metadata_reader.get_facts_for_levels(l_levels);

Line 91: l_all_kpis dbms_sql.varchar2_table;

87: ) is
88: --
89: l_facts BSC_DBGEN_STD_METADATA.tab_clsFact;
90: l_levels dbms_sql.varchar2_table;
91: l_all_kpis dbms_sql.varchar2_table;
92: Begin
93: l_levels(1):=p_levels;
94: l_facts:=bsc_dbgen_metadata_reader.get_facts_for_levels(l_levels);
95: --now, match these with the facts implemented in aw

Line 111: p_kpi_list dbms_sql.varchar2_table,

107: raise;
108: End;
109:
110: procedure get_dims_for_kpis(
111: p_kpi_list dbms_sql.varchar2_table,
112: p_dim_list out nocopy dbms_sql.varchar2_table
113: ) is
114: --
115: l_dimensions dbms_sql.varchar2_table;

Line 112: p_dim_list out nocopy dbms_sql.varchar2_table

108: End;
109:
110: procedure get_dims_for_kpis(
111: p_kpi_list dbms_sql.varchar2_table,
112: p_dim_list out nocopy dbms_sql.varchar2_table
113: ) is
114: --
115: l_dimensions dbms_sql.varchar2_table;
116: Begin

Line 115: l_dimensions dbms_sql.varchar2_table;

111: p_kpi_list dbms_sql.varchar2_table,
112: p_dim_list out nocopy dbms_sql.varchar2_table
113: ) is
114: --
115: l_dimensions dbms_sql.varchar2_table;
116: Begin
117: for i in 1..p_kpi_list.count loop
118: l_dimensions.delete;
119: l_dimensions:=bsc_dbgen_metadata_reader.get_all_levels_for_fact(p_kpi_list(i));

Line 156: p_level_list dbms_sql.varchar2_table,

152: called only for NON REC dim
153: DBI dim are single level dim. we should modify this api to handle multi level dim
154: */
155: procedure get_dim_data_source(
156: p_level_list dbms_sql.varchar2_table,
157: p_level_pk_col out nocopy dbms_sql.varchar2_table,
158: p_data_source out nocopy varchar2,
159: p_inc_data_source out nocopy varchar2
160: ) is

Line 157: p_level_pk_col out nocopy dbms_sql.varchar2_table,

153: DBI dim are single level dim. we should modify this api to handle multi level dim
154: */
155: procedure get_dim_data_source(
156: p_level_list dbms_sql.varchar2_table,
157: p_level_pk_col out nocopy dbms_sql.varchar2_table,
158: p_data_source out nocopy varchar2,
159: p_inc_data_source out nocopy varchar2
160: ) is
161: --

Line 236: p_kpi_list out nocopy dbms_sql.varchar2_table) is

232: End;
233:
234: procedure get_kpi_for_calendar(
235: p_calendar_id number,
236: p_kpi_list out nocopy dbms_sql.varchar2_table) is
237: --
238: l_kpi_list dbms_sql.number_table;
239: Begin
240: l_kpi_list:=bsc_dbgen_metadata_reader.get_fact_ids_for_calendar(p_calendar_id);

Line 238: l_kpi_list dbms_sql.number_table;

234: procedure get_kpi_for_calendar(
235: p_calendar_id number,
236: p_kpi_list out nocopy dbms_sql.varchar2_table) is
237: --
238: l_kpi_list dbms_sql.number_table;
239: Begin
240: l_kpi_list:=bsc_dbgen_metadata_reader.get_fact_ids_for_calendar(p_calendar_id);
241: for i in 1..l_kpi_list.count loop
242: p_kpi_list(i):=l_kpi_list(i);

Line 261: p_dim_set out nocopy dbms_sql.varchar2_table

257: End;
258:
259: procedure get_kpi_dim_sets(
260: p_kpi varchar2,
261: p_dim_set out nocopy dbms_sql.varchar2_table
262: ) is
263: --
264: l_dim_set dbms_sql.number_table;
265: Begin

Line 264: l_dim_set dbms_sql.number_table;

260: p_kpi varchar2,
261: p_dim_set out nocopy dbms_sql.varchar2_table
262: ) is
263: --
264: l_dim_set dbms_sql.number_table;
265: Begin
266: l_dim_set:=bsc_dbgen_metadata_reader.get_dim_sets_for_fact(p_kpi);
267: for i in 1..l_dim_set.count loop
268: p_dim_set(i):=l_dim_set(i);

Line 292: p_dim_level out nocopy dbms_sql.varchar2_table,

288: */
289: procedure get_dim_set_dims(
290: p_kpi varchar2,
291: p_dim_set varchar2,
292: p_dim_level out nocopy dbms_sql.varchar2_table,
293: p_mo_dim_group out nocopy dbms_sql.varchar2_table,
294: p_skip_level out nocopy dbms_sql.varchar2_table
295: ) is
296: --

Line 293: p_mo_dim_group out nocopy dbms_sql.varchar2_table,

289: procedure get_dim_set_dims(
290: p_kpi varchar2,
291: p_dim_set varchar2,
292: p_dim_level out nocopy dbms_sql.varchar2_table,
293: p_mo_dim_group out nocopy dbms_sql.varchar2_table,
294: p_skip_level out nocopy dbms_sql.varchar2_table
295: ) is
296: --
297: l_dimension BSC_DBGEN_STD_METADATA.tab_clsDimension;

Line 294: p_skip_level out nocopy dbms_sql.varchar2_table

290: p_kpi varchar2,
291: p_dim_set varchar2,
292: p_dim_level out nocopy dbms_sql.varchar2_table,
293: p_mo_dim_group out nocopy dbms_sql.varchar2_table,
294: p_skip_level out nocopy dbms_sql.varchar2_table
295: ) is
296: --
297: l_dimension BSC_DBGEN_STD_METADATA.tab_clsDimension;
298: Begin

Line 336: p_measure out nocopy dbms_sql.varchar2_table,

332: */
333: procedure get_dim_set_measures(
334: p_kpi varchar2,
335: p_dim_set varchar2,
336: p_measure out nocopy dbms_sql.varchar2_table,
337: p_measure_type out nocopy dbms_sql.varchar2_table,
338: p_data_type out nocopy dbms_sql.varchar2_table,
339: p_agg_formula out nocopy dbms_sql.varchar2_table,
340: p_forecast out nocopy dbms_sql.varchar2_table,

Line 337: p_measure_type out nocopy dbms_sql.varchar2_table,

333: procedure get_dim_set_measures(
334: p_kpi varchar2,
335: p_dim_set varchar2,
336: p_measure out nocopy dbms_sql.varchar2_table,
337: p_measure_type out nocopy dbms_sql.varchar2_table,
338: p_data_type out nocopy dbms_sql.varchar2_table,
339: p_agg_formula out nocopy dbms_sql.varchar2_table,
340: p_forecast out nocopy dbms_sql.varchar2_table,
341: p_property out nocopy dbms_sql.varchar2_table

Line 338: p_data_type out nocopy dbms_sql.varchar2_table,

334: p_kpi varchar2,
335: p_dim_set varchar2,
336: p_measure out nocopy dbms_sql.varchar2_table,
337: p_measure_type out nocopy dbms_sql.varchar2_table,
338: p_data_type out nocopy dbms_sql.varchar2_table,
339: p_agg_formula out nocopy dbms_sql.varchar2_table,
340: p_forecast out nocopy dbms_sql.varchar2_table,
341: p_property out nocopy dbms_sql.varchar2_table
342: ) is

Line 339: p_agg_formula out nocopy dbms_sql.varchar2_table,

335: p_dim_set varchar2,
336: p_measure out nocopy dbms_sql.varchar2_table,
337: p_measure_type out nocopy dbms_sql.varchar2_table,
338: p_data_type out nocopy dbms_sql.varchar2_table,
339: p_agg_formula out nocopy dbms_sql.varchar2_table,
340: p_forecast out nocopy dbms_sql.varchar2_table,
341: p_property out nocopy dbms_sql.varchar2_table
342: ) is
343: --

Line 340: p_forecast out nocopy dbms_sql.varchar2_table,

336: p_measure out nocopy dbms_sql.varchar2_table,
337: p_measure_type out nocopy dbms_sql.varchar2_table,
338: p_data_type out nocopy dbms_sql.varchar2_table,
339: p_agg_formula out nocopy dbms_sql.varchar2_table,
340: p_forecast out nocopy dbms_sql.varchar2_table,
341: p_property out nocopy dbms_sql.varchar2_table
342: ) is
343: --
344: l_measures BSC_DBGEN_STD_METADATA.tab_clsMeasure;

Line 341: p_property out nocopy dbms_sql.varchar2_table

337: p_measure_type out nocopy dbms_sql.varchar2_table,
338: p_data_type out nocopy dbms_sql.varchar2_table,
339: p_agg_formula out nocopy dbms_sql.varchar2_table,
340: p_forecast out nocopy dbms_sql.varchar2_table,
341: p_property out nocopy dbms_sql.varchar2_table
342: ) is
343: --
344: l_measures BSC_DBGEN_STD_METADATA.tab_clsMeasure;
345: l_projection varchar2(200); --"0" means no projection. else projection

Line 406: p_dim_level out nocopy dbms_sql.varchar2_table) is

402: */
403: procedure get_target_levels(
404: p_kpi varchar2,
405: p_dim_set varchar2,
406: p_dim_level out nocopy dbms_sql.varchar2_table) is
407: --
408: l_dimension BSC_DBGEN_STD_METADATA.tab_clsDimension;
409: Begin
410: l_dimension:=bsc_dbgen_metadata_reader.get_dimensions_for_fact(p_kpi,to_number(p_dim_set),false);

Line 434: p_periodicities out nocopy dbms_sql.number_table

430: --qtr or month or maybe month+week
431: procedure get_target_periodicity(
432: p_kpi varchar2,
433: p_dim_set varchar2,
434: p_periodicities out nocopy dbms_sql.number_table
435: ) is
436: --
437: l_periodicity BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
438: l_flag boolean;

Line 490: p_filter out nocopy dbms_sql.varchar2_table) is

486: */
487: procedure get_dim_level_filter(
488: p_kpi varchar2,
489: p_level varchar2,
490: p_filter out nocopy dbms_sql.varchar2_table) is
491: --
492: l_filter varchar2(32000);
493: Begin
494: l_filter:=bsc_dbgen_metadata_reader.get_filter_for_dim_level(p_kpi,p_level);

Line 504: p_s_views out nocopy dbms_sql.varchar2_table) is

500:
501: procedure get_s_views(
502: p_kpi varchar2,
503: p_dim_set varchar2,
504: p_s_views out nocopy dbms_sql.varchar2_table) is
505: Begin
506: p_s_views:=bsc_dbgen_metadata_reader.get_s_views(p_kpi,to_number(p_dim_set));
507: Exception when others then
508: log_n('Exception in get_s_views '||sqlerrm);

Line 516: p_s_views out nocopy dbms_sql.varchar2_table) is

512: --get the z mvs
513: procedure get_z_s_views(
514: p_kpi varchar2,
515: p_dim_set varchar2,
516: p_s_views out nocopy dbms_sql.varchar2_table) is
517: Begin
518: --zero code mv
519: p_s_views:=bsc_dbgen_metadata_reader.get_z_s_views(p_kpi,to_number(p_dim_set));
520: Exception when others then

Line 527: p_levels out nocopy dbms_sql.varchar2_table) is

523: End;
524:
525: procedure get_s_view_levels(
526: p_s_view varchar2,
527: p_levels out nocopy dbms_sql.varchar2_table) is
528: --
529: l_levels BSC_DBGEN_STD_METADATA.tab_clsLevel;
530: Begin
531: l_levels:=bsc_dbgen_metadata_reader.get_levels_for_table(p_s_view);

Line 561: p_bt_levels out nocopy dbms_sql.varchar2_table,

557: procedure get_base_table_levels(
558: p_kpi varchar2,
559: p_dim_set varchar2,
560: p_base_table varchar2,
561: p_bt_levels out nocopy dbms_sql.varchar2_table,
562: p_bt_level_fks out nocopy dbms_sql.varchar2_table,
563: p_bt_level_pks out nocopy dbms_sql.varchar2_table,
564: p_bt_feed_level out nocopy dbms_sql.varchar2_table
565: ) is

Line 562: p_bt_level_fks out nocopy dbms_sql.varchar2_table,

558: p_kpi varchar2,
559: p_dim_set varchar2,
560: p_base_table varchar2,
561: p_bt_levels out nocopy dbms_sql.varchar2_table,
562: p_bt_level_fks out nocopy dbms_sql.varchar2_table,
563: p_bt_level_pks out nocopy dbms_sql.varchar2_table,
564: p_bt_feed_level out nocopy dbms_sql.varchar2_table
565: ) is
566: --

Line 563: p_bt_level_pks out nocopy dbms_sql.varchar2_table,

559: p_dim_set varchar2,
560: p_base_table varchar2,
561: p_bt_levels out nocopy dbms_sql.varchar2_table,
562: p_bt_level_fks out nocopy dbms_sql.varchar2_table,
563: p_bt_level_pks out nocopy dbms_sql.varchar2_table,
564: p_bt_feed_level out nocopy dbms_sql.varchar2_table
565: ) is
566: --
567: l_levels BSC_DBGEN_STD_METADATA.tab_clsLevel;

Line 564: p_bt_feed_level out nocopy dbms_sql.varchar2_table

560: p_base_table varchar2,
561: p_bt_levels out nocopy dbms_sql.varchar2_table,
562: p_bt_level_fks out nocopy dbms_sql.varchar2_table,
563: p_bt_level_pks out nocopy dbms_sql.varchar2_table,
564: p_bt_feed_level out nocopy dbms_sql.varchar2_table
565: ) is
566: --
567: l_levels BSC_DBGEN_STD_METADATA.tab_clsLevel;
568: l_map BSC_DBGEN_STD_METADATA.tab_clsColumnMaps;

Line 598: p_measures out nocopy dbms_sql.varchar2_table,

594: procedure get_base_table_measures(
595: p_kpi varchar2,
596: p_dim_set varchar2,
597: p_base_table varchar2,
598: p_measures out nocopy dbms_sql.varchar2_table,
599: p_bt_formula out nocopy dbms_sql.varchar2_table) is
600: --
601: l_measures BSC_DBGEN_STD_METADATA.tab_clsMeasure;
602: Begin

Line 599: p_bt_formula out nocopy dbms_sql.varchar2_table) is

595: p_kpi varchar2,
596: p_dim_set varchar2,
597: p_base_table varchar2,
598: p_measures out nocopy dbms_sql.varchar2_table,
599: p_bt_formula out nocopy dbms_sql.varchar2_table) is
600: --
601: l_measures BSC_DBGEN_STD_METADATA.tab_clsMeasure;
602: Begin
603: l_measures:=bsc_dbgen_metadata_reader.get_b_table_measures_for_fact(p_kpi,p_dim_set,p_base_table,true);

Line 621: p_periodicity out nocopy dbms_sql.number_table

617: */
618: procedure get_kpi_periodicities(
619: p_kpi varchar2,
620: p_dim_set varchar2,
621: p_periodicity out nocopy dbms_sql.number_table
622: ) is
623: --
624: l_periodicity BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
625: Begin

Line 686: p_levels out nocopy dbms_sql.varchar2_table) is

682:
683: procedure get_zero_code_levels(
684: p_kpi varchar2,
685: p_dim_set varchar2,
686: p_levels out nocopy dbms_sql.varchar2_table) is
687: --
688: l_levels BSC_DBGEN_STD_METADATA.tab_clsLevel;
689: Begin
690: l_levels:=bsc_dbgen_metadata_reader.get_zero_code_levels(p_kpi,p_dim_set);

Line 702: p_base_tables out nocopy dbms_sql.varchar2_table) is

698:
699: procedure get_dim_set_base_tables(
700: p_kpi varchar2,
701: p_dim_set varchar2,
702: p_base_tables out nocopy dbms_sql.varchar2_table) is
703: Begin
704: p_base_tables:=bsc_dbgen_metadata_reader.get_base_tables_for_dim_set(p_kpi,p_dim_set,false);--false is for "p_targets in boolean"
705: Exception when others then
706: log_n('Exception in get_dim_set_base_tables '||sqlerrm);

Line 713: p_base_tables out nocopy dbms_sql.varchar2_table) is

709:
710: procedure get_dim_set_target_base_tables(
711: p_kpi varchar2,
712: p_dim_set varchar2,
713: p_base_tables out nocopy dbms_sql.varchar2_table) is
714: Begin
715: p_base_tables:=bsc_dbgen_metadata_reader.get_base_tables_for_dim_set(p_kpi,p_dim_set,true);--true is for "p_targets in boolean"
716: Exception when others then
717: log_n('Exception in get_dim_set_target_base_tables '||sqlerrm);

Line 744: procedure get_all_kpi_in_aw(p_kpi_list out nocopy dbms_sql.varchar2_table) is

740:
741: /*
742: returns all the kpi that have been implemented in AW
743: */
744: procedure get_all_kpi_in_aw(p_kpi_list out nocopy dbms_sql.varchar2_table) is
745: Begin
746: p_kpi_list:=bsc_dbgen_metadata_reader.get_all_facts_in_aw;
747: Exception when others then
748: log_n('Exception in get_all_kpi_in_aw '||sqlerrm);

Line 770: p_short_name dbms_sql.varchar2_table,

766: so we decided to do the lookup for them.
767: get_measures_for_short_names and get_dim_levels_for_short_names
768: */
769: procedure get_measures_for_short_names(
770: p_short_name dbms_sql.varchar2_table,
771: p_measure_name out nocopy dbms_sql.varchar2_table
772: ) is
773: Begin
774: p_measure_name:=BSC_DBGEN_METADATA_READER.get_measures_for_short_names(p_short_name);

Line 771: p_measure_name out nocopy dbms_sql.varchar2_table

767: get_measures_for_short_names and get_dim_levels_for_short_names
768: */
769: procedure get_measures_for_short_names(
770: p_short_name dbms_sql.varchar2_table,
771: p_measure_name out nocopy dbms_sql.varchar2_table
772: ) is
773: Begin
774: p_measure_name:=BSC_DBGEN_METADATA_READER.get_measures_for_short_names(p_short_name);
775: Exception when others then

Line 781: p_short_name dbms_sql.varchar2_table,

777: raise;
778: End;
779:
780: procedure get_dim_levels_for_short_names(
781: p_short_name dbms_sql.varchar2_table,
782: p_dim_level_name out nocopy dbms_sql.varchar2_table
783: ) is
784: Begin
785: p_dim_level_name:=BSC_DBGEN_METADATA_READER.get_dim_levels_for_short_names(p_short_name);

Line 782: p_dim_level_name out nocopy dbms_sql.varchar2_table

778: End;
779:
780: procedure get_dim_levels_for_short_names(
781: p_short_name dbms_sql.varchar2_table,
782: p_dim_level_name out nocopy dbms_sql.varchar2_table
783: ) is
784: Begin
785: p_dim_level_name:=BSC_DBGEN_METADATA_READER.get_dim_levels_for_short_names(p_short_name);
786: Exception when others then

Line 799: procedure get_B_table_feed_periodicity(p_kpi varchar2,p_dim_set varchar2,p_base_table varchar2,p_feed_periodicity out nocopy dbms_sql.number_table) is

795: log_n('Exception in is_level_used_by_aw_kpi '||sqlerrm);
796: raise;
797: End;
798:
799: procedure get_B_table_feed_periodicity(p_kpi varchar2,p_dim_set varchar2,p_base_table varchar2,p_feed_periodicity out nocopy dbms_sql.number_table) is
800: l_periodicity dbms_sql.varchar2_table;
801: Begin
802: l_periodicity:=BSC_DBGEN_METADATA_READER.get_target_per_for_b_table(p_kpi,to_number(p_dim_set),p_base_table);
803: for i in 1..l_periodicity.count loop

Line 800: l_periodicity dbms_sql.varchar2_table;

796: raise;
797: End;
798:
799: procedure get_B_table_feed_periodicity(p_kpi varchar2,p_dim_set varchar2,p_base_table varchar2,p_feed_periodicity out nocopy dbms_sql.number_table) is
800: l_periodicity dbms_sql.varchar2_table;
801: Begin
802: l_periodicity:=BSC_DBGEN_METADATA_READER.get_target_per_for_b_table(p_kpi,to_number(p_dim_set),p_base_table);
803: for i in 1..l_periodicity.count loop
804: p_feed_periodicity(i):=to_number(l_periodicity(i));