2607: l_sd_changed varchar2 (20) := 'N';
2608: l_ed_changed varchar2 (20) := 'N';
2609:
2610: l_start_date_changed boolean :=
2611: ota_general.value_changed(p_old_start_date,p_start_date);
2612: l_end_date_changed boolean :=
2613: ota_general.value_changed(p_old_end_date,p_end_date);
2614: --
2615: v_competence_element_id number;
2609:
2610: l_start_date_changed boolean :=
2611: ota_general.value_changed(p_old_start_date,p_start_date);
2612: l_end_date_changed boolean :=
2613: ota_general.value_changed(p_old_end_date,p_end_date);
2614: --
2615: v_competence_element_id number;
2616: v_object_version_number number;
2617: v_start_date date;
2715: --
2716: -- If the old start date is the same as the cel start date then need to
2717: -- update to the new date
2718: --
2719: If not ota_general.value_changed(p_old_start_date,v_start_date) Then
2720: l_start_date := greatest(p_start_date
2721: ,nvl(v_competence_date_from,hr_api.g_sot));
2722: Else
2723: l_start_date := hr_api.g_date;
2725: --
2726: -- If the old end date is the same as the cel end date then need to
2727: -- update to the new date
2728: --
2729: If not ota_general.value_changed(p_old_end_date,v_end_date) Then
2730: l_end_date := least(p_end_date
2731: ,nvl(v_competence_date_to,hr_api.g_eot));
2732: Else
2733: l_end_date := hr_api.g_date;