DBA Data[Home] [Help]

APPS.OE_ORDER_PURGE_PVT dependencies on OE_SETS

Line 2190: select set_id from oe_sets_history

2186: FOR UPDATE NOWAIT;
2187: --16193599 Audit History Purge End
2188:
2189: cursor c_purge_set_history is --bug#5631508
2190: select set_id from oe_sets_history
2191: where header_id= p_header_id
2192: FOR UPDATE NOWAIT;
2193:
2194: l_doc_tbl OE_CONTRACTS_UTIL.doc_tbl_type;

Line 2396: DELETE FROM oe_sets_history WHERE header_id = p_header_id;

2392: OE_DEBUG_PUB.Add('After Deleting Sales Credit history='|| to_char(p_header_id));
2393:
2394: OPEN c_purge_set_history; --bug#5631508
2395: CLOSE c_purge_set_history;
2396: DELETE FROM oe_sets_history WHERE header_id = p_header_id;
2397:
2398: -- Purging Contract Articles
2399:
2400: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN

Line 3229: FROM OE_SETS

3225: IS
3226:
3227: CURSOR c_order_sets IS
3228: SELECT SET_ID
3229: FROM OE_SETS
3230: WHERE HEADER_ID = p_header_id;
3231:
3232: l_set_id NUMBER;
3233: l_lock_set_id NUMBER;

Line 3250: FROM oe_sets

3246:
3247: -- Lock the set record.
3248: SELECT set_id
3249: INTO l_lock_set_id
3250: FROM oe_sets
3251: WHERE set_id = l_set_id
3252: FOR UPDATE NOWAIT;
3253:
3254: DELETE FROM OE_SETS

Line 3254: DELETE FROM OE_SETS

3250: FROM oe_sets
3251: WHERE set_id = l_set_id
3252: FOR UPDATE NOWAIT;
3253:
3254: DELETE FROM OE_SETS
3255: WHERE SET_ID = l_set_id;
3256:
3257: END LOOP;
3258: