Move child range from one parent hierarchy to another parent hierarchy

 Hello Gurus,

I am trying to replicate the Move child flex values from one parent hierarchy to another parent hierarchy using Oracle standard APIs. From Oracle apps, the process is loginto Sys Admin responsibility --> Application --> Validation -->Values,

enter the value set name and value. Once the flex value is opened, click on it and click the tab "Move Child Ranges". You need to select destination parent hierarchy and child range that needs to be moved. When you click Move, it moves the child range from source parent hierarchy to target parent hierarchy. The table which stores the source child range flex values is fnd_flex_value_norm_hierarchy and after the move process, the data gets deleted from this table for the source parent hierarchy. Now, I am trying to do the same using Oracle standard API, I tried using the