DBA Data[Home] [Help]

APPS.EAM_TEXT_INDEX_PVT dependencies on CTX_PARAMETERS

Line 619: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'

615:
616: l_rows_processed INTEGER;
617:
618: -- Limit the indexing memory in case the default parameter max value is higher.
619: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'
620: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'
621: l_Index_Memory_Max ctx_parameters.par_value%TYPE;
622:
623: l_idx_docid_count NUMBER;

Line 620: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'

616: l_rows_processed INTEGER;
617:
618: -- Limit the indexing memory in case the default parameter max value is higher.
619: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'
620: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'
621: l_Index_Memory_Max ctx_parameters.par_value%TYPE;
622:
623: l_idx_docid_count NUMBER;
624: l_idx_status VARCHAR2(256);

Line 621: l_Index_Memory_Max ctx_parameters.par_value%TYPE;

617:
618: -- Limit the indexing memory in case the default parameter max value is higher.
619: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'
620: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'
621: l_Index_Memory_Max ctx_parameters.par_value%TYPE;
622:
623: l_idx_docid_count NUMBER;
624: l_idx_status VARCHAR2(256);
625:

Line 777: FROM ctx_parameters

773: -- Determine index memory parameter value
774: --ctxsys.CTX_ADM.Set_Parameter ('MAX_INDEX_MEMORY', l_Index_Memory);
775: BEGIN
776: SELECT par_value INTO l_Index_Memory_Max
777: FROM ctx_parameters
778: WHERE par_name = 'MAX_INDEX_MEMORY';
779: EXCEPTION
780: WHEN no_data_found THEN
781: Log_Line (l_api_name || ': Error: MAX_INDEX_MEMORY parameter record not found.', FND_LOG.LEVEL_EVENT, l_api_name);

Line 1344: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'

1340:
1341: l_rows_processed INTEGER;
1342:
1343: -- Limit the indexing memory in case the default parameter max value is higher.
1344: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'
1345: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'
1346: l_Index_Memory_Max ctx_parameters.par_value%TYPE;
1347:
1348: l_idx_docid_count NUMBER;

Line 1345: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'

1341: l_rows_processed INTEGER;
1342:
1343: -- Limit the indexing memory in case the default parameter max value is higher.
1344: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'
1345: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'
1346: l_Index_Memory_Max ctx_parameters.par_value%TYPE;
1347:
1348: l_idx_docid_count NUMBER;
1349: l_idx_status VARCHAR2(256);

Line 1346: l_Index_Memory_Max ctx_parameters.par_value%TYPE;

1342:
1343: -- Limit the indexing memory in case the default parameter max value is higher.
1344: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'
1345: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'
1346: l_Index_Memory_Max ctx_parameters.par_value%TYPE;
1347:
1348: l_idx_docid_count NUMBER;
1349: l_idx_status VARCHAR2(256);
1350:

Line 1502: FROM ctx_parameters

1498: -- Determine index memory parameter value
1499: --ctxsys.CTX_ADM.Set_Parameter ('MAX_INDEX_MEMORY', l_Index_Memory);
1500: BEGIN
1501: SELECT par_value INTO l_Index_Memory_Max
1502: FROM ctx_parameters
1503: WHERE par_name = 'MAX_INDEX_MEMORY';
1504: EXCEPTION
1505: WHEN no_data_found THEN
1506: Log_Line (l_api_name || ': Error: MAX_INDEX_MEMORY parameter record not found.', FND_LOG.LEVEL_EVENT, l_api_name);