eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_ITEM_CLASSES_API dependencies on DBMS_LOCK

Line 298: DBMS_LOCK.ALLOCATE_UNIQUE

294: X_LOCK_HANDLE varchar2(500);
295: X_RETURN_VALUE number;
296: begin
297: -- retrieve information for the current row
298: DBMS_LOCK.ALLOCATE_UNIQUE
299: (LOCKNAME =>'AME_ITEM_CLASSES.'||X_ITEM_CLASS_NAME
300: ,LOCKHANDLE => X_LOCK_HANDLE
301: );
302: X_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 302: X_RETURN_VALUE := DBMS_LOCK.REQUEST

298: DBMS_LOCK.ALLOCATE_UNIQUE
299: (LOCKNAME =>'AME_ITEM_CLASSES.'||X_ITEM_CLASS_NAME
300: ,LOCKHANDLE => X_LOCK_HANDLE
301: );
302: X_RETURN_VALUE := DBMS_LOCK.REQUEST
303: (LOCKHANDLE => X_LOCK_HANDLE
304: ,TIMEOUT => 0
305: ,RELEASE_ON_COMMIT => true);
306: if X_RETURN_VALUE = 0 then