eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_WEBFILEPUB dependencies on FND_FILE_TEMP

Line 18: fnd_file_temp t

14: select r.nls_language,
15: r.nls_territory
16: into g_nlslang, g_nlsterr
17: from fnd_concurrent_requests r,
18: fnd_file_temp t
19: where t.request_id = r.request_id
20: and t.file_id = id;
21:
22: exception

Line 32: dummy4 fnd_file_temp.mime_type%TYPE;

28: procedure verify_id( id IN varchar2,
29: name IN OUT NOCOPY varchar2,
30: node IN OUT NOCOPY varchar2)
31: is
32: dummy4 fnd_file_temp.mime_type%TYPE;
33: dummy5 fnd_file_temp.transfer_mode%TYPE;
34: dummy6 fnd_file_temp.request_id%TYPE;
35: dummy7 fnd_file_temp.destination_file%TYPE;
36: dummy8 fnd_file_temp.destination_node%TYPE;

Line 33: dummy5 fnd_file_temp.transfer_mode%TYPE;

29: name IN OUT NOCOPY varchar2,
30: node IN OUT NOCOPY varchar2)
31: is
32: dummy4 fnd_file_temp.mime_type%TYPE;
33: dummy5 fnd_file_temp.transfer_mode%TYPE;
34: dummy6 fnd_file_temp.request_id%TYPE;
35: dummy7 fnd_file_temp.destination_file%TYPE;
36: dummy8 fnd_file_temp.destination_node%TYPE;
37: dummy9 fnd_file_temp.transfer_type%TYPE;

Line 34: dummy6 fnd_file_temp.request_id%TYPE;

30: node IN OUT NOCOPY varchar2)
31: is
32: dummy4 fnd_file_temp.mime_type%TYPE;
33: dummy5 fnd_file_temp.transfer_mode%TYPE;
34: dummy6 fnd_file_temp.request_id%TYPE;
35: dummy7 fnd_file_temp.destination_file%TYPE;
36: dummy8 fnd_file_temp.destination_node%TYPE;
37: dummy9 fnd_file_temp.transfer_type%TYPE;
38: dummy10 varchar2(254);

Line 35: dummy7 fnd_file_temp.destination_file%TYPE;

31: is
32: dummy4 fnd_file_temp.mime_type%TYPE;
33: dummy5 fnd_file_temp.transfer_mode%TYPE;
34: dummy6 fnd_file_temp.request_id%TYPE;
35: dummy7 fnd_file_temp.destination_file%TYPE;
36: dummy8 fnd_file_temp.destination_node%TYPE;
37: dummy9 fnd_file_temp.transfer_type%TYPE;
38: dummy10 varchar2(254);
39:

Line 36: dummy8 fnd_file_temp.destination_node%TYPE;

32: dummy4 fnd_file_temp.mime_type%TYPE;
33: dummy5 fnd_file_temp.transfer_mode%TYPE;
34: dummy6 fnd_file_temp.request_id%TYPE;
35: dummy7 fnd_file_temp.destination_file%TYPE;
36: dummy8 fnd_file_temp.destination_node%TYPE;
37: dummy9 fnd_file_temp.transfer_type%TYPE;
38: dummy10 varchar2(254);
39:
40: begin

Line 37: dummy9 fnd_file_temp.transfer_type%TYPE;

33: dummy5 fnd_file_temp.transfer_mode%TYPE;
34: dummy6 fnd_file_temp.request_id%TYPE;
35: dummy7 fnd_file_temp.destination_file%TYPE;
36: dummy8 fnd_file_temp.destination_node%TYPE;
37: dummy9 fnd_file_temp.transfer_type%TYPE;
38: dummy10 varchar2(254);
39:
40: begin
41:

Line 54: dummy6 fnd_file_temp.request_id%TYPE;

50: node IN OUT NOCOPY varchar2,
51: type IN OUT NOCOPY varchar2,
52: x_mode IN OUT NOCOPY varchar2)
53: is
54: dummy6 fnd_file_temp.request_id%TYPE;
55: dummy7 fnd_file_temp.destination_file%TYPE;
56: dummy8 fnd_file_temp.destination_node%TYPE;
57: dummy9 fnd_file_temp.transfer_type%TYPE;
58: dummy10 varchar2(254);

Line 55: dummy7 fnd_file_temp.destination_file%TYPE;

51: type IN OUT NOCOPY varchar2,
52: x_mode IN OUT NOCOPY varchar2)
53: is
54: dummy6 fnd_file_temp.request_id%TYPE;
55: dummy7 fnd_file_temp.destination_file%TYPE;
56: dummy8 fnd_file_temp.destination_node%TYPE;
57: dummy9 fnd_file_temp.transfer_type%TYPE;
58: dummy10 varchar2(254);
59: begin

Line 56: dummy8 fnd_file_temp.destination_node%TYPE;

52: x_mode IN OUT NOCOPY varchar2)
53: is
54: dummy6 fnd_file_temp.request_id%TYPE;
55: dummy7 fnd_file_temp.destination_file%TYPE;
56: dummy8 fnd_file_temp.destination_node%TYPE;
57: dummy9 fnd_file_temp.transfer_type%TYPE;
58: dummy10 varchar2(254);
59: begin
60:

Line 57: dummy9 fnd_file_temp.transfer_type%TYPE;

53: is
54: dummy6 fnd_file_temp.request_id%TYPE;
55: dummy7 fnd_file_temp.destination_file%TYPE;
56: dummy8 fnd_file_temp.destination_node%TYPE;
57: dummy9 fnd_file_temp.transfer_type%TYPE;
58: dummy10 varchar2(254);
59: begin
60:
61: verify_id (id, name, node, type,

Line 75: dummy7 fnd_file_temp.destination_file%TYPE;

71: type IN OUT NOCOPY varchar2,
72: x_mode IN OUT NOCOPY varchar2,
73: req_id IN OUT NOCOPY varchar2)
74: is
75: dummy7 fnd_file_temp.destination_file%TYPE;
76: dummy8 fnd_file_temp.destination_node%TYPE;
77: dummy9 fnd_file_temp.transfer_type%TYPE;
78: dummy10 varchar2(254);
79:

Line 76: dummy8 fnd_file_temp.destination_node%TYPE;

72: x_mode IN OUT NOCOPY varchar2,
73: req_id IN OUT NOCOPY varchar2)
74: is
75: dummy7 fnd_file_temp.destination_file%TYPE;
76: dummy8 fnd_file_temp.destination_node%TYPE;
77: dummy9 fnd_file_temp.transfer_type%TYPE;
78: dummy10 varchar2(254);
79:
80: begin

Line 77: dummy9 fnd_file_temp.transfer_type%TYPE;

73: req_id IN OUT NOCOPY varchar2)
74: is
75: dummy7 fnd_file_temp.destination_file%TYPE;
76: dummy8 fnd_file_temp.destination_node%TYPE;
77: dummy9 fnd_file_temp.transfer_type%TYPE;
78: dummy10 varchar2(254);
79:
80: begin
81: verify_id (id, name, node, type,

Line 103: from fnd_file_temp

99: begin
100: select filename, node_name, mime_type, transfer_mode, request_id,
101: destination_file, destination_node, NVL(transfer_type, 'R')
102: into name, node, type, x_mode, req_id, dest_file, dest_node, tran_type
103: from fnd_file_temp
104: where file_id = id AND
105: sysdate <= expires
106: for update;
107:

Line 108: delete from fnd_file_temp

104: where file_id = id AND
105: sysdate <= expires
106: for update;
107:
108: delete from fnd_file_temp
109: where file_id = id OR
110: sysdate > expires;
111: commit;
112:

Line 191: fnd_file_temp t

187: into temp_name, file_type
188: from fnd_concurrent_programs_vl p,
189: fnd_concurrent_requests r,
190: fnd_conc_req_outputs o,
191: fnd_file_temp t
192: where p.concurrent_program_id = r.concurrent_program_id
193: and p.application_id = r.program_application_id
194: and t.request_id = r.request_id
195: and r.request_id = o.concurrent_request_id(+)

Line 212: fnd_file_temp t,

208: into temp_name, file_type
209: from fnd_concurrent_programs_tl p,
210: fnd_concurrent_requests r,
211: fnd_conc_req_outputs o,
212: fnd_file_temp t,
213: fnd_languages l
214: where p.concurrent_program_id = r.concurrent_program_id
215: and p.application_id = r.program_application_id
216: and t.request_id = r.request_id

Line 322: from fnd_file_temp

318: NVL(enable_logging, 'N')
319: into name, node, type, x_mode, req_id,
320: dest_file, dest_node,
321: tran_type, ncenc, enable_log
322: from fnd_file_temp
323: where file_id = id and
324: sysdate <= expires
325: for update;
326:

Line 331: delete from fnd_file_temp

327: if ( type = 'apps/bidi' ) then
328: get_nls_values(id);
329: end if;
330:
331: delete from fnd_file_temp
332: where sysdate > expires;
333: commit;
334:
335: svc_prefix := fnd_profile.value('FS_SVC_PREFIX');

Line 361: dummy7 fnd_file_temp.destination_file%TYPE;

357: type IN OUT NOCOPY varchar2,
358: x_mode IN OUT NOCOPY varchar2,
359: req_id IN OUT NOCOPY varchar2)
360: is
361: dummy7 fnd_file_temp.destination_file%TYPE;
362: dummy8 fnd_file_temp.destination_node%TYPE;
363: dummy9 fnd_file_temp.transfer_type%TYPE;
364: dummy10 varchar2(254);
365: dummy11 fnd_file_temp.native_client_encoding%TYPE;

Line 362: dummy8 fnd_file_temp.destination_node%TYPE;

358: x_mode IN OUT NOCOPY varchar2,
359: req_id IN OUT NOCOPY varchar2)
360: is
361: dummy7 fnd_file_temp.destination_file%TYPE;
362: dummy8 fnd_file_temp.destination_node%TYPE;
363: dummy9 fnd_file_temp.transfer_type%TYPE;
364: dummy10 varchar2(254);
365: dummy11 fnd_file_temp.native_client_encoding%TYPE;
366: dummy12 varchar2(1);

Line 363: dummy9 fnd_file_temp.transfer_type%TYPE;

359: req_id IN OUT NOCOPY varchar2)
360: is
361: dummy7 fnd_file_temp.destination_file%TYPE;
362: dummy8 fnd_file_temp.destination_node%TYPE;
363: dummy9 fnd_file_temp.transfer_type%TYPE;
364: dummy10 varchar2(254);
365: dummy11 fnd_file_temp.native_client_encoding%TYPE;
366: dummy12 varchar2(1);
367:

Line 365: dummy11 fnd_file_temp.native_client_encoding%TYPE;

361: dummy7 fnd_file_temp.destination_file%TYPE;
362: dummy8 fnd_file_temp.destination_node%TYPE;
363: dummy9 fnd_file_temp.transfer_type%TYPE;
364: dummy10 varchar2(254);
365: dummy11 fnd_file_temp.native_client_encoding%TYPE;
366: dummy12 varchar2(1);
367:
368: begin
369:

Line 385: from fnd_file_temp

381: is
382: begin
383: select filename, page_number, page_size
384: into name, pagenum, pagesize
385: from fnd_file_temp
386: where file_id = id
387: and sysdate <= expires
388: for update;
389:

Line 390: delete from fnd_file_temp

386: where file_id = id
387: and sysdate <= expires
388: for update;
389:
390: delete from fnd_file_temp
391: where file_id = id
392: or sysdate > expires;
393:
394: commit;