APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on BSC_DIM_LEVEL_FILTERS_PVT

Line 213: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters(

209: RETURN;
210: END IF;
211:
212: --Delete filter values already existing before inserting new values
213: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters(
214: p_tab_id => p_tab_id
215: ,p_dim_level_id => p_dim_level_id
216: ,p_commit => FND_API.G_FALSE
217: ,x_return_status => x_return_status

Line 226: BSC_DIM_LEVEL_FILTERS_PVT.insert_filters(

222: -- INSERT all filter values in bsc_sys_filters
223: IF (p_level_vals_list IS NOT NULL) THEN --p_level_vals_list contains a comma seperated values of dim level values
224: WHILE (BSC_UTILITY.is_more(p_comma_sep_values => p_level_vals_list, x_value => l_level_val)) LOOP
225: l_level_value := TO_NUMBER(RTRIM(LTRIM(l_level_val)));
226: BSC_DIM_LEVEL_FILTERS_PVT.insert_filters(
227: p_source_type => 1
228: ,p_source_code => p_tab_id
229: ,p_dim_level_id => p_dim_level_id
230: ,p_dim_level_value => l_level_value

Line 240: BSC_DIM_LEVEL_FILTERS_PVT.insert_filters(

236: -- INSERT INTO bsc_sys_filters(source_type,source_code, dim_level_id,dim_level_value) VALUES (1,p_tab_id ,p_dim_level_id, l_level_value );
237: END LOOP;
238:
239: --INSERT 'ALL' value also.
240: BSC_DIM_LEVEL_FILTERS_PVT.insert_filters(
241: p_source_type => 1
242: ,p_source_code => p_tab_id
243: ,p_dim_level_id => p_dim_level_id
244: ,p_dim_level_value => 0

Line 423: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view (

419:
420: EXECUTE IMMEDIATE ('DROP VIEW ' || l_view); --DROP FILTER VIEW
421:
422: --DELETE entry from bsc_sys_filters_views
423: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view (
424: p_tab_id => p_tab_id
425: ,p_dim_level_id => p_dim_level_id
426: ,p_commit => FND_API.G_FALSE
427: ,x_return_status => x_return_status

Line 434: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters (

430: );
431: --DELETE FROM bsc_sys_filters_views WHERE source_type=1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;
432:
433: --DELTER entry from bsc_sys_filters
434: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters (
435: p_tab_id => p_tab_id
436: ,p_dim_level_id => p_dim_level_id
437: ,p_commit => FND_API.G_FALSE
438: ,x_return_status => x_return_status

Line 613: BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view(

609: x_msg_count => x_msg_count,
610: x_msg_data => x_msg_data
611: ); --TODO :: USE PACKAGE_NAME.FUNCTION_NAME
612:
613: BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view(
614: p_source_type => 1
615: ,p_source_code => p_tab_id
616: ,p_dim_level_id => p_dim_level_id
617: ,p_level_table_name => l_table