TRIGGER: APPS.FND_DOCUMENTS_LT_PO_IBR

Source

Description

fnd_documents_lt_po_ibr
BEFORE INSERT ON          fnd_documents_long_text
FOR EACH ROW
/* $Header: poatt04t.sql 115.2 99/07/17 02:20:19 porting shi $ */

Type

BEFORE EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN

/* at some point, we need to check whether this document is for PO or not.
   if yes, we mark the record. otherwise, do nothing. AOL may implement a
   wrap package and call approriate product's procedure accordingly.
*/
  IF :new.app_source_version IS NULL THEN
    po_att.mark_record (:new.media_id, 'L', 'DOCUMENT', 'INSERT', 'PO_10SC');

  ELSIF :new.app_source_version = 'PO_R10' THEN
    :new.app_source_version := '';

  END IF;

END;