sp_get_room_available


Parameters

Name Type Mode
i_start_date date IN
i_end_date date IN
i_roomtype_id integer IN (DEFAULT NULL)
i_roomgroup_id integer IN (DEFAULT NULL)
avail_date date OUT
roomtype_id integer OUT
roomtype_code citext OUT
roomtype_name text OUT
roomtype_seq smallint OUT
roomgroup_id integer OUT
rsv integer OUT
block integer OUT
inh integer OUT
ooo integer OUT
avail integer OUT
total integer OUT
stop_sell boolean OUT

Definition