eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_RI_CONFIG_UTILITIES dependencies on PER_RI_CONFIG_UTILITIES

Line 1: PACKAGE BODY per_ri_config_utilities AS

1: PACKAGE BODY per_ri_config_utilities AS
2: /* $Header: perriutl.pkb 120.7.12010000.3 2010/05/13 08:50:13 sravikum ship $ */
3: g_package varchar2(30) := 'per_ri_config_utilities.';
4: g_config_effective_date date := TRUNC(TO_DATE('1951/01/01', 'YYYY/MM/DD'));
5: g_default_date_format varchar2(200) := 'RRRR/MM/DD';

Line 3: g_package varchar2(30) := 'per_ri_config_utilities.';

1: PACKAGE BODY per_ri_config_utilities AS
2: /* $Header: perriutl.pkb 120.7.12010000.3 2010/05/13 08:50:13 sravikum ship $ */
3: g_package varchar2(30) := 'per_ri_config_utilities.';
4: g_config_effective_date date := TRUNC(TO_DATE('1951/01/01', 'YYYY/MM/DD'));
5: g_default_date_format varchar2(200) := 'RRRR/MM/DD';
6:
7: g_config_effective_end_date date := TRUNC(TO_DATE('4712/12/31', 'YYYY/MM/DD'));

Line 229: l_job_key_flex_name := per_ri_config_utilities.return_config_entity_name(l_regional_variance_name)

225: ,p_bg_country_code);
226: fetch csr_job_rv into l_regional_variance_name;
227: if csr_job_rv%FOUND then
228: hr_utility.set_location(l_proc, 20);
229: l_job_key_flex_name := per_ri_config_utilities.return_config_entity_name(l_regional_variance_name)
230: || per_ri_config_main.g_job_rv_struct_def_string;
231: else
232: hr_utility.set_location(l_proc, 30);
233: l_job_key_flex_name := per_ri_config_utilities.return_config_entity_name

Line 233: l_job_key_flex_name := per_ri_config_utilities.return_config_entity_name

229: l_job_key_flex_name := per_ri_config_utilities.return_config_entity_name(l_regional_variance_name)
230: || per_ri_config_main.g_job_rv_struct_def_string;
231: else
232: hr_utility.set_location(l_proc, 30);
233: l_job_key_flex_name := per_ri_config_utilities.return_config_entity_name
234: (per_ri_config_main.g_global_job_structure_name);
235: end if;
236: hr_utility.set_location(' Leaving:' || l_proc, 20);
237: return l_job_key_flex_name;

Line 285: l_pos_key_flex_name := per_ri_config_utilities.return_config_entity_name(l_regional_variance_name)

281: ,p_bg_country_code);
282: fetch csr_pos_rv into l_regional_variance_name;
283: if csr_pos_rv%FOUND then
284: hr_utility.set_location(l_proc, 20);
285: l_pos_key_flex_name := per_ri_config_utilities.return_config_entity_name(l_regional_variance_name)
286: || per_ri_config_main.g_pos_rv_struct_def_string;
287: else
288: hr_utility.set_location(l_proc, 30);
289: l_pos_key_flex_name := per_ri_config_utilities.return_config_entity_name

Line 289: l_pos_key_flex_name := per_ri_config_utilities.return_config_entity_name

285: l_pos_key_flex_name := per_ri_config_utilities.return_config_entity_name(l_regional_variance_name)
286: || per_ri_config_main.g_pos_rv_struct_def_string;
287: else
288: hr_utility.set_location(l_proc, 30);
289: l_pos_key_flex_name := per_ri_config_utilities.return_config_entity_name
290: (per_ri_config_main.g_global_pos_structure_name);
291: end if;
292: hr_utility.set_location(' Leaving:' || l_proc, 20);
293: return l_pos_key_flex_name;

Line 371: select per_ri_config_utilities.return_config_entity_name(regional_variance_name)

367:
368:
369: cursor csr_grd_rv (cp_configuration_code in varchar2
370: ,cp_bg_country_code in varchar2) IS
371: select per_ri_config_utilities.return_config_entity_name(regional_variance_name)
372: from per_ri_config_grd_rv_v
373: where configuration_code = p_configuration_code
374: and reg_variance_country_code = p_bg_country_code;
375:

Line 385: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

381:
382: BEGIN
383: hr_utility.set_location('Entering:'|| l_proc, 10);
384:
385: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
386: (p_configuration_code => p_configuration_code);
387: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);
388: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
389: open csr_grd_rv(p_configuration_code

Line 397: l_grd_key_flex_name := per_ri_config_utilities.return_config_entity_name

393: hr_utility.set_location(l_proc, 20);
394: l_grd_key_flex_name := l_regional_variance_name || per_ri_config_main.g_grd_rv_struct_def_string;
395: else
396: hr_utility.set_location(l_proc, 30);
397: l_grd_key_flex_name := per_ri_config_utilities.return_config_entity_name
398: (per_ri_config_main.g_global_grd_structure_name);
399: end if;
400: hr_utility.trace('Grade Key Flex Name : ' || l_grd_key_flex_name);
401: hr_utility.set_location(' Leaving:' || l_proc, 20);

Line 487: select per_ri_config_utilities.return_config_entity_name(enterprise_name)

483: FUNCTION get_enterprise_name(p_configuration_code in varchar2)
484: RETURN varchar2 IS
485:
486: cursor csr_get_enterprise_name(cp_configuration_code in varchar2) IS
487: select per_ri_config_utilities.return_config_entity_name(enterprise_name)
488: from per_ri_config_enterprise_v
489: where configuration_code = p_configuration_code;
490:
491: l_enterprise_name per_ri_config_information.config_information1%type;

Line 642: if (per_ri_config_utilities.legislation_support(l_country_code, 'PER')) = TRUE then

638: if l_payroll_to_process_employees = 'N' then
639: if l_number_of_employees <= 100 then
640: l_business_group_decision := 'INT';
641: else
642: if (per_ri_config_utilities.legislation_support(l_country_code, 'PER')) = TRUE then
643: l_business_group_decision := l_country_code;
644: else
645: if (l_hr_support_for_this_country = 'Y' ) then
646: l_business_group_decision := l_country_code;

Line 653: if (per_ri_config_utilities.legislation_support(l_country_code, 'PAY')) = TRUE then

649: end if;
650: end if;
651: end if;
652: else
653: if (per_ri_config_utilities.legislation_support(l_country_code, 'PAY')) = TRUE then
654: l_business_group_decision := l_country_code;
655: else
656: -- revisit it
657: -- l_business_group_decision := 'INT';

Line 674: return per_ri_config_utilities.get_country_display_name

670:
671: if NOT l_called_from_ui then
672: return l_business_group_decision;
673: else
674: return per_ri_config_utilities.get_country_display_name
675: (p_territory_code => l_business_group_decision);
676: end if;
677:
678: return l_business_group_decision;

Line 1072: per_ri_config_utilities.create_valueset(p_valueset_name => l_valueset_name

1068: l_valueset_name := p_structure_code || ' ' || p_segment_name
1069: || ' ' || l_valueset_seq;
1070:
1071: hr_utility.trace('l_valueset_name = ' || l_valueset_name);
1072: per_ri_config_utilities.create_valueset(p_valueset_name => l_valueset_name
1073: ,p_valueset_type => p_segment_type);
1074: end if;
1075: hr_utility.set_location('Entering:'|| l_proc, 40);
1076: hr_utility.trace('p_segment_number = ' || to_char(p_segment_number));

Line 1239: l_le_business_group_name := per_ri_config_utilities.business_group_decision

1235: ,p_legal_entity_name);
1236: loop
1237: fetch csr_le_bg_name into l_legal_entity_country_name;
1238: exit when csr_le_bg_name%NOTFOUND;
1239: l_le_business_group_name := per_ri_config_utilities.business_group_decision
1240: (p_configuration_code
1241: ,l_legal_entity_country_name);
1242:
1243: hr_utility.trace('l_legal_entity_country_name = ' || l_legal_entity_country_name);

Line 1293: l_oc_business_group_name := per_ri_config_utilities.business_group_decision

1289: -- if country selected is not there put that in international, if int is not created then put it for hq bg
1290: loop
1291: fetch csr_oct_bg_name into l_operating_company_hq_country;
1292: exit when csr_oct_bg_name%NOTFOUND;
1293: l_oc_business_group_name := per_ri_config_utilities.business_group_decision
1294: (p_configuration_code
1295: ,l_operating_company_hq_country);
1296:
1297: hr_utility.trace('l_operating_company_hq_country = ' || l_operating_company_hq_country);

Line 1346: l_business_group_name := per_ri_config_utilities.business_group_decision

1342: loop
1343: fetch csr_ent_bg_name into
1344: l_enterprise_hq_country;
1345: exit when csr_ent_bg_name%NOTFOUND;
1346: l_business_group_name := per_ri_config_utilities.business_group_decision
1347: (p_configuration_code
1348: ,l_enterprise_hq_country);
1349:
1350: hr_utility.trace('l_enterprise_hq_country = ' || l_enterprise_hq_country);

Line 1399: return per_ri_config_utilities.return_config_entity_name(l_location_code);

1395: loop
1396: fetch csr_location into l_location_code;
1397: exit when csr_location%NOTFOUND;
1398: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1399: return per_ri_config_utilities.return_config_entity_name(l_location_code);
1400: end loop;
1401: close csr_location;
1402:
1403: EXCEPTION

Line 1685: per_ri_config_utilities.write_log(p_message => l_log_message);

1681: ,right_justify_zero_fill => l_right_justify_zero_fill
1682: ,min_value => l_min_value
1683: ,max_value => l_max_value);
1684: l_log_message := 'Created VALUESET ' || p_valueset_name;
1685: per_ri_config_utilities.write_log(p_message => l_log_message);
1686: end if;
1687:
1688: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1689:

Line 1771: select distinct per_ri_config_utilities.business_group_decision(configuration_code, config_information1) BusinessGroup

1767: ,p_country_list out nocopy varchar2
1768: ,p_selected_list out nocopy varchar2) IS
1769:
1770: cursor get_country_list IS
1771: select distinct per_ri_config_utilities.business_group_decision(configuration_code, config_information1) BusinessGroup
1772: from per_ri_config_information pci
1773: where config_information_category = 'CONFIG COUNTRY'
1774: and configuration_code = p_configuration_code;
1775:

Line 2020: per_ri_config_utilities.write_log(p_message => l_log_message);

2016: '', '', '', '', '', '', '', '', '', '');
2017:
2018: l_log_message := 'Submitted Concurrent Request to Compile KEY FLEX ' || p_appl_short_name
2019: || ' ' || p_flex_code || ' ' || p_structure_code;
2020: per_ri_config_utilities.write_log(p_message => l_log_message);
2021:
2022: hr_utility.set_location(' Leaving:'|| l_proc, 50);
2023:
2024: EXCEPTION

Line 2126: if NOT (per_ri_config_utilities.legislation_support(l_legislation_code, 'PAY'))

2122: l_legislation_code := p_country_tab(i).territory_code;
2123: hr_utility.trace('p_country_tab.element = ' || l_legislation_code);
2124: if l_legislation_code <> 'INT' then
2125:
2126: if NOT (per_ri_config_utilities.legislation_support(l_legislation_code, 'PAY'))
2127: and NOT (per_ri_config_utilities.legislation_support(l_legislation_code, 'PER')) then
2128:
2129: open csr_defaults(l_legislation_code);
2130:

Line 2127: and NOT (per_ri_config_utilities.legislation_support(l_legislation_code, 'PER')) then

2123: hr_utility.trace('p_country_tab.element = ' || l_legislation_code);
2124: if l_legislation_code <> 'INT' then
2125:
2126: if NOT (per_ri_config_utilities.legislation_support(l_legislation_code, 'PAY'))
2127: and NOT (per_ri_config_utilities.legislation_support(l_legislation_code, 'PER')) then
2128:
2129: open csr_defaults(l_legislation_code);
2130:
2131: fetch csr_defaults into l_legislation_code,l_currency_code,l_tax_start_date;

Line 2156: per_ri_config_utilities.write_log(p_message => l_log_message);

2152: l_int_hrms_setup_count := l_int_hrms_setup_count + 1 ;
2153: end if;
2154: close csr_defaults;
2155: l_log_message := 'Created International Payroll run CONCURRENT REQUEST for ' || l_legislation_code;
2156: per_ri_config_utilities.write_log(p_message => l_log_message);
2157: end if;
2158: end if;
2159: END LOOP;
2160: end if;

Line 2186: where user_name = upper(per_ri_config_utilities.return_config_entity_name_pre

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
2190: select application_id, responsibility_id

Line 2273: -- per_ri_config_utilities.write_log(p_message => l_log_message);

2269: -- hr_utility.trace('l_responsibility_id = ' || l_responsibility_id);
2270: -- hr_utility.trace('p_responsibility_application_i = ' || l_responsibility_application_i);
2271: --
2272: -- l_log_message := 'Created Security Profile Assignment ' || l_business_group_id;
2273: -- per_ri_config_utilities.write_log(p_message => l_log_message);
2274: --
2275: -- end loop;
2276: -- end if;
2277: hr_utility.set_location(' Leaving:'|| l_proc, 100);

Line 2377: l_shrms := per_ri_config_utilities.responsibility_exists

2373:
2374: BEGIN
2375: hr_utility.set_location('Entering:'|| l_proc, 10);
2376:
2377: l_shrms := per_ri_config_utilities.responsibility_exists
2378: (p_country_code => p_country_code
2379: ,p_assign_responsibility => 'SHRMS');
2380: if l_shrms then
2381: return 'SHRMS';

Line 2384: l_hrms := per_ri_config_utilities.responsibility_exists

2380: if l_shrms then
2381: return 'SHRMS';
2382: end if;
2383:
2384: l_hrms := per_ri_config_utilities.responsibility_exists
2385: (p_country_code => p_country_code
2386: ,p_assign_responsibility => 'HRMS');
2387: if l_hrms then
2388: return 'HRMS';

Line 2391: l_hr := per_ri_config_utilities.responsibility_exists

2387: if l_hrms then
2388: return 'HRMS';
2389: end if;
2390:
2391: l_hr := per_ri_config_utilities.responsibility_exists
2392: (p_country_code => p_country_code
2393: ,p_assign_responsibility => 'PER');
2394: if l_hr then
2395: return 'PER';

Line 2493: per_ri_config_utilities.set_profile_option_value

2489: hr_utility.set_location('Entering:'|| l_proc, 10);
2490:
2491: -- Remove site level profile option
2492: --PER_SECURITY_PROFILE_ID
2493: per_ri_config_utilities.set_profile_option_value
2494: (p_level => 10001
2495: ,p_level_value => 0
2496: ,p_level_value_app => 'PER'
2497: ,p_profile_name => 'PER_SECURITY_PROFILE_ID'

Line 2513: --per_ri_config_utilities.write_log(p_message => l_log_message);

2509: --,sub_request => FALSE);
2510: --hr_utility.trace('l_request_id = ' || to_char(l_request_id));
2511: --l_log_message := 'Created Enable Multiple Security Group process';
2512: --l_log_message := 'Created Enable Multiple Security Group process';
2513: --per_ri_config_utilities.write_log(p_message => l_log_message);
2514:
2515: --
2516: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2517: EXCEPTION

Line 2601: per_ri_config_utilities.write_log(p_message => l_log_message);

2597: open csr_dp_exception(p_patch_header_id);
2598: fetch csr_dp_exception into l_exception_text;
2599: if csr_dp_exception%FOUND then
2600: l_log_message := 'Error occured in loading datapump records';
2601: per_ri_config_utilities.write_log(p_message => l_log_message);
2602:
2603: l_log_message := l_exception_text;
2604: per_ri_config_utilities.write_log(p_message => l_log_message);
2605: hr_utility.raise_error;

Line 2604: per_ri_config_utilities.write_log(p_message => l_log_message);

2600: l_log_message := 'Error occured in loading datapump records';
2601: per_ri_config_utilities.write_log(p_message => l_log_message);
2602:
2603: l_log_message := l_exception_text;
2604: per_ri_config_utilities.write_log(p_message => l_log_message);
2605: hr_utility.raise_error;
2606: end if;
2607: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2608: EXCEPTION

Line 2678: l_start_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_date,'YYYY/MM/DD');

2674: l_error_message varchar2(360);
2675:
2676: l_hrms_misc_resp_count number(9) := 0;
2677: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2678: l_start_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_date,'YYYY/MM/DD');
2679: l_end_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_end_date,'YYYY/MM/DD');
2680:
2681: BEGIN
2682: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2679: l_end_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_end_date,'YYYY/MM/DD');

2675:
2676: l_hrms_misc_resp_count number(9) := 0;
2677: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2678: l_start_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_date,'YYYY/MM/DD');
2679: l_end_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_end_date,'YYYY/MM/DD');
2680:
2681: BEGIN
2682: hr_utility.set_location('Entering:'|| l_proc, 10);
2683: if NOT (p_technical_summary_mode) then

Line 2685: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre

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',
2689: x_security_group => 'STANDARD',

Line 2695: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre

2691: x_start_date => l_start_date,
2692: x_end_date => l_end_date,
2693: x_description => per_ri_config_main.g_description_string);
2694: else
2695: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
2696: (per_ri_config_main.g_configuration_user_name));
2697: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).resp_key := 'GLB_SHRMS_MANAGER';
2698: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).app_short_name := 'PER';
2699: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).security_group := 'STANDARD';

Line 2710: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

2706: end if;
2707: hr_utility.trace('Assigned Responsibility: ' || 'GLB_SHRMS_MANAGER');
2708: hr_utility.set_location(l_proc, 20);
2709:
2710: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
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

Line 2716: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre

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',
2720: x_security_group => 'STANDARD',

Line 2726: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre

2722: x_start_date => l_start_date,
2723: x_end_date => l_end_date,
2724: x_description => per_ri_config_main.g_description_string);
2725: else
2726: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
2727: (per_ri_config_main.g_configuration_user_name));
2728: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).resp_key := 'US_GOV_HR_MANAGER';
2729: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).app_short_name := 'GHR';
2730: p_hrms_misc_resp_tab(l_hrms_misc_resp_count).security_group := 'STANDARD';

Line 2772: hr_utility.trace('per_ri_config_utilities.g_enterprise_short_name = ' || per_ri_config_utilities.g_enterprise_short_name );

2768: l_error_message varchar2(360);
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;

Line 2776: l_entity_name := entity_name || ' ' || per_ri_config_utilities.g_enterprise_short_name;

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
2778: l_entity_name := entity_name;
2779: end if;
2780:

Line 2815: hr_utility.trace('per_ri_config_utilities.g_enterprise_short_name = ' || per_ri_config_utilities.g_enterprise_short_name );

2811: l_error_message varchar2(360);
2812:
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

Line 2820: l_entity_name := per_ri_config_utilities.g_enterprise_short_name || ' ' || entity_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
2822: l_entity_name := entity_name;
2823: end if;
2824:

Line 3042: per_ri_config_utilities.create_resp_and_profile

3038:
3039: hr_utility.trace('l_security_profile_name := ' || l_security_profile_name);
3040: hr_utility.trace('l_responsibility_key := ' || l_responsibility_key);
3041: hr_utility.trace('before loop l_more_profile_resp_tab_count ' || l_more_profile_resp_tab_count );
3042: per_ri_config_utilities.create_resp_and_profile
3043: (p_configuration_code => p_configuration_code
3044: ,p_security_profile_name => l_security_profile_name
3045: ,p_responsibility_key => l_responsibility_key
3046: ,p_technical_summary_mode => p_technical_summary_mode

Line 3154: per_ri_config_utilities.create_resp_and_profile

3150:
3151: -- all International BG's to get copy of GLB_SHRMS_MANAGER responsibility
3152: l_responsibility_key := 'GLB_SHRMS_MANAGER';
3153:
3154: per_ri_config_utilities.create_resp_and_profile
3155: (p_configuration_code => p_configuration_code
3156: ,p_security_profile_name => l_security_profile_name
3157: ,p_responsibility_key => l_responsibility_key
3158: ,p_technical_summary_mode => p_technical_summary_mode

Line 3357: where user_name = upper(per_ri_config_utilities.return_config_entity_name_pre

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
3361: select application_id, responsibility_id

Line 3476: l_start_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_date,'YYYY/MM/DD');

3472: and dgu.application_id = a.application_id
3473: and a.application_short_name = cp_new_app_short_name;
3474:
3475:
3476: l_start_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_date,'YYYY/MM/DD');
3477: l_end_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_end_date,'YYYY/MM/DD');
3478:
3479: BEGIN
3480:

Line 3477: l_end_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_end_date,'YYYY/MM/DD');

3473: and a.application_short_name = cp_new_app_short_name;
3474:
3475:
3476: l_start_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_date,'YYYY/MM/DD');
3477: l_end_date varchar2(240) := to_char(per_ri_config_utilities.g_config_effective_end_date,'YYYY/MM/DD');
3478:
3479: BEGIN
3480:
3481: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3556: l_new_responsibility_name := per_ri_config_utilities.return_config_entity_name(l_new_responsibility_name);

3552: open csr_data_groups(l_new_data_group_id,l_new_app_short_name);
3553: fetch csr_data_groups into l_new_data_group_name, l_new_data_group_app_name;
3554: close csr_data_groups;
3555:
3556: l_new_responsibility_name := per_ri_config_utilities.return_config_entity_name(l_new_responsibility_name);
3557: l_new_resp_key := upper(per_ri_config_utilities.return_config_entity_name(l_new_resp_key)); -- Fix for bug 9706310
3558:
3559: hr_utility.trace('l_new_resp_key ' || l_new_resp_key);
3560: hr_utility.trace('l_new_responsibility_name ' || l_new_responsibility_name);

Line 3557: l_new_resp_key := upper(per_ri_config_utilities.return_config_entity_name(l_new_resp_key)); -- Fix for bug 9706310

3553: fetch csr_data_groups into l_new_data_group_name, l_new_data_group_app_name;
3554: close csr_data_groups;
3555:
3556: l_new_responsibility_name := per_ri_config_utilities.return_config_entity_name(l_new_responsibility_name);
3557: l_new_resp_key := upper(per_ri_config_utilities.return_config_entity_name(l_new_resp_key)); -- Fix for bug 9706310
3558:
3559: hr_utility.trace('l_new_resp_key ' || l_new_resp_key);
3560: hr_utility.trace('l_new_responsibility_name ' || l_new_responsibility_name);
3561:

Line 3583: per_ri_config_utilities.create_responsibility

3579: --append legislation code
3580: l_new_responsibility_name := l_legilsation_code || ' ' || l_new_responsibility_name;
3581: end if;
3582:
3583: per_ri_config_utilities.create_responsibility
3584: (p_app_short_name => l_new_app_short_name
3585: ,p_resp_key => l_new_resp_key
3586: ,p_responsibility_id => l_new_responsibility_id
3587: ,p_responsibility_name => l_new_responsibility_name

Line 3627: l_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre

3623:
3624: -- security profile name and business group name is same
3625: -- get the name of new responsibility key and respobnsibility name
3626:
3627: l_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
3628: (per_ri_config_main.g_configuration_user_name));
3629: l_security_profile_name := p_security_profile_name;
3630: l_responsibility_key := p_responsibility_key;
3631:

Line 3636: l_ts_new_responsibility_name := per_ri_config_utilities.return_config_entity_name(l_ts_responsibility_name);

3632: open csr_responsibility_name(l_responsibility_key);
3633: fetch csr_responsibility_name into l_ts_responsibility_name;
3634: close csr_responsibility_name;
3635:
3636: l_ts_new_responsibility_name := per_ri_config_utilities.return_config_entity_name(l_ts_responsibility_name);
3637: l_ts_new_resp_key := per_ri_config_utilities.return_config_entity_name(p_responsibility_key);
3638:
3639: -- Modify GLB key names to country specific keys
3640: if (l_ts_new_resp_key like 'GLB_%') and (p_security_profile_name not like '%INT BG') then

Line 3637: l_ts_new_resp_key := per_ri_config_utilities.return_config_entity_name(p_responsibility_key);

3633: fetch csr_responsibility_name into l_ts_responsibility_name;
3634: close csr_responsibility_name;
3635:
3636: l_ts_new_responsibility_name := per_ri_config_utilities.return_config_entity_name(l_ts_responsibility_name);
3637: l_ts_new_resp_key := per_ri_config_utilities.return_config_entity_name(p_responsibility_key);
3638:
3639: -- Modify GLB key names to country specific keys
3640: if (l_ts_new_resp_key like 'GLB_%') and (p_security_profile_name not like '%INT BG') then
3641: -- extract legislation code

Line 3767: END per_ri_config_utilities;

3763: return l_bg_name;
3764:
3765: END get_business_group_name;
3766:
3767: END per_ri_config_utilities;