937: fetch c3 into l_dummy ;
938: if c3%found then
939: close c3 ;
940: -- ER FPT
941: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
942: hr_utility.set_location('Calling reverse_term_apln_fut', 105);
943: reverse_term_apln_fut ( p_effective_date
944: ,p_business_group_id
945: ,p_assignment_id
11071: -- insert the profile options and effective date for the flexfield
11072: -- validation to work
11073: --
11074: if g_debug then
11075: hr_utility.set_location('EMP Asg B Profile:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
11076: hr_utility.set_location('EMP Asg l_organization_id:' || l_organization_id, 13163);
11077: end if;
11078: hr_kflex_utility.set_profiles
11079: (p_business_group_id => l_business_group_id
11085: hr_kflex_utility.set_session_date
11086: (p_effective_date => l_effective_date
11087: ,p_session_id => l_session_id);
11088: if g_debug then
11089: hr_utility.set_location('EMP Asg A Profile:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
11090: end if;
11091: --
11092: -- Bug 944911
11093: -- Added to next 2 ifs check for p_concatenated_segments also
11260: --
11261: -- Start of fix for Bug 2622747
11262: --
11263: if g_debug then
11264: hr_utility.set_location('EMP Asg B V_SCL:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
11265: end if;
11266: validate_SCL (
11267: p_validate => FALSE --Changed from p_validate to false for fix of #3180527
11268: ,p_assignment_id => p_assignment_id
11304: );
11305: --End of fix for Bug 2622747
11306: --
11307: if g_debug then
11308: hr_utility.set_location('EMP Asg A V_SCL:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
11309: end if;
11310: if g_debug then
11311: hr_utility.set_location(l_proc, 23);
11312: end if;
11402: --
11403: -- Update assignment.
11404: --
11405: if g_debug then
11406: hr_utility.set_location('EMP Asg B UPD:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
11407: end if;
11408: per_asg_upd.upd
11409: (p_assignment_id => p_assignment_id
11410: ,p_effective_start_date => l_effective_start_date
11493: ,p_supervisor_assignment_id => p_supervisor_assignment_id
11494: );
11495: --
11496: if g_debug then
11497: hr_utility.set_location('EMP Asg A UPD:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
11498: end if;
11499: if g_debug then
11500: hr_utility.set_location(l_proc, 25);
11501: end if;
11698: (p_session_id => l_session_id);
11699: --
11700: if g_debug then
11701: hr_utility.set_location(' Leaving:'||l_proc, 30);
11702: hr_utility.set_location('EMP Asg Leaving:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
11703: end if;
11704: exception
11705: when hr_api.validate_enabled then
11706: --