SISTEMAS
Page tree

Versions Compared

Old Version 19

changes.mady.by.user Sistemas

Saved on

compared with

New Version 20

changes.mady.by.user Sistemas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themeEclipse
titleUbicación de logo
linenumberstrue
collapsetrue
-- =============== 28. INSERTAR UBICACION DE LOGO ================ --
  vc_bandera := '28. INSERTAR UBICACION DE LOGO OL';
  DBMS_OUTPUT.put_line(pi_emisor||';'||vc_bandera||';INSERTAR UBICACION DE LOGO;SI Realizado!');
  insert into debcredpy.logos@olpy (EMISOR, LOGO)
  values (125pi_emisor, '/AccesoCabalEntidades/jsp/imagenes/entidades/E125.jpg');


Paso 29

...

- Emisores Liquidac Clearing

Code Block
languagesql
themeEclipse
titleEmisores liquidac clearing
linenumberstrue
collapsetrue
insert into creditopy.emisores_liquidac_clearing (EMISOR, APLICA_RETENCION_IVA, APLICA_RETENCION_RENTA, ARANC_COMERC_PORC_EMISOR, ARANC_COMERC_PORC_ADMIN, ARANCEL_COMERC_IVA_DISTRIBUIDO, FONDO_DE_GARANTIA, ARANCEL_ADEL_EFEC_ATM, ARANCEL_ADEL_EFEC_VENT, FECHA_REGISTRO, USUARIO_REGISTRO)
values (pi_emisor, 1, 1, 68.00, 32.00, 1, 3.00, 1.5, 1.5, sysdate, user);


Paso 30 - Replicación al OL

Code Block
languagesql
themeEclipse
titleReplicacion al OL
linenumberstrue
collapsetrue
  -- =============== 28. REPLICACION al OL ================ --
  vc_bandera := '28. REPLICACION al OL';
  DBMS_OUTPUT.put_line(pi_emisor||';'||vc_bandera||';Replicar al OL;SI Realizado!');

  --commit;
  BEGIN
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('CREDITOPY.CALENDARIO_CIERRES');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('CREDITOPY.CIERRES_HABILITADOS');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('CREDITOPY.EMISORES_COMERCIOS');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('CREDITOPY.CODIGOS_CORRESPONDENCIA');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('DEBCREDPY.SUCURSALES_EMISORES');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('DEBCREDPY.EMISORES');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('CREDITOPY.CODIGOS_PY');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('DEBCREDPY.CARTERAS');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('CREDITOPY.GRUPOS_AFINIDAD');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('CREDITOPY.CIERRES');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('DEBCREDPY.CAPTADORES');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('DEBCREDPY.EMISORES_PRODUCTOS');
    SYS.DBMS_SNAPSHOT.REFRESH@olpy('CREDITOPY.PROMOTORES');
  END;

Paso 30 - Emisores Liquidac Clearing

Code Block
languagesql
themeEclipse
titleEmisores liquidac clearing
linenumberstrue
collapsetrue
insert into creditopy.emisores_liquidac_clearing (EMISOR, APLICA_RETENCION_IVA, APLICA_RETENCION_RENTA, ARANC_COMERC_PORC_EMISOR, ARANC_COMERC_PORC_ADMIN, ARANCEL_COMERC_IVA_DISTRIBUIDO, FONDO_DE_GARANTIA, ARANCEL_ADEL_EFEC_ATM, ARANCEL_ADEL_EFEC_VENT, FECHA_REGISTRO, USUARIO_REGISTRO)
values (125, 1, 1, 68.00, 32.00, 1, 3.00, 1.5, 1.5, sysdate, user);