DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on FND_MENUS

Line 363: ,p_menu_name in fnd_menus.menu_name%type

359: ,p_start_date in fnd_responsibility.start_date%type
360: ,p_end_date in fnd_responsibility.end_date%type default null
361: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type
362: ,p_data_group_app_id in fnd_responsibility.data_group_application_id%type
363: ,p_menu_name in fnd_menus.menu_name%type
364: ,p_request_group_name in fnd_request_groups.request_group_name%type
365: default null
366: ,p_request_group_app_id in fnd_responsibility.group_application_id%type
367: default null

Line 411: FROM fnd_menus

407: WHERE data_group_name = p_data_group_name;
408: --
409: CURSOR lc_get_menu_id IS
410: SELECT menu_id
411: FROM fnd_menus
412: WHERE menu_name = p_menu_name;
413: --
414: CURSOR lc_get_req_group_id IS
415: SELECT request_group_id

Line 586: fnd_message.set_token('TABLE', 'FND_MENUS_VL');

582: IF lc_get_menu_id%NOTFOUND
583: THEN
584: CLOSE lc_get_menu_id;
585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
586: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
587: fnd_message.set_token('COLUMN', 'MENU_NAME');
588: fnd_message.set_token('VALUE', p_menu_name);
589: hr_utility.raise_error;
590: ELSE

Line 1309: -- HR_MANAGER_ACTIONS_MENU FND_MENUS_VL

1305: -- HR_PERINFO_CHECK_PENDING FND_LOOKUPS
1306: -- HR_SELF_SERV_SAVEFORLATER FND_COMMON_LOOKUPS
1307: -- PAY_FR_CHECK_MANDATORY_ASG_ATTRIBUTES FND_LOOKUPS
1308: -- HR:COST_MAND_SEG_CHECK FND_LOOKUPS
1309: -- HR_MANAGER_ACTIONS_MENU FND_MENUS_VL
1310: -- HR_PERSONAL_ACTIONS_MENU FND_MENUS_VL
1311: -- PER_AUTO_EVAL_ENTITLEMENTS FND_LOOKUPS
1312: -- PER_CHECK_ENTITLEMENT_CACHE FND_LOOKUPS
1313: -- PER_AUTO_APPLY_ENTITLEMENTS FND_LOOKUPS

Line 1310: -- HR_PERSONAL_ACTIONS_MENU FND_MENUS_VL

1306: -- HR_SELF_SERV_SAVEFORLATER FND_COMMON_LOOKUPS
1307: -- PAY_FR_CHECK_MANDATORY_ASG_ATTRIBUTES FND_LOOKUPS
1308: -- HR:COST_MAND_SEG_CHECK FND_LOOKUPS
1309: -- HR_MANAGER_ACTIONS_MENU FND_MENUS_VL
1310: -- HR_PERSONAL_ACTIONS_MENU FND_MENUS_VL
1311: -- PER_AUTO_EVAL_ENTITLEMENTS FND_LOOKUPS
1312: -- PER_CHECK_ENTITLEMENT_CACHE FND_LOOKUPS
1313: -- PER_AUTO_APPLY_ENTITLEMENTS FND_LOOKUPS
1314: -- PER_CAGR_LOG_DETAIL FND_COMMON_LOOKUPS

Line 1538: FROM fnd_menus_vl

1534:
1535: -- HR_MANAGER_ACTIONS_MENU
1536: CURSOR lc_get_mgr_actns_menu IS
1537: SELECT user_menu_name visible_option_value , menu_name profile_option_value
1538: FROM fnd_menus_vl
1539: ORDER BY user_menu_name;
1540:
1541:
1542: -- HR_PERSONAL_ACTIONS_MENU

Line 1545: FROM fnd_menus_vl

1541:
1542: -- HR_PERSONAL_ACTIONS_MENU
1543: CURSOR lc_get_pers_actns_menu IS
1544: SELECT user_menu_name visible_option_value , menu_name profile_option_value
1545: FROM fnd_menus_vl
1546: ORDER BY user_menu_name;
1547:
1548:
1549: -- BEN_CWB_PREFERRED_CURRENCY

Line 2049: CURSOR lc_get_menu_name (p_menu_id in fnd_menus.menu_id%TYPE)

2045: SELECT function_name
2046: FROM fnd_form_functions
2047: WHERE function_id = p_func_id;
2048: --
2049: CURSOR lc_get_menu_name (p_menu_id in fnd_menus.menu_id%TYPE)
2050: IS
2051: SELECT menu_name
2052: FROM fnd_menus
2053: WHERE menu_id = p_menu_id;

Line 2052: FROM fnd_menus

2048: --
2049: CURSOR lc_get_menu_name (p_menu_id in fnd_menus.menu_id%TYPE)
2050: IS
2051: SELECT menu_name
2052: FROM fnd_menus
2053: WHERE menu_id = p_menu_id;
2054: --
2055: --
2056: l_proc varchar2(72) := g_package ||

Line 2063: l_rule_name fnd_menus.menu_name%type;

2059: l_resp_func_rec lc_get_resp_func%rowtype;
2060: l_index binary_integer default 0;
2061: l_func_sec_excl_tbl_count integer default 0;
2062: l_out_func_sec_excl_tbl hr_user_acct_utility.func_sec_excl_tbl;
2063: l_rule_name fnd_menus.menu_name%type;
2064: l_func_sec_excl_err exception;
2065: --
2066: BEGIN
2067: hr_utility.set_location('Entering:'|| l_proc, 11);

Line 2121: -- derive the menu_name from fnd_menus

2117: ELSE
2118: CLOSE lc_get_function_name;
2119: END IF;
2120: ELSE
2121: -- derive the menu_name from fnd_menus
2122: OPEN lc_get_menu_name
2123: (p_menu_id => l_resp_func_rec.action_id);
2124: FETCH lc_get_menu_name into l_rule_name;
2125: IF lc_get_menu_name%NOTFOUND

Line 2207: FROM fnd_menus

2203: --
2204: CURSOR lc_get_menu_id
2205: IS
2206: SELECT menu_id
2207: FROM fnd_menus
2208: WHERE menu_name = p_rule_name;
2209: --
2210: l_proc varchar2(72) := g_package ||
2211: 'create_fnd_resp_functions';