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

APPS.OKL_KLE_PVT dependencies on OKL_K_LINES

Line 12: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_K_LINES_V';

8:
9:
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_K_LINES_V';
13:
14: G_EXCEPTION_HALT_VALIDATION exception;
15:
16:

Line 343: l_desc_flex_name VARCHAR2(30) := 'OKL_K_LINES_DF';

339: l_segment_values_rec Okl_DFlex_Util_Pvt.DFF_Rec_type;
340: l_msg_count NUMBER;
341: l_msg_data VARCHAR2(2000);
342: l_appl_short_name VARCHAR2(30) := 'OKL';
343: l_desc_flex_name VARCHAR2(30) := 'OKL_K_LINES_DF';
344: l_segment_partial_name VARCHAR2(30) := 'ATTRIBUTE';
345: Begin
346: -- initialize return status
347: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 574: -- Validate_Attributes for: OKL_K_LINES_V --

570: ,p_token2_value => SQLERRM);
571: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
572: end validate_subsidy_id;
573: ---------------------------------------------
574: -- Validate_Attributes for: OKL_K_LINES_V --
575: ---------------------------------------------
576: FUNCTION Validate_Attributes (
577: p_klev_rec IN klev_rec_type
578: ) RETURN VARCHAR2 IS

Line 790: -- FUNCTION get_rec for: OKL_K_LINES

786: END api_copy;
787:
788:
789: ---------------------------------------------------------------------------
790: -- FUNCTION get_rec for: OKL_K_LINES
791: ---------------------------------------------------------------------------
792: FUNCTION get_rec (
793: p_kle_rec IN kle_rec_type,
794: x_no_data_found OUT NOCOPY BOOLEAN

Line 796: CURSOR okl_k_lines_pk_csr (p_id IN NUMBER) IS

792: FUNCTION get_rec (
793: p_kle_rec IN kle_rec_type,
794: x_no_data_found OUT NOCOPY BOOLEAN
795: ) RETURN kle_rec_type IS
796: CURSOR okl_k_lines_pk_csr (p_id IN NUMBER) IS
797: SELECT
798: ID,
799: KLE_ID,
800: STY_ID,

Line 943: FROM OKL_K_LINES

939: ORIGINATION_INCOME,
940: AMOUNT_BALANCE_LEGACY,
941: DT_EFFECTIVE_BALANCE_LEGACY
942:
943: FROM OKL_K_LINES
944: WHERE OKL_K_LINES.id = p_id;
945: l_okl_k_lines_pk okl_k_lines_pk_csr%ROWTYPE;
946: l_kle_rec kle_rec_type;
947: BEGIN

Line 944: WHERE OKL_K_LINES.id = p_id;

940: AMOUNT_BALANCE_LEGACY,
941: DT_EFFECTIVE_BALANCE_LEGACY
942:
943: FROM OKL_K_LINES
944: WHERE OKL_K_LINES.id = p_id;
945: l_okl_k_lines_pk okl_k_lines_pk_csr%ROWTYPE;
946: l_kle_rec kle_rec_type;
947: BEGIN
948:

Line 945: l_okl_k_lines_pk okl_k_lines_pk_csr%ROWTYPE;

941: DT_EFFECTIVE_BALANCE_LEGACY
942:
943: FROM OKL_K_LINES
944: WHERE OKL_K_LINES.id = p_id;
945: l_okl_k_lines_pk okl_k_lines_pk_csr%ROWTYPE;
946: l_kle_rec kle_rec_type;
947: BEGIN
948:
949: x_no_data_found := TRUE;

Line 951: OPEN okl_k_lines_pk_csr (p_kle_rec.id);

947: BEGIN
948:
949: x_no_data_found := TRUE;
950: -- Get current database values
951: OPEN okl_k_lines_pk_csr (p_kle_rec.id);
952: FETCH okl_k_lines_pk_csr INTO
953: l_kle_rec.ID,
954: l_kle_rec.KLE_ID,
955: l_kle_rec.STY_ID,

Line 952: FETCH okl_k_lines_pk_csr INTO

948:
949: x_no_data_found := TRUE;
950: -- Get current database values
951: OPEN okl_k_lines_pk_csr (p_kle_rec.id);
952: FETCH okl_k_lines_pk_csr INTO
953: l_kle_rec.ID,
954: l_kle_rec.KLE_ID,
955: l_kle_rec.STY_ID,
956: l_kle_rec.OBJECT_VERSION_NUMBER,

Line 1098: x_no_data_found := okl_k_lines_pk_csr%NOTFOUND;

1094: l_kle_rec.ORIGINATION_INCOME,
1095: l_kle_rec.AMOUNT_BALANCE_LEGACY,
1096: l_kle_rec.DT_EFFECTIVE_BALANCE_LEGACY
1097: ;
1098: x_no_data_found := okl_k_lines_pk_csr%NOTFOUND;
1099: CLOSE okl_k_lines_pk_csr;
1100: RETURN(l_kle_rec);
1101: END get_rec;
1102:

Line 1099: CLOSE okl_k_lines_pk_csr;

1095: l_kle_rec.AMOUNT_BALANCE_LEGACY,
1096: l_kle_rec.DT_EFFECTIVE_BALANCE_LEGACY
1097: ;
1098: x_no_data_found := okl_k_lines_pk_csr%NOTFOUND;
1099: CLOSE okl_k_lines_pk_csr;
1100: RETURN(l_kle_rec);
1101: END get_rec;
1102:
1103: FUNCTION get_rec (

Line 1113: -- FUNCTION get_rec for: OKL_K_LINES_H

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

Line 1116: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,

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

Line 1118: ) RETURN okl_k_lines_h_rec_type IS

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,

Line 1119: CURSOR okl_k_lines_h_pk_csr (p_id IN NUMBER) IS

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,

Line 1267: FROM OKL_K_LINES_H

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

Line 1268: WHERE OKL_K_LINES_H.id = p_id;

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:

Line 1269: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;

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;

Line 1270: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;

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

Line 1275: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);

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,

Line 1276: FETCH okl_k_lines_h_pk_csr INTO

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,

Line 1277: l_okl_k_lines_h_rec.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,

Line 1278: l_okl_k_lines_h_rec.MAJOR_VERSION,

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,

Line 1279: l_okl_k_lines_h_rec.KLE_ID,

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,

Line 1280: l_okl_k_lines_h_rec.STY_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,
1284: l_okl_k_lines_h_rec.TITLE_DATE,

Line 1281: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,

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,

Line 1282: l_okl_k_lines_h_rec.LAO_AMOUNT,

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,

Line 1283: l_okl_k_lines_h_rec.FEE_CHARGE,

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,

Line 1284: l_okl_k_lines_h_rec.TITLE_DATE,

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,

Line 1285: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,

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,

Line 1286: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,

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,

Line 1287: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_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,
1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,

Line 1288: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,

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,

Line 1289: l_okl_k_lines_h_rec.REMARKETED_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,

Line 1290: l_okl_k_lines_h_rec.DATE_REMARKETED,

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,

Line 1291: l_okl_k_lines_h_rec.REMARKET_MARGIN,

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,

Line 1292: l_okl_k_lines_h_rec.REPURCHASED_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,

Line 1293: l_okl_k_lines_h_rec.DATE_REPURCHASED,

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,

Line 1294: l_okl_k_lines_h_rec.GAIN_LOSS,

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,

Line 1295: l_okl_k_lines_h_rec.FLOOR_AMOUNT,

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,

Line 1296: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,

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,

Line 1297: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,

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,

Line 1298: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,

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,

Line 1299: l_okl_k_lines_h_rec.ESTIMATED_OEC,

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,

Line 1300: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,

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,

Line 1301: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,

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,

Line 1302: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,

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,

Line 1303: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,

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,

Line 1304: l_okl_k_lines_h_rec.DELIVERED_DATE,

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,

Line 1305: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,

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,

Line 1306: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,

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,

Line 1307: l_okl_k_lines_h_rec.OCCUPANCY,

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,

Line 1308: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,

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,

Line 1309: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,

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,

Line 1310: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,

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,

Line 1311: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,

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,

Line 1312: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,

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,

Line 1313: l_okl_k_lines_h_rec.YEAR_BUILT,

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,

Line 1314: l_okl_k_lines_h_rec.COVERAGE_RATIO,

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,

Line 1315: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,

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,

Line 1316: l_okl_k_lines_h_rec.NET_RENTABLE,

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,

Line 1317: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,

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,

Line 1318: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,

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,

Line 1319: l_okl_k_lines_h_rec.DATE_APPRAISAL,

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,

Line 1320: l_okl_k_lines_h_rec.APPRAISAL_VALUE,

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,

Line 1321: l_okl_k_lines_h_rec.RESIDUAL_VALUE,

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,

Line 1322: l_okl_k_lines_h_rec.PERCENT,

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,

Line 1323: l_okl_k_lines_h_rec.COVERAGE,

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,

Line 1324: l_okl_k_lines_h_rec.LRV_AMOUNT,

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,

Line 1325: l_okl_k_lines_h_rec.AMOUNT,

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,

Line 1326: l_okl_k_lines_h_rec.LRS_PERCENT,

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,

Line 1327: l_okl_k_lines_h_rec.EVERGREEN_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,
1331: l_okl_k_lines_h_rec.STY_ID_FOR,

Line 1328: l_okl_k_lines_h_rec.PERCENT_STAKE,

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,

Line 1329: l_okl_k_lines_h_rec.AMOUNT_STAKE,

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,

Line 1330: l_okl_k_lines_h_rec.DATE_SOLD,

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,

Line 1331: l_okl_k_lines_h_rec.STY_ID_FOR,

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,

Line 1332: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,

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,

Line 1333: l_okl_k_lines_h_rec.ATTRIBUTE1,

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,

Line 1334: l_okl_k_lines_h_rec.ATTRIBUTE2,

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,

Line 1335: l_okl_k_lines_h_rec.ATTRIBUTE3,

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,

Line 1336: l_okl_k_lines_h_rec.ATTRIBUTE4,

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,

Line 1337: l_okl_k_lines_h_rec.ATTRIBUTE5,

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,

Line 1338: l_okl_k_lines_h_rec.ATTRIBUTE6,

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,

Line 1339: l_okl_k_lines_h_rec.ATTRIBUTE7,

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,

Line 1340: l_okl_k_lines_h_rec.ATTRIBUTE8,

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,

Line 1341: l_okl_k_lines_h_rec.ATTRIBUTE9,

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,

Line 1342: l_okl_k_lines_h_rec.ATTRIBUTE10,

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,

Line 1343: l_okl_k_lines_h_rec.ATTRIBUTE11,

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,

Line 1344: l_okl_k_lines_h_rec.ATTRIBUTE12,

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,

Line 1345: l_okl_k_lines_h_rec.ATTRIBUTE13,

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,

Line 1346: l_okl_k_lines_h_rec.ATTRIBUTE14,

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,

Line 1347: l_okl_k_lines_h_rec.ATTRIBUTE15,

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,

Line 1348: l_okl_k_lines_h_rec.CREATED_BY,

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,

Line 1349: l_okl_k_lines_h_rec.CREATION_DATE,

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,

Line 1350: l_okl_k_lines_h_rec.LAST_UPDATED_BY,

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,

Line 1351: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,

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,

Line 1352: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,

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,

Line 1353: l_okl_k_lines_h_rec.NTY_CODE,

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,

Line 1354: l_okl_k_lines_h_rec.FCG_CODE,

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,

Line 1355: l_okl_k_lines_h_rec.PRC_CODE,

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,

Line 1356: l_okl_k_lines_h_rec.RE_LEASE_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,

Line 1357: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,

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,

Line 1358: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,

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,

Line 1359: l_okl_k_lines_h_rec.SECURED_DEAL_YN,

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,

Line 1360: l_okl_k_lines_h_rec.CLG_ID,

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,

Line 1361: l_okl_k_lines_h_rec.DATE_FUNDING,

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,

Line 1362: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,

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,

Line 1363: l_okl_k_lines_h_rec.DATE_ACCEPTED,

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,

Line 1364: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,

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,

Line 1365: l_okl_k_lines_h_rec.OEC,

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,

Line 1366: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,

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,

Line 1367: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,

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,

Line 1368: l_okl_k_lines_h_rec.RESIDUAL_CODE,

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,

Line 1369: l_okl_k_lines_h_rec.RVI_PREMIUM,

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

Line 1370: l_okl_k_lines_h_rec.CREDIT_NATURE,

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,

Line 1371: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,

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,

Line 1372: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,

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,

Line 1374: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,

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

Line 1375: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,

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,

Line 1376: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,

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

Line 1377: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,

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

Line 1379: l_okl_k_lines_h_rec.FEE_TYPE,

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,

Line 1382: l_okl_k_lines_h_rec.SUBSIDY_ID,

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

Line 1383: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,

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,

Line 1384: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,

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,

Line 1385: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,

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,

Line 1387: l_okl_k_lines_h_rec.PRE_TAX_YIELD,

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,

Line 1388: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,

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,

Line 1389: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,

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

Line 1390: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,

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,

Line 1391: l_okl_k_lines_h_rec.PRE_TAX_IRR,

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,

Line 1392: l_okl_k_lines_h_rec.AFTER_TAX_IRR,

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,

Line 1394: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,

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,

Line 1395: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,

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,

Line 1396: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,

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

Line 1397: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,

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,

Line 1398: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,

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+

Line 1399: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,

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,

Line 1401: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,

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,

Line 1403: l_okl_k_lines_h_rec.QTE_ID,

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,

Line 1404: l_okl_k_lines_h_rec.FUNDING_DATE,

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,

Line 1405: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,

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,

Line 1407: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,

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,

Line 1408: l_okl_k_lines_h_rec.MANUFACTURER_NAME,

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

Line 1409: l_okl_k_lines_h_rec.MODEL_NUMBER,

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,

Line 1410: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_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,

Line 1411: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,

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

Line 1413: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,

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,

Line 1414: l_okl_k_lines_h_rec.TERMINATION_VALUE,

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

Line 1416: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,

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,

Line 1417: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,

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

Line 1419: l_okl_k_lines_h_rec.ORIGINATION_INCOME,

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;

Line 1420: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,

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;

Line 1421: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY

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

Line 1423: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;

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:

Line 1424: CLOSE okl_k_lines_h_pk_csr;

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 (

Line 1425: RETURN(l_okl_k_lines_h_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

Line 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));

Line 1430: ) RETURN okl_k_lines_h_rec_type IS

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;

Line 1433: RETURN(get_rec(p_okl_k_lines_h_rec, l_row_notfound));

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

Line 1438: -- FUNCTION get_rec for: OKL_K_LINES_V

1434: END get_rec;
1435:
1436:
1437: ---------------------------------------------------------------------------
1438: -- FUNCTION get_rec for: OKL_K_LINES_V
1439: ---------------------------------------------------------------------------
1440: FUNCTION get_rec (
1441: p_klev_rec IN klev_rec_type,
1442: x_no_data_found OUT NOCOPY BOOLEAN

Line 1444: CURSOR okl_k_lines_v_pk_csr (p_id IN NUMBER) IS

1440: FUNCTION get_rec (
1441: p_klev_rec IN klev_rec_type,
1442: x_no_data_found OUT NOCOPY BOOLEAN
1443: ) RETURN klev_rec_type IS
1444: CURSOR okl_k_lines_v_pk_csr (p_id IN NUMBER) IS
1445: SELECT
1446: ID,
1447: OBJECT_VERSION_NUMBER,
1448: KLE_ID,

Line 1593: FROM OKL_K_LINES_V

1589: --Bug# 16344245
1590: AMOUNT_BALANCE_LEGACY,
1591: DT_EFFECTIVE_BALANCE_LEGACY
1592:
1593: FROM OKL_K_LINES_V
1594: WHERE OKL_K_LINES_V.id = p_id;
1595: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1596: l_klev_rec klev_rec_type;
1597: BEGIN

Line 1594: WHERE OKL_K_LINES_V.id = p_id;

1590: AMOUNT_BALANCE_LEGACY,
1591: DT_EFFECTIVE_BALANCE_LEGACY
1592:
1593: FROM OKL_K_LINES_V
1594: WHERE OKL_K_LINES_V.id = p_id;
1595: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1596: l_klev_rec klev_rec_type;
1597: BEGIN
1598:

Line 1595: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;

1591: DT_EFFECTIVE_BALANCE_LEGACY
1592:
1593: FROM OKL_K_LINES_V
1594: WHERE OKL_K_LINES_V.id = p_id;
1595: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1596: l_klev_rec klev_rec_type;
1597: BEGIN
1598:
1599: x_no_data_found := TRUE;

Line 1601: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);

1597: BEGIN
1598:
1599: x_no_data_found := TRUE;
1600: -- Get current database values
1601: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);
1602: FETCH okl_k_lines_v_pk_csr INTO
1603: l_klev_rec.ID,
1604: l_klev_rec.OBJECT_VERSION_NUMBER,
1605: l_klev_rec.KLE_ID,

Line 1602: FETCH okl_k_lines_v_pk_csr INTO

1598:
1599: x_no_data_found := TRUE;
1600: -- Get current database values
1601: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);
1602: FETCH okl_k_lines_v_pk_csr INTO
1603: l_klev_rec.ID,
1604: l_klev_rec.OBJECT_VERSION_NUMBER,
1605: l_klev_rec.KLE_ID,
1606: l_klev_rec.STY_ID,

Line 1750: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;

1746: l_klev_rec.AMOUNT_BALANCE_LEGACY,
1747: l_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY
1748:
1749: ;
1750: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;
1751: CLOSE okl_k_lines_v_pk_csr;
1752: RETURN(l_klev_rec);
1753: END get_rec;
1754:

Line 1751: CLOSE okl_k_lines_v_pk_csr;

1747: l_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY
1748:
1749: ;
1750: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;
1751: CLOSE okl_k_lines_v_pk_csr;
1752: RETURN(l_klev_rec);
1753: END get_rec;
1754:
1755: FUNCTION get_rec (

Line 1765: -- FUNCTION null_out_defaults for: OKL_K_LINES_V --

1761: END get_rec;
1762:
1763:
1764: -----------------------------------------------------
1765: -- FUNCTION null_out_defaults for: OKL_K_LINES_V --
1766: -----------------------------------------------------
1767: FUNCTION null_out_defaults (
1768: p_klev_rec IN klev_rec_type
1769: ) RETURN klev_rec_type IS

Line 2302: -- Validate_Record for: OKL_K_LINES_V --

2298: ---------------------------------------------------------------------------
2299:
2300:
2301: -----------------------------------------
2302: -- Validate_Record for: OKL_K_LINES_V --
2303: -----------------------------------------
2304: FUNCTION Validate_Record (
2305: p_klev_rec IN klev_rec_type
2306: ) RETURN VARCHAR2 IS

Line 2821: p_to IN OUT NOCOPY okl_k_lines_h_rec_type

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;

Line 3074: -- validate_row for: OKL_K_LINES_V --

3070: -- PROCEDURE validate_row
3071: ---------------------------------------------------------------------------
3072:
3073: --------------------------------------
3074: -- validate_row for: OKL_K_LINES_V --
3075: --------------------------------------
3076:
3077: PROCEDURE validate_row(
3078:

Line 3162: -- PL/SQL TBL validate_row for: OKL_K_LINES_V --

3158: );
3159:
3160: END validate_row;
3161: ------------------------------------------
3162: -- PL/SQL TBL validate_row for: OKL_K_LINES_V --
3163: ------------------------------------------
3164:
3165: PROCEDURE validate_row(
3166:

Line 3237: -- insert_row for: OKL_K_LINES_H --

3233: ---------------------------------------------------------------------------
3234:
3235:
3236: ------------------------------------
3237: -- insert_row for: OKL_K_LINES_H --
3238: ------------------------------------
3239:
3240: PROCEDURE insert_row(
3241:

Line 3247: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,

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

Line 3248: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type) IS

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;

Line 3253: l_okl_k_lines_h_rec okl_k_lines_h_rec_type := p_okl_k_lines_h_rec;

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

Line 3254: l_def_okl_k_lines_h_rec okl_k_lines_h_rec_type;

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 (

Line 3256: -- Set_Attributes for: OKL_K_LINES_H --

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

Line 3259: p_okl_k_lines_h_rec IN 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

Line 3260: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type

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;

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

Line 3282: p_okl_k_lines_h_rec, -- IN

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

Line 3283: l_okl_k_lines_h_rec); -- OUT

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;

Line 3292: INSERT INTO OKL_K_LINES_H(

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,

Line 3441: l_okl_k_lines_h_rec.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,

Line 3442: l_okl_k_lines_h_rec.MAJOR_VERSION,

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,

Line 3443: l_okl_k_lines_h_rec.KLE_ID,

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,

Line 3444: l_okl_k_lines_h_rec.STY_ID,

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,

Line 3445: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,

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,

Line 3446: l_okl_k_lines_h_rec.LAO_AMOUNT,

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,

Line 3447: l_okl_k_lines_h_rec.FEE_CHARGE,

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,

Line 3448: l_okl_k_lines_h_rec.TITLE_DATE,

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,

Line 3449: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,

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,

Line 3450: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,

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,

Line 3451: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_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,
3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,

Line 3452: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,

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,

Line 3453: l_okl_k_lines_h_rec.REMARKETED_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,

Line 3454: l_okl_k_lines_h_rec.DATE_REMARKETED,

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,

Line 3455: l_okl_k_lines_h_rec.REMARKET_MARGIN,

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,

Line 3456: l_okl_k_lines_h_rec.REPURCHASED_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,

Line 3457: l_okl_k_lines_h_rec.DATE_REPURCHASED,

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,

Line 3458: l_okl_k_lines_h_rec.GAIN_LOSS,

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,

Line 3459: l_okl_k_lines_h_rec.FLOOR_AMOUNT,

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,

Line 3460: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,

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,

Line 3461: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,

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,

Line 3462: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,

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,

Line 3463: l_okl_k_lines_h_rec.ESTIMATED_OEC,

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,

Line 3464: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,

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,

Line 3465: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,

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,

Line 3466: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,

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,

Line 3467: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,

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,

Line 3468: l_okl_k_lines_h_rec.DELIVERED_DATE,

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,

Line 3469: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,

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,

Line 3470: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,

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,

Line 3471: l_okl_k_lines_h_rec.OCCUPANCY,

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,

Line 3472: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,

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,

Line 3473: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,

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,

Line 3474: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,

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,

Line 3475: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,

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,

Line 3476: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,

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,

Line 3477: l_okl_k_lines_h_rec.YEAR_BUILT,

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,

Line 3478: l_okl_k_lines_h_rec.COVERAGE_RATIO,

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,

Line 3479: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,

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,

Line 3480: l_okl_k_lines_h_rec.NET_RENTABLE,

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,

Line 3481: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,

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,

Line 3482: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,

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,

Line 3483: l_okl_k_lines_h_rec.DATE_APPRAISAL,

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,

Line 3484: l_okl_k_lines_h_rec.APPRAISAL_VALUE,

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,

Line 3485: l_okl_k_lines_h_rec.RESIDUAL_VALUE,

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,

Line 3486: l_okl_k_lines_h_rec.PERCENT,

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,

Line 3487: l_okl_k_lines_h_rec.COVERAGE,

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,

Line 3488: l_okl_k_lines_h_rec.LRV_AMOUNT,

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,

Line 3489: l_okl_k_lines_h_rec.AMOUNT,

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,

Line 3490: l_okl_k_lines_h_rec.LRS_PERCENT,

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,

Line 3491: l_okl_k_lines_h_rec.EVERGREEN_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,
3495: l_okl_k_lines_h_rec.STY_ID_FOR,

Line 3492: l_okl_k_lines_h_rec.PERCENT_STAKE,

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,

Line 3493: l_okl_k_lines_h_rec.AMOUNT_STAKE,

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,

Line 3494: l_okl_k_lines_h_rec.DATE_SOLD,

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,

Line 3495: l_okl_k_lines_h_rec.STY_ID_FOR,

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,

Line 3496: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,

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,

Line 3497: l_okl_k_lines_h_rec.ATTRIBUTE1,

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,

Line 3498: l_okl_k_lines_h_rec.ATTRIBUTE2,

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,

Line 3499: l_okl_k_lines_h_rec.ATTRIBUTE3,

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,

Line 3500: l_okl_k_lines_h_rec.ATTRIBUTE4,

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,

Line 3501: l_okl_k_lines_h_rec.ATTRIBUTE5,

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,

Line 3502: l_okl_k_lines_h_rec.ATTRIBUTE6,

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,

Line 3503: l_okl_k_lines_h_rec.ATTRIBUTE7,

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,

Line 3504: l_okl_k_lines_h_rec.ATTRIBUTE8,

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,

Line 3505: l_okl_k_lines_h_rec.ATTRIBUTE9,

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,

Line 3506: l_okl_k_lines_h_rec.ATTRIBUTE10,

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,

Line 3507: l_okl_k_lines_h_rec.ATTRIBUTE11,

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,

Line 3508: l_okl_k_lines_h_rec.ATTRIBUTE12,

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,

Line 3509: l_okl_k_lines_h_rec.ATTRIBUTE13,

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,

Line 3510: l_okl_k_lines_h_rec.ATTRIBUTE14,

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,

Line 3511: l_okl_k_lines_h_rec.ATTRIBUTE15,

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,

Line 3512: l_okl_k_lines_h_rec.CREATED_BY,

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,

Line 3513: l_okl_k_lines_h_rec.CREATION_DATE,

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,

Line 3514: l_okl_k_lines_h_rec.LAST_UPDATED_BY,

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,

Line 3515: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,

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,

Line 3516: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,

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,

Line 3517: l_okl_k_lines_h_rec.NTY_CODE,

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,

Line 3518: l_okl_k_lines_h_rec.FCG_CODE,

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,

Line 3519: l_okl_k_lines_h_rec.PRC_CODE,

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,

Line 3520: l_okl_k_lines_h_rec.RE_LEASE_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,

Line 3521: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,

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,

Line 3522: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,

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,

Line 3523: l_okl_k_lines_h_rec.SECURED_DEAL_YN,

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,

Line 3524: l_okl_k_lines_h_rec.CLG_ID,

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,

Line 3525: l_okl_k_lines_h_rec.DATE_FUNDING,

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,

Line 3526: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,

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,

Line 3527: l_okl_k_lines_h_rec.DATE_ACCEPTED,

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,

Line 3528: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,

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,

Line 3529: l_okl_k_lines_h_rec.OEC,

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,

Line 3530: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,

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,

Line 3531: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,

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,

Line 3532: l_okl_k_lines_h_rec.RESIDUAL_CODE,

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,

Line 3533: l_okl_k_lines_h_rec.RVI_PREMIUM,

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

Line 3534: l_okl_k_lines_h_rec.CREDIT_NATURE,

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,

Line 3535: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,

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,

Line 3536: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,

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,

Line 3538: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,

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

Line 3539: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,

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,

Line 3540: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,

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

Line 3541: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,

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

Line 3543: l_okl_k_lines_h_rec.FEE_TYPE,

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,

Line 3546: l_okl_k_lines_h_rec.SUBSIDY_ID,

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

Line 3547: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,

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,

Line 3548: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,

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,

Line 3549: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,

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,

Line 3551: l_okl_k_lines_h_rec.PRE_TAX_YIELD,

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,

Line 3552: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,

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,

Line 3553: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,

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

Line 3554: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,

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,

Line 3555: l_okl_k_lines_h_rec.PRE_TAX_IRR,

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,

Line 3556: l_okl_k_lines_h_rec.AFTER_TAX_IRR,

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,

Line 3558: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,

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,

Line 3559: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,

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,

Line 3560: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,

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

Line 3561: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,

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,

Line 3562: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,

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+

Line 3563: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,

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,

Line 3565: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,

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,

Line 3567: l_okl_k_lines_h_rec.QTE_ID,

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,

Line 3568: l_okl_k_lines_h_rec.FUNDING_DATE,

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,

Line 3569: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,

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,

Line 3571: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,

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,

Line 3572: l_okl_k_lines_h_rec.MANUFACTURER_NAME,

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

Line 3573: l_okl_k_lines_h_rec.MODEL_NUMBER,

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,

Line 3574: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_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,

Line 3575: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,

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

Line 3577: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,

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,

Line 3578: l_okl_k_lines_h_rec.TERMINATION_VALUE,

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

Line 3580: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST,

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,

Line 3581: l_okl_k_lines_h_rec.ORIG_CONTRACT_LINE_ID,

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

Line 3583: l_okl_k_lines_h_rec.ORIGINATION_INCOME,

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: );

Line 3584: l_okl_k_lines_h_rec.AMOUNT_BALANCE_LEGACY,

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

Line 3585: l_okl_k_lines_h_rec.DT_EFFECTIVE_BALANCE_LEGACY

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;

Line 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

Line 3627: -- insert_row for: OKL_K_LINES --

3623:
3624: END insert_row;
3625:
3626: ------------------------------------
3627: -- insert_row for: OKL_K_LINES --
3628: ------------------------------------
3629:
3630: PROCEDURE insert_row(
3631:

Line 3646: -- Set_Attributes for: OKL_K_LINES --

3642: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3643: l_kle_rec kle_rec_type := p_kle_rec;
3644: l_def_kle_rec kle_rec_type;
3645: ----------------------------------------
3646: -- Set_Attributes for: OKL_K_LINES --
3647: ----------------------------------------
3648: FUNCTION Set_Attributes (
3649: p_kle_rec IN kle_rec_type,
3650: x_kle_rec OUT NOCOPY kle_rec_type

Line 3689: INSERT INTO OKL_K_LINES(

3685: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3686: RAISE OKC_API.G_EXCEPTION_ERROR;
3687: END IF;
3688:
3689: INSERT INTO OKL_K_LINES(
3690: ID,
3691: KLE_ID,
3692: STY_ID,
3693: OBJECT_VERSION_NUMBER,

Line 4024: -- insert_row for: OKL_K_LINES_V --

4020:
4021: END insert_row;
4022:
4023: ------------------------------------
4024: -- insert_row for: OKL_K_LINES_V --
4025: ------------------------------------
4026:
4027: PROCEDURE insert_row(
4028:

Line 4060: -- Set_Attributes for: OKL_K_LINES_V --

4056: l_klev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4057: RETURN(l_klev_rec);
4058: END fill_who_columns;
4059: ----------------------------------------
4060: -- Set_Attributes for: OKL_K_LINES_V --
4061: ----------------------------------------
4062: FUNCTION Set_Attributes (
4063: p_klev_rec IN klev_rec_type,
4064: x_klev_rec OUT NOCOPY klev_rec_type

Line 4189: -- PL/SQL TBL insert_row for: OKL_K_LINES_V --

4185:
4186: END insert_row;
4187:
4188: ----------------------------------------
4189: -- PL/SQL TBL insert_row for: OKL_K_LINES_V --
4190: ----------------------------------------
4191:
4192: PROCEDURE insert_row(
4193:

Line 4265: -- lock_row for: OKL_K_LINES --

4261: -- PROCEDURE lock_row
4262: ---------------------------------------------------------------------------
4263:
4264: --------------------------------
4265: -- lock_row for: OKL_K_LINES --
4266: --------------------------------
4267:
4268: PROCEDURE lock_row(
4269:

Line 4281: FROM OKL_K_LINES

4277: E_Resource_Busy EXCEPTION;
4278: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
4279: CURSOR lock_csr (p_kle_rec IN kle_rec_type) IS
4280: SELECT OBJECT_VERSION_NUMBER
4281: FROM OKL_K_LINES
4282: WHERE ID = p_kle_rec.id
4283: AND OBJECT_VERSION_NUMBER = p_kle_rec.object_version_number
4284: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
4285:

Line 4288: FROM OKL_K_LINES

4284: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
4285:
4286: CURSOR lchk_csr (p_kle_rec IN kle_rec_type) IS
4287: SELECT OBJECT_VERSION_NUMBER
4288: FROM OKL_K_LINES
4289: WHERE ID = p_kle_rec.id;
4290: l_api_version CONSTANT NUMBER := 1;
4291: l_api_name CONSTANT VARCHAR2(30) := 'rec_lock_row';
4292: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4293: l_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;

4289: WHERE ID = p_kle_rec.id;
4290: l_api_version CONSTANT NUMBER := 1;
4291: l_api_name CONSTANT VARCHAR2(30) := 'rec_lock_row';
4292: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4293: l_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;
4294: lc_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;
4295: l_row_notfound BOOLEAN := FALSE;
4296: lc_row_notfound BOOLEAN := FALSE;
4297: BEGIN

Line 4294: lc_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;

4290: l_api_version CONSTANT NUMBER := 1;
4291: l_api_name CONSTANT VARCHAR2(30) := 'rec_lock_row';
4292: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4293: l_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;
4294: lc_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;
4295: l_row_notfound BOOLEAN := FALSE;
4296: lc_row_notfound BOOLEAN := FALSE;
4297: BEGIN
4298: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4379: -- lock_row for: OKL_K_LINES_V --

4375:
4376: END lock_row;
4377:
4378: ----------------------------------
4379: -- lock_row for: OKL_K_LINES_V --
4380: ----------------------------------
4381:
4382: PROCEDURE lock_row(
4383:

Line 4468: -- PL/SQL TBL lock_row for: OKL_K_LINES_V --

4464: );
4465:
4466: END lock_row;
4467: --------------------------------------
4468: -- PL/SQL TBL lock_row for: OKL_K_LINES_V --
4469: --------------------------------------
4470:
4471: PROCEDURE lock_row(
4472:

Line 4542: -- update_row for: OKL_K_LINES --

4538: -- PROCEDURE update_row
4539: ---------------------------------------------------------------------------
4540:
4541: ----------------------------------
4542: -- update_row for: OKL_K_LINES --
4543: ----------------------------------
4544:
4545: PROCEDURE update_row(
4546:

Line 4561: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;

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

Line 4562: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;

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 (

Line 4583: migrate(l_kle_rec, l_okl_k_lines_h_rec);

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;

Line 5108: -- Set_Attributes for: OKL_K_LINES --

5104:
5105: RETURN(l_return_status);
5106: END populate_new_record;
5107: --------------------------------------
5108: -- Set_Attributes for: OKL_K_LINES --
5109: --------------------------------------
5110: FUNCTION Set_Attributes (
5111: p_kle_rec IN kle_rec_type,
5112: x_kle_rec OUT NOCOPY kle_rec_type

Line 5158: UPDATE OKL_K_LINES

5154: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5155: RAISE OKC_API.G_EXCEPTION_ERROR;
5156: END IF;
5157:
5158: UPDATE OKL_K_LINES
5159: SET
5160: ID = l_def_kle_rec.ID,
5161: KLE_ID = l_def_kle_rec.KLE_ID,
5162: STY_ID = l_def_kle_rec.STY_ID,

Line 5316: l_okl_k_lines_h_rec,

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

Line 5317: lx_okl_k_lines_h_rec

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;

Line 5365: -- update_row for: OKL_K_LINES_V --

5361:
5362: END update_row;
5363:
5364: ------------------------------------
5365: -- update_row for: OKL_K_LINES_V --
5366: ------------------------------------
5367:
5368: PROCEDURE update_row(
5369:

Line 5938: -- Set_Attributes for: OKL_K_LINES_V --

5934:
5935: RETURN(l_return_status);
5936: END populate_new_record;
5937: ----------------------------------------
5938: -- Set_Attributes for: OKL_K_LINES_V --
5939: ----------------------------------------
5940: FUNCTION Set_Attributes (
5941: p_klev_rec IN klev_rec_type,
5942: x_klev_rec OUT NOCOPY klev_rec_type

Line 6066: -- PL/SQL TBL update_row for: OKL_K_LINES_V --

6062: );
6063:
6064: END update_row;
6065: ----------------------------------------
6066: -- PL/SQL TBL update_row for: OKL_K_LINES_V --
6067: ----------------------------------------
6068:
6069: PROCEDURE update_row(
6070:

Line 6143: -- delete_row for: OKL_K_LINES --

6139: -- PROCEDURE delete_row
6140: ---------------------------------------------------------------------------
6141:
6142: ----------------------------------
6143: -- delete_row for: OKL_K_LINES --
6144: ----------------------------------
6145:
6146: PROCEDURE delete_row(
6147:

Line 6160: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;

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,

Line 6161: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;

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

Line 6180: migrate(l_kle_rec, l_okl_k_lines_h_rec);

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,

Line 6187: l_okl_k_lines_h_rec,

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

Line 6188: lx_okl_k_lines_h_rec

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;

Line 6197: DELETE FROM OKL_K_LINES

6193: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6194: RAISE OKC_API.G_EXCEPTION_ERROR;
6195: END IF;
6196: */
6197: DELETE FROM OKL_K_LINES
6198: WHERE ID = l_kle_rec.id;
6199:
6200: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
6201:

Line 6323: -- PL/SQL TBL delete_row for: OKL_K_LINES_V --

6319: );
6320:
6321: END delete_row;
6322: ----------------------------------------
6323: -- PL/SQL TBL delete_row for: OKL_K_LINES_V --
6324: ----------------------------------------
6325:
6326: PROCEDURE delete_row(
6327:

Line 6403: INSERT INTO OKL_K_LINES_H

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,

Line 6698: FROM OKL_K_LINES

6694: ORIGINATION_INCOME,
6695: AMOUNT_BALANCE_LEGACY,
6696: DT_EFFECTIVE_BALANCE_LEGACY
6697:
6698: FROM OKL_K_LINES
6699: WHERE id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);
6700:
6701: RETURN l_return_status;
6702: EXCEPTION

Line 6725: INSERT INTO OKL_K_LINES

6721:
6722: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
6723:
6724: BEGIN
6725: INSERT INTO OKL_K_LINES
6726: (
6727: ID,
6728: KLE_ID,
6729: STY_ID,

Line 7019: FROM OKL_K_LINES_H

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;