APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_ASSET_RETURNS_B

Line 661: FROM OKL_ASSET_RETURNS_B asr,

657: SELECT cle.cle_id finasst_id,
658: cim.object1_id1 asset_id,
659: cle_orig.cle_id orig_finasst_id,
660: asr.id asset_return_id
661: FROM OKL_ASSET_RETURNS_B asr,
662: OKC_K_LINES_B cle_orig,
663: OKC_LINE_STYLES_B lse_orig,
664: OKC_K_ITEMS cim_orig,
665: OKC_K_ITEMS cim,

Line 2184: --code added to update status in OKL_ASSET_RETURNS_B

2180: RAISE Okl_Api.G_EXCEPTION_ERROR;
2181: END IF;
2182:
2183: --Bug#2522439 Start
2184: --code added to update status in OKL_ASSET_RETURNS_B
2185: --after the release asset transaction has been processed
2186: OPEN l_asr_csr(p_chrv_id);
2187: LOOP
2188: FETCH l_asr_csr into l_asr_rec;

Line 2537: --code added to update status in OKL_ASSET_RETURNS_B

2533: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2534: RAISE Okl_Api.G_EXCEPTION_ERROR;
2535: END IF;
2536:
2537: --code added to update status in OKL_ASSET_RETURNS_B
2538: --after the release asset transaction has been processed
2539: OPEN l_asr_csr(p_chrv_id);
2540: LOOP
2541: FETCH l_asr_csr into l_asr_rec;