APPS.BIS_PMV_PARAMETERS_PVT dependencies on BIS_PMF_GET_DIMLEVELS_PUB

Line 2287: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(

2283: l_level_type := 'EDW';
2284: ELSE
2285: l_level_type := 'OLTP';
2286: END IF;
2287: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(
2288: p_DimLevelShortName => l_dimension_level
2289: , p_bis_source => l_level_type
2290: , x_Select_String => l_sql_stmnt
2291: , x_table_name => l_view_name

Line 4148: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(

4144:
4145: if v_level_values_view_name is not null then
4146: v_sql_stmnt := 'select '||v_id_name||', '||v_value_name||' from '||v_level_values_view_name;
4147: else
4148: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(
4149: p_DimLevelShortName => vDimensionLevel
4150: ,p_bis_source => vLevelType
4151: ,x_Select_String => v_sql_stmnt
4152: ,x_table_name=> v_table_name

Line 4169: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(

4165: if v_edw_level_values_view_name is not null then
4166: v_sql_stmnt := 'select '||v_id_name||', '||v_value_name||' from '||
4167: v_edw_level_values_view_name;
4168: else
4169: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(
4170: p_DimLevelShortName => vEdwDimensionLevel
4171: ,p_bis_source => 'EDW'
4172: ,x_Select_String => v_sql_stmnt
4173: ,x_table_name=> v_table_name

Line 4189: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(

4185: if v_level_values_view_name is not null then
4186: v_sql_stmnt := 'select '||v_id_name||', '||v_value_name||' from '||
4187: v_level_values_view_name;
4188: else
4189: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(
4190: p_DimLevelShortName => vDimensionLevel
4191: ,p_bis_source => 'OLTP'
4192: ,x_Select_String => v_sql_stmnt
4193: ,x_table_name=> v_table_name

Line 4495: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(

4491:
4492: v_sql_stmnt := v_sql_stmnt || ' from '||v_edw_tmlvl_values_view_name;
4493: v_table_name := v_edw_tmlvl_values_view_name;
4494: else
4495: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(
4496: p_DimLevelShortName => vEdwDimensionLevel
4497: ,p_bis_source => 'EDW'
4498: ,x_Select_String => v_sql_stmnt
4499: ,x_table_name=> v_table_name

Line 4605: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(

4601: v_sql_stmnt := 'select '||v_id_name||', '||v_value_name||', start_date, end_date from '||
4602: v_level_values_view_name;
4603: v_table_name := v_level_values_view_name;
4604: else
4605: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(
4606: p_DimLevelShortName => vDimensionLevel
4607: ,p_bis_source => 'OLTP'
4608: ,x_Select_String => v_sql_stmnt
4609: ,x_table_name=> v_table_name