/* 36: */
/* 37: */ public ResultSet getPersonnelForReport(Long personnelId) /* 38: */ {
/* 39: 41 */ Connection conn = JDBCUtility.getConnection();
/* 40: 42 */ String sql = "{call DBPK_HRM_PERSONNEL_REPORT.get_Personnel_For_Report(?,?)}";
/* 41: */ try
/* 42: */ {
/* 43: 45 */ CallableStatement cstmt = conn.prepareCall(sql);
/* 44: 46 */ cstmt.registerOutParameter(1, -10);
/* 45: 48 */ if (personnelId.longValue() == -1L) {
/* 46: 48 */ cstmt.setString(2, null);
/* 47: */ } else {
/* 48: 49 */ cstmt.setString(2, personnelId.toString());
/* 49: */ }
/* 50: 51 */ cstmt.execute();
/* 51: 52 */ return (ResultSet) cstmt.getObject(1);
/* 52: */ }
/* 53: */ catch (Exception e)
/* 54: */ {
/* 55: 55 */ e.printStackTrace();
/* 56: 56 */ this.logger.log(Priority.ERROR, e.getMessage());
/* 57: */ }
/* 58: 57 */ return null;
/* 59: */ }