1 package fnd_webfile as
2 /* $Header: AFCPFILS.pls 120.2 2005/08/19 21:42:24 rckalyan ship $ */
3
4
5
6 /* Define file types for get_url */
7 process_log constant number := 1;
8 icm_log constant number := 2;
9 request_log constant number := 3;
10 request_out constant number := 4;
11 request_mgr constant number := 5;
12 frd_log constant number := 6;
13 generic_log constant number := 7;
14 generic_trc constant number := 8;
15 generic_ora constant number := 9;
16 generic_cfg constant number := 10;
17 context_file constant number := 11;
18 generic_text constant number := 12;
19 generic_binary constant number := 13;
20 request_xml_output constant number :=14;
21
22 /* Function: GET_URL
23 *
24 * Purpose: Constructs and returns the URL for a Concurrent Processing
25 * log or output file.
26 *
27 * Arguments:
28 * file_type - Specifies the type of file desired:
29 * fnd_webfile.process_log = The log of the concurrent process identified
30 * by the parameter ID.
31 * fnd_webfile.icm_log = The log of the ICM process identified by ID.
32 * Or, the log of the ICM process that spawned
33 * the concurrent process identified by ID.
34 * Or, the log of the most recent ICM process
35 * if ID is null.
36 * fnd_webfile.request_log = The log of the request identified by ID.
37 * fnd_webfile.request_out = The output of the request identified by ID.
38 * fnd_webfile.request_mgr = The log of the concurrent process that ran
39 * the request identified by ID.
40 * fnd_webfile.frd_log = The log of the forms process identified
41 * by ID.
42 * fnd_webfile.generic_log = The log file identified by ID.
43 * fnd_webfile.generic_trc = The trace file identified by ID.
44 * fnd_webfile.generic_ora = The ora file identified by ID.
45 * fnd_webfile.generic_cfg = The config file identified by ID.
46 * fnd_webfile.context_file= Applications Context file identified by ID.
47 * fnd_webfile.generic_text= Generic file using text transfer mode.
48 * fnd_webfile.generic_binary = Generic file using binary transfer mode.
49 * fnd_webfile.request_xml_output = The xml output of Concurrent Request.
50 *
51 * id - A concurrent process ID, concurrent request ID, or file ID
52 * depending on the file type specified.
53 * For fnd_webfile.context_file,fnd_webfile.generic_text,
54 * fnd_webfile.generic_binary this value is null.
55 *
56 * gwyuid - The value of the environment variable GWYUID used in
57 * constructing the URL.
58 *
59 * two_task - The database two_task, used in constructing the URL.
60 *
61 * expire_time - The number of minutes for which this URL will remain
62 * valid.
63 * source_file - Source file name with full patch
64 *
65 * source_node - Source node name.
66 *
67 * dest_file - Destination file name
68 *
69 * dest_node - Destination node name
70 *
71 * page_no - Current page number
72 *
73 * page_size - Number of lines in a page
74 *
75 * Returns NULL on error. Check the FND message stack.
76 */
77 function get_url( file_type IN number,
78 id IN number,
79 gwyuid IN varchar2,
80 two_task IN varchar2,
81 expire_time IN number,
82 source_file IN varchar2 default null,
83 source_node IN varchar2 default null,
84 dest_file IN varchar2 default null,
85 dest_node IN varchar2 default null,
86 page_no IN number default null,
87 page_size IN number default null) return varchar2;
88
89
90
91 /* Function: get_req_log_urls
92 *
93 * Purpose: Constructs and returns the URLs for a concurrent request log
94 * and the log of the manager that ran the request..
95 *
96 * Arguments:
97 * request_id - Desired request_id.
98 *
99 * gwyuid - The value of the environment variable GWYUID used in
100 * constructing the URL.
101 *
102 * two_task - The database two_task, used in constructing the URL.
103 *
104 * expire_time - The number of minutes for which this URL will remain
105 * valid.
106 *
107 * req_log - Output URL for the request log.
108 *
109 * mgr_log - Output URL for the manager log.
110 *
111 * Returns FALSE on error. Check the FND message stack.
112 */
113
114 function get_req_log_urls( request_id IN number,
115 gwyuid IN varchar2,
116 two_task IN varchar2,
117 expire_time IN number,
118 req_log IN OUT NOCOPY varchar2,
119 mgr_log IN OUT NOCOPY varchar2) return boolean;
120
121
122
123 function create_id( name IN varchar2,
124 node IN varchar2,
125 lifetime IN number default 10,
126 type IN varchar2 default 'text/plain',
127 req_id IN number default 0,
128 x_mode IN varchar2 default 'TEXT',
129 ncenc IN varchar2 default 'N') return varchar2;
130
131 procedure set_debug(dbg IN boolean);
132
133 end;