APPS.WMS_WP_WAVE_HEADERS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_WAVE_HEADER_ID in NUMBER,
  X_ATTRIBUTE15 in VARCHAR2,
  X_WAVE_SOURCE in VARCHAR2,
  X_WAVE_STATUS in VARCHAR2,
  X_START_TIME in DATE,
  X_TYPE_ID in VARCHAR2,
  X_BATCH_ID in NUMBER,
  X_SHIP_TO_LOCATION_ID in NUMBER,
  X_CUSTOMER_CLASS_ID in VARCHAR2,
  X_PULL_REPLENISHMENT_FLAG in VARCHAR2,
  X_INITIATE_WAVE_PLANNING in VARCHAR2,
  X_RELEASE_IMMEDIATELY in VARCHAR2,
  X_TABLE_NAME in VARCHAR2,
  X_ADVANCED_CRITERIA in VARCHAR2,
  X_ORGANIZATION_ID in NUMBER,
  X_PICK_SEQ_RULE_ID in NUMBER,
  X_PICK_GROUPING_RULE_ID in NUMBER,
  X_TRIP_ID in NUMBER,
  X_TRIP_STOP_ID in NUMBER,
  X_SHIP_METHOD_CODE in VARCHAR2,
  X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
  X_CARRIER_ID in NUMBER,
  X_DELIVERY_ID in NUMBER,
  X_FROM_ORDER_HEADER_ID in NUMBER,
  X_ORDER_TYPE_ID in NUMBER,
  X_CUSTOMER_ID in NUMBER,
  X_TASK_ID in NUMBER,
  X_PROJECT_ID in NUMBER,
  X_CATEGORY_SET_ID in NUMBER,
  X_CATEGORY_ID in NUMBER,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_BACKORDERS_FLAG in VARCHAR2,
  X_INCLUDE_PLANNED_LINES in VARCHAR2,
  X_TASK_PLANNING_FLAG in VARCHAR2,
  X_APPEND_DELIVERIES in VARCHAR2,
  X_AUTO_CREATE_DELIVERY in VARCHAR2,
  X_AUTO_CREATE_DELIVERY_CRITERI in VARCHAR2,
  X_TASK_PRIORITY in NUMBER,
  X_DEFAULT_STAGE_SUBINVENTORY in VARCHAR2,
  X_DEFAULT_STAGE_LOCATOR_ID in NUMBER,
  X_DEFAULT_ALLOCATION_METHOD in VARCHAR2,
  X_WAVE_FIRMED_FLAG in VARCHAR2,
  X_WAVE_COMPLETION_TIME in DATE,
  X_ORDER_NAME in VARCHAR2,
  X_CUSTOMER in VARCHAR2,
  X_ORDER_TYPE in VARCHAR2,
  X_CUSTOMER_CLASS in VARCHAR2,
  X_SHIP_METHOD in VARCHAR2,
  X_CARRIER in VARCHAR2,
  X_SHIP_PRIORITY in VARCHAR2,
  X_DELIVERY in VARCHAR2,
  X_TRIP in VARCHAR2,
  X_TRIP_STOP in VARCHAR2,
  X_ITEM in VARCHAR2,
  X_ITEM_CATEGORY in VARCHAR2,
  X_PROJECT_NAME in VARCHAR2,
  X_TASK_NAME in VARCHAR2,
  X_SCHEDULED_DAYS in NUMBER,
  X_SCHEDULED_HRS in NUMBER,
  X_DOCK_APPOINTMENT_DAYS in NUMBER,
  X_DOCK_APPOINTMENT_HOURS in NUMBER,
  X_PICK_SLIP_GROUP in VARCHAR2,
  X_RELEASE_SEQ_RULE in VARCHAR2,
  X_STAGING_SUBINVENTORY in VARCHAR2,
  X_STAGING_LOCATOR in VARCHAR2,
  X_CROSS_DOCK_CRITERIA in VARCHAR2,
  X_PICK_SUBINVENTORY in VARCHAR2,
  X_PLANNING_CRITERIA in VARCHAR2,
  X_PLANNING_CRITERIA_ID in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_WAVE_NAME in VARCHAR2,
  X_WAVE_DESCRIPTION in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from WMS_WP_WAVE_HEADERS_B
    where WAVE_HEADER_ID = X_WAVE_HEADER_ID
    ;

Line: 105

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

Line: 289

  insert into WMS_WP_WAVE_HEADERS_TL (
    WAVE_HEADER_ID,
    WAVE_NAME,
    WAVE_DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_WAVE_HEADER_ID,
    X_WAVE_NAME,
    X_WAVE_DESCRIPTION,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from WMS_WP_WAVE_HEADERS_TL T
    where T.WAVE_HEADER_ID = X_WAVE_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 326

end INSERT_ROW;

Line: 417

  cursor c is select
      ATTRIBUTE15,
      WAVE_SOURCE,
      WAVE_STATUS,
      START_TIME,
      TYPE_ID,
      BATCH_ID,
      SHIP_TO_LOCATION_ID,
      CUSTOMER_CLASS_ID,
      PULL_REPLENISHMENT_FLAG,
      INITIATE_WAVE_PLANNING,
      RELEASE_IMMEDIATELY,
      TABLE_NAME,
      ADVANCED_CRITERIA,
      ORGANIZATION_ID,
      PICK_SEQ_RULE_ID,
      PICK_GROUPING_RULE_ID,
      TRIP_ID,
      TRIP_STOP_ID,
      SHIP_METHOD_CODE,
      SHIPMENT_PRIORITY_CODE,
      CARRIER_ID,
      DELIVERY_ID,
      FROM_ORDER_HEADER_ID,
      ORDER_TYPE_ID,
      CUSTOMER_ID,
      TASK_ID,
      PROJECT_ID,
      CATEGORY_SET_ID,
      CATEGORY_ID,
      INVENTORY_ITEM_ID,
      BACKORDERS_FLAG,
      INCLUDE_PLANNED_LINES,
      TASK_PLANNING_FLAG,
      APPEND_DELIVERIES,
      AUTO_CREATE_DELIVERY,
      AUTO_CREATE_DELIVERY_CRITERIA,
      TASK_PRIORITY,
      DEFAULT_STAGE_SUBINVENTORY,
      DEFAULT_STAGE_LOCATOR_ID,
      DEFAULT_ALLOCATION_METHOD,
      WAVE_FIRMED_FLAG,
      WAVE_COMPLETION_TIME,
      ORDER_NAME,
      CUSTOMER,
      ORDER_TYPE,
      CUSTOMER_CLASS,
      SHIP_METHOD,
      CARRIER,
      SHIP_PRIORITY,
      DELIVERY,
      TRIP,
      TRIP_STOP,
      ITEM,
      ITEM_CATEGORY,
      PROJECT_NAME,
      TASK_NAME,
      SCHEDULED_DAYS,
      SCHEDULED_HRS,
      DOCK_APPOINTMENT_DAYS,
      DOCK_APPOINTMENT_HOURS,
      PICK_SLIP_GROUP,
      RELEASE_SEQ_RULE,
      STAGING_SUBINVENTORY,
      STAGING_LOCATOR,
      CROSS_DOCK_CRITERIA,
      PICK_SUBINVENTORY,
      PLANNING_CRITERIA,
      PLANNING_CRITERIA_ID,
      REQUEST_ID,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14
    from WMS_WP_WAVE_HEADERS_B
    where WAVE_HEADER_ID = X_WAVE_HEADER_ID
    for update of WAVE_HEADER_ID nowait;

Line: 507

  cursor c1 is select
      WAVE_NAME,
      WAVE_DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from WMS_WP_WAVE_HEADERS_TL
    where WAVE_HEADER_ID = X_WAVE_HEADER_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of WAVE_HEADER_ID nowait;

Line: 520

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 716

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

Line: 903

  update WMS_WP_WAVE_HEADERS_TL set
    WAVE_NAME = X_WAVE_NAME,
    WAVE_DESCRIPTION = X_WAVE_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where WAVE_HEADER_ID = X_WAVE_HEADER_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 916

end UPDATE_ROW;

Line: 918

procedure DELETE_ROW (
  X_WAVE_HEADER_ID in NUMBER
) is
begin
  delete from WMS_WP_WAVE_HEADERS_TL
  where WAVE_HEADER_ID = X_WAVE_HEADER_ID;

Line: 929

  delete from WMS_WP_WAVE_HEADERS_B
  where WAVE_HEADER_ID = X_WAVE_HEADER_ID;

Line: 935

end DELETE_ROW;

Line: 940

  delete from WMS_WP_WAVE_HEADERS_TL T
  where not exists
    (select NULL
    from WMS_WP_WAVE_HEADERS_B B
    where B.WAVE_HEADER_ID = T.WAVE_HEADER_ID
    );

Line: 947

  update WMS_WP_WAVE_HEADERS_TL T set (
      WAVE_NAME,
      WAVE_DESCRIPTION
    ) = (select
      B.WAVE_NAME,
      B.WAVE_DESCRIPTION
    from WMS_WP_WAVE_HEADERS_TL B
    where B.WAVE_HEADER_ID = T.WAVE_HEADER_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.WAVE_HEADER_ID,
      T.LANGUAGE
  ) in (select
      SUBT.WAVE_HEADER_ID,
      SUBT.LANGUAGE
    from WMS_WP_WAVE_HEADERS_TL SUBB, WMS_WP_WAVE_HEADERS_TL SUBT
    where SUBB.WAVE_HEADER_ID = SUBT.WAVE_HEADER_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.WAVE_NAME <> SUBT.WAVE_NAME
      or (SUBB.WAVE_NAME is null and SUBT.WAVE_NAME is not null)
      or (SUBB.WAVE_NAME is not null and SUBT.WAVE_NAME is null)
      or SUBB.WAVE_DESCRIPTION <> SUBT.WAVE_DESCRIPTION
      or (SUBB.WAVE_DESCRIPTION is null and SUBT.WAVE_DESCRIPTION is not null)
      or (SUBB.WAVE_DESCRIPTION is not null and SUBT.WAVE_DESCRIPTION is null)
  ));

Line: 973

  insert into WMS_WP_WAVE_HEADERS_TL (
    WAVE_HEADER_ID,
    WAVE_NAME,
    WAVE_DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.WAVE_HEADER_ID,
    B.WAVE_NAME,
    B.WAVE_DESCRIPTION,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from WMS_WP_WAVE_HEADERS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from WMS_WP_WAVE_HEADERS_TL T
    where T.WAVE_HEADER_ID = B.WAVE_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);