1406: l_idx_mem := FND_PROFILE.value('HZ_DQM_INDEX_MEMORY');
1407: ELSE
1408: BEGIN
1409: SELECT PAR_VALUE INTO l_idx_mem
1410: FROM CTX_PARAMETERS
1411: WHERE PAR_NAME = 'MAX_INDEX_MEMORY';
1412: EXCEPTION
1413: WHEN NO_DATA_FOUND THEN
1414: BEGIN
1412: EXCEPTION
1413: WHEN NO_DATA_FOUND THEN
1414: BEGIN
1415: SELECT PAR_VALUE INTO l_idx_mem
1416: FROM CTX_PARAMETERS
1417: WHERE PAR_NAME = 'DEFAULT_INDEX_MEMORY';
1418: EXCEPTION
1419: WHEN NO_DATA_FOUND THEN
1420: l_idx_mem := '0';
1451: l_idx_mem := FND_PROFILE.value('HZ_DQM_INDEX_MEMORY');
1452: ELSE
1453: BEGIN
1454: SELECT PAR_VALUE INTO l_idx_mem
1455: FROM CTX_PARAMETERS
1456: WHERE PAR_NAME = 'MAX_INDEX_MEMORY';
1457: EXCEPTION
1458: WHEN NO_DATA_FOUND THEN
1459: BEGIN
1457: EXCEPTION
1458: WHEN NO_DATA_FOUND THEN
1459: BEGIN
1460: SELECT PAR_VALUE INTO l_idx_mem
1461: FROM CTX_PARAMETERS
1462: WHERE PAR_NAME = 'DEFAULT_INDEX_MEMORY';
1463: EXCEPTION
1464: WHEN NO_DATA_FOUND THEN
1465: l_idx_mem := '0';