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 BSC_DBGEN_METADATA_READER

Line 15: l_tab_ClsLevelRelationship:=bsc_dbgen_metadata_reader.get_parents_for_level_aw(p_level,1);

11: ) is
12: --
13: l_tab_ClsLevelRelationship bsc_dbgen_std_metadata.tab_ClsLevelRelationship;
14: Begin
15: l_tab_ClsLevelRelationship:=bsc_dbgen_metadata_reader.get_parents_for_level_aw(p_level,1);
16: for i in 1..l_tab_ClsLevelRelationship.count loop
17: p_parents(i).parent_level:=l_tab_ClsLevelRelationship(i).parent_level;
18: p_parents(i).parent_pk:=l_tab_ClsLevelRelationship(i).parent_level_pk;
19: p_parents(i).child_level:=l_tab_ClsLevelRelationship(i).child_level;

Line 34: l_tab_ClsLevelRelationship:=bsc_dbgen_metadata_reader.get_children_for_level_aw(p_level,1);

30: ) is
31: --
32: l_tab_ClsLevelRelationship bsc_dbgen_std_metadata.tab_ClsLevelRelationship;
33: Begin
34: l_tab_ClsLevelRelationship:=bsc_dbgen_metadata_reader.get_children_for_level_aw(p_level,1);
35: for i in 1..l_tab_ClsLevelRelationship.count loop
36: p_children(i).parent_level:=l_tab_ClsLevelRelationship(i).parent_level;
37: p_children(i).parent_pk:=l_tab_ClsLevelRelationship(i).parent_level_pk;
38: p_children(i).child_level:=l_tab_ClsLevelRelationship(i).child_level;

Line 66: l_level:=bsc_dbgen_metadata_reader.get_level_info(p_level);

62: ) is
63: --
64: l_level BSC_DBGEN_STD_METADATA.clsLevel;
65: Begin
66: l_level:=bsc_dbgen_metadata_reader.get_level_info(p_level);
67: p_level_id:=l_level.level_id;
68: p_level_pk:=l_level.level_pk;
69: p_level_pk_datatype:=l_level.Level_PK_Datatype;--must be varchar2...
70: --for now, we hardcode p_level_pk_datatype to varchar2

Line 94: l_facts:=bsc_dbgen_metadata_reader.get_facts_for_levels(l_levels);

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
96: get_all_kpi_in_aw(l_all_kpis);
97: for i in 1..l_facts.count loop
98: if bsc_aw_utility.in_array(l_all_kpis,to_char(l_facts(i).fact_id)) then

Line 119: l_dimensions:=bsc_dbgen_metadata_reader.get_all_levels_for_fact(p_kpi_list(i));

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));
120: for j in 1..l_dimensions.count loop
121: if bsc_aw_utility.in_array(p_dim_list,l_dimensions(j))=false then
122: p_dim_list(p_dim_list.count+1):=l_dimensions(j);
123: end if;

Line 135: l_flag:=bsc_dbgen_metadata_reader.is_dim_recursive(p_dim_level);

131: function is_dim_recursive(p_dim_level varchar2) return varchar2 is
132: --
133: l_flag boolean;
134: Begin
135: l_flag:=bsc_dbgen_metadata_reader.is_dim_recursive(p_dim_level);
136: if l_flag then
137: return 'Y';
138: else
139: return 'N';

Line 240: l_kpi_list:=bsc_dbgen_metadata_reader.get_fact_ids_for_calendar(p_calendar_id);

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);
243: end loop;
244: Exception when others then

Line 253: p_calendar:=bsc_dbgen_metadata_reader.get_calendar_id_for_fact(p_kpi);

249: procedure get_kpi_calendar(
250: p_kpi varchar2,
251: p_calendar out nocopy number) is
252: Begin
253: p_calendar:=bsc_dbgen_metadata_reader.get_calendar_id_for_fact(p_kpi);
254: Exception when others then
255: log_n('Exception in get_kpi_calendar '||sqlerrm);
256: raise;
257: End;

Line 266: l_dim_set:=bsc_dbgen_metadata_reader.get_dim_sets_for_fact(p_kpi);

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);
269: end loop;
270: Exception when others then

Line 305: l_dimension:=bsc_dbgen_metadata_reader.get_dimensions_for_fact(p_kpi,to_number(p_dim_set),false);

301: when calling get_dimensions_for_fact, call with missing levels=false. not true. if called with true, in the case where
302: we have city and country as independent dim, MO will find state as missing level, group city,state and country into 1 dim
303: we will not know if city and country are independent dim or are related. so call with false. hardcode skip level to N
304: */
305: l_dimension:=bsc_dbgen_metadata_reader.get_dimensions_for_fact(p_kpi,to_number(p_dim_set),false);
306: --true is to include missing levels. so if the kpi has city and country, this api will also return state
307: --loop through hierarchies, levels are inside hierarchies
308: --there is only hier that arun is using. levels are in order of parent to child. so we reverse the order
309: for i in 1..l_dimension.count loop

Line 348: l_measures:=bsc_dbgen_metadata_reader.Get_Measures_For_Fact(p_kpi,to_number(p_dim_set),true);

344: l_measures BSC_DBGEN_STD_METADATA.tab_clsMeasure;
345: l_projection varchar2(200); --"0" means no projection. else projection
346: l_type varchar2(100);
347: Begin
348: l_measures:=bsc_dbgen_metadata_reader.Get_Measures_For_Fact(p_kpi,to_number(p_dim_set),true);
349: --true means return kpi measures+calculated internal measures
350: for i in 1..l_measures.count loop
351: p_measure(i):=l_measures(i).Measure_Name;
352: p_property(i):=null;

Line 388: l_flag:=bsc_dbgen_metadata_reader.is_target_at_higher_level(p_kpi,p_dim_set);

384: ) return varchar2 is
385: --
386: l_flag boolean;
387: Begin
388: l_flag:=bsc_dbgen_metadata_reader.is_target_at_higher_level(p_kpi,p_dim_set);
389: if l_flag then
390: return 'Y';
391: else
392: return 'N';

Line 410: l_dimension:=bsc_dbgen_metadata_reader.get_dimensions_for_fact(p_kpi,to_number(p_dim_set),false);

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);
411: for i in 1..l_dimension.count loop
412: for j in 1..l_dimension(i).Hierarchies.count loop
413: for k in reverse 1..l_dimension(i).Hierarchies(j).Levels.count loop
414: if bsc_dbgen_utils.get_property_value(l_dimension(i).Hierarchies(j).Levels(k).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then

Line 440: l_periodicity:=bsc_dbgen_metadata_reader.Get_Periodicities_For_Fact(p_kpi);

436: --
437: l_periodicity BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
438: l_flag boolean;
439: Begin
440: l_periodicity:=bsc_dbgen_metadata_reader.Get_Periodicities_For_Fact(p_kpi);
441: for i in 1..l_periodicity.count loop
442: --MO will give back all levels with targets. we need to scan and eliminate all periodicities that are not lowest
443: if bsc_dbgen_utils.get_property_value(l_periodicity(i).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then
444: --if l_periodicity(i).Parent_periods.count=0 then --this is the lowest level

Line 477: l_level:=bsc_dbgen_metadata_reader.get_level_info(p_level);

473: l_level_id number;
474: l_level BSC_DBGEN_STD_METADATA.clsLevel;
475: Begin
476: get_level_pk(p_level,l_level_id,p_pk,p_datatype,p_level_source);
477: l_level:=bsc_dbgen_metadata_reader.get_level_info(p_level);
478: p_fk:=l_level.LEVEL_FK;
479: Exception when others then
480: log_n('Exception in get_dim_level_properties '||sqlerrm);
481: raise;

Line 494: l_filter:=bsc_dbgen_metadata_reader.get_filter_for_dim_level(p_kpi,p_level);

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);
495: bsc_aw_utility.convert_varchar2_to_table(l_filter,3800,p_filter);
496: Exception when others then
497: log_n('Exception in get_dim_level_filter '||sqlerrm);
498: raise;

Line 506: p_s_views:=bsc_dbgen_metadata_reader.get_s_views(p_kpi,to_number(p_dim_set));

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);
509: raise;
510: End;

Line 519: p_s_views:=bsc_dbgen_metadata_reader.get_z_s_views(p_kpi,to_number(p_dim_set));

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
521: log_n('Exception in get_s_views '||sqlerrm);
522: raise;
523: End;

Line 531: l_levels:=bsc_dbgen_metadata_reader.get_levels_for_table(p_s_view);

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);
532: for i in 1..l_levels.count loop
533: p_levels(i):=l_levels(i).Level_Name;
534: end loop;
535: Exception when others then

Line 570: l_levels:=bsc_dbgen_metadata_reader.get_levels_for_table(p_base_table);

566: --
567: l_levels BSC_DBGEN_STD_METADATA.tab_clsLevel;
568: l_map BSC_DBGEN_STD_METADATA.tab_clsColumnMaps;
569: Begin
570: l_levels:=bsc_dbgen_metadata_reader.get_levels_for_table(p_base_table);
571: for i in 1..l_levels.count loop
572: p_bt_levels(i):=l_levels(i).level_name;
573: p_bt_level_fks(i):=l_levels(i).LEVEL_FK;
574: p_bt_level_pks(i):=l_levels(i).Level_PK;

Line 577: l_map:=bsc_dbgen_metadata_reader.get_fact_cols_from_b_table(p_kpi,to_number(p_dim_set),p_base_table,'KEYS');

573: p_bt_level_fks(i):=l_levels(i).LEVEL_FK;
574: p_bt_level_pks(i):=l_levels(i).Level_PK;
575: p_bt_feed_level(i):='N';
576: end loop;
577: l_map:=bsc_dbgen_metadata_reader.get_fact_cols_from_b_table(p_kpi,to_number(p_dim_set),p_base_table,'KEYS');
578: for i in 1..p_bt_levels.count loop
579: for j in 1..l_map.count loop
580: if p_bt_level_fks(i)=l_map(j).source_column_name then
581: p_bt_feed_level(i):='Y';

Line 603: l_measures:=bsc_dbgen_metadata_reader.get_b_table_measures_for_fact(p_kpi,p_dim_set,p_base_table,true);

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);
604: for i in 1..l_measures.count loop
605: p_measures(i):=l_measures(i).Measure_Name;
606: p_bt_formula(i):=bsc_dbgen_utils.get_property_value(l_measures(i).properties,BSC_DBGEN_STD_METADATA.SOURCE_FORMULA);
607: end loop;

Line 626: l_periodicity:=bsc_dbgen_metadata_reader.Get_Periodicities_For_Fact(p_kpi);

622: ) is
623: --
624: l_periodicity BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
625: Begin
626: l_periodicity:=bsc_dbgen_metadata_reader.Get_Periodicities_For_Fact(p_kpi);
627: for i in 1..l_periodicity.count loop
628: p_periodicity(i):=l_periodicity(i).Periodicity_id;
629: end loop;
630: Exception when others then

Line 639: p_periodicity:=bsc_dbgen_metadata_reader.get_periodicity_for_table(p_base_table);

635: procedure get_base_table_periodicity(
636: p_base_table varchar2,
637: p_periodicity out nocopy number) is
638: Begin
639: p_periodicity:=bsc_dbgen_metadata_reader.get_periodicity_for_table(p_base_table);
640: Exception when others then
641: log_n('Exception in get_base_table_periodicity '||sqlerrm);
642: raise;
643: End;

Line 652: p_prj_table:=BSC_DBGEN_METADATA_READER.get_table_properties(p_base_table,BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE);

648: p_partition out nocopy bsc_aw_utility.object_partition_r) is
649: --
650: l_partition_info BSC_DBGEN_STD_METADATA.clsTablePartition;
651: Begin
652: p_prj_table:=BSC_DBGEN_METADATA_READER.get_table_properties(p_base_table,BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE);
653: l_partition_info:=BSC_DBGEN_METADATA_READER.get_partition_info(p_base_table);
654: if l_partition_info.table_name is not null then
655: p_partition.main_partition.set_name:='main partition';
656: p_partition.main_partition.partition_type:=l_partition_info.partitioning_type;--HASH, RANGE, LIST

Line 653: l_partition_info:=BSC_DBGEN_METADATA_READER.get_partition_info(p_base_table);

649: --
650: l_partition_info BSC_DBGEN_STD_METADATA.clsTablePartition;
651: Begin
652: p_prj_table:=BSC_DBGEN_METADATA_READER.get_table_properties(p_base_table,BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE);
653: l_partition_info:=BSC_DBGEN_METADATA_READER.get_partition_info(p_base_table);
654: if l_partition_info.table_name is not null then
655: p_partition.main_partition.set_name:='main partition';
656: p_partition.main_partition.partition_type:=l_partition_info.partitioning_type;--HASH, RANGE, LIST
657: p_partition.main_partition.partition_column:=l_partition_info.partitioning_column;

Line 677: return bsc_dbgen_metadata_reader.get_db_calendar_column(p_calendar,p_periodicity);

673: function get_db_calendar_column(
674: p_calendar number,
675: p_periodicity number) return varchar2 is
676: Begin
677: return bsc_dbgen_metadata_reader.get_db_calendar_column(p_calendar,p_periodicity);
678: Exception when others then
679: log_n('Exception in get_db_calendar_column '||sqlerrm);
680: raise;
681: End;

Line 690: l_levels:=bsc_dbgen_metadata_reader.get_zero_code_levels(p_kpi,p_dim_set);

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);
691: for i in 1..l_levels.count loop
692: p_levels(i):=l_levels(i).level_name;
693: end loop;
694: Exception when others then

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

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);
707: raise;
708: End;

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

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);
718: raise;
719: End;

Line 733: --bsc_dbgen_metadata_reader.get_current_period_for_fact also takes care of missing periodicities

729: p_period out nocopy number,
730: p_year out nocopy number
731: ) is
732: Begin
733: --bsc_dbgen_metadata_reader.get_current_period_for_fact also takes care of missing periodicities
734: p_period:=bsc_dbgen_metadata_reader.get_current_period_for_fact(p_kpi,p_periodicity);
735: p_year:=bsc_dbgen_metadata_reader.get_current_year_for_fact(p_kpi);
736: Exception when others then
737: log_n('Exception in get_kpi_current_period '||sqlerrm);

Line 734: p_period:=bsc_dbgen_metadata_reader.get_current_period_for_fact(p_kpi,p_periodicity);

730: p_year out nocopy number
731: ) is
732: Begin
733: --bsc_dbgen_metadata_reader.get_current_period_for_fact also takes care of missing periodicities
734: p_period:=bsc_dbgen_metadata_reader.get_current_period_for_fact(p_kpi,p_periodicity);
735: p_year:=bsc_dbgen_metadata_reader.get_current_year_for_fact(p_kpi);
736: Exception when others then
737: log_n('Exception in get_kpi_current_period '||sqlerrm);
738: raise;

Line 735: p_year:=bsc_dbgen_metadata_reader.get_current_year_for_fact(p_kpi);

731: ) is
732: Begin
733: --bsc_dbgen_metadata_reader.get_current_period_for_fact also takes care of missing periodicities
734: p_period:=bsc_dbgen_metadata_reader.get_current_period_for_fact(p_kpi,p_periodicity);
735: p_year:=bsc_dbgen_metadata_reader.get_current_year_for_fact(p_kpi);
736: Exception when others then
737: log_n('Exception in get_kpi_current_period '||sqlerrm);
738: raise;
739: End;

Line 746: p_kpi_list:=bsc_dbgen_metadata_reader.get_all_facts_in_aw;

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);
749: raise;
750: End;

Line 757: return bsc_dbgen_metadata_reader.get_dimension_level_short_name(p_level_table_name);

753: given the level table name get the level short name
754: */
755: function get_level_short_name(p_level_table_name varchar2) return varchar2 is
756: Begin
757: return bsc_dbgen_metadata_reader.get_dimension_level_short_name(p_level_table_name);
758: Exception when others then
759: log_n('Exception in get_level_short_name '||sqlerrm);
760: raise;
761: End;

Line 774: p_measure_name:=BSC_DBGEN_METADATA_READER.get_measures_for_short_names(p_short_name);

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
776: log_n('Exception in get_measures_for_short_names '||sqlerrm);
777: raise;
778: End;

Line 785: p_dim_level_name:=BSC_DBGEN_METADATA_READER.get_dim_levels_for_short_names(p_short_name);

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
787: log_n('Exception in get_dim_levels_for_short_names '||sqlerrm);
788: raise;
789: End;

Line 793: return BSC_DBGEN_METADATA_READER.is_level_used_by_aw_fact(p_level);

789: End;
790:
791: function is_level_used_by_aw_kpi(p_level varchar2) return boolean is
792: Begin
793: return BSC_DBGEN_METADATA_READER.is_level_used_by_aw_fact(p_level);
794: Exception when others then
795: log_n('Exception in is_level_used_by_aw_kpi '||sqlerrm);
796: raise;
797: End;

Line 802: l_periodicity:=BSC_DBGEN_METADATA_READER.get_target_per_for_b_table(p_kpi,to_number(p_dim_set),p_base_table);

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));
805: end loop;
806: Exception when others then

Line 813: return BSC_DBGEN_METADATA_READER.get_last_update_date_for_fact(p_kpi);

809: End;
810:
811: function get_kpi_LUD(p_kpi varchar2) return date is
812: Begin
813: return BSC_DBGEN_METADATA_READER.get_last_update_date_for_fact(p_kpi);
814: Exception when others then
815: log_n('Exception in get_kpi_LUD '||sqlerrm);
816: raise;
817: End;

Line 821: p_period:=bsc_dbgen_metadata_reader.get_current_period_for_table(p_table);

817: End;
818:
819: procedure get_table_current_period(p_table varchar2,p_period out nocopy number,p_year out nocopy number) is
820: Begin
821: p_period:=bsc_dbgen_metadata_reader.get_current_period_for_table(p_table);
822: p_year:=bsc_dbgen_metadata_reader.get_current_year_for_table(p_table);
823: Exception when others then
824: log_n('Exception in get_table_current_period '||sqlerrm);
825: raise;

Line 822: p_year:=bsc_dbgen_metadata_reader.get_current_year_for_table(p_table);

818:
819: procedure get_table_current_period(p_table varchar2,p_period out nocopy number,p_year out nocopy number) is
820: Begin
821: p_period:=bsc_dbgen_metadata_reader.get_current_period_for_table(p_table);
822: p_year:=bsc_dbgen_metadata_reader.get_current_year_for_table(p_table);
823: Exception when others then
824: log_n('Exception in get_table_current_period '||sqlerrm);
825: raise;
826: End;