APPS.HR_UTIL_MISC_SS dependencies on FND_GLOBAL

Line 12: WHERE ppf.person_id = fnd_global.employee_id

8: l_proc constant varchar2(100) := g_package || ' initLoginPrsnCtx';
9: CURSOR c_bg IS
10: SELECT business_group_id, nvl(org_information10,'USD') currency_code
11: FROM per_people_f ppf, hr_organization_information oi
12: WHERE ppf.person_id = fnd_global.employee_id
13: AND ppf.business_group_id = oi.organization_id
14: AND oi.org_information_context = 'Business Group Information'
15: AND g_eff_date between ppf.effective_start_date and ppf.effective_end_date;
16: BEGIN

Line 342: open get_user_person_id(fnd_global.user_id);

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);
343: fetch get_user_person_id into l_person_id;
344: close get_user_person_id;
345: end if;
346: --

Line 904: if (l_number_value = fnd_global.employee_id) then

900: itemtype => itemtype,
901: itemkey => itemkey,
902: aname => 'CURRENT_PERSON_ID');
903:
904: if (l_number_value = fnd_global.employee_id) then
905: dummy := 'Y';
906: end if;
907:
908: if (dummy = 'Y') then

Line 1210: -- code calling fnd_global.apps_initialize but where the HR signon

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: --
1213:
1214: if ( nvl(fnd_profile.value('HR_SEC_INIT_AM'),'N') = 'Y')

Line 1230: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN

1226: BEGIN
1227:
1228: l_enableSecGroups := nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N');
1229:
1230: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN
1231: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);
1232: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN
1233: fnd_profile.put('ENABLE_SECURITY_GROUPS', l_enableSecGroups);
1234: END IF;

Line 1269: --FND_GLOBAL.set_security_group_id_context(l_secGrpId);

1265: where security_group_key = p_bgId;
1266:
1267: fnd_client_info.set_security_group_context(to_char(l_secGrpId));
1268: -- Fix for bug 5531282 , this reverts the earlier fix for bug 5084537
1269: --FND_GLOBAL.set_security_group_id_context(l_secGrpId);
1270:
1271: EXCEPTION When Others then
1272: fnd_client_info.set_security_group_context(to_char(l_secGrpId));
1273: -- Fix for bug 5531282 , this reverts the earlier fix for bug 5084537

Line 1274: -- FND_GLOBAL.set_security_group_id_context(l_secGrpId);

1270:
1271: EXCEPTION When Others then
1272: fnd_client_info.set_security_group_context(to_char(l_secGrpId));
1273: -- Fix for bug 5531282 , this reverts the earlier fix for bug 5084537
1274: -- FND_GLOBAL.set_security_group_id_context(l_secGrpId);
1275: END;
1276: END IF;
1277:
1278: EXCEPTION

Line 1418: decode(fnd_global.employee_id,p_person_id,

1414: -- This logic for SSHR Manager Self-Service fucntion and for Appraisal Manager Fucntion
1415: IF (l_func_name <> l_param_name) OR (l_appr_index > 0 ) OR (l_ghr_index > 0)THEN
1416: begin
1417: select decode(fnd_profile.value('ENABLE_SECURITY_GROUPS'), 'Y' , p_bg_id,
1418: decode(fnd_global.employee_id,p_person_id,
1419: nvl(
1420: decode( FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1421: ,null,fnd_profile.value('PER_BUSINESS_GROUP_ID'),
1422: FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)

Line 1420: decode( FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)

1416: begin
1417: select decode(fnd_profile.value('ENABLE_SECURITY_GROUPS'), 'Y' , p_bg_id,
1418: decode(fnd_global.employee_id,p_person_id,
1419: nvl(
1420: decode( FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1421: ,null,fnd_profile.value('PER_BUSINESS_GROUP_ID'),
1422: FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1423: )
1424: ,p_bg_id

Line 1422: FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)

1418: decode(fnd_global.employee_id,p_person_id,
1419: nvl(
1420: decode( FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1421: ,null,fnd_profile.value('PER_BUSINESS_GROUP_ID'),
1422: FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1423: )
1424: ,p_bg_id
1425: ),p_bg_id)) into l_bg_id from dual;
1426: end;