UBi3

문서의 이전 판입니다!

---

ALTER PROCEDURE [dbo].[pkg_sys_get_favorite]

  @A_PLANT NVARCHAR(10),
  @A_LANG NVARCHAR(10),
  @A_USER_ID BIGINT,
  @N_RETURN INT OUTPUT,
  @V_RETURN NVARCHAR(4000) OUTPUT

AS BEGIN

  SET NOCOUNT ON;
  DECLARE @li_seq NVARCHAR(3);

  BEGIN TRY	 

select A.MENU_ID MENUSEQ,
	A.MENU_ID,
	C.CODE FORM,
	C.CODE,
	C.NAME,
	C.A_ADD,
	C.A_DELETE ,
	C.A_SAVE ,
	C.A_PRINT ,
	B.PATH ,
	A.DISP_SN
from SYS_FAVORITE A
inner join SYS_MENU B on A.MENU_ID = B.MENU_ID
inner join SYS_PROG C on C.PROG_ID = B.PROG_ID 
where A.USER_ID = @A_USER_ID
	and A.DELETE_YN = 'N'
	and C.USE_YN = 'Y'
order by A.DISP_SN;

SET @N_RETURN = 0;
  SET @V_RETURN = '저장되었습니다.';
 

  END TRY
  BEGIN CATCH
      SET @N_RETURN = -1;
      SET @V_RETURN = ERROR_MESSAGE();
  END CATCH

END;