APPS.FND_GSM_UTIL dependencies on DBMS_LOCK

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

326: -- fnd_oam_context_files.status values: (H)istory,(S)uccess,(F)ailure
327: --pbasha added for synchronization
328: if (contextfile_handle is null)
329: then
330: dbms_lock.allocate_unique('contextfile_lock',contextfile_handle);
331: end if;
332: v_result := dbms_lock.request(lockhandle=>contextfile_handle,release_on_commit=>TRUE);
333: begin
334: select NVL(serial_number, 0), version into db_sr_num, db_ver_str

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

328: if (contextfile_handle is null)
329: then
330: dbms_lock.allocate_unique('contextfile_lock',contextfile_handle);
331: end if;
332: v_result := dbms_lock.request(lockhandle=>contextfile_handle,release_on_commit=>TRUE);
333: begin
334: select NVL(serial_number, 0), version into db_sr_num, db_ver_str
335: from fnd_oam_context_files
336: where (node_name = primary_node

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

341: and name in ( 'METADATA', 'TEMPLATE'))
342: for update;
343:
344: file_found := TRUE;
345: v_result := dbms_lock.release(contextfile_handle);
346: exception
347: when no_data_found then
348: file_found := FALSE;
349: end;

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

360: ctx_file_clob, sysdate, FND_GLOBAL.user_id, sysdate,
361: FND_GLOBAL.user_id, FND_GLOBAL.login_id, primary_node,
362: 'S',
363: DECODE(context_type, 'APPS', 'A', 'DATABASE','D','A'));
364: v_result := dbms_lock.release(contextfile_handle);
365:
366: else
367: -- overwrite the database copy of context file if the serial # of the
368: -- file being uploaded is >= to the copy in the DB.