APPS.OE_ADV_ITEM_PURGE dependencies on OE_SELECTED_ITEMS

Line 27: delete from oe_selected_items

23: IS
24:
25: BEGIN
26:
27: delete from oe_selected_items
28: where used_flag = 'Y';
29:
30: commit;
31:

Line 35: oe_debug_pub.add( 'Error in deleting data from oe_selected_items '||sqlerrm);

31:
32: EXCEPTION
33:
34: WHEN OTHERS THEN
35: oe_debug_pub.add( 'Error in deleting data from oe_selected_items '||sqlerrm);
36: retcode := 2;
37: errbuf := sqlerrm;
38:
39: END PURGE_USED_SESSIONS;