[Home] [Help]
PACKAGE: APPS.BIS_INDICATOR_REGION_PUB
Source
1 package BIS_INDICATOR_REGION_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPREGS.pls 115.29 2003/01/30 09:09:01 sugopal ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_INDICATOR_REGION_PUB';
5
6 TYPE Indicator_Region_Rec_Type IS RECORD (
7 Ind_Selection_ID NUMBER
8 , Plug_ID NUMBER
9 , User_ID NUMBER
10 , User_Name VARCHAR2(100)
11 , Responsibility_ID NUMBER
12 , Responsibility_Short_Name VARCHAR2(100)
13 , Responsibility_Name VARCHAR2(240)
14 , Target_Level_ID NUMBER
15 , Target_Level_Short_Name VARCHAR2(80)
16 , Target_Level_Name VARCHAR2(100)
17 , Label VARCHAR2(40)
18 , Org_Level_Value_ID VARCHAR2(250)
19 , Org_Level_Value_Name VARCHAR2(250)
20 , Dim1_Level_Value_ID VARCHAR2(250)
21 , Dim1_Level_Value_Name VARCHAR2(250)
22 , Dim2_Level_Value_ID VARCHAR2(250)
23 , Dim2_Level_Value_Name VARCHAR2(250)
24 , Dim3_Level_Value_ID VARCHAR2(250)
25 , Dim3_Level_Value_Name VARCHAR2(250)
26 , Dim4_Level_Value_ID VARCHAR2(250)
27 , Dim4_Level_Value_Name VARCHAR2(250)
28 , Dim5_Level_Value_ID VARCHAR2(250)
29 -- mdamle 01/15/2001 - Add Dim6 and Dim7
30 , Dim5_Level_Value_Name VARCHAR2(250)
31 , Dim6_Level_Value_ID VARCHAR2(250)
32 , Dim6_Level_Value_Name VARCHAR2(250)
33 , Dim7_Level_Value_ID VARCHAR2(250)
34 , Dim7_Level_Value_Name VARCHAR2(250)
35 , Plan_ID NUMBER
36 , Plan_Short_Name VARCHAR2(30)
37 , Plan_Name VARCHAR2(80)
38 -- 2400589, , rank_level_short_name VARCHAR2(30) := NULL
39 , rank_level_short_name VARCHAR2(80)
40 , rank_on_change VARCHAR2(1)
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,
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,
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,
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;
75
76 G_MISS_IND_REGION_REC Indicator_Region_Rec_Type;
77 G_MISS_IND_REGION_TBL Indicator_Region_Tbl_Type;
78
79
80 Procedure Create_User_Ind_Selection(
81 p_api_version IN NUMBER,
82 p_Indicator_Region_Rec
83 IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
86
87 Procedure Retrieve_User_Ind_Selections(
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,
106 x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
107
108
109 Procedure Update_User_Ind_Selection(
110 p_api_version IN NUMBER,
111 p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
112 p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
113 p_plug_id IN NUMBER ,
114 p_Indicator_Region_Tbl
115 IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
118
119
120
121 Procedure Delete_User_Ind_Selections(
122 p_api_version IN NUMBER,
123 p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
124 p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
125 p_plug_id IN NUMBER,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
128
129
130 END BIS_INDICATOR_REGION_PUB;