aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_mapped_rateplan
Parameters
Name
Type
Mode
channel_code
text
IN
Definition
declare v_rateplan_id int; map_rate_details boolean; begin map_rate_details := fn_intf_param('NBIS', 'MAP_RATE_DETAILS', false) or is_interface_active('CHANNEX'); if map_rate_details then v_rateplan_id := (select rateplan_id from rate_details d where $1 = any(d.channel_codes) limit 1); else v_rateplan_id := (select p.id from rate_plan p where $1 = any(coalesce(p.channel_codes, array[p.code])) limit 1); end if; return coalesce(v_rateplan_id, fn_intf_param('NBIS', 'DEFAULT_RATEPLAN', null::int)); end;