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 113: FROM wsh_delivery_details wdd,

109: --
110: wnd.ignore_for_planning, -- OTM R12 : update requested quantity change
111: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
112: wdd.replenishment_status --bug# 6689448 (replenishment project)
113: FROM wsh_delivery_details wdd,
114: wsh_new_deliveries wnd,
115: wsh_delivery_assignments_v wda
116: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
117: AND wda.delivery_id = wnd.delivery_id (+)

Line 171: FROM wsh_delivery_details wdd,

167: --
168: wnd.ignore_for_planning, -- OTM R12 : update requested quantity change
169: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
170: wdd.replenishment_status --bug# 6689448 (replenishment project)
171: FROM wsh_delivery_details wdd,
172: wsh_new_deliveries wnd,
173: wsh_delivery_assignments_v wda,
174: mtl_serial_numbers_temp msnt
175: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 233: FROM wsh_delivery_details

229: wdd.delivery_detail_id; -- accounted for
230:
231: CURSOR C_sum_req_quantity is
232: SELECT sum(nvl(requested_quantity,0)),sum(nvl(requested_quantity2,0))
233: FROM wsh_delivery_details
234: WHERE source_line_id = p_changed_attribute.source_line_id
235: AND source_code = p_source_code
236: GROUP BY source_line_id;
237:

Line 240: FROM wsh_delivery_details

236: GROUP BY source_line_id;
237:
238: CURSOR C_get_others is
239: SELECT organization_id,inventory_item_id,requested_quantity_uom,requested_quantity_uom2
240: FROM wsh_delivery_details
241: WHERE source_line_id = p_changed_attribute.source_line_id
242: AND source_code = p_source_code
243: AND rownum < 2;
244:

Line 270: wsh_delivery_details WHERE

266:
267: CURSOR c_check_smc_model_change (c_top_model_line_id NUMBER,
268: c_p_source_header_id NUMBER) IS
269: SELECT top_model_line_id FROM
270: wsh_delivery_details WHERE
271: top_model_line_id = c_top_model_line_id AND
272: source_code = 'OE' AND
273: ship_model_complete_flag = 'Y' AND
274: source_header_id = c_p_source_header_id AND

Line 315: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;

311: l_exception_error_message VARCHAR2(2000) := NULL;
312: l_exception_assignment_id NUMBER;
313:
314: l_delivery_detail_rec wsh_glbl_var_strct_grp.delivery_details_rec_type;
315: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
316: l_dummy_delivery_detail_id NUMBER;
317: l_dummy_rowid VARCHAR2(30);
318: l_dummy_id NUMBER;
319:

Line 516: from wsh_delivery_details wdd

512: --
513: begin
514: select sum(wdd.requested_quantity)
515: into l_oke_cancel_qty_allowed
516: from wsh_delivery_details wdd
517: where
518: wdd.source_line_id = p_changed_attribute.source_line_id
519: and wdd.source_code = p_source_code
520: and not exists (select 'x' from

Line 606: UPDATE WSH_DELIVERY_DETAILS

602: else
603: l_src_cancel_qty_allowed := l_oke_cancel_qty_allowed;
604: end if;
605: --
606: UPDATE WSH_DELIVERY_DETAILS
607: set src_requested_quantity = (src_requested_quantity - l_src_cancel_qty_allowed),
608: last_update_date = SYSDATE,
609: last_updated_by = FND_GLOBAL.USER_ID,
610: last_update_login = FND_GLOBAL.LOGIN_ID

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

791: NVL(old_delivery_detail_rec.released_status,'N') = 'X' )) THEN
792: --
793: --
794: IF l_debug_on THEN
795: WSH_DEBUG_SV.log(l_module_name, 'Updating wsh_delivery_details', old_delivery_detail_rec.delivery_detail_id);
796: WSH_DEBUG_SV.logmsg(l_module_name, 'Old value of requ_qty is ', old_delivery_detail_rec.requested_quantity );
797: WSH_DEBUG_SV.logmsg(l_module_name, 'Old value of requ_qty2 is ' ,old_delivery_detail_rec.requested_quantity2 );
798: END IF;
799:

Line 800: UPDATE wsh_delivery_details SET

796: WSH_DEBUG_SV.logmsg(l_module_name, 'Old value of requ_qty is ', old_delivery_detail_rec.requested_quantity );
797: WSH_DEBUG_SV.logmsg(l_module_name, 'Old value of requ_qty2 is ' ,old_delivery_detail_rec.requested_quantity2 );
798: END IF;
799:
800: UPDATE wsh_delivery_details SET
801: requested_quantity = old_delivery_detail_rec.requested_quantity + l_changed_detail_quantity,
802: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2, -- OPM B2187389
803: last_update_date = SYSDATE,
804: last_updated_by = FND_GLOBAL.USER_ID,

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

806: WHERE source_line_id = old_delivery_detail_rec.source_line_id
807: AND delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
808:
809: -- DBI Project
810: -- Update of wsh_delivery_details where requested_quantity/released_status
811: -- are changed, call DBI API after the update.
812: -- This API will also check for DBI Installed or not
813: IF l_debug_on THEN
814: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',old_delivery_detail_rec.delivery_detail_id);

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

889: NULL);
890: l_item_quantity_uom_tab(1) := old_delivery_detail_rec.requested_quantity_uom;
891:
892: IF l_debug_on THEN
893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
894: END IF;
895:
896: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
897: p_detail_tab => l_split_delivery_detail_tab,

Line 896: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(

892: IF l_debug_on THEN
893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
894: END IF;
895:
896: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
897: p_detail_tab => l_split_delivery_detail_tab,
898: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
899: x_return_status => l_return_status);
900:

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

898: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
899: x_return_status => l_return_status);
900:
901: IF l_debug_on THEN
902: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);
903: END IF;
904:
905: -- we will not fail based on l_return_status here because
906: -- we do not want to stop the flow

Line 1037: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(

1033: END IF;
1034:
1035: l_dummy_delivery_detail_id := null;
1036: --
1037: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(
1038: p_delivery_detail_rec => l_delivery_detail_rec,
1039: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
1040: x_row_id => l_dummy_rowid,
1041: x_delivery_detail_id => l_dummy_delivery_detail_id,

Line 1072: WSH_DELIVERY_DETAILS_PKG.Create_delivery_assignments(

1068: l_delivery_assignments_info.delivery_detail_id := l_dummy_delivery_detail_id;
1069: l_delivery_assignments_info.delivery_id := NULL;
1070: l_delivery_assignments_info.parent_delivery_detail_id := NULL;
1071:
1072: WSH_DELIVERY_DETAILS_PKG.Create_delivery_assignments(
1073: p_delivery_assignments_info => l_delivery_assignments_info,
1074: x_rowid => l_dummy_rowid,
1075: x_delivery_assignment_id => l_dummy_id,
1076: x_return_status => l_return_status);

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

1135: NULL);
1136: l_item_quantity_uom_tab(1) := old_delivery_detail_rec.requested_quantity_uom;
1137:
1138: IF l_debug_on THEN
1139: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
1140: END IF;
1141:
1142: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
1143: p_detail_tab => l_split_delivery_detail_tab,

Line 1142: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(

1138: IF l_debug_on THEN
1139: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
1140: END IF;
1141:
1142: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
1143: p_detail_tab => l_split_delivery_detail_tab,
1144: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
1145: x_return_status => l_return_status);
1146:

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

1144: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
1145: x_return_status => l_return_status);
1146:
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);
1149: END IF;
1150:
1151: -- we will not fail based on l_return_status here because
1152: -- we do not want to stop the flow

Line 1557: update wsh_delivery_details set

1553: END IF;
1554: --
1555:
1556:
1557: update wsh_delivery_details set
1558: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 - ABS(l_changed_detail_quantity2),
1559: last_update_date = SYSDATE,
1560: last_updated_by = FND_GLOBAL.USER_ID,
1561: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1877: FROM wsh_delivery_details wdd,

1873: ,wdd.locator_id
1874: ,wdd.source_header_id
1875: ,wdd.picked_quantity
1876: ,wdd.picked_quantity2
1877: FROM wsh_delivery_details wdd,
1878: wsh_delivery_assignments_v wda
1879: WHERE wdd.source_line_id = p_source_line_id
1880: AND wdd.source_code = p_source_code
1881: AND wdd.released_status IN ('S','Y')

Line 1894: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;

1890: l_txn_temp_id NUMBER;
1891: l_organization_id NUMBER;
1892: l_delivery_id NUMBER;
1893:
1894: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1895: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
1896: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
1897: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;

Line 1895: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;

1891: l_organization_id NUMBER;
1892: l_delivery_id NUMBER;
1893:
1894: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1895: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
1896: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
1897: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
1899: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;

Line 1896: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;

1892: l_delivery_id NUMBER;
1893:
1894: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1895: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
1896: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
1897: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
1899: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
1900: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;

Line 1897: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;

1893:
1894: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1895: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
1896: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
1897: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
1899: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
1900: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
1901: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;

Line 1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;

1894: l_source_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1895: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
1896: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
1897: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
1899: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
1900: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
1901: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
1902: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;

Line 1899: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;

1895: l_inventory_item_id WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID%TYPE;
1896: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
1897: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
1899: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
1900: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
1901: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
1902: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
1903: l_cancel_quantity NUMBER;

Line 1900: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;

1896: l_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE;
1897: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
1899: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
1900: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
1901: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
1902: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
1903: l_cancel_quantity NUMBER;
1904: l_cancel_quantity2 NUMBER;

Line 1901: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;

1897: l_revision WSH_DELIVERY_DETAILS.REVISION%TYPE;
1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
1899: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
1900: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
1901: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
1902: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
1903: l_cancel_quantity NUMBER;
1904: l_cancel_quantity2 NUMBER;
1905:

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

2124: --
2125: -- Debug Statements
2126: --
2127: IF l_debug_on THEN
2128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2129: END IF;
2130: --
2131: wsh_delivery_details_actions.Unassign_Detail_from_delivery
2132: (l_delivery_detail_id, x_return_status);

Line 2131: wsh_delivery_details_actions.Unassign_Detail_from_delivery

2127: IF l_debug_on THEN
2128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2129: END IF;
2130: --
2131: wsh_delivery_details_actions.Unassign_Detail_from_delivery
2132: (l_delivery_detail_id, x_return_status);
2133: IF l_debug_on THEN
2134: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_delivery x_return_status',x_return_status);
2135: END IF;

Line 2153: UPDATE wsh_delivery_details set

2149: END IF;
2150: END LOOP;
2151: CLOSE C_overpick;
2152:
2153: UPDATE wsh_delivery_details set
2154: requested_quantity = 0,
2155: requested_quantity2 = 0,
2156: picked_quantity = NULL,
2157: picked_quantity2 = NULL,

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

2182: AND picked_quantity > 0
2183: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab; -- Added for DBI Project
2184: --
2185: -- DBI Project
2186: -- Update of wsh_delivery_details where requested_quantity/released_status
2187: -- are changed, call DBI API after the update.
2188: -- DBI API will check if DBI is installed
2189: IF l_debug_on THEN
2190: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);

Line 2555: wsh_delivery_details_actions.unreserve_delivery_detail(

2551: IF (l_excess_picked_quantity > 0) THEN
2552:
2553: -- HW OPMCONV - Pass l_excess_picked_quantity2
2554:
2555: wsh_delivery_details_actions.unreserve_delivery_detail(
2556: p_delivery_Detail_id => p_delivery_detail_id,
2557: p_unreserve_mode => 'UNRESERVE',
2558: p_quantity_to_unreserve => l_excess_picked_quantity,
2559: p_quantity2_to_unreserve => l_excess_picked_quantity2,

Line 2599: UPDATE wsh_delivery_details SET

2595: IF ( (p_requested_quantity - ABS(p_changed_detail_quantity)) >= nvl(p_shipped_quantity,0) ) THEN
2596: IF l_debug_on THEN
2597: WSH_DEBUG_SV.logmsg(l_module_name, 'CASE 1 ' );
2598: END IF;
2599: UPDATE wsh_delivery_details SET
2600: requested_quantity = p_requested_quantity - ABS(p_changed_detail_quantity),
2601: requested_quantity2 = p_requested_quantity2 - ABS(p_changed_detail_quantity2),
2602: -- HW OPMCONV - Update Qty2 similar to Qty1
2603: -- requested_quantity2 = p_requested_quantity2 + p_changed_detail_quantity2, -- OPM B2187389

Line 2615: UPDATE wsh_delivery_details SET

2611: last_updated_by = FND_GLOBAL.USER_ID,
2612: last_update_login = FND_GLOBAL.LOGIN_ID
2613: where delivery_detail_id = p_delivery_detail_id;
2614: ELSE
2615: UPDATE wsh_delivery_details SET
2616: requested_quantity = p_requested_quantity - ABS(p_changed_detail_quantity),
2617: requested_quantity2 = p_requested_quantity2 - ABS(p_changed_detail_quantity2),
2618: -- HW OPMCONV - Update Qty2 similar to Qty1
2619: -- requested_quantity2 = p_requested_quantity2 + p_changed_detail_quantity2, -- OPM B2187389

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

2704: END IF;
2705: -- End of OTM R12 : cancel quantity
2706:
2707: -- DBI Project
2708: -- Update of wsh_delivery_details where requested_quantity/released_status
2709: -- are changed, call DBI API after the update.
2710: -- Either of the above 2 updates will be executed for same delivery detail id
2711: -- hence have one call to DBI wrapper and not 2,this will cover for both
2712: -- This API will also check for DBI Installed or not

Line 2745: UPDATE wsh_delivery_details SET

2741: AND (p_requested_quantity - ABS(p_changed_detail_quantity)) >= nvl(p_shipped_quantity,0)) ) THEN
2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.logmsg(l_module_name, 'CASE 2 ' );
2744: END IF;
2745: UPDATE wsh_delivery_details SET
2746: requested_quantity2 = p_requested_quantity2 + p_changed_detail_quantity2 -- OPM B2187389
2747: WHERE delivery_detail_id = p_delivery_detail_id;
2748: END IF;
2749:

Line 2860: update wsh_delivery_details set

2856: ELSE
2857: l_change_reservation_quantity := p_requested_quantity;
2858: l_change_reservation_quantity2 := p_requested_quantity2;
2859:
2860: update wsh_delivery_details set
2861: requested_quantity = 0,
2862: requested_quantity2 = 0,
2863: picked_quantity = NULL,
2864: picked_quantity2 = NULL,

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

2909: --bug# 6689448 (replenishment project):end
2910:
2911:
2912: -- DBI Project
2913: -- Update of wsh_delivery_details where requested_quantity/released_status
2914: -- are changed, call DBI API after the update.
2915: -- This API will also check for DBI Installed or not
2916: IF l_debug_on THEN
2917: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',p_delivery_detail_id);

Line 2973: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (

2969: -- assigned to the delivery if the delivery is planned
2970: IF nvl(l_planned_flag, 'N') = 'N' THEN
2971:
2972: l_details_id(1) := p_delivery_detail_id;
2973: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (
2974: p_ids_tobe_unassigned => l_details_id ,
2975: p_validate_flag => 'Y',
2976: x_return_status => x_return_status);
2977: IF l_debug_on THEN

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

2994:
2995:
2996: IF p_parent_delivery_detail_id IS NOT NULL THEN
2997:
2998: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(p_delivery_detail_id,x_return_status);
2999: IF l_debug_on THEN
3000: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_Cont x_return_status',x_return_status);
3001: END IF;
3002: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN