[Home] [Help]
PACKAGE: APPS.FND_MLS_SUBMIT
Source
1 package FND_MLS_SUBMIT as
2 /* $Header: AFCPMLSS.pls 120.3 2008/05/02 09:33:54 ddhulla noship $ */
3 /*#
4 * Contains concurrent processing related utilities
5 * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Concurrent Request
8 * @rep:category BUSINESS_ENTITY FND_CP_REQUEST
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 */
12
13
14 /*#
15 * Submits a MLS request for processing by a concurrent manager
16 * @param application Short name of the application associated with the concurrent request to be submitted
17 * @param program Short name of the concurrent program for which the request should be submitted
18 * @param description Description of the request that is displayed in the concurrent request's form
19 * @param start_time Time at which the request should start running
20 * @param sub_request Set to TRUE if the request is submitted from another request and should be treated as a sub-request
21 * @param argument1 Argument for concurrent request
22 * @param argument2 Argument for concurrent request
23 * @param argument3 Argument for concurrent request
24 * @param argument4 Argument for concurrent request
25 * @param argument5 Argument for concurrent request
26 * @param argument6 Argument for concurrent request
27 * @param argument7 Argument for concurrent request
28 * @param argument8 Argument for concurrent request
29 * @param argument9 Argument for concurrent request
30 * @param argument10 Argument for concurrent request
31 * @param argument11 Argument for concurrent request
32 * @param argument12 Argument for concurrent request
33 * @param argument13 Argument for concurrent request
34 * @param argument14 Argument for concurrent request
35 * @param argument15 Argument for concurrent request
36 * @param argument16 Argument for concurrent request
37 * @param argument17 Argument for concurrent request
38 * @param argument18 Argument for concurrent request
39 * @param argument19 Argument for concurrent request
40 * @param argument20 Argument for concurrent request
41 * @param argument21 Argument for concurrent request
42 * @param argument22 Argument for concurrent request
43 * @param argument23 Argument for concurrent request
44 * @param argument24 Argument for concurrent request
45 * @param argument25 Argument for concurrent request
46 * @param argument26 Argument for concurrent request
47 * @param argument27 Argument for concurrent request
48 * @param argument28 Argument for concurrent request
49 * @param argument29 Argument for concurrent request
50 * @param argument30 Argument for concurrent request
51 * @param argument31 Argument for concurrent request
52 * @param argument32 Argument for concurrent request
53 * @param argument33 Argument for concurrent request
54 * @param argument34 Argument for concurrent request
55 * @param argument35 Argument for concurrent request
56 * @param argument36 Argument for concurrent request
57 * @param argument37 Argument for concurrent request
58 * @param argument38 Argument for concurrent request
59 * @param argument39 Argument for concurrent request
60 * @param argument40 Argument for concurrent request
61 * @param argument41 Argument for concurrent request
62 * @param argument42 Argument for concurrent request
63 * @param argument43 Argument for concurrent request
64 * @param argument44 Argument for concurrent request
65 * @param argument45 Argument for concurrent request
66 * @param argument46 Argument for concurrent request
67 * @param argument47 Argument for concurrent request
68 * @param argument48 Argument for concurrent request
69 * @param argument49 Argument for concurrent request
70 * @param argument50 Argument for concurrent request
71 * @param argument51 Argument for concurrent request
72 * @param argument52 Argument for concurrent request
73 * @param argument53 Argument for concurrent request
74 * @param argument54 Argument for concurrent request
75 * @param argument55 Argument for concurrent request
76 * @param argument56 Argument for concurrent request
77 * @param argument57 Argument for concurrent request
78 * @param argument58 Argument for concurrent request
79 * @param argument59 Argument for concurrent request
80 * @param argument60 Argument for concurrent request
81 * @param argument61 Argument for concurrent request
82 * @param argument62 Argument for concurrent request
83 * @param argument63 Argument for concurrent request
84 * @param argument64 Argument for concurrent request
85 * @param argument65 Argument for concurrent request
86 * @param argument66 Argument for concurrent request
87 * @param argument67 Argument for concurrent request
88 * @param argument68 Argument for concurrent request
89 * @param argument69 Argument for concurrent request
90 * @param argument70 Argument for concurrent request
91 * @param argument71 Argument for concurrent request
92 * @param argument72 Argument for concurrent request
93 * @param argument73 Argument for concurrent request
94 * @param argument74 Argument for concurrent request
95 * @param argument75 Argument for concurrent request
96 * @param argument76 Argument for concurrent request
97 * @param argument77 Argument for concurrent request
98 * @param argument78 Argument for concurrent request
99 * @param argument79 Argument for concurrent request
100 * @param argument80 Argument for concurrent request
101 * @param argument81 Argument for concurrent request
102 * @param argument82 Argument for concurrent request
103 * @param argument83 Argument for concurrent request
104 * @param argument84 Argument for concurrent request
105 * @param argument85 Argument for concurrent request
106 * @param argument86 Argument for concurrent request
107 * @param argument87 Argument for concurrent request
108 * @param argument88 Argument for concurrent request
109 * @param argument89 Argument for concurrent request
110 * @param argument90 Argument for concurrent request
111 * @param argument91 Argument for concurrent request
112 * @param argument92 Argument for concurrent request
113 * @param argument93 Argument for concurrent request
114 * @param argument94 Argument for concurrent request
115 * @param argument95 Argument for concurrent request
116 * @param argument96 Argument for concurrent request
117 * @param argument97 Argument for concurrent request
118 * @param argument98 Argument for concurrent request
119 * @param argument99 Argument for concurrent request
120 * @param argument100 Argument for concurrent request
121 * @return Returns requestid of submitted request, 0 if submission fails
122 * @rep:displayname Submit MLS Request
123 * @rep:scope public
124 * @rep:lifecycle active
125 * @rep:compatibility S
126 */
127 function submit_mls_request (
128 application IN varchar2 default NULL,
129 program IN varchar2 default NULL,
130 description IN varchar2 default NULL,
131 start_time IN varchar2 default NULL,
132 sub_request IN boolean default FALSE,
133 argument1 IN varchar2 default CHR(0),
134 argument2 IN varchar2 default CHR(0),
135 argument3 IN varchar2 default CHR(0),
136 argument4 IN varchar2 default CHR(0),
137 argument5 IN varchar2 default CHR(0),
138 argument6 IN varchar2 default CHR(0),
139 argument7 IN varchar2 default CHR(0),
140 argument8 IN varchar2 default CHR(0),
141 argument9 IN varchar2 default CHR(0),
142 argument10 IN varchar2 default CHR(0),
143 argument11 IN varchar2 default CHR(0),
144 argument12 IN varchar2 default CHR(0),
145 argument13 IN varchar2 default CHR(0),
146 argument14 IN varchar2 default CHR(0),
147 argument15 IN varchar2 default CHR(0),
148 argument16 IN varchar2 default CHR(0),
149 argument17 IN varchar2 default CHR(0),
150 argument18 IN varchar2 default CHR(0),
151 argument19 IN varchar2 default CHR(0),
152 argument20 IN varchar2 default CHR(0),
153 argument21 IN varchar2 default CHR(0),
154 argument22 IN varchar2 default CHR(0),
155 argument23 IN varchar2 default CHR(0),
156 argument24 IN varchar2 default CHR(0),
157 argument25 IN varchar2 default CHR(0),
158 argument26 IN varchar2 default CHR(0),
159 argument27 IN varchar2 default CHR(0),
160 argument28 IN varchar2 default CHR(0),
161 argument29 IN varchar2 default CHR(0),
162 argument30 IN varchar2 default CHR(0),
163 argument31 IN varchar2 default CHR(0),
164 argument32 IN varchar2 default CHR(0),
165 argument33 IN varchar2 default CHR(0),
166 argument34 IN varchar2 default CHR(0),
167 argument35 IN varchar2 default CHR(0),
168 argument36 IN varchar2 default CHR(0),
169 argument37 IN varchar2 default CHR(0),
170 argument38 IN varchar2 default CHR(0),
171 argument39 IN varchar2 default CHR(0),
172 argument40 IN varchar2 default CHR(0),
173 argument41 IN varchar2 default CHR(0),
174 argument42 IN varchar2 default CHR(0),
175 argument43 IN varchar2 default CHR(0),
176 argument44 IN varchar2 default CHR(0),
177 argument45 IN varchar2 default CHR(0),
178 argument46 IN varchar2 default CHR(0),
179 argument47 IN varchar2 default CHR(0),
180 argument48 IN varchar2 default CHR(0),
181 argument49 IN varchar2 default CHR(0),
182 argument50 IN varchar2 default CHR(0),
183 argument51 IN varchar2 default CHR(0),
184 argument52 IN varchar2 default CHR(0),
185 argument53 IN varchar2 default CHR(0),
186 argument54 IN varchar2 default CHR(0),
187 argument55 IN varchar2 default CHR(0),
188 argument56 IN varchar2 default CHR(0),
189 argument57 IN varchar2 default CHR(0),
190 argument58 IN varchar2 default CHR(0),
191 argument59 IN varchar2 default CHR(0),
192 argument60 IN varchar2 default CHR(0),
193 argument61 IN varchar2 default CHR(0),
194 argument62 IN varchar2 default CHR(0),
195 argument63 IN varchar2 default CHR(0),
196 argument64 IN varchar2 default CHR(0),
197 argument65 IN varchar2 default CHR(0),
198 argument66 IN varchar2 default CHR(0),
199 argument67 IN varchar2 default CHR(0),
200 argument68 IN varchar2 default CHR(0),
201 argument69 IN varchar2 default CHR(0),
202 argument70 IN varchar2 default CHR(0),
203 argument71 IN varchar2 default CHR(0),
204 argument72 IN varchar2 default CHR(0),
205 argument73 IN varchar2 default CHR(0),
206 argument74 IN varchar2 default CHR(0),
207 argument75 IN varchar2 default CHR(0),
208 argument76 IN varchar2 default CHR(0),
209 argument77 IN varchar2 default CHR(0),
210 argument78 IN varchar2 default CHR(0),
211 argument79 IN varchar2 default CHR(0),
212 argument80 IN varchar2 default CHR(0),
213 argument81 IN varchar2 default CHR(0),
214 argument82 IN varchar2 default CHR(0),
215 argument83 IN varchar2 default CHR(0),
216 argument84 IN varchar2 default CHR(0),
217 argument85 IN varchar2 default CHR(0),
218 argument86 IN varchar2 default CHR(0),
219 argument87 IN varchar2 default CHR(0),
220 argument88 IN varchar2 default CHR(0),
221 argument89 IN varchar2 default CHR(0),
222 argument90 IN varchar2 default CHR(0),
223 argument91 IN varchar2 default CHR(0),
224 argument92 IN varchar2 default CHR(0),
225 argument93 IN varchar2 default CHR(0),
226 argument94 IN varchar2 default CHR(0),
227 argument95 IN varchar2 default CHR(0),
228 argument96 IN varchar2 default CHR(0),
229 argument97 IN varchar2 default CHR(0),
230 argument98 IN varchar2 default CHR(0),
231 argument99 IN varchar2 default CHR(0),
232 argument100 IN varchar2 default CHR(0))
233 return number;
234
235 -- This function is for AOL internal use only:
236 procedure internal(critical IN varchar2 default null,
237 type IN varchar2 default null);
238
239 --
240 -- Name
241 -- add_printer
242 -- Purpose
243 -- Called after set print options to add a printer to the
244 -- print list.
245 --
246 -- Arguments
247 -- printer - Printer name where the request o/p should be sent
248 -- copies - Number of copies to print
249 -- lang - Language to print the o/p
250 function add_printer (printer in varchar2 default null,
251 copies in number default null,
252 lang in varchar2 default null) return boolean;
253
254
255 --
256 -- Name
257 -- set_print_options
258 -- Purpose
259 -- Called before submitting request if the printing of output has
260 -- to be controlled with specific printer/style/copies etc.,
261 --
262 -- Arguments
263 -- printer - Printer name where the request o/p should be sent
264 -- style - Print style that needs to be used for printing
265 -- copies - Number of copies to print
266 -- save_output - Should the output file be saved after printing
267 -- - Default is TRUE. TRUE/FALSE
268 -- print_together - Applies only for sub requests. If 'Y', output
269 -- - will not be printed until all the sub requests
270 -- - complete. Default is 'N'. ( Y/N )
271 -- validate_printer - Once submit function is called
272 -- - with a specific program, if the printer specified
273 -- - here conflicts with a printer setting at the
274 -- - program level, one of three options is available:
275 -- - FAIL - raise an error and fail to submit
276 -- - SKIP - skip this print pp action, but submit anyway
277 -- - RESOLVE - switch to the valid printer, if printer
278 -- - and style are compatible
279 -- - Default is RESOLVE
280 -- lang - Language to print the o/p
281
282 function set_print_options (printer IN varchar2 default NULL,
283 style IN varchar2 default NULL,
284 copies IN number default NULL,
285 save_output IN boolean default TRUE,
286 print_together IN varchar2 default 'N',
287 validate_printer IN varchar2 default 'RESOLVE',
288 lang in varchar2 default null)
289 return boolean;
290
291 --
292 -- Name
293 -- set_options
294 -- Purpose
295 -- Called before submitting request to set request attributes
296 --
297 -- Arguments
298 -- implicit - nature of the request to be submitted
299 -- - NO/YES/ERROR/WARNING
300 -- protected - Is the request protected against updates
301 -- - YES/NO default is NO
302 -- language - NLS language
303 -- territory - Language territory
304 -- datagroup
305 -- numeric_characters - NLS Numeric Characters
306 --
307
308 function set_options (implicit IN varchar2 default 'NO',
312 datagroup IN varchar2 default NULL,
309 protected IN varchar2 default 'NO',
310 language IN varchar2 default NULL,
311 territory IN varchar2 default NULL,
313 numeric_characters IN varchar2 default NULL)
314 return boolean;
315
316
317 --
318 -- Name
319 -- add_notification
320 -- Purpose
321 -- Called before submission to add a user to the notify list.
322 --
323 -- Arguments
324 -- User - User name.
325
326 function add_layout (template_appl_name in varchar2,
327 template_code in varchar2,
328 template_language in varchar2,
329 template_territory in varchar2,
330 output_format in varchar2,
331 nls_language in varchar2) return boolean;
332
333 --
334 -- Name
335 -- add_notification
336 -- Purpose
337 -- Called before submission to add a user to the notify list.
338 --
339 -- Arguments
340 -- User - User name.
341 -- on_normal - Notify when normal completion (Values Y/N)
342 -- on_warning - Notify when request completes with warning (Y/N)
343 -- on_error - Notify when request completed with error (Y/N)
344 function add_notification (user in varchar2,
345 on_normal in varchar2 ,
346 on_warning in varchar2 ,
347 on_error in varchar2 ) return boolean;
348
349 -- add_notification
350 -- Purpose
351 -- Called before submission to add a user to the notify list.
352 --
353 -- Arguments
354 -- User - User name.
355 function add_notification (user in varchar2) return boolean;
356
357
358 --
359 -- Name
360 -- add_language
361 -- Purpose
362 -- Called to add language for request submission.
363 --
364 -- Arguments
365 -- lang - Request Language
366 -- territory - Request Territory
367 -- num_char - Request Numeric Characters
368
369 function add_language (
370 lang IN VARCHAR2,
371 territory IN VARCHAR2,
372 num_char IN VARCHAR2) return boolean;
373
374 procedure set_dest_ops(ops_id IN number default NULL);
375
376 procedure set_org_id(org_id IN number default NULL);
377
378 end FND_MLS_SUBMIT;