DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_USER

Line 802: from fnd_user

798: from hr_operating_units
799: where name = p_level_value;
800: else
801: select user_id into levval_id
802: from fnd_user
803: where user_name = p_level_value;
804: end if;
805:
806: select profile_option_id, application_id

Line 2185: from fnd_user

2181: p_security_profile_tab in per_ri_config_fnd_hr_entity.security_profile_tab) IS
2182:
2183: cursor csr_user IS
2184: select user_id
2185: from fnd_user
2186: where user_name = upper(per_ri_config_utilities.return_config_entity_name_pre
2187: (per_ri_config_main.g_configuration_user_name));
2188:
2189: cursor csr_responsibility(cp_responsibility_kay in varchar2) IS

Line 2684: fnd_user_resp_groups_api.load_row(

2680:
2681: BEGIN
2682: hr_utility.set_location('Entering:'|| l_proc, 10);
2683: if NOT (p_technical_summary_mode) then
2684: fnd_user_resp_groups_api.load_row(
2685: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre
2686: (per_ri_config_main.g_configuration_user_name)),
2687: x_resp_key => 'GLB_SHRMS_MANAGER',
2688: x_app_short_name => 'PER',

Line 2715: fnd_user_resp_groups_api.load_row(

2711: (p_configuration_code => p_configuration_code);
2712:
2713: if l_enterprise_primary_industry = 'US_GOVERNMENT' then
2714: if NOT (p_technical_summary_mode) then
2715: fnd_user_resp_groups_api.load_row(
2716: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre
2717: (per_ri_config_main.g_configuration_user_name)),
2718: x_resp_key => 'US_GOV_HR_MANAGER',
2719: x_app_short_name => 'GHR',

Line 3356: from fnd_user

3352: per_ri_config_tech_summary.hrms_resp_tab) IS
3353:
3354: cursor csr_user IS
3355: select user_name
3356: from fnd_user
3357: where user_name = upper(per_ri_config_utilities.return_config_entity_name_pre
3358: (per_ri_config_main.g_configuration_user_name));
3359:
3360: cursor csr_responsibility(cp_responsibility_kay in varchar2) IS

Line 3390: l_user_name fnd_user.user_name%type;

3386: select security_group_name,security_group_key
3387: from fnd_security_groups_vl
3388: where security_group_id = cp_security_group_id;
3389:
3390: l_user_name fnd_user.user_name%type;
3391: l_security_group_id fnd_security_groups.security_group_id%type;
3392: l_business_group_id per_business_groups.business_group_id%type;
3393: l_business_group_name per_business_groups.name%type;
3394: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;

Line 3602: fnd_user_resp_groups_api.load_row(

3598: ,p_web_host_name => l_new_web_host_name
3599: ,p_web_agent_name => l_new_web_agent_name);
3600:
3601: -- assign this responsibility to the user
3602: fnd_user_resp_groups_api.load_row(
3603: x_user_name => l_user_name,
3604: x_resp_key => l_new_resp_key,
3605: x_app_short_name => l_new_app_short_name,
3606: x_security_group => l_security_group_key,