PROCEDURE sp_add_employee_info(
            i_EmployeeId              IN  T_EMPLOYEE.EmployeeId%TYPE,
            i_EmployeName             IN  T_EMPLOYEE.Employeename%TYPE,
            i_DeptId                  IN  T_EMPLOYEE.DeptId%TYPE,
            i_CurrUserId              IN   EBS_USER.USERID%TYPE,
            o_cursor                  OUT SYS_REFCURSOR,
            o_RetCode                 OUT  VARCHAR2,
            o_RetMsg                  OUT  varchar2
            )IS        
            v_updatedate   DATE;     --操作日期
　　　　　　　v_sql     varchar2(4000);
           
             BEGIN
        v_sql :='INSERT INTO T_EMPLOYEE(
                         EMPLOYEEID,
                         EMPLOYEENAME,
                         DEPTID,
                         OPERATOR,
                         UPDATEDATE 
                      )
                      VALUES( 
                        i_EmployeeId,                  
                        i_EmployeName,                
                        i_DeptId,                                  
                        i_CurrUserId,
                        v_updatedate
                      )';  
                      
         open  o_cursor for v_sql;
         close o_cursor;
 END sp_add_employee_info;