APPS.HXT_TIME_GEN dependencies on FND_PROFILE

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

250: l_batch_id hxt_timecards.batch_id%TYPE;
251: l_pre_bat_id hxt_timecards.batch_id%TYPE DEFAULT 0; --SPR C362 by BC
252: l_person_id hxt_timecards.for_person_id%TYPE; -- null to see new person in first loop
253: l_tim_id hxt_timecards.id%TYPE; -- to hold tim_id for same person
254: l_request_id NUMBER := fnd_profile.VALUE ('CONC_REQUEST_ID');
255: l_tim_cntr NUMBER := g_batch_size; -- set to create batch in first loop
256: l_retcode NUMBER;
257: l_errors EXCEPTION;
258: v_retcode NUMBER := 0; --SIR60

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

983: */
984: -- Derive time-out if holiday
985: IF l_hours IS NOT NULL
986: THEN
987: IF ( fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y'
988: OR fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL
989: )
990: THEN --SIR212
991: l_time_out := NULL; -- SPR C332 by BC

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

984: -- Derive time-out if holiday
985: IF l_hours IS NOT NULL
986: THEN
987: IF ( fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') = 'Y'
988: OR fnd_profile.VALUE ('HXT_HOL_HOURS_FROM_HOL_CAL') IS NULL
989: )
990: THEN --SIR212
991: l_time_out := NULL; -- SPR C332 by BC
992: l_time_in := NULL; -- SPR C332 by BC