maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_tg_noresequence_add()
Parameters
Name
Type
Mode
Definition
DECLARE BEGIN /* v20151229 RRB Adds a device to the tmp.noresequence table if it belongs to a customer of the FS Ignition product */ IF OLD.idmodeldevice IN (4,7,8) THEN IF OLD.idtechnicalaccount <> NEW.idtechnicalaccount THEN PERFORM 1 FROM technicalaccount ta JOIN client c ON ta.idclient = c.idclient JOIN staging.otccpre o ON c.clientcode = o.clientcode AND ta.idtechnicalaccount = NEW.idtechnicalaccount; IF FOUND THEN INSERT INTO tmp.noresequence SELECT NEW.serialnumber WHERE NOT EXISTS(SELECT 1 FROM tmp.noresequence WHERE serialnumber = NEW.serialnumber); END IF; END IF; END IF; IF OLD.idmodeldevice = 1 THEN IF OLD.idtechnicalaccount <> NEW.idtechnicalaccount THEN PERFORM 1 FROM technicalaccount ta JOIN client c ON ta.idclient = c.idclient JOIN staging.otccpre o ON c.clientcode = o.clientcode AND ta.idtechnicalaccount = NEW.idtechnicalaccount; IF FOUND THEN INSERT INTO tmp.gnxtof5 SELECT NEW.serialnumber WHERE NOT EXISTS(SELECT 1 FROM tmp.gnxtof5 WHERE serialnumber = NEW.serialnumber); INSERT INTO tmp.noresequence SELECT NEW.serialnumber WHERE NOT EXISTS(SELECT 1 FROM tmp.noresequence WHERE serialnumber = NEW.serialnumber); END IF; END IF; END IF; RETURN NULL; EXCEPTION WHEN OTHERS THEN RETURN NULL; END;