APPS.IEX_ATA_PUB dependencies on V$PARAMETER

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

480: sort_size := fnd_profile.value('IEX_SORT_AREA_SIZE_FOR_TAP');
481: IF sort_size is not NULL and sort_size > 0 THEN
482: st := 'ALTER SESSION SET SORT_AREA_SIZE = ' || sort_size;
483: EXECUTE IMMEDIATE st;
484: select value into s from V$PARAMETER where name = 'sort_area_size';
485: END IF;
486: IEX_DEBUG('Sort Area Size ' || s );
487:
488: hash_size := fnd_profile.value('IEX_HASH_AREA_SIZE_FOR_TAP');

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

488: hash_size := fnd_profile.value('IEX_HASH_AREA_SIZE_FOR_TAP');
489: IF hash_size is not NULL and hash_size > 0 THEN
490: st := 'ALTER SESSION SET HASH_AREA_SIZE = ' || hash_size;
491: EXECUTE IMMEDIATE st;
492: select value into s from V$PARAMETER where name = 'hash_area_size';
493: END IF;
494: IEX_DEBUG('Hash Area Size ' || s );
495: END Set_Area_Sizes;
496: