APPS.BSC_SYS_DIMTABLES_PKG SQL Statements

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

Line: 10

        SELECT level_table_name
        FROM bsc_sys_dim_levels_b
        WHERE nvl(edw_flag, 0) = 0 AND
              nvl(source, 'BSC') = 'BSC';

Line: 18

       SELECT column_name
       FROM all_tab_columns
       WHERE table_name = UPPER(h_dim_table) AND
             owner = UPPER(BSC_APPS.BSC_APPS_SCHEMA);

Line: 24

   h_lst_insert VARCHAR2(32000);

Line: 25

   h_lst_select VARCHAR2(32000);

Line: 35

        h_sql := 'UPDATE '||h_dim_table||' T'||
                 ' SET NAME = ('||
                 '   SELECT B.NAME'||
                 '   FROM '||h_dim_table||' B'||
                 '   WHERE B.CODE = T.CODE AND'||
                 '         B.LANGUAGE = T.SOURCE_LANG'||
                 ' )'||
                 ' WHERE (T.CODE, T.LANGUAGE) IN ('||
                 '   SELECT SUBT.CODE, SUBT.LANGUAGE'||
                 '   FROM '||h_dim_table||' SUBB, '||h_dim_table||' SUBT'||
                 '   WHERE SUBB.CODE = SUBT.CODE AND'||
                 '         SUBB.LANGUAGE = SUBT.SOURCE_LANG AND'||
                 '         SUBB.NAME <> SUBT.NAME'||
                 '   )';

Line: 51

        h_lst_insert := NULL;

Line: 52

        h_lst_select := NULL;

Line: 57

            IF h_lst_insert IS NOT NULL THEN
                h_lst_insert := h_lst_insert||', ';

Line: 59

                h_lst_select := h_lst_select||', ';

Line: 62

            h_lst_insert := h_lst_insert||h_column_name;

Line: 65

                h_lst_select := h_lst_select||'L.LANGUAGE_CODE';

Line: 67

                h_lst_select := h_lst_select||'B.'||h_column_name;

Line: 74

        h_sql := 'INSERT INTO '||h_dim_table||' ('||h_lst_insert||')'||
                 ' SELECT '||h_lst_select||
                 ' FROM '||h_dim_table||' B, FND_LANGUAGES L'||
                 ' WHERE L.INSTALLED_FLAG IN (''I'', ''B'') AND'||
                 '       B.LANGUAGE = USERENV(''LANG'') AND'||
                 '       NOT EXISTS ('||
                 '         SELECT NULL'||
                 '         FROM '||h_dim_table||' T'||
                 '         WHERE T.CODE = B.CODE AND'||
                 '               T.LANGUAGE = L.LANGUAGE_CODE'||
                 '       )';