1 package FND_SUBMIT AUTHID CURRENT_USER as
2 /* $Header: AFCPRSSS.pls 120.9.12020000.2 2012/07/13 20:47:04 pferguso ship $ */
3 /*#
4 * This package contains the APIs for request set submission.
5 * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Request Set Submission
8 * @rep:category BUSINESS_ENTITY FND_CP_REQUEST_SET
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 */
12
13 --
14 -- Package
15 -- FND_SUBMIT
16 --
17 -- Purpose
18 -- Concurrent processing related utilities
19 --
20 -- History
21 -- 11-SEP-98 Venkat Created
22 --
23
24 --
25 -- PUBLIC VARIABLES
26 --
27
28 -- Exceptions
29
30 -- Exception Pragmas
31
32 --
33 -- PUBLIC FUNCTIONS
34 --
35
36 --
37 -- Name
38 -- set_mode
39 -- Purpose
40 -- Called before submitting request to set mode to 'database trigger'
41 --
42 -- Arguments
43 -- db_trigger - Set to TRUE for database trigger mode
44 --
45 /*#
46 * Sets the mode if the request is submitted from a database trigger
47 * @param db_trigger Set to TRUE if the trigger is submitted from a database trigger
48 * @return Returns TRUE on successful completion, FALSE otherwise
49 * @rep:displayname Set Mode
50 * @rep:scope public
51 * @rep:lifecycle active
52 * @rep:compatibility S
53 */
54 function set_mode (db_trigger IN boolean) return boolean;
55
56 --
57 -- Name
58 -- set_nls_options
59 -- Purpose
60 -- Called before submitting request to set request attributes
61 --
62 -- Arguments
63 -- implicit - nature of the request to be submitted
64 -- - NO/YES/ERROR/WARNING
65 -- protected - Is the request protected against updates
66 -- - YES/NO default is NO
67 -- language - NLS language
68 -- territory - Language territory
69 --
70 /*#
71 * Sets request attributes (language-based attributes)
72 * @param language The NLS language
73 * @param territory The language territory
74 * @return Returns TRUE on successful completion, otherwise FALSE
75 * @rep:displayname Set NLS options
76 * @rep:scope public
77 * @rep:lifecycle active
78 * @rep:compatibility S
79 */
80 --
81 -- bug5676655/5709193
82 --
83 function set_nls_options( language IN varchar2 default NULL,
84 territory IN varchar2 default NULL,
85 numeric_characters IN varchar2 default NULL)
86 return boolean;
87
88 --
89 -- Name
90 -- set_repeat_options
91 -- Purpose
92 -- Called before submitting request if the request to be submitted
93 -- is a repeating request.
94 --
95 -- Arguments
96 -- repeat_time - Time of day at which it has to be repeated
97 -- repeat_interval - Frequency at which it has to be repeated
98 -- - This will be used/applied only when repeat_time
99 -- - is NULL
100 -- repeat_unit - Unit for repeat interval. Default is DAYS
101 -- - MONTHS/DAYS/HOURS/MINUTES
102 -- repeat_type - Apply repeat interval from START or END of request
103 -- - default is START. START/END
104 -- repeat_end_time - Time at which the repetition should be stopped
105 --
106 /*#
107 * Sets the repeat options for the request set before submitting a concurrent request
108 * @param repeat_time Time of the day at which request set is to be repeated
109 * @param repeat_interval Frequency at which the request set has to be repeated
110 * @param repeat_unit Unit for the repeat interval
111 * @param repeat_type Specifies whether the repeat interval should apply from the start or end of the previous request
112 * @param repeat_end_time Time at which the repetitions should end
113 * @return Returns TRUE on successful completion, FALSE otherwise
114 * @rep:displayname Set Repeat Options
115 * @rep:scope public
116 * @rep:lifecycle active
117 * @rep:compatibility S
118 */
119 function set_repeat_options (repeat_time IN varchar2 default NULL,
120 repeat_interval IN number default NULL,
121 repeat_unit IN varchar2 default 'DAYS',
122 repeat_type IN varchar2 default 'START',
123 repeat_end_time IN varchar2 default NULL)
124 return boolean;
125
126 --
127 -- Name
128 -- set_increment_dates_option
129 -- Purpose
130 -- Called before submitting request if the request to be submitted
131 -- has a schedule set that repeats. Making this available outside of
132 -- set_repeat_options in case the repeating schedule is set with
133 -- set_rel_class_options or fnd_conc_release_class_utils.assign_specific_sch
134 --
135 -- Arguments
136 -- increment_dates - 'Y' if date parameters should be incremented
137 -- each run, otherwise 'N'
138 --
139 /*#
140 * Sets the increment date parameters option for the request set before submitting a concurrent request
141 * @param increment_dates 'Y' if date parameters should be incremented each run, otherwise 'N'
142 * @rep:displayname Set Increment Dates Option
143 * @rep:scope public
144 * @rep:lifecycle active
145 * @rep:compatibility S
146 */
147 procedure set_increment_dates_option (increment_dates IN varchar2);
148
149 --
150 -- Name
151 -- set_rel_class_options
152 -- Purpose
153 -- Called before submitting request if the request to be submitted
154 -- is using the new scheduler functionality.
155 --
156 -- Arguments
157 -- application - Application Name of Release Class
158 -- class_name - (Developer) Name of Release Class
159 -- cancel_or_hold - Cancel or hold flag
160 -- stale_date - Cancel request on or after this time if not run
161 --
162 /*#
163 * Sets some of the advanced scheduling features available in the concurrent processing system
164 * @param application The short name of the application associated with the release class
165 * @param class_name The developer name of the release class
166 * @param cancel_or_hold Cancel or hold flag
167 * @param stale_date Cancel this request after this date if the request has not yet run
168 * @return Returns TRUE on successful completion, FALSE otherwise
169 * @rep:displayname Set Release Class Options
170 * @rep:scope public
171 * @rep:lifecycle active
172 * @rep:compatibility S
173 */
174 function set_rel_class_options (application IN varchar2 default NULL,
175 class_name IN varchar2 default NULL,
176 cancel_or_hold IN varchar2 default 'H',
177 stale_date IN varchar2 default NULL)
178 return boolean;
179
180 --
181 -- Name
182 -- set_org_id
183 -- Purpose
184 -- Called before submitting request if the program is 'Sinle' multi org catagory.,
185 --
186 -- Arguments
187 -- org_id - Operating unit id
188 --
189 procedure set_org_id(org_id IN number default NULL);
190
191 --
192 -- Name
193 -- set_print_options
194 -- Purpose
195 -- Called before submitting request if the printing of output has
196 -- to be controlled with specific printer/style/copies etc.,
197 --
198 -- Arguments
199 -- printer - Printer name where the request o/p should be sent
200 -- style - Print style that needs to be used for printing
201 -- copies - Number of copies to print
202 -- save_output - Should the output file be saved after printing
203 -- - Default is TRUE. TRUE/FALSE
204 -- print_together - Applies only for sub requests. If 'Y', output
205 -- - will not be printed until all the sub requests
206 -- - complete. Default is 'N'. ( Y/N )
207 --
208 /*#
209 * Sets request set print options like printer, print style, copies, etc. for a given request (context-sensitive)
210 * @param printer Printer name for the output
211 * @param style Print style to be used for printing
212 * @param copies Number of copies to print
213 * @param save_output Specify TRUE if the output should be saved after printing, FALSE Otherwise
214 * @param print_together Applicable only to subrequests. If 'Y' the output will not be printed until all the sub-requests are completed. Default is 'N'
215 * @rep:displayname Set print options
216 * @rep:scope public
217 * @rep:lifecycle active
218 * @rep:compatibility S
219 */
220 function set_print_options (printer IN varchar2 default NULL,
221 style IN varchar2 default NULL,
222 copies IN number default NULL,
223 save_output IN boolean default TRUE,
224 print_together IN varchar2 default 'N')
225 return boolean;
226
227
228 --
229 -- Name
230 -- add_printer
231 -- Purpose
232 -- Called after set print options to add a printer to the
233 -- print list.
234 --
235 -- Arguments
236 -- printer - Printer name where the request o/p should be sent
237 -- copies - Number of copies to print
238 /*#
239 * Adds printer to the printer list (context-sensitive, i.e. works on the request that is currently in context)
240 * @param printer Printer name where the printer output should be sent
241 * @param copies Number of copies to print
242 * @return Returns TRUE on successful completion, FALSE otherwise
243 * @rep:displayname Add Printer
244 * @rep:scope public
245 * @rep:lifecycle active
246 * @rep:compatibility S
247 */
248 function add_printer (printer in varchar2 default null,
249 copies in number default null) return boolean;
250
251 --
252 -- Name
253 -- add_notification
254 -- Purpose
255 -- Called before submission to add a user to the notify list.
256 --
257 -- Arguments
258 -- User - User name.
259 /*#
260 * Adds user to the notification list of a particular request (context-sensitive i.e. works on the request currently in context)
261 * @param user User name
262 * @return Returns TRUE on successful completion, FALSE otherwise
263 * @rep:displayname Add Notification
264 * @rep:scope public
265 * @rep:lifecycle active
266 * @rep:compatibility S
267 */
268 function add_notification (
269 user in varchar2,
270 on_normal in varchar2 default 'Y',
271 on_warning in varchar2 default 'N',
272 on_error in varchar2 default 'N' ) return boolean;
273
274
275 -- --
276 -- Name
277 -- set_request_set
278 -- Purpose
279 --
280 -- To set the request set context. Call this function at very
281 -- beginning of the submission of a concurrent request set transaction.
282 -- Call this function after calling the optional functions SET_MODE,
283 -- SET_REL_CLASS_OPTIONS, SET_REPEAT_OPTIONS.
284 -- It returns TRUE on sucessful completion, and FALSE otherwise.
285 -- Arguments
286 -- application - Application short name
287 -- request_set - Developer Request set name
288 --
289 /*#
290 * Sets the request set context
291 * @param request_set The short name of the request set
292 * @param application The short name of the application that owns the request set
293 * @return Returns TRUE on successful completion, FALSE otherwise
294 * @rep:displayname Set Request Set Context
295 * @rep:scope public
296 * @rep:lifecycle active
297 * @rep:compatibility S
298 */
299 function set_request_set (
300 application IN varchar2,
301 request_set IN varchar2
302 ) return boolean;
303
304 --
305 -- Name
306 -- submit_program
307 -- Purpose
308 -- Submits concurrent request for the program in the request set to be
309 -- processed by a concurrent manager.
310 -- Before calling this function you may want to call the optional functions
311 -- SET_PRINT_OPTIONS, ADD_PRINTER, ADD_NOTIFICATION, SET_NLS_OPTIONS.
312 -- Call submit_program for each program (report) in the request set.
313 -- You must call set_request_set before calling this function. You have to
314 -- call set_request_set only once for all the submit_program calls for that
315 -- request set.
316 -- This function returns TRUE on successful completion,
317 -- and FALSE otherwise.
318 --
319 -- Arguments
320 -- application - Short name of application under which the program
321 -- - is registered
322 -- program - concurrent program name for which the request has
323 -- - to be submitted
324 -- stage - stage name for which the request has to be submitted
325 --
326 -- argument1..100 - Optional. Arguments for the concurrent request
327 --
328 /*#
329 * Submits a program for execution in the concurrent processing system
330 * @param application The short name of the application associated with the program within a report set
331 * @param program The short name of the program with the report set
332 * @param stage The developer name of the request set stage that the program belongs to
333 * @param argument1 Argument for concurrent request
334 * @param argument2 Argument for concurrent request
335 * @param argument3 Argument for concurrent request
336 * @param argument4 Argument for concurrent request
337 * @param argument5 Argument for concurrent request
338 * @param argument6 Argument for concurrent request
339 * @param argument7 Argument for concurrent request
340 * @param argument8 Argument for concurrent request
341 * @param argument9 Argument for concurrent request
342 * @param argument10 Argument for concurrent request
343 * @param argument11 Argument for concurrent request
344 * @param argument12 Argument for concurrent request
345 * @param argument13 Argument for concurrent request
346 * @param argument14 Argument for concurrent request
347 * @param argument15 Argument for concurrent request
348 * @param argument16 Argument for concurrent request
349 * @param argument17 Argument for concurrent request
350 * @param argument18 Argument for concurrent request
351 * @param argument19 Argument for concurrent request
352 * @param argument20 Argument for concurrent request
353 * @param argument21 Argument for concurrent request
354 * @param argument22 Argument for concurrent request
355 * @param argument23 Argument for concurrent request
356 * @param argument24 Argument for concurrent request
357 * @param argument25 Argument for concurrent request
358 * @param argument26 Argument for concurrent request
359 * @param argument27 Argument for concurrent request
363 * @param argument31 Argument for concurrent request
360 * @param argument28 Argument for concurrent request
361 * @param argument29 Argument for concurrent request
362 * @param argument30 Argument for concurrent request
364 * @param argument32 Argument for concurrent request
365 * @param argument33 Argument for concurrent request
366 * @param argument34 Argument for concurrent request
367 * @param argument35 Argument for concurrent request
368 * @param argument36 Argument for concurrent request
369 * @param argument37 Argument for concurrent request
370 * @param argument38 Argument for concurrent request
371 * @param argument39 Argument for concurrent request
372 * @param argument40 Argument for concurrent request
373 * @param argument41 Argument for concurrent request
374 * @param argument42 Argument for concurrent request
375 * @param argument43 Argument for concurrent request
376 * @param argument44 Argument for concurrent request
377 * @param argument45 Argument for concurrent request
378 * @param argument46 Argument for concurrent request
379 * @param argument47 Argument for concurrent request
380 * @param argument48 Argument for concurrent request
381 * @param argument49 Argument for concurrent request
382 * @param argument50 Argument for concurrent request
383 * @param argument51 Argument for concurrent request
384 * @param argument52 Argument for concurrent request
385 * @param argument53 Argument for concurrent request
386 * @param argument54 Argument for concurrent request
387 * @param argument55 Argument for concurrent request
388 * @param argument56 Argument for concurrent request
389 * @param argument57 Argument for concurrent request
390 * @param argument58 Argument for concurrent request
391 * @param argument59 Argument for concurrent request
392 * @param argument60 Argument for concurrent request
393 * @param argument61 Argument for concurrent request
394 * @param argument62 Argument for concurrent request
395 * @param argument63 Argument for concurrent request
396 * @param argument64 Argument for concurrent request
397 * @param argument65 Argument for concurrent request
398 * @param argument66 Argument for concurrent request
399 * @param argument67 Argument for concurrent request
400 * @param argument68 Argument for concurrent request
401 * @param argument69 Argument for concurrent request
402 * @param argument70 Argument for concurrent request
403 * @param argument71 Argument for concurrent request
404 * @param argument72 Argument for concurrent request
405 * @param argument73 Argument for concurrent request
406 * @param argument74 Argument for concurrent request
407 * @param argument75 Argument for concurrent request
408 * @param argument76 Argument for concurrent request
409 * @param argument77 Argument for concurrent request
410 * @param argument78 Argument for concurrent request
411 * @param argument79 Argument for concurrent request
412 * @param argument80 Argument for concurrent request
413 * @param argument81 Argument for concurrent request
414 * @param argument82 Argument for concurrent request
415 * @param argument83 Argument for concurrent request
416 * @param argument84 Argument for concurrent request
417 * @param argument85 Argument for concurrent request
418 * @param argument86 Argument for concurrent request
419 * @param argument87 Argument for concurrent request
420 * @param argument88 Argument for concurrent request
421 * @param argument89 Argument for concurrent request
422 * @param argument90 Argument for concurrent request
423 * @param argument91 Argument for concurrent request
424 * @param argument92 Argument for concurrent request
425 * @param argument93 Argument for concurrent request
426 * @param argument94 Argument for concurrent request
427 * @param argument95 Argument for concurrent request
428 * @param argument96 Argument for concurrent request
429 * @param argument97 Argument for concurrent request
430 * @param argument98 Argument for concurrent request
431 * @param argument99 Argument for concurrent request
432 * @param argument100 Argument for concurrent request
433 * @return Returns TRUE on successful completion, FALSE otherwise
434 * @rep:displayname Submit Program
435 * @rep:scope public
436 * @rep:lifecycle active
437 * @rep:compatibility S
438 */
439 function submit_program (
440 application IN varchar2 default NULL,
441 program IN varchar2 default NULL,
442 stage IN varchar2 default NULL,
443 argument1 IN varchar2 default CHR(0),
444 argument2 IN varchar2 default CHR(0),
445 argument3 IN varchar2 default CHR(0),
446 argument4 IN varchar2 default CHR(0),
447 argument5 IN varchar2 default CHR(0),
448 argument6 IN varchar2 default CHR(0),
449 argument7 IN varchar2 default CHR(0),
450 argument8 IN varchar2 default CHR(0),
451 argument9 IN varchar2 default CHR(0),
452 argument10 IN varchar2 default CHR(0),
453 argument11 IN varchar2 default CHR(0),
454 argument12 IN varchar2 default CHR(0),
455 argument13 IN varchar2 default CHR(0),
456 argument14 IN varchar2 default CHR(0),
457 argument15 IN varchar2 default CHR(0),
458 argument16 IN varchar2 default CHR(0),
459 argument17 IN varchar2 default CHR(0),
460 argument18 IN varchar2 default CHR(0),
461 argument19 IN varchar2 default CHR(0),
462 argument20 IN varchar2 default CHR(0),
463 argument21 IN varchar2 default CHR(0),
464 argument22 IN varchar2 default CHR(0),
465 argument23 IN varchar2 default CHR(0),
466 argument24 IN varchar2 default CHR(0),
467 argument25 IN varchar2 default CHR(0),
468 argument26 IN varchar2 default CHR(0),
469 argument27 IN varchar2 default CHR(0),
470 argument28 IN varchar2 default CHR(0),
471 argument29 IN varchar2 default CHR(0),
472 argument30 IN varchar2 default CHR(0),
476 argument34 IN varchar2 default CHR(0),
473 argument31 IN varchar2 default CHR(0),
474 argument32 IN varchar2 default CHR(0),
475 argument33 IN varchar2 default CHR(0),
477 argument35 IN varchar2 default CHR(0),
478 argument36 IN varchar2 default CHR(0),
479 argument37 IN varchar2 default CHR(0),
480 argument38 IN varchar2 default CHR(0),
481 argument39 IN varchar2 default CHR(0),
482 argument40 IN varchar2 default CHR(0),
483 argument41 IN varchar2 default CHR(0),
484 argument42 IN varchar2 default CHR(0),
485 argument43 IN varchar2 default CHR(0),
486 argument44 IN varchar2 default CHR(0),
487 argument45 IN varchar2 default CHR(0),
488 argument46 IN varchar2 default CHR(0),
489 argument47 IN varchar2 default CHR(0),
490 argument48 IN varchar2 default CHR(0),
491 argument49 IN varchar2 default CHR(0),
492 argument50 IN varchar2 default CHR(0),
493 argument51 IN varchar2 default CHR(0),
494 argument52 IN varchar2 default CHR(0),
495 argument53 IN varchar2 default CHR(0),
496 argument54 IN varchar2 default CHR(0),
497 argument55 IN varchar2 default CHR(0),
498 argument56 IN varchar2 default CHR(0),
499 argument57 IN varchar2 default CHR(0),
500 argument58 IN varchar2 default CHR(0),
501 argument59 IN varchar2 default CHR(0),
502 argument60 IN varchar2 default CHR(0),
503 argument61 IN varchar2 default CHR(0),
504 argument62 IN varchar2 default CHR(0),
505 argument63 IN varchar2 default CHR(0),
506 argument64 IN varchar2 default CHR(0),
507 argument65 IN varchar2 default CHR(0),
508 argument66 IN varchar2 default CHR(0),
509 argument67 IN varchar2 default CHR(0),
510 argument68 IN varchar2 default CHR(0),
511 argument69 IN varchar2 default CHR(0),
512 argument70 IN varchar2 default CHR(0),
513 argument71 IN varchar2 default CHR(0),
514 argument72 IN varchar2 default CHR(0),
515 argument73 IN varchar2 default CHR(0),
516 argument74 IN varchar2 default CHR(0),
517 argument75 IN varchar2 default CHR(0),
518 argument76 IN varchar2 default CHR(0),
519 argument77 IN varchar2 default CHR(0),
520 argument78 IN varchar2 default CHR(0),
521 argument79 IN varchar2 default CHR(0),
522 argument80 IN varchar2 default CHR(0),
523 argument81 IN varchar2 default CHR(0),
524 argument82 IN varchar2 default CHR(0),
525 argument83 IN varchar2 default CHR(0),
526 argument84 IN varchar2 default CHR(0),
527 argument85 IN varchar2 default CHR(0),
528 argument86 IN varchar2 default CHR(0),
529 argument87 IN varchar2 default CHR(0),
530 argument88 IN varchar2 default CHR(0),
531 argument89 IN varchar2 default CHR(0),
532 argument90 IN varchar2 default CHR(0),
533 argument91 IN varchar2 default CHR(0),
534 argument92 IN varchar2 default CHR(0),
535 argument93 IN varchar2 default CHR(0),
536 argument94 IN varchar2 default CHR(0),
537 argument95 IN varchar2 default CHR(0),
538 argument96 IN varchar2 default CHR(0),
539 argument97 IN varchar2 default CHR(0),
540 argument98 IN varchar2 default CHR(0),
541 argument99 IN varchar2 default CHR(0),
542 argument100 IN varchar2 default CHR(0))
543 return boolean;
544
545 -- --
546 -- Name
547 -- submit_set
548 -- Purpose
549 -- Call this function to submit the request set which is set by using the
550 -- set_request_set.
551 -- It will check whether each program in the request set is submitted
552 -- by using submit_program or not.
553 -- If the request completes successfully, this function returns the
554 -- concurrent request ID of the parent request set; otherwise;
555 -- it returns 0.
556 -- Arguments
557 -- None
558 /*#
559 * Submits a request set for execution in the concurrent processing system
560 * @param start_time The time at which the request should start running
561 * @param sub_request Set to TRUE if the request is submitted from another request and should be treated as a sub-request
562 * @return Returns the concurrent program ID on successful submission, otherwise it returns '0'
563 * @rep:displayname Message
564 * @rep:scope public
565 * @rep:lifecycle active
566 * @rep:compatibility S
567 */
568 function submit_set ( start_time IN varchar2 default null,
569 sub_request In boolean default FALSE)
570 return integer;
571
572 procedure set_dest_ops(ops_id IN number default NULL);
573
574
575 --
576 -- Name
577 -- add_layout
578 -- Purpose
579 -- Called before submission to add layout options to a request.
580 --
581 -- Arguments
582 -- template_appl_name - Template application short name
583 -- template_code - Template code
584 -- template_language - ISO 2-letter language code
585 -- template_territory - ISO 2-letter territory code
586 -- output_format - Output format type of the final output
587 function add_layout(template_appl_name in varchar2,
588 template_code in varchar2,
589 template_language in varchar2,
590 template_territory in varchar2,
591 output_format in varchar2) return boolean;
592
593
594
595
596
597
598
599 --
600 -- Name
601 -- add_delivery_option
602 -- Purpose
603 -- Called before submission to add a delivery option
604 --
605 -- Arguments
606 -- Type - Delivery type, see FND_DELIVERY
607 -- p_argument1 - p_argument9 - Options specific to the delivery type
611 p_argument1 in varchar2 default null,
608 -- nls_language - Add only for this language
609 --
610 function add_delivery_option ( type in varchar2,
612 p_argument2 in varchar2 default null,
613 p_argument3 in varchar2 default null,
614 p_argument4 in varchar2 default null,
615 p_argument5 in varchar2 default null,
616 p_argument6 in varchar2 default null,
617 p_argument7 in varchar2 default null,
618 p_argument8 in varchar2 default null,
619 p_argument9 in varchar2 default null,
620 nls_language in varchar2 default null) return boolean;
621
622
623 function add_email (subject in varchar2,
624 from_address in varchar2,
625 to_address in varchar2,
626 cc in varchar2 default null,
627 lang in varchar2 default null) return boolean;
628
629 function add_ipp_printer (printer_name in varchar2,
630 copies in number default null,
631 orientation in varchar2 default null,
632 username in varchar2 default null,
633 password in varchar2 default null,
634 lang in varchar2 default null) return boolean;
635
636
637
638 function add_ipp_printer (printer_id in number,
639 copies in number default null,
640 orientation in varchar2 default null,
641 username in varchar2 default null,
642 password in varchar2 default null,
643 lang in varchar2 default null) return boolean;
644
645
646 function add_fax ( server_name in varchar2,
647 fax_number in varchar2,
648 username in varchar2 default null,
649 password in varchar2 default null,
650 lang in varchar2 default null) return boolean;
651
652
653 function add_fax ( server_id in number,
654 fax_number in varchar2,
655 username in varchar2 default null,
656 password in varchar2 default null,
657 lang in varchar2 default null) return boolean;
658
659
660 function add_ftp ( server in varchar2,
661 username in varchar2,
662 password in varchar2,
663 remote_dir in varchar2,
664 port in varchar2 default null,
665 secure in boolean default FALSE,
666 lang in varchar2 default null) return boolean;
667
668 function add_webdav ( server in varchar2,
669 remote_dir in varchar2,
670 port in varchar2 default null,
671 username in varchar2 default null,
672 password in varchar2 default null,
673 authtype in varchar2 default null,
674 enctype in varchar2 default null,
675 lang in varchar2 default null) return boolean;
676
677 function add_http ( server in varchar2,
678 remote_dir in varchar2,
679 port in varchar2 default null,
680 username in varchar2 default null,
681 password in varchar2 default null,
682 authtype in varchar2 default null,
683 enctype in varchar2 default null,
684 method in varchar2 default null,
685 lang in varchar2 default null) return boolean;
686
687 function add_custom ( custom_id in number,
688 lang in varchar2 default null) return boolean;
689
690 function add_custom ( custom_name in varchar2,
691 lang in varchar2 default null) return boolean;
692
693 function add_burst return boolean;
694
695 -- Bug5680619 5680669
696 -- Name
697 -- justify_program
698 -- Purpose
699 -- It lists all the disabled program in request set
700 -- Call this function at the first step of the submission of a concurrent
701 -- request set transaction.
702 -- It returns a string containing all disabled program name based on
703 -- the criticality
704 -- Arguments
705 -- template_appl_name - Template application short name
706 -- template_request_set_name - Template Request Set Name
707
708 function justify_program(template_appl_name in varchar2,
709 template_request_set_name in varchar2) return varchar2;
710
711 end FND_SUBMIT;