DBA Data[Home] [Help]

APPS.OKL_KHR_PVT dependencies on OKL_K_HEADERS

Line 12: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_K_HEADERS_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_HEADERS_V';
13:
14: G_EXCEPTION_HALT_VALIDATION exception;
15:
16:

Line 53: p_token3_value=> 'OKL_K_HEADERS_V');

49: p_token1_value=> 'khr_id',
50: p_token2 => g_child_table_token,
51: p_token2_value=> G_VIEW,
52: p_token3 => g_parent_table_token,
53: p_token3_value=> 'OKL_K_HEADERS_V');
54: -- notify caller of an error
55: x_return_status := OKC_API.G_RET_STS_ERROR;
56: End If;
57: end if;

Line 110: p_token3_value=> 'OKL_K_HEADERS_V');

106: p_token1_value=> 'pdt_id',
107: p_token2 => g_child_table_token,
108: p_token2_value=> G_VIEW,
109: p_token3 => g_parent_table_token,
110: p_token3_value=> 'OKL_K_HEADERS_V');
111: -- notify caller of an error
112: x_return_status := OKC_API.G_RET_STS_ERROR;
113: End If;
114: end if;

Line 755: p_token3_value => 'OKL_K_HEADERS_V');

751: p_token1_value => 'crs_id',
752: p_token2 => g_child_table_token,
753: p_token2_value => G_VIEW,
754: p_token3 => g_parent_table_token,
755: p_token3_value => 'OKL_K_HEADERS_V');
756: -- notify caller of an error
757: x_return_status := OKC_API.G_RET_STS_ERROR;
758: End If;
759: end if;

Line 840: l_desc_flex_name VARCHAR2(30) := 'OKL_K_HEADERS_DF';

836: l_segment_values_rec Okl_DFlex_Util_Pvt.DFF_Rec_type;
837: l_msg_count NUMBER;
838: l_msg_data VARCHAR2(2000);
839: l_appl_short_name VARCHAR2(30) := 'OKL';
840: l_desc_flex_name VARCHAR2(30) := 'OKL_K_HEADERS_DF';
841: l_segment_partial_name VARCHAR2(30) := 'ATTRIBUTE';
842: Begin
843: -- initialize return status
844: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 983: -- Validate_Attributes for: OKL_K_HEADERS_V --

979: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
980: end validate_OBJECT_VERSION_NUMBER;
981:
982: ---------------------------------------------
983: -- Validate_Attributes for: OKL_K_HEADERS_V --
984: ---------------------------------------------
985: FUNCTION Validate_Attributes (
986: p_khrv_rec IN khrv_rec_type
987: ) RETURN VARCHAR2 IS

Line 1221: -- FUNCTION get_rec for: OKL_K_HEADERS

1217: END api_copy;
1218:
1219:
1220: ---------------------------------------------------------------------------
1221: -- FUNCTION get_rec for: OKL_K_HEADERS
1222: ---------------------------------------------------------------------------
1223: FUNCTION get_rec (
1224: p_khr_rec IN khr_rec_type,
1225: x_no_data_found OUT NOCOPY BOOLEAN

Line 1227: CURSOR okl_k_headers_pk_csr (p_id IN NUMBER) IS

1223: FUNCTION get_rec (
1224: p_khr_rec IN khr_rec_type,
1225: x_no_data_found OUT NOCOPY BOOLEAN
1226: ) RETURN khr_rec_type IS
1227: CURSOR okl_k_headers_pk_csr (p_id IN NUMBER) IS
1228: SELECT
1229: ID,
1230: ISG_ID,
1231: KHR_ID,

Line 1318: FROM OKL_K_HEADERS

1314: TRADEIN_AMOUNT,
1315: TRADEIN_DESCRIPTION,
1316: --Added by dpsingh for LE uptake
1317: LEGAL_ENTITY_ID
1318: FROM OKL_K_HEADERS
1319: WHERE OKL_K_HEADERS.id = p_id;
1320:
1321: l_khr_rec khr_rec_type;
1322: BEGIN

Line 1319: WHERE OKL_K_HEADERS.id = p_id;

1315: TRADEIN_DESCRIPTION,
1316: --Added by dpsingh for LE uptake
1317: LEGAL_ENTITY_ID
1318: FROM OKL_K_HEADERS
1319: WHERE OKL_K_HEADERS.id = p_id;
1320:
1321: l_khr_rec khr_rec_type;
1322: BEGIN
1323:

Line 1326: OPEN okl_k_headers_pk_csr (p_khr_rec.id);

1322: BEGIN
1323:
1324: x_no_data_found := TRUE;
1325: -- Get current database values
1326: OPEN okl_k_headers_pk_csr (p_khr_rec.id);
1327: FETCH okl_k_headers_pk_csr INTO
1328: l_khr_rec.ID,
1329: l_khr_rec.ISG_ID,
1330: l_khr_rec.KHR_ID,

Line 1327: FETCH okl_k_headers_pk_csr INTO

1323:
1324: x_no_data_found := TRUE;
1325: -- Get current database values
1326: OPEN okl_k_headers_pk_csr (p_khr_rec.id);
1327: FETCH okl_k_headers_pk_csr INTO
1328: l_khr_rec.ID,
1329: l_khr_rec.ISG_ID,
1330: l_khr_rec.KHR_ID,
1331: l_khr_rec.PDT_ID,

Line 1417: x_no_data_found := okl_k_headers_pk_csr%NOTFOUND;

1413: l_khr_rec.TRADEIN_AMOUNT,
1414: l_khr_rec.TRADEIN_DESCRIPTION,
1415: --Added by dpsingh for LE uptake
1416: l_khr_rec.LEGAL_ENTITY_ID ;
1417: x_no_data_found := okl_k_headers_pk_csr%NOTFOUND;
1418: CLOSE okl_k_headers_pk_csr;
1419: RETURN(l_khr_rec);
1420: END get_rec;
1421:

Line 1418: CLOSE okl_k_headers_pk_csr;

1414: l_khr_rec.TRADEIN_DESCRIPTION,
1415: --Added by dpsingh for LE uptake
1416: l_khr_rec.LEGAL_ENTITY_ID ;
1417: x_no_data_found := okl_k_headers_pk_csr%NOTFOUND;
1418: CLOSE okl_k_headers_pk_csr;
1419: RETURN(l_khr_rec);
1420: END get_rec;
1421:
1422: FUNCTION get_rec (

Line 1432: -- FUNCTION get_rec for: OKL_K_HEADERS_H

1428: END get_rec;
1429:
1430:
1431: ---------------------------------------------------------------------------
1432: -- FUNCTION get_rec for: OKL_K_HEADERS_H
1433: ---------------------------------------------------------------------------
1434: FUNCTION get_rec (
1435: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,
1436: x_no_data_found OUT NOCOPY BOOLEAN

Line 1435: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,

1431: ---------------------------------------------------------------------------
1432: -- FUNCTION get_rec for: OKL_K_HEADERS_H
1433: ---------------------------------------------------------------------------
1434: FUNCTION get_rec (
1435: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,
1436: x_no_data_found OUT NOCOPY BOOLEAN
1437: ) RETURN okl_k_headers_h_rec_type IS
1438: CURSOR okl_k_headers_h_pk_csr (p_id IN NUMBER) IS
1439: SELECT

Line 1437: ) RETURN okl_k_headers_h_rec_type IS

1433: ---------------------------------------------------------------------------
1434: FUNCTION get_rec (
1435: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,
1436: x_no_data_found OUT NOCOPY BOOLEAN
1437: ) RETURN okl_k_headers_h_rec_type IS
1438: CURSOR okl_k_headers_h_pk_csr (p_id IN NUMBER) IS
1439: SELECT
1440: ID,
1441: MAJOR_VERSION,

Line 1438: CURSOR okl_k_headers_h_pk_csr (p_id IN NUMBER) IS

1434: FUNCTION get_rec (
1435: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,
1436: x_no_data_found OUT NOCOPY BOOLEAN
1437: ) RETURN okl_k_headers_h_rec_type IS
1438: CURSOR okl_k_headers_h_pk_csr (p_id IN NUMBER) IS
1439: SELECT
1440: ID,
1441: MAJOR_VERSION,
1442: ISG_ID,

Line 1530: FROM OKL_K_HEADERS_H

1526: TRADEIN_AMOUNT,
1527: TRADEIN_DESCRIPTION,
1528: --Added by dpsingh for LE uptake
1529: LEGAL_ENTITY_ID
1530: FROM OKL_K_HEADERS_H
1531: WHERE OKL_K_HEADERS_H.id = p_id;
1532: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;
1533: BEGIN
1534:

Line 1531: WHERE OKL_K_HEADERS_H.id = p_id;

1527: TRADEIN_DESCRIPTION,
1528: --Added by dpsingh for LE uptake
1529: LEGAL_ENTITY_ID
1530: FROM OKL_K_HEADERS_H
1531: WHERE OKL_K_HEADERS_H.id = p_id;
1532: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;
1533: BEGIN
1534:
1535: x_no_data_found := TRUE;

Line 1532: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;

1528: --Added by dpsingh for LE uptake
1529: LEGAL_ENTITY_ID
1530: FROM OKL_K_HEADERS_H
1531: WHERE OKL_K_HEADERS_H.id = p_id;
1532: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;
1533: BEGIN
1534:
1535: x_no_data_found := TRUE;
1536: -- Get current database values

Line 1537: OPEN okl_k_headers_h_pk_csr (p_okl_k_headers_h_rec.id);

1533: BEGIN
1534:
1535: x_no_data_found := TRUE;
1536: -- Get current database values
1537: OPEN okl_k_headers_h_pk_csr (p_okl_k_headers_h_rec.id);
1538: FETCH okl_k_headers_h_pk_csr INTO
1539: l_okl_k_headers_h_rec.ID,
1540: l_okl_k_headers_h_rec.MAJOR_VERSION,
1541: l_okl_k_headers_h_rec.ISG_ID,

Line 1538: FETCH okl_k_headers_h_pk_csr INTO

1534:
1535: x_no_data_found := TRUE;
1536: -- Get current database values
1537: OPEN okl_k_headers_h_pk_csr (p_okl_k_headers_h_rec.id);
1538: FETCH okl_k_headers_h_pk_csr INTO
1539: l_okl_k_headers_h_rec.ID,
1540: l_okl_k_headers_h_rec.MAJOR_VERSION,
1541: l_okl_k_headers_h_rec.ISG_ID,
1542: l_okl_k_headers_h_rec.KHR_ID,

Line 1539: l_okl_k_headers_h_rec.ID,

1535: x_no_data_found := TRUE;
1536: -- Get current database values
1537: OPEN okl_k_headers_h_pk_csr (p_okl_k_headers_h_rec.id);
1538: FETCH okl_k_headers_h_pk_csr INTO
1539: l_okl_k_headers_h_rec.ID,
1540: l_okl_k_headers_h_rec.MAJOR_VERSION,
1541: l_okl_k_headers_h_rec.ISG_ID,
1542: l_okl_k_headers_h_rec.KHR_ID,
1543: l_okl_k_headers_h_rec.PDT_ID,

Line 1540: l_okl_k_headers_h_rec.MAJOR_VERSION,

1536: -- Get current database values
1537: OPEN okl_k_headers_h_pk_csr (p_okl_k_headers_h_rec.id);
1538: FETCH okl_k_headers_h_pk_csr INTO
1539: l_okl_k_headers_h_rec.ID,
1540: l_okl_k_headers_h_rec.MAJOR_VERSION,
1541: l_okl_k_headers_h_rec.ISG_ID,
1542: l_okl_k_headers_h_rec.KHR_ID,
1543: l_okl_k_headers_h_rec.PDT_ID,
1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,

Line 1541: l_okl_k_headers_h_rec.ISG_ID,

1537: OPEN okl_k_headers_h_pk_csr (p_okl_k_headers_h_rec.id);
1538: FETCH okl_k_headers_h_pk_csr INTO
1539: l_okl_k_headers_h_rec.ID,
1540: l_okl_k_headers_h_rec.MAJOR_VERSION,
1541: l_okl_k_headers_h_rec.ISG_ID,
1542: l_okl_k_headers_h_rec.KHR_ID,
1543: l_okl_k_headers_h_rec.PDT_ID,
1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,

Line 1542: l_okl_k_headers_h_rec.KHR_ID,

1538: FETCH okl_k_headers_h_pk_csr INTO
1539: l_okl_k_headers_h_rec.ID,
1540: l_okl_k_headers_h_rec.MAJOR_VERSION,
1541: l_okl_k_headers_h_rec.ISG_ID,
1542: l_okl_k_headers_h_rec.KHR_ID,
1543: l_okl_k_headers_h_rec.PDT_ID,
1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,

Line 1543: l_okl_k_headers_h_rec.PDT_ID,

1539: l_okl_k_headers_h_rec.ID,
1540: l_okl_k_headers_h_rec.MAJOR_VERSION,
1541: l_okl_k_headers_h_rec.ISG_ID,
1542: l_okl_k_headers_h_rec.KHR_ID,
1543: l_okl_k_headers_h_rec.PDT_ID,
1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
1547: l_okl_k_headers_h_rec.SALESTYPE_YN,

Line 1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,

1540: l_okl_k_headers_h_rec.MAJOR_VERSION,
1541: l_okl_k_headers_h_rec.ISG_ID,
1542: l_okl_k_headers_h_rec.KHR_ID,
1543: l_okl_k_headers_h_rec.PDT_ID,
1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
1547: l_okl_k_headers_h_rec.SALESTYPE_YN,
1548: l_okl_k_headers_h_rec.DATE_REFINANCED,

Line 1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,

1541: l_okl_k_headers_h_rec.ISG_ID,
1542: l_okl_k_headers_h_rec.KHR_ID,
1543: l_okl_k_headers_h_rec.PDT_ID,
1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
1547: l_okl_k_headers_h_rec.SALESTYPE_YN,
1548: l_okl_k_headers_h_rec.DATE_REFINANCED,
1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,

Line 1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,

1542: l_okl_k_headers_h_rec.KHR_ID,
1543: l_okl_k_headers_h_rec.PDT_ID,
1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
1547: l_okl_k_headers_h_rec.SALESTYPE_YN,
1548: l_okl_k_headers_h_rec.DATE_REFINANCED,
1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,

Line 1547: l_okl_k_headers_h_rec.SALESTYPE_YN,

1543: l_okl_k_headers_h_rec.PDT_ID,
1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
1547: l_okl_k_headers_h_rec.SALESTYPE_YN,
1548: l_okl_k_headers_h_rec.DATE_REFINANCED,
1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
1551: l_okl_k_headers_h_rec.TERM_DURATION,

Line 1548: l_okl_k_headers_h_rec.DATE_REFINANCED,

1544: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
1547: l_okl_k_headers_h_rec.SALESTYPE_YN,
1548: l_okl_k_headers_h_rec.DATE_REFINANCED,
1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
1551: l_okl_k_headers_h_rec.TERM_DURATION,
1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,

Line 1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,

1545: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
1547: l_okl_k_headers_h_rec.SALESTYPE_YN,
1548: l_okl_k_headers_h_rec.DATE_REFINANCED,
1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
1551: l_okl_k_headers_h_rec.TERM_DURATION,
1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,

Line 1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,

1546: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
1547: l_okl_k_headers_h_rec.SALESTYPE_YN,
1548: l_okl_k_headers_h_rec.DATE_REFINANCED,
1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
1551: l_okl_k_headers_h_rec.TERM_DURATION,
1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,

Line 1551: l_okl_k_headers_h_rec.TERM_DURATION,

1547: l_okl_k_headers_h_rec.SALESTYPE_YN,
1548: l_okl_k_headers_h_rec.DATE_REFINANCED,
1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
1551: l_okl_k_headers_h_rec.TERM_DURATION,
1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,

Line 1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,

1548: l_okl_k_headers_h_rec.DATE_REFINANCED,
1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
1551: l_okl_k_headers_h_rec.TERM_DURATION,
1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
1556: l_okl_k_headers_h_rec.ATTRIBUTE1,

Line 1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,

1549: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
1551: l_okl_k_headers_h_rec.TERM_DURATION,
1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
1556: l_okl_k_headers_h_rec.ATTRIBUTE1,
1557: l_okl_k_headers_h_rec.ATTRIBUTE2,

Line 1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,

1550: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
1551: l_okl_k_headers_h_rec.TERM_DURATION,
1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
1556: l_okl_k_headers_h_rec.ATTRIBUTE1,
1557: l_okl_k_headers_h_rec.ATTRIBUTE2,
1558: l_okl_k_headers_h_rec.ATTRIBUTE3,

Line 1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,

1551: l_okl_k_headers_h_rec.TERM_DURATION,
1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
1556: l_okl_k_headers_h_rec.ATTRIBUTE1,
1557: l_okl_k_headers_h_rec.ATTRIBUTE2,
1558: l_okl_k_headers_h_rec.ATTRIBUTE3,
1559: l_okl_k_headers_h_rec.ATTRIBUTE4,

Line 1556: l_okl_k_headers_h_rec.ATTRIBUTE1,

1552: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
1556: l_okl_k_headers_h_rec.ATTRIBUTE1,
1557: l_okl_k_headers_h_rec.ATTRIBUTE2,
1558: l_okl_k_headers_h_rec.ATTRIBUTE3,
1559: l_okl_k_headers_h_rec.ATTRIBUTE4,
1560: l_okl_k_headers_h_rec.ATTRIBUTE5,

Line 1557: l_okl_k_headers_h_rec.ATTRIBUTE2,

1553: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
1556: l_okl_k_headers_h_rec.ATTRIBUTE1,
1557: l_okl_k_headers_h_rec.ATTRIBUTE2,
1558: l_okl_k_headers_h_rec.ATTRIBUTE3,
1559: l_okl_k_headers_h_rec.ATTRIBUTE4,
1560: l_okl_k_headers_h_rec.ATTRIBUTE5,
1561: l_okl_k_headers_h_rec.ATTRIBUTE6,

Line 1558: l_okl_k_headers_h_rec.ATTRIBUTE3,

1554: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
1556: l_okl_k_headers_h_rec.ATTRIBUTE1,
1557: l_okl_k_headers_h_rec.ATTRIBUTE2,
1558: l_okl_k_headers_h_rec.ATTRIBUTE3,
1559: l_okl_k_headers_h_rec.ATTRIBUTE4,
1560: l_okl_k_headers_h_rec.ATTRIBUTE5,
1561: l_okl_k_headers_h_rec.ATTRIBUTE6,
1562: l_okl_k_headers_h_rec.ATTRIBUTE7,

Line 1559: l_okl_k_headers_h_rec.ATTRIBUTE4,

1555: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
1556: l_okl_k_headers_h_rec.ATTRIBUTE1,
1557: l_okl_k_headers_h_rec.ATTRIBUTE2,
1558: l_okl_k_headers_h_rec.ATTRIBUTE3,
1559: l_okl_k_headers_h_rec.ATTRIBUTE4,
1560: l_okl_k_headers_h_rec.ATTRIBUTE5,
1561: l_okl_k_headers_h_rec.ATTRIBUTE6,
1562: l_okl_k_headers_h_rec.ATTRIBUTE7,
1563: l_okl_k_headers_h_rec.ATTRIBUTE8,

Line 1560: l_okl_k_headers_h_rec.ATTRIBUTE5,

1556: l_okl_k_headers_h_rec.ATTRIBUTE1,
1557: l_okl_k_headers_h_rec.ATTRIBUTE2,
1558: l_okl_k_headers_h_rec.ATTRIBUTE3,
1559: l_okl_k_headers_h_rec.ATTRIBUTE4,
1560: l_okl_k_headers_h_rec.ATTRIBUTE5,
1561: l_okl_k_headers_h_rec.ATTRIBUTE6,
1562: l_okl_k_headers_h_rec.ATTRIBUTE7,
1563: l_okl_k_headers_h_rec.ATTRIBUTE8,
1564: l_okl_k_headers_h_rec.ATTRIBUTE9,

Line 1561: l_okl_k_headers_h_rec.ATTRIBUTE6,

1557: l_okl_k_headers_h_rec.ATTRIBUTE2,
1558: l_okl_k_headers_h_rec.ATTRIBUTE3,
1559: l_okl_k_headers_h_rec.ATTRIBUTE4,
1560: l_okl_k_headers_h_rec.ATTRIBUTE5,
1561: l_okl_k_headers_h_rec.ATTRIBUTE6,
1562: l_okl_k_headers_h_rec.ATTRIBUTE7,
1563: l_okl_k_headers_h_rec.ATTRIBUTE8,
1564: l_okl_k_headers_h_rec.ATTRIBUTE9,
1565: l_okl_k_headers_h_rec.ATTRIBUTE10,

Line 1562: l_okl_k_headers_h_rec.ATTRIBUTE7,

1558: l_okl_k_headers_h_rec.ATTRIBUTE3,
1559: l_okl_k_headers_h_rec.ATTRIBUTE4,
1560: l_okl_k_headers_h_rec.ATTRIBUTE5,
1561: l_okl_k_headers_h_rec.ATTRIBUTE6,
1562: l_okl_k_headers_h_rec.ATTRIBUTE7,
1563: l_okl_k_headers_h_rec.ATTRIBUTE8,
1564: l_okl_k_headers_h_rec.ATTRIBUTE9,
1565: l_okl_k_headers_h_rec.ATTRIBUTE10,
1566: l_okl_k_headers_h_rec.ATTRIBUTE11,

Line 1563: l_okl_k_headers_h_rec.ATTRIBUTE8,

1559: l_okl_k_headers_h_rec.ATTRIBUTE4,
1560: l_okl_k_headers_h_rec.ATTRIBUTE5,
1561: l_okl_k_headers_h_rec.ATTRIBUTE6,
1562: l_okl_k_headers_h_rec.ATTRIBUTE7,
1563: l_okl_k_headers_h_rec.ATTRIBUTE8,
1564: l_okl_k_headers_h_rec.ATTRIBUTE9,
1565: l_okl_k_headers_h_rec.ATTRIBUTE10,
1566: l_okl_k_headers_h_rec.ATTRIBUTE11,
1567: l_okl_k_headers_h_rec.ATTRIBUTE12,

Line 1564: l_okl_k_headers_h_rec.ATTRIBUTE9,

1560: l_okl_k_headers_h_rec.ATTRIBUTE5,
1561: l_okl_k_headers_h_rec.ATTRIBUTE6,
1562: l_okl_k_headers_h_rec.ATTRIBUTE7,
1563: l_okl_k_headers_h_rec.ATTRIBUTE8,
1564: l_okl_k_headers_h_rec.ATTRIBUTE9,
1565: l_okl_k_headers_h_rec.ATTRIBUTE10,
1566: l_okl_k_headers_h_rec.ATTRIBUTE11,
1567: l_okl_k_headers_h_rec.ATTRIBUTE12,
1568: l_okl_k_headers_h_rec.ATTRIBUTE13,

Line 1565: l_okl_k_headers_h_rec.ATTRIBUTE10,

1561: l_okl_k_headers_h_rec.ATTRIBUTE6,
1562: l_okl_k_headers_h_rec.ATTRIBUTE7,
1563: l_okl_k_headers_h_rec.ATTRIBUTE8,
1564: l_okl_k_headers_h_rec.ATTRIBUTE9,
1565: l_okl_k_headers_h_rec.ATTRIBUTE10,
1566: l_okl_k_headers_h_rec.ATTRIBUTE11,
1567: l_okl_k_headers_h_rec.ATTRIBUTE12,
1568: l_okl_k_headers_h_rec.ATTRIBUTE13,
1569: l_okl_k_headers_h_rec.ATTRIBUTE14,

Line 1566: l_okl_k_headers_h_rec.ATTRIBUTE11,

1562: l_okl_k_headers_h_rec.ATTRIBUTE7,
1563: l_okl_k_headers_h_rec.ATTRIBUTE8,
1564: l_okl_k_headers_h_rec.ATTRIBUTE9,
1565: l_okl_k_headers_h_rec.ATTRIBUTE10,
1566: l_okl_k_headers_h_rec.ATTRIBUTE11,
1567: l_okl_k_headers_h_rec.ATTRIBUTE12,
1568: l_okl_k_headers_h_rec.ATTRIBUTE13,
1569: l_okl_k_headers_h_rec.ATTRIBUTE14,
1570: l_okl_k_headers_h_rec.ATTRIBUTE15,

Line 1567: l_okl_k_headers_h_rec.ATTRIBUTE12,

1563: l_okl_k_headers_h_rec.ATTRIBUTE8,
1564: l_okl_k_headers_h_rec.ATTRIBUTE9,
1565: l_okl_k_headers_h_rec.ATTRIBUTE10,
1566: l_okl_k_headers_h_rec.ATTRIBUTE11,
1567: l_okl_k_headers_h_rec.ATTRIBUTE12,
1568: l_okl_k_headers_h_rec.ATTRIBUTE13,
1569: l_okl_k_headers_h_rec.ATTRIBUTE14,
1570: l_okl_k_headers_h_rec.ATTRIBUTE15,
1571: l_okl_k_headers_h_rec.CREATED_BY,

Line 1568: l_okl_k_headers_h_rec.ATTRIBUTE13,

1564: l_okl_k_headers_h_rec.ATTRIBUTE9,
1565: l_okl_k_headers_h_rec.ATTRIBUTE10,
1566: l_okl_k_headers_h_rec.ATTRIBUTE11,
1567: l_okl_k_headers_h_rec.ATTRIBUTE12,
1568: l_okl_k_headers_h_rec.ATTRIBUTE13,
1569: l_okl_k_headers_h_rec.ATTRIBUTE14,
1570: l_okl_k_headers_h_rec.ATTRIBUTE15,
1571: l_okl_k_headers_h_rec.CREATED_BY,
1572: l_okl_k_headers_h_rec.CREATION_DATE,

Line 1569: l_okl_k_headers_h_rec.ATTRIBUTE14,

1565: l_okl_k_headers_h_rec.ATTRIBUTE10,
1566: l_okl_k_headers_h_rec.ATTRIBUTE11,
1567: l_okl_k_headers_h_rec.ATTRIBUTE12,
1568: l_okl_k_headers_h_rec.ATTRIBUTE13,
1569: l_okl_k_headers_h_rec.ATTRIBUTE14,
1570: l_okl_k_headers_h_rec.ATTRIBUTE15,
1571: l_okl_k_headers_h_rec.CREATED_BY,
1572: l_okl_k_headers_h_rec.CREATION_DATE,
1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,

Line 1570: l_okl_k_headers_h_rec.ATTRIBUTE15,

1566: l_okl_k_headers_h_rec.ATTRIBUTE11,
1567: l_okl_k_headers_h_rec.ATTRIBUTE12,
1568: l_okl_k_headers_h_rec.ATTRIBUTE13,
1569: l_okl_k_headers_h_rec.ATTRIBUTE14,
1570: l_okl_k_headers_h_rec.ATTRIBUTE15,
1571: l_okl_k_headers_h_rec.CREATED_BY,
1572: l_okl_k_headers_h_rec.CREATION_DATE,
1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,

Line 1571: l_okl_k_headers_h_rec.CREATED_BY,

1567: l_okl_k_headers_h_rec.ATTRIBUTE12,
1568: l_okl_k_headers_h_rec.ATTRIBUTE13,
1569: l_okl_k_headers_h_rec.ATTRIBUTE14,
1570: l_okl_k_headers_h_rec.ATTRIBUTE15,
1571: l_okl_k_headers_h_rec.CREATED_BY,
1572: l_okl_k_headers_h_rec.CREATION_DATE,
1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,

Line 1572: l_okl_k_headers_h_rec.CREATION_DATE,

1568: l_okl_k_headers_h_rec.ATTRIBUTE13,
1569: l_okl_k_headers_h_rec.ATTRIBUTE14,
1570: l_okl_k_headers_h_rec.ATTRIBUTE15,
1571: l_okl_k_headers_h_rec.CREATED_BY,
1572: l_okl_k_headers_h_rec.CREATION_DATE,
1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
1576: l_okl_k_headers_h_rec.AMD_CODE,

Line 1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,

1569: l_okl_k_headers_h_rec.ATTRIBUTE14,
1570: l_okl_k_headers_h_rec.ATTRIBUTE15,
1571: l_okl_k_headers_h_rec.CREATED_BY,
1572: l_okl_k_headers_h_rec.CREATION_DATE,
1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
1576: l_okl_k_headers_h_rec.AMD_CODE,
1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,

Line 1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,

1570: l_okl_k_headers_h_rec.ATTRIBUTE15,
1571: l_okl_k_headers_h_rec.CREATED_BY,
1572: l_okl_k_headers_h_rec.CREATION_DATE,
1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
1576: l_okl_k_headers_h_rec.AMD_CODE,
1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,

Line 1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,

1571: l_okl_k_headers_h_rec.CREATED_BY,
1572: l_okl_k_headers_h_rec.CREATION_DATE,
1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
1576: l_okl_k_headers_h_rec.AMD_CODE,
1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,

Line 1576: l_okl_k_headers_h_rec.AMD_CODE,

1572: l_okl_k_headers_h_rec.CREATION_DATE,
1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
1576: l_okl_k_headers_h_rec.AMD_CODE,
1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,

Line 1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,

1573: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
1576: l_okl_k_headers_h_rec.AMD_CODE,
1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,

Line 1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,

1574: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
1576: l_okl_k_headers_h_rec.AMD_CODE,
1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,

Line 1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,

1575: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
1576: l_okl_k_headers_h_rec.AMD_CODE,
1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,

Line 1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,

1576: l_okl_k_headers_h_rec.AMD_CODE,
1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,

Line 1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,

1577: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,

Line 1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,

1578: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,

Line 1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,

1579: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,

Line 1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,

1580: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,

Line 1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,

1581: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,

Line 1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,

1582: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
1590: l_okl_k_headers_h_rec.DEAL_TYPE,

Line 1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,

1583: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
1590: l_okl_k_headers_h_rec.DEAL_TYPE,
1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,

Line 1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,

1584: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
1590: l_okl_k_headers_h_rec.DEAL_TYPE,
1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,
1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,

Line 1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,

1585: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
1590: l_okl_k_headers_h_rec.DEAL_TYPE,
1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,
1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
1593: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,

Line 1590: l_okl_k_headers_h_rec.DEAL_TYPE,

1586: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
1590: l_okl_k_headers_h_rec.DEAL_TYPE,
1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,
1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
1593: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
1594: l_okl_k_headers_h_rec.ACCEPTED_DATE,

Line 1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,

1587: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
1590: l_okl_k_headers_h_rec.DEAL_TYPE,
1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,
1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
1593: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
1594: l_okl_k_headers_h_rec.ACCEPTED_DATE,
1595: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,

Line 1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,

1588: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
1590: l_okl_k_headers_h_rec.DEAL_TYPE,
1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,
1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
1593: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
1594: l_okl_k_headers_h_rec.ACCEPTED_DATE,
1595: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
1596: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,

Line 1593: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,

1589: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
1590: l_okl_k_headers_h_rec.DEAL_TYPE,
1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,
1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
1593: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
1594: l_okl_k_headers_h_rec.ACCEPTED_DATE,
1595: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
1596: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
1597: --Bug# 2697681 schema changes 11.5.9

Line 1594: l_okl_k_headers_h_rec.ACCEPTED_DATE,

1590: l_okl_k_headers_h_rec.DEAL_TYPE,
1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,
1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
1593: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
1594: l_okl_k_headers_h_rec.ACCEPTED_DATE,
1595: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
1596: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
1597: --Bug# 2697681 schema changes 11.5.9
1598: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,

Line 1595: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,

1591: l_okl_k_headers_h_rec.PRE_TAX_IRR,
1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
1593: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
1594: l_okl_k_headers_h_rec.ACCEPTED_DATE,
1595: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
1596: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
1597: --Bug# 2697681 schema changes 11.5.9
1598: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
1599: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,

Line 1596: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,

1592: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
1593: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
1594: l_okl_k_headers_h_rec.ACCEPTED_DATE,
1595: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
1596: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
1597: --Bug# 2697681 schema changes 11.5.9
1598: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
1599: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
1600: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,

Line 1598: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,

1594: l_okl_k_headers_h_rec.ACCEPTED_DATE,
1595: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
1596: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
1597: --Bug# 2697681 schema changes 11.5.9
1598: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
1599: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
1600: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
1601: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
1602: l_okl_k_headers_h_rec.RECOURSE_CODE,

Line 1599: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,

1595: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
1596: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
1597: --Bug# 2697681 schema changes 11.5.9
1598: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
1599: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
1600: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
1601: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
1602: l_okl_k_headers_h_rec.RECOURSE_CODE,
1603: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,

Line 1600: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,

1596: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
1597: --Bug# 2697681 schema changes 11.5.9
1598: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
1599: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
1600: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
1601: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
1602: l_okl_k_headers_h_rec.RECOURSE_CODE,
1603: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
1604: l_okl_k_headers_h_rec.ASSIGNABLE_YN,

Line 1601: l_okl_k_headers_h_rec.MULTI_GAAP_YN,

1597: --Bug# 2697681 schema changes 11.5.9
1598: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
1599: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
1600: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
1601: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
1602: l_okl_k_headers_h_rec.RECOURSE_CODE,
1603: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
1604: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
1605: l_okl_k_headers_h_rec.SECURITIZED_CODE,

Line 1602: l_okl_k_headers_h_rec.RECOURSE_CODE,

1598: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
1599: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
1600: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
1601: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
1602: l_okl_k_headers_h_rec.RECOURSE_CODE,
1603: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
1604: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
1605: l_okl_k_headers_h_rec.SECURITIZED_CODE,
1606: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,

Line 1603: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,

1599: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
1600: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
1601: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
1602: l_okl_k_headers_h_rec.RECOURSE_CODE,
1603: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
1604: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
1605: l_okl_k_headers_h_rec.SECURITIZED_CODE,
1606: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
1607: --Bug#3143522 : 11.5.10

Line 1604: l_okl_k_headers_h_rec.ASSIGNABLE_YN,

1600: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
1601: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
1602: l_okl_k_headers_h_rec.RECOURSE_CODE,
1603: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
1604: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
1605: l_okl_k_headers_h_rec.SECURITIZED_CODE,
1606: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
1607: --Bug#3143522 : 11.5.10
1608: --subsidy

Line 1605: l_okl_k_headers_h_rec.SECURITIZED_CODE,

1601: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
1602: l_okl_k_headers_h_rec.RECOURSE_CODE,
1603: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
1604: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
1605: l_okl_k_headers_h_rec.SECURITIZED_CODE,
1606: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
1607: --Bug#3143522 : 11.5.10
1608: --subsidy
1609: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,

Line 1606: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,

1602: l_okl_k_headers_h_rec.RECOURSE_CODE,
1603: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
1604: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
1605: l_okl_k_headers_h_rec.SECURITIZED_CODE,
1606: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
1607: --Bug#3143522 : 11.5.10
1608: --subsidy
1609: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
1610: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,

Line 1609: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,

1605: l_okl_k_headers_h_rec.SECURITIZED_CODE,
1606: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
1607: --Bug#3143522 : 11.5.10
1608: --subsidy
1609: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
1610: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
1611: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
1612: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1613: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,

Line 1610: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,

1606: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
1607: --Bug#3143522 : 11.5.10
1608: --subsidy
1609: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
1610: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
1611: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
1612: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1613: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
1614: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,

Line 1611: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,

1607: --Bug#3143522 : 11.5.10
1608: --subsidy
1609: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
1610: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
1611: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
1612: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1613: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
1614: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
1615: --Bug# 3973640 : 11.5.10+

Line 1612: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,

1608: --subsidy
1609: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
1610: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
1611: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
1612: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1613: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
1614: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
1615: --Bug# 3973640 : 11.5.10+
1616: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,

Line 1613: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,

1609: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
1610: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
1611: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
1612: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1613: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
1614: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
1615: --Bug# 3973640 : 11.5.10+
1616: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
1617: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,

Line 1614: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,

1610: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
1611: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
1612: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1613: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
1614: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
1615: --Bug# 3973640 : 11.5.10+
1616: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
1617: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
1618: l_okl_k_headers_h_rec.TOT_CL_LIMIT,

Line 1616: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,

1612: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
1613: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
1614: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
1615: --Bug# 3973640 : 11.5.10+
1616: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
1617: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
1618: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
1619: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
1620: l_okl_k_headers_h_rec.CRS_ID,

Line 1617: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,

1613: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
1614: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
1615: --Bug# 3973640 : 11.5.10+
1616: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
1617: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
1618: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
1619: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
1620: l_okl_k_headers_h_rec.CRS_ID,
1621: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,

Line 1618: l_okl_k_headers_h_rec.TOT_CL_LIMIT,

1614: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
1615: --Bug# 3973640 : 11.5.10+
1616: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
1617: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
1618: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
1619: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
1620: l_okl_k_headers_h_rec.CRS_ID,
1621: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
1622: --Bug# 4419339 OKLH Schema Sales Quote

Line 1619: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,

1615: --Bug# 3973640 : 11.5.10+
1616: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
1617: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
1618: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
1619: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
1620: l_okl_k_headers_h_rec.CRS_ID,
1621: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
1622: --Bug# 4419339 OKLH Schema Sales Quote
1623: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED ,

Line 1620: l_okl_k_headers_h_rec.CRS_ID,

1616: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
1617: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
1618: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
1619: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
1620: l_okl_k_headers_h_rec.CRS_ID,
1621: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
1622: --Bug# 4419339 OKLH Schema Sales Quote
1623: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED ,
1624: l_okl_k_headers_h_rec.DATE_TRADEIN,

Line 1621: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,

1617: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
1618: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
1619: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
1620: l_okl_k_headers_h_rec.CRS_ID,
1621: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
1622: --Bug# 4419339 OKLH Schema Sales Quote
1623: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED ,
1624: l_okl_k_headers_h_rec.DATE_TRADEIN,
1625: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,

Line 1623: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED ,

1619: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
1620: l_okl_k_headers_h_rec.CRS_ID,
1621: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
1622: --Bug# 4419339 OKLH Schema Sales Quote
1623: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED ,
1624: l_okl_k_headers_h_rec.DATE_TRADEIN,
1625: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
1626: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
1627: --Added by dpsingh for LE uptake

Line 1624: l_okl_k_headers_h_rec.DATE_TRADEIN,

1620: l_okl_k_headers_h_rec.CRS_ID,
1621: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
1622: --Bug# 4419339 OKLH Schema Sales Quote
1623: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED ,
1624: l_okl_k_headers_h_rec.DATE_TRADEIN,
1625: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
1626: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
1627: --Added by dpsingh for LE uptake
1628: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID

Line 1625: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,

1621: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
1622: --Bug# 4419339 OKLH Schema Sales Quote
1623: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED ,
1624: l_okl_k_headers_h_rec.DATE_TRADEIN,
1625: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
1626: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
1627: --Added by dpsingh for LE uptake
1628: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID
1629: ;

Line 1626: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,

1622: --Bug# 4419339 OKLH Schema Sales Quote
1623: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED ,
1624: l_okl_k_headers_h_rec.DATE_TRADEIN,
1625: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
1626: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
1627: --Added by dpsingh for LE uptake
1628: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID
1629: ;
1630: x_no_data_found := okl_k_headers_h_pk_csr%NOTFOUND;

Line 1628: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID

1624: l_okl_k_headers_h_rec.DATE_TRADEIN,
1625: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
1626: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
1627: --Added by dpsingh for LE uptake
1628: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID
1629: ;
1630: x_no_data_found := okl_k_headers_h_pk_csr%NOTFOUND;
1631: CLOSE okl_k_headers_h_pk_csr;
1632: RETURN(l_okl_k_headers_h_rec);

Line 1630: x_no_data_found := okl_k_headers_h_pk_csr%NOTFOUND;

1626: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
1627: --Added by dpsingh for LE uptake
1628: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID
1629: ;
1630: x_no_data_found := okl_k_headers_h_pk_csr%NOTFOUND;
1631: CLOSE okl_k_headers_h_pk_csr;
1632: RETURN(l_okl_k_headers_h_rec);
1633: END get_rec;
1634:

Line 1631: CLOSE okl_k_headers_h_pk_csr;

1627: --Added by dpsingh for LE uptake
1628: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID
1629: ;
1630: x_no_data_found := okl_k_headers_h_pk_csr%NOTFOUND;
1631: CLOSE okl_k_headers_h_pk_csr;
1632: RETURN(l_okl_k_headers_h_rec);
1633: END get_rec;
1634:
1635: FUNCTION get_rec (

Line 1632: RETURN(l_okl_k_headers_h_rec);

1628: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID
1629: ;
1630: x_no_data_found := okl_k_headers_h_pk_csr%NOTFOUND;
1631: CLOSE okl_k_headers_h_pk_csr;
1632: RETURN(l_okl_k_headers_h_rec);
1633: END get_rec;
1634:
1635: FUNCTION get_rec (
1636: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type

Line 1636: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type

1632: RETURN(l_okl_k_headers_h_rec);
1633: END get_rec;
1634:
1635: FUNCTION get_rec (
1636: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type
1637: ) RETURN okl_k_headers_h_rec_type IS
1638: l_row_notfound BOOLEAN := TRUE;
1639: BEGIN
1640: RETURN(get_rec(p_okl_k_headers_h_rec, l_row_notfound));

Line 1637: ) RETURN okl_k_headers_h_rec_type IS

1633: END get_rec;
1634:
1635: FUNCTION get_rec (
1636: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type
1637: ) RETURN okl_k_headers_h_rec_type IS
1638: l_row_notfound BOOLEAN := TRUE;
1639: BEGIN
1640: RETURN(get_rec(p_okl_k_headers_h_rec, l_row_notfound));
1641: END get_rec;

Line 1640: RETURN(get_rec(p_okl_k_headers_h_rec, l_row_notfound));

1636: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type
1637: ) RETURN okl_k_headers_h_rec_type IS
1638: l_row_notfound BOOLEAN := TRUE;
1639: BEGIN
1640: RETURN(get_rec(p_okl_k_headers_h_rec, l_row_notfound));
1641: END get_rec;
1642:
1643:
1644: ---------------------------------------------------------------------------

Line 1645: -- FUNCTION get_rec for: OKL_K_HEADERS_V

1641: END get_rec;
1642:
1643:
1644: ---------------------------------------------------------------------------
1645: -- FUNCTION get_rec for: OKL_K_HEADERS_V
1646: ---------------------------------------------------------------------------
1647: FUNCTION get_rec (
1648: p_khrv_rec IN khrv_rec_type,
1649: x_no_data_found OUT NOCOPY BOOLEAN

Line 1651: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS

1647: FUNCTION get_rec (
1648: p_khrv_rec IN khrv_rec_type,
1649: x_no_data_found OUT NOCOPY BOOLEAN
1650: ) RETURN khrv_rec_type IS
1651: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS
1652: SELECT
1653: ID,
1654: OBJECT_VERSION_NUMBER,
1655: ISG_ID,

Line 1742: FROM OKL_K_HEADERS_V

1738: TRADEIN_AMOUNT,
1739: TRADEIN_DESCRIPTION,
1740: --Added by dpsingh for LE uptake
1741: LEGAL_ENTITY_ID
1742: FROM OKL_K_HEADERS_V
1743: WHERE OKL_K_HEADERS_V.id = p_id;
1744:
1745: l_khrv_rec khrv_rec_type;
1746: BEGIN

Line 1743: WHERE OKL_K_HEADERS_V.id = p_id;

1739: TRADEIN_DESCRIPTION,
1740: --Added by dpsingh for LE uptake
1741: LEGAL_ENTITY_ID
1742: FROM OKL_K_HEADERS_V
1743: WHERE OKL_K_HEADERS_V.id = p_id;
1744:
1745: l_khrv_rec khrv_rec_type;
1746: BEGIN
1747:

Line 1750: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);

1746: BEGIN
1747:
1748: x_no_data_found := TRUE;
1749: -- Get current database values
1750: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);
1751: FETCH okl_k_headers_v_pk_csr INTO
1752: l_khrv_rec.ID,
1753: l_khrv_rec.OBJECT_VERSION_NUMBER,
1754: l_khrv_rec.ISG_ID,

Line 1751: FETCH okl_k_headers_v_pk_csr INTO

1747:
1748: x_no_data_found := TRUE;
1749: -- Get current database values
1750: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);
1751: FETCH okl_k_headers_v_pk_csr INTO
1752: l_khrv_rec.ID,
1753: l_khrv_rec.OBJECT_VERSION_NUMBER,
1754: l_khrv_rec.ISG_ID,
1755: l_khrv_rec.KHR_ID,

Line 1841: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;

1837: l_khrv_rec.TRADEIN_AMOUNT,
1838: l_khrv_rec.TRADEIN_DESCRIPTION,
1839: --Added by dpsingh for LE uptake
1840: l_khrv_rec.LEGAL_ENTITY_ID ;
1841: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;
1842: CLOSE okl_k_headers_v_pk_csr;
1843: RETURN(l_khrv_rec);
1844: END get_rec;
1845:

Line 1842: CLOSE okl_k_headers_v_pk_csr;

1838: l_khrv_rec.TRADEIN_DESCRIPTION,
1839: --Added by dpsingh for LE uptake
1840: l_khrv_rec.LEGAL_ENTITY_ID ;
1841: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;
1842: CLOSE okl_k_headers_v_pk_csr;
1843: RETURN(l_khrv_rec);
1844: END get_rec;
1845:
1846: FUNCTION get_rec (

Line 1856: -- FUNCTION null_out_defaults for: OKL_K_HEADERS_V --

1852: END get_rec;
1853:
1854:
1855: -----------------------------------------------------
1856: -- FUNCTION null_out_defaults for: OKL_K_HEADERS_V --
1857: -----------------------------------------------------
1858: FUNCTION null_out_defaults (
1859: p_khrv_rec IN khrv_rec_type
1860: ) RETURN khrv_rec_type IS

Line 2198: -- Validate_Record for: OKL_K_HEADERS_V --

2194: ---------------------------------------------------------------------------
2195:
2196:
2197: -----------------------------------------
2198: -- Validate_Record for: OKL_K_HEADERS_V --
2199: -----------------------------------------
2200: FUNCTION Validate_Record (
2201: p_khrv_rec IN khrv_rec_type
2202: ) RETURN VARCHAR2 IS

Line 2525: p_to IN OUT NOCOPY okl_k_headers_h_rec_type

2521: END migrate;
2522:
2523: PROCEDURE migrate (
2524: p_from IN khr_rec_type,
2525: p_to IN OUT NOCOPY okl_k_headers_h_rec_type
2526: ) IS
2527: BEGIN
2528:
2529: p_to.ID := p_from.ID;

Line 2684: -- validate_row for: OKL_K_HEADERS_V --

2680: -- PROCEDURE validate_row
2681: ---------------------------------------------------------------------------
2682:
2683: --------------------------------------
2684: -- validate_row for: OKL_K_HEADERS_V --
2685: --------------------------------------
2686:
2687: PROCEDURE validate_row(
2688:

Line 2772: -- PL/SQL TBL validate_row for: OKL_K_HEADERS_V --

2768: );
2769:
2770: END validate_row;
2771: ------------------------------------------
2772: -- PL/SQL TBL validate_row for: OKL_K_HEADERS_V --
2773: ------------------------------------------
2774:
2775: PROCEDURE validate_row(
2776:

Line 2847: -- insert_row for: OKL_K_HEADERS_H --

2843: ---------------------------------------------------------------------------
2844:
2845:
2846: ------------------------------------
2847: -- insert_row for: OKL_K_HEADERS_H --
2848: ------------------------------------
2849:
2850: PROCEDURE insert_row(
2851:

Line 2857: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,

2853: p_init_msg_list IN VARCHAR2,
2854: x_return_status OUT NOCOPY VARCHAR2,
2855: x_msg_count OUT NOCOPY NUMBER,
2856: x_msg_data OUT NOCOPY VARCHAR2,
2857: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,
2858: x_okl_k_headers_h_rec OUT NOCOPY okl_k_headers_h_rec_type) IS
2859:
2860: l_api_version CONSTANT NUMBER := 1;
2861: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';

Line 2858: x_okl_k_headers_h_rec OUT NOCOPY okl_k_headers_h_rec_type) IS

2854: x_return_status OUT NOCOPY VARCHAR2,
2855: x_msg_count OUT NOCOPY NUMBER,
2856: x_msg_data OUT NOCOPY VARCHAR2,
2857: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,
2858: x_okl_k_headers_h_rec OUT NOCOPY okl_k_headers_h_rec_type) IS
2859:
2860: l_api_version CONSTANT NUMBER := 1;
2861: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
2862: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2863: l_okl_k_headers_h_rec okl_k_headers_h_rec_type := p_okl_k_headers_h_rec;

2859:
2860: l_api_version CONSTANT NUMBER := 1;
2861: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
2862: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2863: l_okl_k_headers_h_rec okl_k_headers_h_rec_type := p_okl_k_headers_h_rec;
2864: l_def_okl_k_headers_h_rec okl_k_headers_h_rec_type;
2865: ----------------------------------------
2866: -- Set_Attributes for: OKL_K_HEADERS_H --
2867: ----------------------------------------

Line 2864: l_def_okl_k_headers_h_rec okl_k_headers_h_rec_type;

2860: l_api_version CONSTANT NUMBER := 1;
2861: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
2862: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2863: l_okl_k_headers_h_rec okl_k_headers_h_rec_type := p_okl_k_headers_h_rec;
2864: l_def_okl_k_headers_h_rec okl_k_headers_h_rec_type;
2865: ----------------------------------------
2866: -- Set_Attributes for: OKL_K_HEADERS_H --
2867: ----------------------------------------
2868: FUNCTION Set_Attributes (

Line 2866: -- Set_Attributes for: OKL_K_HEADERS_H --

2862: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2863: l_okl_k_headers_h_rec okl_k_headers_h_rec_type := p_okl_k_headers_h_rec;
2864: l_def_okl_k_headers_h_rec okl_k_headers_h_rec_type;
2865: ----------------------------------------
2866: -- Set_Attributes for: OKL_K_HEADERS_H --
2867: ----------------------------------------
2868: FUNCTION Set_Attributes (
2869: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,
2870: x_okl_k_headers_h_rec OUT NOCOPY okl_k_headers_h_rec_type

Line 2869: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,

2865: ----------------------------------------
2866: -- Set_Attributes for: OKL_K_HEADERS_H --
2867: ----------------------------------------
2868: FUNCTION Set_Attributes (
2869: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,
2870: x_okl_k_headers_h_rec OUT NOCOPY okl_k_headers_h_rec_type
2871: ) RETURN VARCHAR2 IS
2872: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2873: BEGIN

Line 2870: x_okl_k_headers_h_rec OUT NOCOPY okl_k_headers_h_rec_type

2866: -- Set_Attributes for: OKL_K_HEADERS_H --
2867: ----------------------------------------
2868: FUNCTION Set_Attributes (
2869: p_okl_k_headers_h_rec IN okl_k_headers_h_rec_type,
2870: x_okl_k_headers_h_rec OUT NOCOPY okl_k_headers_h_rec_type
2871: ) RETURN VARCHAR2 IS
2872: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2873: BEGIN
2874: x_okl_k_headers_h_rec := p_okl_k_headers_h_rec;

Line 2874: x_okl_k_headers_h_rec := p_okl_k_headers_h_rec;

2870: x_okl_k_headers_h_rec OUT NOCOPY okl_k_headers_h_rec_type
2871: ) RETURN VARCHAR2 IS
2872: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2873: BEGIN
2874: x_okl_k_headers_h_rec := p_okl_k_headers_h_rec;
2875: RETURN(l_return_status);
2876: END Set_Attributes;
2877: BEGIN
2878:

Line 2892: p_okl_k_headers_h_rec, -- IN

2888: END IF;
2889:
2890: --- Setting item attributes
2891: l_return_status := Set_Attributes(
2892: p_okl_k_headers_h_rec, -- IN
2893: l_okl_k_headers_h_rec); -- OUT
2894: --- If any errors happen abort API
2895:
2896: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2893: l_okl_k_headers_h_rec); -- OUT

2889:
2890: --- Setting item attributes
2891: l_return_status := Set_Attributes(
2892: p_okl_k_headers_h_rec, -- IN
2893: l_okl_k_headers_h_rec); -- OUT
2894: --- If any errors happen abort API
2895:
2896: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2897: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2902: INSERT INTO OKL_K_HEADERS_H(

2898: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2899: RAISE OKC_API.G_EXCEPTION_ERROR;
2900: END IF;
2901:
2902: INSERT INTO OKL_K_HEADERS_H(
2903: ID,
2904: MAJOR_VERSION,
2905: ISG_ID,
2906: KHR_ID,

Line 2995: l_okl_k_headers_h_rec.ID,

2991: --Added by dpsingh for LE uptake
2992: LEGAL_ENTITY_ID
2993: )
2994: VALUES (
2995: l_okl_k_headers_h_rec.ID,
2996: l_okl_k_headers_h_rec.MAJOR_VERSION,
2997: l_okl_k_headers_h_rec.ISG_ID,
2998: l_okl_k_headers_h_rec.KHR_ID,
2999: l_okl_k_headers_h_rec.PDT_ID,

Line 2996: l_okl_k_headers_h_rec.MAJOR_VERSION,

2992: LEGAL_ENTITY_ID
2993: )
2994: VALUES (
2995: l_okl_k_headers_h_rec.ID,
2996: l_okl_k_headers_h_rec.MAJOR_VERSION,
2997: l_okl_k_headers_h_rec.ISG_ID,
2998: l_okl_k_headers_h_rec.KHR_ID,
2999: l_okl_k_headers_h_rec.PDT_ID,
3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,

Line 2997: l_okl_k_headers_h_rec.ISG_ID,

2993: )
2994: VALUES (
2995: l_okl_k_headers_h_rec.ID,
2996: l_okl_k_headers_h_rec.MAJOR_VERSION,
2997: l_okl_k_headers_h_rec.ISG_ID,
2998: l_okl_k_headers_h_rec.KHR_ID,
2999: l_okl_k_headers_h_rec.PDT_ID,
3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,

Line 2998: l_okl_k_headers_h_rec.KHR_ID,

2994: VALUES (
2995: l_okl_k_headers_h_rec.ID,
2996: l_okl_k_headers_h_rec.MAJOR_VERSION,
2997: l_okl_k_headers_h_rec.ISG_ID,
2998: l_okl_k_headers_h_rec.KHR_ID,
2999: l_okl_k_headers_h_rec.PDT_ID,
3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,

Line 2999: l_okl_k_headers_h_rec.PDT_ID,

2995: l_okl_k_headers_h_rec.ID,
2996: l_okl_k_headers_h_rec.MAJOR_VERSION,
2997: l_okl_k_headers_h_rec.ISG_ID,
2998: l_okl_k_headers_h_rec.KHR_ID,
2999: l_okl_k_headers_h_rec.PDT_ID,
3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
3003: l_okl_k_headers_h_rec.SALESTYPE_YN,

Line 3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,

2996: l_okl_k_headers_h_rec.MAJOR_VERSION,
2997: l_okl_k_headers_h_rec.ISG_ID,
2998: l_okl_k_headers_h_rec.KHR_ID,
2999: l_okl_k_headers_h_rec.PDT_ID,
3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
3003: l_okl_k_headers_h_rec.SALESTYPE_YN,
3004: l_okl_k_headers_h_rec.DATE_REFINANCED,

Line 3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,

2997: l_okl_k_headers_h_rec.ISG_ID,
2998: l_okl_k_headers_h_rec.KHR_ID,
2999: l_okl_k_headers_h_rec.PDT_ID,
3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
3003: l_okl_k_headers_h_rec.SALESTYPE_YN,
3004: l_okl_k_headers_h_rec.DATE_REFINANCED,
3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,

Line 3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,

2998: l_okl_k_headers_h_rec.KHR_ID,
2999: l_okl_k_headers_h_rec.PDT_ID,
3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
3003: l_okl_k_headers_h_rec.SALESTYPE_YN,
3004: l_okl_k_headers_h_rec.DATE_REFINANCED,
3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,

Line 3003: l_okl_k_headers_h_rec.SALESTYPE_YN,

2999: l_okl_k_headers_h_rec.PDT_ID,
3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
3003: l_okl_k_headers_h_rec.SALESTYPE_YN,
3004: l_okl_k_headers_h_rec.DATE_REFINANCED,
3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
3007: l_okl_k_headers_h_rec.TERM_DURATION,

Line 3004: l_okl_k_headers_h_rec.DATE_REFINANCED,

3000: l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
3003: l_okl_k_headers_h_rec.SALESTYPE_YN,
3004: l_okl_k_headers_h_rec.DATE_REFINANCED,
3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
3007: l_okl_k_headers_h_rec.TERM_DURATION,
3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,

Line 3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,

3001: l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
3003: l_okl_k_headers_h_rec.SALESTYPE_YN,
3004: l_okl_k_headers_h_rec.DATE_REFINANCED,
3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
3007: l_okl_k_headers_h_rec.TERM_DURATION,
3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,

Line 3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,

3002: l_okl_k_headers_h_rec.SYNDICATABLE_YN,
3003: l_okl_k_headers_h_rec.SALESTYPE_YN,
3004: l_okl_k_headers_h_rec.DATE_REFINANCED,
3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
3007: l_okl_k_headers_h_rec.TERM_DURATION,
3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,

Line 3007: l_okl_k_headers_h_rec.TERM_DURATION,

3003: l_okl_k_headers_h_rec.SALESTYPE_YN,
3004: l_okl_k_headers_h_rec.DATE_REFINANCED,
3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
3007: l_okl_k_headers_h_rec.TERM_DURATION,
3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,

Line 3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,

3004: l_okl_k_headers_h_rec.DATE_REFINANCED,
3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
3007: l_okl_k_headers_h_rec.TERM_DURATION,
3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
3012: l_okl_k_headers_h_rec.ATTRIBUTE1,

Line 3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,

3005: l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
3007: l_okl_k_headers_h_rec.TERM_DURATION,
3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
3012: l_okl_k_headers_h_rec.ATTRIBUTE1,
3013: l_okl_k_headers_h_rec.ATTRIBUTE2,

Line 3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,

3006: l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
3007: l_okl_k_headers_h_rec.TERM_DURATION,
3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
3012: l_okl_k_headers_h_rec.ATTRIBUTE1,
3013: l_okl_k_headers_h_rec.ATTRIBUTE2,
3014: l_okl_k_headers_h_rec.ATTRIBUTE3,

Line 3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,

3007: l_okl_k_headers_h_rec.TERM_DURATION,
3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
3012: l_okl_k_headers_h_rec.ATTRIBUTE1,
3013: l_okl_k_headers_h_rec.ATTRIBUTE2,
3014: l_okl_k_headers_h_rec.ATTRIBUTE3,
3015: l_okl_k_headers_h_rec.ATTRIBUTE4,

Line 3012: l_okl_k_headers_h_rec.ATTRIBUTE1,

3008: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
3012: l_okl_k_headers_h_rec.ATTRIBUTE1,
3013: l_okl_k_headers_h_rec.ATTRIBUTE2,
3014: l_okl_k_headers_h_rec.ATTRIBUTE3,
3015: l_okl_k_headers_h_rec.ATTRIBUTE4,
3016: l_okl_k_headers_h_rec.ATTRIBUTE5,

Line 3013: l_okl_k_headers_h_rec.ATTRIBUTE2,

3009: l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
3012: l_okl_k_headers_h_rec.ATTRIBUTE1,
3013: l_okl_k_headers_h_rec.ATTRIBUTE2,
3014: l_okl_k_headers_h_rec.ATTRIBUTE3,
3015: l_okl_k_headers_h_rec.ATTRIBUTE4,
3016: l_okl_k_headers_h_rec.ATTRIBUTE5,
3017: l_okl_k_headers_h_rec.ATTRIBUTE6,

Line 3014: l_okl_k_headers_h_rec.ATTRIBUTE3,

3010: l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
3012: l_okl_k_headers_h_rec.ATTRIBUTE1,
3013: l_okl_k_headers_h_rec.ATTRIBUTE2,
3014: l_okl_k_headers_h_rec.ATTRIBUTE3,
3015: l_okl_k_headers_h_rec.ATTRIBUTE4,
3016: l_okl_k_headers_h_rec.ATTRIBUTE5,
3017: l_okl_k_headers_h_rec.ATTRIBUTE6,
3018: l_okl_k_headers_h_rec.ATTRIBUTE7,

Line 3015: l_okl_k_headers_h_rec.ATTRIBUTE4,

3011: l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
3012: l_okl_k_headers_h_rec.ATTRIBUTE1,
3013: l_okl_k_headers_h_rec.ATTRIBUTE2,
3014: l_okl_k_headers_h_rec.ATTRIBUTE3,
3015: l_okl_k_headers_h_rec.ATTRIBUTE4,
3016: l_okl_k_headers_h_rec.ATTRIBUTE5,
3017: l_okl_k_headers_h_rec.ATTRIBUTE6,
3018: l_okl_k_headers_h_rec.ATTRIBUTE7,
3019: l_okl_k_headers_h_rec.ATTRIBUTE8,

Line 3016: l_okl_k_headers_h_rec.ATTRIBUTE5,

3012: l_okl_k_headers_h_rec.ATTRIBUTE1,
3013: l_okl_k_headers_h_rec.ATTRIBUTE2,
3014: l_okl_k_headers_h_rec.ATTRIBUTE3,
3015: l_okl_k_headers_h_rec.ATTRIBUTE4,
3016: l_okl_k_headers_h_rec.ATTRIBUTE5,
3017: l_okl_k_headers_h_rec.ATTRIBUTE6,
3018: l_okl_k_headers_h_rec.ATTRIBUTE7,
3019: l_okl_k_headers_h_rec.ATTRIBUTE8,
3020: l_okl_k_headers_h_rec.ATTRIBUTE9,

Line 3017: l_okl_k_headers_h_rec.ATTRIBUTE6,

3013: l_okl_k_headers_h_rec.ATTRIBUTE2,
3014: l_okl_k_headers_h_rec.ATTRIBUTE3,
3015: l_okl_k_headers_h_rec.ATTRIBUTE4,
3016: l_okl_k_headers_h_rec.ATTRIBUTE5,
3017: l_okl_k_headers_h_rec.ATTRIBUTE6,
3018: l_okl_k_headers_h_rec.ATTRIBUTE7,
3019: l_okl_k_headers_h_rec.ATTRIBUTE8,
3020: l_okl_k_headers_h_rec.ATTRIBUTE9,
3021: l_okl_k_headers_h_rec.ATTRIBUTE10,

Line 3018: l_okl_k_headers_h_rec.ATTRIBUTE7,

3014: l_okl_k_headers_h_rec.ATTRIBUTE3,
3015: l_okl_k_headers_h_rec.ATTRIBUTE4,
3016: l_okl_k_headers_h_rec.ATTRIBUTE5,
3017: l_okl_k_headers_h_rec.ATTRIBUTE6,
3018: l_okl_k_headers_h_rec.ATTRIBUTE7,
3019: l_okl_k_headers_h_rec.ATTRIBUTE8,
3020: l_okl_k_headers_h_rec.ATTRIBUTE9,
3021: l_okl_k_headers_h_rec.ATTRIBUTE10,
3022: l_okl_k_headers_h_rec.ATTRIBUTE11,

Line 3019: l_okl_k_headers_h_rec.ATTRIBUTE8,

3015: l_okl_k_headers_h_rec.ATTRIBUTE4,
3016: l_okl_k_headers_h_rec.ATTRIBUTE5,
3017: l_okl_k_headers_h_rec.ATTRIBUTE6,
3018: l_okl_k_headers_h_rec.ATTRIBUTE7,
3019: l_okl_k_headers_h_rec.ATTRIBUTE8,
3020: l_okl_k_headers_h_rec.ATTRIBUTE9,
3021: l_okl_k_headers_h_rec.ATTRIBUTE10,
3022: l_okl_k_headers_h_rec.ATTRIBUTE11,
3023: l_okl_k_headers_h_rec.ATTRIBUTE12,

Line 3020: l_okl_k_headers_h_rec.ATTRIBUTE9,

3016: l_okl_k_headers_h_rec.ATTRIBUTE5,
3017: l_okl_k_headers_h_rec.ATTRIBUTE6,
3018: l_okl_k_headers_h_rec.ATTRIBUTE7,
3019: l_okl_k_headers_h_rec.ATTRIBUTE8,
3020: l_okl_k_headers_h_rec.ATTRIBUTE9,
3021: l_okl_k_headers_h_rec.ATTRIBUTE10,
3022: l_okl_k_headers_h_rec.ATTRIBUTE11,
3023: l_okl_k_headers_h_rec.ATTRIBUTE12,
3024: l_okl_k_headers_h_rec.ATTRIBUTE13,

Line 3021: l_okl_k_headers_h_rec.ATTRIBUTE10,

3017: l_okl_k_headers_h_rec.ATTRIBUTE6,
3018: l_okl_k_headers_h_rec.ATTRIBUTE7,
3019: l_okl_k_headers_h_rec.ATTRIBUTE8,
3020: l_okl_k_headers_h_rec.ATTRIBUTE9,
3021: l_okl_k_headers_h_rec.ATTRIBUTE10,
3022: l_okl_k_headers_h_rec.ATTRIBUTE11,
3023: l_okl_k_headers_h_rec.ATTRIBUTE12,
3024: l_okl_k_headers_h_rec.ATTRIBUTE13,
3025: l_okl_k_headers_h_rec.ATTRIBUTE14,

Line 3022: l_okl_k_headers_h_rec.ATTRIBUTE11,

3018: l_okl_k_headers_h_rec.ATTRIBUTE7,
3019: l_okl_k_headers_h_rec.ATTRIBUTE8,
3020: l_okl_k_headers_h_rec.ATTRIBUTE9,
3021: l_okl_k_headers_h_rec.ATTRIBUTE10,
3022: l_okl_k_headers_h_rec.ATTRIBUTE11,
3023: l_okl_k_headers_h_rec.ATTRIBUTE12,
3024: l_okl_k_headers_h_rec.ATTRIBUTE13,
3025: l_okl_k_headers_h_rec.ATTRIBUTE14,
3026: l_okl_k_headers_h_rec.ATTRIBUTE15,

Line 3023: l_okl_k_headers_h_rec.ATTRIBUTE12,

3019: l_okl_k_headers_h_rec.ATTRIBUTE8,
3020: l_okl_k_headers_h_rec.ATTRIBUTE9,
3021: l_okl_k_headers_h_rec.ATTRIBUTE10,
3022: l_okl_k_headers_h_rec.ATTRIBUTE11,
3023: l_okl_k_headers_h_rec.ATTRIBUTE12,
3024: l_okl_k_headers_h_rec.ATTRIBUTE13,
3025: l_okl_k_headers_h_rec.ATTRIBUTE14,
3026: l_okl_k_headers_h_rec.ATTRIBUTE15,
3027: l_okl_k_headers_h_rec.CREATED_BY,

Line 3024: l_okl_k_headers_h_rec.ATTRIBUTE13,

3020: l_okl_k_headers_h_rec.ATTRIBUTE9,
3021: l_okl_k_headers_h_rec.ATTRIBUTE10,
3022: l_okl_k_headers_h_rec.ATTRIBUTE11,
3023: l_okl_k_headers_h_rec.ATTRIBUTE12,
3024: l_okl_k_headers_h_rec.ATTRIBUTE13,
3025: l_okl_k_headers_h_rec.ATTRIBUTE14,
3026: l_okl_k_headers_h_rec.ATTRIBUTE15,
3027: l_okl_k_headers_h_rec.CREATED_BY,
3028: l_okl_k_headers_h_rec.CREATION_DATE,

Line 3025: l_okl_k_headers_h_rec.ATTRIBUTE14,

3021: l_okl_k_headers_h_rec.ATTRIBUTE10,
3022: l_okl_k_headers_h_rec.ATTRIBUTE11,
3023: l_okl_k_headers_h_rec.ATTRIBUTE12,
3024: l_okl_k_headers_h_rec.ATTRIBUTE13,
3025: l_okl_k_headers_h_rec.ATTRIBUTE14,
3026: l_okl_k_headers_h_rec.ATTRIBUTE15,
3027: l_okl_k_headers_h_rec.CREATED_BY,
3028: l_okl_k_headers_h_rec.CREATION_DATE,
3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,

Line 3026: l_okl_k_headers_h_rec.ATTRIBUTE15,

3022: l_okl_k_headers_h_rec.ATTRIBUTE11,
3023: l_okl_k_headers_h_rec.ATTRIBUTE12,
3024: l_okl_k_headers_h_rec.ATTRIBUTE13,
3025: l_okl_k_headers_h_rec.ATTRIBUTE14,
3026: l_okl_k_headers_h_rec.ATTRIBUTE15,
3027: l_okl_k_headers_h_rec.CREATED_BY,
3028: l_okl_k_headers_h_rec.CREATION_DATE,
3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,

Line 3027: l_okl_k_headers_h_rec.CREATED_BY,

3023: l_okl_k_headers_h_rec.ATTRIBUTE12,
3024: l_okl_k_headers_h_rec.ATTRIBUTE13,
3025: l_okl_k_headers_h_rec.ATTRIBUTE14,
3026: l_okl_k_headers_h_rec.ATTRIBUTE15,
3027: l_okl_k_headers_h_rec.CREATED_BY,
3028: l_okl_k_headers_h_rec.CREATION_DATE,
3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,

Line 3028: l_okl_k_headers_h_rec.CREATION_DATE,

3024: l_okl_k_headers_h_rec.ATTRIBUTE13,
3025: l_okl_k_headers_h_rec.ATTRIBUTE14,
3026: l_okl_k_headers_h_rec.ATTRIBUTE15,
3027: l_okl_k_headers_h_rec.CREATED_BY,
3028: l_okl_k_headers_h_rec.CREATION_DATE,
3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
3032: l_okl_k_headers_h_rec.AMD_CODE,

Line 3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,

3025: l_okl_k_headers_h_rec.ATTRIBUTE14,
3026: l_okl_k_headers_h_rec.ATTRIBUTE15,
3027: l_okl_k_headers_h_rec.CREATED_BY,
3028: l_okl_k_headers_h_rec.CREATION_DATE,
3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
3032: l_okl_k_headers_h_rec.AMD_CODE,
3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,

Line 3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,

3026: l_okl_k_headers_h_rec.ATTRIBUTE15,
3027: l_okl_k_headers_h_rec.CREATED_BY,
3028: l_okl_k_headers_h_rec.CREATION_DATE,
3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
3032: l_okl_k_headers_h_rec.AMD_CODE,
3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,

Line 3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,

3027: l_okl_k_headers_h_rec.CREATED_BY,
3028: l_okl_k_headers_h_rec.CREATION_DATE,
3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
3032: l_okl_k_headers_h_rec.AMD_CODE,
3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,

Line 3032: l_okl_k_headers_h_rec.AMD_CODE,

3028: l_okl_k_headers_h_rec.CREATION_DATE,
3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
3032: l_okl_k_headers_h_rec.AMD_CODE,
3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,

Line 3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,

3029: l_okl_k_headers_h_rec.LAST_UPDATED_BY,
3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
3032: l_okl_k_headers_h_rec.AMD_CODE,
3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,

Line 3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,

3030: l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
3032: l_okl_k_headers_h_rec.AMD_CODE,
3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,

Line 3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,

3031: l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
3032: l_okl_k_headers_h_rec.AMD_CODE,
3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,

Line 3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,

3032: l_okl_k_headers_h_rec.AMD_CODE,
3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,

Line 3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,

3033: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,

Line 3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,

3034: l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,

Line 3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,

3035: l_okl_k_headers_h_rec.CREDIT_ACT_YN,
3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,

Line 3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,

3036: l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,

Line 3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,

3037: l_okl_k_headers_h_rec.PRE_TAX_YIELD,
3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,

Line 3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,

3038: l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
3046: l_okl_k_headers_h_rec.DEAL_TYPE,

Line 3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,

3039: l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
3046: l_okl_k_headers_h_rec.DEAL_TYPE,
3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,

Line 3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,

3040: l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
3046: l_okl_k_headers_h_rec.DEAL_TYPE,
3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,
3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,

Line 3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,

3041: l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
3046: l_okl_k_headers_h_rec.DEAL_TYPE,
3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,
3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
3049: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,

Line 3046: l_okl_k_headers_h_rec.DEAL_TYPE,

3042: l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
3046: l_okl_k_headers_h_rec.DEAL_TYPE,
3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,
3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
3049: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
3050: l_okl_k_headers_h_rec.ACCEPTED_DATE,

Line 3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,

3043: l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
3046: l_okl_k_headers_h_rec.DEAL_TYPE,
3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,
3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
3049: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
3050: l_okl_k_headers_h_rec.ACCEPTED_DATE,
3051: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,

Line 3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,

3044: l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
3046: l_okl_k_headers_h_rec.DEAL_TYPE,
3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,
3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
3049: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
3050: l_okl_k_headers_h_rec.ACCEPTED_DATE,
3051: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
3052: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,

Line 3049: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,

3045: l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
3046: l_okl_k_headers_h_rec.DEAL_TYPE,
3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,
3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
3049: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
3050: l_okl_k_headers_h_rec.ACCEPTED_DATE,
3051: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
3052: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
3053: --Bug# 2697681 schema changes 11.5.9

Line 3050: l_okl_k_headers_h_rec.ACCEPTED_DATE,

3046: l_okl_k_headers_h_rec.DEAL_TYPE,
3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,
3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
3049: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
3050: l_okl_k_headers_h_rec.ACCEPTED_DATE,
3051: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
3052: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
3053: --Bug# 2697681 schema changes 11.5.9
3054: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,

Line 3051: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,

3047: l_okl_k_headers_h_rec.PRE_TAX_IRR,
3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
3049: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
3050: l_okl_k_headers_h_rec.ACCEPTED_DATE,
3051: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
3052: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
3053: --Bug# 2697681 schema changes 11.5.9
3054: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
3055: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,

Line 3052: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,

3048: l_okl_k_headers_h_rec.AFTER_TAX_IRR,
3049: l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
3050: l_okl_k_headers_h_rec.ACCEPTED_DATE,
3051: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
3052: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
3053: --Bug# 2697681 schema changes 11.5.9
3054: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
3055: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
3056: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,

Line 3054: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,

3050: l_okl_k_headers_h_rec.ACCEPTED_DATE,
3051: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
3052: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
3053: --Bug# 2697681 schema changes 11.5.9
3054: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
3055: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
3056: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
3057: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
3058: l_okl_k_headers_h_rec.RECOURSE_CODE,

Line 3055: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,

3051: l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
3052: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
3053: --Bug# 2697681 schema changes 11.5.9
3054: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
3055: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
3056: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
3057: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
3058: l_okl_k_headers_h_rec.RECOURSE_CODE,
3059: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,

Line 3056: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,

3052: l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
3053: --Bug# 2697681 schema changes 11.5.9
3054: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
3055: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
3056: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
3057: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
3058: l_okl_k_headers_h_rec.RECOURSE_CODE,
3059: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
3060: l_okl_k_headers_h_rec.ASSIGNABLE_YN,

Line 3057: l_okl_k_headers_h_rec.MULTI_GAAP_YN,

3053: --Bug# 2697681 schema changes 11.5.9
3054: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
3055: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
3056: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
3057: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
3058: l_okl_k_headers_h_rec.RECOURSE_CODE,
3059: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
3060: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
3061: l_okl_k_headers_h_rec.SECURITIZED_CODE,

Line 3058: l_okl_k_headers_h_rec.RECOURSE_CODE,

3054: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
3055: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
3056: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
3057: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
3058: l_okl_k_headers_h_rec.RECOURSE_CODE,
3059: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
3060: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
3061: l_okl_k_headers_h_rec.SECURITIZED_CODE,
3062: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,

Line 3059: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,

3055: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
3056: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
3057: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
3058: l_okl_k_headers_h_rec.RECOURSE_CODE,
3059: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
3060: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
3061: l_okl_k_headers_h_rec.SECURITIZED_CODE,
3062: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
3063: --Bug#3143522 : 11.5.10

Line 3060: l_okl_k_headers_h_rec.ASSIGNABLE_YN,

3056: l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
3057: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
3058: l_okl_k_headers_h_rec.RECOURSE_CODE,
3059: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
3060: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
3061: l_okl_k_headers_h_rec.SECURITIZED_CODE,
3062: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
3063: --Bug#3143522 : 11.5.10
3064: --subsidy

Line 3061: l_okl_k_headers_h_rec.SECURITIZED_CODE,

3057: l_okl_k_headers_h_rec.MULTI_GAAP_YN,
3058: l_okl_k_headers_h_rec.RECOURSE_CODE,
3059: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
3060: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
3061: l_okl_k_headers_h_rec.SECURITIZED_CODE,
3062: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
3063: --Bug#3143522 : 11.5.10
3064: --subsidy
3065: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,

Line 3062: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,

3058: l_okl_k_headers_h_rec.RECOURSE_CODE,
3059: l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
3060: l_okl_k_headers_h_rec.ASSIGNABLE_YN,
3061: l_okl_k_headers_h_rec.SECURITIZED_CODE,
3062: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
3063: --Bug#3143522 : 11.5.10
3064: --subsidy
3065: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
3066: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,

Line 3065: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,

3061: l_okl_k_headers_h_rec.SECURITIZED_CODE,
3062: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
3063: --Bug#3143522 : 11.5.10
3064: --subsidy
3065: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
3066: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
3067: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
3068: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3069: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,

Line 3066: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,

3062: l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
3063: --Bug#3143522 : 11.5.10
3064: --subsidy
3065: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
3066: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
3067: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
3068: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3069: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
3070: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,

Line 3067: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,

3063: --Bug#3143522 : 11.5.10
3064: --subsidy
3065: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
3066: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
3067: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
3068: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3069: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
3070: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
3071: --Bug# 3973640 : 11.5.10+ schema

Line 3068: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,

3064: --subsidy
3065: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
3066: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
3067: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
3068: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3069: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
3070: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
3071: --Bug# 3973640 : 11.5.10+ schema
3072: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,

Line 3069: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,

3065: l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
3066: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
3067: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
3068: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3069: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
3070: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
3071: --Bug# 3973640 : 11.5.10+ schema
3072: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
3073: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,

Line 3070: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,

3066: l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
3067: l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
3068: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3069: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
3070: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
3071: --Bug# 3973640 : 11.5.10+ schema
3072: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
3073: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
3074: l_okl_k_headers_h_rec.TOT_CL_LIMIT,

Line 3072: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,

3068: l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
3069: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
3070: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
3071: --Bug# 3973640 : 11.5.10+ schema
3072: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
3073: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
3074: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
3075: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
3076: l_okl_k_headers_h_rec.CRS_ID,

Line 3073: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,

3069: l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
3070: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
3071: --Bug# 3973640 : 11.5.10+ schema
3072: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
3073: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
3074: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
3075: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
3076: l_okl_k_headers_h_rec.CRS_ID,
3077: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,

Line 3074: l_okl_k_headers_h_rec.TOT_CL_LIMIT,

3070: l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
3071: --Bug# 3973640 : 11.5.10+ schema
3072: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
3073: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
3074: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
3075: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
3076: l_okl_k_headers_h_rec.CRS_ID,
3077: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
3078: --Bug# 4419339 OKLH Schema Sales Quote

Line 3075: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,

3071: --Bug# 3973640 : 11.5.10+ schema
3072: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
3073: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
3074: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
3075: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
3076: l_okl_k_headers_h_rec.CRS_ID,
3077: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
3078: --Bug# 4419339 OKLH Schema Sales Quote
3079: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED,

Line 3076: l_okl_k_headers_h_rec.CRS_ID,

3072: l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
3073: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
3074: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
3075: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
3076: l_okl_k_headers_h_rec.CRS_ID,
3077: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
3078: --Bug# 4419339 OKLH Schema Sales Quote
3079: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED,
3080: l_okl_k_headers_h_rec.DATE_TRADEIN,

Line 3077: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,

3073: l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
3074: l_okl_k_headers_h_rec.TOT_CL_LIMIT,
3075: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
3076: l_okl_k_headers_h_rec.CRS_ID,
3077: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
3078: --Bug# 4419339 OKLH Schema Sales Quote
3079: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED,
3080: l_okl_k_headers_h_rec.DATE_TRADEIN,
3081: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,

Line 3079: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED,

3075: l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
3076: l_okl_k_headers_h_rec.CRS_ID,
3077: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
3078: --Bug# 4419339 OKLH Schema Sales Quote
3079: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED,
3080: l_okl_k_headers_h_rec.DATE_TRADEIN,
3081: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
3082: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
3083: --Added by dpsingh for LE uptake

Line 3080: l_okl_k_headers_h_rec.DATE_TRADEIN,

3076: l_okl_k_headers_h_rec.CRS_ID,
3077: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
3078: --Bug# 4419339 OKLH Schema Sales Quote
3079: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED,
3080: l_okl_k_headers_h_rec.DATE_TRADEIN,
3081: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
3082: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
3083: --Added by dpsingh for LE uptake
3084: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID);

Line 3081: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,

3077: l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
3078: --Bug# 4419339 OKLH Schema Sales Quote
3079: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED,
3080: l_okl_k_headers_h_rec.DATE_TRADEIN,
3081: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
3082: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
3083: --Added by dpsingh for LE uptake
3084: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID);
3085: -- Set OUT values

Line 3082: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,

3078: --Bug# 4419339 OKLH Schema Sales Quote
3079: l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED,
3080: l_okl_k_headers_h_rec.DATE_TRADEIN,
3081: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
3082: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
3083: --Added by dpsingh for LE uptake
3084: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID);
3085: -- Set OUT values
3086: x_okl_k_headers_h_rec := l_okl_k_headers_h_rec;

Line 3084: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID);

3080: l_okl_k_headers_h_rec.DATE_TRADEIN,
3081: l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
3082: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
3083: --Added by dpsingh for LE uptake
3084: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID);
3085: -- Set OUT values
3086: x_okl_k_headers_h_rec := l_okl_k_headers_h_rec;
3087: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3088:

Line 3086: x_okl_k_headers_h_rec := l_okl_k_headers_h_rec;

3082: l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
3083: --Added by dpsingh for LE uptake
3084: l_okl_k_headers_h_rec.LEGAL_ENTITY_ID);
3085: -- Set OUT values
3086: x_okl_k_headers_h_rec := l_okl_k_headers_h_rec;
3087: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3088:
3089: EXCEPTION
3090: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3124: -- insert_row for: OKL_K_HEADERS --

3120:
3121: END insert_row;
3122:
3123: ------------------------------------
3124: -- insert_row for: OKL_K_HEADERS --
3125: ------------------------------------
3126:
3127: PROCEDURE insert_row(
3128:

Line 3143: -- Set_Attributes for: OKL_K_HEADERS --

3139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3140: l_khr_rec khr_rec_type := p_khr_rec;
3141: l_def_khr_rec khr_rec_type;
3142: ----------------------------------------
3143: -- Set_Attributes for: OKL_K_HEADERS --
3144: ----------------------------------------
3145: FUNCTION Set_Attributes (
3146: p_khr_rec IN khr_rec_type,
3147: x_khr_rec OUT NOCOPY khr_rec_type

Line 3179: INSERT INTO OKL_K_HEADERS(

3175: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3176: RAISE OKC_API.G_EXCEPTION_ERROR;
3177: END IF;
3178:
3179: INSERT INTO OKL_K_HEADERS(
3180: ID,
3181: ISG_ID,
3182: KHR_ID,
3183: PDT_ID,

Line 3401: -- insert_row for: OKL_K_HEADERS_V --

3397:
3398: END insert_row;
3399:
3400: ------------------------------------
3401: -- insert_row for: OKL_K_HEADERS_V --
3402: ------------------------------------
3403:
3404: PROCEDURE insert_row(
3405:

Line 3437: -- Set_Attributes for: OKL_K_HEADERS_V --

3433: l_khrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3434: RETURN(l_khrv_rec);
3435: END fill_who_columns;
3436: ----------------------------------------
3437: -- Set_Attributes for: OKL_K_HEADERS_V --
3438: ----------------------------------------
3439: FUNCTION Set_Attributes (
3440: p_khrv_rec IN khrv_rec_type,
3441: x_khrv_rec OUT NOCOPY khrv_rec_type

Line 3566: -- PL/SQL TBL insert_row for: OKL_K_HEADERS_V --

3562:
3563: END insert_row;
3564:
3565: ----------------------------------------
3566: -- PL/SQL TBL insert_row for: OKL_K_HEADERS_V --
3567: ----------------------------------------
3568:
3569: PROCEDURE insert_row(
3570:

Line 3642: -- lock_row for: OKL_K_HEADERS --

3638: -- PROCEDURE lock_row
3639: ---------------------------------------------------------------------------
3640:
3641: --------------------------------
3642: -- lock_row for: OKL_K_HEADERS --
3643: --------------------------------
3644:
3645: PROCEDURE lock_row(
3646:

Line 3658: FROM OKL_K_HEADERS

3654: E_Resource_Busy EXCEPTION;
3655: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3656: CURSOR lock_csr (p_khr_rec IN khr_rec_type) IS
3657: SELECT OBJECT_VERSION_NUMBER
3658: FROM OKL_K_HEADERS
3659: WHERE ID = p_khr_rec.id
3660: AND OBJECT_VERSION_NUMBER = p_khr_rec.object_version_number
3661: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3662:

Line 3665: FROM OKL_K_HEADERS

3661: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3662:
3663: CURSOR lchk_csr (p_khr_rec IN khr_rec_type) IS
3664: SELECT OBJECT_VERSION_NUMBER
3665: FROM OKL_K_HEADERS
3666: WHERE ID = p_khr_rec.id;
3667: l_api_version CONSTANT NUMBER := 1;
3668: l_api_name CONSTANT VARCHAR2(30) := 'rec_lock_row';
3669: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3670: l_object_version_number OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;

3666: WHERE ID = p_khr_rec.id;
3667: l_api_version CONSTANT NUMBER := 1;
3668: l_api_name CONSTANT VARCHAR2(30) := 'rec_lock_row';
3669: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3670: l_object_version_number OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
3671: lc_object_version_number OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
3672: l_row_notfound BOOLEAN := FALSE;
3673: lc_row_notfound BOOLEAN := FALSE;
3674: BEGIN

Line 3671: lc_object_version_number OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;

3667: l_api_version CONSTANT NUMBER := 1;
3668: l_api_name CONSTANT VARCHAR2(30) := 'rec_lock_row';
3669: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3670: l_object_version_number OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
3671: lc_object_version_number OKL_K_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
3672: l_row_notfound BOOLEAN := FALSE;
3673: lc_row_notfound BOOLEAN := FALSE;
3674: BEGIN
3675: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3756: -- lock_row for: OKL_K_HEADERS_V --

3752:
3753: END lock_row;
3754:
3755: ----------------------------------
3756: -- lock_row for: OKL_K_HEADERS_V --
3757: ----------------------------------
3758:
3759: PROCEDURE lock_row(
3760:

Line 3845: -- PL/SQL TBL lock_row for: OKL_K_HEADERS_V --

3841: );
3842:
3843: END lock_row;
3844: --------------------------------------
3845: -- PL/SQL TBL lock_row for: OKL_K_HEADERS_V --
3846: --------------------------------------
3847:
3848: PROCEDURE lock_row(
3849:

Line 3919: -- update_row for: OKL_K_HEADERS --

3915: -- PROCEDURE update_row
3916: ---------------------------------------------------------------------------
3917:
3918: ----------------------------------
3919: -- update_row for: OKL_K_HEADERS --
3920: ----------------------------------
3921:
3922: PROCEDURE update_row(
3923:

Line 3938: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;

3934: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3935: l_khr_rec khr_rec_type := p_khr_rec;
3936: l_def_khr_rec khr_rec_type;
3937: l_row_notfound BOOLEAN := TRUE;
3938: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;
3939: lx_okl_k_headers_h_rec okl_k_headers_h_rec_type;
3940: ----------------------------------
3941: -- FUNCTION populate_new_record --
3942: ----------------------------------

Line 3939: lx_okl_k_headers_h_rec okl_k_headers_h_rec_type;

3935: l_khr_rec khr_rec_type := p_khr_rec;
3936: l_def_khr_rec khr_rec_type;
3937: l_row_notfound BOOLEAN := TRUE;
3938: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;
3939: lx_okl_k_headers_h_rec okl_k_headers_h_rec_type;
3940: ----------------------------------
3941: -- FUNCTION populate_new_record --
3942: ----------------------------------
3943: FUNCTION populate_new_record (

Line 3960: migrate(l_khr_rec, l_okl_k_headers_h_rec);

3956: END IF;
3957: -- Move the "old" record to the history record:
3958: -- (1) to get the "old" version
3959: -- (2) to avoid 2 hits to the database
3960: migrate(l_khr_rec, l_okl_k_headers_h_rec);
3961:
3962: IF (x_khr_rec.ID = OKC_API.G_MISS_NUM) THEN
3963: x_khr_rec.ID := l_khr_rec.ID;
3964: END IF;

Line 4284: -- Set_Attributes for: OKL_K_HEADERS --

4280: END IF;
4281: RETURN(l_return_status);
4282: END populate_new_record;
4283: --------------------------------------
4284: -- Set_Attributes for: OKL_K_HEADERS --
4285: --------------------------------------
4286: FUNCTION Set_Attributes (
4287: p_khr_rec IN khr_rec_type,
4288: x_khr_rec OUT NOCOPY khr_rec_type

Line 4327: UPDATE OKL_K_HEADERS

4323: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4324: RAISE OKC_API.G_EXCEPTION_ERROR;
4325: END IF;
4326:
4327: UPDATE OKL_K_HEADERS
4328: SET
4329: ID = l_def_khr_rec.ID,
4330: ISG_ID = l_def_khr_rec.ISG_ID,
4331: KHR_ID = l_def_khr_rec.KHR_ID,

Line 4428: l_okl_k_headers_h_rec,

4424: p_init_msg_list,
4425: x_return_status,
4426: x_msg_count,
4427: x_msg_data,
4428: l_okl_k_headers_h_rec,
4429: lx_okl_k_headers_h_rec
4430: );
4431:
4432: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4429: lx_okl_k_headers_h_rec

4425: x_return_status,
4426: x_msg_count,
4427: x_msg_data,
4428: l_okl_k_headers_h_rec,
4429: lx_okl_k_headers_h_rec
4430: );
4431:
4432: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4433: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4477: -- update_row for: OKL_K_HEADERS_V --

4473:
4474: END update_row;
4475:
4476: ------------------------------------
4477: -- update_row for: OKL_K_HEADERS_V --
4478: ------------------------------------
4479:
4480: PROCEDURE update_row(
4481:

Line 4854: -- Set_Attributes for: OKL_K_HEADERS_V --

4850:
4851: RETURN(l_return_status);
4852: END populate_new_record;
4853: ----------------------------------------
4854: -- Set_Attributes for: OKL_K_HEADERS_V --
4855: ----------------------------------------
4856: FUNCTION Set_Attributes (
4857: p_khrv_rec IN khrv_rec_type,
4858: x_khrv_rec OUT NOCOPY khrv_rec_type

Line 4982: -- PL/SQL TBL update_row for: OKL_K_HEADERS_V --

4978: );
4979:
4980: END update_row;
4981: ----------------------------------------
4982: -- PL/SQL TBL update_row for: OKL_K_HEADERS_V --
4983: ----------------------------------------
4984:
4985: PROCEDURE update_row(
4986:

Line 5059: -- delete_row for: OKL_K_HEADERS --

5055: -- PROCEDURE delete_row
5056: ---------------------------------------------------------------------------
5057:
5058: ----------------------------------
5059: -- delete_row for: OKL_K_HEADERS --
5060: ----------------------------------
5061:
5062: PROCEDURE delete_row(
5063:

Line 5076: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;

5072: l_api_name CONSTANT VARCHAR2(30) := 'rec_delete_row';
5073: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5074: l_khr_rec khr_rec_type:= p_khr_rec;
5075: l_row_notfound BOOLEAN := TRUE;
5076: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;
5077: lx_okl_k_headers_h_rec okl_k_headers_h_rec_type;
5078: BEGIN
5079: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5080: p_init_msg_list,

Line 5077: lx_okl_k_headers_h_rec okl_k_headers_h_rec_type;

5073: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5074: l_khr_rec khr_rec_type:= p_khr_rec;
5075: l_row_notfound BOOLEAN := TRUE;
5076: l_okl_k_headers_h_rec okl_k_headers_h_rec_type;
5077: lx_okl_k_headers_h_rec okl_k_headers_h_rec_type;
5078: BEGIN
5079: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5080: p_init_msg_list,
5081: '_PVT',

Line 5096: migrate(l_khr_rec, l_okl_k_headers_h_rec);

5092: l_khr_rec := get_rec(l_khr_rec, l_row_notfound);
5093: IF (l_row_notfound) THEN
5094: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5095: END IF;
5096: migrate(l_khr_rec, l_okl_k_headers_h_rec);
5097: insert_row(
5098: l_api_version,
5099: p_init_msg_list,
5100: x_return_status,

Line 5103: l_okl_k_headers_h_rec,

5099: p_init_msg_list,
5100: x_return_status,
5101: x_msg_count,
5102: x_msg_data,
5103: l_okl_k_headers_h_rec,
5104: lx_okl_k_headers_h_rec
5105: );
5106:
5107: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5104: lx_okl_k_headers_h_rec

5100: x_return_status,
5101: x_msg_count,
5102: x_msg_data,
5103: l_okl_k_headers_h_rec,
5104: lx_okl_k_headers_h_rec
5105: );
5106:
5107: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5108: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5114: DELETE FROM OKL_K_HEADERS

5110: RAISE OKC_API.G_EXCEPTION_ERROR;
5111: END IF;
5112: -------removed as we do not do implicit versioning on delete-----------------*/
5113: --Bug # 2522268
5114: DELETE FROM OKL_K_HEADERS
5115: WHERE ID = l_khr_rec.id;
5116:
5117: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5118:

Line 5240: -- PL/SQL TBL delete_row for: OKL_K_HEADERS_V --

5236: );
5237:
5238: END delete_row;
5239: ----------------------------------------
5240: -- PL/SQL TBL delete_row for: OKL_K_HEADERS_V --
5241: ----------------------------------------
5242:
5243: PROCEDURE delete_row(
5244:

Line 5320: INSERT INTO OKL_K_HEADERS_H

5316:
5317: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
5318:
5319: BEGIN
5320: INSERT INTO OKL_K_HEADERS_H
5321: (
5322: major_version,
5323: ID,
5324: ISG_ID,

Line 5504: FROM OKL_K_HEADERS

5500: TRADEIN_AMOUNT,
5501: TRADEIN_DESCRIPTION,
5502: --Added by dpsingh for LE uptake
5503: LEGAL_ENTITY_ID
5504: FROM OKL_K_HEADERS
5505: WHERE id = p_khr_id;
5506:
5507: RETURN l_return_status;
5508: EXCEPTION

Line 5531: INSERT INTO OKL_K_HEADERS

5527:
5528: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
5529:
5530: BEGIN
5531: INSERT INTO OKL_K_HEADERS
5532: (
5533: ID,
5534: ISG_ID,
5535: KHR_ID,

Line 5712: FROM OKL_K_HEADERS_H

5708: TRADEIN_AMOUNT,
5709: TRADEIN_DESCRIPTION,
5710: --Added by dpsingh for LE uptake
5711: LEGAL_ENTITY_ID
5712: FROM OKL_K_HEADERS_H
5713: WHERE id = p_khr_id and major_version = p_major_version;
5714:
5715: RETURN l_return_status;
5716: EXCEPTION