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_INTERFACE dependencies on WSH_DELIVERY_DETAILS

Line 418: from wsh_delivery_Details dd,

414: s.stop_id,
415: s.actual_departure_date,
416: nd.name,
417: dd.shipped_quantity
418: from wsh_delivery_Details dd,
419: wsh_trip_stops s,
420: wsh_delivery_legs dl,
421: wsh_delivery_assignments_v da,
422: wsh_new_deliveries nd

Line 812: FROM mtl_customer_items mci, wsh_delivery_details dd, oe_order_lines_all ool

808: IS
809: CURSOR C_container
810: IS
811: SELECT mci.master_container_item_id, mci.detail_container_item_id
812: FROM mtl_customer_items mci, wsh_delivery_details dd, oe_order_lines_all ool
813: WHERE dd.delivery_detail_id = p_delivery_detail_id AND
814: dd.source_line_id = ool.line_id AND
815: mci.customer_item_id(+) = ool.ordered_item_id AND
816: ool.item_identifier_type = 'CUST';

Line 853: UPDATE wsh_delivery_details

849: IF (C_Container%NOTFOUND) THEN
850: CLOSE C_Container;
851: RAISE no_container;
852: ELSE
853: UPDATE wsh_delivery_details
854: SET master_container_item_id = l_master_container_item_id,
855: detail_container_item_id = l_detail_container_item_id
856: WHERE delivery_detail_id = p_delivery_detail_id;
857: CLOSE C_Container;

Line 895: p_old_delivery_detail_info IN WSH_DELIVERY_DETAILS%ROWTYPE

891: END Default_Container;
892:
893:
894: PROCEDURE Populate_Detail_Info(
895: p_old_delivery_detail_info IN WSH_DELIVERY_DETAILS%ROWTYPE
896: , x_new_delivery_detail_info OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
897: , x_return_status OUT NOCOPY VARCHAR2
898: )
899: IS

Line 1094: FROM wsh_delivery_details

1090: released_status,
1091: source_code,
1092: container_flag,
1093: source_line_id -- Column added for Bug 5741373
1094: FROM wsh_delivery_details
1095: WHERE delivery_detail_id = c_detail_id;
1096:
1097: l_detail_rec c_details%ROWTYPE;
1098:

Line 1190: FROM wsh_delivery_details

1186: -- if delivery line is packed, log exception for it
1187:
1188: SELECT container_name
1189: INTO l_container_name
1190: FROM wsh_delivery_details
1191: WHERE delivery_detail_id = l_assign_rec.parent_delivery_detail_id;
1192:
1193: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_PACKING');
1194: l_msg := FND_MESSAGE.GET;

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

1298:
1299: -- HW OPMCONV - Removed branching
1300:
1301: IF l_debug_on THEN
1302: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1303: END IF;
1304:
1305: -- HW OPMCONV - Added Qty2
1306: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail(

Line 1306: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail(

1302: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1303: END IF;
1304:
1305: -- HW OPMCONV - Added Qty2
1306: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail(
1307: p_delivery_detail_id => p_details_id(i),
1308: p_quantity_to_unreserve => NVL(l_detail_rec.picked_quantity, l_detail_rec.requested_quantity),
1309: p_quantity2_to_unreserve => NVL(l_detail_rec.picked_quantity2, l_detail_rec.requested_quantity2),
1310: p_unreserve_mode => 'UNRESERVE',

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

1327: ELSE
1328: -- J: W/V Changes
1329: IF (l_assign_rec.parent_delivery_detail_id IS NOT NULL) THEN
1330: IF l_debug_on THEN
1331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
1332: END IF;
1333:
1334: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(
1335: p_detail_id => p_details_id(i),

Line 1334: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(

1330: IF l_debug_on THEN
1331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
1332: END IF;
1333:
1334: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(
1335: p_detail_id => p_details_id(i),
1336: p_validate_flag => 'N',
1337: x_return_status => l_return_status);
1338:

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

1347: END IF;
1348:
1349: IF (l_assign_rec.delivery_id IS NOT NULL) THEN
1350: IF l_debug_on THEN
1351: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1352: END IF;
1353:
1354: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
1355: p_detail_id => p_details_id(i),

Line 1354: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(

1350: IF l_debug_on THEN
1351: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_DETAIL_FROM_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1352: END IF;
1353:
1354: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
1355: p_detail_id => p_details_id(i),
1356: p_validate_flag => 'N',
1357: x_return_status => l_return_status);
1358:

Line 1371: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to CANCEL',WSH_DEBUG_SV.C_PROC_LEVEL);

1367: END IF;
1368:
1369: IF (p_cancel_delete_flag = 'C') THEN
1370: IF l_debug_on THEN
1371: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to CANCEL',WSH_DEBUG_SV.C_PROC_LEVEL);
1372: END IF;
1373:
1374: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
1375: p_delivery_detail_id => p_details_id(i),

Line 1374: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

1370: IF l_debug_on THEN
1371: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to CANCEL',WSH_DEBUG_SV.C_PROC_LEVEL);
1372: END IF;
1373:
1374: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
1375: p_delivery_detail_id => p_details_id(i),
1376: p_cancel_flag => 'Y',
1377: x_return_status => l_return_status );
1378:

Line 1381: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);

1377: x_return_status => l_return_status );
1378:
1379: ELSE -- delete details
1380: IF l_debug_on THEN
1381: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
1382: END IF;
1383:
1384: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
1385: p_delivery_detail_id => p_details_id(i),

Line 1384: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

1380: IF l_debug_on THEN
1381: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS to DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
1382: END IF;
1383:
1384: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
1385: p_delivery_detail_id => p_details_id(i),
1386: p_cancel_flag => 'N',
1387: x_return_status => l_return_status );
1388:

Line 1466: UPDATE wsh_delivery_details

1462: /* H integration: 940/945 cancel lines wrudge */
1463: IF l_cancel_dds.count > 0 THEN
1464: -- UPDATE is copied/modified from Backorder API
1465: FORALL i IN 1..l_cancel_dds.count
1466: UPDATE wsh_delivery_details
1467: SET move_order_line_id = NULL ,
1468: released_status = 'D',
1469: cycle_count_quantity = NULL,
1470: cycle_count_quantity2 = NULL,

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

1486: -- delivery assignment records are not modified for source_code WSH.
1487: --
1488: -- Use l_cancel_dds to pass as table of delivery detail ids
1489: -- DBI Project
1490: -- Update of wsh_delivery_details where requested_quantity/released_status
1491: -- are changed, call DBI API after the update.
1492: -- DBI API will check if DBI is installed
1493: IF l_debug_on THEN
1494: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_cancel_dds.count);

Line 1915: from wsh_delivery_Details

1911: --
1912:
1913: CURSOR c_details IS
1914: select detail_container_item_id , inventory_item_id , organization_id
1915: from wsh_delivery_Details
1916: where move_order_line_id = p_move_order_line_id
1917: and nvl(line_direction, 'O') IN ('O', 'IO')
1918: and rownum = 1 ;
1919:

Line 2055: FROM wsh_delivery_details wdd

2051: CURSOR c_source_line_to_lock(x_source_line_id NUMBER,
2052: x_neg_source_line_id NUMBER,
2053: x_source_code VARCHAR2) IS
2054: SELECT wdd.delivery_detail_id,wdd.client_id -- LSP PROJECT : Added clientId
2055: FROM wsh_delivery_details wdd
2056: WHERE wdd.source_line_id IN (x_source_line_id, x_neg_source_line_id)
2057: AND wdd.source_code = x_source_code
2058: AND wdd.container_flag = 'N'
2059: AND wdd.released_status <> 'D';

Line 2064: FROM wsh_delivery_details wdd

2060:
2061: -- LSP PROJECT : to get clientId value for the given
2062: CURSOR c_get_client(c_dd_id IN NUMBER) IS
2063: SELECT wdd.client_id -- LSP PROJECT : Added clientId
2064: FROM wsh_delivery_details wdd
2065: WHERE wdd.delivery_detail_id = c_dd_id;
2066:
2067:
2068: l_counter NUMBER;

Line 2124: -- lock records in WSH_DELIVERY_DETAILS and wsh_delivery_assignments_v (if not Pick Confirm)

2120: --
2121: <>
2122: FOR l_counter IN p_changed_attributes.FIRST .. p_changed_attributes.LAST LOOP
2123:
2124: -- lock records in WSH_DELIVERY_DETAILS and wsh_delivery_assignments_v (if not Pick Confirm)
2125: -- unless we are importing source lines.
2126: -- We also look up delivery's status (if not Pick Confirm)
2127: IF p_changed_attributes(l_counter).action_flag <> 'I' THEN
2128:

Line 2302: from wsh_delivery_details

2298: -- has a line that is alredy pending interface.
2299:
2300: cursor c_check_ship_set(c_ship_set IN NUMBER, c_source_header_id IN NUMBER) is
2301: select ship_set_id
2302: from wsh_delivery_details
2303: where source_header_id = c_source_header_id
2304: and ship_set_id = c_ship_set
2305: and source_code = p_source_code
2306: and oe_interfaced_flag = 'P'

Line 2357: FROM wsh_delivery_details wdd,

2353: l_det_status_code,
2354: l_ship_set_id,
2355: l_source_header_id,
2356: l_dummy_id
2357: FROM wsh_delivery_details wdd,
2358: wsh_delivery_assignments_v wda
2359: WHERE wdd.delivery_detail_id = p_delivery_detail_id
2360: AND wdd.delivery_detail_id = wda.delivery_detail_id
2361: AND wdd.container_flag = 'N'

Line 2556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Check_Updates_Allowed',WSH_DEBUG_SV.C_PROC_LEVEL);

2552: -- TPW - Distributed Organization Changes - Start
2553: IF l_rs NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2554: --
2555: IF l_debug_on THEN
2556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Check_Updates_Allowed',WSH_DEBUG_SV.C_PROC_LEVEL);
2557: END IF;
2558: --
2559: WSH_DELIVERY_DETAILS_UTILITIES.Check_Updates_Allowed(
2560: p_changed_attributes => p_changed_attributes,

Line 2559: WSH_DELIVERY_DETAILS_UTILITIES.Check_Updates_Allowed(

2555: IF l_debug_on THEN
2556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Check_Updates_Allowed',WSH_DEBUG_SV.C_PROC_LEVEL);
2557: END IF;
2558: --
2559: WSH_DELIVERY_DETAILS_UTILITIES.Check_Updates_Allowed(
2560: p_changed_attributes => p_changed_attributes,
2561: p_source_code => p_source_code,
2562: x_update_allowed => l_update_allowed,
2563: x_return_status => l_rs);

Line 2566: WSH_DEBUG_SV.log(l_module_name, 'After Calling WSH_DELIVERY_DETAILS_UTILITIES.Check_Updates_Allowed', l_rs);

2562: x_update_allowed => l_update_allowed,
2563: x_return_status => l_rs);
2564: --
2565: IF l_debug_on THEN
2566: WSH_DEBUG_SV.log(l_module_name, 'After Calling WSH_DELIVERY_DETAILS_UTILITIES.Check_Updates_Allowed', l_rs);
2567: END IF;
2568: --
2569: END IF;
2570: -- TPW - Distributed Organization Changes - End

Line 2796: FROM wsh_delivery_details wdd,

2792: wdd.volume_uom_code,
2793: wda.delivery_id,
2794: wda.parent_delivery_detail_id,
2795: wdd.released_status
2796: FROM wsh_delivery_details wdd,
2797: wsh_delivery_assignments_v wda
2798: WHERE wdd.delivery_detail_id = v_delivery_detail_id
2799: AND wdd.delivery_detail_id = wda.delivery_detail_id;
2800: -- cannot add wda.delivery_id is not null because this is a generic

Line 2817: FROM wsh_delivery_details wdd,

2813: wdd.volume_uom_code,
2814: wda.delivery_id,
2815: wda.parent_delivery_detail_id,
2816: wdd.released_status
2817: FROM wsh_delivery_details wdd,
2818: wsh_delivery_assignments_v wda
2819: WHERE wdd.source_line_id = v_source_line_id
2820: AND wdd.delivery_detail_id = wda.delivery_detail_id
2821: AND nvl(wdd.line_direction, 'O') IN ('O', 'IO');

Line 2826: l_source_line_id wsh_delivery_details.source_line_id%TYPE;

2822: i NUMBER;
2823: l_dd_rec wsh_interface.delivery_detail_rec;
2824: l_dd_tab wsh_interface.deliverydetailtab;
2825: l_dd_ids wsh_util_core.id_tab_type;
2826: l_source_line_id wsh_delivery_details.source_line_id%TYPE;
2827: --
2828: l_debug_on BOOLEAN;
2829: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DETAILS_SNAPSHOT';
2830: --