TRIGGER: APPS.CZ_LOCALIZED_TEXTS_TP1

Source

Description

CZ_LOCALIZED_TEXTS_TP1
BEFORE INSERT
ON "CZ"."CZ_LOCALIZED_TEXTS#"
 REFERENCING OLD AS OLD NEW AS NEW
 FOR EACH ROW

Type

BEFORE EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE

  v_persistent_id   cz_localized_texts.persistent_intl_text_id%TYPE;

BEGIN
  IF(:NEW.PERSISTENT_INTL_TEXT_ID IS NULL )THEN
    :new.PERSISTENT_INTL_TEXT_ID:=:new.INTL_TEXT_ID;
  END IF;

  v_persistent_id := :new.PERSISTENT_INTL_TEXT_ID;
  v_persistent_id := cz_model_migration_pvt.get_persisten_intl_text_id(:new.MODEL_ID,:new.INTL_TEXT_ID,v_persistent_id);
  :new.PERSISTENT_INTL_TEXT_ID := v_persistent_id;
END;