Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 :old.wbs_status_id <> :NEW.wbs_status_id 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement