DBA Data[Home] [Help]

APPS.HR_COMPETENCE_ELEMENT_API dependencies on OTA_GENERAL

Line 2611: ota_general.value_changed(p_old_start_date,p_start_date);

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;

Line 2613: ota_general.value_changed(p_old_end_date,p_end_date);

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;

Line 2719: If not ota_general.value_changed(p_old_start_date,v_start_date) Then

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;

Line 2729: If not ota_general.value_changed(p_old_end_date,v_end_date) Then

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;