APPS.AME_ATTRIBUTE_USAGES_API dependencies on DBMS_LOCK

Line 884: DBMS_LOCK.ALLOCATE_UNIQUE

880: X_CURRENT_OWNER,
881: X_LAST_UPDATE_DATE,
882: X_CURRENT_LAST_UPDATE_DATE) then
883:
884: DBMS_LOCK.ALLOCATE_UNIQUE
885: (LOCKNAME =>'AME_ATU.'||X_ATTRIBUTE_ID||'.'||X_APPLICATION_ID
886: ,LOCKHANDLE => X_LOCK_HANDLE
887: );
888: X_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 888: X_RETURN_VALUE := DBMS_LOCK.REQUEST

884: DBMS_LOCK.ALLOCATE_UNIQUE
885: (LOCKNAME =>'AME_ATU.'||X_ATTRIBUTE_ID||'.'||X_APPLICATION_ID
886: ,LOCKHANDLE => X_LOCK_HANDLE
887: );
888: X_RETURN_VALUE := DBMS_LOCK.REQUEST
889: (LOCKHANDLE => X_LOCK_HANDLE
890: ,TIMEOUT => 0
891: ,RELEASE_ON_COMMIT => true);
892: if X_RETURN_VALUE = 0 then