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 4359: FROM OKL_STREAMS_V STM,

4355: -- SMODUGA 11-Oct-04 Bug 3925469
4356: -- Modified cursor by passing sty_id based on the purpose .
4357: CURSOR k_streams_csr ( p_chr_id IN NUMBER,p_sty_id IN NUMBER) IS
4358: SELECT STM.id
4359: FROM OKL_STREAMS_V STM,
4360: OKL_STRM_TYPE_B STY
4361: WHERE STM.khr_id = p_chr_id
4362: AND STM.say_code = 'CURR'
4363: AND STM.STY_ID = STY.ID

Line 4400: OKL_STREAMS_UTIL.get_primary_stream_type(p_term_rec.p_contract_id,

4396: -- Start a savepoint to rollback to if error in this block
4397: SAVEPOINT close_streams;
4398:
4399: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
4400: OKL_STREAMS_UTIL.get_primary_stream_type(p_term_rec.p_contract_id,
4401: 'RESIDUAL_VALUE',
4402: l_dummy_status, -- rmunjulu 4058630 (get into dummy as return not needed)
4403: lx_sty_id);
4404: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++

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

4442:
4443: i := i + 1;
4444: END LOOP;
4445: IF (is_debug_statement_on) THEN
4446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_STREAMS_PUB.update_streams');
4447: END IF;
4448: -- close streams
4449: OKL_STREAMS_PUB.update_streams(
4450: p_api_version => p_api_version,

Line 4449: OKL_STREAMS_PUB.update_streams(

4445: IF (is_debug_statement_on) THEN
4446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_STREAMS_PUB.update_streams');
4447: END IF;
4448: -- close streams
4449: OKL_STREAMS_PUB.update_streams(
4450: p_api_version => p_api_version,
4451: p_init_msg_list => OKL_API.G_FALSE,
4452: x_return_status => l_return_status,
4453: x_msg_count => x_msg_count,

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

4454: x_msg_data => x_msg_data,
4455: p_stmv_tbl => lp_stmv_tbl,
4456: x_stmv_tbl => lx_stmv_tbl);
4457: IF (is_debug_statement_on) THEN
4458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_STREAMS_PUB.update_streams l_return_status ='||l_return_status);
4459: END IF;
4460:
4461: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
4462: -- Streams table update failed.

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

4703: AND p_auto_invoice_yn = 'Y'
4704: AND p_klev_tbl.COUNT > 0 THEN
4705:
4706: IF (is_debug_statement_on) THEN
4707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_STREAMS_UTIL.get_primary_stream_type.');
4708: END IF;
4709:
4710: -- get stream type id for Quote Purchase Amount Purpose
4711: OKL_STREAMS_UTIL.get_primary_stream_type(

Line 4711: OKL_STREAMS_UTIL.get_primary_stream_type(

4707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_STREAMS_UTIL.get_primary_stream_type.');
4708: END IF;
4709:
4710: -- get stream type id for Quote Purchase Amount Purpose
4711: OKL_STREAMS_UTIL.get_primary_stream_type(
4712: p_khr_id => p_term_rec.p_contract_id,
4713: p_primary_sty_purpose => 'AMBPOC', -- Quote Purchase Amount Purpose
4714: x_return_status => l_return_status,
4715: x_primary_sty_id => l_purchase_option_sty_id);

Line 4718: 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);

4714: x_return_status => l_return_status,
4715: x_primary_sty_id => l_purchase_option_sty_id);
4716:
4717: IF (is_debug_statement_on) THEN
4718: 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);
4719: END IF;
4720:
4721: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
4722: AND (l_purchase_option_sty_id IS NULL OR l_purchase_option_sty_id = OKL_API.G_MISS_NUM) THEN

Line 6242: okl_streams stm

6238: SELECT okl_line.fee_type fee_type
6239: FROM okl_k_lines okl_line,
6240: okc_k_lines_b okc_line,
6241: okc_line_styles_b lse,
6242: okl_streams stm
6243: WHERE okl_line.id = okc_line.id AND
6244: okc_line.lse_id = lse.id AND lse.lty_code = 'FEE' AND
6245: okc_line.chr_id = p_khr_id AND
6246: stm.khr_id = okc_line.chr_id AND

Line 6282: okl_streams stm

6278: -- -- rmunjulu bug 4416094
6279: 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
6280: SELECT MAX(stream_element_date)
6281: FROM okl_strm_elements_v sel,
6282: okl_streams stm
6283: WHERE sel.stm_id = stm.id AND
6284: stm.sty_id IN (p_pretax_sty_id, p_rentaccrual_sty_id,
6285: p_interestincome_sty_id) AND stm.khr_id = p_khr_id;
6286: */

Line 6294: okl_streams stm

6290:
6291: CURSOR get_accel_till_csr(p_khr_id IN NUMBER, p_sty_id IN NUMBER) IS
6292: SELECT MAX(stream_element_date)
6293: FROM okl_strm_elements_v sel,
6294: okl_streams stm
6295: WHERE sel.stm_id = stm.id AND
6296: stm.sty_id = p_sty_id AND stm.khr_id = p_khr_id;
6297:
6298: -- Bug#7248153 - rbruno - changed - End

Line 7317: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,

7313: IF l_deal_type IN ('LEASEDF', 'LEASEST')
7314: THEN
7315: -- DF/ST Lease
7316: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
7317: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,
7318: 'RENT',
7319: 'LEASE_INCOME',
7320: l_return_status,
7321: lx_pretax_sty_id);

Line 7326: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,

7322: ELSIF l_deal_type = 'LEASEOP'
7323: THEN
7324: -- OP Lease
7325:
7326: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,
7327: 'RENT',
7328: 'RENT_ACCRUAL',
7329: l_return_status,
7330: lx_rentaccrual_sty_id);

Line 7340: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,

7336: THEN
7337: -- Loan
7338: -- 03-mar-06 sgorantl -- Bug 4931796
7339: -- rmunjulu bug 4416094
7340: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,
7341: 'RENT',
7342: 'INTEREST_INCOME',
7343: l_return_status,
7344: lx_interestincome_sty_id);

Line 7365: OKL_STREAMS_UTIL.get_dependent_stream_type(p_term_rec.p_contract_id,

7361: FOR primary_sty_id_rec in primary_sty_id_csr(p_term_rec.p_contract_id) LOOP
7362:
7363:
7364:
7365: OKL_STREAMS_UTIL.get_dependent_stream_type(p_term_rec.p_contract_id,
7366: primary_sty_id_rec.Primary_sty_id,
7367: 'AMORTIZED_FEE_EXPENSE',
7368: l_return_status,
7369: lx_sty_id);

Line 7383: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,

7379:
7380: -- Added by ansethur for bug#6156337 08-Aug-2007 end
7381: /* commented by ansethur for bug#6156337 08-Aug-2007 start
7382: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
7383: okl_streams_util.get_dependent_stream_type(p_term_rec.p_contract_id,
7384: 'EXPENSE',
7385: 'AMORTIZED_FEE_EXPENSE',
7386: l_return_status,
7387: lx_sty_id);

Line 7448: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

7444: RAISE okl_api.g_exception_error;
7445: END IF;
7446:
7447: -- Start MGAAP 7263041
7448: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
7449: okl_streams_util.get_dependent_stream_type_rep(
7450: p_term_rec.p_contract_id,
7451: 'EXPENSE',
7452: 'AMORTIZED_FEE_EXPENSE',

Line 7449: okl_streams_util.get_dependent_stream_type_rep(

7445: END IF;
7446:
7447: -- Start MGAAP 7263041
7448: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
7449: okl_streams_util.get_dependent_stream_type_rep(
7450: p_term_rec.p_contract_id,
7451: 'EXPENSE',
7452: 'AMORTIZED_FEE_EXPENSE',
7453: l_return_status,

Line 7469: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

7465: p_acceleration_rec => l_acceleration_rec,
7466: p_representation_type => 'SECONDARY',
7467: x_trx_number => l_trx_number);
7468:
7469: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
7470:
7471: IF (is_debug_statement_on) THEN
7472: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_GENERATE_ACCRUALS_PVT.accelerate_accruals , return status : ' || l_return_status);
7473: END IF;