sp_get_room_activity


Parameters

Name Type Mode
i_room_id integer IN (DEFAULT NULL)
more_guest boolean IN (DEFAULT false)
i_start_date date IN (DEFAULT NULL)
i_end_date date IN (DEFAULT NULL)
room_number t_room_number OUT
activity_type text OUT
activity_code integer OUT
room_id integer OUT
booking_id integer OUT
booking_item integer OUT
block_id integer OUT
register_id integer OUT
guest_id integer OUT
folio_id integer OUT
ooo_id integer OUT
name text OUT
start_date date OUT
end_date date OUT
is_more_guest boolean OUT

Definition