APPS.AME_ACTION_USAGES_API2 dependencies on DBMS_LOCK

Line 126: DBMS_LOCK.ALLOCATE_UNIQUE

122: ) as
123: X_LOCK_HANDLE varchar2(500);
124: X_RETURN_VALUE number;
125: begin
126: DBMS_LOCK.ALLOCATE_UNIQUE
127: (LOCKNAME =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
128: ,LOCKHANDLE => X_LOCK_HANDLE
129: );
130: X_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 130: X_RETURN_VALUE := DBMS_LOCK.REQUEST

126: DBMS_LOCK.ALLOCATE_UNIQUE
127: (LOCKNAME =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
128: ,LOCKHANDLE => X_LOCK_HANDLE
129: );
130: X_RETURN_VALUE := DBMS_LOCK.REQUEST
131: (LOCKHANDLE => X_LOCK_HANDLE
132: ,TIMEOUT => 0
133: ,RELEASE_ON_COMMIT => true);
134:

Line 182: DBMS_LOCK.ALLOCATE_UNIQUE

178: ) as
179: X_LOCK_HANDLE varchar2(500);
180: X_RETURN_VALUE number;
181: begin
182: DBMS_LOCK.ALLOCATE_UNIQUE
183: (LOCKNAME =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
184: ,LOCKHANDLE => X_LOCK_HANDLE
185: );
186: X_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 186: X_RETURN_VALUE := DBMS_LOCK.REQUEST

182: DBMS_LOCK.ALLOCATE_UNIQUE
183: (LOCKNAME =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
184: ,LOCKHANDLE => X_LOCK_HANDLE
185: );
186: X_RETURN_VALUE := DBMS_LOCK.REQUEST
187: (LOCKHANDLE => X_LOCK_HANDLE
188: ,TIMEOUT => 0
189: ,RELEASE_ON_COMMIT => true
190: );