APPS.OKC_REP_CONTRACT_SEARCH_PVT dependencies on AD_CTX_DDL

Line 88: ad_ctx_ddl.set_effective_schema(G_APP_NAME);

84: IF FND_API.to_Boolean( p_init_msg_list ) THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87:
88: ad_ctx_ddl.set_effective_schema(G_APP_NAME);
89:
90: ad_ctx_ddl.sync_index(G_CONTRACTS_ALL_INDEX);
91: ad_ctx_ddl.sync_index(G_CONTRACT_VERS_INDEX);
92:

Line 90: ad_ctx_ddl.sync_index(G_CONTRACTS_ALL_INDEX);

86: END IF;
87:
88: ad_ctx_ddl.set_effective_schema(G_APP_NAME);
89:
90: ad_ctx_ddl.sync_index(G_CONTRACTS_ALL_INDEX);
91: ad_ctx_ddl.sync_index(G_CONTRACT_VERS_INDEX);
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:

Line 91: ad_ctx_ddl.sync_index(G_CONTRACT_VERS_INDEX);

87:
88: ad_ctx_ddl.set_effective_schema(G_APP_NAME);
89:
90: ad_ctx_ddl.sync_index(G_CONTRACTS_ALL_INDEX);
91: ad_ctx_ddl.sync_index(G_CONTRACT_VERS_INDEX);
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 168: ad_ctx_ddl.set_effective_schema(G_APP_NAME);

164: IF FND_API.to_Boolean( p_init_msg_list ) THEN
165: FND_MSG_PUB.initialize;
166: END IF;
167:
168: ad_ctx_ddl.set_effective_schema(G_APP_NAME);
169:
170: ad_ctx_ddl.optimize_index (
171: idx_name => G_CONTRACTS_ALL_INDEX,
172: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,

Line 170: ad_ctx_ddl.optimize_index (

166: END IF;
167:
168: ad_ctx_ddl.set_effective_schema(G_APP_NAME);
169:
170: ad_ctx_ddl.optimize_index (
171: idx_name => G_CONTRACTS_ALL_INDEX,
172: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,
173: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED
174: );

Line 172: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,

168: ad_ctx_ddl.set_effective_schema(G_APP_NAME);
169:
170: ad_ctx_ddl.optimize_index (
171: idx_name => G_CONTRACTS_ALL_INDEX,
172: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,
173: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED
174: );
175: ad_ctx_ddl.optimize_index (
176: idx_name => G_CONTRACT_VERS_INDEX,

Line 173: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED

169:
170: ad_ctx_ddl.optimize_index (
171: idx_name => G_CONTRACTS_ALL_INDEX,
172: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,
173: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED
174: );
175: ad_ctx_ddl.optimize_index (
176: idx_name => G_CONTRACT_VERS_INDEX,
177: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,

Line 175: ad_ctx_ddl.optimize_index (

171: idx_name => G_CONTRACTS_ALL_INDEX,
172: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,
173: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED
174: );
175: ad_ctx_ddl.optimize_index (
176: idx_name => G_CONTRACT_VERS_INDEX,
177: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,
178: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED
179: );

Line 177: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,

173: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED
174: );
175: ad_ctx_ddl.optimize_index (
176: idx_name => G_CONTRACT_VERS_INDEX,
177: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,
178: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED
179: );
180:
181: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 178: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED

174: );
175: ad_ctx_ddl.optimize_index (
176: idx_name => G_CONTRACT_VERS_INDEX,
177: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,
178: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED
179: );
180:
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182: