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.HR_USER_ACCT_INTERNAL dependencies on FND_APPLICATION

Line 377: FROM fnd_application

373: ) IS
374: --
375: CURSOR lc_get_app_short_name (c_app_id in number) IS
376: SELECT application_short_name
377: FROM fnd_application
378: WHERE application_id = c_app_id;
379: --
380: -- The following check unique resp key sql is copied from FNDSCRSP.fmb,
381: -- program unit FND_UNIQUE_RESP_KEY.

Line 426: l_resp_app_short_name fnd_application.application_short_name%type := null;

422: FROM sys.dual;
423:
424:
425: l_proc varchar2(72) := g_package||'create_fnd_responsibility';
426: l_resp_app_short_name fnd_application.application_short_name%type := null;
427: l_data_grp_app_short_name fnd_application.application_short_name%type := null;
428: l_req_grp_app_short_name fnd_application.application_short_name%type := null;
429: l_dummy number default null;
430: l_request_group_app_id fnd_responsibility.group_application_id%type

Line 427: l_data_grp_app_short_name fnd_application.application_short_name%type := null;

423:
424:
425: l_proc varchar2(72) := g_package||'create_fnd_responsibility';
426: l_resp_app_short_name fnd_application.application_short_name%type := null;
427: l_data_grp_app_short_name fnd_application.application_short_name%type := null;
428: l_req_grp_app_short_name fnd_application.application_short_name%type := null;
429: l_dummy number default null;
430: l_request_group_app_id fnd_responsibility.group_application_id%type
431: default null;

Line 428: l_req_grp_app_short_name fnd_application.application_short_name%type := null;

424:
425: l_proc varchar2(72) := g_package||'create_fnd_responsibility';
426: l_resp_app_short_name fnd_application.application_short_name%type := null;
427: l_data_grp_app_short_name fnd_application.application_short_name%type := null;
428: l_req_grp_app_short_name fnd_application.application_short_name%type := null;
429: l_dummy number default null;
430: l_request_group_app_id fnd_responsibility.group_application_id%type
431: default null;
432: l_responsibility_id fnd_responsibility.responsibility_id%type default null;

Line 448: fnd_message.set_token('TABLE', 'FND_APPLICATION');

444: IF lc_get_app_short_name%NOTFOUND
445: THEN
446: CLOSE lc_get_app_short_name;
447: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
448: fnd_message.set_token('TABLE', 'FND_APPLICATION');
449: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
450: fnd_message.set_token('VALUE', to_char(p_resp_app_id));
451: hr_utility.raise_error;
452: ELSE

Line 464: fnd_message.set_token('TABLE', 'FND_APPLICATION');

460: IF lc_get_app_short_name%NOTFOUND
461: THEN
462: CLOSE lc_get_app_short_name;
463: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
464: fnd_message.set_token('TABLE', 'FND_APPLICATION');
465: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
466: fnd_message.set_token('VALUE', to_char(p_data_group_app_id));
467: hr_utility.raise_error;
468: ELSE

Line 484: fnd_message.set_token('TABLE', 'FND_APPLICATION');

480: IF lc_get_app_short_name%NOTFOUND
481: THEN
482: CLOSE lc_get_app_short_name;
483: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
484: fnd_message.set_token('TABLE', 'FND_APPLICATION');
485: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
486: fnd_message.set_token('VALUE', to_char(p_request_group_app_id));
487: hr_utility.raise_error;
488: ELSE

Line 708: FROM fnd_application

704: WHERE responsibility_id = p_responsibility_id;
705: --
706: CURSOR lc_get_app_id IS
707: SELECT application_id
708: FROM fnd_application
709: WHERE application_id = p_application_id;
710: --
711: --
712: CURSOR lc_unique_user_resp_groups IS

Line 776: fnd_message.set_token('TABLE', 'FND_APPLICATION');

772: IF lc_get_app_id%NOTFOUND
773: THEN
774: CLOSE lc_get_app_id;
775: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
776: fnd_message.set_token('TABLE', 'FND_APPLICATION');
777: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
778: fnd_message.set_token('VALUE', to_char(p_application_id));
779: hr_utility.raise_error;
780: ELSE

Line 2561: FROM fnd_application

2557: WHERE responsibility_id = p_responsibility_id;
2558: --
2559: CURSOR lc_get_app_id IS
2560: SELECT application_id
2561: FROM fnd_application
2562: WHERE application_id = p_resp_application_id;
2563: --
2564: -- When ENABLED_SECURITY_GROUPS profile option = 'N', then the
2565: -- fnd_user_resp_groups should function like R11 fnd_user_responsibility, the

Line 2654: fnd_message.set_token('TABLE', 'FND_APPLICATION');

2650: IF lc_get_app_id%NOTFOUND
2651: THEN
2652: CLOSE lc_get_app_id;
2653: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2654: fnd_message.set_token('TABLE', 'FND_APPLICATION');
2655: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
2656: fnd_message.set_token('VALUE', to_char(p_resp_application_id));
2657: hr_utility.raise_error;
2658: ELSE