APPS.BIS_KPILIST_WIZARD_PKG dependencies on FND_MENU_ENTRIES

Line 149: l_menu_id fnd_menu_entries.menu_id%TYPE;

145: l_function_id fnd_form_functions.function_id%TYPE;
146: l_created_by fnd_form_functions.created_by%TYPE;
147: l_seed_user fnd_form_functions.created_by%TYPE;
148:
149: l_menu_id fnd_menu_entries.menu_id%TYPE;
150: l_entry_sequence fnd_menu_entries.entry_sequence%TYPE;
151:
152: CURSOR function_id_crsr IS
153: SELECT function_id, created_by

Line 150: l_entry_sequence fnd_menu_entries.entry_sequence%TYPE;

146: l_created_by fnd_form_functions.created_by%TYPE;
147: l_seed_user fnd_form_functions.created_by%TYPE;
148:
149: l_menu_id fnd_menu_entries.menu_id%TYPE;
150: l_entry_sequence fnd_menu_entries.entry_sequence%TYPE;
151:
152: CURSOR function_id_crsr IS
153: SELECT function_id, created_by
154: FROM fnd_form_functions

Line 157: CURSOR menu_crsr (p_function_id fnd_menu_entries.function_id%TYPE) IS

153: SELECT function_id, created_by
154: FROM fnd_form_functions
155: WHERE function_name = p_function_name;
156:
157: CURSOR menu_crsr (p_function_id fnd_menu_entries.function_id%TYPE) IS
158: SELECT menu_id, entry_sequence
159: FROM fnd_menu_entries
160: WHERE function_id = p_function_id;
161: BEGIN

Line 159: FROM fnd_menu_entries

155: WHERE function_name = p_function_name;
156:
157: CURSOR menu_crsr (p_function_id fnd_menu_entries.function_id%TYPE) IS
158: SELECT menu_id, entry_sequence
159: FROM fnd_menu_entries
160: WHERE function_id = p_function_id;
161: BEGIN
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:

Line 187: DELETE FROM fnd_menu_entries WHERE function_id = l_function_id;

183: OPEN menu_crsr(l_function_id);
184: FETCH menu_crsr INTO l_menu_id, l_entry_sequence;
185: CLOSE menu_crsr;
186:
187: DELETE FROM fnd_menu_entries WHERE function_id = l_function_id;
188: DELETE FROM fnd_menu_entries_tl WHERE menu_id = l_menu_id AND entry_sequence = l_entry_sequence;
189:
190:
191: EXCEPTION

Line 188: DELETE FROM fnd_menu_entries_tl WHERE menu_id = l_menu_id AND entry_sequence = l_entry_sequence;

184: FETCH menu_crsr INTO l_menu_id, l_entry_sequence;
185: CLOSE menu_crsr;
186:
187: DELETE FROM fnd_menu_entries WHERE function_id = l_function_id;
188: DELETE FROM fnd_menu_entries_tl WHERE menu_id = l_menu_id AND entry_sequence = l_entry_sequence;
189:
190:
191: EXCEPTION
192: WHEN OTHERS THEN