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