eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DIM_LEVEL_FILTERS_PVT dependencies on BSC_SYS_FILTERS

Line 33: FROM bsc_sys_filters

29:
30: BEGIN
31: IF (p_tab_id is not null and p_dim_level_id is not null) THEN
32: DELETE
33: FROM bsc_sys_filters
34: WHERE source_type = 1
35: AND source_code = p_tab_id
36: AND dim_level_id = p_dim_level_id;
37: END IF;

Line 86: p_source_type IN bsc_sys_filters.source_type%TYPE

82:
83:
84: PROCEDURE insert_filters
85: (
86: p_source_type IN bsc_sys_filters.source_type%TYPE
87: ,p_source_code IN bsc_sys_filters.source_code%TYPE
88: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
89: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 87: ,p_source_code IN bsc_sys_filters.source_code%TYPE

83:
84: PROCEDURE insert_filters
85: (
86: p_source_type IN bsc_sys_filters.source_type%TYPE
87: ,p_source_code IN bsc_sys_filters.source_code%TYPE
88: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
89: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,x_return_status OUT NOCOPY VARCHAR2

Line 88: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE

84: PROCEDURE insert_filters
85: (
86: p_source_type IN bsc_sys_filters.source_type%TYPE
87: ,p_source_code IN bsc_sys_filters.source_code%TYPE
88: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
89: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,x_return_status OUT NOCOPY VARCHAR2
92: ,x_msg_count OUT NOCOPY NUMBER

Line 89: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE

85: (
86: p_source_type IN bsc_sys_filters.source_type%TYPE
87: ,p_source_code IN bsc_sys_filters.source_code%TYPE
88: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
89: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,x_return_status OUT NOCOPY VARCHAR2
92: ,x_msg_count OUT NOCOPY NUMBER
93: ,x_msg_data OUT NOCOPY VARCHAR2

Line 100: bsc_sys_filters(source_type,

96: BEGIN
97: IF (p_source_type IS NOT NULL AND p_source_code IS NOT NULL AND p_dim_level_id IS NOT NULL AND p_dim_level_value IS NOT NULL) THEN
98: INSERT
99: INTO
100: bsc_sys_filters(source_type,
101: source_code,
102: dim_level_id,
103: dim_level_value
104: )

Line 170: FROM bsc_sys_filters_views

166:
167: BEGIN
168: IF (p_tab_id is not null and p_dim_level_id is not null) THEN
169: DELETE
170: FROM bsc_sys_filters_views
171: WHERE source_type = 1
172: AND source_code = p_tab_id
173: AND dim_level_id = p_dim_level_id;
174: END IF;

Line 222: p_source_type IN bsc_sys_filters_views.source_type%TYPE

218:
219:
220: PROCEDURE insert_filters_view
221: (
222: p_source_type IN bsc_sys_filters_views.source_type%TYPE
223: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
224: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
225: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
226: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE

Line 223: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE

219:
220: PROCEDURE insert_filters_view
221: (
222: p_source_type IN bsc_sys_filters_views.source_type%TYPE
223: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
224: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
225: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
226: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
227: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 224: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE

220: PROCEDURE insert_filters_view
221: (
222: p_source_type IN bsc_sys_filters_views.source_type%TYPE
223: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
224: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
225: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
226: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
227: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
228: ,x_return_status OUT NOCOPY VARCHAR2

Line 225: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE

221: (
222: p_source_type IN bsc_sys_filters_views.source_type%TYPE
223: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
224: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
225: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
226: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
227: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
228: ,x_return_status OUT NOCOPY VARCHAR2
229: ,x_msg_count OUT NOCOPY NUMBER

Line 226: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE

222: p_source_type IN bsc_sys_filters_views.source_type%TYPE
223: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
224: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
225: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
226: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
227: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
228: ,x_return_status OUT NOCOPY VARCHAR2
229: ,x_msg_count OUT NOCOPY NUMBER
230: ,x_msg_data OUT NOCOPY VARCHAR2

Line 238: bsc_sys_filters_views(

234:
235: IF (p_source_type IS NOT NULL AND p_source_code IS NOT NULL AND p_dim_level_id IS NOT NULL AND p_level_table_name IS NOT NULL AND p_level_view_name IS NOT NULL) THEN
236: INSERT
237: INTO
238: bsc_sys_filters_views(
239: source_type,
240: source_code,
241: dim_level_id,
242: level_table_name,