DBA Data[Home] [Help]

APPS.XDP_ADAPTER_CORE_DB dependencies on DBMS_LOCK

Line 746: l_Status := DBMS_LOCK.REQUEST(lockhandle=> l_LockHandle,

742:
743: begin
744: l_LockHandle := ObtainHandle(p_ChannelName => p_ChannelName);
745:
746: l_Status := DBMS_LOCK.REQUEST(lockhandle=> l_LockHandle,
747: timeout => p_Timeout,
748: lockmode => 6);
749:
750: if l_Status in(0, 4) then

Line 825: l_Status := DBMS_LOCK.RELEASE(lockhandle => l_LockHandle);

821:
822: begin
823: l_LockHandle := ObtainHandle(ReleaseAdapterLock.p_ChannelName);
824:
825: l_Status := DBMS_LOCK.RELEASE(lockhandle => l_LockHandle);
826:
827: if l_Status in (0, 4) then
828: return 'Y';
829: else

Line 878: DBMS_LOCK.ALLOCATE_UNIQUE(lockname => ObtainHandle.p_ChannelName,

874:
875: l_LockHandle varchar2(240);
876: begin
877:
878: DBMS_LOCK.ALLOCATE_UNIQUE(lockname => ObtainHandle.p_ChannelName,
879: lockhandle => l_LockHandle);
880:
881: commit;
882: