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

Line 789: from fnd_responsibility

785: from fnd_application
786: where application_short_name = p_level_value_app;
787:
788: select responsibility_id into levval_id
789: from fnd_responsibility
790: where application_id = lapp_id
791: and responsibility_key = p_level_value;
792: elsif (p_level = '10005') then
793: select server_id into levval_id

Line 2191: from fnd_responsibility

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
2191: from fnd_responsibility
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

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 3271: ,p_responsibility_id in fnd_responsibility.responsibility_id%type

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
3275: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type

Line 3272: ,p_responsibility_name in fnd_responsibility_tl.responsibility_name%type

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
3275: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type
3276: ,p_menu_name in fnd_menus.menu_name%type

Line 3283: ,p_web_host_name in fnd_responsibility.web_host_name%type

3279: ,p_description in varchar2
3280: ,p_group_app_short_name in fnd_application.application_short_name%type
3281: ,p_request_group_name in fnd_request_groups.request_group_name%type
3282: ,p_version in varchar2
3283: ,p_web_host_name in fnd_responsibility.web_host_name%type
3284: ,p_web_agent_name in fnd_responsibility.web_agent_name%type) IS
3285:
3286: l_proc varchar2(72) := g_package || 'create_responsibility';
3287: l_error_message varchar2(360);

Line 3284: ,p_web_agent_name in fnd_responsibility.web_agent_name%type) IS

3280: ,p_group_app_short_name in fnd_application.application_short_name%type
3281: ,p_request_group_name in fnd_request_groups.request_group_name%type
3282: ,p_version in varchar2
3283: ,p_web_host_name in fnd_responsibility.web_host_name%type
3284: ,p_web_agent_name in fnd_responsibility.web_agent_name%type) IS
3285:
3286: l_proc varchar2(72) := g_package || 'create_responsibility';
3287: l_error_message varchar2(360);
3288:

Line 3299: fnd_responsibility_pkg.load_row

3295: -- create responsibility only when if specified resposibility does not exists
3296: -- this case would happen when loader program is running into non-multiple configuration
3297: -- load mode.
3298: if NOT (fnd_function_security.responsibility_exists(responsibility_key => p_resp_key)) then
3299: fnd_responsibility_pkg.load_row
3300: (x_app_short_name => p_app_short_name
3301: ,x_resp_key => p_resp_key
3302: ,x_responsibility_id => null
3303: ,x_responsibility_name => p_responsibility_name

Line 3362: from fnd_responsibility

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
3362: from fnd_responsibility
3363: where responsibility_key = cp_responsibility_kay;
3364:
3365: cursor csr_responsibility_name(cp_responsibility_kay in varchar2) IS
3366: select responsibility_name

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 3417: l_new_responsibility_id fnd_responsibility.responsibility_id%type;

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;
3421: l_new_data_group_name fnd_data_groups_standard_view.data_group_name%type;

Line 3418: l_new_responsibility_name fnd_responsibility_tl.responsibility_name%type;

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;
3421: l_new_data_group_name fnd_data_groups_standard_view.data_group_name%type;
3422: l_new_data_group_id fnd_data_groups_standard_view.data_group_name%type;

Line 3430: l_new_version fnd_responsibility.version%type;

3426: l_new_description varchar2(240);
3427: l_new_group_app_short_name fnd_application.application_short_name%type;
3428: l_new_request_group_name fnd_request_groups.request_group_name%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;

Line 3431: l_new_web_host_name fnd_responsibility.web_host_name%type;

3427: l_new_group_app_short_name fnd_application.application_short_name%type;
3428: l_new_request_group_name fnd_request_groups.request_group_name%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:

Line 3432: l_new_web_agent_name fnd_responsibility.web_agent_name%type;

3428: l_new_request_group_name fnd_request_groups.request_group_name%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

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: