DBA Data[Home] [Help]

APPS.OE_ORDER_PURGE_PVT dependencies on OE_SETS_HISTORY

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