APPS.AMV_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 AMV
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_AMV_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_AMV_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: owner varchar2(30);

Line 76: IF p_runtime IS NULL OR p_runtime = ctx_ddl.maxtime_unlimited THEN

72:
73: IF p_optimize_level = 'FAST' THEN
74: l_maxtime := null;
75: ELSE
76: IF p_runtime IS NULL OR p_runtime = ctx_ddl.maxtime_unlimited THEN
77: l_maxtime := ' maxtime unlimited';
78: ELSE
79: -- Two indexes so split time in half.
80: l_maxtime := ' maxtime '||TRUNC(p_runtime/2);