The following lines contain the word 'select', 'insert', 'update' or 'delete':
per_bookings_pkg.Insert_Row(X_Rowid => p_Rowid
,X_Booking_Id => p_Booking_Id
,X_Business_Group_Id => p_Business_Group_Id
,X_Person_Id => p_Person_Id
,X_Event_Id => p_Event_Id
,X_Message => p_Message
,X_Token => p_Token
,X_Comments => p_Comments
,X_Attribute_Category => p_Attribute_Category
,X_Attribute1 => p_Attribute1
,X_Attribute2 => p_Attribute2
,X_Attribute3 => p_Attribute3
,X_Attribute4 => p_Attribute4
,X_Attribute5 => p_Attribute5
,X_Attribute6 => p_Attribute6
,X_Attribute7 => p_Attribute7
,X_Attribute8 => p_Attribute8
,X_Attribute9 => p_Attribute9
,X_Attribute10 => p_Attribute10
,X_Attribute11 => p_Attribute11
,X_Attribute12 => p_Attribute12
,X_Attribute13 => p_Attribute13
,X_Attribute14 => p_Attribute14
,X_Attribute15 => p_Attribute15
,X_Attribute16 => p_Attribute16
,X_Attribute17 => p_Attribute17
,X_Attribute18 => p_Attribute18
,X_Attribute19 => p_Attribute19
,X_Attribute20 => p_Attribute20
,X_Primary_Interviewer_Flag => p_Primary_Interviewer_Flag
);
PROCEDURE update_per_bookings
(p_Rowid IN OUT NOCOPY VARCHAR2
,p_Booking_Id IN OUT NOCOPY NUMBER
,p_Business_Group_Id NUMBER
,p_Person_Id NUMBER
,p_Event_Id NUMBER
,p_Message VARCHAR2 default hr_api.g_varchar2
,p_Token VARCHAR2 default hr_api.g_varchar2
,p_Comments VARCHAR2 default hr_api.g_varchar2
,p_Attribute_Category VARCHAR2 default hr_api.g_varchar2
,p_Attribute1 VARCHAR2 default hr_api.g_varchar2
,p_Attribute2 VARCHAR2 default hr_api.g_varchar2
,p_Attribute3 VARCHAR2 default hr_api.g_varchar2
,p_Attribute4 VARCHAR2 default hr_api.g_varchar2
,p_Attribute5 VARCHAR2 default hr_api.g_varchar2
,p_Attribute6 VARCHAR2 default hr_api.g_varchar2
,p_Attribute7 VARCHAR2 default hr_api.g_varchar2
,p_Attribute8 VARCHAR2 default hr_api.g_varchar2
,p_Attribute9 VARCHAR2 default hr_api.g_varchar2
,p_Attribute10 VARCHAR2 default hr_api.g_varchar2
,p_Attribute11 VARCHAR2 default hr_api.g_varchar2
,p_Attribute12 VARCHAR2 default hr_api.g_varchar2
,p_Attribute13 VARCHAR2 default hr_api.g_varchar2
,p_Attribute14 VARCHAR2 default hr_api.g_varchar2
,p_Attribute15 VARCHAR2 default hr_api.g_varchar2
,p_Attribute16 VARCHAR2 default hr_api.g_varchar2
,p_Attribute17 VARCHAR2 default hr_api.g_varchar2
,p_Attribute18 VARCHAR2 default hr_api.g_varchar2
,p_Attribute19 VARCHAR2 default hr_api.g_varchar2
,p_Attribute20 VARCHAR2 default hr_api.g_varchar2
,p_Primary_Interviewer_Flag VARCHAR2 default null
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'update_per_bookings';
select rowid ROW_ID, b.*
from per_bookings b
where booking_id = p_Booking_Id;
savepoint update_per_bookings_swi;
per_bookings_pkg.Update_Row(X_Rowid => p_Rowid
,X_Booking_Id => p_Booking_Id
,X_Business_Group_Id => p_Business_Group_Id
,X_Person_Id => p_Person_Id
,X_Event_Id => p_Event_Id
,X_Message => p_Message
,X_Token => p_Token
,X_Comments => p_rec.Comments
,X_Attribute_Category => p_rec.Attribute_Category
,X_Attribute1 => p_rec.Attribute1
,X_Attribute2 => p_rec.Attribute2
,X_Attribute3 => p_rec.Attribute3
,X_Attribute4 => p_rec.Attribute4
,X_Attribute5 => p_rec.Attribute5
,X_Attribute6 => p_rec.Attribute6
,X_Attribute7 => p_rec.Attribute7
,X_Attribute8 => p_rec.Attribute8
,X_Attribute9 => p_rec.Attribute9
,X_Attribute10 => p_rec.Attribute10
,X_Attribute11 => p_rec.Attribute11
,X_Attribute12 => p_rec.Attribute12
,X_Attribute13 => p_rec.Attribute13
,X_Attribute14 => p_rec.Attribute14
,X_Attribute15 => p_rec.Attribute15
,X_Attribute16 => p_rec.Attribute16
,X_Attribute17 => p_rec.Attribute17
,X_Attribute18 => p_rec.Attribute18
,X_Attribute19 => p_rec.Attribute19
,X_Attribute20 => p_rec.Attribute20
,X_Primary_Interviewer_Flag => p_rec.Primary_Interviewer_Flag
);
rollback to update_per_bookings_swi;
rollback to update_per_bookings_swi;
end update_per_bookings;
PROCEDURE delete_per_bookings
(p_Booking_Id IN NUMBER
,p_return_status out nocopy varchar2
) is
l_Rowid VARCHAR2(30);
l_proc varchar2(72) := g_package ||'delete_per_bookings';
select rowid
from per_bookings
where booking_id = p_Booking_Id;
savepoint delete_per_bookings_swi;
per_bookings_pkg.Delete_Row(X_Rowid => l_Rowid);
rollback to delete_per_bookings_swi;
rollback to delete_per_bookings_swi;
end delete_per_bookings;