APPS.MTL_TRANSACTION_LOTS_INTF_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out nocopy ROWID,
  X_TRANSACTION_INTERFACE_ID in NUMBER,
  X_EXPIRATION_ACTION_CODE in VARCHAR2,
  X_EXPIRATION_ACTION_DATE in DATE,
  X_HOLD_DATE in DATE,
  X_ORIGINATION_TYPE in NUMBER,
  X_PARENT_LOT_NUMBER in VARCHAR2,
  X_REASON_ID in NUMBER,
  X_SOURCE_CODE in VARCHAR2,
  X_SOURCE_LINE_ID in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_LOT_EXPIRATION_DATE in DATE,
  X_TRANSACTION_QUANTITY in NUMBER,
  X_PRIMARY_QUANTITY in NUMBER,
  X_SERIAL_TRANSACTION_TEMP_ID in NUMBER,
  X_ERROR_CODE in VARCHAR2,
  X_PROCESS_FLAG in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_VENDOR_NAME in VARCHAR2,
  X_SUPPLIER_LOT_NUMBER in VARCHAR2,
  X_ORIGINATION_DATE in DATE,
  X_DATE_CODE in VARCHAR2,
  X_GRADE_CODE in VARCHAR2,
  X_CHANGE_DATE in DATE,
  X_MATURITY_DATE in DATE,
  X_STATUS_ID in NUMBER,
  X_RETEST_DATE in DATE,
  X_AGE in NUMBER,
  X_ITEM_SIZE in NUMBER,
  X_COLOR in VARCHAR2,
  X_VOLUME in NUMBER,
  X_VOLUME_UOM in VARCHAR2,
  X_PLACE_OF_ORIGIN in VARCHAR2,
  X_BEST_BY_DATE in DATE,
  X_LENGTH in NUMBER,
  X_LENGTH_UOM in VARCHAR2,
  X_RECYCLED_CONTENT in NUMBER,
  X_THICKNESS in NUMBER,
  X_THICKNESS_UOM in VARCHAR2,
  X_WIDTH in NUMBER,
  X_WIDTH_UOM in VARCHAR2,
  X_CURL_WRINKLE_FOLD in VARCHAR2,
  X_LOT_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_C_ATTRIBUTE1 in VARCHAR2,
  X_C_ATTRIBUTE2 in VARCHAR2,
  X_C_ATTRIBUTE3 in VARCHAR2,
  X_C_ATTRIBUTE4 in VARCHAR2,
  X_C_ATTRIBUTE5 in VARCHAR2,
  X_C_ATTRIBUTE6 in VARCHAR2,
  X_C_ATTRIBUTE7 in VARCHAR2,
  X_C_ATTRIBUTE8 in VARCHAR2,
  X_C_ATTRIBUTE9 in VARCHAR2,
  X_C_ATTRIBUTE10 in VARCHAR2,
  X_C_ATTRIBUTE11 in VARCHAR2,
  X_C_ATTRIBUTE12 in VARCHAR2,
  X_C_ATTRIBUTE13 in VARCHAR2,
  X_C_ATTRIBUTE14 in VARCHAR2,
  X_C_ATTRIBUTE15 in VARCHAR2,
  X_C_ATTRIBUTE16 in VARCHAR2,
  X_C_ATTRIBUTE17 in VARCHAR2,
  X_C_ATTRIBUTE18 in VARCHAR2,
  X_C_ATTRIBUTE19 in VARCHAR2,
  X_C_ATTRIBUTE20 in VARCHAR2,
  X_D_ATTRIBUTE1 in DATE,
  X_D_ATTRIBUTE2 in DATE,
  X_D_ATTRIBUTE3 in DATE,
  X_D_ATTRIBUTE4 in DATE,
  X_D_ATTRIBUTE5 in DATE,
  X_D_ATTRIBUTE6 in DATE,
  X_D_ATTRIBUTE7 in DATE,
  X_D_ATTRIBUTE8 in DATE,
  X_D_ATTRIBUTE9 in DATE,
  X_D_ATTRIBUTE10 in DATE,
  X_N_ATTRIBUTE1 in NUMBER,
  X_N_ATTRIBUTE2 in NUMBER,
  X_N_ATTRIBUTE3 in NUMBER,
  X_N_ATTRIBUTE4 in NUMBER,
  X_N_ATTRIBUTE5 in NUMBER,
  X_N_ATTRIBUTE6 in NUMBER,
  X_N_ATTRIBUTE7 in NUMBER,
  X_N_ATTRIBUTE8 in NUMBER,
  X_N_ATTRIBUTE9 in NUMBER,
  X_N_ATTRIBUTE10 in NUMBER,
  X_VENDOR_ID in NUMBER,
  X_TERRITORY_CODE in VARCHAR2,
  X_PRODUCT_CODE in VARCHAR2,
  X_PRODUCT_TRANSACTION_ID in NUMBER,
  X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
  X_SUBLOT_NUM in VARCHAR2,
  X_REASON_CODE in VARCHAR2,
  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_ATTRIBUTE15 in VARCHAR2,
  X_LOT_NUMBER 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,
  X_PARENT_OBJECT_TYPE IN NUMBER,
  X_PARENT_OBJECT_ID IN NUMBER,
  X_PARENT_OBJECT_NUMBER IN VARCHAR2,
  X_PARENT_OBJECT_TYPE2 IN NUMBER,
  X_PARENT_OBJECT_ID2 IN NUMBER,
  X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
  X_PARENT_ITEM_ID IN NUMBER
  ) IS
     l_transaction_interface_id NUMBER;

Line: 131

  insert into MTL_TRANSACTION_LOTS_INTERFACE (
    EXPIRATION_ACTION_CODE,
    EXPIRATION_ACTION_DATE,
    HOLD_DATE,
    ORIGINATION_TYPE,
    PARENT_LOT_NUMBER,
    REASON_ID,
    TRANSACTION_INTERFACE_ID,
    SOURCE_CODE,
    SOURCE_LINE_ID,
    REQUEST_ID,
    LOT_EXPIRATION_DATE,
    TRANSACTION_QUANTITY,
    PRIMARY_QUANTITY,
    SERIAL_TRANSACTION_TEMP_ID,
    ERROR_CODE,
    PROCESS_FLAG,
    DESCRIPTION,
    VENDOR_NAME,
    SUPPLIER_LOT_NUMBER,
    ORIGINATION_DATE,
    DATE_CODE,
    GRADE_CODE,
    CHANGE_DATE,
    MATURITY_DATE,
    STATUS_ID,
    RETEST_DATE,
    AGE,
    ITEM_SIZE,
    COLOR,
    VOLUME,
    VOLUME_UOM,
    PLACE_OF_ORIGIN,
    BEST_BY_DATE,
    LENGTH,
    LENGTH_UOM,
    RECYCLED_CONTENT,
    THICKNESS,
    THICKNESS_UOM,
    WIDTH,
    WIDTH_UOM,
    CURL_WRINKLE_FOLD,
    LOT_ATTRIBUTE_CATEGORY,
    C_ATTRIBUTE1,
    C_ATTRIBUTE2,
    C_ATTRIBUTE3,
    C_ATTRIBUTE4,
    C_ATTRIBUTE5,
    C_ATTRIBUTE6,
    C_ATTRIBUTE7,
    C_ATTRIBUTE8,
    C_ATTRIBUTE9,
    C_ATTRIBUTE10,
    C_ATTRIBUTE11,
    C_ATTRIBUTE12,
    C_ATTRIBUTE13,
    C_ATTRIBUTE14,
    C_ATTRIBUTE15,
    C_ATTRIBUTE16,
    C_ATTRIBUTE17,
    C_ATTRIBUTE18,
    C_ATTRIBUTE19,
    C_ATTRIBUTE20,
    D_ATTRIBUTE1,
    D_ATTRIBUTE2,
    D_ATTRIBUTE3,
    D_ATTRIBUTE4,
    D_ATTRIBUTE5,
    D_ATTRIBUTE6,
    D_ATTRIBUTE7,
    D_ATTRIBUTE8,
    D_ATTRIBUTE9,
    D_ATTRIBUTE10,
    N_ATTRIBUTE1,
    N_ATTRIBUTE2,
    N_ATTRIBUTE3,
    N_ATTRIBUTE4,
    N_ATTRIBUTE5,
    N_ATTRIBUTE6,
    N_ATTRIBUTE7,
    N_ATTRIBUTE8,
    N_ATTRIBUTE9,
    N_ATTRIBUTE10,
    VENDOR_ID,
    TERRITORY_CODE,
    PRODUCT_CODE,
    PRODUCT_TRANSACTION_ID,
    SECONDARY_TRANSACTION_QUANTITY,
    SUBLOT_NUM,
    REASON_CODE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    LOT_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    PARENT_OBJECT_TYPE,
    PARENT_OBJECT_ID,
    PARENT_OBJECT_NUMBER,
    PARENT_OBJECT_TYPE2,
    PARENT_OBJECT_ID2,
    PARENT_OBJECT_NUMBER2,
    PARENT_ITEM_ID
  ) values (
    X_EXPIRATION_ACTION_CODE,
    X_EXPIRATION_ACTION_DATE,
    X_HOLD_DATE,
    X_ORIGINATION_TYPE,
    X_PARENT_LOT_NUMBER,
    X_REASON_ID,
    X_TRANSACTION_INTERFACE_ID,
    X_SOURCE_CODE,
    X_SOURCE_LINE_ID,
    X_REQUEST_ID,
    X_LOT_EXPIRATION_DATE,
    X_TRANSACTION_QUANTITY,
    X_PRIMARY_QUANTITY,
    X_SERIAL_TRANSACTION_TEMP_ID,
    X_ERROR_CODE,
    X_PROCESS_FLAG,
    X_DESCRIPTION,
    X_VENDOR_NAME,
    X_SUPPLIER_LOT_NUMBER,
    X_ORIGINATION_DATE,
    X_DATE_CODE,
    X_GRADE_CODE,
    X_CHANGE_DATE,
    X_MATURITY_DATE,
    X_STATUS_ID,
    X_RETEST_DATE,
    X_AGE,
    X_ITEM_SIZE,
    X_COLOR,
    X_VOLUME,
    X_VOLUME_UOM,
    X_PLACE_OF_ORIGIN,
    X_BEST_BY_DATE,
    X_LENGTH,
    X_LENGTH_UOM,
    X_RECYCLED_CONTENT,
    X_THICKNESS,
    X_THICKNESS_UOM,
    X_WIDTH,
    X_WIDTH_UOM,
    X_CURL_WRINKLE_FOLD,
    X_LOT_ATTRIBUTE_CATEGORY,
    X_C_ATTRIBUTE1,
    X_C_ATTRIBUTE2,
    X_C_ATTRIBUTE3,
    X_C_ATTRIBUTE4,
    X_C_ATTRIBUTE5,
    X_C_ATTRIBUTE6,
    X_C_ATTRIBUTE7,
    X_C_ATTRIBUTE8,
    X_C_ATTRIBUTE9,
    X_C_ATTRIBUTE10,
    X_C_ATTRIBUTE11,
    X_C_ATTRIBUTE12,
    X_C_ATTRIBUTE13,
    X_C_ATTRIBUTE14,
    X_C_ATTRIBUTE15,
    X_C_ATTRIBUTE16,
    X_C_ATTRIBUTE17,
    X_C_ATTRIBUTE18,
    X_C_ATTRIBUTE19,
    X_C_ATTRIBUTE20,
    X_D_ATTRIBUTE1,
    X_D_ATTRIBUTE2,
    X_D_ATTRIBUTE3,
    X_D_ATTRIBUTE4,
    X_D_ATTRIBUTE5,
    X_D_ATTRIBUTE6,
    X_D_ATTRIBUTE7,
    X_D_ATTRIBUTE8,
    X_D_ATTRIBUTE9,
    X_D_ATTRIBUTE10,
    X_N_ATTRIBUTE1,
    X_N_ATTRIBUTE2,
    X_N_ATTRIBUTE3,
    X_N_ATTRIBUTE4,
    X_N_ATTRIBUTE5,
    X_N_ATTRIBUTE6,
    X_N_ATTRIBUTE7,
    X_N_ATTRIBUTE8,
    X_N_ATTRIBUTE9,
    X_N_ATTRIBUTE10,
    X_VENDOR_ID,
    X_TERRITORY_CODE,
    X_PRODUCT_CODE,
    X_PRODUCT_TRANSACTION_ID,
    X_SECONDARY_TRANSACTION_QUANTI,
    X_SUBLOT_NUM,
    X_REASON_CODE,
    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_ATTRIBUTE15,
    X_LOT_NUMBER,
    sysdate,
    fnd_global.user_id,
    sysdate,
    fnd_global.user_id,
    fnd_global.login_id,
    X_PARENT_OBJECT_TYPE,
    X_PARENT_OBJECT_ID,
    X_PARENT_OBJECT_NUMBER,
    X_PARENT_OBJECT_TYPE2,
    X_PARENT_OBJECT_ID2,
    X_PARENT_OBJECT_NUMBER2,
    X_PARENT_ITEM_ID
    ) returning ROWID INTO x_rowid;

Line: 371

end INSERT_ROW;

Line: 489

   cursor c is SELECT
      transaction_interface_id,
      EXPIRATION_ACTION_CODE,
      EXPIRATION_ACTION_DATE,
      HOLD_DATE,
      ORIGINATION_TYPE,
      PARENT_LOT_NUMBER,
      REASON_ID,
      SOURCE_CODE,
      SOURCE_LINE_ID,
      REQUEST_ID,
      LOT_EXPIRATION_DATE,
      TRANSACTION_QUANTITY,
      PRIMARY_QUANTITY,
      SERIAL_TRANSACTION_TEMP_ID,
      ERROR_CODE,
      PROCESS_FLAG,
      DESCRIPTION,
      VENDOR_NAME,
      SUPPLIER_LOT_NUMBER,
      ORIGINATION_DATE,
      DATE_CODE,
      GRADE_CODE,
      CHANGE_DATE,
      MATURITY_DATE,
      STATUS_ID,
      RETEST_DATE,
      AGE,
      ITEM_SIZE,
      COLOR,
      VOLUME,
      VOLUME_UOM,
      PLACE_OF_ORIGIN,
      BEST_BY_DATE,
      LENGTH,
      LENGTH_UOM,
      RECYCLED_CONTENT,
      THICKNESS,
      THICKNESS_UOM,
      WIDTH,
      WIDTH_UOM,
      CURL_WRINKLE_FOLD,
      LOT_ATTRIBUTE_CATEGORY,
      C_ATTRIBUTE1,
      C_ATTRIBUTE2,
      C_ATTRIBUTE3,
      C_ATTRIBUTE4,
      C_ATTRIBUTE5,
      C_ATTRIBUTE6,
      C_ATTRIBUTE7,
      C_ATTRIBUTE8,
      C_ATTRIBUTE9,
      C_ATTRIBUTE10,
      C_ATTRIBUTE11,
      C_ATTRIBUTE12,
      C_ATTRIBUTE13,
      C_ATTRIBUTE14,
      C_ATTRIBUTE15,
      C_ATTRIBUTE16,
      C_ATTRIBUTE17,
      C_ATTRIBUTE18,
      C_ATTRIBUTE19,
      C_ATTRIBUTE20,
      D_ATTRIBUTE1,
      D_ATTRIBUTE2,
      D_ATTRIBUTE3,
      D_ATTRIBUTE4,
      D_ATTRIBUTE5,
      D_ATTRIBUTE6,
      D_ATTRIBUTE7,
      D_ATTRIBUTE8,
      D_ATTRIBUTE9,
      D_ATTRIBUTE10,
      N_ATTRIBUTE1,
      N_ATTRIBUTE2,
      N_ATTRIBUTE3,
      N_ATTRIBUTE4,
      N_ATTRIBUTE5,
      N_ATTRIBUTE6,
      N_ATTRIBUTE7,
      N_ATTRIBUTE8,
      N_ATTRIBUTE9,
      N_ATTRIBUTE10,
      VENDOR_ID,
      TERRITORY_CODE,
      PRODUCT_CODE,
      PRODUCT_TRANSACTION_ID,
      SECONDARY_TRANSACTION_QUANTITY,
      SUBLOT_NUM,
      REASON_CODE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      LOT_NUMBER,
      PARENT_OBJECT_TYPE,
      PARENT_OBJECT_ID,
      PARENT_OBJECT_NUMBER,
      PARENT_OBJECT_TYPE2,
      PARENT_OBJECT_ID2,
      PARENT_OBJECT_NUMBER2,
      PARENT_ITEM_ID
     from MTL_TRANSACTION_LOTS_INTERFACE
     where ROWID = X_ROWID
     for update of TRANSACTION_INTERFACE_ID nowait;

Line: 614

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

Line: 854

procedure UPDATE_ROW (
  X_ROWID IN ROWID,
  X_TRANSACTION_INTERFACE_ID in NUMBER,
  X_EXPIRATION_ACTION_CODE in VARCHAR2,
  X_EXPIRATION_ACTION_DATE in DATE,
  X_HOLD_DATE in DATE,
  X_ORIGINATION_TYPE in NUMBER,
  X_PARENT_LOT_NUMBER in VARCHAR2,
  X_REASON_ID in NUMBER,
  X_SOURCE_CODE in VARCHAR2,
  X_SOURCE_LINE_ID in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_LOT_EXPIRATION_DATE in DATE,
  X_TRANSACTION_QUANTITY in NUMBER,
  X_PRIMARY_QUANTITY in NUMBER,
  X_SERIAL_TRANSACTION_TEMP_ID in NUMBER,
  X_ERROR_CODE in VARCHAR2,
  X_PROCESS_FLAG in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_VENDOR_NAME in VARCHAR2,
  X_SUPPLIER_LOT_NUMBER in VARCHAR2,
  X_ORIGINATION_DATE in DATE,
  X_DATE_CODE in VARCHAR2,
  X_GRADE_CODE in VARCHAR2,
  X_CHANGE_DATE in DATE,
  X_MATURITY_DATE in DATE,
  X_STATUS_ID in NUMBER,
  X_RETEST_DATE in DATE,
  X_AGE in NUMBER,
  X_ITEM_SIZE in NUMBER,
  X_COLOR in VARCHAR2,
  X_VOLUME in NUMBER,
  X_VOLUME_UOM in VARCHAR2,
  X_PLACE_OF_ORIGIN in VARCHAR2,
  X_BEST_BY_DATE in DATE,
  X_LENGTH in NUMBER,
  X_LENGTH_UOM in VARCHAR2,
  X_RECYCLED_CONTENT in NUMBER,
  X_THICKNESS in NUMBER,
  X_THICKNESS_UOM in VARCHAR2,
  X_WIDTH in NUMBER,
  X_WIDTH_UOM in VARCHAR2,
  X_CURL_WRINKLE_FOLD in VARCHAR2,
  X_LOT_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_C_ATTRIBUTE1 in VARCHAR2,
  X_C_ATTRIBUTE2 in VARCHAR2,
  X_C_ATTRIBUTE3 in VARCHAR2,
  X_C_ATTRIBUTE4 in VARCHAR2,
  X_C_ATTRIBUTE5 in VARCHAR2,
  X_C_ATTRIBUTE6 in VARCHAR2,
  X_C_ATTRIBUTE7 in VARCHAR2,
  X_C_ATTRIBUTE8 in VARCHAR2,
  X_C_ATTRIBUTE9 in VARCHAR2,
  X_C_ATTRIBUTE10 in VARCHAR2,
  X_C_ATTRIBUTE11 in VARCHAR2,
  X_C_ATTRIBUTE12 in VARCHAR2,
  X_C_ATTRIBUTE13 in VARCHAR2,
  X_C_ATTRIBUTE14 in VARCHAR2,
  X_C_ATTRIBUTE15 in VARCHAR2,
  X_C_ATTRIBUTE16 in VARCHAR2,
  X_C_ATTRIBUTE17 in VARCHAR2,
  X_C_ATTRIBUTE18 in VARCHAR2,
  X_C_ATTRIBUTE19 in VARCHAR2,
  X_C_ATTRIBUTE20 in VARCHAR2,
  X_D_ATTRIBUTE1 in DATE,
  X_D_ATTRIBUTE2 in DATE,
  X_D_ATTRIBUTE3 in DATE,
  X_D_ATTRIBUTE4 in DATE,
  X_D_ATTRIBUTE5 in DATE,
  X_D_ATTRIBUTE6 in DATE,
  X_D_ATTRIBUTE7 in DATE,
  X_D_ATTRIBUTE8 in DATE,
  X_D_ATTRIBUTE9 in DATE,
  X_D_ATTRIBUTE10 in DATE,
  X_N_ATTRIBUTE1 in NUMBER,
  X_N_ATTRIBUTE2 in NUMBER,
  X_N_ATTRIBUTE3 in NUMBER,
  X_N_ATTRIBUTE4 in NUMBER,
  X_N_ATTRIBUTE5 in NUMBER,
  X_N_ATTRIBUTE6 in NUMBER,
  X_N_ATTRIBUTE7 in NUMBER,
  X_N_ATTRIBUTE8 in NUMBER,
  X_N_ATTRIBUTE9 in NUMBER,
  X_N_ATTRIBUTE10 in NUMBER,
  X_VENDOR_ID in NUMBER,
  X_TERRITORY_CODE in VARCHAR2,
  X_PRODUCT_CODE in VARCHAR2,
  X_PRODUCT_TRANSACTION_ID in NUMBER,
  X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
  X_SUBLOT_NUM in VARCHAR2,
  X_REASON_CODE in VARCHAR2,
  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_ATTRIBUTE15 in VARCHAR2,
  X_LOT_NUMBER in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_PARENT_OBJECT_TYPE IN NUMBER,
  X_PARENT_OBJECT_ID IN NUMBER,
  X_PARENT_OBJECT_NUMBER IN VARCHAR2,
  X_PARENT_OBJECT_TYPE2 IN NUMBER,
  X_PARENT_OBJECT_ID2 IN NUMBER,
  X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
  X_PARENT_ITEM_ID IN NUMBER
) is
begin
   update MTL_TRANSACTION_LOTS_INTERFACE SET
     TRANSACTION_INTERFACE_ID=X_TRANSACTION_INTERFACE_ID,
    EXPIRATION_ACTION_CODE = X_EXPIRATION_ACTION_CODE,
    EXPIRATION_ACTION_DATE = X_EXPIRATION_ACTION_DATE,
    HOLD_DATE = X_HOLD_DATE,
    ORIGINATION_TYPE = X_ORIGINATION_TYPE,
    PARENT_LOT_NUMBER = X_PARENT_LOT_NUMBER,
    REASON_ID = X_REASON_ID,
    SOURCE_CODE = X_SOURCE_CODE,
    SOURCE_LINE_ID = X_SOURCE_LINE_ID,
    REQUEST_ID = X_REQUEST_ID,
    LOT_EXPIRATION_DATE = X_LOT_EXPIRATION_DATE,
    TRANSACTION_QUANTITY = X_TRANSACTION_QUANTITY,
    PRIMARY_QUANTITY = X_PRIMARY_QUANTITY,
    SERIAL_TRANSACTION_TEMP_ID = X_SERIAL_TRANSACTION_TEMP_ID,
    ERROR_CODE = X_ERROR_CODE,
    PROCESS_FLAG = X_PROCESS_FLAG,
    DESCRIPTION = X_DESCRIPTION,
    VENDOR_NAME = X_VENDOR_NAME,
    SUPPLIER_LOT_NUMBER = X_SUPPLIER_LOT_NUMBER,
    ORIGINATION_DATE = X_ORIGINATION_DATE,
    DATE_CODE = X_DATE_CODE,
    GRADE_CODE = X_GRADE_CODE,
    CHANGE_DATE = X_CHANGE_DATE,
    MATURITY_DATE = X_MATURITY_DATE,
    STATUS_ID = X_STATUS_ID,
    RETEST_DATE = X_RETEST_DATE,
    AGE = X_AGE,
    ITEM_SIZE = X_ITEM_SIZE,
    COLOR = X_COLOR,
    VOLUME = X_VOLUME,
    VOLUME_UOM = X_VOLUME_UOM,
    PLACE_OF_ORIGIN = X_PLACE_OF_ORIGIN,
    BEST_BY_DATE = X_BEST_BY_DATE,
    LENGTH = X_LENGTH,
    LENGTH_UOM = X_LENGTH_UOM,
    RECYCLED_CONTENT = X_RECYCLED_CONTENT,
    THICKNESS = X_THICKNESS,
    THICKNESS_UOM = X_THICKNESS_UOM,
    WIDTH = X_WIDTH,
    WIDTH_UOM = X_WIDTH_UOM,
    CURL_WRINKLE_FOLD = X_CURL_WRINKLE_FOLD,
    LOT_ATTRIBUTE_CATEGORY = X_LOT_ATTRIBUTE_CATEGORY,
    C_ATTRIBUTE1 = X_C_ATTRIBUTE1,
    C_ATTRIBUTE2 = X_C_ATTRIBUTE2,
    C_ATTRIBUTE3 = X_C_ATTRIBUTE3,
    C_ATTRIBUTE4 = X_C_ATTRIBUTE4,
    C_ATTRIBUTE5 = X_C_ATTRIBUTE5,
    C_ATTRIBUTE6 = X_C_ATTRIBUTE6,
    C_ATTRIBUTE7 = X_C_ATTRIBUTE7,
    C_ATTRIBUTE8 = X_C_ATTRIBUTE8,
    C_ATTRIBUTE9 = X_C_ATTRIBUTE9,
    C_ATTRIBUTE10 = X_C_ATTRIBUTE10,
    C_ATTRIBUTE11 = X_C_ATTRIBUTE11,
    C_ATTRIBUTE12 = X_C_ATTRIBUTE12,
    C_ATTRIBUTE13 = X_C_ATTRIBUTE13,
    C_ATTRIBUTE14 = X_C_ATTRIBUTE14,
    C_ATTRIBUTE15 = X_C_ATTRIBUTE15,
    C_ATTRIBUTE16 = X_C_ATTRIBUTE16,
    C_ATTRIBUTE17 = X_C_ATTRIBUTE17,
    C_ATTRIBUTE18 = X_C_ATTRIBUTE18,
    C_ATTRIBUTE19 = X_C_ATTRIBUTE19,
    C_ATTRIBUTE20 = X_C_ATTRIBUTE20,
    D_ATTRIBUTE1 = X_D_ATTRIBUTE1,
    D_ATTRIBUTE2 = X_D_ATTRIBUTE2,
    D_ATTRIBUTE3 = X_D_ATTRIBUTE3,
    D_ATTRIBUTE4 = X_D_ATTRIBUTE4,
    D_ATTRIBUTE5 = X_D_ATTRIBUTE5,
    D_ATTRIBUTE6 = X_D_ATTRIBUTE6,
    D_ATTRIBUTE7 = X_D_ATTRIBUTE7,
    D_ATTRIBUTE8 = X_D_ATTRIBUTE8,
    D_ATTRIBUTE9 = X_D_ATTRIBUTE9,
    D_ATTRIBUTE10 = X_D_ATTRIBUTE10,
    N_ATTRIBUTE1 = X_N_ATTRIBUTE1,
    N_ATTRIBUTE2 = X_N_ATTRIBUTE2,
    N_ATTRIBUTE3 = X_N_ATTRIBUTE3,
    N_ATTRIBUTE4 = X_N_ATTRIBUTE4,
    N_ATTRIBUTE5 = X_N_ATTRIBUTE5,
    N_ATTRIBUTE6 = X_N_ATTRIBUTE6,
    N_ATTRIBUTE7 = X_N_ATTRIBUTE7,
    N_ATTRIBUTE8 = X_N_ATTRIBUTE8,
    N_ATTRIBUTE9 = X_N_ATTRIBUTE9,
    N_ATTRIBUTE10 = X_N_ATTRIBUTE10,
    VENDOR_ID = X_VENDOR_ID,
    TERRITORY_CODE = X_TERRITORY_CODE,
    PRODUCT_CODE = X_PRODUCT_CODE,
    PRODUCT_TRANSACTION_ID = X_PRODUCT_TRANSACTION_ID,
    SECONDARY_TRANSACTION_QUANTITY = X_SECONDARY_TRANSACTION_QUANTI,
    SUBLOT_NUM = X_SUBLOT_NUM,
    REASON_CODE = X_REASON_CODE,
    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,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    lot_number = x_lot_number,
    LAST_UPDATE_DATE = sysdate,
    LAST_UPDATED_BY = fnd_global.user_id,
    LAST_UPDATE_LOGIN =  fnd_global.login_id,
    PARENT_OBJECT_TYPE   =  X_PARENT_OBJECT_TYPE,
    PARENT_OBJECT_ID   =  X_PARENT_OBJECT_ID,
    PARENT_OBJECT_NUMBER   =  X_PARENT_OBJECT_NUMBER,
    PARENT_OBJECT_TYPE2   =  X_PARENT_OBJECT_TYPE2,
    PARENT_OBJECT_ID2   =  X_PARENT_OBJECT_ID2,
    PARENT_OBJECT_NUMBER2   =  X_PARENT_OBJECT_NUMBER2,
    PARENT_ITEM_ID   =  X_PARENT_ITEM_ID
    where ROWID = X_ROWID;

Line: 1094

      insert into MTL_TRANSACTION_LOTS_INTERFACE (
    EXPIRATION_ACTION_CODE,
    EXPIRATION_ACTION_DATE,
    HOLD_DATE,
    ORIGINATION_TYPE,
    PARENT_LOT_NUMBER,
    REASON_ID,
    TRANSACTION_INTERFACE_ID,
    SOURCE_CODE,
    SOURCE_LINE_ID,
    REQUEST_ID,
    LOT_EXPIRATION_DATE,
    TRANSACTION_QUANTITY,
    PRIMARY_QUANTITY,
    SERIAL_TRANSACTION_TEMP_ID,
    ERROR_CODE,
    PROCESS_FLAG,
    DESCRIPTION,
    VENDOR_NAME,
    SUPPLIER_LOT_NUMBER,
    ORIGINATION_DATE,
    DATE_CODE,
    GRADE_CODE,
    CHANGE_DATE,
    MATURITY_DATE,
    STATUS_ID,
    RETEST_DATE,
    AGE,
    ITEM_SIZE,
    COLOR,
    VOLUME,
    VOLUME_UOM,
    PLACE_OF_ORIGIN,
    BEST_BY_DATE,
    LENGTH,
    LENGTH_UOM,
    RECYCLED_CONTENT,
    THICKNESS,
    THICKNESS_UOM,
    WIDTH,
    WIDTH_UOM,
    CURL_WRINKLE_FOLD,
    LOT_ATTRIBUTE_CATEGORY,
    C_ATTRIBUTE1,
    C_ATTRIBUTE2,
    C_ATTRIBUTE3,
    C_ATTRIBUTE4,
    C_ATTRIBUTE5,
    C_ATTRIBUTE6,
    C_ATTRIBUTE7,
    C_ATTRIBUTE8,
    C_ATTRIBUTE9,
    C_ATTRIBUTE10,
    C_ATTRIBUTE11,
    C_ATTRIBUTE12,
    C_ATTRIBUTE13,
    C_ATTRIBUTE14,
    C_ATTRIBUTE15,
    C_ATTRIBUTE16,
    C_ATTRIBUTE17,
    C_ATTRIBUTE18,
    C_ATTRIBUTE19,
    C_ATTRIBUTE20,
    D_ATTRIBUTE1,
    D_ATTRIBUTE2,
    D_ATTRIBUTE3,
    D_ATTRIBUTE4,
    D_ATTRIBUTE5,
    D_ATTRIBUTE6,
    D_ATTRIBUTE7,
    D_ATTRIBUTE8,
    D_ATTRIBUTE9,
    D_ATTRIBUTE10,
    N_ATTRIBUTE1,
    N_ATTRIBUTE2,
    N_ATTRIBUTE3,
    N_ATTRIBUTE4,
    N_ATTRIBUTE5,
    N_ATTRIBUTE6,
    N_ATTRIBUTE7,
    N_ATTRIBUTE8,
    N_ATTRIBUTE9,
    N_ATTRIBUTE10,
    VENDOR_ID,
    TERRITORY_CODE,
    PRODUCT_CODE,
    PRODUCT_TRANSACTION_ID,
    SECONDARY_TRANSACTION_QUANTITY,
    SUBLOT_NUM,
    REASON_CODE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    LOT_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    PARENT_OBJECT_TYPE,
    PARENT_OBJECT_ID,
    PARENT_OBJECT_NUMBER,
    PARENT_OBJECT_TYPE2,
    PARENT_OBJECT_ID2,
    PARENT_OBJECT_NUMBER2,
    PARENT_ITEM_ID
  ) values (
    X_EXPIRATION_ACTION_CODE,
    X_EXPIRATION_ACTION_DATE,
    X_HOLD_DATE,
    X_ORIGINATION_TYPE,
    X_PARENT_LOT_NUMBER,
    X_REASON_ID,
    X_TRANSACTION_INTERFACE_ID,
    X_SOURCE_CODE,
    X_SOURCE_LINE_ID,
    X_REQUEST_ID,
    X_LOT_EXPIRATION_DATE,
    X_TRANSACTION_QUANTITY,
    X_PRIMARY_QUANTITY,
    X_SERIAL_TRANSACTION_TEMP_ID,
    X_ERROR_CODE,
    X_PROCESS_FLAG,
    X_DESCRIPTION,
    X_VENDOR_NAME,
    X_SUPPLIER_LOT_NUMBER,
    X_ORIGINATION_DATE,
    X_DATE_CODE,
    X_GRADE_CODE,
    X_CHANGE_DATE,
    X_MATURITY_DATE,
    X_STATUS_ID,
    X_RETEST_DATE,
    X_AGE,
    X_ITEM_SIZE,
    X_COLOR,
    X_VOLUME,
    X_VOLUME_UOM,
    X_PLACE_OF_ORIGIN,
    X_BEST_BY_DATE,
    X_LENGTH,
    X_LENGTH_UOM,
    X_RECYCLED_CONTENT,
    X_THICKNESS,
    X_THICKNESS_UOM,
    X_WIDTH,
    X_WIDTH_UOM,
    X_CURL_WRINKLE_FOLD,
    X_LOT_ATTRIBUTE_CATEGORY,
    X_C_ATTRIBUTE1,
    X_C_ATTRIBUTE2,
    X_C_ATTRIBUTE3,
    X_C_ATTRIBUTE4,
    X_C_ATTRIBUTE5,
    X_C_ATTRIBUTE6,
    X_C_ATTRIBUTE7,
    X_C_ATTRIBUTE8,
    X_C_ATTRIBUTE9,
    X_C_ATTRIBUTE10,
    X_C_ATTRIBUTE11,
    X_C_ATTRIBUTE12,
    X_C_ATTRIBUTE13,
    X_C_ATTRIBUTE14,
    X_C_ATTRIBUTE15,
    X_C_ATTRIBUTE16,
    X_C_ATTRIBUTE17,
    X_C_ATTRIBUTE18,
    X_C_ATTRIBUTE19,
    X_C_ATTRIBUTE20,
    X_D_ATTRIBUTE1,
    X_D_ATTRIBUTE2,
    X_D_ATTRIBUTE3,
    X_D_ATTRIBUTE4,
    X_D_ATTRIBUTE5,
    X_D_ATTRIBUTE6,
    X_D_ATTRIBUTE7,
    X_D_ATTRIBUTE8,
    X_D_ATTRIBUTE9,
    X_D_ATTRIBUTE10,
    X_N_ATTRIBUTE1,
    X_N_ATTRIBUTE2,
    X_N_ATTRIBUTE3,
    X_N_ATTRIBUTE4,
    X_N_ATTRIBUTE5,
    X_N_ATTRIBUTE6,
    X_N_ATTRIBUTE7,
    X_N_ATTRIBUTE8,
    X_N_ATTRIBUTE9,
    X_N_ATTRIBUTE10,
    X_VENDOR_ID,
    X_TERRITORY_CODE,
    X_PRODUCT_CODE,
    X_PRODUCT_TRANSACTION_ID,
    X_SECONDARY_TRANSACTION_QUANTI,
    X_SUBLOT_NUM,
    X_REASON_CODE,
    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_ATTRIBUTE15,
    x_lot_number,
    sysdate,
    fnd_global.user_id,
    sysdate,
    fnd_global.user_id,
    fnd_global.login_id,
    X_PARENT_OBJECT_TYPE,
    X_PARENT_OBJECT_ID,
    X_PARENT_OBJECT_NUMBER,
    X_PARENT_OBJECT_TYPE2,
    X_PARENT_OBJECT_ID2,
    X_PARENT_OBJECT_NUMBER2,
    X_PARENT_ITEM_ID
    );

Line: 1335

end UPDATE_ROW;

Line: 1337

procedure DELETE_ROW (
  X_ROWID IN ROWID
) is
begin

   delete from MTL_TRANSACTION_LOTS_INTERFACE
  where ROWID = X_ROWID;

Line: 1348

end DELETE_ROW;