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 3769: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);

3765: --
3766: fetch c1 into l_business_group_id;
3767: if c1%found then
3768: --
3769: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_business_group_id);
3770: --
3771: end if;
3772: --
3773: close c1;

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

4457: l_proc VARCHAR2(72) := g_package||'get_operating_unit';
4458: l_operating_unit_id number;
4459:
4460: cursor ou_person is
4461: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4462: from hr_organization_information HOI
4463: , per_all_assignments_f PAAF
4464: where HOI.organization_id = PAAF.organization_id
4465: and PAAF.person_id = p_person_id

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

4468: and PAAF.primary_flag = 'Y'
4469: and HOI.org_information_context='Exp Organization Defaults';
4470: --
4471: cursor ou_assignment is
4472: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4473: from hr_organization_information HOI
4474: , per_all_assignments_f PAAF
4475: where HOI.organization_id = PAAF.organization_id
4476: and PAAF.assignment_id = p_assignment_id

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

4478: PAAF.effective_start_date and PAAF.effective_end_date
4479: and HOI.org_information_context='Exp Organization Defaults';
4480: --
4481: cursor ou_organization is
4482: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4483: from hr_organization_information HOI
4484: where HOI.organization_id = p_organization_id
4485: and HOI.org_information_context='Exp Organization Defaults';
4486: --

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

4525: if ou_person%notfound then
4526:
4527: hr_utility.set_location(l_proc, 50);
4528:
4529: l_operating_unit_id := nvl(fnd_profile.value('ORG_ID'),-99);
4530:
4531: end if;
4532: close ou_person;
4533:

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

4542: if ou_assignment%notfound then
4543:
4544: hr_utility.set_location(l_proc, 80);
4545:
4546: l_operating_unit_id := nvl(fnd_profile.value('ORG_ID'),-99);
4547:
4548: end if;
4549: close ou_assignment;
4550:

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

4556: if ou_organization%notfound then
4557:
4558: hr_utility.set_location(l_proc, 100);
4559:
4560: l_operating_unit_id := nvl(fnd_profile.value('ORG_ID'),-99);
4561:
4562: end if;
4563: close ou_organization;
4564: