36: -- 2086208. Cache the value of ICX_SEC.G_SESSION_ID so that the
37: -- person list can be rebuilt on a change of login session even if
38: -- the user,resp,sec group remain the same. An alternative scheme is
39: -- to track session switching based on the value of
40: -- FND_GLOBAL.SESSION_CONTEXT. This would cause the person list to
41: -- be rebuilt on each call to FND_GLOBAL.APPS_INITIALIZE.
42: --
43: g_icx_session_id NUMBER := 0 ;
44:
37: -- person list can be rebuilt on a change of login session even if
38: -- the user,resp,sec group remain the same. An alternative scheme is
39: -- to track session switching based on the value of
40: -- FND_GLOBAL.SESSION_CONTEXT. This would cause the person list to
41: -- be rebuilt on each call to FND_GLOBAL.APPS_INITIALIZE.
42: --
43: g_icx_session_id NUMBER := 0 ;
44:
45:
381: FETCH csr_get_schema_mode into g_apps_schema_mode, g_org_id;
382: CLOSE csr_get_schema_mode;
383: --
384: l_security_profile_id:=hr_security.get_security_profile;
385: g_user_id:=fnd_global.user_id;
386: g_resp_id:=fnd_global.resp_id;
387: g_resp_appl_id:=fnd_global.resp_appl_id;
388: g_security_group_id:=fnd_global.security_group_id;
389:
382: CLOSE csr_get_schema_mode;
383: --
384: l_security_profile_id:=hr_security.get_security_profile;
385: g_user_id:=fnd_global.user_id;
386: g_resp_id:=fnd_global.resp_id;
387: g_resp_appl_id:=fnd_global.resp_appl_id;
388: g_security_group_id:=fnd_global.security_group_id;
389:
390: -- g_person_id:=get_person_id; -- Bug 2807573 see below
383: --
384: l_security_profile_id:=hr_security.get_security_profile;
385: g_user_id:=fnd_global.user_id;
386: g_resp_id:=fnd_global.resp_id;
387: g_resp_appl_id:=fnd_global.resp_appl_id;
388: g_security_group_id:=fnd_global.security_group_id;
389:
390: -- g_person_id:=get_person_id; -- Bug 2807573 see below
391: -- g_person_list.delete; --6012095(forward port of 5985232)
384: l_security_profile_id:=hr_security.get_security_profile;
385: g_user_id:=fnd_global.user_id;
386: g_resp_id:=fnd_global.resp_id;
387: g_resp_appl_id:=fnd_global.resp_appl_id;
388: g_security_group_id:=fnd_global.security_group_id;
389:
390: -- g_person_id:=get_person_id; -- Bug 2807573 see below
391: -- g_person_list.delete; --6012095(forward port of 5985232)
392:
676:
677: --
678: -- 2876315
679: --
680: if ( hr_signon.session_context <> fnd_global.session_context )
681: then
682: hr_signon.initialize_hr_security;
683: initialise_globals;
684: end if;
998: --- a change in the ICX session id causes the person list to be rebuilt.
999: --- Ideally this would be signalled via the product initialization code
1000: ---
1001:
1002: IF g_user_id <> fnd_global.user_id
1003: or g_resp_id <> fnd_global.resp_id
1004: or g_resp_appl_id <> fnd_global.resp_appl_id
1005: or g_security_group_id <> fnd_global.security_group_id
1006: or g_icx_session_id <> icx_sec.g_session_id
999: --- Ideally this would be signalled via the product initialization code
1000: ---
1001:
1002: IF g_user_id <> fnd_global.user_id
1003: or g_resp_id <> fnd_global.resp_id
1004: or g_resp_appl_id <> fnd_global.resp_appl_id
1005: or g_security_group_id <> fnd_global.security_group_id
1006: or g_icx_session_id <> icx_sec.g_session_id
1007: THEN
1000: ---
1001:
1002: IF g_user_id <> fnd_global.user_id
1003: or g_resp_id <> fnd_global.resp_id
1004: or g_resp_appl_id <> fnd_global.resp_appl_id
1005: or g_security_group_id <> fnd_global.security_group_id
1006: or g_icx_session_id <> icx_sec.g_session_id
1007: THEN
1008: l_return := TRUE;
1001:
1002: IF g_user_id <> fnd_global.user_id
1003: or g_resp_id <> fnd_global.resp_id
1004: or g_resp_appl_id <> fnd_global.resp_appl_id
1005: or g_security_group_id <> fnd_global.security_group_id
1006: or g_icx_session_id <> icx_sec.g_session_id
1007: THEN
1008: l_return := TRUE;
1009: ELSE
2299: l_org_id number;
2300:
2301: --
2302: -- Checks to see if there are any records in org_access for
2303: -- the current responsibility. fnd_global.resp_appl_id is used
2304: -- to improve index performance.
2305: --
2306: CURSOR c_chk_resp_in_org_access IS
2307: SELECT null
2311:
2312: --
2313: -- Returns a single record in org_access that matches the
2314: -- current responsibility and p_org_id (if one exists).
2315: -- fnd_global.resp_appl_id is used to improve index performance.
2316: --
2317: CURSOR c_get_org_access_org IS
2318: SELECT oa.organization_id
2319: FROM org_access oa
2647: FUNCTION get_sec_profile_bg_id
2648: RETURN NUMBER
2649: is
2650: begin
2651: if fnd_global.user_id <> -1 then
2652:
2653: if globals_need_refreshing then
2654: hr_signon.initialize_hr_security;
2655: initialise_globals;