APPS.GL_FLEX_INSERT_PKG dependencies on DBMS_LOCK

Line 229: dbms_lock.allocate_unique(lockname, lockhandle);

225: PROCEDURE allocate_lock(lockname IN VARCHAR2,
226: lockhandle OUT NOCOPY VARCHAR2) IS
227: PRAGMA AUTONOMOUS_TRANSACTION; -- Bug 5074981
228: BEGIN
229: dbms_lock.allocate_unique(lockname, lockhandle);
230: END allocate_lock;
231:
232: /* ----------------------------------------------------------------------- */
233: /* */

Line 538: retval := dbms_lock.request(lockhandle,4,32767,FALSE);

534:
535: end if;
536:
537: allocate_lock('GL_BC_SUMMARY_TEMPLATES'||coaid, lockhandle); -- Bug 5074981
538: retval := dbms_lock.request(lockhandle,4,32767,FALSE);
539:
540: -- ========================= FND LOG ===========================
541: psa_utils.debug_other_string(g_state_level,l_full_path,' retval -> ' || retval);
542: -- ========================= FND LOG ===========================

Line 552: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling dbms_lock.sleep');

548: -- ========================= FND LOG ===========================
549:
550: elsif(retval = 1)then
551: -- ========================= FND LOG ===========================
552: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling dbms_lock.sleep');
553: -- ========================= FND LOG ===========================
554: dbms_lock.sleep(15);
555:
556: else

Line 554: dbms_lock.sleep(15);

550: elsif(retval = 1)then
551: -- ========================= FND LOG ===========================
552: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling dbms_lock.sleep');
553: -- ========================= FND LOG ===========================
554: dbms_lock.sleep(15);
555:
556: else
557: -- ========================= FND LOG ===========================
558: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN FALSE');

Line 673: retval := dbms_lock.release(lockhandle);

669:
670: -- Release the budgetary control user name lock after maintaining the
671: -- account hierarchies.
672:
673: retval := dbms_lock.release(lockhandle);
674:
675: -- ========================= FND LOG ===========================
676: psa_utils.debug_other_string(g_state_level,l_full_path,
677: ' retval -> ' || retval);