10: -- Global package name
11: g_debug BOOLEAN := hr_utility.debug_enabled;
12: g_package CONSTANT VARCHAR2 (33) := 'hxt_time_collection.';
13: g_cache BOOLEAN := TRUE;
14: g_max_tc_allowed PLS_INTEGER := fnd_profile.VALUE ('HXT_BATCH_SIZE');
15:
16: -- Bug 12850901
17: g_intg_error VARCHAR2(4000) := fnd_message.get_string('HXC','HXC_PROJ_PAY_NO_OTLR');
18:
4024: FOR l_hol_rec IN g_hol_cur (i_start_date, i_end_date, i_hcl_id)
4025: LOOP
4026: hr_utility.set_location (l_proc, 20);
4027:
4028: IF ( fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y'
4029: OR fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL
4030: )
4031: THEN
4032: IF g_debug
4025: LOOP
4026: hr_utility.set_location (l_proc, 20);
4027:
4028: IF ( fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y'
4029: OR fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL
4030: )
4031: THEN
4032: IF g_debug
4033: THEN