Function Procedure Packages Oracle PLSQL Tutorial

You create a package body using the CREATE PACKAGE BODY statement.
The simplified syntax for the CREATE PACKAGE BODY statement is as follows:

SQL>
SQL> CREATE [OR REPLACE] PACKAGE BODY package_name
  2  {IS | AS}
  3    package_body
  4  END package_name;
where
package_name specifies the name of the package, which must match the package name previously set in the package specification.
package_body specifies the code for the procedures and functions, along with any variables and cursors.