TRIGGER: APPS.SSP_ABA_T1

Source

Description

SSP_ABA_T1
BEFORE INSERT
ON PER_ABSENCE_ATTENDANCES
FOR EACH ROW

Type

BEFORE EACH ROW

Event

INSERT

Column

When

new.sickness_start_date is not null
    

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
BEGIN
if hr_general.g_data_migrator_mode <> 'Y' then
  if ssp_ssp_pkg.ssp_is_installed then
    :new.linked_absence_id := ssp_ssp_pkg.linked_absence_id (
  	p_person_id => :new.person_id,
  	p_sickness_start_date => :new.sickness_start_date,
  	p_sickness_end_date => :new.sickness_end_date);
  end if;
end if;
END;