Unable to perform Date track update with update_gb_emp_asg API
I have a requirement to perform date track update on ass_attribute16 (Assignment DFF) for some 600 employees.
I am using the below code to call the API to make the update. Requirement is to make the changes effective from 01-AUG-2010. So i need to get all the employees who were active as on 01-AUG-2010 as well as those who are active after the same date.
Please review the code and let me know your ideas.
SET serveroutput ON SIZE 1000000 FORMAT WRAPPED
SET verify OFF
SET feedback OFF
DECLARE
l_validate BOOLEAN:= TRUE;
l_effective_date DATE:= to_date('01-AUG-10');