APPS.BIS_PMV_UTIL dependencies on FND_MENU_ENTRIES

Line 636: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF

632: l_menu_id fnd_responsibility.menu_id%TYPE;
633: l_user_id fnd_user.user_id%TYPE;
634: CURSOR CM IS
635: SELECT 1
636: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
637: WHERE MEV.MENU_ID = l_menu_id
638: AND RF.RESPONSIBILITY_ID (+) = l_resp_id
639: AND RF.RULE_TYPE(+) = DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F')
640: AND RF.ACTION_ID(+) <> DECODE(DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F'), 'F', MEV.FUNCTION_ID,

Line 648: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF

644: AND FF.function_name = l_function_name
645: AND RF.APPLICATION_ID(+) = l_appl_id
646: UNION
647: SELECT 1
648: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
649: WHERE MEV.MENU_ID IN(
650: SELECT SUB_MENU_ID
651: FROM FND_MENU_ENTRIES
652: WHERE SUB_MENU_ID IS NOT NULL

Line 651: FROM FND_MENU_ENTRIES

647: SELECT 1
648: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
649: WHERE MEV.MENU_ID IN(
650: SELECT SUB_MENU_ID
651: FROM FND_MENU_ENTRIES
652: WHERE SUB_MENU_ID IS NOT NULL
653: CONNECT BY MENU_ID = PRIOR SUB_MENU_ID START WITH MENU_ID =l_menu_id)
654: AND RF.RESPONSIBILITY_ID (+) = l_resp_id
655: AND RF.RULE_TYPE(+) = DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F')

Line 973: FROM FND_MENU_ENTRIES_VL MEV, FND_FORM_FUNCTIONS FF

969: WHERE function_name = pPageFunctionName;
970:
971: CURSOR c_paramPortlet_funcName(p_menu_name VARCHAR2) IS
972: SELECT FF.FUNCTION_NAME
973: FROM FND_MENU_ENTRIES_VL MEV, FND_FORM_FUNCTIONS FF
974: WHERE MEV.MENU_ID IN (
975: SELECT SUB_MENU_ID
976: FROM FND_MENU_ENTRIES
977: WHERE SUB_MENU_ID IS NOT NULL

Line 976: FROM FND_MENU_ENTRIES

972: SELECT FF.FUNCTION_NAME
973: FROM FND_MENU_ENTRIES_VL MEV, FND_FORM_FUNCTIONS FF
974: WHERE MEV.MENU_ID IN (
975: SELECT SUB_MENU_ID
976: FROM FND_MENU_ENTRIES
977: WHERE SUB_MENU_ID IS NOT NULL
978: CONNECT BY MENU_ID = PRIOR SUB_MENU_ID START WITH MENU_ID = (SELECT MENU_ID FROM FND_MENUS
979: WHERE MENU_NAME=p_menu_name)
980: )

Line 1103: l_sql := 'SELECT DISTINCT menu_id FROM fnd_menu_entries where function_id in (';

1099: l_menu_id NUMBER;
1100: l_menu_id_tbl BISVIEWER.t_char;
1101: l_count NUMBER := 1;
1102: BEGIN
1103: l_sql := 'SELECT DISTINCT menu_id FROM fnd_menu_entries where function_id in (';
1104: l_privileges := replace(pPrivileges, ',', '~');
1105: SETUP_BIND_VARIABLES(
1106: p_bind_variables => l_privileges,
1107: x_bind_var_tbl => l_bind_values