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.ORACLENAVIGATE dependencies on FND_PROFILE

Line 50: --l_security_group := fnd_profile.value('ENABLE_SECURITY_GROUPS');

46: into l_security_group_count
47: from fnd_security_groups
48: where security_group_id >= 0;
49: */
50: --l_security_group := fnd_profile.value('ENABLE_SECURITY_GROUPS');
51:
52: fnd_profile.get_specific(
53: name_z => 'ENABLE_SECURITY_GROUPS',
54: responsibility_id_z => p_responsibility_id,

Line 52: fnd_profile.get_specific(

48: where security_group_id >= 0;
49: */
50: --l_security_group := fnd_profile.value('ENABLE_SECURITY_GROUPS');
51:
52: fnd_profile.get_specific(
53: name_z => 'ENABLE_SECURITY_GROUPS',
54: responsibility_id_z => p_responsibility_id,
55: application_id_z => p_application_id,
56: val_z => l_security_group,

Line 550: AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=

546: and a.start_date <= sysdate
547: and (a.end_date is null or a.end_date > sysdate)
548: AND b.SECURITY_GROUP_ID IN (-1, fsg.SECURITY_GROUP_ID)
549: AND fsg.SECURITY_GROUP_ID >= 0
550: AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=
551: nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)
552: ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;
553:
554: begin

Line 551: nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)

547: and (a.end_date is null or a.end_date > sysdate)
548: AND b.SECURITY_GROUP_ID IN (-1, fsg.SECURITY_GROUP_ID)
549: AND fsg.SECURITY_GROUP_ID >= 0
550: AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=
551: nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)
552: ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;
553:
554: begin
555:

Line 562: fnd_profile.get(name => 'APPS_PORTAL',

558:
559: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE
560: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow
561:
562: fnd_profile.get(name => 'APPS_PORTAL',
563: val => l_url);
564:
565: if l_url IS NULL Then
566: htp.p ('Please contact System Administrator. ');

Line 574: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'

570: owa_util.mime_header('text/html', FALSE);
571: owa_util.redirect_url(l_url);
572: owa_util.http_header_close;
573:
574: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
575: then
576: select FUNCTION_ID
577: into l_function_id
578: from FND_FORM_FUNCTIONS

Line 592: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'PHP_FWK'

588: owa_util.mime_header('text/html', FALSE);
589: owa_util.redirect_url(l_url);
590: owa_util.http_header_close;
591:
592: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'PHP_FWK'
593: then
594: select FUNCTION_ID
595: into l_function_id
596: from FND_FORM_FUNCTIONS

Line 1238: AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=

1234: and a.start_date <= sysdate
1235: and (a.end_date is null or a.end_date > sysdate)
1236: AND b.SECURITY_GROUP_ID IN (-1, fsg.SECURITY_GROUP_ID)
1237: AND fsg.SECURITY_GROUP_ID >= 0
1238: AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=
1239: nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)
1240: ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;
1241:
1242: begin

Line 1239: nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)

1235: and (a.end_date is null or a.end_date > sysdate)
1236: AND b.SECURITY_GROUP_ID IN (-1, fsg.SECURITY_GROUP_ID)
1237: AND fsg.SECURITY_GROUP_ID >= 0
1238: AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=
1239: nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)
1240: ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;
1241:
1242: begin
1243:

Line 1269: l_php_mode := fnd_profile.value('APPLICATIONS_HOME_PAGE');

1265: end if;
1266:
1267: icx_util.getprompts(601, 'ICX_OBIS_NAVIGATE', l_title, l_prompts);
1268:
1269: l_php_mode := fnd_profile.value('APPLICATIONS_HOME_PAGE');
1270:
1271: if l_prompts.COUNT = 7 -- remove once seeddate available
1272: then
1273: l_prompts(6) := '';

Line 1810: AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=

1806: and a.start_date <= sysdate
1807: and (a.end_date is null or a.end_date > sysdate)
1808: AND b.SECURITY_GROUP_ID IN (-1, fsg.SECURITY_GROUP_ID)
1809: AND fsg.SECURITY_GROUP_ID >= 0
1810: AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=
1811: nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)
1812: ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;
1813:
1814: cursor Favorites is

Line 1811: nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)

1807: and (a.end_date is null or a.end_date > sysdate)
1808: AND b.SECURITY_GROUP_ID IN (-1, fsg.SECURITY_GROUP_ID)
1809: AND fsg.SECURITY_GROUP_ID >= 0
1810: AND nvl(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'),1) <=
1811: nvl(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL',b.USER_ID,a.RESPONSIBILITY_ID,b.RESPONSIBILITY_APPLICATION_ID),1)
1812: ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;
1813:
1814: cursor Favorites is
1815: select PROMPT,