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 487: from fnd_file_temp

483: elsif (file_type >= generic_log and file_type <= generic_cfg) then
484: begin
485: select filename, node_name
486: into fname, node
487: from fnd_file_temp
488: where file_id = id;
489:
490: pos := instr(fname, '.', -1, 1);
491: ext := substr(fname, (pos + 1));

Line 696: from fnd_file_temp T

692: my_file_id := fnd_concurrent_file.get_file_id;
693:
694: select count(*)
695: into collision
696: from fnd_file_temp T
697: where T.file_id = my_file_id;
698: end loop;
699:
700:

Line 772: insert into fnd_file_temp( file_id,

768:
769: end;
770: --- End Shared Appltop Failover code
771:
772: insert into fnd_file_temp( file_id,
773: filename,
774: node_name,
775: mime_type,
776: request_id,