pl/sql package template

PackageBody.sql

CREATE OR REPLACE PACKAGE BODY BFH2_TEMPLATE
AS
    /*
    AUTHOR: Joe Developer
    PACKAGE NAME: TEMPLATE BODY
    CREATION DATE: MM/DD/YYYY
    PURPOSE: 
    DEPENDENCIES:
    
    CHANGELOG:
        DATE        DEVELOPER       DESCRIPTION
        MM-DD-YYYY  Joe Developer   change description...
    
    ADDITIONAL DOCUMENTATION:
        Additional Information about the inner workings of this module.
    */
    /*
    AUTHOR:Joe Developer
    ACCEPTS:These Args
    DOES:Performs Function
    RETURNS:Return Value
    DEPENDENCIES:Uses/Needs
    NOTES: Special Considerations
    */
    FUNCTION FunName(
        InVariable varchar2
    )
    RETURN number
    IS --declaration_section
        returnValue number;
    BEGIN --executable_section
        return returnValue;
    EXCEPTION --exception_section
        when  others  
            then return -1;
    END FunName;
        
END BFH2_TEMPLATE;
/

PackageSpec.sql

CREATE OR REPLACE PACKAGE BFH2_TEMPLATE
AS
    /*
    AUTHOR: Joe Developer
    PACKAGE NAME: TEMPLATE SPEC
    CREATION DATE: MM/DD/YYYY
    PURPOSE: 
    DEPENDENCIES:
    
    CHANGELOG:
        DATE        DEVELOPER       DESCRIPTION
        MM-DD-YYYY  Joe Developer   change description...
    
    ADDITIONAL DOCUMENTATION:
        Additional Information about the inner workings of this module.
    */
    /*
    AUTHOR:Joe Developer
    ACCEPTS:These Args
    DOES:Performs Function
    RETURNS:Return Value
    DEPENDENCIES:Uses/Needs
    NOTES: Special Considerations
    */
    FUNCTION FunName(
        InVariable varchar2
    )
    RETURN number;
 
END BFH2_TEMPLATE;
/