eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_CUSTOM_KPI_UTIL_PUB dependencies on BSC_BIS_CUSTOM_KPI_UTIL_PUB

Line 1: PACKAGE BODY BSC_BIS_CUSTOM_KPI_UTIL_PUB AS

1: PACKAGE BODY BSC_BIS_CUSTOM_KPI_UTIL_PUB AS
2: /* $Header: BSCCSUBB.pls 120.9 2007/10/10 06:42:39 bijain ship $ */
3:
4: /*
5: REM +=======================================================================+

Line 33: REM | BSC_BIS_CUSTOM_KPI_UTIL_PUB from BSC_BIS_KPI_CRUD_PUB since |

29: REM | Made it public. |
30: REM | 09-MAY-05 adrao Added API is_Objective_Report_Type |
31: REM | and is_Objective_Page_Type |
32: REM | 26-SEP-2005 arhegde bug# 4624100 Moved get_format_mask code to |
33: REM | BSC_BIS_CUSTOM_KPI_UTIL_PUB from BSC_BIS_KPI_CRUD_PUB since |
34: REM | pure BIS can use it too. |
35: REM | 10-MAY-2006 visuri bug#5130750 Data Corruption issue |
36: REM | 09-FEB-1007 ashankar Simulation ER 5386112 |
37: REM | 03-APR-2007 amitgupt modified for bug 5959433 |

Line 66: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_52;

62: FETCH Flag_Cur INTO rec_count;
63: CLOSE Flag_Cur;
64:
65: IF (rec_count > 0) THEN
66: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_52;
67: ELSE
68: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511;
69: END IF;
70: EXCEPTION

Line 68: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511;

64:
65: IF (rec_count > 0) THEN
66: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_52;
67: ELSE
68: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511;
69: END IF;
70: EXCEPTION
71: WHEN OTHERS THEN
72: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511;

Line 72: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511;

68: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511;
69: END IF;
70: EXCEPTION
71: WHEN OTHERS THEN
72: BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511;
73: END SetGlobalFlag;
74:
75:
76: FUNCTION IS_NOT_NULL(p_name VARCHAR2)

Line 146: l_tab_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Name(p_Name, l_tab_id);

142: l_kpi_group_id := BSC_BIS_KPI_CRUD_PUB.Get_Group_Id(p_Short_Name);
143: l_kpi_id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Short_Name);
144:
145: IF(BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY <> l_tab_id) THEN
146: l_tab_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Name(p_Name, l_tab_id);
147: BSC_PMF_UI_WRAPPER.Update_Tab(
148: p_commit => p_Commit
149: ,p_tab_id => l_tab_id
150: ,p_tab_name => l_tab_name

Line 165: l_tab_ind_group_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Group_Name(p_Name,l_kpi_group_id);

161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163:
164: IF(BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY <> l_kpi_group_id) THEN
165: l_tab_ind_group_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Group_Name(p_Name,l_kpi_group_id);
166: BSC_PMF_UI_WRAPPER.Update_Kpi_Group(
167: p_commit => p_Commit
168: ,p_kpi_group_id => l_kpi_group_id
169: ,p_kpi_group_name => l_tab_ind_group_name

Line 211: x_msg_data := x_msg_data||' -> BSC_BIS_CUSTOM_KPI_UTIL_PUB.update_kpi_End_To_End_Name ';

207: WHEN OTHERS THEN
208: x_Return_Status := FND_API.G_RET_STS_ERROR;
209: ROLLBACK TO UpdateEndToEndKPIName;
210: IF (x_msg_data IS NOT NULL) THEN
211: x_msg_data := x_msg_data||' -> BSC_BIS_CUSTOM_KPI_UTIL_PUB.update_kpi_End_To_End_Name ';
212: ELSE
213: x_msg_data := SQLERRM||' at BSC_BIS_CUSTOM_KPI_UTIL_PUB.update_kpi_End_To_End_Name ';
214: END IF;
215: END update_kpi_End_To_End_Name;

Line 213: x_msg_data := SQLERRM||' at BSC_BIS_CUSTOM_KPI_UTIL_PUB.update_kpi_End_To_End_Name ';

209: ROLLBACK TO UpdateEndToEndKPIName;
210: IF (x_msg_data IS NOT NULL) THEN
211: x_msg_data := x_msg_data||' -> BSC_BIS_CUSTOM_KPI_UTIL_PUB.update_kpi_End_To_End_Name ';
212: ELSE
213: x_msg_data := SQLERRM||' at BSC_BIS_CUSTOM_KPI_UTIL_PUB.update_kpi_End_To_End_Name ';
214: END IF;
215: END update_kpi_End_To_End_Name;
216: FUNCTION is_KPI_EndToEnd_Measure(p_Measure_Id NUMBER)
217: RETURN VARCHAR2 IS

Line 225: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.Is_Short_Name_Available = FND_API.G_FALSE) THEN

221: l_count NUMBER :=0;
222:
223: BEGIN
224:
225: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.Is_Short_Name_Available = FND_API.G_FALSE) THEN
226: RETURN FND_API.G_FALSE;
227: END IF;
228:
229: IF(Flag_Cur%ISOPEN) THEN

Line 271: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.Is_Short_Name_Available = FND_API.G_FALSE) THEN

267: rec_count NUMBER;
268:
269: BEGIN
270:
271: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.Is_Short_Name_Available = FND_API.G_FALSE) THEN
272: RETURN FND_API.G_FALSE;
273: END IF;
274:
275: IF(Flag_Cur%ISOPEN) THEN

Line 298: RETURN BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_KPI_EndToEnd_MeasureGroup(p_MesGrp_Short_Name);

294:
295: FUNCTION is_KPI_EndToEnd_MeasureCol(p_Measure_Col VARCHAR2,p_MesGrp_Short_Name VARCHAR2)
296: RETURN VARCHAR2 IS
297: BEGIN
298: RETURN BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_KPI_EndToEnd_MeasureGroup(p_MesGrp_Short_Name);
299: EXCEPTION
300: WHEN OTHERS THEN
301: RETURN FND_API.G_FALSE;
302: END is_KPI_EndToEnd_MeasureCol;

Line 322: RETURN BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_KPI_EndToEnd_MeasureGroup(l_Measure_Group_Id);

318:
319: OPEN c_MeasureGrp;
320: FETCH c_MeasureGrp INTO l_Measure_Group_Id;
321: CLOSE c_MeasureGrp;
322: RETURN BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_KPI_EndToEnd_MeasureGroup(l_Measure_Group_Id);
323:
324: EXCEPTION
325: WHEN OTHERS THEN
326: RETURN FND_API.G_FALSE;

Line 373: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.Is_Short_Name_Available = FND_API.G_FALSE) THEN

369: -- Check if ODF with short_names has been applied or not
370: FUNCTION enableVarchar2Implementation
371: RETURN VARCHAR2 IS
372: BEGIN
373: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.Is_Short_Name_Available = FND_API.G_FALSE) THEN
374: RETURN FND_API.G_FALSE;
375: END IF;
376:
377: RETURN FND_API.G_TRUE;

Line 389: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_UNINIT) THEN

385: FUNCTION Is_Short_Name_Available
386: RETURN VARCHAR2 IS
387: BEGIN
388:
389: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_UNINIT) THEN
390: BSC_BIS_CUSTOM_KPI_UTIL_PUB.setGlobalFlag;
391: END IF;
392:
393: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511) THEN

Line 390: BSC_BIS_CUSTOM_KPI_UTIL_PUB.setGlobalFlag;

386: RETURN VARCHAR2 IS
387: BEGIN
388:
389: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_UNINIT) THEN
390: BSC_BIS_CUSTOM_KPI_UTIL_PUB.setGlobalFlag;
391: END IF;
392:
393: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511) THEN
394: RETURN FND_API.G_FALSE;

Line 393: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511) THEN

389: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_UNINIT) THEN
390: BSC_BIS_CUSTOM_KPI_UTIL_PUB.setGlobalFlag;
391: END IF;
392:
393: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511) THEN
394: RETURN FND_API.G_FALSE;
395: ELSIF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_52) THEN
396: RETURN FND_API.G_TRUE;
397: END IF;

Line 395: ELSIF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_52) THEN

391: END IF;
392:
393: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_511) THEN
394: RETURN FND_API.G_FALSE;
395: ELSIF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.G_MDDD_52 = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_BSC_PATCH_LEVEL_52) THEN
396: RETURN FND_API.G_TRUE;
397: END IF;
398:
399: RETURN FND_API.G_FALSE;

Line 457: x_Actual_Source_Type := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_AK_DATASOURCE;

453: l_Analysis_Option := Kpi_Ao.aoId;
454: END LOOP;
455:
456: l_Region_Code := Get_Region_Code (l_Kpi_Id, l_Analysis_Option);
457: x_Actual_Source_Type := BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_AK_DATASOURCE;
458:
459: IF (l_Region_Code IS NOT NULL) THEN
460: x_Actual_Source := l_Region_Code || '.' || p_Measure_Short_Name;
461: ELSE

Line 567: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP

563: END IF;
564:
565: l_max_tab_length := Get_Max_Tab_Name_Length;
566:
567: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP
568: SELECT count(1) INTO l_count
569: FROM BSC_TABS_VL
570: WHERE UPPER(trim(name)) = UPPER(l_tab_name);
571:

Line 614: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP

610: END IF;
611:
612: l_max_tab_length := Get_Max_Tab_Name_Length;
613:
614: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP
615: SELECT count(1) INTO l_count
616: FROM BSC_TABS_VL
617: WHERE UPPER(trim(name)) = UPPER(l_tab_name)
618: AND tab_id <> p_tab_id;

Line 661: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP

657: END IF;
658:
659: l_max_tab_grp_length := Get_Max_Tab_Grp_Name_Length;
660:
661: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP
662: SELECT count(1) INTO l_count
663: FROM BSC_TAB_IND_GROUPS_VL
664: WHERE UPPER(trim(name)) = UPPER(l_tab_grp_name);
665:

Line 708: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP

704: END IF;
705:
706: l_max_tab_grp_length := Get_Max_Tab_Grp_Name_Length;
707:
708: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP
709: SELECT count(1) INTO l_count
710: FROM BSC_TAB_IND_GROUPS_VL
711: WHERE UPPER(trim(name)) = UPPER(l_tab_grp_name)
712: AND IND_GROUP_ID <> p_tab_grp_id;

Line 779: AND B.OBJECT_TYPE = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_OBJECT_TYPE_REPORT;

775:
776: SELECT COUNT(1) INTO l_Count
777: FROM BIS_DISPLAY_FORM_FUNC_V B
778: WHERE B.FUNCTION_NAME = p_Short_Name
779: AND B.OBJECT_TYPE = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_OBJECT_TYPE_REPORT;
780: --//For Simulation Objectives we are creating AG Reports but we don't want it to be projected as
781: --//as the report.thats why we are checking the condition that even if form function exists
782: --//and the objective config_type is 7then it should be treated as an objective not as a report.
783:

Line 799: AND PROTOTYPE_FLAG = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_DELETED_OBJECTIVE_FLAG; -- deleted flag

795: ELSE -- Bug#4476730
796: SELECT COUNT(1) INTO l_Count
797: FROM BSC_KPIS_B
798: WHERE SHORT_NAME = p_Short_Name
799: AND PROTOTYPE_FLAG = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_DELETED_OBJECTIVE_FLAG; -- deleted flag
800: -- bug 5959433 we don't need following condition here
801: -- in simulation flow code won't come here
802: --AND config_type =7;
803:

Line 830: AND B.OBJECT_TYPE = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_OBJECT_TYPE_PAGE;

826: BEGIN
827: SELECT COUNT(1) INTO l_Count
828: FROM BIS_DISPLAY_FORM_FUNC_V B
829: WHERE B.FUNCTION_NAME = p_Short_Name
830: AND B.OBJECT_TYPE = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_OBJECT_TYPE_PAGE;
831:
832: IF (l_Count <> 0) THEN
833: RETURN FND_API.G_TRUE;
834: END IF;

Line 906: END BSC_BIS_CUSTOM_KPI_UTIL_PUB;

902: RETURN l_Format_Mask;
903: END Get_Format_Mask;
904:
905:
906: END BSC_BIS_CUSTOM_KPI_UTIL_PUB;