APPS.OKL_AM_PROCESS_RV_TRX_PVT dependencies on OKL_TRX_ASSETS

Line 133: SUBTYPE thpv_rec_type IS okl_trx_assets_pub.thpv_rec_type;

129: x_processed_count OUT NOCOPY NUMBER,
130: x_error_count OUT NOCOPY NUMBER) IS
131:
132:
133: SUBTYPE thpv_rec_type IS okl_trx_assets_pub.thpv_rec_type;
134: SUBTYPE rbk_tbl_type IS okl_mass_rebook_pub.rbk_tbl_type;
135: SUBTYPE strm_lalevl_tbl_type IS okl_mass_rebook_pub.strm_lalevl_tbl_type;
136:
137:

Line 166: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l, okc_k_headers_b khr

162: CURSOR l_assettrx_csr(p_sysdate DATE) IS
163: SELECT h.id, h.tas_type, date_trans_occurred, depreciate_yn, dnz_asset_id, corporate_book, in_service_date,
164: deprn_method,life_in_months, nvl(depreciation_cost,0) depreciation_cost , asset_number, old_residual_value,
165: new_residual_value, kle_id, dnz_khr_id, contract_number, sts_code
166: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l, okc_k_headers_b khr
167: WHERE h.id = l.tas_id
168: AND h.tsu_code NOT IN ('PROCESSED')
169: AND h.tas_type = 'ARC'
170: AND khr.id = l.dnz_khr_id

Line 308: -- update the staus (tsu_code) in okl_trx_assets_v

304: p_token1 => 'ASSET_NUMBER',
305: p_token1_value => l_assettrx_rec.asset_number);
306: l_transaction_status := l_return_status;
307: ELSE
308: -- update the staus (tsu_code) in okl_trx_assets_v
309: lp_thpv_rec.id := l_assettrx_rec.id;
310: lp_thpv_rec.tsu_code := 'PROCESSED';
311: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
312: p_api_version => p_api_version,

Line 311: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

307: ELSE
308: -- update the staus (tsu_code) in okl_trx_assets_v
309: lp_thpv_rec.id := l_assettrx_rec.id;
310: lp_thpv_rec.tsu_code := 'PROCESSED';
311: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
312: p_api_version => p_api_version,
313: p_init_msg_list => OKC_API.G_FALSE,
314: x_return_status => l_return_status,
315: x_msg_count => x_msg_count,

Line 357: -- update the staus (tsu_code) in okl_trx_assets_v

353: END IF;
354: END IF;
355:
356: IF l_transaction_status <> OKC_API.G_RET_STS_SUCCESS THEN
357: -- update the staus (tsu_code) in okl_trx_assets_v
358: lp_thpv_rec.id := l_assettrx_rec.id;
359: lp_thpv_rec.tsu_code := 'ERROR';
360: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
361: p_api_version => p_api_version,

Line 360: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

356: IF l_transaction_status <> OKC_API.G_RET_STS_SUCCESS THEN
357: -- update the staus (tsu_code) in okl_trx_assets_v
358: lp_thpv_rec.id := l_assettrx_rec.id;
359: lp_thpv_rec.tsu_code := 'ERROR';
360: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
361: p_api_version => p_api_version,
362: p_init_msg_list => OKC_API.G_FALSE,
363: x_return_status => l_return_status,
364: x_msg_count => x_msg_count,