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.OE_ORDER_PURGE_PVT dependencies on OE_DROP_SHIP_SOURCES

Line 2007: FROM oe_drop_ship_sources ds

2003: RETURN VARCHAR2
2004: IS
2005: CURSOR c_ds_line_loc IS
2006: SELECT ds.line_location_id line_location_id
2007: FROM oe_drop_ship_sources ds
2008: WHERE ds.header_id = p_header_id;
2009:
2010: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2011: l_return_status VARCHAR2(1);

Line 2485: FROM oe_drop_ship_sources

2481: FOR UPDATE NOWAIT;
2482:
2483: CURSOR c_purge_ds IS
2484: SELECT line_id
2485: FROM oe_drop_ship_sources
2486: WHERE header_id = p_header_id
2487: FOR UPDATE NOWAIT;
2488:
2489: CURSOR c_ds_line_loc IS

Line 2491: FROM oe_drop_ship_sources ds

2487: FOR UPDATE NOWAIT;
2488:
2489: CURSOR c_ds_line_loc IS
2490: SELECT ds.line_location_id
2491: FROM oe_drop_ship_sources ds
2492: WHERE ds.header_id = p_header_id;
2493:
2494: BEGIN
2495:

Line 2706: DELETE FROM oe_drop_ship_sources where header_id = p_header_id;

2702:
2703: OPEN c_purge_ds;
2704: CLOSE c_purge_ds;
2705:
2706: DELETE FROM oe_drop_ship_sources where header_id = p_header_id;
2707:
2708: OE_DEBUG_PUB.Add('Before Calling PO Purge API ');
2709:
2710: PO_OM_INTEGRATION_GRP.Purge