APPS.PER_QH_TIMELINE dependencies on HR_API

Line 943: l_primary_key:=NVL(p_person_id,hr_api.g_number);

939: hr_utility.set_location(l_proc,110);
940: --
941: if ((l_table='PER_ALL_PEOPLE_F') or (l_table='PER_PERSON_TYPE_USAGES_F')) then
942: l_primary_key_name:='PERSON_ID';
943: l_primary_key:=NVL(p_person_id,hr_api.g_number);
944: else
945: l_primary_key_name:='ASSIGNMENT_ID';
946: l_primary_key:=NVL(p_assignment_id,hr_api.g_number);
947: end if;

Line 946: l_primary_key:=NVL(p_assignment_id,hr_api.g_number);

942: l_primary_key_name:='PERSON_ID';
943: l_primary_key:=NVL(p_person_id,hr_api.g_number);
944: else
945: l_primary_key_name:='ASSIGNMENT_ID';
946: l_primary_key:=NVL(p_assignment_id,hr_api.g_number);
947: end if;
948:
949: l_select_stmt:=l_select_stmt||'
950: ,to_char(effective_start_date,''J'')

Line 991: if( nvl(val_new,hr_api.g_varchar2)<>nvl(val_old,hr_api.g_varchar2) ) then

987: val_new:=l_date_rec.value;
988: --
989: hr_utility.set_location(l_proc,140);
990: --
991: if( nvl(val_new,hr_api.g_varchar2)<>nvl(val_old,hr_api.g_varchar2) ) then
992: --
993: hr_utility.set_location(l_proc,150);
994: --
995: records(i).start_date:=date_start;