[Home] [Help]
6607: where delivery_detail_id = p_del_det_id
6608: and released_status = 'S';
6609:
6610: cursor c_grouping_id is
6611: select wsh_delivery_group_s.nextval from dual;
6612:
6613: l_msg_count NUMBER;
6614: l_msg_data VARCHAR2(4000);
6615: l_det_org NUMBER;
9350: SELECT NVL(decode(l_split_shipped_qty,FND_API.G_MISS_NUM,null,l_split_shipped_qty),
9351: NVL(decode(l_delivery_details_info.picked_quantity,FND_API.G_MISS_NUM,null,l_delivery_details_info.picked_quantity),
9352: decode(l_delivery_details_info.requested_quantity,FND_API.G_MISS_NUM,null,l_delivery_details_info.requested_quantity)))
9353: INTO l_new_wv_qty
9354: FROM dual;
9355: END IF;
9356:
9357: IF l_org_wv_qty <> 0 THEN
9358: l_delivery_details_info.gross_weight := round( (l_new_wv_qty/l_org_wv_qty) * p_old_delivery_detail_rec.gross_weight ,5);
10678: NVL(decode(l_split_shipped_qty,FND_API.G_MISS_NUM,null,l_split_shipped_qty),
10679: NVL(decode(l_delivery_details_info.picked_quantity,FND_API.G_MISS_NUM,null,l_delivery_details_info.picked_quantity),
10680: decode(l_delivery_details_info.requested_quantity,FND_API.G_MISS_NUM,null,l_delivery_details_info.requested_quantity))))
10681: INTO l_new_wv_qty
10682: FROM dual;
10683: END IF;
10684:
10685: IF l_org_wv_qty <> 0 THEN
10686: l_delivery_details_info.gross_weight := round( (l_new_wv_qty/l_org_wv_qty) * p_old_delivery_detail_rec.gross_weight, 5);
11106: ORDER BY msnt.fm_serial_number DESC;
11107:
11108: CURSOR c_temp_id IS
11109: select mtl_material_transactions_s.nextval
11110: from dual;
11111:
11112: --
11113: l_debug_on BOOLEAN;
11114: --
11189: || LPAD(TO_CHAR(l_to_numeric-l_qty_to_split+1),
11190: LENGTH(x_old_detail_rec.serial_number) - l_prefix_length,
11191: '0');
11192:
11193: -- compress range of same serial numbers to individual serial number
11194: IF l_old_to_sn = x_old_detail_rec.serial_number THEN
11195: l_old_to_sn := FND_API.G_MISS_CHAR;
11196: END IF;
11197: IF l_new_to_sn = l_new_sn THEN
11556: --
11557: -- Name
11558: -- Explode_Delivery_Details
11559: -- Purpose
11560: -- Takes individual lines FROM MTL_SERIAL_NUMBERS_TEMP that
11561: -- are under serial number control and explodes them into multiple
11562: -- lines based on the serial numbers entered.
11563: --
11564: -- Bug 1752809: rewritten to explode into serial number ranges.