496: SELECT function_id
497: FROM fnd_form_functions
498: WHERE function_name = p_function_name;
499:
500: CURSOR c_menu_entries (p_function_id fnd_menu_entries.function_id%TYPE) IS
501: SELECT menu_id, entry_sequence
502: FROM fnd_menu_entries
503: WHERE function_id = p_function_id;
504: BEGIN
498: WHERE function_name = p_function_name;
499:
500: CURSOR c_menu_entries (p_function_id fnd_menu_entries.function_id%TYPE) IS
501: SELECT menu_id, entry_sequence
502: FROM fnd_menu_entries
503: WHERE function_id = p_function_id;
504: BEGIN
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
565: l_msg_count NUMBER;
566: l_msg_data VARCHAR2(40);
567: cursor entry_seq_menu_cursor is
568: select menu_id, entry_sequence
569: from fnd_menu_entries
570: where function_id = p_FUNCTION_ID;
571: BEGIN
572:
573: for ent_seq_menu_cur in entry_seq_menu_cursor loop
651: ,x_msg_count OUT NOCOPY NUMBER
652: ,x_msg_data OUT NOCOPY VARCHAR2
653: )
654: IS
655: CURSOR menu_crsr (p_function_id fnd_menu_entries.function_id%TYPE) IS
656: SELECT menu_id, entry_sequence
657: FROM fnd_menu_entries
658: WHERE function_id = p_function_id;
659: BEGIN
653: )
654: IS
655: CURSOR menu_crsr (p_function_id fnd_menu_entries.function_id%TYPE) IS
656: SELECT menu_id, entry_sequence
657: FROM fnd_menu_entries
658: WHERE function_id = p_function_id;
659: BEGIN
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661: