Oracle Apps Knowledge Sharing

API: HR_POSITION_API.UPDATE_POSITION

Tested Instance: R12.2.4

Table Name: PER_ALL_POSITIONS

FYR: Create Position Script - http://www.shareoracleapps.com/2018/03/api-to-create-employee-positions-in-oracle-apps-hrpositionapi.html

Delete Position Script - http://www.shareoracleapps.com/2020/06/api-to-delete-employee-positions-in-oracle-apps-r12-hrpositionapi-deleteposition.html

Script:

DECLARE

  lv_position_name            VARCHAR2(500);
  lb_dummy_bool               BOOLEAN;
  ln_position_definition_id   NUMBER;
  ln_object_version_number    NUMBER;
  ln_position_id              NUMBER;
  lc_comments                 CLOB;

BEGIN

  lc_comments               := 'Test Update Comments';
  ln_object_version_number  := 3;
  ln_position_id            := 421075;  

  hr_position_api.update_position

     ( p_validate                     => FALSE,
       p_position_id                  => ln_position_id,
       p_object_version_number        => ln_object_version_number,
       p_comments                     => lc_comments,
       p_position_definition_id       => ln_position_definition_id,
       p_name                         => lv_position_name,
       p_valid_grades_changed_warning => lb_dummy_bool
     );

  DBMS_OUTPUT.PUT_LINE(ln_position_id);                                  

END;