272: );
273: RAISE FND_API.G_EXC_ERROR;
274: end if;
275: */
276: BIS_DIMENSION_LEVEL_PVT.Retrieve_Dimension_Levels
277: ( p_api_version => 1.0
278: , p_Dimension_Rec => l_Dimension_Rec
279: , x_Dimension_Level_Tbl => x_Dimension_Level_Tbl
280: , x_return_status => x_return_status
313: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
314: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
315: BEGIN
316:
317: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
318: ( p_api_version => 1.0
319: , p_Dimension_Level_Rec => p_Dimension_Level_Rec
320: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
321: , x_return_status => x_return_status
335: );
336: RAISE FND_API.G_EXC_ERROR;
337: end if;
338:
339: BIS_DIMENSION_LEVEL_PVT.Retrieve_Dimension_Level
340: ( p_api_version => 1.0
341: , p_Dimension_Level_Rec => l_Dimension_Level_Rec
342: , x_Dimension_Level_Rec => x_Dimension_Level_Rec
343: , x_return_status => x_return_status
379: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
380: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
381: BEGIN
382:
383: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
384: ( p_api_version => p_api_version
385: , p_Dimension_Level_Rec => p_Dimension_Level_Rec
386: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
387: , x_return_status => x_return_status
402: RAISE FND_API.G_EXC_ERROR;
403: end if;
404:
405: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);
406: BIS_DIMENSION_LEVEL_PVT.Translate_Dimension_Level
407: ( p_api_version => p_api_version
408: , p_commit => p_commit
409: , p_validation_level => p_validation_level
410: , p_Dimension_Level_Rec => l_Dimension_Level_Rec
455: l_Dimension_level_Rec := p_Dimension_level_Rec;
456:
457: BEGIN
458:
459: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
460: ( p_api_version => p_api_version
461: , p_Dimension_Level_Rec => p_Dimension_Level_Rec
462: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
463: , x_return_status => x_return_status
496: ,x_return_status => x_return_status
497: ,x_msg_data => l_return_msg
498: );
499: IF (l_ret_code) THEN
500: BIS_DIMENSION_LEVEL_PVT.Update_Dimension_Level
501: ( p_api_version => p_api_version
502: , p_commit => p_commit
503: , p_validation_level => p_validation_level
504: , p_Dimension_Level_Rec => l_Dimension_Level_Rec
507: , x_error_Tbl => x_error_Tbl
508: );
509: END IF;
510: ELSE
511: BIS_DIMENSION_LEVEL_PVT.Create_Dimension_Level
512: ( p_api_version => p_api_version
513: , p_commit => p_commit
514: , p_validation_level => p_validation_level
515: , p_Dimension_Level_Rec => l_Dimension_Level_Rec
565: IS
566: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
567: BEGIN
568:
569: BIS_DIMENSION_LEVEL_PVT.Create_Dimension_Level
570: (
571: p_api_version => p_api_version
572: , p_commit => p_commit
573: , p_validation_level => p_validation_level
605: IS
606: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
607: BEGIN
608:
609: BIS_DIMENSION_LEVEL_PVT.Update_Dimension_Level
610: (
611: p_api_version => p_api_version
612: , p_commit => p_commit
613: , p_validation_level => p_validation_level
643: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
644: ) IS
645: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
646: BEGIN
647: BIS_DIMENSION_LEVEL_PVT.Delete_Dimension_Level
648: (
649: p_commit => p_commit
650: , p_validation_level => p_validation_level
651: , p_Dimension_Level_Rec => p_Dimension_Level_Rec
1025: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1026: ) IS
1027: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1028: BEGIN
1029: BIS_DIMENSION_LEVEL_PVT.Trans_DimObj_By_Given_Lang
1030: (
1031: p_commit => p_commit
1032: , p_validation_level => p_validation_level
1033: , p_Dimension_Level_Rec => p_Dimension_Level_Rec
1267:
1268: -- get customized values for name , description and enabled
1269: FUNCTION get_customized_name( p_dim_level_id IN NUMBER) RETURN VARCHAR2 AS
1270: BEGIN
1271: RETURN BIS_DIMENSION_LEVEL_PVT.get_customized_name( p_dim_level_id => p_dim_level_id);
1272: END get_customized_name;
1273:
1274: FUNCTION get_customized_description( p_dim_level_id IN NUMBER) RETURN VARCHAR2 AS
1275: BEGIN
1272: END get_customized_name;
1273:
1274: FUNCTION get_customized_description( p_dim_level_id IN NUMBER) RETURN VARCHAR2 AS
1275: BEGIN
1276: RETURN BIS_DIMENSION_LEVEL_PVT.get_customized_description( p_dim_level_id => p_dim_level_id);
1277: END get_customized_description;
1278:
1279: FUNCTION get_customized_enabled( p_dim_level_id IN NUMBER) RETURN VARCHAR2 AS
1280: BEGIN
1277: END get_customized_description;
1278:
1279: FUNCTION get_customized_enabled( p_dim_level_id IN NUMBER) RETURN VARCHAR2 AS
1280: BEGIN
1281: RETURN BIS_DIMENSION_LEVEL_PVT.get_customized_enabled( p_dim_level_id => p_dim_level_id);
1282: END get_customized_enabled;
1283:
1284: FUNCTION get_customized_enabled( p_dim_level_sht_name IN VARCHAR2) RETURN VARCHAR2 AS
1285: BEGIN
1282: END get_customized_enabled;
1283:
1284: FUNCTION get_customized_enabled( p_dim_level_sht_name IN VARCHAR2) RETURN VARCHAR2 AS
1285: BEGIN
1286: RETURN BIS_DIMENSION_LEVEL_PVT.get_customized_enabled( p_dim_level_sht_name => p_dim_level_sht_name);
1287: END get_customized_enabled;
1288:
1289: PROCEDURE validate_disabling (p_dim_level_id IN NUMBER) IS
1290: BEGIN
1287: END get_customized_enabled;
1288:
1289: PROCEDURE validate_disabling (p_dim_level_id IN NUMBER) IS
1290: BEGIN
1291: BIS_DIMENSION_LEVEL_PVT.validate_disabling(p_dim_level_id => p_dim_level_id );
1292: END validate_disabling;
1293:
1294: Procedure Retrieve_Dim_Level_Cust_Wrap
1295: ( p_dim_level_short_name IN VARCHAR2
1350: END IF;
1351:
1352: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_dim_obj_short_name;
1353:
1354: BIS_Dimension_Level_PVT.Retrieve_Dimension_Level
1355: ( p_api_version => 1.0
1356: , p_Dimension_Level_Rec => l_Dimension_Level_Rec
1357: , x_Dimension_Level_Rec => x_Dimension_Level_Rec
1358: , x_return_status => x_return_status
1360: );
1361:
1362: x_Dimension_Level_Rec.Hide := p_Hide;
1363:
1364: BIS_Dimension_Level_PVT.Update_Dimension_Level
1365: ( p_api_version => 1.0
1366: , p_Dimension_Level_Rec => x_Dimension_Level_Rec
1367: , x_return_status => x_return_status
1368: , x_error_Tbl => l_error_tbl