DBA Data[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on FND_MENU_ENTRIES

Line 612: Select entry_sequence from fnd_menu_entries

608: Select menu_id from fnd_menus
609: where menu_name = 'IEX_COLL';
610:
611: CURSOR get_entry_sequence(p_menu_id NUMBER, p_function_id NUMBER) IS
612: Select entry_sequence from fnd_menu_entries
613: where menu_id = p_menu_id
614: and function_id = p_function_id;
615:
616: l_entry_sequence number := 0;

Line 708: FND_MENU_ENTRIES_PKG.update_row(

704: end if;
705:
706: close get_entry_sequence;
707:
708: FND_MENU_ENTRIES_PKG.update_row(
709: x_menu_id => l_menu_id,
710: x_entry_sequence => l_entry_sequence,
711: x_sub_menu_id => null,
712: x_function_id => l_func_id,

Line 771: update fnd_menu_entries set grant_flag = 'Y' where menu_id = 1006151 and function_id = 1011354;

767: -- if p_collections_methods = 'STRATEGIES' then
768: -- commented above if and added below Added by snuthala for bug 10221334 21/10/2010
769:
770: if p_collections_methods <> 'DUNNING' then
771: update fnd_menu_entries set grant_flag = 'Y' where menu_id = 1006151 and function_id = 1011354;
772: else
773: update fnd_menu_entries set grant_flag = 'N' where menu_id = 1006151 and function_id = 1011354;
774: end if;
775: exception

Line 773: update fnd_menu_entries set grant_flag = 'N' where menu_id = 1006151 and function_id = 1011354;

769:
770: if p_collections_methods <> 'DUNNING' then
771: update fnd_menu_entries set grant_flag = 'Y' where menu_id = 1006151 and function_id = 1011354;
772: else
773: update fnd_menu_entries set grant_flag = 'N' where menu_id = 1006151 and function_id = 1011354;
774: end if;
775: exception
776: when others then
777: null;