SQL> create table t (id integer, val varchar2(1));

Table created.

SQL> insert into t 
  2  select level, chr(ascii('A')+level-1) from dual connect by level <= 10;

10 rows created.

SQL> select * from t;
        ID V
---------- -
         1 A
         2 B
         3 C
         4 D
         5 E
         6 F
         7 G
         8 H
         9 I
        10 J

10 rows selected.

SQL> create or replace package p is
  2    myvalue integer;
  3    function get_input return integer;
  4  end;
  5  /

Package created.

SQL> create or replace package body p is
  2    function get_input return integer
  3    is 
  4    begin
  5      return myvalue;
  6    end;
  7  end;
  8  /

Package body created.

SQL> create or replace view v as select * from t where id=p.get_input;

View created.

SQL> exec p.myvalue := 5;

PL/SQL procedure successfully completed.

SQL> select * from v;
        ID V
---------- -
         5 E

1 row selected.

SQL> exec p.myvalue := 3;

PL/SQL procedure successfully completed.

SQL> select * from v;
        ID V
---------- -
         3 C

1 row selected.