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_VIEWS

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,