APPS.IEX_ATA_PUB dependencies on V$PARAMETER

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

595: sort_size := fnd_profile.value('IEX_SORT_AREA_SIZE_FOR_TAP');
596: IF sort_size is not NULL and sort_size > 0 THEN
597: st := 'ALTER SESSION SET SORT_AREA_SIZE = ' || sort_size;
598: EXECUTE IMMEDIATE st;
599: select value into s from V$PARAMETER where name = 'sort_area_size';
600: END IF;
601: IEX_DEBUG('Sort Area Size ' || s );
602:
603: hash_size := fnd_profile.value('IEX_HASH_AREA_SIZE_FOR_TAP');

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

603: hash_size := fnd_profile.value('IEX_HASH_AREA_SIZE_FOR_TAP');
604: IF hash_size is not NULL and hash_size > 0 THEN
605: st := 'ALTER SESSION SET HASH_AREA_SIZE = ' || hash_size;
606: EXECUTE IMMEDIATE st;
607: select value into s from V$PARAMETER where name = 'hash_area_size';
608: END IF;
609: IEX_DEBUG('Hash Area Size ' || s );
610: END Set_Area_Sizes;
611: