APPS.OKL_DEAL_ASSET_PVT dependencies on OKL_TXL_ASSETS_B

Line 65: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;

61: l_cimv_fa_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
62: l_talv_fa_rec OKL_TAL_PVT.talv_rec_type;
63: l_itiv_ib_tbl OKL_ITI_PVT.itiv_tbl_type;
64: -- gboomina Added for Bug 5876083 - Start
65: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
66: l_clev_fa_id OKC_K_LINES_B.ID%TYPE;
67: l_asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE;
68: -- gboomina Added for Bug 5876083 - End
69: x_clev_fin_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 84: -- gboomina added - Cursor to get the okl_txl_assets_b rec's id

80: l_api_version CONSTANT NUMBER := 1;
81: l_msg_data VARCHAR2(4000);
82: l_msg_index_out number;
83:
84: -- gboomina added - Cursor to get the okl_txl_assets_b rec's id
85: -- Record for Corporate book details will be created in okl_txl_assets_b when asset is getting created.
86: -- As per new UI design, We need to get this record and update the user inputs along with asset
87: -- creation.
88: CURSOR get_tal_id_csr(p_clev_fa_id NUMBER, p_asset_number VARCHAR2) IS

Line 85: -- Record for Corporate book details will be created in okl_txl_assets_b when asset is getting created.

81: l_msg_data VARCHAR2(4000);
82: l_msg_index_out number;
83:
84: -- gboomina added - Cursor to get the okl_txl_assets_b rec's id
85: -- Record for Corporate book details will be created in okl_txl_assets_b when asset is getting created.
86: -- As per new UI design, We need to get this record and update the user inputs along with asset
87: -- creation.
88: CURSOR get_tal_id_csr(p_clev_fa_id NUMBER, p_asset_number VARCHAR2) IS
89: SELECT ID

Line 90: FROM OKL_TXL_ASSETS_B

86: -- As per new UI design, We need to get this record and update the user inputs along with asset
87: -- creation.
88: CURSOR get_tal_id_csr(p_clev_fa_id NUMBER, p_asset_number VARCHAR2) IS
89: SELECT ID
90: FROM OKL_TXL_ASSETS_B
91: WHERE KLE_ID = p_clev_fa_id
92: AND ASSET_NUMBER = p_asset_number;
93:
94: --Bug #15992711 : Start

Line 101: FROM okl_txl_assets_b TXL

97: CURSOR chk_rel_ass_csr (p_asset_number VARCHAR2) IS
98: SELECT 'N' new_asset
99: FROM okl_asset_returns_b KAR
100: WHERE KAR.kle_id IN (SELECT KLE.cle_id
101: FROM okl_txl_assets_b TXL
102: ,okl_txd_assets_b TXD
103: ,okc_k_lines_b KLE
104: WHERE TXD.asset_number = p_asset_number
105: AND KLE.id = TXL.kle_id

Line 229: p_token1_value => 'OKL_TXL_ASSETS_B.FA_LOCATION_ID');

225: IF ((p_las_rec.deal_type = 'LEASE') AND (p_las_rec.fa_location_id IS NULL)) THEN
226: OKL_API.set_message(p_app_name => G_APP_NAME,
227: p_msg_name => G_REQUIRED_VALUE,
228: p_token1 => G_COL_NAME_TOKEN,
229: p_token1_value => 'OKL_TXL_ASSETS_B.FA_LOCATION_ID');
230: RAISE OKL_API.G_EXCEPTION_ERROR;
231: ELSE
232: l_talv_fa_rec.fa_location_id := p_las_rec.fa_location_id;
233: END IF;

Line 527: p_token1_value => 'OKL_TXL_ASSETS_B.FA_LOCATION_ID');

523: IF ((p_las_rec.deal_type = 'LEASE') AND (p_las_rec.fa_location_id IS NULL)) THEN
524: OKL_API.set_message(p_app_name => G_APP_NAME,
525: p_msg_name => G_REQUIRED_VALUE,
526: p_token1 => G_COL_NAME_TOKEN,
527: p_token1_value => 'OKL_TXL_ASSETS_B.FA_LOCATION_ID');
528: RAISE OKL_API.G_EXCEPTION_ERROR;
529: ELSE
530: l_talv_fa_rec.fa_location_id := p_las_rec.fa_location_id;
531: END IF;

Line 753: FROM okl_txl_assets_b txl,

749: txl.manufacturer_name,
750: txl.asset_key_id,
751: ast_key.concatenated_segments asset_key_name,
752: cim_fa.object1_id1 asset_id
753: FROM okl_txl_assets_b txl,
754: okc_line_styles_b lse_fa,
755: okl_k_lines kle_fa,
756: okc_k_lines_b cleb_fa,
757: okl_asset_key_lov_uv ast_key,