Overview of Hotel Reservation System PSP Sample
-----------------------------------------------------
This Sample illustrates the implementation of a simple Hotel Reservation System application
using PSPs.

The following functionalities of Hotel Reservation System are provided in this Sample :-
   Hotel Information Enquiry like Room Rates, Room Types, Facilities available etc
   Room Reservation and Cancellation for Hotels.
   Addition of new hotels to the list of available hotels.
   Hotel Information Modification like modification of Room Rates, Room Types etc

Steps in the Sample :
---------------------

  1) Invoke the application by opening the main page, a HTML page is displayed listing all the hotels
      and their information and buttons which allows to perform the functions : Get Hotel Information,
      Reservation/Cancellation, Update Hotel Information and Add a New Hotel. Select the desired
      buttons to perform the respective operations.

Description of Sample Files :
-----------------------------
The sample is provided as a zip file. This zip file contains all the files required for the sample.
It contains the following files:

    1) Install.html                                  - The steps to install the HRS application PSPs in the Oracle Database
    2) Readme.html                                - This file
    3) Main.psp                                     - Main page of the application.
    4) Bottom.psp                                 -  Source for  the  bottom frame of the main page.
    5) Left.psp                                       - Source for the left frame of the main page.
    6) Top.psp                                       - Source for the top frame of the main page.
    7) Hrs_Error_Page.psp                    - Error page of the application.
    8) Hotel_Info_View.psp                  - Displays the list of all the hotels in the right frame of the main page.
    9) Hotel_Info_Mid.psp                    - Displays the options to view the Hotel Details.
  10) Hotel_Details.psp                        - Displays the hotel details for the Hotel selected.
  11) Room_Availability_Details.psp  - Displays the Room Availability details for the Hotel selected.
  12) Add_New.psp                             - Form to enter details of New Hotel to be added.
  13) Hotel_Res_Mid.psp                    - Displays the options for Reservation/Cancellation.
  14) Cancel.psp                                   - Perfoms cancellations of the selected booking(s).
  15) Hotel_Bookings_View.psp         - This page displays the form for Reservation or Cancellation based on the input.
  16) Update_Mid.psp                        - Displays the options for Updating Hotel Information.
  17) Room_Rates.psp                        - Displays the Room Rates of the Hotel selected and allows updating the details.
  18) Room_Avail.psp                        - Displays the Room Availability details and allows updation of the same.
  19) New_Room.psp                         - Form to enter new Room Type for a Hotel selected.
  20) Hrs_Logo.gif                               - Logo displayed on the main page of the Application

The steps in running the sample in iAS environment is explained below :

Running the sample using Oracle iAS:
--------------------------------------

     Step 1. Install the PSP onto the Oracle database using the instructions in the Install.txt

     Step 2. On the Application Server machine where iAS is installed, create a Database Access
                 Descriptor(DAD) to connect to the schema where the PSP is installed in Step 1.

                 Note: For details on creating DADs, refer to the document "Using mod_plsql"
                          on the Documentation Library CD-ROM of iAS software.

     Step 3. After creating the DAD, access the page by using a URL like:
                 http://<ipaddress>:<Port>/<virtual_path>/<dadname>/<PL/SQL procedure name>
                 where,
                    <ipaddress>      -> is the ip-address of the machine on which iAS is setup
                    <Port>              -> is the port on which iAS http listener is setup to run
                                                 (refer to file $IAS_HOME/Apache/Apache/conf/httpds.conf)
                    <virtual_path>   -> is the prefix defined for the PL/SQL module
                                                  (refer to file $IAS_HOME/Apache/modplsql/cfg/plsql.conf)
                    <dadname>       -> is the name of the DAD created in Step 2.

                 Example:
                 http://152.69.168.209:7890/pls/travel/main