1 PACKAGE BSC_DIM_LEVEL_FILTERS_PUB AS
2 /* $Header: BSCPFILS.pls 120.1.12000000.1 2007/07/17 07:44:00 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 | BSCPFILS.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 | 27-Mar-07 psomesul B#5901412-Open issues of enh no. 5678943 |
17 REM +=======================================================================+
18 */
19
20 SOURCE_TYPE_TAB NUMBER := 1; -- Scorecard SOURCE TYPE
21 SOURCE_TYPE_SYSTEM NUMBER := 0; -- System SOURCE TYPE
22
23 PROCEDURE save_filter
24 (p_tab_id IN NUMBER
25 ,p_dim_level_id IN NUMBER
26 ,p_level_vals_list IN OUT NOCOPY VARCHAR2
27 ,p_mismatch_keyitems OUT NOCOPY VARCHAR2
28 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE process_filter_view
35 (
36 p_tab_id IN NUMBER
37 ,p_dim_level_id IN NUMBER
38 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE create_filter_view
45 (
46 p_tab_id IN NUMBER
47 , p_dim_level_id IN NUMBER
48 , p_commit IN VARCHAR2 := FND_API.G_FALSE
49 , x_return_status OUT NOCOPY VARCHAR2
50 , x_msg_count OUT NOCOPY NUMBER
51 , x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54
55 FUNCTION get_new_filter_view_name(
56 p_dimension_table IN VARCHAR2
57 , x_return_status OUT NOCOPY VARCHAR2
58 , x_msg_count OUT NOCOPY NUMBER
59 , x_msg_data OUT NOCOPY VARCHAR2
60
61 ) RETURN VARCHAR2;
62
63 PROCEDURE del_filters_not_applicable(
64 p_tab_id IN NUMBER
65 ,p_ch_level_id IN NUMBER
66 ,p_pa_level_id IN NUMBER
67 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73
74 PROCEDURE get_filter_dimension_SQL
75 ( p_tab_id IN NUMBER
76 , p_dim_level_id IN NUMBER
77 , x_sql OUT NOCOPY VARCHAR2
78 , p_commit IN VARCHAR2 := FND_API.G_FALSE
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_msg_count OUT NOCOPY NUMBER
81 , x_msg_data OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE get_filtered_dim_values_SQL
85 ( p_tab_id IN NUMBER
86 , p_dim_level_id IN NUMBER
87 , x_sql OUT NOCOPY VARCHAR2
88 , p_commit IN VARCHAR2 := FND_API.G_FALSE
89 , x_return_status OUT NOCOPY VARCHAR2
90 , x_msg_count OUT NOCOPY NUMBER
91 , x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE update_tab_who_columns
95 (
96 p_tab_id IN NUMBER
97 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
98 ,x_return_status OUT NOCOPY VARCHAR2
99 ,x_msg_count OUT NOCOPY NUMBER
100 ,x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE validate_key_items(
104 p_tab_id IN NUMBER
105 ,p_dim_level_id IN NUMBER
106 ,p_level_vals_list IN OUT NOCOPY VARCHAR2
107 ,p_mismatch_key_items IN OUT NOCOPY VARCHAR2
108 ,x_return_status OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY NUMBER
110 ,x_msg_data OUT NOCOPY VARCHAR2
111 );
112
113 PROCEDURE validate_parent_key_items(
114 p_tab_id IN NUMBER
115 ,p_dim_level_id IN NUMBER
116 ,p_parent_level_id IN NUMBER
117 ,p_level_vals_list IN VARCHAR2
118 ,p_mismatch_key_items IN OUT NOCOPY VARCHAR2
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_msg_count OUT NOCOPY NUMBER
121 ,x_msg_data OUT NOCOPY VARCHAR2
122 );
123
124 PROCEDURE validate_child_key_items(
125 p_tab_id IN NUMBER
126 ,p_dim_level_id IN NUMBER
127 ,p_child_level_id IN NUMBER
128 ,p_level_vals_list IN VARCHAR2
129 ,p_mismatch_key_items IN OUT NOCOPY VARCHAR2
130 ,x_return_status OUT NOCOPY VARCHAR2
131 ,x_msg_count OUT NOCOPY NUMBER
132 ,x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135 END BSC_DIM_LEVEL_FILTERS_PUB;