Details

Grants

References

Dependencies

Code


NAME VALUE
OWNER CARTERAINVERSION_USER
OBJECT_NAME INSORDENINVERSION
SUBOBJECT_NAME null
OBJECT_ID 28311
DATA_OBJECT_ID null
OBJECT_TYPE TRIGGER
CREATED 11/06/15
LAST_DDL_TIME 11/06/15
TIMESTAMP 2015-06-11:22:56:09
STATUS VALID
TEMPORARY N
GENERATED N
SECONDARY N
NAMESPACE 3
EDITION_NAME null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
NAME OWNER TYPE OBJECT_ID STATUS TYPE_LINK
NAME OWNER TYPE OBJECT_ID STATUS TYPE_LINK
ORDENINVERSION CARTERAINVERSION_USER TABLE 28270 VALID TABLE
SEQ_ORDENINVERSION CARTERAINVERSION_USER SEQUENCE 28306 VALID SEQUENCE
TRIGGER insOrdenInversion BEFORE INSERT OR UPDATE ON OrdenInversion
FOR EACH ROW
BEGIN
IF :new.OrdenInversionId IS NULL THEN
	SELECT SEQ_OrdenInversion.NEXTVAL INTO :NEW.OrdenInversionId
	FROM DUAL;
END IF;

IF(:old.EstadoId <> 'P') THEN
 RAISE_APPLICATION_ERROR (-20000, 'Orden de Inversión no puede ser modificada');
END IF ;

END insOrdenInversion ;