[Home] [Help]
1855: okl_txl_assets_b txlb,
1856: okc_k_lines_b cleb,
1857: okc_line_styles_b lseb,
1858: okc_k_lines_b cleb_top,
1859: okl_k_lines kle_top
1860: where txdb.tax_book = p_book_type_code
1861: and txdb.tal_id = txlb.id
1862: and txlb.kle_id = cleb.id
1863: and cleb.lse_id = lseb.id
3111: --cursor to get maximum subsidy term
3112: cursor l_sub_csr (p_cle_id in number) is
3113: select subb.maximum_term
3114: from okl_subsidies_b subb,
3115: okl_k_lines kle
3116: where subsidy_id = kle.subsidy_id
3117: and kle.id = p_cle_id;
3118:
3119: l_max_subsidy_term okl_subsidies_b.maximum_term%TYPE;
6617: -- Business Rules : If p_edit_mode is sent as 'Y' contract status will be
6618: -- updated to 'INCOMPLETE' else it will not be updated to
6619: -- 'INCOMPLETE'. Facilitates updater transactions which
6620: -- happen in the background while the contract is not 'BOOKED'
6621: -- for example - calculation and updation of okl_k_lines.
6622: -- capitalized_interest every time user navigates to booking
6623: -- page. It is not desired that khr status change to 'INCOMPLETE'
6624: -- every time capitalized interest is updated.
6625: -- Parameters :
6647: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6648:
6649: cursor l_klev_csr(l_id IN NUMBER) is
6650: select 'x'
6651: from OKL_K_LINES_V
6652: where id = l_id;
6653: l_dummy_var VARCHAR2(1) := '?';
6654:
6655: --Bug# 3143522,
7153: -- Business Rules : If p_edit_mode is sent as 'Y' contract status will be
7154: -- updated to 'INCOMPLETE' else it will not be updated to
7155: -- 'INCOMPLETE'. Facilitates updater transactions which
7156: -- happen in the background while the contract is not 'BOOKED'
7157: -- for example - calculation and updation of okl_k_lines.
7158: -- capitalized_interest every time user navigates to booking
7159: -- page. It is not desired that khr status change to 'INCOMPLETE'
7160: -- every time capitalized interest is updated.
7161: -- Parameters :