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_BSC_ADAPTER dependencies on BSC_IM_INT_MD

Line 340: if BSC_IM_INT_MD.create_cube(p_indicator,p_indicator,0,'BSC',p_indicator,null)=false then

336: --MV are created for the SB tables.
337: l_lang:=BSC_IM_UTILS.get_lang;
338: ----------------------
339: --create the metadata for KPI
340: if BSC_IM_INT_MD.create_cube(p_indicator,p_indicator,0,'BSC',p_indicator,null)=false then
341: return false;
342: end if;
343: ----------------------
344: if get_s_sb_tables(p_indicator,l_s_tables,l_periodicity,l_number_s_tables)=false then

Line 389: if BSC_IM_INT_MD.create_object(

385: end if;
386: if ll_number_s_tables>0 then
387: --------------------------------------------
388: --int metadata for the mv for this kpi
389: if BSC_IM_INT_MD.create_object(
390: l_mv_name,
391: 'SUMMARY MV',
392: 'BSC',
393: p_indicator,

Line 586: if BSC_IM_INT_MD.create_fk(

582: if g_debug then
583: write_to_log_file_n('In Create_kpi_map_info--Before Loop Create_Fks'||' '||get_time);
584: end if;
585: for i in 1..l_number_fk loop
586: if BSC_IM_INT_MD.create_fk(
587: l_fk(i),
588: 'SUMMARY MV',
589: p_mv_name,
590: null,

Line 601: if BSC_IM_INT_MD.create_column(

597: end loop;
598: ------------------
599: --int metadata for the measures
600: for i in 1..l_number_measures loop
601: if BSC_IM_INT_MD.create_column(
602: l_measures(i),
603: 'A',
604: null,
605: 'BSC',

Line 739: if BSC_IM_INT_MD.create_fk(

735: return false;
736: end if;
737: --insert into int metadata
738: for j in 1..ll_number_fk loop
739: if BSC_IM_INT_MD.create_fk(
740: ll_fk(j),
741: 'BASE TABLE',
742: l_b_tables(i),
743: null,

Line 752: if BSC_IM_INT_MD.create_column(

748: return false;
749: end if;
750: end loop;
751: for j in 1..ll_number_measures loop
752: if BSC_IM_INT_MD.create_column(
753: ll_measures(j),
754: 'A',
755: null,
756: 'BSC',

Line 1378: write_to_log_file_n('In Create_kpi_map_info--Before BSC_IM_INT_MD.create_object'||' '||get_time);

1374: for i in 1..l_number_source_tables loop
1375: if BSC_IM_UTILS.is_like(l_source_tables(i),'BSC_S_')
1376: or BSC_IM_UTILS.is_like(l_source_tables(i),'BSC_SB_') then
1377: if g_debug then
1378: write_to_log_file_n('In Create_kpi_map_info--Before BSC_IM_INT_MD.create_object'||' '||get_time);
1379: end if;
1380: if BSC_IM_INT_MD.create_object(
1381: l_source_tables(i),
1382: 'SUMMARY MV',

Line 1380: if BSC_IM_INT_MD.create_object(

1376: or BSC_IM_UTILS.is_like(l_source_tables(i),'BSC_SB_') then
1377: if g_debug then
1378: write_to_log_file_n('In Create_kpi_map_info--Before BSC_IM_INT_MD.create_object'||' '||get_time);
1379: end if;
1380: if BSC_IM_INT_MD.create_object(
1381: l_source_tables(i),
1382: 'SUMMARY MV',
1383: 'BSC',
1384: p_mv_name,

Line 1388: write_to_log_file_n('In Create_kpi_map_info--After BSC_IM_INT_MD.create_object'||' '||get_time);

1384: p_mv_name,
1385: null,
1386: 'MV DEPENDENCY')=false then
1387: if g_debug then
1388: write_to_log_file_n('In Create_kpi_map_info--After BSC_IM_INT_MD.create_object'||' '||get_time);
1389: end if;
1390: return false;
1391: end if;
1392: if g_debug then

Line 1393: write_to_log_file_n('In Create_kpi_map_info--After BSC_IM_INT_MD.create_object'||' '||get_time);

1389: end if;
1390: return false;
1391: end if;
1392: if g_debug then
1393: write_to_log_file_n('In Create_kpi_map_info--After BSC_IM_INT_MD.create_object'||' '||get_time);
1394: end if;
1395: end if;
1396: end loop;
1397: -------------------------------------------------------

Line 2037: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_select_sql,'SELECT',null)=false then

2033: --write_to_log_file_n('select sql after no agg changes='||l_select_sql);
2034: --end if;
2035: end if;
2036:
2037: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_select_sql,'SELECT',null)=false then
2038: return false;
2039: end if;
2040: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_select_sql_inc,'SELECT INC',null)=false then
2041: return false;

Line 2040: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_select_sql_inc,'SELECT INC',null)=false then

2036:
2037: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_select_sql,'SELECT',null)=false then
2038: return false;
2039: end if;
2040: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_select_sql_inc,'SELECT INC',null)=false then
2041: return false;
2042: end if;
2043: if (ll_keys_stmt is not null) then
2044: ll_keys_stmt := substr(ll_keys_stmt, 1, length(ll_keys_stmt)-1);

Line 2045: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then

2041: return false;
2042: end if;
2043: if (ll_keys_stmt is not null) then
2044: ll_keys_stmt := substr(ll_keys_stmt, 1, length(ll_keys_stmt)-1);
2045: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then
2046: return false;
2047: end if;
2048: end if;
2049: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_from_sql,'FROM',null)=false then

Line 2049: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_from_sql,'FROM',null)=false then

2045: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then
2046: return false;
2047: end if;
2048: end if;
2049: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_from_sql,'FROM',null)=false then
2050: return false;
2051: end if;
2052: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_where_sql,'WHERE',null)=false then
2053: return false;

Line 2052: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_where_sql,'WHERE',null)=false then

2048: end if;
2049: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_from_sql,'FROM',null)=false then
2050: return false;
2051: end if;
2052: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_where_sql,'WHERE',null)=false then
2053: return false;
2054: end if;
2055: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_group_by_sql,'GROUP BY',null)=false then
2056: return false;

Line 2055: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_group_by_sql,'GROUP BY',null)=false then

2051: end if;
2052: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_where_sql,'WHERE',null)=false then
2053: return false;
2054: end if;
2055: if BSC_IM_INT_MD.create_mapping_detail(p_map_name,'BSC',l_group_by_sql,'GROUP BY',null)=false then
2056: return false;
2057: end if;
2058:
2059: ---------------------------------------------------------------------

Line 2376: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_select_sql(j),'SELECT',null)=false then

2372: if ll_use_union_for_rollup then
2373: --only if union all is allowed for zero code mv do we write this to the int metadata
2374: --if there are too many keys will rollup, then we want to go over cube(...)
2375: for j in 1..ll_union_number loop
2376: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_select_sql(j),'SELECT',null)=false then
2377: return false;
2378: end if;
2379: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_from_sql(j),'FROM',null)=false then
2380: return false;

Line 2379: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_from_sql(j),'FROM',null)=false then

2375: for j in 1..ll_union_number loop
2376: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_select_sql(j),'SELECT',null)=false then
2377: return false;
2378: end if;
2379: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_from_sql(j),'FROM',null)=false then
2380: return false;
2381: end if;
2382: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_where_sql(j),'WHERE',null)=false then
2383: return false;

Line 2382: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_where_sql(j),'WHERE',null)=false then

2378: end if;
2379: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_from_sql(j),'FROM',null)=false then
2380: return false;
2381: end if;
2382: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_where_sql(j),'WHERE',null)=false then
2383: return false;
2384: end if;
2385: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_group_by_sql(j),'GROUP BY',null)=false then
2386: return false;

Line 2385: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_group_by_sql(j),'GROUP BY',null)=false then

2381: end if;
2382: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_where_sql(j),'WHERE',null)=false then
2383: return false;
2384: end if;
2385: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_group_by_sql(j),'GROUP BY',null)=false then
2386: return false;
2387: end if;
2388: end loop;
2389: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then

Line 2389: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then

2385: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_group_by_sql(j),'GROUP BY',null)=false then
2386: return false;
2387: end if;
2388: end loop;
2389: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then
2390: return false;
2391: end if;
2392: else
2393: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_select_sql,

Line 2393: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_select_sql,

2389: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then
2390: return false;
2391: end if;
2392: else
2393: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_select_sql,
2394: 'SELECT',null)=false then
2395: return false;
2396: end if;
2397: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_from_sql,

Line 2397: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_from_sql,

2393: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_select_sql,
2394: 'SELECT',null)=false then
2395: return false;
2396: end if;
2397: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_from_sql,
2398: 'FROM',null)=false then
2399: return false;
2400: end if;
2401: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_where_sql,

Line 2401: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_where_sql,

2397: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_from_sql,
2398: 'FROM',null)=false then
2399: return false;
2400: end if;
2401: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_where_sql,
2402: 'WHERE',null)=false then
2403: return false;
2404: end if;
2405: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_group_by_sql,

Line 2405: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_group_by_sql,

2401: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_where_sql,
2402: 'WHERE',null)=false then
2403: return false;
2404: end if;
2405: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_group_by_sql,
2406: 'GROUP BY',null)=false then
2407: return false;
2408: end if;
2409: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then

Line 2409: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then

2405: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',l_rollup_full_group_by_sql,
2406: 'GROUP BY',null)=false then
2407: return false;
2408: end if;
2409: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then
2410: return false;
2411: end if;
2412: end if;
2413: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_select_sql,

Line 2413: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_select_sql,

2409: if BSC_IM_INT_MD.create_mapping_detail(p_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then
2410: return false;
2411: end if;
2412: end if;
2413: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_select_sql,
2414: 'SELECT',null)=false then
2415: return false;
2416: end if;
2417: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_from_sql,

Line 2417: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_from_sql,

2413: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_select_sql,
2414: 'SELECT',null)=false then
2415: return false;
2416: end if;
2417: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_from_sql,
2418: 'FROM',null)=false then
2419: return false;
2420: end if;
2421: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_where_sql,

Line 2421: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_where_sql,

2417: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_from_sql,
2418: 'FROM',null)=false then
2419: return false;
2420: end if;
2421: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_where_sql,
2422: 'WHERE',null)=false then
2423: return false;
2424: end if;
2425: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_group_by_sql,

Line 2425: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_group_by_sql,

2421: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_where_sql,
2422: 'WHERE',null)=false then
2423: return false;
2424: end if;
2425: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_group_by_sql,
2426: 'GROUP BY',null)=false then
2427: return false;
2428: end if;
2429: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then

Line 2429: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then

2425: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',l_rollup_full_group_by_sql,
2426: 'GROUP BY',null)=false then
2427: return false;
2428: end if;
2429: if BSC_IM_INT_MD.create_mapping_detail(l_full_zero_code_map_name,'BSC',ll_keys_stmt,'KEYS',null)=false then
2430: return false;
2431: end if;
2432:
2433: end if;--if ll_number_rollup_fk>0 then

Line 2444: if BSC_IM_INT_MD.create_object(

2440: write_to_log_file_n('In Create_kpi_map_info--Before Create_object ZEro Code MVs'||' '||get_time);
2441: write_to_log_file_n('ll_number_rollup_fk='||ll_number_rollup_fk);
2442: end if;
2443: if ll_number_rollup_fk>0 and ll_zero_separate then
2444: if BSC_IM_INT_MD.create_object(
2445: p_zero_code_mv_name,
2446: 'ZERO CODE MV',
2447: 'BSC',
2448: p_indicator,

Line 2453: if BSC_IM_INT_MD.create_mapping(p_zero_code_map_name,'BSC','ZERO CODE MV',p_zero_code_mv_name,

2449: null,
2450: 'ZERO CODE MV')=false then
2451: return false;
2452: end if;
2453: if BSC_IM_INT_MD.create_mapping(p_zero_code_map_name,'BSC','ZERO CODE MV',p_zero_code_mv_name,
2454: 'FAST REFRESH')=false then
2455: return false;
2456: end if;
2457: if BSC_IM_INT_MD.create_mapping(l_full_zero_code_map_name,'BSC','ZERO CODE MV',p_zero_code_mv_name,

Line 2457: if BSC_IM_INT_MD.create_mapping(l_full_zero_code_map_name,'BSC','ZERO CODE MV',p_zero_code_mv_name,

2453: if BSC_IM_INT_MD.create_mapping(p_zero_code_map_name,'BSC','ZERO CODE MV',p_zero_code_mv_name,
2454: 'FAST REFRESH')=false then
2455: return false;
2456: end if;
2457: if BSC_IM_INT_MD.create_mapping(l_full_zero_code_map_name,'BSC','ZERO CODE MV',p_zero_code_mv_name,
2458: 'FULL REFRESH')=false then
2459: return false;
2460: end if;
2461: --create the fk, this is reqd for index creation

Line 2463: if BSC_IM_INT_MD.create_fk(

2459: return false;
2460: end if;
2461: --create the fk, this is reqd for index creation
2462: for i in 1..l_number_fk loop
2463: if BSC_IM_INT_MD.create_fk(
2464: l_fk(i),
2465: 'ZERO CODE MV',
2466: p_zero_code_mv_name,
2467: null,

Line 2476: if BSC_IM_INT_MD.create_object(

2472: return false;
2473: end if;
2474: end loop;
2475: --create the mv dependency. this is for snapshot log creation
2476: if BSC_IM_INT_MD.create_object(
2477: p_mv_name,
2478: 'ZERO CODE MV',
2479: 'BSC',
2480: p_zero_code_mv_name,

Line 2508: if BSC_IM_INT_MD.create_fk('CODE','LEVEL TABLE',l_dim_level_tables(i),null,null,null,'BSC',

2504: ll_number_level_columns)=false then
2505: return false;
2506: end if;
2507: if ll_number_level_columns>0 then
2508: if BSC_IM_INT_MD.create_fk('CODE','LEVEL TABLE',l_dim_level_tables(i),null,null,null,'BSC',
2509: 'LEVEL TABLE')=false then
2510: return false;
2511: end if;
2512: --3613094

Line 2514: if BSC_IM_INT_MD.create_fk('LANGUAGE','LEVEL TABLE',l_dim_level_tables(i),null,null,null,'BSC',

2510: return false;
2511: end if;
2512: --3613094
2513: if bsc_im_utils.is_column_in_object(l_dim_level_tables(i),'LANGUAGE') then
2514: if BSC_IM_INT_MD.create_fk('LANGUAGE','LEVEL TABLE',l_dim_level_tables(i),null,null,null,'BSC',
2515: 'LEVEL TABLE')=false then
2516: return false;
2517: end if;
2518: end if;

Line 2521: if BSC_IM_INT_MD.create_column(ll_level_columns(j),'A',null,'BSC',null,null,null,l_dim_level_tables(i),

2517: end if;
2518: end if;
2519: for j in 1..ll_number_level_columns loop
2520: if upper(ll_level_columns(j))<>'CODE' and upper(ll_level_columns(j))<>'LANGUAGE' then
2521: if BSC_IM_INT_MD.create_column(ll_level_columns(j),'A',null,'BSC',null,null,null,l_dim_level_tables(i),
2522: null)=false then
2523: return false;
2524: end if;
2525: end if;

Line 2531: if BSC_IM_INT_MD.create_fk('SOURCE_TYPE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

2527: end if;
2528: end loop;
2529: --if there is filter, make an entry also for the filter table
2530: if l_number_filter>0 then
2531: if BSC_IM_INT_MD.create_fk('SOURCE_TYPE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2532: 'LEVEL TABLE')=false then
2533: return false;
2534: end if;
2535: if BSC_IM_INT_MD.create_fk('SOURCE_CODE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

Line 2535: if BSC_IM_INT_MD.create_fk('SOURCE_CODE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

2531: if BSC_IM_INT_MD.create_fk('SOURCE_TYPE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2532: 'LEVEL TABLE')=false then
2533: return false;
2534: end if;
2535: if BSC_IM_INT_MD.create_fk('SOURCE_CODE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2536: 'LEVEL TABLE')=false then
2537: return false;
2538: end if;
2539: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_ID','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

Line 2539: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_ID','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

2535: if BSC_IM_INT_MD.create_fk('SOURCE_CODE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2536: 'LEVEL TABLE')=false then
2537: return false;
2538: end if;
2539: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_ID','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2540: 'LEVEL TABLE')=false then
2541: return false;
2542: end if;
2543: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_VALUE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

Line 2543: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_VALUE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

2539: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_ID','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2540: 'LEVEL TABLE')=false then
2541: return false;
2542: end if;
2543: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_VALUE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2544: 'LEVEL TABLE')=false then
2545: return false;
2546: end if;
2547: if BSC_IM_UTILS.in_array(l_dim_level_tables,l_number_dim_level_tables,'BSC_SYS_FILTERS')=false then

Line 2573: if BSC_IM_INT_MD.create_mapping(p_map_name,'BSC','SUMMARY MV',p_mv_name,ll_property)=false then

2569: ll_property:=l_base_table_stmt||','||l_dim_level_stmt;
2570: else
2571: ll_property:=l_base_table_stmt||l_dim_level_stmt;
2572: end if;
2573: if BSC_IM_INT_MD.create_mapping(p_map_name,'BSC','SUMMARY MV',p_mv_name,ll_property)=false then
2574: return false;
2575: end if;
2576: end;
2577: -----------------------------------------------------

Line 3566: BSC_IM_INT_MD.set_globals(g_debug);

3562: procedure set_globals(p_debug boolean) is
3563: Begin
3564: g_debug:=p_debug;
3565: BSC_IM_UTILS.set_globals(g_debug);
3566: BSC_IM_INT_MD.set_globals(g_debug);
3567: Exception when others then
3568: BSC_IM_UTILS.g_status_message:=sqlerrm;
3569: null;
3570: End;

Line 6476: if BSC_IM_INT_MD.create_fk(

6472: if get_table_fks(l_s_tables(1),l_fk,l_number_fk)=false then
6473: raise l_exception;
6474: end if;
6475: for i in 1..l_number_fk loop
6476: if BSC_IM_INT_MD.create_fk(
6477: l_fk(i),
6478: 'SUMMARY MV',
6479: p_mv_name,
6480: null,