APPS.MTH_UTIL_PKG dependencies on DBMS_LOCK

Line 845: * lock with p_key_table as the key using rdbms_lock package. The current *

841:
842: /* ****************************************************************************
843: * Procedure :request_lock *
844: * Description :This procedure is used to request an exclusive *
845: * lock with p_key_table as the key using rdbms_lock package. The current *
846: * will wait indifinitely if the lock was held by others until the release *
847: * of the lock. *
848: * File Name :MTHUTILB.PLS *
849: * Visibility :Private *

Line 867: dbms_lock.allocate_unique(p_key_table, v_lockhandle);

863: PROCEDURE request_lock(p_key_table IN VARCHAR2, p_retval OUT NOCOPY INTEGER)
864: IS
865: v_lockhandle VARCHAR2(200);
866: BEGIN
867: dbms_lock.allocate_unique(p_key_table, v_lockhandle);
868: p_retval := dbms_lock.request(v_lockhandle, dbms_lock.x_mode);
869: END request_lock;
870:
871: /* ****************************************************************************

Line 868: p_retval := dbms_lock.request(v_lockhandle, dbms_lock.x_mode);

864: IS
865: v_lockhandle VARCHAR2(200);
866: BEGIN
867: dbms_lock.allocate_unique(p_key_table, v_lockhandle);
868: p_retval := dbms_lock.request(v_lockhandle, dbms_lock.x_mode);
869: END request_lock;
870:
871: /* ****************************************************************************
872: * Procedure :generate_new_time_range *