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 295: l_desc_flex_name VARCHAR2(30) := 'OKL_K_LINES_DF';

291: l_segment_values_rec Okl_DFlex_Util_Pvt.DFF_Rec_type;
292: l_msg_count NUMBER;
293: l_msg_data VARCHAR2(2000);
294: l_appl_short_name VARCHAR2(30) := 'OKL';
295: l_desc_flex_name VARCHAR2(30) := 'OKL_K_LINES_DF';
296: l_segment_partial_name VARCHAR2(30) := 'ATTRIBUTE';
297: Begin
298: -- initialize return status
299: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 526: -- Validate_Attributes for: OKL_K_LINES_V --

522: ,p_token2_value => SQLERRM);
523: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
524: end validate_subsidy_id;
525: ---------------------------------------------
526: -- Validate_Attributes for: OKL_K_LINES_V --
527: ---------------------------------------------
528: FUNCTION Validate_Attributes (
529: p_klev_rec IN klev_rec_type
530: ) RETURN VARCHAR2 IS

Line 727: -- FUNCTION get_rec for: OKL_K_LINES

723: END api_copy;
724:
725:
726: ---------------------------------------------------------------------------
727: -- FUNCTION get_rec for: OKL_K_LINES
728: ---------------------------------------------------------------------------
729: FUNCTION get_rec (
730: p_kle_rec IN kle_rec_type,
731: x_no_data_found OUT NOCOPY BOOLEAN

Line 733: CURSOR okl_k_lines_pk_csr (p_id IN NUMBER) IS

729: FUNCTION get_rec (
730: p_kle_rec IN kle_rec_type,
731: x_no_data_found OUT NOCOPY BOOLEAN
732: ) RETURN kle_rec_type IS
733: CURSOR okl_k_lines_pk_csr (p_id IN NUMBER) IS
734: SELECT
735: ID,
736: KLE_ID,
737: STY_ID,

Line 875: FROM OKL_K_LINES

871: TERMINATION_VALUE,
872: --Bug# 4631549
873: EXPECTED_ASSET_COST
874:
875: FROM OKL_K_LINES
876: WHERE OKL_K_LINES.id = p_id;
877: l_okl_k_lines_pk okl_k_lines_pk_csr%ROWTYPE;
878: l_kle_rec kle_rec_type;
879: BEGIN

Line 876: WHERE OKL_K_LINES.id = p_id;

872: --Bug# 4631549
873: EXPECTED_ASSET_COST
874:
875: FROM OKL_K_LINES
876: WHERE OKL_K_LINES.id = p_id;
877: l_okl_k_lines_pk okl_k_lines_pk_csr%ROWTYPE;
878: l_kle_rec kle_rec_type;
879: BEGIN
880:

Line 877: l_okl_k_lines_pk okl_k_lines_pk_csr%ROWTYPE;

873: EXPECTED_ASSET_COST
874:
875: FROM OKL_K_LINES
876: WHERE OKL_K_LINES.id = p_id;
877: l_okl_k_lines_pk okl_k_lines_pk_csr%ROWTYPE;
878: l_kle_rec kle_rec_type;
879: BEGIN
880:
881: x_no_data_found := TRUE;

Line 883: OPEN okl_k_lines_pk_csr (p_kle_rec.id);

879: BEGIN
880:
881: x_no_data_found := TRUE;
882: -- Get current database values
883: OPEN okl_k_lines_pk_csr (p_kle_rec.id);
884: FETCH okl_k_lines_pk_csr INTO
885: l_kle_rec.ID,
886: l_kle_rec.KLE_ID,
887: l_kle_rec.STY_ID,

Line 884: FETCH okl_k_lines_pk_csr INTO

880:
881: x_no_data_found := TRUE;
882: -- Get current database values
883: OPEN okl_k_lines_pk_csr (p_kle_rec.id);
884: FETCH okl_k_lines_pk_csr INTO
885: l_kle_rec.ID,
886: l_kle_rec.KLE_ID,
887: l_kle_rec.STY_ID,
888: l_kle_rec.OBJECT_VERSION_NUMBER,

Line 1025: x_no_data_found := okl_k_lines_pk_csr%NOTFOUND;

1021: l_kle_rec.TERMINATION_VALUE,
1022: --Bug# 457760
1023: l_kle_rec.EXPECTED_ASSET_COST
1024: ;
1025: x_no_data_found := okl_k_lines_pk_csr%NOTFOUND;
1026: CLOSE okl_k_lines_pk_csr;
1027: RETURN(l_kle_rec);
1028: END get_rec;
1029:

Line 1026: CLOSE okl_k_lines_pk_csr;

1022: --Bug# 457760
1023: l_kle_rec.EXPECTED_ASSET_COST
1024: ;
1025: x_no_data_found := okl_k_lines_pk_csr%NOTFOUND;
1026: CLOSE okl_k_lines_pk_csr;
1027: RETURN(l_kle_rec);
1028: END get_rec;
1029:
1030: FUNCTION get_rec (

Line 1040: -- FUNCTION get_rec for: OKL_K_LINES_H

1036: END get_rec;
1037:
1038:
1039: ---------------------------------------------------------------------------
1040: -- FUNCTION get_rec for: OKL_K_LINES_H
1041: ---------------------------------------------------------------------------
1042: FUNCTION get_rec (
1043: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
1044: x_no_data_found OUT NOCOPY BOOLEAN

Line 1043: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,

1039: ---------------------------------------------------------------------------
1040: -- FUNCTION get_rec for: OKL_K_LINES_H
1041: ---------------------------------------------------------------------------
1042: FUNCTION get_rec (
1043: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
1044: x_no_data_found OUT NOCOPY BOOLEAN
1045: ) RETURN okl_k_lines_h_rec_type IS
1046: CURSOR okl_k_lines_h_pk_csr (p_id IN NUMBER) IS
1047: SELECT

Line 1045: ) RETURN okl_k_lines_h_rec_type IS

1041: ---------------------------------------------------------------------------
1042: FUNCTION get_rec (
1043: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
1044: x_no_data_found OUT NOCOPY BOOLEAN
1045: ) RETURN okl_k_lines_h_rec_type IS
1046: CURSOR okl_k_lines_h_pk_csr (p_id IN NUMBER) IS
1047: SELECT
1048: ID,
1049: MAJOR_VERSION,

Line 1046: CURSOR okl_k_lines_h_pk_csr (p_id IN NUMBER) IS

1042: FUNCTION get_rec (
1043: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
1044: x_no_data_found OUT NOCOPY BOOLEAN
1045: ) RETURN okl_k_lines_h_rec_type IS
1046: CURSOR okl_k_lines_h_pk_csr (p_id IN NUMBER) IS
1047: SELECT
1048: ID,
1049: MAJOR_VERSION,
1050: KLE_ID,

Line 1189: FROM OKL_K_LINES_H

1185: TERMINATION_VALUE,
1186: --Bug# 4631549
1187: EXPECTED_ASSET_COST
1188:
1189: FROM OKL_K_LINES_H
1190: WHERE OKL_K_LINES_H.id = p_id;
1191: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;
1192: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
1193: BEGIN

Line 1190: WHERE OKL_K_LINES_H.id = p_id;

1186: --Bug# 4631549
1187: EXPECTED_ASSET_COST
1188:
1189: FROM OKL_K_LINES_H
1190: WHERE OKL_K_LINES_H.id = p_id;
1191: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;
1192: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
1193: BEGIN
1194:

Line 1191: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;

1187: EXPECTED_ASSET_COST
1188:
1189: FROM OKL_K_LINES_H
1190: WHERE OKL_K_LINES_H.id = p_id;
1191: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;
1192: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
1193: BEGIN
1194:
1195: x_no_data_found := TRUE;

Line 1192: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;

1188:
1189: FROM OKL_K_LINES_H
1190: WHERE OKL_K_LINES_H.id = p_id;
1191: l_okl_k_lines_h_pk okl_k_lines_h_pk_csr%ROWTYPE;
1192: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
1193: BEGIN
1194:
1195: x_no_data_found := TRUE;
1196: -- Get current database values

Line 1197: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);

1193: BEGIN
1194:
1195: x_no_data_found := TRUE;
1196: -- Get current database values
1197: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1198: FETCH okl_k_lines_h_pk_csr INTO
1199: l_okl_k_lines_h_rec.ID,
1200: l_okl_k_lines_h_rec.MAJOR_VERSION,
1201: l_okl_k_lines_h_rec.KLE_ID,

Line 1198: FETCH okl_k_lines_h_pk_csr INTO

1194:
1195: x_no_data_found := TRUE;
1196: -- Get current database values
1197: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1198: FETCH okl_k_lines_h_pk_csr INTO
1199: l_okl_k_lines_h_rec.ID,
1200: l_okl_k_lines_h_rec.MAJOR_VERSION,
1201: l_okl_k_lines_h_rec.KLE_ID,
1202: l_okl_k_lines_h_rec.STY_ID,

Line 1199: l_okl_k_lines_h_rec.ID,

1195: x_no_data_found := TRUE;
1196: -- Get current database values
1197: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1198: FETCH okl_k_lines_h_pk_csr INTO
1199: l_okl_k_lines_h_rec.ID,
1200: l_okl_k_lines_h_rec.MAJOR_VERSION,
1201: l_okl_k_lines_h_rec.KLE_ID,
1202: l_okl_k_lines_h_rec.STY_ID,
1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,

Line 1200: l_okl_k_lines_h_rec.MAJOR_VERSION,

1196: -- Get current database values
1197: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1198: FETCH okl_k_lines_h_pk_csr INTO
1199: l_okl_k_lines_h_rec.ID,
1200: l_okl_k_lines_h_rec.MAJOR_VERSION,
1201: l_okl_k_lines_h_rec.KLE_ID,
1202: l_okl_k_lines_h_rec.STY_ID,
1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1204: l_okl_k_lines_h_rec.LAO_AMOUNT,

Line 1201: l_okl_k_lines_h_rec.KLE_ID,

1197: OPEN okl_k_lines_h_pk_csr (p_okl_k_lines_h_rec.id);
1198: FETCH okl_k_lines_h_pk_csr INTO
1199: l_okl_k_lines_h_rec.ID,
1200: l_okl_k_lines_h_rec.MAJOR_VERSION,
1201: l_okl_k_lines_h_rec.KLE_ID,
1202: l_okl_k_lines_h_rec.STY_ID,
1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1204: l_okl_k_lines_h_rec.LAO_AMOUNT,
1205: l_okl_k_lines_h_rec.FEE_CHARGE,

Line 1202: l_okl_k_lines_h_rec.STY_ID,

1198: FETCH okl_k_lines_h_pk_csr INTO
1199: l_okl_k_lines_h_rec.ID,
1200: l_okl_k_lines_h_rec.MAJOR_VERSION,
1201: l_okl_k_lines_h_rec.KLE_ID,
1202: l_okl_k_lines_h_rec.STY_ID,
1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1204: l_okl_k_lines_h_rec.LAO_AMOUNT,
1205: l_okl_k_lines_h_rec.FEE_CHARGE,
1206: l_okl_k_lines_h_rec.TITLE_DATE,

Line 1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,

1199: l_okl_k_lines_h_rec.ID,
1200: l_okl_k_lines_h_rec.MAJOR_VERSION,
1201: l_okl_k_lines_h_rec.KLE_ID,
1202: l_okl_k_lines_h_rec.STY_ID,
1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1204: l_okl_k_lines_h_rec.LAO_AMOUNT,
1205: l_okl_k_lines_h_rec.FEE_CHARGE,
1206: l_okl_k_lines_h_rec.TITLE_DATE,
1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,

Line 1204: l_okl_k_lines_h_rec.LAO_AMOUNT,

1200: l_okl_k_lines_h_rec.MAJOR_VERSION,
1201: l_okl_k_lines_h_rec.KLE_ID,
1202: l_okl_k_lines_h_rec.STY_ID,
1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1204: l_okl_k_lines_h_rec.LAO_AMOUNT,
1205: l_okl_k_lines_h_rec.FEE_CHARGE,
1206: l_okl_k_lines_h_rec.TITLE_DATE,
1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,

Line 1205: l_okl_k_lines_h_rec.FEE_CHARGE,

1201: l_okl_k_lines_h_rec.KLE_ID,
1202: l_okl_k_lines_h_rec.STY_ID,
1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1204: l_okl_k_lines_h_rec.LAO_AMOUNT,
1205: l_okl_k_lines_h_rec.FEE_CHARGE,
1206: l_okl_k_lines_h_rec.TITLE_DATE,
1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,

Line 1206: l_okl_k_lines_h_rec.TITLE_DATE,

1202: l_okl_k_lines_h_rec.STY_ID,
1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1204: l_okl_k_lines_h_rec.LAO_AMOUNT,
1205: l_okl_k_lines_h_rec.FEE_CHARGE,
1206: l_okl_k_lines_h_rec.TITLE_DATE,
1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,

Line 1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,

1203: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
1204: l_okl_k_lines_h_rec.LAO_AMOUNT,
1205: l_okl_k_lines_h_rec.FEE_CHARGE,
1206: l_okl_k_lines_h_rec.TITLE_DATE,
1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,

Line 1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,

1204: l_okl_k_lines_h_rec.LAO_AMOUNT,
1205: l_okl_k_lines_h_rec.FEE_CHARGE,
1206: l_okl_k_lines_h_rec.TITLE_DATE,
1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1212: l_okl_k_lines_h_rec.DATE_REMARKETED,

Line 1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,

1205: l_okl_k_lines_h_rec.FEE_CHARGE,
1206: l_okl_k_lines_h_rec.TITLE_DATE,
1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1212: l_okl_k_lines_h_rec.DATE_REMARKETED,
1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,

Line 1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,

1206: l_okl_k_lines_h_rec.TITLE_DATE,
1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1212: l_okl_k_lines_h_rec.DATE_REMARKETED,
1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,

Line 1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,

1207: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1212: l_okl_k_lines_h_rec.DATE_REMARKETED,
1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,

Line 1212: l_okl_k_lines_h_rec.DATE_REMARKETED,

1208: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1212: l_okl_k_lines_h_rec.DATE_REMARKETED,
1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1216: l_okl_k_lines_h_rec.GAIN_LOSS,

Line 1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,

1209: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1212: l_okl_k_lines_h_rec.DATE_REMARKETED,
1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1216: l_okl_k_lines_h_rec.GAIN_LOSS,
1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,

Line 1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,

1210: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1212: l_okl_k_lines_h_rec.DATE_REMARKETED,
1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1216: l_okl_k_lines_h_rec.GAIN_LOSS,
1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,

Line 1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,

1211: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
1212: l_okl_k_lines_h_rec.DATE_REMARKETED,
1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1216: l_okl_k_lines_h_rec.GAIN_LOSS,
1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,

Line 1216: l_okl_k_lines_h_rec.GAIN_LOSS,

1212: l_okl_k_lines_h_rec.DATE_REMARKETED,
1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1216: l_okl_k_lines_h_rec.GAIN_LOSS,
1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,

Line 1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,

1213: l_okl_k_lines_h_rec.REMARKET_MARGIN,
1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1216: l_okl_k_lines_h_rec.GAIN_LOSS,
1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,

Line 1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,

1214: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1216: l_okl_k_lines_h_rec.GAIN_LOSS,
1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,

Line 1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,

1215: l_okl_k_lines_h_rec.DATE_REPURCHASED,
1216: l_okl_k_lines_h_rec.GAIN_LOSS,
1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,

Line 1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,

1216: l_okl_k_lines_h_rec.GAIN_LOSS,
1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,

Line 1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,

1217: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,

Line 1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,

1218: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1226: l_okl_k_lines_h_rec.DELIVERED_DATE,

Line 1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,

1219: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1226: l_okl_k_lines_h_rec.DELIVERED_DATE,
1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,

Line 1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,

1220: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1226: l_okl_k_lines_h_rec.DELIVERED_DATE,
1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,

Line 1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,

1221: l_okl_k_lines_h_rec.ESTIMATED_OEC,
1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1226: l_okl_k_lines_h_rec.DELIVERED_DATE,
1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1229: l_okl_k_lines_h_rec.OCCUPANCY,

Line 1226: l_okl_k_lines_h_rec.DELIVERED_DATE,

1222: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1226: l_okl_k_lines_h_rec.DELIVERED_DATE,
1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1229: l_okl_k_lines_h_rec.OCCUPANCY,
1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,

Line 1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,

1223: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1226: l_okl_k_lines_h_rec.DELIVERED_DATE,
1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1229: l_okl_k_lines_h_rec.OCCUPANCY,
1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,

Line 1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,

1224: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1226: l_okl_k_lines_h_rec.DELIVERED_DATE,
1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1229: l_okl_k_lines_h_rec.OCCUPANCY,
1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,

Line 1229: l_okl_k_lines_h_rec.OCCUPANCY,

1225: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
1226: l_okl_k_lines_h_rec.DELIVERED_DATE,
1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1229: l_okl_k_lines_h_rec.OCCUPANCY,
1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,

Line 1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,

1226: l_okl_k_lines_h_rec.DELIVERED_DATE,
1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1229: l_okl_k_lines_h_rec.OCCUPANCY,
1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,

Line 1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,

1227: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1229: l_okl_k_lines_h_rec.OCCUPANCY,
1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1235: l_okl_k_lines_h_rec.YEAR_BUILT,

Line 1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,

1228: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
1229: l_okl_k_lines_h_rec.OCCUPANCY,
1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1235: l_okl_k_lines_h_rec.YEAR_BUILT,
1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,

Line 1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,

1229: l_okl_k_lines_h_rec.OCCUPANCY,
1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1235: l_okl_k_lines_h_rec.YEAR_BUILT,
1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,

Line 1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,

1230: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1235: l_okl_k_lines_h_rec.YEAR_BUILT,
1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1238: l_okl_k_lines_h_rec.NET_RENTABLE,

Line 1235: l_okl_k_lines_h_rec.YEAR_BUILT,

1231: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1235: l_okl_k_lines_h_rec.YEAR_BUILT,
1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1238: l_okl_k_lines_h_rec.NET_RENTABLE,
1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,

Line 1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,

1232: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1235: l_okl_k_lines_h_rec.YEAR_BUILT,
1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1238: l_okl_k_lines_h_rec.NET_RENTABLE,
1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,

Line 1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,

1233: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1235: l_okl_k_lines_h_rec.YEAR_BUILT,
1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1238: l_okl_k_lines_h_rec.NET_RENTABLE,
1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,

Line 1238: l_okl_k_lines_h_rec.NET_RENTABLE,

1234: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
1235: l_okl_k_lines_h_rec.YEAR_BUILT,
1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1238: l_okl_k_lines_h_rec.NET_RENTABLE,
1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,

Line 1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,

1235: l_okl_k_lines_h_rec.YEAR_BUILT,
1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1238: l_okl_k_lines_h_rec.NET_RENTABLE,
1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,

Line 1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,

1236: l_okl_k_lines_h_rec.COVERAGE_RATIO,
1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1238: l_okl_k_lines_h_rec.NET_RENTABLE,
1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1244: l_okl_k_lines_h_rec.PERCENT,

Line 1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,

1237: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
1238: l_okl_k_lines_h_rec.NET_RENTABLE,
1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1244: l_okl_k_lines_h_rec.PERCENT,
1245: l_okl_k_lines_h_rec.COVERAGE,

Line 1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,

1238: l_okl_k_lines_h_rec.NET_RENTABLE,
1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1244: l_okl_k_lines_h_rec.PERCENT,
1245: l_okl_k_lines_h_rec.COVERAGE,
1246: l_okl_k_lines_h_rec.LRV_AMOUNT,

Line 1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,

1239: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1244: l_okl_k_lines_h_rec.PERCENT,
1245: l_okl_k_lines_h_rec.COVERAGE,
1246: l_okl_k_lines_h_rec.LRV_AMOUNT,
1247: l_okl_k_lines_h_rec.AMOUNT,

Line 1244: l_okl_k_lines_h_rec.PERCENT,

1240: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1244: l_okl_k_lines_h_rec.PERCENT,
1245: l_okl_k_lines_h_rec.COVERAGE,
1246: l_okl_k_lines_h_rec.LRV_AMOUNT,
1247: l_okl_k_lines_h_rec.AMOUNT,
1248: l_okl_k_lines_h_rec.LRS_PERCENT,

Line 1245: l_okl_k_lines_h_rec.COVERAGE,

1241: l_okl_k_lines_h_rec.DATE_APPRAISAL,
1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1244: l_okl_k_lines_h_rec.PERCENT,
1245: l_okl_k_lines_h_rec.COVERAGE,
1246: l_okl_k_lines_h_rec.LRV_AMOUNT,
1247: l_okl_k_lines_h_rec.AMOUNT,
1248: l_okl_k_lines_h_rec.LRS_PERCENT,
1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,

Line 1246: l_okl_k_lines_h_rec.LRV_AMOUNT,

1242: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1244: l_okl_k_lines_h_rec.PERCENT,
1245: l_okl_k_lines_h_rec.COVERAGE,
1246: l_okl_k_lines_h_rec.LRV_AMOUNT,
1247: l_okl_k_lines_h_rec.AMOUNT,
1248: l_okl_k_lines_h_rec.LRS_PERCENT,
1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1250: l_okl_k_lines_h_rec.PERCENT_STAKE,

Line 1247: l_okl_k_lines_h_rec.AMOUNT,

1243: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
1244: l_okl_k_lines_h_rec.PERCENT,
1245: l_okl_k_lines_h_rec.COVERAGE,
1246: l_okl_k_lines_h_rec.LRV_AMOUNT,
1247: l_okl_k_lines_h_rec.AMOUNT,
1248: l_okl_k_lines_h_rec.LRS_PERCENT,
1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1250: l_okl_k_lines_h_rec.PERCENT_STAKE,
1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,

Line 1248: l_okl_k_lines_h_rec.LRS_PERCENT,

1244: l_okl_k_lines_h_rec.PERCENT,
1245: l_okl_k_lines_h_rec.COVERAGE,
1246: l_okl_k_lines_h_rec.LRV_AMOUNT,
1247: l_okl_k_lines_h_rec.AMOUNT,
1248: l_okl_k_lines_h_rec.LRS_PERCENT,
1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1250: l_okl_k_lines_h_rec.PERCENT_STAKE,
1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1252: l_okl_k_lines_h_rec.DATE_SOLD,

Line 1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,

1245: l_okl_k_lines_h_rec.COVERAGE,
1246: l_okl_k_lines_h_rec.LRV_AMOUNT,
1247: l_okl_k_lines_h_rec.AMOUNT,
1248: l_okl_k_lines_h_rec.LRS_PERCENT,
1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1250: l_okl_k_lines_h_rec.PERCENT_STAKE,
1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1252: l_okl_k_lines_h_rec.DATE_SOLD,
1253: l_okl_k_lines_h_rec.STY_ID_FOR,

Line 1250: l_okl_k_lines_h_rec.PERCENT_STAKE,

1246: l_okl_k_lines_h_rec.LRV_AMOUNT,
1247: l_okl_k_lines_h_rec.AMOUNT,
1248: l_okl_k_lines_h_rec.LRS_PERCENT,
1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1250: l_okl_k_lines_h_rec.PERCENT_STAKE,
1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1252: l_okl_k_lines_h_rec.DATE_SOLD,
1253: l_okl_k_lines_h_rec.STY_ID_FOR,
1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,

Line 1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,

1247: l_okl_k_lines_h_rec.AMOUNT,
1248: l_okl_k_lines_h_rec.LRS_PERCENT,
1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1250: l_okl_k_lines_h_rec.PERCENT_STAKE,
1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1252: l_okl_k_lines_h_rec.DATE_SOLD,
1253: l_okl_k_lines_h_rec.STY_ID_FOR,
1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1255: l_okl_k_lines_h_rec.ATTRIBUTE1,

Line 1252: l_okl_k_lines_h_rec.DATE_SOLD,

1248: l_okl_k_lines_h_rec.LRS_PERCENT,
1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1250: l_okl_k_lines_h_rec.PERCENT_STAKE,
1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1252: l_okl_k_lines_h_rec.DATE_SOLD,
1253: l_okl_k_lines_h_rec.STY_ID_FOR,
1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1255: l_okl_k_lines_h_rec.ATTRIBUTE1,
1256: l_okl_k_lines_h_rec.ATTRIBUTE2,

Line 1253: l_okl_k_lines_h_rec.STY_ID_FOR,

1249: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
1250: l_okl_k_lines_h_rec.PERCENT_STAKE,
1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1252: l_okl_k_lines_h_rec.DATE_SOLD,
1253: l_okl_k_lines_h_rec.STY_ID_FOR,
1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1255: l_okl_k_lines_h_rec.ATTRIBUTE1,
1256: l_okl_k_lines_h_rec.ATTRIBUTE2,
1257: l_okl_k_lines_h_rec.ATTRIBUTE3,

Line 1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,

1250: l_okl_k_lines_h_rec.PERCENT_STAKE,
1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1252: l_okl_k_lines_h_rec.DATE_SOLD,
1253: l_okl_k_lines_h_rec.STY_ID_FOR,
1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1255: l_okl_k_lines_h_rec.ATTRIBUTE1,
1256: l_okl_k_lines_h_rec.ATTRIBUTE2,
1257: l_okl_k_lines_h_rec.ATTRIBUTE3,
1258: l_okl_k_lines_h_rec.ATTRIBUTE4,

Line 1255: l_okl_k_lines_h_rec.ATTRIBUTE1,

1251: l_okl_k_lines_h_rec.AMOUNT_STAKE,
1252: l_okl_k_lines_h_rec.DATE_SOLD,
1253: l_okl_k_lines_h_rec.STY_ID_FOR,
1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1255: l_okl_k_lines_h_rec.ATTRIBUTE1,
1256: l_okl_k_lines_h_rec.ATTRIBUTE2,
1257: l_okl_k_lines_h_rec.ATTRIBUTE3,
1258: l_okl_k_lines_h_rec.ATTRIBUTE4,
1259: l_okl_k_lines_h_rec.ATTRIBUTE5,

Line 1256: l_okl_k_lines_h_rec.ATTRIBUTE2,

1252: l_okl_k_lines_h_rec.DATE_SOLD,
1253: l_okl_k_lines_h_rec.STY_ID_FOR,
1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1255: l_okl_k_lines_h_rec.ATTRIBUTE1,
1256: l_okl_k_lines_h_rec.ATTRIBUTE2,
1257: l_okl_k_lines_h_rec.ATTRIBUTE3,
1258: l_okl_k_lines_h_rec.ATTRIBUTE4,
1259: l_okl_k_lines_h_rec.ATTRIBUTE5,
1260: l_okl_k_lines_h_rec.ATTRIBUTE6,

Line 1257: l_okl_k_lines_h_rec.ATTRIBUTE3,

1253: l_okl_k_lines_h_rec.STY_ID_FOR,
1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1255: l_okl_k_lines_h_rec.ATTRIBUTE1,
1256: l_okl_k_lines_h_rec.ATTRIBUTE2,
1257: l_okl_k_lines_h_rec.ATTRIBUTE3,
1258: l_okl_k_lines_h_rec.ATTRIBUTE4,
1259: l_okl_k_lines_h_rec.ATTRIBUTE5,
1260: l_okl_k_lines_h_rec.ATTRIBUTE6,
1261: l_okl_k_lines_h_rec.ATTRIBUTE7,

Line 1258: l_okl_k_lines_h_rec.ATTRIBUTE4,

1254: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
1255: l_okl_k_lines_h_rec.ATTRIBUTE1,
1256: l_okl_k_lines_h_rec.ATTRIBUTE2,
1257: l_okl_k_lines_h_rec.ATTRIBUTE3,
1258: l_okl_k_lines_h_rec.ATTRIBUTE4,
1259: l_okl_k_lines_h_rec.ATTRIBUTE5,
1260: l_okl_k_lines_h_rec.ATTRIBUTE6,
1261: l_okl_k_lines_h_rec.ATTRIBUTE7,
1262: l_okl_k_lines_h_rec.ATTRIBUTE8,

Line 1259: l_okl_k_lines_h_rec.ATTRIBUTE5,

1255: l_okl_k_lines_h_rec.ATTRIBUTE1,
1256: l_okl_k_lines_h_rec.ATTRIBUTE2,
1257: l_okl_k_lines_h_rec.ATTRIBUTE3,
1258: l_okl_k_lines_h_rec.ATTRIBUTE4,
1259: l_okl_k_lines_h_rec.ATTRIBUTE5,
1260: l_okl_k_lines_h_rec.ATTRIBUTE6,
1261: l_okl_k_lines_h_rec.ATTRIBUTE7,
1262: l_okl_k_lines_h_rec.ATTRIBUTE8,
1263: l_okl_k_lines_h_rec.ATTRIBUTE9,

Line 1260: l_okl_k_lines_h_rec.ATTRIBUTE6,

1256: l_okl_k_lines_h_rec.ATTRIBUTE2,
1257: l_okl_k_lines_h_rec.ATTRIBUTE3,
1258: l_okl_k_lines_h_rec.ATTRIBUTE4,
1259: l_okl_k_lines_h_rec.ATTRIBUTE5,
1260: l_okl_k_lines_h_rec.ATTRIBUTE6,
1261: l_okl_k_lines_h_rec.ATTRIBUTE7,
1262: l_okl_k_lines_h_rec.ATTRIBUTE8,
1263: l_okl_k_lines_h_rec.ATTRIBUTE9,
1264: l_okl_k_lines_h_rec.ATTRIBUTE10,

Line 1261: l_okl_k_lines_h_rec.ATTRIBUTE7,

1257: l_okl_k_lines_h_rec.ATTRIBUTE3,
1258: l_okl_k_lines_h_rec.ATTRIBUTE4,
1259: l_okl_k_lines_h_rec.ATTRIBUTE5,
1260: l_okl_k_lines_h_rec.ATTRIBUTE6,
1261: l_okl_k_lines_h_rec.ATTRIBUTE7,
1262: l_okl_k_lines_h_rec.ATTRIBUTE8,
1263: l_okl_k_lines_h_rec.ATTRIBUTE9,
1264: l_okl_k_lines_h_rec.ATTRIBUTE10,
1265: l_okl_k_lines_h_rec.ATTRIBUTE11,

Line 1262: l_okl_k_lines_h_rec.ATTRIBUTE8,

1258: l_okl_k_lines_h_rec.ATTRIBUTE4,
1259: l_okl_k_lines_h_rec.ATTRIBUTE5,
1260: l_okl_k_lines_h_rec.ATTRIBUTE6,
1261: l_okl_k_lines_h_rec.ATTRIBUTE7,
1262: l_okl_k_lines_h_rec.ATTRIBUTE8,
1263: l_okl_k_lines_h_rec.ATTRIBUTE9,
1264: l_okl_k_lines_h_rec.ATTRIBUTE10,
1265: l_okl_k_lines_h_rec.ATTRIBUTE11,
1266: l_okl_k_lines_h_rec.ATTRIBUTE12,

Line 1263: l_okl_k_lines_h_rec.ATTRIBUTE9,

1259: l_okl_k_lines_h_rec.ATTRIBUTE5,
1260: l_okl_k_lines_h_rec.ATTRIBUTE6,
1261: l_okl_k_lines_h_rec.ATTRIBUTE7,
1262: l_okl_k_lines_h_rec.ATTRIBUTE8,
1263: l_okl_k_lines_h_rec.ATTRIBUTE9,
1264: l_okl_k_lines_h_rec.ATTRIBUTE10,
1265: l_okl_k_lines_h_rec.ATTRIBUTE11,
1266: l_okl_k_lines_h_rec.ATTRIBUTE12,
1267: l_okl_k_lines_h_rec.ATTRIBUTE13,

Line 1264: l_okl_k_lines_h_rec.ATTRIBUTE10,

1260: l_okl_k_lines_h_rec.ATTRIBUTE6,
1261: l_okl_k_lines_h_rec.ATTRIBUTE7,
1262: l_okl_k_lines_h_rec.ATTRIBUTE8,
1263: l_okl_k_lines_h_rec.ATTRIBUTE9,
1264: l_okl_k_lines_h_rec.ATTRIBUTE10,
1265: l_okl_k_lines_h_rec.ATTRIBUTE11,
1266: l_okl_k_lines_h_rec.ATTRIBUTE12,
1267: l_okl_k_lines_h_rec.ATTRIBUTE13,
1268: l_okl_k_lines_h_rec.ATTRIBUTE14,

Line 1265: l_okl_k_lines_h_rec.ATTRIBUTE11,

1261: l_okl_k_lines_h_rec.ATTRIBUTE7,
1262: l_okl_k_lines_h_rec.ATTRIBUTE8,
1263: l_okl_k_lines_h_rec.ATTRIBUTE9,
1264: l_okl_k_lines_h_rec.ATTRIBUTE10,
1265: l_okl_k_lines_h_rec.ATTRIBUTE11,
1266: l_okl_k_lines_h_rec.ATTRIBUTE12,
1267: l_okl_k_lines_h_rec.ATTRIBUTE13,
1268: l_okl_k_lines_h_rec.ATTRIBUTE14,
1269: l_okl_k_lines_h_rec.ATTRIBUTE15,

Line 1266: l_okl_k_lines_h_rec.ATTRIBUTE12,

1262: l_okl_k_lines_h_rec.ATTRIBUTE8,
1263: l_okl_k_lines_h_rec.ATTRIBUTE9,
1264: l_okl_k_lines_h_rec.ATTRIBUTE10,
1265: l_okl_k_lines_h_rec.ATTRIBUTE11,
1266: l_okl_k_lines_h_rec.ATTRIBUTE12,
1267: l_okl_k_lines_h_rec.ATTRIBUTE13,
1268: l_okl_k_lines_h_rec.ATTRIBUTE14,
1269: l_okl_k_lines_h_rec.ATTRIBUTE15,
1270: l_okl_k_lines_h_rec.CREATED_BY,

Line 1267: l_okl_k_lines_h_rec.ATTRIBUTE13,

1263: l_okl_k_lines_h_rec.ATTRIBUTE9,
1264: l_okl_k_lines_h_rec.ATTRIBUTE10,
1265: l_okl_k_lines_h_rec.ATTRIBUTE11,
1266: l_okl_k_lines_h_rec.ATTRIBUTE12,
1267: l_okl_k_lines_h_rec.ATTRIBUTE13,
1268: l_okl_k_lines_h_rec.ATTRIBUTE14,
1269: l_okl_k_lines_h_rec.ATTRIBUTE15,
1270: l_okl_k_lines_h_rec.CREATED_BY,
1271: l_okl_k_lines_h_rec.CREATION_DATE,

Line 1268: l_okl_k_lines_h_rec.ATTRIBUTE14,

1264: l_okl_k_lines_h_rec.ATTRIBUTE10,
1265: l_okl_k_lines_h_rec.ATTRIBUTE11,
1266: l_okl_k_lines_h_rec.ATTRIBUTE12,
1267: l_okl_k_lines_h_rec.ATTRIBUTE13,
1268: l_okl_k_lines_h_rec.ATTRIBUTE14,
1269: l_okl_k_lines_h_rec.ATTRIBUTE15,
1270: l_okl_k_lines_h_rec.CREATED_BY,
1271: l_okl_k_lines_h_rec.CREATION_DATE,
1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,

Line 1269: l_okl_k_lines_h_rec.ATTRIBUTE15,

1265: l_okl_k_lines_h_rec.ATTRIBUTE11,
1266: l_okl_k_lines_h_rec.ATTRIBUTE12,
1267: l_okl_k_lines_h_rec.ATTRIBUTE13,
1268: l_okl_k_lines_h_rec.ATTRIBUTE14,
1269: l_okl_k_lines_h_rec.ATTRIBUTE15,
1270: l_okl_k_lines_h_rec.CREATED_BY,
1271: l_okl_k_lines_h_rec.CREATION_DATE,
1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,

Line 1270: l_okl_k_lines_h_rec.CREATED_BY,

1266: l_okl_k_lines_h_rec.ATTRIBUTE12,
1267: l_okl_k_lines_h_rec.ATTRIBUTE13,
1268: l_okl_k_lines_h_rec.ATTRIBUTE14,
1269: l_okl_k_lines_h_rec.ATTRIBUTE15,
1270: l_okl_k_lines_h_rec.CREATED_BY,
1271: l_okl_k_lines_h_rec.CREATION_DATE,
1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,

Line 1271: l_okl_k_lines_h_rec.CREATION_DATE,

1267: l_okl_k_lines_h_rec.ATTRIBUTE13,
1268: l_okl_k_lines_h_rec.ATTRIBUTE14,
1269: l_okl_k_lines_h_rec.ATTRIBUTE15,
1270: l_okl_k_lines_h_rec.CREATED_BY,
1271: l_okl_k_lines_h_rec.CREATION_DATE,
1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1275: l_okl_k_lines_h_rec.NTY_CODE,

Line 1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,

1268: l_okl_k_lines_h_rec.ATTRIBUTE14,
1269: l_okl_k_lines_h_rec.ATTRIBUTE15,
1270: l_okl_k_lines_h_rec.CREATED_BY,
1271: l_okl_k_lines_h_rec.CREATION_DATE,
1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1275: l_okl_k_lines_h_rec.NTY_CODE,
1276: l_okl_k_lines_h_rec.FCG_CODE,

Line 1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,

1269: l_okl_k_lines_h_rec.ATTRIBUTE15,
1270: l_okl_k_lines_h_rec.CREATED_BY,
1271: l_okl_k_lines_h_rec.CREATION_DATE,
1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1275: l_okl_k_lines_h_rec.NTY_CODE,
1276: l_okl_k_lines_h_rec.FCG_CODE,
1277: l_okl_k_lines_h_rec.PRC_CODE,

Line 1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,

1270: l_okl_k_lines_h_rec.CREATED_BY,
1271: l_okl_k_lines_h_rec.CREATION_DATE,
1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1275: l_okl_k_lines_h_rec.NTY_CODE,
1276: l_okl_k_lines_h_rec.FCG_CODE,
1277: l_okl_k_lines_h_rec.PRC_CODE,
1278: l_okl_k_lines_h_rec.RE_LEASE_YN,

Line 1275: l_okl_k_lines_h_rec.NTY_CODE,

1271: l_okl_k_lines_h_rec.CREATION_DATE,
1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1275: l_okl_k_lines_h_rec.NTY_CODE,
1276: l_okl_k_lines_h_rec.FCG_CODE,
1277: l_okl_k_lines_h_rec.PRC_CODE,
1278: l_okl_k_lines_h_rec.RE_LEASE_YN,
1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,

Line 1276: l_okl_k_lines_h_rec.FCG_CODE,

1272: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1275: l_okl_k_lines_h_rec.NTY_CODE,
1276: l_okl_k_lines_h_rec.FCG_CODE,
1277: l_okl_k_lines_h_rec.PRC_CODE,
1278: l_okl_k_lines_h_rec.RE_LEASE_YN,
1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,

Line 1277: l_okl_k_lines_h_rec.PRC_CODE,

1273: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1275: l_okl_k_lines_h_rec.NTY_CODE,
1276: l_okl_k_lines_h_rec.FCG_CODE,
1277: l_okl_k_lines_h_rec.PRC_CODE,
1278: l_okl_k_lines_h_rec.RE_LEASE_YN,
1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,

Line 1278: l_okl_k_lines_h_rec.RE_LEASE_YN,

1274: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
1275: l_okl_k_lines_h_rec.NTY_CODE,
1276: l_okl_k_lines_h_rec.FCG_CODE,
1277: l_okl_k_lines_h_rec.PRC_CODE,
1278: l_okl_k_lines_h_rec.RE_LEASE_YN,
1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1282: l_okl_k_lines_h_rec.CLG_ID,

Line 1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,

1275: l_okl_k_lines_h_rec.NTY_CODE,
1276: l_okl_k_lines_h_rec.FCG_CODE,
1277: l_okl_k_lines_h_rec.PRC_CODE,
1278: l_okl_k_lines_h_rec.RE_LEASE_YN,
1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1282: l_okl_k_lines_h_rec.CLG_ID,
1283: l_okl_k_lines_h_rec.DATE_FUNDING,

Line 1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,

1276: l_okl_k_lines_h_rec.FCG_CODE,
1277: l_okl_k_lines_h_rec.PRC_CODE,
1278: l_okl_k_lines_h_rec.RE_LEASE_YN,
1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1282: l_okl_k_lines_h_rec.CLG_ID,
1283: l_okl_k_lines_h_rec.DATE_FUNDING,
1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,

Line 1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,

1277: l_okl_k_lines_h_rec.PRC_CODE,
1278: l_okl_k_lines_h_rec.RE_LEASE_YN,
1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1282: l_okl_k_lines_h_rec.CLG_ID,
1283: l_okl_k_lines_h_rec.DATE_FUNDING,
1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,

Line 1282: l_okl_k_lines_h_rec.CLG_ID,

1278: l_okl_k_lines_h_rec.RE_LEASE_YN,
1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1282: l_okl_k_lines_h_rec.CLG_ID,
1283: l_okl_k_lines_h_rec.DATE_FUNDING,
1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,

Line 1283: l_okl_k_lines_h_rec.DATE_FUNDING,

1279: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1282: l_okl_k_lines_h_rec.CLG_ID,
1283: l_okl_k_lines_h_rec.DATE_FUNDING,
1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1287: l_okl_k_lines_h_rec.OEC,

Line 1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,

1280: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1282: l_okl_k_lines_h_rec.CLG_ID,
1283: l_okl_k_lines_h_rec.DATE_FUNDING,
1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1287: l_okl_k_lines_h_rec.OEC,
1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,

Line 1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,

1281: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
1282: l_okl_k_lines_h_rec.CLG_ID,
1283: l_okl_k_lines_h_rec.DATE_FUNDING,
1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1287: l_okl_k_lines_h_rec.OEC,
1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,

Line 1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,

1282: l_okl_k_lines_h_rec.CLG_ID,
1283: l_okl_k_lines_h_rec.DATE_FUNDING,
1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1287: l_okl_k_lines_h_rec.OEC,
1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,

Line 1287: l_okl_k_lines_h_rec.OEC,

1283: l_okl_k_lines_h_rec.DATE_FUNDING,
1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1287: l_okl_k_lines_h_rec.OEC,
1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1291: l_okl_k_lines_h_rec.RVI_PREMIUM,

Line 1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,

1284: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1287: l_okl_k_lines_h_rec.OEC,
1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1291: l_okl_k_lines_h_rec.RVI_PREMIUM,
1292: l_okl_k_lines_h_rec.CREDIT_NATURE,

Line 1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,

1285: l_okl_k_lines_h_rec.DATE_ACCEPTED,
1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1287: l_okl_k_lines_h_rec.OEC,
1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1291: l_okl_k_lines_h_rec.RVI_PREMIUM,
1292: l_okl_k_lines_h_rec.CREDIT_NATURE,
1293: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,

Line 1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,

1286: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
1287: l_okl_k_lines_h_rec.OEC,
1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1291: l_okl_k_lines_h_rec.RVI_PREMIUM,
1292: l_okl_k_lines_h_rec.CREDIT_NATURE,
1293: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1294: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,

Line 1291: l_okl_k_lines_h_rec.RVI_PREMIUM,

1287: l_okl_k_lines_h_rec.OEC,
1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1291: l_okl_k_lines_h_rec.RVI_PREMIUM,
1292: l_okl_k_lines_h_rec.CREDIT_NATURE,
1293: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1294: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1295: --Bug# 2697681 11.5.9

Line 1292: l_okl_k_lines_h_rec.CREDIT_NATURE,

1288: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1291: l_okl_k_lines_h_rec.RVI_PREMIUM,
1292: l_okl_k_lines_h_rec.CREDIT_NATURE,
1293: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1294: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1295: --Bug# 2697681 11.5.9
1296: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,

Line 1293: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,

1289: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1291: l_okl_k_lines_h_rec.RVI_PREMIUM,
1292: l_okl_k_lines_h_rec.CREDIT_NATURE,
1293: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1294: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1295: --Bug# 2697681 11.5.9
1296: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1297: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,

Line 1294: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,

1290: l_okl_k_lines_h_rec.RESIDUAL_CODE,
1291: l_okl_k_lines_h_rec.RVI_PREMIUM,
1292: l_okl_k_lines_h_rec.CREDIT_NATURE,
1293: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1294: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1295: --Bug# 2697681 11.5.9
1296: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1297: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1298: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,

Line 1296: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,

1292: l_okl_k_lines_h_rec.CREDIT_NATURE,
1293: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1294: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1295: --Bug# 2697681 11.5.9
1296: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1297: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1298: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1299: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1300: --financed fees

Line 1297: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,

1293: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
1294: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1295: --Bug# 2697681 11.5.9
1296: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1297: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1298: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1299: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1300: --financed fees
1301: l_okl_k_lines_h_rec.FEE_TYPE,

Line 1298: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,

1294: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
1295: --Bug# 2697681 11.5.9
1296: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1297: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1298: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1299: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1300: --financed fees
1301: l_okl_k_lines_h_rec.FEE_TYPE,
1302: --Bug# 3143522 : 11.5.10

Line 1299: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,

1295: --Bug# 2697681 11.5.9
1296: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
1297: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1298: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1299: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1300: --financed fees
1301: l_okl_k_lines_h_rec.FEE_TYPE,
1302: --Bug# 3143522 : 11.5.10
1303: --subsidy

Line 1301: l_okl_k_lines_h_rec.FEE_TYPE,

1297: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
1298: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
1299: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
1300: --financed fees
1301: l_okl_k_lines_h_rec.FEE_TYPE,
1302: --Bug# 3143522 : 11.5.10
1303: --subsidy
1304: l_okl_k_lines_h_rec.SUBSIDY_ID,
1305: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,

Line 1304: l_okl_k_lines_h_rec.SUBSIDY_ID,

1300: --financed fees
1301: l_okl_k_lines_h_rec.FEE_TYPE,
1302: --Bug# 3143522 : 11.5.10
1303: --subsidy
1304: l_okl_k_lines_h_rec.SUBSIDY_ID,
1305: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1306: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1307: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1308: --financed fee

Line 1305: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,

1301: l_okl_k_lines_h_rec.FEE_TYPE,
1302: --Bug# 3143522 : 11.5.10
1303: --subsidy
1304: l_okl_k_lines_h_rec.SUBSIDY_ID,
1305: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1306: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1307: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1308: --financed fee
1309: l_okl_k_lines_h_rec.PRE_TAX_YIELD,

Line 1306: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,

1302: --Bug# 3143522 : 11.5.10
1303: --subsidy
1304: l_okl_k_lines_h_rec.SUBSIDY_ID,
1305: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1306: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1307: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1308: --financed fee
1309: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1310: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,

Line 1307: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,

1303: --subsidy
1304: l_okl_k_lines_h_rec.SUBSIDY_ID,
1305: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1306: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1307: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1308: --financed fee
1309: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1310: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1311: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,

Line 1309: l_okl_k_lines_h_rec.PRE_TAX_YIELD,

1305: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
1306: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1307: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1308: --financed fee
1309: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1310: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1311: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1312: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1313: l_okl_k_lines_h_rec.PRE_TAX_IRR,

Line 1310: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,

1306: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
1307: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1308: --financed fee
1309: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1310: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1311: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1312: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1313: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1314: l_okl_k_lines_h_rec.AFTER_TAX_IRR,

Line 1311: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,

1307: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
1308: --financed fee
1309: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1310: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1311: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1312: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1313: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1314: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1315: --quote

Line 1312: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,

1308: --financed fee
1309: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1310: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1311: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1312: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1313: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1314: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1315: --quote
1316: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,

Line 1313: l_okl_k_lines_h_rec.PRE_TAX_IRR,

1309: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
1310: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1311: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1312: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1313: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1314: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1315: --quote
1316: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1317: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,

Line 1314: l_okl_k_lines_h_rec.AFTER_TAX_IRR,

1310: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
1311: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
1312: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1313: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1314: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1315: --quote
1316: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1317: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1318: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,

Line 1316: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,

1312: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1313: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1314: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1315: --quote
1316: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1317: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1318: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1319: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1320: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,

Line 1317: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,

1313: l_okl_k_lines_h_rec.PRE_TAX_IRR,
1314: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1315: --quote
1316: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1317: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1318: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1319: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1320: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1321: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,

Line 1318: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,

1314: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
1315: --quote
1316: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1317: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1318: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1319: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1320: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1321: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1322: --Bug# 2994971

Line 1319: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,

1315: --quote
1316: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1317: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1318: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1319: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1320: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1321: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1322: --Bug# 2994971
1323: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,

Line 1320: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,

1316: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
1317: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1318: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1319: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1320: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1321: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1322: --Bug# 2994971
1323: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1324: --Bug# 3973640 11.5.10+

Line 1321: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,

1317: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
1318: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
1319: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1320: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1321: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1322: --Bug# 2994971
1323: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1324: --Bug# 3973640 11.5.10+
1325: l_okl_k_lines_h_rec.QTE_ID,

Line 1323: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,

1319: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1320: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
1321: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1322: --Bug# 2994971
1323: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1324: --Bug# 3973640 11.5.10+
1325: l_okl_k_lines_h_rec.QTE_ID,
1326: l_okl_k_lines_h_rec.FUNDING_DATE,
1327: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,

Line 1325: l_okl_k_lines_h_rec.QTE_ID,

1321: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
1322: --Bug# 2994971
1323: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1324: --Bug# 3973640 11.5.10+
1325: l_okl_k_lines_h_rec.QTE_ID,
1326: l_okl_k_lines_h_rec.FUNDING_DATE,
1327: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1328: --Bug# 4419339 OKLH
1329: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,

Line 1326: l_okl_k_lines_h_rec.FUNDING_DATE,

1322: --Bug# 2994971
1323: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1324: --Bug# 3973640 11.5.10+
1325: l_okl_k_lines_h_rec.QTE_ID,
1326: l_okl_k_lines_h_rec.FUNDING_DATE,
1327: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1328: --Bug# 4419339 OKLH
1329: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1330: l_okl_k_lines_h_rec.MANUFACTURER_NAME,

Line 1327: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,

1323: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
1324: --Bug# 3973640 11.5.10+
1325: l_okl_k_lines_h_rec.QTE_ID,
1326: l_okl_k_lines_h_rec.FUNDING_DATE,
1327: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1328: --Bug# 4419339 OKLH
1329: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1330: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1331: l_okl_k_lines_h_rec.MODEL_NUMBER,

Line 1329: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,

1325: l_okl_k_lines_h_rec.QTE_ID,
1326: l_okl_k_lines_h_rec.FUNDING_DATE,
1327: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1328: --Bug# 4419339 OKLH
1329: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1330: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1331: l_okl_k_lines_h_rec.MODEL_NUMBER,
1332: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1333: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,

Line 1330: l_okl_k_lines_h_rec.MANUFACTURER_NAME,

1326: l_okl_k_lines_h_rec.FUNDING_DATE,
1327: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1328: --Bug# 4419339 OKLH
1329: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1330: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1331: l_okl_k_lines_h_rec.MODEL_NUMBER,
1332: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1333: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1334: --Bug#4373029

Line 1331: l_okl_k_lines_h_rec.MODEL_NUMBER,

1327: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
1328: --Bug# 4419339 OKLH
1329: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1330: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1331: l_okl_k_lines_h_rec.MODEL_NUMBER,
1332: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1333: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1334: --Bug#4373029
1335: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,

Line 1332: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,

1328: --Bug# 4419339 OKLH
1329: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1330: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1331: l_okl_k_lines_h_rec.MODEL_NUMBER,
1332: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1333: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1334: --Bug#4373029
1335: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1336: l_okl_k_lines_h_rec.TERMINATION_VALUE,

Line 1333: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,

1329: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
1330: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
1331: l_okl_k_lines_h_rec.MODEL_NUMBER,
1332: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1333: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1334: --Bug#4373029
1335: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1336: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1337: --Bug# 4631549

Line 1335: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,

1331: l_okl_k_lines_h_rec.MODEL_NUMBER,
1332: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1333: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1334: --Bug#4373029
1335: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1336: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1337: --Bug# 4631549
1338: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
1339: ;

Line 1336: l_okl_k_lines_h_rec.TERMINATION_VALUE,

1332: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
1333: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
1334: --Bug#4373029
1335: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1336: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1337: --Bug# 4631549
1338: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
1339: ;
1340: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;

Line 1338: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST

1334: --Bug#4373029
1335: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
1336: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1337: --Bug# 4631549
1338: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
1339: ;
1340: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1341: CLOSE okl_k_lines_h_pk_csr;
1342: RETURN(l_okl_k_lines_h_rec);

Line 1340: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;

1336: l_okl_k_lines_h_rec.TERMINATION_VALUE,
1337: --Bug# 4631549
1338: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
1339: ;
1340: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1341: CLOSE okl_k_lines_h_pk_csr;
1342: RETURN(l_okl_k_lines_h_rec);
1343: END get_rec;
1344:

Line 1341: CLOSE okl_k_lines_h_pk_csr;

1337: --Bug# 4631549
1338: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
1339: ;
1340: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1341: CLOSE okl_k_lines_h_pk_csr;
1342: RETURN(l_okl_k_lines_h_rec);
1343: END get_rec;
1344:
1345: FUNCTION get_rec (

Line 1342: RETURN(l_okl_k_lines_h_rec);

1338: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
1339: ;
1340: x_no_data_found := okl_k_lines_h_pk_csr%NOTFOUND;
1341: CLOSE okl_k_lines_h_pk_csr;
1342: RETURN(l_okl_k_lines_h_rec);
1343: END get_rec;
1344:
1345: FUNCTION get_rec (
1346: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type

Line 1346: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type

1342: RETURN(l_okl_k_lines_h_rec);
1343: END get_rec;
1344:
1345: FUNCTION get_rec (
1346: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type
1347: ) RETURN okl_k_lines_h_rec_type IS
1348: l_row_notfound BOOLEAN := TRUE;
1349: BEGIN
1350: RETURN(get_rec(p_okl_k_lines_h_rec, l_row_notfound));

Line 1347: ) RETURN okl_k_lines_h_rec_type IS

1343: END get_rec;
1344:
1345: FUNCTION get_rec (
1346: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type
1347: ) RETURN okl_k_lines_h_rec_type IS
1348: l_row_notfound BOOLEAN := TRUE;
1349: BEGIN
1350: RETURN(get_rec(p_okl_k_lines_h_rec, l_row_notfound));
1351: END get_rec;

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

1346: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type
1347: ) RETURN okl_k_lines_h_rec_type IS
1348: l_row_notfound BOOLEAN := TRUE;
1349: BEGIN
1350: RETURN(get_rec(p_okl_k_lines_h_rec, l_row_notfound));
1351: END get_rec;
1352:
1353:
1354: ---------------------------------------------------------------------------

Line 1355: -- FUNCTION get_rec for: OKL_K_LINES_V

1351: END get_rec;
1352:
1353:
1354: ---------------------------------------------------------------------------
1355: -- FUNCTION get_rec for: OKL_K_LINES_V
1356: ---------------------------------------------------------------------------
1357: FUNCTION get_rec (
1358: p_klev_rec IN klev_rec_type,
1359: x_no_data_found OUT NOCOPY BOOLEAN

Line 1361: CURSOR okl_k_lines_v_pk_csr (p_id IN NUMBER) IS

1357: FUNCTION get_rec (
1358: p_klev_rec IN klev_rec_type,
1359: x_no_data_found OUT NOCOPY BOOLEAN
1360: ) RETURN klev_rec_type IS
1361: CURSOR okl_k_lines_v_pk_csr (p_id IN NUMBER) IS
1362: SELECT
1363: ID,
1364: OBJECT_VERSION_NUMBER,
1365: KLE_ID,

Line 1504: FROM OKL_K_LINES_V

1500: --Bug# 4631549
1501: EXPECTED_ASSET_COST
1502:
1503:
1504: FROM OKL_K_LINES_V
1505: WHERE OKL_K_LINES_V.id = p_id;
1506: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1507: l_klev_rec klev_rec_type;
1508: BEGIN

Line 1505: WHERE OKL_K_LINES_V.id = p_id;

1501: EXPECTED_ASSET_COST
1502:
1503:
1504: FROM OKL_K_LINES_V
1505: WHERE OKL_K_LINES_V.id = p_id;
1506: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1507: l_klev_rec klev_rec_type;
1508: BEGIN
1509:

Line 1506: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;

1502:
1503:
1504: FROM OKL_K_LINES_V
1505: WHERE OKL_K_LINES_V.id = p_id;
1506: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1507: l_klev_rec klev_rec_type;
1508: BEGIN
1509:
1510: x_no_data_found := TRUE;

Line 1512: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);

1508: BEGIN
1509:
1510: x_no_data_found := TRUE;
1511: -- Get current database values
1512: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);
1513: FETCH okl_k_lines_v_pk_csr INTO
1514: l_klev_rec.ID,
1515: l_klev_rec.OBJECT_VERSION_NUMBER,
1516: l_klev_rec.KLE_ID,

Line 1513: FETCH okl_k_lines_v_pk_csr INTO

1509:
1510: x_no_data_found := TRUE;
1511: -- Get current database values
1512: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);
1513: FETCH okl_k_lines_v_pk_csr INTO
1514: l_klev_rec.ID,
1515: l_klev_rec.OBJECT_VERSION_NUMBER,
1516: l_klev_rec.KLE_ID,
1517: l_klev_rec.STY_ID,

Line 1654: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;

1650: l_klev_rec.TERMINATION_VALUE,
1651: --Bug# 4631549
1652: l_klev_rec.EXPECTED_ASSET_COST
1653: ;
1654: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;
1655: CLOSE okl_k_lines_v_pk_csr;
1656: RETURN(l_klev_rec);
1657: END get_rec;
1658:

Line 1655: CLOSE okl_k_lines_v_pk_csr;

1651: --Bug# 4631549
1652: l_klev_rec.EXPECTED_ASSET_COST
1653: ;
1654: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;
1655: CLOSE okl_k_lines_v_pk_csr;
1656: RETURN(l_klev_rec);
1657: END get_rec;
1658:
1659: FUNCTION get_rec (

Line 1669: -- FUNCTION null_out_defaults for: OKL_K_LINES_V --

1665: END get_rec;
1666:
1667:
1668: -----------------------------------------------------
1669: -- FUNCTION null_out_defaults for: OKL_K_LINES_V --
1670: -----------------------------------------------------
1671: FUNCTION null_out_defaults (
1672: p_klev_rec IN klev_rec_type
1673: ) RETURN klev_rec_type IS

Line 2187: -- Validate_Record for: OKL_K_LINES_V --

2183: ---------------------------------------------------------------------------
2184:
2185:
2186: -----------------------------------------
2187: -- Validate_Record for: OKL_K_LINES_V --
2188: -----------------------------------------
2189: FUNCTION Validate_Record (
2190: p_klev_rec IN klev_rec_type
2191: ) RETURN VARCHAR2 IS

Line 2693: p_to IN OUT NOCOPY okl_k_lines_h_rec_type

2689: END migrate;
2690:
2691: PROCEDURE migrate (
2692: p_from IN kle_rec_type,
2693: p_to IN OUT NOCOPY okl_k_lines_h_rec_type
2694: ) IS
2695: BEGIN
2696:
2697: p_to.ID := p_from.ID;

Line 2941: -- validate_row for: OKL_K_LINES_V --

2937: -- PROCEDURE validate_row
2938: ---------------------------------------------------------------------------
2939:
2940: --------------------------------------
2941: -- validate_row for: OKL_K_LINES_V --
2942: --------------------------------------
2943:
2944: PROCEDURE validate_row(
2945:

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

3025: );
3026:
3027: END validate_row;
3028: ------------------------------------------
3029: -- PL/SQL TBL validate_row for: OKL_K_LINES_V --
3030: ------------------------------------------
3031:
3032: PROCEDURE validate_row(
3033:

Line 3104: -- insert_row for: OKL_K_LINES_H --

3100: ---------------------------------------------------------------------------
3101:
3102:
3103: ------------------------------------
3104: -- insert_row for: OKL_K_LINES_H --
3105: ------------------------------------
3106:
3107: PROCEDURE insert_row(
3108:

Line 3114: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,

3110: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3111: x_return_status OUT NOCOPY VARCHAR2,
3112: x_msg_count OUT NOCOPY NUMBER,
3113: x_msg_data OUT NOCOPY VARCHAR2,
3114: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3115: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type) IS
3116:
3117: l_api_version CONSTANT NUMBER := 1;
3118: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';

Line 3115: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type) IS

3111: x_return_status OUT NOCOPY VARCHAR2,
3112: x_msg_count OUT NOCOPY NUMBER,
3113: x_msg_data OUT NOCOPY VARCHAR2,
3114: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3115: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type) IS
3116:
3117: l_api_version CONSTANT NUMBER := 1;
3118: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
3119: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3120: l_okl_k_lines_h_rec okl_k_lines_h_rec_type := p_okl_k_lines_h_rec;

3116:
3117: l_api_version CONSTANT NUMBER := 1;
3118: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
3119: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3120: l_okl_k_lines_h_rec okl_k_lines_h_rec_type := p_okl_k_lines_h_rec;
3121: l_def_okl_k_lines_h_rec okl_k_lines_h_rec_type;
3122: ----------------------------------------
3123: -- Set_Attributes for: OKL_K_LINES_H --
3124: ----------------------------------------

Line 3121: l_def_okl_k_lines_h_rec okl_k_lines_h_rec_type;

3117: l_api_version CONSTANT NUMBER := 1;
3118: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
3119: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3120: l_okl_k_lines_h_rec okl_k_lines_h_rec_type := p_okl_k_lines_h_rec;
3121: l_def_okl_k_lines_h_rec okl_k_lines_h_rec_type;
3122: ----------------------------------------
3123: -- Set_Attributes for: OKL_K_LINES_H --
3124: ----------------------------------------
3125: FUNCTION Set_Attributes (

Line 3123: -- Set_Attributes for: OKL_K_LINES_H --

3119: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3120: l_okl_k_lines_h_rec okl_k_lines_h_rec_type := p_okl_k_lines_h_rec;
3121: l_def_okl_k_lines_h_rec okl_k_lines_h_rec_type;
3122: ----------------------------------------
3123: -- Set_Attributes for: OKL_K_LINES_H --
3124: ----------------------------------------
3125: FUNCTION Set_Attributes (
3126: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3127: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type

Line 3126: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,

3122: ----------------------------------------
3123: -- Set_Attributes for: OKL_K_LINES_H --
3124: ----------------------------------------
3125: FUNCTION Set_Attributes (
3126: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3127: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type
3128: ) RETURN VARCHAR2 IS
3129: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3130: BEGIN

Line 3127: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type

3123: -- Set_Attributes for: OKL_K_LINES_H --
3124: ----------------------------------------
3125: FUNCTION Set_Attributes (
3126: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,
3127: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type
3128: ) RETURN VARCHAR2 IS
3129: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3130: BEGIN
3131: x_okl_k_lines_h_rec := p_okl_k_lines_h_rec;

Line 3131: x_okl_k_lines_h_rec := p_okl_k_lines_h_rec;

3127: x_okl_k_lines_h_rec OUT NOCOPY okl_k_lines_h_rec_type
3128: ) RETURN VARCHAR2 IS
3129: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3130: BEGIN
3131: x_okl_k_lines_h_rec := p_okl_k_lines_h_rec;
3132: RETURN(l_return_status);
3133: END Set_Attributes;
3134: BEGIN
3135:

Line 3149: p_okl_k_lines_h_rec, -- IN

3145: END IF;
3146:
3147: --- Setting item attributes
3148: l_return_status := Set_Attributes(
3149: p_okl_k_lines_h_rec, -- IN
3150: l_okl_k_lines_h_rec); -- OUT
3151: --- If any errors happen abort API
3152:
3153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3150: l_okl_k_lines_h_rec); -- OUT

3146:
3147: --- Setting item attributes
3148: l_return_status := Set_Attributes(
3149: p_okl_k_lines_h_rec, -- IN
3150: l_okl_k_lines_h_rec); -- OUT
3151: --- If any errors happen abort API
3152:
3153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3159: INSERT INTO OKL_K_LINES_H(

3155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3156: RAISE OKC_API.G_EXCEPTION_ERROR;
3157: END IF;
3158:
3159: INSERT INTO OKL_K_LINES_H(
3160: ID,
3161: MAJOR_VERSION,
3162: KLE_ID,
3163: STY_ID,

Line 3303: l_okl_k_lines_h_rec.ID,

3299: EXPECTED_ASSET_COST
3300:
3301: )
3302: VALUES (
3303: l_okl_k_lines_h_rec.ID,
3304: l_okl_k_lines_h_rec.MAJOR_VERSION,
3305: l_okl_k_lines_h_rec.KLE_ID,
3306: l_okl_k_lines_h_rec.STY_ID,
3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,

Line 3304: l_okl_k_lines_h_rec.MAJOR_VERSION,

3300:
3301: )
3302: VALUES (
3303: l_okl_k_lines_h_rec.ID,
3304: l_okl_k_lines_h_rec.MAJOR_VERSION,
3305: l_okl_k_lines_h_rec.KLE_ID,
3306: l_okl_k_lines_h_rec.STY_ID,
3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3308: l_okl_k_lines_h_rec.LAO_AMOUNT,

Line 3305: l_okl_k_lines_h_rec.KLE_ID,

3301: )
3302: VALUES (
3303: l_okl_k_lines_h_rec.ID,
3304: l_okl_k_lines_h_rec.MAJOR_VERSION,
3305: l_okl_k_lines_h_rec.KLE_ID,
3306: l_okl_k_lines_h_rec.STY_ID,
3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3308: l_okl_k_lines_h_rec.LAO_AMOUNT,
3309: l_okl_k_lines_h_rec.FEE_CHARGE,

Line 3306: l_okl_k_lines_h_rec.STY_ID,

3302: VALUES (
3303: l_okl_k_lines_h_rec.ID,
3304: l_okl_k_lines_h_rec.MAJOR_VERSION,
3305: l_okl_k_lines_h_rec.KLE_ID,
3306: l_okl_k_lines_h_rec.STY_ID,
3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3308: l_okl_k_lines_h_rec.LAO_AMOUNT,
3309: l_okl_k_lines_h_rec.FEE_CHARGE,
3310: l_okl_k_lines_h_rec.TITLE_DATE,

Line 3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,

3303: l_okl_k_lines_h_rec.ID,
3304: l_okl_k_lines_h_rec.MAJOR_VERSION,
3305: l_okl_k_lines_h_rec.KLE_ID,
3306: l_okl_k_lines_h_rec.STY_ID,
3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3308: l_okl_k_lines_h_rec.LAO_AMOUNT,
3309: l_okl_k_lines_h_rec.FEE_CHARGE,
3310: l_okl_k_lines_h_rec.TITLE_DATE,
3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,

Line 3308: l_okl_k_lines_h_rec.LAO_AMOUNT,

3304: l_okl_k_lines_h_rec.MAJOR_VERSION,
3305: l_okl_k_lines_h_rec.KLE_ID,
3306: l_okl_k_lines_h_rec.STY_ID,
3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3308: l_okl_k_lines_h_rec.LAO_AMOUNT,
3309: l_okl_k_lines_h_rec.FEE_CHARGE,
3310: l_okl_k_lines_h_rec.TITLE_DATE,
3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,

Line 3309: l_okl_k_lines_h_rec.FEE_CHARGE,

3305: l_okl_k_lines_h_rec.KLE_ID,
3306: l_okl_k_lines_h_rec.STY_ID,
3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3308: l_okl_k_lines_h_rec.LAO_AMOUNT,
3309: l_okl_k_lines_h_rec.FEE_CHARGE,
3310: l_okl_k_lines_h_rec.TITLE_DATE,
3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,

Line 3310: l_okl_k_lines_h_rec.TITLE_DATE,

3306: l_okl_k_lines_h_rec.STY_ID,
3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3308: l_okl_k_lines_h_rec.LAO_AMOUNT,
3309: l_okl_k_lines_h_rec.FEE_CHARGE,
3310: l_okl_k_lines_h_rec.TITLE_DATE,
3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,

Line 3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,

3307: l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
3308: l_okl_k_lines_h_rec.LAO_AMOUNT,
3309: l_okl_k_lines_h_rec.FEE_CHARGE,
3310: l_okl_k_lines_h_rec.TITLE_DATE,
3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,

Line 3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,

3308: l_okl_k_lines_h_rec.LAO_AMOUNT,
3309: l_okl_k_lines_h_rec.FEE_CHARGE,
3310: l_okl_k_lines_h_rec.TITLE_DATE,
3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3316: l_okl_k_lines_h_rec.DATE_REMARKETED,

Line 3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,

3309: l_okl_k_lines_h_rec.FEE_CHARGE,
3310: l_okl_k_lines_h_rec.TITLE_DATE,
3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3316: l_okl_k_lines_h_rec.DATE_REMARKETED,
3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,

Line 3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,

3310: l_okl_k_lines_h_rec.TITLE_DATE,
3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3316: l_okl_k_lines_h_rec.DATE_REMARKETED,
3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,

Line 3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,

3311: l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3316: l_okl_k_lines_h_rec.DATE_REMARKETED,
3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,

Line 3316: l_okl_k_lines_h_rec.DATE_REMARKETED,

3312: l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3316: l_okl_k_lines_h_rec.DATE_REMARKETED,
3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3320: l_okl_k_lines_h_rec.GAIN_LOSS,

Line 3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,

3313: l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3316: l_okl_k_lines_h_rec.DATE_REMARKETED,
3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3320: l_okl_k_lines_h_rec.GAIN_LOSS,
3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,

Line 3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,

3314: l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3316: l_okl_k_lines_h_rec.DATE_REMARKETED,
3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3320: l_okl_k_lines_h_rec.GAIN_LOSS,
3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,

Line 3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,

3315: l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
3316: l_okl_k_lines_h_rec.DATE_REMARKETED,
3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3320: l_okl_k_lines_h_rec.GAIN_LOSS,
3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,

Line 3320: l_okl_k_lines_h_rec.GAIN_LOSS,

3316: l_okl_k_lines_h_rec.DATE_REMARKETED,
3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3320: l_okl_k_lines_h_rec.GAIN_LOSS,
3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,

Line 3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,

3317: l_okl_k_lines_h_rec.REMARKET_MARGIN,
3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3320: l_okl_k_lines_h_rec.GAIN_LOSS,
3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,

Line 3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,

3318: l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3320: l_okl_k_lines_h_rec.GAIN_LOSS,
3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,

Line 3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,

3319: l_okl_k_lines_h_rec.DATE_REPURCHASED,
3320: l_okl_k_lines_h_rec.GAIN_LOSS,
3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,

Line 3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,

3320: l_okl_k_lines_h_rec.GAIN_LOSS,
3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,

Line 3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,

3321: l_okl_k_lines_h_rec.FLOOR_AMOUNT,
3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,

Line 3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,

3322: l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3330: l_okl_k_lines_h_rec.DELIVERED_DATE,

Line 3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,

3323: l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3330: l_okl_k_lines_h_rec.DELIVERED_DATE,
3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,

Line 3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,

3324: l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3330: l_okl_k_lines_h_rec.DELIVERED_DATE,
3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,

Line 3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,

3325: l_okl_k_lines_h_rec.ESTIMATED_OEC,
3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3330: l_okl_k_lines_h_rec.DELIVERED_DATE,
3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3333: l_okl_k_lines_h_rec.OCCUPANCY,

Line 3330: l_okl_k_lines_h_rec.DELIVERED_DATE,

3326: l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3330: l_okl_k_lines_h_rec.DELIVERED_DATE,
3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3333: l_okl_k_lines_h_rec.OCCUPANCY,
3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,

Line 3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,

3327: l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3330: l_okl_k_lines_h_rec.DELIVERED_DATE,
3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3333: l_okl_k_lines_h_rec.OCCUPANCY,
3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,

Line 3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,

3328: l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3330: l_okl_k_lines_h_rec.DELIVERED_DATE,
3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3333: l_okl_k_lines_h_rec.OCCUPANCY,
3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,

Line 3333: l_okl_k_lines_h_rec.OCCUPANCY,

3329: l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
3330: l_okl_k_lines_h_rec.DELIVERED_DATE,
3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3333: l_okl_k_lines_h_rec.OCCUPANCY,
3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,

Line 3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,

3330: l_okl_k_lines_h_rec.DELIVERED_DATE,
3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3333: l_okl_k_lines_h_rec.OCCUPANCY,
3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,

Line 3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,

3331: l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3333: l_okl_k_lines_h_rec.OCCUPANCY,
3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3339: l_okl_k_lines_h_rec.YEAR_BUILT,

Line 3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,

3332: l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
3333: l_okl_k_lines_h_rec.OCCUPANCY,
3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3339: l_okl_k_lines_h_rec.YEAR_BUILT,
3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,

Line 3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,

3333: l_okl_k_lines_h_rec.OCCUPANCY,
3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3339: l_okl_k_lines_h_rec.YEAR_BUILT,
3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,

Line 3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,

3334: l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3339: l_okl_k_lines_h_rec.YEAR_BUILT,
3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3342: l_okl_k_lines_h_rec.NET_RENTABLE,

Line 3339: l_okl_k_lines_h_rec.YEAR_BUILT,

3335: l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3339: l_okl_k_lines_h_rec.YEAR_BUILT,
3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3342: l_okl_k_lines_h_rec.NET_RENTABLE,
3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,

Line 3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,

3336: l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3339: l_okl_k_lines_h_rec.YEAR_BUILT,
3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3342: l_okl_k_lines_h_rec.NET_RENTABLE,
3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,

Line 3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,

3337: l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3339: l_okl_k_lines_h_rec.YEAR_BUILT,
3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3342: l_okl_k_lines_h_rec.NET_RENTABLE,
3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,

Line 3342: l_okl_k_lines_h_rec.NET_RENTABLE,

3338: l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
3339: l_okl_k_lines_h_rec.YEAR_BUILT,
3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3342: l_okl_k_lines_h_rec.NET_RENTABLE,
3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,

Line 3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,

3339: l_okl_k_lines_h_rec.YEAR_BUILT,
3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3342: l_okl_k_lines_h_rec.NET_RENTABLE,
3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,

Line 3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,

3340: l_okl_k_lines_h_rec.COVERAGE_RATIO,
3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3342: l_okl_k_lines_h_rec.NET_RENTABLE,
3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3348: l_okl_k_lines_h_rec.PERCENT,

Line 3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,

3341: l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
3342: l_okl_k_lines_h_rec.NET_RENTABLE,
3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3348: l_okl_k_lines_h_rec.PERCENT,
3349: l_okl_k_lines_h_rec.COVERAGE,

Line 3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,

3342: l_okl_k_lines_h_rec.NET_RENTABLE,
3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3348: l_okl_k_lines_h_rec.PERCENT,
3349: l_okl_k_lines_h_rec.COVERAGE,
3350: l_okl_k_lines_h_rec.LRV_AMOUNT,

Line 3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,

3343: l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3348: l_okl_k_lines_h_rec.PERCENT,
3349: l_okl_k_lines_h_rec.COVERAGE,
3350: l_okl_k_lines_h_rec.LRV_AMOUNT,
3351: l_okl_k_lines_h_rec.AMOUNT,

Line 3348: l_okl_k_lines_h_rec.PERCENT,

3344: l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3348: l_okl_k_lines_h_rec.PERCENT,
3349: l_okl_k_lines_h_rec.COVERAGE,
3350: l_okl_k_lines_h_rec.LRV_AMOUNT,
3351: l_okl_k_lines_h_rec.AMOUNT,
3352: l_okl_k_lines_h_rec.LRS_PERCENT,

Line 3349: l_okl_k_lines_h_rec.COVERAGE,

3345: l_okl_k_lines_h_rec.DATE_APPRAISAL,
3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3348: l_okl_k_lines_h_rec.PERCENT,
3349: l_okl_k_lines_h_rec.COVERAGE,
3350: l_okl_k_lines_h_rec.LRV_AMOUNT,
3351: l_okl_k_lines_h_rec.AMOUNT,
3352: l_okl_k_lines_h_rec.LRS_PERCENT,
3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,

Line 3350: l_okl_k_lines_h_rec.LRV_AMOUNT,

3346: l_okl_k_lines_h_rec.APPRAISAL_VALUE,
3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3348: l_okl_k_lines_h_rec.PERCENT,
3349: l_okl_k_lines_h_rec.COVERAGE,
3350: l_okl_k_lines_h_rec.LRV_AMOUNT,
3351: l_okl_k_lines_h_rec.AMOUNT,
3352: l_okl_k_lines_h_rec.LRS_PERCENT,
3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3354: l_okl_k_lines_h_rec.PERCENT_STAKE,

Line 3351: l_okl_k_lines_h_rec.AMOUNT,

3347: l_okl_k_lines_h_rec.RESIDUAL_VALUE,
3348: l_okl_k_lines_h_rec.PERCENT,
3349: l_okl_k_lines_h_rec.COVERAGE,
3350: l_okl_k_lines_h_rec.LRV_AMOUNT,
3351: l_okl_k_lines_h_rec.AMOUNT,
3352: l_okl_k_lines_h_rec.LRS_PERCENT,
3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3354: l_okl_k_lines_h_rec.PERCENT_STAKE,
3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,

Line 3352: l_okl_k_lines_h_rec.LRS_PERCENT,

3348: l_okl_k_lines_h_rec.PERCENT,
3349: l_okl_k_lines_h_rec.COVERAGE,
3350: l_okl_k_lines_h_rec.LRV_AMOUNT,
3351: l_okl_k_lines_h_rec.AMOUNT,
3352: l_okl_k_lines_h_rec.LRS_PERCENT,
3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3354: l_okl_k_lines_h_rec.PERCENT_STAKE,
3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3356: l_okl_k_lines_h_rec.DATE_SOLD,

Line 3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,

3349: l_okl_k_lines_h_rec.COVERAGE,
3350: l_okl_k_lines_h_rec.LRV_AMOUNT,
3351: l_okl_k_lines_h_rec.AMOUNT,
3352: l_okl_k_lines_h_rec.LRS_PERCENT,
3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3354: l_okl_k_lines_h_rec.PERCENT_STAKE,
3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3356: l_okl_k_lines_h_rec.DATE_SOLD,
3357: l_okl_k_lines_h_rec.STY_ID_FOR,

Line 3354: l_okl_k_lines_h_rec.PERCENT_STAKE,

3350: l_okl_k_lines_h_rec.LRV_AMOUNT,
3351: l_okl_k_lines_h_rec.AMOUNT,
3352: l_okl_k_lines_h_rec.LRS_PERCENT,
3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3354: l_okl_k_lines_h_rec.PERCENT_STAKE,
3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3356: l_okl_k_lines_h_rec.DATE_SOLD,
3357: l_okl_k_lines_h_rec.STY_ID_FOR,
3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,

Line 3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,

3351: l_okl_k_lines_h_rec.AMOUNT,
3352: l_okl_k_lines_h_rec.LRS_PERCENT,
3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3354: l_okl_k_lines_h_rec.PERCENT_STAKE,
3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3356: l_okl_k_lines_h_rec.DATE_SOLD,
3357: l_okl_k_lines_h_rec.STY_ID_FOR,
3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3359: l_okl_k_lines_h_rec.ATTRIBUTE1,

Line 3356: l_okl_k_lines_h_rec.DATE_SOLD,

3352: l_okl_k_lines_h_rec.LRS_PERCENT,
3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3354: l_okl_k_lines_h_rec.PERCENT_STAKE,
3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3356: l_okl_k_lines_h_rec.DATE_SOLD,
3357: l_okl_k_lines_h_rec.STY_ID_FOR,
3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3359: l_okl_k_lines_h_rec.ATTRIBUTE1,
3360: l_okl_k_lines_h_rec.ATTRIBUTE2,

Line 3357: l_okl_k_lines_h_rec.STY_ID_FOR,

3353: l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
3354: l_okl_k_lines_h_rec.PERCENT_STAKE,
3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3356: l_okl_k_lines_h_rec.DATE_SOLD,
3357: l_okl_k_lines_h_rec.STY_ID_FOR,
3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3359: l_okl_k_lines_h_rec.ATTRIBUTE1,
3360: l_okl_k_lines_h_rec.ATTRIBUTE2,
3361: l_okl_k_lines_h_rec.ATTRIBUTE3,

Line 3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,

3354: l_okl_k_lines_h_rec.PERCENT_STAKE,
3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3356: l_okl_k_lines_h_rec.DATE_SOLD,
3357: l_okl_k_lines_h_rec.STY_ID_FOR,
3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3359: l_okl_k_lines_h_rec.ATTRIBUTE1,
3360: l_okl_k_lines_h_rec.ATTRIBUTE2,
3361: l_okl_k_lines_h_rec.ATTRIBUTE3,
3362: l_okl_k_lines_h_rec.ATTRIBUTE4,

Line 3359: l_okl_k_lines_h_rec.ATTRIBUTE1,

3355: l_okl_k_lines_h_rec.AMOUNT_STAKE,
3356: l_okl_k_lines_h_rec.DATE_SOLD,
3357: l_okl_k_lines_h_rec.STY_ID_FOR,
3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3359: l_okl_k_lines_h_rec.ATTRIBUTE1,
3360: l_okl_k_lines_h_rec.ATTRIBUTE2,
3361: l_okl_k_lines_h_rec.ATTRIBUTE3,
3362: l_okl_k_lines_h_rec.ATTRIBUTE4,
3363: l_okl_k_lines_h_rec.ATTRIBUTE5,

Line 3360: l_okl_k_lines_h_rec.ATTRIBUTE2,

3356: l_okl_k_lines_h_rec.DATE_SOLD,
3357: l_okl_k_lines_h_rec.STY_ID_FOR,
3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3359: l_okl_k_lines_h_rec.ATTRIBUTE1,
3360: l_okl_k_lines_h_rec.ATTRIBUTE2,
3361: l_okl_k_lines_h_rec.ATTRIBUTE3,
3362: l_okl_k_lines_h_rec.ATTRIBUTE4,
3363: l_okl_k_lines_h_rec.ATTRIBUTE5,
3364: l_okl_k_lines_h_rec.ATTRIBUTE6,

Line 3361: l_okl_k_lines_h_rec.ATTRIBUTE3,

3357: l_okl_k_lines_h_rec.STY_ID_FOR,
3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3359: l_okl_k_lines_h_rec.ATTRIBUTE1,
3360: l_okl_k_lines_h_rec.ATTRIBUTE2,
3361: l_okl_k_lines_h_rec.ATTRIBUTE3,
3362: l_okl_k_lines_h_rec.ATTRIBUTE4,
3363: l_okl_k_lines_h_rec.ATTRIBUTE5,
3364: l_okl_k_lines_h_rec.ATTRIBUTE6,
3365: l_okl_k_lines_h_rec.ATTRIBUTE7,

Line 3362: l_okl_k_lines_h_rec.ATTRIBUTE4,

3358: l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
3359: l_okl_k_lines_h_rec.ATTRIBUTE1,
3360: l_okl_k_lines_h_rec.ATTRIBUTE2,
3361: l_okl_k_lines_h_rec.ATTRIBUTE3,
3362: l_okl_k_lines_h_rec.ATTRIBUTE4,
3363: l_okl_k_lines_h_rec.ATTRIBUTE5,
3364: l_okl_k_lines_h_rec.ATTRIBUTE6,
3365: l_okl_k_lines_h_rec.ATTRIBUTE7,
3366: l_okl_k_lines_h_rec.ATTRIBUTE8,

Line 3363: l_okl_k_lines_h_rec.ATTRIBUTE5,

3359: l_okl_k_lines_h_rec.ATTRIBUTE1,
3360: l_okl_k_lines_h_rec.ATTRIBUTE2,
3361: l_okl_k_lines_h_rec.ATTRIBUTE3,
3362: l_okl_k_lines_h_rec.ATTRIBUTE4,
3363: l_okl_k_lines_h_rec.ATTRIBUTE5,
3364: l_okl_k_lines_h_rec.ATTRIBUTE6,
3365: l_okl_k_lines_h_rec.ATTRIBUTE7,
3366: l_okl_k_lines_h_rec.ATTRIBUTE8,
3367: l_okl_k_lines_h_rec.ATTRIBUTE9,

Line 3364: l_okl_k_lines_h_rec.ATTRIBUTE6,

3360: l_okl_k_lines_h_rec.ATTRIBUTE2,
3361: l_okl_k_lines_h_rec.ATTRIBUTE3,
3362: l_okl_k_lines_h_rec.ATTRIBUTE4,
3363: l_okl_k_lines_h_rec.ATTRIBUTE5,
3364: l_okl_k_lines_h_rec.ATTRIBUTE6,
3365: l_okl_k_lines_h_rec.ATTRIBUTE7,
3366: l_okl_k_lines_h_rec.ATTRIBUTE8,
3367: l_okl_k_lines_h_rec.ATTRIBUTE9,
3368: l_okl_k_lines_h_rec.ATTRIBUTE10,

Line 3365: l_okl_k_lines_h_rec.ATTRIBUTE7,

3361: l_okl_k_lines_h_rec.ATTRIBUTE3,
3362: l_okl_k_lines_h_rec.ATTRIBUTE4,
3363: l_okl_k_lines_h_rec.ATTRIBUTE5,
3364: l_okl_k_lines_h_rec.ATTRIBUTE6,
3365: l_okl_k_lines_h_rec.ATTRIBUTE7,
3366: l_okl_k_lines_h_rec.ATTRIBUTE8,
3367: l_okl_k_lines_h_rec.ATTRIBUTE9,
3368: l_okl_k_lines_h_rec.ATTRIBUTE10,
3369: l_okl_k_lines_h_rec.ATTRIBUTE11,

Line 3366: l_okl_k_lines_h_rec.ATTRIBUTE8,

3362: l_okl_k_lines_h_rec.ATTRIBUTE4,
3363: l_okl_k_lines_h_rec.ATTRIBUTE5,
3364: l_okl_k_lines_h_rec.ATTRIBUTE6,
3365: l_okl_k_lines_h_rec.ATTRIBUTE7,
3366: l_okl_k_lines_h_rec.ATTRIBUTE8,
3367: l_okl_k_lines_h_rec.ATTRIBUTE9,
3368: l_okl_k_lines_h_rec.ATTRIBUTE10,
3369: l_okl_k_lines_h_rec.ATTRIBUTE11,
3370: l_okl_k_lines_h_rec.ATTRIBUTE12,

Line 3367: l_okl_k_lines_h_rec.ATTRIBUTE9,

3363: l_okl_k_lines_h_rec.ATTRIBUTE5,
3364: l_okl_k_lines_h_rec.ATTRIBUTE6,
3365: l_okl_k_lines_h_rec.ATTRIBUTE7,
3366: l_okl_k_lines_h_rec.ATTRIBUTE8,
3367: l_okl_k_lines_h_rec.ATTRIBUTE9,
3368: l_okl_k_lines_h_rec.ATTRIBUTE10,
3369: l_okl_k_lines_h_rec.ATTRIBUTE11,
3370: l_okl_k_lines_h_rec.ATTRIBUTE12,
3371: l_okl_k_lines_h_rec.ATTRIBUTE13,

Line 3368: l_okl_k_lines_h_rec.ATTRIBUTE10,

3364: l_okl_k_lines_h_rec.ATTRIBUTE6,
3365: l_okl_k_lines_h_rec.ATTRIBUTE7,
3366: l_okl_k_lines_h_rec.ATTRIBUTE8,
3367: l_okl_k_lines_h_rec.ATTRIBUTE9,
3368: l_okl_k_lines_h_rec.ATTRIBUTE10,
3369: l_okl_k_lines_h_rec.ATTRIBUTE11,
3370: l_okl_k_lines_h_rec.ATTRIBUTE12,
3371: l_okl_k_lines_h_rec.ATTRIBUTE13,
3372: l_okl_k_lines_h_rec.ATTRIBUTE14,

Line 3369: l_okl_k_lines_h_rec.ATTRIBUTE11,

3365: l_okl_k_lines_h_rec.ATTRIBUTE7,
3366: l_okl_k_lines_h_rec.ATTRIBUTE8,
3367: l_okl_k_lines_h_rec.ATTRIBUTE9,
3368: l_okl_k_lines_h_rec.ATTRIBUTE10,
3369: l_okl_k_lines_h_rec.ATTRIBUTE11,
3370: l_okl_k_lines_h_rec.ATTRIBUTE12,
3371: l_okl_k_lines_h_rec.ATTRIBUTE13,
3372: l_okl_k_lines_h_rec.ATTRIBUTE14,
3373: l_okl_k_lines_h_rec.ATTRIBUTE15,

Line 3370: l_okl_k_lines_h_rec.ATTRIBUTE12,

3366: l_okl_k_lines_h_rec.ATTRIBUTE8,
3367: l_okl_k_lines_h_rec.ATTRIBUTE9,
3368: l_okl_k_lines_h_rec.ATTRIBUTE10,
3369: l_okl_k_lines_h_rec.ATTRIBUTE11,
3370: l_okl_k_lines_h_rec.ATTRIBUTE12,
3371: l_okl_k_lines_h_rec.ATTRIBUTE13,
3372: l_okl_k_lines_h_rec.ATTRIBUTE14,
3373: l_okl_k_lines_h_rec.ATTRIBUTE15,
3374: l_okl_k_lines_h_rec.CREATED_BY,

Line 3371: l_okl_k_lines_h_rec.ATTRIBUTE13,

3367: l_okl_k_lines_h_rec.ATTRIBUTE9,
3368: l_okl_k_lines_h_rec.ATTRIBUTE10,
3369: l_okl_k_lines_h_rec.ATTRIBUTE11,
3370: l_okl_k_lines_h_rec.ATTRIBUTE12,
3371: l_okl_k_lines_h_rec.ATTRIBUTE13,
3372: l_okl_k_lines_h_rec.ATTRIBUTE14,
3373: l_okl_k_lines_h_rec.ATTRIBUTE15,
3374: l_okl_k_lines_h_rec.CREATED_BY,
3375: l_okl_k_lines_h_rec.CREATION_DATE,

Line 3372: l_okl_k_lines_h_rec.ATTRIBUTE14,

3368: l_okl_k_lines_h_rec.ATTRIBUTE10,
3369: l_okl_k_lines_h_rec.ATTRIBUTE11,
3370: l_okl_k_lines_h_rec.ATTRIBUTE12,
3371: l_okl_k_lines_h_rec.ATTRIBUTE13,
3372: l_okl_k_lines_h_rec.ATTRIBUTE14,
3373: l_okl_k_lines_h_rec.ATTRIBUTE15,
3374: l_okl_k_lines_h_rec.CREATED_BY,
3375: l_okl_k_lines_h_rec.CREATION_DATE,
3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,

Line 3373: l_okl_k_lines_h_rec.ATTRIBUTE15,

3369: l_okl_k_lines_h_rec.ATTRIBUTE11,
3370: l_okl_k_lines_h_rec.ATTRIBUTE12,
3371: l_okl_k_lines_h_rec.ATTRIBUTE13,
3372: l_okl_k_lines_h_rec.ATTRIBUTE14,
3373: l_okl_k_lines_h_rec.ATTRIBUTE15,
3374: l_okl_k_lines_h_rec.CREATED_BY,
3375: l_okl_k_lines_h_rec.CREATION_DATE,
3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,

Line 3374: l_okl_k_lines_h_rec.CREATED_BY,

3370: l_okl_k_lines_h_rec.ATTRIBUTE12,
3371: l_okl_k_lines_h_rec.ATTRIBUTE13,
3372: l_okl_k_lines_h_rec.ATTRIBUTE14,
3373: l_okl_k_lines_h_rec.ATTRIBUTE15,
3374: l_okl_k_lines_h_rec.CREATED_BY,
3375: l_okl_k_lines_h_rec.CREATION_DATE,
3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,

Line 3375: l_okl_k_lines_h_rec.CREATION_DATE,

3371: l_okl_k_lines_h_rec.ATTRIBUTE13,
3372: l_okl_k_lines_h_rec.ATTRIBUTE14,
3373: l_okl_k_lines_h_rec.ATTRIBUTE15,
3374: l_okl_k_lines_h_rec.CREATED_BY,
3375: l_okl_k_lines_h_rec.CREATION_DATE,
3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3379: l_okl_k_lines_h_rec.NTY_CODE,

Line 3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,

3372: l_okl_k_lines_h_rec.ATTRIBUTE14,
3373: l_okl_k_lines_h_rec.ATTRIBUTE15,
3374: l_okl_k_lines_h_rec.CREATED_BY,
3375: l_okl_k_lines_h_rec.CREATION_DATE,
3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3379: l_okl_k_lines_h_rec.NTY_CODE,
3380: l_okl_k_lines_h_rec.FCG_CODE,

Line 3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,

3373: l_okl_k_lines_h_rec.ATTRIBUTE15,
3374: l_okl_k_lines_h_rec.CREATED_BY,
3375: l_okl_k_lines_h_rec.CREATION_DATE,
3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3379: l_okl_k_lines_h_rec.NTY_CODE,
3380: l_okl_k_lines_h_rec.FCG_CODE,
3381: l_okl_k_lines_h_rec.PRC_CODE,

Line 3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,

3374: l_okl_k_lines_h_rec.CREATED_BY,
3375: l_okl_k_lines_h_rec.CREATION_DATE,
3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3379: l_okl_k_lines_h_rec.NTY_CODE,
3380: l_okl_k_lines_h_rec.FCG_CODE,
3381: l_okl_k_lines_h_rec.PRC_CODE,
3382: l_okl_k_lines_h_rec.RE_LEASE_YN,

Line 3379: l_okl_k_lines_h_rec.NTY_CODE,

3375: l_okl_k_lines_h_rec.CREATION_DATE,
3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3379: l_okl_k_lines_h_rec.NTY_CODE,
3380: l_okl_k_lines_h_rec.FCG_CODE,
3381: l_okl_k_lines_h_rec.PRC_CODE,
3382: l_okl_k_lines_h_rec.RE_LEASE_YN,
3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,

Line 3380: l_okl_k_lines_h_rec.FCG_CODE,

3376: l_okl_k_lines_h_rec.LAST_UPDATED_BY,
3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3379: l_okl_k_lines_h_rec.NTY_CODE,
3380: l_okl_k_lines_h_rec.FCG_CODE,
3381: l_okl_k_lines_h_rec.PRC_CODE,
3382: l_okl_k_lines_h_rec.RE_LEASE_YN,
3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,

Line 3381: l_okl_k_lines_h_rec.PRC_CODE,

3377: l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3379: l_okl_k_lines_h_rec.NTY_CODE,
3380: l_okl_k_lines_h_rec.FCG_CODE,
3381: l_okl_k_lines_h_rec.PRC_CODE,
3382: l_okl_k_lines_h_rec.RE_LEASE_YN,
3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,

Line 3382: l_okl_k_lines_h_rec.RE_LEASE_YN,

3378: l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
3379: l_okl_k_lines_h_rec.NTY_CODE,
3380: l_okl_k_lines_h_rec.FCG_CODE,
3381: l_okl_k_lines_h_rec.PRC_CODE,
3382: l_okl_k_lines_h_rec.RE_LEASE_YN,
3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3386: l_okl_k_lines_h_rec.CLG_ID,

Line 3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,

3379: l_okl_k_lines_h_rec.NTY_CODE,
3380: l_okl_k_lines_h_rec.FCG_CODE,
3381: l_okl_k_lines_h_rec.PRC_CODE,
3382: l_okl_k_lines_h_rec.RE_LEASE_YN,
3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3386: l_okl_k_lines_h_rec.CLG_ID,
3387: l_okl_k_lines_h_rec.DATE_FUNDING,

Line 3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,

3380: l_okl_k_lines_h_rec.FCG_CODE,
3381: l_okl_k_lines_h_rec.PRC_CODE,
3382: l_okl_k_lines_h_rec.RE_LEASE_YN,
3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3386: l_okl_k_lines_h_rec.CLG_ID,
3387: l_okl_k_lines_h_rec.DATE_FUNDING,
3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,

Line 3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,

3381: l_okl_k_lines_h_rec.PRC_CODE,
3382: l_okl_k_lines_h_rec.RE_LEASE_YN,
3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3386: l_okl_k_lines_h_rec.CLG_ID,
3387: l_okl_k_lines_h_rec.DATE_FUNDING,
3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,

Line 3386: l_okl_k_lines_h_rec.CLG_ID,

3382: l_okl_k_lines_h_rec.RE_LEASE_YN,
3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3386: l_okl_k_lines_h_rec.CLG_ID,
3387: l_okl_k_lines_h_rec.DATE_FUNDING,
3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,

Line 3387: l_okl_k_lines_h_rec.DATE_FUNDING,

3383: l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3386: l_okl_k_lines_h_rec.CLG_ID,
3387: l_okl_k_lines_h_rec.DATE_FUNDING,
3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3391: l_okl_k_lines_h_rec.OEC,

Line 3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,

3384: l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3386: l_okl_k_lines_h_rec.CLG_ID,
3387: l_okl_k_lines_h_rec.DATE_FUNDING,
3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3391: l_okl_k_lines_h_rec.OEC,
3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,

Line 3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,

3385: l_okl_k_lines_h_rec.SECURED_DEAL_YN,
3386: l_okl_k_lines_h_rec.CLG_ID,
3387: l_okl_k_lines_h_rec.DATE_FUNDING,
3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3391: l_okl_k_lines_h_rec.OEC,
3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,

Line 3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,

3386: l_okl_k_lines_h_rec.CLG_ID,
3387: l_okl_k_lines_h_rec.DATE_FUNDING,
3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3391: l_okl_k_lines_h_rec.OEC,
3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,

Line 3391: l_okl_k_lines_h_rec.OEC,

3387: l_okl_k_lines_h_rec.DATE_FUNDING,
3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3391: l_okl_k_lines_h_rec.OEC,
3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3395: l_okl_k_lines_h_rec.RVI_PREMIUM,

Line 3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,

3388: l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3391: l_okl_k_lines_h_rec.OEC,
3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3395: l_okl_k_lines_h_rec.RVI_PREMIUM,
3396: l_okl_k_lines_h_rec.CREDIT_NATURE,

Line 3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,

3389: l_okl_k_lines_h_rec.DATE_ACCEPTED,
3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3391: l_okl_k_lines_h_rec.OEC,
3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3395: l_okl_k_lines_h_rec.RVI_PREMIUM,
3396: l_okl_k_lines_h_rec.CREDIT_NATURE,
3397: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,

Line 3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,

3390: l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
3391: l_okl_k_lines_h_rec.OEC,
3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3395: l_okl_k_lines_h_rec.RVI_PREMIUM,
3396: l_okl_k_lines_h_rec.CREDIT_NATURE,
3397: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3398: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,

Line 3395: l_okl_k_lines_h_rec.RVI_PREMIUM,

3391: l_okl_k_lines_h_rec.OEC,
3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3395: l_okl_k_lines_h_rec.RVI_PREMIUM,
3396: l_okl_k_lines_h_rec.CREDIT_NATURE,
3397: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3398: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3399: --Bug# 2697681 11.5.9

Line 3396: l_okl_k_lines_h_rec.CREDIT_NATURE,

3392: l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3395: l_okl_k_lines_h_rec.RVI_PREMIUM,
3396: l_okl_k_lines_h_rec.CREDIT_NATURE,
3397: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3398: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3399: --Bug# 2697681 11.5.9
3400: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,

Line 3397: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,

3393: l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3395: l_okl_k_lines_h_rec.RVI_PREMIUM,
3396: l_okl_k_lines_h_rec.CREDIT_NATURE,
3397: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3398: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3399: --Bug# 2697681 11.5.9
3400: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3401: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,

Line 3398: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,

3394: l_okl_k_lines_h_rec.RESIDUAL_CODE,
3395: l_okl_k_lines_h_rec.RVI_PREMIUM,
3396: l_okl_k_lines_h_rec.CREDIT_NATURE,
3397: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3398: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3399: --Bug# 2697681 11.5.9
3400: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3401: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3402: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,

Line 3400: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,

3396: l_okl_k_lines_h_rec.CREDIT_NATURE,
3397: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3398: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3399: --Bug# 2697681 11.5.9
3400: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3401: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3402: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3403: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3404: --financed fees

Line 3401: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,

3397: l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
3398: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3399: --Bug# 2697681 11.5.9
3400: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3401: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3402: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3403: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3404: --financed fees
3405: l_okl_k_lines_h_rec.FEE_TYPE,

Line 3402: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,

3398: l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
3399: --Bug# 2697681 11.5.9
3400: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3401: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3402: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3403: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3404: --financed fees
3405: l_okl_k_lines_h_rec.FEE_TYPE,
3406: --Bug# 3143522: 11.5.10

Line 3403: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,

3399: --Bug# 2697681 11.5.9
3400: l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
3401: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3402: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3403: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3404: --financed fees
3405: l_okl_k_lines_h_rec.FEE_TYPE,
3406: --Bug# 3143522: 11.5.10
3407: --subsidy

Line 3405: l_okl_k_lines_h_rec.FEE_TYPE,

3401: l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
3402: l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
3403: l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
3404: --financed fees
3405: l_okl_k_lines_h_rec.FEE_TYPE,
3406: --Bug# 3143522: 11.5.10
3407: --subsidy
3408: l_okl_k_lines_h_rec.SUBSIDY_ID,
3409: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,

Line 3408: l_okl_k_lines_h_rec.SUBSIDY_ID,

3404: --financed fees
3405: l_okl_k_lines_h_rec.FEE_TYPE,
3406: --Bug# 3143522: 11.5.10
3407: --subsidy
3408: l_okl_k_lines_h_rec.SUBSIDY_ID,
3409: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3410: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3411: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3412: --financed fee

Line 3409: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,

3405: l_okl_k_lines_h_rec.FEE_TYPE,
3406: --Bug# 3143522: 11.5.10
3407: --subsidy
3408: l_okl_k_lines_h_rec.SUBSIDY_ID,
3409: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3410: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3411: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3412: --financed fee
3413: l_okl_k_lines_h_rec.PRE_TAX_YIELD,

Line 3410: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,

3406: --Bug# 3143522: 11.5.10
3407: --subsidy
3408: l_okl_k_lines_h_rec.SUBSIDY_ID,
3409: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3410: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3411: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3412: --financed fee
3413: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3414: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,

Line 3411: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,

3407: --subsidy
3408: l_okl_k_lines_h_rec.SUBSIDY_ID,
3409: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3410: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3411: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3412: --financed fee
3413: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3414: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3415: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,

Line 3413: l_okl_k_lines_h_rec.PRE_TAX_YIELD,

3409: --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
3410: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3411: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3412: --financed fee
3413: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3414: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3415: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3416: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3417: l_okl_k_lines_h_rec.PRE_TAX_IRR,

Line 3414: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,

3410: --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
3411: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3412: --financed fee
3413: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3414: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3415: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3416: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3417: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3418: l_okl_k_lines_h_rec.AFTER_TAX_IRR,

Line 3415: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,

3411: l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
3412: --financed fee
3413: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3414: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3415: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3416: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3417: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3418: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3419: --quote

Line 3416: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,

3412: --financed fee
3413: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3414: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3415: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3416: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3417: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3418: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3419: --quote
3420: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,

Line 3417: l_okl_k_lines_h_rec.PRE_TAX_IRR,

3413: l_okl_k_lines_h_rec.PRE_TAX_YIELD,
3414: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3415: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3416: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3417: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3418: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3419: --quote
3420: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3421: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,

Line 3418: l_okl_k_lines_h_rec.AFTER_TAX_IRR,

3414: l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
3415: l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
3416: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3417: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3418: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3419: --quote
3420: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3421: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3422: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,

Line 3420: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,

3416: l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3417: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3418: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3419: --quote
3420: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3421: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3422: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3423: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3424: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,

Line 3421: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,

3417: l_okl_k_lines_h_rec.PRE_TAX_IRR,
3418: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3419: --quote
3420: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3421: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3422: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3423: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3424: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3425: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,

Line 3422: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,

3418: l_okl_k_lines_h_rec.AFTER_TAX_IRR,
3419: --quote
3420: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3421: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3422: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3423: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3424: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3425: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3426: --Bug#2994971

Line 3423: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,

3419: --quote
3420: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3421: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3422: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3423: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3424: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3425: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3426: --Bug#2994971
3427: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,

Line 3424: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,

3420: l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
3421: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3422: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3423: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3424: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3425: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3426: --Bug#2994971
3427: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3428: --Bug# 3973640: 11.5.10+

Line 3425: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,

3421: l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
3422: l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
3423: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3424: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3425: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3426: --Bug#2994971
3427: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3428: --Bug# 3973640: 11.5.10+
3429: l_okl_k_lines_h_rec.QTE_ID,

Line 3427: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,

3423: l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3424: l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
3425: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3426: --Bug#2994971
3427: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3428: --Bug# 3973640: 11.5.10+
3429: l_okl_k_lines_h_rec.QTE_ID,
3430: l_okl_k_lines_h_rec.FUNDING_DATE,
3431: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,

Line 3429: l_okl_k_lines_h_rec.QTE_ID,

3425: l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
3426: --Bug#2994971
3427: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3428: --Bug# 3973640: 11.5.10+
3429: l_okl_k_lines_h_rec.QTE_ID,
3430: l_okl_k_lines_h_rec.FUNDING_DATE,
3431: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3432: --Bug# 4419339 OKLH
3433: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,

Line 3430: l_okl_k_lines_h_rec.FUNDING_DATE,

3426: --Bug#2994971
3427: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3428: --Bug# 3973640: 11.5.10+
3429: l_okl_k_lines_h_rec.QTE_ID,
3430: l_okl_k_lines_h_rec.FUNDING_DATE,
3431: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3432: --Bug# 4419339 OKLH
3433: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3434: l_okl_k_lines_h_rec.MANUFACTURER_NAME,

Line 3431: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,

3427: l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
3428: --Bug# 3973640: 11.5.10+
3429: l_okl_k_lines_h_rec.QTE_ID,
3430: l_okl_k_lines_h_rec.FUNDING_DATE,
3431: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3432: --Bug# 4419339 OKLH
3433: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3434: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3435: l_okl_k_lines_h_rec.MODEL_NUMBER,

Line 3433: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,

3429: l_okl_k_lines_h_rec.QTE_ID,
3430: l_okl_k_lines_h_rec.FUNDING_DATE,
3431: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3432: --Bug# 4419339 OKLH
3433: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3434: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3435: l_okl_k_lines_h_rec.MODEL_NUMBER,
3436: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3437: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,

Line 3434: l_okl_k_lines_h_rec.MANUFACTURER_NAME,

3430: l_okl_k_lines_h_rec.FUNDING_DATE,
3431: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3432: --Bug# 4419339 OKLH
3433: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3434: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3435: l_okl_k_lines_h_rec.MODEL_NUMBER,
3436: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3437: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3438: --Bug#4373029

Line 3435: l_okl_k_lines_h_rec.MODEL_NUMBER,

3431: l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
3432: --Bug# 4419339 OKLH
3433: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3434: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3435: l_okl_k_lines_h_rec.MODEL_NUMBER,
3436: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3437: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3438: --Bug#4373029
3439: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,

Line 3436: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,

3432: --Bug# 4419339 OKLH
3433: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3434: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3435: l_okl_k_lines_h_rec.MODEL_NUMBER,
3436: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3437: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3438: --Bug#4373029
3439: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3440: l_okl_k_lines_h_rec.TERMINATION_VALUE,

Line 3437: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,

3433: l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
3434: l_okl_k_lines_h_rec.MANUFACTURER_NAME,
3435: l_okl_k_lines_h_rec.MODEL_NUMBER,
3436: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3437: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3438: --Bug#4373029
3439: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3440: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3441: --Bug# 4631549

Line 3439: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,

3435: l_okl_k_lines_h_rec.MODEL_NUMBER,
3436: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3437: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3438: --Bug#4373029
3439: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3440: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3441: --Bug# 4631549
3442: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
3443:

Line 3440: l_okl_k_lines_h_rec.TERMINATION_VALUE,

3436: l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
3437: l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
3438: --Bug#4373029
3439: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3440: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3441: --Bug# 4631549
3442: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
3443:
3444: );

Line 3442: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST

3438: --Bug#4373029
3439: l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
3440: l_okl_k_lines_h_rec.TERMINATION_VALUE,
3441: --Bug# 4631549
3442: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
3443:
3444: );
3445: -- Set OUT values
3446: x_okl_k_lines_h_rec := l_okl_k_lines_h_rec;

Line 3446: x_okl_k_lines_h_rec := l_okl_k_lines_h_rec;

3442: l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
3443:
3444: );
3445: -- Set OUT values
3446: x_okl_k_lines_h_rec := l_okl_k_lines_h_rec;
3447: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3448:
3449: EXCEPTION
3450: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3484: -- insert_row for: OKL_K_LINES --

3480:
3481: END insert_row;
3482:
3483: ------------------------------------
3484: -- insert_row for: OKL_K_LINES --
3485: ------------------------------------
3486:
3487: PROCEDURE insert_row(
3488:

Line 3503: -- Set_Attributes for: OKL_K_LINES --

3499: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3500: l_kle_rec kle_rec_type := p_kle_rec;
3501: l_def_kle_rec kle_rec_type;
3502: ----------------------------------------
3503: -- Set_Attributes for: OKL_K_LINES --
3504: ----------------------------------------
3505: FUNCTION Set_Attributes (
3506: p_kle_rec IN kle_rec_type,
3507: x_kle_rec OUT NOCOPY kle_rec_type

Line 3539: INSERT INTO OKL_K_LINES(

3535: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3536: RAISE OKC_API.G_EXCEPTION_ERROR;
3537: END IF;
3538:
3539: INSERT INTO OKL_K_LINES(
3540: ID,
3541: KLE_ID,
3542: STY_ID,
3543: OBJECT_VERSION_NUMBER,

Line 3860: -- insert_row for: OKL_K_LINES_V --

3856:
3857: END insert_row;
3858:
3859: ------------------------------------
3860: -- insert_row for: OKL_K_LINES_V --
3861: ------------------------------------
3862:
3863: PROCEDURE insert_row(
3864:

Line 3896: -- Set_Attributes for: OKL_K_LINES_V --

3892: l_klev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3893: RETURN(l_klev_rec);
3894: END fill_who_columns;
3895: ----------------------------------------
3896: -- Set_Attributes for: OKL_K_LINES_V --
3897: ----------------------------------------
3898: FUNCTION Set_Attributes (
3899: p_klev_rec IN klev_rec_type,
3900: x_klev_rec OUT NOCOPY klev_rec_type

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

4021:
4022: END insert_row;
4023:
4024: ----------------------------------------
4025: -- PL/SQL TBL insert_row for: OKL_K_LINES_V --
4026: ----------------------------------------
4027:
4028: PROCEDURE insert_row(
4029:

Line 4101: -- lock_row for: OKL_K_LINES --

4097: -- PROCEDURE lock_row
4098: ---------------------------------------------------------------------------
4099:
4100: --------------------------------
4101: -- lock_row for: OKL_K_LINES --
4102: --------------------------------
4103:
4104: PROCEDURE lock_row(
4105:

Line 4117: FROM OKL_K_LINES

4113: E_Resource_Busy EXCEPTION;
4114: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
4115: CURSOR lock_csr (p_kle_rec IN kle_rec_type) IS
4116: SELECT OBJECT_VERSION_NUMBER
4117: FROM OKL_K_LINES
4118: WHERE ID = p_kle_rec.id
4119: AND OBJECT_VERSION_NUMBER = p_kle_rec.object_version_number
4120: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
4121:

Line 4124: FROM OKL_K_LINES

4120: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
4121:
4122: CURSOR lchk_csr (p_kle_rec IN kle_rec_type) IS
4123: SELECT OBJECT_VERSION_NUMBER
4124: FROM OKL_K_LINES
4125: WHERE ID = p_kle_rec.id;
4126: l_api_version CONSTANT NUMBER := 1;
4127: l_api_name CONSTANT VARCHAR2(30) := 'rec_lock_row';
4128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4129: l_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;

4125: WHERE ID = p_kle_rec.id;
4126: l_api_version CONSTANT NUMBER := 1;
4127: l_api_name CONSTANT VARCHAR2(30) := 'rec_lock_row';
4128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4129: l_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;
4130: lc_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;
4131: l_row_notfound BOOLEAN := FALSE;
4132: lc_row_notfound BOOLEAN := FALSE;
4133: BEGIN

Line 4130: lc_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;

4126: l_api_version CONSTANT NUMBER := 1;
4127: l_api_name CONSTANT VARCHAR2(30) := 'rec_lock_row';
4128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4129: l_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;
4130: lc_object_version_number OKL_K_LINES.OBJECT_VERSION_NUMBER%TYPE;
4131: l_row_notfound BOOLEAN := FALSE;
4132: lc_row_notfound BOOLEAN := FALSE;
4133: BEGIN
4134: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4215: -- lock_row for: OKL_K_LINES_V --

4211:
4212: END lock_row;
4213:
4214: ----------------------------------
4215: -- lock_row for: OKL_K_LINES_V --
4216: ----------------------------------
4217:
4218: PROCEDURE lock_row(
4219:

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

4300: );
4301:
4302: END lock_row;
4303: --------------------------------------
4304: -- PL/SQL TBL lock_row for: OKL_K_LINES_V --
4305: --------------------------------------
4306:
4307: PROCEDURE lock_row(
4308:

Line 4378: -- update_row for: OKL_K_LINES --

4374: -- PROCEDURE update_row
4375: ---------------------------------------------------------------------------
4376:
4377: ----------------------------------
4378: -- update_row for: OKL_K_LINES --
4379: ----------------------------------
4380:
4381: PROCEDURE update_row(
4382:

Line 4397: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;

4393: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4394: l_kle_rec kle_rec_type := p_kle_rec;
4395: l_def_kle_rec kle_rec_type;
4396: l_row_notfound BOOLEAN := TRUE;
4397: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
4398: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;
4399: ----------------------------------
4400: -- FUNCTION populate_new_record --
4401: ----------------------------------

Line 4398: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;

4394: l_kle_rec kle_rec_type := p_kle_rec;
4395: l_def_kle_rec kle_rec_type;
4396: l_row_notfound BOOLEAN := TRUE;
4397: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
4398: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;
4399: ----------------------------------
4400: -- FUNCTION populate_new_record --
4401: ----------------------------------
4402: FUNCTION populate_new_record (

Line 4419: migrate(l_kle_rec, l_okl_k_lines_h_rec);

4415: END IF;
4416: -- Move the "old" record to the history record:
4417: -- (1) to get the "old" version
4418: -- (2) to avoid 2 hits to the database
4419: migrate(l_kle_rec, l_okl_k_lines_h_rec);
4420:
4421: IF (x_kle_rec.ID = OKC_API.G_MISS_NUM) THEN
4422: x_kle_rec.ID := l_kle_rec.ID;
4423: END IF;

Line 4925: -- Set_Attributes for: OKL_K_LINES --

4921:
4922: RETURN(l_return_status);
4923: END populate_new_record;
4924: --------------------------------------
4925: -- Set_Attributes for: OKL_K_LINES --
4926: --------------------------------------
4927: FUNCTION Set_Attributes (
4928: p_kle_rec IN kle_rec_type,
4929: x_kle_rec OUT NOCOPY kle_rec_type

Line 4968: UPDATE OKL_K_LINES

4964: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4965: RAISE OKC_API.G_EXCEPTION_ERROR;
4966: END IF;
4967:
4968: UPDATE OKL_K_LINES
4969: SET
4970: ID = l_def_kle_rec.ID,
4971: KLE_ID = l_def_kle_rec.KLE_ID,
4972: STY_ID = l_def_kle_rec.STY_ID,

Line 5119: l_okl_k_lines_h_rec,

5115: p_init_msg_list,
5116: x_return_status,
5117: x_msg_count,
5118: x_msg_data,
5119: l_okl_k_lines_h_rec,
5120: lx_okl_k_lines_h_rec
5121: );
5122:
5123: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5120: lx_okl_k_lines_h_rec

5116: x_return_status,
5117: x_msg_count,
5118: x_msg_data,
5119: l_okl_k_lines_h_rec,
5120: lx_okl_k_lines_h_rec
5121: );
5122:
5123: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5168: -- update_row for: OKL_K_LINES_V --

5164:
5165: END update_row;
5166:
5167: ------------------------------------
5168: -- update_row for: OKL_K_LINES_V --
5169: ------------------------------------
5170:
5171: PROCEDURE update_row(
5172:

Line 5722: -- Set_Attributes for: OKL_K_LINES_V --

5718:
5719: RETURN(l_return_status);
5720: END populate_new_record;
5721: ----------------------------------------
5722: -- Set_Attributes for: OKL_K_LINES_V --
5723: ----------------------------------------
5724: FUNCTION Set_Attributes (
5725: p_klev_rec IN klev_rec_type,
5726: x_klev_rec OUT NOCOPY klev_rec_type

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

5846: );
5847:
5848: END update_row;
5849: ----------------------------------------
5850: -- PL/SQL TBL update_row for: OKL_K_LINES_V --
5851: ----------------------------------------
5852:
5853: PROCEDURE update_row(
5854:

Line 5927: -- delete_row for: OKL_K_LINES --

5923: -- PROCEDURE delete_row
5924: ---------------------------------------------------------------------------
5925:
5926: ----------------------------------
5927: -- delete_row for: OKL_K_LINES --
5928: ----------------------------------
5929:
5930: PROCEDURE delete_row(
5931:

Line 5944: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;

5940: l_api_name CONSTANT VARCHAR2(30) := 'rec_delete_row';
5941: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5942: l_kle_rec kle_rec_type:= p_kle_rec;
5943: l_row_notfound BOOLEAN := TRUE;
5944: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
5945: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;
5946: BEGIN
5947: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5948: p_init_msg_list,

Line 5945: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;

5941: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5942: l_kle_rec kle_rec_type:= p_kle_rec;
5943: l_row_notfound BOOLEAN := TRUE;
5944: l_okl_k_lines_h_rec okl_k_lines_h_rec_type;
5945: lx_okl_k_lines_h_rec okl_k_lines_h_rec_type;
5946: BEGIN
5947: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5948: p_init_msg_list,
5949: '_PVT',

Line 5964: migrate(l_kle_rec, l_okl_k_lines_h_rec);

5960: l_kle_rec := get_rec(l_kle_rec, l_row_notfound);
5961: IF (l_row_notfound) THEN
5962: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5963: END IF;
5964: migrate(l_kle_rec, l_okl_k_lines_h_rec);
5965: insert_row(
5966: l_api_version,
5967: p_init_msg_list,
5968: x_return_status,

Line 5971: l_okl_k_lines_h_rec,

5967: p_init_msg_list,
5968: x_return_status,
5969: x_msg_count,
5970: x_msg_data,
5971: l_okl_k_lines_h_rec,
5972: lx_okl_k_lines_h_rec
5973: );
5974:
5975: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5972: lx_okl_k_lines_h_rec

5968: x_return_status,
5969: x_msg_count,
5970: x_msg_data,
5971: l_okl_k_lines_h_rec,
5972: lx_okl_k_lines_h_rec
5973: );
5974:
5975: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5976: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5981: DELETE FROM OKL_K_LINES

5977: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5978: RAISE OKC_API.G_EXCEPTION_ERROR;
5979: END IF;
5980: */
5981: DELETE FROM OKL_K_LINES
5982: WHERE ID = l_kle_rec.id;
5983:
5984: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5985:

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

6103: );
6104:
6105: END delete_row;
6106: ----------------------------------------
6107: -- PL/SQL TBL delete_row for: OKL_K_LINES_V --
6108: ----------------------------------------
6109:
6110: PROCEDURE delete_row(
6111:

Line 6187: INSERT INTO OKL_K_LINES_H

6183:
6184: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
6185:
6186: BEGIN
6187: INSERT INTO OKL_K_LINES_H
6188: (
6189: major_version,
6190: ID,
6191: KLE_ID,

Line 6472: FROM OKL_K_LINES

6468: TERMINATION_VALUE,
6469: --Bug# 4631549
6470: EXPECTED_ASSET_COST
6471:
6472: FROM OKL_K_LINES
6473: WHERE id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);
6474:
6475: RETURN l_return_status;
6476: EXCEPTION

Line 6499: INSERT INTO OKL_K_LINES

6495:
6496: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
6497:
6498: BEGIN
6499: INSERT INTO OKL_K_LINES
6500: (
6501: ID,
6502: KLE_ID,
6503: STY_ID,

Line 6783: FROM OKL_K_LINES_H

6779: TERMINATION_VALUE,
6780: --Bug# 4631549
6781: EXPECTED_ASSET_COST
6782:
6783: FROM OKL_K_LINES_H
6784: WHERE id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id) and major_version = p_major_version;
6785:
6786:
6787: RETURN l_return_status;