CREATE OR REPLACE TRIGGER "OF_OWNER"."DEBUG_AFTER_WBS_UPDATE" AFTER
    UPDATE ON wbs
    FOR EACH ROW
BEGIN
    IF (NVL(:NEW.ref_number, 1) <> NVL(:old.ref_number, 1) OR NVL(:NEW.name, 1) <> NVL(:old.name, 1)) THEN
        INSERT INTO debug_wbs (
            "WBS_ID",
            "OPERATION_CENTER_ID",
            "NAME",
            "WBS_LEVEL",
            "EFFORT",
            "FROM_DATE",
            "TO_DATE",
            "DESCRIPTION",
            "PARENT_WBS_ID",
            "REF_NUMBER",
            "POI_ID",
            "VO_PERSON_CATEGORY_ID",
            "VEHICLE_ID",
            "POI_TIN",
            "BE_NAME",
            "BE_REF_NUMBER",
            "VEHICLE_OWNER_ID",
            "WBS_STATUS_ID",
            "OC_CALENDAR_ID",
            "PAUSE_MIN",
            "PAUSE_MORNING_MIN",
            "SHORT_DESCRIPTION",
            "IS_PROJECT",
            "WBS_TASK_TYPE_ID",
            "PLANNED_HR",
            "ORDER_NUM",
            "IS_WORK_TIME_REPORTED",
            "CAN_ASSIGN_TEAM",
            "SHORT_NAME",
            "LM_DATE",
            "WBS_PATH",
            "PERCENTAGE_COMPLETED",
            "PERCENTAGE_COMPLETED_DATE",
            "WORKING_SCHEDULE_ID",
            "HR_INPUT_FORMAT_ID",
            "VALIDATION_STATUS_ID",
            "EXPORT_TO_PAYROLL",
            "EXPORT_TO_PAYROLL_DAY_ID",
            "TRAJECT_CHECK_BOX",
            "TRANSPORT_CHECK_BOX",
            "MEAL_ALLOWANCE_CHECK_BOX",
            "LONG_DISTANCE_CHECK_BOX",
            "PAUSE_TAKEN_CHECK_BOX",
            "VEHICLE_ID_CHECK_BOX",
            "VEHICLE_KM_FIELD",
            "PRIVATE_KM_FIELD",
            "PRIVATE_VEHICLE_CHECK_BOX",
            "CUSTOMER_SIGNATURE_REQUESTED",
            "DEFAULT_TIME_SHEET_HRD",
            "PAUSE_TAKEN_DEFAULT_VALUE",
            "LM_NAME",
            "BICYCLE_KM_FIELD",
            "ON_FOOT_CHECK_BOX",
            "PUBLIC_TRANSPORT_CHECK_BOX",
            "ON_FOOT_KM_FIELD",
            "MAX_WORKED_HR_PER_ACTIVITY",
            "EXTERNAL_VALIDATION",
            "USE_DECL_WRK_LOC_AND_JOURNEY",
            "ERP_ID",
            "DISPLAY_PROJECT",
            "DISPLAY_SUB_PROJECT",
            "HRD_REP_ON_OC_POI_CATEGORY_ID",
            "IS_HRD_REPORTED_ON_ACTIVITY",
            "MAINTENANCE_CHECK_BOX",
            "LAUNDRY_CHECK_BOX",
            "DAY_JOURNEY_ROLE_COMBO",
            "USE_DEFAULT_VO_PARAMS",
            "PASSENGER_KM_FIELD",
            "DRIVER_KM_FIELD",
            "USE_TSL_WORK_LOCATION",
            "USE_TSL_DECLARED_VEHICLE",
            "USE_FREE_TEXT_REF_NUMBER",
            "LAUNDRY_IS_NEVER_PAID",
            "OBJECT_MODEL_ID",
            "TRANSPORT_DURATION_FIELD",
            "PAUSE_DURATION_FIELD",
            "WE_BLOCKED_FIELD",
            "VO_DIVISION_ID",
            "MAIN_CONTRACTOR_ID",
            "WAS_WORKING_LATE_CHECK_BOX",
            "MISSION_KM_FIELD",
            "OVERNIGHT_STAY_CHECK_BOX",
            "IS_CLONE_OF_WBS_ID",
            "ERP_ID2",
            "START_AND_STOP_TIME_FIELD",
            "USE_START_STOP_TIME_FOR_DAY_HRD",
            "HARD_WORK_CHECK_BOX",
            "DANGEROUS_WORK_CHECK_BOX",
            "INSALUBRITY_WORK_CHECK_BOX",
            "HEIGHT_WORK_CHECK_BOX",
            "LONG_DISTANCE_EXTRA_FIELD",
            "COMPANY_SITE_OC_POI_ID",
            "PLANNED_BUDGET",
            "ALLOW_PICTURE_ON_TSL",
            "NBR_PASSENGER_FIELD",
            "SUB_PAUSE_FROM_TOT_HR_WHEN_START_STOP_HIF",
            "REPORTED_HR",
            "REPORTED_BUDGET",
            "CLIENT_NAME",
            "PLANNED_TURNOVER",
            "IS_ALREADY_INVOICED",
            "WARNING_WHEN_REPORTING_HOURS",
            "TSL_DECLARED_VEH_MANDATORY",
            "OLD_WBS_ID",
            "OLD_REF_NUMBER",
            "LAST_MODIFIED_DATE",
            "CURRENT_USER",
            "OLD_NAME"
        ) VALUES (
            :NEW."WBS_ID",
            :NEW."OPERATION_CENTER_ID",
            :NEW."NAME",
            :old."WBS_LEVEL",
            :old."EFFORT",
            :old."FROM_DATE",
            :old."TO_DATE",
            :old."DESCRIPTION",
            :old."PARENT_WBS_ID",
            :NEW."REF_NUMBER",
            :old."POI_ID",
            :old."VO_PERSON_CATEGORY_ID",
            :old."VEHICLE_ID",
            :old."POI_TIN",
            :old."BE_NAME",
            :old."BE_REF_NUMBER",
            :old."VEHICLE_OWNER_ID",
            :old."WBS_STATUS_ID",
            :old."OC_CALENDAR_ID",
            :old."PAUSE_MIN",
            :old."PAUSE_MORNING_MIN",
            :old."SHORT_DESCRIPTION",
            :old."IS_PROJECT",
            :old."WBS_TASK_TYPE_ID",
            :old."PLANNED_HR",
            :old."ORDER_NUM",
            :old."IS_WORK_TIME_REPORTED",
            :old."CAN_ASSIGN_TEAM",
            :old."SHORT_NAME",
            :old."LM_DATE",
            :old."WBS_PATH",
            :old."PERCENTAGE_COMPLETED",
            :old."PERCENTAGE_COMPLETED_DATE",
            :old."WORKING_SCHEDULE_ID",
            :old."HR_INPUT_FORMAT_ID",
            :old."VALIDATION_STATUS_ID",
            :old."EXPORT_TO_PAYROLL",
            :old."EXPORT_TO_PAYROLL_DAY_ID",
            :old."TRAJECT_CHECK_BOX",
            :old."TRANSPORT_CHECK_BOX",
            :old."MEAL_ALLOWANCE_CHECK_BOX",
            :old."LONG_DISTANCE_CHECK_BOX",
            :old."PAUSE_TAKEN_CHECK_BOX",
            :old."VEHICLE_ID_CHECK_BOX",
            :old."VEHICLE_KM_FIELD",
            :old."PRIVATE_KM_FIELD",
            :old."PRIVATE_VEHICLE_CHECK_BOX",
            :old."CUSTOMER_SIGNATURE_REQUESTED",
            :old."DEFAULT_TIME_SHEET_HRD",
            :old."PAUSE_TAKEN_DEFAULT_VALUE",
            :old."LM_NAME",
            :old."BICYCLE_KM_FIELD",
            :old."ON_FOOT_CHECK_BOX",
            :old."PUBLIC_TRANSPORT_CHECK_BOX",
            :old."ON_FOOT_KM_FIELD",
            :old."MAX_WORKED_HR_PER_ACTIVITY",
            :old."EXTERNAL_VALIDATION",
            :old."USE_DECL_WRK_LOC_AND_JOURNEY",
            :old."ERP_ID",
            :old."DISPLAY_PROJECT",
            :old."DISPLAY_SUB_PROJECT",
            :old."HRD_REP_ON_OC_POI_CATEGORY_ID",
            :old."IS_HRD_REPORTED_ON_ACTIVITY",
            :old."MAINTENANCE_CHECK_BOX",
            :old."LAUNDRY_CHECK_BOX",
            :old."DAY_JOURNEY_ROLE_COMBO",
            :old."USE_DEFAULT_VO_PARAMS",
            :old."PASSENGER_KM_FIELD",
            :old."DRIVER_KM_FIELD",
            :old."USE_TSL_WORK_LOCATION",
            :old."USE_TSL_DECLARED_VEHICLE",
            :old."USE_FREE_TEXT_REF_NUMBER",
            :old."LAUNDRY_IS_NEVER_PAID",
            :old."OBJECT_MODEL_ID",
            :old."TRANSPORT_DURATION_FIELD",
            :old."PAUSE_DURATION_FIELD",
            :old."WE_BLOCKED_FIELD",
            :old."VO_DIVISION_ID",
            :old."MAIN_CONTRACTOR_ID",
            :old."WAS_WORKING_LATE_CHECK_BOX",
            :old."MISSION_KM_FIELD",
            :old."OVERNIGHT_STAY_CHECK_BOX",
            :old."IS_CLONE_OF_WBS_ID",
            :old."ERP_ID2",
            :old."START_AND_STOP_TIME_FIELD",
            :old."USE_START_STOP_TIME_FOR_DAY_HRD",
            :old."HARD_WORK_CHECK_BOX",
            :old."DANGEROUS_WORK_CHECK_BOX",
            :old."INSALUBRITY_WORK_CHECK_BOX",
            :old."HEIGHT_WORK_CHECK_BOX",
            :old."LONG_DISTANCE_EXTRA_FIELD",
            :old."COMPANY_SITE_OC_POI_ID",
            :old."PLANNED_BUDGET",
            :old."ALLOW_PICTURE_ON_TSL",
            :old."NBR_PASSENGER_FIELD",
            :old."SUB_PAUSE_FROM_TOT_HR_WHEN_START_STOP_HIF",
            :old."REPORTED_HR",
            :old."REPORTED_BUDGET",
            :old."CLIENT_NAME",
            :old."PLANNED_TURNOVER",
            :old."IS_ALREADY_INVOICED",
            :old."WARNING_WHEN_REPORTING_HOURS",
            :old."TSL_DECLARED_VEH_MANDATORY",
            :old."WBS_ID",
            :old."REF_NUMBER",
            SYSDATE,
            :NEW."LM_NAME",
            :old."NAME"
        );
    END IF;
END;