1 package body FND_CONC_REQ_DETAIL as
2 /* $Header: AFCPREQDB.pls 120.0.12010000.1 2009/04/10 17:40:41 tkamiya noship $ */
3
4 --
5 -- Private variables
6 --
7
8 request_rec fnd_concurrent_requests%ROWTYPE; -- represents entire row in fnd_concurrent_requests
9
10 -- ================================================
11 -- PRIVATE FUNCTIONS/PROCEDURES
12 -- ================================================
13
14 --
15 -- FUNCTION
16 -- get_all_req_detail_reqid
17 --
18 -- Purpose
19 -- get request detail based on request_id
20 -- if request_id is not given, get it from FND_GLOBAL
21 -- if request_id is unobtainable, exit FALSE
22 -- sets the global record for all columns of fnd_cocurrent_requests
23 --
24 -- Note
25 -- returns true/false
26 --
27 function get_all_req_detail_reqid(p_request_id in number) return boolean is
28 v_request_id number;
29 v_status boolean;
30
31 begin
32 --
33 -- if request_id is not given, find it in fnd_global
34 -- if that fails, return false and exit
35 --
36 if (p_request_id < 1 or p_request_id IS NULL) then
37 v_request_id := FND_GLOBAL.conc_request_id;
38 if (v_request_id < 1 or v_request_id IS NULL) then
39 return(FALSE);
40 end if;
41 else
42 v_request_id := p_request_id;
43 end if;
44
45 --
46 -- populate the entire row content into global variable
47 -- if sql fails, return false
48 --
49 request_rec := NULL;
50
51 select *
52 into request_rec
53 from FND_CONCURRENT_REQUESTS
54 where REQUEST_ID = v_request_id;
55
56 return(TRUE);
57
58 --
59 -- sql failed
60 -- returning... sorry!
61 --
62 exception
63 when others then
64 request_rec := NULL;
65 return(FALSE);
66
67 end get_all_req_detail_reqid;
68
69
70
71 -- ================================================
72 -- PUBLIC FUNCTIONS/PROCEDURES
73 -- ================================================
74
75 --
76 -- FUNCTION
77 -- get_ALL_REQUEST_INFO
78 --
79 -- Purpose
80 -- get all information of a request based on request_id
81 -- if request_id is not given, obtain from fnd_global
82 --
83 -- Note
84 -- returns NULL on failure
85 --
86 function get_ALL_REQUEST_INFO(request_id in number) return fnd_concurrent_requests%ROWTYPE is
87 v_status boolean;
88
89 begin
90 v_status := get_all_req_detail_reqid(request_id);
91 if (v_status = TRUE) then
92 return(request_rec);
93 else
94 return(NULL);
95 end if;
96
97 end get_ALL_REQUEST_INFO;
98
99
100 --
101 -- FUNCTION
102 -- get_REQUEST_ID
103 --
104 -- Purpose
105 -- get REQUEST_ID of a request based on request_id
106 -- if request_id is not given, obtain from fnd_global
107 --
108 -- Note
109 -- returns NULL on failure
110 --
111 function get_REQUEST_ID(request_id in number) return fnd_concurrent_requests.REQUEST_ID%TYPE is
112 v_status boolean;
113
114 begin
115 v_status := get_all_req_detail_reqid(request_id);
116 if (v_status = TRUE) then
117 return(request_rec.REQUEST_ID);
118 else
119 return(NULL);
120 end if;
121
122 end get_REQUEST_ID;
123
124
125 --
126 -- FUNCTION
127 -- get_LAST_UPDATE_DATE
128 --
129 -- Purpose
130 -- get LAST_UPDATE_DATE of a request based on request_id
131 -- if request_id is not given, obtain from fnd_global
132 --
133 -- Note
134 -- returns NULL on failure
135 --
136 function get_LAST_UPDATE_DATE(request_id in number) return fnd_concurrent_requests.LAST_UPDATE_DATE%TYPE is
137 v_status boolean;
138
139 begin
140 v_status := get_all_req_detail_reqid(request_id);
141 if (v_status = TRUE) then
142 return(request_rec.LAST_UPDATE_DATE);
143 else
144 return(NULL);
145 end if;
146
147 end get_LAST_UPDATE_DATE;
148
149
150 --
151 -- FUNCTION
152 -- get_LAST_UPDATED_BY
153 --
154 -- Purpose
155 -- get LAST_UPDATED_BY of a request based on request_id
156 -- if request_id is not given, obtain from fnd_global
157 --
158 -- Note
159 -- returns NULL on failure
160 --
161 function get_LAST_UPDATED_BY(request_id in number) return fnd_concurrent_requests.LAST_UPDATED_BY%TYPE is
162 v_status boolean;
163
164 begin
165 v_status := get_all_req_detail_reqid(request_id);
166 if (v_status = TRUE) then
167 return(request_rec.LAST_UPDATED_BY);
168 else
169 return(NULL);
170 end if;
171
172 end get_LAST_UPDATED_BY;
173
174
175 --
176 -- FUNCTION
177 -- get_REQUEST_DATE
178 --
179 -- Purpose
180 -- get REQUEST_DATE of a request based on request_id
181 -- if request_id is not given, obtain from fnd_global
182 --
183 -- Note
184 -- returns NULL on failure
185 --
186 function get_REQUEST_DATE(request_id in number) return fnd_concurrent_requests.REQUEST_DATE%TYPE is
187 v_status boolean;
188
189 begin
190 v_status := get_all_req_detail_reqid(request_id);
191 if (v_status = TRUE) then
192 return(request_rec.REQUEST_DATE);
193 else
194 return(NULL);
195 end if;
196
197 end get_REQUEST_DATE;
198
199
200 --
201 -- FUNCTION
202 -- get_REQUESTED_BY
203 --
204 -- Purpose
205 -- get REQUESTED_BY of a request based on request_id
206 -- if request_id is not given, obtain from fnd_global
207 --
208 -- Note
209 -- returns NULL on failure
210 --
211 function get_REQUESTED_BY(request_id in number) return fnd_concurrent_requests.REQUESTED_BY%TYPE is
212 v_status boolean;
213
214 begin
215 v_status := get_all_req_detail_reqid(request_id);
216 if (v_status = TRUE) then
217 return(request_rec.REQUESTED_BY);
218 else
219 return(NULL);
220 end if;
221
222 end get_REQUESTED_BY;
223
224
225 --
226 -- FUNCTION
227 -- get_PHASE_CODE
228 --
229 -- Purpose
230 -- get PHASE_CODE of a request based on request_id
231 -- if request_id is not given, obtain from fnd_global
232 --
233 -- Note
234 -- returns NULL on failure
235 --
236 function get_PHASE_CODE(request_id in number) return fnd_concurrent_requests.PHASE_CODE%TYPE is
237 v_status boolean;
238
239 begin
240 v_status := get_all_req_detail_reqid(request_id);
241 if (v_status = TRUE) then
242 return(request_rec.PHASE_CODE);
243 else
244 return(NULL);
245 end if;
246
247 end get_PHASE_CODE;
248
249
250 --
251 -- FUNCTION
252 -- get_STATUS_CODE
253 --
254 -- Purpose
255 -- get STATUS_CODE of a request based on request_id
256 -- if request_id is not given, obtain from fnd_global
257 --
258 -- Note
259 -- returns NULL on failure
260 --
261 function get_STATUS_CODE(request_id in number) return fnd_concurrent_requests.STATUS_CODE%TYPE is
262 v_status boolean;
263
264 begin
265 v_status := get_all_req_detail_reqid(request_id);
266 if (v_status = TRUE) then
267 return(request_rec.STATUS_CODE);
268 else
269 return(NULL);
270 end if;
271
272 end get_STATUS_CODE;
273
274
275 --
276 -- FUNCTION
277 -- get_PRIORITY_REQUEST_ID
278 --
279 -- Purpose
280 -- get PRIORITY_REQUEST_ID of a request based on request_id
281 -- if request_id is not given, obtain from fnd_global
282 --
283 -- Note
284 -- returns NULL on failure
285 --
286 function get_PRIORITY_REQUEST_ID(request_id in number) return fnd_concurrent_requests.PRIORITY_REQUEST_ID%TYPE is
287 v_status boolean;
288
289 begin
290 v_status := get_all_req_detail_reqid(request_id);
291 if (v_status = TRUE) then
292 return(request_rec.PRIORITY_REQUEST_ID);
293 else
294 return(NULL);
295 end if;
296
297 end get_PRIORITY_REQUEST_ID;
298
299
300 --
301 -- FUNCTION
302 -- get_PRIORITY
303 --
304 -- Purpose
305 -- get PRIORITY of a request based on request_id
306 -- if request_id is not given, obtain from fnd_global
307 --
308 -- Note
309 -- returns NULL on failure
310 --
311 function get_PRIORITY(request_id in number) return fnd_concurrent_requests.PRIORITY%TYPE is
312 v_status boolean;
313
314 begin
315 v_status := get_all_req_detail_reqid(request_id);
316 if (v_status = TRUE) then
317 return(request_rec.PRIORITY);
318 else
319 return(NULL);
320 end if;
321
322 end get_PRIORITY;
323
324
325 --
326 -- FUNCTION
327 -- get_REQUESTED_START_DATE
328 --
329 -- Purpose
330 -- get REQUESTED_START_DATE of a request based on request_id
331 -- if request_id is not given, obtain from fnd_global
332 --
333 -- Note
334 -- returns NULL on failure
335 --
336 function get_REQUESTED_START_DATE(request_id in number) return fnd_concurrent_requests.REQUESTED_START_DATE%TYPE is
337 v_status boolean;
338
339 begin
340 v_status := get_all_req_detail_reqid(request_id);
341 if (v_status = TRUE) then
342 return(request_rec.REQUESTED_START_DATE);
343 else
344 return(NULL);
345 end if;
346
347 end get_REQUESTED_START_DATE;
348
349
350 --
351 -- FUNCTION
352 -- get_HOLD_FLAG
353 --
354 -- Purpose
355 -- get HOLD_FLAG of a request based on request_id
356 -- if request_id is not given, obtain from fnd_global
357 --
358 -- Note
359 -- returns NULL on failure
360 --
361 function get_HOLD_FLAG(request_id in number) return fnd_concurrent_requests.HOLD_FLAG%TYPE is
362 v_status boolean;
363
364 begin
365 v_status := get_all_req_detail_reqid(request_id);
366 if (v_status = TRUE) then
367 return(request_rec.HOLD_FLAG);
368 else
369 return(NULL);
370 end if;
371
372 end get_HOLD_FLAG;
373
374
375 --
376 -- FUNCTION
377 -- get_ENFORCE_SERIALITY_FLAG
378 --
379 -- Purpose
380 -- get ENFORCE_SERIALITY_FLAG of a request based on request_id
381 -- if request_id is not given, obtain from fnd_global
382 --
383 -- Note
384 -- returns NULL on failure
385 --
386 function get_ENFORCE_SERIALITY_FLAG(request_id in number) return fnd_concurrent_requests.ENFORCE_SERIALITY_FLAG%TYPE is
387 v_status boolean;
388
389 begin
390 v_status := get_all_req_detail_reqid(request_id);
391 if (v_status = TRUE) then
392 return(request_rec.ENFORCE_SERIALITY_FLAG);
393 else
394 return(NULL);
395 end if;
396
397 end get_ENFORCE_SERIALITY_FLAG;
398
399
400 --
401 -- FUNCTION
402 -- get_SINGLE_THREAD_FLAG
403 --
404 -- Purpose
405 -- get SINGLE_THREAD_FLAG of a request based on request_id
406 -- if request_id is not given, obtain from fnd_global
407 --
408 -- Note
409 -- returns NULL on failure
410 --
411 function get_SINGLE_THREAD_FLAG(request_id in number) return fnd_concurrent_requests.SINGLE_THREAD_FLAG%TYPE is
412 v_status boolean;
413
414 begin
415 v_status := get_all_req_detail_reqid(request_id);
416 if (v_status = TRUE) then
417 return(request_rec.SINGLE_THREAD_FLAG);
418 else
419 return(NULL);
420 end if;
421
422 end get_SINGLE_THREAD_FLAG;
423
424
425 --
426 -- FUNCTION
427 -- get_HAS_SUB_REQUEST
428 --
429 -- Purpose
430 -- get HAS_SUB_REQUEST of a request based on request_id
431 -- if request_id is not given, obtain from fnd_global
432 --
433 -- Note
434 -- returns NULL on failure
435 --
436 function get_HAS_SUB_REQUEST(request_id in number) return fnd_concurrent_requests.HAS_SUB_REQUEST%TYPE is
437 v_status boolean;
438
439 begin
440 v_status := get_all_req_detail_reqid(request_id);
441 if (v_status = TRUE) then
442 return(request_rec.HAS_SUB_REQUEST);
443 else
444 return(NULL);
445 end if;
446
447 end get_HAS_SUB_REQUEST;
448
449
450 --
451 -- FUNCTION
452 -- get_IS_SUB_REQUEST
453 --
454 -- Purpose
455 -- get IS_SUB_REQUEST of a request based on request_id
456 -- if request_id is not given, obtain from fnd_global
457 --
458 -- Note
459 -- returns NULL on failure
460 --
461 function get_IS_SUB_REQUEST(request_id in number) return fnd_concurrent_requests.IS_SUB_REQUEST%TYPE is
462 v_status boolean;
463
464 begin
465 v_status := get_all_req_detail_reqid(request_id);
466 if (v_status = TRUE) then
467 return(request_rec.IS_SUB_REQUEST);
468 else
469 return(NULL);
470 end if;
471
472 end get_IS_SUB_REQUEST;
473
474
475 --
476 -- FUNCTION
477 -- get_IMPLICIT_CODE
478 --
479 -- Purpose
480 -- get IMPLICIT_CODE of a request based on request_id
481 -- if request_id is not given, obtain from fnd_global
482 --
483 -- Note
484 -- returns NULL on failure
485 --
486 function get_IMPLICIT_CODE(request_id in number) return fnd_concurrent_requests.IMPLICIT_CODE%TYPE is
487 v_status boolean;
488
489 begin
490 v_status := get_all_req_detail_reqid(request_id);
491 if (v_status = TRUE) then
492 return(request_rec.IMPLICIT_CODE);
493 else
494 return(NULL);
495 end if;
496
497 end get_IMPLICIT_CODE;
498
499
500 --
501 -- FUNCTION
502 -- get_UPDATE_PROTECTED
503 --
504 -- Purpose
505 -- get UPDATE_PROTECTED of a request based on request_id
506 -- if request_id is not given, obtain from fnd_global
507 --
508 -- Note
509 -- returns NULL on failure
510 --
511 function get_UPDATE_PROTECTED(request_id in number) return fnd_concurrent_requests.UPDATE_PROTECTED%TYPE is
512 v_status boolean;
513
514 begin
515 v_status := get_all_req_detail_reqid(request_id);
516 if (v_status = TRUE) then
517 return(request_rec.UPDATE_PROTECTED);
518 else
519 return(NULL);
520 end if;
521
522 end get_UPDATE_PROTECTED;
523
524
525 --
526 -- FUNCTION
527 -- get_QUEUE_METHOD_CODE
528 --
529 -- Purpose
530 -- get QUEUE_METHOD_CODE of a request based on request_id
531 -- if request_id is not given, obtain from fnd_global
532 --
533 -- Note
534 -- returns NULL on failure
535 --
536 function get_QUEUE_METHOD_CODE(request_id in number) return fnd_concurrent_requests.QUEUE_METHOD_CODE%TYPE is
537 v_status boolean;
538
539 begin
540 v_status := get_all_req_detail_reqid(request_id);
541 if (v_status = TRUE) then
542 return(request_rec.QUEUE_METHOD_CODE);
543 else
544 return(NULL);
545 end if;
546
547 end get_QUEUE_METHOD_CODE;
548
549
550 --
551 -- FUNCTION
552 -- get_ARGUMENT_INPUT_METHOD_CODE
553 --
554 -- Purpose
555 -- get ARGUMENT_INPUT_METHOD_CODE of a request based on request_id
556 -- if request_id is not given, obtain from fnd_global
557 --
558 -- Note
559 -- returns NULL on failure
560 --
561 function get_ARGUMENT_INPUT_METHOD_CODE(request_id in number) return fnd_concurrent_requests.ARGUMENT_INPUT_METHOD_CODE%TYPE is
562 v_status boolean;
563
564 begin
565 v_status := get_all_req_detail_reqid(request_id);
566 if (v_status = TRUE) then
567 return(request_rec.ARGUMENT_INPUT_METHOD_CODE);
568 else
569 return(NULL);
570 end if;
571
572 end get_ARGUMENT_INPUT_METHOD_CODE;
573
574
575 --
576 -- FUNCTION
577 -- get_ORACLE_ID
578 --
579 -- Purpose
580 -- get ORACLE_ID of a request based on request_id
581 -- if request_id is not given, obtain from fnd_global
582 --
583 -- Note
584 -- returns NULL on failure
585 --
586 function get_ORACLE_ID(request_id in number) return fnd_concurrent_requests.ORACLE_ID%TYPE is
587 v_status boolean;
588
589 begin
590 v_status := get_all_req_detail_reqid(request_id);
591 if (v_status = TRUE) then
592 return(request_rec.ORACLE_ID);
593 else
594 return(NULL);
595 end if;
596
597 end get_ORACLE_ID;
598
599
600 --
601 -- FUNCTION
602 -- get_PROGRAM_APPLICATION_ID
603 --
604 -- Purpose
605 -- get PROGRAM_APPLICATION_ID of a request based on request_id
606 -- if request_id is not given, obtain from fnd_global
607 --
608 -- Note
609 -- returns NULL on failure
610 --
611 function get_PROGRAM_APPLICATION_ID(request_id in number) return fnd_concurrent_requests.PROGRAM_APPLICATION_ID%TYPE is
612 v_status boolean;
613
614 begin
615 v_status := get_all_req_detail_reqid(request_id);
616 if (v_status = TRUE) then
617 return(request_rec.PROGRAM_APPLICATION_ID);
618 else
619 return(NULL);
620 end if;
621
622 end get_PROGRAM_APPLICATION_ID;
623
624
625 --
626 -- FUNCTION
627 -- get_CONCURRENT_PROGRAM_ID
628 --
629 -- Purpose
630 -- get CONCURRENT_PROGRAM_ID of a request based on request_id
631 -- if request_id is not given, obtain from fnd_global
632 --
633 -- Note
634 -- returns NULL on failure
635 --
636 function get_CONCURRENT_PROGRAM_ID(request_id in number) return fnd_concurrent_requests.CONCURRENT_PROGRAM_ID%TYPE is
637 v_status boolean;
638
639 begin
640 v_status := get_all_req_detail_reqid(request_id);
641 if (v_status = TRUE) then
642 return(request_rec.CONCURRENT_PROGRAM_ID);
643 else
644 return(NULL);
645 end if;
646
647 end get_CONCURRENT_PROGRAM_ID;
648
649
650 --
651 -- FUNCTION
652 -- get_RESPONSIB_APPLICATION_ID
653 --
654 -- Purpose
655 -- get RESPONSIBILITY_APPLICATION_ID of a request based on request_id
656 -- if request_id is not given, obtain from fnd_global
657 --
658 -- Note
659 -- returns NULL on failure
660 --
661 function get_RESPONSIB_APPLICATION_ID(request_id in number) return fnd_concurrent_requests.RESPONSIBILITY_APPLICATION_ID%TYPE is
662 v_status boolean;
663
664 begin
665 v_status := get_all_req_detail_reqid(request_id);
666 if (v_status = TRUE) then
667 return(request_rec.RESPONSIBILITY_APPLICATION_ID);
668 else
669 return(NULL);
670 end if;
671
672 end get_RESPONSIB_APPLICATION_ID;
673
674
675 --
676 -- FUNCTION
677 -- get_RESPONSIBILITY_ID
678 --
679 -- Purpose
680 -- get RESPONSIBILITY_ID of a request based on request_id
681 -- if request_id is not given, obtain from fnd_global
682 --
683 -- Note
684 -- returns NULL on failure
685 --
686 function get_RESPONSIBILITY_ID(request_id in number) return fnd_concurrent_requests.RESPONSIBILITY_ID%TYPE is
687 v_status boolean;
688
689 begin
690 v_status := get_all_req_detail_reqid(request_id);
691 if (v_status = TRUE) then
692 return(request_rec.RESPONSIBILITY_ID);
693 else
694 return(NULL);
695 end if;
696
697 end get_RESPONSIBILITY_ID;
698
699
700 --
701 -- FUNCTION
702 -- get_NUMBER_OF_ARGUMENTS
703 --
704 -- Purpose
705 -- get NUMBER_OF_ARGUMENTS of a request based on request_id
706 -- if request_id is not given, obtain from fnd_global
707 --
708 -- Note
709 -- returns NULL on failure
710 --
711 function get_NUMBER_OF_ARGUMENTS(request_id in number) return fnd_concurrent_requests.NUMBER_OF_ARGUMENTS%TYPE is
712 v_status boolean;
713
714 begin
715 v_status := get_all_req_detail_reqid(request_id);
716 if (v_status = TRUE) then
717 return(request_rec.NUMBER_OF_ARGUMENTS);
718 else
719 return(NULL);
720 end if;
721
722 end get_NUMBER_OF_ARGUMENTS;
723
724
725 --
726 -- FUNCTION
727 -- get_NUMBER_OF_COPIES
728 --
729 -- Purpose
730 -- get NUMBER_OF_COPIES of a request based on request_id
731 -- if request_id is not given, obtain from fnd_global
732 --
733 -- Note
734 -- returns NULL on failure
735 --
736 function get_NUMBER_OF_COPIES(request_id in number) return fnd_concurrent_requests.NUMBER_OF_COPIES%TYPE is
737 v_status boolean;
738
739 begin
740 v_status := get_all_req_detail_reqid(request_id);
741 if (v_status = TRUE) then
742 return(request_rec.NUMBER_OF_COPIES);
743 else
744 return(NULL);
745 end if;
746
747 end get_NUMBER_OF_COPIES;
748
749
750 --
751 -- FUNCTION
752 -- get_SAVE_OUTPUT_FLAG
753 --
754 -- Purpose
755 -- get SAVE_OUTPUT_FLAG 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_SAVE_OUTPUT_FLAG(request_id in number) return fnd_concurrent_requests.SAVE_OUTPUT_FLAG%TYPE is
762 v_status boolean;
763
764 begin
765 v_status := get_all_req_detail_reqid(request_id);
766 if (v_status = TRUE) then
767 return(request_rec.SAVE_OUTPUT_FLAG);
768 else
769 return(NULL);
770 end if;
771
772 end get_SAVE_OUTPUT_FLAG;
773
774
775 --
776 -- FUNCTION
777 -- get_NLS_COMPLIANT
778 --
779 -- Purpose
780 -- get NLS_COMPLIANT of a request based on request_id
781 -- if request_id is not given, obtain from fnd_global
782 --
783 -- Note
784 -- returns NULL on failure
785 --
786 function get_NLS_COMPLIANT(request_id in number) return fnd_concurrent_requests.NLS_COMPLIANT%TYPE is
787 v_status boolean;
788
789 begin
790 v_status := get_all_req_detail_reqid(request_id);
791 if (v_status = TRUE) then
792 return(request_rec.NLS_COMPLIANT);
793 else
794 return(NULL);
795 end if;
796
797 end get_NLS_COMPLIANT;
798
799
800 --
801 -- FUNCTION
802 -- get_LAST_UPDATE_LOGIN
803 --
804 -- Purpose
805 -- get LAST_UPDATE_LOGIN of a request based on request_id
806 -- if request_id is not given, obtain from fnd_global
810 --
807 --
808 -- Note
809 -- returns NULL on failure
811 function get_LAST_UPDATE_LOGIN(request_id in number) return fnd_concurrent_requests.LAST_UPDATE_LOGIN%TYPE is
812 v_status boolean;
813
814 begin
815 v_status := get_all_req_detail_reqid(request_id);
816 if (v_status = TRUE) then
817 return(request_rec.LAST_UPDATE_LOGIN);
818 else
819 return(NULL);
820 end if;
821
822 end get_LAST_UPDATE_LOGIN;
823
824
825 --
826 -- FUNCTION
827 -- get_NLS_LANGUAGE
828 --
829 -- Purpose
830 -- get NLS_LANGUAGE of a request based on request_id
831 -- if request_id is not given, obtain from fnd_global
832 --
833 -- Note
834 -- returns NULL on failure
835 --
836 function get_NLS_LANGUAGE(request_id in number) return fnd_concurrent_requests.NLS_LANGUAGE%TYPE is
837 v_status boolean;
838
839 begin
840 v_status := get_all_req_detail_reqid(request_id);
841 if (v_status = TRUE) then
842 return(request_rec.NLS_LANGUAGE);
843 else
844 return(NULL);
845 end if;
846
847 end get_NLS_LANGUAGE;
848
849
850 --
851 -- FUNCTION
852 -- get_NLS_TERRITORY
853 --
854 -- Purpose
855 -- get NLS_TERRITORY of a request based on request_id
856 -- if request_id is not given, obtain from fnd_global
857 --
858 -- Note
859 -- returns NULL on failure
860 --
861 function get_NLS_TERRITORY(request_id in number) return fnd_concurrent_requests.NLS_TERRITORY%TYPE is
862 v_status boolean;
863
864 begin
865 v_status := get_all_req_detail_reqid(request_id);
866 if (v_status = TRUE) then
867 return(request_rec.NLS_TERRITORY);
868 else
869 return(NULL);
870 end if;
871
872 end get_NLS_TERRITORY;
873
874
875 --
876 -- FUNCTION
877 -- get_PRINTER
878 --
879 -- Purpose
880 -- get PRINTER of a request based on request_id
881 -- if request_id is not given, obtain from fnd_global
882 --
883 -- Note
884 -- returns NULL on failure
885 --
886 function get_PRINTER(request_id in number) return fnd_concurrent_requests.PRINTER%TYPE is
887 v_status boolean;
888
889 begin
890 v_status := get_all_req_detail_reqid(request_id);
891 if (v_status = TRUE) then
892 return(request_rec.PRINTER);
893 else
894 return(NULL);
895 end if;
896
897 end get_PRINTER;
898
899
900 --
901 -- FUNCTION
902 -- get_PRINT_STYLE
903 --
904 -- Purpose
905 -- get PRINT_STYLE of a request based on request_id
906 -- if request_id is not given, obtain from fnd_global
907 --
908 -- Note
909 -- returns NULL on failure
910 --
911 function get_PRINT_STYLE(request_id in number) return fnd_concurrent_requests.PRINT_STYLE%TYPE is
912 v_status boolean;
913
914 begin
915 v_status := get_all_req_detail_reqid(request_id);
916 if (v_status = TRUE) then
917 return(request_rec.PRINT_STYLE);
918 else
919 return(NULL);
920 end if;
921
922 end get_PRINT_STYLE;
923
924
925 --
926 -- FUNCTION
927 -- get_PRINT_GROUP
928 --
929 -- Purpose
930 -- get PRINT_GROUP of a request based on request_id
931 -- if request_id is not given, obtain from fnd_global
932 --
933 -- Note
934 -- returns NULL on failure
935 --
936 function get_PRINT_GROUP(request_id in number) return fnd_concurrent_requests.PRINT_GROUP%TYPE is
937 v_status boolean;
938
939 begin
940 v_status := get_all_req_detail_reqid(request_id);
941 if (v_status = TRUE) then
942 return(request_rec.PRINT_GROUP);
943 else
944 return(NULL);
945 end if;
946
947 end get_PRINT_GROUP;
948
949
950 --
951 -- FUNCTION
952 -- get_REQ_CLASS_APPLICATION_ID
953 --
954 -- Purpose
955 -- get REQUEST_CLASS_APPLICATION_ID of a request based on request_id
956 -- if request_id is not given, obtain from fnd_global
957 --
958 -- Note
959 -- returns NULL on failure
960 --
961 function get_REQ_CLASS_APPLICATION_ID(request_id in number) return fnd_concurrent_requests.REQUEST_CLASS_APPLICATION_ID%TYPE is
962 v_status boolean;
963
964 begin
965 v_status := get_all_req_detail_reqid(request_id);
966 if (v_status = TRUE) then
967 return(request_rec.REQUEST_CLASS_APPLICATION_ID);
968 else
969 return(NULL);
970 end if;
971
972 end get_REQ_CLASS_APPLICATION_ID;
973
974
975 --
976 -- FUNCTION
977 -- get_CONC_REQUEST_CLASS_ID
978 --
979 -- Purpose
980 -- get CONCURRENT_REQUEST_CLASS_ID of a request based on request_id
981 -- if request_id is not given, obtain from fnd_global
982 --
983 -- Note
984 -- returns NULL on failure
985 --
986 function get_CONC_REQUEST_CLASS_ID(request_id in number) return fnd_concurrent_requests.CONCURRENT_REQUEST_CLASS_ID%TYPE is
987 v_status boolean;
988
989 begin
990 v_status := get_all_req_detail_reqid(request_id);
991 if (v_status = TRUE) then
992 return(request_rec.CONCURRENT_REQUEST_CLASS_ID);
993 else
994 return(NULL);
995 end if;
996
997 end get_CONC_REQUEST_CLASS_ID;
998
999
1000 --
1001 -- FUNCTION
1002 -- get_PARENT_REQUEST_ID
1003 --
1004 -- Purpose
1005 -- get PARENT_REQUEST_ID of a request based on request_id
1006 -- if request_id is not given, obtain from fnd_global
1007 --
1008 -- Note
1012 v_status boolean;
1009 -- returns NULL on failure
1010 --
1011 function get_PARENT_REQUEST_ID(request_id in number) return fnd_concurrent_requests.PARENT_REQUEST_ID%TYPE is
1013
1014 begin
1015 v_status := get_all_req_detail_reqid(request_id);
1016 if (v_status = TRUE) then
1017 return(request_rec.PARENT_REQUEST_ID);
1018 else
1019 return(NULL);
1020 end if;
1021
1022 end get_PARENT_REQUEST_ID;
1023
1024
1025 --
1026 -- FUNCTION
1027 -- get_CONC_LOGIN_ID
1028 --
1029 -- Purpose
1030 -- get CONC_LOGIN_ID of a request based on request_id
1031 -- if request_id is not given, obtain from fnd_global
1032 --
1033 -- Note
1034 -- returns NULL on failure
1035 --
1036 function get_CONC_LOGIN_ID(request_id in number) return fnd_concurrent_requests.CONC_LOGIN_ID%TYPE is
1037 v_status boolean;
1038
1039 begin
1040 v_status := get_all_req_detail_reqid(request_id);
1041 if (v_status = TRUE) then
1042 return(request_rec.CONC_LOGIN_ID);
1043 else
1044 return(NULL);
1045 end if;
1046
1047 end get_CONC_LOGIN_ID;
1048
1049
1050 --
1051 -- FUNCTION
1052 -- get_LANGUAGE_ID
1053 --
1054 -- Purpose
1055 -- get LANGUAGE_ID of a request based on request_id
1056 -- if request_id is not given, obtain from fnd_global
1057 --
1058 -- Note
1059 -- returns NULL on failure
1060 --
1061 function get_LANGUAGE_ID(request_id in number) return fnd_concurrent_requests.LANGUAGE_ID%TYPE is
1062 v_status boolean;
1063
1064 begin
1065 v_status := get_all_req_detail_reqid(request_id);
1066 if (v_status = TRUE) then
1067 return(request_rec.LANGUAGE_ID);
1068 else
1069 return(NULL);
1070 end if;
1071
1072 end get_LANGUAGE_ID;
1073
1074
1075 --
1076 -- FUNCTION
1077 -- get_DESCRIPTION
1078 --
1079 -- Purpose
1080 -- get DESCRIPTION of a request based on request_id
1081 -- if request_id is not given, obtain from fnd_global
1082 --
1083 -- Note
1084 -- returns NULL on failure
1085 --
1086 function get_DESCRIPTION(request_id in number) return fnd_concurrent_requests.DESCRIPTION%TYPE is
1087 v_status boolean;
1088
1089 begin
1090 v_status := get_all_req_detail_reqid(request_id);
1091 if (v_status = TRUE) then
1092 return(request_rec.DESCRIPTION);
1093 else
1094 return(NULL);
1095 end if;
1096
1097 end get_DESCRIPTION;
1098
1099
1100 --
1101 -- FUNCTION
1102 -- get_REQ_INFORMATION
1103 --
1104 -- Purpose
1105 -- get REQ_INFORMATION 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_REQ_INFORMATION(request_id in number) return fnd_concurrent_requests.REQ_INFORMATION%TYPE is
1112 v_status boolean;
1113
1114 begin
1115 v_status := get_all_req_detail_reqid(request_id);
1116 if (v_status = TRUE) then
1117 return(request_rec.REQ_INFORMATION);
1118 else
1119 return(NULL);
1120 end if;
1121
1122 end get_REQ_INFORMATION;
1123
1124
1125 --
1126 -- FUNCTION
1127 -- get_RESUBMIT_INTERVAL
1128 --
1129 -- Purpose
1130 -- get RESUBMIT_INTERVAL of a request based on request_id
1131 -- if request_id is not given, obtain from fnd_global
1132 --
1133 -- Note
1134 -- returns NULL on failure
1135 --
1136 function get_RESUBMIT_INTERVAL(request_id in number) return fnd_concurrent_requests.RESUBMIT_INTERVAL%TYPE is
1137 v_status boolean;
1138
1139 begin
1140 v_status := get_all_req_detail_reqid(request_id);
1141 if (v_status = TRUE) then
1142 return(request_rec.RESUBMIT_INTERVAL);
1143 else
1144 return(NULL);
1145 end if;
1146
1147 end get_RESUBMIT_INTERVAL;
1148
1149
1150 --
1151 -- FUNCTION
1152 -- get_RESUB_INTERVAL_UNIT_CODE
1153 --
1154 -- Purpose
1155 -- get RESUBMIT_INTERVAL_UNIT_CODE of a request based on request_id
1156 -- if request_id is not given, obtain from fnd_global
1157 --
1158 -- Note
1159 -- returns NULL on failure
1160 --
1161 function get_RESUB_INTERVAL_UNIT_CODE(request_id in number) return fnd_concurrent_requests.RESUBMIT_INTERVAL_UNIT_CODE%TYPE is
1162 v_status boolean;
1163
1164 begin
1165 v_status := get_all_req_detail_reqid(request_id);
1166 if (v_status = TRUE) then
1167 return(request_rec.RESUBMIT_INTERVAL_UNIT_CODE);
1168 else
1169 return(NULL);
1170 end if;
1171
1172 end get_RESUB_INTERVAL_UNIT_CODE;
1173
1174
1175 --
1176 -- FUNCTION
1177 -- get_RESUB_INTERVAL_TYPE_CODE
1178 --
1179 -- Purpose
1180 -- get RESUBMIT_INTERVAL_TYPE_CODE of a request based on request_id
1181 -- if request_id is not given, obtain from fnd_global
1182 --
1183 -- Note
1184 -- returns NULL on failure
1185 --
1186 function get_RESUB_INTERVAL_TYPE_CODE(request_id in number) return fnd_concurrent_requests.RESUBMIT_INTERVAL_TYPE_CODE%TYPE is
1187 v_status boolean;
1188
1189 begin
1190 v_status := get_all_req_detail_reqid(request_id);
1191 if (v_status = TRUE) then
1192 return(request_rec.RESUBMIT_INTERVAL_TYPE_CODE);
1193 else
1194 return(NULL);
1195 end if;
1196
1197 end get_RESUB_INTERVAL_TYPE_CODE;
1198
1199
1200 --
1201 -- FUNCTION
1202 -- get_RESUBMIT_TIME
1203 --
1204 -- Purpose
1205 -- get RESUBMIT_TIME of a request based on request_id
1206 -- if request_id is not given, obtain from fnd_global
1207 --
1211 function get_RESUBMIT_TIME(request_id in number) return fnd_concurrent_requests.RESUBMIT_TIME%TYPE is
1208 -- Note
1209 -- returns NULL on failure
1210 --
1212 v_status boolean;
1213
1214 begin
1215 v_status := get_all_req_detail_reqid(request_id);
1216 if (v_status = TRUE) then
1217 return(request_rec.RESUBMIT_TIME);
1218 else
1219 return(NULL);
1220 end if;
1221
1222 end get_RESUBMIT_TIME;
1223
1224
1225 --
1226 -- FUNCTION
1227 -- get_RESUBMIT_END_DATE
1228 --
1229 -- Purpose
1230 -- get RESUBMIT_END_DATE of a request based on request_id
1231 -- if request_id is not given, obtain from fnd_global
1232 --
1233 -- Note
1234 -- returns NULL on failure
1235 --
1236 function get_RESUBMIT_END_DATE(request_id in number) return fnd_concurrent_requests.RESUBMIT_END_DATE%TYPE is
1237 v_status boolean;
1238
1239 begin
1240 v_status := get_all_req_detail_reqid(request_id);
1241 if (v_status = TRUE) then
1242 return(request_rec.RESUBMIT_END_DATE);
1243 else
1244 return(NULL);
1245 end if;
1246
1247 end get_RESUBMIT_END_DATE;
1248
1249
1250 --
1251 -- FUNCTION
1252 -- get_RESUBMITTED
1253 --
1254 -- Purpose
1255 -- get RESUBMITTED of a request based on request_id
1256 -- if request_id is not given, obtain from fnd_global
1257 --
1258 -- Note
1259 -- returns NULL on failure
1260 --
1261 function get_RESUBMITTED(request_id in number) return fnd_concurrent_requests.RESUBMITTED%TYPE is
1262 v_status boolean;
1263
1264 begin
1265 v_status := get_all_req_detail_reqid(request_id);
1266 if (v_status = TRUE) then
1267 return(request_rec.RESUBMITTED);
1268 else
1269 return(NULL);
1270 end if;
1271
1272 end get_RESUBMITTED;
1273
1274
1275 --
1276 -- FUNCTION
1277 -- get_CONTROLLING_MANAGER
1278 --
1279 -- Purpose
1280 -- get CONTROLLING_MANAGER of a request based on request_id
1281 -- if request_id is not given, obtain from fnd_global
1282 --
1283 -- Note
1284 -- returns NULL on failure
1285 --
1286 function get_CONTROLLING_MANAGER(request_id in number) return fnd_concurrent_requests.CONTROLLING_MANAGER%TYPE is
1287 v_status boolean;
1288
1289 begin
1290 v_status := get_all_req_detail_reqid(request_id);
1291 if (v_status = TRUE) then
1292 return(request_rec.CONTROLLING_MANAGER);
1293 else
1294 return(NULL);
1295 end if;
1296
1297 end get_CONTROLLING_MANAGER;
1298
1299
1300 --
1301 -- FUNCTION
1302 -- get_ACTUAL_START_DATE
1303 --
1304 -- Purpose
1305 -- get ACTUAL_START_DATE of a request based on request_id
1306 -- if request_id is not given, obtain from fnd_global
1307 --
1308 -- Note
1309 -- returns NULL on failure
1310 --
1311 function get_ACTUAL_START_DATE(request_id in number) return fnd_concurrent_requests.ACTUAL_START_DATE%TYPE is
1312 v_status boolean;
1313
1314 begin
1315 v_status := get_all_req_detail_reqid(request_id);
1316 if (v_status = TRUE) then
1317 return(request_rec.ACTUAL_START_DATE);
1318 else
1319 return(NULL);
1320 end if;
1321
1322 end get_ACTUAL_START_DATE;
1323
1324
1325 --
1326 -- FUNCTION
1327 -- get_ACTUAL_COMPLETION_DATE
1328 --
1329 -- Purpose
1330 -- get ACTUAL_COMPLETION_DATE of a request based on request_id
1331 -- if request_id is not given, obtain from fnd_global
1332 --
1333 -- Note
1334 -- returns NULL on failure
1335 --
1336 function get_ACTUAL_COMPLETION_DATE(request_id in number) return fnd_concurrent_requests.ACTUAL_COMPLETION_DATE%TYPE is
1337 v_status boolean;
1338
1339 begin
1340 v_status := get_all_req_detail_reqid(request_id);
1341 if (v_status = TRUE) then
1342 return(request_rec.ACTUAL_COMPLETION_DATE);
1343 else
1344 return(NULL);
1345 end if;
1346
1347 end get_ACTUAL_COMPLETION_DATE;
1348
1349
1350 --
1351 -- FUNCTION
1352 -- get_COMPLETION_TEXT
1353 --
1354 -- Purpose
1355 -- get COMPLETION_TEXT of a request based on request_id
1356 -- if request_id is not given, obtain from fnd_global
1357 --
1358 -- Note
1359 -- returns NULL on failure
1360 --
1361 function get_COMPLETION_TEXT(request_id in number) return fnd_concurrent_requests.COMPLETION_TEXT%TYPE is
1362 v_status boolean;
1363
1364 begin
1365 v_status := get_all_req_detail_reqid(request_id);
1366 if (v_status = TRUE) then
1367 return(request_rec.COMPLETION_TEXT);
1368 else
1369 return(NULL);
1370 end if;
1371
1372 end get_COMPLETION_TEXT;
1373
1374
1375 --
1376 -- FUNCTION
1377 -- get_OUTCOME_PRODUCT
1378 --
1379 -- Purpose
1380 -- get OUTCOME_PRODUCT of a request based on request_id
1381 -- if request_id is not given, obtain from fnd_global
1382 --
1383 -- Note
1384 -- returns NULL on failure
1385 --
1386 function get_OUTCOME_PRODUCT(request_id in number) return fnd_concurrent_requests.OUTCOME_PRODUCT%TYPE is
1387 v_status boolean;
1388
1389 begin
1390 v_status := get_all_req_detail_reqid(request_id);
1391 if (v_status = TRUE) then
1392 return(request_rec.OUTCOME_PRODUCT);
1393 else
1394 return(NULL);
1395 end if;
1396
1397 end get_OUTCOME_PRODUCT;
1398
1399
1400 --
1401 -- FUNCTION
1402 -- get_OUTCOME_CODE
1403 --
1404 -- Purpose
1405 -- get OUTCOME_CODE of a request based on request_id
1406 -- if request_id is not given, obtain from fnd_global
1407 --
1411 function get_OUTCOME_CODE(request_id in number) return fnd_concurrent_requests.OUTCOME_CODE%TYPE is
1408 -- Note
1409 -- returns NULL on failure
1410 --
1412 v_status boolean;
1413
1414 begin
1415 v_status := get_all_req_detail_reqid(request_id);
1416 if (v_status = TRUE) then
1417 return(request_rec.OUTCOME_CODE);
1418 else
1419 return(NULL);
1420 end if;
1421
1425 --
1422 end get_OUTCOME_CODE;
1423
1424
1426 -- FUNCTION
1427 -- get_CPU_SECONDS
1428 --
1429 -- Purpose
1430 -- get CPU_SECONDS of a request based on request_id
1431 -- if request_id is not given, obtain from fnd_global
1432 --
1433 -- Note
1434 -- returns NULL on failure
1435 --
1436 function get_CPU_SECONDS(request_id in number) return fnd_concurrent_requests.CPU_SECONDS%TYPE is
1437 v_status boolean;
1438
1439 begin
1440 v_status := get_all_req_detail_reqid(request_id);
1441 if (v_status = TRUE) then
1442 return(request_rec.CPU_SECONDS);
1443 else
1444 return(NULL);
1445 end if;
1446
1447 end get_CPU_SECONDS;
1448
1449
1450 --
1451 -- FUNCTION
1452 -- get_LOGICAL_IOS
1453 --
1454 -- Purpose
1455 -- get LOGICAL_IOS 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_LOGICAL_IOS(request_id in number) return fnd_concurrent_requests.LOGICAL_IOS%TYPE is
1462 v_status boolean;
1463
1464 begin
1465 v_status := get_all_req_detail_reqid(request_id);
1466 if (v_status = TRUE) then
1467 return(request_rec.LOGICAL_IOS);
1468 else
1469 return(NULL);
1470 end if;
1471
1472 end get_LOGICAL_IOS;
1473
1474
1475 --
1476 -- FUNCTION
1477 -- get_PHYSICAL_IOS
1478 --
1479 -- Purpose
1480 -- get PHYSICAL_IOS of a request based on request_id
1481 -- if request_id is not given, obtain from fnd_global
1482 --
1483 -- Note
1484 -- returns NULL on failure
1485 --
1486 function get_PHYSICAL_IOS(request_id in number) return fnd_concurrent_requests.PHYSICAL_IOS%TYPE is
1487 v_status boolean;
1488
1489 begin
1490 v_status := get_all_req_detail_reqid(request_id);
1491 if (v_status = TRUE) then
1492 return(request_rec.PHYSICAL_IOS);
1493 else
1494 return(NULL);
1495 end if;
1496
1497 end get_PHYSICAL_IOS;
1498
1499
1500 --
1501 -- FUNCTION
1502 -- get_LOGFILE_NAME
1503 --
1504 -- Purpose
1505 -- get LOGFILE_NAME of a request based on request_id
1506 -- if request_id is not given, obtain from fnd_global
1507 --
1508 -- Note
1509 -- returns NULL on failure
1510 --
1511 function get_LOGFILE_NAME(request_id in number) return fnd_concurrent_requests.LOGFILE_NAME%TYPE is
1512 v_status boolean;
1513
1514 begin
1515 v_status := get_all_req_detail_reqid(request_id);
1516 if (v_status = TRUE) then
1517 return(request_rec.LOGFILE_NAME);
1518 else
1519 return(NULL);
1520 end if;
1521
1522 end get_LOGFILE_NAME;
1523
1524
1525 --
1526 -- FUNCTION
1527 -- get_LOGFILE_NODE_NAME
1528 --
1529 -- Purpose
1530 -- get LOGFILE_NODE_NAME of a request based on request_id
1531 -- if request_id is not given, obtain from fnd_global
1532 --
1533 -- Note
1534 -- returns NULL on failure
1535 --
1536 function get_LOGFILE_NODE_NAME(request_id in number) return fnd_concurrent_requests.LOGFILE_NODE_NAME%TYPE is
1537 v_status boolean;
1538
1539 begin
1540 v_status := get_all_req_detail_reqid(request_id);
1541 if (v_status = TRUE) then
1542 return(request_rec.LOGFILE_NODE_NAME);
1543 else
1544 return(NULL);
1545 end if;
1546
1547 end get_LOGFILE_NODE_NAME;
1548
1549
1550 --
1551 -- FUNCTION
1552 -- get_OUTFILE_NAME
1553 --
1554 -- Purpose
1555 -- get OUTFILE_NAME of a request based on request_id
1556 -- if request_id is not given, obtain from fnd_global
1557 --
1558 -- Note
1559 -- returns NULL on failure
1560 --
1561 function get_OUTFILE_NAME(request_id in number) return fnd_concurrent_requests.OUTFILE_NAME%TYPE is
1562 v_status boolean;
1563
1564 begin
1565 v_status := get_all_req_detail_reqid(request_id);
1566 if (v_status = TRUE) then
1567 return(request_rec.OUTFILE_NAME);
1568 else
1569 return(NULL);
1570 end if;
1571
1572 end get_OUTFILE_NAME;
1573
1574
1575 --
1576 -- FUNCTION
1577 -- get_OUTFILE_NODE_NAME
1578 --
1582 --
1579 -- Purpose
1580 -- get OUTFILE_NODE_NAME of a request based on request_id
1581 -- if request_id is not given, obtain from fnd_global
1583 -- Note
1584 -- returns NULL on failure
1585 --
1586 function get_OUTFILE_NODE_NAME(request_id in number) return fnd_concurrent_requests.OUTFILE_NODE_NAME%TYPE is
1587 v_status boolean;
1588
1589 begin
1590 v_status := get_all_req_detail_reqid(request_id);
1591 if (v_status = TRUE) then
1592 return(request_rec.OUTFILE_NODE_NAME);
1593 else
1594 return(NULL);
1595 end if;
1596
1597 end get_OUTFILE_NODE_NAME;
1598
1599
1600 --
1601 -- FUNCTION
1602 -- get_ARGUMENT_TEXT
1603 --
1604 -- Purpose
1605 -- get ARGUMENT_TEXT of a request based on request_id
1606 -- if request_id is not given, obtain from fnd_global
1607 --
1608 -- Note
1609 -- returns NULL on failure
1610 --
1611 function get_ARGUMENT_TEXT(request_id in number) return fnd_concurrent_requests.ARGUMENT_TEXT%TYPE is
1612 v_status boolean;
1613
1614 begin
1615 v_status := get_all_req_detail_reqid(request_id);
1616 if (v_status = TRUE) then
1617 return(request_rec.ARGUMENT_TEXT);
1618 else
1619 return(NULL);
1620 end if;
1621
1622 end get_ARGUMENT_TEXT;
1623
1624
1625 --
1626 -- FUNCTION
1627 -- get_ARGUMENT1
1628 --
1629 -- Purpose
1630 -- get ARGUMENT1 of a request based on request_id
1631 -- if request_id is not given, obtain from fnd_global
1632 --
1633 -- Note
1634 -- returns NULL on failure
1635 --
1636 function get_ARGUMENT1(request_id in number) return fnd_concurrent_requests.ARGUMENT1%TYPE is
1637 v_status boolean;
1638
1639 begin
1640 v_status := get_all_req_detail_reqid(request_id);
1641 if (v_status = TRUE) then
1642 return(request_rec.ARGUMENT1);
1643 else
1644 return(NULL);
1645 end if;
1646
1647 end get_ARGUMENT1;
1648
1649
1650 --
1651 -- FUNCTION
1652 -- get_ARGUMENT2
1653 --
1654 -- Purpose
1655 -- get ARGUMENT2 of a request based on request_id
1656 -- if request_id is not given, obtain from fnd_global
1657 --
1658 -- Note
1659 -- returns NULL on failure
1660 --
1661 function get_ARGUMENT2(request_id in number) return fnd_concurrent_requests.ARGUMENT2%TYPE is
1662 v_status boolean;
1663
1664 begin
1665 v_status := get_all_req_detail_reqid(request_id);
1666 if (v_status = TRUE) then
1667 return(request_rec.ARGUMENT2);
1668 else
1669 return(NULL);
1670 end if;
1671
1672 end get_ARGUMENT2;
1673
1674
1675 --
1676 -- FUNCTION
1677 -- get_ARGUMENT3
1678 --
1679 -- Purpose
1680 -- get ARGUMENT3 of a request based on request_id
1681 -- if request_id is not given, obtain from fnd_global
1682 --
1683 -- Note
1684 -- returns NULL on failure
1685 --
1686 function get_ARGUMENT3(request_id in number) return fnd_concurrent_requests.ARGUMENT3%TYPE is
1687 v_status boolean;
1688
1689 begin
1690 v_status := get_all_req_detail_reqid(request_id);
1691 if (v_status = TRUE) then
1692 return(request_rec.ARGUMENT3);
1693 else
1694 return(NULL);
1695 end if;
1696
1697 end get_ARGUMENT3;
1698
1699
1700 --
1701 -- FUNCTION
1702 -- get_ARGUMENT4
1703 --
1704 -- Purpose
1705 -- get ARGUMENT4 of a request based on request_id
1706 -- if request_id is not given, obtain from fnd_global
1707 --
1708 -- Note
1709 -- returns NULL on failure
1710 --
1711 function get_ARGUMENT4(request_id in number) return fnd_concurrent_requests.ARGUMENT4%TYPE is
1712 v_status boolean;
1713
1714 begin
1715 v_status := get_all_req_detail_reqid(request_id);
1716 if (v_status = TRUE) then
1717 return(request_rec.ARGUMENT4);
1718 else
1719 return(NULL);
1720 end if;
1721
1722 end get_ARGUMENT4;
1723
1724
1725 --
1726 -- FUNCTION
1727 -- get_ARGUMENT5
1728 --
1729 -- Purpose
1730 -- get ARGUMENT5 of a request based on request_id
1731 -- if request_id is not given, obtain from fnd_global
1732 --
1733 -- Note
1734 -- returns NULL on failure
1735 --
1736 function get_ARGUMENT5(request_id in number) return fnd_concurrent_requests.ARGUMENT5%TYPE is
1737 v_status boolean;
1738
1739 begin
1740 v_status := get_all_req_detail_reqid(request_id);
1741 if (v_status = TRUE) then
1742 return(request_rec.ARGUMENT5);
1743 else
1744 return(NULL);
1745 end if;
1746
1747 end get_ARGUMENT5;
1748
1749
1750 --
1751 -- FUNCTION
1752 -- get_ARGUMENT6
1753 --
1754 -- Purpose
1755 -- get ARGUMENT6 of a request based on request_id
1756 -- if request_id is not given, obtain from fnd_global
1757 --
1758 -- Note
1759 -- returns NULL on failure
1760 --
1761 function get_ARGUMENT6(request_id in number) return fnd_concurrent_requests.ARGUMENT6%TYPE is
1762 v_status boolean;
1763
1764 begin
1768 else
1765 v_status := get_all_req_detail_reqid(request_id);
1766 if (v_status = TRUE) then
1767 return(request_rec.ARGUMENT6);
1769 return(NULL);
1770 end if;
1771
1772 end get_ARGUMENT6;
1773
1774
1775 --
1776 -- FUNCTION
1777 -- get_ARGUMENT7
1778 --
1779 -- Purpose
1780 -- get ARGUMENT7 of a request based on request_id
1781 -- if request_id is not given, obtain from fnd_global
1782 --
1783 -- Note
1784 -- returns NULL on failure
1785 --
1786 function get_ARGUMENT7(request_id in number) return fnd_concurrent_requests.ARGUMENT7%TYPE is
1787 v_status boolean;
1788
1789 begin
1790 v_status := get_all_req_detail_reqid(request_id);
1791 if (v_status = TRUE) then
1792 return(request_rec.ARGUMENT7);
1793 else
1794 return(NULL);
1795 end if;
1796
1797 end get_ARGUMENT7;
1798
1799
1800 --
1801 -- FUNCTION
1802 -- get_ARGUMENT8
1803 --
1804 -- Purpose
1805 -- get ARGUMENT8 of a request based on request_id
1806 -- if request_id is not given, obtain from fnd_global
1807 --
1808 -- Note
1809 -- returns NULL on failure
1810 --
1811 function get_ARGUMENT8(request_id in number) return fnd_concurrent_requests.ARGUMENT8%TYPE is
1812 v_status boolean;
1813
1814 begin
1815 v_status := get_all_req_detail_reqid(request_id);
1816 if (v_status = TRUE) then
1817 return(request_rec.ARGUMENT8);
1818 else
1819 return(NULL);
1820 end if;
1821
1822 end get_ARGUMENT8;
1823
1824
1825 --
1826 -- FUNCTION
1827 -- get_ARGUMENT9
1828 --
1829 -- Purpose
1830 -- get ARGUMENT9 of a request based on request_id
1831 -- if request_id is not given, obtain from fnd_global
1832 --
1833 -- Note
1834 -- returns NULL on failure
1835 --
1836 function get_ARGUMENT9(request_id in number) return fnd_concurrent_requests.ARGUMENT9%TYPE is
1837 v_status boolean;
1838
1839 begin
1840 v_status := get_all_req_detail_reqid(request_id);
1841 if (v_status = TRUE) then
1842 return(request_rec.ARGUMENT9);
1843 else
1844 return(NULL);
1845 end if;
1846
1847 end get_ARGUMENT9;
1848
1849
1850 --
1851 -- FUNCTION
1852 -- get_ARGUMENT10
1853 --
1854 -- Purpose
1855 -- get ARGUMENT10 of a request based on request_id
1856 -- if request_id is not given, obtain from fnd_global
1857 --
1858 -- Note
1859 -- returns NULL on failure
1860 --
1861 function get_ARGUMENT10(request_id in number) return fnd_concurrent_requests.ARGUMENT10%TYPE is
1862 v_status boolean;
1863
1864 begin
1865 v_status := get_all_req_detail_reqid(request_id);
1866 if (v_status = TRUE) then
1867 return(request_rec.ARGUMENT10);
1868 else
1869 return(NULL);
1870 end if;
1871
1872 end get_ARGUMENT10;
1873
1874
1875 --
1876 -- FUNCTION
1877 -- get_ARGUMENT11
1878 --
1879 -- Purpose
1880 -- get ARGUMENT11 of a request based on request_id
1881 -- if request_id is not given, obtain from fnd_global
1882 --
1883 -- Note
1884 -- returns NULL on failure
1885 --
1886 function get_ARGUMENT11(request_id in number) return fnd_concurrent_requests.ARGUMENT11%TYPE is
1887 v_status boolean;
1888
1889 begin
1890 v_status := get_all_req_detail_reqid(request_id);
1891 if (v_status = TRUE) then
1892 return(request_rec.ARGUMENT11);
1893 else
1894 return(NULL);
1895 end if;
1896
1897 end get_ARGUMENT11;
1898
1899
1900 --
1901 -- FUNCTION
1902 -- get_ARGUMENT12
1903 --
1904 -- Purpose
1905 -- get ARGUMENT12 of a request based on request_id
1906 -- if request_id is not given, obtain from fnd_global
1907 --
1908 -- Note
1909 -- returns NULL on failure
1910 --
1911 function get_ARGUMENT12(request_id in number) return fnd_concurrent_requests.ARGUMENT12%TYPE is
1912 v_status boolean;
1913
1914 begin
1915 v_status := get_all_req_detail_reqid(request_id);
1916 if (v_status = TRUE) then
1917 return(request_rec.ARGUMENT12);
1918 else
1919 return(NULL);
1920 end if;
1921
1922 end get_ARGUMENT12;
1923
1924
1925 --
1926 -- FUNCTION
1927 -- get_ARGUMENT13
1928 --
1929 -- Purpose
1930 -- get ARGUMENT13 of a request based on request_id
1931 -- if request_id is not given, obtain from fnd_global
1932 --
1933 -- Note
1934 -- returns NULL on failure
1935 --
1936 function get_ARGUMENT13(request_id in number) return fnd_concurrent_requests.ARGUMENT13%TYPE is
1937 v_status boolean;
1938
1939 begin
1940 v_status := get_all_req_detail_reqid(request_id);
1941 if (v_status = TRUE) then
1942 return(request_rec.ARGUMENT13);
1943 else
1944 return(NULL);
1945 end if;
1946
1947 end get_ARGUMENT13;
1948
1949
1950 --
1951 -- FUNCTION
1952 -- get_ARGUMENT14
1953 --
1954 -- Purpose
1955 -- get ARGUMENT14 of a request based on request_id
1956 -- if request_id is not given, obtain from fnd_global
1957 --
1958 -- Note
1959 -- returns NULL on failure
1960 --
1961 function get_ARGUMENT14(request_id in number) return fnd_concurrent_requests.ARGUMENT14%TYPE is
1962 v_status boolean;
1963
1964 begin
1965 v_status := get_all_req_detail_reqid(request_id);
1966 if (v_status = TRUE) then
1967 return(request_rec.ARGUMENT14);
1968 else
1969 return(NULL);
1970 end if;
1971
1972 end get_ARGUMENT14;
1973
1974
1978 --
1975 --
1976 -- FUNCTION
1977 -- get_ARGUMENT15
1979 -- Purpose
1980 -- get ARGUMENT15 of a request based on request_id
1981 -- if request_id is not given, obtain from fnd_global
1982 --
1983 -- Note
1984 -- returns NULL on failure
1985 --
1986 function get_ARGUMENT15(request_id in number) return fnd_concurrent_requests.ARGUMENT15%TYPE is
1987 v_status boolean;
1988
1989 begin
1990 v_status := get_all_req_detail_reqid(request_id);
1991 if (v_status = TRUE) then
1992 return(request_rec.ARGUMENT15);
1993 else
1994 return(NULL);
1995 end if;
1996
1997 end get_ARGUMENT15;
1998
1999
2000 --
2001 -- FUNCTION
2002 -- get_ARGUMENT16
2003 --
2004 -- Purpose
2005 -- get ARGUMENT16 of a request based on request_id
2006 -- if request_id is not given, obtain from fnd_global
2007 --
2008 -- Note
2009 -- returns NULL on failure
2010 --
2011 function get_ARGUMENT16(request_id in number) return fnd_concurrent_requests.ARGUMENT16%TYPE is
2012 v_status boolean;
2013
2014 begin
2015 v_status := get_all_req_detail_reqid(request_id);
2016 if (v_status = TRUE) then
2017 return(request_rec.ARGUMENT16);
2018 else
2019 return(NULL);
2020 end if;
2021
2022 end get_ARGUMENT16;
2023
2024
2025 --
2026 -- FUNCTION
2027 -- get_ARGUMENT17
2028 --
2029 -- Purpose
2030 -- get ARGUMENT17 of a request based on request_id
2031 -- if request_id is not given, obtain from fnd_global
2032 --
2033 -- Note
2034 -- returns NULL on failure
2035 --
2036 function get_ARGUMENT17(request_id in number) return fnd_concurrent_requests.ARGUMENT17%TYPE is
2037 v_status boolean;
2038
2039 begin
2040 v_status := get_all_req_detail_reqid(request_id);
2041 if (v_status = TRUE) then
2042 return(request_rec.ARGUMENT17);
2043 else
2044 return(NULL);
2045 end if;
2046
2047 end get_ARGUMENT17;
2048
2049
2050 --
2051 -- FUNCTION
2052 -- get_ARGUMENT18
2053 --
2054 -- Purpose
2055 -- get ARGUMENT18 of a request based on request_id
2056 -- if request_id is not given, obtain from fnd_global
2057 --
2058 -- Note
2059 -- returns NULL on failure
2060 --
2061 function get_ARGUMENT18(request_id in number) return fnd_concurrent_requests.ARGUMENT18%TYPE is
2062 v_status boolean;
2063
2064 begin
2065 v_status := get_all_req_detail_reqid(request_id);
2066 if (v_status = TRUE) then
2067 return(request_rec.ARGUMENT18);
2068 else
2069 return(NULL);
2070 end if;
2071
2072 end get_ARGUMENT18;
2073
2074
2075 --
2076 -- FUNCTION
2077 -- get_ARGUMENT19
2078 --
2079 -- Purpose
2080 -- get ARGUMENT19 of a request based on request_id
2081 -- if request_id is not given, obtain from fnd_global
2082 --
2083 -- Note
2084 -- returns NULL on failure
2085 --
2086 function get_ARGUMENT19(request_id in number) return fnd_concurrent_requests.ARGUMENT19%TYPE is
2087 v_status boolean;
2088
2089 begin
2090 v_status := get_all_req_detail_reqid(request_id);
2091 if (v_status = TRUE) then
2092 return(request_rec.ARGUMENT19);
2093 else
2094 return(NULL);
2095 end if;
2096
2097 end get_ARGUMENT19;
2098
2099
2100 --
2101 -- FUNCTION
2102 -- get_ARGUMENT20
2103 --
2104 -- Purpose
2105 -- get ARGUMENT20 of a request based on request_id
2106 -- if request_id is not given, obtain from fnd_global
2107 --
2108 -- Note
2109 -- returns NULL on failure
2110 --
2111 function get_ARGUMENT20(request_id in number) return fnd_concurrent_requests.ARGUMENT20%TYPE is
2112 v_status boolean;
2113
2114 begin
2115 v_status := get_all_req_detail_reqid(request_id);
2116 if (v_status = TRUE) then
2117 return(request_rec.ARGUMENT20);
2118 else
2119 return(NULL);
2120 end if;
2121
2122 end get_ARGUMENT20;
2123
2124
2125 --
2126 -- FUNCTION
2127 -- get_ARGUMENT21
2128 --
2129 -- Purpose
2130 -- get ARGUMENT21 of a request based on request_id
2131 -- if request_id is not given, obtain from fnd_global
2132 --
2133 -- Note
2134 -- returns NULL on failure
2135 --
2136 function get_ARGUMENT21(request_id in number) return fnd_concurrent_requests.ARGUMENT21%TYPE is
2137 v_status boolean;
2138
2139 begin
2140 v_status := get_all_req_detail_reqid(request_id);
2141 if (v_status = TRUE) then
2142 return(request_rec.ARGUMENT21);
2143 else
2144 return(NULL);
2145 end if;
2146
2147 end get_ARGUMENT21;
2148
2149
2150 --
2151 -- FUNCTION
2152 -- get_ARGUMENT22
2153 --
2154 -- Purpose
2155 -- get ARGUMENT22 of a request based on request_id
2156 -- if request_id is not given, obtain from fnd_global
2157 --
2158 -- Note
2159 -- returns NULL on failure
2160 --
2161 function get_ARGUMENT22(request_id in number) return fnd_concurrent_requests.ARGUMENT22%TYPE is
2162 v_status boolean;
2163
2164 begin
2165 v_status := get_all_req_detail_reqid(request_id);
2166 if (v_status = TRUE) then
2167 return(request_rec.ARGUMENT22);
2168 else
2169 return(NULL);
2170 end if;
2171
2172 end get_ARGUMENT22;
2173
2174
2175 --
2176 -- FUNCTION
2177 -- get_ARGUMENT23
2178 --
2179 -- Purpose
2180 -- get ARGUMENT23 of a request based on request_id
2181 -- if request_id is not given, obtain from fnd_global
2182 --
2183 -- Note
2187 v_status boolean;
2184 -- returns NULL on failure
2185 --
2186 function get_ARGUMENT23(request_id in number) return fnd_concurrent_requests.ARGUMENT23%TYPE is
2188
2189 begin
2190 v_status := get_all_req_detail_reqid(request_id);
2191 if (v_status = TRUE) then
2192 return(request_rec.ARGUMENT23);
2193 else
2194 return(NULL);
2195 end if;
2196
2197 end get_ARGUMENT23;
2198
2199
2200 --
2201 -- FUNCTION
2202 -- get_ARGUMENT24
2203 --
2204 -- Purpose
2205 -- get ARGUMENT24 of a request based on request_id
2206 -- if request_id is not given, obtain from fnd_global
2207 --
2208 -- Note
2209 -- returns NULL on failure
2210 --
2211 function get_ARGUMENT24(request_id in number) return fnd_concurrent_requests.ARGUMENT24%TYPE is
2212 v_status boolean;
2213
2214 begin
2215 v_status := get_all_req_detail_reqid(request_id);
2216 if (v_status = TRUE) then
2217 return(request_rec.ARGUMENT24);
2218 else
2219 return(NULL);
2220 end if;
2221
2222 end get_ARGUMENT24;
2223
2224
2225 --
2226 -- FUNCTION
2227 -- get_ARGUMENT25
2228 --
2229 -- Purpose
2230 -- get ARGUMENT25 of a request based on request_id
2231 -- if request_id is not given, obtain from fnd_global
2232 --
2233 -- Note
2234 -- returns NULL on failure
2235 --
2236 function get_ARGUMENT25(request_id in number) return fnd_concurrent_requests.ARGUMENT25%TYPE is
2237 v_status boolean;
2238
2239 begin
2240 v_status := get_all_req_detail_reqid(request_id);
2241 if (v_status = TRUE) then
2242 return(request_rec.ARGUMENT25);
2243 else
2244 return(NULL);
2245 end if;
2246
2247 end get_ARGUMENT25;
2248
2249
2250 --
2251 -- FUNCTION
2252 -- get_CRM_THRSHLD
2253 --
2254 -- Purpose
2255 -- get CRM_THRSHLD of a request based on request_id
2256 -- if request_id is not given, obtain from fnd_global
2257 --
2258 -- Note
2259 -- returns NULL on failure
2260 --
2261 function get_CRM_THRSHLD(request_id in number) return fnd_concurrent_requests.CRM_THRSHLD%TYPE is
2262 v_status boolean;
2263
2264 begin
2265 v_status := get_all_req_detail_reqid(request_id);
2266 if (v_status = TRUE) then
2267 return(request_rec.CRM_THRSHLD);
2268 else
2269 return(NULL);
2270 end if;
2271
2272 end get_CRM_THRSHLD;
2273
2274
2275 --
2276 -- FUNCTION
2277 -- get_CRM_TSTMP
2278 --
2279 -- Purpose
2280 -- get CRM_TSTMP of a request based on request_id
2281 -- if request_id is not given, obtain from fnd_global
2282 --
2283 -- Note
2284 -- returns NULL on failure
2285 --
2286 function get_CRM_TSTMP(request_id in number) return fnd_concurrent_requests.CRM_TSTMP%TYPE is
2287 v_status boolean;
2288
2289 begin
2290 v_status := get_all_req_detail_reqid(request_id);
2291 if (v_status = TRUE) then
2292 return(request_rec.CRM_TSTMP);
2293 else
2294 return(NULL);
2295 end if;
2296
2297 end get_CRM_TSTMP;
2298
2299
2300 --
2301 -- FUNCTION
2302 -- get_CRITICAL
2303 --
2304 -- Purpose
2305 -- get CRITICAL of a request based on request_id
2306 -- if request_id is not given, obtain from fnd_global
2307 --
2308 -- Note
2309 -- returns NULL on failure
2310 --
2311 function get_CRITICAL(request_id in number) return fnd_concurrent_requests.CRITICAL%TYPE is
2312 v_status boolean;
2313
2314 begin
2315 v_status := get_all_req_detail_reqid(request_id);
2316 if (v_status = TRUE) then
2317 return(request_rec.CRITICAL);
2318 else
2319 return(NULL);
2320 end if;
2321
2322 end get_CRITICAL;
2323
2324
2325 --
2326 -- FUNCTION
2327 -- get_REQUEST_TYPE
2328 --
2329 -- Purpose
2330 -- get REQUEST_TYPE of a request based on request_id
2331 -- if request_id is not given, obtain from fnd_global
2332 --
2333 -- Note
2334 -- returns NULL on failure
2335 --
2336 function get_REQUEST_TYPE(request_id in number) return fnd_concurrent_requests.REQUEST_TYPE%TYPE is
2337 v_status boolean;
2338
2339 begin
2340 v_status := get_all_req_detail_reqid(request_id);
2341 if (v_status = TRUE) then
2342 return(request_rec.REQUEST_TYPE);
2343 else
2344 return(NULL);
2345 end if;
2346
2347 end get_REQUEST_TYPE;
2348
2349
2350 --
2351 -- FUNCTION
2352 -- get_ORACLE_PROCESS_ID
2353 --
2354 -- Purpose
2355 -- get ORACLE_PROCESS_ID of a request based on request_id
2356 -- if request_id is not given, obtain from fnd_global
2357 --
2358 -- Note
2359 -- returns NULL on failure
2360 --
2361 function get_ORACLE_PROCESS_ID(request_id in number) return fnd_concurrent_requests.ORACLE_PROCESS_ID%TYPE is
2362 v_status boolean;
2363
2364 begin
2365 v_status := get_all_req_detail_reqid(request_id);
2366 if (v_status = TRUE) then
2367 return(request_rec.ORACLE_PROCESS_ID);
2368 else
2369 return(NULL);
2370 end if;
2371
2372 end get_ORACLE_PROCESS_ID;
2373
2374
2375 --
2376 -- FUNCTION
2377 -- get_ORACLE_SESSION_ID
2378 --
2379 -- Purpose
2380 -- get ORACLE_SESSION_ID of a request based on request_id
2381 -- if request_id is not given, obtain from fnd_global
2382 --
2383 -- Note
2384 -- returns NULL on failure
2385 --
2386 function get_ORACLE_SESSION_ID(request_id in number) return fnd_concurrent_requests.ORACLE_SESSION_ID%TYPE is
2387 v_status boolean;
2388
2392 return(request_rec.ORACLE_SESSION_ID);
2389 begin
2390 v_status := get_all_req_detail_reqid(request_id);
2391 if (v_status = TRUE) then
2393 else
2394 return(NULL);
2395 end if;
2396
2397 end get_ORACLE_SESSION_ID;
2398
2399
2400 --
2401 -- FUNCTION
2402 -- get_OS_PROCESS_ID
2403 --
2404 -- Purpose
2405 -- get OS_PROCESS_ID of a request based on request_id
2406 -- if request_id is not given, obtain from fnd_global
2407 --
2408 -- Note
2409 -- returns NULL on failure
2410 --
2411 function get_OS_PROCESS_ID(request_id in number) return fnd_concurrent_requests.OS_PROCESS_ID%TYPE is
2412 v_status boolean;
2413
2414 begin
2415 v_status := get_all_req_detail_reqid(request_id);
2416 if (v_status = TRUE) then
2417 return(request_rec.OS_PROCESS_ID);
2418 else
2419 return(NULL);
2420 end if;
2421
2422 end get_OS_PROCESS_ID;
2423
2424
2425 --
2426 -- FUNCTION
2427 -- get_PRINT_JOB_ID
2428 --
2429 -- Purpose
2430 -- get PRINT_JOB_ID of a request based on request_id
2431 -- if request_id is not given, obtain from fnd_global
2432 --
2433 -- Note
2434 -- returns NULL on failure
2435 --
2436 function get_PRINT_JOB_ID(request_id in number) return fnd_concurrent_requests.PRINT_JOB_ID%TYPE is
2437 v_status boolean;
2438
2439 begin
2440 v_status := get_all_req_detail_reqid(request_id);
2441 if (v_status = TRUE) then
2442 return(request_rec.PRINT_JOB_ID);
2443 else
2444 return(NULL);
2445 end if;
2446
2447 end get_PRINT_JOB_ID;
2448
2449
2450 --
2451 -- FUNCTION
2452 -- get_OUTPUT_FILE_TYPE
2453 --
2454 -- Purpose
2455 -- get OUTPUT_FILE_TYPE of a request based on request_id
2456 -- if request_id is not given, obtain from fnd_global
2457 --
2458 -- Note
2459 -- returns NULL on failure
2460 --
2461 function get_OUTPUT_FILE_TYPE(request_id in number) return fnd_concurrent_requests.OUTPUT_FILE_TYPE%TYPE is
2462 v_status boolean;
2463
2464 begin
2465 v_status := get_all_req_detail_reqid(request_id);
2466 if (v_status = TRUE) then
2467 return(request_rec.OUTPUT_FILE_TYPE);
2468 else
2469 return(NULL);
2470 end if;
2471
2472 end get_OUTPUT_FILE_TYPE;
2473
2474
2475 --
2476 -- FUNCTION
2477 -- get_RELEASE_CLASS_APP_ID
2478 --
2479 -- Purpose
2480 -- get RELEASE_CLASS_APP_ID of a request based on request_id
2481 -- if request_id is not given, obtain from fnd_global
2482 --
2483 -- Note
2484 -- returns NULL on failure
2485 --
2486 function get_RELEASE_CLASS_APP_ID(request_id in number) return fnd_concurrent_requests.RELEASE_CLASS_APP_ID%TYPE is
2487 v_status boolean;
2488
2489 begin
2490 v_status := get_all_req_detail_reqid(request_id);
2491 if (v_status = TRUE) then
2492 return(request_rec.RELEASE_CLASS_APP_ID);
2493 else
2494 return(NULL);
2495 end if;
2496
2497 end get_RELEASE_CLASS_APP_ID;
2498
2499
2500 --
2501 -- FUNCTION
2502 -- get_RELEASE_CLASS_ID
2503 --
2504 -- Purpose
2505 -- get RELEASE_CLASS_ID of a request based on request_id
2506 -- if request_id is not given, obtain from fnd_global
2507 --
2508 -- Note
2509 -- returns NULL on failure
2510 --
2511 function get_RELEASE_CLASS_ID(request_id in number) return fnd_concurrent_requests.RELEASE_CLASS_ID%TYPE is
2512 v_status boolean;
2513
2514 begin
2515 v_status := get_all_req_detail_reqid(request_id);
2516 if (v_status = TRUE) then
2517 return(request_rec.RELEASE_CLASS_ID);
2518 else
2519 return(NULL);
2520 end if;
2521
2522 end get_RELEASE_CLASS_ID;
2523
2524
2525 --
2526 -- FUNCTION
2527 -- get_STALE_DATE
2528 --
2529 -- Purpose
2530 -- get STALE_DATE of a request based on request_id
2531 -- if request_id is not given, obtain from fnd_global
2532 --
2533 -- Note
2534 -- returns NULL on failure
2535 --
2536 function get_STALE_DATE(request_id in number) return fnd_concurrent_requests.STALE_DATE%TYPE is
2537 v_status boolean;
2538
2539 begin
2540 v_status := get_all_req_detail_reqid(request_id);
2541 if (v_status = TRUE) then
2542 return(request_rec.STALE_DATE);
2543 else
2544 return(NULL);
2545 end if;
2546
2547 end get_STALE_DATE;
2548
2549
2550 --
2551 -- FUNCTION
2552 -- get_CANCEL_OR_HOLD
2553 --
2554 -- Purpose
2555 -- get CANCEL_OR_HOLD of a request based on request_id
2556 -- if request_id is not given, obtain from fnd_global
2557 --
2558 -- Note
2559 -- returns NULL on failure
2560 --
2561 function get_CANCEL_OR_HOLD(request_id in number) return fnd_concurrent_requests.CANCEL_OR_HOLD%TYPE is
2562 v_status boolean;
2563
2564 begin
2565 v_status := get_all_req_detail_reqid(request_id);
2566 if (v_status = TRUE) then
2567 return(request_rec.CANCEL_OR_HOLD);
2568 else
2569 return(NULL);
2570 end if;
2571
2572 end get_CANCEL_OR_HOLD;
2573
2574
2575 --
2576 -- FUNCTION
2577 -- get_NOTIFY_ON_PP_ERROR
2578 --
2579 -- Purpose
2580 -- get NOTIFY_ON_PP_ERROR of a request based on request_id
2581 -- if request_id is not given, obtain from fnd_global
2582 --
2583 -- Note
2584 -- returns NULL on failure
2585 --
2586 function get_NOTIFY_ON_PP_ERROR(request_id in number) return fnd_concurrent_requests.NOTIFY_ON_PP_ERROR%TYPE is
2587 v_status boolean;
2588
2589 begin
2593 else
2590 v_status := get_all_req_detail_reqid(request_id);
2591 if (v_status = TRUE) then
2592 return(request_rec.NOTIFY_ON_PP_ERROR);
2594 return(NULL);
2595 end if;
2596
2597 end get_NOTIFY_ON_PP_ERROR;
2598
2599
2600 --
2601 -- FUNCTION
2602 -- get_CD_ID
2603 --
2604 -- Purpose
2605 -- get CD_ID of a request based on request_id
2606 -- if request_id is not given, obtain from fnd_global
2607 --
2608 -- Note
2609 -- returns NULL on failure
2610 --
2611 function get_CD_ID(request_id in number) return fnd_concurrent_requests.CD_ID%TYPE is
2612 v_status boolean;
2613
2614 begin
2615 v_status := get_all_req_detail_reqid(request_id);
2616 if (v_status = TRUE) then
2617 return(request_rec.CD_ID);
2618 else
2619 return(NULL);
2620 end if;
2621
2622 end get_CD_ID;
2623
2624
2625 --
2626 -- FUNCTION
2627 -- get_REQUEST_LIMIT
2628 --
2629 -- Purpose
2630 -- get REQUEST_LIMIT of a request based on request_id
2631 -- if request_id is not given, obtain from fnd_global
2632 --
2633 -- Note
2634 -- returns NULL on failure
2635 --
2636 function get_REQUEST_LIMIT(request_id in number) return fnd_concurrent_requests.REQUEST_LIMIT%TYPE is
2637 v_status boolean;
2638
2639 begin
2640 v_status := get_all_req_detail_reqid(request_id);
2641 if (v_status = TRUE) then
2642 return(request_rec.REQUEST_LIMIT);
2643 else
2644 return(NULL);
2645 end if;
2646
2647 end get_REQUEST_LIMIT;
2648
2649
2650 --
2651 -- FUNCTION
2652 -- get_CRM_RELEASE_DATE
2653 --
2654 -- Purpose
2655 -- get CRM_RELEASE_DATE of a request based on request_id
2656 -- if request_id is not given, obtain from fnd_global
2657 --
2658 -- Note
2659 -- returns NULL on failure
2660 --
2661 function get_CRM_RELEASE_DATE(request_id in number) return fnd_concurrent_requests.CRM_RELEASE_DATE%TYPE is
2662 v_status boolean;
2663
2664 begin
2665 v_status := get_all_req_detail_reqid(request_id);
2666 if (v_status = TRUE) then
2667 return(request_rec.CRM_RELEASE_DATE);
2668 else
2669 return(NULL);
2670 end if;
2671
2672 end get_CRM_RELEASE_DATE;
2673
2674
2675 --
2676 -- FUNCTION
2677 -- get_POST_REQUEST_STATUS
2678 --
2679 -- Purpose
2680 -- get POST_REQUEST_STATUS of a request based on request_id
2681 -- if request_id is not given, obtain from fnd_global
2682 --
2683 -- Note
2684 -- returns NULL on failure
2685 --
2686 function get_POST_REQUEST_STATUS(request_id in number) return fnd_concurrent_requests.POST_REQUEST_STATUS%TYPE is
2687 v_status boolean;
2688
2689 begin
2690 v_status := get_all_req_detail_reqid(request_id);
2691 if (v_status = TRUE) then
2692 return(request_rec.POST_REQUEST_STATUS);
2693 else
2694 return(NULL);
2695 end if;
2696
2697 end get_POST_REQUEST_STATUS;
2698
2699
2700 --
2701 -- FUNCTION
2702 -- get_COMPLETION_CODE
2703 --
2704 -- Purpose
2705 -- get COMPLETION_CODE of a request based on request_id
2706 -- if request_id is not given, obtain from fnd_global
2707 --
2708 -- Note
2709 -- returns NULL on failure
2710 --
2711 function get_COMPLETION_CODE(request_id in number) return fnd_concurrent_requests.COMPLETION_CODE%TYPE is
2712 v_status boolean;
2713
2714 begin
2715 v_status := get_all_req_detail_reqid(request_id);
2716 if (v_status = TRUE) then
2717 return(request_rec.COMPLETION_CODE);
2718 else
2719 return(NULL);
2720 end if;
2721
2722 end get_COMPLETION_CODE;
2723
2724
2725 --
2726 -- FUNCTION
2727 -- get_INCREMENT_DATES
2728 --
2729 -- Purpose
2730 -- get INCREMENT_DATES of a request based on request_id
2731 -- if request_id is not given, obtain from fnd_global
2732 --
2733 -- Note
2734 -- returns NULL on failure
2735 --
2736 function get_INCREMENT_DATES(request_id in number) return fnd_concurrent_requests.INCREMENT_DATES%TYPE is
2737 v_status boolean;
2738
2739 begin
2740 v_status := get_all_req_detail_reqid(request_id);
2741 if (v_status = TRUE) then
2742 return(request_rec.INCREMENT_DATES);
2743 else
2744 return(NULL);
2745 end if;
2746
2747 end get_INCREMENT_DATES;
2748
2749
2750 --
2751 -- FUNCTION
2752 -- get_RESTART
2753 --
2754 -- Purpose
2755 -- get RESTART of a request based on request_id
2756 -- if request_id is not given, obtain from fnd_global
2757 --
2758 -- Note
2759 -- returns NULL on failure
2760 --
2761 function get_RESTART(request_id in number) return fnd_concurrent_requests.RESTART%TYPE is
2762 v_status boolean;
2763
2764 begin
2765 v_status := get_all_req_detail_reqid(request_id);
2766 if (v_status = TRUE) then
2767 return(request_rec.RESTART);
2768 else
2769 return(NULL);
2770 end if;
2771
2772 end get_RESTART;
2773
2774
2775 --
2776 -- FUNCTION
2777 -- get_ENABLE_TRACE
2778 --
2779 -- Purpose
2780 -- get ENABLE_TRACE of a request based on request_id
2781 -- if request_id is not given, obtain from fnd_global
2782 --
2783 -- Note
2784 -- returns NULL on failure
2785 --
2786 function get_ENABLE_TRACE(request_id in number) return fnd_concurrent_requests.ENABLE_TRACE%TYPE is
2787 v_status boolean;
2788
2789 begin
2790 v_status := get_all_req_detail_reqid(request_id);
2791 if (v_status = TRUE) then
2792 return(request_rec.ENABLE_TRACE);
2796
2793 else
2794 return(NULL);
2795 end if;
2797 end get_ENABLE_TRACE;
2798
2799
2800 --
2801 -- FUNCTION
2802 -- get_RESUB_COUNT
2803 --
2804 -- Purpose
2805 -- get RESUB_COUNT of a request based on request_id
2806 -- if request_id is not given, obtain from fnd_global
2807 --
2808 -- Note
2809 -- returns NULL on failure
2810 --
2811 function get_RESUB_COUNT(request_id in number) return fnd_concurrent_requests.RESUB_COUNT%TYPE is
2812 v_status boolean;
2813
2814 begin
2815 v_status := get_all_req_detail_reqid(request_id);
2816 if (v_status = TRUE) then
2817 return(request_rec.RESUB_COUNT);
2818 else
2819 return(NULL);
2820 end if;
2821
2822 end get_RESUB_COUNT;
2823
2824
2825 --
2826 -- FUNCTION
2827 -- get_NLS_CODESET
2828 --
2829 -- Purpose
2830 -- get NLS_CODESET of a request based on request_id
2831 -- if request_id is not given, obtain from fnd_global
2832 --
2833 -- Note
2834 -- returns NULL on failure
2835 --
2836 function get_NLS_CODESET(request_id in number) return fnd_concurrent_requests.NLS_CODESET%TYPE is
2837 v_status boolean;
2838
2839 begin
2840 v_status := get_all_req_detail_reqid(request_id);
2841 if (v_status = TRUE) then
2842 return(request_rec.NLS_CODESET);
2843 else
2844 return(NULL);
2845 end if;
2846
2847 end get_NLS_CODESET;
2848
2849
2850 --
2851 -- FUNCTION
2852 -- get_OFILE_SIZE
2853 --
2854 -- Purpose
2855 -- get OFILE_SIZE of a request based on request_id
2856 -- if request_id is not given, obtain from fnd_global
2857 --
2858 -- Note
2859 -- returns NULL on failure
2860 --
2861 function get_OFILE_SIZE(request_id in number) return fnd_concurrent_requests.OFILE_SIZE%TYPE is
2862 v_status boolean;
2863
2864 begin
2865 v_status := get_all_req_detail_reqid(request_id);
2866 if (v_status = TRUE) then
2867 return(request_rec.OFILE_SIZE);
2868 else
2869 return(NULL);
2870 end if;
2871
2872 end get_OFILE_SIZE;
2873
2874
2875 --
2876 -- FUNCTION
2877 -- get_LFILE_SIZE
2878 --
2879 -- Purpose
2880 -- get LFILE_SIZE of a request based on request_id
2881 -- if request_id is not given, obtain from fnd_global
2882 --
2883 -- Note
2884 -- returns NULL on failure
2885 --
2886 function get_LFILE_SIZE(request_id in number) return fnd_concurrent_requests.LFILE_SIZE%TYPE is
2887 v_status boolean;
2888
2889 begin
2890 v_status := get_all_req_detail_reqid(request_id);
2891 if (v_status = TRUE) then
2892 return(request_rec.LFILE_SIZE);
2893 else
2894 return(NULL);
2895 end if;
2896
2897 end get_LFILE_SIZE;
2898
2899
2900 --
2901 -- FUNCTION
2902 -- get_STALE
2903 --
2904 -- Purpose
2905 -- get STALE of a request based on request_id
2906 -- if request_id is not given, obtain from fnd_global
2907 --
2908 -- Note
2909 -- returns NULL on failure
2910 --
2911 function get_STALE(request_id in number) return fnd_concurrent_requests.STALE%TYPE is
2912 v_status boolean;
2913
2914 begin
2915 v_status := get_all_req_detail_reqid(request_id);
2916 if (v_status = TRUE) then
2917 return(request_rec.STALE);
2918 else
2919 return(NULL);
2920 end if;
2921
2922 end get_STALE;
2923
2924
2925 --
2926 -- FUNCTION
2927 -- get_SECURITY_GROUP_ID
2928 --
2929 -- Purpose
2930 -- get SECURITY_GROUP_ID of a request based on request_id
2931 -- if request_id is not given, obtain from fnd_global
2932 --
2933 -- Note
2934 -- returns NULL on failure
2935 --
2936 function get_SECURITY_GROUP_ID(request_id in number) return fnd_concurrent_requests.SECURITY_GROUP_ID%TYPE is
2937 v_status boolean;
2938
2939 begin
2940 v_status := get_all_req_detail_reqid(request_id);
2941 if (v_status = TRUE) then
2942 return(request_rec.SECURITY_GROUP_ID);
2943 else
2944 return(NULL);
2945 end if;
2946
2947 end get_SECURITY_GROUP_ID;
2948
2949
2950 --
2951 -- FUNCTION
2952 -- get_RESOURCE_CONSUMER_GROUP
2953 --
2954 -- Purpose
2955 -- get RESOURCE_CONSUMER_GROUP of a request based on request_id
2956 -- if request_id is not given, obtain from fnd_global
2957 --
2958 -- Note
2959 -- returns NULL on failure
2960 --
2961 function get_RESOURCE_CONSUMER_GROUP(request_id in number) return fnd_concurrent_requests.RESOURCE_CONSUMER_GROUP%TYPE is
2962 v_status boolean;
2963
2964 begin
2965 v_status := get_all_req_detail_reqid(request_id);
2966 if (v_status = TRUE) then
2967 return(request_rec.RESOURCE_CONSUMER_GROUP);
2968 else
2969 return(NULL);
2970 end if;
2971
2972 end get_RESOURCE_CONSUMER_GROUP;
2973
2974
2975 --
2976 -- FUNCTION
2977 -- get_EXP_DATE
2978 --
2979 -- Purpose
2980 -- get EXP_DATE of a request based on request_id
2981 -- if request_id is not given, obtain from fnd_global
2982 --
2983 -- Note
2984 -- returns NULL on failure
2985 --
2986 function get_EXP_DATE(request_id in number) return fnd_concurrent_requests.EXP_DATE%TYPE is
2987 v_status boolean;
2988
2989 begin
2990 v_status := get_all_req_detail_reqid(request_id);
2991 if (v_status = TRUE) then
2992 return(request_rec.EXP_DATE);
2993 else
2994 return(NULL);
2995 end if;
2996
2997 end get_EXP_DATE;
2998
2999
3000 --
3001 -- FUNCTION
3005 -- get QUEUE_APP_ID of a request based on request_id
3002 -- get_QUEUE_APP_ID
3003 --
3004 -- Purpose
3006 -- if request_id is not given, obtain from fnd_global
3007 --
3008 -- Note
3009 -- returns NULL on failure
3010 --
3011 function get_QUEUE_APP_ID(request_id in number) return fnd_concurrent_requests.QUEUE_APP_ID%TYPE is
3012 v_status boolean;
3013
3014 begin
3015 v_status := get_all_req_detail_reqid(request_id);
3016 if (v_status = TRUE) then
3017 return(request_rec.QUEUE_APP_ID);
3018 else
3019 return(NULL);
3020 end if;
3021
3022 end get_QUEUE_APP_ID;
3023
3024
3025 --
3026 -- FUNCTION
3027 -- get_QUEUE_ID
3028 --
3029 -- Purpose
3030 -- get QUEUE_ID of a request based on request_id
3031 -- if request_id is not given, obtain from fnd_global
3032 --
3033 -- Note
3034 -- returns NULL on failure
3035 --
3036 function get_QUEUE_ID(request_id in number) return fnd_concurrent_requests.QUEUE_ID%TYPE is
3037 v_status boolean;
3038
3039 begin
3040 v_status := get_all_req_detail_reqid(request_id);
3041 if (v_status = TRUE) then
3042 return(request_rec.QUEUE_ID);
3043 else
3044 return(NULL);
3045 end if;
3046
3047 end get_QUEUE_ID;
3048
3049
3050 --
3051 -- FUNCTION
3052 -- get_OPS_INSTANCE
3053 --
3054 -- Purpose
3055 -- get OPS_INSTANCE of a request based on request_id
3056 -- if request_id is not given, obtain from fnd_global
3057 --
3058 -- Note
3059 -- returns NULL on failure
3060 --
3061 function get_OPS_INSTANCE(request_id in number) return fnd_concurrent_requests.OPS_INSTANCE%TYPE is
3062 v_status boolean;
3063
3064 begin
3065 v_status := get_all_req_detail_reqid(request_id);
3066 if (v_status = TRUE) then
3067 return(request_rec.OPS_INSTANCE);
3068 else
3069 return(NULL);
3070 end if;
3071
3072 end get_OPS_INSTANCE;
3073
3074
3075 --
3076 -- FUNCTION
3077 -- get_INTERIM_STATUS_CODE
3078 --
3079 -- Purpose
3080 -- get INTERIM_STATUS_CODE of a request based on request_id
3081 -- if request_id is not given, obtain from fnd_global
3082 --
3083 -- Note
3084 -- returns NULL on failure
3085 --
3086 function get_INTERIM_STATUS_CODE(request_id in number) return fnd_concurrent_requests.INTERIM_STATUS_CODE%TYPE is
3087 v_status boolean;
3088
3089 begin
3090 v_status := get_all_req_detail_reqid(request_id);
3091 if (v_status = TRUE) then
3092 return(request_rec.INTERIM_STATUS_CODE);
3093 else
3094 return(NULL);
3095 end if;
3096
3097 end get_INTERIM_STATUS_CODE;
3098
3099
3100 --
3101 -- FUNCTION
3102 -- get_ROOT_REQUEST_ID
3103 --
3104 -- Purpose
3105 -- get ROOT_REQUEST_ID of a request based on request_id
3106 -- if request_id is not given, obtain from fnd_global
3107 --
3108 -- Note
3109 -- returns NULL on failure
3110 --
3111 function get_ROOT_REQUEST_ID(request_id in number) return fnd_concurrent_requests.ROOT_REQUEST_ID%TYPE is
3112 v_status boolean;
3113
3114 begin
3115 v_status := get_all_req_detail_reqid(request_id);
3116 if (v_status = TRUE) then
3117 return(request_rec.ROOT_REQUEST_ID);
3118 else
3119 return(NULL);
3120 end if;
3121
3122 end get_ROOT_REQUEST_ID;
3123
3124
3125 --
3126 -- FUNCTION
3127 -- get_ORIGIN
3128 --
3129 -- Purpose
3130 -- get ORIGIN of a request based on request_id
3131 -- if request_id is not given, obtain from fnd_global
3132 --
3133 -- Note
3134 -- returns NULL on failure
3135 --
3136 function get_ORIGIN(request_id in number) return fnd_concurrent_requests.ORIGIN%TYPE is
3137 v_status boolean;
3138
3139 begin
3140 v_status := get_all_req_detail_reqid(request_id);
3141 if (v_status = TRUE) then
3142 return(request_rec.ORIGIN);
3143 else
3144 return(NULL);
3145 end if;
3146
3147 end get_ORIGIN;
3148
3149
3150 --
3151 -- FUNCTION
3152 -- get_NLS_NUMERIC_CHARACTERS
3153 --
3154 -- Purpose
3155 -- get NLS_NUMERIC_CHARACTERS of a request based on request_id
3156 -- if request_id is not given, obtain from fnd_global
3157 --
3158 -- Note
3159 -- returns NULL on failure
3160 --
3161 function get_NLS_NUMERIC_CHARACTERS(request_id in number) return fnd_concurrent_requests.NLS_NUMERIC_CHARACTERS%TYPE is
3162 v_status boolean;
3163
3164 begin
3165 v_status := get_all_req_detail_reqid(request_id);
3166 if (v_status = TRUE) then
3167 return(request_rec.NLS_NUMERIC_CHARACTERS);
3168 else
3169 return(NULL);
3170 end if;
3171
3172 end get_NLS_NUMERIC_CHARACTERS;
3173
3174
3175 --
3176 -- FUNCTION
3177 -- get_PP_START_DATE
3178 --
3179 -- Purpose
3180 -- get PP_START_DATE of a request based on request_id
3181 -- if request_id is not given, obtain from fnd_global
3182 --
3183 -- Note
3184 -- returns NULL on failure
3185 --
3186 function get_PP_START_DATE(request_id in number) return fnd_concurrent_requests.PP_START_DATE%TYPE is
3187 v_status boolean;
3188
3189 begin
3190 v_status := get_all_req_detail_reqid(request_id);
3191 if (v_status = TRUE) then
3192 return(request_rec.PP_START_DATE);
3193 else
3194 return(NULL);
3195 end if;
3196
3197 end get_PP_START_DATE;
3198
3199
3200 --
3201 -- FUNCTION
3202 -- get_PP_END_DATE
3203 --
3204 -- Purpose
3208 -- Note
3205 -- get PP_END_DATE of a request based on request_id
3206 -- if request_id is not given, obtain from fnd_global
3207 --
3209 -- returns NULL on failure
3210 --
3211 function get_PP_END_DATE(request_id in number) return fnd_concurrent_requests.PP_END_DATE%TYPE is
3212 v_status boolean;
3213
3214 begin
3215 v_status := get_all_req_detail_reqid(request_id);
3216 if (v_status = TRUE) then
3217 return(request_rec.PP_END_DATE);
3218 else
3219 return(NULL);
3220 end if;
3221
3222 end get_PP_END_DATE;
3223
3224
3225 end FND_CONC_REQ_DETAIL;