![Simple Script to load the HR Locations using API,AskHareesh Blog for OracleApps](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9B3gU6LRXo6TXCZMnWKgNO_Xyzj9y4xgUlqlnKUrvTrxpnbD_zMsBz13vcceA3WjVbpobPrBkuCu_rMT1-ky4URC1cHvxX056Sd-2pxvBtMKKa-CnqcCj9Lyh_dPeGMmq7-ru0LX8Lew/s1600/Simple+Script+to+load+the+HR+Locations+using+API.png)
Simple Script to load the HR Locations using API
DECLARE
l_location_id NUMBER;
l_object_version_number NUMBER;
BEGIN
apps.hr_location_api.create_location (
p_effective_date => SYSDATE,
p_location_code => 'XX_LOCATION',
p_description => 'XX Location',
p_address_line_1 => 'XX Avenue',
p_country => 'US',
p_postal_code => '6442',
p_telephone_number_1 => '7587612050',
p_town_or_city => 'XX',
p_business_group_id => '0',
p_style => 'US_GLB',
p_location_id => l_location_id,
p_object_version_number => l_object_version_number);
COMMIT;
END;
No comments:
Post a Comment