f_aps_mrp_unlock.srf 572 B

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. $PBExportHeader$f_aps_mrp_unlock.srf
  2. global type f_aps_mrp_unlock from function_object
  3. end type
  4. forward prototypes
  5. global function integer f_aps_mrp_unlock (long arg_scid, ref string arg_msg)
  6. end prototypes
  7. global function integer f_aps_mrp_unlock (long arg_scid, ref string arg_msg);Int rslt = 1
  8. UPDATE aps_mrp_lock
  9. SET iflock = 0
  10. Where scid = :arg_scid;
  11. IF sqlca.SQLCode <> 0 THEN
  12. arg_msg = 'MRP运算解锁失败,'+sqlca.SQLErrText
  13. rslt = 0
  14. GOTO ext
  15. END IF
  16. ext:
  17. IF rslt = 0 THEN
  18. ROLLBACK;
  19. ELSE
  20. COMMIT;
  21. END IF
  22. RETURN rslt
  23. end function