APPS.FND_WEBFILE dependencies on FND_FILE_TEMP

Line 35: update fnd_file_temp

31: procedure UPDATE_SVC(id in number,
32: svc in varchar2) is
33: PRAGMA AUTONOMOUS_TRANSACTION;
34: begin
35: update fnd_file_temp
36: set node_name = svc
37: where file_id = id;
38:
39: commit;

Line 59: update fnd_file_temp

55: dest_svc in varchar2,
56: tran_type in varchar2) is
57: PRAGMA AUTONOMOUS_TRANSACTION;
58: begin
59: update fnd_file_temp
60: set destination_node = dest_svc,
61: destination_file = dest_file,
62: transfer_type = tran_type
63: where file_id = id;

Line 85: update fnd_file_temp

81: p_page_size in number,
82: p_tran_type in varchar2) is
83: PRAGMA AUTONOMOUS_TRANSACTION;
84: begin
85: update fnd_file_temp
86: set page_number = p_page_no,
87: page_size = p_page_size,
88: transfer_type = p_tran_type
89: where file_id =id;

Line 493: from fnd_file_temp

489: elsif (file_type >= generic_log and file_type <= generic_cfg) then
490: begin
491: select filename, node_name
492: into fname, node
493: from fnd_file_temp
494: where file_id = id;
495:
496: pos := instr(fname, '.', -1, 1);
497: ext := substr(fname, (pos + 1));

Line 702: from fnd_file_temp T

698: my_file_id := fnd_concurrent_file.get_file_id;
699:
700: select count(*)
701: into collision
702: from fnd_file_temp T
703: where T.file_id = my_file_id;
704: end loop;
705:
706:

Line 778: insert into fnd_file_temp( file_id,

774:
775: end;
776: --- End Shared Appltop Failover code
777:
778: insert into fnd_file_temp( file_id,
779: filename,
780: node_name,
781: mime_type,
782: request_id,