eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_STREAMS

Line 4476: FROM OKL_STREAMS_V STM,

4472: -- Modified cursor by passing sty_id based on the purpose .
4473: -- Fix for Bug#13933234, sgn_code='INTC' needs to be histrized
4474: CURSOR k_streams_csr ( p_chr_id IN NUMBER,p_sty_id IN NUMBER) IS
4475: SELECT STM.id
4476: FROM OKL_STREAMS_V STM,
4477: OKL_STRM_TYPE_B STY
4478: WHERE STM.khr_id = p_chr_id
4479: AND STM.say_code = 'CURR'
4480: AND STM.STY_ID = STY.ID

Line 4529: OKL_STREAMS_UTIL.get_primary_stream_type(p_term_rec.p_contract_id,

4525: -- Start a savepoint to rollback to if error in this block
4526: SAVEPOINT close_streams;
4527:
4528: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
4529: OKL_STREAMS_UTIL.get_primary_stream_type(p_term_rec.p_contract_id,
4530: 'RESIDUAL_VALUE',
4531: l_dummy_status, -- rmunjulu 4058630 (get into dummy as return not needed)
4532: lx_sty_id);
4533: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++

Line 4585: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_STREAMS_PUB.update_streams');

4581:
4582: i := i + 1;
4583: END LOOP;
4584: IF (is_debug_statement_on) THEN
4585: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_STREAMS_PUB.update_streams');
4586: END IF;
4587: -- close streams
4588: OKL_STREAMS_PUB.update_streams(
4589: p_api_version => p_api_version,

Line 4588: OKL_STREAMS_PUB.update_streams(

4584: IF (is_debug_statement_on) THEN
4585: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_STREAMS_PUB.update_streams');
4586: END IF;
4587: -- close streams
4588: OKL_STREAMS_PUB.update_streams(
4589: p_api_version => p_api_version,
4590: p_init_msg_list => OKL_API.G_FALSE,
4591: x_return_status => l_return_status,
4592: x_msg_count => x_msg_count,

Line 4597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_STREAMS_PUB.update_streams l_return_status ='||l_return_status);

4593: x_msg_data => x_msg_data,
4594: p_stmv_tbl => lp_stmv_tbl,
4595: x_stmv_tbl => lx_stmv_tbl);
4596: IF (is_debug_statement_on) THEN
4597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_STREAMS_PUB.update_streams l_return_status ='||l_return_status);
4598: END IF;
4599:
4600: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
4601: -- Streams table update failed.

Line 4851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_STREAMS_UTIL.get_primary_stream_type.');

4847: AND p_auto_invoice_yn = 'Y'
4848: AND p_klev_tbl.COUNT > 0 THEN
4849:
4850: IF (is_debug_statement_on) THEN
4851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_STREAMS_UTIL.get_primary_stream_type.');
4852: END IF;
4853:
4854: -- get stream type id for Quote Purchase Amount Purpose
4855: OKL_STREAMS_UTIL.get_primary_stream_type(

Line 4855: OKL_STREAMS_UTIL.get_primary_stream_type(

4851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_STREAMS_UTIL.get_primary_stream_type.');
4852: END IF;
4853:
4854: -- get stream type id for Quote Purchase Amount Purpose
4855: OKL_STREAMS_UTIL.get_primary_stream_type(
4856: p_khr_id => p_term_rec.p_contract_id,
4857: p_primary_sty_purpose => 'AMBPOC', -- Quote Purchase Amount Purpose
4858: x_return_status => l_return_status,
4859: x_primary_sty_id => l_purchase_option_sty_id);

Line 4862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_STREAMS_UTIL.get_primary_stream_type.l_return_status = '||l_return_status);

4858: x_return_status => l_return_status,
4859: x_primary_sty_id => l_purchase_option_sty_id);
4860:
4861: IF (is_debug_statement_on) THEN
4862: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_STREAMS_UTIL.get_primary_stream_type.l_return_status = '||l_return_status);
4863: END IF;
4864:
4865: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
4866: AND (l_purchase_option_sty_id IS NULL OR l_purchase_option_sty_id = OKL_API.G_MISS_NUM) THEN

Line 6408: okl_streams stm

6404: SELECT okl_line.fee_type fee_type
6405: FROM okl_k_lines okl_line,
6406: okc_k_lines_b okc_line,
6407: okc_line_styles_b lse,
6408: okl_streams stm
6409: WHERE okl_line.id = okc_line.id AND
6410: okc_line.lse_id = lse.id AND lse.lty_code = 'FEE' AND
6411: okc_line.chr_id = p_khr_id AND
6412: stm.khr_id = okc_line.chr_id AND

Line 6448: okl_streams stm

6444: -- -- rmunjulu bug 4416094
6445: CURSOR get_accel_till_csr(p_khr_id IN NUMBER, p_pretax_sty_id IN NUMBER, p_rentaccrual_sty_id IN NUMBER, p_interestincome_sty_id IN NUMBER) IS
6446: SELECT MAX(stream_element_date)
6447: FROM okl_strm_elements_v sel,
6448: okl_streams stm
6449: WHERE sel.stm_id = stm.id AND
6450: stm.sty_id IN (p_pretax_sty_id, p_rentaccrual_sty_id,
6451: p_interestincome_sty_id) AND stm.khr_id = p_khr_id;
6452: */

Line 6460: okl_streams stm

6456:
6457: CURSOR get_accel_till_csr(p_khr_id IN NUMBER, p_sty_id IN NUMBER) IS
6458: SELECT MAX(stream_element_date)
6459: FROM okl_strm_elements_v sel,
6460: okl_streams stm
6461: WHERE sel.stm_id = stm.id AND
6462: stm.sty_id = p_sty_id AND stm.khr_id = p_khr_id;
6463:
6464: -- Bug#7248153 - rbruno - changed - End

Line 7506: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,

7502: IF l_deal_type IN ('LEASEDF', 'LEASEST')
7503: THEN
7504: -- DF/ST Lease
7505: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
7506: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,
7507: 'RENT',
7508: 'LEASE_INCOME',
7509: l_return_status,
7510: lx_pretax_sty_id);

Line 7515: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,

7511: ELSIF l_deal_type = 'LEASEOP'
7512: THEN
7513: -- OP Lease
7514:
7515: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,
7516: 'RENT',
7517: 'RENT_ACCRUAL',
7518: l_return_status,
7519: lx_rentaccrual_sty_id);

Line 7529: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,

7525: THEN
7526: -- Loan
7527: -- 03-mar-06 sgorantl -- Bug 4931796
7528: -- rmunjulu bug 4416094
7529: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,
7530: 'RENT',
7531: 'INTEREST_INCOME',
7532: l_return_status,
7533: lx_interestincome_sty_id);

Line 7554: OKL_STREAMS_UTIL.get_dependent_stream_type(p_term_rec.p_contract_id,

7550: FOR primary_sty_id_rec in primary_sty_id_csr(p_term_rec.p_contract_id) LOOP
7551:
7552:
7553:
7554: OKL_STREAMS_UTIL.get_dependent_stream_type(p_term_rec.p_contract_id,
7555: primary_sty_id_rec.Primary_sty_id,
7556: 'AMORTIZED_FEE_EXPENSE',
7557: l_return_status,
7558: lx_sty_id);

Line 7572: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,

7568:
7569: -- Added by ansethur for bug#6156337 08-Aug-2007 end
7570: /* commented by ansethur for bug#6156337 08-Aug-2007 start
7571: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
7572: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,
7573: 'EXPENSE',
7574: 'AMORTIZED_FEE_EXPENSE',
7575: l_return_status,
7576: lx_sty_id);

Line 7643: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

7639:
7640: -- sosharma added multigaap check for bug 13075531
7641: IF (l_multi_gaap_yn = 'Y') THEN
7642: -- Start MGAAP 7263041
7643: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
7644: okl_streams_util.get_dependent_stream_type_rep(
7645: p_term_rec.p_contract_id,
7646: 'EXPENSE',
7647: 'AMORTIZED_FEE_EXPENSE',

Line 7644: okl_streams_util.get_dependent_stream_type_rep(

7640: -- sosharma added multigaap check for bug 13075531
7641: IF (l_multi_gaap_yn = 'Y') THEN
7642: -- Start MGAAP 7263041
7643: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
7644: okl_streams_util.get_dependent_stream_type_rep(
7645: p_term_rec.p_contract_id,
7646: 'EXPENSE',
7647: 'AMORTIZED_FEE_EXPENSE',
7648: l_return_status,

Line 7664: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

7660: p_acceleration_rec => l_acceleration_rec,
7661: p_representation_type => 'SECONDARY',
7662: x_trx_number => l_trx_number);
7663:
7664: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
7665:
7666: IF (is_debug_statement_on) THEN
7667: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_GENERATE_ACCRUALS_PVT.accelerate_accruals , return status : ' || l_return_status);
7668: END IF;