679:
680: x_period_id := NULL;
681: x_period_name := NULL;
682:
683: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING (
684: p_DimLevelShortName => p_time_dim_level_short_name
685: ,p_bis_source => p_source
686: ,x_Select_String => l_select_string
687: ,x_table_name => l_view_name
1364: FETCH cv INTO x_total_dimlevel_short_name;
1365: CLOSE cv;
1366: END IF;
1367:
1368: BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING (
1369: p_DimLevelShortName => x_total_dimlevel_short_name
1370: ,p_bis_source => l_source
1371: ,x_Select_String => l_select_string
1372: ,x_table_name => l_view_name