APPS.OE_ORDER_PURGE_PVT dependencies on OE_HOLD_SOURCES

Line 3309: FROM OE_HOLD_SOURCES

3305: WHERE HEADER_ID = p_header_id;
3306:
3307: CURSOR c_hold_sources(p_hold_source_id NUMBER) IS
3308: SELECT hold_source_id
3309: FROM OE_HOLD_SOURCES
3310: WHERE hold_source_id = p_hold_source_id
3311: AND hold_entity_id = p_header_id
3312: AND hold_entity_code = 'O';
3313:

Line 3359: FROM oe_hold_sources

3355:
3356: -- Lock the order holds source record.
3357: SELECT hold_source_id
3358: INTO l_lock_hold_source_id
3359: FROM oe_hold_sources
3360: WHERE hold_source_id = l_hold_source_id
3361: FOR UPDATE NOWAIT;
3362:
3363: DELETE FROM OE_HOLD_SOURCES

Line 3363: DELETE FROM OE_HOLD_SOURCES

3359: FROM oe_hold_sources
3360: WHERE hold_source_id = l_hold_source_id
3361: FOR UPDATE NOWAIT;
3362:
3363: DELETE FROM OE_HOLD_SOURCES
3364: WHERE HOLD_SOURCE_ID = l_hold_source_id;
3365:
3366: END LOOP;
3367: oe_debug_pub.add('Number of hold sources deleted : '||to_char(c_hold_sources%ROWCOUNT),1);