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.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BIS_UTILITIES_PVT

Line 706: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => p_source);

702: END;
703: l_valuename := 'NAME';
704: END IF;
705: IF p_source IS NOT NULL THEN -- 2617369
706: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => p_source);
707: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>l_dimshortname
708: ,p_source => p_source
709: );
710: ELSE

Line 707: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>l_dimshortname

703: l_valuename := 'NAME';
704: END IF;
705: IF p_source IS NOT NULL THEN -- 2617369
706: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => p_source);
707: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>l_dimshortname
708: ,p_source => p_source
709: );
710: ELSE
711: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL

Line 711: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL

707: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>l_dimshortname
708: ,p_source => p_source
709: );
710: ELSE
711: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL
712: ,p_DimLevelName =>l_lvlshortname
713: );
714: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME(p_dim_short_name=>l_dimshortname
715: ,p_DimLevelId => NULL

Line 714: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME(p_dim_short_name=>l_dimshortname

710: ELSE
711: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL
712: ,p_DimLevelName =>l_lvlshortname
713: );
714: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME(p_dim_short_name=>l_dimshortname
715: ,p_DimLevelId => NULL
716: ,p_DimLevelName => l_lvlshortname
717: );
718: END IF;

Line 903: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- 2408906

899: FND_MSG_PUB.ADD;
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: CLOSE c_dimlvls;
903: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- 2408906
904: p_level_short_name => l_lvlshortname);
905:
906: IF ( l_Is_Rolling_Period_Level = 1 ) THEN -- 2408906
907:

Line 910: || BIS_UTILITIES_PVT.GET_FND_MESSAGE( 'BIS_ALL_VALUE_ROLLING' )

906: IF ( l_Is_Rolling_Period_Level = 1 ) THEN -- 2408906
907:
908: x_bis_select_string := ' select -1 Id, '
909: || ''''
910: || BIS_UTILITIES_PVT.GET_FND_MESSAGE( 'BIS_ALL_VALUE_ROLLING' )
911: || ''''
912: || ' Value, sysdate start_date, sysdate end_date from dual ' ;
913: -- ' select -1 Id, ' || '''All''' || ' Value from dual ' ;
914: -- ' select id, value, start_date, end_date from BIS_ROLLING_LEVEL_002 ' ;

Line 926: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_Source => p_source);

922:
923: ELSE
924:
925: IF p_source IS NOT NULL THEN -- 2617369
926: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_Source => p_source);
927: ELSE
928: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL
929: , p_DimLevelName => l_lvlshortname);
930: END IF;

Line 928: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL

924:
925: IF p_source IS NOT NULL THEN -- 2617369
926: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_Source => p_source);
927: ELSE
928: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL
929: , p_DimLevelName => l_lvlshortname);
930: END IF;
931:
932: -- Added condition to check if it is a Periodicity time Dimension Object

Line 1886: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => p_source);

1882: l_dimshortname_time bis_dimensions.short_name%TYPE;
1883: l_lvlshortname_total bis_levels.short_name%TYPE;
1884: BEGIN
1885: IF p_source IS NOT NULL THEN
1886: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => p_source);
1887:
1888: IF ((p_source = 'EDW') AND (p_data_source IS NULL)) THEN
1889: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>p_dimshortname
1890: ,p_source => p_source

Line 1889: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>p_dimshortname

1885: IF p_source IS NOT NULL THEN
1886: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => p_source);
1887:
1888: IF ((p_source = 'EDW') AND (p_data_source IS NULL)) THEN
1889: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>p_dimshortname
1890: ,p_source => p_source
1891: );
1892: END IF;
1893: ELSE -- if source is null, it is oltp case

Line 1894: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL

1890: ,p_source => p_source
1891: );
1892: END IF;
1893: ELSE -- if source is null, it is oltp case
1894: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL
1895: ,p_DimLevelName =>p_lvlshortname
1896: );
1897: END IF;
1898: