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 3583: okl_streams stm

3579:
3580: CURSOR get_accel_till_csr (c_khr_id IN NUMBER, c_accrual_sty_id IN NUMBER) IS
3581: SELECT max(stream_element_date) accelerate_till_date
3582: FROM okl_strm_elements_v sel,
3583: okl_streams stm
3584: where SEL.STM_ID = STM.ID
3585: and STM.STY_ID = c_accrual_sty_id
3586: and STM.khr_id = c_khr_id
3587: AND STM.active_yn = 'Y'

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

3851: IF l_release_basis = 'ACCELERATE'
3852: THEN
3853:
3854: IF (is_debug_statement_on) THEN
3855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');
3856: END IF;
3857: -- SECHAWLA 29-DEC-05 4911502 : moved from above : begin
3858: -- rmunjulu 4399352 Added the following for bug 4399352 - start
3859: OKL_STREAMS_UTIL.get_dependent_stream_type(

Line 3859: OKL_STREAMS_UTIL.get_dependent_stream_type(

3855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');
3856: END IF;
3857: -- SECHAWLA 29-DEC-05 4911502 : moved from above : begin
3858: -- rmunjulu 4399352 Added the following for bug 4399352 - start
3859: OKL_STREAMS_UTIL.get_dependent_stream_type(
3860: p_khr_id => p_term_rec.p_contract_id,
3861: p_primary_sty_id => l_sub_rec.stream_type_id,
3862: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
3863: x_return_status => l_return_status,

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

3862: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
3863: x_return_status => l_return_status,
3864: x_dependent_sty_id => l_accrual_sty_id);
3865: IF (is_debug_statement_on) THEN
3866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
3867: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_accrual_sty_id : ' || l_accrual_sty_id);
3868: END IF;
3869:
3870: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3986: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

3982: RAISE OKL_API.G_EXCEPTION_ERROR;
3983: END IF;
3984:
3985: -- Start MGAAP 7263041
3986: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3987: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
3988: p_khr_id => p_term_rec.p_contract_id,
3989: p_primary_sty_id => l_sub_rec.stream_type_id,
3990: p_dependent_sty_purpose => 'SUBSIDY_INCOME',

Line 3987: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

3983: END IF;
3984:
3985: -- Start MGAAP 7263041
3986: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3987: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
3988: p_khr_id => p_term_rec.p_contract_id,
3989: p_primary_sty_id => l_sub_rec.stream_type_id,
3990: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
3991: x_return_status => l_return_status,

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

3990: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
3991: x_return_status => l_return_status,
3992: x_dependent_sty_id => l_accrual_sty_id_rep);
3993: IF (is_debug_statement_on) THEN
3994: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
3995: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_accrual_sty_id_rep : ' || l_accrual_sty_id_rep);
3996: END IF;
3997:
3998: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 4011: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

4007: x_msg_data => l_msg_data,
4008: p_acceleration_rec => l_acceleration_rec,
4009: p_representation_type => 'SECONDARY',
4010: x_trx_number => l_trx_number);
4011: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
4012:
4013: IF (is_debug_statement_on) THEN
4014: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_GENERATE_ACCRUALS_PVT.accelerate_accruals , return status : ' || l_return_status);
4015: END IF;

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

4207:
4208: ELSIF l_sub_rec.accounting_method_code = 'AMORTIZE'THEN
4209:
4210: IF (is_debug_statement_on) THEN
4211: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');
4212: END IF;
4213: -- SECHAWLA 29-DEC-05 4911502 : added begin
4214: OKL_STREAMS_UTIL.get_dependent_stream_type(
4215: p_khr_id => p_term_rec.p_contract_id,

Line 4214: OKL_STREAMS_UTIL.get_dependent_stream_type(

4210: IF (is_debug_statement_on) THEN
4211: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_STREAMS_UTIL.get_dependent_stream_type');
4212: END IF;
4213: -- SECHAWLA 29-DEC-05 4911502 : added begin
4214: OKL_STREAMS_UTIL.get_dependent_stream_type(
4215: p_khr_id => p_term_rec.p_contract_id,
4216: p_primary_sty_id => l_sub_rec.stream_type_id,
4217: p_dependent_sty_purpose => 'SUBSIDY_INCOME', -- ***** confirm
4218: x_return_status => l_return_status,

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

4217: p_dependent_sty_purpose => 'SUBSIDY_INCOME', -- ***** confirm
4218: x_return_status => l_return_status,
4219: x_dependent_sty_id => l_accrual_sty_id);
4220: IF (is_debug_statement_on) THEN
4221: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
4222: END IF;
4223:
4224: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4225: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4357: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

4353: RAISE OKL_API.G_EXCEPTION_ERROR;
4354: END IF;
4355: -- akrangan for bug 5669097 start
4356: -- Start MGAAP 7263041
4357: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4358: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4359: p_khr_id => p_term_rec.p_contract_id,
4360: p_primary_sty_id => l_sub_rec.stream_type_id,
4361: p_dependent_sty_purpose => 'SUBSIDY_INCOME',

Line 4358: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

4354: END IF;
4355: -- akrangan for bug 5669097 start
4356: -- Start MGAAP 7263041
4357: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4358: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4359: p_khr_id => p_term_rec.p_contract_id,
4360: p_primary_sty_id => l_sub_rec.stream_type_id,
4361: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4362: x_return_status => l_return_status,

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

4361: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4362: x_return_status => l_return_status,
4363: x_dependent_sty_id => l_accrual_sty_id_rep);
4364: IF (is_debug_statement_on) THEN
4365: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
4366: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_accrual_sty_id_rep : ' || l_accrual_sty_id_rep);
4367: END IF;
4368:
4369: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 4382: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

4378: x_msg_data => l_msg_data,
4379: p_acceleration_rec => l_acceleration_rec,
4380: p_representation_type => 'SECONDARY',
4381: x_trx_number => l_trx_number);
4382: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
4383:
4384: IF (is_debug_statement_on) THEN
4385: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_GENERATE_ACCRUALS_PVT.accelerate_accruals , return status : ' || l_return_status);
4386: END IF;

Line 4460: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

4456: RAISE OKL_API.G_EXCEPTION_ERROR;
4457: END IF;
4458: -- akrangan for bug 5669097 start
4459: -- Start MGAAP 7263041
4460: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4461: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4462: p_khr_id => p_term_rec.p_contract_id,
4463: p_primary_sty_id => l_sub_rec.stream_type_id,
4464: p_dependent_sty_purpose => 'SUBSIDY_INCOME',

Line 4461: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

4457: END IF;
4458: -- akrangan for bug 5669097 start
4459: -- Start MGAAP 7263041
4460: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4461: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4462: p_khr_id => p_term_rec.p_contract_id,
4463: p_primary_sty_id => l_sub_rec.stream_type_id,
4464: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4465: x_return_status => l_return_status,

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

4464: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4465: x_return_status => l_return_status,
4466: x_dependent_sty_id => l_accrual_sty_id_rep);
4467: IF (is_debug_statement_on) THEN
4468: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_STREAMS_UTIL.get_dependent_stream_type , return status : ' || l_return_status);
4469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_accrual_sty_id_rep : ' || l_accrual_sty_id_rep);
4470: END IF;
4471:
4472: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 4485: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

4481: x_msg_data => l_msg_data,
4482: p_acceleration_rec => l_acceleration_rec,
4483: p_representation_type => 'SECONDARY',
4484: x_trx_number => l_trx_number);
4485: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
4486:
4487: IF (is_debug_statement_on) THEN
4488: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_GENERATE_ACCRUALS_PVT.accelerate_accruals , return status : ' || l_return_status);
4489: END IF;

Line 4821: FROM okl_streams stm

4817: -- Cursor to obtain refund asset remaining amount
4818: CURSOR l_ref_asset_amt_csr(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_date IN DATE) IS
4819: SELECT stm.sty_id,
4820: SUM(ste.amount) amount
4821: FROM okl_streams stm
4822: ,okl_strm_type_b sty
4823: ,okc_k_lines_b kle
4824: ,okc_statuses_b kls
4825: ,okl_strm_elements ste

Line 5183: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

5179: IF (is_debug_statement_on) THEN
5180: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment');
5181: END IF;
5182:
5183: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
5184: OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment(
5185: p_api_version => p_api_version,
5186: p_init_msg_list => OKL_API.G_FALSE,
5187: x_return_status => l_return_status,

Line 5284: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041

5280: IF (is_debug_statement_on) THEN
5281: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment for SECONDARY');
5282: END IF;
5283:
5284: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041
5285:
5286: OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment(
5287: p_api_version => p_api_version,
5288: p_init_msg_list => OKL_API.G_FALSE,

Line 5298: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

5294: p_adjustment_date => l_accrual_adjst_date, -- rmunjulu 4769094
5295: x_accrual_adjustment_tbl => lx_accrual_adjustment_tbl,
5296: p_product_id => l_reporting_pdt_id); -- MGAAP 7263041
5297:
5298: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
5299:
5300: IF (is_debug_statement_on) THEN
5301: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_ACCRUAL_SEC_PVT.Get_Accrual_Adjustment , return status : ' || l_return_status);
5302: END IF;

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

5620: RAISE OKL_API.G_EXCEPTION_ERROR;
5621: END IF;
5622:
5623: IF (is_debug_statement_on) THEN
5624: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_streams_util.get_dependent_stream_type');
5625: END IF;
5626: --Bug 6266134 veramach start
5627: okl_streams_util.get_dependent_stream_type(
5628: p_khr_id => p_term_rec.p_contract_id,

Line 5627: okl_streams_util.get_dependent_stream_type(

5623: IF (is_debug_statement_on) THEN
5624: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_streams_util.get_dependent_stream_type');
5625: END IF;
5626: --Bug 6266134 veramach start
5627: okl_streams_util.get_dependent_stream_type(
5628: p_khr_id => p_term_rec.p_contract_id,
5629: p_primary_sty_purpose => 'RENT',
5630: p_dependent_sty_purpose => 'EXCESS_LOAN_PAYMENT_PAID',
5631: x_return_status => l_return_status,

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

5632: x_dependent_sty_id => l_sty_id
5633: );
5634: --Bug 6266134 veramach end
5635: IF (is_debug_statement_on) THEN
5636: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_streams_util.get_dependent_stream_type , return status : ' || l_return_status);
5637: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_sty_id : ' || l_sty_id);
5638: END IF;
5639:
5640: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN