DBA Data[Home] [Help]

APPS.BSC_UPDATE_DIM dependencies on FND_PROFILE

Line 2447: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile

2443: g_dbi_dim_data(l_i).child_col_src:='CHILD_ID';
2444: g_dbi_dim_data(l_i).parent_col_src:='PARENT_ID';
2445: g_dbi_dim_data(l_i).parent_level_src_col:=null;
2446: g_dbi_dim_data(l_i).denorm_src_object:='ENI_DENORM_HIERARCHIES';
2447: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2448: g_dbi_dim_data(l_i).top_n_levels:=100000;--denorm all levels
2449: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2450: -----
2451: g_dbi_dim_data(l_i).source_to_check := NULL;

Line 2449: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile

2445: g_dbi_dim_data(l_i).parent_level_src_col:=null;
2446: g_dbi_dim_data(l_i).denorm_src_object:='ENI_DENORM_HIERARCHIES';
2447: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2448: g_dbi_dim_data(l_i).top_n_levels:=100000;--denorm all levels
2449: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2450: -----
2451: g_dbi_dim_data(l_i).source_to_check := NULL;
2452: g_dbi_dim_data(l_i).denorm_source_to_check := 'ENI_DENORM_HIERARCHIES';
2453:

Line 2480: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile

2476: g_dbi_dim_data(l_i).child_col_src:='ID';
2477: g_dbi_dim_data(l_i).parent_col_src:='PARENT_ID';
2478: g_dbi_dim_data(l_i).parent_level_src_col:=null;
2479: g_dbi_dim_data(l_i).denorm_src_object:='ENI_ITEM_ITM_CAT_V';
2480: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2481: g_dbi_dim_data(l_i).top_n_levels:=100000;--denorm all levels
2482: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2483: ---
2484:

Line 2482: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile

2478: g_dbi_dim_data(l_i).parent_level_src_col:=null;
2479: g_dbi_dim_data(l_i).denorm_src_object:='ENI_ITEM_ITM_CAT_V';
2480: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2481: g_dbi_dim_data(l_i).top_n_levels:=100000;--denorm all levels
2482: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2483: ---
2484:
2485: l_i := l_i + 1;
2486: g_dbi_dim_data(l_i).short_name := 'REQUESTTYPE';

Line 2561: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile

2557: g_dbi_dim_data(l_i).child_col_src:='SUB_PERSON_ID';
2558: g_dbi_dim_data(l_i).parent_col_src:='SUP_PERSON_ID';
2559: g_dbi_dim_data(l_i).parent_level_src_col:='SUP_LEVEL';
2560: g_dbi_dim_data(l_i).denorm_src_object:='HRI_CS_SUPH';
2561: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2562: g_dbi_dim_data(l_i).top_n_levels:=100000;--denorm all levels
2563: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2564: ---
2565: g_dbi_dim_data(l_i).source_to_check := 'HRI_CS_SUPH';

Line 2563: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile

2559: g_dbi_dim_data(l_i).parent_level_src_col:='SUP_LEVEL';
2560: g_dbi_dim_data(l_i).denorm_src_object:='HRI_CS_SUPH';
2561: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2562: g_dbi_dim_data(l_i).top_n_levels:=100000;--denorm all levels
2563: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2564: ---
2565: g_dbi_dim_data(l_i).source_to_check := 'HRI_CS_SUPH';
2566: g_dbi_dim_data(l_i).denorm_source_to_check := 'HRI_CS_SUPH';
2567:

Line 2764: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile

2760: g_dbi_dim_data(l_i).child_col_src:='ID';
2761: g_dbi_dim_data(l_i).parent_col_src:='PARENT_ID';
2762: g_dbi_dim_data(l_i).parent_level_src_col:=null;
2763: g_dbi_dim_data(l_i).denorm_src_object:='PJI_ORGANIZATIONS_V';
2764: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2765: g_dbi_dim_data(l_i).top_n_levels:=100000;--denorm all levels
2766: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2767: ---
2768:

Line 2766: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile

2762: g_dbi_dim_data(l_i).parent_level_src_col:=null;
2763: g_dbi_dim_data(l_i).denorm_src_object:='PJI_ORGANIZATIONS_V';
2764: --g_dbi_dim_data(l_i).top_n_levels:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2765: g_dbi_dim_data(l_i).top_n_levels:=100000;--denorm all levels
2766: g_dbi_dim_data(l_i).top_n_levels_in_mv:=fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');--read adv sum profile
2767: ---
2768:
2769: l_i := l_i + 1;
2770: g_dbi_dim_data(l_i).short_name := 'POA_COMMODITIES';