DBA Data[Home] [Help]

APPS.CS_SR_SYNC_INDEX_PKG dependencies on AD_CTX_DDL

Line 224: ad_ctx_ddl.sync_index( l_ind_owner ||'.summary_ctx_index' );

220: end if;
221:
222: if (bmode = 'S') then
223: --ctx_ddl.sync_index( '1..summary_ctx_index' );
224: ad_ctx_ddl.sync_index( l_ind_owner ||'.summary_ctx_index' );
225: else
226: EXECUTE IMMEDIATE sql_stmt1;
227: end if;
228: END IF;

Line 273: ad_ctx_ddl.sync_index( l_index_name );

269:
270: BEGIN
271:
272: IF bmode = 'S' THEN
273: ad_ctx_ddl.sync_index( l_index_name );
274: ELSIF bmode = 'OFAST' THEN
275: ad_ctx_ddl.optimize_index( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
276: ELSIF bmode = 'OFULL' THEN
277: ad_ctx_ddl.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );

Line 275: ad_ctx_ddl.optimize_index( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );

271:
272: IF bmode = 'S' THEN
273: ad_ctx_ddl.sync_index( l_index_name );
274: ELSIF bmode = 'OFAST' THEN
275: ad_ctx_ddl.optimize_index( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
276: ELSIF bmode = 'OFULL' THEN
277: ad_ctx_ddl.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
278: ELSIF bmode = 'R' THEN
279:

Line 277: ad_ctx_ddl.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );

273: ad_ctx_ddl.sync_index( l_index_name );
274: ELSIF bmode = 'OFAST' THEN
275: ad_ctx_ddl.optimize_index( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
276: ELSIF bmode = 'OFULL' THEN
277: ad_ctx_ddl.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
278: ELSIF bmode = 'R' THEN
279:
280: -- Start of change for bug fix 4321240
281: --