CREATE OR REPLACE PROCEDURE adam.sp_fco_upd_sit_periodo(pch_compania  char,
                                                        pch_periodo   char,
                                                        pch_operacion char) IS
BEGIN
  UPDATE fco_integrada_cab
     SET sit_periodo = decode(Upper(pch_operacion), 'FCO3060', 2, 1)
   WHERE compania = pch_compania
     AND anio = substr(pch_periodo, 1, 4)
     AND mes = substr(pch_periodo, -2);
END sp_fco_upd_sit_periodo;
/
