APPS.BSC_MV_ADAPTER dependencies on BSC_IM_INT_MD

Line 152: if BSC_IM_INT_MD.get_mapping(

148: end loop;
149: end if;
150: --------------------------------------------
151: --get the mapping info
152: if BSC_IM_INT_MD.get_mapping(
153: p_mv_name,
154: p_apps_origin,
155: l_map_name,
156: l_map_type,

Line 355: if BSC_IM_INT_MD.get_mapping_detail(

351: if l_chosen_map(i) then
352: if g_debug then
353: write_to_log_file_n('Process map '||l_map_name(i));
354: end if;
355: if BSC_IM_INT_MD.get_mapping_detail(
356: l_map_name(i),
357: p_apps_origin,
358: l_line,
359: l_line_type,

Line 573: if BSC_IM_INT_MD.get_object(

569: and object_type = 'MATERIALIZED VIEW';
570: begin
571: l_zmv := upper(substr(p_mv_name, 1, instr(p_mv_name, '_MV', -1)))||'ZMV';
572: --write_to_log_file('zmv_exists_for_mv, we are searching for l_zmv ='||l_zmv);
573: if BSC_IM_INT_MD.get_object(
574: p_kpi,
575: p_apps_origin,
576: 'ZERO CODE MV',
577: l_zero_code_mv,

Line 708: if BSC_IM_INT_MD.get_fk(

704: if BSC_BSC_ADAPTER.get_table_fks(l_s_tables,l_number_s_tables,l_fk_name,l_number_fk)=false then
705: return false;
706: end if;
707: else
708: if BSC_IM_INT_MD.get_fk(
709: p_mv_name,
710: p_apps_origin,
711: l_fk_name,
712: l_fk_type,

Line 987: if BSC_IM_INT_MD.get_column(

983: p_snplog_created:=false;
984: l_number_columns := 0;
985: select count(1) into l_dim from bsc_sys_dim_levels_b where level_table_name=p_object;
986: if(l_dim=0) then -- not dimension
987: if BSC_IM_INT_MD.get_column(
988: p_object,
989: p_apps_origin,
990: l_column_name,
991: l_column_type,

Line 1002: if BSC_IM_INT_MD.get_fk(

998: return false;
999: end if;
1000: end if;
1001: --get the fks
1002: if BSC_IM_INT_MD.get_fk(
1003: p_object,
1004: p_apps_origin,
1005: l_fk_name,
1006: l_fk_type,

Line 1361: if BSC_IM_INT_MD.get_object(

1357: write_to_log_file('In create_zero_code_mv_kpi '||p_kpi||' '||get_time);
1358: write_to_log_file('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
1359: end if;
1360: g_kpi:=p_kpi;
1361: if BSC_IM_INT_MD.get_object(
1362: p_kpi,
1363: p_apps_origin,
1364: 'ZERO CODE MV',
1365: l_zero_code_mv,

Line 1381: if BSC_IM_INT_MD.get_object(

1377: ll_dep_object_desc BSC_IM_UTILS.varchar_tabletype;
1378: ll_number_dep_objects number;
1379: begin
1380: for i in 1..l_number_zero_code_mv loop
1381: if BSC_IM_INT_MD.get_object(
1382: l_zero_code_mv(i),
1383: p_apps_origin,
1384: 'MV DEPENDENCY',
1385: ll_dep_object_name,

Line 1522: if BSC_IM_INT_MD.get_object(

1518: if g_debug then
1519: write_to_log_file_n('In get_ordered_mv_list '||p_kpi||' '||p_apps_origin);
1520: end if;
1521: g_kpi:=p_kpi;
1522: if BSC_IM_INT_MD.get_object(
1523: p_kpi,
1524: p_apps_origin,
1525: 'SUMMARY MV',
1526: l_summary_mv,

Line 1550: if BSC_IM_INT_MD.get_object(

1546: begin
1547: p_number_pc_mv:=0;
1548: for i in 1..l_number_summary_mv loop
1549: ll_number_object:=0;
1550: if BSC_IM_INT_MD.get_object(
1551: l_summary_mv(i),
1552: p_apps_origin,
1553: 'MV DEPENDENCY',
1554: ll_object_name,

Line 1665: BSC_IM_INT_MD.set_globals(g_debug);

1661: p_debug boolean) is
1662: Begin
1663: g_debug:=p_debug;
1664: BSC_IM_UTILS.set_globals(g_debug);
1665: BSC_IM_INT_MD.set_globals(g_debug);
1666: Exception when others then
1667: BSC_IM_UTILS.g_status_message:=sqlerrm;
1668: null;
1669: End;

Line 1756: if BSC_IM_INT_MD.get_object(

1752: end loop;
1753: end loop;
1754: --------------------------------------------
1755: --the zero code mv
1756: if BSC_IM_INT_MD.get_object(
1757: p_kpi,
1758: p_apps_origin,
1759: 'ZERO CODE MV',
1760: l_zero_code_mv,

Line 1946: if BSC_IM_INT_MD.get_object(

1942: return false;
1943: end if;
1944: ------------------------------------------------------
1945: --the zero code mv
1946: if BSC_IM_INT_MD.get_object(
1947: p_kpi,
1948: p_apps_origin,
1949: 'ZERO CODE MV',
1950: l_zero_code_mv,