243: material_stored_amount = p_material_stored_amount,
244: amount_shipped = p_amount_shipped,
245: quantity_shipped = p_quantity_shipped,
246: last_update_date = sysdate,
247: last_updated_by = fnd_global.user_id,
248: last_update_login = fnd_global.login_id
249: where shipment_line_id = p_shipment_line_id;
250:
251: /* Bug 8899316: Commenting this code as SQL%NOTFOUND is refering to the
244: amount_shipped = p_amount_shipped,
245: quantity_shipped = p_quantity_shipped,
246: last_update_date = sysdate,
247: last_updated_by = fnd_global.user_id,
248: last_update_login = fnd_global.login_id
249: where shipment_line_id = p_shipment_line_id;
250:
251: /* Bug 8899316: Commenting this code as SQL%NOTFOUND is refering to the
252: last sql of trigger code on RSL
380: l_qty_shipped,
381: poll.amount_shipped = nvl(poll.amount_shipped,0) +
382: l_amt_shipped,
383: poll.last_update_date = sysdate,
384: poll.last_updated_by = fnd_global.user_id,
385: poll.last_update_login = fnd_global.login_id
386: where poll.line_location_id = l_line_location_id;
387:
388:
381: poll.amount_shipped = nvl(poll.amount_shipped,0) +
382: l_amt_shipped,
383: poll.last_update_date = sysdate,
384: poll.last_updated_by = fnd_global.user_id,
385: poll.last_update_login = fnd_global.login_id
386: where poll.line_location_id = l_line_location_id;
387:
388:
389: IF (g_asn_debug = 'Y') THEN
753:
754: update rcv_shipment_headers
755: set comments = p_comments,
756: last_update_date = sysdate,
757: last_updated_by = fnd_global.user_id,
758: last_update_login = fnd_global.login_id
759: where shipment_header_id = p_document_id;
760:
761: end if;
754: update rcv_shipment_headers
755: set comments = p_comments,
756: last_update_date = sysdate,
757: last_updated_by = fnd_global.user_id,
758: last_update_login = fnd_global.login_id
759: where shipment_header_id = p_document_id;
760:
761: end if;
762:
780: update rcv_shipment_lines
781: set approval_status = p_approval_status,
782: comments = p_comments,
783: last_update_date = sysdate,
784: last_updated_by = fnd_global.user_id,
785: last_update_login = fnd_global.login_id
786: where shipment_line_id = p_document_id;
787:
788: end if;
781: set approval_status = p_approval_status,
782: comments = p_comments,
783: last_update_date = sysdate,
784: last_updated_by = fnd_global.user_id,
785: last_update_login = fnd_global.login_id
786: where shipment_line_id = p_document_id;
787:
788: end if;
789: IF (g_asn_debug = 'Y') THEN