856: WHERE event_id = csr_events.event_id;
857:
858: hr_utility.set_location(' after bookings ', 342);
859:
860: per_events_api.delete_event(
861: p_event_id => csr_events.event_id ,
862: p_object_version_number => csr_events.object_version_number);
863:
864:
906: BEGIN
907: hr_utility.trace('Deleting the event :'||l_prev_event);
908: DELETE from per_bookings
909: WHERE event_id = l_prev_event;
910: per_events_api.delete_event(
911: p_event_id =>l_prev_event,
912: p_object_version_number =>l_prev_ovn);
913: EXCEPTION
914: WHEN Others THEN
924: BEGIN
925: hr_utility.trace('Outside loop.. deleting:'||l_prev_event);
926: DELETE from per_bookings
927: WHERE event_id = l_prev_event;
928: per_events_api.delete_event(
929: p_event_id =>l_prev_event,
930: p_object_version_number =>l_prev_ovn);
931: EXCEPTION
932: WHEN Others THEN