DBA Data[Home] [Help]

APPS.IEX_REP_PVT dependencies on OKL_ASSET_RETURNS_B

Line 688: Cursor l_art_csr(cp_art_id IN OKL_ASSET_RETURNS_B.ID%TYPE) IS

684: x_return_status OUT NOCOPY VARCHAR2,
685: p_repv_rec IN repv_rec_type) AS
686: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
687:
688: Cursor l_art_csr(cp_art_id IN OKL_ASSET_RETURNS_B.ID%TYPE) IS
689: SELECT id
690: FROM okl_asset_returns_b
691: WHERE id = cp_art_id;
692:

Line 690: FROM okl_asset_returns_b

686: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
687:
688: Cursor l_art_csr(cp_art_id IN OKL_ASSET_RETURNS_B.ID%TYPE) IS
689: SELECT id
690: FROM okl_asset_returns_b
691: WHERE id = cp_art_id;
692:
693: l_art_id OKL_ASSET_RETURNS_B.ID%TYPE;
694: BEGIN

Line 693: l_art_id OKL_ASSET_RETURNS_B.ID%TYPE;

689: SELECT id
690: FROM okl_asset_returns_b
691: WHERE id = cp_art_id;
692:
693: l_art_id OKL_ASSET_RETURNS_B.ID%TYPE;
694: BEGIN
695: IF NOT (p_repv_rec.art_id = OKL_API.G_MISS_NUM OR
696: p_repv_rec.art_id IS NULL)
697: THEN

Line 708: p_token3_value => 'OKL_ASSET_RETURNS_B');

704: p_token1_value => 'art_id',
705: p_token2 => G_CHILD_TABLE_TOKEN,
706: p_token2_value => 'IEX_REPOS_OBJECTS_V',
707: p_token3 => G_PARENT_TABLE_TOKEN,
708: p_token3_value => 'OKL_ASSET_RETURNS_B');
709: l_return_status := OKL_API.G_RET_STS_ERROR;
710: END IF;
711: CLOSE l_art_csr;
712: END IF;