DBA Data[Home] [Help]

APPS.OKS_BTL_PVT dependencies on OKC_UTIL

Line 585: /*OKC_UTIL.CHECK_LENGTH

581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
582: Begin
583: null;
584: -- call column length utility
585: /*OKC_UTIL.CHECK_LENGTH
586: (
587: p_view_name => 'OKS_BILL_TXN_LINES_V'
588: ,p_col_name => 'TRX_LINE_AMOUNT'
589: ,p_col_value => P_Trx_Line_Amount

Line 793: OKC_UTIL.CHECK_LENGTH

789: x_return_status := OKC_API.G_RET_STS_SUCCESS;
790:
791: -- call column length utility
792: /*
793: OKC_UTIL.CHECK_LENGTH
794: (
795: p_view_name => 'OKS_BILL_TXN_LINES_V'
796: ,p_col_name => 'attribute1'
797: ,p_col_value => p_attribute1

Line 846: OKC_UTIL.CHECK_LENGTH

842: x_return_status := OKC_API.G_RET_STS_SUCCESS;
843:
844: -- call column length utility
845: /*
846: OKC_UTIL.CHECK_LENGTH
847: (
848: p_view_name => 'OKS_BILL_TXN_LINES_V'
849: ,p_col_name => 'attribute2'
850: ,p_col_value => p_attribute2

Line 900: OKC_UTIL.CHECK_LENGTH

896: x_return_status := OKC_API.G_RET_STS_SUCCESS;
897:
898: -- call column length utility
899: /*
900: OKC_UTIL.CHECK_LENGTH
901: (
902: p_view_name => 'OKS_BILL_TXN_LINES_V'
903: ,p_col_name => 'attribute3'
904: ,p_col_value => p_attribute3

Line 952: OKC_UTIL.CHECK_LENGTH

948: x_return_status := OKC_API.G_RET_STS_SUCCESS;
949:
950: -- call column length utility
951: /*
952: OKC_UTIL.CHECK_LENGTH
953: (
954: p_view_name => 'OKS_BILL_TXN_LINES_V'
955: ,p_col_name => 'attribute4'
956: ,p_col_value => p_attribute4

Line 1005: OKC_UTIL.CHECK_LENGTH

1001: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1002:
1003: -- call column length utility
1004: /*
1005: OKC_UTIL.CHECK_LENGTH
1006: (
1007: p_view_name => 'OKS_BILL_TXN_LINES_V'
1008: ,p_col_name => 'attribute5'
1009: ,p_col_value => p_attribute5

Line 1058: OKC_UTIL.CHECK_LENGTH

1054: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1055:
1056: -- call column length utility
1057: /*
1058: OKC_UTIL.CHECK_LENGTH
1059: (
1060: p_view_name => 'OKS_BILL_TXN_LINES_V'
1061: ,p_col_name => 'attribute6'
1062: ,p_col_value => p_attribute6

Line 1111: OKC_UTIL.CHECK_LENGTH

1107: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1108:
1109: -- call column length utility
1110: /*
1111: OKC_UTIL.CHECK_LENGTH
1112: (
1113: p_view_name => 'OKS_BILL_TXN_LINES_V'
1114: ,p_col_name => 'attribute7'
1115: ,p_col_value => p_attribute7

Line 1165: OKC_UTIL.CHECK_LENGTH

1161: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1162:
1163: -- call column length utility
1164: /*
1165: OKC_UTIL.CHECK_LENGTH
1166: (
1167: p_view_name => 'OKS_BILL_TXN_LINES_V'
1168: ,p_col_name => 'attribute8'
1169: ,p_col_value => p_attribute8

Line 1219: OKC_UTIL.CHECK_LENGTH

1215: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1216:
1217: -- call column length utility
1218: /*
1219: OKC_UTIL.CHECK_LENGTH
1220: (
1221: p_view_name => 'OKS_BILL_TXN_LINES_V'
1222: ,p_col_name => 'attribute9'
1223: ,p_col_value => p_attribute9

Line 1273: OKC_UTIL.CHECK_LENGTH

1269: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1270:
1271: -- call column length utility
1272: /*
1273: OKC_UTIL.CHECK_LENGTH
1274: (
1275: p_view_name => 'OKS_BILL_TXN_LINES_V'
1276: ,p_col_name => 'attribute10'
1277: ,p_col_value => p_attribute10

Line 1328: OKC_UTIL.CHECK_LENGTH

1324:
1325: -- call column length utility
1326:
1327: /*
1328: OKC_UTIL.CHECK_LENGTH
1329: (
1330: p_view_name => 'OKS_BILL_TXN_LINES_V'
1331: ,p_col_name => 'attribute11'
1332: ,p_col_value => p_attribute11

Line 1383: OKC_UTIL.CHECK_LENGTH

1379: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1380:
1381: -- call column length utility
1382: /*
1383: OKC_UTIL.CHECK_LENGTH
1384: (
1385: p_view_name => 'OKS_BILL_TXN_LINES_V'
1386: ,p_col_name => 'attribute12'
1387: ,p_col_value => p_attribute12

Line 1438: OKC_UTIL.CHECK_LENGTH

1434: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1435:
1436: -- call column length utility
1437: /*
1438: OKC_UTIL.CHECK_LENGTH
1439: (
1440: p_view_name => 'OKS_BILL_TXN_LINES_V'
1441: ,p_col_name => 'attribute13'
1442: ,p_col_value => p_attribute13

Line 1493: OKC_UTIL.CHECK_LENGTH

1489: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1490:
1491: -- call column length utility
1492: /*
1493: OKC_UTIL.CHECK_LENGTH
1494: (
1495: p_view_name => 'OKS_BILL_TXN_LINES_V'
1496: ,p_col_name => 'attribute14'
1497: ,p_col_value => p_attribute14

Line 1546: OKC_UTIL.CHECK_LENGTH

1542: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1543:
1544: -- call column length utility
1545: /*
1546: OKC_UTIL.CHECK_LENGTH
1547: (
1548: p_view_name => 'OKS_BILL_TXN_LINES_V'
1549: ,p_col_name => 'attribute15'
1550: ,p_col_value => p_attribute15

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

1592: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1593: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1594:
1595: Begin
1596: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1597:
1598: OKC_UTIL.ADD_VIEW('OKS_BILL_TXN_LINES_V',x_return_status);
1599:
1600: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1598: OKC_UTIL.ADD_VIEW('OKS_BILL_TXN_LINES_V',x_return_status);

1594:
1595: Begin
1596: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1597:
1598: OKC_UTIL.ADD_VIEW('OKS_BILL_TXN_LINES_V',x_return_status);
1599:
1600: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1601: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1602: -- need to leave