DBA Data[Home] [Help]

APPS.FND_SESSION_MANAGEMENT dependencies on FND_PROFILE

Line 294: fnd_profile.get_specific(name_z => 'FND_FIXED_KEY_ENABLED',

290: lm_key varchar2(40);
291: l_fixed_key varchar2(10);
292: l_profile_defined boolean;
293: begin
294: fnd_profile.get_specific(name_z => 'FND_FIXED_KEY_ENABLED',
295: user_id_z => p_user_id,
296: val_z => l_fixed_key,
297: defined_z => l_profile_defined);
298: if(l_fixed_key = 'Y') then

Line 299: fnd_profile.get_specific(name_z => 'FND_FIXED_SEC_KEY',

295: user_id_z => p_user_id,
296: val_z => l_fixed_key,
297: defined_z => l_profile_defined);
298: if(l_fixed_key = 'Y') then
299: fnd_profile.get_specific(name_z => 'FND_FIXED_SEC_KEY',
300: user_id_z => p_user_id,
301: val_z => lf_key,
302: defined_z => l_profile_defined);
303:

Line 381: fnd_profile.get_specific (name_z => 'ICX_SESSION_TIMEOUT',

377: --
378:
379: -- There are not responsibility_id and app_resp_id defined.
380: l_profile_defined := false;
381: fnd_profile.get_specific (name_z => 'ICX_SESSION_TIMEOUT',
382: user_id_z => p_user_id,
383: val_z => l_timeout,
384: defined_z => l_profile_defined);
385: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 420: -- fnd_profile.get_specific

416:
417: l_XSID := NewXSID;
418:
419: -- Is user GUEST
420: -- fnd_profile.get_specific
421: -- (name_z => 'GUEST_USER_PWD',
422: -- val_z => l_guest_username ,
423: -- defined_z => l_profile_defined);
424: -- Using new api to retrieve GUEST credentials.

Line 445: fnd_profile.get_specific

441: else
442: l_guest := 'N';
443: end if;
444:
445: fnd_profile.get_specific
446: (name_z => 'DISTRIBUTED_ENVIRONMENT',
447: val_z => l_dist,
448: defined_z => l_profile_defined);
449:

Line 690: -- fnd_profile.get_specific

686: return 'N';
687: end if;
688:
689: -- check if switched-to user is GUEST
690: -- fnd_profile.get_specific
691: -- (name_z => 'GUEST_USER_PWD',
692: -- val_z => l_guest_username ,
693: -- defined_z => l_profile_defined);
694: -- Using new api to retrieve GUEST credentials.

Line 732: fnd_profile.get_specific (name_z => 'ICX_SESSION_TIMEOUT',

728: -- Bug 5354477 amgonzal
729: -- Finding the ICX_SESSION_TIMEOUT for the user session being converted
730: --
731: l_profile_defined := false;
732: fnd_profile.get_specific (name_z => 'ICX_SESSION_TIMEOUT',
733: user_id_z => p_user_id,
734: responsibility_id_z => l_resp_id,
735: application_id_z => l_resp_app_id,
736: val_z => l_profile_timeout,

Line 773: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');

769:
770: -- Bug 6010245 Guest Login is not being end dated in FND_LOGINS.
771: -- AMGONZAL.
772:
773: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');
774: if (l_audit_level is not null) and ( l_from_login_id is not null) then
775: fnd_signon.audit_end(l_from_login_id); -- end guest audit session and resps.
776: end if;
777:

Line 1129: fnd_profile.get_specific

1125: l_multi_org_flag := MO_UTILS.Get_Multi_Org_Flag;
1126:
1127: if l_multi_org_flag = 'Y'
1128: then
1129: fnd_profile.get_specific
1130: (name_z => 'ORG_ID',
1131: responsibility_id_z => fnd_session_management.g_responsibility_id,
1132: application_id_z => fnd_session_management.g_resp_appl_id,
1133: val_z => fnd_session_management.g_org_id,

Line 1137: fnd_profile.get(name => 'ICX_PREFIX',

1133: val_z => fnd_session_management.g_org_id,
1134: defined_z => l_profile_defined);
1135: end if;
1136:
1137: fnd_profile.get(name => 'ICX_PREFIX',
1138: val => l_prefix);
1139:
1140: if (l_prefix IS NOT NULL)
1141: then

Line 1496: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',

1492: -- Finding first new possible ICX_SESSION_TIMEOUT value
1493: /*
1494: -- added changes for bug#3951647
1495:
1496: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',
1497: val => l_timeout);
1498: Session_update_timeout_pvt(p_session_id, l_timeout);
1499:
1500: -- end changes for bug #3951647

Line 1508: -- Calling fnd_profile.get_specific with the resp_id and app_resp_id

1504: -- Most of the times fnd_session_management.check_session is called with no
1505: -- values for p_resp_id and p_app_resp_id
1506: -- Then, if passed p_resp_id and p_app_resp_id the ICX_SESSION_TIMEOUT
1507: -- value returned will the one defined for the USER or for the SITE
1508: -- Calling fnd_profile.get_specific with the resp_id and app_resp_id
1509: -- taken from ICX_SESSIONS given the session_id.
1510: -- AMGONZAL
1511: l_profile_defined := false;
1512: fnd_profile.get_specific(

Line 1512: fnd_profile.get_specific(

1508: -- Calling fnd_profile.get_specific with the resp_id and app_resp_id
1509: -- taken from ICX_SESSIONS given the session_id.
1510: -- AMGONZAL
1511: l_profile_defined := false;
1512: fnd_profile.get_specific(
1513: name_z => 'ICX_SESSION_TIMEOUT',
1514: user_id_z => l_user_id,
1515: responsibility_id_z => l_resp_id,
1516: application_id_z => l_app_resp_id,

Line 1790: fnd_profile.get_specific(

1786: l_multi_org_flag := MO_UTILS.Get_Multi_Org_Flag;
1787:
1788: if l_multi_org_flag = 'Y'
1789: then
1790: fnd_profile.get_specific(
1791: name_z => 'ORG_ID',
1792: responsibility_id_z => p_responsibility_id,
1793: application_id_z => p_application_id,
1794: val_z => l_org_id,

Line 1810: fnd_profile.get_specific(

1806: from icx_sessions
1807: where session_id = p_session_id;
1808:
1809:
1810: fnd_profile.get_specific(
1811: name_z => 'ICX_SESSION_TIMEOUT',
1812: user_id_z => l_user_id,
1813: responsibility_id_z => p_responsibility_id,
1814: application_id_z => p_application_id,

Line 1981: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');

1977: select login_id into l_login_id
1978: from ICX_SESSIONS
1979: where SESSION_ID = c_session_id;
1980:
1981: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');
1982: if (l_audit_level is not null) and ( l_login_id is not null)
1983: then
1984: fnd_signon.audit_end(l_login_id); -- end audit session and resps.
1985: end if;

Line 2059: fnd_profile.get_specific(name_z => 'ICX_LANGUAGE',

2055: l_language := null;
2056: end;
2057: end if;
2058: if l_language is null then
2059: fnd_profile.get_specific(name_z => 'ICX_LANGUAGE',
2060: user_id_z => l_user_id,
2061: val_z => l_language,
2062: defined_z => l_profile_defined);
2063:

Line 2077: fnd_profile.get_specific(name_z => 'ICX_NLS_SORT',

2073: end if;
2074:
2075: -- The following Profiles should be set
2076:
2077: fnd_profile.get_specific(name_z => 'ICX_NLS_SORT',
2078: user_id_z => l_user_id,
2079: val_z => l_nls_sort,
2080: defined_z => l_profile_defined);
2081:

Line 2087: fnd_profile.get_specific(name_z => 'ICX_DATE_FORMAT_MASK',

2083: then
2084: l_nls_sort:=getNLS_PARAMETER('NLS_SORT');
2085: end if;
2086:
2087: fnd_profile.get_specific(name_z => 'ICX_DATE_FORMAT_MASK',
2088: user_id_z => l_user_id,
2089: val_z => l_date_format,
2090: defined_z => l_profile_defined);
2091:

Line 2117: fnd_profile.get_specific(name_z => 'ICX_NUMERIC_CHARACTERS',

2113: then
2114: l_date_language:=getNLS_PARAMETER('NLS_DATE_LANGUAGE');
2115: end if;
2116:
2117: fnd_profile.get_specific(name_z => 'ICX_NUMERIC_CHARACTERS',
2118: user_id_z => l_user_id,
2119: val_z => l_numeric_characters,
2120: defined_z => l_profile_defined);
2121:

Line 2127: fnd_profile.get_specific(name_z => 'ICX_TERRITORY',

2123: then
2124: l_numeric_characters:=getNLS_PARAMETER('NLS_NUMERIC_CHARACTERS');
2125: end if;
2126:
2127: fnd_profile.get_specific(name_z => 'ICX_TERRITORY',
2128: user_id_z => l_user_id,
2129: val_z => l_nls_territory,
2130: defined_z => l_profile_defined);
2131:

Line 2137: fnd_profile.get_specific(name_z => 'ICX_LIMIT_TIME',

2133: then
2134: l_nls_territory:=getNLS_PARAMETER('NLS_TERRITORY');
2135: end if;
2136:
2137: fnd_profile.get_specific(name_z => 'ICX_LIMIT_TIME',
2138: user_id_z => l_user_id,
2139: val_z => l_limit_time,
2140: defined_z => l_profile_defined);
2141:

Line 2147: fnd_profile.get_specific(name_z => 'ICX_LIMIT_CONNECT',

2143: then
2144: l_limit_time := 4;
2145: end if;
2146:
2147: fnd_profile.get_specific(name_z => 'ICX_LIMIT_CONNECT',
2148: user_id_z => l_user_id,
2149: val_z => l_limit_connects,
2150: defined_z => l_profile_defined);
2151:

Line 2162: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',

2158: -- updateSessionContext
2159: -- check_session
2160: --
2161: /*
2162: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',
2163: user_id_z => p_user_id,
2164: val_z => l_timeout,
2165: defined_z => l_profile_defined);
2166: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',

Line 2166: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',

2162: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',
2163: user_id_z => p_user_id,
2164: val_z => l_timeout,
2165: defined_z => l_profile_defined);
2166: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',
2167: val => l_timeout);
2168: */
2169:
2170: /*

Line 2179: fnd_profile.get_specific(name_z => 'ORG_ID',

2175: */
2176: l_multi_org_flag := MO_UTILS.Get_Multi_Org_Flag;
2177:
2178: if l_multi_org_flag = 'Y' then
2179: fnd_profile.get_specific(name_z => 'ORG_ID',
2180: val_z => l_org_id,
2181: defined_z => l_profile_defined);
2182: end if;
2183: