Period Re-Open

update 
org_acct_periods 

set 
open_flag = 'Y', 
period_close_date = NULL, 
summarized_flag = 'N' 

where
acct_period_id = :p_acct_period_id;