DBA Data[Home] [Help]

APPS.OE_ORDER_PURGE_PVT dependencies on OE_SETS_HISTORY

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