760: UPDATE oe_order_lines
761: SET flow_status_code = 'SHIPPED',
762: shipped_quantity = 0,
763: last_update_date = SYSDATE,
764: last_updated_by = FND_GLOBAL.USER_ID,
765: last_update_login = FND_GLOBAL.LOGIN_ID
766: WHERE line_id = l_line_rec.line_id;
767: IF g_debug_call > 0 THEN
768: G_DEBUG_MSG := G_DEBUG_MSG || '21,';
761: SET flow_status_code = 'SHIPPED',
762: shipped_quantity = 0,
763: last_update_date = SYSDATE,
764: last_updated_by = FND_GLOBAL.USER_ID,
765: last_update_login = FND_GLOBAL.LOGIN_ID
766: WHERE line_id = l_line_rec.line_id;
767: IF g_debug_call > 0 THEN
768: G_DEBUG_MSG := G_DEBUG_MSG || '21,';
769: END IF;
822: := l_line_tbl(1).shipped_quantity;
823: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
824: := SYSDATE;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
826: := FND_GLOBAL.USER_ID;
827: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login
828: := FND_GLOBAL.LOGIN_ID;
829:
830: IF l_debug_level > 0 THEN
824: := SYSDATE;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
826: := FND_GLOBAL.USER_ID;
827: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login
828: := FND_GLOBAL.LOGIN_ID;
829:
830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add
832: ('global flow status code after update: '
5922: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5923: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5924:
5925: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5926: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5927: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5928:
5929: OE_ORDER_UTIL.g_line_tbl(J)
5930: := OE_ORDER_UTIL.g_old_line_tbl(J);
5923: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5924:
5925: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5926: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5927: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5928:
5929: OE_ORDER_UTIL.g_line_tbl(J)
5930: := OE_ORDER_UTIL.g_old_line_tbl(J);
5931: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code