APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_UTILITY

Line 472: ota_utility.get_booking_status_type(p_status_type_id=>p_booking_status_type_id,

468: -- Prerequisite Validation Code
469: -- Can be overridden if p_override_prerequisites parameter is 'Y'
470: -- get booking status type
471:
472: ota_utility.get_booking_status_type(p_status_type_id=>p_booking_status_type_id,
473: p_type => l_incoming_status_type);
474:
475: If ( p_override_prerequisites = 'N' and nvl(l_incoming_status_type,'-1')<>'C'
476: and (p_delegate_person_id is not null or p_delegate_contact_id is not null) ) Then --Bug 4686100

Line 1886: ota_utility.get_booking_status_type(p_status_type_id=>p_booking_status_type_id,

1882:
1883: -- Prerequisite Validation Code
1884: -- Can be overridden if p_override_prerequisites parameter is 'Y'
1885: -- get booking status type
1886: ota_utility.get_booking_status_type(p_status_type_id=>p_booking_status_type_id,
1887: p_type => l_incoming_status_type);
1888:
1889: IF ( p_override_prerequisites = 'N' ) Then
1890: --Call local method

Line 2438: l_waitlist_size := ota_utility.students_on_waitlist(l_old_event_id);

2434: --Send ntf to class owner if any enrollment has been cancelled
2435: --or deleted or class changed
2436: l_old_event_id := ota_tdb_shd.g_old_rec.event_id;
2437: l_auto_waitlist := fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
2438: l_waitlist_size := ota_utility.students_on_waitlist(l_old_event_id);
2439:
2440: if (l_auto_waitlist = 'Y' and l_waitlist_size > 0) then
2441:
2442: if(l_old_booking_status = 'P' or l_old_booking_status = 'A' ) then

Line 2993: l_waitlist_size := ota_utility.students_on_waitlist(l_event_id);

2989: OPEN booking_csr (p_booking_id);
2990: FETCH booking_csr INTO l_event_id,l_booking_status_type_id;
2991: CLOSE booking_csr;
2992:
2993: l_waitlist_size := ota_utility.students_on_waitlist(l_event_id);
2994:
2995: if(l_waitlist_size > 0) then
2996:
2997: OPEN booking_status_csr (l_booking_status_type_id);

Line 3237: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,

3233: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then
3234: l_check_prereq := true;
3235: End If;
3236:
3237: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3238: p_type => l_old_status_type);
3239:
3240: ota_utility.get_booking_status_type(p_status_type_id => l_booking_status_type_id,
3241: p_type => l_new_status_type);

Line 3240: ota_utility.get_booking_status_type(p_status_type_id => l_booking_status_type_id,

3236:
3237: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3238: p_type => l_old_status_type);
3239:
3240: ota_utility.get_booking_status_type(p_status_type_id => l_booking_status_type_id,
3241: p_type => l_new_status_type);
3242:
3243: If ( l_old_status_type = 'C' and l_new_status_type <> 'C' ) Then
3244: l_check_prereq := true;