APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_TXL_ASSETS_V

Line 3200: FROM Okl_Txl_Assets_V

3196: CURRENCY_CONVERSION_TYPE,
3197: CURRENCY_CONVERSION_RATE,
3198: CURRENCY_CONVERSION_DATE
3199: -- Multi-Currency Change
3200: FROM Okl_Txl_Assets_V
3201: WHERE okl_txl_assets_v.kle_id = p_kle_id
3202: AND EXISTS (SELECT NULL
3203: FROM okl_trx_Assets trx,
3204: okl_trx_types_tl ttyp

Line 3201: WHERE okl_txl_assets_v.kle_id = p_kle_id

3197: CURRENCY_CONVERSION_RATE,
3198: CURRENCY_CONVERSION_DATE
3199: -- Multi-Currency Change
3200: FROM Okl_Txl_Assets_V
3201: WHERE okl_txl_assets_v.kle_id = p_kle_id
3202: AND EXISTS (SELECT NULL
3203: FROM okl_trx_Assets trx,
3204: okl_trx_types_tl ttyp
3205: WHERE trx.id = okl_txl_assets_v.tas_id

Line 3205: WHERE trx.id = okl_txl_assets_v.tas_id

3201: WHERE okl_txl_assets_v.kle_id = p_kle_id
3202: AND EXISTS (SELECT NULL
3203: FROM okl_trx_Assets trx,
3204: okl_trx_types_tl ttyp
3205: WHERE trx.id = okl_txl_assets_v.tas_id
3206: AND trx.tsu_code = 'ENTERED'
3207: AND trx.try_id = ttyp.id
3208: AND ttyp.name = 'Split Asset'
3209: AND ttyp.LANGUAGE = 'US');

Line 5759: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V

5755: --------------------------------------------------------------------------------
5756: --Start of Comments
5757: --API Name : Create_Split_Transaction
5758: --Description : Process API to create Split Aseet Transaction Records in
5759: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
5760: -- 1. Take the line details to be split
5761: -- 2. Set the status of the contract as inactive
5762: -- 3. Create and save source record into okl_trx_assets_v
5763: -- 4. Create and save target record into okl_txd_assets_v

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

6316: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6317: RAISE OKL_API.G_EXCEPTION_ERROR;
6318: END IF;
6319:
6320: --Prepare txl record for insert into OKL_TXL_ASSETS_V
6321:
6322: IF l_fa_exists = 'Y' THEN
6323: l_txlv_rec.tas_id := x_trxv_rec.id;
6324: l_txlv_rec.kle_id := l_ast_line_rec.id1;

Line 6724: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V

6720: ------------------------------------------------------------------------------
6721: --Bug# 3156924
6722: --API Name : Create_Split_Transaction
6723: --Description : Process API to create Split Aseet Transaction Records in
6724: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
6725: --Note : Original split asset trx creation callo has been overloaded
6726: -- to include p_trx_date(trx_date) as parameter. This old
6727: -- signature preserved for backward compatability. It will
6728: -- create split asset transaction on SYSDATE

Line 6823: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V

6819: -------------------------------------------------------------------------------------
6820: --Bug# 3156924
6821: --API Name : Create_Split_Transaction
6822: --Description : Process API to create Split Aseet Transaction Records in
6823: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
6824: --Note : New signature added to accomodate p_trx_date being passed. This is
6825: -- the one called from the UI. This will create transactions in OKL
6826: -- _TXL_ITM_INSTS if the asset is serialized ad being split by units
6827: -- UI will mark the selected records as selected_for_split_flag = 'Y'

Line 6987: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V

6983: --------------------------------------------------------------------------------
6984: --Start of Comments
6985: --API Name : Create_Split_Transaction
6986: --Description : Process API to create Split Aseet Transaction Records in
6987: -- OKL_TXL_ASSETS_V and OKL_TXD_ASSETS_V
6988: -- 1. Take the line details to be split
6989: -- 2. Set the status of the contract as inactive
6990: -- 3. Create and save source record into okl_trx_assets_v
6991: -- 4. Create and save target record into okl_txd_assets_v