APPS.WF_MAINTENANCE dependencies on DBMS_LOCK

Line 1104: dbms_lock.allocate_unique('WF_MAINTENANCE.ValidateUserRoles',l_lockhandle);

1100: end if;
1101:
1102: -- Acquire a session lock to ensure that only one instance of the program is
1103: -- running at a time.
1104: dbms_lock.allocate_unique('WF_MAINTENANCE.ValidateUserRoles',l_lockhandle);
1105:
1106: if (dbms_lock.request(lockhandle=>l_lockhandle,
1107: lockmode=>dbms_lock.x_mode,
1108: timeout=>0) <> 0) then

Line 1106: if (dbms_lock.request(lockhandle=>l_lockhandle,

1102: -- Acquire a session lock to ensure that only one instance of the program is
1103: -- running at a time.
1104: dbms_lock.allocate_unique('WF_MAINTENANCE.ValidateUserRoles',l_lockhandle);
1105:
1106: if (dbms_lock.request(lockhandle=>l_lockhandle,
1107: lockmode=>dbms_lock.x_mode,
1108: timeout=>0) <> 0) then
1109: wf_core.raise('WF_LOCK_FAIL');
1110: end if;

Line 1107: lockmode=>dbms_lock.x_mode,

1103: -- running at a time.
1104: dbms_lock.allocate_unique('WF_MAINTENANCE.ValidateUserRoles',l_lockhandle);
1105:
1106: if (dbms_lock.request(lockhandle=>l_lockhandle,
1107: lockmode=>dbms_lock.x_mode,
1108: timeout=>0) <> 0) then
1109: wf_core.raise('WF_LOCK_FAIL');
1110: end if;
1111:

Line 1965: if (dbms_lock.release(l_lockhandle) <> 0) then

1961: -- Bug 8423138
1962: FixLUREffectiveDates(l_maxRows, p_username, p_rolename);
1963:
1964: --release lock
1965: if (dbms_lock.release(l_lockhandle) <> 0) then
1966: wf_core.raise('WF_LOCK_FAIL');
1967: end if;
1968:
1969: exception

Line 1971: result := dbms_lock.release(l_lockhandle);

1967: end if;
1968:
1969: exception
1970: when others then
1971: result := dbms_lock.release(l_lockhandle);
1972: if (c_userRoleAssignments%ISOPEN) then
1973: close c_userRoleAssignments;
1974: end if;
1975: