DBA Data[Home] [Help]

APPS.AME_PRODUCTION_ACTIONS_API dependencies on DBMS_LOCK

Line 135: DBMS_LOCK.ALLOCATE_UNIQUE

131: X_LOCK_HANDLE varchar2(500);
132: X_RETURN_VALUE number;
133: begin
134:
135: DBMS_LOCK.ALLOCATE_UNIQUE
136: (LOCKNAME =>'AME_ACTIONS.'||X_ACTION_ID
137: ,LOCKHANDLE => X_LOCK_HANDLE
138: );
139: X_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 139: X_RETURN_VALUE := DBMS_LOCK.REQUEST

135: DBMS_LOCK.ALLOCATE_UNIQUE
136: (LOCKNAME =>'AME_ACTIONS.'||X_ACTION_ID
137: ,LOCKHANDLE => X_LOCK_HANDLE
138: );
139: X_RETURN_VALUE := DBMS_LOCK.REQUEST
140: (LOCKHANDLE => X_LOCK_HANDLE
141: ,TIMEOUT => 0
142: ,RELEASE_ON_COMMIT => true);
143: