DBA Data[Home] [Help]

APPS.EAM_DEBUG dependencies on DBMS_LOCK

Line 134: dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut);

130: END IF;
131:
132: /* get lock handle for user lock */
133:
134: dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut);
135:
136: IF ( lockhndl IS NOT NULL ) then
137: /* Get the lock, do not release the lock on commit */
138:

Line 139: lstatus := dbms_lock.request(lockhndl,

135:
136: IF ( lockhndl IS NOT NULL ) then
137: /* Get the lock, do not release the lock on commit */
138:
139: lstatus := dbms_lock.request(lockhndl,
140: NVL(x_lock_mode,G_LockMode),
141: G_TimeOut,
142: NVL(x_commit_mode,G_CommitMode));
143:

Line 191: dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut);

187: END IF;
188:
189: /* get lock handle for user lock */
190:
191: dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut);
192:
193: IF ( lockhndl IS NOT NULL ) then
194: /* Release the Lock */
195:

Line 196: lstatus := dbms_lock.release(lockhndl);

192:
193: IF ( lockhndl IS NOT NULL ) then
194: /* Release the Lock */
195:
196: lstatus := dbms_lock.release(lockhndl);
197:
198: IF ( lstatus = 0 ) then /* Lock Released */
199: Return 0;
200: ELSE