DBA Data[Home] [Help]

APPS.EAM_TEXT_INDEX_PVT SQL Statements

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

Line: 169

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

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

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

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

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

   FOR stoplist_rec IN		( SELECT spl_owner, spl_name
                       		    FROM ctxsys.ctx_stoplists
                       		   WHERE spl_name = 'EAM_ASSET_STOPLIST' )
   LOOP
      --ad_ctx_ddl.Drop_Stoplist (stoplist_rec.spl_owner || '.EAM_ASSET_STOPLIST');
Line: 284

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

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

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

   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 = 'EAM_ASSET_TEXT';
Line: 319

   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 = 'EAM_ASSET_TEXT_U1'
      AND table_name = 'EAM_ASSET_TEXT';
Line: 647

   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 = 'EAM_ASSET_TEXT'
                        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,  FND_LOG.LEVEL_EVENT, l_api_name);
Line: 776

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

         SELECT idx_docid_count, idx_status
           INTO l_idx_docid_count, l_idx_status
         FROM ctxsys.ctx_indexes
         WHERE idx_owner = g_Prod_Schema AND idx_name = 'EAM_ASSET_TEXT_CTX1'
           AND idx_table = 'EAM_ASSET_TEXT';
Line: 977

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

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

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

   FOR stoplist_rec IN		( SELECT spl_owner, spl_name
                       		    FROM ctxsys.ctx_stoplists
                       		   WHERE spl_name = 'EAM_WORK_ORDER_STOPLIST' )
   LOOP
      --ad_ctx_ddl.Drop_Stoplist (stoplist_rec.spl_owner || '.EAM_WORK_ORDER_STOPLIST');
Line: 1006

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

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

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

   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 = 'EAM_WORK_ORDER_TEXT';
Line: 1041

   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 = 'EAM_WORK_ORDER_TEXT_U1'
      AND table_name = 'EAM_WORK_ORDER_TEXT';
Line: 1372

   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 = 'EAM_WORK_ORDER_TEXT'
                        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, FND_LOG.LEVEL_EVENT, l_api_name);
Line: 1501

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

         SELECT idx_docid_count, idx_status
           INTO l_idx_docid_count, l_idx_status
         FROM ctxsys.ctx_indexes
         WHERE idx_owner = g_Prod_Schema AND idx_name = 'EAM_WORK_ORDER_TEXT_CTX1'
           AND idx_table = 'EAM_WORK_ORDER_TEXT';
Line: 1669

		    2 - Update / Rebuild
                    3 - Optimize
		    4 - Drop
		    5-  When work order status code is updated from user defined statuses form. The Status_Id which was updated will be passed in p_dummy1 parameter
*/


PROCEDURE Build_Text_Index
(
    ERRBUF		OUT  NOCOPY  VARCHAR2
 ,  RETCODE		OUT  NOCOPY  NUMBER
 ,  p_text_context      IN           NUMBER
 ,  p_Action		IN           NUMBER
 ,  p_dummy1            IN           NUMBER   DEFAULT  NULL
 ,  p_optlevel		IN	     NUMBER   DEFAULT  NULL
 ,  p_dummy2            IN           NUMBER   DEFAULT  NULL
 ,  p_maxtime		IN           NUMBER   DEFAULT  AD_CTX_DDL.Maxtime_Unlimited
)
IS
   l_api_name		CONSTANT VARCHAR2(30)  :=  'Build_Text_Index';
Line: 1758

		     Log_Line ('Calling Eam_Text_Util.Process_Status_Update_Event ...', FND_LOG.LEVEL_EVENT, l_api_name);
Line: 1760

			 Eam_Text_Util.Process_Status_Update_Event(p_status_id => p_dummy1,    --User Defined Status Id whose status code has been updated
														p_commit  =>   FND_API.G_TRUE,
			                                                                                        x_return_status => l_return_status);
Line: 1764

                     Log_Line ('after calling update status event ...Return Status is : '|| l_return_status, FND_LOG.LEVEL_EVENT, l_api_name);