pay_entries_post.txt
| 1 |
|
|---|---|
| 2 |
ALTER PROCEDURE [dbo].[PAY_ENTRIES_POST_UpdRef] |
| 3 |
@p_ET_ID varchar(MAX) = NULL, |
| 4 |
@p_ENTRY_PAIR varchar(50) = NULL, |
| 5 |
@p_TRN_ID varchar(50) = NULL, |
| 6 |
@p_REF_NO VARCHAR(100) = ''---SO REF NO CUA CORE TRA VE |
| 7 |
AS |
| 8 |
BEGIN TRY |
| 9 |
UPDATE PAY_ENTRIES_POST |
| 10 |
SET REF_NO = @p_REF_NO , |
| 11 |
TRN_DATE = GETDATE() -- LUCTV 28042021: BO SUNG NEU TRUONG HOP RETRY BUT TOAN THI NGAY HACH TOAN TREN AMS VA NGAY HACH TOAN TREN CORE FC PHAI KHOP NHAU |
| 12 |
WHERE ET_ID IN (SELECT * FROM wsiSplit(@p_ET_ID,',')) |
| 13 |
/* |
| 14 |
-- doanptt update ref_no danh sách chuyển tiền ngoài hệ thống |
| 15 |
UPDATE TR_REQ_PAY_TRANS_OUTSIDE_REC |
| 16 |
SET REF_NO = @p_REF_NO |
| 17 |
WHERE REQ_PAY_ID = @p_TRN_ID AND ENTRY_PAIR = @p_ENTRY_PAIR |
| 18 |
*/ |
| 19 |
--SELECT * FROM wsiSplit('PET000000000016,PET000000000017,PET000000000018,PET000000000019',',')
|
| 20 |
|
| 21 |
SELECT '0' RESULT, '' ERROR |
| 22 |
RETURN 0 |
| 23 |
END TRY |
| 24 |
BEGIN CATCH |
| 25 |
SELECT '-1' RESULT, ERROR_MESSAGE() ERROR |
| 26 |
RETURN -1 |
| 27 |
END CATCH |