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_AW_ADAPTER_KPI dependencies on BSC_AW_CALENDAR

Line 249: p_dim_set.calendar.aw_dim:=bsc_aw_calendar.get_calendar_name(p_dim_set.calendar.calendar);

245: Begin
246: p_dim_set.calendar.calendar:=p_kpi.calendar;
247: bsc_aw_bsc_metadata.get_dim_set_calendar(p_kpi.kpi,p_dim_set);
248: --give the aw dim names
249: p_dim_set.calendar.aw_dim:=bsc_aw_calendar.get_calendar_name(p_dim_set.calendar.calendar);
250: --set the relation name, periodicity aw name
251: bsc_aw_md_api.get_dim_set_calendar(p_kpi,p_dim_set);
252: --now, get the missing periodicity, and mark lowest level
253: get_missing_periodicity(p_kpi,p_dim_set);

Line 4765: bsc_aw_calendar.get_missing_periodicity(p_dim_set.calendar.aw_dim,l_periodicity_dim,l_lowest_level);

4761: for i in 1..p_dim_set.calendar.periodicity.count loop
4762: l_periodicity_dim(l_periodicity_dim.count+1):=p_dim_set.calendar.periodicity(i).aw_dim;
4763: end loop;
4764: --
4765: bsc_aw_calendar.get_missing_periodicity(p_dim_set.calendar.aw_dim,l_periodicity_dim,l_lowest_level);
4766: --
4767: for i in 1..l_periodicity_dim.count loop
4768: l_flag:=false;
4769: for j in 1..p_dim_set.calendar.periodicity.count loop

Line 6168: l_calendar bsc_aw_calendar.calendar_r;

6164: /*we can have multiple levels at which partitons are defined. example month and week
6165: each DS can be at one periodicity only*/
6166: procedure set_DS_hpt_rollup_data(p_calendar calendar_r,p_DS_calendar calendar_r,p_hpt_data hpt_data_r,p_data_source in out nocopy data_source_r) is
6167: l_index number;
6168: l_calendar bsc_aw_calendar.calendar_r;
6169: l_ds_periodicity bsc_aw_calendar.periodicity_r;
6170: l_upper_periodicities bsc_aw_calendar.periodicity_tb;
6171: Begin
6172: p_data_source.data_source_PT.partition_template.hpt_data.hpt_calendar.dim_name:=null;

Line 6169: l_ds_periodicity bsc_aw_calendar.periodicity_r;

6165: each DS can be at one periodicity only*/
6166: procedure set_DS_hpt_rollup_data(p_calendar calendar_r,p_DS_calendar calendar_r,p_hpt_data hpt_data_r,p_data_source in out nocopy data_source_r) is
6167: l_index number;
6168: l_calendar bsc_aw_calendar.calendar_r;
6169: l_ds_periodicity bsc_aw_calendar.periodicity_r;
6170: l_upper_periodicities bsc_aw_calendar.periodicity_tb;
6171: Begin
6172: p_data_source.data_source_PT.partition_template.hpt_data.hpt_calendar.dim_name:=null;
6173: p_data_source.data_source_PT.partition_template.hpt_data.hpt_calendar.level_names.delete;

Line 6170: l_upper_periodicities bsc_aw_calendar.periodicity_tb;

6166: procedure set_DS_hpt_rollup_data(p_calendar calendar_r,p_DS_calendar calendar_r,p_hpt_data hpt_data_r,p_data_source in out nocopy data_source_r) is
6167: l_index number;
6168: l_calendar bsc_aw_calendar.calendar_r;
6169: l_ds_periodicity bsc_aw_calendar.periodicity_r;
6170: l_upper_periodicities bsc_aw_calendar.periodicity_tb;
6171: Begin
6172: p_data_source.data_source_PT.partition_template.hpt_data.hpt_calendar.dim_name:=null;
6173: p_data_source.data_source_PT.partition_template.hpt_data.hpt_calendar.level_names.delete;
6174: p_data_source.data_source_PT.partition_template.hpt_data.hpt_calendar.level_keys.delete;

Line 6189: bsc_aw_calendar.get_calendar(p_DS_calendar.aw_dim,l_calendar);

6185: p_hpt_data.hpt_calendar.level_keys(l_index);
6186: else /*rollup required */
6187: /*find out the upper periodicities that DS periodicity touches */
6188: /*upgrade(to level 3) must reimplement all calendars so db_column_name is populated in bsc olap metadata */
6189: bsc_aw_calendar.get_calendar(p_DS_calendar.aw_dim,l_calendar);
6190: l_ds_periodicity:=bsc_aw_calendar.get_periodicity_r(p_DS_calendar.periodicity(1).periodicity,l_calendar.periodicity);
6191: bsc_aw_calendar.get_all_upper_periodicities(l_ds_periodicity,l_calendar,l_upper_periodicities);
6192: for j in 1..p_hpt_data.hpt_calendar.level_names.count loop
6193: for k in 1..l_upper_periodicities.count loop

Line 6190: l_ds_periodicity:=bsc_aw_calendar.get_periodicity_r(p_DS_calendar.periodicity(1).periodicity,l_calendar.periodicity);

6186: else /*rollup required */
6187: /*find out the upper periodicities that DS periodicity touches */
6188: /*upgrade(to level 3) must reimplement all calendars so db_column_name is populated in bsc olap metadata */
6189: bsc_aw_calendar.get_calendar(p_DS_calendar.aw_dim,l_calendar);
6190: l_ds_periodicity:=bsc_aw_calendar.get_periodicity_r(p_DS_calendar.periodicity(1).periodicity,l_calendar.periodicity);
6191: bsc_aw_calendar.get_all_upper_periodicities(l_ds_periodicity,l_calendar,l_upper_periodicities);
6192: for j in 1..p_hpt_data.hpt_calendar.level_names.count loop
6193: for k in 1..l_upper_periodicities.count loop
6194: if p_hpt_data.hpt_calendar.level_names(j)=l_upper_periodicities(k).dim_name then

Line 6191: bsc_aw_calendar.get_all_upper_periodicities(l_ds_periodicity,l_calendar,l_upper_periodicities);

6187: /*find out the upper periodicities that DS periodicity touches */
6188: /*upgrade(to level 3) must reimplement all calendars so db_column_name is populated in bsc olap metadata */
6189: bsc_aw_calendar.get_calendar(p_DS_calendar.aw_dim,l_calendar);
6190: l_ds_periodicity:=bsc_aw_calendar.get_periodicity_r(p_DS_calendar.periodicity(1).periodicity,l_calendar.periodicity);
6191: bsc_aw_calendar.get_all_upper_periodicities(l_ds_periodicity,l_calendar,l_upper_periodicities);
6192: for j in 1..p_hpt_data.hpt_calendar.level_names.count loop
6193: for k in 1..l_upper_periodicities.count loop
6194: if p_hpt_data.hpt_calendar.level_names(j)=l_upper_periodicities(k).dim_name then
6195: p_data_source.data_source_PT.cal_parent_child(p_data_source.data_source_PT.cal_parent_child.count+1).parent:=