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_AMORTIZE_PVT dependencies on OKL_TRX_ASSETS

Line 369: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

365: -- RRAVIKIR Legal Entity Changes
366: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
367: -- Legal Entity Changes End
368:
369: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
370: p_init_msg_list => OKL_API.G_FALSE,
371: x_return_status => x_return_status,
372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data,

Line 518: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

514: -- RRAVIKIR Legal Entity Changes
515: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
516: -- Legal Entity Changes End
517:
518: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
519: p_init_msg_list => OKL_API.G_FALSE,
520: x_return_status => x_return_status,
521: x_msg_count => x_msg_count,
522: x_msg_data => x_msg_data,

Line 664: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

660: -- RRAVIKIR Legal Entity Changes
661: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
662: -- Legal Entity Changes End
663:
664: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
665: p_init_msg_list => OKL_API.G_FALSE,
666: x_return_status => x_return_status,
667: x_msg_count => x_msg_count,
668: x_msg_data => x_msg_data,

Line 790: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

786: -- RRAVIKIR Legal Entity Changes
787: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
788: -- Legal Entity Changes End
789:
790: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
791: p_init_msg_list => OKL_API.G_FALSE,
792: x_return_status => x_return_status,
793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data,

Line 933: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

929: -- RRAVIKIR Legal Entity Changes
930: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
931: -- Legal Entity Changes End
932:
933: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
934: p_init_msg_list => OKL_API.G_FALSE,
935: x_return_status => x_return_status,
936: x_msg_count => x_msg_count,
937: x_msg_data => x_msg_data,

Line 1334: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

1330: -- RRAVIKIR Legal Entity Changes
1331: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
1332: -- Legal Entity Changes End
1333:
1334: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
1335: p_init_msg_list => OKL_API.G_FALSE,
1336: x_return_status => x_return_status,
1337: x_msg_count => x_msg_count,
1338: x_msg_data => x_msg_data,

Line 1468: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

1464: -- RRAVIKIR Legal Entity Changes
1465: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
1466: -- Legal Entity Changes End
1467:
1468: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
1469: p_init_msg_list => OKL_API.G_FALSE,
1470: x_return_status => x_return_status,
1471: x_msg_count => x_msg_count,
1472: x_msg_data => x_msg_data,

Line 1610: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

1606: -- RRAVIKIR Legal Entity Changes
1607: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
1608: -- Legal Entity Changes End
1609:
1610: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
1611: p_init_msg_list => OKL_API.G_FALSE,
1612: x_return_status => x_return_status,
1613: x_msg_count => x_msg_count,
1614: x_msg_data => x_msg_data,

Line 1789: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

1785: -- RRAVIKIR Legal Entity Changes
1786: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
1787: -- Legal Entity Changes End
1788:
1789: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
1790: p_init_msg_list => OKL_API.G_FALSE,
1791: x_return_status => x_return_status,
1792: x_msg_count => x_msg_count,
1793: x_msg_data => x_msg_data,

Line 1924: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

1920: -- RRAVIKIR Legal Entity Changes
1921: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
1922: -- Legal Entity Changes End
1923:
1924: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
1925: p_init_msg_list => OKL_API.G_FALSE,
1926: x_return_status => x_return_status,
1927: x_msg_count => x_msg_count,
1928: x_msg_data => x_msg_data,

Line 2096: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

2092: -- RRAVIKIR Legal Entity Changes
2093: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
2094: -- Legal Entity Changes End
2095:
2096: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
2097: p_init_msg_list => OKL_API.G_FALSE,
2098: x_return_status => x_return_status,
2099: x_msg_count => x_msg_count,
2100: x_msg_data => x_msg_data,

Line 2495: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

2491: -- RRAVIKIR Legal Entity Changes
2492: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
2493: -- Legal Entity Changes End
2494:
2495: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
2496: p_init_msg_list => OKL_API.G_FALSE,
2497: x_return_status => x_return_status,
2498: x_msg_count => x_msg_count,
2499: x_msg_data => x_msg_data,

Line 2623: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

2619: -- RRAVIKIR Legal Entity Changes
2620: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
2621: -- Legal Entity Changes End
2622:
2623: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
2624: p_init_msg_list => OKL_API.G_FALSE,
2625: x_return_status => x_return_status,
2626: x_msg_count => x_msg_count,
2627: x_msg_data => x_msg_data,

Line 2755: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

2751: -- RRAVIKIR Legal Entity Changes
2752: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
2753: -- Legal Entity Changes End
2754:
2755: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
2756: p_init_msg_list => OKL_API.G_FALSE,
2757: x_return_status => x_return_status,
2758: x_msg_count => x_msg_count,
2759: x_msg_data => x_msg_data,

Line 2932: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

2928: -- RRAVIKIR Legal Entity Changes
2929: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
2930: -- Legal Entity Changes End
2931:
2932: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
2933: p_init_msg_list => OKL_API.G_FALSE,
2934: x_return_status => x_return_status,
2935: x_msg_count => x_msg_count,
2936: x_msg_data => x_msg_data,

Line 3061: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

3057: -- RRAVIKIR Legal Entity Changes
3058: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
3059: -- Legal Entity Changes End
3060:
3061: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
3062: p_init_msg_list => OKL_API.G_FALSE,
3063: x_return_status => x_return_status,
3064: x_msg_count => x_msg_count,
3065: x_msg_data => x_msg_data,

Line 3232: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,

3228: -- RRAVIKIR Legal Entity Changes
3229: lp_thpv_rec.legal_entity_id := p_legal_entity_id;
3230: -- Legal Entity Changes End
3231:
3232: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def( p_api_version => p_api_version,
3233: p_init_msg_list => OKL_API.G_FALSE,
3234: x_return_status => x_return_status,
3235: x_msg_count => x_msg_count,
3236: x_msg_data => x_msg_data,

Line 3393: -- header- okl_trx_assets_v and transaction lines- okl_txl_assets_v with amortization transactions

3389: -- Start of comments
3390: --
3391: -- Procedure Name : create_offlease_asset_trx
3392: -- Description : This procedure populates the transaction
3393: -- header- okl_trx_assets_v and transaction lines- okl_txl_assets_v with amortization transactions
3394: -- for off-lease assets for a particular financial asset
3395: -- Business Rules :
3396: -- Parameters : p_kle_id - Finacial Asset id
3397: -- p_early_termination_yn - early termination / end of term flag

Line 4781: -- This cursor returns the transaction date from okl_trx_assets_v

4777: lp_lines_temp_rec tlpv_rec_type;
4778: l_api_version CONSTANT NUMBER := 1;
4779: l_sysdate DATE;
4780:
4781: -- This cursor returns the transaction date from okl_trx_assets_v
4782: CURSOR l_hdrtransdate_csr(p_id number) IS
4783: SELECT DATE_TRANS_OCCURRED
4784: FROM okl_trx_assets -- SECHAWLA 24-FEB-05 4147143 : changed view to base table
4785: WHERE id = p_id;

Line 4784: FROM okl_trx_assets -- SECHAWLA 24-FEB-05 4147143 : changed view to base table

4780:
4781: -- This cursor returns the transaction date from okl_trx_assets_v
4782: CURSOR l_hdrtransdate_csr(p_id number) IS
4783: SELECT DATE_TRANS_OCCURRED
4784: FROM okl_trx_assets -- SECHAWLA 24-FEB-05 4147143 : changed view to base table
4785: WHERE id = p_id;
4786:
4787: -- SECHAWLA 24-FEB-05 4147143 : added kle_id, tal_type
4788: -- SECHAWLA 27-FEB-05 4147143 : added asset book

Line 4803: FROM okl_trx_assets h, okl_txl_assets_b l, OKL_TXD_ASSETS_B d

4799: -- get the first 2 transaction lines
4800: -- SECHAWLA 27-FEB-05 4147143 : added check for book and status
4801: CURSOR l_nodeplines_csr(cp_kle_id IN NUMBER, cp_book_type_code IN VARCHAR2) IS
4802: SELECT l.id, l.tas_id
4803: FROM okl_trx_assets h, okl_txl_assets_b l, OKL_TXD_ASSETS_B d
4804: WHERE l.kle_id = cp_kle_id
4805: AND l.tas_id = h.id
4806: AND h.tsu_code IN ( 'ENTERED','ERROR')
4807: AND l.tal_type IN ('AUF','AUT')

Line 4816: FROM okl_trx_assets hdr, okl_txl_assets_b line, OKL_TXD_ASSETS_B txd

4812: -- Get the 4th transaction
4813: -- SECHAWLA 27-FEB-05 4147143 : added check for book and status
4814: CURSOR l_depstartline_csr(cp_kle_id IN NUMBER, cp_book_type_code IN VARCHAR2) IS
4815: SELECT hdr.id hdr_id ,line.id line_id
4816: FROM okl_trx_assets hdr, okl_txl_assets_b line, OKL_TXD_ASSETS_B txd
4817: WHERE line.kle_id = cp_kle_id
4818: AND line.tas_id = hdr.id
4819: AND hdr.tsu_code IN ( 'ENTERED','ERROR')
4820: AND tal_type = 'AUF'

Line 4830: FROM okl_trx_assets h, okl_txl_assets_b l, OKL_TXD_ASSETS_B d

4826: -- get the 3rd transaction header
4827: -- SECHAWLA 27-FEB-05 4147143 : added check for book and status
4828: CURSOR l_amortline_csr(cp_kle_id IN NUMBER, cp_book_type_code IN VARCHAR2) IS
4829: SELECT h.DATE_TRANS_OCCURRED
4830: FROM okl_trx_assets h, okl_txl_assets_b l, OKL_TXD_ASSETS_B d
4831: WHERE l.kle_id = cp_kle_id
4832: AND l.tas_id = h.id
4833: AND h.tsu_code IN ( 'ENTERED','ERROR')
4834: AND l.tal_type = 'AML'

Line 5010: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

5006: lp_lines_temp_rec.hold_period_days := NULL;
5007: END IF;
5008: -- SECHAWLA 24-FEB-05 4147143 : end
5009:
5010: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
5011: p_api_version => p_api_version,
5012: p_init_msg_list => OKL_API.G_FALSE,
5013: x_return_status => x_return_status,
5014: x_msg_count => x_msg_count,

Line 5053: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

5049: FOR l_nodeplines_rec IN l_nodeplines_csr(l_kle_id, l_booktype_code) LOOP -- SECHAWLA 27-FEB-05 4147143 : added booktype_code
5050: lp_header_rec.id := l_nodeplines_rec.tas_id;
5051: lp_header_rec.tsu_code := 'CANCELED';
5052:
5053: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
5054: p_api_version => p_api_version,
5055: p_init_msg_list => OKL_API.G_FALSE,
5056: x_return_status => x_return_status,
5057: x_msg_count => x_msg_count,

Line 5102: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

5098: -- update header
5099: lp_header_rec.id := l_depstartline_rec.hdr_id;
5100: lp_header_rec.date_trans_occurred := trunc(p_header_rec.date_trans_occurred);
5101:
5102: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
5103: p_api_version => p_api_version,
5104: p_init_msg_list => OKL_API.G_FALSE,
5105: x_return_status => x_return_status,
5106: x_msg_count => x_msg_count,

Line 5271: -- This cursor returns the transaction date from okl_trx_assets_v

5267: l_new_trans_date DATE;
5268: l_api_version CONSTANT NUMBER := 1;
5269: l_sysdate DATE;
5270: i NUMBER;
5271: -- This cursor returns the transaction date from okl_trx_assets_v
5272: CURSOR l_hdrtransdate_csr(p_id NUMBER) IS
5273: SELECT DATE_TRANS_OCCURRED
5274: FROM OKL_TRX_ASSETS
5275: WHERE id = p_id;

Line 5274: FROM OKL_TRX_ASSETS

5270: i NUMBER;
5271: -- This cursor returns the transaction date from okl_trx_assets_v
5272: CURSOR l_hdrtransdate_csr(p_id NUMBER) IS
5273: SELECT DATE_TRANS_OCCURRED
5274: FROM OKL_TRX_ASSETS
5275: WHERE id = p_id;
5276:
5277: -- This cursor returns the transaction line information from okl_txl_assets_v
5278: CURSOR l_lines_csr(p_id number) IS

Line 5322: -- loop thru all the records in the input table, validate data an then update okl_trx_assets_v and

5318:
5319: IF p_header_tbl.count > 0 THEN
5320: i := p_header_tbl.FIRST;
5321:
5322: -- loop thru all the records in the input table, validate data an then update okl_trx_assets_v and
5323: -- okl_txl_assets_v
5324: LOOP
5325:
5326: l_date_valid_yn := 'Y';

Line 5421: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

5417: END IF; -- << LABEL 3 >>
5418:
5419:
5420: IF l_date_valid_yn = 'Y' THEN
5421: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
5422: p_api_version => p_api_version,
5423: p_init_msg_list => OKL_API.G_FALSE,
5424: x_return_status => x_return_status,
5425: x_msg_count => x_msg_count,

Line 5548: FROM OKL_TRX_ASSETS TAS

5544: SELECT TAS.id,
5545: TAS.tsu_code,
5546: TAS.tas_type,
5547: TAS.date_trans_occurred
5548: FROM OKL_TRX_ASSETS TAS
5549: WHERE TAS.id = p_id;
5550:
5551: -- Check the Dep Method and Life In months
5552: CURSOR dep_csr (p_dep_method IN VARCHAR2, p_life_in_months IN NUMBER) IS

Line 5593: l_tsu_code OKL_TRX_ASSETS.tsu_code%TYPE;

5589: l_api_name VARCHAR2(30);
5590: l_api_version NUMBER;
5591:
5592: l_id NUMBER;
5593: l_tsu_code OKL_TRX_ASSETS.tsu_code%TYPE;
5594: l_tas_type OKL_TRX_ASSETS.tas_type%TYPE;
5595: l_date_trn OKL_TRX_ASSETS.date_trans_occurred%TYPE;
5596: l_val FA_METHODS.method_code%TYPE;
5597: l_line_id NUMBER;

Line 5594: l_tas_type OKL_TRX_ASSETS.tas_type%TYPE;

5590: l_api_version NUMBER;
5591:
5592: l_id NUMBER;
5593: l_tsu_code OKL_TRX_ASSETS.tsu_code%TYPE;
5594: l_tas_type OKL_TRX_ASSETS.tas_type%TYPE;
5595: l_date_trn OKL_TRX_ASSETS.date_trans_occurred%TYPE;
5596: l_val FA_METHODS.method_code%TYPE;
5597: l_line_id NUMBER;
5598:

Line 5595: l_date_trn OKL_TRX_ASSETS.date_trans_occurred%TYPE;

5591:
5592: l_id NUMBER;
5593: l_tsu_code OKL_TRX_ASSETS.tsu_code%TYPE;
5594: l_tas_type OKL_TRX_ASSETS.tas_type%TYPE;
5595: l_date_trn OKL_TRX_ASSETS.date_trans_occurred%TYPE;
5596: l_val FA_METHODS.method_code%TYPE;
5597: l_line_id NUMBER;
5598:
5599: lp_header_rec thpv_rec_type;