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

Line 230: select 1 from okc_k_items b

226: FROM fa_additions a
227: WHERE a.asset_number = p_asset_number
228: and exists
229: (
230: select 1 from okc_k_items b
231: where b.jtot_object1_code = 'OKX_ASSET'
232: and b.object1_id1 = to_char(a.asset_id)
233: );
234:

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 2873: select 1 from okc_k_items b

2869: FROM fa_additions a
2870: WHERE a.asset_number = p_asset_number
2871: and exists
2872: (
2873: select 1 from okc_k_items b
2874: where b.jtot_object1_code = 'OKX_ASSET'
2875: and b.object1_id1 = to_char(a.asset_id)
2876: );
2877:

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

3485: -- Parameters :
3486: -- Version : 1.0
3487: -- End of Commnets
3488:
3489: FUNCTION check_required_values(p_item1 IN OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
3490: p_item2 IN OKC_K_ITEMS_V.OBJECT1_ID2%TYPE,
3491: p_ast_no IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3492: p_ast_desc IN OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE,
3493: p_cost IN OKL_TXL_ASSETS_B.ORIGINAL_COST%TYPE,

Line 3490: p_item2 IN OKC_K_ITEMS_V.OBJECT1_ID2%TYPE,

3486: -- Version : 1.0
3487: -- End of Commnets
3488:
3489: FUNCTION check_required_values(p_item1 IN OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
3490: p_item2 IN OKC_K_ITEMS_V.OBJECT1_ID2%TYPE,
3491: p_ast_no IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3492: p_ast_desc IN OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE,
3493: p_cost IN OKL_TXL_ASSETS_B.ORIGINAL_COST%TYPE,
3494: p_units IN OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE,

Line 3494: p_units IN OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE,

3490: p_item2 IN OKC_K_ITEMS_V.OBJECT1_ID2%TYPE,
3491: p_ast_no IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3492: p_ast_desc IN OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE,
3493: p_cost IN OKL_TXL_ASSETS_B.ORIGINAL_COST%TYPE,
3494: p_units IN OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE,
3495: p_ib_loc1 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
3496: p_ib_loc2 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE,
3497: p_fa_loc IN OKL_TXL_ASSETS_B.FA_LOCATION_ID%TYPE,
3498: p_refinance_amount IN OKL_K_LINES.REFINANCE_AMOUNT%TYPE,

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

5887: l_trxv_rec trxv_rec_type;
5888: i NUMBER := 0;
5889:
5890: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5891: lv_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
5892: lv_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR;
5893: ln_dummy NUMBER := 0;
5894: lv_dummy VARCHAR2(3);
5895: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;

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

5888: i NUMBER := 0;
5889:
5890: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5891: lv_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
5892: lv_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR;
5893: ln_dummy NUMBER := 0;
5894: lv_dummy VARCHAR2(3);
5895: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;
5896: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%TYPE;

Line 6301: -- i.e., when the OKC_K_ITEMS.OBJECT1_ID1 and OBJECT1_ID2 is null or not null

6297: END IF;
6298: -- x_clev_rec := l_clev_rec;
6299: -- We commented the same out because does not make sense
6300: -- because we are now populating the txl assets in both the cases
6301: -- i.e., when the OKC_K_ITEMS.OBJECT1_ID1 and OBJECT1_ID2 is null or not null
6302: -- IF (x_cimv_rec.object1_id1 IS NULL OR
6303: -- x_cimv_rec.object1_id1 = OKL_API.G_MISS_CHAR) AND
6304: -- (x_cimv_rec.object1_id2 IS NULL OR
6305: -- x_cimv_rec.object1_id2 = OKL_API.G_MISS_CHAR) THEN

Line 6393: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;

6389: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6390: i NUMBER := 0;
6391: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_ITEM';
6392: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;
6393: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;
6394:
6395: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6396: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6397: SELECT cle.display_sequence,

Line 6401: okc_k_items cim,

6397: SELECT cle.display_sequence,
6398: cim.number_of_items
6399: FROM okc_line_styles_b lse2,
6400: okc_line_styles_b lse1,
6401: okc_k_items cim,
6402: okc_k_lines_b cle
6403: WHERE cle.id = p_cle_id
6404: AND cle.dnz_chr_id = p_dnz_chr_id
6405: AND cle.id = cim.cle_id

Line 6602: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;

6598: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6599: i NUMBER;
6600: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_ITEM';
6601: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;
6602: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
6603:
6604: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6605: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6606: SELECT cle.display_sequence,

Line 6610: okc_k_items cim,

6606: SELECT cle.display_sequence,
6607: cim.number_of_items
6608: FROM okc_line_styles_b lse2,
6609: okc_line_styles_b lse1,
6610: okc_k_items cim,
6611: okc_k_lines_b cle
6612: WHERE cle.id = p_cle_id
6613: AND cle.dnz_chr_id = p_dnz_chr_id
6614: AND cle.id = cim.cle_id

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

6701: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
6702: OKL_API.set_message(p_app_name => G_APP_NAME,
6703: p_msg_name => G_FETCHING_INFO,
6704: p_token1 => G_REC_NAME_TOKEN,
6705: p_token1_value => 'OKC_K_ITEMS_V Record');
6706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6707: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6708: OKL_API.set_message(p_app_name => G_APP_NAME,
6709: p_msg_name => G_FETCHING_INFO,

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

6707: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6708: OKL_API.set_message(p_app_name => G_APP_NAME,
6709: p_msg_name => G_FETCHING_INFO,
6710: p_token1 => G_REC_NAME_TOKEN,
6711: p_token1_value => 'OKC_K_ITEMS_V Record');
6712: RAISE OKL_API.G_EXCEPTION_ERROR;
6713: END IF;
6714: IF l_cimv_rec.cle_id <> x_clev_rec.id THEN
6715: OKL_API.set_message(p_app_name => G_APP_NAME,

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

7823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7824: OKL_API.set_message(p_app_name => G_APP_NAME,
7825: p_msg_name => G_FETCHING_INFO,
7826: p_token1 => G_REC_NAME_TOKEN,
7827: p_token1_value => 'OKC_K_ITEMS_V Record');
7828: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7829: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7830: OKL_API.set_message(p_app_name => G_APP_NAME,
7831: p_msg_name => G_FETCHING_INFO,

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

7829: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7830: OKL_API.set_message(p_app_name => G_APP_NAME,
7831: p_msg_name => G_FETCHING_INFO,
7832: p_token1 => G_REC_NAME_TOKEN,
7833: p_token1_value => 'OKC_K_ITEMS_V Record');
7834: RAISE OKL_API.G_EXCEPTION_ERROR;
7835: END IF;
7836: -- Creating iti record
7837: l_itiv_rec.inventory_item_id := to_number(r_cimv_rec.object1_id1);

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

7903: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7904: OKL_API.set_message(p_app_name => G_APP_NAME,
7905: p_msg_name => G_FETCHING_INFO,
7906: p_token1 => G_REC_NAME_TOKEN,
7907: p_token1_value => 'OKC_K_ITEMS_V Record');
7908: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7909: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7910: OKL_API.set_message(p_app_name => G_APP_NAME,
7911: p_msg_name => G_FETCHING_INFO,

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

7909: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7910: OKL_API.set_message(p_app_name => G_APP_NAME,
7911: p_msg_name => G_FETCHING_INFO,
7912: p_token1 => G_REC_NAME_TOKEN,
7913: p_token1_value => 'OKC_K_ITEMS_V Record');
7914: RAISE OKL_API.G_EXCEPTION_ERROR;
7915: END IF;
7916: -- Creating iti record
7917: l_itiv_rec.inventory_item_id := to_number(r_cimv_rec.object1_id1);

Line 8862: okc_k_items_v cim,

8858: SELECT cle.cle_id
8859: FROM okc_subclass_top_line stl,
8860: okc_line_styles_b lse2,
8861: okc_line_styles_b lse1,
8862: okc_k_items_v cim,
8863: okc_k_lines_v cle
8864: WHERE cle.id = p_model_line_id
8865: AND cle.dnz_chr_id = p_dnz_chr_id
8866: AND cle.id = cim.cle_id

Line 9068: okc_k_items_v cim,

9064: SELECT cle.cle_id
9065: FROM okc_subclass_top_line stl,
9066: okc_line_styles_b lse2,
9067: okc_line_styles_b lse1,
9068: okc_k_items_v cim,
9069: okc_k_lines_v cle
9070: WHERE cle.id = p_model_line_id
9071: AND cle.dnz_chr_id = p_dnz_chr_id
9072: AND cle.id = cim.cle_id

Line 9273: okc_k_items_v cim,

9269: SELECT cle.cle_id
9270: FROM okc_subclass_top_line stl,
9271: okc_line_styles_b lse2,
9272: okc_line_styles_b lse1,
9273: okc_k_items_v cim,
9274: okc_k_lines_v cle
9275: WHERE cle.id = p_model_line_id
9276: AND cle.dnz_chr_id = p_dnz_chr_id
9277: AND cle.id = cim.cle_id

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

9596: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9597: l_update_clev_rec clev_rec_type;
9598: l_update_klev_rec klev_rec_type;
9599: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
9600: l_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
9601:
9602: BEGIN
9603: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9604: -- Call start_activity to create savepoint, check compatibility

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

11903: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11904: OKL_API.set_message(p_app_name => G_APP_NAME,
11905: p_msg_name => G_FETCHING_INFO,
11906: p_token1 => G_REC_NAME_TOKEN,
11907: p_token1_value => 'OKC_K_ITEMS_V Record');
11908: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11909: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11910: OKL_API.set_message(p_app_name => G_APP_NAME,
11911: p_msg_name => G_FETCHING_INFO,

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

11909: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11910: OKL_API.set_message(p_app_name => G_APP_NAME,
11911: p_msg_name => G_FETCHING_INFO,
11912: p_token1 => G_REC_NAME_TOKEN,
11913: p_token1_value => 'OKC_K_ITEMS_V Record');
11914: RAISE OKL_API.G_EXCEPTION_ERROR;
11915: END IF;
11916: x_return_status := get_rec_klev(p_id => l_cplv_rec.cle_id,
11917: x_klev_rec => l_klev_rec);

Line 12456: OKC_K_ITEMS cim_orig

12452: asr.legal_entity_id
12453: FROM OKL_ASSET_RETURNS_B asr,
12454: OKC_K_LINES_B cle_orig,
12455: OKC_LINE_STYLES_B lse_orig,
12456: OKC_K_ITEMS cim_orig
12457: WHERE asr.kle_id = cle_orig.cle_id
12458: AND asr.ars_code = 'RE_LEASE'
12459: AND cim_orig.object1_id1 = p_asset_id
12460: AND cim_orig.object1_id2 = '#'

Line 12531: from okc_k_items model_cim,

12527: CURSOR l_modelline_csr(p_cle_id in number,
12528: p_chr_id in number) IS
12529: select model_cleb.id model_cle_id,
12530: model_cim.id model_cim_id
12531: from okc_k_items model_cim,
12532: okc_k_lines_b model_cleb,
12533: okc_line_styles_b model_lseb
12534: where model_cim.cle_id = model_cleb.id
12535: and model_cim.dnz_chr_id = model_cleb.dnz_chr_id

Line 12615: from okc_k_items

12611: --cursor to get item sources for fa and ib lines
12612: CURSOR l_orig_cim_csr(p_orig_cle_id in number) IS
12613: SELECT object1_id1,
12614: object1_id2
12615: from okc_k_items
12616: WHERE cle_id = p_orig_cle_id;
12617:
12618: l_orig_cim_rec l_orig_cim_csr%ROWTYPE;
12619:

Line 12623: from okc_k_items

12619:
12620: --cursor to get corresponding cim record fro fa and ib lines
12621: CURSOR l_cim_csr (p_cle_id in number, p_chr_id in number) IS
12622: SELECT id
12623: from okc_k_items
12624: WHERE cle_id = p_cle_id
12625: And dnz_chr_id = p_chr_id;
12626:
12627: l_cim_id OKC_K_ITEMS.ID%TYPE;

Line 12627: l_cim_id OKC_K_ITEMS.ID%TYPE;

12623: from okc_k_items
12624: WHERE cle_id = p_cle_id
12625: And dnz_chr_id = p_chr_id;
12626:
12627: l_cim_id OKC_K_ITEMS.ID%TYPE;
12628: l_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12629: lx_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12630:
12631:

Line 13577: FROM okc_k_items cim,

13573: --cursor to get any covered asset lines where old line was referenced
13574: CURSOR l_lnk_ast_csr (p_orig_cle_id in NUMBER,
13575: p_chr_id in NUMBER) is
13576: SELECT cim.id
13577: FROM okc_k_items cim,
13578: okc_k_lines_b cleb,
13579: okc_line_styles_b lseb
13580: WHERE cim.object1_id1 = to_char(p_orig_cle_id)
13581: AND cim.object1_id2 = '#'

Line 13590: l_cim_id OKC_K_ITEMS.ID%TYPE;

13586: AND cleb.chr_id is NULL
13587: AND cleb.lse_id = lseb.id
13588: AND lseb.lty_code in ('LINK_SERV_ASSET','LINK_FEE_ASSET','LINK_USAGE_ASSET');
13589:
13590: l_cim_id OKC_K_ITEMS.ID%TYPE;
13591: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13592: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13593:
13594: --cursor to get information about SLH/SLL to sync back

Line 13924: from okc_k_items fa_cim,

13920: cursor l_cim_fa_csr(p_fin_asst_id in number) is
13921: select
13922: fa_cim.object1_id1 asset_id,
13923: fa_cim.dnz_chr_id chr_id
13924: from okc_k_items fa_cim,
13925: okc_k_lines_b fa_cleb,
13926: okc_line_styles_b fa_lseb
13927: where fa_cim.cle_id = fa_cleb.id
13928: and fa_cim.dnz_chr_id = fa_cleb.dnz_chr_id

Line 13933: l_asset_id okc_k_items.OBJECT1_ID1%TYPE;

13929: and fa_cleb.cle_id = p_fin_asst_id
13930: and fa_cleb.lse_id = fa_lseb.id
13931: and fa_lseb.lty_code = 'FIXED_ASSET';
13932:
13933: l_asset_id okc_k_items.OBJECT1_ID1%TYPE;
13934: l_chr_id okc_k_items.DNZ_CHR_ID%TYPE;
13935:
13936: --cursor to fetch all the lines
13937: CURSOR l_lines_csr(p_from_cle_id in number) IS

Line 13934: l_chr_id okc_k_items.DNZ_CHR_ID%TYPE;

13930: and fa_cleb.lse_id = fa_lseb.id
13931: and fa_lseb.lty_code = 'FIXED_ASSET';
13932:
13933: l_asset_id okc_k_items.OBJECT1_ID1%TYPE;
13934: l_chr_id okc_k_items.DNZ_CHR_ID%TYPE;
13935:
13936: --cursor to fetch all the lines
13937: CURSOR l_lines_csr(p_from_cle_id in number) IS
13938: SELECT level,

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

14785: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
14786: OKL_API.set_message(p_app_name => G_APP_NAME,
14787: p_msg_name => G_FETCHING_INFO,
14788: p_token1 => G_REC_NAME_TOKEN,
14789: p_token1_value => 'OKC_K_ITEMS_V Record');
14790: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
14791: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14792: OKL_API.set_message(p_app_name => G_APP_NAME,
14793: p_msg_name => G_FETCHING_INFO,

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

14791: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14792: OKL_API.set_message(p_app_name => G_APP_NAME,
14793: p_msg_name => G_FETCHING_INFO,
14794: p_token1 => G_REC_NAME_TOKEN,
14795: p_token1_value => 'OKC_K_ITEMS_V Record');
14796: RAISE OKL_API.G_EXCEPTION_ERROR;
14797: END IF;
14798:
14799: l_cimv_model_rec.object1_id1 := p_cimv_model_rec.object1_id1;

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

15090: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
15091: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
15092: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
15093: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
15094: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
15095: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
15096: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
15097: ln_dummy NUMBER := 0;
15098: ln_dummy1 NUMBER := 0;

Line 15131: OKC_LINE_STYLES_B LSE_IL, OKC_K_LINES_B KLE_IB, OKC_LINE_STYLES_B LSE_IB, OKC_K_ITEMS ITE,

15127: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,
15128: CII.INSTANCE_ID
15129: FROM
15130: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,
15131: OKC_LINE_STYLES_B LSE_IL, OKC_K_LINES_B KLE_IB, OKC_LINE_STYLES_B LSE_IB, OKC_K_ITEMS ITE,
15132: CSI_ITEM_INSTANCES CII
15133: WHERE
15134: kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id AND lse_fa.lty_code = 'FREE_FORM1'
15135: AND kle_il.cle_id = kle_fa.id AND lse_il.id = kle_il.lse_id AND lse_il.lty_code = 'FREE_FORM2'

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

16190: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
16191: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
16192: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
16193: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
16194: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
16195: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
16196: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
16197: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
16198: ln_dummy NUMBER := 0;

Line 16196: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;

16192: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
16193: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
16194: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
16195: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
16196: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
16197: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
16198: ln_dummy NUMBER := 0;
16199: ln_dummy1 NUMBER := 0;
16200: i NUMBER := 0;

Line 16197: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

16193: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
16194: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
16195: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
16196: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
16197: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
16198: ln_dummy NUMBER := 0;
16199: ln_dummy1 NUMBER := 0;
16200: i NUMBER := 0;
16201: j NUMBER := 0;

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

16895: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
16896: OKL_API.set_message(p_app_name => G_APP_NAME,
16897: p_msg_name => G_FETCHING_INFO,
16898: p_token1 => G_REC_NAME_TOKEN,
16899: p_token1_value => 'OKC_K_ITEMS_V Record');
16900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
16901: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16902: OKL_API.set_message(p_app_name => G_APP_NAME,
16903: p_msg_name => G_FETCHING_INFO,

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

16901: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16902: OKL_API.set_message(p_app_name => G_APP_NAME,
16903: p_msg_name => G_FETCHING_INFO,
16904: p_token1 => G_REC_NAME_TOKEN,
16905: p_token1_value => 'OKC_K_ITEMS_V Record');
16906: RAISE OKL_API.G_EXCEPTION_ERROR;
16907: END IF;
16908: --Build Model cimv item rec
16909: l_cimv_model_rec.id := r_cimv_model_rec.id;

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

16970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
16971: OKL_API.set_message(p_app_name => G_APP_NAME,
16972: p_msg_name => G_FETCHING_INFO,
16973: p_token1 => G_REC_NAME_TOKEN,
16974: p_token1_value => 'OKC_K_ITEMS_V Record');
16975: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
16976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16977: OKL_API.set_message(p_app_name => G_APP_NAME,
16978: p_msg_name => G_FETCHING_INFO,

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

16976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16977: OKL_API.set_message(p_app_name => G_APP_NAME,
16978: p_msg_name => G_FETCHING_INFO,
16979: p_token1 => G_REC_NAME_TOKEN,
16980: p_token1_value => 'OKC_K_ITEMS_V Record');
16981: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
16982: END IF;
16983:
16984: IF (NVL(r_cimv_addon_rec.number_of_items,0) <>

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

17250: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17251: OKL_API.set_message(p_app_name => G_APP_NAME,
17252: p_msg_name => G_FETCHING_INFO,
17253: p_token1 => G_REC_NAME_TOKEN,
17254: p_token1_value => 'OKC_K_ITEMS_V Record');
17255: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17256: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17257: OKL_API.set_message(p_app_name => G_APP_NAME,
17258: p_msg_name => G_FETCHING_INFO,

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

17256: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17257: OKL_API.set_message(p_app_name => G_APP_NAME,
17258: p_msg_name => G_FETCHING_INFO,
17259: p_token1 => G_REC_NAME_TOKEN,
17260: p_token1_value => 'OKC_K_ITEMS_V Record');
17261: RAISE OKL_API.G_EXCEPTION_ERROR;
17262: END IF;
17263: --Build cimv fa item rec
17264: l_cimv_fa_rec.id := r_cimv_fa_rec.id;

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

17462: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17463: OKL_API.set_message(p_app_name => G_APP_NAME,
17464: p_msg_name => G_FETCHING_INFO,
17465: p_token1 => G_REC_NAME_TOKEN,
17466: p_token1_value => 'OKC_K_ITEMS_V Record');
17467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17468: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17469: OKL_API.set_message(p_app_name => G_APP_NAME,
17470: p_msg_name => G_FETCHING_INFO,

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

17468: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17469: OKL_API.set_message(p_app_name => G_APP_NAME,
17470: p_msg_name => G_FETCHING_INFO,
17471: p_token1 => G_REC_NAME_TOKEN,
17472: p_token1_value => 'OKC_K_ITEMS_V Record');
17473: RAISE OKL_API.G_EXCEPTION_ERROR;
17474: END IF;
17475: --Build cimv ib item rec
17476: l_cimv_ib_rec.id := r_cimv_ib_rec.id;

Line 17859: ln_final_current_units OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE;

17855: lb_record_created BOOLEAN := FALSE;
17856: lb_update_oec_required BOOLEAN := FALSE;
17857: ln_item_id OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
17858: -- end
17859: ln_final_current_units OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE;
17860: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
17861: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
17862: r_clev_model_rec clev_rec_type;
17863: r_klev_model_rec klev_rec_type;

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

17875: l_clev_model_rec_out clev_rec_type;
17876: l_klev_model_rec_out klev_rec_type;
17877: l_clev_fa_rec_out clev_rec_type;
17878: l_klev_fa_rec_out klev_rec_type;
17879: ln_model_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
17880: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
17881: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
17882: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
17883:

Line 17969: okc_k_items_v cim,

17965: SELECT cim.number_of_items
17966: FROM okc_subclass_top_line stl,
17967: okc_line_styles_b lse2,
17968: okc_line_styles_b lse1,
17969: okc_k_items_v cim,
17970: okc_k_lines_v cle
17971: WHERE cle.cle_id = p_cle_id
17972: AND cle.dnz_chr_id = p_chr_id
17973: AND cle.id = cim.cle_id

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

18458: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18459: OKL_API.set_message(p_app_name => G_APP_NAME,
18460: p_msg_name => G_FETCHING_INFO,
18461: p_token1 => G_REC_NAME_TOKEN,
18462: p_token1_value => 'OKC_K_ITEMS_V Record');
18463: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18464: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18465: OKL_API.set_message(p_app_name => G_APP_NAME,
18466: p_msg_name => G_FETCHING_INFO,

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

18464: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18465: OKL_API.set_message(p_app_name => G_APP_NAME,
18466: p_msg_name => G_FETCHING_INFO,
18467: p_token1 => G_REC_NAME_TOKEN,
18468: p_token1_value => 'OKC_K_ITEMS_V Record');
18469: RAISE OKL_API.G_EXCEPTION_ERROR;
18470: END IF;
18471:
18472: --Build Model cimv item rec

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

18541: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18542: OKL_API.set_message(p_app_name => G_APP_NAME,
18543: p_msg_name => G_FETCHING_INFO,
18544: p_token1 => G_REC_NAME_TOKEN,
18545: p_token1_value => 'OKC_K_ITEMS_V Record');
18546: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
18547: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18548: OKL_API.set_message(p_app_name => G_APP_NAME,
18549: p_msg_name => G_FETCHING_INFO,

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

18547: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18548: OKL_API.set_message(p_app_name => G_APP_NAME,
18549: p_msg_name => G_FETCHING_INFO,
18550: p_token1 => G_REC_NAME_TOKEN,
18551: p_token1_value => 'OKC_K_ITEMS_V Record');
18552: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
18553: END IF;
18554: --Build addon cimv item rec
18555: r_cimv_addon_rec.number_of_items := ln_remain_inst;

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

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

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

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

Line 18942: okc_k_items cim,

18938: SELECT cim.object1_id1
18939: FROM okc_subclass_top_line stl,
18940: okc_line_styles_b lse2,
18941: okc_line_styles_b lse1,
18942: okc_k_items cim,
18943: okc_k_lines_v cle
18944: WHERE cle.cle_id = p_cle_id
18945: AND cle.dnz_chr_id = p_chr_id
18946: AND cle.lse_id = lse1.id

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

19350: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19351: OKL_API.set_message(p_app_name => G_APP_NAME,
19352: p_msg_name => G_FETCHING_INFO,
19353: p_token1 => G_REC_NAME_TOKEN,
19354: p_token1_value => 'OKC_K_ITEMS_V Record');
19355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19357: OKL_API.set_message(p_app_name => G_APP_NAME,
19358: p_msg_name => G_FETCHING_INFO,

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

19356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19357: OKL_API.set_message(p_app_name => G_APP_NAME,
19358: p_msg_name => G_FETCHING_INFO,
19359: p_token1 => G_REC_NAME_TOKEN,
19360: p_token1_value => 'OKC_K_ITEMS_V Record');
19361: RAISE OKL_API.G_EXCEPTION_ERROR;
19362: END IF;
19363: --Build Model cimv item rec
19364: r_cimv_model_rec.number_of_items := ln_remain_inst;

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

19431: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19432: OKL_API.set_message(p_app_name => G_APP_NAME,
19433: p_msg_name => G_FETCHING_INFO,
19434: p_token1 => G_REC_NAME_TOKEN,
19435: p_token1_value => 'OKC_K_ITEMS_V Record');
19436: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
19437: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19438: OKL_API.set_message(p_app_name => G_APP_NAME,
19439: p_msg_name => G_FETCHING_INFO,

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

19437: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19438: OKL_API.set_message(p_app_name => G_APP_NAME,
19439: p_msg_name => G_FETCHING_INFO,
19440: p_token1 => G_REC_NAME_TOKEN,
19441: p_token1_value => 'OKC_K_ITEMS_V Record');
19442: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
19443: END IF;
19444: --Build addon cimv item rec
19445: r_cimv_addon_rec.number_of_items := ln_remain_inst;

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

19574: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19575: OKL_API.set_message(p_app_name => G_APP_NAME,
19576: p_msg_name => G_FETCHING_INFO,
19577: p_token1 => G_REC_NAME_TOKEN,
19578: p_token1_value => 'OKC_K_ITEMS_V Record');
19579: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19580: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19581: OKL_API.set_message(p_app_name => G_APP_NAME,
19582: p_msg_name => G_FETCHING_INFO,

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

19580: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19581: OKL_API.set_message(p_app_name => G_APP_NAME,
19582: p_msg_name => G_FETCHING_INFO,
19583: p_token1 => G_REC_NAME_TOKEN,
19584: p_token1_value => 'OKC_K_ITEMS_V Record');
19585: RAISE OKL_API.G_EXCEPTION_ERROR;
19586: END IF;
19587: --Build cimv fa item rec
19588: r_cimv_fa_rec.number_of_items := ln_remain_inst;

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

20161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20162: OKL_API.set_message(p_app_name => G_APP_NAME,
20163: p_msg_name => G_FETCHING_INFO,
20164: p_token1 => G_REC_NAME_TOKEN,
20165: p_token1_value => 'OKC_K_ITEMS_V Record');
20166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20167: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20168: OKL_API.set_message(p_app_name => G_APP_NAME,
20169: p_msg_name => G_FETCHING_INFO,

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

20167: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20168: OKL_API.set_message(p_app_name => G_APP_NAME,
20169: p_msg_name => G_FETCHING_INFO,
20170: p_token1 => G_REC_NAME_TOKEN,
20171: p_token1_value => 'OKC_K_ITEMS_V Record');
20172: RAISE OKL_API.G_EXCEPTION_ERROR;
20173: END IF;
20174: --Build Model cimv item rec
20175: r_cimv_model_rec.number_of_items := ln_remain_inst;

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

20242: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20243: OKL_API.set_message(p_app_name => G_APP_NAME,
20244: p_msg_name => G_FETCHING_INFO,
20245: p_token1 => G_REC_NAME_TOKEN,
20246: p_token1_value => 'OKC_K_ITEMS_V Record');
20247: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
20248: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20249: OKL_API.set_message(p_app_name => G_APP_NAME,
20250: p_msg_name => G_FETCHING_INFO,

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

20248: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20249: OKL_API.set_message(p_app_name => G_APP_NAME,
20250: p_msg_name => G_FETCHING_INFO,
20251: p_token1 => G_REC_NAME_TOKEN,
20252: p_token1_value => 'OKC_K_ITEMS_V Record');
20253: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
20254: END IF;
20255: --Build addon cimv item rec
20256: r_cimv_addon_rec.number_of_items := ln_remain_inst;

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

20385: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20386: OKL_API.set_message(p_app_name => G_APP_NAME,
20387: p_msg_name => G_FETCHING_INFO,
20388: p_token1 => G_REC_NAME_TOKEN,
20389: p_token1_value => 'OKC_K_ITEMS_V Record');
20390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20391: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20392: OKL_API.set_message(p_app_name => G_APP_NAME,
20393: p_msg_name => G_FETCHING_INFO,

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

20391: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20392: OKL_API.set_message(p_app_name => G_APP_NAME,
20393: p_msg_name => G_FETCHING_INFO,
20394: p_token1 => G_REC_NAME_TOKEN,
20395: p_token1_value => 'OKC_K_ITEMS_V Record');
20396: RAISE OKL_API.G_EXCEPTION_ERROR;
20397: END IF;
20398: --Build cimv fa item rec
20399: r_cimv_fa_rec.number_of_items := ln_remain_inst;