939: received_quantity2 = NULL,
940: released_status = l_released_status_tab(i),
941: rcv_shipment_line_id = l_rcv_shipment_line_id_tab(i),
942: last_update_date = sysdate,
943: last_updated_by = fnd_global.user_id,
944: last_update_login = fnd_global.user_id
945: where delivery_detail_id = l_del_det_id_tab(i)
946: and source_code = 'PO';
947:
940: released_status = l_released_status_tab(i),
941: rcv_shipment_line_id = l_rcv_shipment_line_id_tab(i),
942: last_update_date = sysdate,
943: last_updated_by = fnd_global.user_id,
944: last_update_login = fnd_global.user_id
945: where delivery_detail_id = l_del_det_id_tab(i)
946: and source_code = 'PO';
947:
948: IF l_debug_on THEN
990: received_quantity =NULL,
991: received_quantity2 = NULL,
992: released_status = 'C',
993: last_update_date = sysdate,
994: last_updated_by = fnd_global.user_id,
995: last_update_login = fnd_global.user_id
996: where delivery_detail_id in (select wda.delivery_detail_id
997: from wsh_delivery_assignments_v wda,
998: wsh_new_deliveries wnd
991: received_quantity2 = NULL,
992: released_status = 'C',
993: last_update_date = sysdate,
994: last_updated_by = fnd_global.user_id,
995: last_update_login = fnd_global.user_id
996: where delivery_detail_id in (select wda.delivery_detail_id
997: from wsh_delivery_assignments_v wda,
998: wsh_new_deliveries wnd
999: where wnd.rcv_shipment_header_id = p_shipment_header_id