APPS.BSC_AW_READ dependencies on BSC_AW_ADAPTER_KPI

Line 254: bsc_aw_adapter_kpi.dmp_dimset(g_kpi(p_kpi).dim_set(g_kpi(p_kpi).dim_set_id(i)).dim_set);

250: end loop;
251: if g_debug then
252: for i in 1..g_kpi(p_kpi).dim_set_id.count loop
253: log('-------Dimset ----------');
254: bsc_aw_adapter_kpi.dmp_dimset(g_kpi(p_kpi).dim_set(g_kpi(p_kpi).dim_set_id(i)).dim_set);
255: log('---------------');
256: end loop;
257: end if;
258: --load levels lookup table

Line 287: p_dim bsc_aw_adapter_kpi.dim_r,

283: raise;
284: End;
285:
286: procedure load_level_lookup(
287: p_dim bsc_aw_adapter_kpi.dim_r,
288: p_dim_set in out nocopy dim_set_r
289: ) is
290: l_level_name varchar2(300);
291: Begin

Line 394: p_parent_child bsc_aw_adapter_kpi.parent_child_tb,

390: */
391: procedure get_child_level(
392: p_level varchar2,
393: p_level_dim level_dim_tv,
394: p_parent_child bsc_aw_adapter_kpi.parent_child_tb,
395: p_child_levels in out nocopy dbms_sql.varchar2_table,
396: p_rel_level_name in out nocopy dbms_sql.varchar2_table
397: ) is
398: l_child_levels dbms_sql.varchar2_table;

Line 439: procedure get_child_periodicity(p_periodicity varchar2,p_cal_periodicity periodicity_tv,p_parent_child bsc_aw_adapter_kpi.cal_parent_child_tb,

435: raise;
436: End;
437:
438: /*called recursively */
439: procedure get_child_periodicity(p_periodicity varchar2,p_cal_periodicity periodicity_tv,p_parent_child bsc_aw_adapter_kpi.cal_parent_child_tb,
440: p_child_levels in out nocopy dbms_sql.varchar2_table,p_rel_level_name in out nocopy dbms_sql.varchar2_table) is
441: l_child_levels dbms_sql.varchar2_table;
442: Begin
443: if p_cal_periodicity(p_periodicity).aggregated='N' then

Line 884: l_composite:=bsc_aw_adapter_kpi.get_cube_pt_comp(p_dim_set.measure(upper(l_measures(1))).cube,p_dim_set.dim_set,l_comp_type);

880: return;
881: end if;
882: l_cube:='bscawrdb_temp_dim_limit';
883: get_measures(p_parameters,l_measures);
884: l_composite:=bsc_aw_adapter_kpi.get_cube_pt_comp(p_dim_set.measure(upper(l_measures(1))).cube,p_dim_set.dim_set,l_comp_type);
885: if l_composite is not null then
886: --loop across all dim in the limit track
887: l_count:=p_dim_set.limit_track.count;
888: for i in 1..p_dim_set.limit_track(l_count).limit_dim.count loop

Line 1107: l_projection_dim:=bsc_aw_adapter_kpi.get_projection_dim(p_dim_set.dim_set);

1103: l_cubes(l_cubes.count+1):=p_dim_set.measure(upper(l_measures(i))).cube;
1104: l_display_cubes(l_display_cubes.count+1):=p_dim_set.measure(upper(l_measures(i))).display_cube;
1105: end if;
1106: end loop;
1107: l_projection_dim:=bsc_aw_adapter_kpi.get_projection_dim(p_dim_set.dim_set);
1108: bsc_aw_dbms_aw.execute('push '||p_dim_set.dim_set.measurename_dim);
1109: bsc_aw_dbms_aw.execute('push '||l_projection_dim);
1110: bsc_aw_dbms_aw.execute('push '||p_dim_set.calendar.aw_dim);
1111: bsc_aw_dbms_aw.execute('limit '||l_projection_dim||' TO ''Y''');

Line 1132: l_pt_comp:=bsc_aw_adapter_kpi.get_cube_pt_comp(l_cubes(i),p_dim_set.dim_set,l_pt_comp_type);

1128: for i in 1..l_cubes.count loop
1129: l_pt_comp:=null;
1130: if l_display_cubes(i) is null then
1131: l_stmt:=l_cubes(i)||'=NA';
1132: l_pt_comp:=bsc_aw_adapter_kpi.get_cube_pt_comp(l_cubes(i),p_dim_set.dim_set,l_pt_comp_type);
1133: else
1134: l_stmt:=l_display_cubes(i)||'=NA';
1135: l_pt_comp:=bsc_aw_adapter_kpi.get_cube_pt_comp(l_display_cubes(i),p_dim_set.dim_set,l_pt_comp_type);
1136: end if;

Line 1135: l_pt_comp:=bsc_aw_adapter_kpi.get_cube_pt_comp(l_display_cubes(i),p_dim_set.dim_set,l_pt_comp_type);

1131: l_stmt:=l_cubes(i)||'=NA';
1132: l_pt_comp:=bsc_aw_adapter_kpi.get_cube_pt_comp(l_cubes(i),p_dim_set.dim_set,l_pt_comp_type);
1133: else
1134: l_stmt:=l_display_cubes(i)||'=NA';
1135: l_pt_comp:=bsc_aw_adapter_kpi.get_cube_pt_comp(l_display_cubes(i),p_dim_set.dim_set,l_pt_comp_type);
1136: end if;
1137: if l_pt_comp is not null then
1138: l_stmt:=l_stmt||' across '||l_pt_comp;
1139: end if;

Line 1427: bsc_aw_adapter_kpi.dmp_measure(p_dimset.measure(upper(p_dimset.dim_set.measure(i).measure)));

1423: dmp_periodicity_r(p_dimset.calendar.periodicity(p_dimset.dim_set.calendar.periodicity(i).periodicity));
1424: end loop;
1425: --
1426: for i in 1..p_dimset.dim_set.measure.count loop
1427: bsc_aw_adapter_kpi.dmp_measure(p_dimset.measure(upper(p_dimset.dim_set.measure(i).measure)));
1428: end loop;
1429: --
1430: Exception when others then
1431: log_n('Exception in dmp_dimset '||sqlerrm);

Line 1572: l_pt_comp:=bsc_aw_adapter_kpi.get_cube_pt_comp(p_cube,p_dim_set.dim_set,l_pt_comp_type);

1568: l_pt_comp varchar2(100);
1569: l_pt_comp_type varchar2(100);
1570: l_stmt varchar2(4000);
1571: Begin
1572: l_pt_comp:=bsc_aw_adapter_kpi.get_cube_pt_comp(p_cube,p_dim_set.dim_set,l_pt_comp_type);
1573: l_stmt:=p_display_cube||'='||p_cube;
1574: if l_pt_comp is not null then
1575: l_stmt:=l_stmt||' across '||l_pt_comp;
1576: end if;