1 PACKAGE BSC_OAF_VIEWS_PVT AS
2 /* $Header: BSCOAFVS.pls 120.1 2007/02/08 09:43:32 ankgoel ship $ */
3 /*===========================================================================+
4 |
5 | Name: GET_AOPTS_SERIES_NAMES
6 |
7 | Description: Check if the menu name and User name are unique to
8 | insert as a new menu.
9 | Return : 'N' : Name Invalid, The name alreday exist
10 | 'U' : User Name Invalid, The user name alreday exist
11 | 'T' : True , The names don't exist. It can be added
12 | Parameters: X_MENU_ID Menu Id that will be inserted
13 | X_MENU_NAME Menu Name
14 | X_USER_MENU_NAME User Menu Name
15 +============================================================================*/
16 FUNCTION GET_AOPTS_SERIES_NAMES(X_INDICATOR in NUMBER,
17 X_A0 in NUMBER,
18 X_A1 in NUMBER,
19 X_A2 in NUMBER,
20 X_SERIES_ID in NUMBER
21 ) RETURN VARCHAR2;
22 PRAGMA RESTRICT_REFERENCES(GET_AOPTS_SERIES_NAMES, WNDS);
23
24 /* ===========================================================
25 | Description : Return the Alarm Color for Kpi measure.
26 | This color is showed buy Ibuilder
27 |
28 |Psuedo logic
29 | If DefaultMeasure = "BSC" Then
30 | Color = KPI Color -> BSC_DESIGNER_PVT.GET_KPI_COLOR
31 | Elseif Measure is BSC and not DEFault THEN
32 | Color = No Color 'WHITE'
33 | Elseif Measure is PMF and kpi <> PRODUCTION THEN
34 | Color = KPI Color -> BSC_DESIGNER_PVT.GET_KPI_COLOR
35 | Elseif Measure is PMF and kpi = PRODUCTION THEN
36 | Color = No Color 'WHITE'
37 | end if;
38 ===========================================================*/
39 /*FUNCTION GET_MEASURE_COLOR(X_INDICATOR in NUMBER,
40 X_A0 in NUMBER,
41 X_A1 in NUMBER,
42 X_A2 in NUMBER,
43 X_SERIES_ID in NUMBER
44 ) RETURN VARCHAR2;*/
45
46 function Get_Aopts_Display_Flag(
47 x_indicator IN number
48 ,x_a0 IN number
49 ,x_a1 IN number
50 ,x_a2 IN number
51 ,x_series_id IN number
52 ) return number;
53
54 /* ===========================================================
55 | Description : Return the parent level names of a given level
56 | in a string
57 |
58 |Psuedo logic
59 ===========================================================*/
60 FUNCTION GET_LEVEL_PARENT_NAMES(p_level_id IN NUMBER
61 ) RETURN VARCHAR2;
62
63 /* ===========================================================
64 | Description :
65 | This function returns the flag value that identify the default
66 | Analsyis option combination for the kpi.
67 |
68 ===========================================================*/
69 FUNCTION GET_AOPTS_DEFAULT_FLAG(
70 x_indicator IN number
71 ,x_a0 IN number
72 ,x_a1 IN number
73 ,x_a2 IN number
74 ,x_series_id IN number
75 ) return number;
76
77 function Is_Parent_Tab(
78 p_tab_id number
79 ) return varchar2;
80 /*===========================================================================+
81 |
82 | Name: GET_DATASET_SOURCE
83 |
84 | Description: Return if the dataset_id is BSC OR PMV
85 | Return : 'BSC' : BSC measure
86 | 'PMF' : PMF measure
87 | Parameters: X_DATASET_ID Menu Id that will be inserted
88 +============================================================================*/
89 FUNCTION GET_DATASET_SOURCE(X_DATASET_ID in NUMBER
90 ) RETURN VARCHAR2;
91
92 h_dataset NUMBER:=-5;
93 h_source VARCHAR2(10) :='BSC';
94
95 END BSC_OAF_VIEWS_PVT;