DBA Data[Home] [Help]

APPS.AME_ACTION_USAGES_API dependencies on DBMS_LOCK

Line 253: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID

249: is
250: lockHandle varchar2(500);
251: returnValue integer;
252: begin
253: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
254: ,lockhandle => lockHandle);
255: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0
256: ,release_on_commit => true);
257: if returnValue = 0 then

Line 255: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0

251: returnValue integer;
252: begin
253: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
254: ,lockhandle => lockHandle);
255: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0
256: ,release_on_commit => true);
257: if returnValue = 0 then
258: insert into AME_ACTION_USAGES
259: (