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

Oracle ebusiness Suite

  • Home
  • Oracle ebusiness Suite
  • HRMS Positions Migration in Oracle Applications

HRMS Positions Migration in Oracle Applications

  • Posted by Sameh Bakkar
  • Categories Oracle ebusiness Suite, Oracle HCM
  • Date March 19, 2011
  • Comments 0 comment
Hi fans, welcome to Appslead . Today we will learn  how to use APIs to create position in  Oracle applications (EBS).
Declare
       l_rows_processed   NUMBER := 0;
       l_commit_point     NUMBER := 250;
       l_batch_run_number hr_api_batch_message_lines.batch_run_number%TYPE;
       l_dummy_line_id    hr_api_batch_message_lines.line_id%TYPE;
       l_sequence         NUMBER := 0;
       V_job_id  number  := 62;
       --------------------
       -- Out Parameters --
       --------------------
       l_position_id            NUMBER;
       l_object_version_number  NUMBER;
       l_position_definition_id NUMBER;
       l_name                   VARCHAR2(1000);
       V_Error   varchar2(3000);
       --
Cursor Pos is 
    select * from temp_positions
    where upload_status = 'N';

BEGIN
       FOR i  IN pos LOOP
              BEGIN
                     l_position_id            := NULL;
                     l_object_version_number  := NULL;
                     l_position_definition_id := NULL;
                     l_name                   := NULL;
                     --
                     hr_position_api.create_position(p_validate               => FALSE
                                                    ,p_job_id                 => 62
                                                    ,p_organization_id        => 81
                                                    ,p_date_effective         => to_date(sysdate,'DD/MM/RRRR')
                                                    ,p_segment1               => i.position_grade
                                                    ,p_segment2               => i.position_name
                                                    ,p_segment3               => i.position_code
                                                    ,p_segment4               => i.ORGANIZARION
                                                    ,p_segment5               => i.position_number
                                                    ,p_location_id            => 143
                                                    ,p_concat_segments =>i.position_grade||'-'||i.position_name||'-'||i.position_code||'-'||i.ORGANIZARION||'-'||i.position_number
                                                    ,p_position_id            => l_position_id
                                                    ,p_status                 => i.position_status
                                                    ,p_object_version_number  => l_object_version_number
                                                    ,p_position_definition_id => l_position_definition_id
                                                    ,p_name                   => l_name);
                                                  
                     Commit;
                     update temp_positions
                     set    upload_status = 'Y'
                     where  serial = i.serial;
                     Commit;
                     dbms_output.put_line('Done');
  
              EXCEPTION
                     WHEN OTHERS THEN
                     
                      V_Error  := SQLERRM;
                      
                                           Commit;
                     update temp_positions
                     set    upload_status = 'N' , error_mess = V_Error
                     where  serial = i.serial;
                     Commit;
                      dbms_output.put_line(v_error);
              END;
       END LOOP;
END ;
 
  I hope find it useful for you. If you like it please share and don’t hesitate to leave comment for any question.
  • 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 Positions API
March 19, 2011

Next post

HRMS GOSI Migration
19 March, 2011

You may also like

  • How to call REST Web service from Oracle Scale System
    11 April, 2017
  • How To Set a Default Sequence For Invoice Number in Oracle Payables application
    8 April, 2017
  • How to use user hook on oracle applications (EBS)
    7 April, 2017

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