334: l_person_id number;
335: --
336: begin
337: --
338: open get_sec_person_id(hr_security.get_security_profile);
339: fetch get_sec_person_id into l_person_id;
340: close get_sec_person_id;
341: if l_person_id is null then
342: open get_user_person_id(fnd_global.user_id);
1204:
1205:
1206: -- 3952978
1207: --
1208: -- Mark HR Security cache as invalid. The next time a secure view
1209: -- is accessed - cache will be rebuilt. This is the equivalent of
1210: -- code calling fnd_global.apps_initialize but where the HR signon
1211: -- callback is not called - ie user/resp/sc context has not changed.
1212: --