DBA Data[Home] [Help]

APPS.OTA_EVENT_SWI dependencies on FND_PROFILE

Line 774: l_waitlist_hours := to_number(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));

770:
771:
772: begin
773: --
774: l_waitlist_hours := to_number(fnd_profile.value('OTA_AUTO_WAITLIST_DAYS'));
775: l_invalid_profile := false;
776: --
777: exception
778: when OTHERS then

Line 783: if fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE') = 'Y' then

779: l_invalid_profile := true;
780: --
781: end;
782:
783: if fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE') = 'Y' then
784:
785:
786: OPEN C_DATE;
787: FETCH C_DATE INTO l_CURRENT_DATE;

Line 794: fnd_profile.value('OTA_AUTO_WAITLIST_BOOKING_STATUS') is not null then

790: l_different_hours := l_event_date - l_current_date ;
791: l_different_hours := l_different_hours * 24 ;
792:
793: IF (not l_invalid_profile) and
794: fnd_profile.value('OTA_AUTO_WAITLIST_BOOKING_STATUS') is not null then
795: --
796: IF l_different_hours > nvl(l_waitlist_hours,0) THEN
797: business_group_id := OTA_GENERAL.get_business_group_id;
798: ota_tdb_waitlist_api.auto_enroll_from_waitlist (