DBA Data[Home] [Help]

APPS.HRI_OPL_MULTI_THREAD dependencies on FND_PROFILE

Line 17: g_debug_flag VARCHAR2(30) := NVL(fnd_profile.value('HRI_ENBL_DTL_LOG'),'N');

13: g_mthd_range_id NUMBER;
14: --
15: -- Variable for setting the debug mode
16: --
17: g_debug_flag VARCHAR2(30) := NVL(fnd_profile.value('HRI_ENBL_DTL_LOG'),'N');
18: g_program VARCHAR2(30) ;
19: g_mode VARCHAR2(30) := 'N';
20: g_mthd_action_id NUMBER;
21: g_error_request_id NUMBER;

Line 494: ELSIF NVL(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N') = 'Y' THEN

490: IF hr_general.chk_product_installed(800) = 'FALSE' THEN
491: --
492: g_mthd_action_array.foundation_hr_flag := 'Y';
493: --
494: ELSIF NVL(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N') = 'Y' THEN
495: --
496: g_mthd_action_array.foundation_hr_flag := 'Y';
497: --
498: ELSE

Line 624: g_chunk := NVL(fnd_profile.value('HRI_MTHD_CHUNK_SIZE'),20);

620: g_mthd_action_array.mthd_action_id);
621: --
622: -- Read the profile value HRI:Multithreading Chunk Size
623: --
624: g_chunk := NVL(fnd_profile.value('HRI_MTHD_CHUNK_SIZE'),20);
625: dbg('chunk size = '||g_chunk);
626: --
627: -- Create the dynamic SQL for calling the pre_processor of the program.
628: -- Based on the sql returned by the pre_process the ranges will be created.

Line 841: g_slave_count := NVL(fnd_profile.value('HRI_NO_THRDS_LAUNCH'),8);

837: dbg('Inside start_threads');
838: --
839: -- Read the profile value HRI:Number of Threads to Launch
840: --
841: g_slave_count := NVL(fnd_profile.value('HRI_NO_THRDS_LAUNCH'),8);
842: dbg('threads to launch = '||g_slave_count);
843: --
844: -- The number of threads to be launched is controlled by the profile option
845: -- HRI: Number of Threads to Launch. However in case the total