[Home] [Help]
PACKAGE: APPS.BSC_DIMENSION_SETS_PUB
Source
1 package BSC_DIMENSION_SETS_PUB as
2 /* $Header: BSCPDMSS.pls 120.0 2005/06/01 16:14:11 appldev noship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCPDMSS.pls |
10 | |
11 | Creation Date: |
12 | October 9, 2001 |
13 | |
14 | Creator: |
15 | Mario-Jair Campos |
16 | |
17 | Description: |
18 | Public specs for package. |
19 | This Package creates a Dimension Set in BSC. |
20 | |
21 | PAJOHRI 21-MAR-2003 Added Bsc_Dim_Set_Rec_Type.Bsc_View_Name |
22 | Added Bsc_Dim_Set_Rec_Type.Bsc_Analysis_Id |
23 | 19-SEP-2003 ADRAO Added API Reorder_Dim_Level |
24 | 18-JUN-2004 ADRAO Modified Record Bsc_Dim_Set_Rec_Type to |
25 | accomodate BSC_KPI_DIM_SETS_TL.SHORT_NAME |
26 | 07-DEC-2004 ADRAO Added constants C_REL_ONE_TO_MANY and |
27 | C_REL_MANY_TO_MANY for Bug4052221 |
28 +======================================================================================+
29 */
30
31 C_REL_ONE_TO_MANY CONSTANT NUMBER := 1;
32 C_REL_MANY_TO_MANY CONSTANT NUMBER := 2;
33
34 TYPE Bsc_Dim_Set_Rec_Type is RECORD
35 (
36 Bsc_Action VARCHAR2(10)
37 , Bsc_Dim_Comp_Disp_Name BSC_KPI_DIM_LEVELS_TL.Comp_Disp_Name%TYPE
38 , Bsc_Dim_Level_Group_Id BSC_KPI_DIM_GROUPS.dim_group_id%TYPE
39 , Bsc_Dim_Level_Group_Index BSC_KPI_DIM_GROUPS.dim_group_index%TYPE
40 , Bsc_Dim_Level_Help BSC_KPI_DIM_LEVELS_TL.Help%TYPE
41 , Bsc_Dim_Level_Long_Name BSC_KPI_DIM_LEVELS_TL.Name%TYPE
42 , Bsc_Dim_Set_Id BSC_KPI_DIM_SETS_TL.dim_set_id%TYPE
43 , Bsc_Dim_Set_Name BSC_KPI_DIM_SETS_TL.name%TYPE
44 , Bsc_Dim_Tot_Disp_Name BSC_KPI_DIM_LEVELS_TL.Comp_Disp_Name%TYPE
45 , Bsc_Dset_Comp_Order BSC_KPI_DIM_LEVELS_B.comp_order_by%TYPE
46 , Bsc_Dset_Default_Key_Value BSC_KPI_DIM_LEVELS_B.default_key_value%TYPE
47 , Bsc_Dset_Default_Type BSC_KPI_DIM_LEVELS_B.default_type%TYPE
48 , Bsc_Dset_Default_Value BSC_KPI_DIM_LEVELS_B.default_value%TYPE
49 , Bsc_Dset_Dim_Level_Index BSC_KPI_DIM_LEVELS_B.dim_level_index%TYPE
50 , Bsc_Dset_Filter_Column BSC_KPI_DIM_LEVELS_B.filter_column%TYPE
51 , Bsc_Dset_Filter_Value BSC_KPI_DIM_LEVELS_B.filter_value%TYPE
52 , Bsc_Dset_Level_Display BSC_KPI_DIM_LEVELS_B.level_display%TYPE
53 , Bsc_Dset_No_Items BSC_KPI_DIM_LEVELS_B.no_items%TYPE
54 , Bsc_Dset_Parent_In_Total BSC_KPI_DIM_LEVELS_B.parent_in_total%TYPE
55 , Bsc_Dset_Parent_Level_Index BSC_KPI_DIM_LEVELS_B.parent_level_index%TYPE
56 , Bsc_Dset_Parent_Level_Index2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%TYPE
57 , Bsc_Dset_Parent_Level_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%TYPE
58 , Bsc_Dset_Parent_Level_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%TYPE
59 , Bsc_Dset_Position BSC_KPI_DIM_LEVELS_B.position%TYPE
60 , Bsc_Dset_Status BSC_KPI_DIM_LEVELS_B.status%TYPE
61 , Bsc_Dset_Target_Level BSC_KPI_DIM_LEVELS_B.target_level%TYPE
62 , Bsc_Dset_Table_Relation BSC_KPI_DIM_LEVELS_B.table_relation%TYPE
63 , Bsc_Dset_Total0 BSC_KPI_DIM_LEVELS_B.total0%TYPE
64 , Bsc_Dset_User_Level0 BSC_KPI_DIM_LEVELS_B.user_level0%TYPE
65 , Bsc_Dset_User_Level1 BSC_KPI_DIM_LEVELS_B.user_level1%TYPE
66 , Bsc_Dset_User_Level1_Default BSC_KPI_DIM_LEVELS_B.user_level1_default%TYPE
67 , Bsc_Dset_User_Level2 BSC_KPI_DIM_LEVELS_B.user_level2%TYPE
68 , Bsc_Dset_User_Level2_Default BSC_KPI_DIM_LEVELS_B.user_level2_default%TYPE
69 , Bsc_Dset_Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%TYPE
70 , Bsc_Kpi_Id BSC_KPIS_B.Indicator%TYPE
71 , Bsc_Language VARCHAR2(5)
72 , Bsc_Level_Id BSC_KPI_DIM_LEVEL_PROPERTIES.dim_level_id%TYPE
73 , Bsc_Level_Name BSC_KPI_DIM_LEVELS_B.level_table_name%TYPE
74 , Bsc_New_Dset VARCHAR2(1)
75 , Bsc_Option_Id BSC_KPI_ANALYSIS_OPTIONS_B.option_id%TYPE
76 , Bsc_Pk_Col BSC_KPI_DIM_LEVELS_B.level_pk_col%TYPE
77 , Bsc_Source_Language VARCHAR2(5)
78 , Bsc_View_Name BSC_KPI_DIM_LEVELS_B.level_view_name%TYPE
79 , Bsc_Analysis_Id BSC_KPI_ANALYSIS_OPTIONS_B.Analysis_Group_Id%TYPE
80 -- PMD
81 , Bsc_Created_By NUMBER -- PMD WHO COLUMN
82 , Bsc_Creation_Date DATE -- PMD WHO COLUMN
83 , Bsc_Last_Updated_By NUMBER -- PMD WHO COLUMN
84 , Bsc_Last_Update_Date DATE -- PMD WHO COLUMN
85 , Bsc_Last_Update_Login NUMBER -- PMD WHO COLUMN
86 , Bsc_Dim_Set_Short_Name BSC_KPI_DIM_SETS_TL.SHORT_NAME%TYPE
87 );
88
89 TYPE Bsc_Dim_Set_Tbl_Type IS TABLE OF Bsc_Dim_Set_Rec_Type
90 INDEX BY BINARY_INTEGER;
91
92
93 procedure Create_Dim_Group_In_Dset(
94 p_commit IN varchar2 := FND_API.G_FALSE
95 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
96 ,x_return_status OUT NOCOPY varchar2
97 ,x_msg_count OUT NOCOPY number
98 ,x_msg_data OUT NOCOPY varchar2
99 );
100
101 procedure Retrieve_Dim_Group_In_Dset(
102 p_commit IN varchar2 := FND_API.G_FALSE
103 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
104 ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
105 ,x_return_status OUT NOCOPY varchar2
106 ,x_msg_count OUT NOCOPY number
107 ,x_msg_data OUT NOCOPY varchar2
108 );
109
110 procedure Update_Dim_Group_In_Dset(
111 p_commit IN varchar2 := FND_API.G_FALSE
112 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
113 ,x_return_status OUT NOCOPY varchar2
114 ,x_msg_count OUT NOCOPY number
115 ,x_msg_data OUT NOCOPY varchar2
116 );
117
118 procedure Delete_Dim_Group_In_Dset(
119 p_commit IN varchar2 := FND_API.G_FALSE
120 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
121 ,x_return_status OUT NOCOPY varchar2
122 ,x_msg_count OUT NOCOPY number
123 ,x_msg_data OUT NOCOPY varchar2
124 );
125
126 procedure Create_Bsc_Kpi_Dim_Sets_Tl(
127 p_commit IN varchar2 := FND_API.G_FALSE
128 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
129 ,x_return_status OUT NOCOPY varchar2
130 ,x_msg_count OUT NOCOPY number
131 ,x_msg_data OUT NOCOPY varchar2
132 );
133
134 procedure Retrieve_Bsc_Kpi_Dim_Sets_Tl(
135 p_commit IN varchar2 := FND_API.G_FALSE
136 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
137 ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
138 ,x_return_status OUT NOCOPY varchar2
139 ,x_msg_count OUT NOCOPY number
140 ,x_msg_data OUT NOCOPY varchar2
141 );
142
143 procedure Update_Bsc_Kpi_Dim_Sets_Tl(
144 p_commit IN varchar2 := FND_API.G_FALSE
145 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
146 ,x_return_status OUT NOCOPY varchar2
147 ,x_msg_count OUT NOCOPY number
148 ,x_msg_data OUT NOCOPY varchar2
149 );
150
151 procedure Delete_Bsc_Kpi_Dim_Sets_Tl(
152 p_commit IN varchar2 := FND_API.G_FALSE
153 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
154 ,x_return_status OUT NOCOPY varchar2
155 ,x_msg_count OUT NOCOPY number
156 ,x_msg_data OUT NOCOPY varchar2
157 );
158
159 procedure Create_Dim_Level_Properties(
160 p_commit IN varchar2 := FND_API.G_FALSE
161 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
162 ,x_return_status OUT NOCOPY varchar2
163 ,x_msg_count OUT NOCOPY number
164 ,x_msg_data OUT NOCOPY varchar2
165 );
166
167 procedure Retrieve_Dim_Level_Properties(
168 p_commit IN varchar2 := FND_API.G_FALSE
169 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
170 ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
171 ,x_return_status OUT NOCOPY varchar2
172 ,x_msg_count OUT NOCOPY number
173 ,x_msg_data OUT NOCOPY varchar2
174 );
175
176 procedure Update_Dim_Level_Properties(
177 p_commit IN varchar2 := FND_API.G_FALSE
178 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
179 ,x_return_status OUT NOCOPY varchar2
180 ,x_msg_count OUT NOCOPY number
181 ,x_msg_data OUT NOCOPY varchar2
182 );
183
184 procedure Delete_Dim_Level_Properties(
185 p_commit IN varchar2 := FND_API.G_FALSE
186 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
187 ,x_return_status OUT NOCOPY varchar2
188 ,x_msg_count OUT NOCOPY number
189 ,x_msg_data OUT NOCOPY varchar2
190 );
191
192 procedure Reorder_Dim_Levels
193 (
194 p_commit IN VARCHAR2 := FND_API.G_FALSE
195 , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
196 , x_return_status OUT NOCOPY VARCHAR2
197 , x_msg_count OUT NOCOPY NUMBER
198 , x_msg_data OUT NOCOPY VARCHAR2
199 ) ;
200
201 procedure Create_Dim_Levels(
202 p_commit IN varchar2 := FND_API.G_FALSE
203 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
204 ,x_return_status OUT NOCOPY varchar2
205 ,x_msg_count OUT NOCOPY number
206 ,x_msg_data OUT NOCOPY varchar2
207 );
208
209 procedure Retrieve_Dim_Levels(
210 p_commit IN varchar2 := FND_API.G_FALSE
211 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
212 ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
213 ,x_return_status OUT NOCOPY varchar2
214 ,x_msg_count OUT NOCOPY number
215 ,x_msg_data OUT NOCOPY varchar2
216 );
217
218 procedure Update_Dim_Levels(
219 p_commit IN varchar2 := FND_API.G_FALSE
220 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
221 ,x_return_status OUT NOCOPY varchar2
222 ,x_msg_count OUT NOCOPY number
223 ,x_msg_data OUT NOCOPY varchar2
224 );
225
226 procedure Delete_Dim_Levels(
227 p_commit IN varchar2 := FND_API.G_FALSE
228 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
229 ,x_return_status OUT NOCOPY varchar2
230 ,x_msg_count OUT NOCOPY number
231 ,x_msg_data OUT NOCOPY varchar2
232 );
233
234 procedure Update_Kpi_Analysis_Options_B(
235 p_commit IN varchar2 := FND_API.G_FALSE
236 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
237 ,x_return_status OUT NOCOPY varchar2
238 ,x_msg_count OUT NOCOPY number
239 ,x_msg_data OUT NOCOPY varchar2
240 );
241 procedure Create_Dim_Group_In_Dset(
242 p_commit IN varchar2 := FND_API.G_FALSE
243 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
244 ,p_create_Dim_Lev_Grp IN BOOLEAN
245 ,x_return_status OUT NOCOPY varchar2
246 ,x_msg_count OUT NOCOPY number
247 ,x_msg_data OUT NOCOPY varchar2
248 );
249 procedure Update_Dim_Group_In_Dset(
250 p_commit IN varchar2 := FND_API.G_FALSE
251 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
252 ,p_create_Dim_Lev_Grp IN BOOLEAN
253 ,x_return_status OUT NOCOPY varchar2
254 ,x_msg_count OUT NOCOPY number
255 ,x_msg_data OUT NOCOPY varchar2
256 );
257 procedure Delete_Dim_Group_In_Dset(
258 p_commit IN varchar2 := FND_API.G_FALSE
259 ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
260 ,p_create_Dim_Lev_Grp IN BOOLEAN
261 ,x_return_status OUT NOCOPY varchar2
262 ,x_msg_count OUT NOCOPY number
263 ,x_msg_data OUT NOCOPY varchar2
264 );
265
266 end BSC_DIMENSION_SETS_PUB;