993: fetch getBookingRowid into l_rowId;
994: close getBookingRowid;
995: --
996: hr_utility.set_location('Row Id in Delete '||l_rowId,10);
997: per_bookings_pkg.Delete_Row(X_Rowid => l_rowId);
998: hr_utility.set_location(' After Row Id in Delete '||l_rowId,10);
999: --
1000: end if;
1001: --
1007: --
1008: hr_utility.set_location('Row Id '||l_rowId,10);
1009: hr_utility.set_location('Booking Id '||p_Booking_Id||'business Group Id '||p_Business_Group_Id||'event Id '||p_event_id,10);
1010: --
1011: PER_BOOKINGS_PKG.Update_Row(X_Rowid => l_rowId,
1012: X_Booking_Id => p_Booking_Id ,
1013: X_Business_Group_Id => p_Business_Group_Id,
1014: X_Person_Id => p_personId,
1015: X_Event_Id => p_event_id,
1046: close check_for_row_exsistance;
1047:
1048: if l_count = 0 then
1049:
1050: PER_BOOKINGS_PKG.Insert_Row(X_Rowid => l_Row_Id,
1051: X_Booking_Id => l_Booking_Id ,
1052: X_Business_Group_Id => p_Business_Group_Id,
1053: X_Person_Id => p_personId,
1054: X_Event_Id => pkg_event_id,