APPS.OKL_DEAL_ASSET_PVT dependencies on OKL_TXL_ITM_INSTS

Line 372: l_itiv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

368: l_clev_fa_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
369: l_clev_ib_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
370: l_cimv_fa_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
371: l_talv_fa_rec OKL_TAL_PVT.talv_rec_type;
372: l_itiv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
373:
374: x_clev_fin_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
375: x_clev_model_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
376: x_clev_fa_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

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

386: l_msg_data VARCHAR2(4000);
387: l_msg_index_out number;
388:
389: ln_dummy number := 0;
390: CURSOR c_serial_num_present(p_dnz_cle_id OKL_TXL_ITM_INSTS.DNZ_CLE_ID%TYPE) is
391: SELECT 1
392: FROM OKL_TXL_ITM_INSTS
393: WHERE dnz_cle_id = p_dnz_cle_id;
394: BEGIN

Line 392: FROM OKL_TXL_ITM_INSTS

388:
389: ln_dummy number := 0;
390: CURSOR c_serial_num_present(p_dnz_cle_id OKL_TXL_ITM_INSTS.DNZ_CLE_ID%TYPE) is
391: SELECT 1
392: FROM OKL_TXL_ITM_INSTS
393: WHERE dnz_cle_id = p_dnz_cle_id;
394: BEGIN
395: x_return_status := OKL_API.G_RET_STS_SUCCESS;
396: -- Call start_activity to create savepoint, check compatibility and initialize message list

Line 739: okl_txl_itm_insts iti

735: FROM okc_k_lines_b cleb_inst,
736: okc_k_lines_b cleb_ib,
737: okc_line_styles_b lse_inst,
738: okc_line_styles_b lse_ib,
739: okl_txl_itm_insts iti
740: WHERE cleb_inst.cle_id = p_clev_fin_id
741: AND cleb_inst.dnz_chr_id = p_dnz_chr_id
742: AND cleb_inst.lse_id = lse_inst.id
743: AND lse_inst.lty_code = 'FREE_FORM2'