APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_TXL_ASSETS_V

Line 3172: FROM Okl_Txl_Assets_V

3168: CURRENCY_CONVERSION_TYPE,
3169: CURRENCY_CONVERSION_RATE,
3170: CURRENCY_CONVERSION_DATE
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

Line 3173: WHERE okl_txl_assets_v.kle_id = p_kle_id

3169: CURRENCY_CONVERSION_RATE,
3170: CURRENCY_CONVERSION_DATE
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

Line 3177: WHERE trx.id = okl_txl_assets_v.tas_id

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
3180: AND ttyp.name = 'Split Asset'
3181: AND ttyp.LANGUAGE = 'US');

Line 5731: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V

5727: --------------------------------------------------------------------------------
5728: --Start of Comments
5729: --API Name : Create_Split_Transaction
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

Line 6267: --Prepare txl record for insert into OKL_TXL_ASSETS_V

6263: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6264: RAISE OKL_API.G_EXCEPTION_ERROR;
6265: END IF;
6266:
6267: --Prepare txl record for insert into OKL_TXL_ASSETS_V
6268:
6269: IF l_fa_exists = 'Y' THEN
6270: l_txlv_rec.tas_id := x_trxv_rec.id;
6271: l_txlv_rec.kle_id := l_ast_line_rec.id1;

Line 6671: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V

6667: ------------------------------------------------------------------------------
6668: --Bug# 3156924
6669: --API Name : Create_Split_Transaction
6670: --Description : Process API to create Split Aseet Transaction Records in
6671: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
6672: --Note : Original split asset trx creation callo has been overloaded
6673: -- to include p_trx_date(trx_date) as parameter. This old
6674: -- signature preserved for backward compatability. It will
6675: -- create split asset transaction on SYSDATE

Line 6770: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V

6766: -------------------------------------------------------------------------------------
6767: --Bug# 3156924
6768: --API Name : Create_Split_Transaction
6769: --Description : Process API to create Split Aseet Transaction Records in
6770: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
6771: --Note : New signature added to accomodate p_trx_date being passed. This is
6772: -- the one called from the UI. This will create transactions in OKL
6773: -- _TXL_ITM_INSTS if the asset is serialized ad being split by units
6774: -- UI will mark the selected records as selected_for_split_flag = 'Y'

Line 6934: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V

6930: --------------------------------------------------------------------------------
6931: --Start of Comments
6932: --API Name : Create_Split_Transaction
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