57: exception
58: when no_data_found then l_new_entry_sequence :=1;
59: end;
60:
61: FND_MENU_ENTRIES_PKG.INSERT_ROW(
62: X_ROWID => X_ROWID,
63: X_MENU_ID => X_MENU_ID,
64: X_ENTRY_SEQUENCE => l_new_entry_sequence,
65: X_SUB_MENU_ID => null,
100: begin
101:
102: fnd_msg_pub.initialize;
103:
104: FND_MENU_ENTRIES_PKG.INSERT_ROW(
105: X_ROWID => l_ROWID,
106: X_MENU_ID => X_MENU_ID,
107: X_ENTRY_SEQUENCE => X_ENTRY_SEQUENCE,
108: X_SUB_MENU_ID => X_SUB_MENU_ID,
163: begin
164:
165: fnd_msg_pub.initialize;
166:
167: FND_MENU_ENTRIES_PKG.UPDATE_ROW(
168: X_MENU_ID => X_MENU_ID,
169: X_ENTRY_SEQUENCE => X_ENTRY_SEQUENCE,
170: X_SUB_MENU_ID => X_SUB_MENU_ID,
171: X_FUNCTION_ID => X_FUNCTION_ID ,
227: OPEN c1;
228: FETCH c1 INTO l_des;
229: CLOSE c1;
230:
231: FND_MENU_ENTRIES_PKG.UPDATE_ROW(
232: X_MENU_ID => X_MENU_ID,
233: X_ENTRY_SEQUENCE => X_OLD_ENTRY_SEQUENCE,
234: X_SUB_MENU_ID => null,
235: X_FUNCTION_ID => X_FUNCTION_ID ,
253: begin
254:
255: fnd_msg_pub.initialize;
256:
257: FND_MENU_ENTRIES_PKG.DELETE_ROW(
258: X_MENU_ID => X_MENU_ID,
259: X_ENTRY_SEQUENCE => X_ENTRY_SEQUENCE);
260:
261: BIS_FND_MENUS_PUB.UPDATE_ROW(
304: fnd_msg_pub.initialize;
305:
306: for entry_seq_cursor in entry_sequence_cursor loop
307:
308: FND_MENU_ENTRIES_PKG.DELETE_ROW(
309: X_MENU_ID => X_MENU_ID,
310: X_ENTRY_SEQUENCE => entry_seq_cursor.entry_sequence);
311: end loop;
312:
662: l_userId := FND_GLOBAL.USER_ID;
663: l_respId := FND_GLOBAL.RESP_ID;
664: l_respAppId := FND_GLOBAL.RESP_APPL_ID;
665:
666: l_result := FND_MENU_ENTRIES_PKG.SUBMIT_COMPILE;
667:
668: /** restore the application context back */
669:
670: FND_GLOBAL.APPS_INITIALIZE(l_userId,l_respId,l_respAppId);