1 package FND_CONC_REQ_DETAIL AUTHID CURRENT_USER as
2 /* $Header: AFCPREQDS.pls 120.0.12010000.1 2009/04/10 17:48:18 tkamiya noship $ */
3
4 -- ================================================
5 -- PUBLIC FUNCTIONS/PROCEDURES
6 -- ================================================
7
8 --
9 -- FUNCTION
10 -- get_ALL_REQUEST_INFO
11 --
12 -- Purpose
13 -- get all information of a request based on request_id
14 -- if request_id is not given, obtain from fnd_global
15 --
16 -- Note
17 -- returns NULL on failure
18 --
19 function get_ALL_REQUEST_INFO(request_id in number) return fnd_concurrent_requests%ROWTYPE;
20
21
22 --
23 -- FUNCTION
24 -- get_REQUEST_ID
25 --
26 -- Purpose
27 -- get REQUEST_ID of a request based on request_id
28 -- if request_id is not given, obtain from fnd_global
29 --
30 -- Note
31 -- returns NULL on failure
32 --
33 function get_REQUEST_ID(request_id in number) return fnd_concurrent_requests.REQUEST_ID%TYPE;
34
35
36 --
37 -- FUNCTION
38 -- get_LAST_UPDATE_DATE
39 --
40 -- Purpose
41 -- get LAST_UPDATE_DATE of a request based on request_id
42 -- if request_id is not given, obtain from fnd_global
43 --
44 -- Note
45 -- returns NULL on failure
46 --
47 function get_LAST_UPDATE_DATE(request_id in number) return fnd_concurrent_requests.LAST_UPDATE_DATE%TYPE;
48
49
50 --
51 -- FUNCTION
52 -- get_LAST_UPDATED_BY
53 --
54 -- Purpose
55 -- get LAST_UPDATED_BY of a request based on request_id
56 -- if request_id is not given, obtain from fnd_global
57 --
58 -- Note
59 -- returns NULL on failure
60 --
61 function get_LAST_UPDATED_BY(request_id in number) return fnd_concurrent_requests.LAST_UPDATED_BY%TYPE;
62
63
64 --
65 -- FUNCTION
66 -- get_REQUEST_DATE
67 --
68 -- Purpose
69 -- get REQUEST_DATE of a request based on request_id
70 -- if request_id is not given, obtain from fnd_global
71 --
72 -- Note
73 -- returns NULL on failure
74 --
75 function get_REQUEST_DATE(request_id in number) return fnd_concurrent_requests.REQUEST_DATE%TYPE;
76
77
78 --
79 -- FUNCTION
80 -- get_REQUESTED_BY
81 --
82 -- Purpose
83 -- get REQUESTED_BY of a request based on request_id
84 -- if request_id is not given, obtain from fnd_global
85 --
86 -- Note
87 -- returns NULL on failure
88 --
89 function get_REQUESTED_BY(request_id in number) return fnd_concurrent_requests.REQUESTED_BY%TYPE;
90
91
92 --
93 -- FUNCTION
94 -- get_PHASE_CODE
95 --
96 -- Purpose
97 -- get PHASE_CODE of a request based on request_id
98 -- if request_id is not given, obtain from fnd_global
99 --
100 -- Note
101 -- returns NULL on failure
102 --
103 function get_PHASE_CODE(request_id in number) return fnd_concurrent_requests.PHASE_CODE%TYPE;
104
105
106 --
107 -- FUNCTION
108 -- get_STATUS_CODE
109 --
110 -- Purpose
111 -- get STATUS_CODE of a request based on request_id
112 -- if request_id is not given, obtain from fnd_global
113 --
114 -- Note
115 -- returns NULL on failure
116 --
117 function get_STATUS_CODE(request_id in number) return fnd_concurrent_requests.STATUS_CODE%TYPE;
118
119
120 --
121 -- FUNCTION
122 -- get_PRIORITY_REQUEST_ID
123 --
124 -- Purpose
125 -- get PRIORITY_REQUEST_ID of a request based on request_id
126 -- if request_id is not given, obtain from fnd_global
127 --
128 -- Note
129 -- returns NULL on failure
130 --
131 function get_PRIORITY_REQUEST_ID(request_id in number) return fnd_concurrent_requests.PRIORITY_REQUEST_ID%TYPE;
132
133
134 --
135 -- FUNCTION
136 -- get_PRIORITY
137 --
138 -- Purpose
139 -- get PRIORITY of a request based on request_id
140 -- if request_id is not given, obtain from fnd_global
141 --
142 -- Note
143 -- returns NULL on failure
144 --
145 function get_PRIORITY(request_id in number) return fnd_concurrent_requests.PRIORITY%TYPE;
146
147
148 --
149 -- FUNCTION
150 -- get_REQUESTED_START_DATE
151 --
152 -- Purpose
153 -- get REQUESTED_START_DATE of a request based on request_id
154 -- if request_id is not given, obtain from fnd_global
155 --
156 -- Note
157 -- returns NULL on failure
158 --
159 function get_REQUESTED_START_DATE(request_id in number) return fnd_concurrent_requests.REQUESTED_START_DATE%TYPE;
160
161
162 --
163 -- FUNCTION
164 -- get_HOLD_FLAG
165 --
166 -- Purpose
167 -- get HOLD_FLAG of a request based on request_id
168 -- if request_id is not given, obtain from fnd_global
169 --
170 -- Note
171 -- returns NULL on failure
172 --
173 function get_HOLD_FLAG(request_id in number) return fnd_concurrent_requests.HOLD_FLAG%TYPE;
174
175
176 --
177 -- FUNCTION
178 -- get_ENFORCE_SERIALITY_FLAG
179 --
180 -- Purpose
181 -- get ENFORCE_SERIALITY_FLAG of a request based on request_id
182 -- if request_id is not given, obtain from fnd_global
183 --
184 -- Note
185 -- returns NULL on failure
186 --
187 function get_ENFORCE_SERIALITY_FLAG(request_id in number) return fnd_concurrent_requests.ENFORCE_SERIALITY_FLAG%TYPE;
188
189
190 --
191 -- FUNCTION
192 -- get_SINGLE_THREAD_FLAG
193 --
194 -- Purpose
195 -- get SINGLE_THREAD_FLAG of a request based on request_id
196 -- if request_id is not given, obtain from fnd_global
197 --
198 -- Note
199 -- returns NULL on failure
200 --
201 function get_SINGLE_THREAD_FLAG(request_id in number) return fnd_concurrent_requests.SINGLE_THREAD_FLAG%TYPE;
202
203
204 --
205 -- FUNCTION
206 -- get_HAS_SUB_REQUEST
207 --
208 -- Purpose
209 -- get HAS_SUB_REQUEST of a request based on request_id
210 -- if request_id is not given, obtain from fnd_global
211 --
212 -- Note
213 -- returns NULL on failure
214 --
215 function get_HAS_SUB_REQUEST(request_id in number) return fnd_concurrent_requests.HAS_SUB_REQUEST%TYPE;
216
217
218 --
219 -- FUNCTION
220 -- get_IS_SUB_REQUEST
221 --
222 -- Purpose
223 -- get IS_SUB_REQUEST of a request based on request_id
224 -- if request_id is not given, obtain from fnd_global
225 --
226 -- Note
227 -- returns NULL on failure
228 --
229 function get_IS_SUB_REQUEST(request_id in number) return fnd_concurrent_requests.IS_SUB_REQUEST%TYPE;
230
231
232 --
233 -- FUNCTION
234 -- get_IMPLICIT_CODE
235 --
236 -- Purpose
237 -- get IMPLICIT_CODE of a request based on request_id
238 -- if request_id is not given, obtain from fnd_global
239 --
240 -- Note
241 -- returns NULL on failure
242 --
243 function get_IMPLICIT_CODE(request_id in number) return fnd_concurrent_requests.IMPLICIT_CODE%TYPE;
244
245
246 --
247 -- FUNCTION
248 -- get_UPDATE_PROTECTED
249 --
250 -- Purpose
251 -- get UPDATE_PROTECTED of a request based on request_id
252 -- if request_id is not given, obtain from fnd_global
253 --
254 -- Note
255 -- returns NULL on failure
256 --
257 function get_UPDATE_PROTECTED(request_id in number) return fnd_concurrent_requests.UPDATE_PROTECTED%TYPE;
258
259
260 --
261 -- FUNCTION
262 -- get_QUEUE_METHOD_CODE
263 --
264 -- Purpose
265 -- get QUEUE_METHOD_CODE of a request based on request_id
266 -- if request_id is not given, obtain from fnd_global
267 --
268 -- Note
269 -- returns NULL on failure
270 --
271 function get_QUEUE_METHOD_CODE(request_id in number) return fnd_concurrent_requests.QUEUE_METHOD_CODE%TYPE;
272
273
274 --
275 -- FUNCTION
276 -- get_ARGUMENT_INPUT_METHOD_CODE
277 --
278 -- Purpose
279 -- get ARGUMENT_INPUT_METHOD_CODE of a request based on request_id
280 -- if request_id is not given, obtain from fnd_global
281 --
282 -- Note
283 -- returns NULL on failure
284 --
285 function get_ARGUMENT_INPUT_METHOD_CODE(request_id in number) return fnd_concurrent_requests.ARGUMENT_INPUT_METHOD_CODE%TYPE;
286
287
288 --
289 -- FUNCTION
290 -- get_ORACLE_ID
291 --
292 -- Purpose
293 -- get ORACLE_ID of a request based on request_id
294 -- if request_id is not given, obtain from fnd_global
295 --
296 -- Note
297 -- returns NULL on failure
298 --
299 function get_ORACLE_ID(request_id in number) return fnd_concurrent_requests.ORACLE_ID%TYPE;
300
301
302 --
303 -- FUNCTION
304 -- get_PROGRAM_APPLICATION_ID
305 --
306 -- Purpose
307 -- get PROGRAM_APPLICATION_ID of a request based on request_id
308 -- if request_id is not given, obtain from fnd_global
309 --
310 -- Note
311 -- returns NULL on failure
312 --
313 function get_PROGRAM_APPLICATION_ID(request_id in number) return fnd_concurrent_requests.PROGRAM_APPLICATION_ID%TYPE;
314
315
316 --
317 -- FUNCTION
318 -- get_CONCURRENT_PROGRAM_ID
319 --
320 -- Purpose
321 -- get CONCURRENT_PROGRAM_ID of a request based on request_id
322 -- if request_id is not given, obtain from fnd_global
323 --
324 -- Note
325 -- returns NULL on failure
326 --
327 function get_CONCURRENT_PROGRAM_ID(request_id in number) return fnd_concurrent_requests.CONCURRENT_PROGRAM_ID%TYPE;
328
329
330 --
331 -- FUNCTION
332 -- get_RESPONSIB_APPLICATION_ID
333 --
334 -- Purpose
335 -- get RESPONSIBILITY_APPLICATION_ID of a request based on request_id
336 -- if request_id is not given, obtain from fnd_global
337 --
338 -- Note
339 -- returns NULL on failure
340 --
341 function get_RESPONSIB_APPLICATION_ID(request_id in number) return fnd_concurrent_requests.RESPONSIBILITY_APPLICATION_ID%TYPE;
342
343
344 --
345 -- FUNCTION
346 -- get_RESPONSIBILITY_ID
347 --
348 -- Purpose
349 -- get RESPONSIBILITY_ID of a request based on request_id
350 -- if request_id is not given, obtain from fnd_global
351 --
352 -- Note
353 -- returns NULL on failure
354 --
355 function get_RESPONSIBILITY_ID(request_id in number) return fnd_concurrent_requests.RESPONSIBILITY_ID%TYPE;
356
357
358 --
359 -- FUNCTION
360 -- get_NUMBER_OF_ARGUMENTS
361 --
362 -- Purpose
363 -- get NUMBER_OF_ARGUMENTS of a request based on request_id
364 -- if request_id is not given, obtain from fnd_global
365 --
366 -- Note
367 -- returns NULL on failure
368 --
369 function get_NUMBER_OF_ARGUMENTS(request_id in number) return fnd_concurrent_requests.NUMBER_OF_ARGUMENTS%TYPE;
370
371
372 --
373 -- FUNCTION
374 -- get_NUMBER_OF_COPIES
375 --
376 -- Purpose
377 -- get NUMBER_OF_COPIES of a request based on request_id
378 -- if request_id is not given, obtain from fnd_global
379 --
380 -- Note
381 -- returns NULL on failure
382 --
383 function get_NUMBER_OF_COPIES(request_id in number) return fnd_concurrent_requests.NUMBER_OF_COPIES%TYPE;
384
385
386 --
387 -- FUNCTION
388 -- get_SAVE_OUTPUT_FLAG
389 --
390 -- Purpose
391 -- get SAVE_OUTPUT_FLAG of a request based on request_id
392 -- if request_id is not given, obtain from fnd_global
393 --
394 -- Note
395 -- returns NULL on failure
396 --
397 function get_SAVE_OUTPUT_FLAG(request_id in number) return fnd_concurrent_requests.SAVE_OUTPUT_FLAG%TYPE;
398
399
400 --
401 -- FUNCTION
402 -- get_NLS_COMPLIANT
403 --
404 -- Purpose
405 -- get NLS_COMPLIANT of a request based on request_id
406 -- if request_id is not given, obtain from fnd_global
407 --
408 -- Note
412
409 -- returns NULL on failure
410 --
411 function get_NLS_COMPLIANT(request_id in number) return fnd_concurrent_requests.NLS_COMPLIANT%TYPE;
413
414 --
415 -- FUNCTION
416 -- get_LAST_UPDATE_LOGIN
417 --
418 -- Purpose
419 -- get LAST_UPDATE_LOGIN of a request based on request_id
420 -- if request_id is not given, obtain from fnd_global
421 --
422 -- Note
423 -- returns NULL on failure
424 --
425 function get_LAST_UPDATE_LOGIN(request_id in number) return fnd_concurrent_requests.LAST_UPDATE_LOGIN%TYPE;
426
427
428 --
429 -- FUNCTION
430 -- get_NLS_LANGUAGE
431 --
432 -- Purpose
433 -- get NLS_LANGUAGE of a request based on request_id
434 -- if request_id is not given, obtain from fnd_global
435 --
436 -- Note
437 -- returns NULL on failure
438 --
439 function get_NLS_LANGUAGE(request_id in number) return fnd_concurrent_requests.NLS_LANGUAGE%TYPE;
440
441
442 --
443 -- FUNCTION
444 -- get_NLS_TERRITORY
445 --
446 -- Purpose
447 -- get NLS_TERRITORY of a request based on request_id
448 -- if request_id is not given, obtain from fnd_global
449 --
450 -- Note
451 -- returns NULL on failure
452 --
453 function get_NLS_TERRITORY(request_id in number) return fnd_concurrent_requests.NLS_TERRITORY%TYPE;
454
455
456 --
457 -- FUNCTION
458 -- get_PRINTER
459 --
460 -- Purpose
461 -- get PRINTER of a request based on request_id
462 -- if request_id is not given, obtain from fnd_global
463 --
464 -- Note
465 -- returns NULL on failure
466 --
467 function get_PRINTER(request_id in number) return fnd_concurrent_requests.PRINTER%TYPE;
468
469
470 --
471 -- FUNCTION
472 -- get_PRINT_STYLE
473 --
474 -- Purpose
475 -- get PRINT_STYLE of a request based on request_id
476 -- if request_id is not given, obtain from fnd_global
477 --
478 -- Note
479 -- returns NULL on failure
480 --
481 function get_PRINT_STYLE(request_id in number) return fnd_concurrent_requests.PRINT_STYLE%TYPE;
482
483
484 --
485 -- FUNCTION
486 -- get_PRINT_GROUP
487 --
488 -- Purpose
489 -- get PRINT_GROUP of a request based on request_id
490 -- if request_id is not given, obtain from fnd_global
491 --
492 -- Note
493 -- returns NULL on failure
494 --
495 function get_PRINT_GROUP(request_id in number) return fnd_concurrent_requests.PRINT_GROUP%TYPE;
496
497
498 --
499 -- FUNCTION
500 -- get_REQ_CLASS_APPLICATION_ID
501 --
502 -- Purpose
503 -- get REQUEST_CLASS_APPLICATION_ID of a request based on request_id
504 -- if request_id is not given, obtain from fnd_global
505 --
506 -- Note
507 -- returns NULL on failure
508 --
509 function get_REQ_CLASS_APPLICATION_ID(request_id in number) return fnd_concurrent_requests.REQUEST_CLASS_APPLICATION_ID%TYPE;
510
511
512 --
513 -- FUNCTION
514 -- get_CONC_REQUEST_CLASS_ID
515 --
516 -- Purpose
517 -- get CONCURRENT_REQUEST_CLASS_ID of a request based on request_id
518 -- if request_id is not given, obtain from fnd_global
519 --
520 -- Note
521 -- returns NULL on failure
522 --
523 function get_CONC_REQUEST_CLASS_ID(request_id in number) return fnd_concurrent_requests.CONCURRENT_REQUEST_CLASS_ID%TYPE;
524
525
526 --
527 -- FUNCTION
528 -- get_PARENT_REQUEST_ID
529 --
530 -- Purpose
531 -- get PARENT_REQUEST_ID of a request based on request_id
532 -- if request_id is not given, obtain from fnd_global
533 --
534 -- Note
535 -- returns NULL on failure
536 --
537 function get_PARENT_REQUEST_ID(request_id in number) return fnd_concurrent_requests.PARENT_REQUEST_ID%TYPE;
538
539
540 --
541 -- FUNCTION
542 -- get_CONC_LOGIN_ID
543 --
544 -- Purpose
545 -- get CONC_LOGIN_ID of a request based on request_id
546 -- if request_id is not given, obtain from fnd_global
547 --
548 -- Note
549 -- returns NULL on failure
550 --
551 function get_CONC_LOGIN_ID(request_id in number) return fnd_concurrent_requests.CONC_LOGIN_ID%TYPE;
552
553
554 --
555 -- FUNCTION
556 -- get_LANGUAGE_ID
557 --
558 -- Purpose
559 -- get LANGUAGE_ID of a request based on request_id
560 -- if request_id is not given, obtain from fnd_global
561 --
562 -- Note
563 -- returns NULL on failure
564 --
565 function get_LANGUAGE_ID(request_id in number) return fnd_concurrent_requests.LANGUAGE_ID%TYPE;
566
567
568 --
569 -- FUNCTION
570 -- get_DESCRIPTION
571 --
572 -- Purpose
573 -- get DESCRIPTION of a request based on request_id
574 -- if request_id is not given, obtain from fnd_global
575 --
576 -- Note
577 -- returns NULL on failure
578 --
579 function get_DESCRIPTION(request_id in number) return fnd_concurrent_requests.DESCRIPTION%TYPE;
580
581
582 --
583 -- FUNCTION
584 -- get_REQ_INFORMATION
585 --
586 -- Purpose
587 -- get REQ_INFORMATION of a request based on request_id
588 -- if request_id is not given, obtain from fnd_global
589 --
590 -- Note
591 -- returns NULL on failure
592 --
593 function get_REQ_INFORMATION(request_id in number) return fnd_concurrent_requests.REQ_INFORMATION%TYPE;
594
595
596 --
597 -- FUNCTION
598 -- get_RESUBMIT_INTERVAL
599 --
600 -- Purpose
601 -- get RESUBMIT_INTERVAL of a request based on request_id
605 -- returns NULL on failure
602 -- if request_id is not given, obtain from fnd_global
603 --
604 -- Note
606 --
607 function get_RESUBMIT_INTERVAL(request_id in number) return fnd_concurrent_requests.RESUBMIT_INTERVAL%TYPE;
608
609
610 --
611 -- FUNCTION
612 -- get_RESUB_INTERVAL_UNIT_CODE
613 --
614 -- Purpose
615 -- get RESUBMIT_INTERVAL_UNIT_CODE of a request based on request_id
616 -- if request_id is not given, obtain from fnd_global
617 --
618 -- Note
619 -- returns NULL on failure
620 --
621 function get_RESUB_INTERVAL_UNIT_CODE(request_id in number) return fnd_concurrent_requests.RESUBMIT_INTERVAL_UNIT_CODE%TYPE;
622
623
624 --
625 -- FUNCTION
626 -- get_RESUB_INTERVAL_TYPE_CODE
627 --
628 -- Purpose
629 -- get RESUBMIT_INTERVAL_TYPE_CODE of a request based on request_id
630 -- if request_id is not given, obtain from fnd_global
631 --
632 -- Note
633 -- returns NULL on failure
634 --
635 function get_RESUB_INTERVAL_TYPE_CODE(request_id in number) return fnd_concurrent_requests.RESUBMIT_INTERVAL_TYPE_CODE%TYPE;
636
637
638 --
639 -- FUNCTION
640 -- get_RESUBMIT_TIME
641 --
642 -- Purpose
643 -- get RESUBMIT_TIME of a request based on request_id
644 -- if request_id is not given, obtain from fnd_global
645 --
646 -- Note
647 -- returns NULL on failure
648 --
649 function get_RESUBMIT_TIME(request_id in number) return fnd_concurrent_requests.RESUBMIT_TIME%TYPE;
650
651
652 --
653 -- FUNCTION
654 -- get_RESUBMIT_END_DATE
655 --
656 -- Purpose
657 -- get RESUBMIT_END_DATE of a request based on request_id
658 -- if request_id is not given, obtain from fnd_global
659 --
660 -- Note
661 -- returns NULL on failure
662 --
663 function get_RESUBMIT_END_DATE(request_id in number) return fnd_concurrent_requests.RESUBMIT_END_DATE%TYPE;
664
665
666 --
667 -- FUNCTION
668 -- get_RESUBMITTED
669 --
670 -- Purpose
671 -- get RESUBMITTED of a request based on request_id
672 -- if request_id is not given, obtain from fnd_global
673 --
674 -- Note
675 -- returns NULL on failure
676 --
677 function get_RESUBMITTED(request_id in number) return fnd_concurrent_requests.RESUBMITTED%TYPE;
678
679
680 --
681 -- FUNCTION
682 -- get_CONTROLLING_MANAGER
683 --
684 -- Purpose
685 -- get CONTROLLING_MANAGER of a request based on request_id
686 -- if request_id is not given, obtain from fnd_global
687 --
688 -- Note
689 -- returns NULL on failure
690 --
691 function get_CONTROLLING_MANAGER(request_id in number) return fnd_concurrent_requests.CONTROLLING_MANAGER%TYPE;
692
693
694 --
695 -- FUNCTION
696 -- get_ACTUAL_START_DATE
697 --
698 -- Purpose
699 -- get ACTUAL_START_DATE of a request based on request_id
700 -- if request_id is not given, obtain from fnd_global
701 --
702 -- Note
703 -- returns NULL on failure
704 --
705 function get_ACTUAL_START_DATE(request_id in number) return fnd_concurrent_requests.ACTUAL_START_DATE%TYPE;
706
707
708 --
709 -- FUNCTION
710 -- get_ACTUAL_COMPLETION_DATE
711 --
712 -- Purpose
713 -- get ACTUAL_COMPLETION_DATE of a request based on request_id
714 -- if request_id is not given, obtain from fnd_global
715 --
716 -- Note
717 -- returns NULL on failure
718 --
719 function get_ACTUAL_COMPLETION_DATE(request_id in number) return fnd_concurrent_requests.ACTUAL_COMPLETION_DATE%TYPE;
720
721
722 --
723 -- FUNCTION
724 -- get_COMPLETION_TEXT
725 --
726 -- Purpose
727 -- get COMPLETION_TEXT of a request based on request_id
728 -- if request_id is not given, obtain from fnd_global
729 --
730 -- Note
731 -- returns NULL on failure
732 --
733 function get_COMPLETION_TEXT(request_id in number) return fnd_concurrent_requests.COMPLETION_TEXT%TYPE;
734
735
736 --
737 -- FUNCTION
738 -- get_OUTCOME_PRODUCT
739 --
740 -- Purpose
741 -- get OUTCOME_PRODUCT of a request based on request_id
742 -- if request_id is not given, obtain from fnd_global
743 --
744 -- Note
745 -- returns NULL on failure
746 --
747 function get_OUTCOME_PRODUCT(request_id in number) return fnd_concurrent_requests.OUTCOME_PRODUCT%TYPE;
748
749
750 --
751 -- FUNCTION
752 -- get_OUTCOME_CODE
753 --
754 -- Purpose
755 -- get OUTCOME_CODE of a request based on request_id
756 -- if request_id is not given, obtain from fnd_global
757 --
758 -- Note
759 -- returns NULL on failure
760 --
761 function get_OUTCOME_CODE(request_id in number) return fnd_concurrent_requests.OUTCOME_CODE%TYPE;
762
763
764 --
765 -- FUNCTION
766 -- get_CPU_SECONDS
767 --
768 -- Purpose
769 -- get CPU_SECONDS of a request based on request_id
770 -- if request_id is not given, obtain from fnd_global
771 --
772 -- Note
773 -- returns NULL on failure
774 --
775 function get_CPU_SECONDS(request_id in number) return fnd_concurrent_requests.CPU_SECONDS%TYPE;
776
777
778 --
779 -- FUNCTION
780 -- get_LOGICAL_IOS
781 --
782 -- Purpose
783 -- get LOGICAL_IOS of a request based on request_id
784 -- if request_id is not given, obtain from fnd_global
785 --
786 -- Note
787 -- returns NULL on failure
788 --
789 function get_LOGICAL_IOS(request_id in number) return fnd_concurrent_requests.LOGICAL_IOS%TYPE;
790
791
792 --
796 -- Purpose
793 -- FUNCTION
794 -- get_PHYSICAL_IOS
795 --
797 -- get PHYSICAL_IOS of a request based on request_id
798 -- if request_id is not given, obtain from fnd_global
799 --
800 -- Note
801 -- returns NULL on failure
802 --
803 function get_PHYSICAL_IOS(request_id in number) return fnd_concurrent_requests.PHYSICAL_IOS%TYPE;
804
805
806 --
807 -- FUNCTION
808 -- get_LOGFILE_NAME
809 --
810 -- Purpose
811 -- get LOGFILE_NAME of a request based on request_id
812 -- if request_id is not given, obtain from fnd_global
813 --
814 -- Note
815 -- returns NULL on failure
816 --
817 function get_LOGFILE_NAME(request_id in number) return fnd_concurrent_requests.LOGFILE_NAME%TYPE;
818
819
820 --
821 -- FUNCTION
822 -- get_LOGFILE_NODE_NAME
823 --
824 -- Purpose
825 -- get LOGFILE_NODE_NAME of a request based on request_id
826 -- if request_id is not given, obtain from fnd_global
827 --
828 -- Note
829 -- returns NULL on failure
830 --
831 function get_LOGFILE_NODE_NAME(request_id in number) return fnd_concurrent_requests.LOGFILE_NODE_NAME%TYPE;
832
833
834 --
835 -- FUNCTION
836 -- get_OUTFILE_NAME
837 --
838 -- Purpose
839 -- get OUTFILE_NAME of a request based on request_id
840 -- if request_id is not given, obtain from fnd_global
841 --
842 -- Note
843 -- returns NULL on failure
844 --
845 function get_OUTFILE_NAME(request_id in number) return fnd_concurrent_requests.OUTFILE_NAME%TYPE;
846
847
848 --
849 -- FUNCTION
850 -- get_OUTFILE_NODE_NAME
851 --
852 -- Purpose
853 -- get OUTFILE_NODE_NAME of a request based on request_id
854 -- if request_id is not given, obtain from fnd_global
855 --
856 -- Note
857 -- returns NULL on failure
858 --
859 function get_OUTFILE_NODE_NAME(request_id in number) return fnd_concurrent_requests.OUTFILE_NODE_NAME%TYPE;
860
861
862 --
863 -- FUNCTION
864 -- get_ARGUMENT_TEXT
865 --
866 -- Purpose
867 -- get ARGUMENT_TEXT of a request based on request_id
868 -- if request_id is not given, obtain from fnd_global
869 --
870 -- Note
871 -- returns NULL on failure
872 --
873 function get_ARGUMENT_TEXT(request_id in number) return fnd_concurrent_requests.ARGUMENT_TEXT%TYPE;
874
875
876 --
877 -- FUNCTION
878 -- get_ARGUMENT1
879 --
880 -- Purpose
881 -- get ARGUMENT1 of a request based on request_id
882 -- if request_id is not given, obtain from fnd_global
883 --
884 -- Note
885 -- returns NULL on failure
886 --
887 function get_ARGUMENT1(request_id in number) return fnd_concurrent_requests.ARGUMENT1%TYPE;
888
889
890 --
891 -- FUNCTION
892 -- get_ARGUMENT2
893 --
894 -- Purpose
895 -- get ARGUMENT2 of a request based on request_id
896 -- if request_id is not given, obtain from fnd_global
897 --
898 -- Note
899 -- returns NULL on failure
900 --
901 function get_ARGUMENT2(request_id in number) return fnd_concurrent_requests.ARGUMENT2%TYPE;
902
903
904 --
905 -- FUNCTION
906 -- get_ARGUMENT3
907 --
908 -- Purpose
909 -- get ARGUMENT3 of a request based on request_id
910 -- if request_id is not given, obtain from fnd_global
911 --
912 -- Note
913 -- returns NULL on failure
914 --
915 function get_ARGUMENT3(request_id in number) return fnd_concurrent_requests.ARGUMENT3%TYPE;
916
917
918 --
919 -- FUNCTION
920 -- get_ARGUMENT4
921 --
922 -- Purpose
923 -- get ARGUMENT4 of a request based on request_id
924 -- if request_id is not given, obtain from fnd_global
925 --
926 -- Note
927 -- returns NULL on failure
928 --
929 function get_ARGUMENT4(request_id in number) return fnd_concurrent_requests.ARGUMENT4%TYPE;
930
931
932 --
933 -- FUNCTION
934 -- get_ARGUMENT5
935 --
936 -- Purpose
937 -- get ARGUMENT5 of a request based on request_id
938 -- if request_id is not given, obtain from fnd_global
939 --
940 -- Note
941 -- returns NULL on failure
942 --
943 function get_ARGUMENT5(request_id in number) return fnd_concurrent_requests.ARGUMENT5%TYPE;
944
945
946 --
947 -- FUNCTION
948 -- get_ARGUMENT6
949 --
950 -- Purpose
951 -- get ARGUMENT6 of a request based on request_id
952 -- if request_id is not given, obtain from fnd_global
953 --
954 -- Note
955 -- returns NULL on failure
956 --
957 function get_ARGUMENT6(request_id in number) return fnd_concurrent_requests.ARGUMENT6%TYPE;
958
959
960 --
961 -- FUNCTION
962 -- get_ARGUMENT7
963 --
964 -- Purpose
965 -- get ARGUMENT7 of a request based on request_id
966 -- if request_id is not given, obtain from fnd_global
967 --
968 -- Note
969 -- returns NULL on failure
970 --
971 function get_ARGUMENT7(request_id in number) return fnd_concurrent_requests.ARGUMENT7%TYPE;
972
973
974 --
975 -- FUNCTION
976 -- get_ARGUMENT8
977 --
978 -- Purpose
979 -- get ARGUMENT8 of a request based on request_id
980 -- if request_id is not given, obtain from fnd_global
981 --
982 -- Note
983 -- returns NULL on failure
984 --
985 function get_ARGUMENT8(request_id in number) return fnd_concurrent_requests.ARGUMENT8%TYPE;
986
987
988 --
989 -- FUNCTION
990 -- get_ARGUMENT9
991 --
992 -- Purpose
996 -- Note
993 -- get ARGUMENT9 of a request based on request_id
994 -- if request_id is not given, obtain from fnd_global
995 --
997 -- returns NULL on failure
998 --
999 function get_ARGUMENT9(request_id in number) return fnd_concurrent_requests.ARGUMENT9%TYPE;
1000
1001
1002 --
1003 -- FUNCTION
1004 -- get_ARGUMENT10
1005 --
1006 -- Purpose
1007 -- get ARGUMENT10 of a request based on request_id
1008 -- if request_id is not given, obtain from fnd_global
1009 --
1010 -- Note
1011 -- returns NULL on failure
1012 --
1013 function get_ARGUMENT10(request_id in number) return fnd_concurrent_requests.ARGUMENT10%TYPE;
1014
1015
1016 --
1017 -- FUNCTION
1018 -- get_ARGUMENT11
1019 --
1020 -- Purpose
1021 -- get ARGUMENT11 of a request based on request_id
1022 -- if request_id is not given, obtain from fnd_global
1023 --
1024 -- Note
1025 -- returns NULL on failure
1026 --
1027 function get_ARGUMENT11(request_id in number) return fnd_concurrent_requests.ARGUMENT11%TYPE;
1028
1029
1030 --
1031 -- FUNCTION
1032 -- get_ARGUMENT12
1033 --
1034 -- Purpose
1035 -- get ARGUMENT12 of a request based on request_id
1036 -- if request_id is not given, obtain from fnd_global
1037 --
1038 -- Note
1039 -- returns NULL on failure
1040 --
1041 function get_ARGUMENT12(request_id in number) return fnd_concurrent_requests.ARGUMENT12%TYPE;
1042
1043
1044 --
1045 -- FUNCTION
1046 -- get_ARGUMENT13
1047 --
1048 -- Purpose
1049 -- get ARGUMENT13 of a request based on request_id
1050 -- if request_id is not given, obtain from fnd_global
1051 --
1052 -- Note
1053 -- returns NULL on failure
1054 --
1055 function get_ARGUMENT13(request_id in number) return fnd_concurrent_requests.ARGUMENT13%TYPE;
1056
1057
1058 --
1059 -- FUNCTION
1060 -- get_ARGUMENT14
1061 --
1062 -- Purpose
1063 -- get ARGUMENT14 of a request based on request_id
1064 -- if request_id is not given, obtain from fnd_global
1065 --
1066 -- Note
1067 -- returns NULL on failure
1068 --
1069 function get_ARGUMENT14(request_id in number) return fnd_concurrent_requests.ARGUMENT14%TYPE;
1070
1071
1072 --
1073 -- FUNCTION
1074 -- get_ARGUMENT15
1075 --
1076 -- Purpose
1077 -- get ARGUMENT15 of a request based on request_id
1078 -- if request_id is not given, obtain from fnd_global
1079 --
1080 -- Note
1081 -- returns NULL on failure
1082 --
1083 function get_ARGUMENT15(request_id in number) return fnd_concurrent_requests.ARGUMENT15%TYPE;
1084
1085
1086 --
1087 -- FUNCTION
1088 -- get_ARGUMENT16
1089 --
1090 -- Purpose
1091 -- get ARGUMENT16 of a request based on request_id
1092 -- if request_id is not given, obtain from fnd_global
1093 --
1094 -- Note
1095 -- returns NULL on failure
1096 --
1097 function get_ARGUMENT16(request_id in number) return fnd_concurrent_requests.ARGUMENT16%TYPE;
1098
1099
1100 --
1101 -- FUNCTION
1102 -- get_ARGUMENT17
1103 --
1104 -- Purpose
1105 -- get ARGUMENT17 of a request based on request_id
1106 -- if request_id is not given, obtain from fnd_global
1107 --
1108 -- Note
1109 -- returns NULL on failure
1110 --
1111 function get_ARGUMENT17(request_id in number) return fnd_concurrent_requests.ARGUMENT17%TYPE;
1112
1113
1114 --
1115 -- FUNCTION
1116 -- get_ARGUMENT18
1117 --
1118 -- Purpose
1119 -- get ARGUMENT18 of a request based on request_id
1120 -- if request_id is not given, obtain from fnd_global
1121 --
1122 -- Note
1123 -- returns NULL on failure
1124 --
1125 function get_ARGUMENT18(request_id in number) return fnd_concurrent_requests.ARGUMENT18%TYPE;
1126
1127
1128 --
1129 -- FUNCTION
1130 -- get_ARGUMENT19
1131 --
1132 -- Purpose
1133 -- get ARGUMENT19 of a request based on request_id
1134 -- if request_id is not given, obtain from fnd_global
1135 --
1136 -- Note
1137 -- returns NULL on failure
1138 --
1139 function get_ARGUMENT19(request_id in number) return fnd_concurrent_requests.ARGUMENT19%TYPE;
1140
1141
1142 --
1143 -- FUNCTION
1144 -- get_ARGUMENT20
1145 --
1146 -- Purpose
1147 -- get ARGUMENT20 of a request based on request_id
1148 -- if request_id is not given, obtain from fnd_global
1149 --
1150 -- Note
1151 -- returns NULL on failure
1152 --
1153 function get_ARGUMENT20(request_id in number) return fnd_concurrent_requests.ARGUMENT20%TYPE;
1154
1155
1156 --
1157 -- FUNCTION
1158 -- get_ARGUMENT21
1159 --
1160 -- Purpose
1161 -- get ARGUMENT21 of a request based on request_id
1162 -- if request_id is not given, obtain from fnd_global
1163 --
1164 -- Note
1165 -- returns NULL on failure
1166 --
1167 function get_ARGUMENT21(request_id in number) return fnd_concurrent_requests.ARGUMENT21%TYPE;
1168
1169
1170 --
1171 -- FUNCTION
1172 -- get_ARGUMENT22
1173 --
1174 -- Purpose
1175 -- get ARGUMENT22 of a request based on request_id
1176 -- if request_id is not given, obtain from fnd_global
1177 --
1178 -- Note
1179 -- returns NULL on failure
1180 --
1181 function get_ARGUMENT22(request_id in number) return fnd_concurrent_requests.ARGUMENT22%TYPE;
1182
1183
1184 --
1185 -- FUNCTION
1186 -- get_ARGUMENT23
1187 --
1188 -- Purpose
1189 -- get ARGUMENT23 of a request based on request_id
1190 -- if request_id is not given, obtain from fnd_global
1191 --
1192 -- Note
1196
1193 -- returns NULL on failure
1194 --
1195 function get_ARGUMENT23(request_id in number) return fnd_concurrent_requests.ARGUMENT23%TYPE;
1197
1198 --
1199 -- FUNCTION
1200 -- get_ARGUMENT24
1201 --
1202 -- Purpose
1203 -- get ARGUMENT24 of a request based on request_id
1204 -- if request_id is not given, obtain from fnd_global
1205 --
1206 -- Note
1207 -- returns NULL on failure
1208 --
1209 function get_ARGUMENT24(request_id in number) return fnd_concurrent_requests.ARGUMENT24%TYPE;
1210
1211
1212 --
1213 -- FUNCTION
1214 -- get_ARGUMENT25
1215 --
1216 -- Purpose
1217 -- get ARGUMENT25 of a request based on request_id
1218 -- if request_id is not given, obtain from fnd_global
1219 --
1220 -- Note
1221 -- returns NULL on failure
1222 --
1223 function get_ARGUMENT25(request_id in number) return fnd_concurrent_requests.ARGUMENT25%TYPE;
1224
1225
1226 --
1227 -- FUNCTION
1228 -- get_CRM_THRSHLD
1229 --
1230 -- Purpose
1231 -- get CRM_THRSHLD of a request based on request_id
1232 -- if request_id is not given, obtain from fnd_global
1233 --
1234 -- Note
1235 -- returns NULL on failure
1236 --
1237 function get_CRM_THRSHLD(request_id in number) return fnd_concurrent_requests.CRM_THRSHLD%TYPE;
1238
1239
1240 --
1241 -- FUNCTION
1242 -- get_CRM_TSTMP
1243 --
1244 -- Purpose
1245 -- get CRM_TSTMP of a request based on request_id
1246 -- if request_id is not given, obtain from fnd_global
1247 --
1248 -- Note
1249 -- returns NULL on failure
1250 --
1251 function get_CRM_TSTMP(request_id in number) return fnd_concurrent_requests.CRM_TSTMP%TYPE;
1252
1253
1254 --
1255 -- FUNCTION
1256 -- get_CRITICAL
1257 --
1258 -- Purpose
1259 -- get CRITICAL of a request based on request_id
1260 -- if request_id is not given, obtain from fnd_global
1261 --
1262 -- Note
1263 -- returns NULL on failure
1264 --
1265 function get_CRITICAL(request_id in number) return fnd_concurrent_requests.CRITICAL%TYPE;
1266
1267
1268 --
1269 -- FUNCTION
1270 -- get_REQUEST_TYPE
1271 --
1272 -- Purpose
1273 -- get REQUEST_TYPE of a request based on request_id
1274 -- if request_id is not given, obtain from fnd_global
1275 --
1276 -- Note
1277 -- returns NULL on failure
1278 --
1279 function get_REQUEST_TYPE(request_id in number) return fnd_concurrent_requests.REQUEST_TYPE%TYPE;
1280
1281
1282 --
1283 -- FUNCTION
1284 -- get_ORACLE_PROCESS_ID
1285 --
1286 -- Purpose
1287 -- get ORACLE_PROCESS_ID of a request based on request_id
1288 -- if request_id is not given, obtain from fnd_global
1289 --
1290 -- Note
1291 -- returns NULL on failure
1292 --
1293 function get_ORACLE_PROCESS_ID(request_id in number) return fnd_concurrent_requests.ORACLE_PROCESS_ID%TYPE;
1294
1295
1296 --
1297 -- FUNCTION
1298 -- get_ORACLE_SESSION_ID
1299 --
1300 -- Purpose
1301 -- get ORACLE_SESSION_ID of a request based on request_id
1302 -- if request_id is not given, obtain from fnd_global
1303 --
1304 -- Note
1305 -- returns NULL on failure
1306 --
1307 function get_ORACLE_SESSION_ID(request_id in number) return fnd_concurrent_requests.ORACLE_SESSION_ID%TYPE;
1308
1309
1310 --
1311 -- FUNCTION
1312 -- get_OS_PROCESS_ID
1313 --
1314 -- Purpose
1315 -- get OS_PROCESS_ID of a request based on request_id
1316 -- if request_id is not given, obtain from fnd_global
1317 --
1318 -- Note
1319 -- returns NULL on failure
1320 --
1321 function get_OS_PROCESS_ID(request_id in number) return fnd_concurrent_requests.OS_PROCESS_ID%TYPE;
1322
1323
1324 --
1325 -- FUNCTION
1326 -- get_PRINT_JOB_ID
1327 --
1328 -- Purpose
1329 -- get PRINT_JOB_ID of a request based on request_id
1330 -- if request_id is not given, obtain from fnd_global
1331 --
1332 -- Note
1333 -- returns NULL on failure
1334 --
1335 function get_PRINT_JOB_ID(request_id in number) return fnd_concurrent_requests.PRINT_JOB_ID%TYPE;
1336
1337
1338 --
1339 -- FUNCTION
1340 -- get_OUTPUT_FILE_TYPE
1341 --
1342 -- Purpose
1343 -- get OUTPUT_FILE_TYPE of a request based on request_id
1344 -- if request_id is not given, obtain from fnd_global
1345 --
1346 -- Note
1347 -- returns NULL on failure
1348 --
1349 function get_OUTPUT_FILE_TYPE(request_id in number) return fnd_concurrent_requests.OUTPUT_FILE_TYPE%TYPE;
1350
1351
1352 --
1353 -- FUNCTION
1354 -- get_RELEASE_CLASS_APP_ID
1355 --
1356 -- Purpose
1357 -- get RELEASE_CLASS_APP_ID of a request based on request_id
1358 -- if request_id is not given, obtain from fnd_global
1359 --
1360 -- Note
1361 -- returns NULL on failure
1362 --
1363 function get_RELEASE_CLASS_APP_ID(request_id in number) return fnd_concurrent_requests.RELEASE_CLASS_APP_ID%TYPE;
1364
1365
1366 --
1367 -- FUNCTION
1368 -- get_RELEASE_CLASS_ID
1369 --
1370 -- Purpose
1371 -- get RELEASE_CLASS_ID of a request based on request_id
1372 -- if request_id is not given, obtain from fnd_global
1373 --
1374 -- Note
1375 -- returns NULL on failure
1376 --
1377 function get_RELEASE_CLASS_ID(request_id in number) return fnd_concurrent_requests.RELEASE_CLASS_ID%TYPE;
1378
1379
1380 --
1381 -- FUNCTION
1382 -- get_STALE_DATE
1383 --
1384 -- Purpose
1385 -- get STALE_DATE of a request based on request_id
1386 -- if request_id is not given, obtain from fnd_global
1387 --
1388 -- Note
1392
1389 -- returns NULL on failure
1390 --
1391 function get_STALE_DATE(request_id in number) return fnd_concurrent_requests.STALE_DATE%TYPE;
1393
1394 --
1395 -- FUNCTION
1396 -- get_CANCEL_OR_HOLD
1397 --
1398 -- Purpose
1399 -- get CANCEL_OR_HOLD of a request based on request_id
1400 -- if request_id is not given, obtain from fnd_global
1401 --
1402 -- Note
1403 -- returns NULL on failure
1404 --
1405 function get_CANCEL_OR_HOLD(request_id in number) return fnd_concurrent_requests.CANCEL_OR_HOLD%TYPE;
1406
1407
1408 --
1409 -- FUNCTION
1410 -- get_NOTIFY_ON_PP_ERROR
1411 --
1412 -- Purpose
1413 -- get NOTIFY_ON_PP_ERROR of a request based on request_id
1414 -- if request_id is not given, obtain from fnd_global
1415 --
1416 -- Note
1417 -- returns NULL on failure
1418 --
1419 function get_NOTIFY_ON_PP_ERROR(request_id in number) return fnd_concurrent_requests.NOTIFY_ON_PP_ERROR%TYPE;
1420
1421
1422 --
1423 -- FUNCTION
1424 -- get_CD_ID
1425 --
1426 -- Purpose
1427 -- get CD_ID of a request based on request_id
1428 -- if request_id is not given, obtain from fnd_global
1429 --
1430 -- Note
1431 -- returns NULL on failure
1432 --
1433 function get_CD_ID(request_id in number) return fnd_concurrent_requests.CD_ID%TYPE;
1434
1435
1436 --
1437 -- FUNCTION
1438 -- get_REQUEST_LIMIT
1439 --
1440 -- Purpose
1441 -- get REQUEST_LIMIT of a request based on request_id
1442 -- if request_id is not given, obtain from fnd_global
1443 --
1444 -- Note
1445 -- returns NULL on failure
1446 --
1447 function get_REQUEST_LIMIT(request_id in number) return fnd_concurrent_requests.REQUEST_LIMIT%TYPE;
1448
1449
1450 --
1451 -- FUNCTION
1452 -- get_CRM_RELEASE_DATE
1453 --
1454 -- Purpose
1455 -- get CRM_RELEASE_DATE of a request based on request_id
1456 -- if request_id is not given, obtain from fnd_global
1457 --
1458 -- Note
1459 -- returns NULL on failure
1460 --
1461 function get_CRM_RELEASE_DATE(request_id in number) return fnd_concurrent_requests.CRM_RELEASE_DATE%TYPE;
1462
1463
1464 --
1465 -- FUNCTION
1466 -- get_POST_REQUEST_STATUS
1467 --
1468 -- Purpose
1469 -- get POST_REQUEST_STATUS of a request based on request_id
1470 -- if request_id is not given, obtain from fnd_global
1471 --
1472 -- Note
1473 -- returns NULL on failure
1474 --
1475 function get_POST_REQUEST_STATUS(request_id in number) return fnd_concurrent_requests.POST_REQUEST_STATUS%TYPE;
1476
1477
1478 --
1479 -- FUNCTION
1480 -- get_COMPLETION_CODE
1481 --
1482 -- Purpose
1483 -- get COMPLETION_CODE of a request based on request_id
1484 -- if request_id is not given, obtain from fnd_global
1485 --
1486 -- Note
1487 -- returns NULL on failure
1488 --
1489 function get_COMPLETION_CODE(request_id in number) return fnd_concurrent_requests.COMPLETION_CODE%TYPE;
1490
1491
1492 --
1493 -- FUNCTION
1494 -- get_INCREMENT_DATES
1495 --
1496 -- Purpose
1497 -- get INCREMENT_DATES of a request based on request_id
1498 -- if request_id is not given, obtain from fnd_global
1499 --
1500 -- Note
1501 -- returns NULL on failure
1502 --
1503 function get_INCREMENT_DATES(request_id in number) return fnd_concurrent_requests.INCREMENT_DATES%TYPE;
1504
1505
1506 --
1507 -- FUNCTION
1508 -- get_RESTART
1509 --
1510 -- Purpose
1511 -- get RESTART of a request based on request_id
1512 -- if request_id is not given, obtain from fnd_global
1513 --
1514 -- Note
1515 -- returns NULL on failure
1516 --
1517 function get_RESTART(request_id in number) return fnd_concurrent_requests.RESTART%TYPE;
1518
1519
1520 --
1521 -- FUNCTION
1522 -- get_ENABLE_TRACE
1523 --
1524 -- Purpose
1525 -- get ENABLE_TRACE of a request based on request_id
1526 -- if request_id is not given, obtain from fnd_global
1527 --
1528 -- Note
1529 -- returns NULL on failure
1530 --
1531 function get_ENABLE_TRACE(request_id in number) return fnd_concurrent_requests.ENABLE_TRACE%TYPE;
1532
1533
1534 --
1535 -- FUNCTION
1536 -- get_RESUB_COUNT
1537 --
1538 -- Purpose
1539 -- get RESUB_COUNT of a request based on request_id
1540 -- if request_id is not given, obtain from fnd_global
1541 --
1542 -- Note
1543 -- returns NULL on failure
1544 --
1545 function get_RESUB_COUNT(request_id in number) return fnd_concurrent_requests.RESUB_COUNT%TYPE;
1546
1547
1548 --
1549 -- FUNCTION
1550 -- get_NLS_CODESET
1551 --
1552 -- Purpose
1553 -- get NLS_CODESET of a request based on request_id
1554 -- if request_id is not given, obtain from fnd_global
1555 --
1556 -- Note
1557 -- returns NULL on failure
1558 --
1559 function get_NLS_CODESET(request_id in number) return fnd_concurrent_requests.NLS_CODESET%TYPE;
1560
1561
1562 --
1563 -- FUNCTION
1564 -- get_OFILE_SIZE
1565 --
1566 -- Purpose
1567 -- get OFILE_SIZE of a request based on request_id
1568 -- if request_id is not given, obtain from fnd_global
1569 --
1570 -- Note
1571 -- returns NULL on failure
1572 --
1573 function get_OFILE_SIZE(request_id in number) return fnd_concurrent_requests.OFILE_SIZE%TYPE;
1574
1575
1576 --
1577 -- FUNCTION
1578 -- get_LFILE_SIZE
1579 --
1580 -- Purpose
1581 -- get LFILE_SIZE of a request based on request_id
1582 -- if request_id is not given, obtain from fnd_global
1583 --
1584 -- Note
1585 -- returns NULL on failure
1589
1586 --
1587 function get_LFILE_SIZE(request_id in number) return fnd_concurrent_requests.LFILE_SIZE%TYPE;
1588
1590 --
1591 -- FUNCTION
1592 -- get_STALE
1593 --
1594 -- Purpose
1595 -- get STALE of a request based on request_id
1596 -- if request_id is not given, obtain from fnd_global
1597 --
1598 -- Note
1599 -- returns NULL on failure
1600 --
1601 function get_STALE(request_id in number) return fnd_concurrent_requests.STALE%TYPE;
1602
1603
1604 --
1605 -- FUNCTION
1606 -- get_SECURITY_GROUP_ID
1607 --
1608 -- Purpose
1609 -- get SECURITY_GROUP_ID of a request based on request_id
1610 -- if request_id is not given, obtain from fnd_global
1611 --
1612 -- Note
1613 -- returns NULL on failure
1614 --
1615 function get_SECURITY_GROUP_ID(request_id in number) return fnd_concurrent_requests.SECURITY_GROUP_ID%TYPE;
1616
1617
1618 --
1619 -- FUNCTION
1620 -- get_RESOURCE_CONSUMER_GROUP
1621 --
1622 -- Purpose
1623 -- get RESOURCE_CONSUMER_GROUP of a request based on request_id
1624 -- if request_id is not given, obtain from fnd_global
1625 --
1626 -- Note
1627 -- returns NULL on failure
1628 --
1629 function get_RESOURCE_CONSUMER_GROUP(request_id in number) return fnd_concurrent_requests.RESOURCE_CONSUMER_GROUP%TYPE;
1630
1631
1632 --
1633 -- FUNCTION
1634 -- get_EXP_DATE
1635 --
1636 -- Purpose
1637 -- get EXP_DATE of a request based on request_id
1638 -- if request_id is not given, obtain from fnd_global
1639 --
1640 -- Note
1641 -- returns NULL on failure
1642 --
1643 function get_EXP_DATE(request_id in number) return fnd_concurrent_requests.EXP_DATE%TYPE;
1644
1645
1646 --
1647 -- FUNCTION
1648 -- get_QUEUE_APP_ID
1649 --
1650 -- Purpose
1651 -- get QUEUE_APP_ID of a request based on request_id
1652 -- if request_id is not given, obtain from fnd_global
1653 --
1654 -- Note
1655 -- returns NULL on failure
1656 --
1657 function get_QUEUE_APP_ID(request_id in number) return fnd_concurrent_requests.QUEUE_APP_ID%TYPE;
1658
1659
1660 --
1661 -- FUNCTION
1662 -- get_QUEUE_ID
1663 --
1664 -- Purpose
1665 -- get QUEUE_ID of a request based on request_id
1666 -- if request_id is not given, obtain from fnd_global
1667 --
1668 -- Note
1669 -- returns NULL on failure
1670 --
1671 function get_QUEUE_ID(request_id in number) return fnd_concurrent_requests.QUEUE_ID%TYPE;
1672
1673
1674 --
1675 -- FUNCTION
1676 -- get_OPS_INSTANCE
1677 --
1678 -- Purpose
1679 -- get OPS_INSTANCE of a request based on request_id
1680 -- if request_id is not given, obtain from fnd_global
1681 --
1682 -- Note
1683 -- returns NULL on failure
1684 --
1685 function get_OPS_INSTANCE(request_id in number) return fnd_concurrent_requests.OPS_INSTANCE%TYPE;
1686
1687
1688 --
1689 -- FUNCTION
1690 -- get_INTERIM_STATUS_CODE
1691 --
1692 -- Purpose
1693 -- get INTERIM_STATUS_CODE of a request based on request_id
1694 -- if request_id is not given, obtain from fnd_global
1695 --
1696 -- Note
1697 -- returns NULL on failure
1698 --
1699 function get_INTERIM_STATUS_CODE(request_id in number) return fnd_concurrent_requests.INTERIM_STATUS_CODE%TYPE;
1700
1701
1702 --
1703 -- FUNCTION
1704 -- get_ROOT_REQUEST_ID
1705 --
1706 -- Purpose
1707 -- get ROOT_REQUEST_ID of a request based on request_id
1708 -- if request_id is not given, obtain from fnd_global
1709 --
1710 -- Note
1711 -- returns NULL on failure
1712 --
1713 function get_ROOT_REQUEST_ID(request_id in number) return fnd_concurrent_requests.ROOT_REQUEST_ID%TYPE;
1714
1715
1716 --
1717 -- FUNCTION
1718 -- get_ORIGIN
1719 --
1720 -- Purpose
1721 -- get ORIGIN of a request based on request_id
1722 -- if request_id is not given, obtain from fnd_global
1723 --
1724 -- Note
1725 -- returns NULL on failure
1726 --
1727 function get_ORIGIN(request_id in number) return fnd_concurrent_requests.ORIGIN%TYPE;
1728
1729
1730 --
1731 -- FUNCTION
1732 -- get_NLS_NUMERIC_CHARACTERS
1733 --
1734 -- Purpose
1735 -- get NLS_NUMERIC_CHARACTERS of a request based on request_id
1736 -- if request_id is not given, obtain from fnd_global
1737 --
1738 -- Note
1739 -- returns NULL on failure
1740 --
1741 function get_NLS_NUMERIC_CHARACTERS(request_id in number) return fnd_concurrent_requests.NLS_NUMERIC_CHARACTERS%TYPE;
1742
1743
1744 --
1745 -- FUNCTION
1746 -- get_PP_START_DATE
1747 --
1748 -- Purpose
1749 -- get PP_START_DATE of a request based on request_id
1750 -- if request_id is not given, obtain from fnd_global
1751 --
1752 -- Note
1753 -- returns NULL on failure
1754 --
1755 function get_PP_START_DATE(request_id in number) return fnd_concurrent_requests.PP_START_DATE%TYPE;
1756
1757
1758 --
1759 -- FUNCTION
1760 -- get_PP_END_DATE
1761 --
1762 -- Purpose
1763 -- get PP_END_DATE of a request based on request_id
1764 -- if request_id is not given, obtain from fnd_global
1765 --
1766 -- Note
1767 -- returns NULL on failure
1768 --
1769 function get_PP_END_DATE(request_id in number) return fnd_concurrent_requests.PP_END_DATE%TYPE;
1770
1771
1772 end FND_CONC_REQ_DETAIL;