APPS.OE_ORDER_PURGE_PVT dependencies on OE_HOLD_RELEASES

Line 3370: FROM OE_HOLD_RELEASES

3366: AND hold_entity_code = 'O';
3367:
3368: CURSOR c_hold_releases(p_hold_release_id NUMBER) IS
3369: SELECT hold_release_id
3370: FROM OE_HOLD_RELEASES
3371: WHERE hold_release_id = p_hold_release_id;
3372:
3373: l_order_hold_id NUMBER;
3374: l_lock_order_hold_id NUMBER;

Line 3437: FROM oe_hold_releases

3433: IF (l_count = 0) THEN
3434: -- Lock the order holds release record.
3435: SELECT hold_release_id
3436: INTO l_lock_hold_release_id
3437: FROM oe_hold_releases
3438: WHERE hold_release_id = l_hold_release_id
3439: FOR UPDATE NOWAIT;
3440:
3441: DELETE FROM OE_HOLD_RELEASES

Line 3441: DELETE FROM OE_HOLD_RELEASES

3437: FROM oe_hold_releases
3438: WHERE hold_release_id = l_hold_release_id
3439: FOR UPDATE NOWAIT;
3440:
3441: DELETE FROM OE_HOLD_RELEASES
3442: WHERE HOLD_RELEASE_ID = l_hold_release_id;
3443: END IF;
3444: END LOOP;
3445: oe_debug_pub.add('Number of hold releases deleted : '||to_char(c_hold_releases%ROWCOUNT),1);