APPS.OKL_DEAL_ASSET_PVT dependencies on OKL_TXL_ITM_INSTS

Line 414: l_itiv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

410: l_clev_fa_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
411: l_clev_ib_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
412: l_cimv_fa_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
413: l_talv_fa_rec OKL_TAL_PVT.talv_rec_type;
414: l_itiv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
415:
416: x_clev_fin_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
417: x_clev_model_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
418: x_clev_fa_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 432: CURSOR c_serial_num_present(p_dnz_cle_id OKL_TXL_ITM_INSTS.DNZ_CLE_ID%TYPE) is

428: l_msg_data VARCHAR2(4000);
429: l_msg_index_out number;
430:
431: ln_dummy number := 0;
432: CURSOR c_serial_num_present(p_dnz_cle_id OKL_TXL_ITM_INSTS.DNZ_CLE_ID%TYPE) is
433: SELECT 1
434: FROM OKL_TXL_ITM_INSTS
435: WHERE dnz_cle_id = p_dnz_cle_id;
436: BEGIN

Line 434: FROM OKL_TXL_ITM_INSTS

430:
431: ln_dummy number := 0;
432: CURSOR c_serial_num_present(p_dnz_cle_id OKL_TXL_ITM_INSTS.DNZ_CLE_ID%TYPE) is
433: SELECT 1
434: FROM OKL_TXL_ITM_INSTS
435: WHERE dnz_cle_id = p_dnz_cle_id;
436: BEGIN
437: x_return_status := OKL_API.G_RET_STS_SUCCESS;
438: -- Call start_activity to create savepoint, check compatibility and initialize message list

Line 781: okl_txl_itm_insts iti

777: FROM okc_k_lines_b cleb_inst,
778: okc_k_lines_b cleb_ib,
779: okc_line_styles_b lse_inst,
780: okc_line_styles_b lse_ib,
781: okl_txl_itm_insts iti
782: WHERE cleb_inst.cle_id = p_clev_fin_id
783: AND cleb_inst.dnz_chr_id = p_dnz_chr_id
784: AND cleb_inst.lse_id = lse_inst.id
785: AND lse_inst.lty_code = 'FREE_FORM2'