DBA Data[Home] [Help]

APPS.AME_CONFIG_VARS_API dependencies on DBMS_LOCK

Line 106: DBMS_LOCK.ALLOCATE_UNIQUE

102: ) as
103: X_LOCK_HANDLE varchar2(500);
104: X_RETURN_VALUE number;
105: begin
106: DBMS_LOCK.ALLOCATE_UNIQUE
107: (LOCKNAME =>'AME_CONFIG_VARS.'||X_VARIABLE_NAME||X_APPLICATION_ID
108: ,LOCKHANDLE => X_LOCK_HANDLE
109: );
110: X_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 110: X_RETURN_VALUE := DBMS_LOCK.REQUEST

106: DBMS_LOCK.ALLOCATE_UNIQUE
107: (LOCKNAME =>'AME_CONFIG_VARS.'||X_VARIABLE_NAME||X_APPLICATION_ID
108: ,LOCKHANDLE => X_LOCK_HANDLE
109: );
110: X_RETURN_VALUE := DBMS_LOCK.REQUEST
111: (LOCKHANDLE => X_LOCK_HANDLE
112: ,TIMEOUT => 0
113: ,RELEASE_ON_COMMIT => true);
114:

Line 203: DBMS_LOCK.ALLOCATE_UNIQUE

199: X_LOCK_HANDLE varchar2(500);
200: X_RETURN_VALUE number;
201: begin
202:
203: DBMS_LOCK.ALLOCATE_UNIQUE
204: (LOCKNAME =>'AME_CONFIG_VARS.'||X_VARIABLE_NAME||to_char(nvl(X_APPLICATION_ID,0))
205: ,LOCKHANDLE => X_LOCK_HANDLE
206: );
207: X_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 207: X_RETURN_VALUE := DBMS_LOCK.REQUEST

203: DBMS_LOCK.ALLOCATE_UNIQUE
204: (LOCKNAME =>'AME_CONFIG_VARS.'||X_VARIABLE_NAME||to_char(nvl(X_APPLICATION_ID,0))
205: ,LOCKHANDLE => X_LOCK_HANDLE
206: );
207: X_RETURN_VALUE := DBMS_LOCK.REQUEST
208: (LOCKHANDLE => X_LOCK_HANDLE
209: ,TIMEOUT => 0
210: ,RELEASE_ON_COMMIT => true);
211: