1 package FND_REQUEST AUTHID CURRENT_USER as
2 /* $Header: AFCPREQS.pls 120.13.12020000.2 2012/07/13 20:45:56 pferguso ship $ */
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 -- Package
15 -- FND_REQUEST
16 --
17 -- Purpose
18 -- Concurrent processing related utilities
19 --
20 -- History
21 -- XX-XXX-93 Ram Bhoopalam Created
22 -- 08-FEB-94 H Pelimuhandiram Gave life
23 --
24
25 --
26 -- PUBLIC VARIABLES
27 --
28
29 -- Exceptions
30
31 -- Exception Pragmas
32
33 --
34 -- PUBLIC FUNCTIONS
35 --
36
37 --
38 -- Name
39 -- set_mode
40 -- Purpose
41 -- Called before submitting request to set mode to 'database trigger'
42 --
43 -- Arguments
44 -- db_trigger - Set to TRUE for database trigger mode
45 --
46 /*#
47 * Called before submitting a request to set the database trigger mode
48 * @param db_trigger Set to TRUE if the request is submitted from a database trigger
49 * @return Returns TRUE on successful completion
50 * @rep:displayname Set database trigger mode
51 * @rep:scope public
52 * @rep:lifecycle active
53 */
54 function set_mode (db_trigger IN boolean) return boolean;
55 pragma restrict_references (set_mode, WNDS, RNDS);
56
57 --
58 -- Name
59 -- set_options
60 -- Purpose
61 -- Called before submitting request to set request attributes
62 --
63 -- Arguments
64 -- implicit - nature of the request to be submitted
65 -- - NO/YES/ERROR/WARNING
66 -- protected - Is the request protected against updates
67 -- - YES/NO default is NO
68 -- language - NLS language
69 -- territory - Language territory
70 -- datagroup
71 -- numeric_characters - NLS Numeric Characters
72 --
73 /*#
74 * Sets miscellaneous request options
75 * @param implicit Determines whether to display the concurrent request in the end user's concurrent request form.
76 * Takes values 'NO', 'YES','ERROR','WARNING'.
77 * @param protected Specify 'YES' if the request is protected against updates, otherwise specify 'NO'
78 * @param language Indicates NLS languages. Defaults to the current language if left NULL
79 * @param territory Indicates language territory. Defaults to the current language territory if left NULL
80 * @return Returns TRUE on successful completion,FALSE otherwise
81 * @rep:displayname Set Request Options
82 * @rep:scope public
83 * @rep:lifecycle active
84 * @rep:compatibility S
85 */
86 function set_options (implicit IN varchar2 default 'NO',
87 protected IN varchar2 default 'NO',
88 language IN varchar2 default NULL,
89 territory IN varchar2 default NULL,
90 datagroup IN varchar2 default NULL,
91 numeric_characters IN varchar2 default NULL)
92 return boolean;
93 pragma restrict_references (set_options, WNDS);
94
95
96 procedure set_dest_ops(ops_id IN number default NULL);
97
98 procedure set_org_id(org_id IN number default NULL);
99
100 --
101 -- Name
102 -- set_repeat_options
103 -- Purpose
104 -- Called before submitting request if the request to be submitted
105 -- is a repeating request.
106 --
107 -- Arguments
108 -- repeat_time - Time of day at which it has to be repeated
109 -- repeat_interval - Frequency at which it has to be repeated
110 -- - This will be used/applied only when repeat_time
111 -- - is NULL
112 -- repeat_unit - Unit for repeat interval. Default is DAYS
113 -- - MONTHS/DAYS/HOURS/MINUTES
114 -- repeat_type - Apply repeat interval from START or END of request
115 -- - default is START. START/END
116 -- repeat_end_time - Time at which the repetition should be stopped
117 --
118 /*#
119 * Sets scheduling options for the concurrent request
120 * @param repeat_time The time of the day to repeat the concurrent request
121 * @param repeat_interval Interval between the re-submissions of the request
122 * @param repeat_unit The unit of time used along with repeat_interval to specify the time between resubmissions of the request.
123 * This parameter applies only when repeat_time is NULL.
124 * @param repeat_type Determines whether to apply the re-submission interval from either the 'START' or the 'END' of the request's
125 * execution. This parameter applies only when repeat_time is NULL.
126 * @param repeat_end_time The date and time to stop resubmitting the concurrent request,
127 * formatted as either 'DD-MON-YYYY HH24:MI:SS' or 'DD-MON-RR HH24:MI:SS'
128 * @return Returns TRUE on successful completion, otherwise FALSE
129 * @rep:displayname Set Repeat Options
130 * @rep:scope public
131 * @rep:lifecycle active
132 * @rep:compatibility S
133 */
134 function set_repeat_options (repeat_time IN varchar2 default NULL,
135 repeat_interval IN number default NULL,
136 repeat_unit IN varchar2 default 'DAYS',
137 repeat_type IN varchar2 default 'START',
138 repeat_end_time IN varchar2 default NULL,
139 increment_dates IN varchar2 default NULL)
140 return boolean;
141 pragma restrict_references (set_repeat_options, WNDS);
142
143 --
144 -- Name
145 -- set_increment_dates_option
146 -- Purpose
147 -- Called before submitting request if the request to be submitted
148 -- has a schedule set that repeats. Making this available outside of
149 -- set_repeat_options in case the repeating schedule is set with
150 -- set_rel_class_options or fnd_conc_release_class_utils.assign_specific_sch
151 --
152 -- Arguments
153 -- incrment_dates - 'Y' if dates should be incremented each run,
154 -- otherwise 'N'
155 --
156 /*#
157 * Sets the increment date parameters option for the concurrent request
158 * @param increment_dates 'Y' if date parameters should be incremented each run, otherwise 'N'
159 * @rep:displayname Set Increment Dates Option
160 * @rep:scope public
161 * @rep:lifecycle active
162 * @rep:compatibility S
163 */
164 procedure set_increment_dates_option (increment_dates IN varchar2);
165 pragma restrict_references (set_increment_dates_option, WNDS);
166
167 --
168 -- Name
169 -- set_rel_class_options
170 -- Purpose
171 -- Called before submitting request if the request to be submitted
172 -- is using the new scheduler functionality.
173 --
174 -- Arguments
175 -- application - Application Name of Release Class
176 -- class_name - (Developer) Name of Release Class
177 -- cancel_or_hold - Cancel or hold flag
178 -- stale_date - Cancel request on or after this time if not run
179 --
180 function set_rel_class_options (application IN varchar2 default NULL,
181 class_name IN varchar2 default NULL,
182 cancel_or_hold IN varchar2 default 'H',
183 stale_date IN varchar2 default NULL)
184 return boolean;
185 pragma restrict_references (set_rel_class_options, WNDS);
186
187 -- Name
188 -- set_target_options
189 -- Purpose
190 -- Called before submitting request to set target node and or connect
191 -- string (instance) for the request. Currently only primary target
192 -- node and connect string are honored and the connect string must be
193 -- the name of a RAC instance.
194 --
195 -- Arguments
196 -- node_name1 - primary target node
197 -- instance1 - primary target instance (connect string)
198 -- node_name2 - secondary target node
199 -- instance2 - secondary target instance (connect string)
200 --
201 -- --
202 function set_target_options (node_name1 IN varchar2 default NULL,
203 instance1 IN varchar2 default NULL,
204 node_name2 IN varchar2 default NULL,
205 instance2 IN varchar2 default NULL)
206 return boolean;
207
208 --
209 -- Name
210 -- set_print_options
211 -- Purpose
212 -- Called before submitting request if the printing of output has
213 -- to be controlled with specific printer/style/copies etc.,
214 --
215 -- Arguments
216 -- printer - Printer name where the request o/p should be sent
217 -- style - Print style that needs to be used for printing
218 -- copies - Number of copies to print
219 -- save_output - Should the output file be saved after printing
220 -- - Default is TRUE. TRUE/FALSE
221 -- print_together - Applies only for sub requests. If 'Y', output
222 -- - will not be printed until all the sub requests
223 -- - complete. Default is 'N'. ( Y/N )
224 -- validate_printer - Once submit function is called
225 -- - with a specific program, if the printer specified
226 -- - here conflicts with a printer setting at the
227 -- - program level, one of three options is available:
228 -- - FAIL - raise an error and fail to submit
229 -- - SKIP - skip this print pp action, but submit anyway
230 -- - RESOLVE - switch to the valid printer, if printer
231 -- - and style are compatible
232 -- - Default is RESOLVE
233 --
234 /*#
235 * Sets the print options for the concurrent request
236 * @param printer The name of the printer to which the concurrent request output should to be sent
237 * @param style Style used to print request output
238 * @param copies Number of copies of the request output to print
239 * @param save_output Indicates whether to save the output file
240 * @param print_together This parameter applies only to those requests containing sub-requests.
241 * 'Y' indicates that output of the sub-request should not be printed until all sub-requests complete.
242 * 'N' indicates that output of the sub-request should be printed as it completes.
243 * @param validate_printer Once submit function is called with a specific program, if the printer specified here conflicts with a printer setting at the program level, one of three options is available, with a default of RESOLVE
244 * FAIL - raise an error and fail to submit
245 * SKIP - skip this print pp action, but submit anyway
246 * RESOLVE - switch to the valid printer, if printer and style are compatible
247 * @return TRUE on successful completion, otherwise FALSE
248 * @rep:displayname Set Print Options
249 * @rep:scope public
250 * @rep:lifecycle active
251 * @rep:compatibility S
252 */
253 function set_print_options (printer IN varchar2 default NULL,
254 style IN varchar2 default NULL,
255 copies IN number default NULL,
256 save_output IN boolean default TRUE,
257 print_together IN varchar2 default 'N',
258 validate_printer IN varchar2 default 'RESOLVE')
259 return boolean;
260 pragma restrict_references (set_print_options, WNDS);
261
262
263 --
264 -- Name
265 -- use_current_notification
266 -- Purpose
267 -- Called before submitting a sub-request to reuse the same notification
268 -- options as the current request
269 --
270 -- Arguments
271 -- none
272 function use_current_notification return boolean;
273 pragma restrict_references (use_current_notification, WNDS);
274
275
276 --
277 -- Name
278 -- add_printer
279 -- Purpose
280 -- Called after set print options to add a printer to the
281 -- print list.
282 --
283 -- Arguments
284 -- printer - Printer name where the request o/p should be sent
285 -- copies - Number of copies to print
286 function add_printer (printer in varchar2 default null,
287 copies in number default null) return boolean;
288 pragma restrict_references (add_printer, WNDS);
289
290 function add_printer (printer in varchar2 default null,
291 copies in number default null,
292 lang in varchar2) return boolean;
293 pragma restrict_references (add_printer, WNDS);
294
295
296
297
298 --
299 -- Name
300 -- add_notification
304 -- Arguments
301 -- Purpose
302 -- Called before submission to add a user to the notify list.
303 --
305 -- User - User name.
306
307 -- Added an overload of the 1 parameter for function
308 function add_notification (user in varchar2) return boolean;
309 pragma restrict_references (add_notification, WNDS);
310
311 function add_notification (user in varchar2,
312 nls_language in varchar2) return boolean;
313 pragma restrict_references (add_notification, WNDS);
314
315
316 --
317 -- Name
318 -- add_layout
319 -- Purpose
320 -- Called before submission to add layout options for request output.
321 --
322 -- Arguments
323 -- Template_APPL_Name - Template Application Short name.
324 -- Template_code - Template code
325 -- Template_Language - Template File language (iso value)
326 -- Template_Territory - Template File Territory (iso value)
327 -- Output Format - Output Format
328 --
329
330 -- Added an overload of the 5 parameters for function
331 function add_layout (template_appl_name in varchar2,
332 template_code in varchar2,
333 template_language in varchar2,
334 template_territory in varchar2,
335 output_format in varchar2
336 ) return boolean;
337
338 function add_layout (template_appl_name in varchar2,
339 template_code in varchar2,
340 template_language in varchar2,
341 template_territory in varchar2,
342 output_format in varchar2,
343 nls_language in varchar2) return boolean;
344
345
346
347 --
348 -- Name
349 -- add_language
350 -- Purpose
351 -- Called before submission to submit a request in a particular language
352 -- Can be called multiple times to submit a request in multiple languages
353 --
354 -- Arguments
355 -- Lang - Language
356 -- Territory - Territory
357 -- Num_char - Numeric characters
358 --
359 function add_language (
360 lang IN VARCHAR2,
361 territory IN VARCHAR2,
362 num_char IN VARCHAR2) return boolean;
363
364
365
366 --
367 -- Name
368 -- add_delivery_option
369 -- Purpose
370 -- Called before submission to add a delivery option
371 --
372 -- Arguments
373 -- Type - Delivery type, see FND_DELIVERY
374 -- p_argument1 - p_argument9 - Options specific to the delivery type
375 -- nls_language - Add only for this language
376 function add_delivery_option ( type in varchar2,
377 p_argument1 in varchar2 default null,
378 p_argument2 in varchar2 default null,
379 p_argument3 in varchar2 default null,
380 p_argument4 in varchar2 default null,
381 p_argument5 in varchar2 default null,
382 p_argument6 in varchar2 default null,
383 p_argument7 in varchar2 default null,
384 p_argument8 in varchar2 default null,
385 p_argument9 in varchar2 default null,
386 nls_language in varchar2 default null) return boolean;
387 --
388 -- Name
389 -- submit_request
390 -- Purpose
391 -- Submits concurrent request to be processed by a concurrent manager
392 --
393 -- Arguments
394 -- application - Short name of application under which the program
395 -- - is registered
396 -- program - concurrent program name for which the request has
397 -- - to be submitted
398 -- description - Optional. Will be displayed along with user
399 -- - concurrent program name
400 -- start_time - Optional. Time at which the request has to start
401 -- - running
402 -- sub_request - Optional. Set to TRUE if the request is submitted
403 -- - from another running request and has to be treated
404 -- - as a sub request. Default is FALSE
405 -- argument1..100 - Optional. Arguments for the concurrent request
406 --
407 /*#
408 * Submits a request for processing by a concurrent manager
409 * @param application Short name of the application associated with the concurrent request to be submitted
410 * @param program Short name of the concurrent program for which the request should be submitted
411 * @param description Description of the request that is displayed in the concurrent request's form
412 * @param start_time Time at which the request should start running
413 * @param sub_request Set to TRUE if the request is submitted from another request and should be treated as a sub-request
414 * @param argument1 Argument for concurrent request
415 * @param argument2 Argument for concurrent request
416 * @param argument3 Argument for concurrent request
417 * @param argument4 Argument for concurrent request
418 * @param argument5 Argument for concurrent request
419 * @param argument6 Argument for concurrent request
420 * @param argument7 Argument for concurrent request
421 * @param argument8 Argument for concurrent request
422 * @param argument9 Argument for concurrent request
423 * @param argument10 Argument for concurrent request
424 * @param argument11 Argument for concurrent request
425 * @param argument12 Argument for concurrent request
426 * @param argument13 Argument for concurrent request
427 * @param argument14 Argument for concurrent request
428 * @param argument15 Argument for concurrent request
429 * @param argument16 Argument for concurrent request
430 * @param argument17 Argument for concurrent request
431 * @param argument18 Argument for concurrent request
435 * @param argument22 Argument for concurrent request
432 * @param argument19 Argument for concurrent request
433 * @param argument20 Argument for concurrent request
434 * @param argument21 Argument for concurrent request
436 * @param argument23 Argument for concurrent request
437 * @param argument24 Argument for concurrent request
438 * @param argument25 Argument for concurrent request
439 * @param argument26 Argument for concurrent request
440 * @param argument27 Argument for concurrent request
441 * @param argument28 Argument for concurrent request
442 * @param argument29 Argument for concurrent request
443 * @param argument30 Argument for concurrent request
444 * @param argument31 Argument for concurrent request
445 * @param argument32 Argument for concurrent request
446 * @param argument33 Argument for concurrent request
447 * @param argument34 Argument for concurrent request
448 * @param argument35 Argument for concurrent request
449 * @param argument36 Argument for concurrent request
450 * @param argument37 Argument for concurrent request
451 * @param argument38 Argument for concurrent request
452 * @param argument39 Argument for concurrent request
453 * @param argument40 Argument for concurrent request
454 * @param argument41 Argument for concurrent request
455 * @param argument42 Argument for concurrent request
456 * @param argument43 Argument for concurrent request
457 * @param argument44 Argument for concurrent request
458 * @param argument45 Argument for concurrent request
459 * @param argument46 Argument for concurrent request
460 * @param argument47 Argument for concurrent request
461 * @param argument48 Argument for concurrent request
462 * @param argument49 Argument for concurrent request
463 * @param argument50 Argument for concurrent request
464 * @param argument51 Argument for concurrent request
465 * @param argument52 Argument for concurrent request
466 * @param argument53 Argument for concurrent request
467 * @param argument54 Argument for concurrent request
468 * @param argument55 Argument for concurrent request
469 * @param argument56 Argument for concurrent request
470 * @param argument57 Argument for concurrent request
471 * @param argument58 Argument for concurrent request
472 * @param argument59 Argument for concurrent request
473 * @param argument60 Argument for concurrent request
474 * @param argument61 Argument for concurrent request
475 * @param argument62 Argument for concurrent request
476 * @param argument63 Argument for concurrent request
477 * @param argument64 Argument for concurrent request
478 * @param argument65 Argument for concurrent request
479 * @param argument66 Argument for concurrent request
480 * @param argument67 Argument for concurrent request
481 * @param argument68 Argument for concurrent request
482 * @param argument69 Argument for concurrent request
483 * @param argument70 Argument for concurrent request
484 * @param argument71 Argument for concurrent request
485 * @param argument72 Argument for concurrent request
486 * @param argument73 Argument for concurrent request
487 * @param argument74 Argument for concurrent request
488 * @param argument75 Argument for concurrent request
489 * @param argument76 Argument for concurrent request
490 * @param argument77 Argument for concurrent request
491 * @param argument78 Argument for concurrent request
492 * @param argument79 Argument for concurrent request
493 * @param argument80 Argument for concurrent request
494 * @param argument81 Argument for concurrent request
495 * @param argument82 Argument for concurrent request
496 * @param argument83 Argument for concurrent request
497 * @param argument84 Argument for concurrent request
498 * @param argument85 Argument for concurrent request
499 * @param argument86 Argument for concurrent request
500 * @param argument87 Argument for concurrent request
501 * @param argument88 Argument for concurrent request
502 * @param argument89 Argument for concurrent request
503 * @param argument90 Argument for concurrent request
504 * @param argument91 Argument for concurrent request
505 * @param argument92 Argument for concurrent request
506 * @param argument93 Argument for concurrent request
507 * @param argument94 Argument for concurrent request
508 * @param argument95 Argument for concurrent request
509 * @param argument96 Argument for concurrent request
510 * @param argument97 Argument for concurrent request
511 * @param argument98 Argument for concurrent request
512 * @param argument99 Argument for concurrent request
513 * @param argument100 Argument for concurrent request
514 * @return Returns requestid of submitted request, 0 if submission fails
515 * @rep:displayname Submit Request
516 * @rep:scope public
517 * @rep:lifecycle active
518 * @rep:compatibility S
519 */
520 function submit_request (
521 application IN varchar2 default NULL,
522 program IN varchar2 default NULL,
523 description IN varchar2 default NULL,
524 start_time IN varchar2 default NULL,
525 sub_request IN boolean default FALSE,
526 argument1 IN varchar2 default CHR(0),
527 argument2 IN varchar2 default CHR(0),
528 argument3 IN varchar2 default CHR(0),
529 argument4 IN varchar2 default CHR(0),
530 argument5 IN varchar2 default CHR(0),
531 argument6 IN varchar2 default CHR(0),
532 argument7 IN varchar2 default CHR(0),
533 argument8 IN varchar2 default CHR(0),
534 argument9 IN varchar2 default CHR(0),
535 argument10 IN varchar2 default CHR(0),
536 argument11 IN varchar2 default CHR(0),
537 argument12 IN varchar2 default CHR(0),
538 argument13 IN varchar2 default CHR(0),
539 argument14 IN varchar2 default CHR(0),
540 argument15 IN varchar2 default CHR(0),
541 argument16 IN varchar2 default CHR(0),
542 argument17 IN varchar2 default CHR(0),
543 argument18 IN varchar2 default CHR(0),
547 argument22 IN varchar2 default CHR(0),
544 argument19 IN varchar2 default CHR(0),
545 argument20 IN varchar2 default CHR(0),
546 argument21 IN varchar2 default CHR(0),
548 argument23 IN varchar2 default CHR(0),
549 argument24 IN varchar2 default CHR(0),
550 argument25 IN varchar2 default CHR(0),
551 argument26 IN varchar2 default CHR(0),
552 argument27 IN varchar2 default CHR(0),
553 argument28 IN varchar2 default CHR(0),
554 argument29 IN varchar2 default CHR(0),
555 argument30 IN varchar2 default CHR(0),
556 argument31 IN varchar2 default CHR(0),
557 argument32 IN varchar2 default CHR(0),
558 argument33 IN varchar2 default CHR(0),
559 argument34 IN varchar2 default CHR(0),
560 argument35 IN varchar2 default CHR(0),
561 argument36 IN varchar2 default CHR(0),
562 argument37 IN varchar2 default CHR(0),
563 argument38 IN varchar2 default CHR(0),
564 argument39 IN varchar2 default CHR(0),
565 argument40 IN varchar2 default CHR(0),
566 argument41 IN varchar2 default CHR(0),
567 argument42 IN varchar2 default CHR(0),
568 argument43 IN varchar2 default CHR(0),
569 argument44 IN varchar2 default CHR(0),
570 argument45 IN varchar2 default CHR(0),
571 argument46 IN varchar2 default CHR(0),
572 argument47 IN varchar2 default CHR(0),
573 argument48 IN varchar2 default CHR(0),
574 argument49 IN varchar2 default CHR(0),
575 argument50 IN varchar2 default CHR(0),
576 argument51 IN varchar2 default CHR(0),
577 argument52 IN varchar2 default CHR(0),
578 argument53 IN varchar2 default CHR(0),
579 argument54 IN varchar2 default CHR(0),
580 argument55 IN varchar2 default CHR(0),
581 argument56 IN varchar2 default CHR(0),
582 argument57 IN varchar2 default CHR(0),
583 argument58 IN varchar2 default CHR(0),
584 argument59 IN varchar2 default CHR(0),
585 argument60 IN varchar2 default CHR(0),
586 argument61 IN varchar2 default CHR(0),
587 argument62 IN varchar2 default CHR(0),
588 argument63 IN varchar2 default CHR(0),
589 argument64 IN varchar2 default CHR(0),
590 argument65 IN varchar2 default CHR(0),
591 argument66 IN varchar2 default CHR(0),
592 argument67 IN varchar2 default CHR(0),
593 argument68 IN varchar2 default CHR(0),
594 argument69 IN varchar2 default CHR(0),
595 argument70 IN varchar2 default CHR(0),
596 argument71 IN varchar2 default CHR(0),
597 argument72 IN varchar2 default CHR(0),
598 argument73 IN varchar2 default CHR(0),
599 argument74 IN varchar2 default CHR(0),
600 argument75 IN varchar2 default CHR(0),
601 argument76 IN varchar2 default CHR(0),
602 argument77 IN varchar2 default CHR(0),
603 argument78 IN varchar2 default CHR(0),
604 argument79 IN varchar2 default CHR(0),
605 argument80 IN varchar2 default CHR(0),
606 argument81 IN varchar2 default CHR(0),
607 argument82 IN varchar2 default CHR(0),
608 argument83 IN varchar2 default CHR(0),
609 argument84 IN varchar2 default CHR(0),
610 argument85 IN varchar2 default CHR(0),
611 argument86 IN varchar2 default CHR(0),
612 argument87 IN varchar2 default CHR(0),
613 argument88 IN varchar2 default CHR(0),
614 argument89 IN varchar2 default CHR(0),
615 argument90 IN varchar2 default CHR(0),
616 argument91 IN varchar2 default CHR(0),
617 argument92 IN varchar2 default CHR(0),
618 argument93 IN varchar2 default CHR(0),
619 argument94 IN varchar2 default CHR(0),
620 argument95 IN varchar2 default CHR(0),
621 argument96 IN varchar2 default CHR(0),
622 argument97 IN varchar2 default CHR(0),
623 argument98 IN varchar2 default CHR(0),
624 argument99 IN varchar2 default CHR(0),
625 argument100 IN varchar2 default CHR(0))
626 return number;
627
628 -- This function is for AOL internal use only:
629 procedure internal(critical IN varchar2 default null,
630 type IN varchar2 default null);
631
632 --
633 -- Name
634 -- add_notification
635 -- Purpose
636 -- Called before submission to add a user to the notify list.
637 --
638 -- Arguments
639 -- User - User name.
640 -- on_normal - Notify when normal completion (Values Y/N)
641 -- on_warning - Notify when request completes with warning (Y/N)
642 -- on_error - Notify when request completed with error (Y/N)
643 function add_notification (user in varchar2,
644 on_normal in varchar2 ,
645 on_warning in varchar2 ,
646 on_error in varchar2 ) return boolean;
647 pragma restrict_references (add_notification, WNDS);
648
649 --
650 -- Name
651 -- submit_svc_ctl_request
652 -- Purpose
653 -- Submits Queue Control Request
654 -- WARNING PERFORMS A COMMIT!!!
655 --
656 -- Arguments
657 -- command - concurrent program name for which the request has
658 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
659 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
660 -- service - Service instance or manager developer name.
661 -- service_app - manager or service instance's application short name
662
663 function submit_svc_ctl_request (
664 command IN varchar2,
665 service IN varchar2,
666 service_app IN varchar2)
667 return number;
668
669 --
670 -- Name
671 -- submit_svc_ctl_by_app
672 -- Purpose
673 -- Submits Queue Control Request
674 -- WARNING PERFORMS A COMMIT!!!
678 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
675 --
676 -- Arguments
677 -- command - concurrent program name for which the request has
679 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
680 -- service_app - manager or service instance's application short name
681 -- svc_type - 0 = mgrs, 1= svcs, 2= both
682
683 function submit_svc_ctl_by_app (
684 command IN varchar2,
685 application IN varchar2,
686 svc_type in NUMBER default 2)
687 return number;
688
689 --
690 -- Name
691 -- submit_svc_ctl_by_svc
692 -- Purpose
693 -- Submits Queue Control Request
694 -- WARNING PERFORMS A COMMIT!!!
695 --
696 -- Arguments
697 -- command - concurrent program name for which the request has
698 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
699 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
700 -- service - Service instance or manager developer name.
701
702 function submit_svc_ctl_by_svc (
703 command IN varchar2,
704 service IN varchar2)
705 return number;
706
707 --
708 -- Name
709 -- submit_svc_ctl_cpinfra
710 -- Purpose
711 -- Submits Queue Control Request
712 -- WARNING PERFORMS A COMMIT!!!
713 --
714 -- Arguments
715 -- command - concurrent program name for which the request has
716 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
717 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
718 -- service - Service instance or manager developer name.
719 -- service_app - manager or service instance's application short name
720
721 function submit_svc_ctl_cpinfra (
722 command IN varchar2)
723 return number;
724
725 --
726 -- Name
727 -- submit_svc_ctl_cpall
728 -- Purpose
729 -- Submits Queue Control Request
730 -- WARNING PERFORMS A COMMIT!!!
731 --
732 -- Arguments
733 -- command - concurrent program name for which the request has
734 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
735 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
736
737 function submit_svc_ctl_cpall (
738 command IN varchar2)
739 return number;
740
741
742 -- Name
743 -- set_deferred
744 -- Purpose
745 -- Called before calling request submission page by other product teams
746 --
747 -- Arguments
748 -- none
749 --
750 function set_deferred
751 return boolean;
752
753
754
755 -- Name
756 -- set_def_request_id
757 -- Purpose
758 -- Called for setting global request id and the request id will be used while creating actual request
759 --
760 -- Arguments
761 -- request_id - used while creating actual request in fnd_concurrent_request
762 --
763 function set_def_request_id (
764 request_id IN number)
765 return boolean;
766
767
768 -- Name
769 -- get_fnd_debug_rules_sequence
770 -- Purpose
771 -- Called to obtain the next sequence value for fnd_debug_rules table
772 --
773 -- Arguments
774 -- none
775 --
776 function get_fnd_debug_rules_sequence
777 return number;
778
779
780 -- Name
781 -- update_fnd_debug_rules_req_id
782 -- Purpose
783 -- Called to set the request id for the specific fnd_debug_rule_id
784 --
785 -- Arguments
786 -- debug_rule_id - the specific row in fnd_debug_rules to get updated
787 -- request_id - the actual request id that debug options is being set for.
788 --
789 function update_fnd_debug_rules_req_id (
790 req_id IN number,
791 fnd_debug_rule_id IN number )
792 return boolean;
793
794
795 -- Name
796 -- delete_fnd_debug_rules_id
797 -- Purpose
798 -- Called to delete the specific fnd_debug_rule_id from fnd_debug_rules
799 -- and fnd_debug_rules_options
800 --
801 -- Arguments
802 -- debug_rule_id - the specific sequence number to be deleted
803 --
804 function delete_fnd_debug_rules_id (
805 fnd_debug_rule_id IN number )
806 return boolean;
807
808 -- NAME
809 -- get_num_char_for_terr
810 -- Purpose
811 -- Called to retrieve the num char associated with a territory
812 --
813 -- Arguments
814 -- original_terr
815 -- check_terr
816 --
817 function get_num_char_for_terr (
818 original_terr IN varchar2,
819 check_terr IN varchar2 )
820 return varchar2;
821
822 -- NAME
823 -- validate_num_char_for_terr
824 -- Purpose
825 -- Called to validate the num char associated with a territory
826 --
827 -- Arguments
828 -- num_char
829 --
830 function validate_num_char_for_terr (
831 num_char IN varchar2 )
832 return boolean;
833
834 FUNCTION INSERT_USER_SCHEDULE(P_RELEASE_CLASS_NAME IN VARCHAR2,
835 P_REQUESTED_START_DATE IN VARCHAR2,
836 P_REQUESTED_END_DATE IN VARCHAR2,
837 P_REPEAT_INTERVAL IN NUMBER,
838 P_REPEAT_INTERVAL_UNIT IN VARCHAR2,
839 P_REPEAT_INTERVAL_TYPE IN VARCHAR2,
840 P_CLASS_TYPE IN VARCHAR2,
841 P_CLASS_INFO IN VARCHAR2,
842 P_DESCRIPTION IN VARCHAR2,
846 FUNCTION UPDATE_USER_SCHEDULE(P_RELEASE_CLASS_NAME IN VARCHAR2,
843 P_ENABLED_FLAG IN VARCHAR2
844 ) return boolean;
845
847 P_REQUESTED_START_DATE IN VARCHAR2,
848 P_REQUESTED_END_DATE IN VARCHAR2,
849 P_REPEAT_INTERVAL IN NUMBER,
850 P_REPEAT_INTERVAL_UNIT IN VARCHAR2,
851 P_REPEAT_INTERVAL_TYPE IN VARCHAR2,
852 P_CLASS_TYPE IN VARCHAR2,
853 P_CLASS_INFO IN VARCHAR2,
854 P_DESCRIPTION IN VARCHAR2,
855 P_ENABLED_FLAG IN VARCHAR2
856 ) return boolean;
857
858 function delete_user_schedule(schName varchar2)
859 RETURN BOOLEAN;
860
861 end FND_REQUEST;