APPS.IC_ITEM_MST_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_ITEM_ID in NUMBER,
  X_ITEM_NO in VARCHAR2,
  X_ALT_ITEMA in VARCHAR2,
  X_ALT_ITEMB in VARCHAR2,
  X_ITEM_UM in VARCHAR2,
  X_DUALUM_IND in NUMBER,
  X_ITEM_UM2 in VARCHAR2,
  X_DEVIATION_LO in NUMBER,
  X_DEVIATION_HI in NUMBER,
  X_LEVEL_CODE in NUMBER,
  X_LOT_CTL in NUMBER,
  X_LOT_INDIVISIBLE in NUMBER,
  X_SUBLOT_CTL in NUMBER,
  X_LOCT_CTL in NUMBER,
  X_NONINV_IND in NUMBER,
  X_MATCH_TYPE in NUMBER,
  X_INACTIVE_IND in NUMBER,
  X_INV_TYPE in VARCHAR2,
  X_SHELF_LIFE in NUMBER,
  X_RETEST_INTERVAL in NUMBER,
  X_GL_CLASS in VARCHAR2,
  X_INV_CLASS in VARCHAR2,
  X_SALES_CLASS in VARCHAR2,
  X_SHIP_CLASS in VARCHAR2,
  X_FRT_CLASS in VARCHAR2,
  X_PRICE_CLASS in VARCHAR2,
  X_STORAGE_CLASS in VARCHAR2,
  X_PURCH_CLASS in VARCHAR2,
  X_TAX_CLASS in VARCHAR2,
  X_CUSTOMS_CLASS in VARCHAR2,
  X_ALLOC_CLASS in VARCHAR2,
  X_PLANNING_CLASS in VARCHAR2,
  X_ITEMCOST_CLASS in VARCHAR2,
  X_COST_MTHD_CODE in VARCHAR2,
  X_UPC_CODE in VARCHAR2,
  X_GRADE_CTL in NUMBER,
  X_STATUS_CTL in NUMBER,
  X_QC_GRADE in VARCHAR2,
  X_LOT_STATUS in VARCHAR2,
  X_BULK_ID in NUMBER,
  X_PKG_ID in NUMBER,
  X_QCITEM_ID in NUMBER,
  X_QCHOLD_RES_CODE in VARCHAR2,
  X_EXPACTION_CODE in VARCHAR2,
  X_FILL_QTY in NUMBER,
  X_FILL_UM in VARCHAR2,
  X_PLANNING_CATEGORY_ID in NUMBER,
  X_PRICE_CATEGORY_ID in NUMBER,
  X_EXPACTION_INTERVAL in NUMBER,
  X_PHANTOM_TYPE in NUMBER,
  X_WHSE_ITEM_ID in NUMBER,
  X_EXPERIMENTAL_IND in NUMBER,
  X_EXPORTED_DATE in DATE,
  X_TRANS_CNT in NUMBER,
  X_DELETE_MARK in NUMBER,
  X_TEXT_CODE in NUMBER,
  X_SEQ_DPND_CLASS in VARCHAR2,
  X_COMMODITY_CODE in VARCHAR2,
  X_REQUEST_ID in NUMBER,
  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_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE16 in VARCHAR2,
  X_ATTRIBUTE17 in VARCHAR2,
  X_ATTRIBUTE18 in VARCHAR2,
  X_ATTRIBUTE19 in VARCHAR2,
  X_ATTRIBUTE20 in VARCHAR2,
  X_ATTRIBUTE21 in VARCHAR2,
  X_ATTRIBUTE22 in VARCHAR2,
  X_ATTRIBUTE23 in VARCHAR2,
  X_ATTRIBUTE24 in VARCHAR2,
  X_ATTRIBUTE25 in VARCHAR2,
  X_ATTRIBUTE26 in VARCHAR2,
  X_ATTRIBUTE27 in VARCHAR2,
  X_ATTRIBUTE28 in VARCHAR2,
  X_ATTRIBUTE29 in VARCHAR2,
  X_ATTRIBUTE30 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ITEM_ABCCODE in VARCHAR2,
  X_ALLOC_CATEGORY_ID in NUMBER,
  X_CUSTOMS_CATEGORY_ID in NUMBER,
  X_FRT_CATEGORY_ID in NUMBER,
  X_GL_CATEGORY_ID in NUMBER,
  X_INV_CATEGORY_ID in NUMBER,
  X_COST_CATEGORY_ID in NUMBER,
  X_PURCH_CATEGORY_ID in NUMBER,
  X_SALES_CATEGORY_ID in NUMBER,
  X_SEQ_CATEGORY_ID in NUMBER,
  X_SHIP_CATEGORY_ID in NUMBER,
  X_STORAGE_CATEGORY_ID in NUMBER,
  X_TAX_CATEGORY_ID in NUMBER,
  X_ITEM_DESC1 in VARCHAR2,
  X_ITEM_DESC2 in VARCHAR2,
  X_ONT_PRICING_QTY_SOURCE in NUMBER,  -- added for pricing by qty2 project
  X_AUTOLOT_ACTIVE_INDICATOR in NUMBER DEFAULT 0,
  X_LOT_PREFIX in VARCHAR2 DEFAULT NULL,
  X_LOT_SUFFIX in NUMBER DEFAULT 0,
  X_SUBLOT_PREFIX in VARCHAR2 DEFAULT NULL,
  X_SUBLOT_SUFFIX in NUMBER DEFAULT 0,
  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 IC_ITEM_MST_B
    where ITEM_ID = X_ITEM_ID
    ;

Line: 126

  insert into IC_ITEM_MST_B (
    ITEM_ID,
    ITEM_NO,
    ITEM_DESC1,
    ITEM_DESC2,
    ALT_ITEMA,
    ALT_ITEMB,
    ITEM_UM,
    DUALUM_IND,
    ITEM_UM2,
    DEVIATION_LO,
    DEVIATION_HI,
    LEVEL_CODE,
    LOT_CTL,
    LOT_INDIVISIBLE,
    SUBLOT_CTL,
    LOCT_CTL,
    NONINV_IND,
    MATCH_TYPE,
    INACTIVE_IND,
    INV_TYPE,
    SHELF_LIFE,
    RETEST_INTERVAL,
    GL_CLASS,
    INV_CLASS,
    SALES_CLASS,
    SHIP_CLASS,
    FRT_CLASS,
    PRICE_CLASS,
    STORAGE_CLASS,
    PURCH_CLASS,
    TAX_CLASS,
    CUSTOMS_CLASS,
    ALLOC_CLASS,
    PLANNING_CLASS,
    ITEMCOST_CLASS,
    COST_MTHD_CODE,
    UPC_CODE,
    GRADE_CTL,
    STATUS_CTL,
    QC_GRADE,
    LOT_STATUS,
    BULK_ID,
    PKG_ID,
    QCITEM_ID,
    QCHOLD_RES_CODE,
    EXPACTION_CODE,
    FILL_QTY,
    FILL_UM,
    PLANNING_CATEGORY_ID,
    PRICE_CATEGORY_ID,
    EXPACTION_INTERVAL,
    PHANTOM_TYPE,
    WHSE_ITEM_ID,
    EXPERIMENTAL_IND,
    EXPORTED_DATE,
    TRANS_CNT,
    DELETE_MARK,
    TEXT_CODE,
    SEQ_DPND_CLASS,
    COMMODITY_CODE,
    REQUEST_ID,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE16,
    ATTRIBUTE17,
    ATTRIBUTE18,
    ATTRIBUTE19,
    ATTRIBUTE20,
    ATTRIBUTE21,
    ATTRIBUTE22,
    ATTRIBUTE23,
    ATTRIBUTE24,
    ATTRIBUTE25,
    ATTRIBUTE26,
    ATTRIBUTE27,
    ATTRIBUTE28,
    ATTRIBUTE29,
    ATTRIBUTE30,
    ATTRIBUTE_CATEGORY,
    ITEM_ABCCODE,
    ALLOC_CATEGORY_ID,
    CUSTOMS_CATEGORY_ID,
    FRT_CATEGORY_ID,
    GL_CATEGORY_ID,
    INV_CATEGORY_ID,
    COST_CATEGORY_ID,
    PURCH_CATEGORY_ID,
    SALES_CATEGORY_ID,
    SEQ_CATEGORY_ID,
    SHIP_CATEGORY_ID,
    STORAGE_CATEGORY_ID,
    TAX_CATEGORY_ID,
    ONT_PRICING_QTY_SOURCE,  -- added for pricing by qty2 project
    AUTOLOT_ACTIVE_INDICATOR,
    LOT_PREFIX,
    LOT_SUFFIX,
    SUBLOT_PREFIX,
    SUBLOT_SUFFIX,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_ITEM_ID,
    X_ITEM_NO,
    X_ITEM_DESC1,
    X_ITEM_DESC2,
    X_ALT_ITEMA,
    X_ALT_ITEMB,
    X_ITEM_UM,
    X_DUALUM_IND,
    X_ITEM_UM2,
    X_DEVIATION_LO,
    X_DEVIATION_HI,
    X_LEVEL_CODE,
    X_LOT_CTL,
    X_LOT_INDIVISIBLE,
    X_SUBLOT_CTL,
    X_LOCT_CTL,
    X_NONINV_IND,
    X_MATCH_TYPE,
    X_INACTIVE_IND,
    X_INV_TYPE,
    X_SHELF_LIFE,
    X_RETEST_INTERVAL,
    X_GL_CLASS,
    X_INV_CLASS,
    X_SALES_CLASS,
    X_SHIP_CLASS,
    X_FRT_CLASS,
    X_PRICE_CLASS,
    X_STORAGE_CLASS,
    X_PURCH_CLASS,
    X_TAX_CLASS,
    X_CUSTOMS_CLASS,
    X_ALLOC_CLASS,
    X_PLANNING_CLASS,
    X_ITEMCOST_CLASS,
    X_COST_MTHD_CODE,
    X_UPC_CODE,
    X_GRADE_CTL,
    X_STATUS_CTL,
    X_QC_GRADE,
    X_LOT_STATUS,
    X_BULK_ID,
    X_PKG_ID,
    X_QCITEM_ID,
    X_QCHOLD_RES_CODE,
    X_EXPACTION_CODE,
    X_FILL_QTY,
    X_FILL_UM,
    X_PLANNING_CATEGORY_ID,
    X_PRICE_CATEGORY_ID,
    X_EXPACTION_INTERVAL,
    X_PHANTOM_TYPE,
    X_WHSE_ITEM_ID,
    X_EXPERIMENTAL_IND,
    X_EXPORTED_DATE,
    X_TRANS_CNT,
    X_DELETE_MARK,
    X_TEXT_CODE,
    X_SEQ_DPND_CLASS,
    X_COMMODITY_CODE,
    X_REQUEST_ID,
    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_ATTRIBUTE15,
    X_ATTRIBUTE16,
    X_ATTRIBUTE17,
    X_ATTRIBUTE18,
    X_ATTRIBUTE19,
    X_ATTRIBUTE20,
    X_ATTRIBUTE21,
    X_ATTRIBUTE22,
    X_ATTRIBUTE23,
    X_ATTRIBUTE24,
    X_ATTRIBUTE25,
    X_ATTRIBUTE26,
    X_ATTRIBUTE27,
    X_ATTRIBUTE28,
    X_ATTRIBUTE29,
    X_ATTRIBUTE30,
    X_ATTRIBUTE_CATEGORY,
    X_ITEM_ABCCODE,
    X_ALLOC_CATEGORY_ID,
    X_CUSTOMS_CATEGORY_ID,
    X_FRT_CATEGORY_ID,
    X_GL_CATEGORY_ID,
    X_INV_CATEGORY_ID,
    X_COST_CATEGORY_ID,
    X_PURCH_CATEGORY_ID,
    X_SALES_CATEGORY_ID,
    X_SEQ_CATEGORY_ID,
    X_SHIP_CATEGORY_ID,
    X_STORAGE_CATEGORY_ID,
    X_TAX_CATEGORY_ID,
    X_ONT_PRICING_QTY_SOURCE,  -- added for pricing by qty2 project
    X_AUTOLOT_ACTIVE_INDICATOR,
    X_LOT_PREFIX,
    X_LOT_SUFFIX,
    X_SUBLOT_PREFIX,
    X_SUBLOT_SUFFIX,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 362

  insert into IC_ITEM_MST_TL (
    ITEM_ID,
    ITEM_DESC1,
    ITEM_DESC2,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_ITEM_ID,
    X_ITEM_DESC1,
    X_ITEM_DESC2,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    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 IC_ITEM_MST_TL T
    where T.ITEM_ID = X_ITEM_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 400

end INSERT_ROW;

Line: 457

  X_DELETE_MARK in NUMBER,
  X_TEXT_CODE in NUMBER,
  X_SEQ_DPND_CLASS in VARCHAR2,
  X_COMMODITY_CODE in VARCHAR2,
  X_REQUEST_ID in NUMBER,
  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_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE16 in VARCHAR2,
  X_ATTRIBUTE17 in VARCHAR2,
  X_ATTRIBUTE18 in VARCHAR2,
  X_ATTRIBUTE19 in VARCHAR2,
  X_ATTRIBUTE20 in VARCHAR2,
  X_ATTRIBUTE21 in VARCHAR2,
  X_ATTRIBUTE22 in VARCHAR2,
  X_ATTRIBUTE23 in VARCHAR2,
  X_ATTRIBUTE24 in VARCHAR2,
  X_ATTRIBUTE25 in VARCHAR2,
  X_ATTRIBUTE26 in VARCHAR2,
  X_ATTRIBUTE27 in VARCHAR2,
  X_ATTRIBUTE28 in VARCHAR2,
  X_ATTRIBUTE29 in VARCHAR2,
  X_ATTRIBUTE30 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ITEM_ABCCODE in VARCHAR2,
  X_ALLOC_CATEGORY_ID in NUMBER,
  X_CUSTOMS_CATEGORY_ID in NUMBER,
  X_FRT_CATEGORY_ID in NUMBER,
  X_GL_CATEGORY_ID in NUMBER,
  X_INV_CATEGORY_ID in NUMBER,
  X_COST_CATEGORY_ID in NUMBER,
  X_PURCH_CATEGORY_ID in NUMBER,
  X_SALES_CATEGORY_ID in NUMBER,
  X_SEQ_CATEGORY_ID in NUMBER,
  X_SHIP_CATEGORY_ID in NUMBER,
  X_STORAGE_CATEGORY_ID in NUMBER,
  X_TAX_CATEGORY_ID in NUMBER,
  X_ITEM_DESC1 in VARCHAR2,
  X_ITEM_DESC2 in VARCHAR2,
  X_ONT_PRICING_QTY_SOURCE in NUMBER,   -- added for pricing by qty2 project
  X_AUTOLOT_ACTIVE_INDICATOR in NUMBER DEFAULT 0,
  X_LOT_PREFIX in VARCHAR2 DEFAULT NULL,
  X_LOT_SUFFIX in NUMBER DEFAULT 0,
  X_SUBLOT_PREFIX in VARCHAR2 DEFAULT NULL,
  X_SUBLOT_SUFFIX in NUMBER DEFAULT 0
) is
  cursor c is select
      ITEM_NO,
      ALT_ITEMA,
      ALT_ITEMB,
      ITEM_UM,
      DUALUM_IND,
      ITEM_UM2,
      DEVIATION_LO,
      DEVIATION_HI,
      LEVEL_CODE,
      LOT_CTL,
      LOT_INDIVISIBLE,
      SUBLOT_CTL,
      LOCT_CTL,
      NONINV_IND,
      MATCH_TYPE,
      INACTIVE_IND,
      INV_TYPE,
      SHELF_LIFE,
      RETEST_INTERVAL,
      GL_CLASS,
      INV_CLASS,
      SALES_CLASS,
      SHIP_CLASS,
      FRT_CLASS,
      PRICE_CLASS,
      STORAGE_CLASS,
      PURCH_CLASS,
      TAX_CLASS,
      CUSTOMS_CLASS,
      ALLOC_CLASS,
      PLANNING_CLASS,
      ITEMCOST_CLASS,
      COST_MTHD_CODE,
      UPC_CODE,
      GRADE_CTL,
      STATUS_CTL,
      QC_GRADE,
      LOT_STATUS,
      BULK_ID,
      PKG_ID,
      QCITEM_ID,
      QCHOLD_RES_CODE,
      EXPACTION_CODE,
      FILL_QTY,
      FILL_UM,
      PLANNING_CATEGORY_ID,
      PRICE_CATEGORY_ID,
      EXPACTION_INTERVAL,
      PHANTOM_TYPE,
      WHSE_ITEM_ID,
      EXPERIMENTAL_IND,
      EXPORTED_DATE,
      TRANS_CNT,
      DELETE_MARK,
      TEXT_CODE,
      SEQ_DPND_CLASS,
      COMMODITY_CODE,
      REQUEST_ID,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      ATTRIBUTE21,
      ATTRIBUTE22,
      ATTRIBUTE23,
      ATTRIBUTE24,
      ATTRIBUTE25,
      ATTRIBUTE26,
      ATTRIBUTE27,
      ATTRIBUTE28,
      ATTRIBUTE29,
      ATTRIBUTE30,
      ATTRIBUTE_CATEGORY,
      ITEM_ABCCODE,
      ALLOC_CATEGORY_ID,
      CUSTOMS_CATEGORY_ID,
      FRT_CATEGORY_ID,
      GL_CATEGORY_ID,
      INV_CATEGORY_ID,
      COST_CATEGORY_ID,
      PURCH_CATEGORY_ID,
      SALES_CATEGORY_ID,
      SEQ_CATEGORY_ID,
      SHIP_CATEGORY_ID,
      STORAGE_CATEGORY_ID,
      TAX_CATEGORY_ID,
      ONT_PRICING_QTY_SOURCE,   -- added for pricing by qty2 project
      AUTOLOT_ACTIVE_INDICATOR,
      LOT_PREFIX,
      LOT_SUFFIX,
      SUBLOT_PREFIX,
      SUBLOT_SUFFIX
    from IC_ITEM_MST_B
    where ITEM_ID = X_ITEM_ID
    for update of ITEM_ID nowait;

Line: 629

  cursor c1 is select
      ITEM_DESC1,
      ITEM_DESC2,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from IC_ITEM_MST_TL
    where ITEM_ID = X_ITEM_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of ITEM_ID nowait;

Line: 642

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

Line: 730

      AND (recinfo.DELETE_MARK = X_DELETE_MARK)
      AND ((recinfo.TEXT_CODE = X_TEXT_CODE)
           OR ((recinfo.TEXT_CODE is null) AND (X_TEXT_CODE is null)))
      AND ((recinfo.SEQ_DPND_CLASS = X_SEQ_DPND_CLASS)
           OR ((recinfo.SEQ_DPND_CLASS is null) AND (X_SEQ_DPND_CLASS is null)))
      AND ((recinfo.COMMODITY_CODE = X_COMMODITY_CODE)
           OR ((recinfo.COMMODITY_CODE is null) AND (X_COMMODITY_CODE is null)))
      AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
           OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
      AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
           OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
      AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
           OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
      AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
           OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
      AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
           OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
      AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
           OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
      AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
           OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
      AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
           OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
      AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
           OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
      AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
           OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
      AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
           OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
      AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
           OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
      AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
           OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
      AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
           OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
      AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
           OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
      AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
           OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
      AND ((recinfo.ATTRIBUTE16 = X_ATTRIBUTE16)
           OR ((recinfo.ATTRIBUTE16 is null) AND (X_ATTRIBUTE16 is null)))
      AND ((recinfo.ATTRIBUTE17 = X_ATTRIBUTE17)
           OR ((recinfo.ATTRIBUTE17 is null) AND (X_ATTRIBUTE17 is null)))
      AND ((recinfo.ATTRIBUTE18 = X_ATTRIBUTE18)
           OR ((recinfo.ATTRIBUTE18 is null) AND (X_ATTRIBUTE18 is null)))
      AND ((recinfo.ATTRIBUTE19 = X_ATTRIBUTE19)
           OR ((recinfo.ATTRIBUTE19 is null) AND (X_ATTRIBUTE19 is null)))
      AND ((recinfo.ATTRIBUTE20 = X_ATTRIBUTE20)
           OR ((recinfo.ATTRIBUTE20 is null) AND (X_ATTRIBUTE20 is null)))
      AND ((recinfo.ATTRIBUTE21 = X_ATTRIBUTE21)
           OR ((recinfo.ATTRIBUTE21 is null) AND (X_ATTRIBUTE21 is null)))
      AND ((recinfo.ATTRIBUTE22 = X_ATTRIBUTE22)
           OR ((recinfo.ATTRIBUTE22 is null) AND (X_ATTRIBUTE22 is null)))
      AND ((recinfo.ATTRIBUTE23 = X_ATTRIBUTE23)
           OR ((recinfo.ATTRIBUTE23 is null) AND (X_ATTRIBUTE23 is null)))
      AND ((recinfo.ATTRIBUTE24 = X_ATTRIBUTE24)
           OR ((recinfo.ATTRIBUTE24 is null) AND (X_ATTRIBUTE24 is null)))
      AND ((recinfo.ATTRIBUTE25 = X_ATTRIBUTE25)
           OR ((recinfo.ATTRIBUTE25 is null) AND (X_ATTRIBUTE25 is null)))
      AND ((recinfo.ATTRIBUTE26 = X_ATTRIBUTE26)
           OR ((recinfo.ATTRIBUTE26 is null) AND (X_ATTRIBUTE26 is null)))
      AND ((recinfo.ATTRIBUTE27 = X_ATTRIBUTE27)
           OR ((recinfo.ATTRIBUTE27 is null) AND (X_ATTRIBUTE27 is null)))
      AND ((recinfo.ATTRIBUTE28 = X_ATTRIBUTE28)
           OR ((recinfo.ATTRIBUTE28 is null) AND (X_ATTRIBUTE28 is null)))
      AND ((recinfo.ATTRIBUTE29 = X_ATTRIBUTE29)
           OR ((recinfo.ATTRIBUTE29 is null) AND (X_ATTRIBUTE29 is null)))
      AND ((recinfo.ATTRIBUTE30 = X_ATTRIBUTE30)
           OR ((recinfo.ATTRIBUTE30 is null) AND (X_ATTRIBUTE30 is null)))
      AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
           OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
      AND ((recinfo.ITEM_ABCCODE = X_ITEM_ABCCODE)
           OR ((recinfo.ITEM_ABCCODE is null) AND (X_ITEM_ABCCODE is null)))
      AND ((recinfo.ALLOC_CATEGORY_ID = X_ALLOC_CATEGORY_ID)
           OR ((recinfo.ALLOC_CATEGORY_ID is null) AND (X_ALLOC_CATEGORY_ID is null)))
      AND ((recinfo.CUSTOMS_CATEGORY_ID = X_CUSTOMS_CATEGORY_ID)
           OR ((recinfo.CUSTOMS_CATEGORY_ID is null) AND (X_CUSTOMS_CATEGORY_ID is null)))
      AND ((recinfo.FRT_CATEGORY_ID = X_FRT_CATEGORY_ID)
           OR ((recinfo.FRT_CATEGORY_ID is null) AND (X_FRT_CATEGORY_ID is null)))
      AND ((recinfo.GL_CATEGORY_ID = X_GL_CATEGORY_ID)
           OR ((recinfo.GL_CATEGORY_ID is null) AND (X_GL_CATEGORY_ID is null)))
      AND ((recinfo.INV_CATEGORY_ID = X_INV_CATEGORY_ID)
           OR ((recinfo.INV_CATEGORY_ID is null) AND (X_INV_CATEGORY_ID is null)))
      AND ((recinfo.COST_CATEGORY_ID = X_COST_CATEGORY_ID)
           OR ((recinfo.COST_CATEGORY_ID is null) AND (X_COST_CATEGORY_ID is null)))
      AND ((recinfo.PURCH_CATEGORY_ID = X_PURCH_CATEGORY_ID)
           OR ((recinfo.PURCH_CATEGORY_ID is null) AND (X_PURCH_CATEGORY_ID is null)))
      AND ((recinfo.SALES_CATEGORY_ID = X_SALES_CATEGORY_ID)
           OR ((recinfo.SALES_CATEGORY_ID is null) AND (X_SALES_CATEGORY_ID is null)))
      AND ((recinfo.SEQ_CATEGORY_ID = X_SEQ_CATEGORY_ID)
           OR ((recinfo.SEQ_CATEGORY_ID is null) AND (X_SEQ_CATEGORY_ID is null)))
      AND ((recinfo.SHIP_CATEGORY_ID = X_SHIP_CATEGORY_ID)
           OR ((recinfo.SHIP_CATEGORY_ID is null) AND (X_SHIP_CATEGORY_ID is null)))
      AND ((recinfo.STORAGE_CATEGORY_ID = X_STORAGE_CATEGORY_ID)
           OR ((recinfo.STORAGE_CATEGORY_ID is null) AND (X_STORAGE_CATEGORY_ID is null)))
      AND ((recinfo.TAX_CATEGORY_ID = X_TAX_CATEGORY_ID)
           OR ((recinfo.TAX_CATEGORY_ID is null) AND (X_TAX_CATEGORY_ID is null)))
      AND ((recinfo.ONT_PRICING_QTY_SOURCE = X_ONT_PRICING_QTY_SOURCE) -- added for pricing by qty2 project
           OR ((recinfo.ONT_PRICING_QTY_SOURCE is null) AND (X_ONT_PRICING_QTY_SOURCE is null)))
      AND ((recinfo.AUTOLOT_ACTIVE_INDICATOR = X_AUTOLOT_ACTIVE_INDICATOR)
           OR ((recinfo.AUTOLOT_ACTIVE_INDICATOR is null) AND (X_AUTOLOT_ACTIVE_INDICATOR is null)))
      AND ((recinfo.LOT_PREFIX = X_LOT_PREFIX)
           OR ((recinfo.LOT_PREFIX is null) AND (X_LOT_PREFIX is null)))
      AND ((recinfo.LOT_SUFFIX = X_LOT_SUFFIX)
           OR ((recinfo.LOT_SUFFIX is null) AND (X_LOT_SUFFIX is null)))
      AND ((recinfo.SUBLOT_PREFIX = X_SUBLOT_PREFIX)
           OR ((recinfo.SUBLOT_PREFIX is null) AND (X_SUBLOT_PREFIX is null)))
      AND ((recinfo.SUBLOT_SUFFIX = X_SUBLOT_SUFFIX)
           OR ((recinfo.SUBLOT_SUFFIX is null) AND (X_SUBLOT_SUFFIX is null)))
  ) then
    null;

Line: 862

procedure UPDATE_ROW (
  X_ITEM_ID in NUMBER,
  X_ITEM_NO in VARCHAR2,
  X_ALT_ITEMA in VARCHAR2,
  X_ALT_ITEMB in VARCHAR2,
  X_ITEM_UM in VARCHAR2,
  X_DUALUM_IND in NUMBER,
  X_ITEM_UM2 in VARCHAR2,
  X_DEVIATION_LO in NUMBER,
  X_DEVIATION_HI in NUMBER,
  X_LEVEL_CODE in NUMBER,
  X_LOT_CTL in NUMBER,
  X_LOT_INDIVISIBLE in NUMBER,
  X_SUBLOT_CTL in NUMBER,
  X_LOCT_CTL in NUMBER,
  X_NONINV_IND in NUMBER,
  X_MATCH_TYPE in NUMBER,
  X_INACTIVE_IND in NUMBER,
  X_INV_TYPE in VARCHAR2,
  X_SHELF_LIFE in NUMBER,
  X_RETEST_INTERVAL in NUMBER,
  X_GL_CLASS in VARCHAR2,
  X_INV_CLASS in VARCHAR2,
  X_SALES_CLASS in VARCHAR2,
  X_SHIP_CLASS in VARCHAR2,
  X_FRT_CLASS in VARCHAR2,
  X_PRICE_CLASS in VARCHAR2,
  X_STORAGE_CLASS in VARCHAR2,
  X_PURCH_CLASS in VARCHAR2,
  X_TAX_CLASS in VARCHAR2,
  X_CUSTOMS_CLASS in VARCHAR2,
  X_ALLOC_CLASS in VARCHAR2,
  X_PLANNING_CLASS in VARCHAR2,
  X_ITEMCOST_CLASS in VARCHAR2,
  X_COST_MTHD_CODE in VARCHAR2,
  X_UPC_CODE in VARCHAR2,
  X_GRADE_CTL in NUMBER,
  X_STATUS_CTL in NUMBER,
  X_QC_GRADE in VARCHAR2,
  X_LOT_STATUS in VARCHAR2,
  X_BULK_ID in NUMBER,
  X_PKG_ID in NUMBER,
  X_QCITEM_ID in NUMBER,
  X_QCHOLD_RES_CODE in VARCHAR2,
  X_EXPACTION_CODE in VARCHAR2,
  X_FILL_QTY in NUMBER,
  X_FILL_UM in VARCHAR2,
  X_PLANNING_CATEGORY_ID in NUMBER,
  X_PRICE_CATEGORY_ID in NUMBER,
  X_EXPACTION_INTERVAL in NUMBER,
  X_PHANTOM_TYPE in NUMBER,
  X_WHSE_ITEM_ID in NUMBER,
  X_EXPERIMENTAL_IND in NUMBER,
  X_EXPORTED_DATE in DATE,
  X_TRANS_CNT in NUMBER,
  X_DELETE_MARK in NUMBER,
  X_TEXT_CODE in NUMBER,
  X_SEQ_DPND_CLASS in VARCHAR2,
  X_COMMODITY_CODE in VARCHAR2,
  X_REQUEST_ID in NUMBER,
  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_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE16 in VARCHAR2,
  X_ATTRIBUTE17 in VARCHAR2,
  X_ATTRIBUTE18 in VARCHAR2,
  X_ATTRIBUTE19 in VARCHAR2,
  X_ATTRIBUTE20 in VARCHAR2,
  X_ATTRIBUTE21 in VARCHAR2,
  X_ATTRIBUTE22 in VARCHAR2,
  X_ATTRIBUTE23 in VARCHAR2,
  X_ATTRIBUTE24 in VARCHAR2,
  X_ATTRIBUTE25 in VARCHAR2,
  X_ATTRIBUTE26 in VARCHAR2,
  X_ATTRIBUTE27 in VARCHAR2,
  X_ATTRIBUTE28 in VARCHAR2,
  X_ATTRIBUTE29 in VARCHAR2,
  X_ATTRIBUTE30 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ITEM_ABCCODE in VARCHAR2,
  X_ALLOC_CATEGORY_ID in NUMBER,
  X_CUSTOMS_CATEGORY_ID in NUMBER,
  X_FRT_CATEGORY_ID in NUMBER,
  X_GL_CATEGORY_ID in NUMBER,
  X_INV_CATEGORY_ID in NUMBER,
  X_COST_CATEGORY_ID in NUMBER,
  X_PURCH_CATEGORY_ID in NUMBER,
  X_SALES_CATEGORY_ID in NUMBER,
  X_SEQ_CATEGORY_ID in NUMBER,
  X_SHIP_CATEGORY_ID in NUMBER,
  X_STORAGE_CATEGORY_ID in NUMBER,
  X_TAX_CATEGORY_ID in NUMBER,
  X_ITEM_DESC1 in VARCHAR2,
  X_ITEM_DESC2 in VARCHAR2,
  X_ONT_PRICING_QTY_SOURCE in NUMBER, -- added for pricing by qty2 project
  X_AUTOLOT_ACTIVE_INDICATOR in NUMBER DEFAULT 0,
  X_LOT_PREFIX in VARCHAR2 DEFAULT NULL,
  X_LOT_SUFFIX in NUMBER DEFAULT 0,
  X_SUBLOT_PREFIX in VARCHAR2 DEFAULT NULL,
  X_SUBLOT_SUFFIX in NUMBER DEFAULT 0,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update IC_ITEM_MST_B set
    ITEM_NO = X_ITEM_NO,
    ITEM_DESC1 = X_ITEM_DESC1,
    ITEM_DESC2 = X_ITEM_DESC2,
    ALT_ITEMA = X_ALT_ITEMA,
    ALT_ITEMB = X_ALT_ITEMB,
    ITEM_UM = X_ITEM_UM,
    DUALUM_IND = X_DUALUM_IND,
    ITEM_UM2 = X_ITEM_UM2,
    DEVIATION_LO = X_DEVIATION_LO,
    DEVIATION_HI = X_DEVIATION_HI,
    LEVEL_CODE = X_LEVEL_CODE,
    LOT_CTL = X_LOT_CTL,
    LOT_INDIVISIBLE = X_LOT_INDIVISIBLE,
    SUBLOT_CTL = X_SUBLOT_CTL,
    LOCT_CTL = X_LOCT_CTL,
    NONINV_IND = X_NONINV_IND,
    MATCH_TYPE = X_MATCH_TYPE,
    INACTIVE_IND = X_INACTIVE_IND,
    INV_TYPE = X_INV_TYPE,
    SHELF_LIFE = X_SHELF_LIFE,
    RETEST_INTERVAL = X_RETEST_INTERVAL,
    GL_CLASS = X_GL_CLASS,
    INV_CLASS = X_INV_CLASS,
    SALES_CLASS = X_SALES_CLASS,
    SHIP_CLASS = X_SHIP_CLASS,
    FRT_CLASS = X_FRT_CLASS,
    PRICE_CLASS = X_PRICE_CLASS,
    STORAGE_CLASS = X_STORAGE_CLASS,
    PURCH_CLASS = X_PURCH_CLASS,
    TAX_CLASS = X_TAX_CLASS,
    CUSTOMS_CLASS = X_CUSTOMS_CLASS,
    ALLOC_CLASS = X_ALLOC_CLASS,
    PLANNING_CLASS = X_PLANNING_CLASS,
    ITEMCOST_CLASS = X_ITEMCOST_CLASS,
    COST_MTHD_CODE = X_COST_MTHD_CODE,
    UPC_CODE = X_UPC_CODE,
    GRADE_CTL = X_GRADE_CTL,
    STATUS_CTL = X_STATUS_CTL,
    QC_GRADE = X_QC_GRADE,
    LOT_STATUS = X_LOT_STATUS,
    BULK_ID = X_BULK_ID,
    PKG_ID = X_PKG_ID,
    QCITEM_ID = X_QCITEM_ID,
    QCHOLD_RES_CODE = X_QCHOLD_RES_CODE,
    EXPACTION_CODE = X_EXPACTION_CODE,
    FILL_QTY = X_FILL_QTY,
    FILL_UM = X_FILL_UM,
    PLANNING_CATEGORY_ID = X_PLANNING_CATEGORY_ID,
    PRICE_CATEGORY_ID = X_PRICE_CATEGORY_ID,
    EXPACTION_INTERVAL = X_EXPACTION_INTERVAL,
    PHANTOM_TYPE = X_PHANTOM_TYPE,
    WHSE_ITEM_ID = X_WHSE_ITEM_ID,
    EXPERIMENTAL_IND = X_EXPERIMENTAL_IND,
    EXPORTED_DATE = X_EXPORTED_DATE,
    TRANS_CNT = X_TRANS_CNT,
    DELETE_MARK = X_DELETE_MARK,
    TEXT_CODE = X_TEXT_CODE,
    SEQ_DPND_CLASS = X_SEQ_DPND_CLASS,
    COMMODITY_CODE = X_COMMODITY_CODE,
    REQUEST_ID = X_REQUEST_ID,
    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,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    ATTRIBUTE16 = X_ATTRIBUTE16,
    ATTRIBUTE17 = X_ATTRIBUTE17,
    ATTRIBUTE18 = X_ATTRIBUTE18,
    ATTRIBUTE19 = X_ATTRIBUTE19,
    ATTRIBUTE20 = X_ATTRIBUTE20,
    ATTRIBUTE21 = X_ATTRIBUTE21,
    ATTRIBUTE22 = X_ATTRIBUTE22,
    ATTRIBUTE23 = X_ATTRIBUTE23,
    ATTRIBUTE24 = X_ATTRIBUTE24,
    ATTRIBUTE25 = X_ATTRIBUTE25,
    ATTRIBUTE26 = X_ATTRIBUTE26,
    ATTRIBUTE27 = X_ATTRIBUTE27,
    ATTRIBUTE28 = X_ATTRIBUTE28,
    ATTRIBUTE29 = X_ATTRIBUTE29,
    ATTRIBUTE30 = X_ATTRIBUTE30,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ITEM_ABCCODE = X_ITEM_ABCCODE,
    ALLOC_CATEGORY_ID = X_ALLOC_CATEGORY_ID,
    CUSTOMS_CATEGORY_ID = X_CUSTOMS_CATEGORY_ID,
    FRT_CATEGORY_ID = X_FRT_CATEGORY_ID,
    GL_CATEGORY_ID = X_GL_CATEGORY_ID,
    INV_CATEGORY_ID = X_INV_CATEGORY_ID,
    COST_CATEGORY_ID = X_COST_CATEGORY_ID,
    PURCH_CATEGORY_ID = X_PURCH_CATEGORY_ID,
    SALES_CATEGORY_ID = X_SALES_CATEGORY_ID,
    SEQ_CATEGORY_ID = X_SEQ_CATEGORY_ID,
    SHIP_CATEGORY_ID = X_SHIP_CATEGORY_ID,
    STORAGE_CATEGORY_ID = X_STORAGE_CATEGORY_ID,
    ONT_PRICING_QTY_SOURCE = X_ONT_PRICING_QTY_SOURCE,  -- added for pricing by qty2 project
    AUTOLOT_ACTIVE_INDICATOR = X_AUTOLOT_ACTIVE_INDICATOR,
    LOT_PREFIX = X_LOT_PREFIX,
    LOT_SUFFIX = X_LOT_SUFFIX,
    SUBLOT_PREFIX = X_SUBLOT_PREFIX,
    SUBLOT_SUFFIX = X_SUBLOT_SUFFIX,
    TAX_CATEGORY_ID = X_TAX_CATEGORY_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where ITEM_ID = X_ITEM_ID;

Line: 1099

  update IC_ITEM_MST_TL set
    ITEM_DESC1 = X_ITEM_DESC1,
    ITEM_DESC2 = X_ITEM_DESC2,
    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 ITEM_ID = X_ITEM_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 1112

end UPDATE_ROW;

Line: 1114

procedure DELETE_ROW (
  X_ITEM_ID in NUMBER
) is
begin
/*********
  delete from IC_ITEM_MST_TL
  where ITEM_ID = X_ITEM_ID;

Line: 1127

  update IC_ITEM_MST_B set delete_mark = 1
  where ITEM_ID = X_ITEM_ID;

Line: 1133

end DELETE_ROW;

Line: 1138

  delete from IC_ITEM_MST_TL T
  where not exists
    (select NULL
    from IC_ITEM_MST_B B
    where B.ITEM_ID = T.ITEM_ID
    );

Line: 1145

  update IC_ITEM_MST_TL T set (
      ITEM_DESC1,
      ITEM_DESC2
    ) = (select
      B.ITEM_DESC1,
      B.ITEM_DESC2
    from IC_ITEM_MST_TL B
    where B.ITEM_ID = T.ITEM_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.ITEM_ID,
      T.LANGUAGE
  ) in (select
      SUBT.ITEM_ID,
      SUBT.LANGUAGE
    from IC_ITEM_MST_TL SUBB, IC_ITEM_MST_TL SUBT
    where SUBB.ITEM_ID = SUBT.ITEM_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.ITEM_DESC1 <> SUBT.ITEM_DESC1
      or SUBB.ITEM_DESC2 <> SUBT.ITEM_DESC2
      or (SUBB.ITEM_DESC2 is null and SUBT.ITEM_DESC2 is not null)
      or (SUBB.ITEM_DESC2 is not null and SUBT.ITEM_DESC2 is null)
  ));

Line: 1169

  insert into IC_ITEM_MST_TL (
    ITEM_ID,
    ITEM_DESC1,
    ITEM_DESC2,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.ITEM_ID,
    B.ITEM_DESC1,
    B.ITEM_DESC2,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from IC_ITEM_MST_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from IC_ITEM_MST_TL T
    where T.ITEM_ID = B.ITEM_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);