59:
60: log('---------------------------------------------------');
61: log('Calling create_initial_prefs');
62:
63: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN
64: l_idx_mem := FND_PROFILE.value('HZ_DQM_INDEX_MEMORY');
65: ELSE
66: BEGIN
67: SELECT PAR_VALUE INTO l_idx_mem
60: log('---------------------------------------------------');
61: log('Calling create_initial_prefs');
62:
63: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN
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
79: END;
80: END;
81: END IF;
82:
83: IF FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL') IS NOT NULL THEN
84: l_num_prll := FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL');
85: ELSE
86: l_num_prll := NULL;
87: END IF;
80: END;
81: END IF;
82:
83: IF FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL') IS NOT NULL THEN
84: l_num_prll := FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL');
85: ELSE
86: l_num_prll := NULL;
87: END IF;
88: