APPS.OE_ORDER_PURGE_PVT dependencies on OE_HOLD_SOURCES

Line 3363: FROM OE_HOLD_SOURCES

3359: WHERE HEADER_ID = p_header_id;
3360:
3361: CURSOR c_hold_sources(p_hold_source_id NUMBER) IS
3362: SELECT hold_source_id
3363: FROM OE_HOLD_SOURCES
3364: WHERE hold_source_id = p_hold_source_id
3365: AND hold_entity_id = p_header_id
3366: AND hold_entity_code = 'O';
3367:

Line 3413: FROM oe_hold_sources

3409:
3410: -- Lock the order holds source record.
3411: SELECT hold_source_id
3412: INTO l_lock_hold_source_id
3413: FROM oe_hold_sources
3414: WHERE hold_source_id = l_hold_source_id
3415: FOR UPDATE NOWAIT;
3416:
3417: DELETE FROM OE_HOLD_SOURCES

Line 3417: DELETE FROM OE_HOLD_SOURCES

3413: FROM oe_hold_sources
3414: WHERE hold_source_id = l_hold_source_id
3415: FOR UPDATE NOWAIT;
3416:
3417: DELETE FROM OE_HOLD_SOURCES
3418: WHERE HOLD_SOURCE_ID = l_hold_source_id;
3419:
3420: END LOOP;
3421: oe_debug_pub.add('Number of hold sources deleted : '||to_char(c_hold_sources%ROWCOUNT),1);