当然可以。
DROP TABLE t;
CREATE TABLE t(a timestamp);

CREATE OR REPLACE PROCEDURE p_t(p1 TIMESTAMP) AS
BEGIN
 INSERT INTO　t VALUES(p1);
 COMMIT;
END;
/

BEGIN
 p_t(systimestamp);
END;
/

SELECT *FROM t;