APPS.HR_CONTINGENT_WORKER_API dependencies on FND_PROFILE

Line 1253: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then

1249: hr_utility.set_location(l_proc, 30);
1250: --
1251: -- Check for future person_type_changes
1252: --
1253: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
1254:
1255: if hr_person.fpt_check_ft_person_type(l_per_details_rec.system_person_type
1256: ,p_person_id
1257: ,l_per_details_rec.business_group_id

Line 1948: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

1944: from per_events pe
1945: , per_bookings pb
1946: where pe.business_group_id = pb.business_group_id
1947: and (pb.business_group_id = p_business_group_id OR
1948: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1949: and pe.event_id = pb.event_id
1950: and pe.event_or_interview = 'E'
1951: and pb.person_id = p_person_id
1952: and pe.date_start > p_session_date

Line 1980: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

1976: from per_events pe
1977: ,per_bookings pb
1978: where pe.business_group_id = pb.business_group_id
1979: and (pb.business_group_id = p_business_group_id OR
1980: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1981: and pe.event_id = pb.event_id
1982: and pe.event_or_interview = 'I'
1983: and pb.person_id = p_person_id
1984: and pe.date_start > p_session_date

Line 2022: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

2018: from per_vacancies pv
2019: where
2020: -- Fix for bug 3446782. This condition exists in the view.
2021: /*(pv.business_group_id = p_business_group_id OR
2022: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2023: and */
2024: pv.recruiter_id = p_person_id
2025: and nvl(pv.date_to, p_session_date) >= p_session_date);
2026: p_status := 'WARNING';

Line 2284: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then

2280: --
2281: if csr_future_per_changes%FOUND
2282: then
2283: --
2284: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
2285: open csr_fpt_ptu_changes;
2286: fetch csr_fpt_ptu_changes into l_exists;
2287: if csr_fpt_ptu_changes%found then
2288: hr_utility.set_location(l_proc, 75);

Line 3821: (fpt_rec.system_person_type in ('APL','EX_APL') and (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'N')) then

3817: -- commented out the if condition and redifined it
3818: -- if fpt_rec.system_person_type <> 'EX_CWK' then
3819: -- ER FPT
3820: if fpt_rec.system_person_type in ('EMP','CWK') or
3821: (fpt_rec.system_person_type in ('APL','EX_APL') and (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'N')) then
3822: b_future_person_type_err := TRUE;
3823: end if;
3824:
3825: end loop;