"APPS"."EGO_MIRI_UNIQUE_ID_T"
BEFORE INSERT
ON "INV"."MTL_ITEM_REVISIONS_INTERFACE#" FOR EACH ROW
Type
BEFORE EACH ROW
Event
INSERT
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
DECLARE
l_date DATE := SYSDATE;
BEGIN
:NEW.LAST_UPDATE_DATE := l_date;
:NEW.CREATION_DATE := l_date;
IF :NEW.INTERFACE_TABLE_UNIQUE_ID IS NULL THEN
SELECT EGO_IMPORT_ROW_SEQ_S.NEXTVAL
INTO :NEW.INTERFACE_TABLE_UNIQUE_ID
FROM DUAL;
END IF;
END EGO_MIRI_UNIQUE_ID_T;