Parameters
| Name | Type | Mode |
|---|---|---|
| i_arrival | date | IN (DEFAULT NULL) |
| i_search_text | text | IN (DEFAULT NULL) |
| i_departure | date | IN (DEFAULT NULL) |
| i_stay_date | date | IN (DEFAULT NULL) |
| i_room_number | text | IN (DEFAULT NULL) |
| i_roomtype_id | integer | IN (DEFAULT NULL) |
| i_channel_name | text | IN (DEFAULT NULL) |
| i_vip_id | integer | IN (DEFAULT NULL) |
| i_member_code | text | IN (DEFAULT NULL) |
| i_company | text | IN (DEFAULT NULL) |
| i_nation_id | integer | IN (DEFAULT NULL) |
| i_rateplan_id | integer | IN (DEFAULT NULL) |
| i_carplate_no | text | IN (DEFAULT NULL) |