Error executing hr_grade_rate_value_api.update_grade_rate_value
I am attempting to update Grade Rate Values using the hr_grade_rate_value_api.update_grade_rate_value API and I get a strange error. I can successfully create Grade Rate Values using the create_grade_rate_value API.
Any help would be appreciated.
Thanks, Keith
DECLARE
l_effective_start_date DATE;
l_effective_end_date DATE;
g_effective_date DATE := TO_DATE('2010-04-01', 'yyyy-mm-dd');
--Global variables
g_datetrack_update_mode VARCHAR2(20) := 'Update';
g_grade_rule_id NUMBER := 440;
g_object_version_number NUMBER := 1;
g_value VARCHAR2(20);
g_rate_id NUMBER;
g_grade_id NUMBER;