eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_LAUNCH_PAD_PUB dependencies on FND_MENUS

Line 58: p_Menu_Id FND_MENUS.menu_id%TYPE

54:
55:
56: FUNCTION get_next_entry_sequence
57: (
58: p_Menu_Id FND_MENUS.menu_id%TYPE
59: )RETURN NUMBER
60: IS
61: l_count NUMBER;
62: BEGIN

Line 109: p_Menu_Id IN FND_MENUS.MENU_ID%TYPE

105: Creator:- ashankar 21-OCT-2003
106: /******************************************************************************/
107:
108: FUNCTION get_Menu_Name(
109: p_Menu_Id IN FND_MENUS.MENU_ID%TYPE
110: )
111: RETURN VARCHAR2
112: IS
113: BEGIN

Line 214: p_Menu_Name IN FND_MENUS.MENU_NAME%TYPE

210: Creator :- ashankar 26-OCT-2003
211: /*****************************************************************************/
212:
213: FUNCTION get_Menu_Id_From_Menu_Name(
214: p_Menu_Name IN FND_MENUS.MENU_NAME%TYPE
215: )RETURN NUMBER
216: IS
217: l_menu_id FND_MENUS.MENU_ID%TYPE;
218: BEGIN

Line 217: l_menu_id FND_MENUS.MENU_ID%TYPE;

213: FUNCTION get_Menu_Id_From_Menu_Name(
214: p_Menu_Name IN FND_MENUS.MENU_NAME%TYPE
215: )RETURN NUMBER
216: IS
217: l_menu_id FND_MENUS.MENU_ID%TYPE;
218: BEGIN
219:
220: SELECT menu_id
221: INTO l_menu_id

Line 222: FROM fnd_menus

218: BEGIN
219:
220: SELECT menu_id
221: INTO l_menu_id
222: FROM fnd_menus
223: WHERE menu_name = p_Menu_Name;
224:
225: RETURN l_menu_id;
226:

Line 237: p_Menu_Id IN FND_MENUS.MENU_ID%TYPE

233: Ouput :- l_menu_name
234: Creator :- ashankar 26-OCT-2003
235: /*****************************************************************************/
236: FUNCTION get_Menu_Name_From_Menu_Id(
237: p_Menu_Id IN FND_MENUS.MENU_ID%TYPE
238: )RETURN VARCHAR2
239: IS
240: l_menu_name FND_MENUS.MENU_NAME%TYPE;
241: BEGIN

Line 240: l_menu_name FND_MENUS.MENU_NAME%TYPE;

236: FUNCTION get_Menu_Name_From_Menu_Id(
237: p_Menu_Id IN FND_MENUS.MENU_ID%TYPE
238: )RETURN VARCHAR2
239: IS
240: l_menu_name FND_MENUS.MENU_NAME%TYPE;
241: BEGIN
242:
243: SELECT menu_name
244: INTO l_menu_name

Line 245: FROM fnd_menus

241: BEGIN
242:
243: SELECT menu_name
244: INTO l_menu_name
245: FROM fnd_menus
246: WHERE menu_id = p_Menu_Id;
247:
248: RETURN l_menu_name;
249:

Line 275: FROM FND_MENUS_VL A

271:
272: CURSOR c_root_menu IS
273: SELECT DISTINCT A.Menu_Id
274: , A.Menu_Name
275: FROM FND_MENUS_VL A
276: ,FND_RESPONSIBILITY_VL B
277: WHERE B.Application_Id =271
278: AND B.Menu_Id = A.MENU_ID
279: AND B.Responsibility_Id IN (SELECT DISTINCT Responsibility_Id from BSC_USER_TAB_ACCESS);

Line 308: p_Launchpad_Id IN FND_MENUS.menu_id%TYPE

304: /********************************************************************************/
305:
306: PROCEDURE Add_Launch_Pad_Root_Menu
307: (
308: p_Launchpad_Id IN FND_MENUS.menu_id%TYPE
309: , p_Description IN VARCHAR2
310: , x_return_status OUT NOCOPY VARCHAR2
311: , x_msg_count OUT NOCOPY NUMBER
312: , x_msg_data OUT NOCOPY VARCHAR2

Line 386: Description :-This fucntion creates the lauchpad entry into FND_MENUS.

382: END Add_Launch_Pad_Root_Menu;
383:
384: /*****************************************************************************
385: Name :- Create_Launch_Pad
386: Description :-This fucntion creates the lauchpad entry into FND_MENUS.
387: Validations :-
388:
389: 1. Generate the menu id internally
390: 2. Generate the menu name internally if null.

Line 421: l_user_id FND_MENUS.LAST_UPDATED_BY%TYPE := NULL;

417: ,x_msg_data OUT NOCOPY VARCHAR2
418: ) IS
419:
420: l_check_val VARCHAR2(2);
421: l_user_id FND_MENUS.LAST_UPDATED_BY%TYPE := NULL;
422: l_count NUMBER :=0;
423: l_fucntion_ids VARCHAR2(32000);
424: l_fucntion_id VARCHAR2(10);
425: l_menu_id FND_MENUS.menu_id%TYPE;

Line 425: l_menu_id FND_MENUS.menu_id%TYPE;

421: l_user_id FND_MENUS.LAST_UPDATED_BY%TYPE := NULL;
422: l_count NUMBER :=0;
423: l_fucntion_ids VARCHAR2(32000);
424: l_fucntion_id VARCHAR2(10);
425: l_menu_id FND_MENUS.menu_id%TYPE;
426: l_sequence NUMBER;
427: l_menu_name FND_MENUS.menu_name%TYPE;
428:
429: BEGIN

Line 427: l_menu_name FND_MENUS.menu_name%TYPE;

423: l_fucntion_ids VARCHAR2(32000);
424: l_fucntion_id VARCHAR2(10);
425: l_menu_id FND_MENUS.menu_id%TYPE;
426: l_sequence NUMBER;
427: l_menu_name FND_MENUS.menu_name%TYPE;
428:
429: BEGIN
430:
431: SAVEPOINT CreateLaunchPad;

Line 442: SELECT FND_MENUS_S.NEXTVAL

438: FND_MSG_PUB.ADD;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;
441:
442: SELECT FND_MENUS_S.NEXTVAL
443: INTO l_menu_id
444: FROM DUAL;
445:
446: l_menu_name := p_menu_name;

Line 612: FROM FND_MENUS_VL

608: ,x_launch_pad_Rec.Bsc_last_updated_by
609: ,x_launch_pad_Rec.Bsc_last_update_login
610: ,x_launch_pad_Rec.Bsc_user_menu_name
611: ,x_launch_pad_Rec.Bsc_description
612: FROM FND_MENUS_VL
613: WHERE menu_id = p_menu_id;
614:
615: EXCEPTION
616: WHEN NO_DATA_FOUND THEN

Line 709: FND_MENUS_PKG.UPDATE_ROW

705: IF(p_launch_pad_rec.Bsc_type IS NOT NULL) THEN
706: l_launch_pad_rec.Bsc_type := p_launch_pad_rec.Bsc_type;
707: END IF;
708:
709: FND_MENUS_PKG.UPDATE_ROW
710: (
711: X_MENU_ID => l_launch_pad_rec.Bsc_menu_id
712: ,X_MENU_NAME => l_launch_pad_rec.Bsc_menu_name
713: ,X_USER_MENU_NAME => l_launch_pad_rec.Bsc_user_menu_name

Line 795: l_menu_name FND_MENUS.menu_name%TYPE;

791: l_launch_pad_rec BSC_LAUNCH_PAD_PUB.Bsc_LauchPad_Rec_Type;
792: l_fucntion_ids VARCHAR2(32000);
793: l_fucntion_id VARCHAR2(10);
794: l_sequence NUMBER;
795: l_menu_name FND_MENUS.menu_name%TYPE;
796: l_count NUMBER :=0;
797:
798: BEGIN
799: FND_MSG_PUB.Initialize;

Line 961: p_Launch_Pad_Id FND_MENUS.menu_id%TYPE

957: /**************************************************************************************/
958:
959: PROCEDURE Delete_Root_Menu_LaunchPad
960: (
961: p_Launch_Pad_Id FND_MENUS.menu_id%TYPE
962: , x_return_status OUT NOCOPY VARCHAR2
963: , x_msg_count OUT NOCOPY NUMBER
964: , x_msg_data OUT NOCOPY VARCHAR2
965: )IS

Line 1019: | Description: It is a wrapper for FND_MENUS_PKG.DELETE_ROW function.

1015: /*===========================================================================+
1016: |
1017: | Name: Delte_Launch_Pad
1018: |
1019: | Description: It is a wrapper for FND_MENUS_PKG.DELETE_ROW function.
1020: | This procedure is to be called from a JAVA Layer
1021: |
1022: | Parameters: x_menu_id - Menu id of the Launch Pad
1023: | Validations : need to check if the menu id being passed is the valid one or not.

Line 1065: FND_MENUS_PKG.DELETE_ROW

1061: RAISE FND_API.G_EXC_ERROR;
1062:
1063: END IF;
1064:
1065: FND_MENUS_PKG.DELETE_ROW
1066: (
1067: X_MENU_ID => p_menu_id
1068: );
1069:

Line 1726: FROM FND_MENUS_TL

1722:
1723: BEGIN
1724: SELECT COUNT(0)
1725: INTO l_count
1726: FROM FND_MENUS_TL
1727: WHERE MENU_ID = p_Menu_Id;
1728:
1729:
1730: RETURN l_count;