procedure GET_SUM_BONUSES(ID   in  varchar2,
                                      TYPE      in varchar2,
                                      DATE_FROM         in date,
                                      DATE_TO           in date,
                                      PLUS_BONUSES       out number,
                                      ORDER_BONUSES      out number,
                                      FIRE_BONUSES       out number,
                                      CONVERSION_BONUSES out number) is
        DATE_FROM_START_DAY DATE := TRUNC(DATE_FROM);
        DATE_TO_END_DAY DATE := TRUNC(DATE_TO) + (86399/86400);
    begin
        select
            sum(case when ROW_TYPE = 'ACCURAL' then OPERATION_BONUS_SUM else 0 end) into GET_SUM_BONUSES.PLUS_BONUSES,
            sum(case when ROW_TYPE = 'ORDER' then OPERATION_BONUS_SUM else 0 end) into GET_SUM_BONUSES.ORDER_BONUSES,
            sum(case when ROW_TYPE = 'FIRE' then OPERATION_BONUS_SUM else 0 end) into GET_SUM_BONUSES.FIRE_BONUSES,
            sum(case when ROW_TYPE = 'CASHBACK' then OPERATION_BONUS_SUM else 0 end) into GET_SUM_BONUSES.CONVERSION_BONUSES
        from OPERATION t
        where t.ID = GET_SUM_BONUSES.ID
          and TYPE = GET_SUM_BONUSES.TYPE
          and CREATE_DTTM>=nvl(DATE_FROM_START_DAY, CREATE_DTTM) AND CREATE_DTTM<=nvl(DATE_TO_END_DAY, CREATE_DTTM);
    end;