Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Transactional
- public void executeSpHatAlokasiSaldoCuti(Employee karyawan, SdKelompokJenisAbsensi kelompokJenisAbsensi) {
- String rndIdProses = System.currentTimeMillis() + RandomDataGenerator.randomString(5);
- em.createNativeQuery("INSERT INTO hat_alokasi_saldo_cuti_i001 "
- + "VALUES(:id,:processId,:karyawanId,:sdKelompokJenisAbsensi,:version,:usrCrt,:crtTime,:usrMod,:modTime)")
- .setParameter("id", UUID.randomUUID().toString())
- .setParameter("processId", rndIdProses)
- .setParameter("karyawanId", karyawan.getId())
- .setParameter("sdKelompokJenisAbsensi", kelompokJenisAbsensi.getId())
- .setParameter("version", 1)
- .setParameter("usrCrt", CurrentUser.getUsername())
- .setParameter("crtTime", TimeUtil.getSystemDateTime())
- .setParameter("usrMod", CurrentUser.getUsername())
- .setParameter("modTime", TimeUtil.getSystemDateTime())
- .executeUpdate();
- clearSpParameter();
- addSpParameter(rndIdProses);
- addSpParameter(CurrentUser.getUsername());
- addSpParameter(TimeUtil.convertDateToSQLString(TimeUtil.getSystemDateTime()));
- executeVoidProcedure("public.spHatAlokasiSaldoCuti");
- }
Advertisement
Add Comment
Please, Sign In to add comment