APPS.HXT_TIME_GEN dependencies on FND_PROFILE

Line 157: l_request_id NUMBER := fnd_profile.VALUE ('CONC_REQUEST_ID');

153: l_batch_id hxt_timecards.batch_id%TYPE;
154: l_pre_bat_id hxt_timecards.batch_id%TYPE DEFAULT 0; --SPR C362 by BC
155: l_person_id hxt_timecards.for_person_id%TYPE; -- null to see new person in first loop
156: l_tim_id hxt_timecards.id%TYPE; -- to hold tim_id for same person
157: l_request_id NUMBER := fnd_profile.VALUE ('CONC_REQUEST_ID');
158: l_tim_cntr NUMBER := g_batch_size; -- set to create batch in first loop
159: l_retcode NUMBER;
160: l_errors EXCEPTION;
161: v_retcode NUMBER := 0; --SIR60

Line 854: IF ( fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y'

850: */
851: -- Derive time-out if holiday
852: IF l_hours IS NOT NULL
853: THEN
854: IF ( fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y'
855: OR fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL
856: )
857: THEN --SIR212
858: l_time_out := NULL; -- SPR C332 by BC

Line 855: OR fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL

851: -- Derive time-out if holiday
852: IF l_hours IS NOT NULL
853: THEN
854: IF ( fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y'
855: OR fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL
856: )
857: THEN --SIR212
858: l_time_out := NULL; -- SPR C332 by BC
859: l_time_in := NULL; -- SPR C332 by BC