eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_AVLEXC_PVT dependencies on OKC_UTIL

Line 400: /* OKC_UTIL.CHECK_LENGTH

396: End If;
397: End If;
398: -- call column length utility
399:
400: /* OKC_UTIL.CHECK_LENGTH
401: (
402: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
403: ,p_col_name => 'sav_id'
404: ,p_col_value => p_sav_id

Line 459: /* OKC_UTIL.CHECK_LENGTH

455: x_return_status := OKC_API.G_RET_STS_ERROR;
456: RAISE G_EXCEPTION_HALT_VALIDATION;
457: End If;
458: -- call column length utility
459: /* OKC_UTIL.CHECK_LENGTH
460: (
461: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
462: ,p_col_name => 'JTOT_OBJECT1_CODE'
463: ,p_col_value => P_JTOT_OBJECT1_CODE

Line 516: OKC_UTIL.CHECK_LENGTH

512: RAISE G_EXCEPTION_HALT_VALIDATION;
513: End If;
514:
515: -- call column length utility
516: OKC_UTIL.CHECK_LENGTH
517: (
518: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
519: ,p_col_name => 'object_version_number'
520: ,p_col_value => p_object_version_number

Line 572: OKC_UTIL.CHECK_LENGTH

568: RAISE G_EXCEPTION_HALT_VALIDATION;
569: End If;
570:
571: -- call column length utility
572: OKC_UTIL.CHECK_LENGTH
573: (
574: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
575: ,p_col_name => 'manufacturing_org_id'
576: ,p_col_value => P_manufacturing_org_id

Line 629: OKC_UTIL.CHECK_LENGTH

625: RAISE G_EXCEPTION_HALT_VALIDATION;
626: End If;*/
627:
628: -- call column length utility
629: OKC_UTIL.CHECK_LENGTH
630: (
631: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
632: ,p_col_name => 'revision_high'
633: ,p_col_value => P_revision_high

Line 686: OKC_UTIL.CHECK_LENGTH

682: RAISE G_EXCEPTION_HALT_VALIDATION;
683: End If;
684:
685: -- call column length utility
686: OKC_UTIL.CHECK_LENGTH
687: (
688: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
689: ,p_col_name => 'revision_low'
690: ,p_col_value => P_revision_low

Line 745: OKC_UTIL.CHECK_LENGTH

741: RAISE G_EXCEPTION_HALT_VALIDATION;
742: End If;
743:
744: -- call column length utility
745: OKC_UTIL.CHECK_LENGTH
746: (
747: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
748: ,p_col_name => 'object1_id1'
749: ,p_col_value => P_object1_id1

Line 804: OKC_UTIL.CHECK_LENGTH

800: RAISE G_EXCEPTION_HALT_VALIDATION;
801: End If;
802:
803: -- call column length utility
804: OKC_UTIL.CHECK_LENGTH
805: (
806: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
807: ,p_col_name => 'object1_id2'
808: ,p_col_value => P_object1_id2

Line 855: OKC_UTIL.CHECK_LENGTH

851: x_return_status := OKC_API.G_RET_STS_SUCCESS;
852:
853:
854: -- call column length utility
855: OKC_UTIL.CHECK_LENGTH
856: (
857: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
858: ,p_col_name => 'attribute_category'
859: ,p_col_value => p_attribute_category

Line 904: OKC_UTIL.CHECK_LENGTH

900: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
901: Begin
902: x_return_status := OKC_API.G_RET_STS_SUCCESS;
903: -- call column length utility
904: OKC_UTIL.CHECK_LENGTH
905: (
906: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
907: ,p_col_name => 'attribute1'
908: ,p_col_value => p_attribute1

Line 950: OKC_UTIL.CHECK_LENGTH

946:
947: x_return_status := OKC_API.G_RET_STS_SUCCESS;
948:
949: -- call column length utility
950: OKC_UTIL.CHECK_LENGTH
951: (
952: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
953: ,p_col_name => 'attribute2'
954: ,p_col_value => p_attribute2

Line 997: OKC_UTIL.CHECK_LENGTH

993: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
994: Begin
995: x_return_status := OKC_API.G_RET_STS_SUCCESS;
996: -- call column length utility
997: OKC_UTIL.CHECK_LENGTH
998: (
999: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1000: ,p_col_name => 'attribute3'
1001: ,p_col_value => p_attribute3

Line 1043: OKC_UTIL.CHECK_LENGTH

1039:
1040: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1041:
1042: -- call column length utility
1043: OKC_UTIL.CHECK_LENGTH
1044: (
1045: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1046: ,p_col_name => 'attribute4'
1047: ,p_col_value => p_attribute4

Line 1090: OKC_UTIL.CHECK_LENGTH

1086: Begin
1087:
1088: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1089: -- call column length utility
1090: OKC_UTIL.CHECK_LENGTH
1091: (
1092: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1093: ,p_col_name => 'attribute5'
1094: ,p_col_value => p_attribute5

Line 1136: OKC_UTIL.CHECK_LENGTH

1132: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1133: Begin
1134: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1135: -- call column length utility
1136: OKC_UTIL.CHECK_LENGTH
1137: (
1138: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1139: ,p_col_name => 'attribute6'
1140: ,p_col_value => p_attribute6

Line 1182: OKC_UTIL.CHECK_LENGTH

1178:
1179: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1180:
1181: -- call column length utility
1182: OKC_UTIL.CHECK_LENGTH
1183: (
1184: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1185: ,p_col_name => 'attribute7'
1186: ,p_col_value => p_attribute7

Line 1229: OKC_UTIL.CHECK_LENGTH

1225: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1226: Begin
1227: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1228: -- call column length utility
1229: OKC_UTIL.CHECK_LENGTH
1230: (
1231: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1232: ,p_col_name => 'attribute8'
1233: ,p_col_value => p_attribute8

Line 1275: OKC_UTIL.CHECK_LENGTH

1271:
1272: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1273:
1274: -- call column length utility
1275: OKC_UTIL.CHECK_LENGTH
1276: (
1277: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1278: ,p_col_name => 'attribute9'
1279: ,p_col_value => p_attribute9

Line 1322: OKC_UTIL.CHECK_LENGTH

1318: Begin
1319:
1320: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1321: -- call column length utility
1322: OKC_UTIL.CHECK_LENGTH
1323: (
1324: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1325: ,p_col_name => 'attribute10'
1326: ,p_col_value => p_attribute10

Line 1368: OKC_UTIL.CHECK_LENGTH

1364: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1365: Begin
1366: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1367: -- call column length utility
1368: OKC_UTIL.CHECK_LENGTH
1369: (
1370: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1371: ,p_col_name => 'attribute11'
1372: ,p_col_value => p_attribute11

Line 1412: OKC_UTIL.CHECK_LENGTH

1408: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1409: Begin
1410: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1411: -- call column length utility
1412: OKC_UTIL.CHECK_LENGTH
1413: (
1414: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1415: ,p_col_name => 'attribute12'
1416: ,p_col_value => p_attribute12

Line 1458: OKC_UTIL.CHECK_LENGTH

1454: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1455: Begin
1456: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1457: -- call column length utility
1458: OKC_UTIL.CHECK_LENGTH
1459: (
1460: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1461: ,p_col_name => 'attribute13'
1462: ,p_col_value => p_attribute13

Line 1504: OKC_UTIL.CHECK_LENGTH

1500:
1501: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1502:
1503: -- call column length utility
1504: OKC_UTIL.CHECK_LENGTH
1505: (
1506: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1507: ,p_col_name => 'attribute14'
1508: ,p_col_value => p_attribute14

Line 1551: OKC_UTIL.CHECK_LENGTH

1547: Begin
1548:
1549: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1550: -- call column length utility
1551: OKC_UTIL.CHECK_LENGTH
1552: (
1553: p_view_name => 'OKS_SERV_AVAIL_EXCEPTS_V'
1554: ,p_col_name => 'attribute15'
1555: ,p_col_value => p_attribute15

Line 1603: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view

1599: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1600:
1601: Begin
1602:
1603: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1604: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAIL_EXCEPTS_V',x_return_status);
1605:
1606: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1607: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1604: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAIL_EXCEPTS_V',x_return_status);

1600:
1601: Begin
1602:
1603: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1604: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAIL_EXCEPTS_V',x_return_status);
1605:
1606: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1607: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1608: -- need to leave

Line 3849: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

3845:
3846: TYPE Var45TabTyp IS TABLE OF Varchar2(45)
3847: INDEX BY BINARY_INTEGER;
3848: l_tabsize NUMBER := p_saxv_tbl.COUNT;
3849: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
3850: TYPE Var720TabTyp IS TABLE OF Varchar2(720)
3851: INDEX BY BINARY_INTEGER;
3852:
3853: in_id OKC_DATATYPES.NumberTabTyp;