326: ) VALUES (
327: AHL_PRD_DISP_MTL_TXNS_S.nextval,
328: 1,
329: sysdate,
330: fnd_global.user_id,
331: sysdate,
332: fnd_global.user_id,
333: fnd_global.login_id,
334: l_disp_mx_rec.disposition_id,
328: 1,
329: sysdate,
330: fnd_global.user_id,
331: sysdate,
332: fnd_global.user_id,
333: fnd_global.login_id,
334: l_disp_mx_rec.disposition_id,
335: l_disp_mx_rec.wo_mtl_txn_id,
336: l_disp_mx_rec.quantity,
329: sysdate,
330: fnd_global.user_id,
331: sysdate,
332: fnd_global.user_id,
333: fnd_global.login_id,
334: l_disp_mx_rec.disposition_id,
335: l_disp_mx_rec.wo_mtl_txn_id,
336: l_disp_mx_rec.quantity,
337: l_disp_mx_rec.uom,
473: --UPDATE existing record
474: UPDATE ahl_prd_disp_mtl_txns SET
475: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
476: LAST_UPDATE_DATE = sysdate,
477: LAST_UPDATED_BY = fnd_global.USER_ID,
478: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,
479: QUANTITY = l_disp_mx_rec.quantity,
480: UOM = l_disp_mx_rec.uom,
481: ATTRIBUTE_CATEGORY = l_disp_mx_rec.ATTRIBUTE_CATEGORY,
474: UPDATE ahl_prd_disp_mtl_txns SET
475: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
476: LAST_UPDATE_DATE = sysdate,
477: LAST_UPDATED_BY = fnd_global.USER_ID,
478: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,
479: QUANTITY = l_disp_mx_rec.quantity,
480: UOM = l_disp_mx_rec.uom,
481: ATTRIBUTE_CATEGORY = l_disp_mx_rec.ATTRIBUTE_CATEGORY,
482: ATTRIBUTE1 = l_disp_mx_rec.ATTRIBUTE1,