APPS.PSA_GVTMB dependencies on FND_FLEX_VALUE_SETS

Line 275: log ('Updating fnd_flex_value_sets');

271: END IF;
272:
273: IF (p_retcode = g_SUCCESS) THEN
274: BEGIN
275: log ('Updating fnd_flex_value_sets');
276: UPDATE fnd_flex_value_sets
277: SET format_type = 'C'
278: WHERE flex_value_set_name LIKE 'Reporting Attribute:%'
279: AND format_type = 'V';

Line 276: UPDATE fnd_flex_value_sets

272:
273: IF (p_retcode = g_SUCCESS) THEN
274: BEGIN
275: log ('Updating fnd_flex_value_sets');
276: UPDATE fnd_flex_value_sets
277: SET format_type = 'C'
278: WHERE flex_value_set_name LIKE 'Reporting Attribute:%'
279: AND format_type = 'V';
280: log ('Updated '||SQL%ROWCOUNT||' rows');

Line 285: l_location := 'update_fnd_flex_value_sets';

281: EXCEPTION
282: WHEN OTHERS THEN
283: p_retcode := g_FAILURE;
284: p_errbuf := SQLERRM;
285: l_location := 'update_fnd_flex_value_sets';
286: error (l_module_name, l_location, SQLCODE||':'||p_errbuf);
287: END;
288: END IF;
289: log ('LEAVE *** '||l_module_name||' ***');