The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE delete_filters
(
p_tab_id IN NUMBER
,p_dim_level_id IN NUMBER
,p_commit IN VARCHAR2 := FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
BEGIN
IF (p_tab_id is not null and p_dim_level_id is not null) THEN
DELETE
FROM bsc_sys_filters
WHERE source_type = 1
AND source_code = p_tab_id
AND dim_level_id = p_dim_level_id;
x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
END delete_filters;
PROCEDURE insert_filters
(
p_source_type IN bsc_sys_filters.source_type%TYPE
,p_source_code IN bsc_sys_filters.source_code%TYPE
,p_dim_level_id IN bsc_sys_filters.dim_level_id%TYPE
,p_dim_level_value IN bsc_sys_filters.dim_level_value%TYPE
,p_commit IN VARCHAR2 := FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
BEGIN
IF (p_source_type IS NOT NULL AND p_source_code IS NOT NULL AND p_dim_level_id IS NOT NULL AND p_dim_level_value IS NOT NULL) THEN
INSERT
INTO
bsc_sys_filters(source_type,
source_code,
dim_level_id,
dim_level_value
)
VALUES (p_source_type,
p_source_code ,
p_dim_level_id,
p_dim_level_value
);
x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
END insert_filters;
PROCEDURE delete_filters_view
(
p_tab_id IN NUMBER
,p_dim_level_id IN NUMBER
,p_commit IN VARCHAR2 := FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
BEGIN
IF (p_tab_id is not null and p_dim_level_id is not null) THEN
DELETE
FROM bsc_sys_filters_views
WHERE source_type = 1
AND source_code = p_tab_id
AND dim_level_id = p_dim_level_id;
x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
END delete_filters_view;
PROCEDURE insert_filters_view
(
p_source_type IN bsc_sys_filters_views.source_type%TYPE
,p_source_code IN bsc_sys_filters_views.source_code%TYPE
,p_dim_level_id IN bsc_sys_filters_views.dim_level_id%TYPE
,p_level_table_name IN bsc_sys_filters_views.level_table_name%TYPE
,p_level_view_name IN bsc_sys_filters_views.level_view_name%TYPE
,p_commit IN VARCHAR2 := FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
BEGIN
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
INSERT
INTO
bsc_sys_filters_views(
source_type,
source_code,
dim_level_id,
level_table_name,
level_view_name)
VALUES (p_source_type,
p_source_code,
p_dim_level_id,
p_level_table_name,
p_level_view_name
);
x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
END insert_filters_view;