Oracle Apps Knowledge Sharing

API: HR_POSITION_API.DELETE_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

Update Position Script -http://www.shareoracleapps.com/2020/06/api-to-update-employee-positions-in-oracle-apps-r12-hrpositionapi-updateposition.html

Script:

DECLARE
  ln_object_version_number    NUMBER;
  ln_position_id              NUMBER;
BEGIN
  ln_object_version_number  := 7;
  ln_position_id            := 421075; 

  hr_position_api.delete_position

     ( p_validate                     => FALSE,
       p_position_id                  => ln_position_id,
       p_object_version_number        => ln_object_version_number       
     );

  DBMS_OUTPUT.PUT_LINE(ln_position_id);                                  
END;