APPS.AD_MV dependencies on DBMS_LOCK

Line 6: gn_timeout_c CONSTANT INTEGER := dbms_lock.maxwait;

2: /* $Header: admvb.pls 120.4 2006/06/01 19:18:16 vlim noship $*/
3:
4: gs_package_name_c CONSTANT VARCHAR2(30) := 'ad_mv';
5:
6: gn_timeout_c CONSTANT INTEGER := dbms_lock.maxwait;
7: gs_lockhandle_name_c CONSTANT VARCHAR2(12) := 'AD_MV_CREATE';
8:
9: ga_stmt dbms_sql.varchar2s;
10:

Line 48: dbms_lock.allocate_unique (

44: l_statement VARCHAR2(500);
45: ln_cursor INTEGER;
46: ln_dummy INTEGER;
47: BEGIN
48: dbms_lock.allocate_unique (
49: lockname => gs_lockhandle_name_c
50: , lockhandle => ls_lockhandle
51: );
52:

Line 54: ln_resource_status := dbms_lock.request (

50: , lockhandle => ls_lockhandle
51: );
52:
53: -- requesting lock
54: ln_resource_status := dbms_lock.request (
55: lockhandle => ls_lockhandle
56: , lockmode => dbms_lock.x_mode
57: , timeout => gn_timeout_c
58: , release_on_commit => FALSE

Line 56: , lockmode => dbms_lock.x_mode

52:
53: -- requesting lock
54: ln_resource_status := dbms_lock.request (
55: lockhandle => ls_lockhandle
56: , lockmode => dbms_lock.x_mode
57: , timeout => gn_timeout_c
58: , release_on_commit => FALSE
59: );
60: -- 0 - success

Line 129: THEN ln_resource_status := dbms_lock.release(lockhandle => ls_lockhandle);

125: EXCEPTION
126: WHEN mv_exists
127: THEN null;
128: WHEN OTHERS
129: THEN ln_resource_status := dbms_lock.release(lockhandle => ls_lockhandle);
130: ga_stmt.DELETE;
131: RAISE;
132: END;
133:

Line 134: ln_resource_status := dbms_lock.release(lockhandle => ls_lockhandle);

130: ga_stmt.DELETE;
131: RAISE;
132: END;
133:
134: ln_resource_status := dbms_lock.release(lockhandle => ls_lockhandle);
135: IF (ln_resource_status <> 0)
136: THEN
137: RAISE_APPLICATION_ERROR(-20002, ls_name_c || ': could not release the lock: ' || ln_resource_status);
138: END IF;

Line 185: dbms_lock.allocate_unique (

181: ls_lockhandle VARCHAR2(128);
182: ln_cursor INTEGER;
183: ln_dummy INTEGER;
184: BEGIN
185: dbms_lock.allocate_unique (
186: lockname => gs_lockhandle_name_c
187: , lockhandle => ls_lockhandle
188: );
189:

Line 191: ln_resource_status := dbms_lock.request (

187: , lockhandle => ls_lockhandle
188: );
189:
190: -- requesting lock
191: ln_resource_status := dbms_lock.request (
192: lockhandle => ls_lockhandle
193: , lockmode => dbms_lock.x_mode
194: , timeout => gn_timeout_c
195: , release_on_commit => FALSE

Line 193: , lockmode => dbms_lock.x_mode

189:
190: -- requesting lock
191: ln_resource_status := dbms_lock.request (
192: lockhandle => ls_lockhandle
193: , lockmode => dbms_lock.x_mode
194: , timeout => gn_timeout_c
195: , release_on_commit => FALSE
196: );
197: IF (ln_resource_status <> 0)

Line 219: ln_resource_status := dbms_lock.release(lockhandle => ls_lockhandle);

215: END IF;
216: EXCEPTION
217: WHEN OTHERS
218: THEN
219: ln_resource_status := dbms_lock.release(lockhandle => ls_lockhandle);
220: ga_stmt.DELETE;
221: RAISE;
222: END;
223:

Line 224: ln_resource_status := dbms_lock.release(lockhandle => ls_lockhandle);

220: ga_stmt.DELETE;
221: RAISE;
222: END;
223:
224: ln_resource_status := dbms_lock.release(lockhandle => ls_lockhandle);
225: IF (ln_resource_status <> 0)
226: THEN
227: RAISE_APPLICATION_ERROR(-20002, ls_name_c || ': could not release the lock: ' || ln_resource_status);
228: END IF;