41: );
42:
43: /*
44: TYPE Indicator_Region_Rec_Type IS RECORD (
45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
42:
43: /*
44: TYPE Indicator_Region_Rec_Type IS RECORD (
45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
43: /*
44: TYPE Indicator_Region_Rec_Type IS RECORD (
45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: TYPE Indicator_Region_Rec_Type IS RECORD (
45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);
71: */
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);
71: */
72:
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);
71: */
72:
73: TYPE Indicator_Region_Tbl_Type IS TABLE of Indicator_Region_Rec_Type
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);
71: */
72:
73: TYPE Indicator_Region_Tbl_Type IS TABLE of Indicator_Region_Rec_Type
74: INDEX BY BINARY_INTEGER;
88: p_api_version IN NUMBER,
89: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
90: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
91: p_plug_id IN NUMBER,
92: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
93: x_Indicator_Region_Tbl
94: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
97:
98:
99: Procedure Retrieve_User_Ind_Selections(
100: p_api_version IN NUMBER,
101: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
102: p_Target_level_rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type,
103: x_Indicator_Region_Tbl
104: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
105: x_return_status OUT NOCOPY VARCHAR2,