APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_UTILITY

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

617: -- Prerequisite Validation Code
618: -- Can be overridden if p_override_prerequisites parameter is 'Y'
619: -- get booking status type
620:
621: ota_utility.get_booking_status_type(p_status_type_id=>p_booking_status_type_id,
622: p_type => l_incoming_status_type);
623:
624: If ( p_override_prerequisites = 'N' and nvl(l_incoming_status_type,'-1')<>'C'
625: and (p_delegate_person_id is not null or p_delegate_contact_id is not null) ) Then --Bug 4686100

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

2073:
2074: -- Prerequisite Validation Code
2075: -- Can be overridden if p_override_prerequisites parameter is 'Y'
2076: -- get booking status type
2077: ota_utility.get_booking_status_type(p_status_type_id=>p_booking_status_type_id,
2078: p_type => l_incoming_status_type);
2079:
2080: IF ( p_override_prerequisites = 'N' ) Then
2081: --Call local method

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

2639: --Send ntf to class owner if any enrollment has been cancelled
2640: --or deleted or class changed
2641: l_old_event_id := ota_tdb_shd.g_old_rec.event_id;
2642: l_auto_waitlist := fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
2643: l_waitlist_size := ota_utility.students_on_waitlist(l_old_event_id);
2644:
2645: if (l_auto_waitlist = 'Y' and l_waitlist_size > 0) then
2646:
2647: if(l_old_booking_status = 'P' or l_old_booking_status = 'A' ) then

Line 2937: ota_utility.get_booking_status_type( p_status_type_id => l_new_booking_status_type_id,

2933: --There is no necessity to lock the event and reset event status when player updates the enrollment status
2934: -- as enr status moves from P to A/E and hence, number of places in a class wont change
2935: --Also need to ensure event_id is locked whenever event_id is changed or number of places has changed
2936:
2937: ota_utility.get_booking_status_type( p_status_type_id => l_new_booking_status_type_id,
2938: p_type => l_new_booking_status_type) ;
2939:
2940: ota_utility.get_booking_status_type( p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
2941: p_type => l_old_booking_status_type) ;

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

2936:
2937: ota_utility.get_booking_status_type( p_status_type_id => l_new_booking_status_type_id,
2938: p_type => l_new_booking_status_type) ;
2939:
2940: ota_utility.get_booking_status_type( p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
2941: p_type => l_old_booking_status_type) ;
2942:
2943: if l_new_booking_status_type in ('A','P','E') and l_old_booking_status_type in ('A','P','E') AND
2944: l_new_event_id = ota_tdb_shd.g_old_rec.event_id

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

3234: OPEN booking_csr (p_booking_id);
3235: FETCH booking_csr INTO l_event_id,l_booking_status_type_id;
3236: CLOSE booking_csr;
3237:
3238: l_waitlist_size := ota_utility.students_on_waitlist(l_event_id);
3239:
3240: if(l_waitlist_size > 0) then
3241:
3242: OPEN booking_status_csr (l_booking_status_type_id);

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

3479: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then
3480: l_check_prereq := true;
3481: End If;
3482:
3483: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3484: p_type => l_old_status_type);
3485:
3486: ota_utility.get_booking_status_type(p_status_type_id => l_booking_status_type_id,
3487: p_type => l_new_status_type);

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

3482:
3483: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3484: p_type => l_old_status_type);
3485:
3486: ota_utility.get_booking_status_type(p_status_type_id => l_booking_status_type_id,
3487: p_type => l_new_status_type);
3488:
3489: If ( l_old_status_type = 'C' and l_new_status_type <> 'C' ) Then
3490: l_check_prereq := true;