251: log ('ENTER *** '||l_module_name||' ***');
252:
253: IF (p_retcode = g_SUCCESS) THEN
254: BEGIN
255: log ('Updating columns in fnd_columns for Reporting Attributes');
256: UPDATE fnd_columns
257: SET flexfield_usage_code = 'K'
258: WHERE table_id = (SELECT table_id
259: FROM fnd_tables
252:
253: IF (p_retcode = g_SUCCESS) THEN
254: BEGIN
255: log ('Updating columns in fnd_columns for Reporting Attributes');
256: UPDATE fnd_columns
257: SET flexfield_usage_code = 'K'
258: WHERE table_id = (SELECT table_id
259: FROM fnd_tables
260: WHERE application_id = 101
264: EXCEPTION
265: WHEN OTHERS THEN
266: p_retcode := g_FAILURE;
267: p_errbuf := SQLERRM;
268: l_location := 'update_fnd_columns';
269: error (l_module_name, l_location, SQLCODE||':'||p_errbuf);
270: END;
271: END IF;
272: