APPS.EGO_ITEM_TEXT_PVT SQL Statements

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

Line: 116

      SELECT value INTO g_Dump_Dir
      FROM v$parameter WHERE name = 'user_dump_dest';

Line: 119

      SELECT TRANSLATE(LTRIM(value), ',', ' ') INTO g_Log_Dir
      FROM v$parameter
      WHERE name = 'utl_file_dir';

Line: 201

   FOR multi_lexer_rec IN ( SELECT pre_owner, pre_name
                            FROM ctxsys.ctx_preferences
                            WHERE pre_name = l_pref_name )
   LOOP
      ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);

Line: 208

   FOR sub_lexer_rec IN   ( SELECT pre_owner, pre_name
                            FROM ctxsys.ctx_preferences
                            WHERE pre_name LIKE 'EGO_ITEM_LEXER%' )
   LOOP
      ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);

Line: 216

   FOR wordlist_rec IN    ( SELECT pre_owner, pre_name
                            FROM ctxsys.ctx_preferences
                            WHERE pre_name = l_pref_name )
   LOOP
      ad_ctx_ddl.drop_preference (wordlist_rec.pre_owner ||'.'|| wordlist_rec.pre_name);

Line: 223

   FOR stoplist_rec IN    ( SELECT spl_owner, spl_name
                            FROM ctxsys.ctx_stoplists
                            WHERE spl_name = 'EGO_ITEM_STOPLIST' )
   LOOP
      ad_ctx_ddl.Drop_Stoplist (stoplist_rec.spl_owner || '.EGO_ITEM_STOPLIST');

Line: 230

   FOR section_group_rec IN ( SELECT sgp_owner, sgp_name
                            FROM ctxsys.ctx_section_groups
                            WHERE sgp_name = 'EGO_ITEM_SECTION_GROUP' )
   LOOP
      ad_ctx_ddl.Drop_Section_Group (section_group_rec.sgp_owner ||'.'|| section_group_rec.sgp_name);

Line: 238

   FOR datastore_rec IN   ( SELECT pre_owner, pre_name
                            FROM ctxsys.ctx_preferences
                            WHERE pre_name = l_pref_name )
   LOOP
      ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);

Line: 246

   FOR storage_rec IN   ( SELECT pre_owner, pre_name
                            FROM ctxsys.ctx_preferences
                            WHERE pre_name = l_pref_name )
   LOOP
      ad_ctx_ddl.drop_preference (storage_rec.pre_owner ||'.'|| storage_rec.pre_name);

Line: 262

   SELECT 'tablespace ' || tablespace_name ||
          ' storage (initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0)'
     INTO tspace_tbl_param
   FROM all_tables
   WHERE owner = g_Prod_Schema AND table_name = 'EGO_ITEM_TEXT_TL';

Line: 268

   SELECT 'tablespace ' || tablespace_name ||
          ' storage (initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0)'
     INTO tspace_idx_param
   FROM all_indexes
   WHERE owner = g_Prod_Schema
     AND index_name = 'EGO_ITEM_TEXT_TL_U1'
     AND table_name = 'EGO_ITEM_TEXT_TL';

Line: 608

   FOR index_rec IN ( SELECT owner, index_name, status, domidx_status, domidx_opstatus
                      FROM all_indexes
                      WHERE ( owner = g_Prod_Schema OR owner = USER OR owner = g_Ctx_Schema )
                        AND table_name = 'EGO_ITEM_TEXT_TL'
                        AND index_name = p_Index_Name )
   LOOP
      -- Check index schema
      --
      IF ( index_rec.owner <> g_Index_Owner )
      THEN
         Log_Line (l_api_name || ': Error: index exists in wrong schema: ' || index_rec.owner);

Line: 730

         SELECT par_value INTO l_Index_Memory_Max
         FROM ctx_parameters
         WHERE par_name = 'MAX_INDEX_MEMORY';

Line: 851

         SELECT idx_docid_count, idx_status
           INTO l_idx_docid_count, l_idx_status
         FROM ctxsys.ctx_indexes
         WHERE idx_owner = g_Index_Owner AND idx_name = p_Index_Name
           AND idx_table = 'EGO_ITEM_TEXT_TL';

Line: 1027

   FOR index_rec IN ( SELECT owner, index_name, index_type, status, domidx_opstatus
                      FROM all_indexes
                      WHERE ( owner = g_Prod_Schema OR owner = USER OR owner = g_Ctx_Schema )
                        AND table_name = 'EGO_ITEM_TEXT_TL'
                        AND (    index_type = 'DOMAIN'
                              OR index_name LIKE 'EGO_ITEM_TEXT_TL_CTX%' )
                    )
   LOOP
      l_index_exists := TRUE;