DBA Data[Home] [Help]

APPS.JTFB_DCF dependencies on FND_MENUS

Line 33: FROM fnd_menus fm

29: WHERE sub_menu_id = cp_sub_menu_id;
30:
31: CURSOR c_menus IS
32: SELECT fm.menu_id menu_id
33: FROM fnd_menus fm
34: WHERE fm.menu_name like 'DCF_%' AND
35: NOT EXISTS (
36: SELECT 1 FROM fnd_menu_entries
37: WHERE menu_id = fm.menu_id );

Line 54: fnd_menus_pkg.delete_row(x_menu_id => mrec.menu_id);

50: l_fme_count := l_fme_count + 1;
51: END LOOP;
52: CLOSE c_entry;
53: -- Delete the DCF Menu
54: fnd_menus_pkg.delete_row(x_menu_id => mrec.menu_id);
55: l_fm_count := l_fm_count + 1;
56: END LOOP;
57:
58: -- dbms_output.put_line(to_char(l_fm_count)||' '||'DCF Menus Deleted');