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

Line 1162: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;

1158: l_inv_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
1159: l_inv_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
1160: l_trxv_rec trxv_rec_type;
1161: lx_trxv_rec trxv_rec_type;
1162: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;
1163: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := null; -- MGAAP
1164: l_trx_reason_asset_split VARCHAR2(20) := OKL_SECURITIZATION_PVT.G_TRX_REASON_ASSET_SPLIT;
1165:
1166: --Cursor to check whether split asset transaction is in progress for the contract

Line 1169: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas

1165:
1166: --Cursor to check whether split asset transaction is in progress for the contract
1167: CURSOR check_split_trx_csr IS
1168: SELECT tas.id
1169: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas
1170: WHERE txl.tal_type= 'ALI'
1171: AND txl.dnz_khr_id = p_chr_id
1172: AND txl.tas_id = tas.id
1173: AND tas.tas_type = 'ALI'

Line 1541: p_source_trx_id => l_split_trans_id, --,

1537: p_init_msg_list => p_init_msg_list,
1538: x_return_status => x_return_status,
1539: x_msg_count => x_msg_count,
1540: x_msg_data => x_msg_data,
1541: p_source_trx_id => l_split_trans_id, --,
1542: p_source_trx_name => 'Split Asset',
1543: p_source_table => 'OKL_TRX_ASSETS');
1544:
1545: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1543: p_source_table => 'OKL_TRX_ASSETS');

1539: x_msg_count => x_msg_count,
1540: x_msg_data => x_msg_data,
1541: p_source_trx_id => l_split_trans_id, --,
1542: p_source_trx_name => 'Split Asset',
1543: p_source_table => 'OKL_TRX_ASSETS');
1544:
1545: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1546: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1547: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1557: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

1553: ------------------------------------------------------------------------
1554:
1555: l_trxv_rec.id := l_split_trans_id;
1556: l_trxv_rec.tsu_code := 'PROCESSED';
1557: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
1558: p_api_version => p_api_version,
1559: p_init_msg_list => p_init_msg_list,
1560: x_return_status => x_return_status,
1561: x_msg_count => x_msg_count,

Line 2536: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l

2532:
2533: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2) IS
2534: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
2535: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
2536: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
2537: WHERE h.id = l.tas_id
2538: AND h.date_trans_occurred <= cp_trx_date
2539: AND h.tas_type in ('AMT','AUD','AUS')
2540: AND l.asset_number = cp_asset_number;

Line 3175: FROM okl_trx_Assets trx,

3171: -- Multi-Currency Change
3172: FROM Okl_Txl_Assets_V
3173: WHERE okl_txl_assets_v.kle_id = p_kle_id
3174: AND EXISTS (SELECT NULL
3175: FROM okl_trx_Assets trx,
3176: okl_trx_types_tl ttyp
3177: WHERE trx.id = okl_txl_assets_v.tas_id
3178: AND trx.tsu_code = 'ENTERED'
3179: AND trx.try_id = ttyp.id

Line 3426: FROM okl_trx_Assets trx,

3422: SELECT 'Y'
3423: FROM okl_txd_assets_b txd
3424: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number
3425: AND EXISTS (SELECT NULL
3426: FROM okl_trx_Assets trx,
3427: okl_trx_types_tl ttyp,
3428: okl_txl_assets_b txl
3429: WHERE trx.id = txl.tas_id
3430: AND trx.try_id = ttyp.id

Line 3513: okl_trx_assets trx

3509: SELECT 'Y'
3510: FROM okl_txd_assets_b txd,
3511: okl_txl_assets_b txl,
3512: okl_trx_types_tl ttyp,
3513: okl_trx_assets trx
3514: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number
3515: AND txd.tal_id = txl.id
3516: AND txl.tas_id = trx.id
3517: AND trx.try_id = ttyp.id

Line 3790: --Procedure to create transaction header (OKL_TRX_ASSETS_V)

3786: END IF;
3787: RETURN(l_return_status);
3788: END Get_fa_Location;
3789: --------------------------------------------------------------------------------
3790: --Procedure to create transaction header (OKL_TRX_ASSETS_V)
3791: --------------------------------------------------------------------------------
3792: PROCEDURE Create_trx_header(
3793: p_api_version IN NUMBER,
3794: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3818: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

3814: RAISE OKL_API.G_EXCEPTION_ERROR;
3815: END IF;
3816: -- evaluate conditions, build outcomes for true conditions and
3817: -- put them on outcome queue
3818: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
3819: p_api_version => p_api_version,
3820: p_init_msg_list => p_init_msg_list,
3821: x_return_status => x_return_status,
3822: x_msg_count => x_msg_count,

Line 3861: --PROCEDURE to update transaction_header (OKL_TRX_ASSETS_V)

3857: x_msg_data,
3858: '_PVT');
3859: END Create_trx_header;
3860: --------------------------------------------------------------------------------
3861: --PROCEDURE to update transaction_header (OKL_TRX_ASSETS_V)
3862: --------------------------------------------------------------------------------
3863: PROCEDURE Update_trx_header(
3864: p_api_version IN NUMBER,
3865: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3889: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

3885: RAISE OKL_API.G_EXCEPTION_ERROR;
3886: END IF;
3887: -- evaluate conditions, build outcomes for true conditions and
3888: -- put them on outcome queue
3889: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
3890: p_api_version => p_api_version,
3891: p_init_msg_list => p_init_msg_list,
3892: x_return_status => x_return_status,
3893: x_msg_count => x_msg_count,

Line 5734: -- 3. Create and save source record into okl_trx_assets_v

5730: --Description : Process API to create Split Aseet Transaction Records in
5731: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
5732: -- 1. Take the line details to be split
5733: -- 2. Set the status of the contract as inactive
5734: -- 3. Create and save source record into okl_trx_assets_v
5735: -- 4. Create and save target record into okl_txd_assets_v
5736: --History :
5737: -- 10-OCT-2001 avsingh Creation
5738: -- 12-Dec-2002 avsingh Overloaded the procedure to take p_srl_tbl

Line 5779: OKL_TRX_ASSETS tas

5775: --Bug# 3156924
5776: tas.DATE_TRANS_OCCURRED,
5777: tas.ID
5778: FROM OKL_TXL_ASSETS_B txl,
5779: OKL_TRX_ASSETS tas
5780: WHERE txl.kle_id = p_cle_id
5781: AND txl.tas_id = tas.id
5782: AND txl.tal_type = 'ALI'
5783: AND tas.tas_type = 'ALI'

Line 5799: l_trx_date okl_trx_assets.DATE_TRANS_OCCURRED%TYPE;

5795: l_split_into_ind_yn VARCHAR2(1) DEFAULT 'Z';
5796: l_split_units NUMBER DEFAULT 0;
5797: l_tal_id NUMBER;
5798: --Bug# 3156924
5799: l_trx_date okl_trx_assets.DATE_TRANS_OCCURRED%TYPE;
5800: l_tas_id okl_trx_assets.ID%TYPE;
5801:
5802:
5803: l_trxv_rec trxv_rec_type;

Line 5800: l_tas_id okl_trx_assets.ID%TYPE;

5796: l_split_units NUMBER DEFAULT 0;
5797: l_tal_id NUMBER;
5798: --Bug# 3156924
5799: l_trx_date okl_trx_assets.DATE_TRANS_OCCURRED%TYPE;
5800: l_tas_id okl_trx_assets.ID%TYPE;
5801:
5802:
5803: l_trxv_rec trxv_rec_type;
5804: l_txlv_rec txlv_rec_type;

Line 6454: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

6450: ------------------------------------------------
6451: --update transaction header for transaction date
6452: l_trxv_rec.id := l_tas_id;
6453: l_trxv_rec.date_trans_occurred := p_trx_date;
6454: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
6455: p_api_version => p_api_version,
6456: p_init_msg_list => p_init_msg_list,
6457: x_return_status => x_return_status,
6458: x_msg_count => x_msg_count,

Line 6937: -- 3. Create and save source record into okl_trx_assets_v

6933: --Description : Process API to create Split Aseet Transaction Records in
6934: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
6935: -- 1. Take the line details to be split
6936: -- 2. Set the status of the contract as inactive
6937: -- 3. Create and save source record into okl_trx_assets_v
6938: -- 4. Create and save target record into okl_txd_assets_v
6939: --Note : old signature kept for backward compatability. This will be the
6940: -- the one called from the UI. This will create transactions in OKL
6941: -- _TXL_ITM_INSTS if the asset is serialized ad being split by units

Line 10720: FROM OKL_TRX_ASSETS tas,

10716: l_amortization_start_date DATE:=NULL;
10717: -- CURSOR TO GET MAX OFF LEASE TRX DATESELECT
10718: Cursor tax_off_trx_amt(p_asset_id in number, p_tax_book in varchar2) is
10719: select tas.date_trans_occurred
10720: FROM OKL_TRX_ASSETS tas,
10721: OKL_TXL_ASSETS_B tal,
10722: OKL_TXD_ASSETS_B txl
10723: WHERE tas.id = tal.tas_id
10724: AND tal.id = txl.tal_id

Line 10732: FROM OKL_TRX_ASSETS tas,

10728: And tal.kle_id = p_asset_id;
10729: Cursor corp_off_trx_amt(p_asset_id in number, p_corp_book in varchar2) is
10730: SELECT
10731: tas.date_trans_occurred
10732: FROM OKL_TRX_ASSETS tas,
10733: OKL_TXL_ASSETS_B tal,
10734: OKL_TXD_ASSETS_B txd
10735: WHERE tas.id = tal.tas_id
10736: AND tal.corporate_book = P_corp_book

Line 10744: FROM OKL_TRX_ASSETS tas,

10740: AND tal.id = txd.tal_id(+)
10741: AND TAX_BOOK IS NULL ;
10742: Cursor tax_off_trx_aus(p_asset_id in number, p_tax_book in varchar2) is
10743: select tas.date_trans_occurred
10744: FROM OKL_TRX_ASSETS tas,
10745: OKL_TXL_ASSETS_B tal,
10746: OKL_TXD_ASSETS_B txl
10747: WHERE tas.id = tal.tas_id
10748: AND tal.id = txl.tal_id

Line 10756: FROM OKL_TRX_ASSETS tas,

10752: And tal.kle_id = p_asset_id;
10753: Cursor corp_off_trx_aus(p_asset_id in number, p_corp_book in varchar2) is
10754: SELECT
10755: tas.date_trans_occurred
10756: FROM OKL_TRX_ASSETS tas,
10757: OKL_TXL_ASSETS_B tal,
10758: OKL_TXD_ASSETS_B txd
10759: WHERE tas.id = tal.tas_id
10760: AND tal.corporate_book = P_corp_book

Line 10941: -- ID of source OKL_TRX_ASSETS record

10937: --History :
10938: -- 28-Nov-2001 ashish.singh Created
10939: -- Bug# 6373605 (OKL.R12.B SLA CRs
10940: -- p_sla_source_header_id IN Number,
10941: -- ID of source OKL_TRX_ASSETS record
10942: -- p_sla_source_header_table IN Varchar2,
10943: -- 'OKL_TRX_ASSETS'
10944: -- p_sla_source_try_id IN Number,
10945: -- OKL_TRX_ASSETS.try_id (transaction type id)

Line 10943: -- 'OKL_TRX_ASSETS'

10939: -- Bug# 6373605 (OKL.R12.B SLA CRs
10940: -- p_sla_source_header_id IN Number,
10941: -- ID of source OKL_TRX_ASSETS record
10942: -- p_sla_source_header_table IN Varchar2,
10943: -- 'OKL_TRX_ASSETS'
10944: -- p_sla_source_try_id IN Number,
10945: -- OKL_TRX_ASSETS.try_id (transaction type id)
10946: -- p_sla_source_line_id IN Number,
10947: -- ID of line table (OKL_TXL_ASSETS_B or

Line 10945: -- OKL_TRX_ASSETS.try_id (transaction type id)

10941: -- ID of source OKL_TRX_ASSETS record
10942: -- p_sla_source_header_table IN Varchar2,
10943: -- 'OKL_TRX_ASSETS'
10944: -- p_sla_source_try_id IN Number,
10945: -- OKL_TRX_ASSETS.try_id (transaction type id)
10946: -- p_sla_source_line_id IN Number,
10947: -- ID of line table (OKL_TXL_ASSETS_B or
10948: -- OKL_TXD_ASSETS_B
10949: -- p_sla_source_line_table IN Varchar2,

Line 14883: FROM OKL_TRX_ASSETS

14879: TRANS_NUMBER,
14880: --Bug# 6373605 start
14881: TRY_ID
14882: --Bug# 6373605 end
14883: FROM OKL_TRX_ASSETS
14884: WHERE id = ptrxid;
14885:
14886: l_trx_rec l_trx_csr%ROWTYPE;
14887:

Line 15191: p_sla_source_header_table => 'OKL_TRX_ASSETS',

15187: p_trx_date => l_trx_rec.date_trans_occurred,
15188: p_trx_number => l_trx_rec.trans_number,
15189: --Bug# 6373605--SLA populate source
15190: p_sla_source_header_id => l_txlv_rec.tas_id,
15191: p_sla_source_header_table => 'OKL_TRX_ASSETS',
15192: p_sla_source_try_id => l_trx_rec.try_id,
15193: p_sla_source_line_id => l_txlv_rec.id,
15194: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
15195: p_sla_source_chr_id => l_chr_id,

Line 15366: p_sla_source_header_table => 'OKL_TRX_ASSETS',

15362: p_trx_date => l_trx_rec.date_trans_occurred,
15363: p_trx_number => l_trx_rec.trans_number,
15364: --Bug# 6373605--SLA populate source
15365: p_sla_source_header_id => l_txlv_rec.tas_id,
15366: p_sla_source_header_table => 'OKL_TRX_ASSETS',
15367: p_sla_source_try_id => l_trx_rec.try_id,
15368: p_sla_source_line_id => l_txdv_rec.id,
15369: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',
15370: p_sla_source_chr_id => l_chr_id,

Line 15710: p_sla_source_header_table => 'OKL_TRX_ASSETS',

15706: p_trx_date => l_trx_rec.date_trans_occurred,
15707: p_trx_number => l_trx_rec.trans_number,
15708: --Bug# 6373605--SLA populate source
15709: p_sla_source_header_id => l_txlv_rec.tas_id,
15710: p_sla_source_header_table => 'OKL_TRX_ASSETS',
15711: p_sla_source_try_id => l_trx_rec.try_id,
15712: p_sla_source_line_id => l_txlv_rec.id,
15713: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
15714: p_sla_source_chr_id => l_chr_id,

Line 15954: p_source_trx_id => p_txlv_rec.tas_id, --,

15950: p_init_msg_list => p_init_msg_list,
15951: x_return_status => x_return_status,
15952: x_msg_count => x_msg_count,
15953: x_msg_data => x_msg_data,
15954: p_source_trx_id => p_txlv_rec.tas_id, --,
15955: p_source_trx_name => 'Split Asset',
15956: p_source_table => 'OKL_TRX_ASSETS');
15957:
15958: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 15956: p_source_table => 'OKL_TRX_ASSETS');

15952: x_msg_count => x_msg_count,
15953: x_msg_data => x_msg_data,
15954: p_source_trx_id => p_txlv_rec.tas_id, --,
15955: p_source_trx_name => 'Split Asset',
15956: p_source_table => 'OKL_TRX_ASSETS');
15957:
15958: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
15959: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
15960: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 15971: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

15967:
15968: --update the transaction record to processed.
15969: l_trxv_rec.id := p_txlv_rec.tas_id;
15970: l_trxv_rec.tsu_code := 'PROCESSED';
15971: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
15972: p_api_version => p_api_version,
15973: p_init_msg_list => p_init_msg_list,
15974: x_return_status => x_return_status,
15975: x_msg_count => x_msg_count,

Line 16166: FROM okl_trx_assets tasb

16162: CURSOR l_cle_tas_csr
16163: IS
16164: SELECT cleb.dnz_chr_id,
16165: tasb.date_trans_occurred
16166: FROM okl_trx_assets tasb
16167: ,okl_txl_assets_b txlb
16168: ,okc_k_lines_b cleb
16169: ,okc_line_styles_b lseb
16170: WHERE txlb.tas_id = tasb.id

Line 16501: FROM OKL_TRX_ASSETS TAS,

16497: --Cursor to find kle_id split transaction lines to be cancelled..
16498: CURSOR l_tal_csr(p_fixedasst_line IN NUMBER) IS
16499: SELECT tal.id tal_id,
16500: tas.id tas_id
16501: FROM OKL_TRX_ASSETS TAS,
16502: OKL_TXL_ASSETS_B TAL
16503: WHERE tas.id = tal.tas_id
16504: AND tas.tsu_code = 'ENTERED'
16505: AND tas.tas_type = 'ALI'

Line 16509: l_tas_id OKL_TRX_ASSETS.ID%TYPE;

16505: AND tas.tas_type = 'ALI'
16506: AND tal.tal_type = 'ALI'
16507: AND tal.kle_id = p_fixedasst_line;
16508:
16509: l_tas_id OKL_TRX_ASSETS.ID%TYPE;
16510: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
16511: l_cle_id OKC_K_LINES_B.ID%TYPE;
16512:
16513: l_tasv_rec okl_trx_assets_pub.thpv_rec_type;

Line 16513: l_tasv_rec okl_trx_assets_pub.thpv_rec_type;

16509: l_tas_id OKL_TRX_ASSETS.ID%TYPE;
16510: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
16511: l_cle_id OKC_K_LINES_B.ID%TYPE;
16512:
16513: l_tasv_rec okl_trx_assets_pub.thpv_rec_type;
16514: lx_tasv_rec okl_trx_assets_pub.thpv_rec_type;
16515:
16516: BEGIN
16517: -- Call start_activity to create savepoint, check compatibility

Line 16514: lx_tasv_rec okl_trx_assets_pub.thpv_rec_type;

16510: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
16511: l_cle_id OKC_K_LINES_B.ID%TYPE;
16512:
16513: l_tasv_rec okl_trx_assets_pub.thpv_rec_type;
16514: lx_tasv_rec okl_trx_assets_pub.thpv_rec_type;
16515:
16516: BEGIN
16517: -- Call start_activity to create savepoint, check compatibility
16518: -- and initialize message list

Line 16558: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

16554: --update the transaction status to cancelled
16555: l_tasv_rec.id := l_tas_id;
16556: l_tasv_rec.tsu_code := 'CANCELED';
16557: --update split transaction header
16558: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
16559: p_api_version => p_api_version,
16560: p_init_msg_list => p_init_msg_list,
16561: x_return_status => x_return_status,
16562: x_msg_count => x_msg_count,