1109: END get_rec;
1110:
1111:
1112: ---------------------------------------------------------------------------
1113: -- FUNCTION get_rec for: OKL_K_LINES_H
1114: ---------------------------------------------------------------------------
1115: FUNCTION get_rec (
1116: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
1117: x_no_data_found OUT NOCOPY BOOLEAN
1112: ---------------------------------------------------------------------------
1113: -- FUNCTION get_rec for: OKL_K_LINES_H
1114: ---------------------------------------------------------------------------
1115: FUNCTION get_rec (
1116: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
1117: x_no_data_found OUT NOCOPY BOOLEAN
1118: ) RETURN okl_k_lines_h_rec_type IS
1119: CURSOR okl_k_lines_h_pk_csr (p_id IN NUMBER) IS
1120: SELECT
1114: ---------------------------------------------------------------------------
1115: FUNCTION get_rec (
1116: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
1117: x_no_data_found OUT NOCOPY BOOLEAN
1118: ) RETURN okl_k_lines_h_rec_type IS
1119: CURSOR okl_k_lines_h_pk_csr (p_id IN NUMBER) IS
1120: SELECT
1121: ID,
1122: MAJOR_VERSION,
1115: FUNCTION get_rec (
1116: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
1117: x_no_data_found OUT NOCOPY BOOLEAN
1118: ) RETURN okl_k_lines_h_rec_type IS
1119: CURSOR okl_k_lines_h_pk_csr (p_id IN NUMBER) IS
1120: SELECT
1121: ID,
1122: MAJOR_VERSION,
1123: KLE_ID,
1263: ORIGINATION_INCOME,
1264: AMOUNT_BALANCE_LEGACY,
1265: DT_EFFECTIVE_BALANCE_LEGACY
1266:
1267: FROM OKL_K_LINES_H
1268: WHERE OKL_K_LINES_H.id = p_id;
1269: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;
1270: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
1271: BEGIN
1264: AMOUNT_BALANCE_LEGACY,
1265: DT_EFFECTIVE_BALANCE_LEGACY
1266:
1267: FROM OKL_K_LINES_H
1268: WHERE OKL_K_LINES_H.id = p_id;
1269: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;
1270: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
1271: BEGIN
1272:
1265: DT_EFFECTIVE_BALANCE_LEGACY
1266:
1267: FROM OKL_K_LINES_H
1268: WHERE OKL_K_LINES_H.id = p_id;
1269: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;
1270: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
1271: BEGIN
1272:
1273: x_no_data_found := TRUE;
1266:
1267: FROM OKL_K_LINES_H
1268: WHERE OKL_K_LINES_H.id = p_id;
1269: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;
1270: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
1271: BEGIN
1272:
1273: x_no_data_found := TRUE;
1274: -- Get current database values
1271: BEGIN
1272:
1273: x_no_data_found := TRUE;
1274: -- Get current database values
1275: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1276: FETCH okl_k_lines_h_pk_csr INTO
1277: l_okl_k_lines_h_rec.ID,
1278: l_okl_k_lines_h_rec.MAJOR_VERSION,
1279: l_okl_k_lines_h_rec.KLE_ID,
1272:
1273: x_no_data_found := TRUE;
1274: -- Get current database values
1275: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1276: FETCH okl_k_lines_h_pk_csr INTO
1277: l_okl_k_lines_h_rec.ID,
1278: l_okl_k_lines_h_rec.MAJOR_VERSION,
1279: l_okl_k_lines_h_rec.KLE_ID,
1280: l_okl_k_lines_h_rec.STY_ID,
1273: x_no_data_found := TRUE;
1274: -- Get current database values
1275: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1276: FETCH okl_k_lines_h_pk_csr INTO
1277: l_okl_k_lines_h_rec.ID,
1278: l_okl_k_lines_h_rec.MAJOR_VERSION,
1279: l_okl_k_lines_h_rec.KLE_ID,
1280: l_okl_k_lines_h_rec.STY_ID,
1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1274: -- Get current database values
1275: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1276: FETCH okl_k_lines_h_pk_csr INTO
1277: l_okl_k_lines_h_rec.ID,
1278: l_okl_k_lines_h_rec.MAJOR_VERSION,
1279: l_okl_k_lines_h_rec.KLE_ID,
1280: l_okl_k_lines_h_rec.STY_ID,
1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1282: l_okl_k_lines_h_rec.LAO_AMOUNT,
1275: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1276: FETCH okl_k_lines_h_pk_csr INTO
1277: l_okl_k_lines_h_rec.ID,
1278: l_okl_k_lines_h_rec.MAJOR_VERSION,
1279: l_okl_k_lines_h_rec.KLE_ID,
1280: l_okl_k_lines_h_rec.STY_ID,
1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1282: l_okl_k_lines_h_rec.LAO_AMOUNT,
1283: l_okl_k_lines_h_rec.FEE_CHARGE,
1276: FETCH okl_k_lines_h_pk_csr INTO
1277: l_okl_k_lines_h_rec.ID,
1278: l_okl_k_lines_h_rec.MAJOR_VERSION,
1279: l_okl_k_lines_h_rec.KLE_ID,
1280: l_okl_k_lines_h_rec.STY_ID,
1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1282: l_okl_k_lines_h_rec.LAO_AMOUNT,
1283: l_okl_k_lines_h_rec.FEE_CHARGE,
1284: l_okl_k_lines_h_rec.TITLE_DATE,
1277: l_okl_k_lines_h_rec.ID,
1278: l_okl_k_lines_h_rec.MAJOR_VERSION,
1279: l_okl_k_lines_h_rec.KLE_ID,
1280: l_okl_k_lines_h_rec.STY_ID,
1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1282: l_okl_k_lines_h_rec.LAO_AMOUNT,
1283: l_okl_k_lines_h_rec.FEE_CHARGE,
1284: l_okl_k_lines_h_rec.TITLE_DATE,
1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1278: l_okl_k_lines_h_rec.MAJOR_VERSION,
1279: l_okl_k_lines_h_rec.KLE_ID,
1280: l_okl_k_lines_h_rec.STY_ID,
1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1282: l_okl_k_lines_h_rec.LAO_AMOUNT,
1283: l_okl_k_lines_h_rec.FEE_CHARGE,
1284: l_okl_k_lines_h_rec.TITLE_DATE,
1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1279: l_okl_k_lines_h_rec.KLE_ID,
1280: l_okl_k_lines_h_rec.STY_ID,
1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1282: l_okl_k_lines_h_rec.LAO_AMOUNT,
1283: l_okl_k_lines_h_rec.FEE_CHARGE,
1284: l_okl_k_lines_h_rec.TITLE_DATE,
1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1280: l_okl_k_lines_h_rec.STY_ID,
1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1282: l_okl_k_lines_h_rec.LAO_AMOUNT,
1283: l_okl_k_lines_h_rec.FEE_CHARGE,
1284: l_okl_k_lines_h_rec.TITLE_DATE,
1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1282: l_okl_k_lines_h_rec.LAO_AMOUNT,
1283: l_okl_k_lines_h_rec.FEE_CHARGE,
1284: l_okl_k_lines_h_rec.TITLE_DATE,
1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1289: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1282: l_okl_k_lines_h_rec.LAO_AMOUNT,
1283: l_okl_k_lines_h_rec.FEE_CHARGE,
1284: l_okl_k_lines_h_rec.TITLE_DATE,
1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1289: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1290: l_okl_k_lines_h_rec.DATE_REMARKETED,
1283: l_okl_k_lines_h_rec.FEE_CHARGE,
1284: l_okl_k_lines_h_rec.TITLE_DATE,
1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1289: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1290: l_okl_k_lines_h_rec.DATE_REMARKETED,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1284: l_okl_k_lines_h_rec.TITLE_DATE,
1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1289: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1290: l_okl_k_lines_h_rec.DATE_REMARKETED,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1292: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1289: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1290: l_okl_k_lines_h_rec.DATE_REMARKETED,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1292: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1289: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1290: l_okl_k_lines_h_rec.DATE_REMARKETED,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1292: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1294: l_okl_k_lines_h_rec.GAIN_LOSS,
1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1289: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1290: l_okl_k_lines_h_rec.DATE_REMARKETED,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1292: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1294: l_okl_k_lines_h_rec.GAIN_LOSS,
1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1289: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1290: l_okl_k_lines_h_rec.DATE_REMARKETED,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1292: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1294: l_okl_k_lines_h_rec.GAIN_LOSS,
1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1289: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1290: l_okl_k_lines_h_rec.DATE_REMARKETED,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1292: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1294: l_okl_k_lines_h_rec.GAIN_LOSS,
1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1290: l_okl_k_lines_h_rec.DATE_REMARKETED,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1292: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1294: l_okl_k_lines_h_rec.GAIN_LOSS,
1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1292: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1294: l_okl_k_lines_h_rec.GAIN_LOSS,
1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1292: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1294: l_okl_k_lines_h_rec.GAIN_LOSS,
1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1294: l_okl_k_lines_h_rec.GAIN_LOSS,
1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1294: l_okl_k_lines_h_rec.GAIN_LOSS,
1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1304: l_okl_k_lines_h_rec.DELIVERED_DATE,
1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1304: l_okl_k_lines_h_rec.DELIVERED_DATE,
1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1304: l_okl_k_lines_h_rec.DELIVERED_DATE,
1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1304: l_okl_k_lines_h_rec.DELIVERED_DATE,
1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1307: l_okl_k_lines_h_rec.OCCUPANCY,
1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1304: l_okl_k_lines_h_rec.DELIVERED_DATE,
1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1307: l_okl_k_lines_h_rec.OCCUPANCY,
1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1304: l_okl_k_lines_h_rec.DELIVERED_DATE,
1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1307: l_okl_k_lines_h_rec.OCCUPANCY,
1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1304: l_okl_k_lines_h_rec.DELIVERED_DATE,
1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1307: l_okl_k_lines_h_rec.OCCUPANCY,
1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1304: l_okl_k_lines_h_rec.DELIVERED_DATE,
1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1307: l_okl_k_lines_h_rec.OCCUPANCY,
1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1304: l_okl_k_lines_h_rec.DELIVERED_DATE,
1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1307: l_okl_k_lines_h_rec.OCCUPANCY,
1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1307: l_okl_k_lines_h_rec.OCCUPANCY,
1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1313: l_okl_k_lines_h_rec.YEAR_BUILT,
1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1307: l_okl_k_lines_h_rec.OCCUPANCY,
1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1313: l_okl_k_lines_h_rec.YEAR_BUILT,
1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1307: l_okl_k_lines_h_rec.OCCUPANCY,
1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1313: l_okl_k_lines_h_rec.YEAR_BUILT,
1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1313: l_okl_k_lines_h_rec.YEAR_BUILT,
1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1316: l_okl_k_lines_h_rec.NET_RENTABLE,
1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1313: l_okl_k_lines_h_rec.YEAR_BUILT,
1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1316: l_okl_k_lines_h_rec.NET_RENTABLE,
1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1313: l_okl_k_lines_h_rec.YEAR_BUILT,
1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1316: l_okl_k_lines_h_rec.NET_RENTABLE,
1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1313: l_okl_k_lines_h_rec.YEAR_BUILT,
1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1316: l_okl_k_lines_h_rec.NET_RENTABLE,
1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1313: l_okl_k_lines_h_rec.YEAR_BUILT,
1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1316: l_okl_k_lines_h_rec.NET_RENTABLE,
1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1313: l_okl_k_lines_h_rec.YEAR_BUILT,
1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1316: l_okl_k_lines_h_rec.NET_RENTABLE,
1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1316: l_okl_k_lines_h_rec.NET_RENTABLE,
1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1322: l_okl_k_lines_h_rec.PERCENT,
1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1316: l_okl_k_lines_h_rec.NET_RENTABLE,
1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1322: l_okl_k_lines_h_rec.PERCENT,
1323: l_okl_k_lines_h_rec.COVERAGE,
1316: l_okl_k_lines_h_rec.NET_RENTABLE,
1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1322: l_okl_k_lines_h_rec.PERCENT,
1323: l_okl_k_lines_h_rec.COVERAGE,
1324: l_okl_k_lines_h_rec.LRV_AMOUNT,
1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1322: l_okl_k_lines_h_rec.PERCENT,
1323: l_okl_k_lines_h_rec.COVERAGE,
1324: l_okl_k_lines_h_rec.LRV_AMOUNT,
1325: l_okl_k_lines_h_rec.AMOUNT,
1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1322: l_okl_k_lines_h_rec.PERCENT,
1323: l_okl_k_lines_h_rec.COVERAGE,
1324: l_okl_k_lines_h_rec.LRV_AMOUNT,
1325: l_okl_k_lines_h_rec.AMOUNT,
1326: l_okl_k_lines_h_rec.LRS_PERCENT,
1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1322: l_okl_k_lines_h_rec.PERCENT,
1323: l_okl_k_lines_h_rec.COVERAGE,
1324: l_okl_k_lines_h_rec.LRV_AMOUNT,
1325: l_okl_k_lines_h_rec.AMOUNT,
1326: l_okl_k_lines_h_rec.LRS_PERCENT,
1327: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1322: l_okl_k_lines_h_rec.PERCENT,
1323: l_okl_k_lines_h_rec.COVERAGE,
1324: l_okl_k_lines_h_rec.LRV_AMOUNT,
1325: l_okl_k_lines_h_rec.AMOUNT,
1326: l_okl_k_lines_h_rec.LRS_PERCENT,
1327: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1328: l_okl_k_lines_h_rec.PERCENT_STAKE,
1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1322: l_okl_k_lines_h_rec.PERCENT,
1323: l_okl_k_lines_h_rec.COVERAGE,
1324: l_okl_k_lines_h_rec.LRV_AMOUNT,
1325: l_okl_k_lines_h_rec.AMOUNT,
1326: l_okl_k_lines_h_rec.LRS_PERCENT,
1327: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1328: l_okl_k_lines_h_rec.PERCENT_STAKE,
1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1322: l_okl_k_lines_h_rec.PERCENT,
1323: l_okl_k_lines_h_rec.COVERAGE,
1324: l_okl_k_lines_h_rec.LRV_AMOUNT,
1325: l_okl_k_lines_h_rec.AMOUNT,
1326: l_okl_k_lines_h_rec.LRS_PERCENT,
1327: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1328: l_okl_k_lines_h_rec.PERCENT_STAKE,
1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1330: l_okl_k_lines_h_rec.DATE_SOLD,
1323: l_okl_k_lines_h_rec.COVERAGE,
1324: l_okl_k_lines_h_rec.LRV_AMOUNT,
1325: l_okl_k_lines_h_rec.AMOUNT,
1326: l_okl_k_lines_h_rec.LRS_PERCENT,
1327: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1328: l_okl_k_lines_h_rec.PERCENT_STAKE,
1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1330: l_okl_k_lines_h_rec.DATE_SOLD,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,
1324: l_okl_k_lines_h_rec.LRV_AMOUNT,
1325: l_okl_k_lines_h_rec.AMOUNT,
1326: l_okl_k_lines_h_rec.LRS_PERCENT,
1327: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1328: l_okl_k_lines_h_rec.PERCENT_STAKE,
1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1330: l_okl_k_lines_h_rec.DATE_SOLD,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,
1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1325: l_okl_k_lines_h_rec.AMOUNT,
1326: l_okl_k_lines_h_rec.LRS_PERCENT,
1327: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1328: l_okl_k_lines_h_rec.PERCENT_STAKE,
1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1330: l_okl_k_lines_h_rec.DATE_SOLD,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,
1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1333: l_okl_k_lines_h_rec.ATTRIBUTE1,
1326: l_okl_k_lines_h_rec.LRS_PERCENT,
1327: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1328: l_okl_k_lines_h_rec.PERCENT_STAKE,
1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1330: l_okl_k_lines_h_rec.DATE_SOLD,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,
1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1333: l_okl_k_lines_h_rec.ATTRIBUTE1,
1334: l_okl_k_lines_h_rec.ATTRIBUTE2,
1327: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1328: l_okl_k_lines_h_rec.PERCENT_STAKE,
1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1330: l_okl_k_lines_h_rec.DATE_SOLD,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,
1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1333: l_okl_k_lines_h_rec.ATTRIBUTE1,
1334: l_okl_k_lines_h_rec.ATTRIBUTE2,
1335: l_okl_k_lines_h_rec.ATTRIBUTE3,
1328: l_okl_k_lines_h_rec.PERCENT_STAKE,
1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1330: l_okl_k_lines_h_rec.DATE_SOLD,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,
1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1333: l_okl_k_lines_h_rec.ATTRIBUTE1,
1334: l_okl_k_lines_h_rec.ATTRIBUTE2,
1335: l_okl_k_lines_h_rec.ATTRIBUTE3,
1336: l_okl_k_lines_h_rec.ATTRIBUTE4,
1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1330: l_okl_k_lines_h_rec.DATE_SOLD,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,
1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1333: l_okl_k_lines_h_rec.ATTRIBUTE1,
1334: l_okl_k_lines_h_rec.ATTRIBUTE2,
1335: l_okl_k_lines_h_rec.ATTRIBUTE3,
1336: l_okl_k_lines_h_rec.ATTRIBUTE4,
1337: l_okl_k_lines_h_rec.ATTRIBUTE5,
1330: l_okl_k_lines_h_rec.DATE_SOLD,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,
1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1333: l_okl_k_lines_h_rec.ATTRIBUTE1,
1334: l_okl_k_lines_h_rec.ATTRIBUTE2,
1335: l_okl_k_lines_h_rec.ATTRIBUTE3,
1336: l_okl_k_lines_h_rec.ATTRIBUTE4,
1337: l_okl_k_lines_h_rec.ATTRIBUTE5,
1338: l_okl_k_lines_h_rec.ATTRIBUTE6,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,
1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1333: l_okl_k_lines_h_rec.ATTRIBUTE1,
1334: l_okl_k_lines_h_rec.ATTRIBUTE2,
1335: l_okl_k_lines_h_rec.ATTRIBUTE3,
1336: l_okl_k_lines_h_rec.ATTRIBUTE4,
1337: l_okl_k_lines_h_rec.ATTRIBUTE5,
1338: l_okl_k_lines_h_rec.ATTRIBUTE6,
1339: l_okl_k_lines_h_rec.ATTRIBUTE7,
1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1333: l_okl_k_lines_h_rec.ATTRIBUTE1,
1334: l_okl_k_lines_h_rec.ATTRIBUTE2,
1335: l_okl_k_lines_h_rec.ATTRIBUTE3,
1336: l_okl_k_lines_h_rec.ATTRIBUTE4,
1337: l_okl_k_lines_h_rec.ATTRIBUTE5,
1338: l_okl_k_lines_h_rec.ATTRIBUTE6,
1339: l_okl_k_lines_h_rec.ATTRIBUTE7,
1340: l_okl_k_lines_h_rec.ATTRIBUTE8,
1333: l_okl_k_lines_h_rec.ATTRIBUTE1,
1334: l_okl_k_lines_h_rec.ATTRIBUTE2,
1335: l_okl_k_lines_h_rec.ATTRIBUTE3,
1336: l_okl_k_lines_h_rec.ATTRIBUTE4,
1337: l_okl_k_lines_h_rec.ATTRIBUTE5,
1338: l_okl_k_lines_h_rec.ATTRIBUTE6,
1339: l_okl_k_lines_h_rec.ATTRIBUTE7,
1340: l_okl_k_lines_h_rec.ATTRIBUTE8,
1341: l_okl_k_lines_h_rec.ATTRIBUTE9,
1334: l_okl_k_lines_h_rec.ATTRIBUTE2,
1335: l_okl_k_lines_h_rec.ATTRIBUTE3,
1336: l_okl_k_lines_h_rec.ATTRIBUTE4,
1337: l_okl_k_lines_h_rec.ATTRIBUTE5,
1338: l_okl_k_lines_h_rec.ATTRIBUTE6,
1339: l_okl_k_lines_h_rec.ATTRIBUTE7,
1340: l_okl_k_lines_h_rec.ATTRIBUTE8,
1341: l_okl_k_lines_h_rec.ATTRIBUTE9,
1342: l_okl_k_lines_h_rec.ATTRIBUTE10,
1335: l_okl_k_lines_h_rec.ATTRIBUTE3,
1336: l_okl_k_lines_h_rec.ATTRIBUTE4,
1337: l_okl_k_lines_h_rec.ATTRIBUTE5,
1338: l_okl_k_lines_h_rec.ATTRIBUTE6,
1339: l_okl_k_lines_h_rec.ATTRIBUTE7,
1340: l_okl_k_lines_h_rec.ATTRIBUTE8,
1341: l_okl_k_lines_h_rec.ATTRIBUTE9,
1342: l_okl_k_lines_h_rec.ATTRIBUTE10,
1343: l_okl_k_lines_h_rec.ATTRIBUTE11,
1336: l_okl_k_lines_h_rec.ATTRIBUTE4,
1337: l_okl_k_lines_h_rec.ATTRIBUTE5,
1338: l_okl_k_lines_h_rec.ATTRIBUTE6,
1339: l_okl_k_lines_h_rec.ATTRIBUTE7,
1340: l_okl_k_lines_h_rec.ATTRIBUTE8,
1341: l_okl_k_lines_h_rec.ATTRIBUTE9,
1342: l_okl_k_lines_h_rec.ATTRIBUTE10,
1343: l_okl_k_lines_h_rec.ATTRIBUTE11,
1344: l_okl_k_lines_h_rec.ATTRIBUTE12,
1337: l_okl_k_lines_h_rec.ATTRIBUTE5,
1338: l_okl_k_lines_h_rec.ATTRIBUTE6,
1339: l_okl_k_lines_h_rec.ATTRIBUTE7,
1340: l_okl_k_lines_h_rec.ATTRIBUTE8,
1341: l_okl_k_lines_h_rec.ATTRIBUTE9,
1342: l_okl_k_lines_h_rec.ATTRIBUTE10,
1343: l_okl_k_lines_h_rec.ATTRIBUTE11,
1344: l_okl_k_lines_h_rec.ATTRIBUTE12,
1345: l_okl_k_lines_h_rec.ATTRIBUTE13,
1338: l_okl_k_lines_h_rec.ATTRIBUTE6,
1339: l_okl_k_lines_h_rec.ATTRIBUTE7,
1340: l_okl_k_lines_h_rec.ATTRIBUTE8,
1341: l_okl_k_lines_h_rec.ATTRIBUTE9,
1342: l_okl_k_lines_h_rec.ATTRIBUTE10,
1343: l_okl_k_lines_h_rec.ATTRIBUTE11,
1344: l_okl_k_lines_h_rec.ATTRIBUTE12,
1345: l_okl_k_lines_h_rec.ATTRIBUTE13,
1346: l_okl_k_lines_h_rec.ATTRIBUTE14,
1339: l_okl_k_lines_h_rec.ATTRIBUTE7,
1340: l_okl_k_lines_h_rec.ATTRIBUTE8,
1341: l_okl_k_lines_h_rec.ATTRIBUTE9,
1342: l_okl_k_lines_h_rec.ATTRIBUTE10,
1343: l_okl_k_lines_h_rec.ATTRIBUTE11,
1344: l_okl_k_lines_h_rec.ATTRIBUTE12,
1345: l_okl_k_lines_h_rec.ATTRIBUTE13,
1346: l_okl_k_lines_h_rec.ATTRIBUTE14,
1347: l_okl_k_lines_h_rec.ATTRIBUTE15,
1340: l_okl_k_lines_h_rec.ATTRIBUTE8,
1341: l_okl_k_lines_h_rec.ATTRIBUTE9,
1342: l_okl_k_lines_h_rec.ATTRIBUTE10,
1343: l_okl_k_lines_h_rec.ATTRIBUTE11,
1344: l_okl_k_lines_h_rec.ATTRIBUTE12,
1345: l_okl_k_lines_h_rec.ATTRIBUTE13,
1346: l_okl_k_lines_h_rec.ATTRIBUTE14,
1347: l_okl_k_lines_h_rec.ATTRIBUTE15,
1348: l_okl_k_lines_h_rec.CREATED_BY,
1341: l_okl_k_lines_h_rec.ATTRIBUTE9,
1342: l_okl_k_lines_h_rec.ATTRIBUTE10,
1343: l_okl_k_lines_h_rec.ATTRIBUTE11,
1344: l_okl_k_lines_h_rec.ATTRIBUTE12,
1345: l_okl_k_lines_h_rec.ATTRIBUTE13,
1346: l_okl_k_lines_h_rec.ATTRIBUTE14,
1347: l_okl_k_lines_h_rec.ATTRIBUTE15,
1348: l_okl_k_lines_h_rec.CREATED_BY,
1349: l_okl_k_lines_h_rec.CREATION_DATE,
1342: l_okl_k_lines_h_rec.ATTRIBUTE10,
1343: l_okl_k_lines_h_rec.ATTRIBUTE11,
1344: l_okl_k_lines_h_rec.ATTRIBUTE12,
1345: l_okl_k_lines_h_rec.ATTRIBUTE13,
1346: l_okl_k_lines_h_rec.ATTRIBUTE14,
1347: l_okl_k_lines_h_rec.ATTRIBUTE15,
1348: l_okl_k_lines_h_rec.CREATED_BY,
1349: l_okl_k_lines_h_rec.CREATION_DATE,
1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1343: l_okl_k_lines_h_rec.ATTRIBUTE11,
1344: l_okl_k_lines_h_rec.ATTRIBUTE12,
1345: l_okl_k_lines_h_rec.ATTRIBUTE13,
1346: l_okl_k_lines_h_rec.ATTRIBUTE14,
1347: l_okl_k_lines_h_rec.ATTRIBUTE15,
1348: l_okl_k_lines_h_rec.CREATED_BY,
1349: l_okl_k_lines_h_rec.CREATION_DATE,
1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1344: l_okl_k_lines_h_rec.ATTRIBUTE12,
1345: l_okl_k_lines_h_rec.ATTRIBUTE13,
1346: l_okl_k_lines_h_rec.ATTRIBUTE14,
1347: l_okl_k_lines_h_rec.ATTRIBUTE15,
1348: l_okl_k_lines_h_rec.CREATED_BY,
1349: l_okl_k_lines_h_rec.CREATION_DATE,
1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1345: l_okl_k_lines_h_rec.ATTRIBUTE13,
1346: l_okl_k_lines_h_rec.ATTRIBUTE14,
1347: l_okl_k_lines_h_rec.ATTRIBUTE15,
1348: l_okl_k_lines_h_rec.CREATED_BY,
1349: l_okl_k_lines_h_rec.CREATION_DATE,
1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1353: l_okl_k_lines_h_rec.NTY_CODE,
1346: l_okl_k_lines_h_rec.ATTRIBUTE14,
1347: l_okl_k_lines_h_rec.ATTRIBUTE15,
1348: l_okl_k_lines_h_rec.CREATED_BY,
1349: l_okl_k_lines_h_rec.CREATION_DATE,
1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1353: l_okl_k_lines_h_rec.NTY_CODE,
1354: l_okl_k_lines_h_rec.FCG_CODE,
1347: l_okl_k_lines_h_rec.ATTRIBUTE15,
1348: l_okl_k_lines_h_rec.CREATED_BY,
1349: l_okl_k_lines_h_rec.CREATION_DATE,
1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1353: l_okl_k_lines_h_rec.NTY_CODE,
1354: l_okl_k_lines_h_rec.FCG_CODE,
1355: l_okl_k_lines_h_rec.PRC_CODE,
1348: l_okl_k_lines_h_rec.CREATED_BY,
1349: l_okl_k_lines_h_rec.CREATION_DATE,
1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1353: l_okl_k_lines_h_rec.NTY_CODE,
1354: l_okl_k_lines_h_rec.FCG_CODE,
1355: l_okl_k_lines_h_rec.PRC_CODE,
1356: l_okl_k_lines_h_rec.RE_LEASE_YN,
1349: l_okl_k_lines_h_rec.CREATION_DATE,
1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1353: l_okl_k_lines_h_rec.NTY_CODE,
1354: l_okl_k_lines_h_rec.FCG_CODE,
1355: l_okl_k_lines_h_rec.PRC_CODE,
1356: l_okl_k_lines_h_rec.RE_LEASE_YN,
1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1353: l_okl_k_lines_h_rec.NTY_CODE,
1354: l_okl_k_lines_h_rec.FCG_CODE,
1355: l_okl_k_lines_h_rec.PRC_CODE,
1356: l_okl_k_lines_h_rec.RE_LEASE_YN,
1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1353: l_okl_k_lines_h_rec.NTY_CODE,
1354: l_okl_k_lines_h_rec.FCG_CODE,
1355: l_okl_k_lines_h_rec.PRC_CODE,
1356: l_okl_k_lines_h_rec.RE_LEASE_YN,
1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1353: l_okl_k_lines_h_rec.NTY_CODE,
1354: l_okl_k_lines_h_rec.FCG_CODE,
1355: l_okl_k_lines_h_rec.PRC_CODE,
1356: l_okl_k_lines_h_rec.RE_LEASE_YN,
1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1360: l_okl_k_lines_h_rec.CLG_ID,
1353: l_okl_k_lines_h_rec.NTY_CODE,
1354: l_okl_k_lines_h_rec.FCG_CODE,
1355: l_okl_k_lines_h_rec.PRC_CODE,
1356: l_okl_k_lines_h_rec.RE_LEASE_YN,
1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1360: l_okl_k_lines_h_rec.CLG_ID,
1361: l_okl_k_lines_h_rec.DATE_FUNDING,
1354: l_okl_k_lines_h_rec.FCG_CODE,
1355: l_okl_k_lines_h_rec.PRC_CODE,
1356: l_okl_k_lines_h_rec.RE_LEASE_YN,
1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1360: l_okl_k_lines_h_rec.CLG_ID,
1361: l_okl_k_lines_h_rec.DATE_FUNDING,
1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1355: l_okl_k_lines_h_rec.PRC_CODE,
1356: l_okl_k_lines_h_rec.RE_LEASE_YN,
1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1360: l_okl_k_lines_h_rec.CLG_ID,
1361: l_okl_k_lines_h_rec.DATE_FUNDING,
1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1356: l_okl_k_lines_h_rec.RE_LEASE_YN,
1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1360: l_okl_k_lines_h_rec.CLG_ID,
1361: l_okl_k_lines_h_rec.DATE_FUNDING,
1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1360: l_okl_k_lines_h_rec.CLG_ID,
1361: l_okl_k_lines_h_rec.DATE_FUNDING,
1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1365: l_okl_k_lines_h_rec.OEC,
1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1360: l_okl_k_lines_h_rec.CLG_ID,
1361: l_okl_k_lines_h_rec.DATE_FUNDING,
1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1365: l_okl_k_lines_h_rec.OEC,
1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1360: l_okl_k_lines_h_rec.CLG_ID,
1361: l_okl_k_lines_h_rec.DATE_FUNDING,
1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1365: l_okl_k_lines_h_rec.OEC,
1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1360: l_okl_k_lines_h_rec.CLG_ID,
1361: l_okl_k_lines_h_rec.DATE_FUNDING,
1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1365: l_okl_k_lines_h_rec.OEC,
1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1361: l_okl_k_lines_h_rec.DATE_FUNDING,
1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1365: l_okl_k_lines_h_rec.OEC,
1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1369: l_okl_k_lines_h_rec.RVI_PREMIUM,
1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1365: l_okl_k_lines_h_rec.OEC,
1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1369: l_okl_k_lines_h_rec.RVI_PREMIUM,
1370: l_okl_k_lines_h_rec.CREDIT_NATURE,
1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1365: l_okl_k_lines_h_rec.OEC,
1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1369: l_okl_k_lines_h_rec.RVI_PREMIUM,
1370: l_okl_k_lines_h_rec.CREDIT_NATURE,
1371: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1365: l_okl_k_lines_h_rec.OEC,
1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1369: l_okl_k_lines_h_rec.RVI_PREMIUM,
1370: l_okl_k_lines_h_rec.CREDIT_NATURE,
1371: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1372: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1365: l_okl_k_lines_h_rec.OEC,
1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1369: l_okl_k_lines_h_rec.RVI_PREMIUM,
1370: l_okl_k_lines_h_rec.CREDIT_NATURE,
1371: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1372: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1373: --Bug# 2697681 11.5.9
1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1369: l_okl_k_lines_h_rec.RVI_PREMIUM,
1370: l_okl_k_lines_h_rec.CREDIT_NATURE,
1371: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1372: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1373: --Bug# 2697681 11.5.9
1374: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1369: l_okl_k_lines_h_rec.RVI_PREMIUM,
1370: l_okl_k_lines_h_rec.CREDIT_NATURE,
1371: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1372: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1373: --Bug# 2697681 11.5.9
1374: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1375: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1369: l_okl_k_lines_h_rec.RVI_PREMIUM,
1370: l_okl_k_lines_h_rec.CREDIT_NATURE,
1371: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1372: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1373: --Bug# 2697681 11.5.9
1374: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1375: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1376: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1370: l_okl_k_lines_h_rec.CREDIT_NATURE,
1371: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1372: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1373: --Bug# 2697681 11.5.9
1374: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1375: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1376: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1377: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1378: --financed fees
1371: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1372: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1373: --Bug# 2697681 11.5.9
1374: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1375: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1376: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1377: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1378: --financed fees
1379: l_okl_k_lines_h_rec.FEE_TYPE,
1372: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1373: --Bug# 2697681 11.5.9
1374: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1375: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1376: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1377: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1378: --financed fees
1379: l_okl_k_lines_h_rec.FEE_TYPE,
1380: --Bug# 3143522 : 11.5.10
1373: --Bug# 2697681 11.5.9
1374: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1375: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1376: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1377: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1378: --financed fees
1379: l_okl_k_lines_h_rec.FEE_TYPE,
1380: --Bug# 3143522 : 11.5.10
1381: --subsidy
1375: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1376: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1377: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1378: --financed fees
1379: l_okl_k_lines_h_rec.FEE_TYPE,
1380: --Bug# 3143522 : 11.5.10
1381: --subsidy
1382: l_okl_k_lines_h_rec.SUBSIDY_ID,
1383: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1378: --financed fees
1379: l_okl_k_lines_h_rec.FEE_TYPE,
1380: --Bug# 3143522 : 11.5.10
1381: --subsidy
1382: l_okl_k_lines_h_rec.SUBSIDY_ID,
1383: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1384: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1385: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1386: --financed fee
1379: l_okl_k_lines_h_rec.FEE_TYPE,
1380: --Bug# 3143522 : 11.5.10
1381: --subsidy
1382: l_okl_k_lines_h_rec.SUBSIDY_ID,
1383: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1384: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1385: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1386: --financed fee
1387: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1380: --Bug# 3143522 : 11.5.10
1381: --subsidy
1382: l_okl_k_lines_h_rec.SUBSIDY_ID,
1383: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1384: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1385: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1386: --financed fee
1387: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1388: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1381: --subsidy
1382: l_okl_k_lines_h_rec.SUBSIDY_ID,
1383: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1384: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1385: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1386: --financed fee
1387: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1388: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1389: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1383: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1384: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1385: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1386: --financed fee
1387: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1388: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1389: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1390: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1391: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1384: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1385: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1386: --financed fee
1387: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1388: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1389: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1390: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1391: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1392: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1385: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1386: --financed fee
1387: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1388: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1389: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1390: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1391: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1392: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1393: --quote
1386: --financed fee
1387: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1388: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1389: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1390: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1391: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1392: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1393: --quote
1394: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1387: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1388: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1389: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1390: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1391: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1392: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1393: --quote
1394: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1395: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1388: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1389: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1390: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1391: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1392: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1393: --quote
1394: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1395: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1396: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1390: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1391: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1392: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1393: --quote
1394: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1395: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1396: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1397: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1398: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1391: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1392: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1393: --quote
1394: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1395: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1396: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1397: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1398: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1399: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1392: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1393: --quote
1394: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1395: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1396: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1397: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1398: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1399: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1400: --Bug# 2994971
1393: --quote
1394: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1395: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1396: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1397: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1398: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1399: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1400: --Bug# 2994971
1401: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1394: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1395: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1396: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1397: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1398: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1399: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1400: --Bug# 2994971
1401: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1402: --Bug# 3973640 11.5.10+
1395: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1396: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1397: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1398: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1399: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1400: --Bug# 2994971
1401: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1402: --Bug# 3973640 11.5.10+
1403: l_okl_k_lines_h_rec.QTE_ID,
1397: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1398: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1399: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1400: --Bug# 2994971
1401: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1402: --Bug# 3973640 11.5.10+
1403: l_okl_k_lines_h_rec.QTE_ID,
1404: l_okl_k_lines_h_rec.FUNDING_DATE,
1405: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1399: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1400: --Bug# 2994971
1401: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1402: --Bug# 3973640 11.5.10+
1403: l_okl_k_lines_h_rec.QTE_ID,
1404: l_okl_k_lines_h_rec.FUNDING_DATE,
1405: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1406: --Bug# 4419339 OKLH
1407: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1400: --Bug# 2994971
1401: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1402: --Bug# 3973640 11.5.10+
1403: l_okl_k_lines_h_rec.QTE_ID,
1404: l_okl_k_lines_h_rec.FUNDING_DATE,
1405: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1406: --Bug# 4419339 OKLH
1407: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1408: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1401: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1402: --Bug# 3973640 11.5.10+
1403: l_okl_k_lines_h_rec.QTE_ID,
1404: l_okl_k_lines_h_rec.FUNDING_DATE,
1405: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1406: --Bug# 4419339 OKLH
1407: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1408: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1409: l_okl_k_lines_h_rec.MODEL_NUMBER,
1403: l_okl_k_lines_h_rec.QTE_ID,
1404: l_okl_k_lines_h_rec.FUNDING_DATE,
1405: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1406: --Bug# 4419339 OKLH
1407: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1408: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1409: l_okl_k_lines_h_rec.MODEL_NUMBER,
1410: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1411: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1404: l_okl_k_lines_h_rec.FUNDING_DATE,
1405: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1406: --Bug# 4419339 OKLH
1407: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1408: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1409: l_okl_k_lines_h_rec.MODEL_NUMBER,
1410: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1411: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1412: --Bug#4373029
1405: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1406: --Bug# 4419339 OKLH
1407: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1408: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1409: l_okl_k_lines_h_rec.MODEL_NUMBER,
1410: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1411: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1412: --Bug#4373029
1413: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1406: --Bug# 4419339 OKLH
1407: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1408: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1409: l_okl_k_lines_h_rec.MODEL_NUMBER,
1410: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1411: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1412: --Bug#4373029
1413: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1414: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1407: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1408: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1409: l_okl_k_lines_h_rec.MODEL_NUMBER,
1410: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1411: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1412: --Bug#4373029
1413: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1414: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1415: --Bug# 4631549
1409: l_okl_k_lines_h_rec.MODEL_NUMBER,
1410: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1411: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1412: --Bug#4373029
1413: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1414: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1415: --Bug# 4631549
1416: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
1417: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
1410: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1411: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1412: --Bug#4373029
1413: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1414: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1415: --Bug# 4631549
1416: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
1417: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
1418: --Bug# 16344245
1412: --Bug#4373029
1413: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1414: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1415: --Bug# 4631549
1416: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
1417: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
1418: --Bug# 16344245
1419: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
1420: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
1413: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1414: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1415: --Bug# 4631549
1416: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
1417: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
1418: --Bug# 16344245
1419: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
1420: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
1421: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
1415: --Bug# 4631549
1416: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
1417: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
1418: --Bug# 16344245
1419: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
1420: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
1421: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
1422: ;
1423: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1416: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
1417: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
1418: --Bug# 16344245
1419: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
1420: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
1421: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
1422: ;
1423: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1424: CLOSE okl_k_lines_h_pk_csr;
1417: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
1418: --Bug# 16344245
1419: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
1420: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
1421: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
1422: ;
1423: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1424: CLOSE okl_k_lines_h_pk_csr;
1425: RETURN(l_okl_k_lines_h_rec);
1419: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
1420: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
1421: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
1422: ;
1423: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1424: CLOSE okl_k_lines_h_pk_csr;
1425: RETURN(l_okl_k_lines_h_rec);
1426: END get_rec;
1427:
1420: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
1421: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
1422: ;
1423: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1424: CLOSE okl_k_lines_h_pk_csr;
1425: RETURN(l_okl_k_lines_h_rec);
1426: END get_rec;
1427:
1428: FUNCTION get_rec (
1421: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
1422: ;
1423: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1424: CLOSE okl_k_lines_h_pk_csr;
1425: RETURN(l_okl_k_lines_h_rec);
1426: END get_rec;
1427:
1428: FUNCTION get_rec (
1429: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type
1425: RETURN(l_okl_k_lines_h_rec);
1426: END get_rec;
1427:
1428: FUNCTION get_rec (
1429: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type
1430: ) RETURN okl_k_lines_h_rec_type IS
1431: l_row_notfound BOOLEAN := TRUE;
1432: BEGIN
1433: RETURN(get_rec(p_okl_k_lines_h_rec, l_row_notfound));
1426: END get_rec;
1427:
1428: FUNCTION get_rec (
1429: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type
1430: ) RETURN okl_k_lines_h_rec_type IS
1431: l_row_notfound BOOLEAN := TRUE;
1432: BEGIN
1433: RETURN(get_rec(p_okl_k_lines_h_rec, l_row_notfound));
1434: END get_rec;
1429: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type
1430: ) RETURN okl_k_lines_h_rec_type IS
1431: l_row_notfound BOOLEAN := TRUE;
1432: BEGIN
1433: RETURN(get_rec(p_okl_k_lines_h_rec, l_row_notfound));
1434: END get_rec;
1435:
1436:
1437: ---------------------------------------------------------------------------
2817: END migrate;
2818:
2819: PROCEDURE migrate (
2820: p_from IN kle_rec_type,
2821: p_to IN OUT NOCOPY okl_k_lines_h_rec_type
2822: ) IS
2823: BEGIN
2824:
2825: p_to.ID := p_from.ID;
3233: ---------------------------------------------------------------------------
3234:
3235:
3236: ------------------------------------
3237: -- insert_row for: OKL_K_LINES_H --
3238: ------------------------------------
3239:
3240: PROCEDURE insert_row(
3241:
3243: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3244: x_return_status OUT NOCOPY VARCHAR2,
3245: x_msg_count OUT NOCOPY NUMBER,
3246: x_msg_data OUT NOCOPY VARCHAR2,
3247: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3248: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type) IS
3249:
3250: l_api_version CONSTANT NUMBER := 1;
3251: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
3244: x_return_status OUT NOCOPY VARCHAR2,
3245: x_msg_count OUT NOCOPY NUMBER,
3246: x_msg_data OUT NOCOPY VARCHAR2,
3247: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3248: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type) IS
3249:
3250: l_api_version CONSTANT NUMBER := 1;
3251: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
3252: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3249:
3250: l_api_version CONSTANT NUMBER := 1;
3251: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
3252: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3253: l_okl_k_lines_h_rec okl_k_lines_h_rec_type := p_okl_k_lines_h_rec;
3254: l_def_okl_k_lines_h_rec okl_k_lines_h_rec_type;
3255: ----------------------------------------
3256: -- Set_Attributes for: OKL_K_LINES_H --
3257: ----------------------------------------
3250: l_api_version CONSTANT NUMBER := 1;
3251: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
3252: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3253: l_okl_k_lines_h_rec okl_k_lines_h_rec_type := p_okl_k_lines_h_rec;
3254: l_def_okl_k_lines_h_rec okl_k_lines_h_rec_type;
3255: ----------------------------------------
3256: -- Set_Attributes for: OKL_K_LINES_H --
3257: ----------------------------------------
3258: FUNCTION Set_Attributes (
3252: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3253: l_okl_k_lines_h_rec okl_k_lines_h_rec_type := p_okl_k_lines_h_rec;
3254: l_def_okl_k_lines_h_rec okl_k_lines_h_rec_type;
3255: ----------------------------------------
3256: -- Set_Attributes for: OKL_K_LINES_H --
3257: ----------------------------------------
3258: FUNCTION Set_Attributes (
3259: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3260: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type
3255: ----------------------------------------
3256: -- Set_Attributes for: OKL_K_LINES_H --
3257: ----------------------------------------
3258: FUNCTION Set_Attributes (
3259: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3260: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type
3261: ) RETURN VARCHAR2 IS
3262: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3263: BEGIN
3256: -- Set_Attributes for: OKL_K_LINES_H --
3257: ----------------------------------------
3258: FUNCTION Set_Attributes (
3259: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3260: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type
3261: ) RETURN VARCHAR2 IS
3262: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3263: BEGIN
3264: x_okl_k_lines_h_rec := p_okl_k_lines_h_rec;
3260: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type
3261: ) RETURN VARCHAR2 IS
3262: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3263: BEGIN
3264: x_okl_k_lines_h_rec := p_okl_k_lines_h_rec;
3265: RETURN(l_return_status);
3266: END Set_Attributes;
3267: BEGIN
3268:
3278: END IF;
3279:
3280: --- Setting item attributes
3281: l_return_status := Set_Attributes(
3282: p_okl_k_lines_h_rec, -- IN
3283: l_okl_k_lines_h_rec); -- OUT
3284: --- If any errors happen abort API
3285:
3286: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3279:
3280: --- Setting item attributes
3281: l_return_status := Set_Attributes(
3282: p_okl_k_lines_h_rec, -- IN
3283: l_okl_k_lines_h_rec); -- OUT
3284: --- If any errors happen abort API
3285:
3286: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3287: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3288: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3289: RAISE OKC_API.G_EXCEPTION_ERROR;
3290: END IF;
3291:
3292: INSERT INTO OKL_K_LINES_H(
3293: ID,
3294: MAJOR_VERSION,
3295: KLE_ID,
3296: STY_ID,
3437: DT_EFFECTIVE_BALANCE_LEGACY
3438:
3439: )
3440: VALUES (
3441: l_okl_k_lines_h_rec.ID,
3442: l_okl_k_lines_h_rec.MAJOR_VERSION,
3443: l_okl_k_lines_h_rec.KLE_ID,
3444: l_okl_k_lines_h_rec.STY_ID,
3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3438:
3439: )
3440: VALUES (
3441: l_okl_k_lines_h_rec.ID,
3442: l_okl_k_lines_h_rec.MAJOR_VERSION,
3443: l_okl_k_lines_h_rec.KLE_ID,
3444: l_okl_k_lines_h_rec.STY_ID,
3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3446: l_okl_k_lines_h_rec.LAO_AMOUNT,
3439: )
3440: VALUES (
3441: l_okl_k_lines_h_rec.ID,
3442: l_okl_k_lines_h_rec.MAJOR_VERSION,
3443: l_okl_k_lines_h_rec.KLE_ID,
3444: l_okl_k_lines_h_rec.STY_ID,
3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3446: l_okl_k_lines_h_rec.LAO_AMOUNT,
3447: l_okl_k_lines_h_rec.FEE_CHARGE,
3440: VALUES (
3441: l_okl_k_lines_h_rec.ID,
3442: l_okl_k_lines_h_rec.MAJOR_VERSION,
3443: l_okl_k_lines_h_rec.KLE_ID,
3444: l_okl_k_lines_h_rec.STY_ID,
3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3446: l_okl_k_lines_h_rec.LAO_AMOUNT,
3447: l_okl_k_lines_h_rec.FEE_CHARGE,
3448: l_okl_k_lines_h_rec.TITLE_DATE,
3441: l_okl_k_lines_h_rec.ID,
3442: l_okl_k_lines_h_rec.MAJOR_VERSION,
3443: l_okl_k_lines_h_rec.KLE_ID,
3444: l_okl_k_lines_h_rec.STY_ID,
3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3446: l_okl_k_lines_h_rec.LAO_AMOUNT,
3447: l_okl_k_lines_h_rec.FEE_CHARGE,
3448: l_okl_k_lines_h_rec.TITLE_DATE,
3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3442: l_okl_k_lines_h_rec.MAJOR_VERSION,
3443: l_okl_k_lines_h_rec.KLE_ID,
3444: l_okl_k_lines_h_rec.STY_ID,
3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3446: l_okl_k_lines_h_rec.LAO_AMOUNT,
3447: l_okl_k_lines_h_rec.FEE_CHARGE,
3448: l_okl_k_lines_h_rec.TITLE_DATE,
3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3443: l_okl_k_lines_h_rec.KLE_ID,
3444: l_okl_k_lines_h_rec.STY_ID,
3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3446: l_okl_k_lines_h_rec.LAO_AMOUNT,
3447: l_okl_k_lines_h_rec.FEE_CHARGE,
3448: l_okl_k_lines_h_rec.TITLE_DATE,
3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3444: l_okl_k_lines_h_rec.STY_ID,
3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3446: l_okl_k_lines_h_rec.LAO_AMOUNT,
3447: l_okl_k_lines_h_rec.FEE_CHARGE,
3448: l_okl_k_lines_h_rec.TITLE_DATE,
3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3446: l_okl_k_lines_h_rec.LAO_AMOUNT,
3447: l_okl_k_lines_h_rec.FEE_CHARGE,
3448: l_okl_k_lines_h_rec.TITLE_DATE,
3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3453: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3446: l_okl_k_lines_h_rec.LAO_AMOUNT,
3447: l_okl_k_lines_h_rec.FEE_CHARGE,
3448: l_okl_k_lines_h_rec.TITLE_DATE,
3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3453: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3454: l_okl_k_lines_h_rec.DATE_REMARKETED,
3447: l_okl_k_lines_h_rec.FEE_CHARGE,
3448: l_okl_k_lines_h_rec.TITLE_DATE,
3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3453: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3454: l_okl_k_lines_h_rec.DATE_REMARKETED,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3448: l_okl_k_lines_h_rec.TITLE_DATE,
3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3453: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3454: l_okl_k_lines_h_rec.DATE_REMARKETED,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3456: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3453: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3454: l_okl_k_lines_h_rec.DATE_REMARKETED,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3456: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3453: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3454: l_okl_k_lines_h_rec.DATE_REMARKETED,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3456: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3458: l_okl_k_lines_h_rec.GAIN_LOSS,
3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3453: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3454: l_okl_k_lines_h_rec.DATE_REMARKETED,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3456: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3458: l_okl_k_lines_h_rec.GAIN_LOSS,
3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3453: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3454: l_okl_k_lines_h_rec.DATE_REMARKETED,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3456: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3458: l_okl_k_lines_h_rec.GAIN_LOSS,
3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3453: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3454: l_okl_k_lines_h_rec.DATE_REMARKETED,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3456: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3458: l_okl_k_lines_h_rec.GAIN_LOSS,
3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3454: l_okl_k_lines_h_rec.DATE_REMARKETED,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3456: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3458: l_okl_k_lines_h_rec.GAIN_LOSS,
3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3456: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3458: l_okl_k_lines_h_rec.GAIN_LOSS,
3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3456: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3458: l_okl_k_lines_h_rec.GAIN_LOSS,
3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3458: l_okl_k_lines_h_rec.GAIN_LOSS,
3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3458: l_okl_k_lines_h_rec.GAIN_LOSS,
3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3468: l_okl_k_lines_h_rec.DELIVERED_DATE,
3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3468: l_okl_k_lines_h_rec.DELIVERED_DATE,
3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3468: l_okl_k_lines_h_rec.DELIVERED_DATE,
3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3468: l_okl_k_lines_h_rec.DELIVERED_DATE,
3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3471: l_okl_k_lines_h_rec.OCCUPANCY,
3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3468: l_okl_k_lines_h_rec.DELIVERED_DATE,
3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3471: l_okl_k_lines_h_rec.OCCUPANCY,
3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3468: l_okl_k_lines_h_rec.DELIVERED_DATE,
3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3471: l_okl_k_lines_h_rec.OCCUPANCY,
3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3468: l_okl_k_lines_h_rec.DELIVERED_DATE,
3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3471: l_okl_k_lines_h_rec.OCCUPANCY,
3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3468: l_okl_k_lines_h_rec.DELIVERED_DATE,
3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3471: l_okl_k_lines_h_rec.OCCUPANCY,
3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3468: l_okl_k_lines_h_rec.DELIVERED_DATE,
3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3471: l_okl_k_lines_h_rec.OCCUPANCY,
3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3471: l_okl_k_lines_h_rec.OCCUPANCY,
3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3477: l_okl_k_lines_h_rec.YEAR_BUILT,
3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3471: l_okl_k_lines_h_rec.OCCUPANCY,
3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3477: l_okl_k_lines_h_rec.YEAR_BUILT,
3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3471: l_okl_k_lines_h_rec.OCCUPANCY,
3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3477: l_okl_k_lines_h_rec.YEAR_BUILT,
3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3477: l_okl_k_lines_h_rec.YEAR_BUILT,
3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3480: l_okl_k_lines_h_rec.NET_RENTABLE,
3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3477: l_okl_k_lines_h_rec.YEAR_BUILT,
3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3480: l_okl_k_lines_h_rec.NET_RENTABLE,
3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3477: l_okl_k_lines_h_rec.YEAR_BUILT,
3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3480: l_okl_k_lines_h_rec.NET_RENTABLE,
3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3477: l_okl_k_lines_h_rec.YEAR_BUILT,
3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3480: l_okl_k_lines_h_rec.NET_RENTABLE,
3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3477: l_okl_k_lines_h_rec.YEAR_BUILT,
3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3480: l_okl_k_lines_h_rec.NET_RENTABLE,
3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3477: l_okl_k_lines_h_rec.YEAR_BUILT,
3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3480: l_okl_k_lines_h_rec.NET_RENTABLE,
3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3480: l_okl_k_lines_h_rec.NET_RENTABLE,
3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3486: l_okl_k_lines_h_rec.PERCENT,
3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3480: l_okl_k_lines_h_rec.NET_RENTABLE,
3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3486: l_okl_k_lines_h_rec.PERCENT,
3487: l_okl_k_lines_h_rec.COVERAGE,
3480: l_okl_k_lines_h_rec.NET_RENTABLE,
3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3486: l_okl_k_lines_h_rec.PERCENT,
3487: l_okl_k_lines_h_rec.COVERAGE,
3488: l_okl_k_lines_h_rec.LRV_AMOUNT,
3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3486: l_okl_k_lines_h_rec.PERCENT,
3487: l_okl_k_lines_h_rec.COVERAGE,
3488: l_okl_k_lines_h_rec.LRV_AMOUNT,
3489: l_okl_k_lines_h_rec.AMOUNT,
3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3486: l_okl_k_lines_h_rec.PERCENT,
3487: l_okl_k_lines_h_rec.COVERAGE,
3488: l_okl_k_lines_h_rec.LRV_AMOUNT,
3489: l_okl_k_lines_h_rec.AMOUNT,
3490: l_okl_k_lines_h_rec.LRS_PERCENT,
3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3486: l_okl_k_lines_h_rec.PERCENT,
3487: l_okl_k_lines_h_rec.COVERAGE,
3488: l_okl_k_lines_h_rec.LRV_AMOUNT,
3489: l_okl_k_lines_h_rec.AMOUNT,
3490: l_okl_k_lines_h_rec.LRS_PERCENT,
3491: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3486: l_okl_k_lines_h_rec.PERCENT,
3487: l_okl_k_lines_h_rec.COVERAGE,
3488: l_okl_k_lines_h_rec.LRV_AMOUNT,
3489: l_okl_k_lines_h_rec.AMOUNT,
3490: l_okl_k_lines_h_rec.LRS_PERCENT,
3491: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3492: l_okl_k_lines_h_rec.PERCENT_STAKE,
3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3486: l_okl_k_lines_h_rec.PERCENT,
3487: l_okl_k_lines_h_rec.COVERAGE,
3488: l_okl_k_lines_h_rec.LRV_AMOUNT,
3489: l_okl_k_lines_h_rec.AMOUNT,
3490: l_okl_k_lines_h_rec.LRS_PERCENT,
3491: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3492: l_okl_k_lines_h_rec.PERCENT_STAKE,
3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3486: l_okl_k_lines_h_rec.PERCENT,
3487: l_okl_k_lines_h_rec.COVERAGE,
3488: l_okl_k_lines_h_rec.LRV_AMOUNT,
3489: l_okl_k_lines_h_rec.AMOUNT,
3490: l_okl_k_lines_h_rec.LRS_PERCENT,
3491: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3492: l_okl_k_lines_h_rec.PERCENT_STAKE,
3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3494: l_okl_k_lines_h_rec.DATE_SOLD,
3487: l_okl_k_lines_h_rec.COVERAGE,
3488: l_okl_k_lines_h_rec.LRV_AMOUNT,
3489: l_okl_k_lines_h_rec.AMOUNT,
3490: l_okl_k_lines_h_rec.LRS_PERCENT,
3491: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3492: l_okl_k_lines_h_rec.PERCENT_STAKE,
3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3494: l_okl_k_lines_h_rec.DATE_SOLD,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,
3488: l_okl_k_lines_h_rec.LRV_AMOUNT,
3489: l_okl_k_lines_h_rec.AMOUNT,
3490: l_okl_k_lines_h_rec.LRS_PERCENT,
3491: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3492: l_okl_k_lines_h_rec.PERCENT_STAKE,
3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3494: l_okl_k_lines_h_rec.DATE_SOLD,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,
3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3489: l_okl_k_lines_h_rec.AMOUNT,
3490: l_okl_k_lines_h_rec.LRS_PERCENT,
3491: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3492: l_okl_k_lines_h_rec.PERCENT_STAKE,
3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3494: l_okl_k_lines_h_rec.DATE_SOLD,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,
3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3497: l_okl_k_lines_h_rec.ATTRIBUTE1,
3490: l_okl_k_lines_h_rec.LRS_PERCENT,
3491: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3492: l_okl_k_lines_h_rec.PERCENT_STAKE,
3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3494: l_okl_k_lines_h_rec.DATE_SOLD,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,
3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3497: l_okl_k_lines_h_rec.ATTRIBUTE1,
3498: l_okl_k_lines_h_rec.ATTRIBUTE2,
3491: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3492: l_okl_k_lines_h_rec.PERCENT_STAKE,
3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3494: l_okl_k_lines_h_rec.DATE_SOLD,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,
3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3497: l_okl_k_lines_h_rec.ATTRIBUTE1,
3498: l_okl_k_lines_h_rec.ATTRIBUTE2,
3499: l_okl_k_lines_h_rec.ATTRIBUTE3,
3492: l_okl_k_lines_h_rec.PERCENT_STAKE,
3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3494: l_okl_k_lines_h_rec.DATE_SOLD,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,
3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3497: l_okl_k_lines_h_rec.ATTRIBUTE1,
3498: l_okl_k_lines_h_rec.ATTRIBUTE2,
3499: l_okl_k_lines_h_rec.ATTRIBUTE3,
3500: l_okl_k_lines_h_rec.ATTRIBUTE4,
3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3494: l_okl_k_lines_h_rec.DATE_SOLD,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,
3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3497: l_okl_k_lines_h_rec.ATTRIBUTE1,
3498: l_okl_k_lines_h_rec.ATTRIBUTE2,
3499: l_okl_k_lines_h_rec.ATTRIBUTE3,
3500: l_okl_k_lines_h_rec.ATTRIBUTE4,
3501: l_okl_k_lines_h_rec.ATTRIBUTE5,
3494: l_okl_k_lines_h_rec.DATE_SOLD,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,
3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3497: l_okl_k_lines_h_rec.ATTRIBUTE1,
3498: l_okl_k_lines_h_rec.ATTRIBUTE2,
3499: l_okl_k_lines_h_rec.ATTRIBUTE3,
3500: l_okl_k_lines_h_rec.ATTRIBUTE4,
3501: l_okl_k_lines_h_rec.ATTRIBUTE5,
3502: l_okl_k_lines_h_rec.ATTRIBUTE6,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,
3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3497: l_okl_k_lines_h_rec.ATTRIBUTE1,
3498: l_okl_k_lines_h_rec.ATTRIBUTE2,
3499: l_okl_k_lines_h_rec.ATTRIBUTE3,
3500: l_okl_k_lines_h_rec.ATTRIBUTE4,
3501: l_okl_k_lines_h_rec.ATTRIBUTE5,
3502: l_okl_k_lines_h_rec.ATTRIBUTE6,
3503: l_okl_k_lines_h_rec.ATTRIBUTE7,
3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3497: l_okl_k_lines_h_rec.ATTRIBUTE1,
3498: l_okl_k_lines_h_rec.ATTRIBUTE2,
3499: l_okl_k_lines_h_rec.ATTRIBUTE3,
3500: l_okl_k_lines_h_rec.ATTRIBUTE4,
3501: l_okl_k_lines_h_rec.ATTRIBUTE5,
3502: l_okl_k_lines_h_rec.ATTRIBUTE6,
3503: l_okl_k_lines_h_rec.ATTRIBUTE7,
3504: l_okl_k_lines_h_rec.ATTRIBUTE8,
3497: l_okl_k_lines_h_rec.ATTRIBUTE1,
3498: l_okl_k_lines_h_rec.ATTRIBUTE2,
3499: l_okl_k_lines_h_rec.ATTRIBUTE3,
3500: l_okl_k_lines_h_rec.ATTRIBUTE4,
3501: l_okl_k_lines_h_rec.ATTRIBUTE5,
3502: l_okl_k_lines_h_rec.ATTRIBUTE6,
3503: l_okl_k_lines_h_rec.ATTRIBUTE7,
3504: l_okl_k_lines_h_rec.ATTRIBUTE8,
3505: l_okl_k_lines_h_rec.ATTRIBUTE9,
3498: l_okl_k_lines_h_rec.ATTRIBUTE2,
3499: l_okl_k_lines_h_rec.ATTRIBUTE3,
3500: l_okl_k_lines_h_rec.ATTRIBUTE4,
3501: l_okl_k_lines_h_rec.ATTRIBUTE5,
3502: l_okl_k_lines_h_rec.ATTRIBUTE6,
3503: l_okl_k_lines_h_rec.ATTRIBUTE7,
3504: l_okl_k_lines_h_rec.ATTRIBUTE8,
3505: l_okl_k_lines_h_rec.ATTRIBUTE9,
3506: l_okl_k_lines_h_rec.ATTRIBUTE10,
3499: l_okl_k_lines_h_rec.ATTRIBUTE3,
3500: l_okl_k_lines_h_rec.ATTRIBUTE4,
3501: l_okl_k_lines_h_rec.ATTRIBUTE5,
3502: l_okl_k_lines_h_rec.ATTRIBUTE6,
3503: l_okl_k_lines_h_rec.ATTRIBUTE7,
3504: l_okl_k_lines_h_rec.ATTRIBUTE8,
3505: l_okl_k_lines_h_rec.ATTRIBUTE9,
3506: l_okl_k_lines_h_rec.ATTRIBUTE10,
3507: l_okl_k_lines_h_rec.ATTRIBUTE11,
3500: l_okl_k_lines_h_rec.ATTRIBUTE4,
3501: l_okl_k_lines_h_rec.ATTRIBUTE5,
3502: l_okl_k_lines_h_rec.ATTRIBUTE6,
3503: l_okl_k_lines_h_rec.ATTRIBUTE7,
3504: l_okl_k_lines_h_rec.ATTRIBUTE8,
3505: l_okl_k_lines_h_rec.ATTRIBUTE9,
3506: l_okl_k_lines_h_rec.ATTRIBUTE10,
3507: l_okl_k_lines_h_rec.ATTRIBUTE11,
3508: l_okl_k_lines_h_rec.ATTRIBUTE12,
3501: l_okl_k_lines_h_rec.ATTRIBUTE5,
3502: l_okl_k_lines_h_rec.ATTRIBUTE6,
3503: l_okl_k_lines_h_rec.ATTRIBUTE7,
3504: l_okl_k_lines_h_rec.ATTRIBUTE8,
3505: l_okl_k_lines_h_rec.ATTRIBUTE9,
3506: l_okl_k_lines_h_rec.ATTRIBUTE10,
3507: l_okl_k_lines_h_rec.ATTRIBUTE11,
3508: l_okl_k_lines_h_rec.ATTRIBUTE12,
3509: l_okl_k_lines_h_rec.ATTRIBUTE13,
3502: l_okl_k_lines_h_rec.ATTRIBUTE6,
3503: l_okl_k_lines_h_rec.ATTRIBUTE7,
3504: l_okl_k_lines_h_rec.ATTRIBUTE8,
3505: l_okl_k_lines_h_rec.ATTRIBUTE9,
3506: l_okl_k_lines_h_rec.ATTRIBUTE10,
3507: l_okl_k_lines_h_rec.ATTRIBUTE11,
3508: l_okl_k_lines_h_rec.ATTRIBUTE12,
3509: l_okl_k_lines_h_rec.ATTRIBUTE13,
3510: l_okl_k_lines_h_rec.ATTRIBUTE14,
3503: l_okl_k_lines_h_rec.ATTRIBUTE7,
3504: l_okl_k_lines_h_rec.ATTRIBUTE8,
3505: l_okl_k_lines_h_rec.ATTRIBUTE9,
3506: l_okl_k_lines_h_rec.ATTRIBUTE10,
3507: l_okl_k_lines_h_rec.ATTRIBUTE11,
3508: l_okl_k_lines_h_rec.ATTRIBUTE12,
3509: l_okl_k_lines_h_rec.ATTRIBUTE13,
3510: l_okl_k_lines_h_rec.ATTRIBUTE14,
3511: l_okl_k_lines_h_rec.ATTRIBUTE15,
3504: l_okl_k_lines_h_rec.ATTRIBUTE8,
3505: l_okl_k_lines_h_rec.ATTRIBUTE9,
3506: l_okl_k_lines_h_rec.ATTRIBUTE10,
3507: l_okl_k_lines_h_rec.ATTRIBUTE11,
3508: l_okl_k_lines_h_rec.ATTRIBUTE12,
3509: l_okl_k_lines_h_rec.ATTRIBUTE13,
3510: l_okl_k_lines_h_rec.ATTRIBUTE14,
3511: l_okl_k_lines_h_rec.ATTRIBUTE15,
3512: l_okl_k_lines_h_rec.CREATED_BY,
3505: l_okl_k_lines_h_rec.ATTRIBUTE9,
3506: l_okl_k_lines_h_rec.ATTRIBUTE10,
3507: l_okl_k_lines_h_rec.ATTRIBUTE11,
3508: l_okl_k_lines_h_rec.ATTRIBUTE12,
3509: l_okl_k_lines_h_rec.ATTRIBUTE13,
3510: l_okl_k_lines_h_rec.ATTRIBUTE14,
3511: l_okl_k_lines_h_rec.ATTRIBUTE15,
3512: l_okl_k_lines_h_rec.CREATED_BY,
3513: l_okl_k_lines_h_rec.CREATION_DATE,
3506: l_okl_k_lines_h_rec.ATTRIBUTE10,
3507: l_okl_k_lines_h_rec.ATTRIBUTE11,
3508: l_okl_k_lines_h_rec.ATTRIBUTE12,
3509: l_okl_k_lines_h_rec.ATTRIBUTE13,
3510: l_okl_k_lines_h_rec.ATTRIBUTE14,
3511: l_okl_k_lines_h_rec.ATTRIBUTE15,
3512: l_okl_k_lines_h_rec.CREATED_BY,
3513: l_okl_k_lines_h_rec.CREATION_DATE,
3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3507: l_okl_k_lines_h_rec.ATTRIBUTE11,
3508: l_okl_k_lines_h_rec.ATTRIBUTE12,
3509: l_okl_k_lines_h_rec.ATTRIBUTE13,
3510: l_okl_k_lines_h_rec.ATTRIBUTE14,
3511: l_okl_k_lines_h_rec.ATTRIBUTE15,
3512: l_okl_k_lines_h_rec.CREATED_BY,
3513: l_okl_k_lines_h_rec.CREATION_DATE,
3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3508: l_okl_k_lines_h_rec.ATTRIBUTE12,
3509: l_okl_k_lines_h_rec.ATTRIBUTE13,
3510: l_okl_k_lines_h_rec.ATTRIBUTE14,
3511: l_okl_k_lines_h_rec.ATTRIBUTE15,
3512: l_okl_k_lines_h_rec.CREATED_BY,
3513: l_okl_k_lines_h_rec.CREATION_DATE,
3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3509: l_okl_k_lines_h_rec.ATTRIBUTE13,
3510: l_okl_k_lines_h_rec.ATTRIBUTE14,
3511: l_okl_k_lines_h_rec.ATTRIBUTE15,
3512: l_okl_k_lines_h_rec.CREATED_BY,
3513: l_okl_k_lines_h_rec.CREATION_DATE,
3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3517: l_okl_k_lines_h_rec.NTY_CODE,
3510: l_okl_k_lines_h_rec.ATTRIBUTE14,
3511: l_okl_k_lines_h_rec.ATTRIBUTE15,
3512: l_okl_k_lines_h_rec.CREATED_BY,
3513: l_okl_k_lines_h_rec.CREATION_DATE,
3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3517: l_okl_k_lines_h_rec.NTY_CODE,
3518: l_okl_k_lines_h_rec.FCG_CODE,
3511: l_okl_k_lines_h_rec.ATTRIBUTE15,
3512: l_okl_k_lines_h_rec.CREATED_BY,
3513: l_okl_k_lines_h_rec.CREATION_DATE,
3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3517: l_okl_k_lines_h_rec.NTY_CODE,
3518: l_okl_k_lines_h_rec.FCG_CODE,
3519: l_okl_k_lines_h_rec.PRC_CODE,
3512: l_okl_k_lines_h_rec.CREATED_BY,
3513: l_okl_k_lines_h_rec.CREATION_DATE,
3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3517: l_okl_k_lines_h_rec.NTY_CODE,
3518: l_okl_k_lines_h_rec.FCG_CODE,
3519: l_okl_k_lines_h_rec.PRC_CODE,
3520: l_okl_k_lines_h_rec.RE_LEASE_YN,
3513: l_okl_k_lines_h_rec.CREATION_DATE,
3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3517: l_okl_k_lines_h_rec.NTY_CODE,
3518: l_okl_k_lines_h_rec.FCG_CODE,
3519: l_okl_k_lines_h_rec.PRC_CODE,
3520: l_okl_k_lines_h_rec.RE_LEASE_YN,
3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3517: l_okl_k_lines_h_rec.NTY_CODE,
3518: l_okl_k_lines_h_rec.FCG_CODE,
3519: l_okl_k_lines_h_rec.PRC_CODE,
3520: l_okl_k_lines_h_rec.RE_LEASE_YN,
3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3517: l_okl_k_lines_h_rec.NTY_CODE,
3518: l_okl_k_lines_h_rec.FCG_CODE,
3519: l_okl_k_lines_h_rec.PRC_CODE,
3520: l_okl_k_lines_h_rec.RE_LEASE_YN,
3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3517: l_okl_k_lines_h_rec.NTY_CODE,
3518: l_okl_k_lines_h_rec.FCG_CODE,
3519: l_okl_k_lines_h_rec.PRC_CODE,
3520: l_okl_k_lines_h_rec.RE_LEASE_YN,
3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3524: l_okl_k_lines_h_rec.CLG_ID,
3517: l_okl_k_lines_h_rec.NTY_CODE,
3518: l_okl_k_lines_h_rec.FCG_CODE,
3519: l_okl_k_lines_h_rec.PRC_CODE,
3520: l_okl_k_lines_h_rec.RE_LEASE_YN,
3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3524: l_okl_k_lines_h_rec.CLG_ID,
3525: l_okl_k_lines_h_rec.DATE_FUNDING,
3518: l_okl_k_lines_h_rec.FCG_CODE,
3519: l_okl_k_lines_h_rec.PRC_CODE,
3520: l_okl_k_lines_h_rec.RE_LEASE_YN,
3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3524: l_okl_k_lines_h_rec.CLG_ID,
3525: l_okl_k_lines_h_rec.DATE_FUNDING,
3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3519: l_okl_k_lines_h_rec.PRC_CODE,
3520: l_okl_k_lines_h_rec.RE_LEASE_YN,
3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3524: l_okl_k_lines_h_rec.CLG_ID,
3525: l_okl_k_lines_h_rec.DATE_FUNDING,
3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3520: l_okl_k_lines_h_rec.RE_LEASE_YN,
3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3524: l_okl_k_lines_h_rec.CLG_ID,
3525: l_okl_k_lines_h_rec.DATE_FUNDING,
3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3524: l_okl_k_lines_h_rec.CLG_ID,
3525: l_okl_k_lines_h_rec.DATE_FUNDING,
3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3529: l_okl_k_lines_h_rec.OEC,
3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3524: l_okl_k_lines_h_rec.CLG_ID,
3525: l_okl_k_lines_h_rec.DATE_FUNDING,
3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3529: l_okl_k_lines_h_rec.OEC,
3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3524: l_okl_k_lines_h_rec.CLG_ID,
3525: l_okl_k_lines_h_rec.DATE_FUNDING,
3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3529: l_okl_k_lines_h_rec.OEC,
3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3524: l_okl_k_lines_h_rec.CLG_ID,
3525: l_okl_k_lines_h_rec.DATE_FUNDING,
3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3529: l_okl_k_lines_h_rec.OEC,
3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3525: l_okl_k_lines_h_rec.DATE_FUNDING,
3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3529: l_okl_k_lines_h_rec.OEC,
3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3533: l_okl_k_lines_h_rec.RVI_PREMIUM,
3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3529: l_okl_k_lines_h_rec.OEC,
3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3533: l_okl_k_lines_h_rec.RVI_PREMIUM,
3534: l_okl_k_lines_h_rec.CREDIT_NATURE,
3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3529: l_okl_k_lines_h_rec.OEC,
3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3533: l_okl_k_lines_h_rec.RVI_PREMIUM,
3534: l_okl_k_lines_h_rec.CREDIT_NATURE,
3535: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3529: l_okl_k_lines_h_rec.OEC,
3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3533: l_okl_k_lines_h_rec.RVI_PREMIUM,
3534: l_okl_k_lines_h_rec.CREDIT_NATURE,
3535: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3536: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3529: l_okl_k_lines_h_rec.OEC,
3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3533: l_okl_k_lines_h_rec.RVI_PREMIUM,
3534: l_okl_k_lines_h_rec.CREDIT_NATURE,
3535: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3536: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3537: --Bug# 2697681 11.5.9
3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3533: l_okl_k_lines_h_rec.RVI_PREMIUM,
3534: l_okl_k_lines_h_rec.CREDIT_NATURE,
3535: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3536: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3537: --Bug# 2697681 11.5.9
3538: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3533: l_okl_k_lines_h_rec.RVI_PREMIUM,
3534: l_okl_k_lines_h_rec.CREDIT_NATURE,
3535: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3536: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3537: --Bug# 2697681 11.5.9
3538: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3539: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3533: l_okl_k_lines_h_rec.RVI_PREMIUM,
3534: l_okl_k_lines_h_rec.CREDIT_NATURE,
3535: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3536: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3537: --Bug# 2697681 11.5.9
3538: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3539: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3540: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3534: l_okl_k_lines_h_rec.CREDIT_NATURE,
3535: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3536: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3537: --Bug# 2697681 11.5.9
3538: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3539: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3540: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3541: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3542: --financed fees
3535: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3536: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3537: --Bug# 2697681 11.5.9
3538: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3539: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3540: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3541: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3542: --financed fees
3543: l_okl_k_lines_h_rec.FEE_TYPE,
3536: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3537: --Bug# 2697681 11.5.9
3538: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3539: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3540: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3541: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3542: --financed fees
3543: l_okl_k_lines_h_rec.FEE_TYPE,
3544: --Bug# 3143522: 11.5.10
3537: --Bug# 2697681 11.5.9
3538: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3539: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3540: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3541: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3542: --financed fees
3543: l_okl_k_lines_h_rec.FEE_TYPE,
3544: --Bug# 3143522: 11.5.10
3545: --subsidy
3539: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3540: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3541: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3542: --financed fees
3543: l_okl_k_lines_h_rec.FEE_TYPE,
3544: --Bug# 3143522: 11.5.10
3545: --subsidy
3546: l_okl_k_lines_h_rec.SUBSIDY_ID,
3547: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3542: --financed fees
3543: l_okl_k_lines_h_rec.FEE_TYPE,
3544: --Bug# 3143522: 11.5.10
3545: --subsidy
3546: l_okl_k_lines_h_rec.SUBSIDY_ID,
3547: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3548: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3549: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3550: --financed fee
3543: l_okl_k_lines_h_rec.FEE_TYPE,
3544: --Bug# 3143522: 11.5.10
3545: --subsidy
3546: l_okl_k_lines_h_rec.SUBSIDY_ID,
3547: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3548: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3549: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3550: --financed fee
3551: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3544: --Bug# 3143522: 11.5.10
3545: --subsidy
3546: l_okl_k_lines_h_rec.SUBSIDY_ID,
3547: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3548: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3549: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3550: --financed fee
3551: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3552: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3545: --subsidy
3546: l_okl_k_lines_h_rec.SUBSIDY_ID,
3547: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3548: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3549: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3550: --financed fee
3551: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3552: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3553: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3547: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3548: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3549: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3550: --financed fee
3551: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3552: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3553: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3554: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3555: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3548: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3549: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3550: --financed fee
3551: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3552: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3553: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3554: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3555: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3556: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3549: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3550: --financed fee
3551: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3552: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3553: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3554: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3555: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3556: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3557: --quote
3550: --financed fee
3551: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3552: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3553: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3554: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3555: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3556: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3557: --quote
3558: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3551: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3552: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3553: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3554: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3555: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3556: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3557: --quote
3558: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3559: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3552: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3553: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3554: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3555: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3556: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3557: --quote
3558: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3559: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3560: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3554: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3555: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3556: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3557: --quote
3558: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3559: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3560: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3561: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3562: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3555: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3556: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3557: --quote
3558: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3559: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3560: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3561: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3562: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3563: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3556: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3557: --quote
3558: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3559: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3560: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3561: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3562: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3563: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3564: --Bug#2994971
3557: --quote
3558: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3559: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3560: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3561: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3562: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3563: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3564: --Bug#2994971
3565: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3558: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3559: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3560: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3561: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3562: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3563: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3564: --Bug#2994971
3565: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3566: --Bug# 3973640: 11.5.10+
3559: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3560: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3561: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3562: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3563: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3564: --Bug#2994971
3565: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3566: --Bug# 3973640: 11.5.10+
3567: l_okl_k_lines_h_rec.QTE_ID,
3561: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3562: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3563: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3564: --Bug#2994971
3565: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3566: --Bug# 3973640: 11.5.10+
3567: l_okl_k_lines_h_rec.QTE_ID,
3568: l_okl_k_lines_h_rec.FUNDING_DATE,
3569: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3563: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3564: --Bug#2994971
3565: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3566: --Bug# 3973640: 11.5.10+
3567: l_okl_k_lines_h_rec.QTE_ID,
3568: l_okl_k_lines_h_rec.FUNDING_DATE,
3569: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3570: --Bug# 4419339 OKLH
3571: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3564: --Bug#2994971
3565: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3566: --Bug# 3973640: 11.5.10+
3567: l_okl_k_lines_h_rec.QTE_ID,
3568: l_okl_k_lines_h_rec.FUNDING_DATE,
3569: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3570: --Bug# 4419339 OKLH
3571: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3572: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3565: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3566: --Bug# 3973640: 11.5.10+
3567: l_okl_k_lines_h_rec.QTE_ID,
3568: l_okl_k_lines_h_rec.FUNDING_DATE,
3569: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3570: --Bug# 4419339 OKLH
3571: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3572: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3573: l_okl_k_lines_h_rec.MODEL_NUMBER,
3567: l_okl_k_lines_h_rec.QTE_ID,
3568: l_okl_k_lines_h_rec.FUNDING_DATE,
3569: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3570: --Bug# 4419339 OKLH
3571: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3572: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3573: l_okl_k_lines_h_rec.MODEL_NUMBER,
3574: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3575: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3568: l_okl_k_lines_h_rec.FUNDING_DATE,
3569: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3570: --Bug# 4419339 OKLH
3571: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3572: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3573: l_okl_k_lines_h_rec.MODEL_NUMBER,
3574: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3575: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3576: --Bug#4373029
3569: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3570: --Bug# 4419339 OKLH
3571: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3572: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3573: l_okl_k_lines_h_rec.MODEL_NUMBER,
3574: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3575: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3576: --Bug#4373029
3577: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3570: --Bug# 4419339 OKLH
3571: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3572: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3573: l_okl_k_lines_h_rec.MODEL_NUMBER,
3574: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3575: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3576: --Bug#4373029
3577: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3578: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3571: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3572: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3573: l_okl_k_lines_h_rec.MODEL_NUMBER,
3574: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3575: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3576: --Bug#4373029
3577: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3578: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3579: --Bug# 4631549
3573: l_okl_k_lines_h_rec.MODEL_NUMBER,
3574: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3575: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3576: --Bug#4373029
3577: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3578: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3579: --Bug# 4631549
3580: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
3581: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
3574: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3575: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3576: --Bug#4373029
3577: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3578: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3579: --Bug# 4631549
3580: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
3581: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
3582: --Bug# 16344245
3576: --Bug#4373029
3577: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3578: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3579: --Bug# 4631549
3580: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
3581: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
3582: --Bug# 16344245
3583: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
3584: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
3577: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3578: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3579: --Bug# 4631549
3580: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
3581: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
3582: --Bug# 16344245
3583: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
3584: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
3585: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
3579: --Bug# 4631549
3580: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
3581: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
3582: --Bug# 16344245
3583: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
3584: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
3585: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
3586:
3587: );
3580: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,
3581: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
3582: --Bug# 16344245
3583: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
3584: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
3585: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
3586:
3587: );
3588: -- Set OUT values
3581: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,
3582: --Bug# 16344245
3583: l_okl_k_lines_h_rec.ORIGINATION_INCOME,
3584: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,
3585: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
3586:
3587: );
3588: -- Set OUT values
3589: x_okl_k_lines_h_rec := l_okl_k_lines_h_rec;
3585: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY
3586:
3587: );
3588: -- Set OUT values
3589: x_okl_k_lines_h_rec := l_okl_k_lines_h_rec;
3590: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3591:
3592: EXCEPTION
3593: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4557: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4558: l_kle_rec kle_rec_type := p_kle_rec;
4559: l_def_kle_rec kle_rec_type;
4560: l_row_notfound BOOLEAN := TRUE;
4561: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
4562: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;
4563: ----------------------------------
4564: -- FUNCTION populate_new_record --
4565: ----------------------------------
4558: l_kle_rec kle_rec_type := p_kle_rec;
4559: l_def_kle_rec kle_rec_type;
4560: l_row_notfound BOOLEAN := TRUE;
4561: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
4562: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;
4563: ----------------------------------
4564: -- FUNCTION populate_new_record --
4565: ----------------------------------
4566: FUNCTION populate_new_record (
4579: END IF;
4580: -- Move the "old" record to the history record:
4581: -- (1) to get the "old" version
4582: -- (2) to avoid 2 hits to the database
4583: migrate(l_kle_rec, l_okl_k_lines_h_rec);
4584:
4585: IF (x_kle_rec.ID = OKC_API.G_MISS_NUM) THEN
4586: x_kle_rec.ID := l_kle_rec.ID;
4587: END IF;
5312: p_init_msg_list,
5313: x_return_status,
5314: x_msg_count,
5315: x_msg_data,
5316: l_okl_k_lines_h_rec,
5317: lx_okl_k_lines_h_rec
5318: );
5319:
5320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5313: x_return_status,
5314: x_msg_count,
5315: x_msg_data,
5316: l_okl_k_lines_h_rec,
5317: lx_okl_k_lines_h_rec
5318: );
5319:
5320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5321: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6156: l_api_name CONSTANT VARCHAR2(30) := 'rec_delete_row';
6157: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6158: l_kle_rec kle_rec_type:= p_kle_rec;
6159: l_row_notfound BOOLEAN := TRUE;
6160: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
6161: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;
6162: BEGIN
6163: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
6164: p_init_msg_list,
6157: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6158: l_kle_rec kle_rec_type:= p_kle_rec;
6159: l_row_notfound BOOLEAN := TRUE;
6160: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
6161: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;
6162: BEGIN
6163: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
6164: p_init_msg_list,
6165: '_PVT',
6176: l_kle_rec := get_rec(l_kle_rec, l_row_notfound);
6177: IF (l_row_notfound) THEN
6178: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6179: END IF;
6180: migrate(l_kle_rec, l_okl_k_lines_h_rec);
6181: insert_row(
6182: l_api_version,
6183: p_init_msg_list,
6184: x_return_status,
6183: p_init_msg_list,
6184: x_return_status,
6185: x_msg_count,
6186: x_msg_data,
6187: l_okl_k_lines_h_rec,
6188: lx_okl_k_lines_h_rec
6189: );
6190:
6191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6184: x_return_status,
6185: x_msg_count,
6186: x_msg_data,
6187: l_okl_k_lines_h_rec,
6188: lx_okl_k_lines_h_rec
6189: );
6190:
6191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6192: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6399:
6400: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
6401:
6402: BEGIN
6403: INSERT INTO OKL_K_LINES_H
6404: (
6405: major_version,
6406: ID,
6407: KLE_ID,
7015: ORIGINATION_INCOME,
7016: AMOUNT_BALANCE_LEGACY,
7017: DT_EFFECTIVE_BALANCE_LEGACY
7018:
7019: FROM OKL_K_LINES_H
7020: WHERE id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id) and major_version = p_major_version;
7021:
7022:
7023: RETURN l_return_status;