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_PVT dependencies on FND_MENUS

Line 11: | Description: it is a wrapper for FND_MENUS_PKG.INSERT_ROW function

7: /*===========================================================================+
8: |
9: | Name: INSERT_APP_MENU_VB
10: |
11: | Description: it is a wrapper for FND_MENUS_PKG.INSERT_ROW function
12: | This procedure is to be called from a VB program.
13: | If there is an error, the procedure inserts the error
14: | message in BSC_MESSAGE_LOGS table.
15: |

Line 35: DELETE FND_MENUS WHERE MENU_ID = X_MENU_ID;

31: X_USER_ID in NUMBER
32: ) IS
33: row_id VARCHAR2(30);
34: BEGIN
35: DELETE FND_MENUS WHERE MENU_ID = X_MENU_ID;
36: DELETE FND_MENUS_TL WHERE MENU_ID = X_MENU_ID;
37: FND_MENUS_PKG.INSERT_ROW( X_ROWID => row_id,
38: X_MENU_ID => X_MENU_ID,
39: X_MENU_NAME => X_MENU_NAME,

Line 36: DELETE FND_MENUS_TL WHERE MENU_ID = X_MENU_ID;

32: ) IS
33: row_id VARCHAR2(30);
34: BEGIN
35: DELETE FND_MENUS WHERE MENU_ID = X_MENU_ID;
36: DELETE FND_MENUS_TL WHERE MENU_ID = X_MENU_ID;
37: FND_MENUS_PKG.INSERT_ROW( X_ROWID => row_id,
38: X_MENU_ID => X_MENU_ID,
39: X_MENU_NAME => X_MENU_NAME,
40: X_USER_MENU_NAME => X_USER_MENU_NAME,

Line 37: FND_MENUS_PKG.INSERT_ROW( X_ROWID => row_id,

33: row_id VARCHAR2(30);
34: BEGIN
35: DELETE FND_MENUS WHERE MENU_ID = X_MENU_ID;
36: DELETE FND_MENUS_TL WHERE MENU_ID = X_MENU_ID;
37: FND_MENUS_PKG.INSERT_ROW( X_ROWID => row_id,
38: X_MENU_ID => X_MENU_ID,
39: X_MENU_NAME => X_MENU_NAME,
40: X_USER_MENU_NAME => X_USER_MENU_NAME,
41: X_MENU_TYPE => X_MENU_TYPE,

Line 60: | Description: it is a wrapper for FND_MENUS_PKG.UPDATE_ROW function

56: /*===========================================================================+
57: |
58: | Name: UPDATE_APP_MENU_VB
59: |
60: | Description: it is a wrapper for FND_MENUS_PKG.UPDATE_ROW function
61: | This procedure is to be called from a VB program.
62: | If there is an error, the procedure inserts the error
63: | message in BSC_MESSAGE_LOGS table.
64: |

Line 84: FND_MENUS_PKG.UPDATE_ROW(X_MENU_ID => X_MENU_ID,

80: X_USER_ID in NUMBER
81: ) IS
82: row_id VARCHAR2(30);
83: BEGIN
84: FND_MENUS_PKG.UPDATE_ROW(X_MENU_ID => X_MENU_ID,
85: X_MENU_NAME => X_MENU_NAME,
86: X_USER_MENU_NAME => X_USER_MENU_NAME,
87: X_MENU_TYPE => X_MENU_TYPE,
88: X_DESCRIPTION => X_DESCRIPTION,

Line 103: | Description: it is a wrapper for FND_MENUS_PKG.DELETE_ROW function

99: /*===========================================================================+
100: |
101: | Name: DELETE_APP_MENU_VB
102: |
103: | Description: it is a wrapper for FND_MENUS_PKG.DELETE_ROW function
104: | This procedure is to be called from a VB program.
105: | If there is an error, the procedure inserts the error
106: | message in BSC_MESSAGE_LOGS table.
107: |

Line 117: FND_MENUS_PKG.DELETE_ROW(X_MENU_ID => X_MENU_ID);

113: PROCEDURE DELETE_APP_MENU_VB(X_MENU_ID in NUMBER
114: ) IS
115: row_id VARCHAR2(30);
116: BEGIN
117: FND_MENUS_PKG.DELETE_ROW(X_MENU_ID => X_MENU_ID);
118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 150: FROM FND_MENUS_VL

146: BEGIN
147: -- Name
148: SELECT count(*)
149: INTO h_count
150: FROM FND_MENUS_VL
151: WHERE MENU_ID <> X_MENU_ID
152: AND (MENU_NAME = X_MENU_NAME);
153: IF h_count > 0 THEN
154: h_val := 'N';

Line 160: FROM FND_MENUS_VL

156: END IF;
157: -- User Name
158: SELECT count(*)
159: INTO h_count
160: FROM FND_MENUS_VL
161: WHERE MENU_ID <> X_MENU_ID
162: AND (upper(USER_MENU_NAME) = X_USER_MENU_NAME);
163: IF h_count > 0 THEN
164: h_val := 'U';

Line 606: FROM fnd_menus

602: h_menu_id_src NUMBER;
603:
604: CURSOR c_menu_id IS
605: SELECT menu_id
606: FROM fnd_menus
607: WHERE menu_name = h_menu_name;
608:
609: CURSOR c_menu_id_u IS
610: SELECT menu_id

Line 611: FROM fnd_menus_vl

607: WHERE menu_name = h_menu_name;
608:
609: CURSOR c_menu_id_u IS
610: SELECT menu_id
611: FROM fnd_menus_vl
612: WHERE user_menu_name = h_user_menu_name;
613:
614: h_menu_id NUMBER;
615: h_row_id VARCHAR2(30);

Line 664: ' FROM BSC_TAB_VIEW_LABELS_B T, FND_MENUS_VL@'||x_src_db_link||' M'||

660: h_user_id := BSC_APPS.fnd_global_user_id;
661:
662: -- Migrate menus with functions
663: h_sql := 'SELECT DISTINCT M.MENU_NAME, M.USER_MENU_NAME, T.LINK_ID'||
664: ' FROM BSC_TAB_VIEW_LABELS_B T, FND_MENUS_VL@'||x_src_db_link||' M'||
665: ' WHERE T.LABEL_TYPE = 2 AND NVL(T.LINK_ID, -1) <> -1 AND T.LINK_ID = M.MENU_ID';
666:
667: h_cursor := DBMS_SQL.OPEN_CURSOR;
668: DBMS_SQL.PARSE(h_cursor, h_sql, DBMS_SQL.NATIVE);

Line 705: SELECT fnd_menus_s.nextval INTO h_menu_id FROM DUAL;

701:
702: -- Create the menu only if the menu is for BSC
703: IF UPPER(SUBSTR(h_menu_name,1,3)) = 'BSC' THEN
704: -- Get the menu_id
705: SELECT fnd_menus_s.nextval INTO h_menu_id FROM DUAL;
706:
707: -- Get all info about the menu in the source to create it in the target
708: h_menu_type := NULL;
709: h_description := NULL;

Line 712: ' FROM fnd_menus_vl@'||x_src_db_link||

708: h_menu_type := NULL;
709: h_description := NULL;
710:
711: h_sql := 'SELECT type, description'||
712: ' FROM fnd_menus_vl@'||x_src_db_link||
713: ' WHERE menu_name =:1';
714: /* ' WHERE menu_name = '''||h_menu_name||'''';*/
715:
716:

Line 733: FND_MENUS_PKG.INSERT_ROW(

729: END IF;
730: DBMS_SQL.CLOSE_CURSOR(h_cursor1);
731:
732: -- call the api to create the menu
733: FND_MENUS_PKG.INSERT_ROW(
734: X_ROWID => h_row_id,
735: X_MENU_ID => h_menu_id,
736: X_MENU_NAME => h_menu_name,
737: X_USER_MENU_NAME => h_user_menu_name,

Line 962: FROM fnd_menus t, fnd_menus@'||x_src_db_link||' s

958: -- Now that all the menus have been migrated we can
959: -- update the link_id in BSC_TAB_VIEW_LABLES_B with the menu_id in the target
960: h_sql := 'UPDATE bsc_tab_view_labels_b l
961: SET link_id = NVL((SELECT t.menu_id
962: FROM fnd_menus t, fnd_menus@'||x_src_db_link||' s
963: WHERE t.menu_name = s.menu_name AND
964: l.link_id = s.menu_id),
965: NVL((SELECT t.menu_id
966: FROM fnd_menus_vl t, fnd_menus_vl@'||x_src_db_link||' s

Line 966: FROM fnd_menus_vl t, fnd_menus_vl@'||x_src_db_link||' s

962: FROM fnd_menus t, fnd_menus@'||x_src_db_link||' s
963: WHERE t.menu_name = s.menu_name AND
964: l.link_id = s.menu_id),
965: NVL((SELECT t.menu_id
966: FROM fnd_menus_vl t, fnd_menus_vl@'||x_src_db_link||' s
967: WHERE t.user_menu_name = s.user_menu_name AND
968: l.link_id = s.menu_id),
969: -1))
970: WHERE label_type = 2';

Line 1071: ' FND_MENUS_VL M'||

1067: ' M.DESCRIPTION'||
1068: ' FROM'||
1069: ' BSC_TAB_VIEW_LABELS_B L,'||
1070: ' BSC_TAB_VIEW_LABELS_B@'||x_src_db_link||' LS,'||
1071: ' FND_MENUS_VL M'||
1072: ' WHERE'||
1073: ' L.TAB_ID = LS.TAB_ID AND'||
1074: ' L.TAB_VIEW_ID = LS.TAB_VIEW_ID AND'||
1075: ' L.LABEL_ID = LS.LABEL_ID AND'||

Line 1149: p_Menu_Id IN FND_MENUS.menu_id%TYPE

1145: /*********************************************************************/
1146:
1147: FUNCTION is_Launch_Pad_Attached
1148: (
1149: p_Menu_Id IN FND_MENUS.menu_id%TYPE
1150: , p_Sub_Menu_Id IN FND_MENUS.menu_id%TYPE
1151:
1152: ) RETURN BOOLEAN
1153: IS

Line 1150: , p_Sub_Menu_Id IN FND_MENUS.menu_id%TYPE

1146:
1147: FUNCTION is_Launch_Pad_Attached
1148: (
1149: p_Menu_Id IN FND_MENUS.menu_id%TYPE
1150: , p_Sub_Menu_Id IN FND_MENUS.menu_id%TYPE
1151:
1152: ) RETURN BOOLEAN
1153: IS
1154: l_count NUMBER;

Line 1178: p_Menu_Id IN FND_MENUS.menu_id%TYPE

1174: /*********************************************************************/
1175:
1176: FUNCTION get_entry_sequence
1177: (
1178: p_Menu_Id IN FND_MENUS.menu_id%TYPE
1179: , p_Sub_Menu_Id IN FND_MENUS.menu_id%TYPE
1180: ) RETURN NUMBER
1181: IS
1182: l_entry_sequence FND_MENU_ENTRIES.entry_sequence%TYPE;

Line 1179: , p_Sub_Menu_Id IN FND_MENUS.menu_id%TYPE

1175:
1176: FUNCTION get_entry_sequence
1177: (
1178: p_Menu_Id IN FND_MENUS.menu_id%TYPE
1179: , p_Sub_Menu_Id IN FND_MENUS.menu_id%TYPE
1180: ) RETURN NUMBER
1181: IS
1182: l_entry_sequence FND_MENU_ENTRIES.entry_sequence%TYPE;
1183: