APPS.JTFB_DCF dependencies on FND_MENU_ENTRIES

Line 20: l_entry_sequence fnd_menu_entries.entry_sequence%TYPE;

16: --Change History: (who, when, what: NO CREATION RECORDS HERE!)
17: --Who When What
18: ------------------------------------------------------------------------
19:
20: l_entry_sequence fnd_menu_entries.entry_sequence%TYPE;
21: l_menu_id fnd_menu_entries.menu_id%TYPE;
22: l_fm_count NUMBER := 0;
23: l_fme_count NUMBER := 0;
24:

Line 21: l_menu_id fnd_menu_entries.menu_id%TYPE;

17: --Who When What
18: ------------------------------------------------------------------------
19:
20: l_entry_sequence fnd_menu_entries.entry_sequence%TYPE;
21: l_menu_id fnd_menu_entries.menu_id%TYPE;
22: l_fm_count NUMBER := 0;
23: l_fme_count NUMBER := 0;
24:
25: CURSOR c_entry(cp_sub_menu_id fnd_menu_entries.sub_menu_id%TYPE) IS

Line 25: CURSOR c_entry(cp_sub_menu_id fnd_menu_entries.sub_menu_id%TYPE) IS

21: l_menu_id fnd_menu_entries.menu_id%TYPE;
22: l_fm_count NUMBER := 0;
23: l_fme_count NUMBER := 0;
24:
25: CURSOR c_entry(cp_sub_menu_id fnd_menu_entries.sub_menu_id%TYPE) IS
26: SELECT menu_id,
27: entry_sequence
28: FROM fnd_menu_entries
29: WHERE sub_menu_id = cp_sub_menu_id;

Line 28: FROM fnd_menu_entries

24:
25: CURSOR c_entry(cp_sub_menu_id fnd_menu_entries.sub_menu_id%TYPE) IS
26: SELECT menu_id,
27: entry_sequence
28: FROM fnd_menu_entries
29: WHERE sub_menu_id = cp_sub_menu_id;
30:
31: CURSOR c_menus IS
32: SELECT fm.menu_id menu_id

Line 36: SELECT 1 FROM fnd_menu_entries

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 );
38:
39: BEGIN
40:

Line 48: fnd_menu_entries_pkg.delete_row(x_menu_id => l_menu_id,

44: OPEN c_entry(mrec.menu_id);
45: LOOP
46: FETCH c_entry INTO l_menu_id, l_entry_sequence;
47: EXIT WHEN c_entry%NOTFOUND;
48: fnd_menu_entries_pkg.delete_row(x_menu_id => l_menu_id,
49: x_entry_sequence => l_entry_sequence);
50: l_fme_count := l_fme_count + 1;
51: END LOOP;
52: CLOSE c_entry;