TRIGGER: APPS.SSP_MED_T1

Source

Description

ssp_med_t1
AFTER INSERT OR DELETE OR UPDATE
OF ACCEPT_LATE_EVIDENCE_FLAG
,  EVIDENCE_RECEIVED_DATE
,  EVIDENCE_STATUS
ON SSP_MEDICALS
FOR EACH ROW

Type

AFTER EACH ROW

Event

INSERT OR UPDATE OR DELETE

Column

When

(old.evidence_status = 'CURRENT'
         or new.evidence_status = 'CURRENT')

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
    ssp_smp_pkg.medical_control (nvl (:old.maternity_id,:new.maternity_id));
    ssp_ssp_pkg.medical_control (nvl (:old.absence_attendance_id,
                                      :new.absence_attendance_id));
  end if;
end if;
END;