[Home] [Help]
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: -- ================================================
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:
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
807: --
808: -- Note
809: -- returns NULL on failure
810: --
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);
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);
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);
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);
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);
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);
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);
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);
1007: --
1008: -- Note
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
1012: v_status boolean;
1013:
1014: begin
1015: v_status := get_all_req_detail_reqid(request_id);
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);
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);
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);
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);
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);
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);
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);
1207: --
1208: -- Note
1209: -- returns NULL on failure
1210: --
1211: function get_RESUBMIT_TIME(request_id in number) return fnd_concurrent_requests.RESUBMIT_TIME%TYPE is
1212: v_status boolean;
1213:
1214: begin
1215: v_status := get_all_req_detail_reqid(request_id);
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);
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);
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);
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);
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);
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);
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);
1407: --
1408: -- Note
1409: -- returns NULL on failure
1410: --
1411: function get_OUTCOME_CODE(request_id in number) return fnd_concurrent_requests.OUTCOME_CODE%TYPE is
1412: v_status boolean;
1413:
1414: begin
1415: v_status := get_all_req_detail_reqid(request_id);
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);
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);
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);
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);
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);
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);
1582: --
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);
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);
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);
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);
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);
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);
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);
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
1765: v_status := get_all_req_detail_reqid(request_id);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
2182: --
2183: -- Note
2184: -- returns NULL on failure
2185: --
2186: function get_ARGUMENT23(request_id in number) return fnd_concurrent_requests.ARGUMENT23%TYPE is
2187: v_status boolean;
2188:
2189: begin
2190: v_status := get_all_req_detail_reqid(request_id);
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);
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);
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);
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);
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);
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);
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);
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:
2389: begin
2390: v_status := get_all_req_detail_reqid(request_id);
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);
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);
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);
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);
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);
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);
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);
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
2590: v_status := get_all_req_detail_reqid(request_id);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
3207: --
3208: -- Note
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);