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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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