APPS.PN_DEBUG dependencies on DBMS_LOCK

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

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

Line 144: dbms_lock.allocate_unique(x_lock_name,lockhndl,lTimeOut);

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

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

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

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

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

Line 212: dbms_lock.allocate_unique(x_lock_name,lockhndl,lTimeOut);

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

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

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