APPS.BSC_UPGRADES_GENERIC SQL Statements

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

Line: 59

   SELECT distinct usr.user_name
   FROM   fnd_user_resp_groups ur,
          fnd_responsibility r,
          fnd_user  usr
   WHERE  ur.responsibility_id = r.responsibility_id
   AND    usr.user_id = ur.user_id
   AND    ur.responsibility_application_id = r.application_id
   AND    r.application_id = 271
   AND    r.responsibility_key IN ('BSC_DESIGNER' ,'BSC_Manager')
   AND    SYSDATE BETWEEN usr.Start_Date AND NVL(usr.End_Date, SYSDATE)
   AND    SYSDATE BETWEEN r.Start_Date   AND NVL(r.End_Date, SYSDATE)
   AND    SYSDATE BETWEEN ur.Start_Date  AND NVL(ur.End_Date, SYSDATE);

Line: 74

    SELECT tab_id
    FROM   bsc_tabs_b;

Line: 81

    IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value(l_property_code, l_property_value) THEN
        RAISE FND_API.G_EXC_ERROR;

Line: 93

        SELECT OBJECT_ID into l_object_id FROM FND_OBJECTS WHERE OBJ_NAME = l_object_name;

Line: 96

        DELETE FROM FND_GRANTS WHERE OBJECT_ID  = to_char(l_object_id)
        AND  PROGRAM_NAME = 'BSC_PMD_GRANTS';

Line: 133

        IF NOT BSC_UPDATE_UTIL.Write_Init_Variable_Value(l_property_code, '0') THEN
            RAISE FND_API.G_EXC_ERROR;

Line: 186

        SELECT tab_id, tab_view_id, name, help
        FROM bsc_tab_views_vl v
        WHERE v.tab_view_id > 1;

Line: 194

    IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value(l_property_code, l_property_value) THEN
        RAISE FND_API.G_EXC_ERROR;

Line: 207

            BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function(p_tab_id => l_tab_id,
                                                              p_tab_view_id => l_tab_view_id,
                                                              p_name => l_name,
                                                              p_description => l_help,
                                                              x_function_id => l_function_id,
                                                              x_return_status => x_return_status ,
                                                              x_msg_count => x_msg_count,
                                                              x_msg_data => x_msg_data);

Line: 219

        IF NOT BSC_UPDATE_UTIL.Write_Init_Variable_Value(l_property_code, '0') THEN
            RAISE FND_API.G_EXC_ERROR;

Line: 264

        select distinct tab_id, tab_view_id, indicator, text_flag, left_position,
        top_position, width, height, font_size, font_style, font_color
        from bsc_tab_view_kpi_tl;

Line: 271

    IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value(l_property_code, l_property_value) THEN
        RAISE FND_API.G_EXC_ERROR;

Line: 279

            select count(*) into l_count from bsc_tab_view_labels_b
            where tab_id = all_tab_view_kpis.tab_id and tab_view_id=all_tab_view_kpis.tab_view_id
            and label_type = BSC_CUSTOM_VIEW_UI_WRAPPER.c_type_kpi and link_id = all_tab_view_kpis.indicator;

Line: 289

                select DECODE(max(LABEL_ID),NULL,0,max(LABEL_ID)+1) into l_label_id
                from bsc_tab_view_labels_b
                where tab_id = all_tab_view_kpis.tab_id and tab_view_id=all_tab_view_kpis.tab_view_id;

Line: 295

                 BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_kpi_label(
                    p_tab_id        => all_tab_view_kpis.tab_id
                   ,p_tab_view_id   => all_tab_view_kpis.tab_view_id
                   ,p_object_id     => l_label_id
                   ,p_text_flag     => all_tab_view_kpis.text_flag
                   ,p_label_text    => BSC_UPGRADES_GENERIC.c_kpi_label
                   ,p_font_size     => all_tab_view_kpis.font_size
                   ,p_font_color    => all_tab_view_kpis.font_color
                   ,p_font_style    => all_tab_view_kpis.font_style
                   ,p_left          => all_tab_view_kpis.left_position
                   ,p_top           => all_tab_view_kpis.top_position
                   ,p_width         => all_tab_view_kpis.width
                   ,p_height        => all_tab_view_kpis.height
                   ,p_kpi_id        => all_tab_view_kpis.indicator
                   ,p_function_id   => BSC_UPGRADES_GENERIC.c_function_id
                   ,x_return_status => x_return_status
                   ,x_msg_count     => x_msg_count
                   ,x_msg_data      => x_msg_data
                  );

Line: 324

        IF NOT BSC_UPDATE_UTIL.Write_Init_Variable_Value(l_property_code, '0') THEN
            RAISE FND_API.G_EXC_ERROR;