APPS.OTA_ILEARNING dependencies on FND_PROFILE

Line 141: l_activity_id := FND_PROFILE.VALUE('OTA_ILEARNING_DEFAULT_ACTIVITY');

137:
138: if cur_get_activity_version_id%NOTFOUND then --if activity_version_id
139: close cur_get_activity_version_id;
140:
141: l_activity_id := FND_PROFILE.VALUE('OTA_ILEARNING_DEFAULT_ACTIVITY');
142: /*
143: open cur_get_activity_id;
144: fetch cur_get_activity_id into l_activity_id;
145: if cur_get_activity_id%NOTFOUND then --if activity_id

Line 764: l_default_event_owner_id := FND_PROFILE.VALUE('OTA_DEFAULT_EVENT_OWNER');

760: else
761: l_enrollment_end_date := p_enrollment_end_date;
762: end if; --if enrollment end date is null use event end date
763:
764: l_default_event_owner_id := FND_PROFILE.VALUE('OTA_DEFAULT_EVENT_OWNER');
765:
766: open cur_get_event_id;
767: fetch cur_get_event_id into l_event_id,l_event_ovn,l2_event_type,l2_course_end_date,
768: l2_enrollment_end_date,l_event_status,l_maximum_attendees,l_course_start_date_time,l_owner_id;

Line 1325: if ('Y' = FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_ACTIVE')) then

1321: close cur_waitlist_size;
1322:
1323:
1324: -- if Auto Waitlist Active profile is turned ON
1325: if ('Y' = FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_ACTIVE')) then
1326:
1327:
1328: select sysdate into l_sysdate from dual;
1329: l_diff_hours := l_course_start_date_time - l_sysdate ;

Line 1331: l_waitlist_hours := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');

1327:
1328: select sysdate into l_sysdate from dual;
1329: l_diff_hours := l_course_start_date_time - l_sysdate ;
1330: l_diff_hours := l_diff_hours * 24 ;
1331: l_waitlist_hours := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');
1332:
1333: IF l_diff_hours <= nvl(l_waitlist_hours,0) THEN -- if not enough time then
1334: -- update max attendees and notify Event Owner
1335: l_maximum_attendees := p_offering_max_attendees;