-- create or replace view SV_AA as
with function ChangeData(pDrep Date) return Date 
     is 
       pragma autonomous_transaction;  -- пробывал ремировать результат тот же
     begin 
       declare 
         nMax Date; 
         nCount Integer:=0;
       begin
         select Count(*) into nCount from SV_A2 where DAY=pDrep;  
         if nCount=0 then 
           delete from SV_A2;
           insert into SV_A2
           select * from SV_A1 where DAY=pDrep;
           commit;
           select Max(DAY) into nMax from SV_A2 where DAY=pDrep;  
           dbms_output.put_line('Change '||nMax);
         end if;
         return pDrep;
       end;  
     end;
     PARAMETER as (select /*+ Materialize
                              No_Merge(P)
                          */
                          P.DREP
                     from (select
                                  To_Date('01-02-2021','DD-MM-YYYY') DREP
                             from DUAL
                          ) P
                    where Not ChangeData(P.DREP) is Null  
                  )
select A.*
  from SV_A2 A   -- наблюдаю старые данные в МОМЕНТ смены даты
 inner join PARAMETER B  
    on (    B.DREP=A.DAY
       )

with AAA111 as (select *
                      from DUAL  
                  )

select /*+ WITH_PLSQL */ 
        * 
 from (with
                  function add_fnc(p_id number) return number
                  is
                  begin
                    select Count(*) into ..... from AAA111;
                    return p_id + 1; 
                 end;
           select add_fnc(10) from DUAL
         )

create or replace type rcData as object(DAY date,RST numeric(18,2));
create or replace type rtData as table of rcData;

create or replace view SV_V1 as 
with function ChangeData(pField rtData,pDrep Date) return rtData
     is 
       pragma autonomous_transaction; 
     begin 
       declare 
         nExe Integer:=0;
       begin
         select Count(*) into nExe from SV_A2 where DAY=pDrep;
         if nExe=0 then
           delete from SV_A2;
           insert into SV_A2 select * from Table(pField);
           commit;
           dbms_output.put_line('Update');
         end if;
         return pField; 
       end; 
     end;
     PARAMETER as (select /*+ Materialize
                              No_Merge(P)
                          */
                          P.DREP
                     from (select
--                                To_Date('01-01-2021','DD-MM-YYYY') DREP
                                  Cast(To_Date(PARAMETERS.Srep,'DD-MM-YYYY') as Date) DREP
                             from DUAL
                          ) P
                  ),
        SCLIST as (select A.*
                     from SV_A1 A   
                    inner join PARAMETER B 
                       on (    B.DREP=A.DAY
                          ) 
                  )
select A.*
  from Table(ChangeData(Cast((select Collect(rcData(DAY,RST)) from SCLIST) as rtData),(select DREP from PARAMETER))) A
 where not Exists(select 1 from SV_A2 where DAY=(select DREP from PARAMETER)) 
 union all
select * from SV_A2              
 where     Exists(select 1 from SV_A2 where DAY=(select DREP from PARAMETER)) 


Вызов из параметризирован. представления со сменой даты
with PARAMETER as (
                   select /*+ qb_name(Refresh) 
                              no_unnest 
                              push_subq
                              Materialize
                          */ 
                          1 EXEC
                     from DUAL
                    where PARAMETERS.Refresh(
                                                       sDrep=>To_Date('01/02/2021','DD/MM/YYYY')
                                                      ) is Null 
                  )
select A.*
  from SV_V1 A
 where Exists(select 1 from PARAMETER)