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_AVL_PVT dependencies on OKC_UTIL

Line 375: OKC_UTIL.CHECK_LENGTH

371:
372: End If;
373:
374: -- call column length utility
375: OKC_UTIL.CHECK_LENGTH
376: (
377: p_view_name => 'OKS_SERV_AVAILS_V'
378: ,p_col_name => 'object1_id1'
379: ,p_col_value => P_object1_id1

Line 437: OKC_UTIL.CHECK_LENGTH

433: End If;
434:
435:
436: -- call column length utility
437: OKC_UTIL.CHECK_LENGTH
438: (
439: p_view_name => 'OKS_SERV_AVAILS_V'
440: ,p_col_name => 'object1_id2'
441: ,p_col_value => P_object1_id2

Line 497: OKC_UTIL.CHECK_LENGTH

493: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
494: x_return_status := OKC_API.G_RET_STS_ERROR;
495: RAISE G_EXCEPTION_HALT_VALIDATION;
496: End If;
497: OKC_UTIL.CHECK_LENGTH
498: (
499: p_view_name => 'OKS_SERV_AVAILS_V'
500: ,p_col_name => 'object_version_number'
501: ,p_col_value => P_object_version_number

Line 555: OKC_UTIL.CHECK_LENGTH

551: x_return_status := OKC_API.G_RET_STS_ERROR;
552: RAISE G_EXCEPTION_HALT_VALIDATION;
553: End If;
554: -- call column length utility
555: OKC_UTIL.CHECK_LENGTH
556: (
557: p_view_name => 'OKS_SERV_AVAILS_V'
558: ,p_col_name => 'general_yn'
559: ,p_col_value => P_general_yn

Line 617: OKC_UTIL.CHECK_LENGTH

613: x_return_status := OKC_API.G_RET_STS_ERROR;
614: RAISE G_EXCEPTION_HALT_VALIDATION;
615: End If;
616: -- call column length utility
617: OKC_UTIL.CHECK_LENGTH
618: (
619: p_view_name => 'OKS_SERV_AVAILS_V'
620: ,p_col_name => 'except_object_type'
621: ,p_col_value => P_except_object_type

Line 700: OKC_UTIL.CHECK_LENGTH

696:
697: x_return_status := OKC_API.G_RET_STS_SUCCESS;
698:
699: -- call column length utility
700: OKC_UTIL.CHECK_LENGTH
701: (
702: p_view_name => 'OKS_SERV_AVAILS_V'
703: ,p_col_name => 'attribute_category'
704: ,p_col_value => p_attribute_category

Line 746: OKC_UTIL.CHECK_LENGTH

742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
743: Begin
744: x_return_status := OKC_API.G_RET_STS_SUCCESS;
745: -- call column length utility
746: OKC_UTIL.CHECK_LENGTH
747: (
748: p_view_name => 'OKS_SERV_AVAILS_V'
749: ,p_col_name => 'attribute1'
750: ,p_col_value => p_attribute1

Line 792: OKC_UTIL.CHECK_LENGTH

788:
789: x_return_status := OKC_API.G_RET_STS_SUCCESS;
790:
791: -- call column length utility
792: OKC_UTIL.CHECK_LENGTH
793: (
794: p_view_name => 'OKS_SERV_AVAILS_V'
795: ,p_col_name => 'attribute2'
796: ,p_col_value => p_attribute2

Line 839: OKC_UTIL.CHECK_LENGTH

835: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
836: Begin
837: x_return_status := OKC_API.G_RET_STS_SUCCESS;
838: -- call column length utility
839: OKC_UTIL.CHECK_LENGTH
840: (
841: p_view_name => 'OKS_SERV_AVAILS_V'
842: ,p_col_name => 'attribute3'
843: ,p_col_value => p_attribute3

Line 885: OKC_UTIL.CHECK_LENGTH

881:
882: x_return_status := OKC_API.G_RET_STS_SUCCESS;
883:
884: -- call column length utility
885: OKC_UTIL.CHECK_LENGTH
886: (
887: p_view_name => 'OKS_SERV_AVAILS_V'
888: ,p_col_name => 'attribute4'
889: ,p_col_value => p_attribute4

Line 932: OKC_UTIL.CHECK_LENGTH

928: Begin
929:
930: x_return_status := OKC_API.G_RET_STS_SUCCESS;
931: -- call column length utility
932: OKC_UTIL.CHECK_LENGTH
933: (
934: p_view_name => 'OKS_SERV_AVAILS_V'
935: ,p_col_name => 'attribute5'
936: ,p_col_value => p_attribute5

Line 978: OKC_UTIL.CHECK_LENGTH

974: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
975: Begin
976: x_return_status := OKC_API.G_RET_STS_SUCCESS;
977: -- call column length utility
978: OKC_UTIL.CHECK_LENGTH
979: (
980: p_view_name => 'OKS_SERV_AVAILS_V'
981: ,p_col_name => 'attribute6'
982: ,p_col_value => p_attribute6

Line 1024: OKC_UTIL.CHECK_LENGTH

1020:
1021: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1022:
1023: -- call column length utility
1024: OKC_UTIL.CHECK_LENGTH
1025: (
1026: p_view_name => 'OKS_SERV_AVAILS_V'
1027: ,p_col_name => 'attribute7'
1028: ,p_col_value => p_attribute7

Line 1071: OKC_UTIL.CHECK_LENGTH

1067: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1068: Begin
1069: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1070: -- call column length utility
1071: OKC_UTIL.CHECK_LENGTH
1072: (
1073: p_view_name => 'OKS_SERV_AVAILS_V'
1074: ,p_col_name => 'attribute8'
1075: ,p_col_value => p_attribute8

Line 1117: OKC_UTIL.CHECK_LENGTH

1113:
1114: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1115:
1116: -- call column length utility
1117: OKC_UTIL.CHECK_LENGTH
1118: (
1119: p_view_name => 'OKS_SERV_AVAILS_V'
1120: ,p_col_name => 'attribute9'
1121: ,p_col_value => p_attribute9

Line 1164: OKC_UTIL.CHECK_LENGTH

1160: Begin
1161:
1162: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1163: -- call column length utility
1164: OKC_UTIL.CHECK_LENGTH
1165: (
1166: p_view_name => 'OKS_SERV_AVAILS_V'
1167: ,p_col_name => 'attribute10'
1168: ,p_col_value => p_attribute10

Line 1210: OKC_UTIL.CHECK_LENGTH

1206: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1207: Begin
1208: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1209: -- call column length utility
1210: OKC_UTIL.CHECK_LENGTH
1211: (
1212: p_view_name => 'OKS_SERV_AVAILS_V'
1213: ,p_col_name => 'attribute11'
1214: ,p_col_value => p_attribute11

Line 1254: OKC_UTIL.CHECK_LENGTH

1250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1251: Begin
1252: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1253: -- call column length utility
1254: OKC_UTIL.CHECK_LENGTH
1255: (
1256: p_view_name => 'OKS_SERV_AVAILS_V'
1257: ,p_col_name => 'attribute12'
1258: ,p_col_value => p_attribute12

Line 1300: OKC_UTIL.CHECK_LENGTH

1296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1297: Begin
1298: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1299: -- call column length utility
1300: OKC_UTIL.CHECK_LENGTH
1301: (
1302: p_view_name => 'OKS_SERV_AVAILS_V'
1303: ,p_col_name => 'attribute13'
1304: ,p_col_value => p_attribute13

Line 1346: OKC_UTIL.CHECK_LENGTH

1342:
1343: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1344:
1345: -- call column length utility
1346: OKC_UTIL.CHECK_LENGTH
1347: (
1348: p_view_name => 'OKS_SERV_AVAILS_V'
1349: ,p_col_name => 'attribute14'
1350: ,p_col_value => p_attribute14

Line 1393: OKC_UTIL.CHECK_LENGTH

1389: Begin
1390:
1391: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1392: -- call column length utility
1393: OKC_UTIL.CHECK_LENGTH
1394: (
1395: p_view_name => 'OKS_SERV_AVAILS_V'
1396: ,p_col_name => 'attribute15'
1397: ,p_col_value => p_attribute15

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

1440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1441: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1442:
1443: Begin
1444: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1445:
1446: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAILS_V',x_return_status);
1447:
1448: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1446: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAILS_V',x_return_status);

1442:
1443: Begin
1444: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1445:
1446: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAILS_V',x_return_status);
1447:
1448: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1449: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1450: -- need to leave

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

3615: END delete_row;
3616:
3617: PROCEDURE INSERT_ROW_UPG(p_savv_tbl savv_tbl_type ) IS
3618: l_tabsize NUMBER := p_savv_tbl.COUNT;
3619: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
3620: TYPE Var720TabTyp IS TABLE OF Varchar2(720)
3621: INDEX BY BINARY_INTEGER;
3622:
3623: in_id OKC_DATATYPES.NumberTabTyp;