DBA Data[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;