[Home] [Help]
1449: -- /== Workflow Changes
1450: --WF: CMR
1451: CURSOR c_get_del_lines_count(p_delv_id NUMBER) IS
1452: SELECT 1
1453: FROM dual
1454: WHERE EXISTS
1455: ( SELECT 'x'
1456: FROM wsh_delivery_assignments wda
1457: , wsh_delivery_details wdd
1463: );
1464:
1465: CURSOR c_get_picked_lines_count(p_delv_id NUMBER) IS
1466: SELECT 1
1467: FROM dual
1468: WHERE EXISTS
1469: ( SELECT 'x'
1470: FROM wsh_delivery_assignments wda
1471: , wsh_delivery_details wdd
6761: where delivery_detail_id = p_del_det_id
6762: and released_status = 'S';
6763:
6764: cursor c_grouping_id is
6765: select wsh_delivery_group_s.nextval from dual;
6766:
6767: l_msg_count NUMBER;
6768: l_msg_data VARCHAR2(4000);
6769: l_det_org NUMBER;
9529: SELECT NVL(decode(l_split_shipped_qty,FND_API.G_MISS_NUM,null,l_split_shipped_qty),
9530: NVL(decode(l_delivery_details_info.picked_quantity,FND_API.G_MISS_NUM,null,l_delivery_details_info.picked_quantity),
9531: decode(l_delivery_details_info.requested_quantity,FND_API.G_MISS_NUM,null,l_delivery_details_info.requested_quantity)))
9532: INTO l_new_wv_qty
9533: FROM dual;
9534: END IF;
9535:
9536: IF l_org_wv_qty <> 0 THEN
9537: l_delivery_details_info.gross_weight := round( (l_new_wv_qty/l_org_wv_qty) * p_old_delivery_detail_rec.gross_weight ,5);
11062: NVL(decode(l_split_shipped_qty,FND_API.G_MISS_NUM,null,l_split_shipped_qty),
11063: NVL(decode(l_delivery_details_info.picked_quantity,FND_API.G_MISS_NUM,null,l_delivery_details_info.picked_quantity),
11064: decode(l_delivery_details_info.requested_quantity,FND_API.G_MISS_NUM,null,l_delivery_details_info.requested_quantity))))
11065: INTO l_new_wv_qty
11066: FROM dual;
11067: END IF;
11068:
11069: IF l_org_wv_qty <> 0 THEN
11070: l_delivery_details_info.gross_weight := round( (l_new_wv_qty/l_org_wv_qty) * p_old_delivery_detail_rec.gross_weight, 5);
11537: ORDER BY msnt.fm_serial_number DESC;
11538:
11539: CURSOR c_temp_id IS
11540: select mtl_material_transactions_s.nextval
11541: from dual;
11542:
11543: --
11544: l_debug_on BOOLEAN;
11545: --
11620: || LPAD(TO_CHAR(l_to_numeric-l_qty_to_split+1),
11621: LENGTH(x_old_detail_rec.serial_number) - l_prefix_length,
11622: '0');
11623:
11624: -- compress range of same serial numbers to individual serial number
11625: IF l_old_to_sn = x_old_detail_rec.serial_number THEN
11626: l_old_to_sn := FND_API.G_MISS_CHAR;
11627: END IF;
11628: IF l_new_to_sn = l_new_sn THEN
12021: --
12022: -- Name
12023: -- Explode_Delivery_Details
12024: -- Purpose
12025: -- Takes individual lines FROM MTL_SERIAL_NUMBERS_TEMP that
12026: -- are under serial number control and explodes them into multiple
12027: -- lines based on the serial numbers entered.
12028: --
12029: -- Bug 1752809: rewritten to explode into serial number ranges.