Oracle EBS 创建人员API

OracleEBS创建人员API

创建人员API 

DECLARE  

 LC_EMPLOYEE_NUMBER                          PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE   ; 

 LN_PERSON_ID                               PER_ALL_PEOPLE_F.PERSON_ID%TYPE ; 

 LN_ASSIGNMENT_ID                           PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE; 

 LN_OBJECT_VER_NUMBER                        PER_ALL_ASSIGNMENTS_F.OBJECT_VERSION_NUMBER%TYPE; 

 ln_asg_ovn                                 NUMBER:=5; 

  

 LD_PER_EFFECTIVE_START_DATE                  PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE; 

 LD_PER_EFFECTIVE_END_DATE                    PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE:=NULL; 

 LC_FULL_NAME                               PER_ALL_PEOPLE_F.FULL_NAME%TYPE; 

 LN_PER_COMMENT_ID                           PER_ALL_PEOPLE_F.COMMENT_ID%TYPE:=NULL; 

 LN_ASSIGNMENT_SEQUENCE                      PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE; 

 lc_assignment_number                        PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE; 

  

 LB_NAME_COMBINATION_WARNING                  BOOLEAN; 

 LB_ASSIGN_PAYROLL_WARNING                    BOOLEAN; 

 LB_ORIG_HIRE_WARNING                        BOOLEAN; 

 --LC_EMPLOYEE_NUMBER := 'test2018';

 p_number varchar2(100) :='test201803';

BEGIN 

         hr_employee_api.create_employee 

         (   -- Input data elements  

             -- ------------------------------ 

             p_hire_date                         => TO_DATE('2018-05-16','YYYY-MM-DD'), 

            P_BUSINESS_GROUP_ID                  => 0, 

             P_LAST_NAME                         => '王五', 

             P_FIRST_NAME                        => '王', 

            p_middle_names                      => NULL, 

             p_sex                              => 'M', 

            p_national_identifier                 => NULL,

            P_DATE_OF_BIRTH                      => NULL, 

             p_known_as                          => 'WANG',  

             -- Output data elements  

             -- -------------------------------- 

            p_employee_number                    => p_number, 

             p_person_id                         => ln_person_id, 

            p_assignment_id                      => ln_assignment_id, 

            p_per_object_version_number            => ln_object_ver_number, 

            p_asg_object_version_number            => ln_asg_ovn, 

            p_per_effective_start_date            => ld_per_effective_start_date, 

            p_per_effective_end_date              => ld_per_effective_end_date, 

             p_full_name                         => lc_full_name, 

            p_per_comment_id                     => ln_per_comment_id, 

            p_assignment_sequence                 => ln_assignment_sequence, 

            p_assignment_number                  => lc_assignment_number, 

            p_name_combination_warning            => lb_name_combination_warning, 

            p_assign_payroll_warning              => lb_assign_payroll_warning, 

            p_orig_hire_warning                  => lb_orig_hire_warning  

       ); 

  

            COMMIT;

            dbms_output.put_line(ln_person_id) ;

EXCEPTION 

      WHEN OTHERS THEN 

                 ROLLBACK; 

                dbms_output.put_line(SQLERRM); 

END; 

--刘轶鹤