DBA Data[Home] [Help]

APPS.AME_APPROVAL_GROUPS_LOAD_API dependencies on DBMS_LOCK

Line 437: DBMS_LOCK.ALLOCATE_UNIQUE

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

Line 441: returnValue := DBMS_LOCK.REQUEST

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