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: );
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: );
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: );
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: );
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: );
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: );