APPS.EAM_TEXT_INDEX_PVT dependencies on CTX_PREFERENCES

Line 256: FROM ctxsys.ctx_preferences

252:
253: Log_Line (l_api_name || ': dropping all existing preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);
254:
255: FOR multi_lexer_rec IN ( SELECT pre_owner, pre_name
256: FROM ctxsys.ctx_preferences
257: WHERE pre_name = 'EAM_ASSET_MULTI_LEXER' )
258: LOOP
259: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
260: END LOOP;

Line 263: FROM ctxsys.ctx_preferences

259: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
260: END LOOP;
261:
262: FOR sub_lexer_rec IN ( SELECT pre_owner, pre_name
263: FROM ctxsys.ctx_preferences
264: WHERE pre_name LIKE 'EAM_ASSET_LEXER%' )
265: LOOP
266: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);
267: END LOOP;

Line 270: FROM ctxsys.ctx_preferences

266: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);
267: END LOOP;
268:
269: FOR wordlist_rec IN ( SELECT pre_owner, pre_name
270: FROM ctxsys.ctx_preferences
271: WHERE pre_name = 'EAM_ASSET_WORDLIST' )
272: LOOP
273: ad_ctx_ddl.drop_preference (wordlist_rec.pre_owner ||'.'|| wordlist_rec.pre_name);
274: END LOOP;

Line 292: FROM ctxsys.ctx_preferences

288: ad_ctx_ddl.Drop_Section_Group (section_group_rec.sgp_owner ||'.'|| section_group_rec.sgp_name);
289: END LOOP;
290:
291: FOR datastore_rec IN ( SELECT pre_owner, pre_name
292: FROM ctxsys.ctx_preferences
293: WHERE pre_name = 'EAM_ASSET_DATASTORE' )
294: LOOP
295: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);
296: END LOOP;

Line 299: FROM ctxsys.ctx_preferences

295: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);
296: END LOOP;
297:
298: FOR storage_rec IN ( SELECT pre_owner, pre_name
299: FROM ctxsys.ctx_preferences
300: WHERE pre_name = 'EAM_ASSET_STORAGE' )
301: LOOP
302: ad_ctx_ddl.drop_preference (storage_rec.pre_owner ||'.'|| storage_rec.pre_name);
303: END LOOP;

Line 978: FROM ctxsys.ctx_preferences

974:
975: Log_Line (l_api_name || ': dropping all existing preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);
976:
977: FOR multi_lexer_rec IN ( SELECT pre_owner, pre_name
978: FROM ctxsys.ctx_preferences
979: WHERE pre_name = 'EAM_WORK_ORDER_MULTI_LEXER' )
980: LOOP
981: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
982: END LOOP;

Line 985: FROM ctxsys.ctx_preferences

981: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
982: END LOOP;
983:
984: FOR sub_lexer_rec IN ( SELECT pre_owner, pre_name
985: FROM ctxsys.ctx_preferences
986: WHERE pre_name LIKE 'EAM_WORK_ORDER_LEXER%' )
987: LOOP
988: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);
989: END LOOP;

Line 992: FROM ctxsys.ctx_preferences

988: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);
989: END LOOP;
990:
991: FOR wordlist_rec IN ( SELECT pre_owner, pre_name
992: FROM ctxsys.ctx_preferences
993: WHERE pre_name = 'EAM_WORK_ORDER_WORDLIST' )
994: LOOP
995: ad_ctx_ddl.drop_preference (wordlist_rec.pre_owner ||'.'|| wordlist_rec.pre_name);
996: END LOOP;

Line 1014: FROM ctxsys.ctx_preferences

1010: ad_ctx_ddl.Drop_Section_Group (section_group_rec.sgp_owner ||'.'|| section_group_rec.sgp_name);
1011: END LOOP;
1012:
1013: FOR datastore_rec IN ( SELECT pre_owner, pre_name
1014: FROM ctxsys.ctx_preferences
1015: WHERE pre_name = 'EAM_WORK_ORDER_DATASTORE' )
1016: LOOP
1017: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);
1018: END LOOP;

Line 1021: FROM ctxsys.ctx_preferences

1017: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);
1018: END LOOP;
1019:
1020: FOR storage_rec IN ( SELECT pre_owner, pre_name
1021: FROM ctxsys.ctx_preferences
1022: WHERE pre_name = 'EAM_WORK_ORDER_STORAGE' )
1023: LOOP
1024: ad_ctx_ddl.drop_preference (storage_rec.pre_owner ||'.'|| storage_rec.pre_name);
1025: END LOOP;