APPS.FND_GSM_UTIL dependencies on DBMS_LOCK

Line 316: dbms_lock.allocate_unique('contextfile_lock',contextfile_handle);

312: -- fnd_oam_context_files.status values: (H)istory,(S)uccess,(F)ailure
313: --pbasha added for synchronization
314: if (contextfile_handle is null)
315: then
316: dbms_lock.allocate_unique('contextfile_lock',contextfile_handle);
317: end if;
318: v_result := dbms_lock.request(lockhandle=>contextfile_handle,release_on_commit=>TRUE);
319: begin
320: select NVL(serial_number, 0), version into db_sr_num, db_ver_str

Line 318: v_result := dbms_lock.request(lockhandle=>contextfile_handle,release_on_commit=>TRUE);

314: if (contextfile_handle is null)
315: then
316: dbms_lock.allocate_unique('contextfile_lock',contextfile_handle);
317: end if;
318: v_result := dbms_lock.request(lockhandle=>contextfile_handle,release_on_commit=>TRUE);
319: begin
320: select NVL(serial_number, 0), version into db_sr_num, db_ver_str
321: from fnd_oam_context_files
322: where (node_name = primary_node

Line 331: v_result := dbms_lock.release(contextfile_handle);

327: and name in ( 'METADATA', 'TEMPLATE'))
328: for update;
329:
330: file_found := TRUE;
331: v_result := dbms_lock.release(contextfile_handle);
332: exception
333: when no_data_found then
334: file_found := FALSE;
335: end;

Line 350: v_result := dbms_lock.release(contextfile_handle);

346: ctx_file_clob, sysdate, FND_GLOBAL.user_id, sysdate,
347: FND_GLOBAL.user_id, FND_GLOBAL.login_id, primary_node,
348: 'S',
349: DECODE(context_type, 'APPS', 'A', 'DATABASE','D','A'));
350: v_result := dbms_lock.release(contextfile_handle);
351:
352: else
353: -- overwrite the database copy of context file if the serial # of the
354: -- file being uploaded is >= to the copy in the DB.