APPS.IEX_REP_PVT dependencies on OKX_ASSET_LINES_V

Line 537: Cursor l_asset_csr(cp_asset_id IN OKX_ASSET_LINES_V.ASSET_ID%TYPE) IS

533: x_return_status OUT NOCOPY VARCHAR2,
534: p_repv_rec IN repv_rec_type) AS
535: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
536:
537: Cursor l_asset_csr(cp_asset_id IN OKX_ASSET_LINES_V.ASSET_ID%TYPE) IS
538: SELECT asset_id
539: --START jsanju 01/06/06 for bug 4932911
540: --change okx_assests_lines_v to okx_assests_v
541: --END jsanju 01/06/06 for bug 4932911

Line 546: l_asset_id OKX_ASSET_LINES_V.ASSET_ID%TYPE;

542:
543: FROM okx_assets_v
544: WHERE asset_id = cp_asset_id;
545:
546: l_asset_id OKX_ASSET_LINES_V.ASSET_ID%TYPE;
547: BEGIN
548: IF (p_repv_rec.asset_id = OKL_API.G_MISS_NUM OR
549: p_repv_rec.asset_id IS NULL)
550: THEN

Line 566: p_token3_value => 'OKX_ASSET_LINES_V');

562: p_token1_value => 'asset_id',
563: p_token2 => G_CHILD_TABLE_TOKEN,
564: p_token2_value => 'IEX_REPOS_OBJECTS_V',
565: p_token3 => G_PARENT_TABLE_TOKEN,
566: p_token3_value => 'OKX_ASSET_LINES_V');
567: l_return_status := OKL_API.G_RET_STS_ERROR;
568: END IF;
569: CLOSE l_asset_csr;
570: END IF;