--------------------------------------
-- Creado por: Diana Mendez / 21-ENE-2013 09:01
-- Descripcion: Parametrizacion de transaccion 09-3080
-- Comentarios: El script es creado para la Jep
---------------------------------------

spool act0009313.log

-----------------------------------------------------------------------------------------------------------------
---- 06 3103 NIVEL DE SEGURIDAD
-----------------------------------------------------------------------------------------------------------------
DELETE FROM TSUBSISTEMATRANSACCIONES WHERE CSUBSISTEMA ='06' AND CTRANSACCION='3103';
DELETE FROM TCOMPANIATRANSACCIONESHORARIO WHERE CSUBSISTEMA ='06' AND CTRANSACCION='3103';
DELETE FROM TROLESHORARIO WHERE CSUBSISTEMA ='06' AND CTRANSACCION='3103';
DELETE FROM TCOMPANIAROLES WHERE CSUBSISTEMA ='06' AND CTRANSACCION='3103';
DELETE FROM TCOMPANIATRANSACCIONESPRODUCTO WHERE CSUBSISTEMA ='06' AND CTRANSACCION='3103';
DELETE FROM TFORMATOXML WHERE CSUBSISTEMA='06' AND CTRANSACCION = '3103';
DELETE FROM TCOMPANIATRANSACCIONES WHERE CSUBSISTEMA ='06' AND CTRANSACCION='3103';
DELETE FROM TUCITRANSACCIONESDIA WHERE CSUBSISTEMA ='06' AND CTRANSACCION='3103';
DELETE FROM TSUBSISTEMATRANSACCIONESID WHERE CSUBSISTEMA ='06' AND CTRANSACCION='3103';

--TSUBSISTEMATRANSACCIONESID
INSERT INTO TSUBSISTEMATRANSACCIONESID (CSUBSISTEMA,CTRANSACCION,VERSIONTRANSACCION,ORDENMENU,PRESENTARENMENU,INTERNA,FORMULARIOBASE,AFECTAINMOVILIZACION,CGRUPOTRANSACCION,PRESENTARENREVERSO,CNIVELMENU,LISTAVALOR,USACACHE,SUMACOMPONENTES,PROVISION,COMPLETARRUBROS,LOTEGENERICO,VERIFICANIVELSEGURIDAD,CUSUARIO_INGRESO,FINGRESO,ACUMULACONTADOR,PAGINA,ORIGENDESTINO,CONTROLAEFECTIVO,REQUIEREAUTORIZACION,EJECUTAENAUTORIZACION) 
VALUES ('06','3103','01',NULL,'1','1','0','0',NULL,'1',NULL,'1','0','0','0','0','0','0',NULL,NULL,'0',NULL,NULL,'0','0','0');

--TCOMPANIATRANSACCIONES
INSERT INTO TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA,CSUBSISTEMA,CTRANSACCION,VERSIONTRANSACCION,VERSIONCONTROL) 
VALUES (2,'06','3103','01',0);

--TSUBSISTEMATRANSACCIONES
INSERT INTO TSUBSISTEMATRANSACCIONES (CIDIOMA,CSUBSISTEMA,CTRANSACCION,VERSIONTRANSACCION,FHASTA,FDESDE,DESCRIPCION,SIGLAS,VERSIONCONTROL) 
VALUES ('ES','06','3103','01',to_timestamp('31/12/2999','DD/MM/YYYY'),SYSTIMESTAMP,'RECEPCION DE PAGARES',NULL,0);


commit;         
prompt Done. 
spool off