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
27: )
28: IS
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
36: ,ORGANIZATION_ID
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
102: )
103: IS
102: )
103: IS
104: i NUMBER := 0;
105: l_Target_Level_id NUMBER;
106: l_Indicator_Region_Rec BIS_INDICATOR_REGION_PUB.Indicator_Region_rec_Type;
107:
108: CURSOR cr_tl_selections IS
109: SELECT distinct TARGET_LEVEL_ID
110: ,PLAN_ID