1 package FND_REQUEST as
2 /* $Header: AFCPREQS.pls 120.7.12010000.3 2008/12/23 17:43:53 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_rel_class_options
146 -- Purpose
147 -- Called before submitting request if the request to be submitted
148 -- is using the new scheduler functionality.
149 --
150 -- Arguments
151 -- application - Application Name of Release Class
152 -- class_name - (Developer) Name of Release Class
153 -- cancel_or_hold - Cancel or hold flag
154 -- stale_date - Cancel request on or after this time if not run
155 --
156 function set_rel_class_options (application IN varchar2 default NULL,
157 class_name IN varchar2 default NULL,
158 cancel_or_hold IN varchar2 default 'H',
159 stale_date IN varchar2 default NULL)
160 return boolean;
161 pragma restrict_references (set_rel_class_options, WNDS);
162
163 -- Name
164 -- set_target_options
165 -- Purpose
166 -- Called before submitting request to set target node and or connect
167 -- string (instance) for the request. Currently only primary target
168 -- node and connect string are honored and the connect string must be
169 -- the name of a RAC instance.
170 --
171 -- Arguments
172 -- node_name1 - primary target node
173 -- instance1 - primary target instance (connect string)
174 -- node_name2 - secondary target node
175 -- instance2 - secondary target instance (connect string)
176 --
177 -- --
178 function set_target_options (node_name1 IN varchar2 default NULL,
179 instance1 IN varchar2 default NULL,
180 node_name2 IN varchar2 default NULL,
181 instance2 IN varchar2 default NULL)
182 return boolean;
183
184 --
185 -- Name
186 -- set_print_options
187 -- Purpose
188 -- Called before submitting request if the printing of output has
189 -- to be controlled with specific printer/style/copies etc.,
190 --
191 -- Arguments
192 -- printer - Printer name where the request o/p should be sent
193 -- style - Print style that needs to be used for printing
194 -- copies - Number of copies to print
195 -- save_output - Should the output file be saved after printing
196 -- - Default is TRUE. TRUE/FALSE
197 -- print_together - Applies only for sub requests. If 'Y', output
198 -- - will not be printed until all the sub requests
199 -- - complete. Default is 'N'. ( Y/N )
200 -- validate_printer - Once submit function is called
201 -- - with a specific program, if the printer specified
202 -- - here conflicts with a printer setting at the
203 -- - program level, one of three options is available:
204 -- - FAIL - raise an error and fail to submit
205 -- - SKIP - skip this print pp action, but submit anyway
206 -- - RESOLVE - switch to the valid printer, if printer
207 -- - and style are compatible
208 -- - Default is RESOLVE
209 --
210 /*#
211 * Sets the print options for the concurrent request
212 * @param printer The name of the printer to which the concurrent request output should to be sent
213 * @param style Style used to print request output
214 * @param copies Number of copies of the request output to print
215 * @param save_output Indicates whether to save the output file
216 * @param print_together This parameter applies only to those requests containing sub-requests.
217 * 'Y' indicates that output of the sub-request should not be printed until all sub-requests complete.
218 * 'N' indicates that output of the sub-request should be printed as it completes.
219 * @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
220 * FAIL - raise an error and fail to submit
221 * SKIP - skip this print pp action, but submit anyway
222 * RESOLVE - switch to the valid printer, if printer and style are compatible
223 * @return TRUE on successful completion, otherwise FALSE
224 * @rep:displayname Set Print Options
225 * @rep:scope public
226 * @rep:lifecycle active
227 * @rep:compatibility S
228 */
229 function set_print_options (printer IN varchar2 default NULL,
230 style IN varchar2 default NULL,
231 copies IN number default NULL,
232 save_output IN boolean default TRUE,
233 print_together IN varchar2 default 'N',
234 validate_printer IN varchar2 default 'RESOLVE')
235 return boolean;
236 pragma restrict_references (set_print_options, WNDS);
237
238
239 --
240 -- Name
241 -- use_current_notification
242 -- Purpose
243 -- Called before submitting a sub-request to reuse the same notification
244 -- options as the current request
245 --
246 -- Arguments
247 -- none
248 function use_current_notification return boolean;
249 pragma restrict_references (use_current_notification, WNDS);
250
251
252 --
253 -- Name
254 -- add_printer
255 -- Purpose
256 -- Called after set print options to add a printer to the
257 -- print list.
258 --
259 -- Arguments
260 -- printer - Printer name where the request o/p should be sent
261 -- copies - Number of copies to print
262 function add_printer (printer in varchar2 default null,
263 copies in number default null) return boolean;
264 pragma restrict_references (add_printer, WNDS);
265
266 --
267 -- Name
268 -- add_notification
269 -- Purpose
270 -- Called before submission to add a user to the notify list.
271 --
272 -- Arguments
273 -- User - User name.
274 function add_notification (user in varchar2) return boolean;
275 pragma restrict_references (add_notification, WNDS);
276
277 --
278 -- Name
279 -- add_layout
280 -- Purpose
281 -- Called before submission to add layout options for request output.
282 --
283 -- Arguments
284 -- Template_APPL_Name - Template Application Short name.
285 -- Template_code - Template code
286 -- Template_Language - Template File language (iso value)
287 -- Template_Territory - Template File Territory (iso value)
288 -- Output Format - Output Format
289 --
290 function add_layout (template_appl_name in varchar2,
291 template_code in varchar2,
292 template_language in varchar2,
293 template_territory in varchar2,
294 output_format in varchar2) return boolean;
295
296 --
297 -- Name
298 -- submit_request
299 -- Purpose
300 -- Submits concurrent request to be processed by a concurrent manager
301 --
302 -- Arguments
303 -- application - Short name of application under which the program
304 -- - is registered
305 -- program - concurrent program name for which the request has
306 -- - to be submitted
307 -- description - Optional. Will be displayed along with user
308 -- - concurrent program name
309 -- start_time - Optional. Time at which the request has to start
310 -- - running
311 -- sub_request - Optional. Set to TRUE if the request is submitted
312 -- - from another running request and has to be treated
313 -- - as a sub request. Default is FALSE
314 -- argument1..100 - Optional. Arguments for the concurrent request
315 --
316 /*#
317 * Submits a request for processing by a concurrent manager
318 * @param application Short name of the application associated with the concurrent request to be submitted
319 * @param program Short name of the concurrent program for which the request should be submitted
320 * @param description Description of the request that is displayed in the concurrent request's form
321 * @param start_time Time at which the request should start running
322 * @param sub_request Set to TRUE if the request is submitted from another request and should be treated as a sub-request
323 * @param argument1 Argument for concurrent request
324 * @param argument2 Argument for concurrent request
325 * @param argument3 Argument for concurrent request
326 * @param argument4 Argument for concurrent request
327 * @param argument5 Argument for concurrent request
328 * @param argument6 Argument for concurrent request
329 * @param argument7 Argument for concurrent request
330 * @param argument8 Argument for concurrent request
331 * @param argument9 Argument for concurrent request
332 * @param argument10 Argument for concurrent request
333 * @param argument11 Argument for concurrent request
334 * @param argument12 Argument for concurrent request
338 * @param argument16 Argument for concurrent request
335 * @param argument13 Argument for concurrent request
336 * @param argument14 Argument for concurrent request
337 * @param argument15 Argument for concurrent request
339 * @param argument17 Argument for concurrent request
340 * @param argument18 Argument for concurrent request
341 * @param argument19 Argument for concurrent request
342 * @param argument20 Argument for concurrent request
343 * @param argument21 Argument for concurrent request
344 * @param argument22 Argument for concurrent request
345 * @param argument23 Argument for concurrent request
346 * @param argument24 Argument for concurrent request
347 * @param argument25 Argument for concurrent request
348 * @param argument26 Argument for concurrent request
349 * @param argument27 Argument for concurrent request
350 * @param argument28 Argument for concurrent request
351 * @param argument29 Argument for concurrent request
352 * @param argument30 Argument for concurrent request
353 * @param argument31 Argument for concurrent request
354 * @param argument32 Argument for concurrent request
355 * @param argument33 Argument for concurrent request
356 * @param argument34 Argument for concurrent request
357 * @param argument35 Argument for concurrent request
358 * @param argument36 Argument for concurrent request
359 * @param argument37 Argument for concurrent request
360 * @param argument38 Argument for concurrent request
361 * @param argument39 Argument for concurrent request
362 * @param argument40 Argument for concurrent request
363 * @param argument41 Argument for concurrent request
364 * @param argument42 Argument for concurrent request
365 * @param argument43 Argument for concurrent request
366 * @param argument44 Argument for concurrent request
367 * @param argument45 Argument for concurrent request
368 * @param argument46 Argument for concurrent request
369 * @param argument47 Argument for concurrent request
370 * @param argument48 Argument for concurrent request
371 * @param argument49 Argument for concurrent request
372 * @param argument50 Argument for concurrent request
373 * @param argument51 Argument for concurrent request
374 * @param argument52 Argument for concurrent request
375 * @param argument53 Argument for concurrent request
376 * @param argument54 Argument for concurrent request
377 * @param argument55 Argument for concurrent request
378 * @param argument56 Argument for concurrent request
379 * @param argument57 Argument for concurrent request
380 * @param argument58 Argument for concurrent request
381 * @param argument59 Argument for concurrent request
382 * @param argument60 Argument for concurrent request
383 * @param argument61 Argument for concurrent request
384 * @param argument62 Argument for concurrent request
385 * @param argument63 Argument for concurrent request
386 * @param argument64 Argument for concurrent request
387 * @param argument65 Argument for concurrent request
388 * @param argument66 Argument for concurrent request
389 * @param argument67 Argument for concurrent request
390 * @param argument68 Argument for concurrent request
391 * @param argument69 Argument for concurrent request
392 * @param argument70 Argument for concurrent request
393 * @param argument71 Argument for concurrent request
394 * @param argument72 Argument for concurrent request
395 * @param argument73 Argument for concurrent request
396 * @param argument74 Argument for concurrent request
397 * @param argument75 Argument for concurrent request
398 * @param argument76 Argument for concurrent request
399 * @param argument77 Argument for concurrent request
400 * @param argument78 Argument for concurrent request
401 * @param argument79 Argument for concurrent request
402 * @param argument80 Argument for concurrent request
403 * @param argument81 Argument for concurrent request
404 * @param argument82 Argument for concurrent request
405 * @param argument83 Argument for concurrent request
406 * @param argument84 Argument for concurrent request
407 * @param argument85 Argument for concurrent request
408 * @param argument86 Argument for concurrent request
409 * @param argument87 Argument for concurrent request
410 * @param argument88 Argument for concurrent request
411 * @param argument89 Argument for concurrent request
412 * @param argument90 Argument for concurrent request
413 * @param argument91 Argument for concurrent request
414 * @param argument92 Argument for concurrent request
415 * @param argument93 Argument for concurrent request
416 * @param argument94 Argument for concurrent request
417 * @param argument95 Argument for concurrent request
418 * @param argument96 Argument for concurrent request
419 * @param argument97 Argument for concurrent request
420 * @param argument98 Argument for concurrent request
421 * @param argument99 Argument for concurrent request
422 * @param argument100 Argument for concurrent request
423 * @return Returns requestid of submitted request, 0 if submission fails
424 * @rep:displayname Submit Request
425 * @rep:scope public
426 * @rep:lifecycle active
427 * @rep:compatibility S
428 */
429 function submit_request (
430 application IN varchar2 default NULL,
431 program IN varchar2 default NULL,
432 description IN varchar2 default NULL,
433 start_time IN varchar2 default NULL,
434 sub_request IN boolean default FALSE,
435 argument1 IN varchar2 default CHR(0),
436 argument2 IN varchar2 default CHR(0),
437 argument3 IN varchar2 default CHR(0),
441 argument7 IN varchar2 default CHR(0),
438 argument4 IN varchar2 default CHR(0),
439 argument5 IN varchar2 default CHR(0),
440 argument6 IN varchar2 default CHR(0),
442 argument8 IN varchar2 default CHR(0),
443 argument9 IN varchar2 default CHR(0),
444 argument10 IN varchar2 default CHR(0),
445 argument11 IN varchar2 default CHR(0),
446 argument12 IN varchar2 default CHR(0),
447 argument13 IN varchar2 default CHR(0),
448 argument14 IN varchar2 default CHR(0),
449 argument15 IN varchar2 default CHR(0),
450 argument16 IN varchar2 default CHR(0),
451 argument17 IN varchar2 default CHR(0),
452 argument18 IN varchar2 default CHR(0),
453 argument19 IN varchar2 default CHR(0),
454 argument20 IN varchar2 default CHR(0),
455 argument21 IN varchar2 default CHR(0),
456 argument22 IN varchar2 default CHR(0),
457 argument23 IN varchar2 default CHR(0),
458 argument24 IN varchar2 default CHR(0),
459 argument25 IN varchar2 default CHR(0),
460 argument26 IN varchar2 default CHR(0),
461 argument27 IN varchar2 default CHR(0),
462 argument28 IN varchar2 default CHR(0),
463 argument29 IN varchar2 default CHR(0),
464 argument30 IN varchar2 default CHR(0),
465 argument31 IN varchar2 default CHR(0),
466 argument32 IN varchar2 default CHR(0),
467 argument33 IN varchar2 default CHR(0),
468 argument34 IN varchar2 default CHR(0),
469 argument35 IN varchar2 default CHR(0),
470 argument36 IN varchar2 default CHR(0),
471 argument37 IN varchar2 default CHR(0),
472 argument38 IN varchar2 default CHR(0),
473 argument39 IN varchar2 default CHR(0),
474 argument40 IN varchar2 default CHR(0),
475 argument41 IN varchar2 default CHR(0),
476 argument42 IN varchar2 default CHR(0),
477 argument43 IN varchar2 default CHR(0),
478 argument44 IN varchar2 default CHR(0),
479 argument45 IN varchar2 default CHR(0),
480 argument46 IN varchar2 default CHR(0),
481 argument47 IN varchar2 default CHR(0),
482 argument48 IN varchar2 default CHR(0),
483 argument49 IN varchar2 default CHR(0),
484 argument50 IN varchar2 default CHR(0),
485 argument51 IN varchar2 default CHR(0),
486 argument52 IN varchar2 default CHR(0),
487 argument53 IN varchar2 default CHR(0),
488 argument54 IN varchar2 default CHR(0),
489 argument55 IN varchar2 default CHR(0),
490 argument56 IN varchar2 default CHR(0),
491 argument57 IN varchar2 default CHR(0),
492 argument58 IN varchar2 default CHR(0),
493 argument59 IN varchar2 default CHR(0),
494 argument60 IN varchar2 default CHR(0),
495 argument61 IN varchar2 default CHR(0),
496 argument62 IN varchar2 default CHR(0),
497 argument63 IN varchar2 default CHR(0),
498 argument64 IN varchar2 default CHR(0),
499 argument65 IN varchar2 default CHR(0),
500 argument66 IN varchar2 default CHR(0),
501 argument67 IN varchar2 default CHR(0),
502 argument68 IN varchar2 default CHR(0),
503 argument69 IN varchar2 default CHR(0),
504 argument70 IN varchar2 default CHR(0),
505 argument71 IN varchar2 default CHR(0),
506 argument72 IN varchar2 default CHR(0),
507 argument73 IN varchar2 default CHR(0),
508 argument74 IN varchar2 default CHR(0),
509 argument75 IN varchar2 default CHR(0),
510 argument76 IN varchar2 default CHR(0),
511 argument77 IN varchar2 default CHR(0),
512 argument78 IN varchar2 default CHR(0),
513 argument79 IN varchar2 default CHR(0),
514 argument80 IN varchar2 default CHR(0),
515 argument81 IN varchar2 default CHR(0),
516 argument82 IN varchar2 default CHR(0),
517 argument83 IN varchar2 default CHR(0),
518 argument84 IN varchar2 default CHR(0),
519 argument85 IN varchar2 default CHR(0),
520 argument86 IN varchar2 default CHR(0),
521 argument87 IN varchar2 default CHR(0),
522 argument88 IN varchar2 default CHR(0),
523 argument89 IN varchar2 default CHR(0),
524 argument90 IN varchar2 default CHR(0),
525 argument91 IN varchar2 default CHR(0),
526 argument92 IN varchar2 default CHR(0),
527 argument93 IN varchar2 default CHR(0),
528 argument94 IN varchar2 default CHR(0),
529 argument95 IN varchar2 default CHR(0),
530 argument96 IN varchar2 default CHR(0),
531 argument97 IN varchar2 default CHR(0),
532 argument98 IN varchar2 default CHR(0),
533 argument99 IN varchar2 default CHR(0),
534 argument100 IN varchar2 default CHR(0))
535 return number;
536
537 -- This function is for AOL internal use only:
538 procedure internal(critical IN varchar2 default null,
539 type IN varchar2 default null);
540
541 --
542 -- Name
543 -- add_notification
544 -- Purpose
545 -- Called before submission to add a user to the notify list.
546 --
547 -- Arguments
548 -- User - User name.
549 -- on_normal - Notify when normal completion (Values Y/N)
550 -- on_warning - Notify when request completes with warning (Y/N)
551 -- on_error - Notify when request completed with error (Y/N)
552 function add_notification (user in varchar2,
553 on_normal in varchar2 ,
557
554 on_warning in varchar2 ,
555 on_error in varchar2 ) return boolean;
556 pragma restrict_references (add_notification, WNDS);
558 --
559 -- Name
560 -- submit_svc_ctl_request
561 -- Purpose
562 -- Submits Queue Control Request
563 -- WARNING PERFORMS A COMMIT!!!
564 --
565 -- Arguments
566 -- command - concurrent program name for which the request has
567 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
568 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
569 -- service - Service instance or manager developer name.
570 -- service_app - manager or service instance's application short name
571
572 function submit_svc_ctl_request (
573 command IN varchar2,
574 service IN varchar2,
575 service_app IN varchar2)
576 return number;
577
578 --
579 -- Name
580 -- submit_svc_ctl_by_app
581 -- Purpose
582 -- Submits Queue Control Request
583 -- WARNING PERFORMS A COMMIT!!!
584 --
585 -- Arguments
586 -- command - concurrent program name for which the request has
587 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
588 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
589 -- service_app - manager or service instance's application short name
590 -- svc_type - 0 = mgrs, 1= svcs, 2= both
591
592 function submit_svc_ctl_by_app (
593 command IN varchar2,
594 application IN varchar2,
595 svc_type in NUMBER default 2)
596 return number;
597
598 --
599 -- Name
600 -- submit_svc_ctl_by_svc
601 -- Purpose
602 -- Submits Queue Control Request
603 -- WARNING PERFORMS A COMMIT!!!
604 --
605 -- Arguments
606 -- command - concurrent program name for which the request has
607 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
608 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
609 -- service - Service instance or manager developer name.
610
611 function submit_svc_ctl_by_svc (
612 command IN varchar2,
613 service IN varchar2)
614 return number;
615
616 --
617 -- Name
618 -- submit_svc_ctl_cpinfra
619 -- Purpose
620 -- Submits Queue Control Request
621 -- WARNING PERFORMS A COMMIT!!!
622 --
623 -- Arguments
624 -- command - concurrent program name for which the request has
625 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
626 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
627 -- service - Service instance or manager developer name.
628 -- service_app - manager or service instance's application short name
629
630 function submit_svc_ctl_cpinfra (
631 command IN varchar2)
632 return number;
633
634 --
635 -- Name
636 -- submit_svc_ctl_cpall
637 -- Purpose
638 -- Submits Queue Control Request
639 -- WARNING PERFORMS A COMMIT!!!
640 --
641 -- Arguments
642 -- command - concurrent program name for which the request has
643 -- - to be submitted: ACTIVATE, DEACTIVATE, RESTART,
644 -- - ABORT (ie. terminate), VERIFY, SUSPEND, or RESUME
645
646 function submit_svc_ctl_cpall (
647 command IN varchar2)
648 return number;
649
650
651 -- Name
652 -- set_deferred
653 -- Purpose
654 -- Called before calling request submission page by other product teams
655 --
656 -- Arguments
657 -- none
658 --
659 function set_deferred
660 return boolean;
661
662
663
664 -- Name
665 -- set_def_request_id
666 -- Purpose
667 -- Called for setting global request id and the request id will be used while creating actual request
668 --
669 -- Arguments
670 -- request_id - used while creating actual request in fnd_concurrent_request
671 --
672 function set_def_request_id (
673 request_id IN number)
674 return boolean;
675
676
677 -- Name
678 -- get_fnd_debug_rules_sequence
679 -- Purpose
680 -- Called to obtain the next sequence value for fnd_debug_rules table
681 --
682 -- Arguments
683 -- none
684 --
685 function get_fnd_debug_rules_sequence
686 return number;
687
688
689 -- Name
690 -- update_fnd_debug_rules_req_id
691 -- Purpose
692 -- Called to set the request id for the specific fnd_debug_rule_id
693 --
694 -- Arguments
695 -- debug_rule_id - the specific row in fnd_debug_rules to get updated
696 -- request_id - the actual request id that debug options is being set for.
697 --
698 function update_fnd_debug_rules_req_id (
699 req_id IN number,
700 fnd_debug_rule_id IN number )
701 return boolean;
702
703
704 -- Name
705 -- delete_fnd_debug_rules_id
706 -- Purpose
707 -- Called to delete the specific fnd_debug_rule_id from fnd_debug_rules
708 -- and fnd_debug_rules_options
709 --
710 -- Arguments
711 -- debug_rule_id - the specific sequence number to be deleted
712 --
713 function delete_fnd_debug_rules_id (
714 fnd_debug_rule_id IN number )
715 return boolean;
716
717 -- NAME
718 -- get_num_char_for_terr
719 -- Purpose
720 -- Called to retrieve the num char associated with a territory
721 --
722 -- Arguments
723 -- original_terr
724 -- check_terr
725 --
726 function get_num_char_for_terr (
727 original_terr IN varchar2,
728 check_terr IN varchar2 )
729 return varchar2;
730
731 -- NAME
732 -- validate_num_char_for_terr
733 -- Purpose
734 -- Called to validate the num char associated with a territory
735 --
736 -- Arguments
737 -- num_char
738 --
739 function validate_num_char_for_terr (
740 num_char IN varchar2 )
741 return boolean;
742
743 FUNCTION INSERT_USER_SCHEDULE(P_RELEASE_CLASS_NAME IN VARCHAR2,
744 P_REQUESTED_START_DATE IN VARCHAR2,
745 P_REQUESTED_END_DATE IN VARCHAR2,
746 P_REPEAT_INTERVAL IN NUMBER,
747 P_REPEAT_INTERVAL_UNIT IN VARCHAR2,
748 P_REPEAT_INTERVAL_TYPE IN VARCHAR2,
749 P_CLASS_TYPE IN VARCHAR2,
750 P_CLASS_INFO IN VARCHAR2,
751 P_DESCRIPTION IN VARCHAR2
752 ) return boolean;
753 end FND_REQUEST;