DBA Data[Home] [Help]

APPS.JTA_NOTES_IMT_PUB dependencies on CTX_DDL

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

105: -- End of comments
106: --------------------------------------------------------------------------
107: ( errbuf OUT NOCOPY VARCHAR2
108: , retcode OUT NOCOPY NUMBER
109: , p_optimize_level IN VARCHAR2 := ctx_ddl.optlevel_full
110: , p_runtime IN NUMBER := ctx_ddl.maxtime_unlimited
111: )
112: AS
113: l_maxtime VARCHAR2(30);

Line 110: , p_runtime IN NUMBER := ctx_ddl.maxtime_unlimited

106: --------------------------------------------------------------------------
107: ( errbuf OUT NOCOPY VARCHAR2
108: , retcode OUT NOCOPY NUMBER
109: , p_optimize_level IN VARCHAR2 := ctx_ddl.optlevel_full
110: , p_runtime IN NUMBER := ctx_ddl.maxtime_unlimited
111: )
112: AS
113: l_maxtime VARCHAR2(30);
114: l_stmt VARCHAR2(256);

Line 131: or (p_runtime > ctx_ddl.maxtime_unlimited)

127: IF (p_runtime IS NOT NULL)
128: THEN
129: IF ( (trunc(p_runtime) <> p_runtime)
130: or (p_runtime < 0)
131: or (p_runtime > ctx_ddl.maxtime_unlimited)
132: )
133: THEN
134: fnd_message.set_name('JTF', 'JTF_NOTES_BAD_PARAMETER_VALUE');
135: fnd_message.set_token('VALUE', NVL(p_runtime,'NULL'));

Line 159: OR (p_runtime = ctx_ddl.maxtime_unlimited)

155: THEN
156: l_maxtime := NULL;
157: ELSE
158: IF ( (p_runtime IS NULL)
159: OR (p_runtime = ctx_ddl.maxtime_unlimited)
160: )
161: THEN
162: l_maxtime := ' maxtime unlimited';
163: ELSE