APPS.OE_ORDER_PURGE_PVT dependencies on OE_SETS

Line 2164: select set_id from oe_sets_history

2160: WHERE header_id = p_header_id
2161: FOR UPDATE NOWAIT;
2162:
2163: cursor c_purge_set_history is --bug#5631508
2164: select set_id from oe_sets_history
2165: where header_id= p_header_id
2166: FOR UPDATE NOWAIT;
2167:
2168: l_doc_tbl OE_CONTRACTS_UTIL.doc_tbl_type;

Line 2342: DELETE FROM oe_sets_history WHERE header_id = p_header_id;

2338: OE_DEBUG_PUB.Add('After Deleting Sales Credit history='|| to_char(p_header_id));
2339:
2340: OPEN c_purge_set_history; --bug#5631508
2341: CLOSE c_purge_set_history;
2342: DELETE FROM oe_sets_history WHERE header_id = p_header_id;
2343:
2344: -- Purging Contract Articles
2345:
2346: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN

Line 3175: FROM OE_SETS

3171: IS
3172:
3173: CURSOR c_order_sets IS
3174: SELECT SET_ID
3175: FROM OE_SETS
3176: WHERE HEADER_ID = p_header_id;
3177:
3178: l_set_id NUMBER;
3179: l_lock_set_id NUMBER;

Line 3196: FROM oe_sets

3192:
3193: -- Lock the set record.
3194: SELECT set_id
3195: INTO l_lock_set_id
3196: FROM oe_sets
3197: WHERE set_id = l_set_id
3198: FOR UPDATE NOWAIT;
3199:
3200: DELETE FROM OE_SETS

Line 3200: DELETE FROM OE_SETS

3196: FROM oe_sets
3197: WHERE set_id = l_set_id
3198: FOR UPDATE NOWAIT;
3199:
3200: DELETE FROM OE_SETS
3201: WHERE SET_ID = l_set_id;
3202:
3203: END LOOP;
3204: