APPS.AS_GAR dependencies on V$PARAMETER

Line 232: select value into s from V$PARAMETER where name = 'sort_area_size';

228: sort_size := fnd_profile.value('AS_SORT_AREA_SIZE_FOR_TAP');
229: IF sort_size is not NULL and sort_size > 0 THEN
230: st := 'ALTER SESSION SET SORT_AREA_SIZE = ' || sort_size;
231: EXECUTE IMMEDIATE st;
232: select value into s from V$PARAMETER where name = 'sort_area_size';
233: AS_GAR.LOG( AS_GAR.G_SETAREASIZE || AS_GAR.G_PROCESS ||' Sort Area Size' || s);
234: END IF;
235:
236: hash_size := fnd_profile.value('AS_HASH_AREA_SIZE_FOR_TAP');

Line 240: select value into s from V$PARAMETER where name = 'hash_area_size';

236: hash_size := fnd_profile.value('AS_HASH_AREA_SIZE_FOR_TAP');
237: IF hash_size is not NULL and hash_size > 0 THEN
238: st := 'ALTER SESSION SET HASH_AREA_SIZE = ' || hash_size;
239: EXECUTE IMMEDIATE st;
240: select value into s from V$PARAMETER where name = 'hash_area_size';
241: AS_GAR.LOG( AS_GAR.G_SETAREASIZE || AS_GAR.G_PROCESS ||' Hash Area size' || s);
242: END IF;
243: END Set_Area_Sizes;
244: END AS_GAR;