TRIGGER: APPS.PO_NOTE_REFERENCES_IBR

Source

Description

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

Type

BEFORE EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
  x_attached_doc_id NUMBER;

BEGIN

  IF :new.app_source_version IS NULL THEN
     IF :new.table_name = 'MTL_SYSTEM_ITEMS' THEN

         po_att.insert_attached_document_item (
     	   :new.creation_date,
      	   :new.created_by,
      	   :new.po_note_id,
           :new.table_name,
           :new.column_name,
           :new.foreign_id,
           :new.sequence_num,
           :new.attribute_category,
           :new.attribute1,
           :new.attribute2,
           :new.attribute3,
           :new.attribute4,
           :new.attribute5,
           :new.attribute6,
           :new.attribute7,
           :new.attribute8,
           :new.attribute9,
           :new.attribute10,
           :new.attribute11,
           :new.attribute12,
           :new.attribute13,
           :new.attribute14,
           :new.attribute15,
           'PO_R10',
           x_attached_doc_id );

    :new.attached_doc_id := x_attached_doc_id;

     ELSE

   	 po_att.insert_attached_document (
     	   :new.creation_date,
      	   :new.created_by,
      	   :new.po_note_id,
           :new.table_name,
           :new.column_name,
           :new.foreign_id,
           :new.sequence_num,
           :new.attribute_category,
           :new.attribute1,
           :new.attribute2,
           :new.attribute3,
           :new.attribute4,
           :new.attribute5,
           :new.attribute6,
           :new.attribute7,
           :new.attribute8,
           :new.attribute9,
           :new.attribute10,
           :new.attribute11,
           :new.attribute12,
           :new.attribute13,
           :new.attribute14,
           :new.attribute15,
           'PO_R10',
           x_attached_doc_id );

    :new.attached_doc_id := x_attached_doc_id;

     END IF;
  END IF;

  :new.app_source_version := '';

END;