DBA Data[Home] [Help]

APPS.OKC_TEMPLATE_KEYWORD_PVT dependencies on AD_CTX_DDL

Line 18: ad_ctx_ddl.set_effective_schema('okc');

14: g_excp_level number := FND_LOG.LEVEL_EXCEPTION;
15:
16: procedure sync is
17: begin
18: ad_ctx_ddl.set_effective_schema('okc');
19: ad_ctx_ddl.sync_index('okc_terms_templates_ctx');
20: exception
21: when others then raise;
22: end;

Line 19: ad_ctx_ddl.sync_index('okc_terms_templates_ctx');

15:
16: procedure sync is
17: begin
18: ad_ctx_ddl.set_effective_schema('okc');
19: ad_ctx_ddl.sync_index('okc_terms_templates_ctx');
20: exception
21: when others then raise;
22: end;
23:

Line 26: ad_ctx_ddl.set_effective_schema('okc');

22: end;
23:
24: procedure optimize is
25: begin
26: ad_ctx_ddl.set_effective_schema('okc');
27: ad_ctx_ddl.optimize_index (
28: idx_name => 'okc_terms_templates_ctx',
29: optlevel => ad_ctx_ddl.optlevel_full,
30: maxtime => ad_ctx_ddl.maxtime_unlimited

Line 27: ad_ctx_ddl.optimize_index (

23:
24: procedure optimize is
25: begin
26: ad_ctx_ddl.set_effective_schema('okc');
27: ad_ctx_ddl.optimize_index (
28: idx_name => 'okc_terms_templates_ctx',
29: optlevel => ad_ctx_ddl.optlevel_full,
30: maxtime => ad_ctx_ddl.maxtime_unlimited
31: );

Line 29: optlevel => ad_ctx_ddl.optlevel_full,

25: begin
26: ad_ctx_ddl.set_effective_schema('okc');
27: ad_ctx_ddl.optimize_index (
28: idx_name => 'okc_terms_templates_ctx',
29: optlevel => ad_ctx_ddl.optlevel_full,
30: maxtime => ad_ctx_ddl.maxtime_unlimited
31: );
32: exception
33: when others then raise;

Line 30: maxtime => ad_ctx_ddl.maxtime_unlimited

26: ad_ctx_ddl.set_effective_schema('okc');
27: ad_ctx_ddl.optimize_index (
28: idx_name => 'okc_terms_templates_ctx',
29: optlevel => ad_ctx_ddl.optlevel_full,
30: maxtime => ad_ctx_ddl.maxtime_unlimited
31: );
32: exception
33: when others then raise;
34: end;