Total Pageviews

Friday, July 21, 2017

Creating Locations Using API Oracle Apps

Using API creating Location in Oracle Apps from backend 


API :hr_location_api.create_location

declare
l_validate boolean := false
;l_effective_date date := to_date('01-JAN-2008','DD-MON-YYYY')
;l_location_code varchar2(20) := '1234'
;l_address_line_1 varchar2(50) := '#1234, XXXXX'
;l_address_line_2 varchar2(50) := 'Adarsh Nagar'
;l_address_line_3 varchar2(50) := 'Hyderabad'
;l_location_id number
;l_business_group_id number := null
;l_object_version_number number;
begin
hr_location_api.create_location
(p_validate => l_validate
,p_effective_date => l_effective_date
,p_location_code => l_location_code
,p_address_line_1 => l_address_line_1
,p_address_line_2 => l_address_line_2
,p_address_line_3 => l_address_line_3
,p_location_id => l_location_id
,p_business_group_id => l_business_group_id
,p_object_version_number => l_object_version_number
,p_description => 'Loaded by API'
,p_inactive_date => '01-JAN-2010'
,p_style =>'US_GLB'
);
dbms_output.put_line(l_location_id);
END;

3 comments: