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_TRX_ASSETS

Line 11: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;

7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_am_lease_trmnt_pvt.';
9:
10: /* Bug 6674730 start */
11: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
12: subtype talv_rec_type is OKL_TXL_ASSETS_PUB.tlpv_rec_type;
13: subtype adpv_rec_type is okl_txd_assets_pvt.advv_rec_type;
14:
15: G_TRANS_TYPE VARCHAR2(3) := 'CFA';

Line 3497: lp_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

3493: WHERE id = p_term_rec.p_contract_id;
3494:
3495: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3496: l_api_name VARCHAR2(30) := 'process_evergreen_deprn';
3497: lp_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
3498: lx_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
3499: lp_tlpv_rec tlpv_rec_type;
3500: lx_tlpv_rec tlpv_rec_type;
3501: l_try_id NUMBER;

Line 3498: lx_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

3494:
3495: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3496: l_api_name VARCHAR2(30) := 'process_evergreen_deprn';
3497: lp_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
3498: lx_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
3499: lp_tlpv_rec tlpv_rec_type;
3500: lx_tlpv_rec tlpv_rec_type;
3501: l_try_id NUMBER;
3502: l_method_id FA_METHODS.method_id%TYPE;

Line 3603: -- and then create transaction header and line in okl_trx_assets_v and

3599:
3600: -- scenario 8 - Direct Finance Lease expiration with NO hold period
3601: -- loop thru all the records from okx_asset_lines_v where
3602: -- contract id matches p_contract_id, validate the data
3603: -- and then create transaction header and line in okl_trx_assets_v and
3604: -- okl_txl_assets_v
3605: FOR l_lines_rec IN l_linesv_csr LOOP
3606: l_line_status := NULL;
3607: -- validate data before creating the transaction line.

Line 3662: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

3658: END IF;
3659: lp_thpv_rec.try_id := l_try_id;
3660: lp_thpv_rec.date_trans_occurred := p_sys_date;
3661:
3662: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
3663: p_api_version => p_api_version,
3664: p_init_msg_list => p_init_msg_list,
3665: x_return_status => x_return_status,
3666: x_msg_count => x_msg_count,

Line 8021: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,

8017: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8018: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
8019: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
8020: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
8021: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8022: p_line_number IN NUMBER,
8023: p_quote_id IN NUMBER,
8024: x_return_status OUT NOCOPY VARCHAR2,
8025: x_msg_count OUT NOCOPY NUMBER,

Line 8501: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,

8497: p_init_msg_list IN VARCHAR2,
8498: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8499: p_kle_id IN OKL_K_LINES.ID%TYPE,
8500: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8501: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8502: p_tal_id IN NUMBER,
8503: p_line_type IN VARCHAR2,
8504: p_fa_trx_id IN NUMBER,
8505: p_asset_id IN NUMBER,

Line 8518: FROM OKL_TRX_ASSETS

8514: l_pkg_name VARCHAR2(30) := 'OKL_AM_LEASE_TRMNT_PVT';
8515:
8516: CURSOR c_try_id(p_tas_id IN NUMBER) IS
8517: SELECT try_id
8518: FROM OKL_TRX_ASSETS
8519: WHERE id = p_tas_id;
8520:
8521: --Cursor for quote details
8522: CURSOR c_quote_details(p_quote_id IN NUMBER) IS

Line 8565: l_fxhv_rec.source_table := 'OKL_TRX_ASSETS';

8561: CLOSE c_quote_details;
8562:
8563: -- header record
8564: l_fxhv_rec.source_id := p_tas_id;
8565: l_fxhv_rec.source_table := 'OKL_TRX_ASSETS';
8566: l_fxhv_rec.khr_id := p_khr_id;
8567: l_fxhv_rec.try_id := l_try_id;
8568: l_fxhv_rec.term_quote_type_code := l_quote_type_code;
8569: l_fxhv_rec.term_quote_num := l_quote_num;

Line 8617: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,

8613: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8614: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
8615: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
8616: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
8617: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8618: p_line_number IN NUMBER,
8619: p_quote_id IN NUMBER,
8620: x_return_status OUT NOCOPY VARCHAR2,
8621: x_msg_count OUT NOCOPY NUMBER,

Line 9532: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

9528: RAISE OKL_API.G_EXCEPTION_ERROR;
9529: END IF;
9530:
9531: /*-- Now creating the new header record
9532: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
9533: p_api_version => p_api_version,
9534: p_init_msg_list => p_init_msg_list,
9535: x_return_status => x_return_status,
9536: x_msg_count => x_msg_count,

Line 9556: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_TRX_ASSETS_PUB.create_trx_ass_h_def');

9552: -- Bug 6674730 start
9553: IF (l_repo_yn = 'Y' AND l_deal_type='LOAN') THEN
9554:
9555: IF (is_debug_statement_on) THEN
9556: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_TRX_ASSETS_PUB.create_trx_ass_h_def');
9557: END IF;
9558:
9559: -- Now creating the new header record
9560: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

Line 9560: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

9556: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_TRX_ASSETS_PUB.create_trx_ass_h_def');
9557: END IF;
9558:
9559: -- Now creating the new header record
9560: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
9561: p_api_version => p_api_version,
9562: p_init_msg_list => p_init_msg_list,
9563: x_return_status => x_return_status,
9564: x_msg_count => x_msg_count,

Line 9569: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_TRX_ASSETS_PUB.create_trx_ass_h_def x_return_status = '||x_return_status);

9565: x_msg_data => x_msg_data,
9566: p_thpv_rec => l_trxv_rec,
9567: x_thpv_rec => x_trxv_rec);
9568: IF (is_debug_statement_on) THEN
9569: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_TRX_ASSETS_PUB.create_trx_ass_h_def x_return_status = '||x_return_status);
9570: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'x_trxv_rec.ID =' ||x_trxv_rec.ID);
9571: END IF;
9572:
9573: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN