public ArrayList datos_tiposubrespuesta() throws Exception {
   Conexion co = new Conexion();
   ArrayList lista = new ArrayList();
   ResultSet rs =
       co.listar(
           "select c_codresp_mt, c_desresp_mt from tipo_respuesta_mt " + "where c_estregi='ACT'");
   Gestion ges = new Gestion();
   while (rs.next()) {
     ges = new Gestion();
     ges.setC_codresp_mt(rs.getString("c_codresp_mt"));
     ges.setC_desresp_mt(rs.getString("c_desresp_mt"));
     lista.add(ges);
   }
   return lista;
 }
 public ArrayList Respuesta_llam(String id_codtcon) throws Exception {
   Conexion co = new Conexion();
   ArrayList lista = new ArrayList();
   ResultSet rs =
       co.listar(
           "select id_codtres,c_destres from tipo_respuesta "
               + "where c_codest='ACT' and id_codtcon like '"
               + id_codtcon
               + "' || '%'");
   Gestion llm = new Gestion();
   while (rs.next()) {
     llm = new Gestion();
     llm.setId_codtres(rs.getString("id_codtres"));
     llm.setC_destres(rs.getString("c_destres"));
     lista.add(llm);
   }
   return lista;
 }
 public ArrayList sub_respuesta_carta(String id_codrspta) throws Exception {
   Conexion co = new Conexion();
   ArrayList lista = new ArrayList();
   ResultSet rs =
       co.listar(
           "SELECT id_codrspta_sub,c_desrspta_sub FROM rspta_carta "
               + "WHERE c_codest = 'ACT' and id_codrspta like '"
               + id_codrspta
               + "' || '%'");
   Gestion ges = new Gestion();
   while (rs.next()) {
     ges = new Gestion();
     ges.setId_codrspta_sub(rs.getString("id_codrspta_sub"));
     ges.setC_desrspta_sub(rs.getString("c_desrspta_sub"));
     lista.add(ges);
   }
   return lista;
 }
 public ArrayList datos_tiposubrespuesta(String id_codtcon, String id_codtres) throws Exception {
   Conexion co = new Conexion();
   ArrayList lista = new ArrayList();
   ResultSet rs =
       co.listar(
           "SELECT id_codtres_sub,id_codtcon,id_codtres,c_destres_sub FROM tipo_subrspta"
               + " WHERE c_codest='ACT' and id_codtcon='"
               + id_codtcon
               + "' AND id_codtres='"
               + id_codtres
               + "'");
   Gestion ges = new Gestion();
   while (rs.next()) {
     ges = new Gestion();
     ges.setId_codrspta_sub(rs.getString("id_codtres_sub"));
     ges.setC_desrspta_sub(rs.getString("c_destres_sub"));
     lista.add(ges);
   }
   return lista;
 }
 public ArrayList gestion_llamada_quitar(
     String f_fproceso, String id_codper, String id_codtcon, String id_codtres, String id_codusu)
     throws Exception {
   Conexion co = new Conexion();
   ArrayList lista = new ArrayList();
   String cadena =
       " SELECT * FROM USP_QRY_GESTION_LLM_QUITAR('"
           + f_fproceso
           + "','"
           + id_codper
           + "','"
           + id_codtcon
           + "','"
           + id_codtres
           + "','"
           + id_codusu
           + "') ";
   ResultSet rs = co.listar(cadena);
   Gestion ges = new Gestion();
   while (rs.next()) {
     ges = new Gestion();
     ges.setF_fproceso(rs.getString("f_fproceso"));
     ges.setC_codcent(rs.getString("c_codcent"));
     ges.setC_nrodoc(rs.getString("c_nrodoc"));
     ges.setC_nombre(rs.getString("c_nombre"));
     ges.setC_contrato(rs.getString("c_contrato"));
     ges.setN_idxges(rs.getString("n_idxges"));
     ges.setC_destcon(rs.getString("c_destcon"));
     ges.setC_destres(rs.getString("c_destres"));
     ges.setF_fecresp(rs.getString("f_fecresp"));
     ges.setC_destres_sub(rs.getString("c_destres_sub"));
     ges.setC_obsges(rs.getString("c_obsges"));
     ges.setC_nomusu(rs.getString("c_nomusu"));
     ges.setId_codusu(rs.getString("id_codusu"));
     ges.setId_codtcon(rs.getString("id_codtcon"));
     ges.setId_codtres(rs.getString("id_codtres"));
     lista.add(ges);
   }
   return lista;
 }
 public ArrayList lista_gestion_contacto(
     String id_codper, String c_nrodoc, String c_nombre, String id_codtges) throws Exception {
   Conexion co = new Conexion();
   ArrayList lista = new ArrayList();
   ResultSet rs =
       co.listar(
           " select * from USP_QRY_GESTION_CONTACTO('"
               + id_codper
               + "','"
               + c_nrodoc
               + "','"
               + c_nombre
               + "','"
               + id_codtges
               + "') ");
   Gestion ges = new Gestion();
   while (rs.next()) {
     ges = new Gestion();
     ges.setC_codcent(rs.getString("c_codcent"));
     ges.setC_tipodoc(rs.getString("c_tipodoc"));
     ges.setC_nrodoc(rs.getString("c_nrodoc"));
     ges.setC_nombre(rs.getString("c_nombre"));
     ges.setC_direccion(rs.getString("c_direccion"));
     ges.setC_distprov(rs.getString("c_distprov"));
     ges.setC_telefono(rs.getString("c_telefono"));
     ges.setF_fproceso(rs.getString("f_fproceso"));
     ges.setF_fecasig(rs.getString("f_fecasig"));
     ges.setC_destges(rs.getString("c_destges"));
     ges.setN_idxges(rs.getString("n_idxges"));
     ges.setId_codusu(rs.getString("id_codusu"));
     ges.setId_codtges(rs.getString("id_codtges"));
     lista.add(ges);
   }
   return lista;
 }