TRIGGER: APPS.WMS_WP_WAVE_HEADERS_UL

Source

Description

"APPS"."WMS_WP_WAVE_HEADERS_UL" 
 

instead of update on WMS_WP_WAVE_HEADERS_VL
referencing new as WAVE_HEADERS
for each row

Type

INSTEAD OF

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS WAVE_HEADERS OLD AS OLD

Body

begin
  WMS_WP_WAVE_HEADERS_PKG.UPDATE_ROW(
    X_WAVE_HEADER_ID => :WAVE_HEADERS.WAVE_HEADER_ID,
    X_ATTRIBUTE15 => :WAVE_HEADERS.ATTRIBUTE15,
    X_WAVE_SOURCE => :WAVE_HEADERS.WAVE_SOURCE,
    X_WAVE_STATUS => :WAVE_HEADERS.WAVE_STATUS,
    X_START_TIME => :WAVE_HEADERS.START_TIME,
    X_TYPE_ID => :WAVE_HEADERS.TYPE_ID,
    X_BATCH_ID => :WAVE_HEADERS.BATCH_ID,
    X_SHIP_TO_LOCATION_ID => :WAVE_HEADERS.SHIP_TO_LOCATION_ID,
    X_CUSTOMER_CLASS_ID => :WAVE_HEADERS.CUSTOMER_CLASS_ID,
    X_PULL_REPLENISHMENT_FLAG => :WAVE_HEADERS.PULL_REPLENISHMENT_FLAG,
    X_INITIATE_WAVE_PLANNING => :WAVE_HEADERS.INITIATE_WAVE_PLANNING,
    X_RELEASE_IMMEDIATELY => :WAVE_HEADERS.RELEASE_IMMEDIATELY,
    X_TABLE_NAME => :WAVE_HEADERS.TABLE_NAME,
    X_ADVANCED_CRITERIA => :WAVE_HEADERS.ADVANCED_CRITERIA,
    X_ORGANIZATION_ID => :WAVE_HEADERS.ORGANIZATION_ID,
    X_PICK_SEQ_RULE_ID => :WAVE_HEADERS.PICK_SEQ_RULE_ID,
    X_PICK_GROUPING_RULE_ID => :WAVE_HEADERS.PICK_GROUPING_RULE_ID,
    X_TRIP_ID => :WAVE_HEADERS.TRIP_ID,
    X_TRIP_STOP_ID => :WAVE_HEADERS.TRIP_STOP_ID,
    X_SHIP_METHOD_CODE => :WAVE_HEADERS.SHIP_METHOD_CODE,
    X_SHIPMENT_PRIORITY_CODE => :WAVE_HEADERS.SHIPMENT_PRIORITY_CODE,
    X_CARRIER_ID => :WAVE_HEADERS.CARRIER_ID,
    X_DELIVERY_ID => :WAVE_HEADERS.DELIVERY_ID,
    X_FROM_ORDER_HEADER_ID => :WAVE_HEADERS.FROM_ORDER_HEADER_ID,
    X_ORDER_TYPE_ID => :WAVE_HEADERS.ORDER_TYPE_ID,
    X_CUSTOMER_ID => :WAVE_HEADERS.CUSTOMER_ID,
    X_TASK_ID => :WAVE_HEADERS.TASK_ID,
    X_PROJECT_ID => :WAVE_HEADERS.PROJECT_ID,
    X_CATEGORY_SET_ID => :WAVE_HEADERS.CATEGORY_SET_ID,
    X_CATEGORY_ID => :WAVE_HEADERS.CATEGORY_ID,
    X_INVENTORY_ITEM_ID => :WAVE_HEADERS.INVENTORY_ITEM_ID,
    X_BACKORDERS_FLAG => :WAVE_HEADERS.BACKORDERS_FLAG,
    X_INCLUDE_PLANNED_LINES => :WAVE_HEADERS.INCLUDE_PLANNED_LINES,
    X_TASK_PLANNING_FLAG => :WAVE_HEADERS.TASK_PLANNING_FLAG,
    X_APPEND_DELIVERIES => :WAVE_HEADERS.APPEND_DELIVERIES,
    X_AUTO_CREATE_DELIVERY => :WAVE_HEADERS.AUTO_CREATE_DELIVERY,
    X_AUTO_CREATE_DELIVERY_CRITERI => :WAVE_HEADERS.AUTO_CREATE_DELIVERY_CRITERIA,
    X_TASK_PRIORITY => :WAVE_HEADERS.TASK_PRIORITY,
    X_DEFAULT_STAGE_SUBINVENTORY => :WAVE_HEADERS.DEFAULT_STAGE_SUBINVENTORY,
    X_DEFAULT_STAGE_LOCATOR_ID => :WAVE_HEADERS.DEFAULT_STAGE_LOCATOR_ID,
    X_DEFAULT_ALLOCATION_METHOD => :WAVE_HEADERS.DEFAULT_ALLOCATION_METHOD,
    X_WAVE_FIRMED_FLAG => :WAVE_HEADERS.WAVE_FIRMED_FLAG,
    X_WAVE_COMPLETION_TIME => :WAVE_HEADERS.WAVE_COMPLETION_TIME,
    X_ORDER_NAME => :WAVE_HEADERS.ORDER_NAME,
    X_CUSTOMER => :WAVE_HEADERS.CUSTOMER,
    X_ORDER_TYPE => :WAVE_HEADERS.ORDER_TYPE,
    X_CUSTOMER_CLASS => :WAVE_HEADERS.CUSTOMER_CLASS,
    X_SHIP_METHOD => :WAVE_HEADERS.SHIP_METHOD,
    X_CARRIER => :WAVE_HEADERS.CARRIER,
    X_SHIP_PRIORITY => :WAVE_HEADERS.SHIP_PRIORITY,
    X_DELIVERY => :WAVE_HEADERS.DELIVERY,
    X_TRIP => :WAVE_HEADERS.TRIP,
    X_TRIP_STOP => :WAVE_HEADERS.TRIP_STOP,
    X_ITEM => :WAVE_HEADERS.ITEM,
    X_ITEM_CATEGORY => :WAVE_HEADERS.ITEM_CATEGORY,
    X_PROJECT_NAME => :WAVE_HEADERS.PROJECT_NAME,
    X_TASK_NAME => :WAVE_HEADERS.TASK_NAME,
    X_SCHEDULED_DAYS => :WAVE_HEADERS.SCHEDULED_DAYS,
    X_SCHEDULED_HRS => :WAVE_HEADERS.SCHEDULED_HRS,
    X_DOCK_APPOINTMENT_DAYS => :WAVE_HEADERS.DOCK_APPOINTMENT_DAYS,
    X_DOCK_APPOINTMENT_HOURS => :WAVE_HEADERS.DOCK_APPOINTMENT_HOURS,
    X_PICK_SLIP_GROUP => :WAVE_HEADERS.PICK_SLIP_GROUP,
    X_RELEASE_SEQ_RULE => :WAVE_HEADERS.RELEASE_SEQ_RULE,
    X_STAGING_SUBINVENTORY => :WAVE_HEADERS.STAGING_SUBINVENTORY,
    X_STAGING_LOCATOR => :WAVE_HEADERS.STAGING_LOCATOR,
    X_CROSS_DOCK_CRITERIA => :WAVE_HEADERS.CROSS_DOCK_CRITERIA,
    X_PICK_SUBINVENTORY => :WAVE_HEADERS.PICK_SUBINVENTORY,
    X_PLANNING_CRITERIA => :WAVE_HEADERS.PLANNING_CRITERIA,
    X_PLANNING_CRITERIA_ID => :WAVE_HEADERS.PLANNING_CRITERIA_ID,
    X_REQUEST_ID => :WAVE_HEADERS.REQUEST_ID,
    X_ATTRIBUTE_CATEGORY => :WAVE_HEADERS.ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => :WAVE_HEADERS.ATTRIBUTE1,
    X_ATTRIBUTE2 => :WAVE_HEADERS.ATTRIBUTE2,
    X_ATTRIBUTE3 => :WAVE_HEADERS.ATTRIBUTE3,
    X_ATTRIBUTE4 => :WAVE_HEADERS.ATTRIBUTE4,
    X_ATTRIBUTE5 => :WAVE_HEADERS.ATTRIBUTE5,
    X_ATTRIBUTE6 => :WAVE_HEADERS.ATTRIBUTE6,
    X_ATTRIBUTE7 => :WAVE_HEADERS.ATTRIBUTE7,
    X_ATTRIBUTE8 => :WAVE_HEADERS.ATTRIBUTE8,
    X_ATTRIBUTE9 => :WAVE_HEADERS.ATTRIBUTE9,
    X_ATTRIBUTE10 => :WAVE_HEADERS.ATTRIBUTE10,
    X_ATTRIBUTE11 => :WAVE_HEADERS.ATTRIBUTE11,
    X_ATTRIBUTE12 => :WAVE_HEADERS.ATTRIBUTE12,
    X_ATTRIBUTE13 => :WAVE_HEADERS.ATTRIBUTE13,
    X_ATTRIBUTE14 => :WAVE_HEADERS.ATTRIBUTE14,
    X_WAVE_NAME => :WAVE_HEADERS.WAVE_NAME,
    X_WAVE_DESCRIPTION => :WAVE_HEADERS.WAVE_DESCRIPTION,
    X_LAST_UPDATE_DATE => :WAVE_HEADERS.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :WAVE_HEADERS.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :WAVE_HEADERS.LAST_UPDATE_LOGIN);
end UPDATE_ROW;