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;