DBA Data[Home] [Help]

APPS.AME_APPROVAL_GROUPS_LOAD_API dependencies on DBMS_LOCK

Line 439: DBMS_LOCK.ALLOCATE_UNIQUE

435: X_LAST_UPDATE_LOGIN NUMBER;
436: lockHandle varchar2(500);
437: returnValue integer;
438: begin
439: DBMS_LOCK.ALLOCATE_UNIQUE
440: (lockname =>'AME_APPROVAL_GROUPS.'||X_APPROVAL_GROUP_NAME
441: ,lockhandle => lockHandle
442: );
443: returnValue := DBMS_LOCK.REQUEST

Line 443: returnValue := DBMS_LOCK.REQUEST

439: DBMS_LOCK.ALLOCATE_UNIQUE
440: (lockname =>'AME_APPROVAL_GROUPS.'||X_APPROVAL_GROUP_NAME
441: ,lockhandle => lockHandle
442: );
443: returnValue := DBMS_LOCK.REQUEST
444: (lockhandle => lockHandle
445: ,timeout => 0
446: ,release_on_commit => true
447: );