APPS.AME_ATTRIBUTES_API dependencies on DBMS_LOCK

Line 148: DBMS_LOCK.ALLOCATE_UNIQUE

144: X_ATTRIBUTE_ID number;
145: X_LOCK_HANDLE varchar2(500);
146: X_RETURN_VALUE number;
147: begin
148: DBMS_LOCK.ALLOCATE_UNIQUE
149: (LOCKNAME =>'AME_ATTRIBUTES.'||X_ATTRIBUTE_NAME
150: ,LOCKHANDLE => X_LOCK_HANDLE
151: );
152: X_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 152: X_RETURN_VALUE := DBMS_LOCK.REQUEST

148: DBMS_LOCK.ALLOCATE_UNIQUE
149: (LOCKNAME =>'AME_ATTRIBUTES.'||X_ATTRIBUTE_NAME
150: ,LOCKHANDLE => X_LOCK_HANDLE
151: );
152: X_RETURN_VALUE := DBMS_LOCK.REQUEST
153: (LOCKHANDLE => X_LOCK_HANDLE
154: ,TIMEOUT => 0
155: ,RELEASE_ON_COMMIT => true);
156:

Line 252: DBMS_LOCK.ALLOCATE_UNIQUE

248: X_RETURN_VALUE number;
249: l_current_start_date date;
250: begin
251:
252: DBMS_LOCK.ALLOCATE_UNIQUE
253: (LOCKNAME =>'AME_ATTRIBUTES.'||X_ATTRIBUTE_ID
254: ,LOCKHANDLE => X_LOCK_HANDLE
255: );
256: X_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 256: X_RETURN_VALUE := DBMS_LOCK.REQUEST

252: DBMS_LOCK.ALLOCATE_UNIQUE
253: (LOCKNAME =>'AME_ATTRIBUTES.'||X_ATTRIBUTE_ID
254: ,LOCKHANDLE => X_LOCK_HANDLE
255: );
256: X_RETURN_VALUE := DBMS_LOCK.REQUEST
257: (LOCKHANDLE => X_LOCK_HANDLE
258: ,TIMEOUT => 0
259: ,RELEASE_ON_COMMIT => true);
260: