7294: iti.object_id1_new,
7295: iti.object_id2_new,
7296: iti.jtot_object_code_new
7297: FROM okl_trx_assets trx,
7298: okl_txl_itm_insts iti,
7299: okc_k_lines_b cleb_ib,
7300: okc_line_styles_b lseb_ib,
7301: okc_k_lines_b cleb_inst,
7302: okc_line_styles_b lseb_inst
7313: AND cleb_inst.dnz_chr_id = p_chr_id
7314: AND cleb_inst.lse_id = lseb_inst.id
7315: AND lseb_inst.lty_code = 'FREE_FORM2';
7316:
7317: l_itiv_ib_tbl OKL_TXL_ITM_INSTS_PUB.iipv_tbl_type;
7318: lx_itiv_ib_tbl OKL_TXL_ITM_INSTS_PUB.iipv_tbl_type;
7319: i NUMBER;
7320:
7321: --Bug# 4191851
7314: AND cleb_inst.lse_id = lseb_inst.id
7315: AND lseb_inst.lty_code = 'FREE_FORM2';
7316:
7317: l_itiv_ib_tbl OKL_TXL_ITM_INSTS_PUB.iipv_tbl_type;
7318: lx_itiv_ib_tbl OKL_TXL_ITM_INSTS_PUB.iipv_tbl_type;
7319: i NUMBER;
7320:
7321: --Bug# 4191851
7322: l_ipyv_rec OKL_IPY_PVT.ipyv_rec_type;
7689: END LOOP;
7690:
7691: IF (i > 0) THEN
7692:
7693: OKL_TXL_ITM_INSTS_PUB.update_txl_itm_insts
7694: (p_api_version => p_api_version,
7695: p_init_msg_list => p_init_msg_list,
7696: x_return_status => x_return_status,
7697: x_msg_count => x_msg_count,