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 3381: lp_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

3377: WHERE id = p_term_rec.p_contract_id;
3378:
3379: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3380: l_api_name VARCHAR2(30) := 'process_evergreen_deprn';
3381: lp_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
3382: lx_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
3383: lp_tlpv_rec tlpv_rec_type;
3384: lx_tlpv_rec tlpv_rec_type;
3385: l_try_id NUMBER;

Line 3382: lx_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

3378:
3379: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3380: l_api_name VARCHAR2(30) := 'process_evergreen_deprn';
3381: lp_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
3382: lx_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
3383: lp_tlpv_rec tlpv_rec_type;
3384: lx_tlpv_rec tlpv_rec_type;
3385: l_try_id NUMBER;
3386: l_method_id FA_METHODS.method_id%TYPE;

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

3483:
3484: -- scenario 8 - Direct Finance Lease expiration with NO hold period
3485: -- loop thru all the records from okx_asset_lines_v where
3486: -- contract id matches p_contract_id, validate the data
3487: -- and then create transaction header and line in okl_trx_assets_v and
3488: -- okl_txl_assets_v
3489: FOR l_lines_rec IN l_linesv_csr LOOP
3490: l_line_status := NULL;
3491: -- validate data before creating the transaction line.

Line 3546: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

3542: END IF;
3543: lp_thpv_rec.try_id := l_try_id;
3544: lp_thpv_rec.date_trans_occurred := p_sys_date;
3545:
3546: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
3547: p_api_version => p_api_version,
3548: p_init_msg_list => p_init_msg_list,
3549: x_return_status => x_return_status,
3550: x_msg_count => x_msg_count,

Line 7822: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,

7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
7819: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
7820: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
7821: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
7822: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
7823: p_line_number IN NUMBER,
7824: p_quote_id IN NUMBER,
7825: x_return_status OUT NOCOPY VARCHAR2,
7826: x_msg_count OUT NOCOPY NUMBER,

Line 8302: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,

8298: p_init_msg_list IN VARCHAR2,
8299: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8300: p_kle_id IN OKL_K_LINES.ID%TYPE,
8301: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8302: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8303: p_tal_id IN NUMBER,
8304: p_line_type IN VARCHAR2,
8305: p_fa_trx_id IN NUMBER,
8306: p_asset_id IN NUMBER,

Line 8319: FROM OKL_TRX_ASSETS

8315: l_pkg_name VARCHAR2(30) := 'OKL_AM_LEASE_TRMNT_PVT';
8316:
8317: CURSOR c_try_id(p_tas_id IN NUMBER) IS
8318: SELECT try_id
8319: FROM OKL_TRX_ASSETS
8320: WHERE id = p_tas_id;
8321:
8322: --Cursor for quote details
8323: CURSOR c_quote_details(p_quote_id IN NUMBER) IS

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

8362: CLOSE c_quote_details;
8363:
8364: -- header record
8365: l_fxhv_rec.source_id := p_tas_id;
8366: l_fxhv_rec.source_table := 'OKL_TRX_ASSETS';
8367: l_fxhv_rec.khr_id := p_khr_id;
8368: l_fxhv_rec.try_id := l_try_id;
8369: l_fxhv_rec.term_quote_type_code := l_quote_type_code;
8370: l_fxhv_rec.term_quote_num := l_quote_num;

Line 8418: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,

8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8415: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
8416: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
8417: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
8418: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8419: p_line_number IN NUMBER,
8420: p_quote_id IN NUMBER,
8421: x_return_status OUT NOCOPY VARCHAR2,
8422: x_msg_count OUT NOCOPY NUMBER,

Line 9333: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

9329: RAISE OKL_API.G_EXCEPTION_ERROR;
9330: END IF;
9331:
9332: /*-- Now creating the new header record
9333: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
9334: p_api_version => p_api_version,
9335: p_init_msg_list => p_init_msg_list,
9336: x_return_status => x_return_status,
9337: x_msg_count => x_msg_count,

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

9353: -- Bug 6674730 start
9354: IF (l_repo_yn = 'Y' AND l_deal_type='LOAN') THEN
9355:
9356: IF (is_debug_statement_on) THEN
9357: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_TRX_ASSETS_PUB.create_trx_ass_h_def');
9358: END IF;
9359:
9360: -- Now creating the new header record
9361: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

Line 9361: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

9357: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_TRX_ASSETS_PUB.create_trx_ass_h_def');
9358: END IF;
9359:
9360: -- Now creating the new header record
9361: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
9362: p_api_version => p_api_version,
9363: p_init_msg_list => p_init_msg_list,
9364: x_return_status => x_return_status,
9365: x_msg_count => x_msg_count,

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

9366: x_msg_data => x_msg_data,
9367: p_thpv_rec => l_trxv_rec,
9368: x_thpv_rec => x_trxv_rec);
9369: IF (is_debug_statement_on) THEN
9370: 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);
9371: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'x_trxv_rec.ID =' ||x_trxv_rec.ID);
9372: END IF;
9373:
9374: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN