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

Line 791: wsh_delivery_details wdd

787: CURSOR c_open_del_lines(c_line_id NUMBER)
788: IS
789: select 'x'
790: from oe_order_lines_all oel,
791: wsh_delivery_details wdd
792: where oel.open_flag = 'Y'
793: and oel.shipped_quantity is null
794: and oel.line_id = c_line_id
795: and wdd.source_code = 'OE'

Line 1996: --Call WSH_DELIVERY_DETAILS_PKG.Update_Delivery_Details api instead of updating WDD directly.

1992: END IF;
1993: --
1994:
1995: IF l_details_interface_tab(i).changed_flag = 'Y' THEN
1996: --Call WSH_DELIVERY_DETAILS_PKG.Update_Delivery_Details api instead of updating WDD directly.
1997: UPDATE wsh_delivery_details
1998: SET reference_number = l_details_interface_tab(i).source_header_number,
1999: reference_line_number = l_details_interface_tab(i).source_line_number,
2000: reference_line_quantity = l_details_interface_tab(i).src_requested_quantity,

Line 1997: UPDATE wsh_delivery_details

1993: --
1994:
1995: IF l_details_interface_tab(i).changed_flag = 'Y' THEN
1996: --Call WSH_DELIVERY_DETAILS_PKG.Update_Delivery_Details api instead of updating WDD directly.
1997: UPDATE wsh_delivery_details
1998: SET reference_number = l_details_interface_tab(i).source_header_number,
1999: reference_line_number = l_details_interface_tab(i).source_line_number,
2000: reference_line_quantity = l_details_interface_tab(i).src_requested_quantity,
2001: reference_line_quantity_uom = l_details_interface_tab(i).src_requested_quantity_uom,

Line 3086: from wsh_delivery_details

3082:
3083: cursor c_lock_delivery_details( c_line_id NUMBER )
3084: is
3085: select delivery_detail_id
3086: from wsh_delivery_details
3087: where source_code = 'OE'
3088: and source_line_id = c_line_id
3089: for update nowait;
3090:

Line 3145: from wsh_delivery_details

3141: END IF;
3142: --
3143: select delivery_detail_id
3144: bulk collect into l_details_tab
3145: from wsh_delivery_details
3146: where source_code = 'OE'
3147: and source_line_id = l_line_rec.line_id
3148: for update nowait;
3149: END LOOP;

Line 3165: from wsh_delivery_details

3161: END IF;
3162: --
3163: select delivery_detail_id
3164: bulk collect into l_details_tab
3165: from wsh_delivery_details
3166: where source_code = 'OE'
3167: and source_line_id = l_line_rec.line_id
3168: for update nowait;
3169: END LOOP;

Line 3221: from wsh_delivery_details wdd,

3217: IS
3218: CURSOR c_delivery_line_info(c_line_id NUMBER)
3219: IS
3220: select wdd.*
3221: from wsh_delivery_details wdd,
3222: wsh_delivery_assignments wda,
3223: wsh_new_deliveries wnd
3224: where wnd.status_code in ( 'CL', 'IT', 'CO' )
3225: and wnd.delivery_id = wda.delivery_id

Line 5764: from wsh_delivery_details wdd,

5760:
5761: BEGIN
5762: select 'x'
5763: into l_tmp
5764: from wsh_delivery_details wdd,
5765: wsh_delivery_assignments wda,
5766: wsh_new_deliveries wnd
5767: where wnd.status_code in ( 'CO', 'IT', 'CL' )
5768: and wnd.delivery_id = wda.delivery_id

Line 7033: FROM Wsh_Delivery_Details wdd

7029: wdd.reference_line_number,
7030: wdd.reference_line_quantity,
7031: wdd.reference_line_quantity_uom,
7032: wdd.rowid
7033: FROM Wsh_Delivery_Details wdd
7034: WHERE wdd.source_code = 'OE'
7035: AND wdd.source_line_id = c_line_id
7036: AND ROWNUM = 1;
7037:

Line 7131: from wsh_delivery_details wdd

7127:
7128: BEGIN
7129: select 'x'
7130: into l_tmp
7131: from wsh_delivery_details wdd
7132: where source_code = 'OE'
7133: and source_line_id = l_line_id
7134: and released_status in ( 'Y', 'C' )
7135: and exists

Line 7220: from wsh_delivery_details

7216:
7217: BEGIN
7218: select 'x'
7219: into l_tmp
7220: from wsh_delivery_details
7221: where source_code = 'OE'
7222: and source_line_id = l_line_id
7223: and released_status in ( 'S', 'Y', 'C' )
7224: and rownum = 1;

Line 7251: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_INV.Validate_Revision', WSH_DEBUG_SV.C_PROC_LEVEL);

7247: p_details_interface_tab(i).revision is not null ) )
7248: THEN
7249: --
7250: IF l_debug_on THEN
7251: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_INV.Validate_Revision', WSH_DEBUG_SV.C_PROC_LEVEL);
7252: END IF;
7253: --
7254:
7255: WSH_DELIVERY_DETAILS_INV.Validate_Revision(

Line 7255: WSH_DELIVERY_DETAILS_INV.Validate_Revision(

7251: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_INV.Validate_Revision', WSH_DEBUG_SV.C_PROC_LEVEL);
7252: END IF;
7253: --
7254:
7255: WSH_DELIVERY_DETAILS_INV.Validate_Revision(
7256: p_revision => p_details_interface_tab(i).revision,
7257: p_organization_id => p_details_interface_tab(i).organization_id,
7258: p_inventory_item_id => p_details_interface_tab(i).inventory_item_id,
7259: x_return_status => l_return_status,

Line 7287: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_INV.Validate_Locator', WSH_DEBUG_SV.C_PROC_LEVEL);

7283: p_details_interface_tab(i).locator_id is not null ) )
7284: THEN
7285: --
7286: IF l_debug_on THEN
7287: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_INV.Validate_Locator', WSH_DEBUG_SV.C_PROC_LEVEL);
7288: END IF;
7289: --
7290:
7291: WSH_DELIVERY_DETAILS_INV.Validate_Locator(

Line 7291: WSH_DELIVERY_DETAILS_INV.Validate_Locator(

7287: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_INV.Validate_Locator', WSH_DEBUG_SV.C_PROC_LEVEL);
7288: END IF;
7289: --
7290:
7291: WSH_DELIVERY_DETAILS_INV.Validate_Locator(
7292: p_locator_id => p_details_interface_tab(i).locator_id,
7293: p_inventory_item_id => p_details_interface_tab(i).inventory_item_id,
7294: p_organization_id => p_details_interface_tab(i).organization_id,
7295: p_subinventory => p_details_interface_tab(i).subinventory,

Line 7327: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_INV.Validate_Lot_Number', WSH_DEBUG_SV.C_PROC_LEVEL);

7323: p_details_interface_tab(i).lot_number is not null ) )
7324: THEN
7325: --
7326: IF l_debug_on THEN
7327: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_INV.Validate_Lot_Number', WSH_DEBUG_SV.C_PROC_LEVEL);
7328: END IF;
7329: --
7330:
7331: WSH_DELIVERY_DETAILS_INV.Validate_Lot_Number(

Line 7331: WSH_DELIVERY_DETAILS_INV.Validate_Lot_Number(

7327: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_INV.Validate_Lot_Number', WSH_DEBUG_SV.C_PROC_LEVEL);
7328: END IF;
7329: --
7330:
7331: WSH_DELIVERY_DETAILS_INV.Validate_Lot_Number(
7332: p_lot_number => p_details_interface_tab(i).lot_number,
7333: p_organization_id => p_details_interface_tab(i).organization_id,
7334: p_inventory_item_id => p_details_interface_tab(i).inventory_item_id,
7335: p_subinventory => p_details_interface_tab(i).subinventory,