diff --git a/src-db/database/model/functions/C_PERIOD_PROCESS.xml b/src-db/database/model/functions/C_PERIOD_PROCESS.xml --- a/src-db/database/model/functions/C_PERIOD_PROCESS.xml +++ b/src-db/database/model/functions/C_PERIOD_PROCESS.xml @@ -1,10 +1,10 @@ - - - - - - + + + + + 'P'; END LOOP; @@ -140,7 +141,7 @@ LOOP v_Record_ID:=Cur_Document.C_PERIODCONTROL_ID; UPDATE C_PeriodControl - SET PeriodStatus='O', openclose='C' + SET PeriodStatus='O', openclose='C', updated=to_date(now()), updatedby=v_AD_User_ID WHERE C_PeriodControl_ID=v_Record_ID AND PeriodStatus<>'P'; END LOOP; @@ -172,7 +173,7 @@ LOOP v_Record_ID:=Cur_Document.C_PERIODCONTROL_ID; UPDATE C_PeriodControl - SET PeriodStatus='C', openclose='O' + SET PeriodStatus='C', openclose='O', updated=to_date(now()), updatedby=v_AD_User_ID WHERE C_PeriodControl_ID=v_Record_ID AND PeriodStatus<>'P'; END LOOP; @@ -190,7 +191,7 @@ LOOP v_Record_ID:=Cur_Document.C_PERIODCONTROL_ID; UPDATE C_PeriodControl - SET PeriodStatus='C', openclose='O' + SET PeriodStatus='C', openclose='O', updated=to_date(now()), updatedby=v_AD_User_ID WHERE C_PeriodControl_ID=v_Record_ID AND PeriodStatus<>'P'; END LOOP; @@ -213,7 +214,9 @@ ) LOOP v_Record_ID:=Cur_Document.C_PERIODCONTROL_ID; - UPDATE C_PeriodControl SET PeriodStatus='P', openclose='O' WHERE C_PeriodControl_ID=v_Record_ID; + UPDATE C_PeriodControl + SET PeriodStatus='P', openclose='O', updated=to_date(now()), updatedby=v_AD_User_ID + WHERE C_PeriodControl_ID=v_Record_ID; END LOOP; ELSIF (p_IsRecursive='N') THEN FOR Cur_Document IN @@ -228,7 +231,9 @@ ) LOOP v_Record_ID:=Cur_Document.C_PERIODCONTROL_ID; - UPDATE C_PeriodControl SET PeriodStatus='P', openclose='O' WHERE C_PeriodControl_ID=v_Record_ID; + UPDATE C_PeriodControl + SET PeriodStatus='P', openclose='O', updated=to_date(now()), updatedby=v_AD_User_ID + WHERE C_PeriodControl_ID=v_Record_ID; END LOOP; END IF; END IF; @@ -239,7 +244,7 @@ ELSE 'O' END FROM c_periodcontrol pc - WHERE pc.c_period_id = p_C_Period_ID) + WHERE pc.c_period_id = p_C_Period_ID), updated=to_date(now()), updatedby=v_AD_User_ID WHERE c_period_id = p_C_Period_ID; --<> @@ -267,5 +272,5 @@ END IF; END C_PERIOD_PROCESS ]]> - - + +