APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_HOLDS

Line 3358: FROM OE_ORDER_HOLDS

3354: CURSOR c_order_holds IS
3355: SELECT DISTINCT NVL(HOLD_RELEASE_ID,0),
3356: NVL(HOLD_SOURCE_ID,0),
3357: ORDER_HOLD_ID
3358: FROM OE_ORDER_HOLDS
3359: WHERE HEADER_ID = p_header_id;
3360:
3361: CURSOR c_hold_sources(p_hold_source_id NUMBER) IS
3362: SELECT hold_source_id

Line 3399: FROM oe_order_holds

3395:
3396: -- Lock the order holds record.
3397: SELECT order_hold_id
3398: INTO l_lock_order_hold_id
3399: FROM oe_order_holds
3400: WHERE order_hold_id = l_order_hold_id
3401: FOR UPDATE NOWAIT;
3402:
3403: OPEN c_hold_sources(l_hold_source_id);

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

3427: FETCH c_hold_releases INTO l_hold_release_id;
3428: EXIT WHEN c_hold_releases%NOTFOUND -- end of fetch
3429: OR c_hold_releases%NOTFOUND IS NULL; -- empty cursor
3430: --bug 6148214
3431: select count(*) into l_count from OE_ORDER_HOLDS where
3432: hold_release_id = l_hold_release_id and HEADER_ID <> p_header_id;
3433: IF (l_count = 0) THEN
3434: -- Lock the order holds release record.
3435: SELECT hold_release_id

Line 3448: DELETE FROM OE_ORDER_HOLDS

3444: END LOOP;
3445: oe_debug_pub.add('Number of hold releases deleted : '||to_char(c_hold_releases%ROWCOUNT),1);
3446: CLOSE c_hold_releases;
3447:
3448: DELETE FROM OE_ORDER_HOLDS
3449: WHERE ORDER_HOLD_ID = l_order_hold_id;
3450:
3451: END LOOP;
3452: