APPS.FND_GSM_UTIL dependencies on FND_OAM_CONTEXT_FILES

Line 325: -- try inserting row into fnd_oam_context_files table

321: end if;
322:
323: f_sr_num := to_number(NVL(sr_num,0));
324:
325: -- try inserting row into fnd_oam_context_files table
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

Line 326: -- fnd_oam_context_files.status values: (H)istory,(S)uccess,(F)ailure

322:
323: f_sr_num := to_number(NVL(sr_num,0));
324:
325: -- try inserting row into fnd_oam_context_files table
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);

Line 335: from fnd_oam_context_files

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
337: and path = filepath
338: and name not in ('METADATA','TEMPLATE')
339: and (status is null or upper(status) in ('S','F')))

Line 354: insert into fnd_oam_context_files

350:
351: -- db_ver := to_number(NVL(substr(db_ver_str,instr(db_ver_str,'.',1,1) +1),0));
352:
353: if ( not file_found ) then
354: insert into fnd_oam_context_files
355: (name, version, path, last_synchronized,
356: text, creation_date, created_by, last_update_date,
357: last_updated_by, last_update_login, node_name,
358: status, ctx_type)

Line 379: update fnd_oam_context_files

375: OR context_name in ('METADATA', 'TEMPLATE'))) then
376: -- bug6739946
377: -- added status to be set to S to mark upload of template
378: -- to already existing row
379: update fnd_oam_context_files
380: set path = filepath,
381: last_synchronized = sysdate,
382: text = ctx_file_clob,
383: last_update_date = sysdate,