aonestar.public

Parameters

Name	Type	Mode
ota_code	text	IN
hotel_code	text	IN (DEFAULT NULL)
payment_method	text	IN (DEFAULT NULL)
roomtype_code	text	IN (DEFAULT NULL)
rateplan_code	text	IN (DEFAULT NULL)

Definition

declare 
   v_channel_id int;
   v_roomtype_id int;
   v_rateplan_id int;
begin
   if roomtype_code is not null then
      v_roomtype_id := fn_get_mapped_roomtype(roomtype_code);
   end if;   

   if rateplan_code is not null then
      v_rateplan_id := fn_get_mapped_rateplan(rateplan_code);
   end if;   

   -- Map channel id in channel_mapping table using specfied conditions 
   select des_channel_id
   from channel_mapping m
   where m.src_ota_code = ota_code
        and (m.src_hotel_code is null or m.src_hotel_code is not distinct from hotel_code) 
        and (m.src_payment is null or m.src_payment is not distinct from payment_method) 
        and (m.src_roomtype is null or m.src_roomtype is not distinct from v_roomtype_id) 
        and (m.src_rateplan is null or m.src_rateplan is not distinct from v_rateplan_id)
   into v_channel_id;

   -- if no maping found, find channel id from channel table using OTA Code
   if v_channel_id is null then
      v_channel_id := (select id from channel c where c.otacode = $1 limit 1);
   end if;   
 
   return v_channel_id;
end;

fn_get_mapped_channel

Parameters

Definition