173: -- --------------------------------------------------------
174: -- Delete all opi_edw_res_util_push_log records
175: -- --------------------------------------------------------
176: -- a). get schema name
177: IF fnd_installation.get_app_info( 'OPI', l_status,
178: l_industry, l_opi_schema) THEN
179: execute immediate 'truncate table '||l_opi_schema
180: ||'.opi_edw_res_util_push_log ';
181: END IF;
217: -- --------------------------------------------------------
218: -- Delete all opi_edw_res_util_push_log records
219: -- --------------------------------------------------------
220: -- a). get schema name
221: IF fnd_installation.get_app_info( 'OPI', l_status,
222: l_industry, l_opi_schema) THEN
223: execute immediate 'truncate table '||l_opi_schema
224: ||'.opi_edw_res_util_push_log ';
225: END IF;