Script to unfinalize an absence calendar

Script to unfinalize an absence calendar 

EXPORT PS_GP_CAL_RUN WHERE CAL_RUN_ID = 'CAL_RUN_ID'; 

EXPORT PS_GP_CAL_RUN_DTL WHERE CAL_RUN_ID = 'CAL_RUN_ID'; 

EXPORT PS_GP_PYE_SEG_STAT WHERE CAL_RUN_ID = 'CAL_RUN_ID'; 

UPDATE PS_GP_CAL_RUN SET RUN_FINALIZED_IND = 'N', RUN_FINALIZED_TS = NULL, RUN_OPEN_IND = 'Y' WHERE CAL_RUN_ID = 'CAL_RUN_ID'; 

UPDATE PS_GP_CAL_RUN_DTL SET CAL_FINAL_TS = NULL  WHERE CAL_RUN_ID = 'CAL_RUN_ID'; 

UPDATE PS_GP_PYE_SEG_STAT SET PYE_CALC_STAT = '50' WHERE CAL_RUN_ID = 'CAL_RUN_ID';