APPS.EGO_ITEM_TEXT_PVT dependencies on CTX_PREFERENCES

Line 202: FROM ctxsys.ctx_preferences

198: Log_Line (l_api_name || ': dropping all existing preferences ...');
199:
200: l_pref_name := 'EGO_ITEM_MULTI_LEXER';
201: FOR multi_lexer_rec IN ( SELECT pre_owner, pre_name
202: FROM ctxsys.ctx_preferences
203: WHERE pre_name = l_pref_name )
204: LOOP
205: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
206: END LOOP;

Line 209: FROM ctxsys.ctx_preferences

205: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
206: END LOOP;
207:
208: FOR sub_lexer_rec IN ( SELECT pre_owner, pre_name
209: FROM ctxsys.ctx_preferences
210: WHERE pre_name LIKE 'EGO_ITEM_LEXER%' )
211: LOOP
212: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);
213: END LOOP;

Line 217: FROM ctxsys.ctx_preferences

213: END LOOP;
214:
215: l_pref_name := 'EGO_ITEM_WORDLIST';
216: FOR wordlist_rec IN ( SELECT pre_owner, pre_name
217: FROM ctxsys.ctx_preferences
218: WHERE pre_name = l_pref_name )
219: LOOP
220: ad_ctx_ddl.drop_preference (wordlist_rec.pre_owner ||'.'|| wordlist_rec.pre_name);
221: END LOOP;

Line 239: FROM ctxsys.ctx_preferences

235: END LOOP;
236:
237: l_pref_name := 'EGO_ITEM_DATASTORE';
238: FOR datastore_rec IN ( SELECT pre_owner, pre_name
239: FROM ctxsys.ctx_preferences
240: WHERE pre_name = l_pref_name )
241: LOOP
242: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);
243: END LOOP;

Line 247: FROM ctxsys.ctx_preferences

243: END LOOP;
244:
245: l_pref_name := 'EGO_ITEM_STORAGE';
246: FOR storage_rec IN ( SELECT pre_owner, pre_name
247: FROM ctxsys.ctx_preferences
248: WHERE pre_name = l_pref_name )
249: LOOP
250: ad_ctx_ddl.drop_preference (storage_rec.pre_owner ||'.'|| storage_rec.pre_name);
251: END LOOP;