DBA Data[Home] [Help]

APPS.FND_SESSION_MANAGEMENT dependencies on FND_PROFILE

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

285: THEN
286: BEGIN
287:
288: -- bug:7715927
289: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');
290:
291: IF (l_audit_level is not null) THEN
292: FOR end_date_rec in c_end_date_fndlogins LOOP
293: fnd_signon.audit_end(l_login_id); -- end date FND_LOGINS

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

331: lm_key varchar2(40);
332: l_fixed_key varchar2(10);
333: l_profile_defined boolean;
334: begin
335: fnd_profile.get_specific(name_z => 'FND_FIXED_KEY_ENABLED',
336: user_id_z => p_user_id,
337: val_z => l_fixed_key,
338: defined_z => l_profile_defined);
339: if(l_fixed_key = 'Y') then

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

336: user_id_z => p_user_id,
337: val_z => l_fixed_key,
338: defined_z => l_profile_defined);
339: if(l_fixed_key = 'Y') then
340: fnd_profile.get_specific(name_z => 'FND_FIXED_SEC_KEY',
341: user_id_z => p_user_id,
342: val_z => lf_key,
343: defined_z => l_profile_defined);
344:

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

418: --
419:
420: -- There are not responsibility_id and app_resp_id defined.
421: l_profile_defined := false;
422: fnd_profile.get_specific (name_z => 'ICX_SESSION_TIMEOUT',
423: user_id_z => p_user_id,
424: val_z => l_timeout,
425: defined_z => l_profile_defined);
426: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 461: -- fnd_profile.get_specific

457:
458: l_XSID := NewXSID;
459:
460: -- Is user GUEST
461: -- fnd_profile.get_specific
462: -- (name_z => 'GUEST_USER_PWD',
463: -- val_z => l_guest_username ,
464: -- defined_z => l_profile_defined);
465: -- Using new api to retrieve GUEST credentials.

Line 486: fnd_profile.get_specific

482: else
483: l_guest := 'N';
484: end if;
485:
486: fnd_profile.get_specific
487: (name_z => 'DISTRIBUTED_ENVIRONMENT',
488: val_z => l_dist,
489: defined_z => l_profile_defined);
490:

Line 733: -- fnd_profile.get_specific

729: return 'N';
730: end if;
731:
732: -- check if switched-to user is GUEST
733: -- fnd_profile.get_specific
734: -- (name_z => 'GUEST_USER_PWD',
735: -- val_z => l_guest_username ,
736: -- defined_z => l_profile_defined);
737: -- Using new api to retrieve GUEST credentials.

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

771: -- Bug 5354477 amgonzal
772: -- Finding the ICX_SESSION_TIMEOUT for the user session being converted
773: --
774: l_profile_defined := false;
775: fnd_profile.get_specific (name_z => 'ICX_SESSION_TIMEOUT',
776: user_id_z => p_user_id,
777: responsibility_id_z => l_resp_id,
778: application_id_z => l_resp_app_id,
779: val_z => l_profile_timeout,

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

812:
813: -- Bug 6010245 Guest Login is not being end dated in FND_LOGINS.
814: -- AMGONZAL.
815:
816: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');
817: if (l_audit_level is not null) and ( l_from_login_id is not null) then
818: fnd_signon.audit_end(l_from_login_id); -- end guest audit session and resps.
819: end if;
820:

Line 1177: fnd_profile.get_specific

1173: l_multi_org_flag := MO_UTILS.Get_Multi_Org_Flag;
1174:
1175: if l_multi_org_flag = 'Y'
1176: then
1177: fnd_profile.get_specific
1178: (name_z => 'ORG_ID',
1179: responsibility_id_z => fnd_session_management.g_responsibility_id,
1180: application_id_z => fnd_session_management.g_resp_appl_id,
1181: val_z => fnd_session_management.g_org_id,

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

1181: val_z => fnd_session_management.g_org_id,
1182: defined_z => l_profile_defined);
1183: end if;
1184:
1185: fnd_profile.get(name => 'ICX_PREFIX',
1186: val => l_prefix);
1187:
1188: if (l_prefix IS NOT NULL)
1189: then

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

1540: -- Finding first new possible ICX_SESSION_TIMEOUT value
1541: /*
1542: -- added changes for bug#3951647
1543:
1544: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',
1545: val => l_timeout);
1546: Session_update_timeout_pvt(p_session_id, l_timeout);
1547:
1548: -- end changes for bug #3951647

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

1552: -- Most of the times fnd_session_management.check_session is called with no
1553: -- values for p_resp_id and p_app_resp_id
1554: -- Then, if passed p_resp_id and p_app_resp_id the ICX_SESSION_TIMEOUT
1555: -- value returned will the one defined for the USER or for the SITE
1556: -- Calling fnd_profile.get_specific with the resp_id and app_resp_id
1557: -- taken from ICX_SESSIONS given the session_id.
1558: -- AMGONZAL
1559: l_profile_defined := false;
1560: fnd_profile.get_specific(

Line 1560: fnd_profile.get_specific(

1556: -- Calling fnd_profile.get_specific with the resp_id and app_resp_id
1557: -- taken from ICX_SESSIONS given the session_id.
1558: -- AMGONZAL
1559: l_profile_defined := false;
1560: fnd_profile.get_specific(
1561: name_z => 'ICX_SESSION_TIMEOUT',
1562: user_id_z => l_user_id,
1563: responsibility_id_z => l_resp_id,
1564: application_id_z => l_app_resp_id,

Line 1838: fnd_profile.get_specific(

1834: l_multi_org_flag := MO_UTILS.Get_Multi_Org_Flag;
1835:
1836: if l_multi_org_flag = 'Y'
1837: then
1838: fnd_profile.get_specific(
1839: name_z => 'ORG_ID',
1840: responsibility_id_z => p_responsibility_id,
1841: application_id_z => p_application_id,
1842: val_z => l_org_id,

Line 1858: fnd_profile.get_specific(

1854: from icx_sessions
1855: where session_id = p_session_id;
1856:
1857:
1858: fnd_profile.get_specific(
1859: name_z => 'ICX_SESSION_TIMEOUT',
1860: user_id_z => l_user_id,
1861: responsibility_id_z => p_responsibility_id,
1862: application_id_z => p_application_id,

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

2029: select login_id into l_login_id
2030: from ICX_SESSIONS
2031: where SESSION_ID = c_session_id;
2032:
2033: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');
2034: if (l_audit_level is not null) and ( l_login_id is not null)
2035: then
2036: fnd_signon.audit_end(l_login_id); -- end audit session and resps.
2037: end if;

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

2107: l_language := null;
2108: end;
2109: end if;
2110: if l_language is null then
2111: fnd_profile.get_specific(name_z => 'ICX_LANGUAGE',
2112: user_id_z => l_user_id,
2113: val_z => l_language,
2114: defined_z => l_profile_defined);
2115:

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

2125: end if;
2126:
2127: -- The following Profiles should be set
2128:
2129: fnd_profile.get_specific(name_z => 'ICX_NLS_SORT',
2130: user_id_z => l_user_id,
2131: val_z => l_nls_sort,
2132: defined_z => l_profile_defined);
2133:

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

2135: then
2136: l_nls_sort:=getNLS_PARAMETER('NLS_SORT');
2137: end if;
2138:
2139: fnd_profile.get_specific(name_z => 'ICX_DATE_FORMAT_MASK',
2140: user_id_z => l_user_id,
2141: val_z => l_date_format,
2142: defined_z => l_profile_defined);
2143:

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

2165: then
2166: l_date_language:=getNLS_PARAMETER('NLS_DATE_LANGUAGE');
2167: end if;
2168:
2169: fnd_profile.get_specific(name_z => 'ICX_NUMERIC_CHARACTERS',
2170: user_id_z => l_user_id,
2171: val_z => l_numeric_characters,
2172: defined_z => l_profile_defined);
2173:

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

2175: then
2176: l_numeric_characters:=getNLS_PARAMETER('NLS_NUMERIC_CHARACTERS');
2177: end if;
2178:
2179: fnd_profile.get_specific(name_z => 'ICX_TERRITORY',
2180: user_id_z => l_user_id,
2181: val_z => l_nls_territory,
2182: defined_z => l_profile_defined);
2183:

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

2185: then
2186: l_nls_territory:=getNLS_PARAMETER('NLS_TERRITORY');
2187: end if;
2188:
2189: fnd_profile.get_specific(name_z => 'ICX_LIMIT_TIME',
2190: user_id_z => l_user_id,
2191: val_z => l_limit_time,
2192: defined_z => l_profile_defined);
2193:

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

2195: then
2196: l_limit_time := 4;
2197: end if;
2198:
2199: fnd_profile.get_specific(name_z => 'ICX_LIMIT_CONNECT',
2200: user_id_z => l_user_id,
2201: val_z => l_limit_connects,
2202: defined_z => l_profile_defined);
2203:

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

2210: -- updateSessionContext
2211: -- check_session
2212: --
2213: /*
2214: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',
2215: user_id_z => p_user_id,
2216: val_z => l_timeout,
2217: defined_z => l_profile_defined);
2218: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',

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

2214: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',
2215: user_id_z => p_user_id,
2216: val_z => l_timeout,
2217: defined_z => l_profile_defined);
2218: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',
2219: val => l_timeout);
2220: */
2221:
2222: /*

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

2227: */
2228: l_multi_org_flag := MO_UTILS.Get_Multi_Org_Flag;
2229:
2230: if l_multi_org_flag = 'Y' then
2231: fnd_profile.get_specific(name_z => 'ORG_ID',
2232: val_z => l_org_id,
2233: defined_z => l_profile_defined);
2234: end if;
2235:

Line 2335: fnd_profile.get_specific(name_z => 'APPS_SSO_LIMIT_SESSIONS',

2331: select user_guid into l_user_guid from fnd_user where user_id = l_user_id;
2332:
2333: if (l_user_guid is not null) then
2334: -- Could have an SSO session - if so disable if profile is set to limit
2335: fnd_profile.get_specific(name_z => 'APPS_SSO_LIMIT_SESSIONS',
2336: user_id_z => l_user_id,
2337: val_z => l_limit_sessions,
2338: defined_z => l_profile_defined);
2339: