HR_POSITION_API.UPDATE_POSITION doesn't affect on PER_POSITION_DEFINITIONS table
Hi All,
Following code is written to update invalid position names affecting NAME column in hr_all_positions_f table and SEGMENT 15 (Designation),SEGMENT 20 (Track) columns in PER_POSITION_DEFINITIONS table. This code works perfectly for updating names but it does not update segment 15 and segment 20 columns. Issue remain same even with updates Flex values. I'm highly appreciated if anyone can give me some guidance to clarify my issue.
BEGIN
DECLARE
L_VALIDATE BOOLEAN := FALSE;
P_GRADES_VALUES BOOLEAN;
eit_p_position_name VARCHAR2(10000);
eit_object_version_number number;
eit_p_position_definition_id number;
l_start DATE;
l_end DATE;