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_APPLICATION

Line 781: from fnd_application

777: if (p_level = '10001') then
778: levval_id := 0;
779: elsif (p_level = '10002') then
780: select application_id into levval_id
781: from fnd_application
782: where application_short_name = p_level_value;
783: elsif (p_level = '10003') then
784: select application_id into lapp_id
785: from fnd_application

Line 785: from fnd_application

781: from fnd_application
782: where application_short_name = p_level_value;
783: elsif (p_level = '10003') then
784: select application_id into lapp_id
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

Line 964: FROM FND_APPLICATION

960: shorthand_length => p_shorthand_length);
961:
962: SELECT application_id
963: INTO l_application_id
964: FROM FND_APPLICATION
965: WHERE application_short_name = p_appl_short_name;
966:
967: SELECT NVL(MAX(ifs.id_flex_num),0) + 1
968: INTO l_structure.structure_number

Line 1942: from fnd_application fa, fnd_id_flex_structures_vl fifs

1938: ,p_structure_code in varchar2) IS
1939:
1940: cursor flex_num_cursor IS
1941: select fifs.id_flex_num
1942: from fnd_application fa, fnd_id_flex_structures_vl fifs
1943: where fa.application_short_name = p_appl_short_name
1944: and fa.application_id = fifs.application_id
1945: and fifs.id_flex_code = p_flex_code
1946: and fifs.id_flex_structure_code = p_structure_code;

Line 3269: (p_app_short_name in fnd_application.application_short_name%type

3265: --
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

Line 3274: ,p_data_group_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
3277: ,p_start_date in varchar2
3278: ,p_end_date in varchar2

Line 3280: ,p_group_app_short_name in fnd_application.application_short_name%type

3276: ,p_menu_name in fnd_menus.menu_name%type
3277: ,p_start_date in varchar2
3278: ,p_end_date in varchar2
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

Line 3372: from fnd_application

3368: where responsibility_key = cp_responsibility_kay;
3369:
3370: cursor csr_application(cp_application_id in number) IS
3371: select application_short_name
3372: from fnd_application
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

Line 3400: l_application_short_name fnd_application.application_short_name%type;

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

Line 3415: l_new_app_short_name fnd_application.application_short_name%type;

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

Line 3420: l_new_data_group_app_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;
3423: l_new_menu_name fnd_menus.menu_name%type;
3424: l_new_start_date varchar2(240); -- must be varchar

Line 3427: l_new_group_app_short_name fnd_application.application_short_name%type;

3423: l_new_menu_name fnd_menus.menu_name%type;
3424: l_new_start_date varchar2(240); -- must be varchar
3425: l_new_end_date varchar2(240); -- must be varchar
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;

Line 3451: fnd_application_vl apps,

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
3455: and resp.responsibility_key = cp_new_responsibility_key;

Line 3460: fnd_application apps

3456:
3457: cursor csr_requests_groups(cp_new_request_group_id in number) IS
3458: select request_group_name, apps.application_short_name
3459: from fnd_request_groups req,
3460: fnd_application apps
3461: where request_group_id = cp_new_request_group_id
3462: and req.application_id = apps.application_id;
3463:
3464: cursor csr_data_groups(cp_new_data_group_id in number,

Line 3469: fnd_application a

3465: cp_new_app_short_name in varchar2) IS
3466: select dg.data_group_name, a.application_short_name
3467: from fnd_data_group_units dgu,
3468: fnd_data_groups dg,
3469: fnd_application a
3470: where dgu.data_group_id = dg.data_group_id
3471: and dg.data_group_id = cp_new_data_group_id
3472: and dgu.application_id = a.application_id
3473: and a.application_short_name = cp_new_app_short_name;