1340: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1341: last_insp_date = sysdate,
1342: valid_flag = 2,
1343: last_update_date = sysdate,
1344: last_updated_by = fnd_global.user_id,
1345: last_update_login = fnd_global.login_id
1346: where shipment_line_id = p_shipment_line_id
1347: returning criteria_id, inspection_result into c_id, lot_result;
1348: else
1341: last_insp_date = sysdate,
1342: valid_flag = 2,
1343: last_update_date = sysdate,
1344: last_updated_by = fnd_global.user_id,
1345: last_update_login = fnd_global.login_id
1346: where shipment_line_id = p_shipment_line_id
1347: returning criteria_id, inspection_result into c_id, lot_result;
1348: else
1349: update qa_skiplot_rcv_results
1354: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1355: last_insp_date = sysdate,
1356: valid_flag = 2,
1357: last_update_date = sysdate,
1358: last_updated_by = fnd_global.user_id,
1359: last_update_login = fnd_global.login_id
1360: where insp_lot_id = p_insp_lot_id
1361: returning criteria_id, inspection_result into c_id, lot_result;
1362: end if;
1355: last_insp_date = sysdate,
1356: valid_flag = 2,
1357: last_update_date = sysdate,
1358: last_updated_by = fnd_global.user_id,
1359: last_update_login = fnd_global.login_id
1360: where insp_lot_id = p_insp_lot_id
1361: returning criteria_id, inspection_result into c_id, lot_result;
1362: end if;
1363: end if;