APPS.FND_GRANTS_PKG dependencies on FND_MENUS

Line 757: from fnd_menus

753: if (X_MENU_NAME is not NULL) then
754: begin
755: select menu_id
756: into mnu_id
757: from fnd_menus
758: where menu_name = X_MENU_NAME;
759: exception
760: when no_data_found then
761: mnu_id := NULL;

Line 767: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_MENUS');

763: if (mnu_id is NULL) then
764: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
765: FND_MESSAGE.SET_TOKEN('VALUE', X_MENU_NAME);
766: FND_MESSAGE.SET_TOKEN('COLUMN', 'MENU_NAME');
767: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_MENUS');
768: app_exception.raise_exception;
769: end if;
770: else
771: mnu_id := NULL;

Line 1086: FROM fnd_menus

1082: app_id number := NULL;
1083:
1084: CURSOR get_menu_id(p_menu_name VARCHAR2) IS
1085: SELECT menu_id
1086: FROM fnd_menus
1087: WHERE menu_name =p_menu_name;
1088:
1089:
1090: CURSOR get_object_id (p_object_name varchar2) is

Line 1129: -- get role id for from FND_MENUS

1125: x_success := FND_API.G_TRUE;
1126:
1127:
1128: -- Step 2
1129: -- get role id for from FND_MENUS
1130: OPEN get_menu_id(p_menu_name);
1131: FETCH get_menu_id INTO l_menu_id;
1132: IF (get_menu_id%NOTFOUND) THEN
1133: CLOSE get_menu_id;

Line 1534: FROM FND_MENUS

1530: invalid_args EXCEPTION;
1531:
1532: CURSOR get_menu_id(p_menu_name VARCHAR2) IS
1533: SELECT menu_id
1534: FROM FND_MENUS
1535: WHERE menu_name = p_menu_name;
1536:
1537: CURSOR get_object_id(p_object_name VARCHAR2) IS
1538: SELECT object_id