DBA Data[Home] [Help]

APPS.BIS_TARGET_LEVEL_PUB dependencies on BIS_TARGET_LEVEL_PVT

Line 45: BIS_Target_Level_PVT.Value_ID_Conversion

41: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
42: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
43: BEGIN
44:
45: BIS_Target_Level_PVT.Value_ID_Conversion
46: ( p_api_version => p_api_version
47: , p_Target_Level_Rec => p_Target_Level_Rec
48: , x_Target_Level_Rec => l_Target_Level_Rec
49: , x_return_status => x_return_status

Line 53: BIS_Target_Level_PVT.Create_Target_Level

49: , x_return_status => x_return_status
50: , x_error_Tbl => x_error_Tbl
51: );
52:
53: BIS_Target_Level_PVT.Create_Target_Level
54: ( p_api_version => p_api_version
55: , p_commit => p_commit
56: , p_Target_Level_Rec => l_Target_Level_Rec
57: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

Line 117: BIS_Target_Level_PVT.Retrieve_Target_Levels

113: , x_error_Tbl => x_error_Tbl
114: );
115: end if;
116:
117: BIS_Target_Level_PVT.Retrieve_Target_Levels
118: ( p_api_version => p_api_version
119: , p_all_info => p_all_info
120: , p_MeasurE_rec => l_Measure_Rec
121: , x_Target_Level_tbl => x_Target_Level_tbl

Line 175: BIS_Target_Level_PVT.Value_ID_Conversion

171: BEGIN
172:
173: l_target_level_rec := p_target_level_rec;
174:
175: BIS_Target_Level_PVT.Value_ID_Conversion
176: ( p_api_version => p_api_version
177: , p_Target_Level_Rec => p_Target_Level_Rec
178: , x_Target_Level_Rec => l_Target_Level_Rec
179: , x_return_status => x_return_status

Line 195: BIS_Target_Level_PVT.Retrieve_Target_Level

191: x_Error_tbl);
192: END IF;
193:
194:
195: BIS_Target_Level_PVT.Retrieve_Target_Level
196: ( p_api_version => p_api_version
197: , p_Target_Level_Rec => l_Target_Level_Rec
198: , p_all_info => p_all_info
199: , x_Target_Level_Rec => x_Target_Level_Rec

Line 251: BIS_Target_Level_PVT.Value_ID_Conversion

247: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
248: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
249: BEGIN
250:
251: BIS_Target_Level_PVT.Value_ID_Conversion
252: ( p_api_version => p_api_version
253: , p_Target_Level_Rec => p_Target_Level_Rec
254: , x_Target_Level_Rec => l_Target_Level_Rec
255: , x_return_status => x_return_status

Line 259: BIS_Target_Level_PVT.Update_Target_Level

255: , x_return_status => x_return_status
256: , x_error_Tbl => x_error_Tbl
257: );
258:
259: BIS_Target_Level_PVT.Update_Target_Level
260: ( p_api_version => p_api_version
261: , p_commit => p_commit
262: , p_Target_Level_Rec => l_Target_Level_Rec
263: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

Line 310: BIS_Target_Level_PVT.Value_ID_Conversion

306: if ( BIS_UTILITIES_PUB.Value_Missing
307: (p_Target_Level_Rec.Target_Level_id) = FND_API.G_TRUE
308: OR BIS_UTILITIES_PUB.Value_NULL
309: (p_Target_Level_Rec.Target_Level_id) = FND_API.G_TRUE) then
310: BIS_Target_Level_PVT.Value_ID_Conversion
311: ( p_api_version
312: , p_Target_Level_Rec.Target_Level_Short_Name
313: , p_Target_Level_Rec.Target_Level_Name
314: , l_Target_Level_Rec.Target_Level_ID

Line 320: BIS_Target_Level_PVT.Delete_Target_Level

316: , x_error_Tbl
317: );
318: end if;
319:
320: BIS_Target_Level_PVT.Delete_Target_Level
321: ( p_api_version => p_api_version
322: , p_commit => p_commit
323: , p_Target_Level_Rec => l_Target_Level_Rec
324: , x_return_status => x_return_status

Line 362: BIS_Target_Level_PVT.Value_ID_Conversion

358: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
359: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
360: BEGIN
361:
362: BIS_Target_Level_PVT.Value_ID_Conversion
363: ( p_api_version => p_api_version
364: , p_Target_Level_Rec => p_Target_Level_Rec
365: , x_Target_Level_Rec => l_Target_Level_Rec
366: , x_return_status => x_return_status

Line 370: BIS_Target_Level_PVT.Validate_Target_Level

366: , x_return_status => x_return_status
367: , x_error_Tbl => x_error_Tbl
368: );
369:
370: BIS_Target_Level_PVT.Validate_Target_Level
371: ( p_api_version => p_api_version
372: , p_Target_Level_Rec => p_Target_Level_Rec
373: , x_return_status => x_return_status
374: , x_error_Tbl => x_error_Tbl

Line 468: BIS_Target_Level_PVT.Retrieve_User_Target_Levels

464:
465: end if;
466:
467: --passed in l_user_id instead of p_user_id
468: BIS_Target_Level_PVT.Retrieve_User_Target_Levels
469: ( p_api_version
470: , l_user_id
471: , p_all_info
472: , x_Target_Level_Tbl

Line 513: BIS_TARGET_LEVEL_PVT.Value_ID_Conversion

509: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
510: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
511: BEGIN
512:
513: BIS_TARGET_LEVEL_PVT.Value_ID_Conversion
514: ( p_api_version => p_api_version
515: , p_Target_Level_Rec => p_Target_Level_Rec
516: , x_Target_Level_Rec => l_Target_Level_Rec
517: , x_return_status => x_return_status

Line 535: BIS_TARGET_LEVEL_PVT.Translate_Target_Level

531: );
532: RAISE FND_API.G_EXC_ERROR;
533: end if;
534:
535: BIS_TARGET_LEVEL_PVT.Translate_Target_Level
536: ( p_api_version => p_api_version
537: , p_commit => p_commit
538: , p_validation_level => p_validation_level
539: , p_Target_Level_Rec => l_Target_Level_Rec

Line 585: BIS_TARGET_LEVEL_PVT.Value_ID_Conversion

581: BEGIN
582:
583: l_Target_Level_Rec := p_Target_Level_Rec;
584:
585: BIS_TARGET_LEVEL_PVT.Value_ID_Conversion
586: ( p_api_version => p_api_version
587: , p_Target_Level_Rec => p_Target_Level_Rec
588: , x_Target_Level_Rec => l_Target_Level_Rec
589: , x_return_status => x_return_status

Line 593: BIS_TARGET_LEVEL_PVT.Validate_Dimensions -- 2486702

589: , x_return_status => x_return_status
590: , x_error_Tbl => x_error_tbl
591: );
592:
593: BIS_TARGET_LEVEL_PVT.Validate_Dimensions -- 2486702
594: (
595: p_target_level_rec => l_Target_Level_Rec
596: , x_return_status => l_return_status
597: , x_return_msg => l_return_msg

Line 604: BIS_TARGET_LEVEL_PVT.Update_Target_Level

600: IF ( l_return_status <> 'S' ) THEN -- 2486702
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:
604: BIS_TARGET_LEVEL_PVT.Update_Target_Level
605: ( p_api_version => p_api_version
606: , p_commit => p_commit
607: , p_validation_level => p_validation_level
608: , p_Target_Level_Rec => l_Target_Level_Rec

Line 617: BIS_TARGET_LEVEL_PVT.Create_Target_Level

613: );
614:
615: IF x_return_status = FND_API.G_RET_STS_ERROR then
616:
617: BIS_TARGET_LEVEL_PVT.Create_Target_Level
618: ( p_api_version => p_api_version
619: , p_commit => p_commit
620: , p_validation_level => p_validation_level
621: , p_Target_Level_Rec => l_Target_Level_Rec

Line 656: l_target_level_id :=BIS_TARGET_LEVEL_PVT.Get_Id_From_DimLevelShortNames(p_target_level_rec);

652: ) RETURN NUMBER
653: IS
654: l_target_level_id NUMBER;
655: BEGIN
656: l_target_level_id :=BIS_TARGET_LEVEL_PVT.Get_Id_From_DimLevelShortNames(p_target_level_rec);
657: return l_target_level_id;
658: END Get_Id_From_DimLevelShortNames;
659:
660: -- New Procedure to return TargetLevel given the DimensionLevel ShortNames in any sequence

Line 674: BIS_Target_Level_PVT.Retrieve_TL_From_DimLvlShNms

670: IS
671: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
672:
673: BEGIN
674: BIS_Target_Level_PVT.Retrieve_TL_From_DimLvlShNms
675: (
676: p_api_version => p_api_version
677: , p_Target_Level_Rec => p_Target_Level_Rec
678: , x_Target_Level_Rec => x_Target_Level_Rec

Line 709: BIS_TARGET_LEVEL_PVT.updt_tl_attributes(p_tl_short_name => p_tl_short_name

705: PROCEDURE updt_tl_attributes(p_tl_short_name IN VARCHAR2
706: ,p_tl_new_short_name IN VARCHAR2
707: ,x_return_status OUT NOCOPY VARCHAR2) AS
708: BEGIN
709: BIS_TARGET_LEVEL_PVT.updt_tl_attributes(p_tl_short_name => p_tl_short_name
710: ,p_tl_new_short_name => p_tl_new_short_name
711: ,x_return_status => x_return_status);
712: EXCEPTION
713: WHEN OTHERS THEN