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.

[Home] [Help]

APPS.BIS_PMV_QUERY_PVT dependencies on FND_API

Line 1902: ,p_all_info =>FND_API.G_TRUE

1898: l_measure_rec.measure_short_name := pMeasure_short_name;
1899: --l_measure_rec.measure_id := p_target_level_rec.measure_id;
1900: BIS_MEASURE_PUB.RETRIEVE_MEASURE( p_api_version => 1.0
1901: ,p_measure_rec => l_measure_rec
1902: ,p_all_info =>FND_API.G_TRUE
1903: ,x_measure_rec => l_measure_rec
1904: ,x_return_status => l_return_status
1905: ,x_error_tbl => l_error_tbl
1906: );

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

Line 2494: l_target_level_rec.Dimension1_Level_ID:= NVL(lDim1_level_id ,FND_API.G_MISS_NUM);

2490:
2491: --also return to UOM
2492: l_target_level_rec.Unit_Of_Measure := l_measure_rec.Unit_Of_Measure_Class;
2493:
2494: l_target_level_rec.Dimension1_Level_ID:= NVL(lDim1_level_id ,FND_API.G_MISS_NUM);
2495: l_target_level_rec.Dimension2_Level_ID:= NVL(lDim2_level_id ,FND_API.G_MISS_NUM);
2496: l_target_level_rec.Dimension3_Level_ID:= NVL(lDim3_level_id ,FND_API.G_MISS_NUM);
2497: l_target_level_rec.Dimension4_Level_ID:= NVL(lDim4_level_id ,FND_API.G_MISS_NUM);
2498: l_target_level_rec.Dimension5_Level_ID:= NVL(lDim5_level_id ,FND_API.G_MISS_NUM);

Line 2495: l_target_level_rec.Dimension2_Level_ID:= NVL(lDim2_level_id ,FND_API.G_MISS_NUM);

2491: --also return to UOM
2492: l_target_level_rec.Unit_Of_Measure := l_measure_rec.Unit_Of_Measure_Class;
2493:
2494: l_target_level_rec.Dimension1_Level_ID:= NVL(lDim1_level_id ,FND_API.G_MISS_NUM);
2495: l_target_level_rec.Dimension2_Level_ID:= NVL(lDim2_level_id ,FND_API.G_MISS_NUM);
2496: l_target_level_rec.Dimension3_Level_ID:= NVL(lDim3_level_id ,FND_API.G_MISS_NUM);
2497: l_target_level_rec.Dimension4_Level_ID:= NVL(lDim4_level_id ,FND_API.G_MISS_NUM);
2498: l_target_level_rec.Dimension5_Level_ID:= NVL(lDim5_level_id ,FND_API.G_MISS_NUM);
2499: l_target_level_rec.Dimension6_Level_ID:= NVL(lDim6_level_id ,FND_API.G_MISS_NUM);

Line 2496: l_target_level_rec.Dimension3_Level_ID:= NVL(lDim3_level_id ,FND_API.G_MISS_NUM);

2492: l_target_level_rec.Unit_Of_Measure := l_measure_rec.Unit_Of_Measure_Class;
2493:
2494: l_target_level_rec.Dimension1_Level_ID:= NVL(lDim1_level_id ,FND_API.G_MISS_NUM);
2495: l_target_level_rec.Dimension2_Level_ID:= NVL(lDim2_level_id ,FND_API.G_MISS_NUM);
2496: l_target_level_rec.Dimension3_Level_ID:= NVL(lDim3_level_id ,FND_API.G_MISS_NUM);
2497: l_target_level_rec.Dimension4_Level_ID:= NVL(lDim4_level_id ,FND_API.G_MISS_NUM);
2498: l_target_level_rec.Dimension5_Level_ID:= NVL(lDim5_level_id ,FND_API.G_MISS_NUM);
2499: l_target_level_rec.Dimension6_Level_ID:= NVL(lDim6_level_id ,FND_API.G_MISS_NUM);
2500: l_target_level_rec.Dimension7_Level_ID:= NVL(lDim7_level_id ,FND_API.G_MISS_NUM);

Line 2497: l_target_level_rec.Dimension4_Level_ID:= NVL(lDim4_level_id ,FND_API.G_MISS_NUM);

2493:
2494: l_target_level_rec.Dimension1_Level_ID:= NVL(lDim1_level_id ,FND_API.G_MISS_NUM);
2495: l_target_level_rec.Dimension2_Level_ID:= NVL(lDim2_level_id ,FND_API.G_MISS_NUM);
2496: l_target_level_rec.Dimension3_Level_ID:= NVL(lDim3_level_id ,FND_API.G_MISS_NUM);
2497: l_target_level_rec.Dimension4_Level_ID:= NVL(lDim4_level_id ,FND_API.G_MISS_NUM);
2498: l_target_level_rec.Dimension5_Level_ID:= NVL(lDim5_level_id ,FND_API.G_MISS_NUM);
2499: l_target_level_rec.Dimension6_Level_ID:= NVL(lDim6_level_id ,FND_API.G_MISS_NUM);
2500: l_target_level_rec.Dimension7_Level_ID:= NVL(lDim7_level_id ,FND_API.G_MISS_NUM);
2501:

Line 2498: l_target_level_rec.Dimension5_Level_ID:= NVL(lDim5_level_id ,FND_API.G_MISS_NUM);

2494: l_target_level_rec.Dimension1_Level_ID:= NVL(lDim1_level_id ,FND_API.G_MISS_NUM);
2495: l_target_level_rec.Dimension2_Level_ID:= NVL(lDim2_level_id ,FND_API.G_MISS_NUM);
2496: l_target_level_rec.Dimension3_Level_ID:= NVL(lDim3_level_id ,FND_API.G_MISS_NUM);
2497: l_target_level_rec.Dimension4_Level_ID:= NVL(lDim4_level_id ,FND_API.G_MISS_NUM);
2498: l_target_level_rec.Dimension5_Level_ID:= NVL(lDim5_level_id ,FND_API.G_MISS_NUM);
2499: l_target_level_rec.Dimension6_Level_ID:= NVL(lDim6_level_id ,FND_API.G_MISS_NUM);
2500: l_target_level_rec.Dimension7_Level_ID:= NVL(lDim7_level_id ,FND_API.G_MISS_NUM);
2501:
2502: x_target_level_id := BIS_TARGET_LEVEL_PVT.Get_Level_Id_From_Dimlevels(l_target_level_rec);

Line 2499: l_target_level_rec.Dimension6_Level_ID:= NVL(lDim6_level_id ,FND_API.G_MISS_NUM);

2495: l_target_level_rec.Dimension2_Level_ID:= NVL(lDim2_level_id ,FND_API.G_MISS_NUM);
2496: l_target_level_rec.Dimension3_Level_ID:= NVL(lDim3_level_id ,FND_API.G_MISS_NUM);
2497: l_target_level_rec.Dimension4_Level_ID:= NVL(lDim4_level_id ,FND_API.G_MISS_NUM);
2498: l_target_level_rec.Dimension5_Level_ID:= NVL(lDim5_level_id ,FND_API.G_MISS_NUM);
2499: l_target_level_rec.Dimension6_Level_ID:= NVL(lDim6_level_id ,FND_API.G_MISS_NUM);
2500: l_target_level_rec.Dimension7_Level_ID:= NVL(lDim7_level_id ,FND_API.G_MISS_NUM);
2501:
2502: x_target_level_id := BIS_TARGET_LEVEL_PVT.Get_Level_Id_From_Dimlevels(l_target_level_rec);
2503:

Line 2500: l_target_level_rec.Dimension7_Level_ID:= NVL(lDim7_level_id ,FND_API.G_MISS_NUM);

2496: l_target_level_rec.Dimension3_Level_ID:= NVL(lDim3_level_id ,FND_API.G_MISS_NUM);
2497: l_target_level_rec.Dimension4_Level_ID:= NVL(lDim4_level_id ,FND_API.G_MISS_NUM);
2498: l_target_level_rec.Dimension5_Level_ID:= NVL(lDim5_level_id ,FND_API.G_MISS_NUM);
2499: l_target_level_rec.Dimension6_Level_ID:= NVL(lDim6_level_id ,FND_API.G_MISS_NUM);
2500: l_target_level_rec.Dimension7_Level_ID:= NVL(lDim7_level_id ,FND_API.G_MISS_NUM);
2501:
2502: x_target_level_id := BIS_TARGET_LEVEL_PVT.Get_Level_Id_From_Dimlevels(l_target_level_rec);
2503:
2504: EXCEPTION

Line 3762: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

3758: ,x_msg_data => l_msg_data );
3759: end if;
3760:
3761:
3762: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3763: RETURN;
3764: END IF;
3765:
3766: -- create the param

Line 3793: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

3789: ,x_msg_count => l_msg_count
3790: ,x_msg_Data => l_msg_data );
3791: end if;
3792:
3793: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3794: RETURN;
3795: END IF;
3796:
3797: commit;