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_COPY_ASSET_PVT dependencies on OKC_K_ITEMS

Line 101: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR,

97: TYPE g_ib_id_tbl IS TABLE OF g_ib_id_rec
98: INDEX BY BINARY_INTEGER;
99:
100: TYPE g_ib_item_type IS RECORD (
101: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR,
102: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR);
103:
104: TYPE g_ib_item_tbl IS TABLE OF g_ib_item_type
105: INDEX BY BINARY_INTEGER;

Line 102: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR);

98: INDEX BY BINARY_INTEGER;
99:
100: TYPE g_ib_item_type IS RECORD (
101: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR,
102: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR);
103:
104: TYPE g_ib_item_tbl IS TABLE OF g_ib_item_type
105: INDEX BY BINARY_INTEGER;
106: -----------------------------------------------------------------------------------------------------------

Line 494: -- Description : validation with OKC_K_ITEMS_V

490: -------------------------------------------------------------------------------------------------
491: -- Start of Commnets
492: -- Badrinath Kuchibholta
493: -- Procedure Name : validate_items_ids
494: -- Description : validation with OKC_K_ITEMS_V
495: -- Business Rules : If the id1 and id2 are populated in okc_k_items_v
496: -- we need to get current info from FA and
497: -- populate the txl_assets table
498: -- if id1 and id2 are null then we there is already info

Line 495: -- Business Rules : If the id1 and id2 are populated in okc_k_items_v

491: -- Start of Commnets
492: -- Badrinath Kuchibholta
493: -- Procedure Name : validate_items_ids
494: -- Description : validation with OKC_K_ITEMS_V
495: -- Business Rules : If the id1 and id2 are populated in okc_k_items_v
496: -- we need to get current info from FA and
497: -- populate the txl_assets table
498: -- if id1 and id2 are null then we there is already info
499: -- in txl_assets tables and now we copy that info and

Line 509: x_object1_id1 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

505: -- Version : 1.0
506: -- End of Commnets
507: FUNCTION validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
508: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
509: x_object1_id1 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
511: RETURN VARCHAR2 IS
512: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
513: CURSOR c_validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

Line 510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)

506: -- End of Commnets
507: FUNCTION validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
508: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
509: x_object1_id1 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
511: RETURN VARCHAR2 IS
512: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
513: CURSOR c_validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
514: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 518: FROM okc_k_items_v cim

514: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
515: IS
516: SELECT object1_id1,
517: object1_id2
518: FROM okc_k_items_v cim
519: WHERE cim.cle_id = p_cle_id
520: AND cim.dnz_chr_id = p_dnz_chr_id
521: AND cim.object1_id1 IS NOT NULL
522: AND cim.object1_id2 IS NOT NULL;

Line 1782: -- FUNCTION get_rec for: OKC_K_ITEMS_V

1778: END IF;
1779: RETURN(x_return_status);
1780: END get_try_id;
1781: --4-------------------------------------------------------------------------
1782: -- FUNCTION get_rec for: OKC_K_ITEMS_V
1783: ---------------------------------------------------------------------------
1784: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)

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

1780: END get_try_id;
1781: --4-------------------------------------------------------------------------
1782: -- FUNCTION get_rec for: OKC_K_ITEMS_V
1783: ---------------------------------------------------------------------------
1784: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)
1787: RETURN VARCHAR2 IS
1788: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

Line 1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,

1781: --4-------------------------------------------------------------------------
1782: -- FUNCTION get_rec for: OKC_K_ITEMS_V
1783: ---------------------------------------------------------------------------
1784: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)
1787: RETURN VARCHAR2 IS
1788: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1789: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

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

1784: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)
1787: RETURN VARCHAR2 IS
1788: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1789: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
1790: SELECT CIM.ID,
1791: CIM.OBJECT_VERSION_NUMBER,
1792: CIM.CLE_ID,

Line 1789: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)
1787: RETURN VARCHAR2 IS
1788: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1789: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
1790: SELECT CIM.ID,
1791: CIM.OBJECT_VERSION_NUMBER,
1792: CIM.CLE_ID,
1793: CIM.CHR_ID,

Line 1810: FROM okc_k_items_v cim

1806: CIM.CREATION_DATE,
1807: CIM.LAST_UPDATED_BY,
1808: CIM.LAST_UPDATE_DATE,
1809: CIM.LAST_UPDATE_LOGIN
1810: FROM okc_k_items_v cim
1811: WHERE cim.dnz_chr_id = p_dnz_chr_id
1812: AND cim.cle_id = p_cle_id;
1813: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
1814: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 3068: From okc_k_items mdl_cim,

3064: mdl_cle.price_unit unit_price,
3065: mdl_cim.number_of_items units,
3066: fin_kle.oec oec,
3067: fa_kle.year_built Year_of_Manufacture
3068: From okc_k_items mdl_cim,
3069: okc_k_lines_b mdl_cle,
3070: okc_line_styles_b mdl_lse,
3071: okl_k_lines fin_kle,
3072: okc_k_lines_tl fin_tl,

Line 3910: from okc_k_items cim_model,

3906: cursor l_cleb_csr (p_cle_id in number) is
3907: select kle_fin.item_insurance_category,
3908: cim_model.object1_id1,
3909: cim_model.object1_id2
3910: from okc_k_items cim_model,
3911: okc_k_lines_b cleb_model,
3912: okc_line_styles_b lseb_model,
3913: okl_k_lines kle_fin
3914: where cim_model.cle_id = cleb_model.id

Line 4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;

4096: lx_fa_klev_rec klev_rec_type;
4097:
4098: ln_txd_line_number NUMBER := 0;
4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;
4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4104: lt_ib_id_tbl g_ib_id_tbl;

Line 4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

4097:
4098: ln_txd_line_number NUMBER := 0;
4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;
4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4104: lt_ib_id_tbl g_ib_id_tbl;
4105: lt_new_ib_id_tbl g_ib_id_tbl;

Line 4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;

4098: ln_txd_line_number NUMBER := 0;
4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;
4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4104: lt_ib_id_tbl g_ib_id_tbl;
4105: lt_new_ib_id_tbl g_ib_id_tbl;
4106: lt_ib_item_tbl g_ib_item_tbl;

Line 4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;
4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4104: lt_ib_id_tbl g_ib_id_tbl;
4105: lt_new_ib_id_tbl g_ib_id_tbl;
4106: lt_ib_item_tbl g_ib_item_tbl;
4107: l_cimv_rec cimv_rec_type;

Line 4147: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

4143: WHERE EXISTS (SELECT '1'
4144: FROM OKL_TXL_ITM_INSTS_V
4145: WHERE kle_id = p_ib_kle_id);
4146:
4147: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4148: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
4149: SELECT *
4150: FROM OKX_ASSETS_V
4151: WHERE id1 = p_object1_id1

Line 4148: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS

4144: FROM OKL_TXL_ITM_INSTS_V
4145: WHERE kle_id = p_ib_kle_id);
4146:
4147: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4148: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
4149: SELECT *
4150: FROM OKX_ASSETS_V
4151: WHERE id1 = p_object1_id1
4152: AND id2 = p_object1_id2;

Line 4168: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

4164: FROM OKX_AST_BKS_V
4165: WHERE id1 = p_object1_id1
4166: AND book_class = 'TAX';
4167:
4168: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4169: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
4170: SELECT *
4171: FROM OKX_INSTALL_ITEMS_V
4172: WHERE id1 = p_object1_id1

Line 4169: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS

4165: WHERE id1 = p_object1_id1
4166: AND book_class = 'TAX';
4167:
4168: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4169: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
4170: SELECT *
4171: FROM OKX_INSTALL_ITEMS_V
4172: WHERE id1 = p_object1_id1
4173: AND id2 = p_object1_id2;

Line 4216: OKC_K_ITEMS_V cim,

4212: IS
4213: SELECT cim.object1_id1,
4214: cim.object1_id2
4215: FROM OKC_LINE_STYLES_V lse,
4216: OKC_K_ITEMS_V cim,
4217: OKC_K_LINES_V cle
4218: WHERE cle.dnz_chr_id = p_dnz_chr_id
4219: AND cle.cle_id = p_cle_id
4220: AND cle.id = cim.cle_id

Line 4874: -- we have to null out the object1_id1 and object1_id2 in okc_k_items

4870: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4871: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4872: RAISE OKL_API.G_EXCEPTION_ERROR;
4873: END IF;
4874: -- we have to null out the object1_id1 and object1_id2 in okc_k_items
4875: -- since the copy lines are for a new contract
4876: x_return_status := get_rec_cimv(lx_txlv_rec.kle_id,
4877: p_to_chr_id,
4878: l_cimv_rec);

Line 4883: p_token1_value => 'OKC_K_ITEMS_V record');

4879: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4880: OKL_API.set_message(p_app_name => G_APP_NAME,
4881: p_msg_name => G_NO_MATCHING_RECORD,
4882: p_token1 => G_COL_NAME_TOKEN,
4883: p_token1_value => 'OKC_K_ITEMS_V record');
4884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4885: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4886: OKL_API.set_message(p_app_name => G_APP_NAME,
4887: p_msg_name => G_NO_MATCHING_RECORD,

Line 4889: p_token1_value => 'OKC_K_ITEMS_V record');

4885: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4886: OKL_API.set_message(p_app_name => G_APP_NAME,
4887: p_msg_name => G_NO_MATCHING_RECORD,
4888: p_token1 => G_COL_NAME_TOKEN,
4889: p_token1_value => 'OKC_K_ITEMS_V record');
4890: RAISE OKL_API.G_EXCEPTION_ERROR;
4891: END IF;
4892: IF l_cimv_rec.cle_id <> lx_txlv_rec.kle_id THEN
4893: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 4896: p_token1_value => 'OKC_K_ITEMS_V.CLE_ID');

4892: IF l_cimv_rec.cle_id <> lx_txlv_rec.kle_id THEN
4893: OKL_API.set_message(p_app_name => G_APP_NAME,
4894: p_msg_name => G_NO_MATCHING_RECORD,
4895: p_token1 => G_COL_NAME_TOKEN,
4896: p_token1_value => 'OKC_K_ITEMS_V.CLE_ID');
4897: RAISE OKL_API.G_EXCEPTION_ERROR;
4898: END IF;
4899: IF l_cimv_rec.dnz_chr_id <> p_to_chr_id THEN
4900: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 4903: p_token1_value => 'OKC_K_ITEMS_V.DNZ_CHR_ID');

4899: IF l_cimv_rec.dnz_chr_id <> p_to_chr_id THEN
4900: OKL_API.set_message(p_app_name => G_APP_NAME,
4901: p_msg_name => G_NO_MATCHING_RECORD,
4902: p_token1 => G_COL_NAME_TOKEN,
4903: p_token1_value => 'OKC_K_ITEMS_V.DNZ_CHR_ID');
4904: RAISE OKL_API.G_EXCEPTION_ERROR;
4905: END IF;
4906: l_cimv_rec.object1_id1 := null;
4907: l_cimv_rec.object1_id2 := null;

Line 5203: -- we have to null out the object1_id1 and object1_id2 in okc_k_items

5199: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5200: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
5201: END IF;
5202:
5203: -- we have to null out the object1_id1 and object1_id2 in okc_k_items
5204: -- since the copy lines are for a new contract
5205: x_return_status := get_rec_cimv(lx_itiv_rec.kle_id,
5206: p_to_chr_id,
5207: l_cimv_rec);

Line 5212: p_token1_value => 'OKC_K_ITEMS_V record');

5208: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5209: OKL_API.set_message(p_app_name => G_APP_NAME,
5210: p_msg_name => G_NO_MATCHING_RECORD,
5211: p_token1 => G_COL_NAME_TOKEN,
5212: p_token1_value => 'OKC_K_ITEMS_V record');
5213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5214: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5215: OKL_API.set_message(p_app_name => G_APP_NAME,
5216: p_msg_name => G_NO_MATCHING_RECORD,

Line 5218: p_token1_value => 'OKC_K_ITEMS_V record');

5214: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5215: OKL_API.set_message(p_app_name => G_APP_NAME,
5216: p_msg_name => G_NO_MATCHING_RECORD,
5217: p_token1 => G_COL_NAME_TOKEN,
5218: p_token1_value => 'OKC_K_ITEMS_V record');
5219: RAISE OKL_API.G_EXCEPTION_ERROR;
5220: END IF;
5221: IF l_cimv_rec.cle_id <> lx_itiv_rec.kle_id THEN
5222: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 5594: OKC_K_ITEMS orig_lnk_cim

5590: CURSOR l_orig_ast_csr(p_orig_lnk_cle_id IN NUMBER,
5591: p_new_chr_id IN NUMBER) IS
5592: SELECT new_cle.id
5593: FROM OKC_K_LINES_B new_cle,
5594: OKC_K_ITEMS orig_lnk_cim
5595: WHERE
5596: --Bug# 2998115 :
5597: --Bug# 3868709 : Query fixed for Performance issue
5598: ((new_cle.ORIG_SYSTEM_ID1 = orig_lnk_cim.object1_id1)

Line 5622: okc_k_items cov_ast_cim

5618: cov_ast_cim.dnz_chr_id
5619: from okc_k_lines_b cov_ast_cleb,
5620: okc_line_styles_b cov_ast_lseb,
5621: okl_k_lines fee_kle,
5622: okc_k_items cov_ast_cim
5623: where fee_kle.id = cov_ast_cleb.cle_id
5624: and fee_kle.fee_type = 'CAPITALIZED'
5625: and cov_ast_lseb.id = cov_ast_cleb.lse_id
5626: and cov_ast_lseb.lty_code = 'LINK_FEE_ASSET'

Line 5984: l_new_lnk_cim_id OKC_K_ITEMS.ID%TYPE;

5980: lv_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
5981: lx_cle_id_tbl klev_tbl_type;
5982: l_new_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
5983: l_orig_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
5984: l_new_lnk_cim_id OKC_K_ITEMS.ID%TYPE;
5985: l_jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE;
5986: l_object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE;
5987: l_object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE;
5988: l_cle_id OKC_K_LINES_B.ID%TYPE;

Line 5985: l_jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE;

5981: lx_cle_id_tbl klev_tbl_type;
5982: l_new_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
5983: l_orig_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
5984: l_new_lnk_cim_id OKC_K_ITEMS.ID%TYPE;
5985: l_jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE;
5986: l_object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE;
5987: l_object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE;
5988: l_cle_id OKC_K_LINES_B.ID%TYPE;
5989: l_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;

Line 5986: l_object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE;

5982: l_new_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
5983: l_orig_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
5984: l_new_lnk_cim_id OKC_K_ITEMS.ID%TYPE;
5985: l_jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE;
5986: l_object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE;
5987: l_object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE;
5988: l_cle_id OKC_K_LINES_B.ID%TYPE;
5989: l_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
5990: l_level NUMBER;

Line 5987: l_object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE;

5983: l_orig_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
5984: l_new_lnk_cim_id OKC_K_ITEMS.ID%TYPE;
5985: l_jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE;
5986: l_object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE;
5987: l_object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE;
5988: l_cle_id OKC_K_LINES_B.ID%TYPE;
5989: l_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
5990: l_level NUMBER;
5991: l_orig_system_id1 OKC_K_LINES_B.ORIG_SYSTEM_ID1%TYPE;

Line 6039: FROM okc_k_items new_lnk_cim,

6035: new_lnk_cim.id,
6036: new_lnk_cim.jtot_object1_code,
6037: new_lnk_cim.object1_id1,
6038: new_lnk_cim.object1_id2
6039: FROM okc_k_items new_lnk_cim,
6040: okc_k_lines_b new_lnk_cle
6041: WHERE new_lnk_cim.cle_id = new_lnk_cle.id
6042: AND new_lnk_cim.dnz_chr_id = new_lnk_cle.dnz_chr_id
6043: --Bug# 4899328