APPS.PA_DEBUG dependencies on DBMS_LOCK

Line 143: -- dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut); /* Bug#2289946 */

139:
140:
141: /* get lock handle for user lock */
142:
143: -- dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut); /* Bug#2289946 */
144:
145: dbms_lock.allocate_unique(x_lock_name,lockhndl,lTimeOut); /* Bug#2289946 */
146:
147: IF ( lockhndl IS NOT NULL ) THEN

Line 145: dbms_lock.allocate_unique(x_lock_name,lockhndl,lTimeOut); /* Bug#2289946 */

141: /* get lock handle for user lock */
142:
143: -- dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut); /* Bug#2289946 */
144:
145: dbms_lock.allocate_unique(x_lock_name,lockhndl,lTimeOut); /* Bug#2289946 */
146:
147: IF ( lockhndl IS NOT NULL ) THEN
148: /* Get the lock, do not release the lock on commit */
149:

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

146:
147: IF ( lockhndl IS NOT NULL ) THEN
148: /* Get the lock, do not release the lock on commit */
149:
150: lstatus := dbms_lock.request(lockhndl,
151: NVL(x_lock_mode,G_LockMode),
152: G_TimeOut,
153: NVL(x_commit_mode,G_CommitMode));
154:

Line 211: -- dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut); /* Bug#2289946 */

207: /* Bug#2289946 -- End */
208:
209: /* get lock handle for user lock */
210:
211: -- dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut); /* Bug#2289946 */
212:
213: dbms_lock.allocate_unique(x_lock_name,lockhndl,lTimeOut); /* Bug#2289946 */
214:
215: IF ( lockhndl IS NOT NULL ) THEN

Line 213: dbms_lock.allocate_unique(x_lock_name,lockhndl,lTimeOut); /* Bug#2289946 */

209: /* get lock handle for user lock */
210:
211: -- dbms_lock.allocate_unique(x_lock_name,lockhndl,G_TimeOut); /* Bug#2289946 */
212:
213: dbms_lock.allocate_unique(x_lock_name,lockhndl,lTimeOut); /* Bug#2289946 */
214:
215: IF ( lockhndl IS NOT NULL ) THEN
216: /* Release the Lock */
217:

Line 218: lstatus := dbms_lock.RELEASE(lockhndl);

214:
215: IF ( lockhndl IS NOT NULL ) THEN
216: /* Release the Lock */
217:
218: lstatus := dbms_lock.RELEASE(lockhndl);
219:
220: IF ( lstatus = 0 ) THEN /* Lock Released */
221: RETURN 0;
222: ELSE