1 PACKAGE BSC_DIM_LEVEL_FILTERS_PVT AS
2 /* $Header: BSCVFILS.pls 120.0.12000000.1 2007/07/17 07:44:44 appldev noship $ */
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 | BSCVFILS.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-12-2006 PSOMESUL E#5678943 MIGRATE COMMON DIMENSIONS AND DIMENSION FILTERS TO SCORECARD DESIGNER|
16 REM +=======================================================================+
17 */
18
19
20 PROCEDURE delete_filters
21 (
22 p_tab_id IN NUMBER
23 ,p_dim_level_id IN NUMBER
24 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
25 ,x_return_status OUT NOCOPY VARCHAR2
26 ,x_msg_count OUT NOCOPY NUMBER
27 ,x_msg_data OUT NOCOPY VARCHAR2
28 );
29
30 PROCEDURE insert_filters
31 (
32 p_source_type IN bsc_sys_filters.source_type%TYPE
33 ,p_source_code IN bsc_sys_filters.source_code%TYPE
34 ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
35 ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
36 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
37 ,x_return_status OUT NOCOPY VARCHAR2
38 ,x_msg_count OUT NOCOPY NUMBER
39 ,x_msg_data OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE delete_filters_view
43 (
44 p_tab_id IN NUMBER
45 ,p_dim_level_id IN NUMBER
46 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
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 insert_filters_view
53 (
54 p_source_type IN bsc_sys_filters_views.source_type%TYPE
55 ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
56 ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
57 ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
58 ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
59 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 END BSC_DIM_LEVEL_FILTERS_PVT;
66