APPS.MTH_UTIL_PKG dependencies on DBMS_LOCK

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

861:
862: /* ****************************************************************************
863: * Procedure :request_lock *
864: * Description :This procedure is used to request an exclusive *
865: * lock with p_key_table as the key using rdbms_lock package. The current *
866: * will wait indifinitely if the lock was held by others until the release *
867: * of the lock. *
868: * File Name :MTHUTILB.PLS *
869: * Visibility :Private *

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

883: PROCEDURE request_lock(p_key_table IN VARCHAR2, p_retval OUT NOCOPY INTEGER)
884: IS
885: v_lockhandle VARCHAR2(200);
886: BEGIN
887: dbms_lock.allocate_unique(p_key_table, v_lockhandle);
888: p_retval := dbms_lock.request(v_lockhandle, dbms_lock.x_mode);
889: END request_lock;
890:
891: /* ****************************************************************************

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

884: IS
885: v_lockhandle VARCHAR2(200);
886: BEGIN
887: dbms_lock.allocate_unique(p_key_table, v_lockhandle);
888: p_retval := dbms_lock.request(v_lockhandle, dbms_lock.x_mode);
889: END request_lock;
890:
891: /* ****************************************************************************
892: * Procedure :generate_new_time_range *