APPS.MTL_SERIAL_NUMBERS_INTERF_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_PRODUCT_TRANSACTION_ID in NUMBER,
  X_SOURCE_CODE in VARCHAR2,
  X_SOURCE_LINE_ID in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_VENDOR_SERIAL_NUMBER in VARCHAR2,
  X_VENDOR_LOT_NUMBER in VARCHAR2,
  X_TO_SERIAL_NUMBER in VARCHAR2,
  X_ERROR_CODE in VARCHAR2,
  X_PROCESS_FLAG in NUMBER,
  X_PARENT_SERIAL_NUMBER in VARCHAR2,
  X_SERIAL_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ORIGINATION_DATE in DATE,
  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_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_D_ATTRIBUTE11 in DATE,
  X_D_ATTRIBUTE12 in DATE,
  X_D_ATTRIBUTE13 in DATE,
  X_D_ATTRIBUTE14 in DATE,
  X_D_ATTRIBUTE15 in DATE,
  X_D_ATTRIBUTE16 in DATE,
  X_D_ATTRIBUTE17 in DATE,
  X_D_ATTRIBUTE18 in DATE,
  X_D_ATTRIBUTE19 in DATE,
  X_D_ATTRIBUTE20 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_STATUS_ID in NUMBER,
  X_TERRITORY_CODE in VARCHAR2,
  X_TIME_SINCE_NEW in NUMBER,
  X_CYCLES_SINCE_NEW in NUMBER,
  X_TIME_SINCE_OVERHAUL in NUMBER,
  X_CYCLES_SINCE_OVERHAUL in NUMBER,
  X_TIME_SINCE_REPAIR in NUMBER,
  X_CYCLES_SINCE_REPAIR in NUMBER,
  X_TIME_SINCE_VISIT in NUMBER,
  X_CYCLES_SINCE_VISIT in NUMBER,
  X_TIME_SINCE_MARK in NUMBER,
  X_CYCLES_SINCE_MARK in NUMBER,
  X_NUMBER_OF_REPAIRS in NUMBER,
  X_STATUS_NAME in VARCHAR2,
  X_C_ATTRIBUTE17 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_PRODUCT_CODE in VARCHAR2,
  X_FM_SERIAL_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: 120

  insert into MTL_SERIAL_NUMBERS_INTERFACE (
    PRODUCT_TRANSACTION_ID,
    TRANSACTION_INTERFACE_ID,
    SOURCE_CODE,
    SOURCE_LINE_ID,
    REQUEST_ID,
    VENDOR_SERIAL_NUMBER,
    VENDOR_LOT_NUMBER,
    TO_SERIAL_NUMBER,
    ERROR_CODE,
    PROCESS_FLAG,
    PARENT_SERIAL_NUMBER,
    SERIAL_ATTRIBUTE_CATEGORY,
    ORIGINATION_DATE,
    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_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,
    --D_ATTRIBUTE11,
    --D_ATTRIBUTE12,
    --D_ATTRIBUTE13,
    --D_ATTRIBUTE14,
    --D_ATTRIBUTE15,
    --D_ATTRIBUTE16,
    --D_ATTRIBUTE17,
    --D_ATTRIBUTE18,
    --D_ATTRIBUTE19,
    --D_ATTRIBUTE20,
    N_ATTRIBUTE1,
    N_ATTRIBUTE2,
    N_ATTRIBUTE3,
    N_ATTRIBUTE4,
    N_ATTRIBUTE5,
    N_ATTRIBUTE6,
    N_ATTRIBUTE7,
    N_ATTRIBUTE8,
    N_ATTRIBUTE9,
    N_ATTRIBUTE10,
    STATUS_ID,
    TERRITORY_CODE,
    TIME_SINCE_NEW,
    CYCLES_SINCE_NEW,
    TIME_SINCE_OVERHAUL,
    CYCLES_SINCE_OVERHAUL,
    TIME_SINCE_REPAIR,
    CYCLES_SINCE_REPAIR,
    TIME_SINCE_VISIT,
    CYCLES_SINCE_VISIT,
    TIME_SINCE_MARK,
    CYCLES_SINCE_MARK,
    NUMBER_OF_REPAIRS,
    STATUS_NAME,
    C_ATTRIBUTE17,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    PRODUCT_CODE,
    FM_SERIAL_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_PRODUCT_TRANSACTION_ID,
    X_TRANSACTION_INTERFACE_ID,
    X_SOURCE_CODE,
    X_SOURCE_LINE_ID,
    X_REQUEST_ID,
    X_VENDOR_SERIAL_NUMBER,
    X_VENDOR_LOT_NUMBER,
    X_TO_SERIAL_NUMBER,
    X_ERROR_CODE,
    X_PROCESS_FLAG,
    X_PARENT_SERIAL_NUMBER,
    X_SERIAL_ATTRIBUTE_CATEGORY,
    X_ORIGINATION_DATE,
    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_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_D_ATTRIBUTE11,
    --X_D_ATTRIBUTE12,
    --X_D_ATTRIBUTE13,
    --X_D_ATTRIBUTE14,
    --X_D_ATTRIBUTE15,
    --X_D_ATTRIBUTE16,
    --X_D_ATTRIBUTE17,
    --X_D_ATTRIBUTE18,
    --X_D_ATTRIBUTE19,
    --X_D_ATTRIBUTE20,
    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_STATUS_ID,
    X_TERRITORY_CODE,
    X_TIME_SINCE_NEW,
    X_CYCLES_SINCE_NEW,
    X_TIME_SINCE_OVERHAUL,
    X_CYCLES_SINCE_OVERHAUL,
    X_TIME_SINCE_REPAIR,
    X_CYCLES_SINCE_REPAIR,
    X_TIME_SINCE_VISIT,
    X_CYCLES_SINCE_VISIT,
    X_TIME_SINCE_MARK,
    X_CYCLES_SINCE_MARK,
    X_NUMBER_OF_REPAIRS,
    X_STATUS_NAME,
    X_C_ATTRIBUTE17,
    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_PRODUCT_CODE,
    x_fm_serial_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: 338

end INSERT_ROW;

Line: 445

   cursor c is SELECT
     transaction_interface_id,
      PRODUCT_TRANSACTION_ID,
      SOURCE_CODE,
      SOURCE_LINE_ID,
      REQUEST_ID,
      VENDOR_SERIAL_NUMBER,
      VENDOR_LOT_NUMBER,
      TO_SERIAL_NUMBER,
      ERROR_CODE,
      PROCESS_FLAG,
      PARENT_SERIAL_NUMBER,
      SERIAL_ATTRIBUTE_CATEGORY,
      ORIGINATION_DATE,
      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_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,
      --D_ATTRIBUTE11,
      --D_ATTRIBUTE12,
      --D_ATTRIBUTE13,
      --D_ATTRIBUTE14,
      --D_ATTRIBUTE15,
      --D_ATTRIBUTE16,
      --D_ATTRIBUTE17,
      --D_ATTRIBUTE18,
      --D_ATTRIBUTE19,
      --D_ATTRIBUTE20,
      N_ATTRIBUTE1,
      N_ATTRIBUTE2,
      N_ATTRIBUTE3,
      N_ATTRIBUTE4,
      N_ATTRIBUTE5,
      N_ATTRIBUTE6,
      N_ATTRIBUTE7,
      N_ATTRIBUTE8,
      N_ATTRIBUTE9,
      N_ATTRIBUTE10,
      STATUS_ID,
      TERRITORY_CODE,
      TIME_SINCE_NEW,
      CYCLES_SINCE_NEW,
      TIME_SINCE_OVERHAUL,
      CYCLES_SINCE_OVERHAUL,
      TIME_SINCE_REPAIR,
      CYCLES_SINCE_REPAIR,
      TIME_SINCE_VISIT,
      CYCLES_SINCE_VISIT,
      TIME_SINCE_MARK,
      CYCLES_SINCE_MARK,
      NUMBER_OF_REPAIRS,
      STATUS_NAME,
      C_ATTRIBUTE17,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
     product_code,
     FM_SERIAL_NUMBER,
      PARENT_OBJECT_TYPE,
      PARENT_OBJECT_ID,
      PARENT_OBJECT_NUMBER,
      PARENT_OBJECT_TYPE2,
      PARENT_OBJECT_ID2,
      PARENT_OBJECT_NUMBER2,
      PARENT_ITEM_ID
    from MTL_SERIAL_NUMBERS_INTERFACE
    where ROWID=X_ROWID
    for update of TRANSACTION_INTERFACE_ID nowait;

Line: 558

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

Line: 777

procedure UPDATE_ROW (
  X_ROWID IN ROWID,
  X_TRANSACTION_INTERFACE_ID in NUMBER,
  X_PRODUCT_TRANSACTION_ID in NUMBER,
  X_SOURCE_CODE in VARCHAR2,
  X_SOURCE_LINE_ID in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_VENDOR_SERIAL_NUMBER in VARCHAR2,
  X_VENDOR_LOT_NUMBER in VARCHAR2,
  X_TO_SERIAL_NUMBER in VARCHAR2,
  X_ERROR_CODE in VARCHAR2,
  X_PROCESS_FLAG in NUMBER,
  X_PARENT_SERIAL_NUMBER in VARCHAR2,
  X_SERIAL_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ORIGINATION_DATE in DATE,
  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_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_D_ATTRIBUTE11 in DATE,
  X_D_ATTRIBUTE12 in DATE,
  X_D_ATTRIBUTE13 in DATE,
  X_D_ATTRIBUTE14 in DATE,
  X_D_ATTRIBUTE15 in DATE,
  X_D_ATTRIBUTE16 in DATE,
  X_D_ATTRIBUTE17 in DATE,
  X_D_ATTRIBUTE18 in DATE,
  X_D_ATTRIBUTE19 in DATE,
  X_D_ATTRIBUTE20 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_STATUS_ID in NUMBER,
  X_TERRITORY_CODE in VARCHAR2,
  X_TIME_SINCE_NEW in NUMBER,
  X_CYCLES_SINCE_NEW in NUMBER,
  X_TIME_SINCE_OVERHAUL in NUMBER,
  X_CYCLES_SINCE_OVERHAUL in NUMBER,
  X_TIME_SINCE_REPAIR in NUMBER,
  X_CYCLES_SINCE_REPAIR in NUMBER,
  X_TIME_SINCE_VISIT in NUMBER,
  X_CYCLES_SINCE_VISIT in NUMBER,
  X_TIME_SINCE_MARK in NUMBER,
  X_CYCLES_SINCE_MARK in NUMBER,
  X_NUMBER_OF_REPAIRS in NUMBER,
  X_STATUS_NAME in VARCHAR2,
  X_C_ATTRIBUTE17 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_PRODUCT_CODE in VARCHAR2,
  X_FM_SERIAL_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_SERIAL_NUMBERS_INTERFACE SET
     transaction_interface_id = x_transaction_interface_id,
    PRODUCT_TRANSACTION_ID = X_PRODUCT_TRANSACTION_ID,
    SOURCE_CODE = X_SOURCE_CODE,
    SOURCE_LINE_ID = X_SOURCE_LINE_ID,
    REQUEST_ID = X_REQUEST_ID,
    VENDOR_SERIAL_NUMBER = X_VENDOR_SERIAL_NUMBER,
    VENDOR_LOT_NUMBER = X_VENDOR_LOT_NUMBER,
    TO_SERIAL_NUMBER = X_TO_SERIAL_NUMBER,
    ERROR_CODE = X_ERROR_CODE,
    PROCESS_FLAG = X_PROCESS_FLAG,
    PARENT_SERIAL_NUMBER = X_PARENT_SERIAL_NUMBER,
    SERIAL_ATTRIBUTE_CATEGORY = X_SERIAL_ATTRIBUTE_CATEGORY,
    ORIGINATION_DATE = X_ORIGINATION_DATE,
    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_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,
    --D_ATTRIBUTE11 = X_D_ATTRIBUTE11,
    --D_ATTRIBUTE12 = X_D_ATTRIBUTE12,
    --D_ATTRIBUTE13 = X_D_ATTRIBUTE13,
    --D_ATTRIBUTE14 = X_D_ATTRIBUTE14,
    --D_ATTRIBUTE15 = X_D_ATTRIBUTE15,
    --D_ATTRIBUTE16 = X_D_ATTRIBUTE16,
    --D_ATTRIBUTE17 = X_D_ATTRIBUTE17,
    --D_ATTRIBUTE18 = X_D_ATTRIBUTE18,
    --D_ATTRIBUTE19 = X_D_ATTRIBUTE19,
    --D_ATTRIBUTE20 = X_D_ATTRIBUTE20,
    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,
    STATUS_ID = X_STATUS_ID,
    TERRITORY_CODE = X_TERRITORY_CODE,
    TIME_SINCE_NEW = X_TIME_SINCE_NEW,
    CYCLES_SINCE_NEW = X_CYCLES_SINCE_NEW,
    TIME_SINCE_OVERHAUL = X_TIME_SINCE_OVERHAUL,
    CYCLES_SINCE_OVERHAUL = X_CYCLES_SINCE_OVERHAUL,
    TIME_SINCE_REPAIR = X_TIME_SINCE_REPAIR,
    CYCLES_SINCE_REPAIR = X_CYCLES_SINCE_REPAIR,
    TIME_SINCE_VISIT = X_TIME_SINCE_VISIT,
    CYCLES_SINCE_VISIT = X_CYCLES_SINCE_VISIT,
    TIME_SINCE_MARK = X_TIME_SINCE_MARK,
    CYCLES_SINCE_MARK = X_CYCLES_SINCE_MARK,
    NUMBER_OF_REPAIRS = X_NUMBER_OF_REPAIRS,
    STATUS_NAME = X_STATUS_NAME,
    C_ATTRIBUTE17 = X_C_ATTRIBUTE17,
    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,
     PRODUCT_CODE = X_PRODUCT_CODE,
     fm_serial_number = x_fm_serial_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: 995

     insert into MTL_SERIAL_NUMBERS_INTERFACE
       (
    PRODUCT_TRANSACTION_ID,
    TRANSACTION_INTERFACE_ID,
    SOURCE_CODE,
    SOURCE_LINE_ID,
    REQUEST_ID,
    VENDOR_SERIAL_NUMBER,
    VENDOR_LOT_NUMBER,
    TO_SERIAL_NUMBER,
    ERROR_CODE,
    PROCESS_FLAG,
    PARENT_SERIAL_NUMBER,
    SERIAL_ATTRIBUTE_CATEGORY,
    ORIGINATION_DATE,
    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_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,
    --D_ATTRIBUTE11,
    --D_ATTRIBUTE12,
    --D_ATTRIBUTE13,
    --D_ATTRIBUTE14,
    --D_ATTRIBUTE15,
    --D_ATTRIBUTE16,
    --D_ATTRIBUTE17,
    --D_ATTRIBUTE18,
    --D_ATTRIBUTE19,
    --D_ATTRIBUTE20,
    N_ATTRIBUTE1,
    N_ATTRIBUTE2,
    N_ATTRIBUTE3,
    N_ATTRIBUTE4,
    N_ATTRIBUTE5,
    N_ATTRIBUTE6,
    N_ATTRIBUTE7,
    N_ATTRIBUTE8,
    N_ATTRIBUTE9,
    N_ATTRIBUTE10,
    STATUS_ID,
    TERRITORY_CODE,
    TIME_SINCE_NEW,
    CYCLES_SINCE_NEW,
    TIME_SINCE_OVERHAUL,
    CYCLES_SINCE_OVERHAUL,
    TIME_SINCE_REPAIR,
    CYCLES_SINCE_REPAIR,
    TIME_SINCE_VISIT,
    CYCLES_SINCE_VISIT,
    TIME_SINCE_MARK,
    CYCLES_SINCE_MARK,
    NUMBER_OF_REPAIRS,
    STATUS_NAME,
    C_ATTRIBUTE17,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    PRODUCT_CODE,
    fm_serial_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_PRODUCT_TRANSACTION_ID,
    X_TRANSACTION_INTERFACE_ID,
    X_SOURCE_CODE,
    X_SOURCE_LINE_ID,
    X_REQUEST_ID,
    X_VENDOR_SERIAL_NUMBER,
    X_VENDOR_LOT_NUMBER,
    X_TO_SERIAL_NUMBER,
    X_ERROR_CODE,
    X_PROCESS_FLAG,
    X_PARENT_SERIAL_NUMBER,
    X_SERIAL_ATTRIBUTE_CATEGORY,
    X_ORIGINATION_DATE,
    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_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_D_ATTRIBUTE11,
    --X_D_ATTRIBUTE12,
    --X_D_ATTRIBUTE13,
    --x_D_ATTRIBUTE14,
    --X_D_ATTRIBUTE15,
    --X_D_ATTRIBUTE16,
    --X_D_ATTRIBUTE17,
    --X_D_ATTRIBUTE18,
    --X_D_ATTRIBUTE19,
    --X_D_ATTRIBUTE20,
    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_STATUS_ID,
    X_TERRITORY_CODE,
    X_TIME_SINCE_NEW,
    X_CYCLES_SINCE_NEW,
    X_TIME_SINCE_OVERHAUL,
    X_CYCLES_SINCE_OVERHAUL,
    X_TIME_SINCE_REPAIR,
    X_CYCLES_SINCE_REPAIR,
    X_TIME_SINCE_VISIT,
    X_CYCLES_SINCE_VISIT,
    X_TIME_SINCE_MARK,
    X_CYCLES_SINCE_MARK,
    X_NUMBER_OF_REPAIRS,
    X_STATUS_NAME,
    X_C_ATTRIBUTE17,
    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_PRODUCT_CODE,
    x_fm_serial_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: 1215

end UPDATE_ROW;

Line: 1217

procedure DELETE_ROW (
  X_ROWID IN ROWID
) is
begin
  delete from MTL_SERIAL_NUMBERS_INTERFACE
  where ROWID=X_ROWID;

Line: 1227

end DELETE_ROW;