Oracle Apps Knowledge Sharing

            In this post, we have given a script to create an employee in R12 instance.

API: HR_EMPLOYEE_API.CREATE_EMPLOYEE

Instance: R12

Script:

DECLARE 
  ln_person_id                 NUMBER;
  ln_assignment_id             per_all_assignments_f.assignment_id%TYPE;
  ln_per_object_version_number per_all_people_f.object_version_number%TYPE;
  ln_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
  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;
  lv_full_name                 per_all_people_f.full_name%TYPE;
  ln_per_comment_id            per_all_people_f.comment_id%TYPE;
  ln_assignment_sequence       per_all_assignments_f.assignment_sequence%TYPE;
  lv_assignment_number         per_all_assignments_f.assignment_number%TYPE;
  lv_employee_number           VARCHAR2(200) DEFAULT '1234567';
  lb_name_combination_warning  BOOLEAN;
  lb_assign_payroll_warning    BOOLEAN;
  lb_orig_hire_warning         BOOLEAN;
BEGIN
  HR_EMPLOYEE_API.CREATE_EMPLOYEE
        (
         -- IN parameters
         p_validate                  => FALSE,
         p_hire_date                 => SYSDATE,
         p_business_group_id         => 81, --from per_business_groups_perf
         p_last_name                 => 'SHARE',
         p_middle_names              => 'ORACLE',  
         p_sex                       => 'M',
         p_person_type_id            => NULL,
         p_email_address             => 'test@shareoracleapps.com',
         p_first_name                => 'APPS',
         p_employee_number           => lv_employee_number,
         -- OUT parameters                                         
         p_person_id                 => ln_person_id,
         p_assignment_id             => ln_assignment_id,
         p_per_object_version_number => ln_per_object_version_number,
         p_asg_object_version_number => ln_asg_object_version_number,
         p_per_effective_start_date  => ld_per_effective_start_date,
         p_per_effective_end_date    => ld_per_effective_end_date,
         p_full_name                 => lv_full_name,
         p_per_comment_id            => ln_per_comment_id,
         p_assignment_sequence       => ln_assignment_sequence,
         p_assignment_number         => lv_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
      );      
        
  DBMS_OUTPUT.PUT_LINE('p_employee_number '|| lv_employee_number);
  DBMS_OUTPUT.PUT_LINE('p_person_id '|| ln_person_id);
  DBMS_OUTPUT.PUT_LINE('p_assignment_id '|| ln_assignment_id);
  DBMS_OUTPUT.PUT_LINE('p_per_object_version_number '|| ln_per_object_version_number);
  DBMS_OUTPUT.PUT_LINE('p_asg_object_version_number '|| ln_asg_object_version_number);
  DBMS_OUTPUT.PUT_LINE('p_per_effective_start_date '|| ld_per_effective_start_date);
  DBMS_OUTPUT.PUT_LINE('p_per_effective_end_date '|| ld_per_effective_end_date);
  DBMS_OUTPUT.PUT_LINE('p_full_name '|| lv_full_name);
  DBMS_OUTPUT.PUT_LINE('p_per_comment_id '|| ln_per_comment_id);
  DBMS_OUTPUT.PUT_LINE('p_assignment_sequence '|| ln_assignment_sequence);
  DBMS_OUTPUT.PUT_LINE('p_assignment_number '|| lv_assignment_number);
       
END;

p_employee_number 1234567
p_person_id 12345
p_assignment_id 130
p_per_object_version_number 2
p_asg_object_version_number 1
p_per_effective_start_date 29-MAY-20
p_per_effective_end_date 31-DEC-12
p_full_name SHARE, APPS ORACLE
p_per_comment_id 
p_assignment_sequence 
p_assignment_number 1234567