APPS.BIS_FND_MENUS_PUB dependencies on FND_MENUS

Line 1: PACKAGE BODY BIS_FND_MENUS_PUB as

1: PACKAGE BODY BIS_FND_MENUS_PUB as
2: /* $Header: BISPFMNB.pls 120.0 2005/05/31 18:23:34 appldev noship $ */
3: ----------------------------------------------------------------------------
4: -- PACKAGE: BIS_FND_MENUS_PUB --
5: -- --

Line 4: -- PACKAGE: BIS_FND_MENUS_PUB --

1: PACKAGE BODY BIS_FND_MENUS_PUB as
2: /* $Header: BISPFMNB.pls 120.0 2005/05/31 18:23:34 appldev noship $ */
3: ----------------------------------------------------------------------------
4: -- PACKAGE: BIS_FND_MENUS_PUB --
5: -- --
6: -- DESCRIPTION: Private package that calls the FND packages to --
7: -- insert records in the FND tables. --
8: -- --

Line 43: from fnd_menus_vl

39:
40: begin
41: select menu_name, user_menu_name
42: into l_menu_name, l_user_menu_name
43: from fnd_menus_vl
44: where menu_name = p_menu_name
45: or user_menu_name = p_user_menu_name;
46: exception
47: when others then null;

Line 63: select FND_MENUS_S.NEXTVAL into l_new_menu_id from dual;

59: RAISE FND_API.G_EXC_ERROR;
60: end if;
61:
62: if X_MENU_ID IS NULL then
63: select FND_MENUS_S.NEXTVAL into l_new_menu_id from dual;
64: else
65: l_new_menu_id := X_MENU_ID;
66: end if;
67:

Line 68: FND_MENUS_PKG.INSERT_ROW(

64: else
65: l_new_menu_id := X_MENU_ID;
66: end if;
67:
68: FND_MENUS_PKG.INSERT_ROW(
69: X_ROWID => l_ROWID,
70: X_MENU_ID => l_new_menu_id,
71: X_MENU_NAME => upper(p_MENU_NAME),
72: X_USER_MENU_NAME => p_USER_MENU_NAME,

Line 126: from fnd_menus_vl

122: select menu_name,
123: type,
124: user_menu_name,
125: description
126: from fnd_menus_vl
127: where menu_id = p_MENU_ID;
128:
129: l_count NUMBER;
130: begin

Line 150: from fnd_menus_vl

146: l_fnd_menu_rec.user_menu_name := p_user_menu_name;
147:
148: select count(1)
149: into l_count
150: from fnd_menus_vl
151: where menu_id <> p_menu_id
152: and user_menu_name = p_user_menu_name;
153:
154: if l_count > 0 then

Line 165: FND_MENUS_PKG.UPDATE_ROW(

161: if (p_description <> BIS_COMMON_UTILS.G_DEF_CHAR) then
162: l_fnd_menu_rec.description := p_description;
163: end if;
164:
165: FND_MENUS_PKG.UPDATE_ROW(
166: X_MENU_ID => p_MENU_ID,
167: X_MENU_NAME => l_fnd_menu_rec.menu_name,
168: X_USER_MENU_NAME => l_fnd_menu_rec.user_menu_name,
169: X_MENU_TYPE => l_fnd_menu_rec.type,

Line 220: from fnd_menus_vl m, fnd_menu_entries_vl me

216: ) IS
217:
218: cursor cr_menu_usage is
219: select m.user_menu_name
220: from fnd_menus_vl m, fnd_menu_entries_vl me
221: where sub_menu_id = p_menu_id
222: and me.menu_id = m.menu_id;
223:
224: cursor cr_resp_usage is

Line 323: select menu_id into l_menu_id from fnd_menus where menu_id = p_menu_id for update of menu_id nowait;

319: validate_delete(p_menu_id, x_return_status, x_msg_count, x_msg_data);
320:
321: if (x_return_status is null) then
322: begin
323: select menu_id into l_menu_id from fnd_menus where menu_id = p_menu_id for update of menu_id nowait;
324: FND_MENUS_PKG.DELETE_ROW(X_MENU_ID => p_MENU_ID);
325: exception
326: when others then
327: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_DELETED_ERROR');

Line 324: FND_MENUS_PKG.DELETE_ROW(X_MENU_ID => p_MENU_ID);

320:
321: if (x_return_status is null) then
322: begin
323: select menu_id into l_menu_id from fnd_menus where menu_id = p_menu_id for update of menu_id nowait;
324: FND_MENUS_PKG.DELETE_ROW(X_MENU_ID => p_MENU_ID);
325: exception
326: when others then
327: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_DELETED_ERROR');
328: FND_MSG_PUB.ADD;

Line 382: FND_MENUS_PKG.DELETE_ROW(X_MENU_ID => p_MENU_ID);

378: x_msg_count => l_msg_count,
379: x_msg_data => l_msg_data);
380:
381: begin
382: FND_MENUS_PKG.DELETE_ROW(X_MENU_ID => p_MENU_ID);
383: exception
384: when no_data_found then
385: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_DELETED_ERROR');
386: FND_MSG_PUB.ADD;

Line 423: from fnd_menus

419: l_last_update_date date;
420:
421: cursor cMenu is
422: select last_update_date
423: from fnd_menus
424: where menu_id = p_menu_id
425: for update of menu_id nowait;
426:
427: BEGIN

Line 468: END BIS_FND_MENUS_PUB;

464: END LOCK_ROW;
465:
466:
467:
468: END BIS_FND_MENUS_PUB;