APPS.BSC_AW_ADAPTER_DIM dependencies on BSC_AW_BSC_METADATA

Line 60: bsc_aw_bsc_metadata.get_all_parent_child(p_dim_level_list,p_dim_parent_child,p_dim_levels);

56: if g_debug then
57: log_n('In get_all_dim_levels'||bsc_aw_utility.get_time);
58: end if;
59: --get all the parent child relations for the levels
60: bsc_aw_bsc_metadata.get_all_parent_child(p_dim_level_list,p_dim_parent_child,p_dim_levels);
61: if g_debug then
62: log_n('p_dim_parent_child');
63: for i in 1..p_dim_parent_child.count loop
64: log(p_dim_parent_child(i).parent_level||'('||p_dim_parent_child(i).parent_pk||') '||

Line 421: bsc_aw_bsc_metadata.get_kpi_for_dim(p_dimension);

417: kpi_for_dim_r holds the kpi and dimset info
418: */
419: procedure get_kpi_for_dim(p_dimension in out nocopy dimension_r) is
420: Begin
421: bsc_aw_bsc_metadata.get_kpi_for_dim(p_dimension);
422: Exception when others then
423: log_n('Exception in get_kpi_for_dim '||sqlerrm);
424: raise;
425: End;

Line 510: bsc_aw_bsc_metadata.create_rec_data_source(p_dimension);

506: procedure create_rec_data_source(
507: p_dimension in out nocopy dimension_r
508: ) is
509: Begin
510: bsc_aw_bsc_metadata.create_rec_data_source(p_dimension);
511: p_dimension.initial_load_program:='load_'||p_dimension.dim_name||'.initial';
512: p_dimension.inc_load_program:='load_'||p_dimension.dim_name||'.initial';
513: Exception when others then
514: log_n('Exception in create_rec_data_source '||sqlerrm);

Line 525: bsc_aw_bsc_metadata.create_data_source(p_dimension);

521: procedure create_data_source(
522: p_dimension in out nocopy dimension_r
523: ) is
524: Begin
525: bsc_aw_bsc_metadata.create_data_source(p_dimension);
526: p_dimension.initial_load_program:='load_'||p_dimension.dim_name||'.initial';
527: p_dimension.inc_load_program:='load_'||p_dimension.dim_name||'.inc';
528: Exception when others then
529: log_n('Exception in create_data_source '||sqlerrm);

Line 1895: if bsc_aw_bsc_metadata.is_level_used_by_aw_kpi(p_old_level(i).level_name) then

1891: */
1892: procedure correct_levels(p_old_level levels_tb,p_new_level out nocopy levels_tb) is
1893: Begin
1894: for i in 1..p_old_level.count loop
1895: if bsc_aw_bsc_metadata.is_level_used_by_aw_kpi(p_old_level(i).level_name) then
1896: p_new_level(p_new_level.count+1):=p_old_level(i);
1897: end if;
1898: end loop;
1899: Exception when others then

Line 1935: bsc_aw_bsc_metadata.get_parent_level(l_levels(i),l_parents); --does not return top node

1931: end if;
1932: end loop;
1933: for i in 1..l_levels.count loop
1934: l_parents.delete;
1935: bsc_aw_bsc_metadata.get_parent_level(l_levels(i),l_parents); --does not return top node
1936: for j in 1..p_old_pc.count loop
1937: if p_old_pc(j).child_level=l_levels(i) then
1938: --if p_old_pc(j).parent_level is null and l_parents.count=0
1939: --and bsc_aw_utility.in_array(l_dim_levels,p_old_pc(j).parent_level) then

Line 2433: bsc_aw_bsc_metadata.set_dim_recursive(p_dimension);

2429: End;
2430:
2431: procedure set_dim_recursive(p_dimension in out nocopy dimension_r) is
2432: Begin
2433: bsc_aw_bsc_metadata.set_dim_recursive(p_dimension);
2434: if p_dimension.recursive is null or p_dimension.recursive='N' then --do one more check
2435: if p_dimension.level_groups(1).parent_child.count=1
2436: and p_dimension.level_groups(1).parent_child(1).parent_level=p_dimension.level_groups(1).parent_child(1).child_level then
2437: p_dimension.recursive:='Y';