Text
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE PROCEDURE sp_AperturaSolicitud_Gas
@nSolicitudes Integer OUTPUT,
@nAgenci Smallint = Null,
@nTalleres Smallint = Null,
@nFinancieras Smallint = Null,
@nTipoCredito Smallint = Null,
@cPlaca varchar(10) = Null,
@cApePaterno varchar(50) = Null,
@cApeMaterno varchar(50) = Null,
@cNombres varchar(50) = Null,
@nTipoDocumento Smallint = Null,
@cNumDocumento varchar(12) = Null,
@dFechaNacimiento datetime = Null,
@nTotalCredito Numeric(11,2) = Null,
@nPlazo smallint = Null,
@nRecorrido smallint = Null,
@cUsuarioRegistro Varchar(12) = null,
@nCalif01 smallint = null,
@nCalif02 smallint = null,
@nCalif03 smallint = null,
@nCalif04 smallint = null,
@nTotalEndeudam Numeric(11,2) = null,
@nDeudaSICOM Numeric(11,2) = null,
@nNumBancosEndeuda smallint = null,
@nAñoFabrica smallint = null,
@dFechaSunarp datetime = null,
@dFechaSOAT datetime = null,
@nTotalPapeletas Numeric(11,2) = null,
@nNumPapeletas smallint = null,
@cFlagCelular char(1) = null,
@cFlagFondJub char(1) = null,
@cFlaGVtaSoat char(1) = null,
@cFlagSegVida char(1) = null,
@cFlagOtros char(1) = null,
@cFlagSegVehic char(1) = null,
@cFlagSegMed char(1) = null,
@nImpFondJub Numeric(11,2) = null,
@nImpSegMed Numeric(11,2) = null,
@nImpSegVida Numeric(11,2) = null,
@nImpVtaSOAT Numeric(11,2) = null,
@nImpCelular Numeric(11,2) = null,
@nImpOtros Numeric(11,2) = null,
@cGlosaOtros Varchar(100) = null,
@nImpSegVehic Numeric(11,2) = null,
@nMtoConversion Numeric(11,2) = null,
@nMtoReparacion Numeric(11,2) = null,
@nMtoVehiculo Numeric(11,2) = null,
@nMtoCuotaInicial Numeric(11,2) = null,
@nTipoCliente smallint = null,
@cFlagCliente1 char(1) = null,
@cFlagCliente2 char(1) = null,
@cFlagCliente3 char(1) = null,
@dFechaVigDocCon datetime = null
AS
BEGIN
BEGIN TRANSACTION AperturaSolicitud
INSERT into solicitudes (nAgenci, nTalleres, nFinancieras, nTipoCredito, cPlaca,
cApePaterno, cApeMaterno, cNombres, cDireccion, nUbiDirecc, nTelefonoFijo,
nTelefonoMovil, nTipoDocumento, cNumDocumento, nEstadoCivil, cOcupacion,
nSexo, dFechaNacimiento, nTotalCredito, nPlazo, nRecorrido, nUbicacion,
dFechaUbicacion, dFechaRegistro, dFechaModificacion, dFechaAnulacion,
cUsuarioRegistro, cUsuarioModificacion, cUsuarioAnulacion, nEstado)
values (@nAgenci, @nTalleres, @nFinancieras, @nTipoCredito, @cPlaca,
@cApePaterno, @cApeMaterno, @cNombres, null, null, null,
null, @nTipoDocumento, @cNumDocumento, null, null,
null, @dFechaNacimiento, @nTotalCredito, @nPlazo, @nRecorrido, null,
null, getdate(), null, null,
@cUsuarioRegistro, null, null, 0)
IF (@@ROWCOUNT < 1) or (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION AperturaSolicitud
RETURN (1)
END
--
SELECT @nSolicitudes = @@IDENTITY
--
INSERT into TableroControl(nSolicitudes, nCalif01, nCalif02, nCalif03, nCalif04, nTotalEndeudam,
nDeudaSICOM, nNumBancosEndeuda, nAñoFabrica, dFechaSunarp,
dFechaSOAT, nTotalPapeletas, nNumPapeletas, cFlagCelular,
cFlagFondJub, cFlagOtros, cFlagSegMed, cFlagSegVehic, cFlagSegVida,
cFlagVtaSoat, nImpSegVida, nImpSegMed, nImpFondJub, nImpVtaSoat,
nImpCelular, nImpOtros, nImpSegVehic, nMtoConversion,
nMtoReparacion, nMtoVehiculo, nMtoCuotaInicial, nTipoCliente,
cFlagCliente1, cFlagCliente2, cFlagCliente3, cVehClase,
cVehMarca, cVehModelo, cVehColor, cVehSerie, cVehMotor,
cGlosaOtros, nValorComercial)
values (@nSolicitudes, @nCalif01, @nCalif02, @nCalif03, @nCalif04, @nTotalEndeudam,
@nDeudaSICOM, @nNumBancosEndeuda, @nAñoFabrica, @dFechaSunarp,
@dFechaSOAT, @nTotalPapeletas, @nNumPapeletas, @cFlagCelular,
@cFlagFondJub, @cFlagOtros, @cFlagSegMed, @cFlagSegVehic, @cFlagSegVida,
@cFlagVtaSoat, @nImpSegVida, @nImpSegMed, @nImpFondJub, @nImpVtaSoat,
@nImpCelular, @nImpOtros, @nImpSegVehic, @nMtoConversion,
@nMtoReparacion, @nMtoVehiculo, @nMtoCuotaInicial, @nTipoCliente,
@cFlagCliente1, @cFlagCliente2, @cFlagCliente3, null,
null, null, null, null, null,
@cGlosaOtros, null)
IF (@@ROWCOUNT < 1) or (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION AperturaSolicitud
RETURN (1)
END
--
INSERT into DatosConyuge (nSolicitudes, dFechaVigDocCon)
VALUES (@nSolicitudes, @dFechaVigDocCon)
IF (@@ROWCOUNT < 1) or (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION AperturaSolicitud
RETURN (1)
END
COMMIT TRANSACTION AperturaSolicitud
RETURN (0)
END