154: ------------------------------------------------------------------------------
155:
156: procedure get_excl_menu_tree_recurs_tl(p_lang varchar2, p_menu_id number,
157: p_respid number, p_appid number,
158: p_kids_menu_ids in out nocopy jtf_menu_pub.number_table,
159: p_kids_menu_data in out nocopy jtf_menu_pub.menu_table)
160: is
161: t_new_ids num_tab_ibbi;
162: t_mt jtf_menu_pub.menu_table;
155:
156: procedure get_excl_menu_tree_recurs_tl(p_lang varchar2, p_menu_id number,
157: p_respid number, p_appid number,
158: p_kids_menu_ids in out nocopy jtf_menu_pub.number_table,
159: p_kids_menu_data in out nocopy jtf_menu_pub.menu_table)
160: is
161: t_new_ids num_tab_ibbi;
162: t_mt jtf_menu_pub.menu_table;
163: cnt number;
158: p_kids_menu_ids in out nocopy jtf_menu_pub.number_table,
159: p_kids_menu_data in out nocopy jtf_menu_pub.menu_table)
160: is
161: t_new_ids num_tab_ibbi;
162: t_mt jtf_menu_pub.menu_table;
163: cnt number;
164: loc number;
165: begin
166: jtf_menu_pub.get_excluded_menu_entries_tl(p_lang, p_menu_id, p_respid, p_appid, t_mt);
162: t_mt jtf_menu_pub.menu_table;
163: cnt number;
164: loc number;
165: begin
166: jtf_menu_pub.get_excluded_menu_entries_tl(p_lang, p_menu_id, p_respid, p_appid, t_mt);
167:
168: if t_mt is null or t_mt.count = 0 then return; end if;
169:
170: cnt := t_mt.first;