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_INFORMATION

Line 218: l_regional_variance_name per_ri_config_information.config_information1%type;

214:
215: l_proc varchar2(72) := g_package || 'get_bg_job_keyflex_name';
216: l_error_message varchar2(360);
217:
218: l_regional_variance_name per_ri_config_information.config_information1%type;
219: l_job_key_flex_name varchar2(30);
220:
221: BEGIN
222: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 274: l_regional_variance_name per_ri_config_information.config_information1%type;

270:
271: l_proc varchar2(72) := g_package || 'get_bg_pos_keyflex_name';
272: l_error_message varchar2(360);
273:
274: l_regional_variance_name per_ri_config_information.config_information1%type;
275: l_pos_key_flex_name varchar2(30);
276:
277: BEGIN
278: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 327: l_product_name per_ri_config_information.config_information1%type;

323:
324: l_proc varchar2(72) := g_package || 'check_selected_product';
325: l_error_message varchar2(360);
326:
327: l_product_name per_ri_config_information.config_information1%type;
328: l_product_selected boolean default FALSE;
329:
330: BEGIN
331: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 378: l_regional_variance_name per_ri_config_information.config_information1%type;

374: and reg_variance_country_code = p_bg_country_code;
375:
376: l_proc varchar2(72) := g_package || 'get_bg_grd_keyflex_name';
377: l_error_message varchar2(360);
378: l_regional_variance_name per_ri_config_information.config_information1%type;
379: l_grd_key_flex_name varchar2(30);
380: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
381:
382: BEGIN

Line 380: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

376: l_proc varchar2(72) := g_package || 'get_bg_grd_keyflex_name';
377: l_error_message varchar2(360);
378: l_regional_variance_name per_ri_config_information.config_information1%type;
379: l_grd_key_flex_name varchar2(30);
380: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
381:
382: BEGIN
383: hr_utility.set_location('Entering:'|| l_proc, 10);
384:

Line 439: l_enterprise_short_name per_ri_config_information.config_information1%type;

435: select enterprise_short_name
436: from per_ri_config_enterprise_v
437: where configuration_code = p_configuration_code;
438:
439: l_enterprise_short_name per_ri_config_information.config_information1%type;
440: l_proc varchar2(72) := g_package || 'get_enterprise_short_name';
441: l_error_message varchar2(360);
442:
443: BEGIN

Line 491: l_enterprise_name per_ri_config_information.config_information1%type;

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;
492: l_proc varchar2(72) := g_package || 'get_enterprise_name';
493: l_error_message varchar2(360);
494:
495: BEGIN

Line 538: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

534: select enterprise_primary_industry
535: from per_ri_config_enterprise_v
536: where configuration_code = p_configuration_code;
537:
538: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
539:
540: l_proc varchar2(72) := g_package || 'get_ent_primary_industry';
541: l_error_message varchar2(360);
542: BEGIN

Line 597: l_configuration_code per_ri_config_information.configuration_code%type;

593: from per_ri_config_country_v
594: where country_code = cp_country_code
595: and configuration_code = cp_configuration_code;
596:
597: l_configuration_code per_ri_config_information.configuration_code%type;
598: l_country_code per_ri_config_information.config_information1%type;
599: l_number_of_employees per_ri_config_information.config_information1%type;
600: l_payroll_to_process_employees per_ri_config_information.config_information1%type;
601: l_hr_support_for_this_country per_ri_config_information.config_information1%type;

Line 598: l_country_code per_ri_config_information.config_information1%type;

594: where country_code = cp_country_code
595: and configuration_code = cp_configuration_code;
596:
597: l_configuration_code per_ri_config_information.configuration_code%type;
598: l_country_code per_ri_config_information.config_information1%type;
599: l_number_of_employees per_ri_config_information.config_information1%type;
600: l_payroll_to_process_employees per_ri_config_information.config_information1%type;
601: l_hr_support_for_this_country per_ri_config_information.config_information1%type;
602: l_business_group_decision per_ri_config_information.config_information1%type;

Line 599: l_number_of_employees per_ri_config_information.config_information1%type;

595: and configuration_code = cp_configuration_code;
596:
597: l_configuration_code per_ri_config_information.configuration_code%type;
598: l_country_code per_ri_config_information.config_information1%type;
599: l_number_of_employees per_ri_config_information.config_information1%type;
600: l_payroll_to_process_employees per_ri_config_information.config_information1%type;
601: l_hr_support_for_this_country per_ri_config_information.config_information1%type;
602: l_business_group_decision per_ri_config_information.config_information1%type;
603: l_called_from_ui boolean default FALSE;

Line 600: l_payroll_to_process_employees per_ri_config_information.config_information1%type;

596:
597: l_configuration_code per_ri_config_information.configuration_code%type;
598: l_country_code per_ri_config_information.config_information1%type;
599: l_number_of_employees per_ri_config_information.config_information1%type;
600: l_payroll_to_process_employees per_ri_config_information.config_information1%type;
601: l_hr_support_for_this_country per_ri_config_information.config_information1%type;
602: l_business_group_decision per_ri_config_information.config_information1%type;
603: l_called_from_ui boolean default FALSE;
604:

Line 601: l_hr_support_for_this_country per_ri_config_information.config_information1%type;

597: l_configuration_code per_ri_config_information.configuration_code%type;
598: l_country_code per_ri_config_information.config_information1%type;
599: l_number_of_employees per_ri_config_information.config_information1%type;
600: l_payroll_to_process_employees per_ri_config_information.config_information1%type;
601: l_hr_support_for_this_country per_ri_config_information.config_information1%type;
602: l_business_group_decision per_ri_config_information.config_information1%type;
603: l_called_from_ui boolean default FALSE;
604:
605: l_proc varchar2(72) := g_package || 'business_group_decision';

Line 602: l_business_group_decision per_ri_config_information.config_information1%type;

598: l_country_code per_ri_config_information.config_information1%type;
599: l_number_of_employees per_ri_config_information.config_information1%type;
600: l_payroll_to_process_employees per_ri_config_information.config_information1%type;
601: l_hr_support_for_this_country per_ri_config_information.config_information1%type;
602: l_business_group_decision per_ri_config_information.config_information1%type;
603: l_called_from_ui boolean default FALSE;
604:
605: l_proc varchar2(72) := g_package || 'business_group_decision';
606: l_error_message varchar2(360);

Line 1225: l_le_business_group_name per_ri_config_information.config_information1%type;

1221: from per_ri_config_legal_entity_v
1222: where configuration_code = cp_configuration_code
1223: and legal_entity_name = cp_legal_entity_name;
1224:
1225: l_le_business_group_name per_ri_config_information.config_information1%type;
1226: l_legal_entity_country_name per_ri_config_information.config_information1%type;
1227:
1228: l_proc varchar2(72) := g_package || 'get_le_bg_name';
1229: l_error_message varchar2(360);

Line 1226: l_legal_entity_country_name per_ri_config_information.config_information1%type;

1222: where configuration_code = cp_configuration_code
1223: and legal_entity_name = cp_legal_entity_name;
1224:
1225: l_le_business_group_name per_ri_config_information.config_information1%type;
1226: l_legal_entity_country_name per_ri_config_information.config_information1%type;
1227:
1228: l_proc varchar2(72) := g_package || 'get_le_bg_name';
1229: l_error_message varchar2(360);
1230:

Line 1278: l_oc_business_group_name per_ri_config_information.config_information1%type;

1274: from per_ri_config_oper_comp_v
1275: where configuration_code = cp_configuration_code
1276: and operating_company_name = cp_operating_company_name;
1277:
1278: l_oc_business_group_name per_ri_config_information.config_information1%type;
1279: l_operating_company_hq_country per_ri_config_information.config_information1%type;
1280:
1281: l_proc varchar2(72) := g_package || 'get_oc_bg_name';
1282: l_error_message varchar2(360);

Line 1279: l_operating_company_hq_country per_ri_config_information.config_information1%type;

1275: where configuration_code = cp_configuration_code
1276: and operating_company_name = cp_operating_company_name;
1277:
1278: l_oc_business_group_name per_ri_config_information.config_information1%type;
1279: l_operating_company_hq_country per_ri_config_information.config_information1%type;
1280:
1281: l_proc varchar2(72) := g_package || 'get_oc_bg_name';
1282: l_error_message varchar2(360);
1283: BEGIN

Line 1330: l_business_group_name per_ri_config_information.config_information1%type;

1326: from per_ri_config_enterprise_v
1327: where configuration_code = cp_configuration_code
1328: and enterprise_name = cp_enterprise_name;
1329:
1330: l_business_group_name per_ri_config_information.config_information1%type;
1331: l_enterprise_hq_country per_ri_config_information.config_information1%type;
1332:
1333: l_proc varchar2(72) := g_package || 'get_enterprise_bg_name';
1334: l_error_message varchar2(360);

Line 1331: l_enterprise_hq_country per_ri_config_information.config_information1%type;

1327: where configuration_code = cp_configuration_code
1328: and enterprise_name = cp_enterprise_name;
1329:
1330: l_business_group_name per_ri_config_information.config_information1%type;
1331: l_enterprise_hq_country per_ri_config_information.config_information1%type;
1332:
1333: l_proc varchar2(72) := g_package || 'get_enterprise_bg_name';
1334: l_error_message varchar2(360);
1335:

Line 1384: l_location_code per_ri_config_information.config_information1%type;

1380: from per_ri_config_locations
1381: where configuration_code = cp_configuration_code
1382: and location_id = cp_location_id;
1383:
1384: l_location_code per_ri_config_information.config_information1%type;
1385:
1386: l_proc varchar2(72) := g_package || 'get_config_location_code';
1387: l_error_message varchar2(360);
1388:

Line 1772: from per_ri_config_information pci

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:
1776: cursor get_country_name(p_territory_code varchar2) IS

Line 1783: from per_ri_config_information pci

1779: where territory_code = p_territory_code;
1780:
1781: cursor get_selected_list IS
1782: select distinct config_information2
1783: from per_ri_config_information pci
1784: where configuration_code = p_configuration_code
1785: and config_information_category = p_config_info_category
1786: and config_information1 <> p_reg_var_name;
1787:

Line 1846: from per_ri_config_information pci

1842: ,p_config_info_category varchar2)
1843: RETURN varchar2 IS
1844: cursor get_selected_country IS
1845: select distinct config_information2 business_group
1846: from per_ri_config_information pci
1847: where configuration_code = p_configuration_code
1848: and config_information_category = p_config_info_category
1849: and config_information1 = p_reg_var_name;
1850:

Line 1901: from per_ri_config_information pci

1897: RETURN varchar2 IS
1898:
1899: cursor get_selected_list IS
1900: select config_information2 country
1901: from per_ri_config_information pci
1902: where configuration_code = p_configuration_code
1903: and config_information_category = p_config_info_category
1904: and config_information1 = p_reg_var_name;
1905:

Line 2367: l_country_code per_ri_config_information.config_information1%type;

2363: RETURN varchar2 IS
2364:
2365: l_proc varchar2(72) := g_package || 'determine_country_resp';
2366: l_error_message varchar2(360);
2367: l_country_code per_ri_config_information.config_information1%type;
2368: l_responsibility_application per_ri_config_responsibility.responsibility_application%type;
2369: l_assign_responsibility varchar2(30);
2370: l_shrms boolean;
2371: l_hrms boolean;

Line 2432: l_country_code per_ri_config_information.config_information1%type;

2428: and responsibility_application = cp_assign_responsibility;
2429:
2430: l_proc varchar2(72) := g_package || 'responsibility_exists';
2431: l_error_message varchar2(360);
2432: l_country_code per_ri_config_information.config_information1%type;
2433: l_responsibility_application per_ri_config_responsibility.responsibility_application%type;
2434: l_assign_responsibility varchar2(30);
2435: l_resp_exists boolean default FALSE;
2436:

Line 2677: l_enterprise_primary_industry per_ri_config_information.config_information1%type;

2673: l_log_message varchar2(360);
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

Line 2764: l_entity_name per_ri_config_information.config_information1%type;

2760: FUNCTION return_config_entity_name(entity_name in varchar2)
2761: RETURN varchar2 IS
2762:
2763:
2764: l_entity_name per_ri_config_information.config_information1%type;
2765: l_multiple_config_upload varchar2(20);
2766:
2767: l_proc varchar2(72) := g_package || 'return_config_entity_name';
2768: l_error_message varchar2(360);

Line 2807: l_entity_name per_ri_config_information.config_information1%type;

2803: FUNCTION return_config_entity_name_pre(entity_name in varchar2)
2804: RETURN varchar2 IS
2805:
2806:
2807: l_entity_name per_ri_config_information.config_information1%type;
2808: l_multiple_config_upload varchar2(20);
2809:
2810: l_proc varchar2(72) := g_package || 'return_config_entity_name_pre';
2811: l_error_message varchar2(360);