eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_CREATE_DYN_INDEX_PKG dependencies on GCS_CREATE_DYN_INDEX_PKG

Line 1: PACKAGE BODY GCS_CREATE_DYN_INDEX_PKG AS

1: PACKAGE BODY GCS_CREATE_DYN_INDEX_PKG AS
2: /* $Header: gcsdynidxb.pls 120.11 2007/06/28 12:22:21 vkosuri noship $ */
3:
4:
5: -- Private procedure

Line 203: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_INTERCO_ELM_TRX_U1');

199: BEGIN
200:
201: fnd_file.put_line(fnd_file.log, 'Starting to Drop Indices');
202: -- Drop indexes before we recreate them
203: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_INTERCO_ELM_TRX_U1');
204: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_HISTORICAL_RATES_U1');
205: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_TRANSLATION_GT_U1');
206: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_ENTRY_LINES_U1');
207: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_AD_TRIAL_BALANCES_U1');

Line 204: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_HISTORICAL_RATES_U1');

200:
201: fnd_file.put_line(fnd_file.log, 'Starting to Drop Indices');
202: -- Drop indexes before we recreate them
203: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_INTERCO_ELM_TRX_U1');
204: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_HISTORICAL_RATES_U1');
205: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_TRANSLATION_GT_U1');
206: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_ENTRY_LINES_U1');
207: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_AD_TRIAL_BALANCES_U1');
208: -- Bugfix 4281391 : Added dropping of index GCS_BAL_INTERFACE_T_U1

Line 205: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_TRANSLATION_GT_U1');

201: fnd_file.put_line(fnd_file.log, 'Starting to Drop Indices');
202: -- Drop indexes before we recreate them
203: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_INTERCO_ELM_TRX_U1');
204: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_HISTORICAL_RATES_U1');
205: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_TRANSLATION_GT_U1');
206: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_ENTRY_LINES_U1');
207: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_AD_TRIAL_BALANCES_U1');
208: -- Bugfix 4281391 : Added dropping of index GCS_BAL_INTERFACE_T_U1
209: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_BAL_INTERFACE_T_U1');

Line 206: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_ENTRY_LINES_U1');

202: -- Drop indexes before we recreate them
203: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_INTERCO_ELM_TRX_U1');
204: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_HISTORICAL_RATES_U1');
205: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_TRANSLATION_GT_U1');
206: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_ENTRY_LINES_U1');
207: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_AD_TRIAL_BALANCES_U1');
208: -- Bugfix 4281391 : Added dropping of index GCS_BAL_INTERFACE_T_U1
209: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_BAL_INTERFACE_T_U1');
210: fnd_file.put_line(fnd_file.log, 'Completed Dropping Indices');

Line 207: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_AD_TRIAL_BALANCES_U1');

203: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_INTERCO_ELM_TRX_U1');
204: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_HISTORICAL_RATES_U1');
205: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_TRANSLATION_GT_U1');
206: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_ENTRY_LINES_U1');
207: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_AD_TRIAL_BALANCES_U1');
208: -- Bugfix 4281391 : Added dropping of index GCS_BAL_INTERFACE_T_U1
209: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_BAL_INTERFACE_T_U1');
210: fnd_file.put_line(fnd_file.log, 'Completed Dropping Indices');
211:

Line 209: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_BAL_INTERFACE_T_U1');

205: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_TRANSLATION_GT_U1');
206: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_ENTRY_LINES_U1');
207: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_AD_TRIAL_BALANCES_U1');
208: -- Bugfix 4281391 : Added dropping of index GCS_BAL_INTERFACE_T_U1
209: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_BAL_INTERFACE_T_U1');
210: fnd_file.put_line(fnd_file.log, 'Completed Dropping Indices');
211:
212: index_list := rtrim(GCS_DYNAMIC_UTIL_PKG.index_col_list(collist), ', ');
213: IF index_list IS NOT NULL THEN

Line 366: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.begin', '<>');

362:
363: BEGIN
364:
365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
366: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.begin', '<>');
367: END IF;
368:
369: p_request_id := fnd_request.submit_request(
370: application => 'GCS',

Line 379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request', 'Submitted Request ID : ' || p_request_id);

375:
376: COMMIT;
377:
378: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request', 'Submitted Request ID : ' || p_request_id);
380: END IF;
381:
382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.end', '<>');

Line 383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.end', '<>');

379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request', 'Submitted Request ID : ' || p_request_id);
380: END IF;
381:
382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.end', '<>');
384: END IF;
385:
386: END;
387:

Line 388: END GCS_CREATE_DYN_INDEX_PKG;

384: END IF;
385:
386: END;
387:
388: END GCS_CREATE_DYN_INDEX_PKG;