create or replace package body PKG_SYS_LOG is
  PROCEDURE SP_LOG_ACTIVITY(P_USER_CODE           IN VARCHAR2,
                            P_APP_CODE            IN VARCHAR2,
                            P_ACTIVITYSTATUS_CODE IN VARCHAR2,
                            P_ACTIVITYTYPE_CODE   IN VARCHAR2,
                            P_ACTIVITYNOTE        IN VARCHAR2,
                            P_RETURN_ID           IN NUMBER) AS
  
  BEGIN
  
    INSERT INTO SYS_LOG_ACTIVITY
      (ACTIVITY_KEY,
       ACTIVITYDATE,
       USER_CODE,
       APP_CODE,
       ACTIVITYTYPE_CODE,
       ACTIVITYSTATUS_CODE,
       ACTIVITYNOTE,
       RETURN_ID)
    VALUES
      (SQ_SYS_LOG_ACTIVE.NEXTVAL,
       SYSDATE,
       UPPER(P_USER_CODE),
       P_APP_CODE,
       P_ACTIVITYTYPE_CODE,
       P_ACTIVITYSTATUS_CODE,
       P_ACTIVITYNOTE,
       P_RETURN_ID);
  
    COMMIT;
  END;
end PKG_SYS_LOG;
/