APPS.FND_GSM_UTIL dependencies on FND_OAM_CONTEXT_FILES

Line 311: -- try inserting row into fnd_oam_context_files table

307: end if;
308:
309: f_sr_num := to_number(NVL(sr_num,0));
310:
311: -- try inserting row into fnd_oam_context_files table
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

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

308:
309: f_sr_num := to_number(NVL(sr_num,0));
310:
311: -- try inserting row into fnd_oam_context_files table
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);

Line 321: from fnd_oam_context_files

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

Line 340: insert into fnd_oam_context_files

336:
337: -- db_ver := to_number(NVL(substr(db_ver_str,instr(db_ver_str,'.',1,1) +1),0));
338:
339: if ( not file_found ) then
340: insert into fnd_oam_context_files
341: (name, version, path, last_synchronized,
342: text, creation_date, created_by, last_update_date,
343: last_updated_by, last_update_login, node_name,
344: status, ctx_type)

Line 365: update fnd_oam_context_files

361: OR context_name in ('METADATA', 'TEMPLATE'))) then
362: -- bug6739946
363: -- added status to be set to S to mark upload of template
364: -- to already existing row
365: update fnd_oam_context_files
366: set path = filepath,
367: last_synchronized = sysdate,
368: text = ctx_file_clob,
369: last_update_date = sysdate,