APPS.FND_FLEX_LOADER_APIS dependencies on DBMS_LOCK

Line 884: dbms_lock.allocate_unique(lockname => p_lock_name,

880: x_lock_handle OUT nocopy VARCHAR2)
881: IS
882: PRAGMA AUTONOMOUS_TRANSACTION;
883: BEGIN
884: dbms_lock.allocate_unique(lockname => p_lock_name,
885: lockhandle => x_lock_handle,
886: expiration_secs => 1*24*60*60); -- 1 day.
887:
888: COMMIT;

Line 913: l_lock_status := dbms_lock.request(lockhandle => l_lock_handle,

909: 'Lock Handle : ' || l_lock_handle,
910: 'Requesting the lock. Sysdate: ' || To_char(Sysdate, g_date_mask));
911: END IF;
912:
913: l_lock_status := dbms_lock.request(lockhandle => l_lock_handle,
914: lockmode => dbms_lock.x_mode,
915: timeout => dbms_lock.maxwait,
916: release_on_commit => TRUE);
917:

Line 914: lockmode => dbms_lock.x_mode,

910: 'Requesting the lock. Sysdate: ' || To_char(Sysdate, g_date_mask));
911: END IF;
912:
913: l_lock_status := dbms_lock.request(lockhandle => l_lock_handle,
914: lockmode => dbms_lock.x_mode,
915: timeout => dbms_lock.maxwait,
916: release_on_commit => TRUE);
917:
918: IF (l_lock_status <> 0) THEN

Line 915: timeout => dbms_lock.maxwait,

911: END IF;
912:
913: l_lock_status := dbms_lock.request(lockhandle => l_lock_handle,
914: lockmode => dbms_lock.x_mode,
915: timeout => dbms_lock.maxwait,
916: release_on_commit => TRUE);
917:
918: IF (l_lock_status <> 0) THEN
919: raise_error(l_func_name, ERROR_UNABLE_TO_LOCK,

Line 921: '. dbms_lock.request() returned : ' ||

917:
918: IF (l_lock_status <> 0) THEN
919: raise_error(l_func_name, ERROR_UNABLE_TO_LOCK,
920: 'Unable to lock entity : ' || l_lock_name ||
921: '. dbms_lock.request() returned : ' ||
922: l_lock_status);
923: END IF;
924:
925: g_lock_handle := l_lock_handle;

Line 948: l_lock_status := dbms_lock.release(lockhandle => g_lock_handle);

944: 'Lock Handle : ' || g_lock_handle,
945: 'Releasing the lock. Sysdate: ' || To_char(Sysdate, g_date_mask));
946: END IF;
947:
948: l_lock_status := dbms_lock.release(lockhandle => g_lock_handle);
949:
950: IF (g_debug_on) THEN
951: debug(l_func_name, 'Released the lock. Release Status: ' || l_lock_status || ', Sysdate: ' || To_char(Sysdate, g_date_mask));
952: END IF;