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

APPS.OKL_CREATE_KLE_PVT dependencies on OKC_K_ITEMS_V

Line 1459: FUNCTION get_rec_ib_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,

1455: END IF;
1456: RETURN(x_return_status);
1457: END get_rec_cplv;
1458: --------------------------------------------------------------------------------------------------
1459: FUNCTION get_rec_ib_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1460: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1461: x_cimv_rec OUT NOCOPY cimv_rec_type)
1462: RETURN VARCHAR2 IS
1463: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

Line 1460: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,

1456: RETURN(x_return_status);
1457: END get_rec_cplv;
1458: --------------------------------------------------------------------------------------------------
1459: FUNCTION get_rec_ib_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1460: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1461: x_cimv_rec OUT NOCOPY cimv_rec_type)
1462: RETURN VARCHAR2 IS
1463: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1464: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

Line 1463: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

1459: FUNCTION get_rec_ib_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1460: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1461: x_cimv_rec OUT NOCOPY cimv_rec_type)
1462: RETURN VARCHAR2 IS
1463: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1464: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
1465: SELECT CIM.ID,
1466: CIM.OBJECT_VERSION_NUMBER,
1467: CIM.CLE_ID,

Line 1464: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

1460: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1461: x_cimv_rec OUT NOCOPY cimv_rec_type)
1462: RETURN VARCHAR2 IS
1463: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1464: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
1465: SELECT CIM.ID,
1466: CIM.OBJECT_VERSION_NUMBER,
1467: CIM.CLE_ID,
1468: CIM.CHR_ID,

Line 1485: FROM okc_k_items_v cim,

1481: CIM.CREATION_DATE,
1482: CIM.LAST_UPDATED_BY,
1483: CIM.LAST_UPDATE_DATE,
1484: CIM.LAST_UPDATE_LOGIN
1485: FROM okc_k_items_v cim,
1486: okc_k_lines_b cle,
1487: okc_line_styles_b lse,
1488: okc_k_lines_b cle1
1489: WHERE cim.dnz_chr_id = p_dnz_chr_id

Line 1498: /*FROM okc_k_items_v cim

1494: AND cle.cle_id = cle1.cle_id
1495: AND cle1.id = p_cle_id
1496: AND cle1.dnz_chr_id = p_dnz_chr_id; --cim.dnz_chr_id
1497:
1498: /*FROM okc_k_items_v cim
1499: WHERE cim.dnz_chr_id = p_dnz_chr_id
1500: AND cim.cle_id in (SELECT cle.id
1501: FROM okc_k_lines_v cle,
1502: okc_line_styles_v lse

Line 1562: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,

1558: END IF;
1559: RETURN(x_return_status);
1560: END get_rec_ib_cimv;
1561: ----------------------------------------------------------------------------------------------------
1562: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1563: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1564: x_cimv_rec OUT NOCOPY cimv_rec_type)
1565: RETURN VARCHAR2 IS
1566: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

Line 1563: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,

1559: RETURN(x_return_status);
1560: END get_rec_ib_cimv;
1561: ----------------------------------------------------------------------------------------------------
1562: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1563: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1564: x_cimv_rec OUT NOCOPY cimv_rec_type)
1565: RETURN VARCHAR2 IS
1566: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1567: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

Line 1566: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

1562: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1563: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1564: x_cimv_rec OUT NOCOPY cimv_rec_type)
1565: RETURN VARCHAR2 IS
1566: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1567: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
1568: SELECT CIM.ID,
1569: CIM.OBJECT_VERSION_NUMBER,
1570: CIM.CLE_ID,

Line 1567: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

1563: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1564: x_cimv_rec OUT NOCOPY cimv_rec_type)
1565: RETURN VARCHAR2 IS
1566: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1567: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
1568: SELECT CIM.ID,
1569: CIM.OBJECT_VERSION_NUMBER,
1570: CIM.CLE_ID,
1571: CIM.CHR_ID,

Line 1588: FROM okc_k_items_v cim

1584: CIM.CREATION_DATE,
1585: CIM.LAST_UPDATED_BY,
1586: CIM.LAST_UPDATE_DATE,
1587: CIM.LAST_UPDATE_LOGIN
1588: FROM okc_k_items_v cim
1589: WHERE cim.dnz_chr_id = p_dnz_chr_id
1590: AND cim.cle_id = p_cle_id;
1591: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
1592: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 1643: FUNCTION get_rec_update_cimv(p_cimv_id IN OKC_K_ITEMS_V.ID%TYPE,

1639: END IF;
1640: RETURN(x_return_status);
1641: END get_rec_cimv;
1642: -------------------------------------------------------------------------------------------------
1643: FUNCTION get_rec_update_cimv(p_cimv_id IN OKC_K_ITEMS_V.ID%TYPE,
1644: x_cimv_rec OUT NOCOPY cimv_rec_type)
1645: RETURN VARCHAR2 IS
1646: CURSOR okc_cimv_pk_csr(p_cimv_id OKC_K_ITEMS_V.ID%TYPE) IS
1647: SELECT ID,

Line 1646: CURSOR okc_cimv_pk_csr(p_cimv_id OKC_K_ITEMS_V.ID%TYPE) IS

1642: -------------------------------------------------------------------------------------------------
1643: FUNCTION get_rec_update_cimv(p_cimv_id IN OKC_K_ITEMS_V.ID%TYPE,
1644: x_cimv_rec OUT NOCOPY cimv_rec_type)
1645: RETURN VARCHAR2 IS
1646: CURSOR okc_cimv_pk_csr(p_cimv_id OKC_K_ITEMS_V.ID%TYPE) IS
1647: SELECT ID,
1648: OBJECT_VERSION_NUMBER,
1649: CLE_ID,
1650: CHR_ID,

Line 1667: FROM okc_k_items_V cim

1663: CREATION_DATE,
1664: LAST_UPDATED_BY,
1665: LAST_UPDATE_DATE,
1666: LAST_UPDATE_LOGIN
1667: FROM okc_k_items_V cim
1668: WHERE cim.id = p_cimv_id;
1669: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
1670: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1671: BEGIN

Line 3530: FUNCTION check_required_values(p_item1 IN OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

3526: -- Parameters :
3527: -- Version : 1.0
3528: -- End of Commnets
3529:
3530: FUNCTION check_required_values(p_item1 IN OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
3531: p_item2 IN OKC_K_ITEMS_V.OBJECT1_ID2%TYPE,
3532: p_ast_no IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3533: p_ast_desc IN OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE,
3534: p_cost IN OKL_TXL_ASSETS_B.ORIGINAL_COST%TYPE,

Line 3531: p_item2 IN OKC_K_ITEMS_V.OBJECT1_ID2%TYPE,

3527: -- Version : 1.0
3528: -- End of Commnets
3529:
3530: FUNCTION check_required_values(p_item1 IN OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
3531: p_item2 IN OKC_K_ITEMS_V.OBJECT1_ID2%TYPE,
3532: p_ast_no IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3533: p_ast_desc IN OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE,
3534: p_cost IN OKL_TXL_ASSETS_B.ORIGINAL_COST%TYPE,
3535: p_units IN OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE,

Line 3535: p_units IN OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE,

3531: p_item2 IN OKC_K_ITEMS_V.OBJECT1_ID2%TYPE,
3532: p_ast_no IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3533: p_ast_desc IN OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE,
3534: p_cost IN OKL_TXL_ASSETS_B.ORIGINAL_COST%TYPE,
3535: p_units IN OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE,
3536: p_ib_loc1 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
3537: p_ib_loc2 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE,
3538: p_fa_loc IN OKL_TXL_ASSETS_B.FA_LOCATION_ID%TYPE,
3539: p_refinance_amount IN OKL_K_LINES.REFINANCE_AMOUNT%TYPE,

Line 5932: lv_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;

5928: l_trxv_rec trxv_rec_type;
5929: i NUMBER := 0;
5930:
5931: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5932: lv_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
5933: lv_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR;
5934: ln_dummy NUMBER := 0;
5935: lv_dummy VARCHAR2(3);
5936: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;

Line 5933: lv_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR;

5929: i NUMBER := 0;
5930:
5931: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5932: lv_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
5933: lv_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR;
5934: ln_dummy NUMBER := 0;
5935: lv_dummy VARCHAR2(3);
5936: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;
5937: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%TYPE;

Line 6746: p_token1_value => 'OKC_K_ITEMS_V Record');

6742: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
6743: OKL_API.set_message(p_app_name => G_APP_NAME,
6744: p_msg_name => G_FETCHING_INFO,
6745: p_token1 => G_REC_NAME_TOKEN,
6746: p_token1_value => 'OKC_K_ITEMS_V Record');
6747: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6748: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6749: OKL_API.set_message(p_app_name => G_APP_NAME,
6750: p_msg_name => G_FETCHING_INFO,

Line 6752: p_token1_value => 'OKC_K_ITEMS_V Record');

6748: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6749: OKL_API.set_message(p_app_name => G_APP_NAME,
6750: p_msg_name => G_FETCHING_INFO,
6751: p_token1 => G_REC_NAME_TOKEN,
6752: p_token1_value => 'OKC_K_ITEMS_V Record');
6753: RAISE OKL_API.G_EXCEPTION_ERROR;
6754: END IF;
6755: IF l_cimv_rec.cle_id <> x_clev_rec.id THEN
6756: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 7868: p_token1_value => 'OKC_K_ITEMS_V Record');

7864: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7865: OKL_API.set_message(p_app_name => G_APP_NAME,
7866: p_msg_name => G_FETCHING_INFO,
7867: p_token1 => G_REC_NAME_TOKEN,
7868: p_token1_value => 'OKC_K_ITEMS_V Record');
7869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7870: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7871: OKL_API.set_message(p_app_name => G_APP_NAME,
7872: p_msg_name => G_FETCHING_INFO,

Line 7874: p_token1_value => 'OKC_K_ITEMS_V Record');

7870: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7871: OKL_API.set_message(p_app_name => G_APP_NAME,
7872: p_msg_name => G_FETCHING_INFO,
7873: p_token1 => G_REC_NAME_TOKEN,
7874: p_token1_value => 'OKC_K_ITEMS_V Record');
7875: RAISE OKL_API.G_EXCEPTION_ERROR;
7876: END IF;
7877: -- Creating iti record
7878: l_itiv_rec.inventory_item_id := to_number(r_cimv_rec.object1_id1);

Line 7948: p_token1_value => 'OKC_K_ITEMS_V Record');

7944: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7945: OKL_API.set_message(p_app_name => G_APP_NAME,
7946: p_msg_name => G_FETCHING_INFO,
7947: p_token1 => G_REC_NAME_TOKEN,
7948: p_token1_value => 'OKC_K_ITEMS_V Record');
7949: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7950: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7951: OKL_API.set_message(p_app_name => G_APP_NAME,
7952: p_msg_name => G_FETCHING_INFO,

Line 7954: p_token1_value => 'OKC_K_ITEMS_V Record');

7950: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7951: OKL_API.set_message(p_app_name => G_APP_NAME,
7952: p_msg_name => G_FETCHING_INFO,
7953: p_token1 => G_REC_NAME_TOKEN,
7954: p_token1_value => 'OKC_K_ITEMS_V Record');
7955: RAISE OKL_API.G_EXCEPTION_ERROR;
7956: END IF;
7957: -- Creating iti record
7958: l_itiv_rec.inventory_item_id := to_number(r_cimv_rec.object1_id1);

Line 8947: okc_k_items_v cim,

8943: SELECT cle.cle_id
8944: FROM okc_subclass_top_line stl,
8945: okc_line_styles_b lse2,
8946: okc_line_styles_b lse1,
8947: okc_k_items_v cim,
8948: okc_k_lines_v cle
8949: WHERE cle.id = p_model_line_id
8950: AND cle.dnz_chr_id = p_dnz_chr_id
8951: AND cle.id = cim.cle_id

Line 9153: okc_k_items_v cim,

9149: SELECT cle.cle_id
9150: FROM okc_subclass_top_line stl,
9151: okc_line_styles_b lse2,
9152: okc_line_styles_b lse1,
9153: okc_k_items_v cim,
9154: okc_k_lines_v cle
9155: WHERE cle.id = p_model_line_id
9156: AND cle.dnz_chr_id = p_dnz_chr_id
9157: AND cle.id = cim.cle_id

Line 9358: okc_k_items_v cim,

9354: SELECT cle.cle_id
9355: FROM okc_subclass_top_line stl,
9356: okc_line_styles_b lse2,
9357: okc_line_styles_b lse1,
9358: okc_k_items_v cim,
9359: okc_k_lines_v cle
9360: WHERE cle.id = p_model_line_id
9361: AND cle.dnz_chr_id = p_dnz_chr_id
9362: AND cle.id = cim.cle_id

Line 9685: l_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;

9681: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9682: l_update_clev_rec clev_rec_type;
9683: l_update_klev_rec klev_rec_type;
9684: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
9685: l_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
9686:
9687: BEGIN
9688: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9689: -- Call start_activity to create savepoint, check compatibility

Line 11992: p_token1_value => 'OKC_K_ITEMS_V Record');

11988: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11989: OKL_API.set_message(p_app_name => G_APP_NAME,
11990: p_msg_name => G_FETCHING_INFO,
11991: p_token1 => G_REC_NAME_TOKEN,
11992: p_token1_value => 'OKC_K_ITEMS_V Record');
11993: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11994: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11995: OKL_API.set_message(p_app_name => G_APP_NAME,
11996: p_msg_name => G_FETCHING_INFO,

Line 11998: p_token1_value => 'OKC_K_ITEMS_V Record');

11994: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11995: OKL_API.set_message(p_app_name => G_APP_NAME,
11996: p_msg_name => G_FETCHING_INFO,
11997: p_token1 => G_REC_NAME_TOKEN,
11998: p_token1_value => 'OKC_K_ITEMS_V Record');
11999: RAISE OKL_API.G_EXCEPTION_ERROR;
12000: END IF;
12001: x_return_status := get_rec_klev(p_id => l_cplv_rec.cle_id,
12002: x_klev_rec => l_klev_rec);

Line 14897: p_token1_value => 'OKC_K_ITEMS_V Record');

14893: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
14894: OKL_API.set_message(p_app_name => G_APP_NAME,
14895: p_msg_name => G_FETCHING_INFO,
14896: p_token1 => G_REC_NAME_TOKEN,
14897: p_token1_value => 'OKC_K_ITEMS_V Record');
14898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
14899: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14900: OKL_API.set_message(p_app_name => G_APP_NAME,
14901: p_msg_name => G_FETCHING_INFO,

Line 14903: p_token1_value => 'OKC_K_ITEMS_V Record');

14899: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14900: OKL_API.set_message(p_app_name => G_APP_NAME,
14901: p_msg_name => G_FETCHING_INFO,
14902: p_token1 => G_REC_NAME_TOKEN,
14903: p_token1_value => 'OKC_K_ITEMS_V Record');
14904: RAISE OKL_API.G_EXCEPTION_ERROR;
14905: END IF;
14906:
14907: l_cimv_model_rec.object1_id1 := p_cimv_model_rec.object1_id1;

Line 15203: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;

15199: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
15200: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
15201: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
15202: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
15203: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
15204: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
15205: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
15206: ln_dummy NUMBER := 0;
15207: ln_dummy1 NUMBER := 0;

Line 16332: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;

16328: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
16329: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
16330: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
16331: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
16332: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
16333: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
16334: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
16335: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
16336: ln_dummy NUMBER := 0;

Line 16334: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;

16330: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
16331: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
16332: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
16333: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
16334: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
16335: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
16336: ln_dummy NUMBER := 0;
16337: ln_dummy1 NUMBER := 0;
16338: i NUMBER := 0;

Line 16335: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

16331: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
16332: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
16333: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
16334: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
16335: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
16336: ln_dummy NUMBER := 0;
16337: ln_dummy1 NUMBER := 0;
16338: i NUMBER := 0;
16339: j NUMBER := 0;

Line 17094: p_token1_value => 'OKC_K_ITEMS_V Record');

17090: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17091: OKL_API.set_message(p_app_name => G_APP_NAME,
17092: p_msg_name => G_FETCHING_INFO,
17093: p_token1 => G_REC_NAME_TOKEN,
17094: p_token1_value => 'OKC_K_ITEMS_V Record');
17095: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17096: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17097: OKL_API.set_message(p_app_name => G_APP_NAME,
17098: p_msg_name => G_FETCHING_INFO,

Line 17100: p_token1_value => 'OKC_K_ITEMS_V Record');

17096: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17097: OKL_API.set_message(p_app_name => G_APP_NAME,
17098: p_msg_name => G_FETCHING_INFO,
17099: p_token1 => G_REC_NAME_TOKEN,
17100: p_token1_value => 'OKC_K_ITEMS_V Record');
17101: RAISE OKL_API.G_EXCEPTION_ERROR;
17102: END IF;
17103: --Build Model cimv item rec
17104: l_cimv_model_rec.id := r_cimv_model_rec.id;

Line 17169: p_token1_value => 'OKC_K_ITEMS_V Record');

17165: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17166: OKL_API.set_message(p_app_name => G_APP_NAME,
17167: p_msg_name => G_FETCHING_INFO,
17168: p_token1 => G_REC_NAME_TOKEN,
17169: p_token1_value => 'OKC_K_ITEMS_V Record');
17170: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
17171: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17172: OKL_API.set_message(p_app_name => G_APP_NAME,
17173: p_msg_name => G_FETCHING_INFO,

Line 17175: p_token1_value => 'OKC_K_ITEMS_V Record');

17171: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17172: OKL_API.set_message(p_app_name => G_APP_NAME,
17173: p_msg_name => G_FETCHING_INFO,
17174: p_token1 => G_REC_NAME_TOKEN,
17175: p_token1_value => 'OKC_K_ITEMS_V Record');
17176: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
17177: END IF;
17178:
17179: IF (NVL(r_cimv_addon_rec.number_of_items,0) <>

Line 17449: p_token1_value => 'OKC_K_ITEMS_V Record');

17445: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17446: OKL_API.set_message(p_app_name => G_APP_NAME,
17447: p_msg_name => G_FETCHING_INFO,
17448: p_token1 => G_REC_NAME_TOKEN,
17449: p_token1_value => 'OKC_K_ITEMS_V Record');
17450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17452: OKL_API.set_message(p_app_name => G_APP_NAME,
17453: p_msg_name => G_FETCHING_INFO,

Line 17455: p_token1_value => 'OKC_K_ITEMS_V Record');

17451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17452: OKL_API.set_message(p_app_name => G_APP_NAME,
17453: p_msg_name => G_FETCHING_INFO,
17454: p_token1 => G_REC_NAME_TOKEN,
17455: p_token1_value => 'OKC_K_ITEMS_V Record');
17456: RAISE OKL_API.G_EXCEPTION_ERROR;
17457: END IF;
17458: --Build cimv fa item rec
17459: l_cimv_fa_rec.id := r_cimv_fa_rec.id;

Line 17673: p_token1_value => 'OKC_K_ITEMS_V Record');

17669: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17670: OKL_API.set_message(p_app_name => G_APP_NAME,
17671: p_msg_name => G_FETCHING_INFO,
17672: p_token1 => G_REC_NAME_TOKEN,
17673: p_token1_value => 'OKC_K_ITEMS_V Record');
17674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17675: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17676: OKL_API.set_message(p_app_name => G_APP_NAME,
17677: p_msg_name => G_FETCHING_INFO,

Line 17679: p_token1_value => 'OKC_K_ITEMS_V Record');

17675: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17676: OKL_API.set_message(p_app_name => G_APP_NAME,
17677: p_msg_name => G_FETCHING_INFO,
17678: p_token1 => G_REC_NAME_TOKEN,
17679: p_token1_value => 'OKC_K_ITEMS_V Record');
17680: RAISE OKL_API.G_EXCEPTION_ERROR;
17681: END IF;
17682: --Build cimv ib item rec
17683: l_cimv_ib_rec.id := r_cimv_ib_rec.id;

Line 18066: ln_final_current_units OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE;

18062: lb_record_created BOOLEAN := FALSE;
18063: lb_update_oec_required BOOLEAN := FALSE;
18064: ln_item_id OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
18065: -- end
18066: ln_final_current_units OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE;
18067: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18068: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18069: r_clev_model_rec clev_rec_type;
18070: r_klev_model_rec klev_rec_type;

Line 18086: ln_model_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;

18082: l_clev_model_rec_out clev_rec_type;
18083: l_klev_model_rec_out klev_rec_type;
18084: l_clev_fa_rec_out clev_rec_type;
18085: l_klev_fa_rec_out klev_rec_type;
18086: ln_model_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
18087: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
18088: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
18089: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
18090:

Line 18176: okc_k_items_v cim,

18172: SELECT cim.number_of_items
18173: FROM okc_subclass_top_line stl,
18174: okc_line_styles_b lse2,
18175: okc_line_styles_b lse1,
18176: okc_k_items_v cim,
18177: okc_k_lines_v cle
18178: WHERE cle.cle_id = p_cle_id
18179: AND cle.dnz_chr_id = p_chr_id
18180: AND cle.id = cim.cle_id

Line 18693: p_token1_value => 'OKC_K_ITEMS_V Record');

18689: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18690: OKL_API.set_message(p_app_name => G_APP_NAME,
18691: p_msg_name => G_FETCHING_INFO,
18692: p_token1 => G_REC_NAME_TOKEN,
18693: p_token1_value => 'OKC_K_ITEMS_V Record');
18694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18695: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18696: OKL_API.set_message(p_app_name => G_APP_NAME,
18697: p_msg_name => G_FETCHING_INFO,

Line 18699: p_token1_value => 'OKC_K_ITEMS_V Record');

18695: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18696: OKL_API.set_message(p_app_name => G_APP_NAME,
18697: p_msg_name => G_FETCHING_INFO,
18698: p_token1 => G_REC_NAME_TOKEN,
18699: p_token1_value => 'OKC_K_ITEMS_V Record');
18700: RAISE OKL_API.G_EXCEPTION_ERROR;
18701: END IF;
18702:
18703: --Build Model cimv item rec

Line 18776: p_token1_value => 'OKC_K_ITEMS_V Record');

18772: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18773: OKL_API.set_message(p_app_name => G_APP_NAME,
18774: p_msg_name => G_FETCHING_INFO,
18775: p_token1 => G_REC_NAME_TOKEN,
18776: p_token1_value => 'OKC_K_ITEMS_V Record');
18777: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
18778: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18779: OKL_API.set_message(p_app_name => G_APP_NAME,
18780: p_msg_name => G_FETCHING_INFO,

Line 18782: p_token1_value => 'OKC_K_ITEMS_V Record');

18778: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18779: OKL_API.set_message(p_app_name => G_APP_NAME,
18780: p_msg_name => G_FETCHING_INFO,
18781: p_token1 => G_REC_NAME_TOKEN,
18782: p_token1_value => 'OKC_K_ITEMS_V Record');
18783: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
18784: END IF;
18785: --Build addon cimv item rec
18786: r_cimv_addon_rec.number_of_items := ln_remain_inst;

Line 18926: p_token1_value => 'OKC_K_ITEMS_V Record');

18922: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18923: OKL_API.set_message(p_app_name => G_APP_NAME,
18924: p_msg_name => G_FETCHING_INFO,
18925: p_token1 => G_REC_NAME_TOKEN,
18926: p_token1_value => 'OKC_K_ITEMS_V Record');
18927: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18928: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18929: OKL_API.set_message(p_app_name => G_APP_NAME,
18930: p_msg_name => G_FETCHING_INFO,

Line 18932: p_token1_value => 'OKC_K_ITEMS_V Record');

18928: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18929: OKL_API.set_message(p_app_name => G_APP_NAME,
18930: p_msg_name => G_FETCHING_INFO,
18931: p_token1 => G_REC_NAME_TOKEN,
18932: p_token1_value => 'OKC_K_ITEMS_V Record');
18933: RAISE OKL_API.G_EXCEPTION_ERROR;
18934: END IF;
18935:
18936: --Build cimv fa item rec

Line 19609: p_token1_value => 'OKC_K_ITEMS_V Record');

19605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19606: OKL_API.set_message(p_app_name => G_APP_NAME,
19607: p_msg_name => G_FETCHING_INFO,
19608: p_token1 => G_REC_NAME_TOKEN,
19609: p_token1_value => 'OKC_K_ITEMS_V Record');
19610: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19611: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19612: OKL_API.set_message(p_app_name => G_APP_NAME,
19613: p_msg_name => G_FETCHING_INFO,

Line 19615: p_token1_value => 'OKC_K_ITEMS_V Record');

19611: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19612: OKL_API.set_message(p_app_name => G_APP_NAME,
19613: p_msg_name => G_FETCHING_INFO,
19614: p_token1 => G_REC_NAME_TOKEN,
19615: p_token1_value => 'OKC_K_ITEMS_V Record');
19616: RAISE OKL_API.G_EXCEPTION_ERROR;
19617: END IF;
19618: --Build Model cimv item rec
19619: r_cimv_model_rec.number_of_items := ln_remain_inst;

Line 19690: p_token1_value => 'OKC_K_ITEMS_V Record');

19686: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19687: OKL_API.set_message(p_app_name => G_APP_NAME,
19688: p_msg_name => G_FETCHING_INFO,
19689: p_token1 => G_REC_NAME_TOKEN,
19690: p_token1_value => 'OKC_K_ITEMS_V Record');
19691: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
19692: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19693: OKL_API.set_message(p_app_name => G_APP_NAME,
19694: p_msg_name => G_FETCHING_INFO,

Line 19696: p_token1_value => 'OKC_K_ITEMS_V Record');

19692: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19693: OKL_API.set_message(p_app_name => G_APP_NAME,
19694: p_msg_name => G_FETCHING_INFO,
19695: p_token1 => G_REC_NAME_TOKEN,
19696: p_token1_value => 'OKC_K_ITEMS_V Record');
19697: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
19698: END IF;
19699: --Build addon cimv item rec
19700: r_cimv_addon_rec.number_of_items := ln_remain_inst;

Line 19833: p_token1_value => 'OKC_K_ITEMS_V Record');

19829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19830: OKL_API.set_message(p_app_name => G_APP_NAME,
19831: p_msg_name => G_FETCHING_INFO,
19832: p_token1 => G_REC_NAME_TOKEN,
19833: p_token1_value => 'OKC_K_ITEMS_V Record');
19834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19835: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19836: OKL_API.set_message(p_app_name => G_APP_NAME,
19837: p_msg_name => G_FETCHING_INFO,

Line 19839: p_token1_value => 'OKC_K_ITEMS_V Record');

19835: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19836: OKL_API.set_message(p_app_name => G_APP_NAME,
19837: p_msg_name => G_FETCHING_INFO,
19838: p_token1 => G_REC_NAME_TOKEN,
19839: p_token1_value => 'OKC_K_ITEMS_V Record');
19840: RAISE OKL_API.G_EXCEPTION_ERROR;
19841: END IF;
19842: --Build cimv fa item rec
19843: r_cimv_fa_rec.number_of_items := ln_remain_inst;

Line 20446: p_token1_value => 'OKC_K_ITEMS_V Record');

20442: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20443: OKL_API.set_message(p_app_name => G_APP_NAME,
20444: p_msg_name => G_FETCHING_INFO,
20445: p_token1 => G_REC_NAME_TOKEN,
20446: p_token1_value => 'OKC_K_ITEMS_V Record');
20447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20448: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20449: OKL_API.set_message(p_app_name => G_APP_NAME,
20450: p_msg_name => G_FETCHING_INFO,

Line 20452: p_token1_value => 'OKC_K_ITEMS_V Record');

20448: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20449: OKL_API.set_message(p_app_name => G_APP_NAME,
20450: p_msg_name => G_FETCHING_INFO,
20451: p_token1 => G_REC_NAME_TOKEN,
20452: p_token1_value => 'OKC_K_ITEMS_V Record');
20453: RAISE OKL_API.G_EXCEPTION_ERROR;
20454: END IF;
20455: --Build Model cimv item rec
20456: r_cimv_model_rec.number_of_items := ln_remain_inst;

Line 20527: p_token1_value => 'OKC_K_ITEMS_V Record');

20523: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20524: OKL_API.set_message(p_app_name => G_APP_NAME,
20525: p_msg_name => G_FETCHING_INFO,
20526: p_token1 => G_REC_NAME_TOKEN,
20527: p_token1_value => 'OKC_K_ITEMS_V Record');
20528: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
20529: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20530: OKL_API.set_message(p_app_name => G_APP_NAME,
20531: p_msg_name => G_FETCHING_INFO,

Line 20533: p_token1_value => 'OKC_K_ITEMS_V Record');

20529: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20530: OKL_API.set_message(p_app_name => G_APP_NAME,
20531: p_msg_name => G_FETCHING_INFO,
20532: p_token1 => G_REC_NAME_TOKEN,
20533: p_token1_value => 'OKC_K_ITEMS_V Record');
20534: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
20535: END IF;
20536: --Build addon cimv item rec
20537: r_cimv_addon_rec.number_of_items := ln_remain_inst;

Line 20670: p_token1_value => 'OKC_K_ITEMS_V Record');

20666: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20667: OKL_API.set_message(p_app_name => G_APP_NAME,
20668: p_msg_name => G_FETCHING_INFO,
20669: p_token1 => G_REC_NAME_TOKEN,
20670: p_token1_value => 'OKC_K_ITEMS_V Record');
20671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20672: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20673: OKL_API.set_message(p_app_name => G_APP_NAME,
20674: p_msg_name => G_FETCHING_INFO,

Line 20676: p_token1_value => 'OKC_K_ITEMS_V Record');

20672: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20673: OKL_API.set_message(p_app_name => G_APP_NAME,
20674: p_msg_name => G_FETCHING_INFO,
20675: p_token1 => G_REC_NAME_TOKEN,
20676: p_token1_value => 'OKC_K_ITEMS_V Record');
20677: RAISE OKL_API.G_EXCEPTION_ERROR;
20678: END IF;
20679: --Build cimv fa item rec
20680: r_cimv_fa_rec.number_of_items := ln_remain_inst;