DBA Data[Home] [Help]

APPS.BIS_ACTUAL_PVT dependencies on BIS_TARGET_LEVEL_PUB

Line 22: IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

18: PROCEDURE Retrieve_User_Selections
19: ( p_api_version IN NUMBER
20: ,p_all_info IN VARCHAR2 := FND_API.G_TRUE
21: ,p_Target_Level_Rec
22: IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
23: ,x_Indicator_Region_Tbl
24: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type
25: ,x_return_status OUT NOCOPY VARCHAR2
26: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 31: l_target_level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

27: )
28: IS
29: i NUMBER := 0;
30: l_Target_Level_id NUMBER;
31: l_target_level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
32: l_Indicator_Region_Rec BIS_INDICATOR_REGION_PUB.Indicator_Region_rec_Type;
33:
34: CURSOR cr_user_selections IS
35: SELECT DISTINCT TARGET_LEVEL_ID

Line 54: BIS_TARGET_LEVEL_PUB.Retrieve_Target_Level

50: IF BIS_UTILITIES_PUB.Value_Missing (p_Target_Level_Rec.Target_Level_ID)
51: = FND_API.G_TRUE
52: THEN
53:
54: BIS_TARGET_LEVEL_PUB.Retrieve_Target_Level
55: ( p_api_version => 1.0
56: , p_Target_Level_Rec => p_Target_Level_Rec
57: , p_all_info => FND_API.G_FALSE
58: , x_Target_Level_Rec => l_Target_level_Rec

Line 97: IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

93: -- given target_level
94:
95: PROCEDURE Retrieve_tl_selections
96: ( p_Target_Level_Rec
97: IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
98: ,x_Indicator_Region_Tbl
99: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type
100: ,x_return_status OUT NOCOPY VARCHAR2
101: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 391: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

387: )
388: IS
389:
390: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
391: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
392: l_Target_Level_Rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
393: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
394:
395:

Line 392: l_Target_Level_Rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

388: IS
389:
390: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
391: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
392: l_Target_Level_Rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
393: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
394:
395:
396: CURSOR cr_bv_actual (p_actual_rec BIS_ACTUAL_PUB.ACTUAL_Rec_Type) IS

Line 612: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

608: -- to FALSE.
609: PROCEDURE Retrieve_Actuals
610: ( p_api_version IN NUMBER
611: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
612: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
613: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
614: ,x_return_status OUT NOCOPY VARCHAR2
615: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
616: )

Line 660: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

656: -- to FALSE.
657: PROCEDURE Retrieve_Latest_Actuals
658: ( p_api_version IN NUMBER
659: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
660: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
661: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
662: ,x_return_status OUT NOCOPY VARCHAR2
663: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
664: )

Line 1139: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

1135: IS
1136: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1137: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1138: l_Dim_Level_Value_Rec2 BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1139: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
1140: l_Target_Level_Rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
1141: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
1142: BEGIN
1143:

Line 1140: l_Target_Level_Rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;

1136: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1137: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1138: l_Dim_Level_Value_Rec2 BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1139: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
1140: l_Target_Level_Rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
1141: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
1142: BEGIN
1143:
1144: x_return_status := FND_API.G_RET_STS_SUCCESS;