CREATE OR REPLACE TRIGGER "ACADEMIC"."AFT_UPD_COURSEPOINTCHANGE" AFTER UPDATE ON "ACADEMIC"."COMPLETECOURSEPOINTCHANGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (
NEW.APPROVALSTATUS='Y'
      )
BEGIN
  UPDATE COMPLETECOURSEPOINT SET INDEXPOINT=:OLD.INDEXPOINT, UPDATEBY=:OLD.UPDATEBY, UPDATETIME=SYSDATE, COUNCILDATE=:OLD.COUNCILDATE, ACTIVESTATUS=:OLD.ACTIVESTATUS WHERE STUDENTID=:OLD.STUDENTID AND SUBJECTID=:OLD.SUBJECTID AND SUBJECTCODE=:OLD.SUBJECTCODE AND STUDYPROGRAMID=:OLD.STUDYPROGRAMID AND SCHOOLYEAR=:OLD.SCHOOLYEAR AND SEMESTER=:OLD.SEMESTER;
-- AND NVL(INDEXPOINT,'-')=NVL(:OLD.LASTINDEX,'-');

    INSERT INTO LOGOFSCORE (STUDENTID,
    SCHOOLYEAR,
    SEMESTER,
    SUBJECTCODE,
    TAKENTO,
    "INDEX",
    "USER",
    INPUTDATE,
    OPERATION,
    LASTINDEX,
    NOTE,
    COUNCILDATE,
    SUBJECTID,
    STUDYPROGRAMID) VALUES(:OLD.STUDENTID,
    :OLD.SCHOOLYEAR,
    :OLD.SEMESTER,
    :OLD.SUBJECTCODE,
    '\N',
    :OLD.INDEXPOINT,
    :OLD.UPDATEBY,
    SYSDATE,
    :OLD.OPERATION,
    :OLD.LASTINDEX,
    :OLD.NOTE,
    :OLD.COUNCILDATE,
    :OLD.SUBJECTID,
    :OLD.STUDYPROGRAMID);
END;