64: l_idx_mem := FND_PROFILE.value('HZ_DQM_INDEX_MEMORY');
65: ELSE
66: BEGIN
67: SELECT PAR_VALUE INTO l_idx_mem
68: FROM CTX_PARAMETERS
69: WHERE PAR_NAME = 'MAX_INDEX_MEMORY';
70: EXCEPTION
71: WHEN NO_DATA_FOUND THEN
72: BEGIN
70: EXCEPTION
71: WHEN NO_DATA_FOUND THEN
72: BEGIN
73: SELECT PAR_VALUE INTO l_idx_mem
74: FROM CTX_PARAMETERS
75: WHERE PAR_NAME = 'DEFAULT_INDEX_MEMORY';
76: EXCEPTION
77: WHEN NO_DATA_FOUND THEN
78: l_idx_mem := '0';