TRIGGER: APPS.PO_NOTES_UBR

Source

Description

po_notes_ubr
/* $Header: poatt04t.sql 115.2 99/07/17 02:20:19 porting shi $ */
BEFORE UPDATE ON          po_notes
FOR EACH ROW

Type

BEFORE EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
  x_document_id NUMBER;

BEGIN

  IF :new.app_source_version IS NULL THEN
    po_att.mark_record (:new.po_note_id, 'L', 'NOTE', 'UPDATE', 'PO_R10');
  END IF;

  :new.app_source_version := '';
END;