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 2431: FROM oe_drop_ship_sources

2427: FOR UPDATE NOWAIT;
2428:
2429: CURSOR c_purge_ds IS
2430: SELECT line_id
2431: FROM oe_drop_ship_sources
2432: WHERE header_id = p_header_id
2433: FOR UPDATE NOWAIT;
2434:
2435: CURSOR c_ds_line_loc IS

Line 2437: FROM oe_drop_ship_sources ds

2433: FOR UPDATE NOWAIT;
2434:
2435: CURSOR c_ds_line_loc IS
2436: SELECT ds.line_location_id
2437: FROM oe_drop_ship_sources ds
2438: WHERE ds.header_id = p_header_id;
2439:
2440: BEGIN
2441:

Line 2652: DELETE FROM oe_drop_ship_sources where header_id = p_header_id;

2648:
2649: OPEN c_purge_ds;
2650: CLOSE c_purge_ds;
2651:
2652: DELETE FROM oe_drop_ship_sources where header_id = p_header_id;
2653:
2654: OE_DEBUG_PUB.Add('Before Calling PO Purge API ');
2655:
2656: PO_OM_INTEGRATION_GRP.Purge