APPS.ENG_CHANGE_TEXT_PVT dependencies on CTX_PREFERENCES

Line 193: l_pre_name ctxsys.ctx_preferences.pre_name%TYPE; -- Bug 4958959

189:
190: --Lang_ISO_List Lang_ISO_List_type :=
191: -- Lang_ISO_List_type ('EN', '', 'DE', 'SV', 'NO', 'FR', '', '');
192:
193: l_pre_name ctxsys.ctx_preferences.pre_name%TYPE; -- Bug 4958959
194: BEGIN
195: Log_Line (l_api_name || ': begin');
196:
197: l_return_status := G_STATUS_SUCCESS;

Line 206: FROM ctxsys.ctx_preferences

202: Log_Line (l_api_name || ': dropping all existing preferences ...');
203:
204: l_pre_name := 'ENG_CHANGE_MULTI_LEXER'; -- Bug 4958959
205: FOR multi_lexer_rec IN ( SELECT pre_owner, pre_name
206: FROM ctxsys.ctx_preferences
207: WHERE pre_name = l_pre_name )
208: LOOP
209: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
210: END LOOP;

Line 213: FROM ctxsys.ctx_preferences

209: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
210: END LOOP;
211:
212: FOR sub_lexer_rec IN ( SELECT pre_owner, pre_name
213: FROM ctxsys.ctx_preferences
214: WHERE pre_name LIKE 'ENG_CHANGE_LEXER%' )
215: LOOP
216: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);
217: END LOOP;

Line 221: FROM ctxsys.ctx_preferences

217: END LOOP;
218:
219: l_pre_name := 'ENG_CHANGE_WORDLIST'; -- Bug 4958959
220: FOR wordlist_rec IN ( SELECT pre_owner, pre_name
221: FROM ctxsys.ctx_preferences
222: WHERE pre_name = l_pre_name )
223: LOOP
224: ad_ctx_ddl.drop_preference (wordlist_rec.pre_owner ||'.'|| wordlist_rec.pre_name);
225: END LOOP;

Line 243: FROM ctxsys.ctx_preferences

239: END LOOP;
240:
241: l_pre_name := 'ENG_CHANGE_DATASTORE'; -- Bug 4958959
242: FOR datastore_rec IN ( SELECT pre_owner, pre_name
243: FROM ctxsys.ctx_preferences
244: WHERE pre_name = l_pre_name )
245: LOOP
246: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);
247: END LOOP;

Line 251: FROM ctxsys.ctx_preferences

247: END LOOP;
248:
249: l_pre_name := 'ENG_CHANGE_STORAGE'; -- Bug 4958959
250: FOR storage_rec IN ( SELECT pre_owner, pre_name
251: FROM ctxsys.ctx_preferences
252: WHERE pre_name = l_pre_name )
253: LOOP
254: ad_ctx_ddl.drop_preference (storage_rec.pre_owner ||'.'|| storage_rec.pre_name);
255: END LOOP;