APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_HOLDS

Line 3304: FROM OE_ORDER_HOLDS

3300: CURSOR c_order_holds IS
3301: SELECT DISTINCT NVL(HOLD_RELEASE_ID,0),
3302: NVL(HOLD_SOURCE_ID,0),
3303: ORDER_HOLD_ID
3304: FROM OE_ORDER_HOLDS
3305: WHERE HEADER_ID = p_header_id;
3306:
3307: CURSOR c_hold_sources(p_hold_source_id NUMBER) IS
3308: SELECT hold_source_id

Line 3345: FROM oe_order_holds

3341:
3342: -- Lock the order holds record.
3343: SELECT order_hold_id
3344: INTO l_lock_order_hold_id
3345: FROM oe_order_holds
3346: WHERE order_hold_id = l_order_hold_id
3347: FOR UPDATE NOWAIT;
3348:
3349: OPEN c_hold_sources(l_hold_source_id);

Line 3377: select count(*) into l_count from OE_ORDER_HOLDS where

3373: FETCH c_hold_releases INTO l_hold_release_id;
3374: EXIT WHEN c_hold_releases%NOTFOUND -- end of fetch
3375: OR c_hold_releases%NOTFOUND IS NULL; -- empty cursor
3376: --bug 6148214
3377: select count(*) into l_count from OE_ORDER_HOLDS where
3378: hold_release_id = l_hold_release_id and HEADER_ID <> p_header_id;
3379: IF (l_count = 0) THEN
3380: -- Lock the order holds release record.
3381: SELECT hold_release_id

Line 3394: DELETE FROM OE_ORDER_HOLDS

3390: END LOOP;
3391: oe_debug_pub.add('Number of hold releases deleted : '||to_char(c_hold_releases%ROWCOUNT),1);
3392: CLOSE c_hold_releases;
3393:
3394: DELETE FROM OE_ORDER_HOLDS
3395: WHERE ORDER_HOLD_ID = l_order_hold_id;
3396:
3397: END LOOP;
3398: