APPS.BSC_DIM_LEVEL_FILTERS_PVT dependencies on BSC_SYS_FILTERS_VIEWS

Line 54: p_source_type IN bsc_sys_filters_views.source_type%TYPE

50: );
51:
52: PROCEDURE insert_filters_view
53: (
54: p_source_type IN bsc_sys_filters_views.source_type%TYPE
55: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
56: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
57: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
58: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE

Line 55: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE

51:
52: PROCEDURE insert_filters_view
53: (
54: p_source_type IN bsc_sys_filters_views.source_type%TYPE
55: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
56: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
57: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
58: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
59: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 56: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE

52: PROCEDURE insert_filters_view
53: (
54: p_source_type IN bsc_sys_filters_views.source_type%TYPE
55: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
56: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
57: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
58: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
59: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
60: ,x_return_status OUT NOCOPY VARCHAR2

Line 57: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE

53: (
54: p_source_type IN bsc_sys_filters_views.source_type%TYPE
55: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
56: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
57: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
58: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
59: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
60: ,x_return_status OUT NOCOPY VARCHAR2
61: ,x_msg_count OUT NOCOPY NUMBER

Line 58: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE

54: p_source_type IN bsc_sys_filters_views.source_type%TYPE
55: ,p_source_code IN bsc_sys_filters_views.source_code%TYPE
56: ,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
57: ,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
58: ,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
59: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
60: ,x_return_status OUT NOCOPY VARCHAR2
61: ,x_msg_count OUT NOCOPY NUMBER
62: ,x_msg_data OUT NOCOPY VARCHAR2