2289: WHERE location_extra_info_id = l_location_extra_info_id;
2290: END;--Local3
2291:
2292: BEGIN --Local4
2293: hr_location_extra_info_api.delete_location_extra_info
2294: (p_validate => false -- true
2295: ,p_location_extra_info_id => l_location_extra_info_id
2296: ,p_object_version_number => l_object_version_number
2297: );
2310: (which => fnd_file.log,
2311: buff => 'need to create new eit');
2312:
2313: BEGIN--Local5
2314: hr_location_extra_info_api.create_location_extra_info
2315: (p_validate => false -- true
2316: ,p_location_id => l_location_id
2317: ,p_information_type => 'EEO-1 Archive Information'
2318: ,p_lei_information_category => 'EEO-1 Archive Information'
2389: AND information_type = 'EEO-1 Archive Information'
2390: AND location_id = l_location_id;
2391: END;--Local9
2392: BEGIN--Local10
2393: hr_location_extra_info_api.delete_location_extra_info
2394: (p_validate => false -- true
2395: ,p_location_extra_info_id => l_location_extra_info_id
2396: ,p_object_version_number => l_object_version_number
2397: );