APPS.OKL_AM_RV_WRITEDOWN_PVT dependencies on OKL_TXL_ASSETS_V

Line 10: -- OKL_TXL_ASSETS_V

6: -- Procedure Name : create_residual_value_trx
7: -- Description : The main body of the package. This procedure gets a table of line ids along with the new
8: -- residual values as parameter. It then validates the new RV to make sure that it is less than
9: -- the current RV and then creates residual value transactions in OKL_TRX_ASSETS_V and
10: -- OKL_TXL_ASSETS_V
11: -- Business Rules :
12: -- Parameters : p_assets_tbl
13: -- History : SECHAWLA 24-DEC-02 : Bug # 2726739
14: -- Added logic to store currency codes and conversion factors

Line 84: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l

80: -- This cursor is used to check if a pending residual value writedown transaction already exists for a contract.
81: -- Included ERROR for Bug# 7014234
82: CURSOR l_assettrx_csr(p_khr_id NUMBER) IS
83: SELECT count(*)
84: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l
85: WHERE h.id = l.tas_id
86: AND h.tsu_code IN ('ENTERED', 'ERROR')
87: AND h.tas_type = 'ARC'
88: AND l.dnz_khr_id = p_khr_id;

Line 162: -- in okl_trx_assets_v and okl_txl_assets_v

158:
159: i := p_assets_tbl.FIRST;
160: -- loop thru the table of records receieved as input. For each record get the line item information from
161: -- cursor l_linesfullv_csr. Validate the input data and then create transaction header and transaction line records
162: -- in okl_trx_assets_v and okl_txl_assets_v
163: LOOP
164: IF p_assets_tbl(i).p_id IS NULL OR p_assets_tbl(i).p_id = OKL_API.G_MISS_NUM THEN
165: l_record_status := OKL_API.G_RET_STS_ERROR;
166: -- Line id is required