Creating a package specification with functions example

create or replace
PACKAGE xx_requisition_report
AS
-- Author      : Gopal Vedula
-- Date        : 29-JAN-2009
-- Description : Get data for Requisition Status Report.
-- Change History
-- Date         Author             Description
-----------------------------------------------------------------------------------------------------------------
-- 29-Jan-2009  Gopal Vedula        Created
-----------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------
-- Function  Name:  getapprover
-- Purpose       :  This function will get approver
-------------------------------------------------------------------
FUNCTION getapprover (p_seq_number IN NUMBER,
                      p_req_num    IN VARCHAR2)RETURN  varchar2;

------------------------------------------------------------------
-- Function  Name:  getapprover_date
-- Purpose       :  This function will get approver
-------------------------------------------------------------------

FUNCTION getapprover_date (p_seq_number IN NUMBER,
                          p_req_num    IN VARCHAR2)RETURN  VARCHAR2;

------------------------------------------------------------------
-- Function  Name:  getapprover_FA
-- Purpose       :  This function will get FA approver
-------------------------------------------------------------------
FUNCTION getapprover_FA(p_req_num IN VARCHAR2)RETURN  varchar2;

------------------------------------------------------------------
-- Function  Name:  getapprover_FA_date
-- Purpose       :  This function will get FA approver Date
-------------------------------------------------------------------
FUNCTION getapprover_FA_date(p_req_num IN VARCHAR2)RETURN  varchar2;

END xx_requisition_report;