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 AD_DDL

Line 40: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.drop_index, body, index_name);

36: NO_INDEX exception;
37: PRAGMA EXCEPTION_INIT (NO_INDEX, -1418);
38: BEGIN
39: body := 'DROP INDEX '||index_name;
40: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.drop_index, body, index_name);
41:
42: EXCEPTION
43: WHEN NO_INDEX THEN
44: fnd_file.put_line(fnd_file.log, 'Index to be dropped not found');

Line 142: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

138: l_table_owner) LOOP
139:
140: fnd_file.put_line(fnd_file.log, 'Starting to drop index: ' || v_indices.index_name);
141:
142: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
143: v_indices.owner,
144: ad_ddl.drop_index,
145: 'DROP INDEX ' || v_indices.index_name,
146: v_indices.index_name);

Line 144: ad_ddl.drop_index,

140: fnd_file.put_line(fnd_file.log, 'Starting to drop index: ' || v_indices.index_name);
141:
142: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
143: v_indices.owner,
144: ad_ddl.drop_index,
145: 'DROP INDEX ' || v_indices.index_name,
146: v_indices.index_name);
147:
148: fnd_file.put_line(fnd_file.log, 'Completed dropping of index');

Line 160: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, l_table_owner, ad_ddl.create_index, body, l_data_table || '_P');

156: END LOOP;
157: len := length(body);
158: body := substr(body, 1, len-2);
159: body:= body || ' )';
160: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, l_table_owner, ad_ddl.create_index, body, l_data_table || '_P');
161: ELSE
162: fnd_file.put_line(fnd_file.log, '<<<<<<<<<>>>>>>>>>>>>>>>>>>>>');
163: fnd_file.put_line(fnd_file.log, 'The indices and processing key on ' || l_data_table || ' were not regenerated since data already exists in the table.');
164: fnd_file.put_line(fnd_file.log, 'If you are ok with the analytical reporting setup, please ignore this warning. Otherwise, please undo the data in the tables');

Line 223: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_INTERCO_ELM_TRX_U1');

219: -- Recreate the indices
220: body:= ' CREATE UNIQUE INDEX GCS_INTERCO_ELM_TRX_U1 ON GCS_INTERCO_ELM_TRX (hierarchy_id, src_entity_id, target_entity_id,';
221: body:= body || 'cal_period_id, company_cost_center_org_id, intercompany_id, line_item_id';
222: body := body || index_list || ')';
223: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_INTERCO_ELM_TRX_U1');
224:
225: fnd_file.put_line(fnd_file.log, 'Generating GCS_HISTORICAL_RATES_U1');
226: body:= ' CREATE UNIQUE INDEX GCS_HISTORICAL_RATES_U1 ON GCS_HISTORICAL_RATES (hierarchy_id, entity_id, from_currency, to_currency, update_flag, ';
227: body:= body || 'cal_period_id, company_cost_center_org_id, intercompany_id, line_item_id';

Line 229: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_HISTORICAL_RATES_U1');

225: fnd_file.put_line(fnd_file.log, 'Generating GCS_HISTORICAL_RATES_U1');
226: body:= ' CREATE UNIQUE INDEX GCS_HISTORICAL_RATES_U1 ON GCS_HISTORICAL_RATES (hierarchy_id, entity_id, from_currency, to_currency, update_flag, ';
227: body:= body || 'cal_period_id, company_cost_center_org_id, intercompany_id, line_item_id';
228: body := body || index_list || ')';
229: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_HISTORICAL_RATES_U1');
230:
231: fnd_file.put_line(fnd_file.log, 'Generating GCS_TRANSLATION_GT_U1');
232: body:= ' CREATE UNIQUE INDEX GCS_TRANSLATION_GT_U1 ON GCS_TRANSLATION_GT (';
233: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';

Line 235: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_TRANSLATION_GT_U1');

231: fnd_file.put_line(fnd_file.log, 'Generating GCS_TRANSLATION_GT_U1');
232: body:= ' CREATE UNIQUE INDEX GCS_TRANSLATION_GT_U1 ON GCS_TRANSLATION_GT (';
233: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';
234: body := body || index_list || ')';
235: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_TRANSLATION_GT_U1');
236:
237: fnd_file.put_line(fnd_file.log, 'Generating GCS_ENTRY_LINES_U1');
238: body:= ' CREATE UNIQUE INDEX GCS_ENTRY_LINES_U1 ON GCS_ENTRY_LINES (entry_id, ';
239: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';

Line 242: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_ENTRY_LINES_U1');

238: body:= ' CREATE UNIQUE INDEX GCS_ENTRY_LINES_U1 ON GCS_ENTRY_LINES (entry_id, ';
239: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';
240: --Bugfix 5532657: Added entry_line_number to the unique index
241: body := body || index_list || ', entry_line_number)';
242: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_ENTRY_LINES_U1');
243:
244: fnd_file.put_line(fnd_file.log, 'Generating GCS_AD_TRIAL_BALANCES_U1');
245: body:= ' CREATE UNIQUE INDEX GCS_AD_TRIAL_BALANCES_U1 ON GCS_AD_TRIAL_BALANCES (ad_transaction_id, trial_balance_seq, ';
246: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';

Line 248: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_AD_TRIAL_BALANCES_U1');

244: fnd_file.put_line(fnd_file.log, 'Generating GCS_AD_TRIAL_BALANCES_U1');
245: body:= ' CREATE UNIQUE INDEX GCS_AD_TRIAL_BALANCES_U1 ON GCS_AD_TRIAL_BALANCES (ad_transaction_id, trial_balance_seq, ';
246: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';
247: body := body || index_list || ')';
248: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_AD_TRIAL_BALANCES_U1');
249:
250: fnd_file.put_line(fnd_file.log, 'Generating GCS_BAL_INTERFACE_T_U1');
251: Generate_Data_Sub_Index(collist);
252: body := ' CREATE UNIQUE INDEX GCS_BAL_INTERFACE_T_U1 ON GCS_BAL_INTERFACE_T ( ' || collist || ') ';

Line 253: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_BAL_INTERFACE_T_U1');

249:
250: fnd_file.put_line(fnd_file.log, 'Generating GCS_BAL_INTERFACE_T_U1');
251: Generate_Data_Sub_Index(collist);
252: body := ' CREATE UNIQUE INDEX GCS_BAL_INTERFACE_T_U1 ON GCS_BAL_INTERFACE_T ( ' || collist || ') ';
253: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_BAL_INTERFACE_T_U1');
254:
255: fnd_file.put_line(fnd_file.log, 'Completed Creation of Indices');
256:
257: fnd_file.put_line(fnd_file.log, 'Starting to Generate PL/SQL Packages');