APPS.BIS_DIMLEVEL_ERRS_PVT SQL Statements

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

Line: 12

REM |     Private API for getting the Select String for DimensionLevelValues|
REM |     This API will get the Select String from either EDW or BIS        |
REM |     depending on the profile option BIS_SOURCE                        |
REM |                                                                       |
REM | HISTORY                                                               |
REM | December-2000 amkulkar Creation                                       |
REM +=======================================================================+
*/
--
-- CONSTANTS
   EDW_ACCT_FLEXFIELD           VARCHAR2(200) := 'EDW_GL';

Line: 35

   SELECT vp.value
   FROM v$parameter vp
   WHERE vp.name = 'utl_file_dir';

Line: 94

 l_select_string     VARCHAR2(32000);

Line: 99

 SELECT
       lvl.name lvlshortname, lvl.longname lvlname, lvl.description lvldesc
       ,lvl.prefix prefix
 FROM
        cmplevel_v lvl
 WHERE
        (lvl.name = p_dim_level_name OR p_dim_level_name IS NULL)
 ;

Line: 108

 SELECT dim.name dimshortname
 FROM cmpwbdimension_v dim, cmplevel_v lvl
 WHERE
       lvl.name=p_lvlshort_name AND
       lvl.dimension = dim.elementid
 ;

Line: 116

 SELECT item.name
 FROM cmpitem_v item, cmprelation_v rel,
      cmpwbitemsetusage_v isu, cmpuniquekey_v pk
 WHERE pk.owningrelation=rel.elementid
         and isu.itemset=pk.elementid
         and isu.attribute=item.elementid
         and upper(rel.name)  = upper(l_lvlshortname )
         and item.name like '%PK_KEY';

Line: 126

 SELECT level_table_col_name
 FROM edw_level_Table_atts_md_v
 WHERE key_type='UK' AND
       upper(level_Table_name) = upper(l_lvlshortname||'_LTC') AND
       level_table_col_name like '%PK_KEY%';

Line: 151

  l_pkkey_sql := ' SELECT level_table_col_name '||
        --2245747         ' FROM edw_level_Table_atts_md_v '||
                 ' FROM EDW_LVL_TBL_UK_MD_V  '||     --2245747
                 ' WHERE key_type=''UK'' AND '||
                 ' upper(level_Table_name) = upper(:l_lvlshortname_ltc) AND '||
                 ' level_table_col_name like ''%PK_KEY%''';

Line: 159

  l_dim_sql := ' SELECT dim.name dimshortname  '||
               ' FROM cmpwbdimension_v dim, cmplevel_v lvl '||
               ' WHERE  '||
               ' lvl.name=:p_lvlshort_name AND '||
               ' lvl.dimension = dim.elementid ';

Line: 164

  l_dim_level_sql := ' SELECT  '||
                     ' lvl.name lvlshortname, lvl.longname lvlname, lvl.description lvldesc '||
                     ' ,lvl.prefix prefix '||
                     ' FROM '||
                     ' cmplevel_v lvl '||
                     ' WHERE  '||
                     ' (lvl.name = :1 OR :2 IS NULL) ';

Line: 172

  l_dim_sql := ' SELECT dim.dim_name dimshortname  '||
               ' FROM edw_dimensions_md_v dim, edw_levels_md_v lvl '||
               ' WHERE  '||
               ' lvl.level_name=:p_lvlshort_name AND '||
               ' lvl.dim_id = dim.dim_id ';

Line: 178

  l_dim_level_sql := ' SELECT  '||
                     ' lvl.LEVEL_NAME lvlshortname, lvl.LEVEL_LONG_NAME lvlname, lvl.DESCRIPTION lvldesc '||
                     ' ,lvl.LEVEL_PREFIX prefix '||
                     ' FROM '||
                     ' edw_levels_md_v lvl '||
                     ' WHERE  '||
                     ' (lvl.LEVEL_NAME = :1 OR :2 IS NULL) ';

Line: 210

         l_sql_string := 'SELECT '||l_pkkey||' from '||l_tablename|| ' where rownum < 2';

Line: 250

         l_sql_string := 'SELECT '||l_pkkey||' from '||l_tablename|| ' where rownum < 2';

Line: 281

            l_sql_string   := 'SELECT start_date from '||l_tablename||' where rownum < 2';

Line: 295

            l_sql_string   := 'SELECT end_date from '||l_tablename||' where rownum < 2';

Line: 313

        l_sql_string := 'SELECT '||l_valuename||' from '||l_tablename|| ' where rownum < 2';