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 Update Employee’s Hire Date

HRMS Update Employee’s Hire Date

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date March 19, 2011
  • Comments 0 comment
Hi guys today we will explain HRMS Update Employee’s Hire Date

DECLARE
v_api_error        VARCHAR2 (5000);
v_error_msg        VARCHAR2 (5000) := NULL;
p_person_id        NUMBER;
----------------------------------
p_validate         BOOLEAN;
p_effective_date   DATE;
p_warn_ee          VARCHAR2 (5000);
BEGIN
FOR hr_data IN (SELECT *
FROM XX_emps
where  emp_old_no not in( '2013' , '580789'))
--                    WHERE NVL (xx.emp_data, 'T_Error') 'Done')
LOOP
BEGIN
p_validate := FALSE;

SELECT person_id, effective_start_date
INTO p_person_id, p_effective_date
FROM per_all_people_f
WHERE attribute1 = hr_data.emp_old_no
AND effective_end_date > SYSDATE;

hr_change_start_date_api.update_start_date
(p_validate            => p_validate,
p_person_id           => p_person_id,
p_old_start_date      => p_effective_date,
p_new_start_date      => to_date(hr_data.hire_date,'DD-MM-RRRR'),
p_update_type         => 'E',
p_warn_ee             => p_warn_ee
);

UPDATE xx_emps
SET
error_msg = null,
status = 'Done'
WHERE emp_old_no = hr_data.emp_old_no;
EXCEPTION
WHEN OTHERS
THEN
p_validate := NULL;
p_effective_date := NULL;
p_person_id := NULL;
v_api_error := NULL;
v_error_msg := NULL;
v_api_error := SQLERRM;

v_error_msg := v_api_error;

UPDATE xx_emps
SET error_msg = v_error_msg,
status = 'Error'
WHERE emp_old_no = hr_data.emp_old_no;

COMMIT;
END;

COMMIT;
END LOOP;
END;

Tag:HRMS, Update Employee's Hire Date

  • 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 Re-Hire EX Employee API
March 19, 2011

Next post

HRMS Employee Migration In Oracle Applications
19 March, 2011

Leave A Reply Cancel reply

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

Search

Categories

  • Blog
  • Fusion HCM
  • Oracle ebusiness Suite
  • Oracle Financial
  • Oracle Fusion
  • 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