APPS.WMS_WP_PLANNING_CRITERIA_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_PLANNING_CRITERIA_ID in NUMBER,
  X_LABOR_SETUP_MODE in VARCHAR2,
  X_PLANNING_METHOD in VARCHAR2,
  X_TYPE in VARCHAR2,
  X_BACKORDER_FLAG in VARCHAR2,
  X_REJECT_ORDER_LINE_FLAG in VARCHAR2,
  X_REJECT_ALL_LINES_SHIPSET_FLA in VARCHAR2,
  X_REJECT_ALL_LINES_MODEL_FLAG in VARCHAR2,
  X_REJECT_ORDER_FLAG in VARCHAR2,
  X_RESERVE_STOCK_FLAG in VARCHAR2,
  X_AUTO_CREATE_DELIVERIES_FLAG in VARCHAR2,
  X_CREDIT_CHECK_HOLD_FLAG in VARCHAR2,
  X_PICKING_SUBINVENTORY in VARCHAR2,
  X_DESTINATION_SUBINVENTORY in VARCHAR2,
  X_BULK_LABOR_PLANNING_FLAG in VARCHAR2,
  X_TIME_UOM in VARCHAR2,
  X_DEPARTMENT_CODE in VARCHAR2,
  X_DEPARTMENT_ID in NUMBER,
  X_ENABLE_LABOR_PLANNING in VARCHAR2,
  X_CROSSDOCK_CRITERIA in VARCHAR2,
  X_CROSSDOCK_CRITERIA_ID in NUMBER,
  X_ALLOCATION_METHOD in VARCHAR2,
  X_PLANNING_CRITERIA 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_PLANNING_CRITERIA_B
    where PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID
    ;

Line: 41

  insert into WMS_WP_PLANNING_CRITERIA_B (
    LABOR_SETUP_MODE,
    PLANNING_CRITERIA_ID,
    PLANNING_METHOD,
    TYPE,
    BACKORDER_FLAG,
    REJECT_ORDER_LINE_FLAG,
    REJECT_ALL_LINES_SHIPSET_FLAG,
    REJECT_ALL_LINES_MODEL_FLAG,
    REJECT_ORDER_FLAG,
    RESERVE_STOCK_FLAG,
    AUTO_CREATE_DELIVERIES_FLAG,
    CREDIT_CHECK_HOLD_FLAG,
    PICKING_SUBINVENTORY,
    DESTINATION_SUBINVENTORY,
    BULK_LABOR_PLANNING_FLAG,
    TIME_UOM,
    DEPARTMENT_CODE,
    DEPARTMENT_ID,
    ENABLE_LABOR_PLANNING,
    CROSSDOCK_CRITERIA,
    CROSSDOCK_CRITERIA_ID,
    ALLOCATION_METHOD,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_LABOR_SETUP_MODE,
    X_PLANNING_CRITERIA_ID,
    X_PLANNING_METHOD,
    X_TYPE,
    X_BACKORDER_FLAG,
    X_REJECT_ORDER_LINE_FLAG,
    X_REJECT_ALL_LINES_SHIPSET_FLA,
    X_REJECT_ALL_LINES_MODEL_FLAG,
    X_REJECT_ORDER_FLAG,
    X_RESERVE_STOCK_FLAG,
    X_AUTO_CREATE_DELIVERIES_FLAG,
    X_CREDIT_CHECK_HOLD_FLAG,
    X_PICKING_SUBINVENTORY,
    X_DESTINATION_SUBINVENTORY,
    X_BULK_LABOR_PLANNING_FLAG,
    X_TIME_UOM,
    X_DEPARTMENT_CODE,
    X_DEPARTMENT_ID,
    X_ENABLE_LABOR_PLANNING,
    X_CROSSDOCK_CRITERIA,
    X_CROSSDOCK_CRITERIA_ID,
    X_ALLOCATION_METHOD,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 99

  insert into WMS_WP_PLANNING_CRITERIA_TL (
    PLANNING_CRITERIA_ID,
    PLANNING_CRITERIA,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_PLANNING_CRITERIA_ID,
    X_PLANNING_CRITERIA,
    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_PLANNING_CRITERIA_TL T
    where T.PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 135

end INSERT_ROW;

Line: 162

  cursor c is select
      LABOR_SETUP_MODE,
      PLANNING_METHOD,
      TYPE,
      BACKORDER_FLAG,
      REJECT_ORDER_LINE_FLAG,
      REJECT_ALL_LINES_SHIPSET_FLAG,
      REJECT_ALL_LINES_MODEL_FLAG,
      REJECT_ORDER_FLAG,
      RESERVE_STOCK_FLAG,
      AUTO_CREATE_DELIVERIES_FLAG,
      CREDIT_CHECK_HOLD_FLAG,
      PICKING_SUBINVENTORY,
      DESTINATION_SUBINVENTORY,
      BULK_LABOR_PLANNING_FLAG,
      TIME_UOM,
      DEPARTMENT_CODE,
      DEPARTMENT_ID,
      ENABLE_LABOR_PLANNING,
      CROSSDOCK_CRITERIA,
      CROSSDOCK_CRITERIA_ID,
      ALLOCATION_METHOD
    from WMS_WP_PLANNING_CRITERIA_B
    where PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID
    for update of PLANNING_CRITERIA_ID nowait;

Line: 189

  cursor c1 is select
      PLANNING_CRITERIA,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from WMS_WP_PLANNING_CRITERIA_TL
    where PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of PLANNING_CRITERIA_ID nowait;

Line: 201

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

Line: 269

procedure UPDATE_ROW (
  X_PLANNING_CRITERIA_ID in NUMBER,
  X_LABOR_SETUP_MODE in VARCHAR2,
  X_PLANNING_METHOD in VARCHAR2,
  X_TYPE in VARCHAR2,
  X_BACKORDER_FLAG in VARCHAR2,
  X_REJECT_ORDER_LINE_FLAG in VARCHAR2,
  X_REJECT_ALL_LINES_SHIPSET_FLA in VARCHAR2,
  X_REJECT_ALL_LINES_MODEL_FLAG in VARCHAR2,
  X_REJECT_ORDER_FLAG in VARCHAR2,
  X_RESERVE_STOCK_FLAG in VARCHAR2,
  X_AUTO_CREATE_DELIVERIES_FLAG in VARCHAR2,
  X_CREDIT_CHECK_HOLD_FLAG in VARCHAR2,
  X_PICKING_SUBINVENTORY in VARCHAR2,
  X_DESTINATION_SUBINVENTORY in VARCHAR2,
  X_BULK_LABOR_PLANNING_FLAG in VARCHAR2,
  X_TIME_UOM in VARCHAR2,
  X_DEPARTMENT_CODE in VARCHAR2,
  X_DEPARTMENT_ID in NUMBER,
  X_ENABLE_LABOR_PLANNING in VARCHAR2,
  X_CROSSDOCK_CRITERIA in VARCHAR2,
  X_CROSSDOCK_CRITERIA_ID in NUMBER,
  X_ALLOCATION_METHOD in VARCHAR2,
  X_PLANNING_CRITERIA 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_PLANNING_CRITERIA_B set
    LABOR_SETUP_MODE = X_LABOR_SETUP_MODE,
    PLANNING_METHOD = X_PLANNING_METHOD,
    TYPE = X_TYPE,
    BACKORDER_FLAG = X_BACKORDER_FLAG,
    REJECT_ORDER_LINE_FLAG = X_REJECT_ORDER_LINE_FLAG,
    REJECT_ALL_LINES_SHIPSET_FLAG = X_REJECT_ALL_LINES_SHIPSET_FLA,
    REJECT_ALL_LINES_MODEL_FLAG = X_REJECT_ALL_LINES_MODEL_FLAG,
    REJECT_ORDER_FLAG = X_REJECT_ORDER_FLAG,
    RESERVE_STOCK_FLAG = X_RESERVE_STOCK_FLAG,
    AUTO_CREATE_DELIVERIES_FLAG = X_AUTO_CREATE_DELIVERIES_FLAG,
    CREDIT_CHECK_HOLD_FLAG = X_CREDIT_CHECK_HOLD_FLAG,
    PICKING_SUBINVENTORY = X_PICKING_SUBINVENTORY,
    DESTINATION_SUBINVENTORY = X_DESTINATION_SUBINVENTORY,
    BULK_LABOR_PLANNING_FLAG = X_BULK_LABOR_PLANNING_FLAG,
    TIME_UOM = X_TIME_UOM,
    DEPARTMENT_CODE = X_DEPARTMENT_CODE,
    DEPARTMENT_ID = X_DEPARTMENT_ID,
    ENABLE_LABOR_PLANNING = X_ENABLE_LABOR_PLANNING,
    CROSSDOCK_CRITERIA = X_CROSSDOCK_CRITERIA,
    CROSSDOCK_CRITERIA_ID = X_CROSSDOCK_CRITERIA_ID,
    ALLOCATION_METHOD = X_ALLOCATION_METHOD,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID;

Line: 329

  update WMS_WP_PLANNING_CRITERIA_TL set
    PLANNING_CRITERIA = X_PLANNING_CRITERIA,
    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 PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 341

end UPDATE_ROW;

Line: 343

procedure DELETE_ROW (
  X_PLANNING_CRITERIA_ID in NUMBER
) is
begin
  delete from WMS_WP_PLANNING_CRITERIA_TL
  where PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID;

Line: 354

  delete from WMS_WP_PLANNING_CRITERIA_B
  where PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID;

Line: 360

end DELETE_ROW;

Line: 365

  delete from WMS_WP_PLANNING_CRITERIA_TL T
  where not exists
    (select NULL
    from WMS_WP_PLANNING_CRITERIA_B B
    where B.PLANNING_CRITERIA_ID = T.PLANNING_CRITERIA_ID
    );

Line: 372

  update WMS_WP_PLANNING_CRITERIA_TL T set (
      PLANNING_CRITERIA
    ) = (select
      B.PLANNING_CRITERIA
    from WMS_WP_PLANNING_CRITERIA_TL B
    where B.PLANNING_CRITERIA_ID = T.PLANNING_CRITERIA_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.PLANNING_CRITERIA_ID,
      T.LANGUAGE
  ) in (select
      SUBT.PLANNING_CRITERIA_ID,
      SUBT.LANGUAGE
    from WMS_WP_PLANNING_CRITERIA_TL SUBB, WMS_WP_PLANNING_CRITERIA_TL SUBT
    where SUBB.PLANNING_CRITERIA_ID = SUBT.PLANNING_CRITERIA_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.PLANNING_CRITERIA <> SUBT.PLANNING_CRITERIA
      or (SUBB.PLANNING_CRITERIA is null and SUBT.PLANNING_CRITERIA is not null)
      or (SUBB.PLANNING_CRITERIA is not null and SUBT.PLANNING_CRITERIA is null)
  ));

Line: 393

  insert into WMS_WP_PLANNING_CRITERIA_TL (
    PLANNING_CRITERIA_ID,
    PLANNING_CRITERIA,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.PLANNING_CRITERIA_ID,
    B.PLANNING_CRITERIA,
    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_PLANNING_CRITERIA_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_PLANNING_CRITERIA_TL T
    where T.PLANNING_CRITERIA_ID = B.PLANNING_CRITERIA_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);