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_LOAN_TRMNT_PVT dependencies on OKL_STREAMS

Line 3605: okl_streams stm

3601:
3602: CURSOR get_accel_till_csr (c_khr_id IN NUMBER, c_accrual_sty_id IN NUMBER) IS
3603: SELECT max(stream_element_date) accelerate_till_date
3604: FROM okl_strm_elements_v sel,
3605: okl_streams stm
3606: where SEL.STM_ID = STM.ID
3607: and STM.STY_ID = c_accrual_sty_id
3608: and STM.khr_id = c_khr_id
3609: AND STM.active_yn = 'Y'

Line 3877: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');

3873: IF l_release_basis = 'ACCELERATE'
3874: THEN
3875:
3876: IF (is_debug_statement_on) THEN
3877: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');
3878: END IF;
3879: -- SECHAWLA 29-DEC-05 4911502 : moved from above : begin
3880: -- rmunjulu 4399352 Added the following for bug 4399352 - start
3881: OKL_STREAMS_UTIL.get_dependent_stream_type(

Line 3881: OKL_STREAMS_UTIL.get_dependent_stream_type(

3877: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');
3878: END IF;
3879: -- SECHAWLA 29-DEC-05 4911502 : moved from above : begin
3880: -- rmunjulu 4399352 Added the following for bug 4399352 - start
3881: OKL_STREAMS_UTIL.get_dependent_stream_type(
3882: p_khr_id => p_term_rec.p_contract_id,
3883: p_primary_sty_id => l_sub_rec.stream_type_id,
3884: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
3885: x_return_status => l_return_status,

Line 3888: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);

3884: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
3885: x_return_status => l_return_status,
3886: x_dependent_sty_id => l_accrual_sty_id);
3887: IF (is_debug_statement_on) THEN
3888: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
3889: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_accrual_sty_id : ' || l_accrual_sty_id);
3890: END IF;
3891:
3892: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4008: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

4004: RAISE OKL_API.G_EXCEPTION_ERROR;
4005: END IF;
4006:
4007: -- Start MGAAP 7263041
4008: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4009: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4010: p_khr_id => p_term_rec.p_contract_id,
4011: p_primary_sty_id => l_sub_rec.stream_type_id,
4012: p_dependent_sty_purpose => 'SUBSIDY_INCOME',

Line 4009: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

4005: END IF;
4006:
4007: -- Start MGAAP 7263041
4008: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4009: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4010: p_khr_id => p_term_rec.p_contract_id,
4011: p_primary_sty_id => l_sub_rec.stream_type_id,
4012: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4013: x_return_status => l_return_status,

Line 4016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);

4012: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4013: x_return_status => l_return_status,
4014: x_dependent_sty_id => l_accrual_sty_id_rep);
4015: IF (is_debug_statement_on) THEN
4016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
4017: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_accrual_sty_id_rep : ' || l_accrual_sty_id_rep);
4018: END IF;
4019:
4020: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 4055: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; --Added by bkatraga for bug 10032334

4051: RAISE OKL_API.G_EXCEPTION_ERROR;
4052: END IF;
4053:
4054: END IF;
4055: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; --Added by bkatraga for bug 10032334
4056: -- end MGAAP 7263041
4057:
4058: -- akrangan for bug 5669097 start
4059: END IF;

Line 4233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');

4229:
4230: ELSIF l_sub_rec.accounting_method_code = 'AMORTIZE'THEN
4231:
4232: IF (is_debug_statement_on) THEN
4233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');
4234: END IF;
4235: -- SECHAWLA 29-DEC-05 4911502 : added begin
4236: OKL_STREAMS_UTIL.get_dependent_stream_type(
4237: p_khr_id => p_term_rec.p_contract_id,

Line 4236: OKL_STREAMS_UTIL.get_dependent_stream_type(

4232: IF (is_debug_statement_on) THEN
4233: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');
4234: END IF;
4235: -- SECHAWLA 29-DEC-05 4911502 : added begin
4236: OKL_STREAMS_UTIL.get_dependent_stream_type(
4237: p_khr_id => p_term_rec.p_contract_id,
4238: p_primary_sty_id => l_sub_rec.stream_type_id,
4239: p_dependent_sty_purpose => 'SUBSIDY_INCOME', -- ***** confirm
4240: x_return_status => l_return_status,

Line 4243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);

4239: p_dependent_sty_purpose => 'SUBSIDY_INCOME', -- ***** confirm
4240: x_return_status => l_return_status,
4241: x_dependent_sty_id => l_accrual_sty_id);
4242: IF (is_debug_statement_on) THEN
4243: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
4244: END IF;
4245:
4246: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4247: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4379: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

4375: RAISE OKL_API.G_EXCEPTION_ERROR;
4376: END IF;
4377: -- akrangan for bug 5669097 start
4378: -- Start MGAAP 7263041
4379: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4380: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4381: p_khr_id => p_term_rec.p_contract_id,
4382: p_primary_sty_id => l_sub_rec.stream_type_id,
4383: p_dependent_sty_purpose => 'SUBSIDY_INCOME',

Line 4380: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

4376: END IF;
4377: -- akrangan for bug 5669097 start
4378: -- Start MGAAP 7263041
4379: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4380: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4381: p_khr_id => p_term_rec.p_contract_id,
4382: p_primary_sty_id => l_sub_rec.stream_type_id,
4383: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4384: x_return_status => l_return_status,

Line 4387: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);

4383: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4384: x_return_status => l_return_status,
4385: x_dependent_sty_id => l_accrual_sty_id_rep);
4386: IF (is_debug_statement_on) THEN
4387: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
4388: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_accrual_sty_id_rep : ' || l_accrual_sty_id_rep);
4389: END IF;
4390:
4391: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 4426: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; --Added by bkatraga for bug 10032334

4422: RAISE OKL_API.G_EXCEPTION_ERROR;
4423: END IF;
4424:
4425: END IF;
4426: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; --Added by bkatraga for bug 10032334
4427: -- end MGAAP 7263041
4428: END IF;
4429: -- akrangan for bug 5669097 End
4430:

Line 4482: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

4478: RAISE OKL_API.G_EXCEPTION_ERROR;
4479: END IF;
4480: -- akrangan for bug 5669097 start
4481: -- Start MGAAP 7263041
4482: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4483: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4484: p_khr_id => p_term_rec.p_contract_id,
4485: p_primary_sty_id => l_sub_rec.stream_type_id,
4486: p_dependent_sty_purpose => 'SUBSIDY_INCOME',

Line 4483: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

4479: END IF;
4480: -- akrangan for bug 5669097 start
4481: -- Start MGAAP 7263041
4482: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4483: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4484: p_khr_id => p_term_rec.p_contract_id,
4485: p_primary_sty_id => l_sub_rec.stream_type_id,
4486: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4487: x_return_status => l_return_status,

Line 4490: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);

4486: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4487: x_return_status => l_return_status,
4488: x_dependent_sty_id => l_accrual_sty_id_rep);
4489: IF (is_debug_statement_on) THEN
4490: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
4491: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_accrual_sty_id_rep : ' || l_accrual_sty_id_rep);
4492: END IF;
4493:
4494: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 4529: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; --Added by bkatraga for bug 10032334

4525: RAISE OKL_API.G_EXCEPTION_ERROR;
4526: END IF;
4527:
4528: END IF;
4529: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; --Added by bkatraga for bug 10032334
4530: -- end MGAAP 7263041
4531: END IF;
4532: -- akrangan for bug 5669097 End
4533: ELSIF l_sub_rec.TERMINATION_REFUND_BASIS = 'FORMULA' THEN

Line 4843: FROM okl_streams stm

4839: -- Cursor to obtain refund asset remaining amount
4840: CURSOR l_ref_asset_amt_csr(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_date IN DATE) IS
4841: SELECT stm.sty_id,
4842: SUM(ste.amount) amount
4843: FROM okl_streams stm
4844: ,okl_strm_type_b sty
4845: ,okc_k_lines_b kle
4846: ,okc_statuses_b kls
4847: ,okl_strm_elements ste

Line 5224: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

5220: IF (is_debug_statement_on) THEN
5221: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment');
5222: END IF;
5223:
5224: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
5225: OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment(
5226: p_api_version => p_api_version,
5227: p_init_msg_list => OKL_API.G_FALSE,
5228: x_return_status => l_return_status,

Line 5327: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041

5323: IF (is_debug_statement_on) THEN
5324: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment for SECONDARY');
5325: END IF;
5326:
5327: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041
5328:
5329: OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment(
5330: p_api_version => p_api_version,
5331: p_init_msg_list => OKL_API.G_FALSE,

Line 5341: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

5337: p_adjustment_date => l_accrual_adjst_date, -- rmunjulu 4769094
5338: x_accrual_adjustment_tbl => lx_accrual_adjustment_tbl,
5339: p_product_id => l_reporting_pdt_id); -- MGAAP 7263041
5340:
5341: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
5342:
5343: IF (is_debug_statement_on) THEN
5344: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment , return status : ' || l_return_status);
5345: END IF;

Line 5668: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_streams_util.get_dependent_stream_type');

5664: RAISE OKL_API.G_EXCEPTION_ERROR;
5665: END IF;
5666:
5667: IF (is_debug_statement_on) THEN
5668: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_streams_util.get_dependent_stream_type');
5669: END IF;
5670: --Bug 6266134 veramach start
5671: okl_streams_util.get_dependent_stream_type(
5672: p_khr_id => p_term_rec.p_contract_id,

Line 5671: okl_streams_util.get_dependent_stream_type(

5667: IF (is_debug_statement_on) THEN
5668: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_streams_util.get_dependent_stream_type');
5669: END IF;
5670: --Bug 6266134 veramach start
5671: okl_streams_util.get_dependent_stream_type(
5672: p_khr_id => p_term_rec.p_contract_id,
5673: p_primary_sty_purpose => 'RENT',
5674: p_dependent_sty_purpose => 'EXCESS_LOAN_PAYMENT_PAID',
5675: x_return_status => l_return_status,

Line 5680: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_streams_util.get_dependent_stream_type , return status : ' || l_return_status);

5676: x_dependent_sty_id => l_sty_id
5677: );
5678: --Bug 6266134 veramach end
5679: IF (is_debug_statement_on) THEN
5680: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_streams_util.get_dependent_stream_type , return status : ' || l_return_status);
5681: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_sty_id : ' || l_sty_id);
5682: END IF;
5683:
5684: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN