APPS.AD_EVENT_REGISTRY_PKG dependencies on AD_LOCK_UTILS_PKG

Line 124: AD_LOCK_UTILS_PKG.Get_Lock(

120: END LOOP ;
121: END IF ;
122:
123: -- Get the named lock.
124: AD_LOCK_UTILS_PKG.Get_Lock(
125: p_LockName => l_LockName,
126: p_LockMode => EVENT_LOCK_MODE,
127: p_Release_On_Commit => RELEASE_COMMIT_CONST,
128: x_LockHandle => g_Event_LockHandle);

Line 526: AD_LOCK_UTILS_PKG.Release_Lock(

522:
523: --
524: -- Release the lock
525: --
526: AD_LOCK_UTILS_PKG.Release_Lock(
527: p_LockHandle => g_Event_LockHandle);
528:
529: g_Event_LockHandle := NULL ;
530:

Line 535: AD_LOCK_UTILS_PKG.Release_Lock(

531: EXCEPTION
532: WHEN OTHERS THEN
533: IF ( g_Event_LockHandle IS NOT NULL ) THEN
534: BEGIN -- begin for release lock
535: AD_LOCK_UTILS_PKG.Release_Lock(
536: p_LockHandle => g_Event_LockHandle);
537: g_Event_LockHandle := NULL ;
538: EXCEPTION
539: WHEN OTHERS THEN

Line 840: AD_LOCK_UTILS_PKG.Release_Lock(

836: -- Release the lock.
837: -- The lock is released only after doing all the DMLs
838: -- and the commit
839: --
840: AD_LOCK_UTILS_PKG.Release_Lock(
841: p_LockHandle => g_Event_LockHandle);
842:
843: g_Event_LockHandle := NULL ;
844:

Line 853: AD_LOCK_UTILS_PKG.Release_Lock(

849: EXCEPTION
850: WHEN OTHERS THEN
851: IF ( g_Event_LockHandle IS NOT NULL ) THEN
852: BEGIN -- begin for release lock
853: AD_LOCK_UTILS_PKG.Release_Lock(
854: p_LockHandle => g_Event_LockHandle);
855: g_Event_LockHandle := NULL ;
856: EXCEPTION
857: WHEN OTHERS THEN

Line 1250: AD_LOCK_UTILS_PKG.Release_Lock(

1246:
1247: -- commit the transaction here
1248: COMMIT;
1249: -- Release the lock.
1250: AD_LOCK_UTILS_PKG.Release_Lock(
1251: p_LockHandle => g_Event_LockHandle);
1252:
1253: g_Event_LockHandle := NULL ;
1254:

Line 1259: AD_LOCK_UTILS_PKG.Release_Lock(

1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: IF ( g_Event_LockHandle IS NOT NULL ) THEN
1258: BEGIN -- begin for release lock
1259: AD_LOCK_UTILS_PKG.Release_Lock(
1260: p_LockHandle => g_Event_LockHandle);
1261: g_Event_LockHandle := NULL ;
1262: EXCEPTION
1263: WHEN OTHERS THEN

Line 1359: AD_LOCK_UTILS_PKG.Release_Lock(

1355:
1356: --
1357: -- Release the lock.
1358: --
1359: AD_LOCK_UTILS_PKG.Release_Lock(
1360: p_LockHandle => g_Event_LockHandle);
1361: g_Event_LockHandle := NULL ;
1362:
1363: -- Get the index pointing to the event from the global event list

Line 1380: AD_LOCK_UTILS_PKG.Release_Lock(

1376: EXCEPTION
1377: WHEN OTHERS THEN
1378: IF ( g_Event_LockHandle IS NOT NULL ) THEN
1379: BEGIN -- begin for release lock
1380: AD_LOCK_UTILS_PKG.Release_Lock(
1381: p_LockHandle => g_Event_LockHandle);
1382: g_Event_LockHandle := NULL ;
1383: EXCEPTION
1384: WHEN OTHERS THEN

Line 1815: AD_LOCK_UTILS_PKG.Release_Lock(

1811: END IF ;
1812: --
1813: -- Release the lock
1814: --
1815: AD_LOCK_UTILS_PKG.Release_Lock(
1816: p_LockHandle => g_Event_LockHandle);
1817: g_Event_LockHandle := NULL ;
1818:
1819: EXCEPTION

Line 1823: AD_LOCK_UTILS_PKG.Release_Lock(

1819: EXCEPTION
1820: WHEN OTHERS THEN
1821: IF ( g_Event_LockHandle IS NOT NULL ) THEN
1822: BEGIN -- begin for release lock
1823: AD_LOCK_UTILS_PKG.Release_Lock(
1824: p_LockHandle => g_Event_LockHandle);
1825: g_Event_LockHandle := NULL ;
1826: EXCEPTION
1827: WHEN OTHERS THEN