APPS.AD_FILE_UTIL dependencies on DBMS_LOCK

Line 11: dbms_lock.allocate_unique('ORA_APPS_AD_CHKFILTMP', l_lockhandle);

7: l_exit_loop boolean := FALSE;
8: begin
9: ad_file_util.error_buf := 'lock_infrastructure()';
10:
11: dbms_lock.allocate_unique('ORA_APPS_AD_CHKFILTMP', l_lockhandle);
12:
13: l_exit_loop := FALSE;
14:
15: loop

Line 18: l_status := dbms_lock.request(l_lockhandle);

14:
15: loop
16: exit when l_exit_loop;
17:
18: l_status := dbms_lock.request(l_lockhandle);
19:
20: if l_status in (0, 4) then
21: -- 0 => success
22: -- 4 => already held, deem as success.

Line 45: dbms_lock.allocate_unique('ORA_APPS_AD_CHKFILTMP', l_lockhandle);

41: l_status number := 100;
42: begin
43: ad_file_util.error_buf := 'unlock_infrastructure()';
44:
45: dbms_lock.allocate_unique('ORA_APPS_AD_CHKFILTMP', l_lockhandle);
46:
47: l_status := dbms_lock.release(l_lockhandle);
48:
49: if l_status not in (0, 4) then

Line 47: l_status := dbms_lock.release(l_lockhandle);

43: ad_file_util.error_buf := 'unlock_infrastructure()';
44:
45: dbms_lock.allocate_unique('ORA_APPS_AD_CHKFILTMP', l_lockhandle);
46:
47: l_status := dbms_lock.release(l_lockhandle);
48:
49: if l_status not in (0, 4) then
50: -- 0 => success. 4 => never held, so deem as success. Any other value is
51: -- an error.

Line 66: -- (created using DBMS_LOCK mgmt services), and also empties the table.

62: -- lock_and_empty_temp_table
63: --
64: -- Purpose
65: -- Serializes access to the AD_CHECK_FILE_TEMP table using a User Lock
66: -- (created using DBMS_LOCK mgmt services), and also empties the table.
67: -- This lock would be a session-level lock, and is intended to be released
68: -- when the calling script is totally done with its use of the temp table.
69: --
70: -- This is especially necessary when we have multiple scripts that use