EBS开发_创建员工

-- Create Employee
-- -------------------------


--以下脚本于20180115在Tony环境实现


--初始化
/*
begin
  fnd_global.apps_initialize(user_id      => 1110,
                             resp_id      => 50597,
                             resp_appl_id => 20003);
  mo_global.init('M');
end;
*/


DECLARE
  lc_employee_number   PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;-- := 'WRKNO1000001';
  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;


  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;
  lc_full_name                PER_ALL_PEOPLE_F.FULL