DBA Data[Home] [Help]

APPS.BIS_PMV_QUERY_PVT dependencies on BIS_DIMENSION_LEVEL_PUB

Line 1763: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;

1759: l_Ordered_Dimension_Select VARCHAR2(2000) := '';
1760: l_dimension_level VARCHAR2(80);
1761: l_dimension_level_short_name VARCHAR2(80);
1762: l_dimension_level_id NUMBER;
1763: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
1764: l_return_status VARCHAR2(2000);
1765: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1766: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;
1767: l_count NUMBER;

Line 1938: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0

1934: --Get the dimension ids for all the dimension level ids-later used to sequence the dimension levels
1935: IF (l_dimension_level_id IS NOT NULL
1936: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN
1937: l_dim_level_rec.dimension_level_id := l_dimension_level_id;
1938: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0
1939: ,p_Dimension_Level_Rec => l_dim_level_rec
1940: ,x_Dimension_Level_Rec => l_dim_level_rec
1941: ,x_return_status => l_return_status
1942: ,x_error_Tbl => l_error_tbl

Line 2020: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0

2016: --Get the dimension ids for all the dimension level ids-later used to sequence the dimension levels
2017: IF (l_dimension_level_id IS NOT NULL
2018: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN
2019: l_dim_level_rec.dimension_level_id := l_dimension_level_id;
2020: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0
2021: ,p_Dimension_Level_Rec => l_dim_level_rec
2022: ,x_Dimension_Level_Rec => l_dim_level_rec
2023: ,x_return_status => l_return_status
2024: ,x_error_Tbl => l_error_tbl

Line 2103: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0

2099: IF (l_dimension_level_id IS NOT NULL
2100: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN
2101: --SetNULL(l_dim_level_rec,l_dim_level_rec);
2102: l_dim_level_rec.dimension_level_id := l_dimension_level_id;
2103: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0
2104: ,p_Dimension_Level_Rec => l_dim_level_rec
2105: ,x_Dimension_Level_Rec => l_dim_level_rec
2106: ,x_return_status => l_return_status
2107: ,x_error_Tbl => l_error_tbl

Line 2184: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0

2180: IF (l_dimension_level_id IS NOT NULL
2181: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN
2182: --SetNULL(l_dim_level_rec,l_dim_level_rec);
2183: l_dim_level_rec.dimension_level_id := l_dimension_level_id;
2184: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0
2185: ,p_Dimension_Level_Rec => l_dim_level_rec
2186: ,x_Dimension_Level_Rec => l_dim_level_rec
2187: ,x_return_status => l_return_status
2188: ,x_error_Tbl => l_error_tbl

Line 2266: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0

2262: IF (l_dimension_level_id IS NOT NULL
2263: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN
2264: --SetNULL(l_dim_level_rec,l_dim_level_rec);
2265: l_dim_level_rec.dimension_level_id := l_dimension_level_id;
2266: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0
2267: ,p_Dimension_Level_Rec => l_dim_level_rec
2268: ,x_Dimension_Level_Rec => l_dim_level_rec
2269: ,x_return_status => l_return_status
2270: ,x_error_Tbl => l_error_tbl

Line 2348: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0

2344: IF (l_dimension_level_id IS NOT NULL
2345: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN
2346: --SetNULL(l_dim_level_rec,l_dim_level_rec);
2347: l_dim_level_rec.dimension_level_id := l_dimension_level_id;
2348: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0
2349: ,p_Dimension_Level_Rec => l_dim_level_rec
2350: ,x_Dimension_Level_Rec => l_dim_level_rec
2351: ,x_return_status => l_return_status
2352: ,x_error_Tbl => l_error_tbl

Line 2430: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0

2426: IF (l_dimension_level_id IS NOT NULL
2427: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN
2428: --SetNULL(l_dim_level_rec,l_dim_level_rec);
2429: l_dim_level_rec.dimension_level_id := l_dimension_level_id;
2430: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => 1.0
2431: ,p_Dimension_Level_Rec => l_dim_level_rec
2432: ,x_Dimension_Level_Rec => l_dim_level_rec
2433: ,x_return_status => l_return_status
2434: ,x_error_Tbl => l_error_tbl