aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_mapped_roomtype
Parameters
Name
Type
Mode
channel_code
text
IN
Definition
declare roomtype_id int; begin roomtype_id := (select id from room_type t where $1 = any(coalesce(t.channel_codes, array[t.code])) limit 1); return coalesce(roomtype_id, fn_intf_param('NBIS', 'DEFAULT_ROOMTYPE', null::int)); end;