[Home] [Help]
51:
52: begin
53: select nvl(max(entry_sequence), 0) + 1
54: into l_new_entry_sequence
55: from fnd_menu_entries
56: where menu_id = X_MENU_ID;
57: exception
58: when no_data_found then l_new_entry_sequence :=1;
59: end;
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 ,
214: X_OLD_ENTRY_SEQUENCE in NUMBER,
215: X_FUNCTION_ID in NUMBER,
216: X_PROMPT in VARCHAR2) is
217:
218: l_des fnd_menu_entries_vl.description%TYPE;
219: CURSOR c1 is
220: SELECT description
221: FROM fnd_menu_entries_vl f
222: WHERE f.menu_id = X_MENU_ID
217:
218: l_des fnd_menu_entries_vl.description%TYPE;
219: CURSOR c1 is
220: SELECT description
221: FROM fnd_menu_entries_vl f
222: WHERE f.menu_id = X_MENU_ID
223: AND f.entry_sequence = X_OLD_ENTRY_SEQUENCE;
224:
225: begin
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(
295: x_msg_data OUT NOCOPY VARCHAR2) is
296:
297: cursor entry_sequence_cursor is
298: select entry_sequence
299: from fnd_menu_entries
300: where menu_id = X_MENU_ID;
301: l_result VARCHAR2(1);
302: begin
303:
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:
358:
359: for i in 1..p_menu_ids.count loop
360: -- Check if menu attachment already exists, then leave it alone
361: select count(1) into l_count
362: from fnd_menu_entries
363: where function_id = p_function_id
364: and menu_id = p_menu_ids(i);
365:
366: if (l_count = 0) then
421:
422: for i in 1..p_function_ids.count loop
423: -- Check if function is added to the menu, then leave it alone
424: select count(1) into l_count
425: from fnd_menu_entries
426: where function_id = p_function_ids(i)
427: and menu_id = p_menu_id;
428:
429: if (l_count = 0) then
477: is
478:
479: cursor entry_seq_cursor(p_function_id NUMBER) is
480: select entry_sequence
481: from fnd_menu_entries
482: where function_id = p_function_id
483: and menu_id = p_menu_id;
484:
485: p_return_status VARCHAR2(40);
535: ) is
536:
537: cursor entry_seq_cursor(p_menu_id NUMBER) is
538: select entry_sequence
539: from fnd_menu_entries
540: where function_id = p_function_id
541: and menu_id = p_menu_id;
542:
543: p_return_status VARCHAR2(40);
594: l_last_update_date date;
595:
596: cursor cMenuEntry is
597: select last_update_date
598: from fnd_menu_entries
599: where menu_id = p_menu_id
600: and entry_sequence = p_entry_sequence
601: for update of menu_id, entry_sequence nowait;
602:
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);