<%@ page language="PL/SQL" %> <%@ page errorPage="Hrs_Error_Page.psp" %> <%@ plsql procedure="cancel" %> <%@ plsql parameter="p_hotel_id" type="NUMBER" default="NULL" %> <%@ plsql parameter="p_booking_id" type="NUMBER" default="NULL" %> <%! /** Overview : This PSP is part of the HRS Application sample. The PSP checks the input parameters and if the booking id is not passed displays an error message and allows the user to go back to the previous screen to select a booking record else deletes the corresponding hotel booking and generates an HTML page that displays if it is successful. In case of Exception, the error_page is displayed. Parameters : p_hotel_id - Parameter to pass the Hotel id p_booking_id - Parameter to pass the Booking id Modification History: Person Date Comments ------------------------------------------------------------- Pushkala 11-AUG-2000 Initial Sample **/ %> PSP Sample - Cancellation

<% /* If a booking record is selected for cancellation, Delete the corresponding record from Hotel_bookings */ BEGIN DELETE FROM hotel_bookings WHERE booking_id = p_booking_id; END; %>

Cancellation Successful !