Have any question?
+2 0100 62 62 837
[email protected]
Register Login

Login with your site account

Lost your password?

Not a member yet? Register now

AppsLead | Learn Oracle From The LeadersAppsLead | Learn Oracle From The Leaders
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us

Blog

  • Home
  • Blog
  • HRMS Re-Hire EX Employee API

HRMS Re-Hire EX Employee API

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date March 19, 2011
  • Comments 0 comment
Hi guys today we will explain HRMS Re-Hire EX Employee API
Create Or replace procedure KFU_re_hire_ex_employee ( V_Person_ID Number, Re_Hire_Date  Date )
is
p_validate                    boolean  default false   ;
p_hire_date                   date           ;
p_person_id                   number        ;
p_per_object_version_number   number  ;
p_person_type_id              number ;
p_rehire_reason               varchar2  (100);
V_object_version_number       number;
------------------------------------------------------------------------------------
p_assignment_id               number;
p_asg_object_version_number   number;
p_per_effective_start_date    date;
p_per_effective_end_date      date;
p_assignment_sequence         number;
p_assignment_number           varchar2 (100);
p_assign_payroll_warning      boolean;

Begin


SELECT MAX (object_version_number)
INTO  V_object_version_number
FROM  per_all_people_f
WHERE person_id = V_Person_ID
and   PERSON_TYPE_ID =1123;

hr_employee_api.re_hire_ex_employee
(p_validate  =>  false ,
p_hire_date                       => to_date( Re_Hire_Date ,'DD/MM/RRRR'),
p_person_id                       => V_Person_ID ,
p_per_object_version_number       => V_object_version_number,
p_person_type_id                  => 1120,
p_rehire_reason                   => Null,
------------------------------------------------------------------------------------------
p_assignment_id                   => p_assignment_id,
p_asg_object_version_number       => p_asg_object_version_number,
p_per_effective_start_date        => p_per_effective_start_date,
p_per_effective_end_date          => p_per_effective_end_date,
p_assignment_sequence             => p_assignment_sequence,
p_assignment_number               => p_assignment_number,
p_assign_payroll_warning          => p_assign_payroll_warning

) ;
Commit;

End;

 

 

Tag:API, HRMS, Re-Hire EX Employee API

  • Share:
Admin bar avatar
Sameh Bakkar
Sameh Bakkar has over 15 years Oracle Applications implementation experience (EBS/Fusion) and he is an Oracle authorized trainer. He has in-depth technical and Functional knowledge of Oracle Applications and Oracle HCM Cloud. Sameh has excellent experience in Team management, Man Power and resource planning, and Pre-Sales management Process. Additionally he has also given Best Practices seminars on Oracle e-business suite and Oracle Fusion.

Previous post

HRMS Delete Employee API
March 19, 2011

Next post

HRMS Update Employee's Hire Date
19 March, 2011

You may also like

  • Entering Request for Quotations (RFQ)
    19 June, 2012
  • HRMS Assignment Migration – API
    9 March, 2011

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Categories

  • Blog
  • Oracle ebusiness Suite
  • Oracle Financial
  • Oracle HCM
  • Oracle SCM

Latest Courses

R12.x Oracle E-Business Suite Essentials for Implementers

R12.x Oracle E-Business Suite Essentials for Implementers

Free
R12.x Oracle HRMS Work Structures Fundamentals

R12.x Oracle HRMS Work Structures Fundamentals

Free
R12.x Oracle Payroll Fundamentals

R12.x Oracle Payroll Fundamentals

Free
AppsLead | Learn Oracle From The Leaders

+2 0100 62 62 837

[email protected]

Company

  • About Us
  • Blog
  • Contact Us

Links

  • Events

Copyright © 2017 AppsLead, All rights reserved. Developed by ECDSCS Co.

  • Privacy
  • Terms
  • Sitemap