DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE dependencies on FND_PROFILE

Line 1167: IF upper ( nvl( FND_PROFILE.value('HZ_DQM_INDEX_BUILD_TYPE'), 'Optimal') ) = upper('Optimal')

1163: l_table_name VARCHAR2(255);
1164: BEGIN
1165: log ('--------------------------------------');
1166: -- If profile option is Optimal we FORCE A REBUILD.
1167: IF upper ( nvl( FND_PROFILE.value('HZ_DQM_INDEX_BUILD_TYPE'), 'Optimal') ) = upper('Optimal')
1168: THEN
1169: IF new_transformations_exist(p_entity)
1170: THEN
1171: log(' Chosen Profile Option is OPTIMAL');

Line 1352: l_realtime_sync_value := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y'); --4915282

1348: -- req_data will be null the first time, by default
1349: req_data := fnd_conc_global.request_data;
1350: IF (req_data IS NULL) THEN --Bug No: 4292425
1351: l_index_creation := nvl(p_index_creation,'PARALLEL');
1352: l_realtime_sync_value := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y'); --4915282
1353: IF p_num_workers IS NULL THEN
1354: l_num_workers:=1;
1355: ELSE
1356: l_num_workers := to_number(p_num_workers);

Line 1400: IF FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL') IS NOT NULL THEN

1396: generate_map_pkg;
1397: FOR I in 1..10 LOOP
1398: l_sub_requests(i) := 1;
1399: END LOOP;
1400: IF FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL') IS NOT NULL THEN
1401: l_num_prll := FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL');
1402: ELSE
1403: l_num_prll := NULL;
1404: END IF;

Line 1401: l_num_prll := FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL');

1397: FOR I in 1..10 LOOP
1398: l_sub_requests(i) := 1;
1399: END LOOP;
1400: IF FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL') IS NOT NULL THEN
1401: l_num_prll := FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL');
1402: ELSE
1403: l_num_prll := NULL;
1404: END IF;
1405: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN

Line 1405: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN

1401: l_num_prll := FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL');
1402: ELSE
1403: l_num_prll := NULL;
1404: END IF;
1405: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN
1406: l_idx_mem := FND_PROFILE.value('HZ_DQM_INDEX_MEMORY');
1407: ELSE
1408: BEGIN
1409: SELECT PAR_VALUE INTO l_idx_mem

Line 1406: l_idx_mem := FND_PROFILE.value('HZ_DQM_INDEX_MEMORY');

1402: ELSE
1403: l_num_prll := NULL;
1404: END IF;
1405: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN
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

Line 1447: l_profile_save := FND_PROFILE.save('HZ_DQM_ENABLE_REALTIME_SYNC','N','SITE'); -- Set sync method to BATCH. 4915282

1443: l_command = 'STAGE_NEW_TRANSFORMATIONS' OR
1444: l_command = 'CREATE_MISSING_INVALID_INDEXES' THEN
1445:
1446: IF ((l_command = 'STAGE_ALL_DATA' OR l_command = 'STAGE_NEW_TRANSFORMATIONS') AND l_realtime_sync_value <> 'N') THEN
1447: l_profile_save := FND_PROFILE.save('HZ_DQM_ENABLE_REALTIME_SYNC','N','SITE'); -- Set sync method to BATCH. 4915282
1448: END IF;
1449:
1450: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN
1451: l_idx_mem := FND_PROFILE.value('HZ_DQM_INDEX_MEMORY');

Line 1450: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN

1446: IF ((l_command = 'STAGE_ALL_DATA' OR l_command = 'STAGE_NEW_TRANSFORMATIONS') AND l_realtime_sync_value <> 'N') THEN
1447: l_profile_save := FND_PROFILE.save('HZ_DQM_ENABLE_REALTIME_SYNC','N','SITE'); -- Set sync method to BATCH. 4915282
1448: END IF;
1449:
1450: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN
1451: l_idx_mem := FND_PROFILE.value('HZ_DQM_INDEX_MEMORY');
1452: ELSE
1453: BEGIN
1454: SELECT PAR_VALUE INTO l_idx_mem

Line 1451: l_idx_mem := FND_PROFILE.value('HZ_DQM_INDEX_MEMORY');

1447: l_profile_save := FND_PROFILE.save('HZ_DQM_ENABLE_REALTIME_SYNC','N','SITE'); -- Set sync method to BATCH. 4915282
1448: END IF;
1449:
1450: IF FND_PROFILE.value('HZ_DQM_INDEX_MEMORY') IS NOT NULL THEN
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

Line 1470: IF FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL') IS NOT NULL THEN

1466: END;
1467: END;
1468: END IF;
1469:
1470: IF FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL') IS NOT NULL THEN
1471: l_num_prll := FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL');
1472: ELSE
1473: l_num_prll := NULL;
1474: END IF;

Line 1471: l_num_prll := FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL');

1467: END;
1468: END IF;
1469:
1470: IF FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL') IS NOT NULL THEN
1471: l_num_prll := FND_PROFILE.value('HZ_DQM_INDEX_PARALLEL');
1472: ELSE
1473: l_num_prll := NULL;
1474: END IF;
1475:

Line 2436: l_profile_save := FND_PROFILE.save('HZ_DQM_ENABLE_REALTIME_SYNC',l_realtime_sync_value,'SITE');

2432: END IF;
2433: END IF;
2434: CLOSE c_sync;
2435: END IF;
2436: l_profile_save := FND_PROFILE.save('HZ_DQM_ENABLE_REALTIME_SYNC',l_realtime_sync_value,'SITE');
2437: END IF;
2438: --End of 4915282
2439: END IF;
2440: --End of Bug No : 4292425