APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_PROFILE

Line 808: from fnd_profile_options

804: end if;
805:
806: select profile_option_id, application_id
807: into profo_id, app_id
808: from fnd_profile_options
809: where profile_option_name = p_profile_name;
810:
811: f_luby := fnd_load_util.owner_id(p_owner);
812:

Line 821: from FND_PROFILE_OPTION_VALUES

817: --
818:
819: if (p_level = '10003') then
820: select 'Y' into found
821: from FND_PROFILE_OPTION_VALUES
822: where PROFILE_OPTION_ID = profo_id
823: and APPLICATION_ID = app_id
824: and LEVEL_ID = 10003
825: and LEVEL_VALUE_APPLICATION_ID = lapp_id

Line 830: from FND_PROFILE_OPTION_VALUES

826: and LEVEL_VALUE = levval_id;
827: hr_utility.trace('Found Record..' || lapp_id || ' ' || levval_id);
828: else
829: select 'Y' into found
830: from FND_PROFILE_OPTION_VALUES
831: where PROFILE_OPTION_ID = profo_id
832: and APPLICATION_ID = app_id
833: and LEVEL_ID = to_number(p_level)
834: and LEVEL_VALUE = levval_id;

Line 838: update fnd_profile_option_values

834: and LEVEL_VALUE = levval_id;
835: end if;
836:
837: if (p_custom_mode = 'FORCE') then
838: update fnd_profile_option_values
839: set profile_option_value = p_profile_option_value,
840: last_update_date = f_ludate,
841: last_updated_by = f_luby,
842: last_update_login = 0

Line 853: insert into fnd_profile_option_values (

849: end if;
850: exception
851: when no_data_found then
852: hr_utility.trace('Creating Profile Option Value..');
853: insert into fnd_profile_option_values (
854: application_id,
855: profile_option_id,
856: level_id,
857: level_value,

Line 2773: l_multiple_config_upload := fnd_profile.value('PER_RI_LOAD_OVERRIDE');

2769:
2770: BEGIN
2771: hr_utility.set_location('Entering:'|| l_proc, 10);
2772: hr_utility.trace('per_ri_config_utilities.g_enterprise_short_name = ' || per_ri_config_utilities.g_enterprise_short_name );
2773: l_multiple_config_upload := fnd_profile.value('PER_RI_LOAD_OVERRIDE');
2774:
2775: if l_multiple_config_upload = 'Y' then
2776: l_entity_name := entity_name || ' ' || per_ri_config_utilities.g_enterprise_short_name;
2777: else

Line 2817: l_multiple_config_upload := fnd_profile.value('PER_RI_LOAD_OVERRIDE');

2813: BEGIN
2814: hr_utility.set_location('Entering:'|| l_proc, 10);
2815: hr_utility.trace('per_ri_config_utilities.g_enterprise_short_name = ' || per_ri_config_utilities.g_enterprise_short_name );
2816:
2817: l_multiple_config_upload := fnd_profile.value('PER_RI_LOAD_OVERRIDE');
2818:
2819: if l_multiple_config_upload = 'Y' then
2820: l_entity_name := per_ri_config_utilities.g_enterprise_short_name || ' ' || entity_name;
2821: else

Line 3751: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

3747: RETURN varchar2 IS
3748:
3749: cursor bg_name IS
3750: select name from per_business_groups
3751: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
3752:
3753: l_bg_name varchar2(50);
3754:
3755: BEGIN