201:
202: BEGIN
203:
204: -- set rollback segment if profile option is set
205: fnd_profile.get('FA_LARGE_ROLLBACK_SEGMENT', l_rbs_name);
206:
207: if (l_rbs_name is not null) THEN
208: l_sql_stmt := 'SET TRANSACTION USE ROLLBACK SEGMENT ' || l_rbs_name;
209: execute immediate l_sql_stmt;
262: end if;
263:
264: end if;
265:
266: fnd_profile.get('FA_NUM_PARALLEL_REQUESTS', l_temp_char);
267: l_total_requests := nvl(l_temp_char, 1);
268:
269: if (g_log_level_rec.statement_level) then
270: fa_debug_pkg.add(l_calling_fn,'Total Requests', l_total_requests, p_log_level_rec => g_log_level_rec);