APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_SYS_FILTERS_VIEWS

Line 362: FROM BSC_SYS_FILTERS_VIEWS

358: l_count NUMBER;
359: BEGIN
360: SELECT COUNT(0)
361: INTO l_count
362: FROM BSC_SYS_FILTERS_VIEWS
363: WHERE DIM_LEVEL_ID = p_dim_level_id;
364:
365: IF(l_count>0)THEN
366: RETURN TRUE;

Line 403: FROM BSC_SYS_FILTERS_VIEWS

399:
400:
401: CURSOR c_filter_par_tabs IS
402: SELECT DISTINCT source_code
403: FROM BSC_SYS_FILTERS_VIEWS
404: WHERE source_type = 1
405: AND dim_level_id = p_par_dim_level_id;
406:
407: CURSOR c_filter_chd_tabs IS

Line 409: FROM BSC_SYS_FILTERS_VIEWS

405: AND dim_level_id = p_par_dim_level_id;
406:
407: CURSOR c_filter_chd_tabs IS
408: SELECT DISTINCT source_code
409: FROM BSC_SYS_FILTERS_VIEWS
410: WHERE source_type = 1
411: AND dim_level_id = p_dim_level_id;
412:
413: BEGIN

Line 580: , p_level_view_name IN BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE

576:
577: PROCEDURE Verify_Recreate_Filter_Views
578: (
579: p_source IN NUMBER
580: , p_level_view_name IN BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE
581: , p_dim_level_id IN BSC_SYS_FILTERS_VIEWS.dim_level_id%TYPE
582: , x_return_status OUT NOCOPY VARCHAR2
583: , x_msg_count OUT NOCOPY NUMBER
584: , x_msg_data OUT NOCOPY VARCHAR2

Line 581: , p_dim_level_id IN BSC_SYS_FILTERS_VIEWS.dim_level_id%TYPE

577: PROCEDURE Verify_Recreate_Filter_Views
578: (
579: p_source IN NUMBER
580: , p_level_view_name IN BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE
581: , p_dim_level_id IN BSC_SYS_FILTERS_VIEWS.dim_level_id%TYPE
582: , x_return_status OUT NOCOPY VARCHAR2
583: , x_msg_count OUT NOCOPY NUMBER
584: , x_msg_data OUT NOCOPY VARCHAR2
585: )IS

Line 655: FROM BSC_SYS_FILTERS_VIEWS

651: , x_msg_data OUT NOCOPY VARCHAR2
652: )IS
653: CURSOR c_filter_tabs(l_dim_level_id IN NUMBER) IS
654: SELECT source_code,level_view_name,dim_level_id
655: FROM BSC_SYS_FILTERS_VIEWS
656: WHERE SOURCE_TYPE=1
657: AND DIM_LEVEL_ID =l_dim_level_id;
658:
659: l_tab NUMBER;

Line 660: l_level_view_name BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;

656: WHERE SOURCE_TYPE=1
657: AND DIM_LEVEL_ID =l_dim_level_id;
658:
659: l_tab NUMBER;
660: l_level_view_name BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;
661: l_dim_level_id BSC_SYS_FILTERS_VIEWS.dim_level_id%TYPE;
662:
663: l_old_count NUMBER;
664: l_new_count NUMBER;

Line 661: l_dim_level_id BSC_SYS_FILTERS_VIEWS.dim_level_id%TYPE;

657: AND DIM_LEVEL_ID =l_dim_level_id;
658:
659: l_tab NUMBER;
660: l_level_view_name BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;
661: l_dim_level_id BSC_SYS_FILTERS_VIEWS.dim_level_id%TYPE;
662:
663: l_old_count NUMBER;
664: l_new_count NUMBER;
665: