LexBuild

ReEdit a Submitted Record

Description:
  • LexBuild provides two features to cancel or edit for those submitted record (waiting for approval).
  • To edit submitted (created or modified) records is "reEdit". The reEdited records are lock during the reEditing.
  • User, Manager, Administrator

Logic Details:

  • ReEdit logics:

    StateDatabase tableSet LastActionDescriptions
    SelectLEX_RECORD_TEMP Select record from LEX_RECORD_TEMP with owner requirement
    Edit  Edit a record from your submitted record list
    ReEdit LockLEX_RECORD_TEMP
  • 1 (create) -> 11 (lock + create)
  • 2 (modify) -> 12 (lock + modify)
  • Lock record with specified Eui
    SubmitLEX_RECORD_TEMP
  • 11 (lock + create) -> 1 (create)
  • 12 (lock + modify) -> 2 (modify)
  • unlock and update record with specified Eui
    SubmitINFL_VARS_TEMP delete records from INFL_VARS_TEMP with specified Eui
    SubmitINFL_VARS_TEMP generate and insert inflVars records to INFL_VARS_TEMP with specified Eui
    ReEdit UnlockINFL_VARS_TEMP
  • 11 (lock + create) -> 1 (create)
  • 12 (lock + modify) -> 2 (modify)
  • unlock records with specified Eui