75: fnd_file.put_line(fnd_file.log, 'Beginning of Generate EPB Index');
76:
77: SELECT epb_table_name
78: INTO l_data_table
79: FROM gcs_system_options;
80:
81: SELECT oracle_username
82: INTO l_table_owner
83: FROM fnd_oracle_userid
258:
259: -- Check if system options is set
260: SELECT nvl(fch_global_vs_combo_id, -1)
261: INTO l_sys_option
262: FROM gcs_system_options;
263:
264: IF l_sys_option <> -1 THEN
265: fnd_file.put_line(fnd_file.log, 'Generating Dimension Transfer');
266: GCS_BUILD_EPB_DIM_TR_PKG.build_epb_dimtr_pkg;
268:
269: --Bugfix 5498824: Removing the reference to ln_item_hierarchy_obj_id
270: SELECT nvl(epb_table_name, 'INVALID')
271: INTO l_epb_table
272: FROM gcs_system_options;
273:
274: IF ( l_epb_table <> 'INVALID' ) THEN
275: fnd_file.put_line(fnd_file.log, 'Generating EPB/FCH Data Transfer');
276: GCS_BUILD_EPB_DATA_TR_PKG.build_epb_datatr_pkg;