DBA Data[Home] [Help]

APPS.OTA_LEARNER_ENROLL_SS dependencies on OTA_TDB_BUS

Line 1244: ota_tdb_bus.check_unique_booking

1240: -- as a row exists for delegate, for this event
1241: null;
1242: ELSE
1243: IF p_person_id IS NOT NULL THEN
1244: ota_tdb_bus.check_unique_booking
1245: (p_customer_id => ''
1246: ,p_organization_id => l_person_details.organization_id
1247: ,p_event_id => p_event_id
1248: ,p_delegate_person_id => p_person_id

Line 1252: ota_tdb_bus.check_unique_booking

1248: ,p_delegate_person_id => p_person_id
1249: ,p_delegate_contact_id => ''
1250: ,p_booking_id => '');
1251: ELSIF p_delegate_contact_id IS NOT NULL THEN
1252: ota_tdb_bus.check_unique_booking
1253: (p_customer_id => l_ext_lrnr_details.customer_id
1254: ,p_organization_id => ''
1255: ,p_event_id => p_event_id
1256: ,p_delegate_person_id => ''

Line 1416: IF ota_tdb_bus2.other_bookings_clash(

1412: ,p_business_group_id => ota_general.get_business_group_id);
1413:
1414: l_booking_status_type_id := l_booking_status_row.booking_status_type_id;
1415:
1416: IF ota_tdb_bus2.other_bookings_clash(
1417: p_delegate_person_id => p_person_id
1418: -- Modified for External Learner Support
1419: -- ,p_delegate_contact_id=> ''
1420: ,p_delegate_contact_id=> p_delegate_contact_id