aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_booking_items_gen_item_id
Parameters
Name
Type
Mode
Definition
BEGIN if (new.booking_seq is null) then new.booking_seq := (select coalesce(max(booking_seq),0)+1 from booking_items where booking_id = new.booking_id); end if; new.no_amend := coalesce(new.no_amend, false); new.no_cancel := coalesce(new.no_cancel, false); new.no_refund := coalesce(new.no_refund, false); RETURN NEW; END;