public void loadLocks(){
  int AD_User_ID=Env.getContextAsInt(Env.getCtx(),"#AD_User_ID");
  log.fine("#" + m_vo.TabNo + " - AD_User_ID="+ AD_User_ID);
  if (!canHaveAttachment())   return;
  String sql="SELECT Record_ID " + "FROM AD_Private_Access " + "WHERE AD_User_ID=? AND AD_Table_ID=? AND IsActive='Y' "+ "ORDER BY Record_ID";
  try {
    if (m_Lock == null)     m_Lock=new ArrayList<Integer>();
 else     m_Lock.clear();
    PreparedStatement pstmt=DB.prepareStatement(sql,null);
    pstmt.setInt(1,AD_User_ID);
    pstmt.setInt(2,m_vo.AD_Table_ID);
    ResultSet rs=pstmt.executeQuery();
    while (rs.next()) {
      Integer key=new Integer(rs.getInt(1));
      m_Lock.add(key);
    }
    rs.close();
    pstmt.close();
  }
 catch (  SQLException e) {
    log.log(Level.SEVERE,sql,e);
  }
  log.fine("#" + m_Lock.size());
}

public void loadLocks ( ) { int AD_User_ID = Env . getContextAsInt ( Env . getCtx ( ) , "#AD_User_ID" ) ; log . fine ( "#" + m_vo . TabNo + " - AD_User_ID=" + AD_User_ID ) ; if ( ! canHaveAttachment ( ) ) return ; String sql = "SELECT Record_ID " + "FROM AD_Private_Access " + "WHERE AD_User_ID=? AND AD_Table_ID=? AND IsActive='Y' " + "ORDER BY Record_ID" ; try { if ( m_Lock == null ) m_Lock = new ArrayList < Integer > ( ) ; else m_Lock . clear ( ) ; PreparedStatement pstmt = DB . prepareStatement ( sql , null ) ; pstmt . setInt ( 1 , AD_User_ID ) ; pstmt . setInt ( 2 , m_vo . AD_Table_ID ) ; ResultSet rs = pstmt . executeQuery ( ) ; while ( rs . next ( ) ) { Integer key = new Integer ( rs . getInt ( 1 ) ) ; m_Lock . add ( key ) ; } rs . close ( ) ; pstmt . close ( ) ; } catch ( SQLException e ) { log . log ( Level . SEVERE , sql , e ) ; } log . fine ( "#" + m_Lock . size ( ) ) ; }
load locks for table and user
