APPS.OE_ORDER_PURGE_PVT dependencies on OE_HOLD_RELEASES

Line 3316: FROM OE_HOLD_RELEASES

3312: AND hold_entity_code = 'O';
3313:
3314: CURSOR c_hold_releases(p_hold_release_id NUMBER) IS
3315: SELECT hold_release_id
3316: FROM OE_HOLD_RELEASES
3317: WHERE hold_release_id = p_hold_release_id;
3318:
3319: l_order_hold_id NUMBER;
3320: l_lock_order_hold_id NUMBER;

Line 3383: FROM oe_hold_releases

3379: IF (l_count = 0) THEN
3380: -- Lock the order holds release record.
3381: SELECT hold_release_id
3382: INTO l_lock_hold_release_id
3383: FROM oe_hold_releases
3384: WHERE hold_release_id = l_hold_release_id
3385: FOR UPDATE NOWAIT;
3386:
3387: DELETE FROM OE_HOLD_RELEASES

Line 3387: DELETE FROM OE_HOLD_RELEASES

3383: FROM oe_hold_releases
3384: WHERE hold_release_id = l_hold_release_id
3385: FOR UPDATE NOWAIT;
3386:
3387: DELETE FROM OE_HOLD_RELEASES
3388: WHERE HOLD_RELEASE_ID = l_hold_release_id;
3389: END IF;
3390: END LOOP;
3391: oe_debug_pub.add('Number of hold releases deleted : '||to_char(c_hold_releases%ROWCOUNT),1);