TRIGGER: APPS.WIP_DISCRETE_JOBS_BRD

Source

Description

wip_discrete_jobs_brd
/* $Header: wipt003.sql 115.1 99/07/16 16:49:46 porting sh $ */
BEFORE DELETE
ON wip_discrete_jobs
FOR EACH ROW

Type

BEFORE EACH ROW

Event

DELETE

Column

When

    old.job_type = 1
      AND old.status_type < 7  

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
  WIP_MRP_RELIEF.wip_discrete_jobs_proc(:old.primary_item_id,
                         :old.organization_id,
                         :old.last_update_date,
                         :old.last_updated_by,
                         :old.creation_date,
                         :old.created_by,
                         :new.net_quantity,         -- null but ok
                         :old.net_quantity,
                         :new.scheduled_completion_date, -- null but ok
                         :old.scheduled_completion_date,
                         :old.wip_entity_id,
                         :old.source_code,
                         :old.source_line_id,
                         :new.alternate_bom_designator,
                         :old.alternate_bom_designator,
                         :new.bom_revision_date,
                         :old.bom_revision_date,
                         :old.demand_class,
                         :old.demand_class,
                         :new.status_type,              -- null but ok
                         :old.status_type,
                         :new.quantity_completed +
			  :new.quantity_scrapped,       -- null but ok
                         :old.quantity_completed +
			  :old.quantity_scrapped,
                         :new.date_completed,           -- null but ok
                         :old.date_completed,
			 :new.project_id,
			 :old.project_id,
			 :new.task_id,
			 :old.task_id
                         );
END;