APPS.WF_MAINTENANCE dependencies on DBMS_LOCK

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

499: end if;
500:
501: -- Acquire a session lock to ensure that only one instance of the program is
502: -- running at a time.
503: dbms_lock.allocate_unique('WF_MAINTENANCE.ValidateUserRoles',l_lockhandle);
504:
505: if (dbms_lock.request(lockhandle=>l_lockhandle,
506: lockmode=>dbms_lock.x_mode,
507: timeout=>0) <> 0) then

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

501: -- Acquire a session lock to ensure that only one instance of the program is
502: -- running at a time.
503: dbms_lock.allocate_unique('WF_MAINTENANCE.ValidateUserRoles',l_lockhandle);
504:
505: if (dbms_lock.request(lockhandle=>l_lockhandle,
506: lockmode=>dbms_lock.x_mode,
507: timeout=>0) <> 0) then
508: wf_core.raise('WF_LOCK_FAIL');
509: end if;

Line 506: lockmode=>dbms_lock.x_mode,

502: -- running at a time.
503: dbms_lock.allocate_unique('WF_MAINTENANCE.ValidateUserRoles',l_lockhandle);
504:
505: if (dbms_lock.request(lockhandle=>l_lockhandle,
506: lockmode=>dbms_lock.x_mode,
507: timeout=>0) <> 0) then
508: wf_core.raise('WF_LOCK_FAIL');
509: end if;
510:

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

1338: if (c_userRoleAssignments%ISOPEN) then
1339: close c_userRoleAssignments;
1340: end if;
1341: --release lock
1342: if (dbms_lock.release(l_lockhandle) <> 0) then
1343: wf_core.raise('WF_LOCK_FAIL');
1344: end if;
1345:
1346: exception

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

1344: end if;
1345:
1346: exception
1347: when others then
1348: result := dbms_lock.release(l_lockhandle);
1349: if (c_userRoleAssignments%ISOPEN) then
1350: close c_userRoleAssignments;
1351: end if;
1352: raise;