218: material_stored_amount = p_material_stored_amount,
219: amount_shipped = p_amount_shipped,
220: quantity_shipped = p_quantity_shipped,
221: last_update_date = sysdate,
222: last_updated_by = fnd_global.user_id,
223: last_update_login = fnd_global.login_id
224: where shipment_line_id = p_shipment_line_id;
225:
226:
219: amount_shipped = p_amount_shipped,
220: quantity_shipped = p_quantity_shipped,
221: last_update_date = sysdate,
222: last_updated_by = fnd_global.user_id,
223: last_update_login = fnd_global.login_id
224: where shipment_line_id = p_shipment_line_id;
225:
226:
227: if (SQL%NOTFOUND) then
337: l_qty_shipped,
338: poll.amount_shipped = nvl(poll.amount_shipped,0) +
339: l_amt_shipped,
340: poll.last_update_date = sysdate,
341: poll.last_updated_by = fnd_global.user_id,
342: poll.last_update_login = fnd_global.login_id
343: where poll.line_location_id = l_line_location_id;
344:
345:
338: poll.amount_shipped = nvl(poll.amount_shipped,0) +
339: l_amt_shipped,
340: poll.last_update_date = sysdate,
341: poll.last_updated_by = fnd_global.user_id,
342: poll.last_update_login = fnd_global.login_id
343: where poll.line_location_id = l_line_location_id;
344:
345:
346: IF (g_asn_debug = 'Y') THEN
583:
584: update rcv_shipment_headers
585: set comments = p_comments,
586: last_update_date = sysdate,
587: last_updated_by = fnd_global.user_id,
588: last_update_login = fnd_global.login_id
589: where shipment_header_id = p_document_id;
590:
591: end if;
584: update rcv_shipment_headers
585: set comments = p_comments,
586: last_update_date = sysdate,
587: last_updated_by = fnd_global.user_id,
588: last_update_login = fnd_global.login_id
589: where shipment_header_id = p_document_id;
590:
591: end if;
592:
610: update rcv_shipment_lines
611: set approval_status = p_approval_status,
612: comments = p_comments,
613: last_update_date = sysdate,
614: last_updated_by = fnd_global.user_id,
615: last_update_login = fnd_global.login_id
616: where shipment_line_id = p_document_id;
617:
618: end if;
611: set approval_status = p_approval_status,
612: comments = p_comments,
613: last_update_date = sysdate,
614: last_updated_by = fnd_global.user_id,
615: last_update_login = fnd_global.login_id
616: where shipment_line_id = p_document_id;
617:
618: end if;
619: IF (g_asn_debug = 'Y') THEN