1498: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1499: last_insp_date = sysdate,
1500: valid_flag = 2,
1501: last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id
1504: where shipment_line_id = p_shipment_line_id
1505: and (interface_txn_id IS NULL or interface_txn_id = l_txn_id)
1506: returning criteria_id, inspection_result into c_id, lot_result;
1499: last_insp_date = sysdate,
1500: valid_flag = 2,
1501: last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id
1504: where shipment_line_id = p_shipment_line_id
1505: and (interface_txn_id IS NULL or interface_txn_id = l_txn_id)
1506: returning criteria_id, inspection_result into c_id, lot_result;
1507:
1515: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1516: last_insp_date = sysdate,
1517: valid_flag = 2,
1518: last_update_date = sysdate,
1519: last_updated_by = fnd_global.user_id,
1520: last_update_login = fnd_global.login_id
1521: where insp_lot_id = p_insp_lot_id
1522: returning criteria_id, inspection_result into c_id, lot_result;
1523: end if;
1516: last_insp_date = sysdate,
1517: valid_flag = 2,
1518: last_update_date = sysdate,
1519: last_updated_by = fnd_global.user_id,
1520: last_update_login = fnd_global.login_id
1521: where insp_lot_id = p_insp_lot_id
1522: returning criteria_id, inspection_result into c_id, lot_result;
1523: end if;
1524: end if;