1 PACKAGE BSC_BIS_CUSTOM_KPI_UTIL_PUB AS
2 /* $Header: BSCCSUBS.pls 120.2.12000000.3 2007/10/09 11:42:21 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 | BSCCSUBS.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 | 13-Aug-04 rpenneru Created. |
18 REM | 17-AUG-04 adrao Modified API SetGlobalFlag and added API |
19 REM | Is_BSC52_Applied for Bug@3836170 |
20 REM | 05-OCT-04 ankgoel Bug#3933075 Moved Get_Pmf_Metadata_By_Objective,
21 REM | get_Region_Code and C_AK_DATASOURCE here |
22 REM | from BSCCRUDB.pls |
23 REM | 11-Feb-05 sawu Bug#4057761: added Get_Unqiue_Tab_Name and|
24 REM | Get_Unqiue_Tab_Group_Name |
25 REM | 29-APR-05 ankagarw Modified API Is_Short_Name_Available for Bug#4336571|
26 REM | Made it public. |
27 REM | 09-MAY-05 adrao Added API is_Objective_Report_Type |
28 REM | and is_Objective_Page_Type |
29 REM | 26-SEP-2005 arhegde bug# 4624100 Moved get_format_mask code to |
30 REM | BSC_BIS_CUSTOM_KPI_UTIL_PUB from BSC_BIS_KPI_CRUD_PUB since |
31 REM | pure BIS can use it too. |
32 REM | 02-Oct-2007 bijain Bug#6327035 Changing the display name of a |
33 REM | DashBord for End to End Kpi should update BSC MetaData|
34 REM +=======================================================================+ */
35
36 G_MDDD_52 NUMBER := 0;
37
38 C_BSC_PATCH_LEVEL_UNINIT CONSTANT NUMBER := 0;
39 C_BSC_PATCH_LEVEL_511 CONSTANT NUMBER := 1; -- BSC.G (5110)
40 C_BSC_PATCH_LEVEL_52 CONSTANT NUMBER := 2;
41
42 C_AK_DATASOURCE CONSTANT VARCHAR2(2) := 'AK';
43
44 C_MAX_LOOP_COUNT CONSTANT NUMBER := 10000; --prevent infinite loop
45
46 C_OBJECT_TYPE_REPORT CONSTANT VARCHAR2(6) := 'REPORT';
47 C_OBJECT_TYPE_PAGE CONSTANT VARCHAR2(4) := 'PAGE';
48
49 C_BSC_DATA_SOURCE CONSTANT VARCHAR2(15) := 'BSC_DATA_SOURCE';
50
51
52 -- added for Bug#4476730
53 C_DELETED_OBJECTIVE_FLAG CONSTANT NUMBER := 2;
54
55 FUNCTION is_KPI_EndToEnd_Measure(p_Short_Name VARCHAR2) RETURN VARCHAR2;
56
57 FUNCTION is_KPI_EndToEnd_Measure(p_Measure_id NUMBER) RETURN VARCHAR2;
58
59 FUNCTION is_KPI_EndToEnd_MeasureGroup(p_Short_Name VARCHAR2) RETURN VARCHAR2;
60
61 FUNCTION is_kpi_endtoend_MeasureGroup(p_Measure_Group_Id NUMBER) RETURN VARCHAR2;
62
63 FUNCTION is_KPI_EndToEnd_MeasureCol(p_Measure_Col VARCHAR2,p_MesGrp_Short_Name VARCHAR2) RETURN VARCHAR2;
64
65 FUNCTION is_KPI_EndToEnd_MeasureCol(p_Measure_Col VARCHAR2) RETURN VARCHAR2;
66
67 /*this function will return 'T' if the passed short_name of scorecard
68 is created through KPI End to End module otherwise 'F'
69 */
70 FUNCTION is_KPI_EndToEnd_Scorecard(p_Short_Name VARCHAR2) RETURN VARCHAR2;
71
72 FUNCTION Get_User_Function_Name(p_function_name VARCHAR2) RETURN VARCHAR2;
73
74 PROCEDURE SetGlobalFlag;
75
76 /*
77 This public function is to test whether parameter is null or not.
78 */
79 -- Added a public API to check for short_name via SetGlobalFlag
80 FUNCTION Is_Short_Name_Available RETURN VARCHAR2;
81
82 FUNCTION enableVarchar2Implementation RETURN VARCHAR2;
83
84 FUNCTION Get_Region_Code (
85 p_Kpi_Id NUMBER
86 , p_AO_Id NUMBER := NULL
87 ) RETURN VARCHAR2;
88
89 -- added for bug#3759819
90 PROCEDURE Get_Pmf_Metadata_By_Objective
91 ( p_Dataset_Id IN NUMBER
92 , p_Measure_Short_Name IN VARCHAR2
93 , x_Actual_Source_Type OUT NOCOPY VARCHAR2
94 , x_Actual_Source OUT NOCOPY VARCHAR2
95 , x_Function_Name OUT NOCOPY VARCHAR2
96 );
97
98 --added for bug#4057761
99 FUNCTION Get_Unqiue_Tab_Name(
100 p_tab_name BSC_TABS_TL.NAME%TYPE
101 ) RETURN BSC_TABS_TL.NAME%TYPE;
102
103 FUNCTION Get_Unqiue_Tab_Name(
104 p_tab_name BSC_TABS_TL.NAME%TYPE
105 , p_tab_id BSC_TABS_TL.TAB_ID%TYPE
106 ) RETURN BSC_TABS_TL.NAME%TYPE;
107 FUNCTION Get_Unqiue_Tab_Group_Name(
108 p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE
109 ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
110
111 FUNCTION Get_Unqiue_Tab_Group_Name(
112 p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE
113 , p_tab_grp_id BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID%TYPE
114 ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
115
116 -- API to check if the report is S2E or AG Report.
117
118 FUNCTION is_Report_S2E(
119 p_Region_Function_Name IN VARCHAR2
120 ) RETURN VARCHAR2;
121
122 FUNCTION is_Objective_Report_Type (
123 p_Short_Name IN VARCHAR2
124 ) RETURN VARCHAR2;
125
126
127 FUNCTION is_Objective_Page_Type (
128 p_Short_Name IN VARCHAR2
129 ) RETURN VARCHAR2;
130
131 FUNCTION Is_Objective_AutoGen_Type (
132 p_Short_Name IN VARCHAR2
133 ) RETURN VARCHAR2;
134
135 FUNCTION Get_Format_Mask (
136 p_Format_Id NUMBER
137 ) RETURN VARCHAR2;
138
139 procedure update_kpi_End_To_End_Name(
140 p_Commit IN VARCHAR2 := FND_API.G_FALSE
141 ,p_Name IN VARCHAR2
142 ,p_Short_Name IN VARCHAR2
143 ,x_Return_Status OUT NOCOPY VARCHAR2
144 ,x_Msg_Count OUT NOCOPY NUMBER
145 ,x_Msg_Data OUT NOCOPY VARCHAR2
146 );
147
148 END BSC_BIS_CUSTOM_KPI_UTIL_PUB;