APPS.IBC_IMT_PUB dependencies on CTX_DDL

Line 28: -- Valid values are 'FAST','FULL', ctx_ddl.optlevel_fast or

24: -- Parameters :
25: --
26: -- IN : p_optimize_level IN VARCHAR2 Optional
27: -- Specifies the type of iMT index optimization to perform.
28: -- Valid values are 'FAST','FULL', ctx_ddl.optlevel_fast or
29: -- ctx_ddl.optlevel_full.
30: --
31: -- Default is ctx_ddl.optlevel_full.
32: --

Line 29: -- ctx_ddl.optlevel_full.

25: --
26: -- IN : p_optimize_level IN VARCHAR2 Optional
27: -- Specifies the type of iMT index optimization to perform.
28: -- Valid values are 'FAST','FULL', ctx_ddl.optlevel_fast or
29: -- ctx_ddl.optlevel_full.
30: --
31: -- Default is ctx_ddl.optlevel_full.
32: --
33: -- : p_runtime IN NUMBER Optional

Line 31: -- Default is ctx_ddl.optlevel_full.

27: -- Specifies the type of iMT index optimization to perform.
28: -- Valid values are 'FAST','FULL', ctx_ddl.optlevel_fast or
29: -- ctx_ddl.optlevel_full.
30: --
31: -- Default is ctx_ddl.optlevel_full.
32: --
33: -- : p_runtime IN NUMBER Optional
34: -- Integer that indicates the total run-time (in seconds) of
35: -- this optimization function call. This time will be

Line 40: -- Default is ctx_ddl.maxtime_unlimited.

36: -- divided equally amongst all indexes within the IBC
37: -- subsystem. A null value implies execution until
38: -- completion of the task.
39: --
40: -- Default is ctx_ddl.maxtime_unlimited.
41: --
42: -- Version : Current version 1.0
43: -- {add comments here}
44: -- Previous version 1.0

Line 53: p_optimize_level IN VARCHAR2 := ctx_ddl.optlevel_full,

49:
50: PROCEDURE OPTIMIZE_IBC_IMT_INDEXES
51: (ERRBUF OUT NOCOPY VARCHAR2,
52: RETCODE OUT NOCOPY NUMBER,
53: p_optimize_level IN VARCHAR2 := ctx_ddl.optlevel_full,
54: p_runtime IN NUMBER := ctx_ddl.maxtime_unlimited)
55: AS
56: --
57: l_maxtime VARCHAR2(30);

Line 54: p_runtime IN NUMBER := ctx_ddl.maxtime_unlimited)

50: PROCEDURE OPTIMIZE_IBC_IMT_INDEXES
51: (ERRBUF OUT NOCOPY VARCHAR2,
52: RETCODE OUT NOCOPY NUMBER,
53: p_optimize_level IN VARCHAR2 := ctx_ddl.optlevel_full,
54: p_runtime IN NUMBER := ctx_ddl.maxtime_unlimited)
55: AS
56: --
57: l_maxtime VARCHAR2(30);
58: l_user_name VARCHAR2(30);

Line 83: OR p_runtime = ctx_ddl.maxtime_unlimited

79: IF p_optimize_level = 'FAST' THEN
80: l_maxtime := NULL;
81: ELSE
82: IF p_runtime IS NULL
83: OR p_runtime = ctx_ddl.maxtime_unlimited
84: THEN
85: l_maxtime := ' maxtime unlimited';
86: ELSE
87: -- Two indexes so split time in half.

Line 98: ad_ctx_ddl.OPTIMIZE_INDEX(l_user_name||'.'||l_index_name,p_optimize_level,p_runtime);

94: -----------------------
95: OPEN c_index_name;
96: FETCH c_index_name INTO l_index_name;
97: IF c_index_name%FOUND THEN
98: ad_ctx_ddl.OPTIMIZE_INDEX(l_user_name||'.'||l_index_name,p_optimize_level,p_runtime);
99: END IF;
100: CLOSE c_index_name;
101:
102: /*

Line 175: ad_ctx_ddl.SYNC_INDEX(l_owner_name||'.'||l_index_name);

171: OPEN c_index_name;
172: FETCH c_index_name INTO l_index_name;
173: IF c_index_name%FOUND
174: THEN
175: ad_ctx_ddl.SYNC_INDEX(l_owner_name||'.'||l_index_name);
176: END IF;
177: CLOSE c_index_name;
178: /*
179: curs := dbms_sql.open_cursor;