Tienes que Crear un Package Body y su Package Especification,.. aqui va una plantilla de cómo lo puedes hacer :
-- Package body PR
CREATE OR REPLACE
Package Body ESQUEMA.NOMBRE_PACKAGE
IS
-- Enter procedure, function bodies as shown below
PROCEDURE procedure_name
( param1 IN datatype,
param2 IN OUT datatype DEFAULT default_value)
IS
-- Enter the procedure variables here. As shown below
variable_name datatype NOT NULL DEFAULT default_value;
BEGIN
statements ;
EXCEPTION
WHEN exception_name THEN
statements ;
END;
-- Enter further code below as specified in the Package spec.
END; -- Package Body PR
--
-- Package especification PR
CREATE OR REPLACE
PACKAGE PR
PROCEDURE
procedure_name( param1 IN datatype,
param2 IN OUT datatype DEFAULT default_value)
;
END;
/
-- End of DDL script for PR
Saludos.