DBA Data[Home] [Help]

APPS.BSC_DIM_LEVEL_FILTERS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

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;
Line: 65

            x_msg_data      :=  x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
Line: 67

            x_msg_data      :=  SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
Line: 74

            x_msg_data      :=  x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
Line: 76

            x_msg_data      :=  SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
Line: 81

END delete_filters;
Line: 84

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
                   );
Line: 137

            x_msg_data      :=  x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
Line: 139

            x_msg_data      :=  SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
Line: 146

            x_msg_data      :=  x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
Line: 148

            x_msg_data      :=  SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
Line: 153

END insert_filters;
Line: 156

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;
Line: 202

            x_msg_data      :=  x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
Line: 204

            x_msg_data      :=  SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
Line: 211

            x_msg_data      :=  x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
Line: 213

            x_msg_data      :=  SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
Line: 217

END delete_filters_view;
Line: 220

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
            );
Line: 277

            x_msg_data      :=  x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
Line: 279

            x_msg_data      :=  SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
Line: 286

            x_msg_data      :=  x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
Line: 288

            x_msg_data      :=  SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
Line: 293

END insert_filters_view;