APPS.BIS_PMV_QUERY_PVT dependencies on BIS_UTILITIES_PUB

Line 1765: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

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;
1768: l_no_target boolean := false;
1769:

Line 1927: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN

1923: end if;
1924:
1925: --Step 2 , get the dimension level id
1926: IF (l_dimension_level_short_name IS NOT NULL
1927: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN
1928: OPEN c_dim_lvl(l_dimension_level_short_name);
1929: FETCH c_dim_lvl INTO l_dimension_level_id;
1930: CLOSE c_dim_lvl;
1931: END IF;

Line 1936: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN

1932:
1933: --STEP 3
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

Line 2009: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN

2005:
2006:
2007: --Step 2 , get the dimension level id
2008: IF (l_dimension_level_short_name IS NOT NULL
2009: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN
2010: OPEN c_dim_lvl(l_dimension_level_short_name);
2011: FETCH c_dim_lvl INTO l_dimension_level_id;
2012: CLOSE c_dim_lvl;
2013: END IF;

Line 2018: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN

2014:
2015: --STEP 3
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

Line 2091: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN

2087: end if;
2088:
2089: --Step 2 , get the dimension level id
2090: IF (l_dimension_level_short_name IS NOT NULL
2091: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN
2092: OPEN c_dim_lvl(l_dimension_level_short_name);
2093: FETCH c_dim_lvl INTO l_dimension_level_id;
2094: CLOSE c_dim_lvl;
2095: END IF;

Line 2100: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN

2096:
2097: --STEP 3
2098: --Get the dimension ids for all the dimension level ids-later used to sequence the dimension levels
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

Line 2172: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN

2168: end if;
2169:
2170: --Step 2 , get the dimension level id
2171: IF (l_dimension_level_short_name IS NOT NULL
2172: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN
2173: OPEN c_dim_lvl(l_dimension_level_short_name);
2174: FETCH c_dim_lvl INTO l_dimension_level_id;
2175: CLOSE c_dim_lvl;
2176: END IF;

Line 2181: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN

2177:
2178: --STEP 3
2179: --Get the dimension ids for all the dimension level ids-later used to sequence the dimension levels
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

Line 2254: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN

2250: end if;
2251:
2252: --Step 2 , get the dimension level id
2253: IF (l_dimension_level_short_name IS NOT NULL
2254: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN
2255: OPEN c_dim_lvl(l_dimension_level_short_name);
2256: FETCH c_dim_lvl INTO l_dimension_level_id;
2257: CLOSE c_dim_lvl;
2258: END IF;

Line 2263: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN

2259:
2260: --STEP 3
2261: --Get the dimension ids for all the dimension level ids-later used to sequence the dimension levels
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

Line 2336: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN

2332: end if;
2333:
2334: --Step 2 , get the dimension level id
2335: IF (l_dimension_level_short_name IS NOT NULL
2336: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN
2337: OPEN c_dim_lvl(l_dimension_level_short_name);
2338: FETCH c_dim_lvl INTO l_dimension_level_id;
2339: CLOSE c_dim_lvl;
2340: END IF;

Line 2345: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN

2341:
2342: --STEP 3
2343: --Get the dimension ids for all the dimension level ids-later used to sequence the dimension levels
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

Line 2418: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN

2414: end if;
2415:
2416: --Step 2 , get the dimension level id
2417: IF (l_dimension_level_short_name IS NOT NULL
2418: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_short_name) = FND_API.G_TRUE) THEN
2419: OPEN c_dim_lvl(l_dimension_level_short_name);
2420: FETCH c_dim_lvl INTO l_dimension_level_id;
2421: CLOSE c_dim_lvl;
2422: END IF;

Line 2427: AND BIS_UTILITIES_PUB.Value_Not_Missing(l_dimension_level_id)= FND_API.G_TRUE) THEN

2423:
2424: --STEP 3
2425: --Get the dimension ids for all the dimension level ids-later used to sequence the dimension levels
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