APPS.HXT_TIME_CLOCK dependencies on FND_PROFILE

Line 822: l_max_batches NUMBER := fnd_profile.Value('HXT_BATCH_SIZE');

818: FUNCTION find_existing_batch(i_payroll_id IN NUMBER,
819: i_time_period_id IN NUMBER,
820: o_batch_id OUT NOCOPY NUMBER)RETURN NUMBER IS
821: --END SIR343
822: l_max_batches NUMBER := fnd_profile.Value('HXT_BATCH_SIZE');
823: l_retcode NUMBER DEFAULT 0;
824: BEGIN
825: --BEGIN GLOBAL
826: -- SELECT bat.batch_id

Line 913: IF (fnd_profile.value('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y' OR

909: BEGIN
910: FOR l_hol_rec IN l_hol_cur(i_start_date, i_end_date, i_hcl_id)
911: LOOP
912: --BEGIN SIR344
913: IF (fnd_profile.value('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y' OR
914: fnd_profile.value('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL) THEN
915: l_hours := l_hol_rec.hours;
916: l_time_out := NULL;
917: l_time_in := NULL;

Line 914: fnd_profile.value('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL) THEN

910: FOR l_hol_rec IN l_hol_cur(i_start_date, i_end_date, i_hcl_id)
911: LOOP
912: --BEGIN SIR344
913: IF (fnd_profile.value('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y' OR
914: fnd_profile.value('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL) THEN
915: l_hours := l_hol_rec.hours;
916: l_time_out := NULL;
917: l_time_in := NULL;
918: ELSE