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;
mmorpg oyunlar
ReplyDeleteinstagram takipçi satın al
tiktok jeton hilesi
tiktok jeton hilesi
saç ekimi antalya
Takipci
instagram takipçi satın al
Metin2 Pvp Serverler
TAKİPCİ SATİN AL
perde modelleri
ReplyDeletesms onay
mobil ödeme bozdurma
nft nasıl alınır
Ankara Evden Eve Nakliyat
TRAFİK SİGORTASİ
dedektör
WEB SİTESİ KURMAK
aşk kitapları
smm panel
ReplyDeleteSMM PANEL
iş ilanları
instagram takipçi satın al
HİRDAVATCİ
HTTPS://WWW.BEYAZESYATEKNİKSERVİSİ.COM.TR
servis
JETON HİLE