1 PACKAGE BSC_DIM_FILTERS_PVT AS
2 /* $Header: BSCVFDLS.pls 120.2 2007/02/23 10:42:21 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 | 16-12-2006 PSOMESUL E#5678943 MIGRATE COMMON DIMENSIONS AND DIMENSION FILTERS TO SCORECARD DESIGNER|
17 REM +=======================================================================+
18 */
19
20
21 FUNCTION get_Filter_View_Name
22 ( p_Tab_Id NUMBER
23 , p_Dim_Level_Id NUMBER
24 ) RETURN VARCHAR2;
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 /*-------------------------------------------------------------------------------------------------------------------
41 Drop_Filter :
42 Delete a Filter View a and make cascading delete for child dimension Filter views
43 -------------------------------------------------------------------------------------------------------------------*/
44 PROCEDURE Drop_Filter_objects
45 ( p_Tab_Id IN NUMBER
46 , p_Dim_Level_Id IN NUMBER
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_msg_count OUT NOCOPY NUMBER
49 , x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE Drop_Filter
53 ( p_Tab_Id IN NUMBER
54 , p_Dim_Level_Id IN NUMBER
55 , x_return_status OUT NOCOPY VARCHAR2
56 , x_msg_count OUT NOCOPY NUMBER
57 , x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE Synch_Fiters_And_Kpi_Dim
61 ( p_Tab_Id IN NUMBER
62 , x_return_status OUT NOCOPY VARCHAR2
63 , x_msg_count OUT NOCOPY NUMBER
64 , x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67
68 END BSC_DIM_FILTERS_PVT;
69