CREATE OR REPLACE PACKAGE HR_HERO
  IS
--
-- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
-- directory of SQL Navigator
--
-- Purpose: Briefly explain the functionality of the package
--
-- MODIFICATION HISTORY
-- Person      Date    Comments
-- ---------   ------  ------------------------------------------
   -- Enter package declarations as shown below

--   variable_name   datatype;
    FUNCTION EmpID2Code(p_EmpID number) RETURN NUMBER;
    FUNCTION EmpID2Name(p_EmpID number) RETURN varchar;
    FUNCTION EmpID2JDate(p_EmpID number) RETURN Date;

    FUNCTION EmpCode2ID(p_Code number) RETURN NUMBER;
    FUNCTION EmpCode2Name(p_Code number) RETURN varchar;
    FUNCTION CadreID2Name(p_Cadre number) RETURN varchar;
    FUNCTION SubCadreID2Name(p_SubCadre number) RETURN varchar;
    FUNCTION DeptID2Name(p_DeptID number) RETURN varchar;
    FUNCTION DeptID2Code(p_DeptID number) RETURN varchar;
    FUNCTION CCNID2SName(p_CCNID number) RETURN varchar;
    FUNCTION SName2CCNID(p_SName varchar2) RETURN number;
    FUNCTION EmpID2BankAC(p_EmpID number) RETURN varchar;
    FUNCTION DesigID2Name(p_DesgID number) RETURN varchar;
    FUNCTION Org2CompanyCode(p_OrgID number) RETURN number;
    FUNCTION OrgID2Name(p_OrgID number) RETURN varchar;
    FUNCTION EmpID2EDQual(p_EmpID number) RETURN varchar2;
    FUNCTION QualID2Name(p_QualID number) RETURN varchar;

    Function GetLastSalry(p_empid number,
                          p_stmon number,
                          p_emon number,
                          p_saltype char)   --  SR - Rate, SE - Earned
            return number;

    PROCEDURE Fill_Attendance(p_OrgCode number,
                              p_Date date);
    PROCEDURE Fill_ISO_Attn(p_OrgCode number,
                              p_FDate date,
                              p_TDate date,
                              p_EmpID number);

    PROCEDURE Check_Attendance(p_OrgCode number,
                              p_Date date);
    PROCEDURE Check_Pre_Salary(p_OrgCode number,
                               p_Month number,
                               p_cursor OUT SYS_REFCURSOR);

    PROCEDURE Fill_LTA_ANN(p_PInstance_ID NUMBER);
    PROCEDURE Fill_LTA_PRO(p_PInstance_ID NUMBER);

    PROCEDURE Fill_Incr_ANN(p_PInstance_ID NUMBER);
    PROCEDURE Fill_Incr_MinWg(p_PInstance_ID NUMBER);

    Procedure FillIncr_Hist(p_mon number,
                        p_divid number,
                        p_deptid number,
                        p_empid number,
                        p_empcode number,
                        p_emptype char);
    Function GetLastCat(p_empid number,
                    p_stdate number,
                    p_edate number,
                    p_saltype char)   --  SR - Rate, SE - Earned
            return number;
    FUNCTION GETLWWDAYS(p_stdate number,
                    p_edate NUMBER,
                    p_jdate date,
                    p_cdate date,
                    p_Empid NUMBER)
            return number;

    FUNCTION GetEarnEL( p_Year number,
                    p_stmon number,
                    p_emon number,
                    p_Empid NUMBER,
                    p_Jdate DATE,
                    p_cdate date,
                    p_Ldate DATE,
                    p_EmpType CHAR,
                    p_IgnELDays char)
            return number;
    FUNCTION GetEarnCL( p_Year number,
                    p_stmon number,
                    p_emon number,
                    p_Empid NUMBER,
                    p_Jdate DATE,
                    p_Ldate DATE,
                    p_EmpType CHAR)
            return number;

    FUNCTION GetEarnSL(p_Year number,
                    p_stmon number,
                    p_emon number,
                    p_Empid NUMBER,
                    p_Jdate DATE,
                    p_Ldate DATE,
                    p_EmpType CHAR)
            return number;
FUNCTION GetESIFlag(p_date date,
                    p_Empid number)
            return char;
FUNCTION GetEnjLeave(p_Year number,
                     p_stmon number,
                     p_emon number,
                     p_Empid number,
                     p_LeaveType char)
            return number;
Procedure FillLWW(p_PInstance_ID  NUMBER);
Procedure FillYR_FF(p_PInstance_ID  NUMBER);

    PROCEDURE Fill_Arrear(v_Org in  number,
                          v_FMon in number,
                          v_IncrType in char,
                          v_Dept in number,
                          v_EmpID in number,
                          v_retval out integer,
                          V_retmsg out nvarchar2);

Procedure FillBONUS(p_PInstance_ID  NUMBER);

FUNCTION GETBONAMT(p_Empid number,
                   p_Basic number,
                   p_erbasic number,
                   p_smon number,
                   p_MonthDays number,
                   p_SalaryDays number,
                   p_EmpType char,
                   p_jdate date,
                   p_catcode number)
            return number;


END; -- Package spec