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 324: -- update the staus (tsu_code) in okl_trx_assets_v

320: p_token1 => 'ASSET_NUMBER',
321: p_token1_value => l_assettrx_rec.asset_number);
322: l_transaction_status := l_return_status;
323: ELSE
324: -- update the staus (tsu_code) in okl_trx_assets_v
325: lp_thpv_rec.id := l_assettrx_rec.id;
326: lp_thpv_rec.tsu_code := 'PROCESSED';
327: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
328: p_api_version => p_api_version,

Line 327: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

323: ELSE
324: -- update the staus (tsu_code) in okl_trx_assets_v
325: lp_thpv_rec.id := l_assettrx_rec.id;
326: lp_thpv_rec.tsu_code := 'PROCESSED';
327: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
328: p_api_version => p_api_version,
329: p_init_msg_list => OKC_API.G_FALSE,
330: x_return_status => l_return_status,
331: x_msg_count => x_msg_count,

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

370: END IF;
371: END IF;
372:
373: IF l_transaction_status <> OKC_API.G_RET_STS_SUCCESS THEN
374: -- update the staus (tsu_code) in okl_trx_assets_v
375: lp_thpv_rec.id := l_assettrx_rec.id;
376: lp_thpv_rec.tsu_code := 'ERROR';
377: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
378: p_api_version => p_api_version,

Line 377: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

373: IF l_transaction_status <> OKC_API.G_RET_STS_SUCCESS THEN
374: -- update the staus (tsu_code) in okl_trx_assets_v
375: lp_thpv_rec.id := l_assettrx_rec.id;
376: lp_thpv_rec.tsu_code := 'ERROR';
377: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
378: p_api_version => p_api_version,
379: p_init_msg_list => OKC_API.G_FALSE,
380: x_return_status => l_return_status,
381: x_msg_count => x_msg_count,