761: hr_utility.trace('l_max_date_from : '|| l_max_date_from);
762:
763: if l_max_date_from is not NULL then
764: hr_utility.set_location(l_proc, 75);
765: hr_competence_element_api.update_competence_element
766: (p_effective_date => l_effective_date
767: ,p_competence_element_id => l_competence_element_id
768: ,p_status => 'ACHIEVED'
769: ,p_achieved_date => l_max_date_from
772: );
773: else
774: --
775: hr_utility.set_location(l_proc, 76);
776: hr_competence_element_api.update_competence_element
777: (p_effective_date => l_effective_date
778: ,p_competence_element_id => l_competence_element_id
779: ,p_status => 'IN_PROGRESS'
780: ,p_achieved_date => NULL
899:
900: hr_utility.set_location(l_proc, 20);
901:
902: --
903: -- Saved competence_id for calling hr_competence_element api
904: --
905: hr_utility.trace('p_outcome_id : '|| p_outcome_id);
906: select competence_id into l_competence_id
907: from per_competence_outcomes
967:
968: hr_utility.trace('l_max_date_from : '|| l_max_date_from);
969: if (l_max_date_from is not NULL) then
970: hr_utility.set_location(l_proc, 60);
971: hr_competence_element_api.update_competence_element
972: (p_effective_date => sysdate
973: ,p_competence_element_id => l_competence_element_id
974: ,p_status => 'ACHIEVED'
975: ,p_achieved_date => l_max_date_from