DBA Data[Home] [Help]

APPS.OTA_TDB_API_UPD2 dependencies on FND_PROFILE

Line 324: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));

320: -- bug# 5231470 Date format changed from DD-MON-YYYY to DD/MM/YYYY
321: l_hours_until_class_starts := 24*(to_date(to_char(l_course_start_date, 'DD/MM/YYYY')
322: ||''||l_course_start_time, 'DD/MM/YYYYHH24:MI') - SYSDATE);
323:
324: l_auto_waitlist_days := TO_NUMBER(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));
325: --
326: OPEN csr_get_waitlist_count(l_event_id);
327: FETCH csr_get_waitlist_count INTO l_waitlist_count;
328: IF (csr_get_waitlist_count%FOUND)