[Home] [Help]
PACKAGE: APPS.BIS_AK_REGION_PUB
Source
1 PACKAGE BIS_AK_REGION_PUB as
2 /* $Header: BISPAKRS.pls 120.5.12000000.2 2007/01/30 10:07:27 akoduri ship $ */
3 ----------------------------------------------------------------------------
4 -- PACKAGE: BIS_AK_REGION_PUB --
5 -- --
6 -- DESCRIPTION: Private package that calls the AK packages to --
7 -- insert/update/delete records in the AK tables. --
8 --
9 -- --
10 -- MODIFICATIONS --
11 -- Date User Modification
12 -- XX-XXX-XX XXXXXXXX Modifications made, which procedures changed & --
13 -- list bug number, if fixing a bug. --
14 -- --
15 -- 11/21/01 mdamle Initial creation --
16 -- 01/10/03 nbarik Enhancement : 2638594 Portlet Builder --
17 -- Added DELETE_REGION_ITEM_ROW --
18 -- 12/25/03 mdamle Page Definer Integration - overloaded for --
19 -- functionality and error messaging --
20 -- 02/10/03 nbarik BSC/PMV Integration - Overloaded Procedures --
21 -- 05/12/04 adrao added Nested Region Items into table --
22 -- Bis_Region_Item_Rec_Type for Start-to-end KPI --
23 -- 06/07/04 mdamle Added DELETE_REGION_AND_REGION_ITEMS --
24 -- 06/29/04 mdamle Added AK_OBJECT_EXISTS and INSERT_AK_OBJECT --
25 -- 30-JUL-2004 rpenneru Modified for enhancemen#3748519 --
26 -- 08/04/04 mdamle Bug#3823878 - Add lock_row --
27 -- 08/18/04 sawu Bug#3822777 - added constants --
28 -- 09/01/04 sawu Bug#3859267 - added constants --
29 -- 08/16/04 sawu Bug#3859267 - Added IS_COMPARE_TYPE and VALIDATE_COMPARE,
30 -- overloaded UPDATE_REGION_ITEM_ATTR
31 -- 11/05/04 ankgoel Bug#3937907 - Added AK_DATA_SET to verify if AK data
32 -- will be modified for the source and compare-to columns
33 -- 11/18/04 sawu Bug#4018318 - Added api Is_View_Based_Report and
34 -- set node_display_flag to 'N' for C_COMPARE_TO_MEASURE_NO_TARGET
35 -- 11/24/04 sawu Bug#4028958: added IS_VIEW_BY_REPORT, IS_AGGREGATE_DEFINED
36 -- and updated UPDATE_REGION_ITEM_ATTR
37 -- 01/08/05 mdamle Add Url to AK_REGION_ITEMS routines --
38 -- 02/01/05 mdamle Add order_sequence, direction to AK_REGION_ITEMS --
39 -- 04/26/05 ankagarw bug#4194925 - saving measure display name as --
40 -- attribute long label in ak_region_items --
41 -- 19-MAY-2005 visuri GSCC Issues bug 4363854 --
42 -- 07/14/05 adrao Bug#4448994 added API Get_Region_Code_TL_Data --
43 -- 10/04/05 adrao Added field Grand_Total_Flag to Bis_Region_Item_Rec_Type
44 -- for Bug#4594984
45 -- 01/20/2006 psomesul Bug#4652028 added a new Function GetMeasureName |
46 -- 02/07/2006 hengliu Bug#4955493 Do not overwrite global menu/title --
47 -- 06/19/2006 ankgoel Bug#5256605 - Support MLS for AK Region Items --
48 -- 10/20/06 akoduri Bug#5584162 - Enable Sort For Percent Of Total
49 ----------------------------------------------------------------------------
50 -- Defaults
51 c_BOLD constant varchar2(1) := 'N';
52 c_ITALIC constant varchar2(1) := 'N';
53 c_VERTICAL_ALIGNMENT constant varchar2(30) := 'TOP';
54 c_HORIZONTAL_ALIGNMENT constant varchar2(30) := 'LEFT';
55 c_OBJECT_ATTRIBUTE_FLAG constant varchar2(1) := 'N';
56 c_UPDATE_FLAG constant varchar2(1) := 'N';
57 c_DISPLAY_HEIGHT constant varchar2(1) := '1';
58 c_SUBMIT constant varchar2(1) := 'N';
59 c_ENCRYPT constant varchar2(1) := 'N';
60 c_ADMIN_CUSTOMIZABLE constant varchar2(1) := 'Y';
61 c_ATTR_LABEL_LENGTH constant number := 0;
62 c_ATTR_VALUE_LENGTH constant number := 30;
63 c_ATTR_DATATYPE constant varchar2(8) := 'VARCHAR2';
64 c_UPPER_CASE_FLAG constant varchar2(1) := 'N';
65
66 c_ISFORM_FLAG constant varchar2(1) := 'N';
67 c_TABLE_LAYOUT_STYLE constant varchar2(12) := 'TABLE_LAYOUT';
68 c_PAGE_LAYOUT_STYLE constant varchar2(11) := 'PAGE_LAYOUT';
69 c_NODE_DISPLAY_FLAG constant varchar2(1) := 'Y';
70 c_NODE_QUERY_FLAG constant varchar2(1) := 'N';
71 c_REQUIRED_FLAG constant varchar2(1) := 'N';
72 c_TEXT_STYLE constant varchar2(4) := 'TEXT';
73 c_NESTED_REGION_STYLE constant varchar2(13) := 'NESTED_REGION';
74 c_ADD_INDEXED_CHILDREN constant varchar2(11) := 'Y';
75 c_IMAGE_FILE_NAME constant varchar2(22) := 'biscollg.gif';
76 C_ATTRIBUTE_CATEGORY CONSTANT VARCHAR2(22) := 'BIS PM Viewer';
77
78 C_MEASURE CONSTANT VARCHAR2(7) := 'MEASURE';
79 C_MEASURE_NO_TARGET CONSTANT VARCHAR(16) := 'MEASURE_NOTARGET';
80 C_COMPARE_TO_MEASURE_NO_TARGET CONSTANT VARCHAR(28) := 'COMPARE_TO_MEASURE_NO_TARGET';
81 C_CHANGE_MEASURE_NO_TARGET CONSTANT VARCHAR(25) := 'CHANGE_MEASURE_NO_TARGET';
82 C_PERCENT_OF_TOTAL CONSTANT VARCHAR(16) := 'PERCENT OF TOTAL';
83 C_SUM CONSTANT VARCHAR(3) := 'SUM';
84
85 TYPE Bis_Region_Rec_Type IS RECORD(
86 Region_Code VARCHAR2(30)
87 , Region_Name VARCHAR2(80)
88 , Region_Description VARCHAR2(2000)
89 , Region_Application_Id NUMBER
90 , Database_Object_Name VARCHAR2(30)
91 , Region_Style VARCHAR2(30)
92 , Region_Object_Type VARCHAR2(30)
93 , Help_Target VARCHAR2(30)
94 , Display_Rows NUMBER
95 , Disable_View_By VARCHAR2(1)
96 , No_Of_Portlet_Rows NUMBER
97 , Schedule VARCHAR2(150)
98 , Header_File_Procedure VARCHAR2(150)
99 , Footer_File_Procedure VARCHAR2(150)
100 , Group_By VARCHAR2(150)
101 , Order_By VARCHAR2(150)
102 , Plsql_For_Report_Query VARCHAR2(150)
103 , Display_Subtotals VARCHAR2(1)
104 , Data_Source VARCHAR2(150)
105 , Where_Clause VARCHAR2(150)
106 , Dimension_Group VARCHAR2(150)
107 , Parameter_Layout VARCHAR2(1)
108 , Kpi_Id NUMBER
109 , Analysis_Option_Id NUMBER
110 , Dim_Set_Id NUMBER
111 , Global_Menu VARCHAR2(150)
112 , Global_Title VARCHAR2(150)
113 );
114
115 TYPE Bis_Region_Tbl_Type IS TABLE OF Bis_Region_Rec_Type
116 INDEX BY BINARY_INTEGER;
117
118 -- Added Grandtotal items for Bug#4594984
119 -- Added Nested Regions for Start to End KPI Enhancement
120
121 TYPE Bis_Region_Item_Rec_Type IS RECORD(
122 Attribute_Code VARCHAR2(30)
123 , Attribute_Application_Id NUMBER
124 , Display_Sequence NUMBER
125 , Node_Display_Flag VARCHAR2(1)
126 , Required_Flag VARCHAR2(1)
127 , Queryable_Flag VARCHAR2(1)
128 , Display_Length NUMBER
129 , Long_Label VARCHAR2(80)
130 , Sort_Sequence NUMBER
131 , Initial_Sort_Sequence VARCHAR2(30)
132 , Sort_Direction VARCHAR2(30)
133 , Url VARCHAR2(2000)
134 , Attribute_Type VARCHAR2(150)
135 , Display_Format VARCHAR2(150)
136 , Display_Type VARCHAR2(3)
137 , Measure_Level VARCHAR2(150)
138 , Base_Column VARCHAR2(150)
139 , Lov_Where_Clause VARCHAR2(150)
140 , Graph_Position VARCHAR2(1)
141 , Graph_Style VARCHAR2(5)
142 , Lov_Table VARCHAR2(150)
143 , Aggregate_Function VARCHAR2(30)
144 , Display_Total VARCHAR2(1)
145 , Variance VARCHAR2(150)
146 , Schedule VARCHAR2(150)
147 , Override_Hierarchy VARCHAR2(150)
148 , Additional_View_By VARCHAR2(150)
149 , Rolling_Lookup VARCHAR2(150)
150 , Operator_Lookup VARCHAR2(150)
151 , Dual_YAxis_Graphs VARCHAR2(150)
152 , Custom_View_Name VARCHAR2(150)
153 , Graph_Measure_Type VARCHAR2(150)
154 , Hide_Target_In_Table VARCHAR2(1)
155 , Parameter_Render_Type VARCHAR2(30)
156 , Privilege VARCHAR2(150)
157 , Grand_Total_Flag BIS_AK_REGION_ITEM_EXTENSION.ATTRIBUTE26%TYPE
158 , Item_Style AK_REGION_ITEMS.ITEM_STYLE%TYPE
159 , Nested_Region_Code AK_REGION_ITEMS.NESTED_REGION_CODE%TYPE
160 , Nested_Region_Application_Id AK_REGION_ITEMS.NESTED_REGION_APPLICATION_ID%TYPE
161 );
162
163 TYPE Bis_Region_Item_Tbl_Type IS TABLE OF Bis_Region_Item_Rec_Type
164 INDEX BY BINARY_INTEGER;
165
166
167 c_RECORD_DELETED constant varchar2(7) := 'DELETED';
168 c_RECORD_CHANGED constant varchar2(7) := 'CHANGED';
169 C_LAST_UPDATE_DATE_FORMAT varchar2(21) := 'YYYY/MM/DD-HH24:MI:SS';
170
171 procedure INSERT_REGION_ROW (
172 X_ROWID in out NOCOPY VARCHAR2,
173 X_USER_ID in NUMBER,
174 X_REGION_APPLICATION_ID in NUMBER,
175 X_REGION_CODE in VARCHAR2,
176 X_DATABASE_OBJECT_NAME in VARCHAR2,
177 X_NAME in VARCHAR2,
178 X_DESCRIPTION in VARCHAR2,
179 X_NUM_ROWS_DISPLAY in NUMBER,
180 X_REGION_STYLE in VARCHAR2,
181 X_REGION_OBJECT_TYPE in VARCHAR2,
182 X_ISFORM_FLAG in VARCHAR2,
183 X_ATTRIBUTE_CATEGORY in VARCHAR2,
184 X_ATTRIBUTE1 in VARCHAR2,
185 X_ATTRIBUTE2 in VARCHAR2,
186 X_ATTRIBUTE3 in VARCHAR2,
187 X_ATTRIBUTE4 in VARCHAR2,
188 X_ATTRIBUTE5 in VARCHAR2,
189 X_ATTRIBUTE6 in VARCHAR2,
190 X_ATTRIBUTE7 in VARCHAR2,
191 X_ATTRIBUTE8 in VARCHAR2,
192 X_ATTRIBUTE9 in VARCHAR2,
193 X_ATTRIBUTE10 in VARCHAR2,
194 X_ATTRIBUTE11 in VARCHAR2,
195 X_ATTRIBUTE12 in VARCHAR2,
196 X_ATTRIBUTE13 in VARCHAR2,
197 X_ATTRIBUTE14 in VARCHAR2,
198 X_ATTRIBUTE15 in VARCHAR2);
199
200 -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
201 procedure INSERT_REGION_ROW (
202 p_REGION_CODE in VARCHAR2
203 ,p_REGION_APPLICATION_ID in NUMBER
204 ,p_DATABASE_OBJECT_NAME in VARCHAR2
205 ,p_NAME in VARCHAR2
206 ,p_REGION_STYLE in VARCHAR2 := c_TABLE_LAYOUT_STYLE
207 ,p_DESCRIPTION in VARCHAR2 := NULL
208 ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := NULL
209 ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := NULL
210 ,p_ATTRIBUTE1 in VARCHAR2 := NULL
211 ,p_ATTRIBUTE2 in VARCHAR2 := NULL
212 ,p_ATTRIBUTE3 in VARCHAR2 := NULL
213 ,p_ATTRIBUTE4 in VARCHAR2 := NULL
214 ,p_ATTRIBUTE5 in VARCHAR2 := NULL
215 ,p_ATTRIBUTE6 in VARCHAR2 := NULL
216 ,p_ATTRIBUTE7 in VARCHAR2 := NULL
217 ,p_ATTRIBUTE8 in VARCHAR2 := NULL
218 ,p_ATTRIBUTE9 in VARCHAR2 := NULL
219 ,p_ATTRIBUTE10 in VARCHAR2 := NULL
220 ,p_ATTRIBUTE11 in VARCHAR2 := NULL
221 ,p_ATTRIBUTE12 in VARCHAR2 := NULL
222 ,p_ATTRIBUTE13 in VARCHAR2 := NULL
223 ,p_ATTRIBUTE14 in VARCHAR2 := NULL
224 ,p_ATTRIBUTE15 in VARCHAR2 := NULL
225 ,x_return_status OUT NOCOPY VARCHAR2
226 ,x_msg_count OUT NOCOPY NUMBER
227 ,x_msg_data OUT NOCOPY VARCHAR2
228 );
229
230 -- nbarik 02/10/04 - overloaded for region record type
231 procedure INSERT_REGION_ROW
232 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
233 , p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type
234 , x_return_status OUT NOCOPY VARCHAR2
235 , x_msg_count OUT NOCOPY NUMBER
236 , x_msg_data OUT NOCOPY VARCHAR2
237 );
238
239 procedure UPDATE_REGION_ROW (
240 X_USER_ID in NUMBER,
241 X_REGION_APPLICATION_ID in NUMBER,
242 X_REGION_CODE in VARCHAR2,
243 X_DATABASE_OBJECT_NAME in VARCHAR2,
244 X_NAME in VARCHAR2,
245 X_DESCRIPTION in VARCHAR2,
246 X_NUM_ROWS_DISPLAY in NUMBER,
247 X_REGION_STYLE in VARCHAR2,
248 X_REGION_OBJECT_TYPE in VARCHAR2,
249 X_ATTRIBUTE_CATEGORY in VARCHAR2,
250 X_ATTRIBUTE1 in VARCHAR2,
251 X_ATTRIBUTE2 in VARCHAR2,
252 X_ATTRIBUTE3 in VARCHAR2,
253 X_ATTRIBUTE4 in VARCHAR2,
254 X_ATTRIBUTE5 in VARCHAR2,
255 X_ATTRIBUTE6 in VARCHAR2,
256 X_ATTRIBUTE7 in VARCHAR2,
257 X_ATTRIBUTE8 in VARCHAR2,
258 X_ATTRIBUTE9 in VARCHAR2,
259 X_ATTRIBUTE10 in VARCHAR2,
260 X_ATTRIBUTE11 in VARCHAR2,
261 X_ATTRIBUTE12 in VARCHAR2,
262 X_ATTRIBUTE13 in VARCHAR2,
263 X_ATTRIBUTE14 in VARCHAR2,
264 X_ATTRIBUTE15 in VARCHAR2);
265
266 -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
267 procedure UPDATE_REGION_ROW (
268 p_REGION_CODE in VARCHAR2
269 ,p_REGION_APPLICATION_ID in NUMBER
270 ,p_DATABASE_OBJECT_NAME in VARCHAR2
271 ,p_NAME in VARCHAR2
272 ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
273 ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
274 ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
275 ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276 ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277 ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278 ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279 ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280 ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281 ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282 ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283 ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284 ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
285 ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286 ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
287 ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
288 ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
289 ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
290 ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
291 ,x_return_status OUT NOCOPY VARCHAR2
292 ,x_msg_count OUT NOCOPY NUMBER
293 ,x_msg_data OUT NOCOPY VARCHAR2
294 );
295
296 -- mdamle 12/25/2003
297 -- nbarik - 04/05/04 - Enh 3546750 - BSC/PMV Integration - Added p_commit
298 PROCEDURE DELETE_REGION_ROW
299 (p_REGION_CODE in VARCHAR2
300 ,p_REGION_APPLICATION_ID in NUMBER
301 ,x_return_status OUT NOCOPY VARCHAR2
302 ,x_msg_count OUT NOCOPY NUMBER
303 ,x_msg_data OUT NOCOPY VARCHAR2
304 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
305 );
306
307 procedure INSERT_REGION_ITEM_ROW (
308 X_ROWID in out NOCOPY VARCHAR2,
309 X_USER_ID in NUMBER,
310 X_REGION_APPLICATION_ID in NUMBER,
311 X_REGION_CODE in VARCHAR2,
312 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
313 X_ATTRIBUTE_CODE in VARCHAR2,
314 X_DISPLAY_SEQUENCE in NUMBER,
315 X_NODE_DISPLAY_FLAG in VARCHAR2,
316 X_NODE_QUERY_FLAG in VARCHAR2,
317 X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
318 X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
319 X_DISPLAY_VALUE_LENGTH in number,
320 X_ITEM_STYLE in VARCHAR2,
321 X_REQUIRED_FLAG in VARCHAR2,
322 X_NESTED_REGION_CODE IN VARCHAR2,
323 X_NESTED_REGION_APPL_ID IN NUMBER,
324 X_ATTRIBUTE_CATEGORY in VARCHAR2,
325 X_ATTRIBUTE1 in VARCHAR2,
326 X_ATTRIBUTE2 in VARCHAR2,
327 X_ATTRIBUTE3 in VARCHAR2,
328 X_ATTRIBUTE4 in VARCHAR2,
329 X_ATTRIBUTE5 in VARCHAR2,
330 X_ATTRIBUTE6 in VARCHAR2,
331 X_ATTRIBUTE7 in VARCHAR2,
332 X_ATTRIBUTE8 in VARCHAR2,
333 X_ATTRIBUTE9 in VARCHAR2,
334 X_ATTRIBUTE10 in VARCHAR2,
335 X_ATTRIBUTE11 in VARCHAR2,
336 X_ATTRIBUTE12 in VARCHAR2,
337 X_ATTRIBUTE13 in VARCHAR2,
338 X_ATTRIBUTE14 in VARCHAR2,
339 X_ATTRIBUTE15 in VARCHAR2,
340 X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
341 X_ORDER_SEQUENCE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
342 X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR);
343
344 -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
345 procedure INSERT_REGION_ITEM_ROW (
346 p_REGION_CODE in VARCHAR2
347 ,p_REGION_APPLICATION_ID in NUMBER
348 ,p_ATTRIBUTE_CODE in VARCHAR2
349 ,p_ATTRIBUTE_APPLICATION_ID in NUMBER
350 ,p_DISPLAY_SEQUENCE in number
351 ,p_NODE_DISPLAY_FLAG in VARCHAR2 := 'Y'
352 ,p_ATTRIBUTE_LABEL_LONG in VARCHAR2 := NULL
353 ,p_NESTED_REGION_CODE in VARCHAR2 := NULL
354 ,p_NESTED_REGION_APPL_ID in NUMBER := NULL
355 ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := NULL
356 ,p_ATTRIBUTE1 in VARCHAR2 := NULL
357 ,p_ATTRIBUTE2 in VARCHAR2 := NULL
358 ,p_ATTRIBUTE3 in VARCHAR2 := NULL
359 ,p_ATTRIBUTE4 in VARCHAR2 := NULL
360 ,p_ATTRIBUTE5 in VARCHAR2 := NULL
361 ,p_ATTRIBUTE6 in VARCHAR2 := NULL
362 ,p_ATTRIBUTE7 in VARCHAR2 := NULL
363 ,p_ATTRIBUTE8 in VARCHAR2 := NULL
364 ,p_ATTRIBUTE9 in VARCHAR2 := NULL
365 ,p_ATTRIBUTE10 in VARCHAR2 := NULL
366 ,p_ATTRIBUTE11 in VARCHAR2 := NULL
367 ,p_ATTRIBUTE12 in VARCHAR2 := NULL
368 ,p_ATTRIBUTE13 in VARCHAR2 := NULL
369 ,p_ATTRIBUTE14 in VARCHAR2 := NULL
370 ,p_ATTRIBUTE15 in VARCHAR2 := NULL
371 ,p_URL in VARCHAR2 := NULL
372 ,p_ORDER_SEQUENCE in VARCHAR2 := NULL
373 ,p_ORDER_DIRECTION in VARCHAR2 := NULL
374 ,x_return_status OUT NOCOPY VARCHAR2
375 ,x_msg_count OUT NOCOPY NUMBER
376 ,x_msg_data OUT NOCOPY VARCHAR2
377 );
378
379 -- nbarik 02/10/04 - overloaded for region record type
380 PROCEDURE INSERT_REGION_ITEM_ROW
381 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
382 , p_region_code IN VARCHAR2
383 , p_region_application_id IN NUMBER
384 , p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
385 , x_return_status OUT NOCOPY VARCHAR2
386 , x_msg_count OUT NOCOPY NUMBER
387 , x_msg_data OUT NOCOPY VARCHAR2
388 );
389
390
391 procedure UPDATE_REGION_ITEM_ROW (
392 X_USER_ID in NUMBER,
393 X_REGION_APPLICATION_ID in NUMBER,
394 X_REGION_CODE in VARCHAR2,
395 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
396 X_ATTRIBUTE_CODE in VARCHAR2,
397 X_DISPLAY_SEQUENCE in VARCHAR2,
398 X_NODE_DISPLAY_FLAG in VARCHAR2,
399 X_NODE_QUERY_FLAG in VARCHAR2,
400 X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
401 X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
402 X_DISPLAY_VALUE_LENGTH in number,
403 X_ITEM_STYLE in VARCHAR2,
404 X_REQUIRED_FLAG in VARCHAR2,
405 X_NESTED_REGION_CODE IN VARCHAR2,
406 X_NESTED_REGION_APPL_ID IN NUMBER,
407 X_ATTRIBUTE_CATEGORY in VARCHAR2,
408 X_ATTRIBUTE1 in VARCHAR2,
409 X_ATTRIBUTE2 in VARCHAR2,
410 X_ATTRIBUTE3 in VARCHAR2,
411 X_ATTRIBUTE4 in VARCHAR2,
412 X_ATTRIBUTE5 in VARCHAR2,
413 X_ATTRIBUTE6 in VARCHAR2,
414 X_ATTRIBUTE7 in VARCHAR2,
415 X_ATTRIBUTE8 in VARCHAR2,
416 X_ATTRIBUTE9 in VARCHAR2,
417 X_ATTRIBUTE10 in VARCHAR2,
418 X_ATTRIBUTE11 in VARCHAR2,
419 X_ATTRIBUTE12 in VARCHAR2,
420 X_ATTRIBUTE13 in VARCHAR2,
421 X_ATTRIBUTE14 in VARCHAR2,
422 X_ATTRIBUTE15 in VARCHAR2,
423 X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
424 X_ORDER_SEQUENCE in VARCHAR2 := NULL,
425 X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR);
426
427
428 -- nbarik 02/10/04 - overloaded for region record type
429 PROCEDURE UPDATE_REGION_ITEM_ROW
430 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
431 , p_region_code IN VARCHAR2
432 , p_region_application_id IN NUMBER
433 , p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
434 , x_return_status OUT NOCOPY VARCHAR2
435 , x_msg_count OUT NOCOPY NUMBER
436 , x_msg_data OUT NOCOPY VARCHAR2
437 );
438
439 -- nbarik 02/10/04 - overloaded for region record type
440 PROCEDURE UPDATE_REGION_ROW
441 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
442 , p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type
443 , x_return_status OUT NOCOPY VARCHAR2
444 , x_msg_count OUT NOCOPY NUMBER
445 , x_msg_data OUT NOCOPY VARCHAR2
446 );
447
448 --nbarik 10/01/03 - Delete AK region item
449 PROCEDURE DELETE_REGION_ITEM_ROW (
450 X_REGION_APPLICATION_ID IN NUMBER,
451 X_REGION_CODE IN VARCHAR2,
452 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
453 X_ATTRIBUTE_CODE IN VARCHAR2
454 );
455
456 -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
457 -- nbarik - 04/05/04 - Enh 3546750 - BSC/PMV Integration - Added p_commit
458 PROCEDURE DELETE_REGION_ITEM_ROW
459 (p_REGION_CODE in VARCHAR2
460 ,p_REGION_APPLICATION_ID in NUMBER
461 ,p_ATTRIBUTE_CODE in VARCHAR2
462 ,p_ATTRIBUTE_APPLICATION_ID in NUMBER
463 ,x_return_status OUT NOCOPY VARCHAR2
464 ,x_msg_count OUT NOCOPY NUMBER
465 ,x_msg_data OUT NOCOPY VARCHAR2
466 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
467 );
468
469
470 PROCEDURE DELETE_REGION_AND_REGION_ITEMS(
471 p_REGION_CODE IN VARCHAR2
472 ,p_REGION_APPLICATION_ID IN NUMBER
473 ,x_return_status OUT NOCOPY VARCHAR2
474 ,x_msg_count OUT NOCOPY NUMBER
475 ,x_msg_data OUT NOCOPY VARCHAR2
476 );
477
478 PROCEDURE DELETE_REGION_ITEMS (
479 p_REGION_CODE IN VARCHAR2
480 ,p_REGION_APPLICATION_ID IN NUMBER
481 ,x_return_status OUT NOCOPY VARCHAR2
482 ,x_msg_count OUT NOCOPY NUMBER
483 ,x_msg_data OUT NOCOPY VARCHAR2
484 );
485
486 PROCEDURE DELETE_EXT_REGION_ITEMS (
487 p_REGION_CODE IN VARCHAR2
488 ,p_REGION_APPLICATION_ID IN NUMBER
489 ,x_return_status OUT NOCOPY VARCHAR2
490 ,x_msg_count OUT NOCOPY NUMBER
491 ,x_msg_data OUT NOCOPY VARCHAR2
492 );
493
494 function VALID_DATABASE_OBJECT (
495 P_DATABASE_OBJECT_NAME IN VARCHAR2) return boolean;
496
497 function AK_OBJECT_EXISTS (
498 P_DATABASE_OBJECT_NAME IN VARCHAR2) return boolean;
499
500 procedure INSERT_AK_OBJECT (
501 P_DATABASE_OBJECT_NAME IN VARCHAR2
502 ,P_APPLICATION_ID IN NUMBER);
503
504 -- rpenneru Added for enh#3757005
505 PROCEDURE GET_REGION_ITEM_REC
506 ( p_region_code IN VARCHAR2
507 , p_region_application_id IN NUMBER
508 , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
509 , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
510 , x_Region_Item_Rec OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
511 , x_return_status OUT NOCOPY VARCHAR2
512 , x_msg_count OUT NOCOPY NUMBER
513 , x_msg_data OUT NOCOPY VARCHAR2
514 );
515
516 PROCEDURE UPDATE_REGION_ITEM_ATTR
517 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
518 , p_region_code IN VARCHAR2
519 , p_region_application_id IN NUMBER
520 , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
521 , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
522 , p_Short_Name IN VARCHAR2
523 , x_return_status OUT NOCOPY VARCHAR2
524 , x_msg_count OUT NOCOPY NUMBER
525 , x_msg_data OUT NOCOPY VARCHAR2
526 );
527
528 PROCEDURE UPDATE_REGION_ITEM_ATTR
529 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
530 , p_region_code IN VARCHAR2
531 , p_region_application_id IN NUMBER
532 , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
533 , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
534 , p_Short_Name IN VARCHAR2
535 , p_type IN VARCHAR2
536 , p_Meas_Name IN VARCHAR2
537 , x_return_status OUT NOCOPY VARCHAR2
538 , x_msg_count OUT NOCOPY NUMBER
539 , x_msg_data OUT NOCOPY VARCHAR2
540 );
541
542
543 PROCEDURE LOCK_REGION_ROW
544 ( p_region_code IN VARCHAR2
545 , p_region_application_id IN NUMBER
546 , p_last_update_date IN VARCHAR2
547 , x_record_status OUT NOCOPY VARCHAR2
548 );
549
550 --return true if and only if p_attribute_type is one of C_MEASURE or C_MEASURE_NO_TARGET
551 FUNCTION IS_MEASURE_TYPE(
552 p_attribute_type IN VARCHAR2
553 ) RETURN BOOLEAN;
554
555 --return true if and only if p_attribute_type is C_COMPARE_TO_MEASURE_NO_TARGET
556 FUNCTION IS_COMPARE_TYPE(
557 p_attribute_type IN VARCHAR2
558 ) RETURN BOOLEAN;
559
560 --return true if and only if given measure short name exists
561 FUNCTION VALIDATE_MEASURE(
562 p_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%Type
563 ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
564 ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
565 ) RETURN BOOLEAN;
566
567 --return true if any only if p_compare_code refers to a valid entry in ak_region_items which
568 --subsequently refers to a valid measure
569 FUNCTION VALIDATE_COMPARE(
570 p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
571 ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
572 ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
573 ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
574 ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
575 ) RETURN BOOLEAN;
576
577 FUNCTION AK_DATA_SET(
578 p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
579 ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
580 ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
581 ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
582 ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
583 ) RETURN VARCHAR2;
584
585 --return 'T' if given report is view based, 'F' otherwise
586 FUNCTION IS_VIEW_BASED_REPORT(
587 p_region_code IN Ak_Regions.REGION_CODE%TYPE
588 ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
589 ) RETURN VARCHAR2;
590
591 --return 'T' if given report is view-by, 'F' otherwise
592 FUNCTION IS_VIEW_BY_REPORT(
593 p_region_code IN Ak_Regions.REGION_CODE%TYPE
594 ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
595 ) RETURN VARCHAR2;
596
597 --return 'T' if at least one aggregate function is defined in any column
598 --for the given report, 'F' otherwise
599 FUNCTION IS_AGGREGATE_DEFINED(
600 p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
601 ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
602 ) RETURN VARCHAR2;
603
604
605 -- added for Bug#4448994 and as a general utility file.
606 PROCEDURE Get_Region_Code_TL_Data (
607 p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
608 , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
609 , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
610 , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
611 , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
612 , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
613 , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
614 , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
615 , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
616 , x_return_status OUT NOCOPY VARCHAR2
617 , x_msg_count OUT NOCOPY NUMBER
618 , x_msg_data OUT NOCOPY VARCHAR2
619 );
620
621 PROCEDURE reset_ak_items_display_seq (
622 p_region_code IN VARCHAR2
623 , p_region_application_id IN NUMBER
624 , x_return_status OUT NOCOPY VARCHAR2
625 , x_msg_count OUT NOCOPY NUMBER
626 , x_msg_data OUT NOCOPY VARCHAR2
627 );
628
629 END BIS_AK_REGION_PUB;