APPS.HR_USER_ACCT_INTERNAL dependencies on FND_REQUEST_GROUPS

Line 364: ,p_request_group_name in fnd_request_groups.request_group_name%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
368: ,p_version in fnd_responsibility.version%type default '4'

Line 416: FROM fnd_request_groups

412: WHERE menu_name = p_menu_name;
413: --
414: CURSOR lc_get_req_group_id IS
415: SELECT request_group_id
416: FROM fnd_request_groups
417: WHERE request_group_name = p_request_group_name
418: AND application_id = p_request_group_app_id;
419: --
420: CURSOR lc_generate_resp_id IS

Line 434: l_req_grp_app_id fnd_request_groups.application_id%type default null;

430: l_request_group_app_id fnd_responsibility.group_application_id%type
431: default null;
432: l_responsibility_id fnd_responsibility.responsibility_id%type default null;
433: l_data_grp_id fnd_data_groups.data_group_id%type default null;
434: l_req_grp_app_id fnd_request_groups.application_id%type default null;
435: --
436: BEGIN
437: hr_utility.set_location('Entering:' || l_proc, 10);
438: --

Line 609: fnd_message.set_token('TABLE', 'FND_REQUEST_GROUPS');

605: IF lc_get_req_group_id%NOTFOUND
606: THEN
607: CLOSE lc_get_req_group_id;
608: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
609: fnd_message.set_token('TABLE', 'FND_REQUEST_GROUPS');
610: fnd_message.set_token('COLUMN',
611: '(REQUEST_GROUP_NAME, REQUEST_GROUP_APP_ID)');
612: fnd_message.set_token('VALUE', p_request_group_name || ', ' ||
613: to_char(p_request_group_app_id));