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 Assignment Extra Information API

HRMS Assignment Extra Information API

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date March 20, 2011
  • Comments 0 comment
Hi guys today we will explain HRMS Assignment Extra Information API
DECLARE
v_person_id       NUMBER;
v_assignment_id   NUMBER;
v_extra           NUMBER;
v_object          NUMBER;
v_api_error       VARCHAR (500);
v_errcode         NUMBER;

CURSOR c1
IS
SELECT *
FROM XX_EXTRA
WHERE valid_flag IS NULL
AND EMP_NO '25980' ;
BEGIN
FOR rec IN c1
LOOP
BEGIN
SELECT DISTINCT person_id
INTO v_person_id
FROM per_all_people_f a
WHERE employee_number = rec.emp_no
AND effective_end_date =
TO_DATE ('31/12/4712', 'DD/MM/RRRR');
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;

BEGIN
SELECT assignment_id
INTO v_assignment_id
FROM per_all_assignments_f
WHERE person_id = v_person_id AND effective_end_date =
TO_DATE ('31/12/4712', 'DD/MM/RRRR');
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;

BEGIN
hr_assignment_extra_info_api.create_assignment_extra_info
(p_assignment_id                 => v_assignment_id,
p_information_type              => 'EAME Assignments',
p_aei_attribute_category        => '',
p_aei_information_category      => 'EAME Assignments',

p_assignment_extra_info_id      => v_extra,
p_object_version_number         => v_object,

p_aei_information6              => rec.INFO6,
p_aei_information7              => rec.INFO7,
p_aei_information8              => rec.INFO8,
p_aei_information3              => rec.INFO3,
p_aei_information4              => rec.INFO4,
p_aei_information11             => rec.INFO11,
p_aei_information12             => rec.INFO12 );


COMMIT;

UPDATE XX_EXTRA
SET valid_flag = 'Y'
WHERE emp_no = rec.emp_no;

COMMIT;
EXCEPTION
WHEN OTHERS
THEN
v_api_error := SQLERRM;
v_errcode := SQLCODE;

UPDATE XX_EXTRA
SET valid_flag = 'N',
error_msg = v_api_error || ' ' || v_errcode
WHERE emp_no = rec.emp_no;

COMMIT;
END;
END LOOP;
END;

Tag:API, Assignment Extra Information API, HRMS

  • 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's Absence
March 20, 2011

Next post

HRMS Employee's Contract API
20 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