eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_USA_QUANTITY_PVT dependencies on WSH_DELIVERY_DETAILS

Line 124: FROM wsh_delivery_details wdd,

120: --
121: wnd.ignore_for_planning, -- OTM R12 : update requested quantity change
122: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
123: wdd.replenishment_status --bug# 6689448 (replenishment project)
124: FROM wsh_delivery_details wdd,
125: wsh_new_deliveries wnd,
126: wsh_delivery_assignments_v wda
127: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
128: AND wda.delivery_id = wnd.delivery_id (+)

Line 188: FROM wsh_delivery_details wdd,

184: --
185: wnd.ignore_for_planning, -- OTM R12 : update requested quantity change
186: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
187: wdd.replenishment_status --bug# 6689448 (replenishment project)
188: FROM wsh_delivery_details wdd,
189: wsh_new_deliveries wnd,
190: wsh_delivery_assignments_v wda,
191: mtl_serial_numbers_temp msnt
192: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 257: FROM wsh_delivery_details

253: wdd.delivery_detail_id; -- accounted for
254:
255: CURSOR C_sum_req_quantity is
256: SELECT sum(nvl(requested_quantity,0)),sum(nvl(requested_quantity2,0))
257: FROM wsh_delivery_details
258: WHERE source_line_id = p_changed_attribute.source_line_id
259: AND source_code = p_source_code
260: GROUP BY source_line_id;
261:

Line 264: FROM wsh_delivery_details

260: GROUP BY source_line_id;
261:
262: CURSOR C_get_others is
263: SELECT organization_id,inventory_item_id,requested_quantity_uom,requested_quantity_uom2
264: FROM wsh_delivery_details
265: WHERE source_line_id = p_changed_attribute.source_line_id
266: AND source_code = p_source_code
267: AND rownum < 2;
268:

Line 294: wsh_delivery_details WHERE

290:
291: CURSOR c_check_smc_model_change (c_top_model_line_id NUMBER,
292: c_p_source_header_id NUMBER) IS
293: SELECT top_model_line_id FROM
294: wsh_delivery_details WHERE
295: top_model_line_id = c_top_model_line_id AND
296: source_code = 'OE' AND
297: ship_model_complete_flag = 'Y' AND
298: source_header_id = c_p_source_header_id AND

Line 340: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;

336: l_exception_error_message VARCHAR2(2000) := NULL;
337: l_exception_assignment_id NUMBER;
338:
339: l_delivery_detail_rec wsh_glbl_var_strct_grp.delivery_details_rec_type;
340: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
341: l_dummy_delivery_detail_id NUMBER;
342: l_dummy_rowid VARCHAR2(30);
343: l_dummy_id NUMBER;
344:

Line 576: from wsh_delivery_details wdd

572: --
573: begin
574: select sum(wdd.requested_quantity)
575: into l_oke_cancel_qty_allowed
576: from wsh_delivery_details wdd
577: where
578: wdd.source_line_id = p_changed_attribute.source_line_id
579: and wdd.source_code = p_source_code
580: and not exists (select 'x' from

Line 666: UPDATE WSH_DELIVERY_DETAILS

662: else
663: l_src_cancel_qty_allowed := l_oke_cancel_qty_allowed;
664: end if;
665: --
666: UPDATE WSH_DELIVERY_DETAILS
667: set src_requested_quantity = (src_requested_quantity - l_src_cancel_qty_allowed),
668: last_update_date = SYSDATE,
669: last_updated_by = FND_GLOBAL.USER_ID,
670: last_update_login = FND_GLOBAL.LOGIN_ID

Line 899: WSH_DEBUG_SV.log(l_module_name, 'Updating wsh_delivery_details :'|| old_delivery_detail_rec.delivery_detail_id);

895: NVL(old_delivery_detail_rec.released_status,'N') = 'X' )) THEN --{
896: --
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.log(l_module_name, 'Updating wsh_delivery_details :'|| old_delivery_detail_rec.delivery_detail_id);
900: WSH_DEBUG_SV.logmsg(l_module_name, 'Old value of requ_qty is :'|| old_delivery_detail_rec.requested_quantity );
901: WSH_DEBUG_SV.logmsg(l_module_name, 'Old value of requ_qty2 is :'||old_delivery_detail_rec.requested_quantity2 );
902: WSH_DEBUG_SV.logmsg(l_module_name, 'l_changed_detail_quantity :'|| l_changed_detail_quantity );
903: WSH_DEBUG_SV.logmsg(l_module_name, ' l_changed_line_quantity2 :'||l_changed_line_quantity2 );

Line 928: UPDATE wsh_delivery_details SET

924: WSH_DEBUG_SV.logmsg(l_module_name,'new l_changed_detail_quantity '||l_changed_detail_quantity);
925: END IF;
926: END IF;
927:
928: UPDATE wsh_delivery_details SET
929: requested_quantity = l_update_qty,
930: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2,
931: last_update_date = SYSDATE,
932: last_updated_by = FND_GLOBAL.USER_ID,

Line 937: UPDATE wsh_delivery_details SET

933: last_update_login = FND_GLOBAL.LOGIN_ID
934: WHERE source_line_id = old_delivery_detail_rec.source_line_id
935: AND delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
936: ELSE
937: UPDATE wsh_delivery_details SET
938: requested_quantity = old_delivery_detail_rec.requested_quantity + l_changed_detail_quantity,
939: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2, -- OPM B2187389
940: last_update_date = SYSDATE,
941: last_updated_by = FND_GLOBAL.USER_ID,

Line 948: -- Update of wsh_delivery_details where requested_quantity/released_status

944: AND delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
945: END IF;
946:
947: -- DBI Project
948: -- Update of wsh_delivery_details where requested_quantity/released_status
949: -- are changed, call DBI API after the update.
950: -- This API will also check for DBI Installed or not
951: IF l_debug_on THEN
952: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',old_delivery_detail_rec.delivery_detail_id);

Line 1031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);

1027: NULL);
1028: l_item_quantity_uom_tab(1) := old_delivery_detail_rec.requested_quantity_uom;
1029:
1030: IF l_debug_on THEN
1031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
1032: END IF;
1033:
1034: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
1035: p_detail_tab => l_split_delivery_detail_tab,

Line 1034: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(

1030: IF l_debug_on THEN
1031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
1032: END IF;
1033:
1034: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
1035: p_detail_tab => l_split_delivery_detail_tab,
1036: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
1037: x_return_status => l_return_status);
1038:

Line 1040: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);

1036: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
1037: x_return_status => l_return_status);
1038:
1039: IF l_debug_on THEN
1040: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);
1041: END IF;
1042:
1043: -- we will not fail based on l_return_status here because
1044: -- we do not want to stop the flow

Line 1213: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(

1209: END IF;
1210:
1211: l_dummy_delivery_detail_id := null;
1212: --
1213: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(
1214: p_delivery_detail_rec => l_delivery_detail_rec,
1215: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
1216: x_row_id => l_dummy_rowid,
1217: x_delivery_detail_id => l_dummy_delivery_detail_id,

Line 1248: WSH_DELIVERY_DETAILS_PKG.Create_delivery_assignments(

1244: l_delivery_assignments_info.delivery_detail_id := l_dummy_delivery_detail_id;
1245: l_delivery_assignments_info.delivery_id := NULL;
1246: l_delivery_assignments_info.parent_delivery_detail_id := NULL;
1247:
1248: WSH_DELIVERY_DETAILS_PKG.Create_delivery_assignments(
1249: p_delivery_assignments_info => l_delivery_assignments_info,
1250: x_rowid => l_dummy_rowid,
1251: x_delivery_assignment_id => l_dummy_id,
1252: x_return_status => l_return_status);

Line 1315: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);

1311: NULL);
1312: l_item_quantity_uom_tab(1) := old_delivery_detail_rec.requested_quantity_uom;
1313:
1314: IF l_debug_on THEN
1315: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
1316: END IF;
1317:
1318: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
1319: p_detail_tab => l_split_delivery_detail_tab,

Line 1318: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(

1314: IF l_debug_on THEN
1315: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
1316: END IF;
1317:
1318: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
1319: p_detail_tab => l_split_delivery_detail_tab,
1320: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
1321: x_return_status => l_return_status);
1322:

Line 1324: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);

1320: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
1321: x_return_status => l_return_status);
1322:
1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);
1325: END IF;
1326:
1327: -- we will not fail based on l_return_status here because
1328: -- we do not want to stop the flow

Line 1812: UPDATE wsh_delivery_details

1808: WSH_DEBUG_SV.logmsg(l_module_name, 'OPM L_CHANGED_LINE_QUANTITY2 < 0 AND L_CHANGED_LINE_QUANTITY = 0 ' );
1809: END IF;
1810: --
1811:
1812: UPDATE wsh_delivery_details
1813: SET requested_quantity2 = old_delivery_detail_rec.requested_quantity2 - ABS(l_changed_detail_quantity2)
1814: --Added bug 13812257, if requested_quantity2 is decremented then cancelled_quantity2 should be incremented.
1815: , cancelled_quantity2 = (NVL(cancelled_quantity2,0) + ABS(l_changed_detail_quantity2))
1816: , last_update_date = SYSDATE

Line 2138: FROM wsh_delivery_details wdd,

2134: ,wdd.locator_id
2135: ,wdd.source_header_id
2136: ,wdd.picked_quantity
2137: ,wdd.picked_quantity2
2138: FROM wsh_delivery_details wdd,
2139: wsh_delivery_assignments_v wda
2140: WHERE wdd.source_line_id = p_source_line_id
2141: AND wdd.source_code = p_source_code
2142: AND wdd.released_status IN ('S','Y')

Line 2158: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;

2154: l_txn_temp_id NUMBER;
2155: l_organization_id NUMBER;
2156: l_delivery_id NUMBER;
2157:
2158: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
2159: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
2160: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
2161: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;

Line 2159: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;

2155: l_organization_id NUMBER;
2156: l_delivery_id NUMBER;
2157:
2158: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
2159: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
2160: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
2161: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
2163: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;

Line 2160: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;

2156: l_delivery_id NUMBER;
2157:
2158: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
2159: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
2160: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
2161: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
2163: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
2164: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;

Line 2161: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;

2157:
2158: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
2159: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
2160: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
2161: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
2163: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
2164: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
2165: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;

Line 2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;

2158: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
2159: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
2160: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
2161: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
2163: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
2164: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
2165: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
2166: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;

Line 2163: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;

2159: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
2160: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
2161: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
2163: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
2164: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
2165: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
2166: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
2167: l_cancel_quantity NUMBER;

Line 2164: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;

2160: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
2161: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
2163: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
2164: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
2165: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
2166: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
2167: l_cancel_quantity NUMBER;
2168: l_cancel_quantity2 NUMBER;

Line 2165: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;

2161: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
2163: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
2164: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
2165: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
2166: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
2167: l_cancel_quantity NUMBER;
2168: l_cancel_quantity2 NUMBER;
2169:

Line 2393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

2389: --
2390: -- Debug Statements
2391: --
2392: IF l_debug_on THEN
2393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2394: END IF;
2395: --
2396: wsh_delivery_details_actions.Unassign_Detail_from_delivery
2397: (l_delivery_detail_id, x_return_status);

Line 2396: wsh_delivery_details_actions.Unassign_Detail_from_delivery

2392: IF l_debug_on THEN
2393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2394: END IF;
2395: --
2396: wsh_delivery_details_actions.Unassign_Detail_from_delivery
2397: (l_delivery_detail_id, x_return_status);
2398: IF l_debug_on THEN
2399: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_delivery x_return_status',x_return_status);
2400: END IF;

Line 2418: UPDATE wsh_delivery_details set

2414: END IF;
2415: END LOOP;
2416: CLOSE C_overpick;
2417:
2418: UPDATE wsh_delivery_details set
2419: requested_quantity = 0,
2420: requested_quantity2 = 0,
2421: picked_quantity = NULL,
2422: picked_quantity2 = NULL,

Line 2451: -- Update of wsh_delivery_details where requested_quantity/released_status

2447: AND picked_quantity > 0
2448: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab; -- Added for DBI Project
2449: --
2450: -- DBI Project
2451: -- Update of wsh_delivery_details where requested_quantity/released_status
2452: -- are changed, call DBI API after the update.
2453: -- DBI API will check if DBI is installed
2454: IF l_debug_on THEN
2455: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);

Line 2843: wsh_delivery_details_actions.unreserve_delivery_detail(

2839: IF (p_fulfillment_base = 'P' and l_excess_picked_quantity > 0) OR (p_fulfillment_base = 'S' and l_excess_picked_quantity2 > 0) THEN
2840:
2841: -- HW OPMCONV - Pass l_excess_picked_quantity2
2842:
2843: wsh_delivery_details_actions.unreserve_delivery_detail(
2844: p_delivery_Detail_id => p_delivery_detail_id,
2845: p_unreserve_mode => 'UNRESERVE',
2846: p_quantity_to_unreserve => l_excess_picked_quantity,
2847: p_quantity2_to_unreserve => l_excess_picked_quantity2,

Line 2922: UPDATE wsh_delivery_details

2918: WSH_DEBUG_SV.log(l_module_name,' p_requested_quantity2 :'||p_requested_quantity2);
2919: WSH_DEBUG_SV.log(l_module_name,' p_changed_detail_quantity2 :'||p_changed_detail_quantity2);
2920: END IF;
2921:
2922: UPDATE wsh_delivery_details
2923: SET requested_quantity = p_requested_quantity - ABS(p_changed_detail_quantity)
2924: , requested_quantity2 = p_requested_quantity2 - ABS(p_changed_detail_quantity2)
2925: -- HW OPMCONV - Update Qty2 similar to Qty1
2926: -- requested_quantity2 = p_requested_quantity2 + p_changed_detail_quantity2, -- OPM B2187389

Line 2939: UPDATE wsh_delivery_details

2935: , last_update_login = FND_GLOBAL.LOGIN_ID
2936: WHERE delivery_detail_id = p_delivery_detail_id;
2937: ELSE
2938:
2939: UPDATE wsh_delivery_details
2940: SET requested_quantity = p_requested_quantity - ABS(p_changed_detail_quantity)
2941: , requested_quantity2 = p_requested_quantity2 - ABS(p_changed_detail_quantity2)
2942: -- HW OPMCONV - Update Qty2 similar to Qty1
2943: -- requested_quantity2 = p_requested_quantity2 + p_changed_detail_quantity2, -- OPM B2187389

Line 2968: UPDATE wsh_delivery_details

2964: WSH_DEBUG_SV.log(l_module_name,' p_requested_quantity2 :'||p_requested_quantity2);
2965: WSH_DEBUG_SV.log(l_module_name,' p_changed_detail_quantity2 :'||p_changed_detail_quantity2);
2966: END IF;
2967:
2968: UPDATE wsh_delivery_details
2969: SET requested_quantity = l_update_qty
2970: , requested_quantity2 = p_requested_quantity2 - ABS(p_changed_detail_quantity2)
2971: , picked_quantity = l_picked_quantity
2972: , picked_quantity2 = l_picked_quantity2

Line 2983: UPDATE wsh_delivery_details

2979: , last_update_login = FND_GLOBAL.LOGIN_ID
2980: WHERE delivery_detail_id = p_delivery_detail_id;
2981: ELSE
2982:
2983: UPDATE wsh_delivery_details
2984: SET requested_quantity = l_update_qty
2985: , requested_quantity2 = p_requested_quantity2 - ABS(p_changed_detail_quantity2)
2986: , picked_quantity = l_picked_quantity
2987: , picked_quantity2 = l_picked_quantity2

Line 3078: -- Update of wsh_delivery_details where requested_quantity/released_status

3074: END IF;
3075: -- End of OTM R12 : cancel quantity
3076:
3077: -- DBI Project
3078: -- Update of wsh_delivery_details where requested_quantity/released_status
3079: -- are changed, call DBI API after the update.
3080: -- Either of the above 2 updates will be executed for same delivery detail id
3081: -- hence have one call to DBI wrapper and not 2,this will cover for both
3082: -- This API will also check for DBI Installed or not

Line 3125: UPDATE wsh_delivery_details SET

3121: AND (p_requested_quantity - ABS(p_changed_detail_quantity)) >= nvl(p_shipped_quantity,0)) ) THEN
3122: IF l_debug_on THEN
3123: WSH_DEBUG_SV.logmsg(l_module_name, 'CASE 2 ' );
3124: END IF;
3125: UPDATE wsh_delivery_details SET
3126: requested_quantity2 = p_requested_quantity2 + p_changed_detail_quantity2 -- OPM B2187389
3127: WHERE delivery_detail_id = p_delivery_detail_id;
3128: END IF; */
3129: -- bug 13812257 comment end

Line 3260: update wsh_delivery_details set

3256: ELSE --} {
3257: l_change_reservation_quantity := p_requested_quantity;
3258: l_change_reservation_quantity2 := p_requested_quantity2;
3259:
3260: update wsh_delivery_details set
3261: requested_quantity = 0,
3262: requested_quantity2 = 0,
3263: picked_quantity = NULL,
3264: picked_quantity2 = NULL,

Line 3313: -- Update of wsh_delivery_details where requested_quantity/released_status

3309: --bug# 6689448 (replenishment project):end
3310:
3311:
3312: -- DBI Project
3313: -- Update of wsh_delivery_details where requested_quantity/released_status
3314: -- are changed, call DBI API after the update.
3315: -- This API will also check for DBI Installed or not
3316: IF l_debug_on THEN
3317: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',p_delivery_detail_id);

Line 3373: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (

3369: -- assigned to the delivery if the delivery is planned
3370: IF nvl(l_planned_flag, 'N') = 'N' THEN
3371:
3372: l_details_id(1) := p_delivery_detail_id;
3373: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (
3374: p_ids_tobe_unassigned => l_details_id ,
3375: p_validate_flag => 'Y',
3376: x_return_status => x_return_status);
3377: IF l_debug_on THEN

Line 3398: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(p_delivery_detail_id,x_return_status);

3394:
3395:
3396: IF p_parent_delivery_detail_id IS NOT NULL THEN
3397:
3398: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(p_delivery_detail_id,x_return_status);
3399: IF l_debug_on THEN
3400: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_Cont x_return_status',x_return_status);
3401: END IF;
3402: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN