APPS.HR_ORGANIZATION_API dependencies on FND_PROFILE

Line 377: l_security_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');

373: );
374: --
375: hr_utility.set_location(l_proc, 30);
376: --
377: l_security_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');
378: -- Bug fix 4329807
379: /* open csr_sec_profile( l_security_profile_id );
380: fetch csr_sec_profile into l_view_all_orgs;
381: close csr_sec_profile;

Line 3090: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);

3086: --
3087: fetch c1 into l_business_group_id;
3088: if c1%found then
3089: --
3090: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);
3091: --
3092: end if;
3093: --
3094: close c1;

Line 3753: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);

3749: --
3750: fetch c1 into l_business_group_id;
3751: if c1%found then
3752: --
3753: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);
3754: --
3755: end if;
3756: --
3757: close c1;

Line 4407: select nvl(org_information1,fnd_profile.value('ORG_ID'))

4403: l_proc VARCHAR2(72) := g_package||'get_operating_unit';
4404: l_operating_unit_id number;
4405:
4406: cursor ou_person is
4407: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4408: from hr_organization_information HOI
4409: , per_all_assignments_f PAAF
4410: where HOI.organization_id = PAAF.organization_id
4411: and PAAF.person_id = p_person_id

Line 4418: select nvl(org_information1,fnd_profile.value('ORG_ID'))

4414: and PAAF.primary_flag = 'Y'
4415: and HOI.org_information_context='Exp Organization Defaults';
4416: --
4417: cursor ou_assignment is
4418: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4419: from hr_organization_information HOI
4420: , per_all_assignments_f PAAF
4421: where HOI.organization_id = PAAF.organization_id
4422: and PAAF.assignment_id = p_assignment_id

Line 4428: select nvl(org_information1,fnd_profile.value('ORG_ID'))

4424: PAAF.effective_start_date and PAAF.effective_end_date
4425: and HOI.org_information_context='Exp Organization Defaults';
4426: --
4427: cursor ou_organization is
4428: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4429: from hr_organization_information HOI
4430: where HOI.organization_id = p_organization_id
4431: and HOI.org_information_context='Exp Organization Defaults';
4432: --

Line 4475: l_operating_unit_id := nvl(fnd_profile.value('ORG_ID'),-99);

4471: if ou_person%notfound then
4472:
4473: hr_utility.set_location(l_proc, 50);
4474:
4475: l_operating_unit_id := nvl(fnd_profile.value('ORG_ID'),-99);
4476:
4477: end if;
4478: close ou_person;
4479:

Line 4492: l_operating_unit_id := nvl(fnd_profile.value('ORG_ID'),-99);

4488: if ou_assignment%notfound then
4489:
4490: hr_utility.set_location(l_proc, 80);
4491:
4492: l_operating_unit_id := nvl(fnd_profile.value('ORG_ID'),-99);
4493:
4494: end if;
4495: close ou_assignment;
4496:

Line 4506: l_operating_unit_id := nvl(fnd_profile.value('ORG_ID'),-99);

4502: if ou_organization%notfound then
4503:
4504: hr_utility.set_location(l_proc, 100);
4505:
4506: l_operating_unit_id := nvl(fnd_profile.value('ORG_ID'),-99);
4507:
4508: end if;
4509: close ou_organization;
4510: