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 FND_RESPONSIBILITY_VL

Line 2213: l_responsibility_key fnd_responsibility_vl.responsibility_name%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);
2217: l_error_message varchar2(360);

Line 3009: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;

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;
3013: l_proc varchar2(72) := g_package || 'create_more_hrms_resps';

Line 3270: ,p_resp_key in fnd_responsibility_vl.responsibility_name%type

3266: -------------------------------------------------------------------------- */
3267:
3268: PROCEDURE create_responsibility
3269: (p_app_short_name in fnd_application.application_short_name%type
3270: ,p_resp_key in fnd_responsibility_vl.responsibility_name%type
3271: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
3272: ,p_responsibility_name in fnd_responsibility_tl.responsibility_name%type
3273: ,p_owner in varchar2
3274: ,p_data_group_app_short_name in fnd_application.application_short_name%type

Line 3367: from fnd_responsibility_vl

3363: where responsibility_key = cp_responsibility_kay;
3364:
3365: cursor csr_responsibility_name(cp_responsibility_kay in varchar2) IS
3366: select responsibility_name
3367: from fnd_responsibility_vl
3368: where responsibility_key = cp_responsibility_kay;
3369:
3370: cursor csr_application(cp_application_id in number) IS
3371: select application_short_name

Line 3403: l_responsibility_key fnd_responsibility_vl.responsibility_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;
3407: l_ts_new_resp_key fnd_responsibility_vl.responsibility_name%type;

Line 3404: l_ts_responsibility_key fnd_responsibility_vl.responsibility_name%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;
3407: l_ts_new_resp_key fnd_responsibility_vl.responsibility_name%type;
3408: l_ovn number(9);

Line 3405: l_ts_new_responsibility_name fnd_responsibility_vl.responsibility_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;
3407: l_ts_new_resp_key fnd_responsibility_vl.responsibility_name%type;
3408: l_ovn number(9);
3409:

Line 3406: l_ts_responsibility_name fnd_responsibility_vl.responsibility_name%type;

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;
3407: l_ts_new_resp_key fnd_responsibility_vl.responsibility_name%type;
3408: l_ovn number(9);
3409:
3410: l_proc varchar2(72) := g_package || 'create_resp_and_profile';

Line 3407: l_ts_new_resp_key fnd_responsibility_vl.responsibility_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;
3407: l_ts_new_resp_key fnd_responsibility_vl.responsibility_name%type;
3408: l_ovn number(9);
3409:
3410: l_proc varchar2(72) := g_package || 'create_resp_and_profile';
3411: l_log_message varchar2(360);

Line 3416: l_new_resp_key fnd_responsibility_vl.responsibility_name%type;

3412: l_error_message varchar2(360);
3413:
3414: l_bg_sg_ut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3415: l_new_app_short_name fnd_application.application_short_name%type;
3416: l_new_resp_key fnd_responsibility_vl.responsibility_name%type;
3417: l_new_responsibility_id fnd_responsibility.responsibility_id%type;
3418: l_new_responsibility_name fnd_responsibility_tl.responsibility_name%type;
3419: l_new_owner varchar2(120);
3420: l_new_data_group_app_name fnd_application.application_short_name%type;

Line 3450: from fnd_responsibility_vl resp,

3446: request_group_id,
3447: resp.version version,
3448: resp.web_host_name web_host_name,
3449: resp.web_agent_name web_agent_name
3450: from fnd_responsibility_vl resp,
3451: fnd_application_vl apps,
3452: fnd_menus menus
3453: where resp.application_id = apps.application_id
3454: and resp.menu_id = menus.menu_id

Line 3707: from fnd_responsibility_vl

3703:
3704: cursor csr_responsibility_key
3705: (cp_responsibility_key in varchar2) IS
3706: select responsibility_name
3707: from fnd_responsibility_vl
3708: where responsibility_key = cp_responsibility_key;
3709:
3710: l_responsibility_name fnd_responsibility_vl.responsibility_name%type;
3711:

Line 3710: l_responsibility_name fnd_responsibility_vl.responsibility_name%type;

3706: select responsibility_name
3707: from fnd_responsibility_vl
3708: where responsibility_key = cp_responsibility_key;
3709:
3710: l_responsibility_name fnd_responsibility_vl.responsibility_name%type;
3711:
3712: l_proc varchar2(72) := g_package || 'get_responsibility_name';
3713: l_error_message varchar2(360);
3714: