1 PACKAGE BSC_DIM_FILTERS_PUB AS
2 /* $Header: BSCPFDLS.pls 120.3 2007/02/23 10:41:52 psomesul ship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BSCCPMDB.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: This Package Filtering Dimension object at tab level |
13 REM | |
14 REM | NOTES |
15 REM | 16-MAR-2004 WCANO Created. |
16 REM | 12-APR-2004 PAJOHRI Bug #3426566, added a new function |
17 REM | Get_Filter_View_Name |
18 REM | 16-12-2006 PSOMESUL E#5678943 MIGRATE COMMON DIMENSIONS AND DIMENSION FILTERS TO SCORECARD DESIGNER|
19 REM +=======================================================================+
20 */
21
22 SOURCE_TYPE_TAB NUMBER := 1; -- Scorecard SOURCE TYPE
23 SOURCE_TYPE_SYSTEM NUMBER := 0; -- System SOURCE TYPE
24
25
26 /*-------------------------------------------------------------------------------------------------------------------
27 Check_Filters_Not_Apply
28 This procedure will check for filters that not apply any more to the tabs
29 It will made one of the next options:
30 1. Check for a all the dimension filters in a specific tab when p_Dim_Level_Id is null and p_Tab_Id is not null
31 2. Check for a all the dimension filters in all the tab when p_Dim_Level_Id is null and p_Tab_Id is null
32 -------------------------------------------------------------------------------------------------------------------*/
33 PROCEDURE Check_Filters_Not_Apply
34 ( p_Tab_Id IN NUMBER := NULL
35 , x_return_status OUT NOCOPY VARCHAR2
36 , x_msg_count OUT NOCOPY NUMBER
37 , x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE Check_Filters_Not_Apply_By_KPI
41 ( p_Kpi_Id IN BSC_KPIS_B.Indicator%TYPE
42 , x_return_status OUT NOCOPY VARCHAR2
43 , x_msg_count OUT NOCOPY NUMBER
44 , x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 /*-------------------------------------------------------------------------------------------------------------------
48 Drop_Filter :
49 Delete a Filter View a and make cascading delete for child dimension Filter views
50 -------------------------------------------------------------------------------------------------------------------*/
51 PROCEDURE Drop_Filter
52 ( p_Tab_Id IN NUMBER
53 , p_Dim_Level_Id IN NUMBER
54 , x_return_status OUT NOCOPY VARCHAR2
55 , x_msg_count OUT NOCOPY NUMBER
56 , x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE Synch_Fiters_And_Kpi_Dim
60 ( p_Tab_Id IN NUMBER
61 , x_return_status OUT NOCOPY VARCHAR2
62 , x_msg_count OUT NOCOPY NUMBER
63 , x_msg_data OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE Drop_Filter_By_Dim_Obj
67 ( p_Dim_Level_Id IN NUMBER
68 , x_return_status OUT NOCOPY VARCHAR2
69 , x_msg_count OUT NOCOPY NUMBER
70 , x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE Drop_Filter_By_Tab
74 ( p_Tab_Id IN NUMBER
75 , x_return_status OUT NOCOPY VARCHAR2
76 , x_msg_count OUT NOCOPY NUMBER
77 , x_msg_data OUT NOCOPY VARCHAR2
78 );
79
80 FUNCTION Get_Filter_View_Name
81 ( p_Kpi_Id IN BSC_KPIS_B.Indicator%TYPE
82 , p_Dim_Level_Id IN BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE
83 ) RETURN VARCHAR2;
84
85
86
87 END BSC_DIM_FILTERS_PUB;