2422: WHERE location_extra_info_id = l_location_extra_info_id;
2423: END;--Local3
2424:
2425: BEGIN --Local4
2426: hr_location_extra_info_api.delete_location_extra_info
2427: (p_validate => false -- true
2428: ,p_location_extra_info_id => l_location_extra_info_id
2429: ,p_object_version_number => l_object_version_number
2430: );
2445:
2446: BEGIN--Local5
2447: -- Bug 7447266
2448: /*
2449: hr_location_extra_info_api.create_location_extra_info
2450: (p_validate => false -- true
2451: ,p_location_id => l_location_id
2452: ,p_information_type => 'EEO-1 Archive Information'
2453: ,p_lei_information_category => 'EEO-1 Archive Information'
2473: ,p_object_version_number => l_object_version_number
2474: );
2475: */
2476:
2477: hr_location_extra_info_api.create_location_extra_info
2478: (p_validate => false -- true
2479: ,p_location_id => l_location_id
2480: ,p_information_type => 'EEO-1 Archive Information'
2481: ,p_lei_information_category => 'EEO-1 Archive Information'
2553: AND information_type = 'EEO-1 Archive Information'
2554: AND location_id = l_location_id;
2555: END;--Local9
2556: BEGIN--Local10
2557: hr_location_extra_info_api.delete_location_extra_info
2558: (p_validate => false -- true
2559: ,p_location_extra_info_id => l_location_extra_info_id
2560: ,p_object_version_number => l_object_version_number
2561: );