DBA Data[Home] [Help]

APPS.BSC_DIM_LEVEL_FILTERS_PVT dependencies on BSC_SYS_FILTERS

Line 32: p_source_type IN bsc_sys_filters.source_type%TYPE

28: );
29:
30: PROCEDURE insert_filters
31: (
32: p_source_type IN bsc_sys_filters.source_type%TYPE
33: ,p_source_code IN bsc_sys_filters.source_code%TYPE
34: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
35: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
36: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 33: ,p_source_code IN bsc_sys_filters.source_code%TYPE

29:
30: PROCEDURE insert_filters
31: (
32: p_source_type IN bsc_sys_filters.source_type%TYPE
33: ,p_source_code IN bsc_sys_filters.source_code%TYPE
34: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
35: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
36: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
37: ,x_return_status OUT NOCOPY VARCHAR2

Line 34: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE

30: PROCEDURE insert_filters
31: (
32: p_source_type IN bsc_sys_filters.source_type%TYPE
33: ,p_source_code IN bsc_sys_filters.source_code%TYPE
34: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
35: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
36: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
37: ,x_return_status OUT NOCOPY VARCHAR2
38: ,x_msg_count OUT NOCOPY NUMBER

Line 35: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE

31: (
32: p_source_type IN bsc_sys_filters.source_type%TYPE
33: ,p_source_code IN bsc_sys_filters.source_code%TYPE
34: ,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
35: ,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
36: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
37: ,x_return_status OUT NOCOPY VARCHAR2
38: ,x_msg_count OUT NOCOPY NUMBER
39: ,x_msg_data OUT NOCOPY VARCHAR2

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