1 PACKAGE BSC_BIS_KPI_CRUD_PUB AS
2 /* $Header: BSCCRUDS.pls 120.26 2007/10/09 12:59:30 bijain ship $ */
3
4 /*REM +=======================================================================+
5 REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BSCCRUDS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: Wrapper API for KPI CRUD |
13 REM | |
14 REM | NOTES |
15 REM | |
16 REM | HISTORY |
17 REM | 15-APR-04 akchan Created. |
18 REM | 23-APR-04 adrao Added Update/Delete APIs |
19 REM | 07-MAY-04 adrao Modified CRUD APIs to handle 1 Dimension |
20 REM | per Analysis Option |
21 REM | 11-MAY-04 adrao KPI End-to-end Phase II: Modified CRUD APIs |
22 REM | to add Parameter Portlet Region Code as an |
23 REM | nested region item and not add Dimension |
24 REM | Level region items. |
25 REM | 14-MAY-04 adrao Added 2 additional regions/analysis options |
26 REM | 20-MAY-04 adrao Added the Create_Dimension API |
27 REM | 26-MAY-04 akchan Removed method Create_PPX_Region_Item() |
28 REM | Added constant for String "MEASURE_NOTARGET" |
29 REM | 27-MAY-04 adrao Modularized all CRUD APIs |
30 REM | 04-JUN-04 adrao Added Autofactoring for Meaaure, Compare To |
31 REM | 10-JUN-04 adrao Added C_NO_PROJECTION to disable Projection |
32 REM | 14-JUN-04 adrao Added APIs to check for Time Dimension Objs |
33 REM | 18-JUN-04 adrao Added C_FORMAT_POINTER for Bug#3701687 |
34 REM | 18-JUN-04 adrao Added API Get_Next_Region_Code_By_AO for |
35 REM | Enh#3691035 |
36 REM | 15-JUL-04 adrao Fixed Bug#3766839 to get KPI_ID from |
37 REM | measure short_name instead of Page Function |
38 REM | 19-JUL-04 adrao added API is_XTD_Enabled for |
39 REM | Bug#3767168 for Paramter Portlets |
40 REM | 21-JUL-04 adrao added API Get_S2EObjective_With_XTD for |
41 REM | Bug#3780082 |
42 REM | 22-JUL-04 adrao Fixed Bug#3770986 (please see bug) |
43 REM | 04-AUG-04 adrao Added API Populate_DBI_Calendar() |
44 REM | for Bug#3809721 |
45 REM | 11-AUG-04 adrao Added API Get_Region_Codes_By_Short_Name |
46 REM | for Bug#3777647 |
47 REM | 18-AUG-04 adrao Added API Check_XTD_Summarization() for |
48 REM | Bug#3831859 |
49 REM | 02-SEP-04 adrao Added API Get_Kpi_Details for Bug#3814292 |
50 REM | 09-SEP-04 adrao Added API Get_Change_Disp_Type_By_Mask() for |
51 REM | Bug#3876413 |
52 REM | 20-SEP-04 ankgoel Added Get_Pmf_Metadata_By_Objective for |
53 REM | Bug#3759819 |
54 REM | 27-SEP-04 ankgoel Added constant C_AK_DATASOURCE for bug#3916377
55 REM | 29-SEP-04 adrao Added constants C_CHANGE_TYPE_INTEGER and |
56 REM | C_CHANGE_TYPE_PERCENT for Bug#3919666 |
57 REM | 30-SEP-04 rpenneru Added Get_S2ESCR_DeleteMessage, |
58 REM | , Delete_S2E_Metadata for bug#3893949 |
59 REM | 05-OCT-04 ankgoel Bug#3933075 Moved Get_Pmf_Metadata_By_Objective
60 REM | and C_AK_DATASOURCE to BSCCSUBB.pls. Moved |
61 REM | C_BSC_UNDERSCORE to BSCUTILB.pls. |
62 REN | 06-OCT-04 adrao Fixed Bug#3935595 |
63 REM | 21-DEC-04 adrao Modified for 8i compatibility, Bug#4079898 |
64 REN | 27-DEC-04 adrao Moved DIMOBJ_SHORT_NAME_CLASS to BSCPMFWB |
65 REM | 08-FEB-05 visuri added Has_Compare_To_Or_Plan() for Enh. |
66 REM | 4065089 |
67 REM | 08-FEB-05 visuri added constants :C_BIS_APPLICATION_ID, |
68 REM | C_DAILY_PERIOD_ATTR_CODE,C_HIDE_PARAMETER, |
69 REM | C_DAILY_PERIOD_ATTR2 for enh. 4065098 |
70 REM | 22-FEB-05 adrao Autogenerated Measures Enhancement for Report |
71 REM | Designer |
72 REM | 07-MAR-05 vtulasi Added procedure Get_Dep_Obj_Func_Name |
73 REM | for bug# 3786130 |
74 REM | 21-Feb-05 rpenneru Enh#4059160, Add FA as property to Custom KPIs|
75 REM | 10-MAR-05 adrao added API Convert_AutoGen_To_ViewBased for |
76 REM | Convert AGR to VBR enhancement. |
77 REM | 18-MAR-05 adrao Made modification to ensure Duplication of |
78 REM | reports and added a few util APIs |
79 REM | 22-APR-05 akoduri Enhancement#3865711 -- Obsolete Seeded Objects|
80 REM | 04-MAY-05 adrao Added constant C_DEFAULT_MEASURE_GROUP_ID |
81 REM | 03-MAY-2005 akoduri Enh #4268374 -- Weighted Average Measures |
82 REM | 11-MAY-2005 adrao Created the following APIs for |
83 REM | selective cascading of Dimensions and Measures|
84 REM | Has_Measure_Column_Changed |
85 REM | Has_Time_Dim_Obj_Changed |
86 REM | Has_Non_Time_Dim_Obj_Changed |
87 REM | 08-jul-2005 ASHANKAR added the method is_Scorecard_From_Reports|
88 REM | and CONSTANT C_BISVIEWER_SHOWREPORT |
89 REM | 02-JUN-2005 adrao Added APIs for Calendar Enhancement (4376162) |
90 REM | 13-JUL-2005 adrao Enabled addition of Time based Periodicities |
91 REM | in the Calendar+Periodicity format #4376162 |
92 REM | 15-JUL-2005 akoduri Provided warning messasges for strucutural |
93 REM | and color changes #4492177 |
94 REM | 04-AUG-2005 adrao Fixed Bug#4520525 |
95 REM | 16-AUG-2005 akoduri Bug#4482355 Removing attribute_code and |
96 REM | attribute2 dependency in Report Designer |
97 REM | 07-SEP-2005 adrao Implemented dynamic Parameter Portlet builder |
98 REM | as required by Bug#4558279 |
99 REM | 30-SEP-2005 adrao Fixed Bug#4638384 added API |
100 REM | Get_Compare_Attribute_Code () |
101 REM | 07-NOV-2005 arhegde bug# 4720781 c_bisreportpg constant added |
102 REM | 25-DEC-2005 adrao Added APIs following APIs for Enh#3909868 |
103 REM | - Migrate_AGR_To_PLSQL |
104 REM | - Is_Primary_Source_Of_Measure |
105 REM | - Cascade_Attr_Code_Into_Measure |
106 REM | - Cascade_Changes_Into_Forumla |
107 REM | 03-JAN-2005 adrao Added API for Is_Dim_Associated_To_Objective()|
108 REM | for Bug#4923006 |
109 REM | 06-JAN-2006 akoduri Enh#4739401 - Hide Dimensions/Dim Objects |
110 REM | 17-JAN-2006 rpenneru bug#4741919 - added Delete_AG_Report |
111 REM | for AG report deletion |
112 REM | 19-JAN-2006 adrao Added API Migrate_To_Existing_Source() for |
113 REM | Enhancement#4952167 |
114 REM | 07-FEB-2006 hengliu Bug#4955493 - Not overwrite global menu/title|
115 REM | 07-FEB-2006 ppandey Bug#4771854 - Rolling Periods for AG |
116 REM | 09-feb-2007 ashankar Simulation Tree Enhacement 5386112 |
117 REM +=======================================================================+ */
118
119
120 C_SINGLE_BAR_INDICATOR CONSTANT NUMBER := 1;
121 C_MULTI_BAR_INDICATOR CONSTANT NUMBER := 10;
122 C_SIMULATION_INDICATOR CONSTANT NUMBER := 7;
123
124 C_NORMAL_INDICATOR_CONFIG_TYPE CONSTANT NUMBER := 1;
125 C_SIM_INDICATOR_CONFIG_TYPE CONSTANT NUMBER := 7;
126
127 C_BSC_APPLICATION_ID CONSTANT NUMBER := 271;
128 C_BIS_APPLICATION_ID CONSTANT NUMBER := 191;
129
130 C_BSC_SOURCE CONSTANT VARCHAR2(16) := 'BSC_DATA_SOURCE';
131
132 c_oltp_time CONSTANT VARCHAR2(5) := 'TIME';
133 c_edw_time CONSTANT VARCHAR2(11) := 'EDW_TIME_M';
134 C_TIME_COMPARISON CONSTANT VARCHAR2(21) := 'TIME_COMPARISON_TYPE';
135 C_BISVIEWER_SHOWREPORT CONSTANT VARCHAR2(21) := 'BISVIEWER.SHOWREPORT';
136 c_bisreportpg CONSTANT VARCHAR2(70) := 'OA.jsp?page=/oracle/apps/bis/report/webui/BISReportPG';
137
138 c_measure_group_id_error CONSTANT NUMBER := -999;
139
140 C_COMPARISON_APPEND_STRING CONSTANT VARCHAR2(2) := '_B';
141 C_CHANGE_APPEND_STRING CONSTANT VARCHAR2(2) := '_C';
142
143 C_CHANGE_ATTRIBURE_TYPE CONSTANT VARCHAR2(24) := 'CHANGE_MEASURE_NO_TARGET';
144 C_COMPARE_ATTRIBURE_TYPE CONSTANT VARCHAR2(28) := 'COMPARE_TO_MEASURE_NO_TARGET';
145
146 C_DAILY_PERIOD_ATTR_CODE CONSTANT VARCHAR2(12) := 'FII_TIME_DAY';
147 C_HIDE_PARAMETER CONSTANT VARCHAR2(14) := 'HIDE PARAMETER';
148 C_DAILY_PERIOD_ATTR2 CONSTANT VARCHAR2(17) := 'TIME+FII_TIME_DAY';
149
150 C_GRAND_TOTAL_ACTUAL CONSTANT VARCHAR2(2) := '_G';
151 C_GRAND_TOTAL_COMPARE_TO CONSTANT VARCHAR2(3) := '_G1';
152 C_COLSPAN CONSTANT VARCHAR2(3) := '_CS';
153
154 C_GRAND_TOTAL_ATTRIBURE_TYPE CONSTANT VARCHAR2(24) := 'GRAND_TOTAL';
155 C_COLUMN_SPAN_ATTRIBURE_TYPE CONSTANT VARCHAR2(7) := 'COLSPAN';
156
157 C_MEASURE_ATTRIBURE_TYPE CONSTANT VARCHAR2(16) := 'MEASURE_NOTARGET';
158
159 C_INVALID_ENTITY CONSTANT NUMBER := -999;
160
161 C_AUTOFACTOR_GROUP1 CONSTANT VARCHAR2(2) := 'AU';
162 C_AUTOFACTOR_GROUP2 CONSTANT VARCHAR2(3) := 'AU1';
163 C_AUTOFACTOR_GROUP3 CONSTANT VARCHAR2(3) := 'AU2';
164 C_AUTOFACTOR_GROUP4 CONSTANT VARCHAR2(3) := 'AU3';
165 C_AUTOFACTOR_GROUP5 CONSTANT VARCHAR2(3) := 'AU4';
166
167 C_NO_PROJECTION CONSTANT NUMBER := 0;
168
169 C_CALC_TC CONSTANT NUMBER := 3;
170 C_CALC_GROWTH CONSTANT NUMBER := 4;
171 C_CALC_QTD CONSTANT NUMBER := 6;
172 C_CALC_YDG CONSTANT NUMBER := 7;
173 C_CALC_AVG CONSTANT NUMBER := 8;
174 C_CALC_YYG CONSTANT NUMBER := 9;
175 C_CALC_XTD CONSTANT NUMBER := 12;
176 C_CALC_DV CONSTANT NUMBER := 20;
177
178 C_ENABLE_CALC_U0 CONSTANT NUMBER := 2;
179 C_ENABLE_CALC_U1 CONSTANT NUMBER := 2;
180
181 C_DISABLE_CALC_U0 CONSTANT NUMBER := 0;
182 C_DISABLE_CALC_U1 CONSTANT NUMBER := 0;
183
184 C_DISABLE_CALC_KPI CONSTANT NUMBER := 0;
185 C_ENABLE_CALC_KPI CONSTANT NUMBER := 1;
186
187 C_FORMAT_POINTER CONSTANT VARCHAR2(2) := 'FP';
188 C_FORMAT_INTEGER CONSTANT VARCHAR2(1) := 'I';
189
190
191 -- Added for Bug#3767168
192 C_AS_OF_DATE CONSTANT VARCHAR2(10) := 'AS_OF_DATE';
193
194 C_MAX_OBJECTIVES_DISPLAY CONSTANT NUMBER := 200;
195
196 -- Added for Bug#3919666, changed for Bug#3935595 to 2
197 C_CHANGE_TYPE_INTEGER CONSTANT NUMBER := 2;
198 C_CHANGE_TYPE_PERCENT CONSTANT NUMBER := 1;
199
200
201 -- added for Default Group fix
202 C_DEFAULT_MEASURE_GROUP_ID CONSTANT NUMBER := -1;
203 C_BSC_CHAR_COMMA CONSTANT VARCHAR2(1) := ',';
204 C_PLSQL_SOURCE CONSTANT VARCHAR2(20) := 'PLSQL_PARAMETERS';
205
206
207 C_PLSQL_BASED_REPORT_TYPE CONSTANT VARCHAR2(30) := 'PLSQL_REPORT';
208 C_VIEW_BASED_REPORT_TYPE CONSTANT VARCHAR2(30) := 'VIEW_REPORT';
209
210
211 G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_BIS_KPI_CRUD_PUB';
212 C_PMD CONSTANT VARCHAR2(10):='PMD_';
213
214
215
216 /******** CONSTANT LIST ********/
217 -- Added by ADRAO for Constant Class management Bug#3770986
218 -- define a VARRAY, which will hold the short_names - moved to BSCUTILS.pls
219
220 -- Include the list of excluded SHORT_NAMES as CONSTANT VARCHAR2(30), use C_DO as a prefix
221 C_DO_PLAN_SNAPSHOT CONSTANT BIS_LEVELS.SHORT_NAME%TYPE := 'PLAN_SNAPSHOT';
222
223 -- Defines a list of Short_Names as a part of Global class G_EXCLUDE_DIMOBJ_CLASS
224 G_EXCLUDE_DIMOBJ_CLASS CONSTANT BSC_PMF_UI_WRAPPER.DIMOBJ_SHORT_NAME_CLASS := BSC_PMF_UI_WRAPPER.DIMOBJ_SHORT_NAME_CLASS (
225 C_DO_PLAN_SNAPSHOT
226 );
227
228 /******** CONSTANT LIST ********/
229
230 C_COMP_TO_DIM_LEVEL CONSTANT VARCHAR2(26) := 'COMPARE TO DIMENSION LEVEL';
231
232 --Called by Java API
233 --------------------------------------------------------------------------------
234 -- Create BSC KPI with BIS Dimension from start to end.
235 --
236 -- Created by: Alex Chan 04/15/2004
237 --------------------------------------------------------------------------------
238
239 TYPE bsc_varchar2_tbl_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
240 TYPE bsc_number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
241
242
243 -- added for Calendar Enh in Report Designer (Enh#4376162)
244 C_BSC_TIME CONSTANT VARCHAR2(8) := 'BSC_TIME';
245
246 -- added for Bug#4520525
247 C_MAX_MESSAGE_SIZE CONSTANT NUMBER := 1800;
248
249 --added constants for Bug#4558279
250
251 C_ICX_PROMPTS CONSTANT VARCHAR2(30) := 'ICX_PROMPTS';
252 C_TABLE CONSTANT VARCHAR2(30) := 'TABLE';
253
254
255
256 PROCEDURE Create_Kpi_End_To_End(
257 p_commit IN VARCHAR2 := FND_API.G_FALSE
258 ,p_responsibility_id IN number
259 ,p_create_new_kpi IN VARCHAR2 := FND_API.G_FALSE
260 ,p_kpi_id_to_add_measure IN VARCHAR2 := NULL
261 ,p_param_portlet_region_code IN VARCHAR2
262 ,p_kpi_name IN VARCHAR2 := NULL
263 ,p_kpi_description IN VARCHAR2 := NULL
264 ,p_measure_name IN varchar2
265 ,p_measure_short_name IN varchar2 := NULL
266 ,p_measure_description IN varchar2 := NULL
267 ,p_measure_type IN number := NULL --Activity/Balance
268 ,p_measure_operation IN varchar2 := BSC_BIS_MEASURE_PUB.c_SUM --Aggregation method
269 ,p_dataset_format_id IN number := NULL --data format
270 ,p_dataset_autoscale_flag IN number := NULL --autoscale flag
271 ,p_measure_increase_in_measure IN varchar2 := NULL --Measure Improvement
272 ,p_measure_random_style IN number := NULL --Measure random style
273 ,p_measure_min_act_value IN number := NULL --min value for actual
274 ,p_measure_max_act_value IN number := NULL --max value for actual
275 ,p_page_function_name IN VARCHAR2
276 ,p_kpi_portlet_function_name IN VARCHAR2
277 ,p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_TRUE -- Create a region per analysis option.
278 ,p_Measure_App_Id IN NUMBER := NULL
279 ,p_Func_Area_Short_Name IN VARCHAR2 := NULL
280 ,x_measure_short_name OUT NOCOPY VARCHAR2
281 ,x_kpi_id OUT NOCOPY number
282 ,x_return_status OUT NOCOPY varchar2
283 ,x_msg_count OUT NOCOPY number
284 ,x_msg_data OUT NOCOPY varchar2
285 );
286
287
288 PROCEDURE Get_Dim_Info_From_Region_Code(
289 p_param_portlet_region_code IN VARCHAR2
290 ,x_non_time_dimension_groups OUT NOCOPY bsc_varchar2_tbl_type
291 ,x_non_time_dimension_objects OUT NOCOPY bsc_varchar2_tbl_type
292 ,x_non_time_dim_obj_short_names OUT NOCOPY VARCHAR2
293 ,x_all_dim_group_ids OUT NOCOPY bsc_number_tbl_type
294 ,x_non_time_counter OUT NOCOPY NUMBER
295 ,x_time_dimension_groups OUT NOCOPY bsc_varchar2_tbl_type
296 ,x_time_dimension_objects OUT NOCOPY bsc_varchar2_tbl_type
297 ,x_time_dim_obj_short_names OUT NOCOPY VARCHAR2
298 ,x_time_counter OUT NOCOPY NUMBER
299 ,x_msg_data OUT NOCOPY VARCHAR2);
300
301
302 PROCEDURE Create_Dim_Level_Region_Item(
303 p_commit VARCHAR2 := FND_API.G_FALSE
304 ,p_non_time_counter NUMBER
305 ,p_non_time_dimension_objects bsc_varchar2_tbl_type
306 ,p_non_time_dimension_groups bsc_varchar2_tbl_type
307 ,p_time_counter NUMBER
308 ,p_time_dimension_objects bsc_varchar2_tbl_type
309 ,p_time_dimension_groups bsc_varchar2_tbl_type
310 ,p_kpi_id NUMBER
311 ,p_Analysis_Option NUMBER := NULL
312 ,x_sequence IN OUT NOCOPY NUMBER
313 ,x_return_status OUT NOCOPY VARCHAR2
314 ,x_msg_count OUT NOCOPY NUMBER
315 ,x_msg_data OUT NOCOPY VARCHAR2);
316
317
318
319
320 PROCEDURE Create_Measure(
321 p_commit VARCHAR2 := FND_API.G_FALSE
322 ,x_dataset_id OUT NOCOPY NUMBER
323 ,p_kpi_id NUMBER
324 ,p_dataset_source VARCHAR2
325 ,p_measure_name VARCHAR2
326 ,p_measure_short_name VARCHAR2
327 ,p_measure_description VARCHAR2
328 ,p_dataset_format_id NUMBER
329 ,p_dataset_autoscale_flag NUMBER
330 ,p_measure_operation VARCHAR2
331 ,p_measure_increase_in_measure VARCHAR2
332 ,p_measure_obsolete VARCHAR2 := FND_API.G_FALSE
333 ,p_type VARCHAR2
334 ,p_measure_random_style NUMBER
335 ,p_measure_min_act_value NUMBER
336 ,p_measure_max_act_value NUMBER
337 ,p_measure_type NUMBER
338 ,p_measure_function_name VARCHAR2
339 ,p_measure_group_id NUMBER
340 ,p_dimension1_id NUMBER
341 ,p_dimension2_id NUMBER
342 ,p_dimension3_id NUMBER
343 ,p_dimension4_id NUMBER
344 ,p_dimension5_id NUMBER
345 ,p_dimension6_id NUMBER
346 ,p_dimension7_id NUMBER
347 ,p_Measure_App_Id NUMBER := NULL
348 ,p_Func_Area_Short_Name VARCHAR2 := NULL
349 ,x_return_status OUT NOCOPY VARCHAR2
350 ,x_msg_count OUT NOCOPY NUMBER
351 ,x_msg_data OUT NOCOPY VARCHAR2
352 );
353
354
355 PROCEDURE Associate_KPI_To_AO(
356 p_commit VARCHAR2 := FND_API.G_FALSE
357 ,p_indicator NUMBER
358 ,p_dataset_id NUMBER
359 ,p_measure_name VARCHAR2
360 ,p_measure_description VARCHAR2
361 ,x_measure_short_name OUT NOCOPY VARCHAR2
362 ,x_return_status OUT NOCOPY VARCHAR2
363 ,x_msg_count OUT NOCOPY NUMBER
364 ,x_msg_data OUT NOCOPY VARCHAR2);
365
366
367 PROCEDURE Create_Measure_Region_Item(
368 p_commit VARCHAR2 := FND_API.G_FALSE
369 ,p_measure_short_name VARCHAR2
370 ,p_sequence_number NUMBER
371 ,p_kpi_id NUMBER
372 ,p_Analysis_Option NUMBER := NULL
373 ,p_dataset_format_id NUMBER
374 ,p_dataset_autoscale_flag NUMBER
375 ,p_Analysis_Option_Name VARCHAR2
376 ,x_return_status OUT NOCOPY varchar2
377 ,x_msg_count OUT NOCOPY number
378 ,x_msg_data OUT NOCOPY varchar2
379 );
380
381
382
383 FUNCTION Does_Dim_Grp_Exist(p_param_portlet_region_code VARCHAR2) RETURN BOOLEAN;
384
385 FUNCTION Does_KPI_Exist(p_portlet_function_name VARCHAR2) RETURN BOOLEAN;
386
387
388 FUNCTION FIND_MAX_SEQ_OF_REGION_ITEM(p_region_code VARCHAR2) RETURN NUMBER;
389
390
391
392 PROCEDURE RETRIEVE_DIMENSION_OBJECTS(p_region_code VARCHAR2,
393 x_dim_obj_list OUT NOCOPY VARCHAR2,
394 x_msg_data OUT NOCOPY VARCHAR2);
395
396 FUNCTION GET_TAB_ID(p_page_function_name VARCHAR2) RETURN NUMBER;
397
398 FUNCTION GET_GROUP_ID(p_kpi_portlet_function_name VARCHAR2) RETURN NUMBER;
399
400 procedure Assign_Kpi_Periodicities(
401 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
402 ,p_kpi_id IN NUMBER
403 ,p_Time_Dim_obj_sns IN VARCHAR2 -- 'MONTH,QUATERLY'
404 ,p_Dft_Dim_obj_sn IN VARCHAR2 --:= NULL
405 ,p_Daily_Flag IN VARCHAR2 --:= FND_API.G_FALSE
406 ,p_Is_XTD_Enabled IN VARCHAR2 -- := 'F' or 'T'
407 ,x_return_status OUT NOCOPY VARCHAR2
408 ,x_msg_count OUT NOCOPY NUMBER
409 ,x_msg_data OUT NOCOPY VARCHAR2
410 );
411
412
413 FUNCTION Is_More( p_dim_short_names IN OUT NOCOPY VARCHAR2
414 , p_dim_name OUT NOCOPY VARCHAR2
415 ) RETURN BOOLEAN;
416
417
418
419
420 PROCEDURE Update_Actual_Data_Source(
421 p_kpi_id IN NUMBER
422 , p_dataset_id IN NUMBER
423 , p_measure_short_name IN VARCHAR2
424 , p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_FALSE
425
426 );
427
428
429
430 PROCEDURE Update_Dim_Dim_Level_Columns(
431 p_dim_object_short_name VARCHAR2,
432 p_non_time_dimension_objects bsc_varchar2_tbl_type,
433 p_non_time_counter NUMBER,
434 x_msg_data OUT NOCOPY VARCHAR2);
435
436
437 PROCEDURE Update_Kpi_End_To_End(
438 p_commit IN VARCHAR2 := FND_API.G_FALSE
439 ,p_param_portlet_region_code IN VARCHAR2
440 ,p_page_function_name IN VARCHAR2
441 ,p_kpi_portlet_function_name IN VARCHAR2
442 ,p_measure_name IN VARCHAR2
443 ,p_measure_short_name IN VARCHAR2 := NULL
444 ,p_measure_description IN VARCHAR2 := NULL
445 ,p_measure_type IN NUMBER := NULL --Activity/Balance
446 ,p_measure_operation IN VARCHAR2 := BSC_BIS_MEASURE_PUB.c_SUM --Aggregation method
447 ,p_dataset_format_id IN NUMBER := NULL --data format
448 ,p_dataset_autoscale_flag IN NUMBER := NULL --autoscale flag
449 ,p_measure_increase_in_measure IN VARCHAR2 := NULL --Measure Improve.
450 ,p_measure_random_style IN NUMBER := NULL --Measure random style
451 ,p_measure_min_act_value IN NUMBER := NULL --min value for actual
452 ,p_measure_max_act_value IN NUMBER := NULL --max value for actual
453 ,p_Measure_App_Id IN NUMBER := NULL
454 ,p_Func_Area_Short_Name IN VARCHAR2 := NULL
455 ,x_return_status OUT NOCOPY VARCHAR2
456 ,x_msg_count OUT NOCOPY NUMBER
457 ,x_msg_data OUT NOCOPY VARCHAR2
458 );
459
460
461 PROCEDURE Update_Measure_Region_Item(
462 p_commit VARCHAR2
463 ,p_measure_short_name VARCHAR2
464 ,p_sequence_number NUMBER
465 ,p_kpi_id NUMBER
466 ,p_Analysis_Option NUMBER := NULL
467 ,p_dataset_format_id NUMBER
468 ,p_dataset_autoscale_flag NUMBER
469 ,p_Analysis_Option_Name VARCHAR2
470 ,x_return_status OUT NOCOPY VARCHAR2
471 ,x_msg_count OUT NOCOPY NUMBER
472 ,x_msg_data OUT NOCOPY VARCHAR2
473 );
474
475
476 PROCEDURE Delete_Kpi_End_To_End(
477 p_commit IN VARCHAR2 := FND_API.G_FALSE
478 ,p_param_portlet_region_code IN VARCHAR2
479 ,p_measure_short_name IN VARCHAR2 := NULL
480 ,p_page_function_name IN VARCHAR2
481 ,p_kpi_portlet_function_name IN VARCHAR2
482 ,x_return_status OUT NOCOPY VARCHAR2
483 ,x_msg_count OUT NOCOPY NUMBER
484 ,x_msg_data OUT NOCOPY VARCHAR2
485 ) ;
486
487
488 PROCEDURE Delete_Measure_Region_Item(
489 p_commit VARCHAR2 := FND_API.G_FALSE
490 ,p_Param_Portlet_Region_Code VARCHAR2
491 ,p_Measure_Short_Name VARCHAR2
492 ,p_Application_Id NUMBER
493 ,x_return_status OUT NOCOPY VARCHAR2
494 ,x_msg_count OUT NOCOPY NUMBER
495 ,x_msg_data OUT NOCOPY VARCHAR2
496 );
497
498 PROCEDURE Unassign_Kpi_Analysis_Option (
499 p_Commit VARCHAR2 := FND_API.G_FALSE
500 ,p_Kpi_Id NUMBER
501 ,p_Dataset_Id NUMBER
502 ,x_return_status OUT NOCOPY VARCHAR2
503 ,x_msg_count OUT NOCOPY NUMBER
504 ,x_msg_data OUT NOCOPY VARCHAR2
505 );
506
507
508 FUNCTION Get_Num_Measures_By_Kpi(p_Kpi_Id NUMBER) RETURN NUMBER;
509
510 FUNCTION Get_Kpi_Id(p_Page_Function_Name VARCHAR2) RETURN NUMBER;
511
512 PROCEDURE Delete_Dim_Level_Region_Item(
513 p_commit VARCHAR2 := FND_API.G_FALSE
514 ,p_Application_Id NUMBER
515 ,p_Non_Time_Counter NUMBER
516 ,p_Non_Time_Dimension_Objects bsc_varchar2_tbl_type
517 ,p_Non_Time_Dimension_Groups bsc_varchar2_tbl_type
518 ,p_Time_Counter NUMBER
519 ,p_Time_Dimension_Objects bsc_varchar2_tbl_type
520 ,p_Time_Dimension_Groups bsc_varchar2_tbl_type
521 ,p_Region_Code VARCHAR2
522 ,x_Return_Status OUT NOCOPY VARCHAR2
523 ,x_Msg_Count OUT NOCOPY NUMBER
524 ,x_Msg_Data OUT NOCOPY VARCHAR2
525 );
526
527
528 FUNCTION Get_Function_Id_By_Name(p_kpi_portlet_function_name VARCHAR2) RETURN NUMBER;
529
530 PROCEDURE Update_Kpi_Analysis_Option (
531 p_Commit VARCHAR2 := FND_API.G_FALSE
532 ,p_Kpi_Id NUMBER
533 ,p_Dataset_Id NUMBER
534 ,p_Measure_Name VARCHAR2
535 ,p_Measure_Description VARCHAR2
536 ,x_return_status OUT NOCOPY VARCHAR2
537 ,x_msg_count OUT NOCOPY NUMBER
538 ,x_msg_data OUT NOCOPY VARCHAR2
539 );
540
541 FUNCTION Get_Sequence_Id_By_Region(
542 p_Region_Code VARCHAR2
543 , p_Region_Application_Id NUMBER
544 , p_Attribute_Code VARCHAR2
545 , p_Attribute_Application_Id NUMBER
546 ) RETURN NUMBER;
547
548
549 FUNCTION Get_Dataset_Id(
550 p_measure_short_name IN VARCHAR2
551 ) RETURN NUMBER;
552
553 PROCEDURE Get_Page_Name (
554 p_Page_Function_Name IN VARCHAR2
555 , p_Kpi_Portlet_Function_Name IN VARCHAR2
556 , x_Page_Names OUT NOCOPY VARCHAR2
557 );
558
559 FUNCTION Get_AO_Id_By_Measure (
560 p_Kpi_Id NUMBER
561 ,p_Dataset_Id NUMBER
562 ) RETURN NUMBER ;
563
564
565 PROCEDURE Create_Region_By_AO (
566 p_Commit VARCHAR2 := FND_API.G_FALSE
567 , p_Kpi_Id IN NUMBER
568 , p_Analysis_Option_Id IN NUMBER := NULL
569 , p_Dim_Set_Id IN NUMBER
570 , p_Region_Name IN VARCHAR2
571 , p_Region_Description IN VARCHAR2
572 , p_Region_Application_Id IN NUMBER
573 , p_Disable_View_By IN VARCHAR2 := 'N'
574 , x_return_status OUT NOCOPY VARCHAR2
575 , x_msg_count OUT NOCOPY NUMBER
576 , x_msg_data OUT NOCOPY VARCHAR2
577 );
578
579 PROCEDURE Update_Region_By_AO (
580 p_Commit VARCHAR2 := FND_API.G_FALSE
581 , p_Kpi_Id IN NUMBER
582 , p_Analysis_Option_Id IN NUMBER
583 , p_Dim_Set_Id IN NUMBER
584 , p_Region_Name IN VARCHAR2
585 , p_Region_Description IN VARCHAR2
586 , p_Region_Application_Id IN NUMBER
587 , p_Disable_View_By IN VARCHAR2 := 'N'
588 , x_return_status OUT NOCOPY VARCHAR2
589 , x_msg_count OUT NOCOPY NUMBER
590 , x_msg_data OUT NOCOPY VARCHAR2
591 );
592
593 PROCEDURE Get_KPI_AO_From_Region(
594 p_Region_Code IN VARCHAR2
595 , x_Kpi_Id OUT NOCOPY NUMBER
596 , x_Analysis_Option_Id OUT NOCOPY NUMBER
597 ) ;
598
599 FUNCTION Has_Region_Per_Measure (
600 p_Region_Code IN VARCHAR2
601 ) RETURN BOOLEAN;
602
603 FUNCTION is_Valid_Region_Code (
604 p_Region_Code IN VARCHAR2
605 ) RETURN BOOLEAN;
606
607 FUNCTION has_Measure_AK_Region (
608 p_Kpi_Id NUMBER
609 ,p_Dataset_Id NUMBER
610 ) RETURN BOOLEAN ;
611
612 FUNCTION has_Dim_Level (
613 p_Region_Code VARCHAR2
614 ) RETURN BOOLEAN;
615
616 FUNCTION Get_Region_Application_Id (
617 p_Region_Code VARCHAR2
618 ) RETURN NUMBER;
619
620
621 FUNCTION Get_Format_Mask (
622 p_Format_Id NUMBER
623 ) RETURN VARCHAR2;
624
625 -- Create a nested region for a parameter portlet region code.
626
627 PROCEDURE Create_Nested_Region_Item(
628 p_commit IN VARCHAR2
629 , p_Root_AK_Region_Code IN VARCHAR2
630 , p_Param_Portlet_Region_Code IN VARCHAR2
631 , p_sequence_number IN NUMBER
632 , x_return_status OUT NOCOPY VARCHAR2
633 , x_msg_count OUT NOCOPY NUMBER
634 , x_msg_data OUT NOCOPY VARCHAR2
635 );
636
637 PROCEDURE Delete_Nested_Region_Item(
638 p_commit VARCHAR2 := FND_API.G_FALSE,
639 p_Root_AK_Region VARCHAR2,
640 p_Application_Id NUMBER,
641 p_Nested_Region_Code VARCHAR2,
642 x_return_status OUT NOCOPY VARCHAR2,
643 x_msg_count OUT NOCOPY NUMBER,
644 x_msg_data OUT NOCOPY VARCHAR2
645 );
646
647
648 /*this function will return 'T' if the passed short_name of KPI Group
649 is created through KPI End to End module otherwise 'F'
650 */
651 FUNCTION is_KPI_EndToEnd_Group(p_Short_Name VARCHAR2) RETURN VARCHAR2;
652
653
654 /*this function will return 'T' if the passed short_name of KPI
655 is created through KPI End to End module otherwise 'F'
656 */
657 FUNCTION is_KPI_EndToEnd_KPI(p_Short_Name VARCHAR2) RETURN VARCHAR2;
658
659
660 /*this function will return 'T' if the passed short_name of Dimension
661 is created through KPI End to End module otherwise 'F'
662 */
663 FUNCTION is_KPI_EndToEnd_Dimension(p_Short_Name VARCHAR2) RETURN VARCHAR2;
664
665 /*this function will return 'T' if the passed short_name of Dimension Object
666 is created through KPI End to End module otherwise 'F'
667 */
668 FUNCTION is_KPI_EndToEnd_DimObject(p_Short_Name VARCHAR2) RETURN VARCHAR2;
669
670 FUNCTION is_KPI_EndToEnd_AnaOpt(p_Short_Name VARCHAR2) RETURN VARCHAR2;
671
672 -- Gets a unqiue region item Attribute Code.
673 FUNCTION get_Unique_Attribute_Code (
674 p_Region_Code IN VARCHAR2
675 , p_Measure_Short_Name IN VARCHAR2
676 , p_Append_String IN VARCHAR2
677 ) RETURN VARCHAR2;
678
679
680 FUNCTION get_measure_group_id (p_kpi_portlet_function_name IN VARCHAR2,
681 x_return_status OUT NOCOPY VARCHAR2, x_msg_data OUT NOCOPY VARCHAR2
682
683 ) RETURN NUMBER;
684
685
686 PROCEDURE Create_Sim_Generic_Region_Item(
687 p_commit IN VARCHAR2 := FND_API.G_FALSE
688 , p_Region_Code IN VARCHAR2
689 , p_Region_Application_Id IN NUMBER
690 , p_Attribute_Code IN VARCHAR2
691 , p_Attribute_Application_Id IN NUMBER
692 , p_Display_Sequence IN NUMBER
693 , p_Node_Display_Flag IN VARCHAR2
694 , p_Required_Flag IN VARCHAR2
695 , p_Queryable_Flag IN VARCHAR2
696 , p_Display_Length IN NUMBER
697 , p_Long_Label IN VARCHAR2
698 , p_Url IN VARCHAR2
699 , p_Attribute_Type IN VARCHAR2
700 , p_Display_Format IN VARCHAR2
701 , p_Display_Type IN VARCHAR2
702 , p_Measure_Level IN VARCHAR2
703 , p_Base_Column IN VARCHAR2
704 , p_Graph_Position IN NUMBER
705 , p_Graph_Style IN VARCHAR2
706 , p_Aggregate_Function IN VARCHAR2
707 , p_Display_Total IN VARCHAR2
708 , p_Graph_Measure_Type IN VARCHAR2
709 , p_Item_Style IN VARCHAR2
710 , p_Grand_Total_Flag IN VARCHAR2
711 , p_Nested_Region_Code IN VARCHAR2
712 , p_Nested_Region_Application_Id IN NUMBER
713 , x_return_status OUT NOCOPY VARCHAR2
714 , x_msg_count OUT NOCOPY NUMBER
715 , x_msg_data OUT NOCOPY VARCHAR2
716 );
717
718 PROCEDURE Create_Addl_Ak_Region_Items(
719 p_commit IN VARCHAR2 := FND_API.G_FALSE
720 , p_Region_Code IN VARCHAR2
721 , p_Region_Application_Id IN NUMBER
722 , p_Display_Sequence IN NUMBER
723 , p_Display_Format IN VARCHAR2
724 , p_Format_Id IN NUMBER
725 , p_Measure_Short_Name IN VARCHAR2
726 , p_Param_Portlet_Region_Code IN VARCHAR2
727 , p_Analysis_Option_Name IN VARCHAR2
728 , p_Kpi_Id IN NUMBER
729 , x_return_status OUT NOCOPY VARCHAR2
730 , x_msg_count OUT NOCOPY NUMBER
731 , x_msg_data OUT NOCOPY VARCHAR2
732 );
733
734
735 PROCEDURE Delete_Misc_Region_Items(
736 p_commit VARCHAR2 := FND_API.G_FALSE,
737 p_Region_Code VARCHAR2,
738 p_Application_Id NUMBER,
739 x_return_status OUT NOCOPY VARCHAR2,
740 x_msg_count OUT NOCOPY NUMBER,
741 x_msg_data OUT NOCOPY VARCHAR2
742 );
743
744 PROCEDURE Update_Sim_Generic_Region_Item(
745 p_commit IN VARCHAR2 := FND_API.G_FALSE
746 , p_Region_Code IN VARCHAR2
747 , p_Region_Application_Id IN NUMBER
748 , p_Attribute_Code IN VARCHAR2
749 , p_Attribute_Application_Id IN NUMBER
750 , p_Display_Sequence IN NUMBER
751 , p_Node_Display_Flag IN VARCHAR2
752 , p_Required_Flag IN VARCHAR2
753 , p_Queryable_Flag IN VARCHAR2
754 , p_Display_Length IN NUMBER
755 , p_Long_Label IN VARCHAR2
756 , p_Url IN VARCHAR2
757 , p_Attribute_Type IN VARCHAR2
758 , p_Display_Format IN VARCHAR2
759 , p_Display_Type IN VARCHAR2
760 , p_Measure_Level IN VARCHAR2
761 , p_Base_Column IN VARCHAR2
762 , p_Graph_Position IN NUMBER
763 , p_Graph_Style IN VARCHAR2
764 , p_Aggregate_Function IN VARCHAR2
765 , p_Display_Total IN VARCHAR2
766 , p_Graph_Measure_Type IN VARCHAR2
767 , p_Item_Style IN VARCHAR2
768 , p_Grand_Total_Flag IN VARCHAR2
769 , p_Nested_Region_Code IN VARCHAR2
770 , p_Nested_Region_Application_Id IN NUMBER
771 , x_return_status OUT NOCOPY VARCHAR2
772 , x_msg_count OUT NOCOPY NUMBER
773 , x_msg_data OUT NOCOPY VARCHAR2
774 );
775
776 PROCEDURE Update_Addl_Ak_Region_Items(
777 p_commit IN VARCHAR2 := FND_API.G_FALSE
778 , p_Region_Code IN VARCHAR2
779 , p_Region_Application_Id IN NUMBER
780 , p_Display_Format IN VARCHAR2
781 , p_Format_id IN NUMBER
782 , p_Measure_Short_Name IN VARCHAR2
783 , x_return_status OUT NOCOPY VARCHAR2
784 , x_msg_count OUT NOCOPY NUMBER
785 , x_msg_data OUT NOCOPY VARCHAR2
786 );
787
788
789 PROCEDURE is_Kpi_In_Production(
790 p_Page_Function_Name IN VARCHAR2
791 , x_Is_Kpi_In_Production OUT NOCOPY VARCHAR2
792 );
793
794
795 PROCEDURE Create_Dimension(
796 p_Commit IN VARCHAR2 := FND_API.G_FALSE
797 ,p_Dim_Short_Name IN VARCHAR2
798 ,p_Display_Name IN VARCHAR2
799 ,p_Description IN VARCHAR2
800 ,p_Dim_Objs_Record IN BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE
801 ,p_Dim_Obj_Short_Names IN VARCHAR2
802 ,p_Dim_Objects_Counter IN NUMBER
803 ,p_Application_Id IN NUMBER
804 ,p_hide IN VARCHAR2 := FND_API.G_FALSE
805 ,x_Return_Status OUT NOCOPY VARCHAR2
806 ,x_Msg_Count OUT NOCOPY NUMBER
807 ,x_Msg_Data OUT NOCOPY VARCHAR2
808 );
809
810 PROCEDURE Create_Ak_Metadata(
811 p_Commit IN VARCHAR2 := FND_API.G_FALSE
812 , p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_TRUE
813 , p_Kpi_Id IN NUMBER
814 , p_Analysis_Option_Id IN NUMBER
815 , p_Dim_Set_Id IN NUMBER
816 , p_Measure_Short_Name IN VARCHAR2
817 , p_Measure_Name IN VARCHAR2
818 , p_Measure_Description IN VARCHAR2
819 , p_User_Portlet_Name IN VARCHAR2
820 , p_Dataset_Format_Id IN NUMBER
821 , p_Application_Id IN NUMBER
822 , p_Disable_View_By IN VARCHAR2
823 , p_Param_Portlet_Region_Code IN VARCHAR2
824 , x_Return_Status OUT NOCOPY VARCHAR2
825 , x_Msg_Count OUT NOCOPY NUMBER
826 , x_Msg_Data OUT NOCOPY VARCHAR2
827 );
828
829
830 /*
831 Added the following parameter for Report Designer
832
833 - p_Region_Function_Name IN VARCHAR2
834 - p_Region_User_Function_Name IN VARCHAR2
835 - p_Dim_Obj_Short_Names IN NUMBER
836 - p_Measure_Short_Name IN NUMBER
837 */
838
839 PROCEDURE Create_Bsc_Bis_Metadata(
840 p_Commit IN VARCHAR2
841 , p_Create_Region_Per_Ao IN VARCHAR2
842 , p_Param_Portlet_Region_Code IN VARCHAR2
843 , p_Page_Function_Name IN VARCHAR2
844 , p_Kpi_Portlet_Function_Name IN VARCHAR2
845 , p_Region_Function_Name IN VARCHAR2
846 , p_Region_User_Function_Name IN VARCHAR2
847 , p_Dim_Obj_Short_Names IN VARCHAR2
848 , p_Force_Create_Dim IN VARCHAR2
849 , p_Measure_Short_Name IN VARCHAR2
850 , p_Responsibility_Id IN NUMBER
851 , p_Measure_Name IN VARCHAR2
852 , p_Measure_Description IN VARCHAR2
853 , p_Dataset_Format_Id IN NUMBER
854 , p_Dataset_Autoscale_Flag IN NUMBER
855 , p_Measure_Operation IN VARCHAR2
856 , p_Measure_Increase_In_Measure IN VARCHAR2
857 ,p_Measure_Obsolete IN VARCHAR2 := FND_API.G_FALSE
858 ,p_Type IN VARCHAR2
859 , p_Measure_Random_Style IN NUMBER
860 , p_Measure_Min_Act_Value IN NUMBER
861 , p_Measure_Max_Act_Value IN NUMBER
862 , p_Measure_Type IN NUMBER
863 , p_Measure_App_Id IN NUMBER := NULL
864 , p_Func_Area_Short_Name IN VARCHAR2 := NULL
865 , x_Measure_Short_Name OUT NOCOPY VARCHAR2
866 , x_Kpi_Id OUT NOCOPY NUMBER
867 , x_Return_Status OUT NOCOPY VARCHAR2
868 , x_Msg_Count OUT NOCOPY NUMBER
869 , x_Msg_Data OUT NOCOPY VARCHAR2
870 );
871
872 PROCEDURE Delete_AK_Metadata(
873 p_Commit IN VARCHAR2
874 , p_Region_Code IN VARCHAR2
875 , p_Region_Code_Application_Id IN NUMBER
876 , x_Return_Status OUT NOCOPY VARCHAR2
877 , x_Msg_Count OUT NOCOPY NUMBER
878 , x_Msg_Data OUT NOCOPY VARCHAR2
879 );
880
881 PROCEDURE Referesh_AK_Metadata (
882 p_Commit IN VARCHAR2
883 , p_Kpi_Id IN NUMBER
884 , p_Deleted_AO_Index IN NUMBER
885 , p_Param_Portlet_Region_Code IN VARCHAR2
886 , x_Return_Status OUT NOCOPY VARCHAR2
887 , x_Msg_Count OUT NOCOPY NUMBER
888 , x_Msg_Data OUT NOCOPY VARCHAR2
889 );
890
891 PROCEDURE Apply_Disabled_Calculations (
892 p_Commit IN VARCHAR2
893 , p_Dataset_Id IN NUMBER
894 , x_Return_Status OUT NOCOPY VARCHAR2
895 , x_Msg_Count OUT NOCOPY NUMBER
896 , x_Msg_Data OUT NOCOPY VARCHAR2
897 );
898
899 PROCEDURE Enable_Kpi_Calculation (
900 p_Commit IN VARCHAR2
901 , p_Kpi_Id IN NUMBER
902 , p_Calculation_Id IN NUMBER
903 , p_Default_Checked IN NUMBER
904 , x_Return_Status OUT NOCOPY VARCHAR2
905 , x_Msg_Count OUT NOCOPY NUMBER
906 , x_Msg_Data OUT NOCOPY VARCHAR2
907 );
908
909 PROCEDURE Get_Dim_Obj_By_Dimension
910 (
911 p_Dim_Short_Name IN VARCHAR2
912 , x_Time_Dim_Obj_Short_Names OUT NOCOPY VARCHAR2
913 , x_Time_Dim_Obj_Counter OUT NOCOPY NUMBER
914 , x_Non_Time_Dim_Obj_Short_Names OUT NOCOPY VARCHAR2
915 , x_Non_Time_Dim_Obj_Counter OUT NOCOPY NUMBER
916 , x_Return_Status OUT NOCOPY VARCHAR2
917 , x_Msg_Count OUT NOCOPY NUMBER
918 , x_Msg_Data OUT NOCOPY VARCHAR2
919 );
920
921 PROCEDURE Get_Time_Dim_Obj_By_Dim
922 (
923 p_Dim_Short_Name IN VARCHAR2
924 , x_Time_Dim_Obj_Short_Names OUT NOCOPY VARCHAR2
925 , x_Time_Dim_Obj_Counter OUT NOCOPY NUMBER
926 , x_Return_Status OUT NOCOPY VARCHAR2
927 , x_Msg_Count OUT NOCOPY NUMBER
928 , x_Msg_Data OUT NOCOPY VARCHAR2
929 );
930
931 PROCEDURE Get_Non_Time_Dim_Obj_By_Dim
932 (
933 p_Dim_Short_Name IN VARCHAR2
934 , x_Non_Time_Dim_Obj_Short_Names OUT NOCOPY VARCHAR2
935 , x_Non_Time_Dim_Obj_Counter OUT NOCOPY NUMBER
936 , x_Return_Status OUT NOCOPY VARCHAR2
937 , x_Msg_Count OUT NOCOPY NUMBER
938 , x_Msg_Data OUT NOCOPY VARCHAR2
939 );
940
941 FUNCTION Is_Time_Dim_Obj (
942 p_Dim_Obj_Short_Name IN VARCHAR2
943 ) RETURN VARCHAR2;
944
945
946 PROCEDURE Is_Time_Dim_Obj (
947 p_Dim_Obj_Short_Name IN VARCHAR2
948 , x_Is_Time_Dim_Obj OUT NOCOPY VARCHAR2
949 );
950
951 PROCEDURE Is_Time_Dimension (
952 p_Dimension_Short_Name IN VARCHAR2
953 , x_Is_Time_Dimension OUT NOCOPY VARCHAR2
954 );
955
956 FUNCTION Get_Next_Region_Code_By_AO (
957 p_Kpi_Id IN NUMBER
958 , p_Analysis_Group0 IN NUMBER
959 ) RETURN VARCHAR2;
960
961 FUNCTION Get_Objective_By_Kpi(
962 p_Short_Name IN VARCHAR2
963 ) RETURN VARCHAR2;
964
965 -- Gets the parameter portlet associated with the current AK Region.
966 FUNCTION Get_Param_Portlet_By_Region (
967 p_Region_Code IN VARCHAR2
968 ) RETURN VARCHAR2;
969
970 -- Checks if AS_OF_DATE is enabled for the Parameter Portlet
971 FUNCTION is_XTD_Enabled (
972 p_Region_Code IN VARCHAR2
973 ) RETURN VARCHAR2;
974
975
976 FUNCTION Get_S2EObjective_With_XTD
977 RETURN VARCHAR2;
978
979 -- Returns if the Dimension Object(level) has been excluded from Constant Class
980 -- BSC_BIS_KPI_CRUD_PUB.G_EXCLUDE_DIMOBJ_CLASS
981
982 FUNCTION Is_Excluded_Dimension_Object(
983 p_Short_Name IN VARCHAR2
984 ) RETURN VARCHAR2;
985
986 -- Validates of the Start-to-End KPI can be deleted using the Delete button from Update KPI Page.
987 PROCEDURE Validate_Kpi_Delete
988 (
989 p_Measure_Short_Name IN VARCHAR2
990 , x_Return_Status OUT NOCOPY VARCHAR2
991 , x_Msg_Count OUT NOCOPY NUMBER
992 , x_Msg_Data OUT NOCOPY VARCHAR2
993 );
994
995
996 -- Loads DBI calendar required for Start-to-End KPI.
997 PROCEDURE Populate_DBI_Calendar
998 (
999 x_Return_Status OUT NOCOPY VARCHAR2
1000 , x_Msg_Count OUT NOCOPY NUMBER
1001 , x_Msg_Data OUT NOCOPY VARCHAR2
1002 );
1003
1004 -- added for Bug#3777647
1005 PROCEDURE Get_Region_Codes_By_Short_Name
1006 (
1007 p_Short_Name IN VARCHAR
1008 , x_Region_Codes OUT NOCOPY VARCHAR2
1009 );
1010
1011 /*
1012 Check_XTD_Summarization returns the error message, when the XTD is available at the
1013 Parameter Portlet level and the profile ADV Summarization is truned off.
1014 */
1015
1016 PROCEDURE Check_XTD_Summarization
1017 (
1018 p_Param_Portlet_Region_Code IN VARCHAR2
1019 , x_Return_Status OUT NOCOPY VARCHAR2
1020 , x_Msg_Count OUT NOCOPY NUMBER
1021 , x_Msg_Data OUT NOCOPY VARCHAR2
1022 );
1023
1024
1025 PROCEDURE Get_Kpi_Details
1026 (
1027 p_Measure_Short_Name IN VARCHAR2
1028 , x_Kpi_Name OUT NOCOPY VARCHAR2
1029 , x_Report_Code OUT NOCOPY VARCHAR2
1030 );
1031
1032 -- added for Bug#3876413
1033 FUNCTION Get_Change_Disp_Type_By_Mask (
1034 p_Format_Id NUMBER
1035 ) RETURN VARCHAR2;
1036
1037
1038 -- added for bug#3893949
1039
1040 PROCEDURE Get_S2ESCR_DeleteMessage(
1041 p_tabId IN number
1042 ,x_return_status OUT NOCOPY varchar2
1043 ,x_msg_count OUT NOCOPY number
1044 ,x_msg_data OUT NOCOPY varchar2
1045 );
1046
1047 procedure Delete_S2E_Metadata(
1048 p_commit IN VARCHAR2 := FND_API.G_FALSE
1049 ,p_tab_id IN number
1050 ,x_return_status OUT NOCOPY varchar2
1051 ,x_msg_count OUT NOCOPY number
1052 ,x_msg_data OUT NOCOPY varchar2
1053 );
1054
1055
1056 FUNCTION Has_Compare_To_Or_Plan (p_param_portlet_region_code IN VARCHAR2) RETURN BOOLEAN ;
1057
1058 PROCEDURE Get_Dim_Info_From_ParamPortlet(
1059 p_Dimension_Info IN VARCHAR2
1060 ,x_non_time_dimension_groups OUT NOCOPY BSC_VARCHAR2_TBL_TYPE
1061 ,x_non_time_dimension_objects OUT NOCOPY BSC_VARCHAR2_TBL_TYPE
1062 ,x_non_time_dim_obj_short_names OUT NOCOPY VARCHAR2
1063 ,x_all_dim_group_ids OUT NOCOPY BSC_NUMBER_TBL_TYPE
1064 ,x_non_time_counter OUT NOCOPY NUMBER
1065 ,x_time_dimension_groups OUT NOCOPY BSC_VARCHAR2_TBL_TYPE
1066 ,x_time_dimension_objects OUT NOCOPY BSC_VARCHAR2_TBL_TYPE
1067 ,x_time_dim_obj_short_names OUT NOCOPY VARCHAR2
1068 ,x_time_counter OUT NOCOPY NUMBER
1069 ,x_msg_data OUT NOCOPY VARCHAR2
1070 ,x_is_as_of_date OUT NOCOPY VARCHAR2
1071 );
1072
1073
1074 FUNCTION is_XTD_Enabled (
1075 p_Time_Dimension_Objects IN BSC_VARCHAR2_TBL_TYPE
1076 ) RETURN VARCHAR2;
1077
1078
1079 /*
1080 Refresh the AK/BSC/BIS Metadata
1081 */
1082
1083 PROCEDURE Refresh_Ak_Bsc_Bis_Metadata(
1084 p_Commit IN VARCHAR2
1085 , p_Region_Code IN VARCHAR2
1086 , p_Region_Application_Id IN NUMBER
1087 , p_Kpi_Id IN NUMBER
1088 , p_Analysis_Option_Id IN NUMBER
1089 , p_Dim_Set_Id IN NUMBER
1090 , p_Dim_Obj_Short_Names IN VARCHAR2
1091 , p_Force_Create_Dim IN VARCHAR2
1092 , x_Return_Status OUT NOCOPY VARCHAR2
1093 , x_Msg_Count OUT NOCOPY NUMBER
1094 , x_Msg_Data OUT NOCOPY VARCHAR2
1095 );
1096
1097 PROCEDURE Refresh_Ak_Bsc_Bis_Metadata(
1098 p_Commit IN VARCHAR2
1099 , p_Region_Code IN VARCHAR2
1100 , p_Region_Application_Id IN NUMBER
1101 , p_Kpi_Id IN NUMBER
1102 , p_Analysis_Option_Id IN NUMBER
1103 , p_Dim_Set_Id IN NUMBER
1104 , p_Global_Menu IN VARCHAR2
1105 , p_Global_Title IN VARCHAR2
1106 , p_Dim_Obj_Short_Names IN VARCHAR2
1107 , p_Force_Create_Dim IN VARCHAR2
1108 , x_Return_Status OUT NOCOPY VARCHAR2
1109 , x_Msg_Count OUT NOCOPY NUMBER
1110 , x_Msg_Data OUT NOCOPY VARCHAR2
1111 );
1112
1113 FUNCTION Get_DS_Sequence_From_AK (
1114 p_Region_Code IN VARCHAR2
1115 , p_Kpi_Id IN VARCHAR2
1116 ) RETURN VARCHAR2;
1117
1118
1119
1120 FUNCTION Get_Data_Series_Id(
1121 p_Kpi_Id IN NUMBER
1122 , p_Dataset_Id IN NUMBER
1123 ) RETURN NUMBER;
1124
1125
1126 PROCEDURE Get_Dep_Obj_Func_Name( p_dep_object_name IN VARCHAR2
1127 ,p_dep_object_type IN VARCHAR2
1128 ,p_object_type IN VARCHAR2
1129 ,x_ret_status OUT NOCOPY VARCHAR2
1130 ,x_mesg_data OUT NOCOPY VARCHAR2
1131 );
1132
1133
1134 FUNCTION Get_Objective_By_AGKpi( p_Short_Name IN VARCHAR2) RETURN VARCHAR2;
1135
1136 --IF AG Report is NOT in Production Mode
1137 PROCEDURE Convert_AutoGen_To_ViewBased (
1138 p_Commit IN VARCHAR2 := FND_API.G_FALSE
1139 , p_Region_Code IN VARCHAR2
1140 , p_Region_Application_Id IN NUMBER
1141 , x_Return_Status OUT NOCOPY VARCHAR
1142 , x_Msg_Count OUT NOCOPY NUMBER
1143 , x_Msg_Data OUT NOCOPY VARCHAR
1144 );
1145
1146
1147 PROCEDURE Delete_AG_Bsc_Metadata (
1148 p_Commit IN VARCHAR2 := FND_API.G_FALSE
1149 , p_Region_Code IN VARCHAR2
1150 , p_Delete_Measures IN VARCHAR2
1151 , p_Delete_Dimensions IN VARCHAR2
1152 , x_Return_Status OUT NOCOPY VARCHAR
1153 , x_Msg_Count OUT NOCOPY NUMBER
1154 , x_Msg_Data OUT NOCOPY VARCHAR
1155 );
1156
1157 -- added for Bug#4932280
1158 PROCEDURE Delete_AG_Bsc_Metadata (
1159 p_Commit IN VARCHAR2 := FND_API.G_FALSE
1160 , p_Region_Code IN VARCHAR2
1161 , p_Delete_Measures IN VARCHAR2
1162 , x_Return_Status OUT NOCOPY VARCHAR
1163 , x_Msg_Count OUT NOCOPY NUMBER
1164 , x_Msg_Data OUT NOCOPY VARCHAR
1165 );
1166
1167
1168 PROCEDURE Switch_Measure_Type (
1169 p_Commit IN VARCHAR2 := FND_API.G_FALSE
1170 , p_Measure_Short_Name IN VARCHAR2
1171 , p_Target_Source IN VARCHAR2
1172 , p_Delete_Columns IN VARCHAR2
1173 , p_Clean_Measure_Date_Source IN VARCHAR2
1174 , x_Return_Status OUT NOCOPY VARCHAR
1175 , x_Msg_Count OUT NOCOPY NUMBER
1176 , x_Msg_Data OUT NOCOPY VARCHAR
1177 );
1178
1179 FUNCTION Get_Measure_Source (
1180 p_Measure_Short_Name IN VARCHAR2
1181 ) RETURN VARCHAR2;
1182
1183 FUNCTION Get_Actual_Source_Data (
1184 p_Measures_Short_Name IN VARCHAR2
1185 ) RETURN VARCHAR2;
1186
1187 FUNCTION Get_Measure_Function_Name (
1188 p_Measures_Short_Name IN VARCHAR2
1189 ) RETURN VARCHAR2;
1190
1191 FUNCTION Get_Actual_Source_Data_Type (
1192 p_Measures_Short_Name IN VARCHAR2
1193 ) RETURN VARCHAR2;
1194
1195
1196 -- API added for Bug#4339686
1197 FUNCTION is_Scorecard_From_AG_Report (
1198 p_Tab_id IN NUMBER
1199 ) RETURN VARCHAR2;
1200
1201 FUNCTION Has_Non_Time_Dim_Obj_Changed (
1202 p_Non_Time_Dim_Objects IN VARCHAR2
1203 , p_Kpi_Id IN NUMBER
1204 ) RETURN VARCHAR2;
1205
1206 FUNCTION Has_Time_Dim_Obj_Changed (
1207 p_Time_Dim_Objects IN VARCHAR2
1208 , p_Kpi_Id IN NUMBER
1209 , p_Is_Xtd IN VARCHAR2
1210 ) RETURN VARCHAR2;
1211
1212 FUNCTION Has_Measure_Column_Changed (
1213 p_Measure_Short_Names IN VARCHAR2
1214 , p_Kpi_id IN NUMBER
1215 ) RETURN VARCHAR2;
1216
1217
1218 PROCEDURE Delete_Tab_And_TabViews
1219 (
1220 p_commit IN VARCHAR2 := FND_API.G_FALSE
1221 , p_region_code IN AK_REGION_ITEMS.region_code%TYPE
1222 , x_Return_Status OUT NOCOPY VARCHAR2
1223 , x_Msg_Count OUT NOCOPY NUMBER
1224 , x_Msg_Data OUT NOCOPY VARCHAR2
1225 );
1226
1227 PROCEDURE Get_Measures_From_CustomView
1228 (
1229 p_region_code IN AK_REGION_ITEMS.region_code%TYPE
1230 , p_region_app_id IN AK_REGION_ITEMS.region_application_id%TYPE
1231 , x_has_cust_view OUT NOCOPY VARCHAR2
1232 , x_meas_sht_names OUT NOCOPY VARCHAR2
1233 , x_scorecard_id OUT NOCOPY NUMBER
1234 , x_tabview_id OUT NOCOPY NUMBER
1235 -- , x_last_update_date OUT NOCOPY VARCHAR
1236 , x_return_status OUT NOCOPY VARCHAR2
1237 , x_msg_count OUT NOCOPY NUMBER
1238 , x_msg_data OUT NOCOPY VARCHAR2
1239 );
1240
1241 FUNCTION is_Scorecard_From_Reports (
1242 p_tab_sht_name IN BSC_TABS_B.short_name%TYPE
1243 ) RETURN VARCHAR2;
1244
1245
1246 -- Check if the Dimension Object is a BSC periodicity
1247 FUNCTION Is_DimObj_Periodicity(
1248 p_Short_NAme IN VARCHAR2
1249 ) RETURN VARCHAR2;
1250
1251 -- This API is similar to BSC_DBI_CALENDAR.get_bsc_Periodicity,
1252 -- except that it queries directly from the BSC_SYS_PERIODICITIES table
1253 PROCEDURE Get_Non_DBI_Periodicities (
1254 p_Time_Short_Name IN VARCHAR2
1255 , x_Periodicity_Id OUT NOCOPY VARCHAR2
1256 , x_Calendar_Id OUT NOCOPY VARCHAR2
1257 , x_Return_Status OUT NOCOPY VARCHAR
1258 , x_Msg_Count OUT NOCOPY NUMBER
1259 , x_Msg_Data OUT NOCOPY VARCHAR
1260 );
1261
1262 FUNCTION Is_Dimension_Calendar(
1263 p_Short_Name IN VARCHAR2
1264 ) RETURN VARCHAR2;
1265
1266 PROCEDURE Is_Struct_Change_For_AG_Report
1267 ( p_Region_Code IN VARCHAR2
1268 , p_Region_Application_Id IN NUMBER
1269 , p_Dim_Obj_Short_Names IN VARCHAR2
1270 , p_Measure_Short_Names IN VARCHAR2
1271 , x_Result OUT NOCOPY VARCHAR2
1272 , x_Return_Status OUT NOCOPY VARCHAR2
1273 , x_Msg_Count OUT NOCOPY NUMBER
1274 , x_Msg_Data OUT NOCOPY VARCHAR2
1275 );
1276
1277 FUNCTION Get_Attribute_Code_For_Measure
1278 ( p_Report_Region_Code IN VARCHAR2
1279 ,p_Measure_Short_Name IN VARCHAR2
1280 ) RETURN VARCHAR2;
1281
1282 -- Added the following APIs for Bug#4558279
1283 /*******************************************
1284 ** START **
1285 Added the following API for dynamic
1286 parameter portlet creation logic as required
1287 by Bug#4558279
1288 ********************************************/
1289
1290 FUNCTION Is_Dim_Exist_In_Current_Region (
1291 p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1292 , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1293 ) RETURN VARCHAR2;
1294
1295 FUNCTION Is_Dim_Exist_In_Nested_Region (
1296 p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1297 , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1298 ) RETURN VARCHAR2;
1299
1300 FUNCTION Is_New_Param_Portlet_Required (
1301 p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1302 , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1303 ) RETURN VARCHAR2;
1304
1305 PROCEDURE Cascade_Parameter_Portlet (
1306 p_Commit IN VARCHAR2
1307 , p_Page_Function_Name IN VARCHAR2
1308 , p_Param_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1309 , p_Param_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1310 , p_Action_Type IN VARCHAR2
1311 , x_Region_Code OUT NOCOPY VARCHAR2
1312 , x_Region_Application_Id OUT NOCOPY NUMBER
1313 , x_Return_Status OUT NOCOPY VARCHAR2
1314 , x_Msg_Count OUT NOCOPY NUMBER
1315 , x_Msg_Data OUT NOCOPY VARCHAR2
1316 );
1317
1318 PROCEDURE Create_Parameter_Portlet (
1319 p_Commit IN VARCHAR2
1320 , p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1321 , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1322 , x_Region_Code OUT NOCOPY VARCHAR2
1323 , x_Region_Application_Id OUT NOCOPY NUMBER
1324 , x_Return_Status OUT NOCOPY VARCHAR2
1325 , x_Msg_Count OUT NOCOPY NUMBER
1326 , x_Msg_Data OUT NOCOPY VARCHAR2
1327 );
1328
1329
1330 FUNCTION Get_New_Region_Code RETURN VARCHAR2;
1331
1332 PROCEDURE Unroll_RegionItems_Into_Record (
1333 p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1334 , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1335 , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
1336 );
1337
1338 PROCEDURE Get_Non_Nested_Into_Rec (
1339 p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1340 , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1341 , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
1342 );
1343
1344 FUNCTION Get_Param_Portlet_By_Dashboard (
1345 p_Page_Function_Name IN VARCHAR2
1346 ) RETURN VARCHAR2;
1347
1348 /*******************************************
1349 Added the following API for dynamic
1350 parameter portlet creation logic as required
1351 by Bug#4558279
1352 ** END **
1353 ********************************************/
1354
1355 -- Added for Bug#4638384, returns the Compare To attribute code
1356 FUNCTION Get_Compare_Attribute_Code (
1357 p_Region_Code IN VARCHAR2
1358 , p_Measure_Short_Name IN VARCHAR2
1359 ) RETURN VARCHAR2;
1360
1361 FUNCTION Get_Comparison_Source (
1362 p_Measures_Short_Name IN VARCHAR2
1363 ) RETURN VARCHAR2;
1364
1365 -- Added the API Migrate_AGR_To_PLSQL() for Enhancement#4878676
1366 PROCEDURE Migrate_AGR_To_PLSQL (
1367 p_Commit IN VARCHAR := FND_API.G_FALSE
1368 , p_Region_Application_Id IN VARCHAR2
1369 , p_Region_Code IN VARCHAR2
1370 , p_Update_AK_Metadata IN VARCHAR2
1371 , p_Plsql_For_Report_Query IN VARCHAR2
1372 , p_Old_Attribute_Code_App_Ids IN VARCHAR2
1373 , p_Old_Attribute_Codes IN VARCHAR2
1374 , p_New_Attribute_Code_App_Ids IN VARCHAR2
1375 , p_New_Attribute_Codes IN VARCHAR2
1376 , x_Return_Status OUT NOCOPY VARCHAR
1377 , x_Msg_Count OUT NOCOPY NUMBER
1378 , x_Msg_Data OUT NOCOPY VARCHAR
1379 );
1380
1381
1382 PROCEDURE Migrate_AGR_To_PLSQL (
1383 p_Commit IN VARCHAR := FND_API.G_FALSE
1384 , p_Region_Application_Id IN VARCHAR2
1385 , p_Region_Code IN VARCHAR2
1386 , x_Return_Status OUT NOCOPY VARCHAR
1387 , x_Msg_Count OUT NOCOPY NUMBER
1388 , x_Msg_Data OUT NOCOPY VARCHAR
1389 );
1390
1391 -- needs to be moved into an utility file.
1392 FUNCTION Is_Primary_Source_Of_Measure (
1393 p_Measure_Short_Name IN VARCHAR2
1394 , p_Region_Code IN VARCHAR2
1395 ) RETURN VARCHAR2;
1396
1397
1398 -- needs to be moved into an utility file.
1399 PROCEDURE Cascade_Attr_Code_Into_Measure (
1400 p_Commit IN VARCHAR := FND_API.G_FALSE
1401 , p_Region_Code IN VARCHAR2
1402 , p_Region_Application_Id IN VARCHAR2
1403 , p_Old_Attribute_Codes IN VARCHAR2
1404 , p_Old_Attribute_Code_App_Ids IN VARCHAR2
1405 , p_New_Attribute_Codes IN VARCHAR2
1406 , p_New_Attribute_Code_App_Ids IN VARCHAR2
1407 , x_Return_Status OUT NOCOPY VARCHAR
1408 , x_Msg_Count OUT NOCOPY NUMBER
1409 , x_Msg_Data OUT NOCOPY VARCHAR
1410 );
1411
1412 PROCEDURE Cascade_Changes_Into_Forumla (
1413 p_Commit IN VARCHAR := FND_API.G_FALSE
1414 , p_Measure_Short_Name IN VARCHAR2
1415 , p_Old_Attribute_Codes IN VARCHAR2
1416 , p_Old_Attribute_Code_App_Ids IN VARCHAR2
1417 , p_New_Attribute_Codes IN VARCHAR2
1418 , p_New_Attribute_Code_App_Ids IN VARCHAR2
1419 , x_Return_Status OUT NOCOPY VARCHAR
1420 , x_Msg_Count OUT NOCOPY NUMBER
1421 , x_Msg_Data OUT NOCOPY VARCHAR
1422 );
1423
1424
1425 -- added for Bug#4923006
1426 FUNCTION Is_Dim_Associated_To_Objective (
1427 p_Dimension_Short_Name IN VARCHAR2
1428 , p_Kpi_Id IN NUMBER
1429 ) RETURN VARCHAR2;
1430
1431 -- added for bug#4741919
1432 PROCEDURE Delete_AG_Report (
1433 p_Commit IN VARCHAR2 := FND_API.G_FALSE
1434 , p_Region_Code IN VARCHAR2
1435 , p_Delete_Measures IN VARCHAR2
1436 , x_Return_Status OUT NOCOPY VARCHAR
1437 , x_Msg_Count OUT NOCOPY NUMBER
1438 , x_Msg_Data OUT NOCOPY VARCHAR
1439 );
1440
1441 -- Added from Enhancement Number#4952167
1442 PROCEDURE Migrate_AGR_To_VBR (
1443 p_Commit IN VARCHAR2 := FND_API.G_FALSE
1444 , p_Region_Application_Id IN VARCHAR2
1445 , p_Region_Code IN VARCHAR2
1446 , x_Return_Status OUT NOCOPY VARCHAR
1447 , x_Msg_Count OUT NOCOPY NUMBER
1448 , x_Msg_Data OUT NOCOPY VARCHAR
1449 );
1450
1451
1452 -- Added from Enhancement Number#4952167
1453 PROCEDURE Migrate_To_Existing_Source (
1454 p_Commit IN VARCHAR2 := FND_API.G_FALSE
1455 , p_Existing_Report_Type IN VARCHAR2
1456 , p_Region_Application_Id IN VARCHAR2
1457 , p_Region_Code IN VARCHAR2
1458 , x_Return_Status OUT NOCOPY VARCHAR
1459 , x_Msg_Count OUT NOCOPY NUMBER
1460 , x_Msg_Data OUT NOCOPY VARCHAR
1461 );
1462
1463 /*
1464 Added this API for Bug#4249900
1465
1466 This API will return a list of Objectives, which uses the DImension created for
1467 this report (p_region_code).
1468 */
1469
1470 PROCEDURE Get_Obj_By_Dim_Region_Code (
1471 p_Region_Code IN VARCHAR2
1472 , p_Region_Application_Id IN NUMBER
1473 , p_Production_Only IN VARCHAR2
1474 , x_Return_Status OUT NOCOPY VARCHAR2
1475 , x_Msg_Count OUT NOCOPY NUMBER
1476 , x_Msg_Data OUT NOCOPY VARCHAR2
1477 );
1478
1479 /*
1480 This API will take the Region Code and try to cascase it to the pl/sql layer.
1481 and hence will ensure that whenever the parameter section is changed for the report, the
1482 same structure is passed down the Dimension/Objective entities.
1483 */
1484 PROCEDURE Cascade_Dimension_By_Region (
1485 p_Commit IN VARCHAR2
1486 , p_Region_Code IN VARCHAR2
1487 , p_Region_Application_Id IN NUMBER
1488 , p_Force_Change IN VARCHAR2
1489 , x_Return_Status OUT NOCOPY VARCHAR2
1490 , x_Msg_Count OUT NOCOPY NUMBER
1491 , x_Msg_Data OUT NOCOPY VARCHAR2
1492 );
1493
1494 /*
1495 This API will get the global menu (attribute19) and title (attribute20) from bis_ak_region_extension table
1496 Added for Bug#4955493
1497 */
1498 PROCEDURE Get_Global_Menu_Title(
1499 p_Region_Code IN VARCHAR2
1500 , p_Region_Application_Id IN NUMBER
1501 , x_Global_Menu OUT NOCOPY VARCHAR2
1502 , x_Global_Title OUT NOCOPY VARCHAR2
1503 );
1504
1505 PROCEDURE Create_Bsc_Bis_Metadata(
1506 p_Commit IN VARCHAR2
1507 , p_Create_Region_Per_Ao IN VARCHAR2
1508 , p_Param_Portlet_Region_Code IN VARCHAR2
1509 , p_Page_Function_Name IN VARCHAR2
1510 , p_Kpi_Portlet_Function_Name IN VARCHAR2
1511 , p_Region_Function_Name IN VARCHAR2
1512 , p_Region_User_Function_Name IN VARCHAR2
1513 , p_Dim_Obj_Short_Names IN VARCHAR2
1514 , p_Force_Create_Dim IN VARCHAR2
1515 , p_Measure_Short_Name IN VARCHAR2
1516 , p_Responsibility_Id IN NUMBER
1517 , p_Measure_Name IN VARCHAR2
1518 , p_Measure_Description IN VARCHAR2
1519 , p_Dataset_Format_Id IN NUMBER
1520 , p_Dataset_Autoscale_Flag IN NUMBER
1521 , p_Measure_Operation IN VARCHAR2
1522 , p_Measure_Increase_In_Measure IN VARCHAR2
1523 ,p_Measure_Obsolete IN VARCHAR2 := FND_API.G_FALSE
1524 ,p_Type IN VARCHAR2
1525 , p_Measure_Random_Style IN NUMBER
1526 , p_Measure_Min_Act_Value IN NUMBER
1527 , p_Measure_Max_Act_Value IN NUMBER
1528 , p_Measure_Type IN NUMBER
1529 , p_Measure_App_Id IN NUMBER := NULL
1530 , p_Func_Area_Short_Name IN VARCHAR2 := NULL
1531 , p_Obj_Grp_Id IN NUMBER
1532 , p_Obj_Tab_Id IN NUMBER
1533 , p_Obj_Type IN NUMBER
1534 , x_Measure_Short_Name OUT NOCOPY VARCHAR2
1535 , x_Kpi_Id OUT NOCOPY NUMBER
1536 , x_Return_Status OUT NOCOPY VARCHAR2
1537 , x_Msg_Count OUT NOCOPY NUMBER
1538 , x_Msg_Data OUT NOCOPY VARCHAR2
1539 );
1540
1541 FUNCTION Get_Tab_Name
1542 (
1543 p_tab_id NUMBER
1544 )
1545 RETURN VARCHAR2;
1546
1547 FUNCTION Get_Objective_Group_Name
1548 (
1549 p_obj_grp_id NUMBER
1550 )
1551 RETURN VARCHAR2;
1552
1553 FUNCTION Generate_Unique_Region_Code
1554 RETURN VARCHAR2;
1555
1556 PROCEDURE Get_Non_Time_Dim_And_DimObjs
1557 (
1558 p_region_code IN AK_REGIONS.region_code%TYPE
1559 ,x_non_time_dim_dimObjs OUT NOCOPY BSC_VARCHAR2_TBL_TYPE
1560 ,x_non_time_counter OUT NOCOPY NUMBER
1561 );
1562
1563
1564 END BSC_BIS_KPI_CRUD_PUB;
[Home] [Help]