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_BUSINESS_GROUPS

Line 2196: from per_business_groups

2192: where responsibility_key = cp_responsibility_kay;
2193:
2194: cursor csr_business_group(cp_business_group_name in varchar2) IS
2195: select business_group_id,security_group_id
2196: from per_business_groups
2197: where name = cp_business_group_name;
2198:
2199: cursor csr_security_profiles (cp_security_profile_name varchar2)IS
2200: select security_profile_id

Line 2212: l_security_profile_name per_business_groups.name%type;

2208: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
2209: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
2210: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
2211:
2212: l_security_profile_name per_business_groups.name%type;
2213: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;
2214: l_ovn number(9);
2215: l_proc varchar2(72) := g_package || 'create_security_profile_assign';
2216: l_log_message varchar2(360);

Line 2536: from per_business_groups

2532: FUNCTION check_fresh_installation
2533: RETURN boolean IS
2534: cursor csr_bg_data IS
2535: select name
2536: from per_business_groups
2537: where name <> 'Setup Business Group';
2538:
2539: l_proc varchar2(72) := g_package || 'check_fresh_installation';
2540: l_log_message varchar2(360);

Line 2542: l_name per_business_groups.name%type;

2538:
2539: l_proc varchar2(72) := g_package || 'check_fresh_installation';
2540: l_log_message varchar2(360);
2541: l_error_message varchar2(360);
2542: l_name per_business_groups.name%type;
2543: l_fresh_installed boolean default FALSE;
2544:
2545: BEGIN
2546: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3008: l_security_profile_name per_business_groups.name%type;

3004: in out nocopy per_ri_config_tech_summary.profile_resp_tab
3005: ,p_more_int_profile_resp_tab
3006: in out nocopy per_ri_config_tech_summary.profile_resp_tab) IS
3007:
3008: l_security_profile_name per_business_groups.name%type;
3009: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;
3010: l_ovn number(9);
3011: l_hrms_resp_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3012: l_int_resp_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;

Line 3377: from per_business_groups

3373: where application_id = cp_application_id;
3374:
3375: cursor csr_business_group(cp_business_group_name in varchar2) IS
3376: select security_group_id
3377: from per_business_groups
3378: where name = cp_business_group_name;
3379:
3380: cursor csr_security_profiles (cp_security_profile_name varchar2)IS
3381: select security_profile_id

Line 3392: l_business_group_id per_business_groups.business_group_id%type;

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;
3395: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
3396: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;

Line 3393: l_business_group_name per_business_groups.name%type;

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;
3395: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
3396: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
3397:

Line 3402: l_security_profile_name per_business_groups.name%type;

3398: l_security_group_name fnd_security_groups_vl.security_group_name%type;
3399: l_security_group_key fnd_security_groups_vl.security_group_key%type;
3400: l_application_short_name fnd_application.application_short_name%type;
3401:
3402: l_security_profile_name per_business_groups.name%type;
3403: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;
3404: l_ts_responsibility_key fnd_responsibility_vl.responsibility_name%type;
3405: l_ts_new_responsibility_name fnd_responsibility_vl.responsibility_name%type;
3406: l_ts_responsibility_name fnd_responsibility_vl.responsibility_name%type;

Line 3433: l_legilsation_code per_business_groups.legislation_code%type;

3429: l_new_request_group_id fnd_request_groups.request_group_name%type;
3430: l_new_version fnd_responsibility.version%type;
3431: l_new_web_host_name fnd_responsibility.web_host_name%type;
3432: l_new_web_agent_name fnd_responsibility.web_agent_name%type;
3433: l_legilsation_code per_business_groups.legislation_code%type;
3434: l_hrms_resp_one_count number(9) := 0;
3435:
3436: cursor csr_new_responsibility(cp_new_responsibility_key in varchar) IS
3437: select apps.application_short_name application_short_name,

Line 3750: select name from per_business_groups

3746: FUNCTION get_business_group_name
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: