APPS.OKC_REP_CONTRACT_SEARCH_PVT dependencies on OKC_REP_CONTRACT_SEARCH_PVT

Line 1: PACKAGE BODY okc_rep_contract_search_pvt AS

1: PACKAGE BODY okc_rep_contract_search_pvt AS
2: /* $Header: OKCVREPSRCHB.pls 120.1 2005/08/22 10:01:22 dzima noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REP_CONTRACT_SEARCH_PVT';

3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REP_CONTRACT_SEARCH_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := 'OKC';
9: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
10:
11: -- Contract Statuses

Line 76: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index');

72: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
73: FND_LOG.STRING(
74: FND_LOG.LEVEL_PROCEDURE,
75: G_MODULE||l_api_name,
76: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index');
77: END IF;
78:
79: -- Standard call to check for call compatibility.
80: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 99: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.syncronize_text_index');

95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(
97: FND_LOG.LEVEL_PROCEDURE,
98: G_MODULE||l_api_name,
99: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.syncronize_text_index');
100: END IF;
101: EXCEPTION
102: WHEN OTHERS THEN
103: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 156: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');

152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(
154: FND_LOG.LEVEL_PROCEDURE,
155: G_MODULE||l_api_name,
156: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');
157: END IF;
158:
159: -- Standard call to check for call compatibility.
160: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 187: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');

183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING(
185: FND_LOG.LEVEL_PROCEDURE,
186: G_MODULE||l_api_name,
187: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');
188: END IF;
189: EXCEPTION
190: WHEN OTHERS THEN
191: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 241: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');

237: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.STRING(
239: FND_LOG.LEVEL_PROCEDURE,
240: G_MODULE||l_api_name,
241: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');
242: END IF;
243:
244: l_api_name := 'update_text_index_ctx';
245: l_api_version := 1.0;

Line 264: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');

260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
261: FND_LOG.STRING(
262: FND_LOG.LEVEL_PROCEDURE,
263: G_MODULE||l_api_name,
264: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');
265: END IF;
266:
267: EXCEPTION
268: WHEN OTHERS THEN

Line 306: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');

302: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.STRING(
304: FND_LOG.LEVEL_PROCEDURE,
305: G_MODULE||l_api_name,
306: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');
307: END IF;
308:
309: retcode := G_RETURN_CODE_ERROR;
310:

Line 331: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');

327: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.STRING(
329: FND_LOG.LEVEL_PROCEDURE,
330: G_MODULE||l_api_name,
331: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');
332: END IF;
333:
334: EXCEPTION
335: WHEN OTHERS THEN